Deprecated: Assigning the return value of new by reference is deprecated in /var/www/mrbcleague/public_html/modules/newbb/viewtopic.php on line 582
MRBC League

MRBC News


Browsing this Thread:   1 Anonymous Users





MRBC SEASON 10 DROP SHEET
Experienced Mechwarrior
Joined:
2015/6/29 2:09
From usa
Group:
Registered User
MRBC Team Leader
MRBC Team Streamer
Temp
Posts: 124
Offline
Season 10 Drop Sheet is up for development

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
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

Posted on: 2018/2/28 7:21

Edited by CWMTraining on 2018/3/6 16:04:19
Edited by CWMTraining on 2018/3/12 19:27:02
Edited by CWMTraining on 2018/3/13 1:19:32
Edited by CWMTraining on 2018/3/13 1:21:33
Edited by CWMTraining on 2018/3/13 2:25:48
Edited by CWMTraining on 2018/3/21 0:05:18
Edited by CWMTraining on 2018/3/26 20:18:13
Edited by CWMTraining on 2018/3/29 13:10:12
Edited by CWMTraining on 2018/3/29 13:33:12
Edited by CWMTraining on 2018/3/29 13:53:05
Edited by CWMTraining on 2018/4/8 4:11:38
Edited by CWMTraining on 2018/4/9 1:47:46
Edited by CWMTraining on 2018/4/10 18:48:34
Transfer the post to other applications Transfer


Re: MRBC SEASON 10 DROP SHEET
Mercenary
Joined:
2014/3/30 1:09
Group:
Registered User
MRBC Team Leader
Posts: 28
Offline
Appreciate you doing this, makes admin and setup for matches much easier

Posted on: 2018/2/28 14:40
Transfer the post to other applications Transfer


Re: MRBC SEASON 10 DROP SHEET
Veteran Mechwarrior
Joined:
2014/9/11 13:47
From Darwin
Group:
BFM Site Admin
Affiliated Caster
MRBC Team Streamer
Temp
MRBC Team Leader
MRBC Referee
Registered User
Posts: 260
Offline
Hey Mate,

With the API coming in, a place to store your match ID per game or link to Screenshot?

Posted on: 2018/3/6 3:27
Transfer the post to other applications Transfer


Re: MRBC SEASON 10 DROP SHEET
Experienced Mechwarrior
Joined:
2015/6/29 2:09
From usa
Group:
Registered User
MRBC Team Leader
MRBC Team Streamer
Temp
Posts: 124
Offline
Added in Match ID on REPORTS tab. Good catch.
Screenshots, considering your results won't post until shots are uploaded I'm not sure how much functionality that would provide. If there are a consensus from the forums I'll add a column by default, otherwise please feel free to make column M on REPORTS your link location.

Posted on: 2018/3/6 16:03
Transfer the post to other applications Transfer


Re: MRBC SEASON 10 DROP SHEET
Experienced Mechwarrior
Joined:
2015/4/2 5:37
From California
Group:
Registered User
MRBC Team Leader
MRBC Team Streamer
Posts: 98
Offline
Thanks for the work, CWM. We will use this as the basis for our spreadsheet. Some notes:

- Javelin is missing
- What is a MAD-5H?
- I think the CTF-3 should be CTF-3L
- Update command mechs to S10
- Update drop restriction images to S10

Posted on: 2018/3/27 4:15
Transfer the post to other applications Transfer


Re: MRBC SEASON 10 DROP SHEET
Experienced Mechwarrior
Joined:
2015/6/29 2:09
From usa
Group:
Registered User
MRBC Team Leader
MRBC Team Streamer
Temp
Posts: 124
Offline
Thank you Tamerlin,

I've updated everything mentioned by Tamerlin

Posted on: 2018/3/29 13:13

Edited by CWMTraining on 2018/3/29 13:53:41
Transfer the post to other applications Transfer






You can view topic.
You cannot start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.

[Advanced Search]