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

{"sheet":"All","index":0,"n_rows":162,"n_cols":6,"rows_kept":162,"merged":[[0,2,0,5],[3,0,3,5],[157,0,157,4]]}
[null,null,"FENCING INSTALLATION, REMOVAL, & REPAIR  ITB 20391 - REVISED BID SCHEDULE"]
["Item #","Description","Unit of Measure (UOM)","Estimated Quanty (Est Qty)","Unit Price","Extended Price"]
["A-B","VINYL, CHAIN LINK, BLACK, 6 GAUGE, Finish furnish & install-includes fabric, line posts,post caps, concrete footings, tension wires, and fittings. Terminal post, stretcher bar, and hardware not included. "]
["Enter unit price in blue area. Extended price and total will be calculated."]
[1,"Fencing  3'","LF",100,null,{"$f":"E5*D5","v":0}]
[{"$f":"+A5+1","v":2},"Fencing  4 '","LF",1250,null,{"$f":"E6*D6","v":0}]
[{"$f":"+A6+1","v":3},"Fencing  6'","LF",2192,null,{"$f":"E7*D7","v":0}]
[{"$f":"+A7+1","v":4},"Fencing 7'","LF",500,null,{"$f":"E8*D8","v":0}]
[5,"Fencing  8'","LF",500,null,{"$f":"E9*D9","v":0}]
[6,"Fencing 10'","LF",500,null,0]
[7,"Fencing 16'","LF",500,null,0]
[8,"Fencing 18'","LF",500,null,0]
[9,"Fencing 20'","LF",500,null,0]
[10,"Add-On for top rail","LF",2300,null,0]
[11,"Add-On for middle rail","LF",500,null,0]
[12,"Add-On for Bottom rail","LF",300,null,0]
[13,"Privacy Slats 4'","LF",100,null,0]
[14,"Privacy Slats 6'","LF",71,null,0]
[15,"Privacy Slats 7'","LF",100,null,0]
[16,"Privacy Slats 8'","LF",100,null,0]
[17,"Privacy Slats 10'","LF",100,null,0]
["C.","GATES-WALKING: furnish and install - includes all gate hardware"]
[18,"Gate-Three (3) ft wide walking 6' high","EA",2,null,{"$f":"+E23*D23","v":0}]
[{"$f":"+A23+1","v":19},"Gate-Three (3) ft wide walking 56\" high","EA",2,null,{"$f":"+E24*D24","v":0}]
[{"$f":"+A24+1","v":20},"Gate-Four (4) ft wide walking 4' high","EA",4,null,0]
[{"$f":"+A25+1","v":21},"Gate-Four (4) ft wide walking 5' high","EA",2,null,0]
[{"$f":"+A26+1","v":22},"Gate-Four (4) ft wide walking, 6' high","EA",2,null,0]
[23,"Gate-Four (4) ft wide walking 7' high","EA",3,null,0]
[24,"Gate-Four (4) ft wide walking 8' high","EA",4,null,0]
[25,"Gate-Four (4) ft wide walking 10' high","EA",4,null,0]
[26,"Additional charge for Pool Code Hardware","EA",2,null,0]
["D.","GATES-DOUBLE DRIVE: furnish & install - includes all gate hardware"]
[27,"Gate-double drive, 10 ft x 10' high","EA",2,null,0]
[{"$f":"A33+1","v":28},"Gate-double drive, 10 ft x 4' high","EA",2,null,0]
[{"$f":"A34+1","v":29},"Gate-double drive, 10 ft x 6' high","EA",2,null,0]
[30,"Gate-double drive, 10 ft x 7' high","EA",2,null,0]
[31,"Gate-double drive, 10 ft x 8' high","EA",2,null,0]
[32,"Gate-double drive, 12 ft x 10' high","EA",2,null,0]
[33,"Gate-double drive, 12 ft x 4' high","EA",2,null,0]
[34,"Gate-double drive, 12 ft x 6' high","EA",2,null,0]
[35,"Gate-double drive, 12 ft x 7' high","EA",2,null,0]
[36,"Gate-double drive, 12 ft x 8' high","EA",2,null,0]
[37,"Gate-double drive, 20 ft x 10' high","EA",2,null,0]
[38,"Gate-double drive, 20 ft x 4' high","EA",2,null,0]
[39,"Gate-double drive, 20 ft x 6' high","EA",2,null,0]
[40,"Gate-double drive, 20 ft x 7' high","EA",2,null,0]
[41,"Gate-double drive, 20 ft x 8' high","EA",2,null,0]
["D-1","GATES-ROLL: furnish & install - includes all gate hardware"]
[42,"Gate-roll, 12 ft wide x 10' high","EA",2,null,0]
[{"$f":"A49+1","v":43},"Gate-roll, 12 ft wide x 4' high","EA",2,null,0]
[{"$f":"A50+1","v":44},"Gate-roll, 12 ft wide x 4' high","EA",2,null,0]
[45,"Gate-roll, 12 ft wide x 6' high","EA",2,null,0]
[46,"Gate-roll, 12 ft wide x 7' high","EA",2,null,{"$f":"E53*D53","v":0}]
[47,"Gate-roll, 12 ft wide x 8' high","EA",2,null,0]
[48,"Gate-roll, 20 ft wide x 10' high","EA",2,null,0]
[49,"Gate-roll, 20 ft wide x 6' high","EA",3,null,0]
[50,"Gate-roll, 20 ft wide x 7' high","EA",2,null,0]
[51,"Gate-roll, 20 ft wide x 8' high","EA",2,null,0]
["E.","BLACK ALUMINUM, ORNAMENTAL, pressed spears: include all labor, equipment & materials such as rails, posts, vertical rails, concrete footings, decorative caps, fittings"]
[52,"Height 4' - 3 rail","LF",100,null,{"$f":"E60*D60","v":0}]
[53,"Height 6' - 3 rail","LF",100,null,{"$f":"E61*D61","v":0}]
[null,"Field and Barbed Wire furnish and install:  includes fabric, line posts, concrete footings, tension wires, fittings.  Terminal post, stretcher bar, top rail, and hardware not included."]
[null,"Fencing with Barbed Wire, delivered and installed ","LF",600,null,{"$f":"E63*D63","v":0}]
[null,"Fencing without barbed wire, delivered and installed","LF",500,null,{"$f":"E64*D64","v":0}]
[null,"Corner post assembly, delivered and installed","EA",500,null,0]
[null,"Pull and End Post Assembly, delivered & installed","EA",500,null,0]
[null,"In-Line brace assembly, delivered & installed","EA",500,null,0]
[null,"Barbed Wire Angled Top furnish and install: "]
[null,"Pressed steel 45 degree angle arms","EA",25,null,0]
[null,"3 strand barbed wire","LF",100,null,0]
[null,"PVC fencing furnish and install: includes PVC, line posts, post caps, concrete footings, tension wires, and fittings.  Terminal post, strecther bar, top rail, and hardware not included."]
[null,"Height       Width          Size       Thickness"]
[null,"Tounge and Groove, white:             48       72       7/8x6       .063","EA",100,null,{"$f":"E73*D73","v":0}]
[null,"Tounge and Groove, white              72       72       7/5x6       .065","EA",120,null,0]
[null,"Post, white                                             84       NA         5x5         .16","EA",100,null,0]
[null,"Post, white                                             108     NA         5x5         .16","EA",50,null,0]
[null,"Gate Post with Channel, white        84        NA      5X5         .16","EA",25,null,0]
[null,"Gate Post with Channel, white      108       NA         5X5       .16","EA",25,null,0]
[null,"Cap - Flat, white                                    NA       NA        5X5        .16","EA",100,null,0]
[null,"Gate-Tounge and Groove, white      48       NA       NA         NA","EA",10,null,0]
[null,"Gate-Tounge and Groove, white      60       NA       NA         NA","EA",10,null,0]
[null,"Gate-Tounge and Groove, white      84       NA       NA         NA","EA",10,null,0]
[null,"Gate-Tounge and Groove, white    120      NA       NA         NA","EA",10,null,0]
[null,"Green Vinyl top rail, 15/8\" ","LF",110,null,0]
[null,"Timber & Trex Fencing, furnish and install.  includes fabric, line posts, concrete footings, tension wires, fittings.  Terminal post, stretcher bar, top rail, and hardware not included."]
[null,"Stockage, 4 ft high","LF",200,null,{"$f":"E86*D86","v":0}]
[null,"Stockage, 6 ft high","LF",500,null,0]
[null,"Stockage, 8 ft high","LF",100,null,0]
[null,"Gate-stockade, 4 ft wide, 4 ft high","EA",10,null,0]
[null,"Gate-stockade, 4 ft wide, 6 ft high","EA",10,null,0]
[null,"Gate-stockade, 4 ft wide, 8 ft high","EA",10,null,0]
[null,"Gate-Stockade, 6 ft wide, 4 ft high","EA",10,null,0]
[null,"Gate-stockade, 6 ft wide, 6 ft high","EA",10,null,0]
[null,"Gate-stockade, 6 ft wide, 8 ft high","EA",10,null,0]
[54,"Additional Cost for Finials","LF",10,null,0]
[null," SECTIONS F-I are omitted by addendum 6"]
["J.","POSTS: furnish and install: includes concrete footings, one stretcher bar per post, and all hardware to attach rails"]
[55,"Corner Posts, 4'","EA",11,null,{"$f":"E98*D98","v":0}]
[56,"Corner Posts, 5'","EA",13,null,0]
[{"$f":"A99+1","v":57},"Corner Posts, 6'","EA",10,null,0]
[58,"Corner Posts, 7'","EA",10,null,0]
[59,"Corner Posts, 8'","EA",10,null,0]
[60,"Corner Posts, 10'","EA",10,null,0]
[61,"Corner Posts, 15'","EA",10,null,0]
[62,"Corner Posts, 16'","EA",5,null,0]
[63,"Corner Posts, 18'","EA",5,null,0]
[64,"Corner Posts, 20'","EA",5,null,0]
[65,"End Posts, 4'","EA",33,null,0]
[66,"End Posts, 5'","EA",11,null,0]
[67,"End Posts, 6'","EA",42,null,0]
[68,"End Posts, 7'","EA",10,null,0]
[69,"End Posts, 8'","EA",10,null,0]
[70,"End Posts, 10'","EA",10,null,0]
[71,"End Posts, 15'","EA",10,null,0]
[72,"End Posts, 16'","EA",5,null,0]
[73,"End Posts, 18'","EA",5,null,0]
[74,"End Posts, 20'","EA",5,null,0]
[75,"Terminal/Gate;  4' high, 3\" round, vinyl colored","EA",25,null,0]
[76,"Terminal/Gate; 6' high, 3\" round, vinyl colored","EA",25,null,0]
[77,"Terminal/Gate; 7' high, 3\" round, vinyl colored","EA",25,null,0]
[78,"Terminal/Gate; 8' high, 3\" round, vinyl colored","EA",2,null,0]
[79,"Terminal/Gate; 10' high, 3\" round, vinyl colored","EA",2,null,{"$f":"E122*D122","v":0}]
[80,"Terminal/Gate; 16' high, 3\" round, vinyl colored","EA",2,null,{"$f":"E123*D123","v":0}]
[81,"Terminal/Gate; 18' high, 3\" round, vinyl colored","EA",2,null,0]
[82,"Terminal/Gate; 20' high, 3\" round, vinyl colored","EA",2,null,0]
["K.","STRETCHER BAR: furnish & install: includes all required hardware to complete connection"]
[83,"4' high, vinyl, colored","EA",313,null,0]
[{"$f":"A127+1","v":84},"6' high, vinyl, colored","EA",338,null,0]
[{"$f":"A128+1","v":85},"7' high, vinyl, colored","EA",200,null,0]
[86,"8' high, vinyl, colored","EA",200,null,0]
[87,"10' high, vinyl, colored","EA",200,null,0]
[88,"16' high, vinyl, colored","EA",50,null,0]
[89,"18' high, vinyl, colored","EA",50,null,0]
[90,"20' high, vinyl, colored","EA",50,null,0]
["L.","CORE DRILLING: for post Installation: includes labor and materials"]
[91,"Concrete Core","EA",14,null,{"$f":"E136*D136","v":0}]
[92,"Asphalt Core","EA",8,null,{"$f":"E137*D137","v":0}]
["M.","REMOVAL OF EXISTING FENCE: includes all labor, equipment, and material to tear down exisiting fence, haul away, and level to existing grade"]
[93,"4 foot","LF",777,null,{"$f":"E139*D139","v":0}]
[{"$f":"A139+1","v":94},"6 foot","LF",1800,null,{"$f":"E140*D140","v":0}]
[{"$f":"A140+1","v":95},"7 foot","LF",100,null,{"$f":"E141*D141","v":0}]
[96,"8 foot","LF",100,null,{"$f":"E142*D142","v":0}]
[97,"10 foot","LF",100,null,{"$f":"E143*D143","v":0}]
["N","BASEBALL/SOFTBALL BACKSTOP: includes all labor, equipment, and materials tear down existing, haul away"]
[98,"Remove existing wire (16'-20' max height)","LF",50,null,{"$f":"E145*D145","v":0}]
[99,"Remove entire structure","LF",20,null,{"$f":"E146*D146","v":0}]
["O","TENNIS COURT CAGES:  includes all labor, equipment, and materials, tear down exisiting, haul away"]
[100,"Fencing 10' high (1 3/4\" mesh x 6 gauge wire) wire only","LF",200,null,{"$f":"E148*D148","v":0}]
[{"$f":"A148+1","v":101},"Fencing 15' high (1 3/4\" mesh x 6 gauge wire) wire only","LF",200,null,0]
[{"$f":"A149+1","v":102},"Remove existing wire (10' max height)","LF",200,null,{"$f":"E150*D150","v":0}]
[103,"Remove existing wire (15' max height)","LF",200,null,{"$f":"E151*D151","v":0}]
[104,"Remove entire structure","LF",100,null,{"$f":"E152*D152","v":0}]
["P","ADDITIONAL SERVICES: may be purchased under this Contract at an hourly rate and cost plus, for any service not already desribedabove.  Labor is already factored in items described above."]
[105,"Repairs / Removal not described above during Regular Working Hours (Monday-Friday, 7am - 6pm)","HR",40,null,{"$f":"E154*D154","v":0}]
[{"$f":"A154+1","v":106},"Service Charge for after hours, weekends, or City Recognized Holidays","HR",10,null,{"$f":"E155*D155","v":0}]
[{"$f":"A155+1","v":107},"Motorized Gate Semi Annual Preventative Maintenance","GATE",3,null,{"$f":"E156*D156","v":0}]
[108,"Parts not described above may be aquired at cost plus markup or discount.  (Enter as a decimal  10% = .10)  If entering a discount enter amount as a negative decimal.  Provide invoice to prove cost.","%",{"v":5000,"d":"$5,000"},null,{"$f":"+D157*E157+5000","v":{"v":5000,"d":"$5,000.00"}}]
["ESTIMATED ANNUAL TOTAL",{"$nulls":4},{"$f":"SUM(F5:F157)","v":{"v":5000,"d":"$5,000.00"}}]
["LF=Lineal feet, EA=Each, HR=Hour"]
["Estimated quantities are for bidding purposes only, no quantities are guarenteed or implied."]
[]
[null,"This bid schedule must be downloaded, completed, printed, and submitted with your bid."]