Spreadsheet: 96210d1295621311-formula-to-count-editions-of-999-and-return-a-no-n1kk1-sequence-numbers-test
Sheet: Print orders

print - orders
Client ref | print ref | Artist | Description | Artist price | Our Premium | Frame | frame colour | mount (ins) | paper border (no mount) | frame size | Frame size (cm) | print size (cm) | Glazing | Limited Edition / Open | Editions | No. |  | Sizing code | frame size (cms | Print size (cms
Sample | SM007 | [NAME] | She creates terror |  |  | High-end | White | 5 inches | - | Medium | 86 x 76 | 73.3 x 63.3 | Acrylic | L/E | 999 | 1 |  | Small | 61 x 51 | 53.4 x 43.4
Sample | SM002 | [NAME] | Super Fashion Victim |  |  | High-end | black | 5 inches | - | Large | 122 x 92 | 109.3 x 79.3 | Acrylic | L/E | 999 | 1 |  | Small - square | 51 x 51 | 43.4 x 43.4
Sample | SM002 | [NAME] | Super Fashion Victim |  |  | [NAME] | black | - | - | Medium | 86 x 76 | 73.3 x 63.3 | - | Open |  | 2 |  | Medium | 86 x 76 | 73.3 x 63.3
Sample | SM015 | [NAME] | Celebrate my desire |  |  | Mid range | grey | 5 inches | - | Small | 61 x 51 | 53.4 x 43.4 | [NAME] | Open |  | 1 |  | Medium - square | 92 x 92 | 79.5 x 79.5
Sample | CM014 | [NAME] | View of Gherkin |  |  | Mid range | black | 5 inches | - | Medium | 86 x 76 | 73.3 x 63.3 | [NAME] | Open |  | 1 |  | Large | 122 x 92 | 109.3 x 79.3
Sample | CM002 | [NAME] | Manhattan |  |  | Mid range | black | 5 inches | - | Medium - square | 92 x 92 | 79.5 x 79.5 | [NAME] | Open |  | 1
Sample | DW001 | [NAME] | Porthmeor beach st ives |  |  | Ornate |  | 5 inches | - | Medium - square | 92 x 92 | 79.5 x 79.5 | [NAME] | Open |  | 1 |  | Small print size includes 3 inch border
Sample | DW020 | [NAME] | St Ives Harbour No. 6 |  |  | Canvas | White | 5 inches | - | Medium - square | 92 x 92 | 79.5 x 79.5 | - | Open |  | 1 |  | medum/large print size includes 5 inch border
Sample | DH006 | [NAME] | Untitled A |  |  | Canvas | Black | 5 inches | - | Medium | 86 x 76 | 73.3 x 63.3 |  | Open | 999 | 1
Sample | DH002 | [NAME] | Untitled 2 |  |  | High-end | White | 5 inches | - | Medium | 86 x 76 | 73.3 x 63.3 | Acrylic | L/E | 999 | 1
Sample | EA002 | [NAME] | Pink Riders |  |  | High-end | White | 5 inches | - | Medium | 86 x 76 | 73.3 x 63.3 | [NAME] | L/E | 999 | 1
Sample | EA007 | [NAME] | Can you feel the force |  |  | Mid range | Grey | 5 inches | - | Small | 61 x 51 | 53.4 x 43.4 | [NAME] | Open |  | 1
Sample | EV001 | [NAME] | Blackdrop |  |  | Mid range | Grey | 5 inches | - | Medium - square | 92 x 92 | 79.5 x 79.5 | [NAME] | Open |  | 1
Sample | EV003 | [NAME] | Death of a Nymph |  |  | canvas | white | - | - | Medium - square | 92 x 92 | 79.5 x 79.5 | - | Open |  | 1
Sample | IS010 | Ines Szamrey | Pink Fruits 2 |  |  | low-range | White | - | 5 inches | Medium - square | 92 x 92 | 79.5 x 79.5 | perspex | Open |  | 1
Sample | IS007 | Ines Szamrey | Orange |  |  | low-range | White | - | 5 inches | Medium | 86 x 76 | 73.3 x 63.3 | perspex | Open |  | 1
Sample | IS016 | Ines Szamrey | Blue & Green Fruits 3 |  |  | low-range | White | - | 5 inches | Medium - square | 92 x 92 | 79.5 x 79.5 | perspex | Open |  | 1
Sample | MC009 | [NAME] | The Big Wave |  |  | low-range | black |  | 3 inches | small | 61 x 51 | 53.4 x 43.4 | perspex | Open |  | 1
Sample | MC008 | [NAME] | That’s my girl |  |  | low-range | black |  | 2 inches | small | 61 x 51 | 53.4 x 43.4 | perspex | Open |  | 1
Sample | MC003 | [NAME] | Dog |  |  | low-range | black |  | 3 inches | small | 61 x 51 | 53.4 x 43.4 | perspex | Open |  | 1
Sample | MW006 | [NAME] | Pandemonium |  |  | Mid range | White | 5 inches | - | Large | 122 x 92 | 109.3 x 79.3 | Acrylic | Open |  | 1
Sample | PR007 | [NAME] | One nation in a groove |  |  | Mid range | White | 5 inches |  | Medium - square | 92 x 92 | 79.5 x 79.5 | [NAME] | Open |  | 1
Sample | PR008 | [NAME] | One Nation Peirrot |  |  | Mid range | Black | 5 inches |  | Medium - square | 92 x 92 | 79.5 x 79.5 | [NAME] | Open |  | 1
Sample | RE002 | [NAME] | Blackthorn Winter |  |  | High-end | Grey | 5 inches |  | Medium | 86 x 76 | 73.3 x 63.3 | Acrylic | L/E | 999 | 1
Sample | [NAME] | [NAME] | Taxi |  |  | low-range | black |  | 5 inches | Medium - square | 92 x 92 | 79.5 x 79.5 | perspex | Open |  | 1
Sample | SE003 | [NAME] | Routemaster |  |  | low-range | black |  | 5 inches | Medium - square | 92 x 92 | 79.5 x 79.5 | perspex | Open |  | 1
Sample | SE009 | [NAME] | Piccadilly Circus |  |  | low-range | black |  | 5 inches | Medium - square | 92 x 92 | 79.5 x 79.5 | perspex | Open |  | 1
Sample | SD001 | [NAME] | Zinger |  |  | Ornate | black | - |  | Medium | 86 x 76 | 73.3 x 63.3 | glass | Open |  | 1
Sample | SM001 | [NAME] | The Story So Far |  |  | Print only | - | - | - | - | #N/A | A0 print (33.11 × 46.81 ins) | - |  |  | 1
 |  | #N/A | #N/A |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  | #N/A | #N/A |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  | #N/A | #N/A |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  | #N/A | #N/A |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  | 0