{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"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":"Tabelle1","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[28,4,28,5]]}
["Getränk",null,null,"Vol-%","Menge [ml]","Alkohol [ml]","Alkohol [g]","Standardgläser"]
["Roederer Cristal",null,null,12,150,{"$f":"D2*E2/100","v":18},{"$f":"F2*0.8","v":14.4},{"$f":"G2/$E$20","v":1.44}]
["Montrachet",null,null,13.5,150,{"$f":"D3*E3/100","v":20.25},{"$f":"F3*0.8","v":16.2},{"$f":"G3/$E$20","v":1.6199999999999999}]
["Château Margaux",null,null,13,200,26,20.8,2.08]
["Morey Saint-Denis",null,null,13,400,52,41.6,4.16]
["Grand Bas-Armagnac",null,null,40,50,20,16,1.6]
[null,null,null,null,"Summe",{"$f":"SUM(F2:F6)","v":136.25},{"$f":"SUM(G2:G6)","v":109},{"$f":"SUM(H2:H6)","v":10.9}]
[]
[{"$f":"ROUND(H7,0)","v":11},"Anzahl der getrunkenen Standardgläser (ganzzahlig gerundet)"]
[120,"Trinkdauer insgesamt [min.]"]
[20,"Zeitraum zwischen Trink-Ende und Kontrolle der Blutalkoholkonzentration [min.]"]
[60,"Anflutungszeit eines Standardglases [min.]"]
[81,"Körpergewicht [kg]"]
[180,"Körpergröße [cm]"]
[{"$f":"A13/(A14*0.01)^2","v":25},"BMI (errechnet)"]
[25,"BMI bei Normalgewicht (Vorgabe)"]
[{"$f":"IF(A15<A16,A13,A16*(A14*0.01)^2)","v":81},"Gewicht [kg]"]
["m","Geschlecht","m"]
[null,null,"w"]
[1,"Standardglas enthält",null,null,10,"g Alkohol"]
[]
[0.2,"Resorptionsdefizit (Anteil an der Alkoholmenge, der nicht ins Blut geht)"]
[{"$f":"E20/A20-E20/A20*A22","v":8},"Alkoholmenge eines Standardglases, die ins Blut geht [g]"]
[{"$f":"IF(A18=\"m\",70%,60%)","v":0.7},"Flüssigkeitsanteil am Körpergewicht"]
[0.15,"Abbau der Blutalkoholkonzentration (BAK) pro Stunde [Promille]"]
[]
[{"$f":"SUM(E30:E63)","v":0.95165945165945154},"Blutalkoholkonzentration im Zeitpunkt der Kontrolle [Promille]"]
[]
["GetrunkenesStandard-glas Nr.","Zeitpunkt:\nGlas ausge-\ntrunken",null,"Alkohol-Abbauzeit\n[min.]","Beitrag des Standard-\nglases zur BAK im Zeit-\npunkt der Kontrolle"]
[{"$f":"IF($A$9>=1,1,\"\")","v":1},{"$f":"IF(A30<=$A$9,$A$10/$A$9*A30,\"\")","v":10.909090909090908},null,{"$f":"IF($A$9>=A30,IF($A$10+$A$11-A30*$A$10/$A$9-$A$12<0,0,$A$10+$A$11-A30*$A$10/$A$9-$A$12),\"\")","v":69.090909090909093},{"$f":"IF($A$9>=A30,IF($A$23/$A$17/$A$24-$A$25/60*D30<0,0,$A$23/$A$17/$A$24-$A$25/60*D30),\"\")","v":0}]
[{"$f":"IF($A$9>=2,2,\"\")","v":2},{"$f":"IF(A31<=$A$9,$A$10/$A$9*A31,\"\")","v":21.818181818181817},null,58.181818181818187,0]
[{"$f":"IF($A$9>=3,3,\"\")","v":3},32.727272727272727,null,47.27272727272728,2.2911656244989545E-2]
[{"$f":"IF($A$9>=4,4,\"\")","v":4},43.636363636363633,null,36.363636363636374,5.0184383517716813E-2]
[{"$f":"IF($A$9>=5,5,\"\")","v":5},54.54545454545454,null,25.454545454545453,7.7457110790444123E-2]
[{"$f":"IF($A$9>=6,6,\"\")","v":6},65.454545454545453,null,14.545454545454547,0.10472983806317138]
[{"$f":"IF($A$9>=7,7,\"\")","v":7},76.36363636363636,null,3.6363636363636402,0.13200256533589866]
[{"$f":"IF($A$9>=8,8,\"\")","v":8},87.272727272727266,null,0,0.14109347442680775]
[{"$f":"IF($A$9>=9,9,\"\")","v":9},98.181818181818173,null,0,0.14109347442680775]
[{"$f":"IF($A$9>=10,10,\"\")","v":10},109.09090909090908,null,0,0.14109347442680775]
[{"$f":"IF($A$9>=11,11,\"\")","v":11},119.99999999999999,null,0,0.14109347442680775]
[{"$f":"IF($A$9>=12,12,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=13,13,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=14,14,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=15,15,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=16,16,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=17,17,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=18,18,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=19,19,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=20,20,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=21,21,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=22,22,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=23,23,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=24,24,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=25,25,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=26,26,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=27,27,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=28,28,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=29,29,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=30,30,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=31,31,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$9>=33,33,\"\")","v":""},{"$f":"IF(A61<=$A$9,$A$10/$A$9*A61,\"\")","v":""},null,"",""]
[{"$f":"IF($A$9>=34,34,\"\")","v":""},{"$f":"IF(A62<=$A$9,$A$10/$A$9*A62,\"\")","v":""},null,"",""]
[{"$f":"IF($A$9>=35,35,\"\")","v":""},{"$f":"IF(A63<=$A$9,$A$10/$A$9*A63,\"\")","v":""},null,"",""]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}