Mobsters 1 Spreadsheet by Orly?STFU!

[Orly?STFU!]

Greetings! This is the support thread for Orly's MySpace Mobsters Manager. This spreadsheet is growing into a full-fledged management tool for your mob. Future updates will include many useful features for mob bosses and even more statistical analysis of your purchases, fights, and more. Keep an eye on this post for updates, or visit my development site, http://orlysmobmgr.isgreat.org.

What is this, and how do you use it?

Essentially, this is a spreadsheet. To use it, you fill out the highlighted green areas found throughout the sheet, and the spreadsheet will automatically calculate several useful values, from which properties to focus on, whether to buy properties one at a time or in bulk (including a custom bulk rate value for buying 1 to 10 at a time, i.e. how many hours until you can buy that many, etc.), your gross, net, bankable income, upkeep, your bounty, what your attack and defense rating is, what your maximum fight damage can be, your hospitalization health level, and reminders for when you are low on mobsters or equipment for your level. If you've ever wondered why you lose to inferior equipment, the Fight Calculator may help.

Now for some caveats. It's locked down so I'm not inundated with a hundred, "I modified this cell, now it's broken," questions. If you want changes, ask. Don't ask for an unlocked version. If you have any questions, bug reports or suggestions, let me know, and I will fix them if I decide it's warranted. Don't ask me how to modify it once you've cracked it. Let me clarify this for smart-alecs: if you manage to get around the protection (yes, I know how easy it is), don't post a modified version and try to tell me what my rights are. If you want me to continue to develop this, don't spit in my face and circumvent my code. I will NOT support nor endorse any version other than the one I link to in this post, my dev site or in my signature.

Here's a preview image of it so you get an idea of what to expect:

http://i263.photobucket.com/albums/ii147/orly_stfu/MySpace/Mobsters/OrlyMobMgr/35d3b812.gif

And here the additional tabs you can click on:

http://i263.photobucket.com/albums/ii147/orly_stfu/MySpace/Mobsters/OrlyMobMgr/e240b3cb.gif

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 3.x).

Instructions:

VERIFY that you have either Excel 2003, Excel 2007 or OpenOffice.org Calc 3.x (http://download.openoffice.org/) so you can open the spreadsheet correctly. Microsoft Works is NOT supported. Microsoft Excel Viewers will not work either. Don't ask me to make this for other programs, I don't have them, nor the time to do so.
DOWNLOAD the file using the link at the bottom of this post. I can no longer attach the file to this post, so it's a direct download link (no registration needed).
EXTRACT the spreadsheet files from the zip file you download from here.
Failure to do this will open the file in read-only mode or a file corruption error (it's not corrupt, it's just not in a readable format until you extract it). THIS IS THE NUMBER ONE ISSUE I GET EVERY WEEK.
OPEN the .xls spreadsheet file in Excel 2003, or
OPEN the .xlsm file Excel 2007, or
OPEN the .ods file in OpenOffice Calc 3.x.
DO NOT OPEN THE .xls FILE IN OPENOFFICE or VICE VERSA (The investment and worth functions will not work if you do).
ENABLE MACROS in Excel when prompted. For Excel 2003 and OpenOffice Calc, you should get a prompt immediately. For Excel 2007, you need to click the Options button on the Security tab that appears at the top of the spreadsheet, then Enable the content. There aren't any actual insecure macros, only two Visual Basic functions to calculate Investment and Worth info.
FILL OUT the green boxes throughout the sheet with your data from MySpace Mobsters (http://profile.myspace.com/Modules/Applications/Pages/Canvas.aspx?appId=104283).
PROTIP: READ the notations by hovering above field names if you are curious what all the data means (indicated by tiny red triangles in Excel, tiny red dots in Calc)
TELL ME if you found this useful, and report any errors or suggestions for future updates in this thread ONLY
TELL OTHERS how you became FILTHY STINKIN' RICH using this tool.


Version History:

2.2.6

Added: New limited edition items: Kriss Super V Recoilless Rifle, Armored Maybach, M-60



DOWNLOAD LINK: MobstersManager_2.2.6.zip (http://www.fileden.com/files/2008/11/11/2182232/MobstersManager/MobstersManager_2.2.6.zip)

When you're bored with all that, come read my Mobsters Blogs (http://tinyurl.com/orlyblog) for a laugh or two! :D

NEW SITE: I am going to start keeping my development notes on my new site, http://orlysmobmgr.isgreat.org. This thread will be maintained for support issues and update notifications. This way, you can comment on specific releases and see what I'm up to, among other things. Those who are interested in helping me shape version 3.0 should head over there and send me suggestions.

Happy Mobbing,

Orly St.Fu

[Orly?STFU!]

This post is will maintain the previous version of my spreadsheet, version 1.2.9.2. It's a simpler sheet, and will suit many people's needs just fine. Those who want even more calculations will want to use version 2.x, now housed in the first thread.

Essentially, you fill out the highlighted green areas (all in one column), and the spreadsheet will calculate several useful values, from which properties to focus on, whether to buy properties one at a time or in bulk (including a bulk rate value for buying 10 at a time, i.e. how many hours until you can buy 10), your gross, net, bankable income, upkeep, your bounty, what your attack and defense rating is, what your maximum fight damage can be, your hospitalization health level, and reminders for when you are low on mobsters or equipment for your level. If you've ever wondered why you lose to inferior equipment, this will help.

It's locked down, so if you want changes, tell me. There's no macros since you can't use them on all systems. If you have any questions, bug reports or suggestions, let me know.

Here's a preview image of it so you get an idea of what to expect:

http://www.mynetimages.com/9796dcce.gif

If you don't have Microsoft Excel installed, you can use OpenOffice.org (http://download.openoffice.org/) for FREE.
I tried it, and it works fine. The free Excel viewers don't let you enter data. :mad:

Instructions:

EXTRACT the spreadsheet from the zip file you download from here
FILL OUT the green boxes down the left side with your data

To Do:

Nothing, this version is complete. All new updates will be in version 2.x.

Version History:

1.2.9.2

Fixed: Hospitalized At value now shows maximum health you can have in the hospital, not minimum health to stay out of the hospital.

1.2.9.1

Fixed: Healing Cap annotation references Maximum Health instead of Maximum Energy (calculation didn't change).

1.2.9

Added: Armored Rolls Royce vehicle with annotations
Changed: Instead of using >> to denote best (>>) and worst (>>), it now uses ++ and --, respectively. This will help the colorblind folks distinguish betwen them.
Added: Editable cells now use validation to make sure you don't enter invalid values.

1.2.8

Fixed: Widened COST XX column to allow for large purchase amount totals
Updated: Moved "Use Bank?" checkbox next to Net Income and Bankable Income
Added: annotated debt/income ratio graph

1.2.7

Removed: Static RATE 10 column (use the custom rate option instead)
Added: Custom COST XX column to show you how much to save depending on the Custom Purchase Rate value
Added: Purchase Recommendation Indicators - Color-coded ">>" symbols appear next to the properties you should buy (green) or avoid (red)
Added: more annotations
Added: Custom Purchase Rate value become red when out of range (less than 0 or more than 10)
Added: Custom RATE (and COST) now have error-checking if Custom Purchase Rate is out of range
Fixed: RPGs are available at level 15, not 20, so annotation and color-coding has been fixed to reflect this
Removed: I deleted the version that had unhidden formulas, mostly to avoid confusion. I was getting too many support questions by people using it instead of the normal one since they were having trouble filling it out. I'll repost the 1.x.x version again once version 2.0 is available. Please be patient.
Updated: credits should be up to date, including the shortened url directly to this post

1.2.6

Added: Property Subtotals
Added: For those who want to see the formulas used, download the "unhidden" version. It's still locked, but now you can click on the locked cells. Note that it's far easier to fill out the primary version for normal use, since you can only select the cells you can edit.

1.2.5

Fixed: Minor display issues with OpenOffice.org labels
Added: Graph to show you your fighting balance
Added: Graph to show you your earning efficiency
Added: Moved and added functionality to the Use Bank checkbox
Added: Annotated Current Income for Territories

1.2.4

Fixed: Hired Gun calculations corrected
Fixed: Attack and Defense formulas updated to be more accurate
Fixed: Rate formulas no longer allow negative income
Added: Healing Cost added
Added: Several more annotations and tips, like what level you unlock items, and more
Added: New color-coding to indicate items that you haven't unlocked or don't meet minimum requirements to purchase
Added: Slightly adjusted top data structure to fit new entries for readability

1.2.3

Fixed: Max Healing Cap calculation corrected to 2/3 Max Health
Fixed: Slightly adjusted a couple of annotations

1.2.2

Fixed: Max Fight Experience calculation corrected
Fixed: Healing Cap adjusted to %70 Max Health
Added: Broadcast Cost
Added: Max Fight Payout
Added: Most fields are now annotated with descriptions and tips

1.2.1

Fixed: Custom Purchase Rate bug fixed (pulls correct pricing now)

1.2.0

Fixed: Attack and Defense points not using correct weapons
Added: New column for armaments showing what is used in attacking or defensive fights

1.1.1

Added: Maximum Healing Cap

1.1

Fixed: Max Mob Size was incorrectly reporting numbers larger than 500 after level 100
Added: Maximum Fight Experience added (thanks to -tommy-)
Added: Custom Purchase Rate for properties added (inspired by pizzamaker27)[/SIZE]

1.0

Initial Release


Those of you looking to learn how this got started, you're welcome to download the "no password" version of 1.0, attached to this thread. Just unprotect it (there's no password), and you'll be able to tinker around.

[rubernck21]

Thank you for the updates...keep up the fantastic work.

[natewhit99]

you are frickin amazing this thing is awesome

[The Strange Hippie]

How bout this... I was using 1.2.5 and I now have the newer version... do I have to enter all my dadt again or is there a way to import it from the other one?

Also... my attack/defense bars are 50/50 ... that's far from wrong! LoL!

[Chris]

How many colour blind people complained?
Lul

[Orly?STFU!]

How bout this... I was using 1.2.5 and I now have the newer version... do I have to enter all my dadt again or is there a way to import it from the other one?

Also... my attack/defense bars are 50/50 ... that's far from wrong! LoL!

You can copy and paste each section in by holding CTRL and selecting one grouped section, then pasting it into the new version. Be careful pasting vehicles since the Rolls Royce was added. That's how I transfer my own data.

[Orly?STFU!]

How many colour blind people complained?
Lul

Just one, but it was a valid concern, so I fixed it.

[Asteria]

Today...you are my hero.. its perfect, and saved me from making a couple costly mistakes already.

thanks

[Orly?STFU!]

Awesome! The down side is that it will be more expensive to hitlist all the rich people. :)

[PowerOfRaistlin]

in cell 5e (max healing cap), i believe there is a small error. it says 2/3 of your max energy. shouldn't this be health?

[The Black Seraph]

That "use bank" checkbox is going to be very useful for not just me but a lot of people I'm sure. Keep up the great work!

[Throxx]

I have just joined lately and have downloaded this awesome spreadsheet. I cannot yet contemplate how much it will help me, but I'm sure the value is great.

However, a small, yet I think important criticism. I see no place to import a value of current bankroll or cash on hand? Will that not affect outcomes?

Thanks.

-t

[wxtraveler]

The amount of money in the bank will not affect any of the formulas.

The rate and cost formulas are set up show you the # of cycles at your current income rate.

Basically, if you are maxing 5mil per cycle the formulas are going to show you that it will take 5 cycles to make 25mil regardless of what you have in the bank.

If you already have 25mil set up then you already know that you will not have to wait any cycles.

If you have X amount already and you are saving for a big purchase (call it Y) then all you have to do to adjust the cycles would be:

1. Take the total of said large purchase (Y).
2. Subtract what cash you have on hand (x).
3. Divide the remainder by your NET income (listed on the spreadsheet).

So... (Y-X)/NET= Adjusted cycles.

It would be simple to add that functionality to the spreadsheet, but the general idea is that you should always reinvest cash ASAP... so you would only use that kind of function while saving for those really large purchases.

[Orly?STFU!]

in cell 5e (max healing cap), i believe there is a small error. it says 2/3 of your max energy. shouldn't this be health?

Fixed in version 1.2.9.1 (no other changes made).

[Orly?STFU!]

I have just joined lately and have downloaded this awesome spreadsheet. I cannot yet contemplate how much it will help me, but I'm sure the value is great.

However, a small, yet I think important criticism. I see no place to import a value of current bankroll or cash on hand? Will that not affect outcomes?

Thanks.

-t

wxtraveler is right, the current, simple spreadsheet assumes maximum investment efficiency by reinvesting your funds as soon as possible, so there isn't a bank balance to use in calculations. The new, in-depth version I've been working on will have many more sheets with plenty of calculations using bank balances, etc.

[Dead Eye Jedi]

Thank you very much for taking the time to create such an awesome workbook. I have so many scratch pieces of paper laying around my desk, its very nice to be able to just plug in figures and get the results. Kudos.

One small discrepancy I have noticed is the relationship between undeveloped and developed land costs. Right now, the developed land cost assumes that the undeveloped land is bought at its cheapest price. Currently I own 210 vacant lots, which obviously changes the overall cost per townhouse or Restaurant, and therefore changes the over all ROI.

I realize this is fairly minuscule compared to the grand scheme of things, but I think it may become more helpful for those of us that plan to keep pushing past $100 million / cycle.

Again, thank you for sharing your hard work with the rest of us. Its obvious that you've put a lot of time into your project.

[codyology]

i'm using open office it is keeps opening as read only, is there something i'm doing wrong if so can someone please explain

[awsing61]

I can onl open the spreadsheet as read only. I have entered all my data and cannot save it.:confused:

[codyology]

ok now mine is finally working and able to save now

[permafrost]

I love the spread sheet but I am having a hard time understanding the ROI.

This is what I did.
I bought properties until it would not pay for itself in 500 payments.
name profit addedcost purchase total cost $-2-$value
dwntwnshppngmall 500000- 1,000,000- 50,000,000 -51000000-$102.00
skyscraper 150000- 1,000,000- 64,000,000- 65000000-$433.33
Store front-20 300- 0- 150,000- 150000- $500.00
Vacant Lot-90 100- 0- 50,000- 50000- $500.00
Shipyard-0 20000- 4,000,000-6,000,000- 10000000-$500.00
seaside-0 8000 0 4,000,000 - 4000000 $500.00
Plaza-0 2000 0 1,000,000 1000000 $500.00
Townhome-140 300 5,000 150,000 155000 $516.67
seaside rsrt 200000 4,000,000-100,000,000-104000000-$520.00
restaurant-110 700 5,000 360,000 365000 $521.43
Hotel-120 10000 50,000 5,200,000 5250000 $525.00
Condo-120 5000 50,000 2,600,000 2650000 $530.00
Casino 300000 1,000,000-160,000,000-161000000-$536.67
Yachthrbr-40 50000 4,000,000-25,000,000-29000000-$580.00

So I am wondering if my theory is wrong? I did it like I was paying money for acreage. I guess I am going to have to think about my theory here :)
your spreadsheet told me to buy more seaside resorts so I am really confused.

[FyiFoff]

I love the spread sheet but I am having a hard time understanding the ROI.
So I am wondering if my theory is wrong? I did it like I was paying money for acreage. I guess I am going to have to think about my theory here :)
your spreadsheet told me to buy more seaside resorts so I am really confused.

PS: for those buying in the 100's just replace thousand where millions is!


there is only a few lands you will be buying,

Skyscraper 1.5m
Casino 3m
Shipyard (SKIP)
Yacht Harbor 500K
Seaside Resort 2m

and then
Downtown Shopping Mall 5m

reguarless of what you have, look at the per million, per half million, or the even cost per six million

skyscrapers might cost less for 10 then seaside resorts, ((but seaside resorts will make you 12m more a day, but how many days will you have to wait, that's why i hate this part, and don't do it this way))

at the start 10 seasides with its sea lot might cost 100m, the same cost of ten casinos. or 110 million. so there is no "true" way or pattern, per say.

MY MAIN BELIEF IS BUY THE NEXT THING YOU CAN IN BULK, IN BLOCKS OF TEN.

YOU WILL HIT A FEW BUMBS WHERE YOU MIGHT HAVE TO WAIT 4 OR 5 DAYS TO BUY THAT NEXT BULK. AND IT WILL HAPPEN A FEW TIMES. DEAL WITH IT!!

I went from 2.5 to almost 5 million in a week. I had to wait a little longer and went from 4.5 to 7.5 becasue of the casinos. but 7.5 times 24 hours, and you fly... I make 500M a day, at level 45.

[Dead Eye Jedi]

Just takethe total cost to buy property (Undeveloped + Developed) / Increased Income per Cycle = Cost per Increased Dollar of Income. Always buy the cheapest one.

[terry73178]

Can you add a bank balance? By connecting it to the amount of turns needed to buy properties you can get a truer sense of how many hours you need to get a property.

[Mr_Frosty_Fingaz]

Little thing I noticed: On the "Hospitalized at" calculation section: My health is 200 I'm hospitalized at 39 (not 40 as indicated by the spreadsheet). I'm actually out of the hospital and able to attack at 40.

[Orly?STFU!]

Can you add a bank balance? By connecting it to the amount of turns needed to buy properties you can get a truer sense of how many hours you need to get a property.

I may do this update, but I'd really like to continue developing the re-write.

[Orly?STFU!]

Little thing I noticed: On the "Hospitalized at" calculation section: My health is 200 I'm hospitalized at 39 (not 40 as indicated by the spreadsheet). I'm actually out of the hospital and able to attack at 40.

Hah, that's true. I'm fixing it in 1.2.9.2.

[Granny Goff]

HELP!! I'm trying to download the latest version, but every time I click on the link, it brings me back here. It's a nice thread and all, but I don't want to live here!! :D:D:D

[Orly?STFU!]

HELP!! I'm trying to download the latest version, but every time I click on the link, it brings me back here. It's a nice thread and all, but I don't want to live here!! :D:D:D

It's an attachment to the first post of this thread. The link in my signature just goes to this thread.

[Aaron]

Thanks for the spreadsheet. It has helped a lot.

[Granny Goff]

It's an attachment to the first post of this thread. The link in my signature just goes to this thread.

Oh crap...I figured that out before because I have downloaded previous versions. What can I say...it was late so I must have been half asleep! :o

Thanks! :D

[ProjectDan35]

I downloaded Open Office. it took 45 minutes! and i did use the spreadsheet. its quite the invention.

[Midnight Watch]

Ten points for cool suff!

[Orly?STFU!]

Since the larger version is taking a long time to develop due to the sheer number of calculations I'm working with, I'll probably create an update to the current, simpler version that incorporates a few of the requested features, like the ability to enter cash and bank balances, your mob type, and adjust the formulas based on your total cash on hand.

No need to request it, it's high on my to do list.

[ProjectDan35]

haha nice blog orlystfu!

[mbond79]

Hey guys...
I need a little help here with this...

I have Microsoft Works and it can open standard spreadsheet files...
But when I try to open this one it says that the file is either password protected or encrypted and that I should open it in the program that created it and remove the password or encryption...

Any help will be appreciated...
TIA :D
The 'Biggg' One
Michael B.

[ProjectDan35]

You have to Un-Zip it.

[Orly?STFU!]

Hey guys...
I need a little help here with this...

I have Microsoft Works and it can open standard spreadsheet files...
But when I try to open this one it says that the file is either password protected or encrypted and that I should open it in the program that created it and remove the password or encryption...

Any help will be appreciated...
TIA :D
The 'Biggg' One
Michael B.

Check the requirements in my sig.

[redrum727]

i tried to download zip but when down laod its not a zip file its a .ew somthin or other please help I have the open office

[Ellemax]

I have Microsoft Works 07 and I only have Microsoft spreadsheet which wont let me open the file because its password protected or encrypted. Any help?

[FrankieV]

Hi. I would like to see what the rates are for buying bulks of weapons/armor/vehicles in the spreadsheet, just like it does for properties. Thanks!

[Christopher]

Hi. I would like to see what the rates are for buying bulks of weapons/armor/vehicles in the spreadsheet, just like it does for properties. Thanks!

The price rate of equipment doesn't change. Do you mean you want to see the price of buying different amounts?

[bw83]

Orly? , I had one question I noticed in the notes under the very first post you talked about having a locked but not hidden version of this. Im by no means trying to steal your formula and can show you what i wanted to use it for but im working on a "payment due date" and "bills register card" excel thing for my finance office (im in the army) and i have it done but some of the features you use like changing text color and stuff are the featuers i really like and tried to put into my spreadsheet and was wondering if it'd be possible to get the unlocked one or get some help on the color changing when other cells arent true and such.

[redrum727]

Stilll having trouble being able to open the sheet in open office. Saying its .edw file or something like that some times get a courrupt file warning please help I would like to use this sheet

[shjchica]

For some reason when I try to open the version I just downloaded it opens it in read-only mode and I can't use it....anyone know why?

[BALLS]

EXTRACT the spreadsheet from the zip file you download from here
FILL OUT the green boxes down the left side with your data
????
PROFIT?!?



new***, lulz

[Darth Vodka]

Oh, lord. /b/ has discovered these forums.

[Orly?STFU!]

Orly? , I had one question I noticed in the notes under the very first post you talked about having a locked but not hidden version of this. Im by no means trying to steal your formula and can show you what i wanted to use it for but im working on a "payment due date" and "bills register card" excel thing for my finance office (im in the army) and i have it done but some of the features you use like changing text color and stuff are the featuers i really like and tried to put into my spreadsheet and was wondering if it'd be possible to get the unlocked one or get some help on the color changing when other cells arent true and such.

Changing text colors based on cell contents is pretty easy, just look up "Conditional Formatting". My examples won't help you much since they're only good for Mobsters. There's far better examples on the web, and that's where I learned it.

[Orly?STFU!]

Oh, lord. /b/ has discovered these forums.

Shhh, Rule 1 & 2, ya know. ;)

[Orly?STFU!]

Stilll having trouble being able to open the sheet in open office. Saying its .edw file or something like that some times get a courrupt file warning please help I would like to use this sheet

I have no idea what you're trying to open. The downloaded file is a .zip file containing the .xls file (Excel Spreadsheet). Make sure you're using OpenOffice.org's Calc program, or Excel 2003/2007.

[Orly?STFU!]

new***, lulz

Thank you for your highly intelligent contribution to these discussions. :rolleyes:

[Orly?STFU!]

For some reason when I try to open the version I just downloaded it opens it in read-only mode and I can't use it....anyone know why?

Did you extract the .xls (Excel Spreadsheet) file from the .zip (ZIP-compressed) file you downloaded? Also, I hear some get read-only access when they try to use OpenOffice.org's suite incorrectly. If you are using OpenOffice.org, make sure to only open it in OpenOffice.org Calc, not the other programs in the suite.

[Orly?STFU!]

I have Microsoft Works 07 and I only have Microsoft spreadsheet which wont let me open the file because its password protected or encrypted. Any help?

Grab OpenOffice.org (FREE) and install the Calc portion of the suite at least. That will open it just fine since it actually emulates most features correctly. I can't support Microsoft Works.

[Claudi Giamatti]

:D This is an excellent sheet you've done. I really like the attack/defense ratio. :)Telling me I have 51% attack, 49% defense. :D I want more attack. Although, I do not understand the whole property bit down the bottom with the percentages and then the little -- or ++ against their names. Explain please? :)

[bw83]

Changing text colors based on cell contents is pretty easy, just look up "Conditional Formatting". My examples won't help you much since they're only good for Mobsters. There's far better examples on the web, and that's where I learned it.

i looked at em a lil bit yesterday but i'll take a better look today... this spreadsheet is the only thing they have me doing at the office anyways this week so its relaxing lol

[Vinny the Hitman]

Although, I do not understand the whole property bit down the bottom with the percentages and then the little -- or ++ against their names. Explain please? :)

The ++ signifies the "best buy" property (i.e.--highest Return On Investment)
The -- signifies the "worst buy" property (i.e.--lowest Return On Investment)

[FrankieV]

The price rate of equipment doesn't change. Do you mean you want to see the price of buying different amounts?

I'd like to see quickly how many cycles to buy 100 SWAT without having to whip out a calculator. It's easy to calculate, but I'm really, really lazy.

No, but what would really come in handy is a sell/upgrade calculator... How many cycles (or how much cash) do I need to buy 100 SWAT if I sell 40 Armored and 60 Escalades--taking into account the extra income/cycle if I sell NOW or if decide to WAIT for when I buy the bulk SWAT. Sounds complicated.

[Orly?STFU!]

I'd like to see quickly how many cycles to buy 100 SWAT without having to whip out a calculator. It's easy to calculate, but I'm really, really lazy.

No, but what would really come in handy is a sell/upgrade calculator... How many cycles (or how much cash) do I need to buy 100 SWAT if I sell 40 Armored and 60 Escalades--taking into account the extra income/cycle if I sell NOW or if decide to WAIT for when I buy the bulk SWAT. Sounds complicated.

I am working on a version that will have more calculations like you want. It's just very big, and takes some time to make it user friendly.

[Orly?STFU!]

:D This is an excellent sheet you've done. I really like the attack/defense ratio. :)Telling me I have 51% attack, 49% defense. :D I want more attack. Although, I do not understand the whole property bit down the bottom with the percentages and then the little -- or ++ against their names. Explain please? :)

Nearly every field has a note attached to it. Just hover your cursor above the field name and a note with tips and descriptions should pop up. In Excel, they look like little red triangles, in OpenOffice, they're little dots, if memory serves.

[Claudi Giamatti]

Nearly every field has a note attached to it. Just hover your cursor above the field name and a note with tips and descriptions should pop up. In Excel, they look like little red triangles, in OpenOffice, they're little dots, if memory serves.

I know, and I used those. :D But then like, some stuff doesn't have the red triangles, so yeah. :P

[GeneralLuminescent]

nice! ;);););) Very useful.

[Please be Mobsta]

is microsoft excel free?

[Vinny the Hitman]

is microsoft excel free?

No, but openoffice in Orly's sig is!

[Goodfella1076]

I also have to say thanks for this spreadsheet. It's professionally done, it has helped me figure out the game mechanics and to keep track of my equipment, property, etc.

[gma5]

I've tried to download but am unable to. Can you help

[Orly?STFU!]

I've tried to download but am unable to. Can you help

Look near the bottom of the first post of this thread. Click the attachment link to download the compressed ZIP file which contains the spreadsheet. I don't know how else to help you with so little troubleshooting details given.

[Orly?STFU!]

I've released version 2.0.0, redubbed as Orly's MySpace Mobsters Manager. The first post of this thread has the link, and the second post contains the archived previous version, 1.2.9.2.

Enjoy!

[ninja407]

This is an awesome spreadsheet, I Know that ORLY took alot of time to do this. I will say that this thing has WAY too much info on the front page, I am also not too fond of the color, but hey it is functional and thats all it needs to be. Keep up the hard work ORLY :)

Teh Ninja!

:cool::cool:

[Orly?STFU!]

Yeah, I wish the color palette was better in Excel 2003, but its not. Excel 2007 is WAY better, but OpenOffice doesn't support those color schemes either. I'll see what I can do to spruce it up in later versions.

As for too much info, you're right, and when the remaining tabs are complete, it'll be redistributed in a clean fashion.

I had to release this version because it has many calculations that I've been getting tons of requests for. It's nowhere near as pretty as I'd like, but it'll improve.

[Darth Vodka]

I'm digging the new spreadsheet. Very functional, and I love seeing the daily and weekly income. It lets me do some long-term financial planning.

[ninja407]

Ok after noticing the E/E Ratios for the missions was off, I double checked them, and found that a couple of them were off.

The High stakes gambling is 15 energy/25 XP, not 25/25
Bank Robbery mission is 25 Energy/30 XP. n ot 20/30

I think thats it. I'll let you know if I spot anything else.

teh Ninja:cool:

[The Strange Hippie]

Love the update but... my attack and defense are 50/50... that's not right.

[Orly?STFU!]

Love the update but... my attack and defense are 50/50... that's not right.

It's not? PM me the numbers used in the Fight Stats area so I can double check the formulas. It's working for me, so I want to make sure it's accurate.

[Orly?STFU!]

V 2.0.1 contains the fixes to the Mission Data tab discovered above. Thanks! I'm sure there will be more updates as time goes on.

Remember, you can transfer your data from one spreadsheet to a new version by selecting grouped cells and copying and pasting them into the updated sheet. This is how I transfer my own data between versions.

[The Strange Hippie]

Nevermind... It changed... I had to save my data then reopen it and it was right. Love the update! WTG!

[Jimmy Crobar]

hey Orly

great sheet however it seems to have a few matematical glitches maybe you can shed some light

im playing as a tycoon

im netting $50,000,000 exactly every 55 minutes

by my calculations I should be netting $1,300,000,000 every 24 hours (26 pay cycles) yet your spread sheet says it should be $1,309,000,000

if i were to bank my funds $45,000, 000 per cycle I should be banking $1,170,000,000 per day yet your calculations state it should be $1,178,100,000 per day

can you check and see if your calculations are off slightly?

thanks for the great sheet

[Christopher]

Not Orly, but there are 1440 minutes in a day; divide that by 55 minutes in a cycle and you get 26.181818 repeating cycles in a day. Orly's sheet uses 26.18, that means $50,000,000 times 26.18 equals $1,309,000,000 per day.

1440 min in a day / 55 min per cycle = 26.181818 cycles per day

26.181818 cycles per day rounded two decimal places = 26.18 cycles per day

26.18 cycles per day * $50,000,000 per cycle = $1,309,000,000 per day


You could use:

$50,000,000 per cycle * (288/11) cycles per day = $1,309,090,909 per day

That would be more accurate.

[Orly?STFU!]

Not Orly, but there are 1440 minutes in a day; divide that by 55 minutes in a cycle and you get 26.181818 repeating cycles in a day. Orly's sheet uses 26.18, that means $50,000,000 times 26.18 equals $1,309,000,000 per day.

1440 min in a day / 55 min per cycle = 26.181818 cycles per day

26.181818 cycles per day rounded two decimal places = 26.18 cycles per day

26.18 cycles per day * $50,000,000 per cycle = $1,309,000,000 per day


You could use:

$50,000,000 per cycle * (288/11) cycles per day = $1,309,090,909 per day

That would be more accurate.

It would be more accurate, but I'm rounding off at 2 decimal places. It's only meant as an approximate guide, so I felt it was close enough.

[212th Battalion]

I like the new sheet. Especially how it uses the bank balance, your hourly income rate to determine when you can by the next property in however many quantity you want. NICE!

[mad medic]

This save me quite a bit over the last two days. BEAUTIFUL spreadsheet!

[Vinny the Hitman]

It would be more accurate, but I'm rounding off at 2 decimal places. It's only meant as an approximate guide, so I felt it was close enough.

Whoa, whoa, whoa...this is ONLY an approximate guide and only 99.99% accurate???

I'm outta here...

:D:D:D:D

/end sarcasm


Great job as always Orly...

[michaeless]

There is something wrong with the spreadsheet.
I am a level 21 and I have 110 Armored Trucks.
On the Attack column is says 105 which is correct
but the defense use column says 110

So far everything else checks out. Thanks for making this spreadsheet. I made my own originally but I switched to yours because it was easier for me.

[gma5]

I've downloaded open office and I still am unable to download the spreadsheet it continues to tell me the file is corrupt can anyone help

[Orly?STFU!]

There is something wrong with the spreadsheet.
I am a level 21 and I have 110 Armored Trucks.
On the Attack column is says 105 which is correct
but the defense use column says 110

So far everything else checks out. Thanks for making this spreadsheet. I made my own originally but I switched to yours because it was easier for me.

Yikes, that's a bug, fixed in version 2.0.2, which is available now.

[Orly?STFU!]

I've downloaded open office and I still am unable to download the spreadsheet it continues to tell me the file is corrupt can anyone help

What file? The .zip file that you downloaded from here or the .xls file, contained inside the compressed .zip file?

You need to open the .xls file in OpenOffice Calc. You can't open the .zip file in Excel or Calc. Try double-clicking the .zip file, then it should open, revealing the .xls file, which you can then drag to your desktop and open properly.

[whelin]

best way to see my stats and how to fight with others THANKS!!!!!!

[Sephirious]

ok, there is a place on the Fight Calc to input your opponent's attack and defense strength. my question is how are you supposed to know how many skill points the other person has in these areas? I mean isn't that a calc that the sheet should tell you, not the other way around?

[ChubyMuscles216]

Downloading now, will tell you what I think of it in a minute or so.

[Dead Eye Jedi]

Nice upgrades to 2.0. Think we could get a row added to the "MOB STATS" table on the "Mob Data" tab to show how much experience is needed between levels?

Thank you.

[Orly?STFU!]

ok, there is a place on the Fight Calc to input your opponent's attack and defense strength. my question is how are you supposed to know how many skill points the other person has in these areas? I mean isn't that a calc that the sheet should tell you, not the other way around?

Those fields are there so you can try to make sense of fights you lost (or won). Enter the data you DO know, and tweak the remaining numbers to see how the numbers play out. It can also be used by those trying to crack the fight formula for testing.

[Orly?STFU!]

Nice upgrades to 2.0. Think we could get a row added to the "MOB STATS" table on the "Mob Data" tab to show how much experience is needed between levels?

Thank you.

Nice idea, I may just do that.

[Smokes em]

All of the income cycle calculations should really be rounded up to the next whole number. Like right now it is telling me that to buy 10 more malls is going to take 14.46 cycles. Realistically, it's 15 cycles.

[Orly?STFU!]

All of the income cycle calculations should really be rounded up to the next whole number. Like right now it is telling me that to buy 10 more malls is going to take 14.46 cycles. Realistically, it's 15 cycles.

That was done due to requests from several people, but have no fear, my next will have a solution for you.

[redrum727]

Please help me when i click to download the link it says its a mobstersmanager 2.02.1.321co2.efw file it will not down load as a zip filee some one please help me out. Really want to try this.

[Orly?STFU!]

Please help me when i click to download the link it says its a mobstersmanager 2.02.1.321co2.efw file it will not down load as a zip filee some one please help me out. Really want to try this.

Compressed .ZIP or executable .EXE file renamed by CA Security Centre to have a ".efw" extension; typically applies to e-mail attachments scanned by Computer Associates (CA) antivirus software.

EFW zipped files may be opened by changing the file extension to ".zip" and opening the file with a decompression utility, such as WinZip or Stuffit Expander; executable files may be run directly by changing the file extension to ".exe" and opening the file.

[redrum727]

thank you ok so how and where do I change the file extension I went to properties but could not change extension

[redrum727]

ok I think I got it all I did was turned off the incomming email protection from firewall and redownloaded file and it was a .zip file

[Orly?STFU!]

thank you ok so how and where do I change the file extension I went to properties but could not change extension

I'm not familiar with your antivirus program, so maybe it's stopping you from renaming it?

Either way, you can use a free zip/unzip program, and when you go to open the .efw file, you can pick that program to open it, then extract the spreadsheet. As a test, I installed FreeZip, available for FREE here (http://members.ozemail.com.au/~nulifetv/freezip/index.html). When I double-clicked the .efx file, I was given the option to choose a program to open it with. In the list of applications, "unzip" appeared. I made sure to make it the default application for .efw files, and from then on, double-clicking .efw files automatically extracts the contents.

I hope that helps others having this issue as well.

[Smokes em]

That was done due to requests from several people, but have no fear, my next will have a solution for you.

Sweet, thanks!

I can't think of any reason anybody would want that. The only reason it would make sense to me to have decimals would be if it was synced with the actual cycles in Mobsters. Then if you were at say 30 minutes until the next pay cycle, it would make sense for Rate or Hours to be 5.5. Other than that, the only place decimals make any sense to me would be on Days, which would be even better if it were dd:hh instead of whole numbers with decimals.

[ddatchi]

I don't know if you have already addressed this yet but, I54 on the 'Fight Calculator' appears to have a problem. From what I can deduce by how items are arranged on 'Equipment Data' and how the similar math appears to works on E44-E53 of 'Fight Calculator', the calculation in I54 [referencing the integer in I44-I53] is not pointing to the correct Attach Strength value on 'Equipment Data'. Same applies for E54 calculation (I think) Just seems to be a pointer problem due to the order of the Vehicles.

Please let me know if I am wrong on my assumptions (since I can't really see the formulas). I audit formulas in Excel @ work @ ExxonMobil. I'll let you know if I see anything else that doesn't seem right.

I really hope I am correct on how these things are calculated otherwise I'll feel real [idiot like]......

Please Advise

Thanks,
Dave

<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.</div> (http://forum.mobstersapp.com/announcement.php?f=2)

[Orly?STFU!]

I don't know if you have already addressed this yet but, I54 on the 'Fight Calculator' appears to have a problem. From what I can deduce by how items are arranged on 'Equipment Data' and how the similar math appears to works on E44-E53 of 'Fight Calculator', the calculation in I54 [referencing the integer in I44-I53] is not pointing to the correct Attach Strength value on 'Equipment Data'. Same applies for E54 calculation (I think) Just seems to be a pointer problem due to the order of the Vehicles.

Please let me know if I am wrong on my assumptions (since I can't really see the formulas). I audit formulas in Excel @ work @ ExxonMobil. I'll let you know if I see anything else that doesn't seem right.

I really hope I am correct on how these things are calculated otherwise I'll feel real [idiot like]......

Please Advise

Thanks,
Dave

Join My Mob --- >> www.myspace.com/bigneddave:D

Nope, you're right, when I added the Armored Rolls Royce, it messed up the formulas for that sheet. I'll have it fixed in the new version tonight.

[Orly?STFU!]

Version 2.0.3 is ready!

This one fixes a glaring formula error on the fight calculator and adds some new experience formulas and purchasing options.

Ever wonder how many experience points you'll need to reach level 400? Make your level 399, then it'll tell you what you need to reach that lofty goal. Right now, that formula is proven to work through the 500's (where you need 100,000 experience point to go up a level). Once we discover at what level you need 1,000,000 per level to advance, I'll update it. I'm guessing 600, but who knows?

[Orly?STFU!]

Update to 2.0.3! I made a functional error when I was adding a new feature. Please re-download the spreadsheet if you grabbed it before 10/22 12:20am CST. The change isn't enough to add a version number, so I'm keeping it at 2.0.3.

[Smokes em]

I see you added "Rounded Rate?", which addresses what I mentioned about the cycles, but I'm curious about the reasoning behind rounding days to the tenth...

[Orly?STFU!]

I see you added "Rounded Rate?", which addresses what I mentioned about the cycles, but I'm curious about the reasoning behind rounding days to the tenth...

That's accurate to the hundredths, actually. As a Tycoon, I earn a slight bit more than non-Tycoons, and that number is a fractional amount. The rate is "proper" by keeping it rounded, since income cycles are just that, an integer number. It's just that for Tycoons, that cycle is still a fraction. Here's an example:

I have to wait 16 cycles to earn enough for my next 10 Seaside Resorts. As a Tycoon, that's 880 minutes EXACTLY, or approximately 14.67 hours or 0.61 days. Now, I'm sure you're not going to tell me that even if I rounded hours up to 15, that 15 hours = 1 day? Thus, hours and days need a fractional amount. While it's true that non-Tycoons don't need the fractional amount for HOURS, the data is still accurate. 15 = 15.00, and all that. That, and 15 hours will still force me to make days = 0.63.

I could make the sheet even more complex and not use decimals for hours for non-Tycoons, but it's not as simple as that. I've yet to find a conditional format function that can change the number format based on another cell's value. If I find it, I'll make the extra .00 go away for non-Tycoons. If you saw what I have to do now, you'd agree that it's not worth it.

[freeport28]

It's an invaluable tool for making the right decision! great job! i'm using the earlier one and was going to update but with the Ambulance add on, i guess i'll wait a little longer. Thanks for providing the Sheet.

[psimpson21]

I love this spreadsheet, its great, curious though if you will provide an update for the new missions/ equipment being offered

[Midnight Watch]

To Do:

Add Property Sale calculations (trying to avoid scripting)
Add more features to calculators
Mob Boss Tool
Move the intricate details still on the Mob Data sheet to pertinent tabs so as to reduce the main sheet's clutter


I actually have been working on the Property Sales calculations already. I have them in a sheet on the 1.2.9.2 version that I am more than happy to share back with you if you're interested. Conditional formatting on it to show green if you don't go over your total cash, and red if you do. I assume with it that all your cash is in one place, and provide a spot to enter it in to give you total costs off of property and equipment. If you're interested, let me know in a message on my profile. I just sent you an add request. My Display name is "The darkness of life...". ~Throws up a peace sign~

[Orly?STFU!]

I actually have been working on the Property Sales calculations already. I have them in a sheet on the 1.2.9.2 version that I am more than happy to share back with you if you're interested. Conditional formatting on it to show green if you don't go over your total cash, and red if you do. I assume with it that all your cash is in one place, and provide a spot to enter it in to give you total costs off of property and equipment. If you're interested, let me know in a message on my profile. I just sent you an add request. My Display name is "The darkness of life...". ~Throws up a peace sign~

I'm not sure if that formula is what I'm looking for. However, since I haven't had much time lately to work out the math needed for that (which wouldn't need a macro), if you've worked it out, I'll gladly include it and credit you. Otherwise, I'll be working it out soon -- assuming the GF stops adding new stuff to mess up my plans. :D

[Orly?STFU!]

v 2.0.4 Update - now with Ambulances!

Enjoy!

[PetrolHead]

I have the sheet with no password on it so i can mess with it :D

Would I be able to just add a row in and input the data for the ambulance into this sheet and it automatically work? Or would this screw up calculations in other cells?

[Midnight Watch]

Well, first off, the only way to get the password off of it is:

A)Orly?STFU! sent it to you that way (NOT GONNA HAPPEN)
B) You got a password cracker and got the password that way (Kinda illegal since the password is used to basically protect his work so you can't claim it as yours.)
C) You loaded it into Google Docs and are editing it there. (Looses almost all formatting that way)

Yes, it would probably mess up the calculations for the other cells, as (from looking at it myself) they use relative formulas. I suggest you leave it alone, and let Orly?STFU! send out the new sheets, and you just use them that way.

@Orly?STFU!: I'll PM you with a link for the sheet I did off the 1.2.9.2 version as soon as I get it uploaded. I haven't added all the comments to it yet, but I'll let you know what password I put on it when I did it so you can change it. You might want to look over the conditional formatting rules, as you're better at them than I am. Mine, you paste something in the cells, the formatting no longer works. No clue why, either. Give me like, 5 minutes to upload it and send you the link.

[Orly?STFU!]

I have the sheet with no password on it so i can mess with it :D

Would I be able to just add a row in and input the data for the ambulance into this sheet and it automatically work? Or would this screw up calculations in other cells?

Why are you asking? If you felt it necessary to crack the password hash (which isn't hard, so it's not impressive), then why should I assist you in repairing it when it becomes unusable? :mad:

[Orly?STFU!]

v 2.0.5 update, already! I made a minor error on the Mission Calculator - you can't actually check the "Sell Ambulance?" checkbox. Ooops.

[Orly?STFU!]

Now then, time for a little survey.

Since I actually update this thing on a fairly regular basis, I've tried to make it easy to move data between sheets via copy/paste of grouped cells. After all, I use it myself. To that end, I'm looking into making it even easier. So, here's the change I'm proposing:

Would you like it if ALL data that you can enter regarding your stats, equipment, and territory can be copy/pasted at once? To do this, I would need to group all editable cells into one column. I can certainly do it, and this is the time to give me some feedback since I'm about to start a major redesign on the front Mob Data page.

Just send me a PM with your opinion (http://forum.mobstersapp.com/private.php?do=newpm&u=2316) to keep the thread clean.

Thanks!

[ninja407]

How did you like the color scheme I sent you? I find it easier to look at myself, but thats just me :)

Ninja 407

[seraphlord23]

This is a cool way of using Excel for the Mobster App keep up the good work I was using one of the older spreadsheets 1.2.8 for the longest it helped me work on how to do my mob stats and gave good information also. Glad for the update still learning how to cruise through forums. Thanks again for your hard work.

[Midnight Watch]

I have sent you the links. There's two because I don't know what version of Office/Open Office you are using. The one that has all of the formatting for what I've done is the XLSX link, while the XLS link had to remove part of the conditional formatting to conform to the rules of the filetype. You have full on permission to play around with and edit/add to/ remove from what I sent you.

[PetrolHead]

Why are you asking? If you felt it necessary to crack the password hash (which isn't hard, so it's not impressive), then why should I assist you in repairing it when it becomes unusable? :mad:

I didn't crack it, I meant the sheet YOU PUT UP with no password. Its not the complete one, I think its an older version??

I am not trying to "repair it" I was asking if I could add the ambulance into that sheet.

So go look at what you have on offer before having a dig at me :p

Those of you looking to learn how this got started, you're welcome to download the "no password" version of 1.0, attached to this thread. Just unprotect it (there's no password), and you'll be able to tinker around.
Attached Files MobstersSpreadsheet_1.0-nopw.zip (12.6 KB, 35 views)

Thats on your second post in this thread, if you don't want people to use it then why have it up?

[Midnight Watch]

I believe we were both thinking that you meant the new sheet, not that one.

[PetrolHead]

Its fine, I would be pissed if someone asked for help after cracking my password lol.

[Bossdawg]

Is your health factored into fighting? Seems like last night I was losing to someone that was far less equipped than me and his attack stats were 60 points less than my defense...I lost 7 out of 10

This is his stats that he told me...dunno if its true

level 119
attack: 128
weapons: (best attack weapons..500 of each) no tanks

my stats:

level 140
Defense: 185
weapons: (best defense weapons...503 of each) I had 18 tanks

according to the spread sheet..I should have easily won

[tntitansfan]

Boss dawg
You can't say if you will win or lose because you know the person you are fighting's level and wepons but you have NO Honest way to know what their skill are.

[Bossdawg]

Boss dawg
You can't say if you will win or lose because you know the person you are fighting's level and wepons but you have NO Honest way to know what their skill are.

I know this... as I already stated..I don't know if what he told me was true.. but he didn't have a reason to lie about it..so I took it as legit information

He is a bulletproof and I'm a tycoon, we were exchanging info to learn more about the game. So him lying doesn't seem likely, but that's the only reason I can see him winning, is if his attack stats were higher than he said.

oh! lol and is this Dimples??? I'm guessing it is and you're just trying to get a rise outta me

[kimmygintx]

Thank for the update!:)

[dontai24]

Does it tell you wat properties to buy? Also if it says buy in bulk how many should I buy? Also wat do the percentages mean? If it's green should I buy more or less. Same thing for red and plain text percentages. Plz help me out.

[Bossdawg]

scroll over the red in the top right corner of each grid and it gives a brief explanation of what everything means. and bulk means 10..unless you change it

[dontai24]

yea i looked at some of them. Does bulk still mean 10 if my custom purchasable rate is 1? and should i buy more or less wen the R.O.I is in a green percentage rate?

[PetrolHead]

Green means thats the best option. E.g. if Casino is green and Shipyard is red (which is often the case on mine) then Casinos should be bought and Shipyards left well alone.

The higher the ROI the better e.g. 0.25% is not as good 0.75% so buy the ones with the higher number.

When buying in bulk it is most cost effective to buy 10 at a time but gaining cash is quicker if you buy less, don't just buy one it wastes lots of money. I tend to buy 5 minimum.

[Orly?STFU!]

I believe we were both thinking that you meant the new sheet, not that one.

You would be correct in that.

[Orly?STFU!]

Its fine, I would be pissed if someone asked for help after cracking my password lol.

You didn't say it was the old, unsupported version. :p

Anyway, I'm not that pissed, since it's so easy to crack an Excel password hash. I get a lot of PMs and messages saying, "look, I've got your password, nyah nyah" (even though it's just a password HASH, not the actual password). To answer your question, you're welcome to try inserting a row, it should work fine on that version. The new version has many cross-sheet references, so it won't work out as well.

[Orly?STFU!]

Is your health factored into fighting? Seems like last night I was losing to someone that was far less equipped than me and his attack stats were 60 points less than my defense...I lost 7 out of 10

This is his stats that he told me...dunno if its true

level 119
attack: 128
weapons: (best attack weapons..500 of each) no tanks

my stats:

level 140
Defense: 185
weapons: (best defense weapons...503 of each) I had 18 tanks

according to the spread sheet..I should have easily won

The problem is that the attack formulas are guesswork. We're fairly certain about skill points having more sway at higher levels (so your tanks aren't worth much yet). There's a random factor involved, and I've seen dice-roll theories which are interesting as well. I've wondered about whether stamina or health affect the "random" factor. For now, the fight calculator is there to give you some guidance, but it's not concrete. The best thing is to fully document the cases where it doesn't work so we can improve the formulas.

[Bossdawg]

ah...well thanks for the reply...maybe it'll get figured out soon.. but it does seem to me if I'm on my lower half of health..I win more fights..so I'm guessing health is a factor

[Orly?STFU!]

yea i looked at some of them. Does bulk still mean 10 if my custom purchasable rate is 1? and should i buy more or less wen the R.O.I is in a green percentage rate?

Green percentages show you the best Return On Investment (ROI). In other words, your property will pay for itself faster with higher ROI. Bulk always assumes that you'll get the best value the more you buy at once. BUY ONE is a solid recommendation to increase your income FASTER -- though it will cost a bit more upfront. In other words, if the recommendation say to BUY ONE, then it means that the income you gain by buying one will shorten the time it takes to buy the next of the same property. Restated, you could buy one property, wait, then buy the next in LESS time than it would take to buy two at once. It will cost you more, but the time benefit is worth more than the extra cost. Of course, if you already have enough to buy more than one, do so. The Buy One/Bulk recommendation assumes no savings, since your savings don't affect ROI.

[Midnight Watch]

Hey, just checking to see if you've gotten a chance to look at the workbooks I sent you in PM. I'm kinda interested to hear what you think on them. ;)

[Orly?STFU!]

Hey, just checking to see if you've gotten a chance to look at the workbooks I sent you in PM. I'm kinda interested to hear what you think on them. ;)

Yes, I just got a chance to check them out. It's not the selling formula I'm looking for, but it's good for speculation of purchases. I'll be looking into adding something similar to a future version. Nice job!

[Smokes em]

...If I find it, I'll make the extra .00 go away for non-Tycoons. If you saw what I have to do now, you'd agree that it's not worth it.

I wouldn't mind taking a shot at it if you don't mind...

[Midnight Watch]

Yes, I just got a chance to check them out. It's not the selling formula I'm looking for, but it's good for speculation of purchases. I'll be looking into adding something similar to a future version. Nice job!

Give me an idea of what you're looking for and I'll see if I can't figure something out with it.

[MetalManiac001]

Is there a reason why OpenOffice won't even run? I'd loveto use this, but even when I change the document properties to open with calc, it does ABSOLUTELY NOTHING.

[Orly?STFU!]

Is there a reason why OpenOffice won't even run? I'd loveto use this, but even when I change the document properties to open with calc, it does ABSOLUTELY NOTHING.

That's too little information. When you say OpenOffice doesn't run, do you mean:

You doubleclick the Calc icon and nothing happens? If so, ask the OpenOffice team, since I can't help you with their program.
You doubleclick the spreadsheet and nothing happens? Try opening Calc first, then opening the spreadsheet from the File-->Open dialog.
Did you extract the .xls file from the .zip you downloaded from here? If not, extract it, then try again.

[chatangel]

Hello Orly STFU!

I'm having a problem with 2.0.4
The total on upkeep is off by more than a million bucks.. going to download 2.0.5 to see if this fixes the problems?
Also.. I copied my bank income into .04 version, not I can not change the amount?

Thanks for this amazing tool! Wow, envious of your masterful skills.....

Thanks again for you dedication to this game and getting the details just right.

Chatangel

[Orly?STFU!]

Hello Orly STFU!

I'm having a problem with 2.0.4
The total on upkeep is off by more than a million bucks.. going to download 2.0.5 to see if this fixes the problems?
Also.. I copied my bank income into .04 version, not I can not change the amount?

Thanks for this amazing tool! Wow, envious of you masterful skills.....

Thanks again for you dedication to this game and getting the details just right.

Chatangel

Telling me it's off by a million bucks doesn't tell me anything I can use to troubleshoot it. I would need to see values entered and the total that it should be producing. You're welcome to send me your current sheet with values, and I'll take a look at it. Also be careful pasting info directly copied from any webpage, including Mobsters, because you can break the form with unintended information. That's nothing I can fix. I type my information in. You can only paste those values if you know how to enter the cell's edit mode (double-click the cell, don't just select it).

On a side note, please edit your previous post and remove the HUGE quote section. It's not needed. ;)

[bammbamm21]

awesome sheet. thank you. helped me shoot up from about 10 mil an hr to almost 100 mil in a few weeks. any chance of you adding the ambulance to the latest version 1 version? i really have no use for the complicated one but having the ambulance missing throws the numbers off a little. thanks for the time and effort though.

[bigmac]

everytime i try to open it. It opens in read only mode what do i need to do to get one that i can actually use.

[Orly?STFU!]

everytime i try to open it. It opens in read only mode what do i need to do to get one that i can actually use.

Did you extract the .xls file from the .zip file you downloaded from here? Windows will open a .zip file as if it's a folder, but it makes the contents read-only. Even if it's read-only, use File --> Save As to make a copy you can then open normally.

[balzini1]

*giant quote removed*

hi what do these columns mean they are right next to the equiptment

[silentoverlord]

When using the fight calculator your defensive power for your armor isnt the correct amount. I filled it out and with 500 advanced ballistic armors my defensive power for those alone is 7500 on the first sheet of your spreadsheet but when using the fight calculator its only 3500 and since it is read only it cant be changed so you automatically at a 4000 defensive loss on any fight. Is this a formula error or am I misunderstanding that page?

[Orly?STFU!]

hi what do these columns mean they are right next to the equiptment

That's too vague. Which columns? They should be labeled. Also, most columns should have a little red triangle or dot on them, and when you hover on them, a note will pop up explaining the field. If I hazard a guess, you mean "Attack Use" and "Defense Use". Both columns have notes explaining them in detail. In a nutshell, they tell you how many of each weapon will be used during your attacks or when you defend.

Also, please edit your post and remove the ridiculously large quote of the first post. ;)

[Orly?STFU!]

When using the fight calculator your defensive power for your armor isnt the correct amount. I filled it out and with 500 advanced ballistic armors my defensive power for those alone is 7500 on the first sheet of your spreadsheet but when using the fight calculator its only 3500 and since it is read only it cant be changed so you automatically at a 4000 defensive loss on any fight. Is this a formula error or am I misunderstanding that page?

No, I double-checked, and the Fight Calculator is correct. The left half of the Fight Calculator is for when you attack. The right half of the Fight Calculator is for when you defend. Two different values there, attack and defense. Ballistic Armor is worth only 7 attack, but 15 defense. 7 x 500 = 3500 attack. 15 x 500 = 7500 defense.

[PetrolHead]

Had a thought for low level mobsters.

When using the sheet to decide what property to buy would it be possible to lock the seaside lot and the developments for it until you reach the proper level for it? And the mall too.
I have a level 11 and its telling me to buy malls and seaside resorts which i can't buy until at least level 15
I just put 100 in each of the boxes so it shows me which other one to buy but its not an ideal solution.
Just a thought.

[redrum781]

Had a thought for low level mobsters.

When using the sheet to decide what property to buy would it be possible to lock the seaside lot and the developments for it until you reach the proper level for it? And the mall too.
I have a level 11 and its telling me to buy malls and seaside resorts which i can't buy until at least level 15
I just put 100 in each of the boxes so it shows me which other one to buy but its not an ideal solution.
Just a thought.

Its telling you to buy those items once they become available, which is why the text for those items are in red, representing that they are not available to you yet. simply put, don't worry about it if the text for the item is red.

red text plus "++"= buy later when correct level
black text plus "++"= buy now
and the "--" should be obvious

[iceman30240]

an awesome option would be to actually link the spreadsheet to your personal mobsters app. Also the ranking Kingpin's spreadsheet link accessable as a guide to the lower lvl peeps to grow their own mobs. Thoughts?

[Orly?STFU!]

an awesome option would be to actually link the spreadsheet to your personal mobsters app. Also the ranking Kingpin's spreadsheet link accessable as a guide to the lower lvl peeps to grow their own mobs. Thoughts?

Sounds awesome! Now if only the Godfather would open up his servers and game code to me... :D

[Orly?STFU!]

Had a thought for low level mobsters.

When using the sheet to decide what property to buy would it be possible to lock the seaside lot and the developments for it until you reach the proper level for it? And the mall too.
I have a level 11 and its telling me to buy malls and seaside resorts which i can't buy until at least level 15
I just put 100 in each of the boxes so it shows me which other one to buy but its not an ideal solution.
Just a thought.

Not a bad idea, though I'm not sure Excel's conditional formatting could handle that, mainly because there are so many mitigating circumstances as to what you can buy. However, I will see if it's possible. I would basically have to combine ALL territory requirements + ROI into a single formula.

The goal is to buy the property with the highest ROI that you're allowed to buy. The difficulty is that each property has an individual requirement set, including mob level and prerequisite undeveloped land. If you don't own a Vacant Lot, you can't buy a Townhome or Restaurant. However, ROI also determines whether to buy ONE or BULK (preferably 10). The recommendation would change drastically depending on current property, level, etc. It's easy to determine individual prerequisites, but combining them may be beyond a spreadsheet's capabilities.

Still, if there's a way to make it happen, I'll look into it.

[terry73178]

Hey thanks for adding the bank balance on the new spreadsheet it makes the figuring on how many to buy more accurate.

[boompagirl]

Hi Orly! Love your spreadsheet. I have the same low level issue. Because I am level 20 and it is suggesting the malls. I don't really care and can easily ignore this, but it is taking away from another potential buy, IYKWIM? Is it unrealistic to have multiple sheets based on levels and available items? Prolly a lot of upkeep??

[Midnight Watch]

Not a bad idea, though I'm not sure Excel's conditional formatting could handle that, mainly because there are so many mitigating circumstances as to what you can buy. However, I will see if it's possible. I would basically have to combine ALL territory requirements + ROI into a single formula.

You could do it if you made the sheet with Office 2007. Only problem is that 97/2003 versions would't be able to do it, and not everyone has Office 2007. If memory serves, you can have multiple conditional formatting rules on one cell. Also, you could just set it up using an "if/and/then" statement in the cell to tell it if it should calculate for that or not. Like, say Cell A1 is the level. You could do =IF(A1<= (Whatever level you want), (Location of the calculations),"Higer Level Needed")

That would only run the calculations if you were at the specified level. That's the formula for the cell though, not for the formatting. Might give that a test shot and see. ;)

[Orly?STFU!]

You could do it if you made the sheet with Office 2007. Only problem is that 97/2003 versions would't be able to do it, and not everyone has Office 2007.

You're correct, that is the limiting factor. I must use Excel 2003 to create the sheet, because I can't force people to buy Excel 2007 to use the sheet.

If OpenOffice.org Calc had better support, I could switch, but it's not there yet.

[Orly?STFU!]

Hi Orly! Love your spreadsheet. I have the same low level issue. Because I am level 20 and it is suggesting the malls. I don't really care and can easily ignore this, but it is taking away from another potential buy, IYKWIM? Is it unrealistic to have multiple sheets based on levels and available items? Prolly a lot of upkeep??

I have an idea that might get around the problem, but multiple sheets would be too much to manage.

[koolaidWTF]

Orly? This spreadsheet is AMAZING I don't know how I went so far without using it.

[Midnight Watch]

True. But OpenOffice has some issues keeping password protected pages password protected. I'd say give the formula I posted before a try for a temp patch for it, and then if that works for you, then keep it, if not, then toss it.

[Orly?STFU!]

True. But OpenOffice has some issues keeping password protected pages password protected. I'd say give the formula I posted before a try for a temp patch for it, and then if that works for you, then keep it, if not, then toss it.

I have an idea that will probably do what I need it to do in order to only recommend properties you are eligible to buy. It's a bit of a hybrid of your idea and another technique to get around the limitations of Excel 2003. As for OpenOffice's password issues, meh. It's not about hiding the formulas as much as keeping the sheet from getting fubar'd.

[Midnight Watch]

True. ( ever notice I start with that alot? ) If you're thinking of adding a cell change into the formula to get more functions into a cell than it really allows, it does work, and quite well. You just have to keep track of where you're at with it is all. Though I'd love to know if it's something different. I have a sheet for work that does soemthing like that.. .>.>

[redrum781]

Im not sure if it has been mentioned before but I think it would be interesting for their to be an area in the Territories section that shows how long it will take for purchases to "pay for themselves" such as if i buy 1 Seaside Lot at $4,000,000, income of $8,000 per hour, how long would it take before that 1 property earns back the $4,000,000. I used a calculator to come up with 20.83 days, but ya know maybe it could be a little optional section seeing as we don't really hold on to properties that long. i just thought about it because at the moment i am focused on shopping malls, but ive had 10 unused Seaside Lots for a while now.

[PetrolHead]

Im not sure if it has been mentioned before but I think it would be interesting for their to be an area in the Territories section that shows how long it will take for purchases to "pay for themselves" such as if i buy 1 Seaside Lot at $4,000,000, income of $8,000 per hour, how long would it take before that 1 property earns back the $4,000,000. I used a calculator to come up with 20.83 days, but ya know maybe it could be a little optional section seeing as we don't really hold on to properties that long. i just thought about it because at the moment i am focused on shopping malls, but ive had 10 unused Seaside Lots for a while now.

If you untick bank and cash for use wouldn't this be what is shown?
Although that would be the time it takes you with your current income to pay it off.
This I think is more useful than your suggestion as your suggestion seems to be a variation on Return On Investment which is shown on the sheet.

I may be wrong lol.

[Orly?STFU!]

Im not sure if it has been mentioned before but I think it would be interesting for their to be an area in the Territories section that shows how long it will take for purchases to "pay for themselves" such as if i buy 1 Seaside Lot at $4,000,000, income of $8,000 per hour, how long would it take before that 1 property earns back the $4,000,000. I used a calculator to come up with 20.83 days, but ya know maybe it could be a little optional section seeing as we don't really hold on to properties that long. i just thought about it because at the moment i am focused on shopping malls, but ive had 10 unused Seaside Lots for a while now.

That's an easy calculation, it's simply current cost divided by income:

(current cost)/(base income) = # of income cycles to pay for itself.

It's basically the inverse of ROI. Thus, if a Vacant Lot costs $5000 and adds $100 in income, it will take 50 income cycles to pay for itself. For anyone but Tycoons, that's 50 hours. As you buy more and more, and the current cost skyrockets, that number will get ridiculously large. For example, if you own 100 Malls, the next bulk purchase will take 1100 hours to pay for itself, or about 45.8 days. If you own 100 Shipyards as the example, it will take 3300 hours to pay for itself, or about 137.5 days.

What I might do, since it provides similar information, is make an option to view this value (adjusted for mob type) instead of the normal ROI value. The recommendations don't change, it's just that higher numbers would be better in this case.

[Midnight Watch]

EDIT: Nevermind. Found the issue. Was on my end. Had a 20 where there was supposed to be a 10. LOL

[iPUNISH]

are u going to update it for the ambulances??

[redrum781]

are u going to update it for the ambulances??

the ambulances have been on there for a little while now, make sure that you are using version 2.0.5 you can download it on Page 1.

[iPUNISH]

are u going to update the spreadsheet for the ambulances??

[redrum781]

ambulances are already in the spreadsheet, go download version 2.0.5 from page 1 as i stated above.

[Midnight Watch]

If only there was a way to program it to automatically update for things like that. Too bad that's WAY out of Excel's league. LOL

[iPUNISH]

I saw the updated version and it rocks!!! Thanks Much..Chow:D

[redrum781]

If only there was a way to program it to automatically update for things like that. Too bad that's WAY out of Excel's league. LOL

yeah would be, i just check back everyday

[FlatfootedNinja]

Orly... let me know if you didn't get my private message... things are moving! :P

[Orly?STFU!]

Orly... let me know if you didn't get my private message... things are moving! :P

I got it, check your PMs

[buttanuts]

Question - This is one of the things I've been trying to figure out.

Is there any way you can enter an amount of money. Say 4 billion and it just tell me the next 10 things of 10 I should buy.

Let's say my next best investment is 5 billion to purchase, but I could but 20/30 each of all the other stuff.

What would be the best purchases for the amount of money you have?

I'm not asking the question, I'm asking if it's feasible or desirable to add that logic to your calculator.

[Cj_Staal]

I found a bug... Well at least for mine

I have 11106 experience

And in the "Minimum XP: Level 50" never changed to level 100 it's still at 11000

And the "Exp to go: Level 50" never changed to level 100 either so it now says "ERROR"

[Cj_Staal]

Whoops sorry I forgot Ihad to type I'm level 50. I thought it would change once I put XP in

[Truckerllew]

I have a question about the fight calculator portion of the spreadsheet.

How do I determine the attack strength and defense power for the enemy mob?

I just downloaded the sheet. Its very neat and answers a lot of my questions about my mobster. I am not sure how to figure the enemy strength though.

If this has been answered already, I'm sorry for bringing it back up. I looked but I have limited time today to search 6000 posts...lol Thanks for makin the sheet

Thanks truckerllew

[redrum781]

I have a question about the fight calculator portion of the spreadsheet.

How do I determine the attack strength and defense power for the enemy mob?

I just downloaded the sheet. Its very neat and answers a lot of my questions about my mobster. I am not sure how to figure the enemy strength though.

If this has been answered already, I'm sorry for bringing it back up. I looked but I have limited time today to search 6000 posts...lol Thanks for makin the sheet

Thanks truckerllew

The only way you can really know your opponents strength is by asking them, otherwise you can just use it to come up with scenarios to see what an opponent would have to have to beat you. The most you can see in a fight is what your opponent is defending with. Well and i also i think by inputting the damage you took and delivered you can see how much max health they have.

[05madmax]

im trying to figure something out since i am still new to this but how would i know the enemy mobs attack strength and defense power and number of hired guns?

[05madmax]

nvm didnt go to the last post haha

[Pryncezzz]

Please help. I have tried to open all of the files and I continue to get a message saying they are corrupt. When I try to repair, that does not work either.

Thanks

[The Beast]

Please help. I have tried to open all of the files and I continue to get a message saying they are corrupt. When I try to repair, that does not work either.

Thanks

have u got excel or a similar program?

[Orly?STFU!]

Please help. I have tried to open all of the files and I continue to get a message saying they are corrupt. When I try to repair, that does not work either.

Thanks

Did you follow the instructions and extract the .xls file from the .zip file you downloaded from here? You can't open .zip files with OpenOffice or Excel. If you double-click the .zip file, Windows should open it, and you'll see a window that displays the .xls file. Drag this file to your desktop to extract it. You can also right-click the .zip file and choose Extract All.

If you use the Computer Associates Security Center for your anti-virus suite, it will rename the .zip file to use .efw as its extension, effectively confusing Windows. You need to rename it by right-clicking the .efw file, and going to Properties. You should be able to go to the General tab and rename it to use .zip instead, then follow the instructions above.

[rlnorto]

I use your spreadsheet every day. It is a great tool for all of us. Do you have a spreadsheet for vampires or know of anyone that does?

[rlnorto]

do you have anything for vampires?

[Orly?STFU!]

do you have anything for vampires?

No, I barely have time to play Mobsters, let alone all the myriad other games out there. :p

[M0bbette]

Thanks for the spreadsheet Orly. I have been resisting downloading it for the longest time because I have so many characters and I was dreading having to input all their individual figures. However, I did it, and now it's working out very nicely.

So thanks again. :D

[Banginbear]

Orly, I downloaded the file but for some reason I can't extract it. When I click on it, nothing happens. I have Vista, please help.

[Orly?STFU!]

Orly, I downloaded the file but for some reason I can't extract it. When I click on it, nothing happens. I have Vista, please help.

Right-click it. If you don't see Extract All as an option, click on Properties and verify the filename ends in ".zip". If it doesn't, try renaming it, then right-click it again.

[HannibalLector]

to LAAAAAAAZY WANT TO BUT AM SOOOO LAZY i wish sum1 could just tell me what to do

[PetrolHead]

to LAAAAAAAZY WANT TO BUT AM SOOOO LAZY i wish sum1 could just tell me what to do

Go away, now

[Bobby Bo]

Call me dumb but I'm having trouble evaluating the results i'm getting from the spreadsheet. Such as what properties I should be purchasing and how many.

[Orly?STFU!]

Call me dumb but I'm having trouble evaluating the results i'm getting from the spreadsheet. Such as what properties I should be purchasing and how many.

The best properties are marked by a green + symbol to their left. The quantities are either BUY ONE or BUY BULK (BUY 10, if possible).

If you hover above nearly any of the field names, specifically those with a little red triangle or dot next to it, you'll see a pop-up with information.

Read them ALL.

[Miken82ndabn]

Maybe you could add a Legend? I see the ++ and the -- and yet don't know what it means, just speculating the ++ means to purchase while the -- means to hold off?

[Miken82ndabn]

IMHO and with due respect, but in the Full Income column should reflect upkeep as well as income, i.e. i am making $18,600 income every 60 mins, and an upkeep of 300, the Full Income now shows $18,600, should be 18,300. I understand that maybe 18,600 is full income, but I want to know what my full Income is "After" my upkeep!

[harryhagan6]

could you tell me how to use the fight calculator? how do i no wat there attack and defence is?

its good though!

oh and does it update its self or do i have to do it ???

[PetrolHead]

IMHO and with due respect, but in the Full Income column should reflect upkeep as well as income, i.e. i am making $18,600 income every 60 mins, and an upkeep of 300, the Full Income now shows $18,600, should be 18,300. I understand that maybe 18,600 is full income, but I want to know what my full Income is "After" my upkeep!

Go up and right on the sheet. Theres an income ledger. shows hourly, daily, weekly, monthly income/upkeep/net income

[Butcher Knife Rick]

Allow the cells to be linked to other cells so we dont have to re-enter all the data on all the sheets.

Thank you

[Orly?STFU!]

Allow the cells to be linked to other cells so we dont have to re-enter all the data on all the sheets.

Thank you

It is. You've NEVER had to re-enter your data more than once. Are you using my sheet? :confused:

[Orly?STFU!]

IMHO and with due respect, but in the Full Income column should reflect upkeep as well as income, i.e. i am making $18,600 income every 60 mins, and an upkeep of 300, the Full Income now shows $18,600, should be 18,300. I understand that maybe 18,600 is full income, but I want to know what my full Income is "After" my upkeep!

The Full Income column = the amount of money your properties earn, it has NOTHING to do with your upkeep.

Look at the HIGHLY detailed INCOME LEDGER in the upper right.

[Orly?STFU!]

Maybe you could add a Legend? I see the ++ and the -- and yet don't know what it means, just speculating the ++ means to purchase while the -- means to hold off?

Do you see the multitude of little red triangles (Excel) or dots (OpenOffice) throughout the sheet? See the one just above the "++" and "--" column? Hover on it, and magically, you'll get a full explanation.

[Orly?STFU!]

could you tell me how to use the fight calculator? how do i no wat there attack and defence is?

its good though!

oh and does it update its self or do i have to do it ???

The fight calculator lets you estimate what your enemy's attack and defense values MIGHT be. If you're lucky enough to get them to tell you what they fought with, you can use it to compare your values. Your values are entered automatically using the first sheet's data, you only need to enter your enemy's known information -- I have no idea what Butcher Knife Rick is talking about.

Take note that there are two columns, one for when you attack, and one for when you defend. Don't confuse the two, or your results will be off. That said, nobody knows the exact fight formula but the GodFather, so take the results with a grain of salt.

[harryhagan6]

how do you extract the file??
mine is not updating.

[Orly?STFU!]

how do you extract the file??
mine is not updating.

Please read the whole thread, or at least the first post, I've answered these questions an incredible number of times. Besides, you didn't tell me enough information to even begin helping you. Updating has nothing to do with extracting, so I don't know what you're trying to do. :confused:

[Zarkana]

So I've read ever post to make sure my problem hasn't been address. On the Properties column, where a ++/-- should show, there is nothing. There are green triangles, but that is it. All data has been entered and updated *hourly*.

Just to give you some specs, here's what I'm working with:

Orly's Myspace Mobsters Manager 2.0.5
WordPerfect Office - Quattro Pro


Any help would be appreciated.

[Orly?STFU!]

So I've read ever post to make sure my problem hasn't been address. On the Properties column, where a ++/-- should show, there is nothing. There are green triangles, but that is it. All data has been entered and updated *hourly*.

Just to give you some specs, here's what I'm working with:

Orly's Myspace Mobsters Manager 2.0.5
WordPerfect Office - Quattro Pro


Any help would be appreciated.

The first post is very clear that I do not support anything but Excel 2003, Excel 2007 and OpenOffice Calc (FREE). I don't have any other spreadsheet programs, and I'm using some complicated methods to make it all work, and other spreadsheet programs won't be fully functional, if at all. Since OpenOffice Calc is free, there's no excuse not to use it if you don't have Excel.

[terry73178]

orly thanks for taking the time to do this for everyone it is the best out there.

[Please be Mobsta]

i finally found the time to download your spreadsheet. thanks for putting the time into it. but, i have one small problem. how do you open it with openoffice?

[Orly?STFU!]

i finally found the time to download your spreadsheet. thanks for putting the time into it. but, i have one small problem. how do you open it with openoffice?

After you download the .zip file, you have to extract the .xls inside it. You can then use OpenOffice.org Calc to open it.

[robbinrobin]

Love the spreadsheet. The ROI section for territories really hlped me in my buying decisions. I like to bounty hunt, so I made myself a simple spreadsheet to keep track of my bounties. I like to know how many and the $$ amount I collect in a day. I wish I had been tracking it all along! Thanks again for sharing your spreadsheet.

[Orly?STFU!]

Just a notice that I am no longer accepting anonymous private messages. I am getting too many people who aren't reading these posts looking for answers, when they've been answered hundreds of time already. Sorry for the inconveniece, but all questions regarding the sheet should stay in this thread.

[Midnight Watch]

So, just curious as to what you're working on with this now? Are there any upcoming changes we can be looking for?

[marion4679]

Just updated my spreadsheet and I LOVE it. Thank you so much for doing this:o

[Alastor]

Thank you, Orly!

[DarkSorrow]

Poke, can you update it for the M4. Thanks :)

[212th Battalion]

I'm sure he will :)

[Christopher]

Poke, can you update it for the M4. Thanks :)

Orly, I'm guessing you just love when the Godfather adds items to the game. :D

[ProjectDan35]

Haha. Especially when they run out, and the weapon dissappears.

[Midnight Watch]

Two updates should be made, then. One for the M4 and one for the brass knuckles that some people have. ;) But that's just my two cents worth..

[Orly?STFU!]

Damn!! I was gone for a couple of days. I'm on it!

[da Queen B]

Damn!! I was gone for a couple of days. I'm on it!

I dont remember approving a time off request for you Orly.

[Orly?STFU!]

Version 2.0.6 is available! Now with M4 and Brass Knuckle data.

With this version, be careful if you copy/paste your old data because the Brass Knuckle field is just below the Hired Guns field.

[M0bbette]

noooooooooooooooo.....I just got done filling everything in for my 10 characters....don't make me do it all again....sob, whine, sniffle :(

[Orly?STFU!]

noooooooooooooooo.....I just got done filling everything in for my 10 characters....don't make me do it all again....sob, whine, sniffle :(

Lol, don't blame me, blame the Godfather for adding a useless weapon. :p

[Christopher]

Lol, don't blame me, blame the Godfather for adding a useless weapon. :p

Have you seen that broadcasts are now free.

[Orly?STFU!]

Have you seen that broadcasts are now free.

Is that permanent? I just noticed that. Dear God!! :eek::eek::eek:

[Orly?STFU!]

*grumble*

Okay, I fixed the Broadcast Cost (FREE). I didn't bother updating the version number, and if you already grabbed 2.0.6, you can grab the new version, or leave it. I'd leave it. :p

[Christopher]

Is that permanent? I just noticed that. Dear God!! :eek::eek::eek:
I don't know.

[Midnight Watch]

Looks like another one for me to add my three shopping sheets to. :(

[KittySoprano13]

Version 2.0.6 is available! Now with M4 and Brass Knuckle data.

With this version, be careful if you copy/paste your old data because the Brass Knuckle field is just below the Hired Guns field.


Orly, when I click on the red link in your sig. to the updated version, I get this message:
Error: Unable to find site's URL to redirect to.

What am I doing wrong or what is causing that?

[212th Battalion]

Orly, when I click on the red link in your sig. to the updated version, I get this message:
Error: Unable to find site's URL to redirect to.

What am I doing wrong or what is causing that?

I can't answer that for him :p But might I suggest going to the first page and looking for the zip file that contains the updated spreadsheet instead? That's what I did :)

[PetrolHead]

I can't answer that for him :p But might I suggest going to the first page and looking for the zip file that contains the updated spreadsheet instead? That's what I did :)

Why should you answer a question directed at the creator of the sheet?

[Vinny the Hitman]

Why should you answer a question directed at the creator of the sheet?

Uh, because the answer he gave is correct & useful information for someone that may not know otherwise?

[PetrolHead]

Someone may not know that to download said file you need to click the download link?? hmmm odd.

[Midnight Watch]

Someone may not know that to download said file you need to click the download link?? hmmm odd.

More like they don't know you have to go to the first page of this thread to find that download link. Let's not be a jerk, ok? Chances are Orly? hasn't updated the link in his sig yet, so you have to use the link in the thread instead. Some people wont' notice that and wonder why it isn't working. So, you shouldn't be a jerk to someone that is only helping out another member.

[Smokes em]

Here's a problem I noticed on both 2.0.6 and 2.0.5 (dunno about previous versions). In the bar that shows Attack % Skill and % Equipment the difference in color is disproportional to the actual percentages. See attached image.

[Orly?STFU!]

Orly, when I click on the red link in your sig. to the updated version, I get this message:
Error: Unable to find site's URL to redirect to.

What am I doing wrong or what is causing that?

Ooops, fixed.

[Orly?STFU!]

Here's a problem I noticed on both 2.0.6 and 2.0.5 (dunno about previous versions). In the bar that shows Attack % Skill and % Equipment the difference in color is disproportional to the actual percentages. See attached image.

That's an Excel 2007 bug, I can't fix that unfortunately. The only fix would be to switch to a different chart type. :(

[saint_lolito]

what the hell am i doing wrong, i only get this file in read only..and when i try to open it in openoffice it says the file is corrupt....i've tried delete the file to download again but it shows that i still have it..and yes i'm not to savy with files and downloads..i would love to use this spread sheet i'm up to 112 mill every 55 mins and get a little cofused on what to buy or do next,,i just reached level fifthy....

[Orly?STFU!]

what the hell am i doing wrong, i only get this file in read only..and when i try to open it in openoffice it says the file is corrupt....i've tried delete the file to download again but it shows that i still have it..and yes i'm not to savy with files and downloads..i would love to use this spread sheet i'm up to 112 mill every 55 mins and get a little cofused on what to buy or do next,,i just reached level fifthy....

Sounds like you didn't extract the .xls file from the .zip file you downloaded.

[Grandma Mulk]

Love it! Love it! Love it! Thanks for all the hard work!

[Jeowan]

pls add mac truck :D

[Midnight Watch]

WTF?! They keep adding things... >.< When does this stuff turn into things we can buy for cash?!

[DarkSorrow]

Having fun yet?

Mack Titan added today!

[Christopher]

Poor Orly, just added the M4 and now needs to add more.

[Orly?STFU!]

I'll have the new sheet up shortly.

*grumble*

:mad:

[Orly?STFU!]

Added the Mack Titan and fixed a broken formula on the Fight Calculator (it wasn't taking enemy M4's into account).