Browsed by
Month: November 2009

Excel Macro Tutorial 4 – Delete non-chargeable tests and sort.

Excel Macro Tutorial 4 – Delete non-chargeable tests and sort.

The billing report has a bunch of tests with at cpt code of ‘0’ or a blank.  These are non-chargeable tests.  We used to have to delete them manually. For this we can loop through the rows and delete non-chargeables just like we did with the junk removal.  For efficiency we could just add this code to the junk-removal macro, but I have kept them separate here for the sake of simplicity. I called the macro ‘DeleteZero’ and copied and…

Read More Read More

Excel Macro Tutorial 3 – Remove header rows and delete junk loop

Excel Macro Tutorial 3 – Remove header rows and delete junk loop

Ok now we’re getting into a bit more advanced material.  We’re going to have the macro do some real grunt-work for us.  Here’s what we want it to do: 1. Find the last row of the report. 2. Go through the entire report, row by row, and delete anything that we don’t want. The report has a bunch of junk we need to delete: Simple enough, the only problem is you can’t just record yourself going through the report deleting…

Read More Read More

Excel Macro Tutorial 1 – Open a text file

Excel Macro Tutorial 1 – Open a text file

In this 6-part series of tutorials, I show you how I was able to automate a process that took 5-10 minutes per report.  Now the process takes about 30 seconds.  The techniques and code examples from these tutorials can be adapted and used by anyone who has the misfortune of being delegated to do tedious gruntwork in Excel.  Many concepts like ‘how to record a macro in Excel’ are NOT covered in this tutorial.  There are plenty of tutorials on…

Read More Read More

Lab Jokes – You know your instrument is a piece of junk when…

Lab Jokes – You know your instrument is a piece of junk when…

You Know your instrument is a piece of junk when… 1. You know the service guy on a first-name basis and have even considered inviting him over for beers sometime. 2. You know the serial number of your instrument by heart from reciting it to tech support so many times. 3. You have actually physically assaulted the instrument while no one was looking. 4. Everyone knows you physically assault the instrument but they never tell anyone about it.