Trade Minister's reports

I haven't as yet the spreasheets that Saj built his very pretty reports with, so all I have to offer today is a bald report of the county's inventory ...

Inventory of the County goods:

105 bread loaves Put on sale
80 fruits Put on sale
2407 bags of corn Put on sale
31 bottles of milk Put on sale
84 fishes Put on sale
207 pieces of meat Put on sale
391 wheat bags Put on sale
90 flour bags Put on sale
2 hundredweights of cow Put on sale
2058 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
328 wood bushels Put on sale
2 shafts Put on sale
1334 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Inventory of the County goods:

5 bread loaves Put on sale
30 fruits Put on sale
2257 bags of corn Put on sale
31 bottles of milk Put on sale
98 fishes Put on sale
162 pieces of meat Put on sale
311 wheat bags Put on sale
66 flour bags Put on sale
2 hundredweights of cow Put on sale
2037 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
228 wood bushels Put on sale
2 shafts Put on sale
3274 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Inventory of the County goods:

5 bread loaves Put on sale
30 fruits Put on sale
2448 bags of corn Put on sale
31 bottles of milk Put on sale
73 fishes Put on sale
154 pieces of meat Put on sale
366 wheat bags Put on sale
66 flour bags Put on sale
2 hundredweights of cow Put on sale
1774 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
128 wood bushels Put on sale
2 shafts Put on sale
3047 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Inventory of the County goods:

5 bread loaves Put on sale
30 fruits Put on sale
2398 bags of corn Put on sale
31 bottles of milk Put on sale
73 fishes Put on sale
139 pieces of meat Put on sale
363 wheat bags Put on sale
66 flour bags Put on sale
2 hundredweights of cow Put on sale
1822 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
128 wood bushels Put on sale
2 shafts Put on sale
3039 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Inventory of the County goods:

5 bread loaves Put on sale
30 fruits Put on sale
2348 bags of corn Put on sale
31 bottles of milk Put on sale
73 fishes Put on sale
158 pieces of meat Put on sale
419 wheat bags Put on sale
66 flour bags Put on sale
2 hundredweights of cow Put on sale
1477 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
128 wood bushels Put on sale
2 shafts Put on sale
2715 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale


I'm working on building some tools, so I have more information readily available from now on.

Treasury: 54738.02
Inventory*: 99554.30
Grants*: 4241.80

Net Worth: 158,534.12

*Based on valuations of goods at my best guess at purchase price, eg: Iron@18.00, stone@14.50, corn@3.50 ...

Inventory of the county goods:

5 bread loaves
30 fruits
2298 bags of corn
31 bottles of milk
73 fishes
161 pieces of meat
368 wheat bags
66 flour bags
2 hundredweights of cow
1564 tons of stone
206 half-hundredweights of pig
492 balls of wool
428 wood bushels
2 shafts
2727 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 57552.52
Inventory*: 101411.8
Grants*: 4193.8

Net Worth: 163158.12

Net change from prior day: 4624 pounds

notes: Purchased 180 wood from Bath and 120 from Chard, 7 wheat from an unknown person, and a sword for an SAS grantee. The increases in iron and stone result from the free maintenance on the upgraded mine.

Inventory of the County goods:

5 bread loaves Put on sale
30 fruits Put on sale
2173 bags of corn Put on sale
31 bottles of milk Put on sale
73 fishes Put on sale
180 pieces of meat Put on sale
260 wheat bags Put on sale
66 flour bags Put on sale
2 hundredweights of cow Put on sale
1572 tons of stone Put on sale
206 half-hundredweights of pig Put on sale
492 balls of wool Put on sale
428 wood bushels Put on sale
2 shafts Put on sale
2681 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Treasury: 62432.02
Inventory*: 99183.80
Grants*: 4193.8

Net Worth: 165809.62

Net change from prior day: 2651.5 pounds

note: purchased 25 pieces of meat from BW

Inventory of the County goods:

5 bread loaves
30 fruits
2198 bags of corn
31 bottles of milk
73 fishes
286 pieces of meat
189 wheat bags
66 flour bags
2 hundredweights of cow
1575 tons of stone
206 half-hundredweights of pig
492 balls of wool
428 wood bushels
2 shafts
2640 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 65804.32
Inventory*: 99592.90
Grants*: 4300

Net Worth: 169627.22

Net change from prior day: 3321.4 pounds

Restatement of yesterday's numbers:
Grants should have been 4690
Net Worth should have been 166305.82
Net Change from the 4th to the 5th should have been 3147.7

I forgot to include a grant in my summary, and found the mistake today.

Inventory of the County goods:

5 bread loaves
30 fruits
2073 bags of corn
31 bottles of milk
73 fishes
286 pieces of meat
161 wheat bags
66 flour bags
2 hundredweights of cow
1574 tons of stone
156 half-hundredweights of pig
592 balls of wool
328 wood bushels
2 shafts
2606 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 70111.92
Inventory: 98127.1
Grants: 4193.8

Net Worth: 172432.82

Net change from prior day: 2805.6 pounds

Notes: Purchased 52 bags of wheat (BW and GC) and 100 wool (GC). GC sold 10 buckets to BW through the TM office and the county fair as well.

Inventory of the County goods:

5 bread loaves
30 fruits
2023 bags of corn
31 bottles of milk
73 fishes
284 pieces of meat
276 wheat bags
66 flour bags
2 hundredweights of cow
1571 tons of stone
156 half-hundredweights of pig
592 balls of wool
328 wood bushels
2 shafts
2580 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 72840.52
Inventory: 98911.70
Grants: 4225.80

Net Worth: 175978.02

Net change from prior day: 3545.20 pounds

Notes: Purchased 116 wheat from Bath and 46 from BW

Inventory of the County goods:

58 bread loaves
74 fruits
1971 bags of corn
31 bottles of milk
73 fishes
279 pieces of meat
222 wheat bags
32 flour bags
2 hundredweights of cow
1379 tons of stone
156 half-hundredweights of pig
592 balls of wool
328 wood bushels
2 shafts
2432 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 78101.52
Inventory: 92784.30
Grants: 3197.50

Net Worth: 174083.32

Net change from prior day: -1894.70 pounds

notes: The loss is attributable to the cost of the stone and iron used in upgrading the BW/Chard stone mine.

Inventory of the County goods:

58 bread loaves
74 fruits
1921 bags of corn
31 bottles of milk
73 fishes
279 pieces of meat
279 wheat bags
32 flour bags
2 hundredweights of cow
1399 tons of stone
156 half-hundredweights of pig
542 balls of wool
478 wood bushels
2 shafts
2435 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 68643.14
Inventory: 93685.00
Grants: 2950.30

Net Worth: 165278.44

Net change from prior day: -8804.88 pounds

notes: bought 150 wood, 94 wheat. sold 50 wool.

For week of June 4 through June 10:

Treasury: + 13905.12
Inventory: -5869.30
Grants: -1291.50
Net worth : +6744.32

Inventory of the County goods:

114 bread loaves
44 fruits
1846 bags of corn
51 fishes
267 pieces of meat
263 wheat bags
21 flour bags
2 hundredweights of cow
1379 tons of stone
116 half-hundredweights of pig
542 balls of wool
331 wood bushels
2 shafts
2382 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 74803.94
Inventory: 89720.80
Grants: 2771.70

Net Worth: 167296.44

Net change from prior day: 2032.80 pounds

notes: bought 9 wheat

Inventory of the County goods:

114 bread loaves
44 fruits
927 bags of corn
51 fishes
267 pieces of meat
232 wheat bags
21 flour bags
2 hundredweights of cow
966 tons of stone
214 half-hundredweights of pig
542 balls of wool
331 wood bushels
2 shafts
1299 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 66369.24
Inventory: 71603.6
Grants: 29882.70

Net Worth: 167855.54

Net change from prior day: 559.10 pounds

notes: Upgrading the iron mine was an unexpected drain. We also bought 244 corn, 70 wheat, and 98 HHW. Grants are so high because of the trading activity documented in the Private Chambers.

Inventory of the County goods:

114 bread loaves
44 fruits
899 bags of corn
51 fishes
227 pieces of meat
229 wheat bags
21 flour bags
2 hundredweights of cow
1137 tons of stone
214 half-hundredweights of pig
542 balls of wool
333 wood bushels
2 shafts
1380 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 70004.24
Inventory: 76722.50
Grants: 30202.70

Net Worth: 176929.44

Net change from prior day: 9073.90 pounds

notes: bought 60 corn and 61 wheat

Inventory of the County goods:

114 bread loaves
44 fruits
874 bags of corn
51 fishes
212 pieces of meat
191 wheat bags
21 flour bags
2 hundredweights of cow
1168 tons of stone
214 half-hundredweights of pig
542 balls of wool
333 wood bushels
2 shafts
1368 iron ore ounces
1 unhooped bucket
1 shoes

I found an error that crept into my spreadsheet several days ago. It was related to granting out all the bottles of milk - the formula i copied saw a blank cell and for some reason, changed everything under that cell, so the inventory numbers have been wrong. To make it easier to restate the last three days, I did a screenie of the corrected spreadsheet.



The columns are for 12, 13 and 14 June; 12 June was the first day affected by the error, and 14 June is, of course, the date of this report

Inventory of the County goods:

114 bread loaves
44 fruits
849 bags of corn
51 fishes
212 pieces of meat
165 wheat bags
21 flour bags
2 hundredweights of cow
1150 tons of stone
214 half-hundredweights of pig
542 balls of wool
333 wood bushels
2 shafts
2064 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 78609.04
Inventory: 81712.70
Grants: 16431.70

Net Worth: 176753.44

Net change from prior day: 7247.50 pounds

notes: bought 75 corn

Inventory of the County goods:

114 bread loaves
44 fruits
978 bags of corn
51 fishes
207 pieces of meat
207 wheat bags
21 flour bags
2 hundredweights of cow
997 tons of stone
214 half-hundredweights of pig
542 balls of wool
333 wood bushels
2 shafts
1911 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 822309.34
Inventory: 72397.00
Grants: 16431.70

Net Worth: 171038.04

Net change from prior day: -459.00 pounds

notes: Purchased 129 corn and 60 wheat

Inventory of the County goods:

114 bread loaves
44 fruits
1180 bags of corn
51 fishes
204 pieces of meat
119 wheat bags
21 flour bags
2 hundredweights of cow
1035 tons of stone
184 half-hundredweights of pig
542 balls of wool
233 wood bushels
2 shafts
1889 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 74674.70
Inventory: 71198.10
Grants: 16447.70

Net Worth: 162320.50

Net change from prior day: -8717.54 pounds

notes: bought 300 corn

For week of June 11 through June 17:

Treasury: + 6031.56
Inventory: - 22472.10
Grants: + 13497.40
Net worth : - 2943.14

Inventory of the County goods:

114 bread loaves Put on sale
44 fruits Put on sale
1330 bags of corn Put on sale
51 fishes Put on sale
189 pieces of meat Put on sale
90 wheat bags Put on sale
21 flour bags Put on sale
2 hundredweights of cow Put on sale
1043 tons of stone Put on sale
184 half-hundredweights of pig Put on sale
542 balls of wool Put on sale
236 wood bushels Put on sale
2 shafts Put on sale
1840 iron ore ounces Put on sale
1 unhooped bucket Put on sale
1 shoes Put on sale

Treasury: 76443.14
Inventory: 70323.40
Grants: 16396.70

Net Worth: 163406.24

Net change from prior day: 1085.74 pounds

notes: bought 300 corn, 98 wheat, and paid 3 weeks of miners lottery costs to Chard.

Inventory of the County goods:

114 bread loaves
44 fruits
1280 bags of corn
51 fishes
169 pieces of meat
118 wheat bags
21 flour bags
2 hundredweights of cow
1059 tons of stone
184 half-hundredweights of pig
542 balls of wool
236 wood bushels
2 shafts
1822 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 80038.24
Inventory: 70069.20
Grants: 16399.70

Net Worth: 166507.24

Net change from prior day: 3100.90 pounds

notes: bought 49 wheat, sold 20 meat

Inventory of the County goods:

114 bread loaves
44 fruits
1766 bags of corn
51 fishes
159 pieces of meat
160 wheat bags
21 flour bags
2 hundredweights of cow
1788 tons of stone
184 half-hundredweights of pig
542 balls of wool
238 wood bushels
2 shafts
1772 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 84517.64
Inventory: 81821.70
Grants: 2739.70

Net Worth: 169079.04

Net change from prior day: 2571.90 pounds

notes: bought 91 wheat, 586 corn, and 2 wood, the latter in the course of paying Bath for 2 weeks of miner's lottery. The jump in stone since yesterday is, of course, due to the successful completion of the trade with Worcester.

Inventory of the County goods:

114 bread loaves
44 fruits
2061 bags of corn
51 fishes
159 pieces of meat
138 wheat bags
21 flour bags
2 hundredweights of cow
1637 tons of stone
184 half-hundredweights of pig
492 balls of wool
238 wood bushels
2 shafts
1610 iron ore ounces Put on sale
1 unhooped bucket
1 shoes

Treasury: 88643.04
Inventory: 76860.50
Grants: 2739.70

Net Worth: 168243.24

Net change from prior day: -835.80 pounds

notes: bought 41 wheat and 370 corn

Inventory of the County goods:

114 bread loaves
44 fruits
2086 bags of corn
51 fishes
147 pieces of meat
115 wheat bags
21 flour bags
2 hundredweights of cow
1680 tons of stone
184 half-hundredweights of pig
492 balls of wool
242 wood bushels
2 shafts
1547 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 94101.84
Inventory: 75939.40
Grants: 2739.70

Net Worth: 172780.94

Net change from prior day: 4537.70 pounds

notes: bought 100 corn and 38 wheat

Inventory of the County goods:

114 bread loaves
44 fruits
2061 bags of corn
16 bottles of milk
65 fishes
170 pieces of meat
85 wheat bags
21 flour bags
2 hundredweights of cow
1674 tons of stone
184 half-hundredweights of pig
492 balls of wool
242 wood bushels
2 shafts
1495 iron ore ounces
1 unhooped bucket
1 shoes

Treasury: 99920.29
Inventory: 75259.40
Grants: 390.00

Net Worth: 175569.69

Net change from prior day: 2788.75 pounds