Spreadsheet: 775779d1649318212-how-to-reset-multiple-dependent-drop-down-cells-drawercostingn
Sheet: Harn

[NAME] base |  |  |  |  |  |  |  |  | [NAME] cost N,M |  |  |  |  |  |  |  | Whiteboard cost K |  |  |  |  |  |  |  | [NAME] cost H,B,D
 | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
0.3 |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
0.4 |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
0.5 |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
0.6 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
0.7 |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
0.8 |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
0.9 |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
1.1 |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
1.2 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
[NAME] back |  |  |  |  |  |  |  |  | [NAME] cost Inner N,M |  |  |  |  |  |  |  | [NAME] cost [NAME] |  |  |  |  |  |  |  | [NAME] cost Inner H,B,D
 | M | K | H,B,D |  |  |  |  |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 |  |  | 0.27 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55
Column1 | 0.071 | 0.113 | 0.2 |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  | 0.3
0.3 |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.4
0.4 |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
0.5 |  |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6 |  |  |  |  |  |  |  | 0.6
0.6 |  |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7 |  |  |  |  |  |  |  | 0.7
0.7 |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  |  | 0.8
0.8 |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9
0.9 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
1 |  |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1 |  |  |  |  |  |  |  | 1.1
1.1 |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 1.2
1.2 |  |  |  |  |  |  |  |  | M_30H |  |  |  |  |  |  |  | M_30H_IN
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550 |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
Whiteboard |  | 35.5 | M2 |  |  |  |  |  | 300 |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  | 400
Sides | 270 | 350 | 400 | 450 | 500 | 550 | Inners |  | 500 |  |  |  |  |  |  |  | 500
M-85 | 12 | 12 | 12.5 | 13 | 13 | 14 |  |  | 600 |  |  |  |  |  |  |  | 600
K-120 | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 700 |  |  |  |  |  |  |  | 700
H-150 |  | 18 | 18 | 18 | 17 | 19.5 |  |  | 800 |  |  |  |  |  |  |  | 800
D-213 | 15 | 16 | 15 | 15 | 15 | 18 |  |  | 900 |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100 |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  | 1200
[NAME] In Brac | Each |  |  |  |  |  |  |  | K_30H |  |  |  |  |  |  |  | K_30H_IN
M | 3.3 | pr |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550 |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
K | 7 | pr |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  | 300
H | 8.5 | pr |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600 |  |  |  |  |  |  |  | 600
Soft Close |  | 10 | ea |  |  |  |  |  | 700 |  |  |  |  |  |  |  | 700
[NAME] | M,K,H | 2.1 | ea |  |  |  |  |  | 800 |  |  |  |  |  |  |  | 800
Harnfile set |  | 12 |  |  |  |  |  |  | 900 |  |  |  |  |  |  |  | 900
Gallery set of 2 |  | 7 |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  | 1000
Boxsides 500mm |  | 6 | pr |  |  |  |  |  | 1100 |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  | H_30H |  |  |  |  |  |  |  | H_30H_IN
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550 |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
 |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600 |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  | 700 |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 900 |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000 |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100 |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  | MB_30H
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
 |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  | MD_30H
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
 |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  | KB_30H
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
 |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  | HB_30H
 |  |  |  |  |  |  |  |  | [NAME] | 270 | 350 | 400 | 450 | 500 | 550
 |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 900
 |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  | 1100
 |  |  |  |  |  |  |  |  | 1200