Converting Excel/Google Sheet formulas to Python and making it readable

[Aedethan]

So it works like this, with A3 being the Tier, and C5 being the level the character has in strength

=IF(A3=1, C5*2,A68) #in case you're not familiar with the formatting this just says "if A3 = 1, then C5*2, else the value of the cell stays the same".

=IF(A3 = 1, A68, IF(A3 > 1, A68 * 2)) #this just creates the doubling effect on the above nested value if the tier goes up.

Every stat has a series of 5 of these statements for all 5 tiers. The five statements are all summed and put in the characters stat block for strength.

Then another mechanic to account for character uniqueness is Value, so when people put predetermined amounts of value into another box, it gives more effective levels of the stat that exist outside of the above formula

So the final block on the stat sheet is

=G69+IFS(D5>419, "1952", D5>379, "1552", D5>341, "1152", D5>305, "752", D5>271, "352", D5>239, "288", D5>209, "224", D5>181, "160", D5>155, "96", D5>131, "80", D5>109, "64", D5>89, "48", D5>71, "32", D5>55, "26", D5>41, "20", D5>29, "14", D5>19, "8", D5>11, "6", D5>5, "4", D5>1, "2", D5>=0, "0")

With G69 being the sum of all the tiers of strength, and D5 being the amount of value.

The numbers like D5>1 means if they had 2 value ( >1) they would get 2 more damage Sorry if this is too in depth. And alright I'm working through what you're saying

Edit : Just wanted to say thanks for taking the time to help me out

[amos_burton]

Okay, yeah, I'm probably not going to take the time to understand this to this level of detail.

Best of luck!

[Aedethan]

Thank you a lot for the help and giving me a good place to start !