{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Beschreibung","Tagesblatt manuell","Dateneingabe"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Beschreibung","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Muster einer Tagesauswertung"]

{"sheet":"Tagesblatt manuell","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Parki-Medikamenten-Doku",null,null,null,"Parki-Medikamenten-Doku"]
[null,null,null,"Datum",null,null,null,"Datum"]
[null,null,null,null,{"$f":"A3","v":0},{"$f":"B3","v":0}]
["Patientenname (optional)     Medikamente & Dosis",null,null,null,"Patientenname (optional)     Medikamente & Dosis"]
[" Aufwachzeit:",null,"Einschlafzeit:",null," Aufwachzeit:",null,"Einschlafzeit:"]
[null,null,null,"Essenseinnahmen",null,null,null,"Essenseinnahmen"]
["Einnahme","Wirkung ab","Wirkung bis","  (max. 4x)","Einnahme","Wirkung ab","Wirkung bis","  (max. 4x)"]
[]
[]
[]
[]
[]
["V1.3 · März2018",null,null,"http://parkinson-erlangen.de/medi-doku",{"$f":"A13","v":"V1.3 · März2018"},null,null,"http://parkinson-erlangen.de/medi-doku"]
[]
["Parki-Medikamenten-Doku",null,null,null,"Parki-Medikamenten-Doku"]
[null,null,null,"Datum",null,null,null,"Datum"]
[{"$f":"A3","v":0},{"$f":"B3","v":0},null,null,{"$f":"E3","v":0},{"$f":"F3","v":0}]
["Patientenname (optional)     Medikamente & Dosis",null,null,null,"Patientenname (optional)     Medikamente & Dosis"]
[" Aufwachzeit:",null,"Einschlafzeit:",null," Aufwachzeit:",null,"Einschlafzeit:"]
[null,null,null,"Essenseinnahmen",null,null,null,"Essenseinnahmen"]
["Einnahme","Wirkung ab","Wirkung bis","  (max. 4x)","Einnahme","Wirkung ab","Wirkung bis","  (max. 4x)"]
[]
[]
[]
[]
[]
[{"$f":"A13","v":"V1.3 · März2018"},null,null,"http://parkinson-erlangen.de/medi-doku",{"$f":"E13","v":"V1.3 · März2018"},null,null,"http://parkinson-erlangen.de/medi-doku"]

{"sheet":"Dateneingabe","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Parki-Medikamenten-Doku"]
[null,null,null,null,null,"Datum"]
[null,{"$f":"IF('Tagesblatt manuell'!B3=\"\",\"\",'Tagesblatt manuell'!B3)","v":""}]
["Patientenname (optional) + Medikamente&Dosis"]
["Einnahme","Frequ","Wirkung","Wartezeit",null,"Essenszeiten"]
["Aufwachen",null,"ab … bis","Wirkdauer","Off"]
[]
[null,null,null,{"$f":"IF(OR(A8=\"\",C8=\"\"),\"\",C8-A8)","v":""}]
[null,{"$f":"IF(A10=\"\",\"\",A10-A8)","v":""},null,{"$f":"IF(OR(C8=\"\",C9=\"\"),\"\",C9-C8)","v":""},{"$f":"IF(OR(OR(C10-C9<0),OR(C10=\"\",C9=\"\")),\"\",C10-C9)","v":""}]
[null,null,null,{"$f":"IF(OR(A10=\"\",C10=\"\"),\"\",C10-A10)","v":""}]
[null,{"$f":"IF(A12=\"\",\"\",A12-A10)","v":""},null,{"$f":"IF(OR(C10=\"\",C11=\"\"),\"\",C11-C10)","v":""},{"$f":"IF(OR(OR(C12-C11<0),OR(C12=\"\",C11=\"\")),\"\",C12-C11)","v":""}]
[null,null,null,{"$f":"IF(OR(A12=\"\",C12=\"\"),\"\",C12-A12)","v":""}]
[null,{"$f":"IF(A14=\"\",\"\",A14-A12)","v":""},null,{"$f":"IF(OR(C12=\"\",C13=\"\"),\"\",C13-C12)","v":""},{"$f":"IF(C13=\"\",\"\",F17-C13-SUM(D15:E15)-SUM(D17:E17))","v":""}]
[null,null,null,{"$f":"IF(OR(A14=\"\",C14=\"\"),\"\",C14-A14)","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",A16-A14)","v":""},null,{"$f":"IF(OR(C14=\"\",C15=\"\"),\"\",C15-C14)","v":""},{"$f":"IF(C15=\"\",\"\",F17-C15-SUM(D17:E17))","v":""}]
[null,null,null,{"$f":"IF(OR(A16=\"\",C16=\"\"),\"\",C16-A16)","v":""}]
["Einschlafen",null,null,{"$f":"IF(OR(C16=\"\",C17=\"\"),\"\",C17-C16)","v":""},{"$f":"IF(C17>0,F17-C17,\"\")","v":""},{"$f":"IF(B17=\"\",1,B17)","v":1}]
[]
["STRG+z = Kalenderdatum + Uhrzeiten zurücksetzen (Makro)"]
[]
[null,"Einnahme","Wartezeit","Wirkdauer","Leerlauf",null,"Essen"]
[{"$f":"B6","v":"00:00:00"},{"$f":"A8-B6","v":"00:00:00"},{"$f":"D8","v":""},{"$f":"D9","v":""},{"$f":"E9","v":""},"00:00:00",1]
[null,{"$f":"A10","v":"00:00:00"},{"$f":"D10","v":""},{"$f":"D11","v":""},{"$f":"E11","v":""},{"$f":"F8","v":"00:00:00"},1]
[null,{"$f":"A12","v":"00:00:00"},{"$f":"D12","v":""},{"$f":"D13","v":""},{"$f":"E13","v":""},{"$f":"F10","v":"00:00:00"},2]
[null,{"$f":"A14","v":"00:00:00"},{"$f":"D14","v":""},{"$f":"D15","v":""},{"$f":"E15","v":""},{"$f":"F12","v":"00:00:00"},1]
[null,{"$f":"A16","v":"00:00:00"},{"$f":"D16","v":""},{"$f":"D17","v":""},{"$f":"E17","v":""},{"$f":"F14","v":"00:00:00"},2]
[null,null,{"$f":"SUM(C22:C26)","v":"00:00:00"},{"$f":"SUM(D22:D26)","v":"00:00:00"},"00:00:00"]
[]
[]
[]
[]
[]
["V1.3 · März2018",null,null,null,null,"http://parkinson-erlangen.de/medi-doku"]