Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: October2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.24
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
304 | Customer B | 112404 | 4mm Textured Florielle | 2 | 0.58 | 10.16 | 17.52 | 3.22 | 4.236842105263158 | 0 | 4.236842105263158 | 1.392
304 | Customer B | 302404 | 4mm Textured Florielle T | 2 | 0.6 | 15 | 25 | 3.22 | 4.236842105263158 | 0 | 4.236842105263158 | 1.44
304 | Customer B | 304004 | 4mm Textured Stippolyte T | 1 | 1.18 | 29.5 | 25 | 4.8 | 6.315789473684211 | 0 | 6.315789473684211 | 2.832
304 | Customer B | 500044 | Insulight(TM) | 42 | 26.5 | 410.82 | 15.5 | 115.61 | 152.1184210526316 | 0 | 152.1184210526316 | 63.59999999999999
304 | Customer B | 500045 | Insulight(TM) | 17 | 7.81 | 175.95 | 22.53 | 59.38 | 78.13157894736842 | 0 | 78.13157894736842 | 18.744
304 | Customer B | 500144 | Insulight(TM) Protect | 26 | 27.14 | 686.4 | 25.29 | 127 | 167.1052631578947 | 0 | 167.1052631578947 | 65.136
304 | Customer B | 500145 | Insulight(TM) Protect | 4 | 1.67 | 47.61 | 28.51 | 14.47 | 19.03947368421053 | 0 | 19.03947368421053 | 4.008
304 | Customer B | 500166 | Insulight(TM) Protect | 2 | 5.38 | 338.94 | 63 | 25.74 | 33.86842105263158 | 0 | 33.86842105263158 | 12.912
304 | Customer B | 512047 | energiKare(TM) | 3 | 1.24 | 39.34 | 31.73 | 11.76 | 15.47368421052632 | 0 | 15.47368421052632 | 2.976
304 | Customer B | 512084 | energiKare(TM) | 454 | 214.34 | 3673.97 | 17.14 | 1462.14 | 1923.868421052632 | 25.5 | 1949.368421052632 | 514.4159999999999
304 | Customer B | 512147 | energiKare(TM) | 4 | 5.04 | 128.52 | 25.5 | 33.18 | 43.6578947368421 | 0 | 43.6578947368421 | 12.096
304 | Customer B | 512484 | energiKare(TM) | 198 | 154.87 | 3969.56 | 25.63 | 1115.27 | 1467.460526315789 | 0 | 1467.460526315789 | 371.688
304 | Customer B | 530047 | Insulight(TM) Therm | 3 | 1.97 | 32.51 | 16.5 | 14.01 | 18.43421052631579 | 0 | 18.43421052631579 | 4.728
304 | Customer B | 530049 | Insulight(TM) [NAME] | 83 | 30.76 | 722.64 | 23.49 | 264.78 | 348.3947368421052 | 0 | 348.3947368421052 | 73.824
304 | Customer B | 530149 | Insulight(TM) [NAME] | 59 | 30.99 | 965.81 | 31.17 | 320.25 | 421.3815789473684 | 0 | 421.3815789473684 | 74.37599999999999
304 | Customer B | 530169 | Insulight(TM) Therm | 1 | 2.81 | 158.77 | 56.5 | 26.12 | 34.36842105263158 | 0 | 34.36842105263158 | 6.744
304 | Customer B | 540047 | Insulight(TM) | 6 | 3.9 | 126.78 | 32.51 | 46.38 | 61.02631578947368 | 0 | 61.02631578947368 | 9.36
304 | Customer B | 540048 | Insulight(TM) [NAME] | 1 | 0.59 | 0 | 0 | 6.85 | 9.01315789473684 | 0 | 9.01315789473684 | 1.416
304 | Customer B | 540148 | Insulight(TM) [NAME] | 1 | 0.76 | 0 | 0 | 8.52 | 11.21052631578947 | 0 | 11.21052631578947 | 1.824
304 | Customer B | 99999999 | Energy Surcharge | 0 | 0 | 2316.5 | 0 | 0 | 0 | 0 | 0 | 0
3152 | Customer C | 101414 | 4mm Oriel Texture Brocade SS | 1 | 2.82 | 198.64 | 70.44 | 100.17 | 131.8026315789474 | 0 | 131.8026315789474 | 6.768
3152 | Customer C | 102604 | 4mm Oriel Collection Laurel st | 3 | 8.46 | 580.26 | 68.59 | 214.97 | 282.8552631578947 | 0 | 282.8552631578947 | 20.304
3152 | Customer C | 500044 | Insulight(TM) | 185 | 111.5 | 2114 | 18.96 | 494.14 | 650.1842105263157 | 0 | 650.1842105263157 | 267.6
3152 | Customer C | 500045 | Insulight(TM) | 18 | 8.68 | 244.96 | 28.22 | 61.53 | 80.96052631578948 | 0 | 80.96052631578948 | 20.832
3152 | Customer C | 500066 | Insulight(TM) | 1 | 5.39 | 512.05 | 95 | 0 | 0 | 1053.26 | 1053.26 | 12.936
3152 | Customer C | 500144 | Insulight(TM) Protect | 71 | 28.83 | 791.08 | 27.44 | 132.87 | 174.8289473684211 | 0 | 174.8289473684211 | 69.192
3152 | Customer C | 500145 | Insulight(TM) Protect | 8 | 2.91 | 103.53 | 35.58 | 20.68 | 27.21052631578947 | 0 | 27.21052631578947 | 6.984
3152 | Customer C | 500166 | Insulight(TM) Protect | 2 | 0.7 | 36.36 | 51.94 | 5.37 | 7.065789473684211 | 0 | 7.065789473684211 | 1.68
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 12 | 9.29 | 433.68 | 46.68 | 11.84 | 15.57894736842105 | 20.34 | 35.91894736842105 | 22.296
3152 | Customer C | 500265 | Insulight(TM) Protect | 8 | 7.03 | 281.66 | 40.07 | 8.6 | 11.31578947368421 | 0 | 11.31578947368421 | 16.872
3152 | Customer C | 500280 | Insulight(TM) Protect | 4 | 3.49 | 217.71 | 62.38 | 21.32 | 28.05263157894737 | 0 | 28.05263157894737 | 8.376
3152 | Customer C | 500281 | Insulight(TM) Protect | 1 | 0.6 | 27 | 45 | 0.58 | 0.763157894736842 | 0 | 0.763157894736842 | 1.44
3152 | Customer C | 500290 | Insulight(TM) Protect | 2 | 2.03 | 112.16 | 55.25 | 25.72 | 33.84210526315789 | 0 | 33.84210526315789 | 4.871999999999999
3152 | Customer C | 512247 | energiKare(TM) | 1 | 0.63 | 31.18 | 49.49 | 3.15 | 4.144736842105263 | 0 | 4.144736842105263 | 1.512
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 944.33 | 0 | 0 | 0 | 0 | 0 | 0