PDA

View Full Version : Building Spreadsheet With Bonus calculators towards Cost, Time and Sell price.



TempusDA
04-16-2013, 01:17 PM
Building Spreadsheet With Bonus calculators towards Cost, Time and Sell price.

It is based off of Upgrade Time 5/5 and Upgrade Cost 5/4.
https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=38

Here is the spreadsheet based off of Upgrade Time 5/5 and Upgrade Cost 5/5
https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=44

It has all buildings Gold, Unit, Boost. No defense buildings.

You plugin your Lumber Mill bonus and any Time bonus from Units.

It will spit out the accurate info.

If there are Units that offer bonus towards cost let me know I can add that to the spreadsheet.

It has sort list functions.

I may add the ability to enter Upgrade Cost and Upgrade Time level into boxes later. It is a lot more difficult to do, it requires very long formulas based on 5 different logic variances. I may attempt it later if I get board hehe.

I took the Level 5 Discount upgrades list someone uploaded to my collection as a base and built on it. Thanks to Krissy for adding it to the collection.
This is her spreadsheet.
https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=23
(https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=23)
If you add spreadsheets to the collection please leave your name so we know who to thank.

This is a bit dry from my usual post will comeback and make it nicer,

Please feel free to leave suggestions to improve it.

If you got skills and want to attempt the upgrade cost and upgrade time level boxes go for it. You will know how to unhide the calculator section. I have a back up if it breaks I will replace it.

Hope you all find it useful.

Tempus

itsaklayton
04-16-2013, 03:13 PM
Thank you for this amazing effort.

Krissy
04-16-2013, 04:25 PM
It was me. I modified the original googledoc and took out the roi stuff. It assumes you have level 10 lumber mill. My guild wanted to know the discounted price using our bonuses. Excel is a wonderful thing. Sorry for adding without asking. There are a couple of errors. Couldn't figure out how to take out the level 1s. For level 1 building your guild upgrades don't count. The buying price only counts your lumber mill. The selling price of level 1 buildings is half the original price. For all upgrades the list is valid.

TempusDA
04-16-2013, 04:33 PM
It was me. I modified the original googledoc and took out the roi stuff. It assumes you have level 10 lumber mill. My guild wanted to know the discounted price using our bonuses. Excel is a wonderful thing. Sorry for adding without asking. There are a couple of errors. Couldn't figure out how to take out the level 1s. For level 1 building your guild upgrades don't count. The buying price only counts your lumber mill. The selling price of level 1 buildings is half the original price. For all upgrades the list is valid.

You have nothing to be sorry for it was greatly appreciated. Actually thank you, you can add stuff anytime. :) Hope you don't mind that I used yours as a base it was nice and stream lined perfect as a tool for people trying to increase their IPH or stats via Boost buildings. Wanted to find out who it was so I could give credit where it is due. I will add your name as the creator of the spreadsheet. Hope you like the additions I made. I will make the changes you wanted on yours for the initial build not having bonuses will adjust mine as well. I thought that was the way it worked but wasn't one 100% sure. Having the sell price adjusted by the bonus was genius, I don't think i seen anyone do that yet.

Thank You for the addition of a wonderful spreadsheet keep them coming if you want. :)

Tempus

PS if you want another spot to advertise your guild I created a Guild Recruitment Spreadsheet here feel free to add your guild there.

https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=27

TempusDA
04-16-2013, 04:38 PM
Thank you for this amazing effort.

Your very welcome so glad it is helping other players and guilds.

Krissy
04-16-2013, 04:48 PM
Thanks for the complement on the sale price. I got screwed on my bd10 run and had to sell an additional building. I had everything written down and back calculated what I got for my manor 3s to find the rules had changed. Finally convinced a couple of guys here, but most keep quoting the original half price rule for selling.

Krissy
04-16-2013, 09:21 PM
Level 5 Guild upgrade spreadsheet is fixed. Sorted the level 1s out and applied correct formula.

TempusDA
04-16-2013, 11:20 PM
Nice I made adjustments to mine as well.
First builds have no bonus to cost or time and sell price is half off normal upgrade cost.
All builds after first build have Upgrade Cost with bonus, Upgrade Time with bonus and sell price is half off Bonus Upgrade Cost.
Added a note about first builds.

TempusDA
04-25-2013, 03:03 PM
Ok so I made the spreadsheet based on guild bonuses 5/5 Upgrade cost and 5/5 Upgrade Time

https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=44