ValueBasedPugs

u/ValueBasedPugs


r/TheWire•

One of the most common questions on this subreddit is "alright, I finished The Wire. What's next?" And really, what could possibly stand up to this show? Lots of people – HBO's "You May Also Like" suggestions included – think that we just want more crime drama. They suggest The Shield or Narcos or maybe Breaking Bad. But, in my humble opinion, The Wire isn’t just a cop show, and its true, spiritual successor should have more in common with the abstract things that make The Wire great than with the superficial fact that it's "a cop show" or about urban poverty.

What makes The Wire great isn’t its superficial subject matter – there are some shitty-ass cop shows and gangster flicks

00

r/excel•

Currently, I am using geocoding software to geocode an address and then a set of other addresses and then formulas to find the closest as-the-crow-flies distance from among them.

Does anybody have a solution to this that either: 1) doesn't require separate software (e.g. an Excel add-on), 2) A way to integrate some sort of driving-time-based distance like the Google API?

11

r/arizonatrail•

So I've sort of kept this bottled up for a while but I feel like it'll be therapeutic to say it out loud. Downvote if you want; I do realize this is my personal opinion, not some sort of objective fact.

Here it is: the northern AZT is very poorly thought out.

It starts with a poorly-chosen route up the Rim. The Washington trail follows an awful set of telephone lines up a dry, rocky trail while See Canyon and Tonto to the east are both verdant green and follow perennial rivers. A pointed decision was apparently made to miss Fossil Springs by traveling a little bit further west. Then the trail stays east, missing West Clear Creek, Wet Beaver Creek, Sedona (WTF!!!). And what does it do i

2826

r/legaladvice•

Hello! This is probably super straightforward, but:

  • Arizona

  • My child was at a daycare for ~6 months

  • A deposit of $3,000 was made, to cover final month of care

  • The monthly cost is $3,000

  • They did not return the deposit - yes, I fulfilled all contract obligations re: the depost

  • After I left, they charged me for another month - yes, I notified them ahead of time, as per contract, that I would be leaving so this should not have happened

  • I have spoken directly with the owner. They acknowledged that they owe me ~$6,000 - that the deposit should be returned and that the $3,000 was a nonsensical overcharge. They promised the money would be returned within 3 business days. It has

11

r/excel•

I have three tables: 1) Started, 2) InProgress, and 3) Completed. Each table has a Project Name, a Start Date, and a Project Status. Project status can be Started, In Progress, or Completed. I want a bit of VBA to move each project to the corresponding table based on what is in Project Status. All three tables are on the same sheet.

I've looked around for solutions on the internet and I'm not having much luck so far, unfortunately.

17

r/ableton•

Hello!

My brother is dipping his toes into Ableton and it sounds like it's extremely hard. There are free courses, for sure, and I'm sure a lot of you are self-learned, but he's a busy guy and I was hoping that for Christmas, I could hook him up with a course that would really jump start his Ableton capabilities. So:

  • Are there any paid courses that you guys would stand by as awesome?

  • Are there online "tutors" available that I could pay for that would get him serious headway with about $250-350 worth of sessions?

  • Any other ideas?

I'm really into cbackpacking gear and I know how annoying these "anybody have any gift idea" threads can be, so appologies if this is too annoying - I did

5563


r/RimWorld•

Whenever there's a toxic fallout event, I restrict my colonists to a safe, indoor area. When it's over, I (hopefully) remember to allow them unrestricted map access again.

So the fallout ends and I go to let them roam free ... and this one pawn who only ever hauls and cleans had accidentally been set to an area called The Freezer. It's the freezer. He had just lived there doing nothing for the entire toxic fallout event.

Dude just froze his ass off and pigged out for a half month without even having a mental state. Just "well I guess this is my life".

I think he liked it. Should I just put his bed in there?

29725

r/ULArizona•

Alright, so here it is: I'm cursed. I've canceled about five trips in 2021. Summer fires, permits....and to add insult to injury, I finally bought a nice Wild Ideas Barrikade Weekender for the trip I was most excited about: a glorious loop around the Grand Tetons. There was going to be pizza ordered to a parking lot. There was a boat trip. Anyway, that trip burned down, fell over, and then sank into the swamp was canceled about two days before it started due to a nearby fire.

So here I am with a pristine $309 bear canister. On pessimistic days, I think I may never use it. Maybe we'll just be on fire

72


r/excel•

Imagine a terrifying spreadsheet: formulas start in column AV and go to EU. Sometimes people mess with the sheet, copying formulas down, but they're not all knowledgeable and will occasionally copy the exact formula and paste it directly so that the cell references are off.

So I need a formula that checks if the cell references are all =ROW().

RowThing 1Thing 2Formula 1Formula 2Formula 3Check
2FALSETRUE=AND(B2=TRUE,C2=FALSE)=AND(B2=FALSE,C2=FALSE)=AND(B2=TRUE,C2=TRUE)No problem
3TRUETRUE=AND(B2=TRUE,C2=FALSE)=AND(B2=FALSE,C2=FALSE)=AND(B2=TRUE,C2=TRUE)Problem

Row 3 here is an issue because there are cell references that are for cells in

18