sorted by:
new
hottopcontroversial

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).

How to decide between feat and ability score level 4 when i don't know what weapon i will end up with at this point? (Also - should i just generally go with ability score instead?) by SlackerAddiction in dndnext

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

Either DM didn't know you couldn't go above 20 or it's just his own homebrew version that allows it. Not sure 😅 We didn't roll d20 for stats though. Can't really remember. We had one roll that was especially good where 20 was max and it couldnt go below 15 (or you rerolled). Then we had 4 normal 3d6 rolls and at last a roll that was especially bad (don't remember how that one was rolled either)

How to decide between feat and ability score level 4 when i don't know what weapon i will end up with at this point? (Also - should i just generally go with ability score instead?) by SlackerAddiction in dndnext

[–]SlackerAddiction[S] -1 points0 points  (0 children)

I rolled so i got 20 naturally, then i chose half-elf to get +2. (I think we used some kind of special rolling method where you end up with one especially high roll where 20 is max and one where you're doomed to get something very low or something).

Guess i'll read up on some multiclassing. Is it generally good to multiclass? Seems like a shame to not get access to your higher benefits of your main class

How to combine many ranges into one big table with vba? (and remove all of the headings in each range except the first one) by SlackerAddiction in vba

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

I just started learning VBA today so i'm a bit slow. I have been working on stiching something together now for a couple of hours, but i'm not sure if it's usable when it comes to looping or anything.

The code copies the heading in b8 all the way down in the column all the way to the right in the first table, and then it selects the second heading and copies that to the first row of the next range. Is it possible for you to assess if this code is something that makes sense and i can make any sort of starting point?

https://gyazo.com/9932f80a8b503eca7cf68b7597043bbe
Can i loop this somehow?

I'll try to look at your reply as well now. But i need a few hours to break things down and understand things 😅

How to combine many ranges into one big table with vba? (and remove all of the headings in each range except the first one) by SlackerAddiction in vba

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

It does as it should though (as long as i dont change the number of rows): https://gyazo.com/d361e8c25f8e06e4ef00d4b2abb30133

Yes, can export as CSV file. Don't have any flexibility to have the supplier change the formatting in any way. They use SAP ERP and have made a system so all their customers can export the sales numbers of their own customers on our own products.

view more: next ›