So, to help me demonstrate to myself exactly how squanderous I am with my own valuable time and money I put the whole lot in a spreadsheet. This allows me to record all the figures I have bought each month and the small number I have painted, and then with a suprising array of satistics (some of which I probably dont need) humiliates my meagre painting efforts.
It has no embedded macro's so I assume will be "safe". I accept no responsibility whatsoever for whether its accuracy or any other aspect of its (non)performance. As this is V1-1 it also comes without any help...
I MAY (repeat MAY) get round to updating it or providing further functionality if anyone requests something sensible. Also note however that I am not an Excel expert so am mostly self taught. I am sure there are better ways of doing what I have done here, but I didn't know abut them at the time!!!
Nice work!
ReplyDeleteIs the summary page supposed to update as I put information into the Data Entry pages, or is there another step that I'm missing? I'm not very good with Excel.
ReplyDeleteChris - yes. I assume from your question that it isn't? Only thing i can think of is that you haven't included a date correctly. It only shows summary for data where it can determine which month that the date entered is in...
ReplyDeleteGreat spreadsheet :) I've stated using it, and it is already helping me curb my miniature excesses. Thanks Brandlin!!
ReplyDeleteHey Brandlin - I need to change the years as this spreadsheet only goes up to 2008!! I need it to infinity and beyond :D
ReplyDelete