Learn how to handle cells, rows, and columns carefully for effective data input and estimation. Discover how to best utilize spreadsheet formulas, include notes, and avoid common errors while using spreadsheet templates.
Key Insights
- Cells serve as the basic input boxes in a spreadsheet, with rows forming the horizontal lines and columns forming the vertical lines. Each column should have a consistent purpose and format, and hidden rows or columns should be avoided as a safety measure.
- Spreadsheet formulas should be referenced directly from the original data source for accurate calculations. It's critical to leave the formulas in their cells for easy reference and recalculation in case any changes are required in the estimate.
- Adding a notes column is beneficial not only for the user but also for anyone reviewing the estimate as it helps define quantity takeoff items. When using spreadsheet templates, it's advisable to save them with a new name to prevent overriding the unprotected template.
Note: These materials offer prospective students a preview of how our classes are structured. Students enrolled in this course will receive access to the full set of materials, including video lectures, project-based assignments, and instructor feedback.
These are things to remember. Cells are boxes where we can input data. Rows are the horizontal lines of cells, and columns are the vertical lines of cells.
Each column should have a consistent purpose and format. Always remember that there should never be any hidden rows or columns. This is a safety feature built into your process of estimating.
Make sure you do not include hidden rows or columns in your estimate. Spreadsheet formulas should utilize the original data source for calculations whenever possible. Do this instead of daisy-chaining calculations.
Leave the formulas in their cells for reference and to recalculate related values when needed. This is important in case any additional changes are required within your estimate. Make sure that changes are replicated or recalculated throughout the rest of the estimate.
Include a notes column. This is important not only for yourself but for anyone else that reviews your estimate. This helps define your quantity takeoff items as needed.
Learn Construction Estimating
- Nationally accredited
- Create your own portfolio
- Free student software
- Learn at your convenience
- Authorized Autodesk training center
When using spreadsheet templates, first use “Save As” with a new name to prevent overwriting the template if it's unprotected.
