PDA

View Full Version : Building Lookup Tables by Level



Hello Kitty
09-15-2012, 09:27 PM
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 (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413009&viewfull=1#post413009)
Output (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413010&viewfull=1#post413010)
Upgrade Costs (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413011&viewfull=1#post413011)
Upgrade Times
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413013&viewfull=1#post413013)Income Per Hour (IPH)
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413014&viewfull=1#post413014)General Info (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)[/URL][URL="http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016"]
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)W (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)eighted upgrade ROI in days. (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=636764&viewfull=1#post636764) (by Octofinger)

Hello Kitty
09-15-2012, 09:28 PM
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

Hello Kitty
09-15-2012, 09:28 PM
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

Hello Kitty
09-15-2012, 09:29 PM
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

Hello Kitty
09-15-2012, 09:29 PM
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

Hello Kitty
09-15-2012, 09:30 PM
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

Hello Kitty
09-15-2012, 09:31 PM
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

BadNews
09-15-2012, 10:25 PM
Great! !!!!!

Serboy
09-15-2012, 10:57 PM
Good job !! It has to be sticky

Mantou
09-15-2012, 11:19 PM
Nice layout.
Request for sticky

echus14
09-15-2012, 11:55 PM
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.

Nick-Clark1
09-15-2012, 11:59 PM
This is brilliant. Thank you HK!

Funkey monkey
09-16-2012, 03:23 AM
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.

Hapl0
09-16-2012, 05:40 AM
Thank you Kitty!

Hello Kitty
09-16-2012, 07:49 AM
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.

John Snow
09-16-2012, 01:50 PM
HK - Definitely a sticky! Thanks for putting this together.

Dr. Dengus
09-16-2012, 02:54 PM
Imagine putting those matrices into RREF by hand ... lol. Appreciate the effort HK, very useful stuff.

bgood
09-17-2012, 08:05 AM
This is awesome. This is very useful information and appreciate the effort HK...thanks again

Intrance
09-18-2012, 02:42 PM
Great post! Just one correction tho. I think jewelcraft building output may be wrong. Mine is at lv 3 and output is 2700 or so not the 1138 posted...

Everson25
09-19-2012, 02:20 AM
Great job Hello Kitty! It's really useful information for everyone.

YLL
09-19-2012, 05:26 AM
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).



Nice one. Keep up the good work, HK. :)

EiZ
09-19-2012, 05:30 AM
Awsome raid info! going to get that greens!

mitchitized
09-19-2012, 06:20 AM
Awsome raid info! going to get that greens!

Haha was thinking the exact same thing! Then I can time raids will killing bosses for minimal exposure. Breeding Den upgrades, here I come! ;)

albeezy
09-19-2012, 07:13 AM
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
Nothing makes me more sad than to do an upgrade only to see my IPH jump by less than $100! Nice tables HK

GetItOn
09-19-2012, 07:43 PM
Nothing makes me more sad than to do an upgrade only to see my IPH jump by less than $100! Nice tables HK

I find it interesting that The 12 & 24 hr buildings have a pair that mimics each other in daily gold increase per upgrade.

Lenders/Wine Makers, Inns/Printing Press, Silo/Taverns, LWs/PMs are slightly off.

craigart
09-19-2012, 10:36 PM
Very interesting topic and thanks for great posting.
playground parts (http://www.swingforswingset.com)
:o

Joie
09-20-2012, 04:46 PM
Great post kitty, thanks ! And I also request sticky

Hello Kitty
09-24-2012, 12:40 PM
Not sure how to request a sticky. Er said he's not taking PMs???

Hello Kitty
10-03-2012, 05:21 PM
I sent a note to ER and CCM, no response. Guess y'all will just have to bookmark this as a favorite, if you're still interested...

All the upgrade info is now sorted first by L10 amounts (high to low), then a second filter was applied by payout hours (high to low) for planning purposes. So now you can plan for 24/48 collection, or any other combo for collection frequency.

Upgrade payouts, costs, time, and IPH charts were affected.

Chimera.
10-03-2012, 09:16 PM
Very useful information

tcapi
10-03-2012, 11:44 PM
Excellent work! I did a screen print on the information I need and leave that on my desktop.

LiveHard
11-12-2012, 10:09 AM
Great info to use. Deserves a sticky.

Kaoslos
11-12-2012, 12:28 PM
Great job :-).

I'll put my missing figures it into my excel sheed on the exact same matter ;-).

One matrix i miss is the "extra gold per hour, per hour of upgrade" which will actually make the decision on which building to upgrade very easy if your only after the best stats.

An example: a manor lvl 2 will give you 15K gold extra which gives 312,5 extra gold per hour. But it takes 48 hours to upgrade which will then give you 6,51 extra gold per hour, per hour of upgrade". Upgrading a bakery from lvl 2 to lvl 3 will give you 12 extra gold per hour (2 hours, extra gold 72, extra gold per hour 24) - but in making the decision you should consider that you will not be able to collect from your bakery when on job or asleep. But still looks better on your stats...

You can also calculate that the general development of gold is "base" +50% per lvl of upgrade (a lvl 2 building adds 100% gold - a lvl 3 adds 150% etc.)

Kaoslos
11-12-2012, 01:24 PM
Your timetable is a little off regarding decimals in the beginning. e.g. Silo lvl 2 takes 2,5 hours. Farm Lvl 3 takes 0,75 Hours. I don't have a complete dataset to compare with. I have updated your timetable with my adjustments, If someone will guide me in how to upload a nice looking table to this board I'll share. Also my "income per hour, per hour of upgrade" matrix is finished... thanks a lot :cool:

DragCro
11-14-2012, 02:25 AM
Hello Kitty rules,thanks for your time to make this!! Nice job ;)

Jopoppy
11-15-2012, 06:05 AM
Great Job! And nice pic in your profile!

Intan jabrut
11-19-2012, 03:29 AM
Hi every member..
I'm a newbie
Can someone give me a table if I want to upgrade Breeding Den please ?
thank you

The1nONLY
11-19-2012, 03:32 AM
Hi every member..
I'm a newbie
Can someone give me a table if I want to upgrade Breeding Den please ?
thank youNot only do you need a table but chairs aswel bro

RotoMan
11-19-2012, 04:02 PM
Not only do you need a table but chairs aswel bro

Some tableware and food would be nice too!

kruppe
11-27-2012, 06:58 PM
Thank you for this information and the way it is laid out.
It has been very helpful even to former lurkers
I do admire the effort expended in making these tables and other minutiae public
Kruppe thanks you

Proprioc3ption
11-29-2012, 04:52 PM
Still can't believe this thread hasn't been stickied.
Great work HK!

Update:
lol, and so it's now been stickied!

uashsar
12-04-2012, 02:05 PM
I really appreciate the insight provided by Kitty.
Can someone provide stats on the values of buildings being sold at the various levels.

With hope.

Shinazueli
12-04-2012, 03:31 PM
I really appreciate the insight provided by Kitty.
Can someone provide stats on the values of buildings being sold at the various levels.

With hope.

With the exception of the gem buildings, you get 50% of the (non lumber mill discounted) construction or most recent upgrade cost.

For instance, a level one manor will sell for 125k. A level 2 manor sells for 200k. Etc.

For the gem buildings, you get nothing. Nada. Zilch. Zero. Denata. Even if they're upgraded, still nothing.

Gambit12
12-05-2012, 09:05 AM
This info is awesome HK..! Just wondering how did you figure out all this things..? Did Gree helps you or something, just curious..?

Gru
12-05-2012, 09:17 PM
Great work!

aether100
12-06-2012, 09:36 AM
thank you for the hard work. this is very useful

rockyarora
12-18-2012, 09:59 PM
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

Oh my god..the creation of this table would have taken ages..so just a thanx is not enough to say..just a 90 bow for you...

Shinazueli
12-18-2012, 10:15 PM
This info is awesome HK..! Just wondering how did you figure out all this things..? Did Gree helps you or something, just curious..?

Patterns and equations.
Divide the level one income by 2. That number is x.
Each level can then be calculated easily.

Level 1 = 2x.
Level 2 = 4x. (Previous income + new level X x)
Level 3 = 7x.
Level 4 = 11x.
Level 5 = 16x.
Level 6 = 22x.
Level 7 = 29x.
Level 8 = 37x.
Level 9 = 46x.
Level 10 = 60x. (Note this should be 56x for the pattern but I guess they decided you deserve a bonus for leveling it to 10. Plus it makes the numbers nicer.)

A similar pattern exists for cost of upgrades. Note that the level 10 upgrade cost is always 100X the level1 construction cost.

The upgrade times do not follow any pattern that I can see, but they're easily reported and recorded by fellow forumites.

Patterns and equations. They are all around you, just look.

Shinazueli
12-18-2012, 10:22 PM
Oh my god..the creation of this table would have taken ages..so just a thanx is not enough to say..just a 90 bow for you...

While giving HK all credit for pretty color codes that must have sucked to put into this format, another equation some might find handy is this one:

First (and second) raid strike = 15% of building payout.
Third raid strike = 30% of building payout.
Total = 60% of building payout.

Practically, this means that you need to stick to 24+ hour buildings above a certain level in order for your income to be worth the time. Silos, lenders, gold mines, manors. My cutoff is 10k for three stamina. This means no silos, l5 gold mines, l6 lenders, l7 playhouses, l2 manors. Nobody has high enough wine makers or inns so I don't even look.

A neat trick I realized during the pvp event. Raid rival, open profile. <8k income, move on. Saves me time looking for buildings, or overvault gold.

AndrewH
01-15-2013, 03:42 PM
I found the tables earlier in the thread very interesting, but one thing which I thought was missing was an indicator on which upgrades offered better "Value for Money"

What I mean is - let's say you upgrade your Trading Post from Level 1 to Level 2. The upgrade is going to cost you 25,000 gold, and the amount of gold you'll now get goes from 190 to 380 (an increase of 190 gold). You'd need to collect from the Trading Post 132 times to make back the cost to upgrade (190 x 132 = 25,080).

Or another example - You upgrade your Tavern from Level 7 to Level 8. That'll cost 22,000 gold, and the amount of gold you collect will go from 2,393 to 3,053 (an increase of 660). So, after collecting from the Level 8 Tavern 34 times you've made back the cost (660 x 34 = 22,440).

So, here's a table showing that - hopefully someone will find it useful :



Building

Payout
Hours
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10


Manor
48
17
28
32
39
52
73
103
150
223
239


Playhouse
48
7
11
13
15
21
28
40
59
87
94


Gold Mine*
24

20
23
28
38
52
75
109
159
172


Lender
24
25
42
47
58
78
109
158
225
334
358


Inn
24
15
25
28
35
46
65
91
134
198
212


Leatherworker
24
5
9
10
12
16
22
31
45
67
70


Silo
24
1
2
2
2
3
3
5
7
10
10


Castle
24
0
3
3
3
4
6
8
12
17
18


Shipyard
18
13
22
24
30
40
56
80
118
176
186


Jewelcrafter*
18

93
103
130
173
236
343
500
719
792


Stable
18
5
8
9
12
16
21
30
44
66
69


Wine Maker*
12

30
34
42
56
77
112
163
245
258


Printing Press
12
35
58
64
80
107
148
213
311
461
490


Pottery Maker
12
15
24
27
34
45
62
90
130
192
209


Tavern
12
4
7
7
9
12
16
23
34
49
52


Butcher Shop
8
32
53
58
74
99
137
196
283
427
452


Library
8
8
14
15
19
25
35
51
72
107
115


Trading Post
6
79
132
148
185
243
343
489
711
1,053
1,128


Fish Market
6
33
54
62
77
102
142
200
289
428
468


Tailor
6
5
8
9
11
14
20
28
41
60
65


Brothel
3
170
285
313
393
524
731
1,044
1,539
2,223
2,418


Apothecary*
3

167
184
230
310
417
596
896
1,334
1,429


Cartographer
3
45
74
83
103
136
192
274
405
589
631


Bakery
3
3
5
5
6
8
11
16
23
34
36


Merchant Caravan
1
72
120
134
165
224
314
443
650
967
1,036


Bazaar
1
3
5
6
7
10
13
19
27
41
44


Farm
0.5
4
7
7
9
12
17
24
35
50
55


Cottage
0.08
10
17
17
24
34
44
60
91
139
143

uashsar
01-16-2013, 09:12 AM
I used the ROI a lot in my prioritization of upgrades when I had low IPH.
A minor detail (?): In the calculations in the table above you haven't taken the missing income while upgrading into consideration.

Bwdavis4
01-26-2013, 06:15 AM
Thanks for the great information. Do you have any other charts for the support and troop buildings? Or is there information elsewhere for the time and cost to build them?
Thanks!

Cru Jones
02-08-2013, 11:20 AM
This is great! Thanks for taking the time to do this!

Pepete1961
02-09-2013, 11:33 AM
Hi! Has anyone figured out how much you get for selling various buildings at different levels?
Thanks!

RandomUser
02-09-2013, 01:07 PM
You get half what the last build/upgrade cost is.

So if your last upgrade cost 10,000 gold, you'd get 5,000 back for selling it. Note that the amount isn't affected by your lumber mill. If the upgrade usually costs 10,000 and you only paid 9,000, you'd still receive 5,000 gold for selling.

Spydrax
02-19-2013, 08:30 PM
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 (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413009&viewfull=1#post413009)
Output (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413010&viewfull=1#post413010)
Upgrade Costs (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413011&viewfull=1#post413011)
Upgrade Times
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413013&viewfull=1#post413013)Income Per Hour (IPH)
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413014&viewfull=1#post413014)General Info (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)


I appreciate you taking your time to develop these charts Hello Kitty! I use them often in generating my upgrade progressions for the week.

dbailey30
02-20-2013, 09:11 AM
Thanks so much for putting this information together, it is really beneficial.

Campers Uninon
02-20-2013, 10:45 AM
Thanks for the info ! Very helpful ! :)

JBearden13
03-03-2013, 08:21 AM
Thanks for posting this!

Jean marc
03-03-2013, 08:25 AM
Thank you, appreciate all you have done.

TempusDA
03-03-2013, 06:21 PM
Thank you for your hard work Kitty.

Your charts have helped many people me included. :)

Octofinger
03-11-2013, 05:32 AM
Thank you Kitty for an excellent summary.

I've used your data together to make a real world ROI table. It doesn't only count how many times you need to harvest, but also how long the payout time is. This in addition has been weighted with an estimate on how many times per day you can actually harvest. This means that the Cottage which is ripe every five minutes and ideally gives high IPH and short ROI still takes quite a while because you cannot be there to harvest every five minutes 24/7. When talking ROI, I've only considered the increase in payouts to pay for an upgrade, because this is what actually counts.

This lists a weighted ROI in days for each building and upgrade:


Building
Payout
Hours
Harvests/
Day
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10


Manor
48
0.5
30
57
64
79
106
147
209
304
449
481


Playhouse
48
0,5
13
22
25
31
42
58
83
120
177
190


Gold Mine*
24
1
-
20
23
28
38
52
75
109
159
172


Lender
24
1
25
43
48
59
80
111
160
229
338
362


Inn
24
1
15
25
29
36
47
66
94
136
201
215


Leatherworker
24
1
5
8
9
12
16
22
32
46
69
72


Silo
24
1
0.7
1.2
1.3
1.9
2.8
4.2
5.8
8.1
11.3
12


Castle
24
1
0
2.1
2.4
3.2
4.4
6
8.5
12.2
18
19.1


Shipyard
18
1.1
12
21
23
29
38
53
75
110
163
173


Jewelcrafter
18
1.1
-
84
94
118
157
215
313
455
654
721


Stable
18
1.1
4.4
7.3
8.4
11
15
20
28
42
61
65


Wine Maker*
12
2
-
15
17
22
29
40
58
84
125
131


Printing Press
12
2
17
29
33
41
55
76
109
158
234
249


Pottery Maker
12
2
7.2
12
14
18
24
32
46
67
98
107


Tavern
12
2
1.8
3.1
3.5
4.7
6.4
8.8
12
18
26
28


Butcher Shop
8
2
16
27
30
39
52
71
101
145
218
230


Library
8
2
4
6.9
7.7
10
14
19
27
38
56
60


Trading Post
6
2.1
38
64
72
91
119
167
238
344
508
544


Fish Market
6
2.1
15
26
30
39
51
70
100
142
208
228


Tailor
6
2.1
2.1
3.6
4.2
5.6
7.9
11
15
22
31
34


Brothel
3
5
34
58
65
81
108
150
214
313
451
490


Apotecary*
3
5
-
33
37
46
63
84
120
180
268
287


Cartographer
3
5
8.8
15
17
22
29
41
57
84
121
130


Bakery
3
5
0.5
.09
1
1.5
2.4
3.2
4.4
6.1
8.5
9.1


Merchant Caravan
1
8
9
17
20
24
33
45
62
89
130
139


Bazaar
1
8
0.4
0.7
0.8
1.4
2.6
3.4
4.6
6.1
8.3
8.9


Farm
0.5
12
0.3
0.5
0.7
1.2
2.4
3.3
4.5
6
8
8.6


Cottage
0.08
15
0.7
1.2
1.3
3.11
7.3
9.9
13
17
23
24






Legend:
Green numbers: ROI with less than 20 days.
Black numbers: ROI between 20 to 60 days.
Yellow numbers: ROI between 60 to 180 days.
Red numbers: ROI more than 180 days.

This is a pretty useful table when you decide what to invest in next unless you only care about IPH. I care for ROI because I want my gold to make use for me.

I've also attached the Excel workbook where anyone can enter their own upgrade or build bonues and edit their expected harvest frequency in order to get more individually accurate numbers.

For example, a Silo returns your L10 upgrade investment in 12 days, but a Jewelcrafter L10 upgrade will take over two years to return the upgrade cost.

I hope you can find this useful. Again, thanks to Kitty for making the data available.

uashsar
03-12-2013, 12:52 PM
Thank you Kitty for an excellent summary.

I've used your data together to make a real world ROI table. ...

Thanks to Kitty and Octofinger.
Octofinger's table clearly illustrate that for many of the upgrades it is not a traditional business case matter, but merely a trophy matter - at least for us players looking less that one year ahead.

Tarsus
03-14-2013, 08:51 AM
Thanks for this effort!

arober11
03-15-2013, 10:13 AM
Has anyone complied a table of the sale values, for each building level?

Ripe melon
03-18-2013, 05:39 AM
Has anyone complied a table of the sale values, for each building level? Why would you want to sell buildings? Selling is a waste of money and lost income.

MistaMasta
03-19-2013, 03:21 PM
Kingdom Slayers ( 727-429-497 ) Welcomes You,

No Minimum Requirements, No Considerations. Donate whatever you can miss, We dont even have to take this **** serius, Cause we will win anyways. Just relax and kick ass, no peepz can F with Us!

You may join, low levels, high levels, free players, gem players etc etc

Dont take our kindness for our weakness

Guild stats:
Members: 4
Walls: 3, upgraded to level 5
Health: 30000

Founder stats:
Level: 79
Health: 880
Attack: 53000+
Defense: 55000+
Allies: 390 - (984-977-147)
Income: 2700 an hour
Allies: 395
Units: 1185

Anybody level 1 to all, Yr Welcome,

Kingdom Slayers - 727-429-497

Greets MistaMista aka JohnnBlade

Hello Kitty
03-22-2013, 10:36 AM
Hey forum peeps! How's everything? It's been forever since I've posted. Lurk constantly and just doing a drive-by now. Thanks all for the in-game comments too, glad that this info helps new players. I added Octofinger's ROI to the OP. Nice work!

The LTQs are crazy...just building stats. Thanks for all the contributors on those threads.

Good luck everyone in the guild wars!

Best wishes, HK

larshenriksen68
03-24-2013, 04:04 PM
Hi Hello Kitty.

First of all, thank you for the tables you have put together so far, I use them all the time!

However, my high payout buildings have been upgraded more or less to the extend where I can't manage to save up enough money for further upgrade before being raided.

That made e think that the only way from here is to sell a building (like a level 8 playhouse) to raise enough money for an upgrade. Yes, then I have to buy the playhouse once again and upgrade it all the way up, but that seams to be my only option, even my lumber mill and Guild upgrades are maxed out.

So what I would like to have is a table which line out what is the pay-back amount for the different buildings at all 10 levels?

There must be quite a few players out there having this problem, so I believe such a table could come very handy!

Thank you!

sdrawkcabnipyt
03-24-2013, 04:27 PM
^ what he said

GreenGuru
03-24-2013, 10:15 PM
Hi Hello Kitty.

First of all, thank you for the tables you have put together so far, I use them all the time!

However, my high payout buildings have been upgraded more or less to the extend where I can't manage to save up enough money for further upgrade before being raided.

That made e think that the only way from here is to sell a building (like a level 8 playhouse) to raise enough money for an upgrade. Yes, then I have to buy the playhouse once again and upgrade it all the way up, but that seams to be my only option, even my lumber mill and Guild upgrades are maxed out.

So what I would like to have is a table which line out what is the pay-back amount for the different buildings at all 10 levels?

There must be quite a few players out there having this problem, so I believe such a table could come very handy!

Thank you!

Look at the cost for each upgrade, divide by two.

I'd do it myself and post it here but I'm short on time now

Eliysiam
03-26-2013, 08:09 AM
Great thread and thanks to everyone who contributed!

Shinazueli
03-26-2013, 08:14 AM
Add up the cost of each upgrade you have so far, divide by two.

I'd do it myself and post it here but I'm short on time now

I'm sorry, but this is incorrect. It's only the most recent upgrade cost, so whatever the price was for the level 8 upgrade * 0.5.

GreenGuru
03-26-2013, 04:17 PM
I'm sorry, but this is incorrect. It's only the most recent upgrade cost, so whatever the price was for the level 8 upgrade * 0.5.

Guess I didn't say it right, I changed it to something more simple then

Eliysiam
03-26-2013, 07:33 PM
Thanks a lot Hello Kitty and OctoFinger.

Just a general question, what does ROI stand for?

JoKeRjr
03-26-2013, 07:42 PM
Thanks a lot Hello Kitty and OctoFinger.

Just a general question, what does ROI stand for?
Return on investment.

Shinazueli
03-26-2013, 07:50 PM
Clarify : ROI means "how long (or how many collections) will it take for this building upgrade to pay for itself?"

For example, the level two manor upgrade, which costs 420k, will take 28 collections, or 56 days, to recoup the cost of the upgrade.

Eliysiam
03-29-2013, 09:52 PM
Thanks to all who replied!

Lots of great info here.
I see lots of spreadsheets with raid payout, upgrades etc.
Just wondering if there is one such breakdown for vault upgrade. I know the max is around 330K but wanted to know howmany levels of upgrade there are and how much they cost.

uashsar
03-30-2013, 05:48 AM
Thanks to all who replied!

Lots of great info here.
I see lots of spreadsheets with raid payout, upgrades etc.
Just wondering if there is one such breakdown for vault upgrade. I know the max is around 330K but wanted to know howmany levels of upgrade there are and how much they cost.

See the FAQ thread - first page has a list of spreadsheets. On one of them you find the vault levels -> https://docs.google.com/spreadsheet/lv?key=0Aj9pi1nr5A99dFF0UWZKZWxzSGVyZkh5ekhnUnh0el E&f=true&noheader=false&gid=10

Desert fox
03-31-2013, 03:50 PM
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 (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413009&viewfull=1#post413009)
Output (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413010&viewfull=1#post413010)
Upgrade Costs (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413011&viewfull=1#post413011)
Upgrade Times
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413013&viewfull=1#post413013)Income Per Hour (IPH)
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413014&viewfull=1#post413014)General Info (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)W (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)eighted upgrade ROI in days. (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=636764&viewfull=1#post636764) (by Octofinger)
does anyone have a loot item location for kingdom age

Frogman
04-06-2013, 12:09 AM
This is very helpful, thank you for making this.

paul2013
04-06-2013, 12:25 AM
nice work, the table can help me a lot

moomrik
04-10-2013, 07:07 AM
Just what I was looking for. Thanks so much.

Mr t
04-17-2013, 02:34 AM
saw this info and printed it imediatly.
Ty

Bombur
04-23-2013, 11:22 AM
Great job! Very useful.

Hun
04-26-2013, 01:18 AM
is there a table like this for the unit buildings? I'd like to know the upgrade costs for those but can't find it anywhere.

KillerVirus666
04-26-2013, 07:27 AM
I think they should add Opium Den as a building, i think it would go right beside the brothel in my town

ShutterBlink
05-01-2013, 10:11 PM
Thanks for the great info

Rawrimabear
05-30-2013, 09:53 PM
I can't believe nobody has pointed this out, but the numbers for the Jewelcrafter are way off. If you look at a level 1 Jewelcrafter in the shop (if you haven't bought one) it shows a payout of 775 but the chart here shows it as 325. I also just raided a level 6 Jewelcrafter and got a total of 5100 gold from it (1275 x 2 and 2550) but the chart here says I should have only gotten 2145 for it. It seems like the Jewelcrafter is actually worth about 2.38 times as much as the charts would imply. I don't have one so I can't say if the upgrade costs and times are accurate.

This puts the Jewelcrafter between the Winemaker and the Inn for raid purposes.

The other gem buildings look accurate. It's just the Jewelcrafter that's wrong.

Gardon
06-01-2013, 05:14 PM
I want to try a different take on determining which money buildings to upgrade. I want to factor in bonuses but can't figure out how Gree is calculating the adjusted cost. It seems like the formula factoring in guild bonuses is probably: cost = (base cost)*(0.95)^(upgrade level). Does anyone know how to factor in lumber mill bonus? I tried adding th following terms *(0.99)^(lumber level) or *(1-decimal of lumber level). Neither worked perfectly. Am I missing a term? Can anyone help?

Octofinger
07-10-2013, 02:06 AM
Gardon, the bonuses are multiplicative as you've guessed.
Cost=(base cost)*0.95^(upgrade level)*(1-(lumber mill level/100))
or
Cost=(base cost)*(1- cost bonus)*(1- mill bonus)

uashsar
07-10-2013, 05:00 AM
Isn't it
Cost=(base cost)*0.95^(upgrade level)*(1-(lumber mill level / 100)) ?
as each Lumber Mill level only give 1% reduction.

Octofinger
07-11-2013, 04:40 AM
Oh. You're absolutely right. I actually looked at the wrong building when I checked. :o
And I missed to divide by 100 as well.

Thank you.
I've updated my post.

Kronous
08-01-2013, 06:34 AM
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 (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413009&viewfull=1#post413009)
Output (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413010&viewfull=1#post413010)
Upgrade Costs (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413011&viewfull=1#post413011)
Upgrade Times
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413013&viewfull=1#post413013)Income Per Hour (IPH)
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413014&viewfull=1#post413014)General Info (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)[/URL][URL="http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016"]
(http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)W (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=413016&viewfull=1#post413016)eighted upgrade ROI in days. (http://www.funzio.com/forum/showthread.php?39662-Building-Lookup-Tables-by-Level&p=636764&viewfull=1#post636764) (by Octofinger)

Thankyou for putting the time and energy into this and sharing. Great work

Ysulliva
08-03-2013, 10:24 PM
Great info! Tanks!

gubbel
08-07-2013, 02:15 PM
great work!!

does anyone know if there are tables for mw too? and where to find them if so?

Officer Overlord
08-16-2013, 08:33 PM
good job putting all that together

Officer Overlord
08-16-2013, 08:35 PM
gree should have an building that gives gems

horse
08-17-2013, 06:25 PM
What about defense values and range for defense buildings?

charlieka
08-19-2013, 06:54 PM
really useful thread! thanks for the info!

captainpony
08-29-2013, 11:49 AM
Can someone with incredible excel powers update the list to reflect the true values of the Jewelcrafter?
As mentioned before, the payouts are far higher than recorded here.
Many thanks to anyone who can post a list of actual payouts of the Jewelcrafter, both raid and collected gain.

Zokudo
09-22-2013, 05:54 PM
Wow great work just to let you know your effort is appreciated

_Mas_
10-23-2013, 01:01 PM
great! thanks!!:D:D:D

uashsar
11-06-2013, 01:28 AM
Anybody having stats for the new building?

UpOnOne
12-03-2013, 07:07 PM
Very interesting

Raistlin (ESq)
03-07-2014, 06:46 PM
What about defense values and range for defense buildings?

Try here https://docs.google.com/spreadsheet/ccc?key=0Aj9pi1nr5A99dFF0UWZKZWxzSGVyZkh5ekhnUnh0e lE#gid=3

DanielLP04
06-15-2014, 07:56 AM
Thank you the tables were extremely helpful and informative.