Organised?

I like spreadsheets.

I could stop there and let you speculate why such a statement in an art blog. When I was a teacher I spent several years late in my career doing more and more IT teaching with pupils but also training members of staff. One tool I used a lot for my record keeping was spreadsheets.

Since being an artist I have two main spreadsheets that I have developed. One is for my financial records and accounting which now allows comparisons from year to year by months. This year although not typical has been interesting to compare with the ongoing development of my business year on year.

The second is my stock record of especially: greeting cards, fine art prints and original art pieces. I am able to keep an eye on stock levels, when new print orders are needed. In previous years when I have had work in up to 5 locations I also know where the stock is, very useful.

Today I started the third. Artist equipment. I have been completing a colour chart to check the state of my markers and how many still work.

See left unit at the front

Now I am going to keep a stock record in a spreadsheet of my different pens – ProMarkers, fineliners and posca paint markers. It will take time to set up but in the long term help me to find particular colours and store so I can easily access each marker when it is needed or new markers need to be ordered.

New spreadsheet started this morning

Hopefully this will make finding and having an easy to check method to see how my pens are doing. Look out for future posts.

New arrivals that prompted the spreadsheet

P.S. busy pens in sets and in sales etc, none of these markers cost more than £1.85 each, current rrp. £3.25 each. A skill in buying wisely.

<div class='sharedaddy sd-block sd-like jetpack-likes-widget-wrapper jetpack-likes-widget-unloaded' id='like-post-wrapper-123416164-4233-6aea61dc97385' data-src='https://widgets.wp.com/likes/?ver=16.4-beta#blog_id=123416164&post_id=4233&origin=andyknillart.com&obj_id=123416164-4233-6aea61dc97385' data-name='like-post-frame-123416164-4233-6aea61dc97385' data-title='Like or Reblog'><h3 class="sd-title">Like this:</h3><div class='likes-widget-placeholder post-likes-widget-placeholder' style='height: 55px;'><span class='button'><span>Like</span></span> <span class="loading"><svg class="jetpack-spinner" width="18" height="18" viewBox="0 0 100 100" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false"><circle cx="50" cy="50" r="46" fill="none" stroke="#ddd" stroke-width="8"/><path d="M 50 4 A 46 46 0 0 1 96 50" fill="none" stroke="currentColor" stroke-width="8" stroke-linecap="round"><animateTransform attributeName="transform" type="rotate" dur="1.4s" from="0 50 50" to="360 50 50" repeatCount="indefinite"/></path></svg><span class="screen-reader-text">Loading…</span></span></div><span class='sd-text-color'></span><a class='sd-link-color'></a></div>

Leave a Reply