A Rant in Geek Speak

I won’t be the least upset if you don’t read this. I haven’t indulged in a good rant in a while, this one is all about data collection and so forth. Boring as hell, so sorry.

I was looking at my sales data, trying to make some sense of it. Lot’s of luck – it’s a nightmare.

There are 3 vendors, with sub-vendors, 12 months, a series of years to come, and an unlimited number of stories. There’s no freaking way to make it fit in a single spreadsheet.

You know why? Because the crazy data is 3-dimensional not 2-dimensional.

Yes – I know – multiple spreadsheets within a book. Ha! Divided by what exactly? Vendor? Each one has a problem with it – watch this.

Spreadsheet sales by vendor. We have months across the top (X) and each writing project across the side (Y). So where does the sub-vendor information go? Oops! Can’t track sales by market.

Take two – Months across the top and vendor with sub-vendor information down the side. So where do we break it down by writing project? (SUPER clunky, this one, though I will need it for the IRS.)

Take three – each project gets their own spreadsheet. (Right, like I have time for that!) and each sale is broken down by price and royalty rate.

PRICE? Royalty rate? Wait a cotton-pickin’ minute! I gotta know each sale for that. Not just Monthly sales and and vendor but the dang prices (which vary) and royalty rates?

Look, you want to crunch these numbers properly or guess at how much money you lose every time you put a work ‘on sale’ for $.99 – or worse yet for free? Average earnings counts in the real world, chickybaby, so don’t go a ‘art-Tist’ and squirm out of it!

Buck up and Geek this properly.

Must have coffee! Coffee and bad Chinese food!

NO! Too early for Chinese.

Okay, Coffee AND chocolate! Put it in the coffee!

(trots off to raid the Godiva.)

Did I ever tell you that I buy Godiva chocolate at the Rineyville Feed Store?

(trot, trot, trot)


(Sobbing noises)


2 thoughts on “A Rant in Geek Speak

  1. Madison Woods says:

    Oh, no, I feel your pain, LOL. Sure hope you pull through and get those stats organized the way you need them. Sounds like a nightmare. But not so much the nightmare of having the last of the Godiva gone without your knowing…

    • K. A. Jordan says:

      I don’t know what’s worse – making a database from scratch – or being out of Godiva, on a Sunday, when the Feed Store isn’t open until Monday. (sobs)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s