need an app where excel data or data input of 3 columns of a BOX i.e. H x W x D is inserted
floated through an excel formula
being run Generates list of part in another type excel sample sheet
Input in red and blue is result
BELOW is formula
| Numbers | Width | Hieght | Depth | Top Type | 20 | Skirting EP | ||
|---|---|---|---|---|---|---|---|---|
| 1 | 600 | 730 | 580 | 20 | for Gola | RHS | ||
| If Shelf | 1 | 0 | for Normal | LHS | ||||
| Nos | Thickness | L | B | Total | PART NAME | |||
| 1 | 18mm | 730 | 580 | 1 | EP-RHS | |||
| 1 | 18mm | 730 | 580 | 1 | EP-LHS | |||
| 1 | 18mm | 564 | 560 | 1 | Top | |||
| 1 | 18mm | 564 | 580 | 1 | Bottom | |||
| 1 | 9mm | 706 | 576 | 1 | Back | |||
| 1 | 18mm | 564 | 560 | 1 | shelfs | |||
| 2 | 18MM | 300 | 690 | 2 | Shutter | OPTION | ||
| 1 | 18MM | 344 | 600 | 1 | 3 DRAWERS | OPTION | ||
| 2 | 18MM | 172 | 600 | 2 | ||||
| 2 | 18MM | 344 | 600 | 2 | 2 DRAWERS | OPTION | ||