Spreadsheet: 752506d1634810163-add-a-cell-value-to-populate-columns-ex1
Sheet: Data Set

 | SET PRODUCT CODE |  | Stock item | [NAME] | QTY P/PACK | [NAME] | EOM - STOCK LEVEL | EOM - STOCK VALUE | Unit Cost | Pack Cost | QTY | PRICE
 |  | CLICKS | B/W |  |  |  |  |  | 0.007 |  | 0
 |  |  | COLOUR |  |  |  |  |  | 0.03 |  | 0
 | 8774477 PP | CARD STOCK | 340gsm Avocet Digital | SRA3 | 125 | PLAIN | 0 |  |  | 18 | 0
 | 56021 |  | 300gsm PLAIN | SRA3 | 125 | PLAIN | 0 |  |  | 12.99 | 0
 | 53336 |  | 300gsm SILK | SRA3 | 125 | SILK | 0 |  |  | 24.99 | 0
 | 84419 | STRAW BOARD | 980gsm Straw Board | 450x600 | 100 | ESKABOARD PK33 | 0 |  |  | 59.95 | 0
 | 95341 | COLOURED CARD | 160gsm Deep Green | SRA2 | 250 | PLAIN | 0 |  |  | 45 | 0
 | 95325 |  | 160gsm Pale Blue | SRA2 | 250 | PLAIN | 0 |  |  | 42.99 | 0
 | 97166 |  | 160gsm Pale Green | SRA2 | 250 | PLAIN | 0 |  |  | 42.99 | 0
 | 95326 |  | 160g Lilac | SRA2 | 250 | PLAIN | 0 |  |  | 42.99 | 0
 | 95327 |  | 160g PINK | SRA2 | 250 | PLAIN | 0 |  |  | 42.99 | 0
 | 62677 | PLAIN PAPER | 100 gsm | A3 | 500 | PLAIN | 0 |  |  | 6.95 | 0
 | 29453 |  | 100 gsm | SRA3 | 500 | PLAIN | 0 |  |  | 11.45 | 0
 | 89653 |  | 100gsm YELLOW | A3 | 500 | PLAIN | 0 |  |  | 7.25 | 0
 | 45896 | SILK PAPER | 100gsm | SRA3 | 500 | SILK | 0 |  |  | 21 | 0
 | 45920 |  | 130gsm | SRA3 | 500 | SILK | 0 |  |  | 15.55 | 0
 | 45965 |  | 200gsm | SRA3 | 500 | SILK | 0 |  |  | 22.75 | 0
 | 53335 |  | 250gsm | SRA3 | 500 | SILK | 0 |  |  | 31 | 0
 |  | STAPLES | 14YH | N/A |  | N/A |  |  | 0.01 |  | 0
 | 83603 | NCR STOCK - ALL NCR STOCK IS MIN ORDER 2500(5X500) | White (Xerox) | A4 | 2500 | Coated Back | 0 |  |  | 51 | 0
 | 83686 |  | Pink (Xerox) | A4 | 2500 | Coated Front | 0 |  |  | 51 | 0
 | 83685 |  | Blue (Xerox) | A4 | 2500 | Coated Front | 0 |  |  | 51 | 0
 | 83687 |  | Yellow (Xerox) | A4 | 2500 | Coated Front | 0 |  |  | 51 | 0
 | 71307 |  | Pink (Xerox) | A4 | 2500 | Coated Front/Back | 0 |  |  | 51 | 0
 | 83688 |  | Blue (Xerox) | A4 | 2500 | Coated Front/Back | 0 |  |  | 51 | 0
 | 83691 |  | Yellow (Xerox) | A4 | 2500 | Coated Front/Back | 0 |  |  | 51 | 0
 | LAPA4BK | FOLDERS | Black Lever Arch | A4 | 10 | N/A | 0 |  |  | 11.15 | 0
 | 2RBA4BK |  | Black Ring Binder | A4 | 10 | N/A | 0 |  |  | 5.5 | 0
 | KF00501 | MISC | Black Backing Card | A4 | 100 | N/A | 0 |  |  | 7.95 | 0
 | KF00500 |  | Blue Backing Card | A4 | 100 | N/A | 0 |  |  | 7.95 | 0
 | BCA4150 |  | Clear PVC Covers | A4 | 100 | N/A | 0 |  |  | 3.99 | 0
 |  |  | 152MM Treasury Tag | 152mm | 100 | N/A | 0 |  |  | 2.99 | 0
 | CALHANBARWH |  | Calendar Hangar Bar | 76[NAME] | 100 | WHITE | 0 |  |  | 12.99 | 0
 | CALHANBARBK |  | Calendar Hangar Bar | 57mm | 100 | BLACK | 0 |  |  | 12.99 | 0
 | BB53489 | COMB BINDS | 28mm [NAME] | A4 | 50 | BLACK | 0 |  |  | 34.95 | 0
 | 936763 |  | 25mm [NAME] | A4 | 50 | BLACK | 0 |  |  | 19.95 | 0
 | 936758 |  | 25mm [NAME] | A4 | 50 | WHITE | 0 |  |  | 19.95 | 0
 | 936771 |  | 20mm [NAME] | A4 | 100 | BLACK | 0 |  |  | 22.95 | 0
 | BB53477 |  | 19mm [NAME] | A4 | 100 | BLACK | 0 |  |  | 14.99 | 0
 | KF24024 |  | 16mm [NAME] | A4 | 100 | BLACK | 0 |  |  | 12.99 | 0
 | 334773 |  | 14mm [NAME] | A4 | 100 | WHITE | 0 |  |  | 12.99 | 0
 | 330739 |  | 12mm [NAME] | A4 | 100 | WHITE | 0 |  |  | 12.99 | 0
 | KF24020 |  | 10mm [NAME] | A4 | 100 | WHITE | 0 |  |  | 11.99 | 0
 | 330658 |  | 8mm [NAME] | A4 | 100 | WHITE | 0 |  |  | 9.95 | 0
 | KF24018 |  | 8mm [NAME] | A4 | 100 | BLACK | 0 |  |  | 9.95 | 0
 | 330658 |  | 6mm [NAME] | A4 | 100 | WHITE | 0 |  |  | 7.95 | 0
 | N/A | WIRE BINDS | 14mm Wire Bind | A5 | 100 | BLACK | 0 |  |  | 49.95 | 0
 | BB53277 |  | 14mm Wire Bind | A4 | 100 | BLACK | 0 |  |  | 49.95 | 0
 | N/A |  | 14mm Wire Bind | A4 | 100 | WHITE | 0 |  |  | 49.95 | 0
 | BB53273 |  | 12mm Wire Bind | A4 | 250 | BLACK | 0 |  |  | 21.95 | 0
 | 449011 |  | 12mm Wire Bind | A4 | 250 | WHITE | 0 |  |  | 21.95 | 0
 | N/A |  | 9mm Wire Bind | A5 | 150 | WHITE | 0 |  |  | 21.95 | 0
 | BB53265 |  | 9mm Wire Bind | A4 | 150 | BLACK | 0 |  |  | 21.95 | 0
 | GB21703 |  | 6mm Wire Bind | A5 | 250 | BLACK | 0 |  |  | 18 | 0
 | N/A |  | 5mm Wire Bind | A5 | 250 | BLACK | 0 |  |  | 18 | 0
 | [NAME] | ENVELOPES | [NAME] | C4 | 250 | WO/Window | 0 |  |  | 7.95 | 0
 | EC5WSPS |  | [NAME] | C5 | 500 | WO/Window | 0 |  |  | 8.95 | 0
 | EC6WSWH |  | [NAME] | C6 | 1000 | W/Window | 0 |  |  | 14.95 | 0
 | EC6WSPS |  | [NAME] | C6 | 1000 | WO/Window | 0 |  |  | 11.45 | 0
 | EDLWSPS |  | [NAME] | DL | 1000 | WO/Window | 0 |  |  | 8.49 | 0
 | LPA4150 | LAMINATES | A4 Clear Gloss Pouch | A4 | 100 | 150 mic | 0 |  |  | 5.95 | 0
 | [NAME] |  | A3 Clear Gloss Pouch | A3 | 100 | 150 mic | 0 |  |  | 9.95 | 0
 |  |  | [NAME] | 305mm | 2 | 75 mic 305mmx100m 25mm core -FK2N2 | 0 |  |  | 0 | 0
 |  |  | Gloss Laminate Roll | 305mm | 2 |  | 0 |  |  | 0 | 0
 | DIVAZMAN | DIVIDERS | A-Z Dividers | A4 | Each | N/A | 0 |  | 0.45 | 0.45 | 0
 | [NAME] |  | 1-10 Dividers | A4 | Each | N/A | 0 |  | 0.99 | 0.99 | 0
 | [NAME] |  | 1-15 Dividers | A4 | Each | N/A | 0 |  | 0.99 | 0.99 | 0
 | DIVP120 |  | 1-20 Dividers | A4 | Each | N/A | 0 |  | 0.99 | 0.99 | 0
 | DIVP131 |  | 1-31 Dividers | A4 | Each | N/A | 0 |  | 1.29 | 1.29 | 0
 | DIV10MAN |  | Coloured Dividers | A4 | Each | N/A | 0 |  | 0.49 | 0.49 | 0
 | STORBOX | PACKING | A3 Packing Boxes | A3 | 100 | N/A | 0 |  |  | 12.5 | 0
 | 70038 |  | Brown Wrapping Paper | 900x225mm | Each | 90gsm | 0 |  | 0 | 49.95 | 0
 | SO10409 |  | A4 50mm Carton | A4 | 10 | N/A | 0 |  |  | 11.85 | 0
 | SO10417 |  | A4 100mm Carton | A4 | 10 | N/A | 0 |  |  | 15.9 | 0
 | BB00791 |  | Fellowes Banker Box | / | 10 | N/A | 0 |  |  | 58.65 | 0
 | 46582 AN |  | Business card Boxes | / | 125 | PLASTIC | 0 |  |  | 69 | 0
 | A1032 |  | Sellotape | Normal | 6 | N/A | 0 |  |  | 0.79 | 0 | 0
 | A1034 |  | Clear Packing Tape | Wide | 6 | N/A | 0 |  |  | 0.99 | 0
 | A1042 |  | Brown Packing Tape | Wide | 6 | N/A | 0 |  |  | 0.99 | 0
 |  |  |  | EOM STOCK VALUATION TOTAL =
 |  |  | Pay |  |  |  |  |  | 0.0121
 |  |  | Subtotal before markup
 |  |  | [NAME] / Profit |  |  |  |  |  | 0.3
 |  |  | VAT |  |  |  |  |  | 0.2
 |  |  |  |  |  | With VAT & Markup |  |  | CASH EXTERNAL & ACCOUNTS
 |  |  |  |  |  | No VAT or [NAME] |  |  | INTERNAL WORK
 |  |  |  |  |  | No VAT with [NAME] |  |  | EXTERNAL WORK