Hi Jensen,
I want you try to following:
1) Write out the triangle leaving plenty of space between rows.
2) Immediately below each data point in the triangle, write the "as at" date.
For example, for Q4 2007 you should write:
695, 4857, 9687, 14698, 18455 ...
Dec07 Mar08 Jun08 Sep08 Dec08 ... etc
And for Q1 2008 you should write:
985, 6975, 11666, 15630, 17495, ...
Mar08 Jun08 Sep08 Dec08 Mar08 ... etc
The triangle of September diagonals will therefore need to include all figures which you have labelled as September.
3) Finally, convert the origin periods into years by summing the September diagonals into their respective origin years. For example, C13 should be 25,096 + 24,912 + 30,701+ 35,504 =116,213
Last edited: Mar 11, 2012