Loading spreadsheet…
Opening in Numbers for Mac...
Choose Media…
Your browser isn’t fully supported.
For the best Numbers for iCloud experience, use a supported browser.
Learn More
Cancel
Continue
This spreadsheet calculates the amount of precursors that you need to produce a
certain amount of chlorine dioxide holding solution (CDH) of a certain concentration.
CDH
5 000
ml of
10
ppm will require
4 999
ml water
tick to toggle target
0 g NaClO₂ solution or powder
67,45
0,050
90,44
6,113
0,31
ml of
22,4%
concentration—without additives?
1,22
calculated amount needed
36,45797
13,253
0,33
ml of
4%
concentration
0,9%
1,02
calculated amount needed
50%
100,0%
insert the concentration and tick the box if it is clear that this is
actual
NaClO₂
content
rather
than the proportion of technical grade power used. 22.4
%
is standard, being 28
%
W/W
of
powder that is 80
%
pure NaClO₂
…
but other concentrations are sold.
fi ll in the data in the orange cells, the results will be shown in the blue cells
use these quantities of precursors to produce the desired amount and concentration of CDH
5NaClO₂ + 4HCl
→
4ClO₂ + 5NaCl + 2H₂O
cells F7 & F10 show the approximate specifi c gravity (density) of the stock solutions
cells F6 & F9 show the number of ml of the stock solutions necessary to produce one gramme of ClO₂
cell F5 is the number of grammes of ClO₂ in the fi nal target solution
cell F11 is the proportion of the total volume that is the target solution, ie not the reagents
cells E5, E6 & E9 are [hidden] values for the molecular masses of ClO₂, NaClO₂ and HCl
cell E11 is the activation proportion, usually 50
%
the tick-box to the right of ‘stock solutions’ can be used to change the measurements to drops (24 per ml)
enter volume of CDH desired
a common standard is 3000 ppm but 3500 and 4000 are also used
stock solutions
sodium chlorite—NaClO₂
hydrochloric acid—HCl
insert the concentration of acid
remember to use “,” for decimal points!
please do not delete,
overwrite or alter the
equations in the blue cells!
If this spreadsheet is not functioning as expected, please email
realising.potential@icloud.com
