Jul 27 2020 06:42 AM
Hi everyone
I'm in need of help
I need to have a sheet that i can manage tuition for all my yoga students
there are different classes and the "start day" is different from person to person
i don't know what is the best formulas for this thing...
every one pay money for 12 session, i want to manage it in a sheet so when it's the last session i cant see it
can anyone please help me?
i don't know what to do
i
Jul 27 2020 08:53 AM
SolutionOne sentence in your description seems like it may be saying the opposite of what you mean.
You wrote: i want to manage it in a sheet so when it's the last session i cant see it
I'm assuming you mean you actually want to be able to see it. i.e., you meant to write " i want to manage it in a sheet so when it's the last session i can see it"
Anyway, I've created a little workbook here for you. It consists of three tabs. The tab in the center, "Transactions" is where you actively track all transactions, meaning
Dates when tuition is paid
Dates when the client attends a class
Prior to entering data in the transactions database, there's a very important "background" tab called "Tables" where you will see:
And then there's a "Summary Tracking" tab that automatically gets populated with
Here's what that summary table is looking like now, based on some test entries:
I have not put this workbook through all its paces--there still no doubt will be an occasional glitch (bug), but it's a start. I should warn you, though, that it relies on a few functions that are only available in the newest versions of Excel, so if you're NOT seeing the kinds of results I'm describing, then you may need to update your Excel, or wait for somebody to create a system that works with the older functions.
Jul 27 2020 08:53 AM
SolutionOne sentence in your description seems like it may be saying the opposite of what you mean.
You wrote: i want to manage it in a sheet so when it's the last session i cant see it
I'm assuming you mean you actually want to be able to see it. i.e., you meant to write " i want to manage it in a sheet so when it's the last session i can see it"
Anyway, I've created a little workbook here for you. It consists of three tabs. The tab in the center, "Transactions" is where you actively track all transactions, meaning
Dates when tuition is paid
Dates when the client attends a class
Prior to entering data in the transactions database, there's a very important "background" tab called "Tables" where you will see:
And then there's a "Summary Tracking" tab that automatically gets populated with
Here's what that summary table is looking like now, based on some test entries:
I have not put this workbook through all its paces--there still no doubt will be an occasional glitch (bug), but it's a start. I should warn you, though, that it relies on a few functions that are only available in the newest versions of Excel, so if you're NOT seeing the kinds of results I'm describing, then you may need to update your Excel, or wait for somebody to create a system that works with the older functions.