Jump to content
Science Forums

Recommended Posts

Posted
Okay, here it is in Word/97 format

 

Oooooooooohhhhhhhhhmmmmmmmmmmmmmmmmmmm. :doh: That is one organic web there. I will be sure & show it to Spider. He's gonna want to know the particulars though. :turtle:

 

P? O? F? ditty?

hunh?

:hyper:

 

probability of failure encantation :D

Posted
Oooooooooohhhhhhhhhmmmmmmmmmmmmmmmmmmm. :turtle: That is one organic web there. I will be sure & show it to Spider. He's gonna want to know the particulars though. ...

Ahhh, Little Grassturtle, here are the particulars. In three parts.

 

(1) Along the top row, starting at cell A1, put first a 0, then 1, then 2, then 3, etc, counting up to any value, and then start counting DOWN until you are back at 0.

 

Along the leftmost column, starting at cell A1, go downwards doing the same thing. 0, 1, 2, 3,... 20, 21, 20, 19,... 3, 2, 1, 0

 

(2) In cell B2, insert the formula

 

=INT(10*(SQRT(B$1*B$1+$A2*$A2)-INT(SQRT(B$1*B$1+$A2*$A2))))

 

This formula has two inputs: the value in row 1 directly above it; and the value in column A directly to the left of it.

 

Now select all cells starting from B2... all the way to the right to include the last column in which you put a "1" at the top... AND all the way down to include the last row in which you put a "1" in its leftmost cell.

 

Press Control-R, then Control-D. This copies the formula to the Right and then Down. (or in reverse order, makes no never mind). Or...you can just copy cell B2, and paste it all the way to the right and all the way down.

 

Don't click nothing! hands off that mouse! Keep that block selection!

 

(3) Finally, you must give the selected cells (the ones with that big honkin formula in them) "Conditional Formatting". With the mouse (careful) pull down the Format Menu and select Conditional Formatting. Have the cells show up in three different background colors for cell values 1-4, 5-7, and 8-9.

 

Then move your cursor over to the background color icon at the top of the screen (the paintcan) and select a 4th color, different from the other 3. Voila!

 

-------- WTF? Over!

 

The formula in all the big block of cells calculates an integer from 0 to 9. The static background color will affect all cells with value 0. The conditional formatting will give different colors for cells with values in one of the three ranges. As far as I know, four colors is the most you can have in an Excel art pattern like this.

Posted

Oh, Turtle, Turtle, Turtle...! :xx:

 

I wish you had Excel on your computer. I have discovered something so psycodellically beautiful and frabjoice beyond dreamerings, that I know it would blow your mind. ALAS!! You don't have Excel.

 

Remember the Excel Art (or "bit quilt" as I call them now) up above? ExcelArt_2? That was just static. I've animated it.

 

Step (1) instead of just linear number series in top row and left column, now I put (starting in B1 going down):

=A1+$A$50

=B1+$A$50

=C1+$A$50

=D1+$A$50

...

=Y1-$A$50

=Z1-$A$50

=AA1-$A$50

=AB1-$A$50

=AC1-$A$50

...

 

With similar, symmetric increment & decrement series in first row.

 

The value in $A$50 is a constant. If we put in 1, you get ExcelArt_2.

If we put in 1.5, you get ExcelArt_3.

 

I created a macro. In $B$50, I put a teensy value, 0.001.

When you hit the keyboard shortcut for the macro, it takes the value in $B$50 and <<<ADDS>>> it to the constant in $A$50.

 

The bitquilt changes slightly.

 

Now HOLD DOWN THE MACRO KEYBOARD SHORTCUT KEYS!!!!!

 

The bitquilt continuously changes.

 

;) :eek: :) :eek: :eek_big: :eek: :eek_big: :eek: :eek_big:

:eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek:

:eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big:

:eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek:

:eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big:

:eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek: :eek_big: :eek:

 

You gotta see this!!! :doh:

Posted

Neato!

I've been working in excel all day (except when I've been posting and reading here ;) )with a boring spreadsheet, so this was a good distraction. :)

 

I read your explanation, but it didn't sink in all the way. I'll need to study it for a while I imagine.

 

What does the sqare root equation thingy do exactly? :xx:

Posted
Neato!...What does the sqare root equation thingy do exactly? :headache:

Thank you! Thank you! :phones:

 

The equation in each cell is

 

Z = Int{ 10 * [ R - Int® ] }

 

where

 

R = SqRt ( X^2 + Y^2 )

 

X is the far left value in that row,

Y is the far uppest value in that column.

 

R is therefore the "distance" measured from the cell to the uppest-left cell of the quilt.

 

Basically, I take the distance R, lop off the integer portion, multiply by 10 and lop off the fraction portion.

 

This yields, essentially, the first fractional digit in the distance R. For example, if X = 7 and Y = 8, then R = 10.63

 

Z = the first fractional digit, or 6.

  • 2 weeks later...
Posted
Yes I see him,

 

prety clever putting a for sell sign on that van. :)

 

He's got a for sale sign on it! Crap! I knew I couldn't trust him. :phones: Fine. Want to know why we call him Petey? One time he drove some guys to a shakedown and he got out cuz he had to pee. He's doing his bizness while the guys were doing theirs when all of a sudden he lets out a scream. The guys stopped whailin' and asked him what the hell? He said, "I caught my petey in the zipper". The first guy to bust out laughin' was the chump they were thumpin' and then the other two fellas just busted a gut too. They let the chump off with what ever he'd already got, and started calling Mac "Petey" from then on. True story. What would be funny now is if you go out when he's asleep and paint Petey on the windshield and shove a spud in the tailpipe. :evil:

Posted
... What would be funny now is if you go out when he's asleep and paint Petey on the windshield and shove a spud in the tailpipe. :phones:

 

Never mind; I reported the van stolen. :evil:

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...