I once worked for a company where the owner had written a Point of Sales system in Excel. It handled mixed orders where some product was given to the customer i

I once worked for a company where the owner had written a Point of Sales system in Excel. It handled mixed orders where some product was given to the customer immediately, some they could come back later and it would be packed for them to grab, and some would be shipped after the event. There were hundreds of SKUs, up to 8 computers taking orders, and most scary of all, they were networked together so that another computer running excel could collect sales data and help the production team figure out how many of each product they should make next. Also the order fulfillment team used the same collected data. It was brilliant. Excel was also the wrong tool. We constantly had problems with file locks, network shares, etc. After one year I worked with another guy to rewrite it as a web app.