Okay, thought I might give you a peek at what I'm up to right now... explanation below the pic:
First step is to paste in the MLB.com scheduled matchups (first two columns). The spreadsheet then pulls the following information:
- park factor
- SP's O-Swing%
- SP's SIERA
- opponent's OPS rank overall, at home, away, vs. LHP, an vs. RHP (last two are hidden)
If any of the following criteria are met, "NO" appears in the 3rd column:
- bad park factor
- O-Swing below 29%
- SIERA below 3.75
- opponent's OPS rank is better than 20th overall or home/away (whichever is applicable)
If none of those criteria are met, "CHECK" will appear in the 3rd column (see J.A. Happ). At this point, I will pull up the info for any SP with "CHECK" next to them and first see if he is owned. If he is, I can put an "x" in the last column and the 3rd column will change to "NO".
If he's unowned, I'll look at his recent history. If I don't like it, I can put an "x" in the last column to change his status to "NO" (even though he isn't owned).
If I'm cool with his recent history, I can then drop "L" or "R" (whichever he pitches with) in the 2nd column right next to his name (see J.A. Happ again). This will grab the appropriate opponent OPS rank vs. LHP/RHP and fill in that field. If that rank is better than 20th, the 3rd column will change to "NO." Otherwise, I've got a good streamer and just need to go research more in depth stuff if I want (e.g. heads up history).