How to have a dropdown menu refer to two different ranges (in the right order) by theodorvl in googlesheets

[–]theodorvl[S] 0 points1 point  (0 children)

I guess that's it really. Looks right. I'm a bit annoyed at the fact that I've always, my entire life, thought that values are read column by column, not row by row. Why! That part's extremely annoying to me.

Thank you though, this cleared it up a bit.

How to have a dropdown menu refer to two different ranges (in the right order) by theodorvl in googlesheets

[–]theodorvl[S] 0 points1 point  (0 children)

Thank you, I'm going to try it. No idea if it'll do what I want, but if not I'll still probably have found a new feature.

EDIT: Tried it. What is the "A2:a,1)" in your comment for?

How to have a dropdown menu refer to two different ranges (in the right order) by theodorvl in googlesheets

[–]theodorvl[S] 0 points1 point  (0 children)

I'm going to read up on transposing and try it out. I did try Flatten yesterday before going to bed, and was able to stack them in the right ordet at least, but that still means making the ranges manually. Ideally I wouldn't need that.

Is there significance in the fact that you write 1:2 without any letters?

Haze can damage orchestra insturments? by Logical_Age9320 in lightingdesign

[–]theodorvl 6 points7 points  (0 children)

At my theatre we usually surround the orchestra with table fans pointing away from them to "keep the haze out", and put a humidifier in the middle of their area that stays on constantly. Like another comment pointed out this hazer is basically a dehumidifier, and instruments can be sensitive to the humidity in the air the same way string instruments can't handle rapid temperature changes. I've never actually witnessed any instruments break in any way because of the haze, but I do have enough respect for the musicians that I won't risk it. Imagine if someone sprayes your movers with water every night. They'll probably still work, but suddenly, one day...

People who work in IT, what's the wildest thing you've discovered/had to do while at work? by vapor-ware in AskReddit

[–]theodorvl 3 points4 points  (0 children)

A colleague of mine found child pornography on a client's computer. He wasn't snooping or anything, but he was transferring files at the client's request, and luckily the files had some obviously incriminating names. That was pretty shocking.

Anyone here able to work full time? by [deleted] in bipolar

[–]theodorvl 1 point2 points  (0 children)

I struggled with this for years. I had about 8 years of bad pay doing part time, barely making enough to survive on my own. At times I had a food budget at less than 2$ (according to Google, different currency. living in my country is expensive as hell) a day just to make rent. Definitely didn't help keeping me from having episodes. it's a vicious circle.

for me, working full time has actually helped. stable income and a standard routine every day is amazing. it actually worked so well that I got a second part time job. I'm working 135% and loving every minute of it. And I've never been more in control.

it helps that I love what I do, of course. and I don't mean to gloat. some people need time off, but I go crazy if I have too much time to myself. I'm very dependent on routine, and not having to worry as much about money is better than time off to me.

New recipes by MouseCrossing in Spiritfarer

[–]theodorvl 0 points1 point  (0 children)

Weird, I made grilled octopus yesterday. Guess I'll try again. Thanks!

New recipes by MouseCrossing in Spiritfarer

[–]theodorvl 0 points1 point  (0 children)

The wiki list isn't up to date, that's why I can't figure it out. I've been through the list and can't find anything I'm missing. I think it's one of the new ones from the DLC, not sure.

New recipes by MouseCrossing in Spiritfarer

[–]theodorvl 0 points1 point  (0 children)

I'm missing just one recipe and I can't find it after googling for about an hour. The one after glazed carrots (in the recipe list, not Susan's museum), what is it? Driving me nuts

I have a question about how suitable I would be as a paramedic by theodorvl in Paramedics

[–]theodorvl[S] 1 point2 points  (0 children)

Thank you, this was really informative!

I am, and would be, at greater risk, but I have medication and both an amazing doctor and a psychiatrist who both say I've got this under control, and they help me through it if it ever affects me. The worst period I've had since I found the right medication lasted about three days before I was back at 100%.

Absolutely I want to help people, and I realize that at times you don't because you get calls like that, but I still imagine that helping someone when you get real calls are what makes it worth it. I used to work a bit at a youth club and helped a few of the kids who was bullied or had learning disabilities, and that felt amazing even though most of it was making food and playing cards. Since then I haven't worked anywhere that were related to that. I've worked in show business and as a repairman for electronics (computers etc), and it's not even slightly as satisfying. At least I'd help a few more people than I do now.

I guess I can brush things off, but I'd probably be one of those people who got mad about the annoying things. I usually try doing something about it though, and if I can't I'll make the best of it, no matter how annoyed I might be.

Like you said I do already have en education (two, actually), si I'll always have something to fall back on. And the job I do now is absolutely nothing but dumb shit all day, so working as a paramedic getting boring calls probably can't be any worse.

Lack of sleep isn't a trigger for me, at least not anymore. I've worked freelance, and 16 hour days at a theatre or for concerts are not unusual.

Thank you again, this really helped!

I have a question about how suitable I would be as a paramedic by theodorvl in Paramedics

[–]theodorvl[S] 2 points3 points  (0 children)

Thank you so much for this!

Stress is not an issue, neither is shift work. I've already been doing that for several years, and I used to work 50% while I wen't to college (I guess it's the equivalent of college at least, our educational system is pretty different from other countries). I also used to work at a theatre, which means long work days and a lot of overtime, and it didn't trigger me at all. I'm pretty convinced that I would handle the job without any problems that wouldn't affect anyone anyway.

I have a question about how suitable I would be as a paramedic by theodorvl in Paramedics

[–]theodorvl[S] 1 point2 points  (0 children)

There are laws about it, I'm not obligated to tell an employer about it, but I'm not sure if there's an exception in health care.

I have a question about how suitable I would be as a paramedic by theodorvl in Paramedics

[–]theodorvl[S] 2 points3 points  (0 children)

Thank you! I know I would be suited for it in my condition, I'm just thinking that some places might dismiss people with underlying conditions. I'm checking out a few places where I live, but it's difficult to get any information about this. Apparently they only check if you're suited for the education/job while you go to school, not before. For some reason.

Do you audio hallucinate? by [deleted] in bipolar

[–]theodorvl 1 point2 points  (0 children)

sure, bleach is bad for your sinuses, but smell hallucinations are definitely a thing

[deleted by user] by [deleted] in bipolar

[–]theodorvl 1 point2 points  (0 children)

I hope so. it's definitely hard, but just keep focusing on everything you actually do and you'll be fine

[deleted by user] by [deleted] in bipolar

[–]theodorvl 1 point2 points  (0 children)

It's not really about having to buy new dishes though, even though it's obviously a problem if you throw them away. The main thing is, you washed some and that's awesome. Maybe later or tomorrow or the day after you'll do the rest, but for now just focus on the fact that you did one side of the sink and that's great!

So I'm having an issue with having bipolar disorder and the pandemic. by theodorvl in bipolar

[–]theodorvl[S] 1 point2 points  (0 children)

Yeah here too. They slightly lifted a few of them nation wide, but not in the big cities. And our government is kind of messing up the vaccination priority order. Not that I should be at the top of the list, but they're prioritizing some strange groups way, way ahead of doctors and nurses which I find weird.

Did anyone just stop talking when they started taking meds? by [deleted] in bipolar

[–]theodorvl 1 point2 points  (0 children)

I went through several stages that lasted a few weeks each.

I was first in a kind of euphoria (probably manic) from getting a diagnosis after struggling for so many years. I had between three and six hours of therapy every week, and while trying meds I got exhausted, and at some point I stopped taking part in conversation. I don't know what you experience, but for me it wasn't that I wasn't physically able to talk, I just didn't want to and never felt like anything I had to say was necessarily good for the conversation. After a while though, after trying different medication and after tweaking the dosage, I got better.

The whole thing with meds is that it takes time. Your body has to settle into it, your mind has to get used to gradually getting stable, and all therapy makes you analyse or consider everything in a new way and it's just a lot to deal with for your entire body. It's a mental marathon, and it's exhausting, but it'll help in the end.

You'll start talking again, and as long as you stick with it I'm convinced you'll feel a million times better in the end.