phantomwolf13's TFCG deck analysis tools

	A	B	C	D	E	G	H	I	J	K	M	N	O	P	Q	R	S	T
1	Deck Analysis Tool
2	by phantomwolf13
3
4	Use this sheet to analyze a deck by entering its load code.
5	input: deck load code			outputs: card list with card codes, quantities, whether the card is upped or not, and costs; deck total cards, total cost; energy analysis (total energy costs, energy available from instas, delta)
6
7	input deck load code here (old OR new format):
8	16.8.3.61.1.62.4.123.7.129.3.133.2.141.2.149.2.217																starting energy superpower:	FALSE
9																	+5 generators superpower:	FALSE
10	old format load code																LM Deck	FALSE
11	8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,61,61,61,62,123,123,123,123,129,129,129,129,129,129,129,133,133,133,141,141,149,149,217,217
12	new format load code
13	16.8.3.61.1.62.4.123.7.129.3.133.2.141.2.149.2.217
14
15						energy costs by color						total energy costs	total instant energy	total generators	energy delta (w/o gens)	energy delta (gens count as +10)
16	card codes	count	text	upped?	card costs	white	red	yellow	green	blue	white	0	1	1	1	11
17	8	16	Yellow Generator	TRUE	500 x16 = 8,000			0			red	0	1	1	1	11
18	61	3	Golden Dragon	FALSE	350 x3 = 1,050			36			yellow	156	1	17	-155	15
19	62	1	Light Dragon	TRUE	3,500 x1 = 3,500			12			green	10	1	1	-9	1
20	123	4	Overkill	FALSE	250 x4 = 1,000			32			blue	0	1	1	1	11
21	129	7	Time Warp	FALSE	200 x7 = 1,400			28
22	133	3	Lure	FALSE	125 x3 = 375			6			deck total cards	deck total cost
23	141	2	Dream Book	FALSE	2,000 x2 = 4,000			30			40	20,275
24	149	2	Heal	FALSE	125 x2 = 250				10
25	217	2	Dagger of Time	FALSE	350 x2 = 700			12
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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