{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":168,"n_cols":6,"rows_kept":168,"cut":false,"hidden":false,"merged":[[21,1,21,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2]]}
["STEP 1: CALCULATION OF TOTAL AWARD"]
[]
[null,"Insert damages "]
[null,"Economic Damages",null,null,0]
[null,"Non-Economic Damages",null,null,0]
[null,null,"TOTAL DAMAGES ",null,{"$f":"E4+E5","v":0}]
[]
["STEP 2:   ECONOMIC VS. NON-ECONOMIC"]
[]
[null,"% Economic ",null,null,{"$f":"IF((E4+E5)=0,0,E4/E6)","v":0}]
[null,"% Non-Economic ",null,null,{"$f":"IF((E4+E5)=0,0,E5/E6)","v":0}]
[null,null,"TOTAL",null,{"$f":"E10+E11","v":0}]
[]
["STEP 3:  ENTER % OF FAULT FOR EACH PARTY"]
[]
[null,"Insert percentages of fault below"]
[null,"PLAINTIFF",null,null,0]
[null,"EMPLOYER",null,null,0]
[null,"DEFENDANT 1",null,null,0]
[null,"DEFENDANT 2",null,null,0]
[null,"DEFENDANT 3",null,null,0]
[null,"DEFENDANT 4",null,null,0]
[null,null,"TOTAL",null,{"$f":"SUM(E17:E22)","v":0}]
[]
["STEP 4:   PLAINTIFF'S NET ECONOMIC DAMAGES"]
[]
[null,"Total Economic Award ",null,null,{"$f":"E4","v":0}]
[null,null,"Comparative Fault %",null,{"$f":"E17","v":0}]
[null,null,"Minus Comparative Fault ",null,{"$f":"E17*E4","v":0},1]
[null,null,"TOTAL",null,{"$f":"E27-E29","v":0}]
[]
["STEP 5:  DEFENDANT'S NET SHARE OF NON-ECONOMIC DAMAGES"]
[]
[null,"Total Non-Economic Award",null,null,{"$f":"E5","v":0}]
[]
[null,{"$f":"B19","v":"DEFENDANT 1"},null,{"$f":"E19","v":0},{"$f":"E$34*D36","v":0},2]
[null,{"$f":"B20","v":"DEFENDANT 2"},null,{"$f":"E20","v":0},{"$f":"E$34*D37","v":0}]
[null,{"$f":"B21","v":"DEFENDANT 3"},null,{"$f":"E21","v":0},{"$f":"E$34*D38","v":0}]
[null,{"$f":"B22","v":"DEFENDANT 4"},null,{"$f":"E22","v":0},{"$f":"E$34*D39","v":0}]
[null,null,"Net Non-Economic Recovery",null,{"$f":"SUM(E36:E39)","v":0}]
[]
["STEP 6:  TOTAL JUDGMENT BEFORE SETOFFS"]
[]
[null,"Plaintiff Net Recovery Economic Recovery",null,null,{"$f":"E30","v":0}]
[null,"Plaintiff Net Recovery Non-Economic Recovery",null,null,{"$f":"E40","v":0}]
[null,null,null,null,{"$f":"SUM(E44:E45)","v":0}]
[]
["STEP 7: DETERMINE WC LIEN SET-OFF"]
[]
[null,"Insert Total WC Lien",null,null,0]
[null,"Percentage of Economic Damages",null,null,{"$f":"E10","v":0}]
[null,"Lien Amount ",null,null,{"$f":"E51*E50","v":0},3]
[]
[null,"Net Economic Recovery Before WC Set- Off",null,null,{"$f":"E44","v":0}]
[null,null,"Minus WC Set-Off",null,{"$f":"-E52","v":0}]
[null,null,"Net Economic Recovery",null,{"$f":"IF((E54+E55)<0,0,(E54+E55))","v":0}]
[]
[null,"Plaintiff Net Recovery Economic Recovery",null,null,{"$f":"E56","v":0}]
[null,"Plaintiff Net Recovery Non-Economic Recovery",null,null,{"$f":"E45","v":0}]
[null,null,null,null,{"$f":"SUM(E58:E59)","v":0}]
[]
["STEP 8:  EMPLOYER RECOVERY OF LIEN (Labor Code 3856)"]
[]
[null,null,"Total Damages (Minus comparative fault) ",null,{"$f":"E6-(E6*E17)","v":0}]
[null,"x","Employer's Negligence",null,{"$f":"E18","v":0}]
[null,null,"Employer's Threshold Value",null,{"$f":"-E64*E65","v":0},4]
[]
[null,"Employer's Total Lien ",null,null,{"$f":"E50","v":0}]
[null,null,"Employer's Threshold Value",null,{"$f":"E66","v":0}]
[null,null,null,null,{"$f":"IF((E68+E69)<0,\"None\",(E68+E69))","v":0}]
[]
[null,null,"Insert Attorneys Fee %",null,0,5]
[null,null,"Minus Fee",null,{"$f":"IF(E70=\"None\",0,-(E72*E70))","v":0}]
[null,"Gross Lien Owed to Employer",null,null,{"$f":"IF(E70=\"None\",\"None\",(E70+E73))","v":0}]
[]
[null,null,"Total Judgment",null,{"$f":"E60","v":0}]
[null,null,"Total WC Set-Off",null,{"$f":"IF((E54+E55)<0,E54,-E55)","v":0}]
[null,null,null,null,{"$f":"SUM(E76:E77)","v":0}]
[]
[]
[]
[]
[null,null,"Lien Amount Owed from Set Off ",null,{"$f":"IF(E74=\"None\",\"None\",IF((E74>E77),E77,IF(E74<E77,E74)))","v":false},"*"]
[]
[null,null,"Additional Lien From Judgment",null,{"$f":"IF(E83=\"None\",\"None\",IF((E74-E83)>E60,E60,IF((E74-E83)=0,\"None\",(E74-E83))))","v":"None"},"*"]
[null,null,"*May be subject to attorneys fees "]
[null,null,"* Cannot exceed judgment Plus WC Set Off"]
[]
[null,"Plaintiff Net Recovery Economic Recovery",null,null,{"$f":"IF(E85=\"None\",E58,IF((E58-E85)<0,0,(E58-E85)))","v":0}]
[null,"Plaintiff Net Recovery Non-Economic Recovery",null,null,{"$f":"IF(E85=\"None\",E59,IF((E58-E85)<0,(E58-E85)+E59,IF((E58-E85)>0,E59)))","v":0}]
[null,null,null,null,{"$f":"SUM(E89:E90)","v":0},6]
[]
[]
["STEP 9: SUBTRACT PRE-TRIAL SETTLEMENT"]
[]
[null,"Insert Total Pre-Trial Settlements",null,null,0]
[null,"Total Pre-Trial Settlements Set-Off ",null,null,{"$f":"E96*E10","v":0},7]
[]
[null,"Net Economic Damages Before Set-Off ",null,null,{"$f":"E89","v":0}]
[null,null,"Minus Pre-Trial Set-Off",null,{"$f":"IF((E89=0),0,E97)","v":0}]
[null,null,"TOTAL",null,{"$f":"E99+E100","v":0}]
[]
[]
[]
[]
["STEP 10:  TOTAL ECONOMIC AND NON-ECONOMIC AWARD"]
[]
[null,"Total Economic Award",null,null,{"$f":"E101","v":0}]
[null,"Total Non-Economic Award",null,null,{"$f":"E90","v":0}]
[null,null,"Net Total Recovery",null,{"$f":"E108+E109","v":0}]
[]
[null," "]
[]
["STEP 11: ADD COSTS OF THE SUIT"]
[]
[null,"Insert Allowable Costs (CCP 1033)",null,null,0]
[null,"NET VERDICT TO PLAINTIFF",null,null,{"$f":"E110-E116","v":0}]
[]
["STEP 12: ADD OR SUBTRACT COSTS PENALTIES"]
[]
[null,"Insert Cost Enhancements (Items Added)",null,null,0]
[null,"Insert Cost Penalties (Items Deducted)",null,null,0]
[null,"NET VERDICT TO PLAINTIFF",null,null,{"$f":"E117+E121-E122","v":0}]
[]
["STEP 13: ADD PREJUDGMENT INTEREST"]
[]
[null,"Insert Prejudgment Interest",null,null,0]
[null,"NET VERDICT TO PLAINTIFF",null,null,{"$f":"E123+E127","v":0}]
[]
[]
["STEP 14: DEDUCT PRE-FEE LIENS AND COSTS"]
[]
[null,"1. Insert Medical Liens Deducted Pre-Fees",null,null,0]
[null,"2. Insert Attorney's Costs of Prosecution",null,null,0]
[null,"Total Pre-Fee Lien & Cost Deduction",null,null,{"$f":"E128-E133-E134","v":0}]
[]
[null,"Net to Client After Deductions",null,null,{"$f":"E135","v":0}]
[]
["STEP 15: DEDUCT ATTORNEYS FEES"]
[]
[null,"Insert % of Attorneys Fees",null,null,{"$f":"E72","v":0}]
[null,"Total Attorneys Fees",null,null,{"$f":"E137*E141","v":0}]
[null,"Net to client after Attorneys Fees",null,null,{"$f":"E137-E142","v":0}]
[]
[]
["STEP 16: DEDUCT POST-FEE LIENS AND COSTS"]
[]
[null,"1. Insert Medical Liens Deducted Post Fees",null,null,0]
[null,"2. Insert Costs Deducted Post Fees",null,null,0]
[null,"Total Post-Fee Lien & Cost Deduction",null,null,{"$f":"E148+E149","v":0}]
[]
[null,"Net to Client After Deductions",null,null,{"$f":"E143-E150","v":0}]
[]
[]
[]
["Cogent Legal assume no liability for the use of this worksheet "]
["and such worksheet should be considered a guide only.  "]
["The law may change after preparation of this worksheet and individual cases may "]
["require the application of different law. "]
[]
[]
[1,"Civil Code §1431.2 and DaFonte v. Up-Right, Inc. (1992) 2 Cal.4th 593"]
[2,"Civil Code §1431.2 and DaFonte v. Up-Right, Inc. (1992) 2 Cal.4th 593"]
[3,"Scalice v. Performance Cleaning Systems 50 Cal.App.4th 221"]
[4,"Associated Construction & Engineering Co. v. Workers' Comp. Appeals Bd. , 22 Cal.3d 829"]
[5,"Summers v. Tice, et al., 33 Cal.2d 80 199; Labor Code § 3856, subd. (b)"]
[6,"Duncan v. Walmart Stores, Inc. "]
[7,"Greathouse v. Amcord, Inc. (1995) 35 Cal.App.4th 831"]