+ Reply to Thread
Results 1 to 3 of 3

Draw a curve with defined variables

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    2

    Draw a curve with defined variables

    Hi everyone,

    I warn you already, I'm french and there might be some english math vocabulary I don't know, so I'll try and be as clear as possible in my explanation, and call each variable something.

    I work for a construction insurance company and I need to draw a curve either on Excel 2007 or Grapher on Mac OS X (preferably on excel) that would represent the premium for constructions with an amount from 10,000 € till 1,000,000.00 € (with a step of 10,000 between each points, so a total of 100 points: e.g.: what's the premium for a 10,000 € construction, then for a 20,000 € one, then 30,000 €, etc). Let's call the total construction amount "x", and the premium for it "y" (or f(x))

    For each 100,000, an intermediate premium "p" is set (not proportionally).
    For instance:

    from 100,001€ till 200,000€, the intermediate premium is 10,200;
    from 200,001€ till 300,000€, the intermediate premium is 10,400;
    from 300,001€ till 400,000€, the intermediate premium is 10,500;
    from 400,001€ till 450,000€, the intermediate premium is 11,800;
    from 450,001€ till 500,000€, the intermediate premium is 12,500;


    The premium is calculated with the sum of many percentages, and percentages on THESE percentages... But basically, it's the sum of 3 main objects:

    A: the premium before commissions
    B: the company's commissions
    C: the broker's commission


    Is there a way to define many variables to begin with, and then name stages of the equation for later use to simplify things (for instance, the intermediate premium "p" + 5% becomes "P", so then when i need to use it to add or multiply with another percentage i can just use "P")? Or maybe there is a sort of math terms or odd greek sign (dont know if matrixes are of any use here) that could simplify things a lot (Grapher is quite a complete program so i could use all these terms in it)?
    As you can see, this is actually more about how to use either Grapher or Excel 2007.

    If you need more details or infos, I'll check the forum daily.

    Thanks in advance to whoever can help

  2. #2
    Registered User
    Join Date
    06-25-2008
    Posts
    2
    *bump*?

    Come on, can't be impossible.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    More likely nobody can understand your question.

    Would an example workbook make your problem any clearer?
    Cheers
    Andy
    www.andypope.info

+ 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