{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","User manual","Company data","Overview of export businesses","Exportmatrix","Vorlage","Neu1","New","Neu3"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":1,"defined_names":23,"comments":7},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"merged":[[5,1,5,2],[10,1,10,2]]}
[]
[]
[]
[null,"Introduction"]
[]
[null,"The X-Risk export risk check is the outcome of an applied research project backed by the Commission for Technology and Innovation (CTI). It was developed and programmed in cooperation with the following partners:"]
[]
[]
[]
[]
[null,"Limitations: The X-Risk export risk check is intended solely for the assessment of risks in export businesses, and covers only one part of the risks to which companies are confronted. The check refers to publicly available data for which the correctness cannot be guaranteed. Under certain circumstances, companies may need to gather additional and more specific information in order to properly assess their own risks in the export business."]

{"sheet":"User manual","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[5,1,5,2],[12,1,12,2],[15,1,15,2]]}
[]
[]
[]
[null,"Using the tool"]
[]
[null,"The X-Risk export check risk is designed to assess the export business of a company with respect to opportunities and risks, to gain an overview of the risk exposure of the company, and to derive measures for risk control. The development of the export risk check is based on a survey of 28 internationally experienced Swiss companies. This reflects how they handle export risks and provides the opportunity to systematise the export risk management of the company.  The check is structured as follows:"]
[null,"1)","Inputting of corporate data: In order to evaluate the relative size of the export business and the associated risks, the total turnover of the company and its net equity must be entered in the 'Company Data' workbook."]
[null,"2)","Determination of export businesses: The company must decide on its own understanding of the term ‘export business’ (projects in foreign markets, foreign customers, foreign markets) and the aspects of the export business for which a risk analysis should be created (critical amount of turnover, geographic location of the market, possible safeguarding of customer payments, critical operating conditions of products). Export businesses that fulfil the defined conditions are entered in the 'Export Businesses' workbook."]
[null,"3)","Assessment of export business: An individual portfolio is created for each determined export business. In these portfolios, the businesses are assessed with respect to resulting opportunities and risks. The evaluation of opportunities proceeds on the basis of expected profit contributions from the business. The evaluation of risks proceeds via an appraisal of the damage potential and the probability of occurrence of various export risks. The risk assessment is supported by the inclusion of links that reference relevant sources of information."]
[null,"4)","Analysis of the Export Risk Matrix: The export businesses of the company are positioned in an export risk matrix on the basis of anticipated gains and losses. The size of the circles reflects their significance for the company, based on share of turnover. Their position indicates the ratio of expected gains and losses. If an export business is positioned in the lower right half of the matrix, it belongs to one of the attractive foreign commitments in which the opportunities are greater than the risks. If a business is positioned in the upper left corner of the matrix, the risks outweigh the related opportunities. The company undertakes an overall assessment of the risk exposure in the export business and decides which export businesses require risk control measures."]
[null,"5)","Monitoring of export risks: The possible measures for the monitoring of export risks comprise the prevention, relocation and reduction of the expected risks. The related measures are more fully described in the X-risk guidelines. These are intended to reduce export risks to an acceptable level for the company."]
[null,"6)","Observation of export risks: Risks that are identified in the determination of export businesses should be periodically reviewed as well as re-evaluated, if required. The company should continuously monitor the development of risk exposure, and at year-end document measures taken in the Annual Report. "]
[null,"These steps for export risk management are described in more detail in the accompanying guidelines. The guidelines also contain advice on the institutionalisation in the company of export risk management.  "]

{"sheet":"Company data","index":2,"n_rows":10,"n_cols":2,"rows_kept":10}
[]
[]
[]
[null,"Company data"]
[]
[null,"\nCompany name"]
[]
[null,"\nRevenue (in CHF)"]
[]
[null,"\nEquity (in CHF)"]

{"sheet":"Overview of export businesses","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"merged":[[1,3,3,4],[1,5,3,5]]}
[]
[{"$nulls":3},"Input new export business"]
[]
[null,"Overview of export businesses"]
[]
[null,"Name","Designation","Product","Client","Country","Expected export revenue (in CHF)","Total expected gains (in CHF)","Total expected losses (in CHF)"]
[null,{"$f":"IF(ROW(J7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(J7))&\"'!C6\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(J7))&\"'!C6\"),\"\"))","v":""},{"$f":"IF(ROW(K7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(K7))&\"'!C7\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(K7))&\"'!C7\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C8\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C8\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C9\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C9\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C10\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!C10\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F6\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F6\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F9\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F9\"),\"\"))","v":""},{"$f":"IF(ROW(L7)>COUNTA(x),\"\",IF(INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F10\")<>\"\",INDIRECT(\"'\"&INDEX(x,ROW(L7))&\"'!F10\"),\"\"))","v":""}]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]

{"sheet":"Exportmatrix","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"merged":[[6,1,22,1]]}
[]
[]
[]
[null,"Export matrix"]
[]
[{"$nulls":9},"Name","Designation",{"$nulls":6},"Expected export revenue / Total revenue","Expected gains / Net equity = opportunities",""]
[null,"Expected losses in % of net equity",{"$nulls":7},{"$f":"'Overview of export businesses'!B7","v":""},{"$f":"'Overview of export businesses'!C7","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G7/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H7/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I7/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B8","v":""},{"$f":"'Overview of export businesses'!C8","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G8/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H8/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I8/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B9","v":""},{"$f":"'Overview of export businesses'!C9","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G9/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H9/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I9/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B10","v":""},{"$f":"'Overview of export businesses'!C10","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G10/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H10/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I10/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B11","v":""},{"$f":"'Overview of export businesses'!C11","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G11/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H11/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I11/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B12","v":""},{"$f":"'Overview of export businesses'!C12","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G12/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H12/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I12/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B13","v":""},{"$f":"'Overview of export businesses'!C13","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G13/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H13/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I13/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B14","v":""},{"$f":"'Overview of export businesses'!C14","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G14/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H14/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I14/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B15","v":""},{"$f":"'Overview of export businesses'!C15","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G15/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H15/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I15/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B16","v":""},{"$f":"'Overview of export businesses'!C16","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G16/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H16/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I16/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B17","v":""},{"$f":"'Overview of export businesses'!C17","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G17/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H17/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I17/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B18","v":""},{"$f":"'Overview of export businesses'!C18","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G18/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H18/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I18/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B19","v":""},{"$f":"'Overview of export businesses'!C19","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G19/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H19/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I19/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B20","v":""},{"$f":"'Overview of export businesses'!C20","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G20/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H20/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I20/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B21","v":""},{"$f":"'Overview of export businesses'!C21","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G21/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H21/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I21/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B22","v":""},{"$f":"'Overview of export businesses'!C22","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G22/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H22/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I22/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B23","v":""},{"$f":"'Overview of export businesses'!C23","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G23/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H23/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I23/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B24","v":""},{"$f":"'Overview of export businesses'!C24","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G24/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H24/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I24/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B25","v":""},{"$f":"'Overview of export businesses'!C25","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G25/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H25/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I25/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B26","v":""},{"$f":"'Overview of export businesses'!C26","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G26/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H26/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I26/Eigenkapital","v":{"$error":"#VALUE!"}}]
[{"$nulls":9},{"$f":"'Overview of export businesses'!B27","v":""},{"$f":"'Overview of export businesses'!C27","v":""},{"$nulls":6},{"$f":"('Overview of export businesses'!G27/Unternehmensumsatz)*100","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!H27/Eigenkapital","v":{"$error":"#VALUE!"}},{"$f":"'Overview of export businesses'!I27/Eigenkapital","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,null,"Expected gains in % of net equity"]

{"sheet":"Vorlage","index":5,"n_rows":74,"n_cols":8,"rows_kept":74,"hidden":true,"merged":[[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[12,1,19,1],[20,1,23,1],[24,1,27,1],[28,1,30,1],[31,1,35,1],[36,1,40,1],[41,1,46,1],[47,1,49,1],[50,1,55,1],[56,1,65,1]]}
[]
[]
[]
[null,"Beurteilung Exportgeschäft"]
[]
[null,"Name",null,null,"Erwarteter Exportumsatz \n(in CHF)"]
[null,"Kurzbezeichung",null,null,"Erwarteter Deckungsbeitrag \n(in CHF)"]
[null,"Produkt",null,null,"Ausserordentliche Erträge/Kosten \n(+/- in CHF)"]
[null,"Kunde",null,null,"\nTotal erwartete Gewinne (in CHF)\n",{"$f":"SUM(F7:F8)","v":{"v":0,"d":"0.00"}}]
[null,"Land",null,null,"\nTotal erwartete Verluste (in CHF)\n",{"$f":"SUM(G13:G66)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Risiko-Arten",null,"Quelle","Maximaler Verlust (in CHF)","Eintretens-wahrscheinlichkeit"," Erwarteter Verlust (in CHF)","Ws in %"]
[null,"Wirtschaftliche Risiken","Währungsverluste","www.eulerhermes-aktuell.de/de/laenderinformationen/laenderinformationen.html",0,"Unwahrscheinlich",{"$f":"E13*H13","v":0},{"$f":"IF(F13=Unwahrscheinlich,$C$69,(IF(F13=STEW,$C$70,IF(F13=TEW,$C$71,IF(F13=MEW,$C$72,IF(F13=HEW,$C$73,IF(F13=SHEW,$C$74)))))))","v":{"v":0,"d":"0%"}}]
[null,null,"Inflation","http://data.worldbank.org/indicator/NY.GDP.DEFL.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rezession","http://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Devisenknappheit",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Behinderung Devisentransfer","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung Mehrwertsteuer",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Steuererhöhungen","www.doingbusiness.org/data/exploretopics/paying-taxes",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollerhöhungen","www.wto.org/english/res_e/statis_e/statis_bis_e.htm?solution=WTO&path=/Dashboards/MAPS&file=Tariff.wcdf&bookmarkState={%22impl%22:%22client%22,%22params%22:{%22langParam%22:%22en%22}}",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Rechtliche Risiken","Veränderung Produktvorschriften",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rechtsunsicherheit","http://worldjusticeproject.org/rule-of-law-index",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Mangelhafte Durchsetzbarkeit von Verträgen","www.doingbusiness.org/data/exploretopics/enforcing-contracts",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Korruption","www.transparency.ch/de/publikationen/Les_indices_de_TI/index.php",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Absatzrisiken","Ausfall Vertriebspartner",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Veränderung Kundenbedürfnisse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zahlungsausfälle","www.atradius.co.uk/creditmanagementknowledge/publications/europeanpaymentbehaviour.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Annulation Bestellungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Wettbewerbsrisiken","Produktkopie","www.internationalpropertyrightsindex.org/ranking",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Neue Konkurrenten",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Substitutionen Produkte",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Personalrisiken","Gesetzesverstösse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Abwerbung","www.doingbusiness.org/data/exploretopics/employing-workers",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verletzung","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Illoyalität",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Politische Risiken","Unruhen","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Terrorismus","www.eda.admin.ch/eda/de/home/travad/travel.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Handelsembargos","www.seco.admin.ch/themen/00513/00620/ ",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Importrestriktionen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verstaatlichungen","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Natürliche Risiken","Erdbeben","http://earthquake.usgs.gov/earthquakes/map/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Epidemien","www.who.int/research/en/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Vulkanausbrüche","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=12&m=03&y=2013",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Überschwemmungen","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=9&m=03&y=2013",0,"Unwahrscheinlich",{"$f":"E45*H45","v":0},{"$f":"IF(F45=Unwahrscheinlich,$C$69,(IF(F45=STEW,$C$70,IF(F45=TEW,$C$71,IF(F45=MEW,$C$72,IF(F45=HEW,$C$73,IF(F45=SHEW,$C$74)))))))","v":{"v":0,"d":"0%"}}]
[null,null,"Erdruschte","www.emdat.be/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Stürme","http://severe.worldweather.wmo.int/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Produktrisiken","Mangelhafte Funktion",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Haftpflicht",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zweckentfremdung (Dual Use Güter)","www.efbs.admin.ch/fileadmin/efbs-dateien/transportguideline/d-SECO-Dual-use-Gueterkontrollverordnung-2008.pdf",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Vertriebsrisiken","Verzögerungen","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Transportschäden",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Warenverluste beim Transport",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Unvollständige Lieferungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollformalitäten","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"unvollständige Dokumente",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Weitere",null,null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[]
[null,"Skalenwert","Eintretenswahrscheinlichkeit in Prozent"]
[null,"Unwahrscheinlich",{"v":0,"d":"0%"}]
[null,"Sehr tief (10%)",{"v":0.1,"d":"10%"}]
[null,"Tief (30%)",{"v":0.3,"d":"30%"}]
[null,"Mittel (50%)",{"v":0.5,"d":"50%"}]
[null,"Hoch (70%)",{"v":0.7,"d":"70%"}]
[null,"Sehr hoch (90%)",{"v":0.9,"d":"90%"}]

{"sheet":"Neu1","index":6,"n_rows":74,"n_cols":8,"rows_kept":74,"hidden":true,"merged":[[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[12,1,19,1],[20,1,23,1],[24,1,27,1],[28,1,30,1],[31,1,35,1],[36,1,40,1],[41,1,46,1],[47,1,49,1],[50,1,55,1],[56,1,65,1]]}
[]
[]
[]
[null,"Beurteilung Exportgeschäft"]
[]
[null,"Name",null,null,"Erwarteter Exportumsatz \n(in CHF)"]
[null,"Kurzbezeichung",null,null,"Erwarteter Deckungsbeitrag \n(in CHF)"]
[null,"Produkt",null,null,"Ausserordentliche Erträge/Kosten \n(+/- in CHF)"]
[null,"Kunde",null,null,"\nTotal erwartete Gewinne (in CHF)\n",{"$f":"SUM(F7:F8)","v":{"v":0,"d":"0.00"}}]
[null,"Land",null,null,"\nTotal erwartete Verluste (in CHF)\n",{"$f":"SUM(G13:G66)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Risiko-Arten",null,"Quelle","Maximaler Verlust (in CHF)","Eintretens-wahrscheinlichkeit"," Erwarteter Verlust (in CHF)","Ws in %"]
[null,"Wirtschaftliche Risiken","Währungsverluste","www.eulerhermes-aktuell.de/de/laenderinformationen/laenderinformationen.html",0,"Unwahrscheinlich",{"$f":"E13*H13","v":0},{"$f":"IF(F13=Unwahrscheinlich,$C$69,(IF(F13=STEW,$C$70,IF(F13=TEW,$C$71,IF(F13=MEW,$C$72,IF(F13=HEW,$C$73,IF(F13=SHEW,$C$74)))))))","v":{"v":0,"d":"0%"}}]
[null,null,"Inflation","http://data.worldbank.org/indicator/NY.GDP.DEFL.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rezession","http://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Devisenknappheit",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Behinderung Devisentransfer","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung Mehrwertsteuer",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Steuererhöhungen","www.doingbusiness.org/data/exploretopics/paying-taxes",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollerhöhungen","www.wto.org/english/res_e/statis_e/statis_bis_e.htm?solution=WTO&path=/Dashboards/MAPS&file=Tariff.wcdf&bookmarkState={%22impl%22:%22client%22,%22params%22:{%22langParam%22:%22en%22}}",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Rechtliche Risiken","Veränderung Produktvorschriften",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rechtsunsicherheit","http://worldjusticeproject.org/rule-of-law-index",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Mangelhafte Durchsetzbarkeit von Verträgen","www.doingbusiness.org/data/exploretopics/enforcing-contracts",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Korruption","www.transparency.ch/de/publikationen/Les_indices_de_TI/index.php",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Absatzrisiken","Ausfall Vertriebspartner",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Veränderung Kundenbedürfnisse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zahlungsausfälle","www.atradius.co.uk/creditmanagementknowledge/publications/europeanpaymentbehaviour.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Annulation Bestellungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Wettbewerbsrisiken","Produktkopie","www.internationalpropertyrightsindex.org/ranking",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Neue Konkurrenten",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Substitutionen Produkte",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Personalrisiken","Gesetzesverstösse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Abwerbung","www.doingbusiness.org/data/exploretopics/employing-workers",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verletzung","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Illoyalität",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Politische Risiken","Unruhen","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Terrorismus","www.eda.admin.ch/eda/de/home/travad/travel.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Handelsembargos","www.seco.admin.ch/themen/00513/00620/ ",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Importrestriktionen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verstaatlichungen","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Natürliche Risiken","Erdbeben","http://earthquake.usgs.gov/earthquakes/map/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Epidemien","www.who.int/research/en/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Vulkanausbrüche","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=12&m=03&y=2013",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Überschwemmungen","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=9&m=03&y=2013",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Erdruschte","www.emdat.be/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Stürme","http://severe.worldweather.wmo.int/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Produktrisiken","Mangelhafte Funktion",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Haftpflicht",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zweckentfremdung (Dual Use Güter)","www.efbs.admin.ch/fileadmin/efbs-dateien/transportguideline/d-SECO-Dual-use-Gueterkontrollverordnung-2008.pdf",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Vertriebsrisiken","Verzögerungen","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Transportschäden",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Warenverluste beim Transport",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Unvollständige Lieferungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollformalitäten","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"unvollständige Dokumente",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Weitere",null,null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[]
[null,"Skalenwert","Eintretenswahrscheinlichkeit in Prozent"]
[null,"Unwahrscheinlich",{"v":0,"d":"0%"}]
[null,"Sehr tief (10%)",{"v":0.1,"d":"10%"}]
[null,"Tief (30%)",{"v":0.3,"d":"30%"}]
[null,"Mittel (50%)",{"v":0.5,"d":"50%"}]
[null,"Hoch (70%)",{"v":0.7,"d":"70%"}]
[null,"Sehr hoch (90%)",{"v":0.9,"d":"90%"}]

{"sheet":"New","index":7,"n_rows":74,"n_cols":8,"rows_kept":74,"merged":[[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[12,1,19,1],[20,1,23,1],[24,1,27,1],[28,1,30,1],[31,1,35,1],[36,1,40,1],[41,1,46,1],[47,1,49,1],[50,1,55,1],[56,1,65,1]]}
[]
[]
[]
[null,"Assessment of Export Business"]
[]
[null,"Name",null,null,"Expected export revenue (in CHF)"]
[null,"Designation",null,null,"Expected marginal income (in CHF)"]
[null,"Product",null,null,"Extraordinary income/expenses (+/- in CHF)"]
[null,"Client",null,null,"Client\n",{"$f":"SUM(F7:F8)","v":{"v":0,"d":"0.00"}}]
[null,"Country",null,null,"\nTotal expected losses (in CHF)",{"$f":"SUM(G13:G66)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Risk types",null,"Source","Maximum loss (in CHF)","Probability of occurrence","Expected loss (in CHF)","Ws in%"]
[null,"Commerical risks","Currency losses","www.eulerhermes-aktuell.de/de/laenderinformationen/laenderinformationen.html",0,"Unlikely",{"$f":"E13*H13","v":0},{"$f":"IF(F13=Unwahrscheinlich,$C$69,(IF(F13=STEW,$C$70,IF(F13=TEW,$C$71,IF(F13=MEW,$C$72,IF(F13=HEW,$C$73,IF(F13=SHEW,$C$74)))))))","v":false}]
[null,null,"Inflation","http://data.worldbank.org/indicator/NY.GDP.DEFL.KD.ZG",0,"Unlikely",0,false]
[null,null,"Recession","http://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG",0,"Unlikely",0,false]
[null,null,"Currency shortage",null,0,"Unlikely",0,false]
[null,null,"Obstacles in currency exchange","www.heritage.org/index/heatmap",0,"Unlikely",0,false]
[null,null,"Blocking of VAT",null,0,"Unlikely",0,false]
[null,null,"Tax increases","www.doingbusiness.org/data/exploretopics/paying-taxes",0,"Unlikely",0,false]
[null,null,"Zollerhöhungen","www.wto.org/english/res_e/statis_e/statis_bis_e.htm?solution=WTO&path=/Dashboards/MAPS&file=Tariff.wcdf&bookmarkState={%22impl%22:%22client%22,%22params%22:{%22langParam%22:%22en%22}}",0,"Unlikely",0,false]
[null,"Legal Risks","Change in product requirements",null,0,"Unlikely",0,false]
[null,null,"Legal uncertainty","http://worldjusticeproject.org/rule-of-law-index",0,"Unlikely",0,false]
[null,null,"Inadequate enforceability of contracts","www.doingbusiness.org/data/exploretopics/enforcing-contracts",0,"Unlikely",0,false]
[null,null,"Corruption","www.transparency.ch/de/publikationen/Les_indices_de_TI/index.php",0,"Unlikely",0,false]
[null,"Sales risks","Loss of distribution partners",null,0,"Unlikely",0,false]
[null,null,"Chang in customer requirements",null,0,"Unlikely",0,false]
[null,null,"Payment defaults","www.atradius.co.uk/creditmanagementknowledge/publications/europeanpaymentbehaviour.html",0,"Unlikely",0,false]
[null,null,"Cancellation of orders",null,0,"Unlikely",0,false]
[null,"Competition risks","Product copies","www.internationalpropertyrightsindex.org/ranking",0,"Unlikely",0,false]
[null,null,"New competitors",null,0,"Unlikely",0,false]
[null,null,"Substitution of products",null,0,"Unlikely",0,false]
[null,"Personnel risks","Legal violations",null,0,"Unlikely",0,false]
[null,null,"Head-hunting","www.doingbusiness.org/data/exploretopics/employing-workers",0,"Unlikely",0,false]
[null,null,"Blocking",null,0,"Unlikely",0,false]
[null,null,"Injury","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unlikely",0,false]
[null,null,"Disloyalty",null,0,"Unlikely",0,false]
[null,"Unlikely\n","Unrest","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unlikely",0,false]
[null,null,"Terrorism","www.eda.admin.ch/eda/de/home/travad/travel.html",0,"Unlikely",0,false]
[null,null,"Trade embargos","www.seco.admin.ch/themen/00513/00620/ ",0,"Unlikely",0,false]
[null,null,"Import restrictions",null,0,"Unlikely",0,false]
[null,null,"Nationalisation","www.heritage.org/index/heatmap",0,"Unlikely",0,false]
[null,"Natural hazards","Earthquakes","http://earthquake.usgs.gov/earthquakes/map/",0,"Unlikely",0,false]
[null,null,"Epidemics","www.who.int/research/en/",0,"Unlikely",0,false]
[null,null,"Volcanic eruptions","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=12&m=03&y=2013",0,"Unlikely",0,false]
[null,null,"Floods","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=12&m=03&y=2013",0,"Unlikely",0,false]
[null,null,"Landslides","www.emdat.be/",0,"Unlikely",0,false]
[null,null,"Storms","http://severe.worldweather.wmo.int/",0,"Unlikely",0,false]
[null,"Product risks","Malfunction",null,0,"Unlikely",0,false]
[null,null,"Liability",null,0,"Unlikely",0,false]
[null,null,"Misuse (dual-use goods)","www.efbs.admin.ch/fileadmin/efbs-dateien/transportguideline/d-SECO-Dual-use-Gueterkontrollverordnung-2008.pdf",0,"Unlikely",0,false]
[null,"Sales risks","Delays","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unlikely",0,false]
[null,null,"Transit damage",null,0,"Unlikely",0,false]
[null,null,"Loss of goods in transit",null,0,"Unlikely",0,false]
[null,null,"Incomplete deliveries",null,0,"Unlikely",0,false]
[null,null,"Customs formalities","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unlikely",0,false]
[null,null,"Incomplete documents",null,0,"Unlikely",0,false]
[null,"Other",null,null,0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[{"$nulls":4},0,"Unlikely",0,false]
[]
[null,"Scale value","Probability of occurrence in percent"]
[null,"Unlikely",{"v":0,"d":"0%"}]
[null,"Very low (10%)",{"v":0.1,"d":"10%"}]
[null,"Low (30%)",{"v":0.3,"d":"30%"}]
[null,"Medium (50%) ",{"v":0.5,"d":"50%"}]
[null,"High (70%)",{"v":0.7,"d":"70%"}]
[null,"Very high (90%)",{"v":0.9,"d":"90%"}]

{"sheet":"Neu3","index":8,"n_rows":74,"n_cols":8,"rows_kept":74,"hidden":true,"merged":[[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[12,1,19,1],[20,1,23,1],[24,1,27,1],[28,1,30,1],[31,1,35,1],[36,1,40,1],[41,1,46,1],[47,1,49,1],[50,1,55,1],[56,1,65,1]]}
[]
[]
[]
[null,"Beurteilung Exportgeschäft"]
[]
[null,"Name",null,null,"Erwarteter Exportumsatz \n(in CHF)"]
[null,"Kurzbezeichung",null,null,"Erwarteter Deckungsbeitrag \n(in CHF)"]
[null,"Produkt",null,null,"Ausserordentliche Erträge/Kosten \n(+/- in CHF)"]
[null,"Kunde",null,null,"\nTotal erwartete Gewinne (in CHF)\n",{"$f":"SUM(F7:F8)","v":{"v":0,"d":"0.00"}}]
[null,"Land",null,null,"\nTotal erwartete Verluste (in CHF)\n",{"$f":"SUM(G13:G66)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Risiko-Arten",null,"Quelle","Maximaler Verlust (in CHF)","Eintretens-wahrscheinlichkeit"," Erwarteter Verlust (in CHF)","Ws in %"]
[null,"Wirtschaftliche Risiken","Währungsverluste","www.eulerhermes-aktuell.de/de/laenderinformationen/laenderinformationen.html",0,"Unwahrscheinlich",{"$f":"E13*H13","v":0},{"$f":"IF(F13=Unwahrscheinlich,$C$69,(IF(F13=STEW,$C$70,IF(F13=TEW,$C$71,IF(F13=MEW,$C$72,IF(F13=HEW,$C$73,IF(F13=SHEW,$C$74)))))))","v":{"v":0,"d":"0%"}}]
[null,null,"Inflation","http://data.worldbank.org/indicator/NY.GDP.DEFL.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rezession","http://data.worldbank.org/indicator/NY.GDP.MKTP.KD.ZG",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Devisenknappheit",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Behinderung Devisentransfer","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung Mehrwertsteuer",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Steuererhöhungen","www.doingbusiness.org/data/exploretopics/paying-taxes",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollerhöhungen","www.wto.org/english/res_e/statis_e/statis_bis_e.htm?solution=WTO&path=/Dashboards/MAPS&file=Tariff.wcdf&bookmarkState={%22impl%22:%22client%22,%22params%22:{%22langParam%22:%22en%22}}",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Rechtliche Risiken","Veränderung Produktvorschriften",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Rechtsunsicherheit","http://worldjusticeproject.org/rule-of-law-index",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Mangelhafte Durchsetzbarkeit von Verträgen","www.doingbusiness.org/data/exploretopics/enforcing-contracts",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Korruption","www.transparency.ch/de/publikationen/Les_indices_de_TI/index.php",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Absatzrisiken","Ausfall Vertriebspartner",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Veränderung Kundenbedürfnisse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zahlungsausfälle","www.atradius.co.uk/creditmanagementknowledge/publications/europeanpaymentbehaviour.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Annulation Bestellungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Wettbewerbsrisiken","Produktkopie","www.internationalpropertyrightsindex.org/ranking",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Neue Konkurrenten",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Substitutionen Produkte",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Personalrisiken","Gesetzesverstösse",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Abwerbung","www.doingbusiness.org/data/exploretopics/employing-workers",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Blockierung",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verletzung","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Illoyalität",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Politische Risiken","Unruhen","www.controlrisks.com/Riskmap/Pages/RiskMap.aspx",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Terrorismus","www.eda.admin.ch/eda/de/home/travad/travel.html",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Handelsembargos","www.seco.admin.ch/themen/00513/00620/ ",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Importrestriktionen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Verstaatlichungen","www.heritage.org/index/heatmap",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Natürliche Risiken","Erdbeben","http://earthquake.usgs.gov/earthquakes/map/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Epidemien","www.who.int/research/en/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Vulkanausbrüche","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=12&m=03&y=2013",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Überschwemmungen","http://earthobservatory.nasa.gov/NaturalHazards/category.php?cat_id=9&m=03&y=2013",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Erdruschte","www.emdat.be/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Stürme","http://severe.worldweather.wmo.int/",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Produktrisiken","Mangelhafte Funktion",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Haftpflicht",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zweckentfremdung (Dual Use Güter)","www.efbs.admin.ch/fileadmin/efbs-dateien/transportguideline/d-SECO-Dual-use-Gueterkontrollverordnung-2008.pdf",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Vertriebsrisiken","Verzögerungen","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Transportschäden",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Warenverluste beim Transport",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Unvollständige Lieferungen",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"Zollformalitäten","www.doingbusiness.org/data/exploretopics/trading-across-borders#sub-menu-item-link",0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,null,"unvollständige Dokumente",null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[null,"Weitere",null,null,0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[{"$nulls":4},0,"Unwahrscheinlich",0,{"v":0,"d":"0%"}]
[]
[null,"Skalenwert","Eintretenswahrscheinlichkeit in Prozent"]
[null,"Unwahrscheinlich",{"v":0,"d":"0%"}]
[null,"Sehr tief (10%)",{"v":0.1,"d":"10%"}]
[null,"Tief (30%)",{"v":0.3,"d":"30%"}]
[null,"Mittel (50%)",{"v":0.5,"d":"50%"}]
[null,"Hoch (70%)",{"v":0.7,"d":"70%"}]
[null,"Sehr hoch (90%)",{"v":0.9,"d":"90%"}]