[FTC]: Ring It Up! Score Calculator

[Flex..(Re-Flex)]

The Lyman Robotics teams are working on strategy. To help with the process of testing different scenarios I have created a simple spreadsheet that makes it easy to tally up scores. I have attached if you think it might be useful in planning for this season in FTC. Enjoy

[JesseK]

I've taken some time to poke around, verify, validate, and run through some scenarios with it. It's a very useful tool! Thanks for making it.

There's a small bug in it where neither side's autonomous ring gets a peg score (e.g. putting the autonomous ring on the top should net +15 points at the end). While there's no clear wording on this in the manual ("autonomous rings are like normal rings except"...), both the animation (at 7:14) and the game manual (part 2, page 14) confirm that they are scored like normal rings. It's a simple fix to column AH, but the sheet is password-protected so I can't modify it.

[Flex..(Re-Flex)]

Thank you for finding this bug and clarifying that point I will fix it and resubmit the form.

[Flex..(Re-Flex)]

Here is the revised version. Thank you again for bringing up that point for future reference the autonomous rings count towards the ring score only if they are scored in autonomous.

[Linda Gardner]

Great tool.

Isn't the multiplier bonus supposed to be applied to both the Ring Score and the Line Score? I know the game video did not show this, but in the one page game description it states - 20% added to Ring Score and Line Score Bonus per each
Weighted ring placed.

[Flex..(Re-Flex)]

Thank you for catching another flaw in rule interpretation, I was under the impression that the "ring score" that was multiplied by was just the rings on the pegs and not the extra "bonus" of the lines. I have updated and attached it.