Hi,
I'm trying to create a chart/calendar that shows which days/working days (probably need both) are available/not available.
I have a table that has 15 clients, each with columns to the right, that contain pretty random dates 'XX/XX/XXXX' stored against them (so far September - December)
I want to see the overall pattern, especially of when there are large gaps between clients, and clusters e.g. end & beginning of the month are very busy.
Some clients can have more than one entry per month, some less. But the average is once a month, and never more than one a week.
to confuse things further, some clients have the same date every month e.g. three as the 1st, where as others go by the last working day, and some random e.t.c.
This tool will help me see when I have available time, when to expect appointments, and to also predict future dates.
How should I store my dates/data and how can I create this? Every time I try I end up with a mess
Help!
Thank you,
I'm trying to create a chart/calendar that shows which days/working days (probably need both) are available/not available.
I have a table that has 15 clients, each with columns to the right, that contain pretty random dates 'XX/XX/XXXX' stored against them (so far September - December)
I want to see the overall pattern, especially of when there are large gaps between clients, and clusters e.g. end & beginning of the month are very busy.
Some clients can have more than one entry per month, some less. But the average is once a month, and never more than one a week.
to confuse things further, some clients have the same date every month e.g. three as the 1st, where as others go by the last working day, and some random e.t.c.
This tool will help me see when I have available time, when to expect appointments, and to also predict future dates.
How should I store my dates/data and how can I create this? Every time I try I end up with a mess
Help!
Thank you,
