Tivie's NPC Battle Calculator (TNBC)
LAST UPDATE - 09-07-27
It would be most appreciated if you can test and counter test with real ingame battles. If you could post battle reports with ballistae only, against NPCs specifying NPC level, your techs and stuff it would be a great help in my research (specially NPC lv6 and higher)
INTRODUCTION
This is a excel spreadsheet I made for calculating transporters, troops status, battle movements and troop losses per turn.
I know there are other other excel spreadsheets around, but I think mine is unique because it gives you an insight of what happens every turn.
You can use it for for calculating NPC attacks as well attacks versus other players (though, for now, in PvP is kind of limited)
If you have any question, don't hesitate asking.
What does this Spreadsheet do?
- Troops Status modified by techs (Attack, defence, life, etc)
- Number of troops of a given NPC lv
- Number of transporters and Ballista needed to attack a NPC, based on techs
- Troop losses
- Battle Report with Round-by-Round events
Known Issues
- Trebuchets attack power still unclear (needs more testing)
- Hero attack not working
ScreenShots
Main Window
http://img38.imageshack.us/img38/1750/screen1jec.th.jpg
Techs and Troops Window
http://img38.imageshack.us/img38/8205/screen2qfk.th.jpg
Report Window
http://img38.imageshack.us/img38/9781/screen3ksg.th.jpg
INSTRUCTIONS
You need to activate macros for it to work. To do so, open Excel, go to Tools>Macros>Security. There select Security level "Medium". This way, every time you open an excel spreadsheet containing macros, it will ask if you wish to run macros or not.
Openoffice Users: www.openoffice.org (Thanks to THEBIGPOTPLANT to pointing and solving this issue!)
this applies to openoffice software ONLY
There is only one more setting to change besides security.
step 1: go to top click tools go to bottom of drop down click "options"
step 2: inside there drop tree of "openoffice.org" and click "security" followed by clicking "options" within those settings displayed, change security to medium or low (i used low).
step 3: drop tree of "load/save" click "VBA properties" and tick option "executable code" in excell 98/2000/xp
DOWNLOAD
Version 2.6 (09.07.27)
Download (rapidshare)
Version 2.5 (09.07.26)
Download (rapidshare)
Version 2.0 (09.07.11)
Download (rapidshare)
Updates
version 2.6 - 09.07.27
.: Trebuchets added (though it's still unclear what they target first and their atk power)
.: Archer Tower + HBR bug corrected
version 2.5 - 09.07.26
.: A more easy reading battle report, with turn based events
.: Interface rebuilt (step by step interface)
.: Some other minor updates
.: Troop loss calculation (BETA, still in test - Feedback is appreciated)
Programmed to future release:
.: PvP (player versus player) battle calculation with troop losses from both attackers and defenders
.: Hero attribute formula correction (currently hero attack is broken)
DISCLAIMER: This spreadsheet was made by me, from scratch. Feel free to use it as you like, but don't forget to credit me if you find it useful and post it in other forums. Also, use the link provided here or link back to this page. I might update the file without previous notice. You may not change or use the source code, formulas or any contained info in the spreadsheet.
DON'T FORGET TO SAY THANKS AND RATE IT (THE STARS AT THE TOP). HELPS KEEPING THIS POST ALIVE!!!