News for hackers. Stuff that matters.
Re:New Zealand's $16B health dept managed finances with sing... by rco8786 on Tuesday March 11, 2025 @06:50AM (#43331155)
Yea exactly my take. This seems like exactly what Excel is good at doing.
Re:New Zealand's $16B health dept managed finances with sing... by nisegami on Tuesday March 11, 2025 @08:06AM (#43331617)
Excel isn't 'good' at anything. It is passable at a great many things.
Re:New Zealand's $16B health dept managed finances with sing... by potato3732842 on Tuesday March 11, 2025 @08:19AM (#43331709)
Quantity has a quality all its own.
Re:New Zealand's $16B health dept managed finances with sing... by whymeogod on Tuesday March 11, 2025 @11:23AM (#43333373)
Sounds like a certain LLM I've read about
Re:New Zealand's $16B health dept managed finances with sing... by TMWNN on Tuesday March 11, 2025 @06:52PM (#43337974)
It really does.

Just the massive, massive ecosystem of online tutorials and answers and YouTube videos for every conceivable question [1] is incomparable.

[1] Except the one you want the answer to at a given moment, amirite fellas?

Re:New Zealand's $16B health dept managed finances with sing... by Suppafly on Wednesday March 12, 2025 @12:59AM (#43340083)
>[1] Except the one you want the answer to at a given moment, amirite fellas?

Everytime I relearn how to do a vlookup, none of the examples online do what I want. It's like they are trying to do something completely opposite of what I want. It's super weird, because what I want to do is always a pretty common thing to need done.

Re:New Zealand's $16B health dept managed finances with sing... by jaffa2 on Wednesday March 12, 2025 @09:40PM (#43349574)
Never use vlookup . Always use match/index.
Re:New Zealand's $16B health dept managed finances with sing... by Suppafly on Wednesday March 12, 2025 @10:30PM (#43349845)
>Always use match/index.

I'm not sure how that'd help in any of the cases where I use vlookup.

Re:New Zealand's $16B health dept managed finances with sing... by sc68cal on Tuesday March 11, 2025 @09:30AM (#43332258)
You are mistaking "being commonly used for this task" with "good at doing"
Re:New Zealand's $16B health dept managed finances with sing... by tempaway64457 on Tuesday March 11, 2025 @09:56AM (#43332511)
Replacing this excel sheet with a 'proper' system would cost between $5million and $20million probably, depending on what sort of consultancy delivered it
Re:New Zealand's $16B health dept managed finances with sing... by datadrivenangel on Tuesday March 11, 2025 @11:12AM (#43333277)
And would be inflexible, and maybe still wrong, and not necessarily more transparent... So it may mean several extra million dollars per year in ongoing maintenance if things turn out typically...

Excel has many issues, but the cost of replacing it is surprisingly high.

Re:New Zealand's $16B health dept managed finances with sing... by TMWNN on Tuesday March 11, 2025 @06:49PM (#43337957)
>And would be inflexible, and maybe still wrong, and not necessarily more transparent...

I'm going through this right now. Not anywhere in this scale, but just in terms of deciding whether to move an order-tracking/accounting system I've built in Excel to a "real" database.

The database I am considering (Panorama X for Mac) is quite inexpensive, I've heard very good things about it, and has a spreadsheet-like UI. However, I've used Excel enough to know that I haven't tapped more than a small fraction of its ability, especially things like Power Query. As much as I loathe VBA, what if the cost of moving to a "real" database isn't the up-front cost, but the longer-term inflexibility of Panorama (and, pretty much, anything else in my price range) compared to the beast that is Excel?

Re:New Zealand's $16B health dept managed finances with sing... by tokyovigilante on Tuesday March 11, 2025 @03:36PM (#43336213)
Probably why the consultancy who produced the report referenced here was delighted to point it out.
Re:New Zealand's $16B health dept managed finances with sing... by Retric on Tuesday March 11, 2025 @10:51AM (#43333017)
Anything commonly used for a task it’s good enough for that task even if “much better” options exist.

Nail guns have a lot of downsides vs using screws, but being much faster and cheap offsets quite a lot.

Re:New Zealand's $16B health dept managed finances with sing... by craigmcnamara on Tuesday March 11, 2025 @01:01PM (#43334595)
Just bad enough