Raul,
Thanks for your reply. It's so great that you reply
to almost any idea, even such hairbrained, halfbaked ideas
as mine.
Google docs does perhaps make sense, especially
because it is so available and free.
Your comment about spreadsheets being scalar seems
to off the mark a little to me, because there are plenty of
spreadsheet formulae that refer to cell ranges, such as
Excel's SUM(A1:E4). To me the bigger problem is making a
cell aware of its own geographic position relative to other
cells: the whole cell referencing thing. Still, you make a
good point and I am beginning to understand the situation a
little better.
But thinking more about your reply, it occurs to me
that I should be more specific about the problem I have been
contemplating writing a small app to solve. The scenario is
4 guys playing bridge for 5 hours or so, and changing
partners after every rubber. The spreadsheet at the
hyperlink below shows the scheme where columns A, B, C, and
D are used for each rubber and columns H, I, J, K, and L
contain running sums of the rubbers, and would typically be
a separate sheet, not columns on the same sheet with A, B,
C, and D.
http://www.pixentral.com/show.php?picture=1PClHxSiRzbGytd3ExEn1RZOSvA16
Henry Rich's bridge scoring J program is very good
at computing the totals produced in rows 25 and higher from
inputs entered in rows 2 through 18, once the inputs are
translated into integers from strings. But how does one
produce a J program or a J/spreadsheet program combination
to accomplish this? (If the compactness of the outputs in
rows 25 and up are a special problem, I would be happy for
each of those rows to simply have one entry instead of some
having two entries, and other accommodations for
simplification would be fine.)
I have added a few comments in column E
It seems especially desirable for the inputs in rows
lower than 25 to be editable, in case an entry error is
found, and then for the outputs in higher rows to
dynamically change like they would in a spreadsheet, and for
the running subtotals also to dynamically recalculate.
So are these things that can be done handily with
Tara, google docs, or the like?
Thanks, again,
On Wed, 19 May 2010, Raul Miller wrote:
Personally, I would like to wire up J to the google docs
spreadsheet. This would probably be best done in the
javascript exported by jhs.
And the cell equations would be in the standard
spreadsheet language, not in J. They are atomic
in character, after all, even when they deal with
arrays.
--
(B=)
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
