Thank you very much. I could make it through. You are my hero.
I have additional question:
When have to get day in the month and weight, we can run the loop as you have showed in Duration days in the month for weighted distribution.
However, when the data get larger, the loop takes time.
The reason is that loop Serial calculation which take 1-2 min to finish for about 3000 lines.
If I could get nodes (this is over 600 nodes!!) for 78 patterns for the year, I can get the answer easily within 20 seconds. I separate all patterns…
The reason is that this is parallel calculation. Is there way that we can calculate fast with less nodes?
DateCal_20200430_2.xlsx (178.4 KB)
