qualitative research analysis using excel 1

I have an excel template that I want to use as a guide for my very own excel sheet.

I have started making mine then got confused with the formulas.

Can you kindly update my excel sheet to be similar to the template/guide.

The names or numbers are my own findings, I just need to follow the formulas and calculations exactly how the guide bur customised to my own excel