In terms of spreadsheets, J is an excellent replacement, but usually using the grid is not necessary.
For instance figuring out the loan balance of say a $10k loan at 5% interest with payment schedule p, where payments are made at end of period (so interest is calculated on balance right before payment) p =. 10 $ _1000 NB. first payment is in last position. ([ + 1.05 * ]) / p , 10000 3711.05 ([ + 1.0 * ]) / p , 10000 0 If there is any pattern to data, it is usually much more quickly/simply expressed in J than excel, and if there is no pattern, it is still easily entered and edited in J as raw data. an alternate way of getting the above answer 1000 (-~ 1.05 * ])^:10 ] 10000 3711.05 seeing the balance at the end of each year: 1000 (-~ 1.05 * ])^:(i.15) ] 10000 10000 9500 8975 8423.75 7844.94 7237.18 6599.04 5929 5225.45 4486.72 3711.05 2896.61 2041.44 1143.51 200.684 Its pretty easy to see the effect of changes in interest rate or fixed payment, that in a spreadsheet would alter the number of rows, and get tedious. ----- Original Message ----- From: Jim Russell <jimsruss...@yahoo.com> To: "programm...@jsoftware.com" <programm...@jsoftware.com> Cc: Sent: Sunday, February 16, 2014 12:54:08 PM Subject: Re: [Jprogramming] J in 5 minutes I'm guessing, cause I never got much beyond the labs. I think it presents an existing array, but lets you receive events for changes to any cell; given that, what tool for updating one or more cells in an array is better than J? I think it serves best as a tool to implement a "finished product" spread sheet for users, rather than one for a non-programmer to build his own. I should go back through the grid labs to be sure. > On Feb 16, 2014, at 12:38 PM, Brian Schott <schott.br...@gmail.com> wrote: > > Jim, I did look there. I even looked at the example page. None of the > examples seem to suggest that formulas can be embedded in the cells. Am I > wrong? > > --- > (B=) > >> On Feb 16, 2014, at 12:16 PM, Jim Russell <jimsruss...@yahoo.com> wrote: >> >> See: >> http://www.jsoftware.com/jwiki/Grid >> Chris did the work using isigraph. I don't know if that has survived the >> progress of j6, j7, and j8. > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
