Post by mike2185 on Jan 28, 2017 17:21:26 GMT -5
Hey everyone,
First I want to say that I did not create this spreadsheet but find the info very valuable when building my fantasy lines.
Here is the data that I am working with:
The top row is the amount of FDP scored and the corresponding column is the % of times that player has reached those points.
What I want to do is find how many points the player needs to reach 5x their value ( which I already know how to calculate) and then have a corresponding column that pulls the percentages from the data above and gives me a some of how many times that player reaches or surpasses the amount of points they need to reach value.
I can pull the data from one column, but cant figure out how to combine the multiple columns.
Thanks in advance for your help!
Mike
First I want to say that I did not create this spreadsheet but find the info very valuable when building my fantasy lines.
Here is the data that I am working with:
The top row is the amount of FDP scored and the corresponding column is the % of times that player has reached those points.
What I want to do is find how many points the player needs to reach 5x their value ( which I already know how to calculate) and then have a corresponding column that pulls the percentages from the data above and gives me a some of how many times that player reaches or surpasses the amount of points they need to reach value.
I can pull the data from one column, but cant figure out how to combine the multiple columns.
Thanks in advance for your help!
Mike
