Dating with MaxiPlan
2 messages in this thread
OK, I found out how to set up a single entry as a date using the jday()
function. Now, how do I get SuperPlan to add a given number of days to an
entry.
I want to have the left column be a series of dates separated by 14
days.
e.g.
90-01-01 90-01-15 90-01-29 90-02-14 90-02-28
How do I set up SP to automatically calculate those days for me once I
have set up the first jday() for the first date?
Usenet:Ernie_Gorrie@mindlink.bc.ca
Ernie, you have a numeric value in the JDAY(n) expression. So for a cell
(let's call it C10) of JDAY(n), the next cell down would be JDAY(n+14),
next would be JDAY(n+28), and so on.
One way to accomplish this is to have a separate column way off to the
right (let's say in Z10) with the "seed" value of the starting Julian
number. Then make the next cell down from the "seed", Z11, have the
expression Z10+14. Copy Z11 to the next cell down, and so on until you
have a full column-length of Julian numbers, each 14 more then the one
above it.
Now go back to cell C10, where you have the JDAY(n) expression. Change
this to JDAY(Z10), and copy this expression downward to the end of the
column.
The beauty of this is that you can change the "seed" value at will, and the
entire sheet changes. In fact, the additive 14 can be placed in a cell of
its own, and referred to specifically as well, making the 2-week "skip"
re-programmable with a single change.
Regards, Whap!penned…
Pat @Oxxi (310) 427-1227