Yes, Joe and Raul, I am better understanding how to make the webspread work. I was exploring ideas for writing formulae that did not require so much curtailing within the summation, or in other "insert" style, formulae, for example. But I don't suppose there is an easy solution.
But, Joe, your spreadsheet demo is very informative regarding JHS programming, and uncovers how difficult it would be to develop such a spreadsheet in J that was easy to use. I got lost in the weeds trying to think about that and lost the beauty of your concoction in being able to maintain the formula in a cell while show the formula result in the output area. That is quite an accomplishment. On Tue, Feb 25, 2014 at 4:01 PM, Joe Bogner <[email protected]> wrote: > Hi Brian, I'm happy to see you playing around with webspread. > > I'm not sure I understand what you're looking for. > > Given: > > r_webspread_ > ┌─┬──┬──┐ > │1│13│14│ > ├─┼──┼──┤ > │2│2 │4 │ > └─┴──┴──┘ > > I usually have column totals or row totals as the last row/column. So an > easy trick is to just curtail the array: > > But you need to have a blank cell first to put the result in... > > r_webspread_ > ┌─┬──┬──┬──┐ > │1│13│14│28│ > ├─┼──┼──┼──┤ > │2│2 │4 │ │ > └─┴──┴──┴──┘ > > > This is what the spreadsheet text looks like: > > 1 13 14 +/ (> }: 0{::r) > 2 2 4 > > Does that help address your question? > > > > -- (B=) ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
