Forum Discussion
Patient Tracker and Package Tracker
Hi, I have two excel 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 da...
sql:
select * from Sheet2;
select * from Sheet1;
select Sheet2.f03,sum(f06) from Sheet2 join Sheet1 on Sheet2.f02=Sheet1.f03 and Sheet2.f03=Sheet1.f02 group by Sheet2.f03;
| f01 | f02 | f03 | f04 | f05 | ||
| Shyam Hani | 153 | Ryaan | Occupational Therapy | 02/10/2024 | ||
| Shyam Hani | 153 | Ryaan | Occupational Therapy | 04/09/2024 | ||
| Shyam Hani | 153 | Ryaan | Occupational Therapy | 06/09/2024 | ||
| Shyam Hani | 153 | Sanju | Speech Therapy | 02/10/2024 | ||
| Shyam Hani | 153 | Sanju | Speech Therapy | 04/09/2024 | ||
| Shyam Hani | 153 | Sanju | Speech Therapy | 05/10/2024 | ||
| Shyam Hani | 153 | Sanju | Speech Therapy | 06/09/2024 | ||
| Shyam Hani | 153 | Sanju | Speech Therapy | 07/09/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 09/10/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 09/10/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 10/08/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 11/09/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 11/09/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 11/10/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 11/10/2024 | ||
| Meera Hasan | 152 | Sanju | Speech Therapy | 12/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 01/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 02/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 04/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 08/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 09/10/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 10/09/2024 | ||
| Dev Mani | 112 | Sanju | Occupational Therapy | 10/10/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 11/09/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 11/10/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 12/09/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 01/10/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 04/10/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 08/10/2024 | ||
| Dev Mani | 112 | Ryaan | Occupational Therapy | 10/10/2024 | ||
| f01 | f02 | f03 | f04 | f05 | f06 | f07 |
| Shyam Hani | Sanju | 153 | Wednesday, 2 October 2024 | Wednesday, 4 September 2024 | 100 | Speech Therapy |
| Shyam Hani | Ryaan | 153 | Wednesday, 2 October 2024 | Occupational Therapy | ||
| Meera Hasan | Sanju | 152 | Wednesday, 9 October 2024 | Saturday, 12 October 2024 | 200 | Occupational Therapy |
| Dev Mani | Sanju | 112 | Tuesday, 1 October 2024 | Tuesday, 8 October 2024 | 300 | Occupational Therapy |
| Dev Mani | Ryaan | 112 | Saturday, 27 July 2024 | Tuesday, 27 August 2024 | 400 | Occupational Therapy |
| f03 | sum(f06) | |||||
| Ryaan | 2800 | |||||
| Sanju | 4200 |