I have no idea about numbers 4 and 6 (post #45) and believe that they are meant for someone that has a prior understanding of load profiles of heat pumps.
Number 5 references a "Figure 3" which suggests to me that there is more to this than what we are able see and therefore I don't feel that I can help.
Again, I suggest trying to learn Excel using the "Excel is Fun" classes.
The lessons that I have seen include both the starter file for the student to work, and the answer file so that the student can check her/his work.