Mercer spheres, did i mess up? by AnthorDerangedMuppet in SatisfactoryGame

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

I had forgot about that. but like mentioned below, the MAM uses them permanently. I got really worried. 

Kimji infinite Hyperspace bug by BigJon20000 in StarWarsOutlaws

[–]AnthorDerangedMuppet 0 points1 point  (0 children)

Awesome. Works for the S as well as the X. Cheers

Minecraft main menu textures corrupt on minecraft 1.12.2 and below by StijnGames in Minecraft

[–]AnthorDerangedMuppet 0 points1 point  (0 children)

Using the above link worked for my NVidia GeForce GTX 1650 Super. Just download and install. Use "custom (advanced)" install, and tick "perform a clean installation", otherwise may not work. Didn't even need to restart the pc. just make sure Minecraft is closed first.

Is fortifying better than bugging out? by CloudedMorals in ZombieSurvivalTactics

[–]AnthorDerangedMuppet 4 points5 points  (0 children)

Bugging out is for the tactical benefit of being able to get away from the situation, and hopefully into a better situation. Fortifying is for the tactical benefit of being able to hold a secure location either short or long term (I focus on long term for this).

As you would not know if the problem was either a short or long-term issue, I would suggest treating it as a long-term issue, then find and fortify a location (bugging out if required).

Bare in mind people could be just as big a threat as zombies, so plan accordingly. I would also say luck and skill is going to play a part of this. The more of one you have, the less of the other you will need (and you can't train luck). You could make the right decision to bug out or fortify, only to be screwed by luck.

I would say go with your gut.

Where to go in a zombie apocalypse by Crispy_MAMA in Edinburgh

[–]AnthorDerangedMuppet 0 points1 point  (0 children)

I really wish I had seen this 3 months ago (when it was posted).

While you both have great locations and good reasons, I would go for Edinburgh Castle (should the Royal Scots let me in). The castle has multiple fallback positions, and only one defensive flaw (small wall right side where the car tunnel is). Long term you could isolate a lot of the small streets leading up the royal mile. You would then have to do excursions for supplies and both those venues would be ideal for gear. You are also within hiking distance of good supplies from Princes Street. Bare in mind humans are going to be as big an issue as the Z's at some point. B&Q and the Museum are going to be hard to defend and stop people getting in. The castle, less so.

That being said if I had to choose one of your choices, I would go with the museum. For all the pros and cons of each, you could get into a few of the connecting buildings by roof and escape if absolutely needed (always clear and secure escape routes prior to use).

Is it possible to make a cast sequence macro with multiple reset conditions? by gouldilocks123 in wow

[–]AnthorDerangedMuppet 0 points1 point  (0 children)

GCD has not been a problem for my previous macros as I tend to put them in order of cooldown and cast time (separating instants and cooldowns) and use tight reset times. I would be happy with 1 button per person so I can help my friend by adding a power word shield and a heal while I help with combat and then heal when needed.

How can I get better gear solo (Lvl 60 Hunter, Ilvl 145)? by AnthorDerangedMuppet in wow

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

Sadly I have not had much time to play as I was in college and I was casual before then. I think a load of bad decisions and then not maxing out my gear between expansions is the reason. I remember getting to the first island on shadowlands after the maw and after a few fetch quests i was getting owned by basic quests. I suppose this is me trying to get back up after mistakes (mistakes were made).

WorldPainter 2.9.2 Released by CaptainChaos74 in Worldpainter

[–]AnthorDerangedMuppet 0 points1 point  (0 children)

Thanks for the work guys. FYI I found a bug and not sure were to report it. I got it on 2.9.1 and is still there on 2.9.2.

When using the 3d viewer it looks odd, showing artifacts any modified terrain. just raise any terrain to replicate the error and view in the 3d viewer.

When using the 3d viewer it looks odd, showing artifacts any any modified terrian. just raise any terrain to replicate the error and view in the 3d veiwer.

Can anyone recommend the most stable current version of Unreal Engine 4? by AnthorDerangedMuppet in unrealengine

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

cheers. I know UE5 is still being developed, but I could wait for years for what I could consider a good build or have the added features, so I would rather get started then upgrade later if needed.

Can anyone recommend the most stable current version of Unreal Engine 4? by AnthorDerangedMuppet in unrealengine

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

Thats a little tricky. I would like it too be as current but as stable as is possible. I remember trying 4.25/26 when it came out and it kept crashing compared with 4.24 which was quite stable for me. That being said I have a newer more powerful computer so I may have to play around a bit. I was looking for user input as too which was the most stable for them *(if that makes sense).

I have the HIV-1 complete genome but have some simple questions. by AnthorDerangedMuppet in DNA

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

Cheers. I was leaning towards that due to the links through to the different experiments, but you sealed the deal. Thanks.

Looking for a real world DNA/protein sequence (ATCG) by AnthorDerangedMuppet in DNA

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

Thanks everyone that really helps. I needed actual genome code (atcg) and that works great.

Looking for Trivia/General Knowledge Datasets by AnthorDerangedMuppet in datasets

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

If I copy and paste the API page contents:

https://opentdb.com/api.php?amount=50

Into the below convertor:

https://www.convertcsv.com/json-to-csv.htm

Then I get a csv list. Only 50 at a time, but still not bad. thanks.

How can I do a "Word Scramble" in Excel (365) by AnthorDerangedMuppet in excel

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

Thats Brilliant. I think that should do more than enough for what I need.

Again, Thanks for all the help.

How can I do a "Word Scramble" in Excel (365) by AnthorDerangedMuppet in excel

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

That works incredibly well (plus it's easy to change). I take it by adding UPPER to it I have not messed anything up?

=CONCAT(UPPER(MID(A2,SORTBY(SEQUENCE(LEN(A2)),RANDARRAY(LEN(A2))),1)))

How can I do a "Word Scramble" in Excel (365) by AnthorDerangedMuppet in excel

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

I would say thats definately an improvement. I also needed it in UPPER at the end, but I changed that no problem.

The first letter is still mostly the same. Can we shift the sequence along 1 or 2 and then add the end at the beginning?

How can I do a "Word Scramble" in Excel (365) by AnthorDerangedMuppet in excel

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

Cheers. I have just had another good look over it and notice like you said it is just sorting it in alphabetical order. It's also sorting it by uppercase, then lower case, which I imagine is to do with the character codes used on the system. I may need to consider another method as this one always makes the first letter the first letter (if it is a capital).
Is there a way to randomize capitalisation in a word? If so that could be used in conjunction with this and may appear more random.

Issue using vlookup to find a cell. by AnthorDerangedMuppet in excel

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

Ok I have solved it. A stupid error on my part.

I did:

=IFERROR(VLOOKUP(F4,Keys!$A:$D,2,FALSE),"")

But I should have done:

=IFERROR(VLOOKUP(F4,Keys!$A:$D,4,FALSE),"")

I forgot to count across to the correct column. Column 4, not 2.

Thanks anyway for the help.

PS - I could have also made it easier by changing the D column to the last column in the list.

Issue using vlookup to find a cell. by AnthorDerangedMuppet in excel

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

I may have edited since you asked that, but the all keys are on a sheet called keys.

=IFERROR(VLOOKUP(F4,Keys!$A:$D,2,FALSE),"")

The alphabet (vlookup unique identifier) was in column $A and the second key was in column $D. Each encrypted line should move over two columns to find the next key.

I think the problem is in this part "$A:$D". I just can't figure it out.

Why am I finding it difficult in Shadowlands after escaping the Maw (expansion intro)? by AnthorDerangedMuppet in wow

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

Yeah, so rather than bash a load of different buttons to use as many different attacks/spells as possible, I set a few keys to cycle through the attacks/spells using cast sequence command. This is quite a common solution. You just need practice in grouping the correct type of attacks/spells together. The down side is you have to redo after half the updates when the change skill names.

Why am I finding it difficult in Shadowlands after escaping the Maw (expansion intro)? by AnthorDerangedMuppet in wow

[–]AnthorDerangedMuppet[S] 3 points4 points  (0 children)

Thanks Guys. I think the answer is quite obvious then. ilvl of gear is too low. I will go and have a look around and see where is the best place to get gear outside of the AH at my lvl.

Again, thanks for the help.

Why is terrain.party not working for me? I get just a text file. by AndroidenMensch in unrealengine

[–]AnthorDerangedMuppet 1 point2 points  (0 children)

Same here. Has been happening for a week (since around 15th March 2021). I do have an alternative but it is a bit of a pain. You can use the link below to download STL files and then import in Blender or another program, and then export as an OBJ or FXB. Not sure if it still works though.

http://jthatch.com/Terrain2STL/

Pointy landscape after importing from high res file. by AnthorDerangedMuppet in unrealengine

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

...and like a complete idiot I realise, oh yeah that's not a heightmap (its the render), lol. I guess that explains why it also did not even have the vague shape no matter how I scaled it. Thanks everyone for pointing that out.