I was literally told to set up this new service as quickly as possible and it didn’t need to be correct or best practice because this was just a proof of concept.
Here we are 6 months later and I’m still cleaning up my own mess.
I was literally told to set up this new service as quickly as possible and it didn’t need to be correct or best practice because this was just a proof of concept.
Here we are 6 months later and I’m still cleaning up my own mess.
My boss convinced me to make a pricing calculator for our contracts using Excel with macros. I pushed back and said we need to use Power Apps, CRM, or anything other than Excel. He said it would just be a POC/wireframe we’d use to build a more permanent solution with later.
Well 5 years later, there are like 2 dozen versions floating around with different macros, pricing, etc. And of course I’m the one who gets messaged every time some makes a change and breaks the damn thing, or some sales person is convinced it’s not calculating correctly. I fucking HATE that Excel sheet.
If it’s on Excel365, you can edit permissions for specific cell ranges. That way your colleagues can only give input but they can’t change formulas or fixed pricing.