| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Ore Compression Calc | Version: Mosaic v1 | ||||
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 | ||||||
10 | On the 'Setup' tab: | |||||
11 | Enter Facility Refine Rate (base rate before skills). | |||||
12 | Select Reprocessing Implant from dropdown (if applicable). | |||||
13 | Select skill levels from the other dropdowns. | |||||
14 | Enter Market system to get prices from. | |||||
15 | Select Price Type for market prices. | |||||
16 | Enter Custom Prices. If blank, market price will be used. | |||||
17 | Enter System Name, System ID and Region ID's that you plan to use in the spreadsheet | |||||
18 | Get the data from here→ | Solar System Data Lookup | ||||
19 | On 'Compression Calc' tab: | |||||
20 | Enter quantity of minerals required. | |||||
21 | Optimization must be done manually. The sheet will not tell you how much of each ore to purchase. | |||||
22 | Type a Qty into column H. | |||||
23 | Yield will update with the quantity of minerals upon reprocessing. | |||||
24 | Additional to Haul = [Required] - [Yield] | |||||
25 | Mineral Volume = Volume if you hauled the required minerals. | |||||
26 | Compressed Volume = Volume of compressed ore and minerals specified in column H. | |||||
27 | Click the "Force Refresh" button to force the data to refresh itself. Wait until message at top says "finished" | |||||
28 | ||||||
29 | Questions? Contact Nolen Cadmar or click here: | Send mail via Eve-Gate | ||||