Spreadsheet: 881585d1729692364-get-a-pass-fail-for-a-report-generated-by-fastreporter-3-custom-otdr-bidirectional
Sheet: OTDR A->B

Identification Information
Filename: |  | <<Identification.FileName>> |  |  |  |  |  | Job ID: |  | <<Identification.JobID>>
Test date: |  | <<Identification.TestDateAtoB>> |  |  |  |  |  | Customer: |  | <<Identification.Customer>>
Test time: |  | <<Identification.TestTimeAtoB>> |  |  |  |  |  | Company: |  | <<Identification.Company>>
Comments: |  | <<Identification.Comments>>
Identifiers
<<CustomIdentifiers.Identifier1NameAtoB>> |  |  | <<CustomIdentifiers.Identifier2NameAtoB>> |  |  | <<CustomIdentifiers.Identifier3NameAtoB>> |  |  |  | <<CustomIdentifiers.Identifier4NameAtoB>> |  |  | <<CustomIdentifiers.Identifier5NameAtoB>>
<<CustomIdentifiers.Identifier1ValueAtoB>> |  |  | <<CustomIdentifiers.Identifier2ValueAtoB>> |  |  | <<CustomIdentifiers.Identifier3ValueAtoB>> |  |  |  | <<CustomIdentifiers.Identifier4ValueAtoB>> |  |  | <<CustomIdentifiers.Identifier5ValueAtoB>>
Location A |  |  |  |  |  |  |  | Location B
Location: |  | <<Identification.LocationA>> |  |  |  |  |  | Location:
Operator: |  | <<Identification.OperatorA>> |  |  |  |  |  | Operator:
Unit model: |  | <<Identification.LocationAUnitModel>> |  |  |  |  |  | Unit model:
Unit s/n: |  | <<Identification.LocationAUnitSerialNumber>> |  |  |  |  |  | Unit s/n:
Calibration Date: |  | <<Identification.LocationACalibrationDate>>
Test Parameters (<<OTDRSummary.Wavelength_FiberSizeAtoB>>)
Range (<<GeneralSettings.DistanceUnit>>): |  |  | <<OTDRSummary.RangeAtoB>> |  | Pulse (<<OTDRSettings.PulseUnit>>): |  |  |  | <<OTDRSummary.PulseAtoB>> |  | Duration (s): |  |  | <<OTDRSummary.DurationAtoB>>
Results (<<OTDRSummary.RealWavelength>> nm)
Span length (<<GeneralSettings.DistanceUnit>>): |  |  | <<OTDRSummary.SpanLengthAtoB>> |  | Span loss (dB): |  |  |  | <<OTDRSummary.SpanLossAtoB>> |  | Span ORL (dB): |  |  | <<OTDRSummary.SpanORLAtoB>>
 |  |  | <<OTDRSummary.SpanLengthAtoBPassFailStatus>> |  |  |  |  |  | <<OTDRSummary.SpanLossAtoBPassFailStatus>> |  |  |  |  | <<OTDRSummary.SpanORLAtoBPassFailStatus>>
Average loss (dB/<<GeneralSettings.DistanceUnit>>): |  |  | <<OTDRSummary.AverageLossAtoB>> |  | [NAME]. splice loss (dB): |  |  |  | <<OTDRSummary.AverageSpliceLossAtoB>> |  | [NAME]. splice loss (dB): |  |  | <<OTDRSummary.MaxSpliceLossAtoB>>
Graphic (<<OTDRSummary.RealWavelength>> nm)
((OTDRGraph.[NAME]))
Event Table (<<OTDRSummary.RealWavelength>> nm)
Type |  |  |  | No. | Location/ Length (<<GeneralSettings.DistanceUnit>>) |  |  | Loss  (dB) |  | Reflectance  (dB) |  | Attenuation  (dB/km) |  | Cumulative Loss (dB)
$$OTDREventTable.EventType$$ |  |  |  | $$OTDREventTable.EventNumber$$ | $$OTDREventTable.PositionAtoB$$$$OTDREventTable.SectionLengthAtoB$$ |  |  | $$OTDREventTable.EventLossAtoB$$$$OTDREventTable.SectionLossAtoB$$ |  | $$OTDREventTable.ReflectanceAtoB$$ |  | $$OTDREventTable.AttenuationAtoB$$ |  | $$OTDREventTable.CumulativeLossAtoB$$
 |  |  |  |  |  |  |  | $$OTDREventTable.EventLossAtoBPassFailStatus$$$$OTDREventTable.SectionLossAtoBPassFailStatus$$ |  | $$OTDREventTable.ReflectanceAtoBPassFailStatus$$ |  | $$OTDREventTable.AttenuationAtoBPassFailStatus$$
Markers Information (<<OTDRSummary.RealWavelength>> nm) |  |  |  |  |  |  |  | Manual Measurements (<<OTDRSummary.RealWavelength>> nm)
[NAME] |  |  | Position (<<GeneralSettings.DistanceUnit>>) |  | Value (dB) |  |  | Measurement |  |  |  | Value
a |  |  | <<OTDRMarkers.SubMarkerAPositionAtoB>> |  | <<OTDRMarkers.SubMarkerALossAtoB>> |  |  | 4 points event loss (dB) |  |  |  | <<OTDRMarkers.FourPointsEventLossAtoB>>
A |  |  | <<OTDRMarkers.MarkerAPositionAtoB>> |  | <<OTDRMarkers.MarkerALossAtoB>> |  |  | A-B LSA loss (dB) |  |  |  | <<OTDRMarkers.ABLSALossAtoB>>
B |  |  | <<OTDRMarkers.MarkerBPositionAtoB>> |  | <<OTDRMarkers.MarkerBLossAtoB>> |  |  | 2 points section att. (dB/km) |  |  |  | <<OTDRMarkers.TwoPointsSectionAttenuationAtoB>>
b |  |  | <<OTDRMarkers.SubMarkerBPositionAtoB>> |  | <<OTDRMarkers.SubMarkerBLossAtoB>> |  |  | A-B LSA attenuation (dB/km) |  |  |  | <<OTDRMarkers.ABLSAAttenuationAtoB>>
B-A |  |  | <<OTDRMarkers.DeltaBAPositionAtoB>> |  | <<OTDRMarkers.DeltaBALossAtoB>> |  |  | 3 points reflectance (dB) |  |  |  | <<OTDRMarkers.ThreePointsReflectanceAtoB>>
 |  |  |  |  |  |  |  | 3 points [NAME]. reflectance (dB) |  |  |  | <<OTDRMarkers.ThreePointsMaxReflectanceAtoB>>
 |  |  |  |  |  |  |  | A-B ORL (dB) |  |  |  | <<OTDRMarkers.ABORLAtoB>>
Pass/Fail Thresholds (<<OTDRThresholds.Wavelength>> nm)
Threshold |  |  | Fail |  | Warning
Splice loss (dB) |  |  | <<OTDRThresholds.SpliceLossFailAtoB>> |  | <<OTDRThresholds.SpliceLossWarningAtoB>>
Connector loss (dB) |  |  | <<OTDRThresholds.ConnectorLossFailAtoB>> |  | <<OTDRThresholds.ConnectorLossWarningAtoB>>
Reflectance (dB) |  |  | <<OTDRThresholds.ReflectanceFailAtoB>> |  | <<OTDRThresholds.ReflectanceWarningAtoB>>
Fiber sect. [NAME]. (dB/km) |  |  | <<OTDRThresholds.FiberSectionAttenuationFailAtoB>> |  | <<OTDRThresholds.FiberSectionAttenuationWarningAtoB>>
Span loss (dB) |  |  | <<OTDRThresholds.SpanLossFailAtoB>> |  | <<OTDRThresholds.SpanLossWarningAtoB>>
Span length (<<GeneralSettings.DistanceUnit>>) |  |  | <<OTDRThresholds.SpanLengthFailAtoB>> |  | <<OTDRThresholds.SpanLengthWarningAtoB>>
Span ORL (dB) |  |  | <<OTDRThresholds.SpanORLFailAtoB>> |  | <<OTDRThresholds.SpanORLWarningAtoB>>