Article View: comp.sys.next.software
Article #1210Hepl with Lotus IMPROV
From: William J Blackert
Date: Wed, 30 Sep 1992 13:22
Date: Wed, 30 Sep 1992 13:22
21 lines
1754 bytes
1754 bytes
Here is one for all of you IMPROV guru's out there. I'm working on a problem in which I need to do iterations on a grid of numbers. The iteration works like this (assuming a x-y coordinate system) val(x,y) = .25*(val(x-1,y) + val(x+1,y) + val(x,y-1) + val(x,y+1)) With any other spreadsheet I would have just entered this formula in one cell and then replicated them around the sheet (except for the border values which are set initially). The glitch is the only spreadsheet I have personal access to is IMPROV. I attempted to use NEXT, PREV and THIS to referece the cells around the current one but apparenty IMPROV won't allow for using a NEXT and PREV in the same formula. So here comes the question... does anyone have any ideas how to do what I want to do (short of writting an individual formula for each cell that needs to be computed (which I'm willing to do, it's a small enough grid but would rather not))? Thanks for any input, please send me e-mail and I'll post a summary of anything that works. Bill Blackert blackewj@nextwork.rose-hulman.edu Rose-Hulman Institute of Tech. NeXTMail Welcome and encouraged!
Technical Details
Message-ID:
<1992Sep30.132221.11748@cs.rose-hulman.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!noc.near.net!news.Brown.EDU!qt.cs.utexas.edu!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!usenet.ucs.indiana.edu!newshost.cs.rose-hulman.edu!newsShow Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.software Path: arc1-ca.pugleaf.net!sparky!uunet!noc.near.net!news.Brown.EDU!qt.cs.utexas.edu!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!usenet.ucs.indiana.edu!newshost.cs.rose-hulman.edu!news From: blackewj@NeXTwork.Rose-Hulman.Edu (William J Blackert) Subject: Hepl with Lotus IMPROV Message-ID: <1992Sep30.132221.11748@cs.rose-hulman.edu> Keywords: IMPROV Sender: news@cs.rose-hulman.edu (The News Administrator) Nntp-Posting-Host: g222-01.nextwork.rose-hulman.edu Organization: Rose-Hulman Institute of Technology Date: Wed, 30 Sep 1992 13:22:21 GMT Lines: 21