Friday, June 4, 2021

The Spreadsheet

 If you are an artist and your eyes started to glaze over at the title of this blog, The Spreadsheet, I understand.

We usually think of numbers with the word spreadsheet. Years ago I found keeping track of entry/competition/event deadlines difficult with just various folders and scraps of paper. There was the added complication of figuring out which paintings to enter. When would I hear from this show so I would know if I could enter a certain painting in another show?

That is when I created my Competition Spreadsheet. Of course, being an artist, the spreadsheet had to have colors!

The next step was to figure out the layout, what categories, and in what order.  Rather than get fancy with it, I opted for the basics in this order:

Date Due, Date Results, Name of Application, Submitted Date, Paintings submitted, and two additional info lines. The info might be size limitations, which gallery, whether the painting must be for sale, which painting was accepted, or when the painting needed to arrive.

For colors I use blue for submitted, green for accepted, tan for not accepted, yellow for did not enter, and neon pink for an upcoming deadline. 

For the next year I save the file with a new name, change all the backgrounds back to white and erase the details except the Name of Application entries. As dates become available, they are added and the process begins again. In the past few years I have added a number of shows/events/competitions.

Here is this year's current spreadsheet.


You might ask, why bother? I have a number of reasons.

  1. So I do not miss a deadline
  2. So I do not submit the same painting to two events at the same time
  3. To keep track of what was entered last year
  4. To gain exposure to galleries hosting various shows
  5. To gain exposure in various online formats or magazines
  6. To win cash or prizes 
  7. To sell paintings
  8. To participate in shows
 
For instance, last year for the first time I entered two paintings in the American Academy of Equine Artists. Both were accepted and Range Runners won the Jean Bowman Award. Also last year for the first time I entered the National Oil & Acrylic Painters Society Spring International Online Competition. My painting Ice Bear won Best of Show. I have since joined NOAPS and have been in their 2020 Best of America Show, the 2021 Best of America Small Works Show, and the 2021 Spring International Online Exhibit.

This might seem like a lot of work but setting up this spreadsheet has made the application process so much easier and clearer for me.

No comments: