calendar of services I have a spreadsheet that looks like this: I need to have a

Question

calendar of services

I have a spreadsheet that looks like this:

I need to have a calendar that shows wwhich services (along with customer) are duue on which day (ie. second Tuesday) of whatever month. I don't care if I wind up with one calendar where I can define (via drop down list) the service and month and there are 31 columns that get populated with jobs, or if I wind up with 12 different sheets that fill in with "customer" and I can look at just "CAB" services or just "JET" services.

I have about 10 different services, 500 customer jobs, and the frequencies vvary from once per year, quarterly, every other month or monthly. And the cycle may start in any month....

SERVICE CUSTOMER WEEK DAY MONTH1 MONTH2 MONTH3 MONTH4 CAB JOE first Monday January July JET SAM second Monday January April July October PUMP PETE first Wednesday January JET TOM third Tuesday All

Explanation / Answer

Hi,

Here's my suggestion.

1. Instead of All, have all 12 moonths listed in 12 columns

2. Once that is done, convert the 12 month columns into a single column - the techniqque to do this is explained here - http://www.ashishmathur.com/converting-a-matrix-data-layout-to-a-tabular-layout/

Once data is converrted into a tabular layout, you can apply filters easily.

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.