F1F9 are running a session at Model Off’s Global Training Camp in London on the 6th December: www.gtc.modeloff.com/london
Having spent a lot of time talking in public about modelling with the FAST Standard, we thought we’d take the opportunity at Model Off to do something a little different. So two of F1F9’s leading lights, Kevin Gate and Andrew Berkley, will be talking about what it is like when you look beyond FAST.
They have been arguing for months about when to break the rules and they are ready to share their arguments with you.
We’ve asked them to focus on enterprise reporting and analysis assignments. For example, month end reporting for a finance function. What role does a standardised approach to modelling have in preparing:
* Data import routines;
* Consolidation of results; and
* Generation of reports
We are not quite certain where the debate might go (imagine all the passion of “BBC Question Time” and the excitement of “Strictly Come Dancing” all in the context of spreadsheets), but we are expecting topics of more general interest to emerge. Such as:
* The segregation of model functions: where to draw the lines in Excel when converting trial balance downloads to monthly management reports;
* How to manage change in your source data – and keep spreadsheets usable with an audit trail;
* The pivotal role of active lines in identifying data requiring further management within the spreadsheet;
* The pivotal role of Level 1 Data in preparing to generate reports; and
* Complex functions, defined Excel names and macros – their justification and their use.
In “Beyond the FAST Standard: adventures in enterprise reporting and analysis”, Kevin and Andrew will explore with you what it is like to break the rules but retain the spirit and the philosophy of a modelling standard. We have seen their spirited arguments – but never in public. We are hoping for fireworks.
If you want to add fuel to the excitement of the debate, then send us a question you’d like them to pose.
We can’t promise they will answer it – but we can promise they will argue over the question.
Kevin Gate is a lifelong modeller with a habit of asking and answering the question “why?”. He has unrivalled experience in working with the FAST Standard in the context of enterprise reporting and analysis. Kevin has great enthusiasm for breaking the rules.
Andrew Berkley is an average self-taught modeller whose skills benefited hugely from a standardised approach to modelling, Andrew prefers to follow the rules. Andrew looks after F1F9’s training.
We hope to see you at the event.