Statistics for power and water usage

[Guest]

I've been playing Kapi Regnum on and off for a while, and am keeping a spreadsheet for calculating things like max possible quality and total cost to produce good X, etc. One of the first things I did with it was to create a column to figure out how much water each product took to make if you made it from scratch, as a sort of guide for which ones would be the most annoying, and whether it made any sense to produce the water myself. I've just started playing Kapilands, and did up a similar thing with power and water both. I'm posting it here in the hopes that it will be useful to someone, or that someone with more knowledge of which products are most popular could use it to figure out the relative profitability of power versus water, or something like that.

Code: Select all

Power

308129.08 cars
279644.08 cabriolets
86455     car bodies
69051.04  motorbikes
34872.485 golden watches
32087.98  engines
30811     diamond rings
26270     golden necklaces
19475     silver necklaces
3535.15   beds
3501.715  computers
3126.25   wardrobes
2489.755  televisions 
2342      chairs
1687.3    leather jackets
1677.55   tires
1567.63   monitors
1442.78   printers
1359.9    jeans
1250      wooden toys
1225.87   stuffed toys
1194.55   toys
1020.3    shoes
1010      diamonds
1000      advertisements
859       gold
759       silver
734       leather
685.7     tables
523.48    cpu
502.98    e-components
467       leather gloves
353.3     textiles
310.4     pullovers
284.85    steel
219.9     plastic
124.85    glass
102.4     coffee powder
100       oil
91.89     detergents
78.4      minced meat
77.61     wine
72.385    perfumes
          shampoo
68        cattle
          pigs
58.4      sausages
57        lambs
56.8      beef
55.7      lamb
          animal food
55.1      wood
53.94     lotions
35.3      sugar
25        gas
24.72     candy
23.99     toothpaste
23.585    beer
21        flour
19.9      chemicals
19.25     cocoa powder
18.75     apple juice
          orange juice
17.97     candy bars
16.8      pork
14.9      silicon
14.38     kapi cola
13.045    bottled cocoa
10.7      iron ore
          coal
9.9       minerals
          quartz
6.5       chickens
5.35      bread
5.1       stones
          sugar cane
3.44      chocolate ice cream
          coffee ice cream
2.44      fruit ice cream
2.3       rubber
2.2       biscuits
2.1       grapes
1.6       coffee beans
          cocoa
1.3       wool
1.1       cotton
          corn
          other fruit
1         power
0.65      eggs
0.6       potatoes
0.24      milk
0.1       water
          seeds

Average power usage: 9054.749
3/4 of all products use at least 4.27
1/2 of all products use at least 55.7
1/4 of all products use at least 929.5

Code: Select all

Water

51432.8   cars
46082.8   cabriolets
16050     can bodies
11206.4   motorbikes
5351.8    engines
3610      diamond rings
3601.35   golden watches
2700      golden necklaces
2250      silver necklaces
1287.5    wardrobes
876.5     beds
680       cattle
          pigs
570       lambs
469.1     wine
420       chairs
390.5     tires
373       leather jackets
357       tables
340       leather
203       shoes
170       leather gloves
153       sugar
120       wooden toys
112.35    beer
110       flour
107.2     candy
104       pullovers
101.7     stuffed toys
100       diamonds
99        jeans
92.5      cocoa powder
90        silver
          gold
87.5      apple juice
          orange juice
80.5      toys
79.7      candy bars
68        beef
          pork
67.05     televisions
65        chickens
63.8      kapi cola
57        lamb
          animal food
53.5      steel
51        wood
          sugar cane
45.65     computers
34.4      chocolate ice cream
          coffee ice cream
34        sausages
          minced meat
33.3      monitors
33        textiles
28.5      bread
24.4      fruit ice cream
24        coffee powder
23        rubber
21        grapes
19.8      printers
16        coffee beans
          cocoa
13.5      glass
13        wool
12        biscuits
11.35     perfumes
          shampoo
11        cotton
          corn
          other fruit
9.9       detergents
9         minerals
          quartz
          chemicals
          plastic
          silicon
7         iron ore
          coal
6.95      bottled cocoa
6.5       eggs
6.4       lotions
6         potatoes
2.4       milk
1.9       toothpaste
1.8       e-components
          cpu
1         stones
          seeds
          water
0         power
          oil
          gas
          advertisements

Average water usage: 1490.858
3/4 of all products use at least 11
1/2 of all products use at least 34.4
1/4 of all products use at least 111.175

Stuff I notice:
Although certain types of goods use way more power than any good uses water (300K power versus 51K water for a car), the average water use is higher by about 600, and there are more products in the mid usage range, and few that use very little or no water compared to the number of products that use very little or no power. Since most of the really high power usage is associated with products in the same chain, I'm guessing that the people who consume the most power are the ones specializing in those specific areas, while water is used more generally across the board.

Does anyone make the products at the top of the list from scratch, or nearly from scratch?

(ETA: Now includes jewels factory info. Doh.)

[Guest]

Yup I produce gold>Watches (500 power) costing 34.5k power per watch and use 3.5b of power weekly on this.
Probably fairly small compared to the R1 guys but I dont there there is a more power intensive industry (few poeple can sell enough cars to use huge amounts of power)
I also produce TVs from the ground up so there is 3.3k per unit
H

[Guest]

Ahh, I seem to have forgotten the jewelry store in there.

[Guest]

Exactly what i noticed, and jewelry is one of the biggest power consumers out there. (i mean in total)

otherwise, good job

[Guest]

It's not very conservative with water, either, but it seems there's no beating the car industry in either case.