{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Liquidated Damages Calc Sheet","Example Form","Update Data"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":130,"n_cols":1,"rows_kept":130,"cut":false,"hidden":false,"merged":[[98,0,99,12],[129,0,133,12],[1,0,1,12],[30,0,40,12],[75,0,76,12],[2,0,17,12],[42,0,68,12],[83,0,91,12],[114,0,116,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 WSDOT Design-Bid-Build project for failure to complete the physical work within the allotted contract time. The Design Project Office 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 1-08.9.OPT3.FR1.  \n\nThe Design Project Engineer will provide the calculation sheet to the Construction Project Engineer near the 90% milestone to be populated.  The Construction Project Engineer will use their workforce projections, as well as any other available information, to fill out the calculation sheet. \nIt is recognized that work force fluctuates during the life of the project.  Review the work force for the duration of the project and select a day that best represents the staffing levels anticipated for the majority of the project.  Document the workforce assumptions in the Comments/Assumptions/Staffing Notes section at the bottom of the form.\n\nHints will pop-up when you hover over column titles in the worksheet to assist you in completing this form.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State Personnel "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This section is intended to capture labor charges for the project office staff, such as PE, APE, Inspectors, material testers, etc. and administration staff who directly support the projects, such as Office Engineer, change order writers, etc.  \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\nThe 18%-22% Overhead range is adequate for most projects, but if your project will include extensive support from a support group you may want to include the position(s) in the State Personnel section.\n\nIf the project will be using consultant support include the position(s) in the State Personnel section, including wage rates from the consultant agreement.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click the down arrow in the left column (under State Personnel) to select personnel that will be working on 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 three columns (Each, Hrs/Day & OverTime Hrs), the worksheet will automatically fill in the Hourly Rate, OT Rate and Daily Cost for each employee.  The Hourly Rate is a fully loaded rate.  OT Rate is straight rate times 1.5, and does not include benefits.\n\nIf a project requires additional labor from a support office, add those positions on a separate line by clicking on the “Add Personnel” box to the right of the Daily Cost column.  You will be asked to enter a row number where you want the line inserted, and the number of personnel you are adding. If three additional people are added, three lines will be added into the worksheet.\n\nFor those personnel positions that are not specifically listed in the pull-down menu, you can add them by typing the position name in the first column under “State Personnel” and add a description.   To find the labor pricing for those positions and calculate hourly rates from annual salaries and benefits, click “State Personnel” at the top of column 1 to access the WSDOT Budget & Financial website. Click on the Current biennium Labor Pricing Template, and select the most recently modified Labor Pricing Template.  \n\nTo use the Labor Pricing Template workbook - select the “Comp Plan” tab at the bottom of the workbook, where you can find a Job Class Code for each job classification. Enter this Job Class Code in the “Position Class Code” column on the “Data Entry tab.” Enter the Percent Time (i.e. 100% for full time, or part time at 20%, 30%, etc.). The Annual Salary and Benefits are displayed in the right-hand columns to use for calculating overtime and hourly rate.\n\nThe Hourly Rate for each job classification can be determined by adding together the “Salary” and “Benefits” and dividing the total by 2,088 hours.  The overtime rate (OT Rate) can be determined by multiplying the Salary (only) times 1.5 and dividing by 2,088 hours.\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.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Per Diem "]
[]
[]
[]
[]
["Enter the number of personnel that will be on per diem during the contract.  To find the current per diem rates for lodging and meals for each county, click on “Per Diem” on the left side of the per diem entry line."]
[]
[]
["Overhead"]
[]
[]
[]
[]
["\n“Subtotal” is the summation of labor and per diem.  “Subtotal including Overhead” is the Subtotal plus a factor of 18%-22%.  \nAccording to WSDOT’s Accounting Office, project office overhead ranges between 18% and 22%. For most projects 20% is a reasonable average.  \nFor projects that are relatively straight-forward 18% may be enough. For larger, more complex projects, projects that may require more support from specialty groups, located in an urban area, high traffic volumes, choosing a higher percentage may be more realistic.  Document those assumptions in the Comments/Assumptions/Staffing Notes section at the bottom of the form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Equipment"]
[]
[]
[]
[]
["If unique equipment is required for the project, such as Zipper Barrier or other highly specialized equipment, it may be listed in the Additional Equipment section.\n"]
[]
[]
["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 1-08.9.OPT3.FR1.\nProject Engineer will 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 Liquidated Damages Calculation Sheet will be kept in the Project File documentation in the region.\n"]

{"sheet":"Liquidated Damages Calc Sheet","index":1,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,11],[58,0,58,11],[46,1,46,11],[48,4,48,8],[50,6,50,8],[2,10,2,11],[4,2,5,11],[41,1,41,4],[2,4,2,7]]}
["        Design Liquidated Damages Calculation Sheet",null,null,null,null,null,null,null,null,null,null,null,null,"Rates updated 4/2025"]
[]
[null,"SR","123","   MP","100.10 to 120.20",null,null,null,"FA#",null,"NH-0123(456)"]
[]
[null,"Project Title","A street to B street - Paving"]
[]
[]
[null,"                   Liquidated Damages for Failure to Complete the Work or Portions of the Work On Time"]
[null,"For job classifications not listed, enter the \"Hourly Rate\" & \"OT Rate\" for each position"]
[null,"State Personnel","Column1","Column2","Column3","Each","Hrs/Day","OverTime Hrs","Hourly Rate","OT Rate","Daily Cost"]
[null,null,{"$f":"IF(B11<>\"\",\"Type desc. - i.e. elec. inspec.\",\"\")","v":""},null,null,{"$f":"IF(B11<>\"\",1,\"\")","v":""},null,{"$f":"IF(OR(B11=\"PE -- TE-5\",B11=\"APE -- TE-4\"),\"0\",\" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B11,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B11,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR((((G11*I11)*F11)+(J11*H11)*F11),\"--\")","v":"--"}]
[null,null,"",null,null,{"$f":"IF(B12<>\"\",1,\"\")","v":""},null,{"$f":"IF(OR(B12=\"PE -- TE-5\",B12=\"APE -- TE-4\"),\"0\",\" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B12,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B12,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR((((G12*I12)*F12)+(J12*H12)*F12),\"--\")","v":"--"}]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B13,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B13,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B14,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B14,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B15,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B15,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B16,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B16,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B17,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B17,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B18,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B18,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B19,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B19,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,{"$f":"IF(B20<>\"\",\"Type desc. - i.e. elec. inspec.\",\"\")","v":""},null,null,{"$f":"IF(B20<>\"\",1,\"\")","v":""},null," ",{"$f":"IFERROR(VLOOKUP( B20,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B20,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR((((G20*I20)*F20)+(J20*H20)*F20),\"--\")","v":"--"}]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B21,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B21,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B22,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B22,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B23,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B23,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B24,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B24,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B25,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B25,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B26,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B26,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B27,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B27,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B28,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B28,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B29,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B29,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B30,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B30,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B31,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B31,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B32,'Update Data'!$C$2:$G$13,5,FALSE), \".0001\")","v":".0001"},{"$f":"IFERROR(VLOOKUP( B32,'Update Data'!$C$2:$I$13,7,FALSE), \".0001\")","v":".0001"},"--"]
[null,null,null,null,null,null,"$ per day"]
[null,"Per Diem","Enter #  personnel Eligible →",null,null,0,null,null,null,null,{"$f":"F34*G34","v":0}]
[]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K32)","v":0}]
[null,"Subtotal including overhead costs calculated at",null,null,null,null,null,"→",0.2,"for this project",null,{"$f":"L36+K34+I39","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"L36*I37","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I37*L36","v":0}]
[null,"Additional Equipment: If a specialized piece of equipment for this project is needed, it may be added."]
[null,null,null,null,null,"Qty","Hrs/Day","OverTime Hrs","Hourly Rate","OT Rate","Daily Cost","Equipment Total"]
[null,null,null,null,null,null,null,null,null,{"$f":"(H42*I42)*1.5","v":0},{"$f":"IFERROR(((G42*I42)*F42)+J42,\"--\")","v":0},{"$f":"K42","v":0}]
[]
[null,null,"CALCULATED LIQUIDATED DAMAGES PER WORKING DAY =",null,null,null,null,null,null,null,null,{"$f":"L37+L42","v":0}]
[null,null,null,null,null,"Rounded to the nearest $50 →",null,null,null,null,null,{"$f":"MROUND(L44,50)","v":0}]
[]
[null,"File this worksheet in your Project File for documentation of calculation of Liquidated Damages.  \nThis document becomes proof in court that Liquidated Damages were reasonably calculated."]
[]
[null,"Use Special Provision",null,null,"1-08.9.OPT3.FR1"]
[]
[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,null,null,null,null,"Date"]
[]
["Comments / Assumptions / Staffing Notes:"]

{"sheet":"Example Form","index":2,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[48,4,48,8],[50,6,50,8],[58,0,58,11],[0,0,0,11],[2,4,2,7],[2,10,2,11],[4,2,5,11],[41,1,41,4],[46,1,46,11]]}
["        Design Liquidated Damages Calculation Sheet"]
[]
[null,"SR","123","   MP","100.10 to 120.20",null,null,null,"FA#",null,"NH-0123(456)"]
[]
[null,"Project Title","A street to B street - Paving"]
[]
[]
[null,"                   Liquidated Damages for Failure to Complete the Work or Portions of the Work On Time"]
[null,"For job classifications not listed, enter the \"Hourly Rate\" & \"OT Rate\" for each position"]
[null,"State Personnel","Column1","Column2","Column3","Each","Hrs/Day","OverTime Hrs","Hourly Rate","OT Rate","Daily Cost"]
[null,"TT-2","Density Inspection",null,null,{"$f":"IF(B11<>\"\",1,\"\")","v":1},8,2,{"$f":"IFERROR(VLOOKUP( B11,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":47.183256704980842},{"$f":"IFERROR(VLOOKUP( B11,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":49.631206896551717},{"$f":"IFERROR((((G11*I11)*F11)+(J11*H11)*F11),\"--\")","v":476.7284674329502}]
[null,"TT-2","Density Inspection",null,null,1,8,2,{"$f":"IFERROR(VLOOKUP( B12,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":47.183256704980842},{"$f":"IFERROR(VLOOKUP( B12,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":49.631206896551717},476.7284674329502]
[null,"TT-2","Street Inspection",null,null,1,8,2,{"$f":"IFERROR(VLOOKUP( B13,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":47.183256704980842},{"$f":"IFERROR(VLOOKUP( B13,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":49.631206896551717},476.7284674329502]
[null,"TE-3","Bridge Deck ",null,null,1,8,2,{"$f":"IFERROR(VLOOKUP( B14,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":62.048735632183906},{"$f":"IFERROR(VLOOKUP( B14,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":68.394224137931019},633.17833333333328]
[null,"TE Intern","Asst. Bridge Deck",null,null,1,8,2,{"$f":"IFERROR(VLOOKUP( B15,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":40.123682950191572},{"$f":"IFERROR(VLOOKUP( B15,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":40.721443965517246},402.43235153256705]
[null,"Other","Consultant ABC Electrical Inspec",null,null,1,8,2,55.5,60.05,564.1]
[null,"PE -- TE-5","Project Engineer",null,null,1,2,{"$f":"IF(OR(B17=\"PE -- TE-5\",B17=\"APE -- TE-4\"),\"0\",\" \")","v":"0"},{"$f":"IFERROR(VLOOKUP( B17,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":73.895095785440603},{"$f":"IFERROR(VLOOKUP( B17,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":1E-3},147.79019157088121]
[null,"APE -- TE-4","Asst. Project Engineer",null,null,1,2,"0",{"$f":"IFERROR(VLOOKUP( B18,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":67.676235632183904},{"$f":"IFERROR(VLOOKUP( B18,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":1E-3},135.35247126436781]
[null,null,{"$f":"IF(B19<>\"\",\"Type desc. - i.e. elec. inspec.\",\"\")","v":""},null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B19,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B19,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B20,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B20,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B21,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B21,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B22,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B22,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B23,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B23,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B24,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B24,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B25,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B25,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B26,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B26,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B27,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B27,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B28,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B28,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B29,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B29,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B30,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B30,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B31,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B31,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,"",null,null,"",null," ",{"$f":"IFERROR(VLOOKUP( B32,'Update Data'!$C$2:$G$13,5,FALSE), \" \")","v":" "},{"$f":"IFERROR(VLOOKUP( B32,'Update Data'!$C$2:$I$13,7,FALSE), \"\")","v":""},"--"]
[null,null,null,null,null,null,"$ per day"]
[null,"Per Diem","Enter #  personnel Eligible →",null,null,3,150,null,null,null,{"$f":"F34*G34","v":450}]
[]
[null,"Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K32)","v":3313.0387500000002}]
[null,"Subtotal including overhead costs calculated at",null,null,null,null,null,"→",0.2,null,null,{"$f":"L36+K34+I39","v":4425.6465000000007}]
[null,null,null,null,null,null,null,null,{"$f":"L36*I37","v":662.60775000000012}]
[null,null,null,null,null,null,null,null,{"$f":"I37*L36","v":662.60775000000012}]
[null,"Additional Equipment: If a specialized piece of equipment for this project is needed, it may be added."]
[null,null,null,null,null,"Qty","Hrs/Day","OverTime Hrs","Hourly Rate","OT Rate","Daily Cost","Equipment Total"]
[null,"Zipper Barrier Transfer Machine (BTM)",null,null,null,1,2,null,800,{"$f":"(H42*I42)*1.5","v":0},{"$f":"IFERROR(((G42*I42)*F42)+J42,\"--\")","v":1600},{"$f":"K42","v":1600}]
[]
[null,null,"CALCULATED LIQUIDATED DAMAGES PER WORKING DAY =",null,null,null,null,null,null,null,null,{"$f":"L37+L42","v":6025.6465000000007}]
[null,null,null,null,null,"Rounded to the nearest $50 →",null,null,null,null,null,{"$f":"MROUND(L44,50)","v":6050}]
[]
[null,"File this worksheet in your Project File for documentation of calculation of Liquidated Damages.  \nThis document becomes proof in court that Liquidated Damages were reasonably calculated."]
[]
[null,"Use Special Provision",null,null,"1-08.9.OPT3.FR1"]
[]
[null,"Insert Liquidated Damages, In the amount of   $ ",null,null,null,null,{"$f":"L45","v":6050},null,null,"  per working day"]
[]
[]
[null," Project  Engineer"]
[]
[]
[null,"Name",null,null,null,null,null,null,"Date"]
[]
["Comments / Assumptions / Staffing Notes:"]

{"sheet":"Update Data","index":3,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Quantity","Hours per day","Position ","PLACE HOLDER","2023 Annual Step L","Benefits","2023- Loaded Rate","2023- Regular Rate","2023- OT Rate","2024 Annual Step L","Benefits","2024- Loaded Rate","2024- Regular Rate","2024- OT Rate"]
[1,1,"TE-1",null,78131.34,31136,52.331101532567047,{"$f":"E2/2088","v":37.419224137931032},{"$f":"H2*1.5","v":56.128836206896551},80475,31452,{"$f":"(J2+K2)/2088","v":53.604885057471265},{"$f":"J2/2088","v":38.541666666666664},{"$f":"M2*1.5","v":57.8125}]
[2,2,"TE-2",null,86222.01,32660,56.935828544061302,{"$f":"E3/2088","v":41.294066091954022},{"$f":"H3*1.5","v":61.941099137931033},88809,33017,{"$f":"(J3+K3)/2088","v":58.345785440613028},{"$f":"J3/2088","v":42.533045977011497},{"$f":"M3*1.5","v":63.799568965517246}]
[3,3,"TE-3",null,95204.76,34353,62.048735632183906,45.596149425287351,68.394224137931019,98061,34756,63.609674329501914,46.964080459770116,70.446120689655174]
[4,4,"TT-1",null,55222.229999999996,26820,39.292255747126433,26.447428160919539,39.671142241379307,56879,27021,40.18199233716475,27.240900383141764,40.861350574712645]
[5,5,"TT-2",null,69086.64,29432,47.183256704980842,33.087471264367814,49.631206896551717,71159,29703,48.305555555555557,34.07998084291188,51.11997126436782]
[6,6,"TT-3",null,78131.34,31136,52.331101532567047,37.419224137931032,56.128836206896551,80475,31452,53.604885057471265,38.541666666666664,57.8125]
[7,7,"TE Intern",null,56684.25,27094,40.123682950191572,27.147629310344829,40.721443965517246,58385,27304,41.038793103448278,27.962164750957854,41.943247126436781]
[8,8,"PE -- TE-5",null,116019.95999999999,38273,73.895095785440603,55.56511494252873,1E-3,119501,38781,75.805555555555557,57.232279693486589,1E-3]
[9,9,"APE -- TE-4",null,105091.97999999998,36216,67.676235632183904,50.331408045977,1E-3,108245,36668,69.402777777777771,51.841475095785441,1E-3]
[10,10,"Other"]
[11,0,"Select a Job Class"]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["JOB CLASS LISTING LINK"]
["NOTE - THIS INFORMATION IS FROM WSDOT PAYROLL SITE:  https://wsdot.sharepoint.com/:u:/r/teams/EngineeringAnalysisOffice/Shared%20Documents/Estimating/Liquidated%20Damages/Salary%20Pricing%20Tool.url?csf=1&web=1&e=c27pCf"]