{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Cover","Instructions","Country data","TechScope Inputs","Score","Report","Country Conversion&Calculation","Currency dropdown","GHG Calculator Cover","User Manual","Input Sheet I","Input Sheet II","GHG Report","SWH Goal Module","Back End Data & Calcs"],"not_rendered":{"charts":10,"images":11,"macros":1,"external_links":0,"defined_names":39,"comments":7,"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":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,2,4,7],[2,0,2,16383],[10,1,10,7],[5,1,5,7],[11,1,11,7]]}
[]
[]
[]
[]
[null,null,"TechScope"]
[null,"Solar Water Heating Market Readiness Analysis Tool"]
[null,null,null,null,"Version 2.0"]
[]
[]
[]
[null,"This tool allows users to evaluate the Solar Water Heating (SWH) market of any country by entering relevant data and calculating a TechScope score for the respective country. The tool is based on the SWH TechScope Market Readiness Assessment methodology, which provides stakeholders with the ability to benchmark and evaluate specific countries’ SWH support framework, national conditions, financing environment and business climate. The companion report provides a detailed explanation of the TechScope methodology and applies the methodology to the five countries receiving support under the GSWH project (Albania, Chile, Mexico, India, and Lebanon) and evaluates their experiences in establishing and growing a SWH market.  "]
[null,"Version 2.0 includes a greenhouse gas calculator tool to help quantify the GHG emissions reductions associated with SWH installations at various scales."]

{"sheet":"Instructions","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,5],[7,1,7,5],[0,0,0,5],[23,1,23,5],[5,1,5,5],[2,1,2,5],[14,1,14,5],[25,1,25,5],[15,1,15,5],[4,1,4,5]]}
["Instructions"]
[]
[null,"Overview"]
[]
[null,"This tool can be used to calculate the TechScope score for a given country. The tool should be used in conjunction with the guidance contained in the companion report: Solar Water Heating TechScope Market Readiness Assessment."]
[null,"The tool includes four sheets: two data input sheets (\"Country Data\" and \"TechScope Inputs\") and two output sheets (\"Score\" and \"Report\"). To calculate a TechScope score for a country, complete the data entry sheets as described below."]
[]
[null,"Entering data"]
[]
[null,"TechScope scores are based on 18 indicators spread across the following 4 parameters: "]
[null,null,"Parameter I: Solar Water Heating Support Framework"]
[null,null,"Parameter II: National Conditions"]
[null,null,"Parameter III: Financing"]
[null,null,"Parameter IV: Business Climate"]
[null,"In order to calculate a TechScope Score, this tool requires users to enter data for the country in question. To support data collection, when possible, links to data sources for required data fields are provided in the tool. In addition, instructions for data collection are included as comments for some data fields. In some instances, the user is responsible for finding the appropriate information to answer the question associated with the indicator.\nNote that if any data points are unavailable for a given country, it may not be possible to calculate a TechScope score. In this event, users may wish to consider alternative data sources or identify suitable proxy data."]
[null,"Throughout the input sheets, color-coded shading is used to indicate which cells will accept data entry. Note that input cells are differentiated between optional and mandatory. Optional cells are used when generating a summary report but are not required to calculate a SWH TechScope score."]
[null,null,"Legend:"]
[null,null,"No input"]
[null,null,"Calculated"]
[null,null,"Input field (optional)","<-- Required to generate printable report"]
[null,null,"Input field (mandatory)","<-- Required to calculate TechScope Index scores"]
[]
[]
[null,"Viewing and printing results"]
[]
[null,"Results can be viewed in a simple summary table showing the final scores for each indicator (see \"Score\" sheet). The tool can also be used to generate a summary report which provides relevant country data as well as a visually informative overview of each indicator's input value(s) and resulting score (see \"Report\" sheet). The Report is designed to serve as a printable or publishable summary document of the data and resulting score."]
[null,"Note that mandatory data (blue cells) is required to calculate TechScope scores. Missing data means a TechScope score cannot be calculated. Optional data (orange cells) is not used to calculate TechScope scores but is presented in the summary report."]

{"sheet":"Country data","index":2,"n_rows":42,"n_cols":41,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,0,38,4],[1,8,1,9],[2,8,2,9],[36,1,36,2],[22,1,22,3],[32,0,32,4]]}
["COUNTRY DATA",null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,"No input","Input field (optional)"]
["Country Name",null,null,null,null,null,null,"Calculated","Input field (mandatory)"]
[]
[]
[1,"Socio-economic data"]
[]
["1a","Data Description","Data Source","Unit",{"$f":"F8-1","v":2009},2010,2011,2012,{"$f":"J8-1","v":2013},{"$f":"YEAR(TODAY())-1","v":2014}]
[null,"Population","World Bank","#"]
[null,"GDP","World Bank"]
[]
[]
[2,"Energy data"]
[]
["2a","Balance indicators"]
[]
[null,"Data Description","Data Source","Unit",{"$f":"F17-1","v":2009},2010,2011,{"$f":"I17-1","v":2012},{"$f":"J17-1","v":2013},{"$f":"YEAR(TODAY())-1","v":2014},{"$f":"E17&\"-\"&J17","v":"2009-2014"}]
[null,"Energy Production","IEA: Indicators","Mtoe"]
[null,"Residential Energy Consumption","IEA: Balances","Ktoe"]
[null,null,null,null,null,{"$f":"IF(OR(ISBLANK(F19),ISBLANK(G19)),\"\",(G19-F19)/F19)","v":""},{"$f":"IF(OR(ISBLANK(G19),ISBLANK(H19)),\"\",(H19-G19)/G19)","v":""},{"$f":"IF(OR(ISBLANK(H19),ISBLANK(I19)),\"\",(I19-H19)/H19)","v":""},{"$f":"IF(OR(ISBLANK(I19),ISBLANK(J19)),\"\",(J19-I19)/I19)","v":""},{"$f":"IF(OR(ISBLANK(J19),ISBLANK(#REF!)),\"\",(#REF!-J19)/J19)","v":""}]
[null,"Average Year-on-Year Growth in Residential Energy Consumption",null,null,null,{"$f":"(F19-E19)/E19","v":{"$error":"#DIV/0!"}},{"$f":"(G19-F19)/F19","v":{"$error":"#DIV/0!"}},{"$f":"(H19-G19)/G19","v":{"$error":"#DIV/0!"}},{"$f":"(I19-H19)/H19","v":{"$error":"#DIV/0!"}},{"$f":"(J19-I19)/I19","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F21:J21)","v":{"$error":"#DIV/0!"}}]
[]
["2b","Primary Fuels for Residential Heating1"]
[]
[null,"Heating Fuel","% of Total Heating","Average retail price of primary heating fuel ($/kWhth)"]
[null,"Oil",null,null,{"$f":"IF(MAX(C$26:C$30)=C26,\"Required\",\"\")","v":"Required"},{"$f":"D26","v":0}]
[null,"Natural Gas",null,null,"Required",{"$f":"D27","v":0}]
[null,"Electricity",null,null,{"$f":"IF(MAX(C$26:C$30)=C28,\"Required\",\"\")","v":"Required"},0]
[null,"Wood",null,null,{"$f":"IF(MAX(C$26:C$30)=C29,\"Required\",\"\")","v":"Required"},0]
[null,"Other",null,null,"Required",0]
[null,"Total",{"$f":"SUM(C26:C30)","v":0}]
[]
["1User is responsible for finding and entering the data. Appropriate data source will depend on country and is at the discretion of the user.Enter data for most recent year available"]
[]
[]
[]
["2c","Generation cost of primary heating fuel ($/kWh)1"]
["1User is responsible for finding and entering the data. Appropriate data source will depend on country and is at the discretion of the user.Enter data for most recent year available"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Year","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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM$3<=#REF!,$F42,0)","v":{"$error":"#REF!"}},{"$f":"IF(AN$3<=#REF!,$F42,0)","v":{"$error":"#REF!"}},{"$f":"IF(AO$3<=#REF!,$F42,0)","v":{"$error":"#REF!"}}]

{"sheet":"TechScope Inputs","index":3,"n_rows":134,"n_cols":42,"rows_kept":134,"cut":false,"hidden":false,"merged":[[1,10,2,10],[54,3,56,3],[52,3,53,3],[65,7,65,9],[122,2,122,6],[12,2,12,6],[20,2,20,6],[16,2,16,6],[24,2,24,6],[45,8,45,10]]}
["SOLAR HOT WATER MARKET DATA",null,null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,"No input","Input field (optional)","Reference to section of companion report","These columns will be hidden ----->"]
["Country Name",null,null,{"$f":"'Country data'!C3","v":0},null,null,null,null,"Calculated","Input field (mandatory)"]
[]
[1,null,"Parameter I: Solar Water Heating Support Framework"]
[]
["1a",null,"SWH Targets"]
[]
[null,null,"Has the country established a solar thermal target?"]
[]
["1b",null,"Financial Incentives for System Installation"]
[]
[null,null,"Does the country offer financial or fiscal incentives for SWH system installation? These may include, for example, direct cash payments (e.g. grants, rebates, performance-based incentives, and feed-in tariffs) or tax incentives (e.g. tax credits, income tax deductions, etc.)"]
[]
["1c",null,"SWH Loan Programs"]
[]
[null,null,"Does the country offer loan policies or programs supporting SWH system installation, such as low-interest loan programs, interest rate buy-down programs, and loan loss reserves?"]
[]
["1d",null,"Building Mandates"]
[]
[null,null,"Does the country require that solar heating (or renewable heating more broadly) be integrated into new construction and/or major renovations of buildings?",null,null,null,null,null,null,null,null,"Mandate policy types"]
[]
["1e",null,"Outreach Campaigns"]
[]
[null,null,"Are there any government-led or government-supported campaigns to raise awareness about solar heating in place?"]
[]
[]
[2,null,"Parameter II: National Conditions"]
[]
["2a",null,"Insolation"]
[]
[null,null,"Data Description","Data Source","Unit","Value","Tier"]
[null,null,"Solar Insolation","Clean Energy Solutions Center’s Global RE Opportunity Tool","Average Solar Resource (kWh/m2/day)",null,{"$f":"VLOOKUP(F33,L33:M43,2,FALSE)","v":{"$error":"#N/A"}},null,"Note: Enter data for most recent year available.",null,null,"Average Solar Resource (kWh/m2/day)","Tier"]
[null,null,null,null,null,null,null,null,null,null,null,"<2.5",0,null,null,2.5]
["2b",null,"SWH Market Penetration",null,null,null,null,null,null,null,null,"2.5-3.0",1]
[null,null,null,null,null,null,null,null,null,null,null,"3.0-3.5",2]
[null,null,"Data Description","Data Source","Unit","Value",null,null,null,null,null,"3.5-4.0",3]
[null,null,"SWH Market penetration per 1000 people","IEA Solar Heating & Cooling Programme Annual Report","kWth/1000 people",null,null,null,"Note: Enter data for most recent year available.",null,null,"4.0-4.5",4]
[null,null,null,null,null,null,null,null,null,null,null,"4.5-5.0",5]
["2c",null,"Residential Energy Consumption Growth",null,null,null,null,null,null,null,null,"5.0-5.5",6]
[null,null,null,null,null,null,null,null,null,null,null,"5.5-6.0",7]
[null,null,"Data Description","Data Source","Unit","Value",null,null,null,null,null,"6.0-6.5",8]
[null,null,"Residential Energy Consumption Growth","(Calculated from \"Country Data\", Section 2a).","%/year",{"$f":"'Country data'!K21","v":{"$error":"#DIV/0!"}},null,null,"Note: Based on data entered on \"Country Data\" sheet.",null,null,"6.5+",9]
[]
["2d",null,"SWH Market Growth"]
[null,null,null,null,null,null,null,null,"Note: Data  for the year of interest is published two years  after the fact (e.g. 2007 data is in the 2009 report)"]
[null,null,"SWH installed capacity ","Data Source","Unit",2007,2008,2009,2010,2011,2012,"Growth Rate from","To","Score","Score Achieved"]
[null,null,"Total","IEA Solar Heating & Cooling Programme Annual Reports (2007-2013)","MWth",null,null,null,null,null,null,-999999,0,0,{"$f":"IF(AND($D$55>=L48,$D$55<M48),N48,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,"Annual market growth","(Calculated)","%",null,{"$f":"IF(OR(ISBLANK(F48),ISBLANK(G48)),\"\",(G48-F48)/F48)","v":""},{"$f":"IF(OR(ISBLANK(G48),ISBLANK(H48)),\"\",(H48-G48)/G48)","v":""},"","",{"$f":"IF(OR(ISBLANK(J48),ISBLANK(K48)),\"\",(K48-J48)/J48)","v":""},0,0.03,1,{"$f":"IF(AND($D$55>=L49,$D$55<M49),N49,\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,0.03,0.06,2,{"$f":"IF(AND($D$55>=L51,$D$55<M51),N51,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0.06,0.1,3,{"$f":"IF(AND($D$55>=L52,$D$55<M52),N52,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Average Annual Market Growth",null,null,null,null,null,null,null,0.1,0.15,4,{"$f":"IF(AND($D$55>=L53,$D$55<M53),N53,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0.15,1000000,5,{"$f":"IF(AND($D$55>=L54,$D$55<M54),N54,\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(G49:K49)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["2e",null,"SWH Competitiveness: Payback Period"]
[]
[null,null,"Data Description","Data Source","Unit","Value",null,"For RETScreen Input \"Fuel Rate\", use the following value:"]
[null,null,"Payback period","(Calculated using RETScreen v4 and country-specific data)","Years",null,null,{"$f":"'Country data'!D37","v":0},"Note: Data entry required on \"Country Data\" sheet, section 2b.",null,null,"Payback from","To","Score","Score Achieved"]
[null,null,null,null,null,null,null,null,null,null,null,12,100000,0,{"$f":"IF(ISBLANK($F$67),\"\",IF(AND($F$67>=L68,$F$67<M68),N68,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,10,12,1,""]
["2f",null,"SWH Competitiveness: Heating Fuel Subsidies",null,null,null,null,null,null,null,null,8,10,2,""]
[null,null,null,null,null,null,null,null,null,null,null,5,8,3,""]
[null,null,"Are subsidies available which reduce the price of conventional residential heating?",null,null,null,null,null,null,null,null,2,5,4,""]
[null,null,null,null,null,null,null,null,null,null,null,-10000000,2,5,""]
[]
[3,null,"Parameter III: Financing",null,null,null,null,null,null,null,null,"Moody's","Standard & Poor’s","Score"]
[null,null,null,null,null,null,null,null,null,null,null,"Aaa, Aaa1, Aaa2, Aaa3","AAA, AAA-, AA+",5]
["3a",null,"Country Credit Rating",null,null,null,null,null,null,null,null,"Aa, Aa1, Aa2, Aa3","AA, AA-, A+",4]
[null,null,null,null,null,null,null,null,null,null,null,"A, A1, A2, A3","A, A-, BBB+",3]
[null,null,"Data Description","Data Source","Value","Score",null,null,null,null,null,"Baa, Baa1, Baa2, Baa3","BBB, BBB-, BB+",2]
[null,null,"Moody's Credit Rating","Trading Economics",null,{"$f":"VLOOKUP(E80,L76:N82,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,"Ba, Ba1, Ba2, Ba3","BB, BB-, B+",1]
[null,null,"S&P Credit Rating","Trading Economics",null,{"$f":"VLOOKUP(E81,M75:N82,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,"B, B1, B2, B3","B, B-, CCC+",0.5]
[null,null,"Average",null,null,{"$f":"AVERAGE(F80:F81)","v":{"$error":"#N/A"}},null,null,null,null,null,"Caa, Caa1, Caa2, Caa3 or below","CCC, CCC-, CC+ or below",0]
[]
["3b",null,"Access to Finance",null,null,null,null,null,null,null,null,"Real Interest Rate",null,"Score","Score Achieved"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M86","v":0.25},100,0,{"$f":"IF(OR(ISBLANK($E$88),ISBLANK($F$88),ISBLANK($G$88)),\"\",IF(AND(AVERAGE($E$88:$G$88)>=L85,AVERAGE($E$88:$G$88)<M85),N85,\"\"))","v":""}]
[null,null,"Data Description","Data Source",2010,2011,2012,"Score",null,null,null,0.15,0.25,1,""]
[null,null,"Domestic Credit Provided by the Banking Sector (% of GDP)","World Bank",null,null,null,{"$f":"SUM(O93:O98)","v":0},null,null,null,0.1,0.15,2,""]
[null,null,"Real Interest Rate (%)","World Bank",null,null,null,{"$f":"SUM(O85:O91)","v":0},null,null,null,{"$f":"M89","v":0.05},0.1,3,""]
[null,null,"Average",null,null,null,null,{"$f":"AVERAGE(H87:H88)","v":0},null,null,null,0.01,0.05,4,""]
[null,null,null,null,null,null,null,null,null,null,null,0,0.01,5,""]
[null,null,null,null,null,null,null,null,null,null,null,-100,0,0,""]
[null,null,null,null,"Note: Enter values as percentages",null,null,null,null,null,null,"Domestic Credit",null,"Score","Score Achieved"]
[null,null,null,null,null,null,null,null,null,null,null,-100,0.05,0,{"$f":"IF(OR(ISBLANK($E$87),ISBLANK($F$87),ISBLANK($G$87)),\"\",IF(AND(AVERAGE($E$87:$G$87)>=L93,AVERAGE($E$87:$G$87)<M93),N93,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,0.05,0.25,1,""]
[4,null,"Parameter IV: Business Climate",null,null,null,null,null,null,null,null,{"$f":"M94","v":0.25},0.5,2,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M95","v":0.5},0.75,3,""]
["4a",null,"Doing Business Index",null,null,null,null,null,null,null,null,0.75,1.25,4,""]
[null,null,null,null,null,null,null,null,null,null,null,1.25,100,5,""]
[null,null,"Data Description","Data Source","Ranking","Percentile",null,null,null,null,null,"From","To","Score","Score Achieved"]
[null,null,"Doing Business Index ","World Bank",null,{"$f":"1-(E100/185)","v":1},null,null,"Note: Enter data for most recent year available.",null,null,0,0.2,1,{"$f":"IF(ISBLANK($E$100),\"\",IF(AND($F$100>=L100,$F$100<M100),N100,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,0.2,0.4,2,{"$f":"IF(ISBLANK($E$100),\"\",IF(AND($F$100>=L101,$F$100<M101),N101,\"\"))","v":""}]
["4b",null,"Manufacturing Capacity",null,null,null,null,null,null,null,null,0.4,0.6,3,""]
[null,null,null,null,null,null,null,null,null,null,null,0.6,0.8,4,""]
[null,null,"Data Description","Data Source","Value",null,null,null,null,null,null,0.8,1,5,""]
[null,null,"MVA as percentage of GDP at constant 2005 prices in US$","UNIDO",null,null,null,null,"Note: Enter data for most recent year available."]
[null,null,null,null,null,null,null,null,null,null,null,"MVA as percentage of GDP"]
["4c",null,"Product Standards and Certification",null,null,null,null,null,null,null,null,"at constant 2005 prices in US$","Score"]
[null,null,null,null,null,null,null,null,null,null,null,"0-2%",0]
[null,null,"What standards or certification infrastructure are currently in place? Please check all that apply.",null,null,null,null,null,null,null,null,">2-4%",1]
[null,null,null,"Existence of a national standards entity",null,null,null,null,null,null,null,">4-8%",2]
[null,null,null,"Solar thermal equipment standards exist",null,null,null,null,null,null,null,">8-12%",3]
[null,null,null,"Domestic solar thermal testing facilities are available",null,null,null,null,null,null,null,">12-17%",4]
[null,null,null,"Solar thermal product national certification has been introduced ",null,null,null,null,null,null,null,">17%",5]
[null,null,null,"Solar thermal products regional or international certification is introduced",null,null,null,null,null,null,null,false,{"$f":"IF(L114,1,0)","v":0},{"$f":"SUM(M$114:M114)*PRODUCT(M$114:M114)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false,0,{"$f":"SUM(M$114:M115)*PRODUCT(M$114:M115)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false,0,{"$f":"SUM(M$114:M116)*PRODUCT(M$114:M116)","v":0}]
["4d",null,"Installer Certification",null,null,null,null,null,null,null,null,false,0,{"$f":"SUM(M$114:M117)*PRODUCT(M$114:M117)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false,0,{"$f":"SUM(M$114:M118)*PRODUCT(M$114:M118)","v":0}]
[null,null,"Is there a national certification system in place for either individual installers or installation companies?"]
[]
["4e",null,"Industry Association"]
[]
[null,null,"Is there a solar thermal industry association? For the purpose of this analysis, we define an active industry association as one that represents more than half of the solar thermal industry and is pursuing industry objectives such as policy lobbying, capacity building or training. "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Year","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,null,null,null,null,null,null,null,null,null,null,null,null,null,33,34,35]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!<=$G129,$G132,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<=$G129,$G132,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<=$G129,$G132,0)","v":{"$error":"#REF!"}}]

{"sheet":"Score","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,1,19,1],[15,2,19,2],[2,1,6,1],[2,2,6,2],[7,1,12,1],[7,2,12,2],[13,1,14,1],[13,2,14,2]]}
[]
[null,"Parameter","Parameter Weight  ","Indicator Weight ","Indicator","Raw Score","Weighted Score"]
[null,"I. Solar Water Heating Support Framework",0.28999999999999998,0.05,"SWH Targets",{"$f":"IF('TechScope Inputs'!H9=\"Yes\",5,0)","v":0},{"$f":"F3*D3","v":0}]
[null,null,null,0.08,"Financial Incentives for System Installation",{"$f":"IF('TechScope Inputs'!H13=\"Yes\",5,0)","v":0},0]
[null,null,null,7.0000000000000007E-2,"SWH Loan Programs",{"$f":"IF('TechScope Inputs'!H17=\"Yes\",5,0)","v":0},0]
[null,null,null,0.05,"Building Mandates",{"$f":"IF('TechScope Inputs'!H21=\"National\",5,IF('TechScope Inputs'!H21=\"Subnational\",2.5,0))","v":0},0]
[null,null,null,0.04,"Outreach Campaigns",{"$f":"IF('TechScope Inputs'!H25=\"Yes\",5,0)","v":0},0]
[null,"II. National Conditions",0.3,0.05,"Insolation",{"$f":"('TechScope Inputs'!G33/9)*5","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,0.04,"SWH Market Penetration",{"$f":"'TechScope Inputs'!F38/268.2*5","v":0},0]
[null,null,null,0.05,"Residential Energy Consumption Growth ",{"$f":"MIN(5,'TechScope Inputs'!F43/0.025*5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,0.04,"SWH Market Growth",{"$f":"SUM('TechScope Inputs'!O48:O54)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,7.0000000000000007E-2,"SWH Competitiveness: Payback Period",{"$f":"SUM('TechScope Inputs'!O68:O73)","v":0},0]
[null,null,null,0.05,"SWH Competitiveness: Heating Fuel Subsidy",{"$f":"IF('TechScope Inputs'!G72=\"Yes\",0,5)","v":5},0.25]
[null,"III. Financing",0.2,0.05,"Country Credit Rating",{"$f":"'TechScope Inputs'!F82","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,0.15,"Access to Finance",{"$f":"'TechScope Inputs'!H89","v":0},0]
[null,"IV. Business Climate",0.21,0.05,"Doing Business Index",{"$f":"SUM('TechScope Inputs'!O100:O104)","v":0},0]
[null,null,null,0.03,"Manufacturing Capacity",{"$f":"VLOOKUP('TechScope Inputs'!E105,'TechScope Inputs'!L108:M113,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,0.05,"Product Standards and Certification",{"$f":"MAX('TechScope Inputs'!N114:N118)","v":0},0]
[null,null,null,0.04,"Installer Certification",{"$f":"IF('TechScope Inputs'!H119=\"Yes\",5,0)","v":0},0]
[null,null,null,0.04,"Industry Association",{"$f":"IF('TechScope Inputs'!H123=\"Yes\",5,0)","v":0},0]
[null,null,null,null,null,5]
[]
[null,null,null,null,null,"Overall Score",{"$f":"SUM(G3:G20)","v":{"$error":"#N/A"}}]

{"sheet":"Report","index":5,"n_rows":185,"n_cols":14,"rows_kept":185,"cut":false,"hidden":false,"merged":[[144,11,144,12],[145,11,145,12],[146,11,146,12],[184,6,184,7],[184,12,184,13],[162,4,162,5],[163,4,163,5],[156,2,157,3],[158,2,162,3],[163,1,163,3],[157,4,157,5],[158,4,158,5],[159,4,159,5],[160,4,160,5],[161,4,161,5],[163,11,163,12],[156,6,156,10],[157,6,157,10],[158,6,158,10],[159,6,159,10],[160,6,160,10],[161,6,161,10],[162,6,162,10],[163,6,163,10],[144,6,144,10],[145,6,145,10],[146,6,146,10],[147,6,147,10],[148,6,148,10],[149,6,149,10],[150,6,150,10],[151,6,151,10],[152,6,152,10],[161,11,161,12],[162,11,162,12],[153,11,153,12],[154,11,154,12],[155,11,155,12],[156,11,156,12],[157,11,157,12],[156,4,156,5],[153,6,153,10],[154,6,154,10],[155,6,155,10],[155,4,155,5],[158,11,158,12],[159,11,159,12],[160,11,160,12],[147,11,147,12],[148,11,148,12],[149,11,149,12],[150,11,150,12],[151,11,151,12],[152,11,152,12],[144,4,144,5],[158,1,162,1],[144,2,144,3],[145,1,149,1],[150,1,155,1],[156,1,157,1],[150,2,155,3],[153,4,153,5],[154,4,154,5],[151,4,151,5],[152,4,152,5],[149,4,149,5],[150,4,150,5],[145,4,145,5],[145,2,149,3],[146,4,146,5],[147,4,147,5],[148,4,148,5],[42,3,42,9],[41,3,41,9],[79,5,79,8],[79,9,79,11],[79,2,79,4],[86,2,86,3],[86,4,86,5],[86,6,86,7],[86,8,86,9],[86,10,86,11],[1,10,1,13],[78,2,78,4],[78,5,78,8],[78,9,78,11],[56,1,56,13],[51,6,51,7],[3,1,3,13],[51,12,51,13],[83,3,83,4],[83,5,83,6],[83,7,83,8],[83,9,83,10],[82,3,82,4],[82,5,82,6],[82,7,82,8],[82,9,82,10],[44,3,44,9],[45,3,45,9],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[43,3,43,9],[91,12,91,13],[96,1,96,13],[94,10,94,13],[87,2,87,3],[87,4,87,5],[87,6,87,7],[87,8,87,9],[87,10,87,11],[111,8,111,11],[91,6,91,7],[107,8,107,10],[177,1,177,13],[178,1,178,13],[179,1,179,13],[180,1,180,13],[167,1,167,13],[101,13,103,13],[101,12,103,12],[107,12,109,12],[107,13,109,13],[122,2,122,3],[122,4,122,5],[122,6,122,7],[122,8,122,9],[122,10,122,11],[126,13,130,13],[136,6,136,7],[136,12,136,13],[139,10,139,13],[141,1,141,13],[123,2,123,3],[123,4,123,5],[123,6,123,7],[123,8,123,9],[123,10,123,11]]}
[null,"Techscope Report",null,null,null,null,null,null,null,null,"Country:"]
[null,"Solar Thermal Market Analysis",null,null,null,null,null,null,null,null,{"$f":"'Country data'!C3","v":0}]
[]
[null,"COUNTRY TRENDS"]
[]
[null,"POPULATION",null,null,null,null,null,"GDP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ENERGY PRODUCTION",null,null,null,null,null,"RESIDENTIAL ENERGY CONSUMPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PRIMARY FUELS FOR RESIDENTIAL HEATING"]
[]
[null,"Fuel",null,"% of total",null,"% of total",null,null,null,null,null,null,null,"Average Retail Price ($/kWhth)"]
[]
[null,{"$f":"'Country data'!B26","v":"Oil"},null,{"$f":"'Country data'!C26","v":0},null,null,null,null,null,null,null,{"$f":"'Country data'!D26","v":0}]
[null,{"$f":"'Country data'!B27","v":"Natural Gas"},null,{"$f":"'Country data'!C27","v":0},null,null,null,null,null,null,null,{"$f":"'Country data'!D27","v":0}]
[null,{"$f":"'Country data'!B28","v":"Electricity"},null,{"$f":"'Country data'!C28","v":0},null,null,null,null,null,null,null,{"$f":"'Country data'!D28","v":0}]
[null,{"$f":"'Country data'!B29","v":"Wood"},null,{"$f":"'Country data'!C29","v":0},null,null,null,null,null,null,null,{"$f":"'Country data'!D29","v":0}]
[null,{"$f":"'Country data'!B30","v":"Other"},null,{"$f":"'Country data'!C30","v":0},null,null,null,null,null,null,null,{"$f":"'Country data'!D30","v":0}]
[]
[]
[]
[]
[]
[null,"TechScope Summary Report",null,null,null,null,"- 1 -",null,null,null,null,"Date Prepared:",{"$f":"TODAY()","v":"2015-11-09"}]
[]
[null,"Techscope Report",null,null,null,null,null,null,null,null,"Country:"]
[null,"Solar Thermal Market Analysis",null,null,null,null,null,null,null,null,{"$f":"K2","v":0}]
[]
[null,"SOLAR HOT WATER MARKET DATA"]
[]
[null,"Parameter I: Solar Water Heating Support Framework",null,null,null,null,null,null,null,null,null,null,null,"Score"]
[]
[null,"þ","1a. SWH targets",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F3","v":0}]
[null,"þ","1b. Financial incentives for system installation",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F4","v":0}]
[null,"þ","1c. SWH loan programs for system installation",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F5","v":0}]
[null,"þ","1d. Required SWH for new construction and renovations",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F6","v":0}]
[null,"þ","1e. Government-sponsored awareness campaigns",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F7","v":0}]
[]
[null,"Parameter II: National Conditions",null,null,null,null,null,null,null,null,null,null,null,"Score"]
[]
[null,null,"2a. Insolation"]
[null,{"$f":"'TechScope Inputs'!F33","v":0},{"$f":"IF($B70=C71,1,0)","v":0},{"$f":"IF($B70=D71,1,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"Score!F8","v":{"$error":"#N/A"}}]
[null,"kWh/m2/day",{"$f":"'TechScope Inputs'!L34","v":"<2.5"},{"$f":"'TechScope Inputs'!L35","v":"2.5-3.0"},{"$f":"'TechScope Inputs'!L36","v":"3.0-3.5"},{"$f":"'TechScope Inputs'!L37","v":"3.5-4.0"},{"$f":"'TechScope Inputs'!L38","v":"4.0-4.5"},{"$f":"'TechScope Inputs'!L39","v":"4.5-5.0"},{"$f":"'TechScope Inputs'!L40","v":"5.0-5.5"},{"$f":"'TechScope Inputs'!L41","v":"5.5-6.0"},{"$f":"'TechScope Inputs'!L42","v":"6.0-6.5"},{"$f":"'TechScope Inputs'!L43","v":"6.5+"}]
[]
[null,null,"2b. SWH Market Penetration"]
[null,{"$f":"'TechScope Inputs'!F38","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F9","v":0}]
[null,"kWth/1000 people"]
[]
[]
[null,null,"2c. Residential Energy Consumption Growth"]
[null,{"$f":"'TechScope Inputs'!F43","v":{"$error":"#DIV/0!"}},{"$f":"IF(B79<=0,1,0)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(AND($B79>0,$B79<0.025),1,0)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(B79>=0.025,1,0)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"Score!F10","v":{"$error":"#DIV/0!"}}]
[null,"%/yr","≤ 0%",null,null,"0 - 2.5%",null,null,null,"≥ 2.5%"]
[]
[null,null,"2d. SWH Market Growth"]
[null,{"$f":"'TechScope Inputs'!D55","v":{"$error":"#DIV/0!"}},{"$f":"IF(N83=0,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(N83=1,1,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(N83=2,1,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(N83=3,1,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(N83=4,1,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(N83=5,1,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"Score!F11","v":{"$error":"#DIV/0!"}}]
[null,"%/yr","< 0%","0 - 3%",null,"3 - 6%",null,"6 - 10%",null,"10 - 15%",null,"≥ 15%"]
[]
[null,null,"2e. SWH Competitiveness: Payback Period"]
[null,{"$f":"'TechScope Inputs'!F67","v":0},{"$f":"IF($N87=1,1,0)","v":0},null,{"$f":"IF($N87=2,1,0)","v":0},null,{"$f":"IF($N87=3,1,0)","v":0},null,{"$f":"IF($N87=4,1,0)","v":0},null,{"$f":"IF($N87=5,1,0)","v":0},null,null,{"$f":"Score!F12","v":0}]
[null,"Years","≤ 10",null,"8 - 10",null,"5 - 8",null,"2 - 5",null,"< 2"]
[]
[null,"þ","2f. SWH Competitiveness: Heating Fuel Subsidy",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F13","v":5}]
[]
[null,"TechScope Summary Report",null,null,null,null,"- 2 -",null,null,null,null,"Date Prepared:",{"$f":"TODAY()","v":"2015-11-09"}]
[]
[null,"Techscope Report",null,null,null,null,null,null,null,null,"Country:"]
[null,"Solar Thermal Market Analysis",null,null,null,null,null,null,null,null,{"$f":"K2","v":0}]
[]
[null,"SOLAR HOT WATER MARKET DATA"]
[]
[null,"Parameter III: Financing",null,null,null,null,null,null,null,null,null,null,null,"Score"]
[]
[null,null,"3a. Country Credit Rating"]
[null,{"$f":"'TechScope Inputs'!E80","v":0},{"$f":"IF(C103=$B102,1,0)","v":1},{"$f":"IF(D103=$B102,1,0)","v":0},0,0,0,0,0,0,"Moody's",null,null,{"$f":"Score!F14","v":{"$error":"#N/A"}}]
[null,null,{"$f":"'TechScope Inputs'!L83","v":0},{"$f":"'TechScope Inputs'!L82","v":"Caa, Caa1, Caa2, Caa3 or below"},{"$f":"'TechScope Inputs'!L81","v":"B, B1, B2, B3"},{"$f":"'TechScope Inputs'!L80","v":"Ba, Ba1, Ba2, Ba3"},{"$f":"'TechScope Inputs'!L79","v":"Baa, Baa1, Baa2, Baa3"},{"$f":"'TechScope Inputs'!L78","v":"A, A1, A2, A3"},{"$f":"'TechScope Inputs'!L77","v":"Aa, Aa1, Aa2, Aa3"},{"$f":"'TechScope Inputs'!L76","v":"Aaa, Aaa1, Aaa2, Aaa3"}]
[null,{"$f":"'TechScope Inputs'!E81","v":0},{"$f":"IF(C105=$B104,1,0)","v":1},0,0,0,0,0,0,0,"S&P"]
[null,null,{"$f":"'TechScope Inputs'!M83","v":0},{"$f":"'TechScope Inputs'!M82","v":"CCC, CCC-, CC+ or below"},{"$f":"'TechScope Inputs'!M81","v":"B, B-, CCC+"},{"$f":"'TechScope Inputs'!M80","v":"BB, BB-, B+"},{"$f":"'TechScope Inputs'!M79","v":"BBB, BBB-, BB+"},{"$f":"'TechScope Inputs'!M78","v":"A, A-, BBB+"},{"$f":"'TechScope Inputs'!M77","v":"AA, AA-, A+"},{"$f":"'TechScope Inputs'!M76","v":"AAA, AAA-, AA+"}]
[]
[null,null,"3b. Access to Finance"]
[null,{"$f":"AVERAGE('TechScope Inputs'!E87:G87)","v":{"$error":"#DIV/0!"}},{"$f":"IF('TechScope Inputs'!$H$87=0,1,0)","v":1},{"$f":"IF('TechScope Inputs'!$H$87=1,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$87=2,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$87=3,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$87=4,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$87=5,1,0)","v":0},"Domestic Credit",null,null,null,null,{"$f":"Score!F15","v":0}]
[null,null,"< 5%","5 - 25%","25 - 50%","50 - 75%","75 - 125%","> 125%","Provided by the "]
[null,null,null,null,null,null,null,null,"Banking Sector"]
[null,null,null,null,null,null,null,null,"(% of GDP)"]
[null,{"$f":"AVERAGE('TechScope Inputs'!E88:G88)","v":{"$error":"#DIV/0!"}},{"$f":"IF('TechScope Inputs'!$H$88=0,1,0)","v":1},{"$f":"IF('TechScope Inputs'!$H$88=1,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$88=2,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$88=3,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$88=4,1,0)","v":0},{"$f":"IF('TechScope Inputs'!$H$88=5,1,0)","v":0},"Real Interest Rate"]
[null,null,"< 0%","> 25%","15 - 25%","10 - 15%","5 - 10%","0 - 5%"]
[]
[null,"Parameter IV: Business Climate",null,null,null,null,null,null,null,null,null,null,null,"Score"]
[]
[null,null,"4a. Doing Business Index"]
[null,{"$f":"'TechScope Inputs'!E100","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F16","v":0}]
[null,"Country Rank"]
[]
[]
[null,null,"4b.Manufacturing Capacity"]
[null,{"$f":"'TechScope Inputs'!E105","v":0},{"$f":"IF($N123=1,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF($N123=2,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF($N123=3,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF($N123=4,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF($N123=5,1,0)","v":{"$error":"#N/A"}},null,null,{"$f":"Score!F17","v":{"$error":"#N/A"}}]
[null,null,{"$f":"'TechScope Inputs'!L109","v":">2-4%"},null,{"$f":"'TechScope Inputs'!L110","v":">4-8%"},null,{"$f":"'TechScope Inputs'!L111","v":">8-12%"},null,{"$f":"'TechScope Inputs'!L112","v":">12-17%"},null,{"$f":"'TechScope Inputs'!L113","v":">17%"}]
[]
[null,null,"4c. Product Standards and Certification"]
[null,"þ","Existence of a national standards entity",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F18","v":0}]
[null,"þ","Solar thermal equipment standards exist"]
[null,"þ","Domestic solar thermal testing facilities are available"]
[null,"þ","Solar thermal product national certification has been introduced "]
[null,"þ","Solar thermal products regional or international certification is introduced"]
[]
[null,"þ","4d. Installer Certification",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F19","v":0}]
[]
[null,"þ","4e. Industry Association",null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F20","v":0}]
[]
[null,"TechScope Summary Report",null,null,null,null,"- 3 -",null,null,null,null,"Date Prepared:",{"$f":"TODAY()","v":"2015-11-09"}]
[]
[null,"Techscope Report",null,null,null,null,null,null,null,null,"Country:"]
[null,"Solar Thermal Market Analysis",null,null,null,null,null,null,null,null,{"$f":"K95","v":0}]
[]
[null,"SUMMARY OF RESULTS"]
[]
[]
[null,"Parameter","Parameter Weight  ",null,"Indicator Weight ",null,"Indicator",null,null,null,null,"Raw Score",null,"Weighted Score"]
[null,"I. Solar Water Heating Support Framework",{"$f":"Score!C3","v":0.28999999999999998},null,{"$f":"Score!D3","v":0.05},null,{"$f":"Score!E3","v":"SWH Targets"},null,null,null,null,{"$f":"Score!F3","v":0},null,{"$f":"Score!G3","v":0}]
[null,null,null,null,{"$f":"Score!D4","v":0.08},null,{"$f":"Score!E4","v":"Financial Incentives for System Installation"},null,null,null,null,{"$f":"Score!F4","v":0},null,{"$f":"Score!G4","v":0}]
[null,null,null,null,{"$f":"Score!D5","v":7.0000000000000007E-2},null,{"$f":"Score!E5","v":"SWH Loan Programs"},null,null,null,null,{"$f":"Score!F5","v":0},null,{"$f":"Score!G5","v":0}]
[null,null,null,null,{"$f":"Score!D6","v":0.05},null,{"$f":"Score!E6","v":"Building Mandates"},null,null,null,null,{"$f":"Score!F6","v":0},null,{"$f":"Score!G6","v":0}]
[null,null,null,null,{"$f":"Score!D7","v":0.04},null,{"$f":"Score!E7","v":"Outreach Campaigns"},null,null,null,null,{"$f":"Score!F7","v":0},null,{"$f":"Score!G7","v":0}]
[null,"II. National Conditions",{"$f":"Score!C8","v":0.3},null,{"$f":"Score!D8","v":0.05},null,{"$f":"Score!E8","v":"Insolation"},null,null,null,null,{"$f":"Score!F8","v":{"$error":"#N/A"}},null,{"$f":"Score!G8","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"Score!D9","v":0.04},null,{"$f":"Score!E9","v":"SWH Market Penetration"},null,null,null,null,{"$f":"Score!F9","v":0},null,{"$f":"Score!G9","v":0}]
[null,null,null,null,{"$f":"Score!D10","v":0.05},null,{"$f":"Score!E10","v":"Residential Energy Consumption Growth "},null,null,null,null,{"$f":"Score!F10","v":{"$error":"#DIV/0!"}},null,{"$f":"Score!G10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"Score!D11","v":0.04},null,{"$f":"Score!E11","v":"SWH Market Growth"},null,null,null,null,{"$f":"Score!F11","v":{"$error":"#DIV/0!"}},null,{"$f":"Score!G11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"Score!D12","v":7.0000000000000007E-2},null,{"$f":"Score!E12","v":"SWH Competitiveness: Payback Period"},null,null,null,null,{"$f":"Score!F12","v":0},null,{"$f":"Score!G12","v":0}]
[null,null,null,null,{"$f":"Score!D13","v":0.05},null,{"$f":"Score!E13","v":"SWH Competitiveness: Heating Fuel Subsidy"},null,null,null,null,{"$f":"Score!F13","v":5},null,{"$f":"Score!G13","v":0.25}]
[null,"III. Financing",{"$f":"Score!C14","v":0.2},null,{"$f":"Score!D14","v":0.05},null,{"$f":"Score!E14","v":"Country Credit Rating"},null,null,null,null,{"$f":"Score!F14","v":{"$error":"#N/A"}},null,{"$f":"Score!G14","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"Score!D15","v":0.15},null,{"$f":"Score!E15","v":"Access to Finance"},null,null,null,null,{"$f":"Score!F15","v":0},null,{"$f":"Score!G15","v":0}]
[null,"IV. Business Climate",{"$f":"Score!C16","v":0.21},null,{"$f":"Score!D16","v":0.05},null,{"$f":"Score!E16","v":"Doing Business Index"},null,null,null,null,{"$f":"Score!F16","v":0},null,{"$f":"Score!G16","v":0}]
[null,null,null,null,{"$f":"Score!D17","v":0.03},null,{"$f":"Score!E17","v":"Manufacturing Capacity"},null,null,null,null,{"$f":"Score!F17","v":{"$error":"#N/A"}},null,{"$f":"Score!G17","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"Score!D18","v":0.05},null,{"$f":"Score!E18","v":"Product Standards and Certification"},null,null,null,null,{"$f":"Score!F18","v":0},null,{"$f":"Score!G18","v":0}]
[null,null,null,null,{"$f":"Score!D19","v":0.04},null,{"$f":"Score!E19","v":"Installer Certification"},null,null,null,null,{"$f":"Score!F19","v":0},null,{"$f":"Score!G19","v":0}]
[null,null,null,null,{"$f":"Score!D20","v":0.04},null,{"$f":"Score!E20","v":"Industry Association"},null,null,null,null,{"$f":"Score!F20","v":0},null,{"$f":"Score!G20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Score!F21","v":5},null,{"$f":"Score!G21","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Overall Score",{"$f":"Score!G23","v":{"$error":"#N/A"}}]
[]
[null,"Assessment of Overall Strength of Market"]
[]
[]
[]
[]
[]
[]
[]
[null,"Explanation of Scores"]
[]
[null,"Score of 0-2: SWH enabling environment is “emerging” and could likely benefit from additional support to accelerate SWH market growth."]
[null,"Score of 2-3: SWH enabling environment is “good” with a SWH market positioned for increased growth."]
[null,"Score of 3-4:  SWH enabling environments are considered to be “strong” and are likely ready to attract investment."]
[null,"Score of 4-5: SWH conditions are “very strong” – policy, market, financial, business conditions are aligned to support SWH and market growth is likely to be rapid."]
[]
[]
[]
[null,"TechScope Summary Report",null,null,null,null,"- 4 -",null,null,null,null,"Date Prepared:",{"$f":"TODAY()","v":"2015-11-09"}]

{"sheet":"Country Conversion&Calculation","index":6,"n_rows":277,"n_cols":20,"rows_kept":277,"cut":false,"hidden":true,"merged":[[87,2,87,8],[68,1,68,5],[1,1,1,6],[29,2,29,7],[34,2,34,7],[44,1,44,6],[267,1,267,5],[96,0,97,0],[96,1,97,1],[96,2,97,2],[96,4,97,5],[96,3,97,3]]}
["LEBANON"]
["SWH Market"]
["Growth Rate","-% to 0%","1% to 5%","6% to 10%","11% to 15%","16% to 20%","20% or greater"]
["Score",0,1,2,3,4,5]
[]
[]
["SWH Market"]
["Growth Rate","Score"]
["-% to 0%",0]
["1% to 5%",1]
["6% to 10%",2]
["11% to 15%",3]
["16% to 20%",4]
["20% or greater",5]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Conversion multiplier for BTU to Mtoe",2.5219021687207E-14,"http://www.unitjuggler.com/convert-energy-from-Btu-to-Mtoe.html"]
[null,"unit",2005,2006,2007,2008,2009,2010]
["Total Primary Energy Production ","BTU",null,{"$f":"6.82*(10^12)","v":6820000000000},{"$f":"5.7*(10^12)","v":5700000000000},{"$f":"3.6*(10^12)","v":3600000000000},{"$f":"6*(10^12)","v":6000000000000},{"$f":"8*(10^12)","v":8000000000000}]
["Total Primary Energy Consumption ","BTU",{"$f":"2.19*(10^14)","v":219000000000000},{"$f":"1.94*(10^14)","v":194000000000000},{"$f":"1.79*(10^14)","v":179000000000000},{"$f":"1.82*(10^14)","v":182000000000000},{"$f":"2.83*(10^14)","v":283000000000000},{"$f":"2.76*(10^14)","v":275999999999999.97}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},2005,2006,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"D20*B18","v":0.17199372790675174},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C21*B18","v":5.5229657494983329},{"$f":"D21*B18","v":4.8924902073181578},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Growth in Energy Demand","unit",2005,2006,2007,2008,2009,2010]
["Total Primary Energy Consumption","Mtoe",{"$f":"C21*B18","v":5.5229657494983329},{"$f":"D25","v":4.8924902073181578},{"$f":"E25","v":{"$error":"#REF!"}},{"$f":"F25","v":{"$error":"#REF!"}},{"$f":"G25","v":{"$error":"#REF!"}},{"$f":"H25","v":{"$error":"#REF!"}}]
["Growth",null,null,{"$f":"((D28-C28)/C28)","v":-0.11415525114155253},{"$f":"((E28-D28)/D28)","v":{"$error":"#REF!"}},{"$f":"((F28-E28)/E28)","v":{"$error":"#REF!"}},{"$f":"((G28-F28)/F28)","v":{"$error":"#REF!"}},{"$f":"((H28-G28)/G28)","v":{"$error":"#REF!"}}]
["Average Growth Rate","%",{"$f":"SUM(D29:H29)/(5)","v":{"$error":"#REF!"}}]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},2006,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(114400/4097457)*1000","v":27.919756082858221},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average Growth Rate","%",{"$f":"SUM(D34:H34)/5","v":{"$error":"#REF!"}}]
[]
["Percent of Cumulitive SWH Capacity by Sector"]
["Residential / individual systems",0.84342153885702353]
["Residential - Multi-family",9.5371218328754365E-2]
["Industry",3.9999357336803716E-2]
["Service sector (tourism,hospitals, etc.), public buildings",2.1207885477418423E-2]
[]
["INDIA"]
[]
["SWH Market"]
["Growth Rate","-% to 0%","1% to 5%","6% to 10%","11% to 15%","16% to 20%","20% or greater"]
["Score",0,1,2,3,4,5]
[]
[]
["SWH Market"]
["Growth Rate","Score"]
["-% to 0%",0]
["1% to 5%",1]
["6% to 10%",2]
["11% to 15%",3]
["16% to 20%",4]
["20% or greater",5]
[null,null,null,null,"To tal ca pac ity of glazed flat-plate and evac u ated tube col lec tors at the end"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,"of 2006"]
[]
["Total Capacity of glazed and flat-plate and evacuated tube collectors"]
["Unit",2006,2007,2008,2009,2010,2011]
["MW th",1050,1178.0999999999999,1771.8,2156.8000000000002,2779,3347]
[]
["Total Capacity of glazed and flat-plate and evacuated tube collectors in operation at end of 2006 in KWth per 1000 inhabitants"]
[null,2007,2008,2009,2010,2011]
["KW th/1000 inhabitants",1.8,1.6,1.9,2.4,2.8]
["Growth",null,{"$f":"(C67-B67)/B67","v":-0.11111111111111108},{"$f":"(D67-C67)/C67","v":0.18749999999999989},{"$f":"(E67-D67)/D67","v":0.26315789473684209},{"$f":"(F67-E67)/E67","v":0.16666666666666663}]
["Average Growth Rate",{"$f":"SUM(C68:F68)/4","v":0.12655336257309938}]
[]
["SWH market penetration Indicator Scoring Methodology (KWth/1000 people)"]
["Unit","Greece","Lithuania","Score"]
["KWth/1000",268.2,0.8,{"$f":"F67/(B73-C73)*5","v":5.2356020942408377E-2}]
[]
[]
["Conversion multiplier for quad BTU to Mtoe",25.219021687207,"http://www.unitjuggler.com/convert-energy-from-Btu-to-Mtoe.html"]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production ","quad BTU",null,null,13.028879999999999,13.5655,14.56757,15.29438,16.00234]
["Total Primary Energy Consumption ","quad BTU",null,null,18.813780000000001,19.903020000000001,21.41704,21.919799999999999,23.610679999999999]
[]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production","Mtoe",null,{"$f":"D78*B76","v":0},{"$f":"E78*$B76","v":328.57560728001749},{"$f":"F78*$B76","v":342.10863869780655},{"$f":"G78*$B76","v":367.37986375990607},{"$f":"H78*$B76","v":385.709300912385},{"$f":"I78*$B76","v":403.56335950606007}]
["Total Primary Energy Consumption","Mtoe",{"$f":"C79*B76","v":0},{"$f":"D79*B76","v":0},{"$f":"E79*$B76","v":474.46512583834135},{"$f":"F79*$B76","v":501.93469302091472},540.11679623577982,552.79591157923994,595.43825096970454]
[]
["Growth in Energy Demand","unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Consumption","Mtoe",{"$f":"C79*B76","v":0},{"$f":"D83","v":0},474.46512583834135,501.93469302091472,540.11679623577982,552.79591157923994,595.43825096970454]
["Growth",null,null,null,null,{"$f":"((F86-E86)/E86)","v":5.789586143773344E-2},{"$f":"((G86-F86)/F86)","v":7.6069862764545179E-2},{"$f":"((H86-G86)/G86)","v":2.347476588734939E-2},{"$f":"((I86-H86)/H86)","v":7.7139389957937635E-2}]
["Average Growth Rate","%",{"$f":"SUM(F87:I87)/(4)","v":5.8644970011891409E-2}]
[]
["Percent of Cumulitive SWH Capacity by Sector"]
["Residential / individual systems"]
["Residential - Multi-family"]
["Industry"]
["Service sector (tourism,hospitals, etc.), public buildings"]
[]
["Flate Plate Collector, LCOE"]
["Sl No","Capacity (lpd)","Collector Area (Sq.m)","Benchmark Cost (Rs.)","Eligible subsidy"]
[]
[null,null,null,null,"All type of users in General Category States & Commercial users in Special Category States","Domestic and Institutional users in Special Category States  "]
[2,200,4,"48,000 -52,000",13200,26400]
[]
["Currency exchange rate Rs. 1 = .0180 USD ","Rs. 1 =",1.7999999999999999E-2]
["http://www.oanda.com/currency/historical-rates/",null,null,"July 1, 2012 - Aug 27, 2013 Avg"]
[]
["FPC, 200 lpd","Avg Benchmark Cost","Eligible Subsidy","30% of benchmark cost"]
["Rupee",{"$f":"SUM(48000,52000)/2","v":50000},{"$f":"E100","v":13200},{"$f":"B106*0.3","v":15000}]
["USD",{"$f":"B106*C102","v":899.99999999999989},{"$f":"C106*C102","v":237.6},{"$f":"D106*C102","v":270}]
[]
["Collector Type","MWth","%",null,null,"http://www.dartmouth.edu/~neudc2012/docs/paper_292.pdf"]
["FPC",2995.4,{"$f":"B110/B112","v":0.8950576704715234},null,"cost of domestic electricity","http://powermin.nic.in/JSP_SERVLETS/internal.jsp"]
["ETC",351.2,{"$f":"B111/B112","v":0.10494232952847667},null,null,"http://www.bijlibachao.com/Historical-Tariff/domestic-lt-tariff-slabs-and-rates-for-all-states-in-india-in-2012.html"]
["Total",{"$f":"SUM(B110:B111)","v":3346.6},{"$f":"SUM(C110:C111)","v":1},null,null,"http://www.bijlibachao.com/News/domestic-lt-tariff-slabs-and-rates-for-all-states-in-india-in-2013.html"]
[null,null,null,null,null,"http://publicfinance.in/?page_id=5818"]
["Access to Credit"]
["Distance to Frontier Ranking for Getting Credit",81.3,"http://www.doingbusiness.org/data/distance-to-frontier"]
[]
["Average lending interst rates to the private sector (2012)"]
[0.106,"http://data.worldbank.org/indicator/FR.INR.LEND"]
[]
["Credit Ratings","http://www.tradingeconomics.com/india/rating"]
["S&P Rating",null,"Moody's rating",null,"Fitch Rating",null,"TE Rating"]
["BBB-","NEGATIVE","Baa3","STABLE","BBB-","STABLE",47.12,"NEGATIVE"]
["Standard & Poor's credit rating for India stands at BBB-. Moody's rating for India sovereign debt is Baa3. Fitch's credit rating for India is BBB-. In general, a credit rating is used by sovereign wealth funds, pension funds and other investors to gauge the credit worthiness of India thus having a big impact on the country's borrowing costs. This page contains - India | Credit Rating - actual values, historical data, forecast, chart, statistics, economic calendar and news. 8/28/2013"]
["Country","Moody's","S&P","Score"]
["India","Baa3","BBB-",3.5,null,null,null,null,null,null,null,null,null,null,null,null,"Country","Moody's","S&P","Score"]
[]
["Doing Business Ranking 2012"]
["Country","Ranking"]
["India",132,null,"http://www.doingbusiness.org/~/media/GIAWB/Doing%20Business/Documents/Annual-Reports/English/DB12-FullReport.pdf",null,null,null,null,null,null,null,null,null,null,null,null,"India","Baa3","BBB-"]
["CHILE"]
[]
[]
["SWH Market"]
["Growth Rate","-% to 0%","1% to 5%","6% to 10%","11% to 15%","16% to 20%","20% or greater"]
["Score",0,1,2,3,4,5]
[]
[]
["SWH Market"]
["Growth Rate","Score"]
["-% to 0%",0]
["1% to 5%",1]
["6% to 10%",2]
["11% to 15%",3]
["16% to 20%",4]
["20% or greater",5]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Conversion multiplier for quad BTU to Mtoe",25.219021687207,"http://www.unitjuggler.com/convert-energy-from-Btu-to-Mtoe.html"]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production ","quad BTU",null,null,0,0,0,0,0]
["Total Primary Energy Consumption ","quad BTU",null,null,0,0,0,0,0]
[]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production","Mtoe",null,{"$f":"D150*B148","v":0},{"$f":"E150*$B148","v":0},{"$f":"F150*$B148","v":0},{"$f":"G150*$B148","v":0},{"$f":"H150*$B148","v":0},{"$f":"I150*$B148","v":0}]
["Total Primary Energy Consumption","Mtoe",{"$f":"C151*B148","v":0},{"$f":"D151*B148","v":0},{"$f":"E151*$B148","v":0},{"$f":"F151*$B148","v":0},0,0,0]
[]
["Growth in Energy Demand","unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Consumption","Mtoe",{"$f":"C151*B148","v":0},{"$f":"D155","v":0},0,0,0,0,0]
["Growth",null,null,null,null,{"$f":"((F158-E158)/E158)","v":{"$error":"#DIV/0!"}},{"$f":"((G158-F158)/F158)","v":{"$error":"#DIV/0!"}},{"$f":"((H158-G158)/G158)","v":{"$error":"#DIV/0!"}},{"$f":"((I158-H158)/H158)","v":{"$error":"#DIV/0!"}}]
["Average Growth Rate","%",{"$f":"SUM(F159:I159)/(4)","v":{"$error":"#DIV/0!"}}]
[]
["Percent of Cumulitive SWH Capacity by Sector"]
["Residential / individual systems"]
["Residential - Multi-family"]
["Industry"]
["Service sector (tourism,hospitals, etc.), public buildings"]
[]
["MEXICO"]
[]
["SWH Market"]
["Growth Rate","-% to 0%","1% to 5%","6% to 10%","11% to 15%","16% to 20%","20% or greater"]
["Score",0,1,2,3,4,5]
[]
[]
["SWH Market"]
["Growth Rate","Score"]
["-% to 0%",0]
["1% to 5%",1]
["6% to 10%",2]
["11% to 15%",3]
["16% to 20%",4]
["20% or greater",5]
[]
[]
["Conversion multiplier for quad BTU to Mtoe",25.219021687207,"http://www.unitjuggler.com/convert-energy-from-Btu-to-Mtoe.html"]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production ","quad BTU",null,null,0,0,0,0,0]
["Total Primary Energy Consumption ","quad BTU",null,null,0,0,0,0,0]
[]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production","Mtoe",null,{"$f":"D187*B185","v":0},{"$f":"E187*$B185","v":0},{"$f":"F187*$B185","v":0},{"$f":"G187*$B185","v":0},{"$f":"H187*$B185","v":0},{"$f":"I187*$B185","v":0}]
["Total Primary Energy Consumption","Mtoe",{"$f":"C188*B185","v":0},{"$f":"D188*B185","v":0},{"$f":"E188*$B185","v":0},{"$f":"F188*$B185","v":0},0,0,0]
[]
["Growth in Energy Demand","unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Consumption","Mtoe",{"$f":"C188*B185","v":0},{"$f":"D192","v":0},0,0,0,0,0]
["Growth",null,null,null,null,{"$f":"((F195-E195)/E195)","v":{"$error":"#DIV/0!"}},{"$f":"((G195-F195)/F195)","v":{"$error":"#DIV/0!"}},{"$f":"((H195-G195)/G195)","v":{"$error":"#DIV/0!"}},{"$f":"((I195-H195)/H195)","v":{"$error":"#DIV/0!"}}]
["Average Growth Rate","%",{"$f":"SUM(F196:I196)/(4)","v":{"$error":"#DIV/0!"}}]
[]
["Percent of Cumulitive SWH Capacity by Sector"]
["Residential / individual systems"]
["Residential - Multi-family"]
["Industry"]
["Service sector (tourism,hospitals, etc.), public buildings"]
[]
["ALBANIA"]
[]
["SWH Market"]
["Growth Rate","-% to 0%","1% to 5%","6% to 10%","11% to 15%","16% to 20%","20% or greater"]
["Score",0,1,2,3,4,5]
[]
[]
["SWH Market"]
["Growth Rate","Score"]
["-% to 0%",0]
["1% to 5%",1]
["6% to 10%",2]
["11% to 15%",3]
["16% to 20%",4]
["20% or greater",5]
[]
[]
["Conversion multiplier for quad BTU to Mtoe",25.219021687207,"http://www.unitjuggler.com/convert-energy-from-Btu-to-Mtoe.html"]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production ","quad BTU",7.0999999999999994E-2,6.8659999999999999E-2,4.3049999999999998E-2,5.2830000000000002E-2,6.4049999999999996E-2,9.844E-2,7.4149999999999994E-2]
["Total Primary Energy Consumption ","quad BTU",0.121,0.11899999999999999,0.10299999999999999,0.11,0.115,0.125,0.106]
[]
[null,"unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Production","Mtoe",{"$f":"C224*$B222","v":1.7905505397916968},{"$f":"D224*$B222","v":1.7315380290436326},1.0856788836342612,1.3323209157351459,1.6152783390656082,2.482560494888657,1.8699904581063989]
["Total Primary Energy Consumption","Mtoe",{"$f":"C225*B222","v":3.051501624152047},{"$f":"D225*B222","v":3.0010635807776329},{"$f":"E225*$B222","v":2.597559233782321},{"$f":"F225*$B222","v":2.7740923855927702},{"$f":"G225*$B222","v":2.9001874940288053},{"$f":"H225*$B222","v":3.152377710900875},{"$f":"I225*$B222","v":2.6732162988439421}]
[]
["Growth in Energy Demand","unit",2005,2006,2007,2008,2009,2010,2011]
["Total Primary Energy Consumption","Mtoe",{"$f":"C225*B222","v":3.051501624152047},{"$f":"D229","v":3.0010635807776329},2.597559233782321,2.7740923855927702,2.9001874940288053,3.152377710900875,2.6732162988439421,null,null,"new-old/old"]
["Growth",null,null,null,{"$f":"(E232-D232)/(E232)","v":-0.15533980582524268},{"$f":"((F232-E232)/E232)","v":6.7961165048543742E-2},{"$f":"((G232-F232)/F232)","v":4.5454545454545491E-2},{"$f":"((H232-G232)/G232)","v":8.6956521739130349E-2},{"$f":"((I232-H232)/H232)","v":-0.152}]
["Average Growth Rate","%",{"$f":"SUM(E233:I233)/(5)","v":-2.1393514716604618E-2}]
[]
["Percent of Cumulitive SWH Capacity by Sector"]
["Residential / individual systems"]
["Residential - Multi-family"]
["Industry"]
["Service sector (tourism,hospitals, etc.), public buildings"]
[]
["Access to Credit"]
["Distance to Frontier Ranking for Getting Credit",81.3,"http://www.doingbusiness.org/data/distance-to-frontier"]
[]
["Average lending interst rates to the private sector"]
[0.109,"http://data.worldbank.org/indicator/FR.INR.LEND"]
[]
["Credit Ratings","http://www.tradingeconomics.com/albania/rating"]
["S&P Rating",null,"Moody's rating",null,"Fitch Rating",null,"TE Rating"]
["B1","STABLE","B1","STABLE",null,null,35,"STABLE"]
["Standard & Poor's credit rating for Albania stands at B1. Moody's rating for Albania sovereign debt is B1. In general, a credit rating is used by sovereign wealth funds, pension funds and other investors to gauge the credit worthiness of Albania thus having a big impact on the country's borrowing costs. This page contains - Albania | Credit Rating - actual values, historical data, forecast, chart, statistics, economic calendar and news. 8/28/2013"]
[]
["Country","Moody's","S&P","Score"]
["Albania","B1","B1",2.5]
[]
["Doing Business Ranking 2012"]
["Country","Ranking"]
["Albania",82,null,"http://www.doingbusiness.org/~/media/GIAWB/Doing%20Business/Documents/Annual-Reports/English/DB12-FullReport.pdf"]
[]
["Total Capacity of glazed and flat-plate and evacuated tube collectors"]
["Unit",2006,2007,2008,2009,2010,2011]
["MW th",28.56,35.1,40.299999999999997,49.1,54,64]
[]
["Total Capacity of glazed and flat-plate and evacuated tube collectors in operation at end of 2006 in KWth per 1000 inhabitants"]
[null,2006,2007,2008,2009,2010,2011]
["KW th/1000 inhabitants",9.1199999999999992,11,11.1,16.5,18.2,21.2]
["Growth",null,null,{"$f":"(D266-C266)/C266","v":9.0909090909090592E-3},{"$f":"(E266-D266)/D266","v":0.48648648648648651},{"$f":"(F266-E266)/E266","v":0.10303030303030299},{"$f":"(G266-F266)/F266","v":0.16483516483516483}]
["Average Growth Rate",{"$f":"SUM(D267:G267)/4","v":0.19086071586071585}]
[]
["SWH market penetration Indicator Scoring Methodology (KWth/1000 people)"]
["Unit","Greece","Lithuania","Score"]
["KWth/1000",268.2,0.8,{"$f":"G266/(B272-C272)*5","v":0.39640987284966345}]
[]
["Split between Types 2011"]
["FPC",90075,{"$f":"B275/B277","v":0.99287926720384478}]
["ETC",646,{"$f":"B276/B277","v":7.1207327961552453E-3}]
["Total",{"$f":"SUM(B275:B276)","v":90721}]

{"sheet":"Currency dropdown","index":7,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,"Please select currency",null,null,"Please select currency",null,null,"Please select tax option"]
[null,"Cost in €",null,null,"in €",null,null,"VAT inc."]
[null,"Cost in $",null,null,"in $",null,null,"VAT exc."]
[null,"Cost in local currency",null,null,"in local currency"]

{"sheet":"GHG Calculator Cover","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,5,14,7],[12,5,12,7],[11,1,11,7],[2,0,2,16383],[4,2,4,7],[5,1,5,7],[9,1,9,7],[10,1,10,7]]}
[]
[]
[]
[]
[null,null,"TechScope"]
[null,"Greenhouse Gas Calculator for \nResidential Solar Water Heating"]
[null,null,null,null,"Version 1.0"]
[]
[]
[null,"The Greenhouse Gas Calculator for Residential Solar Water Heating (\"GHG Calculator\") is an optional module integrated into the TechScope Tool. It is not necessary to complete in order to generate a TechScope score for a country; however, the GHG Calculator provides complementary functions designed to help policymakers quantify the GHG emissions reductions associated with increased development of Solar Water Heating (SWH) systems. The GHG Calculator can also be used to establish SWH targets designed to achieve specific GHG emissions reductions."]
[]
[]
[null,null,null,null,null,"PROCEED TO USER MANUAL u"]
[]
[null,null,null,null,null,"PROCEED TO TOOL u"]

{"sheet":"User Manual","index":9,"n_rows":81,"n_cols":5,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,4,3,6],[63,1,63,5],[77,1,77,5],[65,1,65,5],[67,1,67,5],[72,1,72,5],[73,1,73,5],[74,1,74,5],[71,1,71,5],[75,1,75,5],[47,1,47,5],[49,1,49,5],[51,1,51,5],[53,1,53,5],[58,1,58,5],[59,1,59,5],[61,1,61,5],[55,1,55,5],[48,1,48,5],[50,1,50,5],[52,1,52,5],[56,1,56,5],[57,1,57,5],[54,1,54,5],[60,1,60,5],[41,1,41,5],[43,1,43,5],[44,1,44,5],[46,1,46,5],[40,1,40,5],[45,1,45,5],[38,1,38,5],[21,1,21,5],[0,0,0,5],[5,1,5,5],[7,1,7,5],[9,1,9,5],[24,1,24,5],[19,1,19,5],[23,1,23,5],[8,1,8,5],[17,1,17,5],[12,1,12,5],[36,1,36,5],[33,1,33,5],[16,1,16,5],[34,1,34,5],[82,1,82,6],[69,1,69,5],[68,1,68,5],[70,1,70,5],[79,1,79,5],[80,1,80,5]]}
["Greenhouse Gas Calculator for Residential Solar Water Heating"]
["Integrated User Manual"]
[]
[null,null,null,null,"PROCEED TO TOOL u"]
[]
[1,"Introduction"]
[]
[null,"The Greenhouse Gas (GHG) Calculator is an optional module integrated into the TechScope Tool. It is not necessary to complete in order to generate a TechScope score for a country; however, the GHG Calculator provides complementary functions designed to help policymakers quantify the GHG emissions reductions associated with increased development of Solar Water Heating (SWH) systems. As discussed below, the GHG Calculator can also be used to establish SWH targets in order to achieve desired GHG emissions reductions."]
[2,"Intended Uses"]
[null,"The tool is designed for simplicity, flexibility, and scalability. It estimates the emissions avoided by installing SWH systems using a few simple inputs and assumptions on the type and quantity of installed SWH system (under \"Input Sheet I\") and the type and ratio of fossil fuel-driven hot water heating systems that are replaced or whose use is reduced by the SWH systems (\"Input Sheet II\"). As such, it is possible to use the GHG Calculator for a variety of purposes, including:"]
[null,"- Estimating the GHG emissions avoided by currently installed SWH systems in a country or region"]
[null,"- Estimating the potential GHG emissions reductions from a single project"]
[null,"- Estimating the potential GHG emissions reductions from a policy or programme based on assumptions about the amount of SWH installed as a result"]
[null,"- Estimating the potential GHG emissions reductions from organic growth of the SWH market"]
[null,"- Setting a target quantity of SWH systems needed to reach a desired GHG emissions reduction target"]
[]
[null,"Note that the tool is intended for estimating GHG emissions avoided by installing SWH for the residential sector. Users may the tool useful for the commercial sector as well, but it is not intended for industrial sector emissions calculations. "]
[null,"To accommodate all of these potential uses, the model was designed to minimize required inputs and avoid dependency on market data that may not be available in all regions."]
[]
[3,"Using the GHG Calculator"]
[]
[null,"This section walks the user through entering required data into the GHG Calculator. Note that detailed context-specific help is available in the GHG Calculator module itself by hovering the mouse over the information reference boxes marked with an 'i\". Comment boxes will appear with more detailed information on each input or calculation."]
[]
[null,"Like the rest of the TechScope Score, the GHG Calculator tool requires users to enter data for the country or region in question and inputs (or assumptions) about the technology installed or replaced. To support data collection, when possible, potential data sources are integrated into the model or referenced in context help. In some instances, the user is responsible for finding the appropriate information to answer the question associated with the indicator."]
[null,"Throughout the input sheets, color-coded shading is used to indicate which cells will accept data entry and which are required inputs. Note that input cells are differentiated between optional and mandatory."]
[null,"Format","Meaning","User modification allowed?"]
[null,"i","Context Help","Not modifiable by user"]
[null,"Calculation","Calculated data","Not modifiable by user"]
[null,"Data","Input field (optional)","Modifiable by user"]
[null,"Data","Input field (mandatory)","Modifiable by user"]
[null,"Text","Data label","Not modifiable by user"]
[null,"Calculation","Intermediate or final result","Not modifiable by user"]
[]
[null,"The following section provides the user instructions on how to enter the data for input sheet I and input sheet II."]
[null,"Note that users must fully complete both Input Sheets to calculate GHG emissions."]
[]
[3.1,"INPUT SHEET I"]
[]
[null,"In this section, the user defines the scale of SWH uptake for which associated GHG reductions are desired. This could be used to estimate GHG reductions from a single or set of installed or hypothetical projects or to test the potential GHG impacts of a hypothetical SWH program or policy based on assumed levels of new systems that would be installed. "]
[]
[null,"SECTION 1-3"]
[null,"Section 1. Preferred Units of Measurement: The model is designed to accommodate commonly used units of measurement for SWH system size, heat output, and greenhouse gas emissions. Default units are provided but the user may change any of the desired units. This will set the model up to receive inputs and present outputs in the units selected."]
[]
[null,"Section 2. Solar Resource for the Country or Region: Use the link provided or another data source to enter the average annual solar insolation resource for the country or region being evaluated. Note: use average ANNUAL values, which generally range between 1,000 – 2,500 kWh/m2/year. Data obtained in DAILY values (kWh/m2/year) may be converted to annual by multiplying by 365. "]
[null,"Section 3. Type of Solar Water Heating System: This input is optional. The user may differentiate up to 4 different types of SWH systems. Differentiation allows different volumes and system assumptions to be made for different categories. For example, users may wish to differentiate between Glazed and Unglazed systems, entering different collector yield assumptions (Section 4) or different quantities (Section 6) for each."]
[null,"SECTION 4-6: Refers to characteristics of SWH collectors and systems. While characteristics of individual SWH systems may vary, the model requires the user to enter the “average,” “typical” or “aggregate” conditions so that country-or region-wide analysis may be performed. Where possible, default assumptions are provided but users should use the best available data and assumptions for the country or region."]
[null,"Section 4. Average Collector yield: Collector yield is measured as the % of solar insolation that is converted to heat by the collector. Note that losses in piping or hot water storage may be accounted for in Section 5 below.\n\nThe model allows the user to use default assumptions calculated by the model based on IEA-SHC data (Option 1) or enter their own average collector yield factors for SWH systems installed (Option 2). The methodology and assumptions for Option 1 are detailed below.\n\nInstructions for each option are provided in the context help for Section 4. "]
[null,"Note on Assumptions and Methodology: Option 1 provides a single collector yield assumption for the country or region identified by the user in Input 4B. This value will not be affected by any differentiation or categorization the user may have identified in Section 3. If Option 1 is used, the model will calculate an appropriate collector yield using:\nA. Total collector yield for the country in GWh/yr (Source: IEA-SHC's Solar Heating Worldwide 2015 Edition, Table 5, page 30)\nB. Total collector area for the country in m^2 (same source)\nC. Solar insolation in kWh/m2/yr (provided by the user in Section 2)\nCollector Yield = ( [A]*1000000 / [B] ) / [C]"]
[null,"Section 5. Average Piping and Storage Losses: Efficiency of the SWH collector is identified in Section 4; however, useable heat may be further reduced by losses in the water piping and storage system. Section 5 allows the user to enter the percentage of collector output assumed to be lost due to pipe line and storage tank losses. These are expressed as a percent of collector yield. \n\nUsers should use the best available data or assumptions for the country or region being evaluated. Default values are provided based on assumptions used by the European Solar Thermal Industry Federation. See \"Objective methodology for simple calculation of the energy delivery of (small) Solar Thermal systems\" available at\n"]
[null,"http://www.estif.org/fileadmin/estif/content/policies/downloads/Simple_Calculation.pdf."]
[null,"Section 6. Amount of solar water heating systems installed: Enter the total quantity of SWH for which associated GHG emissions reductions should be calculated. These volumes should be expressed either as square meters of collectors (m^2) or kilowatts of installed capacity (kWth), depending on the unit of measurement selected in Section 1. Note that the model uses a conversion factor of 0.7 kWth per m2 to derive the nominal capacity from the area of installed collectors if total collector area is given in m2 (see assumptions and methodology below).\n\nNote that there is no “correct” value for this input. It will depend on the user’s intentions in using this model. For more information on potential uses, see “Intended Uses” in Part 2 of the User Manual above.\n"]
[null,"Note on assumptions & methodology: The IEA Solar Heating and Cooling Programme has developed a methodology to convert installed collector area to solar thermal capacity. It was established that a factor of 0.7 kWth per m2 should be used to derive the nominal capacity from the area of installed collectors. See IEA Solar Heating and Cooling Programme. (2004). Recommendation: Converting solar thermal collector area into installed capacity (M2 to kWth). Cedar, MI, USA. \n"]
[null,"Section 7. Total output of solar water heating system: This section uses assumptions about the heating fuels that are replaced by SWH systems and calculates the avoided greenhouse gas emissions by type of conventional heating fuel that is avoided/reduced. Separate methods and data sources are required for replacement of electric hot water systems due to the variation across countries and regions in carbon intensity of grid electricity."]
[3.2,"INPUT SHEET II"]
[]
[null,"In this section the user provides information on the fossil fuel energy that will be replaced by the SWH systems. Using this data, the model calculates the GHG emissions of avoided fossil fuel systems."]
[null,"Section 8. Type of Fossil Fuel Used that is Avoided by SWH Systems:  Select up to five types of fossil fuel assumed to be used in fossil fuel heating systems whose use is avoided or reduced by SWH systems. \n\nThe model provides a number of fuel types relevant to domestic and commercial hot water heating for which IPCC emissions factor data is available. For each type of fossil fuel energy selected, provide an estimation or assumption of the percentage of total output of new SWH systems (Input 8B) that will replace each of the conventional sources. For example, if you expect that 50% of the output from new SWH systems will offset natural gas-powered conventional systems, select \"Natural Gas\" from Input 8A and enter \"50%\" in Input 8B in the corresponding row.\n"]
[null,"Section 9. Efficiency of Avoided or Replaced Fossil Fuel Systems: The average efficiency of typical conventional hot water systems in the country or region should be entered by the user here."]
[null,"Section 10. Total Primary Energy of Avoided Fossil Fuel Consumption: The model calculates the amount of fuel avoided, expressed in kWh or MMBtu of primary energy, depending on the unit of measurement selected in Input 1 on Input Sheet I. \n"]
[null,"Section 11. Effective CO2e Emissions Factors for Fossil Fuels: Emissions factors are automatically populated using IPCC and EIA data sets. Note that for consistency with original data sources, the model shows these emissions factors in \"lbs CO2e/kWh\" regardless of the units of measurement selected in Section 1 on Input Sheet I. \n\nIf any of the Displaced Fossil Fuel Types selected in Section 8 are \"Electricity\", select your country or region from Section 10A. Otherwise country selection is not required. If the desired country is not listed, select the best available proxy country or region."]
[null,"Note on Assumptions & Methodology: \nFor all fossil fuels except electricity: Global values are used representing typical emissions associated with the combustion of the fossil fuel in residential settings. Source: IPCC (2006). Guidelines for National Greenhouse Gas Inventories. Chapter 2: Stationary Combustion.\n\nFor electricity: Country-level average grid electricity emissions factors are used, drawing from EIA. (2011) CO2 Emissions From Fuel Combustion Highlights. http://www.iea.org/media/statistics/co2highlights.pdf"]
[null,"Section 12. Total CO2e Emissions Reduced: The model calculates the total emission reductions in carbon dioxide equivalent (CO2e) by multiplying the CO2e emissions factor from Section 11 by the total primary energy in Section 10.\n"]
[]
[null,"Note: the results are also presented in a print-ready and graphically formatted report on the \"GHG Report\" sheet."]
[]
[3.3,"OPTIONAL: SWH GOAL MODULE"]
[]
[null,"This is an optional module that allows the user to run the model in a different way. Completing just Input Sheets I and II allows the user to view resulting GHG emissions reductions obtained by defining the scale of SWH installations. The SWH Goal Module does the opposite: it allows the user to define the desired GHG reductions and have the model determine the required level of SWH installations needed to meet it. "]
[null,"Section A. SWH Output and Avoided Fossil Fuel Emissions Inputs: To use the SWH Goal Module it is necessary to complete all sections of the Input Sheets except Section 6 on Input Sheet I. The SWH Goal Module utilizes Input Sheets I and II by automatically entering the quantity of SWH in Input 6 needed to reach the GHG Goal specified in Section C below."]
[null,"Section B. Relative Portion of Different Types of SWH System: If only one type of SWH system is identified by the user in Section 3 on Input Sheet I, enter \"100%\" in the first blue cell below.\n\nOtherwise, enter the share each type of SWH system is expected to comprise, ensuring that the total adds to \"100%\". For example, if SWH systems are differentiated between \"Glazed\" and \"Unglazed\" in Section 3, enter the assumed % of each type in Section B.\n\nThe model will find the total quantity of SWH needed to reach the GHG Goal identified, but this entry is required in order for the user to specify how that total is divided across  different types of SWH systems that have been differentiated by the user. "]
[null,"Section C. GHG Reduction Goal: Enter the GHG reduction goal for which you want the model to find the quantity of SWH systems that would be needed to reach it. Enter GHG reduction goal in the units shown in the grey cell. To enter in a different unit, change the selection in Input 1 on Input Sheet I."]
[null,"Section D. Calculate SWH Goal: The user clicks the \"Calculate SWH Goal\" button to receive the total quantity of SWH required to reach the GHG reduction goal outlined in Section C. It's important to note that for the button to work macros must be enabled in Excel. Macros may be enabled in Excel help (see Macro Troubleshooting below). \n\nNote, there will be a brief period where Excel will perform functions automatically. The duration will depend on the speed of your computer and should generally last between 5 and 20 seconds. Do not press any keys while this automated process is running. Once completed, the macro will return your cursor to the \"SWH Goal Module\" tab with results selected."]
[null,"Macro troubleshooting: The model use a simple program (\"macro\") to calculate FIT rates based on the inputs.  To use this feature, Macros must be enabled in Excel:"]
[null,"1. Ensure the model is saved in a macro-enabled format ( it will have a \".xlsm\" extension in the file name).  If it is not, choose \"Save As\" and select the macro-enabled format from the list.  Then close and re-open Excel."]
[null,"2. Ensure macros are enabled in Excel options.  Depending on the version of Excel you are using, this option can generally be found by clicking the Office icon (Excel 2007) or \"File\" menu (Excel 2010 and higher) in the top left of the screen, selecting \"Options\" or \"Excel Options\", then \"Trust Center\", \"Trust Center Settings\", \"Macro Settings\" and selecting the \"Enable all macros\" option.  Save, close, and re-open the file if needed. For more information, please refer to Microsoft Excel Help for \"enabling macros.\""]
[null,"Section E. Total Quantity and Output of SWH Needed to Reach SWH Goal: The total quantity of SWH (and output of those systems) required to reach the GHG goal specified in Section C above will be identified in this section once the \"Calculate SWH Goal\" button has been activated. Note that results will also be populated in the \"GHG Report\" sheet."]
[]
[4,"Viewing and printing results "]
[]
[null,"Results can be viewed in a simple summary sheet that provides the GHG emission reductions as a result of the SWH installations in table and graphic form. The information provided includes the output of solar water heating systems installed, the total greenhouse gas reductions in kg CO2e/yr and in the form of useful equivalencies such as passenger vehicles on the road, barrels of oil burned and tonnes of coal burned (note: the avoided emissions is equivalent to any, but not all, of these three equivalencies), and the GHG reductions avoided by each fossil fuel type.  The report is designed to serve as a printable or publishable summary document of the data."]
[null,"Note that mandatory data (blue cells) in Input Sheets I and II is required to calculate the greenhouse gas emission reductions. Missing data means the greenhouse gas emission reductions cannot be calculated and errors will appear in this report. "]

{"sheet":"Input Sheet I","index":10,"n_rows":75,"n_cols":75,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,9,74,10],[5,2,5,3],[27,2,27,10],[44,2,44,10],[52,2,52,10],[62,2,62,10],[34,2,34,3],[30,2,30,3],[29,2,29,3],[35,2,35,3],[20,2,21,2],[10,8,10,9],[11,8,11,9],[8,2,8,10],[13,2,13,10],[18,2,18,10],[11,2,11,3],[10,2,10,3],[10,5,10,6],[11,5,11,6],[3,3,3,7]]}
[{"$f":"'User Manual'!A1:F1","v":"Greenhouse Gas Calculator for Residential Solar Water Heating"},null,null,null,null,null,null,null,null,"Legend"]
["Input Sheet I: Calculating the Output of SWH Systems",null,null,null,null,null,null,null,null,"Context Help","Input field (optional)"]
[null,null,null,null,null,null,null,null,null,"Calculated","Input field (mandatory)"]
["Enter Country Name:",null,null,null,null,null,null,null,null,"Data Label","Intermediate or final result"]
[]
[null,null,"t RETURN TO USER MANUAL"]
[]
[]
[1,"?","Preferred Units of Measurement"]
[]
[null,null,"1A. SWH System Size",null,null,"1B. Heat Output",null,null,"1C. Greenhouse Gas Emissions"]
[null,null,"Meters squared of collector area (m2)",null,null,"Kilowatt Hours Therm (kWhth)",null,null,"Metric (kg)"]
[]
[2,"?","Solar Resource of the Country or Region"]
[]
[null,null,"2A. Data Description","2B. Data Source","2C. Unit","2D. Value"]
[null,null,"2A. Solar Insolation","Clean Energy Solutions Center’s Global RE Opportunity Tool","Average Annual Solar Resource (kWh/m2/year)"]
[]
[3,"?","Type of Solar Water Heating Systems"]
[]
[null,null,"3A. Type of SWH System(s)"]
[]
[]
[]
[]
[]
[]
[4,"?","Average Collector Yield"]
[]
[null,null,"4A. Choose Option to Use"]
[null,null,"<select an option>"]
[]
[null,null,"OPTION 1: USE MODEL DEFAULTS"]
[]
[null,null,"4B. Select your country or region:"]
[null,null,"<select a country>",null,null,"OPTION 2: USER ENTERED DATA",null,null,null,null,null,null,null,"<select a country>","Albania","Australia","Austria","Barbados","Belgium","Brazil","Bulgaria","Canada","Chile","China","Croatia","Cyprus","Czech Republic","Denmark","Estonia","Finland","France (mainland)","Germany","Greece","Hungary","India","Ireland","Israel","Italy","Japan","Jordan","Korea, South","Latvia","Lebanon","Lithuania","Luxembourg","Macedonia","Malta","Mauritius","Mexico","Morocco","Mozambique","Namibia","Netherlands","New Zealand","Norway","Palestinian Territ.","Poland","Portugal","Romania","Russia","Slovakia","Slovenia","South Africa","Spain","Sweden","Switzerland","Taiwan","Thailand","Tunisia","Turkey","United Kingdom","United States","Uruguay","Zimbabwe","Avg of all other countries"]
[]
[null,null,"4C. Type of SWH System(s)","4D. Average Collector Yield (%)","OR","4E. Type of SWH System(s)","4F. Average Collector Yield (%)"]
[null,null,{"$f":"IF(OR($C$36=\"<select a country>\",LEFT($C$31,8)=\"Option 2\"),\"\",$C23)","v":""},{"$f":"IF(OR($C$36=\"<select a country>\",NOT(LEFT($C$31,8)=\"Option 1\")),\"\",SUMIF('Back End Data & Calcs'!$B:$B,'Input Sheet I'!$C$36,'Back End Data & Calcs'!$K:$K))","v":""},null,{"$f":"$C$23","v":0},null,null,{"$f":"IF(LEFT($C$31,8)=\"Option 1\",D39,G39)","v":0}]
[null,null,{"$f":"IF(OR($C$36=\"<select a country>\",LEFT($C$31,8)=\"Option 2\"),\"\",$C24)","v":""},{"$f":"IF(OR($C$36=\"<select a country>\",LEFT($C$31,8)=\"Option 2\",ISBLANK(C24)),\"\",SUMIF('Back End Data & Calcs'!$B:$B,'Input Sheet I'!$C$36,'Back End Data & Calcs'!$K:$K))","v":""},null,{"$f":"$C$24","v":0},null,null,{"$f":"IF(LEFT($C$31,8)=\"Option 1\",D40,G40)","v":0}]
[null,null,"",{"$f":"IF(OR($C$36=\"<select a country>\",LEFT($C$31,8)=\"Option 2\",ISBLANK(C25)),\"\",SUMIF('Back End Data & Calcs'!$B:$B,'Input Sheet I'!$C$36,'Back End Data & Calcs'!$K:$K))","v":""},null,{"$f":"$C$25","v":0},null,null,0]
[null,null,"",{"$f":"IF(OR($C$36=\"<select a country>\",LEFT($C$31,8)=\"Option 2\",ISBLANK(C26)),\"\",SUMIF('Back End Data & Calcs'!$B:$B,'Input Sheet I'!$C$36,'Back End Data & Calcs'!$K:$K))","v":""},null,{"$f":"$C$26","v":0},null,null,0]
[]
[]
[5,"?","Average Piping & Storage Losses"]
[]
[null,null,"5A. Type of SWH System","5B. Assumed Average Pipe Losses","5C. Assumed Average Storage Tank Losses","5D. Total System Losses"]
[null,null,{"$f":"C$23","v":0},0.1,0.05,{"$f":"D48+E48","v":0.15000000000000002}]
[null,null,{"$f":"C$24","v":0},null,null,{"$f":"D49+E49","v":0}]
[null,null,{"$f":"C$25","v":0},null,null,0]
[null,null,{"$f":"C$26","v":0},null,null,0]
[]
[6,"?","Amount of Solar Water Heating Systems Installed"]
[]
[null,null,"6A. Type of SWH System","6B. Total collector area",null,"Convert to m2"]
[null,null,null,{"$f":"VLOOKUP($C$12,'Back End Data & Calcs'!$AW:$AX,2,FALSE)","v":"m2"}]
[null,null,{"$f":"C$23","v":0},null,null,{"$f":"IF($D$56='Back End Data & Calcs'!$AX$27,D57,D57*'Back End Data & Calcs'!$AY$28)","v":0}]
[null,null,{"$f":"C$24","v":0},null,null,{"$f":"IF($D$56='Back End Data & Calcs'!$AX$27,D58,D58*'Back End Data & Calcs'!$AY$28)","v":0}]
[null,null,{"$f":"C$25","v":0},null,null,{"$f":"IF($D$56='Back End Data & Calcs'!$AX$27,D59,D59*'Back End Data & Calcs'!$AY$28)","v":0}]
[null,null,{"$f":"C$26","v":0},null,null,{"$f":"IF($D$56='Back End Data & Calcs'!$AX$27,D60,D60*'Back End Data & Calcs'!$AY$28)","v":0}]
[null,null,"Total",{"$f":"SUM(D57:D60)","v":0},null,{"$f":"IF($D$56='Back End Data & Calcs'!$AX$27,D61,D61*'Back End Data & Calcs'!$AY$28)","v":0}]
[]
[7,"?","Total Output of Solar Water Heating Systems"]
[]
[null,null,"7A. Type of SWH System","7B. System Output "]
[null,null,null,{"$f":"VLOOKUP($F$12,'Back End Data & Calcs'!$AW:$AX,2,FALSE)","v":"kWhth/yr"},null,"kWhth/yr"]
[null,null,{"$f":"C$23","v":0},{"$f":"IF($D$66='Back End Data & Calcs'!$AX$31,F67,F67*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(OR(ISBLANK(F57),F57=0),0,$F$17*F57*I39*(1-F48))","v":0}]
[null,null,{"$f":"C$24","v":0},{"$f":"IF($D$66='Back End Data & Calcs'!$AX$31,F68,F68*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(OR(ISBLANK(F58),F58=0),0,$F$17*F58*I40*(1-F49))","v":0}]
[null,null,{"$f":"C$25","v":0},{"$f":"IF($D$66='Back End Data & Calcs'!$AX$31,F69,F69*'Back End Data & Calcs'!$AY$31)","v":0},null,0,null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(\"Use IEA-SHC avg data\",#REF!,0)),1,0)","v":1}]
[null,null,{"$f":"C$26","v":0},{"$f":"IF($D$66='Back End Data & Calcs'!$AX$31,F70,F70*'Back End Data & Calcs'!$AY$31)","v":0},null,0]
[null,null,"Total Output",{"$f":"SUM(D67:D70)","v":0},null,{"$f":"SUM(F67:F70)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"PROCEED TO INPUT SHEET II   u"]

{"sheet":"Input Sheet II","index":11,"n_rows":69,"n_cols":172,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,7,66,10],[68,7,68,10],[53,2,53,9],[29,2,29,9],[19,2,19,9],[8,2,8,9],[42,2,42,3],[43,2,43,3],[40,2,40,9],[3,3,3,7],[5,2,5,3]]}
[{"$f":"'User Manual'!A1:F1","v":"Greenhouse Gas Calculator for Residential Solar Water Heating"},null,null,null,null,null,null,null,"Legend"]
["Input Sheet I: Calculating the Output of SWH Systems",null,null,null,null,null,null,null,"Context Help","Input field (optional)"]
[null,null,null,null,null,null,null,null,"Calculated","Input field (mandatory)"]
["Country/Region Name:",null,null,{"$f":"'Country data'!C3","v":0},null,null,null,null,"Data Label","Intermediate or final result"]
[]
[null,null,"t RETURN TO INPUT SHEET I"]
[]
[]
[8,"?","Type of Fossil Fuel Used that is Avoided by SWH Systems"]
[]
[null,null,"8A. Displaced Fossil Fuel Type","8B. Percent of SWH Replacing Each Fossil Fuel Type"]
[null,null,null,"(%)"]
[null,null,null,1,null,null,null,null,null,null,null,null,null,"<please select from list>",null,"Biodiesels","Biogasoline","Charcoal","Crude Oil","Electricity","Ethane","Gas/Diesel Oil","Liquefied Petroleum Gases","Motor Gasoline","Natural Gas","Natural Gas Liquids","Other Kerosene","Other Liquid Biofuels","Other Primary Solid Biomass","Peat","Residual Fuel Oil","Waste Oils","Wood / Wood Waste"]
[]
[]
[]
[]
[null,null,"TOTAL",{"$f":"SUM(D13:D17)","v":1},{"$f":"IF(D18=1,\"\",\"<--- Must total 100% to ensure that all SWH system output has been associated with a displaced fuel type.\")","v":""}]
[]
[9,"?","Efficiency of Avoided or Replaced Fossil Fuel Systems"]
[]
[null,null,"9A. Displaced Fossil Fuel Type","9B. Avg Efficiency of Displaced Systems"]
[null,null,null,"(%)"]
[null,null,{"$f":"IF(C$13=\"<please select from list>\",\"\",C$13)","v":0},null,null,null,null,null,null,null,null,null,null,"<please select from list>",null,"Biodiesels","Biogasoline","Charcoal","Crude Oil","Electricity","Ethane","Gas/Diesel Oil","Liquefied Petroleum Gases","Motor Gasoline","Natural Gas","Natural Gas Liquids","Other Kerosene","Other Liquid Biofuels","Other Primary Solid Biomass","Peat","Residual Fuel Oil","Waste Oils","Wood / Wood Waste"]
[null,null,{"$f":"IF(C$14=\"<please select from list>\",\"\",C$14)","v":0}]
[null,null,{"$f":"IF(C$15=\"<please select from list>\",\"\",C$15)","v":0}]
[null,null,{"$f":"IF(C$16=\"<please select from list>\",\"\",C$16)","v":0}]
[null,null,{"$f":"IF(C$17=\"<please select from list>\",\"\",C$17)","v":0}]
[]
[10,"?","Total Primary Energy of Avoided Fossil Fuel Consumption"]
[]
[null,null,"10A. Displaced Fossil Fuel Type","10B. Primary Energy Use Avoided "]
[null,null,null,{"$f":"VLOOKUP('Input Sheet I'!$F$12,'Back End Data & Calcs'!$AW:$AZ,4,FALSE)","v":"kWh/yr"},null,{"$f":"'Back End Data & Calcs'!AZ31","v":"kWh/yr"}]
[null,null,{"$f":"IF(C$13=\"<please select from list>\",\"\",C$13)","v":0},{"$f":"IF($D$33='Back End Data & Calcs'!$AX$31,F34,F34*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(ISBLANK(C13),0,D13*'Input Sheet I'!$F$71*(1/D24))","v":0}]
[null,null,{"$f":"IF(C$14=\"<please select from list>\",\"\",C$14)","v":0},{"$f":"IF($D$33='Back End Data & Calcs'!$AX$31,F35,F35*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(ISBLANK(C14),0,D14*'Input Sheet I'!$F$71*(1/D25))","v":0}]
[null,null,{"$f":"IF(C$15=\"<please select from list>\",\"\",C$15)","v":0},{"$f":"IF($D$33='Back End Data & Calcs'!$AX$31,F36,F36*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(ISBLANK(C15),0,D15*'Input Sheet I'!$F$71*(1/D26))","v":0}]
[null,null,{"$f":"IF(C$16=\"<please select from list>\",\"\",C$16)","v":0},{"$f":"IF($D$33='Back End Data & Calcs'!$AX$31,F37,F37*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(ISBLANK(C16),0,D16*'Input Sheet I'!$F$71*(1/D27))","v":0}]
[null,null,{"$f":"IF(C$17=\"<please select from list>\",\"\",C$17)","v":0},{"$f":"IF($D$33='Back End Data & Calcs'!$AX$31,F38,F38*'Back End Data & Calcs'!$AY$31)","v":0},null,{"$f":"IF(ISBLANK(C17),0,D17*'Input Sheet I'!$F$71*(1/D28))","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D34:D38)","v":0}]
[]
[11,"?","Effective CO2e Emissions Factors for Fossil Fuels"]
[]
[null,null,"11A. Select your country or region:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"<select a country>",null,"OECD Americas","Canada","Chile","Mexico","United States",null,"OECD Asia Oceania","Australia","Israel","Japan","Korea","New Zealand",null,"OECD Europe","Austria","Belgium","Czech Republic","Denmark","Estonia","Finland","France","Germany","Greece","Hungary","Iceland","Ireland","Italy","Luxembourg","Netherlands","Norway","Poland","Portugal","Slovak Republic","Slovenia","Spain","Sweden","Switzerland","Turkey","United Kingdom",null,"AFRICA","Algeria","Angola","Benin","Botswana","Cameroon","Congo","Dem. Rep. of Congo","Côte d'Ivoire","Egypt","Eritrea","Ethiopia","Gabon","Ghana","Kenya","Libyan Arab Jamahiriya","Morocco","Mozambique","Namibia","Nigeria","Senegal","South Africa","Sudan","United Rep. of Tanzania","Togo","Tunisia","Zambia","Zimbabwe","Other Africa",null,"ASIA","Bangladesh","Brunei Darussalam","Cambodia","Chinese Taipei","India","Indonesia","DPR of Korea","Malaysia","Mongolia","Myanmar","Nepal","Pakistan","Philippines","Singapore","Sri Lanka","Thailand","Vietnam","Other Asia",null,"CHINA","People's Rep. of China","Hong Kong, China",null,"MIDDLE EAST","Bahrain","Islamic Republic of Iran","Iraq","Jordan","Kuwait","Lebanon","Oman","Qatar","Saudi Arabia","Syrian Arab Republic","United Arab Emirates","Yemen",null,"NON-OECD EUROPE AND EURASIA","Albania","Armenia","Azerbaijan","Belarus","Bosnia and Herzegovina","Bulgaria","Croatia","Cyprus","Georgia","Gibraltar","Kazakhstan","Kyrgyzstan","Latvia","Lithuania","FYR of Macedonia","Malta","Qatar","Romania","Russian Federation","Serbia","Tajikistan","Turkmenistan","Ukraine","Uzbekistan",null,"LATIN AMERICA","Argentina","Bolivia","Brazil","Colombia","Costa Rica","Cuba","Dominican Republic","Ecuador","El Salvador","Guatemala","Haiti","Honduras","Jamaica","Netherlands Antilles","Nicaragua","Panama","Paraguay","Peru","Trinidad and Tobago","Uruguay","Venezuela","Other Latin America"]
[]
[null,null,"11B. Displaced Fossil Fuel Type","11C. Default Effective CO2e Emissions Factor","11D. OPTIONAL: User-Entered Effective CO2e Emissions Factor"]
[null,null,null,"(lbs CO2e/kWh)","(lbs CO2e/kWh)"]
[null,null,{"$f":"IF(C$13=\"<please select from list>\",\"\",C$13)","v":0},{"$f":"IF(C44=\"<select a country>\",\"Choose Country in Input 11A\",IF(C48=\"Electricity\",SUMIF('Back End Data & Calcs'!$AP:$AP,$C$44,'Back End Data & Calcs'!$AQ:$AQ)*0.00220462,SUMIF('Back End Data & Calcs'!$M$28:$M$45,'Input Sheet II'!C48,'Back End Data & Calcs'!$R$28:$R$45)))","v":0},null,{"$f":"IF(E48=0,D48,E48)","v":0},null,null,null,null,null,null,null,"<please select from list>",null,"Biodiesels","Biogasoline","Charcoal","Crude Oil","Electricity","Ethane","Gas/Diesel Oil","Liquefied Petroleum Gases","Motor Gasoline","Natural Gas","Natural Gas Liquids","Other Kerosene","Other Liquid Biofuels","Other Primary Solid Biomass","Peat","Residual Fuel Oil","Waste Oils","Wood / Wood Waste"]
[null,null,{"$f":"IF(C$14=\"<please select from list>\",\"\",C$14)","v":0},{"$f":"IF(C49=\"Electricity\",SUMIF('Back End Data & Calcs'!$AP:$AP,$C$44,'Back End Data & Calcs'!$AQ:$AQ)*0.00220462,SUMIF('Back End Data & Calcs'!$M$28:$M$45,'Input Sheet II'!C49,'Back End Data & Calcs'!$R$28:$R$45))","v":0},null,{"$f":"IF(E49=0,D49,E49)","v":0}]
[null,null,{"$f":"IF(C$15=\"<please select from list>\",\"\",C$15)","v":0},{"$f":"IF(C50=\"Electricity\",SUMIF('Back End Data & Calcs'!$AP:$AP,$C$44,'Back End Data & Calcs'!$AQ:$AQ)*0.00220462,SUMIF('Back End Data & Calcs'!$M$28:$M$45,'Input Sheet II'!C50,'Back End Data & Calcs'!$R$28:$R$45))","v":0},null,0]
[null,null,{"$f":"IF(C$16=\"<please select from list>\",\"\",C$16)","v":0},{"$f":"IF(C51=\"Electricity\",SUMIF('Back End Data & Calcs'!$AP:$AP,$C$44,'Back End Data & Calcs'!$AQ:$AQ)*0.00220462,SUMIF('Back End Data & Calcs'!$M$28:$M$45,'Input Sheet II'!C51,'Back End Data & Calcs'!$R$28:$R$45))","v":0},null,0]
[null,null,{"$f":"IF(C$17=\"<please select from list>\",\"\",C$17)","v":0},{"$f":"IF(C52=\"Electricity\",SUMIF('Back End Data & Calcs'!$AP:$AP,$C$44,'Back End Data & Calcs'!$AQ:$AQ)*0.00220462,SUMIF('Back End Data & Calcs'!$M$28:$M$45,'Input Sheet II'!C52,'Back End Data & Calcs'!$R$28:$R$45))","v":0},null,0]
[]
[12,"?","Total CO2e Emissions Reduced"]
[]
[null,null,"12A. Displaced Fossil Fuel Type","12B. Total CO2e Reduced"]
[null,null,null,{"$f":"VLOOKUP('Input Sheet I'!I12,'Back End Data & Calcs'!AW35:AX36,2,FALSE)","v":"kg CO2e/yr"},null,{"$f":"'Back End Data & Calcs'!$AX$35","v":"lbs CO2e/yr"}]
[null,null,{"$f":"IF(C$13=\"<please select from list>\",\"\",C$13)","v":0},{"$f":"IF($D$57=$F$57,F58,F58*'Back End Data & Calcs'!$AY$35)","v":0},null,{"$f":"IF(ISBLANK(C13),0,F48*F34)","v":0}]
[null,null,{"$f":"IF(C$14=\"<please select from list>\",\"\",C$14)","v":0},{"$f":"IF($D$57=$F$57,F59,F59*'Back End Data & Calcs'!$AY$35)","v":0},null,{"$f":"IF(ISBLANK(C14),0,F49*F35)","v":0}]
[null,null,{"$f":"IF(C$15=\"<please select from list>\",\"\",C$15)","v":0},{"$f":"IF($D$57=$F$57,F60,F60*'Back End Data & Calcs'!$AY$35)","v":0},null,{"$f":"IF(ISBLANK(C15),0,F50*F36)","v":0}]
[null,null,{"$f":"IF(C$16=\"<please select from list>\",\"\",C$16)","v":0},{"$f":"IF($D$57=$F$57,F61,F61*'Back End Data & Calcs'!$AY$35)","v":0},null,{"$f":"IF(ISBLANK(C16),0,F51*F37)","v":0}]
[null,null,{"$f":"IF(C$17=\"<please select from list>\",\"\",C$17)","v":0},{"$f":"IF($D$57=$F$57,F62,F62*'Back End Data & Calcs'!$AY$35)","v":0},null,{"$f":"IF(ISBLANK(C17),0,F52*F38)","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D58:D62)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"USE SWH GOAL MODULE u"]
[]
[null,null,null,null,null,null,null,"PROCEED TO SUMMARY REPORT u"]

{"sheet":"GHG Report","index":12,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,5,8,6],[9,5,9,6],[10,5,10,6],[20,5,20,6],[3,1,3,6],[5,1,5,3],[5,5,5,6],[6,5,6,6],[7,5,7,6],[25,1,25,2],[16,5,16,6],[19,5,19,6],[15,1,16,2],[11,5,11,6],[23,1,23,6],[13,1,13,6],[17,1,17,2],[17,5,17,6]]}
[null,"TechScope Report",null,null,null,null,"Country:"]
[null,{"$f":"'Input Sheet I'!A1","v":"Greenhouse Gas Calculator for Residential Solar Water Heating"},null,null,null,null,{"$f":"'Input Sheet I'!D4","v":0}]
[]
[null,"OUTPUT OF SOLAR WATER HEATING SYSTEMS INSTALLED"]
[]
[null,{"$f":"\"Solar Hot Water Systems Installed (\"&'Input Sheet I'!D56&\")\"","v":"Solar Hot Water Systems Installed (m2)"},null,null,null,{"$f":"\"Energy Output (\"&'Input Sheet I'!D66&\")\"","v":"Energy Output (kWhth/yr)"}]
[null,null,"TOTAL",{"$f":"'Input Sheet I'!D61","v":0},null,{"$f":"'Input Sheet I'!D71","v":0}]
[null,null,{"$f":"'Input Sheet I'!C57","v":0},{"$f":"'Input Sheet I'!D57","v":0},null,{"$f":"'Input Sheet I'!D67","v":0}]
[null,null,{"$f":"'Input Sheet I'!C58","v":0},{"$f":"'Input Sheet I'!D58","v":0},null,{"$f":"'Input Sheet I'!D68","v":0}]
[null,null,{"$f":"'Input Sheet I'!C59","v":0},{"$f":"'Input Sheet I'!D59","v":0},null,{"$f":"'Input Sheet I'!D69","v":0}]
[null,null,{"$f":"'Input Sheet I'!C60","v":0},{"$f":"'Input Sheet I'!D60","v":0},null,{"$f":"'Input Sheet I'!D70","v":0}]
[]
[]
[null,"TOTAL GREENHOUSE GAS REDUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Per million lbs of CO2e","Per million kg of CO2e"]
[null,{"$f":"C33","v":0},null,"Equivalent to:",null,null,null,null,null,null,null,null,{"$f":"'Back End Data & Calcs'!AX35","v":"lbs CO2e/yr"},{"$f":"'Back End Data & Calcs'!AX36","v":"kg CO2e/yr"}]
[null,null,null,null,null,{"$f":"$B$16/1000000*HLOOKUP($B$18,$M$16:$N$20,2,FALSE)","v":0},null,null,null,null,"Passenger Cars",null,95.5,211]
[null,{"$f":"VLOOKUP('Input Sheet I'!I12,'Back End Data & Calcs'!AW35:AX36,2,FALSE)","v":"kg CO2e/yr"},null,null,null,"Passenger Vehicles on the Road",null,null,null,null,"Barrels of Oil",null,1055,2326]
[null,null,null,null,null,null,null,null,null,null,"Pounds of Coal",null,487210,1074114]
[null,null,{"$f":"$B$16/1000000*HLOOKUP($B$18,$M$16:$N$20,3,FALSE)","v":0},null,null,{"$f":"$B$16/1000000*HLOOKUP($B$18,$M$16:$N$20,5,FALSE)","v":0},null,null,null,null,"Tonnes of Coal",null,{"$f":"M19*0.000453592","v":220.99455832000001},{"$f":"N19*0.000453592","v":487.20951748800002}]
[null,null,"Barrels of Oil Burned",null,null,"Tonnes of Coal Burned"]
[]
[]
[null,"GHG REDUCTIONS BY AVOIDED FOSSIL FUEL TYPE"]
[]
[null,"AVOIDED EMISSIONS"]
[null,null,{"$f":"VLOOKUP('Input Sheet I'!I12,'Back End Data & Calcs'!AW35:AX36,2,FALSE)","v":"kg CO2e/yr"}]
[null,{"$f":"'Input Sheet II'!C13","v":0},{"$f":"'Input Sheet II'!D58","v":0},null,null,null,{"$f":"B28","v":0}]
[null,{"$f":"'Input Sheet II'!C14","v":0},{"$f":"'Input Sheet II'!D59","v":0},null,null,null,{"$f":"B29","v":0}]
[null,{"$f":"'Input Sheet II'!C15","v":0},{"$f":"'Input Sheet II'!D60","v":0},null,null,null,0]
[null,{"$f":"'Input Sheet II'!C16","v":0},{"$f":"'Input Sheet II'!D61","v":0},null,null,null,0]
[null,{"$f":"'Input Sheet II'!C17","v":0},{"$f":"'Input Sheet II'!D62","v":0},null,null,null,0]
[null,"TOTAL",{"$f":"'Input Sheet II'!D63","v":0}]
[]
[]
[null,"TechScope GHG Calculator Summary Report",null,null,null,"Date Prepared:",{"$f":"TODAY()","v":"2015-11-09"}]

{"sheet":"SWH Goal Module","index":13,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,6,50,7],[0,0,0,5],[3,3,3,4],[0,6,0,7],[5,2,5,3],[7,2,7,3],[17,2,18,2],[17,3,18,3],[10,2,10,7],[15,2,15,7],[25,2,25,7],[30,2,30,7],[27,2,27,3],[28,2,28,3],[38,2,38,7],[36,2,36,6]]}
["Greenhouse Gas Calculator for Residential Solar Water Heating",null,null,null,null,null,"Legend"]
["Setting a SWH Target to Achieve GHG Emissions Reduction Goals",null,null,null,null,null,"Context Help","Input field (optional)"]
[null,null,null,null,null,null,"Calculated","Input field (mandatory)"]
["Country/Region Name:",null,null,{"$f":"'Country data'!C3","v":0},null,null,"Data Label","Intermediate or final result"]
[]
[null,null,"t RETURN TO INPUT SHEET I"]
[]
[null,null,"t RETURN TO INPUT SHEET II"]
[]
[]
["A","i","SWH Output and Avoided Fossil Fuel Emissions Inputs"]
[]
[null,null,"Follow instructions in Input Sheet I to complete sections 1-5. It is not necessary to complete Section 6."]
[null,null,"Follow instructions in Input Sheet II to complete sections 8-11."]
[]
["B","i","Relative Portion of Different Types of SWH System"]
[]
[null,null,"B1. Type of SWH System","B2. Percent of total collector area (%)"]
[]
[null,null,{"$f":"'Input Sheet I'!C23","v":0},1]
[null,null,{"$f":"'Input Sheet I'!C24","v":0}]
[null,null,{"$f":"'Input Sheet I'!C25","v":0}]
[null,null,{"$f":"'Input Sheet I'!C26","v":0}]
[null,null,"Total",{"$f":"SUM(D20:D23)","v":1},{"$f":"IF(D24=1,\"\",\"<--- Must total 100%.\")","v":""}]
[]
["C","i","GHG Reduction Goal"]
[]
[]
[null,null,{"$f":"VLOOKUP('Input Sheet I'!I12,'Back End Data & Calcs'!AW35:AX36,2,FALSE)","v":"kg CO2e/yr"}]
[]
["D","i","Calculate SWH Goal"]
[]
[]
[null,null,null,null,{"$f":"C28-'Input Sheet II'!D63","v":0}]
[]
[]
[null,null,"Note: This function requires that Macros be enabled under Excel settings. Click this link for more information on how to enable Macros."]
[]
["E","i","Total Quantity and Output of SWH Needed to Reach SWH Goal",null,null,null,null,null,null,"\n"]
[]
[null,null,"E1. Type of SWH System","E2. Quantity of SWH","E3. Output of SWH Systems"]
[null,null,null,{"$f":"'Input Sheet I'!D56","v":"m2"},{"$f":"'Input Sheet I'!D66","v":"kWhth/yr"}]
[null,null,{"$f":"'Input Sheet I'!C23","v":0},{"$f":"D$47*D20","v":0},{"$f":"D43*0.7/1000","v":0}]
[null,null,{"$f":"'Input Sheet I'!C24","v":0},{"$f":"D$47*D21","v":0},{"$f":"D44*0.7/1000","v":0}]
[null,null,{"$f":"'Input Sheet I'!C25","v":0},{"$f":"D$47*D22","v":0},0]
[null,null,{"$f":"'Input Sheet I'!C26","v":0},{"$f":"D$47*D23","v":0},0]
[null,null,{"$f":"'Input Sheet I'!C61","v":"Total"},null,0]
[]
[]
[]
[null,null,null,null,null,null,"PROCEED TO SUMMARY REPORT u"]

{"sheet":"Back End Data & Calcs","index":14,"n_rows":154,"n_cols":52,"rows_kept":154,"cut":false,"hidden":true,"merged":[[2,12,2,19]]}
[null,"Module Efficiency for OECD Countires",null,null,null,null,null,null,null,null,null,null,"GHG Emissions Factors for Stationary Combustion Fuels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Country Generation Mixes",null,null,null,null,null,null,null,null,null,null,null,null,null,"GHG Emissions from Electricty per kWh",null,null,null,null,null,null,"Unit Conversions"]
[null,"Source: IEA-SHC (2013). Solar Heating Worldwide 2015 Edition.",null,null,null,null,null,null,null,null,null,null,"Source: IPCC (2006). Guidelines for National Greenhouse Gas Inventories. Chapter 2: Stationary Combustion",null,null,null,null,null,null,null,"Alternate Source (US-focused):",null,null,null,null,null,null,"Source: CO2 Emissions from Fuel Combustion (2014 Edition), IEA, Paris.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: CO2 Emissions From Fuel Combustion Highlights 2011"]
[null,"http://www.iea-shc.org/data/sites/1/publications/Solar-Heat-Worldwide-2015.pdf ",null,null,null,null,null,null,null,null,null,null," TABLE 2.5: DEFAULT EMISSION FACTORS FOR STATIONARY COMBUSTION IN THE RESIDENTIAL AND AGRICULTURE/FORESTRY/FISHING/FISHING FARMS CATEGORIES ",null,null,null,null,null,null,null,"EIA Carbon Dioxide Emissions Coefficients",null,null,null,null,null,null,null,"COAL",null,null,"OIL",null,null,"GAS",null,null,"TOTAL",null,null,null,"grammes CO 2 / kilowatt hour"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Global Warming Potentials (GWP) for CH4 and N20 from 2013 IPCC AR5 (100 year)",null,null,null,null,null,null,null,"http://www.eia.gov/environment/emissions/co2_vol_mass.cfm",null,null,null,null,null,null,null,2010,2011,2012,2010,2011,2012,2010,2011,2012,2010,2011,2012]
[null,"Country","Total\ncollector area\n[m²]","Total\ncapacity\n[MWth]","Calculated\nnumber\nof systems","Collector yield [GWh/a]","Energy\nsavings\n[toe/a]","CO2\nreduction\n[tCO2/a]","Yield per m2 [kWh/a/m2]","Insolation [kWh/m2/year]","Efficiency of Selected Country",null,"kg / TJ","CO2","CH4","N2O","CO2e","CO2e (kg/MMBtu)",null,null,null,"lbs CO2","Kg CO2","Lbs CO2 per MMBTU","Kg CO2 per MMBtu",null,null,"million tonnes of CO2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Country/Region",2009]
[null,"Albania",141885,99,18188,99,10664,34473,{"$f":"F6*1000000/C6","v":697.74817633999362},{"$f":"IF($B6='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B6='Input Sheet I'!$C$36,I6/J6,\"\")","v":""},null,"GWP",null,34,298,null,null,null,null,null,null,null,null,null,null,null,"World",13136.30089,13751.78369,13923.758309999999,10990.400540000001,11103.029920000001,11205.38622,6214.8299610000004,6327.2531440000002,6439.7777980000001,{"$f":"AI6+AF6+AC6","v":30341.531391000004},{"$f":"AJ6+AG6+AD6","v":31182.066754000003},31568.922328000001,null,"Africa",643]
[null,"Australia",8023000,5616,1024556,4992,536591,1734637,{"$f":"F7*1000000/C7","v":622.21114296397855},{"$f":"IF($B7='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B7='Input Sheet I'!$C$36,I7/J7,\"\")","v":""},null,null,null,null,null,null,null,null,null,"For homes and businesses",null,null,null,null,"Compare to IPCC",null,"Albania",0.44742599999999999,0.560477,0.65482399999999996,3.4252220000000002,3.544457,3.1407880000000001,2.6869000000000001E-2,2.8024E-2,3.0886E-2,{"$f":"AI7+AF7+AC7","v":3.8995170000000003},{"$f":"AJ7+AG7+AD7","v":4.1329579999999995},{"$f":"AK7+AH7+AE7","v":3.8264980000000004},null,"Albania",11]
[null,"Austria",5056098,3539,503348,2044,219716,710276,404.26431607931647,{"$f":"IF($B8='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B8='Input Sheet I'!$C$36,I8/J8,\"\")","v":""},null,"Crude Oil",73300,10,0.6,{"$f":"N8+O$6*O8+P$6*P8","v":73818.8},null,null,null,"Propane","12.7/gallon","5.8/gallon",139,63.1,null,null,"Algeria",0.73182999999999998,0.58884800000000004,0.58398700000000003,43.748567999999999,46.821243000000003,50.903882000000003,53.034022999999998,56.472509000000002,62.859591000000002,97.514420999999999,103.88260000000001,114.34746,null,"Algeria",576]
[null,"Barbados",131690,92,26977,112,12024,38869,850.48219302908342,{"$f":"IF($B9='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B9='Input Sheet I'!$C$36,I9/J9,\"\")","v":""},null,"Natural Gas Liquids",64200,10,0.6,64718.8,{"$f":"Q9*0.00105505585","v":68.281948544979997},null,null,"Butane","14.8/gallon","6.7/gallon",143.19999999999999,65,null,null,"Angola",0,0,0,14.310244000000001,14.294214,15.005476,1.398917,1.4351780000000001,1.4504459999999999,15.709161000000002,15.729392000000001,16.455922000000001,null,"Angola",237]
[null,"Belgium",487783,341,99922,199,21379,69112,407.96829737813744,{"$f":"IF($B10='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B10='Input Sheet I'!$C$36,I10/J10,\"\")","v":""},null,"Motor Gasoline",69300,10,0.6,69818.8,73.662733379979997,null,null,"Butane/Propane Mix","13.7/gallon","6.2/gallon",141.1,64,null,null,"Argentina",5.6286759999999996,6.4096549999999999,5.4811649999999998,81.348856999999995,84.278188999999998,87.251237000000003,89.354636999999997,93.016969000000003,95.776381999999998,176.33216999999999,183.704813,188.50878400000002,null,"Argentina",393]
[null,"Brazil",9609263,6726,1549301,6407,688607,2226059,666.7524866371125,{"$f":"IF($B11='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B11='Input Sheet I'!$C$36,I11/J11,\"\")","v":""},null,"Other Kerosene",71900,10,0.6,72418.8,76.405878589979991,null,null,"Home Heating and Diesel Fuel","22.4/gallon","10.2/gallon",161.30000000000001,73.2,{"$f":"R12","v":78.727001459980002},null,"Armenia",2.3869999999999998E-3,0,4.7739999999999996E-3,1.022748,0.95977500000000004,0.914381,3.0165549999999999,3.7035100000000001,4.5044219999999999,4.04169,4.6632850000000001,5.4235769999999999,null,"Armenia",108]
[null,"Bulgaria",126200,88,23209,66,7071,22859,522.97939778129955,{"$f":"IF($B12='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B12='Input Sheet I'!$C$36,I12/J12,\"\")","v":""},null,"Gas/Diesel Oil",74100,10,0.6,74618.8,78.727001459980002,null,null,"Kerosene","21.5/gallon","9.8/gallon",159.4,72.3,{"$f":"R11","v":76.405878589979991},null,"Australia",198.60026099999999,190.60791900000001,188.166111,119.51797000000001,123.495422,128.82367300000001,68.741782000000001,73.762978000000004,68.842599000000007,386.86001299999998,387.86631899999998,385.83238300000005,null,"Asia",745]
[null,"Canada",889370,623,14894,423,45489,147051,475.61757198916087,{"$f":"IF($B13='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B13='Input Sheet I'!$C$36,I13/J13,\"\")","v":""},null,"Residual Fuel Oil",77400,10,0.6,77918.8,82.20868576497999,null,null,"Coal (All types)","4,631.5/short ton","2,100.8/short ton",210.2,95.3,null,null,"Austria",14.457291,15.237035000000001,13.908768,33.056257000000002,31.241133999999999,30.645074999999999,18.89676,17.929437,17.07499,66.410308000000001,64.407606000000001,61.628833,null,"Australia",853]
[null,"Chile",139309,98,17525,105,11232,36310,753.72014729845159,{"$f":"IF($B14='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B14='Input Sheet I'!$C$36,I14/J14,\"\")","v":""},null,"Liquefied Petroleum Gases",63100,5,0.1,63299.8,66.784824293829999,null,null,"Natural Gas","119.9/thousand cubic feet","54.4/thousand cubic feet",117,53.1,{"$f":"R16","v":59.399433343829998},null,"Azerbaijan",0,0,0,7.7562119999999997,9.1881219999999999,9.9764549999999996,16.066693000000001,17.603406,19.297820000000002,23.822904999999999,26.791528,29.274275000000003,null,"Austria",163]
[null,"China",374660000,262262,85403747,217841,23413743,75689608,581.43650242886883,{"$f":"IF($B15='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B15='Input Sheet I'!$C$36,I15/J15,\"\")","v":""},null,"Ethane",61600,5,0.1,61799.8,65.202240518829996,null,null,"Gasoline","19.6/gallon","8.9/gallon",157.19999999999999,71.3,{"$f":"R10","v":73.662733379979997},null,"Bahrain",0,0,0,4.1764419999999998,4.0740170000000004,4.6700390000000001,23.883012000000001,23.985782,24.137996000000001,28.059454000000002,28.059799000000002,28.808035,null,"Azerbaijan",443]
[null,"Croatia",145565,102,29819,75,8093,26164,515.23374437536495,{"$f":"IF($B16='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B16='Input Sheet I'!$C$36,I16/J16,\"\")","v":""},null,"Natural Gas",56100,5,0.1,56299.8,59.399433343829998,null,null,"Residual Heating Fuel (Businesses only)","26/gallon","11.8/gallon",173.7,78.8,{"$f":"R13","v":82.20868576497999},null,"Bangladesh",3.1389290000000001,2.8304740000000002,3.5017130000000001,11.012465000000001,14.411137999999999,15.363149,38.349029000000002,38.282729000000003,40.688299000000001,52.500422999999998,55.524341000000007,59.553161000000003,null,"Bahrain",665]
[null,"Cyprus",700947,491,154463,623,66964,216475,888.79758384014769,{"$f":"IF($B17='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B17='Input Sheet I'!$C$36,I17/J17,\"\")","v":""},null,"Waste Oils",73300,300,4,84692,89.354790048199987,null,null,null,null,null,null,null,null,null,"Belarus",2.2108660000000002,2.3334920000000001,2.999978,20.948875999999998,24.200901000000002,29.694241000000002,41.193148000000001,38.921919000000003,38.301513999999997,64.352890000000002,65.456312000000011,70.995733000000001,null,"Bangladesh",585]
[null,"Czech Republic",971269,680,68205,332,35636,115202,341.82085498456144,{"$f":"IF($B18='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B18='Input Sheet I'!$C$36,I18/J18,\"\")","v":""},null,"Peat",106000,300,1.4,116617.2,123.03765907061998,null,null,null,null,null,null,null,null,null,"Belgium",13.354547999999999,12.509474000000001,11.058885999999999,53.990988000000002,50.582061000000003,48.891815000000001,38.826666000000003,34.921702000000003,33.432319,106.172202,98.013237000000004,93.383020000000002,null,"Belarus",302]
[null,"Denmark",785090,550,91965,335,35964,116260,426.70267103134671,{"$f":"IF($B19='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B19='Input Sheet I'!$C$36,I19/J19,\"\")","v":""},null,"Wood / Wood Waste",112000,300,4,123392,130.18545144319998,null,null,null,null,null,null,null,null,null,"Benin",0,0,0,4.5048680000000001,4.6970390000000002,4.9493359999999997,0,0,0,4.5048680000000001,4.6970390000000002,4.9493359999999997,null,"Belgium",218]
[null,"Estonia",8520,6,1745,4,379,1225,469.48356807511738,{"$f":"IF($B20='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B20='Input Sheet I'!$C$36,I20/J20,\"\")","v":""},null,"Other Primary Solid Biomass",100000,300,4,111392,117.5247812432,null,null,null,null,null,null,null,null,null,"Bolivia",0,0,0,8.0267389999999992,8.609337,9.2698959999999992,6.0345219999999999,6.6391099999999996,7.0491809999999999,14.061260999999998,15.248446999999999,16.319077,null,"Benin",725]
[null,"Finland",52202,37,10694,22,2358,7621,421.43979157886673,{"$f":"IF($B21='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B21='Input Sheet I'!$C$36,I21/J21,\"\")","v":""},null,"Charcoal",112000,200,1,119098,125.65504162329999,null,null,null,null,null,null,null,null,null,"Bosnia and Herzegovina",15.190377,17.924491,16.65241,4.391947,4.3576740000000003,4.084632,0.46456799999999998,0.52864800000000001,0.486759,20.046892,22.810813,21.223801000000002,null,"Bolivia",64]
[null,"France (mainland)",2370399,1659,372260,1144,122955,397476,482.61917086532691,{"$f":"IF($B22='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B22='Input Sheet I'!$C$36,I22/J22,\"\")","v":""},null,"Biogasoline",70800,10,0.6,71318.8,75.24531715498,null,null,null,null,null,null,null,null,null,"Botswana",2.1985619999999999,1.7697929999999999,1.5707139999999999,2.6143269999999998,2.7720630000000002,2.9018440000000001,0,0,0,4.8128890000000002,4.5418560000000001,4.4725580000000003,null,"Bosnia and Herzegovina",776]
[null,"Germany",17514176,12260,1915127,7124,765699,2475274,406.75621850551232,{"$f":"IF($B23='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B23='Input Sheet I'!$C$36,I23/J23,\"\")","v":""},null,"Biodiesels",70800,10,0.6,71318.8,75.24531715498,null,null,null,null,null,null,null,null,null,"Brazil",52.720688000000003,55.049708000000003,57.730891,284.03548799999999,302.604736,322.77598799999998,51.767712000000003,50.346926000000003,59.733074999999999,388.523888,408.00137000000001,440.23995399999995,null,"Botswana",63]
[null,"Greece",4178350,2925,1612857,3207,344706,1114330,767.52785190326324,{"$f":"IF($B24='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B24='Input Sheet I'!$C$36,I24/J24,\"\")","v":""},null,"Other Liquid Biofuels",79600,10,0.6,80118.8,84.52980863498,null,null,null,null,null,null,null,null,null,"Brunei Darussalam",0,0,0,1.730191,1.871853,1.993519,5.8329930000000001,6.3970799999999999,6.4027799999999999,7.5631839999999997,8.2689330000000005,8.3962989999999991,null,"Brazil",175]
[null,"Hungary",252100,176,29185,114,12215,39489,452.20150733835777,{"$f":"IF($B25='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B25='Input Sheet I'!$C$36,I25/J25,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"Q25*0.00105505585","v":0},null,null,null,null,null,null,null,null,"Bulgaria",28.146100000000001,33.182301000000002,28.237448000000001,10.975387,10.112863000000001,10.580731999999999,5.0739260000000002,5.7914349999999999,5.4497489999999997,44.195413000000002,49.086599000000007,44.267928999999995,null,"Brunei Darussalam",755]
[null,"India",6231200,4362,1125978,5221,561170,1814094,837.88034407497753,{"$f":"IF($B26='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B26='Input Sheet I'!$C$36,I26/J26,\"\")","v":""},null,"lbs / kWh","1 kg =",2.2046199999999998,"lbs","1 TJ = ",277777.77799999999,"kWh",null,null,null,null,null,null,null,null,"Cambodia",3.1829000000000003E-2,3.5574000000000001E-2,3.9317999999999999E-2,3.724456,3.9925079999999999,4.1323590000000001,0,0,0,3.7562850000000001,4.0280820000000004,4.1716769999999999,null,"Bulgaria",463,null,null,null,null,null,null,null,"multipler to other"]
[null,"Ireland",277619,194,64250,116,12493,40386,417.83883667904576,{"$f":"IF($B27='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B27='Input Sheet I'!$C$36,I27/J27,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cameroon",0,0,0,4.5449960000000003,4.6888439999999996,4.8893279999999999,0.484954,0.50484300000000004,0.52794399999999997,5.0299500000000004,5.1936869999999997,5.4172719999999996,null,"Cambodia",151,null,null,null,null,null,"Meters squared of collector area (m2)","m2",0.7]
[null,"Israel",4150115,2905,1372992,3888,417912,1350983,936.84150921119056,{"$f":"IF($B28='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B28='Input Sheet I'!$C$36,I28/J28,\"\")","v":""},null,"Crude Oil",null,null,null,null,{"$f":"Q8*$O$26/$R$26","v":0.58587264981290188},null,null,null,null,null,null,null,null,null,"Canada",91.192871999999994,84.927441000000002,71.880010999999996,260.909221,261.21617900000001,266.80296199999998,178.54779099999999,189.764501,194.28488400000001,530.64988399999993,535.90812100000005,532.96785699999998,null,"Cameroon",243,null,null,null,null,null,"System capacity (kWth)","kWth",{"$f":"1/0.7","v":1.4285714285714286}]
[null,"Italy",3692896,2585,632778,2266,243579,787419,613.61056471668849,{"$f":"IF($B29='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B29='Input Sheet I'!$C$36,I29/J29,\"\")","v":""},null,"Natural Gas Liquids",null,null,null,null,{"$f":"Q9*$O$26/$R$26","v":0.51364929867068054},null,null,null,null,null,null,null,null,null,"Chile",17.165251000000001,20.946321000000001,24.097113,42.794409000000002,44.227148,44.319997000000001,9.8145860000000003,10.851198,9.3541159999999994,69.774246000000005,76.024666999999994,77.771225999999999,null,"Canada",167]
[null,"Japan",4074396,2852,995253,2366,254254,821926,580.69956872135162,{"$f":"IF($B30='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B30='Input Sheet I'!$C$36,I30/J30,\"\")","v":""},null,"Motor Gasoline",null,null,null,null,0.55412612183829912,null,null,null,null,null,null,null,null,null,"Chinese Taipei",154.77412200000001,149.50272899999999,147.09207499999999,82.638947000000002,78.222069000000005,74.926749000000001,30.425483,33.277954000000001,31.532098000000001,267.83855199999999,261.00275199999999,253.55092200000001,null,"Chile",373,null,null,null,null,null,null,null,null,"For primary energy"]
[null,"Jordan",1192270,835,211031,1129,121342,392261,946.93316111283514,{"$f":"IF($B31='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B31='Input Sheet I'!$C$36,I31/J31,\"\")","v":""},null,"Other Kerosene",null,null,null,null,0.57476136502179087,null,null,null,null,null,null,null,null,null,"Colombia",10.49394,12.253166,9.4696639999999999,32.850290000000001,38.219788000000001,39.795974999999999,18.419871000000001,17.401896000000001,18.086639999999999,61.764101000000004,67.874850000000009,67.352278999999996,null,"China",743,null,null,null,null,null,"Kilowatt Hours Therm (kWhth)","kWhth/yr",{"$f":"3412.14163/1000000","v":3.4121416300000001E-3},"kWh/yr"]
[null,"Korea, South",1762570,1234,254163,871,93632,302683,494.16477076087756,{"$f":"IF($B32='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B32='Input Sheet I'!$C$36,I32/J32,\"\")","v":""},null,"Gas/Diesel Oil",null,null,null,null,0.59222195540782241,null,null,null,null,null,null,null,null,null,"Congo",0,0,0,1.6115250000000001,1.7706569999999999,1.884142,0.19702500000000001,0.28798099999999999,0.29907899999999998,1.8085500000000001,2.0586379999999997,2.1832210000000001,null,"Chinese Taipei",635,null,null,null,null,null,"Millions of Btus (MMBtu)","MMBtu/yr",{"$f":"1/AY31","v":293.0710704408832},"MMBtu/yr"]
[null,"Latvia",6040,4,1237,3,286,923,496.68874172185429,{"$f":"IF($B33='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B33='Input Sheet I'!$C$36,I33/J33,\"\")","v":""},null,"Residual Fuel Oil",null,null,null,null,0.61841284098686966,null,null,null,null,null,null,null,null,null,"Costa Rica",0.26215300000000002,0.25776500000000002,0.26504299999999997,6.2677709999999998,6.424023,6.489058,0,0,0,6.5299239999999994,6.6817880000000001,6.7541010000000004,null,"Colombia",40]
[null,"Lebanon",561000,393,60251,465,49934,161421,828.87700534759358,{"$f":"IF($B34='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B34='Input Sheet I'!$C$36,I34/J34,\"\")","v":""},null,"Liquefied Petroleum Gases",null,null,null,null,0.50238721787169027,null,null,null,null,null,null,null,null,null,"Côte d'Ivoire",0,0,0,3.1060020000000002,2.782613,4.5007260000000002,3.0993780000000002,3.0553780000000001,3.3327629999999999,6.2053799999999999,5.8379910000000006,7.8334890000000001,null,"Congo",207]
[null,"Lithuania",8200,6,1680,4,380,1229,487.80487804878049,{"$f":"IF($B35='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B35='Input Sheet I'!$C$36,I35/J35,\"\")","v":""},null,"Ethane",null,null,null,null,0.49048226988121424,null,null,null,null,null,null,null,null,null,"Croatia",2.6778789999999999,2.7547969999999999,2.4678390000000001,10.606557,10.579291,9.8567219999999995,5.6893380000000002,5.4201030000000001,4.8321420000000002,18.973774000000002,18.754190999999999,17.156703,null,"Costa Rica",752,null,null,null,null,null,"British (lbs)","lbs CO2e/yr",0.453592]
[null,"Luxembourg",45800,32,9382,20,2134,6899,436.68122270742356,{"$f":"IF($B36='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B36='Input Sheet I'!$C$36,I36/J36,\"\")","v":""},null,"Natural Gas",null,null,null,null,0.44683079391613534,null,null,null,null,null,null,null,null,null,"Cuba",7.7877000000000002E-2,6.7202999999999999E-2,6.4630999999999994E-2,27.822267,26.562526999999999,26.795356999999999,2.0267580000000001,1.935754,1.9561470000000001,29.926902000000002,28.565483999999998,28.816134999999999,null,"Côte d'Ivoire",426,null,null,null,null,null,"Metric (kg)","kg CO2e/yr",{"$f":"1/AY35","v":2.2046244201837775}]
[null,"Macedonia",47130,33,10613,29,3131,10122,615.31932951410988,{"$f":"IF($B37='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B37='Input Sheet I'!$C$36,I37/J37,\"\")","v":""},null,"Waste Oils",null,null,null,null,0.67216923680626461,null,null,null,null,null,null,null,null,null,"Cyprus",6.5160999999999997E-2,2.8989999999999998E-2,5.1500000000000005E-4,7.0988499999999997,6.9182990000000002,6.4608720000000002,0,0,0,7.1640109999999995,6.9472890000000005,6.4613870000000002,null,"Croatia",283]
[null,"Malta",48448,34,9925,40,4320,13966,825.62747688243064,{"$f":"IF($B38='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B38='Input Sheet I'!$C$36,I38/J38,\"\")","v":""},null,"Peat",null,null,null,null,0.92554780052996166,null,null,null,null,null,null,null,null,null,"Czech Republic",73.217631999999995,73.850605000000002,69.391850000000005,22.818742,22.149602999999999,21.749306000000001,17.388577000000002,15.879116,15.609249999999999,113.42495099999999,111.879324,106.750406,null,"Cuba",591]
[null,"Mauritius",115113,81,61952,94,10139,32777,816.58891697723107,{"$f":"IF($B39='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B39='Input Sheet I'!$C$36,I39/J39,\"\")","v":""},null,"Wood / Wood Waste",null,null,null,null,0.97931689496054641,null,null,null,null,null,null,null,null,null,"Dem. Rep. of Congo",0,0,0,1.813256,2.2837369999999999,2.4004159999999999,1.6622999999999999E-2,1.6622999999999999E-2,1.6622999999999999E-2,1.829879,2.30036,2.4170389999999999,null,"Cyprus",744]
[null,"Mexico",2497077,1748,129536,1372,147472,476732,549.44240806350786,{"$f":"IF($B40='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B40='Input Sheet I'!$C$36,I40/J40,\"\")","v":""},null,"Other Primary Solid Biomass",null,null,null,null,0.88407731103673803,null,null,null,null,null,null,null,null,null,"Denmark",15.328884,12.767220999999999,10.035914999999999,19.845389000000001,18.600293000000001,17.138199,10.338596000000001,8.8203060000000004,8.1236049999999995,45.512869000000002,40.187820000000002,35.297719000000001,null,"Czech Republic",514]
[null,"Morocco",415000,291,85013,354,38076,123089,853.01204819277109,{"$f":"IF($B41='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B41='Input Sheet I'!$C$36,I41/J41,\"\")","v":""},null,"Charcoal",null,null,null,null,0.94523699717981025,null,null,null,null,null,null,null,null,null,"Dominican Republic",2.9824410000000001,3.1068169999999999,3.338822,14.439572,14.311669,14.271988,1.5030300000000001,1.736618,2.2006299999999999,18.925043000000002,19.155104000000001,19.811440000000001,null,"Dem. Rep. of Congo",3]
[null,"Mozambique",416,0,85,0,36,118,0,{"$f":"IF($B42='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B42='Input Sheet I'!$C$36,I42/J42,\"\")","v":""},null,"Biogasoline",null,null,null,null,0.56603106982877505,null,null,null,null,null,null,null,null,null,"DPR of Korea",61.685192000000001,42.541983999999999,42.905164999999997,2.5442580000000001,2.618439,2.5102009999999999,0,0,0,64.22945,45.160423000000002,45.415365999999999,null,"Denmark",303]
[null,"Namibia",22006,15,2718,20,2158,6975,908.84304280650736,{"$f":"IF($B43='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B43='Input Sheet I'!$C$36,I43/J43,\"\")","v":""},null,"Biodiesels",null,null,null,null,0.56603106982877505,null,null,null,null,null,null,null,null,null,"Ecuador",0,0,0,30.979133999999998,30.787578,31.949432999999999,0.98974799999999996,0.87453599999999998,1.1474500000000001,31.968881999999997,31.662113999999999,33.096882999999998,null,"Dominican Republic",290]
[null,"Netherlands",880450,616,132899,310,33302,107655,352.09267987960703,{"$f":"IF($B44='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B44='Input Sheet I'!$C$36,I44/J44,\"\")","v":""},null,"Other Liquid Biofuels",null,null,null,null,0.63587343137290131,null,null,null,null,null,null,null,null,null,"Egypt",1.6066640000000001,1.6066640000000001,1.474286,102.154285,101.127719,107.199105,80.283392000000006,87.725869000000003,88.180581000000004,184.044341,190.460252,196.853972,null,"DPR of Korea",499]
[null,"New Zealand",159645,112,32703,99,10592,34241,620.12590435027721,{"$f":"IF($B45='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B45='Input Sheet I'!$C$36,I45/J45,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El Salvador",0,0,0,5.8464600000000004,6.0297939999999999,6.1504770000000004,0,0,0,5.8464600000000004,6.0297939999999999,6.1504770000000004,null,"Ecuador",319]
[null,"Norway",39576,28,1502,15,1573,5084,379.01758641600969,{"$f":"IF($B46='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B46='Input Sheet I'!$C$36,I46/J46,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eritrea",0,0,0,0.47611100000000001,0.51045600000000002,0.54172100000000001,0,0,0,0.47611100000000001,0.51045600000000002,0.54172100000000001,null,"Egypt",466]
[null,"Palestinian Territ.",1627000,1139,979454,1580,169832,549015,971.11247695144436,{"$f":"IF($B47='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B47='Input Sheet I'!$C$36,I47/J47,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estonia",14.179239000000001,13.309291,11.997204999999999,2.9844490000000001,3.0130710000000001,3.0833089999999999,1.314238,1.175878,1.266106,18.477926,17.498239999999999,16.346619999999998,null,"El Salvador",349]
[null,"Poland",1485000,1040,186863,606,65177,210698,408.08080808080808,{"$f":"IF($B48='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B48='Input Sheet I'!$C$36,I48/J48,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethiopia",0.119593,0.40661799999999998,0.81323599999999996,5.9494199999999999,6.5893930000000003,7.1159650000000001,0,0,0,6.069013,6.9960110000000002,7.9292009999999999,null,"Eritrea",672]
[null,"Portugal",904629,633,172974,701,75370,243650,774.90330290096824,{"$f":"IF($B49='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B49='Input Sheet I'!$C$36,I49/J49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finland",27.708783,22.916703999999999,18.367431,25.688025,24.462441999999999,23.755652000000001,8.3484610000000004,7.2950850000000003,6.4560180000000003,61.745268999999993,54.674230999999999,48.579101000000001,null,"Estonia",704]
[null,"Romania",128550,90,26333,73,7864,25422,567.87242318164135,{"$f":"IF($B50='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B50='Input Sheet I'!$C$36,I50/J50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Former Soviet Union (if no detail)","x","x","x","x","x","x","x","x","x",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Ethiopia",118]
[null,"Russia",18213,13,825,8,815,2635,439.24669192335148,{"$f":"IF($B51='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B51='Input Sheet I'!$C$36,I51/J51,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Former Yugoslavia (if no detail)","x","x","x","x","x","x","x","x","x",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Finland",205]
[null,"Slovakia",150200,105,20755,71,7603,24577,472.70306258322239,{"$f":"IF($B52='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B52='Input Sheet I'!$C$36,I52/J52,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"France",42.449815999999998,35.700015999999998,40.249966000000001,211.61881399999999,204.64239799999999,202.57037,95.602431999999993,82.91574,85.336673000000005,349.67106199999995,323.25815399999999,328.15700900000002,null,"France",90]
[null,"Slovenia",186800,131,28250,78,8353,27003,417.55888650963595,{"$f":"IF($B53='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B53='Input Sheet I'!$C$36,I53/J53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FYR of Macedonia",5.3726719999999997,6.3674730000000004,5.7778700000000001,2.6277089999999999,2.651154,2.648517,0.22153400000000001,0.25613799999999998,0.26652900000000002,8.2219149999999992,9.2747650000000004,8.6929160000000003,null,"FYR of Macedonia",710]
[null,"South Africa",1506611,1055,148948,1056,113516,366964,700.91085223723974,{"$f":"IF($B54='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B54='Input Sheet I'!$C$36,I54/J54,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gabon",0,0,0,1.73847,1.7613650000000001,1.7403329999999999,0.62759200000000004,0.706542,0.72667999999999999,2.3660619999999999,2.4679070000000003,2.4670129999999997,null,"Gabon",322]
[null,"Spain",3195339,2237,375932,2228,239497,774222,697.26561094143688,{"$f":"IF($B55='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B55='Input Sheet I'!$C$36,I55/J55,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Georgia",9.8835000000000006E-2,0.26059599999999999,0.452623,2.6106750000000001,2.7810269999999999,2.749876,2.1869070000000002,3.2285569999999999,3.6063459999999998,4.8964170000000005,6.2701799999999999,6.8088449999999998,null,"Georgia",129]
[null,"Sweden",454000,318,34572,166,17835,57655,365.63876651982378,{"$f":"IF($B56='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B56='Input Sheet I'!$C$36,I56/J56,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Germany",307.15742899999998,306.89107799999999,317.50013100000001,265.32019600000001,255.00219899999999,256.39268299999998,179.66272699999999,162.73952600000001,163.13190499999999,752.14035200000001,724.63280299999997,737.024719,null,"Germany",430]
[null,"Switzerland",1384940,969,167565,547,58786,190038,394.96295868413074,{"$f":"IF($B57='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B57='Input Sheet I'!$C$36,I57/J57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ghana",0,0,0,9.6859179999999991,9.4149340000000006,11.984443000000001,0.82752899999999996,1.617489,0.82089800000000002,10.513446999999999,11.032423000000001,12.805341,null,"Ghana",187]
[null,"Taiwan",1545628,1082,304849,940,101082,326767,608.16703631145401,{"$f":"IF($B58='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B58='Input Sheet I'!$C$36,I58/J58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gibraltar",0,0,0,0.53180499999999997,0.51941599999999999,0.52856599999999998,0,0,0,0.53180499999999997,0.51941599999999999,0.52856599999999998,null,"Gibraltar",740]
[null,"Thailand",136611,96,27985,110,11871,38376,805.20602294105163,{"$f":"IF($B59='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B59='Input Sheet I'!$C$36,I59/J59,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greece",32.947817999999998,32.719161,32.959175999999999,43.843324000000003,41.226813,36.416997000000002,7.2375439999999998,8.7644280000000006,8.0635809999999992,84.028685999999993,82.710402000000002,77.439753999999994,null,"Greece",722]
[null,"Tunisia",706380,494,247039,635,68239,220596,898.9495738837453,{"$f":"IF($B60='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B60='Input Sheet I'!$C$36,I60/J60,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guatemala",1.1744060000000001,1.1767970000000001,1.1887589999999999,9.0519370000000006,9.2020210000000002,9.2965079999999993,0,0,0,10.226343,10.378818000000001,10.485266999999999,null,"Guatemala",547]
[null,"Turkey",15670321,10969,3629246,14059,1511076,4884855,897.1737081837698,{"$f":"IF($B61='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B61='Input Sheet I'!$C$36,I61/J61,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haiti",0,0,0,2.0850420000000001,2.1328140000000002,2.0720049999999999,0,0,0,2.0850420000000001,2.1328140000000002,2.0720049999999999,null,"Haiti",344]
[null,"United Kingdom",743873,521,152382,297,31924,103200,399.26170193030259,{"$f":"IF($B62='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B62='Input Sheet I'!$C$36,I62/J62,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Honduras",0.47115800000000002,0.60689800000000005,0.617058,6.7948919999999999,7.0238509999999996,7.5436079999999999,0,0,0,7.2660499999999999,7.6307489999999998,8.1606659999999991,null,"Honduras",544]
[null,"United States",23842764,16690,733165,10873,1168663,3777936,456.02934290672005,{"$f":"IF($B63='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B63='Input Sheet I'!$C$36,I63/J63,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hong Kong, China",24.693632000000001,29.967696,29.541941999999999,9.5349970000000006,9.1659159999999993,9.4414210000000001,7.9172880000000001,6.4634299999999998,6.0069499999999998,42.145916999999997,45.597042000000002,44.990313,null,"Hong Kong, China",763]
[null,"Uruguay",12571,9,2575,8,884,2859,636.38533131811312,{"$f":"IF($B64='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B64='Input Sheet I'!$C$36,I64/J64,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hungary",10.448252,10.489267999999999,10.190453,15.92742,15.356536999999999,14.254125999999999,22.171064999999999,21.086141999999999,18.702293999999998,48.546736999999993,46.931946999999994,43.146872999999992,null,"Hungary",302]
[null,"Zimbabwe",22978,16,4707,19,2042,6602,826.87788319261904,{"$f":"IF($B65='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B65='Input Sheet I'!$C$36,I65/J65,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iceland",0.37074200000000002,0.37339299999999997,0.38257999999999998,1.560003,1.479433,1.455317,0,0,0,1.9307449999999999,1.8528259999999999,1.8378969999999999,null,"Iceland",0]
[null,"Avg of all other countries",26641715,18649,5472916,15682,1685544,5448859,588.62576977495632,{"$f":"IF($B66='Input Sheet I'!$C$36,'Input Sheet I'!$F$17,\"\")","v":""},{"$f":"IF($B66='Input Sheet I'!$C$36,I66/J66,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"India",1187.268699,1248.9568489999999,1359.2771760000001,443.52712500000001,459.92372499999999,489.12305800000001,117.793418,118.91861900000001,104.453575,1748.589242,1827.7991929999998,1952.8538090000002,null,"India",951]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indonesia",106.803596,106.635684,124.406041,208.64388099999999,216.382259,231.37902800000001,76.988898000000006,77.255334000000005,79.643681999999998,392.436375,400.27327700000001,435.42875100000003,null,"Indonesia",746]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iraq",0,0,0,91.381782000000001,96.457567999999995,107.473412,9.7879520000000007,11.696636,11.510510999999999,101.16973400000001,108.15420399999999,118.98392299999999,null,"Iraq",684]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ireland",8.027571,7.9560170000000001,9.1641739999999992,20.001857999999999,17.432945,16.950272999999999,10.826523999999999,9.4749630000000007,9.2337419999999995,38.855953,34.863925000000002,35.348188999999998,null,"Ireland",465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Islamic Rep. of Iran",3.2707920000000001,3.8890739999999999,3.5950980000000001,223.94893400000001,227.924307,236.08463800000001,281.250518,293.95779199999998,292.47494599999999,508.47024399999998,525.77117299999998,532.15468199999998,null,"Islamic Republic of Iran",630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Israel",28.735256,29.794156000000001,33.006317000000003,29.179285,28.022607000000001,35.347330999999997,10.137309,9.4216239999999996,4.9137899999999997,{"$f":"AI71+AF71+AC71","v":68.051850000000002},{"$f":"AJ71+AG71+AD71","v":67.238387000000003},{"$f":"AK71+AH71+AE71","v":73.267437999999999},null,"Israel",695]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Italy",51.807752000000001,58.383369000000002,60.417354000000003,185.24435099999999,181.60941700000001,167.43312599999999,157.43310199999999,147.96562,142.042249,394.48520500000001,387.95840600000002,369.89272899999997,null,"Italy",386]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jamaica",0.129161,0.15547,0.17460500000000001,6.7643139999999997,7.1113980000000003,6.9192650000000002,0,0,0,6.8934749999999996,7.2668680000000005,7.0938699999999999,null,"Jamaica",707]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Japan",419.10427600000003,400.06421,419.74537800000002,494.192116,525.20228599999996,535.76592100000005,215.56507500000001,250.36809199999999,259.84184299999998,1128.8614670000002,1175.6345879999999,1215.3531420000002,null,"Japan",415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jordan",0,0,0,13.424182,17.756281000000001,20.160136999999999,5.3472660000000003,2.038862,1.539542,18.771447999999999,19.795143000000003,21.699679,null,"Jordan",581]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kazakhstan",134.194119,142.07543100000001,144.30768900000001,29.454149000000001,35.539769999999997,32.069226,53.698636999999998,53.304259000000002,49.404294,217.34690499999999,230.91946000000002,225.78120900000002,null,"Kazakhstan",480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenya",0.64102199999999998,0.91608400000000001,0.82040900000000005,10.733219,10.634433,9.8210259999999998,0,0,0,11.374241,11.550516999999999,10.641435,null,"Kenya",395]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Korea",276.90858400000002,297.89369099999999,291.22703100000001,186.67194000000001,182.546616,183.59575100000001,90.738197999999997,97.811930000000004,105.975718,554.31872199999998,578.25223699999992,580.79849999999999,null,"Korea",498]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kosovo",6.9514719999999999,6.7350089999999998,6.3557370000000004,1.6143479999999999,1.7446079999999999,1.6433310000000001,0,0,0,8.5658200000000004,8.4796169999999993,7.9990680000000003,null,"Kuwait",870]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kuwait",0,0,0,52.611795000000001,52.305193000000003,56.595013000000002,27.697804000000001,32.430843000000003,34.667586,80.309599000000006,84.736036000000013,91.262598999999994,null,"Kyrgyzstan",81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kyrgyzstan",2.7704339999999998,2.962151,4.1527880000000001,2.7996560000000001,3.674995,4.6916409999999997,0.46350999999999998,0.561446,0.66887099999999999,6.0335999999999999,7.1985919999999997,9.513300000000001,null,"Latin America",344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Latvia",0.41868,0.43083300000000002,0.35872199999999999,4.1410830000000001,3.6821999999999999,3.5964710000000002,3.4005160000000001,2.9820609999999999,2.8016030000000001,7.9602789999999999,7.0950939999999996,6.7567960000000005,null,"Latvia",153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lebanon",0.57728000000000002,0.64142500000000002,0.64142500000000002,17.251730999999999,17.844638,20.384217,0.49555300000000002,0,0,18.324564000000002,18.486063000000001,21.025642000000001,null,"Lebanon",717]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Libya",0,0,0,38.752975999999997,25.352616999999999,33.825201999999997,12.304059000000001,9.9520909999999994,10.376789,51.057034999999999,35.304707999999998,44.201991,null,"Libyan Arab Jamahiriya",872]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lithuania",0.82162000000000002,0.94960800000000001,0.92986100000000005,7.0887979999999997,6.7823200000000003,7.0204110000000002,5.4105429999999997,5.5515179999999997,5.3761000000000001,13.320960999999999,13.283446,13.326372000000001,null,"Lithuania",111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Luxembourg",0.26237500000000002,0.22781299999999999,0.21074699999999999,7.3587569999999998,7.6391289999999996,7.4008940000000001,2.795674,2.4132760000000002,2.4641510000000002,10.416805999999999,10.280218,10.075792,null,"Luxembourg",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malaysia",57.358601,57.336581000000002,61.645634000000001,64.333972000000003,70.518584000000004,68.348551,65.353013000000004,64.500290000000007,65.886324999999999,187.04558599999999,192.35545500000001,195.88050999999999,null,"Malaysia",649]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malta",0,0,0,2.4690660000000002,2.4694720000000001,2.5230079999999999,0,0,0,2.4690660000000002,2.4694720000000001,2.5230079999999999,null,"Malta",850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mauritius",1.5977680000000001,1.5331840000000001,1.614509,2.010713,2.0640589999999999,2.076552,0,0,0,3.6084810000000003,3.5972429999999997,3.6910609999999999,null,"Mexico",455]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mexico",39.528945,40.977598,40.706195999999998,254.568118,260.99660399999999,259.83734199999998,123.83838900000001,130.528458,135.245171,417.93545200000005,432.50265999999999,435.78870899999993,null,"Middle East",690]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mongolia",10.046467,9.9023330000000005,10.733242000000001,2.4803199999999999,3.0824069999999999,3.4827940000000002,0,0,0,12.526786999999999,12.98474,14.216036000000001,null,"Mongolia",535]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montenegro",1.7071689999999999,1.761971,1.582031,0.775949,0.73333499999999996,0.717418,0,0,0,2.4831180000000002,2.4953059999999998,2.2994490000000001,null,"Morocco",638]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morocco",10.833853,11.556281,11.738168,34.130769999999998,36.977158000000003,37.607511000000002,1.331366,1.6847380000000001,2.4938319999999998,46.295988999999999,50.218177000000004,51.839511000000002,null,"Mozambique",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mozambique",2.3172999999999999E-2,0.12049700000000001,3.7075999999999998E-2,2.1717919999999999,2.4883199999999999,2.3733119999999999,0.158503,0.18607599999999999,0.18552399999999999,2.3534679999999999,2.7948929999999996,2.5959119999999998,null,"Myanmar",196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Myanmar",1.6067039999999999,1.5982229999999999,1.883813,3.3263910000000001,3.4992990000000002,6.1346210000000001,3.1035560000000002,3.1623579999999998,3.6335799999999998,8.0366510000000009,8.259879999999999,11.652013999999999,null,"Namibia",237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namibia",7.3632000000000003E-2,2.7348999999999998E-2,2.1038000000000001E-2,2.915584,2.9815269999999998,3.1629,0,0,0,2.9892159999999999,3.0088759999999999,3.1839379999999999,null,"Nepal",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nepal",1.176102,1.397351,1.667503,2.8913720000000001,2.9481190000000002,3.2268629999999998,0,0,0,4.0674739999999998,4.3454700000000006,4.8943659999999998,null,"Netherlands",374]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherlands",28.191137000000001,27.321514000000001,30.376864000000001,65.441456000000002,65.615742999999995,64.435276999999999,90.073357000000001,78.500614999999996,75.560237999999998,183.70595,171.437872,170.37237900000002,null,"Netherlands Antilles",506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherlands Antilles",0,0,0,4.1365189999999998,4.7210429999999999,4.7739890000000003,0,0,0,4.1365189999999998,4.7210429999999999,4.7739890000000003,null,"New Zealand",167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Zealand",5.3481329999999998,5.2054960000000001,6.5319120000000002,17.432147000000001,17.53689,17.492598000000001,8.2153349999999996,7.6219729999999997,8.1188549999999999,30.995615000000001,30.364359,32.143365000000003,null,"Nicaragua",302]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nicaragua",0,0,0,4.3570149999999996,4.4808409999999999,4.300033,0,0,0,4.3570149999999996,4.4808409999999999,4.300033,null,"Nigeria",416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nigeria",9.0888999999999998E-2,7.6538999999999996E-2,0.114811,36.169853000000003,33.798124000000001,35.80283,20.119693999999999,27.947642999999999,28.639723,56.380435999999996,61.822305999999998,64.557364000000007,null,"Non-OECD Europe and Eurasia",355]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norway",2.7397109999999998,2.8694820000000001,2.8361499999999999,23.974772000000002,22.929447,22.480678999999999,11.916145,11.152367999999999,9.9389489999999991,38.630628000000002,36.951296999999997,35.255777999999992,null,"Norway",17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oman",0,0,0,19.351727,22.938025,24.61636,38.397981000000001,42.743699999999997,43.016683,57.749707999999998,65.681725,67.633043000000001,null,"OECD Americas",464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Africa",2.7543839999999999,2.8654410000000001,3.0004110000000002,23.181487000000001,24.085495000000002,25.211206000000001,2.3269739999999999,2.4000780000000002,2.3247010000000001,28.262844999999999,29.351014000000003,30.536318000000001,null,"OECD Asia Oceania",499]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Asia",4.4200330000000001,4.8839889999999997,5.2541950000000002,16.775355999999999,18.505262999999999,19.909545999999999,0.85575299999999999,0.94535100000000005,1.017021,22.051141999999999,24.334602999999998,26.180761999999998,null,"OECD Europe",326]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Non-OECD Americas",1.8683999999999999E-2,1.8683999999999999E-2,1.8683999999999999E-2,17.268508000000001,17.271462,17.531673999999999,1.5372220000000001,1.536921,1.5558529999999999,18.824414000000001,18.827067,19.106210999999998,null,"Oman",842]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pakistan",16.038052,15.803506,14.220119,62.175001999999999,61.406882000000003,64.013891999999998,57.193705999999999,59.182606,59.204169,135.40675999999999,136.39299400000002,137.43818000000002,null,"Other Africa",494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panama",0.319853,0.80302700000000005,1.2598290000000001,8.6162329999999994,8.8637510000000006,8.6200569999999992,0,0,0,8.9360859999999995,9.6667780000000008,9.8798859999999991,null,"Other Asia",268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paraguay",0,0,0,4.687773,4.9063999999999997,5.0574680000000001,0,0,0,4.687773,4.9063999999999997,5.0574680000000001,null,"Other Latin America",175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"People's Rep. of China",5980.3608359999998,6592.7969679999997,6764.4262669999998,1060.5117749999999,1103.1884990000001,1153.6786629999999,194.739521,238.478812,266.23848400000003,7235.6121320000002,7934.4642789999998,8184.3434139999999,null,"Pakistan",458]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peru",3.489859,3.2646030000000001,3.1629619999999998,25.426480999999999,26.337641000000001,27.178024000000001,12.841374999999999,15.076359,15.478398,41.757714999999997,44.678603000000003,45.819383999999999,null,"Panama","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Philippines",29.181994,31.99755,33.634692000000001,39.784720999999998,36.936784000000003,38.249383000000002,7.123259,7.6908349999999999,7.5523179999999996,76.089973999999998,76.625169,79.43639300000001,null,"Paraguay",236]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poland",208.619552,203.42182299999999,198.74359699999999,67.103036000000003,66.477653000000004,63.045278000000003,27.936232,28.111927999999999,29.223706,303.65881999999999,298.01140399999997,291.01258100000001,null,"People's Rep. of China",743]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portugal",6.3984139999999998,8.6501169999999998,11.356331000000001,30.551794999999998,27.520596999999999,24.373818,10.419458000000001,10.562692,9.0854769999999991,47.369667,46.733406000000002,44.815625999999995,null,"Peru",719]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qatar",0,0,0,14.842302,12.264408,15.935605000000001,45.730739999999997,54.793512999999997,59.848258000000001,60.573042000000001,67.057920999999993,75.783862999999997,null,"Philippines",478]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Republic of Moldova",0.38214300000000001,0.38978800000000002,0.43314599999999998,2.2049639999999999,2.3185470000000001,2.0392939999999999,5.3000080000000001,5.1753030000000004,5.1453680000000004,7.8871150000000005,7.8836380000000004,7.6178080000000001,null,"Poland",640]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Romania",28.971679000000002,33.878107999999997,31.089091,22.625561999999999,23.434598999999999,24.269397999999999,23.681684000000001,24.193539999999999,23.491695,75.278925000000001,81.506247000000002,78.850183999999999,null,"Portugal",368]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russian Federation",391.92255399999999,411.08032100000003,425.240297,318.363811,350.19851599999998,350.02401400000002,851.72974699999997,873.47779000000003,864.87730899999997,1562.016112,1634.7566270000002,1640.1416200000001,null,"Qatar",494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saudi Arabia",0,0,0,295.97285699999998,309.49697600000002,327.56049899999999,118.87822300000001,120.26614600000001,131.24185499999999,414.85107999999997,429.76312200000001,458.80235399999998,null,"Qatar",400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Senegal",0.68955200000000005,0.96585299999999996,0.83851600000000004,4.6935209999999996,4.7503469999999997,4.746003,4.6205999999999997E-2,3.5808E-2,5.1579E-2,5.4292789999999993,5.752008,5.6360980000000005,null,"Romania",414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serbia",31.698658000000002,35.904508,31.189164999999999,9.9123099999999997,9.5805749999999996,9.0089419999999993,4.124574,4.2604410000000001,3.884884,45.735542000000002,49.745524000000003,44.082991,null,"Russian Federation",317]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Singapore",3.2882000000000002E-2,3.2882000000000002E-2,3.2882000000000002E-2,31.003800999999999,31.822036000000001,29.942015999999999,16.569092000000001,17.109193999999999,18.402844999999999,47.605775000000001,48.964112,48.377742999999995,null,"Saudi Arabia",757]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slovak Republic",14.091668,13.866018,12.800328,9.8383120000000002,9.7070650000000001,9.2772480000000002,11.153269999999999,10.117853,9.6032390000000003,35.08325,33.690936000000001,31.680815000000003,null,"Senegal",614]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slovenia",5.9175180000000003,5.9998750000000003,5.7017559999999996,7.4188000000000001,7.3967970000000003,7.1245269999999996,1.9550339999999999,1.7194959999999999,1.6556949999999999,15.291352,15.116168000000002,14.481978,null,"Serbia",680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South Africa",301.385221,283.18105300000002,298.39127999999999,70.874522999999996,74.298340999999994,73.748296999999994,4.0537200000000002,4.0340280000000002,3.98481,376.31346400000001,361.51342199999999,376.12438699999996,null,"Singapore",519]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spain",31.394283000000001,49.946609000000002,58.407336000000001,163.72739200000001,152.653851,142.16017099999999,71.977176999999998,66.922371999999996,65.212419999999995,267.09885199999997,269.52283199999999,265.77992699999999,null,"Slovak Republic",222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sri Lanka",0.25812400000000002,1.386293,1.967171,11.969580000000001,13.065770000000001,13.896953,0,0,0,12.227704000000001,14.452063000000001,15.864124,null,"Slovenia",316]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sudan",0,0,0,15.476723,14.581204,14.462400000000001,0,0,0,15.476723,14.581204,14.462400000000001,null,"South Africa",926]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweden",8.9304439999999996,8.3039930000000002,7.2136909999999999,32.770035999999998,30.172889999999999,28.379021000000002,3.1721010000000001,2.6349019999999999,2.354479,44.872580999999997,41.111784999999998,37.947191000000004,null,"Spain",299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Switzerland",0.61035899999999998,0.57296000000000002,0.52293900000000004,32.713490999999998,29.509661000000001,30.306187000000001,7.0012740000000004,6.2159829999999996,6.813936,40.325124000000002,36.298604000000005,37.643062,null,"Sri Lanka",460]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tajikistan",0.34697499999999998,0.38418600000000003,0.73629299999999998,1.55935,1.6316889999999999,1.725133,0.37556899999999999,0.37883600000000001,0.27502199999999999,2.2818939999999999,2.394711,2.7364479999999998,null,"Sudan",356]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thailand",64.167105000000006,72.115075000000004,68.17756,95.907257000000001,98.963593000000003,107.383805,76.099862000000002,70.607338999999996,81.090933000000007,236.17422399999998,241.68600700000002,256.65229799999997,null,"Sweden",43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Togo",0,0,0,2.063542,1.882352,1.616703,0,0,0,{"$f":"AI134+AF134+AC134","v":2.063542},{"$f":"AJ134+AG134+AD134","v":1.882352},{"$f":"AK134+AH134+AE134","v":1.616703},null,"Switzerland",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trinidad and Tobago",0,0,0,4.817456,4.6292179999999998,4.4116799999999996,33.583232000000002,33.293683999999999,32.680200999999997,38.400688000000002,37.922902000000001,37.091880999999994,null,"Syrian Arab Republic",641]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tunisia",0,0,0,11.920313,11.013771,11.289498,11.131373,10.869111999999999,11.754548,23.051686,21.882883,23.044046000000002,null,"Tajikistan",29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Turkey",119.746194,125.09545799999999,138.857584,72.776882999999998,74.721496999999999,76.511881000000002,73.192145999999994,85.749373000000006,86.845420000000004,265.71522299999998,285.566328,302.21488499999998,null,"Thailand",513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Turkmenistan",0,0,0,16.074453999999999,16.93862,17.815175,40.515275000000003,44.608217000000003,46.009293,56.589729000000005,61.546837000000004,63.824467999999996,null,"Togo",202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ukraine",132.317746,144.00903,149.578373,37.280546000000001,37.044935000000002,36.382719000000002,102.062316,104.339259,95.113645000000005,271.66060800000002,285.39322400000003,281.07473700000003,null,"Trinidad and Tobago",253]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United Arab Emirates",2.779347,4.8022600000000004,6.5421060000000004,34.308760999999997,35.293335999999996,36.179310999999998,115.18214399999999,118.36844000000001,128.244901,152.270252,158.46403599999999,170.966318,null,"Tunisia",538]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United Kingdom",111.71838700000001,113.054227,143.52765400000001,165.92909299999999,159.09445099999999,157.919803,194.24146400000001,161.32051100000001,152.538477,471.88894400000004,433.46918900000003,453.98593400000004,null,"Turkey",480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United Rep. of Tanzania",0,7.1770000000000002E-3,0.18895899999999999,4.7335310000000002,5.6955109999999998,6.8046829999999998,1.4970049999999999,1.659729,1.8983890000000001,6.2305359999999999,7.3624170000000007,8.8920310000000011,null,"Turkmenistan",789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"United States",1940.7228230000001,1830.413849,1612.7671789999999,2158.7119109999999,2111.2460339999998,2055.510362,1298.6389469999999,1315.849224,1375.0284469999999,5398.0736809999999,5257.5091069999999,5043.3059880000001,null,"Ukraine",374]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uruguay",9.5680000000000001E-3,4.7819999999999998E-3,7.1770000000000002E-3,6.0141970000000002,7.2188990000000004,8.2622680000000006,0.14901300000000001,0.165183,0.11777600000000001,6.1727780000000001,7.3888639999999999,8.3872210000000003,null,"United Arab Emirates",631]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uzbekistan",5.361383,5.636164,5.6928429999999999,11.027526999999999,10.157931,9.0535700000000006,83.774848000000006,93.412682000000004,96.388816000000006,100.16375800000002,109.206777,111.135229,null,"United Kingdom",450]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Venezuela",0.77355200000000002,0.79622000000000004,0.81888799999999995,107.91992399999999,99.169651999999999,114.426069,73.661494000000005,60.670861000000002,63.033465,182.35496999999998,160.63673299999999,178.27842199999998,null,"United Rep. of Tanzania",281]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Viet Nam",59.004275,62.752707999999998,66.517591999999993,51.449641,54.448306000000002,57.448174000000002,18.980609000000001,17.119392999999999,18.88589,129.43452500000001,134.32040699999999,142.85165599999999,null,"United States",508]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yemen",0,0,0,21.691095000000001,18.493566999999999,18.382749,1.985825,1.3795820000000001,1.588662,23.676919999999999,19.873148999999998,19.971411,null,"Uruguay",199]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zambia",2.2899999999999999E-3,2.2899999999999999E-3,0.20613899999999999,1.7449779999999999,2.1048330000000002,2.5515460000000001,0,0,0,1.7472679999999998,2.1071230000000001,2.7576849999999999,null,"Uzbekistan",461]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zimbabwe",6.8566399999999996,7.4958179999999999,7.8420129999999997,1.8860440000000001,2.0430459999999999,2.1370969999999998,0,0,0,8.7426840000000006,9.5388640000000002,9.9791099999999986,null,"Venezuela",249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vietnam",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yemen",630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zambia",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zimbabwe",619]