World War Spreadsheet v5.5 ** 7/20/2010 Update **

SKT168 · #1 10-06-2009, 08:27 PM

World War Cheat Sheet v5.5
by SKT168 w/ contributions from Supervolcano

*** NEW FEATURE -- 2 Different File Sizes **

Large File handles 1000 building calculations at a time.
Small File handles 150 building calculations at a time (SKT168's standard).

If the file is responding too slowly for you (slow computer) or if you need a smaller file for some other reason, then I suggest you stick with the Small Version!

Note: The spreadsheet should now be 100% complete. Please report any bugs/errors in this thread.

v5.5 --- 7/20/2010:

Fixed the mistake I made in "v5.4 Small" with the Automatic Defense Building Calculator.
Corrected level to unlock "Type 23 Frigate" unit.

v5.4 --- 7/18/2010:

Fixed the mistake I made in v5.2 & v5.3 with opponent's PMC caluclations.

v5.3 --- 7/18/2010:

Fixed the mistake I made in v5.2 with calculating upkeep.

v5.2 --- 7/18/2010:

Added a new mission tab with 8 new missions.
Addded 2 new regular mission loot units.
Addded 3 new special "PMC" mission loot units (each usable alliance member can bring 1 of these to all fights in addition to the rest of your units).
Addded 1 new mission mastery bonus item (and adjusts the reported upkeep everywhere if you mark the dashboard as having the item).
Addded several new cells to the right side of the dashboard to handle the new "PMC" units.
Fixed all mission requirements and payouts after Storm8's 7/16/2010 update.
File was modified by Supervolcano instead of SKT168 due to his recent absence from the forum.

v5.1 --- 6/29/2010

Added the 15 new Regular Units, fixed all unit price & upkeep values, fixed all building prices, and fixed mission payouts from Storm8's 6/29/2010 update.
Added the 18 new Unmarked Shipments & Heroic Reinforcements that we've found since one of Storm8's May 2010 updates.
File was modified by Supervolcano instead of SKT168 due to his recent absence from the forum.

v5.0 --- 3/18/2010

Tweaked everything from last major update.
File was modified by Supervolcano instead of SKT168 due to his recent absence from the forum.

v4.1 --- 2/24/2010

Added SKT168's "Camping Calculator"!!
Added "Upkeep Per Point" to the Battle section of Dashboard.
Added highlighting to the top money/energy mission for each mission tab.
Renamed a few headers on Missions tab to explain what the column represents a little better.
Added more lines for Profile Data so you can keep track of your records and enemy's records (to make this useful, I recommend inputting all of his and your data, then saving it under a different file name, like adding the opponent's name to the end of the standard filename).
Added the other 7 mission mastery lines to Dashboard, even though those other rewards don't factor into any spreadsheet calculations.
Reorganized the layout of Dashboard to accomidate all of this.
Cleaned up some fonts and styling in some sheets to make it look better.
File was modified by Supervolcano instead of SKT168 due to his recent absence from the forum.

v4.0 --- 2/22/2010

Basically revamped the whole spreadsheet, adding in some other features found in some of SKT168's other spreadsheets and double checked all old values!
Introduced seperate "Small" & "Large" versions of spreadsheet.
Added 32 new missions after Storm8's 2/17/2010 update.
Fixed all other mission names, requirements and payouts again.
Added SKT168's "Missions Optimizer" to dashboard (and several new columns to Missions tab).
Added SKT168's "Mission Requirements Checking Features" which were in some of the other spreadsheets.
Fixed several misspellings in unit names and some incorrect/changed values, along with reordering all of them in the forumlas tab so the best units get used for calculations.
Several other minor changes, including rearranging some things, changes to color coatings, and changes to table styles.
File was modified by Supervolcano instead of SKT168 due to his recent absence from the forum.

** v3.7 --- 1/23/2010 Update: Corrected values for Naval Tanker, Corvette, SU-47 Berkut Fighter, Amphibious Assault Vehicle (loot version), and several Missions. This file was modified by Supervolcano, not SKT168. **
** v3.6 --- 12/4/2009 Update: Filled in Missing Information, Updated with new Mission Requirements and Unit Upkeep Costs **
** v3.5 --- 10/6/2009 Update: Completely updated with all the new buildings, units, mastery and missions from the 9/29 update **

Overview
The World War Cheat Sheet has evolved based on suggestions from iMMOforums members. It is designed to meet the needs of casual and power users alike while (hopefully) keeping things simple and easy to use.

Instructions are included in the spreadsheet, but if you have any additional questions, ideas or thoughts please post them in the forums.

Features
Dashboard
This is the Starting Point for everything and the only place where any user input is required. For most users, there is no need to ever leave the Dashboard as it provides a snapshot view of all the data and analysis that occurs in the spreadsheet.

The fields that are REQUIRED are highlighted in Yellow. It is very important to fill in these fields with your current character information because all the calculations/analysis that occurs is based upon this data.

The Orange highlighted fields are optional and can be used to enter in information for an opponent or for testing purposes.

Mission Mastery
The bonuses from the mission mastery rewards - "Mercenary Arms Merchant" and "USO Package" - are automatically taken into account in unit costs/energy timer calculations.

Building Optimizer (In the Buildings Worksheet)
Probably the most complex feature, the spreadsheet calculates not just the next recommended income and defense building purchases but also future building purchases.

At a glance, you can see the next 150 recommended building purchases but - even better than that - you can just enter in the current amount of cash that you have to spend and the spreadsheet will automatically spit out the number of each type of building you should buy (up to 150). If you need to buy more than that, just repeat the process.

The results can be automatically copied to the dashboard via MACRO saving you from having to manually increment each property as you buy.

This should be VERY helpful to campers and less frequent players at it saves multiple steps and allows you to make bulk property purchases.

NOTE: There is ONE Macro on this worksheet. It is NOT Required and everything will still work without enabling macros.

It was added to make things simpler when using the calculator. If you prefer not to have macros enabled, everything will still work but you will have to take the following steps instead:

Method 1
Take the END # results and MANUALLY update them in the Dashboard (type them in yourself).

Method 2
Copy the END # results and (using Excel) use the "Paste Special" (right click) and select "Values" to paste the updated numbers into the Dashboard.

This is necessary because Excel defaults to copying formulas rather than values. If anyone knows a workaround - please let me know.

Unit Optimizer (In the Optimizer Worksheet)
Provides detailed information on the best available attack and defense units at your level along with their potential effect on your income, upkeep, fighting, etc. It provides this information for both your current members and max potential members.

Please note that units are limited to ones that can be actually purchased due to the difficulty obtaining meaningful numbers of loot/promotional units.

Units (Units Worksheet)
Along with much more detailed unit analysis (unused units, wasted upkeep, etc.) in the Units Worksheet, the spreadsheet takes into account situations where you may want to "double up" on units. Specifically, it accounts for units that are only used for attack or units that are only used for defense. Also, in the case of equivalent attack/point values, preference is always given to the lower cost unit.

Character Class
You can now enter in your character class information and all relevant calculations are automatically adjusted.

Loot Items
ALL loot items including promotional Storm 8 items are now included.
-------------------

Please report and bugs, suggestions, fixes etc. in this thread.

Sly Snidely · #2 10-06-2009, 08:53 PM

Allow me to be the first to say...

SWEET!

baldy · #3 10-06-2009, 09:16 PM

nice...

Supervolcano · #4 10-06-2009, 09:44 PM

Where'd you get the info for unlocking missions from level 1-9?

Reliable source?
Or just guessing?

SKT168 · #5 10-06-2009, 10:04 PM

I reset an account and started over

Supervolcano · #6 10-06-2009, 10:41 PM

Quote:

Originally Posted by SKT168

I reset an account and started over

I had a feeling you did that.
Must be nice having 2 devices.

So I figured I'd proofread this monstrosity for SKT168 and expected to find at least a couple typos.

Instead, I only found 1 mission incorrectly named.
And it was incorrect in MY list, SKT168's spreadsheet had it right.

OK, I did find one typo:
In Missions!N18 the word Cruiser has a lower case c.

All missions data has been double checked, nice job!!
Now to check the units.

windwardman · #7 10-06-2009, 11:24 PM

Nice job with the spreadsheet. Thanks. It's good to have everything up to date again.

I've found only two mistakes: Defense of SU-47 Berkut Fighter should be 20, not 50; and the Amphibious Assault Vehicle received in the Unknown Shipment is a Ground weapon, not Water.

Buttoneer · #8 10-07-2009, 03:39 AM

Great sheet, once again SKT. Thank you.

One typo has been bothering me though - turet should be spelled 'turret'. It's your 'Audio' of the WW sheet :lol:

nayak.aj · #9 10-07-2009, 03:51 AM

This is Beautiful ! ur the man !!!! ST !! thanks for this !

Thisonehere · #10 10-07-2009, 09:21 AM

Many thanks! This is an amazing feat.

It reminds me a little bit of the maps I used to make for Zork, LOL. Back in the DAY...

SKT168 · #11 10-07-2009, 01:00 PM

@SuperVolcano: Just in the family, we have 3 iPhones so whenever I can borrow/steal the wife's, I play her accounts (all pure energy) and reset if necessary to get the level info. I think all her accounts have zero wins

@Buttoneer: Too bad there is not an Audio in this game too

@windwardman: Will get that fixed as soon as I finish the iMobsters update.

Keep the bug fixes coming (hopefully there are not too many...)

liangda · #12 10-09-2009, 06:34 PM

wooooooooww ..... finallly!

keiko · #13 10-11-2009, 12:52 AM

This is the best!
Thank you so much for your time and effort
You are greatly appreciated, SKT168!

jpratt · #14 10-12-2009, 10:14 AM

I love the spreadsheet, but, and there is always a but isn't there?

My missions show up differently than what you have listed.

Mine go in order.
Europe, Atlantic, Balkans, Africa, Americas, Pacific.

Air Raid shows up under Africa where yours shows up under Pacific.

sgutierrez · #15 10-12-2009, 10:57 AM

thank you and geat job on this new spreat sheet

i just have a question how do i save my info on the
sheet i have input all my info in it but when a close it
and even that i save it, when i come back to it
it will not be there i have to keep on inputing the info
every time i open it
can you please tell me how

thank you

Supervolcano · #16 10-12-2009, 12:14 PM

Quote:

Originally Posted by jpratt

I love the spreadsheet, but, and there is always a but isn't there?

My missions show up differently than what you have listed.

Mine go in order.
Europe, Atlantic, Balkans, Africa, Americas, Pacific.

Air Raid shows up under Africa where yours shows up under Pacific.

Change your "country" in the top left corner of the dashboard (near level and alliance size) and all the mission tabs will "magically change" to what they should be for you.

P.S. - SKT168, I meant to compliment you for putting this in there, and forgot to mention it. NICE JOB!!!

timofej · #17 10-14-2009, 02:43 PM

Since there are two units that have the same name (Amphibious Assault Vehicle) the VLOOKUP function doesn't find the correct one which leads to some mistakes in the calculations. One of units should be renamed Amphibious Assault Vehicle Promo or something to avoid the confusion.

Another strange thing is that the spread sheet I've downloaded seems miss the macro. Yes, I have macros enabled. However, I cannot see any macros in this workbook at all. Am I the only one?

timofej · #18 10-17-2009, 04:00 AM

One more bug is discovered. Unit "SU-47 Berkut Fighter" has incorrectly 50 attack and 50 defense in the spread sheet. The correct values are 50 attack and 20 defense.

SKT168 · #19 10-20-2009, 12:57 AM

Quote:

Originally Posted by timofej

Since there are two units that have the same name (Amphibious Assault Vehicle) the VLOOKUP function doesn't find the correct one which leads to some mistakes in the calculations. One of units should be renamed Amphibious Assault Vehicle Promo or something to avoid the confusion.

Another strange thing is that the spread sheet I've downloaded seems miss the macro. Yes, I have macros enabled. However, I cannot see any macros in this workbook at all. Am I the only one?

Thanks for catching these bugs - I will update the spreadsheet as soon as I get a chance. Pretty stupid about Storm 8 using the same name for two different items

As far as Macros - the only ones are for automatically copying the Buildings Optimizer results to the dashboard. Are you not seeing the button labeled "Copy Income Optimizer Results to Dashboard" on the Buildings worksheet?

timofej · #20 10-20-2009, 01:12 AM

Quote:

Originally Posted by SKT168

As far as Macros - the only ones are for automatically copying the Buildings Optimizer results to the dashboard. Are you not seeing the button labeled "Copy Income Optimizer Results to Dashboard" on the Buildings worksheet?

Thank you for your reply SKT168. Really impressive work with the spread sheet! I've figured out why I don't see the macros. I use MS Office 2008 for Mac and it appears that it doesn't support VB-scripts and thus, macros. :-/ Too bad, because I miss the function.

I've already fixed the bugs in my spread sheet. It's nice that you have not locked it this time. I hope you will not do it in future because it's good to be able to adapt the spread sheet to own needs.