{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Responses"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":702,"n_cols":702,"rows_kept":702,"merged":[[7,1,7,4],[11,1,11,4]]}
{"$rows_empty":7}
[null,"Glassford Hill Road – Long Look Drive to SR 89A BidTable (BT-19BW)"]
[]
[null,"Instructions"]
[]
[null,"- When pasting content, please use Paste Special as Text without any formatting.\n\n- You can only submit text based responses, please do not use special characters like emojis.\n\n- Please do not change the structure of any of the worksheets. Changing the structure will invalidate your submission.\n\n- Any additional information outside of the given structure of the worksheets will not be visible to the purchaser.\n\n- Please do not save this file in a different format. Saving this file in a different format will invalidate your submission.\n\n- Please follow the instructions provided along with this file to submit it back to Euna Procurement.\n\n- You must bid on every item. To do so, all of the editable cells for the item must contain a valid value.\n\n- Please do not use Excel formulas in your responses.\n\n- If you have any questions regarding the content of this file, please contact the appropriate purchaser.\n\n- If you have any technical problems, please contact Euna Procurement at support.bonfire@eunasolutions.com."]
{"$rows_empty":689}
[{"$nulls":701},"cffd0b174b2245cc5789a774fce1195761e377ec2203b46df43ef59b86ba2bc5f53adee3f749cf5f5115c4d57cc8313eb77063a79551d83de1e3132e752ac405D39Jia+9DzEmq5Mf6ITBMn2Xgna/zmY7c5CoKdK8YxuH1MXGiHbAc5w4E/Z/5nP4"]

{"sheet":"Responses","index":1,"n_rows":132,"n_cols":10,"rows_kept":132}
[]
[null,"Responses"]
[null,{"$f":"IF((COUNTIF(B7:B131, \"Error*\") + COUNTIF(I3:I3, \"Error*\")) > 0, \"Error: Check cell(s)\" &IF(COUNTIF(B7:B131, \"Error*\") > 0, (\" \" & ADDRESS(7 + MATCH(\"Error*\", B7:B131, 0) - 1, COLUMN(), 4)), \"\") & IF(COUNTIF(I3:I3, \"Error*\") > 0, (\" \" & ADDRESS(ROW(), 9 + MATCH(\"Error*\", I3:I3, 0) - 1, 4)), \"\"), \"Success: All data is valid!\")","v":"Error: Check cell(s) B8"},{"$nulls":6},{"$f":"IFERROR(\"Error: Cell \" & ADDRESS((7 + MATCH(FALSE, INDEX(NOT(NOT(ISNUMBER(I7:I131)) * NOT(ISBLANK(I7:I131))), 0), 0) - 1), COLUMN(), 4) & \" must be Numeric\", \"\")","v":""}]
[{"$nulls":8},"Numeric"]
[null,"Status",null,"#","Item","Notes","Quantity Required","Unit","Unit Price","Total Cost"]
[null,"Helper:ResponseStatus","BidTableItem:BidTableItemID","Helper:BidTableBasketOrderWithItemOrder","BidTableItem:ItemName","BidTableItem:343559","BidTableItem:343272","BidTableItem:343276","BidTableItemResponse:294861","BidTableFormula:148991"]
[null,"General Construction Items"]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I8), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I8), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I8"},3484128,"#1-1","\nConstruction Stakes, Lines and Grade\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G8\")), NA(), INDIRECT(\"G8\")) * IF(ISBLANK(INDIRECT(\"I8\")), NA(), INDIRECT(\"I8\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I9",3484130,"#1-2","\nStorm Water Pollution Prevention Plan (SWPPP)\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G9\")), NA(), INDIRECT(\"G9\")) * IF(ISBLANK(INDIRECT(\"I9\")), NA(), INDIRECT(\"I9\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I10",3484131,"#1-3","\nMobilization/Demobilization\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G10\")), NA(), INDIRECT(\"G10\")) * IF(ISBLANK(INDIRECT(\"I10\")), NA(), INDIRECT(\"I10\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I11",3484132,"#1-4","\nQuality Control\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G11\")), NA(), INDIRECT(\"G11\")) * IF(ISBLANK(INDIRECT(\"I11\")), NA(), INDIRECT(\"I11\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I12",3484134,"#1-5","\nTraffic Control\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G12\")), NA(), INDIRECT(\"G12\")) * IF(ISBLANK(INDIRECT(\"I12\")), NA(), INDIRECT(\"I12\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I13",3484135,"#1-6","\nTraffic Control Devices\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G13\")), NA(), INDIRECT(\"G13\")) * IF(ISBLANK(INDIRECT(\"I13\")), NA(), INDIRECT(\"I13\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I14",3484136,"#1-7","\nBarricades and Storage\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G14\")), NA(), INDIRECT(\"G14\")) * IF(ISBLANK(INDIRECT(\"I14\")), NA(), INDIRECT(\"I14\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I15",3484137,"#1-8","\nMessage Boards\n",null,280,"DAY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G15\")), NA(), INDIRECT(\"G15\")) * IF(ISBLANK(INDIRECT(\"I15\")), NA(), INDIRECT(\"I15\")), \"-\")","v":"-"}]
[null,"Basket Total",{"$nulls":7},{"$f":"SUM(J8:J15)","v":{"v":0,"d":"$ 0.00"}}]
[]
[null,"Removal Items"]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I19), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I19), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I19"},3484104,"#2-1","\nRoadway Embankment\n",null,2145,"CY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G19\")), NA(), INDIRECT(\"G19\")) * IF(ISBLANK(INDIRECT(\"I19\")), NA(), INDIRECT(\"I19\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I20",3484105,"#2-2","\nUnsuitable Material Remediation - \nProvisionary Item May or May Not be Used\n",null,1000,"CY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G20\")), NA(), INDIRECT(\"G20\")) * IF(ISBLANK(INDIRECT(\"I20\")), NA(), INDIRECT(\"I20\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I21",3484106,"#2-3","\nMill and Dispose Asphalt Pavement (2\")\n",null,99835,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G21\")), NA(), INDIRECT(\"G21\")) * IF(ISBLANK(INDIRECT(\"I21\")), NA(), INDIRECT(\"I21\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I22",3484107,"#2-4","\nRemove Pavement\n",null,2195,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G22\")), NA(), INDIRECT(\"G22\")) * IF(ISBLANK(INDIRECT(\"I22\")), NA(), INDIRECT(\"I22\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I23",3484108,"#2-5","\nRemove and Dispose Curb and Gutter\n",null,4880,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G23\")), NA(), INDIRECT(\"G23\")) * IF(ISBLANK(INDIRECT(\"I23\")), NA(), INDIRECT(\"I23\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I24",3484109,"#2-6","\nRemove and Dispose Vertical Curb\n",null,4190,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G24\")), NA(), INDIRECT(\"G24\")) * IF(ISBLANK(INDIRECT(\"I24\")), NA(), INDIRECT(\"I24\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I25",3484110,"#2-7","\nRemove and Dispose Storm Structures (drain grates, headwall, scupper, and catch basin)\n",null,7,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G25\")), NA(), INDIRECT(\"G25\")) * IF(ISBLANK(INDIRECT(\"I25\")), NA(), INDIRECT(\"I25\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I26",3484111,"#2-8","\nRemove and Dispose Concrete\n",null,5435,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G26\")), NA(), INDIRECT(\"G26\")) * IF(ISBLANK(INDIRECT(\"I26\")), NA(), INDIRECT(\"I26\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I27",3484112,"#2-9","\nRemove and Relocate Utility Box\n",null,14,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G27\")), NA(), INDIRECT(\"G27\")) * IF(ISBLANK(INDIRECT(\"I27\")), NA(), INDIRECT(\"I27\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I28",3484113,"#2-10","\nRemove and Dispose Blowoff Valve\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G28\")), NA(), INDIRECT(\"G28\")) * IF(ISBLANK(INDIRECT(\"I28\")), NA(), INDIRECT(\"I28\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I29",3484114,"#2-11","\nRemove and Dispose 12\" HDPE pipe\n",null,105,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G29\")), NA(), INDIRECT(\"G29\")) * IF(ISBLANK(INDIRECT(\"I29\")), NA(), INDIRECT(\"I29\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I30",3484115,"#2-12","\nRemove and Dispose 18\" HDPE pipe\n",null,45,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G30\")), NA(), INDIRECT(\"G30\")) * IF(ISBLANK(INDIRECT(\"I30\")), NA(), INDIRECT(\"I30\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I31",3484116,"#2-13","\nRemove and Dispose 24\" HDPE pipe\n",null,55,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G31\")), NA(), INDIRECT(\"G31\")) * IF(ISBLANK(INDIRECT(\"I31\")), NA(), INDIRECT(\"I31\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I32",3484117,"#2-14","\nRemove and Dispose 16\" DIP Effluent Main\n",null,45,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G32\")), NA(), INDIRECT(\"G32\")) * IF(ISBLANK(INDIRECT(\"I32\")), NA(), INDIRECT(\"I32\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I33",3484118,"#2-15","\nRemove and Reuse Existing RipRap\n",null,50,"CY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G33\")), NA(), INDIRECT(\"G33\")) * IF(ISBLANK(INDIRECT(\"I33\")), NA(), INDIRECT(\"I33\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I34",3484119,"#2-16","\nRemove and Relocate Existing Sign\n",null,28,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G34\")), NA(), INDIRECT(\"G34\")) * IF(ISBLANK(INDIRECT(\"I34\")), NA(), INDIRECT(\"I34\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I35",3484120,"#2-17","\nRemove and Replace Existing Sign\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G35\")), NA(), INDIRECT(\"G35\")) * IF(ISBLANK(INDIRECT(\"I35\")), NA(), INDIRECT(\"I35\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I36",3484121,"#2-18","\nAdjust to Grade Survey Marker\n",null,6,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G36\")), NA(), INDIRECT(\"G36\")) * IF(ISBLANK(INDIRECT(\"I36\")), NA(), INDIRECT(\"I36\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I37",3484122,"#2-19","\nRemove Granville Monument Sign\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G37\")), NA(), INDIRECT(\"G37\")) * IF(ISBLANK(INDIRECT(\"I37\")), NA(), INDIRECT(\"I37\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I38",3484123,"#2-20","\nRemove and Reset Existing Fence\n",null,135,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G38\")), NA(), INDIRECT(\"G38\")) * IF(ISBLANK(INDIRECT(\"I38\")), NA(), INDIRECT(\"I38\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I39",3484124,"#2-21","\nRemove and Salvage Existing Sign\n",null,28,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G39\")), NA(), INDIRECT(\"G39\")) * IF(ISBLANK(INDIRECT(\"I39\")), NA(), INDIRECT(\"I39\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I40",3484125,"#2-22","\nRemove and Dispose Existing Pull Box\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G40\")), NA(), INDIRECT(\"G40\")) * IF(ISBLANK(INDIRECT(\"I40\")), NA(), INDIRECT(\"I40\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I41",3484126,"#2-23","\nSignal Pole Foundation Abandonment\n",null,6,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G41\")), NA(), INDIRECT(\"G41\")) * IF(ISBLANK(INDIRECT(\"I41\")), NA(), INDIRECT(\"I41\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I42",3484127,"#2-24","\nRemove and Reset Existing Luminaire\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G42\")), NA(), INDIRECT(\"G42\")) * IF(ISBLANK(INDIRECT(\"I42\")), NA(), INDIRECT(\"I42\")), \"-\")","v":"-"}]
[null,"Basket Total",{"$nulls":7},{"$f":"SUM(J19:J42)","v":{"v":0,"d":"$ 0.00"}}]
[]
[null,"Improvement Items"]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I46), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I46), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I46"},3484138,"#3-1","\n8\" Subgrade Preparation\n",null,26400,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G46\")), NA(), INDIRECT(\"G46\")) * IF(ISBLANK(INDIRECT(\"I46\")), NA(), INDIRECT(\"I46\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I47",3484139,"#3-2","\n4\" Aggregate Base Course for SUP\n",null,5717,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G47\")), NA(), INDIRECT(\"G47\")) * IF(ISBLANK(INDIRECT(\"I47\")), NA(), INDIRECT(\"I47\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I48",3484140,"#3-3","\n13\" Aggregate Base Course\n",null,26400,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G48\")), NA(), INDIRECT(\"G48\")) * IF(ISBLANK(INDIRECT(\"I48\")), NA(), INDIRECT(\"I48\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I49",3484141,"#3-4","\n7\" Asphalt Concrete (AC) Pavement\n",null,26400,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G49\")), NA(), INDIRECT(\"G49\")) * IF(ISBLANK(INDIRECT(\"I49\")), NA(), INDIRECT(\"I49\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I50",3484142,"#3-5","\n3\" Asphalt Concrete (AC) Pavement for SUP\n",null,5717,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G50\")), NA(), INDIRECT(\"G50\")) * IF(ISBLANK(INDIRECT(\"I50\")), NA(), INDIRECT(\"I50\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I51",3484143,"#3-6","\n3\" Asphalt Concrete (AC) Pavement\n",null,99835,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G51\")), NA(), INDIRECT(\"G51\")) * IF(ISBLANK(INDIRECT(\"I51\")), NA(), INDIRECT(\"I51\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I52",3484144,"#3-7","\nAC Bituminous Tack Coat, Type SS1h-\n",null,152635,"SY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G52\")), NA(), INDIRECT(\"G52\")) * IF(ISBLANK(INDIRECT(\"I52\")), NA(), INDIRECT(\"I52\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I53",3484145,"#3-8","\n4\" White Striping (Epoxy)\n",null,71415,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G53\")), NA(), INDIRECT(\"G53\")) * IF(ISBLANK(INDIRECT(\"I53\")), NA(), INDIRECT(\"I53\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I54",3484146,"#3-9","\n4\" Yellow Striping (Epoxy)\n",null,20648,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G54\")), NA(), INDIRECT(\"G54\")) * IF(ISBLANK(INDIRECT(\"I54\")), NA(), INDIRECT(\"I54\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I55",3484147,"#3-10","\n4\" Yellow Striping - SUP (Paint)\n",null,5205,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G55\")), NA(), INDIRECT(\"G55\")) * IF(ISBLANK(INDIRECT(\"I55\")), NA(), INDIRECT(\"I55\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I56",3484148,"#3-11","\n6\" White Striping (Epoxy)\n",null,920,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G56\")), NA(), INDIRECT(\"G56\")) * IF(ISBLANK(INDIRECT(\"I56\")), NA(), INDIRECT(\"I56\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I57",3484149,"#3-12","\n6\" Yellow Striping (Epoxy)\n",null,920,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G57\")), NA(), INDIRECT(\"G57\")) * IF(ISBLANK(INDIRECT(\"I57\")), NA(), INDIRECT(\"I57\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I58",3484150,"#3-13","\n8\" White Striping (Epoxy)\n",null,5555,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G58\")), NA(), INDIRECT(\"G58\")) * IF(ISBLANK(INDIRECT(\"I58\")), NA(), INDIRECT(\"I58\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I59",3484151,"#3-14","\n12\" White Striping (Epoxy)\n",null,5600,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G59\")), NA(), INDIRECT(\"G59\")) * IF(ISBLANK(INDIRECT(\"I59\")), NA(), INDIRECT(\"I59\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I60",3484152,"#3-15","\n18\" White Striping (Epoxy)\n",null,900,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G60\")), NA(), INDIRECT(\"G60\")) * IF(ISBLANK(INDIRECT(\"I60\")), NA(), INDIRECT(\"I60\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I61",3484153,"#3-16","\nTemporary Waterborne Striping [ADOT Section 708-2.01(A)(1)]\n",null,111163,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G61\")), NA(), INDIRECT(\"G61\")) * IF(ISBLANK(INDIRECT(\"I61\")), NA(), INDIRECT(\"I61\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I62",3484154,"#3-17","\nRight Turn Arrow, ADOT Std. Dtl. M-10\n",null,26,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G62\")), NA(), INDIRECT(\"G62\")) * IF(ISBLANK(INDIRECT(\"I62\")), NA(), INDIRECT(\"I62\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I63",3484155,"#3-18","\nLeft Turn Arrow, ADOT Std. Dtl. M10-\n",null,35,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G63\")), NA(), INDIRECT(\"G63\")) * IF(ISBLANK(INDIRECT(\"I63\")), NA(), INDIRECT(\"I63\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I64",3484156,"#3-19","\nThru Arrow, ADOT Std. Dtl. M-10\n",null,9,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G64\")), NA(), INDIRECT(\"G64\")) * IF(ISBLANK(INDIRECT(\"I64\")), NA(), INDIRECT(\"I64\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I65",3484157,"#3-20","\nONLY' Pavement Marking, ADOT Std. Dtl. M-7\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G65\")), NA(), INDIRECT(\"G65\")) * IF(ISBLANK(INDIRECT(\"I65\")), NA(), INDIRECT(\"I65\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I66",3484158,"#3-21","\n6\" Vertical Curb and Gutter, Quad City Std. Dtl. 220Q-1, Type A'\n",null,23055,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G66\")), NA(), INDIRECT(\"G66\")) * IF(ISBLANK(INDIRECT(\"I66\")), NA(), INDIRECT(\"I66\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I67",3484159,"#3-22","\n6\" Single Vertical Curb, Quad City Std. Dtl. 220Q-1, Type A'\n",null,5390,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G67\")), NA(), INDIRECT(\"G67\")) * IF(ISBLANK(INDIRECT(\"I67\")), NA(), INDIRECT(\"I67\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I68",3484160,"#3-23","\nCurb Ramp\n",null,17,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G68\")), NA(), INDIRECT(\"G68\")) * IF(ISBLANK(INDIRECT(\"I68\")), NA(), INDIRECT(\"I68\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I69",3484161,"#3-24","\n4\" Concrete Sidewalk\n",null,87694,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G69\")), NA(), INDIRECT(\"G69\")) * IF(ISBLANK(INDIRECT(\"I69\")), NA(), INDIRECT(\"I69\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I70",3484162,"#3-25","\n6\" Concrete Sidewalk\n",null,600,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G70\")), NA(), INDIRECT(\"G70\")) * IF(ISBLANK(INDIRECT(\"I70\")), NA(), INDIRECT(\"I70\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I71",3484163,"#3-26","\nAdjust Existing Water Valve Box and Cover, Quad City Std. Dtl. 391Q\n",null,7,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G71\")), NA(), INDIRECT(\"G71\")) * IF(ISBLANK(INDIRECT(\"I71\")), NA(), INDIRECT(\"I71\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I72",3484164,"#3-27","\nAdjust Existing Manhole Frame and Cover, Quad City Std. Dtl. 422Q\n",null,7,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G72\")), NA(), INDIRECT(\"G72\")) * IF(ISBLANK(INDIRECT(\"I72\")), NA(), INDIRECT(\"I72\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I73",3484165,"#3-28","\nAluminum Sign Panel (Diamond Grade), Quad City Std. Dtl. 106-P and 131Q\n",null,400,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G73\")), NA(), INDIRECT(\"G73\")) * IF(ISBLANK(INDIRECT(\"I73\")), NA(), INDIRECT(\"I73\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I74",3484166,"#3-29","\nObject Marker, OM1-2\n",null,5,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G74\")), NA(), INDIRECT(\"G74\")) * IF(ISBLANK(INDIRECT(\"I74\")), NA(), INDIRECT(\"I74\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I75",3484167,"#3-30","\nSign Post, Quad City Std. Dtl. 131Q\n",null,19,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G75\")), NA(), INDIRECT(\"G75\")) * IF(ISBLANK(INDIRECT(\"I75\")), NA(), INDIRECT(\"I75\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I76",3484168,"#3-31","\nSign Post Foundation, Quad City Std. Dtl. 131Q\n",null,19,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G76\")), NA(), INDIRECT(\"G76\")) * IF(ISBLANK(INDIRECT(\"I76\")), NA(), INDIRECT(\"I76\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I77",3484169,"#3-32","\nSign Post Slip Base, Quad City Std. Dtl. 131Q\n",null,19,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G77\")), NA(), INDIRECT(\"G77\")) * IF(ISBLANK(INDIRECT(\"I77\")), NA(), INDIRECT(\"I77\")), \"-\")","v":"-"}]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I78), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I78), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I78"},3484170,"#3-33","\nTree (15 Gallon)\n",null,42,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G78\")), NA(), INDIRECT(\"G78\")) * IF(ISBLANK(INDIRECT(\"I78\")), NA(), INDIRECT(\"I78\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I79",3484171,"#3-34","\nShrub (5 Gallon)\n",null,398,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G79\")), NA(), INDIRECT(\"G79\")) * IF(ISBLANK(INDIRECT(\"I79\")), NA(), INDIRECT(\"I79\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I80",3484172,"#3-35","\nRock Mulch\n",null,251845,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G80\")), NA(), INDIRECT(\"G80\")) * IF(ISBLANK(INDIRECT(\"I80\")), NA(), INDIRECT(\"I80\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I81",3484173,"#3-36","\n1-3\" Rock Mulch\n",null,4315,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G81\")), NA(), INDIRECT(\"G81\")) * IF(ISBLANK(INDIRECT(\"I81\")), NA(), INDIRECT(\"I81\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I82",3484174,"#3-37","\nDecorative Boulder (3')\n",null,29,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G82\")), NA(), INDIRECT(\"G82\")) * IF(ISBLANK(INDIRECT(\"I82\")), NA(), INDIRECT(\"I82\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I83",3484175,"#3-38","\nDecorative Boulder (2')\n",null,31,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G83\")), NA(), INDIRECT(\"G83\")) * IF(ISBLANK(INDIRECT(\"I83\")), NA(), INDIRECT(\"I83\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I84",3484176,"#3-39","\nStormwater Harvesting Basin\n",null,4315,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G84\")), NA(), INDIRECT(\"G84\")) * IF(ISBLANK(INDIRECT(\"I84\")), NA(), INDIRECT(\"I84\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I85",3484177,"#3-40","\nRock Sediment Trap\n",null,3,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G85\")), NA(), INDIRECT(\"G85\")) * IF(ISBLANK(INDIRECT(\"I85\")), NA(), INDIRECT(\"I85\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I86",3484178,"#3-41","\nConnect to & Expand Existing Irrigation System\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G86\")), NA(), INDIRECT(\"G86\")) * IF(ISBLANK(INDIRECT(\"I86\")), NA(), INDIRECT(\"I86\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I87",3484179,"#3-42","\nCatch Basin, MAG 533-1, Type D\n",null,4,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G87\")), NA(), INDIRECT(\"G87\")) * IF(ISBLANK(INDIRECT(\"I87\")), NA(), INDIRECT(\"I87\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I88",3484180,"#3-43","\nCurb Inlet, MAG 532\n",null,3,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G88\")), NA(), INDIRECT(\"G88\")) * IF(ISBLANK(INDIRECT(\"I88\")), NA(), INDIRECT(\"I88\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I89",3484181,"#3-44","\nConcrete Scupper, MAG Std. Dtl. 206, 2-Cell\n",null,10,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G89\")), NA(), INDIRECT(\"G89\")) * IF(ISBLANK(INDIRECT(\"I89\")), NA(), INDIRECT(\"I89\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I90",3484182,"#3-45","\nConcrete Scupper, MAG Std. Dtl. 206, 3-Cell\n",null,11,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G90\")), NA(), INDIRECT(\"G90\")) * IF(ISBLANK(INDIRECT(\"I90\")), NA(), INDIRECT(\"I90\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I91",3484183,"#3-46","\nConcrete Scupper, MAG Std. Dtl. 206, 2-Cell without railing\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G91\")), NA(), INDIRECT(\"G91\")) * IF(ISBLANK(INDIRECT(\"I91\")), NA(), INDIRECT(\"I91\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I92",3484184,"#3-47","\nConcrete Scupper, MAG Std. Dtl. 206, 3-Cell without railing\n",null,3,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G92\")), NA(), INDIRECT(\"G92\")) * IF(ISBLANK(INDIRECT(\"I92\")), NA(), INDIRECT(\"I92\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I93",3484185,"#3-48","\n18\" HDPE Storm Drain Pipe\n",null,150,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G93\")), NA(), INDIRECT(\"G93\")) * IF(ISBLANK(INDIRECT(\"I93\")), NA(), INDIRECT(\"I93\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I94",3484186,"#3-49","\n24\" CMP Storm Drain Pipe\n",null,350,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G94\")), NA(), INDIRECT(\"G94\")) * IF(ISBLANK(INDIRECT(\"I94\")), NA(), INDIRECT(\"I94\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I95",3484187,"#3-50","\nEnd Section\n",null,4,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G95\")), NA(), INDIRECT(\"G95\")) * IF(ISBLANK(INDIRECT(\"I95\")), NA(), INDIRECT(\"I95\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I96",3484188,"#3-51","\nNyloplast 24\" Basin, Det. 7001-110-192E\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G96\")), NA(), INDIRECT(\"G96\")) * IF(ISBLANK(INDIRECT(\"I96\")), NA(), INDIRECT(\"I96\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I97",3484189,"#3-52","\nConnect to Existing Box Culvert\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G97\")), NA(), INDIRECT(\"G97\")) * IF(ISBLANK(INDIRECT(\"I97\")), NA(), INDIRECT(\"I97\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I98",3484190,"#3-53","\nRipRap, D50=6\"\n",null,94,"CY",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G98\")), NA(), INDIRECT(\"G98\")) * IF(ISBLANK(INDIRECT(\"I98\")), NA(), INDIRECT(\"I98\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I99",3484191,"#3-54","\nCurb Opening, MAG Std. Dtl. 226-1\n",null,12,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G99\")), NA(), INDIRECT(\"G99\")) * IF(ISBLANK(INDIRECT(\"I99\")), NA(), INDIRECT(\"I99\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I100",3484192,"#3-55","\nRetaining Wall (Reinforced Concrete Cantilever)\n",null,25583,"SF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G100\")), NA(), INDIRECT(\"G100\")) * IF(ISBLANK(INDIRECT(\"I100\")), NA(), INDIRECT(\"I100\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I101",3484193,"#3-56","\nSafety Railing\n",null,3247,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G101\")), NA(), INDIRECT(\"G101\")) * IF(ISBLANK(INDIRECT(\"I101\")), NA(), INDIRECT(\"I101\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I102",3484194,"#3-57","\nRailing, MAG Std. Dtl. 145\n",null,1170,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G102\")), NA(), INDIRECT(\"G102\")) * IF(ISBLANK(INDIRECT(\"I102\")), NA(), INDIRECT(\"I102\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I103",3484195,"#3-58","\nStairway\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G103\")), NA(), INDIRECT(\"G103\")) * IF(ISBLANK(INDIRECT(\"I103\")), NA(), INDIRECT(\"I103\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I104",3484196,"#3-59","\nPole Foundation, Type A, ADOT T-SL 4.01\n",null,9,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G104\")), NA(), INDIRECT(\"G104\")) * IF(ISBLANK(INDIRECT(\"I104\")), NA(), INDIRECT(\"I104\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I105",3484197,"#3-60","\nPole Foundation, Type G, ADOT T-SL 4.07\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G105\")), NA(), INDIRECT(\"G105\")) * IF(ISBLANK(INDIRECT(\"I105\")), NA(), INDIRECT(\"I105\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I106",3484198,"#3-61","\nPole Foundation, Type W, ADOT T-SL 4.17\n",null,6,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G106\")), NA(), INDIRECT(\"G106\")) * IF(ISBLANK(INDIRECT(\"I106\")), NA(), INDIRECT(\"I106\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I107",3484199,"#3-62","\nPedestrian Push Button w/Sign\n",null,20,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G107\")), NA(), INDIRECT(\"G107\")) * IF(ISBLANK(INDIRECT(\"I107\")), NA(), INDIRECT(\"I107\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I108",3484200,"#3-63","\nType A Signal Pole 12', ADOT T-SL 4.01\n",null,9,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G108\")), NA(), INDIRECT(\"G108\")) * IF(ISBLANK(INDIRECT(\"I108\")), NA(), INDIRECT(\"I108\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I109",3484201,"#3-64","\nType G Pole, ADOT T-SL 4.07\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G109\")), NA(), INDIRECT(\"G109\")) * IF(ISBLANK(INDIRECT(\"I109\")), NA(), INDIRECT(\"I109\")), \"-\")","v":"-"}]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I110), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I110), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I110"},3484202,"#3-65","\nType W Signal Pole 60' Span, ADOT T-SL 4.17\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G110\")), NA(), INDIRECT(\"G110\")) * IF(ISBLANK(INDIRECT(\"I110\")), NA(), INDIRECT(\"I110\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I111",3484203,"#3-66","\nType W Signal Pole 65' Span, ADOT T-SL 4.17\n",null,4,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G111\")), NA(), INDIRECT(\"G111\")) * IF(ISBLANK(INDIRECT(\"I111\")), NA(), INDIRECT(\"I111\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I112",3484204,"#3-67","\nSignal Indication Type 'F' Signal Face\n",null,24,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G112\")), NA(), INDIRECT(\"G112\")) * IF(ISBLANK(INDIRECT(\"I112\")), NA(), INDIRECT(\"I112\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I113",3484205,"#3-68","\nSignal Indication Type 'G' Signal Face\n",null,13,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G113\")), NA(), INDIRECT(\"G113\")) * IF(ISBLANK(INDIRECT(\"I113\")), NA(), INDIRECT(\"I113\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I114",3484206,"#3-69","\nSky Bracket Mounting Assembly\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G114\")), NA(), INDIRECT(\"G114\")) * IF(ISBLANK(INDIRECT(\"I114\")), NA(), INDIRECT(\"I114\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I115",3484207,"#3-70","\nType II Mounting Assembly\n",null,20,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G115\")), NA(), INDIRECT(\"G115\")) * IF(ISBLANK(INDIRECT(\"I115\")), NA(), INDIRECT(\"I115\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I116",3484208,"#3-71","\nType V Mounting Assembly\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G116\")), NA(), INDIRECT(\"G116\")) * IF(ISBLANK(INDIRECT(\"I116\")), NA(), INDIRECT(\"I116\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I117",3484209,"#3-72","\nType VI Mounting Assembly\n",null,9,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G117\")), NA(), INDIRECT(\"G117\")) * IF(ISBLANK(INDIRECT(\"I117\")), NA(), INDIRECT(\"I117\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I118",3484210,"#3-73","\nType VII Mounting Assembly\n",null,7,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G118\")), NA(), INDIRECT(\"G118\")) * IF(ISBLANK(INDIRECT(\"I118\")), NA(), INDIRECT(\"I118\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I119",3484211,"#3-74","\nType VIII Mounting Assembly\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G119\")), NA(), INDIRECT(\"G119\")) * IF(ISBLANK(INDIRECT(\"I119\")), NA(), INDIRECT(\"I119\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I120",3484212,"#3-75","\nPull Box\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G120\")), NA(), INDIRECT(\"G120\")) * IF(ISBLANK(INDIRECT(\"I120\")), NA(), INDIRECT(\"I120\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I121",3484213,"#3-76","\nSignal Conduit\n",null,1,"LS",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G121\")), NA(), INDIRECT(\"G121\")) * IF(ISBLANK(INDIRECT(\"I121\")), NA(), INDIRECT(\"I121\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I122",3484214,"#3-77","\n16\" Effluent Line\n",null,2230,"LF",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G122\")), NA(), INDIRECT(\"G122\")) * IF(ISBLANK(INDIRECT(\"I122\")), NA(), INDIRECT(\"I122\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I123",3484215,"#3-78","\n16\" Effluent Gate Valve\n",null,2,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G123\")), NA(), INDIRECT(\"G123\")) * IF(ISBLANK(INDIRECT(\"I123\")), NA(), INDIRECT(\"I123\")), \"-\")","v":"-"}]
[null,"Error: Missing value for 'Unit Price' in cell I124",3484216,"#3-79","\n16\" Effluent Air Release Valve\n",null,1,"EA",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G124\")), NA(), INDIRECT(\"G124\")) * IF(ISBLANK(INDIRECT(\"I124\")), NA(), INDIRECT(\"I124\")), \"-\")","v":"-"}]
[null,"Basket Total",{"$nulls":7},{"$f":"SUM(J46:J124)","v":{"v":0,"d":"$ 0.00"}}]
[]
[null,"Fixed Price Items"]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I128), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I128), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I128"},3484129,"#4-1","\nPublic Relations\n","Enter \"1\" for this Unit Price as this is considered a Fixed Price item.",30000,"ALL",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G128\")), NA(), INDIRECT(\"G128\")) * IF(ISBLANK(INDIRECT(\"I128\")), NA(), INDIRECT(\"I128\")), \"-\")","v":"-"}]
[null,{"$f":"IFERROR(\"Error: Missing value for '\" & INDIRECT(ADDRESS(5, (9 + IF(ISBLANK(I129), 1, NA()) - 1))) & \"' in cell \" & ADDRESS(ROW(), (9 + IF(ISBLANK(I129), 1, NA()) - 1), 4), \"Success: All values provided\")","v":"Error: Missing value for 'Unit Price' in cell I129"},3484133,"#4-2","\nOwners Contract Allowance\n","Enter \"1\" for this Unit Price as this is considered a Fixed Price item.",200000,"ALL",null,{"$f":"IFERROR(IF(ISBLANK(INDIRECT(\"G129\")), NA(), INDIRECT(\"G129\")) * IF(ISBLANK(INDIRECT(\"I129\")), NA(), INDIRECT(\"I129\")), \"-\")","v":"-"}]
[null,"Basket Total",{"$nulls":7},{"$f":"SUM(J128:J129)","v":{"v":0,"d":"$ 0.00"}}]
[]
[null,"Grand Total",{"$nulls":7},{"$f":"SUM(J8:J15,J19:J42,J46:J124,J128:J129)","v":{"v":0,"d":"$ 0.00"}}]