Execl formula - General Questions and Answers

Hello, I need an excel formula to allow me to enter the specific name the search on it to provide a true or false result. I tried using the IF formula to say IF B2 = name, "Correct Name", "Incorrect Name".
Thanks

Related

How do you sort contact list using FIRST NAME first?

Currently it defaults to sorting by last name first. This screws up most of the listings in my phone book as I always had them sorted by first name first on all my other phones.
I tried in settings, there is no options So I am wondering is there a registry edit I could do to sort by first name first?
Thanks
-Attila
Not sure if this will work on your device, but source code is available and the idea should be universal.
http://forum.xda-developers.com/vie...postdays=0&postorder=asc&highlight=first+name
V
vijay555 said:
Not sure if this will work on your device, but source code is available and the idea should be universal.
http://forum.xda-developers.com/vie...postdays=0&postorder=asc&highlight=first+name
V
Click to expand...
Click to collapse
Thanks, but the software doesn't work on my device
I am using Outlook 2003 and QTEK 8310/I-mate SP5.
Below is a solution that I found online that does work for my configuration.
For outlook 2003 I found a solution on how to re-sort by FIRST, LAST for tornado (SP5/QTEK 8310)
----
On the File menu, point to New, and then click Mail Message to
open a new e-mail message.
2. On the Tools menu of the new e-mail message, point to Forms, and
then click Design This Form.
3. Insert five Command buttons on the new form. To do this:a. Click
the (P.2) tab to go to a blank page on the form.
b. On the Form menu, click Control Toolbox, click CommandButton, and
then drag the button to the blank form page.
c. Right-click the new button, click Properties, and then type
cmdLastFirst in the Name box.
d. In the Caption box, type Last, First, and then click OK.
e. In the Toolbox dialog box, click CommandButton, and then drag a
second button to the blank form page.
f. Right-click the new button, click Properties, and then type
cmdFirstLast in the Name box.
g. In the Caption box, type First Last, and then click OK.
h. In the Toolbox dialog box, click CommandButton, and then drag a
third button to the blank form page.
i. Right-click the new button, click Properties, and then type
cmdCompany in the Name box.
j. In the Caption box, type Company, and then click OK.
k. In the Toolbox dialog box, click CommandButton, and then drag a
fourth button to the blank form page.
l. Right-click the new button, click Properties, and then type
cmdLastFirstCompany in the Name box.
m. In the Caption box, type Last, First (Company), and then click OK.
n. In the Toolbox dialog box, click CommandButton, and then drag a
fifth button to the blank form page.
o. Right-click the new button, click Properties, and then type
cmdCompanyLastFirst in the Name box.
p. In the Caption box, type Company (Last, First), and then click OK.
4. Type the following Visual Basic Scripting Edition (VBScript) code.
To do this:a. On the Form menu, click View Code to open the Script
Editor.
b. In the Script Editor, type or copy the following code:Option
Explicit
Dim strSortBy
Sub cmdLastFirst_Click()
strSortBy = "LastFirst"
UpdateContacts
End Sub
Sub cmdFirstLast_Click()
strSortBy = "FirstLast"
UpdateContacts
End Sub
Sub cmdCompany_Click()
strSortBy = "Company"
UpdateContacts
End Sub
Sub cmdLastFirstCompany_Click()
strSortBy = "Last, First (Company)"
UpdateContacts
End Sub
Sub cmdCompanyLastFirst_Click()
strSortBy = "Company (Last, First)"
UpdateContacts
End Sub
Sub UpdateContacts()
Dim CurFolder
Dim MyItems
Dim MyItem
Dim NumItems, i
' Use whichever folder is currently selected
Set CurFolder = Application.ActiveExplorer.CurrentFolder
' Make sure it's a contact folder
If CurFolder.DefaultItemType = 2 Then
MsgBox "This process may take some time. You will be " & _
"notified when complete.", , "Contact Tools Message"
Set MyItems = CurFolder.Items
NumItems = MyItems.Count
For i = 1 to NumItems
Set MyItem = MyItems.Item(i)
' Make sure it's not a distribution list in the folder
' (really only applies to OL98 and OL2000)
If TypeName(MyItem) = "ContactItem" Then
Select Case strSortBy
Case "LastFirst"
If MyItem.LastNameandFirstName <> "" Then
MyItem.FileAs = MyItem.LastNameandFirstName
Else
MyItem.FileAs = MyItem.CompanyName
End IF
Case "FirstLast"
If MyItem.Subject <> "" Then
MyItem.FileAs = MyItem.Subject
Else
MyItem.FileAs = MyItem.CompanyName
End IF
Case "Company"
If MyItem.CompanyName <> "" Then
MyItem.FileAs = MyItem.CompanyName
Else
MyItem.FileAs = MyItem.LastNameandFirstName
End IF
Case "Last, First (Company)"
MyItem.FileAs = MyItem.LastNameAndFirstName
If MyItem.CompanyName <> "" Then
If MyItem.FileAs <> "" Then
MyItem.FileAs = MyItem.FileAs & " (" & _
MyItem.CompanyName & ")"
Else
MyItem.FileAs = MyItem.FileAs & _
MyItem.CompanyName
End If
End If
Case "Company (Last, First)"
MyItem.FileAs = MyItem.CompanyName
If MyItem.LastNameandFirstName <> "" Then
If MyItem.FileAs <> "" Then
MyItem.FileAs = MyItem.FileAs & " (" & _
MyItem.LastNameAndFirstName & ")"
Else
MyItem.FileAs = MyItem.FileAs & _
MyItem.LastNameAndFirstName
End If
End If
End Select
MyItem.Save
End If ' check TypeName
Next
MsgBox "Finished updating contacts."
Else
MsgBox "The current folder must be a contacts folder."
End If ' check contacts folder
Set MyItem = Nothing
Set MyItems = Nothing
Set CurFolder = Nothing
End Sub
c. On the File menu in Script Editor, click Close to return to the
form.
d. Click the Message page of the form.
e. On the Form menu, click Display This Page. This hides the form
page so that it does not appear when the form is used.
5. Publish the form. To do this:a. On the Tools menu, point to Forms,
and then click Publish Form As.
b. Verify that next to the Look in button you see Personal Forms
Library.
c. In the Display name box, type a discriptive name for your new form
(such as, Change File As fields), and then click Publish.
d. When you are prompted to save the form definition with the item,
click No.
e. Close the message without saving it.
Back to the top
How to Use the Custom Form
To use your new form: 1. Locate the Contact folder that you want to
re-sequence.
2. On the File menu, point to New, and then click Choose Form.
3. Change the Look in box to Personal Forms Library, click your new
form, and then click OK.
4. Click the appropriate button to update the File As field.

Making new non-ascii keyboard layout

Hello there.
According to this description:
http://www.kandroid.org/android_pdk/keymaps_keyboard_input.html
I am trying to create new layout with cyrillic characters (so i want to kind of introduce localization for input).
In order to do this I am changing some lines in file
./development/emulator/keymaps/qwerty.kcm
from:
Code:
[type=QWERTY]
# keycode display number base caps fn caps_fn
A 'A' '2' 'a' 'A' '#' 0x00
B 'B' '2' 'b' 'B' '<' 0x00
.....
to
Code:
[type=QWERTY]
# keycode display number base caps fn caps_fn
A 'A' '2' 'a' 'A' '#' 0x00
B 'Б' '2' 'б' 'Б' '<' 0x00
.....
which are supposed to be russian characters.
But compiling this yields in:
Code:
KeyCharMap: out/target/product/generic/obj/KEYCHARS/qwerty.kcm_intermediates/qwerty.kcm.bin
development/emulator/keymaps/qwerty.kcm:5: expected number or quoted ascii but got: 'а'
So it is seems like it does not like utf-8 characters. So, how am I supposed to create non-ascii layout?
You need to use UTF8 chars in quotation marks = "Б", try it again and pls post a file if you succeded
the same stuff:
Code:
[B][[email protected] bin]$ make[/B]
build/core/product_config.mk:229: WARNING: adding test OTA key
build/core/main.mk:177: implicitly installing apns-conf_sdk.xml
============================================
TARGET_PRODUCT=generic
TARGET_SIMULATOR=
TARGET_BUILD_TYPE=release
TARGET_ARCH=arm
TARGET_OS=linux
HOST_ARCH=x86
HOST_OS=linux
HOST_BUILD_TYPE=release
BUILD_ID=TC3
============================================
KeyCharMap: out/target/product/generic/obj/KEYCHARS/qwerty.kcm_intermediates/qwerty.kcm.bin
development/emulator/keymaps/qwerty.kcm:6: expected number or quoted ascii but got: "Б"
make: *** [out/target/product/generic/obj/KEYCHARS/qwerty.kcm_intermediates/qwerty.kcm.bin] Error 1
[B][[email protected] bin]$ cat development/emulator/keymaps/qwerty.kcm[/B]
[type=QWERTY]
# keycode display number base caps fn caps_fn
A 'A' '2' 'a' 'A' '#' 0x00
B "Б" '2' "б" "Б" '<' 0x00
......
you might try the numeric value for the characters instead. I'm not sure if that would work or not. I don't have much experience with non-US character sets
so, this is the file, which perform checking:
./build/tools/kcm/kcm.cpp:
the piece of code is:
Code:
static int
parse_number(const char* filename, int lineno, char* str, int* value)
{
int len = strlen(str);
if (len == 3 && str[0] == '\'' && str[2] == '\'') {
if (str[1] > 0 && str[1] < 127) {
*value = (int)str[1];
return 0;
} else {
fprintf(stderr, "%s:%d: only low ascii characters are allowed in"
" quotes near: %s\n", filename, lineno, str);
return 1;
}
}
char* endptr;
*value = strtol(str, &endptr, 0);
if (*endptr != '\0') {
fprintf(stderr, "%s:%d: expected number or quoted ascii but got: %s\n",
filename, lineno, str);
return 1;
}
if (*value >= 0xfffe || *value < 0) {
fprintf(stderr, "%s:%d: unicode char out of range (no negatives, "
"nothing larger than 0xfffe): %s\n", filename, lineno, str);
return 1;
}
return 0;
}
Anyone can say, how the charset should be formatted in order to pass this?
Ок, I found out.
Just change 'a' to 0xNNNN (with no qoutes around).
I've tested cyrillic layout with emulator -- it works fine.
Does anybody with root access what to try it on G1 ?
I'll provide you with layout file and instructions.
I am really interesting in trying this! Have rooted G1.
I've already tried, it works!
No I am trying to understand, how to write a simple utility, which will copy files back and forth in order to change layout.
http://forum.xda-developers.com/showthread.php?t=466705
please help - i wanna do this for hebrew chars
can u give me a quick run through of what you did to get this done and a more detaild explanation on how you overcome the unicode char failing in the file?
plus - if i understand correctly - you do not have english anymore on your keyboard - or is there something that allowes you to switch between langauges somehow (an android alt-shift or whatever?)
thanks,
E.
--
Peace
eladkatz said:
can u give me a quick run through of what you did to get this done and a more detaild explanation on how you overcome the unicode char failing in the file?
plus - if i understand correctly - you do not have english anymore on your keyboard - or is there something that allowes you to switch between langauges somehow (an android alt-shift or whatever?)
thanks,
E.
--
Peace
Click to expand...
Click to collapse
attached is the example of file with unicode chars
the only way to changes layouts i can see -- is to copy layout files back and forth
So, it actually does work, I wrote a simple app which changes key layout files as soon as you lunch it. It is kind of software layout switcher.
Main problem now: android seems to have some buffer, so layout does not change as soon as you replace a file. It take some random time or chars to input before changes applies.
So I am wondering if somebody knows how to force android to reload charmap?
Another thing that might help, if I can find out which process opens charmap file, it could really help. Unfortunately neither android nor busybox does not have lsof command.
more info:
I have noticed, that app reload the layout file the same time as garbage collector runs for this app. I don't know for sure, where GC initiate layout reloading or they both are initiated by some superior event.
I keep digging android sources, if anyone have any ideas I'll be glad to consider 'em.
keep us posted
dude, what you are doing is very interesting, and i'd aprreciate it if you could keep updating.
Thanks,
E.
i have a adp1, but i can´t put the file on my g1?
can someone please tell me how to do, or why don´t i have root acess?
thanks
eladkatz said:
dude, what you are doing is very interesting, and i'd aprreciate it if you could keep updating.
Thanks,
E.
Click to expand...
Click to collapse
2nd that! Appreciate your work, Worry. Thanx!
Can this be done for Bulgarian layout? I am searching something like this for a long time...
worry said:
I wrote a simple app which changes key layout files as soon as you lunch it.
Click to expand...
Click to collapse
Have you figured out how to access android filesystem from the Java app?
hello!file attached above was only src,need to be makekcharmap-ed,yes?can u plz put here compiled version because at this time don't have an ability 2 use computer and sdk to compile myself!thanks!!!
I have a question :
How to mod the input method ?
For an example : with input method, when I type double "A" it will become "Â", and it will back to "A" if I type triple "A".
(We use qwerty keyboard and input method controller to type our language, we don't have own keyboard as Rusian, Japan ...)
Really good job! Thanks!
Please, keep updating!

sqlite SQLiteStatement please help with extending my INSERT statement

HI,
I am new to android and I am experimenting with sqlite. I would like
to extend my SQL insert statement so I can insert into more than one
row.
I have extended my table as follows including a column called actor
db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY,
name TEXT, actor TEXT");
I am using SQLiteStatement and would like to extend the insert to
include actors along with names
private static final String TABLE_NAME = "testtable ";
private SQLiteStatement insertStmt;
private static final String INSERT = "insert into "
+ TABLE_NAME + "(name) values (?)"; <----------------where is
name coming from ?????
This is my insert function, but how can I call it and execute an
INSERT to include the column actor
public long insert(String name) {
this.insertStmt.bindString(1, name);
return this.insertStmt.executeInsert();
}
call to use insert
this.dh.insert("Inception");
I would like to change this to
this.dh.insert("Inception", "Leo");
Thank you
Graham

SamsungResgistry - noob question!

How to edit regestry values with the SamsungRegestry app?
It has "Path to value" field where I type in the path
HKEY_LOCAL_MACHINE\Audio\StreamClass\Output\10
And the second field "Value (Read/Write)"
"ClassGain"=dword:0
Then I can choose if it should be a Dword or a string.
What am i doing wrong case this is not the right way :-(

[Q] In need of dslreports trunk outtage saving script (pbxes)

Hello,
If anyone has the dslreports.com script for:
Saving a random setting on Pbxes.org when there's a trunk outage notification (free account) ,
I would highly appreciate it.
The above website is unavailable currently and am in need of the script so I can use my GV + Callback + Sipdroid. For reference, it was a simple (either JS or VB) script which saved a random setting whenever there was a trunk outage.
Or if there are any other suggestions for someone to route calls pretty much the same way for android 1.6 I would highly appreciate it as well.
Thank you
Also, a new question,
would anyone happen to know if at this date 4/23/12, Verizon charges or back charges people for using Google voice + callback for free calls as well?
thank you for any help
edited in question
..
I created this vbscript a few years ago for the same reason. Works well. I have it set up as a Rule in Outlook, so whenever I get a trunk outage email from PBXes, it runs this script automatically.
dslreports.com/forum/r24908015-PBXes-free-acount-trunk-outtage-quick-fix
I've pasted the script here just in case the dsl reports post gets removed:
Code:
'###########################################
'## PBXes Trunk Outtage Recovery
'## for Free Users
'##
'## Author: atomicrabbit ([email protected])
'## Date: 2010.10.08
'###########################################
'Edit the following variables appropriately
'------- START EDITING HERE ... DO NOT TOUCH ANYTHING BELOW -------
'Setting Page
' Set this to one of the settigs pages of PBXes
pbxes_settingPage = "https://www4.pbxes.com/config.php?display=extensions&extdisplay=100"
'Form Name
' Set this to the form name on the settings page specified above.
' It MUST be relative to the form on the page specified above
pbxes_formName = "addNew"
'PBXes Login Info
pbxes_username = "your_username" 'Your PBXes.com username
pbxes_password = "your_password" 'Your PBXes.com passowrd
'IE Window Visibility
' True - IE window will be visible while processing the code
' False - IE window will be hidden and run the code in the background
pbxes_windowVisible = False
'Browser Timeout
' Set max timeout for browser responsiveness (in seconds)
' Default: 7
pbxes_timeout = 7
'------- STOP EDITING HERE ... DO NOT TOUCH ANYTHING BELOW -------
pbxes_applySettings = pbxes_settingPage + "&clk_reload=true"
pbxes_timeout = pbxes_timeout * 5 'because the iterations are 200ms
pbxes_tCount = 1
'Create IE object
Set objIE = CreateObject("InternetExplorer.Application")
set WshShell = WScript.CreateObject("WScript.Shell")
'Go to PBXes.com Extensions page
objIE.Navigate pbxes_settingPage
objIE.Visible = pbxes_windowVisible
Wscript.Sleep 1000
'Check if not logged in
if not objIE.Document.Forms("login") is nothing then
' Login to PBXes if you're not already
objIE.Document.All.Item("username").Value = pbxes_username
objIE.Document.All.Item("password").Value = pbxes_password
objIE.Document.All.Item("remember").checked = "false"
objIE.Document.All.Item("btnSubmit").click
Wscript.Sleep 2000
'Go to settings page
objIE.Navigate pbxes_settingPage
'Wait for page to load
Do
Wscript.Sleep 200
pbxes_tCount = pbxes_tCount + 1
Loop While objIE.Document.Forms(pbxes_formName) is nothing AND pbxes_tCount < pbxes_timeout
end if
if pbxes_tCount >= pbxes_timeout AND objIE.Document.Forms(pbxes_formName) is nothing Then
MsgBox "Browser timeout. Try running thescript again.", vbOkOnly, "PBXes Trunk Outtage"
'exit script
Elseif not objIE.Document.Forms(pbxes_formName) is nothing Then
'Submit form
call objIE.Document.Forms(pbxes_formName).elements("Submit").click
Wscript.Sleep 2000
'Apply the changes (red bar at top)
objIE.Navigate pbxes_applySettings
Wscript.Sleep 2000
'Close IE
objIE.Quit
MsgBox "Recovered from trunk outtage!", vbOkOnly, "PBXes Trunk Outtage"
Else
MsgBox "Could not find '" & pbxes_formName & "' form on '" & pbxes_settingPage & "'.", vbOkOnly, "PBXes Trunk Outtage"
'exit script
End if
'Clear variables
Set objIE = Nothing
Set pbxes_settingPage = Nothing
Set pbxes_applySettings = Nothing
Set pbxes_username = Nothing
Set pbxes_password = Nothing
Set pbxes_windowVisible = Nothing
Set pbxes_timeout= Nothing
Set pbxes_tCount= Nothing
Wscript.quit
I actually found the script before this but still Thank You for the script as it's been helpful, although I don't know why I seem to receive "false outtage" e-mails in the sense that calls still seem to be routed with not much interruption if any, what's with that?
Thank you!!

Categories

Resources