can someone give me the quick version of holly fuck on the ss? understand there are some projections involved, but not sure exactly.
In short, there are 9 columns of interest, CE to CM from the WA_NPS sheet. For each of the column with value >= 60%, he gave +1. And if a column is <= 40%, he awards a -1. Then you SUM it all up. So if they are all >= 60% for those 9 columns, you'd get a max value of +9.
Or if they were all <= 40%, you'd get a possible -9.
But you'll never get a -9, because the formula did not account for the last column CM if it's <= 40%. So, on the negative value, the lowest is -8.
Basically, pops is saying life is not perfect, and can't wait for a perfect storm to see all 9 columns tilt on way or the other, but if there's enough conditions that warren an OVER or UNDER possibility, he wants to know what that is (+8...+4 ...-5...-8 etc).
Pops, I think it wasn't intentional leaving CM out of the <= 40% range was it?