Setting goals: whatever gets measured gets improved. So, if we want to get after it, live a life of splendor, we want to track some of our inputs, the 2.0 way.
It’s lightweight, it’s custom, and it utterly rocks.
We want to track stuff so we live in reality. Ask failure agents and they always never know quite how much business they’ve done. They always rounded up, and I call that agent math. This takes that excuse away and lets you create the reality you will live in.
We’ll soon know what pace we are on. This one’s short, the next one is longer. It’s recorded on viddler at 800×600 res, and i think you can pop it out without leaving the site. Thanks to SnapZ pro for making the video:
The way to do it in the cell is =SUM(OTHERSHEET!C2:C200) where ‘other sheet,’ is the other sheet you are messing with by name. I rename them because of minor glitches across browsers.
Chris Rocks says:
Chris – I’m enjoying this series a great deal. While this is a great way to capture a summary of your day — what are you using throughout the day to track your progress in order to properly fill out the form? For example, are you using a printed out form to track individual activities (i.e. number of phone calls, etc)?
November 17, 2008 — 9:28 am
genuinechris johnson says:
CR:
Sure, I have 2 monitor setup with one monior to work, and one monitor to mess with twitter, im, email and this. I use an Imac 24″ and an old dell 20″ to accomplish this.
CJ
November 17, 2008 — 10:22 am
Peter says:
Thanks for the tip Chris. I never thought of that and I always look for new and innovative ways to improve and speed up my business productivity.
I’ll need to check that out.
Peter
November 18, 2008 — 6:40 am