Guild Bonus and Wall Upgrades - Spreadsheet. With Time and Cost Caluculator

[TempusDA]

Guild Bonus and Wall Upgrades - Spreadsheet




http://img715.imageshack.us/img715/3552/guildbonusandwallupgrad.png (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=4)

http://img805.imageshack.us/img805/5641/timeandcostcalculators.png (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=4)


Would like to bring you the results of a Collaboration effort on the Guild Bonuses and Upgrades in the form of a Spreadsheet.

Fellow peers have come together to provide the information for the sheet. You can view them on the Collaborators Tag Wall.


It is complete except for the costs on Health Regeneration and Guild Increase IV upgrades.

Here is the link ---> {Guild Bonus and Wall Upgrades - Spreadsheet}
(https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=4)
There is a Time Modifier and Cost Modifier Calculator in the Spreadsheet.

Hope you folks find it helpful.

Links to other Spreadsheets in the collection:
{LTQ Bound by Honor - Spreadsheet} (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=17)
{LTQ Legacy of Patrickus - Spreadsheet} (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=12)
{LTQ Hades' Challenge - Spreadsheet} (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=3)
{LTQ A Brutish Codex - Spreadhseet} (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=1)
{LTQ A Bard's Song - Spreadsheet} (https://docs.google.com/spreadsheet/ccc?key=0AgCUTOSskdQjdGlOWW4yTWJaQUxJSUt6clRTeXlEe UE#gid=2)

Would like to give special thanks to all past and future collaborators that make the game more enjoyable for everyone.

Good luck to all the guilds in "Battle for Dragon's Roost" and future guild events.

Fight with Honor and feast in the Halls of Valhalla.


Tempus



Here is a link to > {LTQ Limited Time Quest - Spreadsheet Collection of drops.} (http://www.funzio.com/forum/showthread.php?49423-LTQ-Limited-Time-Quest-Spreadsheet-Collection-of-drops.)
Funzio Forums.

[TempusDA]

Let me know if someone broke the Calculator. I have a protected copy I can replace the broken one with.

[TempusDA]

The only values left to complete this spread sheet, are the costs for Health Regeneration and Guild Increase IV. If you have the info and would like to share please visit the spreadsheet and fill in the blanks or leave a reply here and I will add it for you.

If you Contribute

[Krissy]

Technically its not .22 plus .10 for lumber mill. My calculation are .95*.95*.95*.95*.95*.90 = .6964 of original cost which would make it .3036 not 0.32. Or am I wrong.

[TempusDA]

Technically its not .22 plus .10 for lumber mill. My calculation are .95*.95*.95*.95*.95*.90 = .6964 of original cost which would make it .3036 not 0.32. Or am I wrong.

Well in Guild Bonus it shows as a clear 22% and you get 10% for lumber mil would have to bounce it off unmodified cost and compare it to actual.

[Shinazueli]

Technically its not .22 plus .10 for lumber mill. My calculation are .95*.95*.95*.95*.95*.90 = .6964 of original cost which would make it .3036 not 0.32. Or am I wrong.

I've verified this calculation with three different upgrades: it's correct. Percentage bonuses are never additive.

[TempusDA]

Technically its not .22 plus .10 for lumber mill. My calculation are .95*.95*.95*.95*.95*.90 = .6964 of original cost which would make it .3036 not 0.32. Or am I wrong.

I have adjusted to Calculators to match your formula. Thank You I also double checked the values against the actual time and the actual amount saved.

Also thanks to Shinazueli

Please go ahead and triple check it to make sure :)

[Jeshu]

To buy a level 1 wall is 10,000 why does it show 15,000?

[Dirt road Joe]

To buy a level 1 wall is 10,000 why does it show 15,000?
The wall costs 15,000. It comes with 10,000 Health.

[Jeshu]

It shows 10,000 on my end... Am I getting a discount somehow? I took a screen capture too on my iPhone.

[plavine]

this is awesome, however , I got two quickblades in the last quest , you only have one listed.

[Krissy]

Nobody has done this yet. I modified the existing spreadsheet to account for Guild level 5 time and cost bonuses. It also contains the new guild sale price of buildings accounting for your guild discount. ITS NOT HALF anymore.

[Jeshu]

Nobody has done this yet. I modified the existing spreadsheet to account for Guild level 5 time and cost bonuses. It also contains the new guild sale price of buildings accounting for your guild discount. ITS NOT HALF anymore.
So to get half you have to abandon your guild and then rejoin afterwards?