Fun Stuff...Off Topic(O/T)

[jiesen]

I hope this list doesn't get leaked to our HR department, or it's likely to become company policy!

[Peter Hansen]

New Gps

For those who have found themselves lost in a ....... ahem troubling neighborhood! Click on the camera ICON to view !

http://www.sealec.com/ted/Videos/DiscrimiNavSystem

[IIC]

FYI...I was showing someone in my office this Excel tip:

If you use formulas which result in say 5 digits after the decimal point in each col. but you have it formatted to only display 2 digits after the decimal you can run into a problem when you total the column because even though you are only displaying 2 digits the formula will use all the digits in the calculation.

Example:

10.02402
10.02312

These would display as

10.02
10.02

The total you want to show is 20.04. But if you just run an addition formula your answer would be 20.04714 which would round to 20.05.

To remedy this you can do the following (There are other ways but I think this is the simplest):

You can frequently prevent floating point rounding errors from affecting your work by using the Precision as displayed option. This option forces the value of each number in the worksheet to be the precision that is displayed on the worksheet.

Note Use of the Precision as Displayed option can have cumulative calculation effects that can make your data increasingly inaccurate over time. Use this option only if you are certain that the displayed percision will maintain the accuracy of your data.

To use the Precision as displayed option, follow these steps: 1.On the Tools menu, click Options.2.On the Calculation tab, under Workbook options, click to select the Precision as displayed check box.3.Click OK.If you use the Precision as displayed option, you must format your numbers by using a specific number format.

To format cells to a specific number precision, follow these steps: 1.Select the cells that you want to format.2.On the Format menu, click Cells.3.On the Number tab, under Category, click Number.4.In the Decimal places box, select the precision (number of decimal places) that you want.5.Click OK.

[mimo_100]

FYI...I was showing someone in my office this Excel tip:

If you use formulas which result in say 5 digits after the decimal point in each col. but you have it formatted to only display 2 digits after the decimal you can run into a problem when you total the column because even though you are only displaying 2 digits the formula will use all the digits in the calculation.

Example:

10.02402
10.02312

These would display as

10.02
10.02

The total you want to show is 20.04. But if you just run an addition formula your answer would be 20.04714 which would round to 20.05.

To remedy this you can do the following (There are other ways but I think this is the simplest):

You can frequently prevent floating point rounding errors from affecting your work by using the Precision as displayed option. This option forces the value of each number in the worksheet to be the precision that is displayed on the worksheet.

Note Use of the Precision as Displayed option can have cumulative calculation effects that can make your data increasingly inaccurate over time. Use this option only if you are certain that the displayed percision will maintain the accuracy of your data.

To use the Precision as displayed option, follow these steps: 1.On the Tools menu, click Options.2.On the Calculation tab, under Workbook options, click to select the Precision as displayed check box.3.Click OK.If you use the Precision as displayed option, you must format your numbers by using a specific number format.

To format cells to a specific number precision, follow these steps: 1.Select the cells that you want to format.2.On the Format menu, click Cells.3.On the Number tab, under Category, click Number.4.In the Decimal places box, select the precision (number of decimal places) that you want.5.Click OK.

Thanks, Doug.

You can also use the Round function if you know the precision you want.

For example:

23.05678*234.345 = 5403.241109

And, ROUND(23.05678*234.345,4) = 5403.2411

[Peter Hansen]

Ah yes .......Marriage

The world's shortest fairy tale.

Once upon a time a guy asked a girl "Will you marry me?

The girl said "" NO !! ""

And the guy lived happily ever after and went fishing,hunting and played golf a lot and drank beer and farted whenever he wanted.

[Karel]

The world's shortest fairy tale.

Once upon a time a guy asked a girl "Will you marry me?

The girl said "" NO !! ""

And the guy lived happily ever after and went fishing,hunting and played golf a lot and drank beer and farted whenever he wanted.

While we are on the subject of marriage, here is a link to a sheet of paper with some musings of a young man in his late twenties on the subject. (And this is the transcription.) Not to keep you in suspense: the result was in favor of marriage. A couple of months later he married his cousin, Emma Wedgwood, from the Wedgwood pottery dynasty.

I found the link on talk.origins, which is one of my worst time wasters on the web, not counting this site, of course.

Regards,

Karel

[IIC]

How popular were you in High School???

http://www.sailinganarchy.com/general/2002/cool_test.htm

...

[RL]

Good one Doug

[Peter Hansen]

Doug Nice

Doug I guess I hung with the eggheads in HS , and the JOCKS were the most popular and got all the girls.......went to a HS Reunion recently .all the jocks were fat , bald, and out of shape .....looked like 50 miles of bad road .......thanx to working out , watching my diet .....I was better than all .....Remember the turtle always wins the race LOL

[Peter Hansen]

I want to be fireman in 2nd life

Here's the kind of work you could be doing if you had chosen to be a fireman. From the Sioux City area all joined in a team effort to rescue a young girl stuck in steel fence. It took several hours to extract her from her predicament.

Fire Chief Stiffie said, "This was a pretty tough rescue, it took us quite a while to come up with a plan to safely extract her from the fence." Although the girl's entrapment was never life threatening it did take careful planning and gentle handling to safely remove her.

She was taken to an area hospital where she was examined and released.

http://message.snopes.com/showthread.php?t=11118

Yes I did pray for that girl's rescue .thanx to all firemen involved !

[IIC]

Doug I guess I hung with the eggheads in HS , and the JOCKS were the most popular and got all the girls.......went to a HS Reunion recently .all the jocks were fat , bald, and out of shape .....looked like 50 miles of bad road .......thanx to working out , watching my diet .....I was better than all .....Remember the turtle always wins the race LOL

My Dad sent me that one.

I was a jock in HS and college...And to be honest I had a lot of cute girlfriends...But in my old age I came to realize that Cute doesn't really matter...Big boobs matter though...That's why my wife is so great...Well, not really...although my wife does have 'em...But she is really the best person I've ever known...No one else would ever put up with me the way she does...Sometimes I think she is TOO GOOD!!!

[Peter Hansen]

Iic

My Dad sent me that one.

I was a jock in HS and college...And to be honest I had a lot of cute girlfriends...But in my old age I came to realize that Cute doesn't really matter...Big boobs matter though...That's why my wife is so great...Well, not really...although my wife does have 'em...But she is really the best person I've ever known...No one else would ever put up with me the way she does...Sometimes I think she is TOO GOOD!!!

IIC I went with a GF before I married who was a 40F ....but she did not have a brain in her head ......fortunately for me I did not want dumb kids and never chose her as my wife. The woman I chose is highly intelligent , pretty and one who has been with me through the years...a really great woman !

[billyjoe]

The lunar eclipse is about 45 minutes along now @9:30 est and will last about 2 hours and 15 minutes longer. The sky is perfectly clear here. There's about a 1/4 slice of the moon showing .

------------billyjoe

-----------------

[skiracer]

The lunar eclipse is about 45 minutes along now @9:30 est and will last about 2 hours and 15 minutes longer. The sky is perfectly clear here. There's about a 1/4 slice of the moon showing .

------------billyjoe

-----------------

ditto from toms river, nj. pretty neat.

[IIC]

2008 Merger Rumors

Rumors of major business consolidations in 2008.

1.) Hale Business Systems, Mary Kay Cosmetics, Fuller Brush, and W. R. Grace Co. Will merge and become:
Hale, Mary, Fuller, Grace.

2.) PolyGram Records, Warner Bros., and Zesta Crackers join forces and become:
Poly, Warner Cracker.

3.) 3M will merge with Goodyear and become:
MMMGood.

4. Zippo Manufacturing, Audi Motors, Dofasco, and Dakota Mining will merge and become:
ZipAudiDoDa .

5. FedEx is expected to join its competitor, UPS, and become:
FedUP.

6. Fairchild Electronics and Honeywell Computers will become:
Fairwell Honeychild.

7. Grey Poupon and Docker Pants are expected to become:
PouponPants.

8. Knotts Berry Farm and the National Organization of Women will become:
Knott NOW!

And finally.....

9. Victoria 's Secret and Smith &Wesson will merge under the new name:
TittyTittyBang Bang