Spreadsheet: 677385d1589327830-i-need-an-alternative-to-an-if-function-as-i-have-too-many-queries-to-be-able-o-use-the-if-stock-analysis
Sheet: Stock Useage Per One pack

 |  |  | 20000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Formula incorrect by 0.5 |  |  | Formula incorrect by 0.2 |  |  |  |  | Not enough liquid on Wipe
Formulation |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
Number Wipes Per Pack
Size Of Wipe | Height
 | [NAME]
 | weight per Wipe
Weight Of Material | weight per Pack
 |  |  | small | small | large | small | small | large |  | small | small | small | small | small | small | large | large | large | large | large | large | large | large | large | large
Cost p Kg |  |  | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 | 2.55 | 2.55 | 2.8 | 4.4 | 4.4 | 4.4 | 4.4 | 4.4 | 2.8 | 2.8 | 2.55 | 2.55 | 2.55 | 2.55 | 2.55 | 2.55 | 2.55 | 2.7
Amount Of Material
 |  |  |  |  |  | 45 | 45 | 43 | 43 |  |  |  |  |  |  |  |  | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 50
Redundancy Factor
Raw Materials
a |  |  | 27.75 | 55.5 | 74
b |  |  | 0.0375 | 0.075 | 0.1 | 0.0375 | 0.0375 | 0.1 | 0.1 | 0.05 | 0 | 0 | 0 | 0.05 | 0 | 0.00075 | 0.015 |  |  |  |  |  |  |  | 0.12
c |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.255 | 0 | 0.255 | 0 |  | 0.34 | 0.34
e
f
g |  |  |  |  |  | 0 | 0.1125 | 0 | 0.3 | 0.15 |  |  |  |  |  | 0.225 | 0 |  |  |  |  | 0.6
h |  |  |  |  |  | 0.007500000000000001 | 0.007500000000000001 | 0.02 | 0.02 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 |  |  |  |  |  |  |  |  |  | 0.024
i |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0.05 |  |  |  |  |  |  | 0.002
j |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
k
l | d-Panthanol |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
m |  |  | 8.79375 | 17.5875 | 23.45 | 35.93624999999999 | 35.78625 | 95.82999999999998 | 95.43 | 47.715 | 47.9 | 47.615 | 47.615 | 47.865 | 47.865 | 70.7235 | 71.7975 | 143.715 | 143.97 | 144.015 | 143.97 | 189.596 | 191.62 | 191.62 | 114.096
n
o |  |  |  |  |  | 0.05625 | 0.05625 | 0.15 | 0.15 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.075 | 0.75 | 0.225 | 0.225 | 0.225 | 0.225 | 0.2 | 0.3 | 0.3 | 0.12
p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.15 |  |  |  |  | 2
q |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
r |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.05 | 0 | 0
s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.375 | 0.375
t |  |  | 0.09375 | 0.1875 | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18
u
v
w |  |  |  |  |  | 0.1875 | 0.1875 | 0.5 | 0.5 |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  |  |  |  |  |  |  | 1.44
x
y
z |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
aa |  |  | 0.1875 | 0.375 | 0.5 | 0.1875 | 0.1875 | 0.5 | 0.5 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  |  |  |  |  |  |  | 0.36
ab
ac
ad
ae |  |  | 0.5625 | 1.125 | 1.5 | 0.1875 | 0.1875 | 0.5 | 0.5 | 0.25 | 0 | 0.25 | 0.25 | 0 | 0 | 1.35 | 0.375 | 1.5 | 1.5 | 1.5 | 1.5 | 3.600000000000001 | 2 | 2 | 0.6
af
ag |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
ah |  |  |  |  |  | 0.375 | 0.375 | 1 | 1 | 0.5 |  |  |  |  |  | 0.75 | 0.75 | 1.5 | 1.5 | 1.5 | 1.5 | 2 | 2 | 2 | 1.2
ai
aj
ak
al |  |  | 0.075 | 0.15 | 0.2 | 0 | 0.075 | 0 | 0.2 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.12
am |  |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
an |  |  |  |  |  | 0.375 | 0.375 | 1 | 1 | 0.5 |  |  |  |  |  | 0.75 | 0.375 | 2.505 | 2.505 | 2.505 | 2.505 | 2 | 3.34 | 3.34
ao |  |  |  |  |  |  |  |  |  |  | 0.015 | 0 | 0 | 0 | 0
ap
aq |  |  |  |  |  | 0.075 | 0.075 | 0.2 | 0.2 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |  |  | 0.3 | 0.3 | 0.3 | 0.3 |  | 0.4 | 0.4 | 0.18
ar |  |  |  |  |  | 0.0375 |  | 0.1 |  | 0 |  |  |  |  |  | 0.00075 | 0.075 |  |  |  |  | 0.002
as
at |  |  |  |  |  | 0.0375 | 0.0375 | 0.1 | 0.1 | 0.05 | 0 | 0.05 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0.24
au
av |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.12
Total |  |  | 37.5 | 75 | 100 | 37.5 | 37.50000000000001 | 99.99999999999999 | 100 | 50.00000000000001 | 50 | 50 | 50 | 50 | 50 | 75 | 74.66250000000001 | 150 | 150 | 150.3 | 150 | 200 | 200 | 200 | 120