Jimazing Hacks

 If I have a list of items and I want to find out which of them are duplicates, I can use the following formula in another column.  Say the values are in column A… in column B, row 1, I would use this formula:

 =IF(COUNTIF(A:A,A1)>1,”duplicate”, “unique”)

The COUNTIF counts every match of the value in cell A1 with every cell in column A.  The IF condition is whether the results of COUNTIF are greater than 1.  If it is, the cell has duplicate values in the column.

Thanks Will!

The Problem

I just installed your 1 Bit Audio Player on my Wordpress Blog. I really like the way it works. The little icon is so unobtrusive and I didn’t have to do any change to my code. Well done! I am unfortunately having trouble in that it plays back slower and in a lower musical pitch than the original. Any idea what is causing that? Can it be fixed?

The Reason

Flash only supports sample rates that are a multiple of 44.1kHz (ie, 96000, 44100, 22050 and 11025 samples/second). It’s a bit annoying, but unfortunately it’s a limitation of Flash. So to fix it you’d have to use MP3s at one of those sample rates… hope that helps! www.markwheeler.net

The Solution

Go to RareWares and download the Lame Bundle

Your command line parameters would be something like this:

> lame –resample 44.1 mysong.mp3

If you have several files, dBpowerAMP would definitely make it easier, and you could use the above parameters with the mp3 Lame CLI plugin.

Thanks to:

•  www.markwheeler.net
• RareWares http://www.rarewares.org
• Hydrogenaudio Forums http://www.hydrogenaudio.org/forums/lofiversion/index.php/t38029.html

Does anybody know a dos command that will move a list of directories from one drive to another?

for /d %f in (whatever.*) do move %f destination

Problem

I couldn’t get windows to synchronize with the time server. I have a Windows Mobile based phone and the time was wrong. In fact, I got was late for a meeting because of this. Argh! I double clicked the clock on my taskbar and beheld the error glaring at me. “An error occured while Windows was synchronizing with time.nist.gov.”

Date and Time Properties window

I tried changing to the time.windows.com server, but got the same error. After much searching and attempting one thing after another, I finally stumbled upon a fix that worked for me. It is possible to add new servers to that list of Internet time servers. To do so requires a trip to the registry. Modify this hive of the registry:

[My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\DateTime\Servers]

You will see a numbered list of servers. These servers match the DropDown Server selection list on the Internet Time tab in the Date and Time Properties window.

Add a new StringValue

Set its “Name” to the next consecutive number. If the list contains 1 and 2, make this “3″.

Double click the new String Value you just created. This opens a window where you can set its value. Set it to “time-a.nist.gov”. Click Ok.

If the Date and Time Properties window is opened, then close it

Reopen the Date and Time Properties window (double click the clock on your taskbar).

Click the dropdown Server selection and choose the new value.
Vent

The designers of Window Mobile cell phones apparently had to choose whether to update the time like a cell phone does or like a PDA does. A cell phone automagically gets its time from the cell wherever it is. A PDA gets its time when it synchronizes with a PC. Apparently they chose the latter which I find to be completely irritating. What if I am away from my PC for days? The time drifts as computer clocks are prone to do and before you know it, my super duper phone has the wrong time. I find this very irritating and very unintuitive. I would love to hear who made that decision and why they came to that conclusion.

Thanks to

• http://channel9.msdn.com/ShowPost.aspx?PageIndex=3&PostID=314627
• http://www.pctools.com/guides/registry/detail/934/
• A long list of time servers provided by the NTP (Network Time Protocol) Public Services Project `: http://support.ntp.org/bin/view/Servers/StratumTwoTimeServers