Spreadsheet: 139144d1328104730-excel-2007-sorting-groups-by-date-using-the-year-bid-summary-edit
Sheet: MAT FACTORS

 | MATERIAL | CONEST | QUOTED | QUOTE | FACTOR
 | [NAME] | COST | COST | DATE | X
 | 1/2" EMT | 0.16 | 0.1769 | 2011-10-06 00:00:00 |  |  | DUPLEX | 0.3 | 0.09 | 0.5
 | 3/4" EMT | 0.28 | 0.3683 | 2011-10-06 00:00:00 |  |  | GFI | 0.3 | 0.09 | 0.5
 | 1" EMT | 0.5 | 0.6271 | 2011-10-06 00:00:00
 | 1-1/4" EMT | 0.71 | 1.0083 | 2011-10-06 00:00:00 |  |  | EMT Hangers(pneum. Guns) |  |  | 0.5
 | 1-1/2" EMT | 0.87 | 1.2349 | 2011-10-06 00:00:00
 | 2" EMT | 1.07 | 1.4859 | 2011-10-06 00:00:00
 | 2-1/2" EMT | 1.63 | 2.5986 | 2011-10-06 00:00:00
 | 3" EMT | 2.05 | 3.2966 | 2011-10-06 00:00:00
 | 3-1/2" EMT | 2.9 | 4.6118 | 2011-10-06 00:00:00
 | 4" EMT | 3.33 | 4.6778 | 2011-10-06 00:00:00
 | 1/2" GRC | 0.64 | 1.3629 | 2011-10-06 00:00:00
 | 3/4" GRC | 0.79 | 1.4104 | 2011-10-06 00:00:00
 | 1" GRC | 1.2 | 2.1602 | 2011-10-06 00:00:00
 | 1-1/4" GRC | 1.62 | 3.0546 | 2011-10-06 00:00:00
 | 1-1/2" GRC | 1.9 | 3.63 | 2011-10-06 00:00:00
 | 2" GRC | 2.53 | 4.3201 | 2011-10-06 00:00:00
 | 2-1/2" GRC | 4.6 | 8.194 | 2011-10-06 00:00:00
 | 3" GRC | 5.65 | 9.8699 | 2011-10-06 00:00:00
 | 3-1/2" GRC | 6.7 | 12.8789 | 2011-10-06 00:00:00
 | 4" GRC | 7.8 | 13.1596 | 2011-10-06 00:00:00
 | 5" GRC | 12.62 | 27.1418 | 2011-10-06 00:00:00
 | 6" GRC | 17.8 | 39.4644 | 2011-10-06 00:00:00
 | 1" PVC SCH 40 | 0.21 | 0.2554 | 2011-10-06 00:00:00
 | 1-1/2" PVC SCH 40 | 0.35 | 0.4089 | 2011-10-06 00:00:00
 | 2" PVC SCH 40 | 0.45 | 0.5089 | 2011-10-06 00:00:00
 | 2-1/2" PVC SCH 40 | 0.73 | 0.8738 | 2011-10-06 00:00:00
 | 3" PVC SCH 40 | 0.91 | 1.0506 | 2011-10-06 00:00:00
 | 3-1/2" PVC SCH 40 | 1.15 | 1.3565 | 2011-10-06 00:00:00
 | 4" PVC SCH 40 | 1.3 | 1.4655 | 2011-10-06 00:00:00
 | 5" PVC SCH 40 | 1.84 | 2.0798 | 2011-10-06 00:00:00
 | 6" PVC SCH 40 | 2.4 | 2.7292 | 2011-10-06 00:00:00
 | 1" PVC SCH 80 |  | 0.320114 | 2011-03-10 00:00:00
 | 1-1/2" PVC SCH 80 |  | 0.494318 | 2011-03-10 00:00:00
 | 2" PVC SCH 80 |  | 0.650795 | 2011-03-10 00:00:00
 | 2-1/2" PVC SCH 80 |  | 1.042841 | 2011-03-10 00:00:00
 | 3" PVC SCH 80 |  | 1.262841 | 2011-03-10 00:00:00
 | 4" PVC SCH 80 |  | 1.915682 | 2011-03-10 00:00:00
 |  |  |  |  |  | factor for
 |  |  |  | Anixter |  | XHHW
 | #12 THHN | 0.09 | 0.12166 | 2012-01-18 00:00:00
 | #10 THHN | 0.15 | 0.18799 | 2012-01-18 00:00:00
 | #8 THHN | 0.24 | 0.28396 | 2012-01-18 00:00:00
 | #6 THHN | 0.33 | 0.43689 | 2012-01-18 00:00:00
 | #4 THHN | 0.51 | 0.68814 | 2012-01-18 00:00:00
 | #3 THHN | 0.64 | 0.86867 | 2012-01-18 00:00:00
 | #2 THHN | 0.78 | 1.08729 | 2012-01-18 00:00:00
 | #1 THHN | 1 | 1.42888 | 2012-01-18 00:00:00
 | #1/0 THHN | 1.135 | 1.73186 | 2012-01-18 00:00:00
 | #2/0 THHN | 1.55 | 2.17095 | 2012-01-18 00:00:00
 | #3/0 THHN | 1.775 | 2.72347 | 2012-01-18 00:00:00
 | #4/0 THHN | 2.25 | 3.42005 | 2012-01-18 00:00:00
 | #250 THHN | 2.6 | 4.05625 | 2012-01-18 00:00:00
 | #300 THHN | 3.35 | 4.83986 | 2012-01-18 00:00:00
 | #350 THHN | 3.6 | 5.667 | 2012-01-18 00:00:00
 | #400 THHN | 4.2 | 6.45002 | 2012-01-18 00:00:00
 | #500 THHN | 5.1 | 8.02548 | 2012-01-18 00:00:00
 | #600 THHN | 6.15 | 10.35804 | 2012-01-18 00:00:00
 | #750 THHN | 8.8 | 17.44158 | 2012-01-18 00:00:00
 |  |  |  | Anixter
 | #8 XHHW | 0.32061 | 0.32292 | 2011-12-12 00:00:00
 | #6 XHHW | 0.49329 | 0.49685 | 2011-12-12 00:00:00
 | #4 XHHW | 0.59 | 0.78258 | 2011-12-12 00:00:00
 | #3 XHHW | 0.71 | 0.98527 | 2011-12-12 00:00:00
 | #2 XHHW | 0.89 | 1.23652 | 2011-12-12 00:00:00
 | #1 XHHW | 1.2 | 1.54872 | 2011-12-12 00:00:00
 | #1/0 XHHW | 1.4 | 1.91651 | 2011-12-12 00:00:00
 | #2/0 XHHW | 1.71 | 2.40242 | 2011-12-12 00:00:00
 | #3/0 XHHW | 2.26 | 3.01387 | 2011-12-12 00:00:00
 | #4/0 XHHW | 2.68 | 3.74933 | 2011-12-12 00:00:00
 | #250 XHHW | 3.5 | 4.44677 | 2011-12-12 00:00:00
 | #300 XHHW | 4.16 | 5.33086 | 2011-12-12 00:00:00
 | #350 XHHW | 4.72 | 6.08368 | 2011-12-12 00:00:00
 | #400 XHHW | 5.09 | 7.10439 | 2011-12-12 00:00:00
 | #500 XHHW | 6.01 | 8.49108 | 2011-12-12 00:00:00
 | #600 XHHW | 8.13 | 11.00235 | 2011-12-12 00:00:00
 | #750 XHHW | 10.66 | 18.52653 | 2011-12-12 00:00:00
 | #6 XHHW or THHN AL | 0.2 | 0.14225 | 2011-10-04 00:00:00
 | #4 XHHW | 0.26 | 0.17579 | 2011-10-04 00:00:00
 | #3 XHHW
 | #2 XHHW | 0.36 | 0.23877 | 2011-10-04 00:00:00
 | #1 XHHW | 0.52 | 0.34886 | 2011-10-04 00:00:00
 | #1/0 XHHW | 0.61 | 0.41862 | 2011-10-04 00:00:00
 | #2/0 XHHW | 0.71 | 0.49517 | 2011-10-04 00:00:00
 | #3/0 XHHW | 0.88 | 0.61473 | 2011-10-04 00:00:00
 | #4/0 XHHW | 1 | 0.68314 | 2011-10-04 00:00:00
 | #250 XHHW | 1.18 | 0.83386 | 2011-10-04 00:00:00
 | #300 XHHW | 1.62 | 1.204307 | 2011-03-10 00:00:00
 | #350 XHHW | 1.68 | 1.17119 | 2011-10-04 00:00:00
 | #400 XHHW | 1.93 | 1.36932 | 2011-10-04 00:00:00
 | #500 XHHW | 2.16 | 1.51023 | 2011-10-04 00:00:00
 | #600 XHHW | 2.72 | 1.91361 | 2011-10-04 00:00:00
 | #750 XHHW | 3.3 | 2.23231 | 2011-10-04 00:00:00
 | #900 XHHW |  | 3.202795 | 2011-03-10 00:00:00
 | #1000 XHHW |  | 3.474034 | 2011-03-10 00:00:00
 | #14/2 FA MC | 0.36 | 0.40909 | 2011-03-10 00:00:00
 | #14/2 FA MC SHIELDED | 0.36 | 0.738636 | 2011-03-10 00:00:00
 | #14/4 FA MC | 0.66 | 0.653409 | 2011-03-10 00:00:00
 | #14/4 FA MC SHIELDED | 0.66 | 1.284091 | 2011-03-10 00:00:00 |  | A B loop reqrd for high rise
 | MC Cable
 | 12/2 MC | 0.35 | 0.45124 | 2011-12-12 00:00:00
 | 12/3 MC |  | 0.76568 | 2011-03-10 00:00:00
 | 12/4 MC | 0.67 | 1.03261 | 2011-12-12 00:00:00
 | 12/6 MC |  | 1.084783 | 2011-06-16 00:00:00
 | 10/2 MC | 0.6 | 0.94794 | 2011-12-12 00:00:00
 | 10/3 MC | 0.9 | 1.32406 | 2011-12-12 00:00:00
 | 10/4 MC | 1.39 | 2.07237 | 2011-12-12 00:00:00
 | 10/6 MC |  | 2.057609 | 2011-06-16 00:00:00
 | 8/3 MC |  | 1.613176 | 2011-03-10 00:00:00
 | 8/4 MC |  | 2.088235 | 2011-03-10 00:00:00
 | 6/3 MC |  | 2.352941 | 2011-03-10 00:00:00
 | 6/4 MC |  | 2.992235 | 2011-03-10 00:00:00
 | 4/3 MC |  | 3.482353 | 2011-03-10 00:00:00
 | 4/4 MC |  | 4.408118 | 2011-03-10 00:00:00
 | 3/3 MC |  | 4.282353 | 2011-03-10 00:00:00
 | 3/4 MC |  | 5.330471 | 2011-03-10 00:00:00
 | 2/3 MC |  | 5.193294 | 2011-03-10 00:00:00
 | 2/4 MC |  | 6.706118 | 2011-03-10 00:00:00
 | 1/3 MC |  | 6.164706 | 2011-03-10 00:00:00
 | 1/4 MC |  | 8.300353 | 2011-03-10 00:00:00
 | HOSPITAL GRADE BX neutral for each conductor
12/2 BX | 12/2 MC STAT | 0.41 | 0.729 | 2011-03-10 00:00:00
12/4 BX | 12/2 12/2 12/1 MC STAT | 0.83 | 1.223529 | 2011-03-10 00:00:00
10/4 BX | 12/3 12/3 12/1 MC STAT | 1.51 | 1.358824 | 2011-03-10 00:00:00
 | AL MC Feeders
 | 1/0-4 AL MC |  | 3.194828 | 2011-10-28 00:00:00
 | 2/0-4 AL MC |  | 3.574103 | 2011-10-28 00:00:00
 | 3/0-4 AL MC |  | 4.446678 | 2011-10-28 00:00:00
 | 4/0-4 AL MC |  | 4.968989 | 2011-10-28 00:00:00
 | 250-4 AL MC |  | 6.911092 | 2011-10-28 00:00:00
 | 300-4 AL MC |  | 7.41054 | 2011-10-28 00:00:00
 | 350-4 AL MC |  | 8.458092 | 2011-10-28 00:00:00
 | 400-4 AL MC |  | 9.589759 | 2011-10-28 00:00:00
 | 500-4 AL MC |  | 10.276793 | 2011-10-28 00:00:00
 | 600-4 AL MC |  | 12.837345 | 2011-10-28 00:00:00
 | 750-4 AL MC |  | 14.33569 | 2011-10-28 00:00:00