You can export the Moon Lore rules to Excel from the moon lore rules dialog or directly from the export data to Excel menu.

By default, the settings of the Geographical Location fields, to the left of the above dialog, correspond to those of the moon data source of the current set.

The exported results in Excel look as below, with all the rules of the current set running from left to right.

In each non-empty cell, there is:

•either a number from 1 to 23, corresponding to the number of full hours during which the rule is true on a given date

•or the text "ALL" meaning that the rule is true for the maximum number of hours of that day. Generally, ALL would mean 24 hours, but in some cases, if the rule specifies that it can only happen from 8am to 6pm, for example, a maximum of 10 hours a day, then if that rule is true for 10 hours on a given day, from 8am to 6pm, then the text ALL would appear even though the rule is not true for 24 hours.

•The cells are shaded if the rule is true at the end of the current day.

•Placing your mouse cursor over any of the non-empty cells will display a pop-up hint with the start and end times when the collection of conditions is true.

These values can be used in a script using the MoonLoreNumHours macro function.

Topic 181100, last updated on 14-Aug-2020