ALMM - C 69.00 : applicable spread for roll-overs in 'Prices for Various Lengths of Funding' template

What spread must be used for a ‘roll-over’ in ALMM table C 69.00?

Referring to Annex XIX -INSTRUCTIONS FOR COMPLETING THE ADDITIONAL MONITORING TOOLS TEMPLATE OF ANNEX XVIII, it is stated in part 1.4 in paragraph 10 that “For funding that has rolled-over during the reporting period that is still outstanding at the end of the reporting period the average of spreads applying at that time (i.e. end of reporting period) shall be reported. For the purposes of C69.00, funding that rolled-over and is still there at the end of the reporting period shall be considered to represent new funding”. It seems contradictory to ask for an average of spreads while referring to the end of the reporting period. For a roll-over, should we take into account the spread which was: • highest during the reporting period; • OR the spread which was applicable at the end of the reporting period (thus taking the reference rate at the end of the reporting period and the last fixing of rate of contract) • OR an average spread during the reporting period (only applicable if roll-overs within the reporting period should be taken into account)? Should we calculate the “average of spreads applying at that time” as stated in paragraph 10, as a weighted average? Is it possible to provide a clear and detailed example?