software to record your work

[fullor30]

Just came across a software ad in Officials Quarterly that is designed to track your games worked. I checked it out and it doesn't seem that much better than an excel spread sheet that I try and keep current. Are there any other programs out there? Any ideas on maintaining good records for games worked?

The tax write-off thread got me thinking.

[BayStateRef]

I use Excel -- and have modified the spreadsheet through the years. I have columns for day, date, time, home & visiting team, date assigned, date changed, partner, miles, fee, date paid and "notes."

If a game is canceled, I do not delete, but cross it out.

I just got my last high school game check today. Game was played Feb. 5.

It has all the information I need and takes seconds to keep up to date.

[Mark Padgett]

I record all my information on a piece of parchment with a quill pen. I use an abacus to calculate the totals for my taxes each year, which I send in by pony express. That's as technological as I get.

[Back In The Saddle]

Originally Posted by Mark Padgett

I record all my information on a piece of parchment with a quill pen. I use an abacus to calculate the totals for my taxes each year, which I send in by pony express. That's as technological as I get.

Here's how Padgett notifies his assigner of a last minute cancellation (note the hand-quilled note of apology attached to the arrow):

[BillyMac]

Here's a photo of Padgett's new assigner, his previous assigner died in an odd bow and arrow accident, getting a turnback message from Padgett:

[Mark T. DeNucci, Sr.]

I use the calendar in Microsoft Outlook as my diary. I can record the who (my partner(s), and teams), when, where, what (odometer readings, game fee, meals,, toll roads, parking, laundry, uniform costs, registration fees, membership dues, etc.). Bonnie Jean, my lovely wife of 25 years, developed an Excel spread sheet based on the IRS's Schedule C; all I have to do is it the add button at the end of the year, and I am ready to fill out my Schedule C.

MTD, Sr.

[fullor30]

Originally Posted by Mark T. DeNucci, Sr.

I use the calendar in Microsoft Outlook as my diary. I can record the who (my partner(s), and teams), when, where, what (odometer readings, game fee, meals,, toll roads, parking, laundry, uniform costs, registration fees, membership dues, etc.). Bonnie Jean, my lovely wife of 25 years, developed an Excel spread sheet based on the IRS's Schedule C; all I have to do is it the add button at the end of the year, and I am ready to fill out my Schedule C.

MTD, Sr.

Sigh...........sounds neat and tidy. Next year I hope to do the same.

[ca_rumperee]

Best thing about excel (if you're a dork) is lookup functions.

I put the mileage from my house to the various locations and have excel look up the distance, and calc the mileage deduction at 50.5 cents.

Also have it look up the pay rate for the game or game combo (HS Fr/JV, HS Fr)

Excel for me.

[grunewar]

I also use Excel to record the information needed and to do all the automatic calculations on mileage, etc. needed for taxes.

I don't bother recording partners, teams, $ paid/game, etc., as I just print that out from Arbiter.

[IREFU2]

Originally Posted by grunewar

I also use Excel to record the information needed and to do all the automatic calculations on mileage, etc. needed for taxes.

I don't bother recording partners, teams, $ paid/game, etc., as I just print that out from Arbiter.

Our board now sends schedules in email in an excel format. I use my outlook Calendar as well. We also get a hard copy of the games we did when we get paid. Darn....so much paper!!!!

[Lcubed48]

Originally Posted by grunewar

I also use Excel to record the information needed and to do all the automatic calculations on mileage, etc. needed for taxes.

I don't bother recording partners, teams, $ paid/game, etc., as I just print that out from Arbiter.

I do the same. I use Excel to track expenses and mileage. I, then, get everything else off of the Arbiter. Yes, the Arbiter does provide a mileage. However, it is number from zip code to zip code so I measure the actual distance using my vehicle.

[Mark Padgett]

Originally Posted by BillyMac

Here's a photo of Padgett's new assigner, his previous assigner died in an odd bow and arrow accident, getting a turnback message from Padgett:

Here's my old assigner. The shield was for protection from coaches. The sword was for dealing with unruly coaches.