{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","General data","Data entry (1)","Data entry (2)","Data entry (3)","Results (1)","Results (2)","Results (3)","Further resources","hide_backend","hide_Suchtabellen","hide_LI Database"],"not_rendered":{"charts":4,"images":35,"macros":1,"external_links":1,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,3,2,12],[3,3,3,12],[20,5,20,11],[22,5,22,11]]}
[]
[]
[null,null,null,"GIZ (Living) Income Gap Estimator"]
[null,null,null,"v1.0 (01.02.2022)"]
[]
[]
[null,null,"About this tool",null,"This tool allows calculating gaps between actual income and any given income reference"]
[null,null,null,null,"Considered are living income/wage benchmarks and various poverty lines"]
[]
[null,null,"Data requirements",null,"Guidance and/or calculation options are provided, depending on available data."]
[]
[null,null,"How to use it",null,1,"accept macros for the estimation tool to function"]
[null,null,null,null,2,"go to 'general data' form and define available information"]
[null,null,null,null,3,"fill data entry form with detailed/aggregated data"]
[null,null,null,null,null,"data entry cells can be identified by their green filling"]
[null,null,null,null,4,"go to results and explore the estimated income gaps"]
[]
[null,null,"Notes",null,"-","consider published reports/literature on (living) income gaps"]
[null,null,null,null,"-","depending on general data, different data entry forms will be opened"]
[null,null,null,null,"-","benchmarks/poverty lines used are derived from https://align-tool.com/"]
[]
[null,null,"ATTENTION",null,"-","quality of the estimated income gaps significantly depends on data quality and reliability"]
[]
[null,null,"Imprint",null,"Copyright: ",null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH"]
[null,null,null,null,"Developers:",null,"Tim K. Loos, Nicola Nuecken"]
[null,null,null,null,"Contact:",null,"ina@giz.de"]

{"sheet":"General data","index":1,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,3,27,7],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[16,8,16,9],[17,8,17,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kommentare"]
[null,null,"General information and specification of available data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ab hier wird später gelöscht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," \"very hidden\" werden in User Version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VBA Passwort schützen"]
[null,null,"Q1","Please provide information on the following key aspects",null,null,null,null,null,null,null,null,null,null,null,null,null,"Über VBA Worksheets ganz ausblenden \"VeryHidden\""]
[null,null,null,"A set of benchmarks will be generated based on your selection"]
[null,null,null,"Source of benchmarks: https://align-tool.com/"]
[]
[null,null,"a)","select country of interest",null,null,null,null,"Argentina"]
[null,null,"b)","select region or locality"]
[null,null,"c)","enter commodity",null,null,null,null,"Other"]
[null,null,"d)","select preferred currency",null,null,null,null,"Local Currency (LCU)"]
[]
[]
[]
[null,null,"Q2","You may define one additional benchmark or poverty line"]
[null,null,null,"Note: The unit of reporting must be",null,{"$f":"IF(I13=\"Local Currency (LCU)\",\"LCU\",I13)","v":"LCU"},"/HH /year",null,"(user defined benchmark)"]
[]
[]
[]
[null,null,"Q3","Please specify level of datail for your available data"]
[null,null,null,"Note: The buttons will forward you to the corresponding data entry sheet!"]
[]
[null,null,null,"Information is available for:"]
[null,null,"a)","Net income of all income generating activities (main and all other)"]
[]
[null,null,"b)","Net income of main product (e.g. crop) & income share of all income generating activities"]
[]
[null,null,"c)","Net income of main product (e.g. crop) & income share of main product"]
[]
[null,null,"d)","No information or only income from main product (e.g. crop)"]

{"sheet":"Data entry (1)","index":2,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,5,33,6],[19,2,21,4],[19,5,20,6],[23,5,25,6],[26,5,28,6],[32,2,32,4],[26,2,28,4],[23,2,25,4]]}
[]
[]
[null,null,"Data entry form"]
[null,null,"Net income of all income generating activities (main and all other)"]
[]
[]
[null,null,"Q1","Please provide information on the average (absolute) net income for all income generating activites"]
[null,null,null,"Note: consider total annual net income of all household members"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,"Other income sources"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,"(net) Off-farm income"]
[]
[null,null,"Actual income",null,null,{"$f":"IFERROR(F24+F27+F30,\"data missing\")","v":0}]
[]
[null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,"Primary cash crop income"]
[null,null,"Other income",null,null,{"$f":"IFERROR(L12+1-1,\"data missing\")","v":0}]
[]
[]
[null,null,"Net off-farm income",null,null,{"$f":"IFERROR(L17+1-1,\"data missing\")","v":0},null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,"Secondary cash crop income"]
[]
[null,null,null,null,null,{"$f":"IFERROR(L22+L27+L32, \"data missing\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,"Net farm income",null,null,null,null,null,null,"Produce consumed at home"]

{"sheet":"Data entry (2)","index":3,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,2,45,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"delete from P to end"]
[null,null,"Data entry form"]
[null,null,"Net income of main product (e.g. crop) & of other income generating activities"]
[]
[]
[null,null,"Q1","Please provide information on the average (absolute) net income of the main cash product (e.g. crop)"]
[null,null,null,"Note: consider total annual net income"]
[]
[]
[]
[null,null,null,null,null,1700,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,"Primary cash crop income"]
[]
[]
[]
[null,null,"Q2","Please provide the contribution of all income generating activities to total actual income "]
[null,null,null,"Note: the income distribution must add up to 100%; if there is no income from the source enter zero (0)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Other income sources"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Off-farm income"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Primary  cash crop income"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Secondary cash crop income"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"Produce consumed at home"]
[]
[]
[null,null,"Data entry check",null,{"$f":"IF(L22+L27+L32+L37+L42=100,\"income distribution correct\",\"please adjust income distribution data\")","v":"please adjust income distribution data"},null,null,null,null,null,null,{"$f":"L42+L37+L32+L27+L22","v":0},"%"]

{"sheet":"Data entry (3)","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Data entry form"]
[null,null,"Net income of main product (e.g. crop) & income share of main product"]
[]
[]
[null,null,"Q1","Please provide information on the average (absolute) net income of the main cash product (e.g. crop)"]
[null,null,null,"Note: consider total annual net income generated through main product"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,"Primary cash crop income"]
[]
[]
[]
[null,null,"Q2","Please specify the contribution of your main cash product (e.g. crop) to total actual income "]
[null,null,null,"Note: use the slide control to specify income share / for decimals enter share of main product directly"]
[]
[]
[]
[null,null,null,null,null,null,"%",null,"%",{"$f":"100-F22","v":100}]
[null,null,null,"Primary  cash crop income",null,null,null,null,null,null,null,null,"Other income sources"]

{"sheet":"Results (1)","index":5,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,18,17,20],[21,18,21,20],[25,18,25,20],[9,18,9,20],[29,18,29,20],[14,18,14,20],[18,18,18,20],[19,18,19,20],[22,18,22,20],[6,17,6,21],[10,18,10,20],[11,18,11,20],[13,18,13,20],[15,18,15,20],[23,18,23,20],[26,18,26,20],[27,18,27,20],[34,17,36,21],[34,2,36,15]]}
[]
[]
[null,null,"Results",null,"Net income of all income generating activities (main and all other)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benchmark Calculations"]
[null,null,null,null,null,null,null,null,null,null,"Av. Total Actual Income",null,{"$f":"hide_backend!F17","v":0},"USD","/HH /yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Income Benchmark",null,{"$f":"hide_backend!C6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LI per person per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (absolute)",null,{"$f":"hide_backend!F6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (percentage)",null,{"$f":"hide_backend!G6","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Wage Benchmark",null,{"$f":"hide_backend!C7","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (absolute)",null,{"$f":"hide_backend!F7","v":{"$error":"#N/A"}},{"$f":"'Results (1)'!L2","v":0},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (percentage)",null,{"$f":"hide_backend!G7","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Minimum Wage",null,{"$f":"hide_backend!$C$8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"MW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (absolute)",null,{"$f":"hide_backend!F8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (percentage)",null,{"$f":"hide_backend!G8","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Poverty Line",null,{"$f":"hide_backend!C9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"NL PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!F9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!G9","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"World Bank Poverty Line",null,{"$f":"hide_backend!C10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (absolute)",null,{"$f":"hide_backend!F10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (percentage)",null,{"$f":"hide_backend!G10","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"User Defined Benchmark",null,{"$f":"hide_backend!C11","v":0},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"defined in USD/HH/yr, no calcualation needed"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (absolute)",null,{"$f":"hide_backend!F11","v":"No benchmark"},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (percentage)",null,{"$f":"hide_backend!G11","v":"n.a."},"%"]
[]
[]
[null,null,"ATTENTION: The results are based on average income levels. Therefore, calculated gaps are also averages. Actual gaps might be larger for some households.\nValues are based on your entered data. Results should be considered estimates! It is recommended to validate and align income gap estimates with all relevant stakeholders!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note: For the benchmark values used, see the ALIGN Living Income and Living Wage dataset, which proveds the per person and per household benchmark values. "]

{"sheet":"Results (2)","index":6,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,3,37,15],[35,17,37,21],[21,18,21,20],[22,18,22,20],[23,18,23,20],[26,18,26,20],[27,18,27,20],[28,18,28,20],[30,18,30,20],[14,18,14,20],[15,18,15,20],[17,18,17,20],[18,18,18,20],[19,18,19,20],[6,17,6,21],[9,18,9,20],[10,18,10,20],[11,18,11,20],[13,18,13,20]]}
[]
[]
[null,null,"Results",null,"Net income of main product (e.g. crop) & of other income generating activities"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benchmark Calculations"]
[null,null,null,null,null,null,null,null,null,null,"Av. Total Actual Income",null,{"$f":"hide_backend!I28","v":{"$error":"#DIV/0!"}},"USD","/HH /yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Income Benchmark",null,{"$f":"hide_backend!C6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LI per person per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (absolute)",null,{"$f":"hide_backend!I6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (percentage)",null,{"$f":"hide_backend!J6","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Wage Benchmark",null,{"$f":"hide_backend!C7","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (absolute)",null,{"$f":"hide_backend!I7","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (percentage)",null,{"$f":"hide_backend!J7","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Minimum Wage",null,{"$f":"hide_backend!C8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"MW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (absolute)",null,{"$f":"hide_backend!I8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (percentage)",null,{"$f":"hide_backend!J8","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Poverty Line",null,{"$f":"hide_backend!C9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"NL PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!I9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!J9","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"World Bank Poverty Line",null,{"$f":"hide_backend!C10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (absolute)",null,{"$f":"hide_backend!I10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (percentage)",null,{"$f":"hide_backend!J10","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"User Defined Benchmark",null,{"$f":"hide_backend!C11","v":0},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"defined in USD/HH/yr, no calcualation needed"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (absolute)",null,{"$f":"hide_backend!I11","v":"No benchmark"},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (percentage)",null,{"$f":"hide_backend!J11","v":"n.a."},"%"]
[]
[]
[null,null,null,"ATTENTION: The results are based on average income levels. Therefore, calculated gaps are also averages. Actual gaps might be larger for some households.\nValues are based on your entered data. Results should be considered estimates! It is recommended to validate and align income gap estimates with all relevant stakeholders!",null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note: For the benchmark values used, see the ALIGN Living Income and Living Wage Dataset, which proveds the per person and per household benchmark values. "]

{"sheet":"Results (3)","index":7,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,18,6,20],[8,18,8,20],[9,18,9,20],[13,18,13,20],[17,18,17,20],[21,18,21,20],[29,18,29,20],[25,18,25,20],[10,18,10,20],[34,3,36,15],[34,17,36,21],[23,18,23,20],[26,18,26,20],[27,18,27,20],[11,18,11,20],[14,18,14,20],[15,18,15,20],[18,18,18,20],[19,18,19,20],[22,18,22,20]]}
[]
[]
[null,null,"Results",null,"Net income of main product (e.g. crop) & income share of main product"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benchmark Calculations"]
[null,null,null,null,null,null,null,null,null,null,"Av. Total actual income",null,{"$f":"hide_backend!F39","v":{"$error":"#DIV/0!"}},"USD","/HH /yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Income Benchmark",null,{"$f":"hide_backend!C6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LI per person per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (absolute)",null,{"$f":"hide_backend!L6","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Income Gap (percentage)",null,{"$f":"hide_backend!M6","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"Living Wage Benchmark",null,{"$f":"hide_backend!C7","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"LW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (absolute)",null,{"$f":"hide_backend!L7","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. Living Wage Gap (percentage)",null,{"$f":"hide_backend!M7","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Minimum Wage",null,{"$f":"hide_backend!C8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"MW per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (absolute)",null,{"$f":"hide_backend!L8","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National MW Gap (percentage)",null,{"$f":"hide_backend!M8","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"National Poverty Line",null,{"$f":"hide_backend!C9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"NL PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!L9","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. National PL Gap (absolute)",null,{"$f":"hide_backend!M9","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"World Bank Poverty Line",null,{"$f":"hide_backend!C10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"PL per wf per month * household size * 12"]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (absolute)",null,{"$f":"hide_backend!L10","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"Benchmark - Actual income "]
[null,null,null,null,null,null,null,null,null,null,"Av. World Bank PL Gap (percentage)",null,{"$f":"hide_backend!M10","v":{"$error":"#N/A"}},"%",null,null,null,null,"LI Gap/Benchmark * 100"]
[]
[null,null,null,null,null,null,null,null,null,null,"User Defined Benchmark",null,{"$f":"hide_backend!C11","v":0},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",null,null,null,"defined in USD/HH/yr, no calcualation needed"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (absolute)",null,{"$f":"hide_backend!L11","v":"No benchmark"},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr"]
[null,null,null,null,null,null,null,null,null,null,"Av. BM Gap (percentage)",null,{"$f":"hide_backend!M11","v":"n.a."},"%"]
[]
[]
[null,null,null,"ATTENTION: The results are based on average income levels. Therefore, calculated gaps are also averages. Actual gaps might be larger for some households.Values are based on your entered data. Results should be considered estimates! It is recommended to validate and align income gap estimates with all relevant stakeholders!",null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note: For the benchmark values used, see the ALIGN Living Income and Living Wage Dataset, , which proveds the per person and per household benchmark values. "]

{"sheet":"Further resources","index":8,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[22,2,23,11],[26,2,28,11],[30,2,31,11],[33,2,34,11],[41,2,42,11],[37,2,38,11]]}
[]
[]
[null,null,"Further resources that you may find useful"]
[]
[]
[null,null,"Websites "]
[null,null,"For link, click on image"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Publications"]
[]
[null,null,"Anker, R. and Anker, M. (2017): Living Wages around the world. Edward Elgar Publishing/Elgaronline. "]
[null,null,"https://doi.org/10.4337/9781786431462"]
[]
[null,null,"Fairtrade International (2019): Fairtrade Living Income Reference Price model. "]
[null,null,"Available at","https://www.fairtrade.net/issue/living-income#lirp"]
[]
[null,null,"Fountain, A.C. and Hütz-Adams, F. (2019): Necessary Farm Gate Prices for a Living Income. Consultation paper. Cocoa Barometer Consortium. "]
[]
[null,null,"Available at","https://www.voicenetwork.eu"]
[]
[null,null,"Krain, E.; Gyimah, O.J.; Pumpuni, I.; Kwapong-Akuffo, N. and M. Kuntze-Fechner (2021): Analysis and Report of a Baseline Study for a Living Income (and Other Benchmarks) in Cashew and Cocoa Growing Regions of Ghana. GIZ Competitive Cashew Initiative (ComCashew) and the Sustainable Agricultural Supply Chain Project (INA), Bremen, DE and Accra, GH."]
[]
[]
[]
[null,null,"Krain, E. and Steffens, L. (2019): Living Income Reference Pricing Tool, a Handbook to Determine Reference Prices for Agricultural Commodities Based on Benchmarks (Draft), Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ), Bonn"]
[]
[]
[null,null,"Loos, T.K., E. Krain, C. Veldhuyzen van Zanten and A. Petri (2021): How to calculate (living income) reference prices for agriculturalcommodities. Practitioner guide. Living Income Community of Practice. (under review)"]
[]
[null,null,"Available at","LINK, tba once available"]
[]
[null,null,"Tyszler, M., De Los Rios, E., Serflippi, G., Audet-Belanger, A. L. (2020): Guidance manual on calculating and visualizing the income gap to a Living Income Benchmark. The Commitee on Sustainability Assessment (COSA) and KIT Royal Tropical Institute."]
[]
[null,null,"Available at","https://www.living-income.com/licopresources"]
[]
[null,null,"Tyszler, M. and De Los Ríos, C. (2020): Guidance manual on calculating and visualizing the income gap to a Living Income Benchmark. Living Income Community of Practice."]
[]
[null,null,"Available at","LICOP resources | livingincome (living-income.com)"]

{"sheet":"hide_backend","index":9,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Benchmark Look-up drinnen"]
[null,"Mal 12 (um Jahr rauszukriegen)"]
[null,"Summary table",null,null,null,"S1_all info available",null,null,"S2_main & distribution",null,null,"S3_main and main share"]
[null,"Benchmarks","Value","Unit currency","Unit per X","Income gap","share","Gap?","Income gap","share","Gap?","Income gap",null,"Gap?"]
[null,"Living Income",{"$f":"INDEX('hide_LI Database'!BL7:BN62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LI Database'!A7:A62&'hide_LI Database'!B7:B62,0),MATCH('General data'!F18,'hide_LI Database'!BL6:BN6,0))*12","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",{"$f":"IF(C6=0,\"No benchmark\",C6-$F$17)","v":{"$error":"#N/A"}},{"$f":"IF(F6=\"No benchmark\",\"n.a.\",F6/C6*100)","v":{"$error":"#N/A"}},{"$f":"IF(F6<0,\"no income gap\",F6)","v":{"$error":"#N/A"}},{"$f":"IF(C6=0,\"No benchmark\",C6-$I$28)","v":{"$error":"#N/A"}},{"$f":"IF(I6=\"No benchmark\",\"n.a.\",I6/C6*100)","v":{"$error":"#N/A"}},{"$f":"IF(I6<0,\"no income gap\",I6)","v":{"$error":"#N/A"}},{"$f":"IF(C6=0,\"No benchmark\",C6-$F$39)","v":{"$error":"#N/A"}},{"$f":"IF(L6=\"No benchmark\",\"n.a.\",L6/C6*100)","v":{"$error":"#N/A"}},{"$f":"IF(L6<0,\"no income gap\",L6)","v":{"$error":"#N/A"}}]
[null,"Living Wage",{"$f":"INDEX('hide_LI Database'!BB7:BD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LI Database'!A7:A62&'hide_LI Database'!B7:B62,0),MATCH('General data'!F18,'hide_LI Database'!BB6:BD6,0))*12","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(F7<0,\"no income gap\",F7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(I7<0,\"no income gap\",I7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(L7<0,\"no income gap\",L7)","v":{"$error":"#N/A"}}]
[null,"National minimum wage",{"$f":"INDEX('hide_LI Database'!AR7:AT62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LI Database'!A7:A62&'hide_LI Database'!B7:B62,0),MATCH('General data'!F18,'hide_LI Database'!AR6:AT6,0))*12","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"National poverty line",{"$f":"INDEX('hide_LI Database'!AH7:AJ62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LI Database'!A7:A62&'hide_LI Database'!B7:B62,0),MATCH('General data'!F18,'hide_LI Database'!AH6:AJ6,0))*12","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"World Bank poverty line",{"$f":"INDEX('hide_LI Database'!S7:U62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LI Database'!A7:A62&'hide_LI Database'!B7:B62,0),MATCH('General data'!F18,'hide_LI Database'!S6:U6,0))*12","v":{"$error":"#N/A"}},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"User defined benchmark",{"$f":"'General data'!$I$17","v":0},{"$f":"'General data'!$I$13","v":"Local Currency (LCU)"},"/HH /yr","No benchmark","n.a.","No benchmark",{"$f":"IF(C11=0,\"No benchmark\",C11-$I$28)","v":"No benchmark"},"n.a.","No benchmark","No benchmark","n.a.","No benchmark"]
[]
[]
[]
[null,"Graph Scenario 1 - income of all income sources"]
[null,"Income source","Income",null,null,"Total actual income","gap","Übertrag","Check"]
[null,"Other income",{"$f":"'Data entry (1)'!$L$12","v":0},"Other income",{"$f":"$C$17","v":0},{"$f":"E17+E18+E19","v":0},{"$f":"MAX(C6:C11)-F17","v":{"$error":"#N/A"}},{"$f":"'Data entry (1)'!F20","v":0},{"$f":"F17-H17","v":0}]
[null,"Off-farm income",{"$f":"'Data entry (1)'!$L$17","v":0},"Off-farm income",{"$f":"$C$18","v":0}]
[null,"Primary crop income",{"$f":"'Data entry (1)'!$L$22","v":0},"Farm income",{"$f":"$C$19+$C$20+$C$21","v":0}]
[null,"Secondary crop income",{"$f":"'Data entry (1)'!$L$27","v":0}]
[null,"Produce consumed at home",{"$f":"'Data entry (1)'!$L$32","v":0}]
[]
[]
[]
[]
[null,"Graph Scenario 2 - income main & full income distribution"]
[null,"Income source","Income","Share","Factor",null,null,null,"Total actual income","gap"]
[null,"Other income",{"$f":"E28*$C$30","v":{"$error":"#DIV/0!"}},{"$f":"'Data entry (2)'!L22/100","v":0},{"$f":"D28/$D$30","v":{"$error":"#DIV/0!"}},"Other income",null,{"$f":"C28","v":{"$error":"#DIV/0!"}},{"$f":"H28+H29+H30","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C6:C11)-I28","v":{"$error":"#N/A"}}]
[null,"Off-farm income",{"$f":"E29*$C$30","v":{"$error":"#DIV/0!"}},{"$f":"'Data entry (2)'!L27/100","v":0},{"$f":"D29/$D$30","v":{"$error":"#DIV/0!"}},"Off-farm income",null,{"$f":"C29","v":{"$error":"#DIV/0!"}}]
[null,"Primary cash crop income",{"$f":"'Data entry (2)'!F12","v":1700},{"$f":"'Data entry (2)'!L32/100","v":0},{"$error":"#DIV/0!"},"Farm income",null,{"$f":"C30+C31+C32","v":{"$error":"#DIV/0!"}}]
[null,"Secondary crop income",{"$f":"E31*$C$30","v":{"$error":"#DIV/0!"}},{"$f":"'Data entry (2)'!L37/100","v":0},{"$error":"#DIV/0!"}]
[null,"Produce consumed at home",{"$f":"E32*$C$30","v":{"$error":"#DIV/0!"}},{"$f":"'Data entry (2)'!L42/100","v":0},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,"Graph Scenario 3 - income main & share main"]
[null,"Income source","Income","Share","Factor","Total actual income","gap"]
[null,"Other income",{"$f":"C40*E39","v":{"$error":"#DIV/0!"}},{"$f":"'Data entry (3)'!J22/100","v":1},{"$f":"D39/D40","v":{"$error":"#DIV/0!"}},{"$f":"C39+C40","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C6:C11)-F39","v":{"$error":"#N/A"}}]
[null,"Primary cash crop income",{"$f":"'Data entry (3)'!F12","v":0},{"$f":"'Data entry (3)'!F22/100","v":0},{"$f":"D40/D40","v":{"$error":"#DIV/0!"}}]

{"sheet":"hide_Suchtabellen","index":10,"n_rows":41,"n_cols":48,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
["Countries",null,"Region",null,"Commodity ",null,"Currency ",null,null,"Argentina","Bangladesh","Brazil","Burkina Faso","Cameroon","Chile","China","Colombia","Costa Rica","Cote d'Ivoire","Dominican Republic","Ecuador","Egypt, Arab Rep.","El Salvador","Ethiopia","Ghana","Guatemala","Honduras","India","Kenya","Madagascar","Malawi","Mexico","Morocco","Mozambique","Nicaragua","Nigeria","Pakistan","Panama","Papua New Guinea","Peru","Rwanda","South Africa","Sri Lanka","Tanzania","Tunisia","Turkey","Uganda","Vietnam"]
["Argentina",null,"Urban",null,"Banana",null,"EUR",null,null,"Urban","Urban Satellite Cities","Urban","Rural","Rural","Non-Metropolitan Urban","Urban Zhengzhou","Urban-Rural","Rural","Rural","Rural","Rural","Rural","Rural","Non-Metropolitan Urban","Peri-Urban","Rural","Rural","Urban","Rural","Rural","Rural","Non-metropolitan Urban & Rural","Rural","Rural","Urban","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Rural"]
["Bangladesh",null,"Rural",null,"Cocao",null,"Local Currency (LCU)",null,null,"Rural","Urban Dhaka City","Non-metropolitan",null,null,null,"Urban Chengdu",null,null,"Rural Cocoa growing areas",null,null,null,null,null,"Rural",null,null,"Rural Bhadohi, Uttar Pradesh","Non-metropolitan Urban",null,null,null,null,null,"Rural-Urban",null,"Urban",null,null,null,null,null,null,"Urban",null,null,null,"Urban"]
["Brazil",null,"Non-metropolitan",null,"Coffee",null,"USD",null,null,null,null,null,null,null,null,"Urban Hangzhou",null,null,null,null,null,null,null,null,null,null,null,"Rural Rural Nilgiris, Tamil Nadu"]
["Burkina Faso",null,"Non-Metropolitan Urban",null,"Orange",null,null,null,null,null,null,null,null,null,null,"Urban Shanghai"]
["Cameroon",null,"Urban-Rural",null,"Palmoil",null,null,null,null,null,null,null,null,null,null,"Urban Shenzhen"]
["Chile",null,"Peri-Urban",null,"Soy",null,null,null,null,null,null,null,null,null,null,"Urban Suzhou"]
["China",null,"Non-metropolitan Urban & Rural",null,"Vanila"]
["Colombia",null,"Rural-Urban",null,"Other"]
["Costa Rica"]
["Cote d'Ivoire"]
["Dominican Republic",null,"Production Scenario",null,null,null,"Hide Sheets list"]
["Ecuador",null,"Business as ususal",null,null,null,"Data entry (1)"]
["Egypt, Arab Rep.",null,"Good Agricultural Practices",null,null,null,"Data entry (2)"]
["El Salvador",null,"Model data",null,null,null,"Data entry (3)"]
["Ethiopia",null,"Other data",null,null,null,"hide_backend"]
["Ghana",null,null,null,null,null,"hide_LI Database"]
["Guatemala",null,null,null,null,null,"hide_Suchtabellen"]
["Honduras",null,null,null,null,null,"Results (1)"]
["India",null,null,null,null,null,"Results (2)"]
["Kenya",null,null,null,null,null,"Results (3)"]
["Madagascar"]
["Malawi"]
["Mexico"]
["Morocco"]
["Mozambique"]
["Nicaragua"]
["Nigeria"]
["Pakistan"]
["Panama"]
["Papua New Guinea"]
["Peru"]
["Rwanda"]
["South Africa"]
["Sri Lanka"]
["Tanzania"]
["Tunisia"]
["Turkey"]
["Uganda"]
["Vietnam"]

{"sheet":"hide_LI Database","index":11,"n_rows":62,"n_cols":70,"rows_kept":62,"cut":false,"hidden":false,"merged":[[4,68,5,68],[4,69,5,69],[4,53,4,56],[4,57,4,58],[4,59,4,62],[4,63,4,66],[4,67,5,67],[4,37,4,38],[4,39,4,42],[4,43,4,46],[4,47,4,48],[4,49,4,52],[2,37,2,46],[2,47,2,56],[2,57,2,66],[2,67,2,69],[3,37,3,46],[3,47,3,56],[3,57,3,66],[3,67,3,69],[4,29,4,32],[4,33,4,36],[4,10,4,13],[4,14,4,17],[4,18,4,21],[4,22,4,23],[4,25,4,28],[2,7,2,21],[2,22,2,36],[3,7,3,21],[3,22,3,36],[3,0,3,2],[3,3,3,6],[0,0,0,2],[0,3,1,6],[1,0,1,2],[2,0,2,2],[2,3,2,6]]}
["Living Wage & Living Income Dataset",null,null,"ALIGN (www.align-tool.com) provides an overview of the available living wage and income studies based on the internationally acknowledged Anker methodology."]
["Data valid on April 2021"]
["Geography\nSource: GLWC & LICoP",null,null,"Family composition\nSource: GLWC & LICoP",null,null,null,"International Poverty Lines\nSource: World Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National Poverty Lines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Wages\nSource: ILO & WageIndicator Foundation",null,null,null,null,null,null,null,null,null,"Living Wages\nSource: Global Living Wage Coalition",null,null,null,null,null,null,null,null,null,"Living Income\nSource: GLWC & LICoP",null,null,null,null,null,null,null,null,null,"Currency "]
["LW / LI are based on the cost of living in a specific geography, at country or sub-country level, and differ per rural, urban or peri-urban areas",null,null,"The family composition parameters, such as family size, adults per family and labour force are taken from the LW/LI studies.",null,null,null,"The International Poverty Lines are retrieved from the World Bank and differ per country according to the World Bank classification by income group. They are based on a division into 4 income groupings: low-income Int. Poverty Line, set at $1.90/day; lower-middle income Int. Poverty Line, set at $3.20/day; upper-middle income Int. Poverty Line, set at $5.50/day; and high-income Int. Poverty Line, set at $21.70/day. Information on family size and labour force from the LW/LI studies was taken into account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The National Poverty Lines are retrieved from official governmental sources that differ per country. The information on family size and labour force from the LW/LI studies was taken into account.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The data refer to national minimum wage rates where they exist. For countries with multiple minimum wage rates, the selected rate has been specified. Data reported as hourly, weekly, and yearly are converted to monthly, using a 45-hour standard work week, with a maximum of 8hours per day. The information on family size and labour force from the LW/LI studies was taken into account.",null,null,null,null,null,null,null,null,null,"The information is from the Global Living Wage Coalition, from living wage studies that use the full Anker Methodology and Anker Reference Values. The Global Living Wage Coalition's data on family size and labour force were taken into account.",null,null,null,null,null,null,null,null,null,"Information from LW/LI studies that use the full Anker Methodology and Anker Reference Values. In the lack of a living income study, cost of living data was taken from living wage studies to provide living income estimates. The information on family size and labour force from the LW/LI studies was taken into account.",null,null,null,null,null,null,null,null,null,"Currency conversion rates to LCU, EUR & USD are from InforEuro, January 2021. International dollars were calculated using the World Bank PPP conversion factor for 2019."]
["Country","Locality","Region/area","Study type","Family size","Adults per family","Labour force","Year","Poverty headcount ratio","Int. poverty line\nPer person/day","Int. poverty line\nPer person/month",null,null,null,"Int. poverty line\nPer workforce/month",null,null,null,"Int. poverty line \nPer family/month",null,null,null,null,null,"National poverty line\nPer person/day","National poverty line\nPer person/month",null,null,null,"National poverty line\nPer workforce/month",null,null,null,"National poverty line\nPer family/month",null,null,null,null,null,"Minimum Wage \nPer workforce/month",null,null,null,"Minimum Wage\nPer family/month",null,null,null,null,null,"Living Wage \nPer workforce/month",null,null,null,"Living Wage\nPer family/month",null,null,null,null,null,"Living Income\nPer person/month",null,null,null,"Living Income\nPer family/month",null,null,null,"Local currency unit (LCU)","Currency code","2019 PPP Conversion factor"]
[null,null,null,null,"#people","#adults","Workforce/ family",null,"% of population","USD","USD","EUR","LCU","2019 PPP$","USD","EUR","LCU","2019 PPP$","USD","EUR","LCU","2019 PPP$","Year","Source","LCU","LCU","USD","EUR","2019 PPP$","LCU","USD","EUR","2019 PPP$","LCU","USD","EUR","2019 PPP$","Year, type","Source","LCU","USD","EUR","2019 PPP$","LCU","USD","EUR","2019 PPP$","Year","Source","LCU","USD","EUR","2019 PPP$","LCU","USD","EUR","2019 PPP$","Year","Source","LCU","USD","EUR","2019 PPP$","LCU","USD","EUR","2019 PPP$"]
["Argentina","Urban",null,"Living Wage Reference Value",4,2,1.66,2019,14,5.5,{"$f":"J7*30.4","v":167.2},136,13923,null,{"$f":"S7/G7","v":402.89156626506025},{"$f":"T7/G7","v":327.71084337349401},{"$f":"U7/G7","v":33549.397590361448},null,{"$f":"K7*E7","v":668.8},{"$f":"L7*E7","v":544},{"$f":"M7*E7","v":55692},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"Wage Indicator",21600,259,211,null,{"$f":"AN7*G7","v":35856},430,350,null,2020,"GLWC",38741,465,378,null,{"$f":"AX7*G7","v":64310.06},{"$f":"AY7*G7","v":771.9},{"$f":"AZ7*G7","v":627.48},null,2020,"Calculated from GLWC",{"$f":"(36376*G7)/E7","v":15096.039999999999},181,147,null,{"$f":"BH7*E7","v":60384.159999999996},{"$f":"BI7*E7","v":724},{"$f":"BJ7*E7","v":588},null,"Argentine peso","ARS"]
["Argentina","Rural",null,"Living Income Reference Value",4,2,null,2019,14,5.5,167.2,136,13923,null,null,null,null,null,{"$f":"K8*E8","v":668.8},544,55692,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"Wage Indicator",21600,259,211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",{"$f":"BL8/E8","v":12505.75},{"$f":"BM8/E8","v":150},{"$f":"BN8/E8","v":122.25},null,50023,600,489,null,"Argentine peso","ARS"]
["Bangladesh","Urban","Satellite Cities and Districts Surrounding Dhaka","Living Wage Benchmark",4,2,1.58,2016,52,3.2,97.28,79,8226,{"$f":"M9/BR9","v":260.84157849514719},{"$f":"S9/G9","v":246.27848101265823},{"$f":"T9/G9","v":200},{"$f":"U9/G9","v":20825.3164556962},{"$f":"Q9/BR9","v":660.35842656999284},389.12,316,32904,{"$f":"U9/BR9","v":1043.3663139805888},"2016, Low poverty line","Bangladesh Bureau of Statistics (BBS)",{"$f":"Z9/30.4","v":61.25},1862,{"$f":"AI9/E9","v":22},{"$f":"AJ9/E9","v":18},{"$f":"Z9/BR9","v":59.042915044731842},{"$f":"(Y9*30.4*E9)/G9","v":4713.9240506329115},56,46,{"$f":"AD9/BR9","v":149.47573429046037},{"$f":"Y9*30.4*E9","v":7448},88,72,{"$f":"AH9/BR9","v":236.17166017892737},2013,"Wage Indicator",1500,18,14,{"$f":"AN9/BR9","v":47.564109864177098},{"$f":"AN9*G9","v":2370},{"$f":"AO9*G9","v":28.44},{"$f":"AP9*G9","v":22.12},{"$f":"AR9/BR9","v":75.151293585399813},2016,"GLWC",13630,161,131,{"$f":"AX9/BR9","v":432.19921163248927},{"$f":"AX9*G9","v":21535.4},{"$f":"AY9*G9","v":254.38000000000002},{"$f":"AZ9*G9","v":206.98000000000002},{"$f":"BB9/BR9","v":682.87475437933301},2016,"Calculated from GLWC",5135.5,60.5,49.25,{"$f":"BH9/BR9","v":162.84365747165432},20542,242,197,{"$f":"BL9/BR9","v":651.3746298866173},"Bangladeshi taka","BDT",31.536383300000001]
["Bangladesh","Urban","Dhaka City","Living Wage Benchmark",4,2,1.58,2016,52,3.2,97.28,79,8226,260.84157849514719,246.27848101265823,200,20825.3164556962,660.35842656999284,389.12,316,32904,1043.3663139805888,"2016, Low poverty line","Bangladesh Bureau of Statistics (BBS)",{"$f":"Z10/30.4","v":61.25},1862,22,18,59.042915044731842,4713.9240506329115,56,46,149.47573429046037,7448,88,72,236.17166017892737,2013,"Wage Indicator",1500,18,14,47.564109864177098,2370,28.44,22.12,75.151293585399813,2016,"GLWC",16460,194,158,{"$f":"AX10/BR10","v":521.93683224290339},{"$f":"AX10*G10","v":26006.800000000003},{"$f":"AY10*G10","v":306.52000000000004},{"$f":"AZ10*G10","v":249.64000000000001},{"$f":"BB10/BR10","v":824.66019494378747},2016,"Calculated from GLWC",6202.25,73.25,59.5,196.66966693672828,24809,293,238,786.67866774691311,"Bangladeshi taka","BDT",31.536383300000001]
["Brazil","Urban","Minas Gerais South/Southwestern Region","Living Wage Benchmark",4,2,1.71,2019,20,5.5,167.2,136,864,360.06342817340135,391.11111111111109,318.12865497076024,2021.0526315789475,842.25363315415518,668.8,544,3456,1440.2537126936054,2017,"Universidade Federal do Rio Grande do Sul",{"$f":"Z11/30.4","v":2.3026315789473686},70,13.5,11,29.171805523307977,163.74269005847952,32,26,68.238141574989427,280,54,44,116.68722209323191,2021,"Wage Indicator",1100,212,173,458.41408679483965,1881,362.52,295.83,783.8880884191758,2019,"GLWC",1650,319,260,{"$f":"AX11/BR11","v":687.62113019225944},{"$f":"AX11*G11","v":2821.5},{"$f":"AY11*G11","v":545.49},{"$f":"AZ11*G11","v":444.59999999999997},{"$f":"BB11/BR11","v":1175.8321326287637},2019,"Calculated from GLWC",759,146.5,119.25,316.30571988843934,3036,586,477,1265.2228795537574,"Brazilian real","BRL",2.3995772199999998]
["Brazil","Non-metropolitan","State of São Paulo, non-metropolitan areas","Living Wage Benchmark",4,2,1.68,2019,20,5.5,167.2,136,864,360.06342817340135,398.09523809523807,323.8095238095238,2057.1428571428573,857.29387660333657,668.8,544,3456,1440.2537126936054,2017,"Universidade Federal do Rio Grande do Sul",{"$f":"Z12/30.4","v":2.3026315789473686},70,13.5,11,29.171805523307977,166.66666666666669,32,26,69.456679817399959,280,54,44,116.68722209323191,2021,"Wage Indicator",1100,212,173,458.41408679483965,1848,356.15999999999997,290.64,770.13566581533064,2021,"GLWC",2551,493,401,{"$f":"AX12/BR12","v":1063.1039412851237},{"$f":"AX12*G12","v":4285.68},{"$f":"AY12*G12","v":828.24},{"$f":"AZ12*G12","v":673.68},{"$f":"BB12/BR12","v":1786.0146213590078},2021,"Calculated from GLWC",932.25,180,146.5,388.50593855862661,3729,720,586,1554.0237542345064,"Brazilian real","BRL",2.3995772199999998]
["Burkina Faso","Rural",null,"Living Income Reference Value",5.5,2,1.64,2014,44,1.9,57.76,47,30979,163.96141707715506,193.70731707317074,157.6219512195122,103892.98780487805,549.87060605143472,317.68,258.5,170384.5,901.78779392435285,2009,"World Bank, 2016",{"$f":"1.64*223.1","v":365.88399999999996},{"$f":"Y13*30.4","v":11122.873599999999},20.90909090909091,16.90909090909091,58.869625146908454,37302.32,70,57,197.42862091951008,61175.804799999998,115,93,323.78293830799652,2012,"Wage Indicator",34664,65,53,183.46488142168897,56848.959999999999,106.6,86.92,300.88240553156993,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",15703.09090909091,29.454545454545453,24,83.111173309207416,86367,162,132,457.11145320064077,"West African CFA franc","XOF",188.94079199999999]
["Cameroon","Rural",null,"LW & LI Reference Value",5.5,2,1.71,2014,47,3.2,97.28,79,51810,220.26383773018102,312.88888888888886,254.09356725146199,166640.35087719298,708.4509400678337,535.04,434.5,284955,1211.4511075159955,2007,"World Bank, 2016",{"$f":"2.35*242.7","v":570.34500000000003},{"$f":"Y14*30.4","v":17338.488000000001},32.545454545454547,26.363636363636363,73.712447545236273,55767.066666666673,104,85,237.08681958994123,95361.684000000008,179,145,405.4184614987995,2014,"Wage Indicator",36270,68,55,154.19744054185804,62021.7,116.28,94.05,263.67762332657725,2020,"GLWC",104623,196,160,{"$f":"AX14/BR14","v":444.79180650153887},{"$f":"AX14*G14","v":178905.33},{"$f":"AY14*G14","v":335.15999999999997},{"$f":"AZ14*G14","v":273.60000000000002},{"$f":"BB14/BR14","v":760.59398911763139},2020,"GLWC",28317.454545454544,53.090909090909093,43.272727272727273,120.38817241713524,155746,292,238,662.13494829424383,"Central African CFA franc","XAF",235.21791200000001]
["Chile","Non-Metropolitan Urban",null,"Living Wage Reference Value",4,2,1.7,2017,4,5.5,167.2,136,118613,267.31288295388117,393.41176470588232,320,279089.4117647059,628.97148930324977,668.8,544,474452,1069.2515318155247,2021,"Ministerio de Desarollo Social",{"$f":"Z15/30.4","v":5810.0328947368425},176625,248.75,202.5,398.0519669153403,415588.23529411765,585,476,936.59286333021248,706500,995,810,1592.2078676613612,2020,"Wage Indicator",326500,460,375,735.81863947832187,555050,781,636,1250.8916871131473,2020,"GLWC",623057,877,714,1404.1560614316841,1059196.8999999999,1490.8999999999999,1213.8,2387.0653044338624,2020,"Calculated from  GLWC",{"$f":"(513399*G15)/E15","v":218194.57499999998},307.25,250.25,491.73548336309545,{"$f":"513399*G15","v":872778.29999999993},1229,1001,1966.9419334523818,"Chilean peso","CLP",443.72347000000002]
["China","Urban","Zhengzhou","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",{"$f":"1.78*3.7","v":6.5860000000000003},{"$f":"Y16*30.4","v":200.21440000000001},30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,{"$f":"AO16*G16","v":386.26},{"$f":"AP16*G16","v":315.06},603.5822205350895,2019,"GLWC",3036,465,379,727.03438295266449,5404.08,827.7,674.62,1294.1212016557429,2019,"Calculated from  GLWC",{"$f":"BL16/E16","v":1385.1428571428571},212.28571428571428,172.85714285714286,331.70173993549008,4848,743,605,1160.9560897742153,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["China","Urban","Chengdu","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",6.5860000000000003,200.21440000000001,30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,386.26,315.06,603.5822205350895,2019,"GLWC",2597,398,324,621.90655221609677,4622.66,708.44,576.72,1106.9936629446522,2019,"Calculated from  GLWC",1183.7142857142858,181.42857142857142,147.71428571428572,283.46541018001966,4143,635,517,992.1289356300689,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["China","Urban","Hangzhou","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",6.5860000000000003,200.21440000000001,30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,386.26,315.06,603.5822205350895,2019,"GLWC",4159,637,519,995.96047388014881,7403.02,1133.8600000000001,923.82,1772.809643506665,2019,"Calculated from  GLWC",1892.8571428571429,290,236,453.28465904963321,6625,1015,826,1586.4963066737162,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["China","Urban","Shanghai","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",6.5860000000000003,200.21440000000001,30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,386.26,315.06,603.5822205350895,2019,"GLWC",4502,670,546,1078.0990751162369,8013.56,1192.5999999999999,971.88,1919.016353706902,2019,"Calculated from  GLWC",2049.1428571428573,314,255.71428571428572,490.71057731380671,7172,1099,895,1717.4870205983234,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["China","Urban","Shenzhen","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",6.5860000000000003,200.21440000000001,30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,386.26,315.06,603.5822205350895,2019,"GLWC",3004,460,375,719.37130645250465,5347.12,818.80000000000007,667.5,1280.4809254854583,2019,"Calculated from  GLWC",1399.4285714285713,214.57142857142858,174.85714285714286,335.12275623020423,4898,751,612,1172.929646805715,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["China","Urban","Suzhou","Living Wage Benchmark",3.5,2,1.78,2016,24,5.5,167.2,136,1090,261.02354328669441,328.76404494382018,267.41573033707863,2143.2584269662921,513.24854017046653,585.19999999999993,476,3815,913.58240150343056,2011,"World Bank, 2016",6.5860000000000003,200.21440000000001,30.571428571428573,24.857142857142858,47.945570738550053,393.68,60,49,94.274998643216392,700.75040000000001,107,87,167.80949758492517,"2019, urban","ILO",1416,217,177,339.09113513207279,2520.48,386.26,315.06,603.5822205350895,2019,"GLWC",3875,594,484,927.95066994123022,6897.5,1057.32,861.52,1651.7521924953899,2019,"Calculated from GLWC",1763.7142857142858,270.28571428571428,220,422.3586717454167,6173,946,770,1478.2553511089584,"Chinese Yuan Renminbi","CNY",4.1758685299999998]
["Colombia","Urban-Rural","Caribbean coast","Living Wage Benchmark",4,2,1.61,2019,29,5.5,167.2,136,583460,408.15886814088691,415.40372670807449,337.88819875776397,1449590.0621118012,1014.0592997289116,668.8,544,2333840,1632.6354725635476,2018," DANE. Gran Encuesta Integrada de Hogares GEIH 2018",{"$f":"Z22/30.4","v":8468.1907894736851},257433,73.75,60,180.08700151186531,639585.09316770185,183,149,447.42112176860951,1029732,295,240,720.34800604746124,2021,"Wage Indicator",908526,260,212,635.55846816674227,1462726.86,418.6,341.32,1023.2491337484551,2020,"GLWC",1644569,471,384,1150.456623623882,2647756.0900000003,758.31000000000006,618.24,1852.2351640344505,2020,"Calculated from  GLWC",608400,174.25,142,425.60562056853183,2433600,697,568,1702.4224822741273,"Colombian peso","COP",1429.4924000000001]
["Costa Rica","Rural","Limón and Heredia Provinces","Living Wage Benchmark",4,2,1.56,2019,11,5.5,167.2,136,101908,297.29072458394546,428.71794871794867,348.71794871794873,261302.56410256409,762.28390918960372,668.8,544,407632,1189.1628983357818,2018,"Instituto Nacional de Estadística y Censos (INEC) ",{"$f":"Z23/30.4","v":277.46710526315792},8435,13.75,11.25,24.60697160051792,21628.205128205129,35,28,63.09479897568697,33740,55,45,98.427886402071678,"2019, urban","ILO",320978,526,428,936.3718471121565,500725.68,820.56000000000006,667.68000000000006,1460.7400814949642,2019,"GLWC",483282,792,645,1409.8525725004743,753919.92,1235.52,1006.2,2199.3700131007399,2019,"Calculated from  GLWC",152721.75,250.25,203.75,445.52694309797243,610887,1001,815,1782.1077723918897,"Costa Rican colón","CRC",342.78903300000002]
["Cote d'Ivoire","Rural",null,"Living Wage Reference Value",5.5,2,1.61,2015,59,3.2,97.28,79,51810,220.3111504427157,332.3229813664596,269.87577639751549,176990.68322981364,752.61573132604735,535.04,434.5,284955,1211.7113274349365,2015,"Ministère De L´Économie Et Des Finances",737,{"$f":"Y24*30.4","v":22404.799999999999},42,34.18181818181818,95.271709388900916,76538.136645962732,143,116,325.46236126643174,123226.4,231,188,523.99440163895508,2013,"Wage Indicator",60000,112,91,255.13740641889487,96600,180.32000000000002,146.51000000000002,410.77122433442071,2020,"GLWC",100590,188,153,427.73786186127722,161949.90000000002,302.68,246.33,688.65795759665639,2020,"Calculated from  GLWC",{"$f":"(90516*G24)/E24","v":26496.50181818182},49.636363636363633,40.363636363636367,112.67081255107402,{"$f":"90516*G24","v":145730.76},273,222,619.68946903090716,"West African CFA franc","XOF",235.16739799999999]
["Cote d'Ivoire","Rural","Cocoa growing areas","Living Income Benchmark",6,2,1.65,2015,59,3.2,97.28,79,51810,220.3111504427157,353.74545454545461,287.27272727272731,188400,801.13145615532983,583.68000000000006,474,310860,1321.8669026562943,2015,"Ministère De L´Économie Et Des Finances",737,{"$f":"Y25*30.4","v":22404.799999999999},42,34.166666666666664,95.271709388900916,81472,153,125,346.44257959600338,134428.79999999999,252,205,571.63025633340555,2013,"Wage Indicator",60000,112,91,255.13740641889487,99000,184.79999999999998,150.15,420.9767205911765,null,null,null,null,null,null,null,null,null,null,2018,"LICoP",{"$f":"BL25/E25","v":43676},81.833333333333329,66.666666666666671,185.72302271252752,262056,491,400,1114.3381362751652,"West African CFA franc","XOF",235.16739799999999]
["Dominican Republic","Rural","Northern Region","Living Wage Benchmark",4,2,1.67,2019,12,5.5,167.2,136,9601,389.37774589178292,400.47904191616766,325.74850299401197,22996.407185628745,932.64130752522863,668.8,544,38404,1557.5109835671317,2019,"Ministerio de Economía, Planificación y Desarrollo (MEPYD)",{"$f":"Z26/30.4","v":168.81578947368422},5132,89.25,72.75,208.1331727858171,12292.215568862275,214,174,498.52256954686732,20528,357,291,832.53269114326838,"2019, urban","ILO",12015,209,170,487.27982677739527,20065.05,349.03,283.89999999999998,813.75731071824998,2019,"GLWC",17562,305,248,{"$f":"AX26/BR26","v":712.24372183642242},{"$f":"AX26*G26","v":29328.539999999997},{"$f":"AY26*G26","v":509.34999999999997},{"$f":"AZ26*G26","v":414.15999999999997},{"$f":"BB26/BR26","v":1189.4470154668254},2019,"Calculated from GLWC",{"$f":"BL26/E26","v":6864},119.5,97.25,278.37609080316611,27456,478,389,1113.5043632126644,"Dominican peso","DOP",24.65729]
["Ecuador","Rural","Southern Coastal Region","Living Wage Benchmark",4,2,1.61,2019,25,5.5,167.2,136,167,303.05740277410399,415.40372670807449,337.88819875776397,414.90683229813664,752.93764664373657,668.8,544,668,1212.229611096416,2019,"Instituto Nacional de Estadistica y Censos",{"$f":"Z27/30.4","v":2.7960526315789473},85,85,69,154.25077386705891,211.18012422360246,211,172,383.23173631567431,340,340,276,617.00309546823564,"2019, urban","ILO",394,394,321,714.99770474848492,634.34,634.34,516.81000000000006,1151.1463046450606,2020,"GLWC",461,461,375,{"$f":"AX27/BR27","v":836.58360885546074},742.21,742.21,603.75,{"$f":"BB27/BR27","v":1346.8996102572919},2020,"Calculated from  GLWC",{"$f":"BL27/E27","v":170.25},170.25,138.75,308.95522648078565,681,681,555,1235.8209059231426,"United States dollar","USD",0.55105071999999999]
["Egypt, Arab Rep.","Rural",null,"Living Wage Reference Value",5,2,1.53,2017,29,3.2,97.28,79,1514,null,317.90849673202615,258.16993464052285,4947.7124183006536,null,486.4,395,7570,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"Wage Indicator",2000,128,104,null,3060,195.84,159.12,null,2020,"GLWC",3957,253,206,null,6054.21,387.09000000000003,315.18,null,2020,"Calculated from  GLWC",{"$f":"(3686*G28)/E28","v":1127.9159999999999},72.2,58.8,null,{"$f":"3686*G28","v":5639.58},361,294,null,"Egyptian pound","EGP"]
["El Salvador","Rural",null,"Living Wage Reference Value",4.5,2,1.59,2019,6,3.2,97.28,79,849,{"$f":"M29/BR29","v":1699.592654284477},275.32075471698113,223.58490566037736,2402.8301886792451,{"$f":"Q29/BR29","v":4810.1678894843681},437.76,355.5,3820.5,{"$f":"U29/BR29","v":7648.1669442801467},2011,"World Bank, 2016",{"$f":"5.42*0.5","v":2.71},{"$f":"Y29*30.4","v":82.384},{"$f":"AI29/E29","v":9.3333333333333339},{"$f":"AJ29/E29","v":7.7777777777777777},{"$f":"Z29/BR29","v":164.92254561904869},{"$f":"(Y29*30.4*E29)/G29","v":233.1622641509434},27,22,{"$f":"AD29/BR29","v":466.76192156334542},{"$f":"Y29*30.4*E29","v":370.72800000000001},42,35,{"$f":"AH29/BR29","v":742.15145528571918},"2019, urban","ILO",2660,304,248,{"$f":"AN29/BR29","v":5324.9899415744512},4229.4000000000005,483.36,394.32,{"$f":"AR29/BR29","v":8466.7340071033777},2020,"GLWC",3136,358,292,{"$f":"AX29/BR29","v":6277.8828784877733},4986.2400000000007,569.22,464.28000000000003,{"$f":"BB29/BR29","v":9981.8337767955618},2020,"Calculated from  GLWC",{"$f":"(2815*G29)/E29","v":994.63333333333344},113.77777777777777,92.666666666666671,{"$f":"BH29/BR29","v":1991.1325171258152},{"$f":"2815*G29","v":4475.8500000000004},512,417,{"$f":"BL29/BR29","v":8960.0963270661687},"Salvadoran colon","SVC",0.49953145999999998]
["Ethiopia","Non-Metropolitan Urban","Ziway Region","Living Wage Benchmark",5,2,1.65,2015,31,1.9,57.76,47,2252,209.64936525349805,175.03030303030306,142.42424242424244,6824.2424242424249,635.30110682878205,288.8,235,11260,1048.2468262674902,"2015/16","Planning and Development Commission ",{"$f":"7184/365","v":19.682191780821917},598.33863013698624,15.4,12.6,55.702182066992322,1813.1473640514737,44,37,168.79449111209797,2991.6931506849314,77,63,278.51091033496164,null,null,null,null,null,null,null,null,null,null,2019,"GLWC",4847,125,102,{"$f":"AX30/BR30","v":451.23022796789746},7997.5499999999993,206.25,168.29999999999998,{"$f":"BB30/BR30","v":744.52987614703068},2019,"Calculated from  GLWC",{"$f":"BL30/E30","v":1304},33.6,27.4,121.3955471982955,6520,168,137,606.97773599147752,"Ethiopian birr","ETB",10.7417449]
["Ghana","Peri-Urban","Lower Volta Region","Living Wage Benchmark",4.5,2,1.78,2016,29,3.2,97.28,79,552,284.56661911276643,245.93258426966293,199.71910112359549,1395.5056179775281,719.40999213901637,437.76,355.5,2484,1280.549786007449,"2012/13","Ghana Statistical Service",{"$f":"1314/365","v":3.6},109.44,19.111111111111111,15.555555555555555,56.418425354531088,276.67415730337081,49,40,142.6308506153876,492.48,86,70,253.88291409538991,2020,"Wage Indicator",319,56,46,{"$f":"AN31/BR31","v":164.45063676987772},{"$f":"AN31*G31","v":567.82000000000005},{"$f":"AO31*G31","v":99.68},{"$f":"AP31*G31","v":81.88},{"$f":"AR31/BR31","v":292.72213345038233},2019,"GLWC",1244,219,178,{"$f":"AX31/BR31","v":641.30593147877073},2214.3200000000002,389.82,316.84000000000003,{"$f":"BB31/BR31","v":1141.5245580322121},2019,"Calculated from  GLWC",{"$f":"BL31/E31","v":418},73.555555555555557,60,215.48704128466736,1881,331,270,969.69168578100312,"Ghana cedi","GHS",1.9397918199999999]
["Ghana","Rural","Cocoa growing areas of Ashanti, Central, Eastern, Western Regions","Living Income Benchmark",5,2,1.56,2016,29,3.2,97.28,79,552,284.56661911276643,311.79487179487177,253.2051282051282,1769.2307692307693,912.0724971563028,486.4,395,2760,1422.8330955638323,"2012/14","Ghana Statistical Service",{"$f":"1314/365","v":3.6},109.44,19.2,16.2,56.418425354531088,350.76923076923077,62,53,180.82828639272785,547.20000000000005,96,81,282.09212677265543,2020,"Wage Indicator",319,56,46,164.45063676987772,497.64000000000004,87.36,71.760000000000005,256.54299336100928,null,null,null,null,null,null,null,null,null,null,2019,"LICoP",{"$f":"BL32/E32","v":336.6},59.2,48.2,173.52377535028478,1683,296,241,867.61887675142384,"Ghana cedi","GHS",1.9397918199999999]
["Guatemala","Rural","Central Valley Area","Living Wage Benchmark",5,2,1.53,2014,49,5.5,167.2,136,1301,286.42294205407842,546.40522875816987,444.44444444444446,4251.6339869281046,936.02268645123661,836,680,6505,1432.1147102703919,2014,"Instituto Nacional de Estadística",{"$f":"10218/365","v":27.994520547945207},851.03342465753428,109.2,93,187.36010551634806,2781.1549825409616,357,291,612.2879265240133,4255.1671232876715,546,465,936.80052758174031,"2019, urban","ILO",2773,356,290,610.49255827514173,4242.6900000000005,544.68000000000006,443.7,934.05361416096696,2019,"GLWC",2981,383,312,{"$f":"AX33/BR33","v":656.28500404550937},{"$f":"AX33*G33","v":4560.93},{"$f":"AY33*G33","v":585.99},{"$f":"AZ33*G33","v":477.36},{"$f":"BB33/BR33","v":1004.1160561896294},2019,"Calculated from  GLWC",{"$f":"BL33/E33","v":872.6},112,91.2,192.10811624626351,4363,560,456,960.54058123131745,"Guatemalan quetzal","GTQ",4.5422339100000002]
["Honduras","Rural",null,"Living Wage Reference Value",4.5,2,1.65,2019,29,3.2,97.28,79,2338,206.58790630862029,265.30909090909091,215.45454545454547,6376.3636363636369,563.42156265987364,437.76,355.5,10521,929.64557838879136,2011,"World Bank, 2016",{"$f":"6.43*10.3","v":66.228999999999999},2013.3616,83.555555555555557,68,177.90254815490755,5490.9861818181816,228,186,485.18876769520239,9060.127199999999,376,306,800.56146669708392,"2019, urban","ILO",8484,352,287,749.6543187007419,13998.599999999999,580.79999999999995,473.54999999999995,1236.929625856224,2020,"GLWC",6852,284,231,{"$f":"AX34/BR34","v":605.44924466495559},11305.8,468.59999999999997,381.15,{"$f":"BB34/BR34","v":998.99125369717672},2020,"Calculated from  GLWC",{"$f":"(6304*G34)/E34","v":2311.4666666666662},96,78.222222222222229,204.24339570950903,{"$f":"6304*G34","v":10401.599999999999},432,352,919.09528069279065,"Honduran lempira","HNL",11.317216200000001]
["India","Urban","Tiruppur, Tamil Nadu","Living Wage Benchmark",4,2,1.58,2011,62,3.2,97.28,79,7099,336.87372000798894,246.27848101265823,200,17972.151898734177,852.84486077971883,389.12,316,28396,1347.4948800319557,2012,"World Bank, 2016",{"$f":"1.91*15.3","v":29.222999999999999},888.37919999999997,12.25,10,42.156867992917476,2249.0612658227847,31,25,106.72624808333539,3553.5167999999999,49,40,168.62747197166991,2019,"ILO",4757,65,53,225.7371863752646,7516.06,102.7,83.740000000000009,356.66475447291805,2019,"GLWC",15570,213,173,{"$f":"AX35/BR35","v":738.85389780594278},24600.600000000002,336.54,273.34000000000003,{"$f":"BB35/BR35","v":1167.3891585333897},2019,"Calculated from  GLWC",{"$f":"BL35/E35","v":5366},73.25,59.75,254.63648141468778,21464,293,239,1018.5459256587511,"Indian rupee","INR",21.0731784]
["India","Rural","Bhadohi, Uttar Pradesh","Living Wage Benchmark",5,2,1.546,2011,62,3.2,97.28,79,7099,336.87372000798894,314.61836998706337,255.4980595084088,22959.249676584735,1089.501034954686,486.4,395,35495,1684.3686000399446,2012,"World Bank, 2016",{"$f":"1.91*15.3","v":29.222999999999999},888.37919999999997,12.2,9.8000000000000007,42.156867992917476,2873.1539456662354,39,32,136.34174641952612,4441.8959999999997,61,49,210.78433996458739,2019,"ILO",4757,65,53,225.7371863752646,7354.3220000000001,100.49000000000001,81.938000000000002,348.98969013615908,2019,"GLWC",10627,145,118,{"$f":"AX36/BR36","v":504.29032575361293},16429.342000000001,224.17000000000002,182.428,{"$f":"BB36/BR36","v":779.63284361508568},2019,"Calculated from  GLWC",3285.6,44.8,36.4,155.91383215357774,16428,224,182,779.56916076788877,"Indian rupee","INR",21.0731784]
["India","Rural","Rural Nilgiris, Tamil Nadu","Living Wage Benchmark",4,2,1.73,2011,62,3.2,97.28,79,7099,336.87372000798894,224.92485549132948,182.65895953757226,16413.872832369943,778.8987745849455,389.12,316,28396,1347.4948800319557,2012,"World Bank, 2016",{"$f":"1.91*15.3","v":29.222999999999999},888.37919999999997,12.25,10,42.156867992917476,2054.0559537572253,28,23,97.472527151254283,3553.5167999999999,49,40,168.62747197166991,2019,"ILO",4757,65,53,225.7371863752646,8229.61,112.45,91.69,390.52533242920777,2020,"GLWC",12666,173,141,{"$f":"AX37/BR37","v":601.0483923962795},21912.18,299.29000000000002,243.93,{"$f":"BB37/BR37","v":1039.8137188455635},2020,"Calculated from  GLWC",4739.75,64.75,52.75,224.91861028424645,18959,259,211,899.67444113698582,"Indian rupee","INR",21.0731784]
["Kenya","Rural","Mount Kenya","Living Wage Benchmark",5.5,2,1.71,2015,67,3.2,97.28,79,10479,null,312.88888888888886,254.09356725146199,33704.385964912282,null,535.04,434.5,57634.5,null,2005,"World Bank, 2016",{"$f":"2.39*35.6","v":85.084000000000003},2586.5536000000002,24,19.454545454545453,null,8319.3244444444463,77,63,null,14226.044800000001,132,107,null,"2020, agriculture, unskilled worker","Wage Indicator",6736,62,51,null,11518.56,106.02,87.21,null,2016,"GLWC",13943,129,105,null,23842.53,220.59,179.54999999999998,null,2016,"Calculated from  GLWC",3995.818181818182,36.909090909090907,30,null,21977,203,165,null,"Kenyan shilling","KES"]
["Kenya","Non-metropolitan Urban","Lake Naivasha","Living Wage Benchmark",5,2,1.69,2015,67,3.2,97.28,79,10479,null,287.81065088757396,233.72781065088759,31002.958579881659,null,486.4,395,52395,null,2005,"World Bank, 2016",{"$f":"2.39*35.6","v":85.084000000000003},2586.5536000000002,24,19.399999999999999,null,7652.5254437869826,71,58,null,12932.768,120,97,null,"2019, urban","ILO",15125,140,114,null,25561.25,236.6,192.66,null,2019,"GLWC",26546,246,200,null,44862.74,415.74,338,null,2019,"Calculated from  GLWC",7924.4,73.400000000000006,59.8,null,39622,367,299,null,"Kenyan shilling","KES"]
["Madagascar","Rural",null,"Living Income Reference Value",5,2,1.78,2012,79,1.9,57.76,47,219919,{"$f":"M40/BR40","v":207.69266845513104},162.24719101123597,132.02247191011236,617750,{"$f":"Q40/BR40","v":583.40637206497479},288.8,235,1099595,{"$f":"U40/BR40","v":1038.4633422756551},2010,"World Bank, 2016",{"$f":"1.62*700.2","v":1134.3240000000001},34483.4496,9,7.4,{"$f":"Z40/BR40","v":32.566352452321176},96863.622471910101,26,21,{"$f":"AD40/BR40","v":91.478518124497683},172417.24799999999,45,37,{"$f":"AH40/BR40","v":162.83176226160589},"2021, agriculture, lowest","Wage Indicator",170442,45,37,{"$f":"AN40/BR40","v":160.96632758801852},303386.76,80.099999999999994,65.86,{"$f":"AR40/BR40","v":286.52006310667298},null,null,null,null,null,null,null,null,null,null,2020,"GLWC",102538.6,27,22,{"$f":"BH40/BR40","v":96.837996960941538},512693,135,110,{"$f":"BL40/BR40","v":484.18998480470765},"Malagasy ariary","MGA",1058.86742]
["Malawi","Rural","Southern Region","Living Wage Benchmark",5,2,1.59,2016,69,1.9,57.76,47,44323,155.4078893288538,181.63522012578616,147.79874213836476,139380.50314465407,488.70405449325085,288.8,235,221615,777.03944664426899,2016,"The National Statistics Office of Malawi/ The World Bank",{"$f":"137425/365","v":376.50684931506851},11445.808219178081,15,12.8,40.131960765411016,35993.107607478247,47,38,126.20113448242458,57229.04109589041,75,64,200.65980382705507,2020,"Wage Indicator",35000,46,37,122.71904263046009,55650,73.14,58.830000000000005,195.12327778243156,2019,"GLWC",101361,133,108,{"$f":"AX41/BR41","v":355.3978537161733},{"$f":"AX41*G41","v":161163.99000000002},{"$f":"AY41*G41","v":211.47},{"$f":"AZ41*G41","v":171.72},{"$f":"BB41/BR41","v":565.08258740871565},2019,"Calculated from  GLWC",27092.2,{"$f":"BM41/E41","v":35.4},28.8,94.992252764370022,135461,177,144,474.96126382185014,"Malawi kwacha","MWK",285.20431100000002]
["Mexico","Non-metropolitan Urban & Rural","Michoacán, northwestern regions","Living Wage Benchmark",4,2,1.63,2018,23,5.5,167.2,136,3314,319.79792322418069,410.30674846625766,333.74233128834356,8132.5153374233132,784.78017969124096,668.8,544,13256,1279.1916928967228,2021,"Conseja Nacional de Evaluación de la Politíca de Desarolla Social",{"$f":"Z42/30.4","v":71.28289473684211},2167,109.25,89,209.11348811913084,5317.7914110429456,268,218,513.16193403467696,8668,437,356,836.45395247652334,"2019, urban","ILO",2759,139,113,266.24093849593078,4497.17,226.57,184.19,433.97272974836716,2020,"GLWC",11782,594,484,{"$f":"AX42/BR42","v":1136.9520613842176},{"$f":"AX42*G42","v":19204.66},{"$f":"AY42*G42","v":968.21999999999991},{"$f":"AZ42*G42","v":788.92},{"$f":"BB42/BR42","v":1853.2318600562746},2020,"Calculated from  GLWC",4166,210,171,402.01513221241299,16664,840,684,1608.060528849652,"Mexican peso","MXN",10.362793999999999]
["Morocco","Rural",null,"Living Wage Reference Value",4.5,2,1.56,2013,7,3.2,97.28,79,863,205.43247737975375,280.61538461538458,227.88461538461539,2489.4230769230767,592.59368474928954,437.76,355.5,3883.5,924.44614820889183,2007,"World Bank, 2016",{"$f":"2.55*4.1","v":10.454999999999998},{"$f":"Y43*30.4","v":317.83199999999994},35.777777777777779,29.111111111111111,75.658186732980155,916.82307692307666,103,84,218.24476942205814,1430.2439999999997,161,131,340.46184029841072,"2021, agriculture","Wage Indicator",1904,214,174,453.23689099774174,2970.2400000000002,333.84000000000003,271.44,707.04954995647722,2020,"GLWC",2249,253,206,{"$f":"AX43/BR43","v":535.36227303252167},{"$f":"AX43*G43","v":3508.44},{"$f":"AY43*G43","v":394.68},{"$f":"AZ43*G43","v":321.36},{"$f":"BB43/BR43","v":835.16514593073373},2020,"Calculated from  GLWC",{"$f":"(2097*G43)/E43","v":726.96},81.777777777777771,66.666666666666671,173.04889195363359,{"$f":"2097*G43","v":3271.32},368,300,778.72001379135111,"Moroccan dirham","MAD",4.2008937]
["Mozambique","Rural",null,"Living Income Reference Value",5.5,2,1.71,2014,64,1.9,57.76,47,4331,192.35622208489175,185.77777777777777,151.16959064327486,13930.116959064328,618.68960319702023,317.68,258.5,23820.5,1057.9592214669046,2009,"World Bank, 2016",{"$f":"1.45*15.8","v":22.91},{"$f":"Y44*30.4","v":696.46399999999994},9.2727272727272734,7.6363636363636367,30.932621532701923,2240.088888888889,30,24,99.490887970678713,3830.5519999999997,51,42,170.12941842986058,"2021, agriculture","Wage Indicator",4390,59,48,194.97663702439962,7506.9,100.89,82.08,333.41004931172336,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",{"$f":"BL44/E44","v":1658.3636363636363},22.181818181818183,18,73.654251658709825,9121,122,99,405.09838412290406,"Mozambique Metical","MZN",22.515518100000001]
["Nicaragua","Urban","Managua Free Trade Zone","Living Wage Benchmark",4,2,1.68,2014,13,3.2,97.28,79,3378,276.34869904636793,231.61904761904762,188.0952380952381,8042.8571428571431,657.9730929675427,389.12,316,13512,1105.3947961854717,2016,"INIDE Instituto Nacional de información de Desarrollo",{"$f":"18311/365","v":50.167123287671231},{"$f":"Y45*30.4","v":1525.0805479452054},43.75,37.25,124.76436511710463,3631.1441617742985,104,85,297.05801218358243,6100.3221917808214,175,149,499.05746046841853,2019,"ILO",5919,170,138,484.22378616206385,9943.92,285.59999999999997,231.84,813.49596075226725,2019,"GLWC",12101,348,283,{"$f":"AX45/BR45","v":989.96317559505576},{"$f":"AX45*G45","v":20329.68},{"$f":"AY45*G45","v":584.64},{"$f":"AZ45*G45","v":475.44},{"$f":"BB45/BR45","v":1663.1381349996936},2019,"Calculated from  GLWC",4489.5,129,105,367.27871058871187,17958,516,420,1469.1148423548475,"Nicaraguan córdoba","NIO",12.223687]
["Nicaragua","Rural-Urban","Northwest","Living Wage Benchmark",4,2,1.62,2014,13,3.2,97.28,79,3378,276.34869904636793,240.19753086419752,195.06172839506172,8340.7407407407409,682.34246678115539,389.12,316,13512,1105.3947961854717,2016,"INIDE Instituto Nacional de información de Desarrollo",{"$f":"18311/365","v":50.167123287671231},{"$f":"Y46*30.4","v":1525.0805479452054},43.75,37.25,124.76436511710463,3765.6309825807539,108,88,308.06016078297438,6100.3221917808214,175,149,499.05746046841853,"2021, agriculture","Wage Indicator",4415,127,103,361.18398646823988,7152.3,205.74,166.86,585.11805807854864,2020,"GLWC",9900,284,231,{"$f":"AX46/BR46","v":809.90293681439982},{"$f":"AX46*G46","v":16038.000000000002},{"$f":"AY46*G46","v":460.08000000000004},{"$f":"AZ46*G46","v":374.22},{"$f":"BB46/BR46","v":1312.0427576393279},2020,"Calculated from  GLWC",3728.75,107,87.25,305.04298743905991,14915,428,349,1220.1719497562397,"Nicaraguan córdoba","NIO",12.223687]
["Nigeria","Rural",null,"Living Income Reference Value",5,2,1.71,2018,71,3.2,97.28,79,38168,284.39552568524954,284.44444444444446,230.99415204678363,111602.33918128654,831.56586457675303,486.4,395,190840,1421.9776284262477,2010,"World Bank, 2016",{"$f":"1.65*83.6","v":137.93999999999997},{"$f":"Y47*30.4","v":4193.3759999999993},10.6,8.6,31.245477151433366,12261.333333333332,31,25,91.361044302436753,20966.879999999997,53,43,156.22738575716684,2019,"Wage Indicator",30000,76,62,223.5345255333653,51300,129.96,106.02,382.24403866205466,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",27735.599999999999,70.400000000000006,57.4,206.66213954610686,138678,352,287,1033.3106977305345,"Nigerian naira","NGN",134.20745600000001]
["Pakistan","Rural","Sialkot","Living Wage Benchmark",5.5,2,1.647,2018,36,3.2,97.28,79,15501,418.46264985986119,324.85731633272616,263.81299332119005,51764.116575591986,1397.4162563626207,535.04,434.5,85255.5,2301.5445742292363,"2013/ 13","World Bank Group",{"$f":"Z48/30.4","v":99.671052631578945},3030,18.90909090909091,15.454545454545455,81.797421397031115,10118.397085610201,63,51,273.15471626209541,16665,104,85,449.88581768367118,2019,"ILO",18696,117,95,504.71438628346328,30792.312000000002,192.69900000000001,156.465,831.26459420886408,2019,"GLWC",21890,137,112,{"$f":"AX48/BR48","v":590.93912685841951},{"$f":"AX48*G48","v":36052.83},{"$f":"AY48*G48","v":225.63900000000001},{"$f":"AZ48*G48","v":184.464},{"$f":"BB48/BR48","v":973.27674193581697},2019,"Calculated from  GLWC",6555.090909090909,41.090909090909093,33.454545454545453,176.96024204183396,36053,226,184,973.28133123008672,"Pakistan rupee","PKR",37.0427325]
["Pakistan","Urban","Sialkot","Living Wage Benchmark",5,2,1.534,2018,36,3.2,97.28,79,15501,418.46264985986119,317.07953063885265,257.49674054758799,50524.771838331159,1363.9590934154537,486.4,395,77505,2092.3132492993059,"2013/14","World Bank Group",{"$f":"Z49/30.4","v":99.671052631578945},3030,19,15.4,81.797421397031115,9876.1408083441984,62,50,266.61480246750693,15150,95,77,408.98710698515561,2019,"ILO",18696,117,95,504.71438628346328,28679.664000000001,179.47800000000001,145.72999999999999,774.23186855883273,2019,"GLWC",25806,161,131,{"$f":"AX49/BR49","v":696.65487015570466},{"$f":"AX49*G49","v":39586.404000000002},{"$f":"AY49*G49","v":246.97400000000002},{"$f":"AZ49*G49","v":200.95400000000001},{"$f":"BB49/BR49","v":1068.6685708188509},2019,"Calculated from  GLWC",7949.8,49.8,40.6,214.61159756505543,39749,249,203,1073.0579878252772,"Pakistan rupee","PKR",37.0427325]
["Panama","Rural",null,"Living Wage Reference Value",4,2,1.68,2019,12,5.5,167.2,136,167,341.45865904809011,398.09523809523807,323.8095238095238,397.61904761904765,812.99680725735755,668.8,544,668,1365.8346361923604,2011,"World Bank, 2016",{"$f":"6.96*0.6","v":4.1760000000000002},{"$f":"Y50*30.4","v":126.9504},153.25,124.75,259.57073862047105,302.26285714285717,302,246,618.02556814397872,507.80160000000001,613,499,1038.2829544818842,2019,"ILO",458,458,373,936.45548409595983,769.43999999999994,769.43999999999994,626.64,1573.2452132812123,2020,"GLWC",569,569,463,{"$f":"AX50/BR50","v":1163.413035918343},{"$f":"AX50*G50","v":955.92},{"$f":"AY50*G50","v":955.92},{"$f":"AZ50*G50","v":777.83999999999992},{"$f":"BB50/BR50","v":1954.5339003428162},2020,"Calculated from  GLWC",{"$f":"(513*G50)/E50","v":215.45999999999998},215.5,175.5,440.54301005090713,{"$f":"513*G50","v":861.83999999999992},862,702,1762.1720402036285,"United States dollar","USD",0.48907824]
["Papua New Guinea","Rural",null,"Living Income Reference Value",5,2,1.67,2009,66,3.2,97.28,79,340,121.01928894767958,291.25748502994014,236.52694610778445,1017.9640718562874,362.33320044215441,486.4,395,1700,605.09644473839785,2010,"World Bank, 2016",{"$f":"1.92*2.1","v":4.032},{"$f":"Y51*30.4","v":122.5728},35,28.4,43.628450295076881,366.98443113772458,105,85,130.6241026798709,612.86400000000003,175,142,218.14225147538443,2016,"Wage Indicator",683,195,159,243.10639515077986,1140.6099999999999,325,265,405.98767990180232,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",{"$f":"BL51/E51","v":318.60000000000002},90.8,74,113.40219252567857,1593,454,370,567.0109626283928,"Papua New Guinean kina","PGK",2.8094694900000001]
["Peru","Rural",null,"LW & LI Reference Value",5,2,1.72,2019,21,5.5,167.2,136,604,321.48758051959845,486.04651162790697,395.34883720930236,1755.8139534883721,934.55692011511178,836,680,3020,1607.4379025979922,2018,"Instituto Nacional de Estadistica e Informatica",{"$f":"Z52/30.4","v":11.315789473684211},344,95.2,77.599999999999994,183.09888691844679,1000,277,226,532.26420615827556,1720,476,388,915.49443459223392,2018,"Wage Indicator",930,257,209,495.00571172719629,1599.6,{"$f":"AO52*G52","v":442.04},{"$f":"AP52*G52","v":359.48},851.40982417077748,2020,"GLWC",1582,438,357,{"$f":"AX52/BR52","v":842.04197414239195},{"$f":"AX52*G52","v":2721.04},{"$f":"AY52*G52","v":753.36},{"$f":"AZ52*G52","v":614.04},{"$f":"BB52/BR52","v":1448.3121955249142},2020,"GLWC",410,113.4,92.4,218.22832452489297,2050,567,462,1091.1416226244648,"Peruvian sol","PEN",1.8787662000000001]
["Rwanda","Rural",null,"LW & LI Reference Value",5,2,1.69,2016,57,1.9,57.76,47,56190,193.67798653316527,170.88757396449705,139.05325443786984,166242.60355029587,573.01179447682034,288.8,235,280950,968.38993266582634,2011,"World Bank, 2016",{"$f":"1.46*251","v":366.46},{"$f":"Y53*30.4","v":11140.383999999998},11.4,9.4,38.399130491658468,32959.715976331354,34,28,113.60689494573512,55701.919999999991,57,47,191.99565245829234,2019,"ILO",2906,3.4,2.7,10.016519467260691,4911.1399999999994,5.7459999999999996,4.5629999999999997,16.927917899670568,2020,"GLWC",147111,152,124,507.06820211568743,248617.59,256.88,209.56,856.94526157551172,2020,"GLWC",37526.6,38.799999999999997,31.6,129.34821728840504,187633,194,158,646.74108644202522,"Rwandan franc","RWF",290.12073600000002]
["South Africa","Rural","Western Cape Province","Living Wage Benchmark",4.5,2,1.64,2014,57,5.5,167.2,136,2448,358.26559882892576,458.78048780487808,373.17073170731709,6717.0731707317082,983.04585044522321,752.4,612,11016,1612.1951947301659,2019,"Department Statistics South Africa - Republic of South Africa",{"$f":"Z54/30.4","v":26.644736842105264},810,55.333333333333336,45.111111111111114,118.54376431839455,2222.560975609756,152,124,325.2725240443753,3645,249,203,533.44693943277548,2019,"ILO",3547,242,197,519.10460745351293,5817.08,396.88,323.08,851.33155622376125,2019,"GLWC",4280,292,238,626.37939664534406,7019.2,478.88,390.32,1027.2622104983643,2019,"Calculated from  GLWC",1544.4444444444443,105.33333333333333,85.777777777777771,226.02994842601979,6950,474,386,1017.1347679170891,"South African rand","ZAR",6.83291951]
["Sri Lanka","Rural","Estate Sector","Living Wage Benchmark",4.5,2,1.76,2016,11,3.2,97.28,79,18267,324.64858008615636,248.72727272727272,201.98863636363637,46705.397727272728,830.06739226574064,437.76,355.5,82201.5,1460.9186103877034,2016,"Department of Census and Statistics, Sri Lanka",{"$f":"Z55/30.4","v":137.03947368421052},4166,22.222222222222221,18,74.039852446429478,10651.704545454546,57,46,189.3064409141663,18747,100,81,333.17933600893264,2019,"ILO",13182,70,57,234.27588452924468,23200.32,123.2,100.32000000000001,412.32555677147064,2019,"GLWC",23785,126,103,422.71672838173913,41861.599999999999,221.76,181.28,743.9814419518608,2019,"Calculated from  GLWC",8412,44.666666666666664,36.444444444444443,149.501497546655,37854,201,164,672.7567389599476,"Sri Lankan rupee","LKR",56.2669949]
["Tanzania","Rural",null,"LW & LI Reference Value",5.5,null,1.73,2017,77,3.2,97.28,79,221787,286.27556844630095,309.27167630057801,251.15606936416185,705103.1791907514,910.12463956916486,535.04,434.5,1219828.5,1574.5156264546554,2012,"World Bank, 2016",{"$f":"1.44*588.8","v":847.87199999999996},{"$f":"Y56*30.4","v":25775.308799999999},11.272727272727273,9.0909090909090917,33.269944489978869,81944.623352601149,36,29,105.77149982363224,141764.19839999999,62,50,182.98469469488379,"2013, Agriculture","Wage Indicator",100000,44,36,129.07680271896052,173000,76.12,62.28,223.30286870380169,2020,"GLWC",317779,139,113,410.17897291228553,549757.67000000004,240.47,195.49,709.60962313825405,2020,"GLWC",83289.454545454544,36.363636363636367,29.636363636363637,107.50736492933466,458092,200,163,591.29050711134062,"Tanzanian shilling","TZS",774.73254599999996]
["Tanzania","Urban",null,"Living Wage Reference Value",5,null,1.69,2017,77,3.2,97.28,79,221787,286.27556844630095,287.81065088757396,233.72781065088759,656174.55621301779,846.96913741509161,486.4,395,1108935,1431.3778422315049,2012,"World Bank, 2016",{"$f":"1.44*588.8","v":847.87199999999996},{"$f":"Y57*30.4","v":25775.308799999999},11.2,9.1999999999999993,33.269944489978869,76258.310059171592,33,27,98.431788431890141,128876.54399999999,56,46,166.34972244989433,"2013, Agriculture","Wage Indicator",100000,44,36,129.07680271896052,169000,74.36,60.839999999999996,218.13979659504326,2020,"GLWC",425608,186,151,549.36119851611352,719277.52,314.33999999999997,255.19,928.42042549223186,2020,"Calculated from  GLWC",{"$f":"(361338*G57)/E57","v":122132.24399999999},53.4,43.4,157.6443956441195,{"$f":"361338*G57","v":610661.22},267,217,788.22197822059741,"Tanzanian shilling","TZS",774.73254599999996]
["Tunisia","Rural",null,"Living Wage Reference Value",4.5,2,1.46,2015,3,3.2,97.28,79,261,320.24100577368768,299.83561643835617,243.49315068493152,804.45205479452056,987.04419587780455,437.76,355.5,1174.5,1441.0845259815947,2010,"World Bank, 2016",{"$f":"3.97*0.7","v":2.7789999999999999},{"$f":"Y58*30.4","v":84.4816},31.111111111111111,25.333333333333332,103.65698296310488,260.38849315068495,97,79,319.49070091367946,380.16719999999998,140,114,466.45642333397194,"2021, non-agriculture, 48h/w","Wage Indicator",429,159,130,526.3731474211188,626.34,233,189,768.50479523483352,2020,"GLWC",695,258,210,852.74903836288479,1014.6999999999999,376.68,306.59999999999997,1245.0135960098119,2020,"Calculated from  GLWC",{"$f":"(663*G58)/E58","v":215.10666666666668},80,65.111111111111114,263.93093977761959,{"$f":"663*G58","v":967.98},360,293,1187.6892289992882,"Tunisian dinar","TND",0.81501117999999995]
["Turkey","Rural",null,"Living Income Reference Value",4,2,1.58,2019,10,5.5,167.2,136,1228,581.59084988988604,423.29113924050625,344.30379746835439,3108.8607594936707,1472.3818984554077,668.8,544,4912,2326.3633995595442,2011,"World Bank, 2016",{"$f":"2.82*1.1","v":3.1019999999999999},{"$f":"Y59*30.4","v":94.300799999999995},12.75,10.5,44.661630632977335,238.73620253164555,32,26,113.06741932399325,377.20319999999998,51,42,178.64652253190934,2021,"Wage Indicator",3578,487,397,1694.57008217102,5653.2400000000007,769,626,2677.4207298302117,null,null,null,null,null,null,null,null,null,null,2020,"GLWC",{"$f":"BL59/E59","v":887.75},120.75,98.25,420.44566530109637,3551,483,393,1681.7826612043855,"Turkish lira","TRY",2.11145]
["Uganda","Rural","Lake Victoria Basin","Living Wage Benchmark",5,2,1.78,2016,41,1.9,57.76,47,209859,169.79597847158618,162.24719101123597,132.02247191011236,589491.5730337078,476.95499570670268,288.8,235,1049295,848.97989235793091,null,"Uganda Bureau of Statistics",{"$f":"Z60/30.4","v":1006.9407894736843},30611,8.4,6.8,24.767223216510725,85985.955056179781,24,20,69.570851731771711,153055,42,34,123.83611608255363,2017,"Wage Indicator",130000,36,29,105.18241867780844,231400,{"$f":"AO60*G60","v":64.08},{"$f":"AP60*G60","v":51.62},187.22470524649904,2019,"GLWC",652311,180,147,{"$f":"AX60/BR60","v":527.78191315492234},{"$f":"AX60*G60","v":1161113.58},{"$f":"AY60*G60","v":320.39999999999998},{"$f":"AZ60*G60","v":261.66000000000003},{"$f":"BB60/BR60","v":939.45180541576178},2019,"Calculated from  GLWC",{"$f":"BL60/E60","v":197859.6},54.6,44.4,160.08731758941315,989298,273,222,800.43658794706562,"Ugandan shilling","UGX",1235.9480000000001]
["Vietnam","Rural","Economic Zone 4","Living Wage Benchmark",4,2,1.87,2018,7,3.2,97.28,79,2243610,281.59662314489509,208.08556149732618,168.98395721925132,4799165.7754010689,602.3457179569948,389.12,316,8974440,1126.3864925795804,"2016/ 20","ILO, rural ",{"$f":"Z61/30.4","v":23026.315789473687},700000,30.25,24.75,87.85735319481843,1497326.2032085562,65,53,187.9301672616437,2800000,121,99,351.42941277927372,"2021, region 4","Wage Indicator",3070000,133,108,385.31724901156082,5740900,{"$f":"AO61*G61","v":248.71},{"$f":"AP61*G61","v":201.96},720.54325565161878,2020,"GLWC",4618167,200,163,{"$f":"AX61/BR61","v":579.62847033093578},{"$f":"AX61*G61","v":8635972.290000001},{"$f":"AY61*G61","v":374},{"$f":"AZ61*G61","v":304.81},{"$f":"BB61/BR61","v":1083.9052395188501},2020,"Calculated from  GLWC",{"$f":"BL61/E61","v":1932298.5},83.5,68,242.52375970331124,7729194,334,272,970.09503881324497,"Vietnamese dong","VND",7967.4606000000003]
["Vietnam","Urban","Ho Chi Minh City","Living Wage Benchmark",4,2,1.78,2018,7,3.2,97.28,79,2243610,281.59662314489509,218.6067415730337,177.52808988764045,5041820.2247191006,632.80140032560689,389.12,316,8974440,1126.3864925795804,"2016/ 20","ILO, urban",{"$f":"Z62/30.4","v":29605.263157894737},900000,39,31.75,112.9594541076237,2022471.9101123596,87,71,253.84146990477234,3600000,156,127,451.8378164304948,"2021, region 1","Wage Indicator",4420000,191,156,554.75643017299637,7867600,{"$f":"AO62*G62","v":339.98},{"$f":"AP62*G62","v":277.68},987.46644570793353,2020,"GLWC",7446294,322,262,{"$f":"AX62/BR62","v":934.5881170720819},{"$f":"AX62*G62","v":13254403.32},{"$f":"AY62*G62","v":573.16},{"$f":"AZ62*G62","v":466.36},{"$f":"BB62/BR62","v":1663.5668483883057},2020,"Calculated from  GLWC",{"$f":"BL62/E62","v":2965673},128.25,104.5,372.22311460190963,11862692,513,418,1488.8924584076385,"Vietnamese dong","VND",7967.4606000000003]