Project Management Central

Please login or join to subscribe to this thread SHARE Topics: Resource Management, Scheduling

High level Planning and Resource Mapping lorenzo cecchini Project Manager| Syngenta Crop Protection Monthey, Switzerland Hello, I'm managing a program and I'm struggling on finding the right tool for planning. I tried Smartsheet and multiple online tools, I can't give multiple resources with diverse work allocation to a same task. I tried MS project, visualization is pretty poor. I tried Excel, does exactly what I need but opens the door to errors. Basically I would work at a high level for 6 projects with the same Work Break down structure. Each project will have the same 10 main tasks. Each project has common resources and also specific resources dedicated to projects. Along each task there are milestones / deliverables proper to each project. I would visualize the milestones and deliverables over the task bar for visualization purpose. To map resources, I would assign a work allocation also to deliverables, in order to do not complexif with multiple tasks but consider the workload of the resource in delivering something e.g. a workshop in the middle of a long task. Any advise? Thank you, Lorenzo Saving Changes... Posted: Sep 30, 2021 4:39 PM

Sort By: Newest First Chronological Votes Sergio Luis Conte Helping to create solutions for everyone| Worldwide based Organizations Buenos Aires, Argentina The key is the process, not the tool. Something obvious. My recommendation is trying Kanban taking into account Kanban is not a board only, is a whole method/way of working. Saving Changes... Posted: Oct 1, 2021 6:49 AM Keith Novak Tukwila, Wa, USA I did something similar using excel but adding macros to reduce the errors. The problem there is that if the person who wrote your macros leaves, heaven help anyone who needs to update the spreadsheet in the future. Saving Changes... Posted: Oct 1, 2021 2:41 PM Kiron Bondale Retired | Mentor| Retired Welland, Ontario, Canada Lorenzo - It would be overkill to look at a true PPM tool which could likely address all the visualization needs you have, so I'd agree with Keith that a well designed MS Excel workbook with locked cells and macros which are documented somewhere would be the way to go. If there are only 60 tasks in total, you can have people in the rows, with one person & task they are working on per row and the columns representing weeks, months or whatever time frame granularity you want. With that approach, you can use pivot tables to spin the data however you choose. Kiron Saving Changes... Posted: Oct 1, 2021 5:46 PM

Please login or join to reply