Minimum players count needed

[viper]

All four of my leagues draft just 140 hitters and 90 pitchers. There is no bench. The current projections have 237 AL players and 252 NL players - roughly. Because I modify the CVRC numbers, I would like to reduce the set of needed hitters - why modify a players getting just 70 ABs. I would like to remove all hitters with less than 100 projected ABs - and maybe 150. At a 100 minimum, this will leave 187 qualified players and 196 qualified NL players. My PPOS pool is C/OF. It will have 29 & 32 catchers for each league.

Will these numbers create enough replacement players for your algorithms to properly work?

Also, How many pitchers will be required for valid results.

[Todd Zola]

With the caveat I am philosophically opposed to your suggestion, they are part of the available inventory and thus should be counted....

You will find you adjustments will have no significant impact on the values. Maybe even none, though SB could be SLIGHTLY impacted.

Replacement uses the excel function "large". If you have 120 non-catchers, it will find the 120th HR, 120th RBI etc and set that as the replacement. This is slightly different than how I would do it "by hand", but necessary to automate the process. Chances are, the top-120 of each counting category will be left in your adjusted inventory, except maybe SB, as there could be some speedsters with low AB totals that would have been above replacement. This is part and parcel to my being anti to this concept as some owners may want to bolster their steals and use one of these players.

But if you do follow through with the process, sort by AB or IP and CLEAR CONTENTS, DO NOT DELETE OR CUT as that will mess up the coding.

In general, when working with Excel

SOFT OPERATIONS -- copy, paste, clear contents

HARSH OPERATIONS -- cut, insert, delete