Multi-eligible Position Players in CVRC

Ask questions or post comments concerning the CVRC, START or the Team and Player Tracker
Post Reply
Message
Author
User avatar
Kelly_Leak
Major League All-Star
Posts: 297
Joined: January 28th, 2009, 10:19 am
Preferred Style: 5x5 AL-only Auction
Location: Hartford, CT

Multi-eligible Position Players in CVRC

#1 Post by Kelly_Leak »

First, it appears that the PPOS and the QPOS columns are switched on the VALUES tab. For example, Victor Martinez's PPOS equals "C1B" and his QPOS equals "C".

Also, for some reason multi-eligible position players (like Victor) are not being displayed on the RANKINGS and RANKINGS$ tabs when the "POS RANKINGS", "GRID RANKINGS", "GRID RANKINGS WITH $", and "POS RANKINGS WITH $" buttons are pushed. I tried debugging the issue, but (for obvious reasons) the Leauge_Set_Up tab is password protected.

Thank you for all the hard work!
10 Team 5x5 (OBP) AL-Only; 100 FAAB; *6 Keepers
1C: J.Lucroy; 1B: H.Ramirez; 2B: A.Cabrera; 3B: A.Bregman*; SS: R.Martin; MI: M.Semien; CI: C.Davis; OF: C.Stewart, T.Pham*, C.Mullins, J.Bradley, E.Jimenez*; DH: N.Cruz
10P: K.Herrera, C.Rodon, B.Snell*, J.Junis, H.Strickland, J.Verlander, M.Givens, C.Roe, T.Cahill, L.Giolito
Bench: N.Lowe, V.GuerreroJr*, J.Choi, F.Whitley, A.Hays
DL: F.Lindor*, B.Zimmer, D.Duffy

User avatar
Todd Zola
Hall of Famer
Posts: 8278
Joined: December 25th, 2008, 12:45 pm

Re: Multi-eligible Position Players in CVRC

#2 Post by Todd Zola »

thanks -- i keep forgetting to fix the column headings for the positions. I c/p from one to another to do the values and the heading gets c/p as well.

I'm a creature of habit, most of them bad.

As for the multi-player thing, i will look into it
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord

I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord

Always remember, never forget, never say always or never. - The Forum Funklord

You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord

User avatar
viper
Hall of Famer
Posts: 1474
Joined: December 31st, 2008, 11:32 pm
Preferred Style: Currently in an AL-only league with the Bill James Technical RCA as the single hitting category and ERA as the single pitching category.
Contact:

Re: Multi-eligible Position Players in CVRC

#3 Post by viper »

which is the column we can manipulate if we want a C&OF only mix or a C&CO&MI&OF mix
The avalanche has started. It is too late for the pebbles to vote. -- Ambassador Kosh

Mike Ladd
Buffy, the Umpire Slayer

User avatar
Todd Zola
Hall of Famer
Posts: 8278
Joined: December 25th, 2008, 12:45 pm

Re: Multi-eligible Position Players in CVRC

#4 Post by Todd Zola »

Okay, here's the deal...

I'm a moron.

Okay, here's the deal, part II

The intended order of the three columns with positions is...

D: MVPOS most valuable position. This is read by the rankings page to assign positions.
E: QPOS qualifying positions. This is purely aesthetic, listing eligibility based on the official rulebook
F: PPOS pool position. This is what the CVRC uses to determine replacement.

Viper -- the answer to your question is F:PPOS

Kelly -- the reason the multi guys are not showing is I have D and E reversed. You can c/p each into the correct column (cut/insert will not work) or wait until Sunday when we post the new update and I promise it will be correct.

Did I mention I am a moron?
Catchers are like prostate exams -- comes a time where you can't put if off any longer, so you may as well get it over with and take it up the butt - The Forum Funklord

I'd rather be wrong for the right reasons than right for the wrong reasons - The Forum Funklord

Always remember, never forget, never say always or never. - The Forum Funklord

You know you have to seek therapy when you see one of your pitchers had a bad night and it takes you 15 minutes to find the team you have him on. - The Forum Funklord

User avatar
viper
Hall of Famer
Posts: 1474
Joined: December 31st, 2008, 11:32 pm
Preferred Style: Currently in an AL-only league with the Bill James Technical RCA as the single hitting category and ERA as the single pitching category.
Contact:

Re: Multi-eligible Position Players in CVRC

#5 Post by viper »

a damn smart one however
The avalanche has started. It is too late for the pebbles to vote. -- Ambassador Kosh

Mike Ladd
Buffy, the Umpire Slayer

User avatar
Kelly_Leak
Major League All-Star
Posts: 297
Joined: January 28th, 2009, 10:19 am
Preferred Style: 5x5 AL-only Auction
Location: Hartford, CT

Re: Multi-eligible Position Players in CVRC

#6 Post by Kelly_Leak »

Hahaha! I work in excel, access, and VB daily and it seems like at least once a day I have an "I'm a moron" moment!
10 Team 5x5 (OBP) AL-Only; 100 FAAB; *6 Keepers
1C: J.Lucroy; 1B: H.Ramirez; 2B: A.Cabrera; 3B: A.Bregman*; SS: R.Martin; MI: M.Semien; CI: C.Davis; OF: C.Stewart, T.Pham*, C.Mullins, J.Bradley, E.Jimenez*; DH: N.Cruz
10P: K.Herrera, C.Rodon, B.Snell*, J.Junis, H.Strickland, J.Verlander, M.Givens, C.Roe, T.Cahill, L.Giolito
Bench: N.Lowe, V.GuerreroJr*, J.Choi, F.Whitley, A.Hays
DL: F.Lindor*, B.Zimmer, D.Duffy

Post Reply