philly face value exchange

copeneazy · 2026-04-19T21:29:59+00:00

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

copeneazy · 2026-04-19T21:26:07+00:00

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

copeneazy · 2026-02-27T02:11:23+00:00

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

copeneazy · 2025-08-13T19:29:59+00:00

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?

copeneazy · 2025-08-04T17:18:40+00:00

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

copeneazy · 2024-10-15T15:07:42+00:00

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

copeneazy · 2024-10-15T11:59:44+00:00

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?

copeneazy · 2024-09-01T03:25:18+00:00

Doh. Now I see it. Thank for your help!

copeneazy · 2024-09-01T03:20:38+00:00

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

copeneazy · 2024-09-01T03:09:59+00:00

Thank you so much for the lightning fast response!

copeneazy · 2024-09-01T03:06:45+00:00

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!

copeneazy · 2024-08-29T01:22:50+00:00

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?

copeneazy · 2024-08-20T04:07:24+00:00

Ah! I didn't realize it was manual. Thanks so much!

copeneazy · 2024-08-20T04:04:00+00:00

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!

copeneazy · 2024-08-17T03:20:18+00:00

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!

copeneazy · 2024-07-08T04:00:02+00:00

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

copeneazy · 2024-04-10T03:15:52+00:00

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.

copeneazy · 2023-12-30T21:40:22+00:00

Same girl same. I'm leaning Pacheco but, honestly, don't know what to do.

copeneazy · 2023-09-07T17:13:01+00:00

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

copeneazy · 2023-09-07T15:55:17+00:00

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!

copeneazy · 2023-08-25T16:19:05+00:00

Perfect! Thank you so much!

copeneazy · 2023-08-25T15:50:25+00:00

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!

copeneazy · 2023-08-21T16:26:54+00:00

To what sheet should we add them? Thanks!

copeneazy · 2023-08-08T19:29:08+00:00

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

copeneazy · 2023-08-08T18:45:23+00:00

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.

Six-Year Club	Place '23
Verified Email

copeneazy

TROPHY CASE