                               [?] Sums [?]

One of the classic applications of the Pilot is to replace standard paper
and pencil. I keep my Pilot with me at all occasions and if I want to
scribble something down I simply enter it in my trustworthy electronic
companion. So why not also use it for keeping balances at games like
ScrabbleTM, card or dice games. It would sum the points for each player and
thus eliminate all cheating and miscalculations. Of course, I have no
ambitions on a ExcelTM for Pilot, just a simple "sum spreadsheet".

So here it is, Sums V1.4  which calculates sums of integers and fix point
numbers in multiple columns simultaneously. It is free but copyrighted for
legal reasons. Mail me if you want to see the source.

Installation and Usage

After installing the file sums.prc (use instapp.exe from your pilot
directory) on the Pilot you start with two columns. You can make up to four
columns visible on the screen by choosing the appropriate number from the
"Visible" menu. To see other columns use the horizonzal scroll arrows. The
total number of columns the program can manage is 10 and can be adjusted
with the "Columns->Add" and "Columns->Remove" menu entries. The currently
active column can be collapsed, i.e. replaced by its sum, via
"Columns->Collapse". The program remembers the total and visible number of
columns on future starts as well as the column headings and the data.
Display of the vertical column separators and optional right justified data
can be adjusted in the "Columns->Preferences" screen. You can also choose
the separator of the integral and fraction part of a number to be either
"." or ",".
The calculation works with positive or negative integer or floating (fix)
point numbers. Rounding of results from 0 to 8 digits can be specified in
preferences. Letters or special characters are ignored for calculations.
Every time you enter something, the program recalculates the sum for each
column. You can use cut/copy/paste and keyboard input as in other Pilot
applications.
If the heading of one of the columns is "Sum" or "Summe" (german word for
sum), horizontal sums over all columns will be shown in this column. For
perfomance reasons the horizontal sums will only be calulated if you
manually refresh the display with the "Refresh" button.

Known bugs and problems

   * scrolling should be locked for all columns
   * maybe should use global preferences for appearance of numbers and
     fraction separators

History

First of all, thanks for all your feedback.

   * V1.4
     horizontal sums, another fix-point bug fixed, user can choose between
     "." or "," as separators
   * V1.3a
     fixed bug with scroll buttons
   * V1.3
     implemented my own fix-point arithmetic, float libs are not usable
     extended preferences menu
   * V1.2
     added horizontal scrolling with up to 10 columns, user interface
     (menus) totally rewritten, small bug fixes
   * V1.1
     added floating point capability
   * V1.0
     first public version

---------------------------------------------------------------------------
Andreas Linke, a.linke@sap-ag.de, 20-Jul-97

Copyright (c), 1997, by Andreas Linke, Heidelberg, Germany

Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions
are met:

1. Redistributions of source code must retain the above copyright
   notice, this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright
   notice, this list of conditions and the following disclaimer in the
   documentation and/or other materials provided with the distribution.
3. All modifications to the source code must be clearly marked as
   such.  Binary redistributions based on modified source code
   must be clearly marked as modified versions in the documentation
   and/or other materials provided with the distribution.
4. All advertising materials mentioning features or use of this software
   must display the following acknowledgment:
     This product includes software developed by Andreas Linke.
5. The name of Andreas Linke may not be used to endorse or promote
   products derived from this software without specific prior
   written permission.

THIS SOFTWARE IS PROVIDED BY ANDREAS LINKE ``AS IS'' AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
ARE DISCLAIMED.  IN NO EVENT SHALL ANDREAS LINKE BE LIABLE
FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
SUCH DAMAGE.

