Spreadsheet: 56444d1256641756-formula-to-return-value-for-several-names-art_test-1-
Sheet: Art log

 |  | Artist Log
 |  | Gallery | 0.45
 |  | Artist | 0.55
client  ref | Our Artist Ref | Invoice No. | Date | Artist ref | Artist | Description | Artist price | Our Premium | Sale Amount | SOLD | Date of  Sale | Deposit | [NAME] | Delivery Method | Delivery  cost | Artist  Profit | Gallery Profit | Date  returned
CL0001 | A0001 | AR0001 | 2013-10-02 00:00:00 |  | [NAME] | [NAME] |  |  | 0 | 1200 | 2009-02-01 00:00:00 |  |  |  |  | 660 | 540
CL0002 | A0001 | AR0002 | 2013-10-02 00:00:00 |  | [NAME] | Dollar Dollar |  |  | 0 | 3000 | 2009-01-25 00:00:00 |  |  |  |  | 1650 | 1350
 | A0003 | AR0003 | 2013-10-31 00:00:00 | F7 | [NAME] | F.7   Village Festival, Kerala 28x30" | 2500 |  | 2500 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0004 | 2013-10-31 00:00:00 | E32 | [NAME] | E.32 On Karriamuttam canal, Kerala   24" x 30 | 2100 |  | 2100 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0005 | 2013-10-31 00:00:00 | F39 | [NAME] | F.39 Colours of India, Kerala 30" x 30" | 2600 |  | 2600 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0006 | 2013-10-31 00:00:00 | E16 | [NAME] | E.16 Shimmering light, Venice 26" x 28" | 2200 |  | 2200 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0007 | 2013-10-31 00:00:00 | F26 | [NAME] | F.26 Landing stage, Venice 20" x 20" | 950 |  | 950 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0008 | 2013-10-31 00:00:00 | G10 | [NAME] | G.10 Early evening, [NAME] 26" x 28" | 2200 |  | 2200 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0009 | 2013-10-31 00:00:00 | G11 | [NAME] | G.11 Autumn light, [NAME] 26" x 28" | 2200 |  | 2200 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0010 | 2013-10-31 00:00:00 | E38 | [NAME] | [NAME] harbour 26" x 28" | 2100 |  | 2100 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0011 | 2013-10-31 00:00:00 | D26 | [NAME] | D.26 Olive trees, Deja 26" x 28" | 1900 |  | 1900 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0012 | 2013-10-31 00:00:00 |  | [NAME] | [NAME] Over Venetian Towers  Acrylic on Board  23x23cm | 750 |  | 750 | 100 | 2009-01-25 00:00:00 |  |  |  |  | 55.00000000000001 | 45
CL0013 | A0002 | AR0013 | 2013-10-31 00:00:00 |  | [NAME] | House of Gothic    Acrylic on Board 55x43cm | 1200 |  | 1200 | 850 | 2013-10-25 00:00:00 | 100 |  |  |  | 467.5000000000001 | 382.5
 | A0002 | AR0014 | 2013-10-31 00:00:00 |  | [NAME] | Infirmary Tower    Acrylic on Board  27x29cm | 850 |  | 850 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0015 | 2013-10-31 00:00:00 |  | [NAME] | Ruin Of Ury     Acrylic on Board 35x32cm | 850 |  | 850 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0016 | 2013-10-31 00:00:00 |  | [NAME] | [NAME], Aragon  Acrylic on Board 24x27cm | 800 |  | 800 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0017 | 2013-10-31 00:00:00 |  | [NAME] | Dazzleship    Acrylic on Board  37x113cm | 2500 |  | 2500 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0018 | 2013-10-31 00:00:00 |  | [NAME] | Trottenish Ridge , The Isle of Skye Oil on Board  80x122cm | 3000 |  | 3000 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0019 | 2013-10-31 00:00:00 |  | [NAME] | Centre Street, Tradeston   Acrylic on Board  28x38cm | 900 |  | 900 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0020 | 2013-10-31 00:00:00 |  | [NAME] | Queens View, The Campsies  Oil on Board  52x97cm | 1900 |  | 1900 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0021 | 2013-10-31 00:00:00 |  | [NAME] | North Sea Cliffs   Oil on Board  81x113cm | 2800 |  | 2800 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0022 | 2013-10-31 00:00:00 |  | [NAME] | Temple of Venus, Rome  Acrylic on Board 47x66cm | 1850 |  | 1850 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0023 | 2013-10-31 00:00:00 |  | [NAME] | Temple of Minerva, Rome, After [NAME].  --“--  21x23cm | 725 |  | 725 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0024 | 2013-10-31 00:00:00 |  | [NAME] | [NAME], Rome, After [NAME].  --“--  17x23cm | 690 |  | 690 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0025 | 2013-10-31 00:00:00 |  | [NAME] | Chateau Chenonceaux  Acrylicon Board 17x17cm | 590 |  | 590 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0026 | 2013-10-31 00:00:00 |  | [NAME] | [NAME] 33x39cm | 1100 |  | 1100 |  |  |  |  |  |  | 0 | 0
 | A0002 | AR0027 | 2013-10-31 00:00:00 |  | [NAME] | [NAME], Loire    Ink Drawing  17x23cm | 275 |  | 275 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0028 | 2013-10-31 00:00:00 | G3 | [NAME] | Indian street market, Mumbai 28x30 | 2500 |  | 2500 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0029 | 2013-10-31 00:00:00 | [NAME] | [NAME] | F10 blackwater reflections, kerala38x30 | 2500 |  | 2500 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0030 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | awakening - oil and gesso on canvas (76x76 cm) | 1275 |  | 1275 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0031 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | newland 38 - oil and gesso on canvas (60x60 cm) | 795 |  | 795 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0032 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | at dusk - oil and gesso on canvas (45.5 x 35.5 cm) | 355 |  | 355 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0033 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | newland 12 - oil and gesso on canvas (50x50 cm) | 550 |  | 550 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0034 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | newland 39 - oil and gesso on canvas (60x60 cm) | 795 |  | 795 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0035 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | newland 40 - oil and gesso on canvas (40x40 cm) | 350 |  | 350 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0036 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | yeelen - oil and gesso on canvas (51x40 cm) | 450 |  | 450 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0037 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | unspoken - oil and gesso on canvas (45.5 x 35.5 cm) | 355 |  | 355 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0038 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | sadland - oil and gesso on canvas (45.5 x 35.5 cm) | 355 |  | 355 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0039 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | pathway - oil and gesso on canvas (60x60 cm) | 795 |  | 795 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0040 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | desire - oil and gesso on canvas 60x70 cm) | 795 |  | 795 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0041 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | three tribes - oil and gesso on canvas (76x76 cm) | 1275 |  | 1275 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0042 | 2013-10-31 00:00:00 |  | [NAME] | the quest - oil and gesso on canvas (60x60 cm) | 795 |  | 795 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0043 | 2013-10-31 00:00:00 |  | [NAME] | land of the gaels - oil and gesso on canvas (100x100 cm) | 2200 |  | 2200 |  |  |  |  |  |  | 0 | 0
 | A0005 | AR0044 | 2013-10-31 00:00:00 |  | [NAME] Cavellec | metaphor I - oil and gesso on canvas (100x100 cm) | 2200 |  | 2200 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0045 | 2013-10-31 00:00:00 | F12 | [NAME] | F12.   Washing clothes on the bank, Kerala      12" x 10" | 750 |  | 750 |  |  |  |  |  |  | 0 | 0
 | A0003 | AR0046 | 2013-10-31 00:00:00 |  | [NAME] | F13.   Figure on the canal bank, Kerala             12" x 10" | 750 |  | 750 |  |  |  |  |  |  | 0 | 0
 | A0004 | AR0047 | 2013-09-25 00:00:00 |  | [NAME] | [NAME], Acrilic on canvas, 40 X 40 cm | 460 | 40 | 500 |  |  |  |  |  |  | 0 | 0
CL0014 | A0004 | AR0048 | 2013-09-25 00:00:00 |  | [NAME] | [NAME]", Acrilic on canvas, 40 X 40 cm | 460 | 40 | 500 | 500 |  |  |  |  |  | 275 | 225
 | A0004 | AR0049 | 2013-09-25 00:00:00 |  | [NAME] | Duras, Acrilic on canvas, 50 X 40 cm | 500 |  | 500 |  |  |  |  |  |  | 0 | 0
CL0012 | A0004 | AR0050 | 2013-09-25 00:00:00 |  | [NAME] | Maybe Deleuze", Acrilic on canvas, 50 X 40 cm | 500 |  | 500 | 500 |  |  |  |  |  | 275 | 225
 |  | AR0051 |  |  |  | 40 cm X 40 cm | 460 | 40 | 500 |  |  |  |  |  |  | 0 | 0
 |  | AR0052 |  |  |  | 40 cm X 40 cm | 460 | 40 | 500 |  |  |  |  |  |  | 0 | 0
 |  | AR0053 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | AR0054 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | AR0055 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 62210 | 160 | 62370 |  |  |  |  |  |  |  | 2767.5