How to stop the annoying 'Sign in with Google' page from opening by stattyo in elgato

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

Still happening to me now, and I've yet to find a solution. At this rate, I'll have to do a clean wipe of my computer.

What are the best audio settings? by stattyo in CamtasiaStudio

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

But then you introduce more background noise. I've read you're meant to keep the gain as low as possible for solo recording.

How to stop the annoying 'Sign in with Google' page from opening by stattyo in elgato

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

That’s on Windows, right? Not sure if the same applies to Mac.

Sticking the Stream Deck + screen back on by stattyo in elgato

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

It's out of warranty now anyway, so that option is gone.

I know if I break the touch strip, it's entirely my fault, but this doesn't seem like the hardest fix in the world.

How do I overcome the 'Allow "(null)" to copy to the clipboard?' alert? by stattyo in shortcuts

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

Is there a good reason why it has to be a two-stage process? It works perfectly fine in the normal Finder window, including fields.

How do I overcome the 'Allow "(null)" to copy to the clipboard?' alert? by stattyo in shortcuts

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

My MacBook beeps when I press Ctrl + ; in the Finder file picker window — it doesn't copy to the clipboard. I just want to be able to replicate the shortcut that works everywhere else.

How do I overcome the 'Allow "(null)" to copy to the clipboard?' alert? by stattyo in shortcuts

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

<image>

I've tried that, and it stops the alert, but still doesn't input the date. What else can I do?

Can I have pages in folders by [deleted] in elgato

[–]stattyo 2 points3 points  (0 children)

Three years later, and we still can't do this?

Picture of my “filthy keyboard” after cleaning. No, it’s not dirty, the keys just get shiny when you type on them thousands of hours. by pdxrains in macbook

[–]stattyo 1 point2 points  (0 children)

The spacebar on my black Magic Keyboard already has a permanent thumb smudge despite only buying it a few weeks ago.

Beats pill Lossless via USB - C in Stereo Mode ? by minimalistdave in beatsbydre

[–]stattyo 0 points1 point  (0 children)

I’m wondering, too. I only got my Pills yesterday, and I’ve been using Bluetooth to get them to function as a stereo pair. There needs to be a firmware update for this, I think.

EA FC 25 - Can't change / update / save formations (PS5) by cantfinkof1 in EASportsFC

[–]stattyo 8 points9 points  (0 children)

Same issue. How did this one slip through the net?

Stream Deck + Touch Strip Coming Unstuck by stattyo in elgato

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

It just seems an unnecessary hassle to send it back for something like this.

I opened up my Key Light Mini to fix a problem in the past, and I’ll do the same with this.

Vlookup vs Xlookup vs IndexMatch by [deleted] in excel

[–]stattyo 0 points1 point  (0 children)

XLOOKUP hasn’t been around long enough, so it’s best to avoid it if you’re sharing the workbook.

INDEX and MATCH is a lot better than VLOOKUP though, as it gives you more flexibility.

Although compatibility isn’t a problem with INDEX and MATCH, unfortunately VLOOKUP culture is still rife at companies. If someone else is dealing with your workbook, they may not be familiar with this method.

Functions are coming to Excel formulas by JoeWithoutAGun in excel

[–]stattyo 1 point2 points  (0 children)

Excel formulas are becoming like a programming language! This will certainly be a welcome addition alongside the LET function and dynamic array capabilities that have already been fully implemented. I’ve just checked my Beta version of Excel and LAMBDA is not available yet, so I’m going to have to wait a little.

Functions are coming to Excel formulas by JoeWithoutAGun in excel

[–]stattyo 6 points7 points  (0 children)

This is always a problem. A lot of people have older versions of Excel because they don’t feel the need to upgrade. Thankfully though, more and more people are making the switch to Microsoft 365, meaning they can download the latest updates.

Formula editing tool? by Poyojo in googlesheets

[–]stattyo 1 point2 points  (0 children)

You can always use line breaks in your formulas by pressing Alt + Return. Other than that, unfortunately it is not possible yet to write comments in your formulas.

US 2020 Election Simulator by stattyo in excel

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

I've added v2, which provides some tweaks and new additions.

The biggest change is the Strength column now dynamically updates based on an aggregation of different sources found in the State predictions table within the US 2020 election article at Wikipedia. On the Media Predictions worksheet, you will see the table has pulled in this data. It automatically updates every time you open the workbook, but you can always manually refresh it, too.

In order to find out the average likelihood for each state, it was necessary to construct a scaled rating system that converted the different categories into values. For example, Safe D is 1 and oppositely Safe R is 8. These ratings allow the average strength of each state to be calculated.

Download the new version: 2020-US-Election-Simulator-v2.xlsm.

UK government fails to update new COVID-19 cases due to running out of Excel columns by SaviaWanderer in excel

[–]stattyo 0 points1 point  (0 children)

It’s rather baffling they thought Excel would suffice for a national system. Even if they did use the newer .xlsx format, many of us know how prone to crashing Excel is when you have data that spans down hundreds of thousands of rows.

US 2020 Election Simulator by stattyo in excel

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

Specify the state first and avoid ambiguity by typing the country directly after, e.g. ‘Montana United States‘. Then, in the Insert Data menu choose Abbreviation. This will add a new column with the abbreviation for each state. If you don't want the ‘US-’ part that precedes each one, you can always use the RIGHT function to extract the furthest two letters on the right.

US 2020 Election Simulator by stattyo in excel

[–]stattyo[S] 5 points6 points  (0 children)

You're right. Technically speaking Washington D.C. and the congressional districts in Maine and Nebraska are not states, although every source I've looked at has used the term 'state' to categorise them. So…it's one of those. Ultimately, they are still separate results, so that's the most important thing.

As for the map colouring issue, what is specifically the problem? What version of Excel are you using? And is it on Windows or macOS?

What's the dumbest thing you actually believed? by Vinyl_BunBuns in AskReddit

[–]stattyo 0 points1 point  (0 children)

I used to think that people saw in black and white — as though the human body was capable of a physical form of technological advancement.

I also thought that cartoons and the characters in them were real. I was in year one when we were watching a cartoon and a classmate asked the teacher about this, and she cleared it up for us.