Spreadsheet: 152221d1335290288-excel-on-an-ipad-combined-order-form
Sheet: Order form

Shop Name |  |  |  |  | Salesman
Address |  |  |  |  | Date of Order
 |  |  |  |  | Sales Group
Ordered by: |  |  |  |  | Dealership Level
[NAME]
 |  |  |  |  | Nett Total |  |  |  |  |  | IF('Test Results'!F$5="FISH","31",(IF('Test Results'!F$5="SOFT","33",(IF('Test Results'!F$5="LPS","33",(IF('Test Results'!F$5="SPS GROWTH","35",(IF('Test Results'!F$5="SPS COLOUR","35",)))))))))
Item Code | Description | Discount % | Trade Price | Nett Price | Qty | Total Nett | SRP
 |  |  | 440 |  |  |  | 749.99
 |  |  | 440 |  |  |  | 749.99
 |  |  | 440 |  |  |  | 749.99
 |  |  | 850 |  |  |  | 1499.99
 |  |  | 850 |  |  |  | 1499.99
 |  |  | 850 |  |  |  | 1499.99
 |  |  | [NAME]
 |  |  |  |  |  |  | 16.99
 |  |  |  |  |  |  | 16.99
 |  |  |  |  |  |  | 12.99
 |  |  |  |  |  |  | 4.29
 |  |  |  |  |  |  | 47.99
 |  |  | 2125 |  |  |  | 3000
 |  |  | 2125 |  |  |  | 3000
 |  |  | 2357 |  |  |  | 3300 | Available June
 |  |  | 2357 |  |  |  | 3300 | Available June
 |  |  | 2357 |  |  |  | 3300 | Available June
 |  |  | 2357 |  |  |  | 3300 | Available June
 |  |  | 2479 |  |  |  | 3500
 |  |  | 2479 |  |  |  | 3500
 |  |  | 2621 |  |  |  | 3750 | Available June
 |  |  | 2621 |  |  |  | 3750 | Available June
 |  |  | 2621 |  |  |  | 3750 | Available June
 |  |  | 2621 |  |  |  | 3750 | Available June
 |  |  | 2833 |  |  |  | 4000
 |  |  | 2833 |  |  |  | 4000
 |  |  | 2975 |  |  |  | 4300 | Available June
 |  |  | 2975 |  |  |  | 4300 | Available June
 |  |  | 2975 |  |  |  | 4300 | Available June
 |  |  | 2975 |  |  |  | 4300 | Available June
 |  |  | 285 |  |  |  | 376.2
 |  |  | 250 |  |  |  | 330
 |  |  | 285 |  |  |  | 376.2
 |  |  | 250 |  |  |  | 330
 |  |  | 380 |  |  |  | 501.6 | Available June
 |  |  | 310 |  |  |  | 409.2 | Available June
 |  |  | 380 |  |  |  | 501.6 | Available June
 |  |  | 310 |  |  |  | 409.2 | Available June
 |  |  | 380 |  |  |  | 501.6 | Available June
 |  |  | 310 |  |  |  | 409.2 | Available June
 |  |  | 380 |  |  |  | 501.6 | Available June
 |  |  | 310 |  |  |  | 409.2 | Available June
 |  |  | 310 |  |  |  | 409.2
 |  |  | 270 |  |  |  | 356.4
 |  |  | 310 |  |  |  | 409.2
 |  |  | 270 |  |  |  | 356.4
 |  |  | 410 |  |  |  | 541.2 | Available June
 |  |  | 335 |  |  |  | 442.2 | Available June
 |  |  | 410 |  |  |  | 541.2 | Available June
 |  |  | 335 |  |  |  | 442.2 | Available June
 |  |  | 410 |  |  |  | 541.2 | Available June
 |  |  | 335 |  |  |  | 442.2 | Available June
 |  |  | 410 |  |  |  | 541.2 | Available June
 |  |  | 335 |  |  |  | 442.2 | Available June
 |  |  | 335 |  |  |  | 442.2
 |  |  | 290 |  |  |  | 382.8
 |  |  | 335 |  |  |  | 442.2
 |  |  | 290 |  |  |  | 382.8
 |  |  | 440 |  |  |  | 580.8 | Available June
 |  |  | 360 |  |  |  | 475.2 | Available June
 |  |  | 440 |  |  |  | 580.8 | Available June
 |  |  | 360 |  |  |  | 475.2 | Available June
 |  |  | 440 |  |  |  | 580.8 | Available June
 |  |  | 360 |  |  |  | 475.2 | Available June
 |  |  | 440 |  |  |  | 580.8 | Available June
 |  |  | 360 |  |  |  | 475.2 | Available June
 |  | 0.28 |  |  |  |  | 29.99
 |  |  |  |  |  |  | 27.99
 |  |  |  |  |  |  | 27.99
 |  | 0.28 |  |  |  |  | 34.99 | Available June
 |  | 0.28 |  |  |  |  | 34.99 | Available June
 |  | 0.28 |  |  |  |  | 39.99 | Available June
 |  | 0.28 |  |  |  |  | 39.99 | Available June
 |  |  | 194.4388888888887 |  |  |  | 349.99
 |  |  | 83.3277777777777 |  |  |  | 149.99
 |  |  | 21.10555555555553 |  |  |  | 37.99
 |  |  | 24.99444444444442 |  |  |  | 44.99
 |  |  | 27.7722222222222 |  |  |  | 49.99
 |  |  | 3.327777777777774 |  |  |  | 5.99
 |  |  | 8.5
 |  |  | 14.99444444444443
 |  |  | 28
 |  |  | 47.22
 |  |  | 51
 |  |  | 810
 |  |  | 20.54999999999998
 |  |  | 49.99444444444439
 |  |  | 56
 |  |  | 910
 |  | Total [NAME]
 |  | [NAME]
 |  | 0.28 | 55.55 |  |  |  | 99.99
 |  | 0 | 180.65 |  |  |  | 325
 |  | 0 | 208.44 |  |  |  | 375.00
 |  | 0 | 222.33 |  |  |  | 400.00
 |  | 0 | 250.13 |  |  |  | 450.00
 |  | 0 | 50.03 |  |  |  | 90.00
 |  | 0 | 496.12 |  |  |  | -
 |  | 0 | 698.99 |  |  |  | -
 |  |  |  |  |  |  |  | RCPA | RCPB
 |  |  | 24.9722222222222 |  |  |  | 44.95 | 2 | 3
 |  |  | 13.8611111111111 |  |  |  | 24.95 | 2 | 3
 |  |  | 13.8611111111111 |  |  |  | 24.95 | 2 | 2
 |  |  | 13.8611111111111 |  |  |  | 24.95 | 2 | 2
 |  |  | 7.75 |  |  |  | 13.95
 |  |  | 7.75 |  |  |  | 13.95
 |  |  | 7.75 |  |  |  | 13.95
 |  |  | 8.861111111111102 |  |  |  | 15.95 | 3 | 3
 |  |  | 13.86 |  |  |  | 24.95 |  | 2
 |  |  | 8.861111111111102 |  |  |  | 15.95 | 3 | 3
 |  |  | 13.86 |  |  |  | 24.95 |  | 2
 |  |  | 8.861111111111102 |  |  |  | 15.95 | 3 | 3
 |  |  | 13.86 |  |  |  | 24.95 |  | 2
 |  |  | 13.86 |  |  |  | 24.95 | 2 | 2
 |  |  | 38.86 |  |  |  | 69.95
 |  |  | 27.74999999999998 |  |  |  | 49.95 | 2 | 3
 |  |  | 15.52777777777776 |  |  |  | 27.95 | 2 | 3
 |  |  | 16.63888888888887 |  |  |  | 29.95 | 2 | 3
 |  |  | 9.416666666666657 |  |  |  | 16.95
 |  |  | 9.416666666666657 |  |  |  | 16.95
 |  |  | 9.42 |  |  |  | 16.95 | 3 | 6
 |  |  | 16.63888888888887 |  |  |  | 29.95 |  | 3
 |  |  | 33.30555555555552 |  |  |  | 59.95 | 2 | 2
 |  |  | 16.63888888888887 |  |  |  | 29.95 | 2 | 2
 |  |  | 22.19444444444443 |  |  |  | 39.95 | 1 | 1
 |  |  | 9.416666666666657 |  |  |  | 16.95
 |  |  | 12.74999999999999 |  |  |  | 22.95
 |  |  | 9.42 |  |  |  | 16.95
 |  |  | 11.08333333333332 |  |  |  | 19.95 | 3 | 4
 |  |  | 9.416666666666657 |  |  |  | 16.95 | 2 | 3
 |  |  | 9.416666666666657 |  |  |  | 16.95 | 2 | 3
 |  |  | 9.416666666666657 |  |  |  | 16.95 | 2 | 3
 |  |  | 9.416666666666657 |  |  |  | 16.95 | 2 | 3
 |  |  | 9.416666666666657 |  |  |  | 16.95 | 5 | 4
 |  |  | 10.52777777777777 |  |  |  | 18.95 | 3 | 6
 |  |  | 10.52777777777777 |  |  |  | 18.95 | 3 | 6
 |  |  | 70 |  |  |  | -
 |  |  | 70 |  |  |  | -
 |  |  | 70 |  |  |  | -
 |  |  | 85 |  |  |  | -
 |  |  | 85 |  |  |  | -
 |  |  | 75 |  |  |  | -
 |  |  | 9.416666666666657 |  |  |  | 16.95
 |  |  | 24.9722222222222 |  |  |  | 44.95
 |  |  | 8.305555555555546 |  |  |  | 14.95
 |  |  | 10.52777777777777 |  |  |  | 18.95
 |  |  | 8.305555555555546 |  |  |  | 14.95
 |  |  | 12.19444444444443 |  |  |  | 21.95
 |  |  | 9.994444444444433 |  |  |  | 17.99
 |  |  | 8.327777777777769 |  |  |  | 14.99
 |  |  | 19.99999999999998 |  |  |  | -
 |  |  | 13.32999999999999 |  |  |  | 23.994
 |  |  | 23.88333333333331 |  |  |  | 42.99
 |  |  | 5.549999999999994 |  |  |  | 9.99
 |  | 0 | 180
 |  | 0 | 180
 |  | 0 | 180 |  |  |  | 324
 |  | 0 | 180
 |  | 0 | 180
 |  | 0 | 180
 |  | 0 | 90 |  |  |  | 175
 |  | 0 | 90 |  |  |  | 175
 |  | 0 | 90 |  |  |  | 175
 |  | 0 | 385 |  |  |  | 649.99
 |  | 0 | 385 |  |  |  | 649.99
 |  | 0 | 385 |  |  |  | 649.99
 |  | 0 |  |  |  |  | 29.99
 |  | 0 | 38.8833352775 |  |  |  | 69.99
 |  | 0 | 13.8833340275 |  |  |  | 24.99
 |  | 0 | 11.10555611083333 |  |  |  | 19.99
 |  | 0 | 8.327778194166667 |  |  |  | 14.99
 |  | 0 | 6.105555860833332 |  |  |  | 10.99
 |  | 0 | 6.105555860833332 |  |  |  | 10.99
 |  | 0 | 11.10555611083333 |  |  |  | 19.99
 |  | 0 | 14.99 |  |  |  | 24.99
 |  | 0 | 4.438889110833333 |  |  |  | 7.99
 |  | 0 | 33.333335 |  |  |  | 60
 |  | 0 | 9.444444916666667 |  |  |  | 17
 |  | 0 | 11.11111166666667 |  |  |  | 20
 |  | 0 | 5.555555833333333 |  |  |  | 10
 |  | 0 | 4.438889110833333 |  |  |  | 7.99
 |  | 0 | 4.438889110833333 |  |  |  | 7.99
 |  | 0 | 2.772222360833334 |  |  |  | 4.99
 |  | 0 | 19.44444541666667 |  |  |  | 35
 |  | 0 | 300
 |  | 0 | 150
 |  | 0 | 340
 |  | 0 | 750
 |  | 0 | 300
 |  | 0 | 340
 |  | 0 | 150
 |  | 0 | 750
 |  | 0 | 300
 |  | 0 | 340
 |  | 0 | 150
 |  | 0 | 750
 |  | 0 | 4.994444694166667
 |  | 0 | 4.438889110833333
 |  | 0 | 8.327778194166667
 |  | 0 | 14.43888961083333
 |  | 0 | 49.99444694416666
 |  | 0 | 49.99444694416666
 |  | 0 | 38.8833352775
 |  | 0 | 12.2166672775
 |  | 0 | 11.10555611083333
 |  | 0 | 19.43888986083333
 |  | 0 | 2.772222360833334
 |  | 0 | 5.550000277500001 |  |  |  | 9.99
 |  | 0 | 66.66667 |  |  |  | 120
 |  | 0 | 25.00000125 |  |  |  | 45
 |  | 0 | 19.44444541666667 |  |  |  | 35
 |  | 0 | 8.33333375 |  |  |  | 15
 |  | 0 | 5.550000277500001 |  |  |  | 9.99
 |  | 0 | 2.772222360833334 |  |  |  | 4.99
 |  | 0 | 2.772222360833334 |  |  |  | 4.99
 |  | 0 | 11.10555611083333 |  |  |  | 19.99
 |  | 0 | 2.2166667775 |  |  |  | 3.99
 |  | 0 | 19.44444541666667 |  |  |  | 35
 |  | 0 | 8.327777777777769 |  |  |  | 14.99
 |  | 0 | 2.772222360833334 |  |  |  | 4.99
 |  | 0 | 38.8833352775 |  |  |  | 69.99
 |  | 0 | 38.8833352775 |  |  |  | 69.99
 |  | 0 | 8.327778194166667 |  |  |  | 14.99
 |  | 0 | 8.327778194166667 |  |  |  | 14.99
 |  | 0 | 13.8833340275 |  |  |  | 24.99
 |  | 0 | 19.43888986083333 |  |  |  | 34.99
 |  | 0 | 44.43889111083333 |  |  |  | 79.99
 |  | 0 | 44.43889111083333 |  |  |  | 79.99
 |  | 0 | 11.10555611083333 |  |  |  | 19.99
 |  | 0 | 12.22 |  |  |  | 17.99
 |  | 0 | 8.327778194166667 |  |  |  | 14.99
 |  | 0 | 4.994444694166667 |  |  |  | 8.99
 |  | 0 | 3.8833335275 |  |  |  | 6.99
 |  | 0 | 8.8833337775 |  |  |  | 15.99
 |  | 0 | 3.327777944166667 |  |  |  | 5.99
 |  | 0 | 19.43888986083333 |  |  |  | 34.99
 |  | 0 | 9.994444944166665 |  |  |  | 17.99
 |  | 0 | 49.99444694416666 |  |  |  | 89.99
 |  | 0 | 10.5500005275 |  |  |  | 18.99
 |  | 0 | 10.5500005275 |  |  |  | 18.99
 |  | 0 | 25
 |  | 0 | 65
 |  | 0 | 15
 |  | 0 | 10
 |  | 0 | 12
 |  | 0 | 15
 |  | 0 | 5
MAX S - Spare parts
R50420 | RS Flow Pump S2.0 - EUR | 0 | 55
R50475 | [NAME] 400 Main Pump | 0 | 150
R50490 | [NAME] 500/650 Main Pump | 0 | 155
R40350 | Max S Light Chassis Side Plate | 0 | 14.55
R40351 | Max S Front/Rear Light End Cap - Left | 0 | 8.75
R40352 | Max S Front/Rear Light End Cap - Right | 0 | 8.75
R40353 | Max S Front/Rear Light Micro-Switch | 0 | 2.25
R40354 | Max S-400 Front/Rear Light Acrylic Lens | 0 | 4.85
R40355 | [NAME]/Rear Light [NAME] | 0 | 6
R40356 | Max S-650 Front/Rear Light Acrylic Lens | 0 | 7.65
R40357 | Max S-400 Center Light Acrylic Lens | 0 | 3.55
R40358 | Max S-500 Center Light Acrylic Lens | 0 | 4.25
R40359 | Max S-650 Center Light Acrylic Lens | 0 | 5.35
R40361 | Ballast 2xT5 54W 200 - 240V 50/60 hz - CE | 0 | 33.45
R40363 | Ballast 2xT5 80W 200 - 240V 50/60 hz - CE | 0 | 43.25
R40364 | Max S Power Center Switch Unit | 0 | 49.05
R40365 | Max S Power Center Timer Unit | 0 | 120.3
R40366 | Max S Circulation Pump Outlet Assembly | 0 | 6.3
R40367 | [NAME] | 0 | 4.4
R40368 | [NAME] Seal | 0 | 2.95
R40369 | [NAME] assembly | 0 | 15
R40370 | [NAME] diaphragm | 0 | 3.9
R40371 | [NAME] Screw & Plug Set (incl.[NAME]) | 0 | 2.8
R40372 | Max S Filter Sponge set | 0 | 22.35
R40373 | [NAME] | 0 | 8.6
R40374 | [NAME] downpipe | 0 | 18.65
R40375 | [NAME] downpipe | 0 | 12.6
R40376 | Max S Drawer Sliders (pair) | 0 | 27.2
R40377 | [NAME] feet (9 pce - Incl. Spanner) | 0 | 59.3
R40378 | [NAME] (S1) | 0 | 6.65
R40379 | [NAME] (S2,S3,S4) | 0 | 10.8
R40380 | Cabinet (Side panel) Parts Pack (8 sets) | 0 | 2.85
R40381 | Side Panel Holders (8 pcs) | 0 | 18.8
[NAME] | Frame Bracket Plugs (10 pcs) | 0 | 5.1
R40383 | Hinge + Screw S6 (4 set) | 0 | 30.45
R40384 | [NAME] set (5 pcs) | 0 | 7.6
R40385 | Plastic Rivets (34 pcs) | 0 | 4.05
R40386 | Max S Frame Brackets | 0 | 2.5
MAX S - Spare modules
R40424 | Max S-400 Aquarium (glass) | 0 | 415
R40425 | [NAME] | 0 | 80
R40442 | Max S-400 Aluminum Aquarium Stand | 0 | 540
R40443-EUR | [NAME] T5x4 Light unit | 0 | 295
R40444-EUR | [NAME] T5x2 Light unit | 0 | 185
R40472 | [NAME] wall | 0 | 34.85
R40476 | Max S-400 Light Chassis | 0 | 62.6
[NAME] | Max S-400 Aluminum Frame Parts | 0 | 330.5
[NAME] | Max S-400 Sump Pipe Assembly | 0 | 74.6
[NAME] | [NAME]. [NAME] (2 sets) | 0 | 17.8
R40491 | [NAME] S-400 Cabinet Top Board | 0 | 104.15
R40494 | Max S-400 Sump Compartment Base Board | 0 | 30.45
R40497 | [NAME] | 0 | 19.8
R40426 | [NAME]  (glass) | 0 | 500
[NAME] | [NAME] | 0 | 100
R40452 | [NAME] Aquarium Stand | 0 | 615
R40453-EUR | [NAME] T5x4 Light unit | 0 | 320
R40454-EUR | [NAME] T5x2 Light unit | 0 | 210
R40473 | [NAME] wall | 0 | 47.05
R40477 | Max S-500 Light Chassis | 0 | 70.95
R40483 | [NAME] Parts | 0 | 365.95
R40486 | [NAME] | 0 | 84.15
R40489 | [NAME]. [NAME] (3 sets) | 0 | 24.8
R40492 | [NAME] Top Board | 0 | 126.9
[NAME] | [NAME] Compartment Base Board | 0 | 38.05
[NAME] | [NAME] | 0 | 20.3
R40428 | [NAME]  (glass) | 0 | 650
R40429 | [NAME] Sump | 0 | 115
[NAME] | Max S-650 Aluminum Aquarium Stand | 0 | 755
R40463-EUR | [NAME] T5x4 Light unit | 0 | 390
R40464-EUR | [NAME] T5x2 Light unit | 0 | 250
R40474 | [NAME] wall | 0 | 62.5
R40475 | Max S-650 Internal MDF panel | 0 | 63.5
R40478 | Max S-650 Light Chassis | 0 | 82.35
R40484 | Max S-650 Aluminum Frame Parts | 0 | 500.4
R40487 | [NAME] | 0 | 85.2
R40490 | [NAME]. [NAME] (4 sets) | 0 | 31.8
R40493 | [NAME] Cabinet Top Board | 0 | 160.8
R40496 | [NAME] Sump Compartment Base Board | 0 | 50.8
[NAME] | [NAME] | 0 | 25.3
R40440-EUR | Max S Power Center | 0 | 305
R40470 | Max-S Sump Compartment Liner -  left | 0 | 42.25
R40471 | Max-S Sump Compartment Liner -  right | 0 | 42.25
R40479 | Max-S Aluminum Frame Left Wall | 0 | 102.05
R40480 | Max-S Aluminum Frame Right Wall | 0 | 100.7
[NAME] | Max-S Aluminum Frame Middle Wall | 0 | 104.2
 |  |  |  |  | Total