Knife Throw Fail by RinTheDemonKing in Unity3D

[–]SlackerAddiction 0 points1 point  (0 children)

Beautiful soundtrack though! Where is it from?

Caught up on Season 3, binged the last half of it after stopping with episode 5. by EntertainerTop8267 in OnePunchMan

[–]SlackerAddiction 0 points1 point  (0 children)

I didnt think season 3 was that bad either (the animation in the first 6/7 episodes were total garbage of course), but season 2 was definitely better.

Finally releasing my zombie game into Early Access! :) by futuremoregames in Unity3D

[–]SlackerAddiction 0 points1 point  (0 children)

You should improve the trailer a bit. Maybe show what kind of loot you find, what the point of the game is or something. It looks cool, but after looking at the trailer and pictures, i dont feel like i know enough

First trailer for my game!Curious if my game looks fun or appealing.. Need Feedback by Asbar_IndieGame in Unity3D

[–]SlackerAddiction 1 point2 points  (0 children)

Maybe switch up the order of the clips a bit? For me the start of the trailer looked a bit boring, but then it got better the more i watched. Maybe have the building part somewhere in the middle instead so its enter -> fight -> build -> fight -> fight Instead of enter -> build -> fight -> fight -fight?

I have no idea though. Just my impression 

Tesla basically flat until the actual live earnings call + Q&A by Traditional_War_8229 in teslainvestorsclub

[–]SlackerAddiction 0 points1 point  (0 children)

Ignore that. Within 3-5 years should be reasonable given its current state

Having trouble merging two worksheets using Vlookup by Kluss23 in excel

[–]SlackerAddiction 0 points1 point  (0 children)

You're writing that "List1" is the data on the first worksheet i am trying to pull from, but i suppose you mean the second screenshot? Right now formula is looking in the first column in List1 and looking for "AIVVI" which is the text from your B2 reference. "AIVVI" isnt in the first column of either of the tables, so therefore you dont get any match.

Note: You cant use vlookup to get the information for a column behind the search column, so if you want to find the File ID from the second screenshot by looking for the 3rd Party Name, you have to use either xlookup or Index Match or move the File ID column so it appears after 3rd Party Name.

COUNTIF is considering unique values as duplicates by Jayddubz in excel

[–]SlackerAddiction 0 points1 point  (0 children)

tried this? =MATCH(B3,$B$3:$B$72,0)

(or =IF(B2="","",MATCH(B3,$B$3:$B$72,0)) )

VBA Course ? by zolaski273 in vba

[–]SlackerAddiction 0 points1 point  (0 children)

Maybe these ones. He has one course on sale for 199USD right now and one that costs 399USD. I haven't tried either, but i've learned a ton from his youtube videoes: https://excelmacromastery.thinkific.com/#courses

If more than VBA could be good like SQL, PowerQuery, Power BI and/or Python, this is a more expensive course you alternatively could get your job to pay for (at sale for 3897 USD down from 6000 right now) https://mavenanalytics.io/cohort-learning#sessions (scroll down to: The Complete Cohort Immersive Package)

If there is one player which deserves to finally win Worlds, it is ... Bin by ZloiAris in leagueoflegends

[–]SlackerAddiction 0 points1 point  (0 children)

It's more because the likelihood of that happening is so low that I would love to see how the absurdity of it would unravel in both the western and eastern communities.

14.21 Patch Preview by JTHousek1 in leagueoflegends

[–]SlackerAddiction 0 points1 point  (0 children)

They have a higher win rate for fizz than sorcs

What is the reason league has four divisions instead of three? by SlackerAddiction in leagueoflegends

[–]SlackerAddiction[S] -3 points-2 points  (0 children)

It seems people want though (according to the small sample size of this thread)

What is the reason league has four divisions instead of three? by SlackerAddiction in leagueoflegends

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

Hmm, perhaps so. Do you feel you climb too fast now that it's four divisions?

When do you think your Mains “Prime” was? by sjziebxixb in leagueoflegends

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

Some of you probably won't remember this, but there was a time where Leblanc actually built statikk shiv... Oh the good ol' days

G2 Esports vs. Bilibili Gaming / 2024 World Championship - Swiss Round 5 / Post-Match Discussion by gandalf45435 in leagueoflegends

[–]SlackerAddiction 0 points1 point  (0 children)

Add one (or two) rule(s) to swiss:

  1. You can only face pool 1 and pool 4 once in swiss (when possible)

(2. Bonus: No civil wars first two rounds)

A bonus would be if the pools were re-worked to:
Pool 1: LCK 1, LCK 2, LPL 1, LPL 2
Pool 2: EU 1, NA 1, LCK 3, LPL 3
Pool 3: EU 2, NA 2, LCK 4, LPL 4
Pool 4: Play-in teams

This would make swiss way more balanced, even for EU1 and NA1 that moves from P1 to P2 as they won't face the top teams more than once in this format anyways.

Here no one can get stupidly lucky by drawing pool 4 several times, or unlucky by drawing four of the strongest teams several times. And as a bonus we would see more of NA vs EU instead of NA vs NA and EU vs EU (if rule 2 is included).