Sysadmin

7682 readers

253 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

DarraignTheSane@lemmy.world

00Lemming@lemmy.world

L3s@lemmy.world

171

Remember kids, "temporary", "just poc", and similar claims are NEVER TRUE (lemmy.sdf.org)

submitted 13 hours ago by lousyd@lemmy.sdf.org to c/sysadmin@lemmy.world

26 comments fedilink hide all child comments

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.

you are viewing a single comment's thread
view the rest of the comments

[–] hactar42@lemmy.ml 4 points 10 hours ago (1 children)

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.

[–] TheBat@lemmy.world 1 points 3 hours ago

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.