skip's pricing

Project Description:
I need a program that takes the prices on the price charts attached and allows me to enter a percentage for a diamond (say prices go up) that increases that this number will increase all the other diamonds appropriately i would need this so only the owner of the software can see and change this number when he wants

next i need a small program with each of the following fields:
Price Conversion Chart for Fancy Cuts & Old Euros

Pear Shape, Emerald, Oval, Cushion, Princess, Radiant, Accsher Cut

Marquis, Trillions, Bag. and Heart shapes, Old European Cuts, Old Miner Cuts



i n the same program it takes the price from the appropriate fields (by fields I mean:
(1) size (from .40 cts up to 5.99 cts ) Please note the shape and size of the diamonds are listed on the top of each "section" in the Black column there are 10 "boxes" so there will be 10 (2) Cut (by this i mean shape of stone listed above) (3) Clarity (from IF to I3), (4) color (from D to M)

In the program above we get the correct price in the chart--if the cut or shape of the diamond is: Pear Shape, Emerald, Oval, Cushion, Princess, Radiant, Accsher Cut-- then take the price that the charts give and multiply it by .65


In the same program above get the correct price in the chart and if the cut or shape of the diamond is: Marquis, Trillions, Bag. and Heart shapes, Old European Cuts ,
Old Miner Cuts then multiply the price that the chart gives by .55

i believe the best way to do this is to
have all this info on a spreadsheet and to have a layout for the formula like this:

Size_______ Cut ___________ Clarity____________ Color_______ Total_________
I would like a drop down box for each "category" and then the total calculated and given (the size catagories for the drop down box are on the top of each "BOX"there are 10 "boxes" so there will be 10 drop down boxes for Size)



MELEE BREAK-OUT DIAMONDS

I need 1 more small "program" for the five categories below they need to ask

Melee Size , how many carats and then take the number below (the number followed by PC) and multiply that number by .60

total Carat weight entered by us : should look like this:
Melee Size__________ total carat weight__________ Price


These 5 categories below can also be on an excel spreadsheet so when we pick the size of the diamond the formula know where to go to get the correct price category


1-7 points up to 120 pc

8-14 points up to 200 pc

15 to 22 points up to 250 pc

23 to 29 points up to 300 pc

30 to 39 points up to 350 pc


LARGE DIAMOND BUYING PRICE LIST (tables attached at bottom of attachment)