You are here: Home > 1G2
Integration with an Excel .xls File

Back to List of Topics

Used when not using Meet Management Software

Your Eagle Eye Pro system has the ability to integrate with an . xls file.This file
can be imported into Eagle Eye Pro as a blank template (without names, schools, etc.) in order to print results or as a customized template containing athlete names, teams, heats, lanes, etc. that you have added manually.

Option 1 - Standard Template
To use the Excel feature you must use the provided .xls template or create an .xls file with the correct format
(Row 1/ Columns A-H) as shown in the image below.

1.➔ DOWNLOAD the Meet-Template.xls file via the link below and SAVE to the location of your choice.

Click Here to download .xls file

2. Within Eagle Eye Pro Software, SELECT the Results tab and CLICK Import and navigate
to the location of the file.

3. CHANGE the Worksheet File to .xls (lower right corner)
SELECT the Meet-Template.xls file.
4. RECORD a race and ASSIGN times as usual.
5. CLICK the Save Times button to save times to the Meet-Template.xls document.
6. PRINT results by opening the .xls file at its source and choosing to print entire document
or individual sheet (event).

Customizing template
Enter names, teams, ID/Bib # and TFRRS numbers for each participant if you choose. These cells can be left blank, however DO DOT delete unused columns. The labeled columns are necessary for the proper file structure. If you wish to delete columns, do so only after you are done using the . xls file within Eagle Eye Pro software. Additionally you can delete and add heats, lanes and events to fit your needs. Please use caution not to change the fundamental format of the file.Always keep a copy of the original .xls file on hand.

Option 2 - Dual Meet Scoring Template
Click Here to download an Excel .xls dual meet scoring template.

Provided by Mike Robards, Franklin Schools, Indiana

Required Downloads
1. Track Scoring Master Dual - Linked
2. Middle School for Scoring - Template
The scoring template is rigged for our home meets so I would enter basic information on the data tab and it would link to the correct places.

I modified your meet template to fit our middle school meets and added "lanes" to the first heat of the events run in lanes. I made them 11, 12, 13, and 14 (set up for a 3 way meet) to be the places, so their times would be entered twice, by lane & by place. That way I could give every lane a time and assign times that would be linked to the first 3/4 places using the added lanes.

For the non-lane events I linked the first 3 "lanes" as places and linked them to the scoring template. The scoring template will automatically score each event using logic statements based on the school abbreviation.

I found that if you had both open when setting up the meet you could do a save as on the base template (yours modified) and the links would update on the scoring template so you could keep a master.

Most of the time we run the boys and girls together in the 2400 so what I can do is add a 2400 combined tab then use the name columns and make the first 6 slots for First Boy, Second Boy, Third Boy, First Girl, ... and link the times to the appropriate scoring tab.

I've used the scoring template for the last 6 or 7 years and all the visiting coaches love the results because they are easy to read. Now that I'm retired I'm trying to make it easier since I'm sure I'll be called in to time meets for my old school.

TIP: Load the modified template in the Eagle Eye timing computer. This is the source of the links that go into the scoring template, thus you need both templates (download from links above).

The best way to updated the times in the scoring template is to 1) save it 2) close it and immediately re-open it and 3) tell it to update the links. All times will be imported.