Math problem.
Oct. 17th, 2004 04:27 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
I need a formula that will tell me, for a given number of days in a year and a given number of days in a month, how many years it will take for the cycles to match up -- in other words, if we start with the new moon on the first day of the year, how many years until the new moon falls on that day again? (Assumption being that a month is shorter than a year.)
This is driving me crazy. Left-brainers, please help!
This is driving me crazy. Left-brainers, please help!
Re: More thoughts
Date: 2004-10-18 07:15 pm (UTC)If you could make an excel spreadsheet that shows how the calculations work, I would be very grateful.
Re: More thoughts
Date: 2004-10-18 08:16 pm (UTC)If it's the observed new moon, that's just, someone looks up into the sky and says, "it's a new moon, I guess it's the next month now."
If it's a calculated new moon, then you've got a calendar that tells you when the new moon will be, and you'll have a leap-year like cycle of months, e.g. "most months have 24 days, but 3 months out of 10 have 25" or whatever.
Speaking of which, you probably want some kind of independent cycle of months. That is, 6 or 10 or 13 or whatever month names that you cycle through, like weekday names, yeah? The number of names / number of months in the month-cycle should probably be based on how the months get systematically corrected, i.e. in the example above, a cycle of 10 named months, and the months named "such", "so", and "t'other" have 25 days.
Ahhh. There's so many choices, and I don't know how to convey them all! But, anyway, this spreadsheet:
http://www.sedesdraconis.com/stor/calencalc.xls
you can use it to pick a year length and month length, and it won't shut down (m?)any options for the other pieces.
The documentation is in the spreadsheet, I tried to make everything crystal clear, I apologize if it's too patronizing, or if it's not clear enough.
Re: More thoughts
Date: 2004-10-26 03:22 pm (UTC)Re: More thoughts
Date: 2004-10-26 08:23 pm (UTC)"Extra months": so you've set up the # of years in a cycle, and you've set up the approximate number of months in a year. Multiplied together, that'll give you an approximate number of months in a cycle. But if you just use that number, you wouldn't need a cycle, because there'd be an exact number of months (well, offset slighlty, cause of the fudge in year legnth, but not offset enough) in the year, whatever you put in. So you fudge it with the "extra months" cell.
So for example you've got an 11-year cycle, and about 14 months in a year. That makes 154 months in a cycle if there're (nearly) exactly 14 months in a year, but we don't want that. So you put in, say, 4 in the extra months field, so that there are 154+4=158 months in a cycle, or 14 and 4/11 months per year.