Weatherford Knowledge Base

Back to home

Weatherford Knowledge Base

P#

P#

Introduction to P#, Weatherford's unique petro-technical scripting language.

Getting Started with P#

What is P#?

How do I make sure that no one can edit my P# script?

How do I use Placeholders in P# Scripts?

How do I know what's being changed on my scripts?

What is the autocomplete in P# scripts?

How do I write P# Scripts?

Reference Tables vs Scenarios

See more

Data Cleansing

What is data cleansing in PetroVisor?

How do I write a data Cleansing Script in P#?

String Functions

Upper()

CurrentParent()

ToString()

NullString()

Signal()

ScenarioStringValue()

ParseJSON()

CurrentHierarchy()

Find()

Len()

Left()

Right()

_Hierarchy()

AggregateJSON()

_List()

CurrentDataGridCell()

DepthSignal()

EndofDepth()

EntitiesByName()

EntitiesFromEntitySet()

EntitiesInsideDataGridCell()

IsInsideDataGridCell()

LastStringValue()

Lower()

Mid()

OpportunitiesByName()

Predictor()

PredictProbability()

ResponseSurface()

ResponseSurfaceAggregation()

ResponseSurfaceAggregationPoint()

ResponseSurfaceProbability()

ResponseSurfaceScore()

StartOfDepth()

StringSignal()

TimeSignal()

ToAggregation()

Trim()

ToBoolean()

TimeStringSignal()

CurrentEntity()

Concat()

See more

Scenario Functions

ScenarioScope()

ScenarioEntities()

ScenarioValue()

Regression Functions

RegressionValue()

RegressionParameter()

Placeholder Functions

_DateTime()

_Double()

_Signal()

_Entity()

_String()

See more

Mathematical Functions

Cos()

Floor()

Ceiling()

Round()

NumberOfInputFeatures()

NumberOfPredictors()

Tan()

Sin()

Random()

Power()

LOG2()

E()

Trunc()

Sqrt()

Root()

Pi()

Log()

LN()

Exp()

ATan()

ASin()

ACos()

Abs()

See more

Logic Functions

IsTagged

IsEntityType

IsNotNull

Contains

IF THEN ELSEIF ELSE

IsNull

IIf

StartsWith()

EndsWith()

See more

Entities Function

EntitiesByParent()

EntitiesByHierarchy()

EntitiesFromIntersection()

EntitiesFromContext()

ValueForEntity()

Siblings()

EntitiesByDelimitedString()

EntitiesByParentTag()

EntitiesByType()

EntitiesByTag()

BestChildren()

BestEntity()

BestChild()

EntitiesByAlias()

All()

EntitiesByCondition()

See more

Moving Window Functions

MovingChange

MovingDiff

MovingDiv

MovingMin

MovingSlope

MovingAvg

MovingOutlier

MovingStep

MovingMax

MovingOscillationCoefficient

MovingSum

See more

Time and Date Functions

CurrentScope

Day

DayOfYear

StartOf()

Hour

Second

Today

CurrentStep

DaysInMonth

Millisecond

Minute

Next

Month

EndOfTag()

Now

Shift

EndOf()

DayOfWeek

ToDateTime

ToTimeStep()

TagDuration()

CurrentScopeIncrement()

Previous()

StartofTag()

Year()

DateDiff()

TimeValue()

See more

Statistical Functions

Count

First

Last

Median

Min

Mode

Percentile

Sum

Variance

Cumulative

HistoryCumulative

Max

StDev

Mod()

Normalize()

CumulativeByRank()

MovingPercentile()

Average

See more

Economic Functions

IRR()

NPV()

Data Handling

Null()

Smooth()

FillGaps()

ToDouble()

Replace()

NullDate()

See more

Additional Functions

TableValueAggregated() (deprecated)

TablesIntersection() (deprecated)

RefTableLastTimeStamp()

RefTableArea()

RefTableKey()

RefTablesIntersection()

RefTableValueAggregatedAsString()

TableKey() (deprecated)

LastValue()

WorkspaceDictionary()

DepthValue()

Rank()

WorkspaceValue()

PVTValue()

WorkspaceList()

WorkspaceEnumeration()

How do I use a depth dependent scope?

IsOpportunity()

DynaCard()

RefTableSlope()

RefTableValueAsString()

TableValue() (deprecated)

See more

Directional Functions

MinDistance()

ToDepthStep()

CoordinateDegree()

CoordinateUTM()

CoordinateCRS()

CurrentDepthStep()

CurrentScopeDepthIncrement()

See more

Machine Learning Functions

Predict()

PredictScore()

DetectSpike()

DetectChangePoint()

Forecast()

DetectAnomaly()

See more

DCA Functions

DCAModelParameter()

DCAModelDate()

DCAModelValue()

Neighborhood Functions

DataGridCellValue()

AggregateFromEntities()

CurrentRoot()

AggregateDataGrid()

AggregateIfTagged()

Neighbors()

PercentRank()

See more