Chief Delphi - Stronghold Calculator

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)

- General Forum (http://www.chiefdelphi.com/forums/forumdisplay.php?f=16)

- - Stronghold Calculator (http://www.chiefdelphi.com/forums/showthread.php?t=141362)

Gravity

10-01-2016 16:07

Stronghold Calculator

Hey everyone!

Our team (5940) has been trying out different strategies and thought that a calculator might be useful so as to save time.

We put together a simple spreadsheet to calculate:

Individual Autonomous and Teleop scores
Penalties (Generic and Technical Fouls)
Tower durability
Ranking Points per team
Winner of each round including total scores

We will be updating this frequently with anything that our team/this community finds beneficial. Feel free to also include any bugs that you find in the comments section and I'll work on fixing them ASAP.

Regards,
Gravity (Team 5940)
Link: Click Here
Special thanks to frcguy for helping on this :)

Check/Request List:

Fix Ranking Points
Add countdown timer

dwass

10-01-2016 16:38

Re: Stronghold Calculator

Sounds awesome, would it be possible to make the google sheet public though?

frcguy

10-01-2016 16:43

Re: Stronghold Calculator

Quote:

Originally Posted by dwass (Post 1520383)

Sounds awesome, would it be possible to make the google sheet public though?

Oops, it's public now.

Gravity

10-01-2016 16:45

Re: Stronghold Calculator

Quote:

Originally Posted by dwass (Post 1520383)

Sounds awesome, would it be possible to make the google sheet public though?

File sharing is fixed, allowed comments to be posted on the sheet as well.

Starwarsguy2

10-01-2016 17:51

Re: Stronghold Calculator

Quote:

Originally Posted by Gravity (Post 1520343)

We put together a simple spreadsheet to calculate:

Individual Autonomous and Teleop scores
Penalties (Generic and Technical Fouls)
Tower durability
Ranking Points per team
Winner of each round including total scores

Darn, this puts my calculator to shame. :ahh:

first3234

10-01-2016 18:49

Re: Stronghold Calculator

is this going to be for public use?

Gravity

10-01-2016 19:15

Quote:

Originally Posted by first3234 (Post 1520480)

is this going to be for public use?

Yes, this is going to be open for public use and iterations will be posted on the provided link.

alectronic

10-01-2016 19:22

Re: Stronghold Calculator

May be worth saying "strength" instead of "durability" so it matches the manual.

Gravity

10-01-2016 20:44

Quote:

Originally Posted by alectronic (Post 1520499)

May be worth saying "strength" instead of "durability" so it matches the manual.

Ohh yeah, was going to change that a while ago, thanks!

cdicorpo

10-01-2016 22:04

Re: Stronghold Calculator

Also, I noticed the "Boulder: High Tower" on the Blue page cause the Red Tower Durability to go up, not down. :)

Gravity

10-01-2016 22:30

Quote:

Originally Posted by cdicorpo (Post 1520660)

Also, I noticed the "Boulder: High Tower" on the Blue page cause the Red Tower Durability to go up, not down. :)

Awesome, thanks for finding that!

VacioArconte

11-01-2016 01:07

Re: Stronghold Calculator

This is really cool!

Am I wrong on the rules, or shouldn't boulders scored in auto reduce the tower strength as well?

Kyle Heaton

11-01-2016 10:56

Re: Stronghold Calculator

Quote:

Originally Posted by VacioArconte (Post 1520821)

This is really cool!

Am I wrong on the rules, or shouldn't boulders scored in auto reduce the tower strength as well?

I noticed this as well, and the rules don't say anywhere that an auto boulder decrements the tower strength, but I would imagine it.

Gravity

11-01-2016 12:49

Re: Stronghold Calculator

Quote:

Originally Posted by Kyle Heaton (Post 1521033)

I noticed this as well, and the rules don't say anywhere that an auto boulder decrements the tower strength, but I would imagine it.

As I've stated this is a work in progress so I'll be sure to add that ASAP. Thanks for mentioning that! :]

An Outlier

11-01-2016 18:24

Re: Stronghold Calculator

@Gravity,

I made a copy of your (super-helpful) calculator, and made some additions.
Do I have your permission to post the updated version, with credit to your team?

Thanks a bunch!

Ravage457

11-01-2016 20:00

Re: Stronghold Calculator

I'm having trouble opening this document on an iPad, is this file not compatible with iPads?

An Outlier

11-01-2016 20:01

Re: Stronghold Calculator

Quote:

Originally Posted by Ravage457 (Post 1521560)

I'm having trouble opening this document on an iPad, is this file not compatible with iPads?

If you open it with the "Google Sheets" app (Free from Google) you should be fine. I doubt it will work in any other app.

Gravity

18-01-2016 16:51

Re: Stronghold Calculator

Quote:

Originally Posted by An Outlier (Post 1521472)

@Gravity,

I made a copy of your (super-helpful) calculator, and made some additions.
Do I have your permission to post the updated version, with credit to your team?

Thanks a bunch!

This week has been a bit hectic, bit I'm back!

Feel free to send me the link and I'll update accordingly!

Thanks,

Gravit

All times are GMT -5. The time now is 22:21.