Follow Slashdot stories on Twitter

 



Forgot your password?
typodupeerror

Comment Re:Google? wtf (Score 1) 86

It's easy to have unique keys in your spreadsheet so that you can easily relate information on different sheets to one another. The problem is, actually doing the processing that a SQL server would do trivially is irritating, and then it will be processed slowly every time. Whatever Excel does or doesn't cache, it isn't enough. You can do big complicated things, but they work slowly, and maintaining it is irritating at best. When you do complicated things either your formulas get long, or you wind up having to write code, or in fact often it's both. At that point you're way better off IMO doing it in something else so that at least performance is good when you're done, and you never have to screw with editing a long formula.

Comment Re:Google? wtf (Score 1) 86

But, is 2e7 cells really that many? If I spent 5 minutes brainstorming I could probably think of 20 pieces of metadata you'd want in columns of a spreadsheet tracking financial transactions

That's exactly why it should be in a database and not a spreadsheet. Spreadsheets are best when you have a reasonably limited number of columns. It's also a horrible PITA to use them as a relational database (it's more or less possible, but you don't want to do it) so hiding pieces of that complexity in other sheets in order to limit the data the user interfaces with on the main sheet is just a lot of extra work you wouldn't have to do if you used another solution.

I'm mostly surprised that Google Sheets chokes on what feels like a fairly small amount of data. My best guess is that it's some insane formulas that it struggles with more than the number of cells.

It doesn't really matter where it fails, if Excel can do it and Sheets can't then Google has to admit inferiority to Microsoft which is never a good look.

Comment Re:Those who cannot remember history (Score 1) 198

When in the last two centuries have the French, or the British, or the Germans, or the Belgians, or the Italians moved in a way to unify that continent to stand up to this kind of genocide?

Biden went around congress to fund a different genocide. Pretty words, but living up to them is another matter.

Comment Re:Well, if you own it. (Score 2) 34

Yes, it is basically Netherlands office going rogue.

If it were a Chinese office with a Netherlands owning company, you can be sure the /. headline would be "Chinese Office Going Rogue Against Netherlands Owning Company".

By calling it "Civil War" the headline is misleading people into thinking both sides were on equal footing.

Comment Re:This is why we use "agents" instead of "LLM's" (Score 4, Insightful) 106

The ChatGPT (or any AI product) people actually use is more than just an LLM. People get wound up over the inherent limitations of LLM's as if that's some brick wall preventing these things from ever becoming useful.

It's ludicrously simple to program a chatbot script to return the time instead of diving into the LLM if the user asks for the time. Same with mathematical operations - yes, LLM's sometimes get basic math wrong because that's not what they're designed for. But again, super simple to channel math requests to an engine that's built for that.

If they haven't fixed a particular shortcoming yet it's because they're seeking more complete solutions than picking off one tiny complaint at a time. But these are trivial to fix and smarmy posts like this will not age well.

The whole problem with this approach is a) we don’t have all the systems we need individually at a level of capability that meets the current level of hype and b) we don’t have a capable enough system management AI architecture, just using some weighted tokens is horribly deficient.

Comment Re:Really? (Score 5, Insightful) 106

automated image pattern matching has been around for decades

The problem is that the LLM only does one trick. When you start integrating other software with it, the other software's input has to be fed in the same way as your other tokens. As the last paragraph of TFS says, "every clock check consumes space in the model's context window" and that's because it's just more data being fed in. But the model doesn't actually ever know what time it is, even for a second; the current time is just mixed into the stew and cooked with everything else. It doesn't have a concept of the current time because it doesn't have a concept of anything.

You could have a traditional system interpreting the time, and checking the LLM's output to determine whether what it said made sense. But now that system has to be complicated enough to determine that, and since the LLM is capable of so much complexity of output it can never really be reliable either. You can check the LLM with another LLM, and that's better than not checking its output at all, but the output checking is subject to the same kinds of failures as the initial processing.

So yeah, we can do that, but it won't eliminate the [class of] problem.

Comment Re:Big, BIG companies should know better (Score 1) 86

(Shuffles off and mutters something about how does a greybeard get Vulture Capitalist funding to setup cross continental niche cloud for people that value stability over shiny, with Open Source ... Open Stack ... Cloudified LibreOffice, Ceph, my lawn)

Every tech company needs at least three things to start with: The business guy, the brain, and the lawyer. Ideally there should also be a marketing guy, but you can add them in later. Also, none of them have to be male, I just like saying "guy", buddy.

Comment Re:Excel is a platform. (Score 1) 86

Untrained? Excel is a spreadsheet tool within the MS Office suite with 27,000 features. It requires a tad more training than handing a moron a hammer

Yes and no, depending. If you are building an application in Excel, yes, all you said is true. If you are using one, no, none of it is. Spreadsheets can be set up such that the user just stuffs data into them where they are supposed to, then clicks a button to get results. Or maybe they don't even have to hit a button.

For the simplest useful example I can think of, I put together a spreadsheet which produces a table we use for asset valuation. This spreadsheet changes every year. If you load my spreadsheet, it will be correct for the current year. No user has to think about that at all, they just load it and get a correct table. You can extrapolate this to basically any level of complexity because Excel has VBA and you can script everything. The user just follows instructions, and they aren't even allowed to edit any cells which could break anything.

Comment Re: Alibaba (Score 1) 32

In case anyone is going this far down the hole, it turned out great. Even though the item was shipped from the US, because the seller didn't respond I got a refund without having to return it.

So far Aliexpress has been responsive to 100% of my issues and I only have needed to be a little patient and not expect everything to be solved immediately or arrive immediately.

Comment Re:Google? wtf (Score 4, Interesting) 86

20 million cells? That seems ridiculous. Why aren't they using a database for something that huge?

I agree that a database-backed application is the right way to go for that much data. However, Finance used Excel because they could. We all like to talk about how bad an idea it is to do that, but Excel brought financial computations on large data sets to people who can't write any code. It has enabled thousands upon thousands of businesses to do things they couldn't do before without paying a programmer to develop a solution they cannot maintain. The fact that other spreadsheets regularly crater when handed data that Excel has no trouble with is exactly why we have so much Excel.

I like to use Drupal to rapidly create database applications which can handle a lot of data without writing code. But I wouldn't expect someone in accounting to be able to do that at all, and that just shifts the problem domain. Instead of getting stuck with Excel, now I'm getting stuck with Drupal. All of the logic just winds up in a different system that you can't trivially transfer it out of, so you have the same exact maintainability problem, except more people know how to work with Excel.

Comment Re: The AI bubble (Score 1) 68

We know what will happen in a world where there is no need for human labour. The 'elite' will build Terminators to eliminate most of the humans.

I doubt it. The elites have capital to invest in the means of production. Absent this they have no real power or purpose.

When you no longer need to pay countless thousands of people to perform a task this is a double edged sword. It not only means you can make do with less it means anyone else can step in and accomplish the same tasks without you.

Comment Re:OpenAI (Score 1) 115

"Blaming internet or some chatbot" makes perfect sense when the chatbot was programmed to manipulate people and it manipulated a 16 year old to commit suicide.

Chatbots are trained not programmed. If you have evidence OpenAI's chatbot was explicitly trained to manipulate people then FFS please don't keep it to yourself.

Slashdot Top Deals

If what they've been doing hasn't solved the problem, tell them to do something else. -- Gerald Weinberg, "The Secrets of Consulting"

Working...