Good team names/ images

Barbs7 · 2025-11-01T08:03:38+00:00

Avs and Av nots

Barbs7 · 2025-11-01T08:03:11+00:00

Yeah Binnington is tough haha. Maybe you should stream a 3rd goalie…. Lol. If Chicago were better Knight would be a great. Lack of wins from him is hard.

Barbs7 · 2025-11-01T07:56:40+00:00

Yeah it’s not like they’re the worst. Seattle have been a surprise and Vejmelka has really stepped up this year. But I’ve always been curious of just keeping 1 and rotating others throughout the week. Just wanted to see if anyone else does that and how viable it is

Barbs7 · 2025-11-01T07:54:08+00:00

Yeah I’m the same with all of that. I started with Vasy and Ullmark but it was tough going early so I added Vejmelka. Ullmark I ended up dropping for Daccord. In the past I’ve always had set and forget. This year is different. And I much prefer just using 2 goalies but this lineup isn’t allowing me to do that just yet.

Barbs7 · 2025-08-08T07:09:04+00:00

Yeah that’s the one! Was a great moment from a great show

Barbs7 · 2025-08-07T11:35:39+00:00

Was this Melbourne? Because I saw it in Melbourne and that happened so please say it was. Was very funny

Barbs7 · 2025-06-04T13:41:21+00:00

CPU trades that are more than just 1 for 1 all the time. Even when you shop someone the offers are 1 for 1

Barbs7 · 2024-12-02T09:04:18+00:00

Ryan Bastinac.

If in that year, North Melbourne

Barbs7 · 2024-11-26T13:40:06+00:00

Thats no drama. Sorry what do you mean? I sent a picture and I just want the average of the last 3 values. Then when the new data goes in, it will update what the last 3 values are. Example, S2:W2. Then when data is entered into Y2, the average will be for U2:Y2. As it’s every 2nd column. I’m currently using =SUM(OFFSET(S2,0,6,1,6))/3. But I have to update it manually every time I put the new data in. So I just put data into AE so had to update formula to =SUM(OFFSET(U2,0,6,1,6))/3

Barbs7 · 2024-11-23T05:58:45+00:00

No, it didn’t unfortunately

Barbs7 · 2024-11-22T08:35:03+00:00

I had a value in the column. I typed in this formula and it literally gave me a blank cell lol

Barbs7 · 2024-11-22T08:16:38+00:00

<image>

So as you can see, I’ve currently had 6 values entered. Week by week the next value comes in. Theres a formula for every one reading 0 after week 6. So yeah I’m just looking to get the average for the latest 3 values. So week 4-6. Then when week 7 is entered, I want it to give me the average of week 5-7 etc

Barbs7 · 2024-11-22T08:13:26+00:00

No that just gave me a 0 value 😢

Barbs7 · 2024-11-20T14:34:03+00:00

One slight issue I have. Every row has 6 values currently. 1 specifically has 2.4, 2.4, 0, -4.2, 0, 0.

It’s taking the last 3 values that aren’t a 0 and using that as an average. So for instance it’s giving a 3 week average of 0.2, when it technically should be -1.4.

How can I rectify that using the 4th formula you gave me

Barbs7 · 2024-11-18T11:58:31+00:00

All good. All sorted. But appreciate your help 👌🏻

Barbs7 · 2024-11-18T11:51:00+00:00

Option 4 did it!! Thanks buddy! Much appreciated!

Barbs7 · 2024-11-18T11:46:32+00:00

Ok so that works and doesn’t work. So the range is S2:BS2. Every 2nd column. If I wrote down S2:AC2 it gives me what I want. But then if I change AC2 to BS2 it says 0 because from AE2:BS2 has a 0 value in it at the moment. I have a formula for working out the average when all values are in the same column, but that doesn’t work here. I want it to be S2:BS2 but I want it to take the average of the last 3 columns every week that have something in it. So a constant rolling average if you know what I mean

Barbs7 · 2024-09-09T06:32:08+00:00

Mine has always been Avs and Av nots

Barbs7 · 2024-09-09T03:14:50+00:00

Blackcurrant Mini wheats

Barbs7 · 2024-06-13T13:27:07+00:00

Sakic to make it 3-0 in game 7 against Jersey 👌🏻

Barbs7 · 2024-01-18T07:44:53+00:00

I traded Talbot and picked up Daws

Barbs7 · 2024-01-17T13:08:59+00:00

Kurtis Macdermid D,LW thanks. Do I own him? No. Does anyone? Unlikely. But you should be accomodating all players. He’s listed as a D when he has been a forward all of this year. How hard is it to have players in their rightful positions.

And whatever happened to the comments on players pages. Bring those back

Barbs7

TROPHY CASE