| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Booster Production | Version: Tiamat v1.11 | ||||
2 | ||||||
3 | ||||||
4 | To make your own usable copy, click File→Make a Copy. | |||||
5 | When I publish updates, you will receive an email notification. | |||||
6 | Only edit the blue cells. | |||||
7 | Market Data is imported automatically at 1 hour intervals AND each time you open the spreadsheet. | |||||
8 | Click the "Force Refresh" button to force the data to refresh itself. Wait until message at top says "finished" | |||||
9 | Refresh button is located on Market Comparison tab | |||||
10 | ||||||
11 | On the 'Setup' tab: | |||||
12 | Enter Manufacturing System Name | |||||
13 | Select Facility Type from the dropdown | |||||
14 | Enter the Outpost tax. This only applies to player-owned outposts. Leave blank otherwise | |||||
15 | Select skill level for Industry and Advanced Industry skills | |||||
16 | Enter System Name to import market data from. | |||||
17 | Select material price type. (Price used for input materials) | |||||
18 | Select product price type. (Price used for products) | |||||
19 | Enter Custom Price for each item. If blank, market price will be used. | |||||
20 | Enter skills & standings in "For Market Comparison" table | |||||
21 | Corp standings = standings with NPC corporation | |||||
22 | Faction standings = standings with NPC corp's faction | |||||
23 | Enter System Name, System ID and Region ID's that you plan to use in the spreadsheet | |||||
24 | Get the data from here→ | Solar System Data Lookup | ||||
25 | On 'Simple Reactions' & 'Complex Reactions' tabs: | |||||
26 | Enter POS Type | |||||
27 | Unit Build Cost = Total cost to build each unit. (Includes material cost and install cost) | |||||
28 | Unit Profit = Profit after selling each unit | |||||
29 | Material Cost = Cost of all materials required for the specified quantity. | |||||
30 | Install Cost = Cost to install the specified quantity of runs. | |||||
31 | Build Time = Time to complete specified quantity of runs. | |||||
32 | Complex Only: Select Build or Buy for input material price. Buy=market price, Build=unit build cost from 'Simple Reactions' tab. | |||||
33 | On 'Booster Production' tab: | |||||
34 | Select Build or Buy for input material price. Buy=market price, Build=unit build cost from previous tabs. | |||||
35 | Enter Quantity, ME and TE | |||||
36 | Enter BPC Cost | |||||
37 | Unit Build Cost = Total cost to build each unit. (Includes material cost and install cost) | |||||
38 | Unit Profit = Profit after selling each unit | |||||
39 | Material Cost = Cost of all materials required for the specified quantity. | |||||
40 | Install Cost = Cost to install the specified quantity of runs. | |||||
41 | Build Time = Time to complete specified quantity of runs. | |||||
42 | On 'Market Comparison' tab: | |||||
43 | Enter System Names at top | |||||
44 | Select Price Type from dropdowns under each system name | |||||
45 | Build Cost (Column C) is the "Unit Build Cost" from the Blueprints tab. | |||||
46 | Profit = [Market Price] - [Build Cost] - [Taxes] | |||||
47 | Average Daily Volume = average volume sold per day over the past 14 days. | |||||
48 | ||||||
49 | Questions? Contact Nolen Cadmar or click here: | Send mail via Eve-Gate | ||||