Analyses are based on estimating the condition of all pavement sections in the analysis on the same date on an annual basis. To identify these dates, create rows in the table such that the time between successive rows is less than a year. Mathematically:
row.(N+1).date – row.(N).date ≤ 1 year
Example:
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|
Date in row 2 is over three years after the date in row 1, so insert a row and give it a date of 1 year after row 1.
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
1/1/1996 |
|
|
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|
Now check the row 2-3 gap. Even after adding the row, we still have more than a year, so add another row.
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
1/1/1996 |
|
|
|
|
|
|
1/1/1997 |
|
|
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|
Now check 3-4. Still more than a year, so add another row.
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
1/1/1996 |
|
|
|
|
|
|
1/1/1997 |
|
|
|
|
|
|
1/1/1998 |
|
|
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|
The gap between 4-5 is only 6 months, so we do not need to add a row there. The 5-6 gap is over a year, so we add another row and give it a date of 1 year after row 5.
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
1/1/1996 |
|
|
|
|
|
|
1/1/1997 |
|
|
|
|
|
|
1/1/1998 |
|
|
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
6/1/1999 |
|
|
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|
Continue doing this until time between consecutive rows is less than a year in all cases.
|
Date |
Section 1 PCI |
Section 1 PCI Type |
Section 2 PCI
|
Section 2 PCI Type |
Average |
|
1/1/1995 |
100 |
Initial Construction |
|
|
|
|
1/1/1996 |
|
|
|
|
|
|
1/1/1997 |
|
|
|
|
|
|
1/1/1998 |
|
|
|
|
|
|
6/1/1998 |
91 |
Inspection |
|
|
|
|
6/1/1999 |
|
|
|
|
|
|
6/1/2000 |
|
|
|
|
|
|
9/1/2000 |
|
|
100 |
Initial Construction |
|
|
6/1/2001 |
82 |
Inspection |
97 |
Inspection |
|
|
6/1/2002 |
|
|
|
|
|
|
6/1/2003 |
|
|
|
|
|
|
6/1/2004 |
|
|
|
|
|
|
9/1/2004 |
100 |
Reconstruction |
|
|
|
|
1/1/2005 |
|
|
|
|
|