×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating a pricelist

Creating a pricelist

Creating a pricelist

(OP)
I'm working on setting up a corporate software that I would like to include a calculator for our pricing guide. This pricing guide will have atleast 3 dimensions (maybe 4). EX:

What Material, How Thick, How tall, Painted/Unpainted(yes/no).

This pricing guide breaks down in this order:
material, thickness, paint, height... from that information, you can get a final price on an indevidual product.

I'm wondering if there is a function for using that many dimensions to call a single number that has no mathmatic properties (ie. =((thickness)x(height))/(painted), and does anyone have any thought as to how to layout a table(s) of this nature.

James Douglas
gusperry@home.com
RaisedLetter.com - 3D Letters Online!
Since I was 16, I've been working on the internet, designing e-commerce & entertainment sites in the San Diego area. My work includes banks, ISP's, and a few wholesale service providers.

RE: Creating a pricelist

I'm sorry, I'm not sure I understand your question.  It sounds like maybe what you want to do is to find a cost from a table given three or four values.

for example:

Material  Thickness  Height   Painted   Cost
  xyz          3       4        Y       3.75
  xyz          3       5        Y       3.85
  abc          2       4        Y       6.00
  abc          2       6        N       5.00

Do you want to be able to input the values in the first four columns and return the cost?  Or are you saying that there is somekind of definable (is that a word) relationship between some of the characteristics and the cost?

 

Kathryn


RE: Creating a pricelist

(OP)
thanks kathryn, yes, I am trying to return a value based on a combination of these parameters.

Somevalue = function("Aluminum", 0.500, 48, "Yes")

if that helps clearify my project, I would love it if you or anyone has any suggestions on how to layout a table.
Possibly like this?:

height ¦ unpainted ¦ painted
2"      ¦         6.00 ¦     8.00
4"      ¦         7.50 ¦     9.50
6"      ¦       10.00 ¦    12.00

but first I have to specify what material, and then, how thick it is: ex. gatorfoam, 1" or gatorfoam, 1½" before I even get to that table above.

maybe I should look at the differenet thickness' as different materials all together and use their name
(GF15 = Gatorfoam 1.5") as the name of the table to cal to for prices. you can see there are lot of things I could do. If anyone thinks they know what I should do, I'm all ears.

thanks again.

James Douglas
gusperry@home.com
RaisedLetter.com - 3D Letters Online!
Since I was 16, I've been working on the internet, designing e-commerce & entertainment sites in the San Diego area. My work includes banks, ISP's, and a few wholesale service providers.

RE: Creating a pricelist

OK, here's my two cemts.

I would set up a number of tables:

tblMaterials
------------
MaterialID  (autonumber PK)
MaterialName
etc.


tblHeight
------------
HeightID (autonumber PK)
HeightValue

tblThickness
------------
ThicknessID (autonumber PK)
Thickness

tblCosts
--------
CostID  (autonumber PK)
MaterialID (Lookup to tblMaterial FK)
HeightID (Lookup to tblHeight FK)
ThicknessID (Lookup to tblThickness FK)
Painted (yes/no datatype)
Cost

You could actually have one table, tblDimension, which contains all the values from Thickness and Height, and then have the two fields in tblCosts both use the same table as a lookup.

Using this method cuts down on data entry errors.  Make sure that you set the LimitToList property for the lookup columns in tblCosts to Yes.  Then you can only ch oose a Material, Height or Thickness that has been predefined.

Hope that helps.

Kathryn


RE: Creating a pricelist

(OP)
thats more than 2 cents, thanks you kindly.

James Douglas
gusperry@home.com
RaisedLetter.com - 3D Letters Online!
Since I was 16, I've been working on the internet, designing e-commerce & entertainment sites in the San Diego area. My work includes banks, ISP's, and a few wholesale service providers.

RE: Creating a pricelist

Yes, but I'm worth it.

Kathryn


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close