I actually tried calculating my basal adjustment needs in Excel. It's been awhile, and I wasn't exactly successful. I was close though. Maybe a revisit would be worthwhile.
The biggest issue is that sensitivity has to be estimated. If you knew your sensitivity, you wouldn't need to basal test or go through trial and error.
From Shakespeare's Romeo and Juliet, 1594.
Nor arm, nor face, nor any other part
Belonging to a man. O, be some other name!
What's in a name? that which we call a rose
By any other name would smell as sweet;
Minimed 722 Pump, Novarapid, Ramipril A1C 5.6% Diagnosed Oct 19th, 1975.