{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Calculations","Calculations 2.0","Calculations 3.0","Instructions","Calculations (Final)"],"not_rendered":{"charts":0,"images":0,"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":"Calculations","index":0,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":true,"merged":[[16,17,16,18],[0,0,2,8],[0,10,2,18],[3,6,3,8],[8,10,8,12],[10,10,10,14],[10,16,10,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[14,17,14,18],[15,17,15,18],[31,7,31,8],[19,10,19,12],[22,10,24,18],[23,0,23,2],[25,0,25,4],[25,6,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[30,10,30,12],[52,10,52,12],[32,10,32,14],[32,16,32,18],[33,17,33,18],[34,0,34,2],[34,17,34,18],[35,17,35,18],[36,17,36,18],[37,17,37,18],[38,17,38,18],[41,10,41,12],[44,10,46,18],[59,17,59,18],[60,17,60,18],[63,10,63,12],[54,10,54,14],[54,16,54,18],[55,17,55,18],[56,17,56,18],[57,17,57,18],[58,17,58,18]]}
["Multi-Digit Calculation",null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2015-2016)"]
[]
[]
["Digit","Degree","PPI Rating","Total",null,null,"Payable Degree Range",null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
["Thumb",12,0,{"$f":"TRUNC((B5*C5),4)","v":0},null,null,"Range","Year","Rate",null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
["Index",8,0,{"$f":"TRUNC((B6*C6),4)","v":0},null,null,"1* - 10*","Current",1750,null,{"$f":"IF($D$16<=10,($D$16*I11),(10*I11))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I12),\"0\"),(25*I12))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I13),\"0\"),(15*I13))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I14),\"0\")","v":"0"}]
["Middle",7,0,0,null,null,"11* - 35*","Current",1952]
["Ring",6,0,{"$f":"ROUND((B8*C8),1)","v":0},null,null,"36* - 50*","Current",3186]
["Small",4,0,{"$f":"TRUNC((B9*C9),4)","v":0},null,null,"51* - 100*","Current",4060,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K6:N6)","v":0}]
["Total","-","-",{"$f":"SUM(D5:D9)","v":0}]
[null,null,null,null,null,null,"1* - 10*","2015 - 2016",1633,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,"Divide by Hand =",{"$f":"ROUND((D10/40),4)","v":0},null,null,"11* - 35*","2015 - 2016",1835,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
[null,null,null,null,null,null,"36* - 50*","2015 - 2016",3024,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L13*M13),4)","v":0},{"$f":"IF(N13<=10,(N13*I11),((10*I11)+(2*I12)))","v":0},null,"Thumb",{"$f":"O13*2","v":0}]
[null,null,"Multiply by Total =",{"$f":"ROUND((D12*D10),4)","v":0},null,null,"51* - 100*","2015 - 2016",3873,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L14*M14),4)","v":0},{"$f":"N14*I11","v":0},null,"Index",{"$f":"O14*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N15*I11","v":0},null,"Middle",0]
[null,null,"Add to Total =",{"$f":"ROUND((D14+D10),4)","v":0},null,null,"1* - 10*","2014 - 2015",1517,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L16*M16),1)","v":0},{"$f":"N16*I11","v":0},null,"Ring",0]
[null,null,null,null,null,null,"11* - 35*","2014 - 2015",1717,null,"Small",4,{"$f":"$C$32","v":0},0,{"$f":"N17*I11","v":0},null,"Small",0]
[null,null,null,null,null,null,"36* - 50*","2014 - 2015",2862,null,"Total","-","-","-",{"$f":"SUM(O13:O17)","v":0}]
["10 or Less","Between 10 - 35","Between 35 - 50","More than 50",null,null,"51* - 100*","2014 - 2015",3687]
[{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"},null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N9+O18)","v":0}]
[{"$f":"IF($D$16<=10,($D$16*I6),(10*I6))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I7),\"0\"),(25*I7))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I8),\"0\"),(15*I8))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I9),\"0\")","v":"0"},null,null,"1* - 10*","2009 - 2014",1400]
[null,null,null,null,null,null,"11* - 35*","2009 - 2014",1600]
[null,null,null,null,null,null,"36* - 50*","2009 - 2014",2700,null,"Multi-Digit Calculation (2014-2015)"]
["Multi-Digit Total =",null,null,{"$f":"SUM(A21:D21)","v":0},null,null,"51* - 100*","2009 - 2014",3500]
[]
["Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value",null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
["Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled",null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
["Thumb",12,0,{"$f":"TRUNC((B28*C28),4)","v":0},{"$f":"IF(D28<=10,(D28*I6),((10*I6)+(2*I7)))","v":0},null,"Thumb",{"$f":"E28*2","v":0},null,null,{"$f":"IF($D$16<=10,($D$16*I16),(10*I16))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I17),\"0\"),(25*I17))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I18),\"0\"),(15*I18))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I19),\"0\")","v":"0"}]
["Index",8,0,{"$f":"TRUNC((B29*C29),4)","v":0},{"$f":"D29*I6","v":0},null,"Index",{"$f":"E29*2","v":0}]
["Middle",7,0,0,{"$f":"D30*I6","v":0},null,"Middle",0]
["Ring",6,0,{"$f":"ROUND((B31*C31),1)","v":0},{"$f":"D31*I6","v":0},null,"Ring",0,null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K28:N28)","v":0}]
["Small",4,0,0,{"$f":"D32*I6","v":0},null,"Small",0]
["Total","-","-","-",{"$f":"SUM(E28:E32)","v":0},null,null,null,null,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
["Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(D24+E33)","v":0},null,null,null,null,null,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L35*M35),4)","v":0},{"$f":"IF(N35<=10,(N35*I16),((10*I16)+(2*I17)))","v":0},null,"Thumb",{"$f":"O35*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L36*M36),4)","v":0},{"$f":"N36*I16","v":0},null,"Index",{"$f":"O36*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N37*I16","v":0},null,"Middle",0]
[null,null,null,null,null,null,null,null,null,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L38*M38),1)","v":0},{"$f":"N38*I16","v":0},null,"Ring",0]
[null,null,null,null,null,null,null,null,null,null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L39*M39),4)","v":0},{"$f":"N39*I16","v":0},null,"Small",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O35:O39)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N31+O40)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2009-2014)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16<=10,($D$16*I21),(10*I21))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I22),\"0\"),(25*I22))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I23),\"0\"),(15*I23))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I24),\"0\")","v":"0"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K50:N50)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
[null,null,null,null,null,null,null,null,null,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L57*M57),4)","v":0},{"$f":"IF(N57<=10,(N57*I21),((10*I21)+(2*I22)))","v":0},null,"Thumb",{"$f":"O57*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L58*M58),4)","v":0},{"$f":"N58*I21","v":0},null,"Index",{"$f":"O58*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N59*I21","v":0},null,"Middle",0]
[null,null,null,null,null,null,null,null,null,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L60*M60),1)","v":0},{"$f":"N60*I21","v":0},null,"Ring",0]
[null,null,null,null,null,null,null,null,null,null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L61*M61),4)","v":0},{"$f":"N61*I21","v":0},null,"Small",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O57:O61)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N53+O62)","v":0}]

{"sheet":"Calculations 2.0","index":1,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":true,"merged":[[0,0,2,8],[0,10,2,18],[3,6,3,8],[8,10,8,12],[10,10,10,14],[10,16,10,18],[25,0,25,4],[25,6,25,8],[25,17,25,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[19,10,19,12],[23,0,23,2],[23,10,23,14],[23,16,23,18],[24,17,24,18],[26,7,26,8],[26,17,26,18],[27,7,27,8],[27,17,27,18],[28,7,28,8],[28,17,28,18],[41,10,41,12],[29,7,29,8],[29,17,29,18],[30,7,30,8],[30,17,30,18],[31,7,31,8],[33,10,35,18],[34,0,34,2],[39,0,39,4],[39,6,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[43,10,43,14],[43,16,43,18],[44,7,44,8],[44,17,44,18],[58,17,58,18],[45,7,45,8],[45,17,45,18],[46,7,46,8],[46,17,46,18],[47,17,47,18],[48,17,48,18],[49,17,49,18],[52,10,52,12],[56,10,56,14],[56,16,56,18],[57,17,57,18],[79,17,79,18],[59,17,59,18],[60,17,60,18],[61,17,61,18],[62,17,62,18],[63,17,63,18],[66,10,68,18],[74,10,74,12],[76,10,76,14],[76,16,76,18],[77,17,77,18],[78,17,78,18],[80,17,80,18],[81,17,81,18],[82,17,82,18],[85,10,85,12],[89,10,89,14],[89,16,89,18],[96,17,96,18],[90,17,90,18],[91,17,91,18],[92,17,92,18],[93,17,93,18],[94,17,94,18],[95,17,95,18]]}
["Multi-Digit Calculation",null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2015-2016)"]
[]
[]
["Digit","Degree","PPI Rating","Total",null,null,"Payable Degree Range",null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
["Thumb",12,0,{"$f":"TRUNC((B5*C5),4)","v":0},null,null,"Range","Year","Rate",null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
["Index",8,0,{"$f":"TRUNC((B6*C6),4)","v":0},null,null,"1* - 10*","Current",1750,null,{"$f":"IF($D$16<=10,($D$16*I11),(10*I11))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I12),\"0\"),(25*I12))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I13),\"0\"),(15*I13))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I14),\"0\")","v":"0"}]
["Middle",7,0,0,null,null,"11* - 35*","Current",1952]
["Ring",6,0,{"$f":"ROUND((B8*C8),1)","v":0},null,null,"36* - 50*","Current",3186]
["Small",4,0,{"$f":"TRUNC((B9*C9),4)","v":0},null,null,"51* - 100*","Current",4060,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K6:N6)","v":0}]
["Total","-","-",{"$f":"SUM(D5:D9)","v":0}]
[null,null,null,null,null,null,"1* - 10*","2015 - 2016",1633,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,"Divide by Hand =",{"$f":"ROUND((D10/40),4)","v":0},null,null,"11* - 35*","2015 - 2016",1835,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
[null,null,null,null,null,null,"36* - 50*","2015 - 2016",3024,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L13*M13),4)","v":0},{"$f":"IF(N13<=10,(N13*I11),((10*I11)+(2*I12)))","v":0},null,"Thumb",{"$f":"O13*2","v":0}]
[null,null,"Multiply by Total =",{"$f":"ROUND((D12*D10),4)","v":0},null,null,"51* - 100*","2015 - 2016",3873,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L14*M14),4)","v":0},{"$f":"N14*I11","v":0},null,"Index",{"$f":"O14*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N15*I11","v":0},null,"Middle",0]
[null,null,"Add to Total =",{"$f":"IF((D14+D10)<=40,(ROUND((D14+D10),4)),\"INVALID\")","v":0},null,null,"1* - 10*","2014 - 2015",1517,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L16*M16),1)","v":0},{"$f":"N16*I11","v":0},null,"Ring",0]
[null,null,null,null,null,null,"11* - 35*","2014 - 2015",1717,null,"Small",4,{"$f":"$C$32","v":0},0,{"$f":"N17*I11","v":0},null,"Small",0]
[null,null,null,null,null,null,"36* - 50*","2014 - 2015",2862,null,"Total","-","-","-",{"$f":"SUM(O13:O17)","v":0}]
["10 or Less","Between 10 - 35","Between 35 - 50","More than 50",null,null,"51* - 100*","2014 - 2015",3687]
[{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"},null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N9+O18)","v":0}]
[{"$f":"IF($D$16<=10,($D$16*I6),(10*I6))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I7),\"0\"),(25*I7))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I8),\"0\"),(15*I8))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I9),\"0\")","v":"0"},null,null,"1* - 10*","2009 - 2014",1400]
[null,null,null,null,null,null,"11* - 35*","2009 - 2014",1600]
[null,null,null,null,null,null,"36* - 50*","2009 - 2014",2700]
["Multi-Digit Total =",null,null,{"$f":"SUM(A21:D21)","v":0},null,null,"51* - 100*","2009 - 2014",3500,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
["Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value",null,null,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L26*M26","v":0},{"$f":"IF(N26<=10,(N26*I11),((10*I11)+(2*I12)))","v":0},null,"Great",{"$f":"O26*2","v":0}]
["Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled",null,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L27*M27","v":0},{"$f":"N27*I11","v":0},null,"2nd",{"$f":"O27*2","v":0}]
["Thumb",12,0,{"$f":"TRUNC((B28*C28),4)","v":0},{"$f":"IF(D28<=10,(D28*I6),((10*I6)+(2*I7)))","v":0},null,"Thumb",{"$f":"E28*2","v":0},null,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N28*I11","v":0},null,"3rd",0]
["Index",8,0,{"$f":"TRUNC((B29*C29),4)","v":0},{"$f":"D29*I6","v":0},null,"Index",{"$f":"E29*2","v":0},null,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N29*I11","v":0},null,"4th",0]
["Middle",7,0,0,{"$f":"D30*I6","v":0},null,"Middle",0,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N30*I11","v":0},null,"5th",0]
["Ring",6,0,{"$f":"ROUND((B31*C31),1)","v":0},{"$f":"D31*I6","v":0},null,"Ring",0,null,null,"Total","-","-","-",{"$f":"SUM(O26:O30)","v":0},null,"Total",{"$f":"SUM(R26:S30)","v":0}]
["Small",4,0,0,{"$f":"D32*I6","v":0},null,"Small",0]
["Total","-","-","-",{"$f":"SUM(E28:E32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2014-2015)"]
["Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(D24+E33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16<=10,($D$16*I16),(10*I16))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I17),\"0\"),(25*I17))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I18),\"0\"),(15*I18))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I19),\"0\")","v":"0"}]
["Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
["Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
["Great",12,0,{"$f":"B42*C42","v":0},{"$f":"IF(D42<=10,(D42*I6),((10*I6)+(2*I7)))","v":0},null,"Great",{"$f":"E42*2","v":0},null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K39:N39)","v":0}]
["2nd",6,0,{"$f":"B43*C43","v":0},{"$f":"D43*I6","v":0},null,"2nd",{"$f":"E43*2","v":0}]
["3rd",4,0,0,{"$f":"D44*I6","v":0},null,"3rd",0,null,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
["4th",3,0,0,{"$f":"D45*I6","v":0},null,"4th",0,null,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
["5th",2,0,0,{"$f":"D46*I6","v":0},null,"5th",0,null,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L46*M46),4)","v":0},{"$f":"IF(N46<=10,(N46*I16),((10*I16)+(2*I17)))","v":0},null,"Thumb",{"$f":"O46*2","v":0}]
["Total","-","-","-",{"$f":"SUM(E42:E46)","v":0},null,"Total",{"$f":"SUM(H42:I46)","v":0},null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L47*M47),4)","v":0},{"$f":"N47*I16","v":0},null,"Index",{"$f":"O47*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N48*I16","v":0},null,"Middle",0]
[null,null,null,null,null,null,null,null,null,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L49*M49),1)","v":0},{"$f":"N49*I16","v":0},null,"Ring",0]
[null,null,null,null,null,null,null,null,null,null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L50*M50),4)","v":0},{"$f":"N50*I16","v":0},null,"Small",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O46:O50)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N42+O51)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
[null,null,null,null,null,null,null,null,null,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L59*M59","v":0},{"$f":"IF(N59<=10,(N59*I16),((10*I16)+(2*I17)))","v":0},null,"Great",{"$f":"O59*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L60*M60","v":0},{"$f":"N60*I16","v":0},null,"2nd",{"$f":"O60*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N61*I16","v":0},null,"3rd",0]
[null,null,null,null,null,null,null,null,null,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N62*I16","v":0},null,"4th",0]
[null,null,null,null,null,null,null,null,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N63*I16","v":0},null,"5th",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O59:O63)","v":0},null,"Total",{"$f":"SUM(R59:S63)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2009-2014)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16<=10,($D$16*I21),(10*I21))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I22),\"0\"),(25*I22))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I23),\"0\"),(15*I23))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I24),\"0\")","v":"0"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K72:N72)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
[null,null,null,null,null,null,null,null,null,null,"Thumb",12,0,{"$f":"TRUNC((L79*M79),4)","v":0},{"$f":"IF(N79<=10,(N79*I21),((10*I21)+(2*I22)))","v":0},null,"Thumb",{"$f":"O79*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L80*M80),4)","v":0},{"$f":"N80*I21","v":0},null,"Index",{"$f":"O80*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N81*I21","v":0},null,"Middle",0]
[null,null,null,null,null,null,null,null,null,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L82*M82),1)","v":0},{"$f":"N82*I21","v":0},null,"Ring",0]
[null,null,null,null,null,null,null,null,null,null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L83*M83),4)","v":0},{"$f":"N83*I21","v":0},null,"Small",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O79:O83)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N75+O84)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
[null,null,null,null,null,null,null,null,null,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L92*M92","v":0},{"$f":"IF(N92<=10,(N92*I21),((10*I21)+(2*I22)))","v":0},null,"Great",{"$f":"O92*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L93*M93","v":0},{"$f":"N93*I21","v":0},null,"2nd",{"$f":"O93*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N94*I21","v":0},null,"3rd",0]
[null,null,null,null,null,null,null,null,null,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N95*I21","v":0},null,"4th",0]
[null,null,null,null,null,null,null,null,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N96*I21","v":0},null,"5th",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O92:O96)","v":0},null,"Total",{"$f":"SUM(R92:S96)","v":0}]

{"sheet":"Calculations 3.0","index":2,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":true,"merged":[[96,17,96,18],[81,17,81,18],[82,17,82,18],[85,10,85,12],[89,10,89,14],[89,16,89,18],[90,17,90,18],[91,17,91,18],[92,17,92,18],[93,17,93,18],[94,17,94,18],[95,17,95,18],[76,10,76,14],[76,16,76,18],[77,17,77,18],[78,17,78,18],[79,0,79,4],[79,6,80,8],[79,17,79,18],[80,0,80,4],[80,17,80,18],[74,10,74,12],[63,0,63,4],[63,6,63,8],[63,17,63,18],[64,0,64,4],[66,10,68,18],[67,0,67,4],[67,6,67,8],[70,0,70,4],[70,6,70,8],[73,0,73,4],[73,6,74,8],[74,0,74,4],[62,0,62,4],[62,6,62,8],[62,17,62,18],[49,0,51,8],[49,17,49,18],[52,0,52,4],[52,6,52,8],[52,10,52,12],[56,10,56,14],[56,16,56,18],[57,17,57,18],[58,17,58,18],[59,17,59,18],[60,17,60,18],[61,17,61,18],[48,17,48,18],[42,7,42,8],[43,7,43,8],[43,10,43,14],[43,16,43,18],[44,7,44,8],[44,17,44,18],[45,7,45,8],[45,17,45,18],[46,7,46,8],[46,17,46,18],[47,17,47,18],[34,0,34,2],[39,0,39,4],[39,6,39,8],[40,7,40,8],[41,7,41,8],[41,10,41,12],[29,7,29,8],[29,17,29,18],[30,7,30,8],[30,17,30,18],[31,7,31,8],[33,10,35,18],[26,7,26,8],[26,17,26,18],[27,7,27,8],[27,17,27,18],[28,7,28,8],[28,17,28,18],[25,0,25,4],[25,6,25,8],[25,17,25,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[19,10,19,12],[23,0,23,2],[23,10,23,14],[23,16,23,18],[24,17,24,18],[0,0,2,8],[0,10,2,18],[3,6,3,8],[8,10,8,12],[10,10,10,14],[10,16,10,18]]}
["Multi-Digit Calculation",null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2015-2016)"]
[]
[]
["Digit","Degree","PPI Rating","Total",null,null,"Payable Degree Range",null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
["Thumb",12,0,{"$f":"TRUNC((B5*C5),4)","v":0},null,null,"Range","Year","Rate",null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
["Index",8,0,{"$f":"TRUNC((B6*C6),4)","v":0},null,null,"1* - 10*","Current",1750,null,{"$f":"IF($D$16<=10,($D$16*I11),(10*I11))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I12),\"0\"),(25*I12))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I13),\"0\"),(15*I13))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I14),\"0\")","v":"0"}]
["Middle",7,0,0,null,null,"11* - 35*","Current",1952]
["Ring",6,0,{"$f":"ROUND((B8*C8),1)","v":0},null,null,"36* - 50*","Current",3186]
["Small",4,0,{"$f":"TRUNC((B9*C9),4)","v":0},null,null,"51* - 100*","Current",4060,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K6:N6)","v":0}]
["Total","-","-",{"$f":"SUM(D5:D9)","v":0}]
[null,null,null,null,null,null,"1* - 10*","2015 - 2016",1633,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,"Divide by Hand =",{"$f":"ROUND((D10/40),4)","v":0},null,null,"11* - 35*","2015 - 2016",1835,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
[null,null,null,null,null,null,"36* - 50*","2015 - 2016",3024,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L13*M13),4)","v":0},{"$f":"IF(N13<=10,(N13*I11),((10*I11)+(2*I12)))","v":0},null,"Thumb",{"$f":"O13*2","v":0}]
[null,null,"Multiply by Total =",{"$f":"ROUND((D12*D10),4)","v":0},null,null,"51* - 100*","2015 - 2016",3873,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L14*M14),4)","v":0},{"$f":"N14*I11","v":0},null,"Index",{"$f":"O14*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N15*I11","v":0},null,"Middle",0]
[null,null,"Add to Total =",{"$f":"IF((D14+D10)<=40,(ROUND((D14+D10),4)),\"INVALID\")","v":0},null,null,"1* - 10*","2014 - 2015",1517,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L16*M16),1)","v":0},{"$f":"N16*I11","v":0},null,"Ring",0]
[null,null,null,null,null,null,"11* - 35*","2014 - 2015",1717,null,"Small",4,{"$f":"$C$32","v":0},0,{"$f":"N17*I11","v":0},null,"Small",0]
[null,null,null,null,null,null,"36* - 50*","2014 - 2015",2862,null,"Total","-","-","-",{"$f":"SUM(O13:O17)","v":0}]
["10 or Less","Between 10 - 35","Between 35 - 50","More than 50",null,null,"51* - 100*","2014 - 2015",3687]
[{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"},null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N9+O18)","v":0}]
[{"$f":"IF($D$16<=10,($D$16*I6),(10*I6))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I7),\"0\"),(25*I7))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I8),\"0\"),(15*I8))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I9),\"0\")","v":"0"},null,null,"1* - 10*","2009 - 2014",1400]
[null,null,null,null,null,null,"11* - 35*","2009 - 2014",1600]
[null,null,null,null,null,null,"36* - 50*","2009 - 2014",2700]
["Multi-Digit Total =",null,null,{"$f":"SUM(A21:D21)","v":0},null,null,"51* - 100*","2009 - 2014",3500,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
["Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value",null,null,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L26*M26","v":0},{"$f":"IF(N26<=10,(N26*I11),((10*I11)+(2*I12)))","v":0},null,"Great",{"$f":"O26*2","v":0}]
["Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled",null,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L27*M27","v":0},{"$f":"N27*I11","v":0},null,"2nd",{"$f":"O27*2","v":0}]
["Thumb",12,0,{"$f":"TRUNC((B28*C28),4)","v":0},{"$f":"IF(D28<=10,(D28*I6),((10*I6)+(2*I7)))","v":0},null,"Thumb",{"$f":"E28*2","v":0},null,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N28*I11","v":0},null,"3rd",0]
["Index",8,0,{"$f":"TRUNC((B29*C29),4)","v":0},{"$f":"D29*I6","v":0},null,"Index",{"$f":"E29*2","v":0},null,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N29*I11","v":0},null,"4th",0]
["Middle",7,0,0,{"$f":"D30*I6","v":0},null,"Middle",0,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N30*I11","v":0},null,"5th",0]
["Ring",6,0,{"$f":"ROUND((B31*C31),1)","v":0},{"$f":"D31*I6","v":0},null,"Ring",0,null,null,"Total","-","-","-",{"$f":"SUM(O26:O30)","v":0},null,"Total",{"$f":"SUM(R26:S30)","v":0}]
["Small",4,0,0,{"$f":"D32*I6","v":0},null,"Small",0]
["Total","-","-","-",{"$f":"SUM(E28:E32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Multi-Digit Calculation (2014-2015)"]
["Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(D24+E33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16<=10,($D$16*I16),(10*I16))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I17),\"0\"),(25*I17))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I18),\"0\"),(15*I18))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I19),\"0\")","v":"0"}]
["Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
["Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
["Great",12,0,{"$f":"B42*C42","v":0},{"$f":"IF(D42<=10,(D42*I6),((10*I6)+(2*I7)))","v":0},null,"Great",{"$f":"E42*2","v":0},null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K39:N39)","v":0}]
["2nd",6,0,{"$f":"B43*C43","v":0},{"$f":"D43*I6","v":0},null,"2nd",{"$f":"E43*2","v":0}]
["3rd",4,0,0,{"$f":"D44*I6","v":0},null,"3rd",0,null,null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
["4th",3,0,0,{"$f":"D45*I6","v":0},null,"4th",0,null,null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
["5th",2,0,0,{"$f":"D46*I6","v":0},null,"5th",0,null,null,"Thumb",12,{"$f":"$C$28","v":0},{"$f":"TRUNC((L46*M46),4)","v":0},{"$f":"IF(N46<=10,(N46*I16),((10*I16)+(2*I17)))","v":0},null,"Thumb",{"$f":"O46*2","v":0}]
["Total","-","-","-",{"$f":"SUM(E42:E46)","v":0},null,"Total",{"$f":"SUM(H42:I46)","v":0},null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L47*M47),4)","v":0},{"$f":"N47*I16","v":0},null,"Index",{"$f":"O47*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N48*I16","v":0},null,"Middle",0]
[null,null,null,null,null,null,null,null,null,null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L49*M49),1)","v":0},{"$f":"N49*I16","v":0},null,"Ring",0]
["Other PPI Calculations *Board Use Only*",null,null,null,null,null,null,null,null,null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L50*M50),4)","v":0},{"$f":"N50*I16","v":0},null,"Small",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O46:O50)","v":0}]
[]
["Whole Person Injuries",null,null,null,null,null,"Other Year Totals",null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N42+O51)","v":0}]
["Body Part","Degrees","PPI Rating","Total Value","Total",null,"2015-2016","2014-2015","2009-2014"]
["Head",100,0,{"$f":"B55*C55","v":0},{"$f":"IF(D55<=10,(D55*$I$6),IF(D55<=35,((10*$I$6)+((D55-10)*$I$7)),IF(D55<=50,((10*$I$6)+(25*$I$7)+((D55-35)*$I$8)),IF(D55>50,((10*$I$6)+(25*$I$7)+(15*$I$8)+((D55-50)*$I$9)),\"ERROR\"))))","v":0},null,{"$f":"IF(D55<=10,(D55*$I$11),IF(D55<=35,((10*$I$11)+((D55-10)*$I$12)),IF(D55<=50,((10*$I$11)+(25*$I$12)+((D55-35)*$I$13)),IF(D55>50,((10*$I$11)+(25*$I$12)+(15*$I$13)+((D55-50)*$I$14)),\"ERROR\"))))","v":0},{"$f":"IF(D55<=10,(D55*$I$16),IF(D55<=35,((10*$I$16)+((D55-10)*$I$17)),IF(D55<=50,((10*$I$16)+(25*$I$17)+((D55-35)*$I$18)),IF(D55>50,((10*$I$16)+(25*$I$17)+(15*$I$18)+((D55-50)*$I$19)),\"ERROR\"))))","v":0},{"$f":"IF(D55<=10,(D55*$I$21),IF(D55<=35,((10*$I$21)+((D55-10)*$I$22)),IF(D55<=50,((10*$I$21)+(25*$I$22)+((D55-35)*$I$23)),IF(D55>50,((10*$I$21)+(25*$I$22)+(15*$I$23)+((D55-50)*$I$24)),\"ERROR\"))))","v":0}]
["Neck",100,0,{"$f":"B56*C56","v":0},{"$f":"IF(D56<=10,(D56*$I$6),IF(D56<=35,((10*$I$6)+((D56-10)*$I$7)),IF(D56<=50,((10*$I$6)+(25*$I$7)+((D56-35)*$I$8)),IF(D56>50,((10*$I$6)+(25*$I$7)+(15*$I$8)+((D56-50)*$I$9)),\"ERROR\"))))","v":0},null,{"$f":"IF(D56<=10,(D56*$I$11),IF(D56<=35,((10*$I$11)+((D56-10)*$I$12)),IF(D56<=50,((10*$I$11)+(25*$I$12)+((D56-35)*$I$13)),IF(D56>50,((10*$I$11)+(25*$I$12)+(15*$I$13)+((D56-50)*$I$14)),\"ERROR\"))))","v":0},{"$f":"IF(D56<=10,(D56*$I$16),IF(D56<=35,((10*$I$16)+((D56-10)*$I$17)),IF(D56<=50,((10*$I$16)+(25*$I$17)+((D56-35)*$I$18)),IF(D56>50,((10*$I$16)+(25*$I$17)+(15*$I$18)+((D56-50)*$I$19)),\"ERROR\"))))","v":0},{"$f":"IF(D56<=10,(D56*$I$21),IF(D56<=35,((10*$I$21)+((D56-10)*$I$22)),IF(D56<=50,((10*$I$21)+(25*$I$22)+((D56-35)*$I$23)),IF(D56>50,((10*$I$21)+(25*$I$22)+(15*$I$23)+((D56-50)*$I$24)),\"ERROR\"))))","v":0}]
["Shoulder",100,0,0,0,null,0,0,0,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
["Back",100,0,0,0,null,0,0,0,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
["Hip",100,0,0,0,null,0,0,0,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L59*M59","v":0},{"$f":"IF(N59<=10,(N59*I16),((10*I16)+(2*I17)))","v":0},null,"Great",{"$f":"O59*2","v":0}]
["Hernia",100,0,0,0,null,0,0,0,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L60*M60","v":0},{"$f":"N60*I16","v":0},null,"2nd",{"$f":"O60*2","v":0}]
["Bilateral",100,0,0,0,null,0,0,0,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N61*I16","v":0},null,"3rd",0]
["Any Combo",100,0,0,0,null,0,0,0,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N62*I16","v":0},null,"4th",0]
[null,null,null,null,null,null,null,null,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N63*I16","v":0},null,"5th",0]
["Eyes/Ears/Testicles",null,null,null,null,null,"Other Year Totals",null,null,null,"Total","-","-","-",{"$f":"SUM(O59:O63)","v":0},null,"Total",{"$f":"SUM(R59:S63)","v":0}]
["Complete Loss of Vision",null,null,null,null,null,"2015-2016","2014-2015","2009-2014"]
["One Eye",35,0,{"$f":"B66*C66","v":0},{"$f":"IF(D66<=10,(D66*$I$6),IF(D66<=35,((10*$I$6)+((D66-10)*$I$7)),\"ERROR\"))","v":0},null,{"$f":"IF(D66<=10,(D66*$I$11),IF(D66<=35,((10*$I$11)+((D66-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D66<=10,(D66*$I$16),IF(D66<=35,((10*$I$16)+((D66-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D66<=10,(D66*$I$21),IF(D66<=35,((10*$I$21)+((D66-10)*$I$22)),\"ERROR\"))","v":0}]
["Both Eyes",100,0,{"$f":"B67*C67","v":0},{"$f":"IF(D67<=10,(D67*$I$6),IF(D67<=35,((10*$I$6)+((D67-10)*$I$7)),IF(D67<=50,((10*$I$6)+(25*$I$7)+((D67-35)*$I$8)),IF(D67>50,((10*$I$6)+(25*$I$7)+(15*$I$8)+((D67-50)*$I$9)),\"ERROR\"))))","v":0},null,{"$f":"IF(D67<=10,(D67*$I$11),IF(D67<=35,((10*$I$11)+((D67-10)*$I$12)),IF(D67<=50,((10*$I$11)+(25*$I$12)+((D67-35)*$I$13)),IF(D67>50,((10*$I$11)+(25*$I$12)+(15*$I$13)+((D67-50)*$I$14)),\"ERROR\"))))","v":0},{"$f":"IF(D67<=10,(D67*$I$16),IF(D67<=35,((10*$I$16)+((D67-10)*$I$17)),IF(D67<=50,((10*$I$16)+(25*$I$17)+((D67-35)*$I$18)),IF(D67>50,((10*$I$16)+(25*$I$17)+(15*$I$18)+((D67-50)*$I$19)),\"ERROR\"))))","v":0},{"$f":"IF(D67<=10,(D67*$I$21),IF(D67<=35,((10*$I$21)+((D67-10)*$I$22)),IF(D67<=50,((10*$I$21)+(25*$I$22)+((D67-35)*$I$23)),IF(D67>50,((10*$I$21)+(25*$I$22)+(15*$I$23)+((D67-50)*$I$24)),\"ERROR\"))))","v":0},null,"Multi-Digit Calculation (2009-2014)"]
["Complete Loss of Hearing"]
["One Ear",15,0,{"$f":"B69*C69","v":0},{"$f":"IF(D69<=10,(D69*$I$6),IF(D69<=15,((10*$I$6)+((D69-10)*$I$7)),\"ERROR\"))","v":0},null,{"$f":"IF(D69<=10,(D69*$I$11),IF(D69<=15,((10*$I$11)+((D69-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D69<=10,(D69*$I$16),IF(D69<=15,((10*$I$16)+((D69-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D69<=10,(D69*$I$21),IF(D69<=15,((10*$I$21)+((D69-10)*$I$22)),\"ERROR\"))","v":0}]
["Both Ears",40,0,{"$f":"B70*C70","v":0},{"$f":"IF(D70<=10,(D70*$I$6),IF(D70<=35,((10*$I$6)+((D70-10)*$I$7)),IF(D70<=40,((10*$I$6)+(25*$I$7)+((D70-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D70<=10,(D70*$I$11),IF(D70<=35,((10*$I$11)+((D70-10)*$I$12)),IF(D70<=40,((10*$I$11)+(25*$I$12)+((D70-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D70<=10,(D70*$I$16),IF(D70<=35,((10*$I$16)+((D70-10)*$I$17)),IF(D70<=40,((10*$I$16)+(25*$I$17)+((D70-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D70<=10,(D70*$I$21),IF(D70<=35,((10*$I$21)+((D70-10)*$I$22)),IF(D70<=40,((10*$I$21)+(25*$I$22)+((D70-35)*$I$23)),\"ERROR\")))","v":0},null,"10 or Less","Between 10 - 35","Between 35 - 50","More than 50"]
["Loss of Testicle(s)",null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>10,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>35,\"YES\",\"NO\")","v":"NO"},{"$f":"IF($D$16>50,\"YES\",\"NO\")","v":"NO"}]
["One",10,0,{"$f":"B72*C72","v":0},{"$f":"IF(D72<=10,(D72*$I$6),\"ERROR\")","v":0},null,{"$f":"IF(D72<=10,(D72*$I$11),\"ERROR\")","v":0},{"$f":"IF(D72<=10,(D72*$I$16),\"ERROR\")","v":0},{"$f":"IF(D72<=10,(D72*$I$21),\"ERROR\")","v":0},null,{"$f":"IF($D$16<=10,($D$16*I21),(10*I21))","v":0},{"$f":"IF($D$16<=35,IF($D$16>10,(($D$16-10)*I22),\"0\"),(25*I22))","v":"0"},{"$f":"IF($D$16<=50,IF($D$16>35,(($D$16-35)*I23),\"0\"),(15*I23))","v":"0"},{"$f":"IF($D$16>50,(($D$16-50)*I24),\"0\")","v":"0"}]
["Both",30,0,{"$f":"B73*C73","v":0},{"$f":"IF(D73<=10,(D73*$I$6),IF(D73<=30,((10*$I$6)+((D73-10)*$I$7)),\"ERROR\"))","v":0},null,{"$f":"IF(D73<=10,(D73*$I$11),IF(D73<=30,((10*$I$11)+((D73-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D73<=10,(D73*$I$16),IF(D73<=30,((10*$I$16)+((D73-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D73<=10,(D73*$I$21),IF(D73<=30,((10*$I$21)+((D73-10)*$I$22)),\"ERROR\"))","v":0}]
[]
["Upper Extremity Injuries (Below Elbow vs. Elbow and Above)",null,null,null,null,null,null,null,null,null,"Multi-Digit Total =",null,null,{"$f":"SUM(K72:N72)","v":0}]
["Hand",40,0,{"$f":"B76*C76","v":0},{"$f":"IF(D76<=10,(D76*$I$6),IF(D76<=35,((10*$I$6)+((D76-10)*$I$7)),IF(D76<=40,((10*$I$6)+(25*$I$7)+((D76-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D76<=10,(D76*$I$11),IF(D76<=35,((10*$I$11)+((D76-10)*$I$12)),IF(D76<=40,((10*$I$11)+(25*$I$12)+((D76-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D76<=10,(D76*$I$16),IF(D76<=35,((10*$I$16)+((D76-10)*$I$17)),IF(D76<=40,((10*$I$16)+(25*$I$17)+((D76-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D76<=10,(D76*$I$21),IF(D76<=35,((10*$I$21)+((D76-10)*$I$22)),IF(D76<=40,((10*$I$21)+(25*$I$22)+((D76-35)*$I$23)),\"ERROR\")))","v":0}]
["Wrist",40,0,{"$f":"B77*C77","v":0},{"$f":"IF(D77<=10,(D77*$I$6),IF(D77<=35,((10*$I$6)+((D77-10)*$I$7)),IF(D77<=40,((10*$I$6)+(25*$I$7)+((D77-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D77<=10,(D77*$I$11),IF(D77<=35,((10*$I$11)+((D77-10)*$I$12)),IF(D77<=40,((10*$I$11)+(25*$I$12)+((D77-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D77<=10,(D77*$I$16),IF(D77<=35,((10*$I$16)+((D77-10)*$I$17)),IF(D77<=40,((10*$I$16)+(25*$I$17)+((D77-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D77<=10,(D77*$I$21),IF(D77<=35,((10*$I$21)+((D77-10)*$I$22)),IF(D77<=40,((10*$I$21)+(25*$I$22)+((D77-35)*$I$23)),\"ERROR\")))","v":0},null,"Amputations Involved??",null,null,null,null,null,"Doubled Amputation Value"]
["Below Elbow ",40,0,0,{"$f":"IF(D78<=10,(D78*$I$6),IF(D78<=35,((10*$I$6)+((D78-10)*$I$7)),IF(D78<=40,((10*$I$6)+(25*$I$7)+((D78-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D78<=10,(D78*$I$11),IF(D78<=35,((10*$I$11)+((D78-10)*$I$12)),IF(D78<=40,((10*$I$11)+(25*$I$12)+((D78-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D78<=10,(D78*$I$16),IF(D78<=35,((10*$I$16)+((D78-10)*$I$17)),IF(D78<=40,((10*$I$16)+(25*$I$17)+((D78-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D78<=10,(D78*$I$21),IF(D78<=35,((10*$I$21)+((D78-10)*$I$22)),IF(D78<=40,((10*$I$21)+(25*$I$22)+((D78-35)*$I$23)),\"ERROR\")))","v":0},null,"Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled"]
["Above Elbow",50,0,0,{"$f":"IF(D79<=10,(D79*$I$6),IF(D79<=35,((10*$I$6)+((D79-10)*$I$7)),IF(D79<=50,((10*$I$6)+(25*$I$7)+((D79-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D79<=10,(D79*$I$11),IF(D79<=35,((10*$I$11)+((D79-10)*$I$12)),IF(D79<=50,((10*$I$11)+(25*$I$12)+((D79-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D79<=10,(D79*$I$16),IF(D79<=35,((10*$I$16)+((D79-10)*$I$17)),IF(D79<=50,((10*$I$16)+(25*$I$17)+((D79-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D79<=10,(D79*$I$21),IF(D79<=35,((10*$I$21)+((D79-10)*$I$22)),IF(D79<=50,((10*$I$21)+(25*$I$22)+((D79-35)*$I$23)),\"ERROR\")))","v":0},null,"Thumb",12,0,{"$f":"TRUNC((L79*M79),4)","v":0},{"$f":"IF(N79<=10,(N79*I21),((10*I21)+(2*I22)))","v":0},null,"Thumb",{"$f":"O79*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Index",8,{"$f":"$C$29","v":0},{"$f":"TRUNC((L80*M80),4)","v":0},{"$f":"N80*I21","v":0},null,"Index",{"$f":"O80*2","v":0}]
["Lower Extremity Injuries (Below Knee vs. Knee and Above)",null,null,null,null,null,null,null,null,null,"Middle",7,{"$f":"$C$30","v":0},0,{"$f":"N81*I21","v":0},null,"Middle",0]
["Foot",35,0,{"$f":"B82*C82","v":0},{"$f":"IF(D82<=10,(D82*$I$6),IF(D82<=35,((10*$I$6)+((D82-10)*$I$7)),\"ERROR\"))","v":0},null,{"$f":"IF(D82<=10,(D82*$I$11),IF(D82<=35,((10*$I$11)+((D82-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D82<=10,(D82*$I$16),IF(D82<=35,((10*$I$16)+((D82-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D82<=10,(D82*$I$21),IF(D82<=35,((10*$I$21)+((D82-10)*$I$22)),\"ERROR\"))","v":0},null,"Ring",6,{"$f":"$C$31","v":0},{"$f":"ROUND((L82*M82),1)","v":0},{"$f":"N82*I21","v":0},null,"Ring",0]
["Ankle",35,0,{"$f":"B83*C83","v":0},{"$f":"IF(D83<=10,(D83*$I$6),IF(D83<=35,((10*$I$6)+((D83-10)*$I$7)),\"ERROR\"))","v":0},null,{"$f":"IF(D83<=10,(D83*$I$11),IF(D83<=35,((10*$I$11)+((D83-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D83<=10,(D83*$I$16),IF(D83<=35,((10*$I$16)+((D83-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D83<=10,(D83*$I$21),IF(D83<=35,((10*$I$21)+((D83-10)*$I$22)),\"ERROR\"))","v":0},null,"Small",4,{"$f":"$C$32","v":0},{"$f":"TRUNC((L83*M83),4)","v":0},{"$f":"N83*I21","v":0},null,"Small",0]
["Below Knee",35,0,0,0,null,{"$f":"IF(D84<=10,(D84*$I$11),IF(D84<=35,((10*$I$11)+((D84-10)*$I$12)),\"ERROR\"))","v":0},{"$f":"IF(D84<=10,(D84*$I$16),IF(D84<=35,((10*$I$16)+((D84-10)*$I$17)),\"ERROR\"))","v":0},{"$f":"IF(D84<=10,(D84*$I$21),IF(D84<=35,((10*$I$21)+((D84-10)*$I$22)),\"ERROR\"))","v":0},null,"Total","-","-","-",{"$f":"SUM(O79:O83)","v":0}]
["Knee and Up",45,0,0,{"$f":"IF(D85<=10,(D85*$I$6),IF(D85<=35,((10*$I$6)+((D85-10)*$I$7)),IF(D85<=45,((10*$I$6)+(25*$I$7)+((D85-35)*$I$8)),\"ERROR\")))","v":0},null,{"$f":"IF(D85<=10,(D85*$I$11),IF(D85<=35,((10*$I$11)+((D85-10)*$I$12)),IF(D85<=45,((10*$I$11)+(25*$I$12)+((D85-35)*$I$13)),\"ERROR\")))","v":0},{"$f":"IF(D85<=10,(D85*$I$16),IF(D85<=35,((10*$I$16)+((D85-10)*$I$17)),IF(D85<=45,((10*$I$16)+(25*$I$17)+((D85-35)*$I$18)),\"ERROR\")))","v":0},{"$f":"IF(D85<=10,(D85*$I$21),IF(D85<=35,((10*$I$21)+((D85-10)*$I$22)),IF(D85<=45,((10*$I$21)+(25*$I$22)+((D85-35)*$I$23)),\"ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Mutli-Digit With Amputation Total = ",null,null,{"$f":"SUM(N75+O84)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Toe Amputations (No Multi-Digit Calculation For Toes)",null,null,null,null,null,"Doubled Amputation Value"]
[null,null,null,null,null,null,null,null,null,null,"Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled"]
[null,null,null,null,null,null,null,null,null,null,"Great",12,{"$f":"$C$42","v":0},{"$f":"L92*M92","v":0},{"$f":"IF(N92<=10,(N92*I21),((10*I21)+(2*I22)))","v":0},null,"Great",{"$f":"O92*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2nd",6,{"$f":"$C$43","v":0},{"$f":"L93*M93","v":0},{"$f":"N93*I21","v":0},null,"2nd",{"$f":"O93*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,"3rd",4,{"$f":"$C$44","v":0},0,{"$f":"N94*I21","v":0},null,"3rd",0]
[null,null,null,null,null,null,null,null,null,null,"4th",3,{"$f":"$C$45","v":0},0,{"$f":"N95*I21","v":0},null,"4th",0]
[null,null,null,null,null,null,null,null,null,null,"5th",2,{"$f":"$C$46","v":0},0,{"$f":"N96*I21","v":0},null,"5th",0]
[null,null,null,null,null,null,null,null,null,null,"Total","-","-","-",{"$f":"SUM(O92:O96)","v":0},null,"Total",{"$f":"SUM(R92:S96)","v":0}]

{"sheet":"Instructions","index":3,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,1,9,11],[8,1,8,11],[0,0,0,11],[1,0,2,11],[3,0,4,11],[6,0,6,11],[7,1,7,11],[18,1,18,2],[19,1,19,2],[10,1,10,11],[11,1,11,11],[12,1,12,11],[13,1,13,11],[15,0,15,11],[17,0,17,2]]}
["Welcome to the new PPI Calculation Worksheet"]
["This worksheet will assist you through the difficult and complex PPI Calculations. Further, this worksheet will also allow individuals to see what the dollar amount is for other body parts injured."]
[]
["Before you begin, there are a few instructions/rules that must be followed in order for this worksheet to operate correctly:"]
[]
[]
["Instructions/Rules:"]
[1,"Date of injury must be added to retreive correct rate- Message #NAME? means no date of injury was entered. "]
[2,"You are only able to manipulate/change the values under the table headings \"PPI Rating\" or \"Amputation\" in column \"C\". All other cells will be locked and are only available for reference."]
[3,"The cells that are unlocked for you to manipulate correspond with the most current dollar amount per degree. The other tables show different year totals accurately depending on the date of injury. "]
[4,"The amputation sections will only allow you to choose from a list of values in a drop down menu. There will be an arrow next to the cell you wish to manipulate. You can type in a value but if it does not match the statutory minimums, you will receive an error."]
[5,"If your calculations return an \"ERROR\" or \"INVALID\", this is because the values you have input do not correlate with statute, are not possible, or were misplaced. For example, you cannot exceed a 100% PPI rating for any injury so inputting 110% will return an error."]
[6,"It is highly recommended to save this to your computer for easier access."]
[7,"If you have any questions, concerns, or comments, please reach out to the Approval Division. Their phone number is listed below."]
[]
["Thank you for taking the time to read through the instructions/rules. Using this worksheet becomes easier over time. From all of us at the Board, thank you for everything you do and we hope this helps you in the future."]
[]
["Contact Us"]
["Board Member","Phone"]
["Approval Division","(317) 232-3807"]

{"sheet":"Calculations (Final)","index":4,"n_rows":73,"n_cols":50,"rows_kept":73,"cut":false,"hidden":false,"merged":[[4,13,4,14],[4,0,4,4],[4,6,4,8],[6,7,6,8],[7,7,7,8],[5,7,5,8],[4,10,4,12],[57,0,57,4],[60,0,60,4],[64,0,64,4],[69,0,69,4],[42,0,42,4],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[13,0,13,4],[38,47,38,49],[53,0,53,4],[49,47,49,49],[54,0,54,4],[21,0,21,4],[21,6,21,8],[22,7,22,8],[39,0,41,8],[30,0,30,4]]}
[]
["REQUIRED "]
["Date of Injury:",null,857]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2009-07-01",null,null,"23-24","24-25","25-26","26+"]
["Amputations to Digits",null,null,null,null,null,"Doubled Amputation Value",null,null,null,"Dollar Amounts Per Degree",null,null,"Statutory Minimums",null,null,null,null,null,null,null,null,null,null,null,"2014-07-01",null,null,1803,1857,1913,1970]
["Digit","Degree","Amputation","Digit Value","Total",null,"Digit","Doubled",null,null,"Range","Year","Rate",0,0,null,null,null,null,null,null,null,null,null,null,"2015-07-01",null,null,2011,2071,2133,2197]
["Thumb",12,0,{"$f":"TRUNC((B7*C7),4)","v":0},{"$f":"IF(D7<=10,(D7*M7),((10*M7)+(2*M8)))","v":{"$error":"#NAME?"}},null,"Thumb",{"$f":"E7*2","v":{"$error":"#NAME?"}},null,null,"1* - 10*",{"$f":"YEAR($B$3)","v":1900},{"$f":"IF(AND($B$3>=$Z$4,$B$3<$Z$5),\"$1,400\",IF(AND($B$3>=$Z$5,$B$3<$Z$6),\"$1,517\",IF(AND($B$3>=$Z$6,$B$3<$Z$7),\"$1,633\",IF(AND($B$3>=$Z$7,$B$3<$Z$8),\"$1,750\",IF(AND($B$3>=$Z$8,$B$3<$Z$9),\"$1,803\",IF(AND($B$3>=$Z$9,$B$3<$Z$10),\"$1,857\",IF(AND($B$3>=$Z$10,$B$3<$Z$11),\"$1,913\",IF($B$3>=$Z$11,\"$1,970\",ERROR))))))))","v":{"$error":"#NAME?"}},0.33333299999999999,0.5,null,null,null,null,null,null,null,null,null,null,"2016-07-01",null,null,3282,3380,3481,3585]
["Index",8,0,{"$f":"TRUNC((B8*C8),4)","v":0},{"$f":"D8*M7","v":{"$error":"#NAME?"}},null,"Index",{"$f":"E8*2","v":{"$error":"#NAME?"}},null,null,"11* - 35*",{"$f":"YEAR($B$3)","v":1900},{"$f":"IF(AND($B$3>=$Z$4,$B$3<$Z$5),\"$1,600\",IF(AND($B$3>=$Z$5,$B$3<$Z$6),\"$1,717\",IF(AND($B$3>=$Z$6,$B$3<$Z$7),\"$1,835\",IF(AND($B$3>=$Z$7,$B$3<$Z$8),\"$1,952\",IF(AND($B$3>=$Z$8,$B$3<$Z$9),\"$2,011\",IF(AND($B$3>=$Z$9,$B$3<$Z$10),\"$2,071\",IF(AND($B$3>=$Z$10,$B$3<$Z$11),\"$2,133\",IF($B$3>=$Z$11,\"$2,197\",ERROR))))))))","v":{"$error":"#NAME?"}},0.5,1,null,null,null,null,null,null,null,null,null,null,"2023-07-01",null,null,4182,4307,4436,4569]
["Middle",7,0,0,{"$f":"D9*M7","v":{"$error":"#NAME?"}},null,"Middle",{"$error":"#NAME?"},null,null,"36* - 50*",1900,{"$f":"IF(AND($B$3>=$Z$4,$B$3<$Z$5),\"$2,700\",IF(AND($B$3>=$Z$5,$B$3<$Z$6),\"$2,862\",IF(AND($B$3>=$Z$6,$B$3<$Z$7),\"$3,024\",IF(AND($B$3>=$Z$7,$B$3<$Z$8),\"$3,186\",IF(AND($B$3>=$Z$8,$B$3<$Z$9),\"$3,282\",IF(AND($B$3>=$Z$9,$B$3<$Z$10),\"$3,380\",IF(AND($B$3>=$Z$10,$B$3<$Z$11),\"$3,481\",IF($B$3>=$Z$11,\"$3,585\",ERROR))))))))","v":{"$error":"#NAME?"}},1,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01"]
["Ring",6,0,{"$f":"ROUND((B10*C10),2)","v":0},{"$f":"D10*M7","v":{"$error":"#NAME?"}},null,"Ring",{"$error":"#NAME?"},null,null,"51* - 100*",1900,{"$f":"IF(AND($B$3>=$Z$4,$B$3<$Z$5),\"$3,500\",IF(AND($B$3>=$Z$5,$B$3<$Z$6),\"$3,687\",IF(AND($B$3>=$Z$6,$B$3<$Z$7),\"$3,873\",IF(AND($B$3>=$Z$7,$B$3<$Z$8),\"$4,060\",IF(AND($B$3>=$Z$8,$B$3<$Z$9),\"$4,182\",IF(AND($B$3>=$Z$9,$B$3<$Z$10),\"$4,307\",IF(AND($B$3>=$Z$10,$B$3<$Z$11),\"$4,436\",IF($B$3>=$Z$11,\"$4,569\",ERROR))))))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,"2025-07-01"]
["Small",4,0,0,{"$f":"D11*M7","v":{"$error":"#NAME?"}},null,"Small",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-01"]
["Total","-","-","-",{"$f":"SUM(E7:E11)","v":{"$error":"#NAME?"}},null,"Total",{"$f":"SUM(H7:I11)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1* - 10*","2015 - 2016",1633]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11* - 35*","2015 - 2016",1835]
["Loss of Use of Digits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36* - 50*","2015 - 2016",3024]
["Digit","Degree","Percentage Loss","Digit Value","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51* - 100*","2015 - 2016",3873]
["Thumb",12,0,{"$f":"IF((B16*C16)>12,\"INVALID\",(B16*C16))","v":0},{"$f":"IF(D16<=10,(D16*M7),((10*M7)+((D16-10)*M8)))","v":{"$error":"#NAME?"}}]
["Index",8,0,{"$f":"IF((B17*C17)>8,\"INVALID\",(B17*C17))","v":0},{"$f":"D17*M7","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1* - 10*","2014 - 2015",1517]
["Middle",7,0,{"$f":"IF((B18*C18)>7,\"INVALID\",(B18*C18))","v":0},{"$f":"D18*M7","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11* - 35*","2014 - 2015",1717]
["Ring",6,0,{"$f":"IF((B19*C19)>6,\"INVALID\",(B19*C19))","v":0},{"$f":"D19*M7","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36* - 50*","2014 - 2015",2862]
["Small",4,0,{"$f":"IF((B20*C20)>4,\"INVALID\",(B20*C20))","v":0},{"$f":"D20*M7","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51* - 100*","2014 - 2015",3687]
[]
["Toe Amputations",null,null,null,null,null,"Doubled Amputation Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1* - 10*","2009 - 2014",1400]
["Toe","Degree","Amputation","Toe Value","Total",null,"Toe","Doubled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11* - 35*","2009 - 2014",1600]
["Great",12,0,{"$f":"B24*C24","v":0},{"$f":"IF(D24<=10,(D24*M7),((10*M7)+(2*M8)))","v":{"$error":"#NAME?"}},null,"Great",{"$f":"E24*2","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36* - 50*","2009 - 2014",2700]
["2nd",6,0,{"$f":"B25*C25","v":0},{"$f":"D25*M7","v":{"$error":"#NAME?"}},null,"2nd",{"$f":"E25*2","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51* - 100*","2009 - 2014",3500]
["3rd",4,0,0,{"$f":"D26*M7","v":{"$error":"#NAME?"}},null,"3rd",{"$error":"#NAME?"}]
["4th",3,0,0,{"$f":"D27*M7","v":{"$error":"#NAME?"}},null,"4th",{"$error":"#NAME?"}]
["5th",2,0,0,{"$f":"D28*M7","v":{"$error":"#NAME?"}},null,"5th",{"$error":"#NAME?"}]
["Total","-","-","-",{"$f":"SUM(E24:E28)","v":{"$error":"#NAME?"}},null,"Total",{"$f":"SUM(H24:I28)","v":{"$error":"#NAME?"}}]
[]
["Loss of Use of Toes"]
["Digit","Degree","Percentage Loss","Digit Value","Total"]
["Great",12,0,{"$f":"IF((B33*C33)>12,\"INVALID\",(B33*C33))","v":0},{"$f":"IF(D33<=10,(D33*M7),((10*M7)+((D33-10)*M8)))","v":{"$error":"#NAME?"}}]
["2nd",6,0,{"$f":"IF((B34*C34)>6,\"INVALID\",(B34*C34))","v":0},{"$f":"D34*M7","v":{"$error":"#NAME?"}}]
["3rd",4,0,{"$f":"IF((B35*C35)>4,\"INVALID\",(B35*C35))","v":0},{"$f":"D35*M7","v":{"$error":"#NAME?"}}]
["4th",3,0,{"$f":"IF((B36*C36)>3,\"INVALID\",(B36*C36))","v":0},{"$f":"D36*M7","v":{"$error":"#NAME?"}}]
["5th",2,0,{"$f":"IF((B37*C37)>2,\"INVALID\",(B37*C37))","v":0},{"$f":"D37*M7","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Year Totals"]
["Other PPI Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-2016","2014-2015","2009-2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D45<=10,(D45*$AF$12),IF(D45<=35,((10*$AF$12)+((D45-10)*$AF$13)),IF(D45<=50,((10*$AF$12)+(25*$AF$13)+((D45-35)*$AF$14)),IF(D45>50,((10*$AF$12)+(25*$AF$13)+(15*$AF$14)+((D45-50)*$AF$15)),\"ERROR\"))))","v":0},{"$f":"IF(D45<=10,(D45*$AF$17),IF(D45<=35,((10*$AF$17)+((D45-10)*$AF$18)),IF(D45<=50,((10*$AF$17)+(25*$AF$18)+((D45-35)*$AF$19)),IF(D45>50,((10*$AF$17)+(25*$AF$18)+(15*$AF$19)+((D45-50)*$AF$20)),\"ERROR\"))))","v":0},{"$f":"IF(D45<=10,(D45*$AF$22),IF(D45<=35,((10*$AF$22)+((D45-10)*$AF$23)),IF(D45<=50,((10*$AF$22)+(25*$AF$23)+((D45-35)*$AF$24)),IF(D45>50,((10*$AF$22)+(25*$AF$23)+(15*$AF$24)+((D45-50)*$AF$25)),\"ERROR\"))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Whole Person Injuries",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Body Part","Degrees","PPI Rating","Part Value","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Head",100,0,{"$f":"IF((B45*C45)>100,\"INVALID\",(B45*C45))","v":0},{"$f":"IF(D45<=10,(D45*$M$7),IF(D45<=35,((10*$M$7)+((D45-10)*$M$8)),IF(D45<=50,((10*$M$7)+(25*$M$8)+((D45-35)*$M$9)),IF(D45>50,((10*$M$7)+(25*$M$8)+(15*$M$9)+((D45-50)*$M$10)),\"ERROR\"))))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Neck",100,0,{"$f":"IF((B46*C46)>100,\"INVALID\",(B46*C46))","v":0},{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Shoulder",100,0,0,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Back",100,0,0,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Hip",100,0,0,{"$error":"#NAME?"}]
["Hernia",100,0,0,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Year Totals"]
["Bilateral",100,0,0,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-2016","2014-2015","2009-2014"]
["Any Combo",100,0,0,{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D56<=10,(D56*$AF$12),IF(D56<=35,((10*$AF$12)+((D56-10)*$AF$13)),\"ERROR\"))","v":0},{"$f":"IF(D56<=10,(D56*$AF$17),IF(D56<=35,((10*$AF$17)+((D56-10)*$AF$18)),\"ERROR\"))","v":0},{"$f":"IF(D56<=10,(D56*$AF$22),IF(D56<=35,((10*$AF$22)+((D56-10)*$AF$23)),\"ERROR\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D57<=10,(D57*$AF$12),IF(D57<=35,((10*$AF$12)+((D57-10)*$AF$13)),IF(D57<=50,((10*$AF$12)+(25*$AF$13)+((D57-35)*$AF$14)),IF(D57>50,((10*$AF$12)+(25*$AF$13)+(15*$AF$14)+((D57-50)*$AF$15)),\"ERROR\"))))","v":0},{"$f":"IF(D57<=10,(D57*$AF$17),IF(D57<=35,((10*$AF$17)+((D57-10)*$AF$18)),IF(D57<=50,((10*$AF$17)+(25*$AF$18)+((D57-35)*$AF$19)),IF(D57>50,((10*$AF$17)+(25*$AF$18)+(15*$AF$19)+((D57-50)*$AF$20)),\"ERROR\"))))","v":0},{"$f":"IF(D57<=10,(D57*$AF$22),IF(D57<=35,((10*$AF$22)+((D57-10)*$AF$23)),IF(D57<=50,((10*$AF$22)+(25*$AF$23)+((D57-35)*$AF$24)),IF(D57>50,((10*$AF$22)+(25*$AF$23)+(15*$AF$24)+((D57-50)*$AF$25)),\"ERROR\"))))","v":0}]
["Eyes/Ears/Testicles"]
["Complete Loss of Vision",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D59<=10,(D59*$AF$12),IF(D59<=15,((10*$AF$12)+((D59-10)*$AF$13)),\"ERROR\"))","v":0},{"$f":"IF(D59<=10,(D59*$AF$17),IF(D59<=15,((10*$AF$17)+((D59-10)*$AF$18)),\"ERROR\"))","v":0},{"$f":"IF(D59<=10,(D59*$AF$22),IF(D59<=15,((10*$AF$22)+((D59-10)*$AF$23)),\"ERROR\"))","v":0}]
["One Eye",35,0,{"$f":"IF((B56*C56)>35,\"INVALID\",(B56*C56))","v":0},{"$f":"IF(D56<=10,(D56*$M$7),IF(D56<=35,((10*$M$7)+((D56-10)*$M$8)),\"ERROR\"))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D60<=10,(D60*$AF$12),IF(D60<=35,((10*$AF$12)+((D60-10)*$AF$13)),IF(D60<=40,((10*$AF$12)+(25*$AF$13)+((D60-35)*$AF$14)),\"ERROR\")))","v":0},{"$f":"IF(D60<=10,(D60*$AF$17),IF(D60<=35,((10*$AF$17)+((D60-10)*$AF$18)),IF(D60<=40,((10*$AF$17)+(25*$AF$18)+((D60-35)*$AF$19)),\"ERROR\")))","v":0},{"$f":"IF(D60<=10,(D60*$AF$22),IF(D60<=35,((10*$AF$22)+((D60-10)*$AF$23)),IF(D60<=40,((10*$AF$22)+(25*$AF$23)+((D60-35)*$AF$24)),\"ERROR\")))","v":0}]
["Both Eyes",100,0,{"$f":"IF((B57*C57)>100,\"INVALID\",(B57*C57))","v":0},{"$f":"IF(D57<=10,(D57*$M$7),IF(D57<=35,((10*$M$7)+((D57-10)*$M$8)),IF(D57<=50,((10*$M$7)+(25*$M$8)+((D57-35)*$M$9)),IF(D57>50,((10*$M$7)+(25*$M$8)+(15*$M$9)+((D57-50)*$M$10)),\"ERROR\"))))","v":{"$error":"#NAME?"}}]
["Complete Loss of Hearing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D62<=10,(D62*$AF$12),\"ERROR\")","v":0},{"$f":"IF(D62<=10,(D62*$AF$17),\"ERROR\")","v":0},{"$f":"IF(D62<=10,(D62*$AF$22),\"ERROR\")","v":0}]
["One Ear",15,0,{"$f":"IF((B59*C59)>15,\"INVALID\",(B59*C59))","v":0},{"$f":"IF(D59<=10,(D59*$M$7),IF(D59<=15,((10*$M$7)+((D59-10)*$M$8)),\"ERROR\"))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D63<=10,(D63*$AF$12),IF(D63<=30,((10*$AF$12)+((D63-10)*$AF$13)),\"ERROR\"))","v":0},{"$f":"IF(D63<=10,(D63*$AF$17),IF(D63<=30,((10*$AF$17)+((D63-10)*$AF$18)),\"ERROR\"))","v":0},{"$f":"IF(D63<=10,(D63*$AF$22),IF(D63<=30,((10*$AF$22)+((D63-10)*$AF$23)),\"ERROR\"))","v":0}]
["Both Ears",40,0,{"$f":"IF((B60*C60)>40,\"INVALID\",(B60*C60))","v":0},{"$f":"IF(D60<=10,(D60*$M$7),IF(D60<=35,((10*$M$7)+((D60-10)*$M$8)),IF(D60<=40,((10*$M$7)+(25*$M$8)+((D60-35)*$M$9)),\"ERROR\")))","v":{"$error":"#NAME?"}}]
["Loss of Testicle(s)"]
["One",10,0,{"$f":"IF((B62*C62)>10,\"INVALID\",(B62*C62))","v":0},{"$f":"IF(D62<=10,(D62*$M$7),\"ERROR\")","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D66<=10,(D66*$AF$12),IF(D66<=35,((10*$AF$12)+((D66-10)*$AF$13)),IF(D66<=40,((10*$AF$12)+(25*$AF$13)+((D66-35)*$AF$14)),\"ERROR\")))","v":0},{"$f":"IF(D66<=10,(D66*$AF$17),IF(D66<=35,((10*$AF$17)+((D66-10)*$AF$18)),IF(D66<=40,((10*$AF$17)+(25*$AF$18)+((D66-35)*$AF$19)),\"ERROR\")))","v":0},{"$f":"IF(D66<=10,(D66*$AF$22),IF(D66<=35,((10*$AF$22)+((D66-10)*$AF$23)),IF(D66<=40,((10*$AF$22)+(25*$AF$23)+((D66-35)*$AF$24)),\"ERROR\")))","v":0}]
["Both",30,0,{"$f":"IF((B63*C63)>30,\"INVALID\",(B63*C63))","v":0},{"$f":"IF(D63<=10,(D63*$M$7),IF(D63<=30,((10*$M$7)+((D63-10)*$M$8)),\"ERROR\"))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D67<=10,(D67*$AF$12),IF(D67<=35,((10*$AF$12)+((D67-10)*$AF$13)),IF(D67<=40,((10*$AF$12)+(25*$AF$13)+((D67-35)*$AF$14)),\"ERROR\")))","v":0},{"$f":"IF(D67<=10,(D67*$AF$17),IF(D67<=35,((10*$AF$17)+((D67-10)*$AF$18)),IF(D67<=40,((10*$AF$17)+(25*$AF$18)+((D67-35)*$AF$19)),\"ERROR\")))","v":0},{"$f":"IF(D67<=10,(D67*$AF$22),IF(D67<=35,((10*$AF$22)+((D67-10)*$AF$23)),IF(D67<=40,((10*$AF$22)+(25*$AF$23)+((D67-35)*$AF$24)),\"ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D68<=10,(D68*$AF$12),IF(D68<=35,((10*$AF$12)+((D68-10)*$AF$13)),IF(D68<=50,((10*$AF$12)+(25*$AF$13)+((D68-35)*$AF$14)),\"ERROR\")))","v":0},{"$f":"IF(D68<=10,(D68*$AF$17),IF(D68<=35,((10*$AF$17)+((D68-10)*$AF$18)),IF(D68<=50,((10*$AF$17)+(25*$AF$18)+((D68-35)*$AF$19)),\"ERROR\")))","v":0},{"$f":"IF(D68<=10,(D68*$AF$22),IF(D68<=35,((10*$AF$22)+((D68-10)*$AF$23)),IF(D68<=50,((10*$AF$22)+(25*$AF$23)+((D68-35)*$AF$24)),\"ERROR\")))","v":0}]
["Upper Extremity Injuries"]
["Hand",40,0,{"$f":"IF((B66*C66)>40,\"INVALID\",(B66*C66))","v":0},{"$f":"IF(D66<=10,(D66*$M$7),IF(D66<=35,((10*$M$7)+((D66-10)*$M$8)),IF(D66<=40,((10*$M$7)+(25*$M$8)+((D66-35)*$M$9)),\"ERROR\")))","v":{"$error":"#NAME?"}}]
["Wrist",50,0,{"$f":"IF((B67*C67)>40,\"INVALID\",(B67*C67))","v":0},{"$f":"IF(D67<=10,(D67*$M$7),IF(D67<=35,((10*$M$7)+((D67-10)*$M$8)),IF(D67<=40,((10*$M$7)+(25*$M$8)+((D67-35)*$M$9)),\"ERROR\")))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D71<=10,(D71*$AF$12),IF(D71<=35,((10*$AF$12)+((D71-10)*$AF$13)),\"ERROR\"))","v":0},{"$f":"IF(D71<=10,(D71*$AF$17),IF(D71<=35,((10*$AF$17)+((D71-10)*$AF$18)),\"ERROR\"))","v":0},{"$f":"IF(D71<=10,(D71*$AF$22),IF(D71<=35,((10*$AF$22)+((D71-10)*$AF$23)),\"ERROR\"))","v":0}]
["Arm",50,0,{"$f":"IF((B68*C68)>50,\"INVALID\",(B68*C68))","v":0},{"$f":"IF(D68<=10,(D68*$M$7),IF(D68<=35,((10*$M$7)+((D68-10)*$M$8)),IF(D68<=50,((10*$M$7)+(25*$M$8)+((D68-35)*$M$9)),\"ERROR\")))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D72<=10,(D72*$AF$12),IF(D72<=35,((10*$AF$12)+((D72-10)*$AF$13)),\"ERROR\"))","v":0},{"$f":"IF(D72<=10,(D72*$AF$17),IF(D72<=35,((10*$AF$17)+((D72-10)*$AF$18)),\"ERROR\"))","v":0},{"$f":"IF(D72<=10,(D72*$AF$22),IF(D72<=35,((10*$AF$22)+((D72-10)*$AF$23)),\"ERROR\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D73<=10,(D73*$AF$12),IF(D73<=35,((10*$AF$12)+((D73-10)*$AF$13)),IF(D73<=45,((10*$AF$12)+(25*$AF$13)+((D73-35)*$AF$14)),\"ERROR\")))","v":0},{"$f":"IF(D73<=10,(D73*$AF$17),IF(D73<=35,((10*$AF$17)+((D73-10)*$AF$18)),IF(D73<=45,((10*$AF$17)+(25*$AF$18)+((D73-35)*$AF$19)),\"ERROR\")))","v":0},{"$f":"IF(D73<=10,(D73*$AF$22),IF(D73<=35,((10*$AF$22)+((D73-10)*$AF$23)),IF(D73<=45,((10*$AF$22)+(25*$AF$23)+((D73-35)*$AF$24)),\"ERROR\")))","v":0}]
["Lower Extremity Injuries"]
["Foot/Ankle",35,0,{"$f":"IF((B71*C71)>35,\"INVALID\",(B71*C71))","v":0},{"$f":"IF(D71<=10,(D71*$M$7),IF(D71<=35,((10*$M$7)+((D71-10)*$M$8)),\"ERROR\"))","v":{"$error":"#NAME?"}}]
["Knee",45,0,{"$f":"IF((B72*C72)>35,\"INVALID\",(B72*C72))","v":0},{"$f":"IF(D72<=10,(D72*$M$7),IF(D72<=35,((10*$M$7)+((D72-10)*$M$8)),\"ERROR\"))","v":{"$error":"#NAME?"}}]
["Leg",45,0,{"$f":"IF((B73*C73)>45,\"INVALID\",(B73*C73))","v":0},{"$f":"IF(D73<=10,(D73*$M$7),IF(D73<=35,((10*$M$7)+((D73-10)*$M$8)),IF(D73<=45,((10*$M$7)+(25*$M$8)+((D73-35)*$M$9)),\"ERROR\")))","v":{"$error":"#NAME?"}}]