Durg's RPG Developer Tool (Microsoft Excel Spreadsheet)

[Durg]

Durg Presents...

Durg's RPG Developer Tool 1.2a
While I am developing my GM style RPG map, I ran into one issue - how would I know how my heroes would develop, when would I be able to send certain monsters at the players and how would I know how many of each monster to send?

My solve - the developer tool. I'm still working on it, and it lacks features that I plan on adding (such as support for armor calculations), however it is fully functional and should work great.

Note: This is a Microsoft Excel worksheet. Does not include any macros; if you recieve an error message saying there are unsafe macros, please make sure you choose not to run them. They were most likely in there by error, and I have not intentionally placed any. Remember, macros can seriously harm your computer. Never run any untrusted Macros.

http://www.durgonet.com/RPGToolv1.2a.rar (176kb)

11:03pm EST November 30th/06 - v1.2a Release
1. Increased amount of heroes from 16 to 30 (request) - If you guys experience any issues with the slots below 16, I have not fully tested them; please give me feedback on this.
2. Added "Enemies - Advanced" tab, which shows how much health an enemy would end up with after going into combat with a player (if any) (request)
3. Fixed some issues I had found with the auto-formatting on the Enemies sheet, as well as made some changes on the conversion page.

4. On "Enemies" tab, changed the enemies into a list format so that you can filter out creeps. Unfortunately, sorting is not available due to cell locking... Looking for workaround now...

Notes on Release: The filesize... well, 100x'd itself! Due to the new page to calculate HP, there are a LOT more calculations. If you guys don't find this feature useful, tell me and I will remove it. *** Error was found, actually added an additional 100000 lines on one of the pages. Ooops! ^_^;; anyone who tried to download it please try again.

10:56pm EST November 26th/06 - v1.1a Release

1. Resolved issues with Enemies form - fields would not properly highlight when the monster would die. Also, made every section in the editable area selectable, to support any copy and paste functionality for future releases.

2. Added WCIII Unit Conversion Page. This shows you the strings/raw values in the unit editor that needs to be changed.

3. Split the Hero page and the Combat Calculations page up, and left page unlocked so that if someone is using the tool, they don't get stuck with having to redo the heroes over and over again to upgrade to a new version.

If you guys see any issues, please report them in here; also, if you have any requests or recommendations, feel free to tell me. Note that this is an alpha version; the full version will have further calculations.

[Durg]

I forgot the most important thing... Screenshots! ^_^

[seph ir oth]

I like the ideas, the efforts, and that you stated warnings about any sorts of macros running amuck on people's computers.

+Rep

[Durg]

I appreciate the kind comments. ^_^

Also, the units and monsters are a sneak peak of what I have in my map, forgot to mention that.

[Durg]

v1.1a released; tell me if there are any further issues.

As a web developer, I'm considering making an ASP version of the tool. Any demand? If no one is interested I won't waste my time... ^_^;;

[Andrewgosu]

This is quite good! It would be even better, if you could turn it into a program, which doesn't need excel.

[Durg]

In other words, you think that an ASP version would work?

For these who don't know, ASP is a form of web scripting, like PHP. My idea for an ASP version would allow you to log in w/ username and password, select a project (you can have multiple, and you can modify the users that can view/modify the projects)

[Chocobo]

You forget the armor.


There should be more lines for heroes.


In Hero Calculations, you should center Base Statistics at said Level.

Hey, your table is protected in some cells?


In Gameplay Constants, HP Regen Bonus and MP Regen Bonus are preset to 0?

[Sooda]

Program versions are always cool. You have done very good work, I' m novice in doing balancing for creeps and I can' t see the potential of it beacuase I don' t understand its features. I' m trying to do myself RPG styled map too and it could be bretty awsome if it could eas my work. Doing such a massive task on your own sure is hard so don' t forget to rest too. Many thanks for shearing it with us.

EDIT: If there could be function what lets you save all your charts in a text file would be neat.

[Durg]

In order to add such a function, I would require the usage of macros, and macros are bad...

You forget the armor.

My solve - the developer tool. I'm still working on it, and it lacks features that I plan on adding (such as support for armor calculations), however it is fully functional and should work great.

There should be more lines for heroes.

I'll add another 14 next version, totalling 30.

In Hero Calculations, you should center Base Statistics at said Level.

It is centered?

Hey, your table is protected in some cells?

That is to prevent people from modifying the formulas, throwing the balance of the sheet off and to prevent people from stealing the idea. ;P If there're any cells that should not be protected, please be more specific.

In Gameplay Constants, HP Regen Bonus and MP Regen Bonus are preset to 0?

These values are all modifiable - the sheet is configured for my RPG; these are the values that will be on my RPG.


I'll be working on v1.2 today, which will take the sheet out of alpha and I'll have base calculations for armor complete. Feel free to provide more feedback. ^_^

[Weyrling]

you could try adding in a formula for a certain % of evasion/criticalstrike, this should help me alot, since I'm making several maps, and one involves large number of different creeps, you could try adding a part that tells how close they came to dying, other than the will die, or may die thing, so its easier to fine tune even more (i.e. the kobold has 2hp left, rather than may die). I'd like to see an actual program version, too.

[Durg]

Hey; Thanks for the feedback - I'll add the HP thing in the next version; I'll add the evasion formulas with the armor formulas - I'm having a hell of a time developing the armor formulas as it is Expect another release tonight hopefully. If not, it'll be tomorrow night.


Edit/Appended: I appologize, the evasion formulas will be part of the combat simulator I'm developing. The simulator will allow you to put hero vs hero, hero vs monster, monster vs monster and party vs party. When you're talking the one on one combat, you will be able to add variables (such as buffs/abilities) and see the results of 10 rounds of combat, and the odds of each side winning.

[Chocobo]

Originally Posted by Durg

Hey; Thanks for the feedback - I'll add the HP thing in the next version; I'll add the evasion formulas with the armor formulas - I'm having a hell of a time developing the armor formulas as it is Expect another release tonight hopefully. If not, it'll be tomorrow night.


Edit/Appended: I appologize, the evasion formulas will be part of the combat simulator I'm developing. The simulator will allow you to put hero vs hero, hero vs monster, monster vs monster and party vs party. When you're talking the one on one combat, you will be able to add variables (such as buffs/abilities) and see the results of 10 rounds of combat, and the odds of each side winning.

Ourgh party vs party. Will handle at least 40-45 variables. Not good to do that. PvNpC/P stills good, but if you do a party vs party, I would like to see that.

I have a tutorial about formulas used by Warcraft III, should be in my signature.

[Durg]

Thanks - I appreciate the link; I'll have a look at that. I've gotta sit down and finish the armor issues.

And about the party vs party thing; That's scheduled a LONG LONG LONG way down the road - I work a full time job at as a Sprint Nextel Customer Care agent, and I'm a freelance graphics designer/web developer - this is a project in my spare time. ^_^

v1.2a -
1. Increased amount of heroes from 16 to 30 (request) - If you guys experience any issues with the slots below 16, I have not fully tested them; please give me feedback on this.
2. Added "Enemies - Advanced" tab, which shows how much health an enemy would end up with after going into combat with a player (if any) (request)

3. Fixed some issues I had found with the auto-formatting on the Enemies sheet, as well as made some changes on the conversion page.

Link will be posted in main post shortly!

[Durg]

New screenshots