Track Meet Tools

Scoring Program

As a new track coach responsible for hosting and running a track meet, one of the biggest concerns is keeping up with results and scoring as events are completed and score cards come in.  As I didn’t really want to do all the scoring by hand and also didn’t have the time or resources to invest in track meet management software, I adapted an excel spreadsheet to do this task. It’s based on a much simpler version by Berkshire Sports.  Basically, you put in results as they come in and the spreadsheet will keep track of team scores and outstanding individuals in track and field.

Track.Meet Results & Scoring Program (current version)

The current version (updated June 2015) updates team scores automatically after each change.  Please report any problems you may have in the comments below.

Google Sheets Version

Older Version (Excel ’97 compatible)

Track Meet Results & Scoring Program (older version)

Note: For the “update” button to work and determine team scores, macros must be enabled.  Sometimes, security settings prevent this from working, so you can just right-click on the table itself and choose “Refresh” to update the team data.

Recommended alternative: I recently used Athletic.net and Racetab to manage our parish track meet.   See my post on the topic for more.

Scoring Cards

Also, here are a set of scoring cards I put together for our meet.  The file includes cards for races with multiple heats, other race entry forms, throwing field events, and jumping field events.  There are no finals included in any of the cards, but that could be added without too much trouble.

Track Score Cards (Word .doc)

Track Score Cards (PDF)

  1. Steve Wills

    Hey, your T&F tools look good. I might use one or more this afternoon at a meet for my son’s middle school team. Nice work and I’ll give you some follow-up/feedback as soon as I can.

    • Jason

      I’m not familiar with using excel on an iPad, but you can right-click on the pivot-table and update it that way. You might try to press-and-hold on the table and see if a context menu comes up?

  2. Jeff Koos

    This looks & works great, but I can’t get it to keep track of the team points for quad meet.  It won’t let me click on the update results button.  Any help would be great.

  3. Jeff Koos

    I am using a MacBook Pro and I can’t locate a refessh button.  When I put my curser over the update box it doesn’t seem to recognize that it’s a function.  Anymore ideas?
     
    Thanks

  4. Jeff Koos

    Jason,
    I want to score for 8 places (10,8,6,5,4,3,2,1,).  How do I change the score sheets to calculate 8 places?  You have it set up to only score 6 places.  Thanks again for your help.

    • Jason

      Jeff,

      Right now, it is only set up to score 6 places.  You would need to just add some rows in each event section.  You should be able to update the setup tab with the correct information.  It would take some excel work, but you should just be able to copy the existing formulas into the new cells.  I don’t have time to set it up myself at this time, but would be glad to help troubleshoot if you need.  Good luck,

      -Jason

  5. Roma Coleman

    Jason,
    Thank you for doing this and giving everyone access.  I’m going to attempt to use this at my school’s track meet this Friday.
    Sincerely,
    Roma Coleman

  6. Mike Joseph

    Jason,
    I am having difficulty updating the boys team results.  The girls works fine.  When I click to update the boys I get a run -time error ‘1004.’ The PivotTable field name is not valid.  To create a PivotTable report, you must use data that is organized as a list with labeled columns.  If you are changing the name of a PivotTable, you must type a new name or field.  As for as I can tell the girls table is set up the same as boys.  Can you help me with this?  Thanks

    • Jason

      Hi Mike – I’m sure I’m too late for this to be useful for you, but to anyone else with the same issue: You can also update team results by right-clicking on the team scores table and selecting ‘Update’. I put an update button on there which essentially does the same thing. I don’t know why it wouldn’t work, but I’ll look into it.

  7. Scott

    Jason,

    I’m just curious as to how you would go about handling a tie? I know with track this in theory is simple, but I feel like it would take some serious programming to get it just right. Thanks!

    • Jason

      To have 4 divisions, I would think the simplest thing to do would be to save two (or 4) copies of the spreadsheet and just put results for each division in its own spreadsheet. Might be nice to have 2 separate laptops to speed entry.

      Or, I’d recommend you check out racetab to manage your meet. It takes some work to set it up, but its much more powerful. And free.

  8. Spencer

    Hi Jason,

    This sheet is awesome, how did you get the update button on there? I am trying to learn some more excel stuff and would appreciate anything(including another site) that would teach me some of that stuff.

    Thanks,
    Spencer

    • Jason

      Thanks for checking it out. I haven’t used this in a couple years, but when I tried with a more recent version of MS Excel, I don’t think the “Update” button worked. So, I just had to right-click on the table itself and select “Update” (or refresh?).

      Buttons, text boxes, and the like are called “controls” and there is a toolbar with those things available. If you have Office 2007 or 2013, you’ll have to turn on the Developer tab on the ribbon (File –> Options –> Customize Ribbon). From that tab on the ribbon, you can add buttons, text boxes, dropdowns, etc. In older versions of Office, there was a “Controls” toolbar.

      But, once you place the controls, you have to learn to code some VBA (visual basic for applications) to make the buttons and such do what you want. Sorry, I can’t point you to any great tutorials–I mostly muddled through and learned what I needed when I needed it. I’m sure there are a number of websites or books that could help. I would just search for the following key words:

      Excel VBA controls button

      Best of luck!

  9. Spencer

    Actually I think I found some stuff that pointed me in the right direction. I work in IT, so the VBA stuff wasn’t too much, just had to do some additional research. I am reworking your sheet in 2013 to fit our track stuff. I can send it your way if you want when I finish, but you did a great job pointing me in the right direction. Looks like the controls are under the developer tab now.

    Thanks,
    Spencer

  10. Niki

    Thanks for sharing this, I volunteered this weekend to get the results collected up onto a spreadsheet for a meet our small club hosted this past weekend, not sure if I’ll be doing it going forward, so this is super helpful not having to spend $200+ dollars or countless hours to organize and format on top of the input. You are a gem! Hope this works out for what the team needs.

  11. Rudi

    New iOS app: Athletics Meet Manager.

    I’ve found even the best spreadsheets get a bit buggy when my helpers get their hand on them so I’ve gotten paranoid about checking references and double checking results. More advanced programs proved very expensive but there’s a new iPad/iPhone on the App Store for scoring athletics meets and collecting the results. Still growing but currently can replace spreadsheets for score input while still exporting spreadsheet files. Also allows you to share your meet and enter results field/track side from other devises running the app if you want to play around with the tech savvy approach 🙂

  12. Rahkie Mateen

    My school only has MacBooks so I can’t use Racetab. My manager quit so this makes it easy for me to run a meet and keep up with the scores. THANK YOU

    • Jason

      It isn’t necessary to add schools or contestants. When an event is finished, just enter the contestants name, school, and time/distance for the top 6 places. Scoring is automatic when you update the team scoring table.

  13. kate wolman

    Jason, Thank you so much for developing this spreadsheet. My husband coaches at Granada Hills Charter High School. They don’t have a scoring system or funds to pay a timing company – this spreadsheet was so appreciated in giving us the ability to type in the scores. It took a long time just because our scores were in consistent not because of the spreadsheet. When we finally got to a place where the scores were mostly recorded correctly for only the top 3 competitors and we omitted some events that we don’t compete (Pole Vault and Discus) it only took 10 minutes for the team (like Girls JV). We are so grateful for you developing this spreadsheet. Thank you very much.

  14. jim

    Jason,

    is there an option for scoring double duals so that all teams are scored vs each other automatically or would you have to split up results and create 3 meets for the double dual

    • Jason

      No, unfortunately, this is not a feature of the spreadsheet. It might be done using 3 or more separate spreadsheets for each dual, but that would require re-entry of results for each one. In my brief search, it looks like RaceTab (http://racetab.milesplit.com/) might support double dual scoring (and it’s free).

    • Jason

      In case of a tie, you should manually edit the “points” column on the results spreadsheet and split the points equally. You can also change the place to, for example, “2nd (tie)”. The team scoring should update accordingly.

  15. Shawn

    I can not click the undo button on the spreadheet, I have to close the program without saving what I entered, How do you undo what you don’t want?

    • Jason

      I hadn’t noticed this before, but with a little research, I discovered that when the macro runs that updates the team scores (which runs after anything is edited), MS Excel disables the undo button. Unfortunately, you’ll either have to remove the macro and manually update team scores, or deal with not having the ability to undo. Sorry I couldn’t be more helpful.

Leave a Reply to Wendy Cancel reply

Your email address will not be published. Required fields are marked *

Close