Hello all,
A quick tip here tonight I thought I'd share with you.
In case you didn't know - you can right click on a cell, and type "Insert Comment" and you will get a little post-it looking box that you can type in to leave notes for yourself or others about the cell.
If you're like me, and you hate using the mouse for one reason or another, you can create a new comment, or edit the existing comment, simply by pressing shift + F2. Viola!
Getting out is just as easy - just hit the escape key twice. It may seem a little odd at first, but once you get used to it, you'll be navigating the comments like never before!
Monday, July 21, 2008
Friday, July 18, 2008
An Update - Aggregate Sales
I've received aggregate sales from a few other Etsier's
check out the results thus far!
Care to contribute to the Etsy community sales data to find out what day the most sales occur? Send me your data.
Click here to find out how!
Tuesday, July 15, 2008
Congratulations Etsy - Some Statistics
I thought I would post some statistics about the success Etsy has been having. I will update this later with some more detailed data tables, for those that really love the numbers.
Feel free to check out the original thread with this information.
http://www.etsy.com/forums_thread.php?thread_id=5713729
If I had to describe Etsy's past 6 months, I would say.
Amazing
Why?
Thanks to a very open staff, they've left us with some key financial and shop data points month over month since January. I thought I'd take a closer look, and share some progress Etsy has made, to help you realize what a storefront we've got!
(Warning: This is a long thread, but I wanted to share as much useful information as I could!)
Total Sales:
January 2008: $3.8 Million
June 2008: $6.5 Million
That represents a 71% increase in 5 months. That is amazing.
Items sold:
January 2008: 273043
June 2008: 442000
That represents a 62% increase in 5 months. One interesting note about this, as sales have increased faster than items sold, that means the average Etsy purchase has increased in dollar value. Just how much?
Average Price per Sale:
January 2008: $13.92
June 2008: $14.71
Without a distribution of the actual sales, one can't begin to guess what the ideal price is for the typical Etsy buyer, but this is an interesting place to look to compare your current shops average prices.
Items Listed:
January 2008: 575174
June 2008: 742000
A 29% increase over the past 5 months.
Ratio of Items Listed to Items Sold:
January 2008: 2.1
June 2008: 1.7
This number decreasing is a good thing, meaning that sales have started to gain on new listings. A perfect 1:1 ratio would mean an item sold for every item posted!
New Members:
January 2008: 68000
June 2008: 80000
An 18% increase. Unfortunately, the member statistics are a little less fuzzy, as it appears Etsy switched their reporting in May. Prior to may the reported on new buyers, whereas in May and June they provided buyers and sellers. If an Etsy staff member wanted to comment on this to clarify, I'm sure the contribution would be appreciated! If not, I'm sure we're all more than grateful for the information you've provided.
As I said at the beginning, Amazing. Of all the numbers, the only place any hiccup is seen in the growth over the year was in items sold, which decreased 1.5% from May to June, and Total sales, which held flat (despite the decrease in items sold!).
So to you Etsy, and to those who've made Etsy what it is, I say Thank You.
Feel free to check out the original thread with this information.
http://www.etsy.com/forums_thread.php?thread_id=5713729
If I had to describe Etsy's past 6 months, I would say.
Amazing
Why?
Thanks to a very open staff, they've left us with some key financial and shop data points month over month since January. I thought I'd take a closer look, and share some progress Etsy has made, to help you realize what a storefront we've got!
(Warning: This is a long thread, but I wanted to share as much useful information as I could!)
Total Sales:
January 2008: $3.8 Million
June 2008: $6.5 Million
That represents a 71% increase in 5 months. That is amazing.
Items sold:
January 2008: 273043
June 2008: 442000
That represents a 62% increase in 5 months. One interesting note about this, as sales have increased faster than items sold, that means the average Etsy purchase has increased in dollar value. Just how much?
Average Price per Sale:
January 2008: $13.92
June 2008: $14.71
Without a distribution of the actual sales, one can't begin to guess what the ideal price is for the typical Etsy buyer, but this is an interesting place to look to compare your current shops average prices.
Items Listed:
January 2008: 575174
June 2008: 742000
A 29% increase over the past 5 months.
Ratio of Items Listed to Items Sold:
January 2008: 2.1
June 2008: 1.7
This number decreasing is a good thing, meaning that sales have started to gain on new listings. A perfect 1:1 ratio would mean an item sold for every item posted!
New Members:
January 2008: 68000
June 2008: 80000
An 18% increase. Unfortunately, the member statistics are a little less fuzzy, as it appears Etsy switched their reporting in May. Prior to may the reported on new buyers, whereas in May and June they provided buyers and sellers. If an Etsy staff member wanted to comment on this to clarify, I'm sure the contribution would be appreciated! If not, I'm sure we're all more than grateful for the information you've provided.
As I said at the beginning, Amazing. Of all the numbers, the only place any hiccup is seen in the growth over the year was in items sold, which decreased 1.5% from May to June, and Total sales, which held flat (despite the decrease in items sold!).
So to you Etsy, and to those who've made Etsy what it is, I say Thank You.
Friday, July 11, 2008
How to create buttons to move between sheets
Today's tip is going to focus on a simple Macro and button that should help you design your larger sheets to be easier to move around for yourself and others.
My Sample large sheet has 5 whole tabs.
We're going to use the control toolbox for this one (right click in the blank space up at the top near the help box, and enable control toolbox
Once the control toolbox comes up, we're going to use the Command Button
Click on the button, and then click in your spreadsheet
Right click, and select properties. Your interested in two specific options at this point -> Caption, and (name).
(name) is what excel calls the button - caption is what you and your users see on the button. I'm going to create 4 buttons on the summary Tab. One for each sheet. I am going to name them salesButton, viewsButton, daysButton, and listingButton. The captions will be Sales, Views, Days, and Listings
Once you've set up the buttons, while still in design mode (the little right angle ruler clicked)
double click on your button. This will bring up the visual basic screen. You'll see a lot of things you don't need at this point. All you are concerned with is the main window. For the Sales button, you'll see the following:
The code to move between sheets is very straightforward. Sheets("Sheetname").select
So to select the Sales sheet, we'll input sheets("Sales").select
That's all you need! Now when you turn off design mode (uncheck the design button) and click on the button, it will select the Sales sheet! This may seem pretty mundane for my 5 spreadsheet book, but when you start having dozens of sheets, creating a few buttons on the top or bottom of each sheet for your users to get back to where they came from, or where they need to be going, will make this a LOT easier to use. Just make sure you advise people not to change the sheet names on you, or things will stop working.
My Sample large sheet has 5 whole tabs.
We're going to use the control toolbox for this one (right click in the blank space up at the top near the help box, and enable control toolbox
Once the control toolbox comes up, we're going to use the Command Button
Click on the button, and then click in your spreadsheet
Right click, and select properties. Your interested in two specific options at this point -> Caption, and (name).
(name) is what excel calls the button - caption is what you and your users see on the button. I'm going to create 4 buttons on the summary Tab. One for each sheet. I am going to name them salesButton, viewsButton, daysButton, and listingButton. The captions will be Sales, Views, Days, and Listings
Once you've set up the buttons, while still in design mode (the little right angle ruler clicked)
double click on your button. This will bring up the visual basic screen. You'll see a lot of things you don't need at this point. All you are concerned with is the main window. For the Sales button, you'll see the following:
The code to move between sheets is very straightforward. Sheets("Sheetname").select
So to select the Sales sheet, we'll input sheets("Sales").select
That's all you need! Now when you turn off design mode (uncheck the design button) and click on the button, it will select the Sales sheet! This may seem pretty mundane for my 5 spreadsheet book, but when you start having dozens of sheets, creating a few buttons on the top or bottom of each sheet for your users to get back to where they came from, or where they need to be going, will make this a LOT easier to use. Just make sure you advise people not to change the sheet names on you, or things will stop working.
Subscribe to:
Posts (Atom)
