Study Music 5 and 6 Released!

My gosh, the post title makes it seem like I’m some musician. Anyways, more soothing songs have been collected, packaged and uploaded! Check out the study music page.

Want to get a sense of the playlist before downloading the files? Check this out! (note: it does not have all of the study music song collection)

Random Excel Tip

If, for some reason, you’re working with an Excel spreadsheet and you need to copy/paste a formula that refers to different worksheets/rows and want to prevent having to manually go through each cell/worksheet, there’s an easy way.

Press CTRL + ~ to toggle code view, then highlight + copy the cells that you want to modify and paste it directly into Notepad. Do a Replace and replace accordingly (e.g. in the below example, replace “S1″ with “S2″). Then highlight everything + copy, then in Excel, paste it into the respective cells (Excel will be able to properly parse what you’re pasting since it’s tab-delimited). Then press CTRL + ~ to toggle code view to view your final results.

As shown below, for one of my assignments I had to create three tables that referred to various worksheets. My method was completing one row (e.g. Scenario 1, Simulation Run 1), then using the above method to modify it for Simulation Run 2 and so forth until the entire table was complete (replacing R1 with R2, for example). Then I used the above method (selecting the entire table this time and replacing S1 with S2, for example) and created the following two Scenario tables.

Excel Formula Example Excel Notepad Replace

(Norton) Antivirus Fail

I knew this was a virus, I was just curious to see if Norton (built into Yahoo) would catch the virus. Sadly, it met my expectations.

Fake Facebook Email Virus Detected

Get More Battery Life

Aerofoil is a small tool that detects whether or not your laptop is plugged in. If you unplug your laptop, it can automatically change your power plan (e.g. from “High Performance” to “Power Saver”), mute your sound, and also disable Aero (the nice effects) and the Sidebar. Once plugged in again, it will automatically unmute your sound and whatever else you chose to disable when unplugged.

I have Auto Mute and Auto Power Plan enabled, the rest are disabled. I’m not too sure if I like having Aero disabled automatically though; I’m going to leave this program running and see if it disrupts my routine (e.g. having my audio automatically unmuted when I plug my laptop in during class and have music blasting).

EDIT: I’m using BatteryCare now. Main thing I need is the automatic switching of power plans (High Performance when plugged in, Power Saver when I’m not.)

Custom Hash Algorithm

function sexify($salt, $password) {
return sha1(md5(md5($
password)+$salt)+sha1($password+sha1(md5($password+sha1($salt))+$salt))+$salt);
}

To use this, I just need to type: <?=sexify($salt, $password)?> (assuming the $salt and $password variables were set earlier). You can tell I had fun with the algorithm :)