Salvaged Glass Probabilities.xlsx

	A	C	D	E	F	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1
2						Tests Done:	18
3						Confidence:	0.95
4	Total Glass Opened:	Items	Number	Percentage	True	Test Number	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	Average:	Standard Deviation:	Confidence Interval:
5	1800	Nanites	2219	11.611	10	Nanites	120	141	120	164	130	120	129	152	106	87	152	130	98	150	87	97	119	117	11.611	3.204	10.875	12.347
6	Nanite Drops:	Sentinel Exosuit Fragment	371	20.611	20	Sentinel Exosuit Fragment	22	23	18	16	20	22	23	15	21	25	20	16	25	17	22	27	20	19	20.611	4.045	19.682	21.541
7	209	Sentinel Weapons Shard	338	18.778	20	Sentinel Weapons Shard	19	21	24	17	19	20	22	20	16	18	14	24	9	18	22	18	18	19	18.778	3.905	17.880	19.675
8	Average Nanite per Nanite Drop:	Hydraulic Wiring	130	7.222	7	Hydraulic Wiring	8	6	5	8	7	11	5	9	7	7	7	6	11	13	7	2	7	4	7.222	2.589	6.627	7.817
9	10.617	Quantum Computer	70	3.889	4	Quantum Computer	3	4	6	6	3	1	4	2	3	6	4	4	1	4	3	7	5	4	3.889	1.933	3.445	4.333
10		Vy'keen Effigy	185	10.278	12	Vy'keen Effigy	8	7	5	7	13	7	13	14	10	12	14	9	13	11	10	10	10	12	10.278	3.037	9.580	10.976
11		Dirty Bronze	78	4.333	4	Dirty Bronze	3	5	5	4	4	4	2	7	3	4	5	5	4	1	4	5	6	7	4.333	2.036	3.865	4.801
12		Magno-Gold	63	3.500	3	Magno-Gold	3	5	2	4	1	3	3	2	8	4	2	5	4	5	1	4	5	2	3.500	1.838	3.078	3.922
13		Antimatter	123	6.833	7	Antimatter	8	7	13	7	8	9	6	5	8	6	5	5	8	3	11	2	5	7	6.833	2.523	6.253	7.413
14		Magnetic Resonator	83	4.611	4	Magnetic Resonator	5	5	4	4	6	4	2	4	8	3	9	2	5	4	5	5	4	4	4.611	2.097	4.129	5.093
15		Lemmium	66	3.667	4	Lemmium	3	3	3	4	4	3	4	5	2	5	2	3	4	7	4	2	4	4	3.667	1.879	3.235	4.099
16		Geodesite	35	1.944	2	Geodesite	4	0	0	3	0	3	1	1	3	1	2	4	1	2	0	4	3	3	1.944	1.381	1.627	2.262
17		Sentinel Boundary Map	49	2.722	3	Sentinel Boundary Map	3	1	4	5	3	1	2	2	1	1	2	3	6	1	3	5	2	4	2.722	1.627	2.348	3.096
18
19		Category	Chance %			Item	Base Price (Units)		Base Price (Nanites)		Profit (Units)		Profits (Nanites)			Binomial Probability Calculator
20		Module:	39.389			Nanites	NA		1		NA		1.233			Chance	Certainty	Number of Salvaged Glass Needed
21		Component:	15.722			Sentinel Exosuit Fragment	480		481		98.933		99.139			39.389	95.00	6
22		Alloy:	13.444			Sentinel Weapons Shard	480		485		90.133		91.072
23		Map:	2.722			Hydraulic Wiring	3600		NA		260.000		NA			Binomial Probability Calculator for Multiple Successes
24		Effigy:	10.278			Quantum Computer	4200		NA		163.333		NA			Chance	Certainty	Min. Number of Successes			Salvaged Glass Needed
25		Antimatter:	6.833			Vy'keen Effigy	24750		NA		2543.750		NA			2.722	95.00	1			109
26		Nanites:	11.611			Dirty Bronze	25000		NA		1083.333		NA
27		Total:	100.000			Magno-Gold	25000		NA		875.000		NA
28						Antimatter	5233		NA		357.588		NA
29		Average Nanites:	123.278			Magnetic Resonator	6150		NA		283.583		NA
30		Nanite Standard Deviation:	11.103			Lemmium	25000		NA		916.667		NA
31		Confidence Interval:	115.4612278	131.0943277		Geodesite	150000		NA		2916.667		NA
32						Sentinel Boundary Map	3200		NA		87.111		NA
33
34						Category	Units		Nanites
35						Everything:	9676.099		191.444
36						Modules:	189.067		190.212
37						Components:	706.917		NA
38						Alloys:	5791.667		NA
39						Maps:	87.111		NA
40						Effigy:	2543.750		NA
41						Antimatter:	357.588		NA
42						Nanites:	NA		NA
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