Learn how to make fantastic wire wrapped jewelry with artist Eni Oken. No solder or glue, just silver wire, beads and simple tools!

         HOME         JEWELRY gallery         my journal         LEARN  JEWELRY MAKING         tools, tips & materials         contact

     Lesson's Home                                                                                                                   <<--Prev     Next-->>

pricecalcc

Eni's Jewelry Price Calculator
for Excel

Downloadable file

Answers the eternal question: how do I price my jewelry? This simple to use Excel worksheet allows you to input hours of labor and components costs, giving results in 7 well-known price scenarios used by jewelry artisans AND offering optimal suggested wholesale and retail prices.

Click here for screenshot and more info

 

Instructions to download: after purchasing, return to this site to receive a downloading link OR check your email!

Price: US$ 5.00



Images & Design Copyright 2005 Eni Oken

 

TIP: Saving Worksheets versus Workbooks


I received the following question via email regarding usage of the Jewelry Calculator:

>>>Is there any way to save data on a jewelry item without having to open a new workbook? It seems the only way to log information using your spreadsheet is to use the SaveAs feature and save a whole new xls file and then open the original workbook again and start over for each new piece. Is there a way to get it all to save in the same workbook on separate sheets so that it's all in one file perhaps?


The answer: I normally save a whole new worksheet, but this is how you can save a new worksheet:

 

SHORT AND FAST ROUTE:

Click and DRAG the tab called "Jewelry Price Calculator", located at the lower left corner of the calculator. You will see a small sheet of paper on the cursor. Press the CTRL button and you will see a small plus sign inside the sheet. Let go and a duplicate of that worksheet will appear!

clickndrag

 

 

Alternative LONG ROUTE:

1) Click with the RIGHT BUTTON of the mouse on the lower left tab named "Jewelry Price Calculator". A small menu will appear, select "Move or Copy".

worksheet01

 

 

2) A small dialog box will open. Make sure the option "Create a copy is selected".
worksheet02

 

 

3) A new tab called "Jewelry Price Calculator (2)" will appear. Click with RIGHT BUTTON of the mouse again, and this time select "Rename".

worksheet03


 

4) Type the new name of the new Worksheet. Now you can keep all your calculations in the same workbook.

worksheet04

 

This is especially useful if you have similar products or want to compare different alternative solutions to pricing a piece.

 

Want to learn how to make jewelry like this? Click here!

 

ENI OKEN'S NEWSLETTER:

Subscribe to Eni's Announcement Newsletter and be the first one to know about new jewelry releases and new tutorials:
Subscribe
 

I value your privacy: this is an opt-in/opt-out newsletter:
Unsubscribe

 

jewelry supplies,

cabs, tools, jewelry suppliers

sterling silver wire, goldfilled, components, wire

   Learn how to make wire wrapped jewelry in private tutoring sessions or online classes! Discount Offer: Get all paid tutorials for 50% OFF! More info

 

Contact   -    Links   -    Shipping & Delivery   -    Secure Payment & Privacy   -    Returns & Warranty   -    About the Artist      

 

 

Contact Eni

 

 

Images & Design Copyright 2000-2007 Eni Oken