Home  •  LifeWiki  •  Forums  •  Download Golly

## Exporting Data from Golly to Excel

For discussion directly related to ConwayLife.com, such as requesting changes to how the forums or wiki function.

### Exporting Data from Golly to Excel

Hi, I'm a highschool student and I'm writing my IB maths exploration on Chaos theory. I thought I could use Conway's game of life as a way to represent the Butterfly effect so I downloaded the Golly program, but I need a way to save all the results in one table on excel so I don't have to copy the results one by one. Can anybody help me ?

Also, can anyone recommend me a couple of patterns that will show perfectly the Butterfly effect?

Thank You!!

Carolina
acm3366

Posts: 1
Joined: March 25th, 2016, 4:47 pm

### Re: Exporting Data from Golly to Excel

Patterns>Life>Still-Lifes>random.rle:
`x = 98, y = 99, rule = B3/S23\$2obob2o3b2ob2o2bob2o3b2o3b2o2bo5bo8b2o2b2obob2ob2o3b2ob2o3b2o5b2ob2obo3b2ob2obo\$ob2obo5bobo2bob2o3bo2bobobo2b3o3b3o5bo2bo2bob2obobo4b2obobo3bo2b2o2bobob2o2bobobob2o\$6bo4bo2bobo4bo2bobobo7bo5bobo2bo2bobo5bobobo6bo3bo3bob2o2bo3b3obobo\$b6o5b2obobob2ob2obo2bo4b2obo2b4ob3ob3obob2ob2obob6obobo2b3o4b2ob2o4bobob3o\$o12bo3b2obobo2bobob2o2bob2obo8bo3b2o2bobo2bo6bobob2obo2b3o4bob2o2bobo3bo\$b2ob2obobobobo2bo3bobo2bobo2bo7bob2ob4o2bo3bobobobo2b3obo2bo4bo2bo2b4o4bobo2b2o\$2bobob2ob2obo3bo3bobob2o2bo2b6ob2obobo3b3ob2o2bobob3o2bob2obob3o4b2o3bob2obob2obo\$2bobo7bobobob2o3bo2b2o8bo7b3o3bo2b3obo4bobo4b2o3b4o2bo3bobobo4bo\$b2obob6ob2o2bo6b2o2b6o2bob6o4bo2bo5b4obobob2o4bo6bo2bobobobob3ob2obo\$o3bobo4bo3bobo8bobo5bobobo5b4ob2ob4o4bobobobob5ob4obob2o2bobobo4bob2o\$b4o2b2o3bobo2bobo4b2o2bobobobobo3bo2bo3bo2bo5b3o3bo2bo7bo3bobo3bobobo3b3o\$5bobo3b2obobob2o5bobob3obobob3obo2bo3bobob4o2b2o2b2obob4o2bob2o2bo3bobo2b3o3b4o\$b5o2bo5bobo7bo2bo5bobo2bo2bob2o2b2obobo3bo8bobo3bobo2bobob2obo2b2o2bobo4bo\$o5bobo2b4ob6o2bobo2b3obob2o3b2o2bobo2bobo2bobob6obobo2b2ob2obobo2bob3o2bo3b3o\$4o2bobobo11bobo2b2obo2bo3b3o2bobo2bo3bob2ob2o5bobob2o5bo2bob2o5bob4o3bo\$4bobobobo2b8obob3o5bob3o2bob2ob3o3bobo6b3obobo3b4obo3bo2b6o5bob2o\$2o2bobobobobo3bo3bobo4b2obob2o3bobo3bo3b4o3b5o2bobo2b3o3bo2b3o2bo7b5obo\$obobo2bobobob2o3bobo2b2obo2b2o4bobob4o2bo5b4o3bobo2bo5b2o2b2o3b2ob7o6bo\$2bo2bobobobobob4o2bobo3bo3b4obobo4b3ob2obo5bobobobo3b2obob2o2b2o2bobo7bob2ob2o\$bobobobobobobobo3bobobob2ob3o5bo3b2o4bobob2o2b3obobobobo2bobo3bobob2o3b2ob6obo2bo\$2bo2bo2bo2bobobo2b2obob2obo4b4ob4o2b3o3bo4bo4bobobob2obobo3bo2bo6bobo8bo\$3b3o5bobobobo3bo4bob2o4bo6bo3b4ob3ob5obo2bo3bob3obo3bobo3bo4b6o\$6b5obo2bobo3bob2obobob3o2bob3obobo6bo2bo6bo3b2obo4bo3b2ob3ob6o\$b4o5bobob2obob3obo2bo6b2o3bobobob5o2bobo2b2obob3o2bo2b2o4bo6bo7bob2o\$bo2bob2o4bobo3bo5bobo2b4o2b2o4bo2bo3bob2obobobobobo2bo2b2ob2o3bob4obob5ob2obo2b2o\$2bobobo5bo2b2obo2b2obobobo3bobo2b3obobo2bobo2bobobobobobobo9bobobo3bobobo2bo7b2o\$3b2o2bo5bobob2obo2b2obobo2bo2bobo2bobobob2obobo2bobob2obo2b11obobobo3bo4bob2obo\$o4b3o4b2obo4b2o4bobobo3bo2bobobobo2bo2b2ob2obo4bobo4bo7bobob5o2bobobob6o\$5o10bob2o3b4obobob3ob2obobobobobo4bo3bob2o2bo2bo4b2ob4o2bo5b3obobo6bo\$4bob2o4b4obob3o3bobobo5bo2bobobobob2o3bo3bobo4b7ob2o4bobo2b3o3bobob4o\$3obo2bo3bo5bo4b3o2bobob3obob2obobobobo2bob2ob2o2b4o11b3o2bobo3b3o2bo5bo\$o2bob2o4bob5ob2o3bobo2bobo2b2obo2bobobo2b3obo4b2o4bob2o2b5o3b2o2b3o4b2ob5o\$bobo5b2obo6bob3o2bobo3bo5b2o2bobo6bob2o3b2o2bobo2bo2bo2bobo2b2o3b4o3bo\$2obob2o2bo2bo2b3o8bob3ob6o2b3o2b4ob2obob3o2bobo2b3o5bob3o2b3o3bob2o2bo\$3bobobobob2obo3b9o4bo5bobo3bobo2bobo8b2ob3o9bo3bobo2b2obo2bob2o2bo\$3bobobobo4b4o9b3obobobobo2bo2bo2bobo2b8o6b5o6b3o2bobobobobo3b3o\$b2obo2bobob2o5bo2b2o2bo3bobob2obobobo3b2obobobo7bob4o5bob4o3bobo3bobo2bobo\$bo2bob2ob2ob2ob2obo2bo2bob3o2bo4bobob2o3bobobo2b8obo3b2o2b2obo3bobo2bo3bob2obobob2o\$2bobobo9bob2obob2o4b2ob4obobo2bo2bobobo12b2o3bo4bo2b2ob2ob2ob2o4bobobo\$b2obo2b5ob2obo2bobo4b2o2bobo4bobobo2b2obob4ob4ob2obob2ob5o3bo2bo2bo5b3o2bobo\$2bobo7b2o2b3o2b4obo3bobo2b3obob3o3bo4bobo2bobo2bo2bo10b2o2bo2b5o2b3ob2o\$2bobobobobo4bo3b2o3bobo2b2obobo3bobo3b2o2b4o3bobo2bobobo2b7o7b3o5bo4bo\$b2o2bob2ob4obo2bo2b2obobobo2bobob2obo3bobo7b4ob4o2bob2obo4b8o5b2obo2b2o2bo\$o2bobo8b2obobobo2bobobobo2bobo2b5o2b6obo8bobo2bo3bo9bob2o2bo2bobo2b2obo\$b2obobob5o4bobobo2bobobo2b3obobo5bobo4bo3b2ob2o2bob2obo2b10obobobobo2bob2obo2bo\$4bobobo4b4o2bob2obobob3o5bobob2obo2b2o3b3obobobobo2bobobo10b2obobob2obo2bobobo\$b2obobo2b3o5b2o5bobo4bob2obob2obobo4bo6bo3bobobo2bobo2b3ob3o4bobo4bobo2bob2o\$o2bo2b3o3b4obo6bobob4obo2bo5bob4o2bob2obobo2bo2bobo2bobo2bobo2b3obo2b4obo3bo\$bo2b2o3b3o3bobobob2obobobo5b3ob3obobo3b4obobob3o3bobobo2b2o3bobo2bob2obo3bo3b2ob2o\$2b2o3b2o4bobobob2obobobo2b5o3bo2bobo2b3o5bobo4b4obobobo5bob2obo2bobobo6bob2o\$5b2o2b6obobo3bobob2obo4b2obobo2b3o3b6obob2obo4bobob5obo2bob2obobob2o5bo\$2b3o2bobo6bo2bob2obo4bob2o3b2obobo3b2o9bobo2b4o2b2o4bob3o5bobo3bo3b2o\$bo3bobobob4ob3o3bobob2obobob2o3b2obob2o2b5ob3o3b2o3bobo3b2obo4b5obob3obo3bob2o\$bobo2bo2bobo2b2o3b2o3bob2ob2o2bob2o4b2obobo4bobo2b3o2bobo2bob2obobob2obo3bobo3bo2bo2bob2o\$2ob2obobo3bo4bo3b4o8bobob4o3bo2b2o2bobobo3bobobobobo4bo2bo2bobo4b2obo3bobo\$6bob5ob2ob4o4b9obobo2bob2obobobobobo2bobo2bobobobob2obobo2b2ob4obobob3o2bo\$2ob2o2bo6bobo5b3o4bo4bo3bobobo2bo3bobob4obobobo2b2obobo2bob2o6bobobo4b2ob2o\$bobo4b6o2bob4o4bo4b2obob3obo2b3obobobo5bo2bobobo3bo2bobo2bob4obobob5o2bo2bo\$o2bobo7bobobo5bob2o5bo2bo4b3o3bobo3b5o3bobo2bobob3o2bobobo2bobobo5bo2bobo\$2obob7o3bo3b5obo6bo3b4o3b2obobob2o5b3o2b4obo4b2o2bo2bobobobob2o2bob2ob2o\$bob2o7b3ob3obo5bo3bob4o3bobo2bobobobo2b3o4b2o6b4o4b2obobobobobobobobo\$o5bob2o2bo3bo5b4obobobo4b2obob3o2bobo3b2o2b3obo2bob3o4b4o2bobob2obo3bobobo\$4ob2obo7bob4obo3bobo3b2obobo5b2obobo6bo2bo2b2obo2b3obo3bobobo4b4o3bob2o\$3bobo2bo2bo3b2obo8bob4obobobob4o3bob4obobobo4bobobo2bobo2b2obo2b4o4b2obobo\$2obo2bobobobobo6b2o2b2obo3bobobobobo3bob2o5b2obob2o3bo2bob2o2bobo2bobobo4bo2bob2obo\$obobobobobobob2ob5o4bobob2o3bo2bo2bob2obo2b3o3bobo3b2obobobo3bobo2bobobob3obobo4b2o\$2bobobobobobo2bobo5bo2bo2bo2b3o3b3o3bo3b2o2b2obobob2obobobobo2b2o2b3obo2bo2bobob4obo2bo\$2bobobobobob2obo2b6o3bobobo9b2obo6bo2bobobobobobobobobo2b2o4b2obobo2bo4bobob2o\$b2ob2obo2bobo2b3o2bo7bo2b4o2bobo2bobob4obobo2bobobobobob2obobo4bobo3bobobo2b2o3bobo\$bo5bobo2bobo3bo3b2o2bobobo3b4ob3o2bobo2bobob3o2bo2bo2bo4bob6obob2obobob2o2b4o2bo\$2b6ob2obo2bobo3b2o2bobobob2o5bo5bobobo2b2o3b2obobobo2b3obo7bobo2bobo3b2o4b3o\$11bob3ob2o5b2obo2bo2b4obobobobo2bob2o3bo4bobo2b2o2bobob5obo2bobo2bobo3bobo\$4ob5obo13bob2obobo4bob2ob2obobo2bob2ob4obob2o2b2o2bobo3bo2bobobob2ob4ob2ob2o\$o2bobo3bo2b4ob2o6bo2bobob4obo7bob2obo2bo6bo2bobo2b2o2bobo2bobobobo7bo3bobo\$5bobo2b2o3bobo2bo2bob2obo2bo4bo2b2ob4obo2bobo2b3obobobo2bo5bob4obobobob5o3b2o\$4bobob2o2bo2bo2bob4o2bo2bobob2o5bobo4bobobob2o2bobobob2obob5o5bo2bobobo4b3o2b2o\$3bo2bobo2bobob2obo5bo3b2ob2o2b5o2bob2obobobo3bobobob2o3bobo5b3obobo2bo3b2obo2bo2bo\$3b4obob2obo4b5o2b3o6bo4bobobo2bobobo2b3obo2bo3b3obo2b3o3b2obobob4o2bobob2o\$o7bo2bobob3o5b2o4b6ob2obobobobo2bo2b2o3bob2o2b2o4bobo4bo3b2obo6bo2bo\$4ob4o2bobobo2b5o3b3obo5b2obo2b2obobobobo2bo2bo2b2o2b4o2b5ob2o3bobob3ob2obo\$3bobo3b2o2bo2bo6b3o6b3o4bo4bobo2bo2bob2obobo2bo5b2o6bob3o2bobo2bo3b2o\$2obo3bo2bobob2ob4obo2bob5o2bob2ob5o2bobobobo2bobobobob5o3bob2obo3bob2o2bobob2o2bo\$obo2bob2o3bo3bo3bobo3bo5bo2bobo5bobobobobobo4bob2obo4b4obo2bo3bo3b3o2bobobobo\$3b3o3b3ob2obo2bo3b3o2b3o2b2o2bob3obobobobo2bob3obo5b4o5bo2b2o3b3o3bobobobo2bo\$6bobo4bo2bobob3o3b2o3b2o2b2obo2bobobobo2bobo4bobob2obo3bob3ob2o3bobo3b2o2bobob2obo\$b4obob4obob2obobo2bobo2b2o4bo3bobo2bobob2obob4o3b2obo4b2obo2bo2b4o3b2obob2obobo2b2o\$o4bo5bobobo2bobo2bobobo2b5ob2obob3obo3bo6b3o3bobo3bobobo2bo4b3obobo2bobobobo\$4obob4o2bobob2o2b3ob2o2bo5bobo2bo4b3o2b4obo3bobo2b4o2bob2obob2o3bobob2obobobo2b2o\$3bobobo2bob2o2bo2b2o9b4obobo4b3o3b2o3bob5obobo6bo4bobob2obobo3bo2bo2bobo\$2obobo2bo2bo2bobobo2bob7o3bob2ob4o2bobo3bo2bo7bo2bob5ob4obo3bobobobo3bob2o2bo\$o2bo2bob2obo2bobob2obobo6b2obo4bo3bo3b3o2bob6obo2b2obo4bo5b3obo3bobobobo2bob2o\$bob4o4b4obo4bobob4obobob3obob2ob3o3b3o6bob2obo2bob2obob4o3bob4obob2obo3bo\$2o5b4o5bob3obo2bo2bo3bo4bobo3bo2b3o3b5obo4bob2obo2bobo4bobo5b2o4b2o2bo\$2b4obo2bob2obo2bo3bobo3bobo2b3obo2b2obobo3b2o6b2ob2obo4bobo3b4obobob2o4b3o2bob2o\$2bo2bo2bobobo3b2o4bo2b4ob3o3bob2o2bo2b2o2bob5o4bo2b6ob4o3bobobobob4o3bobo\$6bobobobob2o4b2obobo7bo2bo3bobobo2bobobo2bo5bobo6bo4bo4bobobobo3bobo2bob2o\$5b2obobo2bo2bobo2bobobob2ob3o2b2o3bobob2o2bobo5bobobobobob2obob3o5bobobo2bo2bobobo2b2o\$9b2o4b2ob2o4b2ob2obo10bo7bo5b2ob2o3b2obob2obo6b2ob2o2b2o3b2ob2o!`

Try messing with that.

Unfortunately I don't think you can mass export RLEs into Excel. But shouldn't be too bad, if you only need to export ~20 patterns.
I like making rules
fluffykitty

Posts: 332
Joined: June 14th, 2014, 5:03 pm

### Re: Exporting Data from Golly to Excel

This thread might be a place to start, in terms of patterns.

As for the problem of converting to Excel, I do know that Dave Greene (dvgrn) has a script to convert RLE to ASCII, and once that's done, use a text program to insert a tab after every character (by replacing each character with the same character plus tab). That should paste into Excel just fine.

Alternatively, if you're just looking to show differences over just a few generations, there is the option of programming CGoL directly into Excel.
I Like My Heisenburps! (and others)

Extrementhusiast

Posts: 1712
Joined: June 16th, 2009, 11:24 pm
Location: USA

### Re: Exporting Data from Golly to Excel

acm3366 wrote:Hi, I'm a highschool student and I'm writing my IB maths exploration on Chaos theory. I thought I could use Conway's game of life as a way to represent the Butterfly effect so I downloaded the Golly program, but I need a way to save all the results in one table on excel so I don't have to copy the results one by one. Can anybody help me ?

The question isn't quite clear. Are the "results" patterns? Beginning and final patterns, or every step along the way, or something showing the progressively increasing differences when you make a smallest-possible change at T=0?

You might be interested in this rule, which effectively runs two Life patterns simultaneously -- say, two very nearly identical starting configurations -- and uses four different colors to show the growth of the Butterfly Effect region.

It's just a few minutes' work to adapt one of my conversion scripts to export something like DoubleB3S23 to Excel, but you'd have to be much more specific about what your input data and desired output data would be.

acm3366 wrote:Also, can anyone recommend me a couple of patterns that will show perfectly the Butterfly effect?

You could generate minimally-different small patterns at random and be pretty sure of coming up with decent examples. The example that occurs to me offhand is below.

In each of these five-cell patterns, four cells the same, and the fifth is moved to a new location, one cell away or three cells away from its neighboring variant (depending on which pairs of patterns you're comparing). One pattern is a still life (boat), two are gliders, and one is the highly explosive R-pentomino:

`x = 34, y = 33, rule = B3/S23b2o28b2o\$bobo27bobo\$bo30bo28\$b2o28b2o\$2o28b2o\$bo30bo!`

dvgrn
Moderator

Posts: 4850
Joined: May 17th, 2009, 11:00 pm
Location: Madison, WI

Return to Website Discussion

### Who is online

Users browsing this forum: No registered users and 1 guest