Spreadsheets
19-Aug-91 13:10:18
Sb: #32320-Spreadsheets
Fm: Art Steinmetz 76044,3204
To: Khalid Aldoseri 75166,2531
I have done some spreadsheet graphic anims. I wanted to plot how the yield
difference among government bonds of various maturities (aka the Yield
Curve) has changed over the past ten years. MS-DOS spreadsheets allowed
macros to display multiple graphs but in a slideshow, not an animation,
context.
I printed the tabular yield data to a file and brought it into the Amiga
via CrossDOS. I wrote an Arexx macro to read that file and convert the
data points into appropriate screen coordinates for my graph. Using
DigiPaint I drew a graph background as my base image then extended the
macro to include the appropriate DigiPaint Arexx drawing commands. The
Arexx macro drew each line on the base image and saved each frame before
drawing the next. Once I got the kinks worked out I fed the whole mess 10
years worth of monthly data and let it crank. I used the PD MAKEANIM to
assemble the frames. Worked beautifully and made for a fairly interesting
view of some otherwise dry data.
HAM mode was wasteful in terms of processing time and resulting ANIM size
but at the time DigiPaint was the only paint package with Arexx support. I
put it to good use though by including a vibrant blue gradient fill
background to the graph. It made for a very professional appearance.
So….my 2 cents: Spreadsheet anims have some use. Also, existing Amiga
'sheets have IFF export ability. You migh provide IFF *IMPORT* ability to
allow snazzy backgrounds to your graphics and even the tabular worksheet
data. — Art