ABCDEF
1
Polymer ReactionsVersion: Tiamat v1.01
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 System Name to import market data from.
13
Select material price type. (Price used for input materials)
14
Select product price type. (Price used for products)
15
Enter Custom Price for each item. If blank, market price will be used.
16
Enter skills & standings in "For Market Comparison" table
17
Corp standings = standings with NPC corporation
18
Faction standings = standings with NPC corp's faction
19
Enter System Name, System ID and Region ID's that you plan to use in the spreadsheet
20
Get the data from here→
Solar System Data Lookup
21
On 'Polymers' tab:
22
Enter POS Type
23
Unit Material Cost = Total cost of materials to build each unit.
24
Unit Profit = Profit after selling each unit
25
On 'Market Comparison' tab:
26
Enter System Names at top
27
Select Price Type from dropdowns under each system name
28
Build Cost (Column C) includes material AND POS fuel cost.
29
Profit = [Market Price] - [Build Cost] - [Taxes]
30
Average Daily Volume = average volume sold per day over the past 14 days.
31
32
33
Questions? Contact Nolen Cadmar or click here:
Send mail via Eve-Gate