tank build calculator.. help

Discussion in 'General Discussions and Advice' started by leslie hempel, 7 May 2009.

  1. leslie hempel

    leslie hempel Moderator MASA Contributor

    Joined:
    7 May 2007
    Posts:
    14,541
    Likes Received:
    285
    Location:
    Gonubie East London
    i wonder of somone could help me,

    im wanting to draw up an excel worksheet to calculate the cost of a piece of glass this is what i had in mind

    qty of glass x measurement 1 x measurement 2 = M2 x Rate of glass = total + vat = total vat incl.

    then total all the vat incl amonts to a total.

    can anyone assist me i keep doing something wrong but i must admit my knowledge of excel is not good at all..

    thanks
     
  2. AdS Guest




    to hide all adverts.
  3. Warr7207

    Warr7207

    Joined:
    28 Dec 2007
    Posts:
    12,781
    Likes Received:
    31
    Location:
    JHB
    Here you go
     

    Attached Files:

  4. trad

    trad Fish, thats the word!

    Joined:
    15 Aug 2007
    Posts:
    936
    Likes Received:
    22
    Location:
    JHb South Linmeyer
    only thing is the rate may not be constant for a cut piece of glass, because of the size there may be wastage etc which the glass co. will charge you for. It the same for carpets the square mtr price is difference to the price per running mtr
     
  5. leslie hempel

    leslie hempel Thread Starter Moderator MASA Contributor

    Joined:
    7 May 2007
    Posts:
    14,541
    Likes Received:
    285
    Location:
    Gonubie East London
    thanks warr, im having the same trouble with yours as with mine..

    see the end figure if one piece of glass @1m2 is R544.92 then 2 pieces should be R1089.84 not R611.84

    se my problem
     
  6. Thinus

    Thinus

    Joined:
    13 Feb 2009
    Posts:
    52
    Likes Received:
    0
    Location:
    Pretoria

    HERE IS THE FIX
    See File Copy Of Tanks
     

    Attached Files:

  7. FransSny

    FransSny

    Joined:
    16 Oct 2008
    Posts:
    5,697
    Likes Received:
    67
    Location:
    Hermanus
    very cool guys

    but as trad said...one should keep wastage in mind as well as enter the qty's & dimensions for bracing etc
     
  8. leslie hempel

    leslie hempel Thread Starter Moderator MASA Contributor

    Joined:
    7 May 2007
    Posts:
    14,541
    Likes Received:
    285
    Location:
    Gonubie East London
    cool dude thanks, i usually go slightly higher on the sate by a rand or 2 to build in the loss factor. this is just to be able to give people an idea of what they are in for by the time they usually make up their minds something has gone up...

    thank you for the assistance
     
  9. leslie hempel

    leslie hempel Thread Starter Moderator MASA Contributor

    Joined:
    7 May 2007
    Posts:
    14,541
    Likes Received:
    285
    Location:
    Gonubie East London
    ok got it.. just finished doing one i think its going to work now just to test it with a few other rates
     
Recent Posts

Loading...
Similar Threads - tank build calculator Forum Date
Custom tank build cost calculator Anything DIY Related 20 Mar 2012
Tank Builder Anything DIY Related 17 Nov 2016
[wtd] Tank Builder Cape Town Wanted 15 Nov 2016
2000x600x600 DIY Tank Build Beginner Discussions 11 Nov 2016
The tank build Medium Tanks 22 Oct 2016
The shallow reef tank build is here... Members Systems and Setups 16 Oct 2016
Tank drilling and sump building in Eastrand help General Discussions and Advice 19 May 2016