Work Management Spreadsheet - download?

Submitted by Anonymous (not verified)
in
Podcast Discussions

In this podcast:  https://www.manager-tools.com/2020/03/manager-tools-work-management-spreadsheet-part-1 there was talk of the work management spreadsheet. I loved the idea, and am building my own. However, was wondering if there was a downloadable version somewhere, so i could check it out.

Thanks!

Submitted by Wendii Lord on Tuesday March 31st, 2020 6:30 am

Hi,
Parts 2 and 3 of that cast are coming - and we're working out how to best provide a version you can use.
Best regards,
 
Wendii

Submitted by Francois Chalifour on Wednesday April 1st, 2020 2:43 pm

In reply to by Wendii Lord

Have used one for a while, but looking for ways to enhance it. great idea and thanks for sharing

Submitted by Jay Traylor on Saturday April 4th, 2020 5:20 am

In reply to by Wendii Lord

Thanks so much for considering giving us a version we can implement on our own. 

Submitted by Daniel Harrison on Sunday April 12th, 2020 4:16 pm

In reply to by Wendii Lord

Hi Wendii
Any idea when part 3 of the Works Management spreadsheet will be available or perhaps the shownotes?  I've started implementing this as I think it is great idea but I am struggling with some of the conditional formatting.
Best wishes,
Dan

Submitted by Thomas Cox on Friday April 3rd, 2020 11:44 am

@Wendii - love this tool, but can't figure out how to reverse engineer it. All I really want is a sample of a single row with the formulas available - I can figure the rest out from the podcasts and the PDF image.

Submitted by Joshua Abramson on Tuesday April 7th, 2020 12:00 pm

Contribute as you see fit. Keep it simple please
https://docs.google.com/spreadsheets/d/12PB6OpqYLL7tLBkhgJxzijeTV5yTOA9…
Copy Template by column and paste only the values (Ctrl-Shift-V) when creating a new project
I've set 4 rules for conditional formating
- contains done = green
- past deadline = red
- 1 to 2 days due = yellow
- more than 3 days due = green

Remaining Items
- How to easly mark done on a task. As of now, one has to type "done - d MMM YY"

Submitted by Ace Castle on Sunday July 5th, 2020 11:08 am

In reply to by Joshua Abramson

I tinkered with your spreadsheet.  Look at the comments I made in three of the cells.
I'm having trouble in your spreadsheet and mine getting all the conditional formatting rules to work, especially toward the end.  I've tried rearranging them like Wendii said, but still can't get them all to apply like I want.

Submitted by James Richards on Monday April 20th, 2020 1:26 pm

In the PDF example, row 4, task 1, Sarah is responsible for the task "Add conference to website". 
What if Sarah was responsible for "LAX EMC/ECC" (column F) and a different person was responsible for "AUS EHMC/EMC/ECC" (column G)? 

Submitted by Wendii Lord on Monday April 20th, 2020 2:22 pm

In reply to by James Richards

That's a good question!  We actually do have tasks like that.  The person responsible is "Presenter", and whichever presenter is going to present at the conference is responsible.  Since their name is at the top of the column in the header data, we always know who to chase.
We do have scripts that create "red sheets" which show each person's red tasks, and that script that looks up the presenter to know who is responsible.  They're written in Google Script, and we had a great guy do those for us, because it's beyond me!
 
Wendii

Submitted by Tim Barcz on Sunday June 28th, 2020 9:50 pm

In reply to by Wendii Lord

Wendii,
What do you recommend for projects where each project is different than the previous or other projects in the organization? For example:

  • Build new website
  • Build HR Employee Handbook
  • New corporate location

Each of these are projects but have different tasks associated with them and if this is the first/only time the project is being done then many of the tasks/deliverables will be unknown. You know what tasks are due with EMC and ECC because you've done them over and over and even have different named sheets for different types of projects (Cypress vs the sheet used for podcasts for example).
 
Thanks,
 
tim

Submitted by Wendii Lord on Monday June 29th, 2020 6:42 am

In reply to by Tim Barcz

Tim,
 
we have lots of projects like that.  For example, we just spun up virtual conferences, and we had no plan for how to do that.  My best answer is in three parts:
1. https://www.manager-tools.com/2011/06/one-third-planning-rule-part-1
Don't spend more than 1/3 of the time planning.  No plan survives first contact with the enemy :-)
2. https://www.manager-tools.com/2009/07/coaching-model-revised
Super small, frequent tasks & actions.  It's way easier to think about the next couple of steps than the whole project.
3. https://www.manager-tools.com/2009/01/horstman%E2%80%99s-law-project-management-part-1-hall-fame-guidance
Who does what by when?
 
Does that help?
Wendii

Submitted by David Caplivski on Monday June 17th, 2024 8:30 am

Hey! I now also need to work on Work Management Spreadsheet. Can someone help me on the given topic?

Submitted by Wendii Lord on Tuesday June 18th, 2024 6:48 am

what help do you need?
Wendii