![]() ![]() The templates work with the apps Google Sheets, Docs and Slides, and you can make full use of the sharing and collaboration features of the cloud. ![]() My project management templates are now “ready for Google Workspace” and you can get them here. Once I had created all template, I shared them with my coworkers and my followers on Tactical Project Manager. ![]() Because if you don’t like your templates and spreadsheets, you are likely not going to keep your documentation up to date, which is not good. So I wanted to have tools I enjoyed using. After all, I was going to spend 10-12 hours on leading projects every day. Great user experience: The templates should be fun to use.So that’s why I built my templates without macros. And the macro may in fact give you incorrect data if a spreadsheet is modified but the code is not. Who is going to maintain the macro? You may not have the skills to maintain it. No macros: While it’s nice if you can automate some of the steps, macros can be a huge liability long term.Keep formulas simple: Anybody using my templates should be able to understand instantly how they worked and what the formulas did.If the labor rate for one of my resources went up, I only wanted to update the rate once and my budgeting spreadsheet should automatically recalculate to project cost. If I needed to know when a particular task was due, I could pull that information within 3 seconds. The templates had to be super effective to use. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |