Home Renovation Project Planner

Configure the Settings sheet

Select the ‘Settings’ sheet and enter the following information:

• Property Name: This can be the address of the property you’re working on.
• Start date: Enter the renovation start date.
• Target end date: Enter the date you plan to have the renovation completed by.
• People: List all the people who will be involved in this project. You may also list business names or trades. Example: James, Emily, Electrician, Bob’s Tile Shop
• Areas: List all the areas of the property which require work.
• Status: You may rename one or more of the default statuses.
• Priority: You may rename one or more of the default priorities.

🟢 Tip: All dates must be entered in the following format: January 1, 2023

🟢 Tip: To remove an entry in the ‘Category’ list, right click on the entry and select ‘Delete -> Table Rows’.

Start creating tasks

The ‘Tasks’ sheet allows you to manage all your tasks. Each task contains the following columns:

• Task: Enter the name of your task.
• Status: Select a status from the dropdown menu.
• Priority: Select a priority from the dropdown menu. (P1 = Most urgent, P4 = Least urgent)
• Area: Select the affected area from the dropdown menu.
• Budget: Enter the budget amount for this task.
• Actual cost: Enter how much you’ve actually spent on this task.
• Start date: Enter the start date for this task.
• End date: Enter the date which this task should be completed by.
• Assigned to: Select the person who is responsible for this task.
• Comments: Feel free to leave a note or comment for this task (optional).

🟢 Tip: All dates must be entered in the following format: January 1, 2023

🟢 Tip: When the ‘End Date’ is older than Today’s date, it will appear in red.