Archive for November, 2011

UK Excel Developer conference date and location

November 30, 2011

the date and location for this event is now sorted:

Wednesday 25th Jan, all day.

and the location is here:
Skills Matter

This is the same venue as the last event as they looked after us so well.
We will go to the local pub for dinner, which also worked well last time.

So get the date and location in your diaries.

I’ll put up a book/pay link over the weekend.
I’ve only booked a medium sized room, so once its full we’ll have to stop taking bookings. I.e. book early…

The plan is for another smallish informal event with around 30 or so people.

I hope to see you there.




UK Excel Developer Conference London January 2012

November 22, 2011

08:30 – 08:45
Tea, coffee, small talk and any nice biscuits anyone brings
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.

Simon Murphy
09:15 – 09:45
Keeping track of development with working papers.
Branched arguments and conclusions from an Excel Workbook – a
management concept in VBA

Stephen Allen
09:45 – 10:00
Questions and answers & Tea and Coffee
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.

Bob Phillips
11:15 – 12:15
VBA to ExcelDNA The trials and tribulations of migrating from VBA to and ExcelDNA.
– Writing VBA UDFs that convert to C# and C++
– Using ExcelDNA to create XLLs
– Running VB.NET without Visual Studio

Mike Staunton
12:15 – 13:30
Dinner/Lunch PUB
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

Simon Murphy
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.

Mathias Brandewinder
15:05 – 15:30
Break Questions and answers over Tea and Coffee
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
C++ XLLs.
– Demonstrations and examples using Visual Studio 2010 and Planatech XLL+

Charles Williams
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.

Morten Siersted
17:30 – 18:00
Questions and answers and general lurking and conf close
18:00 – late
    Drinking and arguing    

UK Excel Developer Conference 2012

November 6, 2011

Its happening in London towards the end of Jan 2012.

More details to follow, but expect a rich technical program.

Current outline here.