NKramer
2010-11-22, 10:34 PM
Revisiting something from a few years back and I still do not have a better answer. You can schedule items in a family and items nested in family, but I can’t figure out a way to determine the number of one family nested into another.
Any thoughts?
Assumptions:
- Parameters A-E are all Yes/ No parameters
- A + B = 2 when on
- C, D + E = 1 when on
Answer:
- Add another parameter to “count” what is turned on
- if(and(A, and(B, and(C, E))), 6, if(and(A, and(B, or(C, E))), 5, if(and(A, B), 4, if(and(C, and(E, or(A, B))), 4, if(and(C, or(A, B)), 3, if(and(E, or(A, B)), 3, if(or(A, B), 2, if(and(E, C), 2, if(or(E, or(C, D)), 1, 0)))))))))
Any thoughts?
Assumptions:
- Parameters A-E are all Yes/ No parameters
- A + B = 2 when on
- C, D + E = 1 when on
Answer:
- Add another parameter to “count” what is turned on
- if(and(A, and(B, and(C, E))), 6, if(and(A, and(B, or(C, E))), 5, if(and(A, B), 4, if(and(C, and(E, or(A, B))), 4, if(and(C, or(A, B)), 3, if(and(E, or(A, B)), 3, if(or(A, B), 2, if(and(E, C), 2, if(or(E, or(C, D)), 1, 0)))))))))