Spreadsheet: 135397d1326019300-data-validation-trouble-book1
Sheet: Sheet1 (2)

DOOR |  | GLASS |  | GLASS COLOUR |  | BACKING PATTERN |  |  |  | Doors | cost | [NAME] set costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIMPLICITY | MACKINTOSH | ELEGANCE | SPIRIT | VIVARA | BRILLIANCE | PRAIRIE | DIAMOND | BEVEL_DIAMOND | CLASSIC | MURANO | GEORGIAN_BAR |  | Frame | Exterior_Colour | Interior_Colour
WINSTER | 459 | CLASSIC | 144 | NONE / CLEAR |  | #[NAME]? |  |  |  | CROMFORD | 425 | CROMFORD | COST | CHATSWORTH | COST | BRADBOURNE | COST | BRASSINGTON |  | HATHERSAGE | COST | MIDDLETON |  | MILLDALE |  | THORPE |  | WINSTER |  | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR | RED | NONE / CLEAR | NONE / CLEAR | RED | RED | RED | RED | NONE / CLEAR |  | WHITE | WHITE | WHITE
 |  |  |  |  |  |  |  |  |  | CHATSWORTH | 442 | SIMPLICITY | 117 | SIMPLICITY | 127 | MACKINTOSH | 107 | SIMPLICITY | 45 | SPIRIT | 203 | SIMPLICITY | 22 | SIMPLICITY | 120 | SIMPLICITY | 43 | SPIRIT | 218 |  |  |  |  | BLUE |  |  | BLUE | BLUE | BLUE | BLUE |  |  | OAK/WHITE | GREEN | GREEN
Exterior Colour |  | Interior Colour |  | Frame Colour |  |  |  |  |  | BRADBOURNE | 444 | MACKINTOSH | 121 | MACKINTOSH | 107 | SPIRIT | 162 | MACKINTOSH | 69 | MURANO | 245 | MURANO | 55 | MACKINTOSH | 147 | ELEGANCE | 43 | DIAMOND | 114 |  |  |  |  | BLACK |  |  | BLACK | BLACK | BLACK | BLACK |  |  | ROSEWOOD/WHITE | BLACK | BLACK
WHITE |  | WHITE |  | WHITE |  |  |  |  |  | BRASSINGTON | 417 | ELEGANCE | 128 | ELEGANCE | 141 | VIVARA | 184 | ELEGANCE | 49 | DIAMOND | 117 | STD_CLEAR | 19 | ELEGANCE | 131 | SPIRIT | 61 | BEVEL_DIAMOND | 174 |  |  |  |  | GREEN |  |  | GREEN | GREEN | GREEN | GREEN |  |  | BLACK/WHITE | BLUE | BLUE
 |  |  |  |  |  |  |  |  |  | HATHERSAGE | 461 | SPIRIT | 114 | SPIRIT | 162 | DIAMOND | 70 | SPIRIT | 76 | BEVEL_DIAMOND | 190 | SOLID | -18 | SPIRIT | 129 | VIVARA | 64 | CLASSIC | 239 |  |  |  |  | NONE / CLEAR |  |  | NONE / CLEAR | NONE / CLEAR | NONE / CLEAR |  |  |  | OAK/OAK | RED | RED
 |  |  |  |  |  |  |  |  |  | MIDDLETON | 428 | VIVARA | 143 | VIVARA | 184 | BEVEL_DIAMOND | 106 | VIVARA | 82 | CLASSIC | 252 |  |  | VIVARA | 159 | PRAIRIE | 43 | MURANO | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  | ROSEWOOD/ROSEWOOD | OAK | OAK
 |  |  |  |  |  |  |  |  |  | MILLDALE | 428 | BRILLIANCE | 91 | BRILLIANCE | 88 | CLASSIC | 200 | BRILLIANCE | 36 | STD_CLEAR | 73 |  |  | BRILLIANCE | 64 | DIAMOND | 58 | STD_CLEAR | 80 | SIMPLICITY | MACKINTOSH | ELEGANCE | SPIRIT | VIVARA | BRILLIANCE | PRAIRIE | DIAMOND | BEVEL_DIAMOND | CLASSIC | MURANO | STD_CLEAR | GEORGIAN_BAR | WHITE ASH | ROSEWOOD | ROSEWOOD
 |  |  |  |  |  |  |  |  |  | PILSLEY | 443 | PRAIRIE | 128 | PRAIRIE | 141 | MURANO | 197 | PRAIRIE | 49 |  |  |  |  | PRAIRIE | 131 | BEVEL_DIAMOND | 89 |  |  | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CLEAR | CREAM | SPECIAL* | SPECIAL*
 |  |  |  |  |  |  |  |  |  | THORPE | 422 | DIAMOND | 76 | DIAMOND | 70 | STD_CLEAR | 37 | DIAMOND | 56 |  |  |  |  | DIAMOND | 102 | CLASSIC | 110 |  |  |  | STIPPOLYTE |  | STIPPOLYTE | STIPPOLYTE |  |  | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE | STIPPOLYTE
Side Frame |  |  |  |  |  |  |  |  |  | WINSTER | 459 | BEVEL_DIAMOND | 89 | BEVEL_DIAMOND | 106 |  |  | BEVEL_DIAMOND | 74 |  |  |  |  | BEVEL_DIAMOND | 115 | MURANO | 109 |  |  |  | MINSTER |  | MINSTER | MINSTER |  |  | MINSTER | MINSTER | MINSTER | MINSTER | MINSTER | MINSTER
 |  |  |  |  |  |  |  |  |  |  |  | CLASSIC | 144 | CLASSIC | 200 |  |  | CLASSIC | 97 |  |  |  |  | CLASSIC | 170 | STD_CLEAR | 37 |  |  |  | CONTORA |  | CONTORA | CONTORA |  |  | CONTORA | CONTORA | CONTORA | CONTORA | CONTORA | CONTORA
 |  |  |  |  |  |  |  |  |  |  |  | MURANO | 154 | MURANO | 197 |  |  | MURANO | 89 |  |  |  |  | MURANO | 170 | SOLID | -20 |  |  |  | COTSWOLD |  | COTSWOLD | COTSWOLD |  |  | COTSWOLD | COTSWOLD | COTSWOLD | COTSWOLD | COTSWOLD | COTSWOLD
 |  |  |  |  |  |  |  |  |  |  |  | GEORGIAN_BAR | 70 | STD_CLEAR | 37 |  |  | GEORGIAN_BAR | 47 |  |  |  |  | STD_CLEAR | 65 |  |  |  |  |  | OAK |  | OAK | OAK |  |  | OAK | OAK | OAK | OAK | OAK | OAK
 |  |  |  |  |  |  |  |  |  |  |  | STD_CLEAR | 39 | SOLID | -20 |  |  | STD_CLEAR | 44 |  |  |  |  | GEORGIAN_BAR | 96 |  |  |  |  |  | CHARCOAL |  | CHARCOAL | CHARCOAL |  |  | CHARCOAL | CHARCOAL | CHARCOAL | CHARCOAL | CHARCOAL | CHARCOAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIGITAL |  | DIGITAL | DIGITAL |  |  | DIGITAL | DIGITAL | DIGITAL | DIGITAL | DIGITAL | DIGITAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLORIELLE |  | FLORIELLE | FLORIELLE |  |  | FLORIELLE | FLORIELLE | FLORIELLE | FLORIELLE | FLORIELLE | FLORIELLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAFFETA |  | TAFFETA | TAFFETA |  |  | TAFFETA | TAFFETA | TAFFETA | TAFFETA | TAFFETA | TAFFETA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PELERINE |  | PELERINE | PELERINE |  |  | PELERINE | PELERINE | PELERINE | PELERINE | PELERINE | PELERINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANTILLY |  | CHANTILLY | CHANTILLY |  |  | CHANTILLY | CHANTILLY | CHANTILLY | CHANTILLY | CHANTILLY | CHANTILLY
 |  |  |  |  |  | 603 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EVERGLADE |  | EVERGLADE | EVERGLADE |  |  | EVERGLADE | EVERGLADE | EVERGLADE | EVERGLADE | EVERGLADE | EVERGLADE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAYFLOWER |  | MAYFLOWER | MAYFLOWER |  |  | MAYFLOWER | MAYFLOWER | MAYFLOWER | MAYFLOWER | MAYFLOWER | MAYFLOWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WARWICK |  | WARWICK | WARWICK |  |  | WARWICK | WARWICK | WARWICK | WARWICK | WARWICK | WARWICK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARCTIC |  | ARCTIC | ARCTIC |  |  | ARCTIC | ARCTIC | ARCTIC | ARCTIC | ARCTIC | ARCTIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYCAMORE |  | SYCAMORE | SYCAMORE |  |  | SYCAMORE | SYCAMORE | SYCAMORE | SYCAMORE | SYCAMORE | SYCAMORE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUTUMN |  | AUTUMN | AUTUMN |  |  | AUTUMN | AUTUMN | AUTUMN | AUTUMN | AUTUMN | AUTUMN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLEMMISH |  | FLEMMISH | FLEMMISH |  |  | FLEMMISH | FLEMMISH | FLEMMISH | FLEMMISH | FLEMMISH | FLEMMISH