EHP Calculator Tool

[(PSN)T0katax]

For those Tenno who were searching for something like this:

I made up a quick EHP Calculator Tool that allows you to choose your warframe, wich mods to install on the warframe (at least those mods regarding shields, hp and armor) and then returns the ehp of the Warframe.

For those unfamiliar with the term EHP: Effective Health Points, or, how many damage you can take bevore you die. Now, for shields thats easy, 1 shieldpoint is 1 point of damage you can take. But health scales with armor. - 300 armor reduce the ammount of incoming damage by 50%, makeing 300 hp and 300 armor worth 600 effective health. 

Let me know if I missed some important mods, got any values wrong, or if there are any bugs ;)

How to:
https://docs.google.com/spreadsheets/d/1FIwgpXa9UiCRKX8E3qks4fp2Wz3RgdSEXvnUrTL0reY/edit#gid=958795026

Copy or download this google sheet.

1) Top left: Choose Warframe.

2) Right: Select "Ja" for all the mods you want to install.

3) Read the outcome / tinker around.

 

Edited November 24, 2017 by (PS4)T0katax

[13QZXXTTX]

Thanks for the Effort!

WF Builder?

I also recently found out that Inaros + Vitality + Primed Vigor up to 5830, not 5900 :segh:.

Edited November 24, 2017 by DesFrSpace

[(PSN)patKaetzchen]

vor 20 Minuten schrieb DesFrSpace:

Thanks for the Effort!

WF Builder?

I also recently found out that Inaros + Vitality + Primed Vigor up to 5830, not 5900 :segh:.

This calculator gets that right ;) 

WF Builder doesn't show you all the "health" mods on one page (you have to search for them => know their name in english, rather than your respective language, or search for "health" and scroll through some mods), and also doesn't show you EHP (Effective HP, How much damage you can take with the armor calculated in) - if it does, I didn't find it :D

Edited November 24, 2017 by (PS4)patKaetzchen

[(XBOX)oD Static]

I'm missing Quick Thinking (and (Primed) Flow, respectively) ^^

[Almagnus1]

Inaros' Scarab Swarm ( http://warframe.wikia.com/wiki/Scarab_Swarm ) isn't factored into the EHP calculations.

[Almagnus1]

Is there an easy way to account for the arcane helmets?

[Spuddy7]

You should add Scarab Armor to the Warframe Abilities

[Jonas_T_acc]

Arcane Guardian is 150/300/450/600 flat armor increase now instead of 15/30/45/60%, otherwise it looks good.

[(PSN)haylbeee]

I made a copy and it's broken

[Lurieh]

To repair the sheet :

-unfold columns after "P" (Q etc)

-select cells Q5 and R5, copy them

-select cells from Q6 to R23, paste

That's it ! The 8th row is skipped, probably from an inserted row in between.

Also you have to make your own copy of the file before you can edit it.

Edited June 17, 2018 by Lurieh

[(PSN)supernova_girlie]

On 2017-11-24 at 7:38 AM, 13QZXXTTX said:

Thanks for the Effort!

WF Builder?

I also recently found out that Inaros + Vitality + Primed Vigor up to 5830, not 5900 :segh:.

Don't forget Gladiator Resolve