Nicholost
03-27-2012, 09:33 PM
The Crime City iOS Stats Calculator v1.0 is now public. The tool is based off the Crime City iOS Money Buildings spreadsheet's (https://docs.google.com/spreadsheet/ccc?key=0AgEHrvnoijXudHFVU2RxYUQzYXYtOURRd0d3M1hVR 2c&hl=en_US&pli=1#gid=0) Items tab. Thank Tramp Stamp for that one because this tool would not be possible without the item data from that spreadsheet. Also, a nod goes out to white frog, Ramshutu, and Whip88 (Natas), who integration-tested and bug-checked the tool prior to initial release. Their effort is much appreciated. Next time you see 'em on your rivals list, move on to the next victim.
What it does:
The tool shows you what your actual attack and defense stats are for each weapon category. It also shows what your weakest item is for each category and how many of that item you are using in battle (attacking or defending). This is valuable when identifying weak areas and how to improve them.
What it doesn't do:
Currently, a lot. There is definitely room for improvement, but I have a fair bit of time into it already and feel it is "good enough." My reason for using Google Code is for both revision control and so other people can be brought on as developers and sustainers; keeping the item list current, implementing new features, and fixing bugs.
How to make it work: Download and save the latest version of the Crime City iOS Calculator here (http://code.google.com/p/crime-city-ios-stat-calculator/downloads/list) or...
http://code.google.com/p/crime-city-ios-stat-calculator/downloads/list
Open the file and select "Enable Macros" when prompted by Excel. Macros must be enabled for the tool to function.
Enter your item and profile data into the spreadsheet. Only make entries to cells shaded in light-blue.
On the "Items" tab, enter the quantity you own next to each item. If you do not own the item, leave the quantity blank. The tool comes primed with sample data so you can test its functionality.
On the "Stats" tab, enter your mafia size and current level.
Once the tedious task of entering all your item quantities is complete, audit yourself. This can be done by comparing your item totals as shown on the "Stats" tab against those on your profile.
The sum of your guns and melee items should be equal to the number shown next to "# of Weapons." If they are no equal, you have an error in either your gun and/or melee entries.
Likewise, your armor total should be equal to "# of Armor."
Since "# of Explosives" and "# of Vehicles" are not explicitly called out on the profile screen, you will have to audit those independently.
After you have ensured all item quantities are accurate, click the "Calculate" button on the "Stats" tab. The screen will flash a few times and eventually return you to the "Stats" tab. On this tab, you will see a breakdown of your actual attack and defense stats. The total attack should match the attack shown in your game profile within ~3 units. Ideally, it should match exactly, but in some cases, it has been observed to deviate +/- ~3 units. Since defense buildings are not factored in by the calculator, the total defense should be lower than the defense shown in your profile.
If you want to see how your mafia is equipped for a certain category (e.g. Melee Defense), click the "Show Me" button next to the Weakest Attack/Defense Item in that category. The tool will take you to the "Items" tab and apply the necessary filters to order your weapons from strongest to weakest. Currently, the tool does not highlight the weakest item, so it is up to you to remember what it was. Everything above that item is used in battle. Everything below is dead weight and it taking up space.
What to do if you find a bug:
Log an issue here (http://code.google.com/p/crime-city-ios-stat-calculator/issues/list). You can post it in this thread if you want so we can help determine if it really is a bug or not, but it will not be addressed unless it is logged in Google Code. I will do my best to address the bug as quickly as possible, but I write code for a living and am not always that excited to write more on my free time. Hopefully, we can find a capable maintenance team to help with bug fixes and feature enhancements.
http://code.google.com/p/crime-city-ios-stat-calculator/issues/list
Hey, my calculated stats don't match my game stats!
First, double-check the "Items" tab to ensure your quantities entered match your game inventory. If the calculations are still wrong, triple-check them. The manual entry of your inventory is an incredibly tedious and error-prone task. There's a reason why computers do this kind of stuff for us, but as of right now, I'm not aware of a way to export your inventory, so you have to do it manually. Typically, if there is an error, it will be because you accidentally fat-fingered something. I wrote this tool and still find errors in my data entry. It happens.
If your stats are still off, post it up and maybe the community can help, but please only do so after triple-checking your entries. I know it's a PITA, but this thread could quickly get flooded with false bug reports because of bad data entry.
Hey, I have an item in my inventory that isn't in the Items tab. WTF, Mate?
No problem. Add that line-item in manually for time being. As of v1.0, there are many items that were added as one-offs. Hopefully, there are some folks willing to volunteer for maintenance and they can add any missing items and keep the Items tab up to date.
BTW, this was post #500. w00t!
What it does:
The tool shows you what your actual attack and defense stats are for each weapon category. It also shows what your weakest item is for each category and how many of that item you are using in battle (attacking or defending). This is valuable when identifying weak areas and how to improve them.
What it doesn't do:
Currently, a lot. There is definitely room for improvement, but I have a fair bit of time into it already and feel it is "good enough." My reason for using Google Code is for both revision control and so other people can be brought on as developers and sustainers; keeping the item list current, implementing new features, and fixing bugs.
How to make it work: Download and save the latest version of the Crime City iOS Calculator here (http://code.google.com/p/crime-city-ios-stat-calculator/downloads/list) or...
http://code.google.com/p/crime-city-ios-stat-calculator/downloads/list
Open the file and select "Enable Macros" when prompted by Excel. Macros must be enabled for the tool to function.
Enter your item and profile data into the spreadsheet. Only make entries to cells shaded in light-blue.
On the "Items" tab, enter the quantity you own next to each item. If you do not own the item, leave the quantity blank. The tool comes primed with sample data so you can test its functionality.
On the "Stats" tab, enter your mafia size and current level.
Once the tedious task of entering all your item quantities is complete, audit yourself. This can be done by comparing your item totals as shown on the "Stats" tab against those on your profile.
The sum of your guns and melee items should be equal to the number shown next to "# of Weapons." If they are no equal, you have an error in either your gun and/or melee entries.
Likewise, your armor total should be equal to "# of Armor."
Since "# of Explosives" and "# of Vehicles" are not explicitly called out on the profile screen, you will have to audit those independently.
After you have ensured all item quantities are accurate, click the "Calculate" button on the "Stats" tab. The screen will flash a few times and eventually return you to the "Stats" tab. On this tab, you will see a breakdown of your actual attack and defense stats. The total attack should match the attack shown in your game profile within ~3 units. Ideally, it should match exactly, but in some cases, it has been observed to deviate +/- ~3 units. Since defense buildings are not factored in by the calculator, the total defense should be lower than the defense shown in your profile.
If you want to see how your mafia is equipped for a certain category (e.g. Melee Defense), click the "Show Me" button next to the Weakest Attack/Defense Item in that category. The tool will take you to the "Items" tab and apply the necessary filters to order your weapons from strongest to weakest. Currently, the tool does not highlight the weakest item, so it is up to you to remember what it was. Everything above that item is used in battle. Everything below is dead weight and it taking up space.
What to do if you find a bug:
Log an issue here (http://code.google.com/p/crime-city-ios-stat-calculator/issues/list). You can post it in this thread if you want so we can help determine if it really is a bug or not, but it will not be addressed unless it is logged in Google Code. I will do my best to address the bug as quickly as possible, but I write code for a living and am not always that excited to write more on my free time. Hopefully, we can find a capable maintenance team to help with bug fixes and feature enhancements.
http://code.google.com/p/crime-city-ios-stat-calculator/issues/list
Hey, my calculated stats don't match my game stats!
First, double-check the "Items" tab to ensure your quantities entered match your game inventory. If the calculations are still wrong, triple-check them. The manual entry of your inventory is an incredibly tedious and error-prone task. There's a reason why computers do this kind of stuff for us, but as of right now, I'm not aware of a way to export your inventory, so you have to do it manually. Typically, if there is an error, it will be because you accidentally fat-fingered something. I wrote this tool and still find errors in my data entry. It happens.
If your stats are still off, post it up and maybe the community can help, but please only do so after triple-checking your entries. I know it's a PITA, but this thread could quickly get flooded with false bug reports because of bad data entry.
Hey, I have an item in my inventory that isn't in the Items tab. WTF, Mate?
No problem. Add that line-item in manually for time being. As of v1.0, there are many items that were added as one-offs. Hopefully, there are some folks willing to volunteer for maintenance and they can add any missing items and keep the Items tab up to date.
BTW, this was post #500. w00t!