Results 1 to 3 of 3

Thread: Where to start

  1. #1
    Join Date
    May 2013
    Posts
    2

    Where to start

    Hey all DB guru's,

    My name is Dave and new to the magnificent world of DB'es.
    I've set myself a goal to create an Product price calculator wich calculate's the price based on a excel formula.

    So far i've already created the frontend (I'm an webddesigner),
    the Excel formula is almost done and works fully automatic.

    At the moment I'm stuck on how to go further.


    A sample of what i want can be found here: http://www.drukwerkdeal.nl/nl/produc...o_op_plexiglas

    There are 2 option's on what i can do:

    1. I need an DB filled with all possible options for all products wich can conditional past DB info in to the excel formula.(The excel formula works fully automatic)

    Question would be: Wich DB should I use.

    or

    2. Translate the Excel to a other program wich (should) work better with the DB. As I saw most DB guru's dislike Excel.

    Question: wich programs/DB should i use.


    (I understand that nobody will give me an copy and paste answer, As is said earlyer, I'm new to the world of DB an am trying to learn the power of them.)

    All help is appriciated!


    (The product calculator is gonna be used in a e-commerce enviremont.)

  2. #2
    Join Date
    May 2013
    Posts
    2
    To make evrything a little bit more clear:

    I've created an Excel sheet which is already a full working price calculator.
    Price are build from a number of multiple steps. Let say:

    step 1 choose papertype
    step 2 choose type of printing
    Step 3 etc etc.

    Than steps are existing out of options.

    Step 1 choose paper type:
    Option 1: thin paper
    Option 2: Thicker paper
    Option 3: coloured paper
    etc etc.

    Options are data string containing pricing info based on volume, so 1 piece = €1.00 and 100 = 0.80 etc etc (and some product info like max size, min size, etc etc)

    At the moment i have a BIG BIG data sheet wich will Vlookup info based on the user requested input.
    Than prices wil go to a "simple" formula to create the price.

    At the moment with the excel sheet, i have to manully paste the options (thin paper, thick paper) into the excel.

    Hope this helps!

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Take look at MS sql express, it's free.

Posting Permissions

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