My Newest Project - An Automated Timecard

Lookie This People - This is the cool sorta stuff you can do with Dynamics SL/Spitfire.

I'm going to create an automated time card using Excel and VBA.

We use HCSS Dispatcher to dispatch Equipment and Employees, and we use MS Project to create a project schedule. So the first thing this time card is going to do is to query the SQL Tables for both applications and create a time card for the day.

Then we're going to route this time card by e-mail using Spitfire to the job foremen.

After the foreman fills in the time card, then he'll send it back to Spitfire. Because of the power of routings in Spitfire, Spitfire will then send the time card to both the Operations Manager and the Project Manager for approval.

After the time card is approved, then we'll use some VBA code to automatically input the timecard information into Solomon for Payroll Processing.

The final bit of VBA Code will then create a daily cost report that details how the crew performed for that day, and whether or not they made money or lost money.

Finally Spitfire will send the Daily Cost Report to the Foreman, Project Manager, Operations Manager, and the Owner for review.

It's amazing how you can use Dynamics, Spitfire, and Office Automation to deliver reports almost instantaneously and automate data input.