Spreadsheet: 57500d1257717677-entering-mathematical-formula-motorsports-2-
Sheet: Sheet1

Vcc | B | L | T | θ |  | 4.05 | step 1 (Martin) |  |  |  | crank angle | V (including Vcc) | helper
5 | 4 | 6 | 1.95 | 180 |  |  |  |  |  |  | 0 | 5 | 7.95
 |  |  | 1,95 cm crankshaft throw |  |  | 12.56637061435917 | [NAME] |  |  |  | 5 | 5.123500321998784 | 7.940172156640227
volume of combustion chamber approximation, based on  compression ratio of 1 to 10 for 50 cc engine |  |  |  | crank angle, in degrees |  |  |  |  |  |  | 10 | 5.492444048408171 | 7.910812547749828
 |  |  |  |  |  | 49.00884539600078 | step3 |  |  |  | 15 | 6.102182790226791 | 7.862291080372295
 |  |  |  |  |  | result 49 cc displacement, not including volume of combustion chamber (Vcc or cell A2) plausible result |  |  |  |  | 20 | 6.9450471573227 | 7.795218065182627
 |  |  |  |  |  |  |  |  |  |  | 25 | 8.010464151122612 | 7.710434874673945
 |  |  |  |  | V = | 54.00884539600078 |  |  |  |  | 30 | 9.285122339727614 | 7.609000798939421
 |  |  |  |  |  | V = displacement (cubic centimeters, G5) plus Vcc (A2) |  |  |  |  | 35 | 10.75318520461025 | 7.492176068081561
 |  |  |  |  |  |  |  |  |  |  | 40 | 12.39655253183502 | 7.361401051359792
dubbelcheck 1: set E2 (crankshaft angle) to zero: this means Top Dead Center, result in G5 (displacement) should be zero. The present value of 180 (degrees) implies [NAME], displacement at maximum. |  |  |  |  |  |  |  |  |  |  | 45 | 14.19516873965035 | 7.218271721260287
 |  |  |  |  |  |  |  |  |  |  | 50 | 16.12737551633622 | 7.06451159146768
dubbelcheck 2: set rod length (in C2)  to 12 cm, double the present length. This should not influence the result in G5 (displacement) for a given crank angle of 180° or 0°, but should influence the result for all other crank angles |  |  |  |  |  |  |  |  |  |  | 55 | 18.17030406546476 | 6.901940502979
 |  |  |  |  |  |  |  |  |  |  | 60 | 20.30029967795107 | 6.732440837733376
 |  |  |  |  |  |  |  |  |  |  | 65 | 22.49336843659231 | 6.557921970994297
 |  |  |  |  |  |  |  |  |  |  | 70 | 24.72563289752498 | 6.380284009371397
 |  |  |  |  |  |  |  |  |  |  | 75 | 26.9737809867257 | 6.20138206877195
V = Vcc + 1/4πB² [L+T-(Tcosθ+√(L²-T²sin²θ)] |  |  |  |  |  |  |  |  |  |  | 80 | 29.21549057122751 | 6.022992488096979
 |  |  |  |  |  |  |  |  |  |  | 85 | 31.42981167623067 | 5.846782413369999
Where: |  |  |  |  |  |  |  |  |  |  | 90 | 33.5974894650013 | 5.674284095813321
V = Volume of the cylinder |  |  |  |  |  |  |  |  |  |  | 95 | 35.70121399792427 | 5.506875016654131
Vcc = Volume of the combustion chamber |  |  |  |  |  |  |  |  |  |  | 100 | 37.72578726380337 | 5.345764595195951
B = Bore |  |  |  |  |  |  |  |  |  |  | 105 | 39.6582035536957 | 5.191987792872118
L = Rod Length |  |  |  |  |  |  |  |  |  |  | 110 | 41.48764522409071 | 5.046405450401289
T = Throw of the Crankshaft |  |  |  |  |  |  |  |  |  |  | 115 | 43.20540148776883 | 4.909710750205569
 |  |  |  |  |  |  |  |  |  |  | 120 | 44.80472237595146 | 4.782440837733376
 |  |  |  |  |  |  |  |  |  |  | 125 | 46.28062295738226 | 4.664992401209919
 |  |  |  |  |  |  |  |  |  |  | 130 | 47.62965410192872 | 4.557639913690176
 |  |  |  |  |  |  |  |  |  |  | 135 | 48.84965565728561 | 4.460555274632751
 |  |  |  |  |  |  |  |  |  |  | 140 | 49.93950621111852 | 4.373827723195777
 |  |  |  |  |  |  |  |  |  |  | 145 | 50.89888109898744 | 4.297483095354492
 |  |  |  |  |  |  |  |  |  |  | 150 | 51.72802746280833 | 4.231501724180109
 |  |  |  |  |  |  |  |  |  |  | 155 | 52.42756236719337 | 4.175834505231011
 |  |  |  |  |  |  |  |  |  |  | 160 | 52.99829752918206 | 4.130416844117584
 |  |  |  |  |  |  |  |  |  |  | 165 | 53.44109227483204 | 4.095180357844928
 |  |  |  |  |  |  |  |  |  |  | 170 | 53.75673496056639 | 4.070062311002216
 |  |  |  |  |  |  |  |  |  |  | 175 | 53.94585226509281 | 4.055012834082419
 |  |  |  |  |  |  |  |  |  |  | 180 | 54.00884539600078 | 4.05
 |  |  |  |  |  |  |  |  |  |  | 185 | 53.94585226509281 | 4.055012834082419
 |  |  |  |  |  |  |  |  |  |  | 190 | 53.75673496056639 | 4.070062311002216
 |  |  |  |  |  |  |  |  |  |  | 195 | 53.44109227483204 | 4.095180357844928
 |  |  |  |  |  |  |  |  |  |  | 200 | 52.99829752918206 | 4.130416844117584
 |  |  |  |  |  |  |  |  |  |  | 205 | 52.42756236719337 | 4.175834505231011
 |  |  |  |  |  |  |  |  |  |  | 210 | 51.72802746280831 | 4.23150172418011
 |  |  |  |  |  |  |  |  |  |  | 215 | 50.89888109898744 | 4.297483095354492
 |  |  |  |  |  |  |  |  |  |  | 220 | 49.93950621111852 | 4.373827723195777
 |  |  |  |  |  |  |  |  |  |  | 225 | 48.84965565728561 | 4.460555274632751
 |  |  |  |  |  |  |  |  |  |  | 230 | 47.62965410192872 | 4.557639913690176
 |  |  |  |  |  |  |  |  |  |  | 235 | 46.28062295738226 | 4.664992401209919
 |  |  |  |  |  |  |  |  |  |  | 240 | 44.80472237595147 | 4.782440837733375
 |  |  |  |  |  |  |  |  |  |  | 245 | 43.20540148776883 | 4.909710750205569
 |  |  |  |  |  |  |  |  |  |  | 250 | 41.48764522409071 | 5.046405450401289
 |  |  |  |  |  |  |  |  |  |  | 255 | 39.65820355369569 | 5.191987792872119
 |  |  |  |  |  |  |  |  |  |  | 260 | 37.72578726380337 | 5.345764595195951
 |  |  |  |  |  |  |  |  |  |  | 265 | 35.70121399792427 | 5.506875016654131
 |  |  |  |  |  |  |  |  |  |  | 270 | 33.5974894650013 | 5.674284095813321
 |  |  |  |  |  |  |  |  |  |  | 275 | 31.42981167623068 | 5.846782413369998
 |  |  |  |  |  |  |  |  |  |  | 280 | 29.21549057122752 | 6.022992488096978
 |  |  |  |  |  |  |  |  |  |  | 285 | 26.97378098672571 | 6.201382068771949
 |  |  |  |  |  |  |  |  |  |  | 290 | 24.72563289752497 | 6.380284009371398
 |  |  |  |  |  |  |  |  |  |  | 295 | 22.49336843659231 | 6.557921970994297
 |  |  |  |  |  |  |  |  |  |  | 300 | 20.30029967795107 | 6.732440837733376
 |  |  |  |  |  |  |  |  |  |  | 305 | 18.17030406546477 | 6.901940502978999
 |  |  |  |  |  |  |  |  |  |  | 310 | 16.12737551633622 | 7.06451159146768
 |  |  |  |  |  |  |  |  |  |  | 315 | 14.19516873965035 | 7.218271721260287
 |  |  |  |  |  |  |  |  |  |  | 320 | 12.39655253183503 | 7.361401051359791
 |  |  |  |  |  |  |  |  |  |  | 325 | 10.75318520461026 | 7.49217606808156
 |  |  |  |  |  |  |  |  |  |  | 330 | 9.285122339727625 | 7.60900079893942
 |  |  |  |  |  |  |  |  |  |  | 335 | 8.010464151122612 | 7.710434874673945
 |  |  |  |  |  |  |  |  |  |  | 340 | 6.9450471573227 | 7.795218065182627
 |  |  |  |  |  |  |  |  |  |  | 345 | 6.102182790226791 | 7.862291080372295
 |  |  |  |  |  |  |  |  |  |  | 350 | 5.492444048408171 | 7.910812547749828
 |  |  |  |  |  |  |  |  |  |  | 355 | 5.123500321998784 | 7.940172156640227
 |  |  |  |  |  |  |  |  |  |  | 360 | 5 | 7.95