foundation location - rs1 cu d04 - trial hole afc isssue

134307-APB-REP-DEL-XXXXXX document.xls Version Control

1 of 16 04/21/2023

Version Date Comment

1 19-Sep-14 Trial Hole data inputted for D04

2 26-Sep-14 Trial Hole Status updated by Amelia3 10-Oct-14 Trial Hole Status (contractor) updated by Amelia


2 of 16 04/21/2023

NOTE:


3 of 16 04/21/2023

Colour KeyDates lie within THIS week; ending Friday

Deadline lie within NEXT week; ending Friday

CU % Complete

27 40 0.00% 0 0 0FALSE

28 28 0.00% 0 0 0FALSE

29 34 0.00% 0 0 0FALSE

30 0.00%31 0.00%32 0.00%33 0.00%34 0.00%35 0.00%36 0.00%37 0.00%38 0.00%39 0.00%40 0.00%41 0.00%42 0.00%43 0.00%44 0.00%45 0.00%46 0.00%47 0.00%48 0.00%49 0.00%50 0.00%51 0.00%52 0.00%53 0.00%54 0.00%

Total Number of Foundations within CU

Locations Complete As Per GRIP 4

GRIP 5 Trial Holes Required

GRIP 5 Locations Complete

Associated Structure Number Trial Hole ID

Q RS CU Location

Kilo

me

ter

Me

ter

Tra

ck

Str

uct

ure

Kilometerage Track ID GRIP Stage

. 1 D04 43869UR 43 869 UR Anchor Portal 43.869 Up Relief 43869UR 5

. 1 D04 43869DM 43 869 DM Anchor Portal 43.869 Down Main 43869DM 5

. 1 D04 43874UR 43 874 UR Compression Strut 43.874 Up Relief 43874UR 5

. 1 D04 43874DM 43 874 DM Compression Strut 43.874 Down Main 43874DM 5



. 1 D04 43924UR 43 924 UR Anchor Portal 43.924 Up Relief 43924UR 5

. 1 D04 43924DM 43 924 DM Anchor Portal 43.924 Down Main 43924DM 5

. 1 D04 43976UR 43 976 UR TTC-B 43.976 Up Relief 43976UR 5

. 1 D04 43976DM 43 976 DM TTC-B 43.976 Down Main 43976DM 5



























. 1 D04 44600UR 44 600 UR MPA 44.600 Up Relief 44600UR 5

. 1 D04 44600DM 44 600 DM MPA 44.600 Down Main 44600DM 5


























. 1 D04 45100DM 45 100 DM Compression Strut 45.100 Down Main 45100DM 51 D04 45105UR 45 105 UR TTC-B 45.105 Up Relief 45105UR 51 D04 45105DM 45 105 DM TTC-B 45.105 Down Main 45105DM 5

1 D04 45166UR 45 166 UR TTC-B 45.166 Up Relief 45166UR 51 D04 45166DM 45 166 DM TTC-B 45.166 Down Main 45166DM 51 D04 45171UR 45 171 UR Compression Strut 45.171 Up Relief 45171UR 51 D04 45171DM 45 171 DM Compression Strut 45.171 Down Main 45171DM 51 D04 45225UR 45 225 UR TTC-B 45.225 Up Relief 45225UR 51 D04 45225DM 45 225 DM TTC-B 45.225 Down Main 45225DM 5

Design Co-Ordinates Design State As Built Co-Ordinates

Easting Northing Elevation Walkout

484378.493 178648.057 N/A 3 484378.247 178648.125 38.244 3.4 0.246 -0.068 0.177484387.201 178631.876 N/A 3 484387.204 178631.88 37.911 2.97 -0.003 -0.004 -0.007484374.087 178645.692 N/A 3 484373.998 178646.089 38.317 3.4 0.089 -0.397 -0.308484382.798 178629.507 N/A 3 484382.796 178629.505 38.011 3.02m 0.002 0.002 0.004484334.418 178624.373 N/A 3 484334.467 178624.672 38.118 3.4 -0.049 -0.299 -0.348484343.119 178608.183 N/A 3 484343.11 178608.179 37.915 3.05m 0.009 0.004 0.013484330.015 178622.004 N/A 3 484330.079 178622.458 38.129 3.4 -0.064 -0.454 -0.518484338.714 178605.818 N/A 3 484338.716 178605.82 37.911 3.05m -0.002 -0.002 -0.004484284.263 178597.416 N/A 3 484284.080 178597.867 38.547 3.4 0.183 -0.451 -0.268484292.962 178581.231 N/A 3 484292.964 178581.233 37.970 3.1m -0.002 -0.002 -0.004484238.432 178572.785 N/A 3 484238.302 178573.427 38.156 3.5 0.129 -0.642 -0.512484247.131 178556.599 N/A 3 484247.133 178556.602 37.970 3.0m -0.002 -0.003 -0.006484182.928 178542.957 N/A 3 484182.928 178542.957 37.470 2.800 0.000 0.000 0.000484191.627 178526.771 N/A 3 484191.626 178526.77 38.100 3.3m 0.001 0.001 0.002484127.429 178513.130 N/A 3 484126.972 178512.918 38.236 3 0.457 0.212 0.669484136.128 178496.944 N/A 3 484136.129 178496.945 38.1 3m -0.001 -0.001 -0.002484071.990 178483.337 N/A 3 484071.990 178483.337 38.246 3.2 0.000 0.000 0.001484080.689 178467.151 N/A 3 484080.687 178467.149 38.033 3.1m 0.002 0.002 0.004484016.484 178453.506 N/A 3 484015.548 178456.267 36.384 3 0.936 -2.761 -1.825

484025.1827 178437.3198 N/A 3 484025.183 178437.32 37.97 3.05 0.000 0.000 -0.001483965.411 178426.061 N/A 3 483965.114 178426.776 39.235 3.750 0.297 -0.715 -0.418483974.112 178409.871 N/A 3 483974.041 178409.813 38.251 3.000 0.071 0.058 0.129

483961.0076 178423.6924 N/A 3 483960.644 178424.212 39.203 3.5 0.364 -0.520 -0.156483969.7068 178407.5055 N/A 3 TQ TQ TQ #VALUE! #VALUE! #VALUE!483927.5122 178405.6913 N/A 3 483927.682 178406.228 38.976 3.3 -0.170 -0.537 -0.706483936.2109 178389.5052 N/A 3 483936.2109 178389.5052 0.000 0.000 0.000483923.107 178403.326 N/A 3 483923.056 178405.82 38.858 3.4 0.051 -2.494 -2.443483931.808 178387.136 N/A 3 483932.876 178388.08 35.564 3.0m -1.068 -0.944 -2.012

483879.0454 178379.6444 N/A 3 483879.333 178379.527 38.344 3.4 -0.288 0.117 -0.170483887.7443 178363.458 N/A 3 483888.813 178364.515 35.139 3.0m -1.069 -1.057 -2.126483830.6283 178353.624 N/A 3 483830.501 178353.499 38.453 3 0.127 0.125 0.252483839.3277 178337.4368 N/A 3 483840.2 178338.022 35.735 3.1m -0.872 -0.585 -1.457483782.193 178327.5938 N/A 3 483782.193 178327.594 40.5 3 0.000 0.000 0.000

483790.8919 178311.4074 N/A 3 483790.8919 178311.4074 0.000 0.000 0.000483739.034 178304.402 N/A 3 483739.034 178304.402 38.602 3.000 0.000 0.000 0.000483747.695 178288.189 N/A 3 483748.158 178288.506 34.484 2.97m -0.463 -0.317 -0.780

483734.6304 178302.0328 N/A 3 483734.630 178302.033 36.466 3.000 0.000 0.000 0.000483743.2897 178285.8247 N/A 3 483743.8 178285.929 33.905 3.0m -0.510 -0.104 -0.615483708.199 178287.828 N/A 3 483708.199 178287.828 38.795 2.900 0.000 0.000 0.000483716.898 178271.641 N/A 3 483716.997 178272.059 35.729 3.05m -0.099 -0.418 -0.517483681.772 178273.629 N/A 3 483681.813 178274.062 38.991 3.100 -0.041 -0.433 -0.474

483690.474 178257.437 N/A 3 483691.396 178259.224 35.335 3.15m -0.922 -1.787 -2.709483677.369 178271.259 N/A 3 483677.369 178271.259 38.67 3 0.000 0.000 0.000483686.068 178255.073 N/A 3 TQ TQ TQ TQ #VALUE! #VALUE! #VALUE!483643.895 178253.270 N/A 3 483643.895 178253.270 38.65 3 0.000 0.000 0.000

483652.594 178237.083 N/A 3 483652.617 178237.181 38.437 3.0m -0.023 -0.098 -0.121483596.300 178227.692 N/A 3 483596.300 178227.692 38.825 3.05 0.000 0.000 0.000

483605.000 178211.504 N/A 3 483605.578 178211.905 38.451 3.0m -0.578 -0.401 -0.979483591.895 178225.327 N/A 3 483591.895 178225.327 38.78 3 0.000 0.000 0.000

483600.597 178209.136 N/A 3 483600.426 178209.53 38.669 3.1m 0.171 -0.394 -0.223483548.713 178202.118 N/A 3 483548.713 178202.118 38.81 3.05 0.000 0.000 0.000

483557.412 178185.931 N/A 3 483557.158 178186.775 39.812 3.0m 0.254 -0.844 -0.590483501.169 178176.566 N/A 3 483501.169 178176.566 38.683 3m 0.000 0.000 0.001

483509.869 178160.379 N/A 3 483509.570 178162.026 40.471 3.0m 0.299 -1.647 -1.349483453.589 178150.996 N/A 3 483453.589 178150.996 39.003 3.1m 0.000 0.000 0.000

483462.289 178134.809 N/A 3 483462.222 178135.756 37.475 2.9 0.067 -0.947 -0.881

483406.005 178125.423 N/A 3 TQ TQ TQ TQ #VALUE! #VALUE! #VALUE!

483414.713 178109.240 N/A 3 483414.708 178109.367 38.735 3.0m 0.005 -0.127 -0.122483367.295 178104.620 N/A 3 483367.295 178104.620 39.08 3.1 0.000 0.000 0.000

483375.994 178088.433 N/A 3 483376.105 178088.426 38.572 3.25m -0.111 0.007 -0.103483328.507 178083.775 N/A 3 483328.295 178083.725 39.19 3.07 0.212 0.050 0.262

483337.207 178067.586 N/A 3 483337.423 178068.01 38.864 3.0m -0.216 -0.424 -0.640483294.199 178065.340 N/A 3 483294.199 178065.340 39.091 3.2 0.000 0.000 0.000483302.901 178049.148 N/A 3 483302.901 178049.148 38.321 3.05m 0.000 0.000 0.000483289.796 178062.970 N/A 3 483289.795 178062.969 39.035 3.100 0.001 0.001 0.002483298.496 178046.782 N/A 3 483298.496 178046.782 38.929 3.05m 0.000 0.000 0.000

483236.029 178034.075 N/A 3 483235.596 178034.886 39.784 4.050 0.433 -0.811 -0.378483244.729 178017.887 N/A 3 483244.729 178017.887 45.166 3.1m 0.000 0.000 0.000483231.623 178031.710 N/A 3 483231.541 178031.748 39.33 4.05m 0.082 -0.038 0.044483240.325 178015.518 N/A 3 483240.325 178015.518 39.265 3.1m 0.000 0.000 0.000483184.064 178006.148 N/A 3 483184.064 178006.148 39.06 3.2 0.000 0.000 0.000483192.763 177989.960 N/A 3 483192.763 177989.960 39.310 3.1m 0.000 0.000 0.000

X- Easting OSGB36 Grid (to centre of foundation)

Y- Northing OSGB36 Grid (to centre of foundation)

Design Subject To

Change

Foundation Schedule Revision

Tolerance Easting

Tolerance Northing

Trial Hole Status (Design) As-Built TQ

9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Planned 2 Action Req9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Planned 2 Action Req9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 None9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 4 None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Planned 2 Action Req9/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR None

9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Planned 2 Action Req9/5/2014 Complete - GRIP 4 Issued to NR None

9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None





9/5/2014 Complete - GRIP 4 Issued to NR None

9/5/2014 Planned 2 Action Req



9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None

9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR9/5/2014 Complete - GRIP 49/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None9/5/2014 Complete - GRIP 4 Issued to NR None

Date of Last Trial Hole Status

Update

Trial Hole Status (Contractor)

Wk Required

Wk Planned

No Plan None NonePlanned 1 In Production Action ReqPlanned 2 Issued to NR ClosedPlanned 3

VegScrap

AccessComplete - GRIP 4Complete - GRIP 5

Uploaded On to Model ProjectWise Link to GRIP 5 Trial Pit

YesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesNoYesNoYesYesYesYesYesYesYesNoYesYesYesYesYesYesYes

YesYesNoYes

YesYes

YesYes

YesYes

YesYes

YesYes

Yes

No

YesYes

YesYes

YesYesYesYesYes

YesYesYesYesYesYes

Cleared by Engineering

D04 43.869 UR COMBINED.pdfD04 43.869 DM COMBINED.pdfD04 43.874 UR COMBINED.pdfD04 43.874 DM COMBINED.pdfD04 43.919 UR COMBINED.pdfD04 43.919 DM COMBINED.pdfD04 43.924 UR COMBINED.pdfD04 43.924 DM COMBINED.pdfD04 43.976 UR COMBINED.pdfD04 43.976 DM COMBINED.pdfD04 44.028 UR COMBINED.pdfD04 44.028 DM COMBINED.pdf

D04 44.091 DM COMBINED.pdfD04 44.154 UR COMBINED.pdfD04 44.154 DM COMBINED.pdfD04 44.217 UR COMBINED.pdfD04 44.217 DM COMBINED.pdfD04 44.280 UR COMBINED.pdfD04 44.280 DM COMBINED.pdfD04 44.338 UR COMBINED.pdfD04 44.338 DM.pdfD04 44.343 UR COMBINED.pdf

D04 44.381 UR COMBINED.pdf

D04 44.386 UR COMBINED.pdfD04 44.386 UR COMBINED.pdfD04 44.436 UR COMBINED.pdfD04 44.436 DM COMBINED.pdfD04 44.491 UR COMBINED CHECKED.pdfD04 44.491 DM COMBINED.pdf


D04 44.595 UR COMBINED.pdfD04 44.595 DM COMBINED.pdfD04 44.600 UR COMBINED.pdfD04 44.600 DM COMBINED.pdf

D04 44.630 DM COMBINED.pdfD04 44.660 UR COMBINED.pdf





D04 44.762 DM.pdfD04 44.811 UR COMBINED.pdf



D04 44.919 DM COMBINED.pdf




D04 45.100 DM.pdfD04 45.105 UR COMBINED.pdfD04 45.105 DM.pdf

D04 45.166 UR.pdfD04 45.166 DM.pdfD04 45.171 UR.pdfD04 45.171 DM.pdf

D04 45.225 UR COMBINED.pdfD04 45.225 DM.pdf

pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2043.869%20UR%20COMBINED.pdf

pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2043.869%20DM%20COMBINED.pdf



















pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2044.338%20DM.pdf







pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2044.491%20UR%20COMBINED%20CHECKED.pdf
































pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2045.166%20UR.pdf


pw:%5C%5CPROJECTWISEV8I:PWISEV8i%5CDocuments%5CWestern%20and%20Wales%5CSurveys%20and%20Images%5CGWRM%20As%20Built%20Data%5CAmey%20Trial%20Hole%20Data%5CAs%20Built%20Trial%20Hole%20Forms%5CD04%2045.171%20UR.pdf




Yes YNo N

N/A

Trial Hole Status Definition ActionComplete Location complete as per Design Co-Ordinates NoneComplete - Closest Available Location Trial Hole complete at closest location to Design Co-Ordinates NoneScrap There is scrap rail where structure has been placed NR to arrange removal of scrap rail and inform contractor when they can resume work at that location.Complete - As per GRIP4 Location Where possible designer has moved structure to GRIP 4 Trial Hole location None Trial Hole Terminated Due To Water Trial pit has been terminated due to water being uncovered Contractor to return to location, reattempt dig and report as built coords.Contractor to TQ Contractor unsure how to proceed at this location Contractor to issue TQ to NRLocation Terminated Design no longer requires trial hole at provided x-y co-ordinate NoneNew Location New trial hole co-ordinates provided by designer Contractor to carry out trial hole

1) Contractor to populate Columns Q-W inclusive2) Contractor to provide ProjectWise Trial Pit Form Link in column W

Run on 13/11/2014 21:03

Significant loss of functionality # of occurrences

33

6

Minor loss of fidelity

3

Compatibility Report for Foundation location - RS1 CU D04 - Trial Hole AFC Isssue.xls

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.

One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results.

'Statistics'!G7:G39

Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition.

'Statistics'!M:M'Trial Hole Status'!P4:S65536

Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.

1Defined Names

Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.

Run on 13/11/2014 21:24

Significant loss of functionality # of occurrences

33

6

Minor loss of fidelity

3

Compatibility Report for Foundation location - RS1 CU D04 - Trial Hole AFC Isssue.xls

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.

One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results.

'Statistics'!G7:G39

Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition.

'Statistics'!M:M'Trial Hole Status'!P4:S65536

Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.

1Defined Names

Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.