- Joined
- Dec 4, 2013
- Messages
- 100
- Reaction score
- 12
- First Language
- English
- Primarily Uses
I don't know about anyone else, but I'm a very visual worker. I need to be able to see the information at hand to be able to work with it, especially with RPG Maker where I need to base other things stats based on a classes stats. Because of this, I decided that the only real way for me to do this was create a formula to determine what the value of the stat was per given level. To do this, I used the formula for a line (y=mx+ b...only in convoluted excel fashion. On top of this, after reading Garler's "Making a Balanced Game" http://www.rpgmakervxace.net/topic/4933-making-a-balanced-game/ I decided it'd only make sense to include formulas on determining the stats of monsters for a given level class.
You can find the spreadsheet here
https://docs.google.com/spreadsheets/d/10LPOoMrAgyBlQ02VpkAlN2GxzQTDYb0p-wHh-MwAY8k/edit?usp=sharing
To use it you can either download it to your computer and edit it in excel or make a copy of it to your google drive and edit it.
Editing Player Stats
How it works is fairly simple. You edit the gray values in the Level 1 row to your level one value, and then edit the values Level 99 value to your level 99 value (EVEN IF YOU'RE USING A LOWER LEVEL CAP).
"It can't be that simple
" ...yes, I guarantee you it is. I have set it up so every other value in the player columns works off of those editable level one and level ninety-nine stats using the equation of a line,
Bugs?:
Now, if you agree with Garler's default formulas for determining values, then everything should be good and squared to go! If not, changing them is simple. Simply type = into the first rows box under monster stats, then click on whatever number you want to reference and type in a formula.
Ex. Say box C3 under the player stats had value 30 ATK and we know our monster has to have 10% more attack. Simply type = in the ATK in the first row of the monsters attack, click the players attack (a colored C3 should appear next to the equals sign) and then times it by 1.1.
"I'm not good with working with excel though!
" Don't worry, since I'm giving the community this tool I won't abandon you!
Bugs?:
Thank you for reading this far! I hope you can find use of this excel sheet! If you use this sheet in helping you designing your encounters and monsnter stats it'd be nice to get some credit
Credits: To Garler for the making the "Making a Balanced Game" thread.
You can find the spreadsheet here
https://docs.google.com/spreadsheets/d/10LPOoMrAgyBlQ02VpkAlN2GxzQTDYb0p-wHh-MwAY8k/edit?usp=sharing
To use it you can either download it to your computer and edit it in excel or make a copy of it to your google drive and edit it.
Editing Player Stats
How it works is fairly simple. You edit the gray values in the Level 1 row to your level one value, and then edit the values Level 99 value to your level 99 value (EVEN IF YOU'RE USING A LOWER LEVEL CAP).
"It can't be that simple
" ...yes, I guarantee you it is. I have set it up so every other value in the player columns works off of those editable level one and level ninety-nine stats using the equation of a line, Bugs?:
- Certain values may be one point off as compared to whatever version of RPG Maker you're using due to rounding differences.
- If you have a stat graph that isn't a straight line between two values (As in you've sped up or slowed down the stat curve away from average), you will probably run into errors.
Now, if you agree with Garler's default formulas for determining values, then everything should be good and squared to go! If not, changing them is simple. Simply type = into the first rows box under monster stats, then click on whatever number you want to reference and type in a formula.
Ex. Say box C3 under the player stats had value 30 ATK and we know our monster has to have 10% more attack. Simply type = in the ATK in the first row of the monsters attack, click the players attack (a colored C3 should appear next to the equals sign) and then times it by 1.1.
"I'm not good with working with excel though!
" Don't worry, since I'm giving the community this tool I won't abandon you!Here's a small excel lesson that will make your life 20x easier. Excel has this nifty auto-fill feature that will progress a certain set of numbers or formula. This can be done by highlighting something and clicking the bottom right corner and dragging (See picture)
But here's the problem. When we try to auto-fill in a direction it changes ALL THE VALUES. For example, auto-filling down with a formula =A1*1.5 makes the next value =A2*1.5. Auto-filling to the right changes it to =B1*1.5. So when does this become a problem? Well when we want to auto-fill but keep the some column letter or number!
To fix that, simply place a $ in front of the value you don't want to change. So say we wanted to keep the column letter in our example our formula would be =$A1*1.5 making it so an auto-fill to the right or left keeps that letter. If we want to keep the row number simply do =A$1*1.5 so that an auto-fill up or down keeps that row number. Or you can keep both!
"Do I have to do all this work again for a different class? " No, simply copy the page/sheet to another page using the tabs on the bottom of the screen. From there you'll only need to edit the classes stats.
And that's all you need to know if you change the way monsters stats work,. Note: These monster stats should just be used as base, it only reflects what a monster vs. this one class. Remember that you may want to compare other classes average party values and maybe even fidget with their stats to suit your needs.
But here's the problem. When we try to auto-fill in a direction it changes ALL THE VALUES. For example, auto-filling down with a formula =A1*1.5 makes the next value =A2*1.5. Auto-filling to the right changes it to =B1*1.5. So when does this become a problem? Well when we want to auto-fill but keep the some column letter or number!
To fix that, simply place a $ in front of the value you don't want to change. So say we wanted to keep the column letter in our example our formula would be =$A1*1.5 making it so an auto-fill to the right or left keeps that letter. If we want to keep the row number simply do =A$1*1.5 so that an auto-fill up or down keeps that row number. Or you can keep both!
"Do I have to do all this work again for a different class?
" No, simply copy the page/sheet to another page using the tabs on the bottom of the screen. From there you'll only need to edit the classes stats.And that's all you need to know if you change the way monsters stats work,. Note: These monster stats should just be used as base, it only reflects what a monster vs. this one class. Remember that you may want to compare other classes average party values and maybe even fidget with their stats to suit your needs.
- There really shouldn't be any since using this setup monsters stats are completely based on the players stats.
Thank you for reading this far! I hope you can find use of this excel sheet! If you use this sheet in helping you designing your encounters and monsnter stats it'd be nice to get some credit
Credits: To Garler for the making the "Making a Balanced Game" thread.
Last edited by a moderator:
