added your warning.
3 Likes
You are having far too much Fun .
4 Likes
Ok. Here is my next one. Not a GMT but very simple.
4 Likes
Amazing first crack! Keep it up 
4 Likes
Much thanks. Really appreciate feedback especially from a Partner.
4 Likes
Does anyone know the shortest formula for this?
I need to test where a number falls within 3 buckets.
For example. Given a number, say less than 500, and I need to see where a number falls within 3 portions.
Portion 1 is between 1-90, Portion 2 is 91-260, and 3 is between 261-500 where 500 is the max.
The standard way of determine which portion the number sits in would be this.
=if(Number is <91, then 1, if(Number is < 261, then 2, else 3).
Is there a way in Creator to shorten this formula?
FYI, the number is random, the sizes of the portions will vary so 91 and 260 won’t be the same each time. Not hard coded.
3 Likes
Facer only generates one random number on wake . For the middle test you need to test >91 && <260 && = AND .
2 Likes
I do not think there would be reliable simple nested formula.
Maybe stitching 3 formulas with empty else portion would do.
$Nr<=border1?A:$$Nr>border1&&Nr<border2?B:$$Nr>=border2?C:$
3 Likes
I don’t think there is a way of simplifying the structure of the ifthenelse statement. But I figure I would ask. I figure I should ask around and was hoping Creator would have something simplified.
Much thanks.
I’m actually working on correcting my GMT to factor in Daylight savings changes into my GMT. The formula is enormous.
3 Likes
If the answer to the formula is really only 2 answers and not 3 separate answers but there are 3 buckets, i.e bucket one is the same answer as bucket 3, then can the equation be simplified?
If answer to Portion 1 and Portion 3 is always the same, then can if then else be simplified in creator?
Only portion 2 has a different answer. Even though there are 3 portions, there are only 2 answers…
Hope that makes sense.
3 Likes
It is simple, you have to apply all 3 conditions and which ever is fulfilled, returns your desired reply. The other two return nothing. If you manage the conditions to overlap, or leave a gap, you may get two cobbled, or no answer as well.
3 Likes
Use || = OR for crossing Zero .
2 Likes
I dont think that is needed
3 Likes
$Nr>border1&&Nr<border2?A:B$
I think this would satisfy my needs. Let me explain.
- All numbers (Nr, Border1, Border2) will be positive integers.
- There never will be a zero. If it was, then the calculation is wrong. Or the watch generated incorrect starting numbers that form the pre-calculation that derives Border1 and Border2 which is calculated way before this test. If the watch generated bad numbers to start the calculation, there is something really wrong with the watch. However, even if the numbers were really wrong, the calculation should actually still generate positive integers for Border1 and Border2. A quirk of the calculation.
- The calculation will only generate a border 1 and border 2 numbers that are always going to be around 70ish and 300ish respectively. Therefore, no zero cross over. The overall calculation for this test is not actual clock time, therefore, hours are irrelevant for this test.
- Nr will always be a positive number as it is the day number which is between 1 and 365 or 366. Therefore, no zero crossover.
Given these limitations, I don’t think the calculation would ever generate a non-answer, Nr would fall either within the borders, resulting in answer A or by default answer B.
Anyways, thank you all for helping out. I’ll run the test and see what happens. But I’m a long way off to even getting to this condition.
3 Likes
Hi All, I’ve posted a question about conditionals in another post. Kindly take a look if you are interested.
2 Likes
Yes. Overlapping True. The big copy paste trap in the serial conditional panacea. My main overlap is forgetting >= and <= (or a number [in/de]crement in the comparison.
2 Likes
Here is the next GMT version. This time, all zones will automatically reflect Daylight Savings changes. PLUS, this version also will notify when Western Easter Sunday. Which btw is on April 20th, just in a few days.
Any bugs, please let me know!
3 Likes
BTW, all previously published GMZ/GMT faces have also been updated to reflect daylight savings.
2 Likes
Jolly well Done I say . Unique for sure . Not seen Easter done before . 
1 Like
Well, I guess we will have to wait a few more days to see the notice on April 20th.
2 Likes