Spreadsheet: 677448d1589363722-i-need-an-alternative-to-an-if-function-as-i-have-too-many-queries-to-be-able-o-use-the-if-stock-level-analysis
Sheet: Production Weight Per Product

1 | Alcohol 15's
2 | Alcohol 30's
3 | Alcohol 40's
4 | [NAME] 15's
5 | [NAME] 40's
6 | TLC Hygiene 20's
7 | RooiBos 20's
8 | Vitamin E 20's
9 | Evening Primrose Oil 20's
10 | [NAME]
11 | Chamomile 20's
12 | Herbal 30's
13 | Magnolia 30's
14 | [NAME] Scented
15 | [NAME] Unscented
16 | TLC Baby 60's Scented
17 | TLC Baby 60's Unscented
18 | [NAME]
19 | President [NAME]
20 | Clicks [NAME] washcloth
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Formula incorrect by 0.5 |  |  | Formula incorrect by 0.2 |  |  |  |  | Not enough liquid on Wipe
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Nothing
Number Wipes Per Pack |  |  | 15 | 30 | 40 | 15 | 15 | 40 | 40 | 20 | 20 | 20 | 20 | 20 | 20 | 30 | 30 | 60 | 60 | 60 | 60 | 80 | 80 | 80 | 48 | 0
Size Of Wipe | Height |  | 150 | 150 | 150 | 150 | 100 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 250 | 0
 | [NAME] |  | 190 | 190 | 200 | 190 | 200 | 200 | 200 | 190 | 190 | 190 | 190 | 190 | 190 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 250 | 0
 | weight per Wipe |  | 0.0012825 | 0.0012825 | 0.00129 | 0.0012825 | 0.0009 | 0.0009 | 0.00129 | 0.0012825 | 0.0012825 | 0.0012825 | 0.0012825 | 0.0012825 | 0.0012825 | 0.00135 | 0.00135 | 0.00129 | 0.00129 | 0.00129 | 0.00129 | 0.00129 | 0.00129 | 0.00129 | 0.003125 | 0
Weight Of Material | weight per Pack |  | 0.0192375 | 0.038475 | 0.05160000000000001 | 0.0192375 | 0.0135 | 0.036 | 0.05160000000000001 | 0.02565 | 0.02565 | 0.02565 | 0.02565 | 0.02565 | 0.02565 | 0.04049999999999999 | 0.04049999999999999 | 0.07740000000000001 | 0.07740000000000001 | 0.07740000000000001 | 0.07740000000000001 | 0.1032 | 0.1032 | 0.1032 | 0.15 | 0
 |  |  | small | small | large | small | small | large | 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 | 0
Amount Of Material
aaaa |  |  | 45 | 45 | 45 | 45 | 45 | 43 | 43 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 50 | 0
aaa
bbb
[NAME]
ddd
Average ml/Wipe |  |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 0
Total Volume ml |  |  | 37.5 | 75 | 100 | 37.5 | 37.5 | 100 | 100 | 50 | 50 | 50 | 50 | 50 | 50 | 75 | 75 | 150 | 150 | 150 | 150 | 200 | 200 | 200 | 120 | 0
Redundancy Factor
Raw Materials
a |  |  | 27.75 | 55.5 | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
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 | 0
c |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 |  |  |  |  |  |  |  |  |  |  | 0
d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.255 | 0 | 0.255 | 0 |  | 0.34 | 0.34 |  | 0
e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
g |  |  |  |  |  | 0 | 0.1125 | 0 | 0.3 | 0.15 |  |  |  |  |  | 0.225 | 0 |  |  |  |  | 0.6 |  |  |  | 0
i |  |  |  |  |  | 0.007500000000000001 | 0.007500000000000001 | 0.02 | 0.02 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 |  |  |  |  |  |  |  |  |  | 0.024 | 0
j |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0.05 |  |  |  |  |  |  | 0.002 |  |  |  | 0
k |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2 | 0
l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
m | d-Panthanol |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 |  |  |  |  |  |  |  |  |  |  | 0
n |  |  | 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 | 0
o |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
p |  |  |  |  |  | 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 | 0
q |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | 0.15 |  |  |  |  | 2 |  |  |  | 0
r |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  | 0
s |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.05 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
t |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.375 | 0.375 |  |  |  |  |  |  |  |  | 0
u |  |  | 0.09375 | 0.1875 | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18 | 0
v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
x |  |  |  |  |  | 0.1875 | 0.1875 | 0.5 | 0.5 |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  |  |  |  |  |  |  | 1.44 | 0
y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
aa |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  | 0
ab |  |  | 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 | 0
ac |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ad |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
af |  |  | 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 | 0
ag |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ah |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 |  |  |  |  |  |  |  |  |  |  | 0
ai |  |  |  |  |  | 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 | 0
aj |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
al |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
am |  |  | 0.075 | 0.15 | 0.2 | 0 | 0.075 | 0 | 0.2 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.12 | 0
an |  |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  |  |  |  |  |  |  |  | 0
ao |  |  |  |  |  | 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 |  | 0
ap |  |  |  |  |  |  |  |  |  |  | 0.015 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
aq |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ar |  |  |  |  |  | 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 | 0
as |  |  |  |  |  | 0.0375 |  | 0.1 |  | 0 |  |  |  |  |  | 0.00075 | 0.075 |  |  |  |  | 0.002 |  |  |  | 0
at |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
au |  |  |  |  |  | 0.0375 | 0.0375 | 0.1 | 0.1 | 0.05 | 0 | 0.05 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0.24 | 0
av |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
aw |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.12 | 0
 |  |  | 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 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3374999999999915 |  |  | -0.3000000000000114
 |  |  | 75 | 150 | 200 | 75 | 75.00000000000001 | 200 | 200