Nasgaweb Homepage
Forum Home Forum Home » Nasgaweb Forums » A.D.
  New Posts New Posts RSS Feed - AD Excel Spreadsheets
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Database

scottishheavyphotographs.com Old Celt Equipment

AD Excel Spreadsheets

 Post Reply Post Reply
Author
Message
McSanta View Drop Down
Postaholic
Postaholic
Avatar

Joined: 4/12/05
Location: United States
Status: Offline
Points: 1595
Post Options Post Options   Thanks (0) Thanks(0)   Quote McSanta Quote  Post ReplyReply Direct Link To This Post Topic: AD Excel Spreadsheets
    Posted: 5/15/08 at 1:04pm

For what it is worth:  Three out of four excel spreadsheets I use to accomplish the AD task are now up on a web-page.  They are there for any to uses and abuse or even laugh at how the number geek works. 

They can be found at: IowaHighlandGames.googlepages.com/adspreadsheets

and the spreadsheets are:

  • Scoring Spreadsheet: Version 3 is done:  It contains a switch that turns off tie breaking for distance events, since some games do not use this methodology.  It also is a little cleaner version.


  • Budgeting:  A spreadsheet to help develop a budget for athletics.  I was not given one when I took over as an AD so I had to make one.  This is how an actuary approach budgeting: 

    First Step: (Variable Costs): the cost that varies by the flight/athletes (food, t-shirts, awards,....)

    Second Step (fixed Costs): the fixed costs which do not depend on the number of athletes (announcer, bleachers, porta-potties,...). 

    These costs are balanced against registration income and sponsorship to get a final budget number. 


  • *** NEW *** Score Sheet Generator:  Generates score sheets with throwers names.  Places records on each sheet based on event, throwing division, and record set. A little complicated but works well and don't have to keep on telling excel to print because it has a macro built in.


  • Scheduling Flights: This spreed sheet is not simplified and cleaned up yet and thus is not uploaded.  Driven by the the throwing division and the number of throwers, a schedule of events can be determined for each flight.  Can be used to determine where bottle necks may occur, which may allow AD to make changes so the games move along smoothly.

 

In highland games it is better to give then receive for in the long run, your games and this sport will benefit many times over.  If the various festivals (big and small) and AD's communicate, share, and respect each other, we all grow and benefit. 

Mark McVey

"The work of science is to substitute facts for appearances and demonstrations for impressions." -John Ruskin
Back to Top
McSanta View Drop Down
Postaholic
Postaholic
Avatar

Joined: 4/12/05
Location: United States
Status: Offline
Points: 1595
Post Options Post Options   Thanks (0) Thanks(0)   Quote McSanta Quote  Post ReplyReply Direct Link To This Post Posted: 5/23/08 at 5:09am

for those who care:

It was suggested that the scoring program should have a reporting facility so that each thrower's results can be printed and handed out.

An extra tab and macro were added to the scoring Excel spreadsheet for this purpose.  Thus, version 4.0 has been born..... 

If anybody else wants any of these excel files customized, none of the spreadsheets are password protected but all have protection turned on to avoid data being entered where it should not.  Thus, you can easily make changes yourself (if you can figure out how they work...which is sometimes a challenge with spreadsheets).    

If anybody wants customization and is not up for the challenge, please drop me a line.

markjmcvey@yahoo.com

 

Mark McVey

"The work of science is to substitute facts for appearances and demonstrations for impressions." -John Ruskin
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.11
Copyright ©2001-2012 Web Wiz Ltd.

This page was generated in 0.061 seconds.