🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.software
Article #1210

Hepl with Lotus IMPROV

#1210
From: William J Blackert
Date: Wed, 30 Sep 1992 13:22
21 lines
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!news

Show 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