Spreadsheet: 104977d1302460695-simple-getting-a-list-of-values-from-a-column-within-a-given-numerical-range-advtry
Sheet: P2

General data of the program:
Dn ([NAME]) | 40 | nb | 4
IT ([NAME]) | 0.025 | Sb (mm2) | 525
Lp (mm) | 570 | a (m/s^2) | 4.9
[NAME] ([NAME]) | 150
Inputs of the part:
Di (mm) | 39.8
Rti (µm) | 8
Inputs of the tool:
Gs | 46 | 64 | 91 | 107 | 126
Td | 25 | 50 | 75
Inputs of the machine:
P (N/cm^2) | 300 | 400 | 500 | 600
[NAME] (m/min) | 16 | 24
THs (mm)
α (°) | 90
Estimation of the initial values:
Rvqg | 0.8±10% (0.72 - 0.88)
Range: | 0.72 | 0.88
 |  |  |  |  |  |  |  | WRONG | ADDED
 |  |  |  |  |  |  |  | ↓ | ↓
Gs (FEPA) | Td | P (N/cm^2) | VI (m/min) | Vt (1/min) | Qm (cm/min) | Ra (µm) | Rt (µm) | Rq (µm) | th1 ([NAME]) | [NAME] ([NAME]) |  |  |  |  |  |  | Count
VV This is the table for the Advanced Filter
Solution | Rq | Qm | P | VI | Gs | Td | Vt | A Index | B Index | C Index | D Index |  |  | Rq | Rq |  | <<Look at the formula in O55 and P55 as they are funny - different
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<This is the Advanced Filter Criteria
2
3 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] is the result range of the Advanced Filter
4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Solution | Rq | Qm | P | VI | Gs | Td | Vt | A Index | B Index | C Index | D Index
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.7327355899644455 | 0.08240218748406108 | 400 | 24 | 46 | 25 | 191.0828025477707 | 2 | 2 | 1 | 1
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0.7940581699644462 | 0.1595171112038063 | 600 | 24 | 46 | 25 | 191.0828025477707 | 4 | 2 | 1 | 1
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 0.7963398589071219 | 0.08556312788406119 | 400 | 24 | 64 | 25 | 191.0828025477707 | 2 | 2 | 2 | 1
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 0.7968339473617632 | 0.06365319572497549 | 300 | 16 | 91 | 25 | 127.3885350318471 | 1 | 1 | 3 | 1
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 0.8557387237096683 | 0.06485568242418849 | 300 | 24 | 126 | 25 | 191.0828025477707 | 1 | 2 | 5 | 1
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | 0.8648423989071217 | 0.0737179725241886 | 300 | 24 | 64 | 50 | 191.0828025477707 | 1 | 2 | 2 | 2
11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 0.8222212939573039 | 0.08413824674472062 | 600 | 16 | 46 | 75 | 127.3885350318471 | 4 | 1 | 1 | 3
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 86 | 0.7754062899644476 | 0.0563476874840611 | 400 | 24 | 46 | 75 | 191.0828025477707 | 2 | 2 | 1 | 3
13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 | 0.8200000799644447 | 0.09490514934393357 | 500 | 24 | 46 | 75 | 191.0828025477707 | 3 | 2 | 1 | 3
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 | 0.7242506589071191 | 0.05950862788406119 | 400 | 24 | 64 | 75 | 191.0828025477707 | 2 | 2 | 2 | 3
15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 0.8067297689071196 | 0.1048753457439338 | 500 | 24 | 64 | 75 | 191.0828025477707 | 3 | 2 | 2 | 3
16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 102 | 0.7542402608211323 | 0.0733688321840612 | 400 | 24 | 91 | 75 | 191.0828025477707 | 2 | 2 | 3 | 3
17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 104 | 0.768642440821133 | 0.1845300359038064 | 600 | 24 | 91 | 75 | 191.0828025477707 | 4 | 2 | 3 | 3
18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 105 | 0.7502285338611279 | 0.04492304196497551 | 300 | 16 | 107 | 75 | 127.3885350318471 | 1 | 1 | 4 | 3
19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | 0.832444351970179 | 0.0867458504240612 | 400 | 24 | 107 | 75 | 191.0828025477707 | 2 | 2 | 4 | 3
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120