|
Re: Week 1 NA region stats |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Are you using a scrape to pull that info or are you hand entering it?
Either way THANK YOU!
Posted on: 2017/4/18 20:51
|
|
|
Re: VIDEO SUBMISSIONS RULE |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
I've actually gotten some blow back from my unit asking that I wait until after the season to post since it provides an unfair advantage to those who will not post allowing them to see our matches.
Posted on: 2017/4/10 19:19
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Fix for NO Rep for Videos this season.
Don't add video uploads to the reputation section.
No need to modify your sheet. Just DON"T add the number of videos uploaded.
Posted on: 2017/4/4 20:37
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Updated the sheet to fix scrim drop 2 mech Get the new one or fix it by fixing the data validation ranges for scrim Cell data validation fix E 24 REFERENCE!AE102:AE110 E25 REFERENCE!AF102:AF110 e26 REFERENCE!AG102:AG110 e27 REFERENCE!Ah102:Ah110 e28 REFERENCE!Ai102:Ai110 e29 REFERENCE!Aj102:Aj110 e30 REFERENCE!Ak102:Ak110 e31 REFERENCE!Al102:Al110
Posted on: 2017/4/4 3:46
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
The problem I ran in to was updating the mechs shifted the mech list but not the selection that were made below it. This misaligned all of the pilots work.
Posted on: 2017/4/3 17:44
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
If you have already added your pilots to the MRBC sheet please go to the reference tab and follow these instructions:
Right click on Row 60 On the menu that appears choose "Insert 1 above" Do this 20 times Go to the W column and highlight cells W61 - BR90 Right click and Delete Cells and shift up.
If you would rather just copy paste your roster then grab the newest sheet from the link on the first post and make a copy of that. There were more teams than space for one of the calculations due to the large number of teams that signed up.
Once you have a properly functioning sheet you should now be able to go to the Pilots tab and select your division and team and the weekly schedule should populate with maps in place.
Posted on: 2017/4/3 14:21
Edited by CWMTraining on 2017/4/3 15:03:38
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Hi Soba
After asking several times last season and during the development of S9 there wasn't much interest in continuing the full list of mechs. If there is interest enough I can look at adding that back although it comes with some problems when updating the mechs for new seasons.
Posted on: 2017/4/3 3:28
|
|
|
Use of Lilferret's Dropsheet |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Will you be using the Dropsheet in Season 9?
If you are using it this season which functions will you use
Organizing pilots for each drop Selecting mechs for each drop Selecting mech builds for each mech assigning a Drop Commander (Drop Caller) for each drop Filling in statistics for each drop for overall statistics Filling in minimum per drop information for end of match reports
Posted on: 2017/3/28 3:00
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Updated sheet to fix some formulas that were broken by last update. Maps should import correctly now You should be able to select division and teams now
Posted on: 2017/3/28 2:56
|
|
|
Re: Lilferret's MRBC Dropsheet: Season 9 |
|
Experienced Mechwarrior
Joined: 2015/6/29 2:09
From usa
Group:
Registered User MRBC Team Leader MRBC Team Streamer Temp
|
Please continue to send me feedback.
I would recommend taking the current sheet for a spin and see if you find any errors. Just before MRBC starts make another copy to be sure you have the newest then just copy your pilot roster.
07 Lilferret
Posted on: 2017/3/26 4:53
|
|