ACA FTE Calculator.xlsx

	A	B	C	D	E	F
1	ACA FTE Calculator
2	Employee Name	Hours Worked Per Week	Full-Time Status (Y/N)	FTE Calculation	Summary Section
3	Employee 1	40	Y	1	Total Full-Time Employees	4
4	Employee 2	25	N	0.83	Total Part-Time Employees	6
5	Employee 3	30	Y	1	Total FTEs	7.67
6	Employee 4	20	N	0.67	Grand Total	11.67
7	Employee 5	15	N	0.5
8	Employee 6	40	Y	1	To Download: On the upper left corner, click File, click Download, and click Microsoft Excell
9	Employee 7	15	N	0.5
10	Employee 8	20	N	0.67	Please fill out only the following fields: Employee Name, Hours Worked per Week, and Full-Time Status.
11	Employee 9	48	Y	1
12	Employee 10	15	N	0.5
13	Employee 11			0
14	Employee 12			0
15	Employee 13			0
16	Employee 14			0
17	Employee 15			0
18	Employee 16			0
19	Employee 17			0
20	Employee 18			0
21	Employee 19			0
22	Employee 20			0
23	Employee 21			0
24	Employee 22			0
25	Employee 23			0
26	Employee 24			0
27	Employee 25			0
28	Employee 26			0
29	Employee 27			0
30	Employee 28			0
31	Employee 29			0
32	Employee 30			0
33	Employee 31			0
34	Employee 32			0
35	Employee 33			0
36	Employee 34			0
37	Employee 35			0
38	Employee 36			0
39	Employee 37			0
40	Employee 38			0
41	Employee 39			0
42	Employee 40			0
43	Employee 41			0
44	Employee 42			0
45	Employee 43			0
46	Employee 44			0
47	Employee 45			0
48	Employee 46			0
49	Employee 47			0
50	Employee 48			0
51	Employee 49			0
52	Employee 50			0
53	Employee 51			0
54	Employee 52			0
55	Employee 53			0
56	Employee 54			0
57	Employee 55			0
58	Employee 56			0
59	Employee 57			0
60	Employee 58			0
61	Employee 59			0
62	Employee 60			0
63	Employee 61			0
64	Employee 62			0
65	Employee 63			0
66	Employee 64			0
67	Employee 65			0
68	Employee 66			0
69	Employee 67			0
70	Employee 68			0
71	Employee 69			0
72	Employee 70			0
73	Employee 71			0
74	Employee 72			0
75	Employee 73			0
76	Employee 74			0
77	Employee 75			0
78	Employee 76			0
79	Employee 77			0
80	Employee 78			0
81	Employee 79			0
82	Employee 80			0
83	Employee 81			0
84	Employee 82			0
85	Employee 83			0
86	Employee 84			0
87	Employee 85			0
88	Employee 86			0
89	Employee 87			0
90	Employee 88			0
91	Employee 89			0
92	Employee 90			0
93	Employee 91			0
94	Employee 92			0
95	Employee 93			0
96	Employee 94			0
97	Employee 95			0
98	Employee 96			0
99	Employee 97			0
100	Employee 98			0