START Questions

[dannykugler]

Hello,
I'm using START to track an NFBC D&H league that is drafting now.

After I had built up a good bit of entries (at about round 22) I decided to check the standings calculations to see if they made sense.
I took the projections in START for Hitters who have been drafted and calculated a pivot table for HR, RBI, and SB and compared that to the hitters standings table.
1) It appears the stats for Reserve Picks (i.e., R1, R2, ...) are being included in the team stats.
- I can screen the Reserve Positions by using a Filter in Pivot Table to get what I think are the correct totals.
- If I don't use the filter I duplicate the team stats in the hitter standings and in the "Standings" tab.
2) If my statement in 1) above is true, is START supposed to eliminate the stats from the Reserve Picks?

There is no stat line for Matt Manning pitcher for Detroit. Not surprising since he was in AA last year but thought you might want to know. One of the owners in my league drafted him.

Not sure this is a wise approach in the middle of a draft but since we are drafting relatively early are there any suggestions about incorporating projection updates into the START spreadsheet that is already started?
I have some ideas of the mechanism to do the update but was curious what the experts thought.

Thanks,
Danny

[Todd Zola]

Hello,
I'm using START to track an NFBC D&H league that is drafting now.

After I had built up a good bit of entries (at about round 22) I decided to check the standings calculations to see if they made sense.
I took the projections in START for Hitters who have been drafted and calculated a pivot table for HR, RBI, and SB and compared that to the hitters standings table.
1) It appears the stats for Reserve Picks (i.e., R1, R2, ...) are being included in the team stats.
- I can screen the Reserve Positions by using a Filter in Pivot Table to get what I think are the correct totals.
- If I don't use the filter I duplicate the team stats in the hitter standings and in the "Standings" tab.
2) If my statement in 1) above is true, is START supposed to eliminate the stats from the Reserve Picks?

START isn't supposed to count reserves in the totals. I can't check until the next update, but I'll fix it.

There is no stat line for Matt Manning pitcher for Detroit. Not surprising since he was in AA last year but thought you might want to know. One of the owners in my league drafted him.

My first run is players I feel will appear in MLB in 2020. Once the NFBC ADP is out, I add anyone drafted. I have not yet done this, but plan on scrubbing it soon, hopefully for the weekend.

Not sure this is a wise approach in the middle of a draft but since we are drafting relatively early are there any suggestions about incorporating projection updates into the START spreadsheet that is already started?
I have some ideas of the mechanism to do the update but was curious what the experts thought.

If you know pivot tables, you are no doubt intimate with vlookup.

[Todd Zola]

Screw it, it's fixed. I'd have Excel dreams if I didn't take care of it.

[dannykugler]

Thanks Mr. oops Lord Zola.
I’ll give it a go once the fix is released.
Danny

[dannykugler]

Playing with the newest version of START - START121319.xlsx
It looks like two players were dropped that should be there:
Hitter - Mike Zunino C, Tampa Bay Rays
Pitcher - Miguel Castro, Baltimore Orioles

Also Hitter - Adam Jones dropped but since he signed with Orix Buffaloes, I'm assuming that was on purpose.

Thanks,
Danny

[Todd Zola]

Well that's not good.

I'll figure out why they're gone and make sure they're back for tomorrow's update.