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

 | All Pricing is EX GST Pricing Valid at 20.08.2020
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Description | Type | Height | [NAME] |  |  | Price | Lock Body |  | Barrell Type |  | Multi Lock |  | [NAME] |  | Pet Flap |  | Total |  | JPHD21 | Hinge Door 2100
 |  | BELLA HD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Hinge Door 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPHDD21 | Hinge Double Door 2100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Hinge Double Door 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPSD21 | Sliding Door 2100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Door 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPSD26 | Sliding Door 2600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPFD21 | French Door 2100
 | Bella Doors Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total |  | JPFD23 | French Door 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPFDD21 | French Double Door 2100
 |  | SV Doors |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | French Double Door 2300
 | Description | Type | Height | [NAME] |  |  | Price | Lock Body |  | Barrell Type |  | Multi Lock |  | [NAME] |  | Pet Flap |  | Total |  | JPCS21 | Corner Stacker 2100 (2 panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPCS23 | Corner Stacker 2300 (2 panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPCS26 | Corner Stacker 2600 (2 panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPDSE21 | Sliding Door Double Stacker (2 panels) 2100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPDSE23 | Sliding Door Double Stacker (2 panels) 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPDSE26 | Sliding Door Double Stacker (2 panels) 2300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Door 2100 (2 Panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Door 2300 (2 Panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPBP26 | Sliding Bi-parting Door 2600 (2 Panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPETBP21 | Sliding Bi-parting Stacker Door 2100 (4 Panels)
 | Secure View Doors Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total |  | JPETBP23 | Sliding Bi-parting Stacker Door 2300 (4 Panels)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sliding Bi-parting Stacker Door 2600 (4 Panels)
 |  | Xceed Doors
 | Description | Type | Height | [NAME] |  |  | Price | Lock Body |  | Barrell Type |  | Multi Lock |  | [NAME] |  | Pet Flap |  | Total
 | Xceed Doors Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total
 |  | Windows
 | Description | Type | Height | [NAME] |  |  | Price | Quantity |  |  |  |  |  |  |  |  |  | Total
 | Windows Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total
 | Total EX GST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40