{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":184,"n_cols":31,"rows_kept":184,"cut":false,"hidden":false,"merged":[[0,3,1,4],[0,5,1,8],[44,1,45,8],[86,1,87,8],[137,1,138,8],[175,1,175,13],[174,1,174,13],[177,1,177,13],[173,1,173,13],[176,1,176,13],[153,8,153,11],[154,8,154,11],[154,1,154,5],[109,3,109,13],[116,12,116,13],[115,12,115,13],[116,1,116,4],[123,11,123,13],[124,11,124,13],[125,1,125,2],[124,3,124,4],[125,11,125,13],[126,11,126,13],[127,11,127,13],[125,9,125,10],[126,1,126,2],[127,1,127,2],[90,1,90,4],[91,6,91,11],[92,6,92,11],[105,1,105,10],[110,1,110,11],[94,1,94,4],[98,1,98,10],[95,6,95,11],[102,1,102,10],[96,1,96,4],[91,1,91,4],[99,1,99,10],[93,6,93,11],[92,1,92,3],[123,1,123,2],[123,3,123,4],[124,1,124,2],[126,9,126,10],[127,9,127,10],[126,3,126,4],[127,3,127,4],[110,12,110,13],[112,12,112,13],[113,12,113,13],[114,12,114,13],[108,1,108,10],[107,1,107,10],[109,1,109,2],[106,1,106,10],[113,7,113,11],[111,0,111,16383],[21,9,21,11],[78,1,78,3],[76,1,76,3],[77,1,77,3],[74,1,74,3],[86,9,87,10],[60,1,60,3],[40,1,40,3],[41,1,41,3],[70,1,70,3],[75,1,75,3],[42,1,42,4],[51,1,51,3],[52,1,52,3],[65,8,65,11],[63,6,63,11],[80,1,80,3],[69,1,69,3],[67,1,67,3],[28,1,28,3],[57,1,57,3],[79,1,79,3],[55,1,55,4],[72,1,72,4],[12,1,12,3],[12,7,12,11],[11,7,11,11],[14,7,14,11],[17,9,17,11],[16,9,16,11],[18,9,18,11],[19,9,19,11],[20,9,20,11],[20,1,20,3],[13,7,13,11],[0,11,0,13],[0,9,0,10],[1,11,1,13],[1,9,1,10],[19,1,19,3],[0,1,1,1],[5,3,5,6],[11,1,11,3],[3,1,3,2],[4,1,4,2],[4,3,4,6],[11,12,11,13],[5,7,5,8],[16,1,16,3],[5,9,5,13],[19,7,19,8],[18,7,18,8],[3,7,3,8],[4,7,4,10],[3,3,3,6],[7,1,7,13],[16,7,16,8],[17,7,17,8],[3,9,3,13],[128,3,128,4],[133,1,133,2],[133,3,133,4],[134,1,134,2],[134,3,134,4],[141,1,141,4],[135,1,135,2],[135,3,135,4],[135,8,135,10],[141,8,144,13],[143,1,143,5],[132,8,132,10],[131,8,131,10],[130,1,130,13],[128,1,128,2],[131,1,131,2],[131,3,131,4],[128,11,128,13],[133,8,133,10],[134,8,134,10],[134,11,134,13],[128,9,128,10],[131,11,131,13],[161,8,161,13],[148,1,148,5],[157,3,157,13],[149,1,149,4],[151,5,151,6],[155,1,155,11],[159,8,159,13],[148,7,148,13],[132,11,132,13],[135,11,135,13],[152,1,152,13],[150,1,150,11],[144,1,144,5],[146,1,146,5],[145,1,145,5],[142,1,142,5],[145,8,145,11],[146,8,146,11],[140,1,140,13],[132,1,132,2],[132,3,132,4],[137,9,138,10],[137,11,138,13],[133,11,133,13],[4,11,4,13],[5,1,5,2],[14,1,14,3],[21,1,21,3],[20,7,20,8],[89,6,89,11],[83,6,83,11],[83,12,83,13],[89,1,89,3],[86,11,87,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[17,1,17,3],[16,12,16,13],[15,1,15,13],[18,1,18,3],[13,1,13,3],[21,7,21,8],[76,12,76,13],[77,12,77,13],[74,12,74,13],[75,12,75,13],[33,1,33,3],[29,1,29,3],[104,1,104,10],[83,1,83,4],[62,1,62,3],[71,1,71,3],[66,1,66,3],[68,1,68,3],[74,6,74,10],[65,1,65,3],[81,1,81,3],[93,1,93,3],[101,1,101,10],[75,6,82,10],[66,8,71,11],[90,6,90,11],[94,6,94,11],[96,6,96,11],[100,1,100,10],[95,1,95,4],[34,6,34,11],[63,1,63,4],[82,1,82,3],[39,1,39,3],[44,9,45,10],[44,11,45,13],[37,1,37,3],[61,1,61,3],[36,12,36,13],[42,12,42,13],[43,12,43,13],[72,6,72,11],[37,6,41,10],[55,6,55,11],[42,6,42,11],[48,1,48,3],[49,1,49,3],[50,1,50,3],[43,1,43,2],[43,3,43,11],[23,1,23,5],[25,1,25,3],[27,1,27,3],[24,1,24,3],[34,1,34,3],[47,6,47,13],[59,1,59,3],[58,1,58,3],[39,12,39,13],[37,12,37,13],[53,1,53,3],[54,1,54,3],[36,6,36,10],[23,6,23,13],[40,12,40,13],[41,12,41,13],[38,12,38,13],[47,1,47,5],[26,1,26,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[36,1,36,3],[38,1,38,3],[125,3,125,4],[121,1,121,13],[122,1,122,2],[122,3,122,4],[122,9,122,10],[112,1,112,4],[114,7,114,11],[115,7,115,11],[116,7,116,11],[112,7,112,11],[115,1,115,4],[114,1,114,4],[113,1,113,4],[119,12,119,13],[118,12,118,13],[117,1,117,4],[118,1,118,4],[117,7,117,11],[118,7,118,11],[117,12,117,13],[119,1,119,11],[122,11,122,13],[123,9,123,10],[124,9,124,10]]}
[null,null,null,"Formulaire 4.4 ",null,"Calcul de la capacité de stockage \npour les engrais de ferme et les eaux usées",null,null,null,"Commune n° :"]
[null,null,null,null,null,null,null,null,null,"Réception :"]
[]
[null,"Nom / prénom :",null,null,null,null,null,"Adresse :"]
[null,"NPA / commune :",null,null,null,null,null,"Parcelle(s) / droit de superficie n°(s) :"]
[null,"Unité de production :",null,null,null,null,null,"Commune :"]
[]
[null,"Appréciation techn. en matière de protection des eaux des exploitations agricoles"]
[]
[null,"     Permis de construire           Expertise",null,null,null,null,null,null,null,null,"=","données"]
[]
[null,"Eaux résiduaires domestiques",null,null,"Nombre de logements","Chambres habitable","Nombre d'habitants","Evacuation des eaux résiduaires domestiques:",null,null,null,null,"Total eaux résiduaires par an",null,null,"Fa"]
[null,"Ferme",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H13=\"Dans la fosse à purin\",F13*P13,\"0\")","v":"0"},"m3",null,60]
[null,"Habitation annexe",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H14=\"Dans la fosse à purin\",F14*P14,\"0\")","v":"0"},"m3",null,60]
[null,"Autres appartements",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H15=\"Dans la fosse à purin\",F15*P15,\"0\")","v":"0"},"m3",null,60]
[]
[null,"Eaux usées provenant de la restauration (activité annexe), évacuées dans la fosse à purin",null,null,"Nombre de lits ou places assises","Nbr. de jours d'exploitation","Occupation moyenne en pour-cent","Unité",null,"Utilisation:",null,null,"Total eaux usées de la restauration par an",null,null,"Fa","Sommer","Winter","Summe für 1:3"]
[null,"Restaurant places intérieures",null,null,null,null,null,"places assises",null,null,null,null,{"$f":"IF(J18=\"en hiver ou toute l'année\",E18*P18/365*F18)*G18","v":0},"m3",null,19.2,{"$f":"SUM(E18*19.2/365*F18)*G18","v":0},{"$f":"SUM(M18)","v":0},null,null,"FVG","Vollgülle"]
[null,"Carnotzet, places extérieures",null,null,null,null,null,"places assises",null,null,null,null,{"$f":"IF(J19=\"en hiver ou toute l'année\",E19*P19/365*F19)*G19","v":0},"m3",null,3.6,{"$f":"SUM(G19*3.6/365*E19)*F19","v":0},{"$f":"SUM(M19)","v":0},null,null,"F25G F25M","10-40% eingestreut"]
[null,"Salle pour réceptions / fêtes",null,null,null,null,null,"places assises",null,null,null,null,{"$f":"IF(J20=\"en hiver ou toute l'année\",E20*P20/365*F20)*G20","v":0},"m3",null,19.2,{"$f":"SUM(G20*19.2/365*E20)*F20","v":0},{"$f":"SUM(M20)","v":0},null,null,"F50G F50M","40-60% eingestreut"]
[null,"Vacances à la ferme",null,null,null,null,null,"lits/places",null,null,null,null,{"$f":"IF(J21=\"en hiver ou toute l'année\",E21*P21/365*F21)*G21","v":0},"m3",null,60,{"$f":"SUM(G21*60/365*E21)*F21","v":0},{"$f":"SUM(M21)","v":0},null,null,"F75G F75M","60-90% eingestreut"]
[null,"«Aventure sur la paille»",null,null,null,null,null,"lits/places",null,null,null,null,{"$f":"IF(J22=\"en hiver ou toute l'année\",E22*P22/365*F22)*G22","v":0},"m3",null,26.4,{"$f":"SUM(G22*26.4/365*E22)*F22","v":0},{"$f":"SUM(M22)","v":0},null,null,"FNM ","Nur Mist"]
[]
[null,"Animaux",null,null,null,null,"Système de stabulation et calcul des quantités d'engrais",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q18:Q23)","v":0},{"$f":"SUM(R18:R23)","v":0},{"$f":"SUM(Q24-R24)","v":0}]
[null,"Bovins",null,null,"Nbr.","UGB","Nbr. purin unique-\nment","Nbr. purin, peu de fumier","Nbr. purin / fumier","Nbr. fumier, peu de purin","Nbr. fumier uniquem.","Nbr. détention en plein air","Purin m3/an","Fumier m3/an","VG","FVG","LM25G","LM25M","F25G","F25M","LM50G","LM50M","F50G","F50M","LM75G","LM75M","F75G","F75M","NM","FNM"]
[null,"Vache laitière",null,null,null,{"$f":"SUM(E26*1)","v":0},null,null,null,null,null,null,{"$f":"SUM(O26+Q26+U26+Y26)","v":0},{"$f":"SUM((R26+V26+Z26+AC26)/0.8)","v":0},{"$f":"SUM(G26*P26)","v":0},23,{"$f":"SUM(H26*S26)","v":0},{"$f":"SUM(H26*T26)","v":0},17.3,5.3,{"$f":"SUM(I26*W26)","v":0},{"$f":"SUM(I26*X26)","v":0},11.5,10.5,{"$f":"SUM(J26*AA26)","v":0},{"$f":"SUM(J26*AB26)","v":0},5.8,15.8,{"$f":"SUM(K26*AD26)","v":0},21]
[null,"Vache allaitante",null,null,null,{"$f":"SUM(E27*1)","v":0},null,null,null,null,null,null,0,0,{"$f":"SUM(G27*P27)","v":0},17,{"$f":"SUM(H27*S27)","v":0},{"$f":"SUM(H27*T27)","v":0},12.8,4,0,0,8.5,8,{"$f":"SUM(J27*AA27)","v":0},{"$f":"SUM(J27*AB27)","v":0},4.3,12,0,16]
[null,"Veau de vache allaitante",null,null,null,{"$f":"SUM(E28*0.22)","v":0},"-","-",null,"-",null,null,0,0,null,null,null,null,null,null,0,0,2.2999999999999998,2,null,null,null,null,0,3.9]
[null,"Taureau",null,null,null,{"$f":"SUM(E29*0.6)","v":0},null,null,null,null,null,null,0,0,0,18.399999999999999,{"$f":"SUM(H29*S29)","v":0},{"$f":"SUM(H29*T29)","v":0},13.8,4.2,0,0,9.1999999999999993,8.4,{"$f":"SUM(J29*AA29)","v":0},{"$f":"SUM(J29*AB29)","v":0},4.5999999999999996,12.6,0,16.8]
[null,"Génisse d'élevage\nmoins de 1 an",null,null,null,{"$f":"SUM(E30*0.23)","v":0},null,null,null,null,null,null,0,0,0,4.8,{"$f":"SUM(H30*S30)","v":0},{"$f":"SUM(H30*T30)","v":0},3.6,1.2,0,0,2.4,2.2999999999999998,{"$f":"SUM(J30*AA30)","v":0},{"$f":"SUM(J30*AB30)","v":0},1.2,3.5,0,4.5999999999999996]
[null,"Génisse d'élevage\n1 à 2 ans",null,null,null,{"$f":"SUM(E31*0.4)","v":0},null,null,null,null,null,null,0,0,0,8,{"$f":"SUM(H31*S31)","v":0},{"$f":"SUM(H31*T31)","v":0},6,1.9,0,0,4,3.8,{"$f":"SUM(J31*AA31)","v":0},{"$f":"SUM(J31*AB31)","v":0},2,5.7,0,7.6]
[null,"Génisse d'élevage\nplus de 2 ans",null,null,null,{"$f":"SUM(E32*0.6)","v":0},null,null,null,null,null,null,0,0,0,12,{"$f":"SUM(H32*S32)","v":0},{"$f":"SUM(H32*T32)","v":0},9,2.5,0,0,6,5,{"$f":"SUM(J32*AA32)","v":0},{"$f":"SUM(J32*AB32)","v":0},3,7.5,0,10]
[null,"Place de veau à l'engrais",null,null,null,{"$f":"SUM(E33*0.1)","v":0},"-","-","-","-",{"$f":"SUM(E33)","v":0},"-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3.2]
[null,"Place bovin à l'engrais 65-\n520 kg",null,null,null,{"$f":"SUM(E34*0.27)","v":0},null,null,null,null,null,null,{"$f":"SUM(O34+Q34+U34+Y34)","v":0},0,0,5.8,{"$f":"SUM(H34*S34)","v":0},{"$f":"SUM(H34*T34)","v":0},4.4000000000000004,1.3,{"$f":"SUM(I34*W34)","v":0},{"$f":"SUM(I34*X34)","v":0},2.9,2.6,{"$f":"SUM(J34*AA34)","v":0},{"$f":"SUM(J34*AB34)","v":0},1.5,4,0,5.3]
[null,"Total UGB Bovins",null,null,null,{"$f":"SUM(F26:F34)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M26:M34)","v":0},{"$f":"SUM(N26:N34)","v":0}]
[]
[null,"Chevaux",null,null,"Nbr.","UGB","Litière profonde, boxes",null,null,null,null,"UGB par unité","Fumier m3/an",null,"NM","FNM",null,null,null,null,"FVG","Vollgülle"]
[null,"Cheval (dès 3 ans)",null,null,null,{"$f":"SUM(E38*0.7)","v":0},null,null,null,null,null,0.7,{"$f":"SUM(O38/0.8)","v":0},null,{"$f":"SUM(E38*P38)","v":0},12,null,null,null,null,"F25G F25M","10-40% eingestreut"]
[null,"Jument avec poulain",null,null,null,{"$f":"SUM(E39*1)","v":0},null,null,null,null,null,1,{"$f":"SUM(O39/0.8)","v":0},null,{"$f":"SUM(E39*P39)","v":0},14,null,null,null,null,"F50G F50M","40-60% eingestreut"]
[null,"Poulain 0,5 à 3 ans",null,null,null,{"$f":"SUM(E40*0.5)","v":0},null,null,null,null,null,0.5,{"$f":"SUM(O40/0.8)","v":0},null,{"$f":"SUM(E40*P40)","v":0},10,null,null,null,null,"F75G F75M","60-90% eingestreut"]
[null,"Poney / âne / petits chevaux",null,null,null,{"$f":"SUM(E41*0.3)","v":0},null,null,null,null,null,0.25,{"$f":"SUM(O41/0.8)","v":0},null,{"$f":"SUM(E41*P41)","v":0},3.5,null,null,null,null,"FNM ","Nur Mist"]
[null,"Mulet / bardot",null,null,null,{"$f":"SUM(E42*0.4)","v":0},null,null,null,null,null,0.4,{"$f":"SUM(O42/0.8)","v":0},null,{"$f":"SUM(E42*P42)","v":0},5.6,null,null,null,null,"FMSF","Faktor Mastschweineplatz"]
[null,"Total UGB Chevaux",null,null,null,{"$f":"SUM(F38:F42)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M38:N42)","v":0}]
[null,"Mars 2020",null,"Direction des travaux publics et des transports, Office des eaux et des déchets,\nReiterstrasse 11, 3013 Berne l +41 31 633 38 11 l info.awa@be.ch l www.be.ch/oed",null,null,null,null,null,null,null,null,"Page 1 de 4"]
[null,"Calcul de la capacité de stockage pour les engrais de ferme et \nles eaux usées",null,null,null,null,null,null,null,"Commune n° :",null,{"$f":"SUM(L1)","v":0}]
[]
[]
[null,"Animaux",null,null,null,null,"Système de stabulation et calcul des quantités d'engrais"]
[null,"Porcs",null,null,"Place","UGB","Place purin uniquement","Place purin, peu de fumier","Place purin / fumier","Place fumier, peu de purin","Place fumier uniquem.","PPE","Purin m3/an","Fumier m3/an","VG","FVG","LM25G","LM25M","F25G","F25M","LM50G","LM50M","F50G","F50M","LM75G","LM75M","F75G","F75M","NM","FNM","FMSP"]
[null,"Truie d'élevage y.c. porcelets jusqu’à 25 kg ",null,null,null,{"$f":"SUM(E50*0.45)","v":0},null,null,null,null,null,{"$f":"SUM(G50:K50)*AE50","v":0},{"$f":"SUM(O50+Q50+U50+Y50)","v":0},{"$f":"SUM((R50+V50+Z50+AC50)/0.8)","v":0},{"$f":"SUM(G50*P50)","v":0},7.5,{"$f":"SUM(H50*S50)","v":0},{"$f":"SUM(H50*T50)","v":0},5.6,1.1000000000000001,{"$f":"SUM(I50*W50)","v":0},{"$f":"SUM(I50*X50)","v":0},3.8,2.1,{"$f":"SUM(J50*AA50)","v":0},{"$f":"SUM(J50*AB50)","v":0},1.9,3.2,{"$f":"SUM(K50*AD50)","v":0},4.2,2.65]
[null,"Porcs à l'engrais 25-100kg",null,null,null,{"$f":"SUM(E51*0.17)","v":0},null,null,null,null,null,{"$f":"SUM(G51:K51)*AE51","v":0},0,0,0,1.6,0,0,1.2,0.3,0,0,0.8,0.6,0,0,0.4,0.9,0,1.2,1]
[null,"Porcelet",null,null,null,{"$f":"SUM(E52*0.06)","v":0},null,null,null,null,null,0,0,0,0,0.6,0,0,0.5,0.1,0,0,0.3,0.2,0,0,0.2,0.2,0,0.3,0.35]
[null,"Verrat reproducteur",null,null,null,{"$f":"SUM(E53*0.25)","v":0},null,null,null,null,null,0,0,0,0,4.2,0,0,3.2,0.6,0,0,2.1,1.2,0,0,1.1000000000000001,1.8,0,2.2999999999999998,1.47]
[null,"Truie non allaitante ",null,null,null,{"$f":"SUM(E54*0.26)","v":0},null,null,null,null,null,0,0,0,0,5.5,0,0,4.0999999999999996,0.6,0,0,2.8,1.2,0,0,1.4,1.7,0,2.2999999999999998,1.53]
[null,"Truie allaitante (RTPP)",null,null,null,{"$f":"SUM(E55*0.55)","v":0},null,null,null,null,null,0,0,0,0,8.1999999999999993,0,0,6.2,0.9,0,0,4.0999999999999996,1.8,0,0,2.1,2.6,0,3.5,3.24]
[null,"Total UGB Porcs",null,null,null,{"$f":"SUM(F50:F55)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M50:M55)","v":0},{"$f":"SUM(N50:N55)","v":0}]
[]
[null,"Volaille",null,null,"Place","UGB","Place tapis à crottes","Place caisse à corottes","Place crottes liquéfiées","Place fumier liquéfié","100 PP par unité","Nbr.\n100 PP","Purin m3/an","Fumier m3/an","Band","FBand","KBOH","FKBOH",null,"Kver","FKVer","Mver","FMVer",null,"FLHP","FMMP","FMTP"]
[null,"Poule pondeuse  ",null,null,null,{"$f":"SUM(E59*0.01)","v":0},null,null,null,null,1,{"$f":"SUM(G59:J59)/Y59","v":0},{"$f":"SUM(T59+V59)","v":0},{"$f":"SUM((O59+Q59)/0.8)","v":0},{"$f":"SUM(G59*P59)","v":0},2.7E-2,{"$f":"SUM(H59*R59)","v":0},1.4999999999999999E-2,null,{"$f":"SUM(I59*U59)","v":0},2.7E-2,{"$f":"SUM(J59*W59)","v":0},1.4999999999999999E-2,null,100,250,66.66]
[null,"Poulette",null,null,null,{"$f":"SUM(E60*0.004)","v":0},null,null,null,null,0.4,{"$f":"SUM(G60:J60)/Z59","v":0},{"$f":"SUM(T60+V60)","v":0},{"$f":"SUM((O60+Q60)/0.8)","v":0},{"$f":"SUM(G60*P60)","v":0},0.01,{"$f":"SUM(H60*R60)","v":0},6.0000000000000001E-3,null,{"$f":"SUM(I60*U60)","v":0},0.01,{"$f":"SUM(J60*W60)","v":0},6.0000000000000001E-3]
[null,"Poulet à l'engrais   ",null,null,null,{"$f":"SUM(E61*0.004)","v":0},null,null,null,null,0.4,{"$f":"SUM(G61:J61)/Z59","v":0},{"$f":"SUM(T61+V61)","v":0},{"$f":"SUM((O61+Q61)/0.8)","v":0},null,null,{"$f":"SUM(H61*R61)","v":0},8.0000000000000002E-3,null,null,null,{"$f":"SUM(J61*W61)","v":0},8.0000000000000002E-3]
[null,"Dinde à l'engrais",null,null,null,{"$f":"SUM(E62*0.015)","v":0},null,null,null,null,1.5,{"$f":"SUM(G62:J62)/AA59","v":0},{"$f":"SUM(T62+V62)","v":0},{"$f":"SUM((O62+Q62)/0.8)","v":0},null,null,{"$f":"SUM(H62*R62)","v":0},0.03,null,null,null,{"$f":"SUM(J62*W62)","v":0},0.03]
[null,"Autruche / émeu ",null,null,null,{"$f":"SUM(E63*0.2)","v":0},null,null,null,null,1.5,{"$f":"SUM(G63:J63)/Y59","v":0},{"$f":"SUM(T63+V63)","v":0},{"$f":"SUM((O63+Q63)/0.8)","v":0},null,null,{"$f":"SUM(H63*R63)","v":0},0.02,null,null,null,{"$f":"SUM(J63*W63)","v":0},0.02]
[null,"Total UGB Volaille",null,null,null,{"$f":"SUM(F59:F63)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M59:M63)","v":0},{"$f":"SUM(N59:N63)","v":0}]
[]
[null,"Chèvres, moutons, lapins",null,null,"Platz","UGB","Place fumier","Place fumier liquéfié",null,null,null,null,"Purin m3/an","Fumier m3/an","NM","FNM","Mver","FMVer",null,null,"FBand","Kotband"]
[null,"Chèvre",null,null,null,{"$f":"SUM(E67*0.17)","v":0},null,null,null,null,null,null,{"$f":"SUM(Q67)","v":0},{"$f":"SUM(O67)/0.8","v":0},{"$f":"SUM(G67*P67)","v":0},1.7,{"$f":"SUM(H67*R67)","v":0},1.7,null,null,"FKBOH","Kotgrube"]
[null,"Chèvre laitières",null,null,null,{"$f":"SUM(E68*0.2)","v":0},null,null,null,null,null,null,0,0,{"$f":"SUM(G68*P68)","v":0},2,0,2,null,null,"FKVer","Kot verflüssigt"]
[null,"Mouton",null,null,null,{"$f":"SUM(E69*0.17)","v":0},null,null,null,null,null,null,0,0,0,1.7,0,1.7,null,null,"FMVer","Mist verflüssigt"]
[null,"Brebis laitière",null,null,null,{"$f":"SUM(E70*0.25)","v":0},null,null,null,null,null,null,0,0,0,2.2999999999999998,0,2.2999999999999998,null,null,"FLHP","Faktor Legehennenplätz"]
[null,"Lapin(e), lapereau inclus jusqu'à 35 jours",null,null,null,{"$f":"SUM(E71*0.034)","v":0},null,null,null,null,null,null,0,0,0,0.16,0,0.16,null,null,"FMMP","Faktor Mastpouletplätz"]
[null,"Lapereau à partir de 35 jours",null,null,null,{"$f":"SUM(E72*0.011)","v":0},null,null,null,null,null,null,0,0,0,2.8000000000000001E-2,0,2.8000000000000001E-2,null,null,"FMTP","Faktor Masttrutenplätz"]
[null,"Total UGB chèvres, moutons, lapins",null,null,null,{"$f":"SUM(F67:F72)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0}]
[]
[null,"Autres animaux",null,null,"Place","UGB","Litière profonde, boxes",null,null,null,null,"UGB par unité","Fumier m3/an",null,"NM","FNM","Mver","FMVer"]
[null,"Bison plus de 3 ans",null,null,null,{"$f":"SUM(E76*0.8)","v":0},null,null,null,null,null,0.8,{"$f":"SUM(O76)/0.8","v":0},null,{"$f":"SUM(E76*P76)","v":0},9.6]
[null,"Bison moins de 3 ans",null,null,null,{"$f":"SUM(E77*0.4)","v":0},null,null,null,null,null,0.4,0,null,{"$f":"SUM(E77*P77)","v":0},4.4000000000000004]
[null,"Cerf",null,null,null,{"$f":"SUM(E78*0.2)","v":0},null,null,null,null,null,0.2,0,null,0,1.6]
[null,"Daim",null,null,null,{"$f":"SUM(E79*0.1)","v":0},null,null,null,null,null,0.1,0,null,0,1.6]
[null,"Lama plus de 3 ans",null,null,null,{"$f":"SUM(E80*0.17)","v":0},null,null,null,null,null,0.17,0,null,0,1.6]
[null,"Lama moins de 3 ans",null,null,null,{"$f":"SUM(E81*0.11)","v":0},null,null,null,null,null,0.11,0,null,0,1.6]
[null,"Alpaga plus de 3 ans",null,null,null,{"$f":"SUM(E82*0.11)","v":0},null,null,null,null,null,0.11,0,null,0,1.6]
[null,"Alpaga moins de 3 ans",null,null,null,{"$f":"SUM(E83*0.07)","v":0},null,null,null,null,null,7.0000000000000007E-2,0,null,0,1.6]
[null,"Total UGB autres animaux",null,null,null,{"$f":"SUM(F76:F83)","v":0},"Total par an",null,null,null,null,null,{"$f":"SUM(M76:N83)","v":0}]
[]
[]
[null,"Calcul de la capacité de stockage pour les engrais de ferme et \nles eaux usées",null,null,null,null,null,null,null,"Commune n° :",null,{"$f":"SUM(L1)","v":0}]
[]
[]
[null,"Total animaux",null,null,"Places","UGB","Engrais de ferme",null,null,null,null,null,"Purin m3/an","Fumier m3/an","Wasser","Faktor"]
[null,"Bovins",null,null,null,{"$f":"SUM(F35)","v":0},"Bovins",null,null,null,null,null,{"$f":"SUM(M35)","v":0},{"$f":"SUM(N35)","v":0},{"$f":"SUM(F91*P91)","v":0},2.4,"Rindvieh"]
[null,"Chevaux",null,null,null,{"$f":"SUM(F43)","v":0},"Chevaux",null,null,null,null,null,"-",{"$f":"SUM(M43)","v":0},{"$f":"SUM(F92*P92)","v":0},2.4,"Pferde"]
[null,"Porcs (PPE)",null,null,{"$f":"SUM(L50:L55)","v":0},{"$f":"SUM(F56)","v":0},"Porcs",null,null,null,null,null,{"$f":"SUM(M56)","v":0},{"$f":"SUM(N56)","v":0},{"$f":"SUM(L50:L55)*P93","v":0},0.5,"Schweine"]
[null,"Volaille (100 PP)",null,null,{"$f":"SUM(L59:L63)","v":0},{"$f":"SUM(F64)","v":0},"Volaille",null,null,null,null,null,{"$f":"SUM(M64)","v":0},{"$f":"SUM(N64)","v":0},{"$f":"SUM(L59:L60)*P94","v":0},0.25,"LHP",{"$f":"SUM(L61:L63)*S94","v":0},1.25,"MPP"]
[null,"Chèvres, moutons, lapins",null,null,null,{"$f":"SUM(F73)","v":0},"Chèvres, moutons, lapins",null,null,null,null,null,{"$f":"SUM(M73)","v":0},{"$f":"SUM(N73)","v":0},{"$f":"SUM(F68,F70,F71,F72)*P95","v":0},0.25,"Schafe, Ziegen, Zibben"]
[null,"Autres",null,null,null,{"$f":"SUM(F84)","v":0},"Autres",null,null,null,null,null,"-",{"$f":"SUM(M84)","v":0},{"$f":"SUM(F96*P96)","v":0},0,"Übrige Tiere"]
[null,"Total UGB",null,null,null,{"$f":"SUM(F91:F96)","v":0},"Total purin / fumier par an",null,null,null,null,null,{"$f":"SUM(M91+M93+M94+M95)","v":0},{"$f":"SUM(N91:N96)","v":0}]
[]
[null,"Eaux résiduaires des étables et des surfaces",null,null,null,null,null,null,null,null,null,null,null,"m3/an",null,"Faktor"]
[null,"Eaux de nettoyage des étables/écuries et soins aux bovins",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O91)","v":0}]
[null,"Eaux de nettoyage des étables/écuries et soins aux porcs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O93)","v":0}]
[null,"Eaux de nettoyage des étables/écuries et soins aux chevaux et autres animaux",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O92+O95+O96)","v":0}]
[null,"Eaux de nettoyage des poulaillers",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O94+R94)","v":0},null,null,"MP Volumen neu"]
[null,"Nouvelle fumière (m)",null,null,"longueur :",null,"largeur:",null,null,"hauteur de stockage :",null,{"$f":"SUM(F104*H104)","v":0},"m2",{"$f":"SUM(L104*P104)","v":0},{"$f":"SUM(L104*P104)","v":0},1.2,{"$f":"SUM(L104*K104)","v":0}]
[null,"Surfaces d'aires de sortie stabilisées non couverte",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L105*P105)","v":0},{"$f":"SUM(L105*P105)","v":0},1.2]
[null,"Surfaces de fosses / silos à purin non couvertes",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L106*P106)","v":0},0,1.2]
[null,"Surfaces de silos-couloirs",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L107*P107)","v":0},0,0.4]
[null,"Autres surfaces dont les eaux s'écoulent dans la fosse à purin (place de lavage p. ex.)",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L108*P108)","v":0},0,1.2]
[null,"Correction relative à la production d'eaux résiduaires par an \np. ex.: Plus-value pour l'affouragement liquide des porcs. Moins-value pour une consommation reduite d'eau. (indiquer la quantité, ajouter le signe (-) devant en cas de réduction (p. ex.: -5)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L109)","v":0}]
[null,"Motifs :"]
[null,"Total eaux résiduaires des étables et des surfaces par an",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N100+N101+N102+N103+N104+N105+N106+N107+N108+N109)","v":0}]
[]
[null,"Eaux résiduaires installations de traite dans la fosse à purin",null,null,null,"Oui/Non","Nbr.","Unité",null,null,null,null,"m3/an",null,"Wasser","Faktor","F-Zusatz"]
[null,"Chambre à lait",null,null,null,null,null,"Poste de traite",null,null,null,null,{"$f":"IF(F114=\"Oui\",O114)/12*12","v":0},null,{"$f":"IF(G114>0.9,P114)+(G114*Q114)","v":0},6,0.6]
[null,"Citerne de refroidissement",null,null,null,null,null,"Litre",null,null,null,null,0,null,{"$f":"SUM(G115*P115)","v":0},1.7999999999999999E-2]
[null,"Traite à pots",null,null,null,null,null,"Poste de traite",null,null,null,null,0,null,{"$f":"IF(G116>0.9,P116)+(G116*Q116)","v":0},36,6]
[null,"Traite directe",null,null,null,null,null,"Poste de traite",null,null,null,null,0,null,{"$f":"IF(G117>0.9,P117)+(G117*Q117)","v":0},48,6]
[null,"Installation de traite automatique",null,null,null,null,null,"Unité",null,null,null,null,0,null,{"$f":"IF(G118>0.9,P118)*(G118)","v":0},300,150]
[null,"Salle de traite y.c. nettoyage fosse de traite",null,null,null,null,null,"Stalle",null,null,null,null,0,null,{"$f":"IF(G119>0.9,P119)+(G119*Q119)","v":0},48,12,"Hinweis: 6 pro Standplatz + 6 pro Melkeinheit"]
[null,"Total eaux résiduaires installations de traite par an",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M114:N119)","v":0}]
[]
[null,"Volume de stockage de purin disponible (uniquement les fosses en bon état ou celles pouvant être mises en conformité et utilisables toute l'année sans restriction, volume utile = hauteur - 10cm)"]
[null,"Emplacement",null,"Matériel / constr.",null,"Année","Longueur","Largeur","Ø","Hauteur",null,"Volume utile m3",null,null,null,"Nutzvolumen",null,"Ø","Ø Fläche",null,"Summe eckig",null,"Summe rund"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U124+W124)","v":0},null,null,null,{"$f":"SUM(J124)-0.1","v":-0.1},null,{"$f":"SUM(I124)/2","v":0},{"$f":"SUM(R124*R124*3.14)","v":0},null,{"$f":"SUM(G124*H124*P124)","v":0},null,{"$f":"SUM(S124*P124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U125+W125)","v":0},null,null,null,{"$f":"SUM(J125)-0.1","v":-0.1},null,0,{"$f":"SUM(R125*R125*3.14)","v":0},null,{"$f":"SUM(G125*H125*P125)","v":0},null,{"$f":"SUM(S125*P125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U126+W126)","v":0},null,null,null,-0.1,null,0,0,null,{"$f":"SUM(G126*H126*P126)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[]
[null,"Surface de fumière existante (uniquement les fumières en bon état ou celles pouvant être mises en conformité et utilisables toute l'année sans restriction, hauteur de stockage standard 1.50m)"]
[null,"Emplacement",null,"Matériel / constr.",null,"Année","Longueur","Largeur","Hauteur de stockage",null,null,"Surface fumière m2",null,null,null,"MP Volumen",null,"Fläche mit Ableitung in GG"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G133*H133)","v":0},null,null,null,{"$f":"SUM(L133*I133)","v":0},null,{"$f":"IF(D133=\"Dalle béton avec fosse à purin\",G133*H133,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G134*H134)","v":0},null,null,null,{"$f":"SUM(L134*I134)","v":0},null,{"$f":"IF(D134=\"Dalle béton avec fosse à purin\",G134*H134,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,{"$f":"IF(D135=\"Dalle béton avec fosse à purin\",G135*H135,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G136*H136)","v":0},null,null,null,0,null,{"$f":"IF(D136=\"Dalle béton avec fosse à purin\",G136*H136,\"0\")","v":"0"},{"$f":"SUM(R133:R136)*1.2","v":0}]
[]
[null,"Calcul de la capacité de stockage pour les engrais de ferme et \nles eaux usées",null,null,null,null,null,null,null,"Commune n° :",null,{"$f":"SUM(L31)","v":0}]
[]
[]
[null,"Calcul des quantités de purin, des eaux de places et des eaux résiduaires"]
[null,"Eaux résiduaires domestiques",null,null,null,null,{"$f":"SUM(M13:M15)","v":0},"m3"]
[null,"Eaux usées provenant de la restauration (hiver)",null,null,null,null,{"$f":"SUM(M18:M22)","v":0},"m3"]
[null,"Eaux résiduaires des étables et des surfaces",null,null,null,null,{"$f":"SUM(M111)+S136","v":0},"m3"]
[null,"Eaux résiduaires installations de traite",null,null,null,null,{"$f":"SUM(M120)","v":0},"m3"]
[null,"Purin non dilué ",null,null,null,null,{"$f":"SUM(M97)","v":0},"m3","Dilution du purin",null,null,null,4.1666666666666664E-2,{"$f":"SUM(Q24+G142+G144+G145)/G146","v":{"$error":"#DIV/0!"}}]
[null,"Total purin dilué",null,null,null,null,{"$f":"SUM(G142:G146)","v":0},"m3"]
[]
[null,"Volume requis de fosse\nà purin pour une durée de stockage de ",null,null,null,null,null,"mois"]
[null,"Volume de stockage nécessaire",null,null,null,null,{"$f":"SUM(G147/12*G149)","v":0},"m3",null,null,null,"Volume de stockage disponible",{"$f":"SUM(L124:N129)","v":0},"m3"]
[null,"Volume de stockage à construire",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G150-M150)<=0,\"0\",SUM(G150-M150))","v":"0"},"m3"]
[]
[null,"Surface/volume requise de fumière pour une durée de stockage de 6 mois "]
[null,"Fumier produit durant 6 mois",null,null,null,null,{"$f":"N97/2","v":0},"m3","Volume de stockage de fumier existant et projeté",null,null,null,{"$f":"SUM(P133:P136)+Q104","v":0},"m3"]
[null,"Surface de stockage de fumier existante et projetée",null,null,null,null,{"$f":"SUM(L133+L134+L135+L136+L104)","v":0},"m2","Manque de volume de stockage de fumier",null,null,null,{"$f":"SUM(G154-M154)","v":0},"m3"]
[null,"Manque de surface de fumière par rapport à l'hauteur de stockage standard 1.50m",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M155/1.5)<=0,\"0\",SUM(M155/1.5))","v":"0"},"m2"]
[]
[null,"Remarques :"]
[]
[null,"Nom/prénom du maître d'ouvrage:"]
[]
[null,"Lieu et date:"]
[]
[null,"L'exploitante/la requérante:",null,null,null,null,null,null,"Le/la mandataire:"]
[null,"L'exploitant/le requérant:"]
[]
[]
[]
[]
[]
[null,"Signature :",null,null,null,null,null,null,"Signature :"]
[]
[null,"Pièces à joindre à la demande (en 1 exemplaire):"]
[null,"· Formulaire de demande de permis de construire 1.0"]
[null,"· Formulaire 3.0: Evacuation des eaux des biens-fonds"]
[null,"· Extrait de carte topographique à l'échelle 1:25 000 avec indication de l’emplacement"]
[null,"· Plans du projet à l'échelle 1:100 ou 1:50 (plans et coupes)"]
[null,"· Attestation du mandat de l'ingénieur pour la construction de fosses à purin"]
[]
[1]
[1.5,null,5]
[2,null,6]
[2.5]
[3]

{"sheet":"Tabelle2","index":1,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[4,null,null,"Raccordées à la canalisation/STEP",null,null,null,"en été",null,null,"Oui",null,"Béton coulé sur place",null,null,"Dalle béton avec fosse à purin"]
[4.5,null,null,"Dans la fosse à purin",null,null,null,"en hiver ou toute l'année",null,null,"Non",null,"Eléments préfabriqué",null,null,"Fumière couverte"]
[5,null,null,"Dans fosse de décantation",null,null,null,null,null,null,null,null,"Acier",null,null,"Couche profonde"]
[5.5,null,null,"Dans petite STEP",null,null,null,null,null,null,null,null,"Autre (voir remarques)",null,null,"Benne en acier couverte"]
[6,null,null,"Autre évacuation (voir remarques)",null,null,null,null,null,null,null,null,null,null,null,"Autre (voir remarques)"]