Problem with mold sizing

I know how to do that part of it. What I'd like is a formula that actually takes into account the altered water amounts of various lye concentrations. This formula does not take that into account, and there are times it shorts my total batch size so much that my molds are not at all filled. But with lower lye concentration I can end up with more batter than will fit into a mold.

 

Ahhh, I see now.. I've had this happen too, so frustrating!

 

I've made a excel model which would allow me to resize my recipe to fit the multiple molds that I have.

 

Deleted as the previous user has gone away.

 

I've been following this and it has really grabbed me, so I did a little digging around and found this:
https://www.modernsoapmaking.com/how-to-resize-a-soap-recipe-for-your-soap-mold-imperial-and-metric/
I hope it's helpful for some of you, especially in the difference between imperial and metric (U.S. vs International) as well as volume vs weight.
On a side note it also has the formulas for column molds.