Spreadsheet: 695086d1600040164-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
 | Front Door | BELLA HD | 2100 | 720 |  |  |  | Austral Elegance |  | Austral |  | Austral Triple |  | [NAME] |  | N/A |  |  |  | [NAME] | Hinge Door 2300
 | Back | BELLA HD | 2100 | 720 |  |  |  | Austral Elegance |  | Austral |  | Austral Triple |  | [NAME] |  | N/A |  |  |  | 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)
 | Guest | Secure View SD | 2100 | 1200 |  |  |  | Lockwood 8654 |  | N/A |  | Lockwood Triple |  | JPHDD21 |  | N/A |  |  |  | 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
 | Bed 1 | BELLA | 1800 | 900 |  |  |  | 1
 | Bed 2 | BELLA | 1900 | 1200 |  |  |  | 4
 | Windows Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total
 | Total EX GST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40