Keeping Track of Blog Posts in Google Docs
Image via WikipediaChances are, you know I post to a lot of blogs. With my recent change of duties at Creative Weblogging, I now have posting privileges on 22 of their blogs. That doesn’t include the work I am doing for voip.com, my S60 blog, Geektronica, or anywhere else. In short, I needed some place to keep track of all of these posts.
Actually, I didn’t need to, at least I didn’t think so. However, the folks at voip.com want me to submit a bi-weekly list of postings I did for them so they can pay me. I then figured if I was going to keep track of it for them, I might as well keep track of it for myself also.
Enter Google Docs and their spreadsheet. I have a simple table that keeps track of what I post, where, and how much I am (theoretically) going to make for the post. When I submit it to voip.com, I’ll take out all the other posts by doing a Save-As and removing the bits that aren’t relevant to them.
I also feel pretty proud of myself because I did something cool: created a second sheet where I calculate how much revenue I earned in the week by pulling specific entries. It’s dynamic because I pull the entries by week number using a formula. Ok, a bit overkill, but it was a nice exercise.
Are you using Google Docs yet? What are you using it for? Let me know in the comments.
Bookmark with: del.icio.us Digg it Furl iFeedReaders ma.gnolia Maple.nu RawSugar reddit Simpy StumbleUpon
Tags: google, Google Docs, software Fnord
Comment by spg
i use google docs a little. but really only as an alternate access method for spreadsheets or docs created on local software(mostly openoffice or other open source alternatives to MS office wares.) i can save copies of docs in google and access from any web connected computer without having to carry a flash drive or save anything locally. great for use in libraries or internet cafe or just visiting a friend and want to show them something without have to download anything locally. i have never actually created anything from scratch in google docs though; but if i was say at a public library and needed to use a web connected computer to write a document really quick that i would later have access to i guess google would be a very likely option.
spg
Comment by PhoneBoy
Since I can potentially blog from multiple computers in my house (or even while traveling), Google Docs ends up being a good thing. I only have to worry about one copy of this spreadsheet floating around–the one in the cloud.