SOLVED

I Need to track my gym tuition data

%3CLINGO-SUB%20id%3D%22lingo-sub-1547889%22%20slang%3D%22en-US%22%3EI%20Need%20to%20track%20my%20gym%20tuition%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547889%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3EI'm%20in%20need%20of%20help%3C%2FP%3E%3CP%3EI%20need%20to%20have%20a%20sheet%20that%20i%20can%20manage%20tuition%20for%20all%20my%20yoga%20students%3C%2FP%3E%3CP%3Ethere%20are%20different%20classes%20and%20the%20%22start%20day%22%20is%20different%20from%20person%20to%20person%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20don't%20know%20what%20is%20the%20best%20formulas%20for%20this%20thing...%3C%2FP%3E%3CP%3Eevery%20one%20pay%20money%20for%2012%20session%2C%20i%20want%20to%20manage%20it%20in%20a%20sheet%20so%20when%20it's%20the%20last%20session%20i%20cant%20see%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20anyone%20please%20help%20me%3F%3C%2FP%3E%3CP%3Ei%20don't%20know%20what%20to%20do%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1547889%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548189%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20to%20track%20my%20gym%20tuition%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741063%22%20target%3D%22_blank%22%3E%40Maryam-1995%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20sentence%20in%20your%20description%20seems%20like%20it%20may%20be%20saying%20the%20opposite%20of%20what%20you%20mean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20wrote%3A%3CEM%3E%20i%20want%20to%20manage%20it%20in%20a%20sheet%20so%20when%20it's%20the%20last%20session%20i%20cant%20see%20it%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20assuming%20you%20mean%20you%20actually%20want%20to%20be%20able%20to%20see%20it.%20i.e.%2C%20you%20meant%20to%20write%20%3CU%3E%22%20i%20want%20to%20manage%20it%20in%20a%20sheet%20so%20when%20it's%20the%20last%20session%20i%20%3CFONT%20color%3D%22%23FF0000%22%3Ecan%3C%2FFONT%3E%20see%20it%22%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20I've%20created%20a%20little%20workbook%20here%20for%20you.%20It%20consists%20of%20three%20tabs.%20The%20tab%20in%20the%20center%2C%20%22Transactions%22%20is%20where%20you%20actively%20track%20all%20transactions%2C%20meaning%3C%2FP%3E%3CP%3EDates%20when%20tuition%20is%20paid%3C%2FP%3E%3CP%3EDates%20when%20the%20client%20attends%20a%20class%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPrior%20to%20entering%20data%20in%20the%20transactions%20database%2C%20there's%20a%20very%20important%20%22background%22%20tab%20called%20%22Tables%22%20where%20you%20will%20see%3A%3C%2FP%3E%3CUL%3E%3CLI%3EA%20table%20for%20client%20info%3A%3CUL%3E%3CLI%3Ethe%20basic%20info%20on%20each%20client%2C%20beginning%20with%20some%20kind%20of%20unique%20ID.%20I%20created%20them%20using%20the%20person's%20initials%20(to%20ease%20the%20identification%20when%20you%20record%20a%20transaction)%20and%20a%20number.%20Then%20first%20and%20last%20name.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EA%20small%20table%20for%20class%20names%20and%20tuition%20(assuming%20they%20could%20be%20different)%3C%2FLI%3E%3CLI%3EAn%20even%20smaller%20table%20for%20types%20of%20transactions.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20then%20there's%20a%20%22Summary%20Tracking%22%20tab%20that%20automatically%20gets%20populated%20with%3C%2FP%3E%3CUL%3E%3CLI%3Eeach%20ID%20(when%20a%20new%20person%20is%20added%20to%20the%20Client%20Roster)%3C%2FLI%3E%3CLI%3Ethe%20client's%20name%3C%2FLI%3E%3CLI%3ELast%20date%20tuition%20paid%3C%2FLI%3E%3CLI%3EClass%20for%20which%20that%20tuition%20was%20paid%3C%2FLI%3E%3CLI%3EAmount%20of%20tuition%20for%20that%20class%3C%2FLI%3E%3CLI%3EAND%2C%20finally%2C%20the%20number%20you%20wanted%20to%20track%3A%20the%20number%20of%20attendances%20since%20that%20tuition%20was%20paid%2C%20where%20it%20now%20is%20programmed%20to%20highlight%20when%20the%20number%2012%20is%20reached.%20We%20could%20change%20that%20to%20highlight%20at%2010%20or%2011%20if%20that%20would%20be%20better.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EHere's%20what%20that%20summary%20table%20is%20looking%20like%20now%2C%20based%20on%20some%20test%20entries%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20not%20put%20this%20workbook%20through%20all%20its%20paces--there%20still%20no%20doubt%20will%20be%20an%20occasional%20glitch%20(bug)%2C%20but%20it's%20a%20start.%26nbsp%3B%20I%20should%20warn%20you%2C%20though%2C%20that%20it%20relies%20on%20a%20few%20functions%20that%20are%20only%20available%20in%20the%20newest%20versions%20of%20Excel%2C%20so%20if%20you're%20NOT%20seeing%20the%20kinds%20of%20results%20I'm%20describing%2C%20then%20you%20may%20need%20to%20update%20your%20Excel%2C%20or%20wait%20for%20somebody%20to%20create%20a%20system%20that%20works%20with%20the%20older%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552229%22%20slang%3D%22en-US%22%3ERe%3A%20I%20Need%20to%20track%20my%20gym%20tuition%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552229%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20John%2C%20i%20really%20don't%20know%20what%20to%20say%3C%2FP%3E%3CP%3Ei'ts%20a%20great%20great%20feeling%20that%20i%20see%20you%20spend%20time%20to%20give%20me%20what%20i%20exactly%20needed%3C%2FP%3E%3CP%3Ei%20really%20appreciate%20your%20time%20and%20wish%20you%20all%20the%20best%20things%20in%20the%20world%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20please%20excuse%20me%20for%20typing%20badly!%3C%2FP%3E%3CP%3Eyou're%20so%20smart%20and%20you%20understand%20me%20better%20than%20me%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etoday%2C%20when%20i%20say%20to%20others%20that%20%3A%20%22someone%20helped%20us%20and%20show%20us%20the%20way%22%20everybody%20become%20so%20happy%20here%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3Eit's%20so%20valuable%20to%20us%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%201000%20times%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted
Best Response confirmed by Maryam-1995 (Occasional Visitor)
Solution

@Maryam-1995 

One 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:

  • A table for client info:
    • the basic info on each client, beginning with some kind of unique ID. I created them using the person's initials (to ease the identification when you record a transaction) and a number. Then first and last name.
  • A small table for class names and tuition (assuming they could be different)
  • An even smaller table for types of transactions.

 

And then there's a "Summary Tracking" tab that automatically gets populated with

  • each ID (when a new person is added to the Client Roster)
  • the client's name
  • Last date tuition paid
  • Class for which that tuition was paid
  • Amount of tuition for that class
  • AND, finally, the number you wanted to track: the number of attendances since that tuition was paid, where it now is programmed to highlight when the number 12 is reached. We could change that to highlight at 10 or 11 if that would be better.

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.