cbms formulas

1
Water Count(if(wtrstat='WITHOUT ACCESS',KEY)) + Count (if(wtrstat='WITH ACCESS', KEY)) Number of Male and Female Count(if(sex=2, KEYMM))+Count (if(sex=1,KEYMM)) Num,ber of Pop. 18 years above Count(if(age>=18, KEYMM)) Voters age 15 above Count(if(age>=15, KEYMM)) Nutstat Count(if(age<=5, KEYMM)) Crops Count(if(crop=1, KEYCROPS))+Count(if(crop=2, KEYCROPS))+Count(if(crop=3, KEYCROPS)) +Count(if(crop=4, KEYCROPS))+Count(if(crop=5, KEYCROPS))+Count(if(crop=6, KEYCROPS)) +Count(if(crop=7, KEYCROPS))+Count(if(crop=8, KEYCROPS))+Count(if(crop=9, KEYCROPS)) +Count(if(crop=10, KEYCROPS))+Count(if(crop=11, KEYCROPS))

Upload: yan-lean-dollison

Post on 07-Nov-2015

212 views

Category:

Documents


0 download

DESCRIPTION

CBMS Formulas

TRANSCRIPT

WaterCount(if(wtrstat='WITHOUT ACCESS',KEY)) + Count (if(wtrstat='WITH ACCESS', KEY))

Number of Male and FemaleCount(if(sex=2, KEYMM))+Count (if(sex=1,KEYMM))

Num,ber of Pop. 18 years aboveCount(if(age>=18, KEYMM))

Voters age 15 aboveCount(if(age>=15, KEYMM))

NutstatCount(if(age