{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Info","Bodennutzung_Utilisation du sol","GVE_UGB","Betriebstyp_Type correct"],"not_rendered":{"defined_names":27,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":35,"n_cols":1,"rows_kept":35}
["Agroscope, Tänikon, 8356 Ettenhausen"]
["Zentrale Auswertung von Buchhaltungsdaten"]
["Version 09.06.2021*"]
[]
["Diese Datei ist zur Berechnung des Betriebstyps vorgesehen."]
["Die Kennzahlen beziehen sich auf das Buchhaltungsjahr 2018."]
["Die Mindestgrösse wird nicht überprüft."]
[]
["Die Zentrale Auswertung übernimmt keine Verantwortung für falsch eingegeben Daten."]
["Falls ein Betrieb an die Zentrale Auswertung von Buchhaltungsdaten geliefert wird, sind die gelieferten Daten und die Ermittlung der Typologie bei der ZA-BH massgebend."]
["Die Tabelle ist zweisprachig ausgerichtet, die jeweilige nicht benötigte Sprache kann ausgeblendet werden."]
[]
[]
[]
["Agroscope, Tänikon, 8356 Ettenhausen"]
["Dépouillement centralisé des données comptables\n"]
[]
["Ce fichier est pour le calcul du type des exploitations."]
["Les données sont basées sur l'année exercice comptable 2018.\n"]
["La taille minimale n'est pas validée."]
[]
["Le Dépouillement centralisé n'est pas responsable pour des données incorrectes."]
["Si une entreprise est fournie à le Dépouillement centralisé, les données fournies et la détermination de la typologie par la ZA-BH sont utilisées."]
["La table est bilingue, la langue non nécessaire peut être cachée."]
[]
[]
[]
["*"]
["In den einzugebende Zellen befinden sich keine Zahlen mehr."]
["Die Formatierung wurde leicht angepasst."]
["Ein Berechnungsfehler wurde korrigiert."]
[]
["Il n'y a plus de chiffres dans les cellules à saisir."]
["Le formatage a été légèrement ajusté."]
["Une erreur de calcul a été corrigée."]

{"sheet":"Bodennutzung_Utilisation du sol","index":1,"n_rows":49,"n_cols":5,"rows_kept":49}
["Bodennutzung",null,"Utilisation du sol"]
[]
["Betrieb:",null,"Exploitation:",null,12345678]
["Jahr",null,"Année",null,2018]
["Region",null,"Région",null,1]
["1 = Talregion (Talzone)",null,"1 = Région de plaine (zone de plaine)"]
["2 = Hügelregion (Hügelzone, Bergzone I)",null,"2 = Région des collines (zone des collines, zone de montagne I)"]
["3 = Bergregion (Bergzone II -  Bergzone IV)",null,"3 = Région de montagne (zone de montagne II -  zone de montagne IV)"]
[]
["Kultur Flächenausstattung in ha",null,"Culture Surface en ha"]
["Getreide :",null,"Céréales :"]
["Weizen",null,"Blé"]
["Roggen",null,"Seigle"]
["Gerste",null,"Orge"]
["Hafer",null,"Avoine"]
["Triticale",null,"Triticale"]
["Futterweizen",null,"Blé fourrager"]
["Hackfrüchte",null,"Sarclées"]
["Körnermais",null,"Maïs grain"]
["Maisganzpflanzen",null,"Maïs plante entière"]
["Kartoffel",null,"Pommes de terre"]
["Zuckerrüben",null,"Betteraves sucrières"]
["Futterrüben",null,"Betteraves fourragères"]
["Raps",null,"Colza"]
["Soja",null,"Soja"]
["Sonnenblumen",null,"Tournesol"]
["Eiweisserbsen",null,"Pois protéagineux"]
["Brachen",null,"Jachère"]
["Andere einjährige Hauptkulturen",null,"Autre grande culture annuelle"]
[]
["Offene Ackerfläche",null,"Terres ouvertes",null,{"$f":"SUM(E12:E29)","v":{"v":0,"d":"0.00"}}]
[]
["Grünland",null,"Prairies"]
["Kunstwiesen",null,"Prairies artificielles"]
[]
["Ackerflächen",null,"Terres assolées",null,{"$f":"E31+E34","v":{"v":0,"d":"0.00"}}]
[]
["Naturwiesen/Weiden",null,"Prairies naturelles"]
[]
["Spezialkulturen",null,"Cultures spéciales"]
["Reben",null,"Vigne"]
["Obstbau",null,"Arboriculture"]
["Beeren und andere Dauerkulturen",null,"Baies, autre culture pérenne"]
["mehrjährige Erdbeerkulturen",null,"Fraises pluriannuelles"]
["Gemüsebau",null,"Cultures maraîchères"]
[]
["Spezialkulturen",null,"Cultures spéciales",null,{"$f":"SUM(E41:E46)","v":{"v":0,"d":"0.00"}}]
[]
["Landwirtschaftliche Nutzfläche",null,"Surface Agricole Utile",null,{"$f":"E36+E38+E47","v":{"v":0,"d":"0.00"}}]

{"sheet":"GVE_UGB","index":2,"n_rows":80,"n_cols":7,"rows_kept":80}
["Tierbestand",null,"Cheptel"]
["Der Betriebstyp für die Buchhaltungen der Zentralen Auswertung wird auf Basis des tagesgenauen mittleren Bestands der anwesenden Tiere berechnet.",null,"Le type d'exploitation pour la comptabilité de l'Dépouillement centralisé est calculé sur la base du nombre moyen quotidien d'animaux présents!"]
["Faktoren für die Umrechnung des Tierbestandes in Grossvieheinheiten",null,"Coefficients de conversion des animaux en unités de gros bétail"]
["référence: ",null,"référence: "]
["http://www.admin.ch/ch/d/rs/910_91/app1.html",null,"http://www.admin.ch/ch/f/rs/910_91/app1.html"]
[{"$nulls":4},"Coefficient par animal","Présents","UGB"]
[]
[{"$nulls":4},"Faktoren je Tier","Anwesende","GVE"]
["Rinder",null,"Bovins"]
["Zucht- und Nutzrinder",null,"Bovins d’élevage et de rente"]
["Kühe (ohne Mutter- und Ammenkühe)",null,"Vaches (sans les vaches mères et nourrices)",null,{"v":1,"d":"1.000"},null,{"$f":"E11*F11","v":{"v":0,"d":"0.00"}}]
["Stiere und Rinder über 2 Jahre",null,"Taureaux et génisses de plus de deux ans",null,{"v":0.6,"d":"0.600"},null,{"$f":"E12*F12","v":{"v":0,"d":"0.00"}}]
["Jungvieh von 1 bis 2 Jahre",null,"Jeune bétail d’un an à deux ans",null,{"v":0.4,"d":"0.400"},null,{"$f":"E13*F13","v":{"v":0,"d":"0.00"}}]
["Jungvieh von 161 bis 305 Tage",null,"Jeune bétail 161 à 305 jours",null,{"v":0.33,"d":"0.330"},null,{"$f":"E14*F14","v":{"v":0,"d":"0.00"}}]
["Jungvieh bis 160 Tage",null,"Jeune bétail jusqu'à 160 jours",null,{"v":0.13,"d":"0.130"},null,{"$f":"E15*F15","v":{"v":0,"d":"0.00"}}]
["Mutter- und Ammenkuhhaltung",null,"Garde de vaches mères et nourrices"]
["Mutter und Ammenkühe (ohne Kälber), Mastkühe",null,"Vaches mères et nourrices (sans les veaux), vaches à l’engrais",null,{"v":1,"d":"1.000"},null,{"$f":"E17*F17","v":{"v":0,"d":"0.00"}}]
["Kälbermast",null,"Engraissement de veaux"]
["Mastkälber (2,8 bis 3 Umtriebe pro Platz)",null,"Veaux à l’engrais (2,8 à 3 rotations par place)",null,{"v":0.13,"d":"0.130"},null,{"$f":"E19*F19","v":{"v":0,"d":"0.00"}}]
["RiGVE",null,"UGBB",{"$nulls":3},{"$f":"SUM(G11:G19)","v":{"v":0,"d":"0.00"}}]
["Tiere der Pferdegattung",null,"Equidés"]
["Säugende Stuten und tragende Stuten",null,"Juments allaitantes et juments portantes",null,{"v":1,"d":"1.000"},0,{"$f":"E22*F22","v":{"v":0,"d":"0.00"}}]
["Saugfohlen (im Faktor der Mutter eingerechnet)",null,"Poulains sous la mère (compris dans le coefficient de la mère)",null,{"v":0,"d":"0.000"},0,{"v":0,"d":"0.00"}]
["Andere Pferde über 30 Monate",null,"Autres chevaux de plus de 30 mois",null,{"v":0.7,"d":"0.700"},0,{"v":0,"d":"0.00"}]
["Andere Fohlen unter 30 Monate",null,"Autres poulains de moins de 30 mois",null,{"v":0.5,"d":"0.500"},0,{"v":0,"d":"0.00"}]
["Maultiere und Maulesel jeden Alters",null,"Mulets et bardots de tout âge",null,{"v":0.4,"d":"0.400"},0,{"v":0,"d":"0.00"}]
["Ponys, Kleinpferde und Esel jeden Alters",null,"Poneys, petits chevaux et ânes de tout âge",null,{"v":0.25,"d":"0.250"},0,{"v":0,"d":"0.00"}]
[]
["Widerristhöhe 148 cm und höher",null,"Hauteur au garrot 148 cm ou plus"]
["über 900 Tage alt",null,"de plus de 900 jours",null,{"v":0.7,"d":"0.700"},null,{"$f":"E30*F30","v":{"v":0,"d":"0.00"}}]
["über 180 Tage bis 900 Tage alt",null,"de plus de 180 à 900 jours",null,{"v":0.5,"d":"0.500"},null,{"$f":"E31*F31","v":{"v":0,"d":"0.00"}}]
["bis 180 Tage alt",null,"jusqu'à 180 jours",null,{"v":0.3,"d":"0.300"},null,{"$f":"E32*F32","v":{"v":0,"d":"0.00"}}]
["Widerristhöhe bis 148 cm",null,"Hauteur au garrot jusqu'à 148 cm"]
["über 900 Tage alt",null,"de plus de 900 jours",null,{"v":0.35,"d":"0.350"},null,{"$f":"E34*F34","v":{"v":0,"d":"0.00"}}]
["über 180 Tage bis 900 Tage alt",null,"de plus de 180 à 900 jours",null,{"v":0.25,"d":"0.250"},null,{"$f":"E35*F35","v":{"v":0,"d":"0.00"}}]
["bis 180 Tage alt",null,"jusqu'à 180 jours",null,{"v":0.15,"d":"0.150"},null,{"$f":"E36*F36","v":{"v":0,"d":"0.00"}}]
[]
["Schafe",null,"Moutons"]
["Schafe gemolken",null,"Brebis traites",null,{"v":0.25,"d":"0.250"},null,{"$f":"E39*F39","v":{"v":0,"d":"0.00"}}]
["Andere Schafe über 1-jährig",null,"Autres moutons de plus d’un an",null,{"v":0.17,"d":"0.170"},null,{"$f":"E40*F40","v":{"v":0,"d":"0.00"}}]
["Jungschafe unter 1-jährig (in den Faktoren der weiblichen Tiere eingerechnet)",null,"Agneaux de moins d’un an (compris dans le coefficient des brebis)",null,{"v":0,"d":"0.000"},null,{"$f":"E41*F41","v":{"v":0,"d":"0.00"}}]
["Weidelämmer (Mast) unter 1/2-jährig, welche nicht den Muttertieren anzurechnen sind (ganzjährige Weidelämmermast)",null,"Agneaux de pâturage (engraissement) de moins de six mois, non imputables aux mères (engraissement à l’année d’agneaux sur pâturage)",null,{"v":0.03,"d":"0.030"},null,{"$f":"E42*F42","v":{"v":0,"d":"0.00"}}]
["Ziegen",null,"Chèvres"]
["Ziegen gemolken",null,"Chèvres traites",null,{"v":0.2,"d":"0.200"},null,{"$f":"E44*F44","v":{"v":0,"d":"0.00"}}]
["Andere Ziegen über 1-jährig",null,"Autres chèvres de plus d’un an",null,{"v":0.17,"d":"0.170"},null,{"$f":"E45*F45","v":{"v":0,"d":"0.00"}}]
["Jungziegen unter 1-jährig (im Faktor des weiblichen Tieres eingerechnet)",null,"Chevreaux de moins d’un an (compris dans le coefficient des chèvres)",null,{"v":0,"d":"0.000"},null,{"$f":"E46*F46","v":{"v":0,"d":"0.00"}}]
["Zwergziegen über 1-jährig: Nutztierhaltung (grössere Bestände zu Erwerbszwecken)",null,"Chèvres naines: garde d’animaux de rente (effectifs importants, à des fins lucratives)",null,0.085,null,{"$f":"E47*F47","v":{"v":0,"d":"0.00"}}]
["GVE PSZ Pferde - Schafe - Ziegen",null,"UGB COC chevaux - ovins - caprins",{"$nulls":3},{"$f":"SUM(G22:G47)","v":{"v":0,"d":"0.00"}}]
["Andere Raufutter verzehrende Nutztiere",null,"Autres animaux consommant des fourrages grossiers"]
["Bisons über 3 Jahre alt (erwachsene Zuchttiere)",null,"Bisons de plus de trois ans (adultes destinés à l’élevage)",null,{"v":1,"d":"1.000"},null,{"$f":"E50*F50","v":{"v":0,"d":"0.00"}}]
["Bisons bis 3 Jahre alt (Aufzucht und Mast)",null,"Bisons de moins de trois ans (élevage et engraissement)",null,{"v":0.4,"d":"0.400"},null,{"v":0,"d":"0.00"}]
["Damhirsche jeden Alters",null,"Daims de tout âge",null,{"v":0.1,"d":"0.100"},null,{"v":0,"d":"0.00"}]
["Rothirsche jeden Alters",null,"Cerfs rouges de tout âge",null,{"v":0.2,"d":"0.200"},null,{"v":0,"d":"0.00"}]
["Lamas über 2-jährig",null,"Lamas de plus de deux ans",null,{"v":0.17,"d":"0.170"},null,{"v":0,"d":"0.00"}]
["Lamas unter 2-jährig",null,"Lamas de moins de deux ans",null,{"v":0.11,"d":"0.110"},null,{"v":0,"d":"0.00"}]
["Alpakas über 2-jährig",null,"Alpagas de plus de deux ans",null,{"v":0.11,"d":"0.110"},null,{"v":0,"d":"0.00"}]
["Alpakas unter 2-jährig",null,"Alpagas de moins de deux ans",null,{"v":0.07,"d":"0.070"},null,{"v":0,"d":"0.00"}]
["Kaninchen",null,"Lapins"]
["Produzierende Zibben (= Zibben mit mind. 4 Würfen pro Jahr) ab 1. Wurf, inkl. Jungtiere bis zum Beginn der Mast bzw. Aufzucht (Alter: ca. 35 Tage)",null,"Lapines reproductrices (dès la 1ère mise bas, y compris jeunes",null,0.034,null,{"$f":"E59*F59","v":{"v":0,"d":"0.00"}}]
["Jungtiere über 35 Tage",null,"Jeunes animaux de plus de 35 jours",null,0.011,null,{"$f":"E60*F60","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"SUM(G50:G59)","v":{"v":0,"d":"0.00"}}]
["Schweine",null,"Porcs"]
["Säugende Zuchtsauen (4 bis 8 Wochen Säugedauer; 5,7 bis 10,4 Umtriebe pro Platz)",null,"Truies allaitantes (durée de l’allaitement: 4 à 8 semaines; 5,7 à 10,4 rotations par place)",null,{"v":0.55,"d":"0.550"},null,{"$f":"E63*F63","v":{"v":0,"d":"0.00"}}]
["Saugferkel (im Faktor der Mutter eingerechnet)",null,"Porcelets allaités (inclus dans le coefficient des truies)",null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.00"}]
["Nicht säugende Zuchtsauen über 6 Monate alt (ca. 3 Umtriebe pro Platz)",null,"Truies non allaitantes de plus de six mois (env. 3 rotations par place)",null,{"v":0.26,"d":"0.260"},null,{"v":0,"d":"0.00"}]
["Zuchteber",null,"Verrats",null,{"v":0.25,"d":"0.250"},null,{"v":0,"d":"0.00"}]
["Abgesetzte Ferkel (ausgestallt mit ca. 25 kg, 8 bis 12 Umtriebe pro Platz oder ausgestallt mit ca. 35 kg, 6 bis 8 Umtriebe pro Platz)",null,"Porcelets sevrés (sortis de la porcherie dès 25 kg env., 8 à 12 rotations par place ou sortis de la porcherie dès 35 kg env., 6 à 8 rotations par place)",null,{"v":0.06,"d":"0.060"},null,{"v":0,"d":"0.00"}]
["Remonten und Mastschweine (ca. 3 Umtriebe pro Platz)",null,"Porcs de renouvellement et porcs à l’engrais (env. 3 rotations par place)",null,{"v":0.17,"d":"0.170"},null,{"v":0,"d":"0.00"}]
["GVE Schweine",null,"UGB Porcs",{"$nulls":3},{"$f":"SUM(G63:G68)","v":{"v":0,"d":"0.00"}}]
["Nutzgeflügel",null,"Volaille de rente"]
["Zuchthennen, Zuchthähne und Legehennen",null,"Poules et coqs d’élevage, poules pondeuses",null,{"v":0.01,"d":"0.010"},null,{"$f":"E71*F71","v":{"v":0,"d":"0.00"}}]
["Junghennen, Junghähne und Küken (ohne Mastpoulets)",null,"Poulettes, jeunes coqs et poussins (sans les poulets de chair)",null,0.004,null,{"v":0,"d":"0.00"}]
["Mastpoulets jeden Alters (Mastdauer ca. 40 Tage; 6,5 bis 7,5 Umtriebe pro Platz)",null,"Poulets de chair de tout âge (durée d’engraissement env. 40 jours; 6,5 à 7,5 rotations par place)",null,0.004,null,{"v":0,"d":"0.00"}]
["Truten jeden Alters (ca. 3 Umtriebe pro Platz)",null,"Dindes de tout âge (env. 3 rotations par place)",null,0.015,null,{"v":0,"d":"0.00"}]
["Trutenvormast (ca. 6 Umtriebe pro Jahr)",null,"Pré-engraissement de dindes (env. 6 rotations par an)",null,0.005,null,{"v":0,"d":"0.00"}]
["Trutenausmast",null,"Engraissement de dindes",null,0.028,null,{"v":0,"d":"0.00"}]
["Strausse bis 13 Monate",null,"Autruches jusqu’à treize mois",null,{"v":0.14,"d":"0.140"},null,{"v":0,"d":"0.00"}]
["Strausse älter als 13 Monate",null,"Autruches de plus de treize mois",null,{"v":0.26,"d":"0.260"},null,{"v":0,"d":"0.00"}]
["GVE Geflügel",null,"UGB Volaille",{"$nulls":3},{"$f":"SUM(G71:G78)","v":{"v":0,"d":"0.00"}}]
["GVE total",null,"UGB totaux",{"$nulls":3},{"$f":"SUM(G79+G69+G48+G61+G20)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Betriebstyp_Type correct","index":3,"n_rows":57,"n_cols":24,"rows_kept":57,"merged":[[3,1,3,2],[9,3,9,4]]}
[]
[null,"Exploitation/Betrieb:",{"$nulls":7},"UGB","Total UGB",{"$nulls":4},"UGBB","VAL","VMVA","COC","PV","Porcs","Vol."]
[{"$nulls":9},"GVE","Total GVE",{"$nulls":4},"RiGVE","MiK","MAK","PSZ","SG","Schweine","Geflügel"]
[null,{"$f":"+'Bodennutzung_Utilisation du sol'!E3","v":12345678},{"$nulls":7},{"$f":"GVE_UGB!G80+0.0001","v":{"v":1E-4,"d":"0.00"}},{"$f":"P4+S4+U4+V4","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"GVE_UGB!G20","v":{"v":0,"d":"0.00"}},{"$f":"GVE_UGB!G11","v":{"v":0,"d":"0.00"}},{"$f":"GVE_UGB!G17","v":{"v":0,"d":"0.00"}},{"$f":"GVE_UGB!G48","v":{"v":0,"d":"0.00"}},{"$f":"U4+V4","v":{"v":0,"d":"0.00"}},{"$f":"GVE_UGB!G69","v":{"v":0,"d":"0.00"}},{"$f":"GVE_UGB!G79","v":{"v":0,"d":"0.00"}}]
[null,"Année/Jahr",{"$nulls":7},"SAU","TO","CSpé","Lég-horti","Arbo","Viti"]
[]
[null,{"$f":"+'Bodennutzung_Utilisation du sol'!E4","v":2018},{"$nulls":7},{"$f":"'Bodennutzung_Utilisation du sol'!E49","v":{"v":0,"d":"0.00"}},{"$f":"'Bodennutzung_Utilisation du sol'!E31","v":{"v":0,"d":"0.00"}},{"$f":"'Bodennutzung_Utilisation du sol'!E47","v":{"v":0,"d":"0.00"}},{"$f":"'Bodennutzung_Utilisation du sol'!E44+'Bodennutzung_Utilisation du sol'!E45","v":{"v":0,"d":"0.00"}},{"$f":"'Bodennutzung_Utilisation du sol'!E42","v":{"v":0,"d":"0.00"}},{"$f":"'Bodennutzung_Utilisation du sol'!E41","v":{"v":0,"d":"0.00"}}]
[null,"Region",{"$nulls":3},{"$f":"Region","v":1},null,null,{"$f":"Region","v":1}]
[null,"Type :",{"$f":"X42","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(X45=1,\"Indiqué dans le plan de sélection.\",\"Pas défini dans le plan de sélection.\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(X45=1,\"Im Auswahlplan ZA-BH SpB vorgesehen.\",\"Im Auswahlplan ZA-BH SpB nicht vorgesehen.\")","v":{"$error":"#DIV/0!"}},"UGB/ SAU","TO/ SAU","CSpé/   SAU","Lég/ SAU","Arbo/  SAU","Viti/ SAU","UGBB/ UGB","VAL/ UGBB","VMVA/UGBB","COC/  UGB","PV/ UGB","Porcs/ UGB","Vol /UGB"]
[{"$nulls":9},"GVE/ LN","OA/ LN","SKul/ LN","Gemüse/LN","Obst/ LN","Reben/ LN","RiGVE/ GVE","MiK/ RiGVE","MAK/ RiGVE","PSZ/ GVE","SG/ GVE","Schweine-GVE/GVE","Geflügel-GVE/GVE"]
[{"$nulls":9},{"$f":"J4/$J7","v":{"$error":"#DIV/0!"}},{"$f":"K7/$J7","v":{"$error":"#DIV/0!"}},{"$f":"L7/$J7","v":{"$error":"#DIV/0!"}},{"$f":"M7/$J7","v":{"$error":"#DIV/0!"}},{"$f":"N7/$J7","v":{"$error":"#DIV/0!"}},{"$f":"O7/$J7","v":{"$error":"#DIV/0!"}},{"$f":"P4/$J4","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Code "]
[null,"Type ZA2015","Désignation",{"$nulls":6},"UGB/ SAU","TO/ SAU","CSpé/   SAU","Lég/ SAU","Arbo/  SAU","Viti/ SAU","UGBB/ UGB","VAL/ UGBB","VMVA/UGBB","COC/  UGB","PV/ UGB","Porcs/ UGB","Vol /UGB","autres conditions","Groupe :"]
[null,"Typ ZA2015","Bezeichnung",{"$nulls":6},"GVE/ LN","OA/ LN","SKul/ LN","Gemüse/LN","Obst/ LN","Reben/ LN","RiGVE/ GVE","MiK/ RiGVE","MAK/ RiGVE","PSZ/ GVE","SG/ GVE","Schweine-GVE/GVE","Geflügel-GVE/GVE","Andere"]
[{"$nulls":3},"Production végétale",{"$nulls":5},"<=1",">0.70",">0.10",{"$nulls":11},0]
[null,1511,null,null,"Grandes cultures",{"$nulls":3},"Ackerbau","<=1",">0.70","<=0.10",{"$nulls":11},{"$f":"IF(AND(J11<=1,K11>0.7,L11<=0.1),1511,0)","v":{"$error":"#DIV/0!"}}]
[null,1512,null,null,"Cultures spéciales",{"$nulls":3},"Spezialkulturen","<=1",null,">0.10",{"$nulls":11},{"$f":"IF(AND(J11<=1,L11>0.1),1512,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"cult. spéc. maraîchères et horticoles",{"$nulls":6},">0.10","<=0.10","<=0.10",{"$nulls":8},{"$f":"IF(AND(J11<=1,L11>0.1,M11>0.1,N11<=0.1,O11<=0.1),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"cult. spéc. arboriculture",{"$nulls":6},"<=0.10",">0.10","<=0.10",{"$nulls":8},{"$f":"IF(AND(J11<=1,L11>0.1,M11<=0.1,N11>0.1,O11<=0.1),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"cult. spéc. viticulture",{"$nulls":6},"<=0.10","<=0.10",">0.10",{"$nulls":8},{"$f":"IF(AND(J11<=1,L11>0.1,M11<=0.1,N11<=0.1,O11>0.1),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"cult. spéc. combinées",{"$nulls":5},">0.10",{"$nulls":10},"pas 1513-1515",{"$f":"IF(AND(J11<=1,L11>0.1,X19=0,X20=0,X21=0),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Production animale",{"$nulls":5},">1","<=0.25","<=0.10",{"$nulls":3},">0.75",null,null,">0.5",">0.5",{"$nulls":3},0]
[{"$nulls":4},"Bovins",{"$nulls":4},">1","<=0.25","<=0.10",{"$nulls":3},">0.75",{"$nulls":7},0]
[null,1521,null,null,"Vaches laitières",{"$nulls":3},"Milchkühe",null,"<=0.25","<=0.10",{"$nulls":3},">0.75",">0.65","<=0.25",{"$nulls":5},{"$f":"IF(AND(K11<=0.25,L11<=0.1,P11>0.75,Q11>0.65,R11<=0.25),1521,0)","v":{"$error":"#DIV/0!"}}]
[null,1522,null,null,"Vaches allaitantes",{"$nulls":3},"Mutterkühe",null,"<=0.25","<=0.10",{"$nulls":3},">0.75","<=0.25",">0.25",{"$nulls":5},{"$f":"IF(AND(K11<=0.25,L11<=0.1,P11>0.75,Q11<=0.25,R11>0.25),1522,0)","v":{"$error":"#DIV/0!"}}]
[null,1523,null,null,"Bovins mixtes",{"$nulls":3},"Rindvieh gemischt",null,"<=0.25","<=0.10",{"$nulls":3},">0.75",{"$nulls":6},"pas 1521, 1522",{"$f":"IF(AND(K11<=0.25,L11<=0.1,P11>0.75,X25=0,X26=0),1523,0)","v":{"$error":"#DIV/0!"}}]
[null,1531,null,null,"Chevaux/moutons/chèvres",{"$nulls":3},"Pferde/Schafe/Ziegen",null,"<=0.25","<=0.10",{"$nulls":6},">0.5",{"$nulls":4},{"$f":"IF(AND(J11>1,K11<=0.25,L11<=0.1,S11>0.5),1531,0)","v":{"$error":"#DIV/0!"}}]
[null,1541,null,null,"Transformation",{"$nulls":3},"Veredlung",null,"<=0.25","<=0.10",{"$nulls":7},">0.5",{"$nulls":3},{"$f":"IF(AND(J11>1,K11<=0.25,L11<=0.1,T11>0.5),1541,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"Porcs",{"$nulls":3},">1","<=0.25","<=0.10",{"$nulls":8},">0.5",null,null,{"$f":"IF(AND(J11>1,K11<=0.25,L11<=0.1,U12>0.5),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"Volaille",{"$nulls":3},">1","<=0.25","<=0.10",{"$nulls":9},">0.5",null,{"$f":"IF(AND(J11>1,K11<=0.25,L11<=0.1,V11>0.5),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"Autres transformation",{"$nulls":3},">1","<=0.25","<=0.10",{"$nulls":7},">0.5","<=0.5","<=0.5",null,{"$f":"IF(AND(J11>1,K11<=0.25,L11<=0.1,T11>0.5,U11<=0.5,V11<=0.5),0,0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Combiné",{"$nulls":3},"Kombiniert ",{"$nulls":14},"pas 1510-1549",0]
[null,1551,null,null,"Combiné vaches laitières/grdes cult.",{"$nulls":3},"Kombiniert Milchkühe/Ackerbau ",null,">0.4",{"$nulls":4},">0.75",">0.65","<=0.25",{"$nulls":4},"pas 1510-1549",{"$f":"IF(AND(K11>0.4,P11>0.75,Q11>0.65,R11<=0.25,X17=0,X18=0,X19=0,X20=0,X21=0,X22=0,X25=0,X26=0,X27=0,X28=0,X29=0,X30=0,X31=0,X32=0,X33=0),1551,0)","v":{"$error":"#DIV/0!"}}]
[null,1552,null,null,"Combiné vaches allaitantes",{"$nulls":3},"Kombiniert Mutterkühe",{"$nulls":6},">0.75","<=0.25",">0.25",{"$nulls":4},"pas 1510-1549",{"$f":"IF(AND(P11>0.75,Q11<=0.25,R11>0.25,X16=0,X17=0,X18=0,X19=0,X20=0,X21=0,X22=0,X23=0,X24=0,X25=0,X26=0,X27=0,X28=0,X29=0,X30=0,X31=0,X32=0,X33=0,X34=0),1552,0)","v":{"$error":"#DIV/0!"}}]
[null,1553,null,null,"Combiné transformation",{"$nulls":3},"Kombiniert Veredlung",{"$nulls":10},">0.25",null,null,"pas 1510-1549",{"$f":"IF(AND(T11>0.25,X16=0,X17=0,X18=0,X19=0,X20=0,X21=0,X22=0,X23=0,X24=0,X27=0,X28=0,X29=0,X30=0,X31=0,X32=0,X33=0,X34=0),1553,0)","v":{"$error":"#DIV/0!"}}]
[null,1554,null,null,"Combiné autres",{"$nulls":3},"Kombiniert Andere ",{"$nulls":13},"pas 1510-1553",{"$f":"IF(AND(X16=0,X17=0,X18=0,X25=0,X26=0,X27=0,X28=0,X29=0,X34=0,X35=0,X36=0),1554,0)","v":{"$error":"#DIV/0!"}}]
[null,null,1555,null,null,"Combiné autres/vaches laitières",{"$nulls":9},">0.75",">0.25","<=0.25",{"$nulls":4},"pas 1510-1553","=SI(ET(M8>0.75;N8>0.25;O8<=0.25;U12=0;U13=0;U14=0;U15=0;U16=0;U17=0;U18=0;U19=0;U20=0;U21=0;U22=0;U25=0;U26=0;U27=0;U28=0;U29=0;U30=0;U31=0;U32=0;U33=0);1555;0)"]
[null,null,1556,null,null,"Combiné autres /bovins",{"$nulls":9},">0.75","<=0.25","<=0.25",{"$nulls":4},"pas 1510-1553","=SI(ET(M8>0.75;N8<=0.25;O8<=0.25;U12=0;U13=0;U14=0;U15=0;U16=0;U17=0;U18=0;U19=0;U20=0;U21=0;U22=0;U23=0;U26=0;U27=0;U28=0;U29=0;U30=0;U31=0;U32=0;U33=0;U34=0);1556;0)"]
[null,null,1557,null,null,"Combiné non attribuable",{"$nulls":16},"pas 1510-1556","=SI(ET(U12=0;U13=0;U14=0;U15=0;U16=0;U17=0;U18=0;U19=0;U20=0;U21=0;U22=0;U23=0;U24=0;U25=0;U26=0;U27=0;U28=0;U29=0;U30=0;U31=0;U32=0;U33=0;U34=0;U35=0);1557;0)"]
[]
[null,"Indiquer le Code pour la statistique régionale et les références",{"$nulls":21},{"$f":"SUM(X16:X40)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Dans AGRO-TWIN comptabilité, la fonction d'extraction des types d'exploitations calcule les codes ZAS4 (marqués en jaune)"]
[{"$nulls":23},{"$f":"IF(AND(OR(X42=1511,X42=1521,X42=1541,X42=1551,X42=1553,X42=1554),Region=1),1,IF(AND(OR(X42=1521,X42=1522,X42=1541,X42=1553,X42=1554),Region=2),1,IF(AND(OR(X42=1521,X42=1522,X42=1523),Region=3),1,2)))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Explications"]
[{"$nulls":3},"UGB",null,"Unités de gros bétail",null,"GVE","Grossvieheinheiten"]
[{"$nulls":3},"SAU",null,"Surface agricole utile",null,"LN","Landwirtschafltiche Nutzfläche"]
[{"$nulls":3},"UGB/SAU",null,"UGB / SAU",null,"GVE/LN","Viehbesatz je ha LN"]
[{"$nulls":3},"TO/SAU",null,"Terres ouvertes / SAU",null,"OA/LN","Anteil offene Ackerfläche an LN"]
[{"$nulls":3},"CSpé/SAU",null,"Surf. cult. spéciales / SAU",null,"SKul/LN","Anteil Spezialkulturen an LN"]
[]
[{"$nulls":3},"UGBB/UGB",null,"UGB bovins / UGB",null,"RiGVE/GVE","Anteil Rindvieh-GVE am Gesamtviehbestand"]
[{"$nulls":3},"VAL/UGBB",null,"Vaches lait / UGB bovins",null,"MiK/RiGVE","Anteil Milchkühe in GVE am Rindviehbestand"]
[{"$nulls":3},"VMVA/UGBB",null,"Vaches-mères/allaitantes / UGB bovins",null,"MAK/RiGVE","Anteil Mutter-/Ammenkühe in GVE am Rindviehbestand"]
[{"$nulls":3},"COC/UGB",null,"UGB chevaux/ovins/chèvres / UGB",null,"PSZ/GVE","Anteil Pferde-, Schaf- und Ziegen-GVE am Gesamtviehbestand"]
[{"$nulls":3},"PV/UGB",null,"UGB transformation (porcs et volaille) / UGB",null,"SG/GVE","Anteil Schweine- und Geflügel-GVE am Gesamtviehbestand"]