{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Bestellung","Manuell","MEDITHEK"],"not_rendered":{"images":3,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Bestellung","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[0,0,0,3],[2,2,2,4],[12,2,12,3]]}
["Medikamenten-Bestellung"]
[]
["Abholung voraussichtlich:",null,"2018-02-12"]
["Hans Mustermann, Musterstrasse 15, Zürich",{"$nulls":3},"Total Einkauf",{"$f":"SUM(E6:E9)","v":{"v":135.52,"d":"135.52 €"}}]
["Artikel","Grösse Stk","Anzahl","€","€"]
["Vocado 40/5/12.5",{"$f":"IF(A6=\"Aspirin Protect\",98,IF(A6=\"Torasemid\",100,IF(A6=\"Diamicron\",120,IF(A6=\"Vocado 40/5/12.5\",98,IF(A6=\"Metformin\",120,IF(A6=\"BisoHexal\",100,))))))","v":98},1,{"$f":"IF(A6=\"Aspirin Protect\",12.36,IF(A6=\"Torasemid\",14.48,IF(A6=\"Diamicron\",65.44,IF(A6=\"Vocado 40/5/12.5\",122.72,IF(A6=\"Metformin\",13.55,IF(A6=\"BisoHexal\",12.8,))))))","v":122.72},{"$f":"SUM(D6)*C6","v":122.72}]
["BisoHexal",100,1,{"$f":"IF(A7=\"Aspirin Protect\",12.36,IF(A7=\"Torasemid\",14.48,IF(A7=\"Diamicron\",65.44,IF(A7=\"Vocado 40/5/12.5\",122.72,IF(A7=\"Metformin\",13.55,IF(A7=\"BisoHexal\",12.8,))))))","v":{"v":12.8,"d":"12.80"}},{"$f":"SUM(D7)*C7","v":{"v":12.8,"d":"12.80"}}]
[null,{"$f":"IF(A8=\"Aspirin Protect\",98,IF(A8=\"Torasemid\",100,IF(A8=\"Diamicron\",120,IF(A8=\"Vocado 40/5/12.5\",98,IF(A8=\"Metformin\",120,IF(A8=\"BisoHexal\",100,))))))","v":0},0,{"v":0,"d":"0.00"},0]
[null,{"$f":"IF(A9=\"Aspirin Protect\",98,IF(A9=\"Torasemid\",100,IF(A9=\"Diamicron\",120,IF(A9=\"Vocado 40/5/12.5\",98,IF(A9=\"Metformin\",120,IF(A9=\"BisoHexal\",100,))))))","v":0},0,{"v":0,"d":"0.00"},0]
[null,0,0,{"v":0,"d":"0.00"},0]
[null,0,0,{"v":0,"d":"0.00"},0]
[]
["Rezept Info:","gültig bis","2018-06-28"]

{"sheet":"Manuell","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"hidden":true,"merged":[[0,0,0,3],[2,2,2,4],[15,2,15,3]]}
["Medikamenten-Bestellung"]
[]
["Abholung voraussichtlich:",null,"2016-07-28"]
["Christian Rieber, In den Klosterreben 36, CH 4052 Basel",{"$nulls":3},"Total Einkauf",{"$f":"SUM(E6:E9)","v":{"v":0,"d":"0.00 €"}}]
["Artikel","Grösse Stk","Anzahl","€"]
["A",{"$nulls":3},{"$f":"SUM(C6)*D6","v":0}]
[{"$nulls":4},{"$f":"SUM(C7)*D7","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[]
[]
[]
[]
["Rezept Info:","gültig bis","2017-06-02"]

{"sheet":"MEDITHEK","index":2,"n_rows":10,"n_cols":27,"rows_kept":10,"merged":[[0,1,0,2],[1,0,3,0],[1,1,2,1],[1,2,2,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,1,9]]}
["Heute",{"$f":"TODAY()","v":"2018-01-29"}]
["Medikament","Packungs-Einheit","Eingang letzter Kauf ","Datum","Bestand-per Datum","Stk. Restbestand","t Tage verbleibend","Rezeptur",{"$nulls":4},"Bestellen                    q","Datum",2018,2018,2018,2018,2018,2018,2018,2018,2018,2018,2018,2018,"Preis in     €"]
[{"$nulls":3},"Datum für Ist Bestand q",{"$nulls":3},"morgens","mittags","abends","Total Tag","Verbrauch","Bestellung                                  (+5 Tage)","absolutes Ende","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","Einzeln pro Packung"]
[]
["Aspirin Protect",98,"2018-01-04","2018-01-04",99,{"$f":"SUM(E5)-L5","v":74},{"$f":"N5-D5","v":99},1,null,null,{"$f":"SUM(H5:J5)","v":1},{"$f":"(TODAY()-D5)*K5","v":25},{"$f":"N5-5","v":"2018-04-08"},{"$f":"D5+(E5/K5)","v":"2018-04-13"},"Xü",null,null,"X",{"$nulls":8},12.36]
["Vocado 40/5/12.5",98,"2018-01-04","2018-01-04",104,{"$f":"SUM(E6)-L6","v":54},52,1,null,1,{"$f":"SUM(H6:J6)","v":2},50,{"$f":"N6-5","v":"2018-02-20"},"2018-02-25","Xü","X",{"$nulls":10},122.72]
["Torasemid",100,"2018-01-04","2018-01-04",167,{"$f":"SUM(E7)-L7","v":142},167,1,null,null,{"$f":"SUM(H7:J7)","v":1},25,"2018-06-15","2018-06-20","Xü",{"$nulls":11},14.48]
["Diamicron",120,"2016-07-29","2017-12-05",147,92,147,null,null,1,1,55,"2018-04-26","2018-05-01",{"$nulls":12},65.44]
["Metformin",120,"2016-07-29","2017-12-05",122,67,122,1,null,null,1,55,"2018-04-01","2018-04-06",{"$nulls":3},"X",{"$nulls":8},13.55]
["BisoHexal",100,"2016-07-29","2017-12-05",137,27,{"v":68.5,"d":"69"},1,null,1,2,110,"2018-02-06T12:00:00","2018-02-11T12:00:00",null,"X",{"$nulls":10},{"v":12.8,"d":"12.80"}]