Ghiglione_ControlSheet.xlsx
XLSX spreadsheet 39 KB Posted
- Attached to
- AK PRA DENA 10(36) Replace Ghiglione Bridge Federal contract opportunity
- Solicitation number
- 69056721B000019
About this file
This Excel file contains survey control point data and sheet templates for the replacement of the Ghiglione Bridge project in Alaska. The file provides state plane and geo coordinates, elevations, descriptions and other data for survey control points to be used on project plan sheets. It includes templates for up to 20 sheets with insert fields for common project information and instructions for populating sheet data from the point list.
The related federal contract opportunity is a full and open solicitation for the AK PRA DENA 10(36) project to replace the Ghiglione Bridge. The solicitation is being conducted by the Department of Transportation Federal Highway Administration and includes replacing the existing bridge.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Tabulation of Bids ghiglione.pdf | ||
| BidSum.pdf | ||
| QA_08-04-2021.pdf | ||
| QA_08-02-2021.pdf | ||
| Amendment A003.pdf | ||
| QA_07-28-2021.pdf | ||
| QA_07-27-2021.pdf | ||
| Amendment A002.pdf | ||
| QA_07-26-2021.pdf | ||
| QA_07-23-2021.pdf | ||
| Amendment A001.pdf | ||
| QA_07-22-2021.pdf | ||
| QA_07-19-2021.pdf | ||
| QA_06-30-2021.pdf | ||
| DENA01036_XS.pdf | ||
| DENA01036_VA.pdf | ||
| DENA01036_HA.pdf | ||
| DENA01036_EW.pdf | ||
| DENA01036_plans.pdf | ||
| 9830-011P - Ghiglione Bridge As-Built Plans.pdf | ||
| Ghiglione IFB.pdf | ||
| Toklat Pit_Scrape Material Photos.pdf | ||
| Geotech Report No 11-19 Ghiglione Final Foundation Report.pdf | ||
| DENA01036_SUP.pdf | ||
| DENA01036 xml files.zip | ZIP file | |
| CompiledSWPPP_AK for physical data.pdf | ||
| 9830-011P - Ghiglione Bridge Inspection 2019.pdf |
Show all 27
On GovTribe
Work with this file on GovTribe
- 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: | AK | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | PRA DENA 10(36) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD_Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.4 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 3 | 3.0 | ||
| Base sheet name: | Sheet | 3 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 3 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Ghiglione Bridge Replacement |
DATE OF FIELD WORK : June 2009 DATE OF FINAL ADJUSTMENT : June 2009
PROJECT UNITS : US Survey Foot COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (CORS96)
EPOCH DATE : 2008.000
VERTICAL DATUM : Orthometric Elevations based on the NAVD88 GEOID06a
| 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.4 | 3 | 4 | OK | |
| Sheet (2) | Undefined | FALSE | 4 | ||
| Sheet (3) | Undefined | FALSE | 4 | ||
| Sheet (4) | Undefined | FALSE | 4 | ||
| Sheet (5) | Undefined | FALSE | 4 | ||
| Sheet (6) | Undefined | FALSE | 4 | ||
| Sheet (7) | Undefined | FALSE | 4 | ||
| Sheet (8) | Undefined | FALSE | 4 | ||
| Sheet (9) | Undefined | FALSE | 4 | ||
| Sheet (10) | Undefined | FALSE | 4 | ||
| Sheet (11) | Undefined | FALSE | 4 | ||
| Sheet (12) | Undefined | FALSE | 4 | ||
| Sheet (13) | Undefined | FALSE | 4 | ||
| Sheet (14) | Undefined | FALSE | 4 | ||
| Sheet (15) | Undefined | FALSE | 4 | ||
| Sheet (16) | Undefined | FALSE | 4 | ||
| Sheet (17) | Undefined | FALSE | 4 | ||
| Sheet (18) | Undefined | FALSE | 4 | ||
| Sheet (19) | Undefined | FALSE | 4 | ||
| Sheet (20) | Undefined | FALSE | 4 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.4 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects\Alaska\Denali\control\[Ghiglione_ControlSheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 30-Apr-2019 2:07 PM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Ghiglione Bridge Replacement DATE OF FIELD WORK : June 2009 DATE OF FINAL ADJUSTMENT : June 2009 PROJECT UNITS : US Survey Foot COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (CORS96)
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 2997 | 3492192.043 | 1680732.928 | 3435.333 | 63°33'23.579940"N | 149°45'09.904860"W | 3482.2516 | 0.99973585 | 5/8" IR w/RPC | 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. | |||||
| 2998 | 3492323.784 | 1680225.731 | 3421.876 | 63°33'24.896049"N | 149°45'21.091444"W | 3468.7874 | 0.99973644 | 5/8" IR w/RPC | |||||||
| GHIG1 | 3492065.010 | 1680271.658 | 3373.364 | 63°33'22.346796"N | 149°45'20.099296"W | 3420.2823 | 0.99973876 | 5/8" IR w/FHWA Alum Cap | |||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 :Ghiglione Bridge Replacement DATE OF FIELD WORK : June 2009 DATE OF FINAL ADJUSTMENT : June 2009
PROJECT UNITS : US Survey Foot COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (CORS96)
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 2997 | 3492192.043 | 1680732.928 | 3435.333 | 63°33'23.579940"N | 149°45'09.904860"W | 3482.252 | 0.99973585 | 5/8" IR w/RPC | |
| 2998 | 3492323.784 | 1680225.731 | 3421.876 | 63°33'24.896049"N | 149°45'21.091444"W | 3468.787 | 0.99973644 | 5/8" IR w/RPC | |
| GHIG1 | 3492065.010 | 1680271.658 | 3373.364 | 63°33'22.346796"N | 149°45'20.099296"W | 3420.282 | 0.99973876 | 5/8" IR w/FHWA Alum Cap |
File details come from the government source that posted it. Updated .