Go Back   Literotica Discussion Board > Main Literotica Forums > How To...

Reply
 
Thread Tools

Old 02-12-2013, 11:06 AM   #1
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Math and Excel Question (nerd content)

I know there are some fellow nerds here as I have seen you in the Math thread. I have a question that I am not easily finding the answer to.

It is possible to plot non-linear equations in Excel? Like, on a graph? It's logarithmic in nature, not just mx+b. I suppose I can do a scatter chart.

I can post the equation in a bit but it's long and cumbersome.

I thought I'd ask here because I know there are some math brains in our midst. No one here at work can figure it and I'm not an Excel wizard with graphs.

Thanks in advance and I'll post the equation shortly. I realize this is a long shot.
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 11:08 AM   #2
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Oh, and can it plot the actual equation?
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 11:48 AM   #3
DrHappy
Literotica Guru
 
DrHappy's Avatar
 
DrHappy is offline
Join Date: Dec 2006
Location: Southwest U.S.
Posts: 501
I'm only aware of adding a trend line for existing data points. You right click on one of the data points one the chart, and select the Trend/Regression type. I suppose you could define a trend line, and then change the data points to something that would be invisible.

Last edited by DrHappy : 02-12-2013 at 11:58 AM.
  Reply With Quote

Old 02-12-2013, 01:37 PM   #4
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
My calculator doesn't even like the equation. It has a hard time plotting it and it is a pretty powerful calculator. Excel, from what I see so far is only able to plot data points. It looks like I'm going to have to pick sample points and plot them. It seems like Excel should be able to plot a two variable system. I don't understand why it can't. I really don't. I can see it having trouble with my particular problem, as it's logarithmic.

Here is the equation:



The unknowns are t and Ibf (that is one variable). I have the letter E in there, but I define that as it changes for my different scenarios. And the log is actually log base 10, not ln (natural log). It's a bitch figuring out how to represent that in Excel.

Thanks for the idea Dr. I'll see what I can get.

And sorry about such an off the wall question. But a lot of people come to this site, so I figure we may have some expertise.
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 01:42 PM   #5
Primalex
亀の甲より年の功
 
Primalex's Avatar
 
Primalex is online now
Join Date: Jul 2007
Posts: 4,869
Excel is a spreadsheet software.

Trying to do this with Excel is like trying to write a letter with MS Paint. Why would you want this?

Use MatLab for this.
__________________
“Getting an education was a bit like a communicable sexual disease. It made you unsuitable for a lot of jobs and then you had the urge to pass it on.”
― Terry Pratchett, Hogfather
  Reply With Quote

Old 02-12-2013, 01:50 PM   #6
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Quote:
Originally Posted by Primalex View Post
Excel is a spreadsheet software.

Trying to do this with Excel is like trying to write a letter with MS Paint. Why would you want this?

Use MatLab for this.
I understand. But I do not have Matlab or Mathcad at my fingertips. My old laptop has both, but that thing ate shit long ago.

All I want is a simple plot of the equations. I thought maybe Excel would do this.

But you recommend Paint, huh? As you see, I'm a master of paint.
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 01:53 PM   #7
Primalex
亀の甲より年の功
 
Primalex's Avatar
 
Primalex is online now
Join Date: Jul 2007
Posts: 4,869
Quote:
Originally Posted by pmann View Post
I understand. But I do not have Matlab or Mathcad at my fingertips.
Then use Mathematica.

http://www.wolframalpha.com

uses this as engine for equations (no surprise, it's from the same person).

http://www.wolframalpha.com/examples/Math.html
__________________
“Getting an education was a bit like a communicable sexual disease. It made you unsuitable for a lot of jobs and then you had the urge to pass it on.”
― Terry Pratchett, Hogfather
  Reply With Quote

Old 02-12-2013, 02:21 PM   #8
IrisAlthea
Literotica Guru
 
IrisAlthea's Avatar
 
IrisAlthea is offline
Join Date: Feb 2008
Posts: 2,816
Quote:
Originally Posted by Primalex View Post
Then use Mathematica.

http://www.wolframalpha.com

uses this as engine for equations (no surprise, it's from the same person).

http://www.wolframalpha.com/examples/Math.html
And it works on the iPad.
Thank you so much for the link!
  Reply With Quote

Old 02-12-2013, 02:48 PM   #9
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Quote:
Originally Posted by Primalex View Post
Then use Mathematica.

http://www.wolframalpha.com

uses this as engine for equations (no surprise, it's from the same person).

http://www.wolframalpha.com/examples/Math.html
Thank you for this!!! It looks amazing!!!
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 03:15 PM   #10
Bramblethorn
Mallory Heart Surgeon.
 
Bramblethorn's Avatar
 
Bramblethorn is offline
Join Date: Feb 2012
Posts: 6,185
Quote:
Originally Posted by pmann View Post
My calculator doesn't even like the equation. It has a hard time plotting it and it is a pretty powerful calculator. Excel, from what I see so far is only able to plot data points. It looks like I'm going to have to pick sample points and plot them. It seems like Excel should be able to plot a two variable system. I don't understand why it can't. I really don't. I can see it having trouble with my particular problem, as it's logarithmic.

Here is the equation:



The unknowns are t and Ibf (that is one variable). I have the letter E in there, but I define that as it changes for my different scenarios. And the log is actually log base 10, not ln (natural log). It's a bitch figuring out how to represent that in Excel.
If you want to plot a function in base Excel you'll probably need to generate pairs of points, then do an x-y plot and select one of the "connect points with lines" options. However, this addon appears to do what you're after and there's an alternate method here. (Disclaimer: haven't used these myself and can't vouch for them.)

In Excel "Log(x)" will give you the base-ten log of x, "Log(x,y)" will give the base-y log, and "Ln(x)" will give the natural log.

Looking at your equation, you can simplify it further by remembering that log(10^blah) = blah.
  Reply With Quote

Old 02-12-2013, 03:48 PM   #11
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
I was able to get a smooth line plot using the x-y scatter option. I didn't actually plot the equation, but rather a shitload of points in the graph. It's not perfect, but it works well enough. Until I get a chance to look at that other website that Primalex posted. That looks like a powerful tool. (That's what she said)

This Excel sheet will work well enough for upper management types who don't understand this stuff anyway.
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-12-2013, 04:41 PM   #12
Rainshine
Selectively Slutty
 
Rainshine's Avatar
 
Rainshine is offline
Join Date: Jul 2012
Location: Terra Australis
Posts: 16,971
Don't worry about it, the answer is always 7.
__________________
Happiness is back in style...
  Reply With Quote

Old 02-13-2013, 09:22 AM   #13
GiggLeGasm
June Cleaver Wannabe
 
GiggLeGasm's Avatar
 
GiggLeGasm is offline
Join Date: Mar 2011
Location: Clevelandish, Ohio... A great place to live; I wouldn't want to vacation here.
Posts: 18,754
Quote:
Originally Posted by Rainshine View Post
Don't worry about it, the answer is always 7.
lol.. our go-to answer was always 6..
took me back.. made me laugh. thanks
__________________
I don't swallow. I let it run down my chin in a cheap attempt to look kinky.
  Reply With Quote

Old 02-13-2013, 09:27 AM   #14
Rainshine
Selectively Slutty
 
Rainshine's Avatar
 
Rainshine is offline
Join Date: Jul 2012
Location: Terra Australis
Posts: 16,971
Quote:
Originally Posted by GiggLeGasm View Post
lol.. our go-to answer was always 6..
took me back.. made me laugh. thanks
lol Gosh I hated Maths. Especially those questions about trains leaving stations... man...
__________________
Happiness is back in style...
  Reply With Quote

Old 02-13-2013, 10:30 AM   #15
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Quote:
Originally Posted by Rainshine View Post
lol Gosh I hated Maths. Especially those questions about trains leaving stations... man...
I like how you call it Maths *laughs*.

The train questions weren't interesting. Perhaps if we knew why the train was leaving the station.

"A train full of Playboy models leaves to meet the needs of Hugh Jackman and Christian Bale..."

See? Already more interesting.
__________________
*edited for cleanliness*
  Reply With Quote

Old 02-13-2013, 01:32 PM   #16
Rainshine
Selectively Slutty
 
Rainshine's Avatar
 
Rainshine is offline
Join Date: Jul 2012
Location: Terra Australis
Posts: 16,971
I like how you call it interesting. *laughs*

Oh wait, no I don't!
__________________
Happiness is back in style...
  Reply With Quote

Old 02-13-2013, 02:06 PM   #17
Emerson40
An evening spent dancing
 
Emerson40's Avatar
 
Emerson40 is offline
Join Date: Aug 2012
Location: It's not where, but who you're with that matters
Posts: 8,022
Quote:
Originally Posted by pmann View Post
I like how you call it Maths *laughs*.

The train questions weren't interesting. Perhaps if we knew why the train was leaving the station.

"A train full of Playboy models leaves to meet the needs of Hugh Jackman and Christian Bale..."

See? Already more interesting.


<<== Foot tappin' stuff, when waiting for a train or finding square roots. You don't always have to show your work
  Reply With Quote

Old 04-01-2013, 05:19 PM   #18
dougsan
Really Really Experienced
 
dougsan is offline
Join Date: Mar 2013
Location: Boston, MA USA
Posts: 377
Math is always beautiful. It is the language of logic. Not that I'm a math freak, just a lover of math who does math problems to while away the hours.

Excellent job on the previous.

Don't you love Excel? I worked on digicalc too many years ago. For those who wonder, digicalc was the precurser to Lotus 123, which was the precursor to Excel.

It is my believe Microsoft borrowed a lot of the S/W they claimed ownership to over the years. Some they paid well for some they may not have.

Love the old days. Anyone remember punched card programming?
__________________
a leaf falls, loneliness
e.e.cummings
  Reply With Quote

Old 04-01-2013, 06:22 PM   #19
stickygirl
Literotica Guru
 
stickygirl is offline
Join Date: Jan 2012
Posts: 14,151
Psst... got a punch-card porn? I'd love to see some photos - y'know the real vintage B/W stuff. We have a PC in the lab that has orange lettering!!
  Reply With Quote

Old 04-09-2013, 09:38 PM   #20
DvorakAgain
Virgin
 
DvorakAgain is offline
Join Date: Apr 2013
Posts: 1
Quote:
Originally Posted by pmann View Post
My calculator doesn't even like the equation. It has a hard time plotting it and it is a pretty powerful calculator. Excel, from what I see so far is only able to plot data points. It looks like I'm going to have to pick sample points and plot them. It seems like Excel should be able to plot a two variable system. I don't understand why it can't. I really don't. I can see it having trouble with my particular problem, as it's logarithmic.

Here is the equation:



The unknowns are t and Ibf (that is one variable). I have the letter E in there, but I define that as it changes for my different scenarios. And the log is actually log base 10, not ln (natural log). It's a bitch figuring out how to represent that in Excel.

Thanks for the idea Dr. I'll see what I can get.

And sorry about such an off the wall question. But a lot of people come to this site, so I figure we may have some expertise.
Is that the equation for arc flash energy?
  Reply With Quote

Old 04-10-2013, 01:03 PM   #21
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Quote:
Originally Posted by DvorakAgain View Post
Is that the equation for arc flash energy?
Yes. But there was an error in that. I can't remember where, but I think I did the log incorrectly. It's fixed. And I just, instead of plotting the actual equation, plotted a shitload of points.

Is there another nerd among us???
__________________
*edited for cleanliness*
  Reply With Quote

Old 04-10-2013, 01:32 PM   #22
BeachMomma
Sweet n Innocent
 
BeachMomma's Avatar
 
BeachMomma is offline
Join Date: Jun 2012
Location: In your wildest dreams
Posts: 3,982
Quote:
Originally Posted by pmann View Post
My calculator doesn't even like the equation. It has a hard time plotting it and it is a pretty powerful calculator. Excel, from what I see so far is only able to plot data points. It looks like I'm going to have to pick sample points and plot them. It seems like Excel should be able to plot a two variable system. I don't understand why it can't. I really don't. I can see it having trouble with my particular problem, as it's logarithmic.

Here is the equation:



The unknowns are t and Ibf (that is one variable). I have the letter E in there, but I define that as it changes for my different scenarios. And the log is actually log base 10, not ln (natural log). It's a bitch figuring out how to represent that in Excel.

Thanks for the idea Dr. I'll see what I can get.

And sorry about such an off the wall question. But a lot of people come to this site, so I figure we may have some expertise.
*eyes glazed over*

Train questions are easy. It doesn't matter what time they'll collide; there's going to be a lot of dead people and one hell of a mess to clean up.

Oh, I beg to differ, but the answer is always 49.
__________________
My Literotica Submissions

Gentlemen may prefer blondes, but it takes a real man to handle a redhead.


I came to Literotica for the Eros. I stay for the Agape (LakeSailer_MI, 2013).
  Reply With Quote

Old 04-12-2013, 05:50 AM   #23
babyoillover
Literotica Guru
 
babyoillover is offline
Join Date: Apr 2009
Location: Here on Lit far too often!!!
Posts: 605
Surely the answer is always 42!
  Reply With Quote

Old 04-12-2013, 06:21 AM   #24
FHMbabe
Really Really Experienced
 
FHMbabe's Avatar
 
FHMbabe is offline
Join Date: Mar 2013
Location: Treat me like an angel and i'll show you what heaven is really like ;)
Posts: 423
Look at that writing!!! (0_0)
__________________
Saintly Sinner...
  Reply With Quote

Old 04-12-2013, 07:14 AM   #25
Lord Pmann
Literotica Guru
 
Lord Pmann is offline
Join Date: Mar 2012
Posts: 12,996
Quote:
Originally Posted by FHMbabe View Post
Look at that writing!!! (0_0)
I've been told my writing is very heterosexual.
__________________
*edited for cleanliness*
  Reply With Quote
Reply


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -4. The time now is 11:38 AM.

Copyright 1998-2013 Literotica Online. Literotica is a registered trademark.