|08:30 – 08:45||Tea, coffee, small talk and any nice biscuits anyone brings||all|
|08:45 – 09:15||The Excel Window
Excel is the window to most corporate data, and most corporate logic.
This session looks at trade offs you make by placing different elements at the various layers.
|09:15 – 09:45||Keeping track of development with working papers.
Branched arguments and conclusions from an Excel Workbook – a
management concept in VBA
|09:45 – 10:00||Questions and answers & Tea and Coffee||all|
|10:00 – 11:15||Will Self-Service BI Happen?
- Excel as the BI presentation layer
- PowerPivot as an end-user tool
- Bringing it all together.
|11:15 – 12:15||VBA to ExcelDNA The trials and tribulations of migrating from VBA to VB.net and ExcelDNA.
- Writing VBA UDFs that convert to C# and C++
- Using ExcelDNA to create XLLs
- Running VB.NET without Visual Studio
|12:15 – 13:30||Dinner/Lunch PUB||all|
|13:30 – 13:50||Managing the development process
Excel Development is RAD.
What does that mean?
how does it impact project management and planning?
The good and bad of RAD
And how to maximise one and minimise the other
|13:50 – 15:05||The .NET hammer: VSTO for Excel
Compared to other Excel automation approaches, VSTO (Visual Studio Tools
for Office) is heavyweight. We’ll illustrate some of its benefits (full
access to all the power of .NET, modern IDE and development languages, team
development, testable code, automated deployment), and discuss when using
VSTO is and isn’t a good idea.
|15:05 – 15:30||Break Questions and answers over Tea and Coffee||all|
|15:30 – 16:30||VBA to C : Pratfalls and Perils
- Stories based on a c++ newby’s efforts to convert 10K lines of VBA UDFs to
- Demonstrations and examples using Visual Studio 2010 and Planatech XLL+
|16:30 – 17:30||The FAST spreadsheet modelling standard
An industry proven, easily accessible, collaboratively developed, set of guidelines and recommendations to facilitate building robust spreadsheet models efficiently.
|17:30 – 18:00||Questions and answers and general lurking and conf close||all|
|18:00 – late||P-U-B||all|
|Drinking and arguing|