Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Monday, January 7, 2008

Examine Your Etsy Billing Information - Cheap!

This is now available in my shop CHEAP! I began offering it as a PIF, but realized I'd go broke paying .20 with each one. So, it's only a little over a buck!


Instructions for adding your Statement Data to Etsy_Statements_Summarization.xls. From now on, I'll call this the Statements File.
PC Instructions only. I'm sorry, I'm not familiar with Mac. This assumes you have Microsoft Excel 95 or greater.
  1. Open your new Statements File,
  2. Login to Etsy
  3. Click on Your Etsy
  4. Under the Money section, click on Your Etsy Bill (https://www.etsy.com/billing_main.php)
  5. Click on the month you wish to begin with. I'll choose Dec 2007
  6. Scroll down to the bottom of the page and click on the link "Download this entire montly statement as a CSV file".
  7. You'll receive a choice to Open or Save. Choose Open.
  8. Select OK to any other prompts you may receive until the data opens up in Excel.
  9. Now you should be in Excel, with the data viewable.
  10. Select all of the data. One way is to hold down the Ctrl key, while pressing A.
  11. Copy the data. One way is to hold down the Ctrl key, while pressing C.
  12. Now navigate to the new Statements File.
  13. Click on the Dec tab.
  14. Click on the cell A11 and paste the data. One way is to hold down the Ctrl key, while pressing V.
  15. Voila! The data is automatically totaled on the Dec tab and on the Totals Tab.
  16. Continue on with the other months.
Hope this makes sense. Thanks and have fun!

Tuesday, December 18, 2007

Stages of a Hammered Silver Cuff


On a piece of sheet silver, I draw out the design with an ultra fine sharpie. I have some old machinists rulers that I use. Then I lube up my saw blade and get to work. Magnifying lenses are so necessary in this task. The sheet silver is put upon the bench pin and I saw just outside the line drawn. This takes some time. The teeth on the saw blade are so tiny they can't be seen by the naked eye. Well, not mine anyways. :)

After sawing, I take a rough rasp and file down the larger highs and round the corners slightly. I count as I do the corners so they are more uniform. Then I take a finer file and do it all over again. Once more with a diamond file. Then rough sandpaper, then finer and finer grits until the surface is smooth. Looks pretty when done.


Then I move to the bench block and begin hammering the divots. Thousands of them. I always mean to count, but lose track. Hammering does bend the metal and begins to harden it.


When done, I carefully hand bend it a bit to straighten it out. Then I move to my oval bracelet mandrel. It's a heavy hunk of metal. Using my oh-so-cool rawhide mallet, I start to form the shape of the bracelet around the mandrel. At intervals, I make certain the edges are in line. I actually begin at a much smaller size when shaping then, move up to the actual size needed. I've found this is necessary to convince the metal to move.

When done with this, I check the edges for roughness and sand as needed, then steel wool it for a subtle sheen. If a higher shine is desired, a tumble is a good start and then onto rouges. But that's for another post.

Voila! Takes a bit of time, but very satisfying!