≡ Top Menu ≡Category Menu

You are here: Home » NJFM Income/Article Tracking Spreadsheet

NJFM Income/Article Tracking Spreadsheet

SpreadsheetYou all know that I’m a numbers junkie and I track a host of stats when it comes to my online writing.

My stats are helping me to determine what and where to write in 2011 (I’ll get into more detail about that in a later post).  In the meanwhile, I’d like to share a scaled-down version of my income/article tracking spreadsheet.   This one is a bit different than the one I shared some time ago.  It’s got the same basics but I’ve added an Article Count page.

I’ve modified this spreadsheet to suit my needs.  I add and remove formulas and highlight some items with color on an as-needed basis. I want you guys to modify it as you wish.  If the spreadsheet works for you as is, then great.  If it doesn’t, please make changes as you see fit. Just be mindful not to insert numbers in cells with formulas.  It will prohibit the spreadsheet from properly calculating your numbers.

Before asking any questions, please play around with it for a bit to get the feel for what it can do and how it can work for you.


P.S. I don’t usually write two posts in one day, but I needed you guys to have this spreadsheet so you’ll better understand some of my upcoming  posts. 😉

{ 28 comments… add one }
  • Prerna December 28, 2010, 9:37 am

    Completely rocks my world! Thank you!!I’d been using your earlier version and was considering modifying it a bit. But u read my mind. Love ya!

    • Felicia December 28, 2010, 9:39 am

      Hope it works well for you. And, BTW, thanks for the shout out on your blog. I’m headed back over there right now.

      Prerna, you might want to download the spreadsheet again. I just modified it so that when you enter the column headings in January, they’ll populate the column headings throughout the rest of the months (no sense in re-typing if it’s not necessary).

      • Prerna December 30, 2010, 10:26 pm

        You’re most welcome, Felicia. Thanks for the update on the modified version..

        • Felicia December 31, 2010, 8:53 am

          Prerna, your list of 25 free ebooks is fantastic. I downloaded a few and forgot to go back to your blog to thank you for such a great list. I’m headed over there now. BTW, thanks for including my book in your list.

  • Christina Crowe December 28, 2010, 10:09 am

    Wow, I didn’t even know you could make the spread sheet calculate numbers automatically! That’s amazing.

    I’m going to have to look into that for the other spreadsheets I use. Before, it would take me hours to go through everything and make calculations!

    You’re amazing.


  • kidgas December 28, 2010, 10:13 am

    This spreadsheet is similar to my own in that it contains essentially the same information. I have placed my backlinking information in a completely separate spreadsheet since I don’t like working with the tabs below and want to see everything on one page at a glance. It sounds like we are very similar when it comes to numbers and data.

    • Felicia December 28, 2010, 10:21 am

      I guess your finance background and my insurance background breeds stat junkies. 🙂

  • Crystal December 28, 2010, 11:33 am

    Thanks, Felicia – this is just what I need! I was intending to make one but yours is so much better than what I would have come up with. Of course, mine will be mostly blank but that’s ok – I have room for growth:) Best wishes to all of us in the New Year!

  • Sher December 28, 2010, 11:40 am

    Thanks for the new spreadsheet! I used the older one and loved it. This one looks great, too…it will definitely be a great help for 2011!

  • Maria (WriterGig) December 28, 2010, 12:02 pm

    I really should do better job tracking my income each month… I usually jot everything down in a file but no spreadsheets for me at this point. 😉

  • Deanna December 28, 2010, 8:02 pm

    WOW – This is years ahead from my simple spreadsheets – and I went to school for accounting! Love it! Thanks for sharing. 🙂

  • Peter December 29, 2010, 9:46 pm

    Thx. Very Helpful.
    Question on Article Length. I see many writers doing short, very focused articles ie 200-300 words, I assume under the assumption the more articles the more PVs.
    Conversely, longer articles should allow you to get more keywords in the content and therefore more PVs.
    What do you think and does this vary by Site ie Suite vs. AC?

    • Felicia December 30, 2010, 5:17 am

      Peter, some sites require at least 400 words and other sites don’t. I’m not usually verbose so by nature I tend to write shorter articles. Don’t get me wrong, there are those occasions where I write long articles, but I prefer short and to the point.

      All I can say is experiment a bit.

  • Chris Price December 29, 2010, 11:34 pm

    Thank you so much for this. I’m realllllly bad with spreadsheets. I’ve been trying literally for months to wrap my head around how to make a spreadsheet that has all the options I’m looking for. Just by playing around with this amazingly detailed one you’ve made, I have a better idea how to make the very few changes I’m looking to make. (The biggest one is that I want to factor in the time it takes me to complete assignments so I can calculate and chart my pay per work-hour). You have made my goal of getting a working spreadsheet up by year’s end infinitely more likely now.

    • Felicia December 30, 2010, 5:20 am

      Glad this helps. Chris, you’ll find that as you become more used to writing, the time it takes to write an article will diminish. Don’t get discouraged if you seem to take a lot of time initially. It all balances out in the end.

      • Chris Price December 30, 2010, 5:25 am

        Oh, I know. I’ve been writing online for a living for about a year. I’m just too ADD and perfectionist (what a killer combination) to write at optimum speed. It would really help my progress if I could keep track of how much time I’m wasting and how much money that’s costing me.

        • Felicia December 30, 2010, 5:48 am

          I hear ya, Chris. Wasting time is so easy with online writing. If I spent my time writing and not wandering around the internet, I probably would only need to write for about an hour or two a day. Unfortunately, my hand doesn’t know how not to click on unrelated websites when I’m supposed to be writing. 🙂

          That’s why voice recognition software is such a time saver. Not only because I talk faster than I write, but if I’m away from the computer when I write, there’s no temptation to click on an unrelated site and waste my writing time.

          • Ira January 1, 2011, 5:35 pm

            Oh, man you are so right there Felicia.

            I’m really bad about wasting time lol. Picking up Dragon Naturally Speaking was, without doubt, one of the best investments I have ever made.

            400 word article due? No problem, give me 1.5 minutes and it’s done lol

  • Grandma January 1, 2011, 10:07 am

    No kidding, one of my 2011 goal is to stop wasting time on the Internet…all those non-paying but fun stops in Internetland.

    • Felicia January 1, 2011, 10:43 am

      It’s so hard not playing on those fun but time wasting sites. I’m with you, Grandma, I’ve got to get focused.

      • Ira January 1, 2011, 5:38 pm

        I was given productivity advice once that has helped me some, and might do for you guys too.

        There’s nothing at all wrong with distracting yourself fro a while; it gives your mind a chance to fester the backburning ideas. But what you CAN do is set a timer for yourself.

        Give yourself a 30 minute window to surf around, and when the timer goes off, it’s time to work!

        Course, that doesn’t always work for me, cause I, like Felicia, suffer severe allergic reactions to anything resembling a boss or a workplace lol 😀

        But it might help 🙂

    • Daniel January 16, 2011, 3:28 pm

      I am with you Grandma. NO Fun youtube videos, no playing around in facebook. Only focus on working!

  • Ken January 3, 2011, 10:58 am

    Really digging on the spreadsheet Felicia. Recommending it to everybody. Thank you for creating it and making it available.

    • Felicia January 3, 2011, 11:58 am

      I’m glad its working for you, Ken. I’ve found it to be helpful in pointing me in the right writing direction.

  • Daniel January 16, 2011, 3:26 pm

    Thank you Felicia. This is very simple and complete. I liked you worksheet. I did something similar but using some kind of more complex software I developed. Some how I do not trust Excel anymore I have lost data because some bugs the program has.

    • Felicia January 16, 2011, 4:32 pm

      Sorry to hear Excel ate your info. I’ve been using Excel for more years than I’d like to count (well over 10 years) and haven’t had any problems. Maybe I’m one of the lucky ones.

      • Daniel January 16, 2011, 8:42 pm

        I do not who the fault was. Could be my sister turning off the computer improperly or bad luck. No body is perfect!

Leave a Comment