Spreadsheet: 694777d1599786789-need-help-creating-po-with-existing-information-sample-pricing
Sheet: Grille Price 

 | Price list [NAME] From 1.08.2020 Pricing is subject to change all prices stated are EX GST
 | Diamond [NAME] – Undressed –
 | 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 | 168 | 171 | 173 | 176 | 179 | 181 | 184 | 187 | 189 | 192 | 195 | 197 | 200 | 203 | 205 | 208 | 211
 |  | 2200 | 171 | 173 | 176 | 179 | 181 | 184 | 187 | 190 | 192 | 195 | 198 | 201 | 204 | 206 | 209 | 212 | 215
 |  | 2300 | 173 | 176 | 178 | 181 | 184 | 187 | 190 | 193 | 196 | 199 | 201 | 204 | 207 | 210 | 213 | 216 | 219
 |  | 2400 | 175 | 178.5 | 181 | 184 | 187 | 190 | 193 | 196 | 199 | 202 | 204.5 | 207.5 | 210.5 | 213.5 | 217 | 220 | 223
 |  | 2500 | 177 | 181 | 184 | 187 | 190 | 193 | 196 | 199 | 202 | 205 | 208 | 211 | 214 | 217 | 221 | 224 | 227
 |  | 2600 | 179.5 | 183 | 186.5 | 189.5 | 192.5 | 196 | 199 | 202 | 205.5 | 208.5 | 211.5 | 214.5 | 218 | 221 | 224.5 | 228 | 231
 |  | 2700 | 182 | 185 | 189 | 192 | 195 | 199 | 202 | 205 | 209 | 212 | 215 | 218 | 222 | 225 | 228 | 232 | 235
 | SLIDING DOORS |  | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500
 | 4 x HD ROLLERS  SINGLE OR T/LOCK CUTOUT | 2100 | 165 | 167 | 170 | 173 | 175 | 178 | 181 | 183 | 186 | 189 | 191 | 194 | 197 | 199 | 202 | 205 | 207
 |  | 2200 | 167 | 170 | 173 | 175 | 178 | 181 | 184 | 186 | 189 | 192 | 195 | 197 | 200 | 203 | 206 | 208 | 211
 |  | 2300 | 169 | 172 | 175 | 178 | 181 | 184 | 187 | 189 | 192 | 152 | 198 | 201 | 204 | 207 | 210 | 212 | 215
 |  | 2400 | 171.5 | 174.5 | 177.5 | 180.5 | 183.5 | 187 | 190 | 192.5 | 195.5 | 177 | 201.5 | 204.5 | 207.5 | 210.5 | 213.5 | 216 | 219
 |  | 2500 | 174 | 177 | 180 | 183 | 186 | 190 | 193 | 196 | 199 | 202 | 205 | 208 | 211 | 214 | 217 | 220 | 223
 |  | 2600 | 176.5 | 179.5 | 182.5 | 186 | 189 | 192.5 | 196 | 199 | 202 | 205 | 208.5 | 211.5 | 214.5 | 218 | 221 | 224 | 227.5
 |  | 2700 | 179 | 182 | 185 | 189 | 192 | 195 | 199 | 202 | 205 | 208 | 212 | 215 | 218 | 222 | 225 | 228 | 232
 | [NAME] (9mm/11mm extrusion)
 |  | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1550 |  | Standard Colour list
 | 300 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 |  | Black
 | 400 | 43 | 44 | 45 | 47 | 48 | 49 | 50 | 51 | 53 | 54 | 55 | 56 | 57 | 58 |  | [NAME]
 | 500 | 44 | 45 | 47 | 48 | 50 | 51 | 53 | 54 | 55 | 57 | 58 | 60 | 61 | 62 |  | [NAME]
 | 600 | 45 | 47 | 48 | 50 | 52 | 53 | 55 | 56 | 58 | 60 | 61 | 63 | 65 | 66 |  | Monument
 | 700 | 46 | 58 | 50 | 52 | 53 | 55 | 57 | 59 | 61 | 63 | 64 | 66 | 68 | 69 |  | Paladium Silver
 | 800 | 47 | 49 | 51 | 53 | 55 | 57 | 59 | 61 | 63 | 65 | 68 | 70 | 72 | 73 |  | [NAME]
 | 900 | 48 | 50 | 53 | 55 | 57 | 59 | 62 | 64 | 66 | 68 | 71 | 73 | 75 | 76 |  | Dune
 | 1000 | 49 | 51 | 54 | 56 | 59 | 61 | 64 | 66 | 69 | 71 | 74 | 76 | 79 | 80 |  | White Birch
 | 1100 | 50 | 53 | 55 | 58 | 61 | 63 | 66 | 69 | 71 | 74 | 77 | 80 | 82 | 84 |  | Ultra Silver
 | 1200 | 51 | 54 | 57 | 60 | 63 | 65 | 68 | 71 | 74 | 77 | 80 | 83 | 86 | 87 |  | Merino/ Paperbark
 | 1300 | 52 | 55 | 58 | 61 | 64 | 68 | 71 | 74 | 77 | 80 | 83 | 86 | 89 | 91 |  | Anodic Natural [NAME]
 | 1400 | 53 | 56 | 60 | 63 | 66 | 70 | 73 | 76 | 80 | 83 | 86 | 90 | 93 | 95 |  | Anotec [NAME]
 | 1500 | 54 | 57 | 61 | 65 | 68 | 72 | 75 | 79 | 82 | 86 | 89 | 93 | 96 | 98 |  | APO Grey
 | 1600 | 55 | 59 | 62 | 66 | 70 | 74 | 77 | 81 | 85 | 89 | 92 | 96 | 100 | 102 |  | Charcoal
 | 1700 | 56 | 60 | 64 | 68 | 72 | 76 | 80 | 84 | 88 | 92 | 96 | 100 | 103 | 105 |  | Deep Ocean
 | 1800 | 57 | 61 | 65 | 69 | 74 | 78 | 82 | 86 | 90 | 94 | 99 | 103 | 107 | 109 |  | [NAME]
 | 1900 | 58 | 62 | 67 | 71 | 76 | 80 | 84 | 89 | 93 | 97 | 102 | 106 | 111 | 113 |  | Jasper
 | 2000 | 59 | 64 | 68 | 73 | 77 | 82 | 87 | 91 | 96 | 100 | 105 | 109 | 114 | 116 |  | Stone Beige
 | 2100 | 60 | 65 | 70 | 74 | 79 | 84 | 89 | 94 | 98 | 103 | 108 | 113 | 118 | 120 |  | Anotec Silver Grey
 | 2200 | 61 | 66 | 71 | 76 | 81 | 86 | 91 | 96 | 101 | 106 | 111 | 116 | 121 | 124 |  | [NAME]
 | 2300 | 62 | 67 | 72 | 78 | 83 | 88 | 93 | 99 | 104 | 109 | 114 | 119 | 125 | 127 |  | Champagne
 | 2400 | 63 | 68 | 74 | 79 | 85 | 90 | 96 | 101 | 106 | 112 | 117 | 123 | 128 | 131 |  | Clear Ano
 | 2500 | 64 | 70 | 75 | 81 | 87 | 92 | 98 | 104 | 109 | 115 | 120 | 126 | 132 | 135 |  | [NAME]
 | 2600 | 65 | 71 | 77 | 83 | 88 | 94 | 100 | 106 | 112 | 118 | 124 | 129 | 135 | 138 |  | Notre Dame
 | 2700 | 66 | 72 | 78 | 84 | 90 | 96 | 102 | 108 | 115 | 121 | 127 | 133 | 139 | 142 |  | Pottery
 | 2800 | 67 | 73 | 80 | 86 | 92 | 98 | 105 | 111 | 117 | 124 | 130 | 136 | 142 | 145 |  | [NAME]
 | 2900 | 68 | 75 | 81 | 87 | 84 | 100 | 107 | 113 | 120 | 126 | 133 | 139 | 146 | 149 |  | Custom colours are available POA
 | 3000 | 69 | 76 | 82 | 89 | 96 | 103 | 109 | 116 | 123 | 129 | 136 | 143 | 149 | 153