Go to Ultimatecarpage.com

Go Back   Ultimatecarpage.com forums > General forums > Miscellaneous


Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2006, 11:54 AM
drakkie's Avatar
drakkie drakkie is offline
Fanatic
 
Join Date: Mar 2004
Posts: 7,827
Eindhoven, The Netherlands
Excel help needed

I need to create a graph of the following function:
S = r(1-cosA + Labda/2*sin2A)

I tried entering it in Excel and it gives a very nice error. The formula i filled in was:
(B1) =0,0425(1-(cosA1*(PI/180))+ 0,75*(sin2A1*(PI/180))

I get an empty cell saying #Name. how can i solve this ? I need to have this done beofre tomorrow 10 am. I would be more than just thankful for any help on this

S.
Reply With Quote
  #2  
Old 11-12-2006, 11:59 AM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Quote:
Originally Posted by drakkie
I need to create a graph of the following function:
S = r(1-cosA + Labda/2*sin2A)

I tried entering it in Excel and it gives a very nice error. The formula i filled in was:
(B1) =0,0425(1-(cosA1*(PI/180))+ 0,75*(sin2A1*(PI/180))

I get an empty cell saying #Name. how can i solve this ? I need to have this done beofre tomorrow 10 am. I would be more than just thankful for any help on this

S.
Does it have to be done in Excel?

If not, I recommend just plugging the equation into MatLab and then plotting it.
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #3  
Old 11-12-2006, 12:08 PM
Niko_Fx's Avatar
Niko_Fx Niko_Fx is offline
Super Moderator
 
Join Date: Feb 2004
Posts: 5,802
Deerfield Beach, Florida
Send a message via MSN to Niko_Fx
I got certified as a Microsoft Excel Specialist in college... But you lost me there..
Reply With Quote
  #4  
Old 11-12-2006, 12:51 PM
drakkie's Avatar
drakkie drakkie is offline
Fanatic
 
Join Date: Mar 2004
Posts: 7,827
Eindhoven, The Netherlands
Quote:
Originally Posted by Rockefella
Does it have to be done in Excel?

If not, I recommend just plugging the equation into MatLab and then plotting it.
I dont own MAtlab unfortunately AND it has to be done in Excel Drawing it would be easiest but it has to be digital stupid stuff,aint it ...
Reply With Quote
  #5  
Old 11-12-2006, 12:54 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Quote:
Originally Posted by drakkie
I dont own MAtlab unfortunately AND it has to be done in Excel Drawing it would be easiest but it has to be digital stupid stuff,aint it ...
Oh, I have MatLab.

Sucks though that it has to be done in Excel. Check out the Excel Help section.. The help section has assisted me a lot when I'm stuck in MatLab.
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #6  
Old 11-12-2006, 12:59 PM
drakkie's Avatar
drakkie drakkie is offline
Fanatic
 
Join Date: Mar 2004
Posts: 7,827
Eindhoven, The Netherlands
Quote:
Originally Posted by Rockefella
Oh, I have MatLab.

Sucks though that it has to be done in Excel. Check out the Excel Help section.. The help section has assisted me a lot when I'm stuck in MatLab.
i got a mail back from the teacher Matlab is fine too Maybe you can plot and post it here so i can copy it into my work ?

it goes from 0-720 degrees
Reply With Quote
  #7  
Old 11-12-2006, 12:59 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Quote:
Originally Posted by drakkie
i got a mail back from the teacher Matlab is fine too Maybe you can plot and post it here so i can copy it into my work ?

it goes from 0-720 degrees
I'll give it a go.
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #8  
Old 11-12-2006, 01:04 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Hold on, I think I found your problem.

In your equation: (B1) =0,0425(1-(cosA1*(PI/180))+ 0,75*(sin2A1*(PI/180))

I think you should change all of the commas (,) to decimals (.) Perhaps Excel doesn't recognize the commas you used as a decimal point?
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #9  
Old 11-12-2006, 01:05 PM
henk4's Avatar
henk4 henk4 is offline
Supporting Member
 
Join Date: Apr 2003
Posts: 27,312
Rozenburg, Holland
Quote:
Originally Posted by Rockefella
Hold on, I think I found your problem.

In your equation: (B1) =0,0425(1-(cosA1*(PI/180))+ 0,75*(sin2A1*(PI/180))

I think you should change all of the commas (,) to decimals (.) Perhaps Excel doesn't recognize the commas you used as a decimal point?
there is this eternal problem when we use a non anglo saxon version, we have to change the decimal commas to the decimal points...
__________________
"I find the whole business of religion profoundly interesting, but it does mystify me that otherwise intelligent people take it seriously." Douglas Adams
Reply With Quote
  #10  
Old 11-12-2006, 01:06 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Quote:
Originally Posted by henk4
there is this eternal problem when we use a non anglo saxon version, we have to change the decimal commas to the decimal points...
It's just a lesson to be learned. Eventually everyone will notice America is superior.
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #11  
Old 11-12-2006, 01:08 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Drakkie, in the equation: S = r(1-cosA + Labda/2*sin2A)

What is the 'Labda' supposed to mean? (Bolded) Lambda??
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want
Reply With Quote
  #12  
Old 11-12-2006, 01:15 PM
Rockefella's Avatar
Rockefella Rockefella is offline
Super Moderator
 
Join Date: May 2004
Posts: 16,605
Northern New Jersey
Send a message via AIM to Rockefella Send a message via MSN to Rockefella
Ugh, me again.

Drakkie, I put this into MatLab, but, are there any values for A and A1 that you listed in your original equation? MatLab gives me an error message because I have too many variables.

Quote:
Originally Posted by MatLab

>> r = 0.0425;
>> x = r*(1-(cos(A)*(pi/180))+0.75*(sin(2*A)*(pi/180))
Does that equation look right to you? I'm a bit confused with what you put up in the first post.
__________________
Rockefella says:
pat's sister is hawt
David Fiset says:
so is mine
David Fiset says:
do want

Last edited by Rockefella; 11-12-2006 at 01:21 PM.
Reply With Quote
  #13  
Old 11-12-2006, 01:21 PM
drakkie's Avatar
drakkie drakkie is offline
Fanatic
 
Join Date: Mar 2004
Posts: 7,827
Eindhoven, The Netherlands
A is a value of 0 to 720 degrees and B is the same as A.

Because excel works with radials i used the Pi/180 thingy.
Reply With Quote
  #14  
Old 11-12-2006, 01:34 PM
derekthetree's Avatar
derekthetree derekthetree is offline
Enthusiast
 
Join Date: Nov 2004
Posts: 2,734
UK
try putting empty brackets after the PI

so PI()

and more brackets like cos(xxx)
__________________
How can men use sex to get what they want?
Sex is what they want. - Frasier
Reply With Quote
  #15  
Old 11-12-2006, 02:02 PM
drakkie's Avatar
drakkie drakkie is offline
Fanatic
 
Join Date: Mar 2004
Posts: 7,827
Eindhoven, The Netherlands
Quote:
Originally Posted by Rockefella
Drakkie, in the equation: S = r(1-cosA + Labda/2*sin2A)

What is the 'Labda' supposed to mean? (Bolded) Lambda??
yea typing mistake Lambda,the greek letter. In this case it is a ratio in the engine
Reply With Quote
Reply


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

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bob marley-duppy conqueror needed white devil Multimedia 1 09-23-2006 06:02 PM
"peter the pilot" - help needed whiteballz Miscellaneous 0 11-12-2005 02:16 AM
Expert tuning advise needed ! mduhair Miscellaneous 24 02-20-2005 12:38 AM
help - life changing decision needed Matra et Alpine Miscellaneous 70 10-27-2004 11:43 PM
Car Advice and opinions needed! ImportFan General Automotive 9 10-07-2004 10:11 AM



All times are GMT -7. The time now is 09:01 AM.

 

1998 - 2019 Ultimatecarpage.com