[Solved] Increase rankings in RPG with experience points

[Rydviking]

I have a project that requires some mathematics that I'm having trouble with.
What my intention is like buying something. Say there's 859 dollars in your account and you want to buy something that already has a numeric value of 5. In order to make the value of 5 into a 6, you have to spend the original value (5) x10; meaning that out of the 859 it will cost 50 dollars to increase the value of the cell from a 5 to a 6. The same process is applied to make the new value of 6 into a 7, meaning that you will need 70 dollars to convert the original value of 6 to a value of 7; leaving 739 dollars in the account; and so on to a maximum of 30 for the cell being purchased. This will be applied to multiple cells on an individual basis until a maximum of 30 is reached.
Any help would be greatly appreciated.

Edit: Changed subject, was Help, please  Make your post understandable by others  -- MrProgrammer, forum moderator

[Alex1]

What is the required result? And what is the relationship with spreadsheets?

[Rydviking]

I want to be clear to whomever reads this. I'm working on a tabletop rpg. The previous request is an example of how experience points are spent for the character.
The available experience points would be represented by the "bank account" in the original post. The rank of whatever attribute and/or skill being increased is represented by the numeric value of the cell represented by said attribute and/or skill. The cost of increasing the numeric value of the skill and/or attribute cell is 10x the current value to increase by 1, using the "account" as a pool for experience points to spend.

[FJCC]

The rule for spending your experience points is clear, but I don't understand what you want to do. I assume you will have a list of traits and their current level. Do you want to be able to enter possible new levels for some traits and see how much that would cost? Or do you want to optimize the spending in some way?

[Rydviking]

This TTRPG doesn't use levels in the traditional sense of most RPG's. There are 12 attributes that support 50 skills that define what a character can do, and their ability to perform these skills.
I'm trying to provide a better means of accomplishing this digitally.
At the moment it's a manual process of taking the existing rank of whatever attribute and/or skill and multiplying by 10, this is the amount of raw experience needed to advance to the next rank in whatever attribute and/or skill being leveled up. I'm trying to automate this process.

[Rydviking]

If a character has 350 raw experience points. They want to purchase their 4 Strength to a 6. The process is to apply each new rank individually.
Strength 4 to 5 requires 40 raw experience to achieve. Then Strength 5 to 6 requires 50 raw experience points to achieve. Not 4 to 6 is 2 ranks at a cost of 20 raw experience. This is to govern the speed of character growth and development without becoming too powerful too fast.

[Rydviking]

Something like: =((cellX*10)-cell raw experience)adds 1 rank to cellX.
The equation needs to be able to be applied individually to whichever attribute and/or skill being purchased.
Hopefully also keep a running tally of spent experience

[MrProgrammer]

They want to purchase their 4 Strength to a 6. The process is to apply each new rank individually. Strength 4 to 5 requires 40 raw experience to achieve. Then Strength 5 to 6 requires 50 raw experience points to achieve.

To increase a skill from X to Y will require N points where N=(Y-X)*(Y+X-1)*5. In your example X is 4 and Y is 6. Thus N is (6-4)(6+4-1)*5 = 2*9*5 = 90 points (40+50). To increase it from 4 to 8: N = (8-4)(8+4-1)*5 = 4*11*5 = 220. That's what you get adding 40, 50, 60, and 70.

If N is known but Y is not, Y is one half of 1+√(1+.8N+4X²-4X). So when X is 4 and N is 220, the expression is 1+√(1+176+64-16) = 1+√225 = 16. Y is one half of that or 8. For general N this will not be an integer, so round up or down, depending on your objective.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Rydviking]

That's a good representation of the math for the conversion of raw experience into applicable experience. How would you apply this in a practical manner to the individual attribute/skill ranks for when a player spends experience on them? This equation is a good calculator though. I appreciate your input and effort.

[FJCC]

Without an example of your spreadsheet layout, it is very difficult to give specific advice. Please make a small example document and upload it with a explanation of how it would be used.
To upload a file, click Post Reply an look for the Attachments tab just below the box where you type a response.

[Rydviking]

Here's a very basic version of what you should need. The file is called: Untitled_EXAMPLE

[Rydviking]

Any ideas on how to apply this calculator to individual cells that represent the attributes and skills ranks? Or is this just a calculator? I am grateful for what has been accomplished thus far, but if we're done and this cannot be applied in such a way. I'd rather not keep sharing, even if it's only a tiny sliver of my game, if we can't go any further with the application of this well thought out calculator.

[Rydviking]

thanks for the help