# 1836's Steamworks Calculator!

We’re back again with another calculator for the FRC Game!

Now you can access it in one of three ways:

2. Make a copy to Google Drive (you’ll need to manually update this)
3. Excel (this also requires manual updating)

All of these items are avalible NOW at http://milkenknights.com/resources/frc/2017 and can also be accessed from milkenknights.com/steamworks.

Instructions are very straight forward this year: write in blue boxes only an all will be good.

I am certain that I made mistakes so please report bugs either via this thread or the information written on the spreadsheet. Keep your eyes peeled for our game test in just a few days!

Since initial release, rotor (max of 4) warnings added.

Thanks much! (and its “rotors”… :ahh:

The calculator doesn’t include the kPa from the auto period in calculating the RPs for quals.

Also, I don’t see an eliminations calculator yet.

And for Q&A: what does “exceed 40 kPa” mean? Equal to 40, or greater than 40? Likely the latter, but we’ll need clarification.

I’m sorry I’m not completely understanding what issue you are raising.

Coming Soon

My understanding is you can get 1 ranking point (3 with win) by spinning all 4 rotors without delivering a single fuel.

Yeah we were all a little unclear on this so I figured that people can just ignore the RP

over 1 since it doesn’t alter anything else if they do not think it counts. Once it is more, clear I will adjust if needed.

Thanks Jared! This was really valuable to build off for our discussions today.

Citrusdad: It does, check the formula in the yellow box again (sums all kPa)

Here’s an equation for converting retrieved gears directly into rotors, where GearCount is the integer number of gears onboard the airship

``````
=IF(GearCount>0.5,1,0)+IF(GearCount>2.5,1,0)+IF(GearCount>6.5,1,0)+IF(GearCount>12.5,1,0)

``````

EDIT2: Hi Jared, I disagree with your rotor warning count - a rotor that’s started during auto for 60 points, is counted for an additional 40 points at the end of the game. Therefore the warning should only apply to the adjacent cell, not the sum of cells.
I’ve also added the RP for all 4 rotors spinning, and a task/time breakdown with contributions to score. Uploaded to CD_Media, feel free to use & publish
https://www.chiefdelphi.com/media/papers/3326

It wont let me do tge offline i downloaded the Microsoft thing and everything

You correctly show 1 RP

for scoring 41 kPa, but only if its scored in tele, whereas it can be scored in auto as well and the calculator doesn’t include that.

Great calls! All changed. Google Sheets updates will be instantaneous once you make a new copy and Excel changes (web based and download) will apply within 5 minutes.

I have tested this by putting 125 in the low goal auto spot and seem to be getting the correct result if I am understanding what you are saying correctly. Could you send a screenshot?

Could you send a screenshot of the issue please?

Also, you can now calculate fouls in the lower right corner.

Make a new Copy for Google Sheets, Download new Excel doc, or use the interactive version on the website. Keep reporting!

Great job! However, I believe this screenshot will illustrate a couple of issues.

1. I have 2 rotors started in AUTO and 3 rotors started in TELEOP. This totals 5 ROTORS, but doesn’t generate a warning.

2. A RP is not awarded for starting all 4 ROTORS (even if the total between AUTO and TELEOP were 4).

My understanding is that it does not matter when all four are turned. The rules say:

When rules are stating that the accumulation needs to happen in either auto or teleop, it says “…by period’s T=0.”

Thoughts?

This got longer as I was typing it and realizing that I was finding more as I went. To make a “short story, long” as my wife likes to tell me.

The counting of the fuel for Match points need to be corrected to be additive between the all types (Auto High/Low, TeleOp High/Low) and not separate scoring lines.

Examples directly from 4.3 Scoring in the Manual (beginning with TeleOp to remove Auto issues and using 1/9ths for clarity):

12 in Low, 5 in High = 3 kPa, 3 Match Points
12/9 + 5/3 = 3
1 3/9 + 1 6/9 = 3

14 in low, 5 in High = 3 2/9 kPa, 3 Match Points
14/9 + 5/3 = 3 2/9
1 5/9 + 1 6/9 = 3 2/9

The calculator is showing both examples as 2 Match Points because it is treating each goal as a separate scoring line when the manual says that they are added together via examples. You don’t just lop off the remainder in each goal before adding them together. At most, you would be off by 1 Match Point in the TeleOp part of the calculator, but see 2016 Einstein for how important a single point can be. The additive error doesn’t end there though and can add another point of error when Auto is included.

The example given in the Scoring rule is 17 Low in Auto gives 5 2/3 kPa. An additional 3 Low in TeleOp will add 3/9 (1/3) to that giving 6 kPa. The calculator is not adding them together that way resulting in only the 5 still (it takes adding 7 to TeleOp low to make it add another point).

The kPa column should be showing the value in 1/9ths for TeleOp, 1/3rds for Auto to correctly show what the running total is without rounding. The Match Points column should probably not include the fuel as without having all 4 pieces of information together and calculated the total can be off by up to 2 points if the remainders add up to over 2 additional kPa:

Auto Low - 2 fuel - 2/3 kPa
TeleOp High - 2 fuel - 2/3 kPa
TeleOp Low - 8 fuel - 8/9 kPa
Total is 2 2/9 kPa or 2 Match Points. When put in the calculator this way, it shows 1 Match point and that is on the Low TeleOp line for some reason.

TLDR; The Match Points for the goals should not be separate lines but total for all with their respective weights based on goal and when scored. Calculate:
(Auto Low/3) + (Auto High) + (TeleOp Low/9) + (TeleOp High/3) for kPa (1RP if >40) and then round down to whole number for Match Points from fuel.

I can’t download the Excel version to look at the formulas being used at the moment (errors out for me) but the above should help to make them act like the Scoring section describes in the manual per my using Excel to make sure I was seeing what the manual was saying. I didn’t post screenshots as all you need to do is enter the manual’s examples to duplicate what I was using.

Just to keep you in the loop - I’m working on this. Thanks for your input. I’ll update soon.

Per 10.4.3 Qualification Ranking D. Each Team on an ALLIANCE that achieves at least 40 kPa receives one (1) Ranking
Point.
I’ve not looked at your calculator, but am just checking that you’re clear you only need 40 kPa, not 41.

Nate,

Does this seem like it is matching what you have requested? I see what you are saying and think this is the solution but I may still be missing something.
http://i.imgur.com/QxvhYKc.png