+ Reply to Thread
Results 1 to 2 of 2

Stock Pile Volume Calculation

  1. #1
    Registered User
    Join Date
    11-10-2012
    Location
    Malawi
    MS-Off Ver
    Excel 2007
    Posts
    1

    Stock Pile Volume Calculation

    May I be granted urgent assistance on how I can compute the volume of a stock pile in excel given eastings, nothings, and heights. I used this formula; [Ax(By-Cy)+Bx(Cy-Ay)+CX(Ay-By)]*Average Height(the height of A,B&C): Where ABC are the vertices of the triangle, x,y; the coordinates.
    Last edited by zauyamakanda; 01-02-2013 at 07:25 AM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Stock Pile Volume Calculation

    Hi Zauyamakanda,

    welcome to the forum.
    Hope you have managed to solve this query by now, if not consider below:-

    If you have the coordinates in sheet, you can use simple arithmetic operators and an average function to achieve this. Upload a sample workbook. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1