Also, "Head Gasket Volume (cc)" wasn't included in the calculations for columns B & C, and when you do, the compression ratio seems to come out wrong.
Columns B & C also appear to use different formulae to calculate "Combustion volume (cc)" so I didn't go further down that path.
https://docs.google.com/spreadsheets/d/1c3XQoc8EcwDdMsnPR-BS5--745BCabZZrsURfPMtvwI/edit?usp=sharing
This was the main issue, somehow it's always the fancy formulas that are right but the simple addition gets messed up. I should have caught that head volume and combustion volume were equal in column B sooner. When I fix that, I get a stock head volume of 49.5cc and the raised piston volume stays the same at ~16cc, as you've reached manually by iteration. Other values of the sheet remain unaffected, as that stock head volume is just for sanity checking once the raised piston volume is calculated . I added a tab to my sheet with the original head volume formula corrected.
The issue is that my head chambers
are ~39cc, as I've measured directly. That is now a removal of 11cc from the calculated factory value, which is closer to the 4.54cc estimated value you proposed earlier (in the incorrect sheet, it was 17cc off). When I make a copy of your sheet and adjust the head volume to be what I've measured, we have the same values.
Another possibility to explain that misalignment is that the published stock head thickness may be incorrect? Or at least for my head? That would tidy all of this up nicely if that were the case.
Let me know if I've misinterpreted something there, but the 38.5cc is a fixed value. The sanity checking is much appreciated!
Sidenote as it didn't create any issues here: the difference in formulas for combustion volume between B and C was a remnant of working backwards a different way, but it happened to not matter as the subtracted value was 0. That's just the inverted static compression ratio.
Further sidenote: I'm basically ignoring dynamic CR here, as I intend to keep the stock camshaft. Matching static CR should keep everything in order for this particular rebuild.
If anybody has a stock 697-04 head laying around and could cc it that would be great! I'd be willing to send you the supplies for it. Might make a separate thread for that for visibility.