ATITD T7 Chem Helper

	A	B	C	D	E	F	G	H	I	J
1	Quality:	Osiris
2	Attributes:	As----	Bi++++
3	Kaeshra	MiniPalmetto	TapacaeMiralis	PowderedOpal	SaltsOfLead
4
5	Material	Quantity	Fish	Grain	Grey	Mineral	Rock	Veg	Wood	Worm
6	Kaeshra	2	0	0	0	14	0	6	0	0
7	MiniPalmetto	1	0	5	0	0	0	4	0	1
8	TapacaeMiralis	2	0	0	0	0	8	0	12	0
9	PowderedOpal	1	0	0	9	0	0	0	0	1
10	SaltsOfLead	2	0	0	0	16	0	4	0	0
11	80	8	0	5	9	30	8	14	12	2
12
13	Kaeshra	7 Mineral, 3 Vegetable				7 Mineral, 3 Vegetable,
14	MiniPalmetto	5 Grain, 4 Vegetable, 1 Worm				5 Grain, 4 Vegetable, 1 Worm,
15	TapacaeMiralis	4 Rock, 6 Wood				4 Rock, 6 Wood,
16	PowderedOpal	9 Grey, 1 Worm				9 Grey, 1 Worm,
17	SaltsOfLead	8 Mineral, 2 Vegetable				8 Mineral, 2 Vegetable,
18
19
20	BUGS: There could be transcription errors in the EssenceTable sheet (or other buggy behavior, I suppose).
21	Report any unexpected behavior to Huggz, in game.
22
23	How to Use:
24	1) Go to Extract wiki pages (i.e. http://www.atitd.org/wiki/tale7/Osiris)
25	2) Locate desired recipe
26	3) Paste recipe on row 3 (cells A-E), using 1 cell per essence (Copying all 5 from wiki, selecting A3 and hitting paste should copy all 5 into their appropriate spots)
27	4) If all essences are available in EssenceTable sheet, needed spirits will fill out after quantities are entered
28	5) Enter needed quantities for each essence (this is the number of batches in chem lab. Obviously yield will differ based on spirit qualities used and it's up to you to account for that)
29	6) Once quantities are entered bottom row will show the total quantity of spirit types you'll need
30
31	Additional Notes:
32	TO COPY:	Copy the EssenceTable sheet first and rename your copy back to EssenceTable. THEN copy the Chem sheet. Chem sheet will get confused if it can't find Essence Table
33	TO UPDATE:	2 Options, delete your copies and recopy via above instructions, OR select all in one or both sheets, Ctrl C, and Ctrl V onto your sheet.
34	Top Table will list total number of spirit types needed based on the quantities entered
35	Grey spirits will highlight red in the top table, as a reminder that they're there and that the associated essences need to be counted differently (i.e. 3 db per batch)
36	Bottom Table lists out spirits needed for 1 batch of that particular essence
37	Cells A11 and B11 are checksums that ensure Top Table filled out correctly.
38		B11 is the number of essence batches being created.
39		A11 is the number of spirits totalled in the top table.
40		A11 will be green if it equals B11 * 10
41	F13-F17 are hidden calculations. Don't mess with them or the bottom table will break.
42	Rows 1 and 2 are manual note fields to help you remember what you were working on, and are not required.
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