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

Taidot: AutoCAD, tekniikka, Excel, Matematiikka, Koneenrakennus

Näytä lisää: 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, 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, excel formula cidr, excel formula doc file, excel formula expertise, need excel file track job, excel formula call web service, accounting excel formula, excel formula capture data time day, need excel assistant, excel formula network address range, excel formula projects, excel formula convert utm latitude, check excel formula aspnet

Tietoa työnantajasta:
( 3 arvostelua ) Point Frederick, Australia

Projektin tunnus: #16299333

Myönnetty käyttäjälle:


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 Lisää

$30 AUD 1 päivässä
(15 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 1 päivässä
(138 arvostelua)

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, Lisää

$30 AUD 1 päivässä
(11 arvostelua)

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 1 päivässä
(1 arvostelu)

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 Lisää

$99 AUD 5 päivässä
(1 arvostelu)
$15 AUD 1 päivässä
(0 arvostelua)

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 Lisää

$25 AUD 1 päivässä
(0 arvostelua)

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

$25 AUD 1 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)