{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","Cost Factors","Cost Drivers Worksheet","Using Bid History Data","80-20 Rule -- Item Analysis","LS Example Worksheet","EXAMPLE Paving Estimate","LSTC Risk Assessment","CCI Inflation","Production Rates ","DATA"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":9,"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":"Intro","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 1 - Evaluate Factors Affecting Cost"]
[null,null,"What are the specific factors impacting your project ? "]
[null,null,"Market conditions, Site conditions, Materials and resources availability"]
[]
[null,"Step 2 - Using Bid History"]
[null,null,"Unit bid history is how most state DOTs create the Engineer's estimate"]
[null,null,"This tab will guide you though the basics of how to retrieve relevant data "]
[]
[null,"Step 3 - Bid Item Contribution, (80/20 rule)"]
[null,null,"Typically only about 20% of the bid items in a project comprise 80% of the cost, focus your efforts here."]
[null,null,"The most value to utilizing the 80/20 rule may be realized early in the project prior to having a detailed design"]
[null,null,"     Note:  High cost Lump Sum items should be evaluated by their composite parts"]
[]
[null,null,"LS Example Worksheet"]
[null,null,"This tab guides you through breaking down and analyzing the component parts of a high cost Lump Sum item"]
[]
[null,null,"Example Paving Estimate"]
[null,null,"The examples in this workbook are based on this estimate"]
[null,null,"It is provided here for reference and as a template for practice analysis"]
[]
[null,"Tools"]
[null,null,"These are tools that will help you to develop you unit bid prices"]

{"sheet":"Cost Factors","index":1,"n_rows":29,"n_cols":20,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Factors"]
[null,"The following are some factors that affect the cost of work in projects.\nThe cost of work may be higher or lower than average based on project specific conditions.\nClick on the Information button to learn more about each cost factor.","Use the fields below to record information about the specific conditions for your project"]
[null,"FACTORS AFFECTING COST","PROJECT CONDITIONS"]
["Click i to\nView/Close","PROJECT"]
[null,"Type","HMA - Paving",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"type"]
[null,"Project Size","$3M - $4M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"projectsize"]
[null,"Location (urban/rural) & Other Geographic Considerations","rural",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Location"]
[null,"Major Items of work -  quantity (small/large)","large",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"major"]
[null,"Haul Distance/Materials Sources","40 miles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"haul"]
[null,"Site Accessibility (can the equipment/people easily get in to perform the work)","easy access",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"site"]
[null,"Maintenance of Traffic ( one or many moves)","minor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"mot"]
[null,"Difficult Site conditions","no",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"conditions"]
[null,"TIMING"]
[null,"Multi Season Projects (multiple setup/tear-down, administrative costs)","20 working days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"seasons"]
[null,"Construction Season","summer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"conSeason"]
[null,"Timing of advertisement (late season - contractors booked or early - contractors looking for work)","Late winter AD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"ad"]
[null,"WORK and BIDDING"]
[null,"Mobilization considerations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"mob"]
[null,"Restrictions (nighttime work, noise, lane closures)","No restrictions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"restrictions"]
[null,"Bid Environment (bidding competition, amount of similar work, available qualified contractors)","nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"bid"]
[null,"Specifications/Plans Clarity","*** Remember to check these",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"specs"]
[null,"Materials Availability ( what's happened in the world to affect producers of materials)","Oil/Fuel/Binder prices rising",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"materials"]
[null,"Price Volatile Materials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"volatile"]
[null,"Subcontracted Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"subbed"]
[null,"First Time Use Items","none",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"first"]
[null,"Specialty Work",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"special"]
[null,"COST ESCALATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","cost"]
[null,"Project Scope & Scope Creep",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"creep"]
[null,"Inflation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"inflate"]

{"sheet":"Cost Drivers Worksheet","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Drivers Worksheet"]
[null,"Cost drivers Are the various work or activities that are associated with a project. The impact of these factors are cost drivers and can be minimal or significant and should be considered when developing the cost estimate",null,null,"Use this sheet to keep track of items that may need further evaluation for impacts to the cost estimate"]
[null,"Factor","Is this a cost driver for the project?","Does it have a major impact?","Comments about cost driver impacts"]
[null,"Project Size"]
[null,"Location "]
[null,"Major Items of work -  quantity"]
[null,"Haul Distance/Materials Sources"]
[null,"Site Accessibility"]
[null,"Maintenance of Traffic"]
[null,"Difficult Site conditions"]
[null,"Multi Season Project"]
[null,"Construction Season"]
[null,"Timing of advertisement"]
[null,"Mobilization considerations"]
[null,"Work Restrictions"]
[null,"Bid Environment - competition"]
[null,"Specifications/Plans Clarity"]
[null,"Materials Availability"]
[null,"Price Volatile Materials"]
[null,"Subcontracted Items"]
[null,"First Time Use Items"]
[null,"Specialty Work"]
[]
[null,"* Add others as needed"]

{"sheet":"Using Bid History Data","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"80-20 Rule -- Item Analysis","index":4,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Section","Item Number","Standard Item Number","Item Description","QUANTITY ","Unit of Measure","Unit Price","Total"]
[null,"Hot Mix Asphalt",9,"5766","HMA CL. 3/8 IN. PG 64H-28",16680,"TON ",82,1367760]
[null,"Hot Mix Asphalt",7,"5711","PLANING BITUMINOUS PAVEMENT ",153400,"S.Y.",2,306800]
[null,"Traffic",31,"6971","PROJECT TEMPORARY TRAFFIC CONTROL  ",250000,"L.S.",1,265000]
[null,"Preparation",1,"0001","MOBILIZATION ",182900,"L.S.",1,182900]
[null,"Hot Mix Asphalt",15,"6518","SMOOTHNESS COMPLIANCE ADJUSTMENT ",124000,"CALC",1,124000]
[null,"Hot Mix Asphalt",11,"5835","COMPACTION PRICE ADJUSTMENT ",68400,"CALC",1,68400]
[null,"Hot Mix Asphalt",13,"NS","JOINT ADHESIVE FOR BITUMINOUS PAVEMENT",53300,"L.F.",1,53300]
[null,"Hot Mix Asphalt",10,"5830","JOB MIX COMPLIANCE PRICE ADJUSTMENT ",41100,"CALC",1,41100]
[null,"Hot Mix Asphalt",12,"5837","ASPHALT COST PRICE ADJUSTMENT ",27700,"CALC",1,27700]
[null,"Other Items",44,"7038","ROADWAY SURVEYING ",25000,"L.S.",1,{"$f":"H30*F30","v":25000}]
[null,"Traffic",30,"6895","TEMPORARY PAVEMENT MARKING-SHORT DURATION ",163000,"L.F.",0.15,{"$f":"H31*F31","v":24450}]
[null,"Traffic",26,"6806","PAINT LINE ",162891,"L.F.",0.15,{"$f":"H32*F32","v":24433.649999999998}]
[null,"Hot Mix Asphalt",8,"5738","HMA FOR PAVEMENT REPAIR CL. 3/8 IN. PG 64H-28",170,"TON ",140,23800]
[null,"Traffic",41,"6982","CONSTRUCTION SIGNS CLASS A ",964,"S.F.",13,{"$f":"H34*F34","v":12532}]
[null,"Hot Mix Asphalt",6,"5701","CRACK SEALING-CM ",10.3,"CM  ",1200,12360]
[null,"Traffic",23,"6780","REMOVING AND RESETTING BEAM GUARDRAIL ",563,"L.F.",20,{"$f":"H36*F36","v":11260}]
[null,"Traffic",25,"6832","FLEXIBLE GUIDE POST ",368,"EACH",30,{"$f":"H37*F37","v":11040}]
[null,"Traffic",29,"6893","CENTERLINE RUMBLE STRIP ",10.4,"MI. ",1000,{"$f":"H38*F38","v":10400}]
[null,"Surfacing",4,"5020","BALLAST ",270,"TON ",30,8100]
[null,"Traffic",20,"6727","EXTRUDED CURB ",395,"L.F.",15,5925]
[null,"Other Items",46,"7480","ROADSIDE CLEANUP ",5000,"EST.",1,{"$f":"H41*F41","v":5000}]
[null,"Traffic",24,"7450","REPAIR TRANSPORTABLE ATTENUATOR ",4000,"EST.",1,{"$f":"H42*F42","v":4000}]
[null,"Erosion Control",17,"6471","INLET PROTECTION ",36,"EACH",90,3240]
[null,"Grading",3,"0332","PAVEMENT REPAIR EXCAVATION INCL. HAUL ",270,"S.Y.",10,2700]
[null,"Other Items",47,"7490","TRIMMING AND CLEANUP ",2500,"L.S.",1,{"$f":"H45*F45","v":2500}]
[null,"Erosion Control",18,"6479","WATTLE ",475,"L.F.",5,2375]
[null,"Other Items",52,"7530","CONSTRUCTION GEOTEXTILE FOR SEPARATION ",520,"S.Y.",4,{"$f":"H47*F47","v":2080}]
[null,"Erosion Control",19,"6490","EROSION/WATER POLLUTION CONTROL ",2000,"EST.",1,2000]
[null,"Surfacing",5,"5100","CRUSHED SURFACING BASE COURSE ",70,"TON ",25,1750]
[null,"Traffic",42,"6750","BEAM GUARDRAIL POST ",10,"EACH",135,{"$f":"H50*F50","v":1350}]
[null,"Traffic",21,"NS","REMOVING AND RESETTING GUARDRAIL BLOCKS",113,"L.F.",10,1130]
[null,"Preparation",2,"0185","REMOVING GUIDE POST ",220,"EACH",5,1100]
[null,"Other Items",51,"7736","SPCC PLAN ",1000,"L.S.",1,{"$f":"H53*F53","v":1000}]
[null,"Erosion Control",16,"6403","ESC LEAD ",8,"DAY ",75,600]
[null,"Traffic",22,"6755","BEAM GUARDRAIL BLOCK ",15,"EACH",30,450]
[null,"Other Items",45,"3100","ADJUST CATCH BASIN ",1,"EACH",450,{"$f":"H56*F56","v":450}]
[null,"Traffic",27,"6859","PLASTIC STOP LINE ",29,"L.F.",15,{"$f":"H57*F57","v":435}]
[null,"Traffic",28,"6833","PLASTIC TRAFFIC ARROW ",2,"EACH",150,{"$f":"H58*F58","v":300}]
[null,"Traffic",43,"6817","PAINTED WIDE LINE ",454,"L.F.",0.3,{"$f":"H59*F59","v":136.19999999999999}]
[null,"Other Items",48,"7725","REIMBURSEMENT FOR THIRD PARTY DAMAGE ",5,"EST.",1,{"$f":"H60*F60","v":5}]
[null,"Hot Mix Asphalt",14,"6516","CYCLIC DENSITY PRICE ADJUSTMENT ",-1,"CALC",1,-1]
[null,"Other Items",49,"7728","MINOR CHANGE ",-1,"CALC",1,{"$f":"H62*F62","v":-1}]
[null,"Other Items",50,"7732","AGGREGATE COMPLIANCE PRICE ADJUSTMENT ",-1,"CALC",1,{"$f":"H63*F63","v":-1}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table19[Total])","v":2638858.85}]

{"sheet":"LS Example Worksheet","index":5,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,11,2,16],[2,4,2,6],[1,0,1,9]]}
[]
["NOTE: A lump sum item can be used to pay for temporary traffic control when an assessment of the cost risk associated with that approach indicates that the traffic control operation is sufficiently well defined.  See Design Manual chapter 1010.10(3) and LSTC Risk Index tool to determine if lump sum traffic control is appropriate for your project."]
[null,"PROJECT SPECIFIC FACTORS\n• 30 Working Days\n• Moderate Traffic density\n• Some one-direction traffic switching",null,null,"Bid Tabs Pro Bid History Data Analysis",null,null,"Use this Adjusted \nUnit Price\nfor estimate considering\nproj. specific factors ↓↓↓"]
[null,"ITEM","STD. ITEM NO.","UNITS","High\nPrice","Low\nPrice","Weighted AVG\nPrice","UNIT PRICE","QUANTITY","AMOUNT",null,"Applied factors for bid history  price adjustment regarding"]
[null,"LUMP SUM TRAFFIC CONTROL",9671,null,null,null,null,null,null,null,null,"• Location"]
[null,"TRANSPORTABLE ATTENUATOR",7447,"HOUR",17000,9300,12400,12500,1,{"$f":"H6*I6","v":12500},null,"• Fuel price escalation"]
[null,"OPERATION OF TRUCK MOUNTED IMPACT ATTENUATOR",7449,"HOUR",85,72,80,82,200,16400,null,"• Labor availability"]
[null,"FLAGGERS",6980,"HOUR",90,60,78,75,500,37500,null,"• Age of bid data available"]
[null,"OTHER TRAFFIC CONTROL LABOR",6992,"HOUR",90,60,78,75,400,30000]
[null,"TRAFFIC CONTROL SUPERVISOR",6972,"HOUR",105,80,95,103,240,24720]
[null,"CONSTRUCTION SIGNS CLASS A",6982,"S.F.",30,16,19,20,672,13440]
[null,"TEMPORARY TRANSVERSE RUMBLE STRIPS","NS","L.F.","See note","See note","See note",30,48,1440,null,"NOTE: Contacted industry for cost + labor, equipment & materials"]
[null,"TEMPORARY CONCRETE BARRIER",6781,"L.F.",22,10,16,85,1500,127500,null,"              overhead and profit figures from RSMeans"]
[null,"SEQUENTIAL ARROW SIGN",6956,"Hour",7,2,4.5,5.5,240,1320]
[]
[]
[null,null,null,"Total for estimate →",null,null,null,null,null,{"$f":"SUM(J6:J14)","v":264820}]

{"sheet":"EXAMPLE Paving Estimate","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Section","Item Number","Standard Item Number","Item Description","QUANTITY ","Unit of Measure","Unit Price","Total","   Typical Paving Estimate"]
["Preparation",1,"0001","MOBILIZATION ",182900,"L.S.",1,182900]
["Preparation",2,"0185","REMOVING GUIDE POST ",220,"EACH",5,1100]
["Grading",3,"0332","PAVEMENT REPAIR EXCAVATION INCL. HAUL ",270,"S.Y.",10,2700]
["Surfacing",4,"5020","BALLAST ",270,"TON ",30,8100]
["Surfacing",5,"5100","CRUSHED SURFACING BASE COURSE ",70,"TON ",25,1750]
["Hot Mix Asphalt",6,"5701","CRACK SEALING-CM ",10.3,"CM  ",1200,12360]
["Hot Mix Asphalt",7,"5711","PLANING BITUMINOUS PAVEMENT ",153400,"S.Y.",2,306800]
["Hot Mix Asphalt",8,"5738","HMA FOR PAVEMENT REPAIR CL. 3/8 IN. PG 64H-28",170,"TON ",140,23800]
["Hot Mix Asphalt",9,"5766","HMA CL. 3/8 IN. PG 64H-28",16680,"TON ",82,1367760]
["Hot Mix Asphalt",10,"5830","JOB MIX COMPLIANCE PRICE ADJUSTMENT ",41100,"CALC",1,41100]
["Hot Mix Asphalt",11,"5835","COMPACTION PRICE ADJUSTMENT ",68400,"CALC",1,68400]
["Hot Mix Asphalt",12,"5837","ASPHALT COST PRICE ADJUSTMENT ",27700,"CALC",1,27700]
["Hot Mix Asphalt",13,"NS","JOINT ADHESIVE FOR BITUMINOUS PAVEMENT",53300,"L.F.",1,53300]
["Hot Mix Asphalt",14,"6516","CYCLIC DENSITY PRICE ADJUSTMENT ",-1,"CALC",1,-1]
["Hot Mix Asphalt",15,"6518","SMOOTHNESS COMPLIANCE ADJUSTMENT ",124000,"CALC",1,124000]
["Erosion Control",16,"6403","ESC LEAD ",8,"DAY ",75,600]
["Erosion Control",17,"6471","INLET PROTECTION ",36,"EACH",90,3240]
["Erosion Control",18,"6479","WATTLE ",475,"L.F.",5,2375]
["Erosion Control",19,"6490","EROSION/WATER POLLUTION CONTROL ",2000,"EST.",1,2000]
["Traffic",20,"6727","EXTRUDED CURB ",395,"L.F.",15,5925]
["Traffic",21,"NS","REMOVING AND RESETTING GUARDRAIL BLOCKS",113,"L.F.",10,1130]
["Traffic",22,"6755","BEAM GUARDRAIL BLOCK ",15,"EACH",30,450]
["Traffic",23,"6780","REMOVING AND RESETTING BEAM GUARDRAIL ",563,"L.F.",20,{"$f":"G24*E24","v":11260}]
["Traffic",24,"7450","REPAIR TRANSPORTABLE ATTENUATOR ",4000,"EST.",1,4000]
["Traffic",25,"6832","FLEXIBLE GUIDE POST ",368,"EACH",30,11040]
["Traffic",26,"6806","PAINT LINE ",162891,"L.F.",0.15,24433.649999999998]
["Traffic",27,"6859","PLASTIC STOP LINE ",29,"L.F.",15,435]
["Traffic",28,"6833","PLASTIC TRAFFIC ARROW ",2,"EACH",150,300]
["Traffic",29,"6893","CENTERLINE RUMBLE STRIP ",10.4,"MI. ",1000,10400]
["Traffic",30,"6895","TEMPORARY PAVEMENT MARKING-SHORT DURATION ",163000,"L.F.",0.15,24450]
["Traffic",31,"6971","PROJECT TEMPORARY TRAFFIC CONTROL ",265000,"L.S.",1,265000]
["Traffic",41,"6982","CONSTRUCTION SIGNS CLASS A ",964,"S.F.",13,12532]
["Traffic",42,"6750","BEAM GUARDRAIL POST ",10,"EACH",135,1350]
["Traffic",43,"6817","PAINTED WIDE LINE ",454,"L.F.",0.3,136.19999999999999]
["Other Items",44,"7038","ROADWAY SURVEYING ",25000,"L.S.",1,25000]
["Other Items",45,"3100","ADJUST CATCH BASIN ",1,"EACH",450,450]
["Other Items",46,"7480","ROADSIDE CLEANUP ",5000,"EST.",1,5000]
["Other Items",47,"7490","TRIMMING AND CLEANUP ",2500,"L.S.",1,2500]
["Other Items",48,"7725","REIMBURSEMENT FOR THIRD PARTY DAMAGE ",5,"EST.",1,5]
["Other Items",49,"7728","MINOR CHANGE ",-1,"CALC",1,-1]
["Other Items",50,"7732","AGGREGATE COMPLIANCE PRICE ADJUSTMENT ",-1,"CALC",1,-1]
["Other Items",51,"7736","SPCC PLAN ",1000,"L.S.",1,1000]
["Other Items",52,"7530","CONSTRUCTION GEOTEXTILE FOR SEPARATION ",520,"S.Y.",4,2080]
["Total",null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1[Total])","v":2638858.85}]

{"sheet":"LSTC Risk Assessment","index":7,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[20,12,24,12],[26,12,30,12],[32,12,36,12],[3,3,3,9],[4,3,4,5],[0,1,0,10],[16,1,16,10],[1,1,1,10],[17,1,17,6],[11,1,15,10]]}
[null,"Washington State Department of Transportation"]
[null,"Lump Sum Traffic Control Risk Assessment"]
[]
[null,"Project Title:"]
[null,"CN Cost Est:"]
[]
[null,"SR",null,"Begin MP",null,"End MP",null,"Length:",{"$f":"G7-E7","v":0},"miles"]
[null,"SR",null,"Begin MP",null,"End MP",null,"Length:",{"$f":"G8-E8","v":0},"miles"]
[null,"SR",null,"Begin MP",null,"End MP",null,"Length:",0,"miles"]
[]
[null,"Brief Project Description:"]
[null,"Please provide a brief description of this project"]
[]
[]
[]
[]
[]
[null,"Considerations",null,null,null,null,null,null,null,"Risk Rating for this item","Explanation For Rating and \nMitigation Measures Implemented",null,"Select from this List for topic Scoring Information"]
[null,1,"Contract Duration and Schedule",null,null,null,null,null,null,null,null,null,"↑↑ Click Above to select from the drop-down list for information about scoring each of the items to be considered ↑↑     k"]
[null,"1a","Contract Duration",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures",null,"Scoring Notes"]
[null,"1b","Contract  Schedule",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures",null,{"$f":"VLOOKUP('LSTC Risk Assessment'!M18,DATA!B3:E20,2, FALSE)","v":"Scoring notes"}]
[null,2,"Construction stages"]
[null,"2a","Number of construction stages",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,3,"Traffic Control Needs"]
[null,"3a","Intersection Closures",null,null,null,null,null,null,"Rate 0 to 20","Provide an explanation for rating and any mitigation measures"]
[null,"3b"," Interchange Closures",null,null,null,null,null,null,"Rate 0 to 20","Provide an explanation for rating and any mitigation measures",null,"Items for Consideration"]
[null,"3c"," Rolling Slowdowns",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures",null,{"$f":"VLOOKUP('LSTC Risk Assessment'!M18,DATA!B3:E20,3, FALSE)","v":"Items For Consideration"}]
[null,"3d","Mainline Closures",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,"3e","Other High Impact Closures",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,"3f","Closure Approval By Others",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,"3g","Transit Impacts",null,null,null,null,null,null,"Rate 0 to 5","Provide an explanation for rating and any mitigation measures"]
[null,"3h","Pedestrian Route Closures",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures",null,"Possible Mitigation"]
[null,"3i","Bicycle Route Closures",null,null,null,null,null,null,"Rate 0 to 5","Provide an explanation for rating and any mitigation measures",null,{"$f":"VLOOKUP('LSTC Risk Assessment'!M18,DATA!B3:E20,4, FALSE)","v":"Possible Mitigation"}]
[null,"3j","Traffic Control Provided for Others",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,"3k","Multiple Shifts (day & night)",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,"3l","Roadway Detours",null,null,null,null,null,null,"Rate 0 to 20","Provide an explanation for rating and any mitigation measures"]
[null,4,"Traffic Control Plans"]
[null,"4a","Is the contract missing traffic control plans?",null,null,null,null,null,null,"Rate 0 to 20","Provide an explanation for rating and any mitigation measures"]
[null,"4b","Does the contract have significant number of TC plan",null,null,null,null,null,null,"Rate 0 to 10","Provide an explanation for rating and any mitigation measures"]
[null,null,null,null,null,null,null,null,"Project Risk Level →",{"$f":"IFERROR(SUM(J20:J39),\"0\")","v":0},{"$f":"IF(J40>=105,\"Not a good candidate for LSTC\",IF(J40<=35,\"This is a Good Candidate for LSTC\",IF(AND(J40>35,J40<=70),\"Consider LSTC with minor mitigation\",IF(AND(J40>70,J40<105),\"Use bid items or LSTC with mitigation\"))))","v":"This is a Good Candidate for LSTC"}]

{"sheet":"CCI Inflation","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Construction Cost Index Calculator"]
[]
[]
[]
[]
[]
[]
[null,"INDEX CALCULATOR"]
[null,"Item Unit Cost",10,null,"← ENTER - Unit cost to be inflated to current dollars"]
[]
[null,"Current Index number",115.5,null,"← ENTER - CCI index number at the time of this estimate"]
[null,"Index number for unit price used",110,null,"← ENTER - CCI index number at the time of the unit price being utilized"]
[]
[null,"Item Cost multiplier",{"$f":"C11/C12","v":1.05},null,"← Your old cost data will be inflated by this multiplier to bring it to current year dollars"]
[]
[null,"= Todays $ Item Unit Cost",{"$f":"C9*C14","v":10.5},null,"← This is your item unit cost in todays dollars"]

{"sheet":"Production Rates ","index":9,"n_rows":177,"n_cols":6,"rows_kept":177,"cut":false,"hidden":false,"merged":[[5,5,5,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,7],[1,0,1,7],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,3,7],[4,0,4,7],[17,0,17,7],[18,5,18,7],[19,5,19,7],[20,0,20,7],[21,5,21,7],[22,5,22,7],[11,0,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,7],[16,5,16,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[23,0,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[41,5,41,7],[42,5,42,7],[43,5,43,7],[44,5,44,7],[45,5,45,7],[46,5,46,7],[35,5,35,7],[36,5,36,7],[37,0,37,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[53,5,53,7],[54,5,54,7],[55,5,55,7],[56,5,56,7],[57,5,57,7],[58,5,58,7],[47,5,47,7],[48,5,48,7],[49,5,49,7],[50,0,50,7],[51,5,51,7],[52,5,52,7],[65,5,65,7],[66,5,66,7],[67,5,67,7],[68,5,68,7],[69,5,69,7],[70,5,70,7],[59,5,59,7],[60,5,60,7],[61,0,61,7],[62,5,62,7],[63,5,63,7],[64,5,64,7],[77,5,77,7],[78,5,78,7],[79,5,79,7],[80,5,80,7],[81,5,81,7],[82,5,82,7],[71,5,71,7],[72,0,72,7],[73,5,73,7],[74,5,74,7],[75,5,75,7],[76,5,76,7],[89,0,89,7],[90,5,90,7],[91,5,91,7],[92,5,92,7],[93,0,93,7],[94,5,94,7],[83,0,83,7],[84,5,84,7],[85,5,85,7],[86,5,86,7],[87,5,87,7],[88,5,88,7],[101,5,101,7],[102,5,102,7],[103,5,103,7],[104,5,104,7],[105,5,105,7],[106,5,106,7],[95,5,95,7],[96,5,96,7],[97,5,97,7],[98,5,98,7],[99,5,99,7],[100,5,100,7],[113,0,113,7],[114,5,114,7],[115,5,115,7],[116,5,116,7],[117,5,117,7],[118,5,118,7],[107,5,107,7],[108,5,108,7],[109,5,109,7],[110,5,110,7],[111,5,111,7],[112,5,112,7],[125,5,125,7],[126,5,126,7],[127,5,127,7],[128,0,128,7],[129,5,129,7],[130,5,130,7],[119,5,119,7],[120,5,120,7],[121,5,121,7],[122,0,122,7],[123,5,123,7],[124,5,124,7],[137,5,137,7],[138,5,138,7],[139,5,139,7],[140,5,140,7],[141,5,141,7],[142,5,142,7],[131,5,131,7],[132,0,132,7],[133,5,133,7],[134,5,134,7],[135,5,135,7],[136,5,136,7],[149,1,149,5],[149,6,149,7],[150,1,150,5],[150,6,150,7],[151,1,151,5],[151,6,151,7],[143,5,143,7],[144,5,144,7],[146,0,146,7],[147,1,147,5],[147,6,147,7],[148,1,148,5],[148,6,148,7],[155,1,155,5],[155,6,155,7],[156,1,156,5],[156,6,156,7],[157,1,157,5],[157,6,157,7],[152,1,152,5],[152,6,152,7],[153,1,153,5],[153,6,153,7],[154,1,154,5],[154,6,154,7],[161,1,161,5],[161,6,161,7],[162,1,162,5],[162,6,162,7],[163,1,163,5],[163,6,163,7],[158,1,158,5],[158,6,158,7],[159,1,159,5],[159,6,159,7],[160,1,160,5],[160,6,160,7],[169,1,169,5],[169,6,169,7],[176,1,176,5],[176,6,176,7],[177,1,177,5],[178,1,178,5],[164,1,167,5],[164,6,164,7],[165,6,165,7],[166,6,166,7],[167,6,167,7],[168,1,168,5],[168,6,168,7],[185,1,185,5],[186,1,186,5],[187,1,187,5],[188,1,188,5],[190,1,190,5],[191,1,191,5],[179,1,179,5],[180,1,180,5],[181,1,181,5],[182,1,182,5],[183,1,183,5],[184,1,184,5],[198,1,198,5],[199,1,199,5],[200,1,200,5],[201,1,201,5],[202,1,202,5],[192,1,192,5],[193,1,193,5],[194,1,194,5],[195,1,195,5],[196,1,196,5],[197,1,197,5]]}
["Source: Federal Lands"]
[" PRODUCTION RATES - ENGLISH"]
["Activity","Unit","Typical Production Rate ",null,null,"Notes for Production Rates"]
[null,null,"Low","Average","High"]
["MOBILIZATION"]
["Projects less than $1 million","Day",null,3]
["Major bridge project","Day",14,26,28]
["Paving only project","Day",2,3,5]
["Grading only / Minor Earthwork","Day",4,10,20]
["Grading and paving / Major Earthwork","Day",7,12,20]
["Grading, paving and bridge project","Day",12,17,22]
["SURVEY AND STAKING"]
["Verify FHWA control","Day",1,2,3]
["Stake centerline","LF",1600,3200,4800,"Use lower rates for smaller projects"]
["Slope, Reference and Clearing Stakes","LF",600,800,1600,"Use higher rates for flat, lightly/non-vegetated terrain"]
["Grade finishing stakes","LF",800,1600,2400,"Use lower rates for smaller projects; rates represent one course of aggregate (ie: red tops, blue tops, etc); include time for survey of each aggregate course; use higher rates where Machine Guidance is anticipated (ie: large linear projects)"]
["Stake drainage structure/device","EA",4,8,16,"Rate will depend on size and type of structure/device, project topography, and proximity of each structure to each other (ie: will the surveyor have to relocate base station multiple times?)"]
["EROSION CONTROL"]
["Silt fence / Wattles","LF",200,1000,1700,"Use lower rates for excessive boulders and heavy trees, steep terrain."]
["Matting","SY",600,1800,2800,"Use lower rates for isolated small areas, oddly shaped, etc."]
["CLEARING & GRUBBING"]
["Projects with a lot of large trees,\nrugged terrain, or heavy brush","AC",0.3,1.3,2.7]
["Projects with fewer large trees,\nflatter terrain, or less heavy brush","AC",1,3,6]
["EARTHWORK"]
["Strip and stockpile topsoil","CY",300,700,1200,"Use lower rates for excessive boulders and steep terrain, smaller projects, and long haul to stockpile location. "]
["Subexcavation\n(no shoring or dewatering needed)",null,null,null,null,"Use 14 days when cofferdam required, minimum."]
["1' to 5' deep","CY",125,325,500,"Rates from RS Means."]
["5' to 10' deep","CY",225,600,1000,"Rates from RS Means."]
["Roadway Excavation"]
["Projects with less than\n50,000 CY of earthwork\nor haul distance of 5 miles or more","CY",400,1600,2500,"Note 2.  Also consider number of sites (ie: will multiple sites be in production at once?)"]
["Projects with more than\n50,000 CY of earthwork","CY",1200,2800,4500,"Note 2.  Also consider number of sites (ie: will multiple sites be in production at once?)"]
["Rock excavation by hammer","CY",80,240,640,"Rates from RS Means.  Use on jobs with minor rock cuts or where blasting is not permitted"]
["Rock excavated by ripping","CY",300,900,1500,"Use lower rates for harder, yet rippable, rock.  Use higher rates for softer rock. "]
["Rock excavated by blasting","CY",150,250,400,"Use lower rates for difficult access and harder rock; these prod. Rates include pioneering, drilling, blasting, loading and haul away activities but do not include scaling "]
["Structure Excavation (most soils)","CY",60,120,180,"Rates from RS Means"]
["Structure Excavation (sand/gravel)","CY",100,160,220,"Rates from RS Means"]
["Embankment Construction","CY",250,1100,2600,"Note 2"]
["REMOVALS"]
["PCC pavement","SY",500,1000,2500,"Reduce rates for lower quantity and increased pavement depth. "]
["Asphalt pavement","SY",500,3500,8000,"Reduce rates for lower quantity and increased pavement depth; rates are based on milled/pulverized removal rates"]
["Roadway Obliteration","SY",80,400,1500,"Rates will vary depending on how much work is required to return it to the original condition.  Large areas with simple horizontal and vertical geometry will have a production rate up to 1500 SY/day.  Areas that require additional fill or projects with multiple small obliteration sites will have lower production rates. "]
["Concrete curb & gutter","LF",200,360,1100,"Rate will vary based on quantity, dimensions, and condition of curb/gutter to be removed"]
["Sidewalk","SY",100,600,1200,"site conditions must be considered:  rate will increase significantly if material can be removed with a equipment operated hammer vs. labor operated hammer"]
["Guardrail","LF",310,600,870]
["Pipe <36\" diameter","LF",120,240,360]
["Pipe >36\" diameter","LF",95,150,270]
["Pavement Cutting (AC)","LF",800,1600,2400,"As depth increases, reduce rates."]
["Pavement Cutting (PCC)","LF",800,1600,2400,"As depth increases, reduce rates."]
["Structures, minor","DAY",5,10,20]
["Structures, major","DAY",1,3,5]
["DRAINAGE"]
["Box culvert, Cast-in-place","LF",2,10,16,"Prod. Rates include forming, tieing, casting and stripping but do not include excavation or backfill.  Site specific conditions (box size, traffic requirements, existing structure removal, foundation, dewatering, etc…) should also be considered."]
["Box culvert, Precast","LF",40,70,140,"Prod. Rates include placement only.  Excavation, and backfill/compaction, off-site production times and transportation should be considered as well.  Site specific conditions (box size, traffic requirements, existing structure removal, foundation, dewatering, etc…) should also be considered."]
["Inlets and manholes, new or adjust","EA",1,2,3,"As Total in a Line increases, increase production. Pre cast, use higher rate. "]
["Pipe culvert, 24\" and smaller","LF",40,80,120,"Redo rates for sliver fills, deep fills, rocky soil, smaller projects.  Consider traffic volume. Under average conditions, assume 1 installation per day per crew."]
["Pipe culvert, 30\" to 42\"","LF",30,70,100,"Reduce rates for sliver fills, deep fills, rocky soil, smaller projects.  Consider traffic volume. Under average conditions, assume 1 installation per day per crew."]
["Pipe culvert, 48\" and larger","LF",20,55,80,"Reduce rates for sliver fills, deep fills, rocky soil, smaller projects.  Consider traffic volume. Under average conditions, assume 1 installation per day per crew."]
["Riprap, aprons","CY",20,40,60,"Reduce rates for rocky soil, steep sliver fills, smaller projects."]
["Riprap lined ditches","LF",100,200,300,"Reduce rates for rocky soil, steep sliver fills, smaller projects."]
["Underdrain","LF",200,400,800,"Reduce rates for rocky soil, smaller projects, and large trenches dimensions."]
["Wingwall/Headwall","SF",14,35,90,"Unit is for exposed face sqft; rates are for minor drainage structures; as wall area increases, increase production rates; add 7 days for cure and backfill."]
["SUBGRADE AND BASE"]
["Subgrade stabilization, lime","SY",900,4000,6000,"Rates includes scarification and compaction efforts; As application area increases, increase production rate. "]
["Subgrade stabilization, cement","SY",900,4000,5000,"Rates includes scarification and compaction efforts; As application area increases, increase production rate. "]
["Subgrade stabilization, asphalt","SY",900,3000,null,"Limited data available; Rates includes scarification and compaction efforts"]
["Recycling, Cold In Place","SY",null,12000,15000,"Limited data available"]
["Asphalt Pavement Milling","SY",2000,3000,6500]
["Pulverizing","SY",2000,4000,12500,"reduce rates if pulverizing deeper than 3\" "]
["Aggregate Base","TONS",400,1000,1800,"rates include lay down but do not include final grading operations; consider project specific conditions; these activities may be combined with smaller quantities"]
["Aggregate Shoulder","CY",100,350,500]
["Cement Treated Base","SY",1940,4050,5920,"As quantity increases, increase production rate. Allow for sequencing of one lane at a time and curing."]
["Finishing Subgrade/Base Course/Surface Course","LF",500,1000,2000,"Rates are for two lanes; rates do not include survey time; rates represent one course (ie: red tops, blue tops, etc); decrease rates for rocky subgrade; increase rates if it is anticipated that AMG will be used (larger projects);"]
["PAVING"]
["Asphalt paving (HACP)","TONS",550,1000,1700,"Note 2"]
["Asphalt surface treatment (fog seal)","TONS",3,20,58,"Project specific restrictions should be closely considered; increase rates as quantity increases, and where traffic passage can be limited/eliminated"]
["Prime coat","SY",3900,10000,20000,"Production rate will typically be controlled by Asphalt paving production rate"]
["Tack coat","TONS",1,3,8,"Production rate will typically be controlled by Asphalt paving production rate"]
["Paved Ditch","SY",250,500,750,"Rates dependent upon difficulty of paving, based on accessibility, ditch dimensions and continuous ditch length.  Longer ditches will generally have higher production rates. "]
["Portland Cement Concrete Pavement (slip forming)","SY",460,2500,5000,"Slip forming, increase production rates with increase in paving length; production rate varies significantly based on pavement depth. "]
["Portland Cement Concrete Pavement (conventional forming)","SY",20,300,600,"Conventional forming; sharp curves and angles decrease production; note: slip form concrete paving will have significantly higher production rates; use RS Means if slip form paving is anticipated (ie: for vary large concrete paving projects). "]
["Chip Seal","SY",2500,13500,21000,"Add one day to complete brooming"]
["Approach roads, minor HACP","TONS",80,250,350]
["Full Depth Patch","SY",60,160,400,"Project specific conditions should be considered; Larger sites will yield higher rates; smaller multiple sites will yield lower rates"]
["CURBS, GUTTERS, AND SIDEWALK"]
["Curb & Gutter, Concrete","LF",160,480,900,"Reduce rates for hand mixed/placed"]
["Curb, Concrete","LF",160,480,900,"Reduce rates for hand mixed/placed."]
["Curb, Bituminous","LF",650,1200,1850]
["Curb, Stone","LF",50,100,150,"Limited data available"]
["Sidewalks, Concrete","SY",80,160,280]
["GUARDRAIL AND GUARDWALL"]
["W-beam or box beam guardrail","LF",250,500,1000,"Use lower rates for stiff/rocky soils."]
["Steel Backed Timber guardrail","LF",null,600,null,"Limited data available"]
["Cable guardrail","LF",null,800,null,"Limited data available"]
["BRIDGES AND STRUCTURES"]
["Cofferdams","SY",100,200,300,"Limited Data available; increase rate for higher quantities and sandy soil; decrease rates for rocky, or cobbly soil"]
["Column/Pier Cap/Abutment Construction","CY",2,4,8,"Rates include forming, tieing, pouring;  Add cure time and time for stripping forms; Recommend breaking down into individual work activities (ie: survey, form, tie rebar, pour concrete, cure, strip forms); "]
["Deck Construction","SF",100,250,400,"Rates include forming, tieing, pouring;  Add cure time and time for stripping forms; Recommend breaking down into individual work activities (ie: survey, form, tie rebar, pour concrete, cure, strip forms); Reduce production rate for decks with complicated geometry. Add 14 days for curing for all rates."]
["Drilled Shafts","LF",10,112,280,"Note 1; Increase rate for shaft clusters, good accessibility and drilling space; soil type is primary controlling factor; reduce rate slightly for cobbly soil, bore diameter and lower quantities; reduce rate significantly for harder rock"]
["Membrane Waterproofing","SF",null,1500,null,"Limited data available"]
["Piles, Driving Concrete","LF",100,250,500,"Allow time for relaxation/testing/redriving; reduce rate for larger diameter/sectional area piles; consult with geotech. For site specific considerations"]
["Piles, Driving Steel","LF",100,250,500,"Allow time for relaxation/testing/redriving; reduce rate for larger diameter/sectional area piles; consult with geotech. For site specific considerations"]
["Prestressed girders (fabrication)","DAYS",10,13,20,"Includes tieing, prestressing, casting, curing and transportation for one set of girders (ie:for one casting of girders); NOTE: assume 3 girders (typical) per set/casting; tieing/prestressing and casting times (approximately 3-4 days) will overlap cure times for each previous set"]
["Prestressed girders (setting)","EA",3,6,12,"Rates are for placement, not fabrication.  Use lower rate for poor access, and longer beams. Add fabrication, curing and transportation time (below)"]
["Reinforcement (Substructure)","Lbs",3000,4000,5000,"Rates include tieing rebar only"]
["Reinforcement (Superstructure)","Lbs",3000,4400,5800,"Typical = 3 days/span; rates include tieing rebar only"]
["Structural Concrete","CY",20,110,200,"Production rate will be primarily controlled by size of pour; increase rates for larger structural sections/quantities; reduce rates for poor accessibility to pour site"]
["Structural steel beams (setting)","EA",3,6,12]
["Structure Steel, Erecting","Lbs",null,25000,null,"Limited data available"]
["Sidewalks and parapets","DAYS",null,"5/span",null,"Limited data available; recommend conducting project-specific cost based UPA "]
["Wall, MSE","SF",40,150,220,"Limited data available.  Rates include excavation and backfill.  Recommend site/project-specific requirements are considered.  Increase rate as quantity increases.  "]
["Wall, gabion","SF",40,300,600,"Limited data available; rates do not include excavation"]
["Wall, Stone masonry","SF",35,50,100,"Limited data available; rates include excavation and are based on exposed face area"]
["Retaining Wall, Reinforced Concrete","SF",10,22,60,"Limited data available; reduce rates for form liner or stone masonry facing "]
["RIPRAP, ROCKERIES, ROCK EMBANKMENTS"]
["Class 2 and smaller","CY",10,80,200,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Class 3 & 4","CY",20,80,150,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Class 5 & 6","CY",40,100,150,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Class 7 and larger","CY",20,100,200,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Riprap Grouting","CY",100,150,200,"Rates are for grouting of already placed riprap, apply to quantity of grout to be placed, and do not include placement of riprap; Site specific conditions should be closely considered, including concrete/grout haul distance, assumed grout coverage, riprap size, site access, etc…"]
["Special Rock Embankment","CY",75,180,280,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Rock Buttress","CY",25,55,92,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["Rockery","SY",4,20,40,"Site specific requirements should be closely considered.  Reduce rates for multiple small sites, and large amounts of excavation; Increase rates are for larger qtys"]
["SIGNING AND STRIPING"]
["Pavement Marking, Paint","LF",20000,50000,85000]
["Pavement Marking, Thermoplastic","LF",3100,5600,10000,"Limited data avail"]
["Pavement Marking, Symbol","EA",5,10,18]
["Delineators","EA",35,50,100,"Use lower rates for stiff/rocky soil."]
["Signs","EA",10,20,30,"Use lower rates for stiff/rocky soil."]
["REVEGETATION"]
["Mulching, Hydraulic Method","AC",2.5,8,11]
["Seeding, Hydraulic Method","AC",2.5,8,11]
["Place conserved topsoil","CY",200,800,1200,"Includes shaping/compacting."]
["MISCELLANEOUS"]
["Concrete barrier, pre-cast","LF",100,200,300]
["Curb ramp, concrete","SY",12,22,30,"reduce rate for multiple smaller ramps; increase rate for larger, longer ramps"]
["Ditch checks structures (Riprap)","EA",4,15,25,"rates are for riprap ditch check structures"]
["Ditch check structures (Wattles)","EA",20,50,100,"rates are for wattle check structures; reduce rates for rocky soil"]
["Final clean up","STA",10,30,50,"rates will vary based on project size and scope"]
["Finishing, aggregate base","STA",10,25,50,"rates include staking, final grading and QC verification of red tops"]
["Finishing, subgrade","STA",5,12,25,"rates include staking, final grading and QC verification of blue tops; reduce rates in rocky subgrade"]
["Geotextiles, stabilization","SY",500,1000,2000,"rate will depend on lift dimensions and geotextile frequency; closer  geotextile layers will increase production rate"]
["Geotextiles, underdrain","SY",100,140,350,"rate will depend on lift dimensions, understrain length and frequency; larger, more frequent sections of underdrain will increase production rate"]
["Sheet piling","SY",55,82,110,"limited data available; reduce rate by half if removal is required."]
["Temp bridge","DAY",7,14,21,"Includes erecting and dismantling; rates will vary based on site-specific conditions"]
["Temp detours","DAY",2,5,7,"Use lower rates for simpler detours, minor earthwork and surfacing."]
[]
["Studies find significant correlation between production rates and the following influences:"]
["Activity:","Influence:"]
["Bridge deck","Curved or straight"]
["Drilled Shafts","Total length, clustered shafts, accessibility Note 1 below"]
["Excavation  ","Work Area Quantity"]
["Embankment ","Work Area Quantity, Work Zone Congestion"]
["Lime Treated Subgrade","Work Area Quantity, Length of Work Area"]
["Flexible Base","Work Area Quantity, Length of Work Area"]
["Cement Treated Base","Work Area Quantity, Length of Work Area"]
["Hot Mix Pavement","Work Area Quantity, Course Type (Bottom or Final Mat)"]
["Conc Pavement-Slip Form","Work Area Quantity, Length of Work Area"]
["Conc Pavement-Conventional Forming","Work Area Quantity, Configuration (Curves, angles)"]
["MSE Walls ","Size of wall (If a wall has different components, see above rates)"]
["Pre Cast Box Culvert","Length, Soil Type, Clay Content of Soil"]
["Cast in place Box Culvert","Length"]
["RCP","Length, Orientation to Road"]
["Inlets and Manholes","Quantity in a line, CIP vs Pre Cast"]
["Wingwall/Headwall","Wall Surface Area"]
["Note 1","No difference was found between cased and uncased shafts. Clusters = areas where multiple shafts can be installed with no major relocation of the drill rig. Locations with good accessibility would be w/in 30' of a current operational road; locations with good room for drill rig and other equipment to maneuver would be over 2500 SQFT per hole"]
[]
[]
[]
["Note 2","Base Rate Adjustment Factors"]
[]
[null,"Factors","               Adjustment for Noted Conditions"]
[null,"Location",null,"  Rural = 1.0  Small City = 0.85  Big city = .75"]
[null,"Traffic conditions",null,"  Light = 1.0  Moderate = .88  High = .70"]
["Complexity is technical difficulty or unusual","Complexity ",null,"  Low = 1.0  Medium = .85  High = .70"]
["project conditions","Soil conditions",null,"  Good = 1.0  Fair = .85  Poor = .65"]
[null,"Quantity of work",null,"  Large = 1.0  Medium = .88 Small = .75"]
[null,"DO NOT USE MORE THAN 2 FACTORS FOR AN ITEM OF WORK"]

{"sheet":"DATA","index":10,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
["Scoring Info for LSCT Risk Assessment Sheet"]
[null,"Select from this List for topic Scoring Information","Scoring notes","Items For Consideration","Possible Mitigation"]
["1a","1a - Contract Duration","Rate from 0 to 10 based on the duration of the project.  For a project with a single construction season a rating of 0 would be appropriate.  For a project that requires multiple construction seasons (4 or more) a rating of 10 may be appropriate.  Balance the rating for multiple season project with item 2  (number of construction of stages)    ","Multiple seasons or long duration projects may lead to cost escalation for materials and labor.  Rental equipment cost increases will also need to be accounted for in the lump sum, if that method of payment is used.  (***Note: escalation is currently a risk that is assigned to the contractor regardless of the payment method specified.  The number of construction seasons may add to the uncertainty for determining TC needs in the future. The variation in quantites provisions also provide an avenue for repricing when quantities fluctuate.)","Provide adequate period to bid (consider longer than typical 4 weeks). \nUse unit bid items which provide for variation in quantities."]
["1b","1b - Contract  Schedule","Does the schedule require coordination of multiple work activities and closures in order to meet the project schedule constraints?  Rate from 0 to 10 based on the  complexity and coordination of work activates in order to meet the project schedule.  ","Activity stacking in the construction schedule may necessitate multiple traffic control crews leading to higher overall costs and risk to determine TC needs.  Also, activity stacking may also increase the risk that delays may be more difficult to recover.  Contractors will price this risk accordingly.","Lengthen the schedule to alleviate the need for trade or work stacking."]
["2a","2a - Number of construction stages","Does the project require multiple construction stages?  Rate from 0 to 10 based on the number and complexity of construction stages.  Balance the rating with item 1a (contract duration)","The number of construction stages can add to the complexity of TC needs and necessitate multiple traffic control crews for staging changes leading to higher overall cost and risk. "]
["3a","3a - Intersection Closures","Does the project require intersection closures?  Rate from 0 to 20 with 0 being for no intersection closures.  The number and complexity of the closures need to be taken into consideration.","Are there significant number of intersection closures (5 or more)  and are they complex, meaning requiring setup of signed detours? Are  WSP or Uniformed Law Enforcement for implementation? ","Added constraints need to be incorporated into the schedule.  Need time to bid and coordinate between prime and subcontractors."]
["3b","3b - Interchange Closures","Does the project require closures that affect multiple interchanges and on and off connections?  Rate from 0 to 20 based on the number of interchanges and complexity of interchange impacts.","Planning and scheduling will need to take into account the detours necessary to close interchanges which increases the number of constraints on the project.  ","Added constraints need to be incorporated into the schedule.  Need time to bid and coordinate between prime and subcontractors."]
["3c","3c - Rolling Slowdowns","Does the project require rolling slowdowns (e.g. for sign-bridge installation)  Rate from 0 to 10 based on the number/complexity/size of rolling slowdowns.","Rolling slowdowns typically require a large number of vehicles to implement and must be planned and scheduled well in advance increasing the risk of implementation. This can make pre-bid scheduling more difficult and adds to the risk","Allow adequate time in working day calculations and/or eliminate any unnecessary constraints on rolling slowdowns."]
["3d","3d - Mainline Closures","Does the project require mainline closures (e.g. nighttime closures or weekend closures)   Rate from 0 to 10 based on the number and complexity of closures needed.","Mainline Closures typically require a large number of vehicles to implement and must be planned and scheduled well in advance increasing the risk of implementation. This can make pre-bid scheduling more difficult and adds to the risk"]
["3e","3e - Other High Impact Closures","Does the project include limited or constrained closures, such as ramp closures.  Rate from 0 to 10 based on the number and complexity of closures needed excluding mainline closures."," Closures, such as ramps. typically require a large number of vehicles to implement and must be planned and scheduled well in advance increasing the risk of implementation. This can make pre-bid scheduling more difficult and adds to the risk"]
["3f","3f - Closure Approval By Others","Does the project require the Contractor to obtain lane closure approvals/detour approvals from Local Agencies, such as Cities or Counties, that are difficult to obtain or do not include allowable hours in the Contract?  Rate from 0 to 10 based on the need approvals and information provided in the contract and anticipated difficulty in obtain approvals.","It is difficult to price the unknown and the risk involved. ","Approvals should be obtained and include in the contract.  If not, provide as much information so the risk is better defined."]
["3g","3g - Transit Impacts","Does the project require closure of transit facilities and/or relocation of bus stops?  Rate from 0 to 5 based on the number of impacts.","Another element to price and resource.  This needs to be clearly defined in the Contract documents.  This can also make pre-bid scheduling more difficult."]
["3h","3h - Pedestrian Route Closures","Does the project require closure of pedestrian facilities and/or pedestrian detours?  Rate from 0 to 10 based on the number and complexity."," This can make pre-bid scheduling more difficult if there are constraints on what is allowed.  Does the impacts require multiple stages to accommodate/maintain pedestrian routes adding to the complexity?"]
["3i","3i - Bicycle Route Closures","Does the project require closure of bicycle lanes or accommodation of temporary bicycle facilities?  Rate from 0 to 5 based on the number and complexity of detours."," This can make pre-bid scheduling more difficult if there are constraints on what is allowed."]
["3j","3j - Traffic Control Provided for Others","Does the project require providing traffic control for others (such as utility companies) that is variable or difficult to schedule?  Rate from 0 to 10 based on complexity of needs and coordination needed."," This can make pre-bid scheduling more difficult if there are constraints on what is allowed.  Does the impacts require multiple stages to accommodate/maintain pedestrian routes adding to the complexity"]
["3k","3k - Multiple Shifts (day & night)","Does the schedule require multiple shifts, day and night and the need for multiple traffic control crews.  Rate from 0 to 10 based the schedule need for multiple shifts for TC crews."]
["3l","3L - Roadway Detours","Does the project require roadway detours.  Rate from 0 to 20 based on the number detour setups and durations.  "," This can make pre-bid scheduling more difficult if there are constraints on what is allowed.  Setup and takedown of detours takes additional time and resources and can exascerbate already limited lane closure windows."]
["4a","4a - Is the contract missing traffic control plans?","Have all the traffic control plans been provided for the project.  Rate from 0 to 20 based on anticipated number and complexity of traffic control plans needed but not provided. ","Lack of traffic control plans makes determining traffic control needs difficult and can add significant risk the contractor will have to take into consideration.  *** If K plans are provided considerations should be given to the complexity of the needed plans and if K plans are appropriate or site specific plans are needed. Have the TC plans been coordinated with all disciplines (e.g. drainage, structure, roadway and so on.)?","Unless there is no option traffic control plans should be provided.   If none are provided and it is a complex project Lump sum TC should not be used."]
["4b","4b - Does the contract have significant number of TC plan","Are there a significant number of TC plans in the contract?  Rate from 0 to 10 based on the number of plan sheets provided.   ","Due to the Ad period being short the contractors ability understand a large number of complex TC plans can add significant risk. ","It a significant number of complex TC plans are provided consider extending the ad period to provided contractors additional time for review to develop pricing."]