{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["User Manual","Scorecard","Dashboard A","Calculation A"],"not_rendered":{"charts":1,"images":15,"macros":0,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"User Manual","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,0,5,6],[6,0,7,0],[8,0,9,0],[8,1,8,6]]}
[]
[]
[]
[]
[]
["General market development phases"]
["Description of the market phase","Pre-Commercial Phase 0","Pioneering Phase I","Expansion Phase II","Maturity Phase III","Saturation Phase IV","Degeneration Phase V",null,"Variable Example","Pre-Commercial Phase 0"]
[null,"In the context of developing countries, the time when a certain (existing) product/service has not yet reached a certain market or only a few units of this product are traded within the country on demand. ","The new product is introduced into the market it is relatively unknown and has not yet earned the trust of consumers.\nAs only small amounts of the product are bought by “early adopters”, the focus lies on awareness raising and consumer gaining activities (high marketing costs, usually no-or low profits). ","As the product gains popularity, new participants (competitors) enter the market.\nTurnover increases at a very high rate and the product starts generating high profits.","This is usually the longest and the most profitable phase.\nDemand is not growing at such a high rate anymore, and product prices drop. \nDue to the increasing competition for market share, profits decrease at the end of this phase. \nThe number of suppliers decrease and the remaining ones increase their market shares. ","The competition for market shares becomes even harder.","Turnover and profits decrease drastically; the product/ service is replaced by a new product. "]
["Adopter category","Total potential customers (100%) are divided into different categories during the different stages of market development."]
[null,"Innovator\n2-5%","Early Adopters\n10-15%","Early Majority\n35%","Late Majority\n35%","Laggards \n5-10%","Late laggards\n0-10%"]
{"$rows_empty":12}
["June 2019"]

{"sheet":"Scorecard","index":1,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":false,"merged":[[12,16,12,17],[3,16,3,18],[1,7,1,11],[44,7,44,8],[45,7,61,7],[45,8,48,8],[49,8,52,8],[53,8,54,8],[55,8,57,8],[58,8,61,8],[32,7,32,8],[33,7,42,7],[34,8,35,8],[37,8,38,8],[39,8,40,8],[41,8,42,8],[3,7,3,8],[4,7,28,7],[4,8,7,8],[8,8,9,8],[10,8,13,8],[14,8,17,8],[19,8,20,8],[22,8,28,8],[44,0,44,1],[45,0,61,0],[45,1,48,1],[49,1,52,1],[53,1,54,1],[55,1,57,1],[58,1,61,1],[30,0,30,6],[32,0,32,1],[33,0,42,0],[34,1,35,1],[37,1,38,1],[39,1,40,1],[41,1,42,1],[1,0,1,6],[3,0,3,1],[4,0,28,0],[4,1,7,1],[8,1,9,1],[10,1,13,1],[14,1,17,1],[19,1,20,1],[22,1,28,1]]}
[{"$nulls":10},"Please select from the drop-downs in the blue fields."]
["Energy Market Scorecard",{"$nulls":6},"Select your Energy Market Scores",{"$nulls":4},"Country","Year","Technology"]
[]
["Indicators",null,"Variables","Pre-Commercial Phase 0","Pioneering Phase I","Expansion Phase II","Maturity Phase III","Indicators",null,"Variables","Market Phase","Trend",{"$nulls":4},"Trends"]
["Supply Side","S1\nSuppliers","Businesses","No (or very few) businesses","Few businesses","Growing amount of new businesses entering the market","Number of businesses starts to decrease. Takeovers / mergers as well as emergence of dominating businesses.","Supply Side","S1\nSuppliers","Businesses",{"$nulls":6},"Positive","POS","h"]
[null,null,"Business modalities","ICS: business as part-time commercial activity; \npicoPV: introduced by donors/ NGO’s as pilots without business or distribution models defined","ICS: Single person entities who spend a bigger part of their time on ICS production; \npicoPV: commercialized under traditional business models","ICS: Owner works full time; increasing number employees that work part and full time; \npicoPV: different business and distribution models in place","ICS: All suppliers work full time and employ others; \npicoPV: business models consolidated",null,null,"Business modalities",{"$nulls":6},"Slight positive","SPT","k"]
[null,null,"Formality","Mainly informal settings for those attempting to enter the market","Mostly informal settings","Degree of formality rises","Increasing number of formal (registered) businesses",null,null,"Formality",{"$nulls":6},"Stagnation","STA","g"]
[null,null,"Jobs created","No (or very few) jobs created; \nICS: unipersonal commercial activity;  \npicoPV: 1-5 employees per business","ICS: ‘family business’ with few employees on a demand basis (1-19); \npicoPV: Low number of employees (6-19 employees)","Increasing number of personnel (20–99 employees) with larger players in the market and/or small businesses grow.","Number of personnel levels off.",null,null,"Jobs created",{"$nulls":6},"Slight negative","SNT","m"]
[null,"S2\nSales Volume","Products / services sold","Very low sales volume","Low sales volume (few systems sold)","Sale volumes rises rapidly (many systems are sold)","Massive distribution; sales volumes stabilize at the replacement level",null,"S2\nSales Volume","Products / services sold",{"$nulls":6},"Negative","NEG","i"]
[null,null,"Inventory turnover","Low inventory turnover ratio","Inventory turnover ratio remains low","High inventory turnover ratio ","Very high inventory turnover ratio",null,null,"Inventory turnover",{"$nulls":6},"Conflicting","CON","n"]
[null,"S3\nPrices, costs and profits","Prices","Prices are high, higher than WTP. Prices might be set at the break-even point or with very low profit margin. ","Prices are adapted to penetrate the market, in some cases with subsidies from donors","Price competition is at its maximum as suppliers try to increase their market share","High price competition",null,"S3\nPrices, costs and profits","Prices",{"$nulls":6},"Unknown","UNC","s"]
[null,null,"Costs","Costs per unit are very high. Sometimes costs are subsidized by donors.","Costs per unit are high. Sometimes costs are subsidized by donors.","Costs per unit start to decrease.","Costs per unit are low.",null,null,"Costs"]
[null,null,"Profit margin ","No (or very low) profit margin, very low turnover ratio","Low profit margin, low turnover ratio","Profit margin increase. They are maximised during that phase. Turnover ratio rises rapidly, high annual turnover growth rates.","Profit margin decrease; turnover ratio stabilizes.",null,null,"Profit margin ",{"$nulls":6},"Technologies"]
[null,null,"Investments","No investments","Some suppliers (have plans to) invest","Suppliers invest and make plans to expand business","Suppliers invest, diversify and expand business",null,null,"Investments",{"$nulls":6},"ICS","Improved cookstoves"]
[null,"S4\nSupply chain development","Length","Two step supply chain. ICS: producers to customers; picoPV: supplier (importing-distributing/retailing) to customers","Short supply chains: Production/import, distribution, retail and wholesale usually done by the same entity","Visible growth of supply chains: Different stages of the supply chain are done by different entities","Complex and/or efficient supply chains: Clearly defined stages of the supply chain are done by different entities.",null,"S4\nSupply chain development","Length",{"$nulls":6},"SOL","Solar Products"]
[null,null,"Distribution channels","Weak distribution channels.","Weak distribution channels.","Improved distribution channels/network.","Distribution channels/network consolidated.",null,null,"Distribution channels",{"$nulls":6},"SHS","Solar Home Systems"]
[null,null,"Spatial reach","Direct sales only to targeted customers in a very small, local network (rural or urban).","Sales to local villages in vicinity (rural or urban).","Sales move beyond direct vicinity of base of operation.","Sales spread across regions in the whole country.",null,null,"Spatial reach",{"$nulls":6},"MHP","Micro-hydro Power"]
[null,null,"Service industry","No service industry (specialized service providers, e.g. clay/metal providers,)","No service industry ","Service industry starts developing ","Established service infrastructure",null,null,"Service industry",{"$nulls":6},"BIO","Biogas"]
[null,"S5\nValue chain development","Value added","Value added is very low","Value added is low","Value added is increasing","Value added per step is declining, as more steps are introduced.",null,"S5\nValue chain development","Value added"]
[null,"S6\nBusiness networks","Networks","No business networks","Donors/NGOs facilitate informal (and formal) business networks","Business Networks (associations, cluster, communities of practice, etc.) are created to create synergies and competitive advantages","Business networks have consolidated and are functioning.",null,"S6\nBusiness networks","Networks"]
[null,null,"Partnerships","Businesses have no partnerships","Businesses start fist partnerships to create trust (via payment record)","Businesses have more partnerships (e.g. trade credit)","Businesses have many partnerships",null,null,"Partnerships"]
[null,"S7\nWarranties","Warranties","Warranties are not granted","Warranties limited to “lower” risk products (e.g. high quality products or very robust products)","Warranties implemented to promote sales and brand loyalty, as well as to encourage consumer trust in the product/service.","Warranties are an integral offer of quality technology suppliers.",null,"S7\nWarranties","Warranties"]
[null,"S8\nEntrepreneurial skills ","Financial literacy","Business skills are low (e.g. wrong price setting, insufficient record keeping, no business plans) ","Some business skills develop","Business skills are improved","Good business skills",null,"S8\nEntrepreneurial skills ","Financial literacy"]
[null,null,"Satisfaction level","Uncertainty on how the business will succeed ","Increasing level of satisfaction","High level of satisfaction in the business","Decreasing satisfaction as there are more competitors in the market",null,null,"Satisfaction level"]
[null,null,"Marketing skills","Businesses are not aware or have the knowledge to run marketing activities. ","Businesses have little knowledge to run marketing activities.","Businesses have the skills and understand the potential of marketing and.","Businesses have the skills and understand the potential of marketing.",null,null,"Marketing skills"]
[null,null,"Advertising","Advertising is mostly based on word-of-mouth. NGOs/donors do marketing activities to a limited extent to introduce product/services","Marketing is done by NGOs/donors and to a limited extent by suppliers (e.g. sign in front of the shop) to reach early adopters","Increased competition imposes business to implement marketing activities, including diversification (e.g. showrooms, radio, bike adds)","Marketing is directed at special groups to get a competitive advantage and/or at retain customers",null,null,"Advertising"]
[null,null,"Marketing evaluation","Marketing is not evaluated by its effectiveness","Suppliers are not aware of the effectiveness of their marketing activities.","Suppliers are aware of the effectiveness of their marketing.","Suppliers have established measurements to assess the effectiveness of marketing.",null,null,"Marketing evaluation"]
[null,null,"Production automatization and optimisation ","Low division of labour as well as low automation and optimization process; all employees carry out all production steps by hand without process optimization","Low to medium division of labour as well as low to medium automation and optimization process","Medium level of division of labour as well as medium automation and optimization process","High level of division of labour as well as high automation and optimization process",null,null,"Production automatization and optimisation "]
[null,null,"Standardized production ","Most producers have no standardized production processes and struggle to produce good quality products","Some producers have standardized production processes and varying quality ","Most producers have standardized production processes => good quality, stable","Most producers have a high level of standardization of their production processes and very good quality, stable ",null,null,"Standardized production "]
[]
["Energy Market Scorecard"]
[]
["Indicators",null,"Variables","Pre-Commercial Phase 0","Pioneering Phase I","Expansion Phase II","Maturity Phase III","Indicators",null,"Variables","Market Phase","Trend"]
["Demand side","D1\nProduct and service diversity","Diversity","There is only one (or very limited number of) type of product(s)/ service(s) in the market","More types of products/services appear for different needs / preferences","Successful improved product/ service variations dominate. Variations appear for different consumer segments.","Different needs of each consumer segment (regarding services and/or preferences) are served with a diversity of products","Demand side","D1\nProduct and service diversity","Diversity"]
[null,"D2\nMarket penetration","Market share","Low market penetration rates (<5%) (low energy access rates). ","Market penetration rates increase in areas first where the supply is located (6-15%). ","Penetration rates are high in the initial immediate market area (16-30%). ","Market penetration increase far beyond the initial immediate market area and target groups (31-55%). ",null,"D2\nMarket penetration","Market share"]
[null,null,"Technology adopters ","Innovators: 2-5% of potential customers","Early adopters: 10-15% ","Early majority of adopters: 35%","Later majority of adopters: 35% ",null,null,"Technology adopters "]
[null,"D3\nWillingness to pay","Willingness to pay ","No willingness to pay is paired with low ability to pay","Willingness to pay increases as consumers get to know the product/service.","As product/service diversity increases, more customers with different willingness to pay are reached","As product/service diversity increases more customers with different willingness to pay are reached",null,"D3\nWillingness to pay","Willingness to pay "]
[null,"D4\nSystems in use","Usage rate","Usage rate is low","Usage rates starts to increase","Higher usage rate","Usage rate is close to 100%",null,"D4\nSystems in use","Usage rate"]
[null,null,"Maintenance","Informal learning based on experience with the technology (<5%)","Users know how to use and maintain technology properly (6-30%)","Users know how to use and maintain technology properly (31-60%)","Almost all users how to use and maintain technology properly (61-80%)",null,null,"Maintenance"]
[null,"D5\nReplacement and repair","Replacement rate","No replacement yet. ","Low replacement rate.","Replacement rate is high.","Replacement rate is close to 100% ",null,"D5\nReplacement and repair","Replacement rate"]
[null,null,"Repair rate","No repairs yet.","Initial repairs occur, low repair rate","Repair rate is high.","Repair rate is close to 100%",null,null,"Repair rate"]
[null,"D6\nConsumer awareness and perception","Awareness","No (or very little) awareness: < 5% of  potential consumers are aware of the technology.","Fast growth in awareness: 6-30% of potential consumers are aware of the technology.","Most potential consumers (31-60%) are aware of the technology.","Almost all potential consumers are aware of the technology and are knowledgeable about pricing (61-80%).",null,"D6\nConsumer awareness and perception","Awareness"]
[null,null,"Perception","Only a few consumers perceive the technology positively as most of them are not aware of the benefits (<20%).","More consumers perceive the technology positively, because they are aware of the benefits (21-40%).","Consumers perceive the technology positively, because most are aware of benefits and identify bad quality products (41-60%).","All consumers perceive the technology in general positively because they are aware of benefits and identify bad quality products (61-80%).",null,null,"Perception"]
[]
["Indicators",null,"Variables","Pre-Commercial Phase 0","Pioneering Phase I","Expansion Phase II","Maturity Phase III","Indicators",null,"Variables","Market Phase","Trend"]
["Enabling environment","E1\nPolicy","National plans","National targets for energy access technologies are non-existent.","National targets are planned.","National targets are in place.","National targets are effectively met.","Enabling environment","E1\nPolicy","National plans"]
[null,null,"Policy","No existing policies for energy access technologies. ","Policies start to come in to place.","Effective policies are implemented and enforced as intended.","Policies are consolidated.",null,null,"Policy"]
[null,null,"Product taxes","No special tax relief for energy access technologies (e.g. on import duties & tariffs, VAT)","No special tax relief","Tax benefits might arise: Tax relief and/or benefits for importation of energy access technologies","Tax benefits expanded or retracted, depending on self-sustaining character of the market",null,null,"Product taxes"]
[null,null,"Business taxes","No tax incentives or simplified tax system for businesses. Due to informality, most businesses do not pay any taxes.","No tax incentives or simplified tax system for businesses. Due to informality, most businesses do not pay any taxes.","More businesses are formally established and pay taxes.","Most businesses are formally established and pay taxes.",null,null,"Business taxes"]
[null,"E2\nAccess to finance","Subsidies","Partial or full subsidies on the demand side are high in order to “introduce” the technology. Highly donor-based.","First financing mechanisms (including subsidies) emerge/are tested (pilots) – usually donor-driven focused on the demand and supply side.","There are no direct consumer or supplier subsidies in place.","There are no consumer or supplier subsidies in place.",null,"E2\nAccess to finance","Subsidies"]
[null,null,"Financial institutions","Financial institutions are not yet familiar with products/services.","Financial institutions are sensitized to include products/services into their portfolio.","Financial institutions are aware of product/services.","Financial institutions offer elaborated financing mechanisms customers; and offer good terms and conditions for businesses.",null,null,"Financial institutions"]
[null,null,"Financing options and investments by suppliers","Low investments.","Still financial constrains are reflected on (low) investment decisions both on demand and supply side.","Better financing options for suppliers are available as products/services are recognized as profitable by financing institutions.","Investment decisions on the supply side are less limited by financial constraints.",null,null,"Financing options and investments by suppliers"]
[null,null,"Financing options for consumers","No financing mechanisms for customers by businesses.","Businesses start developing first financing mechanisms (PAYGO, micro-loans) for customers.","Businesses offer some financing mechanisms for their customers.","Businesses offer more financing mechanisms for different types of customer segments.",null,null,"Financing options for consumers"]
[null,"E3\nQuality regulations, norms and standards","Regulation, Norms and standards","No quality codes and standards that set a baseline level of quality, durability, and truth-in-advertising. ","Lack of codes and standards for quality;  to protect consumer.","Regulators start working on appropriate codes and standards / adopt international ones.","Suppliers are bound to quality codes and standards.",null,"E3\nQuality regulations, norms and standards","Regulation, Norms and standards"]
[null,null,"Enforcement","n/a","n/a","Enforcement/compliance is still unorganized.","Enforcement/compliance is working well.",null,null,"Enforcement"]
[null,"E4\nMarket information","Cost of information","Market information is available only at high costs. ","Donor facilitate market information (and take over the costs).","Consumers and suppliers have access to market information at lower cost.","Market information is publically available.",null,"E4\nMarket information","Cost of information"]
[null,null,"Market facilitation organizations","Public or private, or a mix of market facilitation organizations are non-existent","Public or private, or a mix of market facilitation organizations are still non-existent","Emergence of market facilitation organizations ","Well-established market facilitation organizations",null,null,"Market facilitation organizations"]
[null,null,"Awareness campaigns ","No awareness campaigns at government level. Donor-driven activities push to awareness.","Big push of consumer awareness raising activities by donors with support of Governments.","Governments support awareness raising activities for consumers. ","Retracting consumer awareness raising campaigns",null,null,"Awareness campaigns "]
[null,"E5\nExpertise development","Courses","No specialised study courses/trainings","No specialised study courses/trainings. NGO/Donor offers trainings.","Specialised study courses/trainings emerge. Demand for skilled labour force increases (usually with a lag)","Availability of specialised study courses/trainings for energy access professionals and technicians",null,"E5\nExpertise development","Courses"]
[null,null,"BDT","No Business Development Training courses","The training offered by NGOs includes some business skills.","Labour force trained by NGOs seeks business courses outside of project.","BDT is included in specialised training for RE professionals",null,null,"BDT"]
[null,null,"User training","No or few training available provided mainly by NGO/ Donors for innovators.","Structured formal training provided by NGOs for early adopters.","Structured formal user training is provided by businesses.","Structured formal user training is provided by businesses.",null,null,"User training"]
[null,null,"Service","Service not available yet (Repair) ","Service partially available","Service easily available ","Service available ",null,null,"Service"]

{"sheet":"Dashboard A","index":2,"n_rows":76,"n_cols":39,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,21,1,22],[1,14,1,20],[0,38,1,49],[55,29,55,34],[56,29,56,34],[57,29,57,34],[58,29,58,34],[25,7,25,11],[26,7,26,11],[27,7,27,11],[28,7,28,11],[48,14,48,17],[49,14,49,17],[39,7,39,11],[4,32,4,33],[5,10,5,11],[5,14,5,15],[6,10,6,11],[3,11,3,12],[3,15,3,16],[11,14,11,15],[11,5,11,7],[11,18,11,20],[6,14,6,15],[7,10,7,11],[7,14,7,15],[53,14,53,17],[54,14,54,17],[55,14,55,17],[56,14,56,17],[57,14,57,17],[58,14,58,17],[59,14,59,17],[60,14,60,17],[61,14,61,17],[42,14,42,17],[43,14,43,17],[44,14,44,17],[45,14,45,17],[46,14,46,17],[47,14,47,17],[50,14,50,17],[51,14,51,17],[52,14,52,17],[61,1,61,4],[60,1,60,4],[59,1,59,4],[58,1,58,4],[57,1,57,4],[56,1,56,4],[55,1,55,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[31,1,31,4],[50,1,50,4],[54,1,54,4],[53,1,53,4],[52,1,52,4],[51,1,51,4],[45,1,45,4],[44,1,44,4],[35,1,35,4],[43,1,43,4],[49,1,49,4],[47,1,47,4],[46,1,46,4],[73,7,73,11],[74,7,74,11],[75,7,75,11],[65,1,65,4],[66,1,66,4],[64,1,64,4],[63,1,63,4],[62,1,62,4],[43,7,43,11],[44,7,44,11],[45,7,45,11],[46,7,46,11],[47,7,47,11],[48,7,48,11],[49,7,49,11],[50,7,50,11],[51,7,51,11],[52,7,52,11],[70,1,70,4],[69,1,69,4],[68,1,68,4],[67,1,67,4],[75,1,75,4],[73,1,73,4],[48,1,48,4],[39,1,39,4],[23,7,23,12],[24,7,24,11],[32,1,32,4],[33,1,33,4],[34,1,34,4],[37,1,37,4],[38,1,38,4],[30,1,30,4],[38,7,38,11],[36,1,36,4],[23,1,23,5],[40,1,40,4],[42,1,42,4],[41,1,41,4],[24,1,24,4],[25,1,25,4],[10,1,10,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[10,23,10,24],[11,23,11,24],[5,5,5,7],[15,1,15,2],[4,5,4,7],[4,10,4,11],[4,14,4,15],[4,18,4,20],[9,2,9,3],[10,5,10,7],[10,10,10,11],[10,14,10,15],[10,18,10,20],[9,11,9,12],[9,15,9,16],[15,5,15,7],[15,10,15,11],[15,14,15,15],[15,18,15,20],[72,1,72,4],[71,1,71,4],[74,1,74,4],[1,1,1,11],[3,33,3,34],[7,34,8,34],[7,32,8,33],[21,1,21,12],[3,6,3,8],[9,6,9,8],[13,6,13,8],[13,2,13,3],[13,11,13,12],[13,15,13,16],[14,1,14,2],[17,1,17,2],[14,5,14,7],[16,5,16,7],[17,5,17,7],[14,14,14,15],[14,18,14,20],[17,18,17,20],[14,10,14,11],[3,24,3,25],[16,1,16,2],[16,14,16,15],[53,7,53,11],[54,7,54,11],[55,7,55,11],[56,7,56,11],[57,7,57,11],[64,7,64,11],[47,20,47,24],[48,20,48,24],[49,20,49,24],[29,7,29,11],[30,7,30,11],[31,7,31,11],[32,7,32,11],[33,7,33,11],[34,7,34,11],[35,7,35,11],[36,7,36,11],[37,7,37,11],[40,7,40,11],[41,7,41,11],[42,7,42,11],[65,7,65,11],[66,7,66,11],[67,7,67,11],[62,7,62,11],[63,7,63,11],[58,7,58,11],[59,7,59,11],[60,7,60,11],[61,7,61,11],[68,7,68,11],[69,7,69,11],[70,7,70,11],[71,7,71,11],[72,7,72,11],[3,19,3,21],[9,19,9,21],[13,19,13,21],[23,20,23,25],[24,14,24,17],[25,14,25,17],[26,14,26,17],[27,14,27,17],[28,14,28,17],[9,24,9,25],[4,23,4,24],[5,23,5,24],[16,18,16,20],[63,14,63,17],[64,14,64,17],[65,14,65,17],[66,14,66,17],[67,14,67,17],[68,14,68,17],[69,14,69,17],[70,14,70,17],[21,14,21,25],[29,14,29,17],[30,14,30,17],[31,14,31,17],[32,14,32,17],[33,14,33,17],[34,14,34,17],[35,14,35,17],[36,14,36,17],[37,14,37,17],[38,14,38,17],[39,14,39,17],[40,14,40,17],[41,14,41,17],[50,20,50,24],[51,20,51,24],[41,20,41,24],[42,20,42,24],[43,20,43,24],[44,20,44,24],[45,20,45,24],[46,20,46,24],[71,14,71,17],[72,14,72,17],[73,14,73,17],[74,14,74,17],[75,14,75,17],[23,14,23,18],[24,20,24,24],[25,20,25,24],[26,20,26,24],[27,20,27,24],[28,20,28,24],[29,20,29,24],[30,20,30,24],[31,20,31,24],[32,20,32,24],[33,20,33,24],[34,20,34,24],[35,20,35,24],[36,20,36,24],[37,20,37,24],[38,20,38,24],[39,20,39,24],[40,20,40,24],[62,14,62,17],[74,20,74,24],[75,20,75,24],[58,20,58,24],[59,20,59,24],[60,20,60,24],[61,20,61,24],[62,20,62,24],[63,20,63,24],[64,20,64,24],[65,20,65,24],[66,20,66,24],[44,29,44,34],[45,29,45,34],[67,20,67,24],[68,20,68,24],[69,20,69,24],[70,20,70,24],[71,20,71,24],[72,20,72,24],[73,20,73,24],[52,20,52,24],[53,20,53,24],[54,20,54,24],[55,20,55,24],[56,20,56,24],[57,20,57,24],[46,29,46,34],[47,29,47,34],[48,29,48,34],[49,29,49,34],[50,29,50,34],[51,29,51,34],[52,29,52,34],[53,29,53,34],[54,29,54,34],[35,29,35,34],[36,29,36,34],[37,29,37,34],[38,29,38,34],[39,29,39,34],[40,29,40,34],[41,29,41,34],[42,29,42,34],[43,29,43,34],[75,29,75,34],[76,29,76,34],[59,29,59,34],[60,29,60,34],[61,29,61,34],[62,29,62,34],[63,29,63,34],[64,29,64,34],[65,29,65,34],[66,29,66,34],[67,29,67,34],[1,23,1,24],[1,25,1,32],[68,29,68,34],[69,29,69,34],[70,29,70,34],[71,29,71,34],[72,29,72,34],[73,29,73,34],[74,29,74,34],[3,27,3,28],[4,27,4,29],[25,29,26,34],[29,29,29,34],[30,29,30,34],[31,29,31,34],[32,29,32,34],[33,29,33,34],[34,29,34,34],[3,29,3,30],[5,32,5,33],[6,32,6,33],[9,32,9,33],[10,32,10,33],[11,32,11,33]]}
[{"$nulls":38},"Summary EnDev Market Scorecard"]
[null,"Engergy Access Market Scorecard",{"$nulls":12},{"$f":"IF(Scorecard!M3=\"\",\"\",Scorecard!M3)","v":""},{"$nulls":8},{"$f":"IF(Scorecard!N3=\"\",\"\",Scorecard!N3)","v":""},null,{"$f":"IF('Calculation A'!W3=\"\",\"\",'Calculation A'!W3)","v":""}]
[{"$nulls":12},"Market phases and trends per indicator"]
[null,"S1 ","Suppliers ",null,null,"S2","Sales volume",null,null,null,"S3","Prices, costs + profits",null,null,"S4","Supply chain dev.",null,null,"S5","Value chain dev.",null,null,null,"S6","Business networks",null,null,"S7",null,"Warranties",null,null,"S8","Entrepreneurial skills"]
[null,"Businesses",null,{"$f":"IF('Calculation A'!G3=1,'Calculation A'!J3,IF('Calculation A'!G3=2,'Calculation A'!J3,IF('Calculation A'!G3=3,'Calculation A'!J3,IF('Calculation A'!G3=4,'Calculation A'!J3,\"\"))))","v":""},null,"Products sold",null,null,{"$f":"IF('Calculation A'!G7=1,'Calculation A'!J7,IF('Calculation A'!G7=2,'Calculation A'!J7,IF('Calculation A'!G7=3,'Calculation A'!J7,IF('Calculation A'!G7=4,'Calculation A'!J7,\"\"))))","v":""},null,"Prices",null,{"$f":"IF('Calculation A'!G9=1,'Calculation A'!J9,IF('Calculation A'!G9=2,'Calculation A'!J9,IF('Calculation A'!G9=3,'Calculation A'!J9,IF('Calculation A'!G9=4,'Calculation A'!J9,\"\"))))","v":""},null,"Length",null,{"$f":"IF('Calculation A'!G13=1,'Calculation A'!J13,IF('Calculation A'!G13=2,'Calculation A'!J13,IF('Calculation A'!G13=3,'Calculation A'!J13,IF('Calculation A'!G13=4,'Calculation A'!J13,\"\"))))","v":""},null,"Value added",null,null,{"$f":"IF('Calculation A'!G17=1,'Calculation A'!J17,IF('Calculation A'!G17=2,'Calculation A'!J17,IF('Calculation A'!G17=3,'Calculation A'!J17,IF('Calculation A'!G17=4,'Calculation A'!J17,\"\"))))","v":""},null,"Networks",null,{"$f":"IF('Calculation A'!G18=1,'Calculation A'!J18,IF('Calculation A'!G18=2,'Calculation A'!J18,IF('Calculation A'!G18=3,'Calculation A'!J18,IF('Calculation A'!G18=4,'Calculation A'!J18,\"\"))))","v":""},null,"Warranties",null,null,{"$f":"IF('Calculation A'!G20=1,'Calculation A'!J20,IF('Calculation A'!G20=2,'Calculation A'!J20,IF('Calculation A'!G20=3,'Calculation A'!J20,IF('Calculation A'!G20=4,'Calculation A'!J20,\"\"))))","v":""},null,"Financial literacy",null,{"$f":"IF('Calculation A'!G21=1,'Calculation A'!J21,IF('Calculation A'!G21=2,'Calculation A'!J21,IF('Calculation A'!G21=3,'Calculation A'!J21,IF('Calculation A'!G21=4,'Calculation A'!J21,\"\"))))","v":""}]
[null,"Business modalities",null,{"$f":"IF('Calculation A'!G4=1,'Calculation A'!J4,IF('Calculation A'!G4=2,'Calculation A'!J4,IF('Calculation A'!G4=3,'Calculation A'!J4,IF('Calculation A'!G4=4,'Calculation A'!J4,\"\"))))","v":""},null,"Inventory turnover",null,null,{"$f":"IF('Calculation A'!G8=1,'Calculation A'!J8,IF('Calculation A'!G8=2,'Calculation A'!J8,IF('Calculation A'!G8=3,'Calculation A'!J8,IF('Calculation A'!G8=4,'Calculation A'!J8,\"\"))))","v":""},null,"Costs",null,{"$f":"IF('Calculation A'!G10=1,'Calculation A'!J10,IF('Calculation A'!G10=2,'Calculation A'!J10,IF('Calculation A'!G10=3,'Calculation A'!J10,IF('Calculation A'!G10=4,'Calculation A'!J10,\"\"))))","v":""},null,"Distribution channels",null,{"$f":"IF('Calculation A'!G14=1,'Calculation A'!J14,IF('Calculation A'!G14=2,'Calculation A'!J14,IF('Calculation A'!G14=3,'Calculation A'!J14,IF('Calculation A'!G14=4,'Calculation A'!J14,\"\"))))","v":""},{"$nulls":6},"Partnerships",null,{"$f":"IF('Calculation A'!G19=1,'Calculation A'!J19,IF('Calculation A'!G19=2,'Calculation A'!J19,IF('Calculation A'!G19=3,'Calculation A'!J19,IF('Calculation A'!G19=4,'Calculation A'!J19,\"\"))))","v":""},{"$nulls":6},"Satisfaction level",null,{"$f":"IF('Calculation A'!G22=1,'Calculation A'!J22,IF('Calculation A'!G22=2,'Calculation A'!J22,IF('Calculation A'!G22=3,'Calculation A'!J22,IF('Calculation A'!G22=4,'Calculation A'!J22,\"\"))))","v":""}]
[null,"Formality",null,{"$f":"IF('Calculation A'!G5=1,'Calculation A'!J5,IF('Calculation A'!G5=2,'Calculation A'!J5,IF('Calculation A'!G5=3,'Calculation A'!J5,IF('Calculation A'!G5=4,'Calculation A'!J5,\"\"))))","v":""},{"$nulls":6},"Profit margin ",null,{"$f":"IF('Calculation A'!G11=1,'Calculation A'!J11,IF('Calculation A'!G11=2,'Calculation A'!J11,IF('Calculation A'!G11=3,'Calculation A'!J11,IF('Calculation A'!G11=4,'Calculation A'!J11,\"\"))))","v":""},null,"Spatial reach",null,{"$f":"IF('Calculation A'!G15=1,'Calculation A'!J15,IF('Calculation A'!G15=2,'Calculation A'!J15,IF('Calculation A'!G15=3,'Calculation A'!J15,IF('Calculation A'!G15=4,'Calculation A'!J15,\"\"))))","v":""},{"$nulls":15},"Marketing skills",null,{"$f":"IF('Calculation A'!G23=1,'Calculation A'!J23,IF('Calculation A'!G23=2,'Calculation A'!J23,IF('Calculation A'!G23=3,'Calculation A'!J23,IF('Calculation A'!G23=4,'Calculation A'!J23,\"\"))))","v":""}]
[null,"Jobs created",null,{"$f":"IF('Calculation A'!G6=1,'Calculation A'!J6,IF('Calculation A'!G6=2,'Calculation A'!J6,IF('Calculation A'!G6=3,'Calculation A'!J6,IF('Calculation A'!G6=4,'Calculation A'!J6,\"\"))))","v":""},{"$nulls":6},"Investments",null,{"$f":"IF('Calculation A'!G12=1,'Calculation A'!J12,IF('Calculation A'!G12=2,'Calculation A'!J12,IF('Calculation A'!G12=3,'Calculation A'!J12,IF('Calculation A'!G12=4,'Calculation A'!J12,\"\"))))","v":""},null,"Service industry",null,{"$f":"IF('Calculation A'!G16=1,'Calculation A'!J16,IF('Calculation A'!G16=2,'Calculation A'!J16,IF('Calculation A'!G16=3,'Calculation A'!J16,IF('Calculation A'!G16=4,'Calculation A'!J16,\"\"))))","v":""},{"$nulls":15},"Advertising",null,{"$f":"IF('Calculation A'!G24=1,'Calculation A'!J24,IF('Calculation A'!G24=2,'Calculation A'!J24,IF('Calculation A'!G24=3,'Calculation A'!J24,IF('Calculation A'!G24=4,'Calculation A'!J24,\"\"))))","v":""}]
[]
[null,"D1","Product diversity",null,null,"D2","Market penetration",null,null,null,"D3","Willingness to pay",null,null,"D4","Systems in use",null,null,"D5","Replacement + repair",null,null,null,"D6","Consumer awareness",{"$nulls":7},"Marketing evaluation",null,{"$f":"IF('Calculation A'!G25=1,'Calculation A'!J25,IF('Calculation A'!G25=2,'Calculation A'!J25,IF('Calculation A'!G25=3,'Calculation A'!J25,IF('Calculation A'!G25=4,'Calculation A'!J25,\"\"))))","v":""}]
[null,"Diversity",null,{"$f":"IF('Calculation A'!G28=1,'Calculation A'!J28,IF('Calculation A'!G28=2,'Calculation A'!J28,IF('Calculation A'!G28=3,'Calculation A'!J28,IF('Calculation A'!G28=4,'Calculation A'!J28,\"\"))))","v":""},null,"Market share",null,null,{"$f":"IF('Calculation A'!G29=1,'Calculation A'!J29,IF('Calculation A'!G29=2,'Calculation A'!J29,IF('Calculation A'!G29=3,'Calculation A'!J29,IF('Calculation A'!G29=4,'Calculation A'!J29,\"\"))))","v":""},null,"Willingness to pay",null,{"$f":"IF('Calculation A'!G31=1,'Calculation A'!J31,IF('Calculation A'!G31=2,'Calculation A'!J31,IF('Calculation A'!G31=3,'Calculation A'!J31,IF('Calculation A'!G31=4,'Calculation A'!J31,\"\"))))","v":""},null,"Usage rate",null,{"$f":"IF('Calculation A'!G32=1,'Calculation A'!J32,IF('Calculation A'!G32=2,'Calculation A'!J32,IF('Calculation A'!G32=3,'Calculation A'!J32,IF('Calculation A'!G32=4,'Calculation A'!J32,\"\"))))","v":""},null,"Replacement rate",null,null,{"$f":"IF('Calculation A'!G34=1,'Calculation A'!J34,IF('Calculation A'!G34=2,'Calculation A'!J34,IF('Calculation A'!G34=3,'Calculation A'!J34,IF('Calculation A'!G34=4,'Calculation A'!J34,\"\"))))","v":""},null,"Awareness",null,{"$f":"IF('Calculation A'!G36=1,'Calculation A'!J36,IF('Calculation A'!G36=2,'Calculation A'!J36,IF('Calculation A'!G36=3,'Calculation A'!J36,IF('Calculation A'!G36=4,'Calculation A'!J36,\"\"))))","v":""},{"$nulls":6},"Production optimisation ",null,{"$f":"IF('Calculation A'!G26=1,'Calculation A'!J26,IF('Calculation A'!G26=2,'Calculation A'!J26,IF('Calculation A'!G26=3,'Calculation A'!J26,IF('Calculation A'!G26=4,'Calculation A'!J26,\"\"))))","v":""}]
[{"$nulls":5},"Technology adopters",null,null,{"$f":"IF('Calculation A'!G30=1,'Calculation A'!J30,IF('Calculation A'!G30=2,'Calculation A'!J30,IF('Calculation A'!G30=3,'Calculation A'!J30,IF('Calculation A'!G30=4,'Calculation A'!J30,\"\"))))","v":""},{"$nulls":5},"Maintenance",null,{"$f":"IF('Calculation A'!G33=1,'Calculation A'!J33,IF('Calculation A'!G33=2,'Calculation A'!J33,IF('Calculation A'!G33=3,'Calculation A'!J33,IF('Calculation A'!G33=4,'Calculation A'!J33,\"\"))))","v":""},null,"Repair rate",null,null,{"$f":"IF('Calculation A'!G35=1,'Calculation A'!J35,IF('Calculation A'!G35=2,'Calculation A'!J35,IF('Calculation A'!G35=3,'Calculation A'!J35,IF('Calculation A'!G35=4,'Calculation A'!J35,\"\"))))","v":""},null,"Perception",null,{"$f":"IF('Calculation A'!G37=1,'Calculation A'!J37,IF('Calculation A'!G37=2,'Calculation A'!J37,IF('Calculation A'!G37=3,'Calculation A'!J37,IF('Calculation A'!G37=4,'Calculation A'!J37,\"\"))))","v":""},{"$nulls":6},"Standardized production ",null,{"$f":"IF('Calculation A'!G27=1,'Calculation A'!J27,IF('Calculation A'!G27=2,'Calculation A'!J27,IF('Calculation A'!G27=3,'Calculation A'!J27,IF('Calculation A'!G27=4,'Calculation A'!J27,\"\"))))","v":""}]
[]
[null,"E1","Policy",null,null,"E2","Access to finance",null,null,null,"E3","Quality regulations",null,null,"E4","Market information",null,null,"E5","Expertise development"]
[null,"National plans",null,{"$f":"IF('Calculation A'!G38=1,'Calculation A'!J38,IF('Calculation A'!G38=2,'Calculation A'!J38,IF('Calculation A'!G38=3,'Calculation A'!J38,IF('Calculation A'!G38=4,'Calculation A'!J38,\"\"))))","v":""},null,"Subsidies",null,null,{"$f":"IF('Calculation A'!G42=1,'Calculation A'!J42,IF('Calculation A'!G42=2,'Calculation A'!J42,IF('Calculation A'!G42=3,'Calculation A'!J42,IF('Calculation A'!G42=4,'Calculation A'!J42,\"\"))))","v":""},null,"Regulation, norms a. standards",null,{"$f":"IF('Calculation A'!G46=1,'Calculation A'!J46,IF('Calculation A'!G46=2,'Calculation A'!J46,IF('Calculation A'!G46=3,'Calculation A'!J46,IF('Calculation A'!G46=4,'Calculation A'!J46,\"\"))))","v":""},null,"Cost of information",null,{"$f":"IF('Calculation A'!G48=1,'Calculation A'!J48,IF('Calculation A'!G48=2,'Calculation A'!J48,IF('Calculation A'!G48=3,'Calculation A'!J48,IF('Calculation A'!G48=4,'Calculation A'!J48,\"\"))))","v":""},null,"Courses",null,null,{"$f":"IF('Calculation A'!G51=1,'Calculation A'!J51,IF('Calculation A'!G51=2,'Calculation A'!J51,IF('Calculation A'!G51=3,'Calculation A'!J51,IF('Calculation A'!G51=4,'Calculation A'!J51,\"\"))))","v":""}]
[null,"Policy",null,{"$f":"IF('Calculation A'!G39=1,'Calculation A'!J39,IF('Calculation A'!G39=2,'Calculation A'!J39,IF('Calculation A'!G39=3,'Calculation A'!J39,IF('Calculation A'!G39=4,'Calculation A'!J39,\"\"))))","v":""},null,"Financial institutions",null,null,{"$f":"IF('Calculation A'!G43=1,'Calculation A'!J43,IF('Calculation A'!G43=2,'Calculation A'!J43,IF('Calculation A'!G43=3,'Calculation A'!J43,IF('Calculation A'!G43=4,'Calculation A'!J43,\"\"))))","v":""},null,"Enforcement",null,{"$f":"IF('Calculation A'!G47=1,'Calculation A'!J47,IF('Calculation A'!G47=2,'Calculation A'!J47,IF('Calculation A'!G47=3,'Calculation A'!J47,IF('Calculation A'!G47=4,'Calculation A'!J47,\"\"))))","v":""},null,"Market facilitation organizations",null,{"$f":"IF('Calculation A'!G49=1,'Calculation A'!J49,IF('Calculation A'!G49=2,'Calculation A'!J49,IF('Calculation A'!G49=3,'Calculation A'!J49,IF('Calculation A'!G49=4,'Calculation A'!J49,\"\"))))","v":""},null,"BDT",null,null,{"$f":"IF('Calculation A'!G52=1,'Calculation A'!J52,IF('Calculation A'!G52=2,'Calculation A'!J52,IF('Calculation A'!G52=3,'Calculation A'!J52,IF('Calculation A'!G52=4,'Calculation A'!J52,\"\"))))","v":""}]
[null,"Product taxes",null,{"$f":"IF('Calculation A'!G40=1,'Calculation A'!J40,IF('Calculation A'!G40=2,'Calculation A'!J40,IF('Calculation A'!G40=3,'Calculation A'!J40,IF('Calculation A'!G40=4,'Calculation A'!J40,\"\"))))","v":""},null,"Financing suppliers",null,null,{"$f":"IF('Calculation A'!G44=1,'Calculation A'!J44,IF('Calculation A'!G44=2,'Calculation A'!J44,IF('Calculation A'!G44=3,'Calculation A'!J44,IF('Calculation A'!G44=4,'Calculation A'!J44,\"\"))))","v":""},{"$nulls":5},"Awareness campaigns",null,{"$f":"IF('Calculation A'!G50=1,'Calculation A'!J50,IF('Calculation A'!G50=2,'Calculation A'!J50,IF('Calculation A'!G50=3,'Calculation A'!J50,IF('Calculation A'!G50=4,'Calculation A'!J50,\"\"))))","v":""},null,"User training",null,null,{"$f":"IF('Calculation A'!G53=1,'Calculation A'!J53,IF('Calculation A'!G53=2,'Calculation A'!J53,IF('Calculation A'!G53=3,'Calculation A'!J53,IF('Calculation A'!G53=4,'Calculation A'!J53,\"\"))))","v":""}]
[null,"Business taxes",null,{"$f":"IF('Calculation A'!G41=1,'Calculation A'!J41,IF('Calculation A'!G41=2,'Calculation A'!J41,IF('Calculation A'!G41=3,'Calculation A'!J41,IF('Calculation A'!G41=4,'Calculation A'!J41,\"\"))))","v":""},null,"Financing  consumers",null,null,{"$f":"IF('Calculation A'!G45=1,'Calculation A'!J45,IF('Calculation A'!G45=2,'Calculation A'!J45,IF('Calculation A'!G45=3,'Calculation A'!J45,IF('Calculation A'!G45=4,'Calculation A'!J45,\"\"))))","v":""},{"$nulls":9},"Servcie availability",null,null,{"$f":"IF('Calculation A'!G54=1,'Calculation A'!J54,IF('Calculation A'!G54=2,'Calculation A'!J54,IF('Calculation A'!G54=3,'Calculation A'!J54,IF('Calculation A'!G54=4,'Calculation A'!J54,\"\"))))","v":""}]
[]
[]
[{"$nulls":11},"Attention zone"]
[null,"All variables in phases 0 and I",{"$nulls":12},"Variables in phases II and III with negative/unknown market trends"]
[]
[null,"Pre-Commercial 0",{"$nulls":5},"Pioneering I",{"$nulls":6},"Expansion II",{"$nulls":5},"Maturity III"]
[null,{"$f":"'Calculation A'!N3","v":""},null,null,null,{"$f":"'Calculation A'!O3","v":""},null,{"$f":"'Calculation A'!P3","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q3","v":""},null,{"$f":"'Calculation A'!R3","v":""},null,null,null,{"$f":"'Calculation A'!S3","v":""},null,{"$f":"'Calculation A'!T3","v":""},{"$nulls":4},{"$f":"'Calculation A'!U3","v":""}]
[null,{"$f":"'Calculation A'!N4","v":""},null,null,null,{"$f":"'Calculation A'!O4","v":""},null,{"$f":"'Calculation A'!P4","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q4","v":""},null,{"$f":"'Calculation A'!R4","v":""},null,null,null,{"$f":"'Calculation A'!S4","v":""},null,{"$f":"'Calculation A'!T4","v":""},{"$nulls":4},{"$f":"'Calculation A'!U4","v":""},null,null,null,"Not yet established"]
[null,{"$f":"'Calculation A'!N5","v":""},null,null,null,{"$f":"'Calculation A'!O5","v":""},null,{"$f":"'Calculation A'!P5","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q5","v":""},null,{"$f":"'Calculation A'!R5","v":""},null,null,null,{"$f":"'Calculation A'!S5","v":""},null,{"$f":"'Calculation A'!T5","v":""},{"$nulls":4},{"$f":"'Calculation A'!U5","v":""}]
[null,{"$f":"'Calculation A'!N6","v":""},null,null,null,{"$f":"'Calculation A'!O6","v":""},null,{"$f":"'Calculation A'!P6","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q6","v":""},null,{"$f":"'Calculation A'!R6","v":""},null,null,null,{"$f":"'Calculation A'!S6","v":""},null,{"$f":"'Calculation A'!T6","v":""},{"$nulls":4},{"$f":"'Calculation A'!U6","v":""},null,null,null,"Variables/trends not measured or unknown"]
[null,{"$f":"'Calculation A'!N7","v":""},null,null,null,{"$f":"'Calculation A'!O7","v":""},null,{"$f":"'Calculation A'!P7","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q7","v":""},null,{"$f":"'Calculation A'!R7","v":""},null,null,null,{"$f":"'Calculation A'!S7","v":""},null,{"$f":"'Calculation A'!T7","v":""},{"$nulls":4},{"$f":"'Calculation A'!U7","v":""}]
[null,{"$f":"'Calculation A'!N8","v":""},null,null,null,{"$f":"'Calculation A'!O8","v":""},null,{"$f":"'Calculation A'!P8","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q8","v":""},null,{"$f":"'Calculation A'!R8","v":""},null,null,null,{"$f":"'Calculation A'!S8","v":""},null,{"$f":"'Calculation A'!T8","v":""},{"$nulls":4},{"$f":"'Calculation A'!U8","v":""},null,null,null,{"$f":"'Calculation A'!V3","v":""}]
[null,{"$f":"'Calculation A'!N9","v":""},null,null,null,{"$f":"'Calculation A'!O9","v":""},null,{"$f":"'Calculation A'!P9","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q9","v":""},null,{"$f":"'Calculation A'!R9","v":""},null,null,null,{"$f":"'Calculation A'!S9","v":""},null,{"$f":"'Calculation A'!T9","v":""},{"$nulls":4},{"$f":"'Calculation A'!U9","v":""},null,null,null,{"$f":"'Calculation A'!V4","v":""}]
[null,{"$f":"'Calculation A'!N10","v":""},null,null,null,{"$f":"'Calculation A'!O10","v":""},null,{"$f":"'Calculation A'!P10","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q10","v":""},null,{"$f":"'Calculation A'!R10","v":""},null,null,null,{"$f":"'Calculation A'!S10","v":""},null,{"$f":"'Calculation A'!T10","v":""},{"$nulls":4},{"$f":"'Calculation A'!U10","v":""},null,null,null,{"$f":"'Calculation A'!V5","v":""}]
[null,{"$f":"'Calculation A'!N11","v":""},null,null,null,{"$f":"'Calculation A'!O11","v":""},null,{"$f":"'Calculation A'!P11","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q11","v":""},null,{"$f":"'Calculation A'!R11","v":""},null,null,null,{"$f":"'Calculation A'!S11","v":""},null,{"$f":"'Calculation A'!T11","v":""},{"$nulls":4},{"$f":"'Calculation A'!U11","v":""},null,null,null,{"$f":"'Calculation A'!V6","v":""}]
[null,{"$f":"'Calculation A'!N12","v":""},null,null,null,{"$f":"'Calculation A'!O12","v":""},null,{"$f":"'Calculation A'!P12","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q12","v":""},null,{"$f":"'Calculation A'!R12","v":""},null,null,null,{"$f":"'Calculation A'!S12","v":""},null,{"$f":"'Calculation A'!T12","v":""},{"$nulls":4},{"$f":"'Calculation A'!U12","v":""},null,null,null,{"$f":"'Calculation A'!V7","v":""}]
[null,{"$f":"'Calculation A'!N13","v":""},null,null,null,{"$f":"'Calculation A'!O13","v":""},null,{"$f":"'Calculation A'!P13","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q13","v":""},null,{"$f":"'Calculation A'!R13","v":""},null,null,null,{"$f":"'Calculation A'!S13","v":""},null,{"$f":"'Calculation A'!T13","v":""},{"$nulls":4},{"$f":"'Calculation A'!U13","v":""},null,null,null,{"$f":"'Calculation A'!V8","v":""}]
[null,{"$f":"'Calculation A'!N14","v":""},null,null,null,{"$f":"'Calculation A'!O14","v":""},null,{"$f":"'Calculation A'!P14","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q14","v":""},null,{"$f":"'Calculation A'!R14","v":""},null,null,null,{"$f":"'Calculation A'!S14","v":""},null,{"$f":"'Calculation A'!T14","v":""},{"$nulls":4},{"$f":"'Calculation A'!U14","v":""},null,null,null,{"$f":"'Calculation A'!V9","v":""}]
[null,{"$f":"'Calculation A'!N15","v":""},null,null,null,{"$f":"'Calculation A'!O15","v":""},null,{"$f":"'Calculation A'!P15","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q15","v":""},null,{"$f":"'Calculation A'!R15","v":""},null,null,null,{"$f":"'Calculation A'!S15","v":""},null,{"$f":"'Calculation A'!T15","v":""},{"$nulls":4},{"$f":"'Calculation A'!U15","v":""},null,null,null,{"$f":"'Calculation A'!V10","v":""}]
[null,{"$f":"'Calculation A'!N16","v":""},null,null,null,{"$f":"'Calculation A'!O16","v":""},null,{"$f":"'Calculation A'!P16","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q16","v":""},null,{"$f":"'Calculation A'!R16","v":""},null,null,null,{"$f":"'Calculation A'!S16","v":""},null,{"$f":"'Calculation A'!T16","v":""},{"$nulls":4},{"$f":"'Calculation A'!U16","v":""},null,null,null,{"$f":"'Calculation A'!V11","v":""}]
[null,{"$f":"'Calculation A'!N17","v":""},null,null,null,{"$f":"'Calculation A'!O17","v":""},null,{"$f":"'Calculation A'!P17","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q17","v":""},null,{"$f":"'Calculation A'!R17","v":""},null,null,null,{"$f":"'Calculation A'!S17","v":""},null,{"$f":"'Calculation A'!T17","v":""},{"$nulls":4},{"$f":"'Calculation A'!U17","v":""},null,null,null,{"$f":"'Calculation A'!V12","v":""}]
[null,{"$f":"'Calculation A'!N18","v":""},null,null,null,{"$f":"'Calculation A'!O18","v":""},null,{"$f":"'Calculation A'!P18","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q18","v":""},null,{"$f":"'Calculation A'!R18","v":""},null,null,null,{"$f":"'Calculation A'!S18","v":""},null,{"$f":"'Calculation A'!T18","v":""},{"$nulls":4},{"$f":"'Calculation A'!U18","v":""},null,null,null,{"$f":"'Calculation A'!V13","v":""}]
[null,{"$f":"'Calculation A'!N19","v":""},null,null,null,{"$f":"'Calculation A'!O19","v":""},null,{"$f":"'Calculation A'!P19","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q19","v":""},null,{"$f":"'Calculation A'!R19","v":""},null,null,null,{"$f":"'Calculation A'!S19","v":""},null,{"$f":"'Calculation A'!T19","v":""},{"$nulls":4},{"$f":"'Calculation A'!U19","v":""},null,null,null,{"$f":"'Calculation A'!V14","v":""}]
[null,{"$f":"'Calculation A'!N20","v":""},null,null,null,{"$f":"'Calculation A'!O20","v":""},null,{"$f":"'Calculation A'!P20","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q20","v":""},null,{"$f":"'Calculation A'!R20","v":""},null,null,null,{"$f":"'Calculation A'!S20","v":""},null,{"$f":"'Calculation A'!T20","v":""},{"$nulls":4},{"$f":"'Calculation A'!U20","v":""},null,null,null,{"$f":"'Calculation A'!V15","v":""}]
[null,{"$f":"'Calculation A'!N21","v":""},null,null,null,{"$f":"'Calculation A'!O21","v":""},null,{"$f":"'Calculation A'!P21","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q21","v":""},null,{"$f":"'Calculation A'!R21","v":""},null,null,null,{"$f":"'Calculation A'!S21","v":""},null,{"$f":"'Calculation A'!T21","v":""},{"$nulls":4},{"$f":"'Calculation A'!U21","v":""},null,null,null,{"$f":"'Calculation A'!V16","v":""}]
[null,{"$f":"'Calculation A'!N22","v":""},null,null,null,{"$f":"'Calculation A'!O22","v":""},null,{"$f":"'Calculation A'!P22","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q22","v":""},null,{"$f":"'Calculation A'!R22","v":""},null,null,null,{"$f":"'Calculation A'!S22","v":""},null,{"$f":"'Calculation A'!T22","v":""},{"$nulls":4},{"$f":"'Calculation A'!U22","v":""},null,null,null,{"$f":"'Calculation A'!V17","v":""}]
[null,{"$f":"'Calculation A'!N23","v":""},null,null,null,{"$f":"'Calculation A'!O23","v":""},null,{"$f":"'Calculation A'!P23","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q23","v":""},null,{"$f":"'Calculation A'!R23","v":""},null,null,null,{"$f":"'Calculation A'!S23","v":""},null,{"$f":"'Calculation A'!T23","v":""},{"$nulls":4},{"$f":"'Calculation A'!U23","v":""},null,null,null,{"$f":"'Calculation A'!V18","v":""}]
[null,{"$f":"'Calculation A'!N24","v":""},null,null,null,{"$f":"'Calculation A'!O24","v":""},null,{"$f":"'Calculation A'!P24","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q24","v":""},null,{"$f":"'Calculation A'!R24","v":""},null,null,null,{"$f":"'Calculation A'!S24","v":""},null,{"$f":"'Calculation A'!T24","v":""},{"$nulls":4},{"$f":"'Calculation A'!U24","v":""},null,null,null,{"$f":"'Calculation A'!V19","v":""}]
[null,{"$f":"'Calculation A'!N25","v":""},null,null,null,{"$f":"'Calculation A'!O25","v":""},null,{"$f":"'Calculation A'!P25","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q25","v":""},null,{"$f":"'Calculation A'!R25","v":""},null,null,null,{"$f":"'Calculation A'!S25","v":""},null,{"$f":"'Calculation A'!T25","v":""},{"$nulls":4},{"$f":"'Calculation A'!U25","v":""},null,null,null,{"$f":"'Calculation A'!V20","v":""}]
[null,{"$f":"'Calculation A'!N26","v":""},null,null,null,{"$f":"'Calculation A'!O26","v":""},null,{"$f":"'Calculation A'!P26","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q26","v":""},null,{"$f":"'Calculation A'!R26","v":""},null,null,null,{"$f":"'Calculation A'!S26","v":""},null,{"$f":"'Calculation A'!T26","v":""},{"$nulls":4},{"$f":"'Calculation A'!U26","v":""},null,null,null,{"$f":"'Calculation A'!V21","v":""}]
[null,{"$f":"'Calculation A'!N27","v":""},null,null,null,{"$f":"'Calculation A'!O27","v":""},null,{"$f":"'Calculation A'!P27","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q27","v":""},null,{"$f":"'Calculation A'!R27","v":""},null,null,null,{"$f":"'Calculation A'!S27","v":""},null,{"$f":"'Calculation A'!T27","v":""},{"$nulls":4},{"$f":"'Calculation A'!U27","v":""},null,null,null,{"$f":"'Calculation A'!V22","v":""}]
[null,{"$f":"'Calculation A'!N28","v":""},null,null,null,{"$f":"'Calculation A'!O28","v":""},null,{"$f":"'Calculation A'!P28","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q28","v":""},null,{"$f":"'Calculation A'!R28","v":""},null,null,null,{"$f":"'Calculation A'!S28","v":""},null,{"$f":"'Calculation A'!T28","v":""},{"$nulls":4},{"$f":"'Calculation A'!U28","v":""},null,null,null,{"$f":"'Calculation A'!V23","v":""}]
[null,{"$f":"'Calculation A'!N29","v":""},null,null,null,{"$f":"'Calculation A'!O29","v":""},null,{"$f":"'Calculation A'!P29","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q29","v":""},null,{"$f":"'Calculation A'!R29","v":""},null,null,null,{"$f":"'Calculation A'!S29","v":""},null,{"$f":"'Calculation A'!T29","v":""},{"$nulls":4},{"$f":"'Calculation A'!U29","v":""},null,null,null,{"$f":"'Calculation A'!V24","v":""}]
[null,{"$f":"'Calculation A'!N30","v":""},null,null,null,{"$f":"'Calculation A'!O30","v":""},null,{"$f":"'Calculation A'!P30","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q30","v":""},null,{"$f":"'Calculation A'!R30","v":""},null,null,null,{"$f":"'Calculation A'!S30","v":""},null,{"$f":"'Calculation A'!T30","v":""},{"$nulls":4},{"$f":"'Calculation A'!U30","v":""},null,null,null,{"$f":"'Calculation A'!V25","v":""}]
[null,{"$f":"'Calculation A'!N31","v":""},null,null,null,{"$f":"'Calculation A'!O31","v":""},null,{"$f":"'Calculation A'!P31","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q31","v":""},null,{"$f":"'Calculation A'!R31","v":""},null,null,null,{"$f":"'Calculation A'!S31","v":""},null,{"$f":"'Calculation A'!T31","v":""},{"$nulls":4},{"$f":"'Calculation A'!U31","v":""},null,null,null,{"$f":"'Calculation A'!V26","v":""}]
[null,{"$f":"'Calculation A'!N32","v":""},null,null,null,{"$f":"'Calculation A'!O32","v":""},null,{"$f":"'Calculation A'!P32","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q32","v":""},null,{"$f":"'Calculation A'!R32","v":""},null,null,null,{"$f":"'Calculation A'!S32","v":""},null,{"$f":"'Calculation A'!T32","v":""},{"$nulls":4},{"$f":"'Calculation A'!U32","v":""},null,null,null,{"$f":"'Calculation A'!V27","v":""}]
[null,{"$f":"'Calculation A'!N33","v":""},null,null,null,{"$f":"'Calculation A'!O33","v":""},null,{"$f":"'Calculation A'!P33","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q33","v":""},null,{"$f":"'Calculation A'!R33","v":""},null,null,null,{"$f":"'Calculation A'!S33","v":""},null,{"$f":"'Calculation A'!T33","v":""},{"$nulls":4},{"$f":"'Calculation A'!U33","v":""},null,null,null,{"$f":"'Calculation A'!V28","v":""}]
[null,{"$f":"'Calculation A'!N34","v":""},null,null,null,{"$f":"'Calculation A'!O34","v":""},null,{"$f":"'Calculation A'!P34","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q34","v":""},null,{"$f":"'Calculation A'!R34","v":""},null,null,null,{"$f":"'Calculation A'!S34","v":""},null,{"$f":"'Calculation A'!T34","v":""},{"$nulls":4},{"$f":"'Calculation A'!U34","v":""},null,null,null,{"$f":"'Calculation A'!V29","v":""}]
[null,{"$f":"'Calculation A'!N35","v":""},null,null,null,{"$f":"'Calculation A'!O35","v":""},null,{"$f":"'Calculation A'!P35","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q35","v":""},null,{"$f":"'Calculation A'!R35","v":""},null,null,null,{"$f":"'Calculation A'!S35","v":""},null,{"$f":"'Calculation A'!T35","v":""},{"$nulls":4},{"$f":"'Calculation A'!U35","v":""},null,null,null,{"$f":"'Calculation A'!V30","v":""}]
[null,{"$f":"'Calculation A'!N36","v":""},null,null,null,{"$f":"'Calculation A'!O36","v":""},null,{"$f":"'Calculation A'!P36","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q36","v":""},null,{"$f":"'Calculation A'!R36","v":""},null,null,null,{"$f":"'Calculation A'!S36","v":""},null,{"$f":"'Calculation A'!T36","v":""},{"$nulls":4},{"$f":"'Calculation A'!U36","v":""},null,null,null,{"$f":"'Calculation A'!V31","v":""}]
[null,{"$f":"'Calculation A'!N37","v":""},null,null,null,{"$f":"'Calculation A'!O37","v":""},null,{"$f":"'Calculation A'!P37","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q37","v":""},null,{"$f":"'Calculation A'!R37","v":""},null,null,null,{"$f":"'Calculation A'!S37","v":""},null,{"$f":"'Calculation A'!T37","v":""},{"$nulls":4},{"$f":"'Calculation A'!U37","v":""},null,null,null,{"$f":"'Calculation A'!V32","v":""}]
[null,{"$f":"'Calculation A'!N38","v":""},null,null,null,{"$f":"'Calculation A'!O38","v":""},null,{"$f":"'Calculation A'!P38","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q38","v":""},null,{"$f":"'Calculation A'!R38","v":""},null,null,null,{"$f":"'Calculation A'!S38","v":""},null,{"$f":"'Calculation A'!T38","v":""},{"$nulls":4},{"$f":"'Calculation A'!U38","v":""},null,null,null,{"$f":"'Calculation A'!V33","v":""}]
[null,{"$f":"'Calculation A'!N39","v":""},null,null,null,{"$f":"'Calculation A'!O39","v":""},null,{"$f":"'Calculation A'!P39","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q39","v":""},null,{"$f":"'Calculation A'!R39","v":""},null,null,null,{"$f":"'Calculation A'!S39","v":""},null,{"$f":"'Calculation A'!T39","v":""},{"$nulls":4},{"$f":"'Calculation A'!U39","v":""},null,null,null,{"$f":"'Calculation A'!V34","v":""}]
[null,{"$f":"'Calculation A'!N40","v":""},null,null,null,{"$f":"'Calculation A'!O40","v":""},null,{"$f":"'Calculation A'!P40","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q40","v":""},null,{"$f":"'Calculation A'!R40","v":""},null,null,null,{"$f":"'Calculation A'!S40","v":""},null,{"$f":"'Calculation A'!T40","v":""},{"$nulls":4},{"$f":"'Calculation A'!U40","v":""},null,null,null,{"$f":"'Calculation A'!V35","v":""}]
[null,{"$f":"'Calculation A'!N41","v":""},null,null,null,{"$f":"'Calculation A'!O41","v":""},null,{"$f":"'Calculation A'!P41","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q41","v":""},null,{"$f":"'Calculation A'!R41","v":""},null,null,null,{"$f":"'Calculation A'!S41","v":""},null,{"$f":"'Calculation A'!T41","v":""},{"$nulls":4},{"$f":"'Calculation A'!U41","v":""},null,null,null,{"$f":"'Calculation A'!V36","v":""}]
[null,{"$f":"'Calculation A'!N42","v":""},null,null,null,{"$f":"'Calculation A'!O42","v":""},null,{"$f":"'Calculation A'!P42","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q42","v":""},null,{"$f":"'Calculation A'!R42","v":""},null,null,null,{"$f":"'Calculation A'!S42","v":""},null,{"$f":"'Calculation A'!T42","v":""},{"$nulls":4},{"$f":"'Calculation A'!U42","v":""},null,null,null,{"$f":"'Calculation A'!V37","v":""}]
[null,{"$f":"'Calculation A'!N43","v":""},null,null,null,{"$f":"'Calculation A'!O43","v":""},null,{"$f":"'Calculation A'!P43","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q43","v":""},null,{"$f":"'Calculation A'!R43","v":""},null,null,null,{"$f":"'Calculation A'!S43","v":""},null,{"$f":"'Calculation A'!T43","v":""},{"$nulls":4},{"$f":"'Calculation A'!U43","v":""},null,null,null,{"$f":"'Calculation A'!V38","v":""}]
[null,{"$f":"'Calculation A'!N44","v":""},null,null,null,{"$f":"'Calculation A'!O44","v":""},null,{"$f":"'Calculation A'!P44","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q44","v":""},null,{"$f":"'Calculation A'!R44","v":""},null,null,null,{"$f":"'Calculation A'!S44","v":""},null,{"$f":"'Calculation A'!T44","v":""},{"$nulls":4},{"$f":"'Calculation A'!U44","v":""},null,null,null,{"$f":"'Calculation A'!V39","v":""}]
[null,{"$f":"'Calculation A'!N45","v":""},null,null,null,{"$f":"'Calculation A'!O45","v":""},null,{"$f":"'Calculation A'!P45","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q45","v":""},null,{"$f":"'Calculation A'!R45","v":""},null,null,null,{"$f":"'Calculation A'!S45","v":""},null,{"$f":"'Calculation A'!T45","v":""},{"$nulls":4},{"$f":"'Calculation A'!U45","v":""},null,null,null,{"$f":"'Calculation A'!V40","v":""}]
[null,{"$f":"'Calculation A'!N46","v":""},null,null,null,{"$f":"'Calculation A'!O46","v":""},null,{"$f":"'Calculation A'!P46","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q46","v":""},null,{"$f":"'Calculation A'!R46","v":""},null,null,null,{"$f":"'Calculation A'!S46","v":""},null,{"$f":"'Calculation A'!T46","v":""},{"$nulls":4},{"$f":"'Calculation A'!U46","v":""},null,null,null,{"$f":"'Calculation A'!V41","v":""}]
[null,{"$f":"'Calculation A'!N47","v":""},null,null,null,{"$f":"'Calculation A'!O47","v":""},null,{"$f":"'Calculation A'!P47","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q47","v":""},null,{"$f":"'Calculation A'!R47","v":""},null,null,null,{"$f":"'Calculation A'!S47","v":""},null,{"$f":"'Calculation A'!T47","v":""},{"$nulls":4},{"$f":"'Calculation A'!U47","v":""},null,null,null,{"$f":"'Calculation A'!V42","v":""}]
[null,{"$f":"'Calculation A'!N48","v":""},null,null,null,{"$f":"'Calculation A'!O48","v":""},null,{"$f":"'Calculation A'!P48","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q48","v":""},null,{"$f":"'Calculation A'!R48","v":""},null,null,null,{"$f":"'Calculation A'!S48","v":""},null,{"$f":"'Calculation A'!T48","v":""},{"$nulls":4},{"$f":"'Calculation A'!U48","v":""},null,null,null,{"$f":"'Calculation A'!V43","v":""}]
[null,{"$f":"'Calculation A'!N49","v":""},null,null,null,{"$f":"'Calculation A'!O49","v":""},null,{"$f":"'Calculation A'!P49","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q49","v":""},null,{"$f":"'Calculation A'!R49","v":""},null,null,null,{"$f":"'Calculation A'!S49","v":""},null,{"$f":"'Calculation A'!T49","v":""},{"$nulls":4},{"$f":"'Calculation A'!U49","v":""},null,null,null,{"$f":"'Calculation A'!V44","v":""}]
[null,{"$f":"'Calculation A'!N50","v":""},null,null,null,{"$f":"'Calculation A'!O50","v":""},null,{"$f":"'Calculation A'!P50","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q50","v":""},null,{"$f":"'Calculation A'!R50","v":""},null,null,null,{"$f":"'Calculation A'!S50","v":""},null,{"$f":"'Calculation A'!T50","v":""},{"$nulls":4},{"$f":"'Calculation A'!U50","v":""},null,null,null,{"$f":"'Calculation A'!V45","v":""}]
[null,{"$f":"'Calculation A'!N51","v":""},null,null,null,{"$f":"'Calculation A'!O51","v":""},null,{"$f":"'Calculation A'!P51","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q51","v":""},null,{"$f":"'Calculation A'!R51","v":""},null,null,null,{"$f":"'Calculation A'!S51","v":""},null,{"$f":"'Calculation A'!T51","v":""},{"$nulls":4},{"$f":"'Calculation A'!U51","v":""},null,null,null,{"$f":"'Calculation A'!V46","v":""}]
[null,{"$f":"'Calculation A'!N52","v":""},null,null,null,{"$f":"'Calculation A'!O52","v":""},null,{"$f":"'Calculation A'!P52","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q52","v":""},null,{"$f":"'Calculation A'!R52","v":""},null,null,null,{"$f":"'Calculation A'!S52","v":""},null,{"$f":"'Calculation A'!T52","v":""},{"$nulls":4},{"$f":"'Calculation A'!U52","v":""},null,null,null,{"$f":"'Calculation A'!V47","v":""}]
[null,{"$f":"'Calculation A'!N53","v":""},null,null,null,{"$f":"'Calculation A'!O53","v":""},null,{"$f":"'Calculation A'!P53","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q53","v":""},null,{"$f":"'Calculation A'!R53","v":""},null,null,null,{"$f":"'Calculation A'!S53","v":""},null,{"$f":"'Calculation A'!T53","v":""},{"$nulls":4},{"$f":"'Calculation A'!U53","v":""},null,null,null,{"$f":"'Calculation A'!V48","v":""}]
[null,{"$f":"'Calculation A'!N54","v":""},null,null,null,{"$f":"'Calculation A'!O54","v":""},null,{"$f":"'Calculation A'!P54","v":""},{"$nulls":4},{"$f":"'Calculation A'!Q54","v":""},null,{"$f":"'Calculation A'!R54","v":""},null,null,null,{"$f":"'Calculation A'!S54","v":""},null,{"$f":"'Calculation A'!T54","v":""},{"$nulls":4},{"$f":"'Calculation A'!U54","v":""},null,null,null,{"$f":"'Calculation A'!V49","v":""}]

{"sheet":"Calculation A","index":3,"n_rows":57,"n_cols":52,"rows_kept":57,"cut":false,"hidden":false,"merged":[[15,44,15,45],[0,41,1,41],[0,40,1,40],[0,39,1,39],[0,36,1,36],[0,37,1,37],[0,38,1,38],[1,44,1,45],[0,19,0,20],[0,15,0,16],[0,17,0,18],[0,8,1,8],[0,9,1,9],[0,13,0,14],[0,12,1,12],[1,47,1,48],[0,28,0,30],[0,31,1,33],[0,22,1,22],[0,23,1,23],[0,35,1,35],[0,34,1,34],[0,25,1,25],[0,24,1,24],[37,0,53,0],[37,1,40,1],[41,1,44,1],[45,1,46,1],[47,1,49,1],[50,1,53,1],[27,0,36,0],[28,1,29,1],[31,1,32,1],[33,1,34,1],[35,1,36,1],[2,0,26,0],[2,1,5,1],[6,1,7,1],[8,1,11,1],[12,1,15,1],[17,1,18,1],[20,1,26,1],[0,3,1,3],[0,4,1,4],[0,6,1,6],[0,1,1,1],[0,2,1,2]]}
[null,"Indicators","ID","Variables","#","Scorecard MP","Market phase per VAR","Scorecard Trend","Trends per VAR","Trends per VAR","Phase 3","Phase 4","Market phase and trends not measured","List  Pre-commercial",null,"List Pioneering",null,"List Expansion \n(only negative and unknown trends )",null,"List Maturity \n(only negative and unknow trends)",null,"List 'Not meassured'","Technology","Country name","Variables","Market phase per VAR\n(adjusted)","Indicator status\n(average)",null,"Indicator status\n(average)",null,null,"Market phases for secondary vertical axis",null,null,"Green ring","Yellow ring","Yellow ring 2","Orange ring","Orange ring 2","Red ring","Red ring 2","White ring"]
[{"$nulls":10},"Neg. trend","Neg. trend",null,{"$f":"COUNTIF($G$3:$G$54,1)","v":0},{"$f":"N2","v":0},{"$f":"COUNTIF($G$3:$G$54,2)","v":0},{"$f":"P2","v":0},{"$f":"SUM(COUNTIFS($G$3:$G$54,3,$I$3:$I$54,{\"STA\";\"SNT\";\"NEG\";\"CON\";\"DNK\"}))","v":0},{"$f":"R2","v":0},{"$f":"SUM(COUNTIFS($G$3:$G$54,4,$I$3:$I$54,{\"STA\";\"SNT\";\"NEG\";\"CON\";\"DNK\"}))","v":0},{"$f":"T2","v":0},{"$f":"COUNTIF($G$3:$G$54,\".d\")+COUNTIF($I$3:$I$54,\"UNC\")","v":0},{"$nulls":4},{"$f":"CONCATENATE(Scorecard!N3&\" \"&W3&\" \"&X3)","v":"  "},null,"ID","Indicators",{"$f":"AA2","v":"  "},{"$nulls":13},"Trends",null,null,"Market phases",null,null,null,"Improved cookstoves"]
["Supply Side","S1\nSuppliers","S1","Businesses","S1V1",{"$f":"IF(Scorecard!K5=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K5=\"Pioneering Phase I\",2,IF(Scorecard!K5=\"Expansion Phase II\",3,IF(Scorecard!K5=\"Maturity Phase III\",4,\"\"))))","v":""},{"$f":"F3","v":""},{"$f":"IF(Scorecard!L5=\"Positive\",\"POS\",IF(Scorecard!L5=\"Slight positive\",\"SPT\",IF(Scorecard!L5=\"Stagnation\",\"STA\",IF(Scorecard!L5=\"Slight negative\",\"SNT\",IF(Scorecard!L5=\"Negative\",\"NEG\",IF(Scorecard!L5=\"Conflicting\",\"CON\",IF(Scorecard!L5=\"Unknown\",\"UNC\",\"\")))))))","v":""},{"$f":"H3","v":""},{"$f":"VLOOKUP(I3,$AS$3:$AT$12,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"AND(G3=3,OR(I3=\"STA\",I3=\"SNT\",I3=\"NEG\",I3=\"CON\",I3=\"DNK\"))","v":false},{"$f":"AND(G3=4,OR(I3=\"STA\",I3=\"SNT\",I3=\"NEG\",I3=\"CON\",I3=\"DNK\"))","v":false},{"$f":"IF(OR(G3=\".d\",I3=\"UNC\"),TRUE)","v":false},{"$f":"IF(ROWS(N$3:N3)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N3))))","v":""},{"$f":"IF(ROWS(O$3:O3)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O3))))","v":""},{"$f":"IF(ROWS(P$3:P3)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P3))))","v":""},{"$f":"IF(ROWS(Q$3:Q3)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q3))))","v":""},{"$f":"IF(ROWS(R$3:R3)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R3))))","v":""},{"$f":"IF(ROWS(S$3:S3)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S3))))","v":""},{"$f":"IF(ROWS(T$3:T3)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T3))))","v":""},{"$f":"IF(ROWS(U$3:U3)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U3))))","v":""},{"$f":"IF(ROWS(V$3:V3)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V3))))","v":""},{"$f":"IF(Scorecard!O3=\"\",\"\",Scorecard!O3)","v":""},{"$f":"IF(Scorecard!M3=\"\",\"\",Scorecard!M3)","v":""},{"$f":"C3&\" \"&D3","v":"S1 Businesses"},{"$f":"IF(OR(G3=\".d\",G3=\".r\",G3=\".n\"),\" \",G3)","v":""},{"$f":"SUM(Z3:Z6)/COUNTIF(Z3:Z6,\">0\")","v":{"$error":"#DIV/0!"}},null,"S1","Suppliers",{"$f":"IFERROR(AA3,0.5)","v":0.5},"Maturity",0,"red",4,3,3.5,2,2.5,1,1.5,0,null,null,"POS","h",null,"Pre-Commercial",1,null,null,"Solar Products"]
[null,null,"S1","Business modalities","S1V2",{"$f":"IF(Scorecard!K6=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K6=\"Pioneering Phase I\",2,IF(Scorecard!K6=\"Expansion Phase II\",3,IF(Scorecard!K6=\"Maturity Phase III\",4,\"\"))))","v":""},{"$f":"F4","v":""},{"$f":"IF(Scorecard!L6=\"Positive\",\"POS\",IF(Scorecard!L6=\"Slight positive\",\"SPT\",IF(Scorecard!L6=\"Stagnation\",\"STA\",IF(Scorecard!L6=\"Slight negative\",\"SNT\",IF(Scorecard!L6=\"Negative\",\"NEG\",IF(Scorecard!L6=\"Conflicting\",\"CON\",IF(Scorecard!L6=\"Unknown\",\"UNC\",\"\")))))))","v":""},{"$f":"H4","v":""},{"$f":"VLOOKUP(I4,$AS$3:$AT$12,2,FALSE)","v":{"$error":"#N/A"}},false,false,{"$f":"IF(OR(G4=\".d\",I4=\"UNC\"),TRUE)","v":false},{"$f":"IF(ROWS(N$3:N4)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N4))))","v":""},{"$f":"IF(ROWS(O$3:O4)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O4))))","v":""},{"$f":"IF(ROWS(P$3:P4)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P4))))","v":""},{"$f":"IF(ROWS(Q$3:Q4)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q4))))","v":""},{"$f":"IF(ROWS(R$3:R4)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R4))))","v":""},{"$f":"IF(ROWS(S$3:S4)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S4))))","v":""},{"$f":"IF(ROWS(T$3:T4)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T4))))","v":""},{"$f":"IF(ROWS(U$3:U4)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U4))))","v":""},{"$f":"IF(ROWS(V$3:V4)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V4))))","v":""},null,null,{"$f":"C4&\" \"&D4","v":"S1 Business modalities"},"",null,null,"S2","Sales Volume",{"$f":"IFERROR(AA7,0.5)","v":0.5},"Expansion",0,"orange",4,3,3.5,2,2.5,1,1.5,0,null,null,"SPT","k",null,"Pioneering",2,null,null,"Solar Home Systems"]
[null,null,"S1","Formality","S1V3",{"$f":"IF(Scorecard!K7=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K7=\"Pioneering Phase I\",2,IF(Scorecard!K7=\"Expansion Phase II\",3,IF(Scorecard!K7=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L7=\"Positive\",\"POS\",IF(Scorecard!L7=\"Slight positive\",\"SPT\",IF(Scorecard!L7=\"Stagnation\",\"STA\",IF(Scorecard!L7=\"Slight negative\",\"SNT\",IF(Scorecard!L7=\"Negative\",\"NEG\",IF(Scorecard!L7=\"Conflicting\",\"CON\",IF(Scorecard!L7=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N5)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N5))))","v":""},{"$f":"IF(ROWS(O$3:O5)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O5))))","v":""},{"$f":"IF(ROWS(P$3:P5)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P5))))","v":""},{"$f":"IF(ROWS(Q$3:Q5)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q5))))","v":""},{"$f":"IF(ROWS(R$3:R5)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R5))))","v":""},{"$f":"IF(ROWS(S$3:S5)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S5))))","v":""},{"$f":"IF(ROWS(T$3:T5)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T5))))","v":""},{"$f":"IF(ROWS(U$3:U5)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U5))))","v":""},{"$f":"IF(ROWS(V$3:V5)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V5))))","v":""},null,null,"S1 Formality","",null,null,"S3","Prices, costs & profits",{"$f":"IFERROR(AA9,0.5)","v":0.5},"Pioneering",0,"yellow",4,3,3.5,2,2.5,1,1.5,0,null,null,"STA","g",null,"Expansion",3,null,null,"Micro-hydro Power"]
[null,null,"S1","Jobs created","S1V4",{"$f":"IF(Scorecard!K8=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K8=\"Pioneering Phase I\",2,IF(Scorecard!K8=\"Expansion Phase II\",3,IF(Scorecard!K8=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L8=\"Positive\",\"POS\",IF(Scorecard!L8=\"Slight positive\",\"SPT\",IF(Scorecard!L8=\"Stagnation\",\"STA\",IF(Scorecard!L8=\"Slight negative\",\"SNT\",IF(Scorecard!L8=\"Negative\",\"NEG\",IF(Scorecard!L8=\"Conflicting\",\"CON\",IF(Scorecard!L8=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N6)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N6))))","v":""},{"$f":"IF(ROWS(O$3:O6)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O6))))","v":""},{"$f":"IF(ROWS(P$3:P6)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P6))))","v":""},{"$f":"IF(ROWS(Q$3:Q6)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q6))))","v":""},{"$f":"IF(ROWS(R$3:R6)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R6))))","v":""},{"$f":"IF(ROWS(S$3:S6)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S6))))","v":""},{"$f":"IF(ROWS(T$3:T6)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T6))))","v":""},{"$f":"IF(ROWS(U$3:U6)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U6))))","v":""},{"$f":"IF(ROWS(V$3:V6)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V6))))","v":""},null,null,"S1 Jobs created","",null,null,"S4","Supply chain development",{"$f":"IFERROR(AA13,0.5)","v":0.5},"Pre-commercial",0,"green",4,3,3.5,2,2.5,1,1.5,0,null,null,"SNT","m",null,"Maturity",4,null,null,"Biogas"]
[null,"S2\nSales Volume","S2","Products / services sold","S2V1",{"$f":"IF(Scorecard!K9=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K9=\"Pioneering Phase I\",2,IF(Scorecard!K9=\"Expansion Phase II\",3,IF(Scorecard!K9=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L9=\"Positive\",\"POS\",IF(Scorecard!L9=\"Slight positive\",\"SPT\",IF(Scorecard!L9=\"Stagnation\",\"STA\",IF(Scorecard!L9=\"Slight negative\",\"SNT\",IF(Scorecard!L9=\"Negative\",\"NEG\",IF(Scorecard!L9=\"Conflicting\",\"CON\",IF(Scorecard!L9=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N7)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N7))))","v":""},{"$f":"IF(ROWS(O$3:O7)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O7))))","v":""},{"$f":"IF(ROWS(P$3:P7)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P7))))","v":""},{"$f":"IF(ROWS(Q$3:Q7)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q7))))","v":""},{"$f":"IF(ROWS(R$3:R7)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R7))))","v":""},{"$f":"IF(ROWS(S$3:S7)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S7))))","v":""},{"$f":"IF(ROWS(T$3:T7)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T7))))","v":""},{"$f":"IF(ROWS(U$3:U7)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U7))))","v":""},{"$f":"IF(ROWS(V$3:V7)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V7))))","v":""},null,null,"S2 Products / services sold","",{"$f":"SUM(Z7:Z8)/COUNTIF(Z7:Z8,\">0\")","v":{"$error":"#DIV/0!"}},null,"S5","\nValue chain development",{"$f":"IFERROR(AA17,0.5)","v":0.5},null,0,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"NEG","i",null,"Saturation and Degradation",null,null,null,"Grid"]
[null,null,"S2","Inventory turnover","S2V2",{"$f":"IF(Scorecard!K10=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K10=\"Pioneering Phase I\",2,IF(Scorecard!K10=\"Expansion Phase II\",3,IF(Scorecard!K10=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L10=\"Positive\",\"POS\",IF(Scorecard!L10=\"Slight positive\",\"SPT\",IF(Scorecard!L10=\"Stagnation\",\"STA\",IF(Scorecard!L10=\"Slight negative\",\"SNT\",IF(Scorecard!L10=\"Negative\",\"NEG\",IF(Scorecard!L10=\"Conflicting\",\"CON\",IF(Scorecard!L10=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N8)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N8))))","v":""},{"$f":"IF(ROWS(O$3:O8)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O8))))","v":""},{"$f":"IF(ROWS(P$3:P8)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P8))))","v":""},{"$f":"IF(ROWS(Q$3:Q8)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q8))))","v":""},{"$f":"IF(ROWS(R$3:R8)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R8))))","v":""},{"$f":"IF(ROWS(S$3:S8)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S8))))","v":""},{"$f":"IF(ROWS(T$3:T8)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T8))))","v":""},{"$f":"IF(ROWS(U$3:U8)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U8))))","v":""},{"$f":"IF(ROWS(V$3:V8)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V8))))","v":""},null,null,"S2 Inventory turnover","",null,null,"S6","\nBusiness networks",{"$f":"IFERROR(AA18,0.5)","v":0.5},null,0,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"CON","n",null,"not measured",0,null,null,"Energy access"]
[null,"S3\nPrices, costs and profits","S3","Prices","S3V1",{"$f":"IF(Scorecard!K11=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K11=\"Pioneering Phase I\",2,IF(Scorecard!K11=\"Expansion Phase II\",3,IF(Scorecard!K11=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L11=\"Positive\",\"POS\",IF(Scorecard!L11=\"Slight positive\",\"SPT\",IF(Scorecard!L11=\"Stagnation\",\"STA\",IF(Scorecard!L11=\"Slight negative\",\"SNT\",IF(Scorecard!L11=\"Negative\",\"NEG\",IF(Scorecard!L11=\"Conflicting\",\"CON\",IF(Scorecard!L11=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N9)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N9))))","v":""},{"$f":"IF(ROWS(O$3:O9)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O9))))","v":""},{"$f":"IF(ROWS(P$3:P9)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P9))))","v":""},{"$f":"IF(ROWS(Q$3:Q9)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q9))))","v":""},{"$f":"IF(ROWS(R$3:R9)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R9))))","v":""},{"$f":"IF(ROWS(S$3:S9)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S9))))","v":""},{"$f":"IF(ROWS(T$3:T9)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T9))))","v":""},{"$f":"IF(ROWS(U$3:U9)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U9))))","v":""},{"$f":"IF(ROWS(V$3:V9)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V9))))","v":""},null,null,"S3 Prices","",{"$f":"SUM(Z9:Z12)/COUNTIF(Z9:Z12,\">0\")","v":{"$error":"#DIV/0!"}},null,"S7","\nWarranties",{"$f":"IFERROR(AA20,0.5)","v":0.5},null,0,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"NYR",7]
[null,null,"S3","Costs","S3V2",{"$f":"IF(Scorecard!K12=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K12=\"Pioneering Phase I\",2,IF(Scorecard!K12=\"Expansion Phase II\",3,IF(Scorecard!K12=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L12=\"Positive\",\"POS\",IF(Scorecard!L12=\"Slight positive\",\"SPT\",IF(Scorecard!L12=\"Stagnation\",\"STA\",IF(Scorecard!L12=\"Slight negative\",\"SNT\",IF(Scorecard!L12=\"Negative\",\"NEG\",IF(Scorecard!L12=\"Conflicting\",\"CON\",IF(Scorecard!L12=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N10)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N10))))","v":""},{"$f":"IF(ROWS(O$3:O10)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O10))))","v":""},{"$f":"IF(ROWS(P$3:P10)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P10))))","v":""},{"$f":"IF(ROWS(Q$3:Q10)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q10))))","v":""},{"$f":"IF(ROWS(R$3:R10)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R10))))","v":""},{"$f":"IF(ROWS(S$3:S10)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S10))))","v":""},{"$f":"IF(ROWS(T$3:T10)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T10))))","v":""},{"$f":"IF(ROWS(U$3:U10)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U10))))","v":""},{"$f":"IF(ROWS(V$3:V10)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V10))))","v":""},null,null,"S3 Costs","",null,null,"S8","\nEntrepreneurial skills ",{"$f":"IFERROR(AA21,0.5)","v":0.5},null,0,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"UNC","s"]
[null,null,"S3","Profit margin ","S3V3",{"$f":"IF(Scorecard!K13=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K13=\"Pioneering Phase I\",2,IF(Scorecard!K13=\"Expansion Phase II\",3,IF(Scorecard!K13=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L13=\"Positive\",\"POS\",IF(Scorecard!L13=\"Slight positive\",\"SPT\",IF(Scorecard!L13=\"Stagnation\",\"STA\",IF(Scorecard!L13=\"Slight negative\",\"SNT\",IF(Scorecard!L13=\"Negative\",\"NEG\",IF(Scorecard!L13=\"Conflicting\",\"CON\",IF(Scorecard!L13=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N11)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N11))))","v":""},{"$f":"IF(ROWS(O$3:O11)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O11))))","v":""},{"$f":"IF(ROWS(P$3:P11)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P11))))","v":""},{"$f":"IF(ROWS(Q$3:Q11)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q11))))","v":""},{"$f":"IF(ROWS(R$3:R11)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R11))))","v":""},{"$f":"IF(ROWS(S$3:S11)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S11))))","v":""},{"$f":"IF(ROWS(T$3:T11)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T11))))","v":""},{"$f":"IF(ROWS(U$3:U11)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U11))))","v":""},{"$f":"IF(ROWS(V$3:V11)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V11))))","v":""},null,null,"S3 Profit margin ","",null,null,"D1","Product & service diversity",{"$f":"IFERROR(AA28,0.5)","v":0.5},null,0,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"NME","ý"]
[null,null,"S3","Investments","S3V4",{"$f":"IF(Scorecard!K14=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K14=\"Pioneering Phase I\",2,IF(Scorecard!K14=\"Expansion Phase II\",3,IF(Scorecard!K14=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L14=\"Positive\",\"POS\",IF(Scorecard!L14=\"Slight positive\",\"SPT\",IF(Scorecard!L14=\"Stagnation\",\"STA\",IF(Scorecard!L14=\"Slight negative\",\"SNT\",IF(Scorecard!L14=\"Negative\",\"NEG\",IF(Scorecard!L14=\"Conflicting\",\"CON\",IF(Scorecard!L14=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N12)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N12))))","v":""},{"$f":"IF(ROWS(O$3:O12)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O12))))","v":""},{"$f":"IF(ROWS(P$3:P12)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P12))))","v":""},{"$f":"IF(ROWS(Q$3:Q12)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q12))))","v":""},{"$f":"IF(ROWS(R$3:R12)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R12))))","v":""},{"$f":"IF(ROWS(S$3:S12)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S12))))","v":""},{"$f":"IF(ROWS(T$3:T12)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T12))))","v":""},{"$f":"IF(ROWS(U$3:U12)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U12))))","v":""},{"$f":"IF(ROWS(V$3:V12)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V12))))","v":""},null,null,"S3 Investments","",null,null,"D2","\nMarket penetration",{"$f":"IFERROR(AA29,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"DNK","T"]
[null,"S4\nSupply chain development","S4","Length","S4V1",{"$f":"IF(Scorecard!K15=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K15=\"Pioneering Phase I\",2,IF(Scorecard!K15=\"Expansion Phase II\",3,IF(Scorecard!K15=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L15=\"Positive\",\"POS\",IF(Scorecard!L15=\"Slight positive\",\"SPT\",IF(Scorecard!L15=\"Stagnation\",\"STA\",IF(Scorecard!L15=\"Slight negative\",\"SNT\",IF(Scorecard!L15=\"Negative\",\"NEG\",IF(Scorecard!L15=\"Conflicting\",\"CON\",IF(Scorecard!L15=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N13)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N13))))","v":""},{"$f":"IF(ROWS(O$3:O13)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O13))))","v":""},{"$f":"IF(ROWS(P$3:P13)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P13))))","v":""},{"$f":"IF(ROWS(Q$3:Q13)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q13))))","v":""},{"$f":"IF(ROWS(R$3:R13)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R13))))","v":""},{"$f":"IF(ROWS(S$3:S13)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S13))))","v":""},{"$f":"IF(ROWS(T$3:T13)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T13))))","v":""},{"$f":"IF(ROWS(U$3:U13)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U13))))","v":""},{"$f":"IF(ROWS(V$3:V13)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V13))))","v":""},null,null,"S4 Length","",{"$f":"SUM(Z13:Z16)/COUNTIF(Z13:Z16,\">0\")","v":{"$error":"#DIV/0!"}},null,"D3","\nWillingness to pay",{"$f":"IFERROR(AA31,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0]
[null,null,"S4","Distribution channels","S4V2",{"$f":"IF(Scorecard!K16=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K16=\"Pioneering Phase I\",2,IF(Scorecard!K16=\"Expansion Phase II\",3,IF(Scorecard!K16=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L16=\"Positive\",\"POS\",IF(Scorecard!L16=\"Slight positive\",\"SPT\",IF(Scorecard!L16=\"Stagnation\",\"STA\",IF(Scorecard!L16=\"Slight negative\",\"SNT\",IF(Scorecard!L16=\"Negative\",\"NEG\",IF(Scorecard!L16=\"Conflicting\",\"CON\",IF(Scorecard!L16=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N14)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N14))))","v":""},{"$f":"IF(ROWS(O$3:O14)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O14))))","v":""},{"$f":"IF(ROWS(P$3:P14)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P14))))","v":""},{"$f":"IF(ROWS(Q$3:Q14)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q14))))","v":""},{"$f":"IF(ROWS(R$3:R14)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R14))))","v":""},{"$f":"IF(ROWS(S$3:S14)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S14))))","v":""},{"$f":"IF(ROWS(T$3:T14)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T14))))","v":""},{"$f":"IF(ROWS(U$3:U14)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U14))))","v":""},{"$f":"IF(ROWS(V$3:V14)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V14))))","v":""},null,null,"S4 Distribution channels","",null,null,"D4","\nSystems in use",{"$f":"IFERROR(AA32,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0]
[null,null,"S4","Spatial reach","S4V3",{"$f":"IF(Scorecard!K17=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K17=\"Pioneering Phase I\",2,IF(Scorecard!K17=\"Expansion Phase II\",3,IF(Scorecard!K17=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L17=\"Positive\",\"POS\",IF(Scorecard!L17=\"Slight positive\",\"SPT\",IF(Scorecard!L17=\"Stagnation\",\"STA\",IF(Scorecard!L17=\"Slight negative\",\"SNT\",IF(Scorecard!L17=\"Negative\",\"NEG\",IF(Scorecard!L17=\"Conflicting\",\"CON\",IF(Scorecard!L17=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N15)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N15))))","v":""},{"$f":"IF(ROWS(O$3:O15)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O15))))","v":""},{"$f":"IF(ROWS(P$3:P15)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P15))))","v":""},{"$f":"IF(ROWS(Q$3:Q15)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q15))))","v":""},{"$f":"IF(ROWS(R$3:R15)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R15))))","v":""},{"$f":"IF(ROWS(S$3:S15)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S15))))","v":""},{"$f":"IF(ROWS(T$3:T15)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T15))))","v":""},{"$f":"IF(ROWS(U$3:U15)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U15))))","v":""},{"$f":"IF(ROWS(V$3:V15)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V15))))","v":""},null,null,"S4 Spatial reach","",null,null,"D5","\nReplacement & repair",{"$f":"IFERROR(AA34,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0]
[null,null,"S4","Service industry","S4V4",{"$f":"IF(Scorecard!K18=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K18=\"Pioneering Phase I\",2,IF(Scorecard!K18=\"Expansion Phase II\",3,IF(Scorecard!K18=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L18=\"Positive\",\"POS\",IF(Scorecard!L18=\"Slight positive\",\"SPT\",IF(Scorecard!L18=\"Stagnation\",\"STA\",IF(Scorecard!L18=\"Slight negative\",\"SNT\",IF(Scorecard!L18=\"Negative\",\"NEG\",IF(Scorecard!L18=\"Conflicting\",\"CON\",IF(Scorecard!L18=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N16)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N16))))","v":""},{"$f":"IF(ROWS(O$3:O16)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O16))))","v":""},{"$f":"IF(ROWS(P$3:P16)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P16))))","v":""},{"$f":"IF(ROWS(Q$3:Q16)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q16))))","v":""},{"$f":"IF(ROWS(R$3:R16)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R16))))","v":""},{"$f":"IF(ROWS(S$3:S16)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S16))))","v":""},{"$f":"IF(ROWS(T$3:T16)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T16))))","v":""},{"$f":"IF(ROWS(U$3:U16)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U16))))","v":""},{"$f":"IF(ROWS(V$3:V16)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V16))))","v":""},null,null,"S4 Service industry","",null,null,"D6","\nConsumer awareness\n& perception",{"$f":"IFERROR(AA36,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Market trends",null,"Keyboard shortcut"]
[null,"S5\nValue chain development","S5","Value added","S5V1",{"$f":"IF(Scorecard!K19=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K19=\"Pioneering Phase I\",2,IF(Scorecard!K19=\"Expansion Phase II\",3,IF(Scorecard!K19=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L19=\"Positive\",\"POS\",IF(Scorecard!L19=\"Slight positive\",\"SPT\",IF(Scorecard!L19=\"Stagnation\",\"STA\",IF(Scorecard!L19=\"Slight negative\",\"SNT\",IF(Scorecard!L19=\"Negative\",\"NEG\",IF(Scorecard!L19=\"Conflicting\",\"CON\",IF(Scorecard!L19=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N17)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N17))))","v":""},{"$f":"IF(ROWS(O$3:O17)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O17))))","v":""},{"$f":"IF(ROWS(P$3:P17)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P17))))","v":""},{"$f":"IF(ROWS(Q$3:Q17)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q17))))","v":""},{"$f":"IF(ROWS(R$3:R17)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R17))))","v":""},{"$f":"IF(ROWS(S$3:S17)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S17))))","v":""},{"$f":"IF(ROWS(T$3:T17)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T17))))","v":""},{"$f":"IF(ROWS(U$3:U17)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U17))))","v":""},{"$f":"IF(ROWS(V$3:V17)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V17))))","v":""},null,null,"S5 Value added","",{"$f":"SUM(Z17)/COUNTIF(Z17,\">0\")","v":{"$error":"#DIV/0!"}},null,"E1","\nPolicy",{"$f":"IFERROR(AA38,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Positive","h","h"]
[null,"S6\nBusiness networks","S6","Networks","S6V1",{"$f":"IF(Scorecard!K20=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K20=\"Pioneering Phase I\",2,IF(Scorecard!K20=\"Expansion Phase II\",3,IF(Scorecard!K20=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L20=\"Positive\",\"POS\",IF(Scorecard!L20=\"Slight positive\",\"SPT\",IF(Scorecard!L20=\"Stagnation\",\"STA\",IF(Scorecard!L20=\"Slight negative\",\"SNT\",IF(Scorecard!L20=\"Negative\",\"NEG\",IF(Scorecard!L20=\"Conflicting\",\"CON\",IF(Scorecard!L20=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N18)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N18))))","v":""},{"$f":"IF(ROWS(O$3:O18)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O18))))","v":""},{"$f":"IF(ROWS(P$3:P18)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P18))))","v":""},{"$f":"IF(ROWS(Q$3:Q18)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q18))))","v":""},{"$f":"IF(ROWS(R$3:R18)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R18))))","v":""},{"$f":"IF(ROWS(S$3:S18)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S18))))","v":""},{"$f":"IF(ROWS(T$3:T18)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T18))))","v":""},{"$f":"IF(ROWS(U$3:U18)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U18))))","v":""},{"$f":"IF(ROWS(V$3:V18)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V18))))","v":""},null,null,"S6 Networks","",{"$f":"SUM(Z18:Z19)/COUNTIF(Z18:Z19,\">0\")","v":{"$error":"#DIV/0!"}},null,"E2","\nAccess to finance",{"$f":"IFERROR(AA42,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Slight positive","k","k"]
[null,null,"S6","Partnerships","S6V2",{"$f":"IF(Scorecard!K21=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K21=\"Pioneering Phase I\",2,IF(Scorecard!K21=\"Expansion Phase II\",3,IF(Scorecard!K21=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L21=\"Positive\",\"POS\",IF(Scorecard!L21=\"Slight positive\",\"SPT\",IF(Scorecard!L21=\"Stagnation\",\"STA\",IF(Scorecard!L21=\"Slight negative\",\"SNT\",IF(Scorecard!L21=\"Negative\",\"NEG\",IF(Scorecard!L21=\"Conflicting\",\"CON\",IF(Scorecard!L21=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N19)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N19))))","v":""},{"$f":"IF(ROWS(O$3:O19)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O19))))","v":""},{"$f":"IF(ROWS(P$3:P19)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P19))))","v":""},{"$f":"IF(ROWS(Q$3:Q19)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q19))))","v":""},{"$f":"IF(ROWS(R$3:R19)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R19))))","v":""},{"$f":"IF(ROWS(S$3:S19)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S19))))","v":""},{"$f":"IF(ROWS(T$3:T19)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T19))))","v":""},{"$f":"IF(ROWS(U$3:U19)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U19))))","v":""},{"$f":"IF(ROWS(V$3:V19)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V19))))","v":""},null,null,"S6 Partnerships","",null,null,"E3","\nQuality regulations, \nnorms & standards",{"$f":"IFERROR(AA46,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Stagnation","g","g"]
[null,"S7\nWarranties","S7","Warranties","S7V1",{"$f":"IF(Scorecard!K22=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K22=\"Pioneering Phase I\",2,IF(Scorecard!K22=\"Expansion Phase II\",3,IF(Scorecard!K22=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L22=\"Positive\",\"POS\",IF(Scorecard!L22=\"Slight positive\",\"SPT\",IF(Scorecard!L22=\"Stagnation\",\"STA\",IF(Scorecard!L22=\"Slight negative\",\"SNT\",IF(Scorecard!L22=\"Negative\",\"NEG\",IF(Scorecard!L22=\"Conflicting\",\"CON\",IF(Scorecard!L22=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N20)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N20))))","v":""},{"$f":"IF(ROWS(O$3:O20)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O20))))","v":""},{"$f":"IF(ROWS(P$3:P20)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P20))))","v":""},{"$f":"IF(ROWS(Q$3:Q20)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q20))))","v":""},{"$f":"IF(ROWS(R$3:R20)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R20))))","v":""},{"$f":"IF(ROWS(S$3:S20)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S20))))","v":""},{"$f":"IF(ROWS(T$3:T20)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T20))))","v":""},{"$f":"IF(ROWS(U$3:U20)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U20))))","v":""},{"$f":"IF(ROWS(V$3:V20)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V20))))","v":""},null,null,"S7 Warranties","",{"$f":"SUM(Z20)/COUNTIF(Z20,\">0\")","v":{"$error":"#DIV/0!"}},null,"E4","\nMarket information  ",{"$f":"IFERROR(AA48,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Slight negative","m","m"]
[null,"S8\nEntrepreneurial skills ","S8","Financial literacy","S8V1",{"$f":"IF(Scorecard!K23=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K23=\"Pioneering Phase I\",2,IF(Scorecard!K23=\"Expansion Phase II\",3,IF(Scorecard!K23=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L23=\"Positive\",\"POS\",IF(Scorecard!L23=\"Slight positive\",\"SPT\",IF(Scorecard!L23=\"Stagnation\",\"STA\",IF(Scorecard!L23=\"Slight negative\",\"SNT\",IF(Scorecard!L23=\"Negative\",\"NEG\",IF(Scorecard!L23=\"Conflicting\",\"CON\",IF(Scorecard!L23=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N21)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N21))))","v":""},{"$f":"IF(ROWS(O$3:O21)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O21))))","v":""},{"$f":"IF(ROWS(P$3:P21)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P21))))","v":""},{"$f":"IF(ROWS(Q$3:Q21)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q21))))","v":""},{"$f":"IF(ROWS(R$3:R21)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R21))))","v":""},{"$f":"IF(ROWS(S$3:S21)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S21))))","v":""},{"$f":"IF(ROWS(T$3:T21)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T21))))","v":""},{"$f":"IF(ROWS(U$3:U21)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U21))))","v":""},{"$f":"IF(ROWS(V$3:V21)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V21))))","v":""},null,null,"S8 Financial literacy","",{"$f":"SUM(Z21:Z27)/COUNTIF(Z21:Z27,\">0\")","v":{"$error":"#DIV/0!"}},null,"E5","\nExpertise development  ",{"$f":"IFERROR(AA51,0.5)","v":0.5},null,null,null,4,3,3.5,2,2.5,1,1.5,0,null,null,"Negative","i","i"]
[null,null,"S8","Satisfaction level","S8V2",{"$f":"IF(Scorecard!K24=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K24=\"Pioneering Phase I\",2,IF(Scorecard!K24=\"Expansion Phase II\",3,IF(Scorecard!K24=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L24=\"Positive\",\"POS\",IF(Scorecard!L24=\"Slight positive\",\"SPT\",IF(Scorecard!L24=\"Stagnation\",\"STA\",IF(Scorecard!L24=\"Slight negative\",\"SNT\",IF(Scorecard!L24=\"Negative\",\"NEG\",IF(Scorecard!L24=\"Conflicting\",\"CON\",IF(Scorecard!L24=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N22)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N22))))","v":""},{"$f":"IF(ROWS(O$3:O22)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O22))))","v":""},{"$f":"IF(ROWS(P$3:P22)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P22))))","v":""},{"$f":"IF(ROWS(Q$3:Q22)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q22))))","v":""},{"$f":"IF(ROWS(R$3:R22)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R22))))","v":""},{"$f":"IF(ROWS(S$3:S22)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S22))))","v":""},{"$f":"IF(ROWS(T$3:T22)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T22))))","v":""},{"$f":"IF(ROWS(U$3:U22)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U22))))","v":""},{"$f":"IF(ROWS(V$3:V22)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V22))))","v":""},null,null,"S8 Satisfaction level","",{"$nulls":18},"Conflicting trend","n","n"]
[null,null,"S8","Marketing skills","S8V3",{"$f":"IF(Scorecard!K25=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K25=\"Pioneering Phase I\",2,IF(Scorecard!K25=\"Expansion Phase II\",3,IF(Scorecard!K25=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L25=\"Positive\",\"POS\",IF(Scorecard!L25=\"Slight positive\",\"SPT\",IF(Scorecard!L25=\"Stagnation\",\"STA\",IF(Scorecard!L25=\"Slight negative\",\"SNT\",IF(Scorecard!L25=\"Negative\",\"NEG\",IF(Scorecard!L25=\"Conflicting\",\"CON\",IF(Scorecard!L25=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N23)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N23))))","v":""},{"$f":"IF(ROWS(O$3:O23)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O23))))","v":""},{"$f":"IF(ROWS(P$3:P23)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P23))))","v":""},{"$f":"IF(ROWS(Q$3:Q23)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q23))))","v":""},{"$f":"IF(ROWS(R$3:R23)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R23))))","v":""},{"$f":"IF(ROWS(S$3:S23)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S23))))","v":""},{"$f":"IF(ROWS(T$3:T23)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T23))))","v":""},{"$f":"IF(ROWS(U$3:U23)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U23))))","v":""},{"$f":"IF(ROWS(V$3:V23)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V23))))","v":""},null,null,"S8 Marketing skills","",{"$nulls":18},"Not yet relevant/ detectable",7,7]
[null,null,"S8","Advertising","S8V4",{"$f":"IF(Scorecard!K26=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K26=\"Pioneering Phase I\",2,IF(Scorecard!K26=\"Expansion Phase II\",3,IF(Scorecard!K26=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L26=\"Positive\",\"POS\",IF(Scorecard!L26=\"Slight positive\",\"SPT\",IF(Scorecard!L26=\"Stagnation\",\"STA\",IF(Scorecard!L26=\"Slight negative\",\"SNT\",IF(Scorecard!L26=\"Negative\",\"NEG\",IF(Scorecard!L26=\"Conflicting\",\"CON\",IF(Scorecard!L26=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N24)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N24))))","v":""},{"$f":"IF(ROWS(O$3:O24)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O24))))","v":""},{"$f":"IF(ROWS(P$3:P24)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P24))))","v":""},{"$f":"IF(ROWS(Q$3:Q24)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q24))))","v":""},{"$f":"IF(ROWS(R$3:R24)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R24))))","v":""},{"$f":"IF(ROWS(S$3:S24)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S24))))","v":""},{"$f":"IF(ROWS(T$3:T24)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T24))))","v":""},{"$f":"IF(ROWS(U$3:U24)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U24))))","v":""},{"$f":"IF(ROWS(V$3:V24)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V24))))","v":""},null,null,"S8 Advertising","",{"$nulls":18},"Unclear","s","s"]
[null,null,"S8","Marketing evaluation","S8V5",{"$f":"IF(Scorecard!K27=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K27=\"Pioneering Phase I\",2,IF(Scorecard!K27=\"Expansion Phase II\",3,IF(Scorecard!K27=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L27=\"Positive\",\"POS\",IF(Scorecard!L27=\"Slight positive\",\"SPT\",IF(Scorecard!L27=\"Stagnation\",\"STA\",IF(Scorecard!L27=\"Slight negative\",\"SNT\",IF(Scorecard!L27=\"Negative\",\"NEG\",IF(Scorecard!L27=\"Conflicting\",\"CON\",IF(Scorecard!L27=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N25)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N25))))","v":""},{"$f":"IF(ROWS(O$3:O25)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O25))))","v":""},{"$f":"IF(ROWS(P$3:P25)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P25))))","v":""},{"$f":"IF(ROWS(Q$3:Q25)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q25))))","v":""},{"$f":"IF(ROWS(R$3:R25)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R25))))","v":""},{"$f":"IF(ROWS(S$3:S25)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S25))))","v":""},{"$f":"IF(ROWS(T$3:T25)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T25))))","v":""},{"$f":"IF(ROWS(U$3:U25)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U25))))","v":""},{"$f":"IF(ROWS(V$3:V25)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V25))))","v":""},null,null,"S8 Marketing evaluation","",{"$nulls":18},"Not measured","ý","ý"]
[null,null,"S8","Production automatization and optimisation ","S8V6",{"$f":"IF(Scorecard!K28=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K28=\"Pioneering Phase I\",2,IF(Scorecard!K28=\"Expansion Phase II\",3,IF(Scorecard!K28=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L28=\"Positive\",\"POS\",IF(Scorecard!L28=\"Slight positive\",\"SPT\",IF(Scorecard!L28=\"Stagnation\",\"STA\",IF(Scorecard!L28=\"Slight negative\",\"SNT\",IF(Scorecard!L28=\"Negative\",\"NEG\",IF(Scorecard!L28=\"Conflicting\",\"CON\",IF(Scorecard!L28=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N26)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N26))))","v":""},{"$f":"IF(ROWS(O$3:O26)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O26))))","v":""},{"$f":"IF(ROWS(P$3:P26)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P26))))","v":""},{"$f":"IF(ROWS(Q$3:Q26)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q26))))","v":""},{"$f":"IF(ROWS(R$3:R26)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R26))))","v":""},{"$f":"IF(ROWS(S$3:S26)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S26))))","v":""},{"$f":"IF(ROWS(T$3:T26)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T26))))","v":""},{"$f":"IF(ROWS(U$3:U26)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U26))))","v":""},{"$f":"IF(ROWS(V$3:V26)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V26))))","v":""},null,null,"S8 Production automatization and optimisation ","",{"$nulls":18},"Unknown trend","T","T"]
[null,null,"S8","Standardized production ","S8V7",{"$f":"IF(Scorecard!K29=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K29=\"Pioneering Phase I\",2,IF(Scorecard!K29=\"Expansion Phase II\",3,IF(Scorecard!K29=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L29=\"Positive\",\"POS\",IF(Scorecard!L29=\"Slight positive\",\"SPT\",IF(Scorecard!L29=\"Stagnation\",\"STA\",IF(Scorecard!L29=\"Slight negative\",\"SNT\",IF(Scorecard!L29=\"Negative\",\"NEG\",IF(Scorecard!L29=\"Conflicting\",\"CON\",IF(Scorecard!L29=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N27)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N27))))","v":""},{"$f":"IF(ROWS(O$3:O27)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O27))))","v":""},{"$f":"IF(ROWS(P$3:P27)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P27))))","v":""},{"$f":"IF(ROWS(Q$3:Q27)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q27))))","v":""},{"$f":"IF(ROWS(R$3:R27)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R27))))","v":""},{"$f":"IF(ROWS(S$3:S27)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S27))))","v":""},{"$f":"IF(ROWS(T$3:T27)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T27))))","v":""},{"$f":"IF(ROWS(U$3:U27)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U27))))","v":""},{"$f":"IF(ROWS(V$3:V27)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V27))))","v":""},null,null,"S8 Standardized production ",""]
["Demand side","D1\nProduct and service diversity","D1","Diversity","D1V1",{"$f":"IF(Scorecard!K34=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K34=\"Pioneering Phase I\",2,IF(Scorecard!K34=\"Expansion Phase II\",3,IF(Scorecard!K34=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L34=\"Positive\",\"POS\",IF(Scorecard!L34=\"Slight positive\",\"SPT\",IF(Scorecard!L34=\"Stagnation\",\"STA\",IF(Scorecard!L34=\"Slight negative\",\"SNT\",IF(Scorecard!L34=\"Negative\",\"NEG\",IF(Scorecard!L34=\"Conflicting\",\"CON\",IF(Scorecard!L34=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N28)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N28))))","v":""},{"$f":"IF(ROWS(O$3:O28)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O28))))","v":""},{"$f":"IF(ROWS(P$3:P28)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P28))))","v":""},{"$f":"IF(ROWS(Q$3:Q28)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q28))))","v":""},{"$f":"IF(ROWS(R$3:R28)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R28))))","v":""},{"$f":"IF(ROWS(S$3:S28)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S28))))","v":""},{"$f":"IF(ROWS(T$3:T28)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T28))))","v":""},{"$f":"IF(ROWS(U$3:U28)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U28))))","v":""},{"$f":"IF(ROWS(V$3:V28)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V28))))","v":""},null,null,"D1 Diversity","",{"$f":"SUM(Z28)/COUNTIF(Z28,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,"D2\nMarket penetration","D2","Market share","D2V1",{"$f":"IF(Scorecard!K35=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K35=\"Pioneering Phase I\",2,IF(Scorecard!K35=\"Expansion Phase II\",3,IF(Scorecard!K35=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L35=\"Positive\",\"POS\",IF(Scorecard!L35=\"Slight positive\",\"SPT\",IF(Scorecard!L35=\"Stagnation\",\"STA\",IF(Scorecard!L35=\"Slight negative\",\"SNT\",IF(Scorecard!L35=\"Negative\",\"NEG\",IF(Scorecard!L35=\"Conflicting\",\"CON\",IF(Scorecard!L35=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N29)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N29))))","v":""},{"$f":"IF(ROWS(O$3:O29)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O29))))","v":""},{"$f":"IF(ROWS(P$3:P29)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P29))))","v":""},{"$f":"IF(ROWS(Q$3:Q29)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q29))))","v":""},{"$f":"IF(ROWS(R$3:R29)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R29))))","v":""},{"$f":"IF(ROWS(S$3:S29)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S29))))","v":""},{"$f":"IF(ROWS(T$3:T29)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T29))))","v":""},{"$f":"IF(ROWS(U$3:U29)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U29))))","v":""},{"$f":"IF(ROWS(V$3:V29)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V29))))","v":""},null,null,"D2 Market share","",{"$f":"SUM(Z29:Z30)/COUNTIF(Z29:Z30,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"D2","Technology adopters ","D2V2",{"$f":"IF(Scorecard!K36=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K36=\"Pioneering Phase I\",2,IF(Scorecard!K36=\"Expansion Phase II\",3,IF(Scorecard!K36=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L36=\"Positive\",\"POS\",IF(Scorecard!L36=\"Slight positive\",\"SPT\",IF(Scorecard!L36=\"Stagnation\",\"STA\",IF(Scorecard!L36=\"Slight negative\",\"SNT\",IF(Scorecard!L36=\"Negative\",\"NEG\",IF(Scorecard!L36=\"Conflicting\",\"CON\",IF(Scorecard!L36=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},{"$f":"AND(G30=3,OR(I30=\"STA\",I30=\"SNT\",I30=\"NEG\",I30=\"CON\",I30=\"DNK\"))","v":false},false,false,{"$f":"IF(ROWS(N$3:N30)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N30))))","v":""},{"$f":"IF(ROWS(O$3:O30)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O30))))","v":""},{"$f":"IF(ROWS(P$3:P30)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P30))))","v":""},{"$f":"IF(ROWS(Q$3:Q30)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q30))))","v":""},{"$f":"IF(ROWS(R$3:R30)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R30))))","v":""},{"$f":"IF(ROWS(S$3:S30)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S30))))","v":""},{"$f":"IF(ROWS(T$3:T30)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T30))))","v":""},{"$f":"IF(ROWS(U$3:U30)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U30))))","v":""},{"$f":"IF(ROWS(V$3:V30)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V30))))","v":""},null,null,"D2 Technology adopters ",""]
[null,"D3\nWillingness to pay","D3","Willingness to pay ","D3V1",{"$f":"IF(Scorecard!K37=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K37=\"Pioneering Phase I\",2,IF(Scorecard!K37=\"Expansion Phase II\",3,IF(Scorecard!K37=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L37=\"Positive\",\"POS\",IF(Scorecard!L37=\"Slight positive\",\"SPT\",IF(Scorecard!L37=\"Stagnation\",\"STA\",IF(Scorecard!L37=\"Slight negative\",\"SNT\",IF(Scorecard!L37=\"Negative\",\"NEG\",IF(Scorecard!L37=\"Conflicting\",\"CON\",IF(Scorecard!L37=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N31)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N31))))","v":""},{"$f":"IF(ROWS(O$3:O31)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O31))))","v":""},{"$f":"IF(ROWS(P$3:P31)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P31))))","v":""},{"$f":"IF(ROWS(Q$3:Q31)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q31))))","v":""},{"$f":"IF(ROWS(R$3:R31)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R31))))","v":""},{"$f":"IF(ROWS(S$3:S31)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S31))))","v":""},{"$f":"IF(ROWS(T$3:T31)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T31))))","v":""},{"$f":"IF(ROWS(U$3:U31)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U31))))","v":""},{"$f":"IF(ROWS(V$3:V31)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V31))))","v":""},null,null,"D3 Willingness to pay ","",{"$f":"SUM(Z31)/COUNTIF(Z31,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,"D4\nSystems in use","D4","Usage rate","D4V1",{"$f":"IF(Scorecard!K38=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K38=\"Pioneering Phase I\",2,IF(Scorecard!K38=\"Expansion Phase II\",3,IF(Scorecard!K38=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L38=\"Positive\",\"POS\",IF(Scorecard!L38=\"Slight positive\",\"SPT\",IF(Scorecard!L38=\"Stagnation\",\"STA\",IF(Scorecard!L38=\"Slight negative\",\"SNT\",IF(Scorecard!L38=\"Negative\",\"NEG\",IF(Scorecard!L38=\"Conflicting\",\"CON\",IF(Scorecard!L38=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N32)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N32))))","v":""},{"$f":"IF(ROWS(O$3:O32)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O32))))","v":""},{"$f":"IF(ROWS(P$3:P32)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P32))))","v":""},{"$f":"IF(ROWS(Q$3:Q32)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q32))))","v":""},{"$f":"IF(ROWS(R$3:R32)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R32))))","v":""},{"$f":"IF(ROWS(S$3:S32)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S32))))","v":""},{"$f":"IF(ROWS(T$3:T32)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T32))))","v":""},{"$f":"IF(ROWS(U$3:U32)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U32))))","v":""},{"$f":"IF(ROWS(V$3:V32)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V32))))","v":""},null,null,"D4 Usage rate","",{"$f":"SUM(Z32:Z33)/COUNTIF(Z32:Z33,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"D4","Maintenance","D4V2",{"$f":"IF(Scorecard!K39=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K39=\"Pioneering Phase I\",2,IF(Scorecard!K39=\"Expansion Phase II\",3,IF(Scorecard!K39=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L39=\"Positive\",\"POS\",IF(Scorecard!L39=\"Slight positive\",\"SPT\",IF(Scorecard!L39=\"Stagnation\",\"STA\",IF(Scorecard!L39=\"Slight negative\",\"SNT\",IF(Scorecard!L39=\"Negative\",\"NEG\",IF(Scorecard!L39=\"Conflicting\",\"CON\",IF(Scorecard!L39=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N33)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N33))))","v":""},{"$f":"IF(ROWS(O$3:O33)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O33))))","v":""},{"$f":"IF(ROWS(P$3:P33)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P33))))","v":""},{"$f":"IF(ROWS(Q$3:Q33)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q33))))","v":""},{"$f":"IF(ROWS(R$3:R33)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R33))))","v":""},{"$f":"IF(ROWS(S$3:S33)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S33))))","v":""},{"$f":"IF(ROWS(T$3:T33)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T33))))","v":""},{"$f":"IF(ROWS(U$3:U33)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U33))))","v":""},{"$f":"IF(ROWS(V$3:V33)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V33))))","v":""},null,null,"D4 Maintenance",""]
[null,"D5\nReplacement and repair","D5","Replacement rate","D5V1",{"$f":"IF(Scorecard!K40=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K40=\"Pioneering Phase I\",2,IF(Scorecard!K40=\"Expansion Phase II\",3,IF(Scorecard!K40=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L40=\"Positive\",\"POS\",IF(Scorecard!L40=\"Slight positive\",\"SPT\",IF(Scorecard!L40=\"Stagnation\",\"STA\",IF(Scorecard!L40=\"Slight negative\",\"SNT\",IF(Scorecard!L40=\"Negative\",\"NEG\",IF(Scorecard!L40=\"Conflicting\",\"CON\",IF(Scorecard!L40=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N34)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N34))))","v":""},{"$f":"IF(ROWS(O$3:O34)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O34))))","v":""},{"$f":"IF(ROWS(P$3:P34)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P34))))","v":""},{"$f":"IF(ROWS(Q$3:Q34)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q34))))","v":""},{"$f":"IF(ROWS(R$3:R34)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R34))))","v":""},{"$f":"IF(ROWS(S$3:S34)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S34))))","v":""},{"$f":"IF(ROWS(T$3:T34)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T34))))","v":""},{"$f":"IF(ROWS(U$3:U34)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U34))))","v":""},{"$f":"IF(ROWS(V$3:V34)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V34))))","v":""},null,null,"D5 Replacement rate","",{"$f":"SUM(Z34:Z35)/COUNTIF(Z34:Z35,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"D5","Repair rate","D5V2",{"$f":"IF(Scorecard!K41=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K41=\"Pioneering Phase I\",2,IF(Scorecard!K41=\"Expansion Phase II\",3,IF(Scorecard!K41=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L41=\"Positive\",\"POS\",IF(Scorecard!L41=\"Slight positive\",\"SPT\",IF(Scorecard!L41=\"Stagnation\",\"STA\",IF(Scorecard!L41=\"Slight negative\",\"SNT\",IF(Scorecard!L41=\"Negative\",\"NEG\",IF(Scorecard!L41=\"Conflicting\",\"CON\",IF(Scorecard!L41=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},{"$f":"AND(G35=3,OR(I35=\"STA\",I35=\"SNT\",I35=\"NEG\",I35=\"CON\",I35=\"DNK\"))","v":false},{"$f":"AND(G35=4,OR(I35=\"STA\",I35=\"SNT\",I35=\"NEG\",I35=\"CON\",I35=\"DNK\"))","v":false},false,{"$f":"IF(ROWS(N$3:N35)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N35))))","v":""},{"$f":"IF(ROWS(O$3:O35)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O35))))","v":""},{"$f":"IF(ROWS(P$3:P35)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P35))))","v":""},{"$f":"IF(ROWS(Q$3:Q35)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q35))))","v":""},{"$f":"IF(ROWS(R$3:R35)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R35))))","v":""},{"$f":"IF(ROWS(S$3:S35)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S35))))","v":""},{"$f":"IF(ROWS(T$3:T35)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T35))))","v":""},{"$f":"IF(ROWS(U$3:U35)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U35))))","v":""},{"$f":"IF(ROWS(V$3:V35)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V35))))","v":""},null,null,"D5 Repair rate",{"$f":"IF(OR(G35=\".d\",G35=\".r\",G35=\".n\"),\" \",G35)","v":""}]
[null,"D6\nConsumer awareness and perception","D6","Awareness","D6V1",{"$f":"IF(Scorecard!K42=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K42=\"Pioneering Phase I\",2,IF(Scorecard!K42=\"Expansion Phase II\",3,IF(Scorecard!K42=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L42=\"Positive\",\"POS\",IF(Scorecard!L42=\"Slight positive\",\"SPT\",IF(Scorecard!L42=\"Stagnation\",\"STA\",IF(Scorecard!L42=\"Slight negative\",\"SNT\",IF(Scorecard!L42=\"Negative\",\"NEG\",IF(Scorecard!L42=\"Conflicting\",\"CON\",IF(Scorecard!L42=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N36)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N36))))","v":""},{"$f":"IF(ROWS(O$3:O36)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O36))))","v":""},{"$f":"IF(ROWS(P$3:P36)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P36))))","v":""},{"$f":"IF(ROWS(Q$3:Q36)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q36))))","v":""},{"$f":"IF(ROWS(R$3:R36)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R36))))","v":""},{"$f":"IF(ROWS(S$3:S36)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S36))))","v":""},{"$f":"IF(ROWS(T$3:T36)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T36))))","v":""},{"$f":"IF(ROWS(U$3:U36)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U36))))","v":""},{"$f":"IF(ROWS(V$3:V36)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V36))))","v":""},null,null,"D6 Awareness","",{"$f":"SUM(Z36:Z37)/COUNTIF(Z36:Z37,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"D6","Perception","D6V2",{"$f":"IF(Scorecard!K43=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K43=\"Pioneering Phase I\",2,IF(Scorecard!K43=\"Expansion Phase II\",3,IF(Scorecard!K43=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L43=\"Positive\",\"POS\",IF(Scorecard!L43=\"Slight positive\",\"SPT\",IF(Scorecard!L43=\"Stagnation\",\"STA\",IF(Scorecard!L43=\"Slight negative\",\"SNT\",IF(Scorecard!L43=\"Negative\",\"NEG\",IF(Scorecard!L43=\"Conflicting\",\"CON\",IF(Scorecard!L43=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N37)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N37))))","v":""},{"$f":"IF(ROWS(O$3:O37)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O37))))","v":""},{"$f":"IF(ROWS(P$3:P37)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P37))))","v":""},{"$f":"IF(ROWS(Q$3:Q37)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q37))))","v":""},{"$f":"IF(ROWS(R$3:R37)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R37))))","v":""},{"$f":"IF(ROWS(S$3:S37)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S37))))","v":""},{"$f":"IF(ROWS(T$3:T37)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T37))))","v":""},{"$f":"IF(ROWS(U$3:U37)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U37))))","v":""},{"$f":"IF(ROWS(V$3:V37)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V37))))","v":""},null,null,"D6 Perception",""]
["Enabling environment","E1\nPolicy","E1","National plans","E1V1",{"$f":"IF(Scorecard!K46=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K46=\"Pioneering Phase I\",2,IF(Scorecard!K46=\"Expansion Phase II\",3,IF(Scorecard!K46=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L46=\"Positive\",\"POS\",IF(Scorecard!L46=\"Slight positive\",\"SPT\",IF(Scorecard!L46=\"Stagnation\",\"STA\",IF(Scorecard!L46=\"Slight negative\",\"SNT\",IF(Scorecard!L46=\"Negative\",\"NEG\",IF(Scorecard!L46=\"Conflicting\",\"CON\",IF(Scorecard!L46=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N38)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N38))))","v":""},{"$f":"IF(ROWS(O$3:O38)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O38))))","v":""},{"$f":"IF(ROWS(P$3:P38)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P38))))","v":""},{"$f":"IF(ROWS(Q$3:Q38)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q38))))","v":""},{"$f":"IF(ROWS(R$3:R38)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R38))))","v":""},{"$f":"IF(ROWS(S$3:S38)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S38))))","v":""},{"$f":"IF(ROWS(T$3:T38)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T38))))","v":""},{"$f":"IF(ROWS(U$3:U38)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U38))))","v":""},{"$f":"IF(ROWS(V$3:V38)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V38))))","v":""},null,null,"E1 National plans","",{"$f":"SUM(Z38:Z41)/COUNTIF(Z38:Z41,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"E1","Policy","E1V2",{"$f":"IF(Scorecard!K47=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K47=\"Pioneering Phase I\",2,IF(Scorecard!K47=\"Expansion Phase II\",3,IF(Scorecard!K47=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L47=\"Positive\",\"POS\",IF(Scorecard!L47=\"Slight positive\",\"SPT\",IF(Scorecard!L47=\"Stagnation\",\"STA\",IF(Scorecard!L47=\"Slight negative\",\"SNT\",IF(Scorecard!L47=\"Negative\",\"NEG\",IF(Scorecard!L47=\"Conflicting\",\"CON\",IF(Scorecard!L47=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N39)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N39))))","v":""},{"$f":"IF(ROWS(O$3:O39)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O39))))","v":""},{"$f":"IF(ROWS(P$3:P39)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P39))))","v":""},{"$f":"IF(ROWS(Q$3:Q39)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q39))))","v":""},{"$f":"IF(ROWS(R$3:R39)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R39))))","v":""},{"$f":"IF(ROWS(S$3:S39)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S39))))","v":""},{"$f":"IF(ROWS(T$3:T39)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T39))))","v":""},{"$f":"IF(ROWS(U$3:U39)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U39))))","v":""},{"$f":"IF(ROWS(V$3:V39)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V39))))","v":""},null,null,"E1 Policy",""]
[null,null,"E1","Product taxes","E1V3",{"$f":"IF(Scorecard!K48=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K48=\"Pioneering Phase I\",2,IF(Scorecard!K48=\"Expansion Phase II\",3,IF(Scorecard!K48=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L48=\"Positive\",\"POS\",IF(Scorecard!L48=\"Slight positive\",\"SPT\",IF(Scorecard!L48=\"Stagnation\",\"STA\",IF(Scorecard!L48=\"Slight negative\",\"SNT\",IF(Scorecard!L48=\"Negative\",\"NEG\",IF(Scorecard!L48=\"Conflicting\",\"CON\",IF(Scorecard!L48=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N40)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N40))))","v":""},{"$f":"IF(ROWS(O$3:O40)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O40))))","v":""},{"$f":"IF(ROWS(P$3:P40)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P40))))","v":""},{"$f":"IF(ROWS(Q$3:Q40)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q40))))","v":""},{"$f":"IF(ROWS(R$3:R40)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R40))))","v":""},{"$f":"IF(ROWS(S$3:S40)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S40))))","v":""},{"$f":"IF(ROWS(T$3:T40)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T40))))","v":""},{"$f":"IF(ROWS(U$3:U40)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U40))))","v":""},{"$f":"IF(ROWS(V$3:V40)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V40))))","v":""},null,null,"E1 Product taxes",""]
[null,null,"E1","Business taxes","E1V4",{"$f":"IF(Scorecard!K49=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K49=\"Pioneering Phase I\",2,IF(Scorecard!K49=\"Expansion Phase II\",3,IF(Scorecard!K49=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L49=\"Positive\",\"POS\",IF(Scorecard!L49=\"Slight positive\",\"SPT\",IF(Scorecard!L49=\"Stagnation\",\"STA\",IF(Scorecard!L49=\"Slight negative\",\"SNT\",IF(Scorecard!L49=\"Negative\",\"NEG\",IF(Scorecard!L49=\"Conflicting\",\"CON\",IF(Scorecard!L49=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N41)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N41))))","v":""},{"$f":"IF(ROWS(O$3:O41)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O41))))","v":""},{"$f":"IF(ROWS(P$3:P41)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P41))))","v":""},{"$f":"IF(ROWS(Q$3:Q41)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q41))))","v":""},{"$f":"IF(ROWS(R$3:R41)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R41))))","v":""},{"$f":"IF(ROWS(S$3:S41)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S41))))","v":""},{"$f":"IF(ROWS(T$3:T41)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T41))))","v":""},{"$f":"IF(ROWS(U$3:U41)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U41))))","v":""},{"$f":"IF(ROWS(V$3:V41)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V41))))","v":""},null,null,"E1 Business taxes",""]
[null,"E2\nAccess to finance","E2","Subsidies","E2V1",{"$f":"IF(Scorecard!K50=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K50=\"Pioneering Phase I\",2,IF(Scorecard!K50=\"Expansion Phase II\",3,IF(Scorecard!K50=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L50=\"Positive\",\"POS\",IF(Scorecard!L50=\"Slight positive\",\"SPT\",IF(Scorecard!L50=\"Stagnation\",\"STA\",IF(Scorecard!L50=\"Slight negative\",\"SNT\",IF(Scorecard!L50=\"Negative\",\"NEG\",IF(Scorecard!L50=\"Conflicting\",\"CON\",IF(Scorecard!L50=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N42)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N42))))","v":""},{"$f":"IF(ROWS(O$3:O42)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O42))))","v":""},{"$f":"IF(ROWS(P$3:P42)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P42))))","v":""},{"$f":"IF(ROWS(Q$3:Q42)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q42))))","v":""},{"$f":"IF(ROWS(R$3:R42)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R42))))","v":""},{"$f":"IF(ROWS(S$3:S42)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S42))))","v":""},{"$f":"IF(ROWS(T$3:T42)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T42))))","v":""},{"$f":"IF(ROWS(U$3:U42)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U42))))","v":""},{"$f":"IF(ROWS(V$3:V42)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V42))))","v":""},null,null,"E2 Subsidies","",{"$f":"SUM(Z42:Z45)/COUNTIF(Z42:Z45,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"E2","Financial institutions","E2V2",{"$f":"IF(Scorecard!K51=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K51=\"Pioneering Phase I\",2,IF(Scorecard!K51=\"Expansion Phase II\",3,IF(Scorecard!K51=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L51=\"Positive\",\"POS\",IF(Scorecard!L51=\"Slight positive\",\"SPT\",IF(Scorecard!L51=\"Stagnation\",\"STA\",IF(Scorecard!L51=\"Slight negative\",\"SNT\",IF(Scorecard!L51=\"Negative\",\"NEG\",IF(Scorecard!L51=\"Conflicting\",\"CON\",IF(Scorecard!L51=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N43)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N43))))","v":""},{"$f":"IF(ROWS(O$3:O43)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O43))))","v":""},{"$f":"IF(ROWS(P$3:P43)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P43))))","v":""},{"$f":"IF(ROWS(Q$3:Q43)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q43))))","v":""},{"$f":"IF(ROWS(R$3:R43)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R43))))","v":""},{"$f":"IF(ROWS(S$3:S43)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S43))))","v":""},{"$f":"IF(ROWS(T$3:T43)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T43))))","v":""},{"$f":"IF(ROWS(U$3:U43)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U43))))","v":""},{"$f":"IF(ROWS(V$3:V43)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V43))))","v":""},null,null,"E2 Financial institutions",""]
[null,null,"E2","Financing options by suppliers","E2V3",{"$f":"IF(Scorecard!K52=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K52=\"Pioneering Phase I\",2,IF(Scorecard!K52=\"Expansion Phase II\",3,IF(Scorecard!K52=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L52=\"Positive\",\"POS\",IF(Scorecard!L52=\"Slight positive\",\"SPT\",IF(Scorecard!L52=\"Stagnation\",\"STA\",IF(Scorecard!L52=\"Slight negative\",\"SNT\",IF(Scorecard!L52=\"Negative\",\"NEG\",IF(Scorecard!L52=\"Conflicting\",\"CON\",IF(Scorecard!L52=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N44)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N44))))","v":""},{"$f":"IF(ROWS(O$3:O44)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O44))))","v":""},{"$f":"IF(ROWS(P$3:P44)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P44))))","v":""},{"$f":"IF(ROWS(Q$3:Q44)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q44))))","v":""},{"$f":"IF(ROWS(R$3:R44)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R44))))","v":""},{"$f":"IF(ROWS(S$3:S44)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S44))))","v":""},{"$f":"IF(ROWS(T$3:T44)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T44))))","v":""},{"$f":"IF(ROWS(U$3:U44)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U44))))","v":""},{"$f":"IF(ROWS(V$3:V44)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V44))))","v":""},null,null,"E2 Financing options by suppliers",""]
[null,null,"E2","Financing options for consumers","E2V4",{"$f":"IF(Scorecard!K53=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K53=\"Pioneering Phase I\",2,IF(Scorecard!K53=\"Expansion Phase II\",3,IF(Scorecard!K53=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L53=\"Positive\",\"POS\",IF(Scorecard!L53=\"Slight positive\",\"SPT\",IF(Scorecard!L53=\"Stagnation\",\"STA\",IF(Scorecard!L53=\"Slight negative\",\"SNT\",IF(Scorecard!L53=\"Negative\",\"NEG\",IF(Scorecard!L53=\"Conflicting\",\"CON\",IF(Scorecard!L53=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$f":"VLOOKUP(I45,$AS$3:$AT$12,2,FALSE)","v":{"$error":"#N/A"}},false,false,false,{"$f":"IF(ROWS(N$3:N45)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N45))))","v":""},{"$f":"IF(ROWS(O$3:O45)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O45))))","v":""},{"$f":"IF(ROWS(P$3:P45)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P45))))","v":""},{"$f":"IF(ROWS(Q$3:Q45)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q45))))","v":""},{"$f":"IF(ROWS(R$3:R45)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R45))))","v":""},{"$f":"IF(ROWS(S$3:S45)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S45))))","v":""},{"$f":"IF(ROWS(T$3:T45)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T45))))","v":""},{"$f":"IF(ROWS(U$3:U45)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U45))))","v":""},{"$f":"IF(ROWS(V$3:V45)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V45))))","v":""},null,null,"E2 Financing options for consumers",""]
[null,"E3\nQuality regulations, norms and standards","E3","Regulation, norms and standards","E3V1",{"$f":"IF(Scorecard!K54=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K54=\"Pioneering Phase I\",2,IF(Scorecard!K54=\"Expansion Phase II\",3,IF(Scorecard!K54=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L54=\"Positive\",\"POS\",IF(Scorecard!L54=\"Slight positive\",\"SPT\",IF(Scorecard!L54=\"Stagnation\",\"STA\",IF(Scorecard!L54=\"Slight negative\",\"SNT\",IF(Scorecard!L54=\"Negative\",\"NEG\",IF(Scorecard!L54=\"Conflicting\",\"CON\",IF(Scorecard!L54=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N46)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N46))))","v":""},{"$f":"IF(ROWS(O$3:O46)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O46))))","v":""},{"$f":"IF(ROWS(P$3:P46)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P46))))","v":""},{"$f":"IF(ROWS(Q$3:Q46)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q46))))","v":""},{"$f":"IF(ROWS(R$3:R46)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R46))))","v":""},{"$f":"IF(ROWS(S$3:S46)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S46))))","v":""},{"$f":"IF(ROWS(T$3:T46)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T46))))","v":""},{"$f":"IF(ROWS(U$3:U46)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U46))))","v":""},{"$f":"IF(ROWS(V$3:V46)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V46))))","v":""},null,null,"E3 Regulation, norms and standards","",{"$f":"SUM(Z46:Z47)/COUNTIF(Z46:Z47,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"E3","Enforcement","E3V2",{"$f":"IF(Scorecard!K55=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K55=\"Pioneering Phase I\",2,IF(Scorecard!K55=\"Expansion Phase II\",3,IF(Scorecard!K55=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L55=\"Positive\",\"POS\",IF(Scorecard!L55=\"Slight positive\",\"SPT\",IF(Scorecard!L55=\"Stagnation\",\"STA\",IF(Scorecard!L55=\"Slight negative\",\"SNT\",IF(Scorecard!L55=\"Negative\",\"NEG\",IF(Scorecard!L55=\"Conflicting\",\"CON\",IF(Scorecard!L55=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N47)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N47))))","v":""},{"$f":"IF(ROWS(O$3:O47)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O47))))","v":""},{"$f":"IF(ROWS(P$3:P47)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P47))))","v":""},{"$f":"IF(ROWS(Q$3:Q47)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q47))))","v":""},{"$f":"IF(ROWS(R$3:R47)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R47))))","v":""},{"$f":"IF(ROWS(S$3:S47)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S47))))","v":""},{"$f":"IF(ROWS(T$3:T47)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T47))))","v":""},{"$f":"IF(ROWS(U$3:U47)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U47))))","v":""},{"$f":"IF(ROWS(V$3:V47)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V47))))","v":""},null,null,"E3 Enforcement",""]
[null,"E4\nMarket information","E4","Cost of information","E4V1",{"$f":"IF(Scorecard!K56=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K56=\"Pioneering Phase I\",2,IF(Scorecard!K56=\"Expansion Phase II\",3,IF(Scorecard!K56=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L56=\"Positive\",\"POS\",IF(Scorecard!L56=\"Slight positive\",\"SPT\",IF(Scorecard!L56=\"Stagnation\",\"STA\",IF(Scorecard!L56=\"Slight negative\",\"SNT\",IF(Scorecard!L56=\"Negative\",\"NEG\",IF(Scorecard!L56=\"Conflicting\",\"CON\",IF(Scorecard!L56=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N48)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N48))))","v":""},{"$f":"IF(ROWS(O$3:O48)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O48))))","v":""},{"$f":"IF(ROWS(P$3:P48)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P48))))","v":""},{"$f":"IF(ROWS(Q$3:Q48)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q48))))","v":""},{"$f":"IF(ROWS(R$3:R48)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R48))))","v":""},{"$f":"IF(ROWS(S$3:S48)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S48))))","v":""},{"$f":"IF(ROWS(T$3:T48)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T48))))","v":""},{"$f":"IF(ROWS(U$3:U48)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U48))))","v":""},{"$f":"IF(ROWS(V$3:V48)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V48))))","v":""},null,null,"E4 Cost of information","",{"$f":"SUM(Z48:Z50)/COUNTIF(Z48:Z50,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"E4","Market facilitation organizations","E4V2",{"$f":"IF(Scorecard!K57=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K57=\"Pioneering Phase I\",2,IF(Scorecard!K57=\"Expansion Phase II\",3,IF(Scorecard!K57=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L57=\"Positive\",\"POS\",IF(Scorecard!L57=\"Slight positive\",\"SPT\",IF(Scorecard!L57=\"Stagnation\",\"STA\",IF(Scorecard!L57=\"Slight negative\",\"SNT\",IF(Scorecard!L57=\"Negative\",\"NEG\",IF(Scorecard!L57=\"Conflicting\",\"CON\",IF(Scorecard!L57=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N49)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N49))))","v":""},{"$f":"IF(ROWS(O$3:O49)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O49))))","v":""},{"$f":"IF(ROWS(P$3:P49)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P49))))","v":""},{"$f":"IF(ROWS(Q$3:Q49)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q49))))","v":""},{"$f":"IF(ROWS(R$3:R49)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R49))))","v":""},{"$f":"IF(ROWS(S$3:S49)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S49))))","v":""},{"$f":"IF(ROWS(T$3:T49)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T49))))","v":""},{"$f":"IF(ROWS(U$3:U49)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U49))))","v":""},{"$f":"IF(ROWS(V$3:V49)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V49))))","v":""},null,null,"E4 Market facilitation organizations",""]
[null,null,"E4","Awareness campaigns ","E4V3",{"$f":"IF(Scorecard!K58=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K58=\"Pioneering Phase I\",2,IF(Scorecard!K58=\"Expansion Phase II\",3,IF(Scorecard!K58=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L58=\"Positive\",\"POS\",IF(Scorecard!L58=\"Slight positive\",\"SPT\",IF(Scorecard!L58=\"Stagnation\",\"STA\",IF(Scorecard!L58=\"Slight negative\",\"SNT\",IF(Scorecard!L58=\"Negative\",\"NEG\",IF(Scorecard!L58=\"Conflicting\",\"CON\",IF(Scorecard!L58=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N50)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N50))))","v":""},{"$f":"IF(ROWS(O$3:O50)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O50))))","v":""},{"$f":"IF(ROWS(P$3:P50)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P50))))","v":""},{"$f":"IF(ROWS(Q$3:Q50)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q50))))","v":""},{"$f":"IF(ROWS(R$3:R50)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R50))))","v":""},{"$f":"IF(ROWS(S$3:S50)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S50))))","v":""},{"$f":"IF(ROWS(T$3:T50)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T50))))","v":""},{"$f":"IF(ROWS(U$3:U50)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U50))))","v":""},{"$f":"IF(ROWS(V$3:V50)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V50))))","v":""},null,null,"E4 Awareness campaigns ",""]
[null,"E5\nExpertise development","E5","Courses","E5V1",{"$f":"IF(Scorecard!K59=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K59=\"Pioneering Phase I\",2,IF(Scorecard!K59=\"Expansion Phase II\",3,IF(Scorecard!K59=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L59=\"Positive\",\"POS\",IF(Scorecard!L59=\"Slight positive\",\"SPT\",IF(Scorecard!L59=\"Stagnation\",\"STA\",IF(Scorecard!L59=\"Slight negative\",\"SNT\",IF(Scorecard!L59=\"Negative\",\"NEG\",IF(Scorecard!L59=\"Conflicting\",\"CON\",IF(Scorecard!L59=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N51)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N51))))","v":""},{"$f":"IF(ROWS(O$3:O51)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O51))))","v":""},{"$f":"IF(ROWS(P$3:P51)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P51))))","v":""},{"$f":"IF(ROWS(Q$3:Q51)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q51))))","v":""},{"$f":"IF(ROWS(R$3:R51)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R51))))","v":""},{"$f":"IF(ROWS(S$3:S51)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S51))))","v":""},{"$f":"IF(ROWS(T$3:T51)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T51))))","v":""},{"$f":"IF(ROWS(U$3:U51)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U51))))","v":""},{"$f":"IF(ROWS(V$3:V51)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V51))))","v":""},null,null,"E5 Courses","",{"$f":"SUM(Z51:Z54)/COUNTIF(Z51:Z54,\">0\")","v":{"$error":"#DIV/0!"}}]
[null,null,"E5","BDT","E5V2",{"$f":"IF(Scorecard!K60=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K60=\"Pioneering Phase I\",2,IF(Scorecard!K60=\"Expansion Phase II\",3,IF(Scorecard!K60=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L60=\"Positive\",\"POS\",IF(Scorecard!L60=\"Slight positive\",\"SPT\",IF(Scorecard!L60=\"Stagnation\",\"STA\",IF(Scorecard!L60=\"Slight negative\",\"SNT\",IF(Scorecard!L60=\"Negative\",\"NEG\",IF(Scorecard!L60=\"Conflicting\",\"CON\",IF(Scorecard!L60=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N52)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N52))))","v":""},{"$f":"IF(ROWS(O$3:O52)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O52))))","v":""},{"$f":"IF(ROWS(P$3:P52)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P52))))","v":""},{"$f":"IF(ROWS(Q$3:Q52)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q52))))","v":""},{"$f":"IF(ROWS(R$3:R52)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R52))))","v":""},{"$f":"IF(ROWS(S$3:S52)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S52))))","v":""},{"$f":"IF(ROWS(T$3:T52)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T52))))","v":""},{"$f":"IF(ROWS(U$3:U52)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U52))))","v":""},{"$f":"IF(ROWS(V$3:V52)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V52))))","v":""},null,null,"E5 BDT",""]
[null,null,"E5","User training","E5V3",{"$f":"IF(Scorecard!K61=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K61=\"Pioneering Phase I\",2,IF(Scorecard!K61=\"Expansion Phase II\",3,IF(Scorecard!K61=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L61=\"Positive\",\"POS\",IF(Scorecard!L61=\"Slight positive\",\"SPT\",IF(Scorecard!L61=\"Stagnation\",\"STA\",IF(Scorecard!L61=\"Slight negative\",\"SNT\",IF(Scorecard!L61=\"Negative\",\"NEG\",IF(Scorecard!L61=\"Conflicting\",\"CON\",IF(Scorecard!L61=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N53)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N53))))","v":""},{"$f":"IF(ROWS(O$3:O53)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O53))))","v":""},{"$f":"IF(ROWS(P$3:P53)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P53))))","v":""},{"$f":"IF(ROWS(Q$3:Q53)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q53))))","v":""},{"$f":"IF(ROWS(R$3:R53)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R53))))","v":""},{"$f":"IF(ROWS(S$3:S53)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S53))))","v":""},{"$f":"IF(ROWS(T$3:T53)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T53))))","v":""},{"$f":"IF(ROWS(U$3:U53)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U53))))","v":""},{"$f":"IF(ROWS(V$3:V53)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V53))))","v":""},null,null,"E5 User training",""]
[null,null,"E5","Service availability","E5V4",{"$f":"IF(Scorecard!K62=\"Pre-Commercial Phase 0\",1,IF(Scorecard!K62=\"Pioneering Phase I\",2,IF(Scorecard!K62=\"Expansion Phase II\",3,IF(Scorecard!K62=\"Maturity Phase III\",4,\"\"))))","v":""},"",{"$f":"IF(Scorecard!L62=\"Positive\",\"POS\",IF(Scorecard!L62=\"Slight positive\",\"SPT\",IF(Scorecard!L62=\"Stagnation\",\"STA\",IF(Scorecard!L62=\"Slight negative\",\"SNT\",IF(Scorecard!L62=\"Negative\",\"NEG\",IF(Scorecard!L62=\"Conflicting\",\"CON\",IF(Scorecard!L62=\"Unknown\",\"UNC\",\"\")))))))","v":""},"",{"$error":"#N/A"},false,false,false,{"$f":"IF(ROWS(N$3:N54)>N$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(N$3:N54))))","v":""},{"$f":"IF(ROWS(O$3:O54)>O$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=1,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(O$3:O54))))","v":""},{"$f":"IF(ROWS(P$3:P54)>P$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(P$3:P54))))","v":""},{"$f":"IF(ROWS(Q$3:Q54)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q54))))","v":""},{"$f":"IF(ROWS(R$3:R54)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R54))))","v":""},{"$f":"IF(ROWS(S$3:S54)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S54))))","v":""},{"$f":"IF(ROWS(T$3:T54)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T54))))","v":""},{"$f":"IF(ROWS(U$3:U54)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U54))))","v":""},{"$f":"IF(ROWS(V$3:V54)>V$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(M$3:M$54=TRUE,ROW(M$3:M$54)-ROW(M$3)+1),ROWS(V$3:V54))))","v":""},null,null,"E5 Service availability",""]
[{"$nulls":16},{"$f":"IF(ROWS(Q$3:Q55)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q55))))","v":""},{"$f":"IF(ROWS(R$3:R55)>R$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(R$3:R55))))","v":""},{"$f":"IF(ROWS(S$3:S55)>S$2,\"\",INDEX($J$3:$J$54,SMALL(IF(K$3:K$54,ROW(K$3:K$54)-ROW(K$3)+1),ROWS(S$3:S55))))","v":""},{"$f":"IF(ROWS(T$3:T55)>T$2,\"\",INDEX(CONCATENATE($C$3:$C$54,\" \",$D$3:$D$54),SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(T$3:T55))))","v":""},{"$f":"IF(ROWS(U$3:U55)>U$2,\"\",INDEX($J$3:$J$54,SMALL(IF(L$3:L$54,ROW(L$3:L$54)-ROW(L$3)+1),ROWS(U$3:U55))))","v":""}]
[{"$nulls":16},{"$f":"IF(ROWS(Q$3:Q56)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q56))))","v":""}]
[{"$nulls":16},{"$f":"IF(ROWS(Q$3:Q57)>Q$2,\"\",INDEX($J$3:$J$54,SMALL(IF(G$3:G$54=2,ROW(G$3:G$54)-ROW(G$3)+1),ROWS(Q$3:Q57))))","v":""}]