PDA

View Full Version : Buildings buildings buildings



RAMNUTS
12-01-2014, 08:00 PM
Can anyone please tell me where I can find the spreadsheet for all the mw buildings, new and old? I have posted this everywhere and I know its out there because I had it until I reset my phone. Thank you!

Mr Big C
12-01-2014, 08:15 PM
http://forums.gree.net/showthread.php?40885-Modern-War-Master-Resource-Sheet&highlight=resource+sheet

http://forums.gree.net/showthread.php?97716-Modern-War-Master-Resourse-Sheet&highlight=resource+sheet

The top link is the one that I was using, but then I built my own off of it. I have stopped looking at any of them for 8 months or more, so no idea if they work or how up to date they are.

SSG
12-01-2014, 09:11 PM
I am still working on it. I have most of the buildings and outputs just like the spreadsheet I publish for ltb's

smart tiger
12-02-2014, 04:31 AM
I have been searching too.. this seems to be the only link available.. The one by maverick seems to be outdated.. anyone else has an updated one?

http://forums.gree.net/showthread.php?65986-ALL-Money-Buildings-(Including-LTE-amp-Gold)-Raid-amp-Collection-Amounts

RAMNUTS
12-02-2014, 12:48 PM
I have been searching too.. this seems to be the only link available.. The one by maverick seems to be outdated.. anyone else has an updated one?

http://forums.gree.net/showthread.php?65986-ALL-Money-Buildings-(Including-LTE-amp-Gold)-Raid-amp-Collection-Amounts

Yea, I have been looking everywhere for it and it Is out there because I had it but can't seem to find it now. I have the link you posted, thanks btw, but I was hunting for the spreadsheet with the pictures of the buildings so I can enter my info into it. Did you ever use that mw toolkit? I wish we had that.
★★★
SSG, do you have an idea when yours will be completed? Thx

Kefa
12-02-2014, 02:19 PM
Thumpr's updated Powerbang's list through 2/2014:
http://forums.gree.net/showthread.php?77043-ALL-Money-Bldgs-Ver-2-0-%28Incl-Gold-amp-LTE%29-Raid-amp-Collection-Amounts

Then Bobthebuilder took it and ran with it through June/2014:
http://forums.gree.net/showthread.php?93865-ALL-Money-Bldgs-Ver-3-0-%28Incl-Gold-amp-LTE%29-Raid-amp-Collection-Amounts!!!&p=1325276#post1325276

Highland Cam
12-03-2014, 12:34 PM
https://docs.google.com/spreadsheets/d/1lMGwWo0YRgOZXoq1JWKK-j6XsjqcmiIeGML53lgZ7D4/edit?usp=sharing

First time posting spreadsheets here so let me know if the above doesn't work. Will post "instructions" in next post

Highland Cam
12-03-2014, 12:40 PM
Buildings list

This tab contains a list of all currently available buildings (both money and non-money). The yellow-highlighted cells (i.e. the level of each building) should be updated to match your current base.

Boosts & Collection pattern

This tab contains details of boosts, current cash and collection pattern. Again only the yellow-highlighted cells need to be updated.

The output boost section calculates the total bonus you currently get to building output. Basically the only change needed should be to put a Y or N depending on whether you own e.g. the EAF Desert Eagle as well as faction boosts and any additional/temp boosts.

The current cash is self-explanatory - current cash available for upgrades. This will feed through the rest of the spreadsheet and calculate which upgrades are currently possible.

The time boost section calculates the total time reduction for upgrades. Again only requires the highlighted cells to be updated (to "Y") for whichever units you own.

The cost boost section calculates the reduction in build and upgrade costs. The cement factory links directly to the building list so doesn't need changed. Again updated highlighted cells for units owned.

Finally the collection pattern section is used to calculate your daily income and also which economy upgrades will lead to largest increase in daily income. Again update the highlighted cells based on your estimated collections. Note the Max column shows the maximum available for each interval and is used to validate the numbers input into the highlighted cells (i.e. any number higher than max will not be accepted).

Income calculator

This tab uses the information provided in the first 2 tabs to calculate your IPH and daily income. Also included is a table showing the breakdown by collection interval (i.e. how much money you make from 24hr buildings etc). Also shows hourly and daily income for each building and ranks the buildings by IPH/daily output.

Top Economy upgrades

This tab calculates the best economy upgrades based on both increase in hourly income and daily income. No inputs required. Note the Top 25 upgrades (in Summary tab) is currently based on the best buildings for increasing daily income (generally favours 12hr/24hr buildings more than rankings based on hourly output).

Non-money upgrades

This tab shows the cost and time for each non-money building upgrade, including each individual defensive building. No inputs required.

Upgrade costs & times

Data for all buildings including base cost and time to build/upgrade. Some of this data is missing/incomplete so please let me know if you find any mistakes or can help update missing info.

Building Output

This tab shows the basic output, hourly output and daily output for all economy buildings (both base and boosted). No inputs required.

Summary

Summary tab which shows Top 25 economy upgrades (based on current cash) plus several tables for non-money (top 25 cheapest, costliest, quickest, slowest). Also shows output summary (i.e. output for each time interval) and IPH/Daily income. Note I have excluded gold buildings from this (unless you have already purchased some - i.e. upgrades of gold buildings will still be included but not new gold buildings). Also there is another table showing quickest upgrades currently possible (along with daily output rank to help choose between similar timings).

Highland Cam
12-03-2014, 12:42 PM
Please feel free to point out any potential improvements, in particular any information that may be missing/wrong. Also feel free to post any questions here and/or PM me (note I don't necessarily log in here every day so don't expect an instant reply!)