{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["INTERACTIVE BAC","Calculations","Sheet3","Compatibility Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"INTERACTIVE BAC","index":0,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[20,0,20,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[13,0,13,1],[5,0,5,1],[0,1,0,19],[4,2,4,16],[35,0,35,11],[23,0,23,11],[18,0,18,1],[19,0,19,1],[10,0,10,1],[24,13,24,19],[23,13,23,19],[3,7,3,8],[4,0,4,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[17,0,17,1],[11,0,11,1],[12,0,12,1]],"flags":["formulas_cached_only"]}
[null,"Blood Alcohol Content (BAC)* Chart"]
[null,"*Numbers are an estimation of percentage of alcohol in blood based on gender and weight. "]
[]
[{"$nulls":6},"Sex:","Male",null,null,null,"Weight:",170,{"$nulls":5},"Gender"]
["Drinks ",null,"Hours Since First Drink",{"$nulls":15},"enter:"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,"Male"]
[1,null,0.005113244027342801,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Female"]
[2,null,0.027846488054685602,0.010226488054685602,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,null,0.0505797320820284,0.0329597320820284,0.015339732082028403,0,0,0,0,0,0,0,0,0,0,0,0,"Yellow:  "]
[4,null,0.07331297610937121,0.05569297610937121,0.038072976109371215,0.020452976109371215,0.0028329761093712144,0,0,0,0,0,0,0,0,0,0,"Lower Risk Drinking"]
[5,null,0.09604622013671402,0.07842622013671402,0.06080622013671402,0.043186220136714026,0.025566220136714026,0.007946220136714026,0,0,0,0,0,0,0,0,0,"Orange:"]
[6,null,0.1187794641640568,0.1011594641640568,0.0835394641640568,0.0659194641640568,0.04829946416405681,0.03067946416405681,0.01305946416405681,0,0,0,0,0,0,0,0,"Increased Risk"]
[7,null,0.1415127081913996,0.12389270819139961,0.10627270819139961,0.08865270819139962,0.07103270819139962,0.05341270819139962,0.035792708191399625,0.018172708191399625,0.0005527081913996243,0,0,0,0,0,0,"Red:"]
[8,null,0.1642459522187424,0.14662595221874242,0.12900595221874242,0.11138595221874242,0.09376595221874243,0.07614595221874243,0.05852595221874243,0.040905952218742436,0.023285952218742436,0.005665952218742436,0,0,0,0,0,"Extreme Risk to Health and Safety"]
[9,null,0.18697919624608522,0.16935919624608523,0.15173919624608523,0.13411919624608523,0.11649919624608523,0.09887919624608524,0.08125919624608524,0.06363919624608524,0.04601919624608525,0.028399196246085247,0.010779196246085247,0,0,0,0]
[10,null,0.20971244027342803,0.19209244027342803,0.17447244027342804,0.15685244027342804,0.13923244027342804,0.12161244027342805,0.10399244027342805,0.08637244027342805,0.06875244027342806,0.05113244027342806,0.03351244027342806,0.015892440273428062,0,0,0]
[11,null,0.2324456843007708,0.21482568430077081,0.19720568430077082,0.17958568430077082,0.16196568430077082,0.14434568430077083,0.12672568430077083,0.10910568430077083,0.09148568430077084,0.07386568430077084,0.05624568430077084,0.038625684300770846,0.021005684300770846,0.0033856843007708456,0]
[12,null,0.25517892832811356,0.23755892832811357,0.21993892832811357,0.20231892832811357,0.18469892832811358,0.16707892832811358,0.14945892832811358,0.13183892832811359,0.11421892832811359,0.09659892832811359,0.0789789283281136,0.0613589283281136,0.0437389283281136,0.026118928328113602,0.008498928328113602]
[13,null,0.2779121723554564,0.2602921723554564,0.24267217235545638,0.22505217235545638,0.20743217235545638,0.1898121723554564,0.1721921723554564,0.1545721723554564,0.1369521723554564,0.1193321723554564,0.1017121723554564,0.08409217235545641,0.06647217235545641,0.048852172355456414,0.031232172355456413]
[14,null,0.3006454163827992,0.28302541638279916,0.26540541638279913,0.24778541638279913,0.23016541638279914,0.21254541638279914,0.19492541638279914,0.17730541638279915,0.15968541638279915,0.14206541638279915,0.12444541638279916,0.10682541638279916,0.08920541638279916,0.07158541638279917,0.05396541638279917]
[15,null,0.323378660410142,0.305758660410142,0.28813866041014197,0.27051866041014194,0.2528986604101419,0.23527866041014192,0.21765866041014192,0.20003866041014193,0.18241866041014193,0.16479866041014193,0.14717866041014194,0.12955866041014194,0.11193866041014194,0.09431866041014195,0.07669866041014195]
[]
[]
["Tips to Lower BAC",{"$nulls":12},"Common Effects of Alcohol"]
[{"$nulls":13},"for People Without Tolerance"]
["* Drink slowly"]
["* Count your drinks",{"$nulls":12},"BAC"]
["* Alternate alcoholic and non-alcoholic beverages",{"$nulls":12},0.02,"Light and moderate drinkers begin to"]
["* Set a BAC limit for yourself of .05%",{"$nulls":13},"feel some effect."]
["* Drink for quality rather than quantity",{"$nulls":12},0.04,"Most people begin to feel relaxed."]
["* Eat before and during drinking",{"$nulls":12},0.06,"Judgment is somewhat impaired; people"]
["* Avoid drinking games",{"$nulls":13},"are less able to make rational decisions"]
[{"$nulls":14},"about their capabilities (e.g., driving)."]
[{"$nulls":13},0.08,"Definite impairment of muscle coordination"]
[{"$nulls":14},"and driving skills is evident; increased risk"]
["Standard Drink Equivalencies",{"$nulls":13},"of nausea and slurred speech."]
[{"$nulls":13},0.1,"Clear deterioration of reaction time."]
["1 drink (0.54 oz alcohol) is equivalent to:",{"$nulls":12},0.15,"Balance and movement are impaired; risk of "]
[null,"* 12 oz beer",{"$nulls":12},"blackouts, passing out, and accidents"]
[null,"* 8 oz malt liquor",{"$nulls":12},"increases dramatically."]
[null,"* 5 oz wine",{"$nulls":11},0.3,"Most people lose consciousness; central"]
[null,"* 10 oz mirco brew",{"$nulls":12},"nervous system is substantially depressed;"]
[null,"* 1-1/2 oz liquor (1 shot)",{"$nulls":12},"risk of death."]

{"sheet":"Calculations","index":1,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,1,1,15],[0,10,0,11]],"flags":["formulas_cached_only"]}
["Blood Alcohol Content Chart",{"$nulls":8},"Gender:","Male",null,null,null,"Weight:",170]
[null,"HOURS PASSED SINCE FIRST DRINK"]
["DRINKS",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[1,0.005113244027342801,-0.0125067559726572,-0.0301267559726572,-0.0477467559726572,-0.0653667559726572,-0.0829867559726572,-0.1006067559726572,-0.1182267559726572,-0.1358467559726572,-0.1534667559726572,-0.17108675597265718,-0.18870675597265718,-0.20632675597265718,-0.22394675597265717,-0.24156675597265717,null,"Calculations:"]
[2,0.027846488054685602,0.010226488054685602,-0.007393511945314398,-0.0250135119453144,-0.042633511945314395,-0.06025351194531439,-0.07787351194531439,-0.09549351194531439,-0.11311351194531438,-0.13073351194531438,-0.14835351194531438,-0.16597351194531437,-0.18359351194531437,-0.20121351194531437,-0.21883351194531436,null,null,"Weight in kg =",77.11149414859838]
[3,0.0505797320820284,0.0329597320820284,0.015339732082028403,-0.002280267917971597,-0.019900267917971597,-0.0375202679179716,-0.055140267917971594,-0.07276026791797159,-0.09038026791797159,-0.10800026791797158,-0.1256202679179716,-0.1432402679179716,-0.1608602679179716,-0.17848026791797159,-0.19610026791797158,null,null,"Body water in ml =",44724.66660618706]
[4,0.07331297610937121,0.05569297610937121,0.038072976109371215,0.020452976109371215,0.0028329761093712144,-0.014787023890628786,-0.032407023890628786,-0.05002702389062878,-0.06764702389062878,-0.08526702389062878,-0.10288702389062877,-0.12050702389062877,-0.13812702389062878,-0.15574702389062878,-0.17336702389062877,null,null,"Alcohol in g per ml water =",0.00028205017403651117]
[5,0.09604622013671402,0.07842622013671402,0.06080622013671402,0.043186220136714026,0.025566220136714026,0.007946220136714026,-0.009673779863285974,-0.027293779863285975,-0.04491377986328597,-0.06253377986328597,-0.08015377986328596,-0.09777377986328596,-0.11539377986328596,-0.13301377986328597,-0.15063377986328597,null,null,"Alcohol in g per ml blood =",0.00022733244027342802]
[6,0.1187794641640568,0.1011594641640568,0.0835394641640568,0.0659194641640568,0.04829946416405681,0.03067946416405681,0.01305946416405681,-0.004560535835943191,-0.02218053583594319,-0.03980053583594319,-0.057420535835943184,-0.07504053583594318,-0.09266053583594318,-0.11028053583594317,-0.12790053583594319,null,null,"Instantaneous BAC =",0.0227332440273428]
[7,0.1415127081913996,0.12389270819139961,0.10627270819139961,0.08865270819139962,0.07103270819139962,0.05341270819139962,0.035792708191399625,0.018172708191399625,0.0005527081913996243,-0.017067291808600376,-0.034687291808600376,-0.05230729180860037,-0.06992729180860037,-0.08754729180860037,-0.10516729180860036]
[8,0.1642459522187424,0.14662595221874242,0.12900595221874242,0.11138595221874242,0.09376595221874243,0.07614595221874243,0.05852595221874243,0.040905952218742436,0.023285952218742436,0.005665952218742436,-0.011954047781257564,-0.029574047781257565,-0.04719404778125756,-0.06481404778125756,-0.08243404778125756]
[9,0.18697919624608522,0.16935919624608523,0.15173919624608523,0.13411919624608523,0.11649919624608523,0.09887919624608524,0.08125919624608524,0.06363919624608524,0.04601919624608525,0.028399196246085247,0.010779196246085247,-0.006840803753914753,-0.024460803753914753,-0.04208080375391475,-0.05970080375391475]
[10,0.20971244027342803,0.19209244027342803,0.17447244027342804,0.15685244027342804,0.13923244027342804,0.12161244027342805,0.10399244027342805,0.08637244027342805,0.06875244027342806,0.05113244027342806,0.03351244027342806,0.015892440273428062,-0.001727559726571938,-0.01934755972657194,-0.03696755972657194,null,"Assumptions:"]
[11,0.2324456843007708,0.21482568430077081,0.19720568430077082,0.17958568430077082,0.16196568430077082,0.14434568430077083,0.12672568430077083,0.10910568430077083,0.09148568430077084,0.07386568430077084,0.05624568430077084,0.038625684300770846,0.021005684300770846,0.0033856843007708456,-0.014234315699229155,null,null,"Female water weight percent  =",0.49]
[12,0.25517892832811356,0.23755892832811357,0.21993892832811357,0.20231892832811357,0.18469892832811358,0.16707892832811358,0.14945892832811358,0.13183892832811359,0.11421892832811359,0.09659892832811359,0.0789789283281136,0.0613589283281136,0.0437389283281136,0.026118928328113602,0.008498928328113602,null,null,"Male water weight percent  =",0.58]
[13,0.2779121723554564,0.2602921723554564,0.24267217235545638,0.22505217235545638,0.20743217235545638,0.1898121723554564,0.1721921723554564,0.1545721723554564,0.1369521723554564,0.1193321723554564,0.1017121723554564,0.08409217235545641,0.06647217235545641,0.048852172355456414,0.031232172355456413,null,null,"Female metabolism rate =",0.01639]
[14,0.3006454163827992,0.28302541638279916,0.26540541638279913,0.24778541638279913,0.23016541638279914,0.21254541638279914,0.19492541638279914,0.17730541638279915,0.15968541638279915,0.14206541638279915,0.12444541638279916,0.10682541638279916,0.08920541638279916,0.07158541638279917,0.05396541638279917,null,null,"Male metabolism rate =",0.01762]
[15,0.323378660410142,0.305758660410142,0.28813866041014197,0.27051866041014194,0.2528986604101419,0.23527866041014192,0.21765866041014192,0.20003866041014193,0.18241866041014193,0.16479866041014193,0.14717866041014194,0.12955866041014194,0.11193866041014194,0.09431866041014195,0.07669866041014195]
["Numbers are an estimation of percentage of alcohol in blood for based on gender and weight. ",{"$nulls":17},"Water % of weight =",0.58]
["Area shaded light gray indicates a legally impaired level of intoxication.",{"$nulls":17},"Percentage of water in blood =",0.806]
[{"$nulls":18},"Alcohol g in 1 drink =",12.6146]
[{"$nulls":18},"Alcohol oz in 1 drink =",0.54]
[{"$nulls":18},"1 oz alcohol in g =",23.36]
[{"$nulls":18},"Alcohol g metabolized per hr =",0.01762]
[]
[{"$nulls":17},"Male"]
[{"$nulls":17},"Female"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Compatibility Report","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,"Compatibility Report for BAC Card Generator.xls"]
[null,"Run on 11/13/2009 18:43"]
[]
[null,"The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format."]
[]
[null,"Significant loss of functionality",null,null,"# of occurrences"]
[]
[null,"Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel.",null,null,4]
[{"$nulls":4},"'Print'!A5:Q21"]
[]
[null,"Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting.",null,null,6]
[{"$nulls":4},"'Print'!C7:Q21"]
[{"$nulls":4},"'Print'!A6:B6"]
[]
[null,"One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets.",null,null,1]
[{"$nulls":4},"'Print'!F7"]
[]
[null,"Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition.",null,null,11]
[{"$nulls":4},"'Print'!A5:Q21"]