{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction and Directions","1. Checklist & Priorities","2. Instruct. Time Allocations","3. and 4b. Master Schedule","Generic Pieces","Saved Schedule","Piece Generator","4a. Student Services (SPED,ESL)","5. Rotations","6. Planning Information","7. Admin Schedules","Color Reference"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Introduction and Directions","index":0,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notes: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Light blue cells are those you can edit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Light green cells are those with formulas and cannot be edited."]

{"sheet":"1. Checklist & Priorities","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2. Instruct. Time Allocations","index":2,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[47,2,47,6],[10,2,12,3],[62,2,62,6],[23,3,23,6],[18,2,20,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Directions:  Update the start and end times for your school day.",null,null,null,"Light blue cells can be edited."]
[null,null,null,null,null,null,"Light green cells cannot be edited."]
[]
[null,null,"Start Time","07:30:00"]
[null,null,"End Time","14:30:00"]
[null,null,"Length of School Day  (Hours:Minutes)",{"$f":"D15-D14","v":"07:00:00"}]
[null,null,"Length of School Day  (Minutes)",{"$f":"(D15-D14)*24*60","v":419.99999999999994}]
[]
[null,null,"Directions:  Fill in the blue cells with the number of minutes spent on each subject, by grade, each day.  This tool only allows you to round to the nearest 5 minutes (e.g. 53 minutes is not allowed). If a multiple of 5 is not entered, the tool will automatically round up when creating your specific periods in the 3. and 4b Master schedule sheet.\n\n\nNOTE: Only put values in Science and Social Studies OR Science/Social Studies, not all 3."]
[]
[]
[null,null,"Grade  ",9,10,11,12]
[]
[null,null,"Subject:","Time Allocations"]
[null,null,"Advisory"]
[null,null,"English"]
[null,null,"Math"]
[null,null,"Science"]
[null,null,"Social Studies"]
[null,null,"Science/Social Studies"]
[null,null,"Electives"]
[null,null,"Lunch"]
[null,null,"Recess"]
[null,null,"Intervention/Enrichment"]
[null,null,"Foreign Language"]
[null,null,"Transitions"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total",{"$f":"SUM(D25:D42)","v":0},{"$f":"SUM(E25:E42)","v":0},{"$f":"SUM(F25:F42)","v":0},{"$f":"SUM(G25:G42)","v":0}]
[null,null,"Minutes unaccounted for: ",{"$f":"$D$17-D44","v":419.99999999999994},{"$f":"$D$17-E44","v":419.99999999999994},419.99999999999994,{"$f":"$D$17-G44","v":419.99999999999994}]
[]
[]
[null,null,"Time requirements by grade and subject"]
[null,null,"Subject:","PreK","K",1,2]
[null,null,"Advisory",0,0,0,0]
[null,null,"English/RLA",0,0,0,0]
[null,null,"Math",0,0,0,0]
[null,null,"Science",0,0,0,0]
[null,null,"Social Studies",0,0,0,0]
[null,null,"Science/Social Studies",0,0,0,0]
[null,null,"Related Arts",0,0,0,0]
[null,null,"Lunch",0,0,0,0]
[null,null,"Recess",0,0,0,0]
[null,null,"Intervention/Enrichment or RTII",45,45,45,45]
[null,null,"Foreign Language",0,0,0,0]
[null,null,"test",0,0,0,0]
[]
[null,null,"Test Time requirements by grade and subject"]
[null,null,"Subject:","PreK","K",1,2]
[null,null,"Advisory",{"$f":"IF(D25-D50>0, 0,D25-D50)","v":0},0,0,0]
[null,null,"English/RLA",0,0,0,0]
[null,null,"Math",0,0,0,0]
[null,null,"Science",0,0,0,0]
[null,null,"Social Studies",0,0,0,0]
[null,null,"Science/Social Studies",0,0,0,0]
[null,null,"Related Arts",0,0,0,0]
[null,null,"Lunch",0,0,0,0]
[null,null,"Recess",0,0,0,0]
[null,null,"Intervention/Enrichment or RTII",-45,-45,-45,-45]
[null,null,"Foreign Language",0,0,0,0]
[null,null,"test",0,0,0,0]
[]
[]
[]
[null,null,"Grade",{"$f":"D22","v":9},{"$f":"E22","v":10},11,12]
[null,null,"Enter the # of Homerooms or\n Homerooms per Team"]

{"sheet":"3. and 4b. Master Schedule","index":3,"n_rows":54,"n_cols":188,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,63,52,68],[52,69,52,74],[52,75,52,86],[53,3,53,14],[53,15,53,26],[53,27,53,38],[53,39,53,50],[53,51,53,62],[53,63,53,68],[53,69,53,74],[53,75,53,86],[52,3,52,14],[52,15,52,26],[52,27,52,38],[52,39,52,50],[52,51,52,62],[50,63,50,68],[50,69,50,74],[50,75,50,86],[51,3,51,14],[51,15,51,26],[51,27,51,38],[51,39,51,50],[51,51,51,62],[51,63,51,68],[51,69,51,74],[51,75,51,86],[50,3,50,14],[50,15,50,26],[50,27,50,38],[50,39,50,50],[50,51,50,62],[48,63,48,68],[48,69,48,74],[48,75,48,86],[49,3,49,14],[49,15,49,26],[49,27,49,38],[49,39,49,50],[49,51,49,62],[49,63,49,68],[49,69,49,74],[49,75,49,86],[48,3,48,14],[48,15,48,26],[48,27,48,38],[48,39,48,50],[48,51,48,62],[2,143,2,148],[10,93,10,187],[8,93,8,187],[6,136,6,153],[3,100,3,106],[3,146,3,160],[5,136,5,153],[2,134,2,137],[3,161,3,177],[3,94,3,99],[2,116,2,118],[2,123,2,127],[2,128,2,133],[2,138,2,142],[3,115,3,123],[2,119,2,122],[6,121,6,135],[5,94,5,99],[5,109,5,120],[3,134,3,145],[3,124,3,133],[4,121,4,135],[4,109,4,120],[22,136,22,153],[21,94,21,99],[21,100,21,108],[21,109,21,120],[21,121,21,135],[21,136,21,153],[22,121,22,135],[20,100,20,108],[20,109,20,120],[20,121,20,135],[20,136,20,153],[20,94,20,99],[18,94,18,99],[19,109,19,120],[19,121,19,135],[19,136,19,153],[17,100,17,108],[17,109,17,120],[17,121,17,135],[17,136,17,153],[18,100,18,108],[18,109,18,120],[18,121,18,135],[18,136,18,153],[17,94,17,99],[9,2,11,86],[16,94,16,187],[4,136,4,153],[5,100,5,108],[4,94,4,99],[5,121,5,135],[1,2,1,86],[22,94,22,99],[22,100,22,108],[22,109,22,120],[6,94,6,99],[6,100,6,108],[6,109,6,120],[1,93,1,187],[2,94,2,95],[2,96,2,97],[2,98,2,100],[2,101,2,104],[2,105,2,109],[2,110,2,115],[19,94,19,99],[19,100,19,108],[3,107,3,114],[4,100,4,108]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,null,"Step 3. Build Bell Schedule Below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directions:  Copy and paste these cells into the your bell schedule at the left."]
[null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D14","v":"07:30:00"},{"$f":"SUM(D3+5/1440)","v":"07:35:00"},{"$f":"SUM(E3+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BQ3+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00",{"$f":"SUM(BY3+5/1440)","v":"13:40:00"},"13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00",null,null,null,null,null,null,"Advisory/Lunch/Recess",10,null,10,null,15,null,null,20,null,null,null,25,null,null,null,null,30,null,null,null,null,null,15,null,null,20,null,null,null,25,null,null,null,null,30,null,null,null,null,null,"Lunch 20",null,null,null,"Lunch 25",null,null,null,null,"Lunch 30"]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electives","Electives 30",null,null,null,null,null,"Electives 35",null,null,null,null,null,null,"Electives 40",null,null,null,null,null,null,null,"Electives 45",null,null,null,null,null,null,null,null,"Electives 50",null,null,null,null,null,null,null,null,null,"Electives 60",null,null,null,null,null,null,null,null,null,null,null,"Electives 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electives 85"]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core","Core 30",null,null,null,null,null,"Core 45",null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core 90"]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention/Enrichment","I/E 30",null,null,null,null,null,"I/E 45",null,null,null,null,null,null,null,null,"I/E 60",null,null,null,null,null,null,null,null,null,null,null,"I/E 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I/E 90"]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other ",30,null,null,null,null,null,45,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,null,"Electives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directions:  Copy and paste these cells into the your master schedule at the left. If you need to split up blocks of time, scroll past the table below for additional blocks."]
[null,null,"Step 4b. Build Master and Teacher Schedules Below"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-populated Subject blocks from Step 2. Instructional Time Allocations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D14","v":"07:30:00"},{"$f":"SUM(CQ12+5/1440)","v":"07:35:00"},{"$f":"SUM(CR12+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(FD12+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00",{"$f":"SUM(FL12+5/1440)","v":"13:40:00"},{"$f":"SUM(FM12+5/1440)","v":"13:45:00"},{"$f":"SUM(FN12+5/1440)","v":"13:50:00"},{"$f":"SUM(FO12+5/1440)","v":"13:55:00"},{"$f":"SUM(FP12+5/1440)","v":"14:00:00"},{"$f":"SUM(FQ12+5/1440)","v":"14:05:00"},{"$f":"SUM(FR12+5/1440)","v":"14:10:00"},{"$f":"SUM(FS12+5/1440)","v":"14:15:00"},{"$f":"SUM(FT12+5/1440)","v":"14:20:00"},{"$f":"SUM(FU12+5/1440)","v":"14:25:00"},{"$f":"SUM(FV12+5/1440)","v":"14:30:00"},{"$f":"SUM(FW12+5/1440)","v":"14:35:00"},{"$f":"SUM(FX12+5/1440)","v":"14:40:00"},{"$f":"SUM(FY12+5/1440)","v":"14:45:00"},{"$f":"SUM(FZ12+5/1440)","v":"14:50:00"},"14:55:00","15:00:00","15:05:00","15:10:00","15:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Instruct. Time Allocations'!D22","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Instruct. Time Allocations'!E22","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Instruct. Time Allocations'!F22","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Instruct. Time Allocations'!G22","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Library of Additional Course Lengths: The table below includes an additional set of pre-set time blocks. Would you like a customized block of time? Head to the piece generator tab. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"English","English: 30 minutes",null,null,null,null,null,"English: 45 minutes",null,null,null,null,null,null,null,null,"English: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"English: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"English: 90 minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Math","Math: 30 minutes",null,null,null,null,null,"Math: 45 minutes",null,null,null,null,null,null,null,null,"Math: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Math: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Math: 90 minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science/Social Studies","Science/Social Studies: 30 minutes",null,null,null,null,null,"Science/Social Studies: 45 minutes",null,null,null,null,null,null,null,null,"Science/Social Studies: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Science/Social Studies: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science/Social Studies: 90 minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science","Science: 30 minutes",null,null,null,null,null,"Science: 45 minutes",null,null,null,null,null,null,null,null,"Science: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Science: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science: 90 minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Studies","Social Studies: 30 minutes",null,null,null,null,null,"Social Studies: 45 minutes",null,null,null,null,null,null,null,null,"Social Studies: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Social Studies: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Studies: 90 minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core","Core: 30 minutes",null,null,null,null,null,"Core: 45 minutes",null,null,null,null,null,null,null,null,"Core: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Core: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core: 90 minutes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]
[null,null,12,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"RA 60",null,null,null,null,null,null,null,null,null,null,null,"Lunch 30",null,null,null,null,null,30,null,null,null,null,null,"RTII 60"]

{"sheet":"Generic Pieces","index":4,"n_rows":15,"n_cols":69,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,68,3,84],[5,1,5,6],[5,7,5,15],[5,16,5,27],[5,28,5,42],[5,43,5,60],[4,1,4,6],[4,7,4,15],[4,16,4,27],[4,28,4,42],[4,43,4,60],[3,53,3,67],[3,1,3,6],[3,7,3,13],[3,14,3,21],[3,22,3,30],[1,0,1,94],[2,1,2,2],[2,3,2,4],[2,5,2,7],[2,8,2,11],[2,12,2,16],[2,17,2,22],[2,23,2,25],[2,26,2,29],[2,30,2,34],[2,35,2,40],[2,41,2,44],[2,45,2,49],[2,50,2,55],[3,31,3,40],[3,41,3,52],[6,1,6,6],[6,7,6,15],[6,16,6,27],[6,28,6,42],[6,43,6,60],[8,1,8,94],[9,1,9,6],[9,7,9,15],[9,16,9,27],[9,28,9,42],[9,43,9,60],[11,1,11,6],[11,7,11,15],[11,16,11,27],[11,28,11,42],[11,43,11,60],[10,1,10,6],[10,7,10,15],[10,16,10,27],[10,28,10,42],[10,43,10,60],[13,1,13,6],[13,7,13,15],[13,16,13,27],[13,28,13,42],[13,43,13,60],[12,1,12,6],[12,7,12,15],[12,16,12,27],[12,28,12,42],[12,43,12,60],[14,1,14,6],[14,7,14,15],[14,16,14,27],[14,28,14,42],[14,43,14,60]]}
[]
["Directions:  Copy and paste these cells into the your bell schedule at the left."]
["Advisory/Lunch/Recess",10,null,10,null,15,null,null,20,null,null,null,25,null,null,null,null,30,null,null,null,null,null,15,null,null,20,null,null,null,25,null,null,null,null,30,null,null,null,null,null,"Lunch 20",null,null,null,"Lunch 25",null,null,null,null,"Lunch 30"]
["Electives","Electives 30",null,null,null,null,null,"Electives 35",null,null,null,null,null,null,"Electives 40",null,null,null,null,null,null,null,"Electives 45",null,null,null,null,null,null,null,null,"Electives 50",null,null,null,null,null,null,null,null,null,"Electives 60",null,null,null,null,null,null,null,null,null,null,null,"Electives 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electives 85"]
["Core","Core 30",null,null,null,null,null,"Core 45",null,null,null,null,null,null,null,null,"Core 60",null,null,null,null,null,null,null,null,null,null,null,"Core 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core 90"]
["Intervention/Enrichment","I/E 30",null,null,null,null,null,"I/E 45",null,null,null,null,null,null,null,null,"I/E 60",null,null,null,null,null,null,null,null,null,null,null,"I/E 75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I/E 90"]
["Other ",30,null,null,null,null,null,45,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"Library of Additional Course Lengths"]
["English","English: 30 minutes",null,null,null,null,null,"English: 45 minutes",null,null,null,null,null,null,null,null,"English: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"English: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"English: 90 minutes"]
["Math","Math: 30 minutes",null,null,null,null,null,"Math: 45 minutes",null,null,null,null,null,null,null,null,"Math: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Math: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Math: 90 minutes"]
["Science/Social Studies","Science/Social Studies: 30 minutes",null,null,null,null,null,"Science/Social Studies: 45 minutes",null,null,null,null,null,null,null,null,"Science/Social Studies: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Science/Social Studies: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science/Social Studies: 90 minutes"]
["Science","Science: 30 minutes",null,null,null,null,null,"Science: 45 minutes",null,null,null,null,null,null,null,null,"Science: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Science: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Science: 90 minutes"]
["Social Studies","Social Studies: 30 minutes",null,null,null,null,null,"Social Studies: 45 minutes",null,null,null,null,null,null,null,null,"Social Studies: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Social Studies: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Studies: 90 minutes"]
["Core","Core: 30 minutes",null,null,null,null,null,"Core: 45 minutes",null,null,null,null,null,null,null,null,"Core: 60 minutes",null,null,null,null,null,null,null,null,null,null,null,"Core: 75 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core: 90 minutes"]

{"sheet":"Saved Schedule","index":5,"n_rows":10,"n_cols":87,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,1,86],[9,2,11,86]]}
[]
[null,null,"Step 3. Build Bell Schedule Below"]
[null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D14","v":"07:30:00"},{"$f":"SUM(D3+5/1440)","v":"07:35:00"},{"$f":"SUM(E3+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BQ3+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[]
[null,null,"Electives"]
[null,null,"Step 4b. Build Master and Teacher Schedules Below"]

{"sheet":"Piece Generator","index":6,"n_rows":24,"n_cols":91,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,7,0,90],[1,1,3,3]]}
[null,null,null,null,null,null,null,"Generated Pieces"]
[null,"Introduction:  To generate additional custom pieces, please select the content area and enter any time blocks you need generated.  This tool only allows you to round to the nearest 5 minutes (e.g. 53 minutes is not allowed). \n"]
[]
[]
[null,"Reason for Split","Subject","Time Block Needed",null,null,null,{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(H5+5/1440)","v":"07:35:00"},{"$f":"SUM(I5+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BU5+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"Example: 5th Grade Lunch","Lunch",35]
[null,null,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C38=\"\", \"\",'2. Instruct. Time Allocations'!C38)","v":""}]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C39=\"\", \"\",'2. Instruct. Time Allocations'!C39)","v":""}]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C40=\"\", \"\",'2. Instruct. Time Allocations'!C40)","v":""}]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C41=\"\", \"\",'2. Instruct. Time Allocations'!C41)","v":""}]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C42=\"\", \"\",'2. Instruct. Time Allocations'!C42)","v":""}]
[null,null,{"$f":"IF('2. Instruct. Time Allocations'!C43=\"\", \"\",'2. Instruct. Time Allocations'!C43)","v":""}]

{"sheet":"4a. Student Services (SPED,ESL)","index":7,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[39,3,39,5],[39,6,39,8],[39,9,39,11],[39,12,39,14],[22,3,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,14],[38,2,38,14],[21,2,21,14],[3,12,3,14],[2,2,2,14],[1,2,1,14],[3,3,3,5],[3,6,3,8],[3,9,3,11]]}
[]
[null,null,"Directions: This sheet can help you identify how many sections you need to serve students that receive push in or pull out services based on the group sizes for various service models. \nFirst, enter how the maximum nuber of students can be push-in or pulled out at the same time by grade level for each service model.\n\nSecond, please complete this chart, to the best of your current knowledge, with the number of students receiving push in or pull out services for each subject."]
[null,null,"Students per SPED Service Model"]
[null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D$22","v":9},null,null,{"$f":"'2. Instruct. Time Allocations'!E$22","v":10},null,null,{"$f":"'2. Instruct. Time Allocations'!F$22","v":11},null,null,{"$f":"'2. Instruct. Time Allocations'!$G$22","v":12}]
[null,null,"Content Areas","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1"]
[null,null,"Max Students Grouped Together",12]
[null,null,"Reading Language Arts"]
[null,null,"Math"]
[null,null,"Science"]
[null,null,"Social Studies"]
[null,null,"Intervention/Enrichment"]
[]
[]
[]
[]
[]
[null,null,"Total Students",{"$f":"SUM(D7:D16)","v":0},{"$f":"SUM(E7:E16)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Sections Needed",{"$f":"IF(ISBLANK(D6),\"\",ROUNDUP(D17/D6,0))","v":0},{"$f":"IF(ISBLANK(E6),\"\",ROUNDUP(E17/E6,0))","v":""},"","","","","","","","","",""]
[]
[]
[]
[null,null,"Students per ESL Service Model"]
[null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D$22","v":9},null,null,{"$f":"'2. Instruct. Time Allocations'!E$22","v":10},null,null,{"$f":"'2. Instruct. Time Allocations'!F$22","v":11},null,null,{"$f":"'2. Instruct. Time Allocations'!$G$22","v":12}]
[null,null,"Content Areas","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1"]
[null,null,"Max Students Grouped Together"]
[null,null,"Reading Language Arts"]
[null,null,"Math"]
[null,null,"Science"]
[null,null,"Social Studies"]
[null,null,"Intervention/Enrichment"]
[]
[]
[]
[]
[]
[null,null,"Total Students",{"$f":"SUM(D26:D35)","v":0},{"$f":"SUM(E26:E35)","v":0},{"$f":"SUM(F26:F35)","v":0},{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(H26:H35)","v":0},{"$f":"SUM(I26:I35)","v":0},{"$f":"SUM(J26:J35)","v":0},{"$f":"SUM(K26:K35)","v":0},{"$f":"SUM(L26:L35)","v":0},{"$f":"SUM(M26:M35)","v":0},{"$f":"SUM(N26:N35)","v":0},{"$f":"SUM(O26:O35)","v":0}]
[null,null,"Sections Needed",{"$f":"IF(ISBLANK(D25),\"\",ROUNDUP(D36/D25,0))","v":""},{"$f":"IF(ISBLANK(E25),\"\",ROUNDUP(E36/E25,0))","v":""},{"$f":"IF(ISBLANK(F25),\"\",ROUNDUP(F36/F25,0))","v":""},{"$f":"IF(ISBLANK(G25),\"\",ROUNDUP(G36/G25,0))","v":""},{"$f":"IF(ISBLANK(H25),\"\",ROUNDUP(H36/H25,0))","v":""},{"$f":"IF(ISBLANK(I25),\"\",ROUNDUP(I36/I25,0))","v":""},{"$f":"IF(ISBLANK(J25),\"\",ROUNDUP(J36/J25,0))","v":""},{"$f":"IF(ISBLANK(K25),\"\",ROUNDUP(K36/K25,0))","v":""},{"$f":"IF(ISBLANK(L25),\"\",ROUNDUP(L36/L25,0))","v":""},{"$f":"IF(ISBLANK(M25),\"\",ROUNDUP(M36/M25,0))","v":""},{"$f":"IF(ISBLANK(N25),\"\",ROUNDUP(N36/N25,0))","v":""},{"$f":"IF(ISBLANK(O25),\"\",ROUNDUP(O36/O25,0))","v":""}]
[]
[null,null,"Other"]
[null,null,"Grade",{"$f":"'2. Instruct. Time Allocations'!D$22","v":9},null,null,{"$f":"'2. Instruct. Time Allocations'!E$22","v":10},null,null,{"$f":"'2. Instruct. Time Allocations'!F$22","v":11},null,null,{"$f":"'2. Instruct. Time Allocations'!$G$22","v":12}]
[null,null,"Content Areas","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1","Push-In/Inclusion","Pull Out","1:1"]
[null,null,"Max Students Grouped Together"]
[null,null,"Reading Language Arts"]
[null,null,"Math"]
[null,null,"Science"]
[null,null,"Social Studies"]
[null,null,"Intervention/Enrichment"]
[]
[]
[]
[]
[]
[null,null,"Total Students",{"$f":"SUM(D43:D52)","v":0},{"$f":"SUM(E43:E52)","v":0},{"$f":"SUM(F43:F52)","v":0},{"$f":"SUM(G43:G52)","v":0},{"$f":"SUM(H43:H52)","v":0},{"$f":"SUM(I43:I52)","v":0},{"$f":"SUM(J43:J52)","v":0},{"$f":"SUM(K43:K52)","v":0},{"$f":"SUM(L43:L52)","v":0},{"$f":"SUM(M43:M52)","v":0},{"$f":"SUM(N43:N52)","v":0},{"$f":"SUM(O43:O52)","v":0}]
[null,null,"Sections Needed",{"$f":"IF(ISBLANK(D42),\"\",ROUNDUP(D53/D42,0))","v":""},{"$f":"IF(ISBLANK(E42),\"\",ROUNDUP(E53/E42,0))","v":""},{"$f":"IF(ISBLANK(F42),\"\",ROUNDUP(F53/F42,0))","v":""},{"$f":"IF(ISBLANK(G42),\"\",ROUNDUP(G53/G42,0))","v":""},{"$f":"IF(ISBLANK(H42),\"\",ROUNDUP(H53/H42,0))","v":""},{"$f":"IF(ISBLANK(I42),\"\",ROUNDUP(I53/I42,0))","v":""},{"$f":"IF(ISBLANK(J42),\"\",ROUNDUP(J53/J42,0))","v":""},{"$f":"IF(ISBLANK(K42),\"\",ROUNDUP(K53/K42,0))","v":""},{"$f":"IF(ISBLANK(L42),\"\",ROUNDUP(L53/L42,0))","v":""},{"$f":"IF(ISBLANK(M42),\"\",ROUNDUP(M53/M42,0))","v":""},{"$f":"IF(ISBLANK(N42),\"\",ROUNDUP(N53/N42,0))","v":""},{"$f":"IF(ISBLANK(O42),\"\",ROUNDUP(O53/O42,0))","v":""}]

{"sheet":"5. Rotations","index":8,"n_rows":19,"n_cols":58,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,51,12,56],[12,57,12,62],[12,1,18,1],[12,3,12,8],[12,9,12,14],[12,15,12,20],[12,21,12,26],[12,27,12,32],[12,33,12,38],[12,39,12,44],[12,45,12,50],[1,2,1,32],[2,2,2,32],[3,1,9,1],[3,3,3,7],[3,8,3,12],[3,13,3,17],[3,18,3,22],[3,23,3,27],[3,28,3,32]]}
[]
[null,null,"Directions:  First, list your block times.  Then, list your rotations (if applicable) below.\n\nIn the example below, five sections (A-E) in each grade rotate through five different specials courses over the course of five days.  For example, section A of each grade always takes a course with the Librarian on A Days and takes Music on B Days"]
[null,null,"Ex. Electives Rotations"]
[null,"Sample",null,"Block 1",null,null,null,null,"Block 2",null,null,null,null,"Block 3",null,null,null,null,"Block 4",null,null,null,null,"Block 5",null,null,null,null,"Block 6"]
[null,null,"Grade and Section:","3A","3B","3C","3D","3E","1A","1B","1C","1D","1E","KA","KB","KC","KD","KE","2A","2B","2C","2D","2E","4A","4B","4C","4D","4E","5A","5B","5C","5D","5E"]
[null,null,"A Day","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music"]
[null,null,"B Day","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art"]
[null,null,"C Day","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL"]
[null,null,"D Day","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE"]
[null,null,"E Day","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib","PE","CL","Art","Music","Lib"]
[]
[]
[null,"Your Schedule",null,"Block 1 Time: ",null,null,null,null,null,"Block 2 Time: ",null,null,null,null,null,"Block 3 Time: ",null,null,null,null,null,"Block 4 Time: ",null,null,null,null,null,"Block 5 Time: ",null,null,null,null,null,"Block 6 Time: ",null,null,null,null,null,"Block 7 Time: ",null,null,null,null,null,"Block 8 Time: ",null,null,null,null,null,"Block 9 Time: ",null,null,null,null,null,"Block 10 Time: "]
[null,null,"Grade and Section:"]
[null,null,"A Day"]
[null,null,"B Day"]
[null,null,"C Day"]
[null,null,"D Day"]
[null,null,"E Day"]

{"sheet":"6. Planning Information","index":9,"n_rows":12,"n_cols":92,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,91,4,92],[4,2,4,3],[4,5,4,89],[6,9,6,23],[6,39,6,53],[6,60,6,74],[6,75,6,89]]}
[]
[]
[]
[]
[null,null,"Directions:  After completing your master schedule, fill in the amount of time that teachers will have to plan below.",null,null,"Directions: List how each planning session will be used (e.g. Data Review, Lesson Planning, Independent Planning) throughout the week.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,null,"Type of Time:","Amount of Time",null,"Day",{"$f":"'2. Instruct. Time Allocations'!D14","v":"07:30:00"},{"$f":"SUM(G6+5/1440)","v":"07:35:00"},{"$f":"SUM(H6+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BT6+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00",null,"Principal"]
[null,null,"Total Weekly Teaching Planning Minutes",null,null,"Example (A Day)",null,null,null,"Grade 8 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 7 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 5 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 6 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP"]
[null,null,"Total Weekly Collaborative Planning Minutes",null,null,"A Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Literacy Coach"]
[null,null,null,null,null,"B Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Math  Coach"]
[null,null,null,null,null,"C Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team Lead"]
[null,null,null,null,null,"D Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team Lead"]
[null,null,null,null,null,"E Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counselor"]

{"sheet":"7. Admin Schedules","index":10,"n_rows":53,"n_cols":88,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,87,1,88],[3,2,3,3],[3,4,3,6],[3,7,3,10],[3,11,3,15],[3,16,3,21],[18,1,18,85],[19,1,19,85],[19,87,19,88],[3,22,3,28],[3,29,3,36],[3,37,3,45],[3,46,3,55],[4,2,4,13],[4,14,4,28],[3,1,4,1],[4,45,4,62],[4,29,4,44],[45,1,45,85],[46,1,46,85],[46,87,46,88],[8,1,8,85],[9,87,9,88],[11,5,11,19],[11,35,11,49],[11,56,11,70],[11,71,11,85],[9,1,9,85],[36,1,36,85],[37,1,37,85],[37,87,37,88],[27,1,27,85],[28,1,28,85],[28,87,28,88]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning"]
[null,"Time Block Library",10,null,15,null,null,20,null,null,null,25,null,null,null,null,30,null,null,null,null,null,35,null,null,null,null,null,null,40,null,null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Observations"]
[null,null,60,null,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feedback"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Co-Teaching"]
[]
[]
[null,"Directions: Consolidate all admin, coach, and/or dean activities into a weekly schedule."]
[null,"Enter Name/Position:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Day",{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(C11+5/1440)","v":"07:35:00"},{"$f":"SUM(D11+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BP11+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"Example (A Day)",null,null,null,"Grade 8 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 7 Data Review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 8 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade 7"]
[null,"A Day"]
[null,"B Day"]
[null,"C Day"]
[null,"D Day"]
[null,"E Day"]
[]
[null,"Directions: Consolidate all admin, coach, and/or dean activities into a weekly schedule."]
[null,"Enter Name/Position:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Day",{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(C21+5/1440)","v":"07:35:00"},{"$f":"SUM(D21+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BP21+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"A Day"]
[null,"B Day"]
[null,"C Day"]
[null,"D Day"]
[null,"E Day"]
[]
[null,"Directions: Consolidate all admin, coach, and/or dean activities into a weekly schedule."]
[null,"Enter Name/Position:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Day",{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(C30+5/1440)","v":"07:35:00"},{"$f":"SUM(D30+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BP30+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"A Day"]
[null,"B Day"]
[null,"C Day"]
[null,"D Day"]
[null,"E Day"]
[]
[null,"Directions: Consolidate all admin, coach, and/or dean activities into a weekly schedule."]
[null,"Enter Name/Position:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Day",{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(C39+5/1440)","v":"07:35:00"},{"$f":"SUM(D39+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BP39+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"A Day"]
[null,"B Day"]
[null,"C Day"]
[null,"D Day"]
[null,"E Day"]
[]
[null,"Directions: Consolidate all admin, coach, and/or dean activities into a weekly schedule."]
[null,"Enter Name/Position:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key"]
[null,"Day",{"$f":"'2. Instruct. Time Allocations'!$D$14","v":"07:30:00"},{"$f":"SUM(C48+5/1440)","v":"07:35:00"},{"$f":"SUM(D48+5/1440)","v":"07:40:00"},"07:45:00","07:50:00","07:55:00","08:00:00","08:05:00","08:10:00","08:15:00","08:20:00","08:25:00","08:30:00","08:35:00","08:40:00","08:45:00","08:50:00","08:55:00","09:00:00","09:05:00","09:10:00","09:15:00","09:20:00","09:25:00","09:30:00","09:35:00","09:40:00","09:45:00","09:50:00","09:55:00","10:00:00","10:05:00","10:10:00","10:15:00","10:20:00","10:25:00","10:30:00","10:35:00","10:40:00","10:45:00","10:50:00","10:55:00","11:00:00","11:05:00","11:10:00","11:15:00","11:20:00","11:25:00","11:30:00","11:35:00","11:40:00","11:45:00","11:50:00","11:55:00","12:00:00","12:05:00","12:10:00","12:15:00","12:20:00","12:25:00","12:30:00","12:35:00","12:40:00","12:45:00","12:50:00","12:55:00",{"$f":"SUM(BP48+5/1440)","v":"13:00:00"},"13:05:00","13:10:00","13:15:00","13:20:00","13:25:00","13:30:00","13:35:00","13:40:00","13:45:00","13:50:00","13:55:00","14:00:00","14:05:00","14:10:00","14:15:00","14:20:00","14:25:00"]
[null,"A Day"]
[null,"B Day"]
[null,"C Day"]
[null,"D Day"]
[null,"E Day"]

{"sheet":"Color Reference","index":11,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Subject","Color","Red","Green","Blue"]
["Advisory",null,196,189,151,null,null,null,"Morning Transition"]
["Recess",null,255,0,255,null,null,null,"Homeroom "]
["Lunch",null,255,153,204,null,null,null,"Literacy"]
["Electives",null,255,255,153,null,null,null,"Math"]
["English",null,146,205,220,null,null,null,"Science"]
["Math",null,177,160,199,null,null,null,"Social Studies"]
["Intervention/Enrichment",null,255,192,0,null,null,null,"Special Subjects"]
["Science/Social Studies",null,218,150,148,null,null,null,"Lunch"]
["Social Studies",null,255,255,0,null,null,null,"Recess"]
["Science",null,146,208,80,null,null,null,"Intervention/Enrichment"]
["Core",null,144,137,239,null,null,null,"Dismissal Transition"]
["Foreign Language",null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C36),\"\",'2. Instruct. Time Allocations'!C36)","v":"Transitions"},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C37),\"\",'2. Instruct. Time Allocations'!C37)","v":""},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C38),\"\",'2. Instruct. Time Allocations'!C38)","v":""},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C39),\"\",'2. Instruct. Time Allocations'!C39)","v":""},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C40),\"\",'2. Instruct. Time Allocations'!C40)","v":""},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C41),\"\",'2. Instruct. Time Allocations'!C41)","v":""},null,216,228,188]
[{"$f":"IF(ISBLANK('2. Instruct. Time Allocations'!C42),\"\",'2. Instruct. Time Allocations'!C42)","v":""},null,216,228,188]