Follow Slashdot blog updates by subscribing to our blog RSS feed

 



Forgot your password?
typodupeerror

Comment Re:Google? wtf (Score 0) 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.

User Journal

Journal Journal: Audio processing and implications

Just as a thought experiment, I wondered just how sophisticated a sound engineering system someone like Delia Derbyshire could have had in 1964, and so set out to design one using nothing but the materials, components, and knowledge available at the time. In terms of sound quality, you could have matched anything produced in the early-to-mid 1980s. In terms of processing sophistication, you could have matched anything produced in the early 2000s. (What I came up with would take a large comple

Comment Re:Don't blame the pilot prematurely (Score 2, Insightful) 30

It's far from indisputable. Indeed, it's hotly disputed within the aviation industry. That does NOT mean that it was a short-circuit (although that is a theory that is under investigation), it merely means that "indisputable" is not the correct term to use here. You can argue probabilities or reasonableness, but you CANNOT argue "indisputable" when specialists in the field in question say that it is, in fact, disputed.

If you were to argue that the most probable cause was manual, then I think I could accept that. If you were to argue that Occam's Razor required that this be considered H0 and therefore a theory that must be falsified before others are considered, I'd not be quite so comfortable but would accept that you've got to have some sort of rigorous methodology and that's probably the sensible one.

But "indisputable"? No, we are not at that stage yet. We might reach that stage, but we're not there yet.

Comment Re:Those who cannot remember history (Score 0) 199

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:Really? (Score 4, Insightful) 107

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: Alibaba (Score 1) 32

Well, I'm about to find out if I need to do my first chargeback, I have a delayed response on a return authorization for where I was sent the wrong item. They advertised a different version. This might be confusing for them since the difference is small - yet critical. But there really should be no confusion because they advertised the other version both in the images and the product name/listing title.

Comment Re:It's (Score 1) 76

Looks good, but I can't find the app in my TV's store so it's a complete non-starter.

I got a Google TV because I knew it would have the best app support. Looks like you didn't.

My desktop TV-used-as-Monitor has stupid LG WebOS, but I also don't need a TV-specific app since my desktop is connected to it and I don't connect the TV to the network, only HDMI.

Slashdot Top Deals

There is nothing so easy but that it becomes difficult when you do it reluctantly. -- Publius Terentius Afer (Terence)

Working...