Spreadsheet: 840090d1692402420-excel-formula-to-best-match-product-based-on-4-criteria-required-quick-sales-calc-v2-demo
Sheet: Sensor Qty CALC demo

Location | Indoor/Outdoor | Cable/Wifi/BT | Height Required | [NAME] | Sensor Recommended | [NAME] | Sensor Width | Sensor MSRP (USD) | Sensor Quantity/Width | Sensor Total Price (USD) | cheapest row | [NAME] | Sensor Quantity/Width | Sensor MSRP (USD) | total
Test location 1 | Indoor | Cable | 1 | 2.64 | Sensor 10 | 2.5 | 2.63 | 1722.7474624032 | 2
Test location 1 | Indoor | Cable | 2.53 | 5.74 | Sensor 1 | 3 | 3.75 | 995.6133511712 | 2
Test location 1 | Indoor | Cable | 7 | 2.66 |  |  | 6.88 | 2103.0932792288
Test location 1 | Indoor | Cable | 2 | 18
Test location 1 | Indoor | Cable | 2.5 | 19
Test location 1 | Indoor | Cable | 3 | 9
Test location 1 | Indoor | Cable | 3.5 | 17
Test location 1 | Indoor | Cable | 3.53 | 4
Test location 1 | Indoor | Cable | 2.53 | 20
Test location 1 | Indoor | Cable | 10 | 3
Test location 1 | Indoor | Cable | 11 | 19
Test location 1 | Indoor | Cable | 12 | 9
Test location 1 | Indoor | Cable | 13 | 5
Test location 1 | Indoor | Cable | 14 | 13
Test location 1 | Indoor | Cable | 15 | 22
Test location 1 | Indoor | Cable | 16 | 11
Test location 1 | Indoor | Cable | 17 | 16
Test location 2 | Indoor | Cable | 18 | 3
Test location 3 | Indoor | Cable | 19 | 12
Test location 4 | Indoor | Cable | 20 | 1
 |  |  |  |  |  |  |  |  | Total Sensors | Total Price (USD)
Ref | Sensor | Indoor/Outdoor | Cable/Wifi/BT | Height | [NAME] | Length | Coverage of Height/Width | Sensor MSRP (USD)
1 | Sensor 1 | Indoor | Cable | 2.5 | 1.88 | 1.06 |  | 995.6133511712
2 | Sensor 1 | Indoor | Cable | 3 | 3.75 | 2.13 |  | 995.6133511712
3 | Sensor 1 | Indoor | Cable | 3.5 | 5.63 | 3.19 |  | 995.6133511712
4 | Sensor 1 | Indoor | Cable | 4 | 7 | 4.25 |  | 995.6133511712
5 | Sensor 1 | Indoor | Cable | 4.5 | 7 | 5 |  | 995.6133511712
6 | Sensor 1 | Indoor | Cable | 5 | 7 | 5 |  | 995.6133511712
7 | Sensor 1 | Indoor | Cable | 5.5 | 7 | 5 |  | 995.6133511712
8 | Sensor 1 | Indoor | Cable | 6 | 7 | 5 |  | 995.6133511712
9 | Sensor 2 | Indoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 1631.0170327328
10 | Sensor 2 | Indoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 1631.0170327328
11 | Sensor 2 | Indoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 1631.0170327328
12 | Sensor 2 | Indoor | Wifi/BT | 4 | 7 | 4.25 |  | 1631.0170327328
13 | Sensor 2 | Indoor | Wifi/BT | 4.5 | 7 | 5 |  | 1631.0170327328
14 | Sensor 2 | Indoor | Wifi/BT | 5 | 7 | 5 |  | 1631.0170327328
15 | Sensor 2 | Indoor | Wifi/BT | 5.5 | 7 | 5 |  | 1631.0170327328
16 | Sensor 2 | Indoor | Wifi/BT | 6 | 7 | 5 |  | 1631.0170327328
17 | Sensor 3 | Outdoor | Cable | 2.5 | 1.88 | 1.06 |  | 1924.1062116224
18 | Sensor 3 | Outdoor | Cable | 3 | 3.75 | 2.13 |  | 1924.1062116224
19 | Sensor 3 | Outdoor | Cable | 3.5 | 5.63 | 3.19 |  | 1924.1062116224
20 | Sensor 3 | Outdoor | Cable | 4 | 7 | 4.25 |  | 1924.1062116224
21 | Sensor 3 | Outdoor | Cable | 4.5 | 7 | 5 |  | 1924.1062116224
22 | Sensor 3 | Outdoor | Cable | 5 | 7 | 5 |  | 1924.1062116224
23 | Sensor 3 | Outdoor | Cable | 5.5 | 7 | 5 |  | 1924.1062116224
24 | Sensor 3 | Outdoor | Cable | 6 | 7 | 5 |  | 1924.1062116224
25 | Sensor 4 | Outdoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 2090.7883097536
26 | Sensor 4 | Outdoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 2090.7883097536
27 | Sensor 4 | Outdoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 2090.7883097536
28 | Sensor 4 | Outdoor | Wifi/BT | 4 | 7 | 4.25 |  | 2090.7883097536
29 | Sensor 4 | Outdoor | Wifi/BT | 4.5 | 7 | 5 |  | 2090.7883097536
30 | Sensor 4 | Outdoor | Wifi/BT | 5 | 7 | 5 |  | 2090.7883097536
31 | Sensor 4 | Outdoor | Wifi/BT | 5.5 | 7 | 5 |  | 2090.7883097536
32 | Sensor 4 | Outdoor | Wifi/BT | 6 | 7 | 5 |  | 2090.7883097536
33 | Sensor 5 | Indoor | Cable | 6 | 5.25 | 4.5 |  | 2103.0932792288
34 | Sensor 5 | Indoor | Cable | 7 | 6.88 | 5.63 |  | 2103.0932792288
35 | Sensor 5 | Indoor | Cable | 8 | 8 | 6 |  | 2103.0932792288
36 | Sensor 5 | Indoor | Cable | 9 | 8 | 6 |  | 2103.0932792288
37 | Sensor 5 | Indoor | Cable | 10 | 8 | 6 |  | 2103.0932792288
38 | Sensor 5 | Indoor | Cable | 11 | 8 | 6 |  | 2103.0932792288
39 | Sensor 5 | Indoor | Cable | 12 | 8 | 6 |  | 2103.0932792288
40 | Sensor 5 | Indoor | Cable | 13 | 8 | 6 |  | 2103.0932792288
41 | Sensor 5 | Indoor | Cable | 14 | 8 | 6 |  | 2103.0932792288
42 | Sensor 6 | Outdoor | Cable | 6 | 5.25 | 4.5 |  | 2886.1620403744
43 | Sensor 6 | Outdoor | Cable | 7 | 6.88 | 5.63 |  | 2886.1620403744
44 | Sensor 6 | Outdoor | Cable | 8 | 8 | 6 |  | 2886.1620403744
45 | Sensor 6 | Outdoor | Cable | 9 | 8 | 6 |  | 2886.1620403744
46 | Sensor 6 | Outdoor | Cable | 10 | 8 | 6 |  | 2886.1620403744
47 | Sensor 6 | Outdoor | Cable | 11 | 8 | 6 |  | 2886.1620403744
48 | Sensor 6 | Outdoor | Cable | 12 | 8 | 6 |  | 2886.1620403744
49 | Sensor 6 | Outdoor | Cable | 13 | 8 | 6 |  | 2886.1620403744
50 | Sensor 6 | Outdoor | Cable | 14 | 8 | 6 |  | 2886.1620403744
51 | Sensor 7 | Indoor | Cable | 2.5 | 1.88 | 1.06 |  | 1722.7474624032
52 | Sensor 7 | Indoor | Cable | 3 | 3.75 | 2.13 |  | 1722.7474624032
53 | Sensor 7 | Indoor | Cable | 3.5 | 5.63 | 3.19 |  | 1722.7474624032
54 | Sensor 7 | Indoor | Cable | 4 | 7.5 | 4.25 |  | 1722.7474624032
55 | Sensor 7 | Indoor | Cable | 4.5 | 9.38 | 5.31 |  | 1722.7474624032
56 | Sensor 7 | Indoor | Cable | 5 | 11 | 6.38 |  | 1722.7474624032
57 | Sensor 7 | Indoor | Cable | 5.5 | 11 | 7.4 |  | 1722.7474624032
58 | Sensor 7 | Indoor | Cable | 6 | 11 | 8 |  | 1722.7474624032
59 | Sensor 8 | Indoor | Wifi/BT | 2.5 | 1.88 | 1.06 |  | 2080.721597616
60 | Sensor 8 | Indoor | Wifi/BT | 3 | 3.75 | 2.13 |  | 2080.721597616
61 | Sensor 8 | Indoor | Wifi/BT | 3.5 | 5.63 | 3.19 |  | 2080.721597616
62 | Sensor 8 | Indoor | Wifi/BT | 4 | 7.5 | 4.25 |  | 2080.721597616
63 | Sensor 8 | Indoor | Wifi/BT | 4.5 | 9.38 | 5.31 |  | 2080.721597616
64 | Sensor 8 | Indoor | Wifi/BT | 5 | 11 | 6.38 |  | 2080.721597616
65 | Sensor 8 | Indoor | Wifi/BT | 5.5 | 11 | 7.4 |  | 2080.721597616
66 | Sensor 8 | Indoor | Wifi/BT | 6 | 11 | 8 |  | 2080.721597616
67 | Sensor 9 | Outdoor | Cable | 2.5 | 1.88 | 1.06 |  | 2325.7100272736
68 | Sensor 9 | Outdoor | Cable | 3 | 3.75 | 2.13 |  | 2325.7100272736
69 | Sensor 9 | Outdoor | Cable | 3.5 | 5.63 | 3.19 |  | 2325.7100272736
70 | Sensor 9 | Outdoor | Cable | 4 | 7.5 | 4.25 |  | 2325.7100272736
71 | Sensor 9 | Outdoor | Cable | 4.5 | 9.38 | 5.31 |  | 2325.7100272736
72 | Sensor 9 | Outdoor | Cable | 5 | 11 | 6.38 |  | 2325.7100272736
73 | Sensor 9 | Outdoor | Cable | 5.5 | 11 | 7.4 |  | 2325.7100272736
74 | Sensor 9 | Outdoor | Cable | 6 | 11 | 8 |  | 2325.7100272736
75 | Sensor 10 | Indoor | Cable | 2.5 | 2.63 | 2.13 |  | 1722.7474624032
76 | Sensor 10 | Indoor | Cable | 2.5 | 5 | 4 |  | 3400
77 | Sensor 10 | Indoor | Cable | 3.5 | 7 | 5.88 |  | 1722.7474624032
78 | Sensor 11 | Indoor | Wifi/BT | 2.5 | 2.63 | 2.13 |  | 1722.7474624032
79 | Sensor 11 | Indoor | Wifi/BT | 3 | 5 | 4 |  | 1722.7474624032
80 | Sensor 11 | Indoor | Wifi/BT | 3.5 | 7 | 5.88 |  | 1722.7474624032
81 | Sensor 12 | Outdoor | Cable | 2.5 | 2.63 | 2.13 |  | 2325.7100272736
82 | Sensor 12 | Outdoor | Cable | 3 | 5 | 4 |  | 2325.7100272736
83 | Sensor 12 | Outdoor | Cable | 3.5 | 7 | 5.88 |  | 2325.7100272736
84 | Sensor 13 | Indoor | Cable | 6 | 10 | 7.25 |  | 3053.9605442336
85 | Sensor 13 | Indoor | Cable | 7 | 12 | 9 |  | 3053.9605442336
86 | Sensor 13 | Indoor | Cable | 8 | 12 | 9 |  | 3053.9605442336
87 | Sensor 13 | Indoor | Cable | 9 | 12 | 9 |  | 3053.9605442336
88 | Sensor 14 | Outdoor | Cable | 6 | 10 | 7.25 |  | 3747.5344101056
89 | Sensor 14 | Outdoor | Cable | 7 | 12 | 9 |  | 3747.5344101056
90 | Sensor 14 | Outdoor | Cable | 8 | 12 | 9 |  | 3747.5344101056
91 | Sensor 14 | Outdoor | Cable | 9 | 12 | 9 |  | 3747.5344101056
92 | Sensor 15 | Indoor | Cable | 9 | 9.88 | 7.88 |  | 3053.9605442336
93 | Sensor 15 | Indoor | Cable | 10 | 11.5 | 9 |  | 3053.9605442336
94 | Sensor 15 | Indoor | Cable | 11 | 12 | 9 |  | 3053.9605442336
95 | Sensor 15 | Indoor | Cable | 12 | 12 | 9 |  | 3053.9605442336
96 | Sensor 16 | Outdoor | Cable | 9 | 9.88 | 7.88 |  | 3747.5344101056
97 | Sensor 16 | Outdoor | Cable | 10 | 11.5 | 9 |  | 3747.5344101056
98 | Sensor 16 | Outdoor | Cable | 11 | 12 | 9 |  | 3747.5344101056
99 | Sensor 16 | Outdoor | Cable | 12 | 12 | 9 |  | 3747.5344101056
100 | Sensor 17 | Indoor | Cable | 11 | 11.5 | 8.38 |  | 0
101 | Sensor 17 | Indoor | Cable | 12 | 12 | 9 |  | 0
102 | Sensor 17 | Indoor | Cable | 13 | 12 | 9 |  | 0
103 | Sensor 17 | Indoor | Cable | 14 | 12 | 9 |  | 0
104 | Sensor 18 | Outdoor | Cable | 11 | 11.5 | 8.38 |  | 0
105 | Sensor 18 | Outdoor | Cable | 12 | 12 | 9 |  | 0
106 | Sensor 18 | Outdoor | Cable | 13 | 12 | 9 |  | 0
107 | Sensor 18 | Outdoor | Cable | 14 | 12 | 9 |  | 0
108 | Sensor 19 | Indoor | Cable | 14 | 10.5 | 7.75 |  | 3053.9605442336
109 | Sensor 19 | Indoor | Cable | 15 | 11.5 | 8.5 |  | 3053.9605442336
110 | Sensor 19 | Indoor | Cable | 16 | 12 | 9 |  | 3053.9605442336
111 | Sensor 20 | Outdoor | Cable | 14 | 10.5 | 7.75 |  | 3747.5344101056
112 | Sensor 20 | Outdoor | Cable | 15 | 11.5 | 8.5 |  | 3747.5344101056
113 | Sensor 20 | Outdoor | Cable | 16 | 12 | 9 |  | 3747.5344101056
114 | Sensor 21 | Indoor | Cable | 16 | 9 | 7 |  | 3053.9605442336
115 | Sensor 21 | Indoor | Cable | 17 | 9.8 | 7.5 |  | 3053.9605442336
116 | Sensor 21 | Indoor | Cable | 18 | 10.5 | 8 |  | 3053.9605442336
117 | Sensor 21 | Indoor | Cable | 19 | 11.3 | 8.5 |  | 3053.9605442336
118 | Sensor 21 | Indoor | Cable | 20 | 12 | 9 |  | 3053.9605442336
119 | Sensor 22 | Outdoor | Cable | 16 | 9 | 7 |  | 3747.5344101056
120 | Sensor 22 | Outdoor | Cable | 17 | 9.8 | 7.5 |  | 3747.5344101056
121 | Sensor 22 | Outdoor | Cable | 18 | 10.5 | 8 |  | 3747.5344101056
122 | Sensor 22 | Outdoor | Cable | 19 | 11.3 | 8.5 |  | 3747.5344101056
123 | Sensor 22 | Outdoor | Cable | 20 | 12 | 9 |  | 3747.5344101056