adepressedthrow

I'm stuck with several relatively new (2015, HD, run tvOS 16) Apple TVs that came from a government auction. They were used in a school, and were never removed from "Apple School Manager", their MDM system for schools. Apparently Apple can mark serials as part of a school or business's fleet, and upon setting up the device, it automatically is registered and pulls down the MDM profiles.

Only the school can remove them from the system, and although Apple's terms of service _require_ them to be in control of the device for it to be registered (i.e. not sold to a third party, me), I have been completely unable to convince the school to help me on the matter. Contacting Apple doesn't seem like much of an option either, as they don't even publicly post contact info for this kind of support.

You might want to play around with the encoding on your videos. On a Windows machine with a i7-8770k (and dedicated GPU) with Firefox latest, the page was spiking up to 100% GPU usage, causing the browsing experience to slow to a crawl. It may be related due to me having a Twitch stream up on a second display.

Probably a Firefox bug, but it's preventing me from looking at this landing page that every one else seems to like :P

I hadn't seen Amanda before. Bacularis looks like it might help with the complexity of setting up Backula. I might try that out.

It's hard to get the motivation to mess with these tools that have relatively little documentation/examples and are purely config file based.

I was able to purchase a LTO-7 library full of tapes a few years ago for basically nothing, and still haven't gotten around to using it. There seems to be very little in terms of free, automated software for managing the system and performing tasks such as backups. tar doesn't exactly cut it for hands-off usage.

The best I've found is using Veeam Backup & Replication, but it's Windows only and not great still.

This is a huge thing for me too. I got super burnt out because I care too much.

I hope you get better. I'm still struggling with it, a year after stopping work.

It's very useful information when you are never rested and constantly are trying to tweak variables to observe the impacts to your sleep. I've long since stopped relying on trackers, however, as nothing seemed to display any accuracy whatsoever. I manually record my perception of sleep every night.

This is commonly done at Lego conventions, though usually not too many people participate.

It seems that there are few options overall, but particularly few OSS options for doing offline storage and sync in native code (_without_ using JavaScript). The only thing I've encountered that really met those requirements (OSS, non-JS) was Couchbase, but it's really not a great experience, and requires complicated setup both for the binary and the server. Adding P2P or CRDT features is even more difficulty.

I'm very happy you found something that works for you. What method of ketamine treatment have you been taking? I just stopped after 2 months of troches, which didn't seem to bring significant, if any, benefit.

Interestingly, I found myself abnormally susceptible to the psychedelic effects. When taking ketamine orally, the expectation is that most of the medicine is absorbed while you hold the troch in your mouth for 30+ minutes. After a lot of experimentation, I found that I barely absorb any medicine through my mouth, but once I swallow it I absorb it very rapidly. This made it difficult to control the delivery speed, and likely hindered my treatment.

I haven't been dealing with depression for anywhere near as long as you, but I do speak from experience about how terrible it is to not find anything that works. I've gone through ~13 of the most commonly prescribed drugs for depression, anxiety, and sleep, and none brought any relief. I've now tried and failed out of ketamine, which I was really hopeful for. Now I'm just back to sitting around trying to get _any_ doctor to actually see me and maybe get tested for various neurodivergent conditions.

Surely that's what lots of non-developer white collar workers use Excel for? I imagine there's orders of magnitude more people using Excel for data processing rather than Python or R. I'm well aware it's not the best tool for the job, but yet people are using it for purposes such as that. I wanted to learn more about that experience.

What do you mean by this? What am I "recording" as the bottom of the data set?

My point was that it is very hard to have a dynamic number of rows feed a proportionate dynamic number of rows. Scripting makes it much simpler, but at least with Google Sheet's scripting, the API seemed pretty lacking for that processing (in the very least, it's very slow, since it's running as a very constrained shared resource).

That's exactly what I did. Now separate out some columns and perform some additional transformation on that FILTERed data. Can you do it without repeating yourself (duplicating the FILTER statement, or any of the other transformations you need to do, besides just filling down a column). Can you perform these transformations only on the row height of the data, and not have extra rows with broken formulas?

I honestly wouldn't even be surprised if the functionality to do the above does exist, but for all of my searching I couldn't find it.

Your aside is exactly why I wanted to use a spreadsheet. It's the only tool that has that market penetration for non-programmers, and I wanted to see what made it tick. It seems like that may have backfired by not using Excel, however.

Interesting. It definitely seems like that would fix a lot of my issues, which prompts the question of why Google hasn't built this functionality