Page 1 of 3 123 LastLast
Results 1 to 15 of 38

Thread: Excel help needed

  1. #1
    Join Date
    Mar 2004
    Location
    Eindhoven, The Netherlands
    Posts
    7,827

    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. #2
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  3. #3
    Join Date
    Feb 2004
    Location
    Deerfield Beach, Florida
    Posts
    5,802
    I got certified as a Microsoft Excel Specialist in college... But you lost me there..

  4. #4
    Join Date
    Mar 2004
    Location
    Eindhoven, The Netherlands
    Posts
    7,827
    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 ...

  5. #5
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  6. #6
    Join Date
    Mar 2004
    Location
    Eindhoven, The Netherlands
    Posts
    7,827
    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

  7. #7
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  8. #8
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  9. #9
    Join Date
    Apr 2003
    Location
    Rozenburg, Holland
    Posts
    27,315
    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

  10. #10
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  11. #11
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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

  12. #12
    Join Date
    May 2004
    Location
    Northern New Jersey
    Posts
    16,602
    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.
    Last edited by Rockefella; 11-12-2006 at 01:21 PM.
    Rockefella says:
    pat's sister is hawt
    David Fiset says:
    so is mine
    David Fiset says:
    do want

  13. #13
    Join Date
    Mar 2004
    Location
    Eindhoven, The Netherlands
    Posts
    7,827
    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. #14
    Join Date
    Nov 2004
    Location
    UK
    Posts
    2,734
    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

  15. #15
    Join Date
    Mar 2004
    Location
    Eindhoven, The Netherlands
    Posts
    7,827
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •