okanogan_wenatchee_controlsheet.xlsx

XLSX spreadsheet 43 KB Posted Dec 23, 2019

Attached to: WA FS ERFO 2017(1)-23(3), Okanogan-Wenatchee 2017 Repairs, Phase 3
Solicitation number: 69056719B000022
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a federal contract opportunity and related survey control sheet for the Okanogan-Wenatchee 2017 Repairs, Phase 3 project. The federal contract opportunity is for construction services on US Forest Service lands located in Okanogan County, Washington. Work will consist of installing culverts and aquatic organism pipes, rebuilding damaged road slopes, rehabilitating roadways, reconstructing ditches, and placing aggregate and chip seal surfacing. The project length is 1.942 miles with an estimated price range between $1-2 million. The tentative fixed completion date is fall 2020. The survey control sheet provides location data for survey points to support the project, including state plane coordinates, elevations, and latitude and longitude for points across four townships.

View the file

Other files

File	Type	Posted
BidSum.pdf	PDF	Jan 21, 2020
Q&A_01-16-2020.pdf	PDF	Jan 16, 2020
Amendment A001.pdf	PDF	Jan 13, 2020
Q&A_01-06-2020.pdf	PDF	Jan 10, 2020
Earthwork_wa-ef1712303_FSR4010-050_2.3_MAIN03.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 5140 MP 10.2.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 4010-050 MP 0.78.pdf	PDF	Dec 23, 2019
wa-ef1712303_HYD_5008-100(0.75) AOP Report.pdf	PDF	Dec 23, 2019
Plans_wa-ef1712303_flat.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 4010-050 MP 2.3.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 4150 MP 0.3.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 5008-100 MP 0.75.pdf	PDF	Dec 23, 2019
SWPPP Okanogan-Wenatchee 2017 Repairs WA FS ERFO 2017(1)-23(3).pdf	PDF	Dec 23, 2019
wa-ef1712303_HYD_5140(10.2)_AOP Report.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 3300-100 MP 8.9.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR5008-100_0.75_MAIN09.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR4010-050_0.78_MAIN02.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR4150_0.3_MAIN04.pdf	PDF	Dec 23, 2019
Attention Contractors.docx	DOCX document	Dec 23, 2019
IFB.pdf	PDF	Dec 23, 2019
wa-ef1712303_HYD_4010-050(0.78)_AOP Report.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR3300-100_MAIN01.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR5140 MP 10.2.pdf	PDF	Dec 23, 2019
Earthwork_wa-ef1712303_FSR4150_2.2_MAIN05.pdf	PDF	Dec 23, 2019
Cross Sections_wa-ef1712303_100_XS_FSR 4150 MP 2.2.pdf	PDF	Dec 23, 2019

Show all 25

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:	WA	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	FS ERFO 2017(1)-23(3)
NPS PMIS /

Drawing No:

Designed by:	USFS
Date:	1/1904
Checked by:	USFS
Date:	1/1904
First sheet #:	D.14	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	26	rows w/data	OK - no spaces in data
Max. row/table	40	32	data rows	Warnings: Empty lines found within data set
		40	rows/table
			PROJECT : Okanogan-Wenatchee 217 Repairs Phase 3

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 (2011)

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

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.14

Filename

Sheet name:

Sheet

c:\pw-work\d0396524\[okanogan_wenatchee_controlsheet.xlsx]Sheet

Reference:

Time

11-Jun-2019 10:47 AM

Begin Column:

PROJECT : Okanogan-Wenatchee 217 Repairs Phase 3

PROJECT UNITS : US SURVEY FOOT

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
						RD 3300-100 mp 8.9					0	0	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.
					GPS1	647061.430	2059899.770	4244.830	48°45'38.94617"N	119°05'38.865964"W	4188.1418	0.99980531	Rebar
					GPS2	646887.760	2059882.910	4243.800	48°45'37.236735"N	119°05'39.176094"W	4187.6453	0.99980524	Rebar
					GPS3	646991.610	2059898.250	4239.820	48°45'38.257769"N	119°05'38.91219"W	4185.0885	0.99980541	spike
						RD 4010-050 mp 2.3					0	0	0	2.	No control points for sites FSR 4200-400 MP 0.2, FSR 4415 MP 0.0 to 0.4, FSR 5100-100 MP 2.3, and FSR 5140 MP 8.75.
					CP1	381578.780	1823295.160	2877.790	48°02'37.123747"N	120°05'08.510375"W	2817.5014	0.99980854	Rebar w/cap
					CP2	381693.330	1823139.930	2884.470	48°02'38.269063"N	120°05'10.778444"W	2824.1847	0.99980821	Rebar w/cap
					CP3	381570.640	1823144.950	2865.520	48°02'37.057812"N	120°05'10.722095"W	2805.238	0.99980912	spike
						4010-050 mp 0.78					0	0	0
					GPS1	382229.800	1828832.070	2277.490	48°02'43.009442"N	120°03'46.931109"W	2216.9193	0.99983718	Rebar w/cap
					GPS2	382407.020	1828689.340	2298.840	48°02'44.772430"N	120°03'49.005560"W	2238.2725	0.99983615	Rebarw/cap
					CP3	382240.880	1828712.170	2277.950	48°02'43.130625"N	120°03'48.694030"W	2217.3858	0.99983715	spike
					CP4	382397.250	1828817.400	2257.710	48°02'44.663370"N	120°03'47.122339"W	2197.136	0.99983811	spike
					CP5	382096.900	1828607.180	2286.170	48°02'41.720121"N	120°03'50.260339"W	2225.6124	0.99983677	spike
						RD 4150 mp 0.3					0	0	0
					GPS1	475785.760	1845171.110	2163.540	48°18'04.552164"N	119°59'31.422129"W	2103.9535	0.99984688	Rebar
					GPS2	475834.310	1844759.990	2162.130	48°18'05.075558"N	119°59'37.494797"W	2102.5501	0.99984696	12" spike
					GPS3	475810.880	1844990.140	2152.140	48°18'04.819560"N	119°59'34.094633"W	2092.5568	0.99984743	spike
					CP4	475727.080	1844854.940	2134.330	48°18'04.007197"N	119°59'36.107785"W	2074.7468	0.99984827	H&T
						5008-100 MP 0.75					0	0	0
					CP1	543799.230	1814554.200	2720.860	48°29'18.754478"N	120°06'54.869672"W	2663.1141	0.99983599	Rebar w/ypc
					CP2	543776.700	1814172.850	2706.690	48°29'18.567237"N	120°07'00.533727"W	2648.9276	0.99983666	Rebar w/ypc
					CP3	543779.180	1814340.330	2714.680	48°29'18.576314"N	120°06'58.047234"W	2656.9242	0.99983628	spike
						5140 MP 10.2					0	0	0
					CP1	632683.188	1781710.606	4716.822	48°43'58.543788"N	120°14'52.384973"W	4661.4612	0.99977736	Rebar w/cap
					CP2	632468.602	1781803.771	4721.939	48°43'56.419482"N	120°14'51.019695"W	4666.5684	0.999777	Rebar w/cap
						4150 mp 2.2					0	0	0
					GPS1	470436.846	1852320.500	2650.500	48°17'10.984945"N	119°57'46.577246"W	2590.7427	0.99982284	Rebar w/cap
					GPS2	470693.360	1852043.020	2638.524	48°17'13.547152"N	119°57'50.637152"W	2578.7733	0.99982345	Rebar w/cap
					CP2	470689.823	1852046.846	2625.297	48°17'13.511823"N	119°57'50.581172"W	2565.5463	0.99982408	Rebar w/cap
					CP3	470699.810	1852058.832	2628.630	48°17'13.609037"N	119°57'50.402279"W	2568.8793	0.99982393	Rebar w/cap
					CP4	470566.258	1852173.101	2638.791	48°17'12.278417"N	119°57'48.735023"W	2579.037	0.99982342	spike
					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 : Okanogan-Wenatchee 217 Repairs Phase 3

PROJECT UNITS : US SURVEY FOOT

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

GPS1	647061.430	2059899.770	4244.830	48°45'38.94617"N	119°05'38.865964"W	4188.142	0.99980531	Rebar
GPS2	646887.760	2059882.910	4243.800	48°45'37.236735"N	119°05'39.176094"W	4187.645	0.99980524	Rebar
GPS3	646991.610	2059898.250	4239.820	48°45'38.257769"N	119°05'38.91219"W	4185.089	0.99980541	spike

CP1	381578.780	1823295.160	2877.790	48°02'37.123747"N	120°05'08.510375"W	2817.501	0.99980854	Rebar w/cap
CP2	381693.330	1823139.930	2884.470	48°02'38.269063"N	120°05'10.778444"W	2824.185	0.99980821	Rebar w/cap
CP3	381570.640	1823144.950	2865.520	48°02'37.057812"N	120°05'10.722095"W	2805.238	0.99980912	spike

GPS1	382229.800	1828832.070	2277.490	48°02'43.009442"N	120°03'46.931109"W	2216.919	0.99983718	Rebar w/cap
GPS2	382407.020	1828689.340	2298.840	48°02'44.772430"N	120°03'49.005560"W	2238.273	0.99983615	Rebarw/cap
CP3	382240.880	1828712.170	2277.950	48°02'43.130625"N	120°03'48.694030"W	2217.386	0.99983715	spike
CP4	382397.250	1828817.400	2257.710	48°02'44.663370"N	120°03'47.122339"W	2197.136	0.99983811	spike
CP5	382096.900	1828607.180	2286.170	48°02'41.720121"N	120°03'50.260339"W	2225.612	0.99983677	spike

GPS1	475785.760	1845171.110	2163.540	48°18'04.552164"N	119°59'31.422129"W	2103.954	0.99984688	Rebar
GPS2	475834.310	1844759.990	2162.130	48°18'05.075558"N	119°59'37.494797"W	2102.550	0.99984696	12" spike
GPS3	475810.880	1844990.140	2152.140	48°18'04.819560"N	119°59'34.094633"W	2092.557	0.99984743	spike
CP4	475727.080	1844854.940	2134.330	48°18'04.007197"N	119°59'36.107785"W	2074.747	0.99984827	H&T

CP1	543799.230	1814554.200	2720.860	48°29'18.754478"N	120°06'54.869672"W	2663.114	0.99983599	Rebar w/ypc
CP2	543776.700	1814172.850	2706.690	48°29'18.567237"N	120°07'00.533727"W	2648.928	0.99983666	Rebar w/ypc
CP3	543779.180	1814340.330	2714.680	48°29'18.576314"N	120°06'58.047234"W	2656.924	0.99983628	spike

CP1	632683.188	1781710.606	4716.822	48°43'58.543788"N	120°14'52.384973"W	4661.461	0.99977736	Rebar w/cap
CP2	632468.602	1781803.771	4721.939	48°43'56.419482"N	120°14'51.019695"W	4666.568	0.99977700	Rebar w/cap

GPS1	470436.846	1852320.5	2650.5	48°17'10.984945"N	119°57'46.577246"W	2590.7427	0.99982284	Rebar w/cap
GPS2	470693.36	1852043.02	2638.524	48°17'13.547152"N	119°57'50.637152"W	2578.7733	0.99982345	Rebar w/cap
CP2	470689.823	1852046.846	2625.297	48°17'13.511823"N	119°57'50.581172"W	2565.5463	0.99982408	Rebar w/cap
CP3	470699.81	1852058.832	2628.63	48°17'13.609037"N	119°57'50.402279"W	2568.8793	0.99982393	Rebar w/cap
CP4	470566.258	1852173.101	2638.791	48°17'12.278417"N	119°57'48.735023"W	2579.037	0.99982342	spike

File details come from the government source that posted it. Updated Dec 23, 2019.