Engine Displacement spreadsheet

[prospero]

As promised, here is the Excel spreadsheet I developed to calculate engine displacement. The yellow background color cells are automatically calculated. The white background color cells accept user input. There are various alternatives already calculated by default, any of them may be changed. Have fun!

[90GTVert]

=(PI()/4)*(D2^2)*D3*B4

Can you tell me what the function explanation is in the first set of brackets (not sure what the () does here), and what is the function of the symbol ^ in the second set. I've never seen this used before. Thanks. Stan

[prospero]

Hello Stan,

Lets go part by part.

I borrowed this equation from en.wikipedia.org/wiki/Engine_displacement.



Which states one fourth of pi times the bore squared times stroke times number of cylinders equals engine displacement.

The () are parenthesis and they are used for arithmetic operation grouping. In essence it permits one to bypass the standard order of operations and is required for proper calculation in this equation. Here is more information on that subject: en.wikipedia.org/wiki/Order_of_operations

The ^ symbol is used to elevate to the power of. In this case to the power of two, or squared.

I hope this answers your questions.

ndnparts said:

=(PI()/4)*(D2^2)*D3*B4

Can you tell me what the function explanation is in the first set of brackets (not sure what the () does here), and what is the function of the symbol ^ in the second set. I've never seen this used before. Thanks. Stan

[Admin]

Oh man, it's been 25 years since I've dealt with that sort of stuff. I found a couple websites where you can enter the bore and stroke and it gives you the displacement in about 1/2 second. I must be getting lazy. Cool work Prospero!

[90GTVert]

Thanks! I do a lot of formulations and statements but I had never run into those in any common formula. Probably because I rarely use any volume, area or mass calculations. Thaks for the clarifications. Stan