Coffee Roast Log.xlsx

	B	C	D	E	F	G	H	I	K	L	M	N	P	Q	R	S	T	U	V	W	X	Y	AA	AB
1	on 12/30/99 - Rested on 01/02/00 -
2
3
4	Event	Time	Bean Temp	Bean Temp -F	Notes	ROC
5		:00	205	401																			How to use
6		:30	175	347		-30																	Temperatures in C with F for reference
7		1:00				-30																	Notes column is where to track gas changes, and misc notes about roast
8		1:30				-30																	Event: Enter TA, Y, FC, 2C, drop to indicate milestone of roast
9		2:00				-30																		TA = Turnaround
10	ta	2:30				-30																		Y = Yellow
11		3:00				-30																		FC = First Crack
12		3:30				-30																		2C = Second Crack
13		4:00				-30																		Drop = when you remove beans from roaster
14		4:30				-30																	All yellow boxes require input
15		5:00				-30
16		5:30				-30
17		6:00				-30
18		6:30				-30
19		7:00				-30
20	y	7:30	165	329		165
21		8:00				165
22		8:30				165
23		9:00				165
24		9:30				165
25	fc	10:00	204	399		204		Roast Milestones
26		10:30				204			Turnaround			Yellow		1st Crack			2nd Crack			Finish
27		11:00				204		Time	2:30			7:30		10:00						13:30
28		11:30				204		Temp				165		204
29		12:00				204
30		12:30				204		Tasting Ratings												Batch #
31		13:00				204		Day
32	drop	13:30				204		Score (1-5)
33		14:00				204
34		14:30				204		Bean Info										Roast Info
35		15:00				204		Coffee Orgin/Name										Date			12/30/99
36		15:30				204		Region			#ERROR!							Roaster
37		16:00				204		Producer			#ERROR!							Batch #
38		16:30				204		Variety			#ERROR!							Pre Heat Time
39		17:00				204		Process			#ERROR!							Humidity
40		17:30				204		Purchase Date			#ERROR!							Temperature			18
41		18:00				204		Price/Lb			#ERROR!							Green Weight			227
42		18:30				204		Supplier			#ERROR!							Roast Weight
43		19:00				204												Shrinkage
44		19:30				204
45		20:00				204		3 Day Rest Period Makes Coffee Drinkable on:							Tuesday, January 02, 1900
46								Final Roast Level
47
48		Roast Plan								Date				Roast Notes
49		Charge Size			227
50										Actuals
51					Time	Temp - C	Temp - F			Time		Temp
52		Charge Temp			0:00	205	401			0:00		205
53		Bean Temp			0:00	23	73			0:00		23
54		Enviromental Temp			0:00	18	65			0:00		18
55		Turn Around			3:00	145	293			2:30
56		Yellow			7:30	172	342			7:30		165
57		First Crack			12:00	210	410			10:00		204
58		Second Crack
59		Drop			14:00	231	448			13:30
60
61		Tasting Notes
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									Earth & Coffee
91		Tasting
92
93									on 12/30/99 - Rested on 01/02/00 -
94									on 12/30/99 - Rested on 01/02/00 -
95
96									Roast Milestones
97											Turnaround		Yellow			1st Crack			2nd Crack			Finish
98									Time		2:30		7:30			10:00						13:30
99									Temp				165			204
100