{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Important Info","Same Schedule Every Day","Block Schedule","Example 1","Example 2","Example 3","Formulas","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":28,"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":"Important Info","index":0,"n_rows":121,"n_cols":21,"rows_kept":121,"cut":false,"hidden":false,"merged":[[20,2,20,23],[22,1,22,17],[115,1,121,3],[119,20,119,23],[120,20,120,23],[30,0,37,23],[39,0,43,23],[19,2,19,23],[17,2,17,23],[1,1,1,23],[5,2,5,23],[7,2,7,23],[8,2,8,23],[11,1,11,23],[3,2,3,23],[18,2,18,23],[15,2,15,23],[6,2,6,23],[9,2,9,23],[16,2,16,23]]}
[]
[null,"INSTRUCTIONS FOR BELL SCHEDULE CALCULATOR"]
[]
[null,1,"Select a worksheet to complete.  If your school has the same bell schedule every day, complete \"Same Schedule Every Day\" work sheet.  If your school has any type of block schedule, complete the \"Block Schedule\" worksheet."]
[null,2,"Complete the heading area on the worksheet you selected."]
[null,3,"Begin completing the daily schedule by inputting Type of Time.  Enter class time as \"1st Period\", \"2nd Period\", \"Seminar\", \"Advocacy\", etc.  Enter lunch time as \"Lunch\".  Enter passing time as \"Passing\"."]
[null,4,"Enter Start Time and End Time."]
[null,5,"Type of time must remain consistent across the rows.  In other words, if the first row is 1st period, then it needs to say 1st period or be blank throughout the worksheet, etc.  This allows the formulas to calculate correctly.  See example worksheets."]
[null,6,"When the school's bell schedule is the same on certain days, you can copy the schedule into each day."]
[null,7,"The Daily Average Minutes table will automatically calculate daily average minutes per class period and total daily average minutes."]
[]
[null,"IMPORTANT INFORMATION"]
[]
[null,"•","Orange highlighted cells indicate an area where the user should input data."]
[null,"•","Blue highlighted cells indicate an area where the spreadsheet contains formulas and access is restricted."]
[null,"•","We have included 3 example worksheets reflecting different types of block schedules.  They also indicate how to complete the daily schedule fields."]
[null,"•","Lunch and one passing period (either before or after lunch) may not be counted.  This will calculate automatically."]
[null,"•","If your school has a period which is a combination of class time and lunch, those times need to be separated on the calculator so that the formula will calculate correctly."]
[null,"•","No passing time is allowed to the first class of the day or from the last class of the day."]
[null,"•","When calculating an individual student's minutes, passing time from a class period to a period not enrolled is not counted.  Passing time from a period where there is no enrolled class is not counted."]
[null,"•","Cutting data will cause formula errors in protected cells so we have disabled the cut function in the worksheet. Instead, copy and paste, then go back to original cell and delete data."]
[]
[null,"EXAMPLES - BELL SCHEDULE CALCULATOR"]
[]
[null,"Example 1","Same schedule every week with changes one day per week"]
[null,"Example 2","Rotating every other day schedule"]
[null,"Example 3","Modified block schedule"]
[]
[]
[]
["Bell Schedule Calculator\nUpdated 6/29/23\n\n\nKansas leads the world in the success of each student."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Kansas State Department of Education"]
[null,null,null,null,"Fiscal Auditing"]
[null,null,null,null,"785-296-4976",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESL Contact Minutes Calculator"]
[null,null,null,null,"https://www.ksde.org/Agency/Fiscal-and-Administrative-Services/Fiscal-Auditing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 6/18/18"]

{"sheet":"Same Schedule Every Day","index":1,"n_rows":100,"n_cols":21,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,0,1,24],[15,20,15,24],[8,0,8,4],[13,0,13,4],[2,0,2,24],[13,10,13,15],[13,20,13,24],[8,20,8,24],[15,7,15,16],[7,0,7,4],[7,20,7,24],[8,8,8,15],[7,8,7,15],[18,13,18,16],[19,13,19,16],[34,13,34,16],[17,13,17,16],[16,13,16,16],[21,13,21,16],[22,13,22,16],[23,13,23,16],[24,13,24,16],[25,13,25,16],[81,0,81,24],[54,13,54,16],[55,13,55,16],[26,13,26,16],[27,13,27,16],[28,13,28,16],[29,13,29,16],[30,13,30,16],[43,13,43,16],[50,13,50,16],[35,13,35,16],[36,13,36,16],[37,13,37,16],[38,13,38,16],[39,13,39,16],[51,13,51,16],[99,0,106,24],[108,0,108,24],[61,13,61,16],[56,13,56,16],[57,13,57,16],[58,13,58,16],[59,13,59,16],[60,13,60,16],[82,0,82,24],[66,1,66,24],[67,0,67,24],[68,0,68,24],[77,0,77,24],[78,0,78,24],[79,0,79,24],[80,0,80,24],[52,13,52,16],[53,13,53,16],[20,13,20,16],[31,13,31,16],[32,13,32,16],[33,13,33,16],[44,13,44,16],[45,13,45,16],[46,13,46,16],[47,13,47,16],[48,13,48,16],[49,13,49,16],[40,13,40,16],[41,13,41,16],[42,13,42,16]]}
[]
["Bell Schedule Calculator"]
["Same Schedule Every Day"]
[]
[]
[]
[]
[]
["School Year",null,null,null,null,null,null,null,"District",null,null,null,null,null,null,null,null,null,null,null,"Building"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Every Day"]
[null,null,null,null,null,null,null,"Type","Start","End"]
[null,null,null,null,null,null,null,"of Time","Time","Time",null,null,"Min","District Notes"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H18,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M17,\">\"&\"00\")","v":0},{"$f":"IF(OR(H19=\"Lunch\",H19=\"Recess\",AND(K19=1,L19=1,H19=\"Passing\")), 0, IF(I19>J19,(J19+0.5)-I19,J19-I19))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H20,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M19,\">\"&\"00\")","v":0},{"$f":"IF(OR(H21=\"Lunch\",H21=\"Recess\",AND(K21=1,L21=1,H21=\"Passing\")), 0, IF(I21>J21,(J21+0.5)-I21,J21-I21))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H21,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M20,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H22,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M21,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M22,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M24,\">\"&\"00\")","v":0},{"$f":"IF(OR(H26=\"Lunch\",H26=\"Recess\",AND(K26=1,L26=1,H26=\"Passing\")), 0, IF(I26>J26,(J26+0.5)-I26,J26-I26))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M25,\">\"&\"00\")","v":0},{"$f":"IF(OR(H27=\"Lunch\",H27=\"Recess\",AND(K27=1,L27=1,H27=\"Passing\")), 0, IF(I27>J27,(J27+0.5)-I27,J27-I27))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H20,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M19,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H35,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M20,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M35,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H37,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M36,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M37,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M40,\">\"&\"00\")","v":0},{"$f":"IF(OR(H42=\"Lunch\",H42=\"Recess\",AND(K42=1,L42=1,H42=\"Passing\")), 0, IF(I42>J42,(J42+0.5)-I42,J42-I42))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M41,\">\"&\"00\")","v":0},{"$f":"IF(OR(H43=\"Lunch\",H43=\"Recess\",AND(K43=1,L43=1,H43=\"Passing\")), 0, IF(I43>J43,(J43+0.5)-I43,J43-I43))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H44,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M43,\">\"&\"00\")","v":0},{"$f":"IF(OR(H45=\"Lunch\",H45=\"Recess\",AND(K45=1,L45=1,H45=\"Passing\")), 0, IF(I45>J45,(J45+0.5)-I45,J45-I45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(H44,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(M43,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(M44,\">\"&\"00\")","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(M19:M61)","v":0}]
[]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bell Schedule Calculator\nUpdated 6/29/2023\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Block Schedule","index":2,"n_rows":110,"n_cols":41,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,0,1,33],[2,0,2,33],[10,2,10,7],[10,8,10,13],[10,14,10,19],[10,20,10,25],[10,26,10,31],[5,14,5,20],[5,27,5,33],[5,2,5,7],[10,33,12,33],[6,2,6,7],[6,27,6,33],[6,14,6,20],[99,2,99,33],[100,2,100,33],[96,3,96,33],[97,2,97,33],[98,2,98,33],[10,34,12,34],[53,33,55,33],[53,2,53,7],[53,8,53,13],[53,14,53,19],[53,20,53,25],[53,26,53,31],[109,1,116,33],[118,1,118,33],[101,2,101,33],[102,2,102,33],[103,2,103,33]]}
[]
["Bell Schedule Calculator"]
["Block Schedule"]
[]
[]
[]
[null,null,"School Year",null,null,null,null,null,null,null,null,null,null,null,"District",null,null,null,null,null,null,null,null,null,null,null,null,"Building"]
[]
[]
[null,null,"WEEK 1"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nWeek 1","CTE Contact Minutes"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-test","Period","Seq","P Num","Contact","Seminar"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,null,null,null,{"$f":"COUNTIF(C13,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H12,\">\"&\"00\")","v":0},{"$f":"IF(OR(C14=\"Lunch\",C14=\"Recess\",AND(F14=1,G14=1,C14=\"Passing\")), 0, IF(D14>E14,(E14+0.5)-D14,E14-D14))","v":0},null,null,null,{"$f":"COUNTIF(I13,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N12,\">\"&\"00\")","v":0},{"$f":"IF(OR(I14=\"Lunch\",I14=\"Recess\",AND(L14=1,M14=1,I14=\"Passing\")), 0, IF(J14>K14,(K14+0.5)-J14,K14-J14))","v":0},null,null,null,{"$f":"COUNTIF(O13,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T12,\">\"&\"00\")","v":0},{"$f":"IF(OR(O14=\"Lunch\",O14=\"Recess\",AND(R14=1,S14=1,O14=\"Passing\")), 0, IF(P14>Q14,(Q14+0.5)-P14,Q14-P14))","v":0},null,null,null,{"$f":"COUNTIF(U13,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z12,\">\"&\"00\")","v":0},{"$f":"IF(OR(U14=\"Lunch\",U14=\"Recess\",AND(X14=1,Y14=1,U14=\"Passing\")), 0, IF(V14>W14,(W14+0.5)-V14,W14-V14))","v":0},null,null,null,{"$f":"COUNTIF(AA13,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF12,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA14=\"Lunch\",AA14=\"Recess\",AND(AD14=1,AE14=1,AA14=\"Passing\")), 0, IF(AB14>AC14,(AC14+0.5)-AB14,AC14-AB14))","v":0},null,{"$f":"ROUND(((H14+N14+T14+Z14+AF14)/5)*1440,0)/1440","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C14)),ISNUMBER(SEARCH(\"*Period*\",I14)),ISNUMBER(SEARCH(\"*Period*\",O14)),ISNUMBER(SEARCH(\"*Period*\",U14)),ISNUMBER(SEARCH(\"*Period*\",AA14))),AH14,0)","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C14)),ISNUMBER(SEARCH(\"*Period*\",I14)),ISNUMBER(SEARCH(\"*Period*\",O14)),ISNUMBER(SEARCH(\"*Period*\",U14)),ISNUMBER(SEARCH(\"*Period*\",AA14))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C14:AA14,C14:AA14)=MAX(COUNTIF(C14:AA14,C14:AA14)),ROW(C14:AA14)*1000+COLUMN(C14:AA14))),\"0\\C000\"),0),\"\")","v":""},{"$f":"IF(AJ14=0, AJ57,AJ14)","v":""},{"$f":"IF(AM14=0,\"\",(MAX(AL$13:AL13)+1)*1)","v":""},{"$f":"IF(AK14=\"\",0,REPLACE(AK14,SEARCH(\" \",AK14,1),7,\"\"))","v":0},{"$f":"AI14","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C14)),ISNUMBER(SEARCH(\"*Seminar*\",I14)),ISNUMBER(SEARCH(\"*Seminar*\",O14)),ISNUMBER(SEARCH(\"*Seminar*\",U14)),ISNUMBER(SEARCH(\"*Seminar*\",AA14))),AH14,0)","v":0}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM15=0,\"\",(MAX(AL$13:AL14)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM16=0,\"\",(MAX(AL$13:AL15)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM17=0,\"\",(MAX(AL$13:AL16)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM18=0,\"\",(MAX(AL$13:AL17)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM19=0,\"\",(MAX(AL$13:AL18)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM20=0,\"\",(MAX(AL$13:AL19)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM21=0,\"\",(MAX(AL$13:AL20)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,{"$f":"COUNTIF(C21,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H20,\">\"&\"00\")","v":0},{"$f":"IF(OR(C22=\"Lunch\",C22=\"Recess\",AND(F22=1,G22=1,C22=\"Passing\")), 0, IF(D22>E22,(E22+0.5)-D22,E22-D22))","v":0},null,null,null,0,0,{"$f":"IF(OR(I22=\"Lunch\",I22=\"Recess\",AND(L22=1,M22=1,I22=\"Passing\")), 0, IF(J22>K22,(K22+0.5)-J22,K22-J22))","v":0},null,null,null,0,0,{"$f":"IF(OR(O22=\"Lunch\",O22=\"Recess\",AND(R22=1,S22=1,O22=\"Passing\")), 0, IF(P22>Q22,(Q22+0.5)-P22,Q22-P22))","v":0},null,null,null,0,0,{"$f":"IF(OR(U22=\"Lunch\",U22=\"Recess\",AND(X22=1,Y22=1,U22=\"Passing\")), 0, IF(V22>W22,(W22+0.5)-V22,W22-V22))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA22=\"Lunch\",AA22=\"Recess\",AND(AD22=1,AE22=1,AA22=\"Passing\")), 0, IF(AB22>AC22,(AC22+0.5)-AB22,AC22-AB22))","v":0},null,{"$f":"ROUND(((H22+N22+T22+Z22+AF22)/5)*1440,0)/1440","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C22)),ISNUMBER(SEARCH(\"*Period*\",I22)),ISNUMBER(SEARCH(\"*Period*\",O22)),ISNUMBER(SEARCH(\"*Period*\",U22)),ISNUMBER(SEARCH(\"*Period*\",AA22))),AH22,0)","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C22)),ISNUMBER(SEARCH(\"*Period*\",I22)),ISNUMBER(SEARCH(\"*Period*\",O22)),ISNUMBER(SEARCH(\"*Period*\",U22)),ISNUMBER(SEARCH(\"*Period*\",AA22))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C22:AA22,C22:AA22)=MAX(COUNTIF(C22:AA22,C22:AA22)),ROW(C22:AA22)*1000+COLUMN(C22:AA22))),\"0\\C000\"),0),\"\")","v":""},"",{"$f":"IF(AM22=0,\"\",(MAX(AL$13:AL21)+1)*1)","v":""},{"$f":"IF(AK22=\"\",0,REPLACE(AK22,SEARCH(\" \",AK22,1),7,\"\"))","v":0},{"$f":"AI22","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C22)),ISNUMBER(SEARCH(\"*Seminar*\",I22)),ISNUMBER(SEARCH(\"*Seminar*\",O22)),ISNUMBER(SEARCH(\"*Seminar*\",U22)),ISNUMBER(SEARCH(\"*Seminar*\",AA22))),AH22,0)","v":0}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM23=0,\"\",(MAX(AL$13:AL22)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM24=0,\"\",(MAX(AL$13:AL23)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM25=0,\"\",(MAX(AL$13:AL24)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,{"$f":"COUNTIF(C25,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H24,\">\"&\"00\")","v":0},{"$f":"IF(OR(C26=\"Lunch\",C26=\"Recess\",AND(F26=1,G26=1,C26=\"Passing\")), 0, IF(D26>E26,(E26+0.5)-D26,E26-D26))","v":0},null,null,null,0,0,{"$f":"IF(OR(I26=\"Lunch\",I26=\"Recess\",AND(L26=1,M26=1,I26=\"Passing\")), 0, IF(J26>K26,(K26+0.5)-J26,K26-J26))","v":0},null,null,null,0,0,{"$f":"IF(OR(O26=\"Lunch\",O26=\"Recess\",AND(R26=1,S26=1,O26=\"Passing\")), 0, IF(P26>Q26,(Q26+0.5)-P26,Q26-P26))","v":0},null,null,null,0,0,{"$f":"IF(OR(U26=\"Lunch\",U26=\"Recess\",AND(X26=1,Y26=1,U26=\"Passing\")), 0, IF(V26>W26,(W26+0.5)-V26,W26-V26))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA26=\"Lunch\",AA26=\"Recess\",AND(AD26=1,AE26=1,AA26=\"Passing\")), 0, IF(AB26>AC26,(AC26+0.5)-AB26,AC26-AB26))","v":0},null,{"$f":"ROUND(((H26+N26+T26+Z26+AF26)/5)*1440,0)/1440","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C26)),ISNUMBER(SEARCH(\"*Period*\",I26)),ISNUMBER(SEARCH(\"*Period*\",O26)),ISNUMBER(SEARCH(\"*Period*\",U26)),ISNUMBER(SEARCH(\"*Period*\",AA26))),AH26,0)","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C26)),ISNUMBER(SEARCH(\"*Period*\",I26)),ISNUMBER(SEARCH(\"*Period*\",O26)),ISNUMBER(SEARCH(\"*Period*\",U26)),ISNUMBER(SEARCH(\"*Period*\",AA26))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C26:AA26,C26:AA26)=MAX(COUNTIF(C26:AA26,C26:AA26)),ROW(C26:AA26)*1000+COLUMN(C26:AA26))),\"0\\C000\"),0),\"\")","v":""},{"$f":"IF(AJ26=0, AJ81,AJ26)","v":""},{"$f":"IF(AM26=0,\"\",(MAX(AL$13:AL25)+1)*1)","v":""},{"$f":"IF(AK26=\"\",0,REPLACE(AK26,SEARCH(\" \",AK26,1),7,\"\"))","v":0},{"$f":"AI26","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C26)),ISNUMBER(SEARCH(\"*Seminar*\",I26)),ISNUMBER(SEARCH(\"*Seminar*\",O26)),ISNUMBER(SEARCH(\"*Seminar*\",U26)),ISNUMBER(SEARCH(\"*Seminar*\",AA26))),AH26,0)","v":0}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM27=0,\"\",(MAX(AL$13:AL26)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM28=0,\"\",(MAX(AL$13:AL27)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM29=0,\"\",(MAX(AL$13:AL28)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,{"$f":"COUNTIF(C29,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H28,\">\"&\"00\")","v":0},{"$f":"IF(OR(C30=\"Lunch\",C30=\"Recess\",AND(F30=1,G30=1,C30=\"Passing\")), 0, IF(D30>E30,(E30+0.5)-D30,E30-D30))","v":0},null,null,null,0,0,{"$f":"IF(OR(I30=\"Lunch\",I30=\"Recess\",AND(L30=1,M30=1,I30=\"Passing\")), 0, IF(J30>K30,(K30+0.5)-J30,K30-J30))","v":0},null,null,null,0,0,{"$f":"IF(OR(O30=\"Lunch\",O30=\"Recess\",AND(R30=1,S30=1,O30=\"Passing\")), 0, IF(P30>Q30,(Q30+0.5)-P30,Q30-P30))","v":0},null,null,null,0,0,{"$f":"IF(OR(U30=\"Lunch\",U30=\"Recess\",AND(X30=1,Y30=1,U30=\"Passing\")), 0, IF(V30>W30,(W30+0.5)-V30,W30-V30))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA30=\"Lunch\",AA30=\"Recess\",AND(AD30=1,AE30=1,AA30=\"Passing\")), 0, IF(AB30>AC30,(AC30+0.5)-AB30,AC30-AB30))","v":0},null,{"$f":"ROUND(((H30+N30+T30+Z30+AF30)/5)*1440,0)/1440","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C30)),ISNUMBER(SEARCH(\"*Period*\",I30)),ISNUMBER(SEARCH(\"*Period*\",O30)),ISNUMBER(SEARCH(\"*Period*\",U30)),ISNUMBER(SEARCH(\"*Period*\",AA30))),AH30,0)","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C30)),ISNUMBER(SEARCH(\"*Period*\",I30)),ISNUMBER(SEARCH(\"*Period*\",O30)),ISNUMBER(SEARCH(\"*Period*\",U30)),ISNUMBER(SEARCH(\"*Period*\",AA30))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C30:AA30,C30:AA30)=MAX(COUNTIF(C30:AA30,C30:AA30)),ROW(C30:AA30)*1000+COLUMN(C30:AA30))),\"0\\C000\"),0),\"\")","v":""},"",{"$f":"IF(AM30=0,\"\",(MAX(AL$13:AL29)+1)*1)","v":""},{"$f":"IF(AK30=\"\",0,REPLACE(AK30,SEARCH(\" \",AK30,1),7,\"\"))","v":0},{"$f":"AI30","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C30)),ISNUMBER(SEARCH(\"*Seminar*\",I30)),ISNUMBER(SEARCH(\"*Seminar*\",O30)),ISNUMBER(SEARCH(\"*Seminar*\",U30)),ISNUMBER(SEARCH(\"*Seminar*\",AA30))),AH30,0)","v":0}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM31=0,\"\",(MAX(AL$13:AL30)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM32=0,\"\",(MAX(AL$13:AL31)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM33=0,\"\",(MAX(AL$13:AL32)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,{"$f":"COUNTIF(H32,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(N32,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(T32,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(Z32,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(AF32,\">\"&\"00\")","v":0},0,null,0,0,"",{"$f":"IF(AJ34=0, AJ65,AJ34)","v":""},{"$f":"IF(AM34=0,\"\",(MAX(AL$13:AL21)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,{"$f":"COUNTIF(H33,\">\"&\"00\")","v":0},{"$f":"IF(OR(C35=\"Lunch\",C35=\"Recess\",AND(F35=1,G35=1,C35=\"Passing\")), 0, IF(D35>E35,(E35+0.5)-D35,E35-D35))","v":0},null,null,null,0,{"$f":"COUNTIF(N33,\">\"&\"00\")","v":0},{"$f":"IF(OR(I35=\"Lunch\",I35=\"Recess\",AND(L35=1,M35=1,I35=\"Passing\")), 0, IF(J35>K35,(K35+0.5)-J35,K35-J35))","v":0},null,null,null,0,{"$f":"COUNTIF(T33,\">\"&\"00\")","v":0},{"$f":"IF(OR(O35=\"Lunch\",O35=\"Recess\",AND(R35=1,S35=1,O35=\"Passing\")), 0, IF(P35>Q35,(Q35+0.5)-P35,Q35-P35))","v":0},null,null,null,0,{"$f":"COUNTIF(Z33,\">\"&\"00\")","v":0},{"$f":"IF(OR(U35=\"Lunch\",U35=\"Recess\",AND(X35=1,Y35=1,U35=\"Passing\")), 0, IF(V35>W35,(W35+0.5)-V35,W35-V35))","v":0},null,null,null,0,{"$f":"COUNTIF(AF33,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA35=\"Lunch\",AA35=\"Recess\",AND(AD35=1,AE35=1,AA35=\"Passing\")), 0, IF(AB35>AC35,(AC35+0.5)-AB35,AC35-AB35))","v":0},null,0,0,"","",{"$f":"IF(AM35=0,\"\",(MAX(AL$13:AL34)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,{"$f":"COUNTIF(H34,\">\"&\"00\")","v":0},{"$f":"IF(OR(C36=\"Lunch\",C36=\"Recess\",AND(F36=1,G36=1,C36=\"Passing\")), 0, IF(D36>E36,(E36+0.5)-D36,E36-D36))","v":0},null,null,null,0,{"$f":"COUNTIF(N34,\">\"&\"00\")","v":0},{"$f":"IF(OR(I36=\"Lunch\",I36=\"Recess\",AND(L36=1,M36=1,I36=\"Passing\")), 0, IF(J36>K36,(K36+0.5)-J36,K36-J36))","v":0},null,null,null,0,{"$f":"COUNTIF(T34,\">\"&\"00\")","v":0},{"$f":"IF(OR(O36=\"Lunch\",O36=\"Recess\",AND(R36=1,S36=1,O36=\"Passing\")), 0, IF(P36>Q36,(Q36+0.5)-P36,Q36-P36))","v":0},null,null,null,0,{"$f":"COUNTIF(Z34,\">\"&\"00\")","v":0},{"$f":"IF(OR(U36=\"Lunch\",U36=\"Recess\",AND(X36=1,Y36=1,U36=\"Passing\")), 0, IF(V36>W36,(W36+0.5)-V36,W36-V36))","v":0},null,null,null,0,{"$f":"COUNTIF(AF34,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA36=\"Lunch\",AA36=\"Recess\",AND(AD36=1,AE36=1,AA36=\"Passing\")), 0, IF(AB36>AC36,(AC36+0.5)-AB36,AC36-AB36))","v":0},null,0,0,"","",{"$f":"IF(AM36=0,\"\",(MAX(AL$13:AL35)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,{"$f":"COUNTIF(H35,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(N35,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(T35,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(Z35,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(AF35,\">\"&\"00\")","v":0},0,null,0,0,"","",{"$f":"IF(AM37=0,\"\",(MAX(AL$13:AL36)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"",{"$f":"IF(AJ38=0, AJ81,AJ38)","v":""},{"$f":"IF(AM38=0,\"\",(MAX(AL$13:AL37)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM39=0,\"\",(MAX(AL$13:AL38)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM40=0,\"\",(MAX(AL$13:AL39)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM41=0,\"\",(MAX(AL$13:AL40)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM42=0,\"\",(MAX(AL$13:AL41)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM43=0,\"\",(MAX(AL$13:AL42)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM44=0,\"\",(MAX(AL$13:AL43)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM45=0,\"\",(MAX(AL$13:AL44)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM46=0,\"\",(MAX(AL$13:AL45)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM47=0,\"\",(MAX(AL$13:AL46)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM48=0,\"\",(MAX(AL$13:AL47)+1)*1)","v":""},0,0,0]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H14:H50)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(N14:N50)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(T14:T50)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(Z14:Z50)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(AF14:AF50)","v":0},null,{"$f":"ROUND(((H51+N51+T51+Z51+AF51)/5)*1440,0)/1440","v":0},{"$f":"SUM(AI14:AI48)","v":0},null,null,null,null,null,{"$f":"SUM(AO14:AO48)","v":0}]
[]
[null,null,"WEEK 2"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nBoth Weeks"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-Test"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,null,null,null,{"$f":"COUNTIF(C56,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H55,\">\"&\"00\")","v":0},{"$f":"IF(OR(C57=\"Lunch\",C57=\"Recess\",AND(F57=1,G57=1,C57=\"Passing\")), 0, IF(D57>E57,(E57+0.5)-D57,E57-D57))","v":0},null,null,null,{"$f":"COUNTIF(I56,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N55,\">\"&\"00\")","v":0},{"$f":"IF(OR(I57=\"Lunch\",I57=\"Recess\",AND(L57=1,M57=1,I57=\"Passing\")), 0, IF(J57>K57,(K57+0.5)-J57,K57-J57))","v":0},null,null,null,{"$f":"COUNTIF(O56,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T55,\">\"&\"00\")","v":0},{"$f":"IF(OR(O57=\"Lunch\",O57=\"Recess\",AND(R57=1,S57=1,O57=\"Passing\")), 0, IF(P57>Q57,(Q57+0.5)-P57,Q57-P57))","v":0},null,null,null,{"$f":"COUNTIF(U56,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z55,\">\"&\"00\")","v":0},{"$f":"IF(OR(U57=\"Lunch\",U57=\"Recess\",AND(X57=1,Y57=1,U57=\"Passing\")), 0, IF(V57>W57,(W57+0.5)-V57,W57-V57))","v":0},null,null,null,{"$f":"COUNTIF(AA56,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF55,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA57=\"Lunch\",AA57=\"Recess\",AND(AD57=1,AE57=1,AA57=\"Passing\")), 0, IF(AB57>AC57,(AC57+0.5)-AB57,AC57-AB57))","v":0},null,{"$f":"ROUND(((H57+N57+T57+Z57+AF57+H14+N14+T14+Z14+AF14)/10)*1440,0)/1440","v":0},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C57)),ISNUMBER(SEARCH(\"*Period*\",I57)),ISNUMBER(SEARCH(\"*Period*\",O57)),ISNUMBER(SEARCH(\"*Period*\",U57)),ISNUMBER(SEARCH(\"*Period*\",AA57))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C57:AA57,C57:AA57)=MAX(COUNTIF(C57:AA57,C57:AA57)),ROW(C57:AA57)*1000+COLUMN(C57:AA57))),\"0\\C000\"),0),\"\")","v":""},null,null,{"$f":"IF(AJ57=\"\",\"\",VALUE(LEFT(AJ57,1)))","v":""}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C66=\"Lunch\",C66=\"Recess\",AND(F66=1,G66=1,C66=\"Passing\")), 0, IF(D66>E66,(E66+0.5)-D66,E66-D66))","v":0},null,null,null,0,0,{"$f":"IF(OR(I66=\"Lunch\",I66=\"Recess\",AND(L66=1,M66=1,I66=\"Passing\")), 0, IF(J66>K66,(K66+0.5)-J66,K66-J66))","v":0},null,null,null,0,0,{"$f":"IF(OR(O66=\"Lunch\",O66=\"Recess\",AND(R66=1,S66=1,O66=\"Passing\")), 0, IF(P66>Q66,(Q66+0.5)-P66,Q66-P66))","v":0},null,null,null,0,0,{"$f":"IF(OR(U66=\"Lunch\",U66=\"Recess\",AND(X66=1,Y66=1,U66=\"Passing\")), 0, IF(V66>W66,(W66+0.5)-V66,W66-V66))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA66=\"Lunch\",AA66=\"Recess\",AND(AD66=1,AE66=1,AA66=\"Passing\")), 0, IF(AB66>AC66,(AC66+0.5)-AB66,AC66-AB66))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C67=\"Lunch\",C67=\"Recess\",AND(F67=1,G67=1,C67=\"Passing\")), 0, IF(D67>E67,(E67+0.5)-D67,E67-D67))","v":0},null,null,null,0,0,{"$f":"IF(OR(I67=\"Lunch\",I67=\"Recess\",AND(L67=1,M67=1,I67=\"Passing\")), 0, IF(J67>K67,(K67+0.5)-J67,K67-J67))","v":0},null,null,null,0,0,{"$f":"IF(OR(O67=\"Lunch\",O67=\"Recess\",AND(R67=1,S67=1,O67=\"Passing\")), 0, IF(P67>Q67,(Q67+0.5)-P67,Q67-P67))","v":0},null,null,null,0,0,{"$f":"IF(OR(U67=\"Lunch\",U67=\"Recess\",AND(X67=1,Y67=1,U67=\"Passing\")), 0, IF(V67>W67,(W67+0.5)-V67,W67-V67))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA67=\"Lunch\",AA67=\"Recess\",AND(AD67=1,AE67=1,AA67=\"Passing\")), 0, IF(AB67>AC67,(AC67+0.5)-AB67,AC67-AB67))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C69)),ISNUMBER(SEARCH(\"*Period*\",I69)),ISNUMBER(SEARCH(\"*Period*\",O69)),ISNUMBER(SEARCH(\"*Period*\",U69)),ISNUMBER(SEARCH(\"*Period*\",AA69))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C69:AA69,C69:AA69)=MAX(COUNTIF(C69:AA69,C69:AA69)),ROW(C69:AA69)*1000+COLUMN(C69:AA69))),\"0\\C000\"),0),\"\")","v":""},null,null,{"$f":"IF(AJ69=\"\",\"\",VALUE(LEFT(AJ69,1)))","v":""}]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C70=\"Lunch\",C70=\"Recess\",AND(F70=1,G70=1,C70=\"Passing\")), 0, IF(D70>E70,(E70+0.5)-D70,E70-D70))","v":0},null,null,null,0,0,{"$f":"IF(OR(I70=\"Lunch\",I70=\"Recess\",AND(L70=1,M70=1,I70=\"Passing\")), 0, IF(J70>K70,(K70+0.5)-J70,K70-J70))","v":0},null,null,null,0,0,{"$f":"IF(OR(O70=\"Lunch\",O70=\"Recess\",AND(R70=1,S70=1,O70=\"Passing\")), 0, IF(P70>Q70,(Q70+0.5)-P70,Q70-P70))","v":0},null,null,null,0,0,{"$f":"IF(OR(U70=\"Lunch\",U70=\"Recess\",AND(X70=1,Y70=1,U70=\"Passing\")), 0, IF(V70>W70,(W70+0.5)-V70,W70-V70))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA70=\"Lunch\",AA70=\"Recess\",AND(AD70=1,AE70=1,AA70=\"Passing\")), 0, IF(AB70>AC70,(AC70+0.5)-AB70,AC70-AB70))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C71=\"Lunch\",C71=\"Recess\",AND(F71=1,G71=1,C71=\"Passing\")), 0, IF(D71>E71,(E71+0.5)-D71,E71-D71))","v":0},null,null,null,0,0,{"$f":"IF(OR(I71=\"Lunch\",I71=\"Recess\",AND(L71=1,M71=1,I71=\"Passing\")), 0, IF(J71>K71,(K71+0.5)-J71,K71-J71))","v":0},null,null,null,0,0,{"$f":"IF(OR(O71=\"Lunch\",O71=\"Recess\",AND(R71=1,S71=1,O71=\"Passing\")), 0, IF(P71>Q71,(Q71+0.5)-P71,Q71-P71))","v":0},null,null,null,0,0,{"$f":"IF(OR(U71=\"Lunch\",U71=\"Recess\",AND(X71=1,Y71=1,U71=\"Passing\")), 0, IF(V71>W71,(W71+0.5)-V71,W71-V71))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA71=\"Lunch\",AA71=\"Recess\",AND(AD71=1,AE71=1,AA71=\"Passing\")), 0, IF(AB71>AC71,(AC71+0.5)-AB71,AC71-AB71))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C73)),ISNUMBER(SEARCH(\"*Period*\",I73)),ISNUMBER(SEARCH(\"*Period*\",O73)),ISNUMBER(SEARCH(\"*Period*\",U73)),ISNUMBER(SEARCH(\"*Period*\",AA73))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C73:AA73,C73:AA73)=MAX(COUNTIF(C73:AA73,C73:AA73)),ROW(C73:AA73)*1000+COLUMN(C73:AA73))),\"0\\C000\"),0),\"\")","v":""},null,null,{"$f":"IF(AJ73=\"\",\"\",VALUE(LEFT(AJ73,1)))","v":""}]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C74=\"Lunch\",C74=\"Recess\",AND(F74=1,G74=1,C74=\"Passing\")), 0, IF(D74>E74,(E74+0.5)-D74,E74-D74))","v":0},null,null,null,0,0,{"$f":"IF(OR(I74=\"Lunch\",I74=\"Recess\",AND(L74=1,M74=1,I74=\"Passing\")), 0, IF(J74>K74,(K74+0.5)-J74,K74-J74))","v":0},null,null,null,0,0,{"$f":"IF(OR(O74=\"Lunch\",O74=\"Recess\",AND(R74=1,S74=1,O74=\"Passing\")), 0, IF(P74>Q74,(Q74+0.5)-P74,Q74-P74))","v":0},null,null,null,0,0,{"$f":"IF(OR(U74=\"Lunch\",U74=\"Recess\",AND(X74=1,Y74=1,U74=\"Passing\")), 0, IF(V74>W74,(W74+0.5)-V74,W74-V74))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA74=\"Lunch\",AA74=\"Recess\",AND(AD74=1,AE74=1,AA74=\"Passing\")), 0, IF(AB74>AC74,(AC74+0.5)-AB74,AC74-AB74))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,{"$f":"IF(OR(C75=\"Lunch\",C75=\"Recess\",AND(F75=1,G75=1,C75=\"Passing\")), 0, IF(D75>E75,(E75+0.5)-D75,E75-D75))","v":0},null,null,null,0,0,{"$f":"IF(OR(I75=\"Lunch\",I75=\"Recess\",AND(L75=1,M75=1,I75=\"Passing\")), 0, IF(J75>K75,(K75+0.5)-J75,K75-J75))","v":0},null,null,null,0,0,{"$f":"IF(OR(O75=\"Lunch\",O75=\"Recess\",AND(R75=1,S75=1,O75=\"Passing\")), 0, IF(P75>Q75,(Q75+0.5)-P75,Q75-P75))","v":0},null,null,null,0,0,{"$f":"IF(OR(U75=\"Lunch\",U75=\"Recess\",AND(X75=1,Y75=1,U75=\"Passing\")), 0, IF(V75>W75,(W75+0.5)-V75,W75-V75))","v":0},null,null,null,0,0,{"$f":"IF(OR(AA75=\"Lunch\",AA75=\"Recess\",AND(AD75=1,AE75=1,AA75=\"Passing\")), 0, IF(AB75>AC75,(AC75+0.5)-AB75,AC75-AB75))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H75,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(N75,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(T75,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(Z75,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(AF75,\">\"&\"00\")","v":0},0,null,0,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C77)),ISNUMBER(SEARCH(\"*Period*\",I77)),ISNUMBER(SEARCH(\"*Period*\",O77)),ISNUMBER(SEARCH(\"*Period*\",U77)),ISNUMBER(SEARCH(\"*Period*\",AA77))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C77:AA77,C77:AA77)=MAX(COUNTIF(C77:AA77,C77:AA77)),ROW(C77:AA77)*1000+COLUMN(C77:AA77))),\"0\\C000\"),0),\"\")","v":""},null,null,{"$f":"IF(AJ77=\"\",\"\",VALUE(LEFT(AJ77,1)))","v":""}]
[null,null,null,null,null,0,{"$f":"COUNTIF(H76,\">\"&\"00\")","v":0},{"$f":"IF(OR(C78=\"Lunch\",C78=\"Recess\",AND(F78=1,G78=1,C78=\"Passing\")), 0, IF(D78>E78,(E78+0.5)-D78,E78-D78))","v":0},null,null,null,0,{"$f":"COUNTIF(N76,\">\"&\"00\")","v":0},{"$f":"IF(OR(I78=\"Lunch\",I78=\"Recess\",AND(L78=1,M78=1,I78=\"Passing\")), 0, IF(J78>K78,(K78+0.5)-J78,K78-J78))","v":0},null,null,null,0,{"$f":"COUNTIF(T76,\">\"&\"00\")","v":0},{"$f":"IF(OR(O78=\"Lunch\",O78=\"Recess\",AND(R78=1,S78=1,O78=\"Passing\")), 0, IF(P78>Q78,(Q78+0.5)-P78,Q78-P78))","v":0},null,null,null,0,{"$f":"COUNTIF(Z76,\">\"&\"00\")","v":0},{"$f":"IF(OR(U78=\"Lunch\",U78=\"Recess\",AND(X78=1,Y78=1,U78=\"Passing\")), 0, IF(V78>W78,(W78+0.5)-V78,W78-V78))","v":0},null,null,null,0,{"$f":"COUNTIF(AF76,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA78=\"Lunch\",AA78=\"Recess\",AND(AD78=1,AE78=1,AA78=\"Passing\")), 0, IF(AB78>AC78,(AC78+0.5)-AB78,AC78-AB78))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H77,\">\"&\"00\")","v":0},{"$f":"IF(OR(C79=\"Lunch\",C79=\"Recess\",AND(F79=1,G79=1,C79=\"Passing\")), 0, IF(D79>E79,(E79+0.5)-D79,E79-D79))","v":0},null,null,null,0,{"$f":"COUNTIF(N77,\">\"&\"00\")","v":0},{"$f":"IF(OR(I79=\"Lunch\",I79=\"Recess\",AND(L79=1,M79=1,I79=\"Passing\")), 0, IF(J79>K79,(K79+0.5)-J79,K79-J79))","v":0},null,null,null,0,{"$f":"COUNTIF(T77,\">\"&\"00\")","v":0},{"$f":"IF(OR(O79=\"Lunch\",O79=\"Recess\",AND(R79=1,S79=1,O79=\"Passing\")), 0, IF(P79>Q79,(Q79+0.5)-P79,Q79-P79))","v":0},null,null,null,0,{"$f":"COUNTIF(Z77,\">\"&\"00\")","v":0},{"$f":"IF(OR(U79=\"Lunch\",U79=\"Recess\",AND(X79=1,Y79=1,U79=\"Passing\")), 0, IF(V79>W79,(W79+0.5)-V79,W79-V79))","v":0},null,null,null,0,{"$f":"COUNTIF(AF77,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA79=\"Lunch\",AA79=\"Recess\",AND(AD79=1,AE79=1,AA79=\"Passing\")), 0, IF(AB79>AC79,(AC79+0.5)-AB79,AC79-AB79))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H78,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(N78,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(T78,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(Z78,\">\"&\"00\")","v":0},0,null,null,null,0,{"$f":"COUNTIF(AF78,\">\"&\"00\")","v":0},0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H57:H93)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(N57:N93)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(T57:T93)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(Z57:Z93)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(AF57:AF93)","v":0},null,{"$f":"ROUND(((H94+N94+T94+Z94+AF94+H51+N51+T51+Z51+AF51)/10)*1440,0)/1440","v":0}]
[]
[]
[null,null,"Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1116 Hour Building Log\nUpdated 6/29/2023\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example 1","index":3,"n_rows":79,"n_cols":41,"rows_kept":79,"cut":false,"hidden":false,"merged":[[14,34,16,34],[45,2,45,7],[45,8,45,13],[45,14,45,19],[45,20,45,25],[45,26,45,31],[45,33,47,33],[14,2,14,7],[14,8,14,13],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,33,16,33],[87,0,89,33],[5,0,5,33],[6,0,6,33],[10,2,10,7],[10,14,10,20],[10,27,10,33],[9,2,9,7],[9,14,9,20],[9,27,9,33],[78,0,85,33]]}
[]
[]
[]
[]
[]
["Bell Schedule Calculator"]
["Block Schedule"]
[]
[]
[null,null,"19/20",null,null,null,null,null,null,null,null,null,null,null,"USD 1001",null,null,null,null,null,null,null,null,null,null,null,null,"Sunflower High"]
[null,null,"School Year",null,null,null,null,null,null,null,null,null,null,null,"District",null,null,null,null,null,null,null,null,null,null,null,null,"Building"]
[]
[]
[null,null,"WEEK 1"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nWeek 1","CTE Contact Minutes"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-test","Period","Seq","P Num","Contact","Seminar"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,"1st period","06:50:00","07:46:00",{"$f":"COUNTIF(C17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H16,\">\"&\"00\")","v":0},{"$f":"IF(OR(C18=\"Lunch\",C18=\"Recess\",AND(F18=1,G18=1,C18=\"Passing\")), 0, IF(D18>E18,(E18+0.5)-D18,E18-D18))","v":3.8888888888888917E-2},"1st period","06:50:00","07:46:00",{"$f":"COUNTIF(I17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N16,\">\"&\"00\")","v":0},{"$f":"IF(OR(I18=\"Lunch\",I18=\"Recess\",AND(L18=1,M18=1,I18=\"Passing\")), 0, IF(J18>K18,(K18+0.5)-J18,K18-J18))","v":3.8888888888888917E-2},"1st period","06:50:00","07:46:00",{"$f":"COUNTIF(O17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T16,\">\"&\"00\")","v":0},{"$f":"IF(OR(O18=\"Lunch\",O18=\"Recess\",AND(R18=1,S18=1,O18=\"Passing\")), 0, IF(P18>Q18,(Q18+0.5)-P18,Q18-P18))","v":3.8888888888888917E-2},"1st period","06:50:00","07:46:00",{"$f":"COUNTIF(U17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z16,\">\"&\"00\")","v":0},{"$f":"IF(OR(U18=\"Lunch\",U18=\"Recess\",AND(X18=1,Y18=1,U18=\"Passing\")), 0, IF(V18>W18,(W18+0.5)-V18,W18-V18))","v":3.8888888888888917E-2},"1st period","06:50:00","07:37:00",{"$f":"COUNTIF(AA17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF16,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA18=\"Lunch\",AA18=\"Recess\",AND(AD18=1,AE18=1,AA18=\"Passing\")), 0, IF(AB18>AC18,(AC18+0.5)-AB18,AC18-AB18))","v":3.2638888888888939E-2},null,{"$f":"ROUND(((H18+N18+T18+Z18+AF18)/5)*1440,0)/1440","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C18)),ISNUMBER(SEARCH(\"*Period*\",I18)),ISNUMBER(SEARCH(\"*Period*\",O18)),ISNUMBER(SEARCH(\"*Period*\",U18)),ISNUMBER(SEARCH(\"*Period*\",AA18))),AH18,0)","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C18)),ISNUMBER(SEARCH(\"*Period*\",I18)),ISNUMBER(SEARCH(\"*Period*\",O18)),ISNUMBER(SEARCH(\"*Period*\",U18)),ISNUMBER(SEARCH(\"*Period*\",AA18))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C18:AA18,C18:AA18)=MAX(COUNTIF(C18:AA18,C18:AA18)),ROW(C18:AA18)*1000+COLUMN(C18:AA18))),\"0\\C000\"),0),\"\")","v":"1st period"},{"$f":"IF(AJ18=0, AJ49,AJ18)","v":"1st period"},{"$f":"IF(AM18=0,\"\",(MAX(AL$17:AL17)+1)*1)","v":1},{"$f":"IF(AK18=\"\",0,REPLACE(AK18,SEARCH(\" \",AK18,1),7,\"\"))","v":"1st"},{"$f":"AI18","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C18)),ISNUMBER(SEARCH(\"*Seminar*\",I18)),ISNUMBER(SEARCH(\"*Seminar*\",O18)),ISNUMBER(SEARCH(\"*Seminar*\",U18)),ISNUMBER(SEARCH(\"*Seminar*\",AA18))),AH18,0)","v":0}]
[null,null,"passing","07:46:00","07:51:00",0,0,3.4722222222222099E-3,"passing","07:46:00","07:51:00",0,0,3.4722222222222099E-3,"passing","07:46:00","07:51:00",0,0,3.4722222222222099E-3,"passing","07:46:00","07:51:00",0,0,3.4722222222222099E-3,"passing","07:37:00","07:42:00",0,0,3.4722222222222099E-3,null,3.472222222222222E-3,0,"","",{"$f":"IF(AM19=0,\"\",(MAX(AL$17:AL18)+1)*1)","v":""},0,0,0]
[null,null,"2nd period","07:51:00","08:48:00",0,1,3.9583333333333359E-2,"2nd period","07:51:00","08:48:00",0,1,3.9583333333333359E-2,"2nd period","07:51:00","08:48:00",0,1,3.9583333333333359E-2,"2nd period","07:51:00","08:48:00",0,1,3.9583333333333359E-2,"2nd period","07:42:00","08:29:00",0,1,3.2638888888888828E-2,null,3.8194444444444448E-2,3.8194444444444448E-2,"2nd period","2nd period",{"$f":"IF(AM20=0,\"\",(MAX(AL$17:AL19)+1)*1)","v":2},"2nd",3.8194444444444448E-2,0]
[null,null,"passing","08:48:00","08:53:00",0,1,3.4722222222221544E-3,"passing","08:48:00","08:53:00",0,1,3.4722222222221544E-3,"passing","08:48:00","08:53:00",0,1,3.4722222222221544E-3,"passing","08:48:00","08:53:00",0,1,3.4722222222221544E-3,"passing","08:29:00","08:34:00",0,1,3.4722222222222654E-3,null,3.472222222222222E-3,0,"","",{"$f":"IF(AM21=0,\"\",(MAX(AL$17:AL20)+1)*1)","v":""},0,0,0]
[null,null,"3rd period","08:53:00","09:48:00",0,1,3.8194444444444531E-2,"3rd period","08:53:00","09:48:00",0,1,3.8194444444444531E-2,"3rd period","08:53:00","09:48:00",0,1,3.8194444444444531E-2,"3rd period","08:53:00","09:48:00",0,1,3.8194444444444531E-2,"3rd period","08:34:00","09:21:00",0,1,3.2638888888888884E-2,null,3.6805555555555557E-2,3.6805555555555557E-2,"3rd period","3rd period",{"$f":"IF(AM22=0,\"\",(MAX(AL$17:AL21)+1)*1)","v":3},"3rd",3.6805555555555557E-2,0]
[null,null,"passing","09:48:00","09:53:00",0,1,3.4722222222221544E-3,"passing","09:48:00","09:53:00",0,1,3.4722222222221544E-3,"passing","09:48:00","09:53:00",0,1,3.4722222222221544E-3,"passing","09:48:00","09:53:00",0,1,3.4722222222221544E-3,"passing","09:21:00","09:26:00",0,1,3.4722222222222099E-3,null,3.472222222222222E-3,0,"","",{"$f":"IF(AM23=0,\"\",(MAX(AL$17:AL22)+1)*1)","v":""},0,0,0]
[null,null,"4th period","09:53:00","10:48:00",0,1,3.8194444444444475E-2,"4th period","09:53:00","10:48:00",0,1,3.8194444444444475E-2,"4th period","09:53:00","10:48:00",0,1,3.8194444444444475E-2,"4th period","09:53:00","10:48:00",0,1,3.8194444444444475E-2,"4th period","09:26:00","10:13:00",0,1,3.2638888888888884E-2,null,3.6805555555555557E-2,3.6805555555555557E-2,"4th period","4th period",{"$f":"IF(AM24=0,\"\",(MAX(AL$17:AL23)+1)*1)","v":4},"4th",3.6805555555555557E-2,0]
[null,null,"passing","10:48:00","10:48:00",0,1,0,"passing","10:48:00","10:48:00",0,1,0,"passing","10:48:00","10:48:00",0,1,0,"passing","10:48:00","10:48:00",0,1,0,"passing","10:13:00","10:18:00",0,1,3.4722222222222654E-3,null,6.9444444444444447E-4,0,"","",{"$f":"IF(AM25=0,\"\",(MAX(AL$17:AL24)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,"Advocacy","10:18:00","11:14:00",0,1,3.8888888888888806E-2,null,7.6388888888888886E-3,0,"","",{"$f":"IF(AM26=0,\"\",(MAX(AL$17:AL25)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,{"$f":"COUNTIF(H25,\">\"&\"00\")","v":0},{"$f":"IF(OR(C27=\"Lunch\",C27=\"Recess\",AND(F27=1,G27=1,C27=\"Passing\")), 0, IF(D27>E27,(E27+0.5)-D27,E27-D27))","v":0},null,null,null,0,{"$f":"COUNTIF(N25,\">\"&\"00\")","v":0},{"$f":"IF(OR(I27=\"Lunch\",I27=\"Recess\",AND(L27=1,M27=1,I27=\"Passing\")), 0, IF(J27>K27,(K27+0.5)-J27,K27-J27))","v":0},null,null,null,0,{"$f":"COUNTIF(T25,\">\"&\"00\")","v":0},{"$f":"IF(OR(O27=\"Lunch\",O27=\"Recess\",AND(R27=1,S27=1,O27=\"Passing\")), 0, IF(P27>Q27,(Q27+0.5)-P27,Q27-P27))","v":0},null,null,null,0,{"$f":"COUNTIF(Z25,\">\"&\"00\")","v":0},{"$f":"IF(OR(U27=\"Lunch\",U27=\"Recess\",AND(X27=1,Y27=1,U27=\"Passing\")), 0, IF(V27>W27,(W27+0.5)-V27,W27-V27))","v":0},"passing","11:14:00","11:14:00",0,{"$f":"COUNTIF(AF25,\">\"&\"00\")","v":1},{"$f":"IF(OR(AA27=\"Lunch\",AA27=\"Recess\",AND(AD27=1,AE27=1,AA27=\"Passing\")), 0, IF(AB27>AC27,(AC27+0.5)-AB27,AC27-AB27))","v":0},null,0,0,"","",{"$f":"IF(AM27=0,\"\",(MAX(AL$17:AL26)+1)*1)","v":""},0,0,0]
[null,null,"Lunch","10:48:00","11:33:00",0,{"$f":"COUNTIF(H26,\">\"&\"00\")","v":0},{"$f":"IF(OR(C28=\"Lunch\",C28=\"Recess\",AND(F28=1,G28=1,C28=\"Passing\")), 0, IF(D28>E28,(E28+0.5)-D28,E28-D28))","v":0},"Lunch","10:48:00","11:33:00",0,{"$f":"COUNTIF(N26,\">\"&\"00\")","v":0},{"$f":"IF(OR(I28=\"Lunch\",I28=\"Recess\",AND(L28=1,M28=1,I28=\"Passing\")), 0, IF(J28>K28,(K28+0.5)-J28,K28-J28))","v":0},"Lunch","10:48:00","11:33:00",0,{"$f":"COUNTIF(T26,\">\"&\"00\")","v":0},{"$f":"IF(OR(O28=\"Lunch\",O28=\"Recess\",AND(R28=1,S28=1,O28=\"Passing\")), 0, IF(P28>Q28,(Q28+0.5)-P28,Q28-P28))","v":0},"Lunch","10:48:00","11:33:00",0,{"$f":"COUNTIF(Z26,\">\"&\"00\")","v":0},{"$f":"IF(OR(U28=\"Lunch\",U28=\"Recess\",AND(X28=1,Y28=1,U28=\"Passing\")), 0, IF(V28>W28,(W28+0.5)-V28,W28-V28))","v":0},"Lunch","11:14:00","11:59:00",0,{"$f":"COUNTIF(AF26,\">\"&\"00\")","v":1},{"$f":"IF(OR(AA28=\"Lunch\",AA28=\"Recess\",AND(AD28=1,AE28=1,AA28=\"Passing\")), 0, IF(AB28>AC28,(AC28+0.5)-AB28,AC28-AB28))","v":0},null,0,0,"","",{"$f":"IF(AM28=0,\"\",(MAX(AL$17:AL27)+1)*1)","v":""},0,0,0]
[null,null,"passing","11:33:00","11:33:00",1,0,0,"passing","11:33:00","11:33:00",1,0,0,"passing","11:33:00","11:33:00",1,0,0,"passing","11:33:00","11:33:00",1,0,0,"passing","11:59:00","11:59:00",1,0,0,null,0,0,"","",{"$f":"IF(AM29=0,\"\",(MAX(AL$17:AL28)+1)*1)","v":""},0,0,0]
[null,null,"5th period","11:33:00","12:28:00",0,0,3.8194444444444475E-2,"5th period","11:33:00","12:28:00",0,0,3.8194444444444475E-2,"5th period","11:33:00","12:28:00",0,0,3.8194444444444475E-2,"5th period","11:33:00","12:28:00",0,0,3.8194444444444475E-2,"5th period","11:59:00","12:46:00",0,0,3.2638888888888939E-2,null,3.6805555555555557E-2,3.6805555555555557E-2,"5th period","5th period",{"$f":"IF(AM30=0,\"\",(MAX(AL$17:AL29)+1)*1)","v":5},"5th",3.6805555555555557E-2,0]
[null,null,"passing","12:28:00","12:33:00",0,0,3.4722222222222099E-3,"passing","12:28:00","12:33:00",0,0,3.4722222222222099E-3,"passing","12:28:00","12:33:00",0,0,3.4722222222222099E-3,"passing","12:28:00","12:33:00",0,0,3.4722222222222099E-3,"passing","12:46:00","12:51:00",0,0,3.4722222222222099E-3,null,3.472222222222222E-3,0,"","",{"$f":"IF(AM31=0,\"\",(MAX(AL$17:AL30)+1)*1)","v":""},0,0,0]
[null,null,"6th period","12:33:00","01:28:00",0,1,3.819444444444442E-2,"6th period","12:33:00","01:28:00",0,1,3.819444444444442E-2,"6th period","12:33:00","01:28:00",0,1,3.819444444444442E-2,"6th period","12:33:00","01:28:00",0,1,3.819444444444442E-2,"6th period","12:51:00","01:38:00",0,1,3.2638888888888884E-2,null,3.6805555555555557E-2,3.6805555555555557E-2,"6th period","6th period",{"$f":"IF(AM32=0,\"\",(MAX(AL$17:AL31)+1)*1)","v":6},"6th",3.6805555555555557E-2,0]
[null,null,"passing","01:28:00","01:33:00",0,1,3.4722222222222238E-3,"passing","01:28:00","01:33:00",0,1,3.4722222222222238E-3,"passing","01:28:00","01:33:00",0,1,3.4722222222222238E-3,"passing","01:28:00","01:33:00",0,1,3.4722222222222238E-3,"passing","01:38:00","01:43:00",0,1,3.4722222222222376E-3,null,3.472222222222222E-3,0,"","",{"$f":"IF(AM33=0,\"\",(MAX(AL$17:AL32)+1)*1)","v":""},0,0,0]
[null,null,"7th period","01:33:00","02:30:00",0,1,3.9583333333333331E-2,"7th period","01:33:00","02:30:00",0,1,3.9583333333333331E-2,"7th period","01:33:00","02:30:00",0,1,3.9583333333333331E-2,"7th period","01:33:00","02:30:00",0,1,3.9583333333333331E-2,"7th period","01:43:00","02:30:00",0,1,3.2638888888888884E-2,null,3.8194444444444448E-2,3.8194444444444448E-2,"7th period","7th period",{"$f":"IF(AM34=0,\"\",(MAX(AL$17:AL33)+1)*1)","v":7},"7th",3.8194444444444448E-2,0]
[null,null,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,0,0,"","",{"$f":"IF(AM35=0,\"\",(MAX(AL$17:AL34)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,0,0,"","",{"$f":"IF(AM36=0,\"\",(MAX(AL$17:AL35)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM37=0,\"\",(MAX(AL$17:AL36)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM38=0,\"\",(MAX(AL$17:AL37)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM39=0,\"\",(MAX(AL$17:AL38)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM40=0,\"\",(MAX(AL$17:AL39)+1)*1)","v":""},0,0,0]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H18:H42)","v":0.28819444444444442},null,null,"Total Minutes",null,null,{"$f":"SUM(N18:N42)","v":0.28819444444444442},null,null,"Total Minutes",null,null,{"$f":"SUM(T18:T42)","v":0.28819444444444442},null,null,"Total Minutes",null,null,{"$f":"SUM(Z18:Z42)","v":0.28819444444444442},null,null,"Total Minutes",null,null,{"$f":"SUM(AF18:AF42)","v":0.28819444444444442},null,{"$f":"ROUND(((H43+N43+T43+Z43+AF43)/5)*1440,0)/1440","v":0.28819444444444442},{"$f":"SUM(AI18:AI40)","v":0.26111111111111118},null,null,null,null,null,{"$f":"SUM(AO18:AO40)","v":0}]
[]
[null,null,"WEEK 2"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nBoth Weeks"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-Test"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,null,null,null,{"$f":"COUNTIF(C48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H47,\">\"&\"00\")","v":0},{"$f":"IF(OR(C49=\"Lunch\",C49=\"Recess\",AND(F49=1,G49=1,C49=\"Passing\")), 0, IF(D49>E49,(E49+0.5)-D49,E49-D49))","v":0},null,null,null,{"$f":"COUNTIF(I48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N47,\">\"&\"00\")","v":0},{"$f":"IF(OR(I49=\"Lunch\",I49=\"Recess\",AND(L49=1,M49=1,I49=\"Passing\")), 0, IF(J49>K49,(K49+0.5)-J49,K49-J49))","v":0},null,null,null,{"$f":"COUNTIF(O48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T47,\">\"&\"00\")","v":0},{"$f":"IF(OR(O49=\"Lunch\",O49=\"Recess\",AND(R49=1,S49=1,O49=\"Passing\")), 0, IF(P49>Q49,(Q49+0.5)-P49,Q49-P49))","v":0},null,null,null,{"$f":"COUNTIF(U48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z47,\">\"&\"00\")","v":0},{"$f":"IF(OR(U49=\"Lunch\",U49=\"Recess\",AND(X49=1,Y49=1,U49=\"Passing\")), 0, IF(V49>W49,(W49+0.5)-V49,W49-V49))","v":0},null,null,null,{"$f":"COUNTIF(AA48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF47,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA49=\"Lunch\",AA49=\"Recess\",AND(AD49=1,AE49=1,AA49=\"Passing\")), 0, IF(AB49>AC49,(AC49+0.5)-AB49,AC49-AB49))","v":0},null,{"$f":"ROUND(((H49+N49+T49+Z49+AF49+H18+N18+T18+Z18+AF18)/10)*1440,0)/1440","v":1.8749999999999999E-2},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C49)),ISNUMBER(SEARCH(\"*Period*\",I49)),ISNUMBER(SEARCH(\"*Period*\",O49)),ISNUMBER(SEARCH(\"*Period*\",U49)),ISNUMBER(SEARCH(\"*Period*\",AA49))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C49:AA49,C49:AA49)=MAX(COUNTIF(C49:AA49,C49:AA49)),ROW(C49:AA49)*1000+COLUMN(C49:AA49))),\"0\\C000\"),0),\"\")","v":""},null,null,{"$f":"IF(AJ49=\"\",\"\",VALUE(LEFT(AJ49,1)))","v":""}]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.9444444444444445E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.8749999999999999E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.8749999999999999E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,6.9444444444444447E-4,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,4.1666666666666666E-3,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H56,\">\"&\"00\")","v":0},{"$f":"IF(OR(C58=\"Lunch\",C58=\"Recess\",AND(F58=1,G58=1,C58=\"Passing\")), 0, IF(D58>E58,(E58+0.5)-D58,E58-D58))","v":0},null,null,null,0,{"$f":"COUNTIF(N56,\">\"&\"00\")","v":0},{"$f":"IF(OR(I58=\"Lunch\",I58=\"Recess\",AND(L58=1,M58=1,I58=\"Passing\")), 0, IF(J58>K58,(K58+0.5)-J58,K58-J58))","v":0},null,null,null,0,{"$f":"COUNTIF(T56,\">\"&\"00\")","v":0},{"$f":"IF(OR(O58=\"Lunch\",O58=\"Recess\",AND(R58=1,S58=1,O58=\"Passing\")), 0, IF(P58>Q58,(Q58+0.5)-P58,Q58-P58))","v":0},null,null,null,0,{"$f":"COUNTIF(Z56,\">\"&\"00\")","v":0},{"$f":"IF(OR(U58=\"Lunch\",U58=\"Recess\",AND(X58=1,Y58=1,U58=\"Passing\")), 0, IF(V58>W58,(W58+0.5)-V58,W58-V58))","v":0},null,null,null,0,{"$f":"COUNTIF(AF56,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA58=\"Lunch\",AA58=\"Recess\",AND(AD58=1,AE58=1,AA58=\"Passing\")), 0, IF(AB58>AC58,(AC58+0.5)-AB58,AC58-AB58))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H57,\">\"&\"00\")","v":0},{"$f":"IF(OR(C59=\"Lunch\",C59=\"Recess\",AND(F59=1,G59=1,C59=\"Passing\")), 0, IF(D59>E59,(E59+0.5)-D59,E59-D59))","v":0},null,null,null,0,{"$f":"COUNTIF(N57,\">\"&\"00\")","v":0},{"$f":"IF(OR(I59=\"Lunch\",I59=\"Recess\",AND(L59=1,M59=1,I59=\"Passing\")), 0, IF(J59>K59,(K59+0.5)-J59,K59-J59))","v":0},null,null,null,0,{"$f":"COUNTIF(T57,\">\"&\"00\")","v":0},{"$f":"IF(OR(O59=\"Lunch\",O59=\"Recess\",AND(R59=1,S59=1,O59=\"Passing\")), 0, IF(P59>Q59,(Q59+0.5)-P59,Q59-P59))","v":0},null,null,null,0,{"$f":"COUNTIF(Z57,\">\"&\"00\")","v":0},{"$f":"IF(OR(U59=\"Lunch\",U59=\"Recess\",AND(X59=1,Y59=1,U59=\"Passing\")), 0, IF(V59>W59,(W59+0.5)-V59,W59-V59))","v":0},null,null,null,0,{"$f":"COUNTIF(AF57,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA59=\"Lunch\",AA59=\"Recess\",AND(AD59=1,AE59=1,AA59=\"Passing\")), 0, IF(AB59>AC59,(AC59+0.5)-AB59,AC59-AB59))","v":0},null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.8749999999999999E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.8749999999999999E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,2.0833333333333333E-3,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,1.9444444444444445E-2,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H49:H73)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(N49:N73)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(T49:T73)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(Z49:Z73)","v":0},null,null,"Total Minutes",null,null,{"$f":"SUM(AF49:AF73)","v":0},null,{"$f":"ROUND(((H43+N43+T43+Z43+AF43+H74+N74+T74+Z74+AF74)/10)*1440,0)/1440","v":0.14444444444444443}]
[]
[]
[]
[]
["Bell Schedule Calculator\nUpdated 6/10/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example 2","index":4,"n_rows":79,"n_cols":41,"rows_kept":79,"cut":false,"hidden":false,"merged":[[14,34,16,34],[45,2,45,7],[45,8,45,13],[45,14,45,19],[45,20,45,25],[45,26,45,31],[45,33,47,33],[14,2,14,7],[14,8,14,13],[14,14,14,19],[14,20,14,25],[14,26,14,31],[14,33,16,33],[87,0,89,33],[10,2,10,7],[10,14,10,20],[10,27,10,33],[5,0,5,33],[6,0,6,33],[9,2,9,7],[9,14,9,20],[9,27,9,33],[78,0,85,33]]}
[]
[]
[]
[]
[]
["Bell Schedule Calculator"]
["Block Schedule"]
[]
[]
[null,null,"19/20",null,null,null,null,null,null,null,null,null,null,null,"USD 3001"]
[null,null,"School Year",null,null,null,null,null,null,null,null,null,null,null,"District",null,null,null,null,null,null,null,null,null,null,null,null,"Building"]
[]
[]
[null,null,"WEEK 1"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nWeek 1","CTE Contact Minutes"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-test","Period","Seq","P Num","Contact","Seminar"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(C17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H16,\">\"&\"00\")","v":0},{"$f":"IF(OR(C18=\"Lunch\",C18=\"Recess\",AND(F18=1,G18=1,C18=\"Passing\")), 0, IF(D18>E18,(E18+0.5)-D18,E18-D18))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(I17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N16,\">\"&\"00\")","v":0},{"$f":"IF(OR(I18=\"Lunch\",I18=\"Recess\",AND(L18=1,M18=1,I18=\"Passing\")), 0, IF(J18>K18,(K18+0.5)-J18,K18-J18))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(O17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T16,\">\"&\"00\")","v":0},{"$f":"IF(OR(O18=\"Lunch\",O18=\"Recess\",AND(R18=1,S18=1,O18=\"Passing\")), 0, IF(P18>Q18,(Q18+0.5)-P18,Q18-P18))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(U17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z16,\">\"&\"00\")","v":0},{"$f":"IF(OR(U18=\"Lunch\",U18=\"Recess\",AND(X18=1,Y18=1,U18=\"Passing\")), 0, IF(V18>W18,(W18+0.5)-V18,W18-V18))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(AA17,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF16,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA18=\"Lunch\",AA18=\"Recess\",AND(AD18=1,AE18=1,AA18=\"Passing\")), 0, IF(AB18>AC18,(AC18+0.5)-AB18,AC18-AB18))","v":6.25E-2},null,{"$f":"ROUND(((H18+N18+T18+Z18+AF18)/5)*1440,0)/1440","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C18)),ISNUMBER(SEARCH(\"*Period*\",I18)),ISNUMBER(SEARCH(\"*Period*\",O18)),ISNUMBER(SEARCH(\"*Period*\",U18)),ISNUMBER(SEARCH(\"*Period*\",AA18))),AH18,0)","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C18)),ISNUMBER(SEARCH(\"*Period*\",I18)),ISNUMBER(SEARCH(\"*Period*\",O18)),ISNUMBER(SEARCH(\"*Period*\",U18)),ISNUMBER(SEARCH(\"*Period*\",AA18))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C18:AA18,C18:AA18)=MAX(COUNTIF(C18:AA18,C18:AA18)),ROW(C18:AA18)*1000+COLUMN(C18:AA18))),\"0\\C000\"),0),\"\")","v":"1st period"},{"$f":"IF(AJ18=0, AJ49,AJ18)","v":"1st period"},{"$f":"IF(AM18=0,\"\",(MAX(AL$17:AL17)+1)*1)","v":1},{"$f":"IF(AK18=\"\",0,REPLACE(AK18,SEARCH(\" \",AK18,1),7,\"\"))","v":"1st"},{"$f":"AI18","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C18)),ISNUMBER(SEARCH(\"*Seminar*\",I18)),ISNUMBER(SEARCH(\"*Seminar*\",O18)),ISNUMBER(SEARCH(\"*Seminar*\",U18)),ISNUMBER(SEARCH(\"*Seminar*\",AA18))),AH18,0)","v":0}]
[null,null,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,0,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,0,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,2.0833333333333333E-3,0,"","",{"$f":"IF(AM19=0,\"\",(MAX(AL$17:AL18)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,null,2.5000000000000001E-2,2.5000000000000001E-2,0,"2nd period",{"$f":"IF(AM20=0,\"\",(MAX(AL$17:AL19)+1)*1)","v":2},"2nd",2.5000000000000001E-2,0]
[null,null,null,null,null,0,1,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,null,1.3888888888888889E-3,0,"","",{"$f":"IF(AM21=0,\"\",(MAX(AL$17:AL20)+1)*1)","v":""},0,0,0]
[null,null,"3rd period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"3rd period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"3rd period","09:25:00","10:55:00",0,0,6.25E-2,null,3.7499999999999999E-2,3.7499999999999999E-2,"3rd period","3rd period",{"$f":"IF(AM22=0,\"\",(MAX(AL$17:AL21)+1)*1)","v":3},"3rd",3.7499999999999999E-2,0]
[null,null,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,0,0,"","",{"$f":"IF(AM23=0,\"\",(MAX(AL$17:AL22)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"4th  period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"4th  period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,null,2.5000000000000001E-2,2.5000000000000001E-2,0,"4th  period",{"$f":"IF(AM24=0,\"\",(MAX(AL$17:AL23)+1)*1)","v":4},"4thd",2.5000000000000001E-2,0]
[null,null,null,null,null,0,0,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,0,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM25=0,\"\",(MAX(AL$17:AL24)+1)*1)","v":""},0,0,0]
[null,null,"Lunch","10:55:00","11:35:00",0,0,0,"Lunch","10:55:00","11:35:00",0,1,0,"Lunch","10:55:00","11:35:00",0,0,0,"Lunch","10:55:00","11:35:00",0,1,0,"Lunch","10:55:00","11:35:00",0,0,0,null,0,0,"","",{"$f":"IF(AM26=0,\"\",(MAX(AL$17:AL25)+1)*1)","v":""},0,0,0]
[null,null,"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(H25,\">\"&\"00\")","v":0},{"$f":"IF(OR(C27=\"Lunch\",C27=\"Recess\",AND(F27=1,G27=1,C27=\"Passing\")), 0, IF(D27>E27,(E27+0.5)-D27,E27-D27))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(N25,\">\"&\"00\")","v":0},{"$f":"IF(OR(I27=\"Lunch\",I27=\"Recess\",AND(L27=1,M27=1,I27=\"Passing\")), 0, IF(J27>K27,(K27+0.5)-J27,K27-J27))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(T25,\">\"&\"00\")","v":0},{"$f":"IF(OR(O27=\"Lunch\",O27=\"Recess\",AND(R27=1,S27=1,O27=\"Passing\")), 0, IF(P27>Q27,(Q27+0.5)-P27,Q27-P27))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(Z25,\">\"&\"00\")","v":0},{"$f":"IF(OR(U27=\"Lunch\",U27=\"Recess\",AND(X27=1,Y27=1,U27=\"Passing\")), 0, IF(V27>W27,(W27+0.5)-V27,W27-V27))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(AF25,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA27=\"Lunch\",AA27=\"Recess\",AND(AD27=1,AE27=1,AA27=\"Passing\")), 0, IF(AB27>AC27,(AC27+0.5)-AB27,AC27-AB27))","v":3.4722222222222099E-3},null,3.472222222222222E-3,0,"","",{"$f":"IF(AM27=0,\"\",(MAX(AL$17:AL26)+1)*1)","v":""},0,0,0]
[null,null,"5th","11:40:00","01:10:00",0,{"$f":"COUNTIF(H26,\">\"&\"00\")","v":0},{"$f":"IF(OR(C28=\"Lunch\",C28=\"Recess\",AND(F28=1,G28=1,C28=\"Passing\")), 0, IF(D28>E28,(E28+0.5)-D28,E28-D28))","v":6.2500000000000056E-2},null,null,null,0,{"$f":"COUNTIF(N26,\">\"&\"00\")","v":0},{"$f":"IF(OR(I28=\"Lunch\",I28=\"Recess\",AND(L28=1,M28=1,I28=\"Passing\")), 0, IF(J28>K28,(K28+0.5)-J28,K28-J28))","v":0},"5th","11:40:00","01:10:00",0,{"$f":"COUNTIF(T26,\">\"&\"00\")","v":0},{"$f":"IF(OR(O28=\"Lunch\",O28=\"Recess\",AND(R28=1,S28=1,O28=\"Passing\")), 0, IF(P28>Q28,(Q28+0.5)-P28,Q28-P28))","v":6.2500000000000056E-2},null,null,null,0,{"$f":"COUNTIF(Z26,\">\"&\"00\")","v":0},{"$f":"IF(OR(U28=\"Lunch\",U28=\"Recess\",AND(X28=1,Y28=1,U28=\"Passing\")), 0, IF(V28>W28,(W28+0.5)-V28,W28-V28))","v":0},"5th","11:40:00","01:10:00",0,{"$f":"COUNTIF(AF26,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA28=\"Lunch\",AA28=\"Recess\",AND(AD28=1,AE28=1,AA28=\"Passing\")), 0, IF(AB28>AC28,(AC28+0.5)-AB28,AC28-AB28))","v":6.2500000000000056E-2},null,3.7499999999999999E-2,0,"","",{"$f":"IF(AM28=0,\"\",(MAX(AL$17:AL27)+1)*1)","v":""},0,0,0]
[null,null,"passing","01:10:00","01:15:00",0,1,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,1,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,1,3.4722222222222238E-3,null,2.0833333333333333E-3,0,"","",{"$f":"IF(AM29=0,\"\",(MAX(AL$17:AL28)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"6th period","11:40:00","01:10:00",0,0,6.2500000000000056E-2,null,null,null,0,1,0,"6th period","11:40:00","01:10:00",0,0,6.2500000000000056E-2,null,null,null,0,1,0,null,2.5000000000000001E-2,2.5000000000000001E-2,0,"6th period",{"$f":"IF(AM30=0,\"\",(MAX(AL$17:AL29)+1)*1)","v":5},"6th",2.5000000000000001E-2,0]
[null,null,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,0,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,0,3.4722222222222238E-3,null,null,null,0,1,0,null,1.3888888888888889E-3,0,"","",{"$f":"IF(AM31=0,\"\",(MAX(AL$17:AL30)+1)*1)","v":""},0,0,0]
[null,null,"7th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"7th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"7th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,3.7499999999999999E-2,3.7499999999999999E-2,"7th period","7th period",{"$f":"IF(AM32=0,\"\",(MAX(AL$17:AL31)+1)*1)","v":6},"7th",3.7499999999999999E-2,0]
[null,null,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,2.0833333333333333E-3,0,"","",{"$f":"IF(AM33=0,\"\",(MAX(AL$17:AL32)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"8th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"8th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,null,2.5000000000000001E-2,2.5000000000000001E-2,0,"8th period",{"$f":"IF(AM34=0,\"\",(MAX(AL$17:AL33)+1)*1)","v":7},"8th",2.5000000000000001E-2,0]
[null,null,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,null,1.3888888888888889E-3,0,"","",{"$f":"IF(AM35=0,\"\",(MAX(AL$17:AL34)+1)*1)","v":""},0,0,0]
[null,null,"Seminar","02:50:00","03:30:00",0,0,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,1,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,0,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,1,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,2.7777777777777776E-2,0,"","",{"$f":"IF(AM36=0,\"\",(MAX(AL$17:AL35)+1)*1)","v":""},0,0,2.7777777777777776E-2]
[null,null,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM37=0,\"\",(MAX(AL$17:AL36)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,0,0,"","",{"$f":"IF(AM38=0,\"\",(MAX(AL$17:AL37)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM39=0,\"\",(MAX(AL$17:AL38)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM40=0,\"\",(MAX(AL$17:AL39)+1)*1)","v":""},0,0,0]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H18:H42)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(N18:N42)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(T18:T42)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(Z18:Z42)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(AF18:AF42)","v":0.29166666666666674},null,{"$f":"ROUND(((H43+N43+T43+Z43+AF43)/5)*1440,0)/1440","v":0.29166666666666669},{"$f":"SUM(AI18:AI40)","v":0.21249999999999999},null,null,null,null,null,{"$f":"SUM(AO18:AO40)","v":2.7777777777777776E-2}]
[]
[null,null,"WEEK 2"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nBoth Weeks"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-Test"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,null,null,null,{"$f":"COUNTIF(C48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H47,\">\"&\"00\")","v":0},{"$f":"IF(OR(C49=\"Lunch\",C49=\"Recess\",AND(F49=1,G49=1,C49=\"Passing\")), 0, IF(D49>E49,(E49+0.5)-D49,E49-D49))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(I48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N47,\">\"&\"00\")","v":0},{"$f":"IF(OR(I49=\"Lunch\",I49=\"Recess\",AND(L49=1,M49=1,I49=\"Passing\")), 0, IF(J49>K49,(K49+0.5)-J49,K49-J49))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(O48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T47,\">\"&\"00\")","v":0},{"$f":"IF(OR(O49=\"Lunch\",O49=\"Recess\",AND(R49=1,S49=1,O49=\"Passing\")), 0, IF(P49>Q49,(Q49+0.5)-P49,Q49-P49))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(U48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z47,\">\"&\"00\")","v":0},{"$f":"IF(OR(U49=\"Lunch\",U49=\"Recess\",AND(X49=1,Y49=1,U49=\"Passing\")), 0, IF(V49>W49,(W49+0.5)-V49,W49-V49))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(AA48,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF47,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA49=\"Lunch\",AA49=\"Recess\",AND(AD49=1,AE49=1,AA49=\"Passing\")), 0, IF(AB49>AC49,(AC49+0.5)-AB49,AC49-AB49))","v":0},null,{"$f":"ROUND(((H49+N49+T49+Z49+AF49+H18+N18+T18+Z18+AF18)/10)*1440,0)/1440","v":3.125E-2},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C49)),ISNUMBER(SEARCH(\"*Period*\",I49)),ISNUMBER(SEARCH(\"*Period*\",O49)),ISNUMBER(SEARCH(\"*Period*\",U49)),ISNUMBER(SEARCH(\"*Period*\",AA49))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C49:AA49,C49:AA49)=MAX(COUNTIF(C49:AA49,C49:AA49)),ROW(C49:AA49)*1000+COLUMN(C49:AA49))),\"0\\C000\"),0),\"\")","v":0},null,null,{"$f":"IF(AJ49=\"\",\"\",VALUE(LEFT(AJ49,1)))","v":0}]
[null,null,null,null,null,0,0,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,0,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,0,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,3.125E-2,null,"2nd period",null,null,2]
[null,null,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","09:20:00","09:25:00",0,0,3.4722222222222099E-3,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"3rd period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"3rd period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,null,3.125E-2,null,0,null,null,0]
[null,null,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,null,0,null,"",null,null,""]
[null,null,"4th  period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"4th  period","09:25:00","10:55:00",0,0,6.25E-2,null,null,null,0,1,0,"4th  period","09:25:00","10:55:00",0,0,6.25E-2,null,3.125E-2,null,"4th  period",null,null,4]
[null,null,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,0,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,0,0,"passing","10:55:00","10:55:00",0,0,0,null,0,null,"",null,null,""]
[null,null,"Lunch","10:55:00","11:35:00",0,1,0,"Lunch","10:55:00","11:35:00",0,0,0,"Lunch","10:55:00","11:35:00",0,1,0,"Lunch","10:55:00","11:35:00",0,0,0,"Lunch","10:55:00","11:35:00",0,1,0,null,0,null,"",null,null,""]
[null,null,"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(H56,\">\"&\"00\")","v":0},{"$f":"IF(OR(C58=\"Lunch\",C58=\"Recess\",AND(F58=1,G58=1,C58=\"Passing\")), 0, IF(D58>E58,(E58+0.5)-D58,E58-D58))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(N56,\">\"&\"00\")","v":0},{"$f":"IF(OR(I58=\"Lunch\",I58=\"Recess\",AND(L58=1,M58=1,I58=\"Passing\")), 0, IF(J58>K58,(K58+0.5)-J58,K58-J58))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(T56,\">\"&\"00\")","v":0},{"$f":"IF(OR(O58=\"Lunch\",O58=\"Recess\",AND(R58=1,S58=1,O58=\"Passing\")), 0, IF(P58>Q58,(Q58+0.5)-P58,Q58-P58))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(Z56,\">\"&\"00\")","v":0},{"$f":"IF(OR(U58=\"Lunch\",U58=\"Recess\",AND(X58=1,Y58=1,U58=\"Passing\")), 0, IF(V58>W58,(W58+0.5)-V58,W58-V58))","v":3.4722222222222099E-3},"passing","11:35:00","11:40:00",1,{"$f":"COUNTIF(AF56,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA58=\"Lunch\",AA58=\"Recess\",AND(AD58=1,AE58=1,AA58=\"Passing\")), 0, IF(AB58>AC58,(AC58+0.5)-AB58,AC58-AB58))","v":3.4722222222222099E-3},null,3.472222222222222E-3,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H57,\">\"&\"00\")","v":0},{"$f":"IF(OR(C59=\"Lunch\",C59=\"Recess\",AND(F59=1,G59=1,C59=\"Passing\")), 0, IF(D59>E59,(E59+0.5)-D59,E59-D59))","v":0},"5th","11:40:00","01:10:00",0,{"$f":"COUNTIF(N57,\">\"&\"00\")","v":0},{"$f":"IF(OR(I59=\"Lunch\",I59=\"Recess\",AND(L59=1,M59=1,I59=\"Passing\")), 0, IF(J59>K59,(K59+0.5)-J59,K59-J59))","v":6.2500000000000056E-2},null,null,null,0,{"$f":"COUNTIF(T57,\">\"&\"00\")","v":0},{"$f":"IF(OR(O59=\"Lunch\",O59=\"Recess\",AND(R59=1,S59=1,O59=\"Passing\")), 0, IF(P59>Q59,(Q59+0.5)-P59,Q59-P59))","v":0},"5th","11:40:00","01:10:00",0,{"$f":"COUNTIF(Z57,\">\"&\"00\")","v":0},{"$f":"IF(OR(U59=\"Lunch\",U59=\"Recess\",AND(X59=1,Y59=1,U59=\"Passing\")), 0, IF(V59>W59,(W59+0.5)-V59,W59-V59))","v":6.2500000000000056E-2},null,null,null,0,{"$f":"COUNTIF(AF57,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA59=\"Lunch\",AA59=\"Recess\",AND(AD59=1,AE59=1,AA59=\"Passing\")), 0, IF(AB59>AC59,(AC59+0.5)-AB59,AC59-AB59))","v":0},null,3.125E-2,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,1,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,1,3.4722222222222238E-3,null,null,null,0,1,0,null,2.0833333333333333E-3,null,"",null,null,""]
[null,null,"6th period","11:40:00","01:10:00",0,0,6.2500000000000056E-2,null,null,null,0,1,0,"6th period","11:40:00","01:10:00",0,0,6.2500000000000056E-2,null,null,null,0,1,0,"6th period","11:40:00","01:10:00",0,0,6.2500000000000056E-2,null,3.125E-2,null,"6th period",null,null,6]
[null,null,"passing","01:10:00","01:15:00",0,0,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,0,3.4722222222222238E-3,null,null,null,0,1,0,"passing","01:10:00","01:15:00",0,0,3.4722222222222238E-3,null,2.0833333333333333E-3,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"7th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"7th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,null,3.125E-2,null,0,null,null,0]
[null,null,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,null,2.0833333333333333E-3,null,"",null,null,""]
[null,null,"8th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"8th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,null,null,0,1,0,"8th period","01:15:00","02:45:00",0,0,6.2499999999999993E-2,null,3.125E-2,null,"8th period",null,null,8]
[null,null,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,null,null,0,1,0,"passing","02:45:00","02:50:00",0,0,3.4722222222222376E-3,null,2.0833333333333333E-3,null,"",null,null,""]
[null,null,"Seminar","02:50:00","03:30:00",0,1,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,0,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,1,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,0,2.7777777777777776E-2,"Seminar","02:50:00","03:30:00",0,1,2.7777777777777776E-2,null,2.7777777777777776E-2,null,"",null,null,""]
[null,null,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,null,null,0,1,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H49:H73)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(N49:N73)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(T49:T73)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(Z49:Z73)","v":0.29166666666666674},null,null,"Total Minutes",null,null,{"$f":"SUM(AF49:AF73)","v":0.29166666666666674},null,{"$f":"ROUND(((H43+N43+T43+Z43+AF43+H74+N74+T74+Z74+AF74)/10)*1440,0)/1440","v":0.29166666666666669}]
[]
[]
[]
[]
["Bell Schedule Calculator\nUpdated 6/10/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example 3","index":5,"n_rows":84,"n_cols":41,"rows_kept":84,"cut":false,"hidden":false,"merged":[[16,34,18,34],[47,2,47,7],[47,8,47,13],[47,14,47,19],[47,20,47,25],[47,26,47,31],[47,33,49,33],[16,2,16,7],[16,8,16,13],[16,14,16,19],[16,20,16,25],[16,26,16,31],[16,33,18,33],[92,0,94,33],[12,2,12,7],[12,14,12,20],[12,27,12,33],[7,0,7,33],[8,0,8,33],[11,2,11,7],[11,14,11,20],[11,27,11,33],[83,0,90,33]]}
[]
[]
[]
[]
[]
[]
[]
["Bell Schedule Calculator"]
["Block Schedule"]
[]
[]
[null,null,"19/20",null,null,null,null,null,null,null,null,null,null,null,"USD 2001",null,null,null,null,null,null,null,null,null,null,null,null,"Meadowlark High"]
[null,null,"School Year",null,null,null,null,null,null,null,null,null,null,null,"District",null,null,null,null,null,null,null,null,null,null,null,null,"Building"]
[]
[]
[null,null,"WEEK 1"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nWeek 1","CTE Contact Minutes"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-test","Period","Seq","P Num","Contact","Seminar"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(C19,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H18,\">\"&\"00\")","v":0},{"$f":"IF(OR(C20=\"Lunch\",C20=\"Recess\",AND(F20=1,G20=1,C20=\"Passing\")), 0, IF(D20>E20,(E20+0.5)-D20,E20-D20))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(I19,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N18,\">\"&\"00\")","v":0},{"$f":"IF(OR(I20=\"Lunch\",I20=\"Recess\",AND(L20=1,M20=1,I20=\"Passing\")), 0, IF(J20>K20,(K20+0.5)-J20,K20-J20))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(O19,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T18,\">\"&\"00\")","v":0},{"$f":"IF(OR(O20=\"Lunch\",O20=\"Recess\",AND(R20=1,S20=1,O20=\"Passing\")), 0, IF(P20>Q20,(Q20+0.5)-P20,Q20-P20))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(U19,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z18,\">\"&\"00\")","v":0},{"$f":"IF(OR(U20=\"Lunch\",U20=\"Recess\",AND(X20=1,Y20=1,U20=\"Passing\")), 0, IF(V20>W20,(W20+0.5)-V20,W20-V20))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(AA19,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF18,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA20=\"Lunch\",AA20=\"Recess\",AND(AD20=1,AE20=1,AA20=\"Passing\")), 0, IF(AB20>AC20,(AC20+0.5)-AB20,AC20-AB20))","v":6.25E-2},null,{"$f":"ROUND(((H20+N20+T20+Z20+AF20)/5)*1440,0)/1440","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C20)),ISNUMBER(SEARCH(\"*Period*\",I20)),ISNUMBER(SEARCH(\"*Period*\",O20)),ISNUMBER(SEARCH(\"*Period*\",U20)),ISNUMBER(SEARCH(\"*Period*\",AA20))),AH20,0)","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C20)),ISNUMBER(SEARCH(\"*Period*\",I20)),ISNUMBER(SEARCH(\"*Period*\",O20)),ISNUMBER(SEARCH(\"*Period*\",U20)),ISNUMBER(SEARCH(\"*Period*\",AA20))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C20:AA20,C20:AA20)=MAX(COUNTIF(C20:AA20,C20:AA20)),ROW(C20:AA20)*1000+COLUMN(C20:AA20))),\"0\\C000\"),0),\"\")","v":"1st period"},{"$f":"IF(AJ20=0, AJ51,AJ20)","v":"1st period"},{"$f":"IF(AM20=0,\"\",(MAX(AL$19:AL19)+1)*1)","v":1},{"$f":"IF(AK20=\"\",0,REPLACE(AK20,SEARCH(\" \",AK20,1),7,\"\"))","v":"1st"},{"$f":"AI20","v":3.7499999999999999E-2},{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C20)),ISNUMBER(SEARCH(\"*Seminar*\",I20)),ISNUMBER(SEARCH(\"*Seminar*\",O20)),ISNUMBER(SEARCH(\"*Seminar*\",U20)),ISNUMBER(SEARCH(\"*Seminar*\",AA20))),AH20,0)","v":0}]
[null,null,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,0,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,0,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,4.1666666666666666E-3,0,"","",{"$f":"IF(AM21=0,\"\",(MAX(AL$19:AL20)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,null,2.5000000000000001E-2,2.5000000000000001E-2,0,"2nd period",{"$f":"IF(AM22=0,\"\",(MAX(AL$19:AL21)+1)*1)","v":2},"2nd",2.5000000000000001E-2,0]
[null,null,null,null,null,0,1,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,1,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,1,0,null,2.7777777777777779E-3,0,"","",{"$f":"IF(AM23=0,\"\",(MAX(AL$19:AL22)+1)*1)","v":""},0,0,0]
[null,null,"3rd period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"3rd period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"3rd period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,3.5416666666666666E-2,3.5416666666666666E-2,"3rd period","3rd period",{"$f":"IF(AM24=0,\"\",(MAX(AL$19:AL23)+1)*1)","v":3},"3rd",3.5416666666666666E-2,0]
[null,null,"passing","10:55:00","11:00:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","10:55:00","11:00:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","10:55:00","11:00:00",0,0,3.4722222222222099E-3,null,2.0833333333333333E-3,0,"","",{"$f":"IF(AM25=0,\"\",(MAX(AL$19:AL24)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"4th  period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"4th  period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,null,2.361111111111111E-2,2.361111111111111E-2,0,"4th  period",{"$f":"IF(AM26=0,\"\",(MAX(AL$19:AL25)+1)*1)","v":4},"4thd",2.361111111111111E-2,0]
[null,null,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,null,0,0,"","",{"$f":"IF(AM27=0,\"\",(MAX(AL$19:AL26)+1)*1)","v":""},0,0,0]
[null,null,"Lunch","11:00:00","11:40:00",0,0,0,"Lunch","11:45:00","01:05:00",0,1,0,"Lunch","11:00:00","11:40:00",0,0,0,"Lunch","11:45:00","01:05:00",0,1,0,"Lunch","11:00:00","11:40:00",0,0,0,null,0,0,"","",{"$f":"IF(AM28=0,\"\",(MAX(AL$19:AL27)+1)*1)","v":""},0,0,0]
[null,null,"passing","11:40:00","11:40:00",1,{"$f":"COUNTIF(H27,\">\"&\"00\")","v":0},{"$f":"IF(OR(C29=\"Lunch\",C29=\"Recess\",AND(F29=1,G29=1,C29=\"Passing\")), 0, IF(D29>E29,(E29+0.5)-D29,E29-D29))","v":0},"passing","01:05:00","01:15:00",1,{"$f":"COUNTIF(N27,\">\"&\"00\")","v":0},{"$f":"IF(OR(I29=\"Lunch\",I29=\"Recess\",AND(L29=1,M29=1,I29=\"Passing\")), 0, IF(J29>K29,(K29+0.5)-J29,K29-J29))","v":6.9444444444444475E-3},"passing","11:40:00","11:40:00",1,{"$f":"COUNTIF(T27,\">\"&\"00\")","v":0},{"$f":"IF(OR(O29=\"Lunch\",O29=\"Recess\",AND(R29=1,S29=1,O29=\"Passing\")), 0, IF(P29>Q29,(Q29+0.5)-P29,Q29-P29))","v":0},"passing","01:05:00","01:15:00",1,{"$f":"COUNTIF(Z27,\">\"&\"00\")","v":0},{"$f":"IF(OR(U29=\"Lunch\",U29=\"Recess\",AND(X29=1,Y29=1,U29=\"Passing\")), 0, IF(V29>W29,(W29+0.5)-V29,W29-V29))","v":6.9444444444444475E-3},"passing","11:40:00","11:40:00",1,{"$f":"COUNTIF(AF27,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA29=\"Lunch\",AA29=\"Recess\",AND(AD29=1,AE29=1,AA29=\"Passing\")), 0, IF(AB29>AC29,(AC29+0.5)-AB29,AC29-AB29))","v":0},null,2.7777777777777779E-3,0,"","",{"$f":"IF(AM29=0,\"\",(MAX(AL$19:AL28)+1)*1)","v":""},0,0,0]
[null,null,"5th","11:40:00","01:05:00",0,{"$f":"COUNTIF(H28,\">\"&\"00\")","v":0},{"$f":"IF(OR(C30=\"Lunch\",C30=\"Recess\",AND(F30=1,G30=1,C30=\"Passing\")), 0, IF(D30>E30,(E30+0.5)-D30,E30-D30))","v":5.9027777777777735E-2},null,null,null,0,{"$f":"COUNTIF(N28,\">\"&\"00\")","v":0},{"$f":"IF(OR(I30=\"Lunch\",I30=\"Recess\",AND(L30=1,M30=1,I30=\"Passing\")), 0, IF(J30>K30,(K30+0.5)-J30,K30-J30))","v":0},"5th","11:40:00","01:05:00",0,{"$f":"COUNTIF(T28,\">\"&\"00\")","v":0},{"$f":"IF(OR(O30=\"Lunch\",O30=\"Recess\",AND(R30=1,S30=1,O30=\"Passing\")), 0, IF(P30>Q30,(Q30+0.5)-P30,Q30-P30))","v":5.9027777777777735E-2},null,null,null,0,{"$f":"COUNTIF(Z28,\">\"&\"00\")","v":0},{"$f":"IF(OR(U30=\"Lunch\",U30=\"Recess\",AND(X30=1,Y30=1,U30=\"Passing\")), 0, IF(V30>W30,(W30+0.5)-V30,W30-V30))","v":0},"5th","11:40:00","01:05:00",0,{"$f":"COUNTIF(AF28,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA30=\"Lunch\",AA30=\"Recess\",AND(AD30=1,AE30=1,AA30=\"Passing\")), 0, IF(AB30>AC30,(AC30+0.5)-AB30,AC30-AB30))","v":5.9027777777777735E-2},null,3.5416666666666666E-2,0,"","",{"$f":"IF(AM30=0,\"\",(MAX(AL$19:AL29)+1)*1)","v":""},0,0,0]
[null,null,"passing","01:05:00","01:15:00",0,0,6.9444444444444475E-3,null,null,null,0,1,0,"passing","01:05:00","01:15:00",0,0,6.9444444444444475E-3,null,null,null,0,1,0,"passing","01:05:00","01:15:00",0,0,6.9444444444444475E-3,null,4.1666666666666666E-3,0,"","",{"$f":"IF(AM31=0,\"\",(MAX(AL$19:AL30)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"6th period","10:55:00","11:40:00",0,0,3.125E-2,null,null,null,0,1,0,"6th period","10:55:00","11:40:00",0,0,3.125E-2,null,null,null,0,1,0,null,1.2500000000000001E-2,1.2500000000000001E-2,0,"6th period",{"$f":"IF(AM32=0,\"\",(MAX(AL$19:AL31)+1)*1)","v":5},"6th",1.2500000000000001E-2,0]
[null,null,null,null,null,0,1,0,"passing","11:40:00","11:45:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","11:40:00","11:45:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,null,1.3888888888888889E-3,0,"","",{"$f":"IF(AM33=0,\"\",(MAX(AL$19:AL32)+1)*1)","v":""},0,0,0]
[null,null,"7th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"7th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"7th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,3.5416666666666666E-2,3.5416666666666666E-2,"7th period","7th period",{"$f":"IF(AM34=0,\"\",(MAX(AL$19:AL33)+1)*1)","v":6},"7th",3.5416666666666666E-2,0]
[null,null,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,4.1666666666666666E-3,0,"","",{"$f":"IF(AM35=0,\"\",(MAX(AL$19:AL34)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"8th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"8th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,null,2.361111111111111E-2,2.361111111111111E-2,0,"8th period",{"$f":"IF(AM36=0,\"\",(MAX(AL$19:AL35)+1)*1)","v":7},"8th",2.361111111111111E-2,0]
[null,null,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,null,2.7777777777777779E-3,0,"","",{"$f":"IF(AM37=0,\"\",(MAX(AL$19:AL36)+1)*1)","v":""},0,0,0]
[null,null,"9th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"9th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"9th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,1.6666666666666666E-2,1.6666666666666666E-2,"9th period","9th period",{"$f":"IF(AM38=0,\"\",(MAX(AL$19:AL37)+1)*1)","v":8},"9th",1.6666666666666666E-2,0]
[null,null,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM39=0,\"\",(MAX(AL$19:AL38)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,1,0,"10th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"10th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,null,1.1111111111111112E-2,1.1111111111111112E-2,0,"10th period",{"$f":"IF(AM40=0,\"\",(MAX(AL$19:AL39)+1)*1)","v":9},"10th",1.1111111111111112E-2,0]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM41=0,\"\",(MAX(AL$19:AL40)+1)*1)","v":""},0,0,0]
[null,null,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,0,0,"","",{"$f":"IF(AM42=0,\"\",(MAX(AL$19:AL41)+1)*1)","v":""},0,0,0]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H20:H44)","v":0.29166666666666663},null,null,"Total Minutes",null,null,{"$f":"SUM(N20:N44)","v":0.2638888888888889},null,null,"Total Minutes",null,null,{"$f":"SUM(T20:T44)","v":0.29166666666666663},null,null,"Total Minutes",null,null,{"$f":"SUM(Z20:Z44)","v":0.2638888888888889},null,null,"Total Minutes",null,null,{"$f":"SUM(AF20:AF44)","v":0.29166666666666663},null,{"$f":"ROUND(((H45+N45+T45+Z45+AF45)/5)*1440,0)/1440","v":0.28055555555555556},{"$f":"SUM(AI20:AI42)","v":0.22083333333333333},null,null,null,null,null,{"$f":"SUM(AO20:AO42)","v":0}]
[]
[null,null,"WEEK 2"]
[null,null,"Monday",null,null,null,null,null,"Tuesday",null,null,null,null,null,"Wednesday",null,null,null,null,null,"Thursday",null,null,null,null,null,"Friday",null,null,null,null,null,null,"Daily Average Minutes for \nBoth Weeks"]
[null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,"Type","Start","End",null,null,null,null,null,null,"P-Test"]
[null,null,"of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min","of Time","Time","Time",null,null,"Min"]
[null,null,null,null,null,{"$f":"COUNTIF(C50,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(H49,\">\"&\"00\")","v":0},{"$f":"IF(OR(C51=\"Lunch\",C51=\"Recess\",AND(F51=1,G51=1,C51=\"Passing\")), 0, IF(D51>E51,(E51+0.5)-D51,E51-D51))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(I50,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(N49,\">\"&\"00\")","v":0},{"$f":"IF(OR(I51=\"Lunch\",I51=\"Recess\",AND(L51=1,M51=1,I51=\"Passing\")), 0, IF(J51>K51,(K51+0.5)-J51,K51-J51))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(O50,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(T49,\">\"&\"00\")","v":0},{"$f":"IF(OR(O51=\"Lunch\",O51=\"Recess\",AND(R51=1,S51=1,O51=\"Passing\")), 0, IF(P51>Q51,(Q51+0.5)-P51,Q51-P51))","v":0},"1st period","07:50:00","09:20:00",{"$f":"COUNTIF(U50,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(Z49,\">\"&\"00\")","v":0},{"$f":"IF(OR(U51=\"Lunch\",U51=\"Recess\",AND(X51=1,Y51=1,U51=\"Passing\")), 0, IF(V51>W51,(W51+0.5)-V51,W51-V51))","v":6.25E-2},null,null,null,{"$f":"COUNTIF(AA50,\"=\"&\"Lunch\")","v":0},{"$f":"COUNTIF(AF49,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA51=\"Lunch\",AA51=\"Recess\",AND(AD51=1,AE51=1,AA51=\"Passing\")), 0, IF(AB51>AC51,(AC51+0.5)-AB51,AC51-AB51))","v":0},null,{"$f":"ROUND(((H51+N51+T51+Z51+AF51+H20+N20+T20+Z20+AF20)/10)*1440,0)/1440","v":3.125E-2},null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"*Period*\",C51)),ISNUMBER(SEARCH(\"*Period*\",I51)),ISNUMBER(SEARCH(\"*Period*\",O51)),ISNUMBER(SEARCH(\"*Period*\",U51)),ISNUMBER(SEARCH(\"*Period*\",AA51))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C51:AA51,C51:AA51)=MAX(COUNTIF(C51:AA51,C51:AA51)),ROW(C51:AA51)*1000+COLUMN(C51:AA51))),\"0\\C000\"),0),\"\")","v":0},null,null,{"$f":"IF(AJ51=\"\",\"\",VALUE(LEFT(AJ51,1)))","v":0}]
[null,null,null,null,null,0,0,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,0,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,0,0,null,3.472222222222222E-3,null,"",null,null,""]
[null,null,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,null,null,0,1,0,"2nd period","07:50:00","09:20:00",0,0,6.25E-2,null,3.125E-2,null,"2nd period",null,null,2]
[null,null,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,1,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,null,null,0,1,0,"passing","09:20:00","09:30:00",0,0,6.9444444444444198E-3,null,3.472222222222222E-3,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"3rd period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"3rd period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,null,2.9861111111111113E-2,null,0,null,null,0]
[null,null,null,null,null,0,1,0,"passing","10:55:00","11:00:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","10:55:00","11:00:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,"4th  period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"4th  period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,null,null,0,1,0,"4th  period","09:30:00","10:55:00",0,0,5.902777777777779E-2,null,2.9861111111111113E-2,null,"4th  period",null,null,4]
[null,null,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,null,null,0,1,0,"passing","10:55:00","10:55:00",0,0,0,null,0,null,"",null,null,""]
[null,null,"Lunch","11:45:00","01:05:00",0,1,0,"Lunch","11:00:00","11:40:00",0,0,0,"Lunch","11:45:00","01:05:00",0,1,0,"Lunch","11:00:00","11:40:00",0,0,0,"Lunch","11:45:00","01:05:00",0,1,0,null,0,null,"",null,null,""]
[null,null,"passing","01:05:00","01:15:00",1,{"$f":"COUNTIF(H58,\">\"&\"00\")","v":0},{"$f":"IF(OR(C60=\"Lunch\",C60=\"Recess\",AND(F60=1,G60=1,C60=\"Passing\")), 0, IF(D60>E60,(E60+0.5)-D60,E60-D60))","v":6.9444444444444475E-3},"passing","11:40:00","11:40:00",1,{"$f":"COUNTIF(N58,\">\"&\"00\")","v":0},{"$f":"IF(OR(I60=\"Lunch\",I60=\"Recess\",AND(L60=1,M60=1,I60=\"Passing\")), 0, IF(J60>K60,(K60+0.5)-J60,K60-J60))","v":0},"passing","01:05:00","01:15:00",1,{"$f":"COUNTIF(T58,\">\"&\"00\")","v":0},{"$f":"IF(OR(O60=\"Lunch\",O60=\"Recess\",AND(R60=1,S60=1,O60=\"Passing\")), 0, IF(P60>Q60,(Q60+0.5)-P60,Q60-P60))","v":6.9444444444444475E-3},"passing","11:40:00","11:40:00",1,{"$f":"COUNTIF(Z58,\">\"&\"00\")","v":0},{"$f":"IF(OR(U60=\"Lunch\",U60=\"Recess\",AND(X60=1,Y60=1,U60=\"Passing\")), 0, IF(V60>W60,(W60+0.5)-V60,W60-V60))","v":0},"passing","01:05:00","01:15:00",1,{"$f":"COUNTIF(AF58,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA60=\"Lunch\",AA60=\"Recess\",AND(AD60=1,AE60=1,AA60=\"Passing\")), 0, IF(AB60>AC60,(AC60+0.5)-AB60,AC60-AB60))","v":6.9444444444444475E-3},null,3.472222222222222E-3,null,"",null,null,""]
[null,null,null,null,null,0,{"$f":"COUNTIF(H59,\">\"&\"00\")","v":0},{"$f":"IF(OR(C61=\"Lunch\",C61=\"Recess\",AND(F61=1,G61=1,C61=\"Passing\")), 0, IF(D61>E61,(E61+0.5)-D61,E61-D61))","v":0},"5th","11:40:00","01:05:00",0,{"$f":"COUNTIF(N59,\">\"&\"00\")","v":0},{"$f":"IF(OR(I61=\"Lunch\",I61=\"Recess\",AND(L61=1,M61=1,I61=\"Passing\")), 0, IF(J61>K61,(K61+0.5)-J61,K61-J61))","v":5.9027777777777735E-2},null,null,null,0,{"$f":"COUNTIF(T59,\">\"&\"00\")","v":0},{"$f":"IF(OR(O61=\"Lunch\",O61=\"Recess\",AND(R61=1,S61=1,O61=\"Passing\")), 0, IF(P61>Q61,(Q61+0.5)-P61,Q61-P61))","v":0},"5th","11:40:00","01:05:00",0,{"$f":"COUNTIF(Z59,\">\"&\"00\")","v":0},{"$f":"IF(OR(U61=\"Lunch\",U61=\"Recess\",AND(X61=1,Y61=1,U61=\"Passing\")), 0, IF(V61>W61,(W61+0.5)-V61,W61-V61))","v":5.9027777777777735E-2},null,null,null,0,{"$f":"COUNTIF(AF59,\">\"&\"00\")","v":0},{"$f":"IF(OR(AA61=\"Lunch\",AA61=\"Recess\",AND(AD61=1,AE61=1,AA61=\"Passing\")), 0, IF(AB61>AC61,(AC61+0.5)-AB61,AC61-AB61))","v":0},null,2.9861111111111113E-2,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"passing","01:05:00","01:15:00",0,0,6.9444444444444475E-3,null,null,null,0,1,0,"passing","01:05:00","01:15:00",0,0,6.9444444444444475E-3,null,null,null,0,1,0,null,3.472222222222222E-3,null,"",null,null,""]
[null,null,"6th period","10:55:00","11:40:00",0,0,3.125E-2,null,null,null,0,1,0,"6th period","10:55:00","11:40:00",0,0,3.125E-2,null,null,null,0,1,0,"6th period","10:55:00","11:40:00",0,0,3.125E-2,null,1.5972222222222221E-2,null,"6th period",null,null,6]
[null,null,"passing","11:40:00","11:45:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","11:40:00","11:45:00",0,0,3.4722222222222099E-3,null,null,null,0,1,0,"passing","11:40:00","11:45:00",0,0,3.4722222222222099E-3,null,1.3888888888888889E-3,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"7th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"7th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,null,2.9861111111111113E-2,null,0,null,null,0]
[null,null,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,null,3.472222222222222E-3,null,"",null,null,""]
[null,null,"8th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"8th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,null,null,0,1,0,"8th period","01:15:00","02:40:00",0,0,5.9027777777777769E-2,null,2.9861111111111113E-2,null,"8th period",null,null,8]
[null,null,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,null,null,0,1,0,"passing","02:40:00","02:50:00",0,0,6.9444444444444614E-3,null,3.472222222222222E-3,null,"",null,null,""]
[null,null,null,null,null,0,1,0,"9th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"9th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,null,1.3888888888888888E-2,null,0,null,null,0]
[null,null,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,0,null,"",null,null,""]
[null,null,"10th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"10th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,null,null,0,1,0,"10th period","02:50:00","03:30:00",0,0,2.7777777777777776E-2,null,1.3888888888888888E-2,null,"10th period",null,null,1]
[null,null,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0,null,0,null,"",null,null,""]
[null,null,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,null,null,0,0,0,null,null,null,0,1,0,null,0,null,"",null,null,""]
[]
[]
[null,null,null,null,"Total Minutes",null,null,{"$f":"SUM(H51:H75)","v":0.2638888888888889},null,null,"Total Minutes",null,null,{"$f":"SUM(N51:N75)","v":0.29166666666666663},null,null,"Total Minutes",null,null,{"$f":"SUM(T51:T75)","v":0.2638888888888889},null,null,"Total Minutes",null,null,{"$f":"SUM(Z51:Z75)","v":0.29166666666666663},null,null,"Total Minutes",null,null,{"$f":"SUM(AF51:AF75)","v":0.2638888888888889},null,{"$f":"ROUND(((H45+N45+T45+Z45+AF45+H76+N76+T76+Z76+AF76)/10)*1440,0)/1440","v":0.27777777777777779}]
[]
[]
[]
[]
[]
[]
[]
["Bell Schedule Calculator\nUpdated 6/10/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Formulas","index":6,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
["Cell","F8"]
["Heading","none"]
["Formula"," =COUNTIF(C7,\"=\"&\"Lunch\")"]
["Translation","Places a 1 in cell if the word Lunch is in C7 (Type of Time, row above)."]
[]
["Cell","G8"]
["Heading","Mins"]
["Formula"," =IF(OR(C8=\"Lunch\",C8=\"Recess\",AND(F8=1,C8=\"Passing\")), 0, IF(D8>E8,(E8+0.5)-D8,E8-D8))"]
["Translation","If there is a 1 in F8 and the word Passing in C8 (Type), don't count the time.  If the words Lunch or Recess are in C8 (Type), don't count the time.  If not, then count the time.  If beg time is greater than end time, then (end time + .5) minus beg time  If not, then end time minus beg time."]
[]
["Cell","G33"]
["Heading","Total Mins"]
["Formula"," =SUM(G8:G32)"]
["Translation","Adds up all time"]
[]
["Cell","AC8"]
["Heading","Daily Average"]
["Formula"," =ROUND(((G8+L8+Q8+V8+AA8+G57+L57+Q57+V57+AA57)/10)*1440,0)/1440"]
["Translation","Adds up all times in first rows of both tables (the formula sees decimals) and divides by 10 for average which is rounded. Excel stores time as a decimal portion of a day.  Dividing the totaled decimals by 1440 converts to actual minutes.  1440 is the number of minutes in a day."]
[]
["Cell","AC33"]
["Heading","total of daily average column"]
["Formula"," =ROUND((SUM(G33:AA33)+SUM(G82:AA82))/10*1440,0)/1440"]
["Translation","Adds up total minutes row for both columns, divides by 10 to average, converts to actual minutes, then rounds."]
[]
["Cell","AD8"]
["Heading","Contact Minutes"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Period*\",C8)),ISNUMBER(SEARCH(\"*Period*\",H8)),ISNUMBER(SEARCH(\"*Period*\",M8)),ISNUMBER(SEARCH(\"*Period*\",R8)),ISNUMBER(SEARCH(\"*Period*\",W8))),AC8,0)"]
["Translation","Looks for the word period in Type columns of both tables and returns a zero if it finds it.  If it doesn't find the word period, then returns the result in AC8."]
[]
["Cell","AD33"]
["Heading","total of Contact Minutes column"]
["Formula"," =SUM(AD8:AD30)"]
["Translation","adds up all contact minutes"]
[]
["Cell","AE8"]
["Heading","P-test"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Period*\",C8)),ISNUMBER(SEARCH(\"*Period*\",H8)),ISNUMBER(SEARCH(\"*Period*\",M8)),ISNUMBER(SEARCH(\"*Period*\",R8)),ISNUMBER(SEARCH(\"*Period*\",W8))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C8:W8,C8:W8)=MAX(COUNTIF(C8:W8,C8:W8)),ROW(C8:W8)*1000+COLUMN(C8:W8))),\"0\\C000\"),0),\"\")"]
["Translation","Looks for the word Period in Type columns of both tables.  Not sure what happens after that."]
[]
["Cell","AF8"]
["Heading","Period"]
["Formula"," =IF(AE8=0, AE57,AE8)"]
["Translation"]
[]
["Cell","AG8"]
["Heading","Seq"]
["Formula"," =IF(AH8=0,\"\",(MAX(AG$7:AG7)+1)*1)"]
["Translation"]
[]
["Cell","AH8"]
["Heading","P Num"]
["Formula"," =IF(AF8=\"\",0,REPLACE(AF8,SEARCH(\" \",AF8,1),7,\"\"))"]
["Translation"]
[]
["Cell","AI8"]
["Heading","Contact"]
["Formula"," =AD8"]
["Translation"]
[]
["Cell","AJ8"]
["Heading","Seminar"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C8)),ISNUMBER(SEARCH(\"*Seminar*\",H8)),ISNUMBER(SEARCH(\"*Seminar*\",M8)),ISNUMBER(SEARCH(\"*Seminar*\",R8)),ISNUMBER(SEARCH(\"*Seminar*\",W8))),AC8,0)"]
["Translation"]
[]
["Cell","AJ33"]
["Heading","toal of seminar minutes column"]
["Formula"," =SUM(AJ8:AJ30)"]
["Translation"]
[]
["Cell","L36"]
["Heading","Total Minutes per Day"]
["Formula"," =ROUND((SUM(G82:AA82)+SUM(G33:AA33))/10*1440,0)/1440"]
["Translation"]

{"sheet":"Sheet2","index":7,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"1G ",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($A$2:$A$40,SMALL(IF(LEN($A$2:$A$40)>0,ROW($A$2:$A$40)-ROW($E$1)),ROW(1:1)),1),\"\")","v":0},null,"","1G "]
[null,{"$f":"IFERROR(INDEX($A$2:$A$40,SMALL(IF(LEN($A$2:$A$40)>0,ROW($A$2:$A$40)-ROW($E$1)),ROW(2:2)),1),\"\")","v":""},null,"1R ",""]
[null,"",null,"","1R "]
[null,"",null,"2G ",""]
[null,"",null,"","2G "]
[null,"",null,"2R ",""]
[null,"",null,"","2R "]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"3G ",""]
[null,"",null,"","3G "]
[null,"",null,"3R ",""]
[null,"",null,"","3R "]
[null,"",null,"4G ",""]
[null,"",null,"","4G "]
[null,"",null,"4R ",""]
[null,null,null,"","4R "]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]