Announcement
Collapse
No announcement yet.
Whose Projections were updated?
Collapse
X
-
Originally posted by Nick
Whatever computer process creates the projections can see when a change is being made. If an asterisk could be appended to that line by the player's name (that way you aren't adding a new column or anything), it would allow us to very quickly scan for updates.
The alternative would be for there to be nother column in which there could be an indicator ("flag") to show whether the projection had been changed. But you could easily do this yourself, and you could fine-tune the flags to show the changes in whatever stat is important to you--ABs, HRs, R$, whatever.
This raises another issue: How does the projection mechanism know which stat-changes need to be flagged? Do you flag *any* change? Or do you pick and choose?
If there are only a few, we can modify our existing spreadsheets by hand. If there are a lot, we would know to go through the process of re-doing our spreadsheets. As it is now, we are in the dark except looking line by line.
Leave a comment:
-
I agree. Whatever computer process creates the projections can see when a change is being made. If an asterisk could be appended to that line by the player's name (that way you aren't adding a new column or anything), it would allow us to very quickly scan for updates. If there are only a few, we can modify our existing spreadsheets by hand. If there are a lot, we would know to go through the process of re-doing our spreadsheets.
As it is now, we are in the dark except looking line by line.
Leave a comment:
-
There might not be time to make comments on why each player changed, besides, that info might be found somewhere else in the site, but having them highlighted on the sheet would be awesome!
Leave a comment:
-
It would be very refreshing to see a bullet point write up of the changes and why. After all when members do find the changes on their own you end up answer all those why did player A have a change to his projections here in the forums.
Just my 2 cents
Leave a comment:
-
Originally posted by Michael
If it really took only 5 minutes, wouldn't BaseballHQ be doing it already? This is a very common customer request.
It would be impossible for BHQ to do this at source because the criteria vary from user to user. But it sounds like you need the changed projections highlighted because of the elaborate filters you have in place; if you put the filter results off to the side as I described earlier, then all you need to do when the new porjections come out is to copy the data (using Paste Special | Values) into the same area of your sheet and the players meeting the criteria would be immediately identified.
If it is important to know which players have changed for some other reason, then the solution would be to put each new projection on its own sheet within a workbook, with a column added far right to VLOOKUP either the R$ or AB projection for the guy from the previous week and then another immediately to the right subtracting that result from the R$ or AB column of the current sheet and flagging the differences.
Leave a comment:
-
If it really took only 5 minutes, wouldn't BaseballHQ be doing it already? This is a very common customer request.
Leave a comment:
-
Re: Whose Projections were updated?
Originally posted by LEC
Is there an easy way to determine which players projections have been updated each week? Every week I find myself spending 45 minutes to an hour running my filters, and customizing the Excel sheet to suit my league, and then do it all over again the following week, when the updated sheets are posted? Is there an easier way?
Leave a comment:
-
Whose Projections were updated?
Is there an easy way to determine which players projections have been updated each week? Every week I find myself spending 45 minutes to an hour running my filters, and customizing the Excel sheet to suit my league, and then do it all over again the following week, when the updated sheets are posted?
Is there an easier way?Tags: None
Leave a comment: