166
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 18 Nov 2024
166 points (97.7% liked)
Sysadmin
7717 readers
148 users here now
A community dedicated to the profession of IT Systems Administration
No generic Lemmy issue posts please! Posts about Lemmy belong in one of these communities:
!lemmy@lemmy.ml
!lemmyworld@lemmy.world
!lemmy_support@lemmy.ml
!support@lemmy.world
founded 1 year ago
MODERATORS
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.