Browsed by
Author: ericains

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.

SynapSonic Software

SynapSonic Software

SynapSonic Software produces software for medical laboratory and general use: Along with commercial software I have also written a few other programs. Download these Free, useful SynapSonic utilities here! Ol Monitor is a turn-around-time management and acceleration tool for labs using the Sunquest lab information system.  OL_Monitor is a program that interacts with the Sunquest™ (Formerly Misys™) Laboratory information system. OL_Monitor integrates seamlessly with Esker™ Smarterm, the client of choice for most laboratories. Like a tireless unblinking eye, it keeps…

Read More Read More

Lab Jokes – Q&A

Lab Jokes – Q&A

Medical Lab Jokes – Q&A Q: What type of red cell will be observed on the peripheral smear if blood was refrigerated prior to making the smear? A: A brrrr cell.  -Credit: (I’ve known this one so long I may have made it up myself.)

Medical Lab Jokes – You know you’ve been in the lab too long when..

Medical Lab Jokes – You know you’ve been in the lab too long when..

You know you’ve been in the lab too long when: You wonder what absolute alcohol tastes like with orange juice You can’t watch CSI without cursing at least one scientific inaccuracy You use acronyms for everything and never stop to elaborate You always seem to use the microscope after the person with the impossibly close together eyes

Sneak peek at new OL Monitor 3x

Sneak peek at new OL Monitor 3x

Here is a screenshot of the new OL Monitor I have been working on. (click for a larger view) (Don’t be overwhelmed by the eye popping colors and multiple dates/times, this is for demonstration only and date fields can be converted to other formats or hidden individually.) Among the features in the works: Read test data from various data sources. Control over background and foreground coloring. Filters and TAT’s now unified under ‘Rules’ Change look with ‘Skins’ Multiple tabs Elegant,…

Read More Read More

List of extremely useful software

List of extremely useful software

First a few sites where you can search for shareware.  I like to read reviews about what I’m trying so I like the following shareware sites: CNET or Downloads.com : Decent editorial reviews but I’ve seen some reviews that were entirely off the mark here. Snapfiles : Lots of ads but also aggregates user reviews. Tucows : Older well known site with reviews. LifeHacker : Along with everything else he reviews software. Good straightforward reviews of unique apps. [ad name=”Synap…

Read More Read More