+ Reply to Thread
Results 1 to 4 of 4

Cubic square meter & Square meters total from meter lengths

  1. #1
    Registered User
    Join Date
    09-14-2017
    Location
    essex
    MS-Off Ver
    2017
    Posts
    2

    Cubic square meter & Square meters total from meter lengths

    Hi eveyone,

    I've been have some real trouble as of late trying to get a formula together to work out the total meters cubed and meters squared, from the insulation thickness and meters total.

    for example:
    A B C D E F G
    Size Thickness Length m3 m2
    15mm 15mm 20m total? total?

    if anyone can help and put me in the right direction that would be great.
    I'm just trying to take the size and thickness to get the cubic/square meter then multiplied by the total.

    Thanks

    Will

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cubic square meter & Square meters total from meter lengths

    A
    B
    C
    D
    E
    1
    Size [mm]
    Thickness [mm]
    Length [m]
    Vol [m3]
    2
    15
    15
    20
    0.0045
    D2: =A2/1000 * B2/1000 * C2
    3
    Surface Area [m2]
    4
    1.2000
    D4: =2 * (A2/1000 + B2/1000) * C2


    Both calculations treat the shape like a piece of rectangular tubing. The area calculation ignores the areas of the ends.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-14-2017
    Location
    essex
    MS-Off Ver
    2017
    Posts
    2

    Re: Cubic square meter & Square meters total from meter lengths

    Quote Originally Posted by shg View Post
    A
    B
    C
    D
    E
    1
    Size [mm]
    Thickness [mm]
    Length [m]
    Vol [m3]
    2
    15
    15
    20
    0.0045
    D2: =A2/1000 * B2/1000 * C2
    3
    Surface Area [m2]
    4
    1.2000
    D4: =2 * (A2/1000 + B2/1000) * C2


    Both calculations treat the shape like a piece of rectangular tubing. The area calculation ignores the areas of the ends.
    Hi Shg,

    I'll give that a try thank you for taking the time to do the table

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cubic square meter & Square meters total from meter lengths

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to automatically add square meter m2
    By TwistedEndz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2016, 10:16 PM
  2. [SOLVED] convert square meters to square feet
    By mroberts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2013, 12:51 PM
  3. Replies: 1
    Last Post: 08-12-2010, 05:00 PM
  4. Replies: 3
    Last Post: 08-19-2009, 08:53 AM
  5. [SOLVED] linest - cubic looking for MSE Mean Square Error
    By Streep in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2005, 04:05 AM
  6. [SOLVED] Formating to show square meters ie m2
    By Ska in forum Excel General
    Replies: 5
    Last Post: 02-15-2005, 02:06 PM
  7. how do I display "meter square" symbol in a formula cell ?
    By lau in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2005, 05:06 PM

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