{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","quantities report","Totals - QA_QC","manual inputs","Surfacing","Surfacing Summary","quantities report_secondary","manual inputs_secondary","Surfacing_secondary","calc wrksht-rdwy exc Secondary","calc wrksht-emb const Secondary"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":4,"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":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,2],[36,2,40,2],[7,2,29,2]]}
[" "]
[null,"Instructions:"]
[null,1,"Add cut and fill volumes to the corridor"]
[null,2,"Run Quantities by Named boundary report and save file in excel format."]
[null,3,"Select the volumes report"]
[]
[null,4,"The report should be in the following format:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,5,"Right click on the report in ORD and select Export to Excel"]
[]
[null,6,"Select entire sheet in the volumes excel spreadsheet.  (CTRL-A or select the select all button)"]
[null,7,"Paste data in the quantities report tab in the grading summary spreadsheet."]
[null,8,"Select the rows that contain the whole project totals and cut and paste to the Totals - QA_QC tab."]
[null,9,"Go to the \"Manual Inputs\" page and click on the \"Click Here to Format Worksheet\" button."]
[]
[]
[]
[]
[]
[null,10,"Input layer thickness and types, existing pavement thickness, and whether cutbacks or emulsion are being used. [EDIT all yellow cells in the Manual Input Tab.]"]
[null,11,"For major secondary roads use the secondary report tabs."]

{"sheet":"quantities report","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Totals - QA_QC","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"manual inputs","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,3,19,4],[11,3,11,4],[27,3,27,4],[18,3,18,4],[17,3,17,4],[20,3,20,4],[21,3,21,4],[14,3,14,4],[12,3,12,4],[10,3,10,4],[16,3,16,4],[15,3,15,4],[13,3,13,4],[1,1,1,4],[2,3,2,4],[4,3,4,4],[3,3,3,4],[5,3,5,4],[0,1,0,4],[6,3,6,4],[8,3,8,4],[7,3,7,4],[9,3,9,4]]}
[null,"Manually update any YELLOW cells"]
[null,"Conversion Factors",null,null,null,null,null,null,null,"Station Range",null,null,null,"Number of Rows"]
[null,"Material","Factor",null,null,null,null,null,"Add Starting Station",null,null,null,null,{"$f":"LOOKUP(2,1/('quantities report'!A:A<>\"\"),ROW('quantities report'!A:A))","v":{"$error":"#N/A"}}]
[null,"Aggregate Base",139,"lb/ft3"]
[null,"HACP",145.19999999999999,"lb/ft3"]
[null,"AntiStrip",0.01,null,null,null,null,null,null,null,null,null,null,"Aggregate Base"]
[null,"Prime Coat - Asphalt Cutbacks",0.33,"gal/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Concrete Pavement"]
[null,"Prime Coat - Asphalt Cutbacks",251,"gal/ton",null,null,null,null,null,null,null,null,null,"N/A"]
[null,"Prime Coat - Asphalt Emulsion",0.27,"gal/yd2"]
[null,"Prime Coat - Asphalt Emulsion",233,"gal/ton",null,null,null,null,null,null,null,null,null,"Asphalt Cutbacks"]
[null,"Blotter",14.75,"lb/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Emulsion"]
[null,"Blotter",0.2,"of total area"]
[null,"Tack Coat - Asphalt Emulsion",0.1,"gal/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Cutbacks"]
[null,"Tack Coat - Asphalt Emulsion",233,"gal/ton",null,null,null,null,null,null,null,null,null,"Asphalt Emulsion"]
[null,"Fog Seal - Asphalt Emulsion",0.1,"gal/yd2"]
[null,"Fog Seal - Asphalt Emulsion",233,"gal/ton"]
[null,null,2000,"lb/ton"]
[]
[null,"Using Cutbacks or Emulsion","Asphalt Emulsion"]
[]
[null,"Existing Pavement",4,"inches"]
[]
[null,"Layer 1","Asphalt Concrete Pavement",4,"inches"]
[null,"Layer 2","N/A",null,"inches"]
[null,"Layer 3","N/A",null,"inches"]
[null,"Layer 4","Aggregate Base",6,"inches"]
[null,"Layer 5","N/A",null,"inches"]

{"sheet":"Surfacing","index":4,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,17,0,19],[5,8,5,10],[5,11,5,13],[2,0,3,1],[5,14,5,16],[4,8,4,10],[4,11,4,13],[4,5,4,7],[4,14,4,16],[4,2,4,4],[5,2,5,4],[5,5,5,7],[2,2,3,3],[2,5,3,6],[2,8,3,9],[2,11,3,12],[2,24,3,25],[4,24,4,26],[5,24,5,26],[2,14,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAY COLUMNS",null,null,null,null,"(20% of area)"]
["TOTALS",null,{"$f":"SUM(C9:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Y9:Y33)","v":0},0,0]
["ORD Component Name",null,"XS_TC_Pavement Layer 1: ",null,{"$f":"VLOOKUP(C5,'manual inputs'!B2:E28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 2: ",null,{"$f":"VLOOKUP(F5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 3: ",null,{"$f":"VLOOKUP(I5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 4: ",null,{"$f":"VLOOKUP(L5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":139},"XS_TC_Pavement Layer 5: ",null,{"$f":"VLOOKUP(O5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(U5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":0.1},{"$f":"VLOOKUP(V5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":0.27},{"$f":"VLOOKUP(W5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":14.75},{"$f":"VLOOKUP(X5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":0.1},"Total Existing Pavement: ",null,{"$f":"VLOOKUP(Y5,'manual inputs'!$B$2:$E$28,2,FALSE)","v":4}]
[null,null,null,null,{"$f":"VLOOKUP(C5,'manual inputs'!B2:E270,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(F5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(I5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(L5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"lb/ft3"},null,null,{"$f":"VLOOKUP(O5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(U5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},{"$f":"VLOOKUP(V5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},{"$f":"VLOOKUP(W5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"lb/yd2"},{"$f":"VLOOKUP(X5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},null,null,{"$f":"VLOOKUP(Y5,'manual inputs'!$B$2:$E$28,3,FALSE)","v":"inches"}]
[null,null,{"$f":"LOOKUP(C6,'manual inputs'!$B$23:$B$27,'manual inputs'!C23:C27)","v":"Asphalt Concrete Pavement"},null,null,{"$f":"LOOKUP(F6,'manual inputs'!$B$23:$B$27,'manual inputs'!C23:C27)","v":"N/A"},null,null,{"$f":"LOOKUP(I6,'manual inputs'!B23:B27,'manual inputs'!C23:C27)","v":"N/A"},null,null,{"$f":"LOOKUP(L6,'manual inputs'!B23:B27,'manual inputs'!C23:C27)","v":"Aggregate Base"},null,null,{"$f":"LOOKUP(O6,'manual inputs'!B23:B27,'manual inputs'!C23:C27)","v":"N/A"},null,null,"Total Aggregate Base","Total Asphalt Concrete Pavement","ANTISTRIP","Fog Seal - Asphalt Emulsion",{"$f":"IF('manual inputs'!C19=\"Asphalt Emulsion\",'manual inputs'!B9,'manual inputs'!B7)","v":"Prime Coat - Asphalt Emulsion"},"Blotter","Tack Coat - Asphalt Emulsion","Existing Pavement"]
[null,null,"Layer 1",null,null,"Layer 2",null,null,"Layer 3",null,null,"Layer 4",null,null,"Layer 5"]
[null,null,"CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","TON","TON","TON","TON","TON","TON","TON","CUYD","CUFT","SQYD"]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!2:2))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!3:3))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($C9=\"\",\" \",(C9*27))","v":" "},{"$f":"IF($C9=\"\",\" \",(D9*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($F9=\"\",\" \",(F9*27))","v":" "},{"$f":"IF($F9=\"\",\" \",(G9*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($I9=\"\",\" \",(I9*27))","v":" "},{"$f":"IF($I9=\"\",\" \",(J9*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($L9=\"\",\" \",(L9*27))","v":" "},{"$f":"IF($L9=\"\",\" \",(M9*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($O9=\"\",\" \",(O9*27))","v":" "},{"$f":"IF($O9=\"\",\" \",(P9*$Q$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF(B9=\"\",\" \",IF($C$5=\"Aggregate Base\",E9)+IF($I$5=\"Aggregate Base\",K9)+IF($F$5=\"Aggregate Base\",H9)+IF($L$5=\"Aggregate Base\",N9)+IF($O$5=\"Aggregate Base\",Q9))","v":" "},{"$f":"IF(B9=\"\",\" \",IF($C$5=\"Asphalt Concrete Pavement\",E9)+IF($I$5=\"Asphalt Concrete Pavement\",$K$9)+IF($F$5=\"Asphalt Concrete Pavement\",H9)+IF($L$5=\"Asphalt Concrete Pavement\",N9)+IF($O$5=\"Asphalt Concrete Pavement\",Q9))","v":" "},{"$f":"IF(B9=\"\",\"\",(S9*'manual inputs'!$C$6))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C9*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C9*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V5=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C9*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C9*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($C9=\"\",\" \",(Y9*27))","v":" "},{"$f":"IF($C9=\"\",\" \",(Z9/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!4:4))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($C10=\"\",\" \",(C10*27))","v":" "},{"$f":"IF($C10=\"\",\" \",(D10*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($F10=\"\",\" \",(F10*27))","v":" "},{"$f":"IF($F10=\"\",\" \",(G10*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($I10=\"\",\" \",(I10*27))","v":" "},{"$f":"IF($I10=\"\",\" \",(J10*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($L10=\"\",\" \",(L10*27))","v":" "},{"$f":"IF($L10=\"\",\" \",(M10*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($O10=\"\",\" \",(O10*27))","v":" "},{"$f":"IF($O10=\"\",\" \",(P10*$Q$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF(B10=\"\",\" \",IF($C$5=\"Aggregate Base\",E10)+IF($I$5=\"Aggregate Base\",K10)+IF($F$5=\"Aggregate Base\",H10)+IF($L$5=\"Aggregate Base\",N10)+IF($O$5=\"Aggregate Base\",Q10))","v":" "},{"$f":"IF(B10=\"\",\" \",IF($C$5=\"Asphalt Concrete Pavement\",E10)+IF($I$5=\"Asphalt Concrete Pavement\",$K$9)+IF($F$5=\"Asphalt Concrete Pavement\",H10)+IF($L$5=\"Asphalt Concrete Pavement\",N10)+IF($O$5=\"Asphalt Concrete Pavement\",Q10))","v":" "},{"$f":"IF(B10=\"\",\"\",(S10*'manual inputs'!$C$6))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C10*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C10*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V6=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C10*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C10*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X10=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($C10=\"\",\" \",(Y10*27))","v":" "},{"$f":"IF($C10=\"\",\" \",(Z10/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!5:5))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($C11=\"\",\" \",(D11*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($F11=\"\",\" \",(G11*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""},{"$f":"IF($I11=\"\",\" \",(I11*27))","v":" "},{"$f":"IF($I11=\"\",\" \",(J11*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($L11=\"\",\" \",(M11*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($O11=\"\",\" \",(P11*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B11=\"\",\"\",(S11*'manual inputs'!$C$6))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C11*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C11*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V7=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C11*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C11*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X11=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($C11=\"\",\" \",(Z11/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!6:6))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($C12=\"\",\" \",(D12*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($F12=\"\",\" \",(G12*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""},{"$f":"IF($I12=\"\",\" \",(I12*27))","v":" "},{"$f":"IF($I12=\"\",\" \",(J12*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($L12=\"\",\" \",(M12*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($O12=\"\",\" \",(P12*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B12=\"\",\"\",(S12*'manual inputs'!$C$6))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C12*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C12*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V8=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C12*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C12*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X12=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($C12=\"\",\" \",(Z12/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!7:7))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($C13=\"\",\" \",(D13*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($F13=\"\",\" \",(G13*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""},{"$f":"IF($I13=\"\",\" \",(I13*27))","v":" "},{"$f":"IF($I13=\"\",\" \",(J13*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($L13=\"\",\" \",(M13*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($O13=\"\",\" \",(P13*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B13=\"\",\"\",(S13*'manual inputs'!$C$6))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C13*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C13*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V9=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C13*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C13*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X13=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($C13=\"\",\" \",(Z13/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!8:8))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($C14=\"\",\" \",(D14*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($F14=\"\",\" \",(G14*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""},{"$f":"IF($I14=\"\",\" \",(I14*27))","v":" "},{"$f":"IF($I14=\"\",\" \",(J14*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($L14=\"\",\" \",(M14*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($O14=\"\",\" \",(P14*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B14=\"\",\"\",(S14*'manual inputs'!$C$6))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C14*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C14*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V10=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C14*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C14*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X14=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($C14=\"\",\" \",(Z14/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!9:9))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($C15=\"\",\" \",(D15*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($F15=\"\",\" \",(G15*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""},{"$f":"IF($I15=\"\",\" \",(I15*27))","v":" "},{"$f":"IF($I15=\"\",\" \",(J15*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($L15=\"\",\" \",(M15*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($O15=\"\",\" \",(P15*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B15=\"\",\"\",(S15*'manual inputs'!$C$6))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C15*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C15*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V11=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C15*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C15*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X15=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($C15=\"\",\" \",(Z15/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!10:10))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($C16=\"\",\" \",(D16*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($F16=\"\",\" \",(G16*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""},{"$f":"IF($I16=\"\",\" \",(I16*27))","v":" "},{"$f":"IF($I16=\"\",\" \",(J16*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($L16=\"\",\" \",(M16*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($O16=\"\",\" \",(P16*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B16=\"\",\"\",(S16*'manual inputs'!$C$6))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C16*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C16*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V12=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C16*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C16*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X16=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($C16=\"\",\" \",(Z16/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!11:11))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($C17=\"\",\" \",(D17*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($F17=\"\",\" \",(G17*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""},{"$f":"IF($I17=\"\",\" \",(I17*27))","v":" "},{"$f":"IF($I17=\"\",\" \",(J17*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($L17=\"\",\" \",(M17*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($O17=\"\",\" \",(P17*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B17=\"\",\"\",(S17*'manual inputs'!$C$6))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C17*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C17*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V13=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C17*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C17*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X17=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($C17=\"\",\" \",(Z17/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!12:12))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($C18=\"\",\" \",(D18*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($F18=\"\",\" \",(G18*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""},{"$f":"IF($I18=\"\",\" \",(I18*27))","v":" "},{"$f":"IF($I18=\"\",\" \",(J18*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($L18=\"\",\" \",(M18*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($O18=\"\",\" \",(P18*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B18=\"\",\"\",(S18*'manual inputs'!$C$6))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C18*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C18*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V14=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C18*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C18*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X18=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($C18=\"\",\" \",(Z18/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!13:13))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($C19=\"\",\" \",(D19*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($F19=\"\",\" \",(G19*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""},{"$f":"IF($I19=\"\",\" \",(I19*27))","v":" "},{"$f":"IF($I19=\"\",\" \",(J19*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($L19=\"\",\" \",(M19*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($O19=\"\",\" \",(P19*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B19=\"\",\"\",(S19*'manual inputs'!$C$6))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C19*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C19*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V15=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C19*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C19*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X19=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($C19=\"\",\" \",(Z19/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!14:14))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($C20=\"\",\" \",(D20*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($F20=\"\",\" \",(G20*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""},{"$f":"IF($I20=\"\",\" \",(I20*27))","v":" "},{"$f":"IF($I20=\"\",\" \",(J20*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($L20=\"\",\" \",(M20*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($O20=\"\",\" \",(P20*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B20=\"\",\"\",(S20*'manual inputs'!$C$6))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C20*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C20*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V16=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C20*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C20*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X20=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($C20=\"\",\" \",(Z20/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!15:15))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($C21=\"\",\" \",(D21*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($F21=\"\",\" \",(G21*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""},{"$f":"IF($I21=\"\",\" \",(I21*27))","v":" "},{"$f":"IF($I21=\"\",\" \",(J21*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($L21=\"\",\" \",(M21*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($O21=\"\",\" \",(P21*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B21=\"\",\"\",(S21*'manual inputs'!$C$6))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C21*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C21*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V17=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C21*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C21*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X21=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($C21=\"\",\" \",(Z21/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!16:16))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($C22=\"\",\" \",(D22*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($F22=\"\",\" \",(G22*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""},{"$f":"IF($I22=\"\",\" \",(I22*27))","v":" "},{"$f":"IF($I22=\"\",\" \",(J22*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($L22=\"\",\" \",(M22*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($O22=\"\",\" \",(P22*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B22=\"\",\"\",(S22*'manual inputs'!$C$6))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C22*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C22*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V18=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C22*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C22*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X22=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($C22=\"\",\" \",(Z22/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!17:17))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""},{"$f":"IF($C23=\"\",\" \",(C23*27))","v":" "},{"$f":"IF($C23=\"\",\" \",(D23*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($F23=\"\",\" \",(G23*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""},{"$f":"IF($I23=\"\",\" \",(I23*27))","v":" "},{"$f":"IF($I23=\"\",\" \",(J23*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($L23=\"\",\" \",(M23*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($O23=\"\",\" \",(P23*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B23=\"\",\"\",(S23*'manual inputs'!$C$6))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C23*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C23*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V19=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C23*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C23*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X23=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($C23=\"\",\" \",(Z23/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!18:18))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($C24=\"\",\" \",(D24*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($F24=\"\",\" \",(G24*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""},{"$f":"IF($I24=\"\",\" \",(I24*27))","v":" "},{"$f":"IF($I24=\"\",\" \",(J24*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($L24=\"\",\" \",(M24*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($O24=\"\",\" \",(P24*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B24=\"\",\"\",(S24*'manual inputs'!$C$6))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C24*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C24*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V20=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C24*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C24*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X24=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($C24=\"\",\" \",(Z24/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!19:19))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($C25=\"\",\" \",(D25*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($F25=\"\",\" \",(G25*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""},{"$f":"IF($I25=\"\",\" \",(I25*27))","v":" "},{"$f":"IF($I25=\"\",\" \",(J25*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($L25=\"\",\" \",(M25*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($O25=\"\",\" \",(P25*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B25=\"\",\"\",(S25*'manual inputs'!$C$6))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C25*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C25*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V21=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C25*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C25*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X25=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($C25=\"\",\" \",(Z25/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!20:20))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($C26=\"\",\" \",(D26*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($F26=\"\",\" \",(G26*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""},{"$f":"IF($I26=\"\",\" \",(I26*27))","v":" "},{"$f":"IF($I26=\"\",\" \",(J26*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($L26=\"\",\" \",(M26*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($O26=\"\",\" \",(P26*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B26=\"\",\"\",(S26*'manual inputs'!$C$6))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C26*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C26*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V22=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C26*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C26*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X26=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($C26=\"\",\" \",(Z26/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!21:21))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($C27=\"\",\" \",(D27*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($F27=\"\",\" \",(G27*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""},{"$f":"IF($I27=\"\",\" \",(I27*27))","v":" "},{"$f":"IF($I27=\"\",\" \",(J27*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($L27=\"\",\" \",(M27*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($O27=\"\",\" \",(P27*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B27=\"\",\"\",(S27*'manual inputs'!$C$6))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C27*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C27*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V23=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C27*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C27*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X27=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($C27=\"\",\" \",(Z27/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!22:22))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($C28=\"\",\" \",(D28*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($F28=\"\",\" \",(G28*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""},{"$f":"IF($I28=\"\",\" \",(I28*27))","v":" "},{"$f":"IF($I28=\"\",\" \",(J28*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($L28=\"\",\" \",(M28*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($O28=\"\",\" \",(P28*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B28=\"\",\"\",(S28*'manual inputs'!$C$6))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C28*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C28*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V24=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C28*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C28*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X28=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($C28=\"\",\" \",(Z28/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!23:23))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($C29=\"\",\" \",(D29*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($F29=\"\",\" \",(G29*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""},{"$f":"IF($I29=\"\",\" \",(I29*27))","v":" "},{"$f":"IF($I29=\"\",\" \",(J29*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($L29=\"\",\" \",(M29*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($O29=\"\",\" \",(P29*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B29=\"\",\"\",(S29*'manual inputs'!$C$6))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C29*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C29*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V25=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C29*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C29*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X29=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($C29=\"\",\" \",(Z29/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!24:24))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($C30=\"\",\" \",(D30*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($F30=\"\",\" \",(G30*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""},{"$f":"IF($I30=\"\",\" \",(I30*27))","v":" "},{"$f":"IF($I30=\"\",\" \",(J30*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($L30=\"\",\" \",(M30*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($O30=\"\",\" \",(P30*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B30=\"\",\"\",(S30*'manual inputs'!$C$6))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C30*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C30*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V26=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C30*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C30*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X30=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($C30=\"\",\" \",(Z30/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!25:25))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($C31=\"\",\" \",(D31*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($F31=\"\",\" \",(G31*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""},{"$f":"IF($I31=\"\",\" \",(I31*27))","v":" "},{"$f":"IF($I31=\"\",\" \",(J31*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($L31=\"\",\" \",(M31*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($O31=\"\",\" \",(P31*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B31=\"\",\"\",(S31*'manual inputs'!$C$6))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C31*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C31*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V27=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C31*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C31*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X31=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($C31=\"\",\" \",(Z31/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!26:26))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=C$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($C32=\"\",\" \",(D32*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=F$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($F32=\"\",\" \",(G32*$E$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=I$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""},{"$f":"IF($I32=\"\",\" \",(I32*27))","v":" "},{"$f":"IF($I32=\"\",\" \",(J32*$K$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=L$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($L32=\"\",\" \",(M32*$N$3/'manual inputs'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=O$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($O32=\"\",\" \",(P32*$Q$3/'manual inputs'!$C$17))","v":" "}," "," ",{"$f":"IF(B32=\"\",\"\",(S32*'manual inputs'!$C$6))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C32*27/('manual inputs'!$D$23/12))/9)*$U$3/'manual inputs'!$C$16)))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C32*27/('manual inputs'!$D$23/12))/9)*$V$3/IF(V28=\"Prime Coat - Asphalt Emulsion\",'manual inputs'!$C$10,'manual inputs'!$C$8))))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C32*27/('manual inputs'!$D$23/12))/9)*'manual inputs'!$C$12)*$W$3/'manual inputs'!$C$17)))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C32*27/('manual inputs'!$D$23/12))/9)*$X$3/'manual inputs'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(X32=\"\",\"\",IFERROR(INDEX('quantities report'!$D$2:$D$10003,SMALL(IF('quantities report'!$A$2:$A$10003=Y$3,ROW('quantities report'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($C32=\"\",\" \",(Z32/('manual inputs'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)),ROW(28:28))),\"\")","v":""}]

{"sheet":"Surfacing Summary","index":5,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[28,0,28,1],[11,0,11,1],[12,0,12,1],[1,0,10,0],[1,1,10,1],[5,4,5,13],[6,4,6,6],[48,14,48,23],[47,14,47,23],[7,9,11,9],[7,10,11,10],[7,11,11,11],[44,4,44,6],[7,4,12,6],[7,7,11,7],[7,8,11,8],[28,4,28,6],[7,12,11,12],[7,13,11,13]]}
[]
["<---Type Beginning Row Number","<---Automatic calculates except for last row",null,null,"NOTE TO DESIGNER:  EXAMPLE PAY ITEMS SHOWN…ADJUST TO FIT PROJECT SPECIFIC REQUIREMENTS"]
[]
[null,null,null,null,"Check Totals ------->",null,null,{"$f":"Surfacing!R2+Surfacing_secondary!R2","v":0},{"$f":"Surfacing!R2+Surfacing_secondary!R2","v":0},{"$f":"Surfacing!S2+Surfacing_secondary!S2","v":0},{"$f":"Surfacing!T2+Surfacing_secondary!T2","v":0},{"$f":"Surfacing!U2+Surfacing_secondary!U2","v":0},{"$f":"Surfacing!V2+Surfacing_secondary!V2","v":0},{"$f":"Surfacing!X2+Surfacing_secondary!X2","v":0}]
[]
[null,null,null,null,"SURFACING SUMMARY"]
[null,null,null,null,null,null,null,"20303-1600","30202-2000","40101-1000","40105-3000","40601-0000","41103-0000","41201-0000"]
[null,null,null,null,"Station to Station",null,null,{"$f":"IF(ISBLANK(H7),\" \",LOOKUP(H7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"REMOVAL OF PAVEMENT, ASPHALT"},{"$f":"IF(ISBLANK(I7),\" \",LOOKUP(I7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"ROADWAY AGGREGATE, METHOD 2"},{"$f":"IF(ISBLANK(J7),\" \",LOOKUP(J7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"ASPHALT CONCRETE PAVEMENT, GYRATORY MIX, 3/4-INCH NOMINAL MAXIMUM SIZE AGGREGATE, 0.3 TO <3 MILLION ESAL"},{"$f":"IF(ISBLANK(K7),\" \",LOOKUP(K7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"ANTISTRIP ADDITIVE, TYPE 3"},{"$f":"IF(ISBLANK(L7),\" \",LOOKUP(L7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"FOG SEAL"},{"$f":"IF(ISBLANK(M7),\" \",LOOKUP(M7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"PRIME COAT, METHOD 3"},{"$f":"IF(ISBLANK(N7),\" \",LOOKUP(N7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$D$2:$D$8005))","v":"TACK COAT"}]
[]
[]
[]
["Rows from"]
["Surfacing",null,null,null,null,null,null,{"$f":"IF(ISBLANK(H7),\" \",LOOKUP(H7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"SQYD"},{"$f":"IF(ISBLANK(I7),\" \",LOOKUP(I7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"TON"},{"$f":"IF(ISBLANK(J7),\" \",LOOKUP(J7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"TON"},{"$f":"IF(ISBLANK(K7),\" \",LOOKUP(K7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"TON"},{"$f":"IF(ISBLANK(L7),\" \",LOOKUP(L7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"TON"},{"$f":"IF(ISBLANK(M7),\" \",LOOKUP(M7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"SQYD"},{"$f":"IF(ISBLANK(N7),\" \",LOOKUP(N7,'[1]FP14 Pay Items'!$A$2:$A$8005,'[1]FP14 Pay Items'!$E$2:$E$8005))","v":"TON"}]
[null,{"$f":"IF(A15=\"\",\"\",+A15)","v":""},null,null,{"$f":"IF(A14=\"\",\"\",INDIRECT(CONCATENATE($A$13,\"!\",\"B\",A14)))","v":""},{"$f":"IF(E14=\"\",\"\",\"-\")","v":""},{"$f":"IF(A14=\"\",\"\",INDIRECT(CONCATENATE($A$13,\"!\",\"b\",B14)))","v":""},{"$f":"IF(F14=\"\",\"\",ROUNDUP(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"AA\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"r\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"s\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"T\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"U\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"v\",$B14))),0))","v":""},{"$f":"IF(F14=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"x\",$B14))),0))","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",+A16)","v":""},null,null,{"$f":"IF(A15=\"\",\"\",INDIRECT(CONCATENATE($A$13,\"!\",\"B\",A15)))","v":""},"",{"$f":"IF(A15=\"\",\"\",INDIRECT(CONCATENATE($A$13,\"!\",\"b\",B15)))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"AA\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"r\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"s\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"T\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"U\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"v\",$B15))),0))","v":""},{"$f":"IF(F15=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"x\",$B15))),0))","v":""}]
[null,{"$f":"IF(A17=\"\",\"\",+A17)","v":""},null,null,"","","","","",{"$f":"IF(F16=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$13,\"!\",\"s\",$B16))),0))","v":""},"","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,null,null,null,"",""]
["Surfacing_Secondary",null,null,null,"Secondary Alignment"]
[null,{"$f":"IF(A31=\"\",\"\",+A31)","v":""},null,null,{"$f":"IF(A30=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"B\",A30)))","v":""},"",{"$f":"IF(A30=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"b\",B30)))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"AA\",$B14))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"r\",$B30))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"s\",$B30))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"T\",$B30))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"U\",$B30))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"v\",$B30))),0))","v":""},{"$f":"IF(F30=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"x\",$B30))),0))","v":""}]
[null,"",null,null,{"$f":"IF(A31=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"B\",A31)))","v":""},{"$f":"IF(E31=\"\",\"\",\"-\")","v":""},{"$f":"IF(A31=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"b\",B31)))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"AA\",$B15))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"r\",$B31))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"s\",$B31))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"T\",$B31))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"U\",$B31))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"v\",$B31))),0))","v":""},{"$f":"IF(F31=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"x\",$B31))),0))","v":""}]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,{"$f":"IF(A37=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"B\",A37)))","v":""},{"$f":"IF(E37=\"\",\"\",\"-\")","v":""},{"$f":"IF(A37=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"b\",B37)))","v":""},"",{"$f":"IF(F37=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"r\",$B37))),0))","v":""},"","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,{"$f":"IF(A41=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"B\",A41)))","v":""},{"$f":"IF(E41=\"\",\"\",\"-\")","v":""},{"$f":"IF(A41=\"\",\"\",INDIRECT(CONCATENATE($A$29,\"!\",\"b\",B41)))","v":""},"",{"$f":"IF(F41=\"\",\"\",ROUND(SUM(INDIRECT(CONCATENATE($A$29,\"!\",\"r\",$B41))),0))","v":""},"","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,"",null,null,"","","","","","","","","",""]
[null,""]
[null,"",null,null,"TOTALS",null,null,{"$f":"SUM(H14:H44)","v":0},0,0,0,0,0,0]
[null,{"$f":"IF(A47=\"\",\"\",+A47)","v":""}]
[null,{"$f":"IF(A48=\"\",\"\",+A48)","v":""},null,null,"Values used for estimating purposes:"]
[null,{"$f":"IF(A49=\"\",\"\",+A49)","v":""},null,null,null,null,null,"Aggregate base . . . .",{"$f":"CONCATENATE('manual inputs'!C4,\" \",'manual inputs'!D4)","v":"139 lb/ft3"}]
[null,{"$f":"IF(A51=\"\",\"\",+A51)","v":""},null,null,null,null,null,"Hot asphalt concrete pavement . . . .",{"$f":"CONCATENATE('manual inputs'!C5,\" \",'manual inputs'!D5)","v":"145.2 lb/ft3"}]
[null,null,null,null,null,null,null,"Antistrip . . . .",{"$f":"CONCATENATE('manual inputs'!C6*100,\"\", \"% of weight of mix\")","v":"1% of weight of mix"}]
[null,null,null,null,null,null,null,"Fog seal . . . .",{"$f":"CONCATENATE('manual inputs'!C15,\" \",'manual inputs'!D15,\" (\",'manual inputs'!C16,\" \",'manual inputs'!D16,\")\")","v":"0.1 gal/yd2 (233 gal/ton)"}]
[null,null,null,null,null,null,null,"Prime coat . . . .",{"$f":"IF('manual inputs'!C19=\"ASPHALT EMULSION\",CONCATENATE('manual inputs'!C9,\" \",'manual inputs'!D9,\" (\",'manual inputs'!C10,\" \",'manual inputs'!D10,\")\"),CONCATENATE('manual inputs'!C7,\" \",'manual inputs'!D7,\" (\",'manual inputs'!C8,\" \",'manual inputs'!D8,\")\"))","v":"0.27 gal/yd2 (233 gal/ton)"}]
[null,null,null,null,null,null,null,"Tack coat . . . .",{"$f":"CONCATENATE('manual inputs'!C13,\" \",'manual inputs'!D13,\" (\",'manual inputs'!C14,\" \",'manual inputs'!D14,\")\")","v":"0.1 gal/yd2 (233 gal/ton)"}]

{"sheet":"quantities report_secondary","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"manual inputs_secondary","index":7,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,3,16,4],[17,3,17,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[0,1,0,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[1,1,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[27,3,27,4]]}
[null,"Manually update any YELLOW cells"]
[null,"Conversion Factors",null,null,null,null,null,null,null,"Station Range",null,null,null,"Number of Rows"]
[null,"Material","Factor",null,null,null,null,null,"Add Starting Station",null,null,null,null,{"$f":"LOOKUP(2,1/('quantities report'!A:A<>\"\"),ROW('quantities report'!A:A))","v":{"$error":"#N/A"}}]
[null,"Aggregate Base",139,"lb/ft3"]
[null,"HACP",145.19999999999999,"lb/ft3"]
[null,"AntiStrip",0.01,null,null,null,null,null,null,null,null,null,null,"Aggregate Base"]
[null,"Prime Coat - Asphalt Cutbacks",0.33,"gal/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Concrete Pavement"]
[null,"Prime Coat - Asphalt Cutbacks",251,"gal/ton",null,null,null,null,null,null,null,null,null,"N/A"]
[null,"Prime Coat - Asphalt Emulsion",0.27,"gal/yd2"]
[null,"Prime Coat - Asphalt Emulsion",233,"gal/ton",null,null,null,null,null,null,null,null,null,"Asphalt Cutbacks"]
[null,"Blotter",14.75,"lb/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Emulsion"]
[null,"Blotter",0.2,"of total area"]
[null,"Tack Coat - Asphalt Emulsion",0.1,"gal/yd2",null,null,null,null,null,null,null,null,null,"Asphalt Cutbacks"]
[null,"Tack Coat - Asphalt Emulsion",233,"gal/ton",null,null,null,null,null,null,null,null,null,"Asphalt Emulsion"]
[null,"Fog Seal - Asphalt Emulsion",0.1,"gal/yd2"]
[null,"Fog Seal - Asphalt Emulsion",233,"gal/ton"]
[null,null,2000,"lb/ton"]
[]
[null,"Using Cutbacks or Emulsion","Asphalt Emulsion"]
[]
[null,"Existing Pavement",4,"inches"]
[]
[null,"Layer 1","Asphalt Concrete Pavement",4,"inches"]
[null,"Layer 2","N/A",null,"inches"]
[null,"Layer 3","N/A",null,"inches"]
[null,"Layer 4","Aggregate Base",6,"inches"]
[null,"Layer 5","N/A",null,"inches"]

{"sheet":"Surfacing_secondary","index":8,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,24,5,26],[2,24,3,25],[4,2,4,4],[4,5,4,7],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,24,4,26],[5,2,5,4],[5,5,5,7],[5,8,5,10],[5,11,5,13],[5,14,5,16],[0,17,0,19],[1,0,1,1],[2,0,3,1],[2,2,3,3],[2,5,3,6],[2,8,3,9],[2,11,3,12],[2,14,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAY COLUMNS",null,null,null,null,"(20% of area)"]
["TOTALS",null,{"$f":"SUM(C9:C33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ORD Component Name",null,"XS_TC_Pavement Layer 1: ",null,{"$f":"VLOOKUP(C5,'manual inputs_secondary'!B2:E28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 2: ",null,{"$f":"VLOOKUP(F5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 3: ",null,{"$f":"VLOOKUP(I5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},"XS_TC_Pavement Layer 4: ",null,{"$f":"VLOOKUP(L5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":139},"XS_TC_Pavement Layer 5: ",null,{"$f":"VLOOKUP(O5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(U5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":0.1},{"$f":"VLOOKUP(V5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":0.27},{"$f":"VLOOKUP(W5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":14.75},{"$f":"VLOOKUP(X5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":0.1},"Total Existing Pavement: ",null,{"$f":"VLOOKUP(Y5,'manual inputs_secondary'!$B$2:$E$28,2,FALSE)","v":4}]
[null,null,null,null,{"$f":"VLOOKUP(C5,'manual inputs_secondary'!B2:E270,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(F5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(I5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(L5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"lb/ft3"},null,null,{"$f":"VLOOKUP(O5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(U5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},{"$f":"VLOOKUP(V5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},{"$f":"VLOOKUP(W5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"lb/yd2"},{"$f":"VLOOKUP(X5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"gal/yd2"},null,null,{"$f":"VLOOKUP(Y5,'manual inputs_secondary'!$B$2:$E$28,3,FALSE)","v":"inches"}]
[null,null,{"$f":"LOOKUP(C6,'manual inputs_secondary'!$B$23:$B$27,'manual inputs_secondary'!C23:C27)","v":"Asphalt Concrete Pavement"},null,null,{"$f":"LOOKUP(F6,'manual inputs_secondary'!$B$23:$B$27,'manual inputs_secondary'!C23:C27)","v":"N/A"},null,null,{"$f":"LOOKUP(I6,'manual inputs_secondary'!B23:B27,'manual inputs_secondary'!C23:C27)","v":"N/A"},null,null,{"$f":"LOOKUP(L6,'manual inputs_secondary'!B23:B27,'manual inputs_secondary'!C23:C27)","v":"Aggregate Base"},null,null,{"$f":"LOOKUP(O6,'manual inputs_secondary'!B23:B27,'manual inputs_secondary'!C23:C27)","v":"N/A"},null,null,"Total Aggregate Base","Total HACP","ANTISTRIP","Fog Seal - Asphalt Emulsion",{"$f":"IF('manual inputs_secondary'!C19=\"Asphalt Emulsion\",'manual inputs_secondary'!B9,'manual inputs_secondary'!B7)","v":"Prime Coat - Asphalt Emulsion"},"Blotter","Tack Coat - Asphalt Emulsion","Existing Pavement"]
[null,null,"Layer 1",null,null,"Layer 2",null,null,"Layer 3",null,null,"Layer 4",null,null,"Layer 5"]
[null,null,"CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","CUYD","CUFT","TON","TON","TON","TON","TON","TON","TON","TON","CUYD","CUFT","SQYD"]
[null,{"$f":"IFERROR(INDEX('manual inputs_secondary'!J:J,SMALL(IF('manual inputs_secondary'!J:J<>\"\",ROW('manual inputs_secondary'!J:J)),ROW('manual inputs_secondary'!2:2))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('manual inputs_secondary'!J:J,SMALL(IF('manual inputs_secondary'!J:J<>\"\",ROW('manual inputs_secondary'!J:J)),ROW('manual inputs_secondary'!3:3))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($C9=\"\",\" \",(C9*27))","v":" "},{"$f":"IF($C9=\"\",\" \",(D9*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($F9=\"\",\" \",(F9*27))","v":" "},{"$f":"IF($F9=\"\",\" \",(G9*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($I9=\"\",\" \",(I9*27))","v":" "},{"$f":"IF($I9=\"\",\" \",(J9*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($L9=\"\",\" \",(L9*27))","v":" "},{"$f":"IF($L9=\"\",\" \",(M9*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($O9=\"\",\" \",(O9*27))","v":" "},{"$f":"IF($O9=\"\",\" \",(P9*$Q$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF(B9=\"\",\" \",IF($C$5=\"Aggregate Base\",E9)+IF($I$5=\"Aggregate Base\",K9)+IF($F$5=\"Aggregate Base\",H9)+IF($L$5=\"Aggregate Base\",N9)+IF($O$5=\"Aggregate Base\",Q9))","v":" "},{"$f":"IF(B9=\"\",\" \",IF($C$5=\"Asphalt Concrete Pavement\",E9)+IF($I$5=\"Asphalt Concrete Pavement\",$K$9)+IF($F$5=\"Asphalt Concrete Pavement\",H9)+IF($L$5=\"Asphalt Concrete Pavement\",N9)+IF($O$5=\"Asphalt Concrete Pavement\",Q9))","v":" "},{"$f":"IF(B9=\"\",\"\",(S9*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C9*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C9*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V5=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C9*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B9=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C9*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B9=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B9))),\"0\")))","v":""},{"$f":"IF($C9=\"\",\" \",(Y9*27))","v":" "},{"$f":"IF($C9=\"\",\" \",(Z9/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!4:4))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($C10=\"\",\" \",(C10*27))","v":" "},{"$f":"IF($C10=\"\",\" \",(D10*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($F10=\"\",\" \",(F10*27))","v":" "},{"$f":"IF($F10=\"\",\" \",(G10*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($I10=\"\",\" \",(I10*27))","v":" "},{"$f":"IF($I10=\"\",\" \",(J10*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($L10=\"\",\" \",(L10*27))","v":" "},{"$f":"IF($L10=\"\",\" \",(M10*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($O10=\"\",\" \",(O10*27))","v":" "},{"$f":"IF($O10=\"\",\" \",(P10*$Q$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF(B10=\"\",\" \",IF($C$5=\"Aggregate Base\",E10)+IF($I$5=\"Aggregate Base\",K10)+IF($F$5=\"Aggregate Base\",H10)+IF($L$5=\"Aggregate Base\",N10)+IF($O$5=\"Aggregate Base\",Q10))","v":" "},{"$f":"IF(B10=\"\",\" \",IF($C$5=\"HACP\",E10)+IF($I$5=\"HACP\",$K$9)+IF($F$5=\"HACP\",H10)+IF($L$5=\"HACP\",N10)+IF($O$5=\"HACP\",Q10))","v":" "},{"$f":"IF(B10=\"\",\"\",(S10*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C10*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C10*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V6=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C10*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B10=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C10*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B10=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B10))),\"0\")))","v":""},{"$f":"IF($C10=\"\",\" \",(Y10*27))","v":" "},{"$f":"IF($C10=\"\",\" \",(Z10/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!5:5))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($C11=\"\",\" \",(D11*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($F11=\"\",\" \",(G11*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""},{"$f":"IF($I11=\"\",\" \",(I11*27))","v":" "},{"$f":"IF($I11=\"\",\" \",(J11*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($L11=\"\",\" \",(M11*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($O11=\"\",\" \",(P11*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B11=\"\",\"\",(S11*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C11*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C11*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V7=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C11*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B11=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C11*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B11=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B11))),\"0\")))","v":""}," ",{"$f":"IF($C11=\"\",\" \",(Z11/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!6:6))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($C12=\"\",\" \",(D12*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($F12=\"\",\" \",(G12*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""},{"$f":"IF($I12=\"\",\" \",(I12*27))","v":" "},{"$f":"IF($I12=\"\",\" \",(J12*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($L12=\"\",\" \",(M12*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($O12=\"\",\" \",(P12*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B12=\"\",\"\",(S12*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C12*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C12*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V8=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C12*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B12=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C12*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B12=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B12))),\"0\")))","v":""}," ",{"$f":"IF($C12=\"\",\" \",(Z12/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!7:7))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($C13=\"\",\" \",(D13*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($F13=\"\",\" \",(G13*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""},{"$f":"IF($I13=\"\",\" \",(I13*27))","v":" "},{"$f":"IF($I13=\"\",\" \",(J13*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($L13=\"\",\" \",(M13*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($O13=\"\",\" \",(P13*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B13=\"\",\"\",(S13*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C13*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C13*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V9=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C13*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B13=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C13*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B13=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B13))),\"0\")))","v":""}," ",{"$f":"IF($C13=\"\",\" \",(Z13/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!8:8))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($C14=\"\",\" \",(D14*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($F14=\"\",\" \",(G14*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""},{"$f":"IF($I14=\"\",\" \",(I14*27))","v":" "},{"$f":"IF($I14=\"\",\" \",(J14*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($L14=\"\",\" \",(M14*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($O14=\"\",\" \",(P14*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B14=\"\",\"\",(S14*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C14*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C14*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V10=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C14*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B14=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C14*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B14=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B14))),\"0\")))","v":""}," ",{"$f":"IF($C14=\"\",\" \",(Z14/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!9:9))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($C15=\"\",\" \",(D15*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($F15=\"\",\" \",(G15*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""},{"$f":"IF($I15=\"\",\" \",(I15*27))","v":" "},{"$f":"IF($I15=\"\",\" \",(J15*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($L15=\"\",\" \",(M15*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($O15=\"\",\" \",(P15*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B15=\"\",\"\",(S15*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C15*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C15*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V11=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C15*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B15=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C15*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B15=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B15))),\"0\")))","v":""}," ",{"$f":"IF($C15=\"\",\" \",(Z15/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!10:10))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($C16=\"\",\" \",(D16*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($F16=\"\",\" \",(G16*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""},{"$f":"IF($I16=\"\",\" \",(I16*27))","v":" "},{"$f":"IF($I16=\"\",\" \",(J16*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($L16=\"\",\" \",(M16*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($O16=\"\",\" \",(P16*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B16=\"\",\"\",(S16*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C16*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C16*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V12=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C16*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B16=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C16*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B16=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B16))),\"0\")))","v":""}," ",{"$f":"IF($C16=\"\",\" \",(Z16/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!11:11))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($C17=\"\",\" \",(D17*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($F17=\"\",\" \",(G17*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""},{"$f":"IF($I17=\"\",\" \",(I17*27))","v":" "},{"$f":"IF($I17=\"\",\" \",(J17*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($L17=\"\",\" \",(M17*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($O17=\"\",\" \",(P17*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B17=\"\",\"\",(S17*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C17*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C17*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V13=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C17*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B17=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C17*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B17=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B17))),\"0\")))","v":""}," ",{"$f":"IF($C17=\"\",\" \",(Z17/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!12:12))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($C18=\"\",\" \",(D18*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($F18=\"\",\" \",(G18*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""},{"$f":"IF($I18=\"\",\" \",(I18*27))","v":" "},{"$f":"IF($I18=\"\",\" \",(J18*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($L18=\"\",\" \",(M18*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($O18=\"\",\" \",(P18*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B18=\"\",\"\",(S18*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C18*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C18*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V14=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C18*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B18=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C18*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B18=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B18))),\"0\")))","v":""}," ",{"$f":"IF($C18=\"\",\" \",(Z18/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!13:13))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($C19=\"\",\" \",(D19*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($F19=\"\",\" \",(G19*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""},{"$f":"IF($I19=\"\",\" \",(I19*27))","v":" "},{"$f":"IF($I19=\"\",\" \",(J19*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($L19=\"\",\" \",(M19*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($O19=\"\",\" \",(P19*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B19=\"\",\"\",(S19*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C19*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C19*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V15=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C19*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B19=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C19*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B19=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B19))),\"0\")))","v":""}," ",{"$f":"IF($C19=\"\",\" \",(Z19/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!14:14))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($C20=\"\",\" \",(D20*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($F20=\"\",\" \",(G20*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""},{"$f":"IF($I20=\"\",\" \",(I20*27))","v":" "},{"$f":"IF($I20=\"\",\" \",(J20*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($L20=\"\",\" \",(M20*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($O20=\"\",\" \",(P20*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B20=\"\",\"\",(S20*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C20*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C20*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V16=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C20*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B20=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C20*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B20=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B20))),\"0\")))","v":""}," ",{"$f":"IF($C20=\"\",\" \",(Z20/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!15:15))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($C21=\"\",\" \",(D21*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($F21=\"\",\" \",(G21*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""},{"$f":"IF($I21=\"\",\" \",(I21*27))","v":" "},{"$f":"IF($I21=\"\",\" \",(J21*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($L21=\"\",\" \",(M21*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($O21=\"\",\" \",(P21*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B21=\"\",\"\",(S21*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C21*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C21*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V17=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C21*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B21=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C21*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B21=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B21))),\"0\")))","v":""}," ",{"$f":"IF($C21=\"\",\" \",(Z21/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!16:16))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($C22=\"\",\" \",(D22*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($F22=\"\",\" \",(G22*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""},{"$f":"IF($I22=\"\",\" \",(I22*27))","v":" "},{"$f":"IF($I22=\"\",\" \",(J22*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($L22=\"\",\" \",(M22*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($O22=\"\",\" \",(P22*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B22=\"\",\"\",(S22*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C22*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C22*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V18=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C22*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C22*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B22=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B22))),\"0\")))","v":""}," ",{"$f":"IF($C22=\"\",\" \",(Z22/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!17:17))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($C23=\"\",\" \",(D23*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($F23=\"\",\" \",(G23*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""},{"$f":"IF($I23=\"\",\" \",(I23*27))","v":" "},{"$f":"IF($I23=\"\",\" \",(J23*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($L23=\"\",\" \",(M23*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($O23=\"\",\" \",(P23*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B23=\"\",\"\",(S23*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C23*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C23*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V19=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C23*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B23=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C23*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B23=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B23))),\"0\")))","v":""}," ",{"$f":"IF($C23=\"\",\" \",(Z23/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!18:18))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($C24=\"\",\" \",(D24*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($F24=\"\",\" \",(G24*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""},{"$f":"IF($I24=\"\",\" \",(I24*27))","v":" "},{"$f":"IF($I24=\"\",\" \",(J24*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($L24=\"\",\" \",(M24*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($O24=\"\",\" \",(P24*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B24=\"\",\"\",(S24*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C24*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C24*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V20=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C24*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B24=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C24*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B24=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B24))),\"0\")))","v":""}," ",{"$f":"IF($C24=\"\",\" \",(Z24/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!19:19))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($C25=\"\",\" \",(D25*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($F25=\"\",\" \",(G25*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""},{"$f":"IF($I25=\"\",\" \",(I25*27))","v":" "},{"$f":"IF($I25=\"\",\" \",(J25*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($L25=\"\",\" \",(M25*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($O25=\"\",\" \",(P25*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B25=\"\",\"\",(S25*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C25*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C25*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V21=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C25*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B25=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C25*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B25=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B25))),\"0\")))","v":""}," ",{"$f":"IF($C25=\"\",\" \",(Z25/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!20:20))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($C26=\"\",\" \",(D26*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($F26=\"\",\" \",(G26*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""},{"$f":"IF($I26=\"\",\" \",(I26*27))","v":" "},{"$f":"IF($I26=\"\",\" \",(J26*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($L26=\"\",\" \",(M26*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($O26=\"\",\" \",(P26*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B26=\"\",\"\",(S26*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C26*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C26*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V22=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C26*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B26=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C26*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B26=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B26))),\"0\")))","v":""}," ",{"$f":"IF($C26=\"\",\" \",(Z26/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!21:21))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($C27=\"\",\" \",(D27*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($F27=\"\",\" \",(G27*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""},{"$f":"IF($I27=\"\",\" \",(I27*27))","v":" "},{"$f":"IF($I27=\"\",\" \",(J27*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($L27=\"\",\" \",(M27*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($O27=\"\",\" \",(P27*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B27=\"\",\"\",(S27*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C27*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C27*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V23=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C27*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B27=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C27*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B27=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B27))),\"0\")))","v":""}," ",{"$f":"IF($C27=\"\",\" \",(Z27/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!22:22))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($C28=\"\",\" \",(D28*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($F28=\"\",\" \",(G28*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""},{"$f":"IF($I28=\"\",\" \",(I28*27))","v":" "},{"$f":"IF($I28=\"\",\" \",(J28*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($L28=\"\",\" \",(M28*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($O28=\"\",\" \",(P28*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B28=\"\",\"\",(S28*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C28*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C28*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V24=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C28*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B28=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C28*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B28=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B28))),\"0\")))","v":""}," ",{"$f":"IF($C28=\"\",\" \",(Z28/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!23:23))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($C29=\"\",\" \",(D29*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($F29=\"\",\" \",(G29*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""},{"$f":"IF($I29=\"\",\" \",(I29*27))","v":" "},{"$f":"IF($I29=\"\",\" \",(J29*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($L29=\"\",\" \",(M29*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($O29=\"\",\" \",(P29*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B29=\"\",\"\",(S29*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C29*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C29*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V25=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C29*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B29=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C29*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B29=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B29))),\"0\")))","v":""}," ",{"$f":"IF($C29=\"\",\" \",(Z29/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!24:24))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($C30=\"\",\" \",(D30*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($F30=\"\",\" \",(G30*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""},{"$f":"IF($I30=\"\",\" \",(I30*27))","v":" "},{"$f":"IF($I30=\"\",\" \",(J30*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($L30=\"\",\" \",(M30*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($O30=\"\",\" \",(P30*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B30=\"\",\"\",(S30*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C30*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C30*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V26=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C30*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B30=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C30*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B30=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B30))),\"0\")))","v":""}," ",{"$f":"IF($C30=\"\",\" \",(Z30/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!25:25))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($C31=\"\",\" \",(D31*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($F31=\"\",\" \",(G31*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""},{"$f":"IF($I31=\"\",\" \",(I31*27))","v":" "},{"$f":"IF($I31=\"\",\" \",(J31*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($L31=\"\",\" \",(M31*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($O31=\"\",\" \",(P31*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B31=\"\",\"\",(S31*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C31*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C31*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V27=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C31*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B31=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C31*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B31=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B31))),\"0\")))","v":""}," ",{"$f":"IF($C31=\"\",\" \",(Z31/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX('manual inputs'!J:J,SMALL(IF('manual inputs'!J:J<>\"\",ROW('manual inputs'!J:J)),ROW('manual inputs'!26:26))),\"\")","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=C$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($C32=\"\",\" \",(D32*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($F$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=F$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($F32=\"\",\" \",(G32*$E$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($I$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=I$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""},{"$f":"IF($I32=\"\",\" \",(I32*27))","v":" "},{"$f":"IF($I32=\"\",\" \",(J32*$K$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($L$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=L$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($L32=\"\",\" \",(M32*$N$3/'manual inputs_secondary'!$C$17))","v":" "},{"$f":"IF($O$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=O$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($O32=\"\",\" \",(P32*$Q$3/'manual inputs_secondary'!$C$17))","v":" "}," "," ",{"$f":"IF(B32=\"\",\"\",(S32*'manual inputs_secondary'!$C$6))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"Aggregate Base\",\"\",(($C32*27/('manual inputs_secondary'!$D$23/12))/9)*$U$3/'manual inputs_secondary'!$C$16)))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C32*27/('manual inputs_secondary'!$D$23/12))/9)*$V$3/IF(V28=\"Prime Coat - Asphalt Emulsion\",'manual inputs_secondary'!$C$10,'manual inputs_secondary'!$C$8))))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",(((C32*27/('manual inputs_secondary'!$D$23/12))/9)*'manual inputs_secondary'!$C$12)*$W$3/'manual inputs_secondary'!$C$17)))","v":""},{"$f":"IF(B32=\"\",\"\",IF($C$5=\"n/a\",\"\",IF($C$5=\"aggregate base\",\"\",((C32*27/('manual inputs_secondary'!$D$23/12))/9)*$X$3/'manual inputs_secondary'!$C$14)))","v":""},{"$f":"IF($C$5=\"n/a\",\"\",IF(B32=\"\",\"\",IFERROR(INDEX('quantities report_secondary'!$D$2:$D$10003,SMALL(IF('quantities report_secondary'!$A$2:$A$10003=Y$3,ROW('quantities report_secondary'!$A$2:$A$10003)-1,\"\"),ROWS($B$9:$B32))),\"0\")))","v":""}," ",{"$f":"IF($C32=\"\",\" \",(Z32/('manual inputs_secondary'!$C$21/12)/9))","v":" "}]
[null,{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)),ROW(28:28))),\"\")","v":""}]

{"sheet":"calc wrksht-rdwy exc Secondary","index":9,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[]
[null,"EARTHWORK SUMMARY\nUSING ROADWAY EXCAVATION AND EITHER BORROW OR WASTE PAY ITEMS"]
[]
[null,"EXCAVATION (unadjusted volumes)"]
[null,null,"Total Roadway Prism Excavation =",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Approach Road Prism Excavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Pay Item 20401-0000 Roadway Excavation =",{"$f":"SUM(D5:D6)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MATERIAL AVAILABLE FOR FILL (unadjusted volumes)"]
[null,null,"Total Structure Excavation (walls) =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Excavation from Roadway Obliteration = ",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D10:D12)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MATERIAL UNAVAILABLE FOR FILL (unadjusted volumes)"]
[null,null,"Total Pavement Removal in Cuts =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Topsoil Stripping in Cuts =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Waste Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D16:D18)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"TOTAL EXCAVATION AVAILABLE FOR FILLS (adjusted volume)"]
[null,null,"Total Volume After Adjustments Applied (Including Shrink/Swell) =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EMBANKMENT (unadjusted volumes)"]
[null,null,"Total Roadway Prism Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Approach Road Prism Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D25:D26)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"VARIOUS BACKFILL MATERIAL GENERATED ONSITE"]
[null,null,"Total Various Types of Wall Backfill Material =",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Backfill for Pavement Removal Under Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Topsoil Replacement Under Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Riprap =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Special Rock Embankment =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Embankment for Roadway Obliteration =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Topping or Select Topping =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Aggregate Base =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D30:D38)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MINUS EMBANKMENT"]
[null,null,"Total Estimated Excavation Available for Fills =",{"$f":"D22","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Estimated Fill Material Required =",{"$f":"D27+D39","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Excavation - Embankment = ",{"$f":"D42-D43","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"WASTE"]
[null,null,"Estimated Total Pay Item 20441-0000 Waste =",{"$f":"IF(D44>0,D44,\"NA\")","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"BORROW"]
[null,null,"Estimated Unadjusted Volume of Unclassified Borrow Required =",{"$f":"IF(D44<0,ABS(D44), \"NA\" )","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Estimated Shrink / Swell at Borrow Pit Site =",0.9]
[null,null,"Estimated Total Pay Item 20403-0000 Unclassified Borrow  =",{"$f":"IF(D50=\"NA\",\"NA\",ABS((ROUNDUP(D50/D51,0))))","v":{"$error":"#REF!"}},"CUYD"]

{"sheet":"calc wrksht-emb const Secondary","index":10,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[]
[null,"EARTHWORK SUMMARY\nUSING EMBANKMENT CONSTRUCTION PAY ITEM"]
[]
[null,"EXCAVATION (unadjusted volumes)"]
[null,null,"Total Roadway Prism Excavation =",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Approach Road Prism Excavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D5:D6)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MATERIAL AVAILABLE FOR FILL (unadjusted volumes)"]
[null,null,"Total Structure Excavation (walls) =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Excavation from Roadway Obliteration = ",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D10:D12)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MATERIAL UNAVAILABLE FOR FILL (unadjusted volumes)"]
[null,null,"Total Pavement Removal in Cuts =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Topsoil Stripping in Cuts =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Waste Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D16:D18)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"TOTAL EXCAVATION AVAILABLE FOR FILLS (adjusted volume)"]
[null,null,"Total Volume After Adjustments Applied (Including Shrink/Swell) =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EMBANKMENT (unadjusted volumes)"]
[null,null,"Total Roadway Prism Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Approach Road Prism Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D25:D26)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"VARIOUS BACKFILL MATERIAL GENERATED ONSITE"]
[null,null,"Total Various Types of Wall Backfill Material =",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Backfill for Pavement Removal Under Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Topsoil Replacement Under Fill =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Riprap =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Special Rock Embankment =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Embankment for Roadway Obliteration =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Subexcavation =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Topping or Select Topping =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Volume for Aggregate Base =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total =",{"$f":"SUM(D30:D38)","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EXCAVATION MINUS EMBANKMENT"]
[null,null,"Total Estimated Excavation Available for Fills =",{"$f":"D22","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Total Estimated Fill Material Required =",{"$f":"D27+D39","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Excavation - Embankment = ",{"$f":"D42-D43","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"EMBANKMENT CONSTRUCTION"]
[null,null,"Estimated Total Pay Item 20420-0000 Embankment Construction =",{"$f":"D27","v":{"$error":"#REF!"}},"CUYD"]
[]
[null,"UNCLASSIFIED BORROW"]
[null,null,"Estimated Unadjusted Volume of Unclassified Borrow Required =",{"$f":"ABS(#REF!)","v":{"$error":"#REF!"}},"CUYD"]
[null,null,"Estimated Shrink / Swell at Borrow Pit Site =",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Estimated Quantity of Unclassified Borrow Required =",{"$f":"#REF!","v":{"$error":"#REF!"}},"CUYD"]