This shouldn't be too hard for us to work with. There are some details, and therein lies the devil, as we say ...
So years ago research was published that showed cattle recovered better from stressful situations if you let them drink an electrolyte solution rather than just water.
Cool idea. Humans do that too. I'm unsure if the cattle will accept the logic. But lets all play along. Consider talking to a vet who wants to chat with you on the topic after we're all done.
Nobody has even implemented this because there just isn't a feasible or economical way to create the 1,000's of liters of water a large number of cattle drink in a day.
That seems weird. Maybe its just to difficult a problem. Anyway ...
I want to take a shot at accomplishing it.
We're here to help.
The idea solution would be 0.09 grams Na/L, 0.12 grams Cl/L and 0.09 grams K/L and 0.02 grams Mg.
That sounds like a good recipe. If your quote resource says its so, we can work with it.
On paper using a mainly sodium bicarbonate mixture, with some NaCl and Potassium bicarbonate I get about 200 times more sodium than I need.
OK. Why did that happen. If you got exactly 200x, why not use exactly 200x less salts, or 200x more water? Why sodium bicarbonate? Some other reason you haven't mentioned?
Will you show us your math? How many grams NaCl, etc. We do require students to show their work on this forum.
Which isn't good. What i'm hoping to accomplish is to be able to say "well, I have 300 head of cattle here, they will drink X Liters of water so I need Y kilograms of the salt mixture"
Or less than y kilos, depending on your math.
Take the salt mixture, measure the correct amount out, then place it in a PVC pipe with a few holes drilled in it & throw it in the water tank.
Hrm. This ease of end use may be detrimental to the plan at this stage.
It dissociates to roughly the correct amount of Na, Cl, K, and Mg
You mean dissolves, then dissociates into the ions, ok. Why do we want to be "rough" about it?
cattle recover better, I'm happy they are healthier & the world is a better place.
Yay.
FYI- the cattle will be drinking from several different types of automatic water tanks that hold anywhere form 200 to 500 Liters. When they start to drink the valve opens automatically releasing more water
I see why you want to formulate a PVC-wrapped "pill" for water addition. But you've making assumptions about dissolving and mixing that aren't good, and we that can't just ignore.
My goal is to formulate a mixture that gets me as close as I can to the ideal mixture.
Again, the "About" can mean anything. It just makes our problems all the more difficult.
So questions-
Using well water not distilled water, so varying levels of impurities in it, how will that impact solubility? A little, a lot?
Generally not at the levels potable water are likely to be at. But when making a nutrient solution, as you are, its you're responsibility to test the input water and adapt your recipe.
Not using an agitator so how much will that impact max solubility and rate of dissociation
Lots. And badly. Not really worth calculating, to the g/L level of hundreds of liters if we can't control mixing.
What can I do to reduce the solubility of the salts?
This is a
non sequitor. Unless you've decided to gild the lily, and ask for time release, on top of the PVC pill. We shouldn't gild lilies, especially when we don't even have a lily to start with.
Changing the temp isn't an option.
Bummer. But not surprising, really. But lets not rule things out. Also why?
Could I use glucose, sucrose,
That should probably be avoided no matter what, given the biology of cattle. Real veterinary knowledge is needed here.
and some minerals (Zn, & Cu)
Even more risky, greater amounts of these can have varying amounts of toxicity. Still not clear why you want to do this.
to increase the number of total dissolved solids and thus reduce the concentration of the Na, Cl, K and Mg ions?
Urm. No. This isn't correct at all. You want to add even more random ions, so the percentage-wise amount in your tablet is less? But that puts even more salts in the water total. That's just incorrect.
Maybe I should be looking at different compounds?
Yes. You selected bicarbonate above, are you also adding some acid, to make a fizzy tablet? Was that the plan?
What type of equipment should I buy to accurately test the levels of Na, Cl, K, and Mg to the 100th of a g/L?
That is a tricky problem in its own right. But your plan isn't really that close.