|
That's not a spreadsheet - that needs a full on database ... 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
One of my cats once managed to rotate my laptop display 90 degrees. I had a heck of a time figuring out how to get it back to normal, because obviously, it's not very easy Googling it on a rotated screen...
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain
modified 4-Jan-21 5:12am.
|
|
|
|
|
On Ubuntu/Gnome, I use [ctr][alt][arrow keys] all the time to navigate multi desktops.
On a Windows box with Intel graphics drivers, ...
(Someone here got most upset at me a couple of years ago because he turned his screen on its ear and didn't know the shortcut to get it back. Spent ages messing around in control panel... with a crick in his neck.)
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Software guys-- hmmph!
So rotate the screen until you get it fixed. ( You DO have a spare keyboard for the laptop? )
|
|
|
|
|
It wasn't me that had an issue. Along similar lines, have you ever used a mouse on a rotated screen? Even more fun in a multi-monitor setup. Move the pointer out the left side of one screen and it enters another from below.
Back in the days of CRT monitors, and before that, TVs, we used to routinely have a mirror on the workbench to see the screen while we were probing around in the back. One of the wags in the shop took an old ball mouse, crosswired the X axis encoder so it behaved mirror image. Great on the repair bench, and a wonderful toy for practical jokers in the office areas.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Not with the screen rotated _for long_, but using the mouse on my thigh or in very cramped quarters or when the mouse is sideways gets fun. I work where I can in plant, often limited work surface, and I don't get along with touchpads. They tend to respond to proximity. The stick on the Thinkpad worked, the Dells not quite. So a mouse.
|
|
|
|
|
I use cordless mice (Logitech M187, nice and small) on any available surface.
Years ago I had a Thinkpad with the stick, worked OK. A later hp with a sttck I never got along with.
I'm coming to use touchpads a bit more. Two finger scrolling is kinda neat, but 'tap to click' still irks.
Maybe it's because I'm now using touchscreens and learning a bit of subtlety in my fingertips.
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
This very morning, I was using my laptop balanced on my lap. A far-distant relative I'd never heard of had contacted me via Facebook messenger (eeuugggh) and I was composing a reply. My wife came in and handed me a coffee in my right hand, and a mince pie in the left (Wrong way around). The cat has a voracious appetite for anything it can fit in its mouth. So it's on the sofa to my left, walking onto my keyboard, desperate to reach the mince pie. I can't put the coffee down, as the shelf is behind my right shoulder, and the cat's (mainly) on the left. I can't put the mince pie down, coz the cat would get it in a nanosecond and consume it, and mince pies are really bad for cats. I'm trying to keep still to avoid spilling the coffee on (a) the keyboard and (b) the sofa throw, since the other cat was sick on it a few days ago and it's only gone back on this morning after the wash. My left hand (with the pie) is now away to my right, to try and keep it away from the cat who is climbing across the keyboard and up my arm.
In the meantime, amongst much shouting, the cat somehow manages to mangle together some sort of response to this person who's never met me but has invaluable genealogical info, send the message, AND delete the contact. He's also managed to bring up a "Send feedback to Google" form from Chrome (that I've never ever seen before) and has composed a message "whuieqprehj" which sums up my feelings quite succinctly.
Fortunately at that moment my wife, responding to the screams, comes back and relieves me of the coffee.
Fortunately, my new contact has a unique name and was quickly found on Facebook again; apology sent, relationship reset. But will either of us ever forget??
|
|
|
|
|
That should give you paws for thought.
I'm not sure how many cookies it makes to be happy, but so far it's not 27.
JaxCoder.com
|
|
|
|
|
you know I seriously always wondered how to select the entire row.
Tell the cat thanks from me. My dog will not appreciate that though.
To err is human to really elephant it up you need a computer
|
|
|
|
|
rnbergren wrote: you know I seriously always wondered how to select the entire row.
I just click in the far left column (to the left of A), usually row numbers - and it selects the entire row(s). At least for what I usually want to do, such as cut, paste, format. Complimentary actions for column(s)
I just tested (in Libre) and copy/paste works as well.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
I guess I should have specified that I meant selecting an entire row using only the keyboard. 
To err is human to really elephant it up you need a computer
|
|
|
|
|
Ah well, maybe cats are simply aliens in disguise. 
As the old saying goes: dogs have a master, cats have personnel.
What a perfect strategy: you get to observe humans and their behaviour, usually get some nice food on the go and none of those you observe is any the wiser.
It is probably more likely than most conspiracy theories. 
|
|
|
|
|
OriginalGriff wrote: what the heck is he using a spreadsheet for?
If they're a mechanical, chemical, or electrical engineer where I work: ![Elephant | [mastadon]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/elephant.gif) ing EVERYTHING.
I have received specifications from these yahoos running well over 100 printed pages that were Excel spreadsheets. I've received screen captures (taken with a phone, naturally) embedded as the sole data in a sheet. I've received Outlook emails with Excel attachments that contain Outlook email messages. 
Software Zen: delete this;
|
|
|
|
|
If you tell them it has a spell check, they can write letters in it as well!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
They actually have to work to do this. Oh my goodness.
And like Griff says. Tell them it has spell check.
To err is human to really elephant it up you need a computer
|
|
|
|
|
It doesn't matter if it has spell check, they don't fix spelling anyway. Using the backspace key means admitting they were wrong, and they never, ever, ing do that.
Software Zen: delete this;
|
|
|
|
|
OriginalGriff wrote: Just where do cats learn this stuff? And what the heck is he using a spreadsheet for?
To take on the world ![^]
|
|
|
|
|
Ctrl+A is faster though, for the last one. The first two are useful indeed.
|
|
|
|
|
but ctrl-A select everything, ctrl-shift-space will select the current table/ pivot table. I use this a lot!
|
|
|
|
|
You all know those cats will eat you if they get the chance
|
|
|
|
|
My cat, Bear, uses the computer for an entirely different purpose. He loves a bit of Death Metal: here he is checking out some Obituary[^].
|
|
|
|
|
Edit: To be clear, the reason this stuff below makes me happy is not because I want to be the best at something, but because one of the goals of my project was to rely mostly on cross platform features and downgrade gracefully. The only platform specific magic i use is mem mapped files, for which my code supports windows and linux currently. I set out to prove that you could largely rely on the stdlib and just design algorithmically better ways to process JSON and I feel I did that. I also think that given the portability and memory usage of my library, it pays for itself even in areas where it slightly underperforms simdjson in raw speed. certain cases - many in fact - will see simdjson slay my library, particulary with random access, which mine can't even do, but for the scenario i designed it for, i designed it to be competitive with fast offerings and it exceeded my expectations so far. I need more benchmarking though
I'm looking at possibly integrating my JSON(C++) bulk loader with simdjson. I've been talking with some of the contributors, but we've been running into a wall because of their reliance on upfront indexing of the entire document.
I just ran my first benchmark of the two performing the same operation - retrieving the name field off of a 20MB json object.
simdjson took 46.231 ms to find Burn Notice
JSON(C++) took 0.055 ms to find Burn Notice
The reason mine is so much faster in this case is I don't index anything. That's a linear search.
I need to run a full suite of benchmarks but the above doesn't surprise me. Simdjson will outperform my library if you need most of the data in the document. If you don't, then mine may win out.
simdjson claims to be the fastest json processor in the world.
the above wobbles that claim, even if it's not exactly a real world benchmark
Simdjson runs on 64bit only.
Mine runs on 8bit all the way up to 64 (and beyond)
Mine is a lot smaller too.
I'm not usually competitive and I didn't design this to beat simdjson, but it's nevertheless satisfying that i'm getting results like this.
Edit: The more benchmarks i create, the happier I get.
Benchmark presently, extracting 20000 episodes from the document.
JSONPath equiv would be $..episodes[*].season_number,episode_number,name
i had to use a different path for simdjson because i couldn't figure out how to use a different search axis:
JSONPath for simdjson was $.seasons[*].episodes[*].season_number,episode_number,name
simdjson took 49.669 ms to extract episode data
JSON(C++) took 55.921 ms to extract episode data
That's the second benchmark, which i'm actually thrilled by. The first one just gets the "status" field off the root object - it's toward the end of the document:
simdjson took 45.685 ms to find Canceled
JSON(C++) took 30.12 ms to find Canceled
Each time I'm closing and reopening and doing a fresh read. The reason being is that my stuff was designed for forward only bulk loading - you get everything you need in a single pass. period. it just wasn't designed to work otherwise. so i wanted to compare apples to apples.
simdjson took over 100MB of RAM to get those numbers, and generally requires 4-5x the amount of RAM as the document size on disk.
Mine did it with under 1kB not counting platform specific incidentals like the mapped vmem page(s) i'm using.
Real programmers use butterflies
modified 3-Jan-21 22:55pm.
|
|
|
|
|
It appears to me that simdjson and JSON(C++) are optimized for different use cases - speed vs memory usage. It does not surprise me that optimizing for memory usage can also help the speed, especially when taking cache effects into account...
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
They absolutely are optimized for different use cases, which is one of the reasons for the integration discussions i'm having with some of the simdjson contributors.
Real programmers use butterflies
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
