mt-a0300461_control-points.xlsx

XLSX spreadsheet 41 KB Posted Oct 13, 2023

Attached to: MT BIGHORN 46(1) WARMAN LOOP ROAD Federal contract opportunity
Solicitation number: 69056721B000003
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains an Excel file with survey control point data and related federal contract opportunity details. The Excel file provides state plane and geo coordinates, elevations, descriptions and notes for 10 survey control points for the Montana BIGHORN 46(1) WARMAN LOOP ROAD project. The related federal contract opportunity is solicitation number 69056721B000003 from the Department of Transportation Federal Highway Administration to perform survey and design work for the WARMAN LOOP ROAD project in Montana. No pricing, response dates or other requirement details are included in the opportunity description.

View the file

Other files for this federal contract opportunity

Other files attached to MT BIGHORN 46(1) WARMAN LOOP ROAD, newest first.
File	Type	Posted
mt-a0300461_Geotechnical Pavement Recon Report.pdf	PDF	Oct 13, 2023
MDT Structure Inspection Report v1.2_02247_01-31-2022_RFS.pdf	PDF	Oct 13, 2023
mt-a0300461_proposedalignment.pdf	PDF	Oct 13, 2023
mt-a0300461_WarmanLoopRoad_HydraulicsReport.pdf	PDF	Oct 13, 2023
FLH Bridge oversized or overload vehicle permit request form Oct 2018.pdf	PDF	Oct 13, 2023
mt-a0300461_plans.pdf	PDF	Oct 13, 2023
mt-a0300461_WarmanLoopRoad_RevisedFinalGeotechnicalReport.pdf	PDF	Oct 13, 2023
IFB 69056721B000003.pdf	PDF	Oct 13, 2023
Physical Data MT BIGHORN 46(1).zip	ZIP file	Oct 13, 2023

On GovTribe

Work with this file on GovTribe

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:	BIGHORN 46(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	10	rows w/data	OK - no spaces in data
Max. row/table	40	10	data rows	Warnings:
		40	rows/table
			PROJECT :Warman Loop Road

DATE OF FIELD WORK :March 2020 DATE OF FINAL ADJUSTMENT : March 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	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

Sheet name:

Sheet

F:\highways\FHWA\19500015_mt-a0300461_WarmanLoopRoad\Warman Loop Road\dgn\Plan and Profile\[mt-a0300461_controlsheet.xlsx]Sheet

Reference:

Time

5-Oct-2020 11:47 AM

Begin Column:

PROJECT :Warman Loop Road DATE OF FIELD WORK :March 2020 DATE OF FINAL ADJUSTMENT : March 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:
					WL1	405175.769	2404860.473	3169.708	45°20'53.467344"N	107°48'08.636020"W	3125.1864	0.9996595541	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.
					WL2	404805.504	2404871.001	3174.232	45°20'49.809596"N	107°48'08.600989"W	3129.7242	0.9996598431	5/8" IR w/FHWA Alum Cap
					WL3	404911.648	2400344.758	3170.763	45°20'51.821163"N	107°49'11.940419"W	3126.4669	0.9996597205	5/8" IR w/FHWA Alum Cap
					WL4	405039.355	2399573.603	3171.551	45°20'53.245151"N	107°49'22.699088"W	3127.2867	0.9996594845	5/8" IR w/FHWA Alum Cap
					WL5	403541.438	2395185.676	3168.339	45°20'39.379563"N	107°50'24.579752"W	3124.3424	0.9996615441	5/8" IR w/FHWA Alum Cap
					WL6	403516.308	2394362.973	3159.679	45°20'39.303440"N	107°50'36.105208"W	3115.7217	0.9996619664	5/8" IR w/FHWA Alum Cap
					WL7	403370.940	2389022.359	3146.488	45°20'38.976620"N	107°51'50.917864"W	3102.7836	0.9996626296	5/8" IR w/FHWA Alum Cap
					WL8	403304.663	2388169.658	3147.820	45°20'38.497954"N	107°52'02.875257"W	3104.1557	0.9996626304	5/8" IR w/FHWA Alum Cap
					WL9	398962.057	2388104.957	3196.552	45°19'55.637632"N	107°52'05.047986"W	3153.0499	0.9996662555	5/8" IR w/FHWA Alum Cap
					WL10	399141.803	2388369.776	3200.692	45°19'57.357721"N	107°52'01.288793"W	3157.1714	0.9996658186	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

PROJECT :Warman Loop Road DATE OF FIELD WORK :March 2020 DATE OF FINAL ADJUSTMENT : March 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
	WL1	405175.769	2404860.473	3169.708	45°20'53.467344"N	107°48'08.636020"W	3125.186	0.99965955	5/8" IR w/FHWA Alum Cap
	WL2	404805.504	2404871.001	3174.232	45°20'49.809596"N	107°48'08.600989"W	3129.724	0.99965984	5/8" IR w/FHWA Alum Cap
	WL3	404911.648	2400344.758	3170.763	45°20'51.821163"N	107°49'11.940419"W	3126.467	0.99965972	5/8" IR w/FHWA Alum Cap
	WL4	405039.355	2399573.603	3171.551	45°20'53.245151"N	107°49'22.699088"W	3127.287	0.99965948	5/8" IR w/FHWA Alum Cap
	WL5	403541.438	2395185.676	3168.339	45°20'39.379563"N	107°50'24.579752"W	3124.342	0.99966154	5/8" IR w/FHWA Alum Cap
	WL6	403516.308	2394362.973	3159.679	45°20'39.303440"N	107°50'36.105208"W	3115.722	0.99966197	5/8" IR w/FHWA Alum Cap
	WL7	403370.940	2389022.359	3146.488	45°20'38.976620"N	107°51'50.917864"W	3102.784	0.99966263	5/8" IR w/FHWA Alum Cap
	WL8	403304.663	2388169.658	3147.820	45°20'38.497954"N	107°52'02.875257"W	3104.156	0.99966263	5/8" IR w/FHWA Alum Cap
	WL9	398962.057	2388104.957	3196.552	45°19'55.637632"N	107°52'05.047986"W	3153.050	0.99966626	5/8" IR w/FHWA Alum Cap
	WL10	399141.803	2388369.776	3200.692	45°19'57.357721"N	107°52'01.288793"W	3157.171	0.99966582	5/8" IR w/FHWA Alum Cap

File details come from the government source that posted it. Updated Oct 13, 2023.