Re:Reasons to ditch Excel
by klausjensen on Monday September 19, 2022 @09:33AM
(#32898081)
I have done a lot of line of business work over the years, and I would argue Excel is the perfect tool for prototyping processes.
Almost anybody can use it, it is simple and reasonably intuitive - and most importantly - extremely flexible, so you can change your processes and workflows without much cost.
Then once processes are figured out and reach a more stable state, you can turn that Excel process into something more smooth, custom software or a more advanced tool. And you have a pretty good starting point for a spec for the software.
Re:Reasons to ditch Excel
by peteradio on Monday September 19, 2022 @09:50AM
(#32898274)
Very very true, and yet I've often seen an excel workbook find its way as a permanent part of the process, even a fully automated one in some cases. Fortunately there are decent libraries for reading/creating workbooks in most languages.
Almost anybody can use it, it is simple and reasonably intuitive - and most importantly - extremely flexible, so you can change your processes and workflows without much cost.
Then once processes are figured out and reach a more stable state, you can turn that Excel process into something more smooth, custom software or a more advanced tool. And you have a pretty good starting point for a spec for the software.