{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["GA","Data","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"GA","index":0,"n_rows":72,"n_cols":21,"rows_kept":72,"cut":false,"hidden":false,"merged":[[15,9,15,10],[20,20,21,20],[31,5,31,6],[48,8,48,10],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[17,9,17,10],[22,5,22,6],[23,5,23,6],[24,5,24,6],[30,5,30,6],[71,11,72,11],[19,8,19,10],[19,2,21,4],[4,6,4,10],[20,8,20,10],[20,5,20,6],[48,5,48,6],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10]]}
[]
[]
[null,null,null,null,null,null,null,"           Site Computer Usage Estimator"]
[]
[null,null,null,null,null,"Test Administration ","Select an Administration"]
[]
[null,null,null,null,null,null,null,null,"Testing Devices Available in the School ",100]
[]
[null,null,null,null,null,null,null,null,"Possible Computer Hours in a Day ",4]
[]
[null,null,null,null,null,null,null,null,"Planned Testing Days ",12]
[null,null,null,null,null,null,null,null,{"$f":"\"(Established Test Window is \" & Data!$I$57 & \" Weekdays)\"","v":"(Established Test Window is 0 Weekdays)"}]
[null,null,null,null,null,null,null,null,"Start Date ",{"$f":"Data!I58","v":"2019-09-17"}]
[null,null,null,null,null,null,null,null,"End Date ",{"$f":"Data!I59","v":"2019-09-17"}]
[]
[null,null,null,null,null,null,null,null,"Number of Test Sessions to be Administered ",{"$f":"S71","v":0}]
[]
[null,null,null,null,null,null,null,null,"Usage Percent of Available Testing Devices ",{"$f":"Data!B78","v":0},null,null,null,null,{"$f":"VLOOKUP(GA!G5,Data!L4:P20,5,FALSE)","v":0},"Longest test time ",null,null,{"$f":"MAX(N23:N32,N51:N56,N58:N63,N65:N66,N68:N69)+(Data!I61*1)","v":10},"Sec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(S18/60,1)","v":0.2},"Hours"]
[null,null,"Students to be Tested",null,null,null,null,null,"Estimated Test\nTime (Minutes)",null,null,null,null,null,"Session 1","Session 2","Session 3"]
[null,null,null,null,null,"End of Course",null,null,"Section",null,null,null,null,null,null,null,null,null,null,null,"Average Test Session Length"]
[null,null,null,null,null,"Subject",null,null,1,2,3,null,null,null,"Minutes","Minutes","Minutes"]
[null,null,null,0,null,{"$f":"Data!A3","v":"Ninth Grade Literature and Composition"},null,null,{"$f":"Data!C3","v":90},{"$f":"IF(Data!E3=0,\"\",Data!E3)","v":85},{"$f":"IF(Data!G3=0,\"\",Data!G3)","v":85},null,null,{"$f":"IF(D23>0,I23,\"\")","v":""},{"$f":"IFERROR(I23*D23,0)","v":0},{"$f":"IFERROR(J23*D23,0)","v":0},{"$f":"IFERROR(K23*D23,0)","v":0},{"$f":"COUNT(I23:K23)","v":3},{"$f":"R23*D23","v":0},null,{"$f":"IFERROR((SUM(O23:Q23)/S23),0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A4","v":"American Literature and Composition"},null,null,{"$f":"Data!C4","v":90},{"$f":"IF(Data!E4=0,\"\",Data!E4)","v":85},{"$f":"IF(Data!G4=0,\"\",Data!G4)","v":85},null,null,{"$f":"IF(D24>0,I24,\"\")","v":""},0,0,0,3,0,null,0]
[null,null,null,0,null,{"$f":"Data!A5","v":"Algebra I"},null,null,{"$f":"Data!C5","v":85},{"$f":"IF(Data!E5=0,\"\",Data!E5)","v":85},{"$f":"IF(Data!G5=0,\"\",Data!G5)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A6","v":"Analytic Geometry"},null,null,{"$f":"Data!C6","v":85},{"$f":"IF(Data!E6=0,\"\",Data!E6)","v":85},{"$f":"IF(Data!G6=0,\"\",Data!G6)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A7","v":"Biology"},null,null,{"$f":"Data!C7","v":70},{"$f":"IF(Data!E7=0,\"\",Data!E7)","v":70},{"$f":"IF(Data!G7=0,\"\",Data!G7)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A8","v":"Coordinate Algebra"},null,null,{"$f":"Data!C8","v":85},{"$f":"IF(Data!E8=0,\"\",Data!E8)","v":85},{"$f":"IF(Data!G8=0,\"\",Data!G8)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A9","v":"Economics/Business/Free Enterprise"},null,null,{"$f":"Data!C9","v":70},{"$f":"IF(Data!E9=0,\"\",Data!E9)","v":70},{"$f":"IF(Data!G9=0,\"\",Data!G9)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A10","v":"Geometry"},null,null,{"$f":"Data!C10","v":85},{"$f":"IF(Data!E10=0,\"\",Data!E10)","v":85},{"$f":"IF(Data!G10=0,\"\",Data!G10)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A11","v":"Physical Science"},null,null,{"$f":"Data!C11","v":70},{"$f":"IF(Data!E11=0,\"\",Data!E11)","v":70},{"$f":"IF(Data!G11=0,\"\",Data!G11)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A12","v":"United States History"},null,null,{"$f":"Data!C12","v":70},{"$f":"IF(Data!E12=0,\"\",Data!E12)","v":70},{"$f":"IF(Data!G12=0,\"\",Data!G12)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,0,null,{"$f":"Data!A14","v":0},{"$f":"IF(Data!B14=0,\"\",Data!B14)","v":""},null,{"$f":"Data!C14","v":0},{"$f":"IF(Data!E14=0,\"\",Data!E14)","v":""},{"$f":"IF(Data!G14=0,\"\",Data!G14)","v":""},null,null,null,0,0,0,{"$f":"COUNT(I34:K34)","v":1},{"$f":"R34*D34","v":0}]
[null,null,null,0,null,{"$f":"Data!A15","v":0},{"$f":"IF(Data!B15=0,\"\",Data!B15)","v":""},null,{"$f":"Data!C15","v":0},{"$f":"IF(Data!E15=0,\"\",Data!E15)","v":""},{"$f":"IF(Data!G15=0,\"\",Data!G15)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A16","v":0},{"$f":"IF(Data!B16=0,\"\",Data!B16)","v":""},null,{"$f":"Data!C16","v":0},{"$f":"IF(Data!E16=0,\"\",Data!E16)","v":""},{"$f":"IF(Data!G16=0,\"\",Data!G16)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A17","v":0},{"$f":"IF(Data!B17=0,\"\",Data!B17)","v":""},null,{"$f":"Data!C17","v":0},{"$f":"IF(Data!E17=0,\"\",Data!E17)","v":""},{"$f":"IF(Data!G17=0,\"\",Data!G17)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A18","v":0},{"$f":"IF(Data!B18=0,\"\",Data!B18)","v":""},null,{"$f":"Data!C18","v":0},{"$f":"IF(Data!E18=0,\"\",Data!E18)","v":""},{"$f":"IF(Data!G18=0,\"\",Data!G18)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A19","v":0},{"$f":"IF(Data!B19=0,\"\",Data!B19)","v":""},null,{"$f":"Data!C19","v":0},{"$f":"IF(Data!E19=0,\"\",Data!E19)","v":""},{"$f":"IF(Data!G19=0,\"\",Data!G19)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A20","v":0},{"$f":"IF(Data!B20=0,\"\",Data!B20)","v":""},null,{"$f":"Data!C20","v":0},{"$f":"IF(Data!E20=0,\"\",Data!E20)","v":""},{"$f":"IF(Data!G20=0,\"\",Data!G20)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0,null,{"$f":"Data!A21","v":0},{"$f":"IF(Data!B21=0,\"\",Data!B21)","v":""},null,{"$f":"Data!C21","v":0},{"$f":"IF(Data!E21=0,\"\",Data!E21)","v":""},{"$f":"IF(Data!G21=0,\"\",Data!G21)","v":""},null,null,null,0,0,0,1,0]
[null,null,null,0]
[null,null,null,0,null,{"$f":"Data!A23","v":0},{"$f":"IF(Data!B23=0,\"\",Data!B23)","v":""},null,{"$f":"Data!C23","v":0},{"$f":"IF(Data!E23=0,\"\",Data!E23)","v":""},{"$f":"IF(Data!G23=0,\"\",Data!G23)","v":""},null,null,null,null,null,null,{"$f":"COUNT(I43:K43)","v":1},{"$f":"R43*D43","v":0}]
[null,null,null,0,null,{"$f":"Data!A24","v":0},{"$f":"IF(Data!B24=0,\"\",Data!B24)","v":""},null,{"$f":"Data!C24","v":0},{"$f":"IF(Data!E24=0,\"\",Data!E24)","v":""},{"$f":"IF(Data!G24=0,\"\",Data!G24)","v":""},null,null,null,null,null,null,{"$f":"COUNT(I44:K44)","v":1},{"$f":"R44*D44","v":0}]
[null,null,null,0,null,{"$f":"Data!A25","v":0},{"$f":"IF(Data!B25=0,\"\",Data!B25)","v":""},null,{"$f":"Data!C25","v":0},{"$f":"IF(Data!E25=0,\"\",Data!E25)","v":""},{"$f":"IF(Data!G25=0,\"\",Data!G25)","v":""},null,null,null,null,null,null,{"$f":"COUNT(I45:K45)","v":1},{"$f":"R45*D45","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(I48*D48,0)","v":0},{"$f":"IFERROR(J48*D48,0)","v":0},{"$f":"IFERROR(K48*D48,0)","v":0}]
[null,null,null,null,null,"End of Grade",null,null,"Section",null,null,null,null,null,{"$f":"IFERROR(I43*D43,0)","v":0},{"$f":"IFERROR(J43*D43,0)","v":0},{"$f":"IFERROR(K43*D43,0)","v":0}]
[null,null,null,null,null,"Subject","Grade",null,1,2,3,null,null,null,{"$f":"IFERROR(I44*D44,0)","v":0},{"$f":"IFERROR(J44*D44,0)","v":0},{"$f":"IFERROR(K44*D44,0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A31","v":"English Language Arts"},{"$f":"Data!B31","v":"Grade 3"},null,{"$f":"Data!C31","v":90},{"$f":"IF(Data!E31=0,\"\",Data!E31)","v":85},{"$f":"IF(Data!G31=0,\"\",Data!G31)","v":85},null,null,{"$f":"IF(D51>0,I51,\"\")","v":""},{"$f":"IFERROR(I51*D51,0)","v":0},{"$f":"IFERROR(J51*D51,0)","v":0},{"$f":"IFERROR(K51*D51,0)","v":0},{"$f":"COUNT(I51:K51)","v":3},{"$f":"R51*D51","v":0},null,{"$f":"IFERROR((SUM(O51:Q51)/S51),0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A32","v":"English Language Arts"},{"$f":"Data!B32","v":"Grade 4"},null,{"$f":"Data!C32","v":90},{"$f":"IF(Data!E32=0,\"\",Data!E32)","v":85},{"$f":"IF(Data!G32=0,\"\",Data!G32)","v":85},null,null,"",0,0,0,3,0,null,0]
[null,null,null,0,null,{"$f":"Data!A33","v":"English Language Arts"},{"$f":"Data!B33","v":"Grade 5"},null,{"$f":"Data!C33","v":90},{"$f":"IF(Data!E33=0,\"\",Data!E33)","v":85},{"$f":"IF(Data!G33=0,\"\",Data!G33)","v":85},null,null,"",0,0,0,3,0,null,0]
[null,null,null,0,null,{"$f":"Data!A34","v":"English Language Arts"},{"$f":"Data!B34","v":"Grade 6"},null,{"$f":"Data!C34","v":90},{"$f":"IF(Data!E34=0,\"\",Data!E34)","v":85},{"$f":"IF(Data!G34=0,\"\",Data!G34)","v":85},null,null,"",0,0,0,3,0,null,0]
[null,null,null,0,null,{"$f":"Data!A35","v":"English Language Arts"},{"$f":"Data!B35","v":"Grade 7"},null,{"$f":"Data!C35","v":90},{"$f":"IF(Data!E35=0,\"\",Data!E35)","v":85},{"$f":"IF(Data!G35=0,\"\",Data!G35)","v":85},null,null,"",0,0,0,3,0,null,0]
[null,null,null,0,null,{"$f":"Data!A36","v":"English Language Arts"},{"$f":"Data!B36","v":"Grade 8"},null,{"$f":"Data!C36","v":90},{"$f":"IF(Data!E36=0,\"\",Data!E36)","v":85},{"$f":"IF(Data!G36=0,\"\",Data!G36)","v":85},null,null,"",0,0,0,3,0,null,0]
[]
[null,null,null,0,null,{"$f":"Data!A38","v":"Mathematics"},{"$f":"Data!B38","v":"Grade 3"},null,{"$f":"Data!C38","v":85},{"$f":"IF(Data!E38=0,\"\",Data!E38)","v":85},{"$f":"IF(Data!G38=0,\"\",Data!G38)","v":""},null,null,{"$f":"IF(D58>0,I58,\"\")","v":""},{"$f":"IFERROR(I58*D58,0)","v":0},{"$f":"IFERROR(J58*D58,0)","v":0},{"$f":"IFERROR(K58*D58,0)","v":0},{"$f":"COUNT(I58:K58)","v":2},{"$f":"R58*D58","v":0},null,{"$f":"IFERROR((SUM(O58:Q58)/S58),0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A39","v":"Mathematics"},{"$f":"Data!B39","v":"Grade 4"},null,{"$f":"Data!C39","v":85},{"$f":"IF(Data!E39=0,\"\",Data!E39)","v":85},{"$f":"IF(Data!G39=0,\"\",Data!G39)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A40","v":"Mathematics"},{"$f":"Data!B40","v":"Grade 5"},null,{"$f":"Data!C40","v":85},{"$f":"IF(Data!E40=0,\"\",Data!E40)","v":85},{"$f":"IF(Data!G40=0,\"\",Data!G40)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A41","v":"Mathematics"},{"$f":"Data!B41","v":"Grade 6"},null,{"$f":"Data!C41","v":85},{"$f":"IF(Data!E41=0,\"\",Data!E41)","v":85},{"$f":"IF(Data!G41=0,\"\",Data!G41)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A42","v":"Mathematics"},{"$f":"Data!B42","v":"Grade 7"},null,{"$f":"Data!C42","v":85},{"$f":"IF(Data!E42=0,\"\",Data!E42)","v":85},{"$f":"IF(Data!G42=0,\"\",Data!G42)","v":""},null,null,"",0,0,0,2,0,null,0]
[null,null,null,0,null,{"$f":"Data!A43","v":"Mathematics"},{"$f":"Data!B43","v":"Grade 8"},null,{"$f":"Data!C43","v":85},{"$f":"IF(Data!E43=0,\"\",Data!E43)","v":85},{"$f":"IF(Data!G43=0,\"\",Data!G43)","v":""},null,null,"",0,0,0,2,0,null,0]
[]
[null,null,null,0,null,{"$f":"Data!A45","v":"Science"},{"$f":"Data!B45","v":"Grade 5"},null,{"$f":"Data!C45","v":70},{"$f":"IF(Data!E45=0,\"\",Data!E45)","v":70},{"$f":"IF(Data!G45=0,\"\",Data!G45)","v":""},null,null,{"$f":"IF(D65>0,I65,\"\")","v":""},{"$f":"IFERROR(I65*D65,0)","v":0},{"$f":"IFERROR(J65*D65,0)","v":0},{"$f":"IFERROR(K65*D65,0)","v":0},{"$f":"COUNT(I65:K65)","v":2},{"$f":"R65*D65","v":0},null,{"$f":"IFERROR((SUM(O65:Q65)/S65),0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A46","v":"Science"},{"$f":"Data!B46","v":"Grade 8"},null,{"$f":"Data!C46","v":70},{"$f":"IF(Data!E46=0,\"\",Data!E46)","v":70},{"$f":"IF(Data!G46=0,\"\",Data!G46)","v":""},null,null,"",{"$f":"IFERROR(I66*D66,0)","v":0},{"$f":"IFERROR(J66*D66,0)","v":0},{"$f":"IFERROR(K66*D66,0)","v":0},{"$f":"COUNT(I66:K66)","v":2},{"$f":"R66*D66","v":0},null,{"$f":"IFERROR((SUM(O66:Q66)/S66),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!E47=0,\"\",Data!E47)","v":""},{"$f":"IF(Data!G47=0,\"\",Data!G47)","v":""}]
[null,null,null,0,null,{"$f":"Data!A48","v":"Social Studies"},{"$f":"Data!B48","v":"Grade 5"},null,{"$f":"Data!C48","v":70},{"$f":"IF(Data!E48=0,\"\",Data!E48)","v":70},{"$f":"IF(Data!G48=0,\"\",Data!G48)","v":""},null,null,{"$f":"IF(D68>0,I68,\"\")","v":""},{"$f":"IFERROR(I68*D68,0)","v":0},{"$f":"IFERROR(J68*D68,0)","v":0},{"$f":"IFERROR(K68*D68,0)","v":0},{"$f":"COUNT(I68:K68)","v":2},{"$f":"R68*D68","v":0},null,{"$f":"IFERROR((SUM(O68:Q68)/S68),0)","v":0}]
[null,null,null,0,null,{"$f":"Data!A49","v":"Social Studies"},{"$f":"Data!B49","v":"Grade 8"},null,{"$f":"Data!C49","v":70},{"$f":"IF(Data!E49=0,\"\",Data!E49)","v":70},{"$f":"IF(Data!G49=0,\"\",Data!G49)","v":""},null,null,"",{"$f":"IFERROR(I69*D69,0)","v":0},{"$f":"IFERROR(J69*D69,0)","v":0},{"$f":"IFERROR(K69*D69,0)","v":0},{"$f":"COUNT(I69:K69)","v":2},{"$f":"R69*D69","v":0},null,{"$f":"IFERROR((SUM(O69:Q69)/S69),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O23:Q69)","v":0},"Total Minutes",null,null,{"$f":"SUM(S23:S69)","v":0},"Total Test Sessions"]
[null,null,null,null,null,null,null,null,null,null,null,"ver. 1.1",null,null,null,null,null,null,{"$f":"IFERROR(ROUNDUP(O71/S71,0),0)","v":0},"Average Test Session Length"]

{"sheet":"Data","index":1,"n_rows":120,"n_cols":18,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
[null,null,"GA - EOC Duration (Minutes)"]
["Subject","Grade","Session 1",null,"Session 2",null,"Session 3",null,"Total"]
["Ninth Grade Literature and Composition",null,90,null,85,null,85,null,{"$f":"C3+E3+G3","v":260},null,null,null,"Start Date","End Date","Days"]
["American Literature and Composition",null,90,null,85,null,85,null,{"$f":"C4+E4+G4","v":260},null,null,"Select an Administration",{"$f":"TODAY()","v":"2019-09-17"},{"$f":"TODAY()","v":"2019-09-17"},0]
["Algebra I",null,85,null,85,null,0,null,{"$f":"C5+E5+G5","v":170},null,null,"EOC Fall Mid-Month - August","2019-08-05","2019-08-23",{"$f":"NETWORKDAYS(M5,N5,$M$73:$M$120)","v":15},"EOC",null,"Keystone"]
["Analytic Geometry",null,85,null,85,null,0,null,170,null,null,"EOC Fall Mid-Month - September","2019-09-09","2019-09-20",10,"EOC",null,"All"]
["Biology",null,70,null,70,null,0,null,140,null,null,"EOC Fall Mid-Month - October","2019-10-07","2019-10-18",10,"EOC",null,"ELA"]
["Coordinate Algebra",null,85,null,85,null,0,null,170,null,null,"EOC Fall Mid-Month - November","2019-11-04","2019-11-15",10,"EOC",null,"Mathematics"]
["Economics/Business/Free Enterprise",null,70,null,70,null,0,null,140]
["Geometry",null,85,null,85,null,0,null,170,null,null,"EOC Winter Main","2019-11-18","2020-01-08",{"$f":"NETWORKDAYS(M10,N10,$M$73:$M$120)","v":28},"EOC",null,"Science"]
["Physical Science",null,70,null,70,null,0,null,140]
["United States History",null,70,null,70,null,0,null,140,null,null,"EOC Spring Mid-Month - January","2020-01-13","2020-01-24",{"$f":"NETWORKDAYS(M12,N12,$M$73:$M$120)","v":9},"EOC",null,"All"]
[null,null,"Session 1",null,"Session 2",null,"Session 3",null,"Total",null,null,"EOC Spring Mid-Month - February","2020-02-10","2020-02-21",{"$f":"NETWORKDAYS(M13,N13,$M$73:$M$120)","v":9},"EOC",null,"Keystone"]
[null,null,0,null,0,null,0,null,{"$f":"C14+E14+G14","v":0},null,null,"EOC Spring Mid-Month - March","2020-03-09","2020-03-20",{"$f":"NETWORKDAYS(M14,N14,$M$73:$M$120)","v":10},"EOC",null,"Keystone"]
[null,null,0,null,0,null,0,null,0,null,null,"EOC Spring Main","2020-04-20","2020-05-29",{"$f":"NETWORKDAYS(M15,N15,$M$73:$M$120)","v":30},"EOC"]
[null,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,null,"EOC Summer Main","2020-06-15","2020-07-17",{"$f":"NETWORKDAYS(M17,N17,$M$73:$M$120)","v":25},"EOC",null,"Keystone"]
[null,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,null,"EOG Spring Main","2020-04-06","2020-05-15",{"$f":"NETWORKDAYS(M19,N19,$M$73:$M$120)","v":30},"EOG",null,"All"]
[null,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0]
[]
[null,null,0,null,0,null,0,null,{"$f":"C23+E23+G23","v":0}]
[null,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0]
[]
[]
[]
[null,null,"GA - EOG Duration (Minutes)",null,null,null,null,null,null,null,null,"EOG Summer Retest","2020-05-11","2020-07-17",{"$f":"NETWORKDAYS(M29,N29,$M$73:$M$120)","v":50},"EOG-Retest",null,"ELA"]
["Subject","Grade","Session 1",null,"Session 2",null,"Session 3",null,"Total"]
["English Language Arts","Grade 3",90,null,85,null,85,null,{"$f":"SUM(C31,E31,G31)","v":260}]
["English Language Arts","Grade 4",90,null,85,null,85,null,{"$f":"C32+E32+G32","v":260}]
["English Language Arts","Grade 5",90,null,85,null,85,null,260]
["English Language Arts","Grade 6",90,null,85,null,85,null,260]
["English Language Arts","Grade 7",90,null,85,null,85,null,260]
["English Language Arts","Grade 8",90,null,85,null,85,null,260]
[null,null,"Session 1",null,"Session 2",null,"Session 3"]
["Mathematics","Grade 3",85,null,85,null,0,null,170]
["Mathematics","Grade 4",85,null,85,null,0,null,170]
["Mathematics","Grade 5",85,null,85,null,0,null,170]
["Mathematics","Grade 6",85,null,85,null,0,null,170]
["Mathematics","Grade 7",85,null,85,null,0,null,170]
["Mathematics","Grade 8",85,null,85,null,0,null,{"$f":"C43+E43+G43","v":170}]
[null,null,"Session 1",null,"Session 2",null,"Session 3"]
["Science","Grade 5",70,null,70,null,0,null,{"$f":"SUM(C45,E45,G45)","v":140}]
["Science","Grade 8",70,null,70,null,0,null,{"$f":"SUM(C46,E46,G46)","v":140}]
[]
["Social Studies","Grade 5",70,null,70,null,0,null,{"$f":"SUM(C48,E48,G48)","v":140}]
["Social Studies","Grade 8",70,null,70,null,0,null,140]
[]
[null,null,null,null,null,null,null,"Nbr of testing days in established test window",{"$f":"VLOOKUP(GA!G5,Data!L4:O20,4,FALSE)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Nbr of testing days in established test window",{"$f":"IFERROR(VLOOKUP(GA!G5,Data!L4:P20,4,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,null,"Start Date",{"$f":"IFERROR(VLOOKUP(GA!G5,Data!L4:P20,2,FALSE),\"\")","v":"2019-09-17"}]
[null,null,null,null,null,null,null,"End Date",{"$f":"IFERROR(VLOOKUP(GA!G5,Data!L4:P20,3,FALSE),\"\")","v":"2019-09-17"}]
[]
[null,null,null,null,null,null,null,"Break - Minutes between tests",10]
[]
[null,"Hours","Minutes"]
[null,{"$f":"ROUND(C64/60,0)","v":0},{"$f":"SUM(GA!O23:Q69)+(GA!S71*I61)","v":0},"Required Testing Minutes"]
[null,{"$f":"ROUND(C65/60,0)","v":4800},{"$f":"ROUND(((GA!J7*(GA!J9*60))*GA!J11),0)","v":288000},"Available Testing Minutes"]
[null,null,{"$f":"IFERROR(C64/C65,0)","v":0}]
[]
[null,{"$f":"GA!J9*60","v":240},"Total possible minutes per computer per day"]
[null,{"$f":"B68*GA!J7","v":24000},"Total possible computer minutes per day"]
[]
[null,{"$f":"GA!S72+Data!I61","v":10},"Average Test Session Length + Break Period"]
[null,null,null,null,null,null,null,null,null,null,null,"Holidays and Winter Break","Date"]
[null,{"$f":"ROUNDDOWN(B68/B71,0)","v":24},"Possible test sessions per computer per day",null,null,null,null,null,null,null,null,"Labor Day","2017-09-04"]
[null,{"$f":"B73*GA!J7","v":2400},"Total possible test session per day",null,null,null,null,null,null,null,null,"Thanksgiving","2017-11-23"]
[null,null,null,null,null,null,null,null,null,null,null,"Day after Thanksgiving","2017-11-24"]
[null,{"$f":"B74*GA!J11","v":28800},"Total possible test session during window",null,null,null,null,null,null,null,null,"Christmas Eve","2017-12-24"]
[null,{"$f":"GA!S71","v":0},"Total Test Sessions",null,null,null,null,null,null,null,null,"Christmas","2017-12-25"]
[null,{"$f":"IFERROR(B77/B76,\"Error\")","v":0},null,null,null,null,null,null,null,null,null,"Day After Christmas ","2017-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2017-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2017-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2017-12-29"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2017-12-30"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2017-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"New Year’s Day","2018-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,"Martin Luther King Day","2018-01-15"]
[null,null,null,null,null,null,null,null,null,null,null,"President’s Day","2018-02-19"]
[null,null,null,null,null,null,null,null,null,null,null,"Memorial Day","2018-05-28"]
[null,null,null,null,null,null,null,null,null,null,null,"Independence Day","2018-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,"Labor Day","2018-09-03"]
[null,null,null,null,null,null,null,null,null,null,null,"Thanksgiving","2018-11-22"]
[null,null,null,null,null,null,null,null,null,null,null,"Day after Thanksgiving","2018-11-23"]
[null,null,null,null,null,null,null,null,null,null,null,"Christmas Eve","2018-12-24"]
[null,null,null,null,null,null,null,null,null,null,null,"Christmas","2018-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-29"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-30"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2018-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"New Year’s Day","2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,"Martin Luther King Day","2019-01-14"]
[null,null,null,null,null,null,null,null,null,null,null,"President’s Day","2019-02-18"]
[null,null,null,null,null,null,null,null,null,null,null,"Memorial Day","2019-05-27"]
[null,null,null,null,null,null,null,null,null,null,null,"Independence Day","2018-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,"Labor Day","2019-09-02"]
[null,null,null,null,null,null,null,null,null,null,null,"Thanksgiving","2019-11-28"]
[null,null,null,null,null,null,null,null,null,null,null,"Day after Thanksgiving","2019-11-29"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-23"]
[null,null,null,null,null,null,null,null,null,null,null,"Christmas Eve","2019-12-24"]
[null,null,null,null,null,null,null,null,null,null,null,"Christmas","2019-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-29"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-30"]
[null,null,null,null,null,null,null,null,null,null,null,"Winter Break","2019-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"New Year’s Day","2020-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,"Martin Luther King Day","2020-01-13"]
[null,null,null,null,null,null,null,null,null,null,null,"President’s Day","2020-02-17"]
[null,null,null,null,null,null,null,null,null,null,null,"Memorial Day","2020-02-25"]

{"sheet":"Sheet2","index":2,"n_rows":102,"n_cols":22,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,4,1,7],[1,9,1,11]]}
[]
[null,null,null,null,"EOC Fall Mid-Month",null,null,null,"EOC Winter Main","EOC Spring Mid-Month",null,null,"EOC Spring Main","EOC Summer Main","EOG Spring Main","EOG Summer Retest"]
[null,"EOC Assessments","Testing Time","Testing Time","August 6 – 24, 2018","September 10–21, 2018","October 9 – 19, 2018","November 5–16, 2018","November 26, 2018 – January 4, 2019","January 14–25, 2019","February 11–22, 2019","March 11–22, 2019","April 22 – May 31, 2019","June 17 – July 19, 2019","April 8–May 17, 2019 ","May 13 – July 19, 2019"]
[null,null,null,null,"2018-08-06","2018-09-10","2018-10-09","2018-11-05","2018-11-26","2019-01-14","2019-02-11","2019-03-11","2019-04-22","2019-06-17","2019-04-08","2019-05-13"]
[null,null,null,null,"2018-08-24","2018-09-21","2018-10-19","2018-11-16","2019-01-04","2019-01-25","2019-02-22","2019-03-22","2019-05-31","2019-07-19","2019-05-17","2019-07-19",null,"ProjectCode","Admin Name",null,null,"State Testing Window"]
[null,"Ninth Grade Literature and Composition – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X","X","X","X","X","X","X","X","X","X",null,null,null,null,"EOC Fall Mid-Month - September","2018-09-10","2018-09-21","September 10–21, 2018"]
[null,"Ninth Grade Literature and Composition – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X","X","X","X","X","X","X","X","X",null,null,null,null,"EOC Fall Mid-Month - October","2018-10-09","2018-10-19","October 9–19, 2018"]
[null,"Ninth Grade Literature and Composition – Section 3","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X","X","X","X","X","X","X","X","X",null,null,null,null,"EOC Fall Mid-Month - November","2018-11-05","2018-11-16","November 5–16, 2018"]
[null,"American Literature and Composition – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA933","EOC Winter Main","2018-11-26","2019-01-04","November 26, 2018–January 4, 2019"]
[null,"American Literature and Composition – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA934","EOC Spring Mid-Month - January","2019-01-14","2019-01-25","January 14–25, 2019"]
[null,"American Literature and Composition – Section 3","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,null,"EOC Spring Mid-Month - February","2019-02-11","2019-02-22","February 11–22, 2019"]
[null,"Coordinate Algebra – Section 1","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,null,"EOC Spring Mid-Month - March","2019-03-11","2019-03-22","March 11–22, 2019"]
[null,"Coordinate Algbera – Section 2","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA935","EOC Spring Main","2019-04-22","2019-05-31","April 22–May 31, 2019"]
[null,"Analytic Geometry – Section 1","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA936","EOC Summer Main","2019-06-17","2019-07-19","June 17–July 19, 2019"]
[null,"Analytic Geometry – Section 2","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA925","EOG Spring Main","2019-04-08","2019-05-17","April 8–May 17, 2019 "]
[null,"Algebra I – Section 1","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X",null,null,null,"EGA926","EOG Summer Retest","2019-05-13","2019-07-19","May 13–July 19, 2019"]
[null,"Algebra I – Section 2","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X"]
[null,"Geometry – Section 1","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X"]
[null,"Geometry – Section 2","60-85 Minutes",75,"X","X","X","X","X","X","X","X","X","X"]
[null,"Biology – Section 1","45-70 Minutes",{"$f":"MROUND((45+70)/2,5)","v":60},"X","X","X","X","X","X","X","X","X","X"]
[null,"Biology – Section 2","45-70 Minutes",{"$f":"MROUND((45+70)/2,5)","v":60},"X","X","X","X","X","X","X","X","X","X"]
[null,"Physical Science – Section 1","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,"Physical Science – Section 2","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,"United States History – Section 1","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,"United States History – Section 2","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,"Economics/Business/Free Enterprise – Section 1","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,"Economics/Business/Free Enterprise – Section 2","45-70 Minutes",60,"X","X","X","X","X","X","X","X","X","X"]
[null,null,null,null,"EOG Spring Main","EOG Summer Retest"]
[null,"EOG Assessments","Testing Time","Testing Time","April 8–May 17, 2019 ","May 13 – July 19, 2019"]
[null,"Grade 3 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X","X"]
[null,"Grade 3 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X"]
[null,"Grade 3 English Language Arts – Section 3","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X"]
[null,"Grade 4 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X"]
[null,"Grade 4 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X"]
[null,"Grade 4 English Language Arts – Section 3","60-85 Minutes",75,"X"]
[null,"Grade 5 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X","X"]
[null,"Grade 5 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X"]
[null,"Grade 5 English Language Arts – Section 3","60-85 Minutes",75,"X"]
[null,"Grade 6 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X"]
[null,"Grade 6 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X"]
[null,"Grade 6 English Language Arts – Section 3","60-85 Minutes",75,"X"]
[null,"Grade 7 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X"]
[null,"Grade 7 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X"]
[null,"Grade 7 English Language Arts – Section 3","60-85 Minutes",75,"X"]
[null,"Grade 8 English Language Arts – Section 1","70-90 Minutes",{"$f":"MROUND((70+90)/2,5)","v":80},"X","X"]
[null,"Grade 8 English Language Arts – Section 2","60-85 Minutes",{"$f":"MROUND((60+85)/2,5)","v":75},"X","X"]
[null,"Grade 8 English Language Arts – Section 3","60-85 Minutes",75,"X"]
[null,"Grade 3 Mathematics – Section 1","60-85 Minutes",75,"X"]
[null,"Grade 3 Mathematics – Section 2","60-85 Minutes",75,"X"]
[null,"Grade 4 Mathematics – Section 1","60-85 Minutes",75,"X"]
[null,"Grade 4 Mathematics – Section 2","60-85 Minutes",75,"X"]
[null,"Grade 5 Mathematics – Section 1","60-85 Minutes",75,"X","X"]
[null,"Grade 5 Mathematics – Section 2","60-85 Minutes",75,"X","X"]
[null,"Grade 6 Mathematics – Section 1","60-85 Minutes",75,"X"]
[null,"Grade 6 Mathematics – Section 2","60-85 Minutes",75,"X"]
[null,"Grade 7 Mathematics – Section 1","60-85 Minutes",75,"X"]
[null,"Grade 7 Mathematics – Section 2","60-85 Minutes",75,"X"]
[null,"Grade 8 Mathematics – Section 1","60-85 Minutes",75,"X","X"]
[null,"Grade 8 Mathematics – Section 2","60-85 Minutes",75,"X","X"]
[null,"Grade 5 Science – Section 1","45-70 Minutes",{"$f":"MROUND((45+70)/2,5)","v":60},"X"]
[null,"Grade 5 Science – Section 2","45-70 Minutes",60,"X"]
[null,"Grade 8 Science – Section 1","45-70 Minutes",60,"X"]
[null,"Grade 8 Science – Section 2","45-70 Minutes",60,"X"]
[null,"Grade 5 Social Studies – Section 1","45-70 Minutes",60,"X"]
[null,"Grade 5 Social Studies – Section 2","45-70 Minutes",60,"X"]
[null,"Grade 8 Social Studies – Section 1","45-70 Minutes",60,"X"]
[null,"Grade 8 Social Studies – Section 2","45-70 Minutes",60,"X"]
[]
[]
[]
[]
[null,"EOC"]
[null,null,"Section 1",2,3]
[null,"American Literature and Composition","x","x","x"]
[null,"Ninth Grade Literature and Composition","x","x","x"]
[null,"Algebra I","x","x"]
[null,"Analytic Geometry","x","x"]
[null,"Biology","x","x"]
[null,"Coordinate Algebra","x","x"]
[null,"Economics/Business/Free Enterprise","x","x"]
[null,"Geometry","x","x"]
[null,"Physical Science","x","x"]
[null,"United States History","x","x"]
[]
[null,"EOG"]
[null,null,null,"Section 1",2,3]
[null,"English Language Arts","Grade 3","x","x","x"]
[null,"English Language Arts","Grade 4","x","x","x"]
[null,"English Language Arts","Grade 5","x","x","x"]
[null,"English Language Arts","Grade 6","x","x","x"]
[null,"English Language Arts","Grade 7","x","x","x"]
[null,"English Language Arts","Grade 8","x","x","x"]
[null,"Mathematics","Grade 3","x","x"]
[null,"Mathematics","Grade 4","x","x"]
[null,"Mathematics","Grade 5","x","x"]
[null,"Mathematics","Grade 6","x","x"]
[null,"Mathematics","Grade 7","x","x"]
[null,"Mathematics","Grade 8","x","x"]
[null,"Science","Grade 5","x","x"]
[null,"Science","Grade 8","x","x"]
[null,"Social Studies","Grade 5","x","x"]
[null,"Social Studies","Grade 8","x","x"]