Replacement tokens for results in excel, 7 replacement tokens for results in excel – Retrotec FanTestic Customized Reports User Manual
Page 33
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.