{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["template","template legend","checks","variable checks","readme","validation","validation detail","lookups"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":54,"comments":1,"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":"template","index":0,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["setting","date","source","indicator_abbr","indicator_name","dimension","subgroup","estimate","se","ci_lb","ci_ub","population","note","setting_average","iso3","favourable_indicator","indicator_scale","ordered_dimension","subgroup_order","reference_subgroup"]

{"sheet":"template legend","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"COLOUR LEGEND"]
[null,"Mandatory variable"]
[null,"Recommended variable"]
[null,"Optional variable"]
[]
[null,"VARIABLE","TYPE","DEFINITION","NOTE"]
[null,"setting","Mandatory","Setting name (e.g. a country like \"Indonesia\", or a province like \"Bali\")","If this variable is missing, data cannot be uploaded. "]
[null,"date","Mandatory","Date of the data (e.g. years, months, weeks, days, or another date format). Note that dates should be sortable numerically / alphabetically in chronological order to ensure correct display in HEAT Plus visuals. For example, monthly data is best entered with the year and month number (e.g. \"2022-12\" and \"2023-04\") instead of text (e.g. December 2022 and \"April 2023\")","If this variable is missing, data cannot be uploaded. "]
[null,"source","Mandatory","Data source (e.g. \"DHS\")","If this variable is missing, data cannot be uploaded. "]
[null,"indicator_abbr","Mandatory","Indicator abbreviation (e.g. \"anc\")","If this variable is missing, data cannot be uploaded. "]
[null,"indicator_name","Mandatory","Indicator name (e.g. \"Antenatal care coverage\")","If this variable is missing, data cannot be uploaded. "]
[null,"dimension","Mandatory","Dimension of inequality (e.g. \"Education\")","If this variable is missing, data cannot be uploaded. "]
[null,"subgroup","Mandatory","Population subgroup (e.g. \"Primary school\")","If this variable is missing, data cannot be uploaded. Subgroup name must be unique within a given combination of setting, year and dimension. "]
[null,"estimate","Mandatory","Subgroup estimate","If this variable is missing for one subgroup (or more), complex summary measures cannot be calculated. Simple measures may be calculated depending on which  estimates are missing. Proportions/percentages must be already multiplied by 100 (not left as decimals)."]
[null,"se","Recommended","Standard error of subgroup estimate","If this variable is missing for one subgroup (or more), 95% confidence intervals for some (or all) summary measures cannot be calculated."]
[null,"ci_lb","Optional","95% confidence interval lower bound of subgroup estimate"]
[null,"ci_ub","Optional","95% confidence interval upper bound of subgroup estimate"]
[null,"population","Recommended","The number of people affected or at risk within that subgroup (e.g. weighted sample size by subgroup in household surveys). ","If this variable is missing for one subgroup (or more), complex summary measures cannot be calculated. "]
[null,"note","Optional","Notes or observations relevant to the analysis. For example if a subgroup estimate is based on a very small number of cases, this could be indicated in the note."]
[null,"setting_average","Recommended","Setting average","If this variable is missing, benchmark data cannot be displayed in a scatterplot. \nProportions/percentages must be already multiplied by 100 (not left as decimals)."]
[null,"iso3","Recommended","ISO3 country code for country-level data (e.g. \"IDN\" for Indonesia). Please refer to  supplementary table 1 in the user manual for a list of WHO member states and corresponding ISO3 country codes (as well as corresponding WHO regions and country income groups).  ","Must be a three-character string. If this variable is missing, benchmark data cannot be filtered by country income group or WHO region. If setting is not a country then iso3 should be blank."]
[null,"favourable_indicator","Mandatory","This dummy variable indicates the indicator type. It must be 1 for favourable indicators and 0 for non-favourable (adverse) indicators. \n\nFavourable indicators measure desirable events that are promoted through public action. They include health intervention indicators, such as antenatal care coverage, and desirable health outcome indicators, such as life expectancy. For these indicators, the ultimate goal is to achieve a maximum level, either in health intervention coverage or health outcome (e.g. complete coverage of antenatal care or the highest possible life expectancy). \n\nAdverse indicators measure undesirable events that are to be reduced or eliminated through public action. They include undesirable health outcome indicators, such as stunting prevalence in children aged less than five years or under-five mortality rate. Here, the ultimate goal is to achieve a minimum level (e.g. theoretically 0 deaths per 1000 live births).","Must be zero or one. If this variable is missing, data cannot be uploaded. "]
[null,"indicator_scale","Mandatory","This variable indicates the scale of the indicator, such as \"100\" for indicators reported as percentages or \"1000\" for indicators reported as rates per 1000 population. ","Must be greater than zero. If this variable is missing, data cannot be uploaded. "]
[null,"ordered_dimension","Mandatory","This dummy variable indicates the dimension type. It must be 0 for dimensions with two subgroups (binary dimensions). For dimensions with more than two subgroups, it must be 1 for ordered dimensions and 0 for non-ordered dimensions. \n\nBinary dimensions compare the situation in two population subgroups (e.g. males and females). \n\nOrdered dimensions have ordered subgroups that have an inherent positioning and can be ranked. For example, education has an inherent ordering in the sense that those with less education unequivocally have less of something compared to those with more education. \n\nNon-ordered dimensions have non-ordered subgroups that are not based on criteria that can be logically ranked. Subnational regions are an example of non-ordered groupings. ","Must be zero or one. If this variable is missing, data cannot be uploaded. "]
[null,"subgroup_order","Mandatory","This variable indicates the order of subgroups for ordered dimensions. \n\nFor ordered dimensions (i.e. if ordered_dimension=1), this variable must be an increasing sequence of integers starting with the value 1 for the most-disadvantaged subgroup. For example, for eduction with three subgroups, the most-disadvantaged subgroup \"No education\" will be assigned the value 1, \"Primary school\" will be assigned the value 2 and the most-advantaged subgroup \"Secondary school +\" will be assigned the value 3. \n\nFor non-ordered dimensions and binary dimensions (i.e. if ordered_dimension=0), this variable must be 0. ","Must be zero or an increasing sequence of integers starting with 1. If this variable is missing, data cannot be uploaded. "]
[null,"reference_subgroup","Mandatory","This variable indicates the reference subgroup for non-ordered dimensions and binary dimensions . \n\nFor ordered dimensions (i.e. if ordered_dimension=1), this variable must be 0. \n\nFor non-ordered dimensions and binary dimensions (i.e. if ordered_dimension=0), you have the option to choose a reference subgroup. A reference subgroup can be chosen by assigning the value 1 to that subgroup and 0 to all other subgroups. For example, for subnational regions (with more than two subgroups), the capital city can be chosen as the reference subgroup. For place of residence (urban vs. rural), urban can be chosen as the reference subgroup.","Must be zero or one. The selection of a reference subgroup impacts on the calculation of the following summary measures: D, MDBU, MDBW, PAF, PAR and R. If this variable is missing, data cannot be uploaded. "]

{"sheet":"checks","index":2,"n_rows":37,"n_cols":114,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"COUNTIF(AN3:AN1048576,\">\"&0)","v":34},{"$f":"COUNTIF(AO3:AO1048576,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"COUNTIF(BJ3:BJ1048576,1)","v":0},{"$f":"COUNTIF(BK3:BK1048576,1)","v":0},{"$f":"COUNTIF(BL3:BL1048576,1)","v":0},null,null,null,{"$f":"COUNTIF(BP3:BP1048576,1)","v":0},{"$f":"COUNTIF(BQ3:BQ1048576,1)","v":0},null,null,null,{"$f":"COUNTIF(BU3:BU1048576,1)","v":0},null,null,null,{"$f":"COUNTIF(BY3:BY1048576,1)","v":0},null,null,null,{"$f":"COUNTIF(CC3:CC1048576,1)","v":0},null,null,null,null,{"$f":"COUNTIF(CH3:CH1048576,1)","v":0},null,null,null,{"$f":"COUNTIF(CL3:CL1048576,1)","v":0},null,null,null,null,null,null,null,null,{"$f":"COUNTIF(CU3:CU1048576,1)","v":0},null,null,null,null,null,null,null,{"$f":"COUNTIF(DC3:DC1048576,1)","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(DJ3:DJ1048576,1)","v":0}]
["setting","year","source","indicator_abbr","indicator_name","dimension","subgroup","estimate","se","ci_lb","ci_ub","population","flag","setting_average","iso3","favourable_indicator","indicator_scale","ordered_dimension","subgroup_order","reference_subgroup","record","row number","setting","year","source","indicator_abbr","indicator_name","dimension","subgroup","estimate","se","population","setting_average","iso3","favourable_indicator","indicator_scale","ordered_dimension","subgroup_order","reference_subgroup","missing data","setting","year","source","indicator_abbr","indicator_name","dimension","subgroup","estimate","se","ci_lb","ci_ub","population","flag","setting_average","iso3","favourable_indicator","indicator_scale","ordered_dimension","subgroup_order","reference_subgroup",null,"iso3 check","subgroup_order_check","reference_subgroup_check",null,"indicator_abbr","indicator_name",{"$f":"IF(COUNTIF(BN:BN,BN2)>1,1,0)","v":0},{"$f":"IF(COUNTIF(BO:BO,BO2)>1,1,0)","v":0},null,"setting","iso3",{"$f":"IF(BS2=\"\",0,IF(COUNTIF(BS:BS,BS2)>1,1,0))","v":0},null,"dimension","ordered_dimension",{"$f":"IF(BW2=\"\",0,IF(COUNTIF(BW:BW,BW2)>1,1,0))","v":0},null,"indicator_abbr","favourable_indicator",{"$f":"IF(CA2=\"\",0,IF(COUNTIF(CA:CA,CA2)>1,1,0))","v":0},null,null,"indicator_abbr","indicator_scale",{"$f":"IF(CF2=\"\",0,IF(COUNTIF(CF:CF,CF2)>1,1,0))","v":0},null,"subgroup","subgroup_order",{"$f":"IF(CJ2=\"\",0,IF(COUNTIF(CJ:CJ,CJ2)>1,1,0))","v":0},null,"setting","year","source","indicator_abbr","indicator_name","setting_average",{"$f":"_xlfn.CONCAT(CN2,CO2,CP2,CQ2,CR2)","v":"settingyearsourceindicator_abbrindicator_name"},{"$f":"IF(CN2=\"\",0,IF(COUNTIF(CT:CT,CT2)>1,1,0))","v":0},null,"setting","date","source","indicator_abbr","dimension","subgroup_order",{"$f":"IF(CW2=\"\",0,IFERROR(IF(DB2=1,0,IF(AND(CW2=CW1,DB2-DB1=1),0,1)),0))","v":0},null,"setting","date","source","indicator_abbr","dimension",{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE2,template!B:B,checks!DF2,template!D:D,checks!DH2,template!F:F,checks!DI2)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","yogyakarta",97.662567138671903,null,90.657257080078097,99.447235107421903,126.87433624267599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,{"$f":"IF(A3<>\"\",1,0)","v":1},{"$f":"ROW()","v":3},{"$f":"IF(AND(E3<>\"\",A3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,B3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,C3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,D3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,E3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,F3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,G3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,H3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,I3=\"\"),1,0)","v":1},{"$f":"IF(AND($U3=1,L3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,N3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,O3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,P3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,Q3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,R3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,S3=\"\"),1,0)","v":0},{"$f":"IF(AND($U3=1,T3=\"\"),1,0)","v":1},{"$f":"IF(SUM(W3:AD3,AI3:AM3)>0,1,0)","v":1},{"$f":"IF(AND($U3=1,W3=0),IF(ISTEXT(A3)=FALSE,1,0),0)","v":0},{"$f":"IF(AND($U3=1,X3=0),IF(AND(LEN(B3)=4,ISNUMBER(B3)=TRUE),0,1),0)","v":0},{"$f":"IF(AND($U3=1,Y3=0),IF(ISTEXT(C3)=FALSE,1,0),0)","v":0},{"$f":"IF(AND($U3=1,Z3=0),IF(ISTEXT(D3)=FALSE,1,0),0)","v":0},{"$f":"IF(AND($U3=1,AA3=0),IF(ISTEXT(E3)=FALSE,1,0),0)","v":0},{"$f":"IF(AND($U3=1,AB3=0),IF(ISTEXT(F3)=FALSE,1,0),0)","v":0},{"$f":"IF(AND($U3=1,AC3=0),IF(ISTEXT(G3)=FALSE,1,0),0)","v":0},{"$f":"IF(H3=\"\",\"\",IF(AND($U3=1,AD3=0),IF(AND(ISNUMBER(H3),H3>=0),0,1),0))","v":0},{"$f":"IF(I3=\"\",\"\",IF(AND($U3=1,AE3=0),IF(AND(ISNUMBER(I3),I3>=0),0,1),0))","v":""},{"$f":"IF(J3=\"\",\"\",IF($U3=1,IF(AND(ISNUMBER(J3),J3>=0),0,1),0))","v":0},{"$f":"IF(K3=\"\",\"\",IF($U3=1,IF(AND(ISNUMBER(K3),K3>=0),0,1),0))","v":0},{"$f":"IF(L3=\"\",\"\",IF($U3=1,IF(AND(ISNUMBER(L3),L3>=0),0,1),0))","v":0},null,{"$f":"IF(N3=\"\",\"\",IF($U3=1,IF(AND(ISNUMBER(N3),N3>=0),0,1),0))","v":0},{"$f":"IF(AH3=1,\"\",IF($U3=1,IF(AND(LEN(O3)=3,ISTEXT(O3)=TRUE),0,1),0))","v":0},{"$f":"IF(AND($U3=1,AI3=0),IF(OR(P3=1,P3=0),0,1),0)","v":0},{"$f":"IF(AND($U3=1,AJ3=0),IF(Q3>=0,0,1),0)","v":0},{"$f":"IF(AND($U3=1,AK3=0),IF(OR(R3=1,R3=0),0,1),0)","v":0},{"$f":"IF(AND($U3=1,AL3=0),IF(S3>=0,0,1),0)","v":0},{"$f":"IF(AND($U3=1,AM3=0),IF(OR(T3=1,T3=0),0,1),0)","v":0},null,{"$f":"IF(U3=0,0,IF(AH3=0,IF(IFERROR(VLOOKUP(O3,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},{"$f":"IF(AND(R3=0,S3<>0),1,IF(AND(R3=1,S3<1),1,0))","v":0},{"$f":"IF(AND(R3=1,T3<>0),1,0)","v":0},null,"anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)",0,0,null,"Indonesia","IDN",0,null,"Subnational region",0,0,null,"anc1",1,0,null,null,"anc1",100,0,null,"yogyakarta",0,0,null,"Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)",97.388114929199205,"Indonesia2017ICEH - DHSanc1Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)",0,null,null,null,null,null,null,null,0,null,"Indonesia",2017,"ICEH - DHS","anc1","Subnational region",{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE3,template!B:B,checks!DF3,template!D:D,checks!DH3,template!F:F,checks!DI3)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west sumatera",99.258529663085895,null,94.928398132324205,99.895660400390597,185.02243041992199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":4},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U4=0,0,IF(AH4=0,IF(IFERROR(VLOOKUP(O4,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west sumatera",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE4,template!B:B,checks!DF4,template!D:D,checks!DH4,template!F:F,checks!DI4)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west sulawesi",98.006393432617202,null,95.336624145507798,99.161178588867202,51.516090393066399,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":5},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U5=0,0,IF(AH5=0,IF(IFERROR(VLOOKUP(O5,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west sulawesi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE5,template!B:B,checks!DF5,template!D:D,checks!DH5,template!F:F,checks!DI5)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west papua",88.298477172851605,null,81.985031127929702,92.599067687988295,35.989551544189503,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":6},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U6=0,0,IF(AH6=0,IF(IFERROR(VLOOKUP(O6,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west papua",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE6,template!B:B,checks!DF6,template!D:D,checks!DH6,template!F:F,checks!DI6)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west nusa tenggara",99.8095703125,null,98.662361145019503,99.973159790039105,214.22901916503901,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":7},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U7=0,0,IF(AH7=0,IF(IFERROR(VLOOKUP(O7,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west nusa tenggara",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE7,template!B:B,checks!DF7,template!D:D,checks!DH7,template!F:F,checks!DI7)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west kalimantan",96.143493652343807,null,90.658920288085895,98.462432861328097,204.98158264160199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":8},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U8=0,0,IF(AH8=0,IF(IFERROR(VLOOKUP(O8,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west kalimantan",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE8,template!B:B,checks!DF8,template!D:D,checks!DH8,template!F:F,checks!DI8)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west java",98.154464721679702,null,96.696601867675795,98.975753784179702,1926.65344238281,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":9},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U9=0,0,IF(AH9=0,IF(IFERROR(VLOOKUP(O9,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"west java",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE9,template!B:B,checks!DF9,template!D:D,checks!DH9,template!F:F,checks!DI9)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","southeast sulawesi",94.4969482421875,null,90.613906860351605,96.829772949218807,109.491943359375,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":10},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U10=0,0,IF(AH10=0,IF(IFERROR(VLOOKUP(O10,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"southeast sulawesi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE10,template!B:B,checks!DF10,template!D:D,checks!DH10,template!F:F,checks!DI10)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south sumatera",96.442367553710895,null,92.045845031738295,98.449714660644503,337.02023315429699,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":11},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U11=0,0,IF(AH11=0,IF(IFERROR(VLOOKUP(O11,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"south sumatera",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE11,template!B:B,checks!DF11,template!D:D,checks!DH11,template!F:F,checks!DI11)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south sulawesi",98.213317871093807,null,96.006759643554702,99.210617065429702,293.52389526367199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":12},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U12=0,0,IF(AH12=0,IF(IFERROR(VLOOKUP(O12,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"south sulawesi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE12,template!B:B,checks!DF12,template!D:D,checks!DH12,template!F:F,checks!DI12)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south kalimantan",100,null,100,100,159.836349487305,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":13},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U13=0,0,IF(AH13=0,IF(IFERROR(VLOOKUP(O13,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"south kalimantan",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE13,template!B:B,checks!DF13,template!D:D,checks!DH13,template!F:F,checks!DI13)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","riau islands",94.993255615234403,null,90.446891784667997,97.437294006347699,73.863098144531193,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":14},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U14=0,0,IF(AH14=0,IF(IFERROR(VLOOKUP(O14,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"riau islands",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE14,template!B:B,checks!DF14,template!D:D,checks!DH14,template!F:F,checks!DI14)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","riau",94.659507751464801,null,91.760078430175795,96.576759338378906,283.91836547851602,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":15},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U15=0,0,IF(AH15=0,IF(IFERROR(VLOOKUP(O15,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"riau",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE15,template!B:B,checks!DF15,template!D:D,checks!DH15,template!F:F,checks!DI15)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","papua",79.292152404785199,null,62.874557495117202,89.645240783691406,154.53305053710901,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":16},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U16=0,0,IF(AH16=0,IF(IFERROR(VLOOKUP(O16,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"papua",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE16,template!B:B,checks!DF16,template!D:D,checks!DH16,template!F:F,checks!DI16)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north sumatera",92.491981506347699,null,86.802879333496094,95.845954895019503,563.90716552734398,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":17},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U17=0,0,IF(AH17=0,IF(IFERROR(VLOOKUP(O17,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"north sumatera",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE17,template!B:B,checks!DF17,template!D:D,checks!DH17,template!F:F,checks!DI17)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north sulawesi",98.228904724121094,null,93.481491088867202,99.535957336425795,71.259841918945298,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":18},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U18=0,0,IF(AH18=0,IF(IFERROR(VLOOKUP(O18,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"north sulawesi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE18,template!B:B,checks!DF18,template!D:D,checks!DH18,template!F:F,checks!DI18)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north maluku",94.940773010253906,null,89.381393432617202,97.665557861328097,48.540809631347699,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":19},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U19=0,0,IF(AH19=0,IF(IFERROR(VLOOKUP(O19,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"north maluku",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE19,template!B:B,checks!DF19,template!D:D,checks!DH19,template!F:F,checks!DI19)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north kalimantan",95.220741271972699,null,86.695755004882798,98.384925842285199,24.163373947143601,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":20},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U20=0,0,IF(AH20=0,IF(IFERROR(VLOOKUP(O20,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"north kalimantan",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE20,template!B:B,checks!DF20,template!D:D,checks!DH20,template!F:F,checks!DI20)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","maluku",89.824577331542997,null,84.684616088867202,93.374481201171903,76.427116394042997,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":21},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U21=0,0,IF(AH21=0,IF(IFERROR(VLOOKUP(O21,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"maluku",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE21,template!B:B,checks!DF21,template!D:D,checks!DH21,template!F:F,checks!DI21)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","lampung",99.170135498046903,null,96.675750732421903,99.796768188476605,298.42028808593801,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":22},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U22=0,0,IF(AH22=0,IF(IFERROR(VLOOKUP(O22,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"lampung",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE22,template!B:B,checks!DF22,template!D:D,checks!DH22,template!F:F,checks!DI22)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","jambi",97.585113525390597,null,90.935798645019503,99.389381408691406,131.56976318359401,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":23},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U23=0,0,IF(AH23=0,IF(IFERROR(VLOOKUP(O23,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"jambi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE23,template!B:B,checks!DF23,template!D:D,checks!DH23,template!F:F,checks!DI23)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","jakarta",99.040390014648395,null,97.005149841308594,99.696846008300795,350.39935302734398,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":24},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U24=0,0,IF(AH24=0,IF(IFERROR(VLOOKUP(O24,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"jakarta",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE24,template!B:B,checks!DF24,template!D:D,checks!DH24,template!F:F,checks!DI24)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","gorontalo",95.993476867675795,null,89.104164123535199,98.595420837402301,45.070793151855497,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":25},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U25=0,0,IF(AH25=0,IF(IFERROR(VLOOKUP(O25,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"gorontalo",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE25,template!B:B,checks!DF25,template!D:D,checks!DH25,template!F:F,checks!DI25)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east nusa tenggara",95.393737792968807,null,92.373550415039105,97.253440856933594,232.64097595214801,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":26},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U26=0,0,IF(AH26=0,IF(IFERROR(VLOOKUP(O26,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"east nusa tenggara",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE26,template!B:B,checks!DF26,template!D:D,checks!DH26,template!F:F,checks!DI26)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east kalimantan",98.473724365234403,null,95.877395629882798,99.444412231445298,126.57651519775401,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":27},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U27=0,0,IF(AH27=0,IF(IFERROR(VLOOKUP(O27,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"east kalimantan",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE27,template!B:B,checks!DF27,template!D:D,checks!DH27,template!F:F,checks!DI27)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east java",98.647064208984403,null,97.175064086914105,99.357116699218807,1205.65454101562,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":28},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U28=0,0,IF(AH28=0,IF(IFERROR(VLOOKUP(O28,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"east java",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE28,template!B:B,checks!DF28,template!D:D,checks!DH28,template!F:F,checks!DI28)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central sulawesi",97.929748535156193,null,95.123817443847699,99.135711669921903,115.071723937988,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":29},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U29=0,0,IF(AH29=0,IF(IFERROR(VLOOKUP(O29,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"central sulawesi",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE29,template!B:B,checks!DF29,template!D:D,checks!DH29,template!F:F,checks!DI29)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central kalimantan",93.069602966308594,null,84.552261352539105,97.054382324218807,87.597328186035199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":30},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U30=0,0,IF(AH30=0,IF(IFERROR(VLOOKUP(O30,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"central kalimantan",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE30,template!B:B,checks!DF30,template!D:D,checks!DH30,template!F:F,checks!DI30)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central java",99.702278137207003,null,98.834823608398395,99.924423217773395,1185.21398925781,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":31},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U31=0,0,IF(AH31=0,IF(IFERROR(VLOOKUP(O31,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"central java",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE31,template!B:B,checks!DF31,template!D:D,checks!DH31,template!F:F,checks!DI31)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bengkulu",99.412498474121094,null,95.854110717773395,99.919319152832003,68.273536682128906,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":32},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U32=0,0,IF(AH32=0,IF(IFERROR(VLOOKUP(O32,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"bengkulu",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE32,template!B:B,checks!DF32,template!D:D,checks!DH32,template!F:F,checks!DI32)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","banten",97.577659606933594,null,95.472297668457003,98.717193603515597,432.06967163085898,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":33},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U33=0,0,IF(AH33=0,IF(IFERROR(VLOOKUP(O33,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"banten",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE33,template!B:B,checks!DF33,template!D:D,checks!DH33,template!F:F,checks!DI33)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bangka balitung",98.355575561523395,null,94.624748229980497,99.510330200195298,52.913898468017599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":34},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U34=0,0,IF(AH34=0,IF(IFERROR(VLOOKUP(O34,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"bangka balitung",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE34,template!B:B,checks!DF34,template!D:D,checks!DH34,template!F:F,checks!DI34)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bali",100,null,100,100,141.88702392578099,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":35},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U35=0,0,IF(AH35=0,IF(IFERROR(VLOOKUP(O35,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"bali",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE35,template!B:B,checks!DF35,template!D:D,checks!DH35,template!F:F,checks!DI35)>1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","aceh",97.454490661621094,null,94.954963684082003,98.732177734375,216.18203735351599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,1,{"$f":"ROW()","v":36},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,"",0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"IF(U36=0,0,IF(AH36=0,IF(IFERROR(VLOOKUP(O36,lookups!$A:$A,1,FALSE),1)=1,1,0),0))","v":0},0,0,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,"aceh",0,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE36,template!B:B,checks!DF36,template!D:D,checks!DH36,template!F:F,checks!DI36)>1,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,"",0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(SUMIFS(template!$T:$T,template!A:A,checks!DE37,template!B:B,checks!DF37,template!D:D,checks!DH37,template!F:F,checks!DI37)>1,1,0)","v":0}]

{"sheet":"variable checks","index":3,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["setting","date","source","indicator_abbr","indicator_name","dimension","subgroup","estimate","se","ci_lb","ci_ub","population","note","setting_average","iso3","favourable_indicator","indicator_scale","ordered_dimension","subgroup_order","reference_subgroup",null,null,"Variable","Variable",{"$f":"COUNTIF(E2:E21,1)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","yogyakarta",97.662567138671903,null,90.657257080078097,99.447235107421903,126.87433624267599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"setting",{"$f":"INDEX(template!$1:$1,,MATCH(W2,template!$1:$1,0))","v":"setting"},{"$f":"IF(IFERROR(X2,1)=1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west sumatera",99.258529663085895,null,94.928398132324205,99.895660400390597,185.02243041992199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"date",{"$f":"INDEX(template!$1:$1,,MATCH(W3,template!$1:$1,0))","v":"date"},{"$f":"IF(IFERROR(X3,1)=1,1,0)","v":0}]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west sulawesi",98.006393432617202,null,95.336624145507798,99.161178588867202,51.516090393066399,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"source",{"$f":"INDEX(template!$1:$1,,MATCH(W4,template!$1:$1,0))","v":"source"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west papua",88.298477172851605,null,81.985031127929702,92.599067687988295,35.989551544189503,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"indicator_abbr",{"$f":"INDEX(template!$1:$1,,MATCH(W5,template!$1:$1,0))","v":"indicator_abbr"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west nusa tenggara",99.8095703125,null,98.662361145019503,99.973159790039105,214.22901916503901,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"indicator_name",{"$f":"INDEX(template!$1:$1,,MATCH(W6,template!$1:$1,0))","v":"indicator_name"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west kalimantan",96.143493652343807,null,90.658920288085895,98.462432861328097,204.98158264160199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"dimension",{"$f":"INDEX(template!$1:$1,,MATCH(W7,template!$1:$1,0))","v":"dimension"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","west java",98.154464721679702,null,96.696601867675795,98.975753784179702,1926.65344238281,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"subgroup",{"$f":"INDEX(template!$1:$1,,MATCH(W8,template!$1:$1,0))","v":"subgroup"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","southeast sulawesi",94.4969482421875,null,90.613906860351605,96.829772949218807,109.491943359375,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"estimate",{"$f":"INDEX(template!$1:$1,,MATCH(W9,template!$1:$1,0))","v":"estimate"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south sumatera",96.442367553710895,null,92.045845031738295,98.449714660644503,337.02023315429699,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"se",{"$f":"INDEX(template!$1:$1,,MATCH(W10,template!$1:$1,0))","v":"se"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south sulawesi",98.213317871093807,null,96.006759643554702,99.210617065429702,293.52389526367199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"ci_lb",{"$f":"INDEX(template!$1:$1,,MATCH(W11,template!$1:$1,0))","v":"ci_lb"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","south kalimantan",100,null,100,100,159.836349487305,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"ci_ub",{"$f":"INDEX(template!$1:$1,,MATCH(W12,template!$1:$1,0))","v":"ci_ub"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","riau islands",94.993255615234403,null,90.446891784667997,97.437294006347699,73.863098144531193,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"population",{"$f":"INDEX(template!$1:$1,,MATCH(W13,template!$1:$1,0))","v":"population"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","riau",94.659507751464801,null,91.760078430175795,96.576759338378906,283.91836547851602,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"note",{"$f":"INDEX(template!$1:$1,,MATCH(W14,template!$1:$1,0))","v":"note"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","papua",79.292152404785199,null,62.874557495117202,89.645240783691406,154.53305053710901,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"setting_average",{"$f":"INDEX(template!$1:$1,,MATCH(W15,template!$1:$1,0))","v":"setting_average"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north sumatera",92.491981506347699,null,86.802879333496094,95.845954895019503,563.90716552734398,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"iso3",{"$f":"INDEX(template!$1:$1,,MATCH(W16,template!$1:$1,0))","v":"iso3"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north sulawesi",98.228904724121094,null,93.481491088867202,99.535957336425795,71.259841918945298,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"favourable_indicator",{"$f":"INDEX(template!$1:$1,,MATCH(W17,template!$1:$1,0))","v":"favourable_indicator"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north maluku",94.940773010253906,null,89.381393432617202,97.665557861328097,48.540809631347699,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"indicator_scale",{"$f":"INDEX(template!$1:$1,,MATCH(W18,template!$1:$1,0))","v":"indicator_scale"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","north kalimantan",95.220741271972699,null,86.695755004882798,98.384925842285199,24.163373947143601,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"ordered_dimension",{"$f":"INDEX(template!$1:$1,,MATCH(W19,template!$1:$1,0))","v":"ordered_dimension"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","maluku",89.824577331542997,null,84.684616088867202,93.374481201171903,76.427116394042997,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"subgroup_order",{"$f":"INDEX(template!$1:$1,,MATCH(W20,template!$1:$1,0))","v":"subgroup_order"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","lampung",99.170135498046903,null,96.675750732421903,99.796768188476605,298.42028808593801,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0,null,null,null,"reference_subgroup",{"$f":"INDEX(template!$1:$1,,MATCH(W21,template!$1:$1,0))","v":"reference_subgroup"},0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","jambi",97.585113525390597,null,90.935798645019503,99.389381408691406,131.56976318359401,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","jakarta",99.040390014648395,null,97.005149841308594,99.696846008300795,350.39935302734398,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","gorontalo",95.993476867675795,null,89.104164123535199,98.595420837402301,45.070793151855497,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east nusa tenggara",95.393737792968807,null,92.373550415039105,97.253440856933594,232.64097595214801,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east kalimantan",98.473724365234403,null,95.877395629882798,99.444412231445298,126.57651519775401,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","east java",98.647064208984403,null,97.175064086914105,99.357116699218807,1205.65454101562,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central sulawesi",97.929748535156193,null,95.123817443847699,99.135711669921903,115.071723937988,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central kalimantan",93.069602966308594,null,84.552261352539105,97.054382324218807,87.597328186035199,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","central java",99.702278137207003,null,98.834823608398395,99.924423217773395,1185.21398925781,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bengkulu",99.412498474121094,null,95.854110717773395,99.919319152832003,68.273536682128906,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","banten",97.577659606933594,null,95.472297668457003,98.717193603515597,432.06967163085898,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bangka balitung",98.355575561523395,null,94.624748229980497,99.510330200195298,52.913898468017599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","bali",100,null,100,100,141.88702392578099,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]
["Indonesia",2017,"ICEH - DHS","anc1","Antenatal care coverage - at least one visit (%) (in the two or three years preceding the survey)","Subnational region","aceh",97.454490661621094,null,94.954963684082003,98.732177734375,216.18203735351599,"Re-analysis of DHS/MICS/RHS data by ICEH (WHO Collaborating Center for Health Inequality Monitoring).",97.388114929199205,"IDN",1,100,0,0]

{"sheet":"readme","index":4,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,10],[17,1,17,10],[37,1,37,10],[32,1,32,10],[38,1,38,10],[39,1,39,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Template and Validation Tool"]
[null,null,null,null,null,null,null,null,null,null,null,"Health Equity Assessment Toolkit Plus (HEAT Plus)"]
[null,null,null,null,null,null,null,null,null,null,null,"UPLOAD DATABASE EDITION, VERSION 6.0"]
[]
[]
[]
[]
[]
[null,"Description"]
[]
[null,"This template and validation tool allows you to prepare your dataset and check that it has been formatted correctly in order to be successfully uploaded to the Health Equity Assessment Toolkit Plus (HEAT Plus)."]
[]
[]
[]
[null,"Intructions"]
[]
[null,"1. Prepare your disaggregated data"]
[null,"2. Prepare your database for upload by following the HEAT Plus template tabs:"]
[null,"l enter your data in the template"]
[null,"l the template legend has information about each of the variables needed for upload to HEAT Plus"]
[null,"3. Validate your database by using the validation tabs:"]
[null,"l check whether your data can be successfully downloaded using validation"]
[null,"l any issues with the dataset will be shown in validation detail"]
[null,"4. Upload your database to HEAT Plus."]
[]
[null,"For further information, please refer to the HEAT Plus user manual and technical notes."]
[]
[]
[null,"About "]
[]
[null,"HEAT Plus was developed to facilitate the assessment of within-country health inequalities, i.e. differences that exist between population subgroups within a country. Users can upload their own data and undertake equity assessments for any indicator and inequality dimension, in any setting of interest (at global, regional, national and subnational levels). Databases have to be in a specified format in order to be uploaded to HEAT Plus. The HEAT Plus Template and Validation Tool helps users prepare their data according to the template and validate that datasets have been formatted correctly in order to be successfully uploaded to HEAT Plus. Once data have been uploaded, they can be used to explore inequalities in a setting of interest and compare inequalities between different settings. Disaggregated data and summary measures are visualized in a variety of interactive graphs and tables that can be customized according to users' needs. Results can be exported to communicate findings to different audiences and inform evidence-based decision making."]
[null,"Further information about the Health Equity Assessment Toolkit are available at"]
[null,"https://www.who.int/data/inequality-monitor/assessment_toolkit/"]
[]
[]
[null,"Disclaimer"]
[null,"© Copyright World Health Organization, 2016-2024. "]
[]
[null,"Your use of the materials in this package is subject to the Terms of Use and Software Licence agreement – see the Readme file, pop-up window or License tab under About in HEAT Plus – and by using these materials you affirm that you have read, and will comply with, the terms of those documents."]

{"sheet":"validation","index":5,"n_rows":83,"n_cols":16,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,4,0,17],[2,4,2,18],[8,8,13,9],[9,10,13,14],[8,10,8,14]]}
[null,null,null,null,"VALIDATION CHECKS"]
[]
[null,null,null,null,"To help ensure that the data entered into this template can be successfully uploaded into HEAT Plus, validation checks have been built into this tool. \nOnce you have entered your disaggregated data into the 'template' tab, click on the button below to start the validation checks. Please wait while the checks run. \nEnsure you have macros enabled first, by clicking 'Enable Content' in the yellow warning ribbon at the top of this page.\nOnce any data is changed in the template, the validation checks can be re-run if needed by clicking the button again. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF($B$15=0,\"✓\",IF($B$15=2,\"✓\",\"⚠️\"))","v":"⚠️"},null,"VALIDATION CHECK RESULTS"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=2,\"Template can be uploaded to HEAT Plus, but some calculations will not function in Heat Plus because some data is missing (see below). After checking these, click the 'Export' button to export the data, then save it and upload to HEAT Plus.\", IF(B15=0,\"Template can be uploaded to HEAT Plus. Click the 'Export' button to export the data, then save it and upload to HEAT Plus.\",\"Template not ready to upload to HEAT Plus, please check and correct errors below. Further detail on errors is in the 'validation detail' tab.\"))","v":"Template not ready to upload to HEAT Plus, please check and correct errors below. Further detail on errors is in the 'validation detail' tab."}]
[]
[]
[]
[]
[null,{"$f":"IF(AND(D15=0,C15>0),2, IF(AND(D15=0,C15=0),0,1))","v":1},{"$f":"SUM(C17:C83)","v":2},{"$f":"SUM(D17:D83)","v":1}]
["Responses","RAG colour","warning","checks"]
[{"$f":"IF(AND(A18=\"Yes\",A19=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A17=\"Yes\",0,1)","v":0},null,{"$f":"IF(F17=\"\",B17-C17,0)","v":0},null,"Setting recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A17=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(setting)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A18=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(setting_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A19=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(A21=\"Yes\",\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Year recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A20=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(year)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A21=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(AND(A23=\"Yes\",A24=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Source recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A22=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(source)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A23=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(source_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A24=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(AND(A26=\"Yes\",A27=\"Yes\",A28=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Indicator_abbr recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A25=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(indicator_abbr)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A26=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(indicator_abbr_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A27=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(SUM(checks!$BP:$BQ)<>0,\"No\",\"Yes\")","v":"Yes"},0,null,0,null,null,"Unique indicator abbreviation with indicator name",null,null,null,null,null,null,null,null,{"$f":"IF(A28=\"Yes\",\"\",\"* Check that each indicator abbreviation and indicator name are uniquely matched\")","v":""}]
[{"$f":"IF(AND(A30=\"Yes\",A31=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Indicator name recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A29=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(indicator_name)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(indicator_name_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A31=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(AND(A33=\"Yes\",A34=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Dimension recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A32=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(dimension)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A33=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(dimension_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A34=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(AND(A36=\"Yes\",A37=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Subgroup recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A35=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(subgroup)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A36=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(subgroup_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must contain characters",null,null,null,null,null,null,null,null,{"$f":"IF(A37=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain characters (text/string)\")","v":""}]
[{"$f":"IF(AND(A39=\"Yes\",A40=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(B40=1,1,IF(AND(B40=0,B39=2),2,0))","v":0},null,0,null,"Estimate recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A38=\"Yes\",\"✓\",IF(A40=\"No\",\"✗\",\"⚠️\"))","v":"✓"}]
[{"$f":"IF(SUM(estimate)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A39=\"Yes\",0,2)","v":0},{"$f":"B39","v":0},0,null,null,"Missing values (warning)",null,null,null,null,null,null,null,null,{"$f":"IF(A39=\"Yes\",\"\",\"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus.\")","v":""}]
[{"$f":"IF(SUM(estimate_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A40=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A40=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(AND(A42=\"Yes\",A43=\"Yes\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(B43=1,1,IF(AND(B43=0,B42=2),2,0))","v":2},null,0,null,"se recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A41=\"Yes\",\"✓\",IF(A43=\"No\",\"✗\",\"⚠️\"))","v":"⚠️"}]
[{"$f":"IF(SUM(se)=0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(A42=\"Yes\",0,2)","v":2},{"$f":"B42","v":2},0,null,null,"Missing values (warning)",null,null,null,null,null,null,null,null,{"$f":"IF(A42=\"Yes\",\"\",\"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus.\")","v":"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus."}]
[{"$f":"IF(SUM(se_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A43=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A43=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(AND(A45=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A44=\"Yes\",0,1)","v":0},null,0,null,"ci_lb recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A44=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(ci_lb_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A45=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A45=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(AND(A47=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A46=\"Yes\",0,1)","v":0},null,0,null,"ci_ub recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A46=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(ci_ub_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A47=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A47=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(AND(A49=\"Yes\",A50=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(B50=1,1,IF(AND(B50=0,B49=2),2,0))","v":0},null,{"$f":"IF(F48=\"\",B48-C48,0)","v":0},null,"Population recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A48=\"Yes\",\"✓\",IF(A50=\"No\",\"✗\",\"⚠️\"))","v":"✓"}]
[{"$f":"IF(SUM(population)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A49=\"Yes\",0,2)","v":0},{"$f":"B49","v":0},0,null,null,"Missing values (warning)",null,null,null,null,null,null,null,null,{"$f":"IF(A49=\"Yes\",\"\",\"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus.\")","v":""}]
[{"$f":"IF(SUM(population_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A50=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A50=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(AND(A52=\"Yes\",A53=\"Yes\",A54=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(OR(B53=1,B54=1),1,IF(AND(B53=0,B52=2),2,0))","v":0},null,0,null,"Setting average recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A51=\"Yes\",\"✓\",IF(OR(A53=\"No\",A54=\"No\"),\"✗\",\"⚠️\"))","v":"✓"}]
[{"$f":"IF(SUM(setting_average)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A52=\"Yes\",0,2)","v":0},{"$f":"B52","v":0},0,null,null,"Missing values (warning)",null,null,null,null,null,null,null,null,{"$f":"IF(A52=\"Yes\",\"\",\"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus.\")","v":""}]
[{"$f":"IF(SUM(setting_average_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A53=\"Yes\",0,1)","v":0},null,0,null,null,"Must be a number greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A53=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain numbers greater than or equal to zero (values cannot be negative).\")","v":""}]
[{"$f":"IF(SUM(checks!$CU:$CU)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A54=\"Yes\",0,1)","v":0},null,0,null,null,"Must be consistent for the same combination of: setting, year, source and indicator",null,null,null,null,null,null,null,null,{"$f":"IF(A54=\"Yes\",\"\",\"* Check that the setting average is consistent for any unique combination of setting, year, source and indicator\")","v":""}]
[{"$f":"IF(AND(A56=\"Yes\",A57=\"Yes\",A58=\"Yes\",A59=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(OR(B57=1,B58=1,B59=1),1,IF(AND(B57=0,B56=2),2,0))","v":0},null,0,null,"ISO3 recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A55=\"Yes\",\"✓\",IF(OR(A57=\"No\",A58=\"No\",A59=\"No\"),\"✗\",\"⚠️\"))","v":"✓"}]
[{"$f":"IF(SUM(iso3_)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A56=\"Yes\",0,2)","v":0},{"$f":"B56","v":0},0,null,null,"Missing values (warning)",null,null,null,null,null,null,null,null,{"$f":"IF(A56=\"Yes\",\"\",\"* Check variable for missing data to see if these are correct (highlighted in amber in the template tab). While not mandatory, if data for this variable is missing some calculations will not function in HEAT Plus.\")","v":""}]
[{"$f":"IF(SUM(iso3_val)=0,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(A57=\"Yes\",0,1)","v":0},null,0,null,null,"Must be three-character string",null,null,null,null,null,null,null,null,{"$f":"IF(A57=\"Yes\",\"\",\"* Data type error: Check that rows for this variable contain a three-character string (no numbers)\")","v":""}]
[{"$f":"IF(SUM(checks!$BJ:$BJ)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be a valid ISO3 code",null,null,null,null,null,null,null,null,{"$f":"IF(A58=\"Yes\",\"\",\"* Check that ISO3 codes match the list in the lookups tab\")","v":""}]
[{"$f":"IF(SUM(checks!$BU:$BU)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be consistent for the same setting",null,null,null,null,null,null,null,null,{"$f":"IF(A59=\"Yes\",\"\",\"* Check that ISO3 codes are consistent for the same setting\")","v":""}]
[{"$f":"IF(AND(A61=\"Yes\",A62=\"Yes\",A63=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Favourable_indicator recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A60=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(favourable_indicator)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A61=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(favourable_indicator_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be 1 or 0",null,null,null,null,null,null,null,null,{"$f":"IF(A62=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain values of either 1 or 0\")","v":""}]
[{"$f":"IF(SUM(checks!$CC:$CC)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be consistent for the same indicator",null,null,null,null,null,null,null,null,{"$f":"IF(A63=\"Yes\",\"\",\"* Check that favourable_indicator is consistent for the same indicator\")","v":""}]
[{"$f":"IF(AND(A65=\"Yes\",A66=\"Yes\",A67=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Indicator_scale recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A64=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(indicator_scale)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A65=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(indicator_scale_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be greater than zero",null,null,null,null,null,null,null,null,{"$f":"IF(A66=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain a number greater than zero\")","v":""}]
[{"$f":"IF(SUM(checks!$CH:$CH)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be consistent for the same indicator",null,null,null,null,null,null,null,null,{"$f":"IF(A67=\"Yes\",\"\",\"* Check that indicator_scale is consistent for the same indicator\")","v":""}]
[{"$f":"IF(AND(A69=\"Yes\",A70=\"Yes\",A71=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Ordered_dimension recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A68=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(ordered_dimension)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A69=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(ordered_dimension_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be 1 or 0",null,null,null,null,null,null,null,null,{"$f":"IF(A70=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain values of either 1 or 0\")","v":""}]
[{"$f":"IF(SUM(checks!$BY:$BY)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be consistent for the same dimension",null,null,null,null,null,null,null,null,{"$f":"IF(A71=\"Yes\",\"\",\"* Check that ordered_dimension is consistent for the same dimension\")","v":""}]
[{"$f":"IF(AND(A73=\"Yes\",A74=\"Yes\",A75=\"Yes\",A77=\"Yes\",A76=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},0,null,0,null,"Subgroup_order recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A72=\"Yes\",\"✓\",\"✗\")","v":"✓"}]
[{"$f":"IF(SUM(subgroup_order)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A73=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":""}]
[{"$f":"IF(SUM(subgroup_order_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be an integer greater than or equal to zero",null,null,null,null,null,null,null,null,{"$f":"IF(A74=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain an integer greater than or equal to zero (values cannot be decimals or negative)\")","v":""}]
[{"$f":"IF(SUM(checks!$BK:$BK)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be 0 when ordered_dimension = 0",null,null,null,null,null,null,null,null,{"$f":"IF(A75=\"Yes\",\"\",\"* Check that where ordered_dimension is recorded as 0, subgroup_order is also recorded as 0\")","v":""}]
[{"$f":"IF(SUM(checks!$CL:$CL)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be consistent for the same subgroup",null,null,null,null,null,null,null,null,{"$f":"IF(A76=\"Yes\",\"\",\"* Check that subgroup_order is consistent for the same subgroup\")","v":""}]
[{"$f":"IF(SUM(checks!$DC:$DC)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be an increasing sequence of integers starting with 1 when ordered_dimension = 1",null,null,null,null,null,null,null,null,{"$f":"IF(A77=\"Yes\",\"\",\"* Check that where ordered_dimension is recorded as 1, subgroup_order is an increasing sequence of numbers starting with 1 (and must not be 0)\")","v":""}]
[{"$f":"IF(AND(A79=\"Yes\",A80=\"Yes\",A81=\"Yes\",A82=\"Yes\"),\"Yes\",\"No\")","v":"No"},1,null,0,null,"Reference_subgroup recorded correctly",null,null,null,null,null,null,null,null,{"$f":"IF(A78=\"Yes\",\"✓\",\"✗\")","v":"✗"}]
[{"$f":"IF(SUM(reference_subgroup)=0,\"Yes\",\"No\")","v":"No"},1,null,1,null,null,"Missing values (mandatory)",null,null,null,null,null,null,null,null,{"$f":"IF(A79=\"Yes\",\"\",\"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)\")","v":"* Check variable for missing data as this variable is mandatory (highlighted in red on the template tab)"}]
[{"$f":"IF(SUM(reference_subgroup_val)=0,\"Yes\",\"No\")","v":"Yes"},0,null,{"$f":"IF(F80=\"\",B80-C80,0)","v":0},null,null,"Must be 1 or 0",null,null,null,null,null,null,null,null,{"$f":"IF(A80=\"Yes\",\"\",\"* Data type error: Check that all rows for this variable contain values of either 1 or 0\")","v":""}]
[{"$f":"IF(SUM(checks!$BL:$BL)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"Must be 0 when ordered_dimension = 1",null,null,null,null,null,null,null,null,{"$f":"IF(A81=\"Yes\",\"\",\"* Check that where ordered_dimension is recorded as 1, reference_subgroup is recorded as 0\")","v":""}]
[{"$f":"IF(SUM(checks!$DJ:$DJ)=0,\"Yes\",\"No\")","v":"Yes"},0,null,0,null,null,"There must be only one reference subgroup when ordered_dimension = 0",null,null,null,null,null,null,null,null,{"$f":"IF(A82=\"Yes\",\"\",\"* Check that where ordered_dimension is recorded as 0, there is only reference_subgroup recorded as 1\")","v":""}]
[{"$f":"IF(SUM('variable checks'!$Y:$Y)=0,\"Yes\",\"No\")","v":"Yes"},0,null,{"$f":"B83-C83","v":0},null,"All required columns are in the dataset",null,null,null,null,null,null,null,null,{"$f":"IF(A83=\"Yes\",\"✓\",\"✗\")","v":"✓"},{"$f":"IF(A83=\"Yes\",\"\",\"* Check that all of the variables listed in the 'template legend' tab are in the dataset\")","v":""}]

{"sheet":"validation detail","index":6,"n_rows":37,"n_cols":68,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(SUM(A4:A65703)=0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(A1=\"No\",(IF(OR(C1=\"No\",D1=\"No\",E1=\"No\",F1=\"No\",G1=\"No\",H1=\"No\",I1=\"No\",J1=\"No\",K1=\"No\",L1=\"No\",M1=\"No\",N1=\"No\",O1=\"No\",P1=\"No\",Q1=\"No\",R1=\"No\",S1=\"No\",T1=\"No\",U1=\"No\",V1=\"No\"),1,0))=1),\"No\",\"Yes\")","v":{"$error":"#REF!"}},{"$f":"validation!A19","v":"Yes"},{"$f":"validation!#REF!","v":{"$error":"#REF!"}},{"$f":"validation!A24","v":"Yes"},{"$f":"validation!A27","v":"Yes"},{"$f":"validation!A31","v":"Yes"},{"$f":"validation!A34","v":"Yes"},{"$f":"validation!A37","v":"Yes"},{"$f":"validation!A40","v":"Yes"},{"$f":"validation!A43","v":"Yes"},{"$f":"validation!A45","v":"Yes"},{"$f":"validation!A47","v":"Yes"},{"$f":"validation!A50","v":"Yes"},"Yes",{"$f":"validation!A53","v":"Yes"},{"$f":"validation!A57","v":"Yes"},{"$f":"validation!A62","v":"Yes"},{"$f":"validation!A66","v":"Yes"},{"$f":"validation!A70","v":"Yes"},{"$f":"validation!A74","v":"Yes"},{"$f":"validation!A80","v":"Yes"},{"$f":"X1","v":"Yes"},{"$f":"validation!A28","v":"Yes"},{"$f":"X1","v":"Yes"},{"$f":"AA1","v":"Yes"},{"$f":"validation!A54","v":"Yes"},{"$f":"AA1","v":"Yes"},{"$f":"AB1","v":"Yes"},"Yes","Yes","Yes",{"$f":"AH1","v":"Yes"},{"$f":"validation!A58","v":"Yes"},{"$f":"AJ1","v":"Yes"},{"$f":"validation!A59","v":"Yes"},{"$f":"AJ1","v":"Yes"},{"$f":"AM1","v":"Yes"},{"$f":"validation!A63","v":"Yes"},{"$f":"AM1","v":"Yes"},{"$f":"AP1","v":"Yes"},{"$f":"validation!A67","v":"Yes"},{"$f":"AP1","v":"Yes"},{"$f":"AS1","v":"Yes"},{"$f":"validation!A71","v":"Yes"},{"$f":"AS1","v":"Yes"},{"$f":"AV1","v":"Yes"},{"$f":"validation!A75","v":"Yes"},{"$f":"AX1","v":"Yes"},{"$f":"validation!A76","v":"Yes"},{"$f":"AX1","v":"Yes"},{"$f":"BA1","v":"Yes"},{"$f":"validation!A77","v":"Yes"},{"$f":"BA1","v":"Yes"},{"$f":"BB1","v":"Yes"},"Yes",{"$f":"BD1","v":"Yes"},{"$f":"BE1","v":"Yes"},{"$f":"BH1","v":"Yes"},{"$f":"validation!A81","v":"Yes"},{"$f":"BJ1","v":"Yes"},{"$f":"validation!A82","v":"Yes"},{"$f":"BJ1","v":"Yes"},{"$f":"BK1","v":"Yes"},{"$f":"BK1","v":"Yes"},{"$f":"BM1","v":"Yes"},{"$f":"BP1","v":"Yes"},{"$f":"validation!A83","v":"Yes"}]
["Missing data in mandatory variables",null,"Data type error - setting","Data type error - year","Data type error - source","Data type error - indicator_abbr","Data type error - indicator_name","Data type error - dimension","Data type error - subgroup","Data type error - estimate","Data type error - se","Data type error - ci_lb","Data type error - ci_ub","Data type error - population","Data type error - ","Data type error - setting_average","Data type error - iso3","Data type error - favourable_indicator","Data type error - indicator_scale","Data type error - ordered_dimension","Data type error - subgroup_order","Data type error - reference_subgroup",null,"indicator_abbr","indicator_name",null,"setting","year","source","indicator_abbr","indicator_name","setting_average",null,"iso3 code incorrect",null,"setting","iso3",null,"indicator_abbr","favourable_indicator",null,"indicator_abbr","indicator_scale",null,"dimension","ordered_dimension",null,"Ordered_dimension = 0 but subgroup_order is not 0",null,"subgroup","subgroup_order",null,"setting","year","source","indicator_abbr","dimension","subgroup_order",null,"Ordered_dimension = 1 but reference_subgroup is not 0",null,"setting","year","source","indicator_abbr","dimension",null,"Variables missing from the dataset"]
["row number",null,"row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number","row number",null,null,null,null,null,null,null,null,null,null,null,"row number",null,null,null,null,null,null,null,null,null,null,null,null,null,"row number",null,null,null,null,null,null,null,null,null,null,null,"row number",null,null,null,null,null,null,null,"Variable"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]

{"sheet":"lookups","index":7,"n_rows":195,"n_cols":2,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
["iso3","country"]
["AFG","Afghanistan"]
["ALB","Albania"]
["DZA","Algeria"]
["AND","Andorra"]
["AGO","Angola"]
["ATG","Antigua and Barbuda"]
["ARG","Argentina"]
["ARM","Armenia"]
["AUS","Australia"]
["AUT","Austria"]
["AZE","Azerbaijan"]
["BHS","Bahamas"]
["BHR","Bahrain"]
["BGD","Bangladesh"]
["BRB","Barbados"]
["BLR","Belarus"]
["BEL","Belgium"]
["BLZ","Belize"]
["BEN","Benin"]
["BTN","Bhutan"]
["BOL","Bolivia (Plurinational State of)"]
["BIH","Bosnia and Herzegovina"]
["BWA","Botswana"]
["BRA","Brazil"]
["BRN","Brunei Darussalam"]
["BGR","Bulgaria"]
["BFA","Burkina Faso"]
["BDI","Burundi"]
["CPV","Cabo Verde"]
["KHM","Cambodia"]
["CMR","Cameroon"]
["CAN","Canada"]
["CAF","Central African Republic"]
["TCD","Chad"]
["CHL","Chile"]
["CHN","China"]
["COL","Colombia"]
["COM","Comoros"]
["COG","Congo"]
["COK","Cook Islands"]
["CRI","Costa Rica"]
["CIV","Côte d'Ivoire"]
["HRV","Croatia"]
["CUB","Cuba"]
["CYP","Cyprus"]
["CZE","Czechia"]
["PRK","Democratic People's Republic of Korea"]
["COD","Democratic Republic of the Congo"]
["DNK","Denmark"]
["DJI","Djibouti"]
["DMA","Dominica"]
["DOM","Dominican Republic"]
["ECU","Ecuador"]
["EGY","Egypt"]
["SLV","El Salvador"]
["GNQ","Equatorial Guinea"]
["ERI","Eritrea"]
["EST","Estonia"]
["SWZ","Eswatini"]
["ETH","Ethiopia"]
["FJI","Fiji"]
["FIN","Finland"]
["FRA","France"]
["GAB","Gabon"]
["GMB","Gambia"]
["GEO","Georgia"]
["DEU","Germany"]
["GHA","Ghana"]
["GRC","Greece"]
["GRD","Grenada"]
["GTM","Guatemala"]
["GIN","Guinea"]
["GNB","Guinea-Bissau"]
["GUY","Guyana"]
["HTI","Haiti"]
["HND","Honduras"]
["HUN","Hungary"]
["ISL","Iceland"]
["IND","India"]
["IDN","Indonesia"]
["IRN","Iran (Islamic Republic of)"]
["IRQ","Iraq"]
["IRL","Ireland"]
["ISR","Israel"]
["ITA","Italy"]
["JAM","Jamaica"]
["JPN","Japan"]
["JOR","Jordan"]
["KAZ","Kazakhstan"]
["KEN","Kenya"]
["KIR","Kiribati"]
["KWT","Kuwait"]
["KGZ","Kyrgyzstan"]
["LAO","Lao People's Democratic Republic"]
["LVA","Latvia"]
["LBN","Lebanon"]
["LSO","Lesotho"]
["LBR","Liberia"]
["LBY","Libya"]
["LTU","Lithuania"]
["LUX","Luxembourg"]
["MDG","Madagascar"]
["MWI","Malawi"]
["MYS","Malaysia"]
["MDV","Maldives"]
["MLI","Mali"]
["MLT","Malta"]
["MHL","Marshall Islands"]
["MRT","Mauritania"]
["MUS","Mauritius"]
["MEX","Mexico"]
["FSM","Micronesia (Federated States of)"]
["MCO","Monaco"]
["MNG","Mongolia"]
["MNE","Montenegro"]
["MAR","Morocco"]
["MOZ","Mozambique"]
["MMR","Myanmar"]
["NAM","Namibia"]
["NRU","Nauru"]
["NPL","Nepal"]
["NLD","Netherlands (Kingdom of the)"]
["NZL","New Zealand"]
["NIC","Nicaragua"]
["NER","Niger"]
["NGA","Nigeria"]
["NIU","Niue"]
["NOR","Norway"]
["OMN","Oman"]
["PAK","Pakistan"]
["PLW","Palau"]
["PAN","Panama"]
["PNG","Papua New Guinea"]
["PRY","Paraguay"]
["PER","Peru"]
["PHL","Philippines"]
["POL","Poland"]
["PRT","Portugal"]
["QAT","Qatar"]
["KOR","Republic of Korea"]
["MDA","Republic of Moldova"]
["ROU","Romania"]
["RUS","Russian Federation"]
["RWA","Rwanda"]
["KNA","Saint Kitts and Nevis"]
["LCA","Saint Lucia"]
["VCT","Saint Vincent and the Grenadines"]
["WSM","Samoa"]
["SMR","San Marino"]
["STP","Sao Tome and Principe"]
["SAU","Saudi Arabia"]
["SEN","Senegal"]
["SRB","Serbia"]
["SYC","Seychelles"]
["SLE","Sierra Leone"]
["SGP","Singapore"]
["SVK","Slovakia"]
["SVN","Slovenia"]
["SLB","Solomon Islands"]
["SOM","Somalia"]
["ZAF","South Africa"]
["SSD","South Sudan"]
["ESP","Spain"]
["LKA","Sri Lanka"]
["SDN","Sudan"]
["SUR","Suriname"]
["SWE","Sweden"]
["CHE","Switzerland"]
["SYR","Syrian Arab Republic"]
["TJK","Tajikistan"]
["THA","Thailand"]
["MKD","North Macedonia"]
["TLS","Timor-Leste"]
["TGO","Togo"]
["TON","Tonga"]
["TTO","Trinidad and Tobago"]
["TUN","Tunisia"]
["TUR","Türkiye"]
["TKM","Turkmenistan"]
["TUV","Tuvalu"]
["UGA","Uganda"]
["UKR","Ukraine"]
["ARE","United Arab Emirates"]
["GBR","United Kingdom"]
["TZA","United Republic of Tanzania"]
["USA","United States of America"]
["URY","Uruguay"]
["UZB","Uzbekistan"]
["VUT","Vanuatu"]
["VEN","Venezuela (Bolivarian Republic of)"]
["VNM","Viet Nam"]
["YEM","Yemen"]
["ZMB","Zambia"]
["ZWE","Zimbabwe"]