As a French person I feel like it's my duty to explain strikes to you. - AdrienIer

Create an account  

 
Combat Calculator

Values are tracking correctly for 100% HP battles, but begin to diverge, and the amount of error between the predictions is a function of the amount of HP away from 100%. Error is further extended once you add in promos. Given this behavior, my guess is either I made an error in the firepower function, or the mouseover is not calculating firepower correctly. I'm thinking the first possibility significantly more likely.

Incidentally, your odds are 60.1% according to the mouseover w/ C2
Blog | EitB | PF2 | PBEM 37 | PBEM 45G | RBDG1
Reply

@Cyneheard, what was the firepower function again? In my calculator it's the average of the modded str. w/ and w/out HP modification.
Blog | EitB | PF2 | PBEM 37 | PBEM 45G | RBDG1
Reply

Sareln Wrote:
@Cyneheard, what was the firepower function again? In my calculator it's the average of the modded str. w/ and w/out HP modification.

My function for attackers (switch Att and Def for Defender):
=FLOOR(20*(3*(Att100HP+AttActHP)+Def100HP+DefActHP)/(3*(Def100HP+DefActHP)+Att100HP+AttActHP),1)

Att, Def: Attacker, defender
ActHP = Str @ 100HP * modified str.

That has divergent behavior from what I think you're describing.
Reply

You mean there's a bug in your spreadsheet?! You've ruined me, Sareln!!!!11oneone

Do griffons get defense bonuses? They're flying units...
Reply

NobleHelium Wrote:You mean there's a bug in your spreadsheet?! You've ruined me, Sareln!!!!11oneone

Do griffons get defense bonuses? They're flying units...

They do. Flying doesn't remove defensive bonii
Blog | EitB | PF2 | PBEM 37 | PBEM 45G | RBDG1
Reply

This has to be the most frustrating thread to read if you're in the game the spoilers are for.

Played: Pitboss 18 - Kublai Khan of Germany Somalia | Pitboss 11 - De Gaulle of Byzantium | Pitboss 8 - Churchill of Portugal | PB7 - Mao of Native America | PBEM29 Greens - Mao of Babylon
Reply

Yeah, the spoilers might be a bit over the top. Non-spoily summary: Sareln's calculator doesn't work properly if one of the units is damaged.
Reply

I can fairly say that in every single battle I have used cyneheards spreadsheet to calculate has been identical between spreadsheet and BtS both RB mod and 3.19.
Current games (All): RtR: PB80 Civ 6: PBEM23

Ended games (Selection): BTS games: PB1, PB3, PBEM2, PBEM4, PBEM5B, PBEM50. RB mod games: PB5, PB15, PB27, PB37, PB42, PB46, PB71. FFH games: PBEMVII, PBEMXII. Civ 6:  PBEM22 Games ded lurked: PB18
Reply

Where is Cyneheard's spreadsheet, anyway?
Reply

I don't think I ever posted it online (some people got it via e-mail at different points in time). The usability's decent, although the back-end code is spaghetti that I'm not even sure I could figure out if I had to redo it now that it's been 2 years since I started the bloody thing.

Cyneheard's Combat Odds Spreadsheet
Reply



Forum Jump: