{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Rearrange","VolumeLookup","Unique Values","Reference Sheet","HCM 2010 Program","WZ Analysis (Worksheet)","ADV WZ Calcs","Acceleration Calcs","Step 1 - Introduction","Step 2 - Facility Data Inputs","Step 3 - WZ Analysis","Step 3a - ADV WZ Analysis","Step 3b - Acceleration Analysis","Step 4 - Synopsis Sheet","Step 4a - ADV WZ Synopsis","Step 4b - Acceleration Synopsis"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":4,"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":"Rearrange","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,14]]}
[]
[]
[]
[]
["Rearranged Data"]
["Segment",{"$f":"REPLACE(LEFT(A1,SEARCH(\"Type:\",A1)-4),1,LOOKUP(9.99999999999999E+307,FIND(\" \",LEFT(A1,SEARCH(\"Segment:\",A1)+9),ROW(INDIRECT(\"1:\"&LEN(A1))))),\"\")","v":{"$error":"#VALUE!"}}]
["Logs",{"$f":"REPLACE(LEFT(A1,LEN(A1)-1),1,LOOKUP(9.99999999999999E+307,FIND(\" \",LEFT(A1,SEARCH(\"Logs:\",A1)+5),ROW(INDIRECT(\"1:\"&LEN(A1))))),\"\")","v":{"$error":"#VALUE!"}}]
["Location Summary",{"$f":"CONCATENATE(\"(Logs: \",B7,\") \",B6)","v":{"$error":"#VALUE!"}}]
["Lanes",{"$f":"REPLACE(LEFT(A1,SEARCH(\"Cap:\",A1)-6),1,LOOKUP(9.99999999999999E+307,FIND(\" \",LEFT(A1,SEARCH(\"Lanes:\",A1)+7),ROW(INDIRECT(\"1:\"&LEN(A1))))),\"\")","v":{"$error":"#VALUE!"}}]
["Date",{"$f":"REPLACE(LEFT(A1,SEARCH(\"Lanes:\",A1)-4),1,LOOKUP(9.99999999999999E+307,FIND(\" \",LEFT(A1,SEARCH(\"Date:\",A1)+6),ROW(INDIRECT(\"1:\"&LEN(A1))))),\"\")","v":{"$error":"#VALUE!"}}]
["Weekday",{"$f":"TEXT(B10,\"DDDD\")","v":{"$error":"#VALUE!"}}]
[12,{"$f":"C2","v":0}]
[1,{"$f":"D2","v":0}]
[2,{"$f":"E2","v":0}]
[3,{"$f":"F2","v":0}]
[4,{"$f":"G2","v":0}]
[5,{"$f":"H2","v":0}]
[6,{"$f":"I2","v":0}]
[7,{"$f":"J2","v":0}]
[8,{"$f":"K2","v":0}]
[9,{"$f":"L2","v":0}]
[10,{"$f":"M2","v":0}]
[11,{"$f":"N2","v":0}]
[12,{"$f":"C3","v":0}]
[1,{"$f":"D3","v":0}]
[2,{"$f":"E3","v":0}]
[3,{"$f":"F3","v":0}]
[4,{"$f":"G3","v":0}]
[5,{"$f":"H3","v":0}]
[6,{"$f":"I3","v":0}]
[7,{"$f":"J3","v":0}]
[8,{"$f":"K3","v":0}]
[9,{"$f":"L3","v":0}]
[10,{"$f":"M3","v":0}]
[11,{"$f":"N3","v":0}]
[]
[]
["Mainline",{"$f":"REPLACE(LEFT(A37,SEARCH(\"Begin\",A37)-3),1,LOOKUP(9.99999999999999E+307,FIND(\" \",LEFT(A37,SEARCH(\"-\",A37)+1),ROW(INDIRECT(\"1:\"&LEN(A37))))),\"\")","v":{"$error":"#VALUE!"}}]

{"sheet":"VolumeLookup","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Lookup",{"$f":"Rearrange!B38","v":{"$error":"#VALUE!"}}]
["Segment"]
["Logs"]
["Location Summary"]
["Lanes"]
["Date"]
["Weekday"]
["00:00:00"]
["01:00:00"]
["02:00:00"]
["03:00:00"]
["04:00:00"]
["05:00:00"]
["06:00:00"]
["07:00:00"]
["08:00:00"]
["09:00:00"]
["10:00:00"]
["11:00:00"]
["12:00:00"]
["13:00:00"]
["14:00:00"]
["15:00:00"]
["16:00:00"]
["17:00:00"]
["18:00:00"]
["19:00:00"]
["20:00:00"]
["21:00:00"]
["22:00:00"]
["23:00:00"]

{"sheet":"Unique Values","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Location","Location","Date","Date"]

{"sheet":"Reference Sheet","index":3,"n_rows":235,"n_cols":28,"rows_kept":235,"cut":false,"hidden":true,"merged":[]}
["DISTRICTS:",null,"COUNTY:","COUNTY:","ROUTE:",null,"ROUTE:",null,"I","US","MO","RT",null,"STATE SYSTEM CLASS",null,"ROADWAY TYPE",null,null,"Work Location",null,null,"Travel Lane Width (ft)",null,"Climbing Grade (%)*",null,"Speed Limit","Binary","Construction Seasons"]
["Northwest",null,"Adair County","Adair","I-29 (MO).svgI-29",null,"I-29",null,"29","24","1","29",null,"INTERSTATE",null,"FREEWAY",null,"No Work Zone (Use for Calibrating Existing Conditions)","Barrier located greater than 2 feet from travel lane",9,null,"<10 ",3,"< 2",0,30,"Yes","more than one"]
["Northeast",null,"Andrew County","Andrew","I-35 (MO).svgI-35",null,"I-35",null,"35","36","2","35",null,"PRIMARY",null,"EXPRESSWAY",null,"Workers & equipment less than 4 feet from travel lane","Barrier located less than 2 feet from travel lane",6,null,"> 11.5",1,">2-3",1,35,"No","one or somewhat less than one"]
["Kansas City",null,"Atchison County","Atchison","I-44 (MO).svgI-44",null,"I-44",null,"44","40","3","44",null,"SUPPLEMENTARY",null,"MULTI-LANE",null,"Workers & equipment greater than 4-feet from travel lane","Crossover on Divided Highway",15,null,"10 - 11.5",2,">3-4",4,40,"N/A","much less than one"]
["Central",null,"Audrain County","Audrain","I-49 (MO).svgI-49",null,"I-49",null,"49","50","5","49",null,"NOT ON SYSTEM",null,"5 LANE SECTION",null,"Barrier located less than 2 feet from travel lane","No Work Zone (Use for Calibrating Existing Conditions)",538,null,null,null,">4-5",7,45]
["Saint Louis",null,"Barry County","Barry","I-55 (MO).svgI-55",null,"I-55",null,"55","54","6","55",null,"UNKNOWN",null,"3 LANE SECTION",null,"Barrier located greater than 2 feet from travel lane","Ramp (used as bypass)",12,null,null,null,">5-6",10,50]
["Southwest",null,"Barton County","Barton","I-57 (MO).svgI-57",null,"I-57",null,"57","56","7","57",null,"N/A",null,"SUPER 2-LANE",null,"Ramp (used as bypass)","Workers & equipment greater than 4-feet from travel lane",3,null,null,null,">6",13,55]
["Southeast",null,"Bates County","Bates","I-64 (MO).svgI-64",null,"I-64",null,"64","60","8","64",null,null,null,"TWO-LANE",null,"Crossover on Divided Highway","Workers & equipment less than 4 feet from travel lane",0,null,null,null,null,null,60]
["UNKNOWN",null,"Benton County","Benton","I-70 (MO).svgI-70",null,"I-70",null,"70","62","9","70",null,null,null,"ONE-WAY",null,null,null,null,null,null,null,null,null,65]
["N/A",null,"Bollinger County","Bollinger","I-72 (MO).svgI-72",null,"I-72",null,"72","66","10","72",null,null,null,"SHARED FOUR LANE",null,null,null,null,null,null,null,null,null,70]
[null,null,"Boone County","Boone","I-155 (MO).svgI-155",null,"I-155",null,"155","136","11","155",null,null,null,"RAMP",null,null,null,null,null,null,null,null,null,75]
[null,null,"Buchanan County","Buchanan","I-170 (MO).svgI-170",null,"I-170",null,"170","160","12","170",null,null,null,"UNKNOWN"]
[null,null,"Butler County","Butler","I-229 (MO).svgI-229",null,"I-229",null,"229","166","13","229",null,null,null,"N/A"]
[null,null,"Caldwell County","Caldwell","I-255 (MO).svgI-255",null,"I-255",null,"255","400","14","255"]
[null,null,"Callaway County","Callaway","I-270 (MO).svgI-270",null,"I-270",null,"270","412","15","270"]
[null,null,"Camden County","Camden","I-435 (MO).svgI-435",null,"I-435",null,"435","460","16","435"]
[null,null,"Cape Girardeau County","Cape Girardeau","I-470 (MO).svgI-470",null,"I-470",null,"470","59","17","470"]
[null,null,"Carroll County","Carroll","I-635 (MO).svgI-635",null,"I-635",null,"635","61","18","635"]
[null,null,"Carter County","Carter","I-670 (MO).svgI-670",null,"I-670",null,"670","63","19","670"]
[null,null,"Cass County","Cass","US 24.svgUS 24",null,"US 24",null,null,"65","20","24"]
[null,null,"Cedar County","Cedar","US 36.svgUS 36",null,"US 36",null,null,"67","21","36"]
[null,null,"Chariton County","Chariton","US 40.svgUS 40",null,"US 40",null,null,"69","22","40"]
[null,null,"Christian County","Christian","US 50.svgUS 50",null,"US 50",null,null,"71","23","50"]
[null,null,"Clark County","Clark","US 54.svgUS 54",null,"US 54",null,null,"159","25","54"]
[null,null,"Clay County","Clay","US 56.svgUS 56",null,"US 56",null,null,"169","27","56"]
[null,null,"Clinton County","Clinton","US 60.svgUS 60",null,"US 60",null,null,"275","28","60"]
[null,null,"Cole County","Cole","US 62.svgUS 62",null,"US 62",null,null,null,"30","62"]
[null,null,"Cooper County","Cooper","US 66.svgUS 66",null,"US 66",null,null,null,"31","66"]
[null,null,"Crawford County","Crawford","US 136.svgUS 136",null,"US 136",null,null,null,"32","136"]
[null,null,"Dade County","Dade","US 160.svgUS 160",null,"US 160",null,null,null,"33","160"]
[null,null,"Dallas County","Dallas","US 166.svgUS 166",null,"US 166",null,null,null,"34","166"]
[null,null,"Daviess County","Daviess","US 400.svgUS 400",null,"US 400",null,null,null,"37","400"]
[null,null,"DeKalb County","DeKalb","US 412.svgUS 412",null,"US 412",null,null,null,"38","412"]
[null,null,"Dent County","Dent","US 460.svgUS 460",null,"US 460",null,null,null,"39","460"]
[null,null,"Douglas County","Douglas","US 59.svgUS 59",null,"US 59",null,null,null,"41","59"]
[null,null,"Dunklin County","Dunklin","US 61.svgUS 61",null,"US 61",null,null,null,"42","61"]
[null,null,"Franklin County","Franklin","US 63.svgUS 63",null,"US 63",null,null,null,"43","63"]
[null,null,"Gasconade County","Gasconade","US 65.svgUS 65",null,"US 65",null,null,null,"45","65"]
[null,null,"Gentry County","Gentry","US 67.svgUS 67",null,"US 67",null,null,null,"46","67"]
[null,null,"Greene County","Greene","US 69.svgUS 69",null,"US 69",null,null,null,"47","69"]
[null,null,"Grundy County","Grundy","US 71.svgUS 71",null,"US 71",null,null,null,"48","71"]
[null,null,"Harrison County","Harrison","US 159.svgUS 159",null,"US 159",null,null,null,"49","159"]
[null,null,"Henry County","Henry","US 169.svgUS 169",null,"US 169",null,null,null,"51","169"]
[null,null,"Hickory County","Hickory","US 275.svgUS 275",null,"US 275",null,null,null,"52","275"]
[null,null,"Holt County","Holt",1,"MO ","MO 1",null,null,null,"53","1"]
[null,null,"Howard County","Howard",2,"MO ","MO 2",null,null,null,"58","2"]
[null,null,"Howell County","Howell",3,"MO ","MO 3",null,null,null,"59","3"]
[null,null,"Iron County","Iron",5,"MO ","MO 5",null,null,null,"64","5"]
[null,null,"Jackson County","Jackson",6,"MO ","MO 6",null,null,null,"66","6"]
[null,null,"Jasper County","Jasper",7,"MO ","MO 7",null,null,null,"68","7"]
[null,null,"Jefferson County","Jefferson",8,"MO ","MO 8",null,null,null,"72","8"]
[null,null,"Johnson County","Johnson",9,"MO ","MO 9",null,null,null,"73","9"]
[null,null,"Knox County","Knox",10,"MO ","MO 10",null,null,null,"74","10"]
[null,null,"Laclede County","Laclede",11,"MO ","MO 11",null,null,null,"75","11"]
[null,null,"Lafayette County","Lafayette",12,"MO ","MO 12",null,null,null,"76","12"]
[null,null,"Lawrence County","Lawrence",13,"MO ","MO 13",null,null,null,"77","13"]
[null,null,"Lewis County","Lewis",14,"MO ","MO 14",null,null,null,"78","14"]
[null,null,"Lincoln County","Lincoln",15,"MO ","MO 15",null,null,null,"79","15"]
[null,null,"Linn County","Linn",16,"MO ","MO 16",null,null,null,"80","16"]
[null,null,"Livingston County","Livingston",17,"MO ","MO 17",null,null,null,"81","17"]
[null,null,"Macon County","Macon",18,"MO ","MO 18",null,null,null,"82","18"]
[null,null,"Madison County","Madison",19,"MO ","MO 19",null,null,null,"83","19"]
[null,null,"Maries County","Maries",20,"MO ","MO 20",null,null,null,"84","20"]
[null,null,"Marion County","Marion",21,"MO ","MO 21",null,null,null,"85","21"]
[null,null,"McDonald County","McDonald",22,"MO ","MO 22",null,null,null,"86","22"]
[null,null,"Mercer County","Mercer",23,"MO ","MO 23",null,null,null,"87","23"]
[null,null,"Miller County","Miller",25,"MO ","MO 25",null,null,null,"89","25"]
[null,null,"Mississippi County","Mississippi",27,"MO ","MO 27",null,null,null,"90","27"]
[null,null,"Moniteau County","Moniteau",28,"MO ","MO 28",null,null,null,"91","28"]
[null,null,"Monroe County","Monroe",30,"MO ","MO 30",null,null,null,"92","30"]
[null,null,"Montgomery County","Montgomery",31,"MO ","MO 31",null,null,null,"94","31"]
[null,null,"Morgan County","Morgan",32,"MO ","MO 32",null,null,null,"95","32"]
[null,null,"New Madrid County","New Madrid",33,"MO ","MO 33",null,null,null,"96","33"]
[null,null,"Newton County","Newton",34,"MO ","MO 34",null,null,null,"97","34"]
[null,null,"Nodaway County","Nodaway",37,"MO ","MO 37",null,null,null,"98","37"]
[null,null,"Oregon County","Oregon",38,"MO ","MO 38",null,null,null,"99","38"]
[null,null,"Osage County","Osage",39,"MO ","MO 39",null,null,null,"100","39"]
[null,null,"Ozark County","Ozark",41,"MO ","MO 41",null,null,null,"101","41"]
[null,null,"Pemiscot County","Pemiscot",42,"MO ","MO 42",null,null,null,"102","42"]
[null,null,"Perry County","Perry",43,"MO ","MO 43",null,null,null,"103","43"]
[null,null,"Pettis County","Pettis",45,"MO ","MO 45",null,null,null,"104","45"]
[null,null,"Phelps County","Phelps",46,"MO ","MO 46",null,null,null,"105","46"]
[null,null,"Pike County","Pike",47,"MO ","MO 47",null,null,null,"106","47"]
[null,null,"Platte County","Platte",48,"MO ","MO 48",null,null,null,"107","48"]
[null,null,"Polk County","Polk",49,"MO ","MO 49",null,null,null,"108","49"]
[null,null,"Pulaski County","Pulaski",51,"MO ","MO 51",null,null,null,"109","51"]
[null,null,"Putnam County","Putnam",52,"MO ","MO 52",null,null,null,"110","52"]
[null,null,"Ralls County","Ralls",53,"MO ","MO 53",null,null,null,"111","53"]
[null,null,"Randolph County","Randolph",58,"MO ","MO 58",null,null,null,"112","58"]
[null,null,"Ray County","Ray",59,"MO ","MO 59",null,null,null,"113","59"]
[null,null,"Reynolds County","Reynolds",64,"MO ","MO 64",null,null,null,"114","64"]
[null,null,"Ripley County","Ripley",66,"MO ","MO 66",null,null,null,"115","66"]
[null,null,"Saint Charles County","Saint Charles",68,"MO ","MO 68",null,null,null,"116","68"]
[null,null,"Saint Clair County","Saint Clair",72,"MO ","MO 72",null,null,null,"117","72"]
[null,null,"Saint Francois County","Saint Francois",73,"MO ","MO 73",null,null,null,"118","73"]
[null,null,"Saint Louis County","Saint Louis",74,"MO ","MO 74",null,null,null,"119","74"]
[null,null,"Saint Louis City","Saint Louis City",75,"MO ","MO 75",null,null,null,"120","75"]
[null,null,"Ste. Genevieve County","Ste. Genevieve",76,"MO ","MO 76",null,null,null,"121","76"]
[null,null,"Saline County","Saline",77,"MO ","MO 77",null,null,null,"122","77"]
[null,null,"Schuyler County","Schuyler",78,"MO ","MO 78",null,null,null,"123","78"]
[null,null,"Scotland County","Scotland",79,"MO ","MO 79",null,null,null,"124","79"]
[null,null,"Scott County","Scott",80,"MO ","MO 80",null,null,null,"125","80"]
[null,null,"Shannon County","Shannon",81,"MO ","MO 81",null,null,null,"126","81"]
[null,null,"Shelby County","Shelby",82,"MO ","MO 82",null,null,null,"127","82"]
[null,null,"Stoddard County","Stoddard",83,"MO ","MO 83",null,null,null,"128","83"]
[null,null,"Stone County","Stone",84,"MO ","MO 84",null,null,null,"129","84"]
[null,null,"Sullivan County","Sullivan",85,"MO ","MO 85",null,null,null,"130","85"]
[null,null,"Taney County","Taney",86,"MO ","MO 86",null,null,null,"131","86"]
[null,null,"Texas County","Texas",87,"MO ","MO 87",null,null,null,"133","87"]
[null,null,"Vernon County","Vernon",89,"MO ","MO 89",null,null,null,"134","89"]
[null,null,"Warren County","Warren",90,"MO ","MO 90",null,null,null,"135","90"]
[null,null,"Washington County","Washington",91,"MO ","MO 91",null,null,null,"137","91"]
[null,null,"Wayne County","Wayne",92,"MO ","MO 92",null,null,null,"138","92"]
[null,null,"Webster County","Webster",94,"MO ","MO 94",null,null,null,"139","94"]
[null,null,"Worth County","Worth",95,"MO ","MO 95",null,null,null,"141","95"]
[null,null,"Wright County","Wright",96,"MO ","MO 96",null,null,null,"142","96"]
[null,null,null,"UNKNOWN",97,"MO ","MO 97",null,null,null,"143","97"]
[null,null,null,"N/A",98,"MO ","MO 98",null,null,null,"144","98"]
[null,null,null,null,99,"MO ","MO 99",null,null,null,"145","99"]
[null,null,null,null,100,"MO ","MO 100",null,null,null,"146","100"]
[null,null,null,null,101,"MO ","MO 101",null,null,null,"147","101"]
[null,null,null,null,102,"MO ","MO 102",null,null,null,"148","102"]
[null,null,null,null,103,"MO ","MO 103",null,null,null,"149","103"]
[null,null,null,null,104,"MO ","MO 104",null,null,null,"150","104"]
[null,null,null,null,105,"MO ","MO 105",null,null,null,"151","105"]
[null,null,null,null,106,"MO ","MO 106",null,null,null,"152","106"]
[null,null,null,null,107,"MO ","MO 107",null,null,null,"153","107"]
[null,null,null,null,108,"MO ","MO 108",null,null,null,"154","108"]
[null,null,null,null,109,"MO ","MO 109",null,null,null,"156","109"]
[null,null,null,null,110,"MO ","MO 110",null,null,null,"157","110"]
[null,null,null,null,111,"MO ","MO 111",null,null,null,"158","111"]
[null,null,null,null,112,"MO ","MO 112",null,null,null,"161","112"]
[null,null,null,null,113,"MO ","MO 113",null,null,null,"162","113"]
[null,null,null,null,114,"MO ","MO 114",null,null,null,"163","114"]
[null,null,null,null,115,"MO ","MO 115",null,null,null,"164","115"]
[null,null,null,null,116,"MO ","MO 116",null,null,null,"165","116"]
[null,null,null,null,117,"MO ","MO 117",null,null,null,"168","117"]
[null,null,null,null,118,"MO ","MO 118",null,null,null,"171","118"]
[null,null,null,null,119,"MO ","MO 119",null,null,null,"172","119"]
[null,null,null,null,120,"MO ","MO 120",null,null,null,"173","120"]
[null,null,null,null,121,"MO ","MO 121",null,null,null,"174","121"]
[null,null,null,null,122,"MO ","MO 122",null,null,null,"175","122"]
[null,null,null,null,123,"MO ","MO 123",null,null,null,"176","123"]
[null,null,null,null,124,"MO ","MO 124",null,null,null,"177","124"]
[null,null,null,null,125,"MO ","MO 125",null,null,null,"179","125"]
[null,null,null,null,126,"MO ","MO 126",null,null,null,"180","126"]
[null,null,null,null,127,"MO ","MO 127",null,null,null,"181","127"]
[null,null,null,null,128,"MO ","MO 128",null,null,null,"185","128"]
[null,null,null,null,129,"MO ","MO 129",null,null,null,"187","129"]
[null,null,null,null,130,"MO ","MO 130",null,null,null,"190","130"]
[null,null,null,null,131,"MO ","MO 131",null,null,null,"202","131"]
[null,null,null,null,133,"MO ","MO 133",null,null,null,"210","133"]
[null,null,null,null,134,"MO ","MO 134",null,null,null,"213","134"]
[null,null,null,null,135,"MO ","MO 135",null,null,null,"215","135"]
[null,null,null,null,137,"MO ","MO 137",null,null,null,"221","137"]
[null,null,null,null,138,"MO ","MO 138",null,null,null,"224","138"]
[null,null,null,null,139,"MO ","MO 139",null,null,null,"231","139"]
[null,null,null,null,141,"MO ","MO 141",null,null,null,"240","141"]
[null,null,null,null,142,"MO ","MO 142",null,null,null,"242","142"]
[null,null,null,null,143,"MO ","MO 143",null,null,null,"245","143"]
[null,null,null,null,144,"MO ","MO 144",null,null,null,"246","144"]
[null,null,null,null,145,"MO ","MO 145",null,null,null,"248","145"]
[null,null,null,null,146,"MO ","MO 146",null,null,null,"249","146"]
[null,null,null,null,147,"MO ","MO 147",null,null,null,"254","147"]
[null,null,null,null,148,"MO ","MO 148",null,null,null,"265","148"]
[null,null,null,null,149,"MO ","MO 149",null,null,null,"266","149"]
[null,null,null,null,150,"MO ","MO 150",null,null,null,"267","150"]
[null,null,null,null,151,"MO ","MO 151",null,null,null,"269","151"]
[null,null,null,null,152,"MO ","MO 152",null,null,null,"273","152"]
[null,null,null,null,153,"MO ","MO 153",null,null,null,"283","153"]
[null,null,null,null,154,"MO ","MO 154",null,null,null,"291","154"]
[null,null,null,null,156,"MO ","MO 156",null,null,null,"340","156"]
[null,null,null,null,157,"MO ","MO 157",null,null,null,"350","157"]
[null,null,null,null,158,"MO ","MO 158",null,null,null,"360","158"]
[null,null,null,null,161,"MO ","MO 161",null,null,null,"364","161"]
[null,null,null,null,162,"MO ","MO 162",null,null,null,"366","162"]
[null,null,null,null,163,"MO ","MO 163",null,null,null,"367","163"]
[null,null,null,null,164,"MO ","MO 164",null,null,null,"370","164"]
[null,null,null,null,165,"MO ","MO 165",null,null,null,"371","165"]
[null,null,null,null,168,"MO ","MO 168",null,null,null,"376","168"]
[null,null,null,null,171,"MO ","MO 171",null,null,null,"413","171"]
[null,null,null,null,172,"MO ","MO 172",null,null,null,"465","172"]
[null,null,null,null,173,"MO ","MO 173",null,null,null,"571","173"]
[null,null,null,null,174,"MO ","MO 174",null,null,null,"740","174"]
[null,null,null,null,175,"MO ","MO 175",null,null,null,"744","175"]
[null,null,null,null,176,"MO ","MO 176",null,null,null,"752","176"]
[null,null,null,null,177,"MO ","MO 177",null,null,null,"759","177"]
[null,null,null,null,179,"MO ","MO 179",null,null,null,"763","179"]
[null,null,null,null,180,"MO ","MO 180",null,null,null,"765","180"]
[null,null,null,null,181,"MO ","MO 181",null,null,null,"799","181"]
[null,null,null,null,185,"MO ","MO 185",null,null,null,null,"185"]
[null,null,null,null,187,"MO ","MO 187",null,null,null,null,"187"]
[null,null,null,null,190,"MO ","MO 190",null,null,null,null,"190"]
[null,null,null,null,202,"MO ","MO 202",null,null,null,null,"202"]
[null,null,null,null,210,"MO ","MO 210",null,null,null,null,"210"]
[null,null,null,null,213,"MO ","MO 213",null,null,null,null,"213"]
[null,null,null,null,215,"MO ","MO 215",null,null,null,null,"215"]
[null,null,null,null,221,"MO ","MO 221",null,null,null,null,"221"]
[null,null,null,null,224,"MO ","MO 224",null,null,null,null,"224"]
[null,null,null,null,231,"MO ","MO 231",null,null,null,null,"231"]
[null,null,null,null,240,"MO ","MO 240",null,null,null,null,"240"]
[null,null,null,null,242,"MO ","MO 242",null,null,null,null,"242"]
[null,null,null,null,245,"MO ","MO 245",null,null,null,null,"245"]
[null,null,null,null,246,"MO ","MO 246",null,null,null,null,"246"]
[null,null,null,null,248,"MO ","MO 248",null,null,null,null,"248"]
[null,null,null,null,249,"MO ","MO 249",null,null,null,null,"249"]
[null,null,null,null,254,"MO ","MO 254",null,null,null,null,"254"]
[null,null,null,null,265,"MO ","MO 265",null,null,null,null,"265"]
[null,null,null,null,266,"MO ","MO 266",null,null,null,null,"266"]
[null,null,null,null,267,"MO ","MO 267",null,null,null,null,"267"]
[null,null,null,null,269,"MO ","MO 269",null,null,null,null,"269"]
[null,null,null,null,273,"MO ","MO 273",null,null,null,null,"273"]
[null,null,null,null,283,"MO ","MO 283",null,null,null,null,"283"]
[null,null,null,null,291,"MO ","MO 291",null,null,null,null,"291"]
[null,null,null,null,340,"MO ","MO 340",null,null,null,null,"340"]
[null,null,null,null,350,"MO ","MO 350",null,null,null,null,"350"]
[null,null,null,null,360,"MO ","MO 360",null,null,null,null,"360"]
[null,null,null,null,364,"MO ","MO 364",null,null,null,null,"364"]
[null,null,null,null,366,"MO ","MO 366",null,null,null,null,"366"]
[null,null,null,null,367,"MO ","MO 367",null,null,null,null,"367"]
[null,null,null,null,370,"MO ","MO 370",null,null,null,null,"370"]
[null,null,null,null,371,"MO ","MO 371",null,null,null,null,"371"]
[null,null,null,null,376,"MO ","MO 376",null,null,null,null,"376"]
[null,null,null,null,413,"MO ","MO 413",null,null,null,null,"413"]
[null,null,null,null,465,"MO ","MO 465",null,null,null,null,"465"]
[null,null,null,null,571,"MO ","MO 571",null,null,null,null,"571"]
[null,null,null,null,740,"MO ","MO 740",null,null,null,null,"740"]
[null,null,null,null,744,"MO ","MO 744",null,null,null,null,"744"]
[null,null,null,null,752,"MO ","MO 752",null,null,null,null,"752"]
[null,null,null,null,759,"MO ","MO 759",null,null,null,null,"759"]
[null,null,null,null,763,"MO ","MO 763",null,null,null,null,"763"]
[null,null,null,null,765,"MO ","MO 765",null,null,null,null,"765"]
[null,null,null,null,799,"MO ","MO 799",null,null,null,null,"799"]
[null,null,null,null,null,null,"UNKNOWN"]
[null,null,null,null,null,null,"N/A"]

{"sheet":"HCM 2010 Program","index":4,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":true,"merged":[[31,3,31,14],[32,3,32,14],[2,0,4,0],[5,0,7,0],[14,0,16,0],[17,0,19,0],[31,0,33,0],[31,1,33,1],[11,0,13,0],[8,0,10,0],[36,0,38,0],[39,0,41,0],[42,0,44,0],[45,0,47,0],[48,0,50,0]]}
["Highway Capacity Manual 2010 Program for the MoDOT's Work Zone Impact Analysis Spreadsheet"]
["Work Location","Travel Lane Width (ft)",null,"Capacity of Work Zone Before Trucks (pc/h/ln)","Percent of Trucks*","ET - Equivalent Truck*","Lane Width Factor      (fLW)","Capacity (w/Trucks) veh/lane/hr"]
["Workers & equipment less than 4 feet from travel lane","> 11.5",1,1440,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,{"$f":"+(D3*(1/(1+(E3*(F3-1)))))*G3","v":1404.8780487804879}]
[null,"10 - 11.5",2,1440,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,{"$f":"+(D4*(1/(1+(E4*(F4-1)))))*G4","v":1278.439024390244}]
[null,"<10 ",3,1440,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1208.1951219512196]
["Workers & equipment greater than 4-feet from travel lane","> 11.5",4,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,1560.9756097560978]
[null,"10 - 11.5",5,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,1420.487804878049]
[null,"<10 ",6,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1342.4390243902442]
["Barrier located less than 2 feet from          travel lane","> 11.5",7,1500,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,1463.4146341463415]
[null,"10 - 11.5",8,1500,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,1331.7073170731708]
[null,"<10 ",9,1500,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1258.5365853658536]
["Barrier located greater than 2 feet from travel lane","> 11.5",10,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,1560.9756097560978]
[null,"10 - 11.5",11,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,1420.487804878049]
[null,"<10 ",12,1600,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1342.4390243902442]
["Ramp                               (used as bypass)","> 11.5",13,1680,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,1639.0243902439026]
[null,"10 - 11.5",14,1680,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,1491.5121951219514]
[null,"<10 ",15,1680,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1409.5609756097563]
["Crossover on              Divided Highway","> 11.5",16,1760,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},1,1717.0731707317075]
[null,"10 - 11.5",17,1760,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.91,1562.5365853658539]
[null,"<10 ",18,1760,{"$f":"'Step 2 - Facility Data Inputs'!$E$15","v":0.05},{"$f":"VLOOKUP(('Step 2 - Facility Data Inputs'!$G$16+'Step 2 - Facility Data Inputs'!$I$16),$C$36:$O$51,'Step 2 - Facility Data Inputs'!$E$16)","v":1.5},0.86,1476.6829268292684]
["* Percent of Trucks and ET - Equivalent Truck located in the below chart."]
[]
[]
["Capacity of Work Before Trucks = 1600 + I  (pc/h/ln)"]
["Intensity of Work = I;  I is the adjustment factor for type, intensity and proximity of work activity"]
[null,"I ranges between + or - 160 pc/h/ln based on professional judgement and local experience"]
["ET = passenger-car equivalent for truck (based on percent of trucks and climbing grade)"]
["Lane Width Facter (fLW) = Restricted lane widths will negatively affect capacity."]
[]
[]
["Passenger - Car Equivalents for Trucks on Upgrades"]
["Climbing Grade        (%)*","Length (mi)",null,"ET - Passenger - Car Equivalents for Trucks on Upgrades "]
[null,null,null,"Percentage of Trucks"]
[null,null,null,0.02,0.04,0.05,0.06,0.08,0.1,0.15,0.2,0.25,0.3,0.35,0.4]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
["< 2",null,1,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[">2-3","0 - 0.49",2,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[null,"0.50 - 1.00",3,2,2,2,2,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[null,">1.00",4,3,3,2.5,2.5,2,2,2,2,2,2,2,2]
[">3-4","0 - 0.49",5,2,2,2,2,2,2,1.5,1.5,1.5,1.5,1.5,1.5]
[null,"0.50 - 1.00",6,3,3,2.5,2.5,2.5,2.5,2,2,2,2,2,2]
[null,">1.00",7,4,3.5,3,3,3,3,2.5,2.5,2.5,2.5,2.5,2.5]
[">4-5","0 - 0.49",8,3,2.5,2.5,2.5,2,2,2,2,2,2,2,2]
[null,"0.50 - 1.00",9,4,3.5,3.5,3.5,3,3,3,3,3,3,3,3]
[null,">1.00",10,5,4,4,4,3.5,3.5,3,3,3,3,3,3]
[">5-6","0 - 0.49",11,4.5,4,3.5,3,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5]
[null,"0.50 - 1.00",12,5.5,5,4.5,4,3,3,3,3,3,3,3,3]
[null,">1.00",13,6,5,5,4.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5]
[">6","0 - 0.49",14,5,4.5,4,4,3.5,3,2.5,2.5,2.5,2.5,2.5,2.5]
[null,"0.50 - 1.00",15,6,5.5,5,5,4.5,4,3.5,3.5,3.5,3.5,3.5,3.5]
[null,">1.00",16,7,6,5.5,5.5,5,4.5,4,4,4,4,4,4]
["*Climbing Grade can be located anywhere throughout the entire work zone project."]

{"sheet":"WZ Analysis (Worksheet)","index":5,"n_rows":221,"n_cols":33,"rows_kept":221,"cut":false,"hidden":true,"merged":[[193,0,213,0],[198,3,198,5],[199,3,199,5],[200,3,200,5],[201,3,201,5],[204,3,204,5],[205,3,205,5],[206,3,206,5],[164,0,184,0],[169,3,169,5],[170,3,170,5],[171,3,171,5],[172,3,172,5],[175,3,175,5],[176,3,176,5],[177,3,177,5],[135,0,155,0],[140,3,140,5],[141,3,141,5],[142,3,142,5],[143,3,143,5],[146,3,146,5],[147,3,147,5],[148,3,148,5],[106,0,126,0],[111,3,111,5],[112,3,112,5],[113,3,113,5],[114,3,114,5],[117,3,117,5],[118,3,118,5],[119,3,119,5],[77,0,97,0],[82,3,82,5],[83,3,83,5],[84,3,84,5],[85,3,85,5],[88,3,88,5],[89,3,89,5],[90,3,90,5],[48,0,68,0],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[32,3,32,5],[24,3,24,5],[19,0,39,0],[25,3,25,5],[26,3,26,5],[27,3,27,5],[30,3,30,5],[31,3,31,5]]}
[null,null,null,null,null,null,null,"WORKSHEET"]
[]
[null,null,null,null,null,null,null,"WORKZONE DETAILS"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"TOTAL NUMBER OF LANES",{"$f":"'Step 2 - Facility Data Inputs'!A15","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developed by University of Missouri - Columbia"]
[null,null,null,null,null,null,null,"TRUCK PERCENTAGE",{"$f":"IF('Step 2 - Facility Data Inputs'!E15='HCM 2010 Program'!D34,0.02,IF('Step 2 - Facility Data Inputs'!E15='HCM 2010 Program'!O34,0.4,'Step 2 - Facility Data Inputs'!E15))","v":0.05}]
[null,null,null,null,null,null,null,"VEH. LEN.",{"$f":"(25*(1-I11))+(50*I11)","v":26.25}]
[null,null,null,null,null,null,null,"TOTAL CAPACITY OF WORKZONE  "]
[]
[null,null,null,null,null,null,null,"User Defined Work Zone Capacitry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time","04:00:00"]
[null,null,null,null,null,null,null,"USER COST","TRUCKS ",{"$f":"'Step 2 - Facility Data Inputs'!K18","v":34.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time",{"$f":"'WZ Analysis (Worksheet)'!G31","v":0}]
[null,null,null,null,null,null,null,null,"CARS",{"$f":"'Step 2 - Facility Data Inputs'!K19","v":13.65},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duration of closure (hrs)",{"$f":"'Step 3 - WZ Analysis'!D18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(H22:H45)","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG16+AG17-AG18","v":-24}]
[{"$f":"'Step 2 - Facility Data Inputs'!E22","v":"Sunday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!E22","v":"Sunday"},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D7","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D22*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!E26+K21","v":0},{"$f":"$D$22*$I$10","v":4600},{"$f":"K22","v":0},{"$f":"MIN(K22,L22)","v":0},{"$f":"IF((K22-L22)<0,0,K22-L22)","v":0},{"$f":"O22*$I$12/(5280*$I$10)","v":0},{"$f":"60*O22/L22","v":0},{"$f":"(Q22*$I$11*($J$16/60))+(Q22*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$19-H23>=0,IF($G$30=\"\",$F$29,$G$30),IF(AND(H22>=$AG$16,H22<$AG$16+$AG$17),IF($G$30=\"\",$F$29,$G$30),$F$22))","v":4600},{"$f":"K22","v":0},{"$f":"MIN(K22,S22)","v":0},{"$f":"IF((K22-S22)<0,0,K22-S22)","v":0},{"$f":"V22*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S22=0,60*V22,60*V22/S22)","v":0},{"$f":"(X22*$I$11*($J$16/60))+(X22*(1-$I$11)*($J$17/60))","v":0},{"$f":"V22-O22","v":0},{"$f":"W22-P22","v":0},{"$f":"X22-Q22","v":0},{"$f":"IF((X22-Q22)=0,IF(OR(AB45<>0,AB23<>0),0,NA()),X22)","v":{"$error":"#N/A"}},{"$f":"Y22-R22","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!E27","v":0},4600,{"$f":"M22+K23","v":0},{"$f":"IF((K23<M23),IF((L23-K23)>O22,O22+K23+N22,L23+N22),(L23+N22))","v":4600},{"$f":"IF((K23<L23),IF((L23-K23)>O22,0,O22-(L23-K23)),(O22+(K23-L23)))","v":0},0,{"$f":"60*O23/L23","v":0},{"$f":"(Q23*$I$11*($J$16/60))+(Q23*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$19-H24>=0,IF($G$30=\"\",$F$29,$G$30),IF(AND(H23>=$AG$16,H23<$AG$16+$AG$17),IF($G$30=\"\",$F$29,$G$30),$F$22))","v":4600},{"$f":"T22+K23","v":0},{"$f":"IF((K23<S23),IF((S23-K23)>V22,V22+K23+U22,S23+U22),(S23+U22))","v":0},{"$f":"IF((K23<S23),IF((S23-K23)>V22,0,V22-(S23-K23)),(V22+(K23-S23)))","v":0},{"$f":"V23*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S23=0,60*V23,60*V23/S23)","v":0},{"$f":"(X23*$I$11*($J$16/60))+(X23*(1-$I$11)*($J$17/60))","v":0},{"$f":"V23-O23","v":0},{"$f":"W23-P23","v":0},0,{"$f":"IF((X23-Q23)=0,IF(OR(AB22<>0,AB24<>0),0,NA()),X23)","v":{"$error":"#N/A"}},{"$f":"Y23-R23","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!E28","v":0},4600,{"$f":"M23+K24","v":0},{"$f":"IF((K24<M24),IF((L24-K24)>O23,O23+K24+N23,L24+N23),(L24+N23))","v":9200},{"$f":"IF((K24<L24),IF((L24-K24)>O23,0,O23-(L24-K24)),(O23+(K24-L24)))","v":0},0,0,{"$f":"(Q24*$I$11*($J$16/60))+(Q24*(1-$I$11)*($J$17/60))","v":0},4600,{"$f":"T23+K24","v":0},{"$f":"IF((K24<S24),IF((S24-K24)>V23,V23+K24+U23,S24+U23),(S24+U23))","v":0},{"$f":"IF((K24<S24),IF((S24-K24)>V23,0,V23-(S24-K24)),(V23+(K24-S24)))","v":0},0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D10:F10","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!E29","v":0},4600,0,13800,{"$f":"IF((K25<L25),IF((L25-K25)>O24,0,O24-(L25-K25)),(O24+(K25-L25)))","v":0},0,0,0,4600,0,{"$f":"IF((K25<S25),IF((S25-K25)>V24,V24+K25+U24,S25+U24),(S25+U24))","v":0},{"$f":"IF((K25<S25),IF((S25-K25)>V24,0,V24-(S25-K25)),(V24+(K25-S25)))","v":0},0,{"$f":"IF(S25=0,60*V25,60*V25/S25)","v":0},0,0,0,0,{"$error":"#N/A"},0,null,null,"Minutes"]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D11:F11","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D26,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!E30","v":0},4600,0,18400,{"$f":"IF((K26<L26),IF((L26-K26)>O25,0,O25-(L26-K26)),(O25+(K26-L26)))","v":0},0,0,0,4600,0,0,{"$f":"IF((K26<S26),IF((S26-K26)>V25,0,V25-(S26-K26)),(V25+(K26-S26)))","v":0},0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X22:X45)","v":0}]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D12:F12","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D27,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!E31","v":0},4600,{"$f":"M26+K27","v":0},23000,0,0,0,0,4600,0,0,{"$f":"IF((K27<S27),IF((S27-K27)>V26,0,V26-(S27-K27)),(V26+(K27-S27)))","v":0},0,{"$f":"IF(S27=0,60*V27,60*V27/S27)","v":0},0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D13","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!E32","v":0},4600,{"$f":"M27+K28","v":0},27600,0,0,0,0,4600,0,0,{"$f":"IF((K28<S28),IF((S28-K28)>V27,0,V27-(S28-K28)),(V27+(K28-S28)))","v":0},0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V22:V45)/T45)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G26=538,D22,IF(VLOOKUP((G26+G27),'HCM 2010 Program'!$C$3:$H$20,6)>(D22),D22,VLOOKUP((G26+G27),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"capacity all wz lanes",{"$f":"MIN((D29*D28),F22)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!E33","v":0},4600,{"$f":"M28+K29","v":0},32200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E15","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E15=\"\",\"\",'Step 3 - WZ Analysis'!E15)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!E34","v":0},4600,{"$f":"M29+K30","v":0},36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D16:F16","v":"00:00:00"},null,null,{"$f":"VLOOKUP('Step 3 - WZ Analysis'!D16,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!E35","v":0},4600,{"$f":"M30+K31","v":0},41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z46","v":0}]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D17:F17","v":"00:00:00"},null,null,{"$f":"VLOOKUP('Step 3 - WZ Analysis'!D17,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!E36","v":0},4600,0,46000,{"$f":"IF((K32<L32),IF((L32-K32)>O31,0,O31-(L32-K32)),(O31+(K32-L32)))","v":0},0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D18:F18","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!E37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W46","v":0}]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!E38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!E39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA22:AA45,0)","v":0}]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!E40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!D22","v":0},{"$f":"'Step 3 - WZ Analysis'!E22","v":0},{"$f":"'Step 3 - WZ Analysis'!F22","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!E41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!D23","v":0},{"$f":"'Step 3 - WZ Analysis'!E23","v":0},{"$f":"'Step 3 - WZ Analysis'!F23","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!E42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"'Step 3 - WZ Analysis'!D24","v":0},{"$f":"'Step 3 - WZ Analysis'!E24","v":0},{"$f":"'Step 3 - WZ Analysis'!F24","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!E43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!E44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!E45","v":0},4600,0,87400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!E46","v":0},4600,0,92000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!E47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!E48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!E49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$f":"IF((X45-Q45)=0,IF(OR(AB44<>0,AB22<>0),0,NA()),X45)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P22:P45)","v":0},{"$f":"MAX(Q22:Q45)","v":0},{"$f":"(SUM(R22:R45))","v":0},null,null,null,null,{"$f":"MAX(W22:W45)","v":0},{"$f":"MAX(X22:X45)","v":0},{"$f":"ROUND(SUM(Y22:Y45),0)","v":0},{"$f":"SUM(Z22:Z45)","v":0},{"$f":"MAX(AA22:AA45)","v":0},{"$f":"MAX(AB22:AB45)","v":0},null,{"$f":"ROUND(SUM(AD22:AD45),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R46<100,ROUND(R46,0),IF(R46<1000,ROUND(R46,-1),ROUND(R46,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD47+R47","v":0},null,null,null,null,{"$f":"IF(AD46<100,ROUND(AD46,0),IF(AD46<1000,ROUND(AD46,-1),ROUND(AD46,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!F22","v":"Monday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F22","v":"Monday"},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G60","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D29","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D51*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!F26+K50","v":0},{"$f":"$F$51","v":4600},{"$f":"K51","v":0},{"$f":"MIN(K51,L51)","v":0},{"$f":"IF((K51-L51)<0,0,K51-L51)","v":0},{"$f":"O51*$I$12/(5280*$I$10)","v":0},{"$f":"60*O51/L51","v":0},{"$f":"(Q51*$I$11*($J$16/60))+(Q51*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$54-H52>=0,IF($G$59=\"\",$F$58,$G$59),IF(AND(H51>=$AG$50,H51<$AG$50+$AG$51),IF($G$59=\"\",$F$58,$G$59),$F$51))","v":4600},{"$f":"K51","v":0},{"$f":"MIN(K51,S51)","v":0},{"$f":"IF((K51-S51)<0,0,K51-S51)","v":0},{"$f":"V51*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S51=0,60*V51,60*V51/S51)","v":0},{"$f":"(X51*$I$11*($J$16/60))+(X51*(1-$I$11)*($J$17/60))","v":0},{"$f":"V51-O51","v":0},{"$f":"W51-P51","v":0},{"$f":"X51-Q51","v":0},{"$f":"IF((X51-Q51)=0,IF(OR(AB74<>0,AB52<>0),0,NA()),X51)","v":{"$error":"#N/A"}},{"$f":"Y51-R51","v":0},null,"Duration of closure (hrs)",{"$f":"'Step 3 - WZ Analysis'!D40","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!F27","v":0},{"$f":"$F$51","v":4600},{"$f":"M51+K52","v":0},{"$f":"IF((K52<M52),IF((L52-K52)>O51,O51+K52+N51,L52+N51),(L52+N51))","v":4600},{"$f":"IF((K52<L52),IF((L52-K52)>O51,0,O51-(L52-K52)),(O51+(K52-L52)))","v":0},{"$f":"O52*$I$12/(5280*$I$10)","v":0},{"$f":"60*O52/L52","v":0},{"$f":"(Q52*$I$11*($J$16/60))+(Q52*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$54-H53>=0,IF($G$59=\"\",$F$58,$G$59),IF(AND(H52>=$AG$50,H52<$AG$50+$AG$51),IF($G$59=\"\",$F$58,$G$59),$F$51))","v":4600},{"$f":"T51+K52","v":0},{"$f":"IF((K52<S52),IF((S52-K52)>V51,V51+K52+U51,S52+U51),(S52+U51))","v":0},{"$f":"IF((K52<S52),IF((S52-K52)>V51,0,V51-(S52-K52)),(V51+(K52-S52)))","v":0},{"$f":"V52*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S52=0,60*V52,60*V52/S52)","v":0},{"$f":"(X52*$I$11*($J$16/60))+(X52*(1-$I$11)*($J$17/60))","v":0},{"$f":"V52-O52","v":0},{"$f":"W52-P52","v":0},{"$f":"X52-Q52","v":0},{"$f":"IF((X52-Q52)=0,IF(OR(AB51<>0,AB53<>0),0,NA()),X52)","v":{"$error":"#N/A"}},{"$f":"Y52-R52","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!F28","v":0},4600,{"$f":"M52+K53","v":0},{"$f":"IF((K53<M53),IF((L53-K53)>O52,O52+K53+N52,L53+N52),(L53+N52))","v":9200},{"$f":"IF((K53<L53),IF((L53-K53)>O52,0,O52-(L53-K53)),(O52+(K53-L53)))","v":0},0,0,0,4600,{"$f":"T52+K53","v":0},{"$f":"IF((K53<S53),IF((S53-K53)>V52,V52+K53+U52,S53+U52),(S53+U52))","v":0},{"$f":"IF((K53<S53),IF((S53-K53)>V52,0,V52-(S53-K53)),(V52+(K53-S53)))","v":0},{"$f":"V53*$I$12/(5280*$I$10)","v":0},0,0,0,0,0,{"$f":"IF((X53-Q53)=0,IF(OR(AB52<>0,AB54<>0),0,NA()),X53)","v":{"$error":"#N/A"}},{"$f":"Y53-R53","v":0},null,"count ",{"$f":"COUNT(H51:H74)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D32:F32","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!F29","v":0},4600,0,{"$f":"IF((K54<M54),IF((L54-K54)>O53,O53+K54+N53,L54+N53),(L54+N53))","v":13800},0,0,0,0,4600,0,0,0,0,{"$f":"IF(S54=0,60*V54,60*V54/S54)","v":0},0,0,0,0,{"$error":"#N/A"},0,null,"short",{"$f":"AG50+AG51-AG53","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D33:F33","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D55,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!F30","v":0},4600,0,18400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D34:F34","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D56,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!F31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D35:F35","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!F32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V57-O57","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X51:X74)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G55=538,D51,IF(VLOOKUP((G55+G56),'HCM 2010 Program'!$C$3:$H$20,6)>(D51),D51,VLOOKUP((G55+G56),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D58*D57),F51)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!F33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E37","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E37=\"\",\"\",'Step 3 - WZ Analysis'!E37)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!F34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V51:V74)/T74)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D38:F38","v":"00:00:00"},null,null,{"$f":"VLOOKUP('Step 3 - WZ Analysis'!D38,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!F35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D39:F39","v":"00:00:00"},null,null,{"$f":"VLOOKUP('Step 3 - WZ Analysis'!D39,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!F36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z75","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D40:F40","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!F37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!F38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W75","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!F39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!F40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA52:AA75,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!P91","v":0},{"$f":"'WZ Analysis (Worksheet)'!AA91","v":0},{"$f":"'WZ Analysis (Worksheet)'!W91","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!F41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!Q91","v":0},{"$f":"'WZ Analysis (Worksheet)'!AB91","v":0},{"$f":"'WZ Analysis (Worksheet)'!X91","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!F42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!R92","v":0},{"$f":"'WZ Analysis (Worksheet)'!AD92","v":0},{"$f":"'WZ Analysis (Worksheet)'!Y92","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!F43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!F44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!F45","v":0},4600,0,87400,0,0,0,{"$f":"(Q70*$I$11*($J$16/60))+(Q70*(1-$I$11)*($J$17/60))","v":0},4600,0,{"$f":"IF((K70<S70),IF((S70-K70)>V69,V69+K70+U69,S70+U69),(S70+U69))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!F46","v":0},4600,0,92000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!F47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!F48","v":0},4600,0,101200,0,0,0,{"$f":"(Q73*$I$11*($J$16/60))+(Q73*(1-$I$11)*($J$17/60))","v":0},4600,0,0,0,0,0,{"$f":"(X73*$I$11*($J$16/60))+(X73*(1-$I$11)*($J$17/60))","v":0},0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!F49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,{"$f":"((V74*X74)*$I$11*$J$16/(60))+((V74*X74)*(1-$I$11)*$J$17/(60))","v":0},0,0,0,{"$f":"IF((X74-Q74)=0,IF(OR(AB73<>0,AB51<>0),0,NA()),X74)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P51:P74)","v":0},{"$f":"MAX(Q51:Q74)","v":0},{"$f":"(SUM(R51:R74))","v":0},null,null,null,null,{"$f":"MAX(W51:W74)","v":0},{"$f":"MAX(X51:X74)","v":0},{"$f":"ROUND(SUM(Y51:Y74),0)","v":0},{"$f":"SUM(Z51:Z74)","v":0},{"$f":"MAX(AA51:AA74)","v":0},{"$f":"MAX(AB51:AB74)","v":0},null,{"$f":"ROUND(SUM(AD51:AD74),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R75<100,ROUND(R75,0),IF(R75<1000,ROUND(R75,-1),ROUND(R75,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD76+R76","v":0},null,null,null,null,{"$f":"IF(AD75<100,ROUND(AD75,0),IF(AD75<1000,ROUND(AD75,-1),ROUND(AD75,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!G22","v":"Tuesday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F52","v":0},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G89","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D51","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D80*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!G26+K79","v":0},{"$f":"$F$80","v":4600},{"$f":"K80","v":0},{"$f":"MIN(K80,L80)","v":0},{"$f":"IF((K80-L80)<0,0,K80-L80)","v":0},{"$f":"O80*$I$12/(5280*$I$10)","v":0},{"$f":"60*O80/L80","v":0},{"$f":"(Q80*$I$11*($J$16/60))+(Q80*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$83-H81>=0,IF($G$88=\"\",$F$87,$G$88),IF(AND(H80>=$AG$79,H80<$AG$79+$AG$80),IF($G$88=\"\",$F$87,$G$88),$F$80))","v":4600},{"$f":"K80","v":0},{"$f":"MIN(K80,S80)","v":0},{"$f":"IF((K80-S80)<0,0,K80-S80)","v":0},{"$f":"V80*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S80=0,60*V80,60*V80/S80)","v":0},{"$f":"(X80*$I$11*($J$16/60))+(X80*(1-$I$11)*($J$17/60))","v":0},{"$f":"V80-O80","v":0},{"$f":"W80-P80","v":0},{"$f":"X80-Q80","v":0},{"$f":"IF((X80-Q80)=0,IF(OR(AB103<>0,AB81<>0),0,NA()),X80)","v":{"$error":"#N/A"}},{"$f":"Y80-R80","v":0},null,"Duration of closure (hrs)",{"$f":"'Step 3 - WZ Analysis'!D62","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!G27","v":0},{"$f":"$F$80","v":4600},{"$f":"M80+K81","v":0},{"$f":"IF((K81<M81),IF((L81-K81)>O80,O80+K81+N80,L81+N80),(L81+N80))","v":4600},{"$f":"IF((K81<L81),IF((L81-K81)>O80,0,O80-(L81-K81)),(O80+(K81-L81)))","v":0},{"$f":"O81*$I$12/(5280*$I$10)","v":0},{"$f":"60*O81/L81","v":0},{"$f":"(Q81*$I$11*($J$16/60))+(Q81*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$83-H82>=0,IF($G$88=\"\",$F$87,$G$88),IF(AND(H81>=$AG$79,H81<$AG$79+$AG$80),IF($G$88=\"\",$F$87,$G$88),$F$80))","v":4600},{"$f":"T80+K81","v":0},{"$f":"IF((K81<S81),IF((S81-K81)>V80,V80+K81+U80,S81+U80),(S81+U80))","v":0},{"$f":"IF((K81<S81),IF((S81-K81)>V80,0,V80-(S81-K81)),(V80+(K81-S81)))","v":0},{"$f":"V81*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S81=0,60*V81,60*V81/S81)","v":0},{"$f":"(X81*$I$11*($J$16/60))+(X81*(1-$I$11)*($J$17/60))","v":0},{"$f":"V81-O81","v":0},{"$f":"W81-P81","v":0},{"$f":"X81-Q81","v":0},{"$f":"IF((X81-Q81)=0,IF(OR(AB80<>0,AB82<>0),0,NA()),X81)","v":{"$error":"#N/A"}},{"$f":"Y81-R81","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!G28","v":0},4600,{"$f":"M81+K82","v":0},{"$f":"IF((K82<M82),IF((L82-K82)>O81,O81+K82+N81,L82+N81),(L82+N81))","v":9200},{"$f":"IF((K82<L82),IF((L82-K82)>O81,0,O81-(L82-K82)),(O81+(K82-L82)))","v":0},0,0,0,4600,{"$f":"T81+K82","v":0},{"$f":"IF((K82<S82),IF((S82-K82)>V81,V81+K82+U81,S82+U81),(S82+U81))","v":0},{"$f":"IF((K82<S82),IF((S82-K82)>V81,0,V81-(S82-K82)),(V81+(K82-S82)))","v":0},0,0,0,0,0,0,{"$f":"IF((X82-Q82)=0,IF(OR(AB81<>0,AB83<>0),0,NA()),X82)","v":{"$error":"#N/A"}},{"$f":"Y82-R82","v":0},null,"count ",{"$f":"COUNT(H80:H103)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D54:F54","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!G29","v":0},4600,0,{"$f":"IF((K83<M83),IF((L83-K83)>O82,O82+K83+N82,L83+N82),(L83+N82))","v":13800},0,0,0,0,4600,0,0,0,0,{"$f":"IF(S83=0,60*V83,60*V83/S83)","v":0},0,0,0,0,{"$f":"IF((X83-Q83)=0,IF(OR(AB82<>0,AB84<>0),0,NA()),X83)","v":{"$error":"#N/A"}},{"$f":"Y83-R83","v":0},null,"short",{"$f":"AG79+AG80-AG82","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D55:F55","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D84,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!G30","v":0},4600,0,{"$f":"IF((K84<M84),IF((L84-K84)>O83,O83+K84+N83,L84+N83),(L84+N83))","v":18400},0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D56:F56","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D85,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!G31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D57:F57","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!G32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V86-O86","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X80:X103)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G84=538,D80,IF(VLOOKUP((G84+G85),'HCM 2010 Program'!$C$3:$H$20,6)>(D80),D80,VLOOKUP((G84+G85),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D87*D86),F80)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!G33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V87-O87","v":0},0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E59","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E59=\"\",\"\",'Step 3 - WZ Analysis'!E59)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!G34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V80:V103)/T103)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D60","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D89,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!G35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D61","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D90,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!G36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z104","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D62:F62","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!G37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!G38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W104","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!G39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!G40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA81:AA104,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"P104","v":0},{"$f":"AA104","v":0},{"$f":"W104","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!G41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"Q104","v":0},{"$f":"AB104","v":0},{"$f":"X104","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!G42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"R105","v":0},{"$f":"AD105","v":0},{"$f":"Y105","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!G43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!G44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!G45","v":0},4600,0,87400,0,0,0,0,4600,0,{"$f":"IF((K99<S99),IF((S99-K99)>V98,V98+K99+U98,S99+U98),(S99+U98))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!G46","v":0},4600,0,92000,0,0,0,0,4600,0,{"$f":"IF((K100<S100),IF((S100-K100)>V99,V99+K100+U99,S100+U99),(S100+U99))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!G47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!G48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!G49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$f":"IF((X103-Q103)=0,IF(OR(AB102<>0,AB80<>0),0,NA()),X103)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P80:P103)","v":0},{"$f":"MAX(Q80:Q103)","v":0},{"$f":"(SUM(R80:R103))","v":0},null,null,null,null,{"$f":"MAX(W80:W103)","v":0},{"$f":"MAX(X80:X103)","v":0},{"$f":"ROUND(SUM(Y80:Y103),0)","v":0},{"$f":"SUM(Z80:Z103)","v":0},{"$f":"MAX(AA80:AA103)","v":0},{"$f":"MAX(AB80:AB103)","v":0},null,{"$f":"ROUND(SUM(AD80:AD103),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R104<100,ROUND(R104,0),IF(R104<1000,ROUND(R104,-1),ROUND(R104,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD105+R105","v":0},null,null,null,null,{"$f":"IF(AD104<100,ROUND(AD104,0),IF(AD104<1000,ROUND(AD104,-1),ROUND(AD104,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!H22","v":"Wednesday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F81","v":0},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G118","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!$D$73","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D109*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!H26+K108","v":0},{"$f":"$F$109","v":4600},{"$f":"K109","v":0},{"$f":"MIN(K109,L109)","v":0},{"$f":"IF((K109-L109)<0,0,K109-L109)","v":0},{"$f":"O109*$I$12/(5280*$I$10)","v":0},{"$f":"60*O109/L109","v":0},{"$f":"(Q109*$I$11*($J$16/60))+(Q109*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$112-H110>=0,IF($G$117=\"\",$F$116,$G$117),IF(AND(H109>=$AG$108,H109<$AG$108+$AG$109),IF($G$117=\"\",$F$116,$G$117),$F$109))","v":4600},{"$f":"K109","v":0},{"$f":"MIN(K109,S109)","v":0},{"$f":"IF((K109-S109)<0,0,K109-S109)","v":0},{"$f":"V109*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S109=0,60*V109,60*V109/S109)","v":0},{"$f":"(X109*$I$11*($J$16/60))+(X109*(1-$I$11)*($J$17/60))","v":0},{"$f":"V109-O109","v":0},{"$f":"W109-P109","v":0},{"$f":"X109-Q109","v":0},{"$f":"IF((X109-Q109)=0,IF(OR(AB132<>0,AB110<>0),0,NA()),X109)","v":{"$error":"#N/A"}},{"$f":"Y109-R109","v":0},null,"Duration of closure (hrs)",{"$f":"D120","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!H27","v":0},{"$f":"$F$109","v":4600},{"$f":"M109+K110","v":0},{"$f":"IF((K110<M110),IF((L110-K110)>O109,O109+K110+N109,L110+N109),(L110+N109))","v":4600},{"$f":"IF((K110<L110),IF((L110-K110)>O109,0,O109-(L110-K110)),(O109+(K110-L110)))","v":0},{"$f":"O110*$I$12/(5280*$I$10)","v":0},{"$f":"60*O110/L110","v":0},{"$f":"(Q110*$I$11*($J$16/60))+(Q110*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$112-H111>=0,IF($G$117=\"\",$F$116,$G$117),IF(AND(H110>=$AG$108,H110<$AG$108+$AG$109),IF($G$117=\"\",$F$116,$G$117),$F$109))","v":4600},{"$f":"T109+K110","v":0},{"$f":"IF((K110<S110),IF((S110-K110)>V109,V109+K110+U109,S110+U109),(S110+U109))","v":0},{"$f":"IF((K110<S110),IF((S110-K110)>V109,0,V109-(S110-K110)),(V109+(K110-S110)))","v":0},{"$f":"V110*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S110=0,60*V110,60*V110/S110)","v":0},{"$f":"(X110*$I$11*($J$16/60))+(X110*(1-$I$11)*($J$17/60))","v":0},{"$f":"V110-O110","v":0},{"$f":"W110-P110","v":0},{"$f":"X110-Q110","v":0},{"$f":"IF((X110-Q110)=0,IF(OR(AB109<>0,AB111<>0),0,NA()),X110)","v":{"$error":"#N/A"}},{"$f":"Y110-R110","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!H28","v":0},4600,{"$f":"M110+K111","v":0},{"$f":"IF((K111<M111),IF((L111-K111)>O110,O110+K111+N110,L111+N110),(L111+N110))","v":9200},{"$f":"IF((K111<L111),IF((L111-K111)>O110,0,O110-(L111-K111)),(O110+(K111-L111)))","v":0},0,0,0,4600,{"$f":"T110+K111","v":0},{"$f":"IF((K111<S111),IF((S111-K111)>V110,V110+K111+U110,S111+U110),(S111+U110))","v":0},{"$f":"IF((K111<S111),IF((S111-K111)>V110,0,V110-(S111-K111)),(V110+(K111-S111)))","v":0},{"$f":"V111*$I$12/(5280*$I$10)","v":0},0,0,{"$f":"V111-O111","v":0},{"$f":"W111-P111","v":0},0,{"$f":"IF((X111-Q111)=0,IF(OR(AB110<>0,AB112<>0),0,NA()),X111)","v":{"$error":"#N/A"}},{"$f":"Y111-R111","v":0},null,"count ",{"$f":"COUNT(H109:H132)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!$D$76:$F$76","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!H29","v":0},4600,0,{"$f":"IF((K112<M112),IF((L112-K112)>O111,O111+K112+N111,L112+N111),(L112+N111))","v":13800},0,0,0,0,4600,0,0,0,0,{"$f":"IF(S112=0,60*V112,60*V112/S112)","v":0},0,0,0,0,{"$f":"IF((X112-Q112)=0,IF(OR(AB111<>0,AB113<>0),0,NA()),X112)","v":{"$error":"#N/A"}},{"$f":"Y112-R112","v":0},null,"short",{"$f":"AG108+AG109-AG111","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!$D$77:$F$77","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D113,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!H30","v":0},4600,0,{"$f":"IF((K113<M113),IF((L113-K113)>O112,O112+K113+N112,L113+N112),(L113+N112))","v":18400},0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!$D$78:$F$78","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D114,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!H31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!$D$79:$F$79","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!H32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V115-O115","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X109:X132)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G113=538,D109,IF(VLOOKUP((G113+G114),'HCM 2010 Program'!$C$3:$H$20,6)>(D109),D109,VLOOKUP((G113+G114),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D116*D115),F109)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!H33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V116-O116","v":0},0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E81","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E81=\"\",\"\",'Step 3 - WZ Analysis'!E81)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!H34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V109:V132)/T132)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D82:F82","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D118,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!H35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D83:F83","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D119,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!H36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z133","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D84:F84","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!H37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!H38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W133","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!H39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!H40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA110:AA133,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"P133","v":0},{"$f":"AA133","v":0},{"$f":"W133","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!H41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"Q133","v":0},{"$f":"AB133","v":0},{"$f":"X133","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!H42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"R134","v":0},{"$f":"AD134","v":0},{"$f":"Y134","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!H43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!H44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!H45","v":0},4600,0,87400,0,0,0,0,4600,0,{"$f":"IF((K128<S128),IF((S128-K128)>V127,V127+K128+U127,S128+U127),(S128+U127))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!H46","v":0},4600,0,92000,0,0,0,0,4600,0,{"$f":"IF((K129<S129),IF((S129-K129)>V128,V128+K129+U128,S129+U128),(S129+U128))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!H47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!H48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!H49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$f":"IF((X132-Q132)=0,IF(OR(AB131<>0,AB109<>0),0,NA()),X132)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P109:P132)","v":0},{"$f":"MAX(Q109:Q132)","v":0},{"$f":"(SUM(R109:R132))","v":0},null,null,null,null,{"$f":"MAX(W109:W132)","v":0},{"$f":"MAX(X109:X132)","v":0},{"$f":"ROUND(SUM(Y109:Y132),0)","v":0},{"$f":"SUM(Z109:Z132)","v":0},{"$f":"MAX(AA109:AA132)","v":0},{"$f":"MAX(AB109:AB132)","v":0},null,{"$f":"ROUND(SUM(AD109:AD132),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R133<100,ROUND(R133,0),IF(R133<1000,ROUND(R133,-1),ROUND(R133,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD134+R134","v":0},null,null,null,null,{"$f":"IF(AD133<100,ROUND(AD133,0),IF(AD133<1000,ROUND(AD133,-1),ROUND(AD133,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!I22","v":"Thursday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F110","v":0},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G147","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D95","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D138*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!I26+K137","v":0},{"$f":"$F$138","v":4600},{"$f":"K138","v":0},{"$f":"MIN(K138,L138)","v":0},{"$f":"IF((K138-L138)<0,0,K138-L138)","v":0},{"$f":"O138*$I$12/(5280*$I$10)","v":0},{"$f":"60*O138/L138","v":0},{"$f":"(Q138*$I$11*($J$16/60))+(Q138*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$141-H139>=0,IF($G$146=\"\",$F$145,$G$146),IF(AND(H138>=$AG$137,H138<$AG$137+$AG$138),IF($G$146=\"\",$F$145,$G$146),$F$138))","v":4600},{"$f":"K138","v":0},{"$f":"MIN(K138,S138)","v":0},{"$f":"IF((K138-S138)<0,0,K138-S138)","v":0},{"$f":"V138*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S138=0,60*V138,60*V138/S138)","v":0},{"$f":"(X138*$I$11*($J$16/60))+(X138*(1-$I$11)*($J$17/60))","v":0},{"$f":"V138-O138","v":0},{"$f":"W138-P138","v":0},{"$f":"X138-Q138","v":0},{"$f":"IF((X138-Q138)=0,IF(OR(AB161<>0,AB139<>0),0,NA()),X138)","v":{"$error":"#N/A"}},{"$f":"Y138-R138","v":0},null,"Duration of closure (hrs)",{"$f":"D149","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!I27","v":0},{"$f":"$F$138","v":4600},{"$f":"M138+K139","v":0},{"$f":"IF((K139<M139),IF((L139-K139)>O138,O138+K139+N138,L139+N138),(L139+N138))","v":4600},{"$f":"IF((K139<L139),IF((L139-K139)>O138,0,O138-(L139-K139)),(O138+(K139-L139)))","v":0},{"$f":"O139*$I$12/(5280*$I$10)","v":0},{"$f":"60*O139/L139","v":0},{"$f":"(Q139*$I$11*($J$16/60))+(Q139*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$141-H140>=0,IF($G$146=\"\",$F$145,$G$146),IF(AND(H139>=$AG$137,H139<$AG$137+$AG$138),IF($G$146=\"\",$F$145,$G$146),$F$138))","v":4600},{"$f":"T138+K139","v":0},{"$f":"IF((K139<S139),IF((S139-K139)>V138,V138+K139+U138,S139+U138),(S139+U138))","v":0},{"$f":"IF((K139<S139),IF((S139-K139)>V138,0,V138-(S139-K139)),(V138+(K139-S139)))","v":0},{"$f":"V139*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S139=0,60*V139,60*V139/S139)","v":0},{"$f":"(X139*$I$11*($J$16/60))+(X139*(1-$I$11)*($J$17/60))","v":0},{"$f":"V139-O139","v":0},{"$f":"W139-P139","v":0},{"$f":"X139-Q139","v":0},{"$f":"IF((X139-Q139)=0,IF(OR(AB138<>0,AB140<>0),0,NA()),X139)","v":{"$error":"#N/A"}},{"$f":"Y139-R139","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!I28","v":0},4600,{"$f":"M139+K140","v":0},{"$f":"IF((K140<M140),IF((L140-K140)>O139,O139+K140+N139,L140+N139),(L140+N139))","v":9200},{"$f":"IF((K140<L140),IF((L140-K140)>O139,0,O139-(L140-K140)),(O139+(K140-L140)))","v":0},0,0,0,4600,{"$f":"T139+K140","v":0},{"$f":"IF((K140<S140),IF((S140-K140)>V139,V139+K140+U139,S140+U139),(S140+U139))","v":0},{"$f":"IF((K140<S140),IF((S140-K140)>V139,0,V139-(S140-K140)),(V139+(K140-S140)))","v":0},{"$f":"V140*$I$12/(5280*$I$10)","v":0},0,0,{"$f":"V140-O140","v":0},{"$f":"W140-P140","v":0},0,{"$f":"IF((X140-Q140)=0,IF(OR(AB139<>0,AB141<>0),0,NA()),X140)","v":{"$error":"#N/A"}},{"$f":"Y140-R140","v":0},null,"count ",{"$f":"COUNT(H138:H161)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D98:F98","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!I29","v":0},4600,0,{"$f":"IF((K141<M141),IF((L141-K141)>O140,O140+K141+N140,L141+N140),(L141+N140))","v":13800},0,0,0,0,4600,0,0,{"$f":"IF((K141<S141),IF((S141-K141)>V140,0,V140-(S141-K141)),(V140+(K141-S141)))","v":0},{"$f":"V141*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S141=0,60*V141,60*V141/S141)","v":0},0,{"$f":"V141-O141","v":0},{"$f":"W141-P141","v":0},0,{"$f":"IF((X141-Q141)=0,IF(OR(AB140<>0,AB142<>0),0,NA()),X141)","v":{"$error":"#N/A"}},{"$f":"Y141-R141","v":0},null,"short",{"$f":"AG137+AG138-AG140","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D99:F99","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D142,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!I30","v":0},4600,0,{"$f":"IF((K142<M142),IF((L142-K142)>O141,O141+K142+N141,L142+N141),(L142+N141))","v":18400},0,0,0,0,4600,0,0,{"$f":"IF((K142<S142),IF((S142-K142)>V141,0,V141-(S142-K142)),(V141+(K142-S142)))","v":0},0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D100:F100","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D143,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!I31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D101:F101","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!I32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V144-O144","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X138:X161)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G142=538,D138,IF(VLOOKUP((G142+G143),'HCM 2010 Program'!$C$3:$H$20,6)>(D138),D138,VLOOKUP((G142+G143),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D145*D144),F138)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!I33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V145-O145","v":0},0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E103","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E103=\"\",\"\",'Step 3 - WZ Analysis'!E103)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!I34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V138:V161)/T161)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D104:F104","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D147,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!I35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D105:F105","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D148,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!I36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z162","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D106:F106","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!I37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!I38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W162","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!I39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!I40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA139:AA162,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"P162","v":0},{"$f":"AA162","v":0},{"$f":"W162","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!I41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"Q162","v":0},{"$f":"AB162","v":0},{"$f":"X162","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!I42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"R163","v":0},{"$f":"AD163","v":0},{"$f":"Y163","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!I43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!I44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!I45","v":0},4600,0,87400,0,0,0,0,4600,0,{"$f":"IF((K157<S157),IF((S157-K157)>V156,V156+K157+U156,S157+U156),(S157+U156))","v":0},0,0,0,{"$f":"(X157*$I$11*($J$16/60))+(X157*(1-$I$11)*($J$17/60))","v":0},0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!I46","v":0},4600,0,92000,0,0,0,0,4600,0,{"$f":"IF((K158<S158),IF((S158-K158)>V157,V157+K158+U157,S158+U157),(S158+U157))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!I47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!I48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!I49","v":0},4600,0,105800,0,0,0,0,4600,0,0,{"$f":"IF((K161<S161),IF((S161-K161)>V160,0,V160-(S161-K161)),(V160+(K161-S161)))","v":0},0,0,{"$f":"(X161*$I$11*($J$16/60))+(X161*(1-$I$11)*($J$17/60))","v":0},0,0,0,{"$f":"IF((X161-Q161)=0,IF(OR(AB160<>0,AB138<>0),0,NA()),X161)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P138:P161)","v":0},{"$f":"MAX(Q138:Q161)","v":0},{"$f":"(SUM(R138:R161))","v":0},null,null,null,null,{"$f":"MAX(W138:W161)","v":0},{"$f":"MAX(X138:X161)","v":0},{"$f":"ROUND(SUM(Y138:Y161),0)","v":0},{"$f":"SUM(Z138:Z161)","v":0},{"$f":"MAX(AA138:AA161)","v":0},{"$f":"MAX(AB138:AB161)","v":0},null,{"$f":"ROUND(SUM(AD138:AD161),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R162<100,ROUND(R162,0),IF(R162<1000,ROUND(R162,-1),ROUND(R162,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD163+R163","v":0},null,null,null,null,{"$f":"IF(AD162<100,ROUND(AD162,0),IF(AD162<1000,ROUND(AD162,-1),ROUND(AD162,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!J22","v":"Friday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F139","v":0},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G176","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D117","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D167*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!J26+K166","v":0},{"$f":"$F$167","v":4600},{"$f":"K167","v":0},{"$f":"MIN(K167,L167)","v":0},{"$f":"IF((K167-L167)<0,0,K167-L167)","v":0},{"$f":"O167*$I$12/(5280*$I$10)","v":0},{"$f":"60*O167/L167","v":0},{"$f":"(Q167*$I$11*($J$16/60))+(Q167*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$170-H168>=0,IF($G$175=\"\",$F$174,$G$175),IF(AND(H167>=$AG$166,H167<$AG$166+$AG$167),IF($G$175=\"\",$F$174,$G$175),$F$167))","v":4600},{"$f":"K167","v":0},{"$f":"MIN(K167,S167)","v":0},{"$f":"IF((K167-S167)<0,0,K167-S167)","v":0},{"$f":"V167*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S167=0,60*V167,60*V167/S167)","v":0},{"$f":"(X167*$I$11*($J$16/60))+(X167*(1-$I$11)*($J$17/60))","v":0},{"$f":"V167-O167","v":0},{"$f":"W167-P167","v":0},{"$f":"X167-Q167","v":0},{"$f":"IF((X167-Q167)=0,IF(OR(AB190<>0,AB168<>0),0,NA()),X167)","v":{"$error":"#N/A"}},{"$f":"Y167-R167","v":0},null,"Duration of closure (hrs)",{"$f":"D178","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!J27","v":0},{"$f":"$F$167","v":4600},{"$f":"M167+K168","v":0},{"$f":"IF((K168<M168),IF((L168-K168)>O167,O167+K168+N167,L168+N167),(L168+N167))","v":4600},{"$f":"IF((K168<L168),IF((L168-K168)>O167,0,O167-(L168-K168)),(O167+(K168-L168)))","v":0},{"$f":"O168*$I$12/(5280*$I$10)","v":0},{"$f":"60*O168/L168","v":0},{"$f":"(Q168*$I$11*($J$16/60))+(Q168*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$170-H169>=0,IF($G$175=\"\",$F$174,$G$175),IF(AND(H168>=$AG$166,H168<$AG$166+$AG$167),IF($G$175=\"\",$F$174,$G$175),$F$167))","v":4600},{"$f":"T167+K168","v":0},{"$f":"IF((K168<S168),IF((S168-K168)>V167,V167+K168+U167,S168+U167),(S168+U167))","v":0},{"$f":"IF((K168<S168),IF((S168-K168)>V167,0,V167-(S168-K168)),(V167+(K168-S168)))","v":0},{"$f":"V168*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S168=0,60*V168,60*V168/S168)","v":0},{"$f":"(X168*$I$11*($J$16/60))+(X168*(1-$I$11)*($J$17/60))","v":0},{"$f":"V168-O168","v":0},{"$f":"W168-P168","v":0},{"$f":"X168-Q168","v":0},{"$f":"IF((X168-Q168)=0,IF(OR(AB167<>0,AB169<>0),0,NA()),X168)","v":{"$error":"#N/A"}},{"$f":"Y168-R168","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!J28","v":0},4600,{"$f":"M168+K169","v":0},{"$f":"IF((K169<M169),IF((L169-K169)>O168,O168+K169+N168,L169+N168),(L169+N168))","v":9200},{"$f":"IF((K169<L169),IF((L169-K169)>O168,0,O168-(L169-K169)),(O168+(K169-L169)))","v":0},0,0,0,4600,{"$f":"T168+K169","v":0},{"$f":"IF((K169<S169),IF((S169-K169)>V168,V168+K169+U168,S169+U168),(S169+U168))","v":0},{"$f":"IF((K169<S169),IF((S169-K169)>V168,0,V168-(S169-K169)),(V168+(K169-S169)))","v":0},{"$f":"V169*$I$12/(5280*$I$10)","v":0},0,0,{"$f":"V169-O169","v":0},{"$f":"W169-P169","v":0},0,{"$f":"IF((X169-Q169)=0,IF(OR(AB168<>0,AB170<>0),0,NA()),X169)","v":{"$error":"#N/A"}},{"$f":"Y169-R169","v":0},null,"count ",{"$f":"COUNT(H167:H190)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D120:F120","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!J29","v":0},4600,0,{"$f":"IF((K170<M170),IF((L170-K170)>O169,O169+K170+N169,L170+N169),(L170+N169))","v":13800},0,0,0,0,4600,0,0,0,{"$f":"V170*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S170=0,60*V170,60*V170/S170)","v":0},0,{"$f":"V170-O170","v":0},{"$f":"W170-P170","v":0},0,{"$f":"IF((X170-Q170)=0,IF(OR(AB169<>0,AB171<>0),0,NA()),X170)","v":{"$error":"#N/A"}},{"$f":"Y170-R170","v":0},null,"short",{"$f":"AG166+AG167-AG169","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D121:F121","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D171,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!J30","v":0},4600,0,{"$f":"IF((K171<M171),IF((L171-K171)>O170,O170+K171+N170,L171+N170),(L171+N170))","v":18400},0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D122:F122","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D172,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!J31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D123:F123","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!J32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V173-O173","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X167:X190)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G171=538,D167,IF(VLOOKUP((G171+G172),'HCM 2010 Program'!$C$3:$H$20,6)>(D167),D167,VLOOKUP((G171+G172),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D174*D173),F167)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!J33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V174-O174","v":0},0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E125","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E125=\"\",\"\",'Step 3 - WZ Analysis'!E125)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!J34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V167:V190)/T190)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D126:F126","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D176,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!J35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D127:F127","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D177,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!J36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z191","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D128:F128","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!J37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!J38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W191","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!J39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!J40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA168:AA191,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"P191","v":0},{"$f":"AA191","v":0},{"$f":"W191","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!J41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"Q191","v":0},{"$f":"AB191","v":0},{"$f":"X191","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!J42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"R192","v":0},{"$f":"AD192","v":0},{"$f":"Y192","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!J43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!J44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!J45","v":0},4600,0,87400,0,0,0,0,4600,0,{"$f":"IF((K186<S186),IF((S186-K186)>V185,V185+K186+U185,S186+U185),(S186+U185))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!J46","v":0},4600,0,92000,0,0,0,0,4600,0,{"$f":"IF((K187<S187),IF((S187-K187)>V186,V186+K187+U186,S187+U186),(S187+U186))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!J47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!J48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!J49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$f":"IF((X190-Q190)=0,IF(OR(AB189<>0,AB167<>0),0,NA()),X190)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P167:P190)","v":0},{"$f":"MAX(Q167:Q190)","v":0},{"$f":"(SUM(R167:R190))","v":0},null,null,null,null,{"$f":"MAX(W167:W190)","v":0},{"$f":"MAX(X167:X190)","v":0},{"$f":"ROUND(SUM(Y167:Y190),0)","v":0},{"$f":"SUM(Z167:Z190)","v":0},{"$f":"MAX(AA167:AA190)","v":0},{"$f":"MAX(AB167:AB190)","v":0},null,{"$f":"ROUND(SUM(AD167:AD190),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R191<100,ROUND(R191,0),IF(R191<1000,ROUND(R191,-1),ROUND(R191,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD192+R192","v":0},null,null,null,null,{"$f":"IF(AD191<100,ROUND(AD191,0),IF(AD191<1000,ROUND(AD191,-1),ROUND(AD191,-2)))","v":0}]
[]
[{"$f":"'Step 2 - Facility Data Inputs'!K22","v":"Saturday"},null,null,null,null,null,null,{"$f":"'Step 2 - Facility Data Inputs'!F168","v":0},"TIME",null,"DEMAND","Base Capacity","Base Arrivals","Base Departures","Base Queued Vehicles","Base Queue","Base Delay","Base User Cost","CAPACITY","TOTAL ARRIVALS","TOTAL DEPARTURES","QUEUED VEHICLES","QUEUE LENGTH","Total Delay","User cost","WZ QUEUED VEHICLES","WZ Queue","WZ Delay","WZ Delay for Graph","WZ User Cost"]
[null,null,"BASE CONDITIONS",null,null,null,null,null,null,"Unmet Demand from Previous Day ->",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time (24 hour clock)",{"$f":"G205","v":0}]
[null,null,"Open Lane Capacity (pc/h/lane):",{"$f":"'Step 3 - WZ Analysis'!D139","v":2300},"Base Conditions Capacity (Total for ALL Lanes):",{"$f":"D196*$I$10","v":4600},null,0,"00:00:00",0,{"$f":"'Step 2 - Facility Data Inputs'!K26+K195","v":0},{"$f":"$F$196","v":4600},{"$f":"K196","v":0},{"$f":"MIN(K196,L196)","v":0},{"$f":"IF((K196-L196)<0,0,K196-L196)","v":0},{"$f":"O196*$I$12/(5280*$I$10)","v":0},{"$f":"60*O196/L196","v":0},{"$f":"(Q196*$I$11*($J$16/60))+(Q196*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$199-H197>=0,IF($G$204=\"\",$F$203,$G$204),IF(AND(H196>=$AG$195,H196<$AG$195+$AG$196),IF($G$204=\"\",$F$203,$G$204),$F$196))","v":4600},{"$f":"K196","v":0},{"$f":"MIN(K196,S196)","v":0},{"$f":"IF((K196-S196)<0,0,K196-S196)","v":0},{"$f":"V196*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S196=0,60*V196,60*V196/S196)","v":0},{"$f":"(X196*$I$11*($J$16/60))+(X196*(1-$I$11)*($J$17/60))","v":0},{"$f":"V196-O196","v":0},{"$f":"W196-P196","v":0},{"$f":"X196-Q196","v":0},{"$f":"IF((X196-Q196)=0,IF(OR(AB219<>0,AB197<>0),0,NA()),X196)","v":{"$error":"#N/A"}},{"$f":"Y196-R196","v":0},null,"Duration of closure (hrs)",{"$f":"D207","v":0}]
[null,null,null,null,null,null,null,1,"01:00:00",1,{"$f":"'Step 2 - Facility Data Inputs'!K27","v":0},{"$f":"$F$196","v":4600},{"$f":"M196+K197","v":0},{"$f":"IF((K197<M197),IF((L197-K197)>O196,O196+K197+N196,L197+N196),(L197+N196))","v":4600},{"$f":"IF((K197<L197),IF((L197-K197)>O196,0,O196-(L197-K197)),(O196+(K197-L197)))","v":0},{"$f":"O197*$I$12/(5280*$I$10)","v":0},{"$f":"60*O197/L197","v":0},{"$f":"(Q197*$I$11*($J$16/60))+(Q197*(1-$I$11)*($J$17/60))","v":0},{"$f":"IF($AG$199-H198>=0,IF($G$204=\"\",$F$203,$G$204),IF(AND(H197>=$AG$195,H197<$AG$195+$AG$196),IF($G$204=\"\",$F$203,$G$204),$F$196))","v":4600},{"$f":"T196+K197","v":0},{"$f":"IF((K197<S197),IF((S197-K197)>V196,V196+K197+U196,S197+U196),(S197+U196))","v":0},{"$f":"IF((K197<S197),IF((S197-K197)>V196,0,V196-(S197-K197)),(V196+(K197-S197)))","v":0},{"$f":"V197*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S197=0,60*V197,60*V197/S197)","v":0},{"$f":"(X197*$I$11*($J$16/60))+(X197*(1-$I$11)*($J$17/60))","v":0},{"$f":"V197-O197","v":0},{"$f":"W197-P197","v":0},{"$f":"X197-Q197","v":0},{"$f":"IF((X197-Q197)=0,IF(OR(AB196<>0,AB198<>0),0,NA()),X197)","v":{"$error":"#N/A"}},{"$f":"Y197-R197","v":0}]
[null,null,"WORKZONE DETAILS",null,null,null,null,2,"02:00:00",2,{"$f":"'Step 2 - Facility Data Inputs'!K28","v":0},4600,{"$f":"M197+K198","v":0},{"$f":"IF((K198<M198),IF((L198-K198)>O197,O197+K198+N197,L198+N197),(L198+N197))","v":9200},{"$f":"IF((K198<L198),IF((L198-K198)>O197,0,O197-(L198-K198)),(O197+(K198-L198)))","v":0},0,0,0,4600,{"$f":"T197+K198","v":0},{"$f":"IF((K198<S198),IF((S198-K198)>V197,V197+K198+U197,S198+U197),(S198+U197))","v":0},{"$f":"IF((K198<S198),IF((S198-K198)>V197,0,V197-(S198-K198)),(V197+(K198-S198)))","v":0},{"$f":"V198*$I$12/(5280*$I$10)","v":0},0,0,{"$f":"V198-O198","v":0},{"$f":"W198-P198","v":0},0,{"$f":"IF((X198-Q198)=0,IF(OR(AB197<>0,AB199<>0),0,NA()),X198)","v":{"$error":"#N/A"}},{"$f":"Y198-R198","v":0},null,"count ",{"$f":"COUNT(H196:H219)","v":24}]
[null,null,"Work Description:",{"$f":"'Step 3 - WZ Analysis'!D142:F142","v":"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"},null,null,null,3,"03:00:00",3,{"$f":"'Step 2 - Facility Data Inputs'!K29","v":0},4600,0,{"$f":"IF((K199<M199),IF((L199-K199)>O198,O198+K199+N198,L199+N198),(L199+N198))","v":13800},0,0,0,0,4600,0,0,0,{"$f":"V199*$I$12/(5280*$I$10)","v":0},{"$f":"IF(S199=0,60*V199,60*V199/S199)","v":0},0,{"$f":"V199-O199","v":0},{"$f":"W199-P199","v":0},0,{"$f":"IF((X199-Q199)=0,IF(OR(AB198<>0,AB200<>0),0,NA()),X199)","v":{"$error":"#N/A"}},{"$f":"Y199-R199","v":0},null,"short",{"$f":"AG195+AG196-AG198","v":-24}]
[null,null,"Work Location:",{"$f":"'Step 3 - WZ Analysis'!D143:F143","v":"No Work Zone (Use for Calibrating Existing Conditions)"},null,null,{"$f":"VLOOKUP(D200,'Reference Sheet'!$S$2:$T$8,2)","v":538},4,"04:00:00",4,{"$f":"'Step 2 - Facility Data Inputs'!K30","v":0},4600,0,{"$f":"IF((K200<M200),IF((L200-K200)>O199,O199+K200+N199,L200+N199),(L200+N199))","v":18400},0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Travel Lane Width (ft):",{"$f":"'Step 3 - WZ Analysis'!D144:F144","v":"> 11.5"},null,null,{"$f":"VLOOKUP(D201,'Reference Sheet'!$V$2:$W$4,2)","v":1},5,"05:00:00",5,{"$f":"'Step 2 - Facility Data Inputs'!K31","v":0},4600,0,23000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Number of Lanes Open:",{"$f":"'Step 3 - WZ Analysis'!D145:F145","v":1},null,null,null,6,"06:00:00",6,{"$f":"'Step 2 - Facility Data Inputs'!K32","v":0},4600,0,27600,0,0,0,0,4600,0,0,0,0,0,{"$f":"(X202*$I$11*($J$16/60))+(X202*(1-$I$11)*($J$17/60))","v":0},{"$f":"V202-O202","v":0},0,0,{"$error":"#N/A"},0,null,"MAX DELAY (minutes)",{"$f":"MAX(X196:X219)","v":0}]
[null,null,"ESTIMATED Work Zone Capacity (pc/h):",{"$f":"IF(G200=538,D196,IF(VLOOKUP((G200+G201),'HCM 2010 Program'!$C$3:$H$20,6)>(D196),D196,VLOOKUP((G200+G201),'HCM 2010 Program'!$C$3:$H$20,6)))","v":2300},"Capacity all wz lanes",{"$f":"MIN((D203*D202),F196)","v":2300},"cell below in use",7,"07:00:00",7,{"$f":"'Step 2 - Facility Data Inputs'!K33","v":0},4600,0,32200,0,0,0,0,4600,0,0,0,0,0,0,{"$f":"V203-O203","v":0},0,0,{"$error":"#N/A"},0]
[null,null,"USER DEFINED Work Zone Capacity (pc/h):",null,{"$f":"'Step 3 - WZ Analysis'!E147","v":0},null,{"$f":"IF('Step 3 - WZ Analysis'!E147=\"\",\"\",'Step 3 - WZ Analysis'!E147)","v":""},8,"08:00:00",8,{"$f":"'Step 2 - Facility Data Inputs'!K34","v":0},4600,0,36800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"AVE DELAY (minutes)",{"$f":"(SUM(V196:V219)/T219)*60","v":{"$error":"#DIV/0!"}}]
[null,null,"Start Time:",{"$f":"'Step 3 - WZ Analysis'!D148:F148","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D205,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},9,"09:00:00",9,{"$f":"'Step 2 - Facility Data Inputs'!K35","v":0},4600,0,41400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"End Time:",{"$f":"'Step 3 - WZ Analysis'!D149:F149","v":"00:00:00"},null,null,{"$f":"VLOOKUP(D206,'WZ Analysis (Worksheet)'!$I$22:$J$45,2)","v":0},10,"10:00:00",10,{"$f":"'Step 2 - Facility Data Inputs'!K36","v":0},4600,0,46000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"COST ($)",{"$f":"Z220","v":0}]
[null,null,"Duration of closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D150:F150","v":0},null,null,null,11,"11:00:00",11,{"$f":"'Step 2 - Facility Data Inputs'!K37","v":0},4600,0,50600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,12,"12:00:00",12,{"$f":"'Step 2 - Facility Data Inputs'!K38","v":0},4600,0,55200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"MAX QUEUE LENGTH (miles)",{"$f":"W220","v":0}]
[null,null,"RESULTS",null,null,null,null,13,"13:00:00",13,{"$f":"'Step 2 - Facility Data Inputs'!K39","v":0},4600,0,59800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total",null,14,"14:00:00",14,{"$f":"'Step 2 - Facility Data Inputs'!K40","v":0},4600,0,64400,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0,null,"Hours per day of queuing",{"$f":"24-COUNTIF(AA197:AA220,0)","v":0}]
[null,null,"Max Queue Length (mi):",{"$f":"P220","v":0},{"$f":"AA220","v":0},{"$f":"W220","v":0},null,15,"15:00:00",15,{"$f":"'Step 2 - Facility Data Inputs'!K41","v":0},4600,0,69000,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Max Delay (minutes):",{"$f":"Q220","v":0},{"$f":"AB220","v":0},{"$f":"X220","v":0},null,16,"16:00:00",16,{"$f":"'Step 2 - Facility Data Inputs'!K42","v":0},4600,0,73600,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,"Cost ($):",{"$f":"R221","v":0},{"$f":"AD221","v":0},{"$f":"Y221","v":0},null,17,"17:00:00",17,{"$f":"'Step 2 - Facility Data Inputs'!K43","v":0},4600,0,78200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,18,"18:00:00",18,{"$f":"'Step 2 - Facility Data Inputs'!K44","v":0},4600,0,82800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,19,"19:00:00",19,{"$f":"'Step 2 - Facility Data Inputs'!K45","v":0},4600,0,87400,0,0,0,0,4600,0,{"$f":"IF((K215<S215),IF((S215-K215)>V214,V214+K215+U214,S215+U214),(S215+U214))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,20,"20:00:00",20,{"$f":"'Step 2 - Facility Data Inputs'!K46","v":0},4600,0,92000,0,0,0,0,4600,0,{"$f":"IF((K216<S216),IF((S216-K216)>V215,V215+K216+U215,S216+U215),(S216+U215))","v":0},0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,21,"21:00:00",21,{"$f":"'Step 2 - Facility Data Inputs'!K47","v":0},4600,0,96600,0,0,0,0,4600,0,0,0,0,0,{"$f":"(X217*$I$11*($J$16/60))+(X217*(1-$I$11)*($J$17/60))","v":0},0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,22,"22:00:00",22,{"$f":"'Step 2 - Facility Data Inputs'!K48","v":0},4600,0,101200,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},0]
[null,null,null,null,null,null,null,23,"23:00:00",23,{"$f":"'Step 2 - Facility Data Inputs'!K49","v":0},4600,0,105800,0,0,0,0,4600,0,0,0,0,0,0,0,0,0,{"$f":"IF((X219-Q219)=0,IF(OR(AB218<>0,AB196<>0),0,NA()),X219)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P196:P219)","v":0},{"$f":"MAX(Q196:Q219)","v":0},{"$f":"(SUM(R196:R219))","v":0},null,null,null,null,{"$f":"MAX(W196:W219)","v":0},{"$f":"MAX(X196:X219)","v":0},{"$f":"ROUND(SUM(Y196:Y219),0)","v":0},{"$f":"SUM(Z196:Z219)","v":0},{"$f":"MAX(AA196:AA219)","v":0},{"$f":"MAX(AB196:AB219)","v":0},null,{"$f":"ROUND(SUM(AD196:AD219),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R220<100,ROUND(R220,0),IF(R220<1000,ROUND(R220,-1),ROUND(R220,-2)))","v":0},null,null,null,null,null,null,{"$f":"AD221+R221","v":0},null,null,null,null,{"$f":"IF(AD220<100,ROUND(AD220,0),IF(AD220<1000,ROUND(AD220,-1),ROUND(AD220,-2)))","v":0}]

{"sheet":"ADV WZ Calcs","index":6,"n_rows":37,"n_cols":111,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,88,0,98],[1,88,1,89],[1,90,1,94],[1,95,1,97],[1,98,2,98],[0,76,0,86],[1,76,1,77],[1,78,1,82],[1,83,1,85],[1,86,2,86],[0,64,0,74],[1,64,1,65],[1,66,1,70],[1,71,1,73],[1,74,2,74],[0,28,0,38],[1,28,1,29],[1,30,1,34],[1,35,1,37],[1,38,2,38],[1,4,1,5],[1,6,1,10],[1,11,1,13],[1,14,2,14],[0,4,0,14],[0,16,0,26],[1,16,1,17],[1,18,1,22],[1,23,1,25],[1,26,2,26],[0,40,0,50],[1,40,1,41],[1,42,1,46],[1,47,1,49],[1,50,2,50],[0,52,0,62],[1,52,1,53],[1,54,1,58],[1,59,1,61],[1,62,2,62],[0,100,0,110],[1,100,1,101],[1,102,1,106],[1,107,1,109],[1,110,2,110]]}
[null,null,null,null,"1. Construction Vehicle Warning System",null,null,null,null,null,null,null,null,null,null,null,"2. Dynamic Late Merge (Zipper Merge) System",null,null,null,null,null,null,null,null,null,null,null,"8. Travel Time Advisory System",null,null,null,null,null,null,null,null,null,null,null,"9. Travel Time Advisory System with Alternative Route",null,null,null,null,null,null,null,null,null,null,null,"3. Queue Warning System",null,null,null,null,null,null,null,null,null,null,null,"4. Road Closure",null,null,null,null,null,null,null,null,null,null,null,"5. Speed Warning System",null,null,null,null,null,null,null,null,null,null,null,"7. Temporary Traffic Incident Management and ITS System",null,null,null,null,null,null,null,null,null,null,null,"6. Temporary Rumble Strips"]
[null,null,null,null,"Pass/Fail Criteria",null,"Scoring",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments",null,"Pass/Fail Criteria",null,"Scoring Calculations",null,null,null,null,"Costs",null,null,"Comments"]
["Question / Criteria","Value","Unit",null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost",null,null,"Minimum Threshold","Result","Lower Threshold","Upper Threshold","Lower Limit Score","Upper Limit Score","Score","Base Cost","Weekly Maint Cost","Total Cost"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A10","v":"Facility Speed Limit (mph)"},{"$f":"'Step 3a - ADV WZ Analysis'!C10","v":0},"mph",null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"B4>=Q4","v":false},40,65,3,10,{"$f":"IF($B4<=S4,U4,IF($B4>=T4,V4,U4+(V4-U4)*($B4-S4)/(T4-S4)))","v":3},null,null,null,"Approach speed must be at least 50 mph. Higher approach speeds increase the probability of conflicts and crashes at the back of a queue.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,65,3,10,{"$f":"IF($B4<=BC4,BE4,IF($B4>=BD4,BF4,BE4+(BF4-BE4)*($B4-BC4)/(BD4-BC4)))","v":3},null,null,null,"Higher speeds increase risk for vehicles approaching the back of a queue",null,null,null,null,null,null,null,null,null,null,null,"Higher speeds increase risk for vehicles approaching the back of a queue",null,45,{"$f":"BY4<=B4","v":false},35,55,2,8,{"$f":"IF($B4<=CA4,CC4,IF($B4>=CB4,CD4,CC4+(CD4-CC4)*($B4-CA4)/(CB4-CA4)))","v":2},null,null,null,"Applicable in work zones with higher speeds",null,55,{"$f":"$B4>=CK4","v":false},55,70,1,10,{"$f":"IF($B4<=CM4,CO4,IF($B4>=CN4,CP4,CO4+(CP4-CO4)*($B4-CM4)/(CN4-CM4)))","v":1},null,null,null,null,null,35,{"$f":"$B4>=CW4","v":false},35,60,5,10,{"$f":"IF($B4<=CY4,DA4,IF($B4>=CZ4,DB4,DA4+(DB4-DA4)*($B4-CY4)/(CZ4-CY4)))","v":5},2000,null,{"$f":"DD4","v":2000},"Assumes 1 set and 1 approach"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A12","v":"Are traffic patterns inconsistent from day to day? (e.g. unpredictible with \nsubstantial variability or impacts from random local traffic genertors)"},{"$f":"'Step 3a - ADV WZ Analysis'!C12","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",3,10,{"$f":"IF($B5<=S5,U5,IF($B5>=T5,V5,U5+(V5-U5)*($B5-S5)/(T5-S5)))","v":3},null,null,null,null,null,null,null,"No","Yes",3,10,{"$f":"IF($B5<=AE5,AG5,IF($B5>=AF5,AH5,AG5+(AH5-AG5)*($B5-AE5)/(AF5-AE5)))","v":3},null,null,null,"TT Advisory systems are more useful when traffic is inconsistent.",null,null,null,"No","Yes",3,10,{"$f":"IF($B5<=AQ5,AS5,IF($B5>=AR5,AT5,AS5+(AT5-AS5)*($B5-AQ5)/(AR5-AQ5)))","v":3},null,null,null,"Variability increases the value of a TT/Alt Route system",null,null,null,"No","Yes",3,8,{"$f":"IF($B5<=BC5,BE5,IF($B5>=BD5,BF5,BE5+(BF5-BE5)*($B5-BC5)/(BD5-BC5)))","v":3},null,null,null,"Unpredictible traffic incrases the value of a queue warning system",null,null,null,null,null,null,null,null,null,null,null,"Unpredictible traffic incrases the value of a queue warning system"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A14","v":"Is the work zone on a route with an existing ITS Travel Time System?"},{"$f":"'Step 3a - ADV WZ Analysis'!C14","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",5,20,{"$f":"IF($B6<=AE6,AG6,IF($B6>=AF6,AH6,AG6+(AH6-AG6)*($B6-AE6)/(AF6-AE6)))","v":5},{"$f":"-AJ11*0.75","v":-15000},{"$f":"-AK13*0.75","v":-56.25},{"$f":"IF($B6=\"Yes\",AJ6*($B11+B25)+AK6*($B11+B25),0)","v":0},"If this falls within an existing ITS system, then the setup cost is estimted at 75% lower",null,null,null,"No","Yes",5,20,{"$f":"IF($B6<=AQ6,AS6,IF($B6>=AR6,AT6,AS6+(AT6-AS6)*($B6-AQ6)/(AR6-AQ6)))","v":5},{"$f":"-AV11*0.75","v":-15000},{"$f":"-AW13*0.75","v":-56.25},{"$f":"IF(B6=\"Yes\",AV6*(B11+N25)+AW6*(B11+N25),0)","v":0},"An existing ITS system increases the feasibility for and reduces cost for this system.",null,null,null,"No","Yes",5,0,{"$f":"IF($B6<=BC6,BE6,IF($B6>=BD6,BF6,BE6+(BF6-BE6)*($B6-BC6)/(BD6-BC6)))","v":5},null,null,null,"Existing ITS devices may reduce the cost of detecting real-time queues",null,null,null,null,null,null,null,null,null,null,null,"Existing ITS devices may reduce the cost of detecting real-time queues"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A16","v":"Are one or more alternative routes with capacity available?"},{"$f":"'Step 3a - ADV WZ Analysis'!C16","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"$B7=AO7","v":false},null,null,null,null,null,null,null,null,"If no alt routes are available, do not consider this option.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",0,10,{"$f":"IF($B7<=BO7,BQ7,IF($B7>=BP7,BR7,BQ7+(BR7-BQ7)*($B7-BO7)/(BP7-BO7)))","v":0},null,null,null,"The availability of alternative routes makes a road closure more feasible."]
[{"$f":"'Step 3a - ADV WZ Analysis'!A18","v":"If yes, what is the approximate length of the existing alternative routes (mi)?"},{"$f":"'Step 3a - ADV WZ Analysis'!C18","v":0},"mi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20000","v":20000},null,{"$f":"$B8*AV8","v":0},"Cost to outfit alternate routes with ITS devices. **note that this system may increase the mileage needed along the primary route also, but this is not accounted for here because of the added complexity and time needed for a user."]
[{"$f":"'Step 3a - ADV WZ Analysis'!A20","v":"If yes, do the alternatative routes have existing ITS Travel Time capability?"},{"$f":"'Step 3a - ADV WZ Analysis'!C20","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",0,5,{"$f":"IF($B9<=AQ9,AS9,IF($B9>=AR9,AT9,AS9+(AT9-AS9)*($B9-AQ9)/(AR9-AQ9)))","v":0},{"$f":"-AV11*0.75","v":-15000},{"$f":"-AW13*0.75","v":-56.25},{"$f":"IF(B9=\"Yes\",AV6*(B8+N25)+AW6*(B8+N25),0)","v":0},"75% discount if ITS devices and TT Capability already exist on the routes."]
[{"$f":"'Step 3a - ADV WZ Analysis'!A26","v":"Work Zone Speed Limit (mph)"},{"$f":"'Step 3a - ADV WZ Analysis'!C26","v":0},"mph",null,null,null,35,55,2,10,{"$f":"IF($B10<=G10,I10,IF($B10>=H10,J10,I10+(J10-I10)*($B10-G10)/(H10-G10)))","v":2},null,null,null,"Higher work zone speeds will lead to a higher potential for crashes with entering construction vehicles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"BY10<=B10","v":false},35,55,4,8,{"$f":"IF($B10<=CA10,CC10,IF($B10>=CB10,CD10,CC10+(CD10-CC10)*($B10-CA10)/(CB10-CA10)))","v":4},null,null,null,"Applicable in work zones with higher speeds"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A28","v":"Total approximate work zone length (mi)"},{"$f":"'Step 3a - ADV WZ Analysis'!C28","v":0},"mi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20000","v":20000},null,{"$f":"$B11*AJ11","v":0},"Base: $20k/mile of work zone",null,null,null,null,null,null,null,null,{"$f":"20000","v":20000},null,{"$f":"$B11*AV11","v":0},"Base: $20k/mile of work zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"B11>=CK11","v":false},1,3,1,5,{"$f":"IF($B11<=CM11,CO11,IF($B11>=CN11,CP11,CO11+(CP11-CO11)*($B11-CM11)/(CN11-CM11)))","v":1},null,150,{"$f":"(FLOOR(B11/1,1))*B13*2*CS11","v":0},"$150/device/day/mile. Assumes 2 devices (camera/sensor) per mile. Assumes portable DMS are covered elsewhere. Reduce cost for existing sensors/cameras. Add if emergency response units on standby."]
[{"$f":"'Step 3a - ADV WZ Analysis'!A30","v":"Total approximate taper length leading up to work zone (mi)"},{"$f":"'Step 3a - ADV WZ Analysis'!C30","v":0},"mi"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A32","v":"Number of days the work zone will be in place"},{"$f":"'Step 3a - ADV WZ Analysis'!C32","v":0},"day",null,null,null,null,null,null,null,null,null,200,{"$f":"M13*B13/7*B15","v":0},"Weekly cost per access point",null,7,{"$f":"B13>=Q13","v":false},null,null,null,null,null,null,null,null,"Work zone must be in place at least 7 days",null,null,null,null,null,null,null,null,null,{"$f":"300/4","v":75},{"$f":"AK13*(B11+B25)","v":0},"$200/week/mile of WZ+Queue",null,null,null,null,null,null,null,null,null,{"$f":"300/4","v":75},{"$f":"AW13*(B11+B25+B8)","v":0},"$200/week/mile of WZ+Queue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,{"$f":"(1+FLOOR(B11/5,1))*CF13*24*B13","v":0},"DELETE COST IF MODOT OWNED TRAILERS. \nNumber of trailers (asuming 1 per every 5 miles) * WZ length. Contractor provided Cost:$10/hour.",null,30,{"$f":"$B13>=CK13","v":false}]
[{"$f":"'Step 3a - ADV WZ Analysis'!A34","v":"Will proposed lane closures persist (e.g. not be set up and taken down frequently)?"},{"$f":"'Step 3a - ADV WZ Analysis'!C34","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"Q14=B14","v":false},null,null,null,null,null,null,null,null,"Because of the work required to set up and calibrate the system, it should not be installed on short term closure.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"BY14=B14","v":false}]
[{"$f":"'Step 3a - ADV WZ Analysis'!A36","v":"Number of access points where low speed construction vehicles will enter the \nwork zone without an adequate dedicated acceleration lane"},{"$f":"'Step 3a - ADV WZ Analysis'!C36","v":0},"num access points",null,1,{"$f":"B15>E15","v":false},null,null,null,null,null,15000,null,{"$f":"L15*B15","v":0},"Invalid strategy if there are no construction vehicle access points. Base cost per access point."]
[{"$f":"'Step 3a - ADV WZ Analysis'!A38","v":"Will sight distance be limited on the approach to the work zone?"},{"$f":"'Step 3a - ADV WZ Analysis'!C38","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",0,20,{"$f":"IF($B16<=BC16,BE16,IF($B16>=BD16,BF16,BE16+(BF16-BE16)*($B16-BC16)/(BD16-BC16)))","v":0},null,null,null,"A Queue warning system has creater value if sight distance issues exist",null,null,null,null,null,null,null,null,null,null,null,"A Queue warning system has creater value if sight distance issues exist"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A40","v":"Are queue lengths anticipated to extend past an upstream intersection or interchange?"},{"$f":"'Step 3a - ADV WZ Analysis'!C40","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",0,5,{"$f":"IF($B17<=BC17,BE17,IF($B17>=BD17,BF17,BE17+(BF17-BE17)*($B17-BC17)/(BD17-BC17)))","v":0},null,null,null,"A Queue warning system has greater value if upstream conflicts exist",null,null,null,null,null,null,null,null,null,null,null,"A Queue warning system has greater value if upstream conflicts exist"]
[{"$f":"'Step 3a - ADV WZ Analysis'!A44","v":"Will the work zone have navigating contrstraints that inhibit emergency responder access?"},{"$f":"'Step 3a - ADV WZ Analysis'!C44","v":0},"Y/N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Yes",0,10,{"$f":"IF($B18<=CM18,CO18,IF($B18>=CN18,CP18,CO18+(CP18-CO18)*($B18-CM18)/(CN18-CM18)))","v":0}]
[{"$f":"'Step 3a - ADV WZ Analysis'!A46","v":"Total estimate project cost without smart workzone strategies ($)"},{"$f":"'Step 3a - ADV WZ Analysis'!C46","v":0},"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9E-2,null,{"$f":"MIN(X19*$B19,50000)","v":0},"1.9% of total project cost or a max of $50k per setup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-3,null,{"$f":"BT19*B19","v":0},"0.5% of total project cost"]
["Directional AADT per open lane in the WZ",{"$f":"MAX('Step 2 - Facility Data Inputs'!E50:K50)/(MIN('Step 3 - WZ Analysis'!$D$13:$F$13,'Step 3 - WZ Analysis'!$D$35:$F$35,'Step 3 - WZ Analysis'!$D$57:$F$57,'Step 3 - WZ Analysis'!$D$79:$F$79,'Step 3 - WZ Analysis'!$D$101:$F$101,'Step 3 - WZ Analysis'!$D$123:$F$123,'Step 3 - WZ Analysis'!$D$145:$F$145))","v":0},"AADT",null,2500,{"$f":"$B20>E20","v":false},2500,15000,1,10,{"$f":"IF($B20<=G20,I20,IF($B20>=H20,J20,I20+(J20-I20)*($B20-G20)/(H20-G20)))","v":1},null,null,null,"Lower volumes will permit construction vehicles to enter the roadway with few potential conflicts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,20000,1,10,{"$f":"MIN(((BR20-BQ20)/(BO20-((BP20-BO20)/2+BO20))^2)*(B20-((BP20-BO20)/2+BO20))^2+BQ20,10)","v":10},null,null,null,"This strategy should be considered for very low and very high volume roads. The score is therefore calculated using a parabolic equation with max score at both the low limit and high limits, and low score at the midpoint.",null,null,null,null,null,null,null,null,null,null,null,null,null,2500,{"$f":"CK20<=$B20","v":false},2500,15000,1,10,{"$f":"IF($B20<=CM20,CO20,IF($B20>=CN20,CP20,CO20+(CP20-CO20)*($B20-CM20)/(CN20-CM20)))","v":1},null,null,null,null,null,2500,{"$f":"CW20<=$B20","v":false},2500,15000,1,5,{"$f":"IF($B20<=CY20,DA20,IF($B20>=CZ20,DB20,DA20+(DB20-DA20)*($B20-CY20)/(CZ20-CY20)))","v":1}]
["Number of approach lanes",{"$f":"MAX('Step 2 - Facility Data Inputs'!A15:C15)","v":2},"num lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"Q21=$B21","v":true},null,null,null,null,null,null,null,null,"Must have 2 approach lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"BY21<=B21","v":true},null,null,null,null,null,null,null,null,"For use on multi lane routes"]
["Number of open lanes in WZ",{"$f":"MIN('Step 3 - WZ Analysis'!D13:F13,'Step 3 - WZ Analysis'!D35:F35,'Step 3 - WZ Analysis'!D57:F57,'Step 3 - WZ Analysis'!D79:F79,'Step 3 - WZ Analysis'!D101:F101,'Step 3 - WZ Analysis'!D123:F123,'Step 3 - WZ Analysis'!D145:F145)","v":1},"num lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"Q22=$B22","v":true},null,null,null,null,null,null,null,null,"Must reduce to 1 open lane"]
["Minutes per day that a queue is present",{"$f":"60*MAX('WZ Analysis (Worksheet)'!AG35,'WZ Analysis (Worksheet)'!AG65,'WZ Analysis (Worksheet)'!AG94,'WZ Analysis (Worksheet)'!AG123,'WZ Analysis (Worksheet)'!AG152,'WZ Analysis (Worksheet)'!AG181,'WZ Analysis (Worksheet)'!AG210,)","v":0},"min",null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"$B23>=Q23","v":false},30,120,1,10,{"$f":"IF($B23<=S23,U23,IF($B23>=T23,V23,U23+(V23-U23)*($B23-S23)/(T23-S23)))","v":1},null,null,null,"A greater number of hours has a greater potential for conflicts and crashes.",null,30,{"$f":"$B23>=AC23","v":false},30,120,2,10,{"$f":"IF($B23<=AE23,AG23,IF($B23>=AF23,AH23,AG23+(AH23-AG23)*($B23-AE23)/(AF23-AE23)))","v":2},null,null,null,"Queue anticipated a minimum of 30 minutes per day. Longer durations increase the need for a TT Advisory system.",null,30,{"$f":"$B23>=AO23","v":false},30,120,2,10,{"$f":"IF($B23<=AQ23,AS23,IF($B23>=AR23,AT23,AS23+(AT23-AS23)*($B23-AQ23)/(AR23-AQ23)))","v":2},null,null,null,"Queue anticipated a minimum of 30 minutes pre day. Longer durations increase the need for a TT Advisory system.",null,30,{"$f":"$B23>=BA23","v":false},30,120,2,10,{"$f":"IF($B23<=BC23,BE23,IF($B23>=BD23,BF23,BE23+(BF23-BE23)*($B23-BC23)/(BD23-BC23)))","v":2},null,null,null,null,null,30,{"$f":"$B23>=BM23","v":false},30,120,1,10,{"$f":"IF($B23<=BO23,BQ23,IF($B23>=BP23,BR23,BQ23+(BR23-BQ23)*($B23-BO23)/(BP23-BO23)))","v":1},null,null,null,"This strategy should be considered when excessive queue durations are present."]
["Maximum Estimated Delay",{"$f":"MAX('WZ Analysis (Worksheet)'!AG26,'WZ Analysis (Worksheet)'!AG57,'WZ Analysis (Worksheet)'!AG115,'WZ Analysis (Worksheet)'!AG144,'WZ Analysis (Worksheet)'!AG173,'WZ Analysis (Worksheet)'!AG202,)","v":0},"min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"$B24>=AC24","v":false},5,25,2,10,{"$f":"IF($B24<=AE24,AG24,IF($B24>=AF24,AH24,AG24+(AH24-AG24)*($B24-AE24)/(AF24-AE24)))","v":2},null,null,null,"Min delay of 5 minutes, and longer delays increase the need for a TT system",null,5,{"$f":"$B24>=AO24","v":false},5,25,2,10,{"$f":"IF($B24<=AQ24,AS24,IF($B24>=AR24,AT24,AS24+(AT24-AS24)*($B24-AQ24)/(AR24-AQ24)))","v":2},null,null,null,"Min delay of 5 minutes, and longer delays increase the need for a TT system",null,5,{"$f":"$B24>=BA24","v":false},5,25,2,10,2,null,null,null,null,null,5,{"$f":"$B24>=BM24","v":false},5,30,1,10,1,null,null,null,"This strategy should be considered when excessive delays are anticipated.",null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"B24>=CK24","v":false},10,30,1,10,{"$f":"IF($B24<=CM24,CO24,IF($B24>=CN24,CP24,CO24+(CP24-CO24)*($B24-CM24)/(CN24-CM24)))","v":1}]
["Estimated Maximum Queue Length",{"$f":"MAX('WZ Analysis (Worksheet)'!AG33,'WZ Analysis (Worksheet)'!AG63,'WZ Analysis (Worksheet)'!AG92,'WZ Analysis (Worksheet)'!AG121,'WZ Analysis (Worksheet)'!AG150,'WZ Analysis (Worksheet)'!AG179,'WZ Analysis (Worksheet)'!AG208)","v":0},"mi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,3,1,10,{"$f":"IF($B25<=AE25,AG25,IF($B25>=AF25,AH25,AG25+(AH25-AG25)*($B25-AE25)/(AF25-AE25)))","v":1},{"$f":"20000","v":20000},null,{"$f":"$B25*AJ25","v":0},"Sensors must be set up to monitor in the queueing area, and portable DMS signs to advise of the travel times.",null,null,null,0.5,3,1,10,{"$f":"IF($B25<=AQ25,AS25,IF($B25>=AR25,AT25,AS25+(AT25-AS25)*($B25-AQ25)/(AR25-AQ25)))","v":1},{"$f":"20000","v":20000},null,{"$f":"$B25*AV25","v":0},"Sensors must be set up to monitor in the queueing area, and portable DMS signs to advise of the travel times.",null,null,null,0.5,3,1,10,1,20000,200,{"$f":"MAX($B25,$B12)*(BH25)+MAX($B25,$B12)*BI25*$B13/7","v":0},"$20,000/mile * max of (queue length and taper length) + $200/mile/week",null,0.5,{"$f":"$B25>=BM25","v":false},0.5,2,1,10,1,null,null,null,"This strategy should be considered when queue lengths are excessively long.",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"B25>=CK25","v":false},0.5,1,1,10,{"$f":"IF($B25<=CM25,CO25,IF($B25>=CN25,CP25,CO25+(CP25-CO25)*($B25-CM25)/(CN25-CM25)))","v":1}]
[]
[]
[]
["Total Points",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K26)","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W4:W26)","v":7},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI4:AI26)","v":13},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AU4:AU26)","v":13},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BG4:BG26)","v":16},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BS4:BS26)","v":13},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CE4:CE26)","v":6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CQ4:CQ26)","v":5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DC4:DC26)","v":6}]
["Total Possible Points",null,null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J26)","v":20},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V4:V26)","v":30},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH4:AH26)","v":60},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AT4:AT26)","v":65},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BF4:BF26)","v":73},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BR4:BR26)","v":50},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CD4:CD26)","v":16},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CP4:CP26)","v":55},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DB4:DB26)","v":15}]
["Normized (total possible = 100)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K29/K30*100,0)","v":15},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(W29/W30*100,0)","v":23},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AI29/AI30*100,0)","v":22},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AU29/AU30*100,0)","v":20},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(BG29/BG30*100,0)","v":22},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(BS29/BS30*100,0)","v":26},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CE29/CE30*100,0)","v":38},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CQ29/CQ30*100,0)","v":9},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(DC29/DC30*100,0)","v":40}]
["Manual Adjustment Points (positive for current initiatives or negative de-emphasized strategies)",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,10]
["Total Final Points (rounded, 100 point max)",null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(K31:K32),0))","v":15},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(W31:W32),0))","v":23},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(AI31:AI32),0))","v":22},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(AU31:AU32),0))","v":20},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(BG31:BG32),0))","v":22},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(BS31:BS32),0))","v":26},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(CE31:CE32),0))","v":38},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(CQ31:CQ32),0))","v":9},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(DC31:DC32),0))","v":50}]
[]
["Strategy Meets Pass/Fail Criteria",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(F4:F26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(R4:R26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD4:AD26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AP4:AP26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BB4:BB26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BN4:BN26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BZ4:BZ26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(CL4:CL26,FALSE),FALSE,TRUE)","v":false},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(CX4:CX26,FALSE),FALSE,TRUE)","v":false}]
["Points",null,null,null,null,null,null,null,null,null,null,null,{"$f":"E1","v":"1. Construction Vehicle Warning System"},{"$f":"K33","v":15},null,null,null,null,null,null,null,null,null,null,{"$f":"Q1","v":"2. Dynamic Late Merge (Zipper Merge) System"},{"$f":"W33","v":23},null,null,null,null,null,null,null,null,null,null,{"$f":"AC1","v":"8. Travel Time Advisory System"},{"$f":"AI33","v":22},null,null,null,null,null,null,null,null,null,null,{"$f":"AO1","v":"9. Travel Time Advisory System with Alternative Route"},{"$f":"AU33","v":20},null,null,null,null,null,null,null,null,null,null,{"$f":"BA1","v":"3. Queue Warning System"},{"$f":"BG33","v":22},null,null,null,null,null,null,null,null,null,null,{"$f":"BM1","v":"4. Road Closure"},{"$f":"BS33","v":26},null,null,null,null,null,null,null,null,null,null,{"$f":"BY1","v":"5. Speed Warning System"},{"$f":"CE33","v":38},null,null,null,null,null,null,null,null,null,null,{"$f":"CK1","v":"7. Temporary Traffic Incident Management and ITS System"},{"$f":"CQ33","v":9},null,null,null,null,null,null,null,null,null,null,{"$f":"CW1","v":"6. Temporary Rumble Strips"},{"$f":"DC33","v":50}]
["Estimated Total Cost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(N4:N26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Z4:Z26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(AL4:AL26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(AX4:AX26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(BJ4:BJ26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(BV4:BV26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(CH4:CH26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(CT4:CT26),-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(DF4:DF26),-3)","v":2000}]

{"sheet":"Acceleration Calcs","index":7,"n_rows":20,"n_cols":43,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,24,0,32],[0,34,0,42],[1,32,2,32],[1,4,1,11],[1,12,2,12],[0,4,0,12],[0,14,0,22],[1,14,1,21],[1,22,2,22],[1,24,1,31],[1,34,1,41],[1,42,2,42]]}
[null,null,null,null,"A+B Bidding",null,null,null,null,null,null,null,null,null,"Liquidated Damages Specified",null,null,null,null,null,null,null,null,null,"Liquidated Savings Specified",null,null,null,null,null,null,null,null,null,"Liquidated Savings / Liquidated Damages Specified"]
[null,null,null,null,"Scoring",null,null,null,null,null,null,null,"Comments",null,"Scoring",null,null,null,null,null,null,null,"Comments",null,"Scoring",null,null,null,null,null,null,null,"Comments",null,"Scoring",null,null,null,null,null,null,null,"Comments"]
["Question / Criteria","Value","Unit",null,"Answer 1","Answer 2","Answer 3","Answer 1 Score","Answer 2 Score","Answer 3 Score","Max","Score",null,null,"Answer 1","Answer 2","Answer 3","Answer 1 Score","Answer 2 Score","Answer 3 Score","Max","Score",null,null,"Answer 1","Answer 2","Answer 3","Answer 1 Score","Answer 2 Score","Answer 3 Score","Max","Score",null,null,"Answer 1","Answer 2","Answer 3","Answer 1 Score","Answer 2 Score","Answer 3 Score","Max","Score"]
[{"$f":"'Step 3b - Acceleration Analysis'!A11","v":"Is the project considered \"routine?\""},{"$f":"'Step 3b - Acceleration Analysis'!C11","v":0},"Y/N",null,"No","Yes",null,0,10,null,{"$f":"MAX(H4:J4)","v":10},{"$f":"IF($B4=E4,H4,IF($B4=F4,I4,IF($B4=G4,J4,\"\")))","v":0},null,null,null,null,null,null,null,null,{"$f":"MAX(R4:T4)","v":0},{"$f":"IF($B4=O4,R4,IF($B4=P4,S4,IF($B4=Q4,T4,\"\")))","v":0},null,null,null,null,null,null,null,null,{"$f":"MAX(AB4:AD4)","v":0},{"$f":"IF($B4=Y4,AB4,IF($B4=Z4,AC4,IF($B4=AA4,AD4,\"\")))","v":0},null,null,null,null,null,null,null,null,{"$f":"MAX(AL4:AN4)","v":0},{"$f":"IF($B4=AI4,AL4,IF($B4=AJ4,AM4,IF($B4=AK4,AN4,\"\")))","v":0}]
[{"$f":"'Step 3b - Acceleration Analysis'!A13","v":"What is the anticipated number of construction seasons?"},{"$f":"'Step 3b - Acceleration Analysis'!C13","v":0},"Seasons",null,"more than one","one or somewhat less than one","much less than one",0,10,10,{"$f":"MAX(H5:J5)","v":10},{"$f":"IF($B5=E5,H5,IF($B5=F5,I5,IF($B5=G5,J5,\"\")))","v":""},null,null,"more than one","one or somewhat less than one","much less than one",0,3,10,{"$f":"MAX(R5:T5)","v":10},{"$f":"IF($B5=O5,R5,IF($B5=P5,S5,IF($B5=Q5,T5,\"\")))","v":""},null,null,"more than one","one or somewhat less than one","much less than one",10,5,0,{"$f":"MAX(AB5:AD5)","v":10},{"$f":"IF($B5=Y5,AB5,IF($B5=Z5,AC5,IF($B5=AA5,AD5,\"\")))","v":""},null,null,"more than one","one or somewhat less than one","much less than one",10,3,10,{"$f":"MAX(AL5:AN5)","v":10},{"$f":"IF($B5=AI5,AL5,IF($B5=AJ5,AM5,IF($B5=AK5,AN5,\"\")))","v":""}]
[{"$f":"'Step 3b - Acceleration Analysis'!A15","v":"Is there is a critical completion date (e.g. to enable future work, or other reasons)?"},{"$f":"'Step 3b - Acceleration Analysis'!C15","v":0},"Y/N",null,null,null,null,null,null,null,0,0,null,null,"No","Yes",null,0,10,null,10,0,null,null,"No","Yes",null,0,10,null,10,0,null,null,"No","Yes",null,0,10,null,10,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A17","v":"Does the work zone for the project or one of its features \ncause unusually high impacts to travelers?"},{"$f":"'Step 3b - Acceleration Analysis'!C17","v":0},"Y/N",null,"No","Yes",null,0,10,null,10,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A19","v":"Does the project include numerous or long detours?"},{"$f":"'Step 3b - Acceleration Analysis'!C19","v":0},"Y/N",null,null,null,null,null,null,null,0,0,null,null,"No","Yes",null,0,10,null,10,0,null,null,"No","Yes",null,0,10,null,10,0,null,null,"No","Yes",null,0,10,null,10,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A21","v":"Are there unusually high safety concerns for the public or workers?"},{"$f":"'Step 3b - Acceleration Analysis'!C21","v":0},"Y/N",null,"No","Yes",null,0,10,null,10,0,null,null,"No","Yes",null,0,10,null,10,0,null,null,null,null,null,null,null,null,0,0,null,null,"No","Yes",null,0,10,null,10,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A23","v":"Will the project cause significant impacts to the local community or business economies?"},{"$f":"'Step 3b - Acceleration Analysis'!C23","v":0},"Y/N",null,"No","Yes",null,0,10,null,10,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A25","v":"Is the project is substantially free of third party conflicts (e.g. right of way, utilities)?"},{"$f":"'Step 3b - Acceleration Analysis'!C25","v":0},"Y/N",null,"No","Yes",null,0,10,null,10,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[{"$f":"'Step 3b - Acceleration Analysis'!A27","v":"Are more than two bidders anticipated?"},{"$f":"'Step 3b - Acceleration Analysis'!C27","v":0},"Y/N",null,"No","Yes",null,0,10,null,10,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
["Total Points",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4:L13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(V4:V13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF4:AF13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP4:AP13)","v":0}]
["Total Possible Points",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K13)","v":70},null,null,null,null,null,null,null,null,null,{"$f":"SUM(U4:U13)","v":40},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE4:AE13)","v":30},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO4:AO13)","v":40}]
["Normized (total possible = 100)",null,null,null,null,null,null,null,null,{"$f":"E1","v":"A+B Bidding"},null,{"$f":"ROUND(L16/L17*100,0)","v":0},null,null,null,null,null,null,null,{"$f":"O1","v":"Liquidated Damages Specified"},null,{"$f":"ROUND(V16/V17*100,0)","v":0},null,null,null,null,null,null,null,{"$f":"Y1","v":"Liquidated Savings Specified"},null,{"$f":"ROUND(AF16/AF17*100,0)","v":0},null,null,null,null,null,null,null,{"$f":"AI1","v":"Liquidated Savings / Liquidated Damages Specified"},null,{"$f":"ROUND(AP16/AP17*100,0)","v":0}]
["Manual Adjustment Points (positive for current initiatives or negative de-emphasized strategies)",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
["Total Final Points (rounded, 100 point max)",null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(L18:L19),0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(V18:V19),0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(AF18:AF19),0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"MIN(100,ROUND(SUM(AP18:AP19),0))","v":0}]

{"sheet":"Step 1 - Introduction","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,8,11,8],[33,0,33,2],[33,4,33,6],[0,2,0,6],[25,0,25,1],[24,0,24,1],[7,6,11,6],[24,2,24,8]]}
[null,null,"MoDOT WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
["Revised: 4/14/26"]
[]
["Remember to ENABLE CONTENT so the macros inside the excel sheet can run."]
[]
["Select Volume Input Method using the BUTTONS below."]
[]
[null,null,null,null,null,null,"Include\nAdvanced\nWork Zone\nStrategies",null,"Include Contract Time Acceleration Strategies"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Yes",null,"Yes"]
[]
[]
["Use the TABS to navigate through the spreadsheet after selecting Input Method."]
[]
["Enter information into the HIGHLIGHTED cells."]
["BLUE","cells indicate information needed regarding the Base Conditions"]
["ORANGE","cells indicate information needed regarding the Work Zone"]
["YELLOW","cells are optional inputs.  Leave these BLANK if you want to use the spreadsheets defaults."]
["GREEN","cells are based on imported TSHV data"]
[]
["The following links will provide additional details regarding the speadsheet."]
["Engineering Policy Guide:",null,"https://epg.modot.org/index.php?title=616.19_Work_Zone_Capacity,_Queue_and_Travel_Delay"]
["Spreadsheet Instructions:",null,"616.13.2_Directions"]
[]
["This speadsheet was developed by MoDOT Central Office Traffic and Highway Safety Division and the University of Missouri - Columbia"]
[]
["Direct any questions regarding this spreadsheet to:"]
[]
["Ray Shank",null,null,null,"Dan Smith"]
["(573) 526-4293",null,"or",null,"(573) 526-4329"]
["Raymond.Shank@modot.mo.gov",null,null,null,"Daniel.Smith@modot.mo.gov"]

{"sheet":"Step 2 - Facility Data Inputs","index":9,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":true,"merged":[[16,9,16,10],[0,3,0,10],[48,2,48,3],[24,0,24,3],[21,0,21,3],[7,0,7,2],[8,0,8,2],[12,0,12,2],[14,0,14,2],[13,0,13,2],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[38,2,38,3],[39,2,39,3],[37,2,37,3],[49,0,49,2],[25,1,36,1],[37,1,48,1],[25,0,48,0],[40,2,40,3],[41,2,41,3],[42,2,42,3],[29,2,29,3],[28,2,28,3],[18,0,18,5],[17,0,17,5],[20,0,20,10],[25,2,25,3],[36,2,36,3],[35,2,35,3],[34,2,34,3],[33,2,33,3],[32,2,32,3],[31,2,31,3],[30,2,30,3],[27,2,27,3],[26,2,26,3],[23,0,23,3],[22,0,22,3],[3,0,3,4],[3,6,3,7],[8,7,8,10],[7,7,7,10],[8,4,8,5],[7,4,7,5]]}
[null,null,null,"WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
["UserInput"]
["ANALYST:",null,null,null,null,null,"DATE OF ANALYSIS:",null,null,"JOB NUMBER:"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2026-05-27"}]
[]
["BACKGROUND INFORMATION"]
[]
["DISTRICT:",null,null,null,"ROUTE (DIRECTION):",null,null,"LOCATION SEGMENT (LOGS):"]
[]
[]
["EXISTING ROADWAY DATA"]
[]
["NUMBER OF",null,null,null,"DAILY TRUCK",null,"CLIMBING",null,"LENGTH OF"]
["LANES:",null,null,null,"PERCENTAGE (%):",null,"GRADE (%):",null,"INCLINE GRADE (mi):"]
[2,null,null,null,0.05,null,"< 2",null,1]
[null,null,null,null,{"$f":"HLOOKUP(IF(E15<0.02,0.02,E15),'HCM 2010 Program'!D34:O35,2)","v":4},null,{"$f":"VLOOKUP(G15,'Reference Sheet'!X2:Y7,2)","v":0},null,{"$f":"IF(G16=0,1,IF(I15<0.5,1,IF(I15<=1,2,3)))","v":1}]
["TRAFFIC VOLUME DATA: Obtained from TMS Traffic Segment Hourly Volume (TSHV) Application",null,null,null,null,null,null,null,null,"USER COST ( $ / hr )"]
["Link to Transportation Management System (TMS)",null,null,null,null,null,null,null,null,"TRUCKS ",34.9]
["Link to Directions on how to use the TSHV table.",null,null,null,null,null,null,null,null,"CARS",13.65]
[]
["DEMAND (veh/hr)"]
["Day of Week",null,null,null,{"$f":"IF(E25=\"\",\"Sunday\",TEXT(E25,\"dddd\"))","v":"Sunday"},{"$f":"IF(F25=\"\",\"Monday\",TEXT(F25,\"dddd\"))","v":"Monday"},{"$f":"IF(G25=\"\",\"Tuesday\",TEXT(G25,\"dddd\"))","v":"Tuesday"},{"$f":"IF(H25=\"\",\"Wednesday\",TEXT(H25,\"dddd\"))","v":"Wednesday"},{"$f":"IF(I25=\"\",\"Thursday\",TEXT(I25,\"dddd\"))","v":"Thursday"},{"$f":"IF(J25=\"\",\"Friday\",TEXT(J25,\"dddd\"))","v":"Friday"},{"$f":"IF(K25=\"\",\"Saturday\",TEXT(K25,\"dddd\"))","v":"Saturday"}]
["Text Date",null,null,null,{"$f":"IF(E25=\"\",\"\",TEXT(E25,\"m/d/yyyy\"))","v":""},{"$f":"IF(F25=\"\",\"\",TEXT(F25,\"m/d/yyyy\"))","v":""},{"$f":"IF(G25=\"\",\"\",TEXT(G25,\"m/d/yyyy\"))","v":""},"","","",""]
["Graph Below Labels",null,null,null,{"$f":"IF(E25=\"\",E22,CONCATENATE(TEXT(E25,\"ddd\"),\" (\",TEXT(E25,\"m/d/yyyy\"),\")\"))","v":"Sunday"},{"$f":"IF(F25=\"\",F22,CONCATENATE(TEXT(F25,\"ddd\"),\" (\",TEXT(F25,\"m/d/yyyy\"),\")\"))","v":"Monday"},"Tuesday","Wednesday","Thursday","Friday","Saturday"]
["Date of Count"]
["Time of Day","AM","12:00 MIDNIGHT - 1 AM"]
[null,null,"1:00 - 2:00 AM"]
[null,null,"2:00 - 3:00 AM"]
[null,null,"3:00 - 4:00 AM"]
[null,null,"4:00 - 5:00 AM"]
[null,null,"5:00 - 6:00 AM"]
[null,null,"6:00 - 7:00 AM"]
[null,null,"7:00 - 8:00 AM"]
[null,null,"8:00 - 9:00 AM"]
[null,null,"9:00 - 10:00 AM"]
[null,null,"10:00 - 11:00 AM"]
[null,null,"11:00 - 12:00 NOON"]
[null,"PM","12 NOON - 1:00 PM"]
[null,null,"1:00 - 2:00 PM"]
[null,null,"2:00 - 3:00 PM"]
[null,null,"3:00 - 4:00 PM"]
[null,null,"4:00 - 5:00 PM"]
[null,null,"5:00 - 6:00 PM"]
[null,null,"6:00 - 7:00 PM"]
[null,null,"7:00 - 8:00 PM"]
[null,null,"8:00 - 9:00 PM"]
[null,null,"9:00 - 10:00 PM"]
[null,null,"10:00 - 11:00 PM"]
[null,null,"11 PM - 12:00 MIDNIGHT"]
["TOTAL ADT",null,null,null,{"$f":"SUM(E26:E49)","v":0},{"$f":"SUM(F26:F49)","v":0},0,0,0,0,0]
[null,null,null,"Unserviced Demand ->",0,0,0,0,0,0,0]

{"sheet":"Step 3 - WZ Analysis","index":10,"n_rows":156,"n_cols":7,"rows_kept":156,"cut":false,"hidden":true,"merged":[[136,0,156,0],[138,4,138,5],[141,3,141,5],[142,3,142,5],[143,3,143,5],[144,3,144,5],[145,3,145,5],[147,3,147,5],[148,3,148,5],[149,3,149,5],[139,3,139,5],[140,3,140,5],[114,0,134,0],[116,4,116,5],[119,3,119,5],[120,3,120,5],[121,3,121,5],[122,3,122,5],[123,3,123,5],[125,3,125,5],[126,3,126,5],[127,3,127,5],[117,3,117,5],[118,3,118,5],[92,0,112,0],[94,4,94,5],[97,3,97,5],[98,3,98,5],[99,3,99,5],[100,3,100,5],[101,3,101,5],[103,3,103,5],[104,3,104,5],[105,3,105,5],[95,3,95,5],[96,3,96,5],[70,0,90,0],[72,4,72,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[79,3,79,5],[81,3,81,5],[82,3,82,5],[83,3,83,5],[48,0,68,0],[50,4,50,5],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[4,0,24,0],[6,4,6,5],[0,0,0,13],[9,3,9,5],[26,0,46,0],[28,4,28,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,3,35,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[10,3,10,5],[17,3,17,5],[7,3,7,5],[8,3,8,5],[29,3,29,5],[16,3,16,5],[15,3,15,5],[13,3,13,5],[12,3,12,5],[11,3,11,5],[30,3,30,5],[51,3,51,5],[52,3,52,5],[73,3,73,5],[74,3,74,5]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!E22,\"(\",TEXT('Step 2 - Facility Data Inputs'!E23,\"m/d/yy\"),\")\")","v":"Sunday()"},{"$f":"'Step 2 - Facility Data Inputs'!E25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F22, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G8,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K21","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G9,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F29","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D11='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G32='WZ Analysis (Worksheet)'!G31,24,IF('WZ Analysis (Worksheet)'!G32>'WZ Analysis (Worksheet)'!G31,'WZ Analysis (Worksheet)'!G32-'WZ Analysis (Worksheet)'!G31,24-('WZ Analysis (Worksheet)'!G31-'WZ Analysis (Worksheet)'!G32))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!P46","v":0},{"$f":"'WZ Analysis (Worksheet)'!AA46","v":0},{"$f":"'WZ Analysis (Worksheet)'!W46","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!Q46","v":0},{"$f":"'WZ Analysis (Worksheet)'!AB46","v":0},{"$f":"'WZ Analysis (Worksheet)'!X46","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!R47","v":0},{"$f":"'WZ Analysis (Worksheet)'!AD47","v":0},{"$f":"'WZ Analysis (Worksheet)'!Y47","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!F22,\" (\",TEXT('Step 2 - Facility Data Inputs'!F23,\"m/d/yy\"),\")\")","v":"Monday ()"},{"$f":"'Step 2 - Facility Data Inputs'!F25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F51, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G30,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K50","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G31,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F58","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D33='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G61='WZ Analysis (Worksheet)'!G60,24,IF('WZ Analysis (Worksheet)'!G61>'WZ Analysis (Worksheet)'!G60,'WZ Analysis (Worksheet)'!G61-'WZ Analysis (Worksheet)'!G60,24-('WZ Analysis (Worksheet)'!G60-'WZ Analysis (Worksheet)'!G61))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!P75","v":0},{"$f":"'WZ Analysis (Worksheet)'!AA75","v":0},{"$f":"'WZ Analysis (Worksheet)'!W75","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!Q75","v":0},{"$f":"'WZ Analysis (Worksheet)'!AB75","v":0},{"$f":"'WZ Analysis (Worksheet)'!X75","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!R76","v":0},{"$f":"'WZ Analysis (Worksheet)'!AD76","v":0},{"$f":"'WZ Analysis (Worksheet)'!Y76","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!G22,\" (\",TEXT('Step 2 - Facility Data Inputs'!G23,\"m/d/yy\"),\")\")","v":"Tuesday ()"},{"$f":"'Step 2 - Facility Data Inputs'!G25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F80, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G52,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K79","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G53,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F87","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D55='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G89='WZ Analysis (Worksheet)'!G90,24,IF('WZ Analysis (Worksheet)'!G90>'WZ Analysis (Worksheet)'!G89,'WZ Analysis (Worksheet)'!G90-'WZ Analysis (Worksheet)'!G89,24-('WZ Analysis (Worksheet)'!G89-'WZ Analysis (Worksheet)'!G90))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!D95","v":0},{"$f":"'WZ Analysis (Worksheet)'!E95","v":0},{"$f":"'WZ Analysis (Worksheet)'!F95","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!D96","v":0},{"$f":"'WZ Analysis (Worksheet)'!E96","v":0},{"$f":"'WZ Analysis (Worksheet)'!F96","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!D97","v":0},{"$f":"'WZ Analysis (Worksheet)'!E97","v":0},{"$f":"'WZ Analysis (Worksheet)'!F97","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!H22,\" (\",TEXT('Step 2 - Facility Data Inputs'!H23,\"m/d/yy\"),\")\")","v":"Wednesday ()"},{"$f":"'Step 2 - Facility Data Inputs'!H25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F109, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G74,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K108","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G75,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F116","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D77='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G118='WZ Analysis (Worksheet)'!G119,24,IF('WZ Analysis (Worksheet)'!G119>'WZ Analysis (Worksheet)'!G118,'WZ Analysis (Worksheet)'!G119-'WZ Analysis (Worksheet)'!G118,24-('WZ Analysis (Worksheet)'!G118-'WZ Analysis (Worksheet)'!G119))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!P133","v":0},{"$f":"'WZ Analysis (Worksheet)'!AA133","v":0},{"$f":"'WZ Analysis (Worksheet)'!W133","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!Q133","v":0},{"$f":"'WZ Analysis (Worksheet)'!AB133","v":0},{"$f":"'WZ Analysis (Worksheet)'!X133","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!R134","v":0},{"$f":"'WZ Analysis (Worksheet)'!AD134","v":0},{"$f":"'WZ Analysis (Worksheet)'!Y134","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!I22,\" (\",TEXT('Step 2 - Facility Data Inputs'!I23,\"m/d/yy\"),\")\")","v":"Thursday ()"},{"$f":"'Step 2 - Facility Data Inputs'!I25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F138, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G96,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K137","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G97,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F145","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D99='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G147='WZ Analysis (Worksheet)'!G148,24,IF('WZ Analysis (Worksheet)'!G148>'WZ Analysis (Worksheet)'!G147,'WZ Analysis (Worksheet)'!G148-'WZ Analysis (Worksheet)'!G147,24-('WZ Analysis (Worksheet)'!G147-'WZ Analysis (Worksheet)'!G148))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!D153","v":0},{"$f":"'WZ Analysis (Worksheet)'!E153","v":0},{"$f":"'WZ Analysis (Worksheet)'!F153","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!D154","v":0},{"$f":"'WZ Analysis (Worksheet)'!E154","v":0},{"$f":"'WZ Analysis (Worksheet)'!F154","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!D155","v":0},{"$f":"'WZ Analysis (Worksheet)'!E155","v":0},{"$f":"'WZ Analysis (Worksheet)'!F155","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!J22,\" (\",TEXT('Step 2 - Facility Data Inputs'!J23,\"m/d/yy\"),\")\")","v":"Friday ()"},{"$f":"'Step 2 - Facility Data Inputs'!J25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F167, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G118,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K166","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G119,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F174","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D121='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G176='WZ Analysis (Worksheet)'!G177,24,IF('WZ Analysis (Worksheet)'!G177>'WZ Analysis (Worksheet)'!G176,'WZ Analysis (Worksheet)'!G177-'WZ Analysis (Worksheet)'!G176,24-('WZ Analysis (Worksheet)'!G176-'WZ Analysis (Worksheet)'!G177))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!D182","v":0},{"$f":"'WZ Analysis (Worksheet)'!E182","v":0},{"$f":"'WZ Analysis (Worksheet)'!F182","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!D183","v":0},{"$f":"'WZ Analysis (Worksheet)'!E183","v":0},{"$f":"'WZ Analysis (Worksheet)'!F183","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!D184","v":0},{"$f":"'WZ Analysis (Worksheet)'!E184","v":0},{"$f":"'WZ Analysis (Worksheet)'!F184","v":0}]
[]
[]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!K22,\" (\",TEXT('Step 2 - Facility Data Inputs'!K23,\"m/d/yy\"),\")\")","v":"Saturday ()"},{"$f":"'Step 2 - Facility Data Inputs'!K25","v":0}]
[null,null,"BASE CONDITIONS"]
[null,null,"Open Lane Capacity (veh/h/lane):",{"$f":"MROUND(2350/((1-'HCM 2010 Program'!$E$3)+('HCM 2010 Program'!$E$3*'HCM 2010 Program'!$F$3)),50)","v":2300},{"$f":"CONCATENATE(\"Base Conditions Capacity\n(Total for ALL Lanes): \",'WZ Analysis (Worksheet)'!F196, \" veh/h\")","v":"Base Conditions Capacity\n(Total for ALL Lanes): 4600 veh/h"}]
[null,null,null,{"$f":"CONCATENATE(\"Added \",TEXT(G140,\"#,###\"),\" unserved vehicles from previous day.\")","v":"Added  unserved vehicles from previous day."},null,null,{"$f":"'WZ Analysis (Worksheet)'!K195","v":0}]
[null,null,"WORKZONE DETAILS",{"$f":"CONCATENATE(TEXT(G141,\"#,###\"),\" unserved vehicles at the end of this day.\")","v":" unserved vehicles at the end of this day."},null,null,0]
[null,null,"Work Description:","(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)"]
[null,null,"Work Location:","No Work Zone (Use for Calibrating Existing Conditions)"]
[null,null,"Travel Lane Width (ft):","> 11.5"]
[null,null,"Number of Lanes Open:",1]
[null,null,"ESTIMATED Work Zone Capacity (veh/h):",{"$f":"'WZ Analysis (Worksheet)'!F203","v":2300}]
[null,null,"USER DEFINED Work Zone Capacity (veh/h):"]
[null,null,"Start Time:","00:00:00"]
[null,null,"End Time:","00:00:00"]
[null,null,"Duration of Closure (hrs):",{"$f":"IF(D143='Reference Sheet'!$R$2,0,IF('WZ Analysis (Worksheet)'!G205='WZ Analysis (Worksheet)'!G206,24,IF('WZ Analysis (Worksheet)'!G206>'WZ Analysis (Worksheet)'!G205,'WZ Analysis (Worksheet)'!G206-'WZ Analysis (Worksheet)'!G205,24-('WZ Analysis (Worksheet)'!G205-'WZ Analysis (Worksheet)'!G206))))","v":0}]
[]
[null,null,"RESULTS"]
[null,null,"Measure of Effectiveness","Base Conditions","Work Zone","Total"]
[null,null,"Max Queue Length (mi):",{"$f":"'WZ Analysis (Worksheet)'!D211","v":0},{"$f":"'WZ Analysis (Worksheet)'!E211","v":0},{"$f":"'WZ Analysis (Worksheet)'!F211","v":0}]
[null,null,"Max Delay (minutes):",{"$f":"'WZ Analysis (Worksheet)'!D212","v":0},{"$f":"'WZ Analysis (Worksheet)'!E212","v":0},{"$f":"'WZ Analysis (Worksheet)'!F212","v":0}]
[null,null,"Cost ($):",{"$f":"'WZ Analysis (Worksheet)'!D213","v":0},{"$f":"'WZ Analysis (Worksheet)'!E213","v":0},{"$f":"'WZ Analysis (Worksheet)'!F213","v":0}]

{"sheet":"Step 3a - ADV WZ Analysis","index":11,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,0,0,5],[7,0,7,3],[23,0,23,3]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[]
[]
["Additional Questions for Advanced Work Zone Strategy Recommendation"]
[]
["Additional Existing Facility Information"]
[]
["Facility Speed Limit (mph)"]
[]
["Are traffic patterns inconsistent from day to day? (e.g. unpredictible with \nsubstantial variability or impacts from random local traffic genertors)"]
[]
["Is the work zone on a route with an existing ITS Travel Time System?"]
[]
["Are one or more alternative routes with capacity available?"]
[]
["If yes, what is the approximate length of the existing alternative routes (mi)?"]
[]
["If yes, do the alternatative routes have existing ITS Travel Time capability?"]
[]
[]
[]
["Additional Work Zone and Project Inputs"]
[]
["Work Zone Speed Limit (mph)"]
[]
["Total approximate work zone length (mi)"]
[]
["Total approximate taper length leading up to work zone (mi)"]
[]
["Number of days the work zone will be in place"]
[]
["Will proposed lane closures persist (e.g. not be set up and taken down frequently)?"]
[]
["Number of access points where low speed construction vehicles will enter the \nwork zone without an adequate dedicated acceleration lane"]
[]
["Will sight distance be limited on the approach to the work zone?"]
[]
["Are queue lengths anticipated to extend past an upstream intersection or interchange?"]
[]
["Are there external merging conflicts or hazards on the approach to or within the work zone?"]
[]
["Will the work zone have navigating contrstraints that inhibit emergency responder access?"]
[]
["Total estimate project cost without smart workzone strategies ($)"]

{"sheet":"Step 3b - Acceleration Analysis","index":12,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,5],[8,0,8,3]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[]
[]
["Contract Time Acceleration Considerations"]
[]
[]
["The following questions can apply to the project as a whole, or to specific features or phases*"]
[]
["Is the project considered \"routine?\""]
[]
["What is the anticipated number of construction seasons?"]
[]
["Is there is a critical completion date (e.g. to enable future work, or other reasons)?"]
[]
["Does the work zone for the project or one of its features \ncause unusually high impacts to travelers?"]
[]
["Does the project include numerous or long detours?"]
[]
["Are there unusually high safety concerns for the public or workers?"]
[]
["Will the project cause significant impacts to the local community or business economies?"]
[]
["Is the project is substantially free of third party conflicts (e.g. right of way, utilities)?"]
[]
["Are more than two bidders anticipated?"]
[]
[]
[]
["* Questions adapted from EPG Section 237.8"]

{"sheet":"Step 4 - Synopsis Sheet","index":13,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":true,"merged":[[0,0,0,13],[24,1,24,2],[31,1,31,2],[38,1,38,2],[45,1,45,2],[3,0,8,0],[10,0,15,0],[17,0,22,0],[24,0,29,0],[31,0,36,0],[38,0,43,0],[45,0,50,0],[3,1,3,2],[10,1,10,2],[17,1,17,2]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!E22,\" (\",TEXT('Step 2 - Facility Data Inputs'!E23,\"m/d/yy\"),\") \",B4)","v":"Sunday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!E22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!E23,\"m/d/yy\"),\")\")","v":"Sunday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D10=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D11='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D11),'Step 3 - WZ Analysis'!D10)","v":"No Work Zone"}]
[null,{"$f":"'Step 3 - WZ Analysis'!C22","v":"Max Queue Length (mi):"},{"$f":"'Step 3 - WZ Analysis'!F22","v":0}]
[null,{"$f":"'Step 3 - WZ Analysis'!C23","v":"Max Delay (minutes):"},{"$f":"'Step 3 - WZ Analysis'!F23","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E24","v":0}]
[null,{"$f":"'Step 3 - WZ Analysis'!C16","v":"Start Time:"},{"$f":"IF(C9=0,\"N/A\",'Step 3 - WZ Analysis'!D16)","v":"N/A"}]
[null,{"$f":"'Step 3 - WZ Analysis'!C18","v":"Duration of Closure (hrs):"},{"$f":"'Step 3 - WZ Analysis'!D18","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!F22,\" (\",TEXT('Step 2 - Facility Data Inputs'!F23,\"m/d/yy\"),\") \",B11)","v":"Monday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!F22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!F23,\"m/d/yy\"),\")\")","v":"Monday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D32=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D33='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D33),'Step 3 - WZ Analysis'!D32)","v":"No Work Zone"}]
[null,{"$f":"'Step 3 - WZ Analysis'!C44","v":"Max Queue Length (mi):"},{"$f":"'Step 3 - WZ Analysis'!F44","v":0}]
[null,{"$f":"'Step 3 - WZ Analysis'!C45","v":"Max Delay (minutes):"},{"$f":"'Step 3 - WZ Analysis'!F45","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E46","v":0}]
[null,{"$f":"'Step 3 - WZ Analysis'!C38","v":"Start Time:"},{"$f":"IF(C16=0,\"N/A\",'Step 3 - WZ Analysis'!D38)","v":"N/A"}]
[null,{"$f":"'Step 3 - WZ Analysis'!C40","v":"Duration of Closure (hrs):"},{"$f":"'Step 3 - WZ Analysis'!D40","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!G$22,\" (\",TEXT('Step 2 - Facility Data Inputs'!G$23,\"m/d/yy\"),\") \",B18)","v":"Tuesday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!G22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!G23,\"m/d/yy\"),\")\")","v":"Tuesday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D54=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D55='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D55),'Step 3 - WZ Analysis'!D54)","v":"No Work Zone"}]
[null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!F66","v":0}]
[null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!F67","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E68","v":0}]
[null,"Start Time:",{"$f":"IF(C23=0,\"N/A\",'Step 3 - WZ Analysis'!D60)","v":"N/A"}]
[null,"Duration of Closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D62","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!H$22,\" (\",TEXT('Step 2 - Facility Data Inputs'!H$23,\"m/d/yy\"),\") \",B25)","v":"Wednesday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!H22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!H23,\"m/d/yy\"),\")\")","v":"Wednesday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D76=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D77='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D77),'Step 3 - WZ Analysis'!D76)","v":"No Work Zone"}]
[null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!F88","v":0}]
[null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!F89","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E90","v":0}]
[null,"Start Time:",{"$f":"IF(C30=0,\"N/A\",'Step 3 - WZ Analysis'!D82)","v":"N/A"}]
[null,"Duration of Closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D84","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!I$22,\" (\",TEXT('Step 2 - Facility Data Inputs'!I$23,\"m/d/yy\"),\") \",B32)","v":"Thursday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!I22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!I23,\"m/d/yy\"),\")\")","v":"Thursday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D98=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D99='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D99),'Step 3 - WZ Analysis'!D98)","v":"No Work Zone"}]
[null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!F110","v":0}]
[null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!F111","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E112","v":0}]
[null,"Start Time:",{"$f":"IF(C37=0,\"N/A\",'Step 3 - WZ Analysis'!D104)","v":"N/A"}]
[null,"Duration of Closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D106","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!J$22,\" (\",TEXT('Step 2 - Facility Data Inputs'!J$23,\"m/d/yy\"),\") \",B39)","v":"Friday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!J22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!J23,\"m/d/yy\"),\")\")","v":"Friday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D120=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D121='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D121),'Step 3 - WZ Analysis'!D120)","v":"No Work Zone"}]
[null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!F132","v":0}]
[null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!F133","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E134","v":0}]
[null,"Start Time:",{"$f":"IF(C44=0,\"N/A\",'Step 3 - WZ Analysis'!D126)","v":"N/A"}]
[null,"Duration of Closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D128","v":0}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!K$22,\" (\",TEXT('Step 2 - Facility Data Inputs'!K$23,\"m/d/yy\"),\") \",B46)","v":"Saturday () No Work Zone"}]
[{"$f":"CONCATENATE('Step 2 - Facility Data Inputs'!K22,\"\n(\",TEXT('Step 2 - Facility Data Inputs'!K23,\"m/d/yy\"),\")\")","v":"Saturday\n()"},{"$f":"IF('Step 3 - WZ Analysis'!D142=\"(Example: Pothole Patching - Close One Lane OR Joint Repair - Two Lanes Closed)\",IF('Step 3 - WZ Analysis'!D143='Reference Sheet'!$R$2,\"No Work Zone\",'Step 3 - WZ Analysis'!D143),'Step 3 - WZ Analysis'!D142)","v":"No Work Zone"}]
[null,"Max Queue Length (mi):",{"$f":"'Step 3 - WZ Analysis'!F154","v":0}]
[null,"Max Delay (minutes):",{"$f":"'Step 3 - WZ Analysis'!F155","v":0}]
[null,"Total User Costs - Work Zone ($)",{"$f":"'Step 3 - WZ Analysis'!E156","v":0}]
[null,"Start Time:",{"$f":"IF(C51=0,\"N/A\",'Step 3 - WZ Analysis'!D148)","v":"N/A"}]
[null,"Duration of Closure (hrs):",{"$f":"'Step 3 - WZ Analysis'!D150","v":0}]

{"sheet":"Step 4a - ADV WZ Synopsis","index":14,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,10],[19,5,19,7],[4,1,4,4]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[]
["Advanced Work Zone Strategy Analysis"]
[null,"From SWZ Calc Sheet"]
["Advanced Work Zone Strategy","Applicable","Base Points","Manual Adjustment","Cost","Score*","Rank","Recommendation","Budgetary Estimate"]
[{"$f":"'ADV WZ Calcs'!M36","v":"1. Construction Vehicle Warning System"},{"$f":"'ADV WZ Calcs'!N35","v":false},{"$f":"'ADV WZ Calcs'!K31","v":15},{"$f":"'ADV WZ Calcs'!K32","v":0},{"$f":"'ADV WZ Calcs'!N37","v":0},{"$f":"IF(B7,IF(SUM(C7:D7)>99,100,SUM(C7:D7)),0)","v":0},{"$f":"IF(B7,RANK(F7,$F$7:$F$15,0),\"-\")","v":"-"},{"$f":"VLOOKUP(F7,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B7,E7,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!Y36","v":"2. Dynamic Late Merge (Zipper Merge) System"},{"$f":"'ADV WZ Calcs'!Z35","v":false},{"$f":"'ADV WZ Calcs'!W31","v":23},{"$f":"'ADV WZ Calcs'!W32","v":0},{"$f":"'ADV WZ Calcs'!Z37","v":0},{"$f":"IF(B8,IF(SUM(C8:D8)>99,100,SUM(C8:D8)),0)","v":0},"-","Not Applicable",{"$f":"IF(B8,E8,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!BI36","v":"3. Queue Warning System"},{"$f":"'ADV WZ Calcs'!BJ35","v":false},{"$f":"'ADV WZ Calcs'!BG31","v":22},{"$f":"'ADV WZ Calcs'!BG32","v":0},{"$f":"'ADV WZ Calcs'!BJ37","v":0},0,"-","Not Applicable",0]
[{"$f":"'ADV WZ Calcs'!BU36","v":"4. Road Closure"},{"$f":"'ADV WZ Calcs'!BV35","v":false},{"$f":"'ADV WZ Calcs'!BS31","v":26},{"$f":"'ADV WZ Calcs'!BS32","v":0},{"$f":"'ADV WZ Calcs'!BV37","v":0},{"$f":"IF(B10,IF(SUM(C10:D10)>99,100,SUM(C10:D10)),0)","v":0},"-",{"$f":"VLOOKUP(F10,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B10,E10,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!CG36","v":"5. Speed Warning System"},{"$f":"'ADV WZ Calcs'!CH35","v":false},{"$f":"'ADV WZ Calcs'!CE31","v":38},{"$f":"'ADV WZ Calcs'!CE32","v":0},{"$f":"'ADV WZ Calcs'!CH37","v":0},0,"-",{"$f":"VLOOKUP(F11,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B11,E11,0)","v":0},"**"]
[{"$f":"'ADV WZ Calcs'!CW1","v":"6. Temporary Rumble Strips"},{"$f":"'ADV WZ Calcs'!DF35","v":false},{"$f":"'ADV WZ Calcs'!DC31","v":40},{"$f":"'ADV WZ Calcs'!DC32","v":10},{"$f":"'ADV WZ Calcs'!DF37","v":2000},0,"-",{"$f":"VLOOKUP(F12,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B12,E12,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!CS36","v":"7. Temporary Traffic Incident Management and ITS System"},{"$f":"'ADV WZ Calcs'!CT35","v":false},{"$f":"'ADV WZ Calcs'!CQ31","v":9},{"$f":"'ADV WZ Calcs'!CQ32","v":0},{"$f":"'ADV WZ Calcs'!CT37","v":0},0,"-",{"$f":"VLOOKUP(F13,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B13,E13,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!AK36","v":"8. Travel Time Advisory System"},{"$f":"'ADV WZ Calcs'!AL35","v":false},{"$f":"'ADV WZ Calcs'!AI31","v":22},{"$f":"'ADV WZ Calcs'!AI32","v":0},{"$f":"'ADV WZ Calcs'!AL37","v":0},0,"-",{"$f":"VLOOKUP(F14,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B14,E14,0)","v":0}]
[{"$f":"'ADV WZ Calcs'!AW36","v":"9. Travel Time Advisory System with Alternative Route"},{"$f":"'ADV WZ Calcs'!AX35","v":false},{"$f":"'ADV WZ Calcs'!AU31","v":20},{"$f":"'ADV WZ Calcs'!AU32","v":0},{"$f":"'ADV WZ Calcs'!AX37","v":0},0,"-",{"$f":"VLOOKUP(F15,$F$22:$H$25,3)","v":"Not Applicable"},{"$f":"IF(B15,E15,0)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"Scoring Criteria"]
[null,null,null,null,null,"From","<= To","Recommendation"]
[null,null,null,null,null,0,1,"Not Applicable"]
[null,null,null,null,null,1,30,"Not Recommended"]
[null,null,null,null,null,30,70,"Should be Considered"]
[null,null,null,null,null,70,100,"Strongly Recommended"]
[]
[]
[]
[]
[]
["* Scores in blue include a manual score adjustment to reflect current initiatives or to de-emphaisize specific initiatives."]
["** Speed trailer cost assumes contractor-provided trailers"]

{"sheet":"Step 4b - Acceleration Synopsis","index":15,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,7],[4,1,4,2],[14,3,14,5]]}
["              WORK ZONE IMPACT ANALYSIS SPREADSHEET"]
[{"$f":"CONCATENATE(\"District: \",'Step 2 - Facility Data Inputs'!A9,\"      Route: \",'Step 2 - Facility Data Inputs'!E9,\" (\",'Step 2 - Facility Data Inputs'!H9,\")\",\"      Job No.: \",'Step 2 - Facility Data Inputs'!J4)","v":"District:       Route:  ()      Job No.: "}]
[]
["Contract Time Acceleration Synopsis*"]
[null,"From Acceleration Calcs"]
["Contract Time Acceleration Strategy","Base Points","Manual Adjustment","Score**","Rank","Recommendation"]
[{"$f":"'Acceleration Calcs'!J18","v":"A+B Bidding"},{"$f":"'Acceleration Calcs'!L18","v":0},{"$f":"'Acceleration Calcs'!L19","v":0},{"$f":"MIN(SUM(B7:C7),100)","v":0},{"$f":"RANK(D7,$D$7:$D$10,0)","v":1},{"$f":"VLOOKUP(D7,$D$17:$F$20,3)","v":"Not Applicable"}]
[{"$f":"'Acceleration Calcs'!T18","v":"Liquidated Damages Specified"},{"$f":"'Acceleration Calcs'!V18","v":0},{"$f":"'Acceleration Calcs'!V19","v":0},{"$f":"MIN(SUM(B8:C8),100)","v":0},{"$f":"RANK(D8,$D$7:$D$10,0)","v":1},{"$f":"VLOOKUP(D8,$D$17:$F$20,3)","v":"Not Applicable"}]
[{"$f":"'Acceleration Calcs'!AD18","v":"Liquidated Savings Specified"},{"$f":"'Acceleration Calcs'!AF18","v":0},{"$f":"'Acceleration Calcs'!AF19","v":0},0,1,{"$f":"VLOOKUP(D9,$D$17:$F$20,3)","v":"Not Applicable"}]
[{"$f":"'Acceleration Calcs'!AN18","v":"Liquidated Savings / Liquidated Damages Specified"},{"$f":"'Acceleration Calcs'!AP18","v":0},{"$f":"'Acceleration Calcs'!AP19","v":0},0,1,{"$f":"VLOOKUP(D10,$D$17:$F$20,3)","v":"Not Applicable"}]
[]
[]
[]
[]
[null,null,null,"Scoring Criteria"]
[null,null,null,"From","<= To","Recommendation"]
[null,null,null,0,1,"Not Applicable"]
[null,null,null,1,30,"Not Recommended"]
[null,null,null,30,70,"Should be Considered"]
[null,null,null,70,100,"Strongly Recommended"]
[]
[]
[]
[]
["* See EPG Section 237.8 for more detail."]
["** Scores in blue include a manual score adjustment to reflect current initiatives or to de-emphaisize specific initiatives."]