{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Summary","Data","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"Summary!PayItemFile","v":"N:\\CFL-DPIT\\Excel\\payitems24.csv"}]
[null,"Instructions"]
[null,1,"On the Summary Tab, click the \"Browse for Pay Item\" button, hit the \"Browse for Pay Item File\" in the dialog box and browse to N:\\CFL-DPIT\\Excel\\PayItems14.csv and select \"Open\" or if you downloaded the file off the network browse to the location to where it was saved."]
[null,null,"Click the \"Return to Excel\" button."]
[]
[null,2,"On the Summary Tab, click the \"Add/Remove Pay Items\" button."]
[null,null,"Pay items are broken out by pay item categories.  Choose the desired pay item category."]
[null,null,"Select the desired pay item and select \"Add Item\".  Repeat for all required pay items."]
[null,null,"To remove pay items click the \"Delete a pay item already placed in sheet\" button and select the desired pay item and click the \"delete item\" button.  Click the \"Close\" button to close the dialog box."]
[null,null,"When all desired pay items have been added click the \"Close\" button."]
[]
[null,3,"Add station,side, MUTCD reference, quantities and road classification.  If a special sign description is needed click on the Data tab and add description and sign size.  Add and remove schedules to tables using the buttons at the top of the Summary tab.  Hide and unhide rows to tables using the buttons at the top of the Summary tab.  Merge and center title over the entire table width."]
[]
[null,4,"Using the Engineer's Estimate Manual (https://highways.dot.gov/federal-lands/estimates/cfl-estimate-manual), determine the correct rounding % and round up values for each item."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The Bid schedule and allowance quantities will be automatically calculated at the bottom but should not be included in tabulation sheets."]
[null,5,"DO NOT MANUALLY ADD ANY COLUMNS TO THE SPREADSHEET."]

{"sheet":"Summary","index":1,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":false,"merged":[[6,3,8,3],[6,7,8,7],[2,12,2,15],[6,2,8,2],[6,12,7,12],[6,8,7,8],[5,9,7,9],[5,3,5,7],[6,6,8,6],[6,4,8,4],[4,3,4,7],[6,5,7,5],[113,0,113,2],[108,0,108,2],[103,0,103,2],[39,2,39,7],[101,2,101,7],[70,2,70,7]]}
[null,null,null,null,null,null,null,"N:\\CFL-DPIT\\Excel\\payitems24.csv"]
[null,null,null,null,null,null,null,null,"Leave this column HIDDEN!!! Do not delete",null,null,null,null,"Leave this column HIDDEN!!! Do not delete"]
["Check Column - do not delete",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(I2,Data!$A:$C,2,FALSE)),\"\",VLOOKUP(I2,Data!$A:$C,2,FALSE))","v":""},null,null,null,"Do not manually add columns to the spreadsheet.  The macro will become inoperable if columns are added to the left of the quantity column."]
[]
[null,null,null,"CONSTRUCTION SIGN SUMMARY",null,null,null,null,null,null,null,null,"*Remember to Merge and Center the Title over the entire table"]
[null,null,null,"Item Number",null,null,null,null,{"$f":"I2","v":"Leave this column HIDDEN!!! Do not delete"},"Remarks",null,null,null,{"$f":"N2","v":"Leave this column HIDDEN!!! Do not delete"}]
[null,null,"Schedule","MUTCD Reference","Description","Sign Panel","Area","Quantity",{"$f":"IF(ISBLANK(I2),\"\",LOOKUP(I2,'[1]FP24 Pay Items'!$B$1:$B$65536,'[1]FP24 Pay Items'!$E$1:$E$65536))","v":"FUNDING RECLASSIFICATION"},null,null,null,"Road Classification\n(Conventional Road, Freeway or Expressway, Minimum)\nSee Tables 6G-1/6H-1 in the MUTCD"]
[]
[null,null,null,null,null,"in x in",null,null,{"$f":"IF(ISBLANK(I2),\"\",LOOKUP(I2,'[1]FP24 Pay Items'!$B$1:$B$65536,'[1]FP24 Pay Items'!$F$1:$F$65536))","v":"LPSM"}]
[]
[null,null,null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP($D11,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D11=\"\",\"\",HLOOKUP($M11,Data!$I$2:$M$199,MATCH($D11,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D11=\"\",\"\",HLOOKUP($N11,Data!$N$2:$P$199,MATCH($D11,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(M11=\"Conventional Road\",\"Conventional Road2\",IF(M11=\"Freeway or Expressway\",\"Freeway or Expressway3\",IF(M11=\"Minimum\",\"Minimum4\",\"\")))","v":""}]
[null,null,null,null,{"$f":"IF(D12=\"\",\"\",VLOOKUP($D12,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D12=\"\",\"\",HLOOKUP($M12,Data!$I$2:$M$199,MATCH($D12,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D12=\"\",\"\",HLOOKUP($N12,Data!$N$2:$P$199,MATCH($D12,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(M12=\"Conventional Road\",\"Conventional Road2\",IF(M12=\"Freeway or Expressway\",\"Freeway or Expressway3\",IF(M12=\"Minimum\",\"Minimum4\",\"\")))","v":""}]
[null,null,null,null,{"$f":"IF(D13=\"\",\"\",VLOOKUP($D13,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D13=\"\",\"\",HLOOKUP($M13,Data!$I$2:$M$199,MATCH($D13,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D13=\"\",\"\",HLOOKUP($N13,Data!$N$2:$P$199,MATCH($D13,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D14=\"\",\"\",VLOOKUP($D14,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D14=\"\",\"\",HLOOKUP($M14,Data!$I$2:$M$199,MATCH($D14,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D14=\"\",\"\",HLOOKUP($N14,Data!$N$2:$P$199,MATCH($D14,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP($D15,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",HLOOKUP($M15,Data!$I$2:$M$199,MATCH($D15,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",HLOOKUP($N15,Data!$N$2:$P$199,MATCH($D15,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP($D16,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D16=\"\",\"\",HLOOKUP($M16,Data!$I$2:$M$199,MATCH($D16,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D16=\"\",\"\",HLOOKUP($N16,Data!$N$2:$P$199,MATCH($D16,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP($D17,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D17=\"\",\"\",HLOOKUP($M17,Data!$I$2:$M$199,MATCH($D17,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D17=\"\",\"\",HLOOKUP($N17,Data!$N$2:$P$199,MATCH($D17,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D18=\"\",\"\",VLOOKUP($D18,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D18=\"\",\"\",HLOOKUP($M18,Data!$I$2:$M$199,MATCH($D18,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D18=\"\",\"\",HLOOKUP($N18,Data!$N$2:$P$199,MATCH($D18,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP($D19,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",HLOOKUP($M19,Data!$I$2:$M$199,MATCH($D19,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",HLOOKUP($N19,Data!$N$2:$P$199,MATCH($D19,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP($D20,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D20=\"\",\"\",HLOOKUP($M20,Data!$I$2:$M$199,MATCH($D20,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D20=\"\",\"\",HLOOKUP($N20,Data!$N$2:$P$199,MATCH($D20,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP($D21,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",HLOOKUP($M21,Data!$I$2:$M$199,MATCH($D21,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",HLOOKUP($N21,Data!$N$2:$P$199,MATCH($D21,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP($D22,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",HLOOKUP($M22,Data!$I$2:$M$199,MATCH($D22,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",HLOOKUP($N22,Data!$N$2:$P$199,MATCH($D22,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP($D23,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",HLOOKUP($M23,Data!$I$2:$M$199,MATCH($D23,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",HLOOKUP($N23,Data!$N$2:$P$199,MATCH($D23,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP($D24,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",HLOOKUP($M24,Data!$I$2:$M$199,MATCH($D24,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",HLOOKUP($N24,Data!$N$2:$P$199,MATCH($D24,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP($D25,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",HLOOKUP($M25,Data!$I$2:$M$199,MATCH($D25,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",HLOOKUP($N25,Data!$N$2:$P$199,MATCH($D25,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP($D26,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",HLOOKUP($M26,Data!$I$2:$M$199,MATCH($D26,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",HLOOKUP($N26,Data!$N$2:$P$199,MATCH($D26,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP($D27,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",HLOOKUP($M27,Data!$I$2:$M$199,MATCH($D27,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",HLOOKUP($N27,Data!$N$2:$P$199,MATCH($D27,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP($D28,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D28=\"\",\"\",HLOOKUP($M28,Data!$I$2:$M$199,MATCH($D28,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D28=\"\",\"\",HLOOKUP($N28,Data!$N$2:$P$199,MATCH($D28,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP($D29,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D29=\"\",\"\",HLOOKUP($M29,Data!$I$2:$M$199,MATCH($D29,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D29=\"\",\"\",HLOOKUP($N29,Data!$N$2:$P$199,MATCH($D29,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP($D30,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",HLOOKUP($M30,Data!$I$2:$M$199,MATCH($D30,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",HLOOKUP($N30,Data!$N$2:$P$199,MATCH($D30,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP($D31,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D31=\"\",\"\",HLOOKUP($M31,Data!$I$2:$M$199,MATCH($D31,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D31=\"\",\"\",HLOOKUP($N31,Data!$N$2:$P$199,MATCH($D31,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP($D32,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D32=\"\",\"\",HLOOKUP($M32,Data!$I$2:$M$199,MATCH($D32,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D32=\"\",\"\",HLOOKUP($N32,Data!$N$2:$P$199,MATCH($D32,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP($D33,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D33=\"\",\"\",HLOOKUP($M33,Data!$I$2:$M$199,MATCH($D33,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D33=\"\",\"\",HLOOKUP($N33,Data!$N$2:$P$199,MATCH($D33,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D34=\"\",\"\",VLOOKUP($D34,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D34=\"\",\"\",HLOOKUP($M34,Data!$I$2:$M$199,MATCH($D34,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D34=\"\",\"\",HLOOKUP($N34,Data!$N$2:$P$199,MATCH($D34,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D35=\"\",\"\",VLOOKUP($D35,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D35=\"\",\"\",HLOOKUP($M35,Data!$I$2:$M$199,MATCH($D35,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D35=\"\",\"\",HLOOKUP($N35,Data!$N$2:$P$199,MATCH($D35,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D36=\"\",\"\",VLOOKUP($D36,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D36=\"\",\"\",HLOOKUP($M36,Data!$I$2:$M$199,MATCH($D36,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D36=\"\",\"\",HLOOKUP($N36,Data!$N$2:$P$199,MATCH($D36,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D37=\"\",\"\",VLOOKUP($D37,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D37=\"\",\"\",HLOOKUP($M37,Data!$I$2:$M$199,MATCH($D37,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D37=\"\",\"\",HLOOKUP($N37,Data!$N$2:$P$199,MATCH($D37,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D38=\"\",\"\",VLOOKUP($D38,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D38=\"\",\"\",HLOOKUP($M38,Data!$I$2:$M$199,MATCH($D38,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D38=\"\",\"\",HLOOKUP($N38,Data!$N$2:$P$199,MATCH($D38,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(AND(Data!$D$2=1,Data!$G$2=1),\"TOTAL\",IF(AND(Data!$D$2=1,Data!$G$2>1),\"SCHEDULE A TOTAL\",IF(AND(Data!$D$2>1,Data!$G$2=1),\"TOTALS\",IF(AND(Data!$D$2=2,Data!$G$2>=2),\"SCHEDULE A TOTALS\"))))","v":false},null,null,null,null,null,{"$f":"IF(I$9=\"LPSM\",\"ALL\",SUM(I$10:I$39))","v":"ALL"},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D42=\"\",\"\",VLOOKUP($D42,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D42=\"\",\"\",HLOOKUP($M42,Data!$I$2:$M$199,MATCH($D42,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D42=\"\",\"\",HLOOKUP($N42,Data!$N$2:$P$199,MATCH($D42,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D43=\"\",\"\",VLOOKUP($D43,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D43=\"\",\"\",HLOOKUP($M43,Data!$I$2:$M$199,MATCH($D43,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D43=\"\",\"\",HLOOKUP($N43,Data!$N$2:$P$199,MATCH($D43,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D44=\"\",\"\",VLOOKUP($D44,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D44=\"\",\"\",HLOOKUP($M44,Data!$I$2:$M$199,MATCH($D44,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D44=\"\",\"\",HLOOKUP($N44,Data!$N$2:$P$199,MATCH($D44,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP($D45,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",HLOOKUP($M45,Data!$I$2:$M$199,MATCH($D45,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",HLOOKUP($N45,Data!$N$2:$P$199,MATCH($D45,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D46=\"\",\"\",VLOOKUP($D46,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D46=\"\",\"\",HLOOKUP($M46,Data!$I$2:$M$199,MATCH($D46,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D46=\"\",\"\",HLOOKUP($N46,Data!$N$2:$P$199,MATCH($D46,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D47=\"\",\"\",VLOOKUP($D47,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D47=\"\",\"\",HLOOKUP($M47,Data!$I$2:$M$199,MATCH($D47,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D47=\"\",\"\",HLOOKUP($N47,Data!$N$2:$P$199,MATCH($D47,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D48=\"\",\"\",VLOOKUP($D48,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D48=\"\",\"\",HLOOKUP($M48,Data!$I$2:$M$199,MATCH($D48,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D48=\"\",\"\",HLOOKUP($N48,Data!$N$2:$P$199,MATCH($D48,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D49=\"\",\"\",VLOOKUP($D49,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D49=\"\",\"\",HLOOKUP($M49,Data!$I$2:$M$199,MATCH($D49,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D49=\"\",\"\",HLOOKUP($N49,Data!$N$2:$P$199,MATCH($D49,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D50=\"\",\"\",VLOOKUP($D50,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D50=\"\",\"\",HLOOKUP($M50,Data!$I$2:$M$199,MATCH($D50,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D50=\"\",\"\",HLOOKUP($N50,Data!$N$2:$P$199,MATCH($D50,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D51=\"\",\"\",VLOOKUP($D51,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D51=\"\",\"\",HLOOKUP($M51,Data!$I$2:$M$199,MATCH($D51,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D51=\"\",\"\",HLOOKUP($N51,Data!$N$2:$P$199,MATCH($D51,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D52=\"\",\"\",VLOOKUP($D52,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D52=\"\",\"\",HLOOKUP($M52,Data!$I$2:$M$199,MATCH($D52,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D52=\"\",\"\",HLOOKUP($N52,Data!$N$2:$P$199,MATCH($D52,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D53=\"\",\"\",VLOOKUP($D53,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D53=\"\",\"\",HLOOKUP($M53,Data!$I$2:$M$199,MATCH($D53,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D53=\"\",\"\",HLOOKUP($N53,Data!$N$2:$P$199,MATCH($D53,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D54=\"\",\"\",VLOOKUP($D54,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D54=\"\",\"\",HLOOKUP($M54,Data!$I$2:$M$199,MATCH($D54,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D54=\"\",\"\",HLOOKUP($N54,Data!$N$2:$P$199,MATCH($D54,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D55=\"\",\"\",VLOOKUP($D55,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D55=\"\",\"\",HLOOKUP($M55,Data!$I$2:$M$199,MATCH($D55,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D55=\"\",\"\",HLOOKUP($N55,Data!$N$2:$P$199,MATCH($D55,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D56=\"\",\"\",VLOOKUP($D56,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D56=\"\",\"\",HLOOKUP($M56,Data!$I$2:$M$199,MATCH($D56,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D56=\"\",\"\",HLOOKUP($N56,Data!$N$2:$P$199,MATCH($D56,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D57=\"\",\"\",VLOOKUP($D57,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D57=\"\",\"\",HLOOKUP($M57,Data!$I$2:$M$199,MATCH($D57,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D57=\"\",\"\",HLOOKUP($N57,Data!$N$2:$P$199,MATCH($D57,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D58=\"\",\"\",VLOOKUP($D58,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D58=\"\",\"\",HLOOKUP($M58,Data!$I$2:$M$199,MATCH($D58,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D58=\"\",\"\",HLOOKUP($N58,Data!$N$2:$P$199,MATCH($D58,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D59=\"\",\"\",VLOOKUP($D59,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D59=\"\",\"\",HLOOKUP($M59,Data!$I$2:$M$199,MATCH($D59,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D59=\"\",\"\",HLOOKUP($N59,Data!$N$2:$P$199,MATCH($D59,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D60=\"\",\"\",VLOOKUP($D60,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D60=\"\",\"\",HLOOKUP($M60,Data!$I$2:$M$199,MATCH($D60,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D60=\"\",\"\",HLOOKUP($N60,Data!$N$2:$P$199,MATCH($D60,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D61=\"\",\"\",VLOOKUP($D61,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D61=\"\",\"\",HLOOKUP($M61,Data!$I$2:$M$199,MATCH($D61,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D61=\"\",\"\",HLOOKUP($N61,Data!$N$2:$P$199,MATCH($D61,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D62=\"\",\"\",VLOOKUP($D62,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D62=\"\",\"\",HLOOKUP($M62,Data!$I$2:$M$199,MATCH($D62,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D62=\"\",\"\",HLOOKUP($N62,Data!$N$2:$P$199,MATCH($D62,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D63=\"\",\"\",VLOOKUP($D63,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D63=\"\",\"\",HLOOKUP($M63,Data!$I$2:$M$199,MATCH($D63,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D63=\"\",\"\",HLOOKUP($N63,Data!$N$2:$P$199,MATCH($D63,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D64=\"\",\"\",VLOOKUP($D64,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D64=\"\",\"\",HLOOKUP($M64,Data!$I$2:$M$199,MATCH($D64,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D64=\"\",\"\",HLOOKUP($N64,Data!$N$2:$P$199,MATCH($D64,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D65=\"\",\"\",VLOOKUP($D65,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D65=\"\",\"\",HLOOKUP($M65,Data!$I$2:$M$199,MATCH($D65,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D65=\"\",\"\",HLOOKUP($N65,Data!$N$2:$P$199,MATCH($D65,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D66=\"\",\"\",VLOOKUP($D66,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D66=\"\",\"\",HLOOKUP($M66,Data!$I$2:$M$199,MATCH($D66,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D66=\"\",\"\",HLOOKUP($N66,Data!$N$2:$P$199,MATCH($D66,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D67=\"\",\"\",VLOOKUP($D67,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D67=\"\",\"\",HLOOKUP($M67,Data!$I$2:$M$199,MATCH($D67,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D67=\"\",\"\",HLOOKUP($N67,Data!$N$2:$P$199,MATCH($D67,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D68=\"\",\"\",VLOOKUP($D68,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D68=\"\",\"\",HLOOKUP($M68,Data!$I$2:$M$199,MATCH($D68,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D68=\"\",\"\",HLOOKUP($N68,Data!$N$2:$P$199,MATCH($D68,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D69=\"\",\"\",VLOOKUP($D69,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D69=\"\",\"\",HLOOKUP($M69,Data!$I$2:$M$199,MATCH($D69,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D69=\"\",\"\",HLOOKUP($N69,Data!$N$2:$P$199,MATCH($D69,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(AND(Data!$D$2=1,Data!$G$2=1),\"TOTAL\",IF(AND(Data!$D$2=1,Data!$G$2>1),\"SCHEDULE B TOTAL\",IF(AND(Data!$D$2>1,Data!$G$2=1),\"TOTALS\",IF(AND(Data!$D$2=2,Data!$G$2>=2),\"SCHEDULE B TOTALS\"))))","v":false},null,null,null,null,null,{"$f":"IF(I$9=\"LPSM\",\"ALL\",SUM(I$41:I$70)+I$40)","v":"ALL"},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D73=\"\",\"\",VLOOKUP($D73,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D73=\"\",\"\",HLOOKUP($M73,Data!$I$2:$M$199,MATCH($D73,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D73=\"\",\"\",HLOOKUP($N73,Data!$N$2:$P$199,MATCH($D73,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D74=\"\",\"\",VLOOKUP($D74,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D74=\"\",\"\",HLOOKUP($M74,Data!$I$2:$M$199,MATCH($D74,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D74=\"\",\"\",HLOOKUP($N74,Data!$N$2:$P$199,MATCH($D74,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D75=\"\",\"\",VLOOKUP($D75,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D75=\"\",\"\",HLOOKUP($M75,Data!$I$2:$M$199,MATCH($D75,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D75=\"\",\"\",HLOOKUP($N75,Data!$N$2:$P$199,MATCH($D75,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D76=\"\",\"\",VLOOKUP($D76,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D76=\"\",\"\",HLOOKUP($M76,Data!$I$2:$M$199,MATCH($D76,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D76=\"\",\"\",HLOOKUP($N76,Data!$N$2:$P$199,MATCH($D76,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(M76=\"Conventional Road\",\"Conventional Road2\",IF(M76=\"Freeway or Expressway\",\"Freeway or Expressway3\",IF(M76=\"Minimum\",\"Minimum4\",\"\")))","v":""}]
[null,null,null,null,{"$f":"IF(D77=\"\",\"\",VLOOKUP($D77,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D77=\"\",\"\",HLOOKUP($M77,Data!$I$2:$M$199,MATCH($D77,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D77=\"\",\"\",HLOOKUP($N77,Data!$N$2:$P$199,MATCH($D77,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D78=\"\",\"\",VLOOKUP($D78,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D78=\"\",\"\",HLOOKUP($M78,Data!$I$2:$M$199,MATCH($D78,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D78=\"\",\"\",HLOOKUP($N78,Data!$N$2:$P$199,MATCH($D78,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D79=\"\",\"\",VLOOKUP($D79,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D79=\"\",\"\",HLOOKUP($M79,Data!$I$2:$M$199,MATCH($D79,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D79=\"\",\"\",HLOOKUP($N79,Data!$N$2:$P$199,MATCH($D79,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D80=\"\",\"\",VLOOKUP($D80,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D80=\"\",\"\",HLOOKUP($M80,Data!$I$2:$M$199,MATCH($D80,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D80=\"\",\"\",HLOOKUP($N80,Data!$N$2:$P$199,MATCH($D80,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D81=\"\",\"\",VLOOKUP($D81,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D81=\"\",\"\",HLOOKUP($M81,Data!$I$2:$M$199,MATCH($D81,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D81=\"\",\"\",HLOOKUP($N81,Data!$N$2:$P$199,MATCH($D81,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D82=\"\",\"\",VLOOKUP($D82,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D82=\"\",\"\",HLOOKUP($M82,Data!$I$2:$M$199,MATCH($D82,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D82=\"\",\"\",HLOOKUP($N82,Data!$N$2:$P$199,MATCH($D82,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D83=\"\",\"\",VLOOKUP($D83,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D83=\"\",\"\",HLOOKUP($M83,Data!$I$2:$M$199,MATCH($D83,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D83=\"\",\"\",HLOOKUP($N83,Data!$N$2:$P$199,MATCH($D83,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D84=\"\",\"\",VLOOKUP($D84,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D84=\"\",\"\",HLOOKUP($M84,Data!$I$2:$M$199,MATCH($D84,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D84=\"\",\"\",HLOOKUP($N84,Data!$N$2:$P$199,MATCH($D84,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D85=\"\",\"\",VLOOKUP($D85,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D85=\"\",\"\",HLOOKUP($M85,Data!$I$2:$M$199,MATCH($D85,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D85=\"\",\"\",HLOOKUP($N85,Data!$N$2:$P$199,MATCH($D85,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D86=\"\",\"\",VLOOKUP($D86,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D86=\"\",\"\",HLOOKUP($M86,Data!$I$2:$M$199,MATCH($D86,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D86=\"\",\"\",HLOOKUP($N86,Data!$N$2:$P$199,MATCH($D86,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D87=\"\",\"\",VLOOKUP($D87,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D87=\"\",\"\",HLOOKUP($M87,Data!$I$2:$M$199,MATCH($D87,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D87=\"\",\"\",HLOOKUP($N87,Data!$N$2:$P$199,MATCH($D87,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D88=\"\",\"\",VLOOKUP($D88,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D88=\"\",\"\",HLOOKUP($M88,Data!$I$2:$M$199,MATCH($D88,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D88=\"\",\"\",HLOOKUP($N88,Data!$N$2:$P$199,MATCH($D88,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D89=\"\",\"\",VLOOKUP($D89,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D89=\"\",\"\",HLOOKUP($M89,Data!$I$2:$M$199,MATCH($D89,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D89=\"\",\"\",HLOOKUP($N89,Data!$N$2:$P$199,MATCH($D89,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D90=\"\",\"\",VLOOKUP($D90,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D90=\"\",\"\",HLOOKUP($M90,Data!$I$2:$M$199,MATCH($D90,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D90=\"\",\"\",HLOOKUP($N90,Data!$N$2:$P$199,MATCH($D90,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D91=\"\",\"\",VLOOKUP($D91,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D91=\"\",\"\",HLOOKUP($M91,Data!$I$2:$M$199,MATCH($D91,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D91=\"\",\"\",HLOOKUP($N91,Data!$N$2:$P$199,MATCH($D91,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D92=\"\",\"\",VLOOKUP($D92,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D92=\"\",\"\",HLOOKUP($M92,Data!$I$2:$M$199,MATCH($D92,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D92=\"\",\"\",HLOOKUP($N92,Data!$N$2:$P$199,MATCH($D92,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D93=\"\",\"\",VLOOKUP($D93,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D93=\"\",\"\",HLOOKUP($M93,Data!$I$2:$M$199,MATCH($D93,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D93=\"\",\"\",HLOOKUP($N93,Data!$N$2:$P$199,MATCH($D93,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D94=\"\",\"\",VLOOKUP($D94,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D94=\"\",\"\",HLOOKUP($M94,Data!$I$2:$M$199,MATCH($D94,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D94=\"\",\"\",HLOOKUP($N94,Data!$N$2:$P$199,MATCH($D94,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D95=\"\",\"\",VLOOKUP($D95,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D95=\"\",\"\",HLOOKUP($M95,Data!$I$2:$M$199,MATCH($D95,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D95=\"\",\"\",HLOOKUP($N95,Data!$N$2:$P$199,MATCH($D95,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D96=\"\",\"\",VLOOKUP($D96,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D96=\"\",\"\",HLOOKUP($M96,Data!$I$2:$M$199,MATCH($D96,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D96=\"\",\"\",HLOOKUP($N96,Data!$N$2:$P$199,MATCH($D96,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D97=\"\",\"\",VLOOKUP($D97,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D97=\"\",\"\",HLOOKUP($M97,Data!$I$2:$M$199,MATCH($D97,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D97=\"\",\"\",HLOOKUP($N97,Data!$N$2:$P$199,MATCH($D97,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D98=\"\",\"\",VLOOKUP($D98,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D98=\"\",\"\",HLOOKUP($M98,Data!$I$2:$M$199,MATCH($D98,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D98=\"\",\"\",HLOOKUP($N98,Data!$N$2:$P$199,MATCH($D98,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D99=\"\",\"\",VLOOKUP($D99,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D99=\"\",\"\",HLOOKUP($M99,Data!$I$2:$M$199,MATCH($D99,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D99=\"\",\"\",HLOOKUP($N99,Data!$N$2:$P$199,MATCH($D99,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D100=\"\",\"\",VLOOKUP($D100,Data!I:J,2,FALSE))","v":""},{"$f":"IF(D100=\"\",\"\",HLOOKUP($M100,Data!$I$2:$M$199,MATCH($D100,Data!$I$2:$I$199,0),FALSE))","v":""},{"$f":"IF(D100=\"\",\"\",HLOOKUP($N100,Data!$N$2:$P$199,MATCH($D100,Data!$I$2:$I$199,0),FALSE))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(AND(Data!$D$2=1,Data!$G$2=1),\"TOTAL\",IF(AND(Data!$D$2=1,Data!$G$2>1),\"SCHEDULE C TOTAL\",IF(AND(Data!$D$2>1,Data!$G$2=1),\"TOTALS\",IF(AND(Data!$D$2=2,Data!$G$2>=2),\"SCHEDULE C TOTALS\"))))","v":false},null,null,null,null,null,{"$f":"IF(I$9=\"LPSM\",\"ALL\",SUM(I$72:I$101)+I$71)","v":"ALL"},null,null,null,null,""]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\"Schedule A\",IF(Data!$G$2=3,\"Schedule A\")))","v":" "},null,null,"Rounding %"]
[null,null,null,"Round up"]
[null,null,null,"Bid Schedule",null,null,null,null,{"$f":"IF(I$9=\"each\",I$40,IF(I$9=\"LPSM\",\"LPSM\",IF(I$105=0,ROUND((I$40*(1+I$104)),0),CEILING(I$40*(1+I$104),I$105))))","v":"LPSM"}]
[null,null,null,"Allowance",null,null,null,null,{"$f":"IF(I$9=\"LPSM\",\"--\",I$106-I$40)","v":"--"}]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\"Schedule B\",IF(Data!$G$2=3,\"Schedule B\")))","v":" "},null,null,{"$f":"IF(Data!$G$2=1, \"\", \"Rounding %\")","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Round up\")","v":" "}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Bid Schedule\")","v":" "},null,null,null,null,{"$f":"IF(Data!$G$2=1,\"\",IF(I$9=\"each\",I$71,IF(I$9=\"LPSM\",\"LPSM\",IF(I$110=0,ROUND((I$71*(1+I$109)),0),CEILING(I$71*(1+I$109),I$110)))))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", \"Allowance\")","v":" "},null,null,null,null,{"$f":"IF(Data!$G$2=1,\"\",IF(I$9=\"LPSM\",\"--\",I$111-I$71))","v":""}]
[]
[{"$f":"IF(Data!$G$2=1,\" \",IF(Data!$G$2=2,\" \",IF(Data!$G$2=3,\"Schedule C\")))","v":" "},null,null,{"$f":"IF(Data!$G$2=1, \"\", IF(Data!$G$2=2, \"\", \"Rounding %\"))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Round up\"))","v":" "}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Bid Schedule\"))","v":" "},null,null,null,null,{"$f":"IF(Data!$G$2<3,\"\",IF(I$9=\"each\",I$102,IF(I$9=\"LPSM\",\"LPSM\",IF(I$115=0,ROUND((I$102*(1+I$114)),0),CEILING(I$102*(1+I$114),I$115)))))","v":""}]
[null,null,null,{"$f":"IF(Data!$G$2=1, \" \", IF(Data!$G$2=2, \"\", \"Allowance\"))","v":" "},null,null,null,null,{"$f":"IF(Data!$G$2<3,\"\",IF(I$9=\"LPSM\",\"--\",I$116-I$102))","v":""}]

{"sheet":"Data","index":2,"n_rows":199,"n_cols":28,"rows_kept":199,"cut":false,"hidden":false,"merged":[[0,10,0,12],[0,16,0,19],[0,20,0,22]]}
["Pay Item Number","Description","Unit","Num Items",null,"Sides","Schedules",null,null,null,"Sign Sizes",null,null,"Area",null,null,"Conventional",null,null,null,"Freeway",null,null,null,"Minimum"]
[null,null,null,{"$f":"COUNTA(A:A)-1","v":0},null,"RT",1,null,"Sign","Description","Conventional Road","Freeway or Expressway","Minimum","Conventional Road2","Freeway or Expressway3","Minimum2","a_c","b_c","c_c","s_c","a_f","b_f","c_f","s_f","a_m","b_m","c_m","s_m"]
[null,null,null,null,null,"LT",null,null,"Special 1",null,null,null,null,{"$f":"LEFT(K3,2)*(RIGHT(K3,2)/144)","v":{"$error":"#VALUE!"}},{"$f":"LEFT(L3,2)*(RIGHT(L3,2)/144)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":""},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":""},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,"LT/RT",null,null,"Special 2",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SQRT(AB4*(AB4-Y4)*(AB4-Z4)*(AB4-AA4))","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":""},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":""},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":""},88]
[null,null,null,null,null,null,null,null,"Special 3",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":""},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":""},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":""},88]
[null,null,null,null,null,null,null,null,"Special 4",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":""},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":""},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":""},88]
[null,null,null,null,null,null,null,null,"Special 5",null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":""},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":""},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":""},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":""},88]
[null,null,null,null,null,null,null,null,"G20-1","Road Work Next XX Miles","36 x 18","48 x 24","—",{"$f":"LEFT(K8,2)*(RIGHT(K8,2)/144)","v":4.5},{"$f":"LEFT(L8,2)*(RIGHT(L8,2)/144)","v":8},"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":48},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"G20-2","End Road Work","36 x 18","48 x 24","—",{"$f":"LEFT(K9,2)*(RIGHT(K9,2)/144)","v":4.5},8,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":48},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"G20-4","Pilot Car Follow Me","36 x 18","—","—",4.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"G20-5aP","Work Zone (plaque)","24 x 18","36 x 24","—",3,6,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"E5-2","Exit Open","48 x 36","48 x 36","—",12,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"E5-2a","Exit Closed","48 x 36","48 x 36","—",12,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"E5-3","Exit Only","48 x 36","48 x 36","—",12,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-8","Detour","24 x 12","30 x 15","—",2,3.125,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"15"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"15"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":30},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-8a","End Detour","24 x 18","24 x 18","—",3,3,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"18"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":30},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-8b","End","24 x 12","24 x 12","—",2,2,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"12"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":24},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-9","Detour","30 x 24","48 x 36","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-9a","Bike/Pedestrian Detour","30 x 24","—","—",5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-9b","Pedestrian Detour","30 x 24","—","—",5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-9c","Bike Detour","30 x 24","—","—",5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"M4-10","Detour","48 x 18","—","—",6,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R1-1","Stop","30 x 30","—","—",6.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R1-1","Stop (on Stop/Slow Paddle)","18 x 18","—","—",2.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R1-2","Yield","36 x 36 x 36","—","30 x 30 x 30",{"$f":"SQRT(T25*(T25-Q25)*(T25-R25)*(T25-S25))","v":561.18446165231626},"—",{"$f":"SQRT(AB25*(AB25-Y25)*(AB25-Z25)*(AB25-AA25))","v":389.7114317029974},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_c]]+Table1[[#This Row],[b_c]]+Table1[[#This Row],[c_c]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Minimum]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"(Z25+AA25+Y25)/2","v":45}]
[null,null,null,null,null,null,null,null,"R1-2aP","To Oncoming Traffic (plaque)","36 x 30","48 x 36","24 x 18",7.5,12,{"$f":"LEFT(M26,2)*(RIGHT(M26,2)/144)","v":3},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"18"},88]
[null,null,null,null,null,null,null,null,"R1-7","Wait on Stop","24 x 30","24 x 30","—",5,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R1-7a","Wait on Stop - Go on Slow","30 x 36","30 x 25","—",7.5,5.208333333333333,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"25"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"25"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":40},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R1-8","Go on Slow","24 x 30","24 x 30","—",5,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-1","Speed Limit","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-6P","Fines Higher (plaque)","24 x 18","36 x 24","—",3,6,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-6aP","Fines Double (plaque)","24 x 18","36 x 24","—",3,6,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-6bP","$ Fine (plaque)","24 x 18","36 x 24","—",3,6,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-10","Begin Higher Fines Zone","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R2-11","End Higher Fines Zone","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,null,null,null,"R2-12","End Work Zone Speed Limit","24 x 36","36 x 54","—",6,13.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"54"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"54"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-1","No Right Turn","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-2","No Left Turn","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-3","No Turns","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-4","No U Turn","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-5L","Left Turn Only","30 x 36","—","—",7.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-5R","Right Turn Only","30 x 36","—","—",7.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-6","Optional Movement Lane Control","30 x 36","—","—",7.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-7L","Left Lane Must Turn Left","30 x 30","—","—",6.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-7R","Right Lane Must Turn Right","30 x 30","—","—",6.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-8","Advance Intersection Lane Control","30 x 30","—","—",6.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-18","No Left or U Turn","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R3-27","No Straight","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R4-1","Do Not Pass","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R4-2","Pass With Care","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R4-7","Keep Right","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R4-7c","Narrow Keep Right","18 x 30","—","—",3.75,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R4-9","Stay in Lane","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R5-1","Do Not Enter","30 x 30","36 x 36","—",6.25,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R5-1a","Wrong Way","36 x 24","42 x 30","—",6,8.75,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"42"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":51},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R6-1","One Way","36 x 12","48 x 18","—",3,6,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"18"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R6-2","One Way","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R8-3","No Parking (symbol)","24 x 24","36 x 36","—",4,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-8","Pedestrian Crosswalk","36 x 18","—","—",4.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-9","Sidewalk Closed","24 x 12","—","—",2,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-10","Sidewalk Closed, Use Other Side","24 x 12","—","—",2,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-11","Sidewalk Closed Ahead, Cross Here","24 x 18","—","—",3,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-11a","Sidewalk Closed, Cross Here","24 x 12","—","—",2,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R9-12","Bike Lane Closed","24 x 12","—","—",2,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"12"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R10-6","Stop Here on Red","24 x 36","—","—",6,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-2","Road Closed","48 x 30","—","—",10,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-2a","Road Closed","48 x 30","—","—",10,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,null,null,null,"R11-2b","Road Closed","48 x 30","—","—",10,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-2c","Road Closed","48 x 30","—","—",10,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-3","Road Closed - Local Traffic Only","60 x 30","—","—",12.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-3a","Road Closed - Local Traffic Only","60 x 30","—","—",12.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-3b","Road Closed - Local Traffic Only","60 x 30","—","—",12.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R11-4","Road Closed to Thru Traffic","60 x 30","—","—",{"$f":"LEFT(K73,2)*(RIGHT(K73,2)/144)","v":12.5},"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R12-1","Weight Limit","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R12-2","Weight Limit","24 x 30","36 x 48","—",5,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R12-5","Weight Limit","24 x 36","36 x 48","—",6,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"R22-2","Turn Off 2-Way Radio and Cell Phone","42 x 36","42 x 36","—",10.5,10.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"42"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"42"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":57},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W1-1L","Turn Left","36 x 36","48 x 48","30 x 30",9,16,{"$f":"LEFT(M78,2)*(RIGHT(M78,2)/144)","v":6.25},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-1R","Turn Right","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-2L","Curve Left","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-2R","Curve Right","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-3L","Left Reverse Turn","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-3R","Right Reverse Turn","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4L","Left Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4R","Right Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4bL","Two Lane Left Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4bR","Two Lane Right Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4cL","Three Lane Left Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-4cR","Three Lane Right Reverse Curve","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W1-6L","One Direction Large Arrow Left","48 x 24","60 x 30","—",8,12.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W1-6R","One Direction Large Arrow Right","48 x 24","60 x 30","—",8,12.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"60"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":60},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W1-8L","Left Chevron","18 x 24","30 x 36","—",3,7.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":51},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W1-8R","Right Chevron","18 x 24","30 x 36","—",3,7.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":51},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W3-1","Stop Ahead (symbol)","36 x 36","48 x 48","30 x 30",9,16,{"$f":"LEFT(M94,2)*(RIGHT(M94,2)/144)","v":6.25},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W3-2","Yield Ahead (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W3-3","Signal Ahead (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W3-4","Be Prepared to Stop","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W3-5","Reduced Speed Limit Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W3-5a","XX MPH Speed Zone Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,null,null,null,"W4-1L","Merge","36 x 36","48 x 48","36 x 36",9,16,9,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"36"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"36"},88]
[null,null,null,null,null,null,null,null,"W4-1R","Merge","36 x 36","48 x 48","36 x 36",9,16,9,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"36"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"36"},88]
[null,null,null,null,null,null,null,null,"W4-2L","Left Lane Ends (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W4-2R","Right Lane Ends (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W4-3L","Lane Added (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W4-3R","Lane Added (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W4-5","Entering Roadway Merge","36 x 36","48 x 48","36 x 36",9,16,9,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"36"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"36"},88]
[null,null,null,null,null,null,null,null,"W4-5aP","No Merge Area (plaque)","18 x 24","24 x 30","—",3,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":42},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W4-6","Added Lane","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W5-1","Road Narrows","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W5-2","Narrow Bridge","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W5-3","One Lane Bridge","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W5-4","Ramp Narrows","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W6-1","Divided Highway (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W6-2","Divided Highway Ends (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W6-3","Two-Way Traffic","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W6-4","Two-Way Traffic","12 x 18","12 x 18","—",1.5,1.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"12"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"12"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"18"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":24},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W7-1","Hill (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W7-3aP","Next XX Miles (plaque)","24 x 18","36 x 30","—",3,7.5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":48},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W8-1","Bump","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W8-2","Dip","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W8-3","Pavement Ends","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-4","Soft Shoulder","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-5","Slippery When Wet","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-6","Truck Crossing","36 x 36","48 x 48","30 x 30",9,16,{"$f":"LEFT(M124,2)*(RIGHT(M124,2)/144)","v":6.25},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-7","Loose Gravel","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-8","Rough Road","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W8-9","Low Shoulder","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W8-11","Uneven Lanes","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-12","No Center Line","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-14","Fallen Rocks","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-15","Grooved Pavement","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,null,null,null,"W8-15aP","Motorcycle (plaque)","24 x 18","30 x 24","—",3,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":39},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W8-16","Metal Bridge Deck","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-17","Shoulder Drop Off (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-17P","Shoulder Drop-Off (plaque)","24 x 18","30 x 24","—",3,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":39},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W8-18","Road May Flood","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W8-23","No Shoulder","36 x 36","48 x 48","30 x 30",{"$f":"LEFT(K137,2)*(RIGHT(K137,2)/144)","v":9},16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-24","Steel Plate Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W8-25","Shoulder Ends","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-1L","Left Lane Ends","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-1R","Right Lane Ends","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-2L","Lane Ends Merge Left","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-2R","Lane Ends Merge Right","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-2a","Merge Here Take Turns","36 x 48","36 x 48","—",12,12,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W9-3","Center Lane Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-3L","Left Lane Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-3R","Right Lane Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W9-5a","Bicycles Merging","30 x 30","—","18 x 18",6.25,"—",2.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"18"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"18"},88]
[null,null,null,null,null,null,null,null,"W10-1","Highway-Rail Grade Crossing Advance Warning","36 dia.","48 dia.","—",null,null,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"a."},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"a."},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"a."},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"a."},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W11-10","Truck","36 x 36","48 x 48","24 x 24",9,16,4,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"24"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"24"},88]
[null,null,null,null,null,null,null,null,"W12-1","Double Arrow","30 x 30","36 x 36","—",6.25,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"30"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"30"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W12-2","Low Clearance (with arrows)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W13-1P","Advisory Speed (plaque)","18 x 18","24 x 24","18 x 18",2.25,4,2.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":36},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"18"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"18"},88]
[null,null,null,null,null,null,null,null,"W13-4P","On Ramp (plaque)","36 x 36","36 x 36","—",9,9,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W14-3","No Passing Zone (pennant)","48 x 48 x 36","64 x 64 x 48","40 x 40 x 30",{"$f":"SQRT(T155*(T155-Q155)*(T155-R155)*(T155-S155))","v":800.94943660633157},{"$f":"SQRT(X155*(X155-U155)*(X155-V155)*(X155-W155))","v":1423.9101095223673},{"$f":"SQRT(AB155*(AB155-Y155)*(AB155-Z155)*(AB155-AA155))","v":556.21488653217477},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_c]]+Table1[[#This Row],[b_c]]+Table1[[#This Row],[c_c]])/2","v":66},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"64"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"64"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":88},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"40"},{"$f":"MID(Table1[[#This Row],[Minimum]],6,2)","v":"40"},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"(Y155+Z155+AA155)/2","v":55}]
[null,null,null,null,null,null,null,null,"W16-2P","XX Feet (plaque)","24 x 18","30 x 24","—",3,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":39},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W20-1","Road Work Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-1","Road Work XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-1b","Path Work XX FT","36 x 36","—","30 x 30",9,"—",{"$f":"LEFT(M159,2)*(RIGHT(M159,2)/144)","v":6.25},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-2","Detour Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-2","Detour XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-2a","Bike Detour XX FT","36 x 36","—","30 x 30",9,"—",6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-2b","Bike Diversion XX FT","36 x 36","—","30 x 30",9,"—",6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"36*3/2","v":54},{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"30*3/2","v":45},{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},{"$f":"(64+64+48)/2","v":88}]
[null,null,null,null,null,null,null,null,"W20-3","Road Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-3","Road Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-3a","Path Closed XX FT","36 x 36","—","30 x 30",9,"—",6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-4","One Lane Road Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-4","One Lane Road XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5L","Left Lane Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5L","Left Lane Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5R","Right Lane Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5R","Right Lane Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5aL","2 Left Lanes Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5aL","2 Left Lanes Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5aR","2 Right Lanes Closed Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5aR","2 Right Lanes Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-5b","Bike Lane Closed XX FT","36 x 36","—","30 x 30",9,"—",6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-7","Flagger (symbol)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-7a","Flagger","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W20-8","Slow (on Stop/Slow Paddle)","18 x 18","—","—",2.25,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W21-1","Workers","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-1a","Workers","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-2","Fresh Oil","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-3","Road Machinery Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-4","Slow Moving Vehicle","36 x 18","—","—",4.5,"—","—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":""},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"—"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":{"$error":"#VALUE!"}},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W21-5","Shoulder Work","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-5a","Shoulder Closed","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-5b","Shoulder Closed XX FT","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-6","Survey Crew","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-7","Utility Work Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W21-8","Mowing Ahead","36 x 36","48 x 48","30 x 30",9,16,{"$f":"LEFT(M191,2)*(RIGHT(M191,2)/144)","v":6.25},{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W22-1","Blasting Zone Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W22-3","End Blasting Zone","42 x 36","42 x 36","36 x 30",10.5,10.5,7.5,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"42"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"42"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"36"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":57},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"36"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W23-1","Slow Traffic Ahead","48 x 24","48 x 24","—",8,8,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":48},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]
[null,null,null,null,null,null,null,null,"W23-2","New Traffic Pattern Ahead","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W24-1","Double Reverse Curve (1 lane)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W24-1a","Double Reverse Curve (2 lane)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W24-1b","Double Reverse Curve (3 lane)","36 x 36","48 x 48","30 x 30",9,16,6.25,{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"36"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"36"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"48"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"48"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":72},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"30"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"30"},88]
[null,null,null,null,null,null,null,null,"W24-1cP","All Lanes (plaque)","24 x 18","30 x 24","—",3,5,"—",{"$f":"LEFT(Table1[[#This Row],[Conventional Road]],2)","v":"24"},{"$f":"MID(Table1[[#This Row],[Conventional Road]],6,2)","v":"18"},{"$f":"RIGHT(Table1[[#This Row],[Conventional Road]],2)","v":"18"},54,{"$f":"LEFT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"30"},{"$f":"MID(Table1[[#This Row],[Freeway or Expressway]],6,2)","v":"24"},{"$f":"RIGHT(Table1[[#This Row],[Freeway or Expressway]],2)","v":"24"},{"$f":"(Table1[[#This Row],[a_f]]+Table1[[#This Row],[b_f]]+Table1[[#This Row],[c_f]])/2","v":39},{"$f":"LEFT(Table1[[#This Row],[Minimum]],2)","v":"—"},45,{"$f":"RIGHT(Table1[[#This Row],[Minimum]],2)","v":"—"},88]

{"sheet":"Sheet1","index":3,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"D5-1","Rest Area XX Miles","66 x 36*","96 x 54*"]
[null,null,null,null,null,"D5-1a","Rest Area Next Right","78 x 36*","120 x 60* (F)","114 x 48* (E)"]
[null,null,null,null,null,"D5-2","Rest Area (with arrow)","66 x 36*","96 x 54*"]
[null,null,null,null,null,"D5-2a","Rest Area Gore","42 x 48*","78 x 78* (F)","66 x 72* (E)"]
[null,null,null,null,null,"D5-5","Rest Area (with horizontal arrow)","42 x 48*","—"]
[null,null,null,null,null,"D5-6","Next Rest Area XX Miles","60 x 48*","90 x 72*"]
[null,null,null,null,null,"D5-7","Rest Area Tourist Info Center XX Miles","90 x 72*","114 x 102* (F)","132 x 96* (E)"]
[null,null,null,null,null,"D5-8","Rest Area Tourist Info Center (with arrow)","84 x 72*","120 x 102* (F)","120 x 96* (E)"]
[null,null,null,null,null,"D5-11","Rest Area Tourist Info Center Next Right","90 x 72*","144 x 102* (F)","132 x 96* (E)"]
[null,null,null,null,null,"D5-12","Interstate Oasis","—","156 x 78"]
[null,null,null,null,null,"D5-12P","Interstate Oasis (plaque)","—","114 x 48"]
[null,null,null,null,null,"D5-13","Brake Check Area XX Miles","84 x 48","126 x 72"]
[null,null,null,null,null,"D5-14","Brake Check Area (with arrow)","78 x 60","96 x 72"]
[null,null,null,null,null,"D5-15","Chain-Up Area XX Miles","66 x 48","96 x 72"]
[null,null,null,null,null,"D5-16","Chain-Up Area (with arrow)","72 x 54","96 x 66"]
[null,null,null,null,null,"D9-1","Telephone","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-2","Hospital","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-3","Camping","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-3a","Trailer Camping","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-4","Litter Container","24 x 30","36 x 48"]
[null,null,null,null,null,"D9-6","Handicapped","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-6P","Van Accessible (plaque)","18 x 9","—"]
[null,null,null,null,null,"D9-7","Gas","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-8","Food","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-9","Lodging","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-10","Tourist Information","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-11","Diesel Fuel","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-11a","Alternative Fuel - Compressed Natural Gas","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-11b","Electric Vehicle Charging","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-11bP","Electric Vehicle Charging (plaque)","24 x 18","30 x 24"]
[null,null,null,null,null,"D9-11c","Alternative Fuel - Ethanol","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-12","RV Sanitatary Station","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-13","Emergency Medical Services","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-13aP","Hospital (plaque)","24 x 12","30 x 12"]
[null,null,null,null,null,"D9-13bP","Ambulance Station (plaque)","24 x 12","30 x 15"]
[null,null,null,null,null,"D9-13cP","Emergency Medical Care (plaque)","24 x 18","30 x 24"]
[null,null,null,null,null,"D9-13dP","Trauma Center (plaque)","24 x 12","30 x 15"]
[null,null,null,null,null,"D9-14","Police","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-15","Propane Gas","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-16","Truck Parking","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-17P","Next Services XX Miles (plaque)","102 x 24","156 x 30"]
[null,null,null,null,null,"D9-18","General Services (up to 6 symbols)","—","96 x 60"]
[null,null,null,null,null,"D9-18a","General Services","—","96 x 60"]
[null,null,null,null,null,"D9-18b","General Services (up to 6 symbols) with Action or Exit Information","108 x 84","132 x 114 (F)","132 x 108 (E)"]
[null,null,null,null,null,"D9-18c","General Services with Action or Exit Information","72 x 60**","132 x 108** (F)","108 x 84** (E)"]
[null,null,null,null,null,"D9-20","Pharmacy","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-20aP","24-Hour (plaque)","24 x 12","30 x 12"]
[null,null,null,null,null,"D9-21","Telecommunication Device for the Deaf","24 x 24","30 x 30"]
[null,null,null,null,null,"D9-22","Wireless Internet","24 x 24","30 x 30"]
[null,null,null,null,null,"D12-1","Weather Information","84 x 48","132 x 84"]
[null,null,null,null,null,"D12-2","Carpool Information","60 x 42","96 x 66"]
[null,null,null,null,null,"D12-3","Channel 9 Monitored","84 x 48","132 x 84"]
[null,null,null,null,null,"D12-4","Emergency Call 911","66 x 30","96 x 48"]
[null,null,null,null,null,"D12-5","Travel Info Call 511 (pictograph)","42 x 60","66 x 78"]
[null,null,null,null,null,"D12-5a","Travel Info Call 511","48 x 36","66 x 48"]

{"sheet":"Sheet2","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Standard 635-1 Typical Sign layout",null,"Signs Needed"]
[null,null,"G20-1","Road Work Next xx Miles",2,"Only if work zone is longer than 2 miles"]
[null,null,"W20+-1","Road Work XXXX",4,"Plus one for each major approach road"]