Database Game Balance Tool (Excel & VBA)

[Kalithro]

DamageCalculations.xlsm version 1.0a

http://youtu.be/cMLnoBOCx9Q  -Quick video on how to run damage calculations (Party vs Enemies & All Level All Skills).  Quick guide though the UserForm

Edit 2013-09-03 (More Videos)

http://youtu.be/G2jlNnols2k  -Quick video on setting up groups of mobs and adjusting enemy stats based on damage calculations (just an example)

http://youtu.be/4UTyCNMA8-o -Another video detailing skill scaling.  A quick look at some easy skills to setup that scale with player level.

For Safety- Using Microsoft SkyDrive

Edit, Will open in Excel.  Can then just SaveAs.

http://sdrv.ms/15JsFNg -Link to DamageCalc.xlsm

Read the Cover worksheet for more information.

What can it do;

You must first... Populate with your games data (currently default RPG Maker VXA data is left in the workbook).

Group Attack ON (Option 1)
Player's Party vs Enemy's Party.  Each Player and Enemy gets 1 turn per round (Until Dead).  Turn order is based on player Speed.
Speed is calculated based on RPG Maker VXA defaults.  Turn order is determined then damage is calculated and applied.
Only Player and Enemies with a Logic of TRUE will be in the fight.
 

Group Attack OFF (Option 2)
This is used to determine 1 on 1 battles.  Actor 1 will fight all Enemies (1-5) one at a time, then Actor 2, and so on.  Use this to
determine how much damage will be done based on the variables you have defined with the userforms.
Use this for very focused selections.

All Level Skill Calc (Option 3)
This options is used to do the following.  Each Actors with TRUE logic will advance from the min level you define to the max level you define.  Actors will use the
highest level dmg skill (not necessarily the highest dmg skill) for the level they are currently at.  Actors for each level (and skill selected) will attack each
enemy that is defined with logic TRUE.  The Dmg, Skill Formula, and Skill Formula with Numbers will be Exported.

Each Enemy with TRUE logic will attack each Actor with TRUE logic from there defined min level to their max defined level.  Each dmg based skill the Enemy has will
be calculated as well.  The Dmg, Skill Formula, and Skill Formula with Numbers well be Exported.

Pics...


free screenshot software

.

.


image post

To Run or Open UserForms.  Go to DamageTable worksheet and right click any cell (or double click).

Please let me know what is / isn't working so I can fix it.  Also let me know what is / isn't clear so I can modify and explain things better.  The VBA code is not locked, so feel free to pick this apart.  In doing so, also be cautions of other versions from other people. 

Kalithro

 

[Shaz]

I'm going to move this to Program and Utility Discussion


Looks nice. Does the database have to be populated manually, or can you run a script to export it in the right format? A video of the whole process would be awesome, if you could make one!

 

[Kalithro]

I'm going to move this to Program and Utility Discussion

Looks nice. Does the database have to be populated manually, or can you run a script to export it in the right format? A video of the whole process would be awesome, if you could make one!

The data is entered manually

The game data is encrypted (*.rvdata2).  Maybe there is a way to export database data to ascii similar to how "Script Import/Export to File by GubiD" works for exporting Scripts (by starting a play test).  That however, is way beyond what I would be capable of doing.  Such a script (or way of exporting database data) would be a huge benefit to game development with RPG Maker).

 

[Shaz]

I've already got one partially done, but it won't take much effort to write a new one for your purposes. You send me a PM telling me how you'd like it set out (I can do text with delimiters, so just tell me what columns from each database tab you want, what you'd like the files to be called, and whether you want them in the Data folder or elsewhere), and I'll write you an exporter script. Then it'll be up to you to figure out how to get the individual files into your spreadsheet.


This tool could be really useful, but having to key everything in manually will turn people off. Let's fix that


Uh ... I'm just having a look at the spreadsheet now, and I don't see where you actually run it. I can see the tabs for all the tables, but I don't see the user form(s). When I downloaded, it didn't make me go through all that stuff you said. It told me I couldn't open it in the browser, and when I clicked OK, it downloaded the .xlsm automatically. Is that all I should have?

 

[Kes]

I can't download it at all.  When I click on the link I end up at a screen telling me it can't be downloaded because the feature "Workbook Protection" is in place.

 

[Kalithro]

I've already got one partially done, but it won't take much effort to write a new one for your purposes. You send me a PM telling me how you'd like it set out (I can do text with delimiters, so just tell me what columns from each database tab you want, what you'd like the files to be called, and whether you want them in the Data folder or elsewhere), and I'll write you an exporter script. Then it'll be up to you to figure out how to get the individual files into your spreadsheet.

This tool could be really useful, but having to key everything in manually will turn people off. Let's fix that

Uh ... I'm just having a look at the spreadsheet now, and I don't see where you actually run it. I can see the tabs for all the tables, but I don't see the user form(s). When I downloaded, it didn't make me go through all that stuff you said. It told me I couldn't open it in the browser, and when I clicked OK, it downloaded the .xlsm automatically. Is that all I should have?

Yes, only 1 xlsm file.  To run do ctrl+m or go to DamageTable Worksheet and double click any cell or right click any cell to bring up the userform (big green button runs the calculation).

 

[Kalithro]

I can't download it at all.  When I click on the link I end up at a screen telling me it can't be downloaded because the feature "Workbook Protection" is in place.

Macro Enabled workbooks won't open in a browser nor will this due to protected workbook.  That is fine, you don't need to open in browser.  Just click ok and then you are prompt to save or open in Excel.  I added screen shots to clear this up.

 

[Jonforum]

hey friend , you link are death, can you update ?

 

[Andar]

@Jonforum if you check his profile, the OP was last seen Oct 2013 - five years ago.
I really doubt that he's still checking in...

 

[Jonforum]

@Jonforum if you check his profile, the OP was last seen Oct 2013 - five years ago.
I really doubt that he's still checking in...

i am searching a tool similar to this but in excel sheet.
http://yanfly.moe/tools/enemylevelcalculator/
I need a basic modele for work, if you have an idea or a good link to other threads , it would be super nice.
I search in the forum, but i get only this threads.
Thank you.