attachment_1_bid_76_25_Offer Sheet.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- GUARDRAILS AND PARTS
- Solicitation number
- bid 76-25
- Issued by
- Coos County, New Hampshire
About this file
This is an offer sheet spreadsheet for RFB 76-25 from the New Hampshire Department of Transportation (DOT) and Bureau of Turnpikes for guardrails and related parts. The spreadsheet is organized into eight sections covering various guardrail components including steel posts and blocks, beam guardrail standard rail, powder coated repair parts, galvanized Nu-Guard repair parts, delineation for end terminal units, MSKT complete end units, SoftStop Trinity units, and MSKT repair parts. Key quantities include 750 poly offset blocks, 800 steel posts (6'), 220 mid-span splice W-beam sections (25'), 250 Nu-Guard steel posts (7'6"), and 30 MSKT complete units.
The spreadsheet is structured as a unit cost pricing sheet where vendors must enter their unit costs for each line item across multiple DOT districts and the Bureau of Turnpikes. The sheet includes columns for unit costs and extended total costs, with automatic calculation of section totals and a grand total. Each section contains specific technical requirements for the guardrail components, such as dimensions, gauges, and mounting specifications. No pricing information is filled in on the form as it appears to be a blank template for vendor completion.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Addendum_1_bid_76_25.pdf | ||
| bid_76_25.pdf | ||
| Addendum_2_bid_76_25.pdf | ||
| bid_76_25.pdf | ||
| Addendum_2_bid_76_25.pdf | ||
| Addendum_1_bid_76_25.pdf | ||
| attachment_1_bid_76_25_Offer Sheet.xlsx | XLSX spreadsheet | |
| bid_76_25.pdf | ||
| attachment_1_bid_76_25_Offer Sheet.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Vendor Business Name: | |||||||||||||
| Instructions: Please enter the item numbers and unit costs. | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| Section 1 - Steel Posts & Blocks | |||||||||||||
| 1 | POLY OFFSET BLOCKS - 6"x 8"x 14" Face | Each | 300 | 150 | 300 | 750 | $0.00 | ||||||
| 2 | STEEL POSTS 6' - W6 x 8.5 x 6' | Each | 300 | 500 | 800 | $0.00 | |||||||
| 3 | STEEL POSTS 7'- W6 x 8.5 x 7' | Each | 300 | 200 | 500 | $0.00 | |||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| Section 2 - BEAM Guard Rail Standard Rail - Mid-Spliced - Galvanized | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 4 | Mid-Span Splice, W-Beam GR Section, 12Ga, 12'-6" mounting holes every 3'-1 1/2" center to center,(3'-1.5" c-c) | Each | 125 | 75 | 75 | $0.00 | |||||||
| 5 | Mid-Span Splice,W-Beam GR Section, 12 Ga, 25'-0" mounting holes every 3'- 1 1/2" center to center, (3'-1.5" c-c) | Each | 100 | 20 | 100 | 220 | $0.00 | ||||||
| 6 | Mid-Span Splice, W-Beam GR (TRANSITION to MGS) Panel, 12Ga, 15'-7 1/2" mounting holes every 3'- 1 1/2" center to center, (3'-1.5" c-c) | Each | 6 | 6 | $0.00 | ||||||||
| 7 | Mid-Span Splice, W-Beam GR (TRANSITION to MGS) Panel, 12Ga, 3'-1 1/2" mounting holes every 3'-1 1/2" center to center, (3'-1.5" c-c) | Each | 6 | 6 | $0.00 | ||||||||
| 8 | Mid-Span Splice, W-Beam GR (TRANSITION to MGS) Panel, 12Ga, 9'-4 1/2" mounting holes every 3'-1 1/2" center to center, (3'-1.5" c-c) | Each | 5 | 20 | 25 | $0.00 | |||||||
| 9 | W BEAM - SECTION 12' 6" RADIUS 20 Traffic Facing Convex | Each | 2 | 2 | $0.00 | ||||||||
| 10 | W BEAM - SECTION 12' 6" RADIUS 30 Traffic Facing Convex | Each | 8 | 8 | $0.00 | ||||||||
| 11 | W BEAM - SECTION 12' 6" RADIUS 40 Traffic Facing Convex | Each | 10 | 10 | $0.00 | ||||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| Section 3 - POWDER COATED - Special Order Repair Parts | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 12 | Powder Coated - W Beam GR Section 25'- 0" for posts set every 6' 3" with intermittant holes every 3' 1-1/2" | Each | 50 | 50 | $0.00 | ||||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| Section 4 - GALVANIZED - Nu-Guard Repair Parts | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 13 | NU-GUARD Steel Posts (Nu-Guard), 6’-6” | Each | 100 | 100 | $0.00 | ||||||||
| 14 | NU-GUARD Steel Posts (Nu-Guard), 7’-6” | Each | 50 | 200 | 250 | $0.00 | |||||||
| 15 | NU-GUARD Steel Posts (Nu-Guard), 8'-6" | Each | 100 | 100 | $0.00 | ||||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| Section 5 - Delineation for End Terminal Units | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 16 | MSKT or SKT Terminal End Reflector Yellow Black Chevron 18" x 18" | Each | 10 | 20 | 30 | $0.00 | |||||||
| 17 | SoftStop Terminal End Reflector Yellow Black Chevron - LEFT (long & narrow - 24 ¼” x 5 3/16” some are 5 ¼” 5 1/8” ) | Each | 10 | 10 | $0.00 | ||||||||
| SECTION TOTAL | $0.00 |
| Section 6 - MSKT Complete End Units - TL3 (Test Level 3 = over 40mph) | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 18 | MSKT - COMPLETE UNITS | Each | 4 | 6 | 20 | 30 | $0.00 | ||||||
| SECTION TOTAL | |||||||||||||
| Section 7 - SoftStop Trinity Units -TL3 (Test Level 3 = over 40mph) | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 19 | SoftStop - COMPLETE UNIT | Each | 6 | 13 | 19 | $0.00 | |||||||
| 20 | TAU II Slider Assembly Kit | Each | 4 | 4 | $0.00 | ||||||||
| 21 | TAU II Sliding Panel | Each | 8 | 8 | $0.00 | ||||||||
| 22 | TAU II Front Support | Each | 2 | 2 | $0.00 | ||||||||
| 23 | TAU II Leg Kit | Each | 4 | 4 | $0.00 | ||||||||
| 24 | Soft Stop Hardware Bag | Each | 5 | 5 | $0.00 | ||||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| Section 8 - MSKT Repair Parts | |||||||||||||
| Line Number | Item Description | Item Number | Unit of Measure | Bureau of Turnpikes | DOT District 1 | DOT District 2 | DOT District 3 | DOT District 4 | DOT District 5 | DOT District 6 | Total Qty | Unit Cost | Extended Total Cost |
| 25 | Impact Head | MS3000 | Each | 3 | 5 | 8 | $0.00 | ||||||
| 26 | W-Beam Guardrail End Section, 12 Gauge(Anchor Panel) | SF1303 | Each | 10 | 10 | $0.00 | |||||||
| 27 | First Post Top (6 x 6 x 1/8" Tube) | MTPHP1A | Each | 3 | 3 | $0.00 | |||||||
| 28 | First Post Bottom (6' W6 x 15) | MTPHP1B | Each | 4 | 4 | $0.00 | |||||||
| 29 | Second Post Assembly Top | UHP2A | Each | 4 | 4 | $0.00 | |||||||
| 30 | Second Post Assembly Bottom | HP2B | Each | 3 | 3 | $0.00 | |||||||
| 31 | Bearing Plate 8" x 8" | E750 | Each | 3 | 3 | $0.00 | |||||||
| 32 | Strut | MS785 | Each | 8 | 8 | $0.00 | |||||||
| SECTION TOTAL | $0.00 | ||||||||||||
| GRAND TOTAL: | $0.00 |
&"Times New Roman,Regular"Attachment 1: Offer Sheet &"Times New Roman,Bold"&14RFB 76-25 Guardrails
&"Times New Roman,Regular"&10Page &P of &N
File details come from the government source that posted it. Updated .