36 ms·
Billion dollar spreadsheet is a little late. Build real code around the 100k level
by Swizec 6y ago
Billion dollar spreadsheet is a little late. Build real code around the 100k level
- wruza 6y agoThis is a great advice, but the human nature prevents two things. First, you never do it at the right time. Second, you cut corners which would heavily affect the ease or even a possibility of such transition. I spent half my work life unfucking spreadsheets into databases and usually it is nuances and misstructure all the way down. You have to be a genius software developer and a master of discipline to be able to turn your sheets to code in zero years. Add some collaborators and it's over. The ability to make a formula in a cell instead of a column is a formula for disaster. If I was looking for the worst tool for a poor man's ERP, I would consider phpMyAdmin or a similar "data studio" tool, but not a spreadsheet. There are plenty, all ready for a frontend to be written in place of them.