{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Reference price essentials","Further resources","General data","Data entry (1)","Data entry (2)","Data entry (3)","Results (1)","Results (2)","Results (3)","hide_backend","hide_LW & Income Database","hide_FLIRP","hide_Suchtabellen"],"not_rendered":{"charts":5,"images":32,"macros":1,"external_links":0,"defined_names":11,"comments":4,"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":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,3,2,12],[3,3,3,12],[19,5,20,11],[21,5,22,11],[30,5,30,11],[18,5,18,11],[37,7,37,8],[28,5,28,11],[35,8,35,9],[29,5,29,11],[32,5,32,11],[31,5,31,10]]}
[]
[]
[null,null,null,"GIZ (Living Income) Reference Price Estimator"]
[null,null,null,"v1.0 (01.02.2022)"]
[]
[]
[null,null,"About this tool",null,"This tool allows calculating (Living Income) Reference Prices using available gross margin data"]
[null,null,null,null,"Two calculation methods are considered in this version (see 'reference price essentials')"]
[]
[null,null,"Data requirements",null,"Detailed information on revenues and costs of production of your product of interest "]
[]
[null,null,"How to use it",null,1,"accept macros for the estimation tool to function"]
[null,null,null,null,2,"it is recommended to read the 'reference price essentials'"]
[null,null,null,null,3,"go to 'general data' sheet  and define number of production scenarios to be compared"]
[null,null,null,null,4,"fill data entry form with detailed (aggregated) gross margin data"]
[null,null,null,null,null,"data entry cells can be identified by their green filling"]
[null,null,null,null,5,"go to results and explore the reference prices"]
[]
[null,null,"Notes",null,"-","results should be considered estimates "]
[null,null,"Notes",null,"-","a reference price is the farm gate price necessary for a producer to reach a given income benchmark, e.g. a living income benchmark or a poverty line"]
[]
[null,null,null,null,"-","if available, a Fairtrade Living Income Reference Price (FLIRP) serves as an internationally acknowledged reference price and should be referred to whenever possible"]
[]
[null,null,null,null,"-","consider the implication of different calculation methods (see reference price essentials)"]
[null,null,null,null,"-","consider the implication of different production scenarios (see reference price essentials)"]
[null,null,null,null,"-","benchmarks/poverty lines used are derived from https://align-tool.com/"]
[null,null,null,null,"-","if your country is not available use \"other country\" and define your own benchmark."]
[]
[null,null,"ATTENTION",null,"-","Results should be used as estimates"]
[null,null,null,null,"-","quality of the estimated reference prices significantly depends on data quality and reliability"]
[null,null,null,null,"-","complementary tools are being developed. Links will be included once available"]
[null,null,null,null,"-","it is recommended to validate and align price estimates with all relevant stakeholders and publicly availbale reference prices!"]
[]
[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,null,"Contact:",null,"ina@giz.de","nicola.nuecken@giz.de"]

{"sheet":"Reference price essentials","index":1,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[43,2,43,11],[67,2,69,11],[10,2,13,11],[15,2,17,11],[19,2,21,11],[23,2,24,11],[45,2,49,11]]}
[]
[]
[null,null,"Essentials of the practitioner guide"]
[null,null,"How to calculate (living income) reference prices for agricultural commodities"]
[null,null,"Loos, Krain, Veldhuyzen van Zanten and Petri (2021, under review) / LICOP"]
[]
[]
[null,null,"This sheet provides the essential information of the practitioner guide on \"How to calculate (living income) "]
[null,null,"reference prices\". The full document will be  available at ",null,null,null,null,"Living Income | Living Income Community of Practice (living-income.com)"]
[]
[null,null,"Calculating a reference price serves to estimate the farm gate price necessary for a producer to reach a given income benchmark, e.g. a living income benchmark or a poverty line. For example, when the target is to enable farmers to earn a living income under a certain production system, the required price for the commodity of interest is referred to as a living income reference price (LIRP)."]
[]
[]
[]
[]
[null,null,"The underlying logic is that a household depending on agricultural production must be able to generate enough revenue from agricultural activities, e.g. crop sales, to cover its respective production costs and, in addition, to meet the given (living income) benchmark. The underlying formula is as follows: (price * yield) - costs = benchmark"]
[]
[]
[]
[null,null,"Rural households usually have several sources of income where a focus commodity often contributes only a part to the overall household income. It cannot be expected that the sales of this commodity generate a full living income. This implies the need to adjust the base model."]
[]
[]
[]
[null,null,"The adjustment may either use the income contribution of the different income generating activities, or use the labour requirement of the different income generating activities. In practice, there are three approaches described in figure 1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Figure 1: Approaches to calculate reference prices (where RP = reference price, BM = benchmark, c = cost of production, Y = yield)"]
[]
[null,null,"The authors' preferred method for calculating reference prices are the labor method approaches. \nWhile the income benchmark is universal to the three calculation methods, the values for all other variables vary to a certain extent, depending on different assumptions regarding the production system. Regardless of the selected calculation method, the underlying scenario will lead to higher or lower reference prices. In practice there are three production system scenarios described in figure 2."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Figure 2: Potential production scenarios and data base for reference price calculation"]
[]
[null,null,"Independently calculated Living Income Reference Prices can serve as an important advocacy instrument to move a sector towards paying sustainable prices. In order to avoid unintended consequences, the price discovery model should be applied with caution and take into account:"]
[]
[]
[null,null,"   - data quality, reliability and representativity"]
[null,null,"   - available benchmarks"]
[null,null,"   - calculaion method"]
[null,null,"   - production scenario"]
[null,null,"   - alignment"]

{"sheet":"Further resources","index":2,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[33,2,34,11],[36,2,37,11],[25,2,26,11],[29,2,31,11],[19,2,19,11]]}
[]
[]
[null,null,"Further resources"]
[]
[]
[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,"Available at","https://doi.org/10.4337/9781786431462"]
[]
[null,null,"De Los Ríos, C. and Tyszler, M. (2020): Guidance on calculating household income. The Committee on Sustainability Assessment (COSA) and KIT Royal Tropical Institute."]
[null,null,"Available at","0c5ab3_5bfb3b8e694c45c290483b3e93043fd1.pdf (filesusr.com)"]
[]
[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,"Fairtrade Living Income Reference Price"]
[null,null,"Carla Veldhuyzen (2019): Fairtrade Living Income Reference Prices for Cocoa (Cote d'Ivoire and Ghana)"]
[null,null,"Available at","https://files.fairtrade.net/2019_RevisedExplanatoryNote_FairtradeLivingIncomeReferencePriceCocoa.pdf"]
[]
[null,null,"Carla Veldhuyzen (2021): Fairtrade Living Income Reference Prices for Coffee from Colombia"]
[null,null,"Available at","https://files.fairtrade.net/Fairtrade-Living-Income-Reference-Prices-for-Coffee-from-Colombia-2021_EN.pdf"]
[]
[null,null,"Carla Veldhuyzen (2021): Fairtrade Living Income Reference Prices for Vanilla (Madagascar and Uganda)"]
[null,null,"Available at","https://files.fairtrade.net/publications/Fairtrade_Vanilla_LivingIncomeReferencePrice_explanatorynote.pdf"]
[]
[null,null,"In Progress: ","Fairtrade Living Income Reference Price for Coffee in Indonesia and Ethiopia"]

{"sheet":"General data","index":3,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[20,8,20,9],[19,8,19,9],[12,8,12,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[14,8,15,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kommentare"]
[null,null,"General information and database specification",null,null,null,null,null,null,null,null,null,null,null,"Ab hier wird später gelöscht"]
[]
[]
[null,null,"Q1","Please provide information on the following key aspects"]
[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,"Other Country",null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[null,null,"b)","Select region or locality",null,null,null,null,null,null,{"$f":"HYPERLINK(\"#\"&ADDRESS(ROW(),COLUMN()-1),CHAR(128))","v":"€"}]
[null,null,"c)","Enter commodiy"]
[null,null,"d)","Select preferred currency",null,null,null,null,"EUR",null,"€"]
[]
[null,null,"Availability of  Fairtrade Living Income Reference Price",null,null,null,null,null,{"$f":"IFERROR(INDEX(tab_flirp_source[Text Ausgabe],MATCH('General data'!I10,tab_flirp_country[Country],0)), \"No FLIRP available\")","v":"No FLIRP available"}]
[null,null,"Note: see 'Further resources'"]
[]
[]
[]
[null,null,"Q2","You may define one additional benchmark or poverty line"]
[null,null,null,"Note: The unit of reporting must be",null,{"$f":"$I$13","v":"EUR"},"/HH  /year",null,"(user defined benchmark)"]
[]
[]
[]
[null,null,"Q3","Please select the number of different production systems or scenarios you want to compare"]
[null,null,null,"(for example: select 2 if you want to compare an average farming system and an improved farming system)"]
[null,null,null,"(for example: select 2 if you want to compare conventional and organic farming systems)"]
[null,null,null,"(for example: select 3 if you want to compare production in three different agro-ecological zones)"]
[]
[]
[]
[]
[null,null,null,"Note: The buttons will forward you to the corresponding data entry form!"]

{"sheet":"Data entry (1)","index":4,"n_rows":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[[19,2,30,2],[27,11,28,14],[24,4,28,9],[10,13,10,14],[11,13,11,14],[7,2,12,2],[7,13,7,14],[8,13,8,14],[9,13,9,14],[23,4,23,9],[13,13,13,14],[54,13,54,14],[34,2,44,2],[42,11,43,14],[53,2,57,2],[53,13,53,14],[39,4,43,9],[38,4,38,10],[66,2,72,2],[66,13,66,14],[67,13,67,14],[70,13,70,14],[71,13,71,14],[70,4,70,12],[71,4,71,12],[68,13,68,14],[69,13,69,14]]}
[]
[null,null,null,null,null,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,"Information for one (1) production system"]
[]
[]
[null,null,"Q1","Please specify the following general information"]
[null,null,"general information",null,null,null,null,null,null,null,null,null,null,"Unit",null,null,"System 1"]
[null,null,null,"a)","Please define your production system",null,null,null,null,null,null,null,null,"Text",null,null,"Name of prod. System 1"]
[null,null,null,"b)","average household size",null,null,null,null,null,null,null,null,"N"]
[null,null,null,"c)","average number of adult household members",null,null,null,null,null,null,null,null,"N"]
[null,null,null,"d)","total household labor capacity of an average household ",null,null,null,null,null,null,null,null,"workforce",null,null,null,null,"i"]
[null,null,null,"e)","total number of working days per year for one worker ",null,null,null,null,null,null,null,null,"days","/ year"]
[null,null,null,"f)","total number of ha used on average for primary crop ",null,null,null,null,null,null,null,null,"ha",null,null,null,null,"i"]
[]
[]
[]
[null,null,"Q2","Please specify key information for calculation methods (see 'Practitioner guide essentials')"]
[]
[null,null,"calculation method 1\nincome share","a)","Calculation using income shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify income share of main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"}]
[null,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,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,"Primary  cash crop income",null,null,null,null,"%"]
[]
[]
[]
[]
[]
[]
[null,null,"calculation method 2\nlabor share","b)","Calculation using labor shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify total number of labordays spent on main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"}]
[null,null,null,null,"Note: Consider total labor days of family members for one hectare during the past season [/ha /year]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,null,null,null,null,null,null,null,null,null,null,"Primary cash crop workload",null,null,null,null,"labordays /ha /yr"]
[]
[]
[]
[]
[]
[null,null,"Q3","Please provide key information for revenue of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"revenue","What were the yield and achieved commodity prices?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"}]
[null,null,null,"a)","reference land size",null,null,null,null,null,null,null,null,"ha",null,null,1]
[null,null,null,"b)",{"$f":"\"average yield per year per \" & N55","v":"average yield per year per ha"},null,null,null,null,null,null,null,null,"kg","/ yr"]
[null,null,null,"c)",{"$f":"\"average price received per \" & N56","v":"average price received per kg"},null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":"\"/ \"&N56","v":"/ kg"}]
[null,null,null,"Revenue per reference land size ",null,null,null,null,null,null,null,null,null,{"$f":"N57","v":"EUR"},{"$f":"\"/ \"&N55","v":"/ ha"},null,{"$f":"Q56*Q57","v":0}]
[]
[]
[]
[null,null,"Q4","Please provide key information for production costs of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"production costs","What were the total costs for key means of production?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"}]
[null,null,null,"a)","inputs   (e.g. fertilizer, pesticides, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"b)","services  (e.g. tractor services, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"c)","hired labor",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"d)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"e)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"Total production costs per reference land size",null,null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":" \"/ \" &'Data entry (3)'!N55","v":"/ ha"},null,{"$f":"SUM(Q68:Q72)","v":0}]

{"sheet":"Data entry (2)","index":5,"n_rows":73,"n_cols":25,"rows_kept":73,"cut":false,"hidden":true,"merged":[[27,11,28,14],[24,4,28,9],[39,4,43,9],[38,4,38,10],[7,2,12,2],[7,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[13,13,13,14],[34,2,44,2],[42,11,43,14],[19,2,30,2],[66,2,72,2],[66,13,66,14],[67,13,67,14],[70,13,70,14],[54,13,54,14],[68,13,68,14],[71,13,71,14],[69,13,69,14],[70,4,70,12],[71,4,71,12],[53,2,57,2],[53,13,53,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"delete from here to end"]
[null,null,"Data entry form"]
[null,null,"Information for two (2) production systems"]
[]
[]
[null,null,"Q1","Please specify the following general information"]
[null,null,"general information",null,null,null,null,null,null,null,null,null,null,"Unit",null,null,"System 1",null,null,null,"System 2"]
[null,null,null,"a)","Please define your production system",null,null,null,null,null,null,null,null,"Text",null,null,"Name of prod. System 1",null,null,null,"Name of prod. System 2"]
[null,null,null,"b)","average household size",null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,{"$f":"Q10","v":0}]
[null,null,null,"c)","average number of adult household members",null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,{"$f":"Q11","v":0}]
[null,null,null,"d)","total household labor capacity of an average household",null,null,null,null,null,null,null,null,"workforce",null,null,null,null,null,null,{"$f":"Q12","v":0},null,"i"]
[null,null,null,"e)","total number of working days per year for one worker",null,null,null,null,null,null,null,null,"days","/ year"]
[null,null,null,"f)","total number of ha used on average for primary crop ",null,null,null,null,null,null,null,null,"ha",null,null,null,null,null,null,null,null,"i"]
[]
[]
[]
[null,null,"Q2","Please specify key information for calculation methods (see 'Practitioner guide essentials')"]
[]
[null,null,"calculation method 1\nincome share","a)","Calculation using income shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify income share of main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"}]
[null,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,null,null,null,null,null,null,null,null,null,46.8,null,null,null,46.8]
[null,null,null,null,null,null,null,null,null,null,null,"Primary  cash crop income",null,null,null,null,"%",null,null,null,"%"]
[]
[]
[]
[]
[]
[]
[null,null,"calculation method 2\nlabor share","b)","Calculation using labor shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify total number of labordays spent on main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"}]
[null,null,null,null,"Note: Consider total labordays of family members for one hectare during the past season [/ha /year]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,null,null,null,null,null,null,null,null,null,null,"Primary cash crop workload",null,null,null,null,"labordays /ha /yr",null,null,null,"labordays /ha /yr"]
[]
[]
[]
[]
[]
[null,null,"Q3","Please provide key information for revenue of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"revenue","What were the yield and achieved commodity prices?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"}]
[null,null,null,"a)","reference land size",null,null,null,null,null,null,null,null,"ha",null,null,1,null,null,null,1,null,null,null,"ggf ha als dropdown und Eingabe flexibel (perspektivisch)"]
[null,null,null,"b)",{"$f":"\"average yield per year per \" & N55","v":"average yield per year per ha"},null,null,null,null,null,null,null,null,"kg","/ yr",null,null,null,null,null,null,null,null,null,"ggf unit als dropdown (perspektivisch"]
[null,null,null,"c)",{"$f":"\"average price received per \" & N56","v":"average price received per kg"},null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":"\"/ \"&N56","v":"/ kg"}]
[null,null,null,"Revenue per reference land size ",null,null,null,null,null,null,null,null,null,{"$f":"N57","v":"EUR"},{"$f":"\"/ \"&N55","v":"/ ha"},null,{"$f":"Q56*Q57","v":0},null,null,null,{"$f":"U56*U57","v":0}]
[]
[]
[]
[null,null,"Q4","Please provide key information for production costs of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"production costs","What were the total costs for key means of production?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"}]
[null,null,null,"a)","inputs   (e.g. fertilizer, pesticides, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"b)","services (e.g. tractor services, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"c)","hired labor",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"d)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"e)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"Total production costs per reference land size",null,null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":" \"/ \" &'Data entry (3)'!N55","v":"/ ha"},null,{"$f":"SUM(Q68:Q72)","v":0},null,null,null,{"$f":"SUM(U68:U72)","v":0}]

{"sheet":"Data entry (3)","index":6,"n_rows":73,"n_cols":29,"rows_kept":73,"cut":false,"hidden":true,"merged":[[7,2,12,2],[53,2,57,2],[66,2,72,2],[19,2,30,2],[34,2,44,2],[23,16,23,17],[7,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[13,13,13,14],[24,4,29,9],[38,4,38,10],[39,4,44,9],[53,13,53,14],[54,13,54,14],[27,11,28,14],[71,13,71,14],[70,4,70,12],[71,4,71,12],[42,11,43,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[69,13,69,14],[70,13,70,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Information for three (3) production systems"]
[]
[]
[null,null,"Q1","Please specify the following general information"]
[null,null,"general information",null,null,null,null,null,null,null,null,null,null,"Unit",null,null,"System 1",null,null,null,"System 2",null,null,null,"System 3"]
[null,null,null,"a)","Please define your production system",null,null,null,null,null,null,null,null,"Text",null,null,"Name of prod. System 1",null,null,null,"Name of prod. System 2",null,null,null,"Name of prod. System 3"]
[null,null,null,"b)","average household size",null,null,null,null,null,null,null,null,"N"]
[null,null,null,"c)","average number of adult household members",null,null,null,null,null,null,null,null,"N"]
[null,null,null,"d)","total household labor capacity of an average household 1",null,null,null,null,null,null,null,null,"workforce",null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,null,null,"e)","total number of working days per year for one worker 2",null,null,null,null,null,null,null,null,"days","/ year"]
[null,null,null,"f)","total number of ha used on average for primary crop ",null,null,null,null,null,null,null,null,"ha",null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[]
[]
[]
[null,null,"Q2","Please specify key information for calculation methods (see 'Practitioner guide essentials')"]
[]
[null,null,"calculation method 1\nincome share","a)","Calculation using income shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify income share of main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"},null,null,null,{"$f":"$Y$9","v":"Name of prod. System 3"}]
[null,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,null,null,null,null,null,null,null,null,null,40,null,null,null,40,null,null,null,40]
[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,"calculation method 2\nlabor share","b)","Calculation using labor shares"]
[null,null,null,null,"Note: see 'reference price essentials'"]
[]
[]
[null,null,null,null,"Please specify total number of labordays spent on main product (e.g. cash crop)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"},null,null,null,{"$f":"$Y$9","v":"Name of prod. System 3"}]
[null,null,null,null,"Note: Consider total labordays of family members for one hectare during the past season [/ha /year]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,null,null,null,null,null,null,null,null,null,null,"Primary cash crop workload",null,null,null,null,"labordays /ha /yr",null,null,null,"labordays /ha /yr",null,null,null,"labordays /ha /yr"]
[]
[]
[]
[]
[]
[null,null,"Q3","Please provide key information for revenue of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"revenue","What were the yield and achieved commodity prices?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"},null,null,null,{"$f":"$Y$9","v":"Name of prod. System 3"}]
[null,null,null,"a)","reference land size",null,null,null,null,null,null,null,null,"ha",null,null,1,null,null,null,1,null,null,null,1,null,null,null,"ggf ha als dropdown und Eingabe flexibel (perspektivisch)"]
[null,null,null,"b)",{"$f":"\"average yield per year per \" & N55","v":"average yield per year per ha"},null,null,null,null,null,null,null,null,"kg","/ yr",null,null,null,null,null,null,null,null,null,null,null,null,null,"ggf unit als dropdown (perspektivisch"]
[null,null,null,"c)",{"$f":"\"average price received per \" & N56","v":"average price received per kg"},null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":"\"/ \"&N56","v":"/ kg"}]
[null,null,null,"Revenue per reference land size ",null,null,null,null,null,null,null,null,null,{"$f":"N57","v":"EUR"},{"$f":"\"/ \"&N55","v":"/ ha"},null,{"$f":"Q56*Q57","v":0},null,null,null,{"$f":"U56*U57","v":0},null,null,null,{"$f":"Y56*Y57","v":0}]
[]
[]
[]
[null,null,"Q4","Please provide key information for production costs of main product (e.g. cash crop)"]
[null,null,null,"Note: ",null,"The reference land size is 1 hectare, i.e. information must be provided per ha [/ha]"]
[null,null,null,null,null,"The reference time periode is the past production cycle, i.e. the past 12 months [/yr]"]
[]
[]
[null,null,"production costs","What were the total costs for key means of production?",null,null,null,null,null,null,null,null,null,"Unit",null,null,{"$f":"$Q$9","v":"Name of prod. System 1"},null,null,null,{"$f":"$U$9","v":"Name of prod. System 2"},null,null,null,{"$f":"$Y$9","v":"Name of prod. System 3"}]
[null,null,null,"a)","inputs   (e.g. fertilizer, pesticides, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"b)","services  (e.g. tractor services, etc.)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"c)","hired labor",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"d)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"e)","enter other costs (e.g. environmental costs)",null,null,null,null,null,null,null,null,{"$f":"'General data'!$I$13","v":"EUR"}]
[null,null,null,"Total production costs per reference land size",null,null,null,null,null,null,null,null,null,{"$f":"'General data'!I13","v":"EUR"},{"$f":" \"/ \" &'Data entry (3)'!N55","v":"/ ha"},null,{"$f":"SUM(Q68:R72)","v":0},null,null,null,{"$f":"SUM(U68:V72)","v":0},null,null,null,{"$f":"SUM(Y68:Z72)","v":0}]

{"sheet":"Results (1)","index":7,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":true,"merged":[[65,1,72,12],[5,9,5,10],[6,9,6,11],[2,1,2,12],[4,9,4,11],[28,1,31,12],[8,9,8,10],[11,9,11,10],[14,9,14,10],[17,9,17,10],[20,9,20,10],[23,9,23,10]]}
[]
[]
[null,"Reference Price to [Benchmark/ poverty line]"]
[]
[null,null,"Reference price in order to achieve:","Method 1\nIncome Share",null,"Method 2\nLabor Share",null,"Unit",null,"Benchmark per HH per year *"]
[null,null,null,null,null,null,null,null,null,"Household with a laborforce of",null,{"$f":"'Data entry (1)'!Q12","v":0}]
[null,null,"Current Price",{"$f":"'Data entry (1)'!$Q$57","v":0},null,{"$f":"'Data entry (1)'!$Q$57","v":0},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"}]
[]
[null,null,"World Bank Poverty Line",{"$f":"IFERROR(hide_backend!G6,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I6,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!K6,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D9/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F9/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,"National Poverty Line",{"$f":"IFERROR(hide_backend!G7,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I7,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!K7,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D12/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F12/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,"National Minimum Wage",{"$f":"IFERROR(hide_backend!G8, \"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I8,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!K8,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D15/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F15/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,"Living Wage",{"$f":"IFERROR(hide_backend!G9,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I9,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!K9,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D18/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F18/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,"Living Income",{"$f":"IFERROR(hide_backend!G10,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I10,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!K10,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D21/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F21/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,"User defined Benchmark",{"$f":"IFERROR(hide_backend!G11,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!I11,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"hide_backend!K11","v":"No benchmark selected"},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,{"$f":"IFERROR((D24/$D$7-1),\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR((F24/$F$7-1),\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[]
[]
[null,"ATTENTION: Values are based on your entered data. The benchmarks given are adjusted to household data entered by individual user.  Values are converted using the IMF's yearly average exchange rates. \n It is recommended to validate and align price estimates with all relevant stakeholders! Results should be considered estimates!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linie durchziehen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print anpassen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* International Poverty Lines are retrieved from the World Bank (WB) and set using 2011 prices. They differ per country according to income group.\nNational Poverty Lines are retrieved from official governmental sources that differ per country and substituted by World Bank data.\nNational Minimum Wages are retrieved from the International Labor Organisation and substituted by Wage Indicator data. \nLiving Wage information comes from the Global Living Wage Coalition. Please not that gross income is used. \nLiving Income information is retrived from studies by LICOP and substituted with cost of living data from living wage studies to provide estimates. Please note that net income is used.\nFor more information on the BMs please refer to the ALIGN Website.\nThe BMs given are adjusted to household data entered by individual user. This may lead to different values than inidcated in the ALIGN Database source. Reference prices are based on calculated BMs."]

{"sheet":"Results (2)","index":8,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":true,"merged":[[34,10,34,11],[1,2,1,13],[3,10,3,12],[4,10,4,11],[5,10,5,12],[7,10,7,11],[10,10,10,11],[13,10,13,11],[16,10,16,11],[19,10,19,11],[22,10,22,11],[53,1,55,23],[50,1,51,12],[50,13,51,13],[43,10,43,11],[46,10,46,11],[37,10,37,11],[1,1,24,1],[26,1,48,1],[40,10,40,11],[27,10,27,12],[28,10,28,11],[29,10,29,12],[31,10,31,11]]}
[]
[null,"Method 1: Income Share","Reference Price to [Benchmark/poverty line]"]
[]
[null,null,null,"Reference price in order to achieve:",{"$f":"'Data entry (2)'!$Q$9","v":"Name of prod. System 1"},null,{"$f":"'Data entry (2)'!$U$9","v":"Name of prod. System 2"},null,"Unit",null,"Benchmark per HH per year *"]
[null,null,null,null,null,null,null,null,null,null,"Household with a laborforce of",null,{"$f":"'Data entry (2)'!Q12","v":0}]
[null,null,null,"Current Price",{"$f":"'Data entry (2)'!$Q$57","v":0},null,{"$f":"'Data entry (2)'!$U$57","v":0},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"}]
[]
[null,null,null,"World Bank Poverty Line",{"$f":"IFERROR(hide_backend!$H$18,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$27,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$18,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$18,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$27,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Poverty Line",{"$f":"IFERROR(hide_backend!$H$19,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$28,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$19,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$19,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$28,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Minimum Wage",{"$f":"IFERROR(hide_backend!$H$20,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$29,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$20,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$20,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$29,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Wage",{"$f":"IFERROR(hide_backend!$H$21,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$30,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$21,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$21,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$30,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Income",{"$f":"IFERROR(hide_backend!$H$22,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$31,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$22,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$22,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$31,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"User defined Benchmark",{"$f":"IFERROR(hide_backend!$H$23,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$32,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"hide_backend!$L$23","v":"No benchmark selected"},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$23,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$32,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[]
[null,"Method 2: Labor Share"]
[null,null,null,"Reference price in order to achieve:",{"$f":"'Data entry (2)'!$Q$9","v":"Name of prod. System 1"},null,{"$f":"'Data entry (2)'!$U$9","v":"Name of prod. System 2"},null,"Unit",null,"Benchmark per HH per year *"]
[null,null,null,null,null,null,null,null,null,null,"Household with a laborforce of",null,{"$f":"'Data entry (2)'!Q12","v":0}]
[null,null,null,"Current Price",{"$f":"'Data entry (2)'!$Q$57","v":0},null,{"$f":"'Data entry (2)'!$U$57","v":0},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"}]
[]
[null,null,null,"World Bank Poverty Line",{"$f":"IFERROR(hide_backend!$J$18,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$27,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$18,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$18,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$27,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Poverty Line",{"$f":"IFERROR(hide_backend!$J$19,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$28,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$19,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$19,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$28,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Minimum Wage",{"$f":"IFERROR(hide_backend!$J$20,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$29,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$20,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$20,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$29,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Wage",{"$f":"IFERROR(hide_backend!$J$21,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$30,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$21,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$21,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$30,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Income",{"$f":"IFERROR(hide_backend!$J$22,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$31,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!$L$22,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$22,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$31,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"User defined Benchmark",{"$f":"IFERROR(hide_backend!$J$23,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$32,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"hide_backend!$L$23","v":"No benchmark selected"},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$23,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$32,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[]
[null,"ATTENTION: Values are based on your entered data. The benchmarks given are adjusted to household data entered by individual user.  Values are converted using the IMF's yearly average exchange rates. \n It is recommended to validate and align price estimates with all relevant stakeholders! Results should be considered estimates!"]
[]
[]
[null,"* International Poverty Lines are retrieved from the World Bank (WB) and set using 2011 prices. They differ per country according to income group.\nNational Poverty Lines are retrieved from official governmental sources that differ per country and substituted by World Bank data.\nNational Minimum Wages are retrieved from the International Labor Organisation and substituted by Wage Indicator data. \nLiving Wage information comes from the Global Living Wage Coalition. Please not that gross income is used. \nLiving Income information is retrived from studies by LICOP and substituted with cost of living data from living wage studies to provide estimates. Please note that net income is used.\nFor more information on the BMs please refer to the ALIGN Website.\nBMs given are adjusted to household data entered by individual user. This may lead to different values than inidcated in the ALIGN Database source. Reference prices are based on calculated BMs."]

{"sheet":"Results (3)","index":9,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":true,"merged":[[4,12,4,13],[19,12,19,13],[5,12,5,14],[7,12,7,13],[10,12,10,13],[13,12,13,13],[16,12,16,13],[52,1,54,25],[46,12,46,13],[50,1,50,15],[22,12,22,13],[26,1,48,1],[27,12,27,14],[28,12,28,13],[29,12,29,14],[31,12,31,13],[34,12,34,13],[37,12,37,13],[40,12,40,13],[43,12,43,13],[1,1,24,1],[1,2,1,15],[3,12,3,14]]}
[]
[null,"Method 1: Income Share","Reference Price to [Benchmark/poverty line]"]
[]
[null,null,null,"Reference price in order to achieve:",{"$f":"'Data entry (3)'!Q9","v":"Name of prod. System 1"},null,{"$f":"'Data entry (3)'!U9","v":"Name of prod. System 2"},null,{"$f":"'Data entry (3)'!Y9","v":"Name of prod. System 3"},null,"Unit",null,"Benchmark per HH per year *"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Household with a laborforce of",null,{"$f":"'Data entry (3)'!Q12","v":0}]
[null,null,null,"Current Price",{"$f":"hide_backend!G39","v":0},null,{"$f":"hide_backend!G48","v":0},null,{"$f":"hide_backend!G57","v":0},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"}]
[]
[null,null,null,"World Bank Poverty Line",{"$f":"IFERROR(hide_backend!$H$39,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$48,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$57,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!L39,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$39,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$48,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$57,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Poverty Line",{"$f":"IFERROR(hide_backend!$H$40,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$49,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$58,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!L40,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$40,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$49,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$58,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Minimum Wage",{"$f":"IFERROR(hide_backend!$H$41,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$50,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$59,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!L41,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$41,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$50,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$59,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Wage",{"$f":"IFERROR(hide_backend!$H$42,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$51,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$60,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!L42,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$42,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$51,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$60,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Income",{"$f":"IFERROR(hide_backend!$H$43,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$52,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$61,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"IFERROR(hide_backend!L43,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$43,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$52,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$61,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"User defined Benchmark",{"$f":"IFERROR(hide_backend!$H$44,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$53,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$H$62,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"hide_backend!L44","v":"No benchmark selected"},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$I$44,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$53,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$I$62,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[]
[null,"Method 2: Labor Share"]
[null,null,null,"Reference price in order to achieve:",{"$f":"'Data entry (3)'!Q9","v":"Name of prod. System 1"},null,{"$f":"'Data entry (3)'!U9","v":"Name of prod. System 2"},null,{"$f":"'Data entry (3)'!Y9","v":"Name of prod. System 3"},null,"Unit",null,"Benchmark per HH per year *"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Household with a laborforce of",null,{"$f":"'Data entry (3)'!Q12","v":0}]
[null,null,null,"Current Price",{"$f":"hide_backend!G39","v":0},null,{"$f":"hide_backend!G48","v":0},null,{"$f":"hide_backend!G57","v":0},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"}]
[]
[null,null,null,"World Bank Poverty Line",{"$f":"IFERROR(hide_backend!$J$39,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$48,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$57,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M8","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$39,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$48,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$57,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Poverty Line",{"$f":"IFERROR(hide_backend!$J$40,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$49,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$58,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M11","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$40,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$49,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$58,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"National Minimum Wage",{"$f":"IFERROR(hide_backend!$J$41,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$50,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$59,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M14","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$41,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$50,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$59,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Wage",{"$f":"IFERROR(hide_backend!$J$42,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$51,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$60,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M17","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$42,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$51,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$60,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"Living Income",{"$f":"IFERROR(hide_backend!$J$43,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$52,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$61,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M20","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$43,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$52,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$61,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[null,null,null,"User defined Benchmark",{"$f":"IFERROR(hide_backend!$J$44,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$53,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$J$62,\"n.a.\")","v":"n.a."},null,{"$f":"'General data'!$I$13&\" /kg\"","v":"EUR /kg"},null,{"$f":"M23","v":"No benchmark selected"},null,{"$f":"'General data'!$I$13&\" /HH /y\"","v":"EUR /HH /y"}]
[null,null,null,null,{"$f":"IFERROR(hide_backend!$K$44,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$53,\"n.a.\")","v":"n.a."},null,{"$f":"IFERROR(hide_backend!$K$62,\"n.a.\")","v":"n.a."},null,"%-difference"]
[]
[]
[null,"ATTENTION: Values are based on your entered data. Benchmarks are adjusted to household data given by individual user. Results should be considered estimates! It is recommended to validate and align price estimates with all relevant stakeholders! Daten werden mit jährlichen Währungsdurchnitsswerten verrechnet. Hierdurch kann es zu Abweichungen in den Daten kommen."]
[]
[null,"* International Poverty Lines are retrieved from the World Bank (WB) and set using 2011 prices. They differ per country according to income group.\nNational Poverty Lines are retrieved from official governmental sources that differ per country and substituted by World Bank data.\nNational Minimum Wages are retrieved from the International Labor Organisation and substituted by Wage Indicator data. \nLiving Wage information comes from the Global Living Wage Coalition. Please not that gross income is used. \nLiving Income information is retrived from studies by LICOP and substituted with cost of living data from living wage studies to provide estimates. Please note that net income is used.\nFor more information on the BMs please refer to the ALIGN Website.\nBMs given are adjusted to household data entered by individual user. This may lead to different values than inidcated in the ALIGN Database source. Reference prices are based on calculated BMs."]

{"sheet":"hide_backend","index":10,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":true,"merged":[[1,2,1,11],[2,5,2,9],[2,10,2,11],[3,6,3,7],[3,8,3,9],[4,3,4,4],[15,2,21,2],[15,7,15,8],[15,9,15,10],[15,11,15,12],[16,4,16,5],[14,3,14,12],[24,2,30,2],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,4,25,5],[35,3,35,13],[36,2,42,2],[36,7,36,8],[36,9,36,10],[36,11,36,12],[37,4,37,5],[45,2,51,2],[45,7,45,8],[45,9,45,10],[45,11,45,12],[46,4,46,5],[54,2,60,2],[54,7,54,8],[54,9,54,10],[54,11,54,12],[55,4,55,5]]}
[null,"Results 1"]
[null,null,"Results "]
[null,null,null,null,null,{"$f":"'Data entry (1)'!Q9","v":"Name of prod. System 1"},null,null,null,null,"Benchmark"]
[null,null,null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,null,null,"Av. Household size"]
[null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (1)'!Q12","v":0},{"$f":"'Data entry (1)'!Q10","v":0}]
[null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K6/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$f":"G6/F6-1","v":{"$error":"#N/A"}},{"$f":"((K6*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$f":"I6/F6-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*M5=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*M5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Originalzahlen gecheckt: Int. Pov line per person per month * 12 * av. Size of household"]
[null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K7/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$f":"G7/F7-1","v":{"$error":"#N/A"}},{"$f":"((K7*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$f":"I7/F7-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*M5*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*M5*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Originalzahlen gecheckt: Nat. Pov line per month * 12 * av. Size of household"]
[null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K8/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((K8*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*L5*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*L5*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Originalzahlen gecheckt: Min. Wage per Workforce per month* 12 * av. Laborforce"]
[null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K9/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((K9*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*L5*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*L5*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Originalzahlen gecheckt: LW per workforce per month * 12 * av. Laborforce"]
[null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K10/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((K10*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*M5*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*M5*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,"Originalzahlen gecheckt: LI per person per month * 12 * av. Size of household"]
[null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (1)'!$Q$57","v":0},{"$f":"((K11/'Data entry (1)'!Q14*'Data entry (1)'!Q27/100)+('Data entry (1)'!Q73))/'Data entry (1)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((K11*'Data entry (1)'!Q42/('Data entry (1)'!Q12*'Data entry (1)'!Q13))+'Data entry (1)'!Q73)/'Data entry (1)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"},"No benchmark selected"]
[]
[]
[]
[null,"Results 2",null,"Results "]
[null,null,{"$f":"'Data entry (2)'!$Q$9","v":"Name of prod. System 1"},null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,"Benchmark",null,"Av. Household size"]
[null,null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (2)'!Q12","v":0},{"$f":"'Data entry (2)'!Q10","v":0}]
[null,null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L18/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$f":"H18/G18-1","v":{"$error":"#N/A"}},{"$f":"((L18*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$f":"J18/G18-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N17=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N17)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L19/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$f":"H19/G19-1","v":{"$error":"#N/A"}},{"$f":"((L19*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N17*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N17*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L20/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L20*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M17*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M17*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L21/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L21*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M17*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M17*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L22/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L22*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N17*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N17*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$Q$57","v":0},{"$f":"((L23/'Data entry (2)'!Q14*'Data entry (2)'!Q27/100)+('Data entry (2)'!Q73))/'Data entry (2)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((L23*'Data entry (2)'!Q42/('Data entry (2)'!Q12*'Data entry (2)'!Q13))+'Data entry (2)'!Q73)/'Data entry (2)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"},"No benchmark selected"]
[]
[null,null,{"$f":"'Data entry (2)'!U9","v":"Name of prod. System 2"},null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,"Benchmark",null,"Av. Household size"]
[null,null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (2)'!U12","v":0},{"$f":"'Data entry (2)'!U10","v":0}]
[null,null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L27/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$f":"H27/G27-1","v":{"$error":"#N/A"}},{"$f":"((L27*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$f":"J27/G27-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N26=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N26)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L28/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$f":"H28/G28-1","v":{"$error":"#N/A"}},{"$f":"((L28*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$f":"J28/G28-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N26*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N17*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L29/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L29*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M17*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M26*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L30/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L30*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M26*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M26*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L31/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L31*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N26*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N26*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (2)'!$U$57","v":0},{"$f":"((L32/'Data entry (2)'!U14*'Data entry (2)'!U27/100)+('Data entry (2)'!U73))/'Data entry (2)'!U56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((L32*'Data entry (2)'!U42/('Data entry (2)'!U12*'Data entry (2)'!U13))+'Data entry (2)'!U73)/'Data entry (2)'!U56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"}]
[]
[]
[null,"Results 3"]
[null,null,null,"Results "]
[null,null,{"$f":"'Data entry (3)'!$Q$9","v":"Name of prod. System 1"},null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,"Benchmark",null,"Av. Household size"]
[null,null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (3)'!Q12","v":0},{"$f":"'Data entry (3)'!Q10","v":0}]
[null,null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L39/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$f":"H39/G39-1","v":{"$error":"#N/A"}},{"$f":"((L39*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$f":"J39/G39-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N38=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N38)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L40/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$f":"H40/G40-1","v":{"$error":"#N/A"}},{"$f":"((L40*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$f":"J40/G40-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N38*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N38*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L41/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L41*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M38*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M38*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L42/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L42*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M38*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M38*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L43/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L43*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N38*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N38*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Q$57","v":0},{"$f":"((L44/'Data entry (3)'!Q14*'Data entry (3)'!Q27/100)+('Data entry (3)'!Q73))/'Data entry (3)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((L44*'Data entry (3)'!Q42/('Data entry (3)'!Q12*'Data entry (3)'!Q13))+'Data entry (3)'!Q73)/'Data entry (3)'!Q56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"},"No benchmark selected"]
[]
[null,null,{"$f":"'Data entry (3)'!U9","v":"Name of prod. System 2"},null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,"Benchmark",null,"Av. Household size"]
[null,null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (3)'!U12","v":0},{"$f":"'Data entry (3)'!U10","v":0}]
[null,null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L48/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$f":"H48/G48-1","v":{"$error":"#N/A"}},{"$f":"((L48*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$f":"J48/G48-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N47=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N47)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L49/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$f":"H49/G49-1","v":{"$error":"#N/A"}},{"$f":"((L49*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$f":"J49/G49-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N47*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N47*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L50/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L50*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M47*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M47*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L51/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L51*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M47*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M47*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L52/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L52*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N47*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N47*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$U$57","v":0},{"$f":"((L53/'Data entry (3)'!U14*'Data entry (3)'!U27/100)+('Data entry (3)'!U73))/'Data entry (3)'!U56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((L53*'Data entry (3)'!U42/('Data entry (3)'!U12*'Data entry (3)'!U13))+'Data entry (3)'!U73)/'Data entry (3)'!U56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"},"No benchmark selected"]
[]
[null,null,{"$f":"'Data entry (3)'!Y9","v":"Name of prod. System 3"},null,null,null,null,"Method 1 \nincome share",null,"Method 2\nlabor share",null,"Benchmark",null,"Av. Household size"]
[null,null,null,"Reference price for","Unit",null,"Current price","Reference Price","%-difference","Reference Price","%-difference","Household with a  laborforce of",{"$f":"'Data entry (3)'!Y12","v":0},{"$f":"'Data entry (3)'!Y10","v":0}]
[null,null,null,"World Bank Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L57/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$f":"H57/G57-1","v":{"$error":"#N/A"}},{"$f":"((L57*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$f":"J57/G57-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N56=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!L7:N62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!P6:R6,0))*12*N56)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Poverty Line",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L58/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$f":"H58/G58-1","v":{"$error":"#N/A"}},{"$f":"((L58*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$f":"J58/G58-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N56*12=0,\"Benchmark not available\",INDEX('hide_LW & Income Database'!AB7:AD62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AB6:AD6,0))*N56*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"National Minimum Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L59/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L59*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$f":"J59/G59-1","v":{"$error":"#N/A"}},{"$f":"IF(INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M56*12=0, \"Benchmark not available\", INDEX('hide_LW & Income Database'!AQ7:AS62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!AQ6:AS6,0))*M56*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Wage",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L60/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L60*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M56*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BA7:BC62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BA6:BC6,0))*M56*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"Living Income",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L61/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((L61*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N56*12=0, \"Benchmark not available\",INDEX('hide_LW & Income Database'!BK7:BM62,MATCH('General data'!I10:J10&'General data'!I11:J11,'hide_LW & Income Database'!A7:A63&'hide_LW & Income Database'!BV7:BV62,0),MATCH('General data'!I13:J13,'hide_LW & Income Database'!BK6:BM6,0))*N56*12)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,"User defined Benchmark",{"$f":"'General data'!$I$13:$J$13","v":"EUR"},"/ kg",{"$f":"'Data entry (3)'!$Y$57","v":0},{"$f":"((L62/'Data entry (3)'!Y14*'Data entry (3)'!Y27/100)+('Data entry (3)'!Y73))/'Data entry (3)'!Y56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"((L62*'Data entry (3)'!Y42/('Data entry (3)'!Y12*'Data entry (3)'!Y13))+'Data entry (3)'!Y73)/'Data entry (3)'!Y56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('General data'!$I$20:$J$20=0, \"No benchmark selected\",'General data'!$I$20:$J$20)","v":"No benchmark selected"},"No benchmark selected"]

{"sheet":"hide_LW & Income Database","index":11,"n_rows":66,"n_cols":74,"rows_kept":66,"cut":false,"hidden":true,"merged":[[4,70,5,70],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,23,4,25],[4,27,4,30],[4,11,4,14],[4,15,4,18],[4,19,4,22],[2,60,2,69],[2,70,2,72],[2,0,2,2],[2,3,2,7],[2,8,2,22],[2,23,2,38],[2,39,2,49],[2,50,2,59],[3,50,3,59],[3,60,3,69],[3,70,3,72],[4,31,4,34],[4,35,4,38],[4,39,4,41],[4,42,4,45],[4,46,4,49],[4,50,4,51],[4,52,4,55],[4,56,4,59],[4,60,4,61],[4,62,4,65],[4,66,4,69],[4,71,5,71],[4,72,5,72],[0,0,0,2],[1,0,1,2],[3,0,3,2],[3,3,3,7],[3,39,3,49],[0,3,1,7],[3,8,3,22],[3,23,3,38]]}
["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/ September 2021"]
["Geography\nSource: GLWC & LICoP",null,null,"Family composition\nSource: GLWC & LICoP",null,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,null,"Minimum Wages\nSource: ILO & WageIndicator Foundation",null,null,null,null,null,null,null,null,null,null,"(Gross) Living Wages \nSource: Global Living Wage Coalition",null,null,null,null,null,null,null,null,null,"(Net) 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,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 using 2011 prices. 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 and substituted by World Bank data. WB Data is given as 2011  PPP and multiplied with the 2011  PPP Conversion rate to equal LCU per person/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,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 8 hours 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,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","Year \n(of study)","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,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,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","Needed for Dropdown Menue"]
[null,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 of study","To add","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","Non-Metropolitan Urban",null,"Living Wage Reference Value",2020,4,2,1.66,2020,14,5.5,167.2,146.38466957639076,11810.172,{"$error":"#REF!"},402.89156626506025,352.73414355756813,28458.245783132534,{"$error":"#REF!"},668.8,585.53867830556305,47240.688000000002,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"not applicable","Wage Indicator",21600,227.13411428210898,192.1554606826642,{"$error":"#REF!"},35856,377.04262970830086,318.97806473322254,{"$error":"#REF!"},2020,"GLWC",38741,548.46747363205202,480.18678170469946,{"$error":"#REF!"},64310.06,910.45600622920631,797.11005762980108,{"$error":"#REF!"},2020,"Calculated from GLWC \n(Net LW * labour force)/ family size",15096.039999999999,213.7189778438451,187.1123322600194,{"$error":"#REF!"},60384.159999999996,854.87591137538038,748.4493290400776,{"$error":"#REF!"},"Argentine peso","ARS",{"$error":"#REF!"},"Urban"]
["Argentina","Rural",null,"Living Income Reference Value",2020,4,2,1.66,2020,14,5.5,167.2,146.38466957639076,11810.172,{"$error":"#REF!"},402.89156626506025,352.73414355756813,28458.245783132534,{"$error":"#REF!"},668.8,585.53867830556305,47240.688000000002,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"Wage Indicator",21600,227.13411428210898,192.1554606826642,{"$error":"#REF!"},35856,377.04262970830086,318.97806473322254,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",12505.75,177.04749769944078,155.00621680657562,{"$error":"#REF!"},50023,708.18999079776313,620.02486722630249,{"$error":"#REF!"},"Argentine peso","ARS",{"$error":"#REF!"},"Rural"]
["Bangladesh","Urban","Satellite Cities and Districts Surrounding Dhaka","Living Wage Benchmark","Update 2021\nOriginal 2016",4,2,1.58,2020,52.9,3.2,97.28,85.169262298990986,8256.2889813333368,{"$error":"#REF!"},246.27848101265823,215.61838556706579,20901.997421097054,{"$error":"#REF!"},389.12,340.67704919596395,33025.155925333347,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,null,"Wage Indicator",1500,19.205350456994516,14.460574956376686,{"$error":"#REF!"},2370,30.344453722051338,22.847708431075166,{"$error":"#REF!"},2021,"GLWC",17926,210.69581570286789,178.24866008462624,{"$error":"#REF!"},28323.08,332.89938881053126,281.63288293370948,{"$error":"#REF!"},2021,"Calculated from GLWC",7076.75,83.17759755524213,70.368247531734838,{"$error":"#REF!"},28307,332.71039022096852,281.47299012693935,{"$error":"#REF!"},"Bangladeshi taka","BDT",{"$error":"#REF!"},"Urban Satellite Cities and Districts Surrounding Dhaka"]
["Bangladesh","Urban","Dhaka City","Living Wage Benchmark","Update 2021\nOriginal 2016",4,2,1.58,2020,52.9,3.2,97.28,85.169262298990986,8256.2889813333368,{"$error":"#REF!"},246.27848101265823,215.61838556706579,20901.997421097054,{"$error":"#REF!"},389.12,340.67704919596395,33025.155925333347,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,null,"Wage Indicator",1500,19.205350456994516,14.460574956376686,{"$error":"#REF!"},2370,30.344453722051338,22.847708431075166,{"$error":"#REF!"},2021,"GLWC",21648,254.44287729196051,215.25867418899858,{"$error":"#REF!"},34203.840000000004,402.01974612129766,340.10870521861779,{"$error":"#REF!"},2021,"Calculated from GLWC",8546.75,100.45545369064411,84.985313822284908,{"$error":"#REF!"},34187,401.82181476257642,339.94125528913963,{"$error":"#REF!"},"Bangladeshi taka","BDT",{"$error":"#REF!"},"Urban Dhaka City"]
["Belize","Rural",null,"Living Wage Benchmark","Update 2021\nOriginal 2018",4,2,1.59,2020,14,3.2,97.28,85.169262298990986,194.56,{"$error":"#REF!"},244.72955974842768,214.26229509180121,489.45911949685535,{"$error":"#REF!"},389.12,340.67704919596395,778.24,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,null,"Wage Indicator",643,321.5,250.23570571400506,{"$error":"#REF!"},1022.37,511.185,397.87477208526809,{"$error":"#REF!"},2021,"GLWC",905,452.5,382.815,{"$error":"#REF!"},1438.95,719.47500000000002,608.67585000000008,{"$error":"#REF!"},2021,"Calculated from GLWC",8547,4273.5,3615.3809999999999,{"$error":"#REF!"},34188,17094,14461.523999999999,{"$error":"#REF!"},"Belizean dollar","BZD",{"$error":"#REF!"},"Rural"]
["Brazil","Urban","Minas Gerais South/Southwestern Region","Living Wage Benchmark","Update 2021\nOriginal 2015",4,2,1.71,2020,19.600000000000001,5.5,167.2,146.38466957639076,861.24719999999991,{"$error":"#REF!"},391.11111111111109,342.4202797108556,2014.6133333333332,{"$error":"#REF!"},668.8,585.53867830556305,3444.9887999999996,{"$error":"#REF!"},2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"Wage Indicator",1100,203.89249304911957,172.49304911955514,{"$error":"#REF!"},1881,348.65616311399447,294.96311399443925,{"$error":"#REF!"},2021,"GLWC",2271,420.94531974050051,356.11974050046342,{"$error":"#REF!"},3883.41,719.8164967562559,608.96475625579239,{"$error":"#REF!"},2019,"Calculated from GLWC",854.25,216.48504815002534,193.38095352250897,{"$error":"#REF!"},3417,865.94019260010134,773.5238140900359,{"$error":"#REF!"},"Brazilian real","BRL",{"$error":"#REF!"},"Urban Minas Gerais South/Southwestern Region"]
["Brazil","Non-metropolitan","State of São Paulo, non-metropolitan areas","Living Wage Benchmark","Update 2021\nOriginal 2020",4,2,1.68,2020,20,5.5,167.2,146.38466957639076,861.24719999999991,{"$error":"#REF!"},398.09523809523807,348.53492756283515,2050.5885714285714,{"$error":"#REF!"},668.8,585.53867830556305,3444.9887999999996,{"$error":"#REF!"},2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"Wage Indicator",1100,203.89249304911957,172.49304911955514,{"$error":"#REF!"},1848,342.53938832252084,289.7883225208526,{"$error":"#REF!"},2021,"GLWC",2710,502.31696014828549,424.96014828544952,{"$error":"#REF!"},4552.8,843.89249304911959,713.93304911955522,{"$error":"#REF!"},2021,"Calculated from GLWC",990.25,183.54958294717332,155.28294717330863,{"$error":"#REF!"},3961,734.19833178869328,621.13178869323451,{"$error":"#REF!"},"Brazilian real","BRL",{"$error":"#REF!"},"Non-metropolitan State of São Paulo, non-metropolitan areas"]
["Burkina Faso","Rural",null,"Living Income Reference Value",2020,5.5,2,1.64,2020,44,1.9,57.76,50.569249490025896,33245.847620552187,{"$error":"#REF!"},193.70731707317074,169.59199524094052,111495.22067868113,{"$error":"#REF!"},317.68,278.13087219514244,182852.16191303704,{"$error":"#REF!"},2009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,null,"Wage Indicator",34664,67.89456400629156,52.84492733517591,{"$error":"#REF!"},56848.959999999999,111.34708497031815,86.665680829688483,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",15703.09090909091,27.28191927187887,23.885494844639688,{"$error":"#REF!"},86367,150.05055599533378,131.37022164551828,{"$error":"#REF!"},"West African CFA franc","XOF",{"$error":"#REF!"},"Rural"]
["Cameroon","Rural",null,"LW & LI Reference Value",2020,5.5,2,1.71,2020,47,3.2,97.28,85.169262298990986,55993.006518824732,{"$error":"#REF!"},312.88888888888886,273.93622376868444,180094.46541142458,{"$error":"#REF!"},535.04,468.4309426444504,307961.53585353604,{"$error":"#REF!"},2007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,null,"Wage Indicator",36270,73.457137353604907,55.293258552008695,{"$error":"#REF!"},62021.7,125.61170487466438,94.551472123934872,{"$error":"#REF!"},2020,"GLWC",104623,181.76779695832676,159.13886900342791,{"$error":"#REF!"},178905.33,310.82293279873875,272.12746599586171,{"$error":"#REF!"},2020,"GLWC",28317.454545454544,49.197607870112961,43.072820406790235,{"$error":"#REF!"},155746,270.58684328562128,236.90051223734631,{"$error":"#REF!"},"Central African CFA franc","XAF",{"$error":"#REF!"},"Rural"]
["Chile","Non-Metropolitan Urban",null,"Living Wage Reference Value",2020,4,2,1.7,2020,3.6,21.7,659.68,577.55405996503259,522946.28332213784,{"$error":"#REF!"},1552.1882352941175,1358.9507293294885,1230461.8431109125,{"$error":"#REF!"},2638.72,2310.2162398601304,2091785.1332885514,{"$error":"#REF!"},2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,"Wage Indicator",326500,411.86930067025889,360.59420745977866,{"$error":"#REF!"},555050,700.17781113944011,613.01015268162371,{"$error":"#REF!"},2020,"GLWC",623057,785.96646513846713,688.11866804676049,{"$error":"#REF!"},1059196.8999999999,1336.1429907353941,1169.8017356794928,{"$error":"#REF!"},2020,"Calculated from  GLWC",218194.57499999998,275.24547324745589,240.97917257013239,{"$error":"#REF!"},872778.29999999993,1100.9818929898236,963.91669028052956,{"$error":"#REF!"},"Chilean peso","CLP",{"$error":"#REF!"},"Non-Metropolitan Urban"]
["China","Urban","Zhengzhou","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",3036,439.46595269900826,392.56450133552607,{"$error":"#REF!"},5404.08,782.24939580423472,698.76481237723647,{"$error":"#REF!"},2019,"Calculated from  GLWC",1385.1428571428571,200.5016881879157,179.10339756019488,{"$error":"#REF!"},4848,701.75590865770494,626.86189146068205,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Zhengzhou"]
["China","Urban","Chengdu","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",2597,375.9199865478671,335.80039854030343,{"$error":"#REF!"},4622.66,669.13757605520345,597.72470940174014,{"$error":"#REF!"},2019,"Calculated from  GLWC",1183.7142857142858,171.34457387841061,153.05803962291404,{"$error":"#REF!"},4143,599.70600857443719,535.70313868019912,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Chengdu"]
["China","Urban","Hangzhou","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",4159,602.02203467561776,537.77198980713206,{"$error":"#REF!"},7403.02,1071.5992217225996,957.23414185669503,{"$error":"#REF!"},2019,"Calculated from  GLWC",1892.8571428571429,273.99415929144828,244.75247707019201,{"$error":"#REF!"},6625,958.97955752006908,856.63366974567202,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Hangzhou"]
["China","Urban","Shanghai","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",4502,651.67184421967568,582.12298584075711,{"$error":"#REF!"},8013.56,1159.9758827110227,1036.1789147965476,{"$error":"#REF!"},2019,"Calculated from  GLWC",2049.1428571428573,296.61677138690828,264.96071932791205,{"$error":"#REF!"},7172,1038.1586998541791,927.36251764769213,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Shanghai"]
["China","Urban","Shenzhen","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",3004,434.83390049664717,388.42679908166019,{"$error":"#REF!"},5347.12,774.00434288403198,691.3997023653551,{"$error":"#REF!"},2019,"Calculated from  GLWC",1399.4285714285713,202.56956863539833,180.950586066385,{"$error":"#REF!"},4898,708.99349022389413,633.32705123234746,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Shenzhen"]
["China","Urban","Suzhou","Living Wage Benchmark","Update 2019\nOriginal 2015",3.5,2,1.78,2020,24,5.5,167.2,146.38466957639076,1153.8082874519146,{"$error":"#REF!"},328.76404494382018,287.83502444795937,2268.7241607200567,{"$error":"#REF!"},585.19999999999993,512.3463435173677,4038.3290060817008,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",1416,204.96830995447817,183.09332473356554,{"$error":"#REF!"},2520.48,364.84359171897114,325.90611802574665,{"$error":"#REF!"},2019,"GLWC",3875,560.91257137966306,501.04988230407236,{"$error":"#REF!"},6897.5,998.42437705580028,891.86879050124878,{"$error":"#REF!"},2019,"Calculated from GLWC",1763.7142857142858,255.30052004620535,228.05389297423326,{"$error":"#REF!"},6173,893.55182016171875,798.18862540981638,{"$error":"#REF!"},"Chinese Yuan Renminbi","CNY",{"$error":"#REF!"},"Urban Suzhou"]
["Colombia","Urban-Rural","Caribbean coast","Living Wage Benchmark","Update 2021\nOriginal 2018",4,2,1.61,2020,29.4,5.5,167.2,146.38466957639076,617779.6008324693,{"$error":"#REF!"},415.40372670807449,363.68862006556708,1534856.1511365697,{"$error":"#REF!"},668.8,585.53867830556305,2471118.4033298772,{"$error":"#REF!"},2018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"Wage Indicator",908526,242.68843543229895,205.3144163757249,{"$error":"#REF!"},1462726.86,390.72838104600135,330.55621036491709,{"$error":"#REF!"},2021,"GLWC",1717518,458.78902337061481,388.1355137715401,{"$error":"#REF!"},2765203.98,738.65032762668989,624.89817717217966,{"$error":"#REF!"},2021,"Calculated from  GLWC",635387.25,169.72671953926579,143.58880473021884,{"$error":"#REF!"},2541549,678.90687815706315,574.35521892087536,{"$error":"#REF!"},"Colombian peso","COP",{"$error":"#REF!"},"Urban-Rural Caribbean coast"]
["Costa Rica","Rural","Limón and Heredia Provinces","Living Wage Benchmark","Update 2021\nOriginal 2017",4,2,1.56,2020,10.6,5.5,167.2,146.38466957639076,97795.422949697226,{"$error":"#REF!"},428.71794871794867,375.34530660613012,250757.4947428134,{"$error":"#REF!"},668.8,585.53867830556305,391181.6917987889,{"$error":"#REF!"},2018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",320978,546.53661443114095,488.2081812893345,{"$error":"#REF!"},500725.68,852.59711851257987,761.60476281136187,{"$error":"#REF!"},2021,"GLWC",446085,119.15968361919975,100.80909234184298,{"$error":"#REF!"},695892.6,185.88910644595163,157.26218405327506,{"$error":"#REF!"},2021,"Calculated from  GLWC",155705.75,41.592629000504864,35.187364134427114,{"$error":"#REF!"},622823,166.37051600201946,140.74945653770845,{"$error":"#REF!"},"Costa Rican colón","CRC",{"$error":"#REF!"},"Rural Limón and Heredia Provinces"]
["Cote d'Ivoire","Rural",null,"Living Wage Reference Value",2020,5.5,2,1.61,2020,59,3.2,97.28,85.169262298990986,55993.006518824732,{"$error":"#REF!"},332.3229813664596,290.95089605245363,191280.45705188572,{"$error":"#REF!"},535.04,468.4309426444504,307961.53585353604,{"$error":"#REF!"},2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,null,"Wage Indicator",60000,121.48217391222506,91.469410342446238,{"$error":"#REF!"},96600,195.58629999868236,147.26575065133846,{"$error":"#REF!"},2020,"GLWC",100590,27.224349877102711,23.835092471242433,{"$error":"#REF!"},161949.90000000002,43.831203302135364,38.374498878700322,{"$error":"#REF!"},2020,"Calculated from  GLWC",26496.50181818182,7.1711903371853074,6.2784230142241464,{"$error":"#REF!"},145730.76,39.441546854519189,34.531326578232807,{"$error":"#REF!"},"West African CFA franc","XOF",{"$error":"#REF!"},"Rural"]
["Cote d'Ivoire","Rural","Cocoa growing areas","Living Income Benchmark",2018,6,2,1.65,2020,59,3.2,97.28,85.169262298990986,55993.006518824732,{"$error":"#REF!"},353.74545454545461,309.70640835996721,203610.93279572632,{"$error":"#REF!"},583.68000000000006,511.01557379394592,335958.03911294841,{"$error":"#REF!"},2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,null,"Wage Indicator",60000,121.48217391222506,91.469410342446238,{"$error":"#REF!"},99000,200.44558695517134,150.92452706503627,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2018,"LICoP",43676,14.776851959338432,12.512634345070497,{"$error":"#REF!"},262056,88.661111756030593,75.075806070422985,{"$error":"#REF!"},"West African CFA franc","XOF",{"$error":"#REF!"},"Rural Cocoa growing areas"]
["Democratic Republic of Congo","Rural",null,"Living Income Reference Value",2021,6,2,1.77,2020,77,1.9,57.76,50.569249490025896,106920.81606745154,{"$error":"#REF!"},195.79661016949152,171.42118471195218,362443.44429644587,{"$error":"#REF!"},346.56,303.41549694015538,641524.8964047092,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"Wage Indicator",7075,4.2937074898725607,3.8354669554955922,{"$error":"#REF!"},12522.75,7.5998622570744327,6.7887765112271987,{"$error":"#REF!"},2021,"GLWC",380033,191.02991369213677,161.61130698354771,{"$error":"#REF!"},672658.41,338.12294723508211,286.05201336087947,{"$error":"#REF!"},2021,"Calculated from GLWC",63338.833333333336,31.838318948689462,26.935217830591284,{"$error":"#REF!"},380033,191.02991369213677,161.61130698354771,{"$error":"#REF!"},"Congolese franc","CDF",{"$error":"#REF!"},"Rural"]
["Dominican Republic","Rural","Northern Region","Living Wage Benchmark","Update 2021\nOriginal 2013",4,2,1.67,2020,12.4,5.5,167.2,146.38466957639076,9450.901973333328,{"$error":"#REF!"},400.47904191616766,350.62196305722341,22636.890954091803,{"$error":"#REF!"},668.8,585.53867830556305,37803.607893333312,{"$error":"#REF!"},2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",12015,234.2340029856795,209.23567346496034,{"$error":"#REF!"},20065.05,391.17078498608475,349.42357468648373,{"$error":"#REF!"},2021,"GLWC",18622,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},31098.739999999998,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2021,"Calculated from GLWC",7278.75,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},29115,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},"Dominican peso","DOP",{"$error":"#REF!"},"Rural Northern Region"]
["Ecuador","Rural","Southern Coastal Region","Living Wage Benchmark","Update 2021\nOriginal 2016",4,2,1.61,2020,25,5.5,167.2,146.38466957639076,167.2,{"$error":"#REF!"},415.40372670807449,363.68862006556708,415.40372670807449,{"$error":"#REF!"},668.8,585.53867830556305,668.8,{"$error":"#REF!"},2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",394,394,351.95084528455283,{"$error":"#REF!"},634.34,634.34,566.64086090813009,{"$error":"#REF!"},2021,"GLWC",462,462,390.85199999999998,{"$error":"#REF!"},743.82,743.82,629.27171999999996,{"$error":"#REF!"},2021,"Calculated from  GLWC",170.75,170.75,144.4545,{"$error":"#REF!"},683,683,577.81799999999998,{"$error":"#REF!"},"United States dollar","USD",{"$error":"#REF!"},"Rural Southern Coastal Region"]
["Egypt, Arab Rep.","Rural",null,"Living Wage Reference Value",2020,5,2,1.53,2020,29,3.2,97.28,85.169262298990986,1533.0523413333365,{"$error":"#REF!"},317.90849673202615,278.33092254572216,5009.9749716775705,{"$error":"#REF!"},486.4,425.84631149495493,7665.2617066666826,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"Wage Indicator",2000,119.2564467195005,106.52895235675238,{"$error":"#REF!"},3060,182.46236348083576,162.98929710583116,{"$error":"#REF!"},2020,"GLWC",3957,251.09185748035847,219.83252745564877,{"$error":"#REF!"},6054.21,384.17054194494847,336.34376700714262,{"$error":"#REF!"},2020,"Calculated from  GLWC",1127.9159999999999,71.572030205159464,62.661770290034255,{"$error":"#REF!"},5639.58,357.86015102579734,313.30885145017129,{"$error":"#REF!"},"Egyptian pound","EGP",{"$error":"#REF!"},"Rural"]
["El Salvador","Rural",null,"Living Wage Reference Value",2020,4.5,2,1.59,2020,6,3.2,97.28,85.169262298990986,851.2,{"$error":"#REF!"},275.32075471698113,241.04508197827639,2409.0566037735848,{"$error":"#REF!"},437.76,383.26168034545947,3830.4,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",2660,304,271.55598214848749,{"$error":"#REF!"},4229.4000000000005,483.36,431.77401161609515,{"$error":"#REF!"},2020,"GLWC",3136,358.4,313.7814926804931,{"$error":"#REF!"},4986.2400000000007,569.85599999999999,498.91257336198407,{"$error":"#REF!"},2020,"Calculated from  GLWC",994.63333333333344,113.67238095238096,99.520896684664493,{"$error":"#REF!"},4475.8500000000004,511.52571428571434,447.84403508099024,{"$error":"#REF!"},"Salvadoran colon","SVC",{"$error":"#REF!"},"Rural"]
["Ethiopia","Non-Metropolitan Urban","Ziway Region","Living Wage Benchmark","Update 2019\nOriginal 2015",5,2,1.65,2020,31,1.9,57.76,50.569249490025896,2017.3930737373735,{"$error":"#REF!"},175.03030303030306,153.24014996977544,6113.3123446587078,{"$error":"#REF!"},288.8,252.84624745012948,10086.965368686868,{"$error":"#REF!"},2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2019,"GLWC",4847,166.73690004214004,148.94211398466288,{"$error":"#REF!"},7997.5499999999993,275.11588506953103,245.75448807469374,{"$error":"#REF!"},2019,"Calculated from  GLWC",1304,44.857626914576151,40.070253071178129,{"$error":"#REF!"},6520,224.28813457288075,200.35126535589066,{"$error":"#REF!"},"Ethiopian birr","ETB",{"$error":"#REF!"},"Non-Metropolitan Urban Ziway Region"]
["Gabon","Urban",null,"Living Wage Benchmark",2021,5,2,1.65,2020,33,5.5,167.2,146.38466957639076,96237.979954230002,{"$error":"#REF!"},506.66666666666669,443.58990780724474,291630.24228554551,{"$error":"#REF!"},836,731.92334788195376,481189.89977115003,{"$error":"#REF!"},2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,null,"Wage Indicator",150000,303.15630445288434,228.67352585611587,{"$error":"#REF!"},247500,500.20790234725916,377.31131766259119,{"$error":"#REF!"},2021,"GLWC",268721,484.5923574919301,409.96513443817287,{"$error":"#REF!"},443389.64999999997,799.57738986168465,676.44247182298523,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,"Central African CFA franc","FCFA",{"$error":"#REF!"},"Urban"]
["Gabon","Rural",null,"Living Wage Benchmark",2021,5,2,1.65,2020,33,5.5,167.2,146.38466957639076,96237.979954230002,{"$error":"#REF!"},506.66666666666669,443.58990780724474,291630.24228554551,{"$error":"#REF!"},836,731.92334788195376,481189.89977115003,{"$error":"#REF!"},2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,null,"Wage Indicator",150000,303.15630445288434,228.67352585611587,{"$error":"#REF!"},247500,500.20790234725916,377.31131766259119,{"$error":"#REF!"},2021,"GLWC",200770,362.05435233440932,306.29798207491029,{"$error":"#REF!"},331270.5,597.38968135177538,505.39167042360197,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},null,{"$error":"#N/A"},{"$error":"#N/A"},null,"Central African CFA franc","FCFA",{"$error":"#REF!"},"Rural"]
["Ghana","Peri-Urban","Lower Volta Region","Living Wage Benchmark","Update 2021\nOriginal 2017",4.5,2,1.78,2020,29,3.2,97.28,85.169262298990986,544.35050666666632,{"$error":"#REF!"},245.93258426966293,215.3155507558761,1376.1670112359543,{"$error":"#REF!"},437.76,383.26168034545947,2449.5772799999986,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,"Wage Indicator",319,57.007974861687188,49.910846670737264,{"$error":"#REF!"},567.82000000000005,101.4741952538032,88.841307073912333,{"$error":"#REF!"},2021,"GLWC",1456,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2591.6799999999998,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2021,"Calculated from  GLWC",496.88888888888891,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2236,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},"Ghana cedi","GHS",{"$error":"#REF!"},"Peri-Urban Lower Volta Region"]
["Ghana","Rural","Cocoa growing areas of Ashanti, Central, Eastern, Western Regions","Living Income Benchmark","Update 2020\nOriginal 2018",5,2,1.56,2020,29,3.2,97.28,85.169262298990986,544.35050666666632,{"$error":"#REF!"},311.79487179487177,272.97840480445831,1744.7131623931612,{"$error":"#REF!"},486.4,425.84631149495493,2721.7525333333315,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,"Wage Indicator",319,57.007974861687188,49.910846670737264,{"$error":"#REF!"},497.64000000000004,88.932440784232014,77.860920806350137,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2019,"LICoP",336.6,64.515304655605277,57.629989866321637,{"$error":"#REF!"},1683,322.5765232780264,288.14994933160818,{"$error":"#REF!"},"Ghana cedi","GHS",{"$error":"#REF!"},"Rural Cocoa growing areas of Ashanti, Central, Eastern, Western Regions"]
["Guatemala","Rural","Central Valley Area","Living Wage Benchmark","Update 2021\nOriginal 2016",5,2,1.53,2020,49,5.5,167.2,146.38466957639076,1291.05988,{"$error":"#REF!"},546.40522875816987,478.38127312545998,4219.1499346405226,{"$error":"#REF!"},836,731.92334788195376,6455.2993999999999,{"$error":"#REF!"},2014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",2773,360.28435569450897,321.83346073472825,{"$error":"#REF!"},4242.6900000000005,551.23506421259879,492.40519492413421,{"$error":"#REF!"},2021,"GLWC",3242,419.40491591203102,354.81655886157824,{"$error":"#REF!"},4960.26,641.68952134540746,542.86933505821469,{"$error":"#REF!"},2021,"Calculated from  GLWC",945,122.25097024579559,103.42432082794308,{"$error":"#REF!"},4725,611.25485122897794,517.12160413971537,{"$error":"#REF!"},"Guatemalan quetzal","GTQ",{"$error":"#REF!"},"Rural Central Valley Area"]
["Honduras","Rural",null,"Living Wage Reference Value",2020,4.5,2,1.65,2020,29,3.2,97.28,85.169262298990986,2391.3253367214456,{"$error":"#REF!"},265.30909090909091,232.27980626997544,6521.7963728766699,{"$error":"#REF!"},437.76,383.26168034545947,10760.964015246505,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",8484,346.16506636569437,309.22103481063317,{"$error":"#REF!"},13998.599999999999,571.17235950339568,510.21470743754469,{"$error":"#REF!"},2020,"GLWC",6852,278.74189670648093,244.04031367508765,{"$error":"#REF!"},11305.8,459.92412956569353,402.66651756389462,{"$error":"#REF!"},2020,"Calculated from  GLWC",2311.4666666666662,94.031319737372115,82.325021947291674,{"$error":"#REF!"},10401.599999999999,423.1409388181745,370.46259876281255,{"$error":"#REF!"},"Honduran lempira","HNL",{"$error":"#REF!"},"Rural"]
["India","Urban","Tiruppur, Tamil Nadu","Living Wage Benchmark","Update 2019\nOriginal 2016",4,2,1.58,2020,62,3.2,97.28,85.169262298990986,7208.4058664371141,{"$error":"#REF!"},246.27848101265823,215.61838556706579,18249.128775790163,{"$error":"#REF!"},389.12,340.67704919596395,28833.623465748457,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",4757,67.551505201415182,60.342155725588682,{"$error":"#REF!"},7516.06,106.73137821823599,95.340606046430125,{"$error":"#REF!"},2019,"GLWC",15570,221.10089047425572,197.50417587711075,{"$error":"#REF!"},24600.600000000002,349.33940694932403,312.056597885835,{"$error":"#REF!"},2019,"Calculated from  GLWC",5366,76.199574713221338,68.067270889953519,{"$error":"#REF!"},21464,304.79829885288535,272.26908355981408,{"$error":"#REF!"},"Indian rupee","INR",{"$error":"#REF!"},"Urban Tiruppur, Tamil Nadu"]
["India","Rural","Bhadohi, Uttar Pradesh","Living Wage Benchmark","Update 2019\nOriginal 2016",5,2,1.546,2020,62,3.2,97.28,85.169262298990986,7208.4058664371141,{"$error":"#REF!"},314.61836998706337,275.45039553360601,23313.084949667253,{"$error":"#REF!"},486.4,425.84631149495493,36042.029332185572,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",4757,67.551505201415182,60.342155725588682,{"$error":"#REF!"},7354.3220000000001,104.43462704138787,93.288972751760099,{"$error":"#REF!"},2019,"GLWC",10627,150.90810295888988,134.80262537225792,{"$error":"#REF!"},16429.342000000001,233.30392717444377,208.40485882551076,{"$error":"#REF!"},2019,"Calculated from  GLWC",3285.6,46.656974036108835,41.677567133065835,{"$error":"#REF!"},16428,233.28487018054417,208.38783566532919,{"$error":"#REF!"},"Indian rupee","INR",{"$error":"#REF!"},"Rural Bhadohi, Uttar Pradesh"]
["India","Rural","Rural Nilgiris, Tamil Nadu","Living Wage Benchmark","Update 2020\nOriginal 2018",4,2,1.73,2020,62,3.2,97.28,85.169262298990986,7208.4058664371141,{"$error":"#REF!"},224.92485549132948,196.92314982425663,16666.834373265003,{"$error":"#REF!"},389.12,340.67704919596395,28833.623465748457,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",4757,67.551505201415182,60.342155725588682,{"$error":"#REF!"},8229.61,116.86410399844826,104.39192940526841,{"$error":"#REF!"},2020,"GLWC",12666,170.93217319199201,149.65221108064682,{"$error":"#REF!"},21912.18,295.71265962214619,258.89832516951901,{"$error":"#REF!"},2020,"Calculated from  GLWC",4739.75,63.964611391658302,56.001426454247259,{"$error":"#REF!"},18959,255.85844556663321,224.00570581698904,{"$error":"#REF!"},"Indian rupee","INR",{"$error":"#REF!"},"Rural Rural Nilgiris, Tamil Nadu"]
["Kenya","Rural","Mount Kenya","Living Wage Benchmark","2015/2016",5.5,2,1.71,2020,67,3.2,97.28,85.169262298990986,10355.531893820535,{"$error":"#REF!"},312.88888888888886,273.93622376868444,33307.266325153767,{"$error":"#REF!"},535.04,468.4309426444504,56955.425416012942,{"$error":"#REF!"},2005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,"agriculture, unskilled worker","Wage Indicator",6736,63.278070766314251,55.400355744966411,{"$error":"#REF!"},11518.56,108.20550101039737,94.734608323892559,{"$error":"#REF!"},2016,"GLWC",13943,137.36381921924342,124.09741884883536,{"$error":"#REF!"},23842.53,234.89213086490625,212.20658623150845,{"$error":"#REF!"},2016,"Calculated from  GLWC",3995.818181818182,39.366050804004779,35.56413415713137,{"$error":"#REF!"},21977,216.5132794220263,195.60273786422252,{"$error":"#REF!"},"Kenyan shilling","KES",{"$error":"#REF!"},"Rural Mount Kenya"]
["Kenya","Non-metropolitan Urban","Lake Naivasha","Living Wage Benchmark","Update 2021\nOriginal 2014",5,2,1.69,2020,67,3.2,97.28,85.169262298990986,10355.531893820535,{"$error":"#REF!"},287.81065088757396,251.98006597334611,30637.668324912822,{"$error":"#REF!"},486.4,425.84631149495493,51777.659469102669,{"$error":"#REF!"},2005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",15125,148.29696492597412,132.47015776352862,{"$error":"#REF!"},25561.25,250.62187072489627,223.87456662036337,{"$error":"#REF!"},2019,"GLWC",29702,291.22092246157246,260.14073559618691,{"$error":"#REF!"},50196.38,492.16335896005745,439.63784315755589,{"$error":"#REF!"},2019,"Calculated from  GLWC",7924.4,77.696824387397641,69.40472847479711,{"$error":"#REF!"},39622,388.48412193698823,347.02364237398552,{"$error":"#REF!"},"Kenyan shilling","KES",{"$error":"#REF!"},"Non-metropolitan Urban Lake Naivasha"]
["Madagascar","Rural",null,"Living Income Reference Value",2020,5,2,1.78,2020,79,1.9,57.76,50.569249490025896,218780.67440023072,{"$error":"#REF!"},162.24719101123597,142.04845362366825,614552.45618042338,{"$error":"#REF!"},288.8,252.84624745012948,1093903.3720011536,{"$error":"#REF!"},2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"agriculture, lowest","Wage Indicator",170442,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},303386.76,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",102538.6,27.071081813950901,23.700905301499066,{"$error":"#REF!"},512693,135.3554090697545,118.50452650749533,{"$error":"#REF!"},"Malagasy ariary","MGA",{"$error":"#REF!"},"Rural"]
["Malawi","Rural","Southern Region","Living Wage Benchmark","Update 2019\nOriginal 2014",5,2,1.59,2020,69,1.9,57.76,50.569249490025896,43292.708046635933,{"$error":"#REF!"},181.63522012578616,159.02279713844621,136140.59134162244,{"$error":"#REF!"},288.8,252.84624745012948,216463.54023317966,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,"Wage Indicator",35000,46.696085581486024,40.882721640889336,{"$error":"#REF!"},55650,74.246776074562788,65.003527409014055,{"$error":"#REF!"},2019,"GLWC",101361,135.95636612095862,121.44659385301404,{"$error":"#REF!"},161163.99000000002,216.17062213232421,193.10008422629232,{"$error":"#REF!"},2019,"Calculated from  GLWC",27092.2,36.338996874756909,32.460763113866541,{"$error":"#REF!"},135461,181.69498437378454,162.3038155693327,{"$error":"#REF!"},"Malawi kwacha","MWK",{"$error":"#REF!"},"Rural Southern Region"]
["Mexico","Non-metropolitan Urban & Rural","Michoacán, northwestern regions","Living Wage Benchmark",2020,4,2,1.63,2020,23,5.5,167.2,146.38466957639076,3589.1151999999997,{"$error":"#REF!"},410.30674846625766,359.22618300954792,8807.6446625766876,{"$error":"#REF!"},668.8,585.53867830556305,14356.460799999999,{"$error":"#REF!"},2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"urban","ILO",2759,143.35446326509407,128.05513837934831,{"$error":"#REF!"},4497.17,233.66777512210331,208.72987555833774,{"$error":"#REF!"},2020,"GLWC",11782,548.86797726637474,480.53742519856593,{"$error":"#REF!"},19204.66,894.65480294419081,783.27600307366242,{"$error":"#REF!"},2020,"Calculated from  GLWC",4166,194.07435013509735,169.91333503456335,{"$error":"#REF!"},16664,776.29740054038939,679.65334013825338,{"$error":"#REF!"},"Mexican peso","MXN",{"$error":"#REF!"},"Non-metropolitan Urban & Rural Michoacán, northwestern regions"]
["Morocco","Rural",null,"Living Wage Reference Value",2020,4.5,2,1.56,2020,7,3.2,97.28,85.169262298990986,923.85330750553146,{"$error":"#REF!"},280.61538461538458,245.68056432401247,2664.9614639582637,{"$error":"#REF!"},437.76,383.26168034545947,4157.3398837748919,{"$error":"#REF!"},2007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"agriculture","Wage Indicator",1904,211.67315175097278,179.07548638132297,{"$error":"#REF!"},2970.2400000000002,330.21011673151753,279.35775875486382,{"$error":"#REF!"},2020,"GLWC",2249,236.81543186843012,207.33342550628242,{"$error":"#REF!"},3508.44,369.43207371475103,323.44014378980057,{"$error":"#REF!"},2020,"Calculated from  GLWC",726.96,76.547508381980421,67.017833261915101,{"$error":"#REF!"},3271.32,344.46378771891187,301.58024967861797,{"$error":"#REF!"},"Moroccan dirham","MAD",{"$error":"#REF!"},"Rural"]
["Mozambique","Rural",null,"Living Income Reference Value",2020,5.5,2,1.71,2020,64,1.9,57.76,50.569249490025896,4012.2984000000001,{"$error":"#REF!"},185.77777777777777,162.6496328626564,12905.053333333335,{"$error":"#REF!"},317.68,278.13087219514244,22067.641200000002,{"$error":"#REF!"},2009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"agriculture","Wage Indicator",4390,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},7506.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",1658.3636363636363,23.873369846161896,20.90128801797476,{"$error":"#REF!"},9121,131.30353415389044,114.95708409886119,{"$error":"#REF!"},"Mozambique Metical","MZN",{"$error":"#REF!"},"Rural"]
["Nicaragua","Urban","Managua Free Trade Zone","Living Wage Benchmark","Update 2019\nOriginal 2017",4,2,1.68,2020,13,3.2,97.28,85.169262298990986,3340.8016398046498,{"$error":"#REF!"},231.61904761904762,202.78395785474046,7954.2896185824993,{"$error":"#REF!"},389.12,340.67704919596395,13363.206559218599,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",5919,178.70435125300901,159.63235400894456,{"$error":"#REF!"},9943.92,300.22331010505513,268.18235473502688,{"$error":"#REF!"},2019,"GLWC",12101,365.34910534087891,326.35768134182098,{"$error":"#REF!"},20329.68,613.78649697267656,548.28090465425919,{"$error":"#REF!"},2019,"Calculated from  GLWC",4489.5,135.54539363919309,121.07948189274482,{"$error":"#REF!"},17958,542.18157455677238,484.31792757097929,{"$error":"#REF!"},"Nicaraguan córdoba","NIO",{"$error":"#REF!"},"Urban Managua Free Trade Zone"]
["Nicaragua","Rural-Urban","Northwest","Living Wage Benchmark","Update 2020\nOriginal 2017",4,2,1.62,2020,13,3.2,97.28,85.169262298990986,3340.8016398046498,{"$error":"#REF!"},240.19753086419752,210.29447481232341,8248.8929377892582,{"$error":"#REF!"},389.12,340.67704919596395,13363.206559218599,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"agriculture","Wage Indicator",4415,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},7152.3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2020,"GLWC",9900,288.27572057116049,252.38723745637131,{"$error":"#REF!"},16038.000000000002,467.00666732528003,408.86732467932154,{"$error":"#REF!"},2020,"Calculated from  GLWC",3728.75,108.57657505855704,95.059486026812579,{"$error":"#REF!"},14915,434.30630023422816,380.23794410725031,{"$error":"#REF!"},"Nicaraguan córdoba","NIO",{"$error":"#REF!"},"Rural-Urban Northwest"]
["Nigeria","Rural",null,"Living Income Reference Value",2020,5,2,1.71,2020,71,3.2,97.28,85.169262298990986,34905.11435728713,{"$error":"#REF!"},284.44444444444446,249.03293069880405,102061.73788680448,{"$error":"#REF!"},486.4,425.84631149495493,174525.57178643564,{"$error":"#REF!"},2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"Wage Indicator",30000,97.745037782039219,87.313321496850904,{"$error":"#REF!"},51300,167.14401460728706,149.30577975961504,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",27735.599999999999,77.298677219108271,67.675486384038578,{"$error":"#REF!"},138678,386.49338609554138,338.37743192019286,{"$error":"#REF!"},"Nigerian naira","NGN",{"$error":"#REF!"},"Rural"]
["Pakistan","Rural","Sialkot","Living Wage Benchmark","Update 2019\nOriginal 2015",5.5,2,1.647,2020,36,3.2,97.28,85.169262298990986,15743.647303729369,{"$error":"#REF!"},324.85731633272616,284.41465855765051,52574.414189745919,{"$error":"#REF!"},535.04,468.4309426444504,86590.060170511526,{"$error":"#REF!"},2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",18696,124.60988275510083,111.31104966108315,{"$error":"#REF!"},30792.312000000002,205.23247689765105,183.32929879180395,{"$error":"#REF!"},2019,"GLWC",21890,145.89807089800797,130.32728268512571,{"$error":"#REF!"},36052.83,240.29412276901914,214.64903458240204,{"$error":"#REF!"},2019,"Calculated from  GLWC",6555.090909090909,43.690046514272865,39.027281221369968,{"$error":"#REF!"},36053,240.29525582850076,214.65004671753482,{"$error":"#REF!"},"Pakistan rupee","PKR",{"$error":"#REF!"},"Rural Sialkot"]
["Pakistan","Urban","Sialkot","Living Wage Benchmark","Update 2019\nOriginal 2015",5,2,1.534,2020,36,3.2,97.28,85.169262298990986,15743.647303729369,{"$error":"#REF!"},317.07953063885265,277.60515742826266,51315.669177735886,{"$error":"#REF!"},486.4,425.84631149495493,78718.236518646852,{"$error":"#REF!"},2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",18696,124.60988275510083,111.31104966108315,{"$error":"#REF!"},28679.664000000001,191.15156014632467,170.75115018010155,{"$error":"#REF!"},2019,"GLWC",25806,171.99842930991292,153.6421131554296,{"$error":"#REF!"},39586.404000000002,263.84559056140642,235.68700158042901,{"$error":"#REF!"},2019,"Calculated from  GLWC",7949.8,52.9858603940148,47.331011050260962,{"$error":"#REF!"},39749,264.92930197007399,236.65505525130482,{"$error":"#REF!"},"Pakistan rupee","PKR",{"$error":"#REF!"},"Urban Sialkot"]
["Panama","Rural",null,"Living Wage Reference Value",2020,4,2,1.68,2020,12,5.5,167.2,146.38466957639076,167.2,{"$error":"#REF!"},398.09523809523807,348.53492756283515,398.09523809523807,{"$error":"#REF!"},668.8,585.53867830556305,668.8,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",458,458,409.120525736866,{"$error":"#REF!"},769.43999999999994,769.43999999999994,687.32248323793488,{"$error":"#REF!"},2020,"GLWC",569,569,498.16313988616236,{"$error":"#REF!"},955.92,955.92,836.91407500875277,{"$error":"#REF!"},2020,"Calculated from  GLWC",215.45999999999998,215.45999999999998,188.63660829503081,{"$error":"#REF!"},861.83999999999992,861.83999999999992,754.54643318012324,{"$error":"#REF!"},"United States dollar","USD",{"$error":"#REF!"},"Rural"]
["Papua New Guinea","Rural",null,"Living Income Reference Value",2020,5,2,1.67,2020,66,3.2,97.28,85.169262298990986,336.58630831364883,{"$error":"#REF!"},291.25748502994014,254.99779131434428,1007.7434380648168,{"$error":"#REF!"},486.4,425.84631149495493,1682.931541568244,{"$error":"#REF!"},2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,null,"Wage Indicator",683,217.99987622055866,196.94576127908812,{"$error":"#REF!"},1140.6099999999999,364.05979328833297,328.89942133607713,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",318.60000000000002,92.081606513592092,80.618035547580206,{"$error":"#REF!"},1593,460.40803256796045,403.090177737901,{"$error":"#REF!"},"Papua New Guinean kina","PGK",{"$error":"#REF!"},"Rural"]
["Peru","Rural",null,"LW & LI Reference Value",2020,5,2,1.72,2020,21,5.5,167.2,146.38466957639076,584.35416825396862,{"$error":"#REF!"},486.04651162790697,425.5368301639266,1698.7039774824668,{"$error":"#REF!"},836,731.92334788195376,2921.770841269843,{"$error":"#REF!"},2018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,null,"Wage Indicator",930,282.96696785303783,239.6086940724077,{"$error":"#REF!"},1599.6,486.70318470722503,412.12695380454124,{"$error":"#REF!"},2020,"GLWC",1582,452.65425382409524,396.30169484681755,{"$error":"#REF!"},2721.04,778.56531657744381,681.63891513652618,{"$error":"#REF!"},2020,"GLWC",410,117.31241723633316,102.707771736533,{"$error":"#REF!"},2050,586.56208618166579,513.53885868266502,{"$error":"#REF!"},"Peruvian sol","PEN",{"$error":"#REF!"},"Rural"]
["Rwanda","Rural",null,"LW & LI Reference Value",2020,5,2,1.69,2020,57,1.9,57.76,50.569249490025896,54483.740062106684,{"$error":"#REF!"},170.88757396449705,149.61316417167424,161194.4972251677,{"$error":"#REF!"},288.8,252.84624745012948,272418.7003105334,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",2906,3.2312207208635715,2.8863727512916144,{"$error":"#REF!"},4911.1399999999994,5.4607630182594358,4.8779699496828286,{"$error":"#REF!"},2020,"GLWC",147111,155.95719659322242,136.54152327367871,{"$error":"#REF!"},248617.59,263.56766224254591,230.75517433251702,{"$error":"#REF!"},2020,"GLWC",37526.6,39.783179596870525,34.830428229581955,{"$error":"#REF!"},187633,198.91589798435263,174.15214114790976,{"$error":"#REF!"},"Rwandan franc","RWF",{"$error":"#REF!"},"Rural"]
["South Africa","Rural","Western Cape Province","Living Wage Benchmark","Update 2021\nOriginal 2013",4.5,2,1.64,2020,57,5.5,167.2,146.38466957639076,2751.9624212637273,{"$error":"#REF!"},458.78048780487808,401.66525188643806,7551.1163998090087,{"$error":"#REF!"},752.4,658.73101309375841,12383.830895686773,{"$error":"#REF!"},2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",3547,245.4938510980304,219.29382844190852,{"$error":"#REF!"},5817.08,402.60991580076984,359.64187864472996,{"$error":"#REF!"},2021,"GLWC",4596,310.77151937250659,262.91270538914057,{"$error":"#REF!"},7537.44,509.66529177091076,431.17683683819052,{"$error":"#REF!"},2019,"Calculated from  GLWC",1544.4444444444443,106.89360430606843,95.485518758967771,{"$error":"#REF!"},6950,481.02121937730794,429.684834415355,{"$error":"#REF!"},"South African rand","ZAR",{"$error":"#REF!"},"Rural Western Cape Province"]
["Sri Lanka","Rural","Estate Sector","Living Wage Benchmark","Update 2021\nOriginal 2015",4.5,2,1.76,2020,11,3.2,97.28,85.169262298990986,18054.444020080882,{"$error":"#REF!"},248.72727272727272,217.76231837810198,46161.930733161345,{"$error":"#REF!"},437.76,383.26168034545947,81244.998090363966,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,"ILO",13182,73.747548338051118,65.876933947310945,{"$error":"#REF!"},23200.32,129.79568507496998,115.94340374726727,{"$error":"#REF!"},2019,"GLWC",23785,133.06671500686892,118.86533712158936,{"$error":"#REF!"},41861.599999999999,234.19741841208929,209.20299333399728,{"$error":"#REF!"},2019,"Calculated from  GLWC",8412,47.061475999065848,42.038899132512491,{"$error":"#REF!"},37854,211.77664199579633,189.1750460963062,{"$error":"#REF!"},"Sri Lankan rupee","LKR",{"$error":"#REF!"},"Rural Estate Sector"]
["Tanzania","Rural",null,"LW & LI Reference Value",2020,5.5,2,1.73,2020,77,3.2,97.28,85.169262298990986,223174.53752113518,{"$error":"#REF!"},309.27167630057801,270.76933100835282,709514.42564522754,{"$error":"#REF!"},535.04,468.4309426444504,1227459.9563662435,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,"Agriculture","Wage Indicator",100000,62.595621331961929,47.131067784402127,{"$error":"#REF!"},173000,108.29042490429414,81.536747267015684,{"$error":"#REF!"},2020,"GLWC",317779,138.51733026251893,121.27280873853245,{"$error":"#REF!"},549757.67000000004,239.63498135415773,209.80195911766114,{"$error":"#REF!"},2020,"GLWC",83289.454545454544,36.305208596722203,31.785442370413399,{"$error":"#REF!"},458092,199.6786472819721,174.8199330372737,{"$error":"#REF!"},"Tanzanian shilling","TZS",{"$error":"#REF!"},"Rural"]
["Tanzania","Urban",null,"Living Wage Reference Value",2020,5,2,1.69,2020,77,3.2,97.28,85.169262298990986,223174.53752113518,{"$error":"#REF!"},287.81065088757396,251.98006597334611,660279.69680809218,{"$error":"#REF!"},486.4,425.84631149495493,1115872.6876056758,{"$error":"#REF!"},2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,"Agriculture","Wage Indicator",100000,62.595621331961929,47.131067784402127,{"$error":"#REF!"},169000,105.78660005101565,79.65150455563959,{"$error":"#REF!"},2020,"GLWC",425608,185.51913090031169,162.42318586687389,{"$error":"#REF!"},719277.52,313.52733122152677,274.49518411501685,{"$error":"#REF!"},2020,"Calculated from  GLWC",122132.24399999999,53.236470559258308,46.608870527693071,{"$error":"#REF!"},610661.22,266.18235279629153,233.04435263846537,{"$error":"#REF!"},"Tanzanian shilling","TZS",{"$error":"#REF!"},"Urban"]
["Tunisia","Rural",null,"Living Wage Reference Value",2020,4.5,2,1.46,2020,3,3.2,97.28,85.169262298990986,273.58621866666635,{"$error":"#REF!"},299.83561643835617,262.50800023661606,843.24519452054699,{"$error":"#REF!"},437.76,383.26168034545947,1231.1379839999986,{"$error":"#REF!"},2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"non-agriculture, 48h/w","Wage Indicator",429,154.42764578833692,130.64578833693304,{"$error":"#REF!"},626.34,225.4643628509719,190.74285097192222,{"$error":"#REF!"},2020,"GLWC",695,247.12355881629622,216.35825659010342,{"$error":"#REF!"},1014.6999999999999,360.80039587179249,315.88305462155097,{"$error":"#REF!"},2020,"Calculated from  GLWC",215.10666666666668,76.486223009751697,66.964177526487077,{"$error":"#REF!"},967.98,344.18800354388264,301.33879886919186,{"$error":"#REF!"},"Tunisian dinar","TND",{"$error":"#REF!"},"Rural"]
["Turkey","Rural",null,"Living Income Reference Value",2020,4,2,1.58,2020,10,5.5,167.2,146.38466957639076,1174.58,{"$error":"#REF!"},423.29113924050625,370.5941001933943,2973.6202531645567,{"$error":"#REF!"},668.8,585.53867830556305,4698.32,{"$error":"#REF!"},2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"Wage Indicator",3578,401.84186882300088,339.95822102425876,{"$error":"#REF!"},5653.2400000000007,634.91015274034146,537.13398921832891,{"$error":"#REF!"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#REF!"},2020,"GLWC",887.75,126.37010676156584,110.63783685780525,{"$error":"#REF!"},3551,505.48042704626334,442.55134743122102,{"$error":"#REF!"},"Turkish lira","TRY",{"$error":"#REF!"},"Rural"]
["Uganda","Rural","Lake Victoria Basin","Living Wage Benchmark",2019,5,2,1.78,2020,41,1.9,57.76,50.569249490025896,214766.05777568571,{"$error":"#REF!"},162.24719101123597,142.04845362366825,603275.44319012843,{"$error":"#REF!"},288.8,252.84624745012948,1073830.2888784285,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,null,"Wage Indicator",130000,35.998870053730151,31.866398063035565,{"$error":"#REF!"},231400,64.077988695639675,56.722188552203306,{"$error":"#REF!"},2019,"GLWC",652311,176.10754808417775,157.31269139395025,{"$error":"#REF!"},1161113.58,313.4714355898364,280.01659068123143,{"$error":"#REF!"},2019,"Calculated from  GLWC",197859.6,53.417110888696001,47.716236878008246,{"$error":"#REF!"},989298,267.08555444348002,238.58118439004124,{"$error":"#REF!"},"Ugandan shilling","UGX",{"$error":"#REF!"},"Rural Lake Victoria Basin"]
["Vietnam","Rural","Economic Zone 4","Living Wage Benchmark","Original 2016\nUpdate 2020",4,2,1.87,2020,7,3.2,97.28,85.169262298990986,2257710.0714666634,{"$error":"#REF!"},208.08556149732618,182.18024021174543,4829326.3560784245,{"$error":"#REF!"},389.12,340.67704919596395,9030840.2858666535,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"region 4","Wage Indicator",3070000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},5740900,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2020,"GLWC",4618167,198.98714694936575,174.21452007255752,{"$error":"#REF!"},8635972.290000001,372.10596479531398,325.78115253568257,{"$error":"#REF!"},2020,"Calculated from  GLWC",1932298.5,83.258696701426999,72.893521566981619,{"$error":"#REF!"},7729194,333.03478680570799,291.57408626792648,{"$error":"#REF!"},"Vietnamese dong","VND",{"$error":"#REF!"},"Rural Economic Zone 4"]
["Vietnam","Urban","Ho Chi Minh City","Living Wage Benchmark","Original 2016\nUpdate 2020",4,2,1.78,2020,7,3.2,97.28,85.169262298990986,2257710.0714666634,{"$error":"#REF!"},218.6067415730337,191.39160067188985,5073505.7785767717,{"$error":"#REF!"},389.12,340.67704919596395,9030840.2858666535,{"$error":"#REF!"},2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"region 1","Wage Indicator",4420000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},7867600,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"},2020,"GLWC",7446294,320.84521811493187,280.90204090262756,{"$error":"#REF!"},13254403.32,571.10448824457876,500.00563280667706,{"$error":"#REF!"},2020,"Calculated from  GLWC",2965673,127.78464032477959,111.87627004115311,{"$error":"#REF!"},11862692,511.13856129911835,447.50508016461242,{"$error":"#REF!"},"Vietnamese dong","VND",{"$error":"#REF!"},"Urban Ho Chi Minh City"]

{"sheet":"hide_FLIRP","index":12,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,"Commodity","Country","Fairtrade Living Income Reference Price per Kilo (USD)","Source","Text Ausgabe"]
[null,"Cocao","Cote d'Ivoire","2,2 USD","Link to study"," Cocao: 2.2 USD/kg"]
[null,"Cocao","Ghana","2,1 USD","https://files.fairtrade.net/2019_RevisedExplanatoryNote_FairtradeLivingIncomeReferencePriceCocoa.pdf","Cocoa: 2.1 USD/kg"]
[null,"Coffee","Colombia","in progress (Fairtrade minimum price = 2.8 USD)","https://www.fairtrade.at/fileadmin/AT/News/Aktuelles/Living_Income_Progress_Report_en.pdf","Coffee: In progress. FT Minumum Price: 2.8 USD/kg"]
[null,"Coffee","Indonesia","in progress","Living Income Progress Report_V5 (fairtrade.at)","Coffee: In progress."]
[null,"Vanilla","Uganda","17,3 USD","https://files.fairtrade.net/publications/Fairtrade_Vanilla_LivingIncomeReferencePrice_explanatorynote.pdf","Vanila: 17,3 USD/kg"]
[null,"Coffee","Ethiopia","in progress",null,"Coffee: In progress."]
[null,"Vanila ","Madagascar","18.4 USD","https://files.fairtrade.net/publications/Fairtrade_Vanilla_LivingIncomeReferencePrice_explanatorynote.pdf","Vanila: 18.4 USD/kg"]

{"sheet":"hide_Suchtabellen","index":13,"n_rows":42,"n_cols":49,"rows_kept":42,"cut":false,"hidden":true,"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","Other Country"]
["Argentina",null,"Urban",null,"Banana",null,"EUR",null,null,"Urban","Urban Satellite Cities and Districts Surrounding Dhaka","Urban Minas Gerais South/Southwestern Region","Rural","Rural","Non-Metropolitan Urban","Urban Zhengzhou","Urban-Rural Caribbean coast","Rural Limón and Heredia Provinces","Rural","Rural Northern Region","Rural Southern Coastal Region","Rural","Rural","Non-Metropolitan Urban Ziway Region","Peri-Urban Lower Volta Region","Rural Central Valley Area","Rural","Urban Tiruppur, Tamil Nadu","Rural Mount Kenya","Rural","Rural Southern Region","Non-metropolitan Urban & Rural Michoacán, northwestern regions","Rural","Rural","Urban Managua Free Trade Zone","Rural","Rural Sialkot","Rural","Rural","Rural","Rural","Rural Western Cape Province","Rural Estate Sector","Rural","Rural","Rural","Rural Lake Victoria Basin","Rural Economic Zone 4","Rural"]
["Bangladesh",null,"Rural",null,"Cocao",null,"LCU",null,null,"Rural","Urban Dhaka City","Non-metropolitan State of São Paulo, non-metropolitan areas",null,null,null,"Urban Chengdu",null,null,"Rural Cocoa growing areas",null,null,null,null,null,"Rural Cocoa growing areas of Ashanti, Central, Eastern, Western Regions",null,null,"Rural Bhadohi, Uttar Pradesh","Non-metropolitan Urban Lake Naivasha",null,null,null,null,null,"Rural-Urban Northwest",null,"Urban Sialkot",null,null,null,null,null,null,"Urban",null,null,null,"Urban Ho Chi Minh City","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban-Rural"]
["Burkina Faso",null,"Non-Metropolitan Urban",null,"Orange",null,null,null,null,null,null,null,null,null,null,"Urban Shanghai",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-metropolitan"]
["Cameroon",null,"Urban-Rural",null,"Palmoil",null,null,null,null,null,null,null,null,null,null,"Urban Shenzhen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peri-Urban"]
["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"]
["Costa Rica"]
["Cote d'Ivoire"]
["Dominican Republic",null,"Production Scenario"]
["Ecuador",null,"Business as ususal"]
["Egypt, Arab Rep.",null,"Good Agricultural Practices"]
["El Salvador",null,"Model data"]
["Ethiopia",null,"Other data"]
["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"]
["Other Country"]