Available Hours Template *MAKE A COPY*.xlsx

	A	B	C	D	E	F	G	H	I	N	O
1		Month-->	Jan
2	#N/A									# of Free Days	30
3	Type	Techs	Days Working	Total Hours	Hours per Day	Advisors	Days Working	Total Hours Goal	Hours Per/Day	Tech Hire Date	Date
4	T	Tech 1	16.0	128.0	8	Writer 1	20.0	419.5	21.0	Tech 1	12/30/1899
5	T	Tech 2	20.0	160.0	8	Writer 2	21.0	440.5	21.0	Tech 2	12/30/1899
6	T	Tech 3	20.0	160.0	8					Tech 3	12/30/1899
7	T	Tech 4	20.0	160.0	8					Tech 4	12/30/1899
8	T	Tech 5	21.0	168.0	8					Tech 5	12/30/1899
9	L	Tech 6	21.0	84.0	4					Tech 6	12/30/1899
10		7			0					7	12/30/1899
11		8			0					8	12/30/1899
12		9			0					9	12/30/1899
13		10			0					10	12/30/1899
14		11			0					11	12/30/1899
15		12			0					12	12/30/1899
16		13			0					13	12/30/1899
17		14			0					14	12/30/1899
18		15			0					15	12/30/1899
19		16			0		Total Hours	860	42	16	12/30/1899
20		17			0		Available hours	860		17	12/30/1899
21		18			0		Diff----->			18	12/30/1899
22		19			0					19	12/30/1899
23		20			0					20	12/30/1899
24		21			0					21	12/30/1899
25		22			0					22	12/30/1899
26		23			0					23	12/30/1899
27		24			0					24	12/30/1899
28		25			0					25	12/30/1899
29		26			0					26	12/30/1899
30		27			0					27	12/30/1899
31		28			0					28	12/30/1899
32		29			0					29	12/30/1899
33		30			0					30	12/30/1899
34		31			0					31	12/30/1899
35		32			0					32	12/30/1899
36		33			0					33	12/30/1899
37		34			0					34	12/30/1899
38		35			0					35	12/30/1899
39		36			0					36	12/30/1899
40		37			0					37	12/30/1899
41		38			0					38	12/30/1899
42		39			0					39	12/30/1899
43		40			0					40	12/30/1899
44		41			0					41	12/30/1899
45		42			0					42	12/30/1899
46		43			0					43	12/30/1899
47		44			0					44	12/30/1899
48		45			0					45	12/30/1899
49		46			0					46	12/30/1899
50		47			0					47	12/30/1899
51		48			0					48	12/30/1899
52		49			0					49	12/30/1899
53
54			Total Available Hours	860
55
56
57	Type	Description	Hours per Day
58	T	<----Tech--->	8
59	L	<----Lube Tech----->	4
60	M	<----Mobil------>	4
61	4T	4 TEN'S	11.3
62	4L	4 Ten's Lube	5.65
63	QLL	Quick Lube	4.5
64	4QLL	4 Ten Quick Lube	5.65
65	QLT	Quick Lube Techs	9
66	4QLT	4 Ten Quick Lube Techs	11.3
67	O4T	Other Lube/Flat techs	5.65
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