{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["4MR Gabions","4MR","Long Branch","Grand Total"],"not_rendered":{"external_links":1,"defined_names":7,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"4MR Gabions","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,0,0,5]]}
["THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20____.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":3},"CHECKED BY:"]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Gabions streambank protection (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.23)",350,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,F6)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"SUMIF(E:E,\"SUBTOTAL\",F:F)","v":{"v":0,"d":"$0.00"}}]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",null,"%",null,{"$f":"C14*F10/100","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",null,"%",null,{"$f":"C15*F10/100","v":{"v":0,"d":"$0.00"}}]
[null,null,"PERCENTAGE LINE ITEMS SUBTOTAL",null,null,{"$f":"F14+F15","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":4},"Four Mile Run Gabions :",{"$f":"F10+F16","v":{"v":0,"d":"$0.00"}}]

{"sheet":"4MR","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[1,0,1,5]]}
[{"$nulls":3},"PREPARED BY:"]
["THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20XX.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":3},"CHECKED BY:"]
[]
["C1","GENERAL EARTHWORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT PRICE","TOTAL"]
[null,"Stream Channel Earthwork",16450,"CY",null,{"$f":"C7*E7","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"F7","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",7790,"SY",null,{"$f":"C12*E12","v":{"v":0,"d":"$0.00"}}]
[null,"Tree/Stump Removal - Remove and Dispose, over 6\" DBH (Diameter at Breast Height)",0,"EA",null,{"$f":"C13*E13","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"F12+F13","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Temporary Erosion and Sediment Controls",1,"LS",null,{"$f":"C18*E18","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"F18","v":{"v":0,"d":"$0.00"}}]
[]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"F8+F14+F19","v":{"v":0,"d":"$0.00"}}]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",null,"%",null,{"$f":"C27*F23/100","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",null,"%",null,{"$f":"C28*F23/100","v":{"v":0,"d":"$0.00"}}]
[null,null,"PERCENTAGE LINE ITEMS SUBTOTAL",null,null,{"$f":"F27+F28","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4},"Four Mile Run Project :",{"$f":"F23+F29","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Long Branch","index":2,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[0,0,0,5]]}
["THE UNDERSIGNED CERTIFIES THAT (CONTRACTOR NAME)___________________________\nIS CURRENTLY REGISTERED WITH THE VIRGINIA STATE BOARD OF CONTRACTORS AS REQUIRED BY THE CODE OF VIRGINIA.  CERTIFICATE NUMBER _________________ WAS ISSUED ON THE ________DAY OF _____________, 20XX.  THE UNDERSIGNED FURTHER CERTIFIES THAT THE REGISTRATION FEE AND ALL RENEWAL FEES REQUIRED UNDER LAW HAVE BEEN PAID.  THE CONTRACTOR AGREES TO FURNISH ALL NECESSARY LABOR, EQUIPMENT, MATERIALS, AND ALL THINGS NECESSARY TO PERFORM THE WORK AS SET FORTH IN ACCORDANCE WITH THE PLANS AND SPECIFICATIONS. THE CONTRACTOR AGREES TO PERFORM RELATED WORK FOR THE FOLLOWING ITEMS AT THE FOLLOWING STIPULATED PRICES: (ALL PRICES INCLUDE PROVISION AND INSTALLATION)."]
[{"$nulls":3},"CHECKED BY:"]
[]
["C1","GENERAL EARTHWORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT PRICE","TOTAL"]
[null,"Stream Channel Earthwork",1540,"CY",null,{"$f":"IFERROR($C6*$E6, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,F6)","v":{"v":0,"d":"$0.00"}}]
[]
["C6","WATERMAIN WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Lower and/or relocate 16\" watermain",150,"LF",null,{"$f":"IFERROR($C11*$E11, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUM(F11)","v":{"v":0,"d":"$0.00"}}]
[]
["C11","LANDSCAPE AND HARDSCAPE RESTORATION WORK"]
["MASTER ITEM #","DESCRIPTION","QTY","UNIT","UNIT\nPRICE","TOTAL"]
["02801-C11-00050","Seed, Mixture of 85% Tall Fescue/Bluegrass and 15% Annual Rye",1890,"SY",null,{"$f":"IFERROR($C16*$E16, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Tree/Stump Removal - Remove and Dispose, over 6\" DBH (Diameter at Breast Height)",26,"EA",null,{"$f":"IFERROR($C17*$E17, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"F16+F17","v":{"v":0,"d":"$0.00"}}]
[]
["C13","EROSION AND SEDIMENT CONTROL WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Temporary Erosion and Sediment Controls",1,"LS",null,{"$f":"IFERROR($C22*$E22, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,F22:F22)","v":{"v":0,"d":"$0.00"}}]
[]
["C17","STORMWATER WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Gabions streambank protection (per Virginia Erosion & Sediment Control Handbook Standard & Specification 3.23)",50,"CY",null,{"$f":"IFERROR($C27*$E27, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,F27)","v":{"v":0,"d":"$0.00"}}]
[]
[]
["C18","OTHER WORK"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
[null,"Lower and/or relocate 4\" gas line",150,"LF",null,{"$f":"IFERROR($C33*$E33, \"\")","v":{"v":0,"d":"$0.00"}}]
[null,"Lower and/or relocate 8\" gas line",150,"LF",null,{"$f":"IFERROR($C34*$E34, \"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"SUBTOTAL",{"$f":"SUBTOTAL(109,F33:F34)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4}," CONTRACT TOTAL (EXCLUDING PERCENTAGE ITEMS)",{"$f":"F18+F12+F7+F23+F28+F35","v":{"v":0,"d":"$0.00"}}]
[]
["PCT","PERCENTAGE LINE ITEMS"]
["MASTER ITEM #","DESCRIPTION","EST. QTY","UNIT","UNIT\nPRICE","TOTAL"]
["01000-C16-00010","Maintenance of Traffic (MOT)",null,"%",null,{"$f":"C42*F38/100","v":{"v":0,"d":"$0.00"}}]
["01000-C16-00030","Mobilization and De-Mobilization",null,"%",null,{"$f":"C43*F38/100","v":{"v":0,"d":"$0.00"}}]
[null,null,"PERCENTAGE LINE ITEMS SUBTOTAL",null,null,{"$f":"F42+F43","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4},"Long Branch Project :",{"$f":"$F$44+F38","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Grand Total","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["Four Mile Run Gabions",null,{"$f":"'4MR Gabions'!F18","v":{"v":0,"d":"$0.00"}}]
["Four Mile Run ",null,{"$f":"'4MR'!F32","v":{"v":0,"d":"$0.00"}}]
["Long Branch",null,{"$f":"'Long Branch'!F47","v":{"v":0,"d":"$0.00"}}]
["GRAND TOTAL",null,{"$f":"C1+C2+C3","v":{"v":0,"d":"$0.00"}}]