It is such a genius concept!
They didn't provide instructions on how to make your own; it was only mentioned in passing, but I loved the idea! I have minimal excel skills so a few google searches later I was ready to try my hand at building a pricing formula spreadsheet. It took a few (mostly painless, but no promises) hours. I found myself staring at the computer with a blank look in my eyes more than once and I had to revive some long dead math skills to get the calculating properties I wanted. But I did it. It's the best Etsy tool I've created for myself. I input the numbers and it does the math for me. Voila! Retail price with no pain. No tears. No wishing I hadn't ever started this Etsy thing.
Another tool I created was a cost-per-yard yarn calculator. The pricing formula above requires the amount of materials (in my calculator's case, the yardage used in the project) and cost of materials (in this case, the cost per yard) to properly calculate the price. This calculator basically takes the cost of the skein of yarn and divides it by the yardage in the skien and spits out the cost per yard. Basic math, but hey, I'm lazy. I'm more than willing to let the calculator do all the work for me.
I would love to explain in exact detail how I made the pricing formula spreadsheet, but I don't think I could actually do it justice right now. Nor do I believe I could replicate what I actually did. But if you stay tuned I will post a tutorial for how to make your own cost-per-yard yarn calculator and maybe sometime further in the future I will re-figure out and make a tutorial on how to make your own pricing formula spreadsheet.
Stay crafty my lovelies and goodnight.
No comments:
Post a Comment