I see your creative genius extends beyond pottery. I can see this as being very beneficial in translating glazes to regional supply. I have been writing and testing clay formula limits; which amount to minimum and maximum levels. If I could add that sas information that would produce the median value: this program would work. Hopefully someone has the programming skills you need.
Thanks Nerd. I thought you might be interested in this. At the moment I only have 7 'other restrictions' that you can see on the bottom left, but I'd like users to be able to define their own types of restrictions. The SAS, as you've described it, would be an example of this. A related example: If you knew the particle size distribution of all your ingredients (as in what % lies between given mesh sizes) you could set a prescribed PSD for your clay body. The COE for glazes, as calculated by other glaze programs, is another example, but I think the conditions under which the calculated COE matches the actual COE are quite narrow, which is why I haven't included it as a default restriction.
A simpler way to work out how much base remains after removing 2ml from 48ml is to multiply by 46/48 = 0.95833...
So if you started with 30.64g per cup, you'd have 30.64g x (46/48) = 29.23g of the base left after removing 2ml.
At the next step you'd have 29.23g x (46/48) = 30.64g x (46/48) x (46/48) = 30.64g x (46/48)^2 = 28.14g of the base left.
If you continue in this way, you'll find the amounts differ slightly from the ones in the spreadsheet. The difference isn't large enough to make a practical difference, but for anyone worrying about where it comes from, it seems to be due to the fact that when you work out the amount of oxide removed, the spreadsheet takes the proportion of oxide in the mixture to be 0.02, whereas it's actually 0.02/1.02.
I wouldn't try reduce plasticity to a single numerical value, since there are number of aspects to it, as Tim mentioned. This survey article mentions various attempts to quantify plasticity.
Ideally, to determine whether density determines resistance to deformation, you'd compare two bodies where you substituted one ingredient with one that's the same with respect to all properties except density. As soon you have other properties changing, you open up the possibility that these are contributing to the deformation resistance.