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

 |  |  |  |  |  |  |  |  |  |  |  | 0.24
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
3152 | Customer C | 101414 | 4mm Oriel Texture Brocade SS | 1 | 2.82 | 198.64 | 70.44 | 89.42 | 117.6578947368421 | 0 | 117.6578947368421 | 6.768
3152 | Customer C | 101504 | 4mm Oriel Collection Canterbur | 3 | 8.46 | 580.26 | 68.59 | 191.45 | 251.9078947368421 | 0 | 251.9078947368421 | 20.304
3152 | Customer C | 101514 | 4mm Oriel Texture Canterbury | 2 | 5.64 | 397.28 | 70.44 | 178.84 | 235.3157894736842 | 0 | 235.3157894736842 | 13.536
3152 | Customer C | 500044 | Insulight(TM) | 198 | 157.75 | 8465.93 | 53.67 | 532.19 | 700.2500000000001 | 14276.75 | 14977 | 378.6
3152 | Customer C | 500045 | Insulight(TM) | 17 | 8.18 | 247.71 | 30.28 | 58.15 | 76.51315789473684 | 0 | 76.51315789473684 | 19.632
3152 | Customer C | 500144 | Insulight(TM) Protect | 88 | 42.71 | 1156.29 | 27.07 | 204.04 | 268.4736842105263 | 0 | 268.4736842105263 | 102.504
3152 | Customer C | 500145 | Insulight(TM) Protect | 4 | 2.98 | 111.02 | 37.26 | 23.55 | 30.98684210526316 | 0 | 30.98684210526316 | 7.152
3152 | Customer C | 500146 | Insulight(TM) Sun | 3 | 4.74 | 187.43 | 39.54 | 25.35 | 33.35526315789474 | 0 | 33.35526315789474 | 11.376
3152 | Customer C | 500148 | Insulight(TM) | 3 | 2.99 | 104.65 | 35 | 23.26 | 30.60526315789474 | 0 | 30.60526315789474 | 7.176
3152 | Customer C | 500166 | Insulight(TM) Protect | 1 | 1.48 | 70.97 | 47.95 | 8.1 | 10.6578947368421 | 0 | 10.6578947368421 | 3.552
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 17 | 7.75 | 373.84 | 48.24 | 10.05 | 13.22368421052632 | 14.18 | 27.40368421052631 | 18.6
3152 | Customer C | 500265 | Insulight(TM) Protect | 40 | 28.58 | 1624.77 | 56.85 | 59.85 | 78.75 | 0 | 78.75 | 68.592
3152 | Customer C | 500280 | Insulight(TM) Protect | 6 | 3.17 | 111.08 | 35.04 | 11.29 | 14.85526315789474 | 0 | 14.85526315789474 | 7.608
3152 | Customer C | 500281 | Insulight(TM) Protect | 3 | 2.1 | 135.72 | 64.63 | 15.59 | 20.51315789473684 | 0 | 20.51315789473684 | 5.04
3152 | Customer C | 500292 | Insulight(TM) Sun | 1 | 0.68 | 42.42 | 62.38 | 4.05 | 5.328947368421052 | 0 | 5.328947368421052 | 1.632
3152 | Customer C | 504044 | Insulight(TM) Triple | 1 | 0.34 | 17.34 | 51 | 2.3 | 3.026315789473684 | 0 | 3.026315789473684 | 0.8160000000000001
3152 | Customer C | 512247 | energiKare(TM) | 6 | 4.42 | 251.25 | 56.84 | 23.33 | 30.69736842105263 | 0 | 30.69736842105263 | 10.608
3152 | Customer C | 512272 | energiKare(TM) | 1 | 0.78 | 40.06 | 51.36 | 8.66 | 11.39473684210526 | 0 | 11.39473684210526 | 1.872
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 1719.85 | 0 | 0 | 0 | 0 | 0 | 0
5212 | Customer D | 500044 | Insulight(TM) | 115 | 143.67 | 8099.7 | 56.38 | 0 | 0 | 2988.03 | 2988.03 | 344.8079999999999
5212 | Customer D | 500166 | Insulight(TM) Protect | 90 | 117.92 | 8171.25 | 69.29 | 0 | 0 | 2896.32 | 2896.32 | 283.008
5212 | Customer D | 512147 | energiKare(TM) | 7 | 3.99 | 201.54 | 50.51 | 30.42 | 40.02631578947368 | 0 | 40.02631578947368 | 9.576
5212 | Customer D | 530169 | Insulight(TM) Therm | 32 | 23.09 | 1360.08 | 58.9 | 0 | 0 | 678.62 | 678.62 | 55.416
5212 | Customer D | 99999999 | Energy Surcharge | 0 | 0 | 2256.13 | 0 | 0 | 0 | 0 | 0 | 0