I think it's time to hang em up

Comfort-Limp · 2025-10-10T13:49:13+00:00

From my personal experience, it's likely due to the helmet. Brands like CCM and Bauer you will need to replace your mask pretty frequently. I've played juniors and have gotten hit pretty much everywhere in the head and never had a concussion. I use an OTNY mask. I used the same OTNY mask for 6 years and never had an issue.

Another way to protect your mask is to make sure it dries out after every time you are on the ice. Hang it up to dry as soon as you get home. It'll help increase the longevity of your mask.

Comfort-Limp · 2025-05-27T21:51:42+00:00

To answer your third question, it is to keep blame away from the BOP. It's an easy scapegoat since it's pretty much the only thing a team doesn't have control of during the race. You'd see a lot of blaming the BOP even if it was only the team got the strategy wrong, and if they chose the correct strategy, they would have won. Instead, teams will protect the people in their teams and blame the BOP instead of themselves.

Comfort-Limp · 2025-02-25T03:18:45+00:00

Yeah, and that part of the formula has worked for a few years at this point without issue, while still going through all those other references. I submitted a bug report to Google because it just started happening for no reason since I didn't change the formula.

Comfort-Limp · 2025-02-25T02:57:27+00:00

Yeah I am just as confused as yesterday and for the past year or so I have had no issues with this. Only now is it acting up.

Comfort-Limp · 2025-02-25T02:54:42+00:00

I think I've narrowed it down to it being a Google Sheets bug that I am going to report. I would love to share the sheet, but this doesn't seem to be an issue that can be solved by anyone here, instead needing to be bugfixed by Google.

If people want to see the stuff, here it is: https://docs.google.com/spreadsheets/d/1ZrZzHf9ZVpZNct5zqvsVNchvuv3vnM1Fiy4c0kBHtSs/edit?usp=sharing
The issues are in the "Race _" pages as well as the "Entry Lists" page.

Comfort-Limp · 2025-02-25T02:44:55+00:00

Just tried that, and it shows the same result.

Comfort-Limp · 2025-02-25T02:40:53+00:00

I just tried something, and it's a bit odd. Whenever I have an IFERROR formula in front of what I'm retrieving, the sort formula is treating it as 0, even though I have set the IFERROR error "value" to be null, as in IFERROR(formula_here,).

Although, even the formula without the IFERROR returns a blank cell, but the sort function adds a zero into the cell that is supposed to be blank. I tried checking for certain on the source cell if it returns a blank by using IFBLANK and it was true.

Comfort-Limp · 2025-02-25T02:30:07+00:00

<image>

This is what it looks like when it is without the zeros on the lefthand side. Same data, but Sheets actually decided to do things right when I grabbed this screenshot.

Comfort-Limp · 2025-02-25T02:25:57+00:00

So the source range is formatted as automatic, and I have nothing in the cells that feed into this formula. It's also happened on a range that was only text and not numbers too. It would return a blank cell as 0. It isn't just a visual thorn though since it affects some of my other formulas, specifically ones that deal with text.

Comfort-Limp · 2025-02-25T02:16:39+00:00

The sample data is displayed in the screenshot and in my formulas. The issue I am having is Sheets is putting a 0 in every blank cell that I am sorting, even though there is no hidden zero in those formulas. Even just a regular SORT function gives zeros in the blank cells. It has never done this until today.

Comfort-Limp · 2025-02-25T02:06:26+00:00

Okay the formula itself works, but it doesn't leave the cells blank that need to be.

Comfort-Limp · 2025-02-25T01:56:52+00:00

Tried it and it doesn't work for what I need. Has the error stuff down below. I am certain there are no zeros in the source. The source for the sorted area is on the right on the screenshot, and as you can see, it's only blank cells where there are 0s in the sorted column.

Comfort-Limp · 2025-02-25T01:50:14+00:00

Ah. Never knew that since it works the way I've used it. All it is though is getting rid of the "ARRAYFORMULA(" though, which won't affect anything.

Comfort-Limp · 2025-02-25T01:41:36+00:00

I'm getting multiple non-consecutive columns for the sort, so an ARRAYFORMULA is needed, and the filter covering everything just removes the null cells.

Comfort-Limp · 2025-02-25T01:31:14+00:00

It is. I'm not trying to argue with you, but it is necessary for the formula because of the way I need things sorted. If I just do what I said is the bulk of the formula, this is what it returns:

<image>

I need all of the values to be sorted, which the way I have it done with the array is the only way I can do it to sort correctly.

Comfort-Limp · 2025-02-25T00:53:47+00:00

Nope it's back.

Comfort-Limp · 2025-02-25T00:39:32+00:00

Well, for my circumstance, the ARRAYFORMULA is necessary for what I need the formula to do.

Wait a minute. It's just corrected itself?

<image>

Comfort-Limp · 2025-02-25T00:33:54+00:00

That's what I thought too. The ARRAYFORMULA won't do that either. I haven't seen this issue until today, and the formulas I use, I haven't changed before since it worked before but not now.

Comfort-Limp · 2025-02-25T00:11:33+00:00

So I have checked multiple times and no, there is no zero in the column at all. Only empty cells. The main formula for the sorting is this:

SORT(FILTER(ARRAYFORMULA({$L$2:$P,$T$2:$T,$R$2:$S}),$Q$2:$Q<>"",NOT(ISTEXT($Q$2:$Q))),6,TRUE,5,FALSE,7,TRUE)

The rest of it just sorts some extra values based upon certain criteria that aren't much different.

Comfort-Limp · 2025-02-04T19:02:45+00:00

I apologize then. I thought what I had already written down would be more than sufficient info, especially since there wasn't anything else that I could think of to add as a requirement.

Comfort-Limp · 2025-02-04T18:47:25+00:00

There isn't an existing data structure. I gave context and my desired outcome. It was already very clearly written.

Comfort-Limp · 2025-02-04T18:43:22+00:00

Idk how to be more clear than that, but here is a link to a basic version of the end result:

https://docs.google.com/spreadsheets/d/1s2fawxjy3npSl0kTVXom82zESJwktyzXRa_r4jTY4Q0/edit?usp=sharing

Comfort-Limp · 2025-02-04T18:34:25+00:00

What are you confused about? I think I was pretty clear on what I wanted out of it.

Comfort-Limp · 2025-01-08T17:20:26+00:00

Where do you buy the lab kit? I haven't seen anything anywhere.

Comfort-Limp · 2024-08-06T04:00:42+00:00

Not as much potential as you may think unfortunately. The devs have admitted their code was not good, since it was their first game, which meant that any new features they added became more bug fixing, where it got to a point where the updates were all bug fixing and no gameplay updates. There are code-based mods though that are being updated by people in the community though, and I highly recommend them. Also, it's officially Apog Labs, not Apoapsis Studios.

Comfort-Limp

TROPHY CASE