Sales Contacts

I am in need of some assistance with a sales contact sheet (see attached). I would like to use "Y" and "N".


1. Under the "Contact %", I would like a percentage of contacts make, successfully.
2. Under the "Apt %", how many of those successfully contacted with (from contact %), made an appointment.
3. Under the "Showed %", how many of those successfully contacted with (from contact %), had a product shown to them.

4. Under the "Sold %", how many of those successfully contacted with (from contact %), made a sale.
5. Under the "Sold %", how many of those successfully contacted with (from showed %), made a sale.


greatly appreciate the help!