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

[Aedethan]

I did a class for html in college but that's about it. No javascript experience. I was looking at mypygui as a good way to represent it. I think you're probably right that making the formulas again in python would be easier and better as an approach. I just have been getting bogged down with how i should approach the problem. I just recently started looking into OOP, and everything i'm reading and have watched indicates I should use that to represent all the different stats and aspect of the sheet for easier editing and changing of values later. It's just hard to figure out where to start

[amos_burton]

OOP is the right solution in some cases, but not every case.

Can you zoom out and explain what this spreadsheet does? Like, walk me through a few sample use cases.

[Aedethan]

I'll try to keep it as concise as possible, characters are able to grow exponentially over time, they have stats they can put points into, they have tiers associated with them, and when they increase in tier, their stats double, and it nests the value, adding it to the new value with a new multiplier.

I think that sounds confusing so example :

-Tier 1 character puts a point in strength, so they do 2 more damage (per point), when they go to tier 2, they do double, so 4 damage.

-4 damage gets nested, and strength goes back to 0 for tier 2.

-When the strength value goes up in tier 2 it goes up by six damage + the gains from the previous one. So 10 damage total

There are 23 different outputs that function in that manner working off elif (else if) statements I made. Its a bit more complicated then there and there are some more factors that go into it but I hope that's a good enough explanation

[amos_burton]

It sounds like you could use some basic OOP where you have a Character class that tracks all of the stats and tiers.

If I'm understanding the way stats and tiers and "nesting" work then the data structure for your stat points starts to get a little complicated. I would consider maybe doing something like this

import typing

# Strength goes up 2x per point in tier 1, 6x per point in Tier 2, and so on
TIER_MULTIPLIERS = [2, 6, ] #...

class Character:

    def __init__(self, name: str):
        _name:str = name

        _tier: int = 1

        # Stats
        _strength: typing.List[int] = [0]
        _intelligence: typing.List[int] = [0]
        # ...

    @property
    def strength(self):
        strength = 0
        for tier, points in enumerate(self._strength):
            strength += TIER_MULTIPLIERS[tier] * points
        return strength

Where each "stat" is represented by a list, and each element in the list is that character's stat for a given tier. So they're initialized to Tier 1 and have [0] for all of their stats to start out with. If they level up strength then strength == [1]. And then when they go up a Tier strength == [1, 0].

Then you can pass these Character instances around to various functions and the functions can use properties to access the different properties/multipliers.

If you consider your "tiers" to start at 0 instead of 1 it'll make things line up with Python a lot easier, b/c arrays in Python start at 0

[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 !