Tuesday, March 9, 2010

converting (transposing) alphabets to numbers in Microsoft Excel

To convert alphabets to numbers, Microsoft Excel contains the "code" function that converts an alphabet to it's ASCII value.

The "char" function converts it back.

To transpose it, convert the alphabet, add/subtract the transpose formula, and convert it back to a number.

A1 (basic alphabet): A
A2 (drop 2 grades): 2
A2: = char(code(A1)-2)

ps. To credit the source, I actually found the information from Yahoo! Answers, but my preferred method isn't the preferred. After having register, fill in a few pages of information, only to find out I'm not qualified to give a "Thumbs Up" to what I felt was the better solution, I gave up and decided to post it here instead.

Monday, March 8, 2010

Eliminating audio background hissing on Fujitsu Lifebook S6410 on Windows 7 64-bit audio passthrough

I routinely plug my TV/radio into the mic-in jack of my notebook, and listen to it through the headphone jack, so that I can watch TV and listen to the audio-alerts or youtube from my PC concurrently.

Having recently updated my OS to Windows 7 64-bit, and using the default audio drivers that came with it, I was pleasantly surprised that (other than enabling the volume from the mic) no particular configuration was necessary to enable audio pass-through.

However, I soon realized that there was a consistent hissing sound. Initially reluctant to install 3rd-party drivers into what has been a vanilla and generally very stable Windows 7, the hissing eventually irritated me enough to take the plunge and install the generic Realtek High Definition Audio drivers (in this case the R243 version).

The 50+ Mb Realtek executable file installed perfectly, silently removing the Microsoft drivers and prompted a reboot. Upon reboot, I opened Control Panel -> Hardware and Sound -> Realtek HD Audio Manager, and enabled "Playback Volume" for the microphone.

Viola! The hissing was totally gone, audio passthough works without a hitch.