trading superbot.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ
1	Eyes (@@)	0.2
2	1 eye obtained	1
3	Throws	2
4	Breaks in [~+(1,-1)] throws	0	1 (not 1st)	1 (1st)
5	Probability	0.64	0.16	0.2
6	Extra eyes needed:	0	1	run dead
7	Probability	0.64	0.16	0.2
8	p\|get in	0.8	0.2
9	1 eye scenario specially coded due to probability of 1st eye breaking
10
11	2 eyes obtained	2
12	Throws	2
13	Breaks in [~+(1,-1)] throws	0	1	2
14	Probability	0.64	0.32	0.04
15	Extra eyes needed:	0	1	2
16	Probability	0.64	0.32	0.04
17
18	3 eyes obtained	3
19	Throws	2
20	Breaks in [~+(1,-1)] throws	0	1	2	3
21	Probability	0.64	0.32	0.04	0
22	Extra eyes needed:	0	1	2	3
23	Probability	0.64	0.32	0.04	0
24
25	Portal Eyes	0	1	2	3	4	5	6	7	8	9	10	11	12
26		0.2824295365	0.3765727153	0.2301277705	0.08523250758	0.0213081269	0.003788111448	0.000491051484	0.000046766808	0.000003247695	0.00000016038	0.000000005346	0.000000000108	0
27
28	Eyes needed from trading	12	11	10	9	8	7	6	5	4	3	2	1	0	Mean
29	1 eye	0.0564859073	0.3012581722	0.3472837263	0.2011487179	0.07244763144	0.01780412381	0.003128699455	0.0004021945488	0.0000380629854	0.000002630232	0.0000001293732	0.0000000042984	0	10.00
30	E(X1)	0.6778308876	3.313839895	3.472837263	1.810338461	0.5795810515	0.1246288666	0.01877219673	0.002010972744	0.0001522519416	0.000007890696	0.0000002587464	0.0000000042984	0
31	2 eyes	0.01129718146	0.1054403603	0.3104632831	0.3180567246	0.1754085006	0.06151892992	0.01486903894	0.002583398474	0.0003293682361	0.00003097643472	0.00000213006024	0.00000010435824	0.000000003456	9.20
32	E(X2)	0.1355661775	1.159843963	3.104632831	2.862510522	1.403268005	0.4306325094	0.08921423361	0.01291699237	0.001317472944	0.00009292930416	0.00000426012048	0.00000010435824	0
33	3 eyes	0	0.01129718146	0.1054403603	0.3104632831	0.3180567246	0.1754085006	0.06151892992	0.01486903894	0.002583398474	0.0003293682361	0.00003097643472	0.00000213006024	0.00000010435824	8.20
34	E(X3)	0	0.1242689961	1.054403603	2.794169548	2.544453797	1.227859504	0.3691135795	0.07434519468	0.0103335939	0.0009881047084	0.00006195286944	0.00000213006024	0
35
36	Eyes needed (weighted)	12	11	10	9	8	7	6	5	4	3	2	1	0
37	p	0.05555388983	0.2971064581	0.3460347602	0.2034678944	0.07486346939	0.01896314385	0.003480130972	0.0004765327285	0.00004952416601	0.000003943135558	0.000000241502877	0.0000000113638518	0.0000000004062436
38	--	12	11	10	9	8	7	6	5	4	3-
39	--	0.05555388983	0.2971064581	0.3460347602	0.2034678944	0.07486346939	0.01896314385	0.003480130972	0.0004765327285	0.00004952416601	0.00000419640853
40	Primary operator bounds	13238	84038	166498	214984	232824	237343	238172	238286	238298	238299
41	Secondary operator bounds										9706	10300	10328	10329
42
43	Parameter 1: Eyes			Simulator specifiations (Assumptions)
44	#eyes	p		1	Every stronghold entry is played
45	1	0.98		2	For trades, use column C. For "Other", fill in em change and reset later.
46	2	0.0175		3	Perfect play is assumed. No chokes are accounted for.
47	3	0.0025		4	To simulate situations, enter bounds in orange cells in column B.
48	Throws	2		5
49				6	See average stats below!
50	Parameter 2: Trades
51	Lockout Trade #	Δems	Trade	AVERAGES AND STANDARD DEVIATIONS
52	1	1	Written Book	X3	10	10.00	#DIV/0!
53	2	-1	1 Glass	X4	20	20.00	#DIV/0!
54	3	-4	1 Bookshelf	X5	21	21.00	#DIV/0!
55	4	-6	6 Glass	Success Rate	1	100.00%	--
56	5	-12	1 Compass	Cycles (✓)	14	14.00	--
57	6	-12	1 Clock	Books	900	900.0	#DIV/0!
58	7	-18	6 Bookshelves	Eyes needed	10	10.00	#DIV/0!
59				Trials		1
60	Parameter 3: Ems from before
61	Ems from before			Trades
62	LL	0		Written Book
63	HL	5		1 Glass
64	Operator UB	30		1 Bookshelf
65				6 Glass
66	Parameter 4: Books and Trades			1 Compass
67	Book Trade LL	8		1 Clock
68	Book Trade HL	10		6 Bookshelves
69	Cleric Roll LL	7		Other (clear cell in Row B to fix later)
70	Cleric Roll HL	11
71	Book-mining buffer (%)	4%
72
73	Trial																																											3-lock	4-lock	5-lock	Cycles	Successful?	Eyes	Book	Cleric	Books
74	1	Restocks passed	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	10	20	21	14	TRUE	10	9	10	900
75		Trades	7	12	11	12	11	3	8	3	11	2	6	2	12	8	3	7	9	5	12	10	3	9	3	3	9	4	11	9	12	10	7	6	3	6	3	7	6	4	10	2	10
76		Rstk Operator	N/A	23873	34091	77399	58095	46372	76700	59580	4608	96673	25193	82807	51904	19739	73170	47980	53347	75649	36190	41488	11868	1803	63734	44109	6837	33865	66629	94932	23310	9235	65010	96611	51221	1921	86895	73288	47113	62600	72458	17515	75975
77		Restock?	1	1	1	1	1	0	1	1	0	1	0	1	1	1	1	1	1	1	1	1	0	0	1	0	0	0	1	1	1	0	1	1	1	0	1	1	1	1	1	0	1
78		X counter	0	0	0	0	0	1	1	1	2	2	3	3	3	3	3	3	3	3	3	3	4	5	5	6	7	8	8	8	8	9	9	9	9	10	10	10	10	10	10	11	11
79		Em operator	9	1° eye operator		149461	/238299	Book roll	9	Books mined	990
80		sqrt(opererator)	3	2° eye operator		2335	/10329	Cleric Roll	10	Ems	100
81		Ems from before	2					Eyes	10
82		Lock Penalty	0	0	0	0	0	1	0	0	-1	0	-4	0	0	0	0	0	0	0	0	0	-6	-12	0	-12	-18	-18	0	0	0	-18	0	0	0	-18	0	0	0	0	0	-18	0
83		Book trades doable this cycle	7	12	11	12	11	3	8	3	11	2	6	2	12	8	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
84		Emeralds Netted this cycle	7	12	11	12	11	4	8	3	10	2	2	2	12	8	2	0	0	0	0	0	-6	-12	0	-12	-18	-18	0	0	0	-18	0	0	0	-18	0	0	0	0	0	-18	0
85		Total Emeralds after this cycle	9	21	32	44	55	59	67	70	80	82	84	86	98	106	108	108	108	108	108	108	102	90	90	78	60	42	42	42	42	24	24	24	24	6	6	6	6	6	6	0	0
86		Books remaining (end of cycle)	927	819	720	612	513	486	414	387	288	270	216	198	90	18	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
87		#extra ems needed (after cycle)	91	79	68	56	45	41	33	30	20	18	16	14	2	-6	-8	-8	-8	-8	-8	-8	-2	10	10	22	40	58	58	58	58	76	76	76	76	94	94	94	94	94	94	100	100
88		Out after this cycle?	No	No	No	No	No	No	No	No	No	No	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
89
90
91
92
93
94
95
96
97
98
99
100