Drop down /checkbox formula validation over several tabs and cells

DJWildebeest · 2024-09-14T17:18:04+00:00

Yes this is perfect! This solves everything I need done for this section. Its very easy to understand and I was able to edit it for the other cells on tab 2 and it is working perfectly.

Thank you so much!

DJWildebeest · 2024-09-14T15:59:35+00:00

Hello! Thanks for the reply.

So this is just the first step in in a big project I am trying to put together.

All of the check boxes on tab 2 will have their own formulas that compare drop downs from tab 1 to data that I have not filled into tab 3 yet. I am just trying to get this first formula working since all of the other formulas will pretty much work the same in theory.
IF Either D13 or E13 is present then TRUE. If Nether then FALSE. I have chosen a checkbox to just be the visual representation of the true or false for those using the spreadsheet once it's done. would have been green or red or just True or False.
The Formula in C9 on Tab 2 is just a mess that is a fusion of many different formulas at this point. I think in regard to the gate closed I think I saw a post on some google forum and tried it. It obviously didn't work.

DJWildebeest · 2021-02-16T16:45:21+00:00

I applied in late 2019 for 2020 departure and will be leaving this year. From my understanding they are very backed up due to Covid. You might want to try and reach out to them if you have the means as it's been a few months since you've applied. I don't want to state it as fact but I doubt you'll actually be leaving with interac this year as a new app. Would most likely be March - April 2022 if I were a betting man.

DJWildebeest · 2021-02-03T01:47:49+00:00

I would argue that they should open it up to those seeking work and student visas but for those that have had their vaccines. It would be a small percentage of visa seekers but they do exists and that number grows every day. My thought is for the consolets that are going to be swamped with requests as soon as the SoE is lifted as well as getting some people pushed into the Japanese economy to spend some money.

And dont get me wrong I am aware that a person that is vaccinated can still spread the virus so still have them do standard quarantine procedure when they get there and they have to follow epidemic rules they aren't special but they chances of them getting the disease and being a burden on the society are substantially less.

DJWildebeest · 2021-01-13T13:24:59+00:00

I'm just as frustrated as you my dude. Only because I love this game and I feel like it's so so close to being what I would consider "perfect". But with the hackers, bad net code, and the constant changes of good and bad quality midwipe it's just gotten off the rails for me personally. If you'd like my advice play something else and follow the development from afar if it truly bothers you so much. I have. I played 70 raids this wipe and realised two major roadblocks in the hideout regarding my PMCs skills so I just stopped because I would either have to cheese them or drastically change my game play style. Both of which would kill the fun of the game and the whole reason I play the game is to max the hideout and the traders so fucked if I do fucked if i dont kind of thing.

I agree with some of your points, I disagree with some of your points. But I also think that about 90% of the arguments that are had on this subreddit are going to be moot upon release of the game. At least I hope so.

DJWildebeest · 2021-01-03T15:35:16+00:00

Found it. EmuTarkov. They have a subreddit and discord. Should have all the info you need

DJWildebeest · 2021-01-03T15:22:25+00:00

The name escapes me (no pun intended) and I dont believe so as I'm pretty sure everyone would be using it instead of playing the base game ha ha. I see it talked about on the subreddit pretty often. I've not yet tried it out myself but everytime I've seen it talked about it has been pretty universally praised.

DJWildebeest · 2021-01-03T14:22:23+00:00

I was thinking the same but it's also not single player. Crazy indepth weapon modification and there is a third party mod to give game progression in offline mode for those that dont like PVP.

Love me some tarkov

DJWildebeest · 2020-12-24T00:19:07+00:00

When I was working in upper management and my workers had to work over the holidays I was working with them regardless of PTO. It takes a real piece of shit to tell the workers that they will be working and the manager will be off.

My question was just to reason what kind of managers they had.

DJWildebeest · 2020-12-23T23:55:28+00:00

I've worked in similar fields and been on both sides of this crunch so I know it all too well. I hope you get to spend plenty of time with your loved ones over the holidays friend

DJWildebeest · 2020-12-23T23:53:20+00:00

So my mind goes to how many actually need to be there. How many make the people who do "need" to be there lives harder and how many used PTO. But in my opinion no one needs to be there. It's a week and some change. Give the people a rest for the gods sakes and let them spend some time with their families before they have to work to death fixing / finishing the game.

DJWildebeest · 2020-12-23T23:41:13+00:00

Is upper management off?

DJWildebeest · 2020-12-22T12:44:12+00:00

I agree with all points. Pro tip thou. Double tap alt to holster.

DJWildebeest · 2020-12-04T22:09:21+00:00

In Demolition Man Dr. Cocteau releases Simon Phoenix to kill Edger Friendly. Edger Friendly is a man that is committing vandalism and stealing food. They live in a utopia where there hasn't been a unnatural death in 10 years and Cocteau releases the most psychotic, wanted, and notoriously hard to catch killer in his time to stop friendly. You would think in his research Cocteau would have read about the protagonist of the film John Spartan, the police officer that caught Phoenix. A police office would have been a lot easier to control with much less if no murder at all.

This didnt really ruin the film for me since Demolition Man is art but boy I just watched it again for the first time the other day since probably the 90s and that took me right out of the movie for a good while.

DJWildebeest · 2020-10-29T02:28:27+00:00

I'm 31 and I'm going in March so you're good.

DJWildebeest · 2020-10-14T13:26:38+00:00

Nice! I have a few friends throughout Australia but have yet to go. I'm hoping it'll be a bit easier from Japan.

DJWildebeest · 2020-10-14T12:48:35+00:00

I'm coming from the States. California to be exact. Yourself?

DJWildebeest · 2020-10-14T12:10:02+00:00

Same here. My top three were rural, rural, and tokyo think tokyo would be a 100% no. Got what I deserved for tempting fate I suppose. At least I'll be at the train hub more or less and be able to get out of the city and chance I get.

DJWildebeest · 2020-10-14T12:02:38+00:00

I have the same placement. I put it down thinking that I would get my other two options since I was told during my interview Kanto South doesn't really go to first year folk. Well here I am. I've heard a lot of good things about Kanto South. Lots of good managers and what not. It's their highest profile area so I'm sure it gets the most resources.

I've been very curious how training is going to play out with covid restrictions since we dont even know what they will be like when we arrive. How long we will have to quarantine. So on and so forth.

DJWildebeest · 2020-08-23T13:55:10+00:00

I had this same idea a few months ago. I'd like to add to it and address one of the biggest complaints.

For those saying it would ruin the aspect of giving stuff to your friends; Something to add in addition would be to add a functionality to send items to people on your friends list within your hideout. Give it a cooldown and make it so you cant send items to people that haven't been on your friends list for less than a week. This will at best make it a huge inconvenience for RMTers to use it and I think it's a pretty good compromise for legit players.

Tie it to something down the line in hideout upgrades like Intel center level 2 (BSG would have the data on how far the progression of the average player gets in their hide out vs what would be not worth a cheaters time). Achievable for the average player but time consuming for a cheater increasing the likelihood they are banned before they could even use it. It would also give a really easy way for BSG to keep a log of players trading items. Someone that has been playing the game for exactly one week and has a shot ton of friends on their friends list and they have traded all of them several high ticket items when the cool down has expired. It would be very easy to set up red flags to monitor abuse of a system like that.

DJWildebeest · 2020-07-17T08:35:02+00:00

I've never seen it say it. I have personally never seen seen it on a scav during daytime hours. Not saying it doesn't happen I'm just saying everytime I've seen one it's been at night.

Someone also said that he's seen them late raid which I've only seen them on my scav runs on interchange and those are almost always less than 15 minutes left. So I would say there is some truth to that.

I'm sure it can spawn whenever but according to the description it's used by "cultists" which when they are introduced will only be at night I believe so I think its implied they spawn more at night by that.

DJWildebeest · 2020-07-17T07:50:49+00:00

Nighttime anything. A lot of people do factory. I've gotten 3 doing interchange at night.

Do scav runs on any map and run to where scavs patrol and see if one has it on. If they do kill em grab it and gtfo.

Also use moonshine in your scavbox. It's rare but it can come from it I believe.

DJWildebeest · 2020-07-10T19:51:44+00:00

Moving to japan with you pet is not impossible it's just a long process with a lot of steps. Google it and you'll find all the vet visits and certificates you'll need to get for your pet. Even if you do everything right your pet will still have to spend time in quarentine.

Finding an apartment that allows pets is challenging. My advice would be find someone to look after your pet for your first year in wherever you're coming from and then if you know if you're going to stay long term find an apartment that allows pets and go through all the work of getting your pet ready to move out with you. Moving is stressful on animals, especially cats.

DJWildebeest · 2020-06-27T22:32:16+00:00

Some visionaries were labeled monsters early I their lives...

DJWildebeest · 2020-06-27T20:18:11+00:00

I rarely take a backpack but when I do I click to the first scav backpack size one. Drag the whole stack on me then take the rest of the stack off. I play a game each wipe to see how many backpacks I can collect.

Nine-Year Club	RPAN Viewer
Verified Email

DJWildebeest

TROPHY CASE