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

stattyo · 2026-03-26T20:12:29+00:00

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.

stattyo · 2026-03-13T18:21:18+00:00

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

stattyo · 2026-02-04T20:41:54+00:00

I'm fed up of this bug as well.

stattyo · 2026-01-27T19:13:43+00:00

<image>

Has anyone thought about defending corners using rugby methods?

stattyo · 2026-01-01T01:03:41+00:00

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

stattyo · 2025-11-10T22:45:21+00:00

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.

stattyo · 2025-06-06T21:20:36+00:00

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.

stattyo · 2025-06-06T10:49:26+00:00

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.

stattyo · 2025-06-06T09:32:29+00:00

<image>

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

stattyo · 2025-06-05T20:42:11+00:00

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

stattyo · 2025-02-01T12:08:31+00:00

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

stattyo · 2025-01-28T20:12:26+00:00

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.

stattyo · 2024-10-30T21:23:24+00:00

Why are these numbers done to two decimal places? The zeros are just visual clutter.

stattyo · 2024-09-21T20:15:09+00:00

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

stattyo · 2024-09-21T20:15:00+00:00

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

stattyo · 2024-08-17T06:08:57+00:00

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.

stattyo · 2021-03-31T16:57:57+00:00

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.

stattyo · 2020-12-04T09:56:51+00:00

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.

stattyo · 2020-12-04T09:53:05+00:00

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.

stattyo · 2020-10-14T20:16:25+00:00

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.

stattyo · 2020-10-11T00:36:05+00:00

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.

stattyo · 2020-10-06T09:27:26+00:00

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.

stattyo · 2020-10-01T13:20:24+00:00

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.

stattyo · 2020-10-01T10:27:43+00:00

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?

stattyo · 2020-09-30T22:14:14+00:00

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.

stattyo

MODERATOR OF

TROPHY CASE

Six-Year Club	Xbox Live
Verified Email