# Add Last 10 average salary to search results
**URL:** https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767
**Category:** Wishlist
**Created:** [March 2, 2021, 4:41am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767 "2021-03-02T04:41:16Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 4:41am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/1 "2021-03-02T04:41:16Z")
Niv – Would it be possible to add a Last 10 column to the table of players generated on the Players page? It’s got average and median, which really don’t vary a lot most of the time, whereas the Last 10 really can show a big difference, especially this time of year. Thanks!
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 4:51am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/2 "2021-03-02T04:51:17Z")
The last 10 and overall averages are on all player pages. Also, this should go in a wishlist topic I think?
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 4:55am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/3 "2021-03-02T04:55:17Z")
[ ](https://dl.dropboxusercontent.com/s/5e7tq380cii36pw/Screen%20Shot%202021-03-01%20at%2011.55.03%20PM.png?dl=0)
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 5:13am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/4 "2021-03-02T05:13:56Z")
Niv – Yeah, that’s great it’s there, but I was thinking also on the list of players you can generate when you click on the Players menu item. A Last 10 column here would be super useful so you don’t have to click thru to each player to see their Last 10.
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 5:47am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/5 "2021-03-02T05:47:19Z")
Ah that’s the search page, not the player page.
Adding more stuff to search makes search slower, and there are already a ton of columns in search results, especially in points leagues. I’m not sure every single piece of information about a player needs to be available in search results.
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 6:29am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/6 "2021-03-02T06:29:11Z")
For sure on there being a lot of info there already and there’s gotta be some limit. I find the Last 10 info to be about the most important thing in doing draft prep, though, and being able to see it in list form for multiple players at once would be a great help this time of year. Swapping it in for avg or median would be my vote. But I know you can only fit in so much. One way or the other, I’ll get my draft cheat sheet into shape. 🙂
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 6:39am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/7 "2021-03-02T06:39:07Z")
Last 10 add averages are in the [average value export](https://ottoneu.fangraphs.com/averageValues) which combined with the roster export is probably the right place to start on any draft sheet, I think.
---
### Author:  [@walt526](https://community.ottoneu.com/u/walt526)
#### Post date: [March 2, 2021, 6:40am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/8 "2021-03-02T06:40:34Z")
What you could do is head over to the [Average Salaries](https://ottoneu.fangraphs.com/averageValues) page and export to CSV for your league format. Next, do a roster export of your league rosters to CSV and then do a vlookup from the team roster page to the CSV with the average salaries page to be able to identify the free agents in your league as well as pull in their salaries for your league. It shouldn’t take more than 5 minutes to set up in Excel if you’re familiar with the vlookup function (and if you’re not, it’s worth learning because it’s a very useful Excel skill to have).
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 6:43am UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/9 "2021-03-02T06:43:04Z")
Ha great minds. Thanks for explaining in a bit more detail.
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 3:38pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/10 "2021-03-02T15:38:45Z")
Thanks for the Excel tips and that sounds doable. Although I’m still not sure why showing both median and average on the search page makes more sense than swapping one of those out for Last 10, given the rarity of much significant deviance between avg and median. Last 10 seems like a better use of that precious screen real estate.
And I should say that I’m mostly obsessing about this Last 10 stuff because of how often it’s referred to on the Ottobot podcast, so you brought my pestering on yourself Niv! 😉
But I’ll be done and start getting to know the Vlookup feature of Excel. Thanks for the feedback and discussion about it.
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 3:42pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/11 "2021-03-02T15:42:02Z")
I think median and average are more meaningful aggregates, though Last 10 is kind of interesting during draft season. Last 10 is only useful in conjunction with median/average as context I think.
Either way, doing a search and copy + pasting a table is not a complete way to make a draft sheet. If your goal is a draft sheet the exports are what you need. Search is simply not meant for creating a draft sheet.
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 3:50pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/12 "2021-03-02T15:50:23Z")
Copy and paste?!? I’m using paper and pencil! 🙃 But that’s part nostalgia because it takes me back to my Strat-O-Matic days when we’d all keep track of our team’s stats in spiral notebooks and need to copy things over to a new page when we erased holes in the paper every 20 games or so. Those were the days!
But I jest a bit — I use the export feature a bit and spreadsheets. When it gets down to the one piece of paper in front of me for the draft, though, that’s by hand. I actually find there’s something about slowing down and writing out the cheat sheet that makes me consider each player better and internalize the data that, I hope, makes me better at reacting quickly in the draft room. That’s the theory anyway!
---
### Author:  [@walt526](https://community.ottoneu.com/u/walt526)
#### Post date: [March 2, 2021, 6:45pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/13 "2021-03-02T18:45:16Z")
Well if you do set up a spreadsheet with the exports, here’s a way to use the data to try to estimate the probability that players will be available at given prices. YMMV, but it can be helpful for budgeting and you’ll have all of the data on hand to calculate the probabilities fairly easily:
> [@Calculating Probability that a Player Will Be Available at a Given Price](https://community.ottoneu.com/t/calculating-probability-that-a-player-will-be-available-at-a-given-price/8677):
>
> I’ve been messing around today with the data on [https://ottoneu.fangraphs.com/averageValues](https://ottoneu.fangraphs.com/averageValues) and wanted to share something that I’ve developed that is a simple, but potentially helpful, tool for budgeting in advance of auctions. What follows are instructions on how to incorporate these data into a simple model into Excel (or another spreadsheet program) to estimate the probability of a player being available at a given auction price. For example, I’ve got an auction coming up next week in an exi…
---
### Author:  [@vibbot](https://community.ottoneu.com/u/vibbot)
#### Post date: [March 2, 2021, 7:12pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/14 "2021-03-02T19:12:55Z")
FWIW, this thread inspired me to add a sort by Last 10 feature on both the Public and Premium versions of the SC for the FA tab
---
### Author:  [@mkirshenbaum](https://community.ottoneu.com/u/mkirshenbaum)
#### Post date: [March 2, 2021, 9:54pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/15 "2021-03-02T21:54:48Z")
Awesome! Thank you, Justin. Will the Last 10 update automatically as more drafts happen?
---
### Author:  [@nivshah](https://community.ottoneu.com/u/nivshah)
#### Post date: [March 2, 2021, 10:35pm UTC](https://community.ottoneu.com/t/add-last-10-average-salary-to-search-results/8767/16 "2021-03-02T22:35:37Z")
It uses the aforementioned exports, so yes.