Spreadsheet: 694777d1599786789-need-help-creating-po-with-existing-information-sample-pricing
Sheet: Pricing Calculator Grill

 | All Pricing is EX GST Pricing Valid at 20.08.2020
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Description | Type | Height | [NAME] |  |  | Price | SQM | Mesh Type |  | Lock Body |  | Barrell Type |  | Multi Lock |  | [NAME] |  | Pet Flap |  | Total |  | JPHD21 | Hinge Door 2100
 |  | Grille HD | 2040 | 820 |  |  |  |  | [NAME] |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  | [NAME] |  | N/A |  |  |  | [NAME] | Hinge Door 2300
 | Front | Grille HD | 2055 | 1200 |  |  |  |  | Stainless Steel Mesh |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  |  |  | N/A |  |  |  | JPHDD21 | Hinge Double Door 2100
 | Back | Grille HD | 2055 | 1200 |  |  |  |  | [NAME] |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  |  |  | N/A |  |  |  | [NAME] | Hinge Double Door 2300
 | Front | Grille HD | 2055 | 1200 |  |  |  |  | Alum Mesh |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  |  |  | N/A |  |  |  | JPSD21 | Sliding Door 2100
 | Back | Grille HD | 2055 | 1200 |  |  |  |  | Sand Fly Mesh |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  |  |  | N/A |  |  |  | [NAME] | Sliding Door 2300
 | Front | Grille HD | 2055 | 1200 |  |  |  |  | Pet Mesh |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  |  |  | N/A |  |  |  | JPSD26 | Sliding Door 2600
 | Back | Grille HD | 2052 | 827 |  |  |  |  | Alum Mesh |  | Austral Elegance |  | Austral |  | Lockwood Triple |  |  |  | N/A |  |  |  | JPFD21 | French Door 2100
 | Bella Doors Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total |  | JPFD23 | French Door 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPFDD21 | French Double Door 2100
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | French Double Door 2300
 | Description | Type | Height | [NAME] |  |  | Price | SQM | Mesh Type |  | Quantity |  |  |  |  |  |  |  |  |  | Total |  | JPCS21 | Corner Stacker 2100 (2 panels)
 |  | Grille | 300 | 820 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPCS23 | Corner Stacker 2300 (2 panels)
 |  | Grille | 820 | 900 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPCS26 | Corner Stacker 2600 (2 panels)
 |  | Grille | 535 | 885 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPDSE21 | Sliding Door Double Stacker (2 panels) 2100
 |  | Grille | 845 | 710 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPDSE23 | Sliding Door Double Stacker (2 panels) 2300
 |  | Grille | 545 | 260 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPDSE26 | Sliding Door Double Stacker (2 panels) 2300
 |  | Grille | 1200 | 820 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Door 2100 (2 Panels)
 |  | Grille | 1324 | 700 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Door 2300 (2 Panels)
 |  | Grille | 466 | 580 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPBP26 | Sliding Bi-parting Door 2600 (2 Panels)
 |  | Grille | 1200 | 720 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPETBP21 | Sliding Bi-parting Stacker Door 2100 (4 Panels)
 |  | Grille | 979 | 280 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | JPETBP23 | Sliding Bi-parting Stacker Door 2300 (4 Panels)
 |  | Grille | 900 | 260 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Stacker Door 2600 (4 Panels)
 | Windows Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total
 | Total EX GST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | FOX
 |  |  | 700 | windows [NAME]
 |  |  | 540 | fly doors
 |  |  | 1188 | [NAME]