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

Evner: AutoCAD, Ingeniørarbejde, Excel, Matematik, Mekanisk Ingeniørarbejde

Se mere: manning's equation excel spreadsheet si units, open channel flow calculator download, manning formula example, open channel flow calculator metric, open channel flow xls, manning equation calculator excel, manning equation calculator for pipe flow, open channel flow calculator spreadsheet metric, excel formula max drawdown calculation, formula conversion indian rupees dollar excel, formula convert indian rupees usd excel, need excel formula expert, need excel formula programming, excel formula calculation digits convert digits, formula projected sales projected increase excel

Om arbejdsgiveren:
( 6 bedømmelser ) Point Frederick, Australia

Projekt ID: #16299333

Tildelt til:


Hi! Your project is one of the most interesting projects for last several months! I like it and I couldn't miss it! I have a great experience in Excel, so I'll be happy to help you with your project. I'm able to start Flere

$30 AUD på 1 dag
(16 bedømmelser)

8 freelancere byder i gennemsnit $39 på dette job


Hello! I finished Civil Engineering in Romania. I am also an Excel expert You will not be dissapointed, /i have a big 36% rehire rate.

$61 AUD på 1 dag
(157 bedømmelser)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Flere

$30 AUD på 1 dag
(17 bedømmelser)

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following: 1. Excel 2. Financial Modelling 3. PowerPoint Presentation 4. M Flere

$99 AUD in 5 dage
(5 bedømmelser)

hello sir I am a Quantity surveyor based in Sri Lanka and I have very strong experiences of more than 8 years in the field.. kindly let me know what you think about my [login to view URL] you.

$25 AUD på 1 dag
(1 bedømmelse)
$15 AUD på 1 dag
(0 bedømmelser)

The project basically requires knowledge of solid geometry and mensuration formulae coupled with excel skills.

$25 AUD på 1 dag
(0 bedømmelser)

Can we use our expertise for your project we have excel expert available to handle this project for you. Let us know if you want to proceed further. Thanks

$30 AUD på 1 dag
(0 bedømmelser)