OK, so you need to replicate the formulae in the example workbook so that they work in your new workbook.

The idea of a help forum is to assist you in doing this, not to do it all for you, so I would ask you please to have a go yourself first. If you come unstuck, then by all means come back and ask for guidance.