Pyro's Excel Goodies

Reply
 
LinkBack Thread Tools
  #12 (permalink)  
Old 02-04-2008
Symbology's Avatar
Questioning

Join Date: Nov 2007
Location: Houston, TX
Posts: 153
Symbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of light
Re: Pyro's Excel Goodies

What was the inspiration / reason for the Ocean simulator?

In my first run, my poor sharks were isolated and became extinct in nothing flat. (They died looking for food I believe.) So it was interesting to see that the fish and plants still maintained a harmonic.

I had never thought about how populations in nature likely are on such a clearly sinusoidal pattern. While watching the actual locations it is not nearly so obvious. It just looks like "business as usual". Though I am able to see at times that one or the other population is growing larger.

I wonder what future patterns we will see in ourselves when all humans are RFID tagged.
__________________
Point: Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.
~ Charles Mingus

Counter Point: The simplest solutions are often the cleverest.
They are also usually wrong.

Last edited by Symbology; 02-04-2008 at 02:14 PM.
Reply With Quote
  #13 (permalink)  
Old 02-04-2008
Pyrotex's Avatar
Slaying Bad Memes
Latest blog: The Problem With Ike
Hypography Staff Member
Moderator
Editor
13 Days in Hell Champion!
Join Date: Nov 2005
Location: Houston, Texas
Posts: 3,848
Blog Entries: 7
Pyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond repute
Send a message via MSN to Pyrotex
Re: Pyro's Excel Goodies

Quote:
Originally Posted by Symbology View Post
What was the inspiration / reason for the Ocean simulator?
I was reading the book "Chaos--The Birth of a New Science".
There was a chapter on the inter-dependence of populations and birth rates.
I thought about modeling then, but got stuck. Years later, I attacked it again just to see if I could. I could.

Yeah, on rare occassions, the sharks starve. The reason is that I can't figure out how to program them with a sense of smell.
__________________
Hypography Forums Moderator
-- - - - - -
What concerns me is not the way things are, but rather the way people think things are.
Epictetus, Greek Philosopher
The map is NOT the territory.
Korzybski, Polish-American Philosopher

Last edited by Pyrotex; 02-04-2008 at 02:24 PM.
Reply With Quote
  #14 (permalink)  
Old 02-04-2008
Pyrotex's Avatar
Slaying Bad Memes
Latest blog: The Problem With Ike
Hypography Staff Member
Moderator
Editor
13 Days in Hell Champion!
Join Date: Nov 2005
Location: Houston, Texas
Posts: 3,848
Blog Entries: 7
Pyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond repute
Send a message via MSN to Pyrotex
Re: Pyro's Excel Goodies

This one is esoteric, abstruse and arcane. Other than that, it should be very useful!
It is a Parameter Index Constructor.

You know how you build all these equations into a really complex spreadsheet and then you have a problem with one, say, it's called fotjpi2, and you need to know every cell where that named parameter is used? Does that experience ring a bell? You ever have that problem? Well, do you, Bubbie?

I guess not. Well... sometimes, I do. Here is a solution of sorts. It is a method whereby you can get Excel itself to build you an index of all your parameters with addresses of every location where an equation uses them.

Sound like fun?

I guess you have to be there.
Attached Files To view attachments in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________
Hypography Forums Moderator
-- - - - - -
What concerns me is not the way things are, but rather the way people think things are.
Epictetus, Greek Philosopher
The map is NOT the territory.
Korzybski, Polish-American Philosopher

Last edited by Pyrotex; 02-04-2008 at 02:26 PM.
Reply With Quote
  #15 (permalink)  
Old 02-04-2008
Pyrotex's Avatar
Slaying Bad Memes
Latest blog: The Problem With Ike
Hypography Staff Member
Moderator
Editor
13 Days in Hell Champion!
Join Date: Nov 2005
Location: Houston, Texas
Posts: 3,848
Blog Entries: 7
Pyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond repute
Send a message via MSN to Pyrotex
Re: Pyro's Excel Goodies

This is a simple one, and yet chillingly profound.
It is the Cosmic Font of Random Truth.

Impressed, aren't you? It uses simple equations and functions that manipulate text rather than numbers.
Attached Files To view attachments in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________
Hypography Forums Moderator
-- - - - - -
What concerns me is not the way things are, but rather the way people think things are.
Epictetus, Greek Philosopher
The map is NOT the territory.
Korzybski, Polish-American Philosopher
Reply With Quote
  #16 (permalink)  
Old 02-04-2008
Symbology's Avatar
Questioning

Join Date: Nov 2007
Location: Houston, TX
Posts: 153
Symbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of light
Re: Pyro's Excel Goodies

Quote:
Originally Posted by Pyrotex View Post
I was reading the book "Chaos--The Birth of a New Science".
There was a chapter on the inter-dependence of populations and birth rates.
I thought about modeling then, but got stuck. Years later, I attacked it again just to see if I could. I could.
Nice. I appreciate the concrete lesson!

Quote:
Originally Posted by Pyrotex View Post
Yeah, on rare occassions, the sharks starve. The reason is that I can't figure out how to program them with a sense of smell.
Hint: Smell generally comes from something leaving (an apparently hidden) trail.
As in "I smell a rat" or "I smell trouble" or "something smells fishy here"

"Decay" is another handy word. Although it takes more memory of course.
__________________
Point: Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.
~ Charles Mingus

Counter Point: The simplest solutions are often the cleverest.
They are also usually wrong.
Reply With Quote
  #17 (permalink)  
Old 02-04-2008
Pyrotex's Avatar
Slaying Bad Memes
Latest blog: The Problem With Ike
Hypography Staff Member
Moderator
Editor
13 Days in Hell Champion!
Join Date: Nov 2005
Location: Houston, Texas
Posts: 3,848
Blog Entries: 7
Pyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond repute
Send a message via MSN to Pyrotex
Re: Pyro's Excel Goodies

This one is oh, so simple. Basically, it just iteratively calculates a simple equation 1,000 times and plots the results. But it allows you to stare directly into the eyes of Chaos itself.

I'm not kidding. Really. I mean it. I'm dead serious about this.

Yeah, "Chaos", the real thing. The mathematical entity. This equation comes right out of the book, "Chaos--The Birth of a New Science". Spend enough time with this spreadsheet and you will know Chaos intimately. Assuming you're still sane.

Such a dirt simple equation. It should create such dirt simple plots.
Really.
There's no rational reason for it to suddenly start giving you two solutions instead of one. Then four solutions. Then eight. Then... Then...

Then...

Then... omigod... OMIGOD... IT'S... CHAOS!!!!!!

No, really... I'm dead serious...
Attached Files To view attachments in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________
Hypography Forums Moderator
-- - - - - -
What concerns me is not the way things are, but rather the way people think things are.
Epictetus, Greek Philosopher
The map is NOT the territory.
Korzybski, Polish-American Philosopher

Last edited by Pyrotex; 02-05-2008 at 07:31 AM.
Reply With Quote
  #18 (permalink)  
Old 02-04-2008
Jay-qu's Avatar
Ancora Imparo
Hypography Staff Member
Moderator
Editor
Gallery Curator
Basic Subscription
Sponsor
2D Memory Champion!
Join Date: Feb 2005
Location: Australia
Posts: 5,603
Blog Entries: 1
Jay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant futureJay-qu has a brilliant future
Re: Pyro's Excel Goodies

Excellent Pyro, I remember being thrilled with one of your 'chaos generators' you posted a while back

Question can the drunkards walk to likened to brownian motion?
__________________
Jay-qu
::Hypography Moderator of..
Chemistry, Physics & Mathematics, Astronomy & Cosmology, Space and Technology & gadgets Forums

Einstein said that if quantum mechanics is right, then the world is crazy. Well, Einstein was right. The world is crazy.
-Daniel Greenberger

Physics Guides - Physics Resources and help
Reply With Quote
  #19 (permalink)  
Old 02-04-2008
Symbology's Avatar
Questioning

Join Date: Nov 2007
Location: Houston, TX
Posts: 153
Symbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of lightSymbology is a glorious beacon of light
Re: Pyro's Excel Goodies

Quote:
Originally Posted by Pyrotex View Post
This one is oh, so simple. Basically, it just iteratively calculates a simple equation 1,000 times and plots the results. But it allows you to stare directly into the eyes of Chaos itself.

I'm not kidding. Really. I mean it. I'm dead serious about this.

Yeah, "Chaos", the real thing. The mathematical entity. This equation comes right out of the book, "Chaos--The Birth of a New Science". Spend enough time with this spreadsheet and you will know Chaos intimately. Assuming you're still sane.

Such a dirt simple equation. It should create such dirt simple plots.
Really.
There's no rational reason for it to suddenly start giving you two solutions instead of one. Then four solutions. Then eight. Then... Then...

Then...

Then... omigod... OMIGOD... IT'S... CHAOS!!!!!!

No, really... I'm dead serious...
Interesting how there are moments of calm in the storm like going from 3.9601 to 3.9602
__________________
Point: Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.
~ Charles Mingus

Counter Point: The simplest solutions are often the cleverest.
They are also usually wrong.
Reply With Quote
  #20 (permalink)  
Old 02-05-2008
Pyrotex's Avatar
Slaying Bad Memes
Latest blog: The Problem With Ike
Hypography Staff Member
Moderator
Editor
13 Days in Hell Champion!
Join Date: Nov 2005
Location: Houston, Texas
Posts: 3,848
Blog Entries: 7
Pyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond reputePyrotex has a reputation beyond repute
Send a message via MSN to Pyrotex
Re: Pyro's Excel Goodies

Quote:
Originally Posted by Jay-qu View Post
...Question can the drunkards walk to likened to brownian motion?
Thank you.
Yes.
An odd result of statistics as applied to the drunkard's walk: the average distance the drunkard actually travels from the starting point after N random steps is around the square root of N.
Hmmm.
Makes you think, don't it?
__________________
Hypography Forums Moderator
-- - - - - -
What concerns me is not the way things are, but rather the way people think things are.
Epictetus, Greek Philosopher
The map is NOT the territory.
Korzybski, Polish-American Philosopher
Reply With Quote
Reply

Bookmarks

Tags
excel, formulas, macros, spreadsheet, spreadsheets, vba


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 compatibility freeztar Suggestions and Wish List 11 01-29-2008
How to convert Ms. Excel spreadsheet to MS. SQL? cannonbow88 Computer Science 2 09-27-2006
How to convert MS Excel format to My SQL? Chloe Computer Science 5 08-11-2005

» Current Poll
Do you read popular science books?
Yes, a few each year - 60.00%
6 Votes
Yes, but very rarely - 10.00%
1 Vote
Yes, most of the time - 20.00%
2 Votes
No - 10.00%
1 Vote
Total Votes: 10
You may not vote on this poll.

All times are GMT -8. The time now is 08:44 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc.
Copyright © 2000-2008 Hypography
Part of the Hypography - Science for Everyone Network