I was wondering if anyone in the deep utility (i.e water, wastewater) repair/replacement industry would have (and be willing to share) their method/spreadsheet for estimating volumes of materials required for trench excavations? (i.e screened rock, crushed gravel, pit run, sand, native backfill material re-use and waste, black dirt, etc).

Ideally, it would be convenient to be able to enter some basic info such as pipe length and size, invert depth, trench bottom width and height, and side slope angle, then with some constants for depths of different subgrade materials based on the specs for sub-base and trench backfill layers, formula magic happens to tell me how much of each material is required for a job.