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!
Multi-eligible Position Players in CVRC
- 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
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
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
Re: Multi-eligible Position Players in CVRC
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
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
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
- 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
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
Mike Ladd
Buffy, the Umpire Slayer
Re: Multi-eligible Position Players in CVRC
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?
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
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
- 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
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
Mike Ladd
Buffy, the Umpire Slayer
- 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
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
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