Mobsters 1 Spreadsheet by Orly?STFU!

[Midnight Watch]

ORLY, your link to the spreadsheet ain't working bro. I think it's cause you're pointing it at the file instead of page one of the thread. I dont' think tinyURL does files well.

[Orly?STFU!]

ORLY, your link to the spreadsheet ain't working bro. I think it's cause you're pointing it at the file instead of page one of the thread. I dont' think tinyURL does files well.

Yeah, I fixed it. Stupid tinyurl...:mad:

[carol ann volini]

:D It took some time to download everything but once I got it done it was amazing. Thanks so much for your work and your help:D

[brokencrystal]

Thanks so much for doing this! I found it a couple of days ago but of course it was after I unlocked the downtown shopping mall, was a dumbass and sold a skyscraper and seaside resort to buy it and lost an assload of money.

[GodofWar]

this is amazing thanks for giving this to the community

[hellcentralx2]

This is a kick ass spreadsheet. But i have 1 question... How do we use the fight calc. When we have no clue how many mobsters our enemy have, what thier attack or deffense or any other that valuable info that is need to calc that?

And once again
thank you

[ProjectDan35]

yes you do, they can fight with 5x their level.

[hellcentralx2]

Ok so i have to assume that they are up to full strength, ok thats kewl thanx

[hellcentralx2]

Then again what about their attack and deffense numbers????

[Orly?STFU!]

This is a kick ass spreadsheet. But i have 1 question... How do we use the fight calc. When we have no clue how many mobsters our enemy have, what thier attack or deffense or any other that valuable info that is need to calc that?

And once again
thank you

The purpose behind the fight calculator is to try and make sense of those odd fights you'll run across, and to see the effects of different skill and equipment versus your current setup. You don't have to know the enemy's stats to use it.

[Midnight Watch]

If I may, its more of a, "Lets test out how good my stats are versus someone who has These stats so I know who to and who not to attack" kinda deal. My stats are set up using this so that I can attack most anyone on my own level and win. Works for me when I use my 17 stamina to go attacking 500+member mobs and win with only 260 of my own and get 70k per attack. (Level 51).

[vodo34861]

ORLY With the downtown shopping malls with the QTY at 30 current price is $200,000,000 but the cost 10 is $2,009,900,000. When it should be $2,000,000,000. Just an FYI.

[shellebole]

This is awesome! Thank you so much for spending your time on this! You are my hero!:)

[Orly?STFU!]

ORLY With the downtown shopping malls with the QTY at 30 current price is $200,000,000 but the cost 10 is $2,009,900,000. When it should be $2,000,000,000. Just an FYI.

Let me guess, you own 1 Plaza, right?

The price you're seeing is because you still have to buy 9 more Plazas (which now cost $1,100,000 each), then the Malls at $200,000,000.

Math doesn't lie!

If you don't want to use your currently owned Undeveloped Territories in the formulas, uncheck the option at the bottom. It'll still include the cost of the land purchase in the cost, because it is a valid factor in determining your purchase's value.

[ThesuicideKing13]

This Thing is AWESOME. Thank you so much for taking the time to make this, so i didnt have to. Because i was going to....hahahaha...

Seriously, awesome work. Thanks a lot.

[BallzMcPicklehead]

Hey, thank you

[moz]

Thanks for the sheet, nice work :).
I have a request; wouldnt it be nicer if we had three figures after the decimal point instead of two in the ROI column? I suppose the colours show you which one is higher when you have same values but having it would be a lil more informative. Watcha think?

PS.: sorry if its been asked before.

[Orly?STFU!]

Thanks for the sheet, nice work :).
I have a request; wouldnt it be nicer if we had three figures after the decimal point instead of two in the ROI column? I suppose the colours show you which one is higher when you have same values but having it would be a lil more informative. Watcha think?

PS.: sorry if its been asked before.

I'm actually working on redoing the ROI figure to make more sense for the average player. ROI can be calculated in many different ways.

[moz]

Well if youre going to change it the way you say on the ROI popup window, its cool by me but it might confuse that average player. Its definitely more informative that way though.

[Timbothy]

You're never gonna get a break, now there is the Bomb Disposal Suit: 5 attack, and 17 defense for 20 favor points. Thanks for the spreadsheet. Saves me time and money.

[arasilly3]

Help okay i downloaded the openoffice program and im in a blacnk calc sheet and idk what to do next idk how to extract the file either

[food king]

--------------------------------------------------------------------------------

hello wonder if anyone would give me a tip or two. I messed up and put alot in energy at beginning so my defense is low how can i raise my defense if i am maxed on mob weapons?

seems if i buy high defense one my spread sheet defense % won't change


I will owe you BIG
thanks
dee

[food king]

open office, then click on open document search for ur spread sheet cick then open, did u open his zip extract sheet to desk top?


Help okay i downloaded the openoffice program and im in a blacnk calc sheet and idk what to do next idk how to extract the file either

[Arcipelago]

Maybe I am doing something wrong, but the "Hours 10" and "Days 10" boxes on my sheet do not appear to be working.

Also, one small suggestion. Your ROI numbers do not include the cost of the undeveloped land they require. This can make a big difference, especially with the ones that require Seaside Lots.

[Arcipelago]

I am no expert, but it seems to me that if you are already maxed out on weapons, your only option is to level up and use skill points to increase defense.

[Christopher]

I am no expert, but it seems to me that if you are already maxed out on weapons, your only option is to level up and use skill points to increase defense.

That is correct, and the reason skill points are so important the higher your level.

[Arcipelago]

Maybe I am doing something wrong, but the "Hours 10" and "Days 10" boxes on my sheet do not appear to be working.


Nevermind, I figured out what I did wrong. Thanks. :D

[redshirt9]

Just had to say, this is awesome!

I had a small SS of my own to help with ROI on properties, but it pales in comparison to this one... Nice work!!!

[Orly?STFU!]

You're never gonna get a break, now there is the Bomb Disposal Suit: 5 attack, and 17 defense for 20 favor points. Thanks for the spreadsheet. Saves me time and money.

Working on it... :mad:

[Orly?STFU!]

Maybe I am doing something wrong, but the "Hours 10" and "Days 10" boxes on my sheet do not appear to be working.

Also, one small suggestion. Your ROI numbers do not include the cost of the undeveloped land they require. This can make a big difference, especially with the ones that require Seaside Lots.

Glad you got it working!

[Orly?STFU!]

Help okay i downloaded the openoffice program and im in a blacnk calc sheet and idk what to do next idk how to extract the file either

To extract the spreadsheet file, double-click the zip file to open it. It should open like a folder, and you can drag the file out. Also, you can right-click the .zip file, and choose "Extract All" to extract the .xls file.

Then, you can select it within OpenOffice Calc. You should be able to double-click the spreadsheet as well once it's extracted.

[Orly?STFU!]

--------------------------------------------------------------------------------

hello wonder if anyone would give me a tip or two. I messed up and put alot in energy at beginning so my defense is low how can i raise my defense if i am maxed on mob weapons?

seems if i buy high defense one my spread sheet defense % won't change

hard to find post here so if possible can ya email me at

www.myspace.com/funkyfrogrocks

I will owe you BIG
thanks
dee

At lower levels, defense skill won't seem like much. However, as long as you maintain the proper mob size for your level, you'll quickly see it jump up as you gain levels and dump points into it. In fact, you can almost go without any equipment whatsoever at the highest levels, because the higher you go in levels, the less equipment does for you since you're maxxed out at 500 of each type (weapon, armor, vehicle), unless you pay good money for godfather points and get lots of hired guns.

[Orly?STFU!]

Okay, the new Bomb Disposal Suit has been added, enjoy!

[weapo]

Sorry in advance if this question was addressed in another post. I love this spreadsheet! There is some feedback I have for Orly. Is it possible for you to add functionality for the limited items such as the Mack Titan or the Bomb Disposal Suit? I have some of each personally and I don't think the spreadsheet is exactly accurate without taking these into consideration. Perhaps making a worksheet where a user can define custom equipment to avoid you having to add the stats for each piece of equipment?

Anyways, thanks Orly!
-Weapo

[Christopher]

Sorry in advance if this question was addressed in another post. I love this spreadsheet! There is some feedback I have for Orly. Is it possible for you to add functionality for the limited items such as the Mack Titan or the Bomb Disposal Suit? I have some of each personally and I don't think the spreadsheet is exactly accurate without taking these into consideration. Perhaps making a worksheet where a user can define custom equipment to avoid you having to add the stats for each piece of equipment?

Anyways, thanks Orly!
-Weapo

Orly updates the sheet when new things come out. Do you have version 2.0.8?

[weapo]

Ah, no I had 2.0.6, thanks a lot!

[ethos2k2]

i just downloaded orly so i don't need to update

[onyxgeo]

will functionality be added to the spreadsheet for the new cash format? Looks like Mobsters is rounding to the nearest million now.

[rainman68]

I have found that I have to go visit the Bank in order to see ALL my cash. On the first page it is only showing to the nearest mil as stated above.

[PetrolHead]

I have found that I have to go visit the Bank in order to see ALL my cash. On the first page it is only showing to the nearest mil as stated above.

I LOVE YOU lol. I hate typing my cash into the sheet to the nearest million. I never thought about getting the number from the bank since I never use it. You are a genius!

[onyxgeo]

Easy enough. Thanks for that tip.

[dijoca]

idk why, but i cant write on the green spaces. i registered and did everything, but it doesnt work. :'(

[Orly?STFU!]

idk why, but i cant write on the green spaces. i registered and did everything, but it doesnt work. :'(

Make sure you follow the instructions. Many people seem to forget to extract the spreadsheet from the .zip archive you download from here. If you don't, it will open in read-only mode.

[Orly?STFU!]

v 2.0.9 is up!

ArmaLite AR-50 Sniper Rifle added. I expect that we'll see a new vehicle within a week with a high attack rating, which will probably cost 20 GF points. :rolleyes:

[carol ann volini]

:pYet again you have outdone yourself. Pure genius;)

[Alabama D]

Hello all,

Since I'm not from America or another english speaking country, I find it hard to undertand much of what is typed above. I would love to know what I;m doing wrong with my equipment, 'cause I thought I had the best as far as needed, but when people attack me I always LOSE.
So, can somebody help me with this spreadsheet or can somebody answer me back in a private message so we can look at it together?

And, last question, when I have 500 people in my mob, do I only need 500 weapons, 500 cars etc.?

Alabama D

[weapo]

Orly,

Once again, love the spreadsheet. I have a suggestion for you. Could you possibly add functionality to the income ledger to account for average hourly, daily, and weekly mission income? Should be simple enough to implement seeing as you already calculate energy regeneration time and average payouts for missions. It should just take a simple table with a drop down selection box to choose the preferred mission, displaying the number of vehicles, badges, or profit.. Can then be combined with territory revenue to get more accurate figures assuming one continuously completes the chosen mission without wasting energy..

Just a thought, I would just add it to my local copy if it weren't protected =)
-Weapo

[freeport28]

Great sheet man ! i have a question I'm trying to figure out the health levels of the people in the fights, I'm using the formula that you explain in the damage tab. do i use both damage taken and given to find out the health of the opponent or just taken or given? thanks !

[SoulRed12]

I think this is great, but could you add another column which includes the number of hours required to make up the difference after buying a certain number of properties? Like if you have $2Bil, and you use it to buy 10 downtown shopping malls, the column would tell you how many hours before the investment pays for itself.

[anthraax]

I understand the spreadsheet can't be modified, however it won't let me change my level after I leveled up. Is this correct? It's pretty inconvenient to have to re-download and re-do the entire spreadsheet every time you level...

[a_violet_fluid]

Since the GF is clearly going to continue creating new items and you are going to update your spreadsheet. Is is possible to give this an import function so that information from the old spreadsheet can be imported into the latest version? If this is possible will you please consider this as a function for the next version?

a_violet_fluid

[Orly?STFU!]

I understand the spreadsheet can't be modified, however it won't let me change my level after I leveled up. Is this correct? It's pretty inconvenient to have to re-download and re-do the entire spreadsheet every time you level...

That didn't make sense. The spreadsheet doesn't know when you level up. You need to be clear as to what you're doing, and what is not happening.

[Orly?STFU!]

Since the GF is clearly going to continue creating new items and you are going to update your spreadsheet. Is is possible to give this an import function so that information from the old spreadsheet can be imported into the latest version? If this is possible will you please consider this as a function for the next version?

a_violet_fluid

It's not possible, sorry. Excel has no way of doing this.

What I do is select each section (contiguous green cells), copy, then paste them into the new sheet. You only have to be aware of the new cells then. It takes me less than a minute to transfer my data.

[a_violet_fluid]

Thanks for the reply. Keep up the hard work.

[Cyrusdust]

First off I want to say I love this spreadsheet! Thanks for taking the time to put it together.

My suggestion is due to all the new items the GF has been offering.

How about if you were to leave a blank row on the bottom of each category (vehicle, armor, etc) where we can enter in the name of an item and its info (defense, attack, upkeep, etc). Or something to that effect.

[Orly?STFU!]

First off I want to say I love this spreadsheet! Thanks for taking the time to put it together.

My suggestion is due to all the new items the GF has been offering.

How about if you were to leave a blank row on the bottom of each category (vehicle, armor, etc) where we can enter in the name of an item and its info (defense, attack, upkeep, etc). Or something to that effect.

No worries, I'll keep adding the new items as I learn of them. I only log on every couple of days, but I usually update the sheet as soon as I see a new item. I'll have a new sheet with the M113 APC shortly.

[Orly?STFU!]

Version 2.0.10 is ready! Includes the M113 APC and a little color-coding to show which items are promotional.

I predicted this item (http://forum.mobstersapp.com/showpost.php?p=342970&postcount=294), yet I'm surprised it doesn't have a higher attack value than the Humvee, but is basically slightly better than the Mack Titan for the same cost. Don't you feel silly now if you bought the Mack Titan? I wonder if this is the new trend for weeks to come... :rolleyes:

[Christopher]

Version 2.0.10 is ready! Includes the M113 APC and a little color-coding to show which items are promotional.

I predicted this item (http://forum.mobstersapp.com/showpost.php?p=342970&postcount=294), yet I'm surprised it doesn't have a higher attack value than the Humvee, but is basically slightly better than the Mack Titan for the same cost. Don't you feel silly now if you bought the Mack Titan? I wonder if this is the new trend for weeks to come... :rolleyes:

Start predicting an item that can be bought with in-game cash. :)

[Giovanni]

For sure, lol.

[Orly?STFU!]

Start predicting an item that can be bought with in-game cash. :)

That'll happen once people stop buying the promotional items, most likely.

[JiMiZnHB]

Hello, I like your Spreadsheet, even though hit is too over the top with info, but do you have ANY Plans Add the NEW Wepons, Armor, and Vehicles???

I have created My own Spreadsheet, and Although no where near as Complex as yours, I do Have ALL the NEW Weapons, Armor, and Vehicles in it.

I would like to SEE how the GodFather Items Calculate out in your Spreadsheet.

Thank You and haPPy moBBing
jiMMi the cliFF

[SoulRed12]

Hello, I like your Spreadsheet, even though hit is too over the top with info, but do you have ANY Plans Add the NEW Wepons, Armor, and Vehicles???

I have created My own Spreadsheet, and Although no where near as Complex as yours, I do Have ALL the NEW Weapons, Armor, and Vehicles in it.

I would like to SEE how the GodFather Items Calculate out in your Spreadsheet.

Thank You and haPPy moBBing
jiMMi the cliFF
He does have the godfather weapons in there already...

[Orly?STFU!]

Hello, I like your Spreadsheet, even though hit is too over the top with info, but do you have ANY Plans Add the NEW Wepons, Armor, and Vehicles???

I have created My own Spreadsheet, and Although no where near as Complex as yours, I do Have ALL the NEW Weapons, Armor, and Vehicles in it.

I would like to SEE how the GodFather Items Calculate out in your Spreadsheet.

Thank You and haPPy moBBing
jiMMi the cliFF

Fail Troll is Fail

[tommynseattle]

Hi there.

I'm writting to you because I have enjoyed using your spreadsheet for months now. However, with the latest revision 2.0.10 there seems to be an error in calculating the Bomb Disposal Suit. When you enter a quantity it accepts the amount, however under the upkeep rate the amount is $0 and the Full Upkeep is $0.

Can you possibly fix this as it is throwing off my upkeep and income ledger.

Thank you

and thank you for all the work you have put into this!! it is greatly appreciated!!

[Greengoblin]

I have a question about the fight calculator.....How do you find out the enemies information BEFORE fighting?

After you fight you can see what they fought with, but it's too late then.

[Christopher]

I have a question about the fight calculator.....How do you find out the enemies information BEFORE fighting?

After you fight you can see what they fought with, but it's too late then.

You can't.

[Greengoblin]

So it's useless then??

[Christopher]

It's mostly to help understand a fight, and to take a guess a how you would do against enemies with different types of stats.

[Orly?STFU!]

Hi there.

I'm writting to you because I have enjoyed using your spreadsheet for months now. However, with the latest revision 2.0.10 there seems to be an error in calculating the Bomb Disposal Suit. When you enter a quantity it accepts the amount, however under the upkeep rate the amount is $0 and the Full Upkeep is $0.

Can you possibly fix this as it is throwing off my upkeep and income ledger.

Thank you

and thank you for all the work you have put into this!! it is greatly appreciated!!

It's my understanding that the Bomb Disposal Suit has no upkeep, thus the math is correct. If I'm wrong, somebody needs to show me what it is. I've not seen anyone mention upkeep for this item anywhere. I don't make enough money to buy one of every special promo item the GF puts out. I wish!!

[Orly?STFU!]

So it's useless then??

It's only useless if you don't know how to use it. Next time, try asking how to use it if you're confused instead of making stupid remarks. :mad:

[msmcc301]

is awesome!! Thank you!!

[PetrolHead]

It's only useless if you don't know how to use it. Next time, try asking how to use it if you're confused instead of making stupid remarks. :mad:

How do we use it? It does seem like it would be more helpful to know that stuff before rather than after a fight.

[SoulRed12]

I don't know if you happened to miss my post, but here it is again just in case: :)

I think this is great, but could you add another column of the property box which includes the number of hours required to make up the difference after buying a certain number of properties? Like if you have $2Bil, and you use it to buy 10 downtown shopping malls, the column would tell you how many hours before the investment pays for itself.

[Oroto]

I would think that it's extremely obvious how to use it.. Enter all your info in the appropriate boxes and all the info is calculated for you.

[The Myspace Mafioso]

I am very interested in this spreadsheet! I downloaded a few times and it keeps saying the file is corrupt! Any suggestions on this? I really want this spreadsheet! Please contact me...Thanks

[The Myspace Mafioso]

Nevermind I got it! Forgot to take it out of the zip file, lol. SWEET! Thanks for making this spreadsheet!

[PetrolHead]

I would think that it's extremely obvious how to use it.. Enter all your info in the appropriate boxes and all the info is calculated for you.

Well yer:p

BUT, you don't know what your enemy is using. Sure you can make estimates but I can usually tell if I can beat by someone and how close the win was by the amount of damage done to me/them. The closer the two numbers, the closer the fight was.

[PetrolHead]

I don't know if you happened to miss my post, but here it is again just in case: :)

Isn't that the ROI column? Only thing is its currently worked out as a percentage, not a time number.
Divide the price by the income. Its not that hard to do yourself, you don't need a spreadsheet to do that.

[Moto Murder]

Are you planning to include a VIP calculator into the data sheet? It would be awesome to be able to see how important more ambulances would be... Thanks, & the current sheet rocks! Moto Murder

[tommynseattle]

It's my understanding that the Bomb Disposal Suit has no upkeep, thus the math is correct. If I'm wrong, somebody needs to show me what it is. I've not seen anyone mention upkeep for this item anywhere. I don't make enough money to buy one of every special promo item the GF puts out. I wish!!

my extreme appologies!! under equipment I have 3 items listed and of course i have the best of everything. So being that it's the last in the category of equipment on my mobsters page I went and put it in the last category on the armor category..sorry..dork here. forgot about the stupid extra toys by the gf for extra gf points only..Since I didn't really buy any because they were basically useless and only money in the bank for the GF, because to of any use whatsoever you'd have to spend umm..how much $$$ to equip your mob. LOL umm..useless..so this was a useless category that I forgot about.

Again, my appologies Orly..Great job as always on the spreadsheet.

But, while i have you. when it comes to territory..when is really not of use to buy the townhomes condos ect... i mean.. ROI shows what to buy when, how many condos do you have to buy to equal the income of shopping malls? it seems at some point the income from shopping malls and even casinos outweighs the spending of money on lower properties.

Just curious..Thanks

[Orly?STFU!]

I go away for a few days, and everything changes. :eek:

Looks like I'm going to have my hands full. Expect an updated sheet Tuesday night sometime.

[212th Battalion]

w00t ! :D

[Orly?STFU!]

Of course, if anyone can provide me with new mission, territory, equipment details that are available for someone above level 88, please share, since I won't have any access to anything higher. :D

Can I assume there will be investigative threads started soon?

I can only put in what I know, so the sooner we figure out the particulars, the sooner the update will be truly complete.

[JoDeeAnne]

1st & foremost, let me give u a BIG THANK YOU for the spread sheet..I luv it, and it's helped me out BIG TIME!

Can't wait to see the update, with the info below...I won't purchase anything until I check out ur spreadsheet!

Ok, I'm new to posting stuff! Did search around 2 see if I could find where someone had already posted.. Didn't see anything.

Was not sure about starting a new thread, decided 2 reply to u! Hope thats ok!

Theres alot of new missions...it willtake me awhile to write & poste..Jst let me know if u rather i didn't!

*Territories


UnDeveloped Land
Empty Field Cost $75,000,000
Income $100,000

Developments

Helipad - Cost $300,000,000 <<yeks:eek:
Income = $600,000
>On Vacant Lot

Airport - Cost $900,000,000 <yeks x 2 :eek::eek:
Income = $1,000,000
>On Empty Field

Equipment

Weapons

10-Liter Sarin Gas Sprayer Cost $2,500,000
UpKeep $75,000
Attack= 18
Defense= 12

Armour

Trans-Kevlar Armed Suit Cost $1,000,000
UpKeep $12,500
Attack=10
Defense=14


Wheels
Hughes 500 Helicopter - Cost $5,000,000
Upkeep $600,000
Attack=20
Defense=15




Of course, if anyone can provide me with new mission, territory, equipment details that are available for someone above level 88, please share, since I won't have any access to anything higher. :D

Can I assume there will be investigative threads started soon?

I can only put in what I know, so the sooner we figure out the particulars, the sooner the update will be truly complete.

[MiniTransAm]

New Mission Info:

Open High Class Escort Agency
Energy-45
Mobsters-50
BMW-50
Beretta 9mm-50
Seaside Resort-1

Payout- 1,000,000 to 4,500,000
Experience + 60


Mob War!
Energy - 60
Mobsters - 240
Humvee - 10
Uzi - 10
Body Armor - 10

Payout - 1,200,000 to 4,800,000
Experience + 110


Engineer A Prison Breakout
Energy - 75
Mobsters - 90
RPG Launcher - 20
Advanced Ballistic Armor - 20

Payout - 0 to 10,000,000
Experience +125


Import Counterfeit Rolexes
Energy - 20
Mobsters - 150
Yacht - 10
Yacht Harbor - 10

Experience + 40
Loot - Counterfeit Rolex +10

Sell Counterfeit Roles
Energy - 140
Mobsters - 150
Minigun - 10
Downtown Shopping Mall - 1
Counterfeit Rolex - 50

Payout - 5,000,000 to 25,000,000
Experience +200



Double checked and I think I got it all right. Thanks for the spreadsheet!

[Greengoblin]

It's only useless if you don't know how to use it. Next time, try asking how to use it if you're confused instead of making stupid remarks. :mad:
Dude, chill out.......I love the sheet, I was asking how to use the fight calculator and I only recieved one response

[Bubbly Pirana]

anyone have access to the stuff above level 400?

[The Point]

These are the missions up to level 200. I don't know what the level 400 mission is.

Level Requirement ???
Elect Capo to Mayor's Office
Payout: $0 - $7,000,000
Experience: +400
Loot: 1 x Small Police Escort

Requires...
Energy: 175
Mobsters: 250

5 x Bulletproof Escalade
120 x Skyscraper
10 x Downtown Shopping Mall

Level Requirement: 200
Raid Lockheed Research Lab
Payout: $2,500,000 - $10,000,000
Experience: +500
Loot: 1 x Exoskeleton

Requires...
Energy: 200
Mobsters: 300

20 x Hughes 500 Helicopter
1 x Trans-Kevlar Armed Suit
2 x Helipad

Theres also a new car, the Lamborghini, thats only (currently?) available via the Christmas mission.

[Mr. Biggellsworth]

Raid Lockheed Research Lab
Payout: $2,500,000 - $10,000,000
Experience: +500
Loot:
1 x
Exoskeleton

Requires...
Energy: 200
Mobsters: 300

20 x
Hughes 500 Helicopter
1 x
Trans-Kevlar Armed Suit
2 x
Helipad



Revolution in Central America
Payout: $5,000,000 - $100,000,000
Experience: +750
Loot:
1 x
Cold War-Era Gunboat

Requires...
Energy: 240
Mobsters: 400

75 x
Hughes 500 Helicopter
200 x
10-Liter Sarin Gas Sprayer
3 x
Airport



Hope this helps :)

[dethmetl]

Thanks alot for this. It really helped!!!!

[weapo]

These are the missions up to level 200. I don't know what the level 400 mission is.

Level Requirement ???
Elect Capo to Mayor's Office


My level 86 doesn't have this mission and my level 206 does. Just trying to be helpful, I know it's not very specific but I'm hoping we can pinpoint the level requirements with some teamwork..

-Weapo

[B-Lok]

My level 86 doesn't have this mission and my level 206 does. Just trying to be helpful, I know it's not very specific but I'm hoping we can pinpoint the level requirements with some teamwork..

-Weapo

I don't have that one and I'm level 114, and it says that more missions will be available at 150. Hope that helps.

[FlatfootedNinja]

I don't have that one and I'm level 114, and it says that more missions will be available at 150. Hope that helps.

I'm level 199 and I have it... so we know its not 200. :) 150 sounds right.

[weapo]

And I had the Raid Lockheed Research Lab when I first noticed the update at level 206 so that's verified at 200 =)

Hope it helps, Orly!

-Weapo

[Kahuna Cowboy]

Orly, you will also need to remove the "1" limitation on the Rolls, the Gala has given me 4 of them. :D

[Orly?STFU!]

Orly, you will also need to remove the "1" limitation on the Rolls, the Gala has given me 4 of them. :D

Nice call, I have to do the same for Brass Knuckles :D

[Sandy106]

Joined the forum just to say thanks, that spreadsheet is awesome :)

[Kahuna Cowboy]

Orly,

I got to tell you thanks so much for this sheet. This new update is going to be a big PIA. I can't see the new stuff either so I am having a hard time making heads or tails of the new missions, equipment, and terrorties. Bless your heart!

[Orly?STFU!]

Okay, the update is going very well, but I'm still missing some key information:

Level Requirements for the following Missions:


Open High-Class Escort Agency
Engineer a Prison Breakout
Import Counterfeit Rolexes
Sell Counterfeit Rolexes


Level Requirements for the following items:


10-Liter Sarin Gas Sprayer
Trans-Kevlar Armed Suit
Hughes 500 Helicopter

[stiletto sarah]

I am at level 182 and all the missions, territories, and equipment you noted is available to me. Also the small police escort can be sold for $2,500,000 and has an upkeep of $500,000 (RIP OFF), has an attack of 60 and a defense of 50.


BTW: Thank you so much for the spreadsheet. It really enhances my game playing :)

[Orly?STFU!]

I am at level 182 and all the missions, territories, and equipment you noted is available to me. Also the small police escort can be sold for $2,500,000 and has an upkeep of $500,000 (RIP OFF), has an attack of 60 and a defense of 50.


BTW: Thank you so much for the spreadsheet. It really enhances my game playing :)

Does that mean it has a value of $5,000,000? If so, thanks, one more item figured out. :D

If possible, can you grab a screenshot?

[MikeySpeed]

I got info for you for the new equipment, 10-Liter Sarin Gas Sprayer, Trans-Kevlar Armed Suit, Exoskeleton, Hughes 500 Helicopter, Cold War-Era Gunboat

10-Liter Sarin Gas Sprayer
Upkeep: $75,000
Attack: 18
Defense: 12
cost per $2,500,000

Trans-Kevlar Armed Suit
Upkeep: $12,500
Attack: 10
Defense: 14
cost per $1,000,000

Exoskeleton
Upkeep: $50,000
Attack: 20
Defense: 75
Not purchasable, sells for half value $10,000,000

Hughes 500 Helicopter
Upkeep: $600,000
Attack: 20
Defense: 15
Cost per $5,000,000 each

Cold War-Era Gunboat
Upkeep: $2,500,000
Attack: 105
Defense: 40
Not purchasable, sells for half value $50,000,000

New Missions not sure what level these became available as I am level 415

Revolution in Central America
Payout: $5,000,000 - $100,000,000
Experience: +750
Loot: 1 x Cold War-Era Gunboat
Requires...
Energy: 240
Mobsters: 400
75 x Hughes 500 Helicopter
200 x 10-Liter Sarin Gas Sprayer
3 x Airport

Raid Lockheed Research Lab
Payout: $2,500,000 - $10,000,000
Experience: +500
Loot: 1 x Exoskeleton
Requires...
Energy: 200
Mobsters: 300
20 x Hughes 500 Helicopter
1 x Trans-Kevlar Armed Suit
2 x Helipad

Elect Capo to Mayor's Office
Payout: $0 - $7,000,000
Experience: +400
Loot: 1 x Small Police Escort
Requires...
Energy: 175
Mobsters: 250
5 x Bulletproof Escalade
120 x Skyscraper
10 x Downtown Shopping Mall

Sell Counterfeit Rolexes
Payout: $5,000,000 - $25,000,000
Experience: +200
Requires...
Energy: 140
Mobsters: 150
10 x Minigun
50 x Counterfeit Rolex
1 x Downtown Shopping Mall

Import Counterfeit Rolexes
Experience: +40
Loot: 10 x Counterfeit Rolex
Requires...
Energy: 20
Mobsters: 150
10 x Yacht
10 x Yacht Harbor

Engineer a Prison Breakout
Payout: $0 - $10,000,000
Experience: +125
Requires...
Energy: 75
Mobsters: 90
20 x RPG Launcher
20 x Advanced Ballistic Armor

Mob War!
Payout: $1,200,000 - $4,800,000
Experience: +110
Requires...
Energy: 60
Mobsters: 240
10 x Humvee
10 x Uzi
10 x Body Armor

Open High-Class Escort Agency
Payout: $1,000,000 - $4,500,000
Experience: +60
Requires...
Energy: 45
Mobsters: 50
50 x BMW
50 x Beretta 9mm
1 x Seaside Resort

New Land

Empty Field
Income: $100,000
$75,000,000 each

Helipad
Income: $600,000
Built On: Vacant Lot
Each Requires 50 Mob Members
$300,000,000 each

Airport
Income: $1,000,000
Built On: Empty Field
Each Requires 60 Mob Members
$900,000,000 each

Can't wait to see the update keep up the good work, p.s. the only item I do not have info on yet is the small police escort as soon as I get I will give you the information.

[Orly?STFU!]

Whew, I'm getting some sleep, but I'll keep working at it tomorrow (today). I'm still missing some level requirement info, but I may go ahead and finish this update and add the other info as it comes in.

Still to do:


REQUIRED: update main mob data sheet with new requirements and items
REQUIRED: update fight calculator
NON-CRITICAL: add missing level requirements for certain missions, verify police escort VALUE (which determines SALE VALUE). I have one report of $2,500,000 sale value, but no confirmation of whether this is the value, (which would make the sale value actually $1,250,000), or if the value is shown as $5,000,000. Yea, I'm tired. :p


I've been working on a few other changes, so I'll see what else I can bundle into this update.

Let me be VERY clear, I have everything I need, EXCEPT this information:

Level Requirements for the following Missions:


Open High-Class Escort Agency
Engineer a Prison Breakout
Import Counterfeit Rolexes
Sell Counterfeit Rolexes


Level Requirements for the following items:


10-Liter Sarin Gas Sprayer
Trans-Kevlar Armed Suit
Hughes 500 Helicopter


Lastly, this stat info:


Verify Small Police Escort Value (half of which becomes the sale value). I have a report of $2,500,000. Can someone please take a screenshot of it?

[IKeeledU]

i never recieved my confirmation email and says the file is corrupted when i try load it from the page

[Exi]

http://i133.photobucket.com/albums/q73/Existia/pe2.jpg

Thanks for the spreadsheet!

[MikeySpeed]

Let me be VERY clear, I have everything I need, EXCEPT this information:

Level Requirements for the following Missions:


Open High-Class Escort Agency
Engineer a Prison Breakout
Import Counterfeit Rolexes
Sell Counterfeit Rolexes


Level Requirements for the following items:


10-Liter Sarin Gas Sprayer
Trans-Kevlar Armed Suit
Hughes 500 Helicopter


Lastly, this stat info:


Verify Small Police Escort Value (half of which becomes the sale value). I have a report of $2,500,000. Can someone please take a screenshot of it?


You got it I will work on that for you immediately :D

[Orly?STFU!]

i never recieved my confirmation email and says the file is corrupted when i try load it from the page

Then how did you post this message? You can't post without confirmation.

Did you follow my instructions? I'll bet you skipped this part:

EXTRACT the spreadsheet from the zip file you download from here.

The file is fine, otherwise I'd get hundreds of complaints, so you must be missing something. Follow the instructions, then let me know if you're still having a problem.

[Orly?STFU!]

http://i133.photobucket.com/albums/q73/Existia/pe2.jpg

Thanks for the spreadsheet!

Excellente! Scratch that off the to do. The earlier report was correct.

[onyxgeo]

Let me be VERY clear, I have everything I need, EXCEPT this information:

Level Requirements for the following Missions:


Open High-Class Escort Agency
Engineer a Prison Breakout
Import Counterfeit Rolexes
Sell Counterfeit Rolexes
Level Requirements for the following items:


10-Liter Sarin Gas Sprayer
Trans-Kevlar Armed Suit
Hughes 500 Helicopter



I just hit level 150 and the following are now available to me:

MISSIONS:
Attend Christmas Gala (favor points)
Elect Capo to Mayor's Office
Sell Counterfeir Rolexes
Import Counterfeit Rolexes
Engineer a Prison Breakout
Mob War!
Open High-Class Escort Agency


TERRITORY:
Helipad
Airport

EQUIPMENT:
10-Liter Sarin Gas Sprayer
Trans-Kevlar Armed Suit
Hughes 500 Helicopter

[212th Battalion]

BTW.....you can own more than 1 rolls royce. I received an extra one with that Christmas Gala thing :D

http://img.photobucket.com/albums/v458/psychoticmindset/2rolls.jpg

[B-Lok]

I'm level 115 and I have all of that listed equip. As for the missions, I think they have the mission list setup in order of low level to high level (with the exception of a few special missions) so I'll list them in the order that I have them from lowest to highest in an attempt to pinpoint levels of availability.

Federal Gold Reserve Heist - LVL30

Open High-Class Escort Agency - ???

High Stakes Gambling - LVL40

Mob War! - ???

Realty Speculation - LVL50

Engineer a Prison Breakout - ???

Import Counterfeit Rolexes - ???

Sell Counterfeit Rolexes - ???

Raid National Guard Armory - LVL100

[hotpiemaggie]

<div style="background-color:black;color:#FFA500;font-weight:bold;text-align:center;">2. Add requests are only allowed within the message body in the Add me / Join my mob! forum,
but are allowed within signatures everywhere.
* To change your signature, go to your User CP which is located on the top left of your screen and choose 'edit signature'.
Don't forget to preview it and save</div> (http://forum.mobstersapp.com/announcement.php?f=2)

[The Titan Corporation]

Any word yet on an update Orly? I know of some peeps that are drooling waiting for the update... Good work bro..

[smokintaz]

When Is the Next New Spread Sheet Coming out with the New Missions and Territories and What not?

[uSuck/iFIGHT/BellaDeath]

dude this is hella work just updating my blog


imagine the add on's this guy has to do give um time ;)

maybe he's saving it for christmas? :rolleyes:

[The Titan Corporation]

dude this is hella work just updating my blog



lol. Dats funny shit right der..

[Orly?STFU!]

I'm nearly done. Santa Orly will have it ready before I get to bed. :D

It will be missing some level requirement info, but I'll add that in the next update.

[Keger32]

I have begun to feel uneasy about how much I rely on your spreadsheet Orly...lol.

[Orly?STFU!]

New version 2.0.11 is ready! It's not 100% due to missing level requirements on some items and missions, but it's functional otherwise. I'll add the missing stuff in the next update (when we figure it out). Merry Christmas!

:D

[kempker1409]

New version 2.0.11 is ready! It's not 100% due to missing level requirements on some items and missions, but it's functional otherwise. I'll add the missing stuff in the next update (when we figure it out). Merry Christmas!

:D

sweet...got it....thank you

[Coleyon]

Whew! I've been waiting on this thing since I saw the new equipment come through! Thanks!!

[The Point]

Upkeep Costs, block J13, does not appear to be tallying my total upkeep correctly. It says my upkeep is only 11 million not the correct 61 million.

[Orly?STFU!]

Upkeep Costs, block J13, does not appear to be tallying my total upkeep correctly. It says my upkeep is only 11 million not the correct 61 million.

Fixed, re-download it, and it should work for you. Sorry about that! :o

I didn't change the version number yet, too few people have grabbed it.

[nasajd]

Looks like you forgot to lock the spreadsheet, maybe that was intentional but I thought you might want to know. Also thanks for the update.

[Orly?STFU!]

Fixed again, sheesh

[The Titan Corporation]

Fixed again, sheesh

Are they keeping you on your toes bro....?

[devionx]

You're awesome, man! Thanks for puttin' in the work for us. That's some dedication right there. I'm sure you're under-appreciated but thanks from me and the folks I've passed your work on to.

[Kenshinr1]

Thanks a lot bro!!

[freeport28]

Hi i don't know if i missed something but the figure in the income ledger is different by 10 million then the total income generated by property on the bottom. The income ledger is the figure that's wrong. I do own 10 airports but like i said it adds correctly for the property income but doesn't seem to make it to the income ledger. Thanks again for doing the heavy lifting! i run my game from your spread sheet.

[engage16]

Orly I thank you my friend for working so hard on something like this. Especially since its for a bunch of people you don't even know... This was the best christmas present I've gotten so far this year alongside with the 12 pack... Keep up the great work, I'll let you know if i find any errors... Merry Christmas to you and your entire family...

[dickphitzwell]

Orly, may I STFU? anywho cell J12 ends at h88, may I suggest just making it =h91 instead of having two places of sum() for the same.

Thank you for your effort on this, its nice to have.

[airtech62]

Something isnt quite right on the newest update. I have everything loaded in correctly and double checked it, but the monetary amounts I have on the game arnt the same as on the stat sheet. Any ideas?

[wildrocci]

Morning (Marry Christmas) hope everything is going fine for you!!
your new spreadsheets the formulas not working correct, the values on all items not adding and computing properlly.
Thanks for all you hard work

[rlnorto]

The newest spreadsheet doesn't include my helipad or airport income in my gross income.... can you fix?

Thanks!

[Orly?STFU!]

The newest spreadsheet doesn't include my helipad or airport income in my gross income.... can you fix?

Thanks!

Yikes, I've been away, but I'll fix that ASAP!

[Orly?STFU!]

Okay, this should be the final, working version. I've corrected the income cell, and tested it thoroughly with my own data this time (not so rushed to get out the door to family now).

Sorry about the bugs, I hope you find it useful. :D

The version number is still 2.0.11, and I'm working on 2.1 now that these massive changes are in place.

[Orly?STFU!]

Morning (Marry Christmas) hope everything is going fine for you!!
your new spreadsheets the formulas not working correct, the values on all items not adding and computing properlly.
Thanks for all you hard work

I fixed the two bugs for income/upkeep. Try downloading the current one, and copy/paste your data into it (you can select adjacent green cells and copy/paste them at one time, it's how I transfer my own data).

You also might want to edit your post above and kill that HUGE quote of the first post.

[Orly?STFU!]

Something isnt quite right on the newest update. I have everything loaded in correctly and double checked it, but the monetary amounts I have on the game arnt the same as on the stat sheet. Any ideas?

Should be working in the version I just put up. Give it a whirl.

[Orly?STFU!]

Orly, may I STFU? anywho cell J12 ends at h88, may I suggest just making it =h91 instead of having two places of sum() for the same.

Thank you for your effort on this, its nice to have.

Which is exactly what I did this time :p

Should be working now. Oh, and it's St. Fu. :D

[Orly?STFU!]

Hi i don't know if i missed something but the figure in the income ledger is different by 10 million then the total income generated by property on the bottom. The income ledger is the figure that's wrong. I do own 10 airports but like i said it adds correctly for the property income but doesn't seem to make it to the income ledger. Thanks again for doing the heavy lifting! i run my game from your spread sheet.

All fixed, grab it again. :cool:

[midnightmoonwolf]

I just wanted to say that, I have been playing this game for a while now, and I am just now getting this Exel program. I can't wait to get it going. This is a Fantastic Idea and I am glad I have it now. Thanks for having such a great Idea!!!

[courtney36420]

Maybe I'm just a crazy but for some reason my incomes are not the same. I'm running new version. Not that it really matters because I rarely look at the income per hour on the sheet when I can look at it on the terrority page.

[M0bbette]

Hey Orly, since I have to do one of these things for about 10 different characters....should I wait for v2.1? Is it imminent?

[Orly?STFU!]

Hey Orly, since I have to do one of these things for about 10 different characters....should I wait for v2.1? Is it imminent?

It's not that eminent, I have personal duties to attend to for the next couple of weeks, so my work on it will be sporadic.

[Orly?STFU!]

Maybe I'm just a crazy but for some reason my incomes are not the same. I'm running new version. Not that it really matters because I rarely look at the income per hour on the sheet when I can look at it on the terrority page.

Well, without knowing what your numbers are for properties and equipment, there's no way for me to troubleshoot it. You're probably missing some equipment or something simple. I tested the current version with my own data (and I own a lot of different assets), and it all adds up perfectly now for me.

The word income can mean gross income or net income. Which is incorrect? Both? Is your upkeep matching correctly? More info is needed to properly help you.

[MOBSTAR!]

i liked it.;; its cool;; helpful;; thanks:D

[rainman68]

Morning everyone. Thanks many many times Orly for this spreadsheet.

[dickphitzwell]

orly, nevermind, you did fix it =)

[airtech62]

Should be working in the version I just put up. Give it a whirl.

Thanks Orly! Workes right now. Great job!

[Coleyon]

I've doublechecked all my quantities and they're right...the amounts are right too...but in the upkeep area, it's off. I know it's off because cells J41(1,487,500), J50(1,115,000) and J69(50,800) should add up to 2,653,300. Which is also what it has in the game for my upkeep. However, in cell J13 where it has my total upkeep it has 2,278,300. The difference is 375,000 which is my price for the 30 transkevlar suits I have...so I'm assuming your total upkeep formula doesn't use the total field but instead uses the individual cells per item...

By the way, I LOOOVE this spreadsheet but didn't run across it til like level 55...wish I'd have had it from the beginning. I'm considering starting a lower level using it from the beginning. LOL

[Coleyon]

I was just going by the date on the spreadsheet...but I didn't remember what time I'd downloaded it. I just re-downloaded it and put all the data in and it's fixed. Thanks!

[weapo]

I noticed the Mission Calculator worksheet the Avg $ / E column (E) gets different results than I do by hand. I think I'm right in assuming by the comment that this column is supposed to show how much money (on average) each energy point is worth. This should be derived by the average payout divided by the mission energy cost. It is currently derived by the average daily payout divided by the amount of energy regenerated per day (which doesn't make sense to me). By doing the math by hand I find the best money:energy ratio is High Stakes Gambling with $83,333.3 money returned per energy point ($1,250,000 avg payout / 15 energy cost). According to the E column of the worksheet the most efficient money making mission is Open High-Class Escort Agency at $183,333 but it really only produces $61,111.1 ($2,750,000 average payout / 45 energy cost). The gambling mission also produces a better experience:energy yield (which is calculated accurately in the worksheet) so IMHO this is by far the best mission to do on a regular basis. If my logic is correct, the correct formulae are:
High Stakes Gambling =G15/'Mission Data'!E15
Open High-Class Escort Agency =G16/'Mission Data'!E16

I'm not sure, exactly, what dividing the average money per day by the average energy regenerated per day is.. if I'm not thinking about this right could somebody please correct me so I understand it correctly?

Thanks a lot and I hope it helps,
-Weapo

[Onehit33]

Orly , I use the spreadsheet always ;) but something isnt right , here is example,
Your Territory: (Income $167,220,400, Upkeep From Equipment: $30,173,320 )

Cash Flow:$137,047,080 every 55 minutes. Next paid in: 54 minutes


This is what spread sheet says , I went & checked to be sure all fields were filled in correctly,,
Gross Income $153,620,400
Upkeep Cost $30,173,320 ( UpKeep Registers Correctly)
Net Income $123,447,080
Bank Fees $12,344,708
Banked Income $111,102,372

Any Help would be Great , Thanx ORLY & Awsome Job ;)

[redshirt9]

Thanks for the holiday update!!!:D

[uSuck/iFIGHT/BellaDeath]

Orly

I updated my blog for the new year, and completed course 101 for mobsters.
In Section 202: ( COMMING SOON ) for teaching advanced mobster stragety, I want to include your sheet... i'm old school I guess, I audit by hand on paper and have hella accounts so I don't spreadsheet them.

However, its awesome what you have created.... and I want to offer a section for you.

Can you make me a custom 1, ( joking of course ) I want to audit my 16 accounts then have a new tab in the worksheet that adds up the resources of all the other accounts... ROLF so i know when my combined income hits 3 billion per hour lolz... i'm close to 2B :D

[courtney36420]

My total income is 141,504,000. My Upkeep is 21,903,900. At the bottom of the sheet under Full Income is says I have 141,504,000 income but under Gross income it says 135,504,000 with a net income of 113,533,100. I just went back and re-entered everything once again and I believe I have figured out the problem. It's not counting my Helipad income. I own 10 which would equal 6,000,000.


Well, without knowing what your numbers are for properties and equipment, there's no way for me to troubleshoot it. You're probably missing some equipment or something simple. I tested the current version with my own data (and I own a lot of different assets), and it all adds up perfectly now for me.

The word income can mean gross income or net income. Which is incorrect? Both? Is your upkeep matching correctly? More info is needed to properly help you.

[robertclarke]

I just wanted to say thank you very much for all the work you have put into this, Orly. This is the most useful Mobsters tool on the net.

[poppilious]

I see on the spreadsheet the values for attack and defense strength are listed using different equipment in the Attack and Defense calculations. My question is this, Does the game use different equipment when being attacked than it does when attacking? If so, does it then make sense to keep full compliments of the stronger defensive equipment as well as the offensive equipment?

[Orly?STFU!]

Orly

I updated my blog for the new year, and completed course 101 for mobsters.
In Section 202: ( COMMING SOON ) for teaching advanced mobster stragety, I want to include your sheet... i'm old school I guess, I audit by hand on paper and have hella accounts so I don't spreadsheet them.

However, its awesome what you have created.... and I want to offer a section for you.

Can you make me a custom 1, ( joking of course ) I want to audit my 16 accounts then have a new tab in the worksheet that adds up the resources of all the other accounts... ROLF so i know when my combined income hits 3 billion per hour lolz... i'm close to 2B :D

Sure, go ahead and put it in there. Make sure people know to come to this thread for support, or they'll be messaging you constantly!

[Orly?STFU!]

I see on the spreadsheet the values for attack and defense strength are listed using different equipment in the Attack and Defense calculations. My question is this, Does the game use different equipment when being attacked than it does when attacking? If so, does it then make sense to keep full compliments of the stronger defensive equipment as well as the offensive equipment?

Yes, the game will use the best equipment available to you for attack or defense, depending on the situation. Many higher levels keep 500 swats and 500 humvees + 500 guided missiles and 500 miniguns. With the new equipments, some will change their complement, but at higher levels the equipment point difference is negligible compared to skill points, so you'll have to determine if the insane upkeep is worth the tiny possibility of an advantage.

[Orly?STFU!]

My total income is 141,504,000. My Upkeep is 21,903,900. At the bottom of the sheet under Full Income is says I have 141,504,000 income but under Gross income it says 135,504,000 with a net income of 113,533,100. I just went back and re-entered everything once again and I believe I have figured out the problem. It's not counting my Helipad income. I own 10 which would equal 6,000,000.

Make sure you grabbed the latest version. 2.0.11 was updated three times in the course of the first few hours to fix that bug.

You can copy/paste entire sections of data (adjacent green cells) to make the transition easier.

If you still have the problem, let me know.

[slayerrockon]

how are u supposed to know what your enemys attack and defence are? :confused:

[Orly?STFU!]

how are u supposed to know what your enemys attack and defence are? :confused:

Educated guess? Start off by putting your own skill point values in there, then tweak it until the fight data makes sense.

[Ms Mob Bitch]

Thank You Orly, for putting so much time into the spreadsheet!

Ciao,
Ms Mob Bitch

[carol ann volini]

Thanks to you Orly I am making 6 mill an hour at level 34. I follow your spreadsheet faithfully and everyone should have it who is playing this game. "You are the bomb"

[paulmasoner]

i think i have found a bug in 2.0.11

last night i spent a few dozen billion buying new territory. i updated my spreadsheet accordingly. My full income subtotal shows $149,250,000 which is correct by my mobster bounty. My income rate in the ledger only shows $139,250,000. I cannot find any mistakes on the spreadsheet or any reason for the discrepancy.

http://forum.mobstersapp.com/attachment.php?attachmentid=427&d=1230679517

http://forum.mobstersapp.com/attachment.php?attachmentid=428&d=1230679527

[Orly?STFU!]

i think i have found a bug in 2.0.11

last night i spent a few dozen billion buying new territory. i updated my spreadsheet accordingly. My full income subtotal shows $149,250,000 which is correct by my mobster bounty. My income rate in the ledger only shows $139,250,000. I cannot find any mistakes on the spreadsheet or any reason for the discrepancy.

http://forum.mobstersapp.com/attachment.php?attachmentid=427&d=1230679517

http://forum.mobstersapp.com/attachment.php?attachmentid=428&d=1230679527

Easy, grab the sheet again, I made a quick fix to it on the first day. You must have grabbed the bad version. The bad version doesn't tally helipad's nor airport's income. To transfer your numbers, you can copy/paste whole sections of green cells at a time. That's how I do it.

[Strider2k]

omg you are awesome :D I just started mobsters a little while ago, and I was sitting here using a calculator for figuring out which territories were more beneficial to buy, thinking to myself "Someone should make a tool to figure all this out" and than I found here, and here is said tool. Thank you so much for making my life easier :)

[paulmasoner]

Easy, grab the sheet again, I made a quick fix to it on the first day. You must have grabbed the bad version. The bad version doesn't tally helipad's nor airport's income. To transfer your numbers, you can copy/paste whole sections of green cells at a time. That's how I do it.

ah thanks, i didnt even see the discussion about that right beforemy posts lol

[TigerGirlC]

Your spreadsheet is amazing!! You wouldn't happen to have one for Facebook's Mob Wars as well, would you???? :)

[Mansalvo]

<div style="background-color:black;color:#FFA500;font-weight:bold;text-align:center;">2. Add requests are only allowed within the message body in the Add me / Join my mob! forum,
but are allowed within signatures everywhere.
* To change your signature, go to your User CP which is located on the top left of your screen and choose 'edit signature'.
Don't forget to preview it and save</div> (http://forum.mobstersapp.com/announcement.php?f=2)

[Orly?STFU!]

Your spreadsheet is amazing!! You wouldn't happen to have one for Facebook's Mob Wars as well, would you???? :)

Nope, sorry, Mobsters is the only "social website" game I play.

[uSuck/iFIGHT/BellaDeath]

Nope, sorry, Mobsters is the only "social website" game I play.



me too, I use to play others but I like mobsters the best :D

[Hiroyuki Aki]

I'm pretty sure the Helipad comes at level 90, unless there's some ultra-special secret hidden territory at level 90 that's only for me. :P

"You can unlock more territories after you get to level 90 ..."

I'm level 66, latest one is the Mall.

[Hostile Rae]

Orly, just wanted to say that I love your spreadsheet and have had it since the beginning.....you're awesome!!

[kimmygintx]

Thanks, Orly for the update- you rock! :cool:

[Remedy]

orly, i downloaded everything but when i open the spreedsheet it say it was opened in a read only. so i can do anythign with it. any idea what ive done wrong???

[jackstrump]

Thanks for the regular updates & tweaks.

Would it be possible to have a Net Worth cell (or maybe Net Worth after Liquidating), based on all a mobster's assets?

Thanks again.

[Bubbly Pirana]

orly, i downloaded everything but when i open the spreedsheet it say it was opened in a read only. so i can do anythign with it. any idea what ive done wrong???

its is in a zipped folder and you need to extract it

[Midnight Watch]

Orly,

Remember those pages I sent you in PM a while back? Would you mind sending them back to me? My comp crashed and I still use them. Would be greatly appreciative. :D

[Orly?STFU!]

Thanks for the regular updates & tweaks.

Would it be possible to have a Net Worth cell (or maybe Net Worth after Liquidating), based on all a mobster's assets?

Thanks again.

Yes, and more!

Three new fields in my latest version (not released yet) will be both Total Invested (minimum amount needed to buy what you have now), Total Assets (what you'd get if you sold everything), and Total Wealth (add in cash and banked funds to assets). Total Wealth would be a better Most Wealthy value, don't you think?

Caveat: The new version will require two vb functions, so I'll be releasing two versions in the same zip, one for Excel (.xls), one for OpenOffice (.ods). You'll need to make sure you allow the macros (just two custom functions to calculate the above fields) to run. Since I'm not using any ActiveX controls, just basic scripted functions, there shouldn't be any issues. To avoid this, I'd have to create lookup tables that would add about 750k per territory to the size of the sheet. Eww.

[Hiroyuki Aki]

Any chance that you can make it so when you're buying territories, it sees whether you have the undeveloped land required for the development and if you don't, add the land price to the calculations? It probably doesn't make much sense, so an example!

Your best buy according to the calculator is a Seaside Resort for a 200,000$ income if you pay 20,000,000$ per land, but you can buy Downtown Shopping Malls for a 500,000$ income for 50,000,000$ per. In reality, if you don't own the undeveloped territories, they cost 24,000,000$ and 51,000,000$ respectively, making the Mall actually a better investment.

I don't know if you understand it, but I tried my best. :P

[samlaff]

Do you plan to add the Empty Field, Helipad, and Airport to Territories?

Empty Field
Income: $100,000
Initial Cost $75,000,000

Helipad
Income $600,000
Built on Vacant Lot
Each Requires 50 Mob Members
Initial Cost $300,000,000

Airport
Income: $1,000,000
Built On: Empty Field
Each Requires 60 Mob Members
Initial Cost $900,000,000

I'm not sure at what level any of these became available, because I was around level 200 when they were introduced. The Empty Field and Helipad follow the same cost progression as all of the properties (except Vacant Lots), but I haven't bought any Airports yet, so I can't say for sure on them.

[The Boss]

Orly you're the f*ing bomb!!!:D

[Signpainter]

http://img386.imageshack.us/img386/9903/image1xc3.jpg (http://imageshack.us)
http://img386.imageshack.us/img386/image1xc3.jpg/1/w318.png (http://g.imageshack.us/img386/image1xc3.jpg/1/)
somehow my bank balance is no longer editable. any idea why?

[fruitmonkey]

Very nice job thanks :D

[weezle0110]

got any free programs that will help me use this file?

[Signpainter]

got any free programs that will help me use this file?

from the first post:

If you don't have Microsoft Excel 2003 or 2007 installed, you can use OpenOffice.org's Calc 3.x (http://download.openoffice.org/) for FREE.
I tested it, and it works fine. The free Excel viewers won't let you enter data, so don't use them. Microsoft Works is not supported, nor is WordPerfect's suite, nor any other spreadsheet program other than the three programs I've validated above as compatible (Excel 2003, Excel 2007, OpenOffice.org Calc).

[Dexter Memphis]

thanks for creting such a thing i just started using it today its very descriptive easy to reead and well put together

[Banjoman]

Orly, I would like to recommend that the HeliPads and Airports be separated from the other properties on the spreadsheet for a correct ROI.

The reason being is that these two properties are skewing the ROI's as to the best buys. Furthermore they require 500 mobsters for each 10 HeliPads and 600 mobsters more for 10 airports.
Therefore you will need 1000 mobsters in your mob for the level 200 mission and 600 more for the level 400 mission.

Thank you for this spreadsheet...This is the first thing I tell people to download when they join the Damn Loyal PAQ. It has made the game more enjoyable for those mobsters!

Banjoman
~DLP~

[dream cruiser]

The Trans-Kevlar Armed Suit is available at level 70 and there is now an option to buy equipment in lots of 100 also.

[Orly?STFU!]

The Trans-Kevlar Armed Suit is available at level 70 and there is now an option to buy equipment in lots of 100 also.

Ah, nice catch on the new lot option. Too bad he didn't include other lots, like 25, 50, 75, etc. I wonder how long that was in there?

[Orly?STFU!]

Orly, I would like to recommend that the HeliPads and Airports be separated from the other properties on the spreadsheet for a correct ROI.

The reason being is that these two properties are skewing the ROI's as to the best buys. Furthermore they require 500 mobsters for each 10 HeliPads and 600 mobsters more for 10 airports.
Therefore you will need 1000 mobsters in your mob for the level 200 mission and 600 more for the level 400 mission.

Thank you for this spreadsheet...This is the first thing I tell people to download when they join the Damn Loyal PAQ. It has made the game more enjoyable for those mobsters!

Banjoman
~DLP~

The ROI value is correct, though. It's just that you have additional requirements to buy them. I may consider your request, but it may have to wait until I get around to redesigning the pages. I was already considering sectioning off properties by affordability and making a whole new recommendation scheme (ROI is still a valid calculation), which would be a combination of the current BULK vs BUY ONE + affordability. That will take a little while to do, but it's a fun challenge to work on. That type of scheme should address your concern, as well as a few other shortcomings of the current setup.

[Orly?STFU!]

http://img386.imageshack.us/img386/9903/image1xc3.jpg (http://imageshack.us)
http://img386.imageshack.us/img386/image1xc3.jpg/1/w318.png (http://g.imageshack.us/img386/image1xc3.jpg/1/)
somehow my bank balance is no longer editable. any idea why?

Ugh, you're might need to re-download the sheet and paste your data back in. That happened to me a few times as well. For some reason, Excel lets you paste over certain style info, which then breaks the cell. It's a bug.

You can try copying the green cell below it, then pasting it onto the bugged cell, then see if it repairs itself. That worked once for me.

[Orly?STFU!]

Any chance that you can make it so when you're buying territories, it sees whether you have the undeveloped land required for the development and if you don't, add the land price to the calculations? It probably doesn't make much sense, so an example!

Your best buy according to the calculator is a Seaside Resort for a 200,000$ income if you pay 20,000,000$ per land, but you can buy Downtown Shopping Malls for a 500,000$ income for 50,000,000$ per. In reality, if you don't own the undeveloped territories, they cost 24,000,000$ and 51,000,000$ respectively, making the Mall actually a better investment.

I don't know if you understand it, but I tried my best. :P

This functionality is already in the sheet. There are option checkboxes at the bottom. If you have it set to "Use Land", many calculations change to reflect owned properties. ROI, however, always takes undeveloped lands requirements and adds it to cost. It's hardcoded into the calculation. The "Use Land" option does not affect it, because it doesn't matter whether you own the prerequisite land or not, it is a part of the price, and required for a proper ROI formula.

Don't forget that as you buy property, their costs change, so ROI changes. The higher the ROI, the faster your return on investment. The math doesn't lie, it's math:

$Income/($CurrentPrice+$LotPrice) % = ReturnOnInvestment% (larger is better)

That's the formula I use. Some like the inverse formula:

($CurrentPrice+$LotPrice)/$Income = Cost/Income Ratio (lower is better)

I may include this formula as an option toggle, since you get the exact same result, but the visual is different.

Note that I am always including the lot price. Only lots don't have lot prices.

[Orly?STFU!]

Quick update since I haven't been around for a few days.

I am in the process of a fairly major update (v2.1). This new version will contain TWO versions of the sheet within the zip file. One for Excel, one for OpenOffice. The reason for this is because I wanted to add a couple of highly custom formulas to the calculations, but was unable to due to the need for vba style scripting and maintaining compatibility for non-Excel users. I have worked out the issue, but it requires a OpenDocument format version (.ods) for OpenOffice to avoid a major compatibility problem. The good news is that it's not hard for me to maintain.

In other news, I have ALL base requirement for new items (I was only missing a few level requirements in 2.0.11).

There will be a new value for you to all compare e-Penii: Total Wealth

This will accompany two other interesting numbers: Total Assets and Total Investment

Total Wealth is actually just Total Assets + Cash + Bank Funds, very straight forward.
Total Assets is the maximum amount of money you would have if you sold everything in an optimum fashion.
Total Investment is the minimum amount of money it would take to purchase your current assets. Since it's nearly impossible to play the perfect game and spend only in lots of 10, I'd wager everyone spent much more than this figure. :D

I will also be adding a few more enhancements, like:
An improved formula to calculate experience requirements above level 600 (confirmed to need 1,000,000 per level)
The maximum amount you can deposit in your bank account from your cash value, taking into account your bank cap. This figure will allow you upper level rich folks to hit your bank cap EXACTLY.

After 2.1, my next step will be to work on 3.0. This new design will take the lessons I learned in version 2.0, and completely rework everything to be more efficient, a cleaner style, more tabs with new calculators, the works. I'm even toying with color scheme options. I'm also going to revisit the fight calculator and redo it from the ground up. At some point, I'm going to want to resurrect the research into the fight formula (since I doubt the GodFather will tell me how it actually works) and produce a more accurate estimate of fight results. Note that once 3.0 is complete (this will take a while), 2.0 will be archived and unlocked for anyone to explore, just like 1.0 is.

I had one troll in here asking why would anyone spend so much time doing this. The answer for me is easy. I am learning advanced Excel tricks that I can use in my real job; I get to reverse-engineer formulas, find solutions to spreadsheet limitations and use mathematical gymnastics, all of which I find very enjoyable; finally, I get some personal fulfillment by contributing a useful tool to the Mobsters community. I hope you all find it useful.

[fedralis]

The fight calculations are a bit off but nice work

[luvinmylife]

I am really retarded at this stuff, I know, and feel really stupid asking, but when I try to enter anything in the green boxes, it says document opened in read only mode. anybody know how to switch it?

[Christopher]

I am really retarded at this stuff, I know, and feel really stupid asking, but when I try to enter anything in the green boxes, it says document opened in read only mode. anybody know how to switch it?

Did you extract it from the zip file first?

[AUDIOMIND]

This is excellent!!!

[luvinmylife]

I just had to re read the help page more carefully. Thanks guys!

[uSuck/iFIGHT/BellaDeath]

Mob Boss Tool.... what's THIS? please do tell?

[Orly?STFU!]

Mob Boss Tool.... what's THIS? please do tell?

More to come, I've been working on that piece for a while.

[Orly?STFU!]

The fight calculations are a bit off but nice work

How is it off? Tell me what's wrong, and I can fix it.

[qwikslvr]

can you tell me what I need to do to get this spreadsheet to open/work? I have downloaded openoffice3.0 and the version v2.0.11 and I extracted the files......what now, because I cant find anything with a spreadsheet with any green sections for me to fill in. (confused) any and all help is appreciated! thanks

[KingRat]

Hope this helps...

The Bank Balance and Cash Balance cell seem to break when you paste anything other than a number in them.

If you copy your bank balance with commas and paste into the spreadsheet, the Bank Balance cell becomes locked. Same for the cash balance cell.

[DavetheDork]

This is almost like what I have, but prettier and more user friendly. Thnx.

[a_violet_fluid]

I have a question that has been puzzling me for some time. I am not going to put all the math down right here but if you do want it let me know, we can IM about it or something. (I am only extending that offer to the creator of this thread.) It seems to me that when properties are purchased incrementally [by tens] a linear function best describes the decrease of the RoI. (Return on Investment) Because of this, the line can be graphed and certain information missing from the individual RoI calculations becomes prominent. Namely the slope of the line segment. Each of the properties have a decreasing RoI for each set of properties you purchase and this decrease is exponential give that the purchases are made in equivalent increments. The problem that I am having with this approach to investing is that while it does clearly allow you to make the best purchase for you dollar I am not so sure that it is giving you the most volume. Here is my argument. The higher the initial investment on the property, the steeper the slope of the line segment that describes the rate of decrease in the RoI. This means that to continue on the same path is going to require more volume. Other less valuable properties, have a much lower slope to to their function, therefore, it would take much less volume to make the RoI match that of a function with a much steeper slope. With that being said my suggestion is this; With 1.2 billion dollars (This is provided the undeveloped lands are already owned.) You could purchase either 20 casinos, or you could buy 10 Casinos, and based on the RoI make what appears to be the next most beneficial purchases. I would argue that the person who Purchased the 20 Casinos, would much faster be able to purchase his next 10 Casinos than the person who chose to purchase based on RoI. If this is true then a formula that describes the Volume of Income based on the RoI should be discussed. If this can be developed it would mean more income volume faster.

Please tell me if I am wrong here or if I have just missed the boat completely.

-Joe

[Orly?STFU!]

I have a question that has been puzzling me for some time. I am not going to put all the math down right here but if you do want it let me know, we can IM about it or something. (I am only extending that offer to the creator of this thread.) It seems to me that when properties are purchased incrementally [by tens] a linear function best describes the decrease of the RoI. (Return on Investment) Because of this, the line can be graphed and certain information missing from the individual RoI calculations becomes prominent. Namely the slope of the line segment. Each of the properties have a decreasing RoI for each set of properties you purchase and this decrease is exponential give that the purchases are made in equivalent increments. The problem that I am having with this approach to investing is that while it does clearly allow you to make the best purchase for you dollar I am not so sure that it is giving you the most volume. Here is my argument. The higher the initial investment on the property, the steeper the slope of the line segment that describes the rate of decrease in the RoI. This means that to continue on the same path is going to require more volume. Other less valuable properties, have a much lower slope to to their function, therefore, it would take much less volume to make the RoI match that of a function with a much steeper slope. With that being said my suggestion is this; With 1.2 billion dollars (This is provided the undeveloped lands are already owned.) You could purchase either 20 casinos, or you could buy 10 Casinos, and based on the RoI make what appears to be the next most beneficial purchases. I would argue that the person who Purchased the 20 Casinos, would much faster be able to purchase his next 10 Casinos than the person who chose to purchase based on RoI. If this is true then a formula that describes the Volume of Income based on the RoI should be discussed. If this can be developed it would mean more income volume faster.

Please tell me if I am wrong here or if I have just missed the boat completely.

-Joe

Yep, you missed the boat, kind of. :D

Seriously, one glaring error is that you can't buy 20 at a time, so that philosophy is flawed. You must limit your math to purchases in lots of 1 to 10. Math is math, and when the math states that buying a single property will allow you to buy the next in less time than it would take to save up for the two together, then you should buy one, then go for the next using the additional income gained. Otherwise, save up for 10 (or at least more than one). This is NOT the cheapest way to gain property, but the fastest. This is where the confusion comes in. Keep in mind that this technique is only useful if you spend all your money investing in property when you have it, and on a regular schedule. If you only play once a day and earn enough to buy multiple properties in your absence, go ahead and by multiple. I'm pretty sure my tips say this. But, since many players are online 24/7, they can get their income higher much faster by following an investment schedule using ROI and the bulk vs one recommendations.

The only change I can see making to the recommendation is to utilize my new sheet's ability to employ complex formulas not possible with normal Excel functions. Then I could probably fine tune the recommendations logically. It used be impossible to determine with Excel how much it would actually cost to earn the same $100,000,000/cycle income with just Restaurants vs Malls. I'll be able to do this in the near future, and that should have the affect as the Bulk vs One recommendation, where you can find out that you'll earn a higher income faster buying a certain property vs another, even if it's a larger investment to do so. Right now, the simplified ROI formula is fairly accurate, well within an acceptable margin of error.

If you have specific math to show me feel free to send it along. It's obvious that I love math. ;)

[Orly?STFU!]

Hope this helps...

The Bank Balance and Cash Balance cell seem to break when you paste anything other than a number in them.

If you copy your bank balance with commas and paste into the spreadsheet, the Bank Balance cell becomes locked. Same for the cash balance cell.

Yeah, that's an Excel bug, I can't do anything about it, unfortunately. It's not the commas, but the style information which breaks it. Silly Microsoft. :p

You can test this by copying and pasting the balance info into Notepad first, then copy/paste the numbers with commas from Notepad (which has no style info), and it'll still work fine.

[moz]

Hi,
There seems to be a problem with the experience calculator. Im level 503 atm. I have 1508201 xp points and i need exactly 7799 xp points to get to next level. Yet the xp calculator says i need 97799. Thats because according to the calculator the 100.000xp/level requirement starts from level 500 while in reality it starts from level 501. You still need 10.000 xp to get to 501.
No big problem, just thought id point it out in case you havent noticed yourself.

[Mr LEE]

I hope the new spread sheet is in the work's, i do enjoy using it

[GroninG]

umm how do i change my bankk balance on the new one!?

[Demegorgon]

It is available at lvl 70

[Orly?STFU!]

Hi,
There seems to be a problem with the experience calculator. Im level 503 atm. I have 1508201 xp points and i need exactly 7799 xp points to get to next level. Yet the xp calculator says i need 97799. Thats because according to the calculator the 100.000xp/level requirement starts from level 500 while in reality it starts from level 501. You still need 10.000 xp to get to 501.
No big problem, just thought id point it out in case you havent noticed yourself.

Since I'm not that high a level, I have to rely on accurate information from others. Using your values, I can fix the formula, which I have to revamp anyway to include the 600+ level amounts of 1,000,000 exp/level. I'll have it fixed in the new sheet.

[Orly?STFU!]

umm how do i change my bankk balance on the new one!?

Type it in? :confused:

If you simply copy/pasted it from mobsters, you'll cause an excel bug that I can't fix (I'm not Microsoft). Try copying the green Cash cell below it, and pasting that value onto the bank cell. If it works, you should be able to type in the value. I hope that helps.

[DEEZ LUTZ]

Type it in? :confused:

If you simply copy/pasted it from mobsters, you'll cause an excel bug that I can't fix (I'm not Microsoft). Try copying the green Cash cell below it, and pasting that value onto the bank cell. If it works, you should be able to type in the value. I hope that helps.

To avoid said bug, right click and click paste special. Then select text and it wont paste the formatting.

[Orly?STFU!]

To avoid said bug, right click and click paste special. Then select text and it wont paste the formatting.

Nice call. You could also double-click the cell (which makes you enter direct entry mode) and paste to avoid the bug, since it will only paste the text.

[DeeJayTre]

Awesome...

[Murph]

I have just updated from version 5 to version 11.

I am lvl 19 atm. On the old sheet it said i should buy skyscrapers next, but the new one says vacant lot, downtown malls, helipad or airport. Well the last 3 i can't buy at my lvl, so is there something i've done wrong for it to change from skyscrapers to having to keep buying vacant lots?

If i was to tell the sheet i had 99 malls it would then say i needed the skyscrapers next.

[rip torell]

this question may have nothin to do with this but i want to knw how upkeep works exactly i thought the more stuff you had the higher your upkeep was but i started selling things and my upkeep went up

[xtc1]

hey im new with excell so i have no idea where to look to find the fight calculater and the other cool stuff that i see in the preview pic. where do i look? or is that a compleatly difrent download?

[MorgannJ]

dude, your awesome. this is fantastic. it's helped me so much and it's so good that all the data i want is located in one file. instead of hunting around for a territory calculator, attack and defense point calculator and in different programs or web pages. and better yet, you've provided even more incredibly useful information that i didn't even think was possible to figure out for someone let alone find it on the net.

Certainly showed all my Mobsters enthusiast friends.

Thanks for all the hard work. And keep the updated versions coming. Don't think you get enough feedback so here's my support.

Thanks mate :D

[Orly?STFU!]

I have just updated from version 5 to version 11.

I am lvl 19 atm. On the old sheet it said i should buy skyscrapers next, but the new one says vacant lot, downtown malls, helipad or airport. Well the last 3 i can't buy at my lvl, so is there something i've done wrong for it to change from skyscrapers to having to keep buying vacant lots?

If i was to tell the sheet i had 99 malls it would then say i needed the skyscrapers next.

Well, it goes by the best ROI, and due to limitations of Excel, I can't always make it recommend based on all the possible criteria available (there's A LOT). Thus, I have to use ROI as the basis, and I'll assume you're smart enough to know that higher ROI = good, and to make your own decisions, using the sheet's recommendations as a simple guideline.

I'm trying to make up some fancy tricks to force it to do what I want, but it's a lot to juggle, and it's not ready. It would be easier if I could just say, "only Excel 2007 supported", but that wouldn't be fair to the OpenOffice crowd. It'll improve over time, but for now, just remember that higher ROI is better. The Bulk vs Buy One recommendation is still accurate.

[Orly?STFU!]

this question may have nothin to do with this but i want to knw how upkeep works exactly i thought the more stuff you had the higher your upkeep was but i started selling things and my upkeep went up

Sorry, not enough info to even hazard a guess. Well, other than this: Remember that ambulances have upkeep, so if you're doing that mission several times, it will affect your upkeep.

[Orly?STFU!]

hey im new with excell so i have no idea where to look to find the fight calculater and the other cool stuff that i see in the preview pic. where do i look? or is that a compleatly difrent download?

It's a tab near the bottom.

[Orly?STFU!]

Another heads up. I had to make some more modifications due to the new tank. I'll finish up the latest version this week.

[bryanr72]

It's too early, and I'm not thinking straight. I just downloaded the spreadsheet, and I'm filling in everything.

How do I calculate,or where do I find my "Attack Strength" & "Defense Power"?



-me

[bryanr72]

It's too early, and I'm not thinking straight. I just downloaded the spreadsheet, and I'm filling in everything.

How do I calculate,or where do I find my "Attack Strength" & "Defense Power"?



-me


Nevermind, I figured it out. I feel stupid now. :)

[NEED MORE PEOPLE]

well i dont have an activation email for some reason. arrrggghhh

[fedralis]

How is it off? Tell me what's wrong, and I can fix it.

When calculating fights with my defensive character that has over 1000 defense skill with characters that have tank / police escorts my total fight should be 55% winning with the worst scenario possible, yet I am losing fights to these characters which leads me to believe something is off on the calculations.

[LilHide]

I;'m using Excel 07, the latest version, I can NOT input anything into the spreed sheet besides what kind of mobster I am.

[Airborne82abn]

Looks awesome. I downloaded OpenOffice.org and then downloaded the file. For some reason it downloads it as an EFW file instead of ZIP. I believe this is due to my firewall. I cannot figure out how to extract the files from it or convert it back to a ZIP file so I can unzip it. I am using Windows Vista. Any advice would be greatly appreciated. Airborne82abn@yahoo.com.

[Orly?STFU!]

I;'m using Excel 07, the latest version, I can NOT input anything into the spreed sheet besides what kind of mobster I am.

Did you extract the file from the zip file? I have Excel 2007 too, and it works fine for me. There's too little info here for me to troubleshoot the problem.

[Orly?STFU!]

Looks awesome. I downloaded OpenOffice.org and then downloaded the file. For some reason it downloads it as an EFW file instead of ZIP. I believe this is due to my firewall. I cannot figure out how to extract the files from it or convert it back to a ZIP file so I can unzip it. I am using Windows Vista. Any advice would be greatly appreciated. Airborne82abn@yahoo.com.

Rename it to .zip from .efw. It's your antivirus program which is renaming it. I posted a fix for this earlier in the thread.

[Orly?STFU!]

When calculating fights with my defensive character that has over 1000 defense skill with characters that have tank / police escorts my total fight should be 55% winning with the worst scenario possible, yet I am losing fights to these characters which leads me to believe something is off on the calculations.

I take it you know their attack and defense skill stats, because otherwise, your calculations may be missing this key information.

Besides, I've always stated it's not perfect because there's a random modifier to the attack formula which seems to favor the attacker. The fight calculator is an attempt to give you an idea how you can win or lose odd fights. Nobody knows the actual fight formula, we only know the effect of skill points is multiplied by your active mob size in terms of effectiveness.

Some are speculating that there's a dice roll for each active mob member, and the maximum fight points are determined in this manner. Until I see real fight data from a controlled set of scenarios, I can't analyze it. This was attempted long ago, but abandoned, unfortunately. I don't have time for that kind of research, so I have to rely on other's findings.

[redwire]

i just stared and i don't know what to do?
can someone help me please?

[fedralis]

I take it you know their attack and defense skill stats, because otherwise, your calculations may be missing this key information.

Besides, I've always stated it's not perfect because there's a random modifier to the attack formula which seems to favor the attacker. The fight calculator is an attempt to give you an idea how you can win or lose odd fights. Nobody knows the actual fight formula, we only know the effect of skill points is multiplied by your active mob size in terms of effectiveness.

Some are speculating that there's a dice roll for each active mob member, and the maximum fight points are determined in this manner. Until I see real fight data from a controlled set of scenarios, I can't analyze it. This was attempted long ago, but abandoned, unfortunately. I don't have time for that kind of research, so I have to rely on other's findings.

I will post the most recent data that happened. I am a 484 with 1096 defense 2970 health, 4 hired guns, 404 miniguns, 100 sarin gas, 504 ballistic armor, 502 apc, 1 rolls, 1 mack truck. Was attacked on the fightlist and lost 3 times with no wins against a lvl 340 with 161 hired guns that defends with below equipment.

38 M113 APC, 29 Mack Titan, 39 Armored Rolls Royce, 38 Bomb Disposal Suit, 370 Humvee, 223 Hughes 500 Helicopter, 661 Trans-Kevlar Armed Suit, 31 M4, 28 ArmaLite AR-50 Sniper Rifle, 640 Guided Missile Launcher.

From damage done the 340 appears to have around 3000 health. With all the points leftover assigned to attack I should win most fights from the spreadsheet but dont. This is one of many examples I have found. Unless the random isnt that random I shouldnt lose as much as I have been.

[somerockenguy]

thanks for this i have something just like this i made in openoffice calc but it got annoying updating it every time new weapons came out. the only thing mine has that yours does not is i have the same color scheme as the mobsters app and i have the pictures of the weapons/property next to there name. i think im going to stop updating mine and take the lazy way out and use yours. F.Y.I. if i crack the password lock you have on it im going to make it look better but not distribute it.

[Smokes em]

I will post the most recent data that happened. I am a 484 with 1096 defense 2970 health, 4 hired guns, 404 miniguns, 100 sarin gas, 504 ballistic armor, 502 apc, 1 rolls, 1 mack truck. Was attacked on the fightlist and lost 3 times with no wins against a lvl 340 with 161 hired guns that defends with below equipment.

38 M113 APC, 29 Mack Titan, 39 Armored Rolls Royce, 38 Bomb Disposal Suit, 370 Humvee, 223 Hughes 500 Helicopter, 661 Trans-Kevlar Armed Suit, 31 M4, 28 ArmaLite AR-50 Sniper Rifle, 640 Guided Missile Launcher.

From damage done the 340 appears to have around 3000 health. With all the points leftover assigned to attack I should win most fights from the spreadsheet but dont. This is one of many examples I have found. Unless the random isnt that random I shouldnt lose as much as I have been.

You're still missing the most important part though - skill point distribution. It's not a "controlled scenario" if you don't know all attributes of the 2 opponents in the fight.

[fedralis]

You're still missing the most important part though - skill point distribution. It's not a "controlled scenario" if you don't know all attributes of the 2 opponents in the fight.

No i have all the skill points. It is all in attack unless the user has tanks. Even with all in attack the calculator doesnt work out like it should

[somerockenguy]

ok just found out you have no password lock on the spredsheet which is cool so now im going to make it a little more visually appealing. just finished entering all my info and it works great.

[technocat]

Wow, well if nothing else so far, the R.O.I% is the best. I always wanted to be efficient on the properties I bought and usually ended up calculating myself. This is GOLD!:D

[redwire]

how do i get skill points

[212th Battalion]

how do i get skill points

you get them when you level up.

[Orly?STFU!]

I will post the most recent data that happened. I am a 484 with 1096 defense 2970 health, 4 hired guns, 404 miniguns, 100 sarin gas, 504 ballistic armor, 502 apc, 1 rolls, 1 mack truck. Was attacked on the fightlist and lost 3 times with no wins against a lvl 340 with 161 hired guns that defends with below equipment.

38 M113 APC, 29 Mack Titan, 39 Armored Rolls Royce, 38 Bomb Disposal Suit, 370 Humvee, 223 Hughes 500 Helicopter, 661 Trans-Kevlar Armed Suit, 31 M4, 28 ArmaLite AR-50 Sniper Rifle, 640 Guided Missile Launcher.

From damage done the 340 appears to have around 3000 health. With all the points leftover assigned to attack I should win most fights from the spreadsheet but dont. This is one of many examples I have found. Unless the random isnt that random I shouldnt lose as much as I have been.

What's the damage taken/given? My numbers are showing a much closer fight than you're saying. You're off by at least 38 hired guns (he has 199, not 161). That's a large margin.

[somerockenguy]

wow this already needs to be updated theres a new chainsaw out. and this is why i stopped making my own calculator because updating it every week got a pain.

P.S. pm me if you want to see the visual edits i did to the calc. finding the sell value for property is hard i for get how i did it on mine i think it was one of the script options on open office calc.

[Orly?STFU!]

wow this already needs to be updated theres a new chainsaw out. and this is why i stopped making my own calculator because updating it every week got a pain.

P.S. pm me if you want to see the visual edits i did to the calc. finding the sell value for property is hard i for get how i did it on mine i think it was one of the script options on open office calc.

Yeah, I knew something was coming, so I held off the release. I'm working on it now. If you have a cool color scheme, send me ideas. Keep in mind I'm limited to the color palette of Excel 2003.

[Orly?STFU!]

well i dont have an activation email for some reason. arrrggghhh

If you can post, you already activated. :confused:

[Orly?STFU!]

Version 2.1 is now available for download!

This version has many changes, so visit the first post of this thread to learn more about this update. Click the link in my signature to visit the first post.

Starting with this version, I can only use direct download links (the zip is nearly 200k, too big to attach here), so forum registration won't be necessary. Of course, you can download it from the version number in my signature, like always. This is due to having two versions of the sheet, one for Excel 2003+ and one for OpenOffice Calc 3.x.