[Babase] New foxpro cycle calculations

Karl O. Pinc babase@www.eco.princeton.edu
Sat, 12 Feb 2005 05:48:20 +0000


Hi,

We met here in Princeton at lunch today and decided that
we were not going to get the new system producing data
inside of 3 weeks.  So I hacked the foxpro system to
produce some necesssary information.

There are 3 new tables:

newcycles
This is like cycles, only has an Estm column
recording whether the M date is estimated,
and has an estimated M date when possible.

newcycstats
This has M, S, O, and D states for the
females sexual cycles, as documented in the
new documentation for the new system.
But exceptions are noted below.

newrepstats
Don't use this, no telling what's in there.

The three tables are in the TEMP folder.
You _could_ put them in the DATA folder,
but please don't because my conversion program
will do some preliminary conversion on them
before it figures out that it does not need
the data.

There is a new program:

newmakerep

You run it by typing:

do newmakerep

in the foxpro command window.

The program must be run after any update to the cycles
table.  It rebuilds the above 3 tables.

Here are the cavats:

The foxpro system has no GAPS table.  So,
when there's gaps the cycle states are just really
long.  Likewise, there's always days-in and days-remaining,
except when the statdate is after the last transition
marker in which case the very last state has no days
remining.  Except that in foxpro no days remaning,
while showing on the screen as "blank", is equal
to 0 if you compare it to anything.


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein