• 1 Post
  • 79 Comments
Joined 1 year ago
cake
Cake day: July 2nd, 2023

help-circle








  • I’m not a programmer by trade but I learned some python and VBA to automate some of the things I do every day. Any time you’re doing some manual shit and think “there’s gotta be a better way” there probably is - just Google how to do that one thing and you’ll build up your knowledge over time.

    It’s up to you to decide if you tell your boss or not. I chose to and took on some extra duties along with extra pay so it worked out for me but it’s a small business with a high value on productivity.


  • Good God please use xlookup. We have some old school people that still use vlookup and refuse to convert their ranges to tables, it drives me crazy.

    I still use index/match for multiple lookup returns (or is it sumifs I can’t remember?) But I do a lot of work in BI and it’s much more intuitive for me in DAX/M.






  • I just spent my afternoon doing volume calculations… each unit is 3 oz, I need 300 units, 900 oz, but I can only buy in 1 gallon which is 128 oz, etc. For this one, each unit is 10g and 600 of those, I can buy in 1.25 lb or 2.6 lb let’s convert that and see what the cost per gram is and go with the cheaper, okay I can buy in 1180g how much do I need again?

    Repeat that 57 times and you too can have a job in supply chain.