Spreadsheet to calculate balance of a radial engine.
Enter values for your engine in column C.
If you select 'corrected' slave rod pin angles, they are calculated automatically.
The first graph shows piston displacements from TDC.
The second shows the motion of the centre of mass of each of the master and slave rods.
The third and fourth show the sum of the mass moments, overlaid with the mass moment of the counterweight.
I've increased the crank angle increments from 1 degree to 5 degrees. It can be a bit slow to update otherwise.
To get the best possible balance, adjust the value 'Counterbalance Mass' to get the value of 'Balance error' as small as possible.
Note that the values in the spreadsheet as saved are for a large (2.3 litre, 120kg) engine, hence the otherwise worrying large balance error.
I know I could have used a goal seek function to minimise tha balance error, but I like to see the effect of manually entered changes.
Feel free to share as you wish.
Enter values for your engine in column C.
If you select 'corrected' slave rod pin angles, they are calculated automatically.
The first graph shows piston displacements from TDC.
The second shows the motion of the centre of mass of each of the master and slave rods.
The third and fourth show the sum of the mass moments, overlaid with the mass moment of the counterweight.
I've increased the crank angle increments from 1 degree to 5 degrees. It can be a bit slow to update otherwise.
To get the best possible balance, adjust the value 'Counterbalance Mass' to get the value of 'Balance error' as small as possible.
Note that the values in the spreadsheet as saved are for a large (2.3 litre, 120kg) engine, hence the otherwise worrying large balance error.
I know I could have used a goal seek function to minimise tha balance error, but I like to see the effect of manually entered changes.
Feel free to share as you wish.