Any Excel Experts Around Here?
- Thread starter Gameface
- Start date
LogGrad98
Well-Known Member
Contributor
20-21 Award Winner
2022 Award Winner
2023 Award Winner
2024 Award Winner
If you need help with either excel or access I could help with both and I have some time on my hands. I have taught classes on excel and access as well as visual basic. I could probably get it done. PM if you still need help.
Sounds to me excel is the wrong program.
I'all duck out because I don't mess with Access or VB.
I figured as much and was obviously joking. What has me scratching my head is most companies your size that I deal with and even municipalities have reliable PM databases based on a work order system. Why are you building an excel database instead?
We have a program for our PMs, it's MP2. But it is a very old version and it has not been set up well. It works for PMs and I've been told it could be used for our shift notes but it isn't. Our shift notes are supposed to document any adjustments or repairs we perform during our shift. But it's more of a justify yourself thing.
It's currently done on an excel spreadsheet with a template that we just copy from a master and create a whole new file every shift. So to search it you have to open each file, three per day, and scan through to see if the production line you are looking for is mentioned and then read the entry to see if it is related to whatever problem you're working on.
I haven't been tasked with fixing this, I just want to for my own sanity.
LogGrad98
Well-Known Member
Contributor
20-21 Award Winner
2022 Award Winner
2023 Award Winner
2024 Award Winner
This kind of **** happens way more than you think. I was creating the same types of things for eBay for hells sake. You'd think they could program something.
Joe Bagadonuts
Well-Known Member
Yep. I created a very complex excel program that included macros, automatic multi-user integration, etc., that was used by a large apartment company to manage inventory for over a decade, and I created another one that was used by a multinational supplement company for at least five years. In both cases I was told they just needed a temporary bandaid until they got a proper database built, but in both cases they turned their attention to other projects once a workable system was in place.
I'm not. I see a whole lot of the tracking side being compiled into excel spreadsheets. I actually prefer it for many applications in the "if it isn't broke don't fix it" vein. Excel's simplicity does a great job for certain projects. I've seen a ton of money dumped down the tube needlessly in attempts to develop tracking software that is not needed.