-
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.
-
[QUOTE=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.[/QUOTE]
Does it have to be done in Excel?
If not, I recommend just plugging the equation into MatLab and then plotting it.
-
I got certified as a Microsoft Excel Specialist in college... But you lost me there..
-
[quote=Rockefella]Does it have to be done in Excel?
If not, I recommend just plugging the equation into MatLab and then plotting it.[/quote]
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 ...
-
[QUOTE=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 ...[/QUOTE]
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.
-
[quote=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.[/quote]
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 :rolleyes:
-
[QUOTE=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 :rolleyes:[/QUOTE]
I'll give it a go.
-
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?
-
[QUOTE=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?[/QUOTE]
there is this eternal problem when we use a non anglo saxon version, we have to change the decimal commas to the decimal points...
-
[QUOTE=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...[/QUOTE]
It's just a lesson to be learned. Eventually everyone will notice America is superior. :D
-
Drakkie, in the equation: S = r(1-cosA +[B] Labda[/B]/2*sin2A)
What is the 'Labda' supposed to mean? (Bolded) Lambda??
-
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=MatLab]
>> r = 0.0425;
>> x = r*(1-(cos(A)*(pi/180))+0.75*(sin(2*A)*(pi/180))[/quote]
Does that equation look right to you? I'm a bit confused with what you put up in the first post.
-
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.
-
try putting empty brackets after the PI
so PI()
and more brackets like cos(xxx)
-
[quote=Rockefella]Drakkie, in the equation: S = r(1-cosA +[B] Labda[/B]/2*sin2A)
What is the 'Labda' supposed to mean? (Bolded) Lambda??[/quote]
yea typing mistake:) Lambda,the greek letter. In this case it is a ratio in the engine :)