The Official Forum  

Go Back   The Official Forum > Basketball

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
  #1 (permalink)  
Old Sat Mar 22, 2008, 02:41pm
Official Forum Member
 
Join Date: Feb 2007
Posts: 2,842
software to record your work

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.
Reply With Quote
  #2 (permalink)  
Old Sat Mar 22, 2008, 03:02pm
Official Forum Member
 
Join Date: Feb 2003
Location: Boston area
Posts: 615
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.
Reply With Quote
  #3 (permalink)  
Old Sat Mar 22, 2008, 03:03pm
certified Hot Mom tester
 
Join Date: Aug 1999
Location: only in my own mind, such as it is
Posts: 12,918
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.
__________________
Yom HaShoah
Reply With Quote
  #4 (permalink)  
Old Sun Mar 23, 2008, 01:27am
Official Forum Member
 
Join Date: Jan 2003
Location: In a little pink house
Posts: 5,289
Quote:
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):

__________________
"It is not enough to do your best; you must know what to do, and then do your best." - W. Edwards Deming
Reply With Quote
  #5 (permalink)  
Old Sun Mar 23, 2008, 08:31am
Esteemed Forum Member
 
Join Date: Aug 2005
Location: Connecticut
Posts: 22,934
Modern Communcication ...

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:

Reply With Quote
  #6 (permalink)  
Old Sun Mar 23, 2008, 08:44am
Administrator
 
Join Date: Sep 1999
Location: Toledo, Ohio, U.S.A.
Posts: 8,044
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.
__________________
Mark T. DeNucci, Sr.
Trumbull Co. (Warren, Ohio) Bkb. Off. Assn.
Wood Co. (Bowling Green, Ohio) Bkb. Off. Assn.
Ohio Assn. of Basketball Officials
International Assn. of Approved Bkb. Officials
Ohio High School Athletic Association
Toledo, Ohio
Reply With Quote
  #7 (permalink)  
Old Sun Mar 23, 2008, 10:41am
Official Forum Member
 
Join Date: Feb 2007
Posts: 2,842
Quote:
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.
Reply With Quote
  #8 (permalink)  
Old Sun Mar 23, 2008, 12:05pm
Official Forum Member
 
Join Date: Dec 2007
Location: Bay Area, CA
Posts: 208
Excel

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.
Reply With Quote
  #9 (permalink)  
Old Sun Mar 23, 2008, 12:29pm
9/11 - Never Forget
 
Join Date: Jan 2007
Location: Northern Virginia
Posts: 5,642
Send a message via Yahoo to 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.
__________________
There was the person who sent ten puns to friends, with the hope that at least one of the puns would make them laugh. No pun in ten did.
Reply With Quote
  #10 (permalink)  
Old Mon Mar 24, 2008, 08:02am
Official Forum Member
 
Join Date: Nov 2004
Posts: 1,673
Send a message via MSN to IREFU2 Send a message via Yahoo to IREFU2
Quote:
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!!!!
__________________
Score the Basket!!!!
Reply With Quote
  #11 (permalink)  
Old Mon Mar 24, 2008, 08:37am
Official Forum Member
 
Join Date: Oct 2005
Location: Midlothian, VA
Posts: 671
Quote:
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.
__________________
THE FLY IS OPEN, LET'S GO PEAY
Reply With Quote
  #12 (permalink)  
Old Mon Mar 24, 2008, 11:41am
certified Hot Mom tester
 
Join Date: Aug 1999
Location: only in my own mind, such as it is
Posts: 12,918
Quote:
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.

__________________
Yom HaShoah
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New Record: Dec 22 rainmaker Basketball 20 Tue Dec 27, 2005 11:58am
Officials Record Keeper software? OverAndBack Football 6 Tue Aug 23, 2005 11:54am
I may have T record! thumpferee Basketball 27 Fri Jan 14, 2005 11:01pm
New record for me Kelvin green Basketball 2 Fri Dec 17, 2004 01:36pm
How Do You Work With A Partner Who Is Very Difficult To Work With? Love2ref4Ever Basketball 22 Sat Apr 28, 2001 05:06pm


All times are GMT -5. The time now is 10:14am.



Search Engine Friendly URLs by vBSEO 3.3.0 RC1