FY26-27 DSHS WorkFirst Calculator Tool.xls

	A	B	C	D	E	F	G	H	I
1	WorkFirst Participation Hours Calculator
2	Student's Name:				Quarter/Year:
3	A	B	C	D	E	F	G	H	I
4	Class Name	Number of scheduled class hours	Credit/Credit hours	Homework required?	Unsupervised Study Hours	Maximum number of Study Hours	Additional supervised study hours possible	Total Scheduled Supervised Study Hours	Projected Total Participation Hours
5	(Simplified Formulas:)	Enter Hours	Enter Credits	"Y" or "N"	=IF(D="Y",B, 0)	=IF(D="Y",C*3,B)	=IF(D="Y",F-E,0)	Enter Hours	=B+E+H
6					0		0		0
7					0		0		0
8					0		0		0
9					0		0		0
10					0		0		0
11					0		0		0
12					0		0		0
13					0		0		0
14					0		0		0
15					0		0		0
16					0		0		0
17	TOTAL	0	0		0		0	0	0
18	* "Total Scheduled Supervised Study Hours" (H) cannot exceed "Additonal supervised Study Hours possible" (G).
19
20	6/18/26 10:25
21
22
23
24
25
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