Here is the Season 9 Dropsheet This connects to two other sheets that have reference data.
How to use this sheet
1. Open the link, go to File and select "Make a copy"
2. Open the reference tab
3. If there are no mechs listed in A2 then click in A2 and allow the connection
4. Open the Pilots tab and fill in your roster
5. Have each pilot fill in their skill level for each weight class (season 10 will use this)
6. Open reference tab
7. Column I rows 3 - 32 are used named mech builds. IE Skirmisher, Gauss, Harasser
Filling out the sheet during drops for each week
Fill in each pilot and which mech they will bring (checks for duplicates)
Fill in each persons Kills, Assists and Damage from screen cap
Enter any enemy mechs destroyed out of combat (overheating, oob, friendly fire) (calculates mechs killed for points)
Select if your team had a Win or Loss (calculates win rewards)
At the end of the night go to the reports tab and enter how many videos you upload
Upload all of your screen caps to the MRBC site and use the reports tab to help you fill in the match report.
NOTES:
1.This sheet references 2 other sheets and you may need to grant permission to access them
2. Fixtures will automatically update once they are posted (and I update the reference sheet) I will post here when that happens.
3. Once fixtures are input go to the Pilots tab and select your division and team
4. Maps will automatically populate once fixtures are updated, and your team is selected
5. If you fill out the weekly sheets from your screen caps then you can use the reports tab to help you fill out your match report, you will also be able to look at pilot statistics
6. Column J is the only manual entry needed on the REPORTS tab. Please do not change other cells or the calculations will be off.
I will update this post as needed. Please contact me if you need help setting up the sheet for your team or if you have feedback/bug fixes.
07
Lilferret
UPDATES:
Fixed formulas for mech class selection
Fixed formulas to point to season 9 import sheets
Added SCRIM tab with drop down selection of maps
Fixed drop down for drop 3 second mech class selection on all weekly tabs
Drop 3 command mech updated to 85 ton mechs.
Updated Drop 3 command mech reference formula to pull updates from fixtures sheet
Reworked the maps section i n REFERENCE and updated formulas
Made drop 5 on SCRIM tab customizable
Updated DC (Drop Commander o r Drop Caller) drop downs to pull from pilots in each drop
Cleaned up drops that were missing outlines around information (cosmetic)
Added Notes in places to help explain some fields
Fixed error in data validation on drop 2 of each week causing drop 1 variants to be displayed