mt-ep-yell2022-1-3_Rescue creek_control-sheet.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
MT ERFO NP YELL 2022-1(3), Yellowstone NP Rescue Creek Bridge Replacement
Solicitation number
69056725R000010
Issued by

About this file

This is a survey control sheet in Excel format containing precise coordinate and elevation data for the Yellowstone National Park Rescue Creek Bridge Replacement project. The document provides detailed survey control points (RESCUE1, RESCUE2, and RESCUE3) with state plane coordinates, geographic coordinates, orthometric elevations, and combined factors, all established using Wyoming West SPCS NAD83 2011 coordinate system and NAVD88 GEOID18 vertical datum. The field work was conducted in March 2024 with final adjustments completed in April 2024.

The survey control points are marked with 5/8-inch iron rods with FHWA aluminum caps and provide the foundational reference framework for the bridge replacement construction project identified as MT ERFO NP YELL 2022-1(3) under NPS PMIS No. 326131. The document includes technical specifications for coordinate system conversions, epoch date of 2010.000, and instructions for using combined factors to verify ground distances. This survey data supports the federal contracting opportunity for bridge replacement work being conducted through task orders to six pre-selected prime contractors including H-K Contractors, M.A. Deatley Construction, Missouri River Contractors, Oftedal Construction, Riverside Contracting, and Sundt Construction.

View the file

Other files

File Type Posted
Amendment A003.pdf PDF
QA_09-02-2025.pdf PDF
QA_08-27-2025.pdf PDF
Amendment A002.pdf PDF
QA_08-21-2025.pdf PDF
QA2_08-18-2025.pdf PDF
QA_08-18-2025.pdf PDF
Amendment A001.pdf PDF
QA_08-14-2025.pdf PDF
mt-ep-yell2022-1-3_xs.pdf PDF
RFP 69056725R000010_MT ERFO NP YELL 2022-1(3).pdf PDF
mt-ep-yell2022-1-3_Rescue Creek Bridge Final Foundation Memo.pdf PDF
mt-ep-yell2022-1-3_ali.pdf PDF
mt-ep-yell2022-1-3_plans_Final.pdf PDF
Physical Data.zip ZIP file
RescueCreek_Waterway_Hydraulics_Memo_95pct.pdf PDF
mt-ep-yell2022-1-3_earthwork.pdf PDF
Show all 17

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

Information

Survey Control Sheet
Information
1.This file transfers the Survey Control point list (in Excel format) to an Excel plan sheet. Open the point list files in Excel. Select the tab at the bottom of the worksheet and drag it to this spreadsheet. It will become a new tab. Place the name of this tab in the "Data Location" block below. The Survey Control point list will appear.
2.If extra sheets are needed, copy the original plan sheet by holding the left mouse button on the worksheet's tab (below) and hold the <CTRL>key. A mini sheet with a plus sign should appear. Drag this and drop it to the desired location.
Common Sheet Information
Insert the following values. They will appear on every sheet.
Project:MT ERFO NP YELL 2022-1(3)Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
NPS PMIS No.NPS PMIS No. 326131Note: NPS fields do not appear on the sheet unless additional text is added.
NPS Drwg No.NPS Drwg No. 101/195340
First sheet #:D.11.0
Title block text:SURVEY CONTROL
Show Totals?TRUE
Data location:Page 1Worksheet found
Data begins in col:A
Min. rows/table33.0
Base sheet name:Sheet3rows w/dataOK - no spaces in data
Max. row/table353data rowsWarnings:
35rows/table
PROJECT : Yellowstone NP Rescue Creek Bridge Replacement

DATE OF FIELD WORK :March 2024 DATE OF FINAL ADJUSTMENT : April, 2024

COORDINATE SYSTEM :Wyoming West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WY83/2011-WIF NSRS11(NAD83/2011) Wyoming, West Zone, International Foot

PROJECT UNITS : International foot

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
WorksheetSheetHeaderNumberNotes
SheetD.131OK
Sheet (2)UndefinedFALSE1
Sheet (3)UndefinedFALSE1
Sheet (4)UndefinedFALSE1
Sheet (5)UndefinedFALSE1
Sheet (6)UndefinedFALSE1
Sheet (7)UndefinedFALSE1
Sheet (8)UndefinedFALSE1
Sheet (9)UndefinedFALSE1
Sheet (10)UndefinedFALSE1
Sheet (11)UndefinedFALSE1
Sheet (12)UndefinedFALSE1
Sheet (13)UndefinedFALSE1
Sheet (14)UndefinedFALSE1
Sheet (15)UndefinedFALSE1
Sheet (16)UndefinedFALSE1
Sheet (17)UndefinedFALSE1
Sheet (18)UndefinedFALSE1
Sheet (19)UndefinedFALSE1
Sheet (20)UndefinedFALSE1
Total Sheets:10sheets missing

Revised: 20 September 2023

Sheet

Sheet Information
Sheet num:D.1Filename0
Sheet name:SheetC:\Users\nicole.garcia\Desktop\EXPORT-PW\Yell NP Rescue Creek\Rescue Creek 100% Submittal Items\[Rescue creek_control-sheet.xlsx]Sheet
Reference:Time
17-Apr-2025 8:49 AM
Begin Column:ABCDEFGHI
NPS PMIS No. 326131 NPS Drwg No. 101/195340
C:\Users\nicole.garcia\Desktop\EXPORT-PW\Yell NP Rescue Creek\Rescue Creek 100% Submittal Items\[Rescue creek_control-sheet.xlsx]Sheet
PROJECT : Yellowstone NP Rescue Creek Bridge Replacement

DATE OF FIELD WORK :March 2024 DATE OF FINAL ADJUSTMENT : April, 2024

PROJECT UNITS : International foot COORDINATE SYSTEM :Wyoming West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WY83/2011-WIF NSRS11(NAD83/2011) Wyoming, West Zone, International Foot

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTORTHOMETRIC ELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
RESCUE11975711.0982466461.9955363.30045°01'09.658818"N110°41'42.623516"W5334.59670.9997112255/8" ir w/fhwa alum cap1.To precisely check distances between points as measured on the ground, inverse the state plane coordinates and divide the computed distance by a mean combined factor of the two points.
RESCUE21975323.0122466994.9535355.98945°01'05.866659"N110°41'35.163342"W5327.29340.99971138165/8" ir w/fhwa alum cap
RESCUE31975125.2012466708.3965384.74545°01'03.892213"N110°41'39.131765"W5356.04940.99971011145/8" ir w/fhwa alum cap
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.000000
00.0000.0000.000000

17-Apr-2025 8:49 AM

PROJECT : Yellowstone NP Rescue Creek Bridge Replacement DATE OF FIELD WORK :March 2024 DATE OF FINAL ADJUSTMENT : April, 2024

COORDINATE SYSTEM :Wyoming West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WY83/2011-WIF NSRS11(NAD83/2011) Wyoming, West Zone, International Foot

PROJECT UNITS : International foot

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
RESCUE11975711.0982466461.9955363.30045°01'09.658818"N110°41'42.623516"W5334.5970.999711225/8" ir w/fhwa alum cap
RESCUE21975323.0122466994.9535355.98945°01'05.866659"N110°41'35.163342"W5327.2930.999711385/8" ir w/fhwa alum cap
RESCUE31975125.2012466708.3965384.74545°01'03.892213"N110°41'39.131765"W5356.0490.999710115/8" ir w/fhwa alum cap

File details come from the government source that posted it. Updated .