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!
Bookmarks