Results 1 to 13 of 13

Entering mathematical formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    5

    Entering mathematical formula

    Firstly I'm not sure if this is the correct forum for this question, so apologies.

    I am doing a Motorsport Degree at Uni and as part of one of my assignments I've been asked to produce an Excel spreadsheet to show how changes in crank angle affect in-cylinder volume.

    The full question that I've been given is as follows:

    Based on the equation provided below, produce an excel spreadsheet showing how changes in the crank angle affect the in-cylinder volume. Start from an angle of θ= 180° up to an angle of θ=540° by moving 5° at a time. Produce a graph of the crank angle (θ) vs. volume of cylinder (V)

    V = Vcc + 1/4πBē [L+T-(Tcosθ+√(Lē-Tēsinēθ)]

    Where:
    V = Volume of the cylinder
    Vcc = Volume of the combustion chamber
    B = Bore
    L = Rod Length
    T = Throw of the Crankshaft

    Basically I'm pretty much clueless as how I will go about entering it into excel as a formula to work out the volume of the cylinder for every 5° the crank angle changes.

    If anyone could give me a few steps as to how I would go about it, would appreciate it very much!
    Last edited by ju boy; 10-21-2009 at 06:47 PM.

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