Hello, I’m looking for a tool or some code that could help me keep track of all my numbered variables.
To put it simply, I want to calculate precise averages of certain values based on player choices, and generate all possible combinations of choices along with their corresponding variable outcomes.
For example, if I pick Choice 1 in Scene 1, Choice 3 in Scene 2, and Choice 1 in Scene 3, I might end up with 150 cash, 76 loyalty, and 65 charisma.
If instead I pick Choice 1 in Scene 1, Choice 3 in Scene 2, and Choice 2 in Scene 3, the resulting values will be different.
Even with a set of only 3 choices for 3 scenes the total possibilites is already 3^3 (=27), then you take an average set of 3 questions per scenes and 40 scenes, it does : 3^40, which is an absurd amount of possible choices, and by no way manageable.
So, is there any way to efficiently track these values? I understand 3^40 is far too many combinations to compute exhaustively, but maybe the process could be broken down. For instance, if you process 10 scenes at a time (3^10 combinations) in one file, you could then calculate accurate averages and use those as a base for decisions in the next file, and so on.
Maybe I’m overcomplicating things and this approach isn’t necessary. If so, I’d love to hear how you keep track of your variables and ensure that choices and conditions don’t end up feeling unrealistically hard or easy.
Personally, I currently use Excel to note every choice, its outcome, and the variables it affects. I then calculate the minimum, maximum, mean, quartile, and median values at the end of each file to balance things out.
I’d love to hear your thoughts and suggestions.
