Dear All,
This is a small program. For all of you who receives orders for
multiple sizes in different quantities it gives real results for
orders confirmations.
http://www.ganoksin.com/ftp/Ring-Weight-Confirmation.xls
-
With his small program where you can see the average size and
weight for spread in sizes versus quantities for each size. -
Input from the order: style #,Gold Karat, size and
weight, how many rings ordered per each size. -
Look at the bottom and see what is the average size and weight.
It will show the results instantaneously. -
File should be saved with style # as the name. They can be
retrieved later and used for next quote by changing Kt, quantities in
sizes.
Thank You and kind regards,
Joel Z. Fain