[Pooge]

> Start with a gsheet, when it breaks build something else.

Absolutely don't. The one who built the spreadsheet will have changed companies and the "business logic" and the knowledge will be gone with them. You're now stuck with a blackbox that no ones knows the specs of but everybody depends on.

[asdff]

If the sky doesn't fall the sky doesn't fall. Buddy of mine in sales is using some old DOS software from the 90s to control inventory and quotes. I bet there are absolutely zero people who know how it works in that company today. But, it works.

Turns out when you make relatively simple software, it doesn't really need maintenance. How often do you need to maintain a function like f(x)= mx + b? If it works it works.

[Pooge]

The question is not whether it works or not. It's that it becomes the bottleneck of your infrastructure.

Those users are accustomed to doing their work in a spreadsheet so it makes it harder to automate the process.

Spreadsheets are amazing tools, but they must not be used as the source of truth.

[asdff]

It is kind of interesting seeing the fear developers have over "everything in finance is on excel." It kind of reeks of armchairism where one assumes the worst immediately and assumes this assumption has somehow not been realized by the domain experts in this space who are in fact also smart spend all their time on the thing.

To an accountant, excel spreadsheet is a source of truth. There is no undetermined behavior. They can look at the calculations underlying the spreadsheet and understand what is happening, no different than a developer looking at source code. They do in fact have their own forms of unit tests considering these data are audited in a far more rigorous fashion than most any code that ships with unit tests.

[wewtyflakes]

How is that different than an engineer building out a service implementing material business logic then leaving for another job?

[Pooge]

A spreadsheet doesn't scale, is easily lost or corrupted or stolen, doesn't have security and people that tend to use it don't add data validation and don't care about atomic properties or data consistency.

[wewtyflakes]

These are different reasons than given previously. Regardless, Google Sheets are automatically versioned and have extensive access controls, both at the document level, and cell level. Further still, these types of documents are not black boxes, since anyone with access can inspect the data themselves. Arguments regarding scale and atomic operations/properties/consistency are fine, though I do not believe all business logic is necessarily beholden to these qualities.

[Pooge]

Let's qualify spreadsheets as software: critical software should not be made by a non-technical person that doesn't know software engineering principles.

I guess Google Sheets invalidates some of my arguments, but Excel certainly does not. And, even if the feature is there, I've never seen them applied.

[seb1204]

Agree but a company can still have rules for a sheet tool to have e.g. comments, explanations as part of it.