Most Accurate MLB Experts Past 4 Years
Moderator: Baseball Moderators
L0rdB23 wrote:thanks .. now i have another question.. i got stats for every pitcher and hitter last year in excel format.. i dont kno the formula to sort by a certain stat .. i only learned to do sums and vlookups and i dont even remember all of it.. can someone please explain to me how to sort by hrs or n e category.. becuase when i got to sort it just sorts the column but then the hrs dont match the players.. i appreciate n e help u guys can give me.. thanks
kentx12 wrote:I would help but I am lost too. I guess my way of ranking is old school. I sit down after all free agents sign, take a printout of sportsline, yahoo, and espn rankings, add gut feeling predictions and minor league stats, and make 1 hell of a big notebook. After that I try to list players in diffrent stages at a posistion depending on how deep that posistion is then rank by what posistions I need to take in what order. That gives me an idea of a strategy but it never works. At least I have the players ranked the way I want them.
Easy enough.......wrveres wrote:Thanks .. siege ...
forumlas can be tough at first ... but you'll get the hand of them real quick ... I think MLB has a list of them ...
an easy sample using excell...
I want to see home many homeruns per at ab each player got .. or HR/AB ... I'm sure you have heard of this ...
open up your excell and get to the top of the page for all batters ..
in the first blank column ... (should be row 1) type HR/AB ... Directly below that we are going to start a formula .. the 'CEll' (as they are called) should be blank (This should be row 2, column say ... k )so row 2 column K.
Now locate which column has HR's ..... maybe its coulmn F maybe it's coulmn H, for our example its H ... and locat which column has AB's ... our example will be coulmn G ... do ya folow me .. so far?
time to type a formula ...... back to our hypothectical coulmn ... 'K,2'
or column k ... row two written "K,2" in k,2 type =g2/h2
that's it ..hit enter the formula is AB/HR ... ,..
-------------------------------------------------------
filters .....
Click on the very top left hand side .. just above and to the left of A,1 ... the whole range of cells should go dark. ... On the tool bar, click data, then filter, then turn on the auto filter ... each coulmn should now have a little arrow on it. it will allow you to sort real quick.... click top 10 and ask for the top 10 pct HRs ... play around here all ya want .... just don't delete info from here ...
Here you ask excell .... who are the batters that batted .300 and above .... had 15 hr's and a OBP of .400 ... It will tell ya .....using filters ...
if you get lost in the filters .... just go and turn the off and all your data is back to normal, then turn the 'auto filter' on again ...
hope this helps ...
DieHardCubbie wrote:Easy enough.......wrveres wrote:Thanks .. siege ...
forumlas can be tough at first ... but you'll get the hand of them real quick ... I think MLB has a list of them ...
an easy sample using excell...
I want to see home many homeruns per at ab each player got .. or HR/AB ... I'm sure you have heard of this ...
open up your excell and get to the top of the page for all batters ..
in the first blank column ... (should be row 1) type HR/AB ... Directly below that we are going to start a formula .. the 'CEll' (as they are called) should be blank (This should be row 2, column say ... k )so row 2 column K.
Now locate which column has HR's ..... maybe its coulmn F maybe it's coulmn H, for our example its H ... and locat which column has AB's ... our example will be coulmn G ... do ya folow me .. so far?
time to type a formula ...... back to our hypothectical coulmn ... 'K,2'
or column k ... row two written "K,2" in k,2 type =g2/h2
that's it ..hit enter the formula is AB/HR ... ,..
-------------------------------------------------------
filters .....
Click on the very top left hand side .. just above and to the left of A,1 ... the whole range of cells should go dark. ... On the tool bar, click data, then filter, then turn on the auto filter ... each coulmn should now have a little arrow on it. it will allow you to sort real quick.... click top 10 and ask for the top 10 pct HRs ... play around here all ya want .... just don't delete info from here ...
Here you ask excell .... who are the batters that batted .300 and above .... had 15 hr's and a OBP of .400 ... It will tell ya .....using filters ...
if you get lost in the filters .... just go and turn the off and all your data is back to normal, then turn the 'auto filter' on again ...
hope this helps ...
Users browsing this forum: No registered users and 6 guests