Season 10 Drop Sheet is up for developmentHow 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
6. Open reference tab
7. Column I rows 3 - 32 are used named mech builds. Examples: Skirmisher, Gauss, Harasser. These are specific for your unit.
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 each match, copy the match number and paste it in to the drop on the REPORTS tab.
At the end of the night go to the REPORTS tab and enter if you uploaded all 5 videos.
Upload all of your screen caps to the MRBC site and use the drop numbers to fill in your drop information.
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-0 are the only cells needing manual entry on the REPORTS tab. Please do not change other cells or the calculations will be off.
*UPDATES*
3/6/2018 - Added Match ID column to REPORTS tab
3/12/2018 - Updated eligible mechs. Special thanks to QueenBlade (so awesome)
3/12/2018 - Updated REPORTS tab to have Match ID for each drop
3/12/2018 - Updated formatting (Green = need to fill in for stats or drop# )
3/12/2018 - Each drop in each week has a section for Match ID where you will copy paste the ID from the end of the match for reporting.
3/29/2018 - Added Javelin
3/29/2018 - Fixed MAD and CTF variants
3/29/2018 - Updated formula for S10 special mechs
3/29/2018 - Updated back end for easier season updates
3/29/2018 - Updated MRBC drop info images
4/08/2018 - Updated Fixtures
4/08/2018 - Updated new drop info images
4/10/2018 - Extended validation range for builds to J91 to provide more build options