mt-d-malm202301_DAR2023(1)_control-point.xlsx

XLSX spreadsheet 41 KB Posted Jun 23, 2023

Attached to: MT DAR MALM 2023(1) Defense Access Roads FY 2023
Solicitation number: 69056723B000007
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a survey control point list and plan sheets for a federal Defense Access Roads project in Montana. Key details include the project name and number as MT DAR MALM 2023(1), field work dates of July 2022 and final adjustment date of August 2022. The survey control point list provides state plane coordinates, elevations, latitude and longitude, and ellipsoid heights for 16 control points along with their descriptions. The plan sheets layout follows the standard format including title blocks, notes, and control point data displayed across 16 numbered sheets.

View the file

Other files

File	Type	Posted
Award Notice tabs.pdf	PDF	Sep 12, 2023
Bid Tabulation_MT DAR MALM 2023(1).pdf	PDF	Aug 3, 2023
BidSum_MT DAR MALM 2023(1).pdf	PDF	Aug 2, 2023
QA_08-01-2023_02.pdf	PDF	Aug 1, 2023
QA_08-01-2023_01.pdf	PDF	Aug 1, 2023
QA_07-19-2023_01.pdf	PDF	Jul 19, 2023
Amendment A001.pdf	PDF	Jul 12, 2023
QA_07-12-2023_01.pdf	PDF	Jul 12, 2023
mt-d-malm202301_DAR2023(1)_XS.pdf	PDF	Jun 23, 2023
mt-d-malm202301_DAR2023(1)_proposed-vertical-alignment.pdf	PDF	Jun 23, 2023
mt-d-malm202301_DAR2023_SWPPP.pdf	PDF	Jun 23, 2023
Physical Data.zip	ZIP file	Jun 23, 2023
mt-d-malm202301_DAR2023(1)_Earthwork.pdf	PDF	Jun 23, 2023
mt-d-malm202301_DAR2023(1)_Plans_STAMPED.pdf	PDF	Jun 23, 2023
mt-d-malm202301_DAR2023(1)_proposed-horizontal-alignment.pdf	PDF	Jun 23, 2023
IFB_MT DAR MALM 2023(1)_69056723B000007.pdf	PDF	Jun 23, 2023
DAR Grizzly Bear Sightings Log.pdf	PDF	Jun 23, 2023
mt-d-malm202301_DAR2023(1)_XS_culverts.pdf	PDF	Jun 23, 2023

Show all 18

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:	MALM 2023(1)
NPS PMIS /

Drawing No:

Designed by:	S. Markwardt
Date:	1/1904
Checked by:	N. Bell
Date:	1/1904
First sheet #:	D.16	1.0
Title block text:	K-03 ROAD 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	5	rows w/data	OK - no spaces in data
Max. row/table	40	5	data rows	Warnings:
		40	rows/table
			PROJECT : DEFENSE ACCESS ROADS FY 2023

DATE OF FIELD WORK : JULY 2022

DATE OF FINAL ADJUSTMENT : AUGUST 2022

PROJECT UNITS : INTERNATIONAL FOOT

COORDINATE SYSTEM : SPCS NAD83(2011); MT ZONE 2500

VERTICAL DATUM : NAVD88 BASED ON GEOID 18

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

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.16

Filename

ERROR:#REF!

Sheet name:

Sheet

F:\highways\FHWA\22500007_mt-d-malm202301_DAR2023\Submittals\Grade Raise\[mt-d-malm202301_DAR2023(1)_control-point.xlsx]Sheet

Reference:

Time

24-Mar-2023 9:21 AM

Begin Column:

PROJECT : DEFENSE ACCESS ROADS FY 2023

DATE OF FIELD WORK : JULY 2022

DATE OF FINAL ADJUSTMENT : AUGUST 2022 PROJECT UNITS : INTERNATIONAL FOOT

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

FACTOR

1	816754.062	1908726.892	4381.289	46° 29' 24.08323"	-109° 44' 14.80965"	4342.206	0.9992266365	Set RPA RPC 30 ft N of road CL (Lower Nihill Rd) and 1.4 mi E of HWY 191
2	816758.615	1906656.889	4411.355	46° 29' 24.06514"	-109° 44' 44.41062"	4372.300	0.9992252008	Set RPA RPC 29 ft N of road CL (Lower Nihill Rd) and 140 ft W of wooden corral
3	816763.254	1905210.263	4421.039	46° 29' 24.06562"	-109° 45' 05.09741"	4382.003	0.9992247376	Set RPA RPC 29 ft N of road CL (Lower Nihill Rd) and 0.7 mi E of HWY 191
4	816763.445	1903180.460	4419.762	46° 29' 24.00212"	-109° 45' 34.12331"	4380.753	0.999224800	Set RPA RPC 28 ft N of road CL (Lower Nihill Rd) and 0.3 mi E of HWY 191
V295	816787.000	1901412.078	4400.013	46° 29' 24.17612"	-109° 45' 59.41207"	4361.027	0.999225734	Found Benchmark. See NGS Datasheet for V295.
0	0.000	0.000	0.000			0	0	0
0	0.000	0.000	0.000			0		NOTE:
0	0.000	0.000	0.000			0	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.
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			0
0	0.000	0.000	0.000			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 : DEFENSE ACCESS ROADS FY 2023

DATE OF FIELD WORK : JULY 2022

DATE OF FINAL ADJUSTMENT : AUGUST 2022

PROJECT UNITS : INTERNATIONAL FOOT

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	1	816754.062	1908726.892	4381.289	46° 29' 24.08323"	-109° 44' 14.80965"	4342.21	0.99922664	Set RPA RPC 30 ft N of road CL (Lower Nihill Rd) and 1.4 mi E of HWY 191
	2	816758.615	1906656.889	4411.355	46° 29' 24.06514"	-109° 44' 44.41062"	4372.30	0.99922520	Set RPA RPC 29 ft N of road CL (Lower Nihill Rd) and 140 ft W of wooden corral
	3	816763.254	1905210.263	4421.039	46° 29' 24.06562"	-109° 45' 05.09741"	4382.00	0.99922474	Set RPA RPC 29 ft N of road CL (Lower Nihill Rd) and 0.7 mi E of HWY 191
	4	816763.445	1903180.460	4419.762	46° 29' 24.00212"	-109° 45' 34.12331"	4380.75	0.99922480	Set RPA RPC 28 ft N of road CL (Lower Nihill Rd) and 0.3 mi E of HWY 191
	V295	816787.000	1901412.078	4400.013	46° 29' 24.17612"	-109° 45' 59.41207"	4361.03	0.99922573	Found Benchmark. See NGS Datasheet for V295.

File details come from the government source that posted it. Updated Jun 23, 2023.