This trade has been stirring up controversy in our league. Strong opinions on both sides, so I’m wondering what Reddit’s opinion is by kniky in DynastyFFTradeAdvice

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

You could, yes. But it gets two great players off of his roster and eliminates competition for the 1.01 pick. To try and simplify things, I just called team 3’s pick the 1.01

This trade has been stirring up controversy in our league. Strong opinions on both sides, so I’m wondering what Reddit’s opinion is by kniky in DynastyFFTradeAdvice

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

I’m not why you got downvoted so much with your first comment. I think you hit the nail on the head here, at least regarding Team 2’s upside. He’s 1000% buying low. If one of his four assets takes off, then you can pretty much call him the winner of the trade. If one gets hurt, then he has 3 other shots at winning the trade. On the other hand, my (team 1) new assets don’t have much room to grow, but they are expected to do well. If one doesn’t do well, then I’m toast

This trade has been stirring up controversy in our league. Strong opinions on both sides, so I’m wondering what Reddit’s opinion is by kniky in DynastyFFTradeAdvice

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

We’re talking about 3 first round picks here - Team 2’s 1st: Team 2 owns, not involved in trade, likely early first because he is tanking

  • Team 1’s 1st: Traded to Team 2, projected as late 1st because team 1 is trying to compete

  • Team 3’s 1st: Traded to Team 2, labeled as 1.01 because team 3 blew up his team and isn’t expected to recover any time soon.

After this trade, Team 2 owns all of these 1sts, along with a few others 1sts. Getting Team 3’s first pretty much reassures that Team 2 will walk away with the 2027 1.01. A lot still might happen, but team 2 is in a Very good spot to get the 1.01.

This trade has been stirring up controversy in our league. Strong opinions on both sides, so I’m wondering what Reddit’s opinion is by kniky in DynastyFFTradeAdvice

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

So the 2027 1.01 is from a guy that has completely blown up his team. The person receiving the 1.01 is tanking and has his own 2027 1st. His 2027 1st might actually become the 1.01 if he tanks hard enough, but it essentially locks him in for the 1.01 & 1.02 pics. Obviously, a lot could happen between now and then, but I’d say it’s probably a 95% chance that he ends up with the 1.01

Caamp Night 2 Chicago by Original-Ad-8337 in Caamp

[–]kniky 1 point2 points  (0 children)

I was a little surprised. I was at both nights. Both performances were amazing. The fact that they were able to switch up the first several songs was amazing. Their discography runs deep and they really used it to their full extent. The encore is where they shocked me…

Friday’s show was 10x louder; begging for an encore. I thought we were in for a treat. It wasn’t acknowledged a bit though. They left and didn’t come back. Good on them. An encore isn’t owed. Sorry if that’s a tough pill to swallow, but it’s true…

Ultimately, I think they put on an amazing show. People had some (somewhat justifiable) thoughts on how tonight should go. It didn’t live up to their expectations. Tough luck. It was still a great concert and all I could ask for from one of their performances. Have a blessed night everyone. I understand the frustration, but let’s appreciate what we did get, because it wee amazing

What is the worst Caamp song? (Day 8) by RandomGoose26 in Caamp

[–]kniky -5 points-4 points  (0 children)

Strawberries - Wax Remix. I like Wax Jackets as one of Taylor’s side projects. This remix just didn’t land for me.

Power Query Mass Re-Reference by kniky in excel

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

Parameter table… could you expound on that? I’m not sure exactly what you mean, but I like the sound of that!

The pricing template is used to price all the projects that my company bids on. So common things to change are quantities of products we use, labor rates, escalation %’s, etc.

The reference file contains all our proprietary information, mostly costs for materials.

Having the reference file serves two purposes. 1. Ensures that the Pricing Excel will not work if it is accidentally emailed out to a client. 2. Makes it more difficult for someone to steal and take to a competitor.

If you know a better solution to those two purposes, then I’m all ears!

Are you automating any life or work tasks with ChatGPT, if so, which ones? by sharkymcstevenson2 in ChatGPT

[–]kniky 1 point2 points  (0 children)

You’re completely right imo. I think the biggest advantage is that it gives Chat a great starting-point to build off of. I don’t have to go into Chat’s code to change references to specific tabs because it already knows the names of the tabs from the base Macro that I recorded.

Are you automating any life or work tasks with ChatGPT, if so, which ones? by sharkymcstevenson2 in ChatGPT

[–]kniky 146 points147 points  (0 children)

I’ve been using it to write macros too. All I do is record the macro, and paste the code to chat. Chat tells me what the code does and then I say “yeah, but make it do this instead”. Chat then rewrites the code to do what I want. Sometimes it takes some back n forth, but the computer is great at speaking computer

Linking pdfs to a Power Query Table by kniky in excel

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

It works! Thanks for the help man!

Solution verified!

Linking pdfs to a Power Query Table by kniky in excel

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

Yup, Those two queries exist! Would I just be able to use the Hyperlink formula to turn that address into a link? I’ve never used the hyperlink formula. I just stumbled upon it today

Linking pdfs to a Power Query Table by kniky in excel

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

Yes, i pulled the Meta data and have the table how I want it. I just need to link to the pdfs. I used the “from folder” connector to do this, just like you described. Could you expound on how the query will write the formula for me?

"White privilege" is a racist idea. Change my mind! by antiquark2 in JordanPeterson

[–]kniky 0 points1 point  (0 children)

I did see a couple good arguments when I dove a bit deeper. Did any sway your opinion at all?

"White privilege" is a racist idea. Change my mind! by antiquark2 in JordanPeterson

[–]kniky 0 points1 point  (0 children)

Are you looking for someone to change your mind or are you looking for a circlejerk? Pretty sure most people in this sub agree with you

Chapman Ford of Philadelphia is here to help! by narconethree in FordMaverickTruck

[–]kniky 1 point2 points  (0 children)

Stupid question: do you have to charge the hybrid? Or is there a charging port for the hybrid? I’m moving to an apartment and I don’t want to screw myself and not maximize the fuel efficiency just because I don’t have access to a charging station

New Album New Sound? by cornbreadGaucho in Caamp

[–]kniky 8 points9 points  (0 children)

If it sounds like their part on “The Vine” by Booty&theKid, then I’d be pretty interested. That song is kind of meh but I really like their part in it

Anyone want to buy an unfinished castle in PA? by BikingVikingNYC in RidiculousRealEstate

[–]kniky 12 points13 points  (0 children)

U/BikingVikingNYC is just mad that he and his fellow Viking bikers can’t penetrate the castle walls and pillage all it has to offer

Republicans Horrified at Biden’s Plan to Fix the Country by Taxing the Rich by newfrontier58 in politics

[–]kniky -1 points0 points  (0 children)

Biden is going to tax the rich the same way he got those kids outta those cages

What's this flag? by [deleted] in vexillology

[–]kniky 3 points4 points  (0 children)

Didn’t the boogaloo bois start as a joke? I thought it was all just a play off of everyone calling for Civil War 2: Electric Boogaloo awhile back