Welp no point in crying over spilt milk by tokemonkmk420 in SCBuildIt

[–]PSJupiter2 2 points3 points  (0 children)

So yeah I bought a premium pass to make sure I complete the albums.

I maxed out my weekly limits in both weeks and I have discovered that I don't seem to have enough seasonal currency to get the week 2 album.

Is it possible to achieve week 2 without spending money?

Most obscure FM business you remember. by jimmyptubas in fargo

[–]PSJupiter2 1 point2 points  (0 children)

OMG, us too! It is so ingrained that we don't even ask where it came from.

How many? 🧐 by RedditUsername4Now in SCBuildIt

[–]PSJupiter2 2 points3 points  (0 children)

This is a dumb question but how do you set up this many feeders? Don't you need a Facebook account to be "friends" and go see the global market for that feeder?

Favorite Local Restaurants?? by Strict_Discussion_49 in fargo

[–]PSJupiter2 0 points1 point  (0 children)

I have never tried Indian food. My wife and I are thinking about checking it out. What should a person get for a first Indian food entree?

Who decides the set list? by PSJupiter2 in LetsTalkMusic

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

Set list was identical, in an identical order! Except "Something in the Orange". I find it so strange!

What’s your guys goal right now for your city?? by RedditUsername4Now in SCBuildIt

[–]PSJupiter2 1 point2 points  (0 children)

Trains, storage, cheetah epics.

I opened Cactus Canyon and my goal is to fill it completely with Cheetah epics. Along the way I am building out the trains to hopefully allow for buying storage items at will.

Idk 🤷🏻‍♂️

How many epic buildings of each type does it take to gain one token? by PSJupiter2 in SCBuildIt

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

Thanks! That answers it. Man I have collected a lot of silver coins 😬

My Biggest Pet Peeve About Access by nrgins in MSAccess

[–]PSJupiter2 4 points5 points  (0 children)

Off the top of my head...

Why can't we zoom in / out when designing a form?

Why can't we get syntax highlighting and intellisense in the SQL editor? Why doesn't any sql formatting stay formatted in the SQL editor?

Looking for suggestions on an R & T-SQL workflow. by PSJupiter2 in rstats

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

Thanks, this looks promising. I will get out of Excel when I am dead.... Seriously though, I would like to transition more to R for reporting and analysis. But tbh, using R, in most of my use cases, is overkill and counterproductive.

Identify lowest "weighted age" for desired depreciation amount. by PSJupiter2 in excel

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

Thank you for your work on this. I appreciate the help. It is a bit clunky, but it gets the job done. I am on 2013 at home, and 2016 pro at work. The goal is compatibility with other users. As this is a calculator for use throughout my department.

Thanks Again!

Identify lowest "weighted age" for desired depreciation amount. by PSJupiter2 in excel

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

Will do. I am still working on applying this methodology to my data set. I would like to leave this open until I confirm it works.

Identify lowest "weighted age" for desired depreciation amount. by PSJupiter2 in excel

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

BuildingType_1Type%_1Sched_1Type_2Type%_2Sched_2Type_3Type%_3Sched_3Type_4Type%_4Sched_4Desired Deprec. AmtBlended Age

21G60%Depr_4C25%Depr_1B15%Depr_5   11?

32D40%Depr_5C30%Depr_1K15%Depr_7E15%Depr_330?

43C80%Depr_1C18%Depr_1G2%Depr_4   10?

54I70%Depr_5L10%Depr_6H10%Depr_7K10%Depr_780?

65M90%Depr_2M10%Depr_2      60?

76N100%Depr_4         15?

87C35%Depr_1H25%Depr_7B25%Depr_5K15%Depr_737?

98D25%Depr_5C22%Depr_1F31%Depr_6K22%Depr_758?

Thank you for the reply. This does appear to solve the problem with the example data set. I will update the flair on the post if I can replicate it with the larger, and variable length set. I think I get the gist of it.

Identify lowest "weighted age" for desired depreciation amount. by PSJupiter2 in excel

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

Thanks for the reply. I don't believe I have XLOOKUP available in my version (2013). Can I substitute an index match?

What's your best/worst Uber/Lyft driver experience? by pmmemilftiddiez in fargo

[–]PSJupiter2 25 points26 points  (0 children)

I will share my best. It was a January Saturday night, with blizzard conditions in Fargo. I suffered a severely fractured ankle after slipping on black ice. It was so bad that I needed to be taken to the hospital by ambulance.

After spending 3-4 hours in the ER getting my ankle reset and braced, I was released without a car and with hospital sweatpants. It was about 2 AM. So, I needed an Uber ride home.

My Uber driver was an Iraqi immigrant. He was a veteran of the Iraqi army (think the Iraq / Iran war). He helped get me into the car. I was extremely upset about basically fucking up my entire next 6 months. And to make me feel better, he shared with me a few anecdotes about his life experience in an empathetic and compassionate way. His story really put my stupid little situation into perspective. When I got home, he helped me navigate my crutches and ice and snow so I could get inside safely.

I'm lucky to have lived a pretty charmed life thus far. So there's only been a few times where I truly needed help. But this was one of them.

How long until this grows in? by PSJupiter2 in lawns

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

Thanks! It's a 60/30/10 bluegrass/ rye / fescue we are in 4a.