Spreadsheet: 716555d1612269289-index-match-and-if-table-roof-cost-sheet
Sheet: Sheet1

 | Gable
 | Poly (Opal,Clear,Bronze)
 |  |  |  |  |  |  |  | [NAME]
 |  | 6000 | 5750 | 5500 | 5250 | 5000 | 4750 | 4500 | 4250 | 4000 | 3750 | 3500 | 3250 | 3000 |  |  |  |  |  |  | [NAME] |  | Colour
 | 6000 | 3485 | 3346 | 3207 | 3072 | 2933 | 2832 | 2736 | 2636 | 2535 | 2434 | 2333 | 2237 | 2136 |  |  | [NAME] | Depth
 | 5750 | 3351 | 3216 | 3087 | 2952 | 2823 | 2727 | 2631 | 2535 | 2439 | 2343 | 2247 | 2151 | 2055 |  |  | 6000 | 6000 |  |  | select |  | Select
 | 5500 | 3216 | 3087 | 2962 | 2837 | 2708 | 2616 | 2525 | 2434 | 2338 | 2247 | 2156 | 2064 | 1973 |  |  |  |  |  |  | Opal |  | Rose/White | 0.05
 | 5250 | 3082 | 2962 | 2837 | 2717 | 2597 | 2506 | 2420 | 2333 | 2242 | 2156 | 2064 | 1978 | 1892 |  | Roof spec | Opal |  |  |  | Clear |  | Rose | 0.1
 | 5000 | 2948 | 2832 | 2717 | 2597 | 2482 | 2400 | 2314 | 2228 | 2146 | 2060 | 1978 | 1892 | 1810 |  |  |  |  |  |  | [NAME] |  | Grey/White | 0.15
 | 4750 | 2818 | 2708 | 2597 | 2487 | 2376 | 2295 | 2213 | 2132 | 2055 | 1973 | 1892 | 1810 | 1728 |  | Colour | Select |  |  |  | [NAME] |  | Grey | 0.2
 | 4500 | 2688 | 2583 | 2477 | 2372 | 2266 | 2189 | 2112 | 2036 | 1959 | 1882 | 1805 | 1728 | 1652 |  |  |  |  |  |  | DG Unit
Depth | 4250 | 2599 | 2458 | 2357 | 2256 | 2160 | 2084 | 2012 | 1940 | 1868 | 1796 | 1719 | 1647 | 1575
 | 4000 | 2429 | 2333 | 2237 | 2146 | 2050 | 1983 | 1911 | 1844 | 1776 | 1704 | 1637 | 1565 | 1498 |  | Price
 | 3750 | 2271 | 2184 | 2093 | 2007 | 1920 | 1853 | 1791 | 1724 | 1661 | 1594 | 1532 | 1464 | 1402
 | 3500 | 2117 | 2036 | 1954 | 1872 | 1791 | 1728 | 1666 | 1608 | 1546 | 1484 | 1426 | 1364 | 1306
 | 3250 | 1959 | 1882 | 1810 | 1733 | 1656 | 1604 | 1546 | 1488 | 1431 | 1378 | 1320 | 1263 | 1205 |  | Price to be determined based on width & depth, Roof spec & colour.
 | 3000 | 1824 | 1752 | 1685 | 1613 | 1546 | 1493 | 1440 | 1388 | 1335 | 1282 | 1234 | 1181 | 1128
 | 2750 | 1685 | 1623 | 1560 | 1498 | 1436 | 1388 | 1340 | 1287 | 1239 | 1191 | 1143 | 1095 | 1047
 | 2500 | 1551 | 1493 | 1436 | 1378 | 1320 | 1277 | 1234 | 1191 | 1143 | 1100 | 1056 | 1013 | 970
 | Gable
 | Poly ([NAME])
 |  | 6000 | 5750 | 5500 | 5250 | 5000 | 4750 | 4500 | 4250 | 4000 | 3750 | 3500 | 3250 | 3000
 | 6000
 | 5750
 | 5500
 | 5250
 | 5000
 | 4750
 | 4500
 | 4250
 | 4000
 | 3750
 | 3500
 | 3250
 | 3000
 | 2750
 | 2500
 | Gable
 | DG Unit (SMARTGLAS Plus+)
 |  | 6000 | 5750 | 5500 | 5250 | 5000 | 4750 | 4500 | 4250 | 4000 | 3750 | 3500 | 3250 | 3000
 | 6000 | 5975 | 5640 | 5305 | 4970 | 4635 | 4435 | 4240 | 4040 | 3840 | 3670 | 3495 | 3325 | 3150
 | 5750 | 5745 | 5420 | 5100 | 4775 | 4455 | 4260 | 4070 | 3880 | 3685 | 3520 | 3355 | 3190 | 3025
 | 5500 | 5510 | 5200 | 4890 | 4580 | 4270 | 4085 | 3905 | 3720 | 3535 | 3375 | 3215 | 3055 | 2895
 | 5250 | 5280 | 4980 | 4685 | 4385 | 4090 | 3910 | 3735 | 3560 | 3380 | 3230 | 3075 | 2925 | 2770
 | 5000 | 5045 | 4760 | 4475 | 4190 | 3905 | 3735 | 3565 | 3400 | 3230 | 3080 | 2935 | 2790 | 2645
 | 4750 | 4825 | 4555 | 4280 | 4010 | 3735 | 3575 | 3415 | 3250 | 3090 | 2950 | 2810 | 2670 | 2530
 | 4500 | 4605 | 4350 | 4090 | 3830 | 3570 | 3415 | 3260 | 3105 | 2950 | 2815 | 2685 | 2550 | 2415
 | 4250 | 4390 | 4140 | 3895 | 3645 | 3400 | 3250 | 3105 | 2960 | 2810 | 2685 | 2555 | 2430 | 2305
 | 4000 | 4170 | 3935 | 3700 | 3465 | 3230 | 3090 | 2950 | 2810 | 2670 | 2550 | 2430 | 2310 | 2190
 | 3750 | 3930 | 3705 | 3485 | 3265 | 3045 | 2915 | 2780 | 2650 | 2520 | 2405 | 2290 | 2175 | 2060
 | 3500 | 3685 | 3480 | 3275 | 3065 | 2860 | 2735 | 2610 | 2490 | 2365 | 2255 | 2150 | 2040 | 1935
 | 3250 | 3445 | 3250 | 3060 | 2865 | 2675 | 2560 | 2440 | 2325 | 2210 | 2110 | 2010 | 1910 | 1805
 | 3000 | 3215 | 3035 | 2860 | 2680 | 2500 | 2395 | 2285 | 2175 | 2070 | 1975 | 1880 | 1785 | 1690
 | 2750 | 2985 | 2820 | 2660 | 2495 | 2330 | 2230 | 2130 | 2025 | 1925 | 1840 | 1750 | 1665 | 1575
 | 2500 | 2760 | 2605 | 2455 | 2305 | 2155 | 2065 | 1970 | 1880 | 1785 | 1705 | 1625 | 1545 | 1460