Time, a couple issues with the Team Plastics spreadsheet:
1. Make sure the additional Winning Combos spreadsheets are deleted. Since this was a Plastics event, you can delete the sheets for HMS and MFB.
2. The Results sheet should display each BeyBattle by each team member individually, with information in the notes column specifying which Team BeyBattle it was, the score of that BeyBattle, and in the row for the last BeyBattle of that Team BeyBattle, the final score and winning team. See the spreadsheet for Team BeyBattle Revolution as an example:
https://docs.google.com/spreadsheets/d/1...lpkZY/edit
It actually might be a good idea to keep a separate sheet that just shows the Team BeyBattle overall results like you've done (so that it is easier to process the Team BeyBattles on each Team Account in the future when we have the team rankings intergrated into the BP System), so you can keep that. Just duplicate the Results sheet and have the second one list the results for each member like I have described. The first sheet can be called Results - Team Accounts and the second can be called Results - Team Members. Does that make sense?
3. The Final Scores, Credits, etc. sheet should show each individual member, not the teams.
(Jul. 05, 2015 5:43 AM)Time Wrote: P.S. When I get back is it cool if I redesign these spreadsheets for your approval? There's a lot of inefficiency in them right now.
I'm no spreadsheet wizard by any means–I haven't had a reason to use them in the past very much, and as a result I don't know all of the tricks–so I bet that there is. The format is pretty set in stone now because so many tournament have already been submitted with it and I don't want to go back and edit those so that our archive is consistent ... but if you want to propose something that is an absolutely incredible improvement, we can consider it! But the sooner the better.
Wombat Wrote:Also, a question about majority win for Team Format: does the entire team have to get a majority win to get the credit or is it individual? Because I went 4-0 but my team went 2-2. This was probably answered when Team Format was first announced and I either skipped over it or don't remember, haha.
It should be individual. The spreadsheet should show each individual member and their score, faces earned, etc. as I mentioned above.