mt-ep-yell2022-1-3_Rescue creek_control-sheet.xlsx
XLSX spreadsheet 38 KB Posted
- Solicitation number
- 69056725R000010
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
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. 326131 | Note: NPS fields do not appear on the sheet unless additional text is added. | ||
| NPS Drwg No. | NPS Drwg No. 101/195340 | |||
| First sheet #: | D.1 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 3 | 3.0 | ||
| Base sheet name: | Sheet | 3 | rows w/data | OK - no spaces in data |
| Max. row/table | 35 | 3 | data rows | Warnings: |
| 35 | rows/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. | ||||
| Worksheet | Sheet | Header | Number | Notes |
| Sheet | D.1 | 3 | 1 | OK |
| Sheet (2) | Undefined | FALSE | 1 | |
| Sheet (3) | Undefined | FALSE | 1 | |
| Sheet (4) | Undefined | FALSE | 1 | |
| Sheet (5) | Undefined | FALSE | 1 | |
| Sheet (6) | Undefined | FALSE | 1 | |
| Sheet (7) | Undefined | FALSE | 1 | |
| Sheet (8) | Undefined | FALSE | 1 | |
| Sheet (9) | Undefined | FALSE | 1 | |
| Sheet (10) | Undefined | FALSE | 1 | |
| Sheet (11) | Undefined | FALSE | 1 | |
| Sheet (12) | Undefined | FALSE | 1 | |
| Sheet (13) | Undefined | FALSE | 1 | |
| Sheet (14) | Undefined | FALSE | 1 | |
| Sheet (15) | Undefined | FALSE | 1 | |
| Sheet (16) | Undefined | FALSE | 1 | |
| Sheet (17) | Undefined | FALSE | 1 | |
| Sheet (18) | Undefined | FALSE | 1 | |
| Sheet (19) | Undefined | FALSE | 1 | |
| Sheet (20) | Undefined | FALSE | 1 | |
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 20 September 2023
Sheet
| Sheet Information | |||||||||||||
| Sheet num: | D.1 | Filename | 0 | ||||||||||
| Sheet name: | Sheet | C:\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: | A | B | C | D | E | F | G | H | I | ||||
| 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 COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ORTHOMETRIC ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| RESCUE1 | 1975711.098 | 2466461.995 | 5363.300 | 45°01'09.658818"N | 110°41'42.623516"W | 5334.5967 | 0.999711225 | 5/8" ir w/fhwa alum cap | 1. | 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. | |||||
| RESCUE2 | 1975323.012 | 2466994.953 | 5355.989 | 45°01'05.866659"N | 110°41'35.163342"W | 5327.2934 | 0.9997113816 | 5/8" ir w/fhwa alum cap | |||||||
| RESCUE3 | 1975125.201 | 2466708.396 | 5384.745 | 45°01'03.892213"N | 110°41'39.131765"W | 5356.0494 | 0.9997101114 | 5/8" ir w/fhwa alum cap | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 |
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 COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| RESCUE1 | 1975711.098 | 2466461.995 | 5363.300 | 45°01'09.658818"N | 110°41'42.623516"W | 5334.597 | 0.99971122 | 5/8" ir w/fhwa alum cap | |
| RESCUE2 | 1975323.012 | 2466994.953 | 5355.989 | 45°01'05.866659"N | 110°41'35.163342"W | 5327.293 | 0.99971138 | 5/8" ir w/fhwa alum cap | |
| RESCUE3 | 1975125.201 | 2466708.396 | 5384.745 | 45°01'03.892213"N | 110°41'39.131765"W | 5356.049 | 0.99971011 | 5/8" ir w/fhwa alum cap |
File details come from the government source that posted it. Updated .