Excel help needed

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

[Rockefella]

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.

[drakkie]

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

[Rockefella]

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.

[drakkie]

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

[Rockefella]

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.

[Niko_Fx]

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

[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?

[henk4]

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

[Rockefella]

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.

[pimento]

there is this eternal problem when we use a non anglo saxon version, we have to change the decimal commas to the decimal points...

You should be able to set up windows/excel to parse them properly easily enough. It's just in the options somewhere.

Decimal points ftw btw. Just fyi.

[henk4]

You should be able to set up windows/excel to parse them properly easily enough. It's just in the options somewhere.

Decimal points ftw btw. Just fyi.

ftw??

[Rockefella]

ftw??

ftw = for the win.

[Rockefella]

Drakkie, in the equation: S = r(1-cosA + Labda/2*sin2A)

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

[drakkie]

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