Suoritettu

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

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

Projektin tunnus: #16299333

Myönnetty käyttäjälle:

Excel4You

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ä
(16 Arvostelua)
3.7

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

sergiuloghin

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ä
(157 arvostelua)
6.9
khudammunir

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ä
(17 arvostelua)
4.3
sunprah2018

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ä
(5 arvostelua)
3.6
QSMaster

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 1 päivässä
(1 arvostelu)
2.1
$15 AUD 1 päivässä
(0 arvostelua)
0.0
abi5a848cf75d285

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

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

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)
0.0