{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Control","data","Potential Outcome Calculator"],"not_rendered":{"charts":1,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Control","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"hidden":true}
[]
[]
[]
[{"$nulls":3},"m","ft"]
[null,null,1,{"$f":"IF(C5=1,'Potential Outcome Calculator'!F5,'Potential Outcome Calculator'!F5*0.3048)","v":{"v":1,"d":"1.000"}},{"$f":"IF(C5=2,'Potential Outcome Calculator'!F5,'Potential Outcome Calculator'!F5*3.280839895)","v":{"v":3.280839895,"d":"3.281"}}]
[{"$nulls":3},"Kgs","Lbs"]
[null,null,1,{"$f":"IF(C7=1,'Potential Outcome Calculator'!F7,'Potential Outcome Calculator'!F7*0.45359237)","v":{"v":0.4,"d":"0.400"}},{"$f":"IF(C7=2,'Potential Outcome Calculator'!F7,'Potential Outcome Calculator'!F7*2.204622622)","v":{"v":0.8818490488,"d":"0.882"}}]
[]
[]
[null,null,"m","kg"]
[null,null,"ft","lb"]

{"sheet":"data","index":1,"n_rows":105,"n_cols":18,"rows_kept":105,"hidden":true}
[null,null,"limited data"]
[null,null,{"v":4.4006743306671225,"d":"4.4007"},{"v":6.456944327617776,"d":"6.4569"},{"v":10.297240136550943,"d":"10.2972"}]
[null,null,-1.0015,-0.9996,-0.9969]
[]
[null,null,"full data"]
[null,null,{"v":4.563304495262663,"d":"4.5633"},{"v":6.612631956692916,"d":"6.6126"},{"v":10.550898250965846,"d":"10.5509"}]
[null,null,-0.8489,-0.8472,-0.8476]
[]
[null,null,{"$f":"IF(Control!D7<1,data!C2,data!C6)","v":{"v":4.4006743306671225,"d":"4.401"}},{"$f":"IF(Control!D7<1,data!D2,data!D6)","v":{"v":6.456944327617776,"d":"6.457"}},{"$f":"IF(Control!D7<1,data!E2,data!E6)","v":{"v":10.297240136550943,"d":"10.297"}}]
[null,null,{"$f":"IF(Control!D7<1,data!C3,data!C7)","v":{"v":-1.0015,"d":"-1.002"}},{"$f":"IF(Control!D7<1,data!D3,data!D7)","v":{"v":-0.9996,"d":"-1.000"}},{"$f":"IF(Control!D7<1,data!E3,data!E7)","v":{"v":-0.9969,"d":"-0.997"}}]
[]
[]
[]
[null,"Mass","Slight","Minor","Major","Fatality",null,null,"Notes"]
[{"v":0.1,"d":"0.100"},{"$f":"IF(Control!D$7<1,A15,A15*10)","v":{"v":0.1,"d":"0.10"}},{"$f":"C$9*$B15^(C$10)","v":{"v":44.158999999999985,"d":"44.16"}},{"$f":"D$9*$B15^(D$10)","v":{"v":64.50999999999998,"d":"64.51"}},{"v":102.23999999999995,"d":"102.24"},{"$f":"E15","v":{"v":102.23999999999995,"d":"102.24"}},null,1,"Dropped object classification is defined by mass of object and height from which it falls"]
[{"$f":"A15+0.01","v":{"v":0.11,"d":"0.110"}},{"$f":"IF(Control!D$7<1,A16,A16*10)","v":0.11},{"v":40.13880658901628,"d":"40.14"},{"v":58.647690391601,"d":"58.65"},{"v":92.97292041156115,"d":"92.97"},{"v":92.97292041156115,"d":"92.97"},null,2,"The threshold values between classifications are defined by best-fit curves to the \"probit\" data"]
[{"$f":"A16+0.01","v":{"v":0.12,"d":"0.120"}},{"$f":"IF(Control!D$7<1,A17,A17*10)","v":0.12},{"v":36.78910412066059,"d":"36.79"},{"v":53.762253997505496,"d":"53.76"},{"v":85.24816838060605,"d":"85.25"},{"v":85.24816838060605,"d":"85.25"},null,3,"The best fit curves are presented as \"limited data\" for mass in the range 0.1 to 1.0 kg"]
[{"v":0.13,"d":"0.130"},{"$f":"IF(Control!D$7<1,A18,A18*10)","v":0.13},{"v":33.955096002973264,"d":"33.96"},{"v":49.628284925181866,"d":"49.63"},{"v":78.71014508054849,"d":"78.71"},{"v":78.71014508054849,"d":"78.71"},null,4,"The best fit curves are presented as \"full data\" for mass in the range 1.0 to 10.0 kg"]
[{"v":0.14,"d":"0.140"},{"$f":"IF(Control!D$7<1,A19,A19*10)","v":0.14},{"v":31.526227290807903,"d":"31.53"},{"v":46.08477350992325,"d":"46.08"},{"v":73.10478463826072,"d":"73.10"},{"v":73.10478463826072,"d":"73.10"},null,5,"The best fit curves are presented in the format               height= A*mass^B"]
[{"v":0.15000000000000002,"d":"0.150"},{"$f":"IF(Control!D$7<1,A20,A20*10)","v":{"v":0.15000000000000002,"d":"0.15"}},{"v":29.4214338433901,"d":"29.42"},{"v":43.01364231342738,"d":"43.01"},{"v":68.24572702113572,"d":"68.25"},{"v":68.24572702113572,"d":"68.25"},null,6,"The probit data is as follows"]
[{"v":0.16000000000000003,"d":"0.160"},{"$f":"IF(Control!D$7<1,A21,A21*10)","v":{"v":0.16000000000000003,"d":"0.16"}},{"v":27.579924147661657,"d":"27.58"},{"v":40.326330696099255,"d":"40.33"},{"v":63.9931708779434,"d":"63.99"},{"v":63.9931708779434,"d":"63.99"},null,null,"Pr =-29.15+2,1*ln(m*v^5.115)",{"$nulls":3},"0.001<m<0.1",null,"Pr =",{"v":7,"d":"7.00"},"High","High (99% fatality)"]
[{"v":0.17000000000000004,"d":"0.170"},{"$f":"IF(Control!D$7<1,A22,A22*10)","v":{"v":0.17000000000000004,"d":"0.17"}},{"v":25.955215273400352,"d":"25.96"},{"v":37.95511399094162,"d":"37.96"},{"v":60.24018696438952,"d":"60.24"},{"v":60.24018696438952,"d":"60.24"},null,null,"Pr =-17.56+5,3*ln(0.5*m^2)",{"$nulls":3},"0.1<m<4.5",null,"Pr =",{"v":4.2,"d":"4.20"},"Medium","Medium (21% fatality)"]
[{"v":0.18000000000000005,"d":"0.180"},{"$f":"IF(Control!D$7<1,A23,A23*10)","v":{"v":0.18000000000000005,"d":"0.18"}},{"v":24.511157250925194,"d":"24.51"},{"v":35.84731612792331,"d":"35.85"},{"v":56.90359182663004,"d":"56.90"},{"v":56.90359182663004,"d":"56.90"},null,null,"Pr=-13.19+10.54*ln(v)",{"$nulls":3},"m > 4.5",null,"Pr =",{"v":2.5,"d":"2.50"},"Safe","Safe (<0.1% fatality)"]
[{"v":0.19000000000000006,"d":"0.190"},{"$f":"IF(Control!D$7<1,A24,A24*10)","v":{"v":0.19000000000000006,"d":"0.19"}},{"v":23.219213169115108,"d":"23.22"},{"v":33.961349749467686,"d":"33.96"},{"v":53.91770224276319,"d":"53.92"},{"v":53.91770224276319,"d":"53.92"},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)"]
[{"v":0.20000000000000007,"d":"0.200"},{"$f":"IF(Control!D$7<1,A25,A25*10)","v":{"v":0.20000000000000007,"d":"0.20"}},{"v":22.056555415287846,"d":"22.06"},{"v":32.26394422479911,"d":"32.26"},{"v":51.22996251901372,"d":"51.23"},{"v":51.22996251901372,"d":"51.23"},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"]
[{"v":0.21000000000000008,"d":"0.210"},{"$f":"IF(Control!D$7<1,A26,A26*10)","v":{"v":0.21000000000000008,"d":"0.21"}},{"v":21.00470596182396,"d":"21.00"},{"v":30.728165615426324,"d":"30.73"},{"v":48.797820582567084,"d":"48.80"},{"v":48.797820582567084,"d":"48.80"},null,7,"The probit function indicates the the relationship between exposure and the probability that the consequence occurs"]
[{"v":0.22000000000000008,"d":"0.220"},{"$f":"IF(Control!D$7<1,A27,A27*10)","v":{"v":0.22000000000000008,"d":"0.22"}},{"v":20.048547562991892,"d":"20.05"},{"v":29.331976619251307,"d":"29.33"},{"v":46.586455672608786,"d":"46.59"},{"v":46.586455672608786,"d":"46.59"},null,8,"The probit data category of High has been used to define the fatal/DAWFC threshold"]
[{"v":0.2300000000000001,"d":"0.230"},{"$f":"IF(Control!D$7<1,A28,A28*10)","v":{"v":0.2300000000000001,"d":"0.23"}},{"v":19.17559295600698,"d":"19.18"},{"v":28.057172159846456,"d":"28.06"},{"v":44.56709854362159,"d":"44.57"},{"v":44.56709854362159,"d":"44.57"},null,9,"The probit data category of Medium has been used to define the DAWFC/Recordable threshold"]
[{"v":0.2400000000000001,"d":"0.240"},{"$f":"IF(Control!D$7<1,A29,A29*10)","v":{"v":0.2400000000000001,"d":"0.24"}},{"v":18.3754368014707,"d":"18.38"},{"v":26.888581063013497,"d":"26.89"},{"v":42.71577142950919,"d":"42.72"},{"v":42.71577142950919,"d":"42.72"},null,10,"The probit data category of Safe has been used to define the Recordable/First Aid threshold"]
[{"v":0.2500000000000001,"d":"0.250"},{"$f":"IF(Control!D$7<1,A30,A30*10)","v":{"v":0.2500000000000001,"d":"0.25"}},{"v":17.63933918683059,"d":"17.64"},{"v":25.813459319809613,"d":"25.81"},{"v":41.01233027982589,"d":"41.01"},{"v":41.01233027982589,"d":"41.01"},null,11,"DAWFC = Days Away From Work Case"]
[{"v":0.2600000000000001,"d":"0.260"},{"$f":"IF(Control!D$7<1,A31,A31*10)","v":{"v":0.2600000000000001,"d":"0.26"}},{"v":16.959905265540392,"d":"16.96"},{"$f":"D$9*$B31^(D$10)","v":{"v":24.821023357595823,"d":"24.82"}},{"v":39.43972791806173,"d":"39.44"},{"v":39.43972791806173,"d":"39.44"},null,12,"The best fit curves are fitted to data that does not exactly achieve the 7.00, 4.20 and 2.50 targets, "]
[{"v":0.27000000000000013,"d":"0.270"},{"$f":"IF(Control!D$7<1,A32,A32*10)","v":{"v":0.27000000000000013,"d":"0.27"}},{"v":16.330836103241182,"d":"16.33"},{"v":23.902087022521318,"d":"23.90"},{"v":37.98344086778487,"d":"37.98"},{"v":37.98344086778487,"d":"37.98"},null,null,"but is reproduced for this chart because it matches the DROPS calculator card."]
[{"v":0.28000000000000014,"d":"0.280"},{"$f":"IF(Control!D$7<1,A33,A33*10)","v":{"v":0.28000000000000014,"d":"0.28"}},{"v":15.746732925896517,"d":"15.75"},{"v":23.04877634687123,"d":"23.05"},{"v":36.631018945409494,"d":"36.63"},{"v":36.631018945409494,"d":"36.63"},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"]
[{"v":0.29000000000000015,"d":"0.290"},{"$f":"IF(Control!D$7<1,A34,A34*10)","v":{"v":0.29000000000000015,"d":"0.29"}},{"v":15.20294187734373,"d":"15.20"},{"v":22.254303326557586,"d":"22.25"},{"v":35.3717279977226,"d":"35.37"},{"v":35.3717279977226,"d":"35.37"},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"]
[{"v":0.30000000000000016,"d":"0.300"},{"$f":"IF(Control!D$7<1,A35,A35*10)","v":{"v":0.30000000000000016,"d":"0.30"}},{"v":14.695429832286942,"d":"14.70"},{"v":21.512784940410484,"d":"21.51"},{"v":34.19626405883828,"d":"34.20"},{"v":34.19626405883828,"d":"34.20"}]
[{"v":0.31000000000000016,"d":"0.310"},{"$f":"IF(Control!D$7<1,A36,A36*10)","v":{"v":0.31000000000000016,"d":"0.31"}},{"v":14.22068425088809,"d":"14.22"},{"v":20.819097195893747,"d":"20.82"},{"v":33.09652280590858,"d":"33.10"},{"v":33.09652280590858,"d":"33.10"}]
[{"v":0.3200000000000002,"d":"0.320"},{"$f":"IF(Control!D$7<1,A37,A37*10)","v":{"v":0.3200000000000002,"d":"0.32"}},{"v":13.77563181485846,"d":"13.78"},{"v":20.1687565396024,"d":"20.17"},{"v":32.06541222173202,"d":"32.07"},{"v":32.06541222173202,"d":"32.07"}]
[{"v":0.3300000000000002,"d":"0.330"},{"$f":"IF(Control!D$7<1,A38,A38*10)","v":{"v":0.3300000000000002,"d":"0.33"}},{"v":13.357571860337098,"d":"13.36"},{"v":19.55782282818619,"d":"19.56"},{"v":31.096699302768986,"d":"31.10"},{"v":31.096699302768986,"d":"31.10"}]
[{"v":0.3400000000000002,"d":"0.340"},{"$f":"IF(Control!D$7<1,A39,A39*10)","v":{"v":0.3400000000000002,"d":"0.34"}},{"v":12.964121560576109,"d":"12.96"},{"v":18.98281942101431,"d":"18.98"},{"v":30.18488380598645,"d":"30.18"},{"v":30.18488380598645,"d":"30.18"}]
[{"v":0.3500000000000002,"d":"0.350"},{"$f":"IF(Control!D$7<1,A40,A40*10)","v":{"v":0.3500000000000002,"d":"0.35"}},{"v":12.593170508020467,"d":"12.59"},{"v":18.440666970408365,"d":"18.44"},{"v":29.325093628911304,"d":"29.33"},{"v":29.325093628911304,"d":"29.33"}]
[{"v":0.3600000000000002,"d":"0.360"},{"$f":"IF(Control!D$7<1,A41,A41*10)","v":{"v":0.3600000000000002,"d":"0.36"}},{"v":12.242842867770241,"d":"12.24"},{"v":17.928628246164312,"d":"17.93"},{"v":28.512997618109473,"d":"28.51"},{"v":28.512997618109473,"d":"28.51"}]
[{"v":0.3700000000000002,"d":"0.370"},{"$f":"IF(Control!D$7<1,A42,A42*10)","v":{"v":0.3700000000000002,"d":"0.37"}},{"v":11.911465669724862,"d":"11.91"},{"v":17.44426190690276,"d":"17.44"},{"v":27.7447325101379,"d":"27.74"},{"v":27.7447325101379,"d":"27.74"}]
[{"v":0.3800000000000002,"d":"0.380"},{"$f":"IF(Control!D$7<1,A43,A43*10)","v":{"v":0.3800000000000002,"d":"0.38"}},{"v":11.597542108380368,"d":"11.60"},{"v":16.98538357023284,"d":"16.99"},{"v":27.016841402661395,"d":"27.02"},{"v":27.016841402661395,"d":"27.02"}]
[{"v":0.39000000000000024,"d":"0.390"},{"$f":"IF(Control!D$7<1,A44,A44*10)","v":{"v":0.39000000000000024,"d":"0.39"}},{"v":11.299728951295553,"d":"11.30"},{"v":16.55003287175404,"d":"16.55"},{"v":26.326221687049177,"d":"26.33"},{"v":26.326221687049177,"d":"26.33"}]
[{"v":0.40000000000000024,"d":"0.400"},{"$f":"IF(Control!D$7<1,A45,A45*10)","v":{"v":0.40000000000000024,"d":"0.40"}},{"v":11.016817337069758,"d":"11.02"},{"v":16.13644546490386,"d":"16.14"},{"v":25.67008078735868,"d":"25.67"},{"v":25.67008078735868,"d":"25.67"}]
[{"v":0.41000000000000025,"d":"0.410"},{"$f":"IF(Control!D$7<1,A46,A46*10)","v":{"v":0.41000000000000025,"d":"0.41"}},{"v":10.747716384022269,"d":"10.75"},{"v":15.743029118136144,"d":"15.74"},{"v":25.045898373446946,"d":"25.05"},{"v":25.045898373446946,"d":"25.05"}]
[{"v":0.42000000000000026,"d":"0.420"},{"$f":"IF(Control!D$7<1,A47,A47*10)","v":{"v":0.42000000000000026,"d":"0.42"}},{"v":10.491439141031206,"d":"10.49"},{"v":15.368343226577348,"d":"15.37"},{"v":24.45139396962508,"d":"24.45"},{"v":24.45139396962508,"d":"24.45"}]
[{"v":0.43000000000000027,"d":"0.430"},{"$f":"IF(Control!D$7<1,A48,A48*10)","v":{"v":0.43000000000000027,"d":"0.43"}},{"$f":"C$9*$B48^(C$10)","v":{"v":10.247090499175426,"d":"10.25"}},{"v":15.011081182344556,"d":"15.01"},{"v":23.884499080867663,"d":"23.88"},{"v":23.884499080867663,"d":"23.88"}]
[{"v":0.4400000000000003,"d":"0.440"},{"$f":"IF(Control!D$7<1,A49,A49*10)","v":{"v":0.4400000000000003,"d":"0.44"}},{"v":10.013856752172032,"d":"10.01"},{"v":14.67005514876199,"d":"14.67"},{"v":23.343333118167482,"d":"23.34"},{"v":23.343333118167482,"d":"23.34"}]
[{"v":0.4500000000000003,"d":"0.450"},{"$f":"IF(Control!D$7<1,A50,A50*10)","v":{"v":0.4500000000000003,"d":"0.45"}},{"v":9.790996549079725,"d":"9.79"},{"v":14.344182864555943,"d":"14.34"},{"v":22.826182532298052,"d":"22.83"},{"v":22.826182532298052,"d":"22.83"}]
[{"v":0.4600000000000003,"d":"0.460"},{"$f":"IF(Control!D$7<1,A51,A51*10)","v":{"v":0.4600000000000003,"d":"0.46"}},{"v":9.577833027359569,"d":"9.58"},{"v":14.032476169134593,"d":"14.03"},{"v":22.331482667947245,"d":"22.33"},{"v":22.331482667947245,"d":"22.33"}]
[{"v":0.4700000000000003,"d":"0.470"},{"$f":"IF(Control!D$7<1,A52,A52*10)","v":{"v":0.4700000000000003,"d":"0.47"}},{"v":9.373746950460472,"d":"9.37"},{"v":13.73403099263449,"d":"13.73"},{"v":21.857801933225993,"d":"21.86"},{"v":21.857801933225993,"d":"21.86"}]
[{"v":0.4800000000000003,"d":"0.480"},{"$f":"IF(Control!D$7<1,A53,A53*10)","v":{"v":0.4800000000000003,"d":"0.48"}},{"v":9.178170703407192,"d":"9.18"},{"v":13.448018597133114,"d":"13.45"},{"v":21.403827947031623,"d":"21.40"},{"v":21.403827947031623,"d":"21.40"}]
[{"v":0.4900000000000003,"d":"0.490"},{"$f":"IF(Control!D$7<1,A54,A54*10)","v":{"v":0.4900000000000003,"d":"0.49"}},{"v":8.990583023794741,"d":"8.99"},{"v":13.173677890299054,"d":"13.17"},{"v":20.96835538183091,"d":"20.97"},{"v":20.96835538183091,"d":"20.97"}]
[{"v":0.5000000000000003,"d":"0.500"},{"$f":"IF(Control!D$7<1,A55,A55*10)","v":{"v":0.5000000000000003,"d":"0.50"}},{"v":8.81050436521179,"d":"8.81"},{"v":12.910308661346434,"d":"12.91"},{"v":20.550275264601844,"d":"20.55"},{"v":20.550275264601844,"d":"20.55"}]
[{"v":0.5100000000000003,"d":"0.510"},{"$f":"IF(Control!D$7<1,A56,A56*10)","v":{"v":0.5100000000000003,"d":"0.51"}},{"v":8.63749280627182,"d":"8.64"},{"v":12.65726561270954,"d":"12.66"},{"v":20.148565535876887,"d":"20.15"},{"v":20.148565535876887,"d":"20.15"}]
[{"v":0.5200000000000004,"d":"0.520"},{"$f":"IF(Control!D$7<1,A57,A57*10)","v":{"v":0.5200000000000004,"d":"0.52"}},{"v":8.47114043179021,"d":"8.47"},{"v":12.413953080327202,"d":"12.41"},{"v":19.762282697597833,"d":"19.76"},{"v":19.762282697597833,"d":"19.76"}]
[{"v":0.5300000000000004,"d":"0.530"},{"$f":"IF(Control!D$7<1,A58,A58*10)","v":{"v":0.5300000000000004,"d":"0.53"}},{"v":8.311070123735837,"d":"8.31"},{"v":12.179820351593275,"d":"12.18"},{"v":19.39055440603629,"d":"19.39"},{"v":19.39055440603629,"d":"19.39"}]
[{"v":0.5400000000000004,"d":"0.540"},{"$f":"IF(Control!D$7<1,A59,A59*10)","v":{"v":0.5400000000000004,"d":"0.54"}},{"v":8.156932708827703,"d":"8.16"},{"v":11.954357503502134,"d":"11.95"},{"v":19.032572887321923,"d":"19.03"},{"v":19.032572887321923,"d":"19.03"}]
[{"v":0.5500000000000004,"d":"0.550"},{"$f":"IF(Control!D$7<1,A60,A60*10)","v":{"v":0.5500000000000004,"d":"0.55"}},{"v":8.008404417376296,"d":"8.01"},{"v":11.737091694786093,"d":"11.74"},{"v":18.68758907092626,"d":"18.69"},{"v":18.68758907092626,"d":"18.69"}]
[{"v":0.5600000000000004,"d":"0.560"},{"$f":"IF(Control!D$7<1,A61,A61*10)","v":{"v":0.5600000000000004,"d":"0.56"}},{"v":7.865184614456267,"d":"7.87"},{"v":11.527583855298754,"d":"11.53"},{"v":18.35490735139486,"d":"18.35"},{"v":18.35490735139486,"d":"18.35"}]
[{"v":0.5700000000000004,"d":"0.570"},{"$f":"IF(Control!D$7<1,A62,A62*10)","v":{"v":0.5700000000000004,"d":"0.57"}},{"v":7.726993769959557,"d":"7.73"},{"v":11.325425723862374,"d":"11.33"},{"v":18.03388090120645,"d":"18.03"},{"v":18.03388090120645,"d":"18.03"}]
[{"v":0.5800000000000004,"d":"0.580"},{"$f":"IF(Control!D$7<1,A63,A63*10)","v":{"v":0.5800000000000004,"d":"0.58"}},{"v":7.593571638692729,"d":"7.59"},{"v":11.13023719252543,"d":"11.13"},{"v":17.723907468271502,"d":"17.72"},{"v":17.723907468271502,"d":"17.72"}]
[{"v":0.5900000000000004,"d":"0.590"},{"$f":"IF(Control!D$7<1,A64,A64*10)","v":{"v":0.5900000000000004,"d":"0.59"}},{"v":7.464675625593032,"d":"7.46"},{"v":10.941663920878629,"d":"10.94"},{"v":17.42442560059438,"d":"17.42"},{"v":17.42442560059438,"d":"17.42"}]
[{"v":0.6000000000000004,"d":"0.600"},{"$f":"IF(Control!D$7<1,A65,A65*10)","v":{"v":0.6000000000000004,"d":"0.60"}},{"v":7.34007931446163,"d":"7.34"},{"v":10.759375188924235,"d":"10.76"},{"v":17.134911248284247,"d":"17.13"},{"v":17.134911248284247,"d":"17.13"}]
[{"v":0.6100000000000004,"d":"0.610"},{"$f":"IF(Control!D$7<1,A66,A66*10)","v":{"v":0.6100000000000004,"d":"0.61"}},{"$f":"C$9*$B66^(C$10)","v":{"v":7.219571141445964,"d":"7.22"}},{"v":10.583061961125173,"d":"10.58"},{"v":16.854874699630354,"d":"16.85"},{"v":16.854874699630354,"d":"16.85"}]
[{"v":0.6200000000000004,"d":"0.620"},{"$f":"IF(Control!D$7<1,A67,A67*10)","v":{"v":0.6200000000000004,"d":"0.62"}},{"v":7.1029531969252995,"d":"7.10"},{"v":10.412435137792398,"d":"10.41"},{"v":16.58385781354049,"d":"16.58"},{"v":16.58385781354049,"d":"16.58"}]
[{"v":0.6300000000000004,"d":"0.630"},{"$f":"IF(Control!D$7<1,A68,A68*10)","v":{"v":0.6300000000000004,"d":"0.63"}},{"v":6.990040141529546,"d":"6.99"},{"v":10.247223972996167,"d":"10.25"},{"v":16.321431515427214,"d":"16.32"},{"v":16.321431515427214,"d":"16.32"}]
[{"v":0.6400000000000005,"d":"0.640"},{"$f":"IF(Control!D$7<1,A69,A69*10)","v":{"v":0.6400000000000005,"d":"0.64"}},{"v":6.880658223805519,"d":"6.88"},{"v":10.087174640788781,"d":"10.09"},{"v":16.0671935277392,"d":"16.07"},{"v":16.0671935277392,"d":"16.07"}]
[{"v":0.6500000000000005,"d":"0.650"},{"$f":"IF(Control!D$7<1,A70,A70*10)","v":{"v":0.6500000000000005,"d":"0.65"}},{"v":6.774644388581744,"d":"6.77"},{"v":9.932048933767545,"d":"9.93"},{"v":15.820766309878898,"d":"15.82"},{"v":15.820766309878898,"d":"15.82"}]
[{"v":0.6600000000000005,"d":"0.660"},{"$f":"IF(Control!D$7<1,A71,A71*10)","v":{"v":0.6600000000000005,"d":"0.66"}},{"v":6.671845466410352,"d":"6.67"},{"v":9.781623079942678,"d":"9.78"},{"v":15.581795185308058,"d":"15.58"},{"v":15.581795185308058,"d":"15.58"}]
[{"v":0.6700000000000005,"d":"0.670"},{"$f":"IF(Control!D$7<1,A72,A72*10)","v":{"v":0.6700000000000005,"d":"0.67"}},{"v":6.572117435613577,"d":"6.57"},{"v":9.635686665550617,"d":"9.64"},{"v":15.349946636292499,"d":"15.35"},{"v":15.349946636292499,"d":"15.35"}]
[{"v":0.6800000000000005,"d":"0.680"},{"$f":"IF(Control!D$7<1,A73,A73*10)","v":{"v":0.6800000000000005,"d":"0.68"}},{"v":6.475324749459339,"d":"6.48"},{"v":9.494041652907134,"d":"9.49"},{"v":15.124906749036295,"d":"15.12"},{"v":15.124906749036295,"d":"15.12"}]
[{"v":0.6900000000000005,"d":"0.690"},{"$f":"IF(Control!D$7<1,A74,A74*10)","v":{"v":0.6900000000000005,"d":"0.69"}},{"v":6.381339721857296,"d":"6.38"},{"v":9.356501483659112,"d":"9.36"},{"v":14.906379793954928,"d":"14.91"},{"v":14.906379793954928,"d":"14.91"}]
[{"v":0.7000000000000005,"d":"0.700"},{"$f":"IF(Control!D$7<1,A75,A75*10)","v":{"v":0.7000000000000005,"d":"0.70"}},{"v":6.2900419657220965,"d":"6.29"},{"v":9.222890258895534,"d":"9.22"},{"v":14.694086927579171,"d":"14.69"},{"v":14.694086927579171,"d":"14.69"}]
[{"v":0.7100000000000005,"d":"0.710"},{"$f":"IF(Control!D$7<1,A76,A76*10)","v":{"v":0.7100000000000005,"d":"0.71"}},{"v":6.201317878810238,"d":"6.20"},{"v":9.093041988540454,"d":"9.09"},{"v":14.487765004102993,"d":"14.49"},{"v":14.487765004102993,"d":"14.49"}]
[{"v":0.7200000000000005,"d":"0.720"},{"$f":"IF(Control!D$7<1,A77,A77*10)","v":{"v":0.7200000000000005,"d":"0.72"}},{"v":6.115060172414139,"d":"6.12"},{"v":8.966799903292566,"d":"8.97"},{"v":14.287165485920154,"d":"14.29"},{"v":14.287165485920154,"d":"14.29"}]
[{"v":0.7300000000000005,"d":"0.730"},{"$f":"IF(Control!D$7<1,A78,A78*10)","v":{"v":0.7300000000000005,"d":"0.73"}},{"v":6.03116743880294,"d":"6.03"},{"v":8.844015823114065,"d":"8.84"},{"v":14.092053443661374,"d":"14.09"},{"v":14.092053443661374,"d":"14.09"}]
[{"v":0.7400000000000005,"d":"0.740"},{"$f":"IF(Control!D$7<1,A79,A79*10)","v":{"v":0.7400000000000005,"d":"0.74"}},{"v":5.949543753744088,"d":"5.95"},{"v":8.724549576919838,"d":"8.72"},{"v":13.90220663726943,"d":"13.90"},{"v":13.90220663726943,"d":"13.90"}]
[{"v":0.7500000000000006,"d":"0.750"},{"$f":"IF(Control!D$7<1,A80,A80*10)","v":{"v":0.7500000000000006,"d":"0.75"}},{"v":5.870098310830826,"d":"5.87"},{"v":8.608268468688562,"d":"8.61"},{"v":13.717414670551797,"d":"13.72"},{"$f":"E80","v":{"v":13.717414670551797,"d":"13.72"}}]
[{"$f":"A80+0.01","v":{"v":0.7600000000000006,"d":"0.760"}},{"$f":"IF(Control!D$7<1,A81,A81*10)","v":{"v":0.7600000000000006,"d":"0.76"}},{"v":5.792745084685475,"d":"5.79"},{"v":8.495046785720227,"d":"8.50"},{"v":13.537478212446025,"d":"13.54"},{"v":13.537478212446025,"d":"13.54"}]
[{"v":0.7700000000000006,"d":"0.770"},{"$f":"IF(Control!D$7<1,A82,A82*10)","v":{"v":0.7700000000000006,"d":"0.77"}},{"v":5.717402520412943,"d":"5.72"},{"v":8.384765345208779,"d":"8.38"},{"v":13.362208278935636,"d":"13.36"},{"v":13.362208278935636,"d":"13.36"}]
[{"v":0.7800000000000006,"d":"0.780"},{"$f":"IF(Control!D$7<1,A83,A83*10)","v":{"v":0.7800000000000006,"d":"0.78"}},{"v":5.6439932469481375,"d":"5.64"},{"v":8.27731107569159,"d":"8.28"},{"v":13.191425570175822,"d":"13.19"},{"v":13.191425570175822,"d":"13.19"}]
[{"v":0.7900000000000006,"d":"0.790"},{"$f":"IF(Control!D$7<1,A84,A84*10)","v":{"v":0.7900000000000006,"d":"0.79"}},{"v":5.572443812179716,"d":"5.57"},{"v":8.172576630285517,"d":"8.17"},{"v":13.02495985793902,"d":"13.02"},{"v":13.02495985793902,"d":"13.02"}]
[{"v":0.8000000000000006,"d":"0.800"},{"$f":"IF(Control!D$7<1,A85,A85*10)","v":{"v":0.8000000000000006,"d":"0.80"}},{"v":5.502684437944317,"d":"5.50"},{"v":8.070460028928398,"d":"8.07"},{"v":12.862649418979263,"d":"12.86"},{"v":12.862649418979263,"d":"12.86"}]
[{"v":0.8100000000000006,"d":"0.810"},{"$f":"IF(Control!D$7<1,A86,A86*10)","v":{"v":0.8100000000000006,"d":"0.81"}},{"v":5.43464879317374,"d":"5.43"},{"v":7.970864327119481,"d":"7.97"},{"v":12.704340510348606,"d":"12.70"},{"v":12.704340510348606,"d":"12.70"}]
[{"v":0.8200000000000006,"d":"0.820"},{"$f":"IF(Control!D$7<1,A87,A87*10)","v":{"v":0.8200000000000006,"d":"0.82"}},{"v":5.368273783645108,"d":"5.37"},{"v":7.873697308896808,"d":"7.87"},{"v":12.549886883086016,"d":"12.55"},{"v":12.549886883086016,"d":"12.55"}]
[{"v":0.8300000000000006,"d":"0.830"},{"$f":"IF(Control!D$7<1,A88,A88*10)","v":{"v":0.8300000000000006,"d":"0.83"}},{"v":5.3034993569334725,"d":"5.30"},{"v":7.778871202007565,"d":"7.78"},{"v":12.399149331043718,"d":"12.40"},{"v":12.399149331043718,"d":"12.40"}]
[{"v":0.8400000000000006,"d":"0.840"},{"$f":"IF(Control!D$7<1,A89,A89*10)","v":{"v":0.8400000000000006,"d":"0.84"}},{"v":5.24026832129973,"d":"5.24"},{"v":7.68630241342212,"d":"7.69"},{"v":12.251995271924212,"d":"12.25"},{"v":12.251995271924212,"d":"12.25"}]
[{"v":0.8500000000000006,"d":"0.850"},{"$f":"IF(Control!D$7<1,A90,A90*10)","v":{"v":0.8500000000000006,"d":"0.85"}},{"v":5.178526177366008,"d":"5.18"},{"v":7.595911283516433,"d":"7.60"},{"v":12.10829835787642,"d":"12.11"},{"v":12.10829835787642,"d":"12.11"}]
[{"v":0.8600000000000007,"d":"0.860"},{"$f":"IF(Control!D$7<1,A91,A91*10)","v":{"v":0.8600000000000007,"d":"0.86"}},{"v":5.118220961537454,"d":"5.12"},{"v":7.507621857403449,"d":"7.51"},{"v":11.967938113245976,"d":"11.97"},{"v":11.967938113245976,"d":"11.97"}]
[{"v":0.8700000000000007,"d":"0.870"},{"$f":"IF(Control!D$7<1,A92,A92*10)","v":{"v":0.8700000000000007,"d":"0.87"}},{"v":5.059303100225131,"d":"5.06"},{"v":7.421361672033718,"d":"7.42"},{"v":11.830799597295835,"d":"11.83"},{"v":11.830799597295835,"d":"11.83"}]
[{"v":0.8800000000000007,"d":"0.880"},{"$f":"IF(Control!D$7<1,A93,A93*10)","v":{"v":0.8800000000000007,"d":"0.88"}},{"v":5.001725274010662,"d":"5.00"},{"v":7.337061557810945,"d":"7.34"},{"v":11.6967730899117,"d":"11.70"},{"v":11.6967730899117,"d":"11.70"}]
[{"v":0.8900000000000007,"d":"0.890"},{"$f":"IF(Control!D$7<1,A94,A94*10)","v":{"v":0.8900000000000007,"d":"0.89"}},{"v":4.94544229097052,"d":"4.95"},{"v":7.254655453580914,"d":"7.25"},{"v":11.565753798485295,"d":"11.57"},{"v":11.565753798485295,"d":"11.57"}]
[{"v":0.9000000000000007,"d":"0.900"},{"$f":"IF(Control!D$7<1,A95,A95*10)","v":{"v":0.9000000000000007,"d":"0.90"}},{"v":4.890410968447407,"d":"4.89"},{"v":7.174080233953686,"d":"7.17"},{"v":11.437641584328984,"d":"11.44"},{"v":11.437641584328984,"d":"11.44"}]
[{"v":0.9100000000000007,"d":"0.910"},{"$f":"IF(Control!D$7<1,A96,A96*10)","v":{"v":0.9100000000000007,"d":"0.91"}},{"v":4.836590022618819,"d":"4.84"},{"v":7.0952755480104175,"d":"7.10"},{"v":11.312340707119992,"d":"11.31"},{"v":11.312340707119992,"d":"11.31"}]
[{"v":0.9200000000000007,"d":"0.920"},{"$f":"IF(Control!D$7<1,A97,A97*10)","v":{"v":0.9200000000000007,"d":"0.92"}},{"v":4.783939965269379,"d":"4.78"},{"v":7.018183668528621,"d":"7.02"},{"v":11.189759586002957,"d":"11.19"},{"v":11.189759586002957,"d":"11.19"}]
[{"v":0.9300000000000007,"d":"0.930"},{"$f":"IF(Control!D$7<1,A98,A98*10)","v":{"v":0.9300000000000007,"d":"0.93"}},{"v":4.732423007224664,"d":"4.73"},{"v":6.942749350934201,"d":"6.94"},{"v":11.069810576097552,"d":"11.07"},{"v":11.069810576097552,"d":"11.07"}]
[{"v":0.9400000000000007,"d":"0.940"},{"$f":"IF(Control!D$7<1,A99,A99*10)","v":{"v":0.9400000000000007,"d":"0.94"}},{"v":4.6820029679502895,"d":"4.68"},{"v":6.868919701255956,"d":"6.87"},{"v":10.952409759264414,"d":"10.95"},{"v":10.952409759264414,"d":"10.95"}]
[{"v":0.9500000000000007,"d":"0.950"},{"$f":"IF(Control!D$7<1,A100,A100*10)","v":{"v":0.9500000000000007,"d":"0.95"}},{"v":4.6326451908619255,"d":"4.63"},{"v":6.796644052419289,"d":"6.80"},{"v":10.837476748079267,"d":"10.84"},{"v":10.837476748079267,"d":"10.84"}]
[{"v":0.9600000000000007,"d":"0.960"},{"$f":"IF(Control!D$7<1,A101,A101*10)","v":{"v":0.9600000000000007,"d":"0.96"}},{"v":4.584316463929713,"d":"4.58"},{"v":6.7258738482710285,"d":"6.73"},{"v":10.72493450205251,"d":"10.72"},{"v":10.72493450205251,"d":"10.72"}]
[{"v":0.9700000000000008,"d":"0.970"},{"$f":"IF(Control!D$7<1,A102,A102*10)","v":{"v":0.9700000000000008,"d":"0.97"}},{"v":4.536984945194935,"d":"4.54"},{"v":6.656562534777539,"d":"6.66"},{"v":10.614709155211015,"d":"10.61"},{"v":10.614709155211015,"d":"10.61"}]
[{"v":0.9800000000000008,"d":"0.980"},{"$f":"IF(Control!D$7<1,A103,A103*10)","v":{"v":0.9800000000000008,"d":"0.98"}},{"v":4.490620092848002,"d":"4.49"},{"v":6.588665457883709,"d":"6.59"},{"v":10.506729854230807,"d":"10.51"},{"v":10.506729854230807,"d":"10.51"}]
[{"v":0.9900000000000008,"d":"0.990"},{"$f":"IF(Control!D$7<1,A104,A104*10)","v":{"v":0.9900000000000008,"d":"0.99"}},{"v":4.4451925995451536,"d":"4.45"},{"v":6.522139767561936,"d":"6.52"},{"v":10.400928606375011,"d":"10.40"},{"v":10.400928606375011,"d":"10.40"}]
[{"v":1.0000000000000007,"d":"1.000"},{"$f":"IF(Control!D$7<1,A105,A105*10)","v":{"v":1.0000000000000007,"d":"1.00"}},{"v":4.40067433066712,"d":"4.40"},{"v":6.456944327617771,"d":"6.46"},{"v":10.297240136550936,"d":"10.30"},{"v":10.297240136550936,"d":"10.30"}]

{"sheet":"Potential Outcome Calculator","index":2,"n_rows":54,"n_cols":14,"rows_kept":54,"merged":[[1,2,1,9],[1,11,1,19],[3,11,6,19],[10,11,12,19],[14,11,17,19],[21,13,21,19],[23,13,25,19],[27,13,29,19],[31,13,31,19],[37,1,37,19],[38,1,38,19],[40,1,42,19],[44,1,44,6],[45,1,47,19],[49,1,50,19],[52,1,52,6],[53,1,58,19],[61,1,61,19]]}
["One usable password is ","AAAABABBAAA>"]
[null,null,"Outcome Calculator",{"$nulls":8},"Important information for Users"]
[]
[{"$nulls":11},"GRAPH FUNCTIONALITY: For full functionality, please Enable Content where prompted. For information, a single Macro is employed in this workbook to rescale the top Mass(lb) axis where applicable."]
[{"$nulls":3},"Height",null,1]
[]
[{"$nulls":3},"Mass",null,0.4]
[]
[]
[]
[{"$nulls":3},"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"},{"$nulls":5},"CALCULATOR ASSUMPTIONS: The Calculator assumes that full PPE is being worn and that the object is blunt (no sharp edges - outcome would be worse)."]
[]
[]
[]
[{"$nulls":11},"CALCULATOR ACCURACY: The DROPS Calculator is a guide only and is intended to give a general idea of the potential severity of a dropped object. A detailed and specific risk assessment will always deliver a more accurate calculation of potential severity."]
[]
[]
[]
[]
[{"$nulls":11},"KEY",null,"DESCRIPTION"]
[]
[{"$nulls":13},"FATALITY: Death resulting from an injury or trauma."]
[]
[{"$nulls":13},"MAJOR: A Lost Time Incident (LTI). Non-fatal traumatic injury that causes any loss of time from work beyond the day or shift it occurred. Also referred to as Day Away From Work Case (DAFWC)."]
[]
[]
[]
[{"$nulls":13},"MINOR: A Recordable Incident. A Work-related injury that does not involve death, day(s) away from work, restricted work or job transfer, and where the employee receives medical treatment beyond first aid."]
[]
[]
[]
[{"$nulls":13},"SLIGHT: A First Aid Case. Limited or no injury. Treatment may be limited to first aid."]
[]
[]
[]
[]
[]
[]
[null,"  Additional information for Users"]
[]
[null,"CALCULATING FALL ENERGY (JOULES). Mass(m) x Height(h) x Gravitational Acceleration(g = 9.8m/s). The Joule is a unit of energy equal to the work done by a force of one newton acting through one metre. In terms of dropped objects, it is recognised that any object achieving 40 Joules or more is likely to result in a recordable (MINOR) incident or worse on impact with a human body. For example, 200g Machine Bolt falling 27m = 53Joules (0.2[m] x 27[h] x 9.8[g] = 53Joules). Or Pounds x Feet x 32.17ft/sec divided by 23.73ft/pdl = Joule."]
[]
[]
[]
[null,"PURPOSE OF THE CALCULATOR"]
[null,"This Calculator provides a common benchmark in the classification of the potential consequences of a dropped object. One of a number of similar tools, the DROPS Calculator is endorsed by the DROPS Workgroup and recognised by HSE Organisations. While other ‘calculators’ exist, they all follow the same principle – plotting the mass of a dropped object against the distance it falls to determine its possible consequences."]
[]
[]
[]
[null,"It is designed to be employed during task planning / risk assessment to determine potential severity rating. It is also used in reporting processes to determine potential outcome of an actual dropped object incident. It may also be considered during design and manufacture to address requirements for positioning, fixtures and fittings for items to be secured at height."]
[]
[]
[null,"CONSIDERATIONS WHEN USING THS CALCULATOR"]
[null,"• With light objects (<0.1 kg) a key influencing factor is the effect of an object punching the skin and damaging tissue/organic functions. \n• The calculator assumes a blunt object so is not compatible with broken glass, metal shards etc.\n• The wearing of standard PPE, eg hard hat, safety boots and eye protection, is assumed in the calculator.\n• Do not subtract the height of an individual, measure fall distance to solid deck / ground level.\n• DROPS Calculator and other similar tools are guides only providing cursory indication of possible outcome – they are not an accurate prediction.\n• In reality, even a small object falling from height can be lethal."]