+ Reply to Thread
Results 1 to 1 of 1

Help on Pricing Quote Calc Formula

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help on Pricing Quote Calc Formula

    Hey Guys

    I need some help plz ....Im currently in College doing my Bussiness/Commerce course.....In my project I need to create a business plan & a module is to create a Quote/Cost calculator in Excel (which gives point on time management/continous improvement). The area is construction and focusing on windows.

    I have my data I just need help in terms of how to proceed with the codes...

    An example of the data is -

    Widthmm Dropmm m2 $
    0-600 0-1600 0.96 (MAX) 119 (WILL ALWAYS BE THIS COST)
    0-600 1601-2100 1.26 (MAX) 126 (WILL ALWAYS BE THIS COST)

    All I want my excel code to do is add in my width and drop and for a price to be created......I need the values to fall in between MIN&MAX values EX. 425x1500 is the same cost as 590x1400 (0-600 x 0-1600) always will be $119, so if I have a m2 field and it will always be rounded to the highest possible figue just like in the date explained above.

    425 x 1500 = .6375m2 (rounded to max .96m2) .96m2 x ($123.958) = $119



    Do I even need the m2 field? Or can I just set codes so if values are picked up in 0-600 x 0-1600 it will always cost $119

    0-600 x 1601-2100 will always cost $126


    Please help I have attached a simple chart to set parameters.

    pricing-range.jpg
    Last edited by StaceyXO; 05-01-2013 at 05:52 AM. Reason: got asked to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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