$16bn health agency managed finances with Excel spreadsheet.
-
It's just one of 6,000 apps that New Zealand thinks might be best tamed with ERP
How does erotic role play help tame Excel?
I would also like to know more.
-
That depends on spending articles, not on sum amount. Maybe their accounting is as simple as: 10bn income, 2bn to steal, 3 for salaries, 1 for medicaments and machinery, rest for advertisements.
You don't need super-pooper software for that.
Yeah, it depends entirely on how many things you're tracking and how many people need to access it. It's probably not the right tool here, but sometimes it just is.
-
That depends on spending articles, not on sum amount. Maybe their accounting is as simple as: 10bn income, 2bn to steal, 3 for salaries, 1 for medicaments and machinery, rest for advertisements.
You don't need super-pooper software for that.
Even if their spending is that simple in terms of categories, it's almost certain their breakdown within each category is definitely quite a bit more complex. Hell, my wife runs her own therapy practice with just herself and she talks about how obnoxious dealing with insurance is for billing all the time.
-
Shift+F9.. annnnd, the data is gone
Not if there is a BACKUP folder with daily copies of all your spreadsheets.
Sifting through the backups is so much fun when you're trying to find when a particular issue started.
-
It's just one of 6,000 apps that New Zealand thinks might be best tamed with ERP
Honestly, that's fine. This may be a wild take, but they grew and their usage of excel obviously didn't hold them back, what's the issue?
-
Not if there is a BACKUP folder with daily copies of all your spreadsheets.
Sifting through the backups is so much fun when you're trying to find when a particular issue started.
Excel is indeed super powerful. I've seen firsthand what they power in multiple Fortune 500 companies, and usually for a lot of critical tasks. It doesn't surprise me in the least that this company was using it for finances.
-
It's not the worst option available, it might not be the cleanest solution, but it does offer a level of flexibility if you have an in-depth understanding of key operational (or financial) business processes.
This is why I specified "nearly" the worst. It can absolutely get the job done and has basically every tool you'd need to do the job, but it's pretty much the worst amongst the "this will do everything you need" options.
My thought process was abacus < pen & paper < text file < spreadsheet < database solutions
-
It's not the worst option available, it might not be the cleanest solution, but it does offer a level of flexibility if you have an in-depth understanding of key operational (or financial) business processes.
It's better than just text files or word I guess
-
It's just one of 6,000 apps that New Zealand thinks might be best tamed with ERP
How does erotic role play help tame Excel?
It let's your accounts blow off steam so they use excel better instead of filling the account ting sheets with dirty messages
-
It's just one of 6,000 apps that New Zealand thinks might be best tamed with ERP
How does erotic role play help tame Excel?
For a non-joke answer. ERP in this context means Enterprise Resource Planning. It basically allows you to do everything an enterprise requires with one software system instead of using several different ones.
-
This is why I specified "nearly" the worst. It can absolutely get the job done and has basically every tool you'd need to do the job, but it's pretty much the worst amongst the "this will do everything you need" options.
My thought process was abacus < pen & paper < text file < spreadsheet < database solutions
But a spreadsheet can function like a database.
-
It's just one of 6,000 apps that New Zealand thinks might be best tamed with ERP
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.
-
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.
In fairness to the register they also ridicule moving to a dedicatdd ERP in the same article.
You're r absolutely right there is nothing wrong with Excel. Its powerful software and ultimately it cones down to human and organisational processes about whether its being used to its best or not. You can also have the most expensive top end dedicated ERP in the world and still be a total mess. Similarly business used to run on pen and paper and could be highly efficient.
Software is just a tool, and organisation go wrong when they think it alone is the solution to their problems.
Also I doubt Health NZ overspend has anything whatsoever to do with excel. Instead it'll be due to rising demand, and inflationary pressures on public finances. We have the exact problems here in the UK with the NHS just scaled up to a £182bn.
-
For a non-joke answer. ERP in this context means Enterprise Resource Planning. It basically allows you to do everything an enterprise requires with one software system instead of using several different ones.
And they all suck ass
-
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 not... Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers ), limits in columns and records, ever changing formats across versions... You asking for a disaster to happen which happens very often
-
It's not... Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers ), limits in columns and records, ever changing formats across versions... You asking for a disaster to happen which happens very often
Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers )
You can literally label ranges to use them as variables in Excel formulae, not to mention Excel Tables has more operations and features than you'll ever need.
limits in columns and records
Unless you are working with an unfiltered, un-aggregated ledger dump straight out of your database (in which case you shouldn't be let anywhere near an office computer), it's rather hard to cross 1M+ rows and 16.4k columns in corporate finance.
ever changing formats across versions
The .xlsx format was introduced in 2007 (18 years ago) and hasn't changed since. Not to mention you can still use all kinds of plaintext formats whenever you want.
-
Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers )
You can literally label ranges to use them as variables in Excel formulae, not to mention Excel Tables has more operations and features than you'll ever need.
limits in columns and records
Unless you are working with an unfiltered, un-aggregated ledger dump straight out of your database (in which case you shouldn't be let anywhere near an office computer), it's rather hard to cross 1M+ rows and 16.4k columns in corporate finance.
ever changing formats across versions
The .xlsx format was introduced in 2007 (18 years ago) and hasn't changed since. Not to mention you can still use all kinds of plaintext formats whenever you want.
Anybody who used ANY library to process xslx knows MS keeps changing it
About ranges... can you give me the range for whole columns minus 6 first records and 9 last records? -
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 powerful tool.
You typoed 'popular'?
-
And they all suck ass
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.
-
Not if there is a BACKUP folder with daily copies of all your spreadsheets.
Sifting through the backups is so much fun when you're trying to find when a particular issue started.
My backup is ctrl+z
