week++

August 4th, 2007

I pretty much spent this week Excelling, or at least attempting to. I created a database of all of their teleconsultation records with macros that automatically generated useful summaries whenever it was updated with session attendance logs.

After the first day, I was impressed with how I picked up VBA so easily (I had learned some VB 6 back in high school). I had written code to separate parts of a single name, search the total attendance for duplicates, delete the repeats, and display unique names alongside counts and the dates attended. I later learned this was called a filter, and excel had this feature built in.

Two days later, the same thing happened again. Except this time, I had programmed a pivot table. Or actually like 6 different pivot tables. Oh well, at least I know how to program in VB again.

Entry Filed under: Uncategorized

2 Comments

  • 1. Sandeep  |  August 6th, 2007 at 4:10 pm

    Nice work dude. I kinda understand your womens grant now.
    Keep the posts coming, its a pretty good dictraction from work.

  • 2. Dhruv M  |  August 8th, 2007 at 6:14 pm

    you should totally use access databases to store this stuff if you don’t already. excel is really bad for storing a lot of data.


Calendar

August 2007
M T W T F S S
« Jul   Sep »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Recent Comments