Building Lookup Tables by Level

GREE

DECAGAMES Forum - Powered by vBulletin
Page 1 of 8 123 ... LastLast
Results 1 to 15 of 107

Thread: Building Lookup Tables by Level

  1. #1
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Lookup Tables by Level

    The purpose of this thread is to share a different way of looking at the same data we've seen before for building planning and raiding purposes. Building data by level:

    Raid Payouts
    Output
    Upgrade Costs
    Upgrade Times
    Income Per Hour (IPH)
    General Info
    Weighted upgrade ROI in days. (by Octofinger)
    Last edited by Hello Kitty; 03-22-2013 at 10:41 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  2. #2
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Raid Payouts by Level

    The following table is a matrix of the payouts for raiding each building at their respective levels. The grid highlights payouts greater than 5000 gold in green and between 2000 and 4999 in pink. The data is sorted in descending order (highest to lowest) on column L10.

    Building L1 L2 L3 L4 L5 L6 L7 L8 L9 L10
    Manor 9,000 18,000 31,500 49,500 72,000 99,000 130,500 166,500 207,000 270,000
    Gold Mine* 1,350 2,700 4,725 7,425 10,800 14,850 19,575 24,975 31,050 40,500
    Lender 1,200 2,400 4,200 6,600 9,600 13,200 17,400 22,200 27,600 36,000
    Playhouse 780 1,560 2,730 4,290 6,240 8,580 11,310 14,430 17,940 23,400
    Wine Maker* 600 1,200 2,100 3,300 4,800 6,600 8,700 11,100 13,800 18,000
    Inn 405 810 1,418 2,228 3,240 4,455 5,873 7,493 9,315 12,150
    Shipyard 300 600 1,050 1,650 2,400 3,300 4,350 5,550 6,900 9,000
    Leatherworker 270 540 945 1,485 2,160 2,970 3,915 4,995 6,210 8,100
    Printing Press 210 420 735 1,155 1,680 2,310 3,045 3,885 4,830 6,300
    Silo 198 396 693 1,089 1,584 2,178 2,871 3,663 4,554 5,940
    Jewelcrafter* 195 390 683 1,073 1,560 2,145 2,828 3,608 4,485 5,850
    Stable 174 348 609 957 1,392 1,914 2,523 3,219 4,002 5,220
    Pottery Maker 150 300 525 825 1,200 1,650 2,175 2,775 3,450 4,500
    Butcher Shop 114 228 399 627 912 1,254 1,653 2,109 2,622 3,420
    Trading Post 114 228 399 627 912 1,254 1,653 2,109 2,622 3,420
    Tavern 99 198 347 545 792 1,089 1,436 1,832 2,277 2,970
    Fish Market 78 156 273 429 624 858 1,131 1,443 1,794 2,340
    Brothel 78 156 273 429 624 858 1,131 1,443 1,794 2,340
    Library 75 150 263 413 600 825 1,088 1,388 1,725 2,250
    Apothecary* 72 144 252 396 576 792 1,044 1,332 1,656 2,160
    Castle 60 120 210 330 480 660 870 1,110 1,380 1,800
    Merchant Caravan 60 120 210 330 480 660 870 1,110 1,380 1,800
    Tailor 50 101 176 277 403 554 731 932 1,159 1,512
    Cartographer 41 82 143 224 326 449 592 755 938 1,224
    Bakery 29 58 101 158 230 317 418 533 662 864
    Bazaar 15 30 53 83 120 165 218 278 345 450
    Farm 7 14 25 40 58 79 104 133 166 216
    Cottage 2 4 7 10 14 20 26 34 41 54
    *Gold Buildings
    Last edited by Hello Kitty; 03-22-2013 at 10:50 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  3. #3
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Output by Level

    The following matrix is the gold output for each building by level. The data is sorted by payout hours.

    Building Payout
    Hours
    L1 L2 L3 L4 L5 L6 L7 L8 L9 L10
    Manor 48 15,000 30,000 52,500 82,500 120,000 165,000 217,500 277,500 345,000 450,000
    Playhouse 48 1,300 2,600 4,550 7,150 10,400 14,300 18,850 24,050 29,900 39,000
    Gold Mine* 24 2,250 4,500 7,875 12,375 18,000 24,750 32,625 41,625 51,750 67,500
    Lender 24 2,000 4,000 7,000 11,000 16,000 22,000 29,000 37,000 46,000 60,000
    Inn 24 675 1,350 2,363 3,713 5,400 7,425 9,788 12,488 15,525 20,250
    Leatherworker 24 450 900 1,575 2,475 3,600 4,950 6,525 8,325 10,350 13,500
    Silo 24 330 660 1,155 1,815 2,640 3,630 4,785 6,105 7,590 9,900
    Castle 24 100 200 350 550 800 1,100 1,450 1,850 2,300 3,000
    Shipyard 18 500 1,000 1,750 2,750 4,000 5,500 7,250 9,250 11,500 15,000
    Jewelcrafter* 18 325 650 1,138 1,788 2,600 3,575 4,713 6,013 7,475 9,750
    Stable 18 290 580 1,015 1,595 2,320 3,190 4,205 5,365 6,670 8,700
    Wine Maker* 12 1,000 2,000 3,500 5,500 8,000 11,000 14,500 18,500 23,000 30,000
    Printing Press 12 350 700 1,225 1,925 2,800 3,850 5,075 6,475 8,050 10,500
    Pottery Maker 12 250 500 875 1,375 2,000 2,750 3,625 4,625 5,750 7,500
    Tavern 12 165 330 578 908 1,320 1,815 2,393 3,053 3,795 4,950
    Butcher Shop 8 190 380 665 1,045 1,520 2,090 2,755 3,515 4,370 5,700
    Library 8 125 250 438 688 1,000 1,375 1,813 2,313 2,875 3,750
    Trading Post 6 190 380 665 1,045 1,520 2,090 2,755 3,515 4,370 5,700
    Fish Market 6 130 260 455 715 1,040 1,430 1,885 2,405 2,990 3,900
    Tailor 6 84 168 294 462 672 924 1,218 1,554 1,932 2,520
    Brothel 3 130 260 455 715 1,040 1,430 1,885 2,405 2,990 3,900
    Apothecary* 3 120 240 420 660 960 1,320 1,740 2,220 2,760 3,600
    Cartographer 3 68 136 238 374 544 748 986 1,258 1,564 2,040
    Bakery 3 48 96 168 264 384 528 696 888 1,104 1,440
    Merchant Caravan 1 100 200 350 550 800 1,100 1,450 1,850 2,300 3,000
    Bazaar 1 25 50 88 138 200 275 363 463 575 750
    Farm 0.50 12 24 42 66 96 132 174 222 276 360
    Cottage 0.08 3 6 11 17 24 33 44 56 69 90

    *Gold Buildings
    Last edited by Hello Kitty; 09-16-2012 at 09:38 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  4. #4
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Upgrade Cost by Level

    The following is the cost to upgrade to each level (L1 is original build), sorted in descending order on L10. Cumulative (Cum) amount is the total cost to upgrade to level 10. This chart does not account for Lumber Mill discounts.

    Building Payout
    Hours
    L1 L2 L3 L4 L5 L6 L7 L8 L9 L10 Cum
    Amount
    Manor 48 250,000 420,000 700,000 1,150,000 1,950,000 3,250,000 5,400,000 9,000,000 15,000,000 25,000,000 62,120,000
    Playhouse 48 8,400 14,000 23,500 39,000 65,500 109,000 182,000 304,000 508,000 850,000 2,103,400
    Gold Mine* 24 500G' 45,000 75,000 125,000 210,000 350,000 585,000 975,000 1,600,000 2,700,000 6,665,000
    Lender 24 50,000 83,500 140,000 230,000 390,000 650,000 1,100,000 1,800,000 3,000,000 5,000,000 12,443,500
    Inn 24 10,000 16,500 28,000 46,000 77,000 130,000 215,000 360,000 600,000 1,000,000 2,482,500
    Leatherworker 24 2,200 3,700 6,100 10,000 17,000 28,500 47,500 80,000 135,000 220,000 550,000
    Silo 24 225 375 625 1,050 1,750 2,900 4,900 8,150 13,500 22,500 55,975
    Castle 24 210 350 600 975 1,600 2,700 4,500 7,600 12,500 31,035
    Shipyard 18 6,500 11,000 18,000 30,000 50,000 84,000 140,000 235,000 395,000 650,000 1,619,500
    Jewelcrafter* 18 190G' 30,000 50,000 84,000 140,000 230,000 390,000 650,000 1,050,000 1,800,000 4,424,000
    Stable 18 1,400 2,300 3,900 6,500 11,000 18,000 30,000 51,000 85,000 140,000 349,100
    Wine Maker* 12 200G' 30,000 50,000 84,000 140,000 230,000 390,000 650,000 1,100,000 1,800,000 4,474,000
    Printing Press 12 12,000 20,000 33,500 56,000 93,000 155,000 260,000 435,000 725,000 1,200,000 2,989,500
    Pottery Maker 12 3,600 6,000 10,000 17,000 28,000 46,000 78,000 130,000 215,000 365,000 898,600
    Tavern 12 600 1,000 1,650 2,800 4,650 7,800 13,000 22,000 36,000 60,000 149,500
    Butcher Shop 8 6,000 10,000 16,500 28,000 47,000 78,000 130,000 215,000 365,000 600,000 1,495,500
    Library 8 1,000 1,700 2,800 4,700 7,800 13,000 22,000 36,000 60,000 100,000 249,000
    Trading Post 6 15,000 25,000 42,000 70,000 115,000 195,000 325,000 540,000 900,000 1,500,000 3,727,000
    Fish Market 6 4,200 7,000 12,000 20,000 33,000 55,000 91,000 150,000 250,000 425,000 1,047,200
    Tailor 6 375 625 1,050 1,750 2,900 4,900 8,100 13,500 22,500 38,000 93,700
    Brothel 3 22,000 37,000 61,000 102,000 170,000 285,000 475,000 800,000 1,300,000 2,200,000 5,452,000
    Apothecary* 3 60G' 20,000 33,000 55,000 93,000 150,000 250,000 430,000 720,000 1,200,000 2,951,000
    Cartographer 3 3,000 5,000 8,400 14,000 23,000 39,000 65,000 110,000 180,000 300,000 747,400
    Bakery 3 120 200 335 560 935 1,550 2,600 4,300 7,200 12,000 29,800
    Merchant Caravan 1 7,200 12,000 20,000 33,000 56,000 94,000 155,000 260,000 435,000 725,000 1,797,200
    Bazaar 1 75 125 210 350 585 975 1,650 2,700 4,550 7,600 18,820
    Farm 0.50 45 75 125 210 350 585 975 1,650 2,700 4,550 11,265
    Cottage 0.08 30 50 84 140 233 390 650 1,085 1,800 3,000 7,462

    *Gold Buildings
    Last edited by Hello Kitty; 10-03-2012 at 05:44 PM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  5. #5
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Upgrade Times by Level

    The following are the times to upgrade buildings to each level (L1 is original build), sorted in descending order on L10. Cumulative (Cum) values are the total times to upgrade to level 10 in hours and days. This chart does not account for discounts from events such as the Holy Avenger (10% faster upgrades).

    Building Payout
    Hours
    L1 L2 L3 L4 L5 L6 L7 L8 L9 L10 Cum
    Hours
    Cum
    Days
    Manor 48 36 48 60 72 84 96 108 120 132 144 900 37.50
    Playhouse 48 12 32 44 53 62 71 80 89 98 107 648 27.00
    Gold Mine* 24 9 12 15 18 21 24 27 30 33 189 7.88
    Lender 24 24 44 56 68 80 92 104 116 128 140 852 35.50
    Inn 24 15 34 44 54 64 74 84 94 104 114 681 28.38
    Leatherworker 24 2 6 12 30 36 42 48 54 60 66 356 14.83
    Silo 24 1 1 3 10 24 42 48 60 66 72 326 13.58
    Castle 24 1 2 8 18 22 26 30 34 38 179 7.45
    Shipyard 18 9 27 39 47 55 63 71 79 87 95 572 23.83
    Jewelcrafter* 18 12 15 18 21 24 27 30 33 36 216 9.00
    Stable 18 1.50 4 10 24 30 36 42 48 54 60 310 12.90
    Wine Maker* 12 18 30 40 48 56 64 72 80 88 496 20.67
    Printing Press 12 18 36 46 56 66 76 86 96 106 116 702 29.25
    Pottery Maker 12 3.00 12 18 36 43 50 57 64 71 78 432 18.00
    Tavern 12 1 3 6 16 25 30 35 40 45 50 251 10.44
    Butcher Shop 8 8.00 24 36 42 50 58 66 74 82 90 530 22.08
    Library 8 1.25 3 8 18 27 33 39 45 51 57 282 11.76
    Trading Post 6 20.00 38 48 58 68 78 88 98 108 118 722 30.08
    Fish Market 6 5 16 24 38 46 54 62 70 78 86 479 19.96
    Tailor 6 0.75 2 4 12 24 29 34 39 44 49 238 9.91
    Brothel 3 22.00 40 51 62 73 84 95 106 117 128 778 32.42
    Apothecary* 3 0.01 3 6 9 12 15 18 21 24 27 135 5.63
    Cartographer 3 2.50 8.00 16 33 40 47 54 61 68 75 405 16.85
    Bakery 3 0.25 0.75 2 8 18 22 26 30 34 38 179 7.46
    Merchant Caravan 1 10.00 30.00 42 45 54 63 72 81 90 99 586 24.42
    Bazaar 1 0.10 0.50 1.00 6 16 20 24 28 32 36 164 6.82
    Farm 0.50 0.01 1 4 12 16 20 24 28 32 137 5.71
    Cottage 0.08 0.01 0.10 0.50 3 9 12 15 18 21 24 103 4.28





    *Gold Buildings
    Last edited by Hello Kitty; 03-22-2013 at 10:50 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  6. #6
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building Income Per Hour (IPH) by Level

    The following matrix is the income per hour (IPH) for each building by level. The data is sorted by payout hours.

    Building Payout
    Hours
    L1 L2 L3 L4 L5 L6 L7 L8 L9 L10
    Manor 48 313 625 1,094 1,719 2,500 3,438 4,531 5,781 7,188 9,375
    Playhouse 48 27 54 95 149 217 298 393 501 623 813
    Gold Mine* 24 94 188 328 516 750 1,031 1,359 1,734 2,156 2,813
    Lender 24 83 167 292 458 667 917 1,208 1,542 1,917 2,500
    Inn 24 28 56 98 155 225 309 408 520 647 844
    Leatherworker 24 19 38 66 103 150 206 272 347 431 563
    Silo 24 14 28 48 76 110 151 199 254 316 413
    Castle 24 4 8 15 23 33 46 60 77 96 125
    Shipyard 18 28 56 97 153 222 306 403 514 639 833
    Jewelcrafter* 18 18 36 63 99 144 199 262 334 415 542
    Stable 18 16 32 56 89 129 177 234 298 371 483
    Wine Maker* 12 83 167 292 458 667 917 1,208 1,542 1,917 2,500
    Printing Press 12 29 58 102 160 233 321 423 540 671 875
    Pottery Maker 12 21 42 73 115 167 229 302 385 479 625
    Tavern 12 14 28 48 76 110 151 199 254 316 413
    Butcher Shop 8 24 48 83 131 190 261 344 439 546 713
    Library 8 16 31 55 86 125 172 227 289 359 469
    Trading Post 6 32 63 111 174 253 348 459 586 728 950
    Fish Market 6 22 43 76 119 173 238 314 401 498 650
    Tailor 6 14 28 49 77 112 154 203 259 322 420
    Brothel 3 43 87 152 238 347 477 628 802 997 1,300
    Apothecary* 3 40 80 140 220 320 440 580 740 920 1,200
    Cartographer 3 23 45 79 125 181 249 329 419 521 680
    Bakery 3 16 32 56 88 128 176 232 296 368 480
    Merchant Caravan 1 100 200 350 550 800 1,100 1,450 1,850 2,300 3,000
    Bazaar 1 25 50 88 138 200 275 363 463 575 750
    Farm 0.50 24 48 84 132 192 264 348 444 552 720
    Cottage 0.08 36 72 132 204 288 396 528 672 828 1,080

    *Gold Buildings
    Last edited by Hello Kitty; 09-16-2012 at 09:35 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  7. #7
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637

    Building General Info by Level

    The following is general building information: the level the building is unlocked, plot size, and defense values of each building by level. The actual usage calculations of the building defense values remains unknown, but most likely increases the risk of losing units to a rival when raiding. No info available for Castle defense.

    Building Unlocks Size L1 L2 L3 L4 L5 L6 L7 L8 L9 L10
    Castle 0 12 x 12
    Gold Mine* 1 7 x 7 12 24 36 48 60 72 84 96 108 120
    Apothecary* 1 6 x 6 5 10 15 20 25 30 35 40 45 50
    Farm 1 8 x 8 2 4 6 8 10 12 14 16 18 20
    Cottage 1 6 x 6 1 2 3 4 5 6 7 8 9 10
    Bazaar 2 7 x 7 3 6 9 12 15 18 21 24 27 30
    Bakery 3 6 x 6 4 8 12 16 20 24 28 32 36 40
    Silo 4 5 x 5 5 10 15 20 25 30 35 40 45 50
    Jewelcrafter* 5 6 x 6 11 22 33 44 55 66 77 88 99 110
    Tailor 6 7 x 7 6 12 18 24 30 36 42 48 54 60
    Tavern 7 7 x 7 7 14 21 28 35 42 49 56 63 70
    Library 8 7 x 7 8 16 24 32 40 48 56 64 72 80
    Stable 9 6 x 6 9 18 27 36 45 54 63 72 81 90
    Leatherworker 10 7 x 7 10 20 30 40 50 60 70 80 90 100
    Cartographer 11 5 x 5 11 22 33 44 55 66 77 88 99 110
    Pottery Maker 13 7 x 7 12 24 36 48 60 72 84 96 108 120
    Fish Market 14 6 x 6 13 26 39 52 65 78 91 104 117 130
    Wine Maker* 17 10 x 10 28 56 84 112 140 168 196 224 252 280
    Butcher Shop 19 6 x 6 15 30 45 60 75 90 105 120 135 150
    Shipyard 21 12 x 12 15 30 45 60 75 90 105 120 135 150
    Merchant Caravan 23 6 x 6 16 32 48 64 80 96 112 128 144 160
    Playhouse 24 11 x 11 17 34 51 68 85 102 119 136 153 170
    Inn 27 7 x 7 18 36 54 72 90 108 126 144 162 180
    Printing Press 31 7 x 7 14 28 42 56 70 84 98 112 126 140
    Trading Post 33 7 x 7 20 40 60 80 100 120 140 160 180 200
    Brothel 36 9 x 9 21 42 63 84 105 126 147 168 189 210
    Lender 38 10 x 10 23 46 69 92 115 138 161 184 207 230
    Manor 41 8 x 8 30 60 90 120 150 180 210 240 270 300

    *Gold Buildings
    Last edited by Hello Kitty; 09-16-2012 at 09:34 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

  8. #8
    Verbose Veteran BadNews's Avatar
    Member Since
    Jul 2012
    Post Count
    530
    Great! !!!!!

  9. #9
    Consistent Contributor Serboy's Avatar
    Member Since
    Jun 2012
    Location
    Kingdom Age
    Post Count
    199
    Good job !! It has to be sticky
    Last edited by Serboy; 09-16-2012 at 10:11 AM.
    Kingdom Age: Serboy

  10. #10
    Steady Scribe
    Member Since
    Sep 2012
    Post Count
    42
    Nice layout.
    Request for sticky

  11. #11
    Verbose Veteran echus14's Avatar
    Member Since
    Jul 2012
    Location
    The Little Red Dot
    Post Count
    968
    Great job (as usual) HK! Agree should be a sticky. One suggestion - you might like to put a footnote in the payout table to highlight that the figures don't take into account how long it takes for the payout to occur. Eg, 48 hrs for the manor as opposed to 1 hour for the merchant caravan.
    Proud Member of the


    KA - 358177252

    Honora ante Fidem, Fides ante Ego
    (Honour before Loyalty, Loyalty before Self)

    "If you don't stand for something, you'll fall for anything." - Wiseman, Sucker Punch

  12. #12
    Banned
    Member Since
    May 2012
    Location
    Australia
    Post Count
    190
    This is brilliant. Thank you HK!

  13. #13
    Articulate Author Funkey monkey's Avatar
    Member Since
    May 2012
    Location
    Big D
    Post Count
    264
    HK -
    This is great. Thanks for putting this together. I'm not sure the best way to do this suggested table, but I wish there was a way to reference the XP associated with the building level. For example, a level 8 shipyard will give more XP than a silo 10 but the payout is the same.
    IGN:Funkey monkey
    KA: 909164955
    MQ: 970090885
    Taking requests for Allies by PM.


  14. #14
    Verbose Veteran
    Member Since
    May 2012
    Post Count
    529
    Thank you Kitty!



  15. #15
    Master of Musings Hello Kitty's Avatar
    Member Since
    Mar 2012
    Location
    Florida / Texas
    Post Count
    2,637
    You're welcome guys! Glad it was received well.

    I ran out of steam last night and had intended to include payout times to output as well as an IPH chart - both are there now and are sorted by Payout Hours for planning purposes. Also added is a general building info chart that includes unlock level, plot size, and defense values (increases risk of losing units while raiding - unsure how these values play into any calculation).

    @FM - I don't have XP data. Since Raiding produces such little XP versus PvE, I have not been interested in collecting that info. Will be happy to publish a data set if you can provide it to me.
    Last edited by Hello Kitty; 09-16-2012 at 08:00 AM.
    >^..^<

    Game of the Name... (Spreadsheet / Thread)
    MW RankingsKA Spreadsheet - My Kingdom

Posting Permissions

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