mt-ef1817301_sur_MP6.91_9.24_controlsheet.xlsx

XLSX spreadsheet 41 KB Posted Mar 9, 2022

Attached to: MT FS ERFO 2018(1) - 73(1) Helena-Lewis & Clark 2018 Repairs, Phase 1
Solicitation number: 69056721B000024
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a survey control sheet and related federal contract opportunity details. The survey control sheet provides state plane coordinate and geographic coordinate data for 11 survey control points located at two sites along South Fork Teton FSR 109 in Montana. The control points were established in August-September 2020 and adjusted in September 2020 using the Montana SPCS NAD83 2011 coordinate system and NAVD88 vertical datum. The related federal contract opportunity is solicitation number 69056721B000024 for MT FS ERFO 2018(1) - 73(1) Helena-Lewis & Clark 2018 Repairs, Phase 1 issued by the Department of Transportation Federal Highway Administration. No further details are provided on the opportunity requirements, response dates, or award information.

View the file

Other files

File	Type	Posted
Bid Tabulation_MT FS ERFO 2018(1)-73(1).pdf	PDF	Apr 8, 2022
BidSum-MT FS ERFO 2018(1)-73(1).pdf	PDF	Apr 7, 2022
QA 3.17.22.pdf	PDF	Mar 17, 2022
mt-ef1817301_(924)_horizontal alignment.pdf	PDF	Mar 9, 2022
MT FS ERFO 2018 1-73 1_SB.pdf	PDF	Mar 9, 2022
DXF and XML zip files.zip	ZIP file	Mar 9, 2022
mt-ef1817301_(924)_vertical alignment.pdf	PDF	Mar 9, 2022
mt-ef1817301_XS.pdf	PDF	Mar 9, 2022
mt-ef1817301_plans.pdf	PDF	Mar 9, 2022
mt-ef1817301_(691)_Earthwork.pdf	PDF	Mar 9, 2022
mt-ef1817301_GM 09-21_Helena Lewis and Clark Geotechnical Recommendations.pdf	PDF	Mar 9, 2022
mt-ef1817301_(691)_horizontal alignment.pdf	PDF	Mar 9, 2022
mt-ef1817301_SWPPPBinder.pdf	PDF	Mar 9, 2022
mt-ef1817301_(924)_Earthwork.pdf	PDF	Mar 9, 2022
mt-ef1817301_(691)_vertical alignment.pdf	PDF	Mar 9, 2022

Show all 15

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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:	MT	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	FS ERFO 2018(1)-73(1)
NPS PMIS /

Drawing No:

Designed by:	WFLHD Survey
Date:	1/1904
Checked by:	WFLHD Survey
Date:	1/1904
First sheet #:	J.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	5	3.0
Base sheet name:	Sheet	9	rows w/data	OK - no spaces in data
Max. row/table	40	11	data rows	Warnings: Empty lines found within data set
		40	rows/table
			PROJECT :South Fork Teton FSR 109 MP 6.91 & 9.24

DATE OF FIELD WORK : August-September 2020 DATE OF FINAL ADJUSTMENT : September 2020

PROJECT UNITS : International Foot COORDINATE SYSTEM : Montana SPCS NAD83 2011

EPOCH DATE : 2010.0000

VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

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	J.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: 15 June 2015

Sheet

Sheet Information

Sheet num:

J.1

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2021\Montana\New folder\[MT_FS_ERFO_2018(1)-72(1)_MP6.91_9.24_controlsheet.xlsx]Sheet

Reference:

Time

19-Oct-2021 7:20 AM

Begin Column:

PROJECT :South Fork Teton FSR 109 MP 6.91 & 9.24 DATE OF FIELD WORK : August-September 2020 DATE OF FINAL ADJUSTMENT : September 2020 PROJECT UNITS : International Foot COORDINATE SYSTEM : Montana SPCS NAD83 2011

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
							MP 6.91							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.
					20101	1335248.151	1175737.089	5393.897	47°52'03.867736"N	112°43'56.107412"W	5351.035	0.9992487644	5/8" IR W/FHWA ALUM CAP
					20102	1335413.719	1175493.507	5413.607	47°52'05.401862"N	112°43'59.778871"W	5370.753	0.9992479349	5/8" IR W/FHWA ALUM CAP
					20103	1335549.436	1175218.556	5435.774	47°52'06.628684"N	112°44'03.892220"W	5392.929	0.9992469658	5/8" IR W/FHWA ALUM CAP
					20104	1335585.007	1174911.377	5442.141	47°52'06.854366"N	112°44'08.417442"W	5399.308	0.9992466778	5/8" IR W/FHWA ALUM CAP
					20105	1335619.498	1174615.377	5439.852	47°52'07.073905"N	112°44'12.778120"W	5397.031	0.9992468025	5/8" IR W/FHWA ALUM CAP	2.	Survey control is available for these 2 sites only
							MP 9.24
					20201	1331984.048	1165901.876	5648.341	47°51'27.636261"N	112°46'18.300180"W	5605.858	0.9992339856	5/8" IR W/FHWA ALUM CAP
					20202	1331792.335	1165718.563	5649.506	47°51'25.669415"N	112°46'20.869719"W	5607.031	0.9992337884	5/8" IR W/FHWA ALUM CAP
					20203	1331407.995	1165352.831	5659.581	47°51'21.727026"N	112°46'25.994973"W	5617.121	0.9992330241	5/8" IR W/FHWA ALUM CAP
					20204	1331221.879	1165169.121	5666.600	47°51'19.815181"N	112°46'28.573603"W	5624.148	0.9992325517	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

PROJECT :South Fork Teton FSR 109 MP 6.91 & 9.24 DATE OF FIELD WORK : August-September 2020 DATE OF FINAL ADJUSTMENT : September 2020

PROJECT UNITS : International Foot COORDINATE SYSTEM : Montana SPCS NAD83 2011

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION

20101	1335248.151	1175737.089	5393.897	47°52'03.867736"N	112°43'56.107412"W	5351.035	0.99924876	5/8" IR W/FHWA ALUM CAP
20102	1335413.719	1175493.507	5413.607	47°52'05.401862"N	112°43'59.778871"W	5370.753	0.99924793	5/8" IR W/FHWA ALUM CAP
20103	1335549.436	1175218.556	5435.774	47°52'06.628684"N	112°44'03.892220"W	5392.929	0.99924697	5/8" IR W/FHWA ALUM CAP
20104	1335585.007	1174911.377	5442.141	47°52'06.854366"N	112°44'08.417442"W	5399.308	0.99924668	5/8" IR W/FHWA ALUM CAP
20105	1335619.498	1174615.377	5439.852	47°52'07.073905"N	112°44'12.778120"W	5397.031	0.99924680	5/8" IR W/FHWA ALUM CAP

20201	1331984.048	1165901.876	5648.341	47°51'27.636261"N	112°46'18.300180"W	5605.858	0.99923399	5/8" IR W/FHWA ALUM CAP
20202	1331792.335	1165718.563	5649.506	47°51'25.669415"N	112°46'20.869719"W	5607.031	0.99923379	5/8" IR W/FHWA ALUM CAP
20203	1331407.995	1165352.831	5659.581	47°51'21.727026"N	112°46'25.994973"W	5617.121	0.99923302	5/8" IR W/FHWA ALUM CAP
20204	1331221.879	1165169.121	5666.600	47°51'19.815181"N	112°46'28.573603"W	5624.148	0.99923255	5/8" IR W/FHWA ALUM CAP

File details come from the government source that posted it. Updated Mar 9, 2022.