The image shows data that was made in google sheet. It consists of clients data records. I used this exact same format and formula on my previous work. For the status of the client and the commission, I used color coding for easily determination. I tend to keep my file simply and organized so that if there’s any mistakes in my inputs I could easily spot and correct them. I also used summation formula to compute the inputs that needed to be computed.