Video
Video Description
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