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

GREE

GREE Forum - Powered by vBulletin
Results 1 to 13 of 13

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

  1. #1
    Articulate Author TempusDA's Avatar
    Member Since
    Mar 2013
    Post Count
    351

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


    Guild Bonus and Wall Upgrades - Spreadsheet







    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}

    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}
    {LTQ Legacy of Patrickus - Spreadsheet}
    {LTQ Hades' Challenge - Spreadsheet}
    {LTQ A Brutish Codex - Spreadhseet}
    {LTQ A Bard's Song - Spreadsheet}

    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



    Last edited by TempusDA; 03-23-2013 at 04:46 AM.

  2. #2
    Articulate Author TempusDA's Avatar
    Member Since
    Mar 2013
    Post Count
    351
    Let me know if someone broke the Calculator. I have a protected copy I can replace the broken one with.

  3. #3
    Articulate Author TempusDA's Avatar
    Member Since
    Mar 2013
    Post Count
    351
    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

  4. #4
    Consistent Contributor
    Member Since
    Feb 2013
    Post Count
    182

    Calculations

    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.

  5. #5
    Articulate Author TempusDA's Avatar
    Member Since
    Mar 2013
    Post Count
    351
    Quote Originally Posted by Krissy View Post
    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.

  6. #6
    Prominent Poet
    Member Since
    Nov 2012
    Location
    US
    Post Count
    1,375
    Quote Originally Posted by Krissy View Post
    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.
    KA : 831745853
    BnB is recruiting : http://www.funzio.com/forum/showthre...-is-recruiting
    MW: 301523231

    Fortune doesn't favor the bold, that's stupid. Fortune favors the intelligent, prepared, and patient. - Me, 2012

    Please stop complaining about how bad Gree is at <fill in the blank>. A cursory search of the forums with the keywords 'Gree' and 'sucks' should let you see that we already know. - Me, 2013

  7. #7
    Articulate Author TempusDA's Avatar
    Member Since
    Mar 2013
    Post Count
    351
    Quote Originally Posted by Krissy View Post
    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
    Last edited by TempusDA; 03-23-2013 at 04:36 AM.

  8. #8
    Consistent Contributor
    Member Since
    Jun 2012
    Location
    Washington, DC
    Post Count
    131
    To buy a level 1 wall is 10,000 why does it show 15,000?
    Jesus - 614-298-890 (KA)
    Lvl 176- 591.3k A - 596.6k D - 21.9k IPH - 500 Allies

    Looking for guilds? Please join us.
    756-470-120

    Current guild bonuses:
    +23% upgrade speed
    +23% upgrade cost reduction
    +10% casualty decrease
    +24 guild member

  9. #9
    Articulate Author Dirt road Joe's Avatar
    Member Since
    Oct 2012
    Location
    Kansas
    Post Count
    282
    Quote Originally Posted by Jeshu View Post
    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.
    Matthew 7:3-5

  10. #10
    Consistent Contributor
    Member Since
    Jun 2012
    Location
    Washington, DC
    Post Count
    131
    It shows 10,000 on my end... Am I getting a discount somehow? I took a screen capture too on my iPhone.
    Jesus - 614-298-890 (KA)
    Lvl 176- 591.3k A - 596.6k D - 21.9k IPH - 500 Allies

    Looking for guilds? Please join us.
    756-470-120

    Current guild bonuses:
    +23% upgrade speed
    +23% upgrade cost reduction
    +10% casualty decrease
    +24 guild member

  11. #11
    Verbose Veteran
    Member Since
    Dec 2011
    Post Count
    947
    this is awesome, however , I got two quickblades in the last quest , you only have one listed.

  12. #12
    Consistent Contributor
    Member Since
    Feb 2013
    Post Count
    182
    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.

  13. #13
    Consistent Contributor
    Member Since
    Jun 2012
    Location
    Washington, DC
    Post Count
    131
    Quote Originally Posted by Krissy View Post
    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?
    Jesus - 614-298-890 (KA)
    Lvl 176- 591.3k A - 596.6k D - 21.9k IPH - 500 Allies

    Looking for guilds? Please join us.
    756-470-120

    Current guild bonuses:
    +23% upgrade speed
    +23% upgrade cost reduction
    +10% casualty decrease
    +24 guild member

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •