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 PDF
bid_76_25.pdf PDF
Addendum_2_bid_76_25.pdf PDF
bid_76_25.pdf PDF
Addendum_2_bid_76_25.pdf PDF
Addendum_1_bid_76_25.pdf PDF
attachment_1_bid_76_25_Offer Sheet.xlsx XLSX spreadsheet
bid_76_25.pdf 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 NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
Section 1 - Steel Posts & Blocks
1POLY OFFSET BLOCKS - 6"x 8"x 14" FaceEach300150300750$0.00
2STEEL POSTS 6' - W6 x 8.5 x 6'Each300500800$0.00
3STEEL POSTS 7'- W6 x 8.5 x 7'Each300200500$0.00
SECTION TOTAL$0.00
Section 2 - BEAM Guard Rail Standard Rail - Mid-Spliced - Galvanized
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
4Mid-Span Splice, W-Beam GR Section, 12Ga, 12'-6" mounting holes every 3'-1 1/2" center to center,(3'-1.5" c-c)Each1257575$0.00
5Mid-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)Each10020100220$0.00
6Mid-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)Each66$0.00
7Mid-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)Each66$0.00
8Mid-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)Each52025$0.00
9W BEAM - SECTION 12' 6" RADIUS 20 Traffic Facing ConvexEach22$0.00
10W BEAM - SECTION 12' 6" RADIUS 30 Traffic Facing ConvexEach88$0.00
11W BEAM - SECTION 12' 6" RADIUS 40 Traffic Facing ConvexEach1010$0.00
SECTION TOTAL$0.00
Section 3 - POWDER COATED - Special Order Repair Parts
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
12Powder Coated - W Beam GR Section 25'- 0" for posts set every 6' 3" with intermittant holes every 3' 1-1/2"Each5050$0.00
SECTION TOTAL$0.00
Section 4 - GALVANIZED - Nu-Guard Repair Parts
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
13NU-GUARD Steel Posts (Nu-Guard), 6’-6”Each100100$0.00
14NU-GUARD Steel Posts (Nu-Guard), 7’-6”Each50200250$0.00
15NU-GUARD Steel Posts (Nu-Guard), 8'-6"Each100100$0.00
SECTION TOTAL$0.00
Section 5 - Delineation for End Terminal Units
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
16MSKT or SKT Terminal End Reflector Yellow Black Chevron 18" x 18"Each102030$0.00
17SoftStop Terminal End Reflector Yellow Black Chevron - LEFT (long & narrow - 24 ¼” x 5 3/16” some are 5 ¼” 5 1/8” )Each1010$0.00
SECTION TOTAL$0.00
Section 6 - MSKT Complete End Units - TL3 (Test Level 3 = over 40mph)
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
18MSKT - COMPLETE UNITSEach462030$0.00
SECTION TOTAL
Section 7 - SoftStop Trinity Units -TL3 (Test Level 3 = over 40mph)
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
19SoftStop - COMPLETE UNITEach61319$0.00
20TAU II Slider Assembly KitEach44$0.00
21TAU II Sliding PanelEach88$0.00
22TAU II Front SupportEach22$0.00
23TAU II Leg KitEach44$0.00
24Soft Stop Hardware BagEach55$0.00
SECTION TOTAL$0.00
Section 8 - MSKT Repair Parts
Line NumberItem DescriptionItem NumberUnit of MeasureBureau of TurnpikesDOT District 1DOT District 2DOT District 3DOT District 4DOT District 5DOT District 6Total QtyUnit CostExtended Total Cost
25Impact HeadMS3000Each358$0.00
26W-Beam Guardrail End Section, 12 Gauge(Anchor Panel)SF1303Each1010$0.00
27First Post Top (6 x 6 x 1/8" Tube)MTPHP1AEach33$0.00
28First Post Bottom (6' W6 x 15)MTPHP1BEach44$0.00
29Second Post Assembly TopUHP2AEach44$0.00
30Second Post Assembly BottomHP2BEach33$0.00
31Bearing Plate 8" x 8"E750Each33$0.00
32StrutMS785Each88$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 .