Spreadsheet Version 3.0 Release

[white frog]

I think I have all the bugs worked out now! Thanks to all who helped beta test this for me.

The new version is now available on the download page. This is the final time (how many times have I said that?) I will be updating it. To replace my working on it, I have included instructions on how everyone can update their own spreadsheet. On the "Equipment Summary" sheet at the very bottom, you will find these instructions.

Also, most pages are protected so that you don't accidentally mess things up, but there is no password. All you need to do is to remove the protection from each page and you can edit all you like!

I really hope that this version is final. I hope you all enjoy it and find it useful! Cheers!

[Vicious...]

No, thank you for all your help and advice! DLing now.

[Rertslelm]

Ïðîñòèòóòêè Àñòàíà (http://astanadosug.com/)

[Nicholost]

Haha! White Frog, I literally got all my buildings and everything but vehicles entered into the previous version last night. LOL.

Based on my initial test-run, I will say that I am stoked to see v3.0 released and will migrate to that release. If everyone knew what a game-changer this tool is, everyone would use it. Thank you.

[Quirt]

Only been playing CC for about a week and downloaded v2.2 as soon as I found it – having an update already is awesome LOL :D Thank you SO much for this amazing tool --- I can't imagine how much time and effort went into developing it!!
Cheers

[CounterSniper]

Man, that is one sweet sheet!

Kudos, white frog!

[Jamievs]

Thanks! Looks really great!

Would it be possible to have an option to place somewhere if you have goodfella?

[Feng1234]

Uhhh still not sure how to use it effectively? Can someone please explain?

[white frog]

Uhhh still not sure how to use it effectively? Can someone please explain?
It's actually very simple. Here's the steps:
1. On the summary page, input your level, # of mafia, attack skill points, and defense skill points
2. On the Money Buildings and Gold Buildings sheet, enter the # of buildings you have for each level into column X (Owned)
3. On the defense building sheet, enter the # of buildings you have into column Q
4. Input the amount of all your equipment on the appropriate sheets (guns, melee, armor, etc)

Then, return to the "Summary" page to see all of your stats calculated for you. It will tell you how much money you've spent (and where you've spent it), how much gold you've spent, your effective stats (att. and def.), etc.

The Goal Calculator is a tool that will tell you the most efficient upgrade to increase your economy the fastest. For this you will need to input:
1. A list of possible upgrades into column A
2. The upgrade cost as found in the Money Building or Gold Building sheets
3. The Actual Per Hour Growth found on the above sheets in column
4. The upgrade times for each level of upgrade you're looking at
5. Your current Cash on Hand in the top (it's labeled)
Column G will show you the Upgrade vs. Time value... the next available upgrade with the largest value is the most efficient upgrade, and should be pursued next

The rest of the tools are pretty self-explanitory!

[snowstockholm]

white frog, I SALUTE YOU. Your all-in-one spreadsheet is fully sick.

[H-Wood]

Absolutely fantastic tool. Thank you!!! Can you give a brief summary of what the update changes/improves?

[white frog]

It's all listed on the download page!

[Maniaxe]

Thank you White Frog for taking the time to do this and to share it with all of us! I am now glad I procrastinated putting info into V.2.3 lol!

[Navi Ho]

Fantastic job! Just quickly glanced at it for now (something about work keeps nagging at me), and I noticed weapons etc are all listed alphabetically. Is there a way to order them as they show up in our own inventory, without messing up the calculations? If I missed that it is there my apologies, will be looking at this in greater detail later. Anyway again a HUGE thank you to you and all those who contributed to this awesome piece of work.

[McLovin]

Great spreadsheet, thanks for all you help and effort. What is the best thing to do if you are a Tycoon/Goodfella class? It's throwing off the income/hour and goal calculator figures.

[McLovin]

Figured it out - you can just change the collections per day column to reflect the extra 10% income

[Vartains]

After you. Put all your data into the spreadsheet, ow do o maintain it? Do you have to add every single item you get from fight/rob/mission?

[nycpizzalover]

Salute to white frog. <applause> Should definitely be a stickie so all noobies can access it.

I had created my own little spreadsheet so that I wouldn't spend any more RP than necessary on weapons and armor and to keep track of my attack scores. Just that little spreadsheet was a pain in the butt to keep up. So I can imagine how much work went into this consolidated spreadsheet.

[dudeman]

Is there any way for me to use this spreadsheet on my iPad? My computer is funked and I'm not currently too interested in finding and/or fixing the problem.

[deuces]

Hey white frog, thanks for the updates and for putting this whole thing together. I'm just starting out again and putting everything in. When i put in my level, it gives me a skill point multiplier of 14.14...where is this coming from?

edit: i swear i saw it somewhere but now i cant figure out how to add an item? missing the hardened shotgun.

[Jazz]

How do we adjust the calculations to the Tycoon or Goodfella class? I don't see an option...

[white frog]

Is there any way for me to use this spreadsheet on my iPad? My computer is funked and I'm not currently too interested in finding and/or fixing the problem.
I use an app called "Docs to Go." You can open any Microsoft Office document through this... I believe they have a free version!

[white frog]

Hey white frog, thanks for the updates and for putting this whole thing together. I'm just starting out again and putting everything in. When i put in my level, it gives me a skill point multiplier of 14.14...where is this coming from?
It's based on the skill point multiplier formula discovered by my mentor.. Tramp Stamp, RIP! I would link you to his thread, but it's been deleted! If you would like, I have a PDF created of it.. done before the thread was nerfed.

[Nicholost]

It's based on the skill point multiplier formula discovered by my mentor.. Tramp Stamp, RIP! I would link you to his thread, but it's been deleted! If you would like, I have a PDF created of it.. done before the thread was nerfed.
Caleb recreated that thread and made it public for all.

https://docs.google.com/document/d/1hwXWabpcJ5MArWjSy0-16Kbimbzjnq8xPAGcVD12BdI/edit

[white frog]

How do we adjust the calculations to the Tycoon or Goodfella class? I don't see an option...
In my original post, I explained why I personally don't support the increase in income gained from Tycoon or Goodfella (also by some previous event reward items). I do, however, understand the desire for this bonus, so please don't think I'm judging anyone for taking full advantage of it!

I didn't include these in my spreadsheet because I originally intended it for my purposes only. There is a way to get these figures though.. let's see if you can figure it out!

Just kidding!
Simply adjust the "Collections per day" to reflect a 10% increase.

[deuces]

It's based on the skill point multiplier formula discovered by my mentor.. Tramp Stamp, RIP! I would link you to his thread, but it's been deleted! If you would like, I have a PDF created of it.. done before the thread was nerfed.

Didnt expect such a quick response, i made an edit to my post also asking how to add in new items?

Also, i remember the skill point multiplier being capped at level 100. Is this not true?

edit: finished inputting most stuff, i have 12 new items i need to input by hand. When looking at the attack/defense after putting all my items in, for some reason gun attack and explosive attack only calculate 499 items even tho theres way more than 500 in each category. Any idea why this would be? I'm using the dice and 499 napalms for attack.

[Jazz]

Simply adjust the "Collections per day" to reflect a 10% increase.

I think I understand. So for a 12h building I get 2 collections per day. With the Tycoon bonus I would essentially be receiving 2.2 collections per day? Is that what you are saying?

[Swearengen]

Haha! White Frog, I literally got all my buildings and everything but vehicles entered into the previous version last night. LOL.

Based on my initial test-run, I will say that I am stoked to see v3.0 released and will migrate to that release. If everyone knew what a game-changer this tool is, everyone would use it. Thank you.

Nicholost has convinced me to swap over and try white frog's spreadsheet. I was using Lars, but white frog is getting a ton of kudos here so I’ll be entering data tonight!

[deuces]

Got most data entered in. Very interesting with the goal calculator. Its telling me i should upgrade my rock cafes to level 3 and gentlemens clubs to level 2 before upgrading my nightclub to level 3!! WHAT DO I DO NOW??? Everyone told me to take my nightclubs straight to level 3...

edit: clearly im somewhat slow :) having 35m in the bank obviously changes things quite a lot. However, since i do already have that 35m, does that mean i should spend it on a rock cafe level 3 upgrade with a 509 upgrade vs time number or level 3 nightclub at 413 upgrade vs time?

[white frog]

Got most data entered in. Very interesting with the goal calculator. Its telling me i should upgrade my rock cafes to level 3 and gentlemens clubs to level 2 before upgrading my nightclub to level 3!! WHAT DO I DO NOW??? Everyone told me to take my nightclubs straight to level 3...

edit: clearly im somewhat slow :) having 35m in the bank obviously changes things quite a lot. However, since i do already have that 35m, does that mean i should spend it on a rock cafe level 3 upgrade with a 509 upgrade vs time number or level 3 nightclub at 413 upgrade vs time?
I'm going to assume that you've spent some time saving up that 35 mil. Since the time you've spent saving has a lot of value, you still need to take it into consideration. What I would do is input roughly the amount you probably had when you started saving, and use the results from that experiment. The closer you get to the NC upgrade, the more it will tell you that's it's the best choice!

[white frog]

I think I understand. So for a 12h building I get 2 collections per day. With the Tycoon bonus I would essentially be receiving 2.2 collections per day? Is that what you are saying?
Correct!

Reaching the minimum characters for a response...

[Swearengen]

Put all my data into white frog's spread sheet (not as hard as i thought it would be) and damn that is one nice program! I haven't had a chance to really play with it and look at all the features but thanks for making it available!

[McLovin]

Got most data entered in. Very interesting with the goal calculator. Its telling me i should upgrade my rock cafes to level 3 and gentlemens clubs to level 2 before upgrading my nightclub to level 3!! WHAT DO I DO NOW??? Everyone told me to take my nightclubs straight to level 3...

edit: clearly im somewhat slow :) having 35m in the bank obviously changes things quite a lot. However, since i do already have that 35m, does that mean i should spend it on a rock cafe level 3 upgrade with a 509 upgrade vs time number or level 3 nightclub at 413 upgrade vs time?

Deuces, you can 'reset' things by changing the current cash on hand to 0 to see what would have been the best upgrade when you started. The value calculation is based on your IPH but you should find that the NC streets the opposition up to L3 or L4. I've found this a good way too try to calculate the value of the time already invested as white frog has already stated.

Seems to me like its a matter of short term IPH increase (RCs, GCs) vs long term growth (NC) - NC rules for long term

[white frog]

The big problem I had when creating this goal calculator was figuring out a way to give a "potential" value to the remaining upgrades and figure that in to the equation.

[white frog]

for some reason gun attack and explosive attack only calculate 499 items even tho theres way more than 500 in each category. Any idea why this would be? I'm using the dice and 499 napalms for attack.
I'll take a look at this later today to see what's going on..

[white frog]

for some reason gun attack and explosive attack only calculate 499 items even tho theres way more than 500 in each category. Any idea why this would be? I'm using the dice and 499 napalms for attack.
Okay.. I figured this out, and it was a really stupid mistake on my part. When I added the new equipment, I forgot to extend the equations in the columns for Used, Unused, and Total Attack/Defense. Normally I insert a line in the middle, which automatically extends these equations, but when I add to the top, it doesn't.
I've fixed this on my master copy and will get it uploaded soon, but for now all you need to do is to unprotect the sheet, highlight the cell to change (used, unused, total att/def), scroll to the top of the section and click and drag to include the cell for the item it's not calculating. Or you can just adjust the starting number in the equation. For example:
Total used on for Guns should read SUM(F4:F378) instead of F5.. etc.

Let me know if you have any problems getting this to work for you!

[Gaming Will]

bump


Nice job White Frog

[ruffy]

omg u r a excel king to design this sheet. thank you bro =)

[NotHappyatU]

This sheet is good

[Feng1234]

Hey is it true that vehicles aren't counted as weapons in the profile section? I have 379 but my profile only says 369?

Also why does the summary total come up to 555 def and 635
when my actual profile defense says 555 and 637 attack?

[Feng1234]

I think the difference is attributed to my towers which is showing as 4 defense. Why is this the case? A bug?

[Dreno33]

Perfect!! Thanks for those simple steps in adding equipment!!! Question - when we add equipment, will it automatically be added alphabetically? or no?

[deuces]

Bump, great spreadsheet!!!

Whitefrog, on the goal calculator, when i have enough in the bank to do both level 2 and level 3 upgrades for the same building, should i generally try to go 2,3,2,3?

For example, the gentlemans club. With my 25% time and $ discount, the upgrade vs time is 641.03 for level 2 and 739.64 for level 3. Level 4, theres a pretty significant dropoff.

These numbers are true for most of the high level buildings, not sure if all buildings are this way as well.

Basically i guess just wondering if its always best to stack upgrades if possible.

[white frog]

Bump, great spreadsheet!!!

Whitefrog, on the goal calculator, when i have enough in the bank to do both level 2 and level 3 upgrades for the same building, should i generally try to go 2,3,2,3?

For example, the gentlemans club. With my 25% time and $ discount, the upgrade vs time is 641.03 for level 2 and 739.64 for level 3. Level 4, theres a pretty significant dropoff.

These numbers are true for most of the high level buildings, not sure if all buildings are this way as well.

Basically i guess just wondering if its always best to stack upgrades if possible.
I've noticed that for most buildings, it's more efficient to go all the way to 3 or 4 before starting the second building. Keep in mind that #'s will change as your bank goes up... don't let that change effect your strategy or else you'll be devaluing the time it took to save that bankroll!

[deuces]

Alright cool thanks. Im making a LOT of cash since these nightclubs are up to level 3 now, so i'm accumulating cash in my bank and not being able to spend all of it when choosing the highest upgrade vs time. That'll be taken care of with going 2,3,2 on these Gmens, and saving for the 2nd level 3 might take a day so i'll maybe upgrade an upscale club which are both still at 1.

[white frog]

I will always input my new bankroll as soon as I begin an upgrade, see what the next upgrade is, and stick with it. Reason being is if 24 hours later you re-input your income, it might tell you a completely different upgrade, and like I said before, going down that road will devalue the time invested in saving over those 24 hours.

[Swearengen]

So I put in my wife's data into the calculator. Reviewed it 3 times but I am still coming out way off in one area - Def. Basically my profile def is a little over 800 more than my def calculated by the spread sheet (i.e. the blue box number on the def tab is 800+ off) = data entry error.

My ATK profile and calculator are 100% on the money, my number of melee, weapons in the calculator and profile match, etc...So that would mean my equip is all entered correctly. That only leaves my gold/money bldg, def bldgs, and sp stat adjustments right? Am I missing some other possible error? I double checked her bldgs (money & def) like 3 times... hmmmmm :(

[Dreno33]

So I put in my wife's data into the calculator. Reviewed it 3 times but I am still coming out way off in one area - Def. Basically my profile def is a little over 800 more than my def calculated by the spread sheet (i.e. the blue box number on the def tab is 800+ off) = data entry error.

My ATK profile and calculator are 100% on the money, my number of melee, weapons in the calculator and profile match, etc...So that would mean my equip is all entered correctly. That only leaves my gold/money bldg, def bldgs, and sp stat adjustments right? Am I missing some other possible error? I double checked her bldgs (money & def) like 3 times... hmmmmm :(

well, def buildings inflate the defense score, as we all know, that's probably it. On the left side in the Summary page, scroll down to where it says Fake (Profile). it is in like a salmon color. This number SHOULD closely match your wife's profile number. but it is not the REAL defense she uses.

[Swearengen]

That's the number that is like 800 off. Her in game profile says ~16100, but her fake profile listing on the calculator is like 15300'ish...Just trying to figure out what I could have entered wrong. I don't imagine any calculator to be 100% on pt, but 800 seems pretty way off... hmm, thanks though...

[msjo]

Does she have any armories? On the version that I downloaded, the real value bring used for a level 1 armory was set to 13 instead of 26. Also, is she a tycoon? Did you change the defense amounts to reflect the tycoon bonus on def buildings?

[white frog]

Did you change the defense amounts to reflect the tycoon bonus on def buildings?
If your attack is coming out correct, then this would be my guess. The spreadsheet wasn't written for tycoon, so you would have to adjust the defense values for the buildings.

[2Legit]

Wow man!! U should get paid from putting so much effort onto this.

I just downloaded it and I'm very impressed!

Bows down...u da KING!!!!

[Swearengen]

Thanks, that must be it I TOTALLY forgot that tycoon has bldg def bonuses also not just cash. WOW - I feel stupid. Thanks, I'll just change the values...

[bliss]

can somebody make video to this confusing 4 me

[white frog]

can somebody make video to this confusing 4 me
Um.. Hmmm.... Let me think.. No!!! Are you kidding?

[Feng1234]

Lol

Someone would say making this whole thing is pretty crazy enough (Lars) so I don't see why making it into a tutorial video is so hard?

And while you're at it, please do another one for tycoons cause we all special.

[War Priest]

Awesome spreadsheet! :)

[JohnnyR]

lolol, twas thinkin' the same thing WP.

Damn, White Frog, I just might play CC to make use of this spreadsheet.

[War Priest]

lolol, twas thinkin' the same thing WP.

Damn, White Frog, I just might play CC to make use of this spreadsheet.

And I thought EnjoyLife's had to much on it. Haha :p

[Inzaghi]

I think I have all the bugs worked out now! Thanks to all who helped beta test this for me.

The new version is now available on the download page. This is the final time (how many times have I said that?) I will be updating it. To replace my working on it, I have included instructions on how everyone can update their own spreadsheet. On the "Equipment Summary" sheet at the very bottom, you will find these instructions.

Also, most pages are protected so that you don't accidentally mess things up, but there is no password. All you need to do is to remove the protection from each page and you can edit all you like!

I really hope that this version is final. I hope you all enjoy it and find it useful! Cheers!
1) The event end item is not the same for all levels. For example, "loaded dice", "big 7's" and "crooked dice" are from the same event. So would you please add that or you can allow users to custom design a weapon.
2) Would you please add rewards for buying buildings and weapons in the goals list? Just wish to know if the rewards are worthwhile.

[wupuck]

thank you!

[Dreno33]

1) The event end item is not the same for all levels. For example, "loaded dice", "big 7's" and "crooked dice" are from the same event. So would you please add that or you can allow users to custom design a weapon.
2) Would you please add rewards for buying buildings and weapons in the goals list? Just wish to know if the rewards are worthwhile.

he, after I and probably many others suggested, added an amazing feature to allow us to ADD our own equipment. Just do that(:

[Inzaghi]

he, after I and probably many others suggested, added an amazing feature to allow us to ADD our own equipment. Just do that(:
How to insert the new row? I cannot if the sheet is protected. But once the protection is removed, the added item is not considered.

[Dreno33]

How to insert the new row? I cannot if the sheet is protected. But once the protection is removed, the added item is not considered.

if you have his latest version downloaded, he gives directions on how to add equipment

[Inzaghi]

if you have his latest version downloaded, he gives directions on how to add equipment
Dreno, I did download the latest version and followed his instruction. But if I didn't remove the protection, all the "insert" option is disabled...

[white frog]

But once the protection is removed, the added item is not considered.
What do you mean, "the added item is not considered?"

[LooryncEnance]

http://www.jerseysqueens.co.uk/ soccer jerseys,Soccer Shirt,Wholesale Socer Jerseys,Football Jerseys,cheap soccer jerseys,soccer jerseys cheap,authentic soccer jerseys,cheap soccer shirts,wholesale soccer shirts
http://www.jerseys-queens.com/ youth soccer jerseys|soccer jerseys|cheap soccer jerseys|soccer jerseys cheap|authentic soccer jerseys|cheap soccer shirts|wholesale soccer shirts|soccer Shirt|Football Jerseys|Wholesale Socer Jerseys

[Inzaghi]

What do you mean, "the added item is not considered?"
I removed the protection and managed to add the custom item, but it's not shown in the attack sheet.

[white frog]

I removed the protection and managed to add the custom item, but it's not shown in the attack sheet.
You only followed the first 3 steps in the instructions... see step 4 on the "Equipment Summary" page

[War Priest]

You guys should do a spreadsheet like mine. :D Haha just kidding.

[Inzaghi]

You only followed the first 3 steps in the instructions... see step 4 on the "Equipment Summary" page
Got it! I thought they were added into that sheet automatically.
Also, plz double check the attack sheet, the first row is not included in the total for guns and explosives.

[white frog]

Got it! I thought they were added into that sheet automatically.
Also, plz double check the attack sheet, the first row is not included in the total for guns and explosives.
I commented on this a few pages back... you need to highlight the cell that adds up the attack, click into the formula bar, and extend the sum upward to include the first item.

[Sasha54]

Thanks for this!

Now just need to enter all my data again - good thing I'm not so busy at work............:cool:

[white frog]

Thanks for this!

Now just need to enter all my data again - good thing I'm not so busy at work............:cool:
Just a heads up... you might wanna hold off. I'm working on some new things, and there will be a new release, hopefully sometime this week.

[Swearengen]

Just a heads up... you might wanna hold off. I'm working on some new things, and there will be a new release, hopefully sometime this week.

New stuff - sounds good! :)

[white frog]

I'm kinda waiting for this "scratcher" thing to be released so I can see if it would be beneficial to add something related to them. Hopefully they will come out soon so I can get this new version released!!!

[Dreno33]

I say just release the new version, White Frog. God knows when they'll release the scratchers. They've been pretty sh!tty on keeping us up-to-date. I WANT TO SEE YOUR NEW VERSION! :D :D :D :D

[white frog]

I'm still trying to find time to input an entire page of new equipment, but I have given up on the scratchers. New additions will include the Event Logging Tool, Event Loot Items list, the No-Banking Test Sheet, and a clickable "Best of the Best" page based off of the new and improved list (so you can have access to all advice with one document). I will hopefully get the time to get this out soon...

[Dreno33]

I'm still trying to find time to input an entire page of new equipment, but I have given up on the scratchers. New additions will include the Event Logging Tool, Event Loot Items list, the No-Banking Test Sheet, and a clickable "Best of the Best" page based off of the new and improved list (so you can have access to all advice with one document). I will hopefully get the time to get this out soon...

love it!! I'll definitely use that no bank thing to predict my future levels etc.

hey, if you can add the event items in to affect the upgrade times / cost. is it possible for a tycoon option? :D :D

[Dreno33]

@WF ~ a lot of your "squares column" data are inaccurate in the building sheets.

a few of them listed wrong:

1) Beach Nightclub (8x7) says 20, not 56
2) Crematorium (7x7) says 25, not 49
3) Underboss' House (5x5) says 56, not 25

theres more that was just a couple examples.

[white frog]

@WF ~ a lot of your "squares column" data are inaccurate in the building sheets.

a few of them listed wrong:

1) Beach Nightclub (8x7) says 20, not 56
2) Crematorium (7x7) says 25, not 49
3) Underboss' House (5x5) says 56, not 25

theres more that was just a couple examples.
Thanks Dreno.. I'll check on that and get it fixed!