Google Docs Template for Freelance – Data & Project Management


Google Docs Template for Freelance – Data & Project Management

February 10, 2012
/ /
in News
/
Share

Freelance project management can get a person lost in the sea of email correspondence from time to time. I’ve tried several time tracking applications and various sorts of free productivity tools for keeping things in order. The drawback of taking this route is that you are running several apps to get the job done. I’m sharing something that I started out with as a starting point for data management with client projects.

If you are new to this please don’t be intimidated. I’m an artsy fartsy gal, who used to be in the “dumb blonde” category. If I can get this you can too! So before I get started with this I’m going to share a link with you, an online friend who shares a love for spreadsheets and organizes her blog posts this way.

Lara Tayler:
The Organized Writer

I was so geeked to meet another chick online who’s into organizing information. If I don’t make your eyes glaze over with this post, I’ll post another tutorial using zoho docs.

Managing Client & Personal Data

Have you ever needed to look up client or personal login information and found yourself digging through emails and text documents?
My partner is a Visual Basic for Applications and .Net programmer. He sometimes shakes his head with my methodology for keeping my information straight. A problem for us is that we spend so much time working on client projects, we haven’t fully developed our own in house business software.

So in a nutshell part of what we do is in addition to web design/development is manage data for people. For our own system we have one big Microsoft Access database that has about 2400 records for clients and login information. Because there are so many records in this database, it would be pretty difficult to load it as a google doc. I’ve tried but it lags a little bit because there is so much data in there. This template will work fine for a starting point if you are a beginner to this.

I’ve sort of outgrown the spreadsheet, but still find it useful for time tracking and keeping a data record set specifically for clients who don’t have database applications.
It may be a great starting point if you have not yet begun to organize your personal and/or client data.

The cool thing about working with data is that you can import it and export it into different applications to perform various functions. A simple task would be to filter a record set by “category” in Microsoft Access. You could then export those filtered records into a spreadsheet.

Say I have 20 records for “John Smith” and I want to see all of the information related to “John Smith”.

A Scenario – Finding it FAST:

I want all of his login information so I can send him the current data he needs. He needs his twitter login, his hosting control panel login, the logins for all of his employees pop email accounts, etc. I would filter the category column and it would pull up only the records in which I’ve entered “John Smith” in the category field.

I could then select all of those records and paste them into the tab in the spreadsheet called “Keys” and bam, here’s all of John Smith’s data. I could paste it into Excel or OO Calc, but honestly I prefer the auto formatting in google docs.

Sharing & Collaboration

I can then share that document with “John Smith” if he has a gmail account. I can talk with him on the phone and select a cell in the spreadsheet and he will see right where I’m at in the document because google will highlight the spot I’m at in the spreadsheet. Also, two people can edit the document at the same time, so it’s great for collaboration. If “John Smith” has someone on staff taking care of his social media marketing, I can collaborate with this employee through a shared google doc.

Time Tracking

The above spreadsheet tab displays a time sheet. When you type the time you started in the IN field and the time you stopped in the OUT field (with AM and PM), it will automatically calculate how many hours and minutes you’ve worked and leave a total at the bottom for the week (or time frame if you remove the days).

Just a FYI, I ran Linux as my main operating system for a few years. Back then I was using Open Office Base for my personal database. My partner was running windows and we just had separate data because I was stubborn and fanatical about using open source software. Base is a great app but definitely not MSAccess. I can’t copy and paste selected filter/sort rows into excel or Open Office Calc from OO Base. One can however, export a database and import that data into these spreadsheet applications.


This is EASY
Above is an invoice. You know what an invoice is right? This one auto calculates your total, bam.

Here’s the logins tab. You can use your tab key to navigate around in the cells or just click on them. If you click on a cell that has a hyperlink though, it will take you to that link. Using the tab and arrow keys on your keyboard is very effective. I typically just put the url in the service column, like say twitter.com/username

I also have other tabs in this sheet for various data/information that is required when working on a project. Some of the fields may be out of date, such as category ID and page order information (used in wordpress before WP 3.0 Custom menus). From time to time I still need to order the pages by number so I keep it in there.
Spreadsheet Link
So once you click on the link, just copy the spreadsheet to your google docs or download it to your computer. I hope you find this useful!

  •  

  •  

  • 14 Comments

    1. Sweetheart Diary February 10, 2012 11:31 am

      Great post. Thanks for this. You really work so hard to bring all this for us. 🙂

      Reply
    2. jenifardesuza February 10, 2012 11:37 am

      A lot of knowledge………….Web Design Manchester

      Reply
    3. suruha February 10, 2012 2:25 pm

      Somehow I know this is really crucial, but, just how – I have no idea! LOL You amaze me with your knowledge!

      Su

      Reply
    4. spreadsheet February 14, 2012 12:57 pm

      Nice post. But when it comes to online data sharing and collaboration, Google Docs doesn't prove very handy, Hence I am looking for some alternatives and have come across CollateBox http://www.collatebox.com/ seems like an handy tool. Well gotta wait for it though, but saw the video its very interesting.http://www.youtube.com/watch?v=1KruqWWiw1s

      Reply
    5. Susan Smith February 14, 2012 6:57 pm

      @spreadsheet What databases does it work with? Can one do custom programming with Collatebox?

      Reply
    6. spreadsheet February 17, 2012 11:19 am

      @susan smith: Seems like the product will work for database management. I too registered recently, now actually waiting for their beta version. Well you can try it.
      Can you please elaborate on what custom programming is?

      Reply
    7. Better than Google Docs February 17, 2012 11:24 am

      Looks like this tool is more o like combination of Dropbox+Evernote, If so then it's gonna be an handy tool. Must wait for this one. Looks very exciting, I hope it solves the problem of working on transient data with multiple users, basically Online data

      Reply
    8. Susan Smith February 17, 2012 4:24 pm

      I see. Sounds interesting. Conflicted copies from multiple users editing a spreadsheet in Drop Box is definitely no fun.

      Reply
    9. website design company February 27, 2012 5:09 am

      The blog is absolutely fantastic. Lots of great information and inspiration, both of which we all need. Thanks.

      Reply
    10. online project management February 27, 2012 4:00 pm

      online project management helps with effectiveness any time selection on the whole. This feature simply saves time period all about for everyone.

      Reply
    11. james leal August 22, 2014 9:59 am

      Hello! I'm a project manager at this marketing firm in New York and we are planning to launch a new project for which I'm incharge. Thankfully most of the work has already been completed and I'm only left with arranging the report formatting and the presentation. I thought I must check out the internet for some Project management templates because I want my report to look as professional as possible. I just jumped across your blog in the process and I love it!! Thanks for sharing.

      Reply
    12. anis January 18, 2016 5:34 am

      Thanks for sharing with us that awesome article you have amazing blog………..

      Reply
    13. anis January 26, 2016 12:11 am

      Thanks for sharing with us that awesome article you have amazing blog.
      Cybergraphix

      Reply
    14. anis April 13, 2016 2:24 am

      This is Great and very useful advice with in this post. Thank you.

      Reply

    Post a Comment

    Your email address will not be published. Required fields are marked *

    *