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

 |  |  | Building Permits | Lumber | Wall Panels | Windows | Window Install | Trim & Doors - Material | Hardware | Framing Labor | Plumbing | Electrical | HVAC | Light Fixtures | Insulation | Countertops - Laminate | Finish Carpentry | Paint | Cabinets | Mirrors | Flooring | Drywall | Ceramic Tile | 0 | 0 | 0 | 0
 | Model ID | Option Name | 020 | 266 | 267 | 502 | 504 | 538 | 588 | 620 | 631 | 633 | 634 | 636 | 641 | 643 | 644 | 646 | 648 | 653 | 659 | 743 | 752 | 0 | 0 | 0 | 0 | Total
1 | bla0700-701 | Guest Master Suite #1 | 0 | 295 | 353 | 0 | 0 | 290 | 110 | 350 | 1850 | 500 | 470 | 27.5 | 0 | 180 | 105 | 200 | 765 | 165 | 0 | 575 | 1149 | 0 | 0 | 0 | 0 | 7384.5
2 | gva0700-701 | Guest Master Suite #1 | 0 | 162 | 283 | 0 | 0 | 290 | 110 | 350 | 1200 | 445 | 400 | 234 | 0 | 146 | 105 | 300 | 766 | 154 | 0 | 476 | 1770 | 0 | 0 | 0 | 0 | 7191
3 | mda0800-702 | Guest Master Suite #1 | 0 | 301 | 448 | 0 | 0 | 386.6 | 152.62 | 350 | 1850 | 265 | 470 | 122 | 0 | 0 | 162 | 300 | 396 | 120 | 0 | 476 | 1212 | 0 | 0 | 0 | 0 | 7011.219999999999
4 | tra0800-701 | Guest Master Suite #1 | 0 | 162 | 353 | 0 | 0 | 290 | 110 | 350 | 0 | 325 | 400 | 108 | 0 | 160 | 105 | 627.88 | 676 | 140 | 0 | 594 | 1212 | 0 | 0 | 0 | 0 | 5612.88
5 | bla0700-702 | Guest Master Suite #1 | 0 | 301 | 448 | 0 | 0 | 290 | 95 | 350 | 1850 | 500 | 470 | 37.5 | 0 | 148 | 105 | 200 | 741 | 165 | 0 | 750 | 1196 | 0 | 0 | 0 | 0 | 7646.5
6 | gva0700-702 | Guest Master Suite #1 | 0 | 0 | 386 | 0 | 0 | 290 | 95 | 350 | 1200 | 445 | 400 | 196 | 0 | 128 | 105 | 300 | 766 | 143 | 0 | 476 | 1770 | 0 | 0 | 0 | 0 | 7050
7 | tra0800-702 | Guest Master Suite #1 | 0 | 162 | 448 | 0 | 0 | 290 | 95 | 350 | 0 | 325 | 400 | 185 | 0 | 128 | 105 | 811.66 | 657 | 95 | 0 | 629 | 1212 | 0 | 0 | 0 | 0 | 5892.66
8 | bla0700-703 | Guest Master Suite #1 | 0 | 313 | 376 | 0 | 0 | 375 | 130 | 350 | 1850 | 500 | 470 | 37.5 | 0 | 180 | 215 | 200 | 765 | 165 | 0 | 450 | 1333 | 0 | 0 | 0 | 0 | 7709.5
9 | gva0700-703 | Guest Master Suite #1 | 0 | 0 | 405 | 0 | 0 | 375 | 130 | 350 | 1200 | 445 | 400 | 196 | 0 | 146 | 215 | 300 | 494 | 154 | 0 | 644 | 1770 | 0 | 0 | 0 | 0 | 7224
10 | mda0800-703 | Guest Master Suite #1 | 0 | 313 | 376 | 0 | 0 | 475.51 | 197.54 | 350 | 1850 | 265 | 0 | 101 | 0 | 0 | 182 | 300 | 424 | 136 | 0 | 644 | 1544 | 0 | 0 | 0 | 0 | 7158.05
11 | tra0800-703 | Guest Master Suite #1 | 0 | 162 | 376 | 0 | 0 | 375 | 130 | 350 | 0 | 325 | 400 | 101 | 0 | 160 | 215 | 299.5 | 676 | 140 | 0 | 740 | 1544 | 0 | 0 | 0 | 0 | 5993.5
12 | mda0800-706 | Guest Master Suite #1 | 0 | 0 | 0 | 0 | 0 | 321.56 | 172.35 | 350 | 1850 | 175 | 470 | 248 | 0 | 0 | 156 | 450 | 862 | 120 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 5274.91
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Average: | #N/A | 241.2222222222222 | 386.5454545454546 | #N/A | #N/A | 337.3891666666667 | 127.2925 | 350 | 1633.333333333333 | 376.25 | 431.8181818181818 | 132.7916666666667 | #N/A | 152.8888888888889 | 147.9166666666667 | 357.42 | 665.6666666666666 | 141.4166666666667 | #N/A | 546.1666666666666 | 1428.363636363636 | #N/A | #N/A | #N/A | #N/A
 |  | Min | 0 | 162 | 283 | 0 | 0 | 290 | 95 | 350 | 1200 | 175 | 400 | 27.5 | 0 | 128 | 105 | 200 | 396 | 95 | 0 | 100 | 1149 | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 313 | 448 | 0 | 0 | 475.51 | 197.54 | 350 | 1850 | 500 | 470 | 248 | 0 | 180 | 215 | 811.66 | 862 | 165 | 0 | 750 | 1770 | 0 | 0 | 0 | 0