Hi, all,
I have a litle project where I'm trying to explore and categorize patterns in my set of time data according to certain criteria defined by me. This relates to this thread I already made in this forum. Initially, I asked for help counting certain conditions, but I'd also be interested in creating a label for each type of day based on which condition is met.
Having thought more on it, I'm wondering if perhaps the answer to my thread above is best achieved through what I'm doing here anyway and simply counting the # of patterns.
I think it's hard for me to describe here, but I hope the Excel sheet is somewhat self-explanatory.
Basically, I've given a label to each condition/pattern I've created. I've just used AA, AB, AC, etc. Then, I've started a what-if formula where the column pattern returns AA, AB, AC, etc. if those condtions are met.
For example, with pattern A, I'm requesting that B5, Order = LH; C5, LOD <= 10:00 (10/24); HOD <= 10:00 (10/24).
By now, I have 3 out of 44 patterns and it looks like this (sorry if the syntax seems weird, but it's Excel in Norwegian. It's correct in the Excel sheet though):
=HVIS.SETT(OG([@Order]="LH";[@LOD]<=10/24;[@HOD]<=10/24);"A";OG([@Order]="LH";[@LOD]<=10/24;[@HOD]>10/24;[@HOD]<=11/24);"AA";OG([@Order]="LH";[@LOD]<=10/24;[@HOD]>11/24;[@HOD]<=12/24);"AB")
Which means it will get a helluva lot longer, pardon my french.
I don't mind spending a day doing this if it works, but I'd love to hear some experienced Excel users comment on this and whether there's a smarter way to accomplish this or even some other software, although I'd love to stay with Excel.
Thanks a lot in advance for any pointers.
Bookmarks