|
Ben -
Nice job. This is virtually an exact duplicate of a spreadsheet I made up when the game was being created to determine implications of some of the scoring options that were being considered at the time (I note that your sheet does not have the "how many monkeys in the bins?" multiplier though...).
There is a companion sheet that you can also create that is particularly useful to the drivers/coaches as well. (hint, hint) For a given number of "X" bins in your alliance scoring zone and "Y" bins in the opponent alliance scoring zone (note: Y is not automatically 45-X), what is the maximum QP that you can get? Use this at a glance to determine if you should move a few containers from your side of the field to theirs, or vice versa.
-dave
---------------------------------------
Y = AX^2 + B.... ehhh, whatever
|