1. ## 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.

2. 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.

3. I got certified as a Microsoft Excel Specialist in college... But you lost me there..

4. 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 ...

5. 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.

6. 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 7. 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.

8. 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?

9. 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...

10. 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. 11. Drakkie, in the equation: S = r(1-cosA + Labda/2*sin2A)

What is the 'Labda' supposed to mean? (Bolded) Lambda??

12. 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. 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.
Last edited by Rockefella; 11-12-2006 at 01:21 PM.

13. 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.

14. try putting empty brackets after the PI

so PI()

and more brackets like cos(xxx)

15. 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 