{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Daten","Berechnung","Eingabe","Hilfsfelder"],"not_rendered":{"charts":0,"images":3,"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":"Daten","index":0,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":true,"merged":[[2,0,2,12]]}
["Medikament","Dosierung","Einnahme",null,null,null,"Anwendung aktiv","Anwendung","Bemerkung","Anfangs-Bestand-Menge","Datum Anfangs-Bestand","Zugang Neu-Datum","Zugang Neu-Menge"]
[]
["\"Bitte keine Einträge von Hand durchführen, sondern die Eingabemaske benutzen!\""]
["Pradaxa","150mg",1,null,1,null,"x","Hemmung der Blutgerinnung","Beispiel",175,"19.03.2019","19.03.2019"]
["Bisoprolol","2,5mg",1,null,1,null,"x","Betablocker - Bluthochdruck","Beispiel",80,"01.04.2019","01.04.2019"]

{"sheet":"Berechnung","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,0,1,2]]}
[]
["Verbrauch",null,null,"Restbestand","Verbraucht","Bestand Neu","Bestell-Datum"]
["pro Tag","pro Woche","Gesamt","Gesamt","Am","Gesamt","spätestens"]
[{"$f":"IF(Daten!G4=\"x\",IF(SUM(Daten!C4:F4)=0,\"\",SUM(Daten!C4:F4)),\"\")","v":2},{"$f":"IFERROR(A4*7,\"\")","v":14},{"$f":"IF(Daten!G4=\"x\",(TODAY()-Daten!K4)*A4,\"\")","v":30},{"$f":"IF(Daten!G4=0,\"\",IF(Daten!G4=\"bei Bedarf\",Daten!J4,SUM(Daten!J4)-C4))","v":145},{"$f":"IFERROR(Daten!L4+(F4/A4),\"\")","v":"2019-05-30T12:00:00"},{"$f":"IF(Daten!G4=0,\"\",IF(Daten!G4=\"bei Bedarf\",Daten!J4,IF(Daten!M4=0,D4,Daten!J4-C4+Daten!M4)))","v":145},{"$f":"IFERROR(E4-5,\"\")","v":"2019-05-25T12:00:00"}]
[{"$f":"IF(Daten!G5=\"x\",IF(SUM(Daten!C5:F5)=0,\"\",SUM(Daten!C5:F5)),\"\")","v":2},{"$f":"IFERROR(A5*7,\"\")","v":14},{"$f":"IF(Daten!G5=\"x\",(TODAY()-Daten!K5)*A5,\"\")","v":4},{"$f":"IF(Daten!G5=0,\"\",IF(Daten!G5=\"bei Bedarf\",Daten!J5,SUM(Daten!J5)-C5))","v":76},{"$f":"IFERROR(Daten!L5+(F5/A5),\"\")","v":"2019-05-09"},{"$f":"IF(Daten!G5=0,\"\",IF(Daten!G5=\"bei Bedarf\",Daten!J5,IF(Daten!M5=0,D5,Daten!J5-C5+Daten!M5)))","v":76},{"$f":"IFERROR(E5-5,\"\")","v":"2019-05-04"}]
[{"$f":"IF(Daten!G6=\"x\",IF(SUM(Daten!C6:F6)=0,\"\",SUM(Daten!C6:F6)),\"\")","v":""},"",{"$f":"IF(Daten!G6=\"x\",(TODAY()-Daten!K6)*A6,\"\")","v":""},{"$f":"IF(Daten!G6=0,\"\",IF(Daten!G6=\"bei Bedarf\",Daten!J6,SUM(Daten!J6)-C6))","v":""},{"$f":"IFERROR(Daten!L6+(F6/A6),\"\")","v":""},{"$f":"IF(Daten!G6=0,\"\",IF(Daten!G6=\"bei Bedarf\",Daten!J6,IF(Daten!M6=0,D6,Daten!J6-C6+Daten!M6)))","v":""},""]
[{"$f":"IF(Daten!G7=\"x\",IF(SUM(Daten!C7:F7)=0,\"\",SUM(Daten!C7:F7)),\"\")","v":""},"",{"$f":"IF(Daten!G7=\"x\",(TODAY()-Daten!K7)*A7,\"\")","v":""},{"$f":"IF(Daten!G7=0,\"\",IF(Daten!G7=\"bei Bedarf\",Daten!J7,SUM(Daten!J7)-C7))","v":""},{"$f":"IFERROR(Daten!L7+(F7/A7),\"\")","v":""},{"$f":"IF(Daten!G7=0,\"\",IF(Daten!G7=\"bei Bedarf\",Daten!J7,IF(Daten!M7=0,D7,Daten!J7-C7+Daten!M7)))","v":""},""]
[{"$f":"IF(Daten!G8=\"x\",IF(SUM(Daten!C8:F8)=0,\"\",SUM(Daten!C8:F8)),\"\")","v":""},"",{"$f":"IF(Daten!G8=\"x\",(TODAY()-Daten!K8)*A8,\"\")","v":""},{"$f":"IF(Daten!G8=0,\"\",IF(Daten!G8=\"bei Bedarf\",Daten!J8,SUM(Daten!J8)-C8))","v":""},{"$f":"IFERROR(Daten!L8+(F8/A8),\"\")","v":""},{"$f":"IF(Daten!G8=0,\"\",IF(Daten!G8=\"bei Bedarf\",Daten!J8,IF(Daten!M8=0,D8,Daten!J8-C8+Daten!M8)))","v":""},""]
[{"$f":"IF(Daten!G9=\"x\",IF(SUM(Daten!C9:F9)=0,\"\",SUM(Daten!C9:F9)),\"\")","v":""},"",{"$f":"IF(Daten!G9=\"x\",(TODAY()-Daten!K9)*A9,\"\")","v":""},{"$f":"IF(Daten!G9=0,\"\",IF(Daten!G9=\"bei Bedarf\",Daten!J9,SUM(Daten!J9)-C9))","v":""},{"$f":"IFERROR(Daten!L9+(F9/A9),\"\")","v":""},{"$f":"IF(Daten!G9=0,\"\",IF(Daten!G9=\"bei Bedarf\",Daten!J9,IF(Daten!M9=0,D9,Daten!J9-C9+Daten!M9)))","v":""},""]
[{"$f":"IF(Daten!G10=\"x\",IF(SUM(Daten!C10:F10)=0,\"\",SUM(Daten!C10:F10)),\"\")","v":""},"",{"$f":"IF(Daten!G10=\"x\",(TODAY()-Daten!K10)*A10,\"\")","v":""},{"$f":"IF(Daten!G10=0,\"\",IF(Daten!G10=\"bei Bedarf\",Daten!J10,SUM(Daten!J10)-C10))","v":""},{"$f":"IFERROR(Daten!L10+(F10/A10),\"\")","v":""},{"$f":"IF(Daten!G10=0,\"\",IF(Daten!G10=\"bei Bedarf\",Daten!J10,IF(Daten!M10=0,D10,Daten!J10-C10+Daten!M10)))","v":""},""]
[{"$f":"IF(Daten!G11=\"x\",IF(SUM(Daten!C11:F11)=0,\"\",SUM(Daten!C11:F11)),\"\")","v":""},"",{"$f":"IF(Daten!G11=\"x\",(TODAY()-Daten!K11)*A11,\"\")","v":""},{"$f":"IF(Daten!G11=0,\"\",IF(Daten!G11=\"bei Bedarf\",Daten!J11,SUM(Daten!J11)-C11))","v":""},{"$f":"IFERROR(Daten!L11+(F11/A11),\"\")","v":""},{"$f":"IF(Daten!G11=0,\"\",IF(Daten!G11=\"bei Bedarf\",Daten!J11,IF(Daten!M11=0,D11,Daten!J11-C11+Daten!M11)))","v":""},""]
[{"$f":"IF(Daten!G12=\"x\",IF(SUM(Daten!C12:F12)=0,\"\",SUM(Daten!C12:F12)),\"\")","v":""},"",{"$f":"IF(Daten!G12=\"x\",(TODAY()-Daten!K12)*A12,\"\")","v":""},{"$f":"IF(Daten!G12=0,\"\",IF(Daten!G12=\"bei Bedarf\",Daten!J12,SUM(Daten!J12)-C12))","v":""},{"$f":"IFERROR(Daten!L12+(F12/A12),\"\")","v":""},{"$f":"IF(Daten!G12=0,\"\",IF(Daten!G12=\"bei Bedarf\",Daten!J12,IF(Daten!M12=0,D12,Daten!J12-C12+Daten!M12)))","v":""},""]
[{"$f":"IF(Daten!G13=\"x\",IF(SUM(Daten!C13:F13)=0,\"\",SUM(Daten!C13:F13)),\"\")","v":""},"",{"$f":"IF(Daten!G13=\"x\",(TODAY()-Daten!K13)*A13,\"\")","v":""},{"$f":"IF(Daten!G13=0,\"\",IF(Daten!G13=\"bei Bedarf\",Daten!J13,SUM(Daten!J13)-C13))","v":""},{"$f":"IFERROR(Daten!L13+(F13/A13),\"\")","v":""},{"$f":"IF(Daten!G13=0,\"\",IF(Daten!G13=\"bei Bedarf\",Daten!J13,IF(Daten!M13=0,D13,Daten!J13-C13+Daten!M13)))","v":""},""]
[{"$f":"IF(Daten!G14=\"x\",IF(SUM(Daten!C14:F14)=0,\"\",SUM(Daten!C14:F14)),\"\")","v":""},"",{"$f":"IF(Daten!G14=\"x\",(TODAY()-Daten!K14)*A14,\"\")","v":""},{"$f":"IF(Daten!G14=0,\"\",IF(Daten!G14=\"bei Bedarf\",Daten!J14,SUM(Daten!J14)-C14))","v":""},{"$f":"IFERROR(Daten!L14+(F14/A14),\"\")","v":""},{"$f":"IF(Daten!G14=0,\"\",IF(Daten!G14=\"bei Bedarf\",Daten!J14,IF(Daten!M14=0,D14,Daten!J14-C14+Daten!M14)))","v":""},""]
[{"$f":"IF(Daten!G15=\"x\",IF(SUM(Daten!C15:F15)=0,\"\",SUM(Daten!C15:F15)),\"\")","v":""},"",{"$f":"IF(Daten!G15=\"x\",(TODAY()-Daten!K15)*A15,\"\")","v":""},{"$f":"IF(Daten!G15=0,\"\",IF(Daten!G15=\"bei Bedarf\",Daten!J15,SUM(Daten!J15)-C15))","v":""},{"$f":"IFERROR(Daten!L15+(F15/A15),\"\")","v":""},{"$f":"IF(Daten!G15=0,\"\",IF(Daten!G15=\"bei Bedarf\",Daten!J15,IF(Daten!M15=0,D15,Daten!J15-C15+Daten!M15)))","v":""},""]
[{"$f":"IF(Daten!G16=\"x\",IF(SUM(Daten!C16:F16)=0,\"\",SUM(Daten!C16:F16)),\"\")","v":""},"",{"$f":"IF(Daten!G16=\"x\",(TODAY()-Daten!K16)*A16,\"\")","v":""},{"$f":"IF(Daten!G16=0,\"\",IF(Daten!G16=\"bei Bedarf\",Daten!J16,SUM(Daten!J16)-C16))","v":""},{"$f":"IFERROR(Daten!L16+(F16/A16),\"\")","v":""},{"$f":"IF(Daten!G16=0,\"\",IF(Daten!G16=\"bei Bedarf\",Daten!J16,IF(Daten!M16=0,D16,Daten!J16-C16+Daten!M16)))","v":""},""]
[{"$f":"IF(Daten!G17=\"x\",IF(SUM(Daten!C17:F17)=0,\"\",SUM(Daten!C17:F17)),\"\")","v":""},"",{"$f":"IF(Daten!G17=\"x\",(TODAY()-Daten!K17)*A17,\"\")","v":""},{"$f":"IF(Daten!G17=0,\"\",IF(Daten!G17=\"bei Bedarf\",Daten!J17,SUM(Daten!J17)-C17))","v":""},{"$f":"IFERROR(Daten!L17+(F17/A17),\"\")","v":""},{"$f":"IF(Daten!G17=0,\"\",IF(Daten!G17=\"bei Bedarf\",Daten!J17,IF(Daten!M17=0,D17,Daten!J17-C17+Daten!M17)))","v":""},""]
[{"$f":"IF(Daten!G18=\"x\",IF(SUM(Daten!C18:F18)=0,\"\",SUM(Daten!C18:F18)),\"\")","v":""},"",{"$f":"IF(Daten!G18=\"x\",(TODAY()-Daten!K18)*A18,\"\")","v":""},{"$f":"IF(Daten!G18=0,\"\",IF(Daten!G18=\"bei Bedarf\",Daten!J18,SUM(Daten!J18)-C18))","v":""},{"$f":"IFERROR(Daten!L18+(F18/A18),\"\")","v":""},{"$f":"IF(Daten!G18=0,\"\",IF(Daten!G18=\"bei Bedarf\",Daten!J18,IF(Daten!M18=0,D18,Daten!J18-C18+Daten!M18)))","v":""},""]
[{"$f":"IF(Daten!G19=\"x\",IF(SUM(Daten!C19:F19)=0,\"\",SUM(Daten!C19:F19)),\"\")","v":""},"",{"$f":"IF(Daten!G19=\"x\",(TODAY()-Daten!K19)*A19,\"\")","v":""},{"$f":"IF(Daten!G19=0,\"\",IF(Daten!G19=\"bei Bedarf\",Daten!J19,SUM(Daten!J19)-C19))","v":""},{"$f":"IFERROR(Daten!L19+(F19/A19),\"\")","v":""},{"$f":"IF(Daten!G19=0,\"\",IF(Daten!G19=\"bei Bedarf\",Daten!J19,IF(Daten!M19=0,D19,Daten!J19-C19+Daten!M19)))","v":""},""]
[{"$f":"IF(Daten!G20=\"x\",IF(SUM(Daten!C20:F20)=0,\"\",SUM(Daten!C20:F20)),\"\")","v":""},"",{"$f":"IF(Daten!G20=\"x\",(TODAY()-Daten!K20)*A20,\"\")","v":""},{"$f":"IF(Daten!G20=0,\"\",IF(Daten!G20=\"bei Bedarf\",Daten!J20,SUM(Daten!J20)-C20))","v":""},{"$f":"IFERROR(Daten!L20+(F20/A20),\"\")","v":""},{"$f":"IF(Daten!G20=0,\"\",IF(Daten!G20=\"bei Bedarf\",Daten!J20,IF(Daten!M20=0,D20,Daten!J20-C20+Daten!M20)))","v":""},""]
[{"$f":"IF(Daten!G21=\"x\",IF(SUM(Daten!C21:F21)=0,\"\",SUM(Daten!C21:F21)),\"\")","v":""},"",{"$f":"IF(Daten!G21=\"x\",(TODAY()-Daten!K21)*A21,\"\")","v":""},{"$f":"IF(Daten!G21=0,\"\",IF(Daten!G21=\"bei Bedarf\",Daten!J21,SUM(Daten!J21)-C21))","v":""},{"$f":"IFERROR(Daten!L21+(F21/A21),\"\")","v":""},{"$f":"IF(Daten!G21=0,\"\",IF(Daten!G21=\"bei Bedarf\",Daten!J21,IF(Daten!M21=0,D21,Daten!J21-C21+Daten!M21)))","v":""},""]
[{"$f":"IF(Daten!G22=\"x\",IF(SUM(Daten!C22:F22)=0,\"\",SUM(Daten!C22:F22)),\"\")","v":""},"",{"$f":"IF(Daten!G22=\"x\",(TODAY()-Daten!K22)*A22,\"\")","v":""},{"$f":"IF(Daten!G22=0,\"\",IF(Daten!G22=\"bei Bedarf\",Daten!J22,SUM(Daten!J22)-C22))","v":""},{"$f":"IFERROR(Daten!L22+(F22/A22),\"\")","v":""},{"$f":"IF(Daten!G22=0,\"\",IF(Daten!G22=\"bei Bedarf\",Daten!J22,IF(Daten!M22=0,D22,Daten!J22-C22+Daten!M22)))","v":""},""]
[{"$f":"IF(Daten!G23=\"x\",IF(SUM(Daten!C23:F23)=0,\"\",SUM(Daten!C23:F23)),\"\")","v":""},"",{"$f":"IF(Daten!G23=\"x\",(TODAY()-Daten!K23)*A23,\"\")","v":""},{"$f":"IF(Daten!G23=0,\"\",IF(Daten!G23=\"bei Bedarf\",Daten!J23,SUM(Daten!J23)-C23))","v":""},{"$f":"IFERROR(Daten!L23+(F23/A23),\"\")","v":""},{"$f":"IF(Daten!G23=0,\"\",IF(Daten!G23=\"bei Bedarf\",Daten!J23,IF(Daten!M23=0,D23,Daten!J23-C23+Daten!M23)))","v":""},""]
[{"$f":"IF(Daten!G24=\"x\",IF(SUM(Daten!C24:F24)=0,\"\",SUM(Daten!C24:F24)),\"\")","v":""},"",{"$f":"IF(Daten!G24=\"x\",(TODAY()-Daten!K24)*A24,\"\")","v":""},{"$f":"IF(Daten!G24=0,\"\",IF(Daten!G24=\"bei Bedarf\",Daten!J24,SUM(Daten!J24)-C24))","v":""},{"$f":"IFERROR(Daten!L24+(F24/A24),\"\")","v":""},{"$f":"IF(Daten!G24=0,\"\",IF(Daten!G24=\"bei Bedarf\",Daten!J24,IF(Daten!M24=0,D24,Daten!J24-C24+Daten!M24)))","v":""},""]
[{"$f":"IF(Daten!G25=\"x\",IF(SUM(Daten!C25:F25)=0,\"\",SUM(Daten!C25:F25)),\"\")","v":""},"",{"$f":"IF(Daten!G25=\"x\",(TODAY()-Daten!K25)*A25,\"\")","v":""},{"$f":"IF(Daten!G25=0,\"\",IF(Daten!G25=\"bei Bedarf\",Daten!J25,SUM(Daten!J25)-C25))","v":""},{"$f":"IFERROR(Daten!L25+(F25/A25),\"\")","v":""},{"$f":"IF(Daten!G25=0,\"\",IF(Daten!G25=\"bei Bedarf\",Daten!J25,IF(Daten!M25=0,D25,Daten!J25-C25+Daten!M25)))","v":""},""]
[{"$f":"IF(Daten!G26=\"x\",IF(SUM(Daten!C26:F26)=0,\"\",SUM(Daten!C26:F26)),\"\")","v":""},"",{"$f":"IF(Daten!G26=\"x\",(TODAY()-Daten!K26)*A26,\"\")","v":""},{"$f":"IF(Daten!G26=0,\"\",IF(Daten!G26=\"bei Bedarf\",Daten!J26,SUM(Daten!J26)-C26))","v":""},{"$f":"IFERROR(Daten!L26+(F26/A26),\"\")","v":""},{"$f":"IF(Daten!G26=0,\"\",IF(Daten!G26=\"bei Bedarf\",Daten!J26,IF(Daten!M26=0,D26,Daten!J26-C26+Daten!M26)))","v":""},""]

{"sheet":"Eingabe","index":2,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Name:","Geburts-datum:"]
["Max Mustermann","1900-01-01"]
["Name Medikament","Dosis","Tag (Mo-So)","Morgens","Mittags","Abends","Nachts","Anwendung","Bemerkung","Bestand","Aufbrauch","Bestellung spätestens Aufbrauch  plus 5 Tage"]
[{"$f":"IF(Daten!A4=0,\"\",Daten!A4)","v":"Pradaxa"},{"$f":"IF(Daten!B4=0,\"\",Daten!B4)","v":"150mg"},{"$f":"IF(Daten!G4=0,\"\",Daten!G4)","v":"x"},{"$f":"IF(Daten!C4=0,\"\",Daten!C4)","v":1},{"$f":"IF(Daten!D4=0,\"\",Daten!D4)","v":""},{"$f":"IF(Daten!E4=0,\"\",Daten!E4)","v":1},{"$f":"IF(Daten!F4=0,\"\",Daten!F4)","v":""},{"$f":"IF(Daten!H4=0,\"\",Daten!H4)","v":"Hemmung der Blutgerinnung"},{"$f":"IF(Daten!I4=0,\"\",Daten!I4)","v":"Beispiel"},{"$f":"IF(Berechnung!F4=0,\"\",Berechnung!F4)","v":145},{"$f":"IFERROR(Berechnung!E4,\"\")","v":"2019-05-30T12:00:00"},{"$f":"IFERROR(Berechnung!G4,\"\")","v":"2019-05-25T12:00:00"}]
[{"$f":"IF(Daten!A5=0,\"\",Daten!A5)","v":"Bisoprolol"},{"$f":"IF(Daten!B5=0,\"\",Daten!B5)","v":"2,5mg"},{"$f":"IF(Daten!G5=0,\"\",Daten!G5)","v":"x"},{"$f":"IF(Daten!C5=0,\"\",Daten!C5)","v":1},{"$f":"IF(Daten!D5=0,\"\",Daten!D5)","v":""},{"$f":"IF(Daten!E5=0,\"\",Daten!E5)","v":1},{"$f":"IF(Daten!F5=0,\"\",Daten!F5)","v":""},{"$f":"IF(Daten!H5=0,\"\",Daten!H5)","v":"Betablocker - Bluthochdruck"},{"$f":"IF(Daten!I5=0,\"\",Daten!I5)","v":"Beispiel"},{"$f":"IF(Berechnung!F5=0,\"\",Berechnung!F5)","v":76},{"$f":"IFERROR(Berechnung!E5,\"\")","v":"2019-05-09"},{"$f":"IFERROR(Berechnung!G5,\"\")","v":"2019-05-04"}]
[{"$f":"IF(Daten!A6=0,\"\",Daten!A6)","v":""},{"$f":"IF(Daten!B6=0,\"\",Daten!B6)","v":""},{"$f":"IF(Daten!G6=0,\"\",Daten!G6)","v":""},{"$f":"IF(Daten!C6=0,\"\",Daten!C6)","v":""},{"$f":"IF(Daten!D6=0,\"\",Daten!D6)","v":""},{"$f":"IF(Daten!E6=0,\"\",Daten!E6)","v":""},{"$f":"IF(Daten!F6=0,\"\",Daten!F6)","v":""},{"$f":"IF(Daten!H6=0,\"\",Daten!H6)","v":""},{"$f":"IF(Daten!I6=0,\"\",Daten!I6)","v":""},{"$f":"IF(Berechnung!F6=0,\"\",Berechnung!F6)","v":""},{"$f":"IFERROR(Berechnung!E6,\"\")","v":""},{"$f":"IFERROR(Berechnung!G6,\"\")","v":""}]
[{"$f":"IF(Daten!A7=0,\"\",Daten!A7)","v":""},{"$f":"IF(Daten!B7=0,\"\",Daten!B7)","v":""},{"$f":"IF(Daten!G7=0,\"\",Daten!G7)","v":""},{"$f":"IF(Daten!C7=0,\"\",Daten!C7)","v":""},{"$f":"IF(Daten!D7=0,\"\",Daten!D7)","v":""},{"$f":"IF(Daten!E7=0,\"\",Daten!E7)","v":""},{"$f":"IF(Daten!F7=0,\"\",Daten!F7)","v":""},{"$f":"IF(Daten!H7=0,\"\",Daten!H7)","v":""},{"$f":"IF(Daten!I7=0,\"\",Daten!I7)","v":""},{"$f":"IF(Berechnung!F7=0,\"\",Berechnung!F7)","v":""},{"$f":"IFERROR(Berechnung!E7,\"\")","v":""},{"$f":"IFERROR(Berechnung!G7,\"\")","v":""}]
[{"$f":"IF(Daten!A8=0,\"\",Daten!A8)","v":""},{"$f":"IF(Daten!B8=0,\"\",Daten!B8)","v":""},{"$f":"IF(Daten!G8=0,\"\",Daten!G8)","v":""},{"$f":"IF(Daten!C8=0,\"\",Daten!C8)","v":""},{"$f":"IF(Daten!D8=0,\"\",Daten!D8)","v":""},{"$f":"IF(Daten!E8=0,\"\",Daten!E8)","v":""},{"$f":"IF(Daten!F8=0,\"\",Daten!F8)","v":""},{"$f":"IF(Daten!H8=0,\"\",Daten!H8)","v":""},{"$f":"IF(Daten!I8=0,\"\",Daten!I8)","v":""},{"$f":"IF(Berechnung!F8=0,\"\",Berechnung!F8)","v":""},{"$f":"IFERROR(Berechnung!E8,\"\")","v":""},{"$f":"IFERROR(Berechnung!G8,\"\")","v":""}]
[{"$f":"IF(Daten!A9=0,\"\",Daten!A9)","v":""},{"$f":"IF(Daten!B9=0,\"\",Daten!B9)","v":""},{"$f":"IF(Daten!G9=0,\"\",Daten!G9)","v":""},{"$f":"IF(Daten!C9=0,\"\",Daten!C9)","v":""},{"$f":"IF(Daten!D9=0,\"\",Daten!D9)","v":""},{"$f":"IF(Daten!E9=0,\"\",Daten!E9)","v":""},{"$f":"IF(Daten!F9=0,\"\",Daten!F9)","v":""},{"$f":"IF(Daten!H9=0,\"\",Daten!H9)","v":""},{"$f":"IF(Daten!I9=0,\"\",Daten!I9)","v":""},{"$f":"IF(Berechnung!F9=0,\"\",Berechnung!F9)","v":""},{"$f":"IFERROR(Berechnung!E9,\"\")","v":""},{"$f":"IFERROR(Berechnung!G9,\"\")","v":""}]
[{"$f":"IF(Daten!A10=0,\"\",Daten!A10)","v":""},{"$f":"IF(Daten!B10=0,\"\",Daten!B10)","v":""},{"$f":"IF(Daten!G10=0,\"\",Daten!G10)","v":""},{"$f":"IF(Daten!C10=0,\"\",Daten!C10)","v":""},{"$f":"IF(Daten!D10=0,\"\",Daten!D10)","v":""},{"$f":"IF(Daten!E10=0,\"\",Daten!E10)","v":""},{"$f":"IF(Daten!F10=0,\"\",Daten!F10)","v":""},{"$f":"IF(Daten!H10=0,\"\",Daten!H10)","v":""},{"$f":"IF(Daten!I10=0,\"\",Daten!I10)","v":""},{"$f":"IF(Berechnung!F10=0,\"\",Berechnung!F10)","v":""},{"$f":"IFERROR(Berechnung!E10,\"\")","v":""},{"$f":"IFERROR(Berechnung!G10,\"\")","v":""}]
[{"$f":"IF(Daten!A11=0,\"\",Daten!A11)","v":""},{"$f":"IF(Daten!B11=0,\"\",Daten!B11)","v":""},{"$f":"IF(Daten!G11=0,\"\",Daten!G11)","v":""},{"$f":"IF(Daten!C11=0,\"\",Daten!C11)","v":""},{"$f":"IF(Daten!D11=0,\"\",Daten!D11)","v":""},{"$f":"IF(Daten!E11=0,\"\",Daten!E11)","v":""},{"$f":"IF(Daten!F11=0,\"\",Daten!F11)","v":""},{"$f":"IF(Daten!H11=0,\"\",Daten!H11)","v":""},{"$f":"IF(Daten!I11=0,\"\",Daten!I11)","v":""},{"$f":"IF(Berechnung!F11=0,\"\",Berechnung!F11)","v":""},{"$f":"IFERROR(Berechnung!E11,\"\")","v":""},{"$f":"IFERROR(Berechnung!G11,\"\")","v":""}]
[{"$f":"IF(Daten!A12=0,\"\",Daten!A12)","v":""},{"$f":"IF(Daten!B12=0,\"\",Daten!B12)","v":""},{"$f":"IF(Daten!G12=0,\"\",Daten!G12)","v":""},{"$f":"IF(Daten!C12=0,\"\",Daten!C12)","v":""},{"$f":"IF(Daten!D12=0,\"\",Daten!D12)","v":""},{"$f":"IF(Daten!E12=0,\"\",Daten!E12)","v":""},{"$f":"IF(Daten!F12=0,\"\",Daten!F12)","v":""},{"$f":"IF(Daten!H12=0,\"\",Daten!H12)","v":""},{"$f":"IF(Daten!I12=0,\"\",Daten!I12)","v":""},{"$f":"IF(Berechnung!F12=0,\"\",Berechnung!F12)","v":""},{"$f":"IFERROR(Berechnung!E12,\"\")","v":""},{"$f":"IFERROR(Berechnung!G12,\"\")","v":""}]
[{"$f":"IF(Daten!A13=0,\"\",Daten!A13)","v":""},{"$f":"IF(Daten!B13=0,\"\",Daten!B13)","v":""},{"$f":"IF(Daten!G13=0,\"\",Daten!G13)","v":""},{"$f":"IF(Daten!C13=0,\"\",Daten!C13)","v":""},{"$f":"IF(Daten!D13=0,\"\",Daten!D13)","v":""},{"$f":"IF(Daten!E13=0,\"\",Daten!E13)","v":""},{"$f":"IF(Daten!F13=0,\"\",Daten!F13)","v":""},{"$f":"IF(Daten!H13=0,\"\",Daten!H13)","v":""},{"$f":"IF(Daten!I13=0,\"\",Daten!I13)","v":""},{"$f":"IF(Berechnung!F13=0,\"\",Berechnung!F13)","v":""},{"$f":"IFERROR(Berechnung!E13,\"\")","v":""},{"$f":"IFERROR(Berechnung!G13,\"\")","v":""}]
[{"$f":"IF(Daten!A14=0,\"\",Daten!A14)","v":""},{"$f":"IF(Daten!B14=0,\"\",Daten!B14)","v":""},{"$f":"IF(Daten!G14=0,\"\",Daten!G14)","v":""},{"$f":"IF(Daten!C14=0,\"\",Daten!C14)","v":""},{"$f":"IF(Daten!D14=0,\"\",Daten!D14)","v":""},{"$f":"IF(Daten!E14=0,\"\",Daten!E14)","v":""},{"$f":"IF(Daten!F14=0,\"\",Daten!F14)","v":""},{"$f":"IF(Daten!H14=0,\"\",Daten!H14)","v":""},{"$f":"IF(Daten!I14=0,\"\",Daten!I14)","v":""},{"$f":"IF(Berechnung!F14=0,\"\",Berechnung!F14)","v":""},{"$f":"IFERROR(Berechnung!E14,\"\")","v":""},{"$f":"IFERROR(Berechnung!G14,\"\")","v":""}]
[{"$f":"IF(Daten!A15=0,\"\",Daten!A15)","v":""},{"$f":"IF(Daten!B15=0,\"\",Daten!B15)","v":""},{"$f":"IF(Daten!G15=0,\"\",Daten!G15)","v":""},{"$f":"IF(Daten!C15=0,\"\",Daten!C15)","v":""},{"$f":"IF(Daten!D15=0,\"\",Daten!D15)","v":""},{"$f":"IF(Daten!E15=0,\"\",Daten!E15)","v":""},{"$f":"IF(Daten!F15=0,\"\",Daten!F15)","v":""},{"$f":"IF(Daten!H15=0,\"\",Daten!H15)","v":""},{"$f":"IF(Daten!I15=0,\"\",Daten!I15)","v":""},{"$f":"IF(Berechnung!F15=0,\"\",Berechnung!F15)","v":""},{"$f":"IFERROR(Berechnung!E15,\"\")","v":""},{"$f":"IFERROR(Berechnung!G15,\"\")","v":""}]
[{"$f":"IF(Daten!A16=0,\"\",Daten!A16)","v":""},{"$f":"IF(Daten!B16=0,\"\",Daten!B16)","v":""},{"$f":"IF(Daten!G16=0,\"\",Daten!G16)","v":""},{"$f":"IF(Daten!C16=0,\"\",Daten!C16)","v":""},{"$f":"IF(Daten!D16=0,\"\",Daten!D16)","v":""},{"$f":"IF(Daten!E16=0,\"\",Daten!E16)","v":""},{"$f":"IF(Daten!F16=0,\"\",Daten!F16)","v":""},{"$f":"IF(Daten!H16=0,\"\",Daten!H16)","v":""},{"$f":"IF(Daten!I16=0,\"\",Daten!I16)","v":""},{"$f":"IF(Berechnung!F16=0,\"\",Berechnung!F16)","v":""},{"$f":"IFERROR(Berechnung!E16,\"\")","v":""},{"$f":"IFERROR(Berechnung!G16,\"\")","v":""}]
[{"$f":"IF(Daten!A17=0,\"\",Daten!A17)","v":""},{"$f":"IF(Daten!B17=0,\"\",Daten!B17)","v":""},{"$f":"IF(Daten!G17=0,\"\",Daten!G17)","v":""},{"$f":"IF(Daten!C17=0,\"\",Daten!C17)","v":""},{"$f":"IF(Daten!D17=0,\"\",Daten!D17)","v":""},{"$f":"IF(Daten!E17=0,\"\",Daten!E17)","v":""},{"$f":"IF(Daten!F17=0,\"\",Daten!F17)","v":""},{"$f":"IF(Daten!H17=0,\"\",Daten!H17)","v":""},{"$f":"IF(Daten!I17=0,\"\",Daten!I17)","v":""},{"$f":"IF(Berechnung!F17=0,\"\",Berechnung!F17)","v":""},{"$f":"IFERROR(Berechnung!E17,\"\")","v":""},{"$f":"IFERROR(Berechnung!G17,\"\")","v":""}]
[{"$f":"IF(Daten!A18=0,\"\",Daten!A18)","v":""},{"$f":"IF(Daten!B18=0,\"\",Daten!B18)","v":""},{"$f":"IF(Daten!G18=0,\"\",Daten!G18)","v":""},{"$f":"IF(Daten!C18=0,\"\",Daten!C18)","v":""},{"$f":"IF(Daten!D18=0,\"\",Daten!D18)","v":""},{"$f":"IF(Daten!E18=0,\"\",Daten!E18)","v":""},{"$f":"IF(Daten!F18=0,\"\",Daten!F18)","v":""},{"$f":"IF(Daten!H18=0,\"\",Daten!H18)","v":""},{"$f":"IF(Daten!I18=0,\"\",Daten!I18)","v":""},{"$f":"IF(Berechnung!F18=0,\"\",Berechnung!F18)","v":""},{"$f":"IFERROR(Berechnung!E18,\"\")","v":""},{"$f":"IFERROR(Berechnung!G18,\"\")","v":""}]
[{"$f":"IF(Daten!A19=0,\"\",Daten!A19)","v":""},{"$f":"IF(Daten!B19=0,\"\",Daten!B19)","v":""},{"$f":"IF(Daten!G19=0,\"\",Daten!G19)","v":""},{"$f":"IF(Daten!C19=0,\"\",Daten!C19)","v":""},{"$f":"IF(Daten!D19=0,\"\",Daten!D19)","v":""},{"$f":"IF(Daten!E19=0,\"\",Daten!E19)","v":""},{"$f":"IF(Daten!F19=0,\"\",Daten!F19)","v":""},{"$f":"IF(Daten!H19=0,\"\",Daten!H19)","v":""},{"$f":"IF(Daten!I19=0,\"\",Daten!I19)","v":""},{"$f":"IF(Berechnung!F19=0,\"\",Berechnung!F19)","v":""},{"$f":"IFERROR(Berechnung!E19,\"\")","v":""},{"$f":"IFERROR(Berechnung!G19,\"\")","v":""}]
[{"$f":"IF(Daten!A20=0,\"\",Daten!A20)","v":""},{"$f":"IF(Daten!B20=0,\"\",Daten!B20)","v":""},{"$f":"IF(Daten!G20=0,\"\",Daten!G20)","v":""},{"$f":"IF(Daten!C20=0,\"\",Daten!C20)","v":""},{"$f":"IF(Daten!D20=0,\"\",Daten!D20)","v":""},{"$f":"IF(Daten!E20=0,\"\",Daten!E20)","v":""},{"$f":"IF(Daten!F20=0,\"\",Daten!F20)","v":""},{"$f":"IF(Daten!H20=0,\"\",Daten!H20)","v":""},{"$f":"IF(Daten!I20=0,\"\",Daten!I20)","v":""},{"$f":"IF(Berechnung!F20=0,\"\",Berechnung!F20)","v":""},{"$f":"IFERROR(Berechnung!E20,\"\")","v":""},{"$f":"IFERROR(Berechnung!G20,\"\")","v":""}]
[{"$f":"IF(Daten!A21=0,\"\",Daten!A21)","v":""},{"$f":"IF(Daten!B21=0,\"\",Daten!B21)","v":""},{"$f":"IF(Daten!G21=0,\"\",Daten!G21)","v":""},{"$f":"IF(Daten!C21=0,\"\",Daten!C21)","v":""},{"$f":"IF(Daten!D21=0,\"\",Daten!D21)","v":""},{"$f":"IF(Daten!E21=0,\"\",Daten!E21)","v":""},{"$f":"IF(Daten!F21=0,\"\",Daten!F21)","v":""},{"$f":"IF(Daten!H21=0,\"\",Daten!H21)","v":""},{"$f":"IF(Daten!I21=0,\"\",Daten!I21)","v":""},{"$f":"IF(Berechnung!F21=0,\"\",Berechnung!F21)","v":""},{"$f":"IFERROR(Berechnung!E21,\"\")","v":""},{"$f":"IFERROR(Berechnung!G21,\"\")","v":""}]
[{"$f":"IF(Daten!A22=0,\"\",Daten!A22)","v":""},{"$f":"IF(Daten!B22=0,\"\",Daten!B22)","v":""},{"$f":"IF(Daten!G22=0,\"\",Daten!G22)","v":""},{"$f":"IF(Daten!C22=0,\"\",Daten!C22)","v":""},{"$f":"IF(Daten!D22=0,\"\",Daten!D22)","v":""},{"$f":"IF(Daten!E22=0,\"\",Daten!E22)","v":""},{"$f":"IF(Daten!F22=0,\"\",Daten!F22)","v":""},{"$f":"IF(Daten!H22=0,\"\",Daten!H22)","v":""},{"$f":"IF(Daten!I22=0,\"\",Daten!I22)","v":""},{"$f":"IF(Berechnung!F22=0,\"\",Berechnung!F22)","v":""},{"$f":"IFERROR(Berechnung!E22,\"\")","v":""},{"$f":"IFERROR(Berechnung!G22,\"\")","v":""}]
[{"$f":"IF(Daten!A23=0,\"\",Daten!A23)","v":""},{"$f":"IF(Daten!B23=0,\"\",Daten!B23)","v":""},{"$f":"IF(Daten!G23=0,\"\",Daten!G23)","v":""},{"$f":"IF(Daten!C23=0,\"\",Daten!C23)","v":""},{"$f":"IF(Daten!D23=0,\"\",Daten!D23)","v":""},{"$f":"IF(Daten!E23=0,\"\",Daten!E23)","v":""},{"$f":"IF(Daten!F23=0,\"\",Daten!F23)","v":""},{"$f":"IF(Daten!H23=0,\"\",Daten!H23)","v":""},{"$f":"IF(Daten!I23=0,\"\",Daten!I23)","v":""},{"$f":"IF(Berechnung!F23=0,\"\",Berechnung!F23)","v":""},{"$f":"IFERROR(Berechnung!E23,\"\")","v":""},{"$f":"IFERROR(Berechnung!G23,\"\")","v":""}]
[{"$f":"IF(Daten!A24=0,\"\",Daten!A24)","v":""},{"$f":"IF(Daten!B24=0,\"\",Daten!B24)","v":""},{"$f":"IF(Daten!G24=0,\"\",Daten!G24)","v":""},{"$f":"IF(Daten!C24=0,\"\",Daten!C24)","v":""},{"$f":"IF(Daten!D24=0,\"\",Daten!D24)","v":""},{"$f":"IF(Daten!E24=0,\"\",Daten!E24)","v":""},{"$f":"IF(Daten!F24=0,\"\",Daten!F24)","v":""},{"$f":"IF(Daten!H24=0,\"\",Daten!H24)","v":""},{"$f":"IF(Daten!I24=0,\"\",Daten!I24)","v":""},{"$f":"IF(Berechnung!F24=0,\"\",Berechnung!F24)","v":""},{"$f":"IFERROR(Berechnung!E24,\"\")","v":""},{"$f":"IFERROR(Berechnung!G24,\"\")","v":""}]
[{"$f":"IF(Daten!A25=0,\"\",Daten!A25)","v":""},{"$f":"IF(Daten!B25=0,\"\",Daten!B25)","v":""},{"$f":"IF(Daten!G25=0,\"\",Daten!G25)","v":""},{"$f":"IF(Daten!C25=0,\"\",Daten!C25)","v":""},{"$f":"IF(Daten!D25=0,\"\",Daten!D25)","v":""},{"$f":"IF(Daten!E25=0,\"\",Daten!E25)","v":""},{"$f":"IF(Daten!F25=0,\"\",Daten!F25)","v":""},{"$f":"IF(Daten!H25=0,\"\",Daten!H25)","v":""},{"$f":"IF(Daten!I25=0,\"\",Daten!I25)","v":""},{"$f":"IF(Berechnung!F25=0,\"\",Berechnung!F25)","v":""},{"$f":"IFERROR(Berechnung!E25,\"\")","v":""},{"$f":"IFERROR(Berechnung!G25,\"\")","v":""}]
[{"$f":"IF(Daten!A26=0,\"\",Daten!A26)","v":""},{"$f":"IF(Daten!B26=0,\"\",Daten!B26)","v":""},{"$f":"IF(Daten!G26=0,\"\",Daten!G26)","v":""},{"$f":"IF(Daten!C26=0,\"\",Daten!C26)","v":""},{"$f":"IF(Daten!D26=0,\"\",Daten!D26)","v":""},{"$f":"IF(Daten!E26=0,\"\",Daten!E26)","v":""},{"$f":"IF(Daten!F26=0,\"\",Daten!F26)","v":""},{"$f":"IF(Daten!H26=0,\"\",Daten!H26)","v":""},{"$f":"IF(Daten!I26=0,\"\",Daten!I26)","v":""},{"$f":"IF(Berechnung!F26=0,\"\",Berechnung!F26)","v":""},{"$f":"IFERROR(Berechnung!E26,\"\")","v":""},{"$f":"IFERROR(Berechnung!G26,\"\")","v":""}]

{"sheet":"Hilfsfelder","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Auswahl - Medikamente",null,"Einnahme - Menge","Anwendung - aktiv","Datum","Menge"]
["Pradaxa",null,0,"x",{"$f":"$E$7-5","v":"2019-03-29"},10]
["Amiodaron",null,0.5,"bei Bedarf",{"$f":"$E$7-4","v":"2019-03-30"},20]
["Torasemid",null,1,null,{"$f":"$E$7-3","v":"2019-03-31"},30]
["Eplerenon",null,1.5,null,{"$f":"$E$7-2","v":"2019-04-01"},40]
["Bisoprolol",null,2,null,{"$f":"$E$7-1","v":"2019-04-02"},50]
["Ramipril",null,2.5,null,{"$f":"TODAY()","v":"2019-04-03"},60]
["Atorvastatin",null,3,null,{"$f":"$E$7+1","v":"2019-04-04"},70]
["Allopurinol",null,4,null,{"$f":"$E$7+2","v":"2019-04-05"},80]
["Tromcardin complex",null,5,null,{"$f":"$E$7+3","v":"2019-04-06"},90]
["Biotin beta",null,6,null,{"$f":"$E$7+4","v":"2019-04-07"},100]
["Debora",null,7,null,{"$f":"$E$7+5","v":"2019-04-08"},110]
["Pantroprazol",null,8,null,{"$f":"$E$7+6","v":"2019-04-09"},120]
[null,null,9,null,{"$f":"$E$7+7","v":"2019-04-10"},130]
[null,null,10,null,{"$f":"$E$7+8","v":"2019-04-11"},140]
[null,null,null,null,{"$f":"$E$7+9","v":"2019-04-12"},150]
[null,null,null,null,{"$f":"$E$7+10","v":"2019-04-13"},160]
[null,null,null,null,{"$f":"$E$7+11","v":"2019-04-14"},170]
[null,null,null,null,{"$f":"$E$7+12","v":"2019-04-15"},180]
[null,null,null,null,{"$f":"$E$7+13","v":"2019-04-16"},190]
[null,null,null,null,{"$f":"$E$7+14","v":"2019-04-17"},200]
[null,null,null,null,{"$f":"$E$7+15","v":"2019-04-18"}]
[null,null,null,null,{"$f":"$E$7+16","v":"2019-04-19"}]
[null,null,null,null,{"$f":"$E$7+17","v":"2019-04-20"}]
[null,null,null,null,{"$f":"$E$7+18","v":"2019-04-21"}]
[null,null,null,null,{"$f":"$E$7+19","v":"2019-04-22"}]
[null,null,null,null,{"$f":"$E$7+20","v":"2019-04-23"}]
[null,null,null,null,{"$f":"$E$7+21","v":"2019-04-24"}]
[null,null,null,null,{"$f":"$E$7+22","v":"2019-04-25"}]
[null,null,null,null,{"$f":"$E$7+23","v":"2019-04-26"}]
[null,null,null,null,{"$f":"$E$7+24","v":"2019-04-27"}]
[null,null,null,null,{"$f":"$E$7+25","v":"2019-04-28"}]
[null,null,null,null,{"$f":"$E$7+26","v":"2019-04-29"}]