Category : Lotus and other Spreadsheets
Archive   : ZMACROS.ZIP
Filename : ZLIFE.WKS

#}/



ÿ

ÿp$H\D
G
G\Z((ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ#:0
ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò&ò'((

LB)
'*ÿÿÿÿÿÿÿÿ-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
ÿ'* ÿ#' *Iÿ

' ZLIFE...a 1-2-3 Release 1A worksheet that sets you up for LIFE!Iÿ
' ===============================================================Mÿ
'In LIFE, a cell is born in the next generation if its (empty) place inJÿ
'this one is surrounded by exactly three live cells; a cell survivesHÿ
'into the next generation if it's surrounded in this one by two orKÿ
'three live cells; and a cell dies before the next generation if it'sBÿ
'surrounded by more than three or fewer than two live cells.Mÿ

'In this worksheet, ZLIFE, macro Z sets things up so LIFE can evolve onMÿ
'the [Home] page. Run macro Z by pressing [Alt][Z]. Or read on if youKÿ
'like - or don't have ZLIFE on disk. What follows is enough to let aIÿ

'macro enthusiast recreate ZLIFE. But you don't have to do that...Jÿ
'...ZLIFE is now on the same disk as Z-macros (tm), $15 by mail fromDÿ
' JUST DISCS #276A, Box 34069, Seattle, WA 98124-1069Mÿ
'$19 from 206/384-3660 (10:00am to 2:00pm Pacific Time), VISA accepted. ñ#Mÿ
'John Conway, a Cambridge mathematician, described LIFE in the Sixties. ñ#Lÿ
'For LIFE's place in the unbelievably rich field of Cellular Automata,Jÿ
'see The Portable Universe by Steven Levy in Whole Earth Review #49,Mÿ
'Winter 1985. Levy says "...the game of LIFE took on a life of its ownMÿ
'in late 1970 when Martin Gardner, a columnist for Scientific American,Mÿ
'wrote about Conway's experiment." Gardner's report was printed in theKÿ
'October 1970 issue of Scientific American, pp 120 - 123. Go to yourMÿ
'library and check it out. (For some LIFE forms reported you'll need aKÿ
'bigger worksheet, like ZLIFE2 - coming soon)! Conway first ran LIFE<ÿ
'on a DEC PDP-7, but YOU can do it on a PC with 1-2-3!Kÿ
'The rules of LIFE, given in English on the [Home] page, are shown asKÿ
!'the following 1-2-3 formula : 2=A21#AND#A1#OR#3=A21 . (Z copies the+ÿ
"'formula all over that third page). Jÿ
$'Z moves the formulas from the nine cells below the rules of LIFE toMÿ
%'their proper places on the second page, and copies them to other cellsÿ
&'on that page.ÿ''* ÿ#'' *ÿ('2=A21#AND#A1#OR#3=A21 ÿ('\Z!ÿ('{home}{down}/re{end}{down} ñ#(%ñ)'+B1+A2+AJ1+A20+B2+AJ2+AJ20+B20ÿ)'{end}{right}~{end}{down}"ñ*'+B2+A3+AJ2+A1+B3+AJ3+AJ1+B1+ÿ*'/m{end}{down}{end}{down}{end}{down}~'ñ+'+B20+A1+AJ20+A19+B1+AJ1+AJ19+B19*ÿ+'{home}~{home}{end}{down}{end}{down}"ñ,'+C1+B2+A1+B20+C2+A2+A20+C20#ÿ,'/rnc\~~{down}/rnd\Z~/rnc\Z~~ñ-'+C2+B3+A2+B1+C3+A3+A1+C1ÿ-'{end}{down}/m{up}~{home}$ñ.'+C20+B1+A20+B19+C1+A1+A19+C19 ÿ.'{pgdn}{pgdn}{pgdn}~/xg\Z~'ñ/'+A1+AJ2+AI1+AJ20+A2+AI2+AI20+A20$ñ0'+A2+AJ3+AI2+AJ1+A3+AI3+AI1+A1&ÿ0'Second page has general format.)ñ1'+A20+AJ1+AI20+AJ19+A1+AI1+AI19+A19)ÿ1'Global format is +/-, column width(ÿ2'2, recalculation rowwise, manual.ÿ3'{edit}{home}{del}~/xrRÿ4'{home}{end}{down}/m{up}{up}~{home}{end}{right}{pgdn}~{home}/m~{pgdn}{pgdn}~Jÿ5'{down}/m{end}{down}~{home}{pgdn}~{home}{pgdn}{end}{down}/m{up}{up}~Jÿ6'{home}{pgdn}{right}~{end}{up}/m{right}{end}{right}~{end}{down}{up}~Kÿ7'{end}{down}/xc\~{right}/xc\~/c~.{end}{right}{left}~{end}{right}/xc\~Kÿ8'{end}{up}/xc\~/c~.{end}{down}{up}~{up}/xc\~{end}{left}/xc\~/c~.{end}Kÿ9'{right}{left}~{left}/xc\~{down}/xc\~/c~.{end}{down}{up}~{right}/xc\~Lÿ:'/c~.{end}{right}{left}{end}{down}{up}~{home}{pgdn}{pgdn}/xc\~/c~.{up}Gÿ;'{end}{right}{pgdn}~{pgdn}/rnd\Z~/rnc\Z~~{down}/rnd\~/rnc\~~/xg\~ÿ<'{calc}/xg\Z~9ÿ='{home}+A41~/c~.{pgdn}{end}{right}{up}~{goto}\~/re~Mÿ
>'After you've run Z, you can always get back here with [F5][F3][Enter].Lÿ
@'Macro D, below, sets up this demo. The comment tells how it does it.
ÿ
B
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB

ÿ B
ÿ
B
ÿB
ÿ B
ÿ
B
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿB
ÿ B
ÿ!B
ÿ"B
ÿ#B
ÿ
C
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC

ÿC
ÿ C

ÿ
C
ÿC
ÿ C
ÿ
C
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿC

ÿC
ÿC
ÿC
ÿC
ÿC
ÿC
ÿ C
ÿ!C
ÿ"C
ÿ#C
ÿ
D
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD

ÿD
ÿ D

ÿ
D
ÿD
ÿ D
ÿ
D
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD
ÿD

ÿD
ÿD

ÿD
ÿD
ÿD
ÿD
ÿD
ÿ D
ÿ!D
ÿ"D
ÿ#D
ÿ
E
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE

ÿ E
ÿ
E
ÿE
ÿ E
ÿ
E
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE
ÿE

ÿE
ÿE

ÿE
ÿE
ÿE
ÿE
ÿE
ÿ E
ÿ!E
ÿ"E
ÿ#E
ÿ
F
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿ F
ÿ
F
ÿF
ÿ F
ÿ
F
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF
ÿF

ÿF

ÿF
ÿF
ÿF
ÿF
ÿF
ÿ F
ÿ!F
ÿ"F
ÿ#F ÿG'\D3ÿ
G'{goto}\D~{end}{up}/c{end}{right}{end}{down}~ÿG'Copy range above to8ÿ
H'{home}{down}{down}{down}{down}{down}{down}{down}~ÿH'[Home] screen. Press1ÿ
I'{calc}{home}/c~.{end}{right}{pgdn}{up}~/xqÿI'[F9] and copy [Home]ÿJ'cell over changes.Lÿ
L'Run D. When it's through, it leaves you on the [Home] page where youIÿ
M'can run Z. Z runs until you press [Ctrl][Break] (and then [Esc]).Nÿ
N'Of course, you can make changes on the [Home] page yourself: enter a 1 Kÿ
O'for each new live cell, 0 for a dead one. Then press [F9]. Copy an3ÿ
P'unchanged cell over your changes, and run Z.Lÿ
R'The colony of six live cells on the left turns out to be stable. YouJÿ
S'can get some action by adding another live cell to make an unstableLÿ
T'colony like the one on the right. For the demo, you don't need to doLÿ
U'any adding - just run macro A. But when you've run A, and run Z, andLÿ
V'the whole issue is stable once more, you can experiment by adding yetKÿ
W'another live cell. If you add it at the bottom right of the lowest Mÿ
X'colony on the screen, you'll eventually see a "glider" evolve. That'sJÿ
Y'a colony that cycles through a series of shapes and moves across toMÿ
Z'the edge of the screen and wraps itself around to the other side - and4ÿ
['keeps on going until it meets another colony.Jÿ
]'Remember to press [F9] after making your changes, and then copy an Jÿ
^'unchanged cell over the ones you've changed before you run Z again.Lÿ
_'After you've done the copying, the CALC indicator will come on again.Jÿ
`'You can ignore it this time because your next step is to run Z, and7ÿ
a'the runtime version of macro Z contains {calc}. Lÿ
c'Seems that with LIFE you get Order out of Chaos. Makes you wonder...=ÿe' (c) Copyright 1985, George Atherton, Vancouver, B.C.Aÿg' 1-2-3 is a trademark of Lotus Corporation, Cambridge, MALÿi' The coined word, Z-macro, refers to a new approach to organizing andOÿj' extending 1-2-3 macros, and is a trademark property of the publisher ofÿk' this material,Dÿm' JUST DISCS #276A, Box 34069, Seattle, WA 98124-1069Oÿo' You may photocopy and distribute free printed copies of this worksheet,Mÿp' but may not transfer it from paper to disk for any purpose other thanNÿq' your own use. If you want to hand out free copies of the Z-macro diskOÿr' (that contains ZLIFE) you may do so. Here's what it says on that disk:Mÿt'Anyone may make and distribute free copies of this disk for personal Lÿu'or business use, but no part of the material may be used in a productNÿv'that's sold - without written permission from the author and publisher.Lÿw'Reasonable care must be taken to ensure that all copies are complete.Nÿx'To get a warranted unmodified copy of the most recent version, send $15Oÿy'to the publisher; or phone (206) 384-3660 from 10:00am to 2:00pm PacificLÿz'Time, and pay by VISA. (There's an additional $4 handling charge forLÿ{'phone orders). As a paying customer you receive a disk, a money-backNÿ|'guarantee and a $5 credit note you can use as part payment for the nextCÿ}'version...and a letter about that when it's ready to ship...