├─┼─┼─┤
│4│5│9│
├─┼─┼─┤
│6│9│6│
└─┴─┴─┘
to show off, repeatedly growing spreadsheet 5 times with the algorithm
extendSumAvg^:5 i.3 3
0 1 2 3 6 12 24 48
3 4 5 12 24 48 96 192
6 7 8 21 42 84 168 336
9 12 15 12 48 96 192 384
18 24
x27;wa 1 0 to 3 0 } 1 2 3 bea 1 1 to 3 1} 'foods qty'wa 0 0 to 0 1} 5 3 $ < ''
- Original Message -
From: Joe Bogner
To: programm...@jsoftware.com
Cc:
Sent: Monday, August 18, 2014 9:15:42 PM
Subject: Re: [Jprogramming] dsl for spreadsheet like input selectors
P
PM, 'Pascal Jasmin' via Programming <
programm...@jsoftware.com> wrote:
> sorry, mistyped to2
>
> to2
> =: [: <"1 [: ,."0/&>/ [ +&.> [: i.@:>:&.> -~
>
>
> - Original Message -
> From: Brian Schott
> To: Prog
sorry, mistyped to2
to2
=: [: <"1 [: ,."0/&>/ [ +&.> [: i.@:>:&.> -~
- Original Message -
From: Brian Schott
To: Programming forum
Cc:
Sent: Monday, August 18, 2014 5:32:43 PM
Subject: Re: [Jprogramming] dsl for spreadsheet like input selector
I am not getting good results with to2.
I am playing with the following.
CP=: {@(,&<)
cross =: [: CP &>/< @:i.@>:"0
0 1 -.~&(,&cross) 2 3
┌───┬───┬───┬───┬───┬───┬───┬───┬───┬───┐
│0 2│0 3│1 0│1 1│1 2│1 3│2 0│2 1│2 2│2 3│
└───┴───┴───┴───┴───┴───┴───┴───┴───┴───┘
On Mon, Aug 18, 2014 at
spreadsheets have a range selection syntax like A1:C3&F4~B2 which means the
block range from A1 to C3 with the cell F4 added, and the cell B2 removed.
Ignoring the letter conversions, here are some useful J functions for building
a list of selectors (can be used with both { and }). Conjunction
