Visual Automatic Actor Stats Table With Corresponding Monster Stats Table

じ☆ve冰风

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?:

• 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.
  

Editing Monster Stats

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!

SpoilerHere'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.



Bugs?:

• 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. 




本贴来自国际rpgmaker官方论坛作者:Cjdgame处,因国际论坛即将永久关站,为了存档多年珍贵资料,署名转载到本论坛存档,由于官方帖子为英文原帖，需要中文翻译请点击论坛顶部切换语言为中文就可以将帖子翻译成中文浏览,方便大家随时查看,原文地址：https://forums.rpgmakerweb.com/threads/visual-automatic-actor-stats-table-with-corresponding-monster-stats-table.47980/