{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Preferences","Tabelle1","china","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Preferences","index":0,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Esixell preferences"]
[]
[]
[null,null,"General Preferences"]
[]
[]
[null,null,"Allow duplicate Exchanges?",null,null,null,null,0,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0= no duplicates in formal inventory"]
[null,null,null,null,null,null,null,"1= duplicate exchanges allowed in formal inventory"]
[]
[]
[null,null,"Keep helper Combi-names after parsing?",null,null,null,null,1,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0 = delete helper combinames in sheets"]
[null,null,null,null,null,null,null,"1 = keep combinames in all sheets"]
[]
[]
[]
[]
[]
[null,null,"Excel to XML file conversion (XL —> ML)"]
[]
[]
[null,null,"Round mean values and GSD to number of significant digits",null,null,null,null,8]
[null,null,null,null,null,null,null,"0 = no rounding, i.e. 123456.789123456 is recorded as such"]
[null,null,null,null,null,null,null,"e.g 5 = rounding to five digits, i.e. 123460 is recorded, rounding <5 is not recommended."]
[]
[]
[null,null,"Split multiple datasets in start Excel into individual XML files?",null,null,null,null,0,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0 = create a single new XML file with multiple datasets"]
[null,null,null,null,null,null,null,"1 = create several new XML files for multiple datasets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XML to Excel file conversion  (ML —> XL)"]
[]
[]
[]
[null,null,"Split multiple datasets in XML into individual Excel workbooks?",null,null,null,null,1,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0 = create one new workbook for multiple datasets"]
[null,null,null,null,null,null,null,"1 = create several new workbooks for multiple datasets"]
[]
[]
[null,null,"Close created workbooks after parsing?",null,null,null,null,0,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0 = keep all created workbooks open"]
[null,null,null,null,null,null,null,"1 = close finished workbooks"]
[]
[]
[null,null,"Sort parsed exchanges list?",null,null,null,null,0,"0/1 = No/Yes"]
[null,null,null,null,null,null,null,"0 = keep exchange list in order of XML sequence"]
[null,null,null,null,null,null,null,"1 = sort exchanges list into bio//tech"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Copyleft © 2002-2022 Gabor Doka, <ecoinvent {at} doka {dot} ch>. "]
[null,null,"Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)  "]
[null,null,"https://creativecommons.org/licenses/by-sa/4.0/"]
[null,null,"You are free to:"]
[null,null,"    Share                 — copy and redistribute the material in any medium or format"]
[null,null,"    Adapt                 — remix, transform, and build upon the material"]
[null,null,"Under the following terms:"]
[null,null,"    Attribution  — You must give appropriate credit, provide a link to the license, and indicate if changes were made. "]
[null,null,"                           You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use."]
[null,null,"    ShareAlike  — If you remix, transform, or build upon the material, you must distribute your contributions under the "]
[null,null,"                          same license as the original."]
[null,null,"    No additional restrictions — You may not apply legal terms or technological measures that legally restrict others "]
[null,null,"                                                from doing anything the license permits."]
[null,null,"The software tool have been developed by Gabor Doka, funded by Swiss Federal Office for the Environment (FOEN) the Swiss EPA."]
[null,null,"The Excel workbooks and VBA code are provided free of charge to anybody and must be shared-alike. "]
[null,null,"The Excel workbooks and VBA code or derivatives may not be sold or offered for sale, or included with software products offered for sale. "]
[null,null,"If you paid money to obtain these software tools, somebody has profited illegally from content provided freely. "]
[null,null,"Companies that distribute software for profit are expressly prohibited from distributing these tools. "]
[null,null,"The Excel workbooks and VBA code come with absolutely no warranty. "]
[null,null,"These are free workbooks, and you are welcome to redistribute them under the Creative Commons Attribution-ShareAlike conditions. "]
[null,null,"You can *use* the tools to work on confidential and/or commercial LCA inventory datasets. "]
[null,null,"But the tools themselves must remain free and open."]

{"sheet":"Tabelle1","index":1,"n_rows":77,"n_cols":46,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"from \"NF3_ecospold_0.7-ecoinvent.xlsx\"",null,"Type","ID","Field name, IndexNumber","type of content",null,null,"Type","ID","Field name","type of content",null,null,"Type","ID","Field name","type of content",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"from MSWI 2013 FLUWA.xls","Type","ID","Field name, IndexNumber","for MSWI",null,"comment"]
[null,null,null,null,null,null,null,"ReferenceFunction",401,"Name","text",null,null,"Sources",801,"Number","integer",null,null,"Persons",5800,"Number","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",401,"Name","disposal, wood ash mixture, pure, 0% water, to municipal incineration, with filter ash extraction","disposal, liginite ash from stove, 0% water, to municipal incineration",97,"Old name used here, ES1 name is \"disposal, [waste name], to municipal incineration\". ES2 name is \"treatment of [waste name], municipal incineration\""]
[null,null,null,null,null,null,null,"Geography",662,"Location","text",null,null,"Sources",802,"SourceType","integer",null,null,"Persons",5802,"Name","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geography",662,"Location","CH",false]
[null,null,null,null,null,null,null,"ReferenceFunction",493,"InfrastructureProcess","0  /1",null,null,"Sources",803,"Text","text",null,null,"Persons",5803,"Address","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",493,"InfrastructureProcess ",0,null,"no"]
[null,null,null,null,null,null,null,"ReferenceFunction",403,"Unit","text",null,null,"Sources",1002,"FirstAuthor","text",null,null,"Persons",5804,"Telephone","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",403,"Unit","kg"]
[null,null,null,null,null,null,null,"DataSetInformation",201,"Type","integer",null,null,"Sources",1003,"AdditionalAuthors","text",null,null,"Persons",5805,"Telefax","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataSetInformation",201,"Type",1,null,"Ecospold1 had only values 0-4 (0=System non-terminated. 1=Unit process. 2=System terminated. 3=Elementary Flow. 4=Impact Category)\nFor Ecospold2, 5 apprently needs to be set for multi-functional DS.    "]
[null,null,null,null,null,null,null,null,202,"Version","nr",null,null,"Sources",1004,"Year","integer (4 digit)",null,null,"Persons",5806,"Email","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataSetInformation",202,"Version",1]
[null,null,null,null,null,null,null,null,203,"energyValues","integer","not actively used",null,"Sources",1005,"Title","text",null,null,"Persons",5807,"CompanyCode ","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataSetInformation",203,"energyValues",0,null,"undefined"]
[null,null,null,null,null,null,null,null,205,"LanguageCode","text (en)",null,null,null,1006,"PageNumbers","text",null,null,"Persons",5808,"CountryCode","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataSetInformation",205,"LanguageCode","en"]
[null,null,null,null,null,null,null,null,206,"LocalLanguageCode","text (de)",null,null,"Sources",1007,"NameOfEditors","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataSetInformation",206,"LocalLanguageCode","de"]
[null,null,null,null,null,null,null,"DataEntryBy",302,"Person","integer",null,null,"Sources",1008,"TitleOfAnthology","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataEntryBy",302,"Person",46,null,"11=Roland Hischier, 46 = Gabor Doka"]
[null,null,null,null,null,null,null,null,304,"QualityNetwork","text",null,null,"Sources",1009,"PlaceOfPublication","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataEntryBy",304,"QualityNetwork",1,null,"1=EcoInvent"]
[null,null,null,null,null,null,null,"ReferenceFunction",400,"DataSetRelatesToProduct","0  /1","always 1 for UPR-LCIs",null,"Sources",1010,"Publisher","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",400,"DataSetRelatesToProduct",1]
[null,null,null,null,null,null,null,null,402,"IncludedProcesses","text",null,null,"Sources",1011,"Journal","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",402,"IncludedProcesses","Waste incineration from waste reception gate further downstream (excluding transport to the MSWI plant). Waste-specific air and water emisions from incineration, auxiliary material consumption for flue gas cleaning. Short-term emissions to river water and long-term emisisons to ground water from slag compartment (from bottom ash) and residual material landfill (from solidified fly ashes and scrubber slugde). Waste-specific process energy demands for MSWI and net energy generation.",null,"Was ist alles an technischen Prozessen mit drin, welche Kategorien von Inputs/Outputs sind berücksichtigt (z.B. Transporte der Rohstoffe, Flue gas treatment facility), welche sind NICHT enthalten (z.B. auf Grund fehlender Daten). ### Die Beschreibung der spezifisch eingesetzten Technik erfolgt dann im Feld 'Technlogy'. ### "]
[null,null,null,null,null,null,null,null,404,"Amount","nr (should aways be 1)",null,null,"Sources",1012,"VolumeNo","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",404,"Amount",1]
[null,null,null,null,null,null,null,null,490,"LocalName","text",null,null,"Sources",1013,"IssueNo","text","in ES1 def this is defined as 'String'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",490,"LocalName","Entsorgung, Holzasche gemischt, rein, 0% Wasser, in Kehrichtverbrennung",null,71,"Old name used here for ES1"]
[null,null,null,null,null,null,null,null,491,"Synonyms","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",491,"Synonyms","",null,"Synonyme in Deutsch UND Englisch, je 80 Zeichen pro Synonym, Abkürzungen auch hier aufführen (z.B. MSWI). Trennung durch \"//\". ### ","MO text ei2k (ES1)"]
[null,null,null,null,null,null,null,null,492,"GeneralComment","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",492,"GeneralComment","This dataset represents the activity of waste disposal of wood ash mixture, pure in a municipal solid waste incinerator (MSWI)\nRecommended use of this dataset: For small amounts of wood ash from small scale furnaces, which go to disposal as part of communal waste mixture. Larger amounts will be landfilled or as fertilizer on suitable ground.\n\nWaste composition (wet, in ppm): H2O n.a.; O 445010; H n.a.; C 12000; S 9200; N n.a.; P 9800; B n.a.; Cl 3200; Br n.a.; F n.a.; I n.a.; Ag n.a.; As 6.7; Ba n.a.; Cd 14.2; Co 18; Cr 194.9; Cu 163.2; Hg 0.1; Mn 19956; Mo 3.7; Ni 55.2; Pb 65; Sb n.a.; Se n.a.; Sn n.a.; V 39.5; Zn 1662; Be n.a.; Sc n.a.; Sr n.a.; Ti 1383; Tl n.a.; W n.a.; Si 82600; Fe 22833; Ca 284400; Al 20800; K 54500; Mg 32100; Na n.a.; \nShare of carbon in waste that is biogenic 100%.\nShare of metals in waste not oxidised and bulk-recyclable (exclude very small or thin parts) Iron: 0%; Alu: 0%; Copper: 0%.\nRecovery of metal scrap from bottom ash to recycling: 0g iron scrap, 0g aluminium scrap, 0g copper scrap.Ultimately one kg of this waste produces 1.085 kg of bottom ash (can include some washed ash) and 0 kg of residues, which are landfilled (technology mix). Net energy production: 0MJ/kg electric energy and 0MJ/kg thermal energy. \n",null,"Bei Multioutput-Prozessen den folgenden Satz eintragen: ### The multioutput-process 'english name des MO-Prozesses (#401: NAME)' delivers the co-products 'english name des allocatedByProducts 1 (#401: NAME)', 'english name des allocatedByProducts 2 (#401: NAME)', ..., and 'english name des allocatedByProducts n (#401: NAME)'. ### Das verwendete Allokationsverfahren und den verwendeten Allokationsparameter  (falls nicht zu umfangreich) angeben. ### Bei Infrastruktur-Datensätzen Angaben machen zu Kapazität (Jahresproduktion), Auslastung und Lebensdauer. ### ","The multioutput-process 'treatment of wood ash mixture, pure, municipal incineration' delivers the co-products '[treatment of] wood ash mixture, pure (disposal function) and the energy products 'electricity, medium voltage' and 'heat, district or industrial, other than natural gas' (net energy production: 0MJ/kg electric energy and 0MJ/kg thermal energy). Allocation with economical key.\n"]
[null,null,null,null,null,null,null,null,494,"InfrastructureIncluded","0  /1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",494,"InfrastructureIncluded ",null,null,"empty for detailed LCI, nonempty for cumulated LCI data"]
[null,null,null,null,null,null,null,null,495,"Category","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",495,"Category","waste management",null,"L"]
[null,null,null,null,null,null,null,null,496,"SubCategory","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",496,"SubCategory","municipal incineration",null,"M"]
[null,null,null,null,null,null,null,null,497,"LocalCategory","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",497,"LocalCategory","Entsorgungssysteme",null,"H"]
[null,null,null,null,null,null,null,null,498,"LocalSubCategory","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",498,"LocalSubCategory","Kehrichtverbrennung",null,"I"]
[null,null,null,null,null,null,null,null,499,"Formula","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",499,"Formula","",null,"nur REINE chemische Formeln eingeben (keine Werkstoffbezeichnungen wie AlMg3) ### "]
[null,null,null,null,null,null,null,null,501,"StatisticalClassification","text","should be NACE code (Nomenclature of Economic Activities). not really used in ecoinvent. ESUS IO uses SITC (Standard International Trade Classification)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",501,"StatisticalClassification"]
[null,null,null,null,null,null,null,null,502,"CASNumber","text (\"0007845-45-9\")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReferenceFunction",502,"CASNumber","",null,"R"]
[null,null,null,null,null,null,null,"TimePeriod",601,"StartDate","text yyyy-mm-dd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimePeriod",601,"StartDate","2006-01",null,"Bei der Angabe von StartDate das Alter der Informationen mit einbeziehen. EndDate soll sich auf die aktuellst verwendeten Daten beziehen. ### bei zeit- und technikunabhängigen Prozessen (z.B. Holzwachstum im Wald, die damit verbundenen Energie- und Stoffflüsse dürften immer etwa gleich sein) aktuellstmögliche Jahreszahlen eintragen (d.h. 2002). Sobald jedoch Maschinen, aktive (Wald-)Pflege, Saatgut, etc. eingesetzt werden, soll hier das aktuellste Datum der verwendeten Quelle (Literatur, etc.) eintragen werden. ### Monate werden nicht unbedingt benötigt (StartDate 2000 heisst 2000-01-01; EndDate 2000 heisst 2000-12-31). ### "]
[null,null,null,null,null,null,null,null,602,"EndDate","text yyyy-mm-dd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimePeriod",602,"EndDate","2012-12"]
[null,null,null,null,null,null,null,null,603,"DataValidForEntirePeriod","0  /1","(tooltip is wrong, this is a boolean 0/1, not 1/2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimePeriod",603,"DataValidForEntirePeriod",1,null,"Das Yes (= 1) grosszügig einsetzen. Die '0' v.a. dann verwenden, wenn die Daten z.B. nur für das Sommerhalbjahr gültig sind und nicht für das ganze Jahr. ### "]
[null,null,null,null,null,null,null,null,611,"OtherPeriodText","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TimePeriod",611,"OtherPeriodText","Waste composition as given in literature reference, theoretical data or other source. Transfer coefficients for modern MSWI. ",null,"entweder spezifizieren, welche Daten aus welcher Zeit stammen (falls Spannbreite StartDate - EndDate gross) oder hier Ausnahmen angeben, die über die angegebene Spannbreite hinausgehen. ### "]
[null,null,null,null,null,null,null,"Geography",663,"Text","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geography",663,"Text","Specific to the technology mix encountered in Switzerland in 2012.",null,"soll enthalten: ### Hinweise auf Bezüge von Proxy-Datensätzen mit einem anderen RegionalCode (z.B. Phosphor, ab Fabrik/kg/USA/false bezieht Strom, ab Mittelspannung/kWh/UCTE/false) ### Hinweise, wenn von einem oder einer beschränkten Anzahl von Länderdaten auf einen Kontinentsdurchschnitt extrapoliert wurde (Daten von Produktionsanlagen DE und FR verwendet für Datensatz RER). ### Falls möglich: Hinweise auf die Verwendbarkeit für andere Wirtschaftsräume (Datensatz RER anwendbar für Nordamerika und/oder Japan). ### "]
[null,null,null,null,null,null,null,"Technology",692,"Text","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technology",692,"Text","average Swiss MSWI plants in 2010 (grate incinerators) with electrostatic precipitator for fly ash (ESP), wet flue gas scrubber and 25%  SNCR , 42.77%  SCR-high dust , 32.68%  SCR-low dust -DeNOx facilities and 0% without Denox  (weighted according to mass of burnt waste, representing Swiss average). Efficiency of iron scrap separation from slag : 58%. Efficiency of non-ferrous scrap separation from slag : 31%. The technology mix for this dataset includes a filter ash treatment (FLUWA) of a share of 46.22%. Gross electric efficiency technology mix 15.84% and Gross thermal efficiency technology mix 28.51% ",null,"Hier Detailinformationen zur Technik eines Prozesses eintragen (so verfügbar und anwendbar). ### Bei Infrastruktur-Datensätzen: Beschreiben der Technik der Infrastruktur und nicht nur der Herstellungsweise der Infrastruktur (Beispiel Öl-Heizkessel: Beschreiben der Technik des Heizkessels und nicht nur der Technik, wie der Heizkessel hergestellt wird; Beispiel Sonnenkollektor: \"wie wurde die Beschichtung für den Sonnenkollektor gemacht\" und nicht nur \"Der Kollektor hat eine selektive Beschichtung\".) ### Alle Infos \"included are ...\" im Feld \"IncludedProcesses' unterbringen. ### "]
[null,null,null,null,null,null,null,"Representativeness",722,"Percent","nr (0-100)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representativeness",722,"Percent",null,null,"bezieht sich auf das unter 'ProductionVolume' Angegebene. Falls nicht bekannt: NICHTS eingeben (NICHT eine '0' eingeben). ### "]
[null,null,null,null,null,null,null,null,724,"ProductionVolume","text!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representativeness",724,"ProductionVolume",null,null,"Hier geographischen Raum und Jahr angeben, für welches das jährliche Produktionsvolumen gültig ist. ### "]
[null,null,null,null,null,null,null,null,725,"SamplingProcedure","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representativeness",725,"SamplingProcedure","fully waste-specific calculation based on literature data for average MSWI operation performance",null,"welche Art Quelle wurde benutzt? (Literatur, Umweltberichte, Fragebogen, Messungen). Falls bekannt, wie wurden Messungen durchgeführt (kontinuierlich, Punktmessungen). ### "]
[null,null,null,null,null,null,null,null,726,"Extrapolations","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representativeness",726,"Extrapolations","Typical elemental transfer coefficients from current studies for modern MSWI, completed with data from coal power plants and estimates, adapted for inert/burnable waste.",null,"Hier entweder 'none' oder verweisen auf andere Felder. ### 'see Geography/Text', 'see Technology/Text', 'see OtherPeriodText'. [Bem.: Feld-Ids werden nicht angezeigt] ### "]
[null,null,null,null,null,null,null,null,727,"UncertaintyAdjustments","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representativeness",727,"UncertaintyAdjustments","uncertainty of waste input composition data derived from generic formula GSD(c) = N*ln(c)+1",null,"wenn keine, dann 'none' eintragen ### "]
[null,null,null,null,null,null,null,"DataGeneratorAndPublication",751,"Person","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",751,"Person",46,null,"Gabor Doka"]
[null,null,null,null,null,null,null,null,756,"DataPublishedIn","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",756,"DataPublishedIn",2,null,"2= Data has been published entirely in (refers to field 757) (default)"]
[null,null,null,null,null,null,null,null,757,"ReferenceToPublishedSource","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",757,"ReferenceToPublishedSource",314,null,"13 = Life Cycle Inventories of Waste Treatment Services, 313 = 2013 MSWI update, 314= 2015 MSWI update"]
[null,null,null,null,null,null,null,null,758,"Copyright","0  /1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",758,"Copyright",1]
[null,null,null,null,null,null,null,null,759,"AccessRestrictedTo","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",759,"AccessRestrictedTo",0,null,"0 = public"]
[null,null,null,null,null,null,null,null,760,"CompanyCode","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",760,"CompanyCode",null,null,"only if Institute restricted acces in #759 (=3) (760 is allerdings in names verwendet)"]
[null,null,null,null,null,null,null,null,761,"CountryCode","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",761,"CountryCode",null,null,"only if Institute restricted acces in #759 (=3)"]
[null,null,null,null,null,null,null,null,762,"PageNumbers","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DataGeneratorAndPublication",762,"PageNumbers"]
[null,null,null,null,null,null,null,"ProofReading",5616,"proofReadingDetails","integer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ProofReading",5616,"Validator",511,null,"11 =Roland Hischier, 511 = Ivan Munoz"]
[null,null,null,null,null,null,null,null,5615,"proofReadingValidator","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ProofReading",5615,"Details","Passed.",null,"Mireille wünscht sich hier \"Passed\" (mail  18.Jul 2011)"]
[null,null,null,null,null,null,null,null,5619,"otherDetails","text",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ProofReading",5619,"OtherDetails"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOP","stop parsing, as field is insufficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 = false","some translation required, record warning",null,null,null,null,null,null,null,null,null,"Allocation",2401,"referenceToCoProduct","output-product processes: '[treatment of] wood ash mixture, pure (disposal function) and the energy products 'electricity, medium voltage' and 'heat, district or industrial, other than natural gas' ",null,"Indicates the co-product output for which a particular allocation factor is valid. Additional information is required about the exchange on which the allocation factor is applied (see 'referenceToInputOutput').MultipleOccurences=Yes is only valid, if referenceFunction describes a multioutput process.Liste enth‰lt die Eintr‰ge der Kombination #3501=2 (FromSystem), #3504=2 (Allocated by-product) aus Exchanges, zus‰tzlich Edit Feld Nur Lesen zur Klartextanzeige des FlussesEintr‰ge in Allocations nur dann, wenn in Exchanges Eintr‰ge mit #3504=2 vorhanden sind!","not used anymore in Ecospold 2"]
[null,null,null,null,null,"for XL => ML, recognizing empty cells, (e.g I dont want any useless journal=\"0\" attributes etc. OR <OutputGroup>-</OutputGroup>)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"none","tag or attribute is skipped entirely",null,null,null,null,null,null,null,null,null,"Allocation",2403,"allocationMethod",1,null,"Indicates the kind of allocation parameter chosen. The codes are: -1[minus 1]=Undefined (default). 0=Physical causality. 1=Economic causality. 2=Other method. 'Other method' comprises in particular physical parameters (like mass, energy, exergy, etc.) and parameters other than economic.MultipleOccurences=Yes only valid, if referenceFunction describes a multioutput process.-1=Undefined (default)0=Physical causality1=Economic causality2=Other method","to be placed in X-Exchange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see VBA 'CellEmptyQuest",null,null,null,null,null,null,null,null,null,null,"√","field can be written",null,null,null,null,null,null,null,null,null,"Allocation",2407,"explanations","monetary net revenue of disposal fees and sold net energy production (if any)",null,"Contains further information about the allocation procedure and the allocation parameter chosen. An eventual coincidence in allocation factors when comparing different allocation parameters (like physical and economic ones) may be reported here as well.","to be placed in X-Exchange"]
[null,null,null,null,null,null,"\"Empty\" cells",null,null,null,null,null,null,null,null,null,null,"case 1","case 2","case 3"]
[null,null,null,null,null,null,null,"ansi code","WERT","string & \"\"","ANSI of taht","value of taht","string länge","istleer","istzahl","ist text","isktext","via VBA: val(cell.value)","VBA ce.Value = \"0\"","VBA ce.Value = \"\"",null,"desirable decision for journal or synonym attribute (i.e. text entries)","desirable decision for <OutputGroup> tag (i.e. number entries)","reproducing decision for journal or synonym text","reproducing decision for <OutputGroup> tag","function for for journal or synonym text","function for <OutputGroup> tag",null,"decision numbers with 0","decision numbers with 0","decision numbers w/o 0","decision numbers w/o 0","decision boolean","decision boolean","decision text","decision text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"requried","facult","requried","facult","requried","facult","requried","facult"]
[null,null,null,null,null,"untouched cell",null,{"$f":"CODE(G58)","v":{"$error":"#VALUE!"}},{"$f":"VALUE(G58)","v":0},{"$f":"G58&\"\"","v":""},{"$f":"CODE(J58)","v":{"$error":"#VALUE!"}},{"$f":"VALUE(J58)","v":{"$error":"#VALUE!"}},{"$f":"LEN(G58)","v":0},{"$f":"ISBLANK(G58)","v":true},{"$f":"ISNUMBER(G58)","v":false},{"$f":"ISTEXT($G58)","v":false},{"$f":"ISNONTEXT($G58)","v":true},0,0,0,null," no entry"," no entry",{"$f":"AND(P58,NOT(O58),M58>1)","v":false},{"$f":"AND(O58,Q58)","v":false},{"$f":"IsXMLText($G58)","v":false},{"$f":"IsXMLNumber($G58)","v":false},{"$f":"F58","v":"untouched cell"},"STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"space"," ",32,{"$error":"#VALUE!"}," ",32,{"$error":"#VALUE!"},1,false,false,true,false,0,"not zero","not zero",null," no entry"," no entry",{"$f":"AND(P59,NOT(O59),M59>1)","v":false},false,false,{"$f":"IsXMLNumber(G59)","v":false},"space","STOP","none","STOP","none","STOP","none","STOP","none","with TRIM() this can be converted to \"\""]
[null,null,null,null,null,"2 spaces","  ",32,{"$error":"#VALUE!"},"  ",32,{"$error":"#VALUE!"},2,false,false,true,false,0,"not zero","not zero",null," no entry"," no entry",true,false,false,false,"2 spaces","STOP","none","STOP","none","STOP","none","STOP","none","with TRIM() this can be converted to \"\""]
[null,null,null,null,null,"zero",0,48,0,"0",48,0,1,false,true,false,true,0,0,"not zero",null," no entry","make entry",false,true,false,true,"zero","√","√","STOP","none","0 = false","0 = false","STOP","none"]
[null,null,null,null,null,"one",1,49,{"$f":"VALUE(G62)","v":1},{"$f":"G62&\"\"","v":"1"},49,{"$f":"VALUE(J62)","v":1},{"$f":"LEN(G62)","v":1},{"$f":"ISBLANK(G62)","v":false},{"$f":"ISNUMBER(G62)","v":true},false,true,0,0,"not zero",null," no entry","make entry",{"$f":"AND(P62,NOT(O62),M62>1)","v":false},true,false,true,"one","√","√","√","√","1= true","1= true","STOP","none"]
[null,null,null,null,null," =\"\" empty string",{"$f":"\"\"","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,false,false,true,false,0,"not zero",0,null," no entry"," no entry",false,false,false,false," =\"\" empty string","STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"dash (minus)","-",45,{"$error":"#VALUE!"},"-",45,{"$error":"#VALUE!"},1,false,false,true,false,0,"not zero","not zero",null," no entry"," no entry",false,false,false,false,"dash (minus)","STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"endash","–",208,{"$error":"#VALUE!"},"–",208,{"$error":"#VALUE!"},1,false,false,true,false,0,"not zero","not zero",null," no entry"," no entry",false,false,false,false,"endash","STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"dash from zero via number format [=0]\"-\",0.00",0,{"$f":"CODE(G66)","v":48},0,"0",48,0,1,false,true,false,true,0,0,"not zero",null," no entry","make entry",false,true,false,true,"dash from zero via number format [=0]\"-\",0.00","STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"\"\" from zero via number format [=0]\"\",0.00",0,48,{"$f":"VALUE(G67)","v":0},{"$f":"G67&\"\"","v":"0"},48,0,{"$f":"LEN(G67)","v":1},false,{"$f":"ISNUMBER(G67)","v":true},false,true,0,0,"not zero",null," no entry","make entry",false,true,false,true,"\"\" from zero via number format [=0]\"\",0.00","STOP","none","STOP","none","STOP","none","STOP","none"]
[null,null,null,null,null,"text \"true\"","true",116,{"$error":"#VALUE!"},"true",116,{"$f":"VALUE(J68)","v":{"$error":"#VALUE!"}},4,false,false,true,false,null,null,null,null,"make entry"," no entry",true,false,true,false,"text \"true\"","STOP","ignore","STOP","ignore","√","√","STOP","warning short text"]
[null,null,null,null,null,"text \"false\"","false",102,{"$error":"#VALUE!"},"false",102,{"$f":"VALUE(J69)","v":{"$error":"#VALUE!"}},5,false,false,true,false,null,null,null,null,"make entry"," no entry",true,false,{"$f":"IsXMLText($G69)","v":true},{"$f":"IsXMLNumber(G69)","v":false},"text \"false\"","STOP","ignore","STOP","ignore","√","√","STOP","warning short text"]
[null,null,null,null,null,"boolen false",false,70,{"$error":"#VALUE!"},"FALSCH",{"$f":"CODE(J70)","v":70},{"$f":"VALUE(J70)","v":{"$error":"#VALUE!"}},6,{"$f":"ISBLANK(G70)","v":false},{"$f":"ISNUMBER(G70)","v":false},{"$f":"ISTEXT($G70)","v":false},{"$f":"ISNONTEXT($G70)","v":true},null,null,null,null,"make entry"," no entry",{"$f":"AND(P70,NOT(O70),M70>1)","v":false},{"$f":"AND(O70,Q70)","v":false},{"$f":"IsXMLText($G70)","v":true},{"$f":"IsXMLNumber(G70)","v":false},{"$f":"F70","v":"boolen false"},"STOP","ignore","STOP","ignore","√","√","STOP","warning short text"]
[null,null,null,null,null,"boolen true",true,87,{"$error":"#VALUE!"},"WAHR",{"$f":"CODE(J71)","v":87},{"$f":"VALUE(J71)","v":{"$error":"#VALUE!"}},4,{"$f":"ISBLANK(G71)","v":false},{"$f":"ISNUMBER(G71)","v":false},{"$f":"ISTEXT($G71)","v":false},{"$f":"ISNONTEXT($G71)","v":true},null,null,null,null," no entry"," no entry",{"$f":"AND(P71,NOT(O71),M71>1)","v":false},{"$f":"AND(O71,Q71)","v":false},{"$f":"IsXMLText($G71)","v":true},{"$f":"IsXMLNumber(G71)","v":false},{"$f":"F71","v":"boolen true"},"STOP","ignore","STOP","ignore","√","√","STOP","warning short text"]
[null,null,null,null,null,"erro value",{"$f":"NA()","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CODE(J72)","v":{"$error":"#N/A"}},{"$f":"VALUE(J72)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"ISBLANK(G72)","v":false},{"$f":"ISNUMBER(G72)","v":false},{"$f":"ISTEXT($G72)","v":false},{"$f":"ISNONTEXT($G72)","v":true},null,null,null,null," no entry"," no entry",{"$f":"AND(P72,NOT(O72),M72>1)","v":{"$error":"#N/A"}},{"$f":"AND(O72,Q72)","v":false},"error",{"$f":"IsXMLNumber(G72)","v":false},{"$f":"F72","v":"erro value"},"STOP","warning short text","STOP","warning short text","STOP","warning short text","STOP","warning short text"]
[null,null,null,null,null,"nonempty text","MIT",77,{"$error":"#VALUE!"},"MIT",77,{"$error":"#VALUE!"},3,false,false,true,false,0,"not zero","not zero",null," no entry"," no entry",true,false,{"$f":"IsXMLText($G73)","v":true},{"$f":"IsXMLNumber(G73)","v":false},"nonempty text","STOP","ignore","STOP","ignore","STOP","ignore","√","√"]
[null,null,null,null,null,"nonempty number",4,52,4,"4",52,4,1,false,true,false,true,4,"not zero","not zero",null," no entry","make entry",false,true,false,true,"nonempty number","√","√","√","√","STOP","none","STOP","warning short text"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"this works fine for all",null,null,null,null,null,null,"is a number AND is no text (disregards untouched cells)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"the blue cell is also 0, but formatted to a dash"]

{"sheet":"china","index":2,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Problem"]
[null,"reading a text file into Excel VBA can not handle all special characters properly"]
[null,"In part this can be remedied by a search/replace routing (e.g replacing \"√§\" with \"ä\")"]
[null,"In the geographies file the chinese provinces are listed with their chinese names, e.g. \"China, Anhui (安徽)\""]
[null,"Reading such a text file with Excel VBA misreads the chinese cahracters"]
[null,"Each Chinese character is displayed as *three* ANSI/ASCII characters (E.g. \"北\" is \"ÂÆâ\")"]
[null,"These mismatches cannot be replaced with a VBA search/replace routine, as with the two-letter special characters"]
[null,"because the VBA code text does not hold the correct chinese characters properly (will be converted to e.g.         Or __ )"]
[null,"Solution"]
[null,"It is however possible within VBA to define a search/replace routine based on a *cell's contents*"]
[null,"and this reproduces also chinese characters in the replaced cell content correctly"]
[null,"So for geograhpies a special replace routine is run which replaces cell's miscoded content with the correct content"]
[null,"based on the list of wrong and correct Unicode strings listed below"]
[null,"the table can be expanded without leaving blank lines"]
[null,"The VBA routine however is presently (Dec 2018) only called when a Geography name file is parsed."]
[]
["province","wrong chinese","short geo code","UUID",null,null,null,"correct chinese",null,"full text in MasterData"]
[null,null,null,null,null,null,null,"族自治 even if signs are not displayed correctly in Excel cells (this also depends on fonts installed in your system), they still do retain different meaning"]
["info only","cell below marks beginning of list of wrong strings","info only","info only",null,null,null,"cell below marks beginning of list of correct strings",null,"info only",null,"info only"]
["China, Anhui ","ÂÆâÂæΩ","CN-AH","2f82cf2a-d2e0-4be3-b60c-399bfe93d403",null,null,"China, Anhui ","安徽",null,"China, Anhui (ÂÆâÂæΩ)",null,"China, Anhui (安徽)"]
["China, Beijing ","Âåó‰∫¨","CN-BJ","a7cf4239-43f5-4256-ae84-e94595cbaac6",null,null,"China, Beijing ","北京",null,"China, Beijing (Âåó‰∫¨)",null,"China, Beijing (北京)"]
["China, Chongqing ","ÈáçÂ∫Ü","CN-CQ","8bc809e8-f246-46f7-bf1f-93e34e06befd",null,null,"China, Chongqing ","重庆",null,"China, Chongqing (ÈáçÂ∫Ü)",null,"China, Chongqing (重庆)"]
["China, Fujian ","Á¶èÂª∫","CN-FJ","7ac3c1e7-0b7d-4ff9-9aa5-0d67d7da37fa",null,null,"China, Fujian ","福建",null,"China, Fujian (Á¶èÂª∫)",null,"China, Fujian (福建)"]
["China, Gansu ","ÁîòËÇÉ","CN-GS","d5231e2f-479b-4f21-9173-35beeaf2406a",null,null,"China, Gansu ","甘肃",null,"China, Gansu (ÁîòËÇÉ)",null,"China, Gansu (甘肃)"]
["China, Guangdong ","Âπø‰∏ú","CN-GD","fbfd6cb0-56b1-4d0b-a13f-7f9f213f9afa",null,null,"China, Guangdong ","广东",null,"China, Guangdong (Âπø‰∏ú)",null,"China, Guangdong (广东)"]
["China, Guangxi ","ÂπøË•øÂ£ÆÊóèËá™Ê≤ªÂå∫","CN-GX","c6b0afc2-8321-49aa-81f3-a793417eed91",null,null,"China, Guangxi ","广西壮族自治区",null,"China, Guangxi (ÂπøË•øÂ£ÆÊóèËá™Ê≤ªÂå∫)",null,"China, Guangxi (广西壮族自治区)"]
["China, Guizhou ","Ë¥µÂ∑û","CN-GZ","4a743c1d-f819-4398-b389-784b84de386e",null,null,"China, Guizhou ","贵州",null,"China, Guizhou (Ë¥µÂ∑û)",null,"China, Guizhou (贵州)"]
["China, Hainan ","Êµ∑Âçó","CN-HA","dd10b4f5-3c51-4c62-9b32-a111e15e3e52",null,null,"China, Hainan ","海南",null,"China, Hainan (Êµ∑Âçó)",null,"China, Hainan (海南)"]
["China, Hebei ","Ê≤≥Âåó","CN-HB","06bbed25-6ebe-48aa-9b92-300bddaeb2b7",null,null,"China, Hebei ","河北",null,"China, Hebei (Ê≤≥Âåó)",null,"China, Hebei (河北)"]
["China, Heilongjiang ","ÈªëÈæôÊ±üÁúÅ","CN-HL","0f7b1e31-0d0b-404a-994b-e3cd1b7586f0",null,null,"China, Heilongjiang ","黑龙江省",null,"China, Heilongjiang (ÈªëÈæôÊ±üÁúÅ)",null,"China, Heilongjiang (黑龙江省)"]
["China, Henan ","Ê≤≥Âçó","CN-HE","bf7827a3-16a7-4a38-ad02-527898a12a7f",null,null,"China, Henan ","河南",null,"China, Henan (Ê≤≥Âçó)",null,"China, Henan (河南)"]
["China, Hubei ","ÊπñÂåó","CN-HU","2a19941e-dd11-44b4-919f-fb33c9150b71",null,null,"China, Hubei ","湖北",null,"China, Hubei (ÊπñÂåó)",null,"China, Hubei (湖北)"]
["China, Hunan ","ÊπñÂçó","CN-HN","9923dac7-3164-4e2f-8723-f343d998072d",null,null,"China, Hunan ","湖南",null,"China, Hunan (ÊπñÂçó)",null,"China, Hunan (湖南)"]
["China, Inner Mongol ","ÂÜÖËíôÂè§Ëá™Ê≤ªÂå∫","CN-NM","da5d7825-8e05-4bad-b026-4204389cdef3",null,null,"China, Inner Mongol ","内蒙古自治区",null,"China, Inner Mongol (ÂÜÖËíôÂè§Ëá™Ê≤ªÂå∫)",null,"China, Inner Mongol (内蒙古自治区)"]
["China, Jiangsu ","Ê±üËãè","CN-JS","dc5987d0-7a19-4843-82f1-15708e106edb",null,null,"China, Jiangsu ","江苏",null,"China, Jiangsu (Ê±üËãè)",null,"China, Jiangsu (江苏)"]
["China, Jiangxi ","Ê±üË•ø","CN-JX","f5c62675-f6ae-4bc4-8c9b-3b737ef2ea53",null,null,"China, Jiangxi ","江西",null,"China, Jiangxi (Ê±üË•ø)",null,"China, Jiangxi (江西)"]
["China, Jilin ","ÂêâÊûó","CN-JL","e58a4a8a-ca18-48d8-9023-3628de160e8e",null,null,"China, Jilin ","吉林",null,"China, Jilin (ÂêâÊûó)",null,"China, Jilin (吉林)"]
["China, Liaoning ","ËæΩÂÆÅ","CN-LN","13b215dc-598a-480e-98e6-13675076ac78",null,null,"China, Liaoning ","辽宁",null,"China, Liaoning (ËæΩÂÆÅ)",null,"China, Liaoning (辽宁)"]
["China, Ningxia ","ÂÆÅÂ§èÂõûÊóèËá™Ê≤ªÂå∫","CN-NX","9e2f10b3-138f-4320-95a3-ea3853c5fbdd",null,null,"China, Ningxia ","宁夏回族自治区",null,"China, Ningxia (ÂÆÅÂ§èÂõûÊóèËá™Ê≤ªÂå∫)",null,"China, Ningxia (宁夏回族自治区)"]
["China, Qinghai ","ÈùíÊµ∑","CN-QH","06422af3-6431-4f6f-a555-7c0e008bce8b",null,null,"China, Qinghai ","青海",null,"China, Qinghai (ÈùíÊµ∑)",null,"China, Qinghai (青海)"]
["China, Shaanxi ","ÈôïË•ø","CN-SA","232efb31-1dd5-4d00-87a8-5fa631021c17",null,null,"China, Shaanxi ","陕西",null,"China, Shaanxi (ÈôïË•ø)",null,"China, Shaanxi (陕西)"]
["China, Shandong ","Â±±‰∏ú","CN-SD","2b2ddda2-bb8e-42f7-82e5-013cc04f7bc5",null,null,"China, Shandong ","山东",null,"China, Shandong (Â±±‰∏ú)",null,"China, Shandong (山东)"]
["China, Shanghai ","‰∏äÊµ∑","CN-SH","4a15b2ab-5593-48d7-a7b9-b1c07c5ca99b",null,null,"China, Shanghai ","上海",null,"China, Shanghai (‰∏äÊµ∑)",null,"China, Shanghai (上海)"]
["China, Shanxi ","Â±±Ë•ø","CN-SX","79abbd47-8e8b-4932-94c8-f3518ff110e9",null,null,"China, Shanxi ","山西",null,"China, Shanxi (Â±±Ë•ø)",null,"China, Shanxi (山西)"]
["China, Sichuan ","ÂõõÂ∑ù","CN-SC","1238ec0d-4167-453a-9ec5-50cfef0782a1",null,null,"China, Sichuan ","四川",null,"China, Sichuan (ÂõõÂ∑ù)",null,"China, Sichuan (四川)"]
["China, Tianjin ","Â§©Ê¥•","CN-TJ","24c6336b-e160-4d2a-8d25-ac207a66f6c1",null,null,"China, Tianjin ","天津",null,"China, Tianjin (Â§©Ê¥•)",null,"China, Tianjin (天津)"]
["China, Xinjiang ","Êñ∞ÁñÜÁª¥ÂêæÂ∞îËá™Ê≤ªÂå∫","CN-XJ","e8a978ab-a183-4ce7-b791-760190d8a63c",null,null,"China, Xinjiang ","新疆维吾尔自治区",null,"China, Xinjiang (Êñ∞ÁñÜÁª¥ÂêæÂ∞îËá™Ê≤ªÂå∫)",null,"China, Xinjiang (新疆维吾尔自治区)"]
["China, Xizang ","Ë•øËóèËá™Ê≤ªÂå∫","CN-XZ","c079ba9b-dc27-45f0-96b5-a3dd168de8ed",null,null,"China, Xizang ","西藏自治区",null,"China, Xizang (Ë•øËóèËá™Ê≤ªÂå∫)",null,"China, Xizang (西藏自治区)"]
["China, Yunnan ","‰∫ëÂçó","CN-YN","f41e84aa-2c80-451e-a7ab-594acc1b096d",null,null,"China, Yunnan ","云南",null,"China, Yunnan (‰∫ëÂçó)",null,"China, Yunnan (云南)"]
["China, Zhejiang ","ÊµôÊ±ü","CN-ZJ","a959ec4b-3db6-4b9f-9ea6-897fbcfdc610",null,null,"China, Zhejiang ","浙江",null,"China, Zhejiang (ÊµôÊ±ü)",null,"China, Zhejiang (浙江)"]

{"sheet":"Tabelle3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}