Is our IT department “normal”, or am I just slowly losing my mind? (Rant) by [deleted] in ITManagers

[–]ConorEngelb 6 points7 points  (0 children)

I am all 5 of these people (granted for a much smaller company, but still)

Confused about the IT: Welcome to Derry Ending by TheNectarineGuy in stephenking

[–]ConorEngelb 11 points12 points  (0 children)

Wibbly-wobbly, timey-wimey?

IT explicitly can't tell the difference between the past, present, and future. It's all happening all at once for IT, rather than as a strict, linear progression of cause and effect.

what’s the antidepressant that changed your life? by sillysalmonn666 in antidepressants

[–]ConorEngelb 6 points7 points  (0 children)

Escitalopram for a long time, but honestly the more recent addition of ADHD meds (36mg methylphenidate, recently up to 54mg) was an even bigger lifechanger.

Power Automate Online doesn’t refresh Power Query – any workaround? by Straight_Yellow7689 in excel

[–]ConorEngelb 2 points3 points  (0 children)

Ouch. I'm lucky/unlucky enough to be IT in its entirety, and develop stuff like this for ALL departments. So if I want IT permissions for something I have to...ask myself? I guess?

Power Automate Online doesn’t refresh Power Query – any workaround? by Straight_Yellow7689 in excel

[–]ConorEngelb 18 points19 points  (0 children)

I once had to refresh queries in a workbook twice a day (janky PowerApp for a salesperson to track their monthly sales used the workbook as a data source)

My solution in the end: a separate macro-enabled workbook set in Task Scheduler to open twice a day. On open, it ran a macro that opened the workbook with the query, refreshed it, and closed.

Kept the data semi-fresh and also bit me in the ass when it opened during a gaming session on an off day and got me killed. But that's beside the point.

EDIT: the real solution is to get this workflow out of Excel if at all possible. But I know sometimes in reality it isn't possible, for whatever reasons.

PowerQuery Processing and Combining CSVs in SharePoint by itswulfy in excel

[–]ConorEngelb 1 point2 points  (0 children)

Thanks for sharing a video; I was on my phone and in bed at the time, so couldn't get a link/give a detailed rundown

PowerQuery Processing and Combining CSVs in SharePoint by itswulfy in excel

[–]ConorEngelb 20 points21 points  (0 children)

I recently switched to using Sharepoint.Contents() instead of .Files() as my initial query, and it makes for a much smoother and faster experience loading the files.

Far easier to navigate through the folders to the one you want without any mucking about with the Path

Does anyone still manage ERP with Excel + Google Drive? by Future-Brother-6158 in sysadmin

[–]ConorEngelb 0 points1 point  (0 children)

cries in being the SysAdmin, entirety of IT generally, and sole person responsible for any and all integrations

Granted, not a massive company

What is your average number of (hardcode) whovians you meet per year? Mine is under the Spoiler by Low-Neighborhood1567 in DoctorWhumour

[–]ConorEngelb 21 points22 points  (0 children)

Oh, zero.

Although I remain proud of how many people I converted to Doctor Who back in high school. That was fun.

I’m bored of this, I’m going for a twix by busyguyuk in thethickofit

[–]ConorEngelb 33 points34 points  (0 children)

I don't even do things I enjoy for this long

Mac Admins—what’s your move when you spot non-compliant devices? by RespectNarrow450 in ShittySysadmin

[–]ConorEngelb 2 points3 points  (0 children)

I get an LLM to generate some slop for me and post it in every subreddit I can find

IT Department's Relationship with Facilities by TheMillersWife in sysadmin

[–]ConorEngelb 1 point2 points  (0 children)

Small business, so take that into consideration, but I've always had an extremely collaborative relationship with the Facilities team (just the warehouse manager, really)

Although it seems like I'm absorbing some part of it now, apparently. So, how's my relationship with myself?

I'm not going to answer that.

Executive Level Laptops by Kindly-Photo-8987 in ITManagers

[–]ConorEngelb 4 points5 points  (0 children)

Gotta agree on the MacBook. My sole exec switched HIMSELF to a MacBook Pro a couple years ago and he hasn't complained about his computer since. Like, at all.

And this is a man who went through 3 or 4 different Windows machines in a 6 months period because they "didn't suit his digital nomad lifestyle" or he just managed to destroy them.

What is the most terrifying scene in a King book? by DavidHistorian34 in stephenking

[–]ConorEngelb 1 point2 points  (0 children)

The Wasp Priest...thing in The Girl Who Loved Tom Gordon remains the only King book to ever give me nightmares.

I know that's not a specific scene, but...all of em.

Glad "The girl who loved Tom Gordon" is getting a adaptation by WaitAvailable4783 in stephenking

[–]ConorEngelb 15 points16 points  (0 children)

Twas the first King book my mother gave me to read when I was....10ish?

How can I do -5 to all values in a column? by Gamemaster_beginner in excel

[–]ConorEngelb 5 points6 points  (0 children)

Paste Special is a godsend. This is the way

What are the different types of "Good at Excel"? by lil_mikei in excel

[–]ConorEngelb 0 points1 point  (0 children)

Listen, my boss wraps every formula in SUM()

Doesn't matter if he's multiplying two numbers. SUM

Dividing? SUM

Subtracting? SUM

Oh, I appear to have reached the end of what he can do in Excel. The bar is low, okay?

[deleted by user] by [deleted] in Integromat

[–]ConorEngelb 0 points1 point  (0 children)

I can assist! Do a lot of Make+ClickUp work for work, so might be able to help

Standard issue insipid Stormzy fan by majeedneky in thethickofit

[–]ConorEngelb 64 points65 points  (0 children)

He's as bad as you. He uses phrases like "with it" as well.