Mastersball Fantasy Forum

There is a glitch in the Ultra Standings and Roster Tracker in the Saves category. Can I change the saves numbers myself, or is it easiest to just wait for an updated version? (no hurry, I don't plan to be drafting any closers for awhile)

You can type in over any of the stats that you wish.

I see the glitch and will fix that now.

Saves is fixed.

I am looking at BA now. I don't like the way the new adjustment has changed a couple of hitters.

Awesome, thanks. This is an extremely useful tool for NFBC Slow Drafts... is there a quick way to find a player in the hitter or pitcher list, like a search, or can I put the lists in alphabetical order?

davep wrote:Awesome, thanks. This is an extremely useful tool for NFBC Slow Drafts... is there a quick way to find a player in the hitter or pitcher list, like a search, or can I put the lists in alphabetical order?

Dave -- are you talking about the pulldown menu or the actual names that are shown?

One of the "problems" is since there is code in the cells, easy sorting is not possible. My preference is to have the initial list be by dollar value. Some like it alphabetical.

If you are not concerned about the players not on the list, or you are willing to type in the players not actually listed, then it is simple to convert the cells to numbers/text and you will be able to sort on any column.

I'm just talking about finding players as they are drafted to add to the rosters. They are in order of AB's and IP's, so it's a long list to scroll through and can be tough to find players. But, this is certainly not a big deal. If I can't find someone, I can cross-check AB's against the projections and find him.

gotcha -- if you want to be able to sort by any of those columns, it is an easy Excel fix, with the sole issue being you will not be able to access unlisted players from the pulldown menu.

Here are two different things you can do, depending on what you want to be able to do.

1. If you don't care about being able to sort by at bats and only care about alphabetical sorting, you can put the cursor in the Player name box and SORT ASCENDING and the list will be alphabetical. The pulldown availability for unlisted players will still be there.

2. If you do not care about being able to add unlisted players or don't mind typing them in, doing this separately but the same process to both hitting and pitching....

- highlight all the players and the stats, starting in cell C7 and dragging it to the bottom right
-right click, choose copy
-right click, choose paste special, click the values circle, click OK
-starting at the first PLAYER NAME cell under those listed (it appears blank), highlight the area from the name to where the stats would be, then go down to row 2000
-right click, choose clear contents

You should now be able to sort by ANY column.

perfect, that is exactly what I was looking to do, thanks.