1836's Steamworks Calculator!

[jaredhk]

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

Now you can access it in one of three ways:

1. On our website (no downloads or accounts)
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!

[jaredhk]

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

[Citrus Dad]

Thanks much! (and its "rotors"...

[Citrus Dad]

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.

[jaredhk]

Originally Posted by Citrus Dad

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

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

Originally Posted by Citrus Dad

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

Coming Soon

[jeremylee]

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

[jaredhk]

Originally Posted by jeremylee

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.

[s-neff]

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

[Tblue3633]

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

[Citrus Dad]

Originally Posted by jaredhk

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



Coming Soon

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.

[jaredhk]

Originally Posted by s-neff

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.

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.

[jaredhk]

Originally Posted by Citrus Dad

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.

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?

[jaredhk]

Originally Posted by Tblue3633

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

Could you send a screenshot of the issue please?

[jaredhk]

Elims version added!

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!

[b.arci]

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).