Extracting Numbers from ALM Charts

You can extract the numbers from the funnel chart for copying into a spreadsheet. Once the funnel is showing the numbers you want to extract, click on the SHOW button:

Then on the dialogue that pops up, press the Select All button:

You should now be able to right-click on the selected data (or press CTRL+C) to copy the data which can be pasted directly into a spreadsheet.

NOTE that if success/failure is measured over the period of the projection, rather than just at the end, the percentiles gradually stop as the scenarios either succeed or fail. To get a full funnel right up to year x you need to set success/failure to something like :

The funding level of the scheme benefits on the buyout basis is greater than 100% after x years
The funding level of the scheme benefits on the buyout basis is less than 100% after x years