Spreadsheet: 851636d1701821616-cannot-solve-value-error-error-sample-file
Sheet: Tab 2

 |  |  |  | JOB NAME | Page Number |  | Room Name |  |  |  |  |  |  |  | Overall Width
 |  |  |  |  | Page 2.1 |  | Reception 101 |  |  |  |  |  |  |  | 73
 |  |  | Height Error
 |  |  |  |  | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height
 |  |  | [NAME]
Defaults |  |  | Second Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottoms on Sinks?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Groove on Bottom? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grove on [NAME]?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Table Cabinets |  |  |  |  |  |  |  |  |  | Sides |  |  | Bottom |  |  | Top |  |  | Nailer |  |  | Rails |  |  | Shelves |  |  | Backing |  |  | Drawer Front |  |  | Doors |  |  | [NAME] |  |  | Drawer Partition |  |  | Size For Optimization |  |  | Finished Ends |  |  | [NAME] |  |  |  | Opening Heights |  |  |  | Total Height
Base Cabinet Height with Top |  |  | Finished Ends? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page # | Component | [NAME] | Cabinet # | [NAME] | [NAME] | [NAME] | First Drawer Height | Second Drawer Height | Third Drawer Height | Forth Drawer Height | Side Depth | Side Height | Side Qty | BottomWidth | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Nailer Width | Nailer Depth | Nailer Qty | Rail Width | Rail Depth | Rail Qty | [NAME] | [NAME] | [NAME] | BackWidth | BackHeight | Back Qty | Drawer Front Width | Drawer 1 Height | Drawer Qty | Door Width | [NAME] | Door Qty | Drawer [NAME] | Drawer Bottom Depth | Drawer Bottom Qty | Drawer Partition Height | Drawer Partition Depth | Drawer Partition Qty | Optimization [NAME] | Optimization [NAME] | Optimization Size Qty | Finished Ends Depth | Finished Ends Height | Finished Ends Qty | First Door Height | Second Door Height | Third Door Height | Forth Door Height | First Opening Height | Second Opening Height | Third Opening Height | Forth Opening Height | Ttl Drawer, Door, Opening | Finished Ends [NAME] | Finished Ends Bottom Length | Hinge Qty | Edge Bander [NAME] |  |  | Count Doors | Count Drawers
Base Cabinet Depth |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Wall Cabinet Height |  |  | Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Wall Cabinet Depth |  |  | Depth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Box Material Thickness |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
19mm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
First Drawer Opening Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Z Metal box space requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] box thinkness |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Edge Bander Thinkness |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Hinge Left Space Behind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Space Between Drawer and Door |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Space Between Counter and Drawer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
First Drawer Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Z Metal box space requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
custom plywood box |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | Blind Corner |  | Space |  | 3DC |  | 3DC |  | FHSDB |  | Space |  |  |  |  |  |  |  |  |  |  | Difference |  |  |  |  |  |  | [NAME] | Height | Depth | First Drawer Height | Second Drawer Height | Third Drawer Height | Forth Drawer Height
 |  |  | Cabinet # |  |  |  |  |  | 3DC1 |  | 3DC2 |  | FHSDB3
 |  |  | [NAME] |  | 24 |  | 3 |  | 15 |  | 15 |  | 15 |  | 1
 |  |  | Height |  |  |  |  |  | 30 |  | 30 |  | 30
 |  |  | Depth |  |  |  |  |  | 24 |  |  |  | 24
 |  |  | Finished Ends? |  |  |  |  |  | None |  | None |  | None
 |  |  |  |  | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height | Type | Height
 |  |  | [NAME] |  |  |  |  |  | Drawer | 5.375 | Drawer | 5.375 | Door | 23.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For SDB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For SDB
 |  |  | Second Height |  |  |  |  |  | Drawer | 5.375 | Drawer | 5.375 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No=side-1" for the bottom depth, backing will be as high as side. Yes=bottom depth = side depth, backing height = side-matl thickness plus 1/4. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No=side-1" for the bottom depth, backing will be as high as side. Yes=bottom depth = side depth, backing height = side-matl thickness plus 1/4.
 |  |  | Third Height |  |  |  |  |  | Drawer | 12.25 | Drawer | 12.25
 |  |  | Forth Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For shelves, qty should be: (1) for <=20", 21-36", 2 shelves, for 37-42", 3 shelves,
 |  |  | Height Error |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adj backing for WC same base cabinets, groove or no groove.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For pantry have a dynamic shelf qty.
Remaining door/opening heights
Component | Description | Non Door/Opening Height | Calculation
2SDDP | 2 Stack Double Door Pantry |  | TK+Sp bet d&d
2SDDW | 2 Stack Double Door Wall |  | Sp bet d&d
2SSDP | 2 Stack Single Door Pantry |  | TK+Sp bet d&d
2SSDW | 2 Stack Single Door Wall |  | Sp bet d&d
3SDDP | 3 Stack Double Door Pantry |  | TK+Sp bet d&d*2
3SSDP | 3 Stack Single Door Pantry |  | TK+Sp bet d&d*2
ADASNK | [NAME] |  | CT thickness+space bet counter/drawer+Space bet drawer/door
BMC | Base Microwave Cabinet |  | CT thickness+Toe [NAME]
DDB | Double Door Base |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
DDW | Double Door Wall | 0
FHDDB | Full Height Double Door Base |  | TK+CT thickness+sp bet counter/door
FHDDP | Full Height Double Door Pantry |  | TK
FHSDB | Full Height Single Door Base |  | TK+CT thickness+sp bet counter/door
FHSDP | Full Height Single Door Pantry |  | TK
FHSNK | Full Height Sink |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
OBCD | Open Base Cabinet w/drawer |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
OWC | Open Wall Cabinet | 0
SDB | Single Door Base |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
SDW | Single Door Wall | 0
SNK | Sink |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
Trash | [NAME] |  | CT thickness+Toe Kick+space bet counter/drawer
WMC | Wall Microwave Cabinet |  | Space bet door and drawer
OBC | Open Base Cabinet |  | CT thickness+Toe [NAME]
2DC | 2 Drawer Cabinets |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door
3DC | 3 Drawer Cabinets |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door*2
4DC | 4 Drawer Cabinets |  | CT thickness+Toe Kick+space bet counter/drawer+Space bet drawer/door*3