quote:

ORIGINAL: Mina

Hey, nice work! This'll be very useful to a lot of people, including myself.

Two things that immediately came to mind as far as suggestions go are uploading a version to google drive, as that's free and most people will have a gmail account. I opened the .xls in sheets and it seemed to convert fine.
The other was making it so that you don't need to add a % to the end of the linear tech fields, so it treats any whole number as being a percentage out of 100. The difference between Laser weapons 100% and Laser Weapons 100 is... a bit huge.

quote:

ORIGINAL: Vic

Sorry there. There is an undocumented rule...

If size = 6 Or size = 7 Then moveRedux -= 10
If size = 8 Or size = 9 Then moveRedux -= 20
If size = 10 Or size > 10 Then moveRedux -= 30

made note to add this to future manual revision.

Thanks for spotting

Soft attack/defense:
800 initial firepower for 180mm howitzer
*1.265 conventional gun optimization bonus
*0.84 for weapon design score
*0.5 for tank destroyer soft attack penalty
*1.5 for cluster bombs bonus
637 soft attack
*0.5 infantry defense penalty
318 soft defense

Hard attack/defense
800 initial firepower
*1.265 conventional gun optimization bonus
*0.84 for weapon design
*0.5 for howitzer hard attack penalty
*1.5 for tank destroyer hard attack bonus
*1.36 armour piercing optimization bonus
*0.5 turretless hard attack penalty
434 hard attack
And hard defense is calculated before the turretless penalty is applied, so it's
867 firepower
*0.667 tank defense penalty
578 hard defense

quote:

So I could only save it as .xlsx. Which as you might know is a bad format.

quote:

“But the plans were on display…”
“On display? I eventually had to go down to the cellar to find them.”
“That’s the display department.”
“With a flashlight.”
“Ah, well, the lights had probably gone.”
“So had the stairs.”
“But look, you found the notice, didn’t you?”
“Yes,” said Arthur, “yes I did. It was on display in the bottom of a locked filing cabinet stuck in a disused lavatory with a sign on the door saying ‘Beware of the Leopard.”

― Douglas Adams, The Hitchhiker's Guide to the Galaxy

quote:

ORIGINAL: BlueTemplar

Thank you, but the AP cost penalty is still wrong, you calculator says +70% while it's +80% for my Monitor :
Last Engine Power is listed as 1200, last Weight before Movement Redux is listed as 1660, and not 1510 like in the Calculator.
With 1660 manually input I *do* get +80%.

I don't know how you managed to figure out the math :
This ends up with a 72.2% Weight / Engine Power ratio, which *should* lead to a +30% move cost modifier
(see manual p.328 - I *think* that I'm interpreting the brackets correctly ??),
with then the 11 Monitor size adding an extra +30% on top of that,
for a total of +60%, and not +80% ??