How to Prepare an Award List Spreadsheet
A clear award list is one of the best ways to save time and avoid engraving mistakes. Trophy orders usually involve names, categories, teams, quantities, product choices and deadlines. If those details are scattered across emails, screenshots, texts and handwritten notes, the chance of an old correction slipping through is much higher. A spreadsheet gives everyone one source of truth. It also helps Geraldton Trophy Centre quote faster, check missing details and prepare proofs where needed.
The simplest structure is one row for every trophy, medal, plaque or plate that needs to be produced. If one person receives two awards, use two rows. If a team receives 20 identical medals, use either 20 rows with names or one row with quantity 20 if names are not required. This makes it clear how many physical items are needed and what wording belongs on each one. Avoid putting several award names in one cell if they need separate plates.
A simple layout is: Team or Group | Award Category | Recipient Name | Product Code or Type | Quantity | Engraving Wording | Ribbon/Colour | Proof Needed | Notes. A junior football row might say “Year 9 Blue | Most Improved | Sam Taylor | small trophy | 1 | Most Improved 2026 | n/a | yes | match last year style”. A school carnival row might say “Year 5 | 100m First Place | no name | medal | 1 | Year 5 100m First Place | faction red ribbon | no | athletics carnival”. The exact columns can change, but the idea is to make each physical award unambiguous.
Names should be typed exactly as they need to be engraved. Check spelling, capitalisation, initials, apostrophes, hyphens and preferred names before sending the final file. If a player is known by a nickname but the parent expects a full legal name, the spreadsheet needs to show the final choice. Avoid sending “corrected” names in separate message threads after the spreadsheet unless you also update and resend the master file.
Small wording differences can make a presentation table look messy. Decide whether awards say Best & Fairest or Best and Fairest, Runner Up or Runner-Up, Under 13 or U13, Soccer or Football, 2026 Season or Season 2026. Use the same style throughout the spreadsheet unless there is a deliberate reason to change it. If last year’s wording needs to be matched, send a photo of the previous plate or trophy.
If you have browsed the website or catalogues, include product codes, screenshots or page links. If you have not chosen products, leave the product column blank and describe the purpose instead: junior medal, major trophy, perpetual plate, sponsor plaque or staff badge. Staff can then suggest practical options. Product codes are helpful, but they are not required before starting an enquiry.
Include the event date, required pickup date and whether a proof is needed before production. If someone else must approve names or layout, add their contact or note that approval is pending. For large club and school orders, it is better to send rough quantities early and final names later than to wait until everything is perfect. Just make it clear which file is draft and which file is final.
Before attaching the spreadsheet, check for blank recipient names, duplicated awards, missing quantities, inconsistent team names and unclear notes. Save the file with a useful name such as “Club Name 2026 Trophy List FINAL”. Attach it to the website enquiry form or email it through with the presentation date in the message. If there are changes later, resend the full updated spreadsheet and clearly say it replaces the earlier version.