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

Færdigheder: AutoCAD, Ingeniørarbejde, Excel, Matematik, Mekanisk Ingeniørarbejde

Se mere: 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, formula projected sales projected increase excel, formula para grados farenheit celsius excel, excel spreadsheet mortgage repayment calculation formula, excel formula convert longitude latitute utm excel, need excel macro input data, need excel spreadsheet custom, need excel expert, need excel file track job, need excel assistant, need excel experts

Om arbejdsgiveren:
( 0 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 Mere

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

10 freelancers are bidding on average $36 for this 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
(125 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, Mere

$30 AUD på 1 dag
(11 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 [url removed, login to view] you.

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

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 Mere

$99 AUD in 5 dage
(1 bedømmelse)
$15 AUD på 1 dag
(0 bedømmelser)

100% Satisfaction Guaranteed We will work together and communicate until we make final product. My services include FLYER BROCHURE POSTER BILLBOARD RACK CARD POSTCARD BUSINESS CARD CERTIFICATE REPORT S Mere

$25 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)

A proposal has not yet been provided

$24 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)