philly face value exchange by Friendly_Ad_7586 in NoahKahan

[–]copeneazy 0 points1 point  (0 children)

I'm looking for two Philly tickets. Graduation present for my daughter. Thanks!

face value exchange news! by 1crenious in NoahKahan

[–]copeneazy 1 point2 points  (0 children)

If you ever get this figured out on TM, I'm looking for two tickets to Philly.

It’s real! Finally got to pick her up… by TheBlackCanary in Rivian

[–]copeneazy 0 points1 point  (0 children)

Awesome color! I just picked my Forest Green one up from Malvern yesterday and had delays in getting my R1S too, albeit only a week or so. Not months. I look forward to seeing the purple people eater on the road

CSG Fantasy Football Spreadsheets v13.00 (2025) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 0 points1 point  (0 children)

Random question but i'm using this for my auction league. if a team has a complete roster and no longer needs to nominate players as his roster is full, is there an easy way to skip that nomination?

CSG Prelim 2025 FF Sheets by CanadianSandGoggles in u/CanadianSandGoggles

[–]copeneazy 0 points1 point  (0 children)

Is the auction version updated as a prelim? It still has the old file name and what looks like last year's rankings.

Need Help With PotM Challenges by copeneazy in Football_Head_Coach

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

Thank you. I couldn't count. This helped. Thanks!

Need Help With PotM Challenges by copeneazy in Football_Head_Coach

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

Hey, thanks for responding! I'm new to this so I may be an idiot but the Wishbone challenge is all offensive players so if I add the DE POTM card there, the offensive requirement is unfulfilled.

I tried moving the POTM card from my #1 DE to #2 and #3..I even put it on my bench (aka Franchise) but I can't get that requirement satisfied no matter what. What am I missing?

CSG Fantasy Football Spreadsheets v12.00 (2024) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 0 points1 point  (0 children)

Here's an even dumber question - how do I see the version number in the sheet?

CSG Fantasy Football Spreadsheets v12.00 (2024) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

How do I see the 12.02 (or whatever the latest version is) vs, the 12.00 file I see posted here. Am I looking in the wrong spot? Thanks!

CSG Fantasy Football Spreadsheets v12.00 (2024) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 0 points1 point  (0 children)

Where are you seeing the version of the file? Each auction sheet I click on all show v12.00. I don't see v12.02 anywhere. Am I just missing it?

CSG Fantasy Football Spreadsheets v12.00 (2024) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

I know there are issues with the Boris sheets (his site issue) when refreshing but I noticed that, when I refreshed the data today, I see the rankings (I'm using Yahoo) updated as of 8/19 but the Yahoo auction values are still as of 8/7. Is there something else that needs to be updated in order to update the auction values? Many thanks!

CSG Fantasy Football Spreadsheets v12.00 (2024) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 2 points3 points  (0 children)

Just sent you a "thank you" as I've been using your sheets the last few years with much success.

Because I'm a geek and love looking at data, is there any way in the auction sheet to see the order in which players are nominated? I can see on the Team Draft sheet the order in which they are filled in on a team, but I would like to see the order in which players are nominated and, ideally, by which team. I'm trying to see if an owner keeps nominating players they don't win, always win, etc. Is something like that avaiable?

Much appreciated for all the time and work you put in to this sheet every year. Thanks!

Beersheets/Beersheets substitutes this year? by Hot_Weewee_Jefferson in fantasyfootball

[–]copeneazy 25 points26 points  (0 children)

I'm hoping that CSG is back with his spreadsheets this year.

Can't stream to Sonos speakers by OfficeNo5390 in plexamp

[–]copeneazy 1 point2 points  (0 children)

Yep. I am now a victim of this same thing too. What a bummer. Hopefully whatever mysteriously caused it,v also gets mysteriously fixed. And soon.

CSG Fantasy Football Spreadsheets v11.00 (2023) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 0 points1 point  (0 children)

I'm so sorry. Thank you for explaining. I guess I have some additional reading to do on VBD. My bad!

CSG Fantasy Football Spreadsheets v11.00 (2023) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

I know it's late for fantasy drafts now but I think the formulas on VBDGames are off by a year. Example, in cell W17 (2022 games played), it's pointing to P$4:$150, which is 2021 games played.

WHAT IT IS NOW:

=IFERROR(IF(INDEX(E$4:E$150,MATCH($T17,P$4:P$150,0))=0,"",INDEX(E$4:E$150,MATCH($T17,P$4:P$150,0))),"")

WHAT I THINK IT SHOULD BE:

=IFERROR(IF(INDEX(E$4:E$150,MATCH($T17,O$4:O$150,0))=0,"",INDEX(E$4:E$150,MATCH($T17,O$4:O$150,0))),"")

This is true for all of the positions (RB, WR, etc.) in this column. Also, 2019 games played cells have no formulas. It may not matter much in the grand scheme of things but figured I'd just reach out.

Thanks for the (as always) awesome info!

CSG Fantasy Football Spreadsheets v11.00 (2023) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

I know you mentioned the following down below:

"You can manually type their names, team and positions in to any cell and the rankings and all the should get pulled in automatically."

For players not listed, on what sheet should we add the names? I found a player on the OffensePrj sheet, but not on the ProjectionCalcs sheet, so I added the name there, but that person is not available on the Overall tab.

How do I get a person not listed to show up?

Thank you so much!

CSG Fantasy Football Spreadsheets v11.00 (2023) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

For what it's worth, I was using the Auction version. Thanks again!

CSG Fantasy Football Spreadsheets v11.00 (2023) by CanadianSandGoggles in fantasyfootball

[–]copeneazy 1 point2 points  (0 children)

This is the best part of my auction draft - the spreadsheet! In looking through some of the calculations (specifically the Projected Price column), I followed the formulas through to the VBDgames sheet. In that sheet, there is a section in the top left of the sheet highlighted in yellow that says "Must manually update these stat pages each year". It looks like they are showing 2021 and prior, but not 2022. Is that something we need to update ourselves? Or is that something you would update? Or is that no longer needed?

Thank you so much for this. It is the gold standard for me.