Spreadsheet: 694777d1599786789-need-help-creating-po-with-existing-information-sample-pricing
Sheet: SV BW Pricing AUG2020

 | Price list [NAME] From 1.08.2020 Pricing is subject to change all prices stated are EX GST
 | SECUREVIEW SECURITY DOOR SCREENS – Undressed –  Must be fitted with T/Lock to be classed as Security
 | HINGE DOORS |  | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500
 | 4 X HINGES  SINGLE OR T/LOCK CUTOUT | 2100 | 336.3 | 349.6 | 361.95 | 374.3 | 386.65 | 399.95 | 412.3 | 425.6 | 437 | 450.3 | 462.65 | 475.95 | 488.3 | 501.6 | 513 | 526.3 | 538.65
 |  | 2200 | 345.8 | 360.05 | 373.35 | 386.65 | 399.95 | 414.2 | 426.55 | 438.9 | 452.2 | 465.5 | 478.8 | 491.15 | 505.4 | 517.75 | 532 | 545.3 | 557.65
 |  | 2300 | 368.6 | 382.85 | 397.1 | 410.4 | 423.7 | 437 | 451.25 | 464.55 | 478.8 | 492.1 | 506.35 | 520.6 | 533.9 | 548.15 | 561.4499999999999 | 574.75 | 588.05
 |  | 2400 | 379.05 | 393.775 | 408.025 | 422.275 | 436.525 | 450.3 | 465.025 | 478.8 | 493.525 | 507.775 | 522.025 | 536.75 | 550.525 | 565.25 | 579.5 | 593.275 | 607.525
 |  | 2500 | 389.5 | 404.7 | 418.95 | 434.15 | 449.35 | 463.6 | 478.8 | 493.05 | 508.25 | 523.4499999999999 | 537.6999999999999 | 552.9 | 567.15 | 582.35 | 597.55 | 611.8 | 627
 |  | 2600 | 406.125 | 421.325 | 436.525 | 451.725 | 467.4 | 482.6 | 498.275 | 513.475 | 529.15 | 544.35 | 559.55 | 575.225 | 589.9499999999999 | 605.625 | 621.3 | 636.025 | 651.6999999999999
 |  | 2700 | 422.75 | 437.95 | 454.1 | 469.3 | 485.45 | 501.6 | 517.75 | 533.9 | 550.05 | 565.25 | 581.4 | 597.55 | 612.75 | 628.9 | 645.05 | 660.25 | 676.4
 | SLIDING DOORS |  | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500
 | 4 x HD ROLLERS  SINGLE OR T/LOCK CUTOUT | 2100 | 339.15 | 352.45 | 364.8 | 378.1 | 390.45 | 403.75 | 415.15 | 428.45 | 440.8 | 454.1 | 466.45 | 478.8 | 491.15 | 504.45 | 516.8 | 530.1 | 542.4499999999999
 |  | 2200 | 350.55 | 362.9 | 377.15 | 389.5 | 402.8 | 416.1 | 429.4 | 442.7 | 456 | 468.35 | 482.6 | 495.9 | 508.25 | 522.5 | 534.85 | 548.15 | 561.4499999999999
 |  | 2300 | 373.35 | 385.7 | 399.95 | 413.25 | 427.5 | 440.8 | 455.05 | 468.35 | 482.6 | 496.85 | 510.15 | 524.4 | 536.75 | 551 | 564.3 | 578.55 | 591.85
 |  | 2400 | 383.325 | 397.1 | 411.825 | 425.6 | 440.325 | 454.1 | 468.825 | 483.075 | 497.325 | 512.05 | 525.8249999999999 | 540.55 | 554.3249999999999 | 568.5749999999999 | 582.35 | 596.6 | 610.85
 |  | 2500 | 393.3 | 408.5 | 423.7 | 437.95 | 453.15 | 467.4 | 482.6 | 497.8 | 512.05 | 527.25 | 541.5 | 556.6999999999999 | 571.9 | 586.15 | 600.4 | 614.65 | 629.85
 |  | 2600 | 409.925 | 425.125 | 440.8 | 456 | 471.2 | 486.4 | 502.075 | 517.275 | 532.475 | 547.675 | 563.35 | 579.025 | 594.225 | 609.425 | 624.625 | 639.35 | 655.025
 |  | 2700 | 426.55 | 441.75 | 457.9 | 474.05 | 489.25 | 505.4 | 521.55 | 536.75 | 552.9 | 568.1 | 585.1999999999999 | 601.35 | 616.55 | 632.6999999999999 | 648.85 | 664.05 | 680.1999999999999
 | SECUREVIEW SECURITY [NAME] (9mm/11mm extrusion)
 |  | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1550 |  | Standard Colour list
 | 300 | 69.35 | 74.1 | 78.85 | 83.6 | 89.3 | 94.05 | 98.8 | 105.45 | 110.2 | 114.95 | 120.65 | 125.4 | 130.15 | 132.05 |  | Black
 | 400 | 74.1 | 79.8 | 86.45 | 92.14999999999999 | 98.8 | 105.45 | 111.15 | 116.85 | 123.5 | 129.2 | 135.85 | 141.55 | 148.2 | 151.05 |  | [NAME]
 | 500 | 78.85 | 86.45 | 93.1 | 100.7 | 108.3 | 114.95 | 122.55 | 129.2 | 136.8 | 144.4 | 151.05 | 158.65 | 165.3 | 170.05 |  | [NAME]
 | 600 | 83.6 | 92.14999999999999 | 100.7 | 109.25 | 116.85 | 125.4 | 133 | 142.5 | 150.1 | 158.65 | 166.25 | 174.8 | 183.35 | 188.1 |  | Monument
 | 700 | 89.3 | 98.8 | 108.3 | 116.85 | 126.35 | 136.8 | 145.35 | 154.85 | 163.4 | 172.9 | 182.4 | 191.9 | 200.45 | 206.15 |  | Paladium Silver
 | 800 | 94.05 | 105.45 | 114.95 | 125.4 | 136.8 | 146.3 | 156.75 | 166.25 | 177.65 | 188.1 | 197.6 | 208.05 | 219.45 | 224.2 |  | [NAME]
 | 900 | 98.8 | 111.15 | 122.55 | 133 | 145.35 | 156.75 | 167.2 | 179.55 | 190.95 | 201.4 | 213.75 | 225.15 | 236.55 | 242.25 |  | Dune
 | 1000 | 105.45 | 116.85 | 129.2 | 142.5 | 154.85 | 166.25 | 179.55 | 191.9 | 204.25 | 216.6 | 228.95 | 242.25 | 254.6 | 260.3 |  | White Birch
 | 1100 | 110.2 | 123.5 | 136.8 | 150.1 | 163.4 | 177.65 | 190.95 | 204.25 | 217.55 | 230.85 | 245.1 | 258.4 | 271.7 | 278.35 |  | Ultra Silver
 | 1200 | 114.95 | 129.2 | 144.4 | 158.65 | 172.9 | 188.1 | 201.4 | 216.6 | 230.85 | 246.05 | 260.3 | 275.5 | 289.75 | 296.4 |  | Merino/ Paperbark
 | 1300 | 120.65 | 135.85 | 151.05 | 166.25 | 182.4 | 197.6 | 213.75 | 228.95 | 245.1 | 254.6 | 276.45 | 291.65 | 307.8 | 314.45 |  | Anodic Natural [NAME]
 | 1400 | 125.4 | 141.55 | 158.65 | 174.8 | 191.9 | 208.05 | 225.15 | 242.25 | 258.4 | 277.4 | 291.65 | 308.75 | 314.45 | 332.5 |  | Anotec [NAME]
 | 1500 | 130.15 | 148.2 | 165.3 | 183.35 | 200.45 | 219.45 | 236.55 | 254.6 | 271.7 | 288.8 | 307.8 | 314.45 | 342.95 | 351.5 |  | APO Grey
 | 1600 | 135.85 | 154.85 | 172.9 | 191.9 | 209.95 | 228.95 | 247.95 | 266 | 285 | 304.95 | 323 | 342 | 360.05 | 370.5 |  | Charcoal
 | 1700 | 140.6 | 160.55 | 179.55 | 199.5 | 220.4 | 239.4 | 259.35 | 279.3 | 298.3 | 318.25 | 339.15 | 358.15 | 378.1 | 388.55 |  | Deep Ocean
 | 1800 | 145.35 | 166.25 | 188.1 | 208.05 | 228.95 | 249.85 | 270.75 | 291.65 | 312.55 | 332.5 | 354.35 | 375.25 | 395.2 | 406.6 |  | [NAME]
 | 1900 | 150.1 | 172.9 | 194.75 | 215.65 | 238.45 | 260.3 | 282.15 | 304 | 325.85 | 347.7 | 370.5 | 391.4 | 413.25 | 424.65
 | 2000 | 155.8 | 178.6 | 201.4 | 225.15 | 247 | 270.75 | 293.55 | 316.35 | 340.1 | 361.95 | 384.75 | 408.5 | 431.3 | 442.7 |  | Stone Beige
 | 2100 | 160.55 | 184.3 | 209 | 232.75 | 257.45 | 280.25 | 304.95 | 328.7 | 352.45 | 377.15 | 400.9 | 424.65 | 448.4 | 460.75 |  | Anotec Silver Grey
 | 2200 | 166.25 | 190.95 | 215.65 | 241.3 | 266 | 291.65 | 316.35 | 341.05 | 365.75 | 391.4 | 416.1 | 441.75 | 466.45 | 478.8 |  | [NAME]
 | 2300 | 171.95 | 196.65 | 223.25 | 248.9 | 275.5 | 301.15 | 327.75 | 354.35 | 380 | 406.6 | 432.25 | 457.9 | 483.55 | 496.85 |  | Champagne
 | 2400 | 176.7 | 204.25 | 230.85 | 257.45 | 284.05 | 311.6 | 339.15 | 365.75 | 393.3 | 420.85 | 447.45 | 475 | 501.6 | 514.9 |  | Clear Ano
 | 2500 | 181.45 | 209.95 | 238.45 | 266 | 294.5 | 323 | 350.55 | 379.05 | 407.55 | 435.1 | 463.6 | 491.15 | 518.6999999999999 | 532.9499999999999 |  | [NAME]
 | 2600 | 187.15 | 215.65 | 245.1 | 274.55 | 304 | 332.5 | 361.95 | 391.4 | 420.85 | 449.35 | 478.8 | 508.25 | 536.75 | 551.9499999999999 |  | Notre Dame
 | 2700 | 191.9 | 230.85 | 251.75 | 282.15 | 312.55 | 342.95 | 373.35 | 402.8 | 433.2 | 463.6 | 494 | 525.35 | 555.75 | 570 |  | Pottery
 | 2800 | 196.65 | 228 | 259.35 | 290.7 | 322.05 | 352.45 | 384.75 | 416.1 | 447.45 | 478.8 | 510.15 | 541.5 | 566.1999999999999 | 589 |  | [NAME]
 | 2900 | 201.4 | 233.7 | 266 | 298.3 | 331.55 | 363.85 | 396.15 | 428.45 | 460.75 | 493.05 | 525.35 | 558.6 | 590.9 | 607.05 |  | Custom colours are available POA
 | 3000 | 207.1 | 241.3 | 274.55 | 307.8 | 341.05 | 374.3 | 407.55 | 440.8 | 475 | 508.25 | 541.5 | 574.75 | 608 | 625.1