How to Estimate Construction Projects Spreadsheet Functions Google Sheets

Video

Video Description

The office work is hours of staring at a computer screen, often a spreadsheet, trying to produce a proposal for work.

You know how to build it. You think you know how much it should cost, but you are guessing without accurate estimating systems in place.

In this video, I want to show you three simple spreadsheet functions that will show you how to estimate a residential construction project in less time and with more accuracy.

3 SIMPLE SPREADSHEET FUNCTIONS FOR ESTIMATING CONSTRUCTION PROJECTS

The 3 simple spreadsheets functions* are:

1. COPY and PASTE
2. ABSOLUTE REFERENCE
3. DATA VALIDATION

* The format for the examples and functions in this post are for Google Sheets. To my knowledge, the functions are similar (if not the same) to functions used with .xls files.  Also, I use a Mac. Where I refer to keyboard strokes, I am referring to the Mac OS keyboard strokes. You may need to modify the keystrokes listed here for your particular operating system.

====
See the original post here:
http://shawnvandyke.com/estimate-construction-project-spreadsheet-functions/

Sign up for a FREE 28 Day Action Guide to Streamline Your Construction business here:
http://shawnvandyke.com/thepaperworkpunchlist

Scroll to Top