Managing Complex Spreadsheets — The Story of PerfectXL.
Posted in , by This week we finished grading of the I’m teaching.
All in all, this spreadsheet has grown quite complex, and it is easy to make a mistake.
For example, I once released incorrect grades — a rather stressful event both for my students and myself.
And all I did wrong was forgetting the — despite the fact that I was well aware of this “feature”.
For the this year’s spreadsheet we had duplicate student ids, in a column where each row had to be unique, leading to a missing grade, and again extra effort and stress to resolve this as soon as possible.
Now I have an interest in spreadsheets that goes beyond that of the casual user: As a software engineering researcher, I have looked extensively at spreadsheets.
I did this together with , first when she was doing her PhD under my supervision in the context of the project (co-funded by Microsoft) and then in the context of the project (funded by the Dutch agency).
From a research perspective, these projects were certainly successful.

Leading to a series of publications in such venues as ECOOP 2010

ICSE 2011-2013, ICSM, EMSE, and SANER.
To that end, we founded a company, , which offers tooling, services, consultancy, and training to help organizations and individuals become more effective with their spreadsheets.
After several years of operating somewhat under the radar.

The Infotron team (headed by CEO ) has now launched an on line service

PerfectXL, in which users can upload a spreadsheet and get it analyzed.
The service then helps in the following ways: PerfectXL can visualize the between sheets, as shown above for my course sheet;.

PerfectXL can (such as the vlookup I mentioned

interrupted ranges, or overly complex conditional logic);.

PerfectXL can assess the structure and quality of the in your sheet

If this sounds interesting, you can try out the service for free at.
There are various that help Infotron run and further grow this service — pick the subscription that suits you and your organization best.

Even if you decide not to use the PerfectXL service

the site contains a lot of generally useful information, such as various hints and tips on how to well-structured spreadsheets.
, , The Collaborative Software Architecture Course Current Dutch Ius Promovendi Considered Harmful One thought on “Managing Complex Spreadsheets — The Story of PerfectXL ”.
Pieter October 10, .

2017 at 12:55 Thanks for sharing

I will check your ‘begroting’ sheet om perfectxl ???? Reply

Leave a Reply Cancel reply.
Enter your comment here.
Email Name Website You are commenting using your WordPress.com account.
(  /   ) You are commenting using your Google account.
(  /   ) You are commenting using your Twitter account.
(  /   ) You are commenting using your Facebook account.
(  /   ).
Search  (1).
(1).
(2).
(1).
(1).
(1).
(1).
(1).
(1).
(2).
(1).
(1).
(1).
(1).
(2).
(2).
(1).
(1).
(1).
(1).
(1).
(1).
(1).
(2).
(1).
(1).
(1).
(1).
(1).
(1).
(1).
(3).
(1).
(1).
(1).
Post to bloggers like this:.

Written by

admin