beautypg.com

Replacement tokens for results in excel, 7 replacement tokens for results in excel – Retrotec FanTestic Customized Reports User Manual

Page 33

background image

rev-2014-10-27

Page 33 of 61
©Retrotec Inc. 2011-2014

Step

PointFlow

TotalFlow for point in step

PointPrA

AverageRoomPressure for point in
step

PointCR

CorrectedRoomPressure for point in
step

PointPrB

TotalFanPressure for point in step,
only valid if one fan is used

RangeUsed

not filled out

PointTarget

“bias0” for before step, “bias1” for
after step, otherwise TargetPressure
value for point in flow step

ReadingGauge

GaugeSerialNumber for this reading
fan pressure line

ReadingFlow

Flow for this reading fan pressure line

ReadingPrA

RoomPressure for this reading fan
pressure line

RangeUsed

“(bias)” or range name for this
reading fan pressure line

ReadingPrB

FanPressure for this reading fan
pressure line

TimeStamp

datetime for this reading fan pressure
line

3.7 Replacement tokens for results in Excel

Any result from a test can be included in the Excel spreadsheet template by modifying the Excel
template to include a defined range name with the same name as the Replacement Token for that
result.

Excel defined names cannot start with numbers, and cannot contain dashes.

If the replacement token starts with a digit, put an underscore in front of the replacement token to
create the defined name to put into the Excel template document.