Chief Delphi
Page 1 of 2 1 2 >
Show 100 post(s) from this thread on one page

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   General Forum (http://www.chiefdelphi.com/forums/forumdisplay.php?f=16)
-   -   1836's Steamworks Calculator! (http://www.chiefdelphi.com/forums/showthread.php?t=153112)

jaredhk 07-01-2017 12:35
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:
  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 07-01-2017 14:35
Re: 1836's Steamworks Calculator!
 
Since initial release, rotor (max of 4) warnings added.

Citrus Dad 07-01-2017 17:42
Re: 1836's Steamworks Calculator!
 
Thanks much! (and its "rotors"... :ahh:

Citrus Dad 07-01-2017 17:49
Re: 1836's Steamworks Calculator!
 
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 07-01-2017 18:12
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by Citrus Dad (Post 1626640)
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.

Quote:
Originally Posted by Citrus Dad (Post 1626640)
Also, I don't see an eliminations calculator yet.
Coming Soon

jeremylee 07-01-2017 19:04
Re: 1836's Steamworks Calculator!
 
My understanding is you can get 1 ranking point (3 with win) by spinning all 4 rotors without delivering a single fuel.

jaredhk 07-01-2017 19:10
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by jeremylee (Post 1626696)
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 07-01-2017 19:43
Re: 1836's Steamworks Calculator!
 
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

Code:
=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 07-01-2017 23:58
Re: 1836's Steamworks Calculator!
 
It wont let me do tge offline i downloaded the Microsoft thing and everything

Citrus Dad 08-01-2017 00:53
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by jaredhk (Post 1626657)
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 08-01-2017 01:54
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by s-neff (Post 1626735)
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 08-01-2017 01:56
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by Citrus Dad (Post 1626997)
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 08-01-2017 10:33
Re: 1836's Steamworks Calculator!
 
Quote:
Originally Posted by Tblue3633 (Post 1626947)
It wont let me do tge offline i downloaded the Microsoft thing and everything
Could you send a screenshot of the issue please?

jaredhk 08-01-2017 10:34
Re: 1836's Steamworks Calculator!
 
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 08-01-2017 11:38
Re: 1836's Steamworks Calculator!
 
1 Attachment(s)
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).


All times are GMT -5. The time now is 15:42.
Page 1 of 2 1 2 >
Show 100 post(s) from this thread on one page

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi