{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Introduction","Main Menu","Other Factors","Bridges","Output Bridges","HiddenBridges","Earthwork","Output Earthwork","HiddenEarthwork","Asphalt Paving","Output AP","HiddenAP","Concrete Paving","Output CP","Hidden CP","Miscellaneous Activities","Output Misc.","Hidden Misc."],"not_rendered":{"charts":184,"images":17,"macros":1,"external_links":0,"defined_names":9,"comments":5,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Main Menu","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Project ID"]
[null,null,null,null,null,null,null,null,null,null,null,"Project Location"]
[null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,null,null,null,"Description"]
[null,null,null,null,null,null,null,null,null,null,null,"Name/Initials of Respondent"]

{"sheet":"Other Factors","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Bridges","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[[40,5,42,5],[23,2,23,4],[24,2,24,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[25,2,25,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Main Menu'!M16=\"\",\"\",'Main Menu'!M16)","v":""}]
[null,"Project Location",{"$f":"IF('Main Menu'!M17=\"\",\"\",'Main Menu'!M17)","v":""}]
[null,"Date",{"$f":"IF('Main Menu'!M18=\"\",\"\",'Main Menu'!M18)","v":""}]
[null,"Description",{"$f":"IF('Main Menu'!M19=\"\",\"\",'Main Menu'!M19)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF('Main Menu'!M20=\"\",\"\",'Main Menu'!M20)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Factor","Description",null,null,"Severity"]
[null,"Project Duration","1 = Short ( ≤ 15 calendar weeks)\n2 = Mid-range (15-30 calendar weeks)\n3 = Long ( ≥ 30 calendar weeks)"]
[null,"Project Size","1 = Small ( ≤ 5,000 total SF brige deck)\n2 = Medium (5,000 - 40,000 total SF brige deck)\n3 = Large ( ≥ 40,000 total SF brige deck)"]
[null,"Type of Construction ","1 = New construction project (new deck)\n2 = Reconstruction, resurfacing or maintenance project\n3 = Rehabilitation project (structure currently used for transportation)"]
[null,"Expedited Project Schedule","1 = 40 hours week, 8 hours per day, normal (optimum) crew size, no work on holidays.\n2 = 50 hours per week, larger than normal or constantly changing crew sizes, work on some holidays\n3 = Working beyond 50 weekly hours (overtime), much larger than normal crew sizes (overmanning), working on all holidays, no excuse completion dates."]
[null,"Night Time Construction","1 = Daytime construction\n3 = Nighttime construction"]
[null,"Urban Project","1 = Rural area no traffic\n2 = Rural area under traffic\n3 = Urban area with city streets, nearby residents, commercial buildings, urban cross-sections"]
[null,"Traffic Conditions","1 = Low traffic, road closed\n2 = Moderate traffic, working adjacent to existing traffic\n3 = High traffic, open to traffic, lane restrictions, limited work area"]
[null,"Project Constraints","1 = No site constraints (few utilities, intersections, driveways, gaps, roundabouts)\n2 = Moderate site constraints (some utilities, ramps, limited space for equipment, adjacent buildings)\n3 = Difficult site constraints (presence of significant utilities, conflict with other operations)"]
[null,"Season","1 = Summer, air temperature above 60 °F, some rainfall (minimum level)\n2 = Spring or fall, air temperature between 35 and 60 °F, moderate level of rainfall\n3 = Winter, air temperature below 35 °F, extreme rainfall and snow"]
[null,"Staged Contruction","1 = Single phase \n2 = Two phases, structure done half at a time\n3 = Three or more phases, portions of project done in different stages and multiple mobilizations"]
[null,"Permit Restrictions","1 = Having approved environmental documents, no noise constraints, no vibration constraints\n2 = Need to account for noise restrictions and/or vibration constraints during operating time\n3 = Different permits needed for erosion control issues, water and dust constraints, storm water treatment, hazardous material, removal and disposal of underground fuel tanks, contaminated soils"]
[null,"Difficulty","1 = Normal\n2 = Difficult\n3 = Very Difficult"]

{"sheet":"Output Bridges","index":4,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":true,"merged":[[62,0,67,0],[68,0,77,0],[78,0,95,0],[24,3,24,6],[40,3,40,6],[25,1,25,2],[26,1,28,2],[29,1,31,2],[32,1,34,2],[35,1,37,2],[41,1,41,2],[42,1,43,2],[52,1,53,2],[50,1,51,2],[48,1,49,2],[43,3,43,6],[44,1,45,2],[45,3,45,6],[46,1,47,2],[42,0,61,0],[47,3,47,6],[49,3,49,6],[51,3,51,6],[53,3,53,6],[55,3,55,6],[57,3,57,6],[59,3,59,6],[61,3,61,6],[58,1,59,2],[56,1,57,2],[54,1,55,2],[63,3,63,6],[65,3,65,6],[67,3,67,6],[69,3,69,6],[71,3,71,6],[73,3,73,6],[75,3,75,6],[77,3,77,6],[79,3,79,6],[81,3,81,6],[83,3,83,6],[85,3,85,6],[87,3,87,6],[89,3,89,6],[91,3,91,6],[93,3,93,6],[95,3,95,6],[94,1,95,2],[92,1,93,2],[90,1,91,2],[88,1,89,2],[86,1,87,2],[84,1,85,2],[82,1,83,2],[80,1,81,2],[78,1,79,2],[76,1,77,2],[74,1,75,2],[72,1,73,2],[70,1,71,2],[68,1,69,2],[66,1,67,2],[64,1,65,2],[62,1,63,2],[60,1,61,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF(Bridges!C13=\"\",\"\",Bridges!C13)","v":""}]
[null,"Project Location",{"$f":"IF(Bridges!C14=\"\",\"\",Bridges!C14)","v":""}]
[null,"Date",{"$f":"IF(Bridges!C15=\"\",\"\",Bridges!C15)","v":""}]
[null,"Description",{"$f":"IF(Bridges!C16=\"\",\"\",Bridges!C16)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF(Bridges!C17=\"\",\"\",Bridges!C17)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"(*) means formed, poured and stripped."]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Predicted Value","Max","Unit/Day"]
[null,"Concrete Masonry, Substructure",null,0.2,{"$f":"HiddenBridges!U25","v":2.5234999999999999},{"$f":"HiddenBridges!$U$15","v":4},"Pours/Day"]
[]
[]
[null,"Temporary Sheet Piling (height>=15')",null,{"$f":"HiddenBridges!$U$28","v":115},{"$f":"HiddenBridges!U42","v":115},{"$f":"HiddenBridges!$U$32","v":2000},"S.F./Day"]
[]
[]
[null,"Parapet (Straight Back)",null,{"$f":"HiddenBridges!$U$45","v":16},{"$f":"HiddenBridges!U59","v":16},{"$f":"HiddenBridges!$U$49","v":200},"Feet/Day"]
[]
[]
[null,"Deck Placement, Girder bridge",null,{"$f":"HiddenBridges!U63","v":120},{"$f":"HiddenBridges!U77","v":1396.04},{"$f":"HiddenBridges!U67","v":1499},"S.F./Day"]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Average","Max","Unit/Day"]
["Decks","Parapet (Architectural)",null,{"$f":"HiddenBridges!J94","v":69},{"$f":"HiddenBridges!K94","v":110},{"$f":"HiddenBridges!L94","v":150},"Ft"]
[]
[null,"Parapet (with Liner)",null,{"$f":"HiddenBridges!J95","v":33},{"$f":"HiddenBridges!K95","v":74},{"$f":"HiddenBridges!L95","v":150},"Ft"]
[]
[null,"Deck Placement, Slab Bridge*",null,{"$f":"HiddenBridges!J96","v":263},{"$f":"HiddenBridges!K96","v":383},{"$f":"HiddenBridges!L96","v":500},"Sf"]
[]
[null,"Deck Removal, Partial Depth",null,{"$f":"HiddenBridges!J97","v":197},{"$f":"HiddenBridges!K97","v":3444},{"$f":"HiddenBridges!L97","v":20000},"Sf"]
[]
[null,"Deck Removal, Full Depth",null,{"$f":"HiddenBridges!J98","v":2577},{"$f":"HiddenBridges!K98","v":5383},{"$f":"HiddenBridges!L98","v":8189},"Sf"]
[]
[null,"Deck Slab Repair",null,90,270,450,"Sy"]
[]
[null,"Bridge Overlay with Joint Repair",null,{"$f":"HiddenBridges!J100","v":600},{"$f":"HiddenBridges!K100","v":1300},{"$f":"HiddenBridges!L100","v":2000},"Ft"]
[]
[null,"Bridge Overlay without Joint Repair",null,{"$f":"HiddenBridges!J101","v":125},{"$f":"HiddenBridges!K101","v":146},{"$f":"HiddenBridges!L101","v":168},"Ft"]
[]
[null,"Bridge Overlay with <25% Deck Prep",null,{"$f":"HiddenBridges!J102","v":700},{"$f":"HiddenBridges!K102","v":2000},{"$f":"HiddenBridges!L102","v":4400},"Sy"]
[]
[null,"Bridge Overlay with ≥25% Deck Prep",null,{"$f":"HiddenBridges!J103","v":20},{"$f":"HiddenBridges!K103","v":190},{"$f":"HiddenBridges!L103","v":360},"Sy"]
[]
["Superstructure","Precast Concrete Girder Erection",null,{"$f":"HiddenBridges!J104","v":2.5},{"$f":"HiddenBridges!K104","v":5.8},{"$f":"HiddenBridges!L104","v":9},"Each"]
[]
[null,"Steel Girder Erection",null,{"$f":"HiddenBridges!J105","v":4},{"$f":"HiddenBridges!K105","v":7.5},{"$f":"HiddenBridges!L105","v":11},"Each"]
[]
[null,"Form + Pour Diaphragms *",null,{"$f":"HiddenBridges!J106","v":0.5},{"$f":"HiddenBridges!K106","v":2.7},{"$f":"HiddenBridges!L106","v":6},"Each"]
[]
["Foundation","Driving Piles (All Types)",null,{"$f":"HiddenBridges!J107","v":50},{"$f":"HiddenBridges!K107","v":350},{"$f":"HiddenBridges!L107","v":1000},"Ft"]
[]
[null,"Caissons",null,{"$f":"HiddenBridges!J108","v":60},{"$f":"HiddenBridges!K108","v":74},{"$f":"HiddenBridges!L108","v":88},"Ft"]
[]
[null,"Spread Footings *",null,{"$f":"HiddenBridges!J109","v":0.25},{"$f":"HiddenBridges!K109","v":0.25},{"$f":"HiddenBridges!L109","v":0.25},"Pours"]
[]
[null,"Cofferdam",null,{"$f":"HiddenBridges!J110","v":250},{"$f":"HiddenBridges!K110","v":265},{"$f":"HiddenBridges!L110","v":280},"Sf"]
[]
[null,"Temporary Sheet Piling (height<15’)",null,{"$f":"HiddenBridges!J111","v":433},{"$f":"HiddenBridges!K111","v":783},{"$f":"HiddenBridges!L111","v":1133},"Sf"]
[]
["Other","Concrete Masonry, Culverts *",null,{"$f":"HiddenBridges!J112","v":0.7},{"$f":"HiddenBridges!K112","v":1.3},{"$f":"HiddenBridges!L112","v":1.8},"Panels"]
[]
[null,"Retaining Walls: Cast in Place*",null,{"$f":"HiddenBridges!J113","v":273},{"$f":"HiddenBridges!K113","v":286},{"$f":"HiddenBridges!L113","v":300},"Panels "]
[]
[null,"Retaining Walls: Precast (including footing)",null,{"$f":"HiddenBridges!J114","v":350},{"$f":"HiddenBridges!K114","v":350},{"$f":"HiddenBridges!L114","v":350},"Sf"]
[]
[null,"Retaining Walls: Mechanically Stabilized",null,{"$f":"HiddenBridges!J115","v":165},{"$f":"HiddenBridges!K115","v":1080},{"$f":"HiddenBridges!L115","v":2000},"Sf"]
[]
[null,"Moment Slab on MSE walls*",null,{"$f":"HiddenBridges!J116","v":28},{"$f":"HiddenBridges!K116","v":176},{"$f":"HiddenBridges!L116","v":350},"Ft"]
[]
[null,"Noise Walls",null,{"$f":"HiddenBridges!J117","v":300},{"$f":"HiddenBridges!K117","v":650},{"$f":"HiddenBridges!L117","v":1000},"Sf"]
[]
[null,"Maintenance Painting (Clean + Paint)",null,{"$f":"HiddenBridges!J118","v":100},{"$f":"HiddenBridges!K118","v":200},{"$f":"HiddenBridges!L118","v":300},"Sf"]
[]
[null,"Full Containment Painting (Clean+Paint)",null,{"$f":"HiddenBridges!J119","v":550},{"$f":"HiddenBridges!K119","v":7180},{"$f":"HiddenBridges!L119","v":19400},"Sf"]
[]
[null,"Bridge Deck Grooving",null,{"$f":"HiddenBridges!J120","v":7800},{"$f":"HiddenBridges!K120","v":7800},{"$f":"HiddenBridges!L120","v":7800},"Sf"]
[]
[]
[]
[]
[]
[]
["Reliability input",1]
[]
[]
["complexity input",1]

{"sheet":"HiddenBridges","index":5,"n_rows":120,"n_cols":21,"rows_kept":120,"cut":false,"hidden":true,"merged":[[118,13,118,19],[119,13,119,19],[96,13,96,19],[97,13,97,19],[113,13,113,19],[114,13,114,19],[115,13,115,19],[116,13,116,19],[117,13,117,19],[108,13,108,19],[109,13,109,19],[110,13,110,19],[111,13,111,19],[112,13,112,19],[103,13,103,19],[104,13,104,19],[105,13,105,19],[106,13,106,19],[107,13,107,19],[98,13,98,19],[99,13,99,19],[100,13,100,19],[101,13,101,19],[102,13,102,19],[118,7,118,8],[119,7,119,8],[108,7,108,8],[109,7,109,8],[110,7,110,8],[111,7,111,8],[112,7,112,8],[113,7,113,8],[114,7,114,8],[115,7,115,8],[116,7,116,8],[117,7,117,8],[98,7,98,8],[99,7,99,8],[100,7,100,8],[101,7,101,8],[102,7,102,8],[103,7,103,8],[104,7,104,8],[105,7,105,8],[106,7,106,8],[107,7,107,8],[58,0,58,2],[5,16,5,17],[6,0,6,2],[6,8,6,9],[23,0,23,2],[40,0,40,2],[0,9,0,11],[97,7,97,8],[83,7,84,13],[93,7,93,8],[94,7,94,8],[95,7,95,8],[96,7,96,8],[95,13,95,19],[94,13,94,19],[93,13,93,19]]}
[null,null,null,null,null,null,null,null,null,"For Dropdown Menus"]
[null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,3]
[null,null,"Determine whether you would like to have narrow spread, medium spread or large spread for your estimate."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boundaries"]
["Dependent Variable 1: Concrete Masonry",null,null,null,null,null,null,null,"x-new (user input)",null,null,null,"Estimate of Ῡ",null,null,null,"MIN","MAX"]
[]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,"Concrete Masonry"]
["(Intercept)  ",2.5234999999999999,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B11+B12*J12+B13*J13","v":2.5234999999999999},null,null,null,0.2,4,null,"min",0.2]
["StagedConstruction",-1.0335000000000001,null,null,null,null,null,"StagedConstruction","1, 2 or 3",{"$f":"Bridges!F34","v":0},null,null,null,null,null,null,null,null,null,"Q1",0.625]
["Project Constraints",0.76170000000000004,null,null,null,null,null,"Project Constraints","1, 2 or 3",{"$f":"Bridges!F32","v":0},null,null,null,null,null,null,null,null,null,"Median",1.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"U12","v":0.625}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"U13-U12","v":1.0249999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"U14-U13","v":0.35000000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"M11","v":2.5234999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"U15-U14","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"U12-U11","v":0.42499999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
["Dependent Variable 2: Sheet Piling (height>=15')"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(U20<=U11,U11,IF(U20>=U15,U15,U20))","v":2.5234999999999999}]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0"]
["(Intercept)  ",-1068.3,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B27+J28*B28+B29*J29+J30*B30+B31*J31","v":-1068.3},null,null,null,110,2000,null,null,"Sheet Piling (height>=15')"]
["Season",1111.5,null,null,null,null,null,"Season","1, 2 or 3",{"$f":"Bridges!F33","v":0},null,null,null,null,null,null,null,null,null,"min",115]
["Project Size",343.2,null,null,null,null,null,"Project Size","1, 2 or 3",{"$f":"Bridges!F26","v":0},null,null,null,null,null,null,null,null,null,"Q1",250]
["Permit Restriction",-363.2,null,null,null,null,null,"Permit Restriction","1, 2 or 3",{"$f":"Bridges!F35","v":0},null,null,null,null,null,null,null,null,null,"Median",435]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",2000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"U29","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"U30-U29","v":185}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"U31-U30","v":315}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M27","v":-1068.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"U32-U31","v":1250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"U29-U28","v":135}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
["Dependent Variable 3: Parapet Straight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(U37<=U28,U28,IF(U37>=U32,U32,U37))","v":115}]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input"]
["(Intercept)  ",1,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B44+B45*J45","v":1},null,null,null,40,400,null,null,"Parapet (Straight Back)"]
["ProjectDuration",49.75,null,null,null,null,null,"ProjectDuration","1, 2 or 3",{"$f":"Bridges!F25","v":0},null,null,null,null,null,null,null,null,null,"min",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",90.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",150.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",200]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"U46","v":57}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"U47-U46","v":33.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"U48-U47","v":59.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M44","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"U49-U48","v":49.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"U46-U45","v":41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
["Dependent Variable 4: Deck Placement, Girder bridge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(U54<=U45,U45,IF(U54>=U49,U49,U54))","v":16}]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input"]
["(Intercept)  ",1396.04,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B62+B63*J63+B64*J64+B65*J65","v":1396.04},null,null,null,120,800,null,null,"Deck Placement, Girder bridge"]
["Staged Construction",-338.63,null,null,null,null,null,"Staged Construction","1, 2 or 3",{"$f":"Bridges!F34","v":0},null,null,null,null,null,null,null,null,null,"min",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",326.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",620]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",987.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",1499]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"U64","v":326.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"U65-U64","v":293.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"U66-U65","v":367.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M62","v":1396.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"U67-U66","v":511.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"U64-U63","v":206.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(U72<=U63,U63,IF(U72>=U67,U67,U72))","v":1396.04}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Non Modelled Activities"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Min","Average","Max","N"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.5]
[null,null,null,null,null,null,null,"Parapet (Architectural)",null,69,110,150,"D"]
[null,null,null,null,null,null,null,"Parapet (with Liner)",null,33,74,150,4]
[null,null,null,null,null,null,null,"Deck Placement, Slab Bridge*",null,263,383,500,"D"]
[null,null,null,null,null,null,null,"Deck Removal, Partial Depth",null,197,3444,20000,14]
[null,null,null,null,null,null,null,"Deck Removal, Full Depth",null,2577,5383,8189,"D"]
[null,null,null,null,null,null,null,"Deck Slab Repair",null,"NA","NA","NA"]
[null,null,null,null,null,null,null,"Bridge Overlay with Joint Repair",null,600,1300,2000,"D"]
[null,null,null,null,null,null,null,"Bridge Overlay without Joint Repair",null,125,146,168,2]
[null,null,null,null,null,null,null,"Bridge Overlay with <25% Deck Prep",null,700,2000,4400,3]
[null,null,null,null,null,null,null,"Bridge Overlay with ≥25% Deck Prep",null,20,190,360,2]
[null,null,null,null,null,null,null,"Precast Concrete Girder Erection",null,2.5,5.8,9,15]
[null,null,null,null,null,null,null,"Steel Girder Erection",null,4,7.5,11,"D"]
[null,null,null,null,null,null,null,"Form + Pour Diaphragms *",null,0.5,2.7,6,8]
[null,null,null,null,null,null,null,"Driving Piles (All Types)",null,50,350,1000,19]
[null,null,null,null,null,null,null,"Caissons",null,60,74,88,2]
[null,null,null,null,null,null,null,"Spread Footings *",null,0.25,0.25,0.25,1]
[null,null,null,null,null,null,null,"Cofferdam",null,250,265,280,2]
[null,null,null,null,null,null,null,"Temporary Sheet Piling (height<15’)",null,433,783,1133,"D"]
[null,null,null,null,null,null,null,"Concrete Masonry, Culverts *",null,0.7,1.3,1.8,"D"]
[null,null,null,null,null,null,null,"Retaining Walls: Cast in Place*",null,273,286,300,2]
[null,null,null,null,null,null,null,"Retaining Walls: Precast (including footing)",null,350,350,350,1]
[null,null,null,null,null,null,null,"Retaining Walls: Mechanically Stabilized",null,165,1080,2000,2]
[null,null,null,null,null,null,null,"Moment Slab on MSE walls*",null,28,176,350,3]
[null,null,null,null,null,null,null,"Noise Walls",null,300,650,1000,"D"]
[null,null,null,null,null,null,null,"Maintenance Painting (Clean + Paint)",null,100,200,300,"D"]
[null,null,null,null,null,null,null,"Full Containment Painting (Clean+Paint)",null,550,7180,19400,3]
[null,null,null,null,null,null,null,"Bridge Deck Grooving",null,7800,7800,7800,1]

{"sheet":"Earthwork","index":6,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[[30,2,30,4],[29,2,29,4],[23,2,23,4],[31,2,31,4],[3,2,5,3],[25,2,25,4],[21,2,21,4],[28,2,28,4],[27,2,27,4],[26,2,26,4],[24,2,24,4],[22,2,22,4],[35,2,35,4],[33,2,33,4],[32,2,32,4],[34,2,34,4],[39,5,41,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Main Menu'!M16=\"\",\"\",'Main Menu'!M16)","v":""}]
[null,"Project Location",{"$f":"IF('Main Menu'!M17=\"\",\"\",'Main Menu'!M17)","v":""}]
[null,"Date",{"$f":"IF('Main Menu'!M18=\"\",\"\",'Main Menu'!M18)","v":""}]
[null,"Description",{"$f":"IF('Main Menu'!M19=\"\",\"\",'Main Menu'!M19)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF('Main Menu'!M20=\"\",\"\",'Main Menu'!M20)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Factor","Description",null,null,"Severity"]
[null,"Project Duration","1 = Short ( ≤ 20 calendar weeks)\n2 = Mid-range (20-30 calendar weeks)\n3 = Long ( ≥ 30 calendar weeks)"]
[null,"Project Size","1 = Small ( ≤ 135,000 total cubic yards)\n2 = Medium (135,000 - 300,000 total cubic yards)\n3 = Large ( ≥ 300,000 total cubic yards)"]
[null,"Type of work","1 = New construction project\n2 = Reconstruction, resurfacing or maintenance project\n3 = Rehabilitation project (structure currently used for transportation)"]
[null,"Expedited Project Schedule","1 = 40 hours week, 8 hours per day, normal (optimum) crew size, no work on holidays.\n2 = 50 hours per week, larger than normal or constantly changing crew sizes, work on some holidays\n3 = Working beyond 50 weekly hours (overtime), much larger than normal crew sizes (overmanning), working on all holidays, no excuse completion dates."]
[null,"Night Time Work","1 = Daytime construction\n3 = Nighttime construction"]
[null,"Project Length","1 = Short stretch\n2 = Medium stretch\n3 = Long stretch"]
[null,"Urban Project","1 = Rural area no traffic\n2 = Rural area under traffic\n3 = Urban area with city streets, nearby residents, commercial buildings, urban cross-sections"]
[null,"Materials Delivery","1 = Easy to get materials and equipment to construction site\n2 = Some delays in getting materials on site (long distances, traffic congestion)\n3 = Very difficult to deliver materials to site"]
[null,"Project Constraints","1 = No site constraints (few utilities, intersections, driveways, gaps, roundabouts)\n2 = Moderate site constraints (some utilities, ramps, limited space for equipment, adjacent buildings)\n3 = Difficult site constraints (presence of significant utilities, conflict with other operations)"]
[null,"Season","1 = Summer, air temperature above 60 °F, some rainfall (minimum level)\n2 = Spring or fall, air temperature between 35 and 60 °F, moderate level of rainfall\n3 = Winter, air temperature below 35 °F, extreme rainfall and snow"]
[null,"Soil Moisture Condition","1 = Soil near optimum moisture\n2 = Wet soil that must be dried\n3 = Very wet soil"]
[null,"Soil Type","1 = Soil is mainly sand\n2 = Soil is granular and sandy with some silt and clay\n3 = Soil is mainly wet silt, clay or silty clay "]
[null,"Difficulty","1 = Normal\n2 = Difficult\n3 = Very Difficult"]
[null,"Staged Construction","1 = Single phase \n2 = Two phases, project done half at a time\n3 = Three or more phases, portions of project done in different stages and multiple mobilizations"]

{"sheet":"Output Earthwork","index":7,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":true,"merged":[[53,3,53,6],[55,3,55,6],[57,3,57,6],[59,3,59,6],[61,3,61,6],[52,1,53,2],[54,1,55,2],[56,1,57,2],[58,1,59,2],[60,1,61,2],[51,1,51,2],[50,3,50,6],[21,1,21,2],[22,1,24,2],[25,1,27,2],[10,2,10,3],[14,2,14,3],[11,2,11,3],[13,2,13,3],[12,2,12,3],[20,3,20,6],[28,1,30,2],[40,1,42,2],[43,1,45,2],[46,1,48,2],[31,1,33,2],[34,1,36,2],[37,1,39,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF(Earthwork!C11=\"\",\" \",Earthwork!C11)","v":" "}]
[null,"Project Location",{"$f":"IF(Earthwork!C12=\"\",\" \",Earthwork!C12)","v":" "}]
[null,"Date",{"$f":"IF(Earthwork!C13=\"\",\" \",Earthwork!C13)","v":" "}]
[null,"Description",{"$f":"IF(Earthwork!C14=\"\",\" \",Earthwork!C14)","v":" "}]
[null,"Name/Initials of Respondent",{"$f":"IF(Earthwork!C15=\"\",\" \",Earthwork!C15)","v":" "}]
[]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Predicted Value","Max","Unit/Day"]
[null,"Excavation: Truck",null,{"$f":"HiddenEarthwork!$V$9","v":40},{"$f":"HiddenEarthwork!V23","v":40},{"$f":"HiddenEarthwork!$V$13","v":5000},"C.Y/Day"]
[]
[]
[null,"Excavation: Scraper",null,{"$f":"HiddenEarthwork!$V$27","v":190},{"$f":"HiddenEarthwork!V41","v":1528.5},{"$f":"HiddenEarthwork!$V$31","v":17000},"C.Y/Day"]
[]
[]
[null,"Excavation: Articulated",null,{"$f":"HiddenEarthwork!$V$49","v":250},{"$f":"HiddenEarthwork!V63","v":2199.8000000000002},{"$f":"HiddenEarthwork!$V$53","v":8000},"C.Y/Day"]
[]
[]
[null,"Base Course Roadway",null,{"$f":"HiddenEarthwork!$V$70","v":40},{"$f":"HiddenEarthwork!V84","v":385.1},{"$f":"HiddenEarthwork!$V$74","v":7000},"Tons/Day"]
[]
[]
[null,"Base Course Shoulders",null,{"$f":"HiddenEarthwork!$V$90","v":30},{"$f":"HiddenEarthwork!V104","v":30},{"$f":"HiddenEarthwork!$V$94","v":2500},"Tons/Day"]
[]
[]
[null,"Breaker Run",null,{"$f":"HiddenEarthwork!$V$107","v":25},{"$f":"HiddenEarthwork!V121","v":25},{"$f":"HiddenEarthwork!$V$111","v":4115},"C.Y/Day"]
[]
[]
[null,"Shallow Excavation",null,{"$f":"HiddenEarthwork!$V$135","v":75},{"$f":"HiddenEarthwork!V149","v":350.3},{"$f":"HiddenEarthwork!$V$139","v":4000},"C.Y/Day"]
[]
[]
[null,"Excavation Below Subgrade",null,{"$f":"HiddenEarthwork!$V$154","v":15},{"$f":"HiddenEarthwork!V168","v":15},{"$f":"HiddenEarthwork!$V$158","v":3000},"C.Y/Day"]
[]
[]
[null,"Clearing & Grubbing",null,{"$f":"HiddenEarthwork!$V$176","v":1},{"$f":"HiddenEarthwork!V190","v":6.0359999999999996},{"$f":"HiddenEarthwork!$V$180","v":30},"Stations/Day"]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Average","Max","Unit/Day"]
[null,"Soft Rock Excavation",null,1000,1300,1800,"C.Y./Day"]
[]
[null,"Hard Rock Excavation",null,176,706,1200,"C.Y./Day"]
[]
[null,"Topsoil Placement",null,20,1100,8223,"C.Y./Day"]
[]
[null,"Marsh Excavation (depth ≤8’)",null,458,3486,5000,"C.Y./Day"]
[]
[null,"Marsh Excavation (depth >8’)",null,1200,2139,4600,"C.Y./Day"]
[]
[]
[]
[]
[]
[]
["Reliability input",1]
["complexity input",1]

{"sheet":"HiddenEarthwork","index":8,"n_rows":209,"n_cols":22,"rows_kept":209,"cut":false,"hidden":true,"merged":[[204,7,204,8],[205,7,205,8],[206,7,206,8],[207,7,207,8],[208,7,208,8],[194,7,195,13],[4,17,4,18],[172,0,172,4],[5,8,5,9],[86,0,86,4],[103,0,103,4],[131,0,131,4],[150,0,150,4],[5,0,5,4],[23,0,23,4],[45,0,45,4],[66,0,66,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boundaries"]
["Dependent Variable 1: Exacavation Truck",null,null,null,null,null,null,null,"x-new (user input)",null,null,null,null,"Estimate of Ῡ",null,null,null,"MIN","MAX"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Excavation Truck"]
["(Intercept)                                                   ",-141.5,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B9*J9+B10*J10","v":-141.5},null,null,null,200,5000,null,"min",40]
["Size",967.8,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",5000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V10","v":600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V11-V10","v":900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V12-V11","v":900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N9","v":-141.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V13-V12","v":2600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V10-V9","v":560}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V18<=V9,V9,IF(V18>=V13,V13,V18))","v":40}]
["Dependent Variable 2: Exacavation Scrapers"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Excavation Scraper"]
["(Intercept)  ",1528.5,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B27*J27+B28*J28+B29*J29","v":1528.5},null,null,null,75,17000,null,"min",190]
["Size",3344.4,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",1375]
["Materials Delivery",-2792.9,null,null,null,null,null,"Materials Delivery","1, 2 or 3",{"$f":"Earthwork!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Median",5075]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",8000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",17000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V28","v":1375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V29-V28","v":3700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V30-V29","v":2925}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N27","v":1528.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V31-V30","v":9000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V28-V27","v":1185}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V36<=V27,V27,IF(V36>=V31,V31,V36))","v":1528.5}]
[]
[]
[]
[]
["Dependent Variable 3: Exacavation Articulated"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Excavation Articulated"]
["(Intercept)  ",2199.8000000000002,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B49*J49+B50*J50+B51*J51+B52*J52","v":2199.8000000000002},null,null,null,250,8000,null,"min",250]
["Size",2203.1999999999998,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",1925]
["Expediated Schedule",-1377.9,null,null,null,null,null,"Expediated Schedule","1, 2 or 3",{"$f":"Earthwork!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Median",3000]
["Season",-1694.7,null,null,null,null,null,"Season","1, 2 or 3",{"$f":"Earthwork!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",4500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",8000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V50","v":1925}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V51-V50","v":1075}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V52-V51","v":1500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N49","v":2199.8000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V53-V52","v":3500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V50-V49","v":1675}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V58<=V49,V49,IF(V58>=V53,V53,V58))","v":2199.8000000000002}]
[]
[]
[]
["Dependent Variable 4: Base Course Roadway"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Base Course Roadway"]
["(Intercept)  ",385.1,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B70*J70+B71*J71+B72*J72","v":385.1},null,null,null,200,7000,null,"min",40]
["Size",1243.3,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",600]
["Night Work",-612.29999999999995,null,null,null,null,null,"Night Work","1, 2 or 3",{"$f":"Earthwork!F27","v":0},null,null,null,null,null,null,null,null,null,null,"Median",1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",2750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",7000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V71","v":600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V72-V71","v":900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V73-V72","v":1250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N70","v":385.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V74-V73","v":4250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V71-V70","v":560}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V79<=V70,V70,IF(V79>=V74,V74,V79))","v":385.1}]
[]
[]
["Dependent Variable 5: Base Course Shoulders"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Base Course Shoulder"]
["(Intercept)  ",-477.58,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B90*J90+B91*J91+B92*J92","v":-477.58},null,null,null,80,2500,null,"min",30]
["Size",382.5,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",187.5]
["Type of Work",332.73,null,null,null,null,null,"Type of Work","1, 2 or 3",{"$f":"Earthwork!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Median",743]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",2500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V91","v":187.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V92-V91","v":555.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V93-V92","v":257}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N90","v":-477.58}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V94-V93","v":1500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V91-V90","v":157.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
["Dependent Variable 6: Breaker Run",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V99<=V90,V90,IF(V99>=V94,V94,V99))","v":30}]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Breaker Run"]
["(Intercept)  ",-582.6,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B107*J107+B108*J108+B109*J109+B110*J110","v":-582.6},null,null,null,200,5350,null,"min",25]
["Size",1122.4000000000001,null,null,null,null,null,"SoilMoisture                              ","1, 2 or 3",{"$f":"Earthwork!F33","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",488.75]
["Soil Moisture",494.5,null,null,null,null,null,"Season","1, 2 or 3",{"$f":"Earthwork!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Median",1225]
["Difficulty",-588.70000000000005,null,null,null,null,null,"TypeWork","1, 2 or 3",{"$f":"Earthwork!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",4115]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V108","v":488.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V109-V108","v":736.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V110-V109","v":1775}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N107","v":-582.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V111-V110","v":1115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V108-V107","v":463.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V116<=V107,V107,IF(V116>=V111,V111,V116))","v":25}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dependent Variable 7: Shallow Excavation"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Shallow Excavation"]
["(Intercept)  ",350.3,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B135+B136*J136+B137*J137+B138*J138+B139*J139","v":350.3},null,null,null,75,2750,null,"min",75]
["Size",405.8,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",400]
["Type of Work",-622.79999999999995,null,null,null,null,null,"MaterialDelivery","1, 2 or 3",{"$f":"Earthwork!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Median",615]
["Project Duration",1181.3,null,null,null,null,null,"Project Duration","1, 2 or 3",{"$f":"Earthwork!F23","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",1100]
["Night Work",-832.1,null,null,null,null,null,"Urban Project","1, 2 or 3",{"$f":"Earthwork!F29","v":0},null,null,null,null,null,null,null,null,null,null,"Max",4000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V136","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V137-V136","v":215}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V138-V137","v":485}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N135","v":350.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V139-V138","v":2900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V136-V135","v":325}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V144<=V135,V135,IF(V144>=V139,V139,V144))","v":350.3}]
[]
["Dependent Variable 8: EBS"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"EBS"]
["(Intercept)  ",-422.7,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B154+B155*J155+B156*J156+B157*J157","v":-422.7},null,null,null,50,6000,null,"min",15]
["Size",715.4,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",392]
["Night Work",-549.4,null,null,null,null,null,"Night Work","1, 2 or 3",{"$f":"Earthwork!F27","v":0},null,null,null,null,null,null,null,null,null,null,"Median",827.5]
["Type Work",507.6,null,null,null,null,null,"Type Work","1, 2 or 3",{"$f":"Earthwork!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",1112.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",3000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V155","v":392}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V156-V155","v":435.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V157-V156","v":285}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N154","v":-422.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V158-V157","v":1887.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V155-V154","v":377}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V163<=V154,V154,IF(V163>=V158,V158,V163))","v":15}]
[]
[]
[]
[]
["Dependent Variable 9: Clearing and Grubbing"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Clearing & Grubbing"]
["(Intercept)  ",6.0359999999999996,null,null,null,null,null,"(Intercept)",1,1,null,null,null,{"$f":"B176*J176+B177*J177+B178*J178","v":6.0359999999999996},null,null,null,1,25,null,"min",1]
["Size",6.8380000000000001,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"Earthwork!F24","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",5.5]
["Expediated Schedule",-5.1980000000000004,null,null,null,null,null,"Expediated Schedule","1, 2 or 3",{"$f":"Earthwork!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Median",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",30]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V177","v":5.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V178-V177","v":2.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V179-V178","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x mark",{"$f":"N176","v":6.0359999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V180-V179","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V177-V176","v":4.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y mark",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V185<=V176,V176,IF(V185>=V180,V180,V185))","v":6.0359999999999996}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Non Modelled Activities"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Min","Average","Max","N"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.5]
[null,null,null,null,null,null,null,"Soft Rock Excavation",null,1000,1300,1800,3]
[null,null,null,null,null,null,null,"Hard Rock Excavation",null,176,706,1200,4]
[null,null,null,null,null,null,null,"Topsoil Placement",null,20,1100,8223,32]
[null,null,null,null,null,null,null,"Marsh Excavation (depth ≤8’)",null,458,3486,5000,3]
[null,null,null,null,null,null,null,"Marsh Excavation (depth >8’)",null,1200,2138,4600,9]

{"sheet":"Asphalt Paving","index":9,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":true,"merged":[[42,5,44,5],[23,2,23,4],[24,2,24,4],[37,2,37,4],[36,2,36,4],[35,2,35,4],[34,2,34,4],[33,2,33,4],[32,2,32,4],[28,2,28,4],[38,2,38,4],[3,1,5,2],[25,2,25,4],[27,2,27,4],[26,2,26,4],[31,2,31,4],[30,2,30,4],[29,2,29,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Main Menu'!M16=\"\",\"\",'Main Menu'!M16)","v":""}]
[null,"Project Location",{"$f":"IF('Main Menu'!M17=\"\",\"\",'Main Menu'!M17)","v":""}]
[null,"Date",{"$f":"IF('Main Menu'!M18=\"\",\"\",'Main Menu'!M18)","v":""}]
[null,"Description",{"$f":"IF('Main Menu'!M19=\"\",\"\",'Main Menu'!M19)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF('Main Menu'!M20=\"\",\"\",'Main Menu'!M20)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Factor","Description",null,null,"Severity"]
[null,"Type of work","1 = New construction project\n2 = Reconstruction, resurfacing or maintenance project\n3 = Rehabilitation project (structure currently used for transportation)"]
[null,"Project Size","1 = Small ( ≤ 10,000 total tons)\n2 = Medium (10,000 - 50,000 total tons)\n3 = Large ( ≥ 50,000 total cubic tons)"]
[null,"Expedited Project Schedule","1 = 40 hours week, 8 hours per day, normal (optimum) crew size, no work on holidays.\n2 = 50 hours per week, larger than normal or constantly changing crew sizes, work on some holidays.\n3 = Working beyond 50 weekly hours (overtime), much larger than normal crew sizes (overmanning), working on all holidays, no excuse completion dates."]
[null,"Night Time Paving","1 = Daytime paving\n3 = Nighttime paving"]
[null,"Project Length","1 = Short total project length\n2 = Medium total project length\n3 = Long total project length"]
[null,"Paving Width","1 = Wide paving width ( >14’) \n2 = Medium paving width ( <14’)\n3 = Narrow paving width (shoulders only)"]
[null,"Urban Project","1 = Rural area no traffic\n2 = Rural area under traffic\n3 = Urban area with city streets, nearby residents, commercial buildings, urban cross-sections"]
[null,"Size and Proximity of Storage and Staging Areas","1 = Adequate storage and staging, on site\n2 = Limited size of storage and staging\n3 = Insufficient storage and staging, in the general area of the project"]
[null,"Numerous Typical Section Transitions","1 = Continuous pavement width\n2 = Some incidental pavement (intersections, ramp tapers)\n3 = Many incidental pavement areas (roundabouts, intersections, ramps)"]
[null,"Season","1 = Summer, air temperature above 60 °F, some rainfall (minimum level)\n2 = Spring or fall, air temperature between 35 and 60 °F, moderate level of rainfall\n3 = Winter, air temperature below 35 °F, extreme rainfall and snow"]
[null,"Staged Contruction","1 = Single phase \n2 = Two phases, structure done half at a time\n3 = Three or more phases, portions of roadway done in different stages and multiple mobilizations"]
[null,"Asphalt Thickness ","1 = Thick pavement structure ( ≥ 4'')\n2 = Thin pavement structure (between 2'' and 4'')\n3 = Very thin pavement structure ( ≤ 2'')"]
[null,"Type and Amount of Miling","1 = No correction required\n2 = Some correction and asphalt paving removal required\n3 = Significant correction required"]
[null,"Presence of Ride Specification","1 = No ride specification\n3 = Presence of ride specifications (such as International Roughness Index)"]
[null,"Difficulty","1 = Normal\n2 = Difficult\n3 = Very Difficult"]

{"sheet":"Output AP","index":10,"n_rows":70,"n_cols":7,"rows_kept":70,"cut":false,"hidden":true,"merged":[[20,3,20,6],[20,1,20,2],[55,3,55,6],[57,3,57,6],[59,3,59,6],[21,1,21,2],[22,1,24,2],[25,1,27,2],[28,1,30,2],[31,1,33,2],[34,1,36,2],[43,1,45,2],[37,1,39,2],[40,1,42,2],[61,3,61,6],[63,3,63,6],[49,1,49,2],[48,1,48,2],[54,1,55,2],[56,1,57,2],[58,1,59,2],[60,1,61,2],[62,1,63,2],[48,3,48,6],[10,2,10,3],[14,2,14,3],[11,2,11,3],[13,2,13,3],[12,2,12,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Asphalt Paving'!C13=\"\",\" \",'Asphalt Paving'!C13)","v":" "}]
[null,"Project Location",{"$f":"IF('Asphalt Paving'!C14=\"\",\" \",'Asphalt Paving'!C14)","v":" "}]
[null,"Date",{"$f":"IF('Asphalt Paving'!C15=\"\",\" \",'Asphalt Paving'!C15)","v":" "}]
[null,"Description",{"$f":"IF('Asphalt Paving'!C16=\"\",\" \",'Asphalt Paving'!C16)","v":" "}]
[null,"Name/Initials of Respondent",{"$f":"IF('Asphalt Paving'!C17=\"\",\" \",'Asphalt Paving'!C17)","v":" "}]
[]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Predicted Value","Max","Unit/Day"]
[null,"HMA Placement Lower Layer",null,{"$f":"HiddenAP!$V$9","v":20},{"$f":"HiddenAP!V23","v":108.41},{"$f":"HiddenAP!$V$13","v":350},"Tons/Hour"]
[]
[]
[null,"HMA Placement Surface Layer",null,{"$f":"HiddenAP!$V$27","v":25},{"$f":"HiddenAP!V41","v":82.06},{"$f":"HiddenAP!$V$31","v":350},"Tons/Hour"]
[]
[]
[null,"Hand Placement of Asphalt Pavement",null,{"$f":"HiddenAP!$V$45","v":4},{"$f":"HiddenAP!V59","v":4},{"$f":"HiddenAP!$V$49","v":150},"Tons/Hour"]
[]
[]
[null,"Thick Milling (>2\")",null,{"$f":"HiddenAP!$V$64","v":1467},{"$f":"HiddenAP!V78","v":1638},{"$f":"HiddenAP!$V$68","v":20500},"S.Y./Day"]
[]
[]
[null,"Base Course Placement",null,{"$f":"HiddenAP!V83","v":60},{"$f":"HiddenAP!V97","v":1199.2},{"$f":"HiddenAP!V87","v":3400},"Tons/Day"]
[]
[]
[null,"QMP Density",null,{"$f":"HiddenAP!$V$101","v":2000},{"$f":"HiddenAP!V115","v":4743},{"$f":"HiddenAP!$V$105","v":40000},"S.Y./Day"]
[]
[]
[null,"Rumble Strip Centerline",null,{"$f":"HiddenAP!$V$120","v":650},{"$f":"HiddenAP!V134","v":47221},{"$f":"HiddenAP!$V$124","v":125000},"Feet/Day"]
[]
[]
[null,"Rumble Strip Shoulder",null,{"$f":"HiddenAP!$V$139","v":1250},{"$f":"HiddenAP!V152","v":1250},{"$f":"HiddenAP!$V$143","v":125000},"Feet/Day"]
[]
[]
[]
[]
[null,null,null,"Producitivty Rates"]
[null,"Activity",null,"Min","Average","Max","Unit/Day"]
[null,"HMA Placement: Lower Layer",null,{"$f":"HiddenAP!V9","v":20},{"$f":"IF(HiddenAP!M9<HiddenAP!R9,HiddenAP!R9,IF(HiddenAP!M9>HiddenAP!S9,HiddenAP!S9,HiddenAP!M9))","v":108.41},{"$f":"HiddenAP!V13","v":350},"Tons/Hour"]
[null,"HMA Placement: Surface Layer",null,{"$f":"IF(HiddenAP!#REF!<HiddenAP!R27,HiddenAP!R27,IF(HiddenAP!#REF!>HiddenAP!S27,HiddenAP!S27,HiddenAP!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(HiddenAP!M27<HiddenAP!R27,HiddenAP!R27,IF(HiddenAP!M27>HiddenAP!S27,HiddenAP!S27,HiddenAP!M27))","v":82.06},{"$f":"IF(HiddenAP!#REF!<HiddenAP!R27,HiddenAP!R27,IF(HiddenAP!#REF!>HiddenAP!S27,HiddenAP!S27,HiddenAP!#REF!))","v":{"$error":"#REF!"}},"Tons/Hour"]
[null,"Hand Placement of Asphalt Pavement",null,{"$f":"IF(HiddenAP!#REF!<HiddenAP!R45,HiddenAP!R45,IF(HiddenAP!#REF!>HiddenAP!S45,HiddenAP!S45,HiddenAP!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(HiddenAP!M45<HiddenAP!R45,HiddenAP!R45,IF(HiddenAP!M45>HiddenAP!S45,HiddenAP!S45,HiddenAP!M45))","v":4},{"$f":"IF(HiddenAP!#REF!<HiddenAP!R45,HiddenAP!R45,IF(HiddenAP!#REF!>HiddenAP!S45,HiddenAP!S45,HiddenAP!#REF!))","v":{"$error":"#REF!"}},"Tons/Hour"]
[null,"Base Course Placement",null,{"$f":"IF(HiddenAP!#REF!<HiddenAP!#REF!,HiddenAP!#REF!,IF(HiddenAP!#REF!>HiddenAP!#REF!,HiddenAP!#REF!,HiddenAP!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(HiddenAP!#REF!<HiddenAP!#REF!,HiddenAP!#REF!,IF(HiddenAP!#REF!>HiddenAP!#REF!,HiddenAP!#REF!,HiddenAP!#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(HiddenAP!#REF!<HiddenAP!#REF!,HiddenAP!#REF!,IF(HiddenAP!#REF!>HiddenAP!#REF!,HiddenAP!#REF!,HiddenAP!#REF!))","v":{"$error":"#REF!"}},"Tons/Day"]
[null,"QMP Profiling",null,{"$f":"HiddenAP!J170","v":9100},{"$f":"HiddenAP!K170","v":105116},{"$f":"HiddenAP!L170","v":469300},"S. Y./Day"]
[]
[null,"Profile Milling ",null,{"$f":"HiddenAP!J171","v":14000},{"$f":"HiddenAP!K171","v":14000},{"$f":"HiddenAP!L171","v":14000},"S. Y./Day"]
[]
[null,"Thin milling (0 - 2 in)",null,{"$f":"HiddenAP!J172","v":287},{"$f":"HiddenAP!K172","v":19816},{"$f":"HiddenAP!L172","v":45000},"S. Y./Day"]
[]
[null,"Grooved Epoxy Marking: Grinding Only",null,{"$f":"HiddenAP!J173","v":500},{"$f":"HiddenAP!K173","v":33121},{"$f":"HiddenAP!L173","v":66800},"Ft/Day"]
[]
[null,"Grooved Epoxy Marking: Marking Only",null,{"$f":"HiddenAP!J174","v":500},{"$f":"HiddenAP!K174","v":64433},{"$f":"HiddenAP!L174","v":126000},"Ft/Day"]
[]
[]
[]
[]
[]
["Reliability input",1]
["complexity input",1]

{"sheet":"HiddenAP","index":11,"n_rows":174,"n_cols":22,"rows_kept":174,"cut":false,"hidden":true,"merged":[[173,7,173,8],[159,7,160,13],[169,7,169,8],[170,7,170,8],[171,7,171,8],[172,7,172,8],[138,0,138,4],[42,0,42,4],[62,0,62,4],[4,17,4,18],[5,0,5,4],[5,8,5,9],[24,0,24,4],[119,0,119,4],[82,0,82,4],[100,0,100,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boundaries"]
["Dependent Variable 1: HMA Placement LL\n",null,null,null,null,null,null,null,"x-new (user input)",null,null,null,"Estimate of Ῡ",null,null,null,null,"MIN","MAX"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"HMALL"]
["(Intercept)                                                   ",108.41,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B9*J9+B10*J10","v":108.41},null,null,null,null,20,700,null,"min",20]
["Project Size",45.69,null,null,null,null,null,"ExpediatedSchedule ","1, 2 or 3",{"$f":"'Asphalt Paving'!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",119.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",235]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",350]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V10","v":119.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V11-V10","v":60.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V12-V11","v":55}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate x",{"$f":"M9","v":108.41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V13-V12","v":115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V10-V9","v":99.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V18<=V9,V9,IF(V18>=V13,V13,V18))","v":108.41}]
[]
["Dependent Variable 2: HMA Placement SL\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMASL"]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"B28*J28+B29*J29","v":82.06},null,null,null,null,25,600,null,"min",25]
["(Intercept)",82.06,null,null,null,null,null,"(Intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q1",100]
["Project Size",57.57,null,null,null,null,null,"Project Size","1, 2 or 3",{"$f":"'Asphalt Paving'!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Median",175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",227.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",350]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V28","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V29-V28","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V30-V29","v":52.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M27","v":82.06}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V31-V30","v":122.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V28-V27","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V36<=V27,V27,IF(V36>=V31,V31,V36))","v":82.06}]
[]
["Dependent Variable 3: Hand Placement of Asphalt Pavement\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAND AP"]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"B46*J46+B47*J47+B48*J48+B49*J49+B50*J50+B51*J51+B52*J52+B53*J53+B54*J54+B55*J55+B56*J56+B57*J57+B58*J58+B59*J59+B60*J60","v":-332.60599999999999},null,null,null,null,4,50,null,"min",4]
["(Intercept)",-332.60599999999999,null,null,null,null,null,"(Intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q1",20]
["Project Length",96.852999999999994,null,null,null,null,null,"Project Length","1,2 or 3",{"$f":"'Asphalt Paving'!F29","v":0},null,null,null,null,null,null,null,null,null,null,"Median",37.5]
["Difficulty",-98.42,null,null,null,null,null,"Difficulty","1,2 or 3",{"$f":"'Asphalt Paving'!F39","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",48]
["Staged Construction",94.263000000000005,null,null,null,null,null,"Staged Construction","1,2 or 3",{"$f":"'Asphalt Paving'!F35","v":0},null,null,null,null,null,null,null,null,null,null,"Max",150]
["Expediated Schedule",-23.687999999999999,null,null,null,null,null,"Expediated Schedule","1,2 or 3",{"$f":"'Asphalt Paving'!F27","v":0}]
["Project Size",81.59,null,null,null,null,null,"Project Size","1,2 or 3",{"$f":"'Asphalt Paving'!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V46","v":20}]
["Season",71.772999999999996,null,null,null,null,null,"Season","1,2 or 3",{"$f":"'Asphalt Paving'!F34","v":0},null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V47-V46","v":17.5}]
["Storage and Staging",39.200000000000003,null,null,null,null,null,"Storage and Staging","1,2 or 3",{"$f":"'Asphalt Paving'!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V48-V47","v":10.5}]
["Type of Work",170.083,null,null,null,null,null,"Type of Work","1,2 or 3",{"$f":"'Asphalt Paving'!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M45","v":-332.60599999999999}]
["Type Amount of Milling",-52.445999999999998,null,null,null,null,null,"Type Amount of Milling","1,2 or 3",{"$f":"'Asphalt Paving'!F37","v":0},null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V49-V48","v":102}]
["Typical Transitions",86.116,null,null,null,null,null,"Typical Transitions","1,2 or 3",{"$f":"'Asphalt Paving'!F33","v":0},null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V46-V45","v":16}]
["Night Paving",-90.721999999999994,null,null,null,null,null,"Night Paving","1,2 or 3",{"$f":"'Asphalt Paving'!F28","v":0},null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
["Ride Specification",75.593999999999994,null,null,null,null,null,"Ride Specification","1,2 or 3",{"$f":"'Asphalt Paving'!F38","v":0}]
["Urban Project",-142.99100000000001,null,null,null,null,null,"Urban Project","1,2 or 3",{"$f":"'Asphalt Paving'!F31","v":0},null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V54<=V45,V45,IF(V54>=V49,V49,V54))","v":4}]
["Asphalt Thickness",-104.108,null,null,null,null,null,"Asphalt Thickness","1,2 or 3",{"$f":"'Asphalt Paving'!F36","v":0}]
[]
[]
["Dependent Variable 4: Thick milling (≥2 in)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thick Milling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",1467]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",6000]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"B67*J67+B68*J68","v":1638},null,null,null,null,1467,20500,null,"Median",11000]
["(Intercept)",1638,null,null,null,null,null,"(Intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q3",14793]
["ProjectLength",4794,null,null,null,null,null,"ProjectLength","1, 2 or 3",{"$f":"'Asphalt Paving'!F29","v":0},null,null,null,null,null,null,null,null,null,null,"Max",20500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V65","v":6000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V66-V65","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V67-V66","v":3793}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M66","v":1638}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V68-V67","v":5707}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V65-V64","v":4533}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V73<=V64,V64,IF(V73>=V68,V68,V73))","v":1638}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Course"]
["Dependent Variable 5: Base Course",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",885]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"B86*J86+B87*J87+B88*J88","v":1199.2},null,null,null,null,9100,469300,null,"Median",1200]
["(Intercept)",1199.2,null,null,null,null,null,"(Intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q3",2158]
["Difficulty",866.5,null,null,null,null,null,"Difficulty","1, 2 or 3",{"$f":"'Asphalt Paving'!F39","v":0},null,null,null,null,null,null,null,null,null,null,"Max",3400]
["Storage and Staging",-709.9,null,null,null,null,null,"Storage and Staging","1, 2 or 3",{"$f":"'Asphalt Paving'!F32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V84","v":885}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V85-V84","v":315}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V86-V85","v":958}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M85","v":1199.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V87-V86","v":1242}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V84-V83","v":825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V92<=V83,V83,IF(V92>=V87,V87,V92))","v":1199.2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QMP Density"]
["Dependent Variable 6: QMP Density",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",5147.25]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"B104*J104+B105*J105+B106*J106","v":4743},null,null,null,null,2000,40000,null,"Median",10500]
[" (Intercept)    ",4743,null,null,null,null,null," (Intercept)    ",1,1,null,null,null,null,null,null,null,null,null,null,"Q3",15250]
["TypeAmountMiling",-9140,null,null,null,null,null,"TypeAmountMiling","1, 2 or 3",{"$f":"'Asphalt Paving'!F37","v":0},null,null,null,null,null,null,null,null,null,null,"Max",40000]
["Staged Construction",-8472,null,null,null,null,null,"Staged Construction","1, 2 or 3",{"$f":"'Asphalt Paving'!F35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V102","v":5147.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V103-V102","v":5352.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V104-V103","v":4750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M103","v":4743}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V105-V104","v":24750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V102-V101","v":3147.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V110<=V101,V101,IF(V110>=V105,V105,V110))","v":4743}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rumble Center"]
["Dependent Variable 7: Rumble Strip Center(new to tool)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",9225]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"J123*B123+B124*J124+B125*J125+B126*J126+B127*J127+B128*J128+B129*J129+B130*J130","v":47221},null,null,null,null,650,125000,null,"Median",34569.5]
["(intercept)",47221,null,null,null,null,null,"(intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q3",49456.75]
["RideSpecification",5635,null,null,null,null,null,"RideSpecification","1, 2 or 3",{"$f":"'Asphalt Paving'!F38","v":0},null,null,null,null,null,null,null,null,null,null,"Max",125000]
["Typical Transitions",-105228,null,null,null,null,null,"Typical Transitions","1, 2 or 3",{"$f":"'Asphalt Paving'!F33","v":0}]
["ProjectSize",105453,null,null,null,null,null,"ProjectSize","1, 2 or 3",{"$f":"'Asphalt Paving'!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V121","v":9225}]
["Asphalt Thickness",12680,null,null,null,null,null,"Asphalt Thickness","1, 2 or 3",{"$f":"'Asphalt Paving'!F36","v":0},null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V122-V121","v":25344.5}]
["Storage and Staging",-16872,null,null,null,null,null,"Storage and Staging","1, 2 or 3",{"$f":"'Asphalt Paving'!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V123-V122","v":14887.25}]
["Project Length",-13854,null,null,null,null,null,"Project Length","1, 2 or 3",{"$f":"'Asphalt Paving'!F29","v":0},null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M122","v":47221}]
["Project Width",-12905,null,null,null,null,null,"Project Width","1, 2 or 3",{"$f":"'Asphalt Paving'!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V124-V123","v":75543.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V121-V120","v":8575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V129<=V120,V120,IF(V129>=V124,V124,V129))","v":47221}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rumble Shoulder"]
["Dependent Variable 8: Rumble Strip Shoulder(new to tool)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",1250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",15000]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,{"$f":"J142*B142+B143*J143+B144*J144+B145*J145","v":-150645},null,null,null,null,1250,125000,null,"Median",24000]
["(intercept)",-150645,null,null,null,null,null,"(intercept)",1,1,null,null,null,null,null,null,null,null,null,null,"Q3",30250]
["RideSpecification",36910,null,null,null,null,null,"RideSpecification","1, 2 or 3",{"$f":"'Asphalt Paving'!F38","v":0},null,null,null,null,null,null,null,null,null,null,"Max",125000]
["Type Amount of Milling",47590,null,null,null,null,null,"Typical Transitions","1, 2 or 3",{"$f":"'Asphalt Paving'!F33","v":0}]
["Project Width",30549,null,null,null,null,null,"Asphalt Thickness","1, 2 or 3",{"$f":"'Asphalt Paving'!F36","v":0},null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V140","v":15000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V141-V140","v":9000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V142-V141","v":6250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M141","v":-150645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V143-V142","v":94750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V140-V139","v":13750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V148<=V139,V139,IF(V148>=V143,V143,V148))","v":1250}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Non Modelled Activities"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Min","Average","Max","N"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.5]
[null,null,null,null,null,null,null,"QMP Profiling",null,9100,105116,469300,9]
[null,null,null,null,null,null,null,"Profile Milling",null,14000,14000,14000,1]
[null,null,null,null,null,null,null,"Thin Milling(0-2 in)",null,287,19816,45000,12]
[null,null,null,null,null,null,null,"Grooved Epoxy Marking: Grinding Only",null,500,33121,66800,4]
[null,null,null,null,null,null,null,"Grooved Epoxy Marking: Marking Only",null,500,64433,126000,3]

{"sheet":"Concrete Paving","index":12,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[[40,5,42,5],[33,2,33,4],[34,2,34,4],[35,2,35,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[32,2,32,4],[36,2,36,4],[23,2,23,4],[25,2,25,4],[26,2,26,4],[24,2,24,4],[31,2,31,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Main Menu'!M16=\"\",\"\",'Main Menu'!M16)","v":""}]
[null,"Project Location",{"$f":"IF('Main Menu'!M17=\"\",\"\",'Main Menu'!M17)","v":""}]
[null,"Date",{"$f":"IF('Main Menu'!M18=\"\",\"\",'Main Menu'!M18)","v":""}]
[null,"Description",{"$f":"IF('Main Menu'!M19=\"\",\"\",'Main Menu'!M19)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF('Main Menu'!M20=\"\",\"\",'Main Menu'!M20)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Factor","Description",null,null,"Severity"]
[null,"Project Size","1 = Small ( ≤ 15,000 total square yards)\n2 = Medium (15,000 - 100,000 total square yards)\n3 = Large ( ≥ 100,000 total square yards)"]
[null,"Expedited Project Schedule","1 = 40 hours week, 8 hours per day, normal (optimum) crew size, no work on holidays.\n2 = 50 hours per week, larger than normal or constantly changing crew sizes, work on some holidays.\n3 = Working beyond 50 weekly hours (overtime), much larger than normal crew sizes (overmanning), working on all holidays, no excuse completion dates."]
[null,"Night Time Paving","1 = Daytime paving\n3 = Nighttime paving"]
[null,"Project Length","1 = Short total project length\n2 = Medium total project length\n3 = Long total project length"]
[null,"Urban Project","1 = Rural area no traffic\n2 = Rural area under traffic\n3 = Urban area with city streets, commercial buildings, urban cross-sections, curb and gutter"]
[null,"Traffic Conditions","1 = Low traffic, road closed\n2 = Moderate traffic, paving adjacent to existing traffic\n3 = High traffic, open to traffic, lane restrictions, limited work area"]
[null,"Size and Proximity of Storage and Staging Areas","1 = Adequate storage and staging, on site\n2 = Limited size of storage and staging\n3 = Insufficient storage and staging, in the general area of the project"]
[null,"Materials Delivery","1 = Easy to get materials and equipment to paving site\n2 = Difficult to get materials and equipment to paving site\n3 = Very difficult to get materials and equipment to paving site"]
[null,"Project Constraints","1 = No site constraints (few utilities, intersections, driveways, gaps, roundabouts)\n2 = Moderate site constraints (some utilities, ramps, limited space for equipment, adjacent buildings)\n3 = Difficult site constraints (presence of significant utilities, conflict with other operations)"]
[null,"Numerous Typical Section Transitions","1 = Continuous pavement width\n2 = Some incidental pavement (intersections, ramp tapers)\n3 = Many incidental pavement areas (roundabouts, intersections, ramps)"]
[null,"Season","1 = Summer, air temperature above 60 °F, some rainfall (minimum level)\n2 = Spring or fall, air temperature between 35 and 60 °F, moderate level of rainfall\n3 = Winter, air temperature below 35 °F, extreme rainfall and snow"]
[null,"Staged Contruction","1 = Single phase \n2 = Two phases, structure done half at a time\n3 = Three or more phases, portions of roadway done in different stages and multiple mobilizations"]
[null,"Difficulty","1 = Normal\n2 = Difficult\n3 = Very Difficult"]

{"sheet":"Output CP","index":13,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":true,"merged":[[30,1,32,2],[33,1,35,2],[36,1,38,2],[10,2,10,3],[14,2,14,3],[11,2,11,3],[13,2,13,3],[12,2,12,3],[27,1,29,2],[20,1,20,2],[21,1,23,2],[24,1,26,2],[19,3,19,6],[40,3,40,6],[41,1,41,2],[46,1,47,2],[44,1,45,2],[42,1,43,2],[43,3,43,6],[45,3,45,6],[47,3,47,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Concrete Paving'!C13=\"\",\" \",'Concrete Paving'!C13)","v":" "}]
[null,"Project Location",{"$f":"IF('Concrete Paving'!C14=\"\",\" \",'Concrete Paving'!C14)","v":" "}]
[null,"Date",{"$f":"IF('Concrete Paving'!C15=\"\",\" \",'Concrete Paving'!C15)","v":" "}]
[null,"Description",{"$f":"IF('Concrete Paving'!C16=\"\",\" \",'Concrete Paving'!C16)","v":" "}]
[null,"Name/Initials of Respondent",{"$f":"IF('Concrete Paving'!C17=\"\",\" \",'Concrete Paving'!C17)","v":" "}]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Predicted Value","Max","Unit/Day"]
[null,"Concrete Paving (thickness > 10\")",null,{"$f":"'Hidden CP'!$V$9","v":173},{"$f":"'Hidden CP'!V23","v":852.3},{"$f":"'Hidden CP'!$V$13","v":12000},"S.Y./Day"]
[]
[]
[null,"Concrete Paving (thickness < 10\")",null,{"$f":"'Hidden CP'!$V$28","v":300},{"$f":"'Hidden CP'!$V$37","v":2565},{"$f":"'Hidden CP'!$V$32","v":14000},"S.Y./Day"]
[]
[]
[null,"Base Course",null,{"$f":"'Hidden CP'!$V$47","v":21},{"$f":"'Hidden CP'!$V$56","v":1247.8},{"$f":"'Hidden CP'!$V$51","v":3940},"Tons/Day"]
[]
[]
[null,"Sidewalks",null,{"$f":"'Hidden CP'!$V$69","v":350},{"$f":"'Hidden CP'!V83","v":3393.6},{"$f":"'Hidden CP'!$V$73","v":10000},"S.F./Day"]
[]
[]
[null,"Hand Placement of Concrete",null,{"$f":"'Hidden CP'!$V$89","v":57},{"$f":"'Hidden CP'!$V$98","v":172.12},{"$f":"'Hidden CP'!$V$93","v":1300},"S.Y./Day"]
[]
[]
[null,"Curb and Gutter",null,{"$f":"'Hidden CP'!$V$108","v":300},{"$f":"'Hidden CP'!$V$122","v":2642.5},{"$f":"'Hidden CP'!$V$112","v":4112},"S.Y./Day"]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Average","Max","Unit/Day"]
[null,"Barrier Wall ",null,{"$f":"'Hidden CP'!J140","v":44},{"$f":"'Hidden CP'!K140","v":1032},{"$f":"'Hidden CP'!L140","v":2000},"Ft"]
[]
[null,"Grinding ",null,1000,1500,2000,"S.Y."]
[]
[null,"Patching ",null,{"$f":"'Hidden CP'!J142","v":70},{"$f":"'Hidden CP'!K142","v":285},{"$f":"'Hidden CP'!L142","v":725},"S.Y."]
[]
[]
[]
[]
[]
[]
["Reliability input",1]
["complexity input",1]

{"sheet":"Hidden CP","index":14,"n_rows":142,"n_cols":22,"rows_kept":142,"cut":false,"hidden":true,"merged":[[65,0,65,4],[85,0,85,4],[4,17,4,18],[5,0,5,4],[5,8,5,9],[24,0,24,4],[43,0,43,4],[129,7,130,13],[139,7,139,8],[140,7,140,8],[141,7,141,8],[104,0,104,4]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boundaries"]
["Dependent Variable 1: Thick Concrete Paving\n",null,null,null,null,null,null,null,"x-new (user input)",null,null,null,"Estimate of Ῡ",null,null,null,null,"MIN","MAX"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Thick Paving"]
["(Intercept)                                                   ",852.3,null,null,null,null,null,"(Intercept)                                                   ",1,1,null,null,{"$f":"B9*J9+B10*J10+B11*J11+B12*J12+B13*J13+B14*J14+B15*J15+B16*J16+B17*J17+B18*J18","v":852.3},null,null,null,null,3000,11000,null,"min",173]
["Size",5779.1,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"'Concrete Paving'!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",1500]
["Season",-5166.5,null,null,null,null,null,"Season","1, 2 or 3",{"$f":"'Concrete Paving'!F35","v":0},null,null,null,null,null,null,null,null,null,null,"Median",3500]
["Traffic Conditions",2643.8,null,null,null,null,null,"Traffic Conditions","1, 2 or 3",{"$f":"'Concrete Paving'!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",7350]
["Night Paving",3728.3,null,null,null,null,null,"Night Paving","1, 2 or 3",{"$f":"'Concrete Paving'!F27","v":0},null,null,null,null,null,null,null,null,null,null,"Max",12000]
["Typical Section",-2231.1999999999998,null,null,null,null,null,"Typical Section","1, 2 or 3",{"$f":"'Concrete Paving'!F34","v":0}]
["Staged Construction",-1644.4,null,null,null,null,null,"Staged Construction","1, 2 or 3",{"$f":"'Concrete Paving'!F36","v":0},null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V10","v":1500}]
["Storage Staging",4199.8999999999996,null,null,null,null,null,"Storage Staging","1, 2 or 3",{"$f":"'Concrete Paving'!F31","v":0},null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V11-V10","v":2000}]
["Project Constraints",-5000.6000000000004,null,null,null,null,null,"Project Constraints","1, 2 or 3",{"$f":"'Concrete Paving'!F33","v":0},null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V12-V11","v":3850}]
["Materials Delivery",-1694.5,null,null,null,null,null,"Materials Delivery","1, 2 or 3",{"$f":"'Concrete Paving'!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M9","v":852.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V13-V12","v":4650}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V10-V9","v":1327}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V18<=V9,V9,IF(V18>=V13,V13,V18))","v":852.3}]
[]
["Dependent Variable 2: Thin Concrete Paving\n"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Thin Paving"]
["(Intercept)                                                   ",2565,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B28*J28+B29*J29+B30*J30+B31*J31","v":2565},null,null,null,null,1233,11264,null,"min",300]
["ExpediatedSchedule",-2662.1,null,null,null,null,null,"ExpediatedSchedule","1, 2 or 3",{"$f":"'Concrete Paving'!F26","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",2000]
["NightPaving",2899.3,null,null,null,null,null,"NightPaving","1, 2 or 3",{"$f":"'Concrete Paving'!F27","v":0},null,null,null,null,null,null,null,null,null,null,"Median",3100]
["Difficulty",1518.7,null,null,null,null,null,"Difficulty","1, 2 or 3",{"$f":"'Concrete Paving'!F37","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",5575]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",14000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V29","v":2000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V30-V29","v":1100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V31-V30","v":2475}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M28","v":2565}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V32-V31","v":8425}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V29-V28","v":1700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V37<=V28,V28,IF(V37>=V32,V32,V37))","v":2565}]
[]
["Dependent Variable 3: Base Course"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Base Course"]
["(Intercept)                                                   ",1247.8,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B47*J47+B48*J48+B49*J49+B50*J50+B51*J51+B52*J52+B53*J53+B54*J54","v":1247.8},null,null,null,null,400,3940,null,"min",21]
["Traffic Conditions",-1156.7,null,null,null,null,null,"Traffic Conditions","1, 2 or 3",{"$f":"'Concrete Paving'!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",762.5]
["Difficulty",484.2,null,null,null,null,null,"Difficulty","1, 2 or 3",{"$f":"'Concrete Paving'!F37","v":0},null,null,null,null,null,null,null,null,null,null,"Median",1200]
["Project Length",664,null,null,null,null,null,"Project Length","1, 2 or 3",{"$f":"'Concrete Paving'!F28","v":0},null,null,null,null,null,null,null,null,null,null,"Q3",2000]
["Night Paving",1011.8,null,null,null,null,null,"Night Paving","1, 2 or 3",{"$f":"'Concrete Paving'!F27","v":0},null,null,null,null,null,null,null,null,null,null,"Max",3940]
["Expediated Schedule",424.8,null,null,null,null,null,"Expediated Schedule","1, 2 or 3",{"$f":"'Concrete Paving'!F26","v":0}]
["Project Constraints",-436.7,null,null,null,null,null,"Project Constraints","1, 2 or 3",{"$f":"'Concrete Paving'!F33","v":0},null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V48","v":762.5}]
["Materials Delivery",-378.9,null,null,null,null,null,"Materials Delivery","1, 2 or 3",{"$f":"'Concrete Paving'!F32","v":0},null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V49-V48","v":437.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V50-V49","v":800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M47","v":1247.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V51-V50","v":1940}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V48-V47","v":741.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V56<=V47,V47,IF(V56>=V51,V51,V56))","v":1247.8}]
[]
[]
[]
[]
["Dependent Variable 4: Sidewalks"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Sidewalks"]
["(Intercept)                                                   ",3393.6,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B69*J69+B70*J70+B71*J71","v":3393.6},null,null,null,null,700,16500,null,"min",350]
["Traffic Conditions",-1999.4,null,null,null,null,null,"Traffic Conditions","1, 2 or 3",{"$f":"'Concrete Paving'!F30","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",1370]
["Storage Staging",2305.1999999999998,null,null,null,null,null,"Storage Staging","1, 2 or 3",{"$f":"'Concrete Paving'!F31","v":0},null,null,null,null,null,null,null,null,null,null,"Median",2763]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",10000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V70","v":1370}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V71-V70","v":1393}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V72-V71","v":2237}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M69","v":3393.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V73-V72","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V70-V69","v":1020}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V78<=V69,V69,IF(V78>=V73,V73,V78))","v":3393.6}]
[]
[]
["Dependent Variable 5: Hand Placement of CP"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Hand Placement"]
["(Intercept)                                                   ",172.12,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B89*J89+B90*J90","v":172.12},null,null,null,null,140,1300,null,"min",57]
["Size",167.66,null,null,null,null,null,"Size","1, 2 or 3",{"$f":"'Concrete Paving'!F25","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",425]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",622.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",1300]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V90","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V91-V90","v":175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V92-V91","v":197.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M89","v":172.12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V93-V92","v":677.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V90-V89","v":193}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V98<=V89,V89,IF(V98>=V93,V93,V98))","v":172.12}]
[]
["Dependent Variable 6: Curb and Gutter"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,null,null,null,null,null,null,"Curb and Gutter"]
["(Intercept)                                                   ",2642.5,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B108*J108+B109*J109","v":2642.5},null,null,null,null,null,null,null,"min",300]
["Staged Construction",-546,null,null,null,null,null,"Staged Construction","1, 2 or 3",{"$f":"'Concrete Paving'!F36","v":0},null,null,null,null,null,null,null,null,null,null,"Q1",550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",4112]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"V109","v":550}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"V110-V109","v":650}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"V111-V110","v":800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M108","v":2642.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"V112-V111","v":2112}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"V109-V108","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(V117<=V108,V108,IF(V117>=V112,V112,V117))","v":2642.5}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Non Modelled Activities"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Min","Average","Max","N"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.5]
[null,null,null,null,null,null,null,"Barrier Wall",null,44,1032,2000,9]
[null,null,null,null,null,null,null,"Grinding",null,1000,1500,2000,0]
[null,null,null,null,null,null,null,"Patching",null,70,285,725,5]

{"sheet":"Miscellaneous Activities","index":15,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[28,2,28,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[41,2,41,4],[45,5,47,5],[39,2,39,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[40,2,40,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Main Menu'!M16=\"\",\"\",'Main Menu'!M16)","v":""}]
[null,"Project Location",{"$f":"IF('Main Menu'!M17=\"\",\"\",'Main Menu'!M17)","v":""}]
[null,"Date",{"$f":"IF('Main Menu'!M18=\"\",\"\",'Main Menu'!M18)","v":""}]
[null,"Description",{"$f":"IF('Main Menu'!M19=\"\",\"\",'Main Menu'!M19)","v":""}]
[null,"Name/Initials of Respondent",{"$f":"IF('Main Menu'!M20=\"\",\"\",'Main Menu'!M20)","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Factor","Description",null,null,"Severity"]
[null,"Type of Construction","1 = New construction project\n2 = Reconstruction, resurfacing or maintenance project\n3 = Rehabilitation project (structure currently used for transportation)"]
[null,"Expedited Project Schedule","1 = 40 hours week, 8 hours per day, normal (optimum) crew size, no work on holidays.\n2 = 50 hours per week, larger than normal or constantly changing crew sizes, work on some holidays.\n3 = Working beyond 50 weekly hours (overtime), much larger than normal crew sizes (overmanning), working on all holidays, no excuse completion dates."]
[null,"Night Time Construction","1 = Daytime construction\n3 = Nighttime construction"]
[null,"Urban Project","1 = Rural area no traffic\n2 = Rural area under traffic\n3 = Urban area with city streets, nearby residents, commercial buildings, urban cross-sections"]
[null,"Size and Proximity of Storage and Staging Areas","1 = Adequate storage and staging, on site\n2 = Limited size of storage and staging\n3 = Insufficient storage and staging, in the general area of the project"]
[null,"Numerous Typical Section Transitions","1 = Continuous pavement width\n2 = Some incidental pavement (intersections, ramp tapers)\n3 = Many incidental pavement areas (roundabouts, intersections, ramps)"]
[null,"Season","1 = Summer, air temperature above 60 °F, some rainfall (minimum level)\n2 = Spring or fall, air temperature between 35 and 60 °F, moderate level of rainfall\n3 = Winter, air temperature below 35 °F, extreme rainfall and snow"]
[null,"Staged Construction","1 = Single phase \n2 = Two phases, structure done half at a time\n3 = Three or more phases, portions of roadway done in different stages and multiple mobilizations"]
[null,"Type and Amount of Miling","1 = No correction required\n2 = Some correction and asphalt paving removal required\n3 = Significant correction required"]
[null,"Presence of Ride Specification","1 = No ride specification\n3 = Presence of ride specifications (such as International Roughness Index)"]
[null,"Project Difficulty","Based on your experience and your past projects, you consider this project to be:\n1 = Normal Project  \n2 = Difficult Project \n3 = Very Difficult Project "]
[null,"Project Duration","1 = Short ( ≤ 15 calendar weeks)\n2 = Mid-range (15-30 calendar weeks)\n3 = Long ( ≥ 30 calendar weeks)"]
[null,"Traffic Conditions","1 = Low traffic, road closed\n2 = Moderate traffic, working adjacent to existing traffic\n3 = High traffic, open to traffic, lane restrictions, limited work area"]
[null,"Project Constraints","1 = No site constraints (few utilities, intersections, driveways, gaps, roundabouts)\n2 = Moderate site constraints (some utilities, ramps, limited space for equipment, adjacent buildings)\n3 = Difficult site constraints (presence of significant utilities, conflict with other operations)"]
[null,"Permit Restrictions","1 = Having approved environmental documents, no noise constraints, no vibration constraints\n2 = Need to account for noise restrictions and/or vibration constraints during operating time\n3 = Different permits needed for erosion control issues, water and dust constraints, storm water treatment, hazardous material, removal and disposal of underground fuel tanks, contaminated soils"]
[null,"Materials Delivery","1 = Easy to get materials and equipment to paving site\n2 = Difficult to get materials and equipment to paving site\n3 = Very difficult to get materials and equipment to paving site"]
[null,"Soil Moisture Condition","1 = Soil near optimum moisture\n2 = Wet soil that must be dried\n3 = Very wet soil"]
[null,"Soil Type","1 = Soil is mainly sand\n2 = Soil is granular and sandy with some silt and clay\n3 = Soil is mainly wet silt, clay or silty clay "]

{"sheet":"Output Misc.","index":16,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":true,"merged":[[20,3,20,6],[31,1,33,2],[34,1,36,2],[25,1,27,2],[28,1,30,2],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[80,3,80,6],[82,3,82,6],[84,3,84,6],[86,3,86,6],[21,1,21,2],[22,1,24,2],[46,1,48,2],[37,1,39,2],[40,1,42,2],[43,1,45,2],[49,1,51,2],[52,1,54,2],[53,3,54,6],[57,3,57,6],[70,3,70,6],[72,3,72,6],[74,3,74,6],[76,3,76,6],[78,3,78,6],[60,3,60,6],[62,3,62,6],[64,3,64,6],[66,3,66,6],[68,3,68,6],[58,1,58,2],[85,1,86,2],[83,1,84,2],[81,1,82,2],[59,1,60,2],[61,1,62,2],[63,1,64,2],[65,1,66,2],[67,1,68,2],[69,1,70,2],[71,1,72,2],[73,1,74,2],[75,1,76,2],[77,1,78,2],[79,1,80,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project ID",{"$f":"IF('Miscellaneous Activities'!C13=\"\",\" \",'Miscellaneous Activities'!C13)","v":" "}]
[null,"Project Location",{"$f":"IF('Miscellaneous Activities'!C14=\"\",\" \",'Miscellaneous Activities'!C14)","v":" "}]
[null,"Date",{"$f":"IF('Miscellaneous Activities'!C15=\"\",\" \",'Miscellaneous Activities'!C15)","v":" "}]
[null,"Description",{"$f":"IF('Miscellaneous Activities'!C16=\"\",\" \",'Miscellaneous Activities'!C16)","v":" "}]
[null,"Name/Initials of Respondent",{"$f":"IF('Miscellaneous Activities'!C17=\"\",\" \",'Miscellaneous Activities'!C17)","v":" "}]
[]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Predicted Value","Max","Unit/Day"]
[null,"Adjust Frames and Grates",null,{"$f":"'Hidden Misc.'!$P$10","v":1},{"$f":"'Hidden Misc.'!P24","v":71.150999999999996},{"$f":"'Hidden Misc.'!$P$14","v":74},"Each/Day"]
[]
[]
[null,"Pipe Underdrains",null,{"$f":"'Hidden Misc.'!$P$29","v":110},{"$f":"'Hidden Misc.'!P43","v":110},{"$f":"'Hidden Misc.'!$P$33","v":4349},"Ft/Day"]
[]
[]
[null,"Riprap Light/Medium",null,{"$f":"'Hidden Misc.'!P49","v":20},{"$f":"'Hidden Misc.'!P63","v":20},{"$f":"'Hidden Misc.'!P53","v":216},"S.Y./Day"]
[]
[]
[null,"Riprap Heavy/Extra Heavy",null,{"$f":"'Hidden Misc.'!$P$67","v":49},{"$f":"'Hidden Misc.'!P81","v":1100},{"$f":"'Hidden Misc.'!$P$71","v":1100},"S.Y./Day"]
[]
[]
[null,"Concrete Barrier",null,{"$f":"'Hidden Misc.'!P86","v":44},{"$f":"'Hidden Misc.'!P100","v":925.9},{"$f":"'Hidden Misc.'!P90","v":3280},"Ft/Day"]
[]
[]
[null,"Paint Pavement Marking(Truck)",null,{"$f":"'Hidden Misc.'!$P$106","v":1117},{"$f":"'Hidden Misc.'!P120","v":33394},{"$f":"'Hidden Misc.'!$P$110","v":48971},"Ft/Day"]
[]
[]
[null,"Excelsior Blanket",null,{"$f":"'Hidden Misc.'!P125","v":190},{"$f":"'Hidden Misc.'!P139","v":190},{"$f":"'Hidden Misc.'!P129","v":10000},"S.Y./Day"]
[]
[]
[null,"Seeding",null,{"$f":"'Hidden Misc.'!$P$144","v":0.25},{"$f":"'Hidden Misc.'!P158","v":0.25},{"$f":"'Hidden Misc.'!$P$148","v":4},"Acre/Day"]
[]
[]
[null,"Straw Mulch",null,{"$f":"'Hidden Misc.'!$P$163","v":500},{"$f":"'Hidden Misc.'!P177","v":500},{"$f":"'Hidden Misc.'!$P$167","v":25000},"Ton/Day"]
[]
[]
[null,"Remove Concrete Pavement",null,{"$f":"'Hidden Misc.'!$P$182","v":150},{"$f":"'Hidden Misc.'!P196","v":150},{"$f":"'Hidden Misc.'!$P$186","v":24000},"S.Y./Day"]
[]
[]
[null,"Geotextiles",null,{"$f":"'Hidden Misc.'!$P$201","v":12},{"$f":"'Hidden Misc.'!P215","v":1204},{"$f":"'Hidden Misc.'!$P$205","v":1204},"S.Y./Day"]
[]
[]
[]
[]
[null,null,null,"Productivity Rates"]
[null,"Activity",null,"Min","Average","Max","Unit/Day"]
[null,"Catch Basins",null,{"$f":"'Hidden Misc.'!J234","v":1.5},{"$f":"'Hidden Misc.'!K234","v":5.6749999999999998},{"$f":"'Hidden Misc.'!L234","v":23},"Each"]
[]
[null,"Chain Link Fence",null,{"$f":"'Hidden Misc.'!J235","v":349},{"$f":"'Hidden Misc.'!K235","v":741},{"$f":"'Hidden Misc.'!L235","v":2000},"Ft"]
[]
[null,"Culvert Pipe",null,{"$f":"'Hidden Misc.'!J236","v":40},{"$f":"'Hidden Misc.'!K236","v":179},{"$f":"'Hidden Misc.'!L236","v":589},"Ft"]
[]
[null,"Electrical Conduit In Trench",null,{"$f":"'Hidden Misc.'!J237","v":350},{"$f":"'Hidden Misc.'!K237","v":1057},{"$f":"'Hidden Misc.'!L237","v":2500},"Ft"]
[]
[null,"Electrical Wire Pulling(Lighting)",null,{"$f":"'Hidden Misc.'!J238","v":1000},{"$f":"'Hidden Misc.'!K238","v":7362},{"$f":"'Hidden Misc.'!L238","v":16300},"Ft"]
[]
[null,"Electrical Wire Pulling(Signals)",null,{"$f":"'Hidden Misc.'!J239","v":1000},{"$f":"'Hidden Misc.'!K239","v":2748},{"$f":"'Hidden Misc.'!L239","v":5593},"Ft"]
[]
[null,"Manholes",null,{"$f":"'Hidden Misc.'!J240","v":0.5},{"$f":"'Hidden Misc.'!K240","v":3.5},{"$f":"'Hidden Misc.'!L240","v":12},"Each"]
[]
[null,"Remove Curb & Gutter",null,{"$f":"'Hidden Misc.'!J241","v":200},{"$f":"'Hidden Misc.'!K241","v":2260},{"$f":"'Hidden Misc.'!L241","v":10300},"Ft"]
[]
[null,"Remove Sidewalk",null,{"$f":"'Hidden Misc.'!J242","v":100},{"$f":"'Hidden Misc.'!K242","v":1371},{"$f":"'Hidden Misc.'!L242","v":7850},"Sy"]
[]
[null,"Seal Coat",null,15840,26400,52800,"Ft"]
[]
[null,"Silt Fence",null,{"$f":"'Hidden Misc.'!J244","v":110},{"$f":"'Hidden Misc.'!K244","v":2005},{"$f":"'Hidden Misc.'!L244","v":10000},"Ft"]
[]
[null,"Sodding",null,{"$f":"'Hidden Misc.'!J245","v":321},{"$f":"'Hidden Misc.'!K245","v":3054},{"$f":"'Hidden Misc.'!L245","v":10850},"Sy"]
[]
[null,"Steel Plate Beam Guardrail",null,{"$f":"'Hidden Misc.'!J246","v":25},{"$f":"'Hidden Misc.'!K246","v":618},{"$f":"'Hidden Misc.'!L246","v":1829},"Ft"]
[]
[null,"Steel Plate Beam Guardrail Removal",null,{"$f":"'Hidden Misc.'!J247","v":97},{"$f":"'Hidden Misc.'!K247","v":854},{"$f":"'Hidden Misc.'!L247","v":1900},"Ft"]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[1]

{"sheet":"Hidden Misc.","index":17,"n_rows":247,"n_cols":16,"rows_kept":247,"cut":false,"hidden":true,"merged":[[178,0,178,4],[197,0,197,4],[121,0,121,4],[140,0,140,4],[159,0,159,4],[6,0,6,4],[5,8,5,9],[25,0,25,4],[102,0,102,4],[45,0,45,4],[63,0,63,4],[82,0,82,4],[223,7,224,13],[243,7,243,8],[244,7,244,8],[245,7,245,8],[246,7,246,8],[238,7,238,8],[239,7,239,8],[240,7,240,8],[241,7,241,8],[242,7,242,8],[233,7,233,8],[234,7,234,8],[235,7,235,8],[236,7,236,8],[237,7,237,8]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"x-new (user input)",null,null,null,"Estimate of Ῡ"]
["Dependent Variable 1: FramesGrates"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Frames and Grates"]
["(Intercept)                                                   ",71.150999999999996,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B10*J10+B11*J11","v":71.150999999999996},null,"min",1]
["Duration",-21.872,null,null,null,null,null,"Duration","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F36","v":0},null,null,null,null,"Q1",4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",74]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P11","v":4.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P12-P11","v":7.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P13-P12","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M10","v":71.150999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P14-P13","v":56}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P11-P10","v":3.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P19<=P10,P10,IF(P19>=P14,P14,P19))","v":71.150999999999996}]
[]
["Dependent Variable 2: Pipe Underdrains"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Pipe Underdrains"]
["(Intercept)                                                   ",-1712,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B29*J29+B30*J30+B31*J31+B32*J32","v":-1712},null,"min",110]
["NightWork",1628.1,null,null,null,null,null,"NightWork","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F27","v":0},null,null,null,null,"Q1",175]
["SoilMoisture",1343.7,null,null,null,null,null,"SoilMoisture","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F41","v":0},null,null,null,null,"Median",400]
["Material Delivery",-918.2,null,null,null,null,null,"Material Delivery","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F40","v":0},null,null,null,null,"Q3",1350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",4349]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P30","v":175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P31-P30","v":225}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P32-P31","v":950}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M29","v":-1712}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P33-P32","v":2999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P30-P29","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P38<=P29,P29,IF(P38>=P33,P33,P38))","v":110}]
[]
[]
["Dependent Variable 3: Riprap LM"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Riprap LM"]
["(Intercept)                                                   ",6.3230000000000004,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B49*J49+B50*J50+B51*J51+B52*J52+B53*J53","v":6.3230000000000004},null,"min",20]
["Soil Moisture",58.354999999999997,null,null,null,null,null,"Soil Moisture","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F41","v":0},null,null,null,null,"Q1",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",216]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P50","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P51-P50","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P52-P51","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M49","v":6.3230000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P53-P52","v":66}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P50-P49","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P58<=P49,P49,IF(P58>=P53,P53,P58))","v":20}]
["Dependent Variable 4: Riprap HEH"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Riprap HEH"]
["(Intercept)                                                   ",1167.19,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B67*J67+B68*J68+B69*J69+B70*J70","v":1167.19},null,"min",49]
["Duration",-238.27,null,null,null,null,null,"Duration","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F36","v":0},null,null,null,null,"Q1",80]
["Season",-583.85,null,null,null,null,null,"Season","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F31","v":0},null,null,null,null,"Median",100]
["Staged Construction",266.37,null,null,null,null,null,"Staged Construction","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F32","v":0},null,null,null,null,"Q3",570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",1100]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P68","v":80}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P69-P68","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P70-P69","v":470}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M67","v":1167.19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P71-P70","v":530}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P68-P67","v":31}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P76<=P67,P67,IF(P76>=P71,P71,P76))","v":1100}]
[]
["Dependent Variable 5: Concrete Barrier"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Concrete Barrier"]
["(Intercept)                                                   ",925.9,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B86*J86+B87*J87+B88*J88","v":925.9},null,"min",44]
["Material Delivery",1309.9000000000001,null,null,null,null,null,"Material Delivery","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F40","v":0},null,null,null,null,"Q1",525]
["Duration",-767.3,null,null,null,null,null,"Duration","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F36","v":0},null,null,null,null,"Median",1210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",2062.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",3280]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P87","v":525}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P88-P87","v":685}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P89-P88","v":852.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M86","v":925.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P90-P89","v":1217.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P87-P86","v":481}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P95<=P86,P86,IF(P95>=P90,P90,P95))","v":925.9}]
[]
[]
["Dependent Variable 6: Paint Pavement Marking"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Paint Marking"]
["(Intercept)                                                   ",33394,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B106*J106+B107*J107","v":33394},null,"min",1117]
["Project Constraints",-9756,null,null,null,null,null,"Project Constraints","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F38","v":0},null,null,null,null,"Q1",7250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",12000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",26000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",48971]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P107","v":7250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P108-P107","v":4750}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P109-P108","v":14000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M106","v":33394}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P110-P109","v":22971}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P107-P106","v":6133}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P115<=P106,P106,IF(P115>=P110,P110,P115))","v":33394}]
[]
["Dependent Variable 7: Excelsior Blanket"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Excelsior Blanket"]
["(Intercept)                                                   ",-410.4,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B125*J125+B126*J126+B127*J127","v":-410.4},null,"min",190]
["Soil Moisture",2289,null,null,null,null,null,"Soil Moisture","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F41","v":0},null,null,null,null,"Q1",1325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",2200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",4675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",10000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P126","v":1325}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P127-P126","v":875}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P128-P127","v":2475}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M125","v":-410.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P129-P128","v":5325}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P126-P125","v":1135}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P134<=P125,P125,IF(P134>=P129,P129,P134))","v":190}]
[]
["Dependent Variable 8: Seeding"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Seeding"]
["(Intercept)                                                   ",-6.3640000000000002E-2,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B144*J144+B145*J145+B146*J146+B147*J147+B148*J148","v":-6.3640000000000002E-2},null,"min",0.25]
["Expediated Schedule",0.86438999999999999,null,null,null,null,null,"Expediated Schedule","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F26","v":0},null,null,null,null,"Q1",0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P145","v":0.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P146-P145","v":0.19999999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P147-P146","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M144","v":-6.3640000000000002E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P148-P147","v":2.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P145-P144","v":0.55000000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P153<=P144,P144,IF(P153>=P148,P148,P153))","v":0.25}]
[]
["Dependent Variable 9: Straw Mulch"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Straw Mulch"]
["(Intercept)                                                   ",-6621.5,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B163*J163+B164*J164+B165*J165+B166*J166+B167*J167+B168*J168","v":-6621.5},null,"min",500]
["Night Work",32847.199999999997,null,null,null,null,null,"Night Work","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F27","v":0},null,null,null,null,"Q1",737.75]
["Soil Moisture",15942.9,null,null,null,null,null,"Soil Moisture","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F41","v":0},null,null,null,null,"Median",6200]
["Material Delivery ",-6929.6,null,null,null,null,null,"Material Delivery ","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F40","v":0},null,null,null,null,"Q3",10762.75]
["Soil Type",-4839,null,null,null,null,null,"Soil Type","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F42","v":0},null,null,null,null,"Max",25000]
["Project Constraints",3360.4,null,null,null,null,null,"Project Constraints","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P164","v":737.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P165-P164","v":5462.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P166-P165","v":4562.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M163","v":-6621.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P167-P166","v":14237.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P164-P163","v":237.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P172<=P163,P163,IF(P172>=P167,P167,P172))","v":500}]
[]
["Dependent Variable 10: Remove Pavement"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Remove Pavement"]
["(Intercept)                                                   ",-16777,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B182*J182+B183*J183","v":-16777},null,"min",150]
["Night Work",20388,null,null,null,null,null,"Night Work","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F27","v":0},null,null,null,null,"Q1",645.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",1944]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",3600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",24000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P183","v":645.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P184-P183","v":1298.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P185-P184","v":1656}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M182","v":-16777}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P186-P185","v":20400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P183-P182","v":495.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P191<=P182,P182,IF(P191>=P186,P186,P191))","v":150}]
[]
["Dependent Variable 11: Geotextiles"]
[]
["Factors","Estimated Coef.",null,null,null,null,null,null,"Possible values","Input x0",null,null,null,null,null,"Geotextiles"]
["(Intercept)                                                   ",2043.6,null,null,null,null,null,"(Intercept)",1,1,null,null,{"$f":"B201*J201+B202*J202+B203*J203+B204*J204","v":2043.6},null,"min",12]
["Duration",-587.4,null,null,null,null,null,"Duration","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F36","v":0},null,null,null,null,"Q1",131.5]
["Expediated Schedule",-449.2,null,null,null,null,null,"Expediated Schedule","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F26","v":0},null,null,null,null,"Median",400]
["Difficulty",421.2,null,null,null,null,null,"Difficulty","1, 2 or 3",{"$f":"'Miscellaneous Activities'!F35","v":0},null,null,null,null,"Q3",1073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",1204]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box1 - hidden",{"$f":"P202","v":131.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 - lower",{"$f":"P203-P202","v":268.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bow 3 - upper",{"$f":"P204-P203","v":673}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate",{"$f":"M201","v":2043.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Top",{"$f":"P205-P204","v":131}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whisker Bottom",{"$f":"P202-P201","v":119.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimate y",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output",{"$f":"IF(P210<=P201,P201,IF(P210>=P205,P205,P210))","v":1204}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Non Modelled Activities"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Min","Average","Max","N"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.5,0.5]
[null,null,null,null,null,null,null,"Catch Basins",null,1.5,5.6749999999999998,23,20]
[null,null,null,null,null,null,null,"Chain Link Fence",null,349,741,2000,6]
[null,null,null,null,null,null,null,"Culvert Pipe",null,40,179,589,16]
[null,null,null,null,null,null,null,"Electrical Conduit In Trench",null,350,1057,2500,10]
[null,null,null,null,null,null,null,"Electrical Wire Pulling(Lighting)",null,1000,7362,16300,8]
[null,null,null,null,null,null,null,"Electrical Wire Pulling(Signals)",null,1000,2748,5593,4]
[null,null,null,null,null,null,null,"Manholes",null,0.5,3.5,12,15]
[null,null,null,null,null,null,null,"Remove Curb & Gutter",null,200,2260,10300,11]
[null,null,null,null,null,null,null,"Remove Sidewalk",null,100,1371,7850,8]
[null,null,null,null,null,null,null,"Seal Coat",null,"NA","NA","NA",0]
[null,null,null,null,null,null,null,"Silt Fence",null,110,2005,10000,26]
[null,null,null,null,null,null,null,"Sodding",null,321,3054,10850,5]
[null,null,null,null,null,null,null,"Steel Plate Beam Guardrail",null,25,618,1829,21]
[null,null,null,null,null,null,null,"Steel Plate Beam Guardrail Removal",null,97,854,1900,25]