Open World Drops Value Reference Sheet.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	S
1
2							Unresolved variables in income (for optional extra weighing purposes):
3							Weekly Quiz			Drift World lvl50+
4							4000 Asterites			8 gold pins per drift world run
5										Raid, pins
6
7	The Adventure Map will reset at 4 a.m. every Monday, Thursday, and Saturday, making Mon to Thurs the best time to Raid.
8										Read the commentts for this column	(User: change numbers in this column)
9		AsteriteCost	GoldPinsCost	#ofWeekdayRuns	#ofTimeWorks	TwinSak->Asterite Shop, Stam Cost	TimeW->BattleArsenal, Stam Cost	AsteriteDiscountComparedToGoldPins(NOT Compared to OW)	Discount Percentage	Ast Gain if Salvaging for Buying SP Valk Frags	How many?	AsteriteStamCostTotal	GpinsStamCostTotal	AsteriteDiscountComparedToGoldPins(NOT Compared to OW)	If Salvaging, Asterite value:	I need to add a column for Asterite value, for if you are selling Twin Saks and Adv Skill Mats
10	Spatial Lens	330	10	0.275	0.6666666667	9.35	13.33333333	3.983333333	29.88%	0	4	37.4	53.33333333	15.93333333	0
11	AE Imaginons	270	8	0.225	0.5333333333	7.65	10.66666667	3.016666667	28.28%	162	4	30.6	42.66666667	12.06666667	648
12	SP Valk Fragment	500	25	0.4166666667	1.666666667	14.16666667	33.33333333	19.16666667	57.50%	500	2	28.33333333	66.66666667	38.33333333	1000
13	FT/TP Core	600		0.5	0	17	0			360	2	34	0	-34	720
14	Fog/DK/VD/SD/StFu Cores	300		0.25	0	8.5	0			180	2	17	0	-17	360
15	Phase Shifters	600	24	0.5	1.6	17	32	15	46.88%	360	1	17	32	15	360
16	Smelted Core	600	24	0.5	1.6	17	32	15	46.88%	300	1	17	32	15	300
17	Adv SP Matz	400	14	0.3333333333	0.9333333333	11.33333333	18.66666667	7.333333333	39.29%	240	2	22.66666667	37.33333333	14.66666667	480
18	SS Imaginons	200	8	0.1666666667	0.5333333333	5.666666667	10.66666667	5	46.88%	120	4	22.66666667	42.66666667	20	480
19	Note to self: get exp chips added - need coin-stamina conversion value though										4 for 36 in OW
20
21
22
23
24
25	Note: Each Raven fragment is worth between 42 and 60 stamina.
26	Each Accipiter fragment is worth between 36 and 42 stamina. Extreme end would be 60 stamina each.
27	Import the Expeditions spreadsheet for this
28		330	1
29		337.5	1.25
30		200	0.4
31		#DIV/0!	#DIV/0!
32		#DIV/0!	#DIV/0!
33		250	0.4166666667
34		250	0.4166666667
35		285.7142857	0.7142857143
36		250	1.25
37		#DIV/0!	#DIV/0!
38		#DIV/0!	#DIV/0!
39
40	Upcoming edits:
41	gold pins efficiency:
42
43	ae imag and sc metals are the highest priority.
44
45	consider the value of an ow task:
46
47	you can get 3-5 ae imaginons per task
48
49	you can get 2-3 sp valk frags per task
50
51	converting ae imag to a gold pins ratio, we have roughly 24-40 gold pins from 1 ow task for 3-5 ae imag (ex task)
52
53	converting sp valk to a gold pins ratio, we have roughly 50-75 gold pins from 1 ow task for 2-3 sp valk frags
54
55	this means you should buy ae imags from gold pins first because it is by far the highest value option
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