Lately I've been calculating a lot. Stats mainly. Then while browsing KaW's forums, I came across a user who created a "Build" calculator. Which got me thinking, "Hey since I'm tired of calculating why don't I make my own calculator to calculate my calculations?". Then I decided to make a PIMD version of the "KaW Build Calculator". As of right now, it's only function is to calculate T6 stats. All you can currently do is calculate a dream build. I plan to add much more to it including tier 1-5 and make it look simple and clean. You WILL need a spreadsheet app on your device. I made this on MS Excel so if it doesn't work properly on your device's spreadsheet app I'll try my best to get it working. If on a computer, click here. Then click "File", "Open with", "Google Spreadsheet". It will be added to your Google Docs so you can freely edit it. If on a mobile click here for a direct download link, then open it with whatever spreadsheet app you use. -Instructions- Usage is simple, all you have to do is add the number of crew members you have into the "added" section (red[/color=red] numbers) then your stats will appear in the yellow rectangle to the side. *Changelog* v1.3 - 2/7/14 -Text changes -Store items added (stat) -Avatars added -Removed untrue calculations v1.2 - 1/23/14 -Formatting -Cleanliness -Organization -Pupil Bonus -EC Total -Money Total v1.1 - 1/21/14 -Formatting -Cleanliness -Organization -Max TB -Dorm prices -Fixed l4 crew not calculating v1.0 - 1/21/14 -Added T1-T5 with all stats and prices -Text changes -Added T1-T5 stats and prices -Added pretty organizational color v0.1 - 1/20/14 -Initial Release. Thanks to: Dark_assasin_lIllI (in KaW) who has http://forum.kingdomsatwar.com/viewtopi ... =6&t=28046]this thread[/url] including his own KaW calculator which I am looking at to get ideas on how to format my own. SaintNicholas for answering a few of my questions regarding crew stats. Most importantly, thanks to the PIMD community for supplying most of the numbers and info required to make such a thing exist.
I think this has to be a sticky before I can request an update to the first post . Anyways, I updated the calculator with a few things. v1.0 - Text changes - T1-T5 prices and stats (so now everyone can calculate their stats or make your own dream build with whatever tier crew) - Added organized color for pretty ness The original link should point to the updates version of the calculator. Also, here's another picture of how its used. All you have to do is add a number anywhere in the red area (or really just change any red number) then your stats will appear in the yellow area.
I built one up to t-5 (haven't updated with t-6 yet) it includes cost of dorms etc in it as well as what your tb needs to be at your stats to be maxed, pm me and I'll gladly sent it to you op. if you want to look at it
Hmm. Making an app out of it WOULD be rather neat. If I knew how to make it ?, though its in my interest .
The updates version had a few issues with level 4 numbers so I fixed that and added a few things . Like before the same link should direct you to the newest version. 1/21/14 v1.1 -Formatting -Cleanliness -Organization -Max TB -Dorm prices -Stats to pupil -Fixed l4 crew not calculating The next update should add much more, including base store items (limited time items like taco cat and whatnot), stat items and whatever else I come up with. Pots will come later while I learn more about them. Also, if you have any feedback please wall me or post here, suggestions welcome too .
That's great lol. Perhaps we can be nerds together and make it more compact. There's currently 1 hidden cell (in the version I'm working on) that was pissing me off due to a function not doing what I wanted ?.
Formulas piss me off. But I'm enjoying this . The next version will either take a long time (few days to a week?) depending if I want to focus on adding the store items or not. I've finished adding the avatar bonus and money needed to actually have the build you want. Though I won't update it until I add more. Try it out doe .
Minor things changed and few things added. Original link is updated. I originally planned to at least release this version with store items included but I was having trouble with the formula and have to get it working ?. If you have any issues or find typos/mistakes please let me know ASAP on wall or here . I don't think the OP is clear on editing this file. There's two ways: [li] 1. Download the file to YOUR Drive account, then select it and open with "Google Spreadsheet".[/li] [li] 2. Download the file to your device or computer and use your own spreadsheet app/program to edit it.[/li] Hope the list works ?. Also, only worry about changing the RED numbers. Feedback and suggestions welcome (as I'm running out of ideas of what to add). v1.2 1/23/14 -Formatting -Cleanliness -Organization -Pupil Bonus -Stats with bonuses applied -EC Total -Money Total -Fixed Max TB Formula -Avatar percent bonus -Checkmark to determine bc status
Not an app, that's dumb. But maybe a section on pimd ?like the feedback button? Or make an HTML app. Simple and fast to make.