mta-valley20-1_control-points.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- MT FLAP VALLEY 20(1), Duck Creek Road
- Solicitation number
- 69056724B000013
About this file
This document appears to be a spreadsheet containing a list of survey control points for the MT FLAP VALLEY 20(1), Duck Creek Road project. It provides the state plane coordinates, geodetic coordinates, elevations, and descriptions for 6 survey control points.
The related federal contract opportunity is for the MT FLAP VALLEY 20(1), Duck Creek Road project, solicitation number 69056724B000013. This is a solicitation issued by the Department of Transportation Federal Highway Administration for the construction project. The spreadsheet appears to be an attachment to the solicitation, providing detailed survey information for the project site.
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
| 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. | |||
| State: | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | ||
| Project: | MT FLAP Valley 20(1) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD_Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD_Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.10 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 6 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 6 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT : Duck Creek Road |
DATE OF FIELD WORK :September 2022
DATE OF FINAL ADJUSTMENT : 12/12/2022
COORDINATE SYSTEM : Montana SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot
PROJECT UNITS : International foot
| Sheet Names | |||||
| Input the names of the worksheets in the order you would like the sheets numbered. | |||||
| Worksheet Name | Sheet | Header row | Sheet Number | Notes | |
| Sheet | D.10 | 3 | 10 | OK | |
| Sheet (2) | Undefined | FALSE | 10 | ||
| Sheet (3) | Undefined | FALSE | 10 | ||
| Sheet (4) | Undefined | FALSE | 10 | ||
| Sheet (5) | Undefined | FALSE | 10 | ||
| Sheet (6) | Undefined | FALSE | 10 | ||
| Sheet (7) | Undefined | FALSE | 10 | ||
| Sheet (8) | Undefined | FALSE | 10 | ||
| Sheet (9) | Undefined | FALSE | 10 | ||
| Sheet (10) | Undefined | FALSE | 10 | ||
| Sheet (11) | Undefined | FALSE | 10 | ||
| Sheet (12) | Undefined | FALSE | 10 | ||
| Sheet (13) | Undefined | FALSE | 10 | ||
| Sheet (14) | Undefined | FALSE | 10 | ||
| Sheet (15) | Undefined | FALSE | 10 | ||
| Sheet (16) | Undefined | FALSE | 10 | ||
| Sheet (17) | Undefined | FALSE | 10 | ||
| Sheet (18) | Undefined | FALSE | 10 | ||
| Sheet (19) | Undefined | FALSE | 10 | ||
| Sheet (20) | Undefined | FALSE | 10 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.10 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2023\Montana\Duck_creek_Road\PW\[Duck_Creek_Road_controlsheet_update2.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 21-Aug-2023 8:24 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT : Duck Creek Road DATE OF FIELD WORK :September 2022 DATE OF FINAL ADJUSTMENT : 12/12/2022 COORDINATE SYSTEM : Montana SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot PROJECT UNITS : International foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 22100 | 1382127.290 | 2704193.027 | 2339.903 | 48°00'08.793167"N | 106°29'34.414043"W | 2284.6274 | 0.9994331794 | MDT 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. | |||||
| 22101 | 1381047.265 | 2704043.941 | 2335.619 | 47°59'58.194419"N | 106°29'37.215364"W | 2280.3527 | 0.9994324918 | 5/8" ir w/fhwa alum cap | |||||||
| 22102 | 1379060.774 | 2702215.742 | 2315.463 | 47°59'39.287879"N | 106°30'05.207739"W | 2260.2313 | 0.9994318685 | 5/8" ir w/fhwa alum cap | |||||||
| 22103 | 1378603.772 | 2701038.287 | 2322.503 | 47°59'35.223750"N | 106°30'22.771103"W | 2267.2883 | 0.9994311923 | 1/2" IR w/orange plastic cap | |||||||
| 22104 | 1377135.735 | 2697313.516 | 2302.707 | 47°59'22.141869"N | 106°31'18.338772"W | 2247.5429 | 0.9994310452 | 5/8" ir w/fhwa alum cap | |||||||
| 22105 | 1377488.451 | 2696385.469 | 2303.927 | 47°59'25.969838"N | 106°31'31.781375"W | 2248.7718 | 0.999431305 | 5/8" ir w/fhwa alum cap | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 |
PROJECT : Duck Creek Road DATE OF FIELD WORK :September 2022
DATE OF FINAL ADJUSTMENT : 12/12/2022
COORDINATE SYSTEM : Montana SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot
PROJECT UNITS : International foot
| PROJECT COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 22100 | 1382127.290 | 2704193.027 | 2339.903 | 48°00'08.793167"N | 106°29'34.414043"W | 2284.627 | 0.99943318 | MDT Alum cap | |
| 22101 | 1381047.265 | 2704043.941 | 2335.619 | 47°59'58.194419"N | 106°29'37.215364"W | 2280.353 | 0.99943249 | 5/8" ir w/fhwa alum cap | |
| 22102 | 1379060.774 | 2702215.742 | 2315.463 | 47°59'39.287879"N | 106°30'05.207739"W | 2260.231 | 0.99943187 | 5/8" ir w/fhwa alum cap | |
| 22103 | 1378603.772 | 2701038.287 | 2322.503 | 47°59'35.223750"N | 106°30'22.771103"W | 2267.288 | 0.99943119 | 1/2" IR w/orange plastic cap | |
| 22104 | 1377135.735 | 2697313.516 | 2302.707 | 47°59'22.141869"N | 106°31'18.338772"W | 2247.543 | 0.99943105 | 5/8" ir w/fhwa alum cap | |
| 22105 | 1377488.451 | 2696385.469 | 2303.927 | 47°59'25.969838"N | 106°31'31.781375"W | 2248.772 | 0.99943130 | 5/8" ir w/fhwa alum cap |
File details come from the government source that posted it. Updated .