Don’t use a spreadsheet to track your projects. This video will show you a better way.
I guess every hardcore project manager knows that. But it’s worth a reminder. Watch the video.
Here’s the first point. You can’t sync Android and iOS with a spreadsheet. That means somebody is stuck entering time on a desktop. What about your employees in the field? How do they get their hours back to your project? Why not just use an app that syncs?
Second: In a spreadsheet, your billing rates will get so out of whack you’ll want to off yourself. There are tools for this sort of thing you know. Just sayin’ 🙂
Third, your spreadsheet is not likely to look for user mistakes. So you’ll be correcting them every week. Is that a good use of your time? And what if you make a mistake. 10% of those mistakes never get found. Multiply those hours times your billing rate. That’s how much you lose in human error. Uggh…
Fourth, sure, you can create some charts to show project status in a spreadsheet. But are they all encompassing? Or do you update them every time something changes.
Fifth: Can you log in with the web. Sort of… I guess. But now you have sharing issues.
And lastly, you really don’t get a lot of project management in spreadsheets. Standard Time has PM aplenty. Like that word, aplenty. Me to. 😉 PM aplenty.