WA_FS_OKW_76(1)_Icicle_creek_Controlsheet.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
WA USFS OkWen617 76(1), Icicle Creek Road Rock Fall Mitigation
Solicitation number
69056723B000009
Issued by

About this file

The provided document appears to be a Survey Control Point List in Excel format for a federal contract opportunity related to the WA USFS OkWen617 76(1) Icicle Creek Road Rockfall Mitigation project.

The key details of the federal contract opportunity are:

  • Solicitation Number: 69056723B000009
  • Name: WA USFS OkWen617 76(1), Icicle Creek Road Rock Fall Mitigation
  • Opportunity Type: Invitation for Bids (IFB) for a construction project
  • Issuing Agency: Department of Transportation Federal Highway Administration
  • Project Details: The project involves rockfall mitigation work on the Icicle Creek Road in Washington. The Survey Control Point List provides the coordinate data for survey points in the project area.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

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

Drawing No:

Designed by:WFLHD Survey
Date:1/1904
Checked by:WFLHD Survey
Date:1/1904
First sheet #:D.101.0
Title block text:SURVEY CONTROL
Show Totals?TRUE
Data location:Page 1Worksheet found
Data begins in col:A
Min. rows/table53.0
Base sheet name:Sheet8rows w/dataOK - no spaces in data
Max. row/table408data rowsWarnings:
40rows/table
PROJECT : Icicle creek road

DATE OF FIELD WORK : November 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 2011

EPOCH DATE : 2010.000

VERTICAL DATUM :Orthometric elevations based on the NAVD88 GEOID18

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
Worksheet NameSheetHeader rowSheet NumberNotes
SheetD.10310OK
Sheet (2)UndefinedFALSE10
Sheet (3)UndefinedFALSE10
Sheet (4)UndefinedFALSE10
Sheet (5)UndefinedFALSE10
Sheet (6)UndefinedFALSE10
Sheet (7)UndefinedFALSE10
Sheet (8)UndefinedFALSE10
Sheet (9)UndefinedFALSE10
Sheet (10)UndefinedFALSE10
Sheet (11)UndefinedFALSE10
Sheet (12)UndefinedFALSE10
Sheet (13)UndefinedFALSE10
Sheet (14)UndefinedFALSE10
Sheet (15)UndefinedFALSE10
Sheet (16)UndefinedFALSE10
Sheet (17)UndefinedFALSE10
Sheet (18)UndefinedFALSE10
Sheet (19)UndefinedFALSE10
Sheet (20)UndefinedFALSE10
Total Sheets:10sheets missing

Revised: 15 June 2015

Sheet

Sheet Information
Sheet num:D.10Filename0
Sheet name:SheetC:\MyFiles\Projects_2020\Washington\Icicle_Creek\gps\[WA_FS_OKW_76(1)_Icicle_creek_Controlsheet.xlsx]Sheet
Reference:Time
2-Apr-2021 2:38 PM
Begin Column:ABCDEFGHI

PROJECT : Icicle creek road DATE OF FIELD WORK : November 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 2011

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
20101198629.1421671064.4131382.26747°32'40.072835"N120°42'33.273898"W1321.72850.9999288625/8" IR W/FHWA ALUM CAP1.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.
20102198624.3181670803.3921382.25647°32'40.029361"N120°42'37.078685"W1321.73560.99992886375/8" IR W/FHWA ALUM CAP
20103198610.3501670170.6641407.98447°32'39.901386"N120°42'46.301724"W1347.51150.99992763865/8" IR W/FHWA ALUM CAP
20104198608.6461669939.4471421.43247°32'39.888127"N120°42'49.672007"W1360.97510.9999269961MAG NAIL & WASHER
20105198454.0311669745.7651430.25947°32'38.365135"N120°42'52.498615"W1369.81550.99992664715/8" IR W/FHWA ALUM CAP
20106198370.5041669357.4881434.62947°32'37.546651"N120°42'58.159991"W1374.21130.9999264766H&T
20107197602.1831668753.3751459.67847°32'29.972799"N120°43'06.982195"W1399.30360.99992564345/8" IR W/FHWA ALUM CAP
20108197543.7771668430.5591468.08747°32'29.401091"N120°43'11.688604"W1407.73320.99992526845/8" IR W/FHWA ALUM CAP
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000

PROJECT : Icicle creek road DATE OF FIELD WORK : November 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 2011

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
20101198629.1421671064.4131382.26747°32'40.072835"N120°42'33.273898"W1321.7290.999928865/8" IR W/FHWA ALUM CAP
20102198624.3181670803.3921382.25647°32'40.029361"N120°42'37.078685"W1321.7360.999928865/8" IR W/FHWA ALUM CAP
20103198610.3501670170.6641407.98447°32'39.901386"N120°42'46.301724"W1347.5120.999927645/8" IR W/FHWA ALUM CAP
20104198608.6461669939.4471421.43247°32'39.888127"N120°42'49.672007"W1360.9750.99992700MAG NAIL & WASHER
20105198454.0311669745.7651430.25947°32'38.365135"N120°42'52.498615"W1369.8160.999926655/8" IR W/FHWA ALUM CAP
20106198370.5041669357.4881434.62947°32'37.546651"N120°42'58.159991"W1374.2110.99992648H&T
20107197602.1831668753.3751459.67847°32'29.972799"N120°43'06.982195"W1399.3040.999925645/8" IR W/FHWA ALUM CAP
20108197543.7771668430.5591468.08747°32'29.401091"N120°43'11.688604"W1407.7330.999925275/8" IR W/FHWA ALUM CAP

File details come from the government source that posted it. Updated .