Re: Template for AppleWorks (IIe version)

[Hugh Hood <hughhood@earthlink.net>]

Brother Robert,

I'm glad to see that you're still putting AppleWorks to good use.

Using the Database module of AppleWorks 5.1, the solution here would be
similar to that discussed a couple of years ago for a TV program record time
database. You may wish to examine the formulas used in that database and
adapt them to your current project. BTW, that thread (including the
formulas) is archived here:

<http://groups.google.com/group/comp.sys.apple2/browse_thread/thread/fba74ed
a25e61b6a>



The keys points are:

1. When constructing the database Category Names, put the word 'time'
somewhere in each 'TIME' category name so that AppleWorks will format them
as such.

2. Use the '@TimetoNum' function in the Database to convert your hours and
minutes to just minutes (in order to perform addition/subtraction).

3. Add (or subtract) the desired # of minutes to the result of Step 2.

4. Since Randy never got around to adding the corresponding '@NumtoTime'
function, you now need to break the calculated total minutes back down to
Hours and Minutes. This takes (3) formulas/categories. (See the sample in
the thread listed above). First, figure the hours. Then figure the minutes.
Then '@Join' them together.

5. Be sure to set the 'input' categories to 'Auto-recalc' in the Database
option settings so that as you enter your times, the record will be
recalculated.


Please let me know if I can help further. I'd be happy to send you a sample
database file with these formulas in it if you like. I suspect, however,
that you will be able to do it yourself just fine, especially if you follow
the example in the archived thread.

BTW, the full documentation for AppleWorks 4 (Reference Manual) and
AppleWorks 5 (Delta Manual plus index and errata) is located on that 'other'
site.  

<ftp://ftp.apple.asimov.net/pub/apple_II/documentation/applications/applewor
ks/>

Heck, they're even OCRed.





Hugh Hood





in article boucher1-115C25.09391828022012@news.giganews.com, Robert Boucher
at boucher1@alumni.texas.net wrote on 2/28/12 9:39 AM:

> I seem to be having one of my frequent "senior moments." I would like to
> set up a template (SS or DB) where I can enter a time for Event 1 (as an
> example, sunset time for Mar 15, 2012), have a number of events with
> fixed relationships with Event 1, and calculate times for the other
> events.
> 
> Event 2.  15 minutes before event 1
> Event 3.  21 minutes after event 1
> Event  4.  90 minutes after event 1
> and so on
> 
> Any suggestions?