You can add additional pages to a single file so, although he could have created his Analysis on another part of the same sheet as the data entry, MIck made a new sheet titled Analysis. Starting with the analysis of income, in the first column he made an identical copy of the list in the drop down menu on the data entry sheet. In the second column used the “SUM” and “IF” formula to sum the total of the income relating to each analysis heading in turn, finally summing to a grand total adding a third column to show the percentage represented by each part of the total. He created a separate table for income expenditure. Finally he showed how to create colourful charts to display the data, in this case the percentage in a pie chart. The chart title headings can be edited by double clicking on them and in the case of the pie chart individual slices can be dragged out, all very Apple and user friendly.
David W had a problem with loading a very large number of photos to iCloud and although he still had plenty of storage capacity left the only explanation we could come up with was one suggested by Mick: possibly the total remaining storage needed to complete the transfer exceeded the actual storage available. David was going to add some storage and see if that fixed it.
On John M’s request David M gave a quick demonstration of saving web archives and the option of saving as pdfs.
Euan ended the evening by showing some short Affinity Photo videos to open our eyes to the new Affinity Designer for iPad.