Michigan APF has modified the excellent Next Lifter Excel Spreadsheet by Joe Marksteiner* to add a few more features and customize it for our use in the APF/WPC. The basics of the program are the same as the original with the following additions:
- Full list of APF/AAPF divisions and classes already added
- Support for 50 and 65 lb bars
- Support for separate bar weight for all three lifts (bench & deadlift do not assume the same weight bar).
- Color sorting of the weigh-in sheet. The “flights” column of the weigh-in sheet automatically changes color based on the weight class of the lifter. This makes it easy to visually see where the weight classes lie for assigning flights.
- Enhanced barload screen. An enhanced barload screen which can be served to a projector is added. This allows a separate screen to be sent to a projector/tv instead of the main scoring screen which only shows the current lifter and barload. This is then easier for the audience and platform crew to see and read. Use of this feature requires a separate webserver or projection server (see instructions).
- Upcoming flights display. A new page which shows the upcoming flights (all flights except the current flight) is provided. This can be displayed next to the scoring screen in a split display mode giving the list of flights without needing to print off flight sheet. The view can also automatically update if changes to the flight order or attempts are made.
- ETA to next flight. A timer is provided on the new upcoming flights display which attempts to predict the time until the next flight will begin. This can be used by the lifters to help gauge the timing of their warmup routines. The timer recursively estimates the time remaining in the flight based on the number of lifters left in the flight, the number of attempts remaining, and how long, on average, each attempt is taking.