{"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":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[24,4,24,5]]}
[12,"Anzahl der getrunkenen Standardgläser"]
[120,"Trinkdauer insgesamt [min.]"]
[10,"Zeitraum zwischen Trink-Ende und Kontrolle der Blutalkoholkonzentration [min.]"]
[60,"Anflutungszeit eines Standardglases [min.]"]
[75,"Körpergewicht [kg]"]
[182,"Körpergröße [cm]"]
[{"$f":"A5/(A6*0.01)^2","v":22.642192971863299},"BMI (errechnet)"]
[25,"BMI bei Normalgewicht (Vorgabe)"]
[{"$f":"IF(A7<A8,A5,A8*(A6*0.01)^2)","v":75},"Gewicht [kg]"]
["m","Geschlecht","m"]
[null,null,"w"]
[1,"Standardglas enthält",null,null,10,"g Alkohol"]
[1,"l Alkohol mit",null,5,"Vol.-% =",{"$f":"A13*1000*D13/100*0.8/$E$12","v":4},{"$f":"IF(F13=1,\"Standardglas\",\"Standardgläser\")","v":"Standardgläser"}]
[0.25,"l Bier mit",null,5,"Vol.-% =",{"$f":"A14*1000*D14/100*0.8/$E$12","v":1},{"$f":"IF(F14=1,\"Standardglas\",\"Standardgläser\")","v":"Standardglas"}]
[0.25,"l Wein mit",null,15,"Vol.-% =",{"$f":"A15*1000*D15/100*0.8/$E$12","v":3},{"$f":"IF(F15=1,\"Standardglas\",\"Standardgläser\")","v":"Standardgläser"}]
[2,"cl Schnaps",null,37.5,"Vol.-% =",{"$f":"A16*10*D16/100*0.8/$E$12","v":0.6},{"$f":"IF(F16=1,\"Standardglas\",\"Standardgläser\")","v":"Standardgläser"}]
[]
[0.2,"Resorptionsdefizit (Anteil an der Alkoholmenge, der nicht ins Blut geht)"]
[{"$f":"E12/A12-E12/A12*A18","v":8},"Alkoholmenge eines Standardglases, die ins Blut geht [g]"]
[{"$f":"IF(A10=\"m\",70%,60%)","v":0.7},"Flüssigkeitsanteil am Körpergewicht"]
[0.15,"Abbau der Blutalkoholkonzentration (BAK) pro Stunde [Promille]"]
[]
[{"$f":"SUM(E26:E59)","v":1.3035714285714288},"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$1>=1,1,\"\")","v":1},{"$f":"IF(A26<=$A$1,$A$2/$A$1*A26,\"\")","v":10},null,{"$f":"IF($A$1>=A26,IF($A$2+$A$3-A26*$A$2/$A$1-$A$4<0,0,$A$2+$A$3-A26*$A$2/$A$1-$A$4),\"\")","v":60},{"$f":"IF($A$1>=A26,IF($A$19/$A$9/$A$20-$A$21/60*D26<0,0,$A$19/$A$9/$A$20-$A$21/60*D26),\"\")","v":2.3809523809524002E-3}]
[{"$f":"IF($A$1>=2,2,\"\")","v":2},{"$f":"IF(A27<=$A$1,$A$2/$A$1*A27,\"\")","v":20},null,50,2.7380952380952395E-2]
[{"$f":"IF($A$1>=3,3,\"\")","v":3},30,null,40,5.2380952380952389E-2]
[{"$f":"IF($A$1>=4,4,\"\")","v":4},40,null,30,7.7380952380952397E-2]
[{"$f":"IF($A$1>=5,5,\"\")","v":5},50,null,20,0.10238095238095239]
[{"$f":"IF($A$1>=6,6,\"\")","v":6},60,null,10,0.1273809523809524]
[{"$f":"IF($A$1>=7,7,\"\")","v":7},70,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=8,8,\"\")","v":8},80,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=9,9,\"\")","v":9},90,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=10,10,\"\")","v":10},100,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=11,11,\"\")","v":11},110,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=12,12,\"\")","v":12},120,null,0,0.15238095238095239]
[{"$f":"IF($A$1>=13,13,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=14,14,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=15,15,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=16,16,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=17,17,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=18,18,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=19,19,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=20,20,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=21,21,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=22,22,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=23,23,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=24,24,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=25,25,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=26,26,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=27,27,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=28,28,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=29,29,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=30,30,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=31,31,\"\")","v":""},"",null,"",""]
[{"$f":"IF($A$1>=33,33,\"\")","v":""},{"$f":"IF(A57<=$A$1,$A$2/$A$1*A57,\"\")","v":""},null,"",""]
[{"$f":"IF($A$1>=34,34,\"\")","v":""},{"$f":"IF(A58<=$A$1,$A$2/$A$1*A58,\"\")","v":""},null,"",""]
[{"$f":"IF($A$1>=35,35,\"\")","v":""},{"$f":"IF(A59<=$A$1,$A$2/$A$1*A59,\"\")","v":""},null,"",""]
[]
["Aufgenommene Alkoholmenge:",null,null,null,{"$f":"A1*E12","v":120},"g       =",{"$f":"E61*1.25","v":150},"ml"]
[]
["Das entspricht"]
[]
[null,{"$f":"$G$61/E65*100/1000","v":3},null,"l Bier mit",{"$f":"D14","v":5},"Vol.-%"]
["oder",{"$f":"$G$61/E66*100/1000","v":1},null,"l Wein mit",{"$f":"D15","v":15},"Vol.-%"]
["oder",{"$f":"$G$61/E67*100/1000","v":0.4},null,"l Schnaps mit",{"$f":"D16","v":37.5},"Vol.-%"]

{"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":[]}