ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Captain of Industry — Trade vs. Self-Production Calculator
2
3
HOW THIS WORKBOOK WORKS
4
It explodes your multi-level recipe chain down to raw materials, then compares how much of
5
each raw material your own factories would consume against what a real trade contract hands
6
you back — since Captain of Industry contracts are barter (give X of item A, get Y of item B),
7
each contract can trade a totally different finished good for a totally different raw material.
8
9
FILL IN THESE 3 SHEETS (yellow = your input):
10
1. Items - list every item: raw materials, intermediates, final goods. One per row.
11
2. Recipes - one row per INGREDIENT of a recipe: output item, output qty per run, input
12
 item, input qty per run. Multi-ingredient recipe = multiple rows.
13
3. Contracts - one row per real trade contract, exactly as the game shows it:
14
 Give Item + Give Qty (the finished good and how much you hand over),
15
 Get Item + Get Qty (the raw material and how much you receive).
16
 e.g. "93 Servers for 8400 Iron ore" -> Give=Server/93, Get=Iron ore/8400.
17
 Up to 12 contracts supported. The last 3 columns compute automatically:
18
 how much of that raw material your own factories would need to make Give
19
 Qty of Give Item, the Net Gain/(Loss), and % vs. self-production. Green =
20
 the contract nets you more raw material than self-production would use.
21
22
Summary sheet is a separate, simpler tool: pick any Target Item + Qty and see the full raw
23
material breakdown for it — useful for general planning, independent of any contract.
24
25
DATA CLEANUP APPLIED TO YOUR ORIGINAL UPLOAD (double check these)
26
- Trimmed stray spaces on items like "Sand ", "Bauxite ", "Steel plate ", "graphite " etc.
27
- Fixed "Copmposite Panel" typo to "Composite Panel"; fixed double space in
28
 "Construction Parts III/IV".
29
- Vehicle Parts I's "Electronics" input (no tier number) was assumed to mean Electronics I.
30
- "Iron plate" (was an input to Server with no recipe) was corrected to "Steel plate" per
31
 your confirmation — Server now correctly traces down through Steel Plate -> Molten Steel ->
32
 Molten Iron -> Iron Ore + Limestone.
33
34
LIMITS OF THIS TEMPLATE
35
- Assumes ONE recipe per output item. Edit that item's rows in Recipes for alternate recipes.
36
- Supports up to 110 unique items, 220 recipe input-lines, and 12 simultaneous contracts.
37
- Byproducts (a recipe outputting 2+ items) aren't modeled — treat the main output only.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100