Browsed by
Month: April 2010

DragInfo Version 1.004 sync with text file

DragInfo Version 1.004 sync with text file

Synchronizing with text file: DragInfo now supports synchronizing with a plaintext file.  Changes to the xml file will update the plaintext file and vice versa. Any snippets that exist in the xml file already or that you create will also be created within the text file. On the other hand, DragInfo ignores any info in the text file that does not match a tab title. Lets say you have you have a tab named “Dog”.  If a line is detected…

Read More Read More

How to combine/copy multiple workbooks into one workbook.

How to combine/copy multiple workbooks into one workbook.

A lab billing macro example Here is another useful macro for copying data from multiple workbooks into one workbook. At the end of the month billing needs a report with all the months charges listed. We have been creating a workbook daily with the day’s charges listed. Now we have to collate all those workbooks into one workbook. Again it’s a tedious process in need of automation.

Turn-Around-Time Excel macro

Turn-Around-Time Excel macro

Once again we have reports that the system has chucked out that need a lot of work.  In this example we are reporting the turn-around-times for a monthly report.  In this example, the Cerner Powervision app gives us a report on each tests’ TAT.  This report is exported to Excel and the user counts how many tests exceeded TAT, and calculates the percent meeting target TAT. TEDIOUS!  Excel macros to the rescue: Instead of making this into a full-blown tutorial…

Read More Read More