Spreadsheet: 267390d1380061128-need-a-little-help-with-min-formula-and-formulas-in-range-option-coast-analysis-blank-130924
Sheet: Data

Cost Calculation |  | Tieout Report-bla07FIX012-3/19/2013-8:30:35 AM |  |  |  | Created By | [NAME] |  |  | Cost Calculation |  | Tieout Report-gva0700k-3/7/2013-1:06:07 PM |  |  |  | Created By | [NAME] |  |  | Cost Calculation |  | Tieout Report-mda08FIX008-3/5/2013-10:32:42 AM |  |  |  | Created By | [NAME] #3 |  |  | Cost Calculation |  | Tieout Report-tra08FIX012-3/5/2013-5:42:25 AM |  |  |  | Created By | [NAME] #3
Community |  | bla0700 | [NAME] at Banning Lewis Ranch (bla0700) |  |  | Tax Amount | 7.90% |  |  | Community |  | gva0700 | [NAME] at Green Valley Ranch Golf Club (gva0700) |  |  | Tax Amount | 7.72% |  |  | Community |  | mda0800 | Ranch House at The Meadows (mda0800) |  |  | Tax Amount | 5.10% |  |  | Community |  | tra0800 | Ranch House at Thompson River Ranch (tra0800) |  |  | Tax Amount | 6.70%
Model |  | bla0700-701 | Cypress (bla0700-701) |  |  | [NAME] | 2090 |  |  | Model |  | gva0700-701 | Cypress (gva0700-701) |  |  | [NAME] | 2090 |  |  | Model |  | mda0800-702 | Riviera (mda0800-702) |  |  | [NAME] | 2481 |  |  | Model |  | tra0800-701 | Cypress (tra0800-701) |  |  | [NAME] | 2090
Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description
 | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1
 | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0 |  |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0 |  |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0 |  |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0
 | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1411483253588517 | 295 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.07751196172248805 | 162 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1213220475614672 | 301 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.07751196172248805 | 162
 | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1688995215311005 | 353 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1354066985645933 | 283 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1805723498589279 | 448 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1688995215311005 | 353
 | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 |  |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 |  |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290 |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290 |  |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1558242644095123 | 386.6 |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.138755980861244 | 290
 | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110 |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110 |  |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.061515517936316 | 152.62 |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.05263157894736842 | 110
 | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1410721483272874 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1674641148325359 | 350
 | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.8851674641148326 | 1850 |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.5741626794258373 | 1200 |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.7456670697299477 | 1850 |  |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0
 | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.2392344497607655 | 500 |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.2129186602870813 | 445 |  |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.1068117694478033 | 265 |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1555023923444976 | 325
 | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.2248803827751196 | 470 |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1913875598086125 | 400 |  |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1894397420395002 | 470 |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1913875598086125 | 400
 | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.0131578947368421 | 27.5 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.1119617224880383 | 234 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.04917372027408303 | 122 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.05167464114832536 | 108
 | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0
 | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.0861244019138756 | 180 |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.06985645933014355 | 146 |  |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0 |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.07655502392344497 | 160
 | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105 |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105 |  |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06529625151148731 | 162 |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.05023923444976076 | 105
 | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.09569377990430623 | 200 |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1435406698564593 | 300 |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.120918984280532 | 300 |  |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.3004210526315789 | 627.88
 | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3660287081339713 | 765 |  |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3665071770334928 | 766 |  |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.1596130592503023 | 396 |  |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.323444976076555 | 676
 | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.07894736842105263 | 165 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.0736842105263158 | 154 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.04836759371221282 | 120 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.06698564593301436 | 140
 | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0
 | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.2751196172248804 | 575 |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2277511961722488 | 476 |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.1918581217251109 | 476 |  |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2842105263157895 | 594
 | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5497607655502393 | 1149 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.8468899521531101 | 1770 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4885126964933494 | 1212 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5799043062200957 | 1212
Total |  |  |  |  |  |  | 3.533253588516747 | 7384.5 |  | Total |  |  |  |  |  |  | 3.44066985645933 | 7191 |  | Total |  |  |  |  |  |  | 2.82596533655784 | 7011.22 |  | Total |  |  |  |  |  |  | 2.685588516746412 | 5612.88
bla0700-701 Total |  |  |  |  |  |  | 3.533253588516747 | 7384.5 |  | gva0700-701 Total |  |  |  |  |  |  | 3.44066985645933 | 7191 |  | mda0800-702 Total |  |  |  |  |  |  | 2.82596533655784 | 7011.22 |  | tra0800-701 Total |  |  |  |  |  |  | 2.685588516746412 | 5612.88
Cost Calculation |  | Tieout Report-bla07FIX012-3/19/2013-8:30:35 AM |  |  |  | Created By | [NAME] |  |  | Cost Calculation |  | Tieout Report-gva0700k-3/7/2013-1:06:07 PM |  |  |  | Created By | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Cost Calculation |  | Tieout Report-tra08FIX012-3/5/2013-5:42:25 AM |  |  |  | Created By | [NAME] #3
Community |  | bla0700 | [NAME] at Banning Lewis Ranch (bla0700) |  |  | Tax Amount | 7.90% |  |  | Community |  | gva0700 | [NAME] at Green Valley Ranch Golf Club (gva0700) |  |  | Tax Amount | 7.72% |  |  |  |  |  |  |  |  |  |  |  |  | Community |  | tra0800 | Ranch House at Thompson River Ranch (tra0800) |  |  | Tax Amount | 6.70%
Model |  | bla0700-702 | Riviera (bla0700-702) |  |  | [NAME] | 2485 |  |  | Model |  | gva0700-702 | Riviera (gva0700-702) |  |  | [NAME] | 2485 |  |  |  |  |  |  |  |  |  |  |  |  | Model |  | tra0800-702 | Riviera (tra0800-702) |  |  | [NAME] | 2485
Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option ID |  | Description
 | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  |  |  |  |  |  |  |  |  |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1
 | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0 |  |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0
 | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1211267605633803 | 301 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.06519114688128773 | 162
 | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1802816901408451 | 448 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1553319919517103 | 386 |  |  |  |  |  |  |  |  |  |  |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1802816901408451 | 448
 | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290 |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290 |  |  |  |  |  |  |  |  |  |  |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1167002012072435 | 290
 | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95 |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95 |  |  |  |  |  |  |  |  |  |  |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.03822937625754527 | 95
 | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1408450704225352 | 350
 | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.744466800804829 | 1850 |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.482897384305835 | 1200 |  |  |  |  |  |  |  |  |  |  |  |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0
 | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.2012072434607646 | 500 |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1790744466800805 | 445 |  |  |  |  |  |  |  |  |  |  |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.130784708249497 | 325
 | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1891348088531187 | 470 |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1609657947686117 | 400 |  |  |  |  |  |  |  |  |  |  |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1609657947686117 | 400
 | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.01509054325955735 | 37.5 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.07887323943661972 | 196 |  |  |  |  |  |  |  |  |  |  |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.0744466800804829 | 185
 | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0
 | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05955734406438631 | 148 |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05150905432595573 | 128 |  |  |  |  |  |  |  |  |  |  |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05150905432595573 | 128
 | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105 |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105 |  |  |  |  |  |  |  |  |  |  |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.04225352112676056 | 105
 | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.08048289738430585 | 200 |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1207243460764588 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.3266237424547284 | 811.66
 | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2981891348088531 | 741 |  |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.3082494969818914 | 766 |  |  |  |  |  |  |  |  |  |  |  |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2643863179074447 | 657
 | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.06639839034205232 | 165 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05754527162977868 | 143 |  |  |  |  |  |  |  |  |  |  |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.03822937625754527 | 95
 | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0
 | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.3018108651911469 | 750 |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.1915492957746479 | 476 |  |  |  |  |  |  |  |  |  |  |  |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2531187122736419 | 629
 | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4812877263581489 | 1196 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.7122736418511066 | 1770 |  |  |  |  |  |  |  |  |  |  |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4877263581488934 | 1212
Total |  |  |  |  |  |  | 3.077062374245473 | 7646.5 |  | Total |  |  |  |  |  |  | 2.837022132796781 | 7050 |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | 2.371291750503018 | 5892.66
bla0700-702 Total |  |  |  |  |  |  | 3.077062374245473 | 7646.5 |  | gva0700-702 Total |  |  |  |  |  |  | 2.837022132796781 | 7050 |  |  |  |  |  |  |  |  |  |  |  | tra0800-702 Total |  |  |  |  |  |  | 2.371291750503018 | 5892.66
Cost Calculation |  | Tieout Report-bla07FIX012-3/19/2013-8:30:35 AM |  |  |  | Created By | [NAME] |  |  | Cost Calculation |  | Tieout Report-gva0700k-3/7/2013-1:06:07 PM |  |  |  | Created By | [NAME] |  |  | Cost Calculation |  | Tieout Report-mda08FIX008-3/5/2013-10:32:42 AM |  |  |  | Created By | [NAME] #3 |  |  | Cost Calculation |  | Tieout Report-tra08FIX012-3/5/2013-5:42:25 AM |  |  |  | Created By | [NAME] #3
Community |  | bla0700 | [NAME] at Banning Lewis Ranch (bla0700) |  |  | Tax Amount | 7.90% |  |  | Community |  | gva0700 | [NAME] at Green Valley Ranch Golf Club (gva0700) |  |  | Tax Amount | 7.72% |  |  | Community |  | mda0800 | Ranch House at The Meadows (mda0800) |  |  | Tax Amount | 5.10% |  |  | Community |  | tra0800 | Ranch House at Thompson River Ranch (tra0800) |  |  | Tax Amount | 6.70%
Model |  | bla0700-703 | Augusta (bla0700-703) |  |  | [NAME] | 2764 |  |  | Model |  | gva0700-703 | Augusta (gva0700-703) |  |  | [NAME] | 2764 |  |  | Model |  | mda0800-703 | Augusta (mda0800-703) |  |  | [NAME] | 2764 |  |  | Model |  | tra0800-703 | Augusta (tra0800-703) |  |  | [NAME] | 2764
Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description |  |  |  |  |  |  |  | Option ID |  | Description
 | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1 |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1
 | 020 | Building Permits |  | 32728 | PIKES PEAK REGIONAL |  | 0 | 0 |  |  | 020 | Building Permits |  | 64051 | MANAGER OF FINANCE |  | 0 | 0 |  |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0 |  |  | 020 | Building Permits |  | 58746 | TOWN OF JOHNSTOWN |  | 0 | 0
 | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1132416787264834 | 313 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1132416787264834 | 313 |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.05861070911722142 | 162
 | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1465267727930535 | 405 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376 |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0.1360347322720695 | 376
 | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 502 | Windows |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 |  |  | 502 | Windows |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0 |  |  | 504 | Window Install |  | 25743 | ALSIDE  SUPPLY  CENTER |  | 0 | 0 |  |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0 |  |  | 504 | Window Install |  | 37505 | ATRIUM DOOR & WINDOW |  | 0 | 0
 | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375 |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375 |  |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1720369030390738 | 475.51 |  |  | 538 | Trim & Doors - Material |  | 70442 | BMC  WEST CORPORATION |  | 0.1356729377713459 | 375
 | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130 |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130 |  |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.07146888567293777 | 197.54 |  |  | 588 | Hardware |  | 70442 | BMC  WEST CORPORATION |  | 0.04703328509406658 | 130
 | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350 |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1266280752532561 | 350
 | 631 | Plumbing |  | 9781M | C + T  PLUMBING    LLC |  | 0.6693198263386397 | 1850 |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.4341534008683068 | 1200 |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.6693198263386397 | 1850 |  |  | 631 | Plumbing |  | 9846D | SPECTRUM  PLUMBING,  INC |  | 0 | 0
 | 633 | Electrical |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.1808972503617945 | 500 |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1609985528219971 | 445 |  |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.09587554269175108 | 265 |  |  | 633 | Electrical |  | 4502C | COLORADO SYSTEMS CO |  | 0.1175832127351664 | 325
 | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1700434153400869 | 470 |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1447178002894356 | 400 |  |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0 | 0 |  |  | 634 | HVAC |  | 2867C | EASTSIDE HEATING |  | 0.1447178002894356 | 400
 | 636 | Light Fixtures |  | 3923Q | FOUNTAIN VALLEY ELECTRICAL |  | 0.01356729377713459 | 37.5 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.07091172214182344 | 196 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.03654124457308249 | 101 |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.03654124457308249 | 101
 | 641 | Insulation |  | 83884 | [NAME] / INSULATIONS,   INC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0 |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0
 | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.06512301013024602 | 180 |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.052821997105644 | 146 |  |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0 |  |  | 643 | Countertops - Laminate |  | 42143 | THE  TOP  SHOP  INC |  | 0.05788712011577424 | 160
 | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215 |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215 |  |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.0658465991316932 | 182 |  |  | 644 | Finish Carpentry |  | 70442 | BMC  WEST CORPORATION |  | 0.07778581765557163 | 215
 | 646 | Paint |  | 6470S | JUST DETAILS PAINTING |  | 0.07235890014471781 | 200 |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1085383502170767 | 300 |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1085383502170767 | 300 |  |  | 646 | Paint |  | 4570S | ILLUSIONS  PAINTING |  | 0.1083574529667149 | 299.5
 | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2767727930535456 | 765 |  |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.178726483357453 | 494 |  |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.1534008683068017 | 424 |  |  | 648 | Cabinets |  | 37994 | MASCO  CABINETRY   LLC |  | 0.2445730824891461 | 676
 | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05969609261939219 | 165 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05571635311143271 | 154 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.04920405209840811 | 136 |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.05065123010130246 | 140
 | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0 |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0
 | 743 | Drywall |  | 5738W | EL PASO  DRYWALL |  | 0.1628075253256151 | 450 |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2329956584659914 | 644 |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.2329956584659914 | 644 |  |  | 743 | Drywall |  | 3443C | HORIZON  DRYWALL   INC  68 |  | 0.2677279305354559 | 740
 | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.4822720694645442 | 1333 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.6403762662807525 | 1770 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5586107091172214 | 1544 |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0.5586107091172214 | 1544
Total |  |  |  |  |  |  | 2.789254703328509 | 7709.5 |  | Total |  |  |  |  |  |  | 2.613603473227207 | 7224 |  | Total |  |  |  |  |  |  | 2.589743125904486 | 7158.05 |  | Total |  |  |  |  |  |  | 2.168415340086831 | 5993.5
bla0700-703 Total |  |  |  |  |  |  | 2.789254703328509 | 7709.5 |  | gva0700-703 Total |  |  |  |  |  |  | 2.613603473227207 | 7224 |  | mda0800-703 Total |  |  |  |  |  |  | 2.589743125904486 | 7158.05 |  | tra0800-703 Total |  |  |  |  |  |  | 2.168415340086831 | 5993.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost Calculation |  | Tieout Report-mda08FIX008-3/5/2013-10:32:42 AM |  |  |  | Created By | [NAME] #3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Community |  | mda0800 | Ranch House at The Meadows (mda0800) |  |  | Tax Amount | 5.10%
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Model |  | mda0800-706 | Pinehurst (mda0800-706) |  |  | [NAME] | 2588
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option ID |  | Description
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category ID | Category Name |  | Vendor ID | [NAME] |  | Sqft | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gms1 |  | Guest Master Suite #1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 020 | Building Permits |  | 73322 | TOWN OF CASTLE ROCK |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 266 | Lumber |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 267 | Wall Panels |  | 82155 | PRECISION BUILDING SYSTEMS LLC |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 502 | Windows |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 504 | Window Install |  | 37122 | MILGARD MFG COMPANY |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 538 | Trim & Doors - Material |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.1242503863987635 | 321.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 588 | Hardware |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06659582689335394 | 172.35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 620 | Framing Labor |  | 8215L | PRECISION BUILDING SYSTEMS LLC |  | 0.1352395672333848 | 350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 631 | Plumbing |  | 9326F | PARAGON  PLUMBING & HEATING  LLC   143 |  | 0.7148377125193199 | 1850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 633 | Electrical |  | 9797C | DEER CREEK ELECTRIC |  | 0.06761978361669242 | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 634 | HVAC |  | 7619C | STEEL T HEATING |  | 0.1816074188562597 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 636 | Light Fixtures |  | 7651L | ARLUN   INC |  | 0.09582689335394128 | 248
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 641 | Insulation |  | 49386 | BUILDERS INSULATION OF COLORADO  LLC |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 643 | Countertops - Laminate |  | 38800 | COLORADO COUNTERTOPS |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 644 | Finish Carpentry |  | 4227A | WEST BROTHERS CONSTRUTION      15 |  | 0.06027820710973725 | 156
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 646 | Paint |  | 3401S | CUSTOM QUALITY PAINTING |  | 0.1738794435857805 | 450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 648 | Cabinets |  | 79252 | [NAME] |  | 0.3330757341576507 | 862
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 653 | Mirrors |  | 94404 | PREMIER  GLASS  SOLUTIONS,  INC |  | 0.0463678516228748 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 659 | Flooring |  | 76514 | ARLUN   INC |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 743 | Drywall |  | 3194D | M & M  DRYWALL  GROUP      32 |  | 0.03863987635239567 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 752 | Ceramic Tile |  | 76514 | ARLUN   INC |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  | 2.038218701700155 | 5274.91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mda0800-706 Total |  |  |  |  |  |  | 2.038218701700155 | 5274.91