+ Reply to Thread
Results 1 to 2 of 2

Can this program be writen in excel?

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Can this program be writen in excel?

    I have some programming knowledge, but not very much. I was going to go about using MATLAB, but if i can use excel I would like to. Essentially I need to find the correct degrees for a bowthruster and z drive on a ship.

    There are 3 angles..for sake of this lets call them.. Alpha, theta, and omega.. defined as I, J, and K...each angle can fall between 0-180 degrees.

    so For i= 0:180
    j=0:180
    k:0:180

    Now I want to keep this short, so I'm not going to go through all the math and steps it took to come up with the next two equations..BUT essentially the program needs to take all numbers from 0-180 for the three angles and run it through the next two equations and then find all the possible outputs with a percent different less then 1.

    equation 1: Fcosi-Fcosj+F1cosk=0 F=700, F1=120

    equation 2: 92.2F(sini+sinj)-7.0922f(cosi+cosj)-87.9433f1sink=0


    essentially without going on, can a program be written in excel to run all the numbers through a trial and error situation.

    This is a very crude begining and is what I have at the core of this, I have started to write out a program I would write into matlab, but if I can do something in excel that will make it much more simple.

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Can this program be writen in excel?

    Hi There,

    Welcome to the forum.

    Please can you change your thread title as it does not comply with Forum Rule# 1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.
    Thanks,

    Bonny Tycoon


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1