Racking from the fermentation vessel at 20 °C will result in residual CO2 corresponding to about 4 g/L sugar already present in the cider (minus any CO2 lost during racking).
If current SG is 1.001 (1 Oe) and final SG was estimated to 0.008, it means a potential SG drop of 0.003 (3 Oe), which corresponds to 8.5 g/L added sugar.
Summarized:
4 + 8.5 = 12.5 g sugar per litre
This “Pet Nat” gives a carbonation level slightly below a typical cider (~3.5 Bar at 20 °C serving temperature).
If ~9 g/L sugar is then added (= total 21.5 g/L), the cider will be champagne-like in petillance (6 Bar at 20 °C).
Link to chart: https://eeenilsson.github.io/ciderkollen/figures.html
You have produced an interesting chart, Erik. Being a hobby craft cidermaker, I think it could be a very useful tool. I will leave it for others to address your calculations but at first glance they seem to be O.K. to me. My interest is in the carbonation process.
I bottle at the sugar level (i.e. SG) needed for carbonation and retained sweetness, then pasteurise to stop fermentation where I want it (for example, bottle at 1.010 and pasteurise at gauge pressure of 1.8 bar which is 2.5 volumes of CO2 at 20C). At that point the SG should be around 1.005 or 9g/L of sugar for sweetness). It isn’t very precise or elegant, but it works for me.
I monitor bottle pressure in a test bottle fitted with a pressure gauge and hot waterbath pasteurise at 65C for about 10 minutes, so bottle pressure shouldn't get to much more than 6 bar or 100psi which seems to be an adequate safety margin over the likely burst pressure for bottles. As always PPE is essential.
Your chart could be tailored to help with this task. If you are after some feedback, from a user’s perspective I found there are two aspects that you might like to look into.
Firstly, your RHS pressure scale indicates absolute pressure, whereas the actual gauge pressure will be about a bar (15psi) less than this because of atmospheric pressure (Claude and Andrew had an in-depth discussion on this in May 2021, and it is also reflected in the many on-line carbonation calculators that are based on multiple regression research published in Zymurgy Magazine, Summer 1995). So, a “gauge pressure” scale might be useful (you do have a small gauge pressure notation in red that refers to this near the LHS pressure scale).
Secondly, I note that some bottle pressure limits are shown on the chart. This is a useful guide and no doubt you have found that such information is hard to find. The only manufacturers’ information that I could get was from Visy Glass who suggest that 330ml bottles shouldn’t exceed 4 GV (gas volumes) but they don’t specify temperature.
FYI, following is some pressure information that I have found for 12oz/330ml bottles that you might find useful in assessing bottle pressure limits.
Shanghai Misa Glass quote that China Standard GB4544 pass test for various markets is in the order of 1.8MPa (261psi).
U.S. Dept of Commerce has a Voluntary Standard requiring that pressure in reusable bottles should not exceed 200psi
A 1953 Ohio State University PhD study by Jo Morgan Teague “Stress in Glass Bottles” shows distribution curves for the pressure failure of new (and degraded) 12oz bottles. The mean was in the order of 400psi with the worst-case bottles being 50% of this (i.e. around 200psi). Although glass bottle making technology has no doubt changed in the intervening years, I imagine that the spread is similar. Hopefully bottles have become stronger.