{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Setup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Break","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Conditional Formating used to highlight duplicate values in a day (column), and across each break (row)"]
[null,"A.M. Recess"]
[null,"Lunch",null,null,null,null,null,null,"This table uses data validation on each cell"]
[null,"P.M. Recess"]
[]
[]
[]
[]
[]
[null,"Break","Monday","Tuesday","Wednesday","Thursday","Friday",null,"This table uses data validation on the cells in just the Monday column.  "]
[null,"A.M. Recess",null,null,null,null,null,null,"VBA is used to populate the cells across the other days"]
[null,"Lunch",null,null,null,null,null,null,"Can delete a specific cell, VBA will fill in from first empty cell"]
[null,"P.M. Recess",null,null,null,null,null,null,"Pressing Delete key on Monday will delete the last entry in row"]
[]
[]
[]
[]
[null,"Useful Reading"]
[]
[null,"Data Validation"]
[null,"Excel Tables"]
[null,"Conditional Formatting"]
[null,"VBA Events"]

{"sheet":"Setup","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Teacher",null,"Teacher"]
[null,"John"]
[null,"Mary",null,"John"]
[null,"Alan",null,"Mary"]
[null,"Claire",null,"Alan"]
[null,"Bob",null,"Claire"]
[null,"Vanessa",null,"Bob"]
[null,null,null,"Vanessa"]