Hey there! Inspired by my day-by-day Senior Data Scientist job, I find myself often into the process of estimating a new project plan after the requirements gathering phase. Since it is a highly automatable task and sometimes boring one, I decided to create a tool to help me do that in the future for the SambaNova Hackathon.
Starting from a client/business need it creates:
- Work Breakdown Structure (WBS): the breakdown of all the tasks to do for the project
- Dependency graph of the tasks (i.e. a DAG of the tasks and their dependencies), in order to let the Project Manager quickly understand the most critical tasks
- The GANTT chart (both as interactive Plotly and Excel) with all the tasks and their start/end dates
- The team structure: a list of people needed to implement the project. Each person has a role, a desired seniority and a list of skills
- Economics: the overall cost of the project splitted in personnel and non-personnel costs.
- Personnel costs: starting from the list of roles it uses salary.com data to gather the average annual salary in the USA for each role and calculated the overall cost of the team (it takes into account more than one person per role if any).
- Non-personnel costs: it asks the LLM to estimate it. In an improved version I plan to leverage some existing data (e.g. via RAG).
- Trello Board: with all of the previous information it uses the official Trello APIs to create a new board for the project, as well as a new To Do list that it fills with a card for each task. Each card gets the estimated start and end dates, as well as the people who will work on that specific task (as a description for the Trello card).
Most of the previous points have an LLM agent that is using one or more tools/functions.
Live demo: Here
It could not work 100% because a part of the project performs scraping for the economics and streamlit cloud could block outgoing requests.
Github: Here
Video!
. I put in a project I am doing i and it suggested a team of 4. We need an add on feature to author a headcount justification request 
.