Sure Shawn, this use of a spreadsheet would be interesting.
It would be of great support for your endeavor to find the trove of negative reports concerning ordnance that some Federal functionary might have kept. Most of Gorgas' paperwork did not survive the end of the war, complaints were rampant.

Fuzes caused a pile of problems. You might want to work them into your empirical investigation of Civil War Ordnance failures.