DDDBE meetup #2 - Legacy Inferno
We'd be nowhere without companies like @nucleus_hosting who provide us with a location. Can your company help us for the next meetup?— DDD Belgium (@DDDBE) October 18, 2013
If you happen to have a venue and you are willing to host a DDDBE event, please do let us know!
Part 1: Turns out writing advanced Excel is a lot like writing software
The subject of the first part of this meeting was simple: legacy all over the place, even in places where you do not expect it to be: Excel files!! One might wonder what this had to do with DDD, and well, apparently some Excel files are not that different from software programs.
I could try explaining this, but I would assume that our presenter @Felienne’s slides explain it way better, so here we go:
Turns out a lot of companies are using Excel as a tool to write software, and it is one of biggest sources of hidden legacy in the enterprise. She even told us about a horror story where Excel files were actually used to monitor and manage a system that handled the distribution of gasses like argon… And apparently that is just the tip of the iceberg, and there are a lot more of these stories to be found over at eusprig.org.
Felienne is a very animated and entertaining presenter, with an interesting subject; here are a few impressions to give you an idea:
[email protected] (@mattiasgeniar) October 17, 2013
Spreadsheets exist under the radar in enterprises. Nobody knows where they are, how many, what the critical ones do.— DDD Belgium (@DDDBE) October 17, 2013
A machine to fill gas tanks, being run by one giant excel file? Yep.— DDD Belgium (@DDDBE) October 17, 2013
Why do people even use Excel for this? My personal opinion.
I would think that, when you ask people what they like the most about Excel, they would tend to forget the most important thing: instant feedback! Enter a formula somewhere, and you can see right away what the outcome is on your screen, no need to compile, run etc, just enter some data or formula and you will see directly whether your code works or not.
Excel provided continuous testing avant la lettre!
This might seem like an obvious thing, but it is not! Consider all the things people are doing in the latest decade to shorten the feedback cycle of their unit tests; this is a big thing.
In fact, I think there is one guy who realized this, and he actually started building an IDE that provides instant feedback:
This is an IDE that allows you to write software in the same way Excel works, and, to be honest, it looks awesome!! (While writing this post, I noticed an alpha is available, so that’s another thing on my todo list.)
Software design principles apply
In Excel these are in fact even more obvious; the classic paradigm of easy versus simple especially applies in Excel; things might be easy to write, but they are hard to figure out, so they are not simple. If attendees wonder what I was rambling about afterwards during the lean coffee over “easy versus simple”, I would like to take a look at this video, or a more detailed post I wrote about it:
Back to the excel thingy
In my opinion (and I think a lot of the attendees agreed), there is a lot of unexplored opportunity in this hidden gem called excel file refactoring. The more people start writing higher-level tools, the more the software design principles apply to the configuration/usage of those tools; there will probably be a whole brave new world out there…
2 Free tickets for the BuildStuffLt conference!
A few weeks ago Greg Young kindly provided us 2 free tickets for the [BuildStuff.lt]((https://buildstuff.lt/) conference, and the idea was to hand them out during this meeting…
And, for this one time that we did have a woman in the crowd, we asked her to pick out 2 cards out of a pile, which she did. Thank you @BuildStuffLt for this opportunity!
BTW, this is a great conference where some of us will be attending, and some others might, so make sure you check it out!
Part two: lean coffee
The next part was a non-conference using the lean coffee format. The crowd was interesting, but I honestly do think that we needed to split up in smaller groups, so we could give everyone the opportunity to speak up…
As an attempt to do that, I even promised to the group to keep my mouth shut for 10 minutes - which is hard for me, as I tend to have an opinion about anything ;-) -.
I would suggest that, for the next time we do this, we keep the groups smaller. I noticed during the DDD Barbecue with the German DDD community a while back, that when you have smaller groups (7 or 8 tops), everybody tends to speak up.
Nevertheless, a lot of interesting stuff passed, like what is DDD, what is CQRS, how to get started with DDD, what soft skills does a developer require?
The random quotes Mathias wrote down on the whiteboard during the event provide a good overview.
Wrapping it up
To wrap up this interesting evening, a few members of the community decided to have one last drink, talk about how it went and think about the next thing to do. We will keep you posted!
Thank you all for attending, we had a blast, and we hope you did as well!
Tom Expert in Tomfoolery
PS: if you do find any errors in this text or would like to add something, feel free to do so by editing this file here and sending me a pull request…