{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Checkin","Weekly Schedule","Patrons","Time in - out"],"not_rendered":{"charts":0,"images":0,"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":"Checkin","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Weekly Schedule","index":1,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
[]
[null,"Sunday",null,"Mondy",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday"]
[null,"Patrons","Volunteer","Patrons","Volunteer","Patrons","Volunteer","Patrons","Volunteer","Patrons","Volunteer","Patrons","Volunteer","Patrons","Volunteer",1]
["Overnight AM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["08:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["08:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["09:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
["09:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
["10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["10:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
["11:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
["11:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
["12:00:00"]
["12:30:00"]
["13:00:00"]
["13:30:00"]
["14:00:00"]
["14:30:00"]
["15:00:00"]
["15:30:00"]
["16:00:00"]
["16:30:00"]
["17:00:00"]
["17:30:00"]
["18:00:00"]
["18:30:00"]
["19:00:00"]
["19:30:00"]
["20:00:00"]
["20:30:00"]
["21:00:00"]
["21:30:00"]
["Overnight PM"]

{"sheet":"Patrons","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["First Name","Middle Name","Last Name","Adopted/Foster Family",null,"Brithdate","Age","Parent/guardian (1)","Parent/guardian (2)","Parent/guardian (3)","Parent/guardian (4)","Notes","Checked in"]
["Becca","Maria","Jones","Pieper","Becca Jones","5/6/1983",{"$f":"INT((TODAY()-F2)/365)","v":31},"","","to see","what happens","","x"]
["Michael","Reid","Jones",null,"Michael Jones","10/26/1985",29]
["Jacob","Samuel","Jones",null,"Jacob Jones","7/21/2010",4,"Michael Jones","Becca Jones","test","test","Can not be picked up by Grandma"]
["Daniel","Reid","Jones",null,"Daniel Jones","3/25/2012",2,"Michael Jones","Becca Jones","","","cries a lot","x"]
["Nathan","Richard","Jones",null,"Nathan Jones","6/6/2014",{"$f":"INT((TODAY()-F6)/365)","v":0},"Michael Jones","Becca Jones",null,null,""]
["Sarah","Ann","Smith",null,"Sarah Smith","12/25/2002",{"$f":"INT((TODAY()-F7)/365)","v":11},"Annie Smith","George Smith","","","Allergies to peanuts","x"]
["Jim",null,"Jones",null,"Jim  Jones","5/24/1989",{"$f":"INT((TODAY()-F8)/365)","v":25},"","","","","","x"]
["Jose",null,"Gonzalez",null,"Jose Gonzalez","10/20/2000",{"$f":"INT((TODAY()-F9)/365)","v":14},"","","","",""]

{"sheet":"Time in - out","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["no text"]
["Name","Time In - Date","Time In - Time","Time Out - Date","Time Out - Time","Duration","Overnight?"]
["Do not delete","this","is","just","as ","example","line"]
["Nathan Jones","2014-11-25","17:12:41","2014-11-25","17:12:48",8.101851851871622E-5]
["Nathan Jones","2014-11-25","17:12:51","2014-11-25","17:12:55",4.6296296296377548E-5,null,null,"Total Hours",{"$f":"SUM(F4:F1048576)","v":2.3365046296296299}]
["Becca Jones","2014-11-25","17:12:59","2014-11-25","17:13:07",9.2592592592644074E-5,null,null,"Unique Patrons",{"$f":"SUMPRODUCT((A4:A99999<>\"\")/COUNTIF(A4:A99999,A4:A99999&\"\"))","v":6.9999999999999991}]
["Michael Jones","2014-11-25","17:13:03","2014-11-25","17:13:11",9.2592592592644074E-5,null,null,"Total Patron visits",{"$f":"COUNTA(A4:A1048576)","v":14}]
["Becca Jones","2014-11-25","19:56:56","2014-11-25","20:35:10",2.6550925925926006E-2,null,null,"New Patrons"]
["Michael Jones","2014-11-25","19:59:35","2014-11-25","20:35:13",2.474537037037039E-2,null,null,"Overnight Visits",{"$f":"COUNTA(G4:G1048576)","v":3}]
["Jacob Jones","2014-11-25","20:04:57","2014-11-26","16:07:36",0.83517361111111099,true,null,"Adopted/Foster Families",{"$f":"SUMPRODUCT((Patrons!D2:D1048576<>\"\")/COUNTIF(Patrons!D2:D1048576,Patrons!D2:D1048576&\"\"))","v":1}]
["Daniel Jones","2014-11-25","20:35:17"]
["Michael Jones","2014-11-25","20:35:54","2014-12-09","14:37:12",0.75090277777777781,true]
["Becca Jones","2014-11-25","20:38:28"]
["Nathan Jones","2014-11-26","16:07:24","2014-12-04","08:36:16",0.68671296296296291,true]
["Sarah Smith","2014-12-04","08:36:00"]
["Jim  Jones","2014-12-09","14:37:07"]
["Michael Jones","2014-12-10","13:38:45","2014-12-10","13:56:11",1.2106481481481413E-2]