{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Bid Form","Part One","Part Two","Part Three","Part Four","Part Five","Part Six"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Bid Form","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[0,5,6,6],[1,0,1,4],[2,0,2,4],[2,7,2,10],[3,0,3,4],[3,7,5,10],[4,0,4,4],[5,0,5,4],[6,0,6,4],[6,7,6,10],[7,0,7,10],[8,0,8,10],[9,0,9,3],[9,5,9,10],[10,0,10,10],[11,0,11,3],[11,4,12,10],[12,0,12,3],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,4],[16,5,16,7],[17,0,17,2],[17,4,17,7],[17,9,17,10],[18,0,18,1],[18,2,18,7],[19,1,19,7],[20,0,20,1],[20,2,20,7],[20,9,20,10],[21,1,21,4],[21,7,21,10],[22,1,22,4],[22,7,22,10],[23,0,24,4],[23,6,24,10],[25,0,25,4],[25,6,25,10],[26,0,26,5],[26,6,26,10],[27,0,28,10],[29,0,29,10],[30,0,30,10],[33,5,33,8]]}
["SOLICITATION, OFFER, AND BID FORM",{"$nulls":9},"ESCAMBIA COUNTY, FLORIDA"]
["Submit offers to:"]
["Jeff Lovingood, 850-595-4953",{"$nulls":6},"Invitation to Bid"]
["Purchasing Specialist",{"$nulls":6},"Installation, Refurbish, and Removal of Pavement Markings and Associated Items"]
["Office of Purchasing, 2nd Floor, Room 11.101"]
["213 Palafox Place, Pensacola, FL  32502"]
["or P.O. Box 1591, Pensacola, FL 32591-1591",{"$nulls":6},"Solicitation Number PD 18-19.007"]
["SOLICITATION"]
["Mailing Date: November 13, 2018"]
["Pre-Solicitation Conference: A",{"$nulls":3},"Non-Mandatory","Pre-Solicitation Conference will be held in the Office of "]
["Purchasing Conference Room, 11.407, at 213 Palafox Pl. Pensacola, FL 32502 at 10:00 AM CST, November 28, 2018"]
["Offers Will Be Received Until:",{"$nulls":3},"2:00 PM CST, December 13, 2018, and may not be withdrawn within 90 days after such date and time."]
[]
["POSTING OF SOLICITATION TABULATIONS"]
["Solicitation tabulations with Recommended Awards will be posted for review by interested parties at the Escambia County Office of Purchasing, and will remain posted for a period of two (2) business days.  Failure to file a protest in writing within two (2) business days after posting of the soliciation tabulation shall constitute a waiver of any protest relating to this soliciation.  All protests must be filed with the Escambia County Office of Purchasing.  Protests will be handled according to Escambia County Purchasing Ordinance."]
["OFFER (shall be completed by Offeror)"]
["Federal Employer ID Number or S.S. Number:",{"$nulls":9},"Terms of Payment"]
["Delivery Date will be ",{"$nulls":3},"days after receipt of Purchase Order"]
["Vendor Name:"]
["Address:",{"$nulls":9},"Bid Bond Attached"]
["City, State, Zip:",{"$nulls":7},"$"]
["Phone:",{"$nulls":5},"Toll Free:"]
["Fax:",{"$nulls":5},"Contact:"]
[]
[]
["Name & Title of Person Authorized to Sign Offer",{"$nulls":5},"* Signature of Person Authorized to Sign Offer"]
[{"$nulls":6},"(Original Signature Required)"]
["* Failure to execute this Form binding the bidder/proposer's offer shall result in the bid/proposal being rejected as non-responsive."]
[]
["I certify that this offer is made without prior understanding, agreement, or connection, with any Corporation, firm or person submitting an offer for the same materials, supplies, or equipment, and is in all respects fair and without collusion or fraud.  I agree to abide by all conditions of this offer and certify that I am authorized to sign this offer for the Offeror and that the Offeror is in compliance with all requirements of the solicitation, including but not limited to certification requirements.  In submitting an offer to Escambia County Florida, the Offeror agrees that if the offer is accepted, the Offeror will convey, sell, assign or transfer to Escambia County Florida all rights title and interest in and to all causes of action it may now or hereafter acquire under the Anti-trust laws of the United States and the State of Florida for price fixing relating to the particular commodities or services purchase or acquired by Escambia County Florida.  At the County’s discretion, such assignment shall be made and become effective at the time the County tenders final payment to the Offeror."]
["BID FORM"]
[]
[]
[{"$nulls":4},"BASE BID:    $",{"$f":"'Part One'!D57+'Part Two'!D62+'Part Three'!D48+'Part Four'!D13+'Part Five'!D7+'Part Six'!F14","v":0}]

{"sheet":"Part One","index":1,"n_rows":57,"n_cols":6,"rows_kept":57,"merged":[[0,0,0,5]]}
["Part 1:  Application of Paint Markings (White, Yellow, Blue, Red)"]
[]
["Item #","Description of Work Order Items","Unit","10 Days","15-30 Days*","60-120 Days*"]
["PO100","Skip Stripe, 4\", 10'-30' Skip","GM"]
["PO101","Skip Stripe, 4\", 10'-30' Skip","LF"]
["PO102","Skip Stripe, 4\", 6'-10' Skip","LF"]
["PO103","Skip Stripe, 4\", 2'-4' Skip","LF"]
["PO104","Solid Stripe, 4\"","LF"]
["PO105","Solid Stripe, 4\"","GM"]
["PO106","Skip Stripe, 6\", 10'-30' Skip","GM"]
["PO107","Skip Stripe, 6\", 10'-30' Skip","LF"]
["PO108","Skip Stripe, 6\", 6'-10' Skip","LF"]
["PO109","Skip Stripe, 6\", 2'-4' Skip","LF"]
["PO110","Solid Stripe, 6\"","GM"]
["PO111","Solid Stripe, 6\"","LF"]
["PO112","Solid Stripe, 12\"","LF"]
["PO113","Solid Stripe, 18\"","LF"]
["PO114","Solid Stripe, 24\"","LF"]
["PO115","Directional Arrow, Single headed, 12SF","EA"]
["PO116","Directional Arrow, Single headed, 16SF","EA"]
["PO117","Directional Arrow, Double headed, 27SF","EA"]
["PO118","\"Bump\" Pavement Message","EA"]
["PO119","Removal \"Bump\" Pavement Message","EA"]
["PO120","Hump Markings (Ref: 3B-29 \"A\") MUTCD","EA"]
["PO121","Hump Markings (Ref: 3B-30 \"A\") MUTCD","EA"]
["PO122","Hump Markings (Ref: 3B-31 \"Advance\") MUTCD","EA"]
["PO123","Combination (Ref: 3B-29 \"A\" & \"Advance\") MUTCD","EA"]
["PO124","Combination (Ref: 3B-30 \"A\" & \"Advance\") MUTCD","EA"]
["PO125","\"Lane\" Pavement Message","EA"]
["PO126","\"Left\" Pavement Message","EA"]
["PO127","\"Merge\" Pavement Message","EA"]
["PO128","\"Only\" Pavement Message","EA"]
["PO129","\"Ped Xing\" Pavement Message","EA"]
["PO130","\"Right\" Pavement Message","EA"]
["PO131","\"RXR\" Pavement Message","EA"]
["PO132","\"School\" Pavement Message","EA"]
["PO133","\"Stop\" Pavement Message","EA"]
["PO134","\"Yield\" Pavement Message","EA"]
["PO135","Approach Yield (Ref:3B-14a) MUTCD","EA"]
["PO136","Approach Yield (Ref:3B-14b) MUTCD","EA"]
["PO137","\"Turn\" Pavement Message","EA"]
["PO138","Diamond Pavement Message","EA"]
["PO139","Bike Symbol Pavement Message","EA"]
["PO140","Bike Symbol \"Arrow\"","EA"]
["PO141","Bike Symbol & Arrow","EA"]
["PO142","5' Handicapped Symbol Pavement Message","EA"]
["PO143","3' Handicapped Symbol Pavement Message","EA"]
["PO144","Removal of Paint Markings","LF"]
["PO145","Removal of Paint Markings","SF"]
["PO146","Solid Stripe, 4\" (BLUE)","LF"]
["PO147","Solid Stripe, 6\" (BLUE)","LF"]
["PO148","Removal of Combination (Ref: 3B-29 \"A\" & Advance) MUTCD","EA"]
["PO149","Removal of Combination (Ref: 3B-30 \"A\" & Advance) MUTCD"]
["PO150","Temporary Removal Tape 6\" White","EA"]
["PO151","Temporary Removal Tape 6\" Blue","EA"]
["PO152","Temporary Removal Tape Handicap Emblem","EA"]
[null,null,"Total",{"$f":"SUM(D4:D56)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E4:E56)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]

{"sheet":"Part Two","index":2,"n_rows":62,"n_cols":6,"rows_kept":62,"merged":[[0,0,0,5]]}
["Part 2:  Application of Thermoplastic Markings (White, Yellow, Blue, Red)"]
[]
["Item #","Description of Work Order Items","Unit","10 Days","15-30 Days*","60-120 Days*"]
["TO100","Skip Stripe, 4\", 10'-30' Skip","GM"]
["TO101","Skip Stripe, 4\", 10'-30' Skip","LF"]
["TO102","Skip Stripe, 4\", 6'-10' Skip","LF"]
["TO103","Skip Stripe, 4\", 2'-4' Skip","LF"]
["TO104","Solid Stripe, 4\"","LF"]
["TO105","Solid Stripe, 4\"","GM"]
["TO106","Skip Stripe, 6\", 10'-30' Skip","GM"]
["TO107","Skip Stripe, 6\", 10'-30' Skip","LF"]
["TO108","Skip Stripe, 6\", 6'-10' Skip","LF"]
["TO109","Skip Stripe, 6\", 2'-4' Skip","LF"]
["TO110","Solid Stripe, 6\"","GM"]
["TO111","Solid Stripe, 6\" Audible and Vibratory","GM"]
["TO112","Solid Stripe, 6\"","LF"]
["TO113","Solid Stripe, 6\" Audible and Vibratory","LF"]
["TO114","Solid Stripe, 12\"","LF"]
["TO115","Solid Stripe, 18\"","LF"]
["TO116","Solid Stripe, 24\"","LF"]
["TO117","Directional Arrow, Single headed 12SF","EA"]
["TO118","Directional Arrow, Single headed 16SF","EA"]
["TO119","Directional Arrow, Double headed, 27SF","EA"]
["TO120","\"Bump\" Thermoplastic Message","EA"]
["TO121","Removal \"Bump\" Thermoplastic Message","EA"]
["TO122","Hump Markings (Ref: 3B-29 \"A\") MUTCD","EA"]
["TO123","Hump Markings (Ref: 3B-30 \"A\") MUTCD","EA"]
["TO124","Hump Markings (Ref:3B-31 \"Advance\") MUTCD","EA"]
["TO125","Combination (Ref: 3B-29 \"A\" & Advance) MUTCD","EA"]
["TO126","Combination (Ref: 3B-30 \"A\" & Advance) MUTCD","EA"]
["TO127","\"Lane\" Thermoplastic Message","EA"]
["TO128","\"Left\" Thermoplastic Message","EA"]
["TO129","\"Merge\" Thermoplastic Message","EA"]
["TO130","\"Only\" Thermoplastic Message","EA"]
["TO131","\"Ped Xing\" Thermoplastic Message","EA"]
["TO132","\"Right\" Thermoplastic Message","EA"]
["TO133","\"RXR\" Thermoplastic Message","EA"]
["TO134","\"School\" Thermoplastic Message","EA"]
["TO135","\"Stop\" Thermoplastic Message","EA"]
["TO136","\"Yield\" Thermoplastic Message","EA"]
["TO137","Approach Yield (Ref: 3B-14a) MUTCD","EA"]
["TO138","Approach Yield (Ref: 3B-14b) MUTCD","EA"]
["TO139","\"Turn\" Thermoplastic Message","EA"]
["TO140","Diamond Thermoplastic Message","EA"]
["TO141","Bike Symbol Thermoplastic Message","EA"]
["TO142","Bike Symbol \"Arrow\"","EA"]
["TO143","Bike Symbol & Arrow","EA"]
["TO144","5' Handicapped Symbol Thermoplastic Message","EA"]
["TO145","3' Handicapped Symbol Thermoplastic Message","EA"]
["TO146","Removal of Thermoplastic Markings","LF"]
["TO147","Removal of Thermoplastic Markings","SF"]
["TO148","Rumble Strips FDOT Index 518 (1 set)","EA"]
["TO149","Rumble Strips FDOT Index 518 (4 sets)","EA"]
["TO150","Solid Stripe, 4\" (BLUE)","LF"]
["TO151","Solid Stripe, 6\" (BLUE)","LF"]
["TO152","Removal of Combination (Ref:3B-29\"A\" & Advance) MUTCD","EA"]
["TO153","Removal of Combination (Ref:3B-30\"A\" & Advance) MUTCD","EA"]
["TO154","Removal of Thermoplastic Rumble Stripe FDOT Index 518 (1 set)","EA"]
["TO155","Removal of Thermoplastic Rumble Stripe FDOT Index 518 (4 sets)","EA"]
["TO156","Street Print Brand Textured Pavement, Brick, Red (w/layout & prep.)","SF"]
["TO157","Street Print Brand Textured Pavement, Brick, Red (refurbish only)","SF"]
[null,null,"Total",{"$f":"SUM(D4:D61)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E4:E61)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]

{"sheet":"Part Three","index":3,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[0,0,0,5],[49,0,49,5]]}
["Part 3:  Layout (Only) for Installation of Pavement Markings*"]
[]
["Item #","Description of Work Order Items","Unit","10 Days","15-30 Days*","60-120 Days*"]
["LO100","Sk+C17+B2:B36+B2:B37+C17+B2:B36+B2:B2:B38","GM"]
["LO101","Skip Stripe, 4\", 10'-30' Skip","LF"]
["LO102","Skip Stripe, 4\", 6'-10' Skip","LF"]
["LO103","Skip Stripe, 4\", 2'-4' Skip","LF"]
["LO104","Solid Stripe, 4\"","LF"]
["LO105","Solid Stripe, 4\"","GM"]
["LO106","Skip Stripe, 6\", 10'-30' Skip","GM"]
["LO107","Skip Stripe, 6\", 10'-30' Skip","LF"]
["LO108","Skip Stripe, 6\", 6'-10' Skip","LF"]
["LO109","Skip Stripe, 6\", 2'-4' Skip","LF"]
["LO110","Solid Stripe, 6\"","GM"]
["LO111","Solid Stripe, 6\"","LF"]
["LO112","Solid Stripe, 12\"","LF"]
["LO113","Solid Stripe, 18\"","LF"]
["LO114","Solid Stripe, 24\"","LF"]
["LO115","Directional Arrow, Single-headed 12SF","EA"]
["LO116","Directional Arrow, Single-headed 16SF","EA"]
["LO117","Directional Arrow, Double-headed 27SF","EA"]
["LO118","\"Bump\" Thermoplastic Message","EA"]
["LO119","Hump Markings (Ref: 3B-29 \"A\") MUTCD","EA"]
["LO120","Hump Markings (Ref: 3B-30 \"A\") MUTCD","EA"]
["LO121","Hump Markings (Ref: 3B-31 \"Advance\") MUTCD","EA"]
["LO122","Combination (Ref: 3B-29 \"A\" & \"Advance\") MUTCD","EA"]
["LO123","Combination (Ref: 3B-30 \"A\" & \"Advance\") MUTCD","EA"]
["LO124","\"Lane\" Pavement Message","EA"]
["LO125","\"Left\" Pavement Message","EA"]
["LO126","\"Merge\" Pavement Message","EA"]
["LO127","\"Only\" Pavement Message","EA"]
["LO128","\"Ped Xing\" Pavement Message","EA"]
["LO129","\"Right\" Pavement Message","EA"]
["LO130","\"RXR\" Pavement Message","EA"]
["LO131","\"School\" Pavement Message","EA"]
["LO132","\"Stop\" Pavement Message","EA"]
["LO133","\"Yield\" Pavement Message","EA"]
["LO134","Approach Yield (Ref: 3B-14a) MUTCD","EA"]
["LO135","Approach Yield (Ref: 3B-14b) MUTCD","EA"]
["LO136","\"Turn\" Pavement Message","EA"]
["LO137","Diamond Pavement Message","EA"]
["LO138","Bike Symbol Pavement Message","EA"]
["LO139","Bike Symbol \"Arrow\"","EA"]
["LO140","Bike Symbol \"Arrow\"","EA"]
["LO141","Handicapped Symbol Pavement Message","EA"]
["LO142","Rumble Strips FDOT Index 518 (1 set)","EA"]
["LO143","Rumble Strips FDOT Index 518 (4 sets)","EA"]
[null,null,"Total",{"$f":"SUM(D4:D47)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E4:E47)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[]
["*Layout - Measuring and marking locations for pavement markings and associated items where none previously existed or previous locations are indiscernible."]

{"sheet":"Part Four","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[0,0,0,5]]}
["Part 4: Layout and Installation of Reflective Pavement Markings and Flexible Post Channelizers         (All Colors)"]
[]
["Item #","Description of Work Order Items","Unit","10 Days","15-30 Days*","60-120 Days*"]
["RO100","Mono-directional Reflective (RPM), (F&I)","EA"]
["RO101","Bi-directional Reflective (RPM), (F&I)","EA"]
["RO102","Removal, Reflective Pavement Markers","EA"]
["RO103","Flexible Post C Delineators, 36\" (F&I)","EA"]
["RO104","Removal, Flexible Post Delineators","EA"]
["RO105","Impact Recovery Flexible Delineators, 48\" (F&I)","EA"]
["RO106","Impact Recovery Flexible Delineators, 60\" (F&I)","EA"]
["RO107","Impact Recovery Flexible Delineators, 60\" (F&I)","EA"]
["RO108","Type IV (Diamond Grade) 6\" X 12\" Delineators, post type, 7ft galvanized, U-Channel (2#/ft)","EA"]
[null,null,"Total",{"$f":"SUM(D4:D12)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E4:E12)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F4:F12)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Part Five","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[0,0,0,5]]}
["Part 5:  Installation, Relocation and Removal of Wheel Stops"]
[]
["Item #","Description of Work Order Items","Unit","10 Days","15-30 Days*","60-120 Days*"]
["WO100","6' long, Concrete or Rubber Wheel Stops Anchored with 12\" Drift Pins, (F&I)","EA"]
["WO100","Relocate, 6' long, Concrete or Rubber Wheel Stops Anchored with 12\" Drift Pins, in existing asphalt","EA"]
["WO100","Remove, 6' long, Concrete or Rubber Wheel Stops Anchored with 12\" Drift Pins, in existing asphalt","EA"]
[null,null,"Total",{"$f":"SUM(D4:D6)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(E4:E6)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(F4:F6)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Part Six","index":6,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[0,0,0,5],[2,0,2,5],[4,0,4,5],[6,0,6,5]]}
["Part 6:  Night Application of Pavement Markings and Associated Items"]
[]
["Application of Pavement Markings and Associated Items to be performed between the hours of 8:00 PM and 6:00 AM"]
[]
["Work Required by the County to be performed under Part 6 will include a Flat Rate or Percentage Adder for the Contractor to cover the increase in night-time operational costs, in addition to the line item amounts.  If the Percentage Adder amount is less than the Flat Rate Adder amount, the Flat Rate Adder amount will supercede the Percentage."]
[]
["Note:  The Flate Rate Adder should be the minimum additional cost the Contractor considers is necessary for smaller jobs to compensate for increased night-time operational costs."]
[]
["Flat Rate Adder:"]
[]
["Percentage Adder:",{"$f":"'Part One'!D57+'Part Two'!D62+'Part Three'!D48+'Part Four'!D13+'Part Five'!D7","v":{"v":0,"d":"$0.00"}},"*",null,"=",{"$f":"B11*D11","v":{"v":0,"d":"$0.00"}}]
[null,"Uses Subtotals in \"10 Days\" column from Parts 1-5 for this total.",null,"Percentage",null,"Percentage Adder Total"]
[]
["Grand Total Adder:",{"$f":"B11","v":{"v":0,"d":"$0.00"}},"+",{"$f":"IF(B9>F11,B9,F11)","v":{"v":0,"d":"$0.00"}},"=",{"$f":"B14+D14","v":{"v":0,"d":"$0.00"}}]
[null,"Uses Subtotals in \"10 Days\" column from Parts 1-5 for this total.",null,"Select the LARGER of the two adders. Enter the Flat Rate amount OR the Percentage amount.",null,"Part 6 Total"]