Spreadsheet: 52893d1252698839-how-to-print-updated-information-order_example
Sheet: Sheet3

MFR | MFR PART # | OQP PART # | [NAME] | COLOR | QTY | UNIT | EXTENED
 |  |  |  |  |  | PRICE | PRICE
Customer: | Vendor Total
 |  |  |  |  |  |  | 0
Air Supply | 6320220 | 0 | 2HP Silencer |  | 0 | 98.95
 |  |  |  |  | 0 |  | 0
 |  |  | Subtotal |  |  |  | 0
 |  |  | Carecraft 2% |  |  |  | 0
Enter 1 in B Col | 0 |  | Carecraft Processing |  |  | -
 |  |  | Freight |  |  |  | 0
 |  | Total | Aqua Cal |  |  |  | 0
Not | Fire by Design |  | Remote control [NAME] |  | 0 | 1300 | 0
Carecraft |  |  |  |  | 0 | 4.38 | 0
 | Wok Pots |  | Wok Pots |  | 0 | 150 | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  | Subtotal |  |  |  | 0
 |  |  | Carecraft 2% |  |  |  | 0
Enter 1 in B Col | 0 |  | Carecraft Processing
 |  |  | Freight |  |  |  | 0
 |  | Total | 0 |  |  |  | 0
Paramount | [PHONE]-01 |  | SDX Dual Pack | White | 2 | 41.41 | 82.82
Paramount | [PHONE]-07 | 3401 | Canister w/beige deck lid | [NAME] | 1 | 250.1 | 250.1
Paramount | [PHONE]-08 |  | [NAME] for Concrete Without Sump With SDX | Lt. Gray | 1 | 73.39 | 73.39
Paramount | [PHONE]-02 |  | [NAME] for Concrete W/SDX W/Cap | Gray | 1 | 125.46 | 125.46
Paramount | [PHONE]-08 | 3403 | [NAME] for Concrete W/SDX W/Cap | [NAME] | 1 | 125.46 | 125.46
Paramount | [PHONE]-02 | 3367 | Threaded Downjet Returns | Gray | 5 | 3.98 | 19.9
Paramount | [PHONE]-08 | 3379 | Threaded Downjet Returns | Lt. Gray | 4 | 3.98 | 15.92
Paramount | [PHONE]-03 | 3406 | 6 Port Water Valve 2" Black | Black | 1 | 230.42 | 230.42
Paramount | [PHONE]-03 | 3395 | 9 Port Water Valve 2" Black | Black | 1 | 483.8 | 483.8
Paramount | [PHONE]-08 | 3375 | Bodies w/ Caps | Lt. Gray | 12 | 18.66 | 223.92
Paramount | [PHONE]-03 | 3739 | Step Bodies w / Caps | Black | 12 | 16.2 | 194.4
Paramount | [PHONE]-08 | 3377 | Step Bodies w / Caps | Lt. Gray | 14 | 16.2 | 226.8
Paramount | [PHONE]-08 | 3373 | Rotating Nozzles | Lt. Gray | 12 | 41.82 | 501.84
Paramount | [PHONE]-08 | 3374 | Fixed Nozzles | Lt. Gray | 2 | 41.82 | 83.64
Paramount | [PHONE]-02 | 50237 | PCC Step Nozzles | Gray | 11 | 29.11 | 320.21
Paramount | [PHONE]-08 | 3376 | PCC Step Nozzles | Lt. Gray | 14 | 29.11 | 407.54
Paramount | [PHONE]-00 | 3381 | PCC 2000 Nozzle Tool |  | 2 | 10.46 | 20.92
Paramount | [PHONE]-00 | 3382 | PCC 2000 Step Nozzle Tool |  | 2 | 9.43 | 18.86
Paramount | [PHONE]-00 | 3399 | Paramount Clear O3 Single |  | 2 | 282.86 | 565.72
 |  |  | Subtotal |  |  |  | 3971.12
 |  |  | Carecraft 2% |  |  |  | 79.42240000000002
 |  |  | Freight |  |  |  | 121.516272
 |  | Total | Paramount |  |  |  | 4172.058672000001
Pentair | O11515 | 298 | 2 HP Pump | 0 | 1 | 476.83 | 476.83
Pentair | O11012 | 3000 | PMP Intelliflow 3.2KW |  | 2 | 1055.56 | 2111.12
Pentair | O11013 | 3001 | Intelliflow 4 X 160 (VS 3050) |  | 1 | 743.06 | 743.06
Pentair | 600105 | 0 | IntelliBrite 12V Pool Light LED 100' |  | 2 | 399.18 | 798.36
Pentair | 640055 |  | IntelliBrite 12V SPA Light LED  100' |  | 1 | 328.83 | 328.83
Pentair | 460922 |  | 1200R H/C  Heat Pump Heat & Cool |  | 1 | 3267.11 | 3267.11
Pentair | 180009 |  | 60 SF DE Filter |  | 1 | 482.73 | 482.73
Pentair | 160301 |  | 420 Cartridge |  | 1 | 512.91 | 512.91
Pentair | 188593 | 370 | Filter Quad DE 80 |  | 1 | 572.23 | 572.23
Pentair | 261055 | 51177 | MPV - Sand |  | 1 | 92.18 | 92.18
Pentair | 261152 | 50177 | MPV |  | 2 | 92.18 | 184.36
Pentair | 460736 | 51180 | HTR 400 MasterTemp NA GAS |  | 2 | 1526.98 | 3053.96
Pentair | 460737 | 51181 | HTR 400 MasterTemp Propane |  | 1 | 1526.98 | 1526.98
Pentair | O72138 | 50620 | Pressure Relief Valve |  | 1 | 22.98 | 22.98
Pentair | 506300 | 50171 | Skimmer With White Lid |  | 6 | 60.6 | 363.6
Pentair | 520094 | 60337 | Remote 4 Func WH 150' IS4 (Spa Side) | White | 2 | 133.1 | 266.2
Pentair | 520136 | 60301 | Intellitouch Foundation LC (Enclosure Kit) |  | 1 | 322.15 | 322.15
Pentair | 520505 | 60304 | Intellitouch Personality Kit I5 Pool & Spa |  | 1 | 423.53 | 423.53
Pentair | 520138 | 60316 | Intellitouch 3.75 Mono Panel |  | 1 | 350.98 | 350.98
Pentair | 263042 | 62201 | 2" Check Valve CPVC Straight | Inv. | 4 | 22.63 | 90.52
Pentair | 263027 | 62204 | 2" 2 Way Valve CPVC |  | 16 | 27.09 | 433.44
Pentair | 263026 | 62205 | 2" 3 Way Valve CPVC |  | 2 | 29.08 | 58.16
Pentair | 77360300 | 50172 | 250 W Spa Light 100' |  | 1 | 135.14 | 135.14
Pentair | 78456300 | 50175 | 500 W Pool Light 100' |  | 4 | 149.82 | 599.28
Pentair | 79206600 | 50304 | Niche, Spa 250 W |  | 3 | 24.96 | 74.88
Pentair | 79206700 | 50303 | Niche, Pool  500 W | Inv. | 6 | 27.6 | 165.6
Pentair | LA01N | 60500 | Pump Univ Booster 3/4 HP Letro |  | 2 | 174.5 | 349
Pentair | R171096 | 50176 | Rainbow Chlorinator |  | 6 | 41.19 | 247.14
Pentair | T29 |  | Fluidmaster Valve 400 AB |  | 2 | 9.03 | 18.06
Pentair | 516112 |  | Skimmer Basket |  | 4 | 7.89 | 31.56
Pentair | 516252 |  | Skimmer Weir |  | 4 | 5.95 | 23.8
Pentair | 520704 |  | LDCNTR 8 AUX 8PSC IC20 EZTCH Pool Only W/Salt |  | 1 | 1123.78 | 1123.78
Pentair | 520547 |  | [NAME] 8 Wireless Controller |  | 1 | 376.6 | 376.6
Pentair | 581202fsg |  | MagicFalls Water Effects 24" 6" lip Gray |  | 2 | 155.69 | 311.38
 |  |  | Subtotal |  |  |  | 19938.44
 |  |  | Carecraft 2% |  |  |  | 398.7688
 |  | Total | Pentair |  |  |  | 20337.2088
[NAME] | 1-470-02 | 50290 | Polaris QT Blower, 1.5 HP |  | 1 | 128.6 | 128.6
[NAME] | F5 | 489 | [NAME] 280 |  | 2 | 338 | 676
[NAME] | FFWS18-6 |  | 18" PowerFall with 1/2" Nozzle/Lip |  | 3 | 143.64 | 430.92
 |  |  | Subtotal |  |  |  | 1235.52
 |  |  | Zodiac Discount 3% |  |  |  | 37.0656
 |  |  | Subtotal |  |  |  | 1198.4544
 |  |  | Carecraft 2% |  |  |  | 23.969088
 |  |  | Freight |  |  |  | 73.34540928
 |  | Total | [NAME] |  |  |  | 1295.76889728
Waterpik | 4716 | 50161 | 2" 2 Way Valve |  | 7 | 29.66 | 207.62
Waterpik | 4717 | 50162 | 2" 3 Way Valve |  | 2 | 33.03 | 66.06
Waterpik | 4724 | 50163 | 1.5" 2 Way Valve |  | 1 | 28.29 | 28.29
Waterpik | 6614 | 50165 | Power Center |  | 1 | 324.04 | 324.04
Waterpik | 6952 | 50167 | [NAME] |  | 3 | 2.57 | 7.71
Waterpik | 7235 | 215 | 1.5" Check Valve |  | 1 | 24.16 | 24.16
Waterpik | 7305 | 50168 | 2" Check Valve |  | 1 | 25.59 | 25.59
Waterpik | 7443 | 50169 | 4 Function 150' (don't need w/PDA) |  | 1 | 141.78 | 141.78
 |  |  | Subtotal |  |  |  | 825.25
 |  |  | [NAME] of 3% |  |  |  | 24.7575
 |  |  | Subtotal |  |  |  | 800.4925
 |  |  | Carecraft 2% |  |  |  | 16.00985
 |  |  | Freight |  |  |  | 24.4950705
 |  | Total | Waterpik |  |  |  | 840.9974205
Waterway | 210-3710 | 50158 | Spa Poly Gunite Jet | White | 18 | 5.29 | 95.22
Waterway | 210-3717 |  | Poly Storm Gunite Assy 1-1/2" Air x 2" Water | Gray | 6 | 5.29 | 31.74
Waterway | 212-8017G | 50664 | Poly Storm Gunite Roto Internal | Gray | 3 | 6.91 | 20.73
Waterway | 212-8057G |  | Poly Storm Gunite Directional Internal | Gray | 12 | 3.61 | 43.32
Waterway | 212-8127G | 50661 | Poly Storm Gunite Twin Roto Internal | Gray | 3 | 6.91 | 20.73
Waterway | 215-9150 | 50628 | Return Wall Fittings | White | 6 | 1.16 | 6.96
Waterway | 215-9157 | 622 | Return Wall Fittings | Gray | 20 | 1.28 | 25.6
Waterway | 400-1410C | 50656 | 1/2" Eyeballs | White | 6 | 1.12 | 6.72
Waterway | 400-1419C |  | 1/2" Eyeballs | [NAME] | 3 | 1.24 | 3.72
Waterway | 400-1417C-DK | 50657 | 1/2" Eyeballs | Gray | 20 | 1.24 | 24.8
Waterway | 400-5090 | 50079 | 2" Union |  | 14 | 3.06 | 42.84
Waterway | 640-2310 | 50049 | Anti-vortex Cover & Frame | White | 4 | 5.41 | 21.64
Waterway | 640-2317 | 688 | Anti-vortex Cover & Frame | Gray | 4 | 5.41 | 21.64
Waterway | 212-7630G |  | Power Gunite Directional Internal | White | 6 | 5.54 | 33.24
 |  |  | Subtotal |  |  |  | 398.9
 |  |  | Carecraft 2% |  |  |  | 7.978
 |  |  | Freight |  |  |  | 40.6878
 |  | Total | Waterway |  |  |  | 447.5658
Intermatic | PX100 | 51288 | Transformer 100 Watt (City of Austin) |  | 2 | 54.07 | 108.14
 |  |  | Subtotal |  |  |  | 108.14
 |  |  | Carecraft 2% |  |  |  | 2.1628
 |  |  | Freight |  |  |  | 4.412112
 |  | Total | Intermatic |  |  |  | 114.714912
 |  |  |  | Total |  | Order | 27208.31450178