yell2019(1)_survey-control.xlsx

XLSX spreadsheet 40 KB Posted Jun 19, 2020

Attached to: WY NPS YELL 2019(1)Roosevelt Lodge Parking Lot
Solicitation number: 69056719R000010
Issued by: Department of Transportation Federal Highway Administration

View the file

Other files

File	Type	Posted
QA_07-20-2020.pdf	PDF	Jul 20, 2020
Amendment A002.pdf	PDF	Jul 20, 2020
Amendment A001.pdf	PDF	Jul 17, 2020
yell2019(1)_plans.pdf	PDF	Jun 19, 2020
SWPPP WY NPS YELL 2019(1) Roosevelt Lodge Parking Lot Scan.pdf	PDF	Jun 19, 2020
GM 24-20 WY NPS YELL 2019(1) Roosevelt Lodge Parking Subsurface Investigation Results Memo.pdf	PDF	Jun 19, 2020
WY NPS YELL 2019(1) Roosevelt Lodge Parking Lot ds.pdf	PDF	Jun 19, 2020
yell2019(1)_x-sections.pdf	PDF	Jun 19, 2020
Roosevelt End Area Volumes.pdf	PDF	Jun 19, 2020

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

Drawing No:

Designed by:	DJ&A
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	8	rows w/data	OK - no spaces in data
Max. row/table	40	8	data rows	Warnings:
		40	rows/table
			PROJECT : Roosevelt Lodge

DATE OF FIELD WORK : Multiple Entries

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Wyoming West SPCS NAD83(2011)

EPOCH DATE : 2010.000

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.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

C:\MyFiles\Projects\Yellowstone\2019\Roosevelt\[Roosevelt_Controlsheet.xlsx]Sheet

Reference:

Time

17-May-2019 8:50 AM

Begin Column:

PROJECT : Roosevelt Lodge DATE OF FIELD WORK : Multiple Entries

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Wyoming West SPCS NAD83(2011)

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					4000	1936494.273	2538449.282	6324.820	44°54'46.610523"N	110°24'58.117507"W	6297.047	0.9996451653	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.
					4001	1936658.998	2538681.211	6307.620	44°54'48.246448"N	110°24'54.903929"W	6279.8514	0.999645941	5/8" IR w/fhwa alum cap
					4002	1936807.227	2538905.175	6301.130	44°54'49.719140"N	110°24'51.800050"W	6273.3657	0.9996462068	5/8" IR w/fhwa alum cap
					4003	1937041.725	2539324.446	6270.600	44°54'52.051493"N	110°24'45.986900"W	6242.8438	0.9996475826	5/8" IR w/fhwa alum cap
					4004	1937391.024	2538748.870	6275.950	44°54'55.477426"N	110°24'54.005292"W	6248.1915	0.9996474398	5/8" IR w/fhwa alum cap
					4005	1937318.141	2538397.719	6283.080	44°54'54.743557"N	110°24'58.881022"W	6255.3165	0.9996471685	5/8" IR w/fhwa alum cap
					4006	1936881.752	2538378.825	6306.690	44°54'50.433754"N	110°24'59.118695"W	6278.9208	0.9996460449	5/8" IR w/fhwa alum cap
					4007	1937507.197	2538985.586	6267.290	44°54'56.634094"N	110°24'50.722269"W	6239.536	0.9996478068	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
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0

PROJECT : Roosevelt Lodge DATE OF FIELD WORK : Multiple Entries

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Wyoming West SPCS NAD83(2011)

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	4000	1936494.273	2538449.282	6324.820	44°54'46.610523"N	110°24'58.117507"W	6297.047	0.99964517	5/8" IR w/fhwa alum cap
	4001	1936658.998	2538681.211	6307.620	44°54'48.246448"N	110°24'54.903929"W	6279.851	0.99964594	5/8" IR w/fhwa alum cap
	4002	1936807.227	2538905.175	6301.130	44°54'49.719140"N	110°24'51.800050"W	6273.366	0.99964621	5/8" IR w/fhwa alum cap
	4003	1937041.725	2539324.446	6270.600	44°54'52.051493"N	110°24'45.986900"W	6242.844	0.99964758	5/8" IR w/fhwa alum cap
	4004	1937391.024	2538748.870	6275.950	44°54'55.477426"N	110°24'54.005292"W	6248.192	0.99964744	5/8" IR w/fhwa alum cap
	4005	1937318.141	2538397.719	6283.080	44°54'54.743557"N	110°24'58.881022"W	6255.317	0.99964717	5/8" IR w/fhwa alum cap
	4006	1936881.752	2538378.825	6306.690	44°54'50.433754"N	110°24'59.118695"W	6278.921	0.99964604	5/8" IR w/fhwa alum cap
	4007	1937507.197	2538985.586	6267.290	44°54'56.634094"N	110°24'50.722269"W	6239.536	0.99964781	5/8" IR w/fhwa alum cap

File details come from the government source that posted it. Updated Jun 19, 2020.