BigPunkin,
Good catch on the alternate formula. There's a typo in the excel workbook and the alternate formula should be divided by 4. :)
It's set up to calculate pivot by summing the H,L,C and dividing by 3 as this is the standard calculation. However, you can adjust it to your preference.