{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Transcript Review Worksheet","Clock_Hr"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Transcript Review Worksheet","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,7,2,8],[27,0,27,3],[27,8,27,11],[2,14,2,15],[4,0,4,7],[2,10,2,12],[2,2,2,5],[4,8,4,15],[37,0,37,15],[35,0,36,15],[34,0,34,15],[29,4,29,7],[28,0,28,3],[29,0,29,3],[29,12,29,15],[28,8,28,11],[30,5,32,7],[30,8,32,12],[29,8,29,11],[30,14,32,15],[30,0,32,4]]}
["Postsecondary Child Care Grant Program Transcript Review - Effective 2017-2018 & Thereafter"]
["This spreadsheet is meant to be filled out for review. Users of this spreadsheet are responsible for confirming the accuracy of all calculations."]
[null,"Student Name:",null,null,null,null,"HS Grad Date:",null,null,"Transcript Review Date:",null,null,null,"SSN"]
[null,"This cell is left blank on purpose. "]
["Quarter Credits",null,null,null,null,null,null,null,"Semester Credits"]
["Quarter School Name","Term","Year","Credits","  Post -      July 1, 1992 Units","   Pre -      July 1, 1992 Credits","   Pre -      July 1, 1992 Units","Bank Credits","Semester School Name","Term","Year","Credits","  Post -      July 1, 1992 Units","   Pre -      July 1, 1992 Credits","   Pre -      July 1, 1992 Units","Bank Credits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(D26>15,8,IF(D26<16,ROUND(D26*0.53333,1)))","v":0},null,{"$f":"IF(F26<6,0,IF(F26<9,4,IF(F26<12,6,IF(F26<999,8))))","v":0}]
["Clock Hour",null,null,null,{"$f":"IF(Clock_Hr!$H$4=\"YES\", Clock_Hr!$H$16,0)","v":0},null,{"$f":"IF(Clock_Hr!$H$4=\"NO\", Clock_Hr!$H$16,0)","v":0},null,null,null,null,null,{"$f":"IF(L27>15,12,IF(L27<16,ROUND(L27*0.8,1)))","v":0},null,{"$f":"IF(N27<6,0,IF(N27<9,6,IF(N27<12,9,IF(N27<999,12))))","v":0}]
["Total:",null,null,null,{"$f":"SUM(E7:E27)","v":0},"Total:",{"$f":"SUM(G7:G27)","v":0},{"$f":"SUM(H7:H27)","v":0},"Total:",null,null,null,{"$f":"SUM(M7:M27)","v":0},"Total:",{"$f":"SUM(O7:O27)","v":0},{"$f":"SUM(P7:P27)","v":0}]
["Total Quarter Banked Credit Units:",null,null,null,{"$f":"IF(H28/12<0.5,0,IF(H28/12<0.75,4,IF(H28/12<1,6,IF(H28/12<1.5,8,IF(H28/12<1.75,12,IF(H28/12<2,14,IF(H28/12<2.5,16,IF(H28/12<2.75,20))))))))","v":0},null,null,null,"Total Semester Banked Credit Units:",null,null,null,{"$f":"IF(P28/12<0.5,0,IF(P28/12<0.75,6,IF(P28/12<1,9,IF(P28/12<1.5,12,IF(P28/12<1.75,18,IF(P28/12<2,21,IF(P28/12<2.5,24,IF(P28/12<2.75,30))))))))","v":0}]
["Total Quarter Units:",null,null,null,{"$f":"SUM(E28+E29+G28)","v":0},null,null,null,"Total Semester Units:",null,null,null,{"$f":"SUM(M28+O28+M29)","v":0}]
["Total Units at Time of Review:",null,null,null,null,{"$f":"SUM(E30+M30)","v":0},null,null,"FT* Terms of Remaining Eligibility:",null,null,null,null,{"$f":"IF(F31>93.6,\"0 Sems\",IF(F31<81.7,\"2 Sems\",IF(F31 <93.7,\"1 Sem\")))","v":"2 Sems"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F31>94.4,\"0 Qtrs\",IF(F31<78.5,\"3 Qtrs\",IF(F31<86.5,\"2 Qtrs\",IF(F31<94.5,\"1 Qtr\"))))","v":"3 Qtrs"}]
["Remember to clear Clock_Hr page on that Worksheet"]
["Users of this spreadsheet are responsible for confirming the accuracy of all calculations."]
["Five years of full-time attendance equals 120 units.  Schools may exceed the maximum of 120 units by disbursing one more term of State Grant to students attending a school on the quarter system who have not yet exceeded 118.4 units or students attending a semester school who have not yet exceeded 117.6 units."]
[]
["*Terms of remaining eligibility shown are for a student enrolled for 15 or more credits per term.  Student may have more remaining terms of eligibility if enrolled less than full-time."]
["End of Worksheet"]

{"sheet":"Clock_Hr","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[[19,3,21,5],[15,2,15,5],[3,0,3,5],[5,0,5,5],[7,0,7,5],[9,0,9,5],[11,0,11,5],[13,2,13,5]]}
["Postsecondary Education Units Calculator for Progressive Clock Hour Transcripts"]
["(Enter data in orange cells)",null," ",null,null,null,null," ",null,null," ",null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES","Post July 1, 1992 Conversion"]
["Was course work taken after July 1, 1992?",null,null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO",null,null,"Quarter"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clock Hours Per Week",null,"Credits","Units"]
["Total Hours in Student's Period of Enrollment",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,1,0.5]
["Total Weeks in Student's Period of Enrollment",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,2,1.1000000000000001]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7,3,1.6]
["Average Clock Hours per Week",null,null,null,null,null,null,{"$f":"TRUNC(H6/H8)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,9,4,2.1]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,11,5,2.7]
["Enrollment Level (in credits)",null,null,null,null,null,null,{"$f":"VLOOKUP($H$10,$Z$6:$AB$21,3,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,13,6,3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,15,7,3.7]
[null,null,"Units for Enrollment Level",null,null,null,null,{"$f":"IF($H$4=\"YES\",VLOOKUP($H$12,$AB$6:$AC$21,2,1),VLOOKUP($H$12,$AB$27:$AC$42,2,1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,17,8,4.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,19,9,4.8]
[null,null,"Total Units for Period of Enrollment",null,null,null,null,{"$f":"$H$14 * ($H$8/12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,21,10,5.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,23,11,5.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,25,12,6.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,27,13,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,29,14,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,9999,15,8]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-July 1, 1992 Conversion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"Quarter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clock Hours Per Week",null,"Credits","Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,9,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,11,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,13,6,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,15,7,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,17,8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,19,9,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,21,10,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,23,11,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,25,12,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,27,13,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,29,14,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,9999,15,8]