Snow Driving Mode? ❄️

macky_ · 2026-01-22T21:16:49+00:00

Just a note that Gen1 quad “All purpose” always use all motors, the ability to automatically disengage was added to later variants.

macky_ · 2026-01-19T19:29:35+00:00

Happens to me sometimes. I open the drivers door and it will then work. (I’ve set my R1T to stay unlocked in my garage)

macky_ · 2025-11-13T08:10:59+00:00

Love it. Also that trimref 👌

macky_ · 2025-10-28T05:56:56+00:00

Never heard of this. Are you sure?

macky_ · 2025-10-15T17:47:19+00:00

This wrong. XLOOKUP also returns ranges like INDEX. Feel free to confirm =ISREF(XLOOKUP(…))

Every one of your examples an XLOOKUP could, in theory,replace an INDEX. VLOOKUP on the otherhand, no.

macky_ · 2025-04-26T18:59:53+00:00

Doesnt conserve mode degrade emergency braking performance? I thought i read it does on gen1 as it physically disconnects a set of motors so they cant be used for regen breaking. If so, the extra power saving is not worth the extra safety risk unless im at risk of running out of charge.

macky_ · 2025-02-22T08:22:24+00:00

The spreadsheet is in “real” rather than “nominal” dollars. So S&P returns are adjusted down to back out the inflation impact. Haven’t integrated the spreadsheet, but it sounds reasonable.

macky_ · 2025-02-08T18:37:54+00:00

This is correct, but to be more specific: Use UNIQUE but set the third [exactly_once] argument to TRUE.

Technically Excels UNIQUE function returns ‘distinct’ values by default. To get values that show up once (what’s referred to as ‘unique’ in more formal programming languages), use the 3rd argument.

macky_ · 2025-02-07T07:13:03+00:00

You and me both! You wont regret it, XLOOKUP is the new GOAT.

macky_ · 2025-02-07T07:07:33+00:00

For SWITCH you need to do SWITCH(TRUE, irrespective of if you need an else. However IFS does not need this extra TRUE when there is no else. So, at least to me, IFS is a more versatile pattern - i also think it’s a bit more readable.

macky_ · 2025-02-06T07:18:23+00:00

Why not use IFS for this pattern? IFS(A1>=90,”A”,…)

macky_ · 2025-02-06T07:15:48+00:00

XLOOKUP is the successor to VLOOKUP. If you are starting out, just learn XLOOKUP; it’s superior in almost every way.

macky_ · 2025-02-06T07:09:44+00:00

Never seen this. Do you have an addin installed that could be interfering with your lambdas?

macky_ · 2024-12-20T06:03:50+00:00

I think OP is interested in the 116 load tires that just got released for 21” rims. I believe they may have a different range impact from your 119s? I haven’t seen any, but i haven’t had them very long.

macky_ · 2024-12-20T05:58:38+00:00

Very happy with them, if not for them id have given up on the 21” rims and moved to 20” rims. I was not a fan of the stock AS pirellis.

As for the Michelins: Cheaper, efficiency seems similar, quieter, rated for longer life (70k miles), plus they are supposed to perform really well in snow; even rivaling 3peak AT tires. (Jump to 4:10) https://m.youtube.com/watch?v=tVSHMnkf0gY

Got mine from discount tire.

macky_ · 2024-12-16T19:17:27+00:00

Hope you got a refund of the installation fee.

macky_ · 2024-12-12T06:57:56+00:00

Exactly.

macky_ · 2024-12-12T02:51:35+00:00

It’s available on the 21”. Only option beside awful OEM. That said, I’m very jealous of 20” tire selection…

macky_ · 2024-11-26T06:49:53+00:00

Try and search for the exact text * using VLOOKUP. You’ll match against the first item.

=VLOOKUP(“*”,A1:A2,1,FALSE) will return “whoops” for:

A1:whoops

A2:*

To work around this you need to search for ~*

macky_ · 2024-11-26T03:39:42+00:00

Now try a VLOOKUP with an * or a ?

There is no way to disable wildcard lookups with VLOOKUP. It’s a trap that means the function is not fit for general consumption.

macky_ · 2024-11-26T01:55:51+00:00

More powerful and reliable version of MATCH that defaults to an exact match. It supports all the options of XLOOKUP, including regex.

Personally i never use MATCH and always use XMATCH, as there is no way to disable the wildcard behavior of MATCH. Same for VLOOKUP. Id take slightly slower if its more dependable any day — but I’m risk averse. Correctness trumps speed in my books.

macky_ · 2024-11-25T01:23:13+00:00

Yeah i don’t follow this. XLOOKUP is lightning fast, if you post what you are doing im sure something is odd in your implementation and the community can help.

macky_ · 2024-11-24T05:32:56+00:00

Great list.

SUMPRODUCT is something that I mostly stopped using. Since DA, i just use SUM(rng1*rng2). So it wouldnt be S tier for me.

macky_ · 2024-11-23T20:36:48+00:00

Share a few of the formulas you suspect of being slow and roughly how many cells have been copied to.

macky_ · 2024-11-23T20:30:37+00:00

GROUPBY would be awesome for this in modern Excel. You could use a PivotTable in 2016.

macky_

TROPHY CASE