Excel Formula - Trench & Pipe Calculation

I need excel formula to calculate various scenarios of a pipe within a trench. Using variable inputs provided I need formula to calculate volumes of materials going back in a trench including 'Haunching Material', 'Backfill Material' & Bedding Material required. These will vary depending on trench width, trench length, trench depth, pipe OD diameter and depth of Haunching Material. Other cell input considerations are pipe ID diameter, bedding material depth and if backfill material is filled to top of trench or left partially filled. As the pipe takes up volume this volume needs to taken off any haunching and back fill calculation. The following inputs are variables; Pipe OD Trench Length Trench Depth Trench Width Bedding Material Depth Haunching Material Depth Backfill Material Depth Sketch attached. I also need warnings if the pipe is too large to fit within the trench both in width and height