{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ESY&RSY"],"not_rendered":{"charts":0,"images":0,"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":"ESY&RSY","index":0,"n_rows":371,"n_cols":6,"rows_kept":371,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,5,0,10],[1,5,1,10]]}
["2017-2018",null,null,null,"SCHOOL NAME:","Welligent Elementary"]
["DATE","DAY",null,null,"LOCATION CODE:",1234]
["2017-07-01","N"]
["2017-07-02","N"]
["2017-07-03","Y"]
["2017-07-04","N"]
["2017-07-05","Y"]
["2017-07-06","Y",null,null,"NPS_ESY & RSY_2017-2018 CALENDAR"]
["2017-07-07","Y"]
["2017-07-08","N",null,null,null,"    Holiday"]
["2017-07-09","N",null,null,null,"    Weekends (Saturday/Sunday)"]
["2017-07-10","Y",null,null,null,"    Totals"]
["2017-07-11","Y"]
["2017-07-12","Y",null,null,"PLEASE DO NOT ALTER THIS TEMPLATE.  IT WAS DESIGNED TO EXPEDIATE THE UPLOADING PROCESS."]
["2017-07-13","Y",null,null,"Please follow the instructions below to complete and submission of the 2017-2018 school calendar."]
["2017-07-14","Y",null,null,"1.    Enter your School Name and Location Code in the above yellow box.  (School name and location code in boxes are examples.)"]
["2017-07-15","N",null,null,"2.    Enter 'N' for each specific day the school is closed or 'Y' for each day the school is opened. N or Y must be in uppercase."]
["2017-07-16","N",null,null,"3.    Monthly Totals (purple boxes) automatically calculates for each month."]
["2017-07-17","Y",null,null,"4.    Unless otherwise approved by LEA, NPS may operate ESY programs beginning on or after 6/29/17, for a total of 20 instructional days. "]
["2017-07-18","Y",null,null,"       RSY may not exceed 180 days.  Note:  If your ESY begins on 06/29/17 to 06/30/2017, it will not reflect on this 2017-2018 school calendar.  "]
["2017-07-19","Y",null,null,"5.    In the red boxes below, manually count and enter the total 'Y' days for ESY (B369) and RSY (B370).  Tip: Use the Monthly Totals to help with count.      "]
["2017-07-20","Y",null,null,"6.    In the purple boxes, enter the first day of ESY in cell D369, and last day of ESY in cell F369. (Dates in boxes are examples.)"]
["2017-07-21","Y",null,null,"7.    In the purple boxes, enter the first day of RSY in cell D370, and the last day of RSY in cell F370. (Dates in boxes are examples.)"]
["2017-07-22","N",null,null,"8.    The 'Grand Totals' automatically calculates.  "]
["2017-07-23","N",null,null,"9.   'SAVE' the Excel spreadsheet in this format 'Excel Macro-Enabled Workbook'."]
["2017-07-24","Y",null,null,"10.  Please submit with your contract application materials to Special-Ed-Master-Contracts@lausd.net."]
["2017-07-25","Y"]
["2017-07-26","Y"]
["2017-07-27","Y"]
["2017-07-28","Y"]
["2017-07-29","N"]
["2017-07-30","N"]
["2017-07-31","Y","July Total:",{"$f":"COUNTIF(B3:B33,\"Y\")","v":20}]
["2017-08-01","N"]
["2017-08-02","N"]
["2017-08-03","N"]
["2017-08-04","N"]
["2017-08-05","N"]
["2017-08-06","N"]
["2017-08-07","N"]
["2017-08-08","N"]
["2017-08-09","N"]
["2017-08-10","N"]
["2017-08-11","N"]
["2017-08-12","N"]
["2017-08-13","N"]
["2017-08-14","N"]
["2017-08-15","Y"]
["2017-08-16","Y"]
["2017-08-17","Y"]
["2017-08-18","Y"]
["2017-08-19","N"]
["2017-08-20","N"]
["2017-08-21","Y"]
["2017-08-22","Y"]
["2017-08-23","Y"]
["2017-08-24","Y"]
["2017-08-25","Y"]
["2017-08-26","N"]
["2017-08-27","N"]
["2017-08-28","Y"]
["2017-08-29","Y"]
["2017-08-30","Y"]
["2017-08-31","Y","August Total:",{"$f":"COUNTIF(B34:B64,\"Y\")","v":13}]
["2017-09-01","N"]
["2017-09-02","N"]
["2017-09-03","N"]
["2017-09-04","N"]
["2017-09-05","Y"]
["2017-09-06","Y"]
["2017-09-07","Y"]
["2017-09-08","Y"]
["2017-09-09","N"]
["2017-09-10","N"]
["2017-09-11","Y"]
["2017-09-12","Y"]
["2017-09-13","Y"]
["2017-09-14","Y"]
["2017-09-15","Y"]
["2017-09-16","N"]
["2017-09-17","N"]
["2017-09-18","Y"]
["2017-09-19","Y"]
["2017-09-20","Y"]
["2017-09-21","N"]
["2017-09-22","Y"]
["2017-09-23","N"]
["2017-09-24","N"]
["2017-09-25","Y"]
["2017-09-26","Y"]
["2017-09-27","Y"]
["2017-09-28","Y"]
["2017-09-29","Y"]
["2017-09-30","N","September Total:",{"$f":"COUNTIF(B65:B94,\"Y\")","v":18}]
["2017-10-01","N"]
["2017-10-02","Y"]
["2017-10-03","Y"]
["2017-10-04","Y"]
["2017-10-05","Y"]
["2017-10-06","Y"]
["2017-10-07","N"]
["2017-10-08","N"]
["2017-10-09","Y"]
["2017-10-10","Y"]
["2017-10-11","Y"]
["2017-10-12","Y"]
["2017-10-13","Y"]
["2017-10-14","N"]
["2017-10-15","N"]
["2017-10-16","Y"]
["2017-10-17","Y"]
["2017-10-18","Y"]
["2017-10-19","Y"]
["2017-10-20","Y"]
["2017-10-21","N"]
["2017-10-22","N"]
["2017-10-23","Y"]
["2017-10-24","Y"]
["2017-10-25","Y"]
["2017-10-26","Y"]
["2017-10-27","Y"]
["2017-10-28","N"]
["2017-10-29","N"]
["2017-10-30","Y"]
["2017-10-31","Y","October Total:",{"$f":"COUNTIF(B95:B125,\"Y\")","v":22}]
["2017-11-01","Y"]
["2017-11-02","Y"]
["2017-11-03","Y"]
["2017-11-04","N"]
["2017-11-05","N"]
["2017-11-06","Y"]
["2017-11-07","Y"]
["2017-11-08","Y"]
["2017-11-09","Y"]
["2017-11-10","N"]
["2017-11-11","N"]
["2017-11-12","N"]
["2017-11-13","Y"]
["2017-11-14","Y"]
["2017-11-15","Y"]
["2017-11-16","Y"]
["2017-11-17","Y"]
["2017-11-18","N"]
["2017-11-19","N"]
["2017-11-20","N"]
["2017-11-21","N"]
["2017-11-22","N"]
["2017-11-23","N"]
["2017-11-24","N"]
["2017-11-25","N"]
["2017-11-26","N"]
["2017-11-27","Y"]
["2017-11-28","Y"]
["2017-11-29","Y"]
["2017-11-30","Y","November Total:",{"$f":"COUNTIF(B126:B155,\"Y\")","v":16}]
["2017-12-01","Y"]
["2017-12-02","N"]
["2017-12-03","N"]
["2017-12-04","Y"]
["2017-12-05","Y"]
["2017-12-06","Y"]
["2017-12-07","Y"]
["2017-12-08","Y"]
["2017-12-09","N"]
["2017-12-10","N"]
["2017-12-11","Y"]
["2017-12-12","Y"]
["2017-12-13","Y"]
["2017-12-14","Y"]
["2017-12-15","Y"]
["2017-12-16","N"]
["2017-12-17","N"]
["2017-12-18","N"]
["2017-12-19","N"]
["2017-12-20","N"]
["2017-12-21","N"]
["2017-12-22","N"]
["2017-12-23","N"]
["2017-12-24","N"]
["2017-12-25","N"]
["2017-12-26","N"]
["2017-12-27","N"]
["2017-12-28","N"]
["2017-12-29","N"]
["2017-12-30","N"]
["2017-12-31","N","December Total:",{"$f":"COUNTIF(B156:B186,\"Y\")","v":11}]
["2018-01-01","N"]
["2018-01-02","N"]
["2018-01-03","N"]
["2018-01-04","N"]
["2018-01-05","N"]
["2018-01-06","N"]
["2018-01-07","N"]
["2018-01-08","Y"]
["2018-01-09","Y"]
["2018-01-10","Y"]
["2018-01-11","Y"]
["2018-01-12","Y"]
["2018-01-13","N"]
["2018-01-14","N"]
["2018-01-15","N"]
["2018-01-16","Y"]
["2018-01-17","Y"]
["2018-01-18","Y"]
["2018-01-19","Y"]
["2018-01-20","N"]
["2018-01-21","N"]
["2018-01-22","Y"]
["2018-01-23","Y"]
["2018-01-24","Y"]
["2018-01-25","Y"]
["2018-01-26","Y"]
["2018-01-27","N"]
["2018-01-28","N"]
["2018-01-29","Y"]
["2018-01-30","Y"]
["2018-01-31","Y","January Total:",{"$f":"COUNTIF(B187:B217,\"Y\")","v":17}]
["2018-02-01","Y"]
["2018-02-02","Y"]
["2018-02-03","N"]
["2018-02-04","N"]
["2018-02-05","Y"]
["2018-02-06","Y"]
["2018-02-07","Y"]
["2018-02-08","Y"]
["2018-02-09","Y"]
["2018-02-10","N"]
["2018-02-11","N"]
["2018-02-12","Y"]
["2018-02-13","Y"]
["2018-02-14","Y"]
["2018-02-15","Y"]
["2018-02-16","Y"]
["2018-02-17","N"]
["2018-02-18","N"]
["2018-02-19","N"]
["2018-02-20","Y"]
["2018-02-21","Y"]
["2018-02-22","Y"]
["2018-02-23","Y"]
["2018-02-24","N"]
["2018-02-25","N"]
["2018-02-26","Y"]
["2018-02-27","Y"]
["2018-02-28","Y","February Total:",{"$f":"COUNTIF(B218:B245,\"Y\")","v":19}]
["2018-03-01","Y"]
["2018-03-02","Y"]
["2018-03-03","N"]
["2018-03-04","N"]
["2018-03-05","Y"]
["2018-03-06","Y"]
["2018-03-07","Y"]
["2018-03-08","Y"]
["2018-03-09","Y"]
["2018-03-10","N"]
["2018-03-11","N"]
["2018-03-12","Y"]
["2018-03-13","Y"]
["2018-03-14","Y"]
["2018-03-15","Y"]
["2018-03-16","Y"]
["2018-03-17","N"]
["2018-03-18","N"]
["2018-03-19","Y"]
["2018-03-20","Y"]
["2018-03-21","Y"]
["2018-03-22","Y"]
["2018-03-23","Y"]
["2018-03-24","N"]
["2018-03-25","N"]
["2018-03-26","N"]
["2018-03-27","N"]
["2018-03-28","N"]
["2018-03-29","N"]
["2018-03-30","N"]
["2018-03-31","N","March Total:",{"$f":"COUNTIF(B246:B276,\"Y\")","v":17}]
["2018-04-01","N"]
["2018-04-02","N"]
["2018-04-03","Y"]
["2018-04-04","Y"]
["2018-04-05","Y"]
["2018-04-06","Y"]
["2018-04-07","N"]
["2018-04-08","N"]
["2018-04-09","Y"]
["2018-04-10","Y"]
["2018-04-11","Y"]
["2018-04-12","Y"]
["2018-04-13","Y"]
["2018-04-14","N"]
["2018-04-15","N"]
["2018-04-16","Y"]
["2018-04-17","Y"]
["2018-04-18","Y"]
["2018-04-19","Y"]
["2018-04-20","Y"]
["2018-04-21","N"]
["2018-04-22","N"]
["2018-04-23","Y"]
["2018-04-24","Y"]
["2018-04-25","Y"]
["2018-04-26","Y"]
["2018-04-27","Y"]
["2018-04-28","N"]
["2018-04-29","N"]
["2018-04-30","Y","April Total:",{"$f":"COUNTIF(B277:B306,\"Y\")","v":20}]
["2018-05-01","Y"]
["2018-05-02","Y"]
["2018-05-03","Y"]
["2018-05-04","Y"]
["2018-05-05","N"]
["2018-05-06","N"]
["2018-05-07","Y"]
["2018-05-08","Y"]
["2018-05-09","Y"]
["2018-05-10","Y"]
["2018-05-11","Y"]
["2018-05-12","N"]
["2018-05-13","N"]
["2018-05-14","Y"]
["2018-05-15","Y"]
["2018-05-16","Y"]
["2018-05-17","Y"]
["2018-05-18","Y"]
["2018-05-19","N"]
["2018-05-20","N"]
["2018-05-21","Y"]
["2018-05-22","Y"]
["2018-05-23","Y"]
["2018-05-24","Y"]
["2018-05-25","Y"]
["2018-05-26","N"]
["2018-05-27","N"]
["2018-05-28","N"]
["2018-05-29","Y"]
["2018-05-30","Y"]
["2018-05-31","Y","May Total:",{"$f":"COUNTIF(B307:B337,\"Y\")","v":22}]
["2018-06-01","Y"]
["2018-06-02","N"]
["2018-06-03","N"]
["2018-06-04","Y"]
["2018-06-05","Y"]
["2018-06-06","Y"]
["2018-06-07","Y"]
["2018-06-08","N"]
["2018-06-09","N"]
["2018-06-10","N"]
["2018-06-11","N"]
["2018-06-12","N"]
["2018-06-13","N"]
["2018-06-14","N"]
["2018-06-15","N"]
["2018-06-16","N"]
["2018-06-17","N"]
["2018-06-18","N"]
["2018-06-19","N"]
["2018-06-20","N"]
["2018-06-21","N"]
["2018-06-22","N"]
["2018-06-23","N"]
["2018-06-24","N"]
["2018-06-25","N"]
["2018-06-26","N"]
["2018-06-27","N"]
["2018-06-28","N"]
["2018-06-29","N"]
["2018-06-30","N","June Total:",{"$f":"COUNTIF(B338:B367,\"Y\")","v":5}]
[]
["Total for ESY \"Y\":",20,"FIRST DAY OF ESY: ","2017-07-01","LAST DAY OF ESY: ","2017-07-31"]
["Total for RSY \"Y\":",180,"FIRST DAY OF RSY: ","2017-08-15","LAST DAY OF RSY: ","2018-06-07"]
["GRAND TOTAL: ",{"$f":"SUM(B369,B370)","v":200},"GRAND TOTAL:",{"$f":"D33+D64+D94+D125+D155+D186+D217+D245+D276+D306+D337+D367","v":200}]