waa-jeffer134309-2_ControlPoints.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- 69056725B000014
About this file
This file is a Survey Control Point spreadsheet for the Two Trout Creek Culvert Replacement project (WA FLAP JEFFER 134309(2)). The document serves as a control sheet template for managing survey data in Excel format, with instructions for organizing and displaying survey control points across multiple worksheets.
The survey data includes eleven control points (numbered 22001 through 22009, plus TROUT1 and TROUT2) located in Washington State using the Washington North State Plane Coordinate System (NAD83 2011) with orthometric elevations based on NAVD88 GEOID18. Each point is marked with a 5/8-inch iron with FHWA aluminum cap and includes state plane coordinates (North and East), orthometric elevation, geographic coordinates (latitude and longitude), ellipsoid height, combined factors for distance calculations, and descriptive notes. The project uses US Survey Feet as the unit of measurement, with an epoch date of 2010.000 and a CADD system coordinate designation of WA83/2011-NF NSRS11. Field work dates were recorded as multiple entries, and the file was last revised on 12 August 2024 with a reference timestamp of 27 October 2025. This spreadsheet provides the foundational survey control data necessary for the culvert replacement project design and construction activities.
View the file
Other files
Show all 15
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
| 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 FLAP JEFFER 134309(2) | 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 | 11 | rows w/data | OK - no spaces in data |
| Max. row/table | 35 | 11 | data rows | Warnings: |
| 35 | rows/table | |||
| PROJECT : Two Trout Creek Culvert Replacement |
DATE OF FIELD WORK :Multiple entries
COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot
PROJECT UNITS : US SURVEY 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: 12 August 2024
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.1 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\Users\adam.davies\Documents\Projects_2025\Washington\Two Trout\PW\[Two_Trout_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 27-Oct-2025 9:43 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
| C:\Users\adam.davies\Documents\Projects_2025\Washington\Two Trout\PW\[Two_Trout_controlsheet.xlsx]Sheet | |
| PROJECT : Two Trout Creek Culvert Replacement |
DATE OF FIELD WORK :Multiple entries
PROJECT UNITS : US SURVEY FOOT
COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ORTHOMETRIC ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 22001 | 314094.451 | 799223.194 | 410.966 | 47°48'35.136121"N | 124°15'28.170982"W | 336.2974 | 0.9999405787 | 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. | |||||
| 22002 | 313989.097 | 799185.720 | 415.224 | 47°48'34.080932"N | 124°15'28.650795"W | 340.5502 | 0.9999404029 | 5/8"ir w/fhwa alum cap | |||||||
| 22003 | 313787.395 | 799217.165 | 411.047 | 47°48'32.106058"N | 124°15'28.059109"W | 336.3679 | 0.999940654 | 5/8"ir w/fhwa alum cap | |||||||
| 22004 | 313607.156 | 799085.807 | 390.577 | 47°48'30.271320"N | 124°15'29.864182"W | 315.8861 | 0.9999416801 | 5/8"ir w/fhwa alum cap | |||||||
| 22005 | 313376.192 | 798773.344 | 370.444 | 47°48'27.856911"N | 124°15'34.286743"W | 295.7317 | 0.9999427058 | 5/8"ir w/fhwa alum cap | |||||||
| 22006 | 312798.471 | 798559.608 | 330.867 | 47°48'22.066988"N | 124°15'37.038134"W | 256.1259 | 0.9999447491 | 5/8"ir w/fhwa alum cap | |||||||
| 22007 | 312621.378 | 798196.908 | 307.795 | 47°48'20.161561"N | 124°15'42.230772"W | 233.0287 | 0.9999459025 | 5/8"ir w/fhwa alum cap | |||||||
| 22008 | 312118.404 | 798126.957 | 279.483 | 47°48'15.171756"N | 124°15'42.926338"W | 204.6966 | 0.9999473873 | 5/8"ir w/fhwa alum cap | |||||||
| 22009 | 311925.833 | 797996.827 | 262.663 | 47°48'13.215905"N | 124°15'44.705084"W | 187.8643 | 0.999948243 | 5/8"ir w/fhwa alum cap | |||||||
| TROUT1 | 310831.051 | 797471.351 | 225.960 | 47°48'02.190867"N | 124°15'51.680365"W | 151.1013 | 0.9999502919 | 5/8"ir w/fhwa alum cap | |||||||
| TROUT2 | 310431.612 | 797200.474 | 224.331 | 47°47'58.133448"N | 124°15'55.383413"W | 149.4469 | 0.9999504794 | 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 | |||||||
| 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 |
27-Oct-2025 9:43 AM
PROJECT : Two Trout Creek Culvert Replacement DATE OF FIELD WORK :Multiple entries
COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot
PROJECT UNITS : US SURVEY FOOT
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 22001 | 314094.451 | 799223.194 | 410.966 | 47°48'35.136121"N | 124°15'28.170982"W | 336.297 | 0.99994058 | 5/8"ir w/fhwa alum cap | |
| 22002 | 313989.097 | 799185.720 | 415.224 | 47°48'34.080932"N | 124°15'28.650795"W | 340.550 | 0.99994040 | 5/8"ir w/fhwa alum cap | |
| 22003 | 313787.395 | 799217.165 | 411.047 | 47°48'32.106058"N | 124°15'28.059109"W | 336.368 | 0.99994065 | 5/8"ir w/fhwa alum cap | |
| 22004 | 313607.156 | 799085.807 | 390.577 | 47°48'30.271320"N | 124°15'29.864182"W | 315.886 | 0.99994168 | 5/8"ir w/fhwa alum cap | |
| 22005 | 313376.192 | 798773.344 | 370.444 | 47°48'27.856911"N | 124°15'34.286743"W | 295.732 | 0.99994271 | 5/8"ir w/fhwa alum cap | |
| 22006 | 312798.471 | 798559.608 | 330.867 | 47°48'22.066988"N | 124°15'37.038134"W | 256.126 | 0.99994475 | 5/8"ir w/fhwa alum cap | |
| 22007 | 312621.378 | 798196.908 | 307.795 | 47°48'20.161561"N | 124°15'42.230772"W | 233.029 | 0.99994590 | 5/8"ir w/fhwa alum cap | |
| 22008 | 312118.404 | 798126.957 | 279.483 | 47°48'15.171756"N | 124°15'42.926338"W | 204.697 | 0.9999473873 | 5/8"ir w/fhwa alum cap | |
| 22009 | 311925.833 | 797996.827 | 262.663 | 47°48'13.215905"N | 124°15'44.705084"W | 187.864 | 0.999948243 | 5/8"ir w/fhwa alum cap | |
| TROUT1 | 310831.051 | 797471.351 | 225.960 | 47°48'02.190867"N | 124°15'51.680365"W | 151.101 | 0.9999502919 | 5/8"ir w/fhwa alum cap | |
| TROUT2 | 310431.612 | 797200.474 | 224.331 | 47°47'58.133448"N | 124°15'55.383413"W | 149.447 | 0.9999504794 | 5/8"ir w/fhwa alum cap |
File details come from the government source that posted it. Updated .