First - I just want to say thank you as this is another year I'll be ahead of the curve thanks to this magnificent excel weapon you have fashioned!

I came here to ask a few semi-advanced questions regarding this tool's usage. I want to make sure I'm eeking out every inch of worth I can get from the data :) - specifically want to understand how the #'s affect each other in terms of trending etc. (Also - Apologies if some of these topics have been answered in the past... I did try to search through some older 2014 & 2015 posts+subreddits and could not find a comprehensive for what I was looking for.)

So let's pretend this is the scenario:

-The sheet is setup with my league's settings & we are in the middle of the live draft, 50 picks deep

-We are looking at the AUCTION tab for up to date data

-Mike Evans gets nominated

Here's my questions on the columns in the AUCTION tab:

-Is this correct: Projected $ is a static number that is initially calculated from the average VBD & league settings and will not change as the paid values are logged during the auction. i.e. Mike Evans Projected $ is 33 and that # will NOT change as other WR's are drafted for different values?

-What is the value in # the inflated/deflated telling me? Mike Evans is projected 33$ and in my mock example where I have drafted a bunch of RB's, the # is DEFLATED, showing $26. Does this mean that based on the prior auction movement, mike evans is NOW worth 26, and not 33?

-What is the intention of the Custom/Yahoo/ESPN $ value? Is this for me to have an idea of what the others in my league are likely valueing players by with their own cheat sheets? Am I supposed to only be using the Projected $ as the truth for my own valuations?