{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data","Overview","Employee 1","Employee 2","Employee 3","Employee 4","Employee 5","Employee 6","Employee 7","Employee 8","Employee 9","Employee 10"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Director",12,null,"Nutrition - 1000","Operations - 2000","Administration - 3000","Communications & Marketing - 4000"]
["Manager",10,null,"Menu Planning (1100) ","Food Production (2100)","Free and Reduced Price Meal Benefits (3100)","Communications & Marketing (4100)"]
["FT Staff (>20hrs per week)",6,null,"Nutrition Education (1200) ","Serving Food (2200)","Program Management (3200)"]
["PT Staff (<20hrs per week)",4,null,"General Nutrition (1300)","Cashier and Point of Service (2300)","Financial Management (3300)"]
[null,null,null,null,"Purchasing / Procurement (2400)","Human Resources and Staff Training (3400)"]
["Nutrition - 1000",null,null,null,"Receiving and Storage (2500)","Facilities and Equipment Planning (3500)"]
["Operations - 2000",null,null,null,"Food Safety and Hazard Analysis and Critical Control Point (HACCP) (2600)"]
["Administration - 3000"]
["Communications & Marketing - 4000"]

{"sheet":"Overview","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
["District Name:",null,null,null,null,"District Number:"]
[]
["Employee Name","Hiring Date","School","Position","Total Hours YTD","Required Hours","Remaining Hours"]
[{"$f":"IF(ISBLANK('Employee 1'!$B$1),\"\",'Employee 1'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 1'!$H$1),\"\",'Employee 1'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 1'!$B$4),\"\",'Employee 1'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 1'!$B$2),\"\",'Employee 1'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 1'!$H$3),\"\",'Employee 1'!$H$3)","v":0},{"$f":"'Employee 1'!$H$2","v":""},{"$f":"IFERROR(IF(F5-E5>0,F5-E5,\"0\"),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Employee 2'!$B$1),\"\",'Employee 2'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 2'!$H$1),\"\",'Employee 2'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 2'!$B$4),\"\",'Employee 2'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 2'!$B$2),\"\",'Employee 2'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 2'!$H$3),\"\",'Employee 2'!$H$3)","v":0},{"$f":"'Employee 2'!$H$2","v":""},{"$f":"IFERROR(IF(F6-E6>0,F6-E6,\"0\"),\"\")","v":""}]
[{"$f":"IF(ISBLANK('Employee 3'!$B$1),\"\",'Employee 3'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 3'!$H$1),\"\",'Employee 3'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 3'!$B$4),\"\",'Employee 3'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 3'!$B$2),\"\",'Employee 3'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 3'!$H$3),\"\",'Employee 3'!$H$3)","v":0},{"$f":"'Employee 3'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 4'!$B$1),\"\",'Employee 4'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 4'!$H$1),\"\",'Employee 4'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 4'!$B$4),\"\",'Employee 4'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 4'!$B$2),\"\",'Employee 4'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 4'!$H$3),\"\",'Employee 4'!$H$3)","v":0},{"$f":"'Employee 4'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 5'!$B$1),\"\",'Employee 5'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 5'!$H$1),\"\",'Employee 5'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 5'!$B$4),\"\",'Employee 5'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 5'!$B$2),\"\",'Employee 5'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 5'!$H$3),\"\",'Employee 5'!$H$3)","v":0},{"$f":"'Employee 5'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 6'!$B$1),\"\",'Employee 6'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 6'!$H$1),\"\",'Employee 6'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 6'!$B$4),\"\",'Employee 6'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 6'!$B$2),\"\",'Employee 6'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 6'!$H$3),\"\",'Employee 6'!$H$3)","v":0},{"$f":"'Employee 6'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 7'!$B$1),\"\",'Employee 7'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 7'!$H$1),\"\",'Employee 7'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 7'!$B$4),\"\",'Employee 7'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 7'!$B$2),\"\",'Employee 7'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 7'!$H$3),\"\",'Employee 7'!$H$3)","v":0},{"$f":"'Employee 7'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 8'!$B$1),\"\",'Employee 8'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 8'!$H$1),\"\",'Employee 8'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 8'!$B$4),\"\",'Employee 8'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 8'!$B$2),\"\",'Employee 8'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 8'!$H$3),\"\",'Employee 8'!$H$3)","v":0},{"$f":"'Employee 8'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 9'!$B$1),\"\",'Employee 9'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 9'!$H$1),\"\",'Employee 9'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 9'!$B$4),\"\",'Employee 9'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 9'!$B$2),\"\",'Employee 9'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 9'!$H$3),\"\",'Employee 9'!$H$3)","v":0},{"$f":"'Employee 9'!$H$2","v":""},""]
[{"$f":"IF(ISBLANK('Employee 10'!$B$1),\"\",'Employee 10'!$B$1)","v":""},{"$f":"IF(ISBLANK('Employee 10'!$H$1),\"\",'Employee 10'!$H$1)","v":""},{"$f":"IF(ISBLANK('Employee 10'!$B$4),\"\",'Employee 10'!$B$4)","v":""},{"$f":"IF(ISBLANK('Employee 10'!$B$2),\"\",'Employee 10'!$B$2)","v":""},{"$f":"IF(ISBLANK('Employee 10'!$H$3),\"\",'Employee 10'!$H$3)","v":0},{"$f":"'Employee 10'!$H$2","v":""},""]

{"sheet":"Employee 1","index":2,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,4,5,7],[0,3,0,4]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 2","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 3","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 4","index":5,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 5","index":6,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 6","index":7,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 7","index":8,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 8","index":9,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 9","index":10,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]

{"sheet":"Employee 10","index":11,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,3,0,4],[5,4,5,7]]}
["Employee Name: ",null,"Classification:",null,null,null,"Hire Date:"]
["Job Title: ",null,null,null,null,null,"Required Hours of Training per Year:",{"$f":"IFERROR(VLOOKUP(D1,Data!A1:B4,2,FALSE),\"\")","v":""}]
["Institution/School District: ",null,null,null,null,null,"Total Hours Year to Date:",{"$f":"I12+I18+I25","v":0}]
["School Site: ",null,null,null,null,null,"School Year Training Applied to SY","21-22"]
[]
["Key Areas","Key Topics","Training Title/Subject","Completion Date","Creditable Training Time\n(Length in hours, minutes)",null,null,null,"Total for This Page"]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E7=\"\",G7=\"\"),\"\",(E7*60)+G7)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I7:I11))/60","v":0}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E13=\"\",G13=\"\"),\"\",(E13*60)+G13)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I13:I17))/60","v":0}]
[]
[null,null,null,null,null,"Hour(s)",null,"Minutes",{"$f":"IF(AND(E20=\"\",G20=\"\"),\"\",(E20*60)+G20)","v":""}]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,"Hour(s)",null,"Minutes",""]
[null,null,null,null,null,null,null,null,{"$f":"(SUM(I20:I24))/60","v":0}]