Identify Dates to Use Interpolation for Each Section in a Condition Analysis

Dates where the next observed condition is greater than the last observed condition (within a section) use interpolation. At this point in the analysis, any date in the table that has not been assigned a PCI type is assigned the “Interpolation” type.

Date

Section 1 PCI

Section 1 PCI Type

Section 2 PCI

 

Section 2 PCI Type

Average

1/1/1995

100

Initial Construction

NULL

NULL

 

1/1/1996

 

Interpolation

NULL

NULL

 

1/1/1997

 

Interpolation

NULL

NULL

 

1/1/1998

 

Interpolation

NULL

NULL

 

6/1/1998

91

Inspection

NULL

NULL

 

6/1/1999

 

Interpolation

NULL

NULL

 

6/1/2000

 

Interpolation

NULL

NULL

 

9/1/2000

 

Interpolation

100

Initial Construction

 

6/1/2001

82

Inspection

97

Inspection

 

6/1/2002

 

Family

 

Family

 

6/1/2003

 

Family

 

Family

 

6/1/2004

 

Family

 

Family

 

9/1/2004

 

Family

 

Family

 

9/1/2004

100

Reconstruction

 

Family

 

1/1/2005

 

Family

 

Family