Log in

No account? Create an account
Well, compbio took utterly too much of my time... although it was… - dmv/blogs/lj — LiveJournal

> Recent Entries
> Archive
> Friends
> Profile
> dmv/index


Alt. Info Streams
Flickr Stream

April 11th, 2002

Previous Entry Share Next Entry
02:23 am
Well, compbio took utterly too much of my time... although it was weird to take out my excel muscles and flex em. Time was, its true, I played spreadsheet cowboy. But I picked up some new things: new aggravations at some of the UI behavior, but also some new tricks, and a better understanding of why some people try to do CAs in excel. Still wrong, but whatever.

Thought experiment/Challenge: using whatever Excel trickery you have at your mental disposal, figure out how to get a cell to modify its own code during evaluation. That is, consider evolutionary CA which adapt their rules...

But, since I stayed up too late working on compbio, I just won't go tomorrow!

(2 comments | Leave a comment)


Date:April 11th, 2002 05:15 am (UTC)
I actually think the harder part would be to developing a way of "clocking" all the cells in the spreadsheet. At least as far as I can remember, the way spreadsheet cells update would not allow for a continous synchronous simulation. Of course one can consider the idea of asynchronous automata.
[User Picture]
Date:April 11th, 2002 03:16 pm (UTC)
Indeed -- asynchronous may be more fun.

In our assignment last night, we were driving equations to a steady-state equilibrium. The second spreadsheet was to do so using only two cells per reactant. Murphy recommended using a "Flag" approach to initialization (ie. one of the cells was IF( flag=0, initialize, run )). I wonder if you could use a similar mechanism, along with explicit Iteration mode calculation method to get synchronization...

> Go to Top