{"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]]}
[35,"Anzahl der getrunkenen Standardgläser"]
[180,"Trinkdauer insgesamt [min.]"]
[10,"Zeitraum zwischen Trink-Ende und Kontrolle der Blutalkoholkonzentration [min.]"]
[60,"Anflutungszeit eines Standardglases [min.]"]
[90,"Körpergewicht [kg]"]
[180,"Körpergröße [cm]"]
[{"$f":"A5/(A6*0.01)^2","v":27.777777777777775},"BMI (errechnet)"]
[25,"BMI bei Normalgewicht (Vorgabe)"]
[{"$f":"IF(A7<A8,A5,A8*(A6*0.01)^2)","v":81},"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":2.0754409171075836},"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":5.1428571428571432},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":124.85714285714286},{"$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":0}]
[{"$f":"IF($A$1>=2,2,\"\")","v":2},{"$f":"IF(A27<=$A$1,$A$2/$A$1*A27,\"\")","v":10.285714285714286},null,119.71428571428572,0]
[{"$f":"IF($A$1>=3,3,\"\")","v":3},15.428571428571431,null,114.57142857142858,0]
[{"$f":"IF($A$1>=4,4,\"\")","v":4},20.571428571428573,null,109.42857142857142,0]
[{"$f":"IF($A$1>=5,5,\"\")","v":5},25.714285714285715,null,104.28571428571428,0]
[{"$f":"IF($A$1>=6,6,\"\")","v":6},30.857142857142861,null,99.142857142857139,0]
[{"$f":"IF($A$1>=7,7,\"\")","v":7},36,null,94,0]
[{"$f":"IF($A$1>=8,8,\"\")","v":8},41.142857142857146,null,88.857142857142861,0]
[{"$f":"IF($A$1>=9,9,\"\")","v":9},46.285714285714292,null,83.714285714285722,0]
[{"$f":"IF($A$1>=10,10,\"\")","v":10},51.428571428571431,null,78.571428571428555,0]
[{"$f":"IF($A$1>=11,11,\"\")","v":11},56.571428571428577,null,73.428571428571445,0]
[{"$f":"IF($A$1>=12,12,\"\")","v":12},61.714285714285722,null,68.285714285714278,0]
[{"$f":"IF($A$1>=13,13,\"\")","v":13},66.857142857142861,null,63.142857142857139,0]
[{"$f":"IF($A$1>=14,14,\"\")","v":14},72,null,58,0]
[{"$f":"IF($A$1>=15,15,\"\")","v":15},77.142857142857153,null,52.857142857142861,8.9506172839506071E-3]
[{"$f":"IF($A$1>=16,16,\"\")","v":16},82.285714285714292,null,47.714285714285708,2.180776014109348E-2]
[{"$f":"IF($A$1>=17,17,\"\")","v":17},87.428571428571431,null,42.571428571428569,3.4664902998236324E-2]
[{"$f":"IF($A$1>=18,18,\"\")","v":18},92.571428571428584,null,37.428571428571431,4.7522045855379169E-2]
[{"$f":"IF($A$1>=19,19,\"\")","v":19},97.714285714285722,null,32.285714285714292,6.0379188712522028E-2]
[{"$f":"IF($A$1>=20,20,\"\")","v":20},102.85714285714286,null,27.142857142857139,7.32363315696649E-2]
[{"$f":"IF($A$1>=21,21,\"\")","v":21},108.00000000000001,null,22,8.6093474426807759E-2]
[{"$f":"IF($A$1>=22,22,\"\")","v":22},113.14285714285715,null,16.857142857142861,9.8950617283950604E-2]
[{"$f":"IF($A$1>=23,23,\"\")","v":23},118.28571428571429,null,11.714285714285708,0.11180776014109348]
[{"$f":"IF($A$1>=24,24,\"\")","v":24},123.42857142857144,null,6.5714285714285694,0.12466490299823632]
[{"$f":"IF($A$1>=25,25,\"\")","v":25},128.57142857142858,null,1.4285714285714164,0.13752204585537922]
[{"$f":"IF($A$1>=26,26,\"\")","v":26},133.71428571428572,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=27,27,\"\")","v":27},138.85714285714286,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=28,28,\"\")","v":28},144,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=29,29,\"\")","v":29},149.14285714285717,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=30,30,\"\")","v":30},154.28571428571431,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=31,31,\"\")","v":31},159.42857142857144,null,0,0.14109347442680775]
[{"$f":"IF($A$1>=33,33,\"\")","v":33},{"$f":"IF(A57<=$A$1,$A$2/$A$1*A57,\"\")","v":169.71428571428572},null,0,0.14109347442680775]
[{"$f":"IF($A$1>=34,34,\"\")","v":34},{"$f":"IF(A58<=$A$1,$A$2/$A$1*A58,\"\")","v":174.85714285714286},null,0,0.14109347442680775]
[{"$f":"IF($A$1>=35,35,\"\")","v":35},{"$f":"IF(A59<=$A$1,$A$2/$A$1*A59,\"\")","v":180},null,0,0.14109347442680775]
[]
["Aufgenommene Alkoholmenge:",null,null,null,{"$f":"A1*E12","v":350},"g       =",{"$f":"E61*1.25","v":437.5},"ml"]
[]
["Das entspricht"]
[]
[null,{"$f":"$G$61/E65*100/1000","v":8.75},null,"l Bier mit",{"$f":"D14","v":5},"Vol.-%"]
["oder",{"$f":"$G$61/E66*100/1000","v":2.916666666666667},null,"l Wein mit",{"$f":"D15","v":15},"Vol.-%"]
["oder",{"$f":"$G$61/E67*100/1000","v":1.1666666666666665},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":[]}