Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!tut.cis.ohio-state.edu!ucbvax!pro-abilink.UUCP!saw
From: saw@pro-abilink.UUCP (Alan Woods)
Newsgroups: comp.sys.apple
Subject: Re: Appleworks 3.0
Message-ID: <8906260837.AA21967@crash.cts.com>
Date: 26 Jun 89 06:31:17 GMT
Sender: daemon@ucbvax.BERKELEY.EDU
Reply-To: pnet01!pro-sol!pro-carolina!pro-abilink!saw@nosc.mil
Organization: The Internet
Lines: 40

Network Comment: to #5697 by shankar@src.honeywell.com

>>This is probably too much to ask for but what I'd really like to see
>>in Appleworks is the ability to reference other spreadsheet and
>>database modules (perhaps on disk, especially the database).  I often
>>have needs where the numbers on one file are a function of huge lists
>>of constants stored in another spreadsheet or database, and being
>>forced to combine these into the same file makes the whole thing
>>a kluge.
>>
>>Is there any spreadsheet on the Apple (or any other computer for that
>>matter) that supports such a feature?
>>---
>>Subash Shankar             Honeywell Systems & Research Center
>>shankar@src.honeywell.com  srcsip!shankar

I once wrote a couple of interlinked macros using TimeOut Ultramacros that
were called from one spreadsheet which was a quote template.  They checked for
a file on the desktop and loaded it if it was not loaded, then proceeded to
open it and search it for various pieces of information such as list price and
weights for UPS, Parcel Post and LTL (Motor Freight) shipments.  It then went
back to original file and entered the information in the proper blanks and
cycled until it had found the price and weight info for each product in the
quote.  Finally it did an OA-K to run the formulas in the template and total
the results.  It took about 4 or 5 hours to write and refine but it works
great.  Now we keep the quote templates in files seperate from the "price
list" files.  This was a change from using the @lookup command which only
allows two rows or two columns for data.  One column to match off of (equal to
or greater than, I think) and the resulting data to be returned.  Have you
ever tried to look up a part number using AWClassic's @lookup?  Not too great
if it is supposed to be in the middle of the list and isn't.
Your friendly BBud,

 Alan Woods
 ProLine: pro-abilink!saw
    UUCP: crash!pro-abilink!saw
    ARPA: crash!pro-abilink!saw@nocs.mil
    INET: saw@pro-abilink.cts.com
  Bitnet: saw%pro-abilink.cts.com@nosc.mil
    ICBM: N32-26.485 W99-42.035 WGS-72  <--- (Thanks, Vic!:)