Spreadsheet: 272956d1382555177-auto-populate-a-cell-best-light-images
Sheet: STOCK

NO | CATEGORY | STOCK ID | [NAME] | UNIT COST | STOCK | QUANTITY | STOCK VALUE | RETAIL PRICE | RETAIL STOCK VALUE | SALES | TOTAL SALES | PURCHASES
1 | A5 Cards | A5-001 | 199 Steps Whitby [NAME] | 0.3 |  | 6 |  | 2.5
2 | A5 Cards | A5-002 | [NAME] | 0.3 |  | 6 |  | 2.5
3 | A5 Cards | A5-003 | Bengali Eagle Owl A5 Card | 0.3 |  | 6 |  | 2.5
4 | A5 Cards | A5-004 | Candle - Season Greetings A5 Card | 0.3 |  | 6 |  | 2.5
5 | A5 Cards | A5-005 | Cloud Inversion A5 Card | 0.3 |  | 5 |  | 2.5
6 | A5 Cards | A5-006 | Duke Of Portland A5 Card | 0.3 |  | 6 |  | 2.5
7 | A5 Cards | A5-007 | [NAME] | 0.3 |  | 7 |  | 2.5
8 | A5 Cards | A5-008 | Golden Hardraw A5 Card | 0.3 |  | 4 |  | 2.5
9 | A5 Cards | A5-009 | Hardy Ponies [NAME] | 0.3 |  | 6 |  | 2.5
10 | A5 Cards | A5-010 | Hartsop Barn A5 Card | 0.3 |  | 3 |  | 2.5
11 | A5 Cards | A5-011 | Hartsop Cottage A5 Card | 0.3 |  | 4 |  | 2.5
12 | A5 Cards | A5-012 | Hawes In Winter - Merry Christmas A5 Card | 0.3 |  | 8 |  | 2.5
13 | A5 Cards | A5-013 | Hawes In Winter A5 Card | 0.3 |  | 6 |  | 2.5
14 | A5 Cards | A5-014 | Healaugh Bridge A5 Card | 0.3 |  | 6 |  | 2.5
15 | A5 Cards | A5-015 | High Dam A5 Card | 0.3 |  | 1 |  | 2.5
16 | A5 Cards | A5-016 | Highland Cow A5 Card | 0.3 |  | 6 |  | 2.5
17 | A5 Cards | A5-017 | Keld Views A5 Card | 0.3 |  | 6 |  | 2.5
18 | A5 Cards | A5-018 | [NAME] | 0.3 |  | 6 |  | 2.5
19 | A5 Cards | A5-019 | [NAME] Uist A5 Card | 0.3 |  | 6 |  | 2.5
20 | A5 Cards | A5-028 | [NAME] | 0.3 |  | 6 |  | 2.5
21 | A5 Cards | A5-021 | Millennium Bridge A5 Card | 0.3 |  | 1 |  | 2.5
22 | A5 Cards | A5-022 | Muker Tea Shop [NAME] | 0.3 |  | 6 |  | 2.5
23 | A5 Cards | A5-023 | Muker To Keld A5 Card | 0.3 |  | 6 |  | 2.5
24 | A5 Cards | A5-024 | Muker Tree A5 Card | 0.3 |  | 7 |  | 2.5
25 | A5 Cards | A5-025 | Rays Of Light A5 Card | 0.3 |  | 6 |  | 2.5
26 | A5 Cards | A5-026 | [NAME] | 0.3 |  | 6 |  | 2.5
27 | A5 Cards | A5-027 | Richmond Castle A5 Card | 0.3 |  | 3 |  | 2.5
28 | A5 Cards | A5-020 | Robin - Season Greetings A5 Card | 0.3 |  | 5 |  | 2.5
29 | A5 Cards | A5-029 | [NAME] Bay A5 Card | 0.3 |  | 6 |  | 2.5
30 | A5 Cards | A5-030 | [NAME] | 0.3 |  | 4 |  | 2.5
31 | A5 Cards | A5-031 | Season Greetings - Robin A5 Card | 0.3 |  | 1 |  | 2.5
32 | A5 Cards | A5-032 | Swaledale Views A5 Card | 0.3 |  | 6 |  | 2.5
33 | A5 Cards | A5-033 | The Millennium Cairn A5 Card | 0.3 |  | 6 |  | 2.5
34 | A5 Cards | A5-034 | Tyne Bridge A5 Card | 0.3 |  | 1 |  | 2.5
35 | A5 Cards | A5-035 | [NAME] | 0.3 |  | 6 |  | 2.5
36 | A5 Cards | A5-036 | Wainwath Force A5 Card | 0.3 |  | 6 |  | 2.5
37 | A5 Cards | A5-037 | [NAME] | 0.3 |  | 6 |  | 2.5
38 | A6 Cards | A6-001 | 199 Steps Whitby [NAME] | 0.71 |  | 2 |  | 1.45
39 | A6 Cards | A6-002 | Admiral [NAME] A6 Card | 0.71 |  | 7 |  | 1.45
40 | A6 Cards | A6-003 | Angle Tarn A6 Card | 0.71 |  | 7 |  | 1.45
41 | A6 Cards | A6-004 | Blea Tarn 5 Stones A6 Card | 0.71 |  | 7 |  | 1.45
42 | A6 Cards | A6-005 | Blea Tarn Autumn A6 Card | 0.71 |  | 5 |  | 1.45
43 | A6 Cards | A6-006 | Blea Tarn Black White A6 Card | 0.71 |  | 7 |  | 1.45
44 | A6 Cards | A6-007 | Blea Tarn Stone A6 Card | 0.71 |  | 6 |  | 1.45
45 | A6 Cards | A6-008 | Brothers Water A6 Card | 0.71 |  | 8 |  | 1.45
46 | A6 Cards | A6-009 | Buttermere Views A6 Card | 0.71 |  | 6 |  | 1.45
47 | A6 Cards | A6-010 | Buttermere Views Roots A6 Card | 0.71 |  | 5 |  | 1.45
48 | A6 Cards | A6-011 | Duke Of Portland A6 Card | 0.71 |  | 7 |  | 1.45
49 | A6 Cards | A6-012 | Glenridding [NAME] | 0.71 |  | 7 |  | 1.45
50 | A6 Cards | A6-013 | Gowbarrow A6 Card | 0.71 |  | 8 |  | 1.45
51 | A6 Cards | A6-014 | Grasmere [NAME] | 0.71 |  | 3 |  | 1.45
52 | A6 Cards | A6-015 | Grosmont Steam Train 44871 A6 Card | 0.71 |  | 4 |  | 1.45
53 | A6 Cards | A6-016 | Grosmont Steam Train 45428 A6 Card | 0.71 |  | 6 |  | 1.45
54 | A6 Cards | A6-017 | High Dam A6 Card | 0.71 |  | 5 |  | 1.45
55 | A6 Cards | A6-018 | Holy Trinity Church A6 Card | 0.71 |  | 6 |  | 1.45
56 | A6 Cards | A6-019 | [NAME] | 0.71 |  | 7 |  | 1.45
57 | A6 Cards | A6-020 | London Routemaster A6 Card | 0.71 |  | 7 |  | 1.45
58 | A6 Cards | A6-021 | Masham Steam Engine Blue Red A6 Card | 0.71 |  | 8 |  | 1.45
59 | A6 Cards | A6-022 | Masham Steam Engine Duke [NAME] | 0.71 |  | 8 |  | 1.45
60 | A6 Cards | A6-023 | Masham Steam Engine Green A6 Card | 0.71 |  | 5 |  | 1.45
61 | A6 Cards | A6-024 | Masham Steam Engine Green Red A6 Card | 0.71 |  | 7 |  | 1.45
62 | A6 Cards | A6-025 | Ribblehead Station A6 Card | 0.71 |  | 8 |  | 1.45
63 | A6 Cards | A6-026 | Ribblehead Viaduct A6 Card | 0.71 |  | 2 |  | 1.45
64 | A6 Cards | A6-027 | Richmond Obelisk A6 Card | 0.71 |  | 7 |  | 1.45
65 | A6 Cards | A6-028 | [NAME] | 0.71 |  | 5 |  | 1.45
66 | A6 Cards | A6-029 | Sir [NAME] | 0.71 |  | 1 |  | 1.45
67 | A6 Cards | A6-030 | The Dairy A6 Card | 0.71 |  | 5 |  | 1.45
68 | A6 Cards | A6-031 | The Quiraing A6 Card | 0.71 |  | 7 |  | 1.45
69 | A6 Cards | A6-032 | Ullswater [NAME] | 0.71 |  | 8 |  | 1.45
70 | A6 Cards | A6-033 | Whitby 199 Steps A6 Card | 0.71 |  | 5 |  | 1.45
71 | A6 Cards | A6-034 | [NAME] Tarn A6 Card | 0.71 |  | 8 |  | 1.45
72 | Clock | CLOCK-001 | Keld Views Clock | 12 |  | 1 |  | 25
73 | Clock | CLOCK-002 | Wintery Swaledale Clock | 12 |  | 1 |  | 25
74 | Coaster | COASTER-001 | Keld Views Coaster | 4 |  | 1 |  | 6
75 | Jigsaw | JIGSAW-001 | Keld Views Jigsaw | 10 |  | 1 |  | 15
76 | Laminate Blocks | LAMBLOCK-001 | Blea Tarn Black White Laminated Block | 5 |  | 1 |  | 15
77 | Laminate Blocks | LAMBLOCK-002 | Hartsop Barn Laminated Block | 5 |  | 2 |  | 15
78 | Laminate Blocks | LAMBLOCK-003 | Keld Views Laminated Block | 5 |  | 1 |  | 15
79 | Laminate Blocks | LAMBLOCK-004 | Wintery Swaledale Laminated Block | 5 |  | 2 |  | 15
80 | [NAME] | MUG-001 | [NAME] | 4 |  | 1 |  | 8
81 | Ovals | OVALS-001 | Hartsop Barn Oval | 8 |  | 1 |  | 18
82 | Phone Cases | IPHONE4-001 | Keld Views Iphone 4 Case | 5 |  | 1 |  | 12
83 | Slate | SLATE-002 | Keld Views Slate | 7 |  | 2 |  | 15
84 | Slate | SLATE-001 | Wintery Swaledale Slate | 7 |  | 1 |  | 15
85 | [NAME] | WOOD-001 | Keld Views Wooden Block | 12 |  | 1 |  | 25
86 | 8 x 6 Mounted Image | 8x6-001 | Holy Trinity Church 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
87 | 8 x 6 Mounted Image | 8x6-002 | [NAME] x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
88 | 8 x 6 Mounted Image | 8x6-003 | Keld Views 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
89 | 8 x 6 Mounted Image | 8x6-004 | Swanage Pier 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
90 | 8 x 6 Mounted Image | 8x6-005 | Dayspring 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
91 | 8 x 6 Mounted Image | 8x6-006 | The Green Knight 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
92 | 8 x 6 Mounted Image | 8x6-007 | Sleeping Class Only 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
93 | 8 x 6 Mounted Image | 8x6-008 | Black Nab 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
94 | 8 x 6 Mounted Image | 8x6-009 | Admiral [NAME] 8 x 6 Mounted Image | 0.15 |  | 1 |  | 3.5
95 | 8 x 6 Mounted Image | 8x6-010 | [NAME] x 6 Mounted Image | 0.15 |  | 1 |  | 3.5