Hello all, new to this forum but have been reading for some time as a guest. Started making Bio a few weeks ago and my first batch was a single stage process. The second was the Titration 2 stage which resulted in more gel / soap than I was expecting. My oil titrated at .67 NaOH. At the end of the second stage, I demethed using the GL method. At the end I got a lot of foaming and the gel. My assumption was too much catalyst in the second stage. I should have performed a 3/27 after stage one but I did not.
Given this experience, I am interested in trying the No titration 2 stage. To this end, I made a spread sheet calculator. Compared my calculator to the one posted on this forum (Tools) and the first stage calculations agree, the second stage do not.
The data I used is as follows.
Batch 75.8 L
Base 3.5 NaOH
Methanol 20%
1st Stage Methanol 12.13L and 265gm NaOH. Agreement on calculated values.
2nd Stage assumed drop out. 0.5 ml
Methanol 20% 3.0L Tools calculator 2.5 L

NaOH .5*3.5*75.8 = 133 gm. Tools calculator 44 gm.

Can anyone help explain the discrepancies?
Thanks Jeff