Hi,

I have two sheets one in which patient attendance is tracked with which therapist has been attended. Another sheet that says the type of package that the patients has bought. 

Every day I need to calculate the revenue by each Therapist. I have attached both the sheets, to show the type of data that is being generated from the system. 

Patient Attendance Tracker 

Patient NamePatient IDTherapistDepartmentDateShyam Hani153RyaanOccupational Therapy02/10/2024Shyam Hani153RyaanOccupational Therapy04/09/2024Shyam Hani153RyaanOccupational Therapy06/09/2024Shyam Hani153SanjuSpeech Therapy02/10/2024Shyam Hani153SanjuSpeech Therapy04/09/2024Shyam Hani153SanjuSpeech Therapy05/10/2024Shyam Hani153SanjuSpeech Therapy06/09/2024Shyam Hani153SanjuSpeech Therapy07/09/2024Meera Hasan152SanjuSpeech Therapy09/10/2024Meera Hasan152SanjuSpeech Therapy09/10/2024Meera Hasan152SanjuSpeech Therapy10/08/2024Meera Hasan152SanjuSpeech Therapy11/09/2024Meera Hasan152SanjuSpeech Therapy11/09/2024Meera Hasan152SanjuSpeech Therapy11/10/2024Meera Hasan152SanjuSpeech Therapy11/10/2024Meera Hasan152SanjuSpeech Therapy12/10/2024Dev Mani112SanjuOccupational Therapy01/10/2024Dev Mani112SanjuOccupational Therapy02/10/2024Dev Mani112SanjuOccupational Therapy04/10/2024Dev Mani112SanjuOccupational Therapy08/10/2024Dev Mani112SanjuOccupational Therapy09/10/2024Dev Mani112SanjuOccupational Therapy10/09/2024Dev Mani112SanjuOccupational Therapy10/10/2024Dev Mani112RyaanOccupational Therapy11/09/2024Dev Mani112RyaanOccupational Therapy11/10/2024Dev Mani112RyaanOccupational Therapy12/09/2024Dev Mani112RyaanOccupational Therapy01/10/2024Dev Mani112RyaanOccupational Therapy04/10/2024Dev Mani112RyaanOccupational Therapy08/10/2024Dev Mani112RyaanOccupational Therapy10/10/2024

Patient Price Tracker

Patient NameTherapistPatient IDPackage FromPackage ToPackage PricePackageShyam HaniSanju153Wednesday, 2 October 2024Wednesday, 4 September 2024100Speech TherapyShyam HaniRyaan153Wednesday, 2 October 2024 0Occupational TherapyMeera HasanSanju152Wednesday, 9 October 2024Saturday, 12 October 2024200Occupational TherapyDev ManiSanju112Tuesday, 1 October 2024Tuesday, 8 October 2024300Occupational TherapyDev ManiRyaan112Saturday, 27 July 2024Tuesday, 27 August 2024400Occupational Therapy

​Hi,I have two sheets one in which patient attendance is tracked with which therapist has been attended. Another sheet that says the type of package that the patients has bought.  Every day I need to calculate the revenue by each Therapist. I have attached both the sheets, to show the type of data that is being generated from the system.   Patient Attendance Tracker Patient NamePatient IDTherapistDepartmentDateShyam Hani153RyaanOccupational Therapy02/10/2024Shyam Hani153RyaanOccupational Therapy04/09/2024Shyam Hani153RyaanOccupational Therapy06/09/2024Shyam Hani153SanjuSpeech Therapy02/10/2024Shyam Hani153SanjuSpeech Therapy04/09/2024Shyam Hani153SanjuSpeech Therapy05/10/2024Shyam Hani153SanjuSpeech Therapy06/09/2024Shyam Hani153SanjuSpeech Therapy07/09/2024Meera Hasan152SanjuSpeech Therapy09/10/2024Meera Hasan152SanjuSpeech Therapy09/10/2024Meera Hasan152SanjuSpeech Therapy10/08/2024Meera Hasan152SanjuSpeech Therapy11/09/2024Meera Hasan152SanjuSpeech Therapy11/09/2024Meera Hasan152SanjuSpeech Therapy11/10/2024Meera Hasan152SanjuSpeech Therapy11/10/2024Meera Hasan152SanjuSpeech Therapy12/10/2024Dev Mani112SanjuOccupational Therapy01/10/2024Dev Mani112SanjuOccupational Therapy02/10/2024Dev Mani112SanjuOccupational Therapy04/10/2024Dev Mani112SanjuOccupational Therapy08/10/2024Dev Mani112SanjuOccupational Therapy09/10/2024Dev Mani112SanjuOccupational Therapy10/09/2024Dev Mani112SanjuOccupational Therapy10/10/2024Dev Mani112RyaanOccupational Therapy11/09/2024Dev Mani112RyaanOccupational Therapy11/10/2024Dev Mani112RyaanOccupational Therapy12/09/2024Dev Mani112RyaanOccupational Therapy01/10/2024Dev Mani112RyaanOccupational Therapy04/10/2024Dev Mani112RyaanOccupational Therapy08/10/2024Dev Mani112RyaanOccupational Therapy10/10/2024  Patient Price Tracker Patient NameTherapistPatient IDPackage FromPackage ToPackage PricePackageShyam HaniSanju153Wednesday, 2 October 2024Wednesday, 4 September 2024100Speech TherapyShyam HaniRyaan153Wednesday, 2 October 2024 0Occupational TherapyMeera HasanSanju152Wednesday, 9 October 2024Saturday, 12 October 2024200Occupational TherapyDev ManiSanju112Tuesday, 1 October 2024Tuesday, 8 October 2024300Occupational TherapyDev ManiRyaan112Saturday, 27 July 2024Tuesday, 27 August 2024400Occupational Therapy  Read More

​