Crime City Equipment Tracker

Now updated for Crime City Syndicates! 
Track your equipment inventory with our Crime City Equipment Tracker Spreadsheet.

Crime City Equipment Tracker



Crime City Equipment Tracker 1.1 - There has been a secretive change/update to the way profile defense is calculated, specifically regarding defensive buildings, and possibly money buildings, further complicated by syndicate bonuses. For this reason, the calculation you see on this spreadsheet will be close if your equipment is 100% accurate, however your profile will actually show a different amount for defense until this is figured out. It's all for show anyway, as the actual defense totals used in PvP and Robbery defense are different, and also based on a unknown formula. Attack profile totals in this spreadsheet are 100% accurate and should match your visible profile if all equipment is properly accounted. If you find any errors, or have any update suggestions, please comment on the blog!

Crime City Equipment Tracker Summary

Find Guns, Melee, Explosives, Armor, and Vehicles in the Crime City Loot Spreadsheet


Crime City All-In-One Spreadsheet - A great way to track your equipment inventory, buildings, and much more with fantastic visual and statistical information regarding your data.  This was the source document for the Crime City Equipment Tracker with Syndicate Bonus support.  *Note: The All-In-One Spreadsheet is NOT updated for Crime City Syndicate Bonuses.

Credit to: white frog

24 comments:

  1. Is it possible to add new items that are not listed?

    ReplyDelete
  2. There seems to be a problem with how attack is calculated. For some reason it does not calculate all armor. Idk what the problem is, but some sort of problem is it for sure

    ReplyDelete
    Replies
    1. Thank you for the message. I have double-checked the formulas for armor attack, and they are correct. Have you made any additions of equipment to the tracker since downloading? Perhaps a formula was inadvertently changed when adding something.

      Delete
    2. I do have added items in all sections, but it's only in the armor section that something is faulty. It does not count all armor for some reason. It says I'm using 146 armor, and not using 660 witch is faulty as my current mafia size is 400 something

      Delete
    3. On the attack tab, double check the "Totals from Armor" (around line 860) and ensure the full range for column F is shown in the formula. This line is the base of all the summary for armor attack. Hope this helps.

      Delete
  3. I have figured it out. It was wrong formula at the very first column, the column that is supposed to calculate how many you have in your mafia. And also there was a couple of wrongs here and there, for some reason it fucked up in the column after a newly added item, but that is easily fixed by just copying from the second column and all the way down.

    ReplyDelete
  4. And that is in the Usable column just to clear =)

    ReplyDelete
  5. And also, make sure you add in the notes when you add a new item that is top of the table, that you make sure to change the formulas so everything will add up properly

    ReplyDelete
  6. when I add a gun to the list, it is not included in the summary. where is the correct place to add new guns?

    ReplyDelete
  7. To clarify, I have guns that are not in your list. I go to the gun tab, create a new row, enter the gun name, quantity and attack and defense. after doing that, the summary shows no change in the amount of weapons I have or any stat change. What did I do wrong?

    ReplyDelete
    Replies
    1. You have to add it in the attack and defence tab aswell, it's all in the instrucions on the summary page

      Delete
    2. The *bad* instructions. Seriously, update those, they don't make any sense.

      Delete
  8. Replies
    1. Right-click on the link, and choose to save the spreadsheet.

      Delete
  9. just started entering weapons. looks good so far, thanks.

    fat tony.

    ReplyDelete
  10. The GPS is really GPS, not some assisted-GPS that Sprint and Verizon have in their phones. That means you can really navigate with it, like I did, to streets around SF I wasn’t too familiar with.

    ReplyDelete
  11. On Line 227 of Defense Buildings there is a "Profile Defense" number. What is that and how should it be changed?

    ReplyDelete
  12. how are the attack and defense skill points caculated into the equation?

    ReplyDelete
  13. Does each item you buy add the exact attack and def. numbers that are given or is it less? example: Tommy guns are 10 attack so if I buy 10 of them do I add 100 attack?

    ReplyDelete