{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1493","1296","bore measurements"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":36,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"1493","index":0,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["CR calculations"]
[null,"input values for cells in","BLUE","others are fixed or calculated"]
[]
["CR = (Vcyl+Vcc)/Vcc",null,"Vcyl=Vcc*(CR-1)",null,"Vcc=Vcyl/(CR-1)"]
["where :"]
["Vcc = total combustion chamber volume"]
["     = Vhead+Vgasket+Vdeck+Vrecess"]
["where:"]
["Vhead=volume in head"]
["Vgasket=volume due to head gasket thickness"]
["Vdeck=volume due to difference between piston TDC and block deck"]
["Vrecess=volume of recess in top of piston (a negative value for crowned pistons)"]
[]
["Vcyl=stroke*pi*(bore/2)^2"]
[]
["starting 1500 values:"]
["stroke",87.5,"mm"]
["bore",{"$f":"IF(D18=\"std\", 'bore measurements'!B2,IF(D18=0.01,'bore measurements'!B3,IF(D18=0.02,'bore measurements'!B4,IF(D18=0.03,'bore measurements'!B5,IF(D18=0.04,'bore measurements'!B6,IF(D18=0.05,'bore measurements'!B7,IF(D18=0.06,'bore measurements'!B8,\"specify!\")))))))","v":73.7},"mm","std","type \"std\" or 0.010 or 0.020 or 0.030 or 0.040 or 0.050 or 0.060 depending on starting piston size"]
["Vcyl",{"$f":"(B17/10)*PI()*(B18/2/10)^2","v":373.278443137625},"cc",{"$f":"B19*4","v":1493.1137725505},"cc engine displacement"]
["Vgasket",{"$f":"(D20*2.54)*PI()*(((B18)/10/2)^2)","v":3.6841515827846059},"cc",3.4000000000000002E-2,"inches compressed head gasket thickness"]
["Vdeck",{"$f":"(D21/0.03937/10)*PI()*(B$18/10/2)^2","v":2.1671523241779456},"cc",0.02,"inches of piston top to block deck clearance; change this value from nominal 0.020 if block has been decked or non-Spitfire pistons used"]
["Vrecess",{"$f":"IF(D22=\"dish\", 6.7,IF(D22=\"flat\",0,\"specify!\"))","v":6.7},"cc","dish","type \"dish\" if dished pistons, \"flat\" if flat-top pistons"]
["CR",7.5,":1","fill-in starting value (e.g., 7.5 for stock dished-piston North America 1500, 9 for stock flat-top piston UK 1500)"]
["therefore:"]
["Vcc old",{"$f":"B19/(B23-1)","v":57.427452790403848},"cc"]
["Vhead old",{"$f":"B25-(B20+B21+B22)","v":44.876148883441296},"cc",null,"input measured value of head volume here, if available--otherwise, leave blank and nominal value used"]
[null,null,null,null,"(useful if substituting a non-stock or already-shaved head)"]
["solution for milling head to achieve new CR:"]
["target CR",9.5]
["Vhead old",{"$f":"IF(D26>0, D26,B26)","v":44.876148883441296},"cc",{"$f":"IF(B30=B26,\"nominal\",\"measured\")","v":"nominal"},"if a measured value entered above, then measured value is used--otherwise nominal value used"]
["new bore",{"$f":"IF(D31=\"std\", 'bore measurements'!B2,IF(D31=0.01,'bore measurements'!B3,IF(D31=0.02,'bore measurements'!B4,IF(D31=0.03,'bore measurements'!B5,IF(D31=0.04,'bore measurements'!B6,IF(D31=0.05,'bore measurements'!B7,IF(D31=0.06,'bore measurements'!B8,\"specify!\")))))))","v":73.7},"mm","std","type \"std\" or 0.010 or 0.020 or 0.030 or 0.040 or 0.050 or 0.060 depending on new piston size"]
["Vcyl new",{"$f":"(B17/10)*PI()*(B31/2/10)^2","v":373.278443137625},"cc",{"$f":"B32*4","v":1493.1137725505},"cc engine displacement"]
["Vdeck new",{"$f":"(D33/0.03937/10)*PI()*(B$18/10/2)^2","v":2.1671523241779456},"cc",0.02,"inches of piston top to block deck clearance; change this value from nominal 0.020 if block has been decked or non-Spitfire pistons used"]
["Vrecess",{"$f":"IF(D34=\"dish\", 6.7,IF(D34=\"flat\",0,\"specify!\"))","v":0},"cc","flat","type \"dish\" for dished pistons, \"flat\" for flat-top pistons"]
["Vcc new",{"$f":"B32/(B29-1)","v":43.915110957367645},"cc"]
["Vhead new",{"$f":"B35-B20-B33-B34","v":38.063807050405089},"cc"]
["cc to remove",{"$f":"B30-B36","v":6.8123418330362071},"cc"]
["cc per mm",3.5,"cc","cc's removed per mm of milling (approx.)"]
["to mill off",{"$f":"B37/B38","v":1.9463833808674877},"mm"]
["to mill off",{"$f":"B39*0.03937","v":7.6629113704752991E-2},"inches"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2.9425/2","v":1.4712499999999999}]

{"sheet":"1296","index":1,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["CR calculations"]
[null,"input values for cells in","BLUE","others are fixed or calculated"]
[]
["CR = (Vcyl+Vcc)/Vcc",null,"Vcyl=Vcc*(CR-1)",null,"Vcc=Vcyl/(CR-1)"]
["where :"]
["Vcc = total combustion chamber volume"]
["     = Vhead+Vgasket+Vdeck+Vrecess"]
["where:"]
["Vhead=volume in head"]
["Vgasket=volume due to head gasket thickness"]
["Vdeck=volume due to difference between piston TDC and block deck"]
["Vrecess=volume of recess in top of piston (a negative value for crowned pistons)"]
[]
["Vcyl=stroke*pi*(bore/2)^2"]
[]
["starting 1300 values:"]
["stroke",76,"mm"]
["bore",{"$f":"IF(D18=\"std\", 'bore measurements'!B2,IF(D18=0.01,'bore measurements'!B3,IF(D18=0.02,'bore measurements'!B4,IF(D18=0.03,'bore measurements'!B5,IF(D18=0.04,'bore measurements'!B6,IF(D18=0.05,'bore measurements'!B7,IF(D18=0.06,'bore measurements'!B8,\"specify!\")))))))","v":73.7},"mm","std","type \"std\" or 0.010 or 0.020 or 0.030 or 0.040 or 0.050 or 0.060 depending on starting piston size"]
["Vcyl",{"$f":"(B17/10)*PI()*(B18/2/10)^2","v":324.21899061096576},"cc",{"$f":"B19*4","v":1296.875962443863},"cc engine displacement"]
["Vgasket",{"$f":"(D20*2.54)*PI()*(((B18)/10/2)^2)","v":3.6841515827846059},"cc",3.4000000000000002E-2,"inches compressed head gasket thickness"]
["Vdeck",{"$f":"(D21/0.03937/10)*PI()*(B$18/10/2)^2","v":2.1671523241779456},"cc",0.02,"inches of piston top to block deck clearance; change this value from nominal 0.020 if block has been decked or non-Spitfire pistons used"]
["Vrecess",{"$f":"IF(D22=\"dish\", 6.7,IF(D22=\"flat\",0,\"specify!\"))","v":0},"cc","flat","type \"dish\" if dished pistons, \"flat\" if flat-top pistons"]
["CR",9,":1","fill-in starting value (e.g., 9 for stock Spitfire mk3 using 515973 head)"]
["therefore:"]
["Vcc old",{"$f":"B19/(B23-1)","v":40.52737382637072},"cc"]
["Vhead old",{"$f":"B25-(B20+B21+B22)","v":34.676069919408171},"cc",null,"input measured value of head volume here, if available--otherwise, leave blank and nominal value used"]
[null,null,null,null,"(useful if substituting a non-stock or already-shaved head)"]
["solution for milling head to achieve new CR:"]
["target CR",9.5]
["Vhead old",{"$f":"IF(D26>0, D26,B26)","v":34.676069919408171},"cc","nominal","if a measured value entered above, then measured value is used--otherwise nominal value used"]
["new bore",{"$f":"IF(D31=\"std\", 'bore measurements'!B2,IF(D31=0.01,'bore measurements'!B3,IF(D31=0.02,'bore measurements'!B4,IF(D31=0.03,'bore measurements'!B5,IF(D31=0.04,'bore measurements'!B6,IF(D31=0.05,'bore measurements'!B7,IF(D31=0.06,'bore measurements'!B8,\"specify!\")))))))","v":73.7},"mm","std","type \"std\" or 0.010 or 0.020 or 0.030 or 0.040 or 0.050 or 0.060 depending on new piston size"]
["Vcyl new",{"$f":"(B17/10)*PI()*(B31/2/10)^2","v":324.21899061096576},"cc",{"$f":"B32*4","v":1296.875962443863},"cc engine displacement"]
["Vdeck new",{"$f":"(D33/0.03937/10)*PI()*(B$18/10/2)^2","v":2.1671523241779456},"cc",0.02,"inches of piston top to block deck clearance; change this value from nominal 0.020 if block has been decked or non-Spitfire pistons used"]
["Vrecess",{"$f":"IF(D34=\"dish\", 6.7,IF(D34=\"flat\",0,\"specify!\"))","v":0},"cc","flat","type \"dish\" for dished pistons, \"flat\" for flat-top pistons"]
["Vcc new",{"$f":"B32/(B29-1)","v":38.143410660113616},"cc"]
["Vhead new",{"$f":"B35-B20-B33-B34","v":32.29210675315106},"cc"]
["cc to remove",{"$f":"B30-B36","v":2.3839631662571108},"cc"]
["cc per mm",3.5,"cc","cc's removed per mm of milling (approx.)"]
["to mill off",{"$f":"B37/B38","v":0.68113233321631739},"mm"]
["to mill off",{"$f":"B39*0.03937","v":2.6816179958726417E-2},"inches"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2.9425/2","v":1.4712499999999999}]

{"sheet":"bore measurements","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["bore (over)","bore (mm)"]
["standard",73.7]
[0.01,{"$f":"A3*25.4+B$2","v":73.954000000000008}]
[0.02,74.207999999999998]
[0.03,74.462000000000003]
[0.04,74.716000000000008]
[0.05,74.97]
[0.06,75.224000000000004]