Spreadsheet: 682647d1592235945-hiding-data-with-semicolon-example-order-form
Sheet: Purchase Order

 |  |  |  | PURCHASE ORDER
 |  |  |  |  |  |  |  | PO DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Model | LCD | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/5 C | OEM | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 S | OEM | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | OEM | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | OEM | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | OEM | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | OEM | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | OEM | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | OEM | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | OEM | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | OEM | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | OEM | 130
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XR | OEM | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XS | OEM | 141
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | OEM | 191
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | OEM | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 Max | OEM | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/5 C | GENERIC | 10
 | ITEM # | Make | LCD | Model | Colour | QTY | UNIT PRICE | AMOUNT |  |  |  |  |  |  |  |  |  | SE | GENERIC | 10
 | 1 | IPHONE | OEM | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | GENERIC | 11
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | GENERIC | 16
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | GENERIC | 16
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | GENERIC | 19
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | GENERIC | 17
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | GENERIC | 19
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | GENERIC | 19
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | GENERIC | 21
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Soft OLED | GENERIC | 106
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X TFT | GENERIC | 56
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] OLED | GENERIC | 121
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XS TFT | GENERIC | 66
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XR | GENERIC | 61
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | GENERIC | 111
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | GENERIC | 81
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 Pro | GENERIC | 255
 | 17
 | 18
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Premium | 14
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | Premium | 17
 |  |  |  |  |  | SUB TOTAL |  |  |  |  |  |  |  |  |  |  |  | 6 S | Premium | 18
 |  |  |  |  |  | P&P |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | Premium | 19
 |  |  |  |  |  | VAT @20% |  |  |  |  |  |  |  |  |  |  |  | 7 Prem/Tianma | Premium | 18
 | Notes/Additional Information |  |  |  |  | TOTAL NET |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | Premium | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Prem/Tianma | Premium | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | Premium | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | NCC | 15.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | NCC | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | NCC | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | NCC | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | NCC | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | NCC | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | NCC | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | NCC | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | NCC | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XS | NCC | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | NCC | 121