Last December I had the good fortune of being able to represent Spreadsheet1 as a guest at the second day of the Modeloff Global Training Camp 2016 which was held at Canary Wharf in London.
This provided an interesting opportunity to meet a galaxy of MVPs; Roger Govier, Bob Phillips and Charles Williams were present in their capacity of ModelOff assessors. In the morning, I attended presentations by Liam Bastick (a virtuoso performance) and Dan Mayoh. Both presenters invited questions in open session, so it is well worth attendees spending time to identify those issues that are of concern to them. Dan had indicated that the use of Named Formulas was within scope of his presentation, so I suggested he should provide examples. His pièce de resistance was projecting a solid coloured image of the Batman logo built entirely from formulas held within defined names! Microsoft was out in force with a number of staff over from Redmond as well as the UK. They appeared interested in receiving user feedback and were engaging positively. The Microsoft ‘Power’ presentations were well attended.
Although I am not a financial modeller, I decided to attend the afternoon session in which Andrew Berkley of F1F9 set out to show how external data imported in columnar form could be transformed to feed into the standard FAST approach. There followed an interesting debate as to whether it is worth transforming to the conventional financial modelling layout or whether it would be better simply to accept the columnar layout and exploit the associated functionality such as Pivot tables.
Altogether a stimulating day!
Peter Bartholomew
This provided an interesting opportunity to meet a galaxy of MVPs; Roger Govier, Bob Phillips and Charles Williams were present in their capacity of ModelOff assessors. In the morning, I attended presentations by Liam Bastick (a virtuoso performance) and Dan Mayoh. Both presenters invited questions in open session, so it is well worth attendees spending time to identify those issues that are of concern to them. Dan had indicated that the use of Named Formulas was within scope of his presentation, so I suggested he should provide examples. His pièce de resistance was projecting a solid coloured image of the Batman logo built entirely from formulas held within defined names! Microsoft was out in force with a number of staff over from Redmond as well as the UK. They appeared interested in receiving user feedback and were engaging positively. The Microsoft ‘Power’ presentations were well attended.
Although I am not a financial modeller, I decided to attend the afternoon session in which Andrew Berkley of F1F9 set out to show how external data imported in columnar form could be transformed to feed into the standard FAST approach. There followed an interesting debate as to whether it is worth transforming to the conventional financial modelling layout or whether it would be better simply to accept the columnar layout and exploit the associated functionality such as Pivot tables.
Altogether a stimulating day!
Peter Bartholomew
RSS Feed
