libi10-2_LittleBighorn_SUR_controlsheet.xlsx

XLSX spreadsheet 45 KB Posted Sep 19, 2024

Attached to: MT NP LIBI 10 (2), Little Bighorn Battlefield National Monument
Solicitation number: 69056723B000002
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Sep 19, 2024

This document appears to be a survey control point list in Excel format that provides survey information for the Little Bighorn Battlefield Road project. The file includes the state, project name, design and survey dates, coordinate system, and other details. It lists 21 survey control points with their northing, easting, elevation, latitude, longitude, ellipsoid height, combined factor, and description.

The related federal contract opportunity is Solicitation Number 69056723B000002 for the MT NP LIBI 10 (2), Little Bighorn Battlefield National Monument project. The Department of Transportation Federal Highway Administration is the awarding agency. The solicitation seeks services for this project but the specific requirements are not provided in the documents given.

View the file

Other files

File	Type	Posted
Tabulation of Bids_MT NP LIBI 10(2).pdf	PDF	Oct 23, 2024
BidSum_MT NP LIBI 10(2).pdf	PDF	Oct 22, 2024
BidSum_MT NP LIBI 10(2).pdf	PDF	Oct 22, 2024
QA_10-16-2024.pdf	PDF	Oct 16, 2024
QA_10-15-2024.pdf	PDF	Oct 15, 2024
QA_10-11-2024.pdf	PDF	Oct 11, 2024
LIBI entrance gate electrical drawing.pdf	PDF	Oct 10, 2024
Amendment A002.pdf	PDF	Oct 10, 2024
QA_10-10-2024.pdf	PDF	Oct 10, 2024
as-maintained electrical drawing.pdf	PDF	Oct 10, 2024
QA_10-08-2024.pdf	PDF	Oct 8, 2024
Amendment A001.pdf	PDF	Oct 8, 2024
libi10-2_LittleBighorn_AlignmentData.pdf	PDF	Sep 19, 2024
libi10-2_LittleBighorn_XS.pdf	PDF	Sep 19, 2024
IFB 69056723B000002.pdf	PDF	Sep 19, 2024
libi10-2_ProjectNameChangeMemo.pdf	PDF	Sep 19, 2024
libi01002_FinalGeotech_PavementReport GR56-20.pdf	PDF	Sep 19, 2024
libi10-2_LittleBighorn_PLANS_Stamped.pdf	PDF	Sep 19, 2024
libi01002_LittleBighornParkRoad_FinalGeotechAddendum GM40-23.pdf	PDF	Sep 19, 2024
libi10-2_LittleBighorn_Phyiscal Data.zip	ZIP file	Sep 19, 2024

Show all 20

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:	PRA LIBI (2)
NPS PMIS /

Drawing No:

Designed by:	WFLHD Survey
Date:	1/1904
Checked by:	WFLHD SUrvey
Date:	1/1904
First sheet #:	D.54	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	21	rows w/data	OK - no spaces in data
Max. row/table	40	21	data rows	Warnings:
		40	rows/table
			PROJECT : Little Bighorn Battlefield Road

DATE OF FIELD WORK : Multiple entries

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

EPOCH DATE : 2010.0000

VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

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.54	3	54	OK
	Sheet (2)	Undefined	FALSE	54
	Sheet (3)	Undefined	FALSE	54
	Sheet (4)	Undefined	FALSE	54
	Sheet (5)	Undefined	FALSE	54
	Sheet (6)	Undefined	FALSE	54
	Sheet (7)	Undefined	FALSE	54
	Sheet (8)	Undefined	FALSE	54
	Sheet (9)	Undefined	FALSE	54
	Sheet (10)	Undefined	FALSE	54
	Sheet (11)	Undefined	FALSE	54
	Sheet (12)	Undefined	FALSE	54
	Sheet (13)	Undefined	FALSE	54
	Sheet (14)	Undefined	FALSE	54
	Sheet (15)	Undefined	FALSE	54
	Sheet (16)	Undefined	FALSE	54
	Sheet (17)	Undefined	FALSE	54
	Sheet (18)	Undefined	FALSE	54
	Sheet (19)	Undefined	FALSE	54
	Sheet (20)	Undefined	FALSE	54
	Total Sheets:	1	0	sheets missing

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.54

Filename

Sheet name:

Sheet

F:\highways\FHWA\24500013_mt-np-libi-10(2)_LittleBighorn_Phase1\DGN\Mapping and Survey\[RPA_LittleBighorn_2022_controlsheet.xlsx]Sheet

Reference:

Time

28-Jun-2024 2:09 PM

Begin Column:

PROJECT : Little Bighorn Battlefield Road DATE OF FIELD WORK : Multiple entries 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:
						5601	488732.971	2497601.871	3242.140	45°34'16.377328"N	107°25'59.427029"W	3194.3111	0.9995526039	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.
						5602	488111.965	2499430.867	3298.020	45°34'09.769281"N	107°25'33.949490"W	3250.209	0.9995507274	5/8" IR w/FHWA Alum Cap
						5603	486406.528	2500759.906	3295.740	45°33'52.585095"N	107°25'15.905305"W	3247.8987	0.9995529047	5/8" IR w/FHWA Alum Cap
						5604	484390.980	2500424.833	3231.280	45°33'32.775182"N	107°25'21.366075"W	3183.3985	0.9995583761	5/8" IR w/FHWA Alum Cap
						5605	482626.988	2500862.347	3184.960	45°33'15.246269"N	107°25'15.875775"W	3137.1443	0.9995627084	5/8" IR w/FHWA Alum Cap
						5606	480908.568	2502188.349	3107.420	45°32'57.933968"N	107°24'57.885650"W	3059.5932	0.999568516	5/8" IR w/FHWA Alum Cap
						5607	480110.787	2503757.355	3131.100	45°32'49.645443"N	107°24'36.139420"W	3083.2283	0.999568397	5/8" IR w/FHWA Alum Cap
						5608	478868.515	2505306.418	3211.000	45°32'36.973000"N	107°24'14.842337"W	3163.1563	0.9995661266	5/8" IR w/FHWA Alum Cap
						5609	477401.665	2505319.954	3251.720	45°32'22.488692"N	107°24'15.203706"W	3203.8716	0.9995659546	5/8" IR w/FHWA Alum Cap
						5610	476691.580	2505940.979	3277.660	45°32'15.314575"N	107°24'06.746822"W	3229.8266	0.9995655947	5/8" IR w/FHWA Alum Cap
						5611	475750.604	2506586.315	3319.070	45°32'05.854499"N	107°23'58.036054"W	3271.2347	0.9995647789	5/8" IR w/FHWA Alum Cap
						5612	476241.419	2507710.168	3394.095	45°32'10.401880"N	107°23'42.064204"W	3346.2706	0.9995606367	5/8" IR w/FHWA Alum Cap
						5613	475634.320	2508291.956	3451.410	45°32'04.254165"N	107°23'34.121254"W	3403.611	0.9995586538	5/8" IR w/FHWA Alum Cap
						5614	475180.852	2508567.658	3390.510	45°31'59.704303"N	107°23'30.420051"W	3342.7193	0.9995621214	5/8" IR w/FHWA Alum Cap
						5615	474160.448	2509047.339	3375.710	45°31'49.503414"N	107°23'24.068497"W	3327.8891	0.9995640861	5/8" IR w/FHWA Alum Cap
						5616	473059.361	2509457.966	3375.010	45°31'38.524319"N	107°23'18.718005"W	3327.2011	0.9995654739	5/8" IR w/FHWA Alum Cap
						5617	472637.970	2510720.051	3415.880	45°31'34.028056"N	107°23'01.152234"W	3368.0712	0.9995640777	5/8" IR w/FHWA Alum Cap
						5618	471794.332	2511980.740	3397.480	45°31'25.363035"N	107°22'43.767500"W	3349.6254	0.9995660309	5/8" IR w/FHWA Alum Cap
						5619	471094.831	2512323.878	3400.700	45°31'18.365878"N	107°22'39.214791"W	3352.8184	0.9995667454	5/8" IR w/FHWA Alum Cap
						5620	479304.080	2505108.336	3192.690	45°32'41.325227"N	107°24'17.461474"W	3144.8473	0.9995664693	5/8" IR w/FHWA Alum Cap
						5621	486225.835	2501739.171	3300.130	45°33'50.544390"N	107°25'02.209807"W	3252.3086	0.99955294	5/8" IR w/FHWA Alum Cap
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0
					0	0	0.000	0.000	0.000			0	0	0

PROJECT : Little Bighorn Battlefield Road DATE OF FIELD WORK : Multiple entries

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

			STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	ALIAS	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	Gate	5601	488732.971	2497601.871	3242.140	45°34'16.377328"N	107°25'59.427029"W	3194.311	0.99955260	5/8" IR w/FHWA Alum Cap	1
	29101	5602	488111.965	2499430.867	3298.020	45°34'09.769281"N	107°25'33.949490"W	3250.209	0.99955073	5/8" IR w/FHWA Alum Cap	2
	29102	5603	486406.528	2500759.906	3295.740	45°33'52.585095"N	107°25'15.905305"W	3247.899	0.99955290	5/8" IR w/FHWA Alum Cap	3
	29103	5604	484390.980	2500424.833	3231.280	45°33'32.775182"N	107°25'21.366075"W	3183.399	0.99955838	5/8" IR w/FHWA Alum Cap	4
	29104	5605	482626.988	2500862.347	3184.960	45°33'15.246269"N	107°25'15.875775"W	3137.144	0.99956271	5/8" IR w/FHWA Alum Cap	5
	29105	5606	480908.568	2502188.349	3107.420	45°32'57.933968"N	107°24'57.885650"W	3059.593	0.99956852	5/8" IR w/FHWA Alum Cap	6
	29106	5607	480110.787	2503757.355	3131.100	45°32'49.645443"N	107°24'36.139420"W	3083.228	0.99956840	5/8" IR w/FHWA Alum Cap	7
	29107	5608	478868.515	2505306.418	3211.000	45°32'36.973000"N	107°24'14.842337"W	3163.156	0.99956613	5/8" IR w/FHWA Alum Cap	8
	29108	5609	477401.665	2505319.954	3251.720	45°32'22.488692"N	107°24'15.203706"W	3203.872	0.99956595	5/8" IR w/FHWA Alum Cap	9
	29109	5610	476691.580	2505940.979	3277.660	45°32'15.314575"N	107°24'06.746822"W	3229.827	0.99956559	5/8" IR w/FHWA Alum Cap	10
	29110	5611	475750.604	2506586.315	3319.070	45°32'05.854499"N	107°23'58.036054"W	3271.235	0.99956478	5/8" IR w/FHWA Alum Cap	11
	29111	5612	476241.419	2507710.168	3394.095	45°32'10.401880"N	107°23'42.064204"W	3346.271	0.99956064	5/8" IR w/FHWA Alum Cap	12
	Weir	5613	475634.320	2508291.956	3451.410	45°32'04.254165"N	107°23'34.121254"W	3403.611	0.99955865	5/8" IR w/FHWA Alum Cap	13
	29112	5614	475180.852	2508567.658	3390.510	45°31'59.704303"N	107°23'30.420051"W	3342.719	0.99956212	5/8" IR w/FHWA Alum Cap	14
	29113	5615	474160.448	2509047.339	3375.710	45°31'49.503414"N	107°23'24.068497"W	3327.889	0.99956409	5/8" IR w/FHWA Alum Cap	15
	29114	5616	473059.361	2509457.966	3375.010	45°31'38.524319"N	107°23'18.718005"W	3327.201	0.99956547	5/8" IR w/FHWA Alum Cap	16	Added Cell in plm.dgn
	29115	5617	472637.970	2510720.051	3415.880	45°31'34.028056"N	107°23'01.152234"W	3368.071	0.99956408	5/8" IR w/FHWA Alum Cap	17
	29116	5618	471794.332	2511980.740	3397.480	45°31'25.363035"N	107°22'43.767500"W	3349.625	0.99956603	5/8" IR w/FHWA Alum Cap	18
	Reno	5619	471094.831	2512323.878	3400.700	45°31'18.365878"N	107°22'39.214791"W	3352.818	0.99956675	5/8" IR w/FHWA Alum Cap	19
	Hull	5620	479304.080	2505108.336	3192.690	45°32'41.325227"N	107°24'17.461474"W	3144.847	0.99956647	5/8" IR w/FHWA Alum Cap	20
	Calhoun	5621	486225.835	2501739.171	3300.130	45°33'50.544390"N	107°25'02.209807"W	3252.3086	0.99955294	5/8" IR w/FHWA Alum Cap	21

File details come from the government source that posted it. Updated Sep 19, 2024.