{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Control","data","Potential Outcome Calculator"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Control","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"m","ft"]
[null,null,1,{"$f":"IF(C5=1,'Potential Outcome Calculator'!F5,'Potential Outcome Calculator'!F5*0.3048)","v":2},{"$f":"IF(C5=2,'Potential Outcome Calculator'!F5,'Potential Outcome Calculator'!F5*3.280839895)","v":6.5616797900000003}]
[null,null,null,"Kgs","Lbs"]
[null,null,1,{"$f":"IF(C7=1,'Potential Outcome Calculator'!F7,'Potential Outcome Calculator'!F7*0.45359237)","v":2},{"$f":"IF(C7=2,'Potential Outcome Calculator'!F7,'Potential Outcome Calculator'!F7*2.204622622)","v":4.4092452440000001}]
[]
[]
[null,null,"m","kg"]
[null,null,"ft","lb"]

{"sheet":"data","index":1,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
[null,null,"limited data"]
[null,null,4.4006743306671225,6.4569443276177756,10.297240136550943]
[null,null,-1.0015000000000001,-0.99960000000000004,-0.99690000000000001]
[]
[null,null,"full data"]
[null,null,4.5633044952626634,6.6126319566929164,10.550898250965846]
[null,null,-0.84889999999999999,-0.84719999999999995,-0.84760000000000002]
[]
[null,null,{"$f":"IF(Control!D7<1,data!C2,data!C6)","v":4.5633044952626634},{"$f":"IF(Control!D7<1,data!D2,data!D6)","v":6.6126319566929164},{"$f":"IF(Control!D7<1,data!E2,data!E6)","v":10.550898250965846}]
[null,null,{"$f":"IF(Control!D7<1,data!C3,data!C7)","v":-0.84889999999999999},{"$f":"IF(Control!D7<1,data!D3,data!D7)","v":-0.84719999999999995},{"$f":"IF(Control!D7<1,data!E3,data!E7)","v":-0.84760000000000002}]
[]
[]
[]
[null,"Mass","Slight","Minor","Major","Fatality",null,null,"Notes"]
[0.1,{"$f":"IF(Control!D$7<1,A15,A15*10)","v":1},{"$f":"C$9*$B15^(C$10)","v":4.5633044952626634},{"$f":"D$9*$B15^(D$10)","v":6.6126319566929164},10.550898250965846,{"$f":"E15","v":10.550898250965846},null,1,"Dropped object classification is defined by mass of object and height from which it falls"]
[{"$f":"A15+0.01","v":0.11},{"$f":"IF(Control!D$7<1,A16,A16*10)","v":1.1000000000000001},4.208634378658636,6.0996718112569139,9.7320648663892744,9.7320648663892744,null,2,"The threshold values between classifications are defined by best-fit curves to the \"probit\" data"]
[{"$f":"A16+0.01","v":0.12},{"$f":"IF(Control!D$7<1,A17,A17*10)","v":1.2},3.9089713655865306,5.6662013069503701,9.0401452977128525,9.0401452977128525,null,3,"The best fit curves are presented as \"limited data\" for mass in the range 0.1 to 1.0 kg"]
[0.13,{"$f":"IF(Control!D$7<1,A18,A18*10)","v":1.3},3.6521864183745691,5.2947022637362151,8.4471664012993308,8.4471664012993308,null,4,"The best fit curves are presented as \"full data\" for mass in the range 1.0 to 10.0 kg"]
[0.14000000000000001,{"$f":"IF(Control!D$7<1,A19,A19*10)","v":1.4000000000000001},3.4295043605040587,4.9724987171815176,7.9328878003231953,7.9328878003231953,null,5,"The best fit curves are presented in the format               height= A*mass^B"]
[0.15000000000000002,{"$f":"IF(Control!D$7<1,A20,A20*10)","v":1.5000000000000002},3.2344137833475406,4.6901835260175897,7.482289087700166,7.482289087700166,null,6,"The probit data is as follows"]
[0.16000000000000003,{"$f":"IF(Control!D$7<1,A21,A21*10)","v":1.6000000000000003},3.0619775035420287,4.4406229823071595,7.0839801825380695,7.0839801825380695,null,null,"Pr =-29.15+2,1*ln(m*v^5.115)",null,null,null,"0.001<m<0.1",null,"Pr =",7,"High","High (99% fatality)"]
[0.17000000000000004,{"$f":"IF(Control!D$7<1,A22,A22*10)","v":1.7000000000000004},2.9083814065798959,4.2183054628970664,6.7291611531548883,6.7291611531548883,null,null,"Pr =-17.56+5,3*ln(0.5*m^2)",null,null,null,"0.1<m<4.5",null,"Pr =",4.2,"Medium","Medium (21% fatality)"]
[0.18000000000000005,{"$f":"IF(Control!D$7<1,A23,A23*10)","v":1.8000000000000005},2.770630554390868,4.0189026395246108,6.4109215067171057,6.4109215067171057,null,null,"Pr=-13.19+10.54*ln(v)",null,null,null,"m > 4.5",null,"Pr =",2.5,"Safe","Safe (<0.1% fatality)"]
[0.19000000000000006,{"$f":"IF(Control!D$7<1,A24,A24*10)","v":1.9000000000000006},2.6463392427263597,3.8389663100241296,6.1237560666732413,6.1237560666732413,null,null,"where m is mass in kg and v is velocity in metres/second derived from assuming potential energy of mass*gravitational constant* height (mgh)"]
[0.20000000000000007,{"$f":"IF(Control!D$7<1,A25,A25*10)","v":2.0000000000000009},2.5335827038657279,3.6757142269768219,5.8632229761504924,5.8632229761504924,null,null,"is fully converted (without losses) to kinetic energy one-half*mass*velocity squared (0.5*m*v^2) so that v^2 = 2*g*h"]
[0.21000000000000008,{"$f":"IF(Control!D$7<1,A26,A26*10)","v":2.1000000000000005},2.4307902716507948,3.5268757915467028,5.6256973018268335,5.6256973018268335,null,7,"The probit function indicates the the relationship between exposure and the probability that the consequence occurs"]
[0.22000000000000008,{"$f":"IF(Control!D$7<1,A27,A27*10)","v":2.2000000000000011},2.3366670533894429,3.3905789106913256,5.4081903713531787,5.4081903713531787,null,8,"The probit data category of High has been used to define the fatal/DAWFC threshold"]
[0.23000000000000009,{"$f":"IF(Control!D$7<1,A28,A28*10)","v":2.3000000000000007},2.2501355900248412,3.2652657196133155,5.2082152045436656,5.2082152045436656,null,9,"The probit data category of Medium has been used to define the DAWFC/Recordable threshold"]
[0.2400000000000001,{"$f":"IF(Control!D$7<1,A29,A29*10)","v":2.4000000000000012},2.1702917813259739,3.1496289062015506,5.0236848424196223,5.0236848424196223,null,10,"The probit data category of Safe has been used to define the Recordable/First Aid threshold"]
[0.25000000000000011,{"$f":"IF(Control!D$7<1,A30,A30*10)","v":2.5000000000000009},2.096371155536632,3.0425629764633024,4.8528345340094123,4.8528345340094123,null,11,"DAWFC = Days Away From Work Case"]
[0.26000000000000012,{"$f":"IF(Control!D$7<1,A31,A31*10)","v":2.6000000000000014},2.0277227501458941,{"$f":"D$9*$B31^(D$10)","v":2.9431265139024538},4.6941614779510239,4.6941614779510239,null,12,"The best fit curves are fitted to data that does not exactly achieve the 7.00, 4.20 and 2.50 targets, "]
[0.27000000000000013,{"$f":"IF(Control!D$7<1,A32,A32*10)","v":2.7000000000000011},1.9637886673985465,2.8505126364228834,4.5463776534306559,4.5463776534306559,null,null,"but is reproduced for this chart because it matches the DROPS calculator card."]
[0.28000000000000014,{"$f":"IF(Control!D$7<1,A33,A33*10)","v":2.8000000000000016},1.9040879125259957,2.7640256403305048,4.4083725301607455,4.4083725301607455,null,13,"For future revisions, the 7.00, 4.20 and 2.50 target values may be accurately achieved by use of the \"goal seek\" function"]
[0.29000000000000015,{"$f":"IF(Control!D$7<1,A34,A34*10)","v":2.9000000000000012},1.8482035004734712,2.6830623665376674,4.2791833182544314,4.2791833182544314,null,14,"The best fit curves are fitted to data using mass values of 0.1 kg and greater and so are focussed on skull fracture"]
[0.30000000000000016,{"$f":"IF(Control!D$7<1,A35,A35*10)","v":3.0000000000000018},1.7957720829590527,2.6070972082857393,4.1579710323893764,4.1579710323893764]
[0.31000000000000016,{"$f":"IF(Control!D$7<1,A36,A36*10)","v":3.1000000000000014},1.7464755376164054,2.5356699539743417,4.0440010826243986,4.0440010826243986]
[0.32000000000000017,{"$f":"IF(Control!D$7<1,A37,A37*10)","v":3.200000000000002},1.7000340982403603,2.4683758569363645,3.9366274208027545,3.9366274208027545]
[0.33000000000000018,{"$f":"IF(Control!D$7<1,A38,A38*10)","v":3.3000000000000016},1.6562007055244461,2.404857468967649,3.835279502963334,3.835279502963334]
[0.34000000000000019,{"$f":"IF(Control!D$7<1,A39,A39*10)","v":3.4000000000000021},1.6147563318654596,2.3447978815774344,3.7394514992868357,3.7394514992868357]
[0.3500000000000002,{"$f":"IF(Control!D$7<1,A40,A40*10)","v":3.5000000000000018},1.5755060891973163,2.2879150989334773,3.6486933108568551,3.6486933108568551]
[0.36000000000000021,{"$f":"IF(Control!D$7<1,A41,A41*10)","v":3.6000000000000023},1.5382759705590432,2.2339573267772184,3.5626030488010962,3.5626030488010962]
[0.37000000000000022,{"$f":"IF(Control!D$7<1,A42,A42*10)","v":3.700000000000002},1.5029101078398763,2.1826990074355632,3.4808207045891941,3.4808207045891941]
[0.38000000000000023,{"$f":"IF(Control!D$7<1,A43,A43*10)","v":3.8000000000000025},1.469268452476282,2.1339374662093724,3.4030227963929729,3.4030227963929729]
[0.39000000000000024,{"$f":"IF(Control!D$7<1,A44,A44*10)","v":3.9000000000000021},1.4372248046756204,2.0874900615812244,3.3289178197847007,3.3289178197847007]
[0.40000000000000024,{"$f":"IF(Control!D$7<1,A45,A45*10)","v":4.0000000000000027},1.4066651313738585,2.0431917528276928,3.2582423648064363,3.2582423648064363]
[0.41000000000000025,{"$f":"IF(Control!D$7<1,A46,A46*10)","v":4.1000000000000023},1.3774861246032037,2.0008930151928426,3.1907577879022537,3.1907577879022537]
[0.42000000000000026,{"$f":"IF(Control!D$7<1,A47,A47*10)","v":4.2000000000000028},1.3495939609931811,1.9604580458537648,3.1262473480795299,3.1262473480795299]
[0.43000000000000027,{"$f":"IF(Control!D$7<1,A48,A48*10)","v":4.3000000000000025},{"$f":"C$9*$B48^(C$10)","v":1.3229032303110217},1.9217632142880636,3.0645137332368262,3.0645137332368262]
[0.44000000000000028,{"$f":"IF(Control!D$7<1,A49,A49*10)","v":4.400000000000003},1.2973360066825055,1.8846957189416185,3.0053769158290473,3.0053769158290473]
[0.45000000000000029,{"$f":"IF(Control!D$7<1,A50,A50*10)","v":4.5000000000000027},1.272821040739943,1.8491524187509032,2.9486722876673062,2.9486722876673062]
[0.4600000000000003,{"$f":"IF(Control!D$7<1,A51,A51*10)","v":4.6000000000000032},1.2492930546620247,1.8150388134477182,2.8942490322301579,2.8942490322301579]
[0.47000000000000031,{"$f":"IF(Control!D$7<1,A52,A52*10)","v":4.7000000000000028},1.2266921250871299,1.7822681509346339,2.8419686998244611,2.8419686998244611]
[0.48000000000000032,{"$f":"IF(Control!D$7<1,A53,A53*10)","v":4.8000000000000034},1.2049631413414874,1.7507606435747256,2.7917039566102679,2.7917039566102679]
[0.49000000000000032,{"$f":"IF(Control!D$7<1,A54,A54*10)","v":4.900000000000003},1.184055328438451,1.7204427781516201,2.7433374831538679,2.7433374831538679]
[0.50000000000000033,{"$f":"IF(Control!D$7<1,A55,A55*10)","v":5.0000000000000036},1.1639218259628543,1.6912467066520667,2.6967610019986599,2.6967610019986599]
[0.51000000000000034,{"$f":"IF(Control!D$7<1,A56,A56*10)","v":5.1000000000000032},1.1445193153240887,1.6631097070031808,2.6518744169044206,2.6518744169044206]
[0.52000000000000035,{"$f":"IF(Control!D$7<1,A57,A57*10)","v":5.2000000000000037},1.1258076889977464,1.6359737045390095,2.608585049027794,2.608585049027794]
[0.53000000000000036,{"$f":"IF(Control!D$7<1,A58,A58*10)","v":5.3000000000000034},1.1077497563219372,1.6097848463390327,2.5668069575006931,2.5668069575006931]
[0.54000000000000037,{"$f":"IF(Control!D$7<1,A59,A59*10)","v":5.4000000000000039},1.0903109812053204,1.5844931217246898,2.5264603336888038,2.5264603336888038]
[0.55000000000000038,{"$f":"IF(Control!D$7<1,A60,A60*10)","v":5.5000000000000036},1.073459247767433,1.5600520231593118,2.4874709599438498,2.4874709599438498]
[0.56000000000000039,{"$f":"IF(Control!D$7<1,A61,A61*10)","v":5.6000000000000041},1.0571646504904086,1.5364182426043593,2.4497697249523829,2.4497697249523829]
[0.5700000000000004,{"$f":"IF(Control!D$7<1,A62,A62*10)","v":5.7000000000000037},1.0413993059328952,1.5135513990668785,2.4132921888726568,2.4132921888726568]
[0.5800000000000004,{"$f":"IF(Control!D$7<1,A63,A63*10)","v":5.8000000000000043},1.0261371834566024,1.4914137936509073,2.3779781923735763,2.3779781923735763]
[0.59000000000000041,{"$f":"IF(Control!D$7<1,A64,A64*10)","v":5.9000000000000039},1.0113539527555417,1.4699701889166568,2.3437715044736604,2.3437715044736604]
[0.60000000000000042,{"$f":"IF(Control!D$7<1,A65,A65*10)","v":6.0000000000000044},0.99702684626748872,1.4491876097698368,2.3106195047461369,2.3106195047461369]
[0.61000000000000043,{"$f":"IF(Control!D$7<1,A66,A66*10)","v":6.1000000000000041},{"$f":"C$9*$B66^(C$10)","v":0.98313453479460555},1.4290351634612908,2.2784728960274401,2.2784728960274401]
[0.62000000000000044,{"$f":"IF(Control!D$7<1,A67,A67*10)","v":6.2000000000000046},0.96965701487225231,1.4094838765837547,2.2472854442559256,2.2472854442559256]
[0.63000000000000045,{"$f":"IF(Control!D$7<1,A68,A68*10)","v":6.3000000000000043},0.95657550660723367,1.3905065472161082,2.2170137424883003,2.2170137424883003]
[0.64000000000000046,{"$f":"IF(Control!D$7<1,A69,A69*10)","v":6.4000000000000048},0.94387236086375348,1.3720776105925416,2.1876169965037691,2.1876169965037691]
[0.65000000000000047,{"$f":"IF(Control!D$7<1,A70,A70*10)","v":6.5000000000000044},0.93153097481096059,1.3541730168701964,2.1590568297189376,2.1590568297189376]
[0.66000000000000048,{"$f":"IF(Control!D$7<1,A71,A71*10)","v":6.600000000000005},0.9195357149633786,1.3367701197386266,2.1312971054076049,2.1312971054076049]
[0.67000000000000048,{"$f":"IF(Control!D$7<1,A72,A72*10)","v":6.7000000000000046},0.90787184694739698,1.3198475747617957,2.104303764454766,2.104303764454766]
[0.68000000000000049,{"$f":"IF(Control!D$7<1,A73,A73*10)","v":6.8000000000000052},0.89652547131560922,1.3033852464714659,2.0780446770787422,2.0780446770787422]
[0.6900000000000005,{"$f":"IF(Control!D$7<1,A74,A74*10)","v":6.9000000000000048},0.8854834648080222,1.2873641233425641,2.0524895071336782,2.0524895071336782]
[0.70000000000000051,{"$f":"IF(Control!D$7<1,A75,A75*10)","v":7.0000000000000053},0.87473342652662411,1.2717662398786675,2.027609587760375,2.027609587760375]
[0.71000000000000052,{"$f":"IF(Control!D$7<1,A76,A76*10)","v":7.100000000000005},0.86426362854882932,1.2565746051211641,2.003377807289791,2.003377807289791]
[0.72000000000000053,{"$f":"IF(Control!D$7<1,A77,A77*10)","v":7.2000000000000055},0.85406297055711322,1.2417731369705294,1.9797685044230462,1.9797685044230462]
[0.73000000000000054,{"$f":"IF(Control!D$7<1,A78,A78*10)","v":7.3000000000000052},0.84412093810763311,1.227346601773984,1.9567573718168707,1.9567573718168707]
[0.74000000000000055,{"$f":"IF(Control!D$7<1,A79,A79*10)","v":7.4000000000000057},0.83442756420069097,1.2132805586917177,1.9343213672958564,1.9343213672958564]
[0.75000000000000056,{"$f":"IF(Control!D$7<1,A80,A80*10)","v":7.5000000000000053},0.82497339385120383,1.199561308404963,1.9124386319944673,{"$f":"E80","v":1.9124386319944673}]
[{"$f":"A80+0.01","v":0.76000000000000056},{"$f":"IF(Control!D$7<1,A81,A81*10)","v":7.6000000000000059},0.81574945138856136,1.1861758457743419,1.8910884148037999,1.8910884148037999]
[0.77000000000000057,{"$f":"IF(Control!D$7<1,A82,A82*10)","v":7.7000000000000055},0.8067472102428519,1.1731118160968523,1.8702510025618364,1.8702510025618364]
[0.78000000000000058,{"$f":"IF(Control!D$7<1,A83,A83*10)","v":7.800000000000006},0.79795856499892803,1.1603574746452741,1.8499076554824843,1.8499076554824843]
[0.79000000000000059,{"$f":"IF(Control!D$7<1,A84,A84*10)","v":7.9000000000000057},0.78937580552150655,1.1479016492052176,1.8300405473688548,1.8300405473688548]
[0.8000000000000006,{"$f":"IF(Control!D$7<1,A85,A85*10)","v":8.0000000000000053},0.78099159297382881,1.1357337053529935,1.8106327102008801,1.8106327102008801]
[0.81000000000000061,{"$f":"IF(Control!D$7<1,A86,A86*10)","v":8.1000000000000068},0.7727989375696227,1.1238435142423935,1.7916679827271182,1.7916679827271182]
[0.82000000000000062,{"$f":"IF(Control!D$7<1,A87,A87*10)","v":8.2000000000000064},0.76479117791345763,1.112221422690685,1.7731309627260454,1.7731309627260454]
[0.83000000000000063,{"$f":"IF(Control!D$7<1,A88,A88*10)","v":8.300000000000006},0.756961961798302,1.1008582253739574,1.7550069626338218,1.7550069626338218]
[0.84000000000000064,{"$f":"IF(Control!D$7<1,A89,A89*10)","v":8.4000000000000057},0.74930522834136404,1.0897451389597286,1.7372819682638401,1.7372819682638401]
[0.85000000000000064,{"$f":"IF(Control!D$7<1,A90,A90*10)","v":8.5000000000000071},0.74181519135028495,1.078873778020607,1.7199426003687632,1.7199426003687632]
[0.86000000000000065,{"$f":"IF(Control!D$7<1,A91,A91*10)","v":8.6000000000000068},0.73448632382161094,1.0682361325870746,1.7029760788185095,1.7029760788185095]
[0.87000000000000066,{"$f":"IF(Control!D$7<1,A92,A92*10)","v":8.7000000000000064},0.72731334348233534,1.0578245472102759,1.6863701891881109,1.6863701891881109]
[0.88000000000000067,{"$f":"IF(Control!D$7<1,A93,A93*10)","v":8.800000000000006},0.72029119929325169,1.0476317014172107,1.6701132515677621,1.6701132515677621]
[0.89000000000000068,{"$f":"IF(Control!D$7<1,A94,A94*10)","v":8.9000000000000075},0.71341505884004464,1.0376505914511238,1.6541940914239324,1.6541940914239324]
[0.90000000000000069,{"$f":"IF(Control!D$7<1,A95,A95*10)","v":9.0000000000000071},0.70668029654450593,1.027874513199214,1.6386020123553509,1.6386020123553509]
[0.9100000000000007,{"$f":"IF(Control!D$7<1,A96,A96*10)","v":9.1000000000000068},0.70008248263408923,1.018297046218261,1.6233267706011616,1.6233267706011616]
[0.92000000000000071,{"$f":"IF(Control!D$7<1,A97,A97*10)","v":9.2000000000000064},0.69361737281331715,1.0089120387763824,1.6083585511707275,1.6083585511707275]
[0.93000000000000071,{"$f":"IF(Control!D$7<1,A98,A98*10)","v":9.3000000000000078},0.68728089858529595,0.9997135938360423,1.5936879454755688,1.5936879454755688]
[0.94000000000000072,{"$f":"IF(Control!D$7<1,A99,A99*10)","v":9.4000000000000075},0.68106915817594482,0.99069605590969922,1.5793059303539358,1.5793059303539358]
[0.95000000000000073,{"$f":"IF(Control!D$7<1,A100,A100*10)","v":9.5000000000000071},0.67497840801744058,0.98185399872513413,1.5652038483875403,1.5652038483875403]
[0.96000000000000074,{"$f":"IF(Control!D$7<1,A101,A101*10)","v":9.6000000000000068},0.66900505475096184,0.97318221364267665,1.551373389418212,1.551373389418212]
[0.97000000000000075,{"$f":"IF(Control!D$7<1,A102,A102*10)","v":9.7000000000000082},0.66314564771202733,0.96467569877119763,1.5378065731797004,1.5378065731797004]
[0.98000000000000076,{"$f":"IF(Control!D$7<1,A103,A103*10)","v":9.8000000000000078},0.65739687186468154,0.95632964873401194,1.5244957329666415,1.5244957329666415]
[0.99000000000000077,{"$f":"IF(Control!D$7<1,A104,A104*10)","v":9.9000000000000075},0.65175554115345002,0.94813944503970926,1.5114335002688957,1.5114335002688957]
[1.0000000000000007,{"$f":"IF(Control!D$7<1,A105,A105*10)","v":10.000000000000007},0.64621859224442746,0.94010064701645524,1.4986127903051047,1.4986127903051047]

{"sheet":"Potential Outcome Calculator","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,9]]}
["One usable password is ","AAAABABBAAA>"]
[null,null,"Outcome Calculator"]
[]
[]
[null,null,null,"Height",null,2]
[]
[null,null,null,"Mass",null,2]
[]
[]
[]
[null,null,null,"Outcome",null,{"$f":"IF(Control!D5<data!C9*Control!D7^(data!C10),\"Slight\",IF(Control!D5<data!D9*Control!D7^(data!D10),\"Minor\",IF(Control!D5<data!E9*Control!D7^(data!E10),\"Major\",\"Fatality\")))","v":"Slight"}]