wa-ef-gifpn2020-1-1_controlsheet.xlsx

XLSX spreadsheet 39 KB Posted Aug 28, 2025

Attached to: WA ERFO FS GIFPN603 2020-1(1), Gifford Pinchot Repairs 2020, Phase 1
Solicitation number: 69056724B000011
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Aug 28, 2025

This file is a Survey Control point list Excel spreadsheet for the Gifford Pinchot National Forest road repair project. The document details precise geospatial survey information for a road repair project in Washington State, specifically the GP ERFO Repairs 2020, Phase 1 at the Copper Creek site. The survey was conducted in June 2023 using the Washington South State Plane Coordinate System (NAD83 2011) with orthometric elevations based on NAVD88 GEOID18, and uses international foot units for measurements.

The spreadsheet contains 14 survey points (numbered 23101-23114) with detailed coordinate data, including state plane coordinates, geographic coordinates, elevation, latitude/longitude, ellipsoid height, and combined factor. Each point is marked with a specific description such as "5/8 IR W/FHWA ALUM CAP" or "Spike", indicating the type of survey marker used. The project is associated with a Federal Highway Administration solicitation (69056724B000011) for road repairs in the Gifford Pinchot National Forest, with survey data collected to support infrastructure rehabilitation efforts.

View the file

Other files

File	Type	Posted
BidTabulation_WA ERFO FS GIFPN603 2020-1(1)_1.pdf	PDF	Oct 1, 2025
BidSum_WA ERFO FS GIFPN603 2020-1(1).pdf	PDF	Oct 1, 2025
QA_09-23-2025.pdf	PDF	Sep 23, 2025
Amendment A002.pdf	PDF	Sep 23, 2025
Amendment A001.pdf	PDF	Sep 17, 2025
QA_09-17-2025.pdf	PDF	Sep 17, 2025
QA_09-12-2025.pdf	PDF	Sep 12, 2025
QA_09-11-2025.pdf	PDF	Sep 11, 2025
wa-ef-gifpn2020-1-1_plans.pdf	PDF	Aug 28, 2025
WFLHD Construction Contract Administration_FY 23 V2.pdf	PDF	Aug 28, 2025
Physical Data.zip	ZIP file	Aug 28, 2025
wa-ef-gifpn2020-1-1_XS_culverts.pdf	PDF	Aug 28, 2025
wa-ef-gifpn2022-1-1__Earthwork.pdf	PDF	Aug 28, 2025
wa-ef-gifpn2020-1-1_XS.pdf	PDF	Aug 28, 2025
wa-ef-gifpn2022-1-1_proposed-alignment.pdf	PDF	Aug 28, 2025
wa-ef-gifpn2020-1-1_Hydraulic_Report.pdf	PDF	Aug 28, 2025
wa-ef-gifpn2020-1-1_final_GEO_Memo.pdf	PDF	Aug 28, 2025
GP2020_ERFO_EPA_CompiledSWPPP_signed.pdf	PDF	Aug 28, 2025
IFB_69056724B000011_WA ERFO FS GIFPN603 2020-1(1).pdf	PDF	Aug 28, 2025

Show all 19

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

Survey Control Sheet
	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.
Project:	WA ERFO FS GifPn603 2020-1(1)	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
NPS PMIS No.	NPS PMIS No.	Note: NPS fields do not appear on the sheet unless additional text is added.
NPS Drwg No.	NPS Drwg No.
First sheet #:	D.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	14	rows w/data	OK - no spaces in data
Max. row/table	35	14	data rows	Warnings:
		35	rows/table
			PROJECT : GP ERFO REPAIRS 2020, PHASE 1 Copper creek site

DATE OF FIELD WORK: 6/2023

DATE OF FINAL ADJUSTMENT : 6/2023

COORDINATE SYSTEM : Washington South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-SIF NSRS11(NAD83/2011) Washington, South Zone, International foot

PROJECT UNITS : International foot

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
Worksheet	Sheet	Header	Number	Notes
Sheet	D.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: 20 September 2023

Sheet

Sheet Information

Sheet num:

D.1

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2024\Washington\Copper_Creek_ERFO\[copper_creek_controlsheet_edit.xlsx]Sheet

Reference:

Time

4-Nov-2024 7:46 AM

Begin Column:

C:\MyFiles\Projects_2024\Washington\Copper_Creek_ERFO\[copper_creek_controlsheet_edit.xlsx]Sheet
	PROJECT : GP ERFO REPAIRS 2020, PHASE 1 Copper creek site

DATE OF FIELD WORK: 6/2023

DATE OF FINAL ADJUSTMENT : 6/2023

PROJECT UNITS : International foot COORDINATE SYSTEM : Washington South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-SIF NSRS11(NAD83/2011) Washington, South Zone, International foot

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ORTHOMETRIC ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					23101	522671.696	1275283.000	2052.384	46°45'26.537145"N	121°57'24.956926"W	1986.7166	0.9998242027	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.
					23102	522644.832	1275490.575	2077.936	46°45'26.309832"N	121°57'21.968807"W	2012.2793	0.9998229784	5/8 IR W/FHWA ALUM CAP
					23103	522684.550	1275685.828	2100.525	46°45'26.737415"N	121°57'19.175289"W	2034.8811	0.999821905	Spike
					23104	522720.879	1275763.930	2107.795	46°45'27.110195"N	121°57'18.063273"W	2042.1571	0.9998215629	Spike
					23105	522759.202	1276110.845	2145.292	46°45'27.551570"N	121°57'13.091330"W	2079.6749	0.9998197773	Spike
					23106	522987.383	1276254.302	2173.421	46°45'29.829753"N	121°57'11.091498"W	2107.8207	0.9998184662	5/8 IR W/FHWA ALUM CAP
					23107	522973.165	1276598.680	2210.899	46°45'29.752016"N	121°57'06.142007"W	2145.3183	0.9998166739	5/8 IR W/FHWA ALUM CAP
					23108	523010.745	1276800.525	2230.701	46°45'30.159581"N	121°57'03.253162"W	2165.1339	0.9998157334	Spike
					23109	522953.011	1277094.466	2258.010	46°45'29.643105"N	121°56'59.016522"W	2192.4576	0.9998144207	5/8 IR W/FHWA ALUM CAP
					23110	523028.650	1277187.110	2271.284	46°45'30.406451"N	121°56'57.705993"W	2205.7402	0.9998137975	5/8 IR W/FHWA ALUM CAP
					23111	523135.100	1276929.719	2299.093	46°45'31.410392"N	121°57'01.430600"W	2233.5378	0.9998124845	Hub & Tack
					23112	523249.351	1276738.218	2323.903	46°45'32.503247"N	121°57'04.211036"W	2258.3403	0.9998113158	Spike
					23113	523315.929	1276548.386	2345.078	46°45'33.125874"N	121°57'06.954912"W	2279.5065	0.999810314	5/8 IR W/FHWA ALUM CAP
					23114	523301.475	1276331.873	2365.739	46°45'32.943868"N	121°57'10.060553"W	2300.1546	0.9998093251	5/8 IR W/FHWA ALUM CAP
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0

4-Nov-2024 7:46 AM

PROJECT : GP ERFO REPAIRS 2020, PHASE 1 Copper creek site

DATE OF FIELD WORK: 6/2023

DATE OF FINAL ADJUSTMENT : 6/2023

COORDINATE SYSTEM : Washington South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-SIF NSRS11(NAD83/2011) Washington, South Zone, International foot

PROJECT UNITS : International foot

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	23101	522671.696	1275283.000	2052.384	46°45'26.537145"N	121°57'24.956926"W	1986.717	0.99982420	5/8 IR W/FHWA ALUM CAP
	23102	522644.832	1275490.575	2077.936	46°45'26.309832"N	121°57'21.968807"W	2012.279	0.99982298	5/8 IR W/FHWA ALUM CAP
	23103	522684.550	1275685.828	2100.525	46°45'26.737415"N	121°57'19.175289"W	2034.881	0.99982191	Spike
	23104	522720.879	1275763.930	2107.795	46°45'27.110195"N	121°57'18.063273"W	2042.157	0.99982156	Spike
	23105	522759.202	1276110.845	2145.292	46°45'27.551570"N	121°57'13.091330"W	2079.675	0.99981978	Spike
	23106	522987.383	1276254.302	2173.421	46°45'29.829753"N	121°57'11.091498"W	2107.821	0.99981847	5/8 IR W/FHWA ALUM CAP
	23107	522973.165	1276598.680	2210.899	46°45'29.752016"N	121°57'06.142007"W	2145.318	0.99981667	5/8 IR W/FHWA ALUM CAP
	23108	523010.745	1276800.525	2230.701	46°45'30.159581"N	121°57'03.253162"W	2165.134	0.99981573	Spike
	23109	522953.0105	1277094.4661	2258.01	46°45'29.643105"N	121°56'59.016522"W	2192.4576	0.9998144207	5/8 IR W/FHWA ALUM CAP
	23110	523028.6497	1277187.1101	2271.2843	46°45'30.406451"N	121°56'57.705993"W	2205.7402	0.9998137975	5/8 IR W/FHWA ALUM CAP
	23111	523135.1003	1276929.7192	2299.0931	46°45'31.410392"N	121°57'01.430600"W	2233.5378	0.9998124845	Hub & Tack
	23112	523249.3506	1276738.2175	2323.9026	46°45'32.503247"N	121°57'04.211036"W	2258.3403	0.9998113158	Spike
	23113	523315.9288	1276548.386	2345.0775	46°45'33.125874"N	121°57'06.954912"W	2279.5065	0.999810314	5/8 IR W/FHWA ALUM CAP
	23114	523301.4751	1276331.8734	2365.7389	46°45'32.943868"N	121°57'10.060553"W	2300.1546	0.9998093251	5/8 IR W/FHWA ALUM CAP

File details come from the government source that posted it. Updated Aug 28, 2025.