Well that’s end of a great day of Excel goodness, all that’s left now is a quick trip down the pub, and for Roger to convice me that Named ranges are as good as he thinks they are!!! Bring on the beer!!!
The goodies were better this year - well done Simon!
Morten Siersted, from conference sponsors http://www.f1f9.com, talking about FAST, a simplified set of rules his company is using to build clean models.
Its interesting to see this take on an approach to a standard, F1F9 have tried to give it an independent life, by passing it on to 3rd parties, I guess the concept is like open source, but for a spefification… if that make sense – it does to me, you can read all about it here
F1F9, Help, Calculate, or Help Breakpoint, my monies of the former!
As i have said before I liked what Morten had to say, I not sure everyone else did. I don’t think you would use the FAST standard for every model you every builid, but I’m certain that its principals would make a good many models a lot simpler to user and easier to maintain, I can think of a few around here that would greatly benefit!!!
I was looking forward to this one. Charles has huge respect in the Excel commuitely, and has a list of achievement’s as long as I am tall. Charles is talking about how hes getting on with writing addins in C. This is proper C not that C# rubbish!
Charles first makes the case for why he’s moved over to C, 64 bit and speed beign high on the list. Next its in to VS2010 and Planatech XLL+ with a walk through of how to do it, and some of the gottas for a VBA to C convert. I’ve done a few Pure C XLL’s, using such tools a WXL it works well, but XLL Plus sure looks nice, I like thoses wizards!!!
Synonymous with Speed Charles Williams at the helm
It was an insightful talk, not only for the how, but also for the, – it takes me longer, but is that because I have worked with VBA for 20 years? – I’ll ask if the speed gap has come down next year Charles!
Post lunch, and it’s Mathias, with a run down on VSTO, and what’s new and exciting in the .Net and Excel world, excellent day so far.
Here’s Mathias opening up visual studio, it didn’t crash, and he knew where everything was, what an IDE!!!
It can be done: VSTO deployment has gotten better.
A few examples of how to use VSTO, including the famous/infamous ”Click Once Deployment”. Its interesting to listen to Mathias, as he’s clearly been using this stuff out in the trenches, and so it gives a much better impression to hear him say, its getting better along the deployment story, than say an MS person saying it.
Excellent demos, and presentation, even dealth with the questions form Rickard, although I’m not sure Rickard is sold on the VSTO way yet!
Every good conference needs a lunch, and this is no exception! The slaughtered lamb….
The Slaughtered Lamb, 4 more happy punters!
This being an excel event there’s also beer, but no beer for Simon, professional to the end.
I think it might have been Gin, in that glass...