Reporting

Reporter

The results of OPILE analyses can be exported in a number of ways, including:

  • A customisable report to Microsoft Word.

  • A customisable report to Microsoft Excel.

  • Direct copying and pasting of information to other programs.

  • Production of a pile model for input to structural analyses.

The advantage of producing a report into Word or Excel is that these reports do not require specialised knowledge of OPILE in order to be able to interpret the results. Therefore, they are ideal for providing results to colleagues. The following sections explain how the reporting processes work.

_images/Reporter_Excel.png

Word Report

The Word reporter creates a file in Microsoft Word which summarises the OPILE analyses that have been carried out. This type of report production enables easy development of input for reports or it can be used to pass results on to colleagues. It is controlled by a series of options, however generally the default report file should prove adequate. It reports the input parameters, including pile properties, axial and lateral soil inputs, axial capacity, pile response curves and the output of load-displacement analyses. Word Reporter produces a format would not require special knowledge of the software in order to determine how the pile analyses had been carried out and it is considerably easier to read than the text file formats often produced by similar software.

The Word report which is output will be placed into the same directory as the current OPILE file that is open. The report may require some editing for aesthetic reasons before it is used elsewhere. The report is based upon the report template (OPILE Output Template.dot) which is contained within the OPILE program directory. This report template can be customised by users and this customisation might include things such as the company logo.

_images/Reporter_Word.png

The actual output of the Word report is primarily controlled in two separate places. The first is the Word tab in the reporter dialogue box, where override values to the title, template and folder where the file is written can be entered. There is also the option to control the way that text boxes, combo boxes and check boxes are output. In OPILE many text boxes and combo boxes turn yellow if input is required or used. The two options (see picture above) are to output the contents of these controls regardless of whether they are used in the current analysis, or to only output the contents of the controls that are actually used in the analyses.

The other place which controls the output of the report are the check boxes which are selected under the Analysis Options section in the main OPILE window. Where one of these check boxes is checked the relevant output will be included in the Word report.

Note: Previous versions of OPILE required Microsoft Word 2003 to create the reports. Changes have now been made and OPILE has no dependency on Microsoft Word and it does not need to be installed, apart from to view the reports that are created.

Excel Report

The Excel reporter exports the results of OPILE analyses into a Microsoft Excel file. The Excel file is generated from a customisable template file (Report Excel Template.xls) which is contained within the OPILE program directory. This template can be customised to produce OPILE results formatted for inclusion into reports. It is still possible to use the Excel exporter even if Excel is not installed, and the files it produces should be readable by any version from Excel 2003 onwards.

_images/Reporter_Excel.png

The actual output of the Excel report is primarily controlled in two separate places. The first is the Excel tab in the reporter dialogue box, where override values to the title, template and folder where the file is written can be entered. There is also the option to control the way that text boxes, combo boxes and check boxes are output. In OPILE many text boxes and combo boxes turn yellow if input is required or used. The two options (see picture above) are to output the contents of these controls regardless of whether they are used in the current analysis, or to only output the contents of the controls that are actually used in the analyses.

The other place which controls the output of the report are the check boxes which are selected under the Analysis Options section in the main OPILE window. Where one of these check boxes is checked the relevant output will be included in the Excel report.

In generating the Excel report OPILE makes extensive use of “Named Ranges” within Excel and it is to these that information will be written. The use of named ranges, rather than cell references, means that users can layout the Excel report as they wish it to appear. If OPILE does not find the named range when it attempts to write something to Excel then that data will not be written, neither should this cause an error. The worksheet names in Excel can also be changed. If the named range in Excel is too small for the information to be pasted from OPILE then some data will be missing. The named ranges can be moved around within Excel (by dragging or cutting and pasting) to customise the report.

By default OPILE will use its own default Excel template stored in the program directory, however, OPILE will also allow the selection of a particular report template to use. For example, an Excel report may be customised for a particular project and it may be required to base all project reports on that modified template. Additionally the report can be customised by the inclusion of plots of the data as required.

The Excel report will be written to the same folder as the current OPILE file, however, it is also possible to specify an alternative directory.

In order to write the information the parameter and the named range is given below:

OPILE parameter name

OPILE Tab

Type of output

number of rows

Number of columns

Named range in Excel template

Date

General

Text

1

1

Date

Project Title

General

Text

1

1

Project

Client

General

Text

1

1

Client

Engineer

General

Text

1

1

Engineer

Location

General

Text

1

1

Location

Project No

General

Text

1

1

Project_No

Notes

General

Text

1

1

Notes

Pile Penetration

General

Text

1

1

Penetration

Pile Length

General

Text

1

1

Full_Length

Use a different length to the penetration

General

Boolean

1

1

UseDiffLengthToPenetration

General Scour

General

Text

1

1

GeneralScour

Local Scour

General

Text

1

1

LocalScour

Overburden Reduction Depth

General

Text

1

1

OverburdenReductionDept

Pile Property Data

General

Grid

10

11

Prop_Data

Annular Area Override

General

Text

1

1

AnnularAreaOverride

Total Pile Weight

General

Text

1

1

TotPileW

Material Property Data

General

Grid

10

5

Mat_Data

TZ, QZ Curves and Axial Capacity

General

Boolean

1

1

AnAxCurves

Auto Generate Axial Load Cases

General

Boolean

1

1

AutoAxLoad

Axial Load Displacement Response

General

Boolean

1

1

AxLDResp

PY Curves

General

Boolean

1

1

AnLatCurves

Auto Generate Lateral Load Cases

General

Boolean

1

1

AutoLatLoad

Lateral Load Displacement Response

General

Boolean

1

1

LatLDResp

Soil Resistance to Driving

General

Boolean

1

1

AnSRD

Conductor Mode

General

Boolean

1

1

ConductorMode

Retain Old Results

General

Boolean

1

1

RetainOldResults

Iteration Limit

General

Text

1

1

IterationLimit

Uncouple TZ/QZ and PY Generation from Load Displacement Response

General

Boolean

1

1

UncoupleLDResp

Analysis Notes

General

Text

1

1

AnalysisNotes

Include Border on Charts

General

Boolean

1

1

InclBorder

Include Location Box on Charts

General

Boolean

1

1

InclLocation

Include Project Number Box on Charts

General

Boolean

1

1

InclProjectNo

Include Project Name Box on Charts

General

Boolean

1

1

InclProject

Include Client Name Box on Charts

General

Boolean

1

1

InclClient

Reshape Chart for Copying

General

Boolean

1

1

ChartReshape

Axial Capaity Units

General

Text

1

1

UnitAxCap

End Bearing Units

General

Text

1

1

UnitEndBearing

Axial Soil Input Data

Axial Soil

Grid

100

24

AxialSoil

K Sand Compression

Axial Soil

Text

1

1

K_Comp

K Sand Tension

Axial Soil

Text

1

1

K_Tens

Sand Friction Multiplier

Axial Soil

Text

1

1

SandFrictionMultiplier

Clay Friction Multiplier

Axial Soil

Text

1

1

ClayFrictionMultiplier

ICP Base Condition

Axial Soil

Text

1

1

ICPBaseCondition

TZ Method

Axial Soil

Text

1

1

TZMethod

CPT Diameter

Axial Soil

Text

1

1

CPTDiam

Pile roughness

Axial Soil

Text

1

1

Pile_Roughness

TMod

Axial Soil

Text

1

1

TMod

ZMod (TZ Curve)

Axial Soil

Text

1

1

ZMod

Optional End Bearing Limit

Axial Soil

Boolean

1

1

OptEndLimit

Optional Skin Friction Limit

Axial Soil

Boolean

1

1

OptSkinLimit

zpeak/D

Axial Soil

Text

1

1

ZpeakOverD

Clay Alpha

Axial Soil

Text

1

1

ClayALPHA

QMod

Axial Soil

Text

1

1

QMod

ZMod (QZ Curves)

Axial Soil

Text

1

1

ZqMod

Clay Exp 1

Axial Soil

Text

1

1

ClayExp1

Clay Exp 2

Axial Soil

Text

1

1

ClayExp2

IP Lower Limit

Axial Soil

Text

1

1

IPLowerLimit

IP Upper Limit

Axial Soil

Text

1

1

IPUpperLimit

IP Divisor

Axial Soil

Text

1

1

IPDivisor

IP Subtractor

Axial Soil

Text

1

1

IPSubtractor

n for PSI>1.0

Axial Soil

Text

1

1

nForPSI

Smooth Plugged End Bearing

Axial Soil

Boolean

1

1

CorrectEndBearing

Plugged End Bearing Correction - Above Distance

Axial Soil

Text

1

1

EndBearingAboveDistance

Plugged End Bearing Correction - Below Distance

Axial Soil

Text

1

1

EndBearingBelowDistance

Plugged End Bearing Correction - Increment

Axial Soil

Text

1

1

EndBearingIncrement

Smooth Unplugged End Bearing

Axial Soil

Boolean

1

1

CorrectEndBearing_U

Unplugged End Bearing Correction - Above Distance

Axial Soil

Text

1

1

EndBearingAboveDistance_U

Unplugged End Bearing Correction - Below Distance

Axial Soil

Text

1

1

EndBearingBelowDistance_U

Unplugged End Bearing Correction - Increment

Axial Soil

Text

1

1

EndBearingIncrement_U

Lateral Soil Input Data

Lateral Soil

Grid

100

27

LateralSoil

Cyclic or Static

Lateral Soil

Text

1

1

CyclicOrStatic

P Modifier

Lateral Soil

Text

1

1

PMod

Y Modifier

Lateral Soil

Text

1

1

YMod

Stiff CLAYAPI Factor

Lateral Soil

Text

1

1

StiffCLAYFactor

Stiff CLAYAPI Limit Strength

Lateral Soil

Text

1

1

StiffCLAYStrength

Rock Mass Shear Strength as Fraction of UCS

Lateral Soil

Text

1

1

RockMassStrengthAsPercent

Fragio Transition Depth

Lateral Soil

Text

1

1

FragioTransitionDepth

x0 for Wesselink and Dunnavant

Lateral Soil

Text

1

1

x0

Dunnavant Cycles

Lateral Soil

Text

1

1

DunnavantCycles

Rock Reese97 Krm

Lateral Soil

Text

1

1

RockReeseKrm

Rock Reese97 Top Depth of Rock Layer

Lateral Soil

Text

1

1

RockReeseTopOfRock

Novello Cycles

Lateral Soil

Text

1

1

NovelloCycles

Allow Y Shifts

Lateral Soil

Boolean

1

1

AllowYShifts

Manually define Xr

Lateral Soil

Boolean

1

1

Manually_Define_Xr

Manually defined Xr value

Lateral Soil

Text

1

1

Manual_Xr

Modify Y for large diameter piles

Lateral Soil

Boolean

1

1

Modify_Y_LargeDiameterPile

SRD Soil Input Data

SRD Soil

Grid

100

25

SRDSoil

Main SRD Method

SRD Soil

Text

1

1

SRD_MAIN

K Sand Compression

SRD Soil

Text

1

1

K_STEVENS

Nu - Rock

SRD Soil

Text

1

1

STEVENS_NU

Upper Bound Residual Lambda - Clay

SRD Soil

Text

1

1

UB_LAMBDA_RES

Lower Bound Residual Lambda - Clay

SRD Soil

Text

1

1

LB_LAMBDA_RES

Upper Bound Lambda Maximum - Clay

SRD Soil

Text

1

1

UB_LAMBDA_MAX

Lower Bound Lambda Maximum - Clay

SRD Soil

Text

1

1

LB_LAMBDA_MAX

Upper Bound Residual Lambda - Sand, Rock

SRD Soil

Text

1

1

UB_LAMBDA_RES_SAND

Lower Bound Residual Lambda - Sand, Rock

SRD Soil

Text

1

1

LB_LAMBDA_RES_SAND

Upper Bound Lambda Maximum - Sand, Rock

SRD Soil

Text

1

1

UB_LAMBDA_MAX_SAND

Lower Bound Lambda Maximum - Sand, Rock

SRD Soil

Text

1

1

LB_LAMBDA_MAX_SAND

Colliat Non Degradation Length

SRD Soil

Text

1

1

COLLIAT_DEGR

ALM Upper Bound Factor

SRD Soil

Text

1

1

ALM_UBFACTOR

ALM Factor on Sand Friction

SRD Soil

Text

1

1

ALMFactorSandFriction

ALM Factor on Clay Friction

SRD Soil

Text

1

1

ALMFactorClayFriction

Include Effect of Installation Weight

SRD Soil

Boolean

1

1

InclInstalWeight

Weight 1

SRD Soil

Text

1

1

HAMMER_WEIGHT1

Weight 2

SRD Soil

Text

1

1

HAMMER_WEIGHT2

Weight 3

SRD Soil

Text

1

1

HAMMER_WEIGHT3

Plugged Skin Factor - Sand (UB)

SRD Soil

Text

1

1

STEVENS_NC_SKINF

Plugged Nc - Clay (UB)

SRD Soil

Text

1

1

STEVENS_NC

Plugged End Factor - Sand (UB)

SRD Soil

Text

1

1

STEVENS_UB_END

Unplugged UB Skin Factor

SRD Soil

Text

1

1

STEVENS_CORUBSAND

Unplugged LB Skin Factor

SRD Soil

Text

1

1

STEVENS_CORDLBSAND

SRD Custom Input

SRD Soil

Grid

5

5

SRDCustom

Auto Generate Pile Grid

Custom Input

Boolean

1

1

AutoGenPileGrid

Default Grid Increment

Custom Input

Text

1

1

DefaultGridIncr

Custom Lateral Grid

Custom Input

Grid

200

7

LatGrid

Custom Axial Grid

Custom Input

Grid

200

5

AxGrid

Custom SRD Grid

Custom Input

Grid

200

5

SRDGrid

T/Tmax and Z/D Values for TZ Calculation in Clay (API 2000)

Custom Input

Grid

8

2

ValTZClay

T/Tmax and Z/D Values for TZ Calculation in Sand (API 2000)

Custom Input

Grid

8

2

ValTZSand

T/Tmax and Z/Zpeak Values for TZ Calculation in Clay (API RP2GEO)

Custom Input

Grid

8

2

ValTZClay_RP2GEO

T/Tmax and Z/Zpeak Values for TZ Calculation in Sand (API RP2GEO)

Custom Input

Grid

8

2

ValTZSand_RP2GEO

Q/Qmax and Z/D Values for QZ Calculation in Clay and Sand (API 2000 and API RP2GEO)

Custom Input

Grid

8

2

ValQZ

Z/D Values for Axial Load Generation

Custom Input

Grid

8

1

ValAxOther

P/Pmax and Y/Yc Values for Static PY Calculation in Clay

Custom Input

Grid

8

2

ValPY

P/Pmax and Y/Yc Values for Cyclic PY Calculation in Clay

Custom Input

Grid

8

2

ValPY_C

P/Pmax and Y/Yc Values for Cyclic PY Calculation in Clay (Reduced Capacity Zone)

Custom Input

Grid

8

2

ValPY_C_RedCap

Y/D Values for PY Calculation and Lateral Load Generation

Custom Input

Grid

8

1

ValLatOther

Custom TZ Curve 1

Custom Input

Grid

8

2

TZCurve1

Custom TZ Curve 2

Custom Input

Grid

8

2

TZCurve2

Custom TZ Curve 3

Custom Input

Grid

8

2

TZCurve3

Custom QZ Curve 1

Custom Input

Grid

8

2

QZCurve1

Custom QZ Curve 2

Custom Input

Grid

8

2

QZCurve2

Custom QZ Curve 3

Custom Input

Grid

8

2

QZCurve3

Custom PY Curve 1

Custom Input

Grid

8

2

PYCurve1

Custom PY Curve 2

Custom Input

Grid

8

2

PYCurve2

Custom PY Curve 3

Custom Input

Grid

8

2

PYCurve3

Locate Axial response Peaks

Load Cases

Boolean

1

1

LocateAxRespPeaks

Include Pile Weight in Axial Analysis

Load Cases

Boolean

1

1

InclPileWeightinAxAn

Type of Load Cases

Load Cases

Text

1

1

LCType

Initial Displacement

Load Cases

Text

1

1

InitDisp

Displacement Interval for Peaks

Load Cases

Text

1

1

DispIntervalPeaks

Iterations to Find Peaks

Load Cases

Text

1

1

ItPeaks

Distinct Compression Peak Found Before 0.05D Displacement

Load Cases

Text

1

1

CompPeak

Peak Tension Load

Load Cases

Text

1

1

PeakTens

Axial Load Cases Input

Load Cases

Grid

200

7

AxialLoad

Rotation

Load Cases

Text

1

1

Rotation

Grid Point

Load Cases

Text

1

1

GridPoint

Axial Load for Lateral Analysis

Load Cases

Text

1

1

AxLoadForLatAn

Lateral Load Cases Input

Load Cases

Grid

200

6

LatLoad

TZ Curves - Combined

TZ Curves

Grid

400

13

TZCurves

TZ Mid Element Depth

TZ Curves

Grid

200

1

TZDepth

T Points

TZ Curves

Grid

200

8

TZCurvesT

Z Points  (TZ)

TZ Curves

Grid

200

8

TZCurvesZ

Top Depth Limit TZ Curves

TZ Curves

Text

1

1

TZTopDepth

Lower Depth Limit TZ Curves

TZ Curves

Text

1

1

TZLowerDepth

QZ Curves - Combined

QZ Curves

Grid

400

13

QZCurves

QZ Mid Element Depth

QZ Curves

Grid

200

1

QZDepth

Q Points

QZ Curves

Grid

200

8

QZCurvesQ

Z Points  (QZ)

QZ Curves

Grid

200

8

QZCurvesZ

Top Depth Limit QZ Curves

QZ Curves

Text

1

1

QZTopDepth

Lower Depth Limit QZ Curves

QZ Curves

Text

1

1

QZLowerDepth

PY Curves - Combined - Cyclic

PY Curves

Grid

400

12

PYCurvesCYCLIC

PY Curves - Combined - Static

PY Curves

Grid

400

12

PYCurvesSTATIC

PY Mid Element Depth - Cyclic

PY Curves

Grid

200

2

PYCyclicDepth

P Points - Cyclic

PY Curves

Grid

200

9

PYCyclicP

Y Points - Cyclic

PY Curves

Grid

200

9

PYCyclicY

PY Mid Element Depth - Static

PY Curves

Grid

200

2

PYStaticDepth

P Points - Static

PY Curves

Grid

200

9

PYStaticP

Y Points - Static

PY Curves

Grid

200

9

PYStaticY

Top Depth Limit PY Curves

PY Curves

Text

1

1

PYTopDepth

Lower Depth Limit PY Curves

PY Curves

Text

1

1

PYLowerDepth

Plot Static or Cyclic PY Curves

PY Curves

Text

1

1

PYPlotCyclicStatic

AxCap (All Penetrations)

AXCAP

Grid

200

8

AxCap

AxCap Details (Final Penetration)

AXCAP

Grid

200

9

Axcap_Single

End Bearing

AXCAP

Grid

600

5

Axcap_End

Skin Friction

AXCAP

Grid

600

4

Axcap_Skin

Overburden

AXCAP

Grid

200

4

Axcap_Overburden

SRD Output

SRD

Grid

200

13

SRDOutput

SRD Summary

SRD

Grid

6

9

SRDSummary

SRD Summary Depth

SRD

Text

1

1

SRDSymmaryDepth

Full Axial Output - Selected Load Case

AXIAL OUTPUT

Text

1

1

AxSelectedLC

Full Axial Output - Single Case

AXIAL OUTPUT

Grid

200

9

AxialFullOutput

Axial Selected Grip Point

AXIAL OUTPUT

Text

1

1

AxSelectedGridPoint

Axial Summary

AXIAL OUTPUT

Grid

200

10

AxialSummaryOutput

Full Axial Output - All Load Cases

AXIAL OUTPUT

Grid

10000

10

Axial_ALL_Cases

Full Lateral Output - Selected Load Case

LATERAL OUTPUT

Text

1

1

LatSelectedLC

Full Lateral Output - Single Case

LATERAL OUTPUT

Grid

200

8

LatFullOutput

Lateral Selected Grip Point

LATERAL OUTPUT

Grid

1

1

LatSelectedGridPoint

Lateral Summary

LATERAL OUTPUT

Grid

200

10

LatSummaryOutput

Full Lateral Output - All Load Cases

LATERAL OUTPUT

Grid

10000

9

Lat_ALL_Cases

Sand Replacement Methods

ALLCAP

Grid

1

6

ALLCAP_Comparison_Sand

Clay Replacement Methods

ALLCAP

Grid

1

6

ALLCAP_Comparison_Clay

Target penetrations

ALLCAP

Grid

6

1

ALLCAP_TargetPenetration

Summary of ALLCAP - Target Penetration 1

ALLCAP

Grid

7

6

ALLCAP_Summary_1

Summary of ALLCAP - Target Penetration 2

ALLCAP

Grid

7

6

ALLCAP_Summary_2

Summary of ALLCAP - Target Penetration 3

ALLCAP

Grid

7

6

ALLCAP_Summary_3

Summary of ALLCAP - Target Penetration 4

ALLCAP

Grid

7

6

ALLCAP_Summary_4

Summary of ALLCAP - Target Penetration 5

ALLCAP

Grid

7

6

ALLCAP_Summary_5

Summary of ALLCAP - Target Penetration 6

ALLCAP

Grid

7

6

ALLCAP_Summary_6

Skin Friction (Single) - Replacement 1

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_1

Skin Friction (Single) - Replacement 2

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_2

Skin Friction (Single) - Replacement 3

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_3

Skin Friction (Single) - Replacement 4

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_4

Skin Friction (Single) - Replacement 5

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_5

Skin Friction (Single) - Replacement 6

ALLCAP

Grid

200

7

ALLCAP_Single_Friction_6

Cumulative Friction Capacity (Single) - Replacement 1

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_1

Cumulative Friction Capacity (Single) - Replacement 2

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_2

Cumulative Friction Capacity (Single) - Replacement 3

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_3

Cumulative Friction Capacity (Single) - Replacement 4

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_4

Cumulative Friction Capacity (Single) - Replacement 5

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_5

Cumulative Friction Capacity (Single) - Replacement 6

ALLCAP

Grid

200

7

ALLCAP_Single_Cap_6

Total Capacity (All penetrations)

PROWEAP

Text

1

1

ALLCAP_All_Caps

Source Folder for WEAP Files

PROWEAP

Text

1

1

WEAP_FOLDER

WEAP Output File Extension

PROWEAP

Text

1

1

WEAP_FILE_TYPE

Weap Line Identifier

PROWEAP

Text

1

1

WEAP_LINEID

Number of Lines To Jump Forward

PROWEAP

Grid

12

10

WEAP_NOLINEJUMPS

WEAP File Import

PROWEAP

Text

1

1

WEAP_FILE_IMP

Pile Length

PROWEAP

Text

1

1

WEAP_PILE_LENGTH

Pile Penetration

PROWEAP

Text

1

1

WEAP_PILE_PENETRATION

Steel Area

PROWEAP

Text

1

1

WEAP_STEEL_AREA

Hammer

PROWEAP

Text

1

1

WEAP_HAMMER

Shaft Quake

PROWEAP

Text

1

1

WEAP_SHAFT_QUAKE

Tip Quake

PROWEAP

Text

1

1

WEAP_TIP_QUAKE

Shaft Damping

PROWEAP

Text

1

1

WEAP_SHAFT_DAMPING

Tip Damping

PROWEAP

Text

1

1

WEAP_TIP_DAMPING

Percent Shaft Resistance

PROWEAP

Text

1

1

WEAP_SHAFT_RESISTANCE

Source Folder for Driving Records

PROWEAP

Text

1

1

WEAP_RECORDS_FILE

Driving File Selected for Import

PROWEAP

Text

1

1

WEAP_DRIVING_FILES

File Delimiter

PROWEAP

Text

1

1

WEAP_DELIMITER

Row Containing Column Headers

PROWEAP

Text

1

1

WEAP_ROW_COL_HEADERS

Row Where Import Begins

PROWEAP

Text

1

1

WEAP_ROW_IMPORT_START

Blow Number

PROWEAP

Text

1

1

WEAP_COL_BN

Length of Pile in Soil

PROWEAP

Text

1

1

WEAP_COL_EL

Energy Column (EMX) Averaged

PROWEAP

Text

1

1

WEAP_COL_EMX

Refusal Criteria

PROWEAP

Text

1

1

WEAP_PLOTTING_REFUSAL_CRIT

CSX (Max in Increment)

PROWEAP

Text

1

1

WEAP_COL_CSX

TSX (Max in Increment)

PROWEAP

Text

1

1

WEAP_COL_TSX

Delete Existing Driving Records

PROWEAP

Boolean

1

1

WEAP_DEL_EX_REC

Imported WEAP Results

PROWEAP

Grid

2000

13

WEAP_IMP

Imported Driving Records

PROWEAP

Grid

2000

18

WEAP_RECORD

Axial Chart Warning

Text

1

1

AXIAL_WARNING

Structural Model

The structural modelling module in OPILE that can be used to output pile models (i.e. pile parameters, TZ, QZ and PY curves) for input to various structural analyses packages. There are various options that can be used with this, such as the option to include load cases if the structural analysis package allows analysis of a single pile. This means that results of OPILE can be readily compared.

The module outputs the pile model into a text file and the pile response curves are output into the exact format and units which a particular package requires. This saves the, usually quite tedious, process of converting the curves and then either manipulating through software such as Excel or even retyping them in by hand!

Model Choices

Currently the only software which is seamlessly supported is Sacs, although in the interests of developing our software we would be happy to discuss the output of pile models to other publicy available structural analysis software. USFOS is also supported, although this has been tested less and should only be used with some caution.

File Description

File description is a text box that allows entry of some descriptive text specifically for the pile model generation. Normally the other information which is entered about an OPILE analysis is included as comments within the pile model file.

Include Load Cases

There is an option to include load cases, where applicable, if the structural analyses package allows analysis of a single pile. If load cases are included they are extracted from the lateral and axial load case tables. Note that currently only loads applied at the pile head should be included, as not all analysis packages accept loads applied elsewhere on the pile. In addition torsional load cases are not included.

Mininum Depth for QZ Curves

The minimum depth for QZ curves is included as an option to help prevent execessively long structural model files being generated. For instance it might be desirable to define the minimum depth for QZ curves to be 10m above the pile tip, that way only QZ curves for the last 10m of the pile penetration will be generated.

Soil Model Number

The soil model number is included if it is possible that more than one pile model (each with different soil stratigraphies) will be defined for the same jacket analyses. Using a different soil model number should allow the structural software to differentiate between the models.

General Recommendations

It is always recommended that some comparison is made between the output from the structural analysis software and the results of OPILE to ensure that the conversion has been made correctly. There may be some small differences due to the calculation methods implemented in the various software packages that are available.

Batch Control

Batch Control allows the continuous processing or/and reporting of a list of OPILE files. The start a batch run, the Path & Name of the batch run template needs to be provided. The standard batch run procedure consists of:

  1. opening a OPILE file listed in the batch run template,

  2. runs “Analyse”, and “Compare Capacities” (*),

  3. saves and closes the OPILE file (i)

This procedure is repeated as long as all listed files are processed.

(*) only when a target penetration and a replacement combination are provided in the ALLCAP tab.

Alternatives: Within the Batch Control, the user can include the generation of Word or Excel reports for each file.

_images/Reporter_BatchRun.png

Requirements for Batch Run Template:

  • The standard OPILE Batch Run Template (OPILE Batch Run Template.xlsx) is contained within the OPILE program directory.

  • As minimum, the template needs to contain the following Name Variables:

    • Input_Path : OPILE looks in this cell for the path of the listed OPILE files

    • Output_Path : OPILE looks in this cell for the path where to save the OPILE files (when it is the same as the input path, the OPILE files will be overwritten)

    • Title_List : OPILE looks below this cell for the list of OPILE file names

    • RunNo : OPILE looks in this cell for the number of OPILE files the Batch run should contain.

Optional named variables are:

  • Include_List : OPILE will look below this cell, with the same amount of rows below the Title_List cell, and include or not the file in the batch run (this will not change the number in RunNo)

  • Date_List : OPILE will write below this cell, with the same amount of rows below the Title_List cell, the date of the most recent Run

By including the necessary named variables into the same Sheet, any Excel file can be used as source of a Batch Run file, as long as the Sheet with the named variables is the ‘active sheet’ when opening the file.