 Tutorials
Here is a list of tutorials that can help you set up an estimating
spreadsheet. These tutorials are fairly advanced and you need to be familiar
with Excel to understand them. If you are a beginner, they may be hard to
understand. If you have questions about Excel, feel free to email
Lorin with your question.
|
|
Convert Decimal Inches To Feet-Inches (Imperial) In
Excel
This file contains multiple formulas that show how to convert a decimal number
to feet-inches. For example, 25.25" is converted to 2' 1-1/4". Also, the
file contains formulas to convert Feet-Inches to decimal. For example,
5' 3-5/8" is converted to 63.625".
Download Decimal To Imperial
(Feet-Inches)
|
|
Link To Database With Vlookup Formula And Data
Validation Drop Down List
After downloading both files, open both of them in excel. The drop down list
won't work in the estimate if the database isn't open.
Download Estimate
Download Database
|
|
Hierarchal Data Validation Drop Down List
One cell determines what data will appear in the data validation drop down list
of another cell.
Download Variable Drop Down List
|
|
Filter Items In A Data Validation Drop Down List
The value in one cell will filter the items of a data validation drop down list
in another cell.
Download Filter Drop Down List
|
|
Combobox Tutorial
Shows how to add a combobox to a sheet.
Download Combobox Tutorial
|
|
Using A Combobox On An Estimate Spreadsheet
Shows how a combobox can be used to chose items from a database and add them to
an estimate.
Download Estimate With Combobox
|
Pictures
Of Userforms To Add Items To An Estimate
|