{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Liquidated Damages","Example Form","Sheet1","DATA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Instructions","index":0,"n_rows":58,"n_cols":1,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,0,61,12],[1,0,1,12],[15,0,25,12],[2,0,13,12],[27,0,35,12],[39,0,44,12],[49,0,52,12]]}
[]
["INSTRUCTIONS FOR LIQUIDATED DAMAGES WORKSHEET"]
["SAVE THIS WORKBOOK TO YOUR COMPUTER FOR THE CALCULATIONS TO FUNCTION CORRECTLY. \n \nLiquidated Damages are calculated for each Local Agency Design-Bid-Build project for failure to complete the physical work within the allotted contract time. The Local Agency Engineer is responsible for completing the Design Liquidated Damages Calculation Sheet to determine the liquidated damages (LD) amount, which will be used in a fill-in for Special Provision APWA 1-08.9 Option A.  \n\nThe Local Agency or consultant should calculate construction engineering costs near the 90% milestone to fill out this form.  Workforce projections must be ascertained for estimating construction staffing during the project.  Since workforce will fluctuate through the project life, select a representative point near the end of the project for populating the Local Agency Personnel section of this form.  Document the workforce assumptions in the Comments/Assumptions/Staffing Notes section at the bottom of this form.\n\nHints will pop-up when you hover over column titles in the worksheet to assist you in completing this form.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculations are intended to capture labor charges for the project staff, such as Engineers, Inspectors, testers,  administration staff, etc who bill directly to the projects. \n\nThere is an Overhead section below that will address indirect charges such as support office staff, vehicles, office administration staff, redistributed costs, office overhead, office equipment, rent, etc.  \n\nLocal Agencies ICR rates must be compliant with 2CFR 200 and be federally approved. Local Agencies that do not have a federally approved ICR may utilize the 10% De minimis rate allowed under 2 CFR 200.\n\nIf the project will be using consultant support include the position(s) in the Consultant Personnel section, including wage rates from the consultant agreement.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["In the left column (under Local Agency Personnel) insert the personnel that will be directly charging time to the project.  In the next column to the right, add a description of the work that person will be doing, i.e. Electrical Inspector, Roadway Inspector, Structure Inspector, Materials Tester, etc. \nAs you fill in the next five columns (Each, Hrs/Day & OverTime Hrs,  the Hourly Rate, and the Hourly Fringe Benefit Rate), the worksheet will automatically fill in, OT Rate and Daily Cost for each employee.  The Hourly Rate is the unweighted rate.  OT Rate is straight rate times 1.5, and does not include benefits.\n\nIf the project will be using consultants during the duration of the project, use the project-specific consultant agreement to obtain the wage rates.  If a consultant has been hired an has an established ICR rate replace the safe harbor rate of 110% with the actual ICR.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overhead"]
[]
["\n“Subtotal” is the summation of labor.  “Subtotal including Overhead” is the Subtotal plus a factor of 10% or the Local Agency's approved federal Indirect Cost Rate (ICR).  \nLocal Agencies ICR rates must be compliant with 2CFR 200 and be federally approved. Local Agencies that do not have a federally approved ICR may utilize the 10% De minimis rate allowed under 2 CFR 200."]
[]
[]
[]
[]
[]
[]
["Calculated Liquidated Damages"]
[]
[]
["The total calculation of daily liquidated damages will be rounded to the nearest $50.  Use this amount for the fill-in blank in Special Provision APWA GSP 1-08.9 Option A.\nFor Local Agencies with full CA, the Local Agency Project Engineer must sign and date this form.\nFor Local Agencies without a CA or with restricted CA status, the Local Agency authority must sign and date this worksheet. \n"]
[]
[]
[]
[]
[]
["Comments/Assumptions/Staffing Notes"]
[]
["All assumptions regarding the completion of this form should be captured in this note box at the end of the form.\n \nThe Approved Project Liquidated Damages Calculation Sheet must be kept in the Project File documentation.\n"]

{"sheet":"Liquidated Damages","index":1,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,4,2,7],[2,10,2,11],[4,2,5,11],[46,1,46,11],[4,1,5,1],[37,1,37,4],[36,1,36,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[33,5,33,6],[36,5,36,6],[37,5,37,6],[34,5,34,6],[32,5,32,6],[32,1,32,4],[35,5,35,6],[60,1,62,11],[54,1,55,2],[54,4,55,7],[54,9,55,11],[48,4,48,8],[50,6,50,8],[58,0,58,11]]}
["       Local Agency Liquidated Damages Calculation - (Project-by-Project)"]
[]
[null,"SR",null,"   MP",null,null,null,null,null,"Federal Aid #"]
[]
[null,"Project Title"]
[]
[]
[null,"                   Liquidated Damages for Failure to Complete the Work or Portions of the Work On Time"]
[null,"List personnel that will activey be working on the project \"only\""]
[null,"Local Agency Personnel","Project Assignment","Column1","Column2","Each","Hrs/Day","OverTime Hrs","Unweighted Hourly Wage Rate","Hourly Fringe Benefits Rate","OT Rate","Daily Cost"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I11*1.5","v":0},{"$f":"IFERROR(((((G11*I11)*F11)+(K11*H11)*F11)+((G11+H11)*J11)),\"--\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"Administrative staff and personnel are included under the project overhead calculation and cannot be included in above calculation."]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11:L26)","v":0}]
[null,"Subtotal including Agency Federal Approved overhead rate",null,null,null,null,null,"→",0.1,"for this project",null,{"$f":"L29+I32","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"L29*I30","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I30*L29","v":0}]
[null,"Consultant CN Personnel",null,null,null,"Project Assignment",null,"Each","Hrs/Day","Unweighted Hourly Wage Rate","Hourly Fringe Benefits Rate","Daily Cost"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(((I34*J34)+(I34*K34)),\"--\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(((I35*J35)+(I35*K35)),\"--\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L34:L38)","v":0}]
[null,"Subtotal including Standard Safe Harbor overhead rate",null,null,null,null,null,"→",1.1000000000000001,"for this project",null,{"$f":"L40*I41","v":0}]
[]
[]
[null,null,"CALCULATED LIQUIDATED DAMAGES PER WORKING DAY =",null,null,null,null,null,null,null,null,{"$f":"L30+L41","v":0}]
[null,null,null,null,null,"Rounded to the nearest $50 →",null,null,null,null,null,{"$f":"MROUND(L44,50)","v":0}]
[]
[null,"This worksheet must be submitted to Region LPE as part of Division One approval package for every project.                                                                                     This file and approval must be in the project file as documentation for Liquidated Damages on all Federal-Aid projects.  "]
[]
[null,"Use Special Provision",null,null,"APWA 1-08.9 Option A"]
[]
[null,"Insert Liquidated Damages, In the amount of   $ ",null,null,null,null,{"$f":"L45","v":0},null,null,"  per working day"]
[]
[null," Project  Engineer"]
[]
[]
[]
[null,"Name",null,null,"Signature",null,null,null,null,"Date"]
[null,"By signing I cerify that the above information provided is true and accurate."]
["Comments / Assumptions / Staffing Notes:"]
[null,"Reference:  23 CFR §635.127 – Agreement provisions regarding overruns in contract Time."]

{"sheet":"Example Form","index":2,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[54,9,55,11],[58,0,58,11],[60,1,62,11],[36,1,36,4],[36,5,36,6],[37,1,37,4],[37,5,37,6],[54,1,55,2],[54,4,55,7],[46,1,46,11],[48,4,48,8],[50,6,50,8],[0,0,0,11],[2,10,2,11],[4,1,5,1],[4,2,5,11],[32,1,32,4],[32,5,32,6],[35,1,35,4],[35,5,35,6],[33,1,33,4],[2,4,2,7],[33,5,33,6],[34,1,34,4],[34,5,34,6]]}
["       Local Agency Liquidated Damages Calculation - (Project-by-Project)"]
[]
[null,"SR or Street","Alder","   MP","0.75 to 2.00",null,null,null,null,"Federal Aid #","HSIP-1234(001)"]
[]
[null,"Project Title","2023 County Safety Improvements"]
[]
[]
[null,"                   Liquidated Damages for Failure to Complete the Work or Portions of the Work On Time"]
[null,"List personnel that will activey be working on the project \"only\""]
[null,"Local Agency Personnel","Project Assignment","Column1","Column2","Each","Hrs/Day","OverTime Hrs","Unweighted Hourly Wage Rate","Hourly Fringe Benefits Rate","OT Rate","Daily Cost"]
[null,"Engineer EIT","Field Inspector",null,null,1,2,0,65,27.5,{"$f":"I11*1.5","v":97.5},{"$f":"IFERROR(((((G11*I11)*F11)+(K11*H11)*F11)+((G11+H11)*J11)),\"--\")","v":185}]
[null,"Engineer Tech","Tester",null,null,1,2,0,55,24.75,82.5,159.5]
[null,null,null,null,null,1,4,0,90,32.5,135,490]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"Administrative staff and personnel are included under the project overhead calculation and cannot be included in above calculation."]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11:L26)","v":834.5}]
[null,"Subtotal including Agency Federal Approved overhead rate",null,null,null,null,null,"→",0.1,"for this project",null,{"$f":"L29+I32","v":917.95}]
[null,null,null,null,null,null,null,null,{"$f":"L29*I30","v":83.45}]
[null,null,null,null,null,null,null,null,{"$f":"I30*L29","v":83.45}]
[null,"Consultant CN Personnel",null,null,null,"Project Assignment",null,"Each","Hrs/Day","Unweighted Hourly Wage Rate","Hourly Fringe Benefits Rate","Daily Cost"]
[null,"Project Engineer",null,null,null,"Project Management",null,1,4,100,39.5,{"$f":"IFERROR(((I34*J34)+(I34*K34)),\"--\")","v":558}]
[null,"Project Inspector",null,null,null,"Field Inspection",null,1,10,70,34.75,{"$f":"IFERROR(((I35*J35)+(I35*K35)),\"--\")","v":1047.5}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L34:L38)","v":1605.5}]
[null,"Subtotal including Standard Safe Harbor overhead rate",null,null,null,null,null,"→",1.1000000000000001,"for this project",null,{"$f":"L40*1.1","v":1766.0500000000002}]
[]
[]
[null,null,"CALCULATED LIQUIDATED DAMAGES PER WORKING DAY =",null,null,null,null,null,null,null,null,{"$f":"L30+L41","v":2684}]
[null,null,null,null,null,"Rounded to the nearest $50 →",null,null,null,null,null,{"$f":"MROUND(L44,50)","v":2700}]
[]
[null,"This worksheet must be submitted to Region LPE as part of Division One approval package for every project.                                                                             This file and approval must be in the project file as documentation for Liquidated Damages on all Federal-Aid projects.  "]
[]
[null,"Use Special Provision",null,null,"APWA 1-08.9 Option A"]
[]
[null,"Insert Liquidated Damages, In the amount of   $ ",null,null,null,null,{"$f":"L45","v":2700},null,null,"  per working day"]
[]
[null," Project  Engineer"]
[]
[]
[]
[null,"Name",null,null,"Signature",null,null,null,null,"Date"]
[null,"By signing I cerify that the above information provided is true and accurate."]
["Comments / Assumptions / Staffing Notes:"]
[null,"Reference:  23 CFR §635.127 – Agreement provisions regarding overruns in contract Time."]

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

{"sheet":"DATA","index":4,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Quantity","Hours per day","Position ","PLACE HOLDER","2020 Annual Step L","Benefits","2020- Loaded Rate","2020- Regular Rate","2020- OT Rate","2021 Annual Step L","Benefits","2021- Loaded Rate","2021- Regular Rate","2021- OT Rate"]
[1,1,"TE-1",null,70637.400000000009,29696.158800000001,48.05,{"$f":"E2/2088","v":33.830172413793107},{"$f":"H2*1.5","v":50.745258620689661},72756.522000000012,30185.765874000001,{"$f":"(J2+K2)/2088","v":49.301862008620695},{"$f":"J2/2088","v":34.845077586206905},{"$f":"M2*1.5","v":52.267616379310354}]
[2,2,"TE-2",null,77954.52,31345.03284,52.35,{"$f":"E3/2088","v":37.334540229885057},{"$f":"H3*1.5","v":56.001810344827589},80293.155599999998,31885.1536452,{"$f":"(J3+K3)/2088","v":53.725243891379307},{"$f":"J3/2088","v":38.454576436781608},{"$f":"M3*1.5","v":57.681864655172411}]
[3,3,"TE-3",null,86062.680000000008,33173.12556,57.11,41.217758620689658,61.826637931034483,88644.560400000002,33767.214526800002,58.626328987931039,42.454291379310348,63.681437068965522]
[4,4,"TT-1",null,49934.400000000001,25028.059799999999,35.9,23.914942528735633,35.872413793103448,51432.432000000001,25377.949344000001,36.78658110344827,24.632390804597701,36.94858620689655]
[5,5,"TT-2",null,62455.08,27851.550360000001,43.25,29.911436781609197,44.867155172413796,64328.732400000001,28285.1174508,44.355292074137935,30.808779885057472,46.213169827586206]
[6,6,"TT-3",null,70637.400000000009,29696.158800000001,48.05,33.830172413793107,50.745258620689661,72756.522000000012,30185.765874000001,49.301862008620695,34.845077586206905,52.267616379310354]
[7,7,"TE Intern",null,51244.560000000005,25322.88852,36.67,24.542413793103449,36.813620689655174,52781.896800000002,25681.582245599999,37.578294562068969,25.278686206896552,37.918029310344828]
[8,8,"PE -- TE-5",null,104887,37418,68.150000000000006,50.23323754789272,1E-3,108034,38138,70.005747126436788,51.740421455938694,1E-3]
[9,9,"APE -- TE-4",null,95011,35191,62.36,45.503352490421456,1E-3,97862,35846,64.036398467432946,46.86877394636015,1E-3]
[10,10,"Other"]
[11,0,"Select a Job Class"]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOTE - THIS INFORMATION IS FROM WSDOT PAYROLL SITE:  http://wwwi.wsdot.wa.gov/Budget/BudgetTools.htm "]