2022.01.21 13:27 Adept_Student_7975 Rate my car drip(I should maybe change boost color into titanium white since doesn't look like it goes well with red,help me out)
|submitted by Adept_Student_7975 to RLSideSwipe [link] [comments]|
2022.01.21 13:27 PowerForce2021 Uncharted Legacy of Thieves Collection – Launch Trailer
|submitted by PowerForce2021 to Youtubeisawsome [link] [comments]|
2022.01.21 13:27 Noah_Philipsen CHIZUK From A Baal TeShuva (An Unforgettable Night)
|submitted by Noah_Philipsen to Noachide [link] [comments]|
2022.01.21 13:27 Libertus82 Have some IDs in a large array (some IDs exist in multiple cells). For every row each unique ID appears in, I need to sum the value of another cell. Quite lost, please help!
So essentially, I have a large array with IDs scattered throughout the array. I also have a list of these IDs. I need to add to the list of IDs, the summed value of a single column for each row the ID appears.
Here is an example showing what my data looks like, and the results I am hoping for. A15:A18 has the list of IDs. Note that the ID in A15 appears twice in the array, so I need to sum cells H2 and H3 for that ID - because the ID in A15 appears in both row 2 and 3. For the ID in A16, it only appears once in the array, so I only need to pull the single value from H5, because the ID only appears in row 5 in the array.
I only need to do this once for now, so this doesn't need to be too slick. I just need the data! Thanks for looking!
submitted by Libertus82 to sheets [link] [comments]
2022.01.21 13:27 ineedmoresleepasap My dog won’t eat
I need advice. My dog is a healthy (besides some severe anxiety which I give him CBD chews almost daily for), 6 1/2 year old mini schnauzer. He can be very active but also is down to spend the entire day in bed with me when I need it. Truly the best little buddy I could ever have. I only work one long day a week and I put him in daycare for that day. He loves going and even has an obvious favorite person there.
My issue is, he literally won’t eat on his own. If I switch brands (slowly and properly) he will happily eat it for a few weeks and then go straight back to starving himself. I literally have to sit on the floor with him every morning/night and hand feed him like it’s treats. It’s emotionally exhausting watching him be willing to starve himself. I’ve tried just leaving his food out and deciding that he will eat when he’s hungry but broke after day 4 of ZERO food being ingested. He gets so excited for treats or human food but has a sensitive tummy so I don’t like him having those things very often.
I’m on a waitlist with a breeder to get a new puppy that’s supposed to be born this month and I really want this resolved before throwing another dog in the mix. Part of me feels like maybe it‘s depression related because we used to live with my parents and he had several other dog siblings there but now it’s just us. So maybe once he has his new sibling, he’ll be happier and want to eat more? I don’t know. Has anyone else dealt with something like this?
submitted by ineedmoresleepasap to dogs [link] [comments]
2022.01.21 13:27 Throwaway84237942 Let's Try This Out
I'm not really used to venting at all, never really done it, but as I'm sitting here in my room in silence trying to resist the urge to smash my fist into the wall as hard as possible, I decided let's try this out.
The last 12 months have been torturous, just day to day misery. I have so much bottled up stress, frustration and sadness with no way to release it. I'd love to go into detail with the main issue I have currently but even thinking about it makes me sick to my stomach and anxious, it's something I gotta emotionally prepare myself just to even briefly discuss in vague detail. But the other stuff...
I deal with really bad loneliness, it really fucking gets to me. The friend group I had back before January last year has completely dissolved, and these guys were the best friends I've had, their company was like a second home to me. One by one I lost each of them throughout the year, not dead don't get me wrong. I miss them and the good times so much. One now hates my guts, another has become distant to focus on his own life, one just has no interest in communicating with me, I'm still friends with another and us splitting as a group made me and him closer but still. It's extremely hard to find new friends, I've given up on it.
I can no longer find enjoyment in stuff I used to love, as it'll just contribute to me feeling more miserable with all the good past memories associated with all those things being just that, memories. There's only a minimal amount of stuff and hobbies I can enjoy anymore, and in tandem with the loneliness I suffer from it just leads to me sitting in my room in the dark, not knowing what to do to pass the time or distract myself from the misery.
Used to deal with bad eczema, so bad it makes me shudder thinking about previous experiences, and it's come back, I don't know if it's related to my feelings but the last time I had it I was also under extreme amounts of stress and sadness. But this time I feel like such shit I don't have the drive to take care of myself on a basic level. I couldn't be bothered to use the basic treatment I was prescribed by the doctor. I look like shit and am in physical pain cause of it but I just can't bring myself to do anything about it. Had me laying in bed for a full 40 fucking hours one time back in December. Unrelated but I'll also have periods where I feel like such shit I can't even eat, back in June I didn't eat for 4 entire days, and I have frequent issues sleeping. Constant nightmares and waking up throughout the night, also in June I could no longer sleep, I had to buy YouTube premium just to play videos through my headphones to help me sleep and keep my mind at bay.
Just feel like such a failure and disappointment to everyone around me. I'm going to be 20 soon, and I can't do shit, I'm a fucking idiot. I don't even know how to take public transport for fucks sake. I dropped out of college, I can't drive, I've never had a job. I only graduated high school because they couldn't hold the finals due to covid so I got a free pass. I am quite literally a waste of space with no redeemable qualities and I live in such an isolated world. I contribute nothing to society.
Is this what adult life is like? Permanent misery, just doing your best to temporarily distract yourself from it? I don't know how to relieve my stress, frustration, depression and such, it's bottled in so much that the smallest most insignificant things will have me fucking fuming or on the verge of tears. Where have all the good times gone? It's just me stuck with my demons now.
If anyone actually bothered to read this, thanks you're awesome. I feel indifferent after this rant, maybe I need to wait a bit. Anyways, have a good day everyone.
submitted by Throwaway84237942 to Vent [link] [comments]
2022.01.21 13:27 PowerForce2021 Uncharted Legacy of Thieves Collection – Launch Trailer
|submitted by PowerForce2021 to Sub4subGrowth [link] [comments]|
2022.01.21 13:27 jpdelta6 I'm looking for a first-hand account of the Hong Kong Protests for a profile essay.
Hello, I am a college student in the United States Midwest, and I'm working to write a profile essay for my class. However one of the primary components of a profile is a first-hand account of the subject. Of course, I didn't take part in the protests so I cannot provide such an account. I'm hoping to talk to someone or multiple people about their experiences during the protests.
I hope anyone who contacts me will be willing to prove their identity and relation. No evidence will be recorded and the person will remain as anonymous as possible, as I don't want to see anyone persecuted by the Chinese government, for their freedom of speech.
submitted by jpdelta6 to HongKongProtest [link] [comments]
2022.01.21 13:27 IllKindheartedness30 [USA-NY] [H] Nvidia GeForce GTX 1080 TI SC 4GB [W] Paypal or Local Cash
2022.01.21 13:27 Odd-Strategy-5264 Am i
2022.01.21 13:27 GretaVanFleek Living Quarters and Care for Mini Donkey?
So my wife decided she wants a mini donkey. I need to quickly build a simple shelter and ensure I have basic needs for its care, because she's pulling the trigger on getting a 1 y/o adorable one with spots. First time owning something like that, so we're green.
It will be kept in a fenced area about 1.5 acres in size. I do have chickens as well that will share the area as they free range, but they have their own coop they go in at night.
I plan to make a small and simple, three-sided, lean-to structure for housing, probably something like 8×12×8 unless it needs to be bigger? I'm not really sure on sizing. Wife wants me to build it with a center split so we can use it as a stall for the mini donkey as well as for a handful of Nigerian dwarf goats she wants to get later this spring.
I know I need a ground feeder or something, water trough, make sure fence is secure, make sure donkey can't get in the coop. But I'm not clear on other care requirements, like what exactly they eat or how much I'll need to feed when grazing openly is an option, or on things like how often they need veterinary care, farrier work, etc. We were told the mini donkey is currently unvaccinated and stands for the farrier, which I assume means that the donkey doesn't throw a shit fit over getting its hooves trimmed.
Any advice is appreciated!
submitted by GretaVanFleek to homestead [link] [comments]
2022.01.21 13:27 heartucx Question about leave paycheck
2022.01.21 13:27 LyndseyT11 Can't expedite new debit card. Bummed.
Chatted with customer support today because my debit card is having issues being read at several of the terminals when I insert the chip. I use tap when it's available, but I wanted a new debit card shipped to me without this one being deactivated so I could at least tap for the mean time. Was told they don't have that option and this one will be deactivated immediately.
That would be alright if it didn't take 7 to 10 business days to get the new one. If this one is going to be deactivated, wouldnt the option to expedite that shipping be helpful? This is the first time I've ever thought chase did something better than Sofi. They shipped me a new debit card in 2 days before.
Guess I could just use credit in the meantime if I order it, but still disappointed.
submitted by LyndseyT11 to sofi [link] [comments]
2022.01.21 13:27 ComanderCupcake I have 6 dogs, here is some pics of me with them
|submitted by ComanderCupcake to aww [link] [comments]|
2022.01.21 13:27 DeluxeArmChair Constantly falling asleep after work
So I feel this has been a problem for a while now. I just found the sub and was hoping to get some advice. I don't have a very intense job at all it's actually far from it, I work from home at a desk. I do tech support, although it's not physically demanding mentally It can be draining for some of those calls. and by the end of my shift, about 3/4 of the time I want to just lay down and relax for a bit, and then I get comfortable and sleep is all I want. I've gotten to a point where I do this everyday, sleep through my free time, maybe spend a few hours once I wake up around 9:00 or 10:00 to eat and shower or maybe try to do some light stretching and exercise to get my body to not feel so weak from doing mostly sleeping and sitting. I do try and stand when I work but it seems to only help so much. by the time I hit 4:00 p.m. I'm in bed falling asleep by 5:00 and not waking up till 10:00pm. on my last day of the week today I fell asleep at 4:00pm and woke up around 8, couldn't help but fall back asleep and slept till 6:00 a.m., once again had no motivation to wake up and slept some more till 10:00 a.m.
I really feel there's something wrong with me but I just have no idea. I've had my blood work and my doctor didn't have any comments, just gave me a basic pamphlet about good sleeping practices and some vitamin D cause I was moderately low on that. Sleeping kind of always has been my coping mechanism with most things but these days it's kind of gotten out of hand for some reason. which I don't understand because my life is on a uptrend All things considered.
submitted by DeluxeArmChair to GetOutOfBed [link] [comments]
2022.01.21 13:27 delightkc Mental load
Why is it that most of the moms I know are full time breadwinners and the partners are supposed to be stay at home dads/part time but it feels as though we are always carrying the load? It’s the mental load thing isn’t it.
Do these millennial dads just wanna be cool and easy breezy but not want the hard stuff that comes with it? I know the “provider” mentality is outdated but someone still has to provide. Haha. And yea! I know all dads aren’t like this but I just noticed a trend with some of my pals.
I’m hearing a lot of dads playing video games, YouTube, or phone when baby naps during the day so not much housework gets done.
Love my husband and he’s great with her, very engaged with her when they play. And I am super glad I’m involved during the day and love working from home but I just wish I didn’t have to ask for help when it just seems logical. Maybe it’s because I’m working from home and have some flexibility? I just don’t think he gets that other stuff needs to be done when you are watching the baby/house regularly.
Anyone else experience this/notice this?
submitted by delightkc to Mommit [link] [comments]
2022.01.21 13:27 PowerForce2021 Uncharted Legacy of Thieves Collection – Launch Trailer
2022.01.21 13:27 iamcalifw 🐕 Meta Shinji Just stealth launched 🚀 | Elon Tweeted about us | CG and CMC listing soon | A new member in Meta token family💥 | 🚀GEM x1000 moonshot | FairLaunch 💰| Just Launched
Tg : https://t.me/metashinji_bnb
💥 CONTRACT : 0x5ee46B5A83291349f00c0c474A6c08D406AEaFB7
🚀 Buy On Pancakeswap - https://pancakeswap.finance/swap?outputCurrency=0x5ee46B5A83291349f00c0c474A6c08D406AEaFB7
🔥Chart : https://charts.bogged.finance/?token=0x5ee46b5a83291349f00c0c474a6c08d406aeafb7
🔥Ownership Renounced : https://bscscan.com/address/0x5ee46b5a83291349f00c0c474a6c08d406aeafb7#readContract
Slippage : 0%
Meta Shinji THE NEXT 1000X GEM? The Next ShibaInu
0% Buy/Sell taxes :
Experimented team of professionals (development, marketing, etc.) 📡
The Shinji Inu token is our foundational currency that allows investors to hold millions, billions, or even trillions, of it in their community.
Incoming marketing :
2022.01.21 13:27 Arnadus [SOL] Solana. Price 🔥 +4.13% in 1 hour [+ 1 other]
2022.01.21 13:27 CipherZer0 Is this how the game is generally played?
Like, throw everything in your hand, spend about 5 minutes summoning & shuffling from the countless effects of your cards, then end up with a 1-turn 10star monster that either destroys your whole board or prevents you from doing anything...? 5 ranked matches so far and that's all I've been getting. Not a fan
submitted by CipherZer0 to masterduel [link] [comments]
2022.01.21 13:27 thatswhatyougot Bipartisan group of eight US Senators urge President Biden not to extend solar tariffs
|submitted by thatswhatyougot to energy [link] [comments]|
2022.01.21 13:27 UnusefulCoder THE FIRST ONLINE SCHOOL ON DISCORD! A large team of real teachers and students will help you with anything school related. We are a welcoming community for every school grade (13y/o+), feel free to join!
|submitted by UnusefulCoder to DiscordAdvertising [link] [comments]|
2022.01.21 13:27 Immediate-Form-2262 Spark Mandrill VS Lugnut (MegaMan VS Transformers) big dumb bruiser loyalists to Megatron and Sigma that have to be pointed in the direction of what to smash by there comparatively smarter allies
|submitted by Immediate-Form-2262 to DeathBattleMatchups [link] [comments]|
2022.01.21 13:27 throwawayanon-help i have to leave back to my home state and say goodbye to my boyfriend.. but don’t know how to say it . i also overheard his step father speaking about us. how do i break news to boyfriend?
i have been living with my former long distance boyfriend and his family for some time over a year now. it’s hard coming to terms with the truth but i know in my heart and logically i should go back home.. i am going to college and don’t work so i am being taken care of him and his family and realized today how much of a burden i actually am. i love my boyfriend so much and i wish i could stay but there’s so many reasons as to why i shouldn’t be here anymore. first off, this place still doesn’t feel like a “home”, i feel isolated and my relationships with the rest of his family aren’t close. that being said, i don’t really step out of the way to leave the room and start conversations up for fun. secondly, when me and my boyfriend get into arguments the only thing that sucks is that i can’t just go home and be with my family when i want / need them. third, there’s nothing for me here.. i don’t have a job and i don’t have a ride to go anywhere :/ i’m only going to college but thats my only purpose. if i were back in my city i would be able to have a job, be able to drive, and have an actual life. besides that sure, me and my boyfriend get into fights but at the end of the day everything is fine and we love each-other the same. the only other thing that is causing a problem is being with his family.. i don’t feel comfortable around them and overheard his step father speaking on the phone to my boyfriends sister. his step father said that the two brothers living here in the house (other siblings are moved out) “have no life skills” and that his wife is stuck with the two of them still. he stated that he thinks my boyfriend would pick up the slack since he goes to work everyday but” he’s just not doing it “. he also said that how at his (my bf) age did he (stepdad) have to teach him to cook.. then my boyfriends sister replies “yet he wants to be with a girl like (x) years younger than him”. later on after that he said “yeah like you said , she’s only hurting him.” i stopped listening because i was just shocked at what they had to say. he also said stuff about they don’t even have to worry basic necessities and theres always garbage in our space ..? i clean our area everyday and leave trash bags / grocery bags next to the door so my boyfriend can take it out. i feel embarrassed to even see him again since he is willing to say this stuff about us. i wouldn’t want to live with his family if i had the choice, but it is how it is. my heart is breaking just knowing that it is necessary. all the signs point to go home. i don’t know how to tell my boyfriend it is the right thing to go home, i am worried the relationship will break off going back long distance.
submitted by throwawayanon-help to relationship_advice [link] [comments]
2022.01.21 13:27 babaggett2100 Louie Anderson, comic and 'Baskets' star, dead at 68