Spreadsheet: 860120d1708347905-formula-that-populates-if-1-4-columns-are-populated-copy-of-amnesty-value-exchange-pricing-calculator
Sheet: Sheet1

Value Exchange Pricing Calculator
[NAME]
354 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 |  |  |  | 25
Min send charge | 125 |  |  |  | 150 |  |  |  | Min over 350 copies per batch
Letter Print | 0.12 | 354 |  | Letter | 0.15 | 354
Poster [NAME] | 0.13 | 354 |  | Poster [NAME] | 0.16 | 354
Enclosing | 0.05 | 354 |  | Enclosing | 0.06 | 354
Total
Postage | 0.75 | 354 |  |  | 0.75
[NAME]
289 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 |  |  |  | 25
Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 289 |  | Letter | 0.15 | 289
Poster [NAME] | 0.13 | 289 |  | Poster [NAME] | 0.16 | 289
Enclosing | 0.05 | 289 |  | Enclosing | 0.06 | 289
Total |  |  |  |  |  |  |  |  | Min charge
 |  |  | 125 |  |  |  | 150
Postage | 0.75 | 289 |  |  | 0.75
[NAME]
118 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 |  |  |  | 25
Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 118 |  | Letter | 0.15 | 118
Poster [NAME] | 0.13 | 118 |  | Poster [NAME] | 0.16 | 118
Enclosing | 0.05 | 118 |  | Enclosing | 0.06 | 118
Total
 |  |  | 125 |  |  |  | 150
Postage | 0.75 | 118 |  |  | 0.75
[NAME] |  |  |  |  |  |  |  |  | [NAME]
33 | VR | Qty |  |  | TPH | Qty |  |  | 697 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 |  |  |  | 25 |  |  |  | [NAME] | 20 |  |  |  | 25
Min send charge | 125 |  |  |  | 150 |  |  |  | Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 33 |  | Letter | 0.15 | 33 |  |  | Letter Print | 0.12 | 697 |  | Letter | 0.15 | 697
Poster [NAME] | 0.13 | 33 |  | Poster [NAME] | 0.16 | 33 |  |  | Enclosing | 0.2 | 697 |  | Enclosing | 0.24 | 697
Enclosing | 0.05 | 33 |  | Enclosing | 0.06 | 33 |  |  | Total
Total
 |  |  | 125 |  |  |  | 150 |  |  |  |  | 125 |  |  |  | 150
Postage | 0.75 | 33 |  |  | 0.75 |  |  |  | Postage | 0.75 | 697 |  |  | 0.75
[NAME] |  |  |  |  |  |  |  |  | [NAME]
17 | VR | Qty |  |  | TPH | Qty |  |  | 282 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 |  |  |  | 25 |  |  |  | [NAME] | 20 |  |  |  | 25
Min send charge | 125 |  |  |  | 150 |  |  |  | Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 17 |  | Letter | 0.15 | 17 |  |  | Letter Print | 0.12 | 282 |  | Letter | 0.15 | 282
Poster [NAME] | 0.13 | 17 |  | Poster [NAME] | 0.16 | 17 |  |  | Enclosing | 0.2 | 282 |  | Enclosing | 0.24 | 282
Enclosing | 0.05 | 17 |  | Enclosing | 0.06 | 17 |  |  | Total
Total
 |  |  | 125 |  |  |  | 150 |  |  |  |  | 125 |  |  |  | 150
Postage | 0.89 | 17 |  |  | 0.89 | 17 |  |  | Postage | 0.89 | 282 |  |  | 0.89 | Hi
[NAME] |  |  |  |  |  |  |  |  | [NAME]
154 | VR | Qty |  |  | TPH | Qty |  |  | 263 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 | 154 |  |  | 25 |  |  |  | [NAME] | 20 | 263 |  |  | 25
Min send charge | 125 |  |  |  | 150 |  |  |  | Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 154 |  | Letter | 0.15 | 154 |  |  | Letter Print | 0.12 | 263 |  | Letter | 0.15 | 263
Poster [NAME] | 0.13 | 154 |  | Poster [NAME] | 0.16 | 154 |  |  | Enclosing letter, sticker sheet and A6 booklet | 0.2 | 263 |  | Enclosing letter, sticker sheet and A6 booklet | 0.24 | 263
Enclosing | 0.05 | 154 |  | Enclosing | 0.06 | 154 |  |  | Total
Total
 |  |  | 125 |  |  |  | 150 |  |  |  |  | 125 |  |  |  | 150
Postage | 0.89 | 154 |  |  | 0.89 |  |  |  | Postage | 0.89 | 263 |  |  | 0.89
[NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
93 | VR | Qty |  |  | TPH | Qty |  |  | 62 | VR | Qty |  |  | TPH | Qty |  |  | 247 | VR | Qty |  |  | TPH | Qty
[NAME] | 20 | 93 |  |  | 25 |  |  |  | [NAME] | 20 | 62 |  |  | 25 |  |  |  | [NAME] | 20 | 247 |  |  | 25
Min send charge | 125 |  |  |  | 150 |  |  |  | Min send charge | 125 |  |  |  | 150 |  |  |  | Min send charge | 125 |  |  |  | 150
Letter Print | 0.12 | 93 |  | Letter | 0.15 | 93 |  |  | Letter Print | 0.12 | 62 |  | Letter | 0.15 | 62 |  |  | Letter Print | 0.12 | 247 |  | Letter | 0.15 | 247
Poster [NAME] | 0.13 | 93 |  | Poster [NAME] | 0.16 | 93 |  |  | Enclosing letter, sticker sheet and A6 booklet | 0.2 | 62 |  | Enclosing letter, sticker sheet and A6 booklet | 0.24 | 62 |  |  | Enclosing letter and calendar | 0.2 | 247 |  | Enclosing | 0.24 | 247
Enclosing | 0.05 | 93 |  | Enclosing | 0.06 | 93 |  |  | Total |  |  |  |  |  |  |  |  | Total
Total
 |  |  | 125 |  |  |  | 150 |  |  |  |  | 125 |  |  |  | 150 |  |  |  |  | 125 |  |  |  | 150
Postage | 0.89 | 93 |  |  | 0.89 |  |  |  | Postage | 0.89 | 62 |  |  | 0.89 |  |  |  | Postage | 0.89 | 247 |  |  | 0.89
LAST BATCH TO BILL