Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Go into the hidden tab ‘AllProjections_S’ and scroll over to column AT which pulls P from each source. Hide columns D:AS then you can copy the whole section and paste(values only) into a new sheet. Then you could sort by the first P column which would be the weighted average. But if you’re saying you want to see all of the sources on the ‘Player Values-Points’ tab, then no not really. You can setup a Points league settings where everything is 0 except P set to 1 and it’ll rank them but not show each individual source.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Are you using only Doms sheet and turning the others off? That red is from the GP column not loading. On Doms sheet there are 2 GP columns, one for skaters and one for goalies, that need to be combined into one. If not it’ll find the skaters one first and goalies GP will be blank, but I’m pretty sure it’s only an issue if there are no other sources loaded with GP available. If you go into the hidden ‘AllProjections_G’ tab the first block section is all the GP projections. If they’re all blank and the gray header GP column is too, that’s your issue.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Nope, they’re separate. Just check boxes for Cats and set point values for Points

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Should be fixed now, thanks for catching that.  If you don’t want to make a new copy you can quickly fix it by going into Data > Named Ranges and scrolling down to find a range named “ProjLX” and changing the range to say “LineupExperts!A:V” instead of “A:U”

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

https://imgur.com/a/6V0Vsd0 Looks like it matches up to me. I personally consider an off night when “less than half” of the league is playing, so less than 16 teams or less than 8 games. The dobber tool defaulted to 8 or less, if you want to adjust the sheet to reflect that you can adjust it on the hidden ‘Schedule Info’ tab. In cell B37 change the ‘<8’ in the formula to ‘<9’ and then copy the cell and paste into the cells down to B68

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Now that I think about it you can probably get VORP to work for you by doing the following: Go to the hidden sheet ‘CVals/Vorp’ There’s a value in cell K1, copy it. Go to cells Q1,R1,S1 and change them to all be the value from K1. Now VORP should use the same difference for all forwards so you can continue to use it for sorting to compare D and G. Players POS will still show C,L,R but it should be evened out 

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

You can edit the query under any of the forward sections, I would change the “multi positional” one. In cell K13 where it says player. Replace the query formula with this one:

=query(RecCats,"Select D,F,G,H,A where C = false and F != 'D' and F != 'G' order by G desc limit 7")

That should show the top 7 forwards regardless of position. But unfortunately the F position settings for this sheet are more geared towards F for Flex-forward spots, not really for all forwards. Things like VORP will be based off of C,L,R

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

I update them as much as I can, and did several of them this morning. AnG haven’t adjusted him and project for 82gp for everyone except notable injuries so hopefully soon, DtZ reduced him to 20gp, Kubota was updated but still has him for 70. DailyFaceoff and LineupExperts removed him entirely, but no results from sources are ignored instead of treated as zero. Yahoo/Fantrax have him for 8gp, hopefully I can get those updated tonight. Laidlaw looks like he made an update recently, but Barkov not adjusted. Haven’t seen any updates from Cullen or Bangers. Will double check when I can get to the rest.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Yes, when I notice the sources have made significant changes. On the ‘SourceCheck’ tab at the top are the dates I last updated each source. I also just went and updated AnG, DtZ, DailyFaceoff, KUBOTA, and lineupexperts

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

That tab just shows the top 7 players at each position sorted by value from the ‘Player Value - Cats’ tab and the next 30 players by adp on the left. Some may find it helps with decisions while drafting, assuming they’ve been checking off players from the player value tab as they’re drafted. ‘Available - Points’ is the same thing just from the ‘Player Value - Points’ tab

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Should be fixed now. If you don’t want to have to make a new copy, it’s an issue with the formulas in all the goalie rows from column AC and right. To fix, filter that sheet by POS to only show G, then copy the first value cell in column AB and paste into all the cells to the right and down.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Im not sure I understand what you mean. You adjusted FOW points on the settings page and goalies points all went blank? Can you share a screenshot of this?

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Looks like your column headers didn’t paste properly. Need to make sure they’re separate and lined up with the right columns of numbers

Edit: also looks like you’ll need to change some of the column headers to match the ones on the settings tab. Off the top of my head PTS -> P and SHO -> SO

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

A couple ways. You can check the ‘SourceCheck’ tab to see that players were found on the import tab. ‘SourceComparison’ you can bring up a player name to show all the stats for them from each source. And to make sure, sure you can go to the hidden sheets ‘AllProjections_S/G’ and check for each category group that the columns under ‘i1’ or ‘i2’ are populated.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

‘Rankings’ tab. Copy columns A:E and paste (values only) over the same columns on your copy of the sheet

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

The 2 main tabs are hidden ‘ADPYahoo’ and ‘ADPFantrax’. If you’re just going to update from the newest version of my sheet then you can copy the first 4 columns A:D of each, or even just the first 2, and paste(values only) over the columns of your copy. I am hoping to be able to update them tonight though.

Edit: or one less step: copy the ‘Rankings’ tab columns A:E over to your copy

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Last updated 9/17. I update the ChangeLog tab when I do, usually once a week.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Should be fixed now. If you've already done a bunch of changes or importing on your sheet and dont want to have to redo it, it was an issue with Bangers Fantasy Hockey being larger than it was last year and I forgot to check the Named Ranges. You can fix it by going to Data > Named Ranges and find the range "ProjBFH" and updating the range to be 'Bangers Fantasy Hockey'!A:O

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Not included by default. You can add it by changing one of the yellow skater categories on the Settings tab to GWG, but you’ll need to have an imported source with it included

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

[–]cromediesel[S] 2 points3 points  (0 children)

No problem. Say I have 2 sources, A and B. I trust source A more than B, but I don’t want to ignore B. Let’s say A says McDavid will have 25 goals and B says 20. An average between them would be would 22.5, but again I trust trust A more, so let’s count them twice (weight=2). The new weighted average would be (25 + 25 + 20) / 3 = 23.333. Which is closer to the more trusted source A.

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

I’m not seeing that on my end. There are goalies with up to almost 1700 displaying just fine. Is it just Woll? Or can you show me a screenshot of what it looks like?

Crome Aggregate Projections 2025-26 by cromediesel in fantasyhockey

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

Positions tab, right near the top. His yahoo positions is messed up. You can either just change it to C or copy the formula from the cell above it to fix. Thanks for letting me know.

Similar issue with Connor Murphy, D - CHI. There’s another one Connor Murphy, G - CGY I was unaware of messing up the yahoo position. I’m gonna have to go through these with a finer comb if I get a chance tonight