{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Water","Sanitation","Hygiene","MICS12"],"not_rendered":{"charts":96,"images":76,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Joint Monitoring Programme for Water Supply, Sanitation and Hygiene"]
[]
[null,null,"Estimates on household water, sanitation and hygiene \nby wealth quintile and sub-national region in"]
[null,null,{"$f":"+Water!B5","v":"Argentina"}]
[]
[null,null,"Updated December 2019"]
[]
[null,null,"Follow the links below to find the following information: "]
[]
[null,null,"JMP Estimates"]
[null,null,"WASH status and trends by wealth quintile \n(customized quintiles made without water and sanitation assets)"]
[null,null,"Water"]
[null,null,"Sanitation"]
[null,null,"Hygiene"]
[]
[null,null,"Data inputs"]
[null,null," customized wealth quintiles and subnational data:"]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B105\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B105\")))","v":"MICS12"}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B106\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B106\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B107\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B107\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B108\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B108\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B109\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B109\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B110\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B110\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B111\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B111\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B112\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B112\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B113\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B113\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B114\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B114\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B115\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B115\")))","v":""}]
[null,null,{"$f":"IF(INDIRECT(CONCATENATE(\"Water\",\"!B116\"))=0,\"\",INDIRECT(CONCATENATE(\"Water\",\"!B116\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISNUMBER(M48), \"\", \"Insufficient data to estimate safely managed sanitation services at national level\")","v":"Insufficient data to estimate safely managed sanitation services at national level"}]

{"sheet":"Water","index":1,"n_rows":318,"n_cols":28,"rows_kept":318,"cut":false,"hidden":false,"merged":[[317,1,317,11],[6,9,6,16],[6,17,6,24],[6,1,6,8],[4,1,4,24],[117,1,117,11],[30,21,30,24],[32,1,33,2],[32,3,33,3],[30,17,30,20],[30,1,31,4],[30,5,30,8],[30,9,30,12],[30,13,30,16],[96,23,96,27],[35,1,36,2],[35,3,36,3],[38,1,39,2],[38,3,39,3],[96,0,97,2],[96,3,96,7],[96,8,96,12],[96,13,96,17],[96,18,96,22],[217,18,217,22],[98,0,99,1],[100,0,101,1],[196,0,197,2],[196,3,196,7],[196,8,196,12],[217,1,217,11],[3,1,3,24],[317,18,317,22],[117,18,117,22],[196,18,196,22],[296,23,296,27],[298,0,299,1],[300,0,301,1],[296,0,297,2],[296,3,296,7],[296,8,296,12],[296,13,296,17],[296,18,296,22],[196,23,196,27],[198,0,199,1],[200,0,201,1],[196,13,196,17]]}
["ARG"]
[]
[]
[null,"Summary of trends in drinking water coverage by wealth quintile (%)"]
[null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!A2\"))),\"\",INDIRECT(CONCATENATE($B105,\"!A2\")))","v":"Argentina"}]
[]
[null,{"$f":"B118","v":"National drinking water coverage, 2000–2017"},null,null,null,null,null,null,null,{"$f":"B218","v":"Urban drinking water coverage, 2008–2016"},null,null,null,null,null,null,null,{"$f":"B318","v":"Rural drinking water coverage, 2008–2016"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!A2\"))),\"\",INDIRECT(CONCATENATE($B105,\"!A2\")))","v":"Argentina"},null,null,null,"Poorest",null,null,null,"Poor",null,null,null,"Middle",null,null,null,"Rich",null,null,null,"Richest"]
[null,null,null,null,null,"Basic","Limited","Unimproved","Surface \n water","Basic","Limited","Unimproved","Surface \nwater","Basic","Limited","Unimproved","Surface \nwater","Basic","Limited","Unimproved","Surface \nwater","Basic","Limited","Unimproved","Surface \nwater"]
[null,"NATIONAL",null,"Estimate",{"$f":"C99","v":2000},{"$f":"E99","v":{"$error":"#DIV/0!"}},{"$f":"F99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J99","v":{"$error":"#DIV/0!"}},{"$f":"K99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O99","v":{"$error":"#DIV/0!"}},{"$f":"P99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T99","v":{"$error":"#DIV/0!"}},{"$f":"U99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y99","v":{"$error":"#DIV/0!"}},{"$f":"Z99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C100","v":2017},{"$f":"E100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"URBAN",null,"Estimate",{"$f":"C199","v":2008},{"$f":"E199","v":{"$error":"#DIV/0!"}},{"$f":"F199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J199","v":{"$error":"#DIV/0!"}},{"$f":"K199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O199","v":{"$error":"#DIV/0!"}},{"$f":"P199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T199","v":{"$error":"#DIV/0!"}},{"$f":"U199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y199","v":{"$error":"#DIV/0!"}},{"$f":"Z199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C200","v":2016},{"$f":"E200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"RURAL",null,"Estimate",{"$f":"C299","v":2008},{"$f":"E299","v":{"$error":"#DIV/0!"}},{"$f":"F299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J299","v":{"$error":"#DIV/0!"}},{"$f":"K299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O299","v":{"$error":"#DIV/0!"}},{"$f":"P299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T299","v":{"$error":"#DIV/0!"}},{"$f":"U299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y299","v":{"$error":"#DIV/0!"}},{"$f":"Z299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C300","v":2016},{"$f":"E300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NATIONAL",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water"]
["Forecast period:",null,2000,{"$f":"IF((D101+H101)>100,D101*100/(D101+H101),D101)","v":{"$error":"#DIV/0!"}},{"$f":"D99*AVERAGEIF(E105:E116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D99*(100-AVERAGEIF(E105:E116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E99+F99+H99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D101+H101)>100,H101*100/(D101+H101),H101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I101+M101)>100,I101*100/(I101+M101),I101)","v":{"$error":"#DIV/0!"}},{"$f":"I99*AVERAGEIF(J105:J116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I99*(100-AVERAGEIF(J105:J116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J99+K99+M99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I101+M101)>100,M101*100/(I101+M101),M101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N101+R101)>100,N101*100/(N101+R101),N101)","v":{"$error":"#DIV/0!"}},{"$f":"N99*AVERAGEIF(O105:O116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N99*(100-AVERAGEIF(O105:O116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O99+P99+R99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N101+R101)>100,R101*100/(N101+R101),R101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S101+W101)>100,S101*100/(S101+W101),S101)","v":{"$error":"#DIV/0!"}},{"$f":"S99*AVERAGEIF(T105:T116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S99*(100-AVERAGEIF(T105:T116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T99+U99+W99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S101+W101)>100,W101*100/(S101+W101),W101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X101+AB101)>100,X101*100/(X101+AB101),X101)","v":{"$error":"#DIV/0!"}},{"$f":"X99*AVERAGEIF(Y105:Y116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X99*(100-AVERAGEIF(Y105:Y116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y99+Z99+AB99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X101+AB101)>100,AB101*100/(X101+AB101),AB101)","v":{"$error":"#DIV/0!"}}]
[null,null,2017,{"$f":"IF((D102+H102)>100,D102*100/(D102+H102),D102)","v":{"$error":"#DIV/0!"}},{"$f":"D100*AVERAGEIF(E105:E116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D100*(100-AVERAGEIF(E105:E116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E100+F100+H100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D102+H102)>100,H102*100/(D102+H102),H102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I102+M102)>100,I102*100/(I102+M102),I102)","v":{"$error":"#DIV/0!"}},{"$f":"I100*AVERAGEIF(J105:J116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I100*(100-AVERAGEIF(J105:J116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J100+K100+M100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I102+M102)>100,M102*100/(I102+M102),M102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N102+R102)>100,N102*100/(N102+R102),N102)","v":{"$error":"#DIV/0!"}},{"$f":"N100*AVERAGEIF(O105:O116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N100*(100-AVERAGEIF(O105:O116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O100+P100+R100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N102+R102)>100,R102*100/(N102+R102),R102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S102+W102)>100,S102*100/(S102+W102),S102)","v":{"$error":"#DIV/0!"}},{"$f":"S100*AVERAGEIF(T105:T116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S100*(100-AVERAGEIF(T105:T116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T100+U100+W100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S102+W102)>100,W102*100/(S102+W102),W102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X102+AB102)>100,X102*100/(X102+AB102),X102)","v":{"$error":"#DIV/0!"}},{"$f":"X100*AVERAGEIF(Y105:Y116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X100*(100-AVERAGEIF(Y105:Y116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y100+Z100+AB100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X102+AB102)>100,AB102*100/(X102+AB102),AB102)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C99,C105:C116)","v":2010},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",D105:D116),\nIF(FORECAST($C101,D$105:D$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,D$105:D$116,$C$105:$C$116)>100,100,\nFORECAST($C101,D$105:D$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",H105:H116),\nIF(FORECAST($C101,H$105:H$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,H$105:H$116,$C$105:$C$116)>100,100,\nFORECAST($C101,H$105:H$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",I105:I116),\nIF(FORECAST($C101,I$105:I$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,I$105:I$116,$C$105:$C$116)>100,100,\nFORECAST($C101,I$105:I$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",M105:M116),\nIF(FORECAST($C101,M$105:M$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,M$105:M$116,$C$105:$C$116)>100,100,\nFORECAST($C101,M$105:M$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",N105:N116),\nIF(FORECAST($C101,N$105:N$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,N$105:N$116,$C$105:$C$116)>100,100,\nFORECAST($C101,N$105:N$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",R105:R116),\nIF(FORECAST($C101,R$105:R$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,R$105:R$116,$C$105:$C$116)>100,100,\nFORECAST($C101,R$105:R$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",S105:S116),\nIF(FORECAST($C101,S$105:S$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,S$105:S$116,$C$105:$C$116)>100,100,\nFORECAST($C101,S$105:S$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",W105:W116),\nIF(FORECAST($C101,W$105:W$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,W$105:W$116,$C$105:$C$116)>100,100,\nFORECAST($C101,W$105:W$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",X105:X116),\nIF(FORECAST($C101,X$105:X$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,X$105:X$116,$C$105:$C$116)>100,100,\nFORECAST($C101,X$105:X$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",AB105:AB116),\nIF(FORECAST($C101,AB$105:AB$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,AB$105:AB$116,$C$105:$C$116)>100,100,\nFORECAST($C101,AB$105:AB$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C100,C105:C116)","v":2014},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",D105:D116),\nIF(FORECAST($C102,D$105:D$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,D$105:D$116,$C$105:$C$116)>100,100,\nFORECAST($C102,D$105:D$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",H105:H116),\nIF(FORECAST($C102,H$105:H$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,H$105:H$116,$C$105:$C$116)>100,100,\nFORECAST($C102,H$105:H$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",I105:I116),\nIF(FORECAST($C102,I$105:I$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,I$105:I$116,$C$105:$C$116)>100,100,\nFORECAST($C102,I$105:I$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",M105:M116),\nIF(FORECAST($C102,M$105:M$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,M$105:M$116,$C$105:$C$116)>100,100,\nFORECAST($C102,M$105:M$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",N105:N116),\nIF(FORECAST($C102,N$105:N$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,N$105:N$116,$C$105:$C$116)>100,100,\nFORECAST($C102,N$105:N$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",R105:R116),\nIF(FORECAST($C102,R$105:R$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,R$105:R$116,$C$105:$C$116)>100,100,\nFORECAST($C102,R$105:R$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",S105:S116),\nIF(FORECAST($C102,S$105:S$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,S$105:S$116,$C$105:$C$116)>100,100,\nFORECAST($C102,S$105:S$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",W105:W116),\nIF(FORECAST($C102,W$105:W$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,W$105:W$116,$C$105:$C$116)>100,100,\nFORECAST($C102,W$105:W$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",X105:X116),\nIF(FORECAST($C102,X$105:X$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,X$105:X$116,$C$105:$C$116)>100,100,\nFORECAST($C102,X$105:X$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",AB105:AB116),\nIF(FORECAST($C102,AB$105:AB$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,AB$105:AB$116,$C$105:$C$116)>100,100,\nFORECAST($C102,AB$105:AB$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C16\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C23\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C21\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D16\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D23\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D21\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E16\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E23\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E21\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F16\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F23\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F21\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G16\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G23\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G221\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G21\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!C16\"))),\"\",INDIRECT(CONCATENATE($B112,\"!C16\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!C23\"))),\"\",INDIRECT(CONCATENATE($B112,\"!C23\")))","v":""},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!C21\"))),\"\",INDIRECT(CONCATENATE($B112,\"!C21\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!D16\"))),\"\",INDIRECT(CONCATENATE($B112,\"!D16\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!D23\"))),\"\",INDIRECT(CONCATENATE($B112,\"!D23\")))","v":""},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!D21\"))),\"\",INDIRECT(CONCATENATE($B112,\"!D21\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!E16\"))),\"\",INDIRECT(CONCATENATE($B112,\"!E16\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!E23\"))),\"\",INDIRECT(CONCATENATE($B112,\"!E23\")))","v":""},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!E21\"))),\"\",INDIRECT(CONCATENATE($B112,\"!E21\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!F16\"))),\"\",INDIRECT(CONCATENATE($B112,\"!F16\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!F23\"))),\"\",INDIRECT(CONCATENATE($B112,\"!F23\")))","v":""},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!F21\"))),\"\",INDIRECT(CONCATENATE($B112,\"!F21\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!G16\"))),\"\",INDIRECT(CONCATENATE($B112,\"!G16\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!G23\"))),\"\",INDIRECT(CONCATENATE($B112,\"!G23\")))","v":""},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B112,\"!G221\"))),\"\",INDIRECT(CONCATENATE($B112,\"!G21\")))","v":""}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"National drinking water coverage, \",C99,\"–\",C100)","v":"National drinking water coverage, 2000–2017"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B153,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B153,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B153,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B153,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B153,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B153,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B153,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B153,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B153,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B153,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B153,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B153,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B153,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B153,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B153,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B153,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B153,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B153,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B153,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B153,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B153,\"!Q1\")))","v":""}]
[null,null,null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,"","","",""]
[null,null,null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,"","","",""]
[null,null,null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,"","","",""]
[null,null,null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,"","","",""]
[null,null,null,null,"","","","",null,"","","","",null,"","","","",null,"","","","",null,"","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["URBAN",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water"]
["Forecast period:",null,{"$f":"MinBase(C205:C216)","v":2008},{"$f":"IF((D201+H201)>100,D201*100/(D201+H201),D201)","v":{"$error":"#DIV/0!"}},{"$f":"D199*AVERAGEIF(E205:E216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D199*(100-AVERAGEIF(E205:E216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E199+F199+H199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D201+H201)>100,H201*100/(D201+H201),H201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I201+M201)>100,I201*100/(I201+M201),I201)","v":{"$error":"#DIV/0!"}},{"$f":"I199*AVERAGEIF(J205:J216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I199*(100-AVERAGEIF(J205:J216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J199+K199+M199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I201+M201)>100,M201*100/(I201+M201),M201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N201+R201)>100,N201*100/(N201+R201),N201)","v":{"$error":"#DIV/0!"}},{"$f":"N199*AVERAGEIF(O205:O216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N199*(100-AVERAGEIF(O205:O216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O199+P199+R199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N201+R201)>100,R201*100/(N201+R201),R201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S201+W201)>100,S201*100/(S201+W201),S201)","v":{"$error":"#DIV/0!"}},{"$f":"S199*AVERAGEIF(T205:T216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S199*(100-AVERAGEIF(T205:T216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T199+U199+W199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S201+W201)>100,W201*100/(S201+W201),W201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X201+AB201)>100,X201*100/(X201+AB201),X201)","v":{"$error":"#DIV/0!"}},{"$f":"X199*AVERAGEIF(Y205:Y216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X199*(100-AVERAGEIF(Y205:Y216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y199+Z199+AB199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X201+AB201)>100,AB201*100/(X201+AB201),AB201)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxTarget(C205:C216)","v":2016},{"$f":"IF((D202+H202)>100,D202*100/(D202+H202),D202)","v":{"$error":"#DIV/0!"}},{"$f":"D200*AVERAGEIF(E205:E216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D200*(100-AVERAGEIF(E205:E216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E200+F200+H200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D202+H202)>100,H202*100/(D202+H202),H202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I202+M202)>100,I202*100/(I202+M202),I202)","v":{"$error":"#DIV/0!"}},{"$f":"I200*AVERAGEIF(J205:J216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I200*(100-AVERAGEIF(J205:J216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J200+K200+M200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I202+M202)>100,M202*100/(I202+M202),M202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N202+R202)>100,N202*100/(N202+R202),N202)","v":{"$error":"#DIV/0!"}},{"$f":"N200*AVERAGEIF(O205:O216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N200*(100-AVERAGEIF(O205:O216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O200+P200+R200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N202+R202)>100,R202*100/(N202+R202),R202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S202+W202)>100,S202*100/(S202+W202),S202)","v":{"$error":"#DIV/0!"}},{"$f":"S200*AVERAGEIF(T205:T216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S200*(100-AVERAGEIF(T205:T216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T200+U200+W200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S202+W202)>100,W202*100/(S202+W202),W202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X202+AB202)>100,X202*100/(X202+AB202),X202)","v":{"$error":"#DIV/0!"}},{"$f":"X200*AVERAGEIF(Y205:Y216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X200*(100-AVERAGEIF(Y205:Y216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y200+Z200+AB200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X202+AB202)>100,AB202*100/(X202+AB202),AB202)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C199,C205:C216)","v":2010},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",D205:D216),\nIF(FORECAST($C201,D$205:D$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,D$205:D$216,$C$205:$C$216)>100,100,\nFORECAST($C201,D$205:D$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",H205:H216),\nIF(FORECAST($C201,H$205:H$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,H$205:H$216,$C$205:$C$216)>100,100,\nFORECAST($C201,H$205:H$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",I205:I216),\nIF(FORECAST($C201,I$205:I$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,I$205:I$216,$C$205:$C$216)>100,100,\nFORECAST($C201,I$205:I$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",M205:M216),\nIF(FORECAST($C201,M$205:M$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,M$205:M$216,$C$205:$C$216)>100,100,\nFORECAST($C201,M$205:M$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",N205:N216),\nIF(FORECAST($C201,N$205:N$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,N$205:N$216,$C$205:$C$216)>100,100,\nFORECAST($C201,N$205:N$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",R205:R216),\nIF(FORECAST($C201,R$205:R$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,R$205:R$216,$C$205:$C$216)>100,100,\nFORECAST($C201,R$205:R$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",S205:S216),\nIF(FORECAST($C201,S$205:S$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,S$205:S$216,$C$205:$C$216)>100,100,\nFORECAST($C201,S$205:S$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",W205:W216),\nIF(FORECAST($C201,W$205:W$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,W$205:W$216,$C$205:$C$216)>100,100,\nFORECAST($C201,W$205:W$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",X205:X216),\nIF(FORECAST($C201,X$205:X$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,X$205:X$216,$C$205:$C$216)>100,100,\nFORECAST($C201,X$205:X$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",AB205:AB216),\nIF(FORECAST($C201,AB$205:AB$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,AB$205:AB$216,$C$205:$C$216)>100,100,\nFORECAST($C201,AB$205:AB$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C200,C205:C216)","v":2014},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",D205:D216),\nIF(FORECAST($C202,D$205:D$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,D$205:D$216,$C$205:$C$216)>100,100,\nFORECAST($C202,D$205:D$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",H205:H216),\nIF(FORECAST($C202,H$205:H$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,H$205:H$216,$C$205:$C$216)>100,100,\nFORECAST($C202,H$205:H$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",I205:I216),\nIF(FORECAST($C202,I$205:I$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,I$205:I$216,$C$205:$C$216)>100,100,\nFORECAST($C202,I$205:I$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",M205:M216),\nIF(FORECAST($C202,M$205:M$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,M$205:M$216,$C$205:$C$216)>100,100,\nFORECAST($C202,M$205:M$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",N205:N216),\nIF(FORECAST($C202,N$205:N$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,N$205:N$216,$C$205:$C$216)>100,100,\nFORECAST($C202,N$205:N$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",R205:R216),\nIF(FORECAST($C202,R$205:R$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,R$205:R$216,$C$205:$C$216)>100,100,\nFORECAST($C202,R$205:R$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",S205:S216),\nIF(FORECAST($C202,S$205:S$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,S$205:S$216,$C$205:$C$216)>100,100,\nFORECAST($C202,S$205:S$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",W205:W216),\nIF(FORECAST($C202,W$205:W$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,W$205:W$216,$C$205:$C$216)>100,100,\nFORECAST($C202,W$205:W$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",X205:X216),\nIF(FORECAST($C202,X$205:X$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,X$205:X$216,$C$205:$C$216)>100,100,\nFORECAST($C202,X$205:X$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",AB205:AB216),\nIF(FORECAST($C202,AB$205:AB$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,AB$205:AB$216,$C$205:$C$216)>100,100,\nFORECAST($C202,AB$205:AB$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H16\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H23\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H21\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I16\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I23\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I21\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J16\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J23\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J21\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K16\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K23\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K21\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L16\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L23\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L221\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L21\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"Urban drinking water coverage, \",C199,\"–\",C200)","v":"Urban drinking water coverage, 2008–2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B253,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B253,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B253,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B253,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B253,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B253,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B253,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B253,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B253,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B253,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B253,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B253,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B253,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B253,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B253,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B253,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B253,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B253,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B253,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B253,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B253,\"!Q1\")))","v":""}]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B254,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B254,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B254,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B254,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B254,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B254,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B254,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B254,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B254,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B254,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B254,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B254,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B254,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B254,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B254,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B254,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B254,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B254,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B254,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B254,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B254,\"!Q1\")))","v":""}]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B255,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B255,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B255,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B255,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B255,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B255,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B255,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B255,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B255,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B255,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B255,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B255,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B255,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B255,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B255,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B255,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B255,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B255,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B255,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B255,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B255,\"!Q1\")))","v":""}]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B256,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B256,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B256,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B256,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B256,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B256,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B256,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B256,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B256,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B256,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B256,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B256,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B256,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B256,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B256,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B256,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B256,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B256,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B256,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B256,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B256,\"!Q1\")))","v":""}]
[null,null,null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!M18\"))),\"\",INDIRECT(CONCATENATE($B257,\"!M18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!M19\"))),\"\",INDIRECT(CONCATENATE($B257,\"!M19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!M20\"))),\"\",INDIRECT(CONCATENATE($B257,\"!M20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B257,\"!M21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!N18\"))),\"\",INDIRECT(CONCATENATE($B257,\"!N18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!N19\"))),\"\",INDIRECT(CONCATENATE($B257,\"!N19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!N20\"))),\"\",INDIRECT(CONCATENATE($B257,\"!N20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B257,\"!N21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!O18\"))),\"\",INDIRECT(CONCATENATE($B257,\"!O18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!O19\"))),\"\",INDIRECT(CONCATENATE($B257,\"!O19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!O20\"))),\"\",INDIRECT(CONCATENATE($B257,\"!O20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B257,\"!O21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!P18\"))),\"\",INDIRECT(CONCATENATE($B257,\"!P18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!P19\"))),\"\",INDIRECT(CONCATENATE($B257,\"!P19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!P20\"))),\"\",INDIRECT(CONCATENATE($B257,\"!P20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B257,\"!P21\")))","v":""},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!Q18\"))),\"\",INDIRECT(CONCATENATE($B257,\"!Q18\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!Q19\"))),\"\",INDIRECT(CONCATENATE($B257,\"!Q19\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!Q20\"))),\"\",INDIRECT(CONCATENATE($B257,\"!Q20\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B257,\"!Q21\"))),\"\",INDIRECT(CONCATENATE($B257,\"!Q1\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RURAL",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water","Improved","Basic","Limited","Unimproved","Surface water"]
["Forecast period:",null,{"$f":"MinBase(C305:C316)","v":2008},{"$f":"IF((D301+H301)>100,D301*100/(D301+H301),D301)","v":{"$error":"#DIV/0!"}},{"$f":"D299*AVERAGEIF(E305:E316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D299*(100-AVERAGEIF(E305:E316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E299+F299+H299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D301+H301)>100,H301*100/(D301+H301),H301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I301+M301)>100,I301*100/(I301+M301),I301)","v":{"$error":"#DIV/0!"}},{"$f":"I299*AVERAGEIF(J305:J316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I299*(100-AVERAGEIF(J305:J316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J299+K299+M299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I301+M301)>100,M301*100/(I301+M301),M301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N301+R301)>100,N301*100/(N301+R301),N301)","v":{"$error":"#DIV/0!"}},{"$f":"N299*AVERAGEIF(O305:O316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N299*(100-AVERAGEIF(O305:O316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O299+P299+R299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N301+R301)>100,R301*100/(N301+R301),R301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S301+W301)>100,S301*100/(S301+W301),S301)","v":{"$error":"#DIV/0!"}},{"$f":"S299*AVERAGEIF(T305:T316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S299*(100-AVERAGEIF(T305:T316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T299+U299+W299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S301+W301)>100,W301*100/(S301+W301),W301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X301+AB301)>100,X301*100/(X301+AB301),X301)","v":{"$error":"#DIV/0!"}},{"$f":"X299*AVERAGEIF(Y305:Y316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X299*(100-AVERAGEIF(Y305:Y316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y299+Z299+AB299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X301+AB301)>100,AB301*100/(X301+AB301),AB301)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxTarget(C305:C316)","v":2016},{"$f":"IF((D302+H302)>100,D302*100/(D302+H302),D302)","v":{"$error":"#DIV/0!"}},{"$f":"D300*AVERAGEIF(E305:E316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D300*(100-AVERAGEIF(E305:E316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E300+F300+H300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D302+H302)>100,H302*100/(D302+H302),H302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I302+M302)>100,I302*100/(I302+M302),I302)","v":{"$error":"#DIV/0!"}},{"$f":"I300*AVERAGEIF(J305:J316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I300*(100-AVERAGEIF(J305:J316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J300+K300+M300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I302+M302)>100,M302*100/(I302+M302),M302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N302+R302)>100,N302*100/(N302+R302),N302)","v":{"$error":"#DIV/0!"}},{"$f":"N300*AVERAGEIF(O305:O316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N300*(100-AVERAGEIF(O305:O316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O300+P300+R300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N302+R302)>100,R302*100/(N302+R302),R302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S302+W302)>100,S302*100/(S302+W302),S302)","v":{"$error":"#DIV/0!"}},{"$f":"S300*AVERAGEIF(T305:T316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S300*(100-AVERAGEIF(T305:T316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T300+U300+W300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S302+W302)>100,W302*100/(S302+W302),W302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X302+AB302)>100,X302*100/(X302+AB302),X302)","v":{"$error":"#DIV/0!"}},{"$f":"X300*AVERAGEIF(Y305:Y316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X300*(100-AVERAGEIF(Y305:Y316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y300+Z300+AB300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X302+AB302)>100,AB302*100/(X302+AB302),AB302)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C299,C305:C316)","v":2010},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",D305:D316),\nIF(FORECAST($C301,D$305:D$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,D$305:D$316,$C$305:$C$316)>100,100,\nFORECAST($C301,D$305:D$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",H305:H316),\nIF(FORECAST($C301,H$305:H$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,H$305:H$316,$C$305:$C$316)>100,100,\nFORECAST($C301,H$305:H$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",I305:I316),\nIF(FORECAST($C301,I$305:I$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,I$305:I$316,$C$305:$C$316)>100,100,\nFORECAST($C301,I$305:I$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",M305:M316),\nIF(FORECAST($C301,M$305:M$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,M$305:M$316,$C$305:$C$316)>100,100,\nFORECAST($C301,M$305:M$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",N305:N316),\nIF(FORECAST($C301,N$305:N$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,N$305:N$316,$C$305:$C$316)>100,100,\nFORECAST($C301,N$305:N$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",R305:R316),\nIF(FORECAST($C301,R$305:R$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,R$305:R$316,$C$305:$C$316)>100,100,\nFORECAST($C301,R$305:R$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",S305:S316),\nIF(FORECAST($C301,S$305:S$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,S$305:S$316,$C$305:$C$316)>100,100,\nFORECAST($C301,S$305:S$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",W305:W316),\nIF(FORECAST($C301,W$305:W$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,W$305:W$316,$C$305:$C$316)>100,100,\nFORECAST($C301,W$305:W$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",X305:X316),\nIF(FORECAST($C301,X$305:X$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,X$305:X$316,$C$305:$C$316)>100,100,\nFORECAST($C301,X$305:X$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",AB305:AB316),\nIF(FORECAST($C301,AB$305:AB$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,AB$305:AB$316,$C$305:$C$316)>100,100,\nFORECAST($C301,AB$305:AB$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C300,C305:C316)","v":2014},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",D305:D316),\nIF(FORECAST($C302,D$305:D$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,D$305:D$316,$C$305:$C$316)>100,100,\nFORECAST($C302,D$305:D$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",H305:H316),\nIF(FORECAST($C302,H$305:H$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,H$305:H$316,$C$305:$C$316)>100,100,\nFORECAST($C302,H$305:H$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",I305:I316),\nIF(FORECAST($C302,I$305:I$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,I$305:I$316,$C$305:$C$316)>100,100,\nFORECAST($C302,I$305:I$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",M305:M316),\nIF(FORECAST($C302,M$305:M$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,M$305:M$316,$C$305:$C$316)>100,100,\nFORECAST($C302,M$305:M$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",N305:N316),\nIF(FORECAST($C302,N$305:N$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,N$305:N$316,$C$305:$C$316)>100,100,\nFORECAST($C302,N$305:N$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",R305:R316),\nIF(FORECAST($C302,R$305:R$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,R$305:R$316,$C$305:$C$316)>100,100,\nFORECAST($C302,R$305:R$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",S305:S316),\nIF(FORECAST($C302,S$305:S$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,S$305:S$316,$C$305:$C$316)>100,100,\nFORECAST($C302,S$305:S$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",W305:W316),\nIF(FORECAST($C302,W$305:W$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,W$305:W$316,$C$305:$C$316)>100,100,\nFORECAST($C302,W$305:W$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",X305:X316),\nIF(FORECAST($C302,X$305:X$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,X$305:X$316,$C$305:$C$316)>100,100,\nFORECAST($C302,X$305:X$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",AB305:AB316),\nIF(FORECAST($C302,AB$305:AB$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,AB$305:AB$316,$C$305:$C$316)>100,100,\nFORECAST($C302,AB$305:AB$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water","Improved","Improved\n<=30 min",null,null,"Surface water"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M16\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M23\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M21\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N16\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N23\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N21\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O16\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O23\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O21\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P16\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P23\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P21\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P21\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q16\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q16\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q23\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q23\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q221\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q21\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"Rural drinking water coverage, \",C299,\"–\",C300)","v":"Rural drinking water coverage, 2008–2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]

{"sheet":"Sanitation","index":2,"n_rows":318,"n_cols":28,"rows_kept":318,"cut":false,"hidden":false,"merged":[[298,0,299,1],[300,0,301,1],[317,18,317,22],[196,23,196,27],[198,0,199,1],[200,0,201,1],[217,18,217,22],[296,0,297,2],[296,3,296,7],[296,8,296,12],[296,13,296,17],[296,18,296,22],[296,23,296,27],[217,1,217,11],[317,1,317,11],[98,0,99,1],[100,0,101,1],[117,18,117,22],[196,0,197,2],[196,3,196,7],[196,8,196,12],[196,13,196,17],[196,18,196,22],[117,1,117,11],[96,23,96,27],[32,1,33,2],[32,3,33,3],[35,1,36,2],[35,3,36,3],[38,1,39,2],[38,3,39,3],[96,0,97,2],[96,3,96,7],[96,8,96,12],[96,13,96,17],[96,18,96,22],[30,21,30,24],[4,1,4,24],[3,1,3,24],[6,1,6,8],[6,9,6,16],[6,17,6,24],[30,1,31,4],[30,5,30,8],[30,9,30,12],[30,13,30,16],[30,17,30,20]]}
[]
[]
[]
[null,"Summary of trends in sanitation coverage by wealth quintile (%)"]
[null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!A2\"))),\"\",INDIRECT(CONCATENATE($B105,\"!A2\")))","v":"Argentina"}]
[]
[null,{"$f":"B118","v":"National sanitation coverage, 2008–2016"},null,null,null,null,null,null,null,{"$f":"B218","v":"Urban sanitation coverage, 2008–2016"},null,null,null,null,null,null,null,{"$f":"B318","v":"Rural sanitation coverage, 2008–2016"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!A2\"))),\"\",INDIRECT(CONCATENATE($B105,\"!A2\")))","v":"Argentina"},null,null,null,"Poorest",null,null,null,"Poor",null,null,null,"Middle",null,null,null,"Rich",null,null,null,"Richest"]
[null,null,null,null,null,"Basic","Limited","Unimproved","Open defecation","Basic","Limited","Unimproved","Open defecation","Basic","Limited","Unimproved","Open defecation","Basic","Limited","Unimproved","Open defecation","Basic","Limited","Unimproved","Open defecation"]
[null,"NATIONAL",null,"Estimate",{"$f":"C99","v":2008},{"$f":"E99","v":{"$error":"#DIV/0!"}},{"$f":"F99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J99","v":{"$error":"#DIV/0!"}},{"$f":"K99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O99","v":{"$error":"#DIV/0!"}},{"$f":"P99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T99","v":{"$error":"#DIV/0!"}},{"$f":"U99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y99","v":{"$error":"#DIV/0!"}},{"$f":"Z99","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C100","v":2016},{"$f":"E100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"URBAN",null,"Estimate",{"$f":"C199","v":2008},{"$f":"E199","v":{"$error":"#DIV/0!"}},{"$f":"F199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J199","v":{"$error":"#DIV/0!"}},{"$f":"K199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O199","v":{"$error":"#DIV/0!"}},{"$f":"P199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T199","v":{"$error":"#DIV/0!"}},{"$f":"U199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y199","v":{"$error":"#DIV/0!"}},{"$f":"Z199","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C200","v":2016},{"$f":"E200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y200","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"RURAL",null,"Estimate",{"$f":"C299","v":2008},{"$f":"E299","v":{"$error":"#DIV/0!"}},{"$f":"F299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J299","v":{"$error":"#DIV/0!"}},{"$f":"K299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O299","v":{"$error":"#DIV/0!"}},{"$f":"P299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T299","v":{"$error":"#DIV/0!"}},{"$f":"U299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y299","v":{"$error":"#DIV/0!"}},{"$f":"Z299","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"C300","v":2016},{"$f":"E300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"T300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Y300","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NATIONAL",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation"]
["Forecast period:",null,{"$f":"MinBase(C105:C116)","v":2008},{"$f":"IF((D101+H101)>100,D101*100/(D101+H101),D101)","v":{"$error":"#DIV/0!"}},{"$f":"D99*AVERAGEIF(E105:E116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D99*(100-AVERAGEIF(E105:E116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E99+F99+H99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D101+H101)>100,H101*100/(D101+H101),H101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I101+M101)>100,I101*100/(I101+M101),I101)","v":{"$error":"#DIV/0!"}},{"$f":"I99*AVERAGEIF(J105:J116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I99*(100-AVERAGEIF(J105:J116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J99+K99+M99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I101+M101)>100,M101*100/(I101+M101),M101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N101+R101)>100,N101*100/(N101+R101),N101)","v":{"$error":"#DIV/0!"}},{"$f":"N99*AVERAGEIF(O105:O116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N99*(100-AVERAGEIF(O105:O116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O99+P99+R99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N101+R101)>100,R101*100/(N101+R101),R101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S101+W101)>100,S101*100/(S101+W101),S101)","v":{"$error":"#DIV/0!"}},{"$f":"S99*AVERAGEIF(T105:T116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S99*(100-AVERAGEIF(T105:T116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T99+U99+W99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S101+W101)>100,W101*100/(S101+W101),W101)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X101+AB101)>100,X101*100/(X101+AB101),X101)","v":{"$error":"#DIV/0!"}},{"$f":"X99*AVERAGEIF(Y105:Y116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X99*(100-AVERAGEIF(Y105:Y116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y99+Z99+AB99)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X101+AB101)>100,AB101*100/(X101+AB101),AB101)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxTarget(C105:C116)","v":2016},{"$f":"IF((D102+H102)>100,D102*100/(D102+H102),D102)","v":{"$error":"#DIV/0!"}},{"$f":"D100*AVERAGEIF(E105:E116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D100*(100-AVERAGEIF(E105:E116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E100+F100+H100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D102+H102)>100,H102*100/(D102+H102),H102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I102+M102)>100,I102*100/(I102+M102),I102)","v":{"$error":"#DIV/0!"}},{"$f":"I100*AVERAGEIF(J105:J116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I100*(100-AVERAGEIF(J105:J116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J100+K100+M100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I102+M102)>100,M102*100/(I102+M102),M102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N102+R102)>100,N102*100/(N102+R102),N102)","v":{"$error":"#DIV/0!"}},{"$f":"N100*AVERAGEIF(O105:O116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N100*(100-AVERAGEIF(O105:O116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O100+P100+R100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N102+R102)>100,R102*100/(N102+R102),R102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S102+W102)>100,S102*100/(S102+W102),S102)","v":{"$error":"#DIV/0!"}},{"$f":"S100*AVERAGEIF(T105:T116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S100*(100-AVERAGEIF(T105:T116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T100+U100+W100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S102+W102)>100,W102*100/(S102+W102),W102)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X102+AB102)>100,X102*100/(X102+AB102),X102)","v":{"$error":"#DIV/0!"}},{"$f":"X100*AVERAGEIF(Y105:Y116,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X100*(100-AVERAGEIF(Y105:Y116,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y100+Z100+AB100)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X102+AB102)>100,AB102*100/(X102+AB102),AB102)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C99,C105:C116)","v":2010},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",D105:D116),\nIF(FORECAST($C101,D$105:D$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,D$105:D$116,$C$105:$C$116)>100,100,\nFORECAST($C101,D$105:D$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",H105:H116),\nIF(FORECAST($C101,H$105:H$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,H$105:H$116,$C$105:$C$116)>100,100,\nFORECAST($C101,H$105:H$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",I105:I116),\nIF(FORECAST($C101,I$105:I$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,I$105:I$116,$C$105:$C$116)>100,100,\nFORECAST($C101,I$105:I$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",M105:M116),\nIF(FORECAST($C101,M$105:M$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,M$105:M$116,$C$105:$C$116)>100,100,\nFORECAST($C101,M$105:M$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",N105:N116),\nIF(FORECAST($C101,N$105:N$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,N$105:N$116,$C$105:$C$116)>100,100,\nFORECAST($C101,N$105:N$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",R105:R116),\nIF(FORECAST($C101,R$105:R$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,R$105:R$116,$C$105:$C$116)>100,100,\nFORECAST($C101,R$105:R$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",S105:S116),\nIF(FORECAST($C101,S$105:S$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,S$105:S$116,$C$105:$C$116)>100,100,\nFORECAST($C101,S$105:S$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",W105:W116),\nIF(FORECAST($C101,W$105:W$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,W$105:W$116,$C$105:$C$116)>100,100,\nFORECAST($C101,W$105:W$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",X105:X116),\nIF(FORECAST($C101,X$105:X$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,X$105:X$116,$C$105:$C$116)>100,100,\nFORECAST($C101,X$105:X$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",AB105:AB116),\nIF(FORECAST($C101,AB$105:AB$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C101,AB$105:AB$116,$C$105:$C$116)>100,100,\nFORECAST($C101,AB$105:AB$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C100,C105:C116)","v":2014},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",D105:D116),\nIF(FORECAST($C102,D$105:D$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,D$105:D$116,$C$105:$C$116)>100,100,\nFORECAST($C102,D$105:D$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",H105:H116),\nIF(FORECAST($C102,H$105:H$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,H$105:H$116,$C$105:$C$116)>100,100,\nFORECAST($C102,H$105:H$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",I105:I116),\nIF(FORECAST($C102,I$105:I$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,I$105:I$116,$C$105:$C$116)>100,100,\nFORECAST($C102,I$105:I$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",M105:M116),\nIF(FORECAST($C102,M$105:M$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,M$105:M$116,$C$105:$C$116)>100,100,\nFORECAST($C102,M$105:M$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",N105:N116),\nIF(FORECAST($C102,N$105:N$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,N$105:N$116,$C$105:$C$116)>100,100,\nFORECAST($C102,N$105:N$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",R105:R116),\nIF(FORECAST($C102,R$105:R$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,R$105:R$116,$C$105:$C$116)>100,100,\nFORECAST($C102,R$105:R$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",S105:S116),\nIF(FORECAST($C102,S$105:S$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,S$105:S$116,$C$105:$C$116)>100,100,\nFORECAST($C102,S$105:S$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",W105:W116),\nIF(FORECAST($C102,W$105:W$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,W$105:W$116,$C$105:$C$116)>100,100,\nFORECAST($C102,W$105:W$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",X105:X116),\nIF(FORECAST($C102,X$105:X$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,X$105:X$116,$C$105:$C$116)>100,100,\nFORECAST($C102,X$105:X$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C105:C116)-MIN(C105:C116)<5,AVERAGEIF(C105:C116,\">0\",AB105:AB116),\nIF(FORECAST($C102,AB$105:AB$116,$C$105:$C$116)<0,0,\nIF(FORECAST($C102,AB$105:AB$116,$C$105:$C$116)>100,100,\nFORECAST($C102,AB$105:AB$116,$C$105:$C$116))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C122\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C129\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!C127\"))),\"\",INDIRECT(CONCATENATE($B105,\"!C127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D122\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D129\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!D127\"))),\"\",INDIRECT(CONCATENATE($B105,\"!D127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E122\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E129\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!E127\"))),\"\",INDIRECT(CONCATENATE($B105,\"!E127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F122\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F129\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!F127\"))),\"\",INDIRECT(CONCATENATE($B105,\"!F127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G122\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G129\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B105,\"!G2127\"))),\"\",INDIRECT(CONCATENATE($B105,\"!G127\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"National sanitation coverage, \",C99,\"–\",C100)","v":"National sanitation coverage, 2008–2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["URBAN",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation"]
["Forecast period:",null,{"$f":"MinBase(C205:C216)","v":2008},{"$f":"IF((D201+H201)>100,D201*100/(D201+H201),D201)","v":{"$error":"#DIV/0!"}},{"$f":"D199*AVERAGEIF(E205:E216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D199*(100-AVERAGEIF(E205:E216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E199+F199+H199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D201+H201)>100,H201*100/(D201+H201),H201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I201+M201)>100,I201*100/(I201+M201),I201)","v":{"$error":"#DIV/0!"}},{"$f":"I199*AVERAGEIF(J205:J216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I199*(100-AVERAGEIF(J205:J216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J199+K199+M199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I201+M201)>100,M201*100/(I201+M201),M201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N201+R201)>100,N201*100/(N201+R201),N201)","v":{"$error":"#DIV/0!"}},{"$f":"N199*AVERAGEIF(O205:O216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N199*(100-AVERAGEIF(O205:O216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O199+P199+R199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N201+R201)>100,R201*100/(N201+R201),R201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S201+W201)>100,S201*100/(S201+W201),S201)","v":{"$error":"#DIV/0!"}},{"$f":"S199*AVERAGEIF(T205:T216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S199*(100-AVERAGEIF(T205:T216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T199+U199+W199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S201+W201)>100,W201*100/(S201+W201),W201)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X201+AB201)>100,X201*100/(X201+AB201),X201)","v":{"$error":"#DIV/0!"}},{"$f":"X199*AVERAGEIF(Y205:Y216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X199*(100-AVERAGEIF(Y205:Y216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y199+Z199+AB199)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X201+AB201)>100,AB201*100/(X201+AB201),AB201)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxTarget(C205:C216)","v":2016},{"$f":"IF((D202+H202)>100,D202*100/(D202+H202),D202)","v":{"$error":"#DIV/0!"}},{"$f":"D200*AVERAGEIF(E205:E216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D200*(100-AVERAGEIF(E205:E216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E200+F200+H200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D202+H202)>100,H202*100/(D202+H202),H202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I202+M202)>100,I202*100/(I202+M202),I202)","v":{"$error":"#DIV/0!"}},{"$f":"I200*AVERAGEIF(J205:J216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I200*(100-AVERAGEIF(J205:J216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J200+K200+M200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I202+M202)>100,M202*100/(I202+M202),M202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N202+R202)>100,N202*100/(N202+R202),N202)","v":{"$error":"#DIV/0!"}},{"$f":"N200*AVERAGEIF(O205:O216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N200*(100-AVERAGEIF(O205:O216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O200+P200+R200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N202+R202)>100,R202*100/(N202+R202),R202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S202+W202)>100,S202*100/(S202+W202),S202)","v":{"$error":"#DIV/0!"}},{"$f":"S200*AVERAGEIF(T205:T216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S200*(100-AVERAGEIF(T205:T216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T200+U200+W200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S202+W202)>100,W202*100/(S202+W202),W202)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X202+AB202)>100,X202*100/(X202+AB202),X202)","v":{"$error":"#DIV/0!"}},{"$f":"X200*AVERAGEIF(Y205:Y216,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X200*(100-AVERAGEIF(Y205:Y216,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y200+Z200+AB200)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X202+AB202)>100,AB202*100/(X202+AB202),AB202)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C199,C205:C216)","v":2010},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",D205:D216),\nIF(FORECAST($C201,D$205:D$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,D$205:D$216,$C$205:$C$216)>100,100,\nFORECAST($C201,D$205:D$216,$C$205:$C$216))))","v":91.091329557352935},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",H205:H216),\nIF(FORECAST($C201,H$205:H$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,H$205:H$216,$C$205:$C$216)>100,100,\nFORECAST($C201,H$205:H$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",I205:I216),\nIF(FORECAST($C201,I$205:I$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,I$205:I$216,$C$205:$C$216)>100,100,\nFORECAST($C201,I$205:I$216,$C$205:$C$216))))","v":95.665616622149059},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",M205:M216),\nIF(FORECAST($C201,M$205:M$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,M$205:M$216,$C$205:$C$216)>100,100,\nFORECAST($C201,M$205:M$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",N205:N216),\nIF(FORECAST($C201,N$205:N$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,N$205:N$216,$C$205:$C$216)>100,100,\nFORECAST($C201,N$205:N$216,$C$205:$C$216))))","v":96.960065284540192},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",R205:R216),\nIF(FORECAST($C201,R$205:R$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,R$205:R$216,$C$205:$C$216)>100,100,\nFORECAST($C201,R$205:R$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",S205:S216),\nIF(FORECAST($C201,S$205:S$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,S$205:S$216,$C$205:$C$216)>100,100,\nFORECAST($C201,S$205:S$216,$C$205:$C$216))))","v":97.448050333876878},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",W205:W216),\nIF(FORECAST($C201,W$205:W$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,W$205:W$216,$C$205:$C$216)>100,100,\nFORECAST($C201,W$205:W$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",X205:X216),\nIF(FORECAST($C201,X$205:X$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,X$205:X$216,$C$205:$C$216)>100,100,\nFORECAST($C201,X$205:X$216,$C$205:$C$216))))","v":98.689323768873763},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",AB205:AB216),\nIF(FORECAST($C201,AB$205:AB$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C201,AB$205:AB$216,$C$205:$C$216)>100,100,\nFORECAST($C201,AB$205:AB$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C200,C205:C216)","v":2014},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",D205:D216),\nIF(FORECAST($C202,D$205:D$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,D$205:D$216,$C$205:$C$216)>100,100,\nFORECAST($C202,D$205:D$216,$C$205:$C$216))))","v":91.091329557352935},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",H205:H216),\nIF(FORECAST($C202,H$205:H$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,H$205:H$216,$C$205:$C$216)>100,100,\nFORECAST($C202,H$205:H$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",I205:I216),\nIF(FORECAST($C202,I$205:I$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,I$205:I$216,$C$205:$C$216)>100,100,\nFORECAST($C202,I$205:I$216,$C$205:$C$216))))","v":95.665616622149059},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",M205:M216),\nIF(FORECAST($C202,M$205:M$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,M$205:M$216,$C$205:$C$216)>100,100,\nFORECAST($C202,M$205:M$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",N205:N216),\nIF(FORECAST($C202,N$205:N$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,N$205:N$216,$C$205:$C$216)>100,100,\nFORECAST($C202,N$205:N$216,$C$205:$C$216))))","v":96.960065284540192},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",R205:R216),\nIF(FORECAST($C202,R$205:R$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,R$205:R$216,$C$205:$C$216)>100,100,\nFORECAST($C202,R$205:R$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",S205:S216),\nIF(FORECAST($C202,S$205:S$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,S$205:S$216,$C$205:$C$216)>100,100,\nFORECAST($C202,S$205:S$216,$C$205:$C$216))))","v":97.448050333876878},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",W205:W216),\nIF(FORECAST($C202,W$205:W$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,W$205:W$216,$C$205:$C$216)>100,100,\nFORECAST($C202,W$205:W$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",X205:X216),\nIF(FORECAST($C202,X$205:X$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,X$205:X$216,$C$205:$C$216)>100,100,\nFORECAST($C202,X$205:X$216,$C$205:$C$216))))","v":98.689323768873763},null,null,null,{"$f":"IF(MAX(C205:C216)-MIN(C205:C216)<5,AVERAGEIF(C205:C216,\">0\",AB205:AB216),\nIF(FORECAST($C202,AB$205:AB$216,$C$205:$C$216)<0,0,\nIF(FORECAST($C202,AB$205:AB$216,$C$205:$C$216)>100,100,\nFORECAST($C202,AB$205:AB$216,$C$205:$C$216))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H122\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H122\")))","v":91.091329557352935},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H129\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!H127\"))),\"\",INDIRECT(CONCATENATE($B205,\"!H127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I122\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I122\")))","v":95.665616622149059},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I129\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!I127\"))),\"\",INDIRECT(CONCATENATE($B205,\"!I127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J122\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J122\")))","v":96.960065284540192},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J129\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!J127\"))),\"\",INDIRECT(CONCATENATE($B205,\"!J127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K122\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K122\")))","v":97.448050333876878},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K129\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!K127\"))),\"\",INDIRECT(CONCATENATE($B205,\"!K127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L122\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L122\")))","v":98.689323768873763},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L129\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B205,\"!L2127\"))),\"\",INDIRECT(CONCATENATE($B205,\"!L127\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"Urban sanitation coverage, \",C199,\"–\",C200)","v":"Urban sanitation coverage, 2008–2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RURAL",null,null,"Poorest",null,null,null,null,"Poor",null,null,null,null,"Middle",null,null,null,null,"Rich",null,null,null,null,"Richest"]
[null,null,null,"Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation","Improved","Basic","Limited","Unimproved","Open defecation"]
["Forecast period:",null,{"$f":"MinBase(C305:C316)","v":2008},{"$f":"IF((D301+H301)>100,D301*100/(D301+H301),D301)","v":{"$error":"#DIV/0!"}},{"$f":"D299*AVERAGEIF(E305:E316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D299*(100-AVERAGEIF(E305:E316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E299+F299+H299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D301+H301)>100,H301*100/(D301+H301),H301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I301+M301)>100,I301*100/(I301+M301),I301)","v":{"$error":"#DIV/0!"}},{"$f":"I299*AVERAGEIF(J305:J316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I299*(100-AVERAGEIF(J305:J316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J299+K299+M299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I301+M301)>100,M301*100/(I301+M301),M301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N301+R301)>100,N301*100/(N301+R301),N301)","v":{"$error":"#DIV/0!"}},{"$f":"N299*AVERAGEIF(O305:O316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N299*(100-AVERAGEIF(O305:O316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O299+P299+R299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N301+R301)>100,R301*100/(N301+R301),R301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S301+W301)>100,S301*100/(S301+W301),S301)","v":{"$error":"#DIV/0!"}},{"$f":"S299*AVERAGEIF(T305:T316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S299*(100-AVERAGEIF(T305:T316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T299+U299+W299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S301+W301)>100,W301*100/(S301+W301),W301)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X301+AB301)>100,X301*100/(X301+AB301),X301)","v":{"$error":"#DIV/0!"}},{"$f":"X299*AVERAGEIF(Y305:Y316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X299*(100-AVERAGEIF(Y305:Y316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y299+Z299+AB299)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X301+AB301)>100,AB301*100/(X301+AB301),AB301)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxTarget(C305:C316)","v":2016},{"$f":"IF((D302+H302)>100,D302*100/(D302+H302),D302)","v":{"$error":"#DIV/0!"}},{"$f":"D300*AVERAGEIF(E305:E316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"D300*(100-AVERAGEIF(E305:E316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(E300+F300+H300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((D302+H302)>100,H302*100/(D302+H302),H302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I302+M302)>100,I302*100/(I302+M302),I302)","v":{"$error":"#DIV/0!"}},{"$f":"I300*AVERAGEIF(J305:J316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"I300*(100-AVERAGEIF(J305:J316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(J300+K300+M300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((I302+M302)>100,M302*100/(I302+M302),M302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N302+R302)>100,N302*100/(N302+R302),N302)","v":{"$error":"#DIV/0!"}},{"$f":"N300*AVERAGEIF(O305:O316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"N300*(100-AVERAGEIF(O305:O316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(O300+P300+R300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((N302+R302)>100,R302*100/(N302+R302),R302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S302+W302)>100,S302*100/(S302+W302),S302)","v":{"$error":"#DIV/0!"}},{"$f":"S300*AVERAGEIF(T305:T316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"S300*(100-AVERAGEIF(T305:T316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(T300+U300+W300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((S302+W302)>100,W302*100/(S302+W302),W302)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X302+AB302)>100,X302*100/(X302+AB302),X302)","v":{"$error":"#DIV/0!"}},{"$f":"X300*AVERAGEIF(Y305:Y316,\">0\")/100","v":{"$error":"#DIV/0!"}},{"$f":"X300*(100-AVERAGEIF(Y305:Y316,\">0\"))/100","v":{"$error":"#DIV/0!"}},{"$f":"100-(Y300+Z300+AB300)","v":{"$error":"#DIV/0!"}},{"$f":"IF((X302+AB302)>100,AB302*100/(X302+AB302),AB302)","v":{"$error":"#DIV/0!"}}]
["Regression period:",null,{"$f":"MinRegYear(C299,C305:C316)","v":2010},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",D305:D316),\nIF(FORECAST($C301,D$305:D$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,D$305:D$316,$C$305:$C$316)>100,100,\nFORECAST($C301,D$305:D$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",H305:H316),\nIF(FORECAST($C301,H$305:H$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,H$305:H$316,$C$305:$C$316)>100,100,\nFORECAST($C301,H$305:H$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",I305:I316),\nIF(FORECAST($C301,I$305:I$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,I$305:I$316,$C$305:$C$316)>100,100,\nFORECAST($C301,I$305:I$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",M305:M316),\nIF(FORECAST($C301,M$305:M$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,M$305:M$316,$C$305:$C$316)>100,100,\nFORECAST($C301,M$305:M$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",N305:N316),\nIF(FORECAST($C301,N$305:N$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,N$305:N$316,$C$305:$C$316)>100,100,\nFORECAST($C301,N$305:N$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",R305:R316),\nIF(FORECAST($C301,R$305:R$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,R$305:R$316,$C$305:$C$316)>100,100,\nFORECAST($C301,R$305:R$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",S305:S316),\nIF(FORECAST($C301,S$305:S$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,S$305:S$316,$C$305:$C$316)>100,100,\nFORECAST($C301,S$305:S$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",W305:W316),\nIF(FORECAST($C301,W$305:W$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,W$305:W$316,$C$305:$C$316)>100,100,\nFORECAST($C301,W$305:W$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",X305:X316),\nIF(FORECAST($C301,X$305:X$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,X$305:X$316,$C$305:$C$316)>100,100,\nFORECAST($C301,X$305:X$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",AB305:AB316),\nIF(FORECAST($C301,AB$305:AB$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C301,AB$305:AB$316,$C$305:$C$316)>100,100,\nFORECAST($C301,AB$305:AB$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"MaxRegYear(C300,C305:C316)","v":2014},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",D305:D316),\nIF(FORECAST($C302,D$305:D$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,D$305:D$316,$C$305:$C$316)>100,100,\nFORECAST($C302,D$305:D$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",H305:H316),\nIF(FORECAST($C302,H$305:H$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,H$305:H$316,$C$305:$C$316)>100,100,\nFORECAST($C302,H$305:H$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",I305:I316),\nIF(FORECAST($C302,I$305:I$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,I$305:I$316,$C$305:$C$316)>100,100,\nFORECAST($C302,I$305:I$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",M305:M316),\nIF(FORECAST($C302,M$305:M$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,M$305:M$316,$C$305:$C$316)>100,100,\nFORECAST($C302,M$305:M$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",N305:N316),\nIF(FORECAST($C302,N$305:N$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,N$305:N$316,$C$305:$C$316)>100,100,\nFORECAST($C302,N$305:N$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",R305:R316),\nIF(FORECAST($C302,R$305:R$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,R$305:R$316,$C$305:$C$316)>100,100,\nFORECAST($C302,R$305:R$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",S305:S316),\nIF(FORECAST($C302,S$305:S$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,S$305:S$316,$C$305:$C$316)>100,100,\nFORECAST($C302,S$305:S$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",W305:W316),\nIF(FORECAST($C302,W$305:W$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,W$305:W$316,$C$305:$C$316)>100,100,\nFORECAST($C302,W$305:W$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",X305:X316),\nIF(FORECAST($C302,X$305:X$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,X$305:X$316,$C$305:$C$316)>100,100,\nFORECAST($C302,X$305:X$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(MAX(C305:C316)-MIN(C305:C316)<5,AVERAGEIF(C305:C316,\">0\",AB305:AB316),\nIF(FORECAST($C302,AB$305:AB$316,$C$305:$C$316)<0,0,\nIF(FORECAST($C302,AB$305:AB$316,$C$305:$C$316)>100,100,\nFORECAST($C302,AB$305:AB$316,$C$305:$C$316))))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Survey","Year","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation","Improved","Not shared",null,null,"Open defecation"]
[null,"MICS12",2012,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M122\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M129\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!M127\"))),\"\",INDIRECT(CONCATENATE($B305,\"!M127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N122\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N129\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!N127\"))),\"\",INDIRECT(CONCATENATE($B305,\"!N127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O122\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O129\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!O127\"))),\"\",INDIRECT(CONCATENATE($B305,\"!O127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P122\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P129\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!P127\"))),\"\",INDIRECT(CONCATENATE($B305,\"!P127\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q122\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q122\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q129\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q129\")))","v":"N/A"},null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($B305,\"!Q2127\"))),\"\",INDIRECT(CONCATENATE($B305,\"!Q127\")))","v":"N/A"}]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[null,null,null,"","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,"","","",null,null,""]
[]
[null,{"$f":"CONCATENATE(\"Rural sanitation coverage, \",C299,\"–\",C300)","v":"Rural sanitation coverage, 2008–2016"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data points used for regression"]

{"sheet":"Hygiene","index":3,"n_rows":88,"n_cols":25,"rows_kept":88,"cut":false,"hidden":false,"merged":[[3,1,3,24],[4,1,4,24],[33,1,34,3],[31,6,32,9],[31,10,31,12],[31,13,31,15],[6,2,6,6],[6,10,6,15],[6,18,6,23],[33,19,34,19],[31,16,31,18],[31,19,31,21],[31,22,31,24],[33,6,34,7],[33,8,34,8],[33,9,34,9],[33,15,34,15],[33,16,34,16],[33,17,34,17],[33,18,34,18],[36,6,37,7],[36,8,37,8],[36,9,37,9],[36,10,37,10],[36,11,37,11],[33,10,34,10],[33,11,34,11],[33,12,34,12],[33,13,34,13],[33,14,34,14],[33,20,34,20],[33,21,34,21],[33,22,34,22],[33,23,34,23],[33,24,34,24],[36,19,37,19],[36,20,37,20],[36,21,37,21],[36,22,37,22],[36,23,37,23],[39,12,40,12],[39,13,40,13],[39,14,40,14],[39,15,40,15],[36,18,37,18],[36,12,37,12],[36,13,37,13],[36,14,37,14],[36,15,37,15],[36,16,37,16],[36,17,37,17],[39,22,40,22],[39,23,40,23],[39,24,40,24],[31,4,32,5],[39,16,40,16],[39,17,40,17],[39,18,40,18],[39,19,40,19],[39,20,40,20],[39,21,40,21],[36,24,37,24],[39,6,40,7],[39,8,40,8],[39,9,40,9],[39,10,40,10],[39,11,40,11]]}
[]
[]
[]
[null,"Hygiene coverage by wealth quintile (%)"]
[null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!A2\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!A2\")))","v":"Argentina"}]
[]
[null,null,{"$f":"CONCATENATE(\"National hygiene coverage,  \",IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!A2\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!A210\"))))","v":"National hygiene coverage,  2012"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Urban hygiene coverage,  \",IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!A2\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!A210\"))))","v":"Urban hygiene coverage,  2012"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Rural hygiene coverage,  \",IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!A2\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!A210\"))))","v":"Rural hygiene coverage,  2012"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"INDEX(B88:B100,A88)","v":"MICS12"},null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!A2\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!A2\")))","v":"Argentina"},null,null,null,"Poorest",null,null,"Poor",null,null,"Middle",null,null,"Rich",null,null,"Richest"]
[null,null,null,null,null,null,null,null,null,null,"Basic","Limited","No facility","Basic","Limited","No facility","Basic","Limited","No facility","Basic","Limited","No facility","Basic","Limited","No facility"]
[null,">>>  Select Survey :   ",null,null,null,null,"NATIONAL",null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE(#REF!,\"!A2\"))),\"\",INDIRECT(CONCATENATE(#REF!,\"!A210\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!C222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!C222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!C223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!C223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!C224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!C224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!D222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!D222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!D223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!D223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!D224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!D224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!E222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!E222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!E223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!E223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!E224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!E224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!F222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!F222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!F223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!F223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!F224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!F224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!G222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!G222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!G223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!G223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!G224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!G224\")))","v":"N/A"}]
[]
[]
[null,null,null,null,null,null,"URBAN",null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE(#REF!,\"!A2\"))),\"\",INDIRECT(CONCATENATE(#REF!,\"!A210\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!H222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!H222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!H223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!H223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!H224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!H224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!I222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!I222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!I223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!I223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!I224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!I224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!J222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!J222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!J223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!J223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!J224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!J224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!K222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!K222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!K223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!K223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!K224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!K224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!L222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!L222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!L223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!L223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!L224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!L224\")))","v":"N/A"}]
[]
[]
[null,null,null,null,null,null,"RURAL",null,null,{"$f":"IF(ISERROR(INDIRECT(CONCATENATE(#REF!,\"!A2\"))),\"\",INDIRECT(CONCATENATE(#REF!,\"!A210\")))","v":""},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!M222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!M222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!M223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!M223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!M224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!M224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!N222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!N222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!N223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!N223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!N224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!N224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!O222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!O222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!O223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!O223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!O224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!O224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!P222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!P222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!P223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!P223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!P224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!P224\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!Q222\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!Q222\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!Q223\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!Q223\")))","v":"N/A"},{"$f":"IF(ISERROR(INDIRECT(CONCATENATE($E$32,\"!Q224\"))),\"\",INDIRECT(CONCATENATE($E$32,\"!Q224\")))","v":"N/A"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"MICS12"]

{"sheet":"MICS12","index":4,"n_rows":498,"n_cols":17,"rows_kept":498,"cut":false,"hidden":false,"merged":[[539,2,539,3],[539,7,539,8],[539,12,539,13],[540,2,540,3],[540,7,540,8],[540,12,540,13],[537,2,537,3],[537,7,537,8],[537,12,537,13],[538,2,538,3],[538,7,538,8],[538,12,538,13],[535,2,535,3],[535,7,535,8],[535,12,535,13],[536,2,536,3],[536,7,536,8],[536,12,536,13],[533,2,533,3],[533,7,533,8],[533,12,533,13],[534,2,534,3],[534,7,534,8],[534,12,534,13],[531,2,531,3],[531,7,531,8],[531,12,531,13],[532,2,532,3],[532,7,532,8],[532,12,532,13],[529,2,529,3],[529,7,529,8],[529,12,529,13],[530,2,530,3],[530,7,530,8],[530,12,530,13],[527,2,527,3],[527,7,527,8],[527,12,527,13],[528,2,528,3],[528,7,528,8],[528,12,528,13],[525,2,525,3],[525,7,525,8],[525,12,525,13],[526,2,526,3],[526,7,526,8],[526,12,526,13],[523,2,523,3],[523,7,523,8],[523,12,523,13],[524,2,524,3],[524,7,524,8],[524,12,524,13],[521,2,521,3],[521,7,521,8],[521,12,521,13],[522,2,522,3],[522,7,522,8],[522,12,522,13],[519,2,519,3],[519,7,519,8],[519,12,519,13],[520,2,520,3],[520,7,520,8],[520,12,520,13],[517,2,517,3],[517,7,517,8],[517,12,517,13],[518,2,518,3],[518,7,518,8],[518,12,518,13],[515,2,515,3],[515,7,515,8],[515,12,515,13],[516,2,516,3],[516,7,516,8],[516,12,516,13],[513,2,513,3],[513,7,513,8],[513,12,513,13],[514,2,514,3],[514,7,514,8],[514,12,514,13],[511,2,511,3],[511,7,511,8],[511,12,511,13],[512,2,512,3],[512,7,512,8],[512,12,512,13],[509,2,509,3],[509,7,509,8],[509,12,509,13],[510,2,510,3],[510,7,510,8],[510,12,510,13],[507,2,507,3],[507,7,507,8],[507,12,507,13],[508,2,508,3],[508,7,508,8],[508,12,508,13],[505,2,505,3],[505,7,505,8],[505,12,505,13],[506,2,506,3],[506,7,506,8],[506,12,506,13],[503,2,503,3],[503,7,503,8],[503,12,503,13],[504,2,504,3],[504,7,504,8],[504,12,504,13],[501,2,501,3],[501,7,501,8],[501,12,501,13],[502,2,502,3],[502,7,502,8],[502,12,502,13],[499,2,499,3],[499,7,499,8],[499,12,499,13],[500,2,500,3],[500,7,500,8],[500,12,500,13],[497,2,497,3],[497,7,497,8],[497,12,497,13],[498,2,498,3],[498,7,498,8],[498,12,498,13],[495,2,495,3],[495,7,495,9],[495,12,495,13],[496,2,496,3],[496,7,496,8],[496,12,496,13],[493,2,493,3],[493,7,493,8],[493,12,493,13],[494,2,494,3],[494,7,494,8],[494,12,494,13],[491,2,491,3],[491,7,491,8],[491,12,491,13],[492,2,492,3],[492,7,492,8],[492,12,492,13],[489,2,489,3],[489,7,489,8],[489,12,489,13],[490,2,490,3],[490,7,490,8],[490,12,490,13],[487,2,487,3],[487,7,487,8],[487,12,487,13],[488,2,488,3],[488,7,488,8],[488,12,488,13],[485,2,485,3],[485,7,485,8],[485,12,485,13],[486,2,486,3],[486,7,486,8],[486,12,486,13],[483,2,483,3],[483,7,483,8],[483,12,483,13],[484,2,484,3],[484,7,484,8],[484,12,484,13],[481,2,481,3],[481,7,481,8],[481,12,481,13],[482,2,482,3],[482,7,482,8],[482,12,482,13],[479,2,479,3],[479,7,479,8],[479,12,479,13],[480,2,480,3],[480,7,480,8],[480,12,480,13],[477,2,477,3],[477,7,477,8],[477,12,477,13],[478,2,478,3],[478,7,478,8],[478,12,478,13],[475,2,475,3],[475,7,475,8],[475,12,475,13],[476,2,476,3],[476,7,476,8],[476,12,476,13],[473,2,473,3],[473,7,473,8],[473,12,473,13],[474,2,474,3],[474,7,474,8],[474,12,474,13],[471,2,471,3],[471,7,471,8],[471,12,471,13],[472,2,472,3],[472,7,472,8],[472,12,472,13],[469,2,469,3],[469,7,469,8],[469,12,469,13],[470,2,470,3],[470,7,470,8],[470,12,470,13],[466,2,466,3],[466,7,467,8],[466,12,466,13],[467,2,467,3],[467,12,467,13],[468,2,468,3],[468,7,468,8],[468,12,468,13],[464,2,464,3],[464,7,464,8],[464,12,464,13],[465,2,465,3],[465,7,465,9],[465,12,465,13],[462,2,462,3],[462,7,462,8],[462,12,462,13],[463,2,463,3],[463,7,463,8],[463,12,463,13],[459,2,459,3],[459,7,459,11],[459,12,459,13],[460,2,460,3],[460,7,461,8],[460,9,460,11],[460,12,460,13],[461,2,461,3],[461,12,461,13],[457,2,457,3],[457,7,457,8],[457,12,457,13],[458,2,458,3],[458,7,458,8],[458,12,458,13],[455,2,455,3],[455,7,455,8],[455,12,455,13],[456,2,456,3],[456,7,456,8],[456,12,456,13],[453,2,453,3],[453,7,453,8],[453,12,453,13],[454,2,454,3],[454,7,454,8],[454,12,454,13],[451,2,451,3],[451,7,451,8],[451,12,451,13],[452,2,452,3],[452,7,452,8],[452,12,452,13],[449,2,449,3],[449,7,449,8],[449,12,449,13],[450,2,450,3],[450,7,450,8],[450,12,450,13],[447,2,447,3],[447,7,447,8],[447,12,447,13],[448,2,448,3],[448,7,448,8],[448,12,448,13],[445,2,445,3],[445,7,445,8],[445,12,445,13],[446,2,446,3],[446,7,446,8],[446,12,446,13],[443,2,443,3],[443,7,443,8],[443,12,443,13],[444,2,444,3],[444,7,444,8],[444,12,444,13],[441,2,441,3],[441,7,441,8],[441,12,441,13],[442,2,442,3],[442,7,442,8],[442,12,442,13],[439,2,439,3],[439,7,439,8],[439,12,439,13],[440,2,440,3],[440,7,440,8],[440,12,440,13],[437,2,437,3],[437,7,437,8],[437,12,437,13],[438,2,438,3],[438,7,438,8],[438,12,438,13],[435,2,435,3],[435,7,435,8],[435,12,435,13],[436,2,436,3],[436,7,436,8],[436,12,436,13],[433,2,433,3],[433,7,433,8],[433,12,433,13],[434,2,434,3],[434,7,434,8],[434,12,434,13],[431,2,431,3],[431,7,431,8],[431,12,431,13],[432,2,432,3],[432,7,432,8],[432,12,432,13],[429,2,429,3],[429,7,429,8],[429,12,429,13],[430,2,430,3],[430,7,430,9],[430,12,430,13],[427,2,427,3],[427,7,427,8],[427,12,427,13],[428,2,428,3],[428,7,428,8],[428,12,428,13],[425,2,425,3],[425,7,425,8],[425,12,425,13],[426,2,426,3],[426,7,426,8],[426,12,426,13],[423,2,423,3],[423,7,423,8],[423,12,423,13],[424,2,424,3],[424,7,424,8],[424,12,424,13],[421,2,421,3],[421,7,421,8],[421,12,421,13],[422,2,422,3],[422,7,422,8],[422,12,422,13],[419,2,419,3],[419,7,419,8],[419,12,419,13],[420,2,420,3],[420,7,420,8],[420,12,420,13],[417,2,417,3],[417,7,417,8],[417,12,417,13],[418,2,418,3],[418,7,418,8],[418,12,418,13],[415,2,415,3],[415,7,415,8],[415,12,415,13],[416,2,416,3],[416,7,416,8],[416,12,416,13],[414,2,414,3],[414,7,414,8],[414,12,414,13],[411,2,411,3],[411,7,411,8],[411,12,411,13],[412,2,412,3],[412,7,412,8],[412,12,412,13],[407,2,407,3],[407,7,407,8],[407,12,407,13],[408,2,408,3],[408,7,408,8],[408,12,408,13],[413,2,413,3],[413,7,413,8],[413,12,413,13],[404,7,404,8],[404,12,404,13],[405,2,405,3],[405,7,405,8],[405,12,405,13],[406,2,406,3],[406,7,406,8],[406,12,406,13],[401,1,444,1],[401,2,401,3],[401,12,401,13],[402,2,402,3],[402,7,402,8],[402,12,402,13],[403,2,403,3],[403,7,403,8],[403,12,403,13],[404,2,404,3],[409,2,409,3],[409,7,409,8],[409,12,409,13],[410,2,410,3],[410,7,410,8],[410,12,410,13],[398,7,398,10],[398,12,398,15],[399,2,399,3],[399,7,399,9],[399,12,399,13],[400,2,400,3],[400,7,401,8],[400,12,400,13],[227,0,229,0],[279,0,279,2],[280,0,280,1],[285,0,287,0],[288,0,288,2],[398,2,398,5],[219,2,219,6],[219,7,219,11],[219,12,219,16],[221,0,223,0],[225,0,226,1],[225,2,225,6],[225,7,225,11],[225,12,225,16],[149,0,150,0],[151,0,156,0],[207,0,207,1],[212,0,212,1],[213,0,213,1],[219,0,220,1],[132,7,132,11],[132,12,132,16],[134,0,138,0],[139,0,143,0],[147,0,148,1],[147,2,147,6],[147,7,147,11],[147,12,147,16],[121,0,122,0],[123,0,126,0],[127,0,128,0],[129,0,131,0],[132,0,133,1],[132,2,132,6],[46,12,46,16],[48,0,55,0],[107,0,107,1],[112,0,112,1],[113,0,113,1],[119,0,120,1],[119,2,119,6],[119,7,119,11],[119,12,119,16],[46,0,47,1],[46,2,46,6],[46,7,46,11],[28,0,29,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[36,0,37,0],[38,0,39,0],[21,0,22,0],[23,0,25,0],[26,0,27,1],[26,2,26,6],[26,7,26,11],[26,12,26,16],[40,0,41,0],[42,0,43,0],[44,0,45,0],[1,0,1,1],[6,0,6,1],[7,0,7,1],[13,0,14,1],[13,2,13,6],[13,7,13,11],[13,12,13,16],[15,0,16,0],[17,0,20,0]]}
["ARG"]
[{"$f":"A281","v":"Argentina"}]
["Drinking water coverage by wealth quintile"]
[{"$f":"A289","v":"2012"}]
[]
["Notes"]
["WHO/UNICEF JMP customised wealth index excludes water,"]
[" sanitation and hygiene assets."]
["Survey used for analyse :",{"$f":"A280","v":"MICS12"}]
[{"$f":"B283","v":""}]
[{"$f":"B282","v":"Time to improved source based on:"}]
[]
[]
["Argentina\nMICS12\nWeighted percentage used in graphs",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["Water","Improved","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Not Improved","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Water ladder","Basic","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Limited","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Other unimproved","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Surface water","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Improved water point at more than 30 minutes","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Manually calculated ratios","Improved wells"]
[null,"Improved sources"]
[null,"Other"]
["Argentina\nMICS12\nPercentage based on weighted population",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["Household connection","Yes",80.018941533935546,83.892173833058521,86.276860269600164,88.153318637250962,90.611798786639881,80.018941533935546,83.892173833058521,86.276860269600164,88.153318637250962,90.611798786639881,80.018941533935546,83.892173833058521,86.276860269600164,88.153318637250962,90.611798786639881]
[null,"No",19.981058466064454,16.107826166941475,13.723139730399842,11.846681362749029,9.3882012133601211,19.981058466064454,16.107826166941475,13.723139730399842,11.846681362749029,9.3882012133601211,19.981058466064454,16.107826166941475,13.723139730399842,11.846681362749029,9.3882012133601211]
["Piped water","Yes",81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511,81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511,81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511]
[null,"No",18.070346638288605,15.994517721862398,13.579137774932754,11.779206890385858,9.2762856309384905,18.070346638288605,15.994517721862398,13.579137774932754,11.779206890385858,9.2762856309384905,18.070346638288605,15.994517721862398,13.579137774932754,11.779206890385858,9.2762856309384905]
["Water source on premises","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Improved Water source on premises","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Water point at more than 30 minutes","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Water source available when needed","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Improved water source available when needed","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Water source free from contamination","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Improved water source free from contamination","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Argentina\nMICS12\nPercentage based on weighted population",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["AS1. Fuente principal de agua","Agua de red pública",81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511,81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511,81.929653361711402,84.005482278137606,86.420862225067253,88.220793109614135,90.723714369061511]
[null,"Perforación con bomba a motor",13.171378424593042,13.056587699340325,12.22501244089206,9.9492559680774058,8.5194160649581949,13.171378424593042,13.056587699340325,12.22501244089206,9.9492559680774058,8.5194160649581949,13.171378424593042,13.056587699340325,12.22501244089206,9.9492559680774058,8.5194160649581949]
[null,"Perforación con bomba manual",0.80437832940601239,0.31467115775826127,0.20831643491166421,0.39368317451796175,6.6513278528877617E-2,0.80437832940601239,0.31467115775826127,0.20831643491166421,0.39368317451796175,6.6513278528877617E-2,0.80437832940601239,0.31467115775826127,0.20831643491166421,0.39368317451796175,6.6513278528877617E-2]
[null,"Pozo",1.4684687831057406,1.0375292134028642,0.39434065464302864,0.72208082954747099,0.40315107342451817,1.4684687831057406,1.0375292134028642,0.39434065464302864,0.72208082954747099,0.40315107342451817,1.4684687831057406,1.0375292134028642,0.39434065464302864,0.72208082954747099,0.40315107342451817]
[null,"Transporte por cisterna",0.54442871689939554,0.50776637818958892,6.37801239485528E-2,5.9430070548583055E-2,6.7952663163158775E-2,0.54442871689939554,0.50776637818958892,6.37801239485528E-2,5.9430070548583055E-2,6.7952663163158775E-2,0.54442871689939554,0.50776637818958892,6.37801239485528E-2,5.9430070548583055E-2,6.7952663163158775E-2]
[null,"Agua de lluvia, río, canal, arroyo o acequia",0.38895200450871509,0.16576048198932289,0.16699294321911096,0.12572798074159261,6.744545143488827E-3,0.38895200450871509,0.16576048198932289,0.16699294321911096,0.12572798074159261,6.744545143488827E-3,0.38895200450871509,0.16576048198932289,0.16699294321911096,0.12572798074159261,6.744545143488827E-3]
[null,"Otras",1.5088582144693872,0.77659675525567495,0.30196566094568317,0.40583186297264456,6.0618655740869089E-2,1.5088582144693872,0.77659675525567495,0.30196566094568317,0.40583186297264456,6.0618655740869089E-2,1.5088582144693872,0.77659675525567495,0.30196566094568317,0.40583186297264456,6.0618655740869089E-2]
[null,"Missing",0.1838821653063139,0.13560603592636017,0.21872951637265237,0.12319700398020036,0.15188934997938253,0.1838821653063139,0.13560603592636017,0.21872951637265237,0.12319700398020036,0.15188934997938253,0.1838821653063139,0.13560603592636017,0.21872951637265237,0.12319700398020036,0.15188934997938253]
["Water point at more than 30 minutes","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Water source on premises","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Improved Water source on premises","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Water source available when needed","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Improved water source available when needed","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Water source free from contamination","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
["Improved water source free from contamination","missing",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A281","v":"Argentina"}]
["Sanitation coverage by wealth quintile"]
[{"$f":"A289","v":"2012"}]
[]
["Notes"]
["WHO/UNICEF JMP customised wealth index excludes water,"]
[" sanitation and hygiene assets."]
["Survey used for analyse :",{"$f":"A280","v":"MICS12"}]
[{"$f":"B285","v":""}]
[{"$f":"B284","v":"Ratio of Shared improved based on:"}]
[]
[]
["Argentina\nMICS12\nWeighted percentage used in graphs",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["Sanitation","Improved","N/A","N/A","N/A","N/A","N/A",91.091329557352935,95.665616622149059,96.960065284540192,97.448050333876878,98.689323768873763,"N/A","N/A","N/A","N/A","N/A"]
[null,"Not Improved","N/A","N/A","N/A","N/A","N/A",8.9086704426470771,4.3343833778509504,3.0399347154598089,2.551949666123122,1.3106762311262403,"N/A","N/A","N/A","N/A","N/A"]
["Sanitation ladder","Basic","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Limited","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Other unimproved","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Open defecation","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Shared among Improved Sanitation","Yes","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Manually calculated ratios","Improved latrines"]
[null,"Other"]
[null,"Other"]
["Argentina\nMICS12\nPercentage based on weighted population",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["Sanitation type","Sewer connection","N/A","N/A","N/A","N/A","N/A",32.13626399814283,50.19223288266376,60.203449689470943,68.927649771917956,78.753572415578034,"N/A","N/A","N/A","N/A","N/A"]
[null,"Septic tank connection","N/A","N/A","N/A","N/A","N/A",25.414142327206442,25.225597141528244,23.66707076730161,18.255812251322983,15.687798295329925,"N/A","N/A","N/A","N/A","N/A"]
[null,"Improved latrines","N/A","N/A","N/A","N/A","N/A",33.540923232003664,20.247786597957056,13.089544827767632,10.264588310635943,4.2479530579658009,"N/A","N/A","N/A","N/A","N/A"]
[null,"Unimproved facilities","N/A","N/A","N/A","N/A","N/A",8.9086704426470771,4.3343833778509504,3.0399347154598089,2.551949666123122,1.3106762311262403,"N/A","N/A","N/A","N/A","N/A"]
[null,"Open defecation","N/A","N/A","N/A","N/A","N/A",0,0,0,0,0,"N/A","N/A","N/A","N/A","N/A"]
["AS6. El desagüe del inodoro es","A red pública (cloaca)","N/A","N/A","N/A","N/A","N/A",33.782134500983275,51.858885869169377,61.593113277093423,70.527997684072091,79.674304803949354,"N/A","N/A","N/A","N/A","N/A"]
[null,"A cámara séptica y pozo ciego","N/A","N/A","N/A","N/A","N/A",26.715736912493494,26.063223092750615,24.213372792196296,18.679671923279852,15.871209200381001,"N/A","N/A","N/A","N/A","N/A"]
[null,"Sólo a pozo ciego","N/A","N/A","N/A","N/A","N/A",35.258733870750618,20.920122377130358,13.391688042475844,10.502909398420091,4.297617191855637,"N/A","N/A","N/A","N/A","N/A"]
[null,"A hoyo, excavación en la tierra, etc","N/A","N/A","N/A","N/A","N/A",3.8545923953692718,0.87790444508776722,0.27771847516128406,0.17188877330713917,9.5818810498712714E-2,"N/A","N/A","N/A","N/A","N/A"]
[null,"Missing","N/A","N/A","N/A","N/A","N/A",0.38880232040334661,0.27986421586187615,0.52410741307315001,0.11753222092081932,6.1049993315289236E-2,"N/A","N/A","N/A","N/A","N/A"]
["Shared among Improved Sanitation","missing","N/A","N/A","N/A","N/A","N/A",100,100,100,100,100,"N/A","N/A","N/A","N/A","N/A"]
["Shared among Sanitation","missing","N/A","N/A","N/A","N/A","N/A",100,100,100,100,100,"N/A","N/A","N/A","N/A","N/A"]
[]
["Argentina\nMICS12\nWeighted population",null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles",null,null,null,null,"Wealth index quintiles"]
[null,null,"Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest","Poorest","Second","Middle","Fourth","Richest"]
["Sanitation","Improved","N/A","N/A","N/A","N/A","N/A",6650956,6989064,7076642,7122898,7199173,"N/A","N/A","N/A","N/A","N/A"]
[null,"Not Improved","N/A","N/A","N/A","N/A","N/A",650459,316658,221870,186533,95611,"N/A","N/A","N/A","N/A","N/A"]
["AS6. El desagüe del inodoro es","A red pública (cloaca)","N/A","N/A","N/A","N/A","N/A",2346402,3666905,4393956,5038219,5744903,"N/A","N/A","N/A","N/A","N/A"]
[null,"A cámara séptica y pozo ciego","N/A","N/A","N/A","N/A","N/A",1855592,1842912,1727344,1334396,1144391,"N/A","N/A","N/A","N/A","N/A"]
[null,"Sólo a pozo ciego","N/A","N/A","N/A","N/A","N/A",2448962,1479247,955342,750283,309879,"N/A","N/A","N/A","N/A","N/A"]
[null,"A hoyo, excavación en la tierra, etc","N/A","N/A","N/A","N/A","N/A",267728,62076,19812,12279,6909,"N/A","N/A","N/A","N/A","N/A"]
[null,"Missing","N/A","N/A","N/A","N/A","N/A",27005,19789,37389,8396,4402,"N/A","N/A","N/A","N/A","N/A"]
[null,"Total","N/A","N/A","N/A","N/A","N/A",6945689,7070929,7133843,7143573,7210484,"N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A281","v":"Argentina"}]
["Hygiene coverage by wealth quintile"]
[{"$f":"A289","v":"2012"}]
[]
["Notes"]
["WHO/UNICEF JMP customised wealth index excludes water,"]
[" sanitation and hygiene assets."]
["Survey used for analyse :",{"$f":"A280","v":"MICS12"}]
[]
[]
[]
[]
["Azerbaijan\nMICS12\nWeighted percentage used in graphs",null,"COMPOSITE wealth index quintile",null,null,null,null,"URBAN wealth index quintile",null,null,null,null,"RURAL wealth index quintile"]
[null,null,"Poorest","Poor","Middle","Rich","Richest","Poorest","Poor","Middle","Rich","Richest","Poorest","Poor","Middle","Rich","Richest"]
["Hygiene ladder","Basic","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Limited","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No facility","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
["Azerbaijan\nMICS12\nWeighted population",null,"COMPOSITE wealth index quintile",null,null,null,null,"URBAN wealth index quintile",null,null,null,null,"RURAL wealth index quintile"]
[null,null,"Poorest","Poor","Middle","Rich","Richest","Poorest","Poor","Middle","Rich","Richest","Poorest","Poor","Middle","Rich","Richest"]
["Hygiene ladder","Basic","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Limited","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"No facility","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MICS12"]
["Argentina",null,"Count"]
["W_text_t","Time to improved source based on:",23791]
["W_text_i","",23791]
["S_text_s","Ratio of Shared improved based on:",23791]
["S_text_i","",23791]
["Urban/Rural","Urban",23791]
[null,"Rural",0]
[null,"Missing",0]
["2012"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"INITIAL (National) Wealth Index Quintile",null,null,null,null,"URBAN Wealth Index Quintile",null,null,null,null,"RURAL Wealth Index Quintile"]
[null,null,null,null,null,null,null,"Component Matrix"]
[null,null,null,null,null,null,null,null,null,"Component"]
[null,"Note:\n\nThe INITIAL (national) Wealth Index Quintile is based on the first Principal Component Analysys (PCA) which has been runned at national level.\n\nThe final national-level (COMPOSITE) Wealth Index is based on the urban and rural specific wealth indexes . Regression procedures are used to establish the relationships between the two sets of scores (urban and rural) and the initial (national) wealth factors.\nThis allows best use of the available information for each area and a better precision of the final national (COMPOSITE) Wealth Index.\n\nFor dependancy reasons, all WASH variables (contained in the generic MICS and DHS scripts) have been excluded from from the sets of asset variables used in the PCAs.\n\nSee the methodology paper, the syntax files and the output files for more information on the used procedure.",null,null,null,null,null,null,null,"1"]
[null,null,null,null,null,null,null,"Household has: Internet",null,0.68919936373761759]
[null,null,null,null,null,null,null,"Household has: Washing machine",null,0.64032030805592999]
[null,null,null,null,null,null,null,"Household has: microwave",null,0.63154329404811271]
[null,null,null,null,null,null,null,"Has ceramic tile, mosaic, marble, wood, carpeting",null,0.61434314035084481]
[null,null,null,null,null,null,null,"Household has: Camera Camcorder / Digital Camera",null,0.59910276213284774]
[null,null,null,null,null,null,null,"Household has: Auto 2000 or more",null,0.59466116873872188]
[null,null,null,null,null,null,null,"Household member owns: credit card",null,0.59021138010215757]
[null,null,null,null,null,null,null,"Household has: Telephone / line",null,0.5606052131700836]
[null,null,null,null,null,null,null,"Has cement or brick fixed",null,-0.55177351926269169]
[null,null,null,null,null,null,null,"Household has: DVD / Video Recorder",null,0.53208443965931573]
[null,null,null,null,null,null,null,"Household has: Refrigerator with freezer",null,0.52903138739032318]
[null,null,null,null,null,null,null,"Household has: TV cable/satelital",null,0.47788173673589796]
[null,null,null,null,null,null,null,"Household has: Air Conditioning / Split",null,0.47131073726145156]
[null,null,null,null,null,null,null,"Household has: CD player",null,0.46908848445912049]
[null,null,null,null,null,null,null,"Persons per sleeping rooms",null,-0.36544514047432758]
[null,null,null,null,null,null,null,"Household member owns: mobile phone",null,0.36370717202392999]
[null,null,null,null,null,null,null,"Household has: Refrigerator without freezer",null,-0.32144203356455242]
[null,null,null,null,null,null,null,"Household has: TV color con control remoto/Plasma/LCD",null,0.31491263280288656]
[null,null,null,null,null,null,null,"Household has: Computadora",null,0.26939634017444547]
[null,null,null,null,null,null,null,"Household has: independent freezer",null,0.26939634017444447]
[null,null,null,null,null,null,null,"Has earth or loose brick",null,-0.23312899293087483]
[null,null,null,null,null,null,null,"Household has tenant loan, transfer, license free",null,-0.21798818582702917]
[null,null,null,null,null,null,null,"Household owns land and housing",null,0.21585966015073163]
[null,null,null,null,null,null,null,"Household owns housing only",null,-0.13427546901109771]
[null,null,null,null,null,null,null,"Household rents dwelling",null,1.574041464205474E-2]
[]
[]
[]
[null,null,null,null,null,null,null,"Communalities"]
[null,null,null,null,null,null,null,null,null,"Extraction"]
[null,null,null,null,null,null,null,"Persons per sleeping rooms",null,0.13355015069630102]
[null,null,null,null,null,null,null,"Has ceramic tile, mosaic, marble, wood, carpeting",null,0.37741749409613778]
[null,null,null,null,null,null,null,"Has cement or brick fixed",null,0.30445401655953602]
[null,null,null,null,null,null,null,"Has earth or loose brick",null,5.4349127344963888E-2]
[null,null,null,null,null,null,null,"Household has: Air Conditioning / Split",null,0.22213381105793303]
[null,null,null,null,null,null,null,"Household has: Internet",null,0.47499576297633689]
[null,null,null,null,null,null,null,"Household has: Auto 2000 or more",null,0.35362190560570267]
[null,null,null,null,null,null,null,"Household has: Telephone / line",null,0.31427820503347487]
[null,null,null,null,null,null,null,"Household has: CD player",null,0.22004400625215453]
[null,null,null,null,null,null,null,"Household has: Camera Camcorder / Digital Camera",null,0.35892411959520754]
[null,null,null,null,null,null,null,"Household has: DVD / Video Recorder",null,0.28311385092756802]
[null,null,null,null,null,null,null,"Household has: microwave",null,0.39884693225714096]
[null,null,null,null,null,null,null,"Household has: Washing machine",null,0.4100100969088411]
[null,null,null,null,null,null,null,"Household has: Computadora",null,7.2574388099385545E-2]
[null,null,null,null,null,null,null,"Household has: independent freezer",null,7.2574388099385004E-2]
[null,null,null,null,null,null,null,"Household has: Refrigerator without freezer",null,0.10332498094211484]
[null,null,null,null,null,null,null,"Household has: Refrigerator with freezer",null,0.27987420884413022]
[null,null,null,null,null,null,null,"Household has: TV cable/satelital",null,0.22837095430571808]
[null,null,null,null,null,null,null,"Household has: TV color con control remoto/Plasma/LCD",null,9.9169966298845669E-2]
[null,null,null,null,null,null,null,"Household member owns: mobile phone",null,0.1322829069816446]
[null,null,null,null,null,null,null,"Household member owns: credit card",null,0.34834947320209353]
[null,null,null,null,null,null,null,"Household owns land and housing",null,4.6595392880389358E-2]
[null,null,null,null,null,null,null,"Household owns housing only",null,1.8029901578150261E-2]
[null,null,null,null,null,null,null,"Household rents dwelling",null,2.4776065310381124E-4]
[null,null,null,null,null,null,null,"Household has tenant loan, transfer, license free",null,4.7518849160159402E-2]
[]
[]
[null,null,null,null,null,null,null,"Total Variance Explained"]
[null,null,null,null,null,null,null,"Component",null,"Extraction Sums of Squared Loadings"]
[null,null,null,null,null,null,null,null,null,"Total","% of Variance","Cumulative %"]
[null,null,null,null,null,null,null,"1",null,5.3546526503564182,21.418610601425673,21.418610601425673]
[]
[]
[null,null,null,null,null,null,null,"Component Score Coefficient Matrix"]
[null,null,null,null,null,null,null,null,null,"Component"]
[null,null,null,null,null,null,null,null,null,"1"]
[null,null,null,null,null,null,null,"Persons per sleeping rooms",null,-6.824815059665966E-2]
[null,null,null,null,null,null,null,"Has ceramic tile, mosaic, marble, wood, carpeting",null,0.11473071746492328]
[null,null,null,null,null,null,null,"Has cement or brick fixed",null,-0.10304562317893101]
[null,null,null,null,null,null,null,"Has earth or loose brick",null,-4.3537649994039716E-2]
[null,null,null,null,null,null,null,"Household has: Air Conditioning / Split",null,8.8018918879841826E-2]
[null,null,null,null,null,null,null,"Household has: Internet",null,0.12871037744936506]
[null,null,null,null,null,null,null,"Household has: Auto 2000 or more",null,0.11105504083428079]
[null,null,null,null,null,null,null,"Household has: Telephone / line",null,0.10469497272297736]
[null,null,null,null,null,null,null,"Household has: CD player",null,8.7603905442474761E-2]
[null,null,null,null,null,null,null,"Household has: Camera Camcorder / Digital Camera",null,0.11188452384357184]
[null,null,null,null,null,null,null,"Household has: DVD / Video Recorder",null,9.9368619106208311E-2]
[null,null,null,null,null,null,null,"Household has: microwave",null,0.11794290597095514]
[null,null,null,null,null,null,null,"Household has: Washing machine",null,0.11958204385363985]
[null,null,null,null,null,null,null,"Household has: Computadora",null,5.0310703189405545E-2]
[null,null,null,null,null,null,null,"Household has: independent freezer",null,5.0310703189405358E-2]
[null,null,null,null,null,null,null,"Household has: Refrigerator without freezer",null,-6.0030417387233609E-2]
[null,null,null,null,null,null,null,"Household has: Refrigerator with freezer",null,9.8798450979842675E-2]
[null,null,null,null,null,null,null,"Household has: TV cable/satelital",null,8.9246075878346487E-2]
[null,null,null,null,null,null,null,"Household has: TV color con control remoto/Plasma/LCD",null,5.881102909297492E-2]
[null,null,null,null,null,null,null,"Household member owns: mobile phone",null,6.7923578945820295E-2]
[null,null,null,null,null,null,null,"Household member owns: credit card",null,0.11022402733497041]
[null,null,null,null,null,null,null,"Household owns land and housing",null,4.0312542053752731E-2]
[null,null,null,null,null,null,null,"Household owns housing only",null,-2.5076410699050672E-2]
[null,null,null,null,null,null,null,"Household rents dwelling",null,2.9395771621165798E-3]
[null,null,null,null,null,null,null,"Household has tenant loan, transfer, license free",null,-4.0710051624453993E-2]
[]
[]
[null,null,null,null,null,null,null,"Component Score Covariance Matrix"]
[null,null,null,null,null,null,null,"Component",null,"1"]
[null,null,null,null,null,null,null,"1",null,1]