I think those are pretty spectacular results
Adjusting the grain bill to 8.532KG, you actually got 78% Into Fermenter Efficiency for a 1.100 OG beer using BIAB!!!
(I just changed the grainbill field B110 on the details tab to match reality)
And if you had added the 200ml the calculator suggested to dilute then you would have 19.95L of 1.100 wort which is pretty spectacularly spot on

, with an extra 40g of grain you would've hit 20L or in fact, slightly exceeded it, due to better than predicted efficiency everywhere else than in the conversion.
Absorption turned out to be 1.38L/KG instead of 1.3L/KG. This is probably a very accurate figure, since the grainbill was such a high percentage of the mash. My figures show an absorption value between 1.2-1.4L. 1.38 is quite possibly exactly to be expected. I also think that finer grinds result in less absorption. You might want to consider updating the absorption figure to 1.38L/KG for you next brew. Or not

, by underestimating you normally end up with a more concentrated beer which can be diluted (ie 200ml at the end), where as with the overestimating you end up with a dilute beer... which means a longer boil if you want to rectify it.
8.5KG x 0.08L is the difference, ie 680ml. BUT, that's only 80ml per kilogram of grain.
on the adjusted grain bill you got 96% conversion efficiency. Not too bad for such an extreme grain bill

, and you proved that you can get 1.102 out of a mash with BIAB
Now, perhaps the 96% was a bit short than the 99% you were aiming for... but more likely its just a measurement error, or it could be the grains not quite being the same as the specs, or even the milling... it could just be the thick L:G (2.35 L/KG)
I've been using 0.5mm gap on my MM2 mill
anyway, I would estimate that anything >95% is good
1.105 would've been 99% conversion... but that's pretty damn close... and the sparge would've picked up the difference. Quite possible more conversion happened during your second mash.
BTW, with the reduced grainbill, you got 78.0% Into Fermenter which is *exactly* what the calculator has predicted based on the updated grainbill!!!
The mash volume calculation is not actually based on my research, so I'm not *that* disappointed it was off
I found the original factor from the greenbay rackers website...
http://rackers.org/calcs.shtml/, Can I Mash It? calculator, 0.67, then added 5% to make it 0.7 for a 5% safety margin. Quite possible it should be higher... I suspect the error is magnified by your thick mash. Anyway, when mashing at the limit, best to hold some water back. Alternatively, I should increase the factor
Another thought, did you end up spilling any mash water when you added your lid? That would've lost a few points there
And did you perhaps measure your total mash volume? Might be able to work out a better grain wet displacement figure
I think the big takeaway is that your results were well within the margins of error on your equipment and measuring devices... which means that the CE calc's theory held up in practise on its biggest test yet
1) 1.100SG is possible in a BIAB mash.
2) The calculators sparging estimates appear to have been correct
3) the Into/End of boil sparge additions appear to have been calculated correctly...
its all good
Thankyou for you testing this as well, and I really expect the beer will be fantastic
I think there is an issue in the chart... as it is getting confused by your -2% Kettle Loss... which I assume is due to measurement inaccuracies somewhere...
Volume measures are probably +-5% and SG +-1%
Amazing results
