{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Sheet1","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,2,6],[9,3,9,4],[6,3,6,4],[14,2,15,2],[14,3,15,4],[4,3,4,4],[5,3,5,4],[7,3,7,4],[8,3,8,4],[10,3,10,4],[23,3,23,4],[24,3,24,5],[11,3,11,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[16,3,16,4]]}
[null,"ASR Base Settlement Calculator"]
[]
[]
[]
[null,null,"Last Name"]
[null,null,"First Name"]
[null,null,"Is Claimant Represented by an Attorney before 11/11/2013"]
[null,null,"Date of Birth",null,null,{"$f":"IF(AND(ISNUMBER(D8),ISNUMBER(D11)),\"Age at Implant: \"&DATEDIF(D8,D11,\"Y\"),\"\")","v":""}]
[null,null,"Date of Death (if Applicable)"]
[null,null,"Did Death occur during hospitalization for \nRevision or Re-Revision Surgery?"]
[null,null,"Implant Date"]
[null,null,"Was Initial ASR Implantation a Revision Device?"]
[null,null,"Height at time of Initial Implant",null,"feet/inches",{"$f":"IF(OR(ISBLANK(D13),ISBLANK(D14)),\"\",\"BMI:\")","v":""}]
[null,null,"Weight at time of Initial Implant",null,"lbs.",{"$f":"IF(AND(D14>=85,D14<700),703*D14/(((LEFT(D13,FIND(\"'\",D13)-1)+((MID(D13,FIND(\"'\",D13)+1,LEN(D13)-FIND(\"'\",D13)-1))/12))*12)^2),IF(ISBLANK(D14),\"\",\"\"))","v":""}]
[null,null,"Revision Date",null,null,{"$f":"IF(AND(ISNUMBER(D11),ISNUMBER(D15)),\"Latency:\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(D11),ISNUMBER(D15)),DATEDIF(D11,D15,\"Y\")&\" years \"&DATEDIF(D11,D15,\"YM\")&\" months \"&DATEDIF(D11,D15,\"MD\")&\" days\",\"\")","v":""}]
[null,null,"Did Claimant use Tobacco at time of Revision Surgery? "]
[]
[null,null,"Latency Adjustment",{"$f":"IF(OR(D11=0,D15=0),\"\",IF(F16=\"8 years 0 months 0 days\",Sheet2!A5,IF(OR(DATEDIF(D11,D15,\"D\")<=180,DATEDIF(D11,D15,\"Y\")>=8),\"Outside Settlement Criteria\",IF(DATEDIF(D11,D15,\"Y\")<5,Sheet2!A2,IF(DATEDIF(D11,D15,\"Y\")<6,Sheet2!A3,IF(DATEDIF(D11,D15,\"Y\")<7,Sheet2!A4,IF(DATEDIF(D11,D15,\"Y\")<8,Sheet2!A5,\"\")))))))","v":""},null,{"$f":"VLOOKUP(D19,Sheet2!A2:B5,2,FALSE)*IF(D7=\"No\",0.71,1)","v":{"$error":"#N/A"}}]
[null,null,"Tobacco Adjustment",{"$f":"IF(D17=0,\"\",D17)","v":""},null,{"$f":"F19*VLOOKUP(D20,Sheet2!A8:B10,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"BMI Adjustment",{"$f":"IF(OR(D13=0,D14=0),\"No Reference in Records\",IF(F14<=35,Sheet2!A$13,IF(F14<=40,Sheet2!A$14,IF(F14<=50,Sheet2!A$15,IF(F14<100,Sheet2!A$16,\"\")))))","v":"No Reference in Records"},null,{"$f":"F19*VLOOKUP(D21,Sheet2!A13:B17,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Death within 5 years of Revision Surgery Adjustment",{"$f":"IF(D9=0,\"N/A -Claimant is Alive\",IF(D15=0,\"ENTER REVISION DATE\",IF(DATEDIF(D15,D9,\"Y\")>=5,\"No\",\"Yes\")))&IF(D10=\"Yes\",\" - Exemption Applied\",\"\")","v":"N/A -Claimant is Alive"},null,{"$f":"IF(OR(D9=0,D10=\"Yes\"),0,F19*VLOOKUP(D22,Sheet2!A20:B21,2,FALSE))","v":0}]
[null,null,"Age Adjustment",{"$f":"IF(D8=0,\"ENTER DATE OF BIRTH\",IF(DATEDIF(D8,D11,\"Y\")=0,\"\",IF(DATEDIF(D8,D11,\"Y\")<70,Sheet2!A24,IF(DATEDIF(D8,D11,\"Y\")<75,Sheet2!A25,IF(DATEDIF(D8,D11,\"Y\")<80,Sheet2!A26,IF(DATEDIF(D8,D11,\"Y\")<85,Sheet2!A27,Sheet2!A28))))))","v":"ENTER DATE OF BIRTH"},null,{"$f":"IF(F22<0,0,F19*VLOOKUP(D23,Sheet2!A24:B28,2,FALSE))","v":{"$error":"#N/A"}}]
[null,null,"ASR was not Claimant’s Initial Implant ",{"$f":"IF(D12=0,\"\",D12)","v":""},null,{"$f":"F19*VLOOKUP(D24,Sheet2!A31:B32,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Projected Base Settlement Allocation",{"$f":"IF(D7=\"No\",DOLLAR(MAX(SUM(F19:F24),VLOOKUP(D19,Sheet2!A2:D5,4,FALSE)),2)&IF(VLOOKUP(D19,Sheet2!A2:D5,4,FALSE)>SUM(F19:F24),\" (Minimum Cap Applied)\",\"\"),DOLLAR(MAX(SUM(F19:F24),VLOOKUP(D19,Sheet2!A2:C5,3,FALSE)),2)&IF(VLOOKUP(D19,Sheet2!A2:C5,3,FALSE)>SUM(F19:F24),\" (Minimum Cap Applied)\",\"\"))","v":{"$error":"#N/A"}}]

{"sheet":"Sheet2","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Latency","Base Award","Minimum","Minimum without Attorney"]
["180 days < X < 5 years ",250000,150000,106500]
["5 years ≤ X < 6 years",225000,150000,106500]
["6 years ≤ X < 7 years",200000,125000,88750]
["7 years ≤ X ≤ 8 years",150000,100000,71000]
[]
["Use of Tobacco\n(at time of Revision Surgery). ","Adjustment"]
["Yes",-0.05]
["No",0]
["No Reference in Records",-0.05]
[]
["BMI","Adjustment"]
["BMI ≤ 35",0]
["BMI > 35",-0.05]
["BMI > 40",-0.15]
["BMI > 50",-0.2]
["No Reference in Records",-0.2]
[]
["Death within 5 years of Revision Surgery","Adjustment"]
["Yes",-0.25]
["No",0]
[]
["Age\n(at time of ASR Implant)","Adjustment"]
["< 70",0]
["≥ 70",-0.04]
["≥ 75",-0.08]
["≥ 80",-0.12]
["≥ 85",-0.15]
[]
["ASR was not Claimant’s Initial Implant ","Adjustment"]
["Yes",-0.05]
["No",0]

{"sheet":"Sheet3","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["feet/inches","Yes",null,"4' 0\""]
["inches","No",null,"4' 1\""]
["cm","No Reference in Records",null,"4' 2\""]
[null,null,null,"4' 3\""]
["lbs.",null,null,"4' 4\""]
["kg",null,null,"4' 5\""]
[null,null,null,"4' 6\""]
[null,null,null,"4' 7\""]
[null,null,null,"4' 8\""]
[null,null,null,"4' 9\""]
[null,null,null,"4' 10\""]
[null,null,null,"4' 11\""]
[]
[null,null,null,"5' 0\""]
[null,null,null,"5' 1\""]
[null,null,null,"5' 2\""]
[null,null,null,"5' 3\""]
[null,null,null,"5' 4\""]
[null,null,null,"5' 5\""]
[null,null,null,"5' 6\""]
[null,null,null,"5' 7\""]
[null,null,null,"5' 8\""]
[null,null,null,"5' 9\""]
[null,null,null,"5' 10\""]
[null,null,null,"5' 11\""]
[null,null,null,"6' 0\""]
[null,null,null,"6' 1\""]
[null,null,null,"6' 2\""]
[null,null,null,"6' 3\""]
[null,null,null,"6' 4\""]
[null,null,null,"6' 5\""]
[null,null,null,"6' 6\""]
[null,null,null,"6' 7\""]
[null,null,null,"6' 8\""]
[null,null,null,"6' 9\""]
[null,null,null,"6' 10\""]
[null,null,null,"6' 11\""]
[null,null,null,"7' 0\""]

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}