Quantcast
Mathematical complication in Excel.
A comedy conversation by Dangeo 2,691 13
01/12/2005 08:59 AM 243 views

Hey all, long time.



Since I've been gone, I've:



* lost my job in computers.

* lost my car.

* lost my house.

* filed/completed bankruptcy.

* taken a mediocre blue-collar job.



My latest endeavor into the world of employment is with a chemical transfer company. Basically, I transfer chemicals from railcars to tank trucks. (Everybody should do this once in their lives, it's a real treat)



Anyhow, some of the chemicals we load need to be blended with other chemicals or cut with water to dilute their potency.



I've been working on a spreadsheet that will help with some of these dilutions and blends. But one of them is giving me grief. (I've sniffed too many chemicals)



I need an Excel formula to cut 85% acid with water to make it 75% acid.



The calculation should give pounds based on pounds being input.



Acid 14.2 pounds per gallon.

Water 8.337 pounds per gallon.

Like This? Rate It!
Hilarious 5 votes 4.5 /live?func=new_user&msgid=1112362
Like It!
Share on your site: 0 shares
 
Digg It!
Stumble It!


34 Comments on "

Mathematical complication in Excel.

"

(Funniest: Frogpop,Dangeo,Dead Robot)


Side-splitting 17 votes 5.0 /live?func=new_user&msgid=1112363
Dead Robot 67,630 16
01/12/2005 09:04 AM

Who are you?



Whats with this trend in old timers coming back and expecting answers for serious questions?



Here's my answer: Up up up right right right, square square circle up. Now you're in godmode.



Hey D, Werehamster lost stuff too and didnt get a clear reply.

 

  0 votes 0.0 /live?func=new_user&msgid=1112364
Chris Garrett 86,932 12
01/12/2005 09:06 AM

I'm going to play the lottery today.



I was looking at the photo album this morning, and saw your picture, and wondered who you were, and if you were ever going to post again.



gimme 3 numbers..for the pick 3



and 4 numbers..for the pick 4



and six numbers and the powerball, ok?



I'll split if I win..promise.







 

Hilarious 5 votes 4.5 /live?func=new_user&msgid=1112365
Phuc 237,919 21
01/12/2005 09:20 AM

Sorry I can't help you, Dangeo. The math skills of my Asian half have been negated by the stupidity of my caucasian half.

 

  0 votes 0.0 /live?func=new_user&msgid=1112367
The Chocolaty Snork 45,655 12
01/12/2005 09:28 AM

You should leave this place while you can. A job transfering chemicals is still a job.

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1112368
larkknot 3,359 10
01/12/2005 09:28 AM

http://www.purplemath.com/modules/mixture.htm

Scroll down to the second example for the algebraic process you need to put into EXCEL.

 

Side-splitting 35 votes 5.0 /live?func=new_user&msgid=1112371
Frogpop 173,153 25
01/12/2005 09:30 AM

Let's see now.. tricky math question.. hazardous chemicals.. lives at stake.. QUICKLY! TO GAB!!

 

  0 votes 0.0 /live?func=new_user&msgid=1112379
20 Chickens 286,527 61
01/12/2005 09:43 AM

=((trae+your webcam)*eternity)

 

Hilarious 2 votes 4.0 /live?func=new_user&msgid=1112384
Just Chit till Presidents Day 178,776 15
01/12/2005 09:50 AM

Chris Garrett meant to say, "I saw your picture in the photo album and thought to myself, Frost these aren't tit pictures. Damnit, if I ever get a chance I'm getting my twenty seconds back from that guy somehow."



(unless he has somehow acquired tits now)

 

  0 votes 0.0 /live?func=new_user&msgid=1112385
Rаt 2,085 9
01/12/2005 09:51 AM

Is that 14.2 pounds pure acid, or 85% acid.







ps: who are you, and how did you get a personalised icon?

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1112386
20 Chickens 286,527 61
01/12/2005 09:53 AM

that's dangeo, an old school gabber. He got that icon by dancing "ode to Gab" in the moscow ballet. Best publicity stunt ever.

 

Hilarious 7 votes 4.6 /live?func=new_user&msgid=1112391
SpecialKake 55,555 14
01/12/2005 10:11 AM

eh, just eye it. What could possibly go wrong?

 

  0 votes 0.0 /live?func=new_user&msgid=1112444
Dangeo 2,691 13
01/12/2005 11:49 AM

I read that purple math problem and my brain melted and oozed out my ear.



14.2 pounds is 85% acid.



My ballerina rocks!



I am lesbian.



Trae still has my webcam. (bitch!)

 

Side-splitting 11 votes 5.0 /live?func=new_user&msgid=1112448
Dangeo 2,691 13
01/12/2005 11:56 AM

Dangeo doing "Ode to GAB"

 

  1 votes 0.0 /live?func=new_user&msgid=1112539
Gabe 9,232 13
01/12/2005 01:41 PM

I can't vouch for the validity of this answer, but here goes.



Acid 14.2 pounds per gallon.

Water 8.337 pounds per gallon



You need 75% acid, one gallon of which has 0.75 gallons acid (10.65 lbs) and 0.25 gallons water (2.08 lbs). One gallon of your existing 85% acid contains 0.85 gallons (12.07 lbs) acid.



We need to end up with the same ratio as the 75% acid, so:



12.07/x = 10.65/2.08

x = 2.36 lbs water.



1 gallon of 85% acid already has 0.15 gallons (1.25 lbs) of water, but to make it 75% acid, we need 2.36 lbs of water.



2.36 - 1.25 = 1.11



So for every gallon of 85% acid you have, add 1.11 lbs of water.



 

  0 votes 0.0 /live?func=new_user&msgid=1112555
DemoMonkey. Period. 166,252 10
01/12/2005 02:01 PM

Dangeo



Excel spreedsheet has been sent to the e-mail in your profile.



Glad to help



Demo

 

  0 votes 0.0 /live?func=new_user&msgid=1112556
DemoMonkey. Period. 166,252 10
01/12/2005 02:04 PM

Gabes math is sound (and put more succintly than I could), but I still think you'll find the spreadsheet helpful. It allows you to choose your desired concentration of starting or ending solution, and work by either weight or volume.



See? Who says Gabbers are unhelpful.

 

  0 votes 0.0 /live?func=new_user&msgid=1112558
Trae 156,790 17
01/12/2005 02:05 PM

=((trae+your webcam)*eternity)



Chickens, you are such an instigator!! Dan, you need the cam, send me your address again I lost it. I suck at sending things back to people. Ask Aimless, I've had her necklace for a year.



Sorry to hear about the bad luck, but kickass on the chemical thing! If all else fails you can be a terrorist.

 

Side-splitting 28 votes 5.0 /live?func=new_user&msgid=1112656
Gabosaurus Rex 9,232 13
01/12/2005 04:17 PM

Where this is all leading



>*< worksafe

 

  0 votes 0.0 /live?func=new_user&msgid=1112837
Gabe 9,232 13
01/12/2005 07:24 PM

Email that spreadsheet to me, too. I'm enough of a geek that formulas excite me.

 

  0 votes 0.0 /live?func=new_user&msgid=1112841
Dweezil Meniketti 77,546 17
01/12/2005 07:30 PM

"It was the most horrifying thing I've ever seen," said Ethel Wallenbach, a playground monitor.



Ethel Wallenbach...

 

Hilarious 3 votes 4.0 /live?func=new_user&msgid=1112981
Dogs Akimbo 211,569 32
01/12/2005 11:57 PM

The acid also spilled over into the nearby horse farm...

 

Hilarious 5 votes 4.5 /live?func=new_user&msgid=1112985
AKADave 3,588 9
01/13/2005 12:02 AM

14.2 pounds of acid? Have a nice trip....

 

  0 votes 0.0 /live?func=new_user&msgid=1113041
Dangeo 2,691 13
01/13/2005 01:24 AM

Gabe, please leave that news article up for me.



The guys at work will get a kick out of it.



Funny stuff. Except for the part about all them kids.

 

  0 votes 0.0 /live?func=new_user&msgid=1113052
Dangeo 2,691 13
01/13/2005 01:42 AM

Gabe, Demo,



I think between the two of you I can make the result I'm looking for.



Basically, using your logic, I can whip something together.



The final result would be:



X gallons of water

X gallons of acid (85%)

based on desired weight of 75% acid.



IE: Input "45,000" lbs would net somewhere around 650 gallons of water and 2800 gallions of acid.

 

  0 votes 0.0 /live?func=new_user&msgid=1113057
Rаt 2,085 9
01/13/2005 01:57 AM

Except for the part about all them kids.



No, that's what makes it funny.



You've been gone for a looong time.

 

Hilarious 3 votes 4.0 /live?func=new_user&msgid=1113090
Boots at the Boar 2,305 11
01/13/2005 02:45 AM

Just remember to add acid to water and not vice versa. I never took that warning seriously until I got into an advanced course and they started using 20 mol/L Shakespeare that will melt away tile flooring, wood, rubber, polyester/cotton shirts, and your nipples. I know this from experience.

 

  0 votes 0.0 /live?func=new_user&msgid=1113094
Boots at the Boar 2,305 11
01/13/2005 02:48 AM

Since I've been gone, I've:



* lost my job in computers.

* lost my car.

* lost my house.

* filed/completed bankruptcy.

* taken a mediocre blue-collar job.




Did you keep your wife? I can't remember if you were even married; it's been so long. My mind thinks you engaged way back when.

 

Hilarious 4 votes 4.3 /live?func=new_user&msgid=1113118
Hammerhead 59,399 14
01/13/2005 03:23 AM

If he'd lost his wife and his dog, it'd be the perfect country song.

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1113132
Daisypie 49,378 9
01/13/2005 03:49 AM

* taken a mediocre blue-collar job.



Dan, you're a working man now. Leave that pencil-pushin' Shakespeare to the pansy-assed white-collar wimps!



...I can not believe that trombone act didn't take off!

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1113137
Frogpop 173,153 25
01/13/2005 04:06 AM

The perfect country song would be hot Shania on Sarah lesbian action.

 

  0 votes 0.0 /live?func=new_user&msgid=1113140
Gabosaurus Rex 9,232 13
01/13/2005 04:12 AM

Remember, you can't put too much water in the reactor.

 

  0 votes 0.0 /live?func=new_user&msgid=1113350
DemoMonkey. Period. 166,252 10
01/13/2005 12:46 PM

Dangeo/Gabe



New spreedsheet sent, check your e-mails.

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1113364
turtle10 42,578 26
01/13/2005 01:18 PM

Don't forget to carry the 4.



That is where I always mess up on equations

 

Chuckleworthy 1 votes 2.0 /live?func=new_user&msgid=1113496
EllaL 800 8
01/13/2005 03:03 PM

i totally bought that news story for a while. "but wait, i didnt see it on the news...then again, i havent turned on the news yet this morning" i think it was the melting kids that got me.