OR ERFO FS UMPQU615-2022-2(1)_controlsheet.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- 69056724B000023
About this file
I apologize, but the provided file appears to be an Excel control sheet (OR ERFO FS UMPQU615-2022-2(1)_controlsheet.xlsx), and without being able to view its contents, I cannot provide a detailed summary. The related federal contract opportunity information indicates this is an Invitation for Bids (IFB) for a construction project by the Department of Transportation Federal Highway Administration, specifically for Umpqua ERFO Repairs in 2022 (Solicitation Number: 69056724B000023). However, without access to the actual spreadsheet contents, I cannot confidently elaborate on the specific details of the project or contract requirements.
View the file
Other files
Show all 18
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: | OR ERFO FS UMPQU615-2022-2(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 | 9 | rows w/data | OK - no spaces in data |
| Max. row/table | 35 | 12 | data rows | Warnings: Empty lines found within data set |
| 35 | rows/table | |||
| PROJECT : Umpqua ERFO repairs 2022 |
DATE OF FIELD WORK :September, 2023 DATE OF FINAL ADJUSTMENT : November, 2023
COORDINATE SYSTEM : Oregon South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : OR83/2011-SIF NSRS11(NAD83/2011) Oregon, Southern Zone, Intn'l 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 | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\ThatcherSmith\Survey\Projects\OR\Umpqua\2023\[OR ERFO FS UMPQU615-2022-2(1)_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 27-Mar-2024 9:08 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
| C:\MyFiles\ThatcherSmith\Survey\Projects\OR\Umpqua\2023\[OR ERFO FS UMPQU615-2022-2(1)_controlsheet.xlsx]Sheet | |
| PROJECT : Umpqua ERFO repairs 2022 |
DATE OF FIELD WORK :September, 2023 DATE OF FINAL ADJUSTMENT : November, 2023
PROJECT UNITS : International Foot COORDINATE SYSTEM : Oregon South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : OR83/2011-SIF NSRS11(NAD83/2011) Oregon, Southern Zone, Intn'l Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ORTHOMETRIC ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 0 | Green Butte | 0.000 | 0.000 | 0 | 0 | 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. | |||||
| 23101 | 436990.814 | 4238338.578 | 2392.139 | 42°50'14.048514"N | 123°02'48.000960"W | 2315.2196 | 0.9998005917 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 23102 | 437228.307 | 4238450.302 | 2400.574 | 42°50'16.427015"N | 123°02'46.598930"W | 2323.6545 | 0.9998001225 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 0 | Fairview | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 23111 | 610411.456 | 4298637.117 | 1429.007 | 43°19'03.748214"N | 122°50'23.983583"W | 1352.5448 | 0.9998333467 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 23112 | 610573.694 | 4298613.852 | 1422.343 | 43°19'05.343692"N | 122°50'24.359515"W | 1345.8821 | 0.9998336852 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 23113 | 610796.161 | 4298623.052 | 1414.193 | 43°19'07.542815"N | 122°50'24.319190"W | 1337.7358 | 0.9998341023 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 23114 | 610945.476 | 4298587.718 | 1409.413 | 43°19'09.007362"N | 122°50'24.853450"W | 1332.958 | 0.9998343492 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 0 | Wight Creek | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | |||||||
| 23121 | 607361.755 | 4307131.640 | 1557.752 | 43°18'35.963992"N | 122°48'27.975918"W | 1481.4446 | 0.9998268463 | 5/8" IR W/ FHWA ALUM CAP | |||||||
| 23122 | 607056.717 | 4307192.778 | 1592.366 | 43°18'32.968723"N | 122°48'27.035593"W | 1516.0641 | 0.9998251563 | 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-Mar-2024 9:08 AM
PROJECT : Umpqua ERFO repairs 2022 DATE OF FIELD WORK :September, 2023 DATE OF FINAL ADJUSTMENT : November, 2023
COORDINATE SYSTEM : Oregon South SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM : OR83/2011-SIF NSRS11(NAD83/2011) Oregon, Southern Zone, Intn'l Foot
PROJECT UNITS : International Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| Green Butte | |||||||||
| 23101 | 436990.814 | 4238338.578 | 2392.139 | 42°50'14.048514"N | 123°02'48.000960"W | 2315.220 | 0.99980059 | 5/8" IR W/ FHWA ALUM CAP | |
| 23102 | 437228.307 | 4238450.302 | 2400.574 | 42°50'16.427015"N | 123°02'46.598930"W | 2323.655 | 0.99980012 | 5/8" IR W/ FHWA ALUM CAP | |
| Fairview | |||||||||
| 23111 | 610411.456 | 4298637.117 | 1429.007 | 43°19'03.748214"N | 122°50'23.983583"W | 1352.545 | 0.99983335 | 5/8" IR W/ FHWA ALUM CAP | |
| 23112 | 610573.694 | 4298613.852 | 1422.343 | 43°19'05.343692"N | 122°50'24.359515"W | 1345.882 | 0.99983369 | 5/8" IR W/ FHWA ALUM CAP | |
| 23113 | 610796.161 | 4298623.052 | 1414.193 | 43°19'07.542815"N | 122°50'24.319190"W | 1337.736 | 0.99983410 | 5/8" IR W/ FHWA ALUM CAP | |
| 23114 | 610945.4761 | 4298587.7176 | 1409.4126 | 43°19'09.007362"N | 122°50'24.853450"W | 1332.958 | 0.9998343492 | 5/8" IR W/ FHWA ALUM CAP | |
| Wight Creek | |||||||||
| 23121 | 607361.755 | 4307131.640 | 1557.752 | 43°18'35.963992"N | 122°48'27.975918"W | 1481.445 | 0.99982685 | 5/8" IR W/ FHWA ALUM CAP | |
| 23122 | 607056.717 | 4307192.778 | 1592.366 | 43°18'32.968723"N | 122°48'27.035593"W | 1516.064 | 0.99982516 | 5/8" IR W/ FHWA ALUM CAP |
File details come from the government source that posted it. Updated .