How can you distinguish the the alpha cells from the numeric cells?
If you can fit that distinction in an “if” condition I would start by making an adjacent column along the lines of “if left cell is alpha then left cell else above cell”. Then you’ll have what you need except you’ll have some rows of AA BB etc. You could then either delete those rows (but only after copying and pasting values — not formulas) or better yet make a pivot table.
Also: this website shows up in my search results a lot. I know it’s not a Lemmy community, but maybe we should make a spreadsheets community if there isn’t one already!
Yeah, there are plenty of ways of doing that, but I was assuming OP’s sheet had other types of cells and that the A’s and 123s were a minimal working example.
I’ve been looking for a digital copy of Kronecker Wallis’ text, “Euclid’s Elements”, on the major sites (AA, ZL, LG, VK, IRC, Scribd, Mobilism, rutracker, Ocean of PDF, etc.) but they’ve all come up empty....
Started in mid November and despite repeated requests from Tuta(nota) and reassurances from MS, it’s still happening and MS have gone silent on the subject.
My favourite “lesson” I ever gave was in a grade 9 technology class. It was a pretty small class, about 10 kids. I split them up into two teams and made a competition. They chose their own teams — it ended up being boys vs girls. I never would have made it that way on my own but that’s how it worked out.
The school had a bunch of old, decommissioned PCs that were headed to the junk yard. I sorted through all of them to get two exact sets of working parts for the competition.
The goal of the competition was to recover a jpeg from one of the hard drives. Each team had a computer with the ram removed and two hard drives. One was blank and the other had the jpeg on it. They also had a Linux Mint installer on a usb stick.
I don’t remember exactly how I had set it up but it was points based, something about getting to different stages first. Like 5 points to be the team that turns the computer on first. One of the big ones was that they got an extra 10 points if they did the whole thing without a mouse.
I told the other classes about the competition and asked some other teachers if it would be okay for them to watch and cheer on. It ended up being the nerdiest and most exciting class ever. Students were literally cheering each team through a Linux install. One team got stuck and had to pull out the mouse. There was booing. It was so epic.
The girls won, being the first to recover the jpeg and they did it all without a mouse. It was so awesome. The jpeg was the meme about how would a dog wear pants.
It was about 5 years ago, my first year teaching. I really miss those days. I only teach math now, and while I like that, there was something magical about showing kids how fun computers can be.
If I recall correctly I didn’t tell them much about anything. One of them had a nerd dad who set up his daughter with Linux at home but she wasn’t familiar with the install process. I gave them some basic info when I gave them the rules (you have to connect the hard drives and ram) but for the most part everything was new to them.
On the other hand, I also ran a computer club with some other kids (in a younger grade) where we took that pile of broken computers and salvaged working parts. We ended up with 3 or 4 working pcs that we ran Linux mint on. They used the computers for Roblox or something at lunch lol. The computers ended up being a popular attraction at lunch!
Yeah I had formatted and partitioned the disk ahead of time. The JPEG was in the root directory IIRC. I warned them to not plug in both hard drives during the install process to be sure not to overwrite the wrong drive. They were labelled physically but were otherwise identical.
I have an account on an SMTP server. The server has a storage quota. I’d like the delete stuff from the server but keep it locally in case I need it. Just in case....
If they want it so much why don’t they pay him? Sounds like if it weren’t for him (and the others he seems to allude to) we wouldn’t have this opportunity.
Recently learned about this stuff on a Lemmy World post and I thought I’d move the conversation here since they’ve been fussy about DB0 in the past....
The *arr services are fantastic for helping you organize your content as you download them. They won’t find anything that you wouldn’t be able to find yourself, though. You feed it your indexers via Jackett or Prowlarr for torrents, or NewzNab (or equivalent) for Usenet. What shows up on my Sonarr searches is likely very different than somebody else’s since we likely have different indexers.
If you are looking for content that is hard to find I would recommend getting into Usenet or joining a private tracker.
If you want to get into building a large library and hosting your it on a Plex/Jellyfin/Emby server, I would recommend getting into Sonarr and Radarr, and then learning about the other *arrs.
This works best when your services are all running through a browser. You can set up most torrent clients to only work through a vpn. The rest of your traffic should be fine unless you don’t want your ISP to know that you’ve visited torrent sites.
I don’t think you’ll find many providers that offer free trials, although I stand to be corrected. But some will accept crypto so if you don’t want to give your credit card details you could try that.
I’m looking to go into Usenet / premiumize / real Debrid but I don’t know which ones are reputable. Which ones have you all had luck with or liked? And what was the cost?
For me it was several days before an episode released on streaming services due to a leak. But in general I’ve got every episode of every show I watch downloaded, unpacked, renamed, moved into my library, and ready to watch in Jellyfin within an hour after it’s aired. I’ve never sat down with a timer, but I reckon sometimes the whole process is much less than an hour.
In my case the slowest process is the unpacking, but only because I’ve allotted two of my 10 cores for it. My server does a lot of other things and I don’t need slowdowns every time a new episode airs.
Linux laptop recommendation thread🐧💻 (lemmy.world)
I’m on the market to buy a new laptop, and Lemmy has successfully coaxed and goaded me to give Linux a serious try....
which software would i use on linux to capture video from disney plus for personal use?
Title…
Where can I post questions on how do construct formulas in Onlyoffice/Libreoffice spreadsheets?
Short term: I’m trying to automate transcribing a list from:...
What is an obscure piece of media or videogame that you think nobody else here has heard of? (kbin.social)
It could even be a youtube video or movie that you don't think anyone reading this has heard of besides you.
Finding Obscure Books and Newer Editions
I’ve been looking for a digital copy of Kronecker Wallis’ text, “Euclid’s Elements”, on the major sites (AA, ZL, LG, VK, IRC, Scribd, Mobilism, rutracker, Ocean of PDF, etc.) but they’ve all come up empty....
MS Outlook Blocking Tutanota Emails As Spam (tuta.com)
Started in mid November and despite repeated requests from Tuta(nota) and reassurances from MS, it’s still happening and MS have gone silent on the subject.
Any experience with teaching kids Linux?
Any one here has any experience with teaching 8 to 12 years old kids Linux?
How to keep all email locally in a useful format that can be searched across devices?
I have an account on an SMTP server. The server has a storage quota. I’d like the delete stuff from the server but keep it locally in case I need it. Just in case....
The world's 280 million electric bikes and mopeds are cutting demand for oil far more than electric cars (theconversation.com)
Calibre 7.0 E-Book Manager Introduces New Notes Feature, Support for Audio EPUBs (9to5linux.com)
Lost Doctor Who episodes found – but owner is reluctant to hand them to BBC (www.theguardian.com)
cross-posted from: feddit.uk/post/4478496...
deleted_by_author
Library Genesis in Numbers: Mapping the Underground Flow of Knowledge (direct.mit.edu)
How do Sonarr / related services work?
Recently learned about this stuff on a Lemmy World post and I thought I’d move the conversation here since they’ve been fussy about DB0 in the past....
Usenet
So, i want to give a try to usenet world....
Usenet communities?
I’m looking to go into Usenet / premiumize / real Debrid but I don’t know which ones are reputable. Which ones have you all had luck with or liked? And what was the cost?