Here it is at last, not completed but far enough along to be used with confidence.
The file you are looking for does not exist.
jmp.sh
You must use a gram scale to utilize this to make a formula match the spreadsheet.
Start by adding the batch size in gallons then the PPM of your starting water. This calculates the Ca content of your starting water at 27.5%. If you know your Ca content is higher you can change the formula for I11 =SUM((F11+F18+F24+F32+F38)/B3) + (B5*
0.275) here.
Now you just insert the grams of each product to see how it effects the balance in the mix. This will allow you to have more N in veg and less in flower and anywhere in between. Just play around with it to see how things change.
The idea is to keep everything in the circle in the green!
Don't forget you still need to add the Bio-stimulants. This spreadsheet is designed primarily for hydroponics but the balance carries through to soil depending on the hard elements used in the soil or peat. The biggest concern here would be Dolomite Lime, Lime or other Ca sources used in the soil/peat mix. In this case just let the Ca go low in the spreadsheet. All of the rules for soil or peat fertilizing still apply. Fertilize soil once a week and peat 2 or three times. Just PHed water other times.
View attachment 1326718
Ps. I will be getting a Phosphorus meter soon so this spreadsheet is subject to change if the tested numbers are different than the mathematical. Also important is this is based on the Mega Crop batch I have. So don't work to close to the minimums and maximums to allow for some variations in batches.