1 Reply Latest reply: Apr 19, 2013 9:58 AM by Paul Fowler RSS

    Temporal values inside of Excel

    Paul Fowler
      I have a logic puzzle for today.

      Is there a way to put the following into Excel sheets verbatim and then make it temporal with other rules?

      2010-01-01 New Year's Day
      2010-01-18 Dr. Martin Luther King, Jr. Day
      ...

      Of course, I know about using "Apply Sheet" so that I can have a worksheet for each year, and I know I could do the following:

      Condition Conclusion
      TemporalOn(2010-01-01) New Year's Day
      TemporalOn(2010-01-18) Dr. Martin Luther King, Jr. Day
      ...

      But, is there a way to take the original form of "2010-01-01" and "New Year's Day" in Excel rows and then make it temporal? I am looking for a larger pattern via this simple example...

      Thoughts?
        • 1. Re: Temporal values inside of Excel
          Paul Fowler
          Wait, I found a whacky solution...

          the holiday dates = AddDays(2010-01-01, TemporalDaysSince(2010-01-01, 2010-12-31))

          then, using "the holiday dates" as a condition and "the holiday name" as a conclusion in Excel...

          the holiday dates | the holiday name
          2010-01-01 | New Years day
          2010-01-18 | Dr. Martin Luther King, Jr. Day
          ...

          Whacky, but performance aside, it works...