MEMBERS
- Nnoli Armstrong Chinwendu
- Olajumoke Aiyesa
- Vivian Chiemela Adirichukwu
- Chioma Nwagu
- Arimah Ezinma
You need to take control of your finances. To do so you need to create an automated budget spreadsheet
This spreadsheet receives input parameters like your monthly income, 10 expense categories, and the financial expense amounts for those 10 categories
All you have to do is input the necessary spends on a daily basis and the sheet should automatically generate necessary charts showing budget spends for that month.
If you can, account for input dates and make the budget account for a 12 month period with accompanying charts, great!
This is the link to the report: here
Team Bravo project centered on creating an automated budget Spreadsheet. Spreadsheet was a topic TEAM BRAVO members were not familiar with. The team lead advised the team to take some time and get acquainted with the topic. After which, the team came together and in order to complete the project before the due date, went straight to business. The team lead then assigned roles to each team member.
Chioma Nwagu was assigned to create an Expense and Income form that will be directly linked to the Expense and Income spreadsheet. These forms were a way to put in various incomes and Expenses that had been filled in the forms into their respective sheets.She filled the income form from January to November 2022 and was also assigned to build the main dashboard.
All team members were assigned to fill the Expense form using two categories for each month from January to November 2022.
Nnoli Armstrong Chinwendu was assigned to build the income dashboard and also color code the expense sheet, income sheet and the income dashboard.
Olajumoke Aiyesa was assigned with incorporating the income total column and its formula into the main dashboard. She was also assigned to add conditional formatting to each monthly expenditure, so that when the monthly expenditure is over budget, it will turn red.
Vivian Chiemela Adirichukwu was assigned to create charts showing the Yearly expenditure, Category expenditure for the year, Yearly income and income sources.
Arimah Ezinma was assigned to put in all the necessary formulas that will make the Budget calculator functional. She was also assigned to put in formulas that will link the income and expense sheet to their various dashboards.
As the team leader, She assigned the various roles to her team members using the “Click Up” platform and ensured that they followed through with all their tasks correctly and at the appropriate time.She also ensured after completion of the project, the project is pushed to Github for assessment.
All team members showed dedication to the completion of this project and great team spirit by ensuring that they completed their various roles at the stipulated time and showcasing knowledge of Google sheets. Team Bravo is Optimistic the assessment of their project will be positive.