Looking for ways to do interior estimation in Excel? Then, this is the right place for you. You can easily estimate the cost of an interior design plan by going through some steps. Here, you will find 2 ways to do interior estimation in Excel.
How to Do Interior Estimation in Excel: 2 Suitable Methods
To estimate the cost of an interior design plan you can either use an Excel Template or else create it manually. Here, we have shown you the steps needed to do interior estimation in both ways below.
1. Use Excel Templates to Estimate Interior Design
In the first method, you will find a way to estimate interior design using an Excel Template. Follow the steps to do it on your own.
Steps:
- Firstly, open an Excel workbook and click on File.
- Then, go to the New option.
- Next, type “estimate” in the search box and press Enter.
- Now, you will find different templates for estimating costs. You can choose by clicking on any of those templates.
- Here, we will select the Kitchen remodel cost calculator template.
- After that, click on the Create button.
- Thus, a new worksheet for interior estimation will open.
- Now, you can change the title and headings in the workbook according to your choice by just typing in the cells.
- Then, you can also change the contents of the lists according to your wish.
- Here, you can see that we have added Home Decor as a new Category and added the other components of this.
- After that, you will see that Home Decor has been added to the Category box automatically.
- Next, if you add the values of the Actual Cost, the Total Actual Cost will automatically be calculated.
- Similarly, you can change the values in the Estimated Cost column, which will also change the values in the Total Estimated Cost column.
- Then, to filter out any Category, click on the box shown below.
- After that, click on those Categories which you want to filter out.
- Thus, you can filter the dataset according to categories.
- However, if you want to add those categories again, click on the button shown below.
Read More: How to Calculate Residential Construction Cost Estimator in Excel+
2. Manually Perform Interior Estimation in Excel
Now, we will show you how to perform interior estimation manually in Excel. Go through the steps given below to do it on your own.
Step-01: Insert Data & Format Cells
Firstly, you need to insert your data and format cells to perform interior estimation manually. Here are the steps to do that.
- In the beginning, insert the headings of your dataset.
- Here, we will insert Field, Description, Amount, Area, Estimated Cost Per Unit, Actual Cost Per Unit, Estimated Cost and Actual Cost as headings.
- Then, select cell range B4:I4 to format those cells.
- After that, go to the Home tab >> click on Bold button >> select 14 as Font Size.
- Next, insert your values in the Field, Description, Amount and Area columns according to your available data.
- Now, to add borders, select cell range B4:I12.
- Then, go to the Home tab >> click on Borders >> select All Borders.
- After that, select cell range B4:I4.
- Next, go to the Home tab >> click on Fill Color >> select any color according to your wish to change the fill color.
- Similarly, go to the Home tab >> click on Font Color >> select any color according to your wish to change the font color.
- Now, select cell range F5:I12.
- Finally, go to the Home tab >> click on Number >> select Currency as the number format for those cells.
Read More: How to Make an Effort Estimation Sheet in Excel
Step-02: Calculate Estimated and Actual Cost
Now, we will show you how you can calculate the Estimated and Actual Cost using some formulas in Excel.
- Firstly, insert your values in the Estimated Cost Per Unit and Actual Cost Per Unit columns.
- After that, insert the following formula in Cell H5 and press Enter.
=D5*E5*F5
- Then, drag down the Fill Handle tool up to Cell H8 to autofill this formula for cell range H6:H8.
- Now, insert the following formula in Cell H9 and press Enter.
=D9*F9
- Next, drag down the Fill Handle tool to autofill this formula for the rest of the cells.
- Thus, you will get all the values of the Estimated Cost.
- After that, insert the following formula in Cell I5 and press Enter.
=D5*E5*G5
- Then, drag down the Fill Handle tool up to Cell I8 to autofill this formula for cell range I6:I8.
- Further, insert the following formula in Cell I9 and press Enter.
=D9*G9
- Next, drag down the Fill Handle tool to autofill this formula for the rest of the cells.
- Finally, you will get all the values of the Actual Cost.
- Now, to view the dataset more clearly, go to the View tab >> turn off the Gridlines option.
- After that, add the Total Cost row and format the row as you wish.
- Then, insert the following formula in Cell H13 and press Enter.
=SUM(H5:H12)
- Lastly, insert the following formula in Cell I13 and press Enter.
=SUM(I5:I12)
- That’s it. Thus, you can perform interior estimation manually in Excel.
Download Practice Workbook
You can download the workbook to practice yourself.
Conclusion
So, in this article, we have shown you 2 ways to do interior estimation in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Please let us know if there are any more alternatives that we may have missed.