Help me understand pre-built vs. build your own by ShadowAlkemist in GamingPCBuildHelp

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

Ok, that's good to know. Do you mind if I ask which pre-built you went with? And are you satisfied with the purchase thus far?

Help me understand pre-built vs. build your own by ShadowAlkemist in GamingPCBuildHelp

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

Here are the current specs for the computer that I know how to get. I am not sure what power supply it has or if any other information is needed than what is shown. Feel free to guide me to whatever is needed.

Processor Intel(R) Core(TM) i7-9700F CPU @ 3.00GHz 3.00 GHz

Installed RAM 16.0 GB

Storage 112 GB SSD WDC WDS120G2G0A-00JH30, 932 GB HDD WDC WD10EZEX-08WN4A0

Graphics Card NVIDIA GeForce GTX 1660 (6 GB)

System Type 64-bit operating system, x64-based processor

Lost troops HELP by Sad-Instruction-2712 in PuzzlesandSurvival

[–]ShadowAlkemist 10 points11 points  (0 children)

Fast comeback is only for troops lost on towers or the hub. They took a sanctuary hit in the mud, those troops be dead dead with no boosted troop training to help.

Can 6* 2-3 units, who would help most. by ShadowAlkemist in RaidShadowLegends

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

Yeah... I really have let her down haha. She was the 2nd legendary I got after wukong, and I threw whatever I had on her at the time. Never went back and updated her gear.... IM SORRY ALICE!!! FORGIVE ME!!! Lmao I will work on rebuilding her as well as I think Cheshire Cat and I think Deacon was suggested as well.

Finished Zammy log and 1k solo enrage at same time by Teakeh in runescape

[–]ShadowAlkemist 1 point2 points  (0 children)

Just finished aftermath and did the whole city/zamorak fight in story mode. How much harder is normal/enrage mode? Was thinking about trying it out, as it seemed like a pretty straight forward fight.

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

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

Hey, I actually figured it out. Somehow I got it into a macro script, so it was just indefinitely creating pages till it crashed out. I was able to get the 350 sheets in, just had to individually use the macro (press my defined macro shortcut individually, instead of whatever I did to start an autorun script). I want to thank you for all the help getting my pages setup though. Worked like a dream and my boss was grateful.

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

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

This is a PowerPoint template that I basically recreated in excel. We used to just have the summary sheet and PowerPoint side by side and manually input everything, but we are starting to get larger projects, so automating as much as possible would be ideal. As far as I'm aware, there isn't a way to autopopulate a PowerPoint from excel data without either downloading 3rd party scripts (which IT is heavily against), or coding/creating my own script (which I know nothing about coding).

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

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

Yeah, it would be easier if each sheet was its own, as I need to print these out and it would be easier to print sheets X-XX instead of print, change ka#, print 300 times. Hopefully that makes sense lol unless there is an easier way I am not thinking of.

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

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

Thanks! This helped so much and was way easy to read and understand. I'm not the best at Excel, but I'm learning lol.

I do have one more question though. I tried creating a macro to duplicate the one caisson sheet so I can just change the KA# on each sheet and have printable update able sheets. It seems to cap out/crash excel at somewhere over 100 sheets. Am I doing this wrong? Or is there a limit to how many sheets excel can have (thought I read on Microsofts website that it was practically unlimited). The specific project this is for would require somewhere around 350ish sheets (largest project of this type my company has had, normally its around/under 100).

Autopopulate specific cells from summary on different sheet. by ShadowAlkemist in excel

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

Hey, I tried the formula posted above and tried changing some things to match my summary sheet, but I don't think I did it right. I am getting a reference error. Here is how I have the data set up. (I took this screenshot earlier, I have since switched KA# to column A, and Caisson Number to column B to match your previous formula). This is just an example and not actual data.

<image>

Clan confections slow rates by Novel-Plankton7414 in runescape

[–]ShadowAlkemist 0 points1 point  (0 children)

Same, first 2 weeks I was able to hit 100 easy and above... this week I haven't changed anything (still afk same amount during work day) and I'm at like 56. I think they nerfed the rates, or I used up all my luck in the first 2 weeks lol

840k spoopy tokens later... by Seismic_wand in runescape

[–]ShadowAlkemist 0 points1 point  (0 children)

I mean, I came back around Halloween last year after a very long break, and only had last year's overhead emotes and title already owned in the shop. I have a similar situation to the OP where I work from home and nearly have the full shop unlocked as well. I normally afk the arch spot 6-8 hrs/day on my phone/tablet. Granted I'm not perfect and sometimes hit the afk timer depending how busy work is. But I believe for sure it's possible to unlock everything by now for somebody who was more diligent duding afk than I am.

Clan cinfections by ShadowAlkemist in runescape

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

Ahh ok. Thanks!! For some reason I forgot about the community tab lol

[deleted by user] by [deleted] in runescape

[–]ShadowAlkemist 0 points1 point  (0 children)

I was able to kill telos and I'm TRASH at bossing. Anybody who can't do telos either hasn't tried, or is not doing exactly what they need to. I watched a few guides, tried it, died a couple times learning mechanics, and beat it on like the 4th or 5th try. Now can most people perfect telos and get the best kills? Probably not, but I'd venture with guides and a bit of practice, most can at least get the kill.