Okay just a few corrections here on the sparging side of things.
This info is very hard to take on board as there is so much misinformation about it on the net and The BIABacus is the only software that can actually handle sparging calculations properly, let alone estimate them very well.
The basic rule is, you should
not sparge if you can fit all your water into the kettle. The reality is the same as, it makes no difference if you have your coffee or tea with two sugars; whether you add all the water first or if you add it over two or three times, your mug of coffee or tea will be just as sweet. (This is not a perfect analogy but the end result is as simple as this.)
Other sites, software etc have you thinking that sparging rinses most/all the final sugars out of the grain. This is not correct. In real life, all-grain brewing is a bit like soaking a pair of really dirty jeans in two 10 Litre buckets versus one 20 Litre bucket. You will end up with the same amount of water at the same level of "dirtiness" (original gravity). Less dirty jeans will result in a less dirty water (lower original gravity), but unless you add hundreds more litres, you will not get clear water (approach an original gravity of 1.000
So basically, forget whatever you have read on sparging elsewhere as this is the only site that has actually tested these things out side by side and with the proper tools. Anyone that does report a higher kettle efficiency using sparging will not have done the same recipe side by side or considered the time in which the grain is in contact with the liquor (water). A typical example is someone tries mashing at full-volume for 60 minutes and then, on their next brew, finds that mashing for 60 minutes and then sparging improves their 'yield'. The reason is not because of the two additions of water, it is because the sparging meant the grain had more time in contact with the water. In other words, if they had just done a full-volume 90-minute mash to start with, they would have achieved the same result with zero extra effort. (This is a very simplistic example as it assumes that the brewer is actually using the exact same recipe, water, temps etc, etc).
There is a lot of other info on this site on this subject but it is hard to find. An advanced search showing the oldest of my posts with any of the following search terms, "The Sweet Liquor Shop", "jeans", "coffee", "tea", "sparging", should come up with more info. If you find any well-written links, post them here as it's been a while since we explored this.
Okay, one last thing chlehb, whilst I haven't checked your file, do not over-ride any BIABacus defaults. I saw you mention changing efficiency for example. Don't do it!!!! The BIABacus estimates all that for you and keeps you on safe ground. Out of time but from a quick scan I can see that you are also confused (and rightly so) on efficiency. One of the reasons why this site created Clear Brewing Terminology is because of this. Read
this post in the CBT thread.

PP
If you have found
the above or anything else of value on BIABrewer.info, consider supporting us by
getting some BIPs!