$16bn health agency managed finances with Excel spreadsheet.
-
You can copy and paste values to another workbook and sort but it'll kill almost all the useful information. We've got these massive docs that reference numerous tabs and populate parent+children lines. It's an absolute mess and takes 6 months of training, I look at it as job security lol
Surely it would be cheaper to hire a dev for 6 months to put it into a proper database.
-
To be fair I think Excel is faster to get a novice up to speed than teaching them to program
Source: Manage SQL database infrastructure for a living
Surely its not any harder than teaching them basic SQL.
-
Surely its not any harder than teaching them basic SQL.
I guess it depends on what you define as "basic SQL". Because most people are already used to working with desktop apps, and familiar with the office programs specifically.
You'd essentially have to teach them programming. Its like when people say "terminal is better than GUI" (it's me, I say that) but then you forget about all of the people who don't know the difference between a desktop and a modem
-
It's because you're supposed to customize them, not use as-is. We've had a lot of happy customers. Some send us gifts! But for the first year or maybe even couple of years, you probably pay more to your partner for implementation, customizations and advice than to the ERP developer for licensing.
ERPs aren't for every company, different ERPs work best for different companies and different partners themselves have their own specializations. The one I work through (used to work for, but now I have my own company and just contract for them), does small to medium sized production companies. Think 5-200 employees usually. The ERP we work with is meant to cover every imaginable use case - which is why it doesn't have enough depth. We add a bunch of stuff that isn't there OOTB, sometimes remove things in default modules, etc.
But first you NEED an ERP partner to make the most of it. At ours the CEO is also the biggest salesman. He's not afraid to tell you if he doesn't think it's a good fit. A bad partner will still try to sell you and that's going to end up in disappointment for everyone.
It sounds like JDE. My company uses it, but they don't even use all of the built in features. They do a bunch of stuff manually that they could just do with the software they're paying for.
-
I guess it depends on what you define as "basic SQL". Because most people are already used to working with desktop apps, and familiar with the office programs specifically.
You'd essentially have to teach them programming. Its like when people say "terminal is better than GUI" (it's me, I say that) but then you forget about all of the people who don't know the difference between a desktop and a modem
It wouldn't be hard to teach them a graphical representation of SQL, something like Access I guess. Teach them concepts like joins and where clauses, and give them software that abstracts that a bit.
Then add some Excel-like features on top. Everything would end up being SQL at the end of the day, and sysadmins could then tune things to keep them fast (e.g. replicate DBs so poorly optimized queries don't hurt the whole org, esp. if a dept only needs read access).
-
It sounds like JDE. My company uses it, but they don't even use all of the built in features. They do a bunch of stuff manually that they could just do with the software they're paying for.
Odoo actually. You more or less can't use all the features, there's too many. That doesn't mean it's the best ERP, it just tries to be a true generalist, which means it needs lots of customizations usually.
-
Only those with no experience in corporate finance will find this surprising.
Excel is a powerful tool. The only ones who ridicule it are idiots who don't understand anything.
Excel is a fantastic tool. It is however not a database.
-
Only those with no experience in corporate finance will find this surprising.
Excel is a powerful tool. The only ones who ridicule it are idiots who don't understand anything.
Anything Turing-complete is a powerful tool, but the reason people are reacting negatively is because of how much of the wrong tool it is.
- Does an excel-based solution offer adequate runtime performance? No
- Does an excel-based solution offer adequate write concurrency? No
- Does an excel-based solution offer appropriate data durability guarantees? No
Basically the only saving grace of Excel-based solutions is that they are built in tools that finance workers comprehend, and that is quite simply not enough. To base systems at this scale on Excel is criminally negligent.
-
Only those with no experience in corporate finance will find this surprising.
Excel is a powerful tool. The only ones who ridicule it are idiots who don't understand anything.
It’s a powerful tool that you shouldn’t use as a book keeping tool and ledger for a company that manages $16B. And I’ve worked on a trading floor of a big energy company. Excel was only used within departments as a tool for the employees not as the entire companies financial administration.
-
Interesting, never thought about using python as an excel replacement. Definitely wouldn't work in my current work setting. But I just started taking a python class and I'll have to keep this in mind.
Once you get the basics of Python, you need to learn the Pandas library. Also, check out Jupyter notebooks right now, is going to make your life easier.
-
System shared this topic onSystem shared this topic on
