Modern War Master Resource Sheet

[Maverick50727]

Links:
"Modern War Master Resource Sheet – Part 1 (https://docs.google.com/spreadsheet/ccc?key=0AiSsos_vax1hdEhYUGRSdGtsY01odV9hS2QybXFiQ 3c)" – by Maverick50727
Missions, Bosses, Units, Strongest Cash and Valor Attack Units, Strongest Cash and Valor Defense Units

"Modern War Master Resource Sheet – Part 2 (https://docs.google.com/spreadsheet/ccc?key=0AiSsos_vax1hdGZ2VGl2OVFoRFBpelV2V3F4dmdGT Wc)" – by Maverick50727
PVP Ranks, Level, Money Buildings, Units Buildings, Boost Buildings, Defense Buildings, Expansions, Vault

Updates/Corrections:
PLEASE HELP VERIFY. To minimize people corrupting the sheet like people did in past public sheets, this public sheet will be read only for the public and I the only editor for now. All building costs, upgrade times and defense values (defense buildings only) are in GREEN, any blanks or those in BLACK may be correct just not verified a second time. If people could please check the upgrade costs, times and def values on their next upgrades if possible and post to this thread or send me a Private Message, I'll add changes submitted to the next sheet revision.

All changes will be provided to Khimsoo for use in his toolkit. So the better the information you provide here, the better we can make his Toolkit. If you haven’t checked out his Toolkit, I strongly encourage you to do so, as it is a great tool for economy planning."Toolkit for Modern War (http://www.funzio.com/forum/showthread.php?36750-Toolkit-for-Modern-War)" – by Khimsoo

When providing information please specify if this the discounted or original cost. If the discounted price please provide your current Cement Factory level and any units with bonus reductions. (see below)

If you have the Cement Factory, here is the formula to figure out the full price.

-1% Cost/0.99
-2% Cost/0.98
-3% Cost/0.97
-4% Cost/0.96
-5% Cost/0.95
-6% Cost/0.94
-7% Cost/0.93
-8% Cost/0.92
-9% Cost/0.91
-10% Cost/0.90

Units with Building Upgrade Cost Reductions (Cost / .70 or See Below)
Hurricane 30% Building Upgrade Cost Reduction
Monsoon Ship 30% Building Upgrade Cost Reduction
Draft Destroyer 30% Building Upgrade Cost Reduction
Draughtsman 30% Building Upgrade Cost Reduction

Units with Building Upgrade Time Reductions (Time / .80 or See Below)
Grey Bird 20% Building Upgrade Time Reduction
Silent Drifter 20% Building Upgrade Time Reduction
Shadow Stalker 20% Building Upgrade Time Reduction
Whirling Thunder 20% Building Upgrade Time Reduction
Storm Viper 20% Building Upgrade Time Reduction
Offensive Viper 20% Building Upgrade Time Reduction
Wicked Viper 20% Building Upgrade Time Reduction
Dragon Viper 20% Building Upgrade Time Reduction

[Maverick50727]

About/History & Credits:
These sheets supersedes my Boss Loot Map Sheet (http://www.funzio.com/forum/showthread.php?37511-Boss-Loot-Map-Sheet) published previously (contained now in Part 1).

The Modern War Master Resource Sheets were created by me (Maverick50727) using information from my own existing sheets and data file sources. Initial building upgrade times and costs were derived by comparing to sheets from TrampStamp, War Priest, EnjoyLife, and itzkakarot. Special thanks to the following who had early access and assisted in early cost/times verification values and corrections: Ryans67, BigD@wg, Selfproclaimed, mxz, Idiokus, Angel 2, Copenhagen, Romaro, Jp lfs, Thunder Child, What?, Corsair, EnjoyLife, Khimsoo, Tate, Agent Orange, Q Raider, Miner, Spectra, Wdigeorge, and many more.

General Usage:
I apologize up front as the original doc had much better formatting and features like hyperlinks between the BOSS in the Missions sheet to the corresponding 3 entries in the Boss sheet for that mission. Due to security, Google limitations, max cell sizes, 400,00 cell limits, and other issues many features had to be removed, but still overall this is a good one stop shop for accurate information. For the same reasons the Sheet had to be split into multiple parts. I'll try to update once a week or as new content is released.

Viewed Online:
Pros: This is best viewed via PC instead of IOS. Via PC will allow you to do advanced functions like filters and scrolling with frozen panes so that the top and left columns stay in place. I tested with Windows 7 IE 9. Allows you to see all pictures, filter buildings by name and pictures of buildings are hidden when rows are filtered.

Cons: Limited when viewing via IOS devices without options to filter or header rows being locked in place.

Download to Excel:
Pros: Allows you to manipulate the data much more and edit yourself.

Cons: When Google converts the docs in the upload and download process, it removes many of the defined filters, table styles (alternating white and gray rows), page formatting like paper size, orientation, controlled page breaks, headers and footers, rows repeated at top, etc. So much may have to be manually recreated unfortunately. Sadly, the way pictures are handled in Excel vs. Google is different and can be a cause of headaches. Excel treats pictures as a picture over a cell, not content within the cell. Google docs treats the URL picture as internal to the cell. This means like I said above the pictures don't show if you filter a building out by name. Excel filters the data but the picture is not in the cell thus still shows in place regardless if all it rows are filter out. Meaning filtering or sorting will leave pictures beside the wrong rows. Also Google neatly centers a picture within a merge cell range. When downloading to Excel all pictures are resized very small and not centered. I would recommend deleting column A (pictures) from all the building sheets if downloaded locally. If you leave the pictures you must resize and center, and if you want to enable filtering on the sheet you can't do Ctrl + A to highlight all and select filter, because you can't filter merged cells. You will have to select the entire range of cells excluding column A (pictures) and filter those only. Yes difficult to make it pretty.

Download/Print to PDF:
Pros: Keeps pictures most of the formatting (Repeat row headers on each page, Include sheet names, Include Page Numbers, Landscape, etc) based on selection.

Cons: You can't control page breaks so not all sheets break at the same point and some picture sizes may be affected

[Maverick50727]

Individual Sheet Usage Details/Description:

Part 1
Missions - This is a one stop shop for anything that can be "farmed". Complete list of all missions on maps including loot, drop rate, xp, energy, required units, etc. Note: Gree defines "Boss" missions as any mission that requires more than 1 hit. That is why I have a Boss ID (Col F) to identify each mission for lookup. If it is a true "Top Level Boss" they are treated differently that on the missions in the fact they have 3 drop rate chances (.6,.3,.1), thus I broke them out in a different "Bosses" sheet. If you see that it is a "Top Boss" in Col T-V, you will have to manually refer to the Bosses sheet as the hyperlinks to take you there is something that the Google conversion removes. Top bosses really can't be farmed in large qty due to required energy thus having them in here is more for reference.

Bosses - Top level bosses only and their 3 drops. This sheet can be used for a secondary purpose of planning or staging boss missions. This can be used to plan income that can be earned quickly off staged bosses in order to get larger purchases and upgrades like the Nano’s (how I got mine). For more info see http://www.funzio.com/forum/showthread.php?37511-Boss-Loot-Map-Sheet.

Units - List of all units current at the time of last data set import.

Strongest Cash and Valor Attack Units/Strongest Cash and Valor Defense Units - As stated list of ONLY Cash and Valor Units sorted by Attack or Defense. Intended for "Free Players".


Part 2
PVP Ranks - PVP Ranks including pictures, Battle Points Required, and Rewards
Levels - Player Levels with XP ranges, XP, Valor and Money Payouts
Money Buildings, Units Buildings, Boost Buildings, Defense Buildings, Expansions, Vault - All used for Base and economy planning including costs, upgrades, levels unlocked, units unlocked, etc. Self explanatory in most cases.

Note: The Defense Buildings sheet does have player that can be used if downloaded locally to help determine the defense value added to you Alliance Defense. Alliance Def Stats Raw or Boosted includes the sum of all your base defenses in addition to just your units. If you want to see how much you base defenses add up this is a handy tool to get a quick total. Consider base defenses indestructible units that aren't include in your 2,000 max theoretical unit limit. They play a part in defending attack and raids (if the building is within the def blue circle range). But just like boosts they can be taken out completely with 3 raid and don't add to you score until repaired, but at least they are never destroyed.

[Maverick50727]

Reserved for Future Content 3

[Maverick50727]

Reserved for Future Content 4

[Maverick50727]

Reserved for Future Content 5

[Thief]

You rock maverick!!!!

[jeffrey]

Maverick, you are simply amazing!

[Maverick50727]

Thanks for the positive feedback thus far. It could be much better if not for the many limitations I ran into converting to a public Google doc. Hope you like it and find it useful, feel free to post your feedback here or if anone has updates. Sending me a Private Message is probably the best for updates or corrections people may find, but I will try to review the thread periodically. Thanks again to the 27 people who were permissed early to help verify.

[Helmi88]

Thanks Maverick . Awesome work !!!

[cheiz]

Great Maverick! Just sent you a PM about this... but when I was typing that I didn't know you had already released it.

[JohnnyR]

This is....awesome Mav. Wondered what happened to ya buddy, hope all's well.

[Copenhagen]

Looks good, Mav! Thanks for all your hard work on this.

[Maverick50727]

This is....awesome Mav. Wondered what happened to ya buddy, hope all's well.

I’ve been sick with pneumonia since June. I never have fully gotten over it yet and still have a cough. I don’t post much in the forum unless it adds value typically and don’t have the time to read all the threads unfortunately, so I may be behind the curve at times or late to the party. My work blocks Funzio and Gmail via firewalls, so I have limited access while working, which is probably a good thing :) If you ever need to reach me , Private Message is the best. If it is full it (which happens almost daily) it should email me that you tried to contact me and I can still get back to you.

For every post in a thread I probably do 10-20 PMs or emails. I’ve been working with groups of forum members behind the curtains even though I’m not in the forum as much these days. I have my spys to keep me informed. Hopefully you will start to see more information and results of these behind the scene actions over the next few months.

[Tate]

I'm sure that many forumites will appreciate all the hard work that you and others put into this Maverick, I know that I certainly do!

[overkill 280]

Thank you so much Mav, You've done so much to help us all.

[Blackstone]

Thanks Maverick! Great job on this and very much appreciated.

[Hotlips]

thanks for the info, very organize worksheet you got;)

[kloid]

Hi

First time poster, long time reader.

Just wanted to also add my thanks to Maverick. This is not only an extremely useful resource but it is also nicely presented too! Great work :D

Cheers
Kloid

[Lt. Falcon]

Great resource Maverick, you did an awesome job....I have an update for you, Electric Power Plant level 7 is $50mil and takes 114 hours, these are without any cost or time reduction boosts.

[dthfrmabv]

This worksheets are awesome! STICKY STICKY!!!

Thanks man!

[Maverick50727]

Great resource Maverick, you did an awesome job....I have an update for you, Electric Power Plant level 7 is $50mil and takes 114 hours, these are without any cost or time reduction boosts.
Thanks for the confirm. Romaro beat you to it yesterday but I just haven't been able to update it yet as my work blocks google docs. He sent me these 2, but please keep them coming. I'll update as soon as I can
---

Electric power plant 6-7 current income 88000 new income 116000 cost 48500000 time 114 hours
Natural gas plant 6-7 current income 154000 new income 203000 cost 1746000 time 72 hours

Both with cement factory level 3

[BigD@wg]

Nice work Mav!

[Maverick50727]

Nice work Mav!
Love your artwork.

[Maverick50727]

This worksheets are awesome! STICKY STICKY!!!

Thanks man!
Hello Kitty was kind and added to her FAQ, so you can get there from her link. But many people do miss it, so I try to draw attention to it in some threads and in game posts on walls if people need help directing them to the forum. Hopefully that will bring in some new blood too.

[Arizona]

Hello Mav,
Thanks for all your time and effort putting the spreadsheets together. I've been adding defensive buildings and noticed a few errors regarding plot sizes.
Here are the correct ones I can confirm:
Fortified Bunker 9x9
Minefield 7x7

New data:
Fortified Bunker: Level 04
Raw upgrade cost 3,400,000
Raw upgrade time 18 hours
Defense 55

[Maverick50727]

Hello Mav,
Thanks for all your time and effort putting the spreadsheets together. I've been adding defensive buildings and noticed a few errors regarding plot sizes.
Here are the correct ones I can confirm:
Fortified Bunker 9x9
Minefield 7x7

New data:
Fortified Bunker: Level 04
Raw upgrade cost 3,400,000
Raw upgrade time 18 hours
Defense 55

Yes you are right. I verified that myself and had them written down correct, but must have transposed the 2 when I entered them. Human error. Good catch, that is why it is good to have more eyes looking at it. I'll correct when I have access later. Have a few addtions from various people.

[Gilgamesh]

Thanks for putting this together, great work. ( tips hat )

[JohnnyR]

Gotta love this sheet. Let's try keeping this up top where it belongs.

Mav, anyone else-your TRs dying on you?

[Guderian40]

Mav, excellent work - thanks a lot for that!!
I really enjoy such useful threads - as I enjoy this forum at least as much as the game...

THANK YOU!!

[Maverick50727]

Updated with info from Arizona and Romaro. If people have any updates I missed or can provide, please do so.

[Lt. Falcon]

Mav, level 8 EPP costs $83mil and takes 120 hrs to upgrade....boosts already excluded.


How much is the lvl 5->6 upgrade on the Natural Gas Plant?

[Maverick50727]

Mav, level 8 EPP costs $83mil and takes 120 hrs to upgrade....boosts already excluded.


How much is the lvl 5->6 upgrade on the Natural Gas Plant?

Thanks. Updated.

As for the L6 Natural Gas, it is unknown. Khimsoo's app just has an estimate of 1,092,000, but nobody has filled in that blank yet.

[Elvis Himself]

Thanks Maverick! This is so much help is deciding which upgrades to do. Thanks for giving us some tools to make our own strategy.

[Maverick50727]

Thanks Maverick! This is so much help is deciding which upgrades to do. Thanks for giving us some tools to make our own strategy.
You're welcome. I'm here to help with many other forum members. If you have questions feel free to ask or post a thread. People shouldn't lurk and be afraid to ask. Nobody should claim to be the ultimate expert here either, but among the members there should be many answers, sometimes different. You have to decide which answers or strategies will work for you according to your playstyle.

[Stormchaser]

First off, Thanks much for the awesome resource!! Secondly, here a bit of info for your charts...

Leveling to a level 7 Wind Farm = 54 hours and 265,000 money.

[EnjoyLife]

Here is some info that you are missing. The data is without boosts.
Desalination Lvl 6 costs 10 million
Diamond Mine Lvl 7 costs 125 million and takes 96 hours (I will have the infor for Lvl 8 in 2 days)
Geothermal Lvl 7 costs 125 million and takes 120 hours
Geothermal Lvl 8 costs 200 million and takes 126 hours
Space Center Lvl 5 costs 92 million and takes 114 hours
Space Center Lvl 6 costs 150 million and takes 132 hours

[Captain Steelman]

Just want to say, IMPRESSIVE WORK. Thx man....

[Procyon]

Holy crap, Mav! Not sure how I've missed this till now, but holy crap. This is a work of art! Can't imagine how much effort was involved to create this. Thanks for the truly unselfish sharing.

Did I say holy crap?

[dee17]

Tried PM'ing you Mav but your inbox was full. Here's a few more upgrade costs/times to help fill your spreadsheet. All figures are unboosted.

Natural gas to L6: 1,100,000
Recycling to L6: 7,700,000 84hr
Chemical to L6: 43,000,000 114hr
Desalination to L8: 29,000,000 84hr
Oil Refinery to L7: 30,000,000 108hr
Oil Refinery to L8: 50,000,000 114hr

[megaants]

Curious what are the green numbers in comparison to the black numbers?

edit: nvm i figure it out by reading the first page... hahaha. but EPP 5-6 is definitely 108 hours. doing it right now

[megaants]

Shipyard to lvl 8 720k 96 hours
Shipyard to lvl 9 1.2M 108 hours
Cement Factory to lvl 5 1.15m 48 hours

[Stormchaser]

To Level 8 Natural Gas Plant = 84 hrs : 3,000,000 money

Confirm Level 4 Desalination Plant = 24 hrs : 3,700,000
Confirm Level 3 Communications Center = 12 hrs : 310,000
Confirm Level 6 Military Market = 54 hrs : 338,000
Confirm Level 3 Ore Mine = 16 hrs : 1,150,000
Confirm Level 3 Recycling Plant = 18 hrs : 1,650,000

Confirm Level 2 Airship Hanger = 24 hrs : 500,000
Confirm Level 7 Cement Factory = 72 hrs : 3,250,000
Confirm Level 2 Electronics Factory = 18 hrs : 410,000
.ERROR. Level 2 Genetics Lab = 18 hrs : 330,000
Confirm Level 2 Naval Research Center = 36 hrs : 580,000

Confirm Level 3 Elite Training Facility = 18 hrs : 140,000
.ERROR. Level 5 War Factory = 36 hrs : 39,000


Thanks Again for the excellent resource!!

-Stormchaser

[Stormchaser]

Confirm Lvl 2 Oil Rig = 8,000,000 : 18 hrs

[Poopenshire]

are we still looking at a new revision it says this version is in the owners trash bin. love the money buildings

[Anjunbeats]

Could anyone explain to me what the "consumption rate" stands for? Did not find any explanation in the sheet or in this thread :(

[fluffy402]

Might as well bump this. Can someone please fix the money buildings?

[BringIt]

I noticed all but three of the money buildings disappeared...

[fluffy402]

I have a pdf saved on my PC with the correct money building information (unfortunately was too dumb to save it as an Excel file). Where's a place I can upload them?

[JimmyThePick]

Maverick,
First off, I wanted to say thank you for developing & putting the MW master resource sheets into the public domain. I have made 3 updates to a local copy of the sheets, and thought they might be useful to the group ( if not, no harm / no foul ). All of the changes impact the 4 building tabs; 3 additional columns were added (C, D, H).

1. Added a column (C) that contains the count of a particular building at a particular level. For instance, a user might have one level 4 armory & one level 6 armory, 0 biodomes, ect....

2. Added a column (D) that is a boolean column based on the value in the previously mentioned building count column (C). The purpose of this column is to allow the end user to filter on their specific upgrade path for a given set of buildings. For instance, creating a filter on column C that includes values 0,1, or 2 and on column D where the value is TRUE provides all current & available upgrade options.

3. Added column (H) which is an extension of the Build / Upgrade Cost Column. This new column automatically incorporates the discount from a Cement Factory (if it is present) and computes the updated values for building cost & ROI.

If you are interested, please let me know and I'll forward a copy of the updates. Regards,
Jim

[Adacus71]

You're welcome. I'm here to help with many other forum members. If you have questions feel free to ask or post a thread. People shouldn't lurk and be afraid to ask. Nobody should claim to be the ultimate expert here either, but among the members there should be many answers, sometimes different. You have to decide which answers or strategies will work for you according to your playstyle.

Hello!

This is my first post to the forum after a few weeks lurking.

Thanks for taking the time to put this information together. My base is what I would consider "a mess", and this is very helpful for future planning.

Are the money buildings that no longer show up going to come back? I'm trying to figure out what direction to go next.

Thanks again!

MW Handle = Specialist - 981828393
Level - 118, 50K A/49K D

[Dudebot121256]

Hello!

This is my first post to the forum after a few weeks lurking.

Thanks for taking the time to put this information together. My base is what I would consider "a mess", and this is very helpful for future planning.

Are the money buildings that no longer show up going to come back? I'm trying to figure out what direction to go next.

Thanks again!

MW Handle = Specialist - 981828393
Level - 118, 50K A/49K DWelcome to the forum, I hope you have a good experience.

If you haven't already, I recommend you check out the rules page (http://www.funzio.com/forum/showthread.php?36131-Posting-Guidelines).

Thank you and have a nice day :)

[Adacus71]

Welcome to the forum, I hope you have a good experience.

If you haven't already, I recommend you check out the rules page (http://www.funzio.com/forum/showthread.php?36131-Posting-Guidelines).

Thank you and have a nice day :)

Done! I'm too old for any of that stuff...heehee

I hope I didn't break a rule, and that was just a courtesy "please don't be a jerk" message....

MW Handle = Specialist - 981828393
Level - 118, 50K A/49K D

[Dudebot121256]

Done! I'm too old for any of that stuff...heehee

I hope I didn't break a rule, and that was just a courtesy "please don't be a jerk" message....

MW Handle = Specialist - 981828393
Level - 118, 50K A/49K DNope, not at all. You haven't broken any rules; you're good to go. I was just welcoming you and I decided to link you to the rules before you accidentally broke one and got warned/banned :)

[Adacus71]

Nope, not at all. You haven't broken any rules; you're good to go. I was just welcoming you and I decided to link you to the rules before you accidentally broke one and got warned/banned :)

Thanks for the welcome!

MW Handle = Specialist - 981828393

[Dudebot121256]

Thanks for the welcome!

MW Handle = Specialist - 981828393It appears to me that the "MW Handle = Specialist - 981828393" is your signature. If you want to automate it and not have to put it manually everytime, follow this tutorial.

Go to the top middle and look for Forum Actions. Then click General Settings. Scroll down to Edit Signature and input anything you want into the box below.

[Adacus71]

It appears to me that the "MW Handle = Specialist - 981828393" is your signature. If you want to automate it and not have to put it manually everytime, follow this tutorial.

Go to the top middle and look for Forum Actions. Then click General Settings. Scroll down to Edit Signature and input anything you want into the box below.

I was looking for the "how to" when you posted this. Very much appreciated.

[Dudebot121256]

I was looking for the "how to" when you posted this. Very much appreciated.No problem. If you need any help or have any questions, feel free to ask.

[nic4msu]

Thank you for creating& updating these spreadsheets. They are amazing!

Are these spreadsheet links in the 1st post the most up-to-date versions? I use them as my MW Bible, so just making sure I'm not following an old link. (the Toolkit is amazing, but sometimes the spreadsheet offers a better perspective)

[GeoffW]

I too was wondering if the spreadsheets are going to be kept up to date.
They have been in the owners bin for some while now which doesn't bode well.
As mentioned in a previous post, the toolkit is fantastic, but the raw data gives me insight I just can't get from the kit.

[iPlay]

Crime City 223 177 431 & 105 415 074
Modern Wars 486 317 760 & 649 613 652
Kingdom Age 879 083 229 & 311 860 583
Monster Quest 769 028 940

[DMJ]

Maverick,
I want to thank you for putting together this spreadsheet. It is extremely helpful. My question is, is there a way to copy the spreadsheet into my excel worksheet?

Thanks again for all that you have done!!

[GeoffW]

Maverick,
I want to thank you for putting together this spreadsheet. It is extremely helpful. My question is, is there a way to copy the spreadsheet into my excel worksheet?

Thanks again for all that you have done!!
DMJ - Just Download as xlsx (under the Google Sheets File menu).

[commander Don]

Can the anniversary center and Chinese takeaway building be added please.. this is so 2012.

[DMJ]

Thank you much GW


DMJ - Just Download as xlsx (under the Google Sheets File menu).

[beijota2]

Anyone have any idea where the armor buster comes from? 550/825 a/d, low casualty rate, loot item, not on the spreadsheet (yet).

Thanks.

[GeoffW]

North east Asia, insurgent village, cell leader.It's in the toolkit which is kept very up to date

[A3OT]

Oh, how much time did you spend on it?

[GeoffW]

Not sure what you mean. I just looked it up in the toolkit.

[Nouife]

Thanks a lot for putting these spreadsheets together Maverick, they're very useful.

[RALK3212421]

Got an updated one?

If I click on "Money Buildings" all it shows is the buildings that cost Gold Bars. Is there one that only shows in game cash?

[Deskjockey]

Download it and you will see all the buildings. It's still missing the AC, AMR, and AV, unfortunately. Anyone know the payout ladder, upgrade costs and times for the AV, in particular?

[RALK3212421]

Download it and you will see all the buildings. It's still missing the AC, AMR, and AV, unfortunately. Anyone know the payout ladder, upgrade costs and times for the AV, in particular?

I have downloaded the document...but it still only shows the BioDome, Geothermal Plant, and Watertreatment Plant...

Wierd.

EDIT: I can find them via the Google Docs link...and switch it to "List View". But can't find them anywhere when I download it...?

[commander Don]

Download it and you will see all the buildings. It's still missing the AC, AMR, and AV, unfortunately. Anyone know the payout ladder, upgrade costs and times for the AV, in particular?

Its so 2012....

[war hammer]

Well, I need some help really badly. It has to do with WHERE you get the SUPER HIGH atk/def LOOT units. I see that the resource spreadsheet lists all of them, but does not tell the area on the globe and/or mission "boss" to attack once you do find the area of the globe its located at. I HIGHLY recommend putting that info on the resource sheet. Don't take me wrong though, I do appreciate the info on all the units but its useless for what I need it for. Mainly because I want to start "loot farming" ever since I beat ALL the misions. I have seen many players with 1000+ of the same LOOT item and want to do something similar to that except "qaulity over qauntity". I want those LOOT units with like 300+ atk/def such as the "Wavebreaker", the Grom Trooper, the Riptide Runner, Executive Chinook, Etc. SOMEONE PLEASE HELP! I NEED THE HELP SO BAD! MAVERICK PLEASE SEE THIS AND ADD THE LOCATION ON THE GLOBE AND 'BOSS' TO ATTACK WHEN THERE!!!!!!!!!!!


PLEASE READ AND HELP IF YOU CAN!!!!!!!!

[war hammer]

Links:
"Modern War Master Resource Sheet – Part 1 (https://docs.google.com/spreadsheet/ccc?key=0AiSsos_vax1hdEhYUGRSdGtsY01odV9hS2QybXFiQ 3c)" – by Maverick50727
Missions, Bosses, Units, Strongest Cash and Valor Attack Units, Strongest Cash and Valor Defense Units

"Modern War Master Resource Sheet – Part 2 (https://docs.google.com/spreadsheet/ccc?key=0AiSsos_vax1hdGZ2VGl2OVFoRFBpelV2V3F4dmdGT Wc)" – by Maverick50727
PVP Ranks, Level, Money Buildings, Units Buildings, Boost Buildings, Defense Buildings, Expansions, Vault

Updates/Corrections:
PLEASE HELP VERIFY. To minimize people corrupting the sheet like people did in past public sheets, this public sheet will be read only for the public and I the only editor for now. All building costs, upgrade times and defense values (defense buildings only) are in GREEN, any blanks or those in BLACK may be correct just not verified a second time. If people could please check the upgrade costs, times and def values on their next upgrades if possible and post to this thread or send me a Private Message, I'll add changes submitted to the next sheet revision.

All changes will be provided to Khimsoo for use in his toolkit. So the better the information you provide here, the better we can make his Toolkit. If you haven’t checked out his Toolkit, I strongly encourage you to do so, as it is a great tool for economy planning."Toolkit for Modern War (http://www.funzio.com/forum/showthread.php?36750-Toolkit-for-Modern-War)" – by Khimsoo

When providing information please specify if this the discounted or original cost. If the discounted price please provide your current Cement Factory level and any units with bonus reductions. (see below)

If you have the Cement Factory, here is the formula to figure out the full price.

-1% Cost/0.99
-2% Cost/0.98
-3% Cost/0.97
-4% Cost/0.96
-5% Cost/0.95
-6% Cost/0.94
-7% Cost/0.93
-8% Cost/0.92
-9% Cost/0.91
-10% Cost/0.90

Units with Building Upgrade Cost Reductions (Cost / .70 or See Below)
Hurricane 30% Building Upgrade Cost Reduction
Monsoon Ship 30% Building Upgrade Cost Reduction
Draft Destroyer 30% Building Upgrade Cost Reduction
Draughtsman 30% Building Upgrade Cost Reduction

Units with Building Upgrade Time Reductions (Time / .80 or See Below)
Grey Bird 20% Building Upgrade Time Reduction
Silent Drifter 20% Building Upgrade Time Reduction
Shadow Stalker 20% Building Upgrade Time Reduction
Whirling Thunder 20% Building Upgrade Time Reduction
Storm Viper 20% Building Upgrade Time Reduction
Offensive Viper 20% Building Upgrade Time Reduction
Wicked Viper 20% Building Upgrade Time Reduction
Dragon Viper 20% Building Upgrade Time Reduction
Well, I need some help really badly. It has to do with WHERE you get the SUPER HIGH atk/def LOOT units. I see that the resource spreadsheet lists all of them, but does not tell the area on the globe and/or mission "boss" to attack once you do find the area of the globe its located at. I HIGHLY recommend putting that info on the resource sheet. Don't take me wrong though, I do appreciate the info on all the units but its useless for what I need it for. Mainly because I want to start "loot farming" ever since I beat ALL the misions. I have seen many players with 1000+ of the same LOOT item and want to do something similar to that except "qaulity over qauntity". I want those LOOT units with like 300+ atk/def such as the "Wavebreaker", the Grom Trooper, the Riptide Runner, Executive Chinook, Etc. SOMEONE PLEASE HELP! I NEED THE HELP SO BAD! MAVERICK PLEASE SEE THIS AND ADD THE LOCATION ON THE GLOBE AND 'BOSS' TO ATTACK WHEN THERE!!!!!!!!!!!


PLEASE READ AND HELP IF YOU CAN!!!!!!!!

[Nouife]

Does anybody know if the unit stats are still up to date in these spreadsheets, especially the casualty rates?

[American Capitalist]

This whole sheet needs a major update. No Ann. Center, AMR, AV, and Jinai Factory, plus the loot units chart is way out of date. The transport raider is supposedly the best unit, but I can't get it from any of the missions. Also all the new valor and cash units are there.

[Ericinico]

This whole sheet needs a major update. No Ann. Center, AMR, AV, and Jinai Factory, plus the loot units chart is way out of date. The transport raider is supposedly the best unit, but I can't get it from any of the missions. Also all the new valor and cash units are there.That's why you should download Khimsoos app.

[krabbie]

Please update the excel sheet for the Android users!

[eitematt]

Great sheet even if it is a bit out of date - good work and thanks

[Mr t]

Hi amigos, Is there a updated sheet somewhere?
This is a great sheet but misses the numerous new units.

[United Nation of Foxes]

Thanks for this

[Nullin]

When is this going to get updated :( it is very helpful

[ProCision]

When is this going to get updated :( it is very helpful

Feel free to start where he left off. Or just use the MWTool Kit

[Nullin]

I can't figure out the toolkit hell I can barely turn phone on lol