Tuesday, July 2, 2013

Remove unused serial ports under winxp


http://support.microsoft.com/kb/315539


To work around this behavior and display devices when you click Show hidden devices:
  1. Click Start, point to All Programs, point to Accessories, and then click Command Prompt.
  2. At a command prompt, type the following command , and then press ENTER:
    set devmgr_show_nonpresent_devices=1
  3. Type the following command a command prompt, and then press ENTER:
    start devmgmt.msc
  4. Troubleshoot the devices and drivers in Device Manager.

    NOTE: Click Show hidden devices on the View menu in Device Manager before you can see devices that are not connected to the computer.
  5. When you finish troubleshooting, close Device Manager.
  6. Type exit at the command prompt.

    Note that when you close the command prompt window, Window clears the devmgr_show_nonpresent_devices=1variable that you set in step 2 and prevents ghosted devices from being displayed when you click Show hidden devices.
If you are a developer or power user and you want to be able to view devices that are not connected to your computer, set this environment variable globally: 

To have us set the environment variable globally for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Tuesday, April 23, 2013

How to find out MSISDN and IMSI?


From: http://www.tomshardware.com/forum/33509-39-finding-msisdn-number


IMSI

MSISDN


> What are the currently used ways of finding the 'own' MSISDN?

The MSISDN can be stored on the SIM. It's often put there by
the network provider as the first entry in the "own numbers"
phonebook. But it does not need to be stored anywhere on the
phone or SIM, and does not need to be correct if it is stored
in the above manner.

Some phones allow users to read, edit or delete these "own
number" entries via the phonebook menu. And they can usually
be read over a serial interface with "AT+CNUM" command. 
Likewise they can be deleted and added with "AT+CPBW" after
first setting the phonebook to "own numbers" with the

AT+CPBS="ON"

command.

The only absolutely reliable DIY method of establishing your
MSISDN is to call someone and look at their calling number
display, or SMS someone and look at the sender's address.

John

if your sim provider is UFONE simply dial the code *2# and press the dial button it will show your MSISDN number.




One mechanism if you have access to terminal software and can send AT commands (see: http://bit.ly/cwkzA7) to your mobile device, the command: AT+CIMI will return the IMSI as long as the SIM is initialized (will not return IMSI if the SIM is locked). 

Wednesday, January 11, 2012

Apply Excel Conditional Formatting to a Row

[1] Contextures.com

Fill color of a row based on H column value. '$' means do things for a row
=$H12=100%
Do things for a cell
=H12=100%