Iteration & Conway’s Game of Life

re: Iteration & Conway’s Game of Life

Alex — Sat, 03 Nov 2007 03:06:37 GMT

If you use 0-s (or blanks) and 1-s, =(nbors=3)+AND(nbors=2,B2) is a bit shorter :-)

re: Map wrap-around

Rick Williams — Mon, 05 Nov 2007 06:14:26 GMT

The easiest way I can see to achieve the wrap around would be to add one additional cell at each boundary (top, bottom, left and right) of both sheets which simply takes the result calculated at the opposite edge of the board.

This would then not require any modification to the more complex formulae involved in the calculation.

re: Iteration & Conway’s Game of Life

Kanwaljit Singh Dhunna — Wed, 07 Nov 2007 12:16:44 GMT

Hi David,

When I saw the Print preview of the above article, words in "BOLD" were looking jumbled up with other words. Anyway A nice Article.

Below is a link highlighting something which I feel should be categorized as a "BUG" and may be of interest to you. I am reporting here because I don't where I should have been reporting. Sorry for that.

http://www.asap-utilities.com/blog/

Problem with copying filtered data in Excel 2007 + workaround

It says "you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 works". In that way Excel 2000-2003 is better than Excel 2007.

Regards

CA kanwaljit Singh Dhunna

India

re: Iteration & Conway’s Game of Life

John Greenan — Wed, 07 Nov 2007 17:41:12 GMT

Excellent article explaining a generally poorly understood area of Excel!

Keep up the good work.

re: Iteration & Conway’s Game of Life

Dan B (MS) — Wed, 07 Nov 2007 20:13:22 GMT

kanwaljit: Can you use the this form: (http://blogs.msdn.com/excel/contact.aspx) to send us an email with a sample workbook and the repro steps for the selection/copy/paste issue you are running into? That way, we can follow up and better understand what's going on.

Thanks! Dan

re: Iteration & Conway’s Game of Life

Chris Rae (MS) — Thu, 08 Nov 2007 22:51:47 GMT

Alex - that's a good point. And all that after me singing the praises of using TRUE/FALSE.

Rick - that's a much more elegant solution than my rather ugly one. I wish I'd thought of it!

Chris

re: Iteration & Conway’s Game of Life

Keith Duffy — Sun, 11 Nov 2007 21:53:14 GMT

Nice job. I thought it was a good implementation of Excel iteration, a tough concept to get a grip on, for Excel users, myself included! Keep up the fine work.

Best regards,

Keith

re: Iteration & Conway’s Game of Life

Alex — Tue, 13 Nov 2007 00:00:01 GMT

Chris, when do we see the updated tutorial then? :)

re: Iteration & Conway’s Game of Life

Kanwaljit Singh Dhunna — Wed, 14 Nov 2007 16:46:39 GMT

Hi Dan,

I posted my comments at the place you specified, but don't know where to look for the follow up comments.

Thanks

CA Kanwaljit Singh Dhunna

re: Iteration & Conway’s Game of Life

Dan B (MS) — Thu, 15 Nov 2007 01:08:52 GMT

Kanwaljit - looks like we never got your email, could you use the email form again and resend it?

Thanks!

re: Iteration & Conway’s Game of Life

Stephen Bullen — Fri, 23 Nov 2007 12:06:49 GMT

Hi Chris,

Instead of using that second sheet, you can do it all in an array formula - so the entire grid is a single array formula, which is also circular. I did this and a lot of other examples when I was first playing with circular references in '96. The results (including my Life.zip solution) can be found in the "Worksheet Functions" section of my Excel page - www.oaltd.co.uk/Excel.

Regards

Stephen Bullen

Unusual (but cool!) Uses of Excel

Microsoft Excel — Fri, 07 Mar 2008 02:10:12 GMT

Many of you who have been using Excel for a long time have most likely seen some of the creative, interesting,

Unusual (but cool!) Uses of Excel

Noticias externas — Fri, 07 Mar 2008 02:29:49 GMT

Many of you who have been using Excel for a long time have most likely seen some of the creative, interesting

Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2

Microsoft Excel — Tue, 30 Sep 2008 09:02:05 GMT

Today's author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in