Survey_control.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
MT NP GLAC 14(6), Swiftcurrent Spur Road Rehabilitation
Solicitation number
69056724B000012
Issued by

About this file

This document appears to be a Survey Control point list for the MT NP GLAC 14(6), Swiftcurrent Spur Road Rehabilitation project. The file contains information on survey control points including their state plane coordinates, geographic coordinates, elevations, descriptions, and combined factors. This information is being provided to support the federal contract opportunity for the Swiftcurrent Spur Road Rehabilitation project. The related federal contract opportunity is a solicitation issued by the Department of Transportation Federal Highway Administration for the MT NP GLAC 14(6) project. The solicitation includes full requirements for the road rehabilitation work, but details on the specific products or services, response dates, award dates, pricing terms, set asides, or incumbents are not provided in this document.

View the file

Other files

Show all 29

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:MTNote: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
Project:NP GLAC 14(6)
NPS PMIS /

Drawing No:

Designed by:WFLHD Survey
Date:1/1904
Checked by:WFLHD Survey
Date:1/1904
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/table53.0
Base sheet name:Sheet21rows w/dataOK - no spaces in data
Max. row/table4021data rowsWarnings:
40rows/table
PROJECT :Many Glacier Road

DATE OF FIELD WORK : Multiple entries

LATEST CONTROL ADJUSTMENT : 8/2022

COORDINATE SYSTEM : Montana SPCS NAD83 (2011) VERTICAL DATUM : Elevations determined through differential Leveling holding initial elevation at 12601 NAV88 GEOID12b CADD PROGRAM 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 NameSheetHeader rowSheet NumberNotes
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: 15 June 2015

Sheet

Sheet Information
Sheet num:D.1Filename0
Sheet name:SheetC:\pw-work\d0578635\[mt_np_glac_14(6)_controlsheet.xlsx]Sheet
Reference:Time
24-May-2023 8:28 AM
Begin Column:ABCDEFGHI

PROJECT :Many Glacier Road DATE OF FIELD WORK : Multiple entries LATEST CONTROL ADJUSTMENT : 8/2022 COORDINATE SYSTEM : Montana SPCS NAD83 (2011) VERTICAL DATUM : Elevations determined through differential Leveling holding initial elevation at 12601 NAV88 GEOID12b CADD PROGRAM COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot

PROJECT UNITS : International foot

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
CP221921685826.294967286.7954896.91448°48'03.671127"N113°39'23.473830"W4849.68110.99965219855/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.
CP221931685698.737966923.9664915.41948°48'02.224184"N113°39'28.785125"W4868.18650.9996510935/8" IR w/FHWA Alum Cap
CP221941685768.250966602.0114907.32048°48'02.740581"N113°39'33.642875"W4860.08870.99965155885/8" IR w/FHWA Alum Cap
CP221951685663.045966178.6654904.33148°48'01.482066"N113°39'39.874528"W4857.10010.99965150835/8" IR w/FHWA Alum Cap
CP221961685653.918965872.5254906.22248°48'01.231682"N113°39'44.433978"W4858.99170.99965137965/8" IR w/FHWA Alum Cap
CP221971685527.394965676.4374906.02048°47'59.882081"N113°39'47.258609"W4858.78930.99965118225/8" IR w/FHWA Alum Cap
CP221981685328.116965304.7644909.51548°47'57.723442"N113°39'52.644597"W4862.28380.99965068435/8" IR w/FHWA Alum Cap
CP221991685273.285964932.8534911.04948°47'56.988035"N113°39'58.148725"W4863.8180.99965049835/8" IR w/FHWA Alum Cap
CP222001685132.665964720.8054909.30448°47'55.491061"N113°40'01.200062"W4862.07260.99965035215/8" IR w/FHWA Alum Cap
CP222011684949.098964595.4324898.32348°47'53.616343"N113°40'02.924358"W4851.09110.9996505895/8" IR w/FHWA Alum Cap
CP222021684814.169963928.8894904.63248°47'51.936788"N113°40'12.759454"W4857.40030.99965003045/8" IR w/FHWA Alum Cap
CP222031684802.486963714.4624909.70748°47'51.709040"N113°40'15.948591"W4862.47540.99964975325/8" IR w/FHWA Alum Cap
CP222041684853.787963498.4754915.65548°47'52.101112"N113°40'19.211078"W4868.42380.99964952935/8" IR w/FHWA Alum Cap
CP222051684825.035963265.8614916.71348°47'51.695556"N113°40'22.657912"W4869.48190.99964941675/8" IR w/FHWA Alum Cap
CP222061684850.425962955.4274916.88048°47'51.782597"N113°40'27.308579"W4869.64930.9996494225/8" IR w/FHWA Alum Cap
CP222071684766.843962657.2594919.64848°47'50.802200"N113°40'31.689558"W4872.41750.99964913975/8" IR w/FHWA Alum Cap
CP222081684830.083962451.4154922.03448°47'51.317135"N113°40'34.810273"W4874.80390.99964910465/8" IR w/FHWA Alum Cap
CP222091684804.544962208.7474924.68848°47'50.937827"N113°40'38.409583"W4877.45810.99964891985/8" IR w/FHWA Alum Cap
DJA111684753.108964187.5624898.99848°47'51.470900"N113°40'08.852517"W4851.76590.999650228aluminum cap
DJA121684814.523962484.6504921.75548°47'51.181282"N113°40'34.302151"W4874.52480.9996490971aluminum cap
MG1011684787.649964290.3244899.07148°47'51.865227"N113°40'07.347152"W4851.83890.99965028494" brass cap
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000

PROJECT :Many Glacier Road DATE OF FIELD WORK : Multiple entries

LATEST CONTROL ADJUSTMENT : 8/2022

COORDINATE SYSTEM : Montana SPCS NAD83 (2011) VERTICAL DATUM : Elevations determined through differential Leveling holding initial elevation at 12601 NAV88 GEOID12b CADD PROGRAM COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot

PROJECT UNITS : International foot

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
CP221921685826.294967286.7954896.91448°48'03.671127"N113°39'23.473830"W4849.68110.999652205/8" IR w/FHWA Alum Cap
CP221931685698.737966923.9664915.41948°48'02.224184"N113°39'28.785125"W4868.18650.999651095/8" IR w/FHWA Alum Cap
CP221941685768.25966602.0114907.3248°48'02.740581"N113°39'33.642875"W4860.08870.999651565/8" IR w/FHWA Alum Cap
CP221951685663.045966178.6654904.33148°48'01.482066"N113°39'39.874528"W4857.10010.999651515/8" IR w/FHWA Alum Cap
CP221961685653.918965872.5254906.22248°48'01.231682"N113°39'44.433978"W4858.99170.999651385/8" IR w/FHWA Alum Cap
CP221971685527.394965676.4374906.0248°47'59.882081"N113°39'47.258609"W4858.78930.999651185/8" IR w/FHWA Alum Cap
CP221981685328.116965304.7644909.51548°47'57.723442"N113°39'52.644597"W4862.28380.999650685/8" IR w/FHWA Alum Cap
CP221991685273.285964932.8534911.04948°47'56.988035"N113°39'58.148725"W4863.8180.999650505/8" IR w/FHWA Alum Cap
CP222001685132.665964720.8054909.30448°47'55.491061"N113°40'01.200062"W4862.07260.999650355/8" IR w/FHWA Alum Cap
CP222011684949.098964595.4324898.32348°47'53.616343"N113°40'02.924358"W4851.09110.999650595/8" IR w/FHWA Alum Cap
CP222021684814.169963928.8894904.63248°47'51.936788"N113°40'12.759454"W4857.40030.999650035/8" IR w/FHWA Alum Cap
CP222031684802.486963714.4624909.70748°47'51.709040"N113°40'15.948591"W4862.47540.999649755/8" IR w/FHWA Alum Cap
CP222041684853.787963498.4754915.65548°47'52.101112"N113°40'19.211078"W4868.42380.999649535/8" IR w/FHWA Alum Cap
CP222051684825.035963265.8614916.71348°47'51.695556"N113°40'22.657912"W4869.48190.999649425/8" IR w/FHWA Alum Cap
CP222061684850.425962955.4274916.8848°47'51.782597"N113°40'27.308579"W4869.64930.999649425/8" IR w/FHWA Alum Cap
CP222071684766.843962657.2594919.64848°47'50.802200"N113°40'31.689558"W4872.41750.999649145/8" IR w/FHWA Alum Cap
CP222081684830.083962451.4154922.03448°47'51.317135"N113°40'34.810273"W4874.80390.999649105/8" IR w/FHWA Alum Cap
CP222091684804.544962208.7474924.68848°47'50.937827"N113°40'38.409583"W4877.45810.999648925/8" IR w/FHWA Alum Cap
DJA111684753.108964187.5624898.99848°47'51.470900"N113°40'08.852517"W4851.76590.99965023aluminum cap
DJA121684814.523962484.654921.75548°47'51.181282"N113°40'34.302151"W4874.52480.99964910aluminum cap
MG1011684787.649964290.3244899.07148°47'51.865227"N113°40'07.347152"W4851.83890.999650284" brass cap

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