{"text_format":"1","workbook":"xlsx","n_sheets":42,"sheets":["INSTRUCTIONS","SUMMARY","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"comments":2,"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":"INSTRUCTIONS","index":0,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,9,0,10],[1,9,1,10],[2,9,2,10],[0,6,0,8]]}
["Diocese of Covington",null,null,null,null,null,"Cells are PROTECTED"]
["Teacher Leave Time Template Instructions"]
["Version 1.2"]
[]
[null,null,"SUMMARY - This tab contains a one page summary of each teacher's name, beginning sick leave"]
[null,null,"balance, days earned this year, days used this year and the ending balance."]
[null,null,"Tabs 01-40 - Each tab has one teacher's report for the year.  This can be printed out and given"]
[null,null,"to teacher(s) as needed or requested."]
[]
[null,"NAVIGATION:"]
[null,null,"SUMMARY - To navigate to the Summary tab, you can manually select the Summary tab by clicking"]
[null,null,"on it directly at the bottom of the screen.  Additionally, all other tabs have a button labeled "]
[null,null,"\"Go to Summary\" at the top, right hand side of the page.  These hyper-links will be blue;"]
[null,null,"until you click them for the first time and then they'll turn purple.  Additionally, you can navigate"]
[null,null,"to any particular teacher's report by clicking on his/her name (they are hyper-links)."]
[null,null,"Tabs 01-40 - To navigate to an individual teacher's tab, you can manually select it.  Additionally,"]
[null,null,"as mentioned above, you can click the teacher's name on the Summary tab and you will be"]
[null,null,"taken directly to that teacher's page."]
[null,null,"Cell Protection - IMPORTANT - If the note highlighted in yellow above says \"Cells are Protected\","]
[null,null,"you will only be able to enter data into cells designed for data entry.  This is to prevent accidental"]
[null,null,"erasure of formulas and the normal state that the spreadsheet should normally exist.  If the note"]
[null,null,"says \"Cells are UNPROTECTED\", please be extremely careful a you can inadvertently delete or"]
[null,null,"change formulas that can impact the integrity of the spreadsheet and the accuracy of the data."]
[null,null,"You should only have the spreadsheet set to UNPROTECTED if you need to make corrections to"]
[null,null,"to non-data cells and are confident that you know the changes you need to make are correct."]
[null,"DATA ENTRY:"]
[null,null,"All data entry cells will appear in blue; but will print in black & white."]
[null,null,"Cells that have a red 'tick' mark in the upper right hand corner contain helpful hints.  Simply hover"]
[null,null,"your mouse over the cell to see the hint.  The tick marks look like this."]
[null,null,"You can copy/paste data if necessary but be careful that you don't override formulas."]
[null,null,"It is recommended that you do NOT cut/paste as that can have unintended results in certain cells."]
[]
[null,null,"ONE TIME SETUP:"]
[null,null,"+ Select whether you want the template to track \"hours\" or \"days\"."]
[null,null,"- This is only a label and the template doesn't care which you use, but you must be consistent"]
[null,null,"and can only use one or the other; not both.  The spreadsheet is initally setup to use \"days\"."]
[null,null,"-Once you've decided; go to cell D6 on the SUMMARY tab and make your selection from the"]
[null,null,"drop down list.  The template will make all label changes throughout the workbook to match"]
[null,null,"your selection."]
[]
[null,null,"SETUP AT THE BEGINNING OF EACH YEAR"]
[null,null,"SUMMARY tab:"]
[null,null,"+ Enter the Parish/School name in cell B1 on the Summary tab.  This information will carry to all"]
[null,null,"the other tabs in the spreadsheet."]
[null,null,"+ Enter the School Year label in cell B3 on the Summary tab.  This information will carry to all"]
[null,null,"the other tabs in the spreadsheet."]
[null,null,"+ Enter Teachers Names on the Summary tab (in the order you want them to appear) in column B."]
[null,null,"- Do NOT sort this data after entry; enter them in the order you want them to appear."]
[null,null,"+ Enter the beginning balance (i.e. carried over from the prior year ) of available sick time"]
[null,null,"for each teacher in column C.  Use either hours or days, as selected from above."]
[null,null,"+ Enter the earned hours/days for each teacher for the school year in column D.  Diocesan policy"]
[null,null,"is that each teacher earns 10 days/school year.  The template comes with 10 days loaded, but"]
[null,null,"information can obviously be updated/changed as necessary."]
[]
[null,null,"DATE ENTRY EVERY PAY PERIOD"]
[null,null,"TABS 01 through 40:"]
[null,null,"+ Enter the hours or days that each teach uses on his/her individual tab; as selected from the"]
[null,null,"Summary tab."]
[null,null,"- Note that there is a column for every month and a row for every day."]
[null,null,"- As noted on the individual tabs, days (or hours) used are entered as positive amounts."]
[]
[null,"HELPFUL HINTS:"]
[null,null,"+ Printing - To print any page/tab in the spreadsheet, simply click the excel 'print' icon, or select"]
[null,null,"\"File\" from the top tabs, and then \"Print\", set the print parameters as desired and again click"]
[null,null,"\"Print\"."]
[null,null,"+ If your school has more than 40 teachers/employees, you can use more than one template"]
[null,null,"for each year.  For example, you could put the teachers in one file and non-instructional personnel "]
[null,null,"in a separate file.  You could also segregate alphabetically; A-L and M-Z."]
[null,null,"+ File management"]
[null,null,"- You should save this file using a name that will assist in finding/identifying it in the future;"]
[null,null,"keeping in mind the order that your computer is setup to display file names.  You should"]
[null,null,"have/keep a separate file for each school year.  Some examples could be:"]
[null,null,null,"2017-2018 - St. Agatha - Teacher Sick Time Log .xls"]
[null,null,null,"St. Bernadette - Teacher Sick Time Log - 2017-2018.xls"]
[null,null,null,"2017-2018 - St. Camilla Teacher Sick Time Log - A to L.xls"]
[null,null,null,"St. Daria - Teacher Sick Time Log - M to Z.xls"]
[null,null,"+ Cells with comments / instructions - If a cell has a red 'tick' mark in the upper right hand corner"]
[null,null,"that means there is a comment associated with that cell.  In order to see it, simply hover your"]
[null,null,"mouse over that cell to see the comment."]
[null,null,"+ It is suggested to use a new template downloaded from the Diocese's website every year"]
[null,null,"rather than trying to clear the current year's data.  Names/days/hours can be copied/pasted"]
[null,null,"from the existing sheet to the newly downloaded one each year."]

{"sheet":"SUMMARY","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,"{Enter School Name}"]
[null,"Teacher Leave Summary"]
[null,"{Enter School Year}"]
[]
[null,null,"Carry","Earned","Used","Ending"]
[null,"Teacher","Over","Select",{"$f":"+D6","v":"Select"},"Balance","√"]
[null,"{Enter Teacher 01 name}",0,{"$f":"IF($D$6=\"Hours\",65,10)","v":10},{"$f":"+'01'!$I$8","v":0},{"$f":"SUM(C7:E7)","v":10},{"$f":"IF(F7=SUM(C7:E7),\"ok\",\"ERR\")","v":"ok"}]
[null,"{Enter Teacher 02 name}",0,{"$f":"IF($D$6=\"Hours\",65,10)","v":10},{"$f":"+'02'!$I$8","v":0},{"$f":"SUM(C8:E8)","v":10},{"$f":"IF(F8=SUM(C8:E8),\"ok\",\"ERR\")","v":"ok"}]
[null,"{Enter Teacher 03 name}",0,10,{"$f":"+'03'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 04 name}",0,10,{"$f":"+'04'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 05 name}",0,10,{"$f":"+'05'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 06 name}",0,10,{"$f":"+'06'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 07 name}",0,10,{"$f":"+'07'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 08 name}",0,10,{"$f":"+'08'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 09 name}",0,10,{"$f":"+'09'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 10 name}",0,10,{"$f":"+'10'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 11 name}",0,10,{"$f":"+'11'!$I$8","v":0},10,{"$f":"IF(F17=SUM(C17:E17),\"ok\",\"ERR\")","v":"ok"}]
[null,"{Enter Teacher 12 name}",0,10,{"$f":"+'12'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 13 name}",0,10,{"$f":"+'13'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 14 name}",0,10,{"$f":"+'14'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 15 name}",0,10,{"$f":"+'15'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 16 name}",0,10,{"$f":"+'16'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 17 name}",0,10,{"$f":"+'17'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 18 name}",0,10,{"$f":"+'18'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 19 name}",0,10,{"$f":"+'19'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 20 name}",0,10,{"$f":"+'20'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 21 name}",0,10,{"$f":"+'21'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 22 name}",0,10,{"$f":"+'22'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 23 name}",0,10,{"$f":"+'23'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 24 name}",0,10,{"$f":"+'24'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 25 name}",0,10,{"$f":"+'25'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 26 name}",0,10,{"$f":"+'26'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 27 name}",0,10,{"$f":"+'27'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 28 name}",0,10,{"$f":"+'28'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 29 name}",0,10,{"$f":"+'29'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 30 name}",0,10,{"$f":"+'30'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 31 name}",0,10,{"$f":"+'31'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 32 name}",0,10,{"$f":"+'32'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 33 name}",0,10,{"$f":"+'33'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 34 name}",0,10,{"$f":"+'34'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 35 name}",0,10,{"$f":"+'35'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 36 name}",0,10,{"$f":"+'36'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 37 name}",0,10,{"$f":"+'37'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 38 name}",0,10,{"$f":"+'38'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 39 name}",0,10,{"$f":"+'39'!$I$8","v":0},10,"ok"]
[null,"{Enter Teacher 40 name}",0,10,{"$f":"+'40'!$I$8","v":0},10,"ok"]
[]
[null,"Total",{"$f":"SUM(C6:C47)","v":0},{"$f":"SUM(D6:D47)","v":400},{"$f":"SUM(E6:E47)","v":0},{"$f":"SUM(F6:F47)","v":400},{"$f":"IF(F48=SUM(C48:E48),\"ok\",\"ERR\")","v":"ok"}]
[null,null,{"$f":"IF(C48=SUM(C6:C47),\"ok\",\"ERR\")","v":"ok"},{"$f":"IF(D48=SUM(D6:D47),\"ok\",\"ERR\")","v":"ok"},{"$f":"IF(E48=SUM(E6:E47),\"ok\",\"ERR\")","v":"ok"},{"$f":"IF(F48=SUM(F6:F47),\"ok\",\"ERR\")","v":"ok"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select"]
[null,"Days"]
[null,"Hours"]

{"sheet":"01","index":2,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[46,1,46,14],[47,1,47,14],[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B7","v":"{Enter Teacher 01 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C7","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D7","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"02","index":3,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B8","v":"{Enter Teacher 02 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C8","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D8","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"03","index":4,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B9","v":"{Enter Teacher 03 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C9","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D9","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"04","index":5,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B10","v":"{Enter Teacher 04 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C10","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D10","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"05","index":6,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B11","v":"{Enter Teacher 05 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C11","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D11","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"06","index":7,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B12","v":"{Enter Teacher 06 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C12","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D12","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"07","index":8,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B13","v":"{Enter Teacher 07 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C13","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D13","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"08","index":9,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B14","v":"{Enter Teacher 08 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C14","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D14","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"09","index":10,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B15","v":"{Enter Teacher 09 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C15","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D15","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"10","index":11,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B16","v":"{Enter Teacher 10 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C16","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D16","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"11","index":12,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B17","v":"{Enter Teacher 11 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C17","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D17","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"12","index":13,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B18","v":"{Enter Teacher 12 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C18","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D18","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"13","index":14,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B19","v":"{Enter Teacher 13 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C19","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D19","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"14","index":15,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B20","v":"{Enter Teacher 14 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C20","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D20","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"15","index":16,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B21","v":"{Enter Teacher 15 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C21","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D21","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13,null,null,null,0]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"16","index":17,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B22","v":"{Enter Teacher 16 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C22","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D22","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"17","index":18,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B23","v":"{Enter Teacher 17 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C23","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D23","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"18","index":19,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B24","v":"{Enter Teacher 18 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C24","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D24","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"19","index":20,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B25","v":"{Enter Teacher 19 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C25","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D25","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"20","index":21,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B26","v":"{Enter Teacher 20 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C26","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D26","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"21","index":22,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B27","v":"{Enter Teacher 21 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C27","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D27","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"22","index":23,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B28","v":"{Enter Teacher 22 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C28","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D28","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"23","index":24,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B29","v":"{Enter Teacher 23 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C29","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D29","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"24","index":25,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B30","v":"{Enter Teacher 24 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C30","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D30","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"25","index":26,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B31","v":"{Enter Teacher 25 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C31","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D31","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"26","index":27,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B32","v":"{Enter Teacher 26 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C32","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D32","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"27","index":28,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B33","v":"{Enter Teacher 27 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C33","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D33","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"28","index":29,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B34","v":"{Enter Teacher 28 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C34","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D34","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"29","index":30,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B35","v":"{Enter Teacher 29 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C35","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D35","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"30","index":31,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B36","v":"{Enter Teacher 30 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C36","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D36","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"31","index":32,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B37","v":"{Enter Teacher 31 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C37","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D37","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"32","index":33,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B38","v":"{Enter Teacher 32 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C38","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D38","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"33","index":34,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B39","v":"{Enter Teacher 33 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C39","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D39","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"34","index":35,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B40","v":"{Enter Teacher 34 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C40","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D40","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"35","index":36,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B41","v":"{Enter Teacher 35 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C41","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D41","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"36","index":37,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B42","v":"{Enter Teacher 36 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C42","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D42","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"37","index":38,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B43","v":"{Enter Teacher 37 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C43","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D43","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"38","index":39,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B44","v":"{Enter Teacher 38 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C44","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D44","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"39","index":40,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B45","v":"{Enter Teacher 39 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C45","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D45","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]

{"sheet":"40","index":41,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,1,48,14],[49,1,49,14],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[46,1,46,14],[47,1,47,14]]}
[null,{"$f":"+SUMMARY!B1","v":"{Enter School Name}"}]
[null,"Teacher Leave Summary"]
[null,{"$f":"+SUMMARY!B46","v":"{Enter Teacher 40 name}"}]
[null,{"$f":"+SUMMARY!B3","v":"{Enter School Year}"}]
[]
[null,"Carry-over from last year",null,null,null,null,null,null,{"$f":"+SUMMARY!C46","v":0}]
[null,{"$f":"+SUMMARY!D6&\" earned this year\"","v":"Select earned this year"},null,null,null,null,null,null,{"$f":"+SUMMARY!D46","v":10}]
[null,{"$f":"+SUMMARY!D6&\" used this year (see below)\"","v":"Select used this year (see below)"},null,null,null,null,null,null,{"$f":"-SUM(B44:N44)","v":0}]
[null,{"$f":"+SUMMARY!D6&\" remaining\"","v":"Select remaining"},null,null,null,null,null,null,{"$f":"SUM(I6:J8)","v":10}]
[null,{"$f":"\"Enter \"&LOWER(+SUMMARY!D6)&\" used as positive amounts below\"","v":"Enter select used as positive amounts below"}]
[null,"DAY","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","NOTES"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"TOTAL",{"$f":"SUM(C11:C43)","v":0},{"$f":"SUM(D11:D43)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(M11:M43)","v":0},0]
[null,null,{"$f":"IF(C44=SUM(C11:C43),\"ok\",\"ERR\")","v":"ok"},"ok","ok","ok","ok","ok","ok","ok","ok","ok",{"$f":"IF(M44=SUM(M11:M43),\"ok\",\"ERR\")","v":"ok"},"ok"]
[null,"ADDITIONAL NOTES/COMMENTS:"]