{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Menu","Page Couverture","Rap. stocks et des cultures","Inv. Stock","Terres,Bâtiments","Inv. Récoltes","Terrain Loué","Machinerie","Matériel d'Étable","Crédit","Autres Rev.","Bilan","États des Résultats","Plans de Cultures","Plans d'Élevage","Budget d'Exploitation","Service de la Dette","Trés. et Prév.","Rapport de la Ferme","l'Actif long terme"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"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":"Menu","index":0,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Cahier Planification et Analyse Financière de Ferme",null,null,null,null,null,"Publication 37F"]

{"sheet":"Page Couverture","index":1,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CAHIER PLANIFICATION ET "]
[null,"ANALYSE FINANCIÈRE DE FERME"]
[null,"Publication 37"]
[]
[]
[]
[]
[null,"Détails de l'exploitation"]
[null,"Agriculteur:"]
[null,"Nom de ferme ou d'exploitation"]
[null,"Adresse"]
[null,"Ville/Village"]
[]
[null,"Code Postal"]
[]
[null,"Téléphone"]
[null,"Courriel:"]
[]
[null,"Adresse"]
[null,"Comté"]
[null,"Lot:"]
[null,"Concession"]
[null,"Canton:"]
[]
[null,"Dernier mis à jour",{"$f":"NOW()","v":"2018-02-27T10:46:03.330"}]
[null,"Année Commencant","2004-01-01"]
[null,"Année Finissant","2004-12-31"]
[]
[null,"Produit par:"]
[null,"Agent de liaison:"]
[null,"Agence:"]
[null,"Adresse:"]
[null,"Ville/Village"]
[null,"Code Postal"]
[null,"Téléphone"]
[null,"Courriel:"]

{"sheet":"Rap. stocks et des cultures","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"RAPPORT DES STOCKS ET DES CULTURES"]
[null,null,null,"                 POUR L'ANNÉE",null,{"$f":"'Page Couverture'!C27","v":"2004-01-01"}]
[]
[null,"CULTURES","Acres","Acres","Rendement","Rendement","COMMENTAIRES"]
[null,null,"Semés","Récoltés","Total","Par Acre"]
[null,null,null,null,null,{"$f":"IF(D6=0,\"-\",SUM(E6/D6))","v":"-"}]
[null,null,null,null,null,{"$f":"IF(D7=0,\"-\",SUM(E7/D7))","v":"-"}]
[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,null,null,{"$f":"IF(D13=0,\"-\",SUM(E13/D13))","v":"-"}]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,"Total",{"$f":"SUM(C6:C15)","v":0},{"$f":"SUM(D6:D15)","v":0}]
[]
[null,"STOCKS"]
[]
[null,"Reproduction",null,"Nbre  de têtes","Valeur"]
[null,null,null,"vendus","Totale"]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D22:D25)","v":0},{"$f":"SUM(E22:E25)","v":0}]
[]
[null,"Marché",null,"Nbre  de têtes","Valeur "]
[null,null,null,"vendus","Totale"]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D30:D33)","v":0},{"$f":"SUM(E30:E33)","v":0}]

{"sheet":"Inv. Stock","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"INVENTAIRE DES STOCKS A LA FERME"]
[null,null,null,null,"BÉTAIL ET VOLAILLE"]
[]
[null,null,null,"Stock d'ouverture",null,{"$f":"'Page Couverture'!C27","v":"2004-01-01"},null,"Stock de fermeture",null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,"Description du bétail",null,"Nombre ","Valeur","Valeur",null,"Nombre ","Valeur","Valeur"]
[null,"ou volaille",null,"de têtes","moyenne","totale",null,"de têtes","moyenne","totale"]
[null,"Reproduction"]
[null,"Vaches",null,null,null,{"$f":"D8*E8","v":0},null,null,null,{"$f":"H8*I8","v":0}]
[null,"Taures saillies",null,null,null,0,null,null,null,0]
[null,"Taures non saillies",null,null,null,0,null,null,null,0]
[null,"Veaux",null,null,null,0,null,null,null,0]
[null,"Taureaux",null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,"TOTAL  - REPRODUCTION",null,{"$f":"SUM(D8:D16)","v":0},null,{"$f":"SUM(F8:F16)","v":0},null,{"$f":"SUM(H8:H16)","v":0},null,{"$f":"SUM(J8:J16)","v":0}]
[]
[null,"MARCHÉ"]
[null,"Veaux",null,null,null,{"$f":"D20*E20","v":0},null,null,null,{"$f":"SUM(H20*I20)","v":0}]
[null,"Vaches de reforme",null,null,null,{"$f":"D21*E21","v":0},null,null,null,{"$f":"SUM(H21*I21)","v":0}]
[null,null,null,null,null,{"$f":"D22*E22","v":0},null,null,null,{"$f":"SUM(H22*I22)","v":0}]
[null,null,null,null,null,{"$f":"D23*E23","v":0},null,null,null,{"$f":"SUM(H23*I23)","v":0}]
[null,null,null,null,null,{"$f":"D24*E24","v":0},null,null,null,{"$f":"SUM(H24*I24)","v":0}]
[null,"TOTAL -  MARCHÉ",null,{"$f":"SUM(D20:D24)","v":0},null,{"$f":"SUM(F20:F24)","v":0},null,{"$f":"SUM(H20:H24)","v":0},null,{"$f":"SUM(J20:J24)","v":0}]
[]
[]
[null,"TOTAL BÉTAIL",null,{"$f":"SUM(D25+D17)","v":0},null,{"$f":"SUM(F25+F17)","v":0},null,{"$f":"SUM(H25+H17)","v":0},null,{"$f":"SUM(J25+J17)","v":0}]
[]
[]
[null,"Dénombrer:   Bovins laitiers - vaches, taures, (saillies et non saillies), veaux (moins de 6 mois, génisses, males)"]
[null,"                      Bovins de boucheries - vaches, taures, taureaux, bouvillons et génisses d'engraissement"]
[null,"                ","Porcs - truies, verrats, jeunes truies, porcs"]
[null,null,"Moutons, chèvres, vollailles, autres animaux"]

{"sheet":"Terres,Bâtiments","index":4,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"   TERRES, BÂTIMENTS"]
[null,"TERRAIN POSSÉDÉ",null,null,null,null,"Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[]
[null,"Champ","Description officielle",null,null,"                Achat",null,"                            Acres",null,"Valeur marchande"]
[null,"no.",null,null,null,"Année","Cost","Total","Arable","actuelle"]
[]
[]
[]
[]
[]
[]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H6:H11)","v":0},{"$f":"SUM(I6:I11)","v":0},{"$f":"SUM(J6:J11)","v":0}]
[]
[null,"RENSEIGNEMENTS SUR LES BÂTIMENTS PRINCIPAUX"]
[]
[null,"Champ","Description",null,null,"               Achat",null,"Valeur actuelle","Dépréciation","Valeur actuelle"]
[null,"no.",null,null,null,"Année","Coût",{"$f":"'Page Couverture'!C27","v":"2004-01-01"},null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(H18-I18)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H19*5%)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"SUM(H21-I21)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,"Total",null,null,null,null,{"$f":"+SUM(G19:G25)","v":0},{"$f":"+SUM(H19:H25)","v":0},{"$f":"+SUM(I19:I25)","v":0},{"$f":"+SUM(J19:J25)","v":0}]
[null,"DRAINAGE SOUTERRAIN"]
[]
[null,"Description",null,null,null,"Date","Coût","Valeur","Dépréciation","Total"]
[null,null,null,null,null,null,"Total","31 décembre",null,"Valeur actuelle"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H31*5%)","v":0},{"$f":"SUM(H31-I31)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H32*5%)","v":0},{"$f":"SUM(H32-I32)","v":0}]
[null,"Total",null,null,null,null,{"$f":"+G32+G31","v":0},{"$f":"SUM(H31:H32)","v":0},{"$f":"SUM(I31:I32)","v":0},{"$f":"SUM(J31:J32)","v":0}]
[]
[null,"QUOTAS"]
[]
[null,"Description",null,null,null,"Date","Valeur totale"]
[]
[]
[]
[null,"Total",null,null,null,null,{"$f":"SUM(G38:G40)","v":0}]

{"sheet":"Inv. Récoltes","index":5,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"INVENTAIRE DES RÉCOLTES ET DES APPROVISIONNEMENTS"]
[null,null,null,"  Inventaire des cultures produites à la ferme",null,null,null,null,"       Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[]
[null,null,"Stock d'ouverture",null,null,{"$f":"'Page Couverture'!C27","v":"2004-01-01"},null,"Stock de fermeture",null,null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,"DESCRIPTION","Quantité","Unité","$/unités","Valeur",null,"Quantité","Unité","$/unités","Valeur"]
[null,null,null,null,null,"totale",null,null,null,null,"totale"]
[null,null,null,null,null,{"$f":"SUM(C7*E7)","v":0},null,null,null,null,{"$f":"SUM(H7*J7)","v":0}]
[null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(H8*J8)","v":0}]
[null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(H9*J9)","v":0}]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,"TOTAL - CULTURES PRODUITES",null,null,null,{"$f":"SUM(F7:F16)","v":0},null,null,null,null,{"$f":"SUM(K7:K16)","v":0}]
[]
[null,null,null,"                   Inventaire des aliments achetés et des approvisionnements"]
[]
[null,null,"       Stock d'ouverture",null,null,{"$f":"'Page Couverture'!C27","v":"2004-01-01"},null,"        Stock de fermeture",null,null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,"DESCRIPTION","Quantité","Unité","$/unité","Valeur",null,"Quantité","Unité","$/Unité","Valeur"]
[null,null,null,null,null,"totale",null,null,null,null,"totale"]
[null,"Aliment complet",null,null,null,{"$f":"SUM(C24*E24)","v":0},null,null,null,null,{"$f":"SUM(H24*J24)","v":0}]
[null,"Complément protéique",null,null,null,{"$f":"SUM(C25*E25)","v":0},null,null,null,null,{"$f":"SUM(H25*J25)","v":0}]
[null,"Foin",null,null,null,0,null,null,null,null,0]
[null,"Grain",null,null,null,0,null,null,null,null,0]
[null,"Paille",null,null,null,0,null,null,null,null,0]
[null,"Semences et plants",null,null,null,0,null,null,null,null,0]
[null,"Engrais et chaux",null,null,null,0,null,null,null,null,0]
[null,"Pesticides, autres produits chimiques",null,null,null,0,null,null,null,null,0]
[null,"Ficelle et contenants",null,null,null,0,null,null,null,null,0]
[null,"Carburant",null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,"TOTAL - ALIMENTS ACHETÉS ET APPROVISIONNEMENTS",null,null,null,{"$f":"SUM(F24:F37)","v":0},null,null,null,null,{"$f":"SUM(K24:K37)","v":0}]

{"sheet":"Terrain Loué","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"TERRAIN LOUÉ"]
[]
[]
[null,"Propriétaire",null,"Types de bail","Date","Acres","Acres","Paiement"]
[null,null,null,"et conditions","d'expiration",null,null,"annuel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F6:F35)","v":0},{"$f":"SUM(G6:G35)","v":0},{"$f":"SUM(H6:H35)","v":0}]

{"sheet":"Machinerie","index":7,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"INVENTAIRE DE LA MACHINERIE ET DU MATÉRIEL"]
[]
[null,"Description:","Année","Prix","Valeur","Dépré-","Valeur",null,"Description",null,"Année","Prix","Valeur","Dépré-","Valeur "]
[null,"(sorte, marque, modèle, etc.)","d'achat","d'achat","dépréc.","ciation","actuelle",null,null,null,"d'achat","d'achat","dépréc.","ciation","actuelle"]
[null,null,null,null,"Dec.31/99",null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"},null,null,null,null,null,"Dec.31/99",null,{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,null,null,null,null,{"$f":"SUM(E6*10%)","v":0},{"$f":"SUM(E6-F6)","v":0},null,null,null,null,null,null,{"$f":"SUM(M6*10%)","v":0},{"$f":"SUM(M6-N6)","v":0}]
[null,null,null,null,null,{"$f":"SUM(E7*10%)","v":0},{"$f":"SUM(E7-F7)","v":0},null,null,null,null,null,null,{"$f":"SUM(M7*10%)","v":0},{"$f":"SUM(M7-N7)","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"SUM(E23*10%)","v":0},{"$f":"SUM(E23-F23)","v":0},null,null,null,null,null,null,0,{"$f":"SUM(M23-N23)","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,{"$f":"SUM(M24*10%)","v":0},{"$f":"SUM(M24-N24)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,"Total",null,null,{"$f":"SUM(L6:L25)","v":0},{"$f":"SUM(M6:M25)","v":0},{"$f":"SUM(N6:N25)","v":0},{"$f":"SUM(O6:O25)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,"Total  - Valeur actuelle",null,{"$f":"SUM(G36+O26)","v":0}]
[null,null,null,null,null,0,0,null,"Amortissements, année en cours",null,{"$f":"SUM(F36+N26)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[null,"Total",null,{"$f":"SUM(D6:D34)","v":0},{"$f":"SUM(E6:E34)","v":0},{"$f":"SUM(F6:F34)","v":0},{"$f":"SUM(G6:G34)","v":0}]

{"sheet":"Matériel d'Étable","index":8,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"                          INVENTAIRE DU MATÉRIEL D'ÉTABLE"]
[]
[null,"Description",null,null,"Valeur","Appréciation","Dépréciation","Valeur"]
[null,"(sorte, marque, modèle, etc.)",null,null,"Dec.31/99","$",null,"actuelle"]
[null,null,null,null,null,null,{"$f":"SUM(E5+F5)*10%","v":0},{"$f":"SUM(E5+F5-G5)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E6+F6-G6)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E7+F7-G7)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E8+F8-G8)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E9 + F9-G9)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E10+F10-G10)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E11+F11-G11)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E12+F12-G12)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E13+F13-G13)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E14-F15-G14)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E15+F15-G15)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E16+F16-G16)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E17+F17-G17)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E18+F18-G18)","v":0}]
[null,null,null,null,null,null,0,{"$f":"SUM(E19+F19-G19)","v":0}]
[null,"Total",null,null,{"$f":"SUM(E5:E19)","v":0},{"$f":"SUM(F5:F19)","v":0},{"$f":"SUM(G5:G19)","v":0},{"$f":"SUM(H5:H19)","v":0}]

{"sheet":"Crédit","index":9,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"RENSEIGNEMENTS SUR LE CRÉDIT",null,null,null,"Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[]
[null,"COMPTES CLIENTS"]
[null,"Client",null,null,null,"Solde","Taux","Solde de","Taux"]
[null,null,null,null,null,"d'ouverture","d'intérêt","fermeture","d'intérêt"]
[]
[]
[]
[]
[null,"Total des comptes clients",null,null,null,{"$f":"SUM(F6:F9)","v":0},null,{"$f":"SUM(H6:H9)","v":0}]
[]
[null,"COMPTES FOURNISSEURS"]
[null,"Fournisseur",null,null,null,"Solde","Taux","Solde de","Taux"]
[null,null,null,null,null,"d'ouverture","d'intérêt","fermeture","d'intérêt"]
[]
[]
[]
[]
[]
[null,"Total des comptes fournisseurs",null,null,null,{"$f":"SUM(F15:F19)","v":0},null,{"$f":"SUM(H15:H19)","v":0}]
[]
[null,null,null,"PRÊTS, BILLETS ET HYPOTHÈQUES"]
[]
[null,"CRÉDIT À L'EXPLOITATION"]
[null,"Prêteur",null,null,null,"Raison du crédit - type",null,null,"Montant autorisé  ($)","Taux d'int.","Solde à payer ($)"]
[]
[]
[]
[null,"Total de crédit à l'exploitation",null,null,null,null,null,null,{"$f":"SUM(I26:I28)","v":0},null,{"$f":"SUM(K26:K28)","v":0}]
[]
[null,"PRÊTS À LONG TERME"]
[null,"Prêteur",null,"Raison",null,"          Prêt initial",null,"Taux","Période de remboursement","Solde","   Paiement dû dans l'année"]
[null,null,null,null,null,"Année","Montant","d'int.",null,"actuel","Capital","Int."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total de prêts à long terme",null,null,null,null,{"$f":"SUM(G34:G42)","v":0},null,null,{"$f":"SUM(J34:J42)","v":0},{"$f":"SUM(K34:K42)","v":0},{"$f":"SUM(L34:L42)","v":0}]
[]
[null,"PRÊTS ARRIÉRÉS"]
[null,"Prêteur",null,"Raison",null,null,"Période","Principale","Intérêt"]
[null,null,null,null,null,null,"Arriérée","Arriérée","Arriérée"]
[]
[]
[]
[null,"Total de prêts arriérés",null,null,null,null,null,{"$f":"SUM(K48:K52)","v":0},{"$f":"SUM(L48:L52)","v":0}]

{"sheet":"Autres Rev.","index":10,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"REVENUS  D'APPOINT  ET PRÊTS HORS FERME"]
[]
[null,"Revenus d'Appoint"]
[]
[null,"DEMANDEUR"]
[]
[null,"Employeur",null,"Genre de travail",null,null,null,"Salaire / Année"]
[]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H8:H11)","v":0}]
[]
[]
[null,"CONJOINT"]
[]
[null,"Employeur",null,"Genre de travail",null,null,null,"Salaire / Année"]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H19:H21)","v":0}]
[]
[null,"Prêts non reliés à la ferme"]
[]
[null,"Prêteur",null,"Raison",null,null,"Solde","Paiment "]
[null,null,null,null,null,null,"Actuel","annuel dû"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H29:H35)","v":0}]

{"sheet":"Bilan","index":11,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"BILAN"]
[null,"Nom: ",{"$f":"'Page Couverture'!C10","v":0},null,null,null,"Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[]
[null,null,"ACTIF",null,null,null,"PASSIF ET AVOIR DU PROPRIÉTAIRE"]
[null,null,null,"À ce","Dernier",null,null,null,"À ce","Dernier"]
[null,null,null,"jour","Bilan",null,null,null,"jour","Bilan"]
[null,"ACTIF  À COURT TERME",null,{"$f":"'Page Couverture'!C27","v":"2004-01-01"},"Dec.31/99",null,"PASSIF À COURT TERME",null,{"$f":"D7","v":"2004-01-01"},{"$f":"E7","v":"Dec.31/99"}]
[]
[null,"Encaisse et banque",null,"","",null,"Comptes fournisseurs",null,null,{"$f":"Crédit!F20","v":0}]
[null,"Investissements à court terme",null,"","",null,"Crédit bancaire à l'eXploitation "]
[null,"Comptes clients",null,{"$f":"Crédit!H10","v":0},{"$f":"Crédit!F10","v":0},null,"(incluant le découvert)"]
[null,"Animaux pour le marché",null,{"$f":"'Inv. Stock'!J25","v":0},{"$f":"'Inv. Stock'!F25","v":0},null,"Capital dû dans l'année "]
[null,"Cultures produites",null,{"$f":"'Inv. Récoltes'!K17","v":0},{"$f":"'Inv. Récoltes'!F17","v":0},null,"sur prêts à long terme"]
[null,"Aliments achetés et approvisionnements",null,{"$f":"'Inv. Récoltes'!K38","v":0},{"$f":"'Inv. Récoltes'!F38","v":0},null,"Arr. de cap. sur prêts à long terme"]
[null,"Autres",null,null,"",null,"Autres"]
[null,null,null,"",""]
[]
[null,"TOTAL DE L'ACTIF À COURT TERME",null,{"$f":"SUM(D9:D17)","v":0},{"$f":"SUM(E9:E17)","v":0},null,"TOTAL DU PASSIF À COURT TERME",null,{"$f":"SUM(I9:I17)","v":0},{"$f":"SUM(J9:J16)","v":0}]
[]
[null,"ACTIF À LONG TERME",null,null,null,null,"PASSIF À LONG TERM (dû dans plus de 1 an)"]
[null,"Quota",null,{"$f":"'Terres,Bâtiments'!G41","v":0},null,null," - Billets à long terme, prêts, hypothèques, etc."]
[null,"Animaux de reproduction",null,{"$f":"'Inv. Stock'!J17","v":0},null,null,{"$f":"Crédit!B34","v":0},null,{"$f":"Crédit!J34","v":0}]
[null,"Drainage souterrain",null,{"$f":"'Terres,Bâtiments'!J33","v":0},null,null,{"$f":"Crédit!B35","v":0},null,{"$f":"Crédit!J35","v":0}]
[null,"Machinerie",null,{"$f":"Machinerie!K28","v":0},null,null,{"$f":"Crédit!B36","v":0},null,{"$f":"Crédit!J36","v":0}]
[null,"Équipement d'étable",null,{"$f":"'Matériel d''Étable'!H20","v":0},null,null,{"$f":"Crédit!B37","v":0},null,{"$f":"Crédit!J37","v":0}]
[null,"Bâtiments",null,{"$f":"'Terres,Bâtiments'!J26","v":0},null,null,{"$f":"Crédit!B38","v":0},null,{"$f":"Crédit!J38","v":0}]
[null,"Terres",null,{"$f":"'Terres,Bâtiments'!J12","v":0},null,null,{"$f":"Crédit!B39","v":0},null,{"$f":"Crédit!J39","v":0}]
[null,"Autres - domicile",null,{"$f":"'Terres,Bâtiments'!J18","v":0},null,null,null,null,{"$f":"Crédit!J40","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Crédit!J41","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Crédit!J42","v":0}]
[]
[null,"TOTAL DE L'ACTIF À LONG TERME",null,{"$f":"SUM(D21:D31)","v":0},{"$f":"SUM(E21:E31)","v":0},null,"MOINS:  Capital dû dans l'année",null,{"$f":"Crédit!K43","v":0},{"$f":"+J13","v":0}]
[]
[null,"TOTAL DE L'ACTIF",null,{"$f":"SUM(D32+D18)","v":0},{"$f":"SUM(E32+E18)","v":0},null,"TOTAL DU PASSIF À LONG TERM",null,{"$f":"SUM(I22:I30)-I32","v":0},{"$f":"SUM(J22:J30)-J32","v":0}]
[]
[null,"VARIATION DE L'AVOIR DU PROPRÉTAIRE",null,null,null,null,"TOTAL DU PASSIF",null,{"$f":"SUM(I34+I18)","v":0},{"$f":"SUM(J34+J18)","v":0}]
[null,"Avoir du propriétaire au début",null,{"$f":"J41","v":0}]
[null," + Bénéfice net de la ferme",null,{"$f":"'États des Résultats'!H50","v":0}]
[null," + Apports du propriétaire"]
[null," - Retraits du propriétaire"]
[null," = Avoir du propriétaire à la fin",null,{"$f":"SUM(D37+D38+D39-D40)","v":0},null,null,"AVOIR DU PROPRIÉTAIRE",null,{"$f":"SUM(D34-I36)","v":0},{"$f":"SUM(E34-J36)","v":0}]
[]
[null,"MÉTHODE DE CALCUL",null,null,null,null,"TOTAL DU PASSIF ET DE L'AVOIR DU PROPRIÉTAIRE",null,{"$f":"SUM(I41+I36)","v":0},{"$f":"SUM(J41+J36)","v":0}]
[null,"Récoltes et animaux évalués à la valeur marchande"]
[null,"Bâtiments et machinerie au  prix d'achat moins l'amortissement"]
[null,"Terres à la valeur marchande"]

{"sheet":"États des Résultats","index":12,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"ÉTATS DES RÉSULTATS"]
[null,null,null,"                            (avec rajustement de compatbilité d'exercice)"]
[null,"Nom:",{"$f":"'Page Couverture'!C10","v":0},null,"Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[null,"REVENUE",null,null,null,"DÉPENSES"]
[null,"Bétail","Reproduction",{"$f":"'Rap. stocks et des cultures'!E26","v":0},null,"Bétail","- achats"]
[null,null,"Marché",{"$f":"'Rap. stocks et des cultures'!E34","v":0},null,null,"- Aliments achetés"]
[null,null,null,null,null,null,"- santé animale"]
[null,null,null,null,null,"Cultures","- semence"]
[null,"Cultures",{"$f":"'Inv. Récoltes'!B7","v":0},null,null,null,"- engrais"]
[null,null,{"$f":"'Inv. Récoltes'!B8","v":0},null,null,null,"- pest/produits chimiques"]
[null,null,{"$f":"'Inv. Récoltes'!B9","v":0},null,null,null,"- assurance"]
[null,null,{"$f":"'Inv. Récoltes'!B10","v":0},null,null,null," - autres dépenses"]
[null,null,{"$f":"'Inv. Récoltes'!B11","v":0},null,null,"Frais de mise en marché, transport"]
[null,null,{"$f":"'Inv. Récoltes'!B12","v":0},null,null,"Travail à forfait, location de matériel"]
[null,null,{"$f":"'Inv. Récoltes'!B13","v":0},null,null,"Main-d'oeuvre engagée"]
[null,null,{"$f":"'Inv. Récoltes'!B14","v":0},null,null,"Carburant, huile (machinerie et matériel)"]
[null,null,{"$f":"'Inv. Récoltes'!B15","v":0},null,null,"Réparation (machinerie et matériel)"]
[null,null,{"$f":"'Inv. Récoltes'!B16","v":0},null,null,"Frais des véhicules motorisés"]
[null,"Travail à forfait",null,null,null,"Réparation (bâtiments et clôtures)"]
[null,"Rabais, octrois",null,null,null,"Équipment loué"]
[null,null,null,null,null,"Électricité, téléphone"]
[null,"TOTAL  DES PRODUITS ENCAISSÉS",null,{"$f":"SUM(D5:D21)","v":0},null,"Comptabilité, frais de bureau"]
[null,null,null,null,null,"Intérêt (crédit à l'exploitation)"]
[null,"ADJUSTEMENTS",null,null,null,"Autres charges variables payées"]
[null,"Variation des comptes clients"]
[null,"+ comptes clients à la fin",null,{"$f":"Crédit!H10","v":0},null,"TOTAL DES CHARGES VARIABLES PAYÉES",null,{"$f":"SUM(H5:H25)","v":0},"B"]
[null,"- comptes clients au début",null,{"$f":"Crédit!F10","v":0}]
[null,"Variation des stocks de bétail",null,null,null,"AJUSTEMENTS"]
[null,"+ Animaux pour le marché, à la fin",null,{"$f":"'Inv. Stock'!J25","v":0},null,"+ Comptes fournisseurs, à la fin",null,{"$f":"Crédit!H20","v":0}]
[null,"- Animaux pour le marché, au début",null,{"$f":"'Inv. Stock'!F25","v":0},null,"- Comptes fournisseurs, au début",null,{"$f":"Crédit!F20","v":0}]
[null,"+ Sujets reproducteurs, à la fin",null,{"$f":"'Inv. Stock'!J17","v":0},null,"TOTAL DES CHARGES VARIABLES",null,{"$f":"SUM(H26+H29-H30)","v":0},"C"]
[null,"- Sujets reproducteurs, au début",null,{"$f":"'Inv. Stock'!F17","v":0},null,"Marge sur charges variables  (A-C)",null,{"$f":"SUM(D41-H31)","v":0}]
[null,"VARIATIONS DES STOCKS DE RÉCOLTES, ALIMENTS ET APPROV.",null,null,null,"CHARGES FIXES"]
[null,"+ Cultures produites, à la fin",null,{"$f":"'Inv. Récoltes'!K17","v":0},null,"Taxes fonçières"]
[null,"- Cultures produites, au début",null,{"$f":"'Inv. Récoltes'!F17","v":0},null,"Ass. (incendie et responsabilité)"]
[null,"+ Aliments achetés et approv., à la fin",null,{"$f":"'Inv. Récoltes'!K38","v":0},null,"Locations, baux"]
[null,"- Aliments achetés et approv., au début",null,{"$f":"'Inv. Récoltes'!F38","v":0},null,"Intérêts (à long terme)"]
[null,"+ Coûts de produits",null,null,null,"TOTAL DES CHARGES FIXES PAYÉES",null,{"$f":"SUM(H34:H37)","v":0},"D"]
[null,"    commercialisables consommés",null,null,null,"Total des dépenses générales"]
[null,null,null,null,null,"Amortissement (équipement d'étable)",null,{"$f":"'Matériel d''Étable'!G20","v":0}]
[null,"TOTAL DES PRODUITS",null,{"$f":"SUM(D22+D26-D27+D29-D30+D31-D32+D34-D35+D36-D37+D39)","v":0},"A","Amortissement (machinerie et matériel)",null,{"$f":"Machinerie!K29","v":0}]
[null,null,null,null,null,"Amortissement (bâtiments)",null,{"$f":"'Terres,Bâtiments'!I26","v":0}]
[null,null,null,null,null,"Amortissement (drainage souterrain)",null,{"$f":"'Terres,Bâtiments'!I33","v":0}]
[null,"Total des décaissements",null,{"$f":"SUM(H38+H31)","v":0},null,"TOTAL DES CHARGES FIXES NON PAYÉES",null,{"$f":"SUM(H40:H43)","v":0},"E"]
[]
[null,null,null,null,null,"TOTAL DES CHARGES  (C+D+E)",null,{"$f":"SUM(H31+H38+H44)","v":0}]
[null,null,null,null,null,"- Part personnelle des charges"]
[null,null,null,null,null,"TOTAL DES CHARGES DE LA FERME",null,{"$f":"SUM(H46-H47)","v":0},"F"]
[]
[null,null,null,null,null,"BÉNÉFICE NET DE LA FERME (A-F)",null,{"$f":"SUM(D41-H48)","v":0}]

{"sheet":"Plans de Cultures","index":13,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"PLANS DES CULTURES",null,null,null,"Du:","Jan. 1, 2001",null,"au:","Dec. 31, 2001",null,null,"1999 Acres",{"$f":"'Terres,Bâtiments'!I12+'Terrain Loué'!F36","v":0}]
[]
[null,null,"            Stock d'ouverture",null,null,"Production anticipée",null,null,"Utilisations",null,null,"Ventes",null,null,"Prévisions du stock de fermeture"]
[null,"CULTURE","Nombre","Valeur/","Valeur","#","Rendement","Unités","Aliments pour","Propriétaire","Nombre","Valeur/","TOTAL","Nombre","Valeur/","TOTAL"]
[null,null,"d'unités","Unité","totale","Acres","acre","totales","bétail et semences",null,"d'unités","Unité",null,"d'unités","Unité"]
[null,{"$f":"'États des Résultats'!C9","v":0},{"$f":"'Inv. Récoltes'!H7","v":0},{"$f":"'Inv. Récoltes'!J7","v":0},{"$f":"SUM(C6*D6)","v":0},null,null,{"$f":"SUM(F6*G6)","v":0},null,null,null,null,{"$f":"SUM(K6*L6)","v":0},{"$f":"SUM(C6+H6-I6-J6-K6)","v":0},null,{"$f":"SUM(N6*O6)","v":0}]
[null,{"$f":"'États des Résultats'!C10","v":0},{"$f":"'Inv. Récoltes'!H8","v":0},{"$f":"'Inv. Récoltes'!J8","v":0},{"$f":"SUM(C7*D7)","v":0},null,null,{"$f":"SUM(F7*G7)","v":0},null,null,null,null,{"$f":"SUM(K7*L7)","v":0},{"$f":"SUM(C7+H7-I7-J7-K7)","v":0},null,{"$f":"SUM(N7*O7)","v":0}]
[null,{"$f":"'États des Résultats'!C11","v":0},{"$f":"'Inv. Récoltes'!H9","v":0},{"$f":"'Inv. Récoltes'!J9","v":0},0,null,null,0,null,null,null,null,0,{"$f":"SUM(C8+H8-I8-J8-K8)","v":0},null,{"$f":"SUM(N8*O8)","v":0}]
[null,{"$f":"'États des Résultats'!C12","v":0},{"$f":"'Inv. Récoltes'!H10","v":0},{"$f":"'Inv. Récoltes'!J10","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C13","v":0},{"$f":"'Inv. Récoltes'!H11","v":0},{"$f":"'Inv. Récoltes'!J11","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C14","v":0},{"$f":"'Inv. Récoltes'!H12","v":0},{"$f":"'Inv. Récoltes'!J12","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C15","v":0},{"$f":"'Inv. Récoltes'!H13","v":0},{"$f":"'Inv. Récoltes'!J13","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C16","v":0},{"$f":"'Inv. Récoltes'!H14","v":0},{"$f":"'Inv. Récoltes'!J14","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C17","v":0},{"$f":"'Inv. Récoltes'!H15","v":0},{"$f":"'Inv. Récoltes'!J15","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'États des Résultats'!C18","v":0},{"$f":"'Inv. Récoltes'!H16","v":0},{"$f":"'Inv. Récoltes'!J16","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E6:E15)","v":0},{"$f":"SUM(F6:F15)","v":0},null,null,null,null,null,null,{"$f":"SUM(M6:M15)","v":0},null,null,{"$f":"SUM(P6:P15)","v":0}]
[]
[null,"INTRANTS CULTURAUX",null,null,null,null,null,"Du:",{"$f":"I1","v":"Jan. 1, 2001"},null,"Au:",{"$f":"L1","v":"Dec. 31, 2001"}]
[]
[null,"Culture",null,"Acres"," Semences et plants",null,"     Engrais et chaux",null," Pesticides, prod. chim.",null,"       Autres Intrants",null,"     Assurance Récolte"]
[null,null,null,null,"$/Acre","Total","$/Acre","Total","$/Acre","Total","$/Acre","Total","$/Acre","Total"]
[null,{"$f":"B6","v":0},null,{"$f":"F6","v":0},null,{"$f":"E23*D23","v":0},null,{"$f":"G23*D23","v":0},null,{"$f":"I23*D23","v":0},null,{"$f":"D23*K23","v":0},null,{"$f":"D23*M23","v":0}]
[null,0,null,0,null,{"$f":"E24*D24","v":0},null,{"$f":"G24*D24","v":0},null,{"$f":"I24*D24","v":0},null,{"$f":"D24*K24","v":0},null,{"$f":"D24*M24","v":0}]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D23:D31)","v":0},null,{"$f":"SUM(F23:F31)","v":0},null,{"$f":"SUM(H23:H31)","v":0},null,{"$f":"SUM(J23:J31)","v":0},null,{"$f":"SUM(L23:L31)","v":0},null,{"$f":"SUM(N23:N31)","v":0}]

{"sheet":"Plans d'Élevage","index":14,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"PLANS D'ÉLEVAGE"]
[null,"Date:",{"$f":"'Page Couverture'!C28","v":"2004-12-31"}]
[]
[null,null,"STOCK D'OUVERTURE",null,null,null,null,null,null,null,null,null,null," PROJ. ENDING INVENTORY"]
[null,"Animaux de","Nbre","Valeur/","Total","Nbre de ","Nbre","      ACHATS",null,"Nbre d'animaux","Nbre","        VENTES",null,null,"Valeur/"]
[null,"Reproduction",null,"Tête",null,"Naissance","d'admissions","Nbre","Coût ($)","morts","d'expédition","Nbre","Produits","Nbre","Tête","Total"]
[null,{"$f":"'Inv. Stock'!B8","v":"Vaches"},{"$f":"'Inv. Stock'!H8","v":0},{"$f":"'Inv. Stock'!I8","v":0},{"$f":"C7*D7","v":0},null,null,null,null,null,null,null,null,{"$f":"C7+F7+G7+H7-J7-K7-L7","v":0},null,{"$f":"N7*O7","v":0}]
[null,{"$f":"'Inv. Stock'!B9","v":"Taures saillies"},{"$f":"'Inv. Stock'!H9","v":0},{"$f":"'Inv. Stock'!I9","v":0},{"$f":"C8*D8","v":0},null,null,null,null,null,null,null,null,{"$f":"C8+F8+G8+H8-J8-K8-L8","v":0},null,{"$f":"N8*O8","v":0}]
[null,{"$f":"'Inv. Stock'!B10","v":"Taures non saillies"},{"$f":"'Inv. Stock'!H10","v":0},{"$f":"'Inv. Stock'!I10","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B11","v":"Veaux"},{"$f":"'Inv. Stock'!H11","v":0},{"$f":"'Inv. Stock'!I11","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B12","v":"Taureaux"},{"$f":"'Inv. Stock'!H12","v":0},{"$f":"'Inv. Stock'!I12","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B13","v":0},{"$f":"'Inv. Stock'!H13","v":0},{"$f":"'Inv. Stock'!I13","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B14","v":0},{"$f":"'Inv. Stock'!H14","v":0},{"$f":"'Inv. Stock'!I14","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B15","v":0},{"$f":"'Inv. Stock'!H15","v":0},{"$f":"'Inv. Stock'!I15","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"'Inv. Stock'!B16","v":0},{"$f":"'Inv. Stock'!H16","v":0},{"$f":"'Inv. Stock'!I16","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"TOTAL",{"$f":"SUM(C7:C16)","v":0},null,{"$f":"SUM(E7:E16)","v":0},0,0,0,0,0,0,0,0,0,null,0]
[]
[null,"Marché"]
[null,{"$f":"'Inv. Stock'!B20","v":"Veaux"},{"$f":"'Inv. Stock'!H20","v":0},{"$f":"'Inv. Stock'!I20","v":0},{"$f":"SUM(C20*D20)","v":0},null,null,null,null,null,null,null,null,{"$f":"C20+F20+G20+H20-J20-K20-L20","v":0},null,{"$f":"N20*O20","v":0}]
[null,{"$f":"'Inv. Stock'!B21","v":"Vaches de reforme"},{"$f":"'Inv. Stock'!H21","v":0},{"$f":"'Inv. Stock'!I21","v":0},{"$f":"SUM(C21*D21)","v":0},null,null,null,null,null,null,null,null,{"$f":"C21+F21+G21+H21-J21-K21-L21","v":0},null,{"$f":"N21*O21","v":0}]
[null,{"$f":"'Inv. Stock'!B22","v":0},{"$f":"'Inv. Stock'!H22","v":0},{"$f":"'Inv. Stock'!I22","v":0},{"$f":"SUM(C22*D22)","v":0},null,null,null,null,null,null,null,null,{"$f":"C22+F22+G22+H22-J22-K22-L22","v":0},null,{"$f":"N22*O22","v":0}]
[null,{"$f":"'Inv. Stock'!B23","v":0},{"$f":"'Inv. Stock'!H23","v":0},{"$f":"'Inv. Stock'!I23","v":0},{"$f":"SUM(C23*D23)","v":0},null,null,null,null,null,null,null,null,{"$f":"C23+F23+G23+H23-J23-K23-L23","v":0},null,{"$f":"N23*O23","v":0}]
[null,{"$f":"'Inv. Stock'!B24","v":0},{"$f":"'Inv. Stock'!H24","v":0},{"$f":"'Inv. Stock'!I24","v":0},{"$f":"SUM(C24*D24)","v":0},null,null,null,null,null,null,null,null,{"$f":"C24+F24+G24+H24-J24-K24-L24","v":0},null,{"$f":"N24*O24","v":0}]
[]
[null,"TOTAL",{"$f":"SUM(C20:C25)","v":0},null,{"$f":"SUM(E20:E25)","v":0},0,0,0,{"$f":"SUM(I20:I25)","v":0},0,0,0,0,0,null,0]

{"sheet":"Budget d'Exploitation","index":15,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"       BUDGET D'EXPLOITATION"]
[null,null,null,"               "]
[null,"Année:",{"$f":"'Trés. et Prév.'!E3","v":"2001"},null,"Nom:",null,{"$f":"'Page Couverture'!C10","v":0}]
[null,"PRODUITS",null,null,null,"DÉPENSES"]
[null,"Bétail","Reproduction",{"$f":"'Plans d''Élevage'!M17","v":0},null,"Bétail","- achats",{"$f":"'Trés. et Prév.'!E23","v":0}]
[null,null,"Marché",{"$f":"'Plans d''Élevage'!M26","v":0},null,null,"- aliments achetés",{"$f":"'Trés. et Prév.'!E24","v":0}]
[null,null,null,null,null,null,"- santé animale",{"$f":"'Trés. et Prév.'!E25","v":0}]
[null,null,null,null,null,"Cultures","- semences et plants",{"$f":"'Trés. et Prév.'!E26","v":0}]
[null,"Cultures",{"$f":"'Trés. et Prév.'!C6","v":0},{"$f":"'Trés. et Prév.'!E6","v":0},null,null,"- engrais",{"$f":"'Trés. et Prév.'!E27","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C7","v":0},{"$f":"'Trés. et Prév.'!E7","v":0},null,null,"- pest/prod. chimiques",{"$f":"'Trés. et Prév.'!E28","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C8","v":0},{"$f":"'Trés. et Prév.'!E8","v":0},null,null," - assurance",{"$f":"'Trés. et Prév.'!E29","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C9","v":0},{"$f":"'Trés. et Prév.'!E9","v":0},null,null," - autres dépenses",{"$f":"'Trés. et Prév.'!E30","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C10","v":0},{"$f":"'Trés. et Prév.'!E10","v":0},null,"Frais de mise en marché, transport",null,0]
[null,null,{"$f":"'Trés. et Prév.'!C11","v":0},{"$f":"'Trés. et Prév.'!E11","v":0},null,"Travail à forfait, locationde matériel",null,{"$f":"'Trés. et Prév.'!E32","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C12","v":0},{"$f":"'Trés. et Prév.'!E12","v":0},null,"Main d'oeuvre engagée",null,{"$f":"'Trés. et Prév.'!E33","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C13","v":0},{"$f":"'Trés. et Prév.'!E13","v":0},null,"Carburant, huile (machinerie et matériel)",null,{"$f":"'Trés. et Prév.'!E34","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C14","v":0},{"$f":"'Trés. et Prév.'!E14","v":0},null,"Réparation (machinerie et matériel)",null,{"$f":"'Trés. et Prév.'!E35","v":0}]
[null,null,{"$f":"'Trés. et Prév.'!C15","v":0},{"$f":"'Trés. et Prév.'!E15","v":0},null,"Frais des véhicules motorisés",null,{"$f":"'Trés. et Prév.'!E36","v":0}]
[null,"Custom Work",null,{"$f":"'Trés. et Prév.'!E16","v":0},null,"Réparation (bâtiments et clôtures)",null,{"$f":"'Trés. et Prév.'!E37","v":0}]
[null,"Rebates, Grants",null,{"$f":"'Trés. et Prév.'!E17","v":0},null,"Équipement loué",null,{"$f":"'Trés. et Prév.'!E38","v":0}]
[null,null,null,null,null,"Électricité, téléphone",null,{"$f":"'Trés. et Prév.'!E39","v":0}]
[null,"TOTAL DES PRODUITS ENCAISSÉS",null,{"$f":"SUM(D5:D20)","v":0},null,"Comptabilité, frais de bureau",null,{"$f":"'Trés. et Prév.'!E40","v":0}]
[null,null,null,null,null,"Intérêt (crédit à l'exploitation)",null,{"$f":"'Trés. et Prév.'!E45","v":0}]
[null,"AJUSTEMENTS",null,null,null,"Autres charges variables payées",null,{"$f":"'Trés. et Prév.'!E44","v":0}]
[null,"Variation des comptes clients"]
[null,"+ Comptes clients à la fin",null,null,null,"TOTAL DES CHARGS VARIABLES PAYÉES",null,{"$f":"SUM(H5:H24)","v":0},"B"]
[null,"- Comptes clients au début",null,{"$f":"Crédit!H10","v":0}]
[null,"Variation des stocks de bétails",null,null,null,"AJUSTEMENTS"]
[null,"+ Animaux pour le marché à la fin",null,{"$f":"SUM('Plans d''Élevage'!P26)","v":0},null,"+ Comptes fournisseurs, à la fin"]
[null,"- Animaux pour le marché au début",null,{"$f":"SUM('Plans d''Élevage'!E26)","v":0},null,"- Comptes fournisseurs, au début",null,{"$f":"Crédit!H20","v":0}]
[null,"+ Sujet reproducteurs, à la fin",null,{"$f":"SUM('Plans d''Élevage'!P17)","v":0},null,"TOTAL DES CHARGES VARIABLES",null,{"$f":"SUM(H26+H29-H30)","v":0},"C"]
[null,"- Sujets reproducteurs, au début",null,{"$f":"SUM('Plans d''Élevage'!E17)","v":0},null,"Marge sur charges variables  (A-C)",null,{"$f":"SUM(D41-H31)","v":0}]
[null,"Variation des stocks de récoltes, aliments et approvisionnements",null,null,null,"CHARGES FIXES"]
[null,"+ Cultures produites, à la fin",null,{"$f":"'Plans de Cultures'!P17","v":0},null,"Taxes fonçières",null,{"$f":"'Trés. et Prév.'!E42","v":0}]
[null,"- Cultures produites, au début",null,{"$f":"'Plans de Cultures'!E17","v":0},null,"Assurance (incendie et responsabilité)",null,{"$f":"'Trés. et Prév.'!E43","v":0}]
[null,"+ Aliments achetés et approvisionnements à la fin",null,null,null,"Locations et baux",null,{"$f":"'Trés. et Prév.'!E41","v":0}]
[null,"- Aliments achetés et approvisionnements au début",null,{"$f":"'Inv. Récoltes'!K38","v":0},null,"Intérêts (à long terme)",null,{"$f":"'Trés. et Prév.'!E46","v":0}]
[null,"+ Coûts des produits ",null,null,null,"TOTAL DES CHARGES FIXES PAYÉES",null,{"$f":"SUM(H34:H37)","v":0},"D"]
[null,"     commercialisables consommés",null,null,null,"Total des dépenses générales"]
[null,null,null,null,null,"Amortissement: équipement d'étable",null,{"$f":"'Matériel d''Étable'!H20*10%","v":0}]
[null,"TOTAL DES PRODUITS",null,{"$f":"SUM(D22+D26-D27+D29-D30+D31-D32+D34-D35+D36-D37+D39)","v":0},"A","Amortissement: machinerie et matériel",null,{"$f":"Machinerie!K28*10%","v":0}]
[null,null,null,null,null,"Amortissement:  bâtiments",null,{"$f":"'Terres,Bâtiments'!J26*5%","v":0}]
[null,null,null,null,null,"Amortissement: drainage souterrain",null,{"$f":"'Terres,Bâtiments'!J33*5%","v":0},"E"]
[null,"Total des décaissements",null,{"$f":"H38+H26","v":0},null,"TOTAL DES CHARGES FIXES NON PAYÉES",null,{"$f":"SUM(H40:H43)","v":0}]
[]
[null,null,null,null,null,"TOTAL DES CHARGES  (C+D+E)",null,{"$f":"SUM(H31+H38+H44)","v":0},"F"]
[null,null,null,null,null,"- Part personnelle des charges"]
[null,null,null,null,null,"TOTAL DES CHARGES DE FERME",null,{"$f":"SUM(H46-H47)","v":0}]
[]
[null,null,null,null,null,"BÉNÉFICES NET DE LA FERME (A-F)",null,{"$f":"SUM(D41-H48)","v":0}]

{"sheet":"Service de la Dette","index":16,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,"SERVICE DE LA DETTE"]
[null,"  ","( Incluez les nouveaux prêts lorsque vous utilisez cette page pour faire des prévisions)"]
[null,"REMBOURSEMENTS DE LA DETTE EXIGIBLES ",null,null,null,"Nom:",{"$f":"'Page Couverture'!C10","v":0}]
[null,"Pour la période:"]
[]
[null,"PASSIF À COURT TERME",null,"Solde","Taux","           Paiments annuels",null,"Solde"]
[null,null,null,"en début d'année","d'intérêt","Intérêt","Capital","en fin d'année"]
[null,"Comptes clients"]
[null,{"$f":"Crédit!B15","v":0},null,{"$f":"Crédit!H15","v":0}]
[null,{"$f":"Crédit!B16","v":0},null,{"$f":"Crédit!H16","v":0}]
[null,{"$f":"Crédit!B17","v":0},null,{"$f":"Crédit!H17","v":0}]
[null,{"$f":"Crédit!B18","v":0},null,{"$f":"Crédit!H18","v":0}]
[null,{"$f":"Crédit!B19","v":0},null,{"$f":"Crédit!H19","v":0}]
[null,"Total de comptes clients",null,{"$f":"SUM(D9:D13)","v":0},null,{"$f":"SUM(F9:F13)","v":0},{"$f":"SUM(G9:G13)","v":0},{"$f":"SUM(H9:H13)","v":0}]
[]
[null,"Crédit à l'exploitation"]
[null,{"$f":"Crédit!B26","v":0},null,{"$f":"Crédit!K26","v":0},{"$f":"'Trés. et Prév.'!C45","v":0},{"$f":"SUM('Trés. et Prév.'!E45)","v":0},null,{"$f":"'Trés. et Prév.'!Q53","v":0}]
[null,{"$f":"Crédit!B27","v":0},null,{"$f":"Crédit!K27","v":0},{"$f":"Crédit!J27","v":0}]
[]
[null,"Total de crédit à l'exploitation",null,{"$f":"SUM(D17:D18)","v":0},null,{"$f":"SUM(F17:F18)","v":0},{"$f":"SUM(G17:G18)","v":0},{"$f":"SUM(H17:H18)","v":0}]
[]
[null,"PASSIF À LONG TERME"]
[null,{"$f":"Crédit!B34","v":0},{"$f":"Crédit!D34","v":0},{"$f":"Crédit!J34","v":0},{"$f":"Crédit!H34","v":0},{"$f":"Crédit!L34","v":0},{"$f":"Crédit!K34","v":0},{"$f":"SUM(D23-G23)","v":0}]
[null,{"$f":"Crédit!B35","v":0},{"$f":"Crédit!D35","v":0},{"$f":"Crédit!J35","v":0},{"$f":"Crédit!H35","v":0},{"$f":"Crédit!L35","v":0},{"$f":"Crédit!K35","v":0},{"$f":"SUM(D24-G24)","v":0}]
[null,{"$f":"Crédit!B36","v":0},{"$f":"Crédit!D36","v":0},{"$f":"Crédit!J36","v":0},{"$f":"Crédit!H36","v":0},{"$f":"Crédit!L36","v":0},{"$f":"Crédit!K36","v":0},0]
[null,{"$f":"Crédit!B37","v":0},{"$f":"Crédit!D37","v":0},{"$f":"Crédit!J37","v":0},{"$f":"Crédit!H37","v":0},{"$f":"Crédit!L37","v":0},{"$f":"Crédit!K37","v":0},0]
[null,{"$f":"Crédit!B38","v":0},{"$f":"Crédit!D38","v":0},{"$f":"Crédit!J38","v":0},{"$f":"Crédit!H38","v":0},{"$f":"Crédit!L38","v":0},{"$f":"Crédit!K38","v":0},0]
[null,{"$f":"Crédit!B39","v":0},{"$f":"Crédit!D39","v":0},{"$f":"Crédit!J39","v":0},{"$f":"Crédit!H39","v":0},{"$f":"Crédit!L39","v":0},{"$f":"Crédit!K39","v":0},0]
[null,{"$f":"Crédit!B40","v":0},{"$f":"Crédit!D40","v":0},{"$f":"Crédit!J40","v":0},{"$f":"Crédit!H40","v":0},{"$f":"Crédit!L40","v":0},{"$f":"Crédit!K40","v":0},0]
[null,{"$f":"Crédit!B41","v":0},{"$f":"Crédit!D41","v":0},{"$f":"Crédit!J41","v":0},{"$f":"Crédit!H41","v":0},{"$f":"Crédit!L41","v":0},{"$f":"Crédit!K41","v":0},0]
[null,{"$f":"Crédit!B42","v":0},{"$f":"Crédit!D42","v":0},{"$f":"Crédit!J42","v":0},{"$f":"Crédit!H42","v":0},{"$f":"Crédit!L42","v":0},{"$f":"Crédit!K42","v":0},{"$f":"SUM(D31-G31)","v":0}]
[null,{"$f":"'l''Actif long terme'!B34","v":0},{"$f":"'l''Actif long terme'!C34","v":0},{"$f":"'l''Actif long terme'!F13","v":0},{"$f":"'l''Actif long terme'!D34","v":0},{"$f":"'l''Actif long terme'!E34","v":0},{"$f":"'l''Actif long terme'!F34","v":0},{"$f":"SUM(D31-G31)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D23:D32)","v":0},null,{"$f":"SUM(F23:F32)","v":0},{"$f":"SUM(G23:G32)","v":0},{"$f":"SUM(H23:H32)","v":0}]
[]
[null,"TOTAL GÉNÉRAL",null,{"$f":"SUM(D34+D20)","v":0},null,{"$f":"SUM(F34+F20)","v":0},{"$f":"SUM(G34+G20)","v":0},{"$f":"SUM(H34+H20)","v":0}]
[]
[null,"Remboursements exigibles (intérêts et capital)",null,null,null,{"$f":"SUM(F36+G36)","v":0}]
[]
[null,"CAPACITÉ DE REMBOURSEMENT DE LA DETTE"]
[]
[null,"L'ANNÉE DERNIÈRE",null,null,null,"PRÉVISIONS"]
[null," + encaissements de la ferme",null,{"$f":"'États des Résultats'!D22","v":0},null," + encaissements de la ferme",null,{"$f":"'Budget d''Exploitation'!D22","v":0}]
[null," - décaissements de la ferme",null,{"$f":"'États des Résultats'!D44","v":0},null," - décaissements de la ferme",null,{"$f":"'Budget d''Exploitation'!D44","v":0}]
[null," = produits encaissés nets",null,{"$f":"SUM(D43-D44)","v":0},null," = produits encaissés nets",null,{"$f":"SUM(H43-H44)","v":0}]
[null," + paiements d'intérêts",null,{"$f":"'États des Résultats'!H23+H37","v":0},null," + paiements d'intérêts",null,{"$f":"F36","v":0}]
[null," + apports du propriétaire",null,{"$f":"'Trés. et Prév.'!D20","v":0},null," + apports du propriétaire",null,{"$f":"'Trés. et Prév.'!E20","v":0}]
[null," - retraits du propriétaire",null,{"$f":"'Trés. et Prév.'!D50","v":0},null," - retraits du propriétaire",null,{"$f":"'Trés. et Prév.'!E50","v":0}]
[null," - réserve pour l'acquisition d'actifs",null,{"$f":"'États des Résultats'!H44","v":0},null," - réserve pour l'acquisition d'actifs",null,{"$f":"SUM('Budget d''Exploitation'!H44)","v":0}]
[]
[]
[null," = Capacité de remboursement",null,{"$f":"SUM(D45+D46+D47-D48-D49)","v":0},null," = Capacité de remboursement",null,{"$f":"SUM(H45+H46+H47-H48-H49)","v":0}]

{"sheet":"Trés. et Prév.","index":17,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"BUDGET DE TRÉSORERIE ET PRÉVISIONS",null,null,{"$f":"'Rapport de la Ferme'!D3","v":0}]
[null,null,null,"L'annnée dernière","Prévisions"]
[null,"ENCAISSEMENTS","work",{"$f":"'Page Couverture'!C28","v":"2004-12-31"},"2001","Jan","Fév","Mars","Avril","Mai","Juin","Juillet","Août","Sep","Oct","Nov","Déc","Total"]
[null,"Encaisse",null,{"$f":"Bilan!E9","v":""},{"$f":"Bilan!D9","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F4:Q4)","v":0}]
[null,"Bétail",null,{"$f":"SUM('États des Résultats'!D5+'États des Résultats'!D6)","v":0},{"$f":"SUM('Plans d''Élevage'!M17+'Plans d''Élevage'!M26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Ventes de récoltes",{"$f":"'États des Résultats'!C9","v":0},{"$f":"'États des Résultats'!D9","v":0},{"$f":"'Plans de Cultures'!M6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C10","v":0},{"$f":"'États des Résultats'!D10","v":0},{"$f":"'Plans de Cultures'!M7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C11","v":0},{"$f":"'États des Résultats'!D11","v":0},{"$f":"'Plans de Cultures'!M8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C12","v":0},{"$f":"'États des Résultats'!D12","v":0},{"$f":"'Plans de Cultures'!M9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C13","v":0},{"$f":"'États des Résultats'!D13","v":0},{"$f":"'Plans de Cultures'!M10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:Q10)","v":0}]
[null,null,{"$f":"'États des Résultats'!C14","v":0},{"$f":"'États des Résultats'!D14","v":0},{"$f":"'Plans de Cultures'!M11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C15","v":0},{"$f":"'États des Résultats'!D15","v":0},{"$f":"'Plans de Cultures'!M12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C16","v":0},{"$f":"'États des Résultats'!D16","v":0},{"$f":"'Plans de Cultures'!M13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C17","v":0},{"$f":"'États des Résultats'!D17","v":0},{"$f":"'Plans de Cultures'!M14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'États des Résultats'!C18","v":0},{"$f":"'États des Résultats'!D18","v":0},{"$f":"'Plans de Cultures'!M15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Travail à forfait",null,{"$f":"'États des Résultats'!D19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Rabais et octrois",null,{"$f":"'États des Résultats'!D20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Prêts à long terme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Ventes de biens immobiliers",null,null,{"$f":"'l''Actif long terme'!E13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Contributions personnelles",null,{"$f":"Bilan!D39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL DES ENCAISSEMENTS",null,{"$f":"SUM(D4:D20)","v":0},{"$f":"SUM(E4:E20)","v":0},{"$f":"SUM(F4:F20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DÉCAISSEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bétail   -  achats",null,{"$f":"'États des Résultats'!H5","v":0},{"$f":"'Plans d''Élevage'!I17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bétail   -  aliments",null,{"$f":"'États des Résultats'!H6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Santé animale",null,{"$f":"'États des Résultats'!H7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F25:Q25)","v":0}]
[null,"Semences",null,{"$f":"'États des Résultats'!H8","v":0},{"$f":"'Plans de Cultures'!F33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Engrais et chaux",null,{"$f":"'États des Résultats'!H9","v":0},{"$f":"'Plans de Cultures'!H33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Herbicides/pesticides",null,{"$f":"'États des Résultats'!H10","v":0},{"$f":"'Plans de Cultures'!J33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Assurance récolte",null,{"$f":"'États des Résultats'!H11","v":0},{"$f":"'Plans de Cultures'!N33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Autres (reliées aux cultures)",null,{"$f":"'États des Résultats'!H12","v":0},{"$f":"'Plans de Cultures'!L33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Mise en marché",null,{"$f":"'États des Résultats'!H13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Travail à forfait",null,{"$f":"'États des Résultats'!H14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Main d'oeuvre engagée",null,{"$f":"'États des Résultats'!H15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Carburant, huile (mach. et matériel)",null,{"$f":"'États des Résultats'!H16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Réparation (mach. et matériel)",null,{"$f":"'États des Résultats'!H17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Frais des véhicules motorisés",null,{"$f":"'États des Résultats'!H18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Réparation (bâtiments et clôtures)",null,{"$f":"'États des Résultats'!H19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Baux d'équipement",null,{"$f":"'États des Résultats'!H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Électricité, téléphone",null,{"$f":"'États des Résultats'!H21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Comptabilité, frais de bureau",null,{"$f":"'États des Résultats'!H22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Loyer et baux",null,{"$f":"'États des Résultats'!H36","v":0},{"$f":"'Terrain Loué'!H36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F41:Q41)","v":0}]
[null,"Taxes fonçières",null,{"$f":"'États des Résultats'!H34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Assurance (incendie et responsabilité)",null,{"$f":"'États des Résultats'!H35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Autres frais - crédit à l'exploitation",null,{"$f":"'États des Résultats'!H24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Intérêts - crédit à l'exploitation",null,{"$f":"'États des Résultats'!H23","v":0},{"$f":"+R45","v":0},{"$f":"IF(C53<0,0,+$C$45*C53/12)","v":0},{"$f":"IF(F53<0,0,+$C$45*F53/12)","v":0},{"$f":"IF(G53<0,0,+$C$45*G53/12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Intérêts - prêts à long terme ",null,{"$f":"'États des Résultats'!H37","v":0},{"$f":"SUM('Service de la Dette'!F34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL DES CHARGES PAYÉES",null,{"$f":"SUM(D23:D46)","v":0},{"$f":"SUM(E23:E46)","v":0},{"$f":"SUM(F23:F46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Remboursements de capital",null,null,{"$f":"SUM('Service de la Dette'!G34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Acquisitions des biens immobiliers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Retraits personnels",null,{"$f":"Bilan!D40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL DES DÉCAISSEMENTS",null,{"$f":"SUM(D47:D50)","v":0},{"$f":"SUM(E47:E50)","v":0},{"$f":"SUM(F47:F50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EXCÉDENT OU (DÉFICIT)",null,{"$f":"SUM(D21-D51)","v":0},{"$f":"SUM(E21-E51)","v":0},{"$f":"SUM(F21-F51)","v":0},{"$f":"SUM(G21-G51)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R21-R51)","v":0}]
[null,"SOLDE DU CRÉDIT À L'EXPLOITATION",{"$f":"Crédit!K29","v":0},null,null,{"$f":"IF(C53>0,((+C53*-1+F52)*-1),0)","v":0},{"$f":"IF(F53<0,((+F53*-1+G52)*-1),IF((F54+G52)*-1<0,0,(F54+G52)*-1))","v":0},{"$f":"IF(G53<0,((+G53*-1+H52)*-1),IF((G54+H52)*-1<0,0,(G54+H52)*-1))","v":0},{"$f":"IF(H53<0,((+H53*-1+I52)*-1),IF((H54+I52)*-1<0,0,(H54+I52)*-1))","v":0},0,0,0,0,0,0,0,0]
[null,"ENCAISSE en fin",null,null,null,{"$f":"IF(C53>0,F52-C53,F52)","v":0},{"$f":"IF(F53>0,G52-F53,F54+G52)","v":0},{"$f":"IF(G53>0,H52-G53,G54+H52)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Rapport de la Ferme","index":18,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"RAPPORT DE LA FERME"]
[]
[null,"AGRICULTEUR",null,{"$f":"'Page Couverture'!C10","v":0}]
[null,"NOM DE FERME OU D'EXPLOITATION",null,{"$f":"'Page Couverture'!C11","v":0},null,null,null,"COMTÉ:",{"$f":"'Page Couverture'!C21","v":0}]
[null,"TÉLÉPHONE #:",null,{"$f":"'Page Couverture'!C17","v":0}]
[null,"ADRESSE:",null,{"$f":"'Page Couverture'!C12","v":0},null,null,null,"CODE POSTAL",{"$f":"'Page Couverture'!C15","v":0}]
[null,null,null,{"$f":"'Page Couverture'!D14","v":0}]
[null,"FERME"]
[null,"Lot",{"$f":"'Page Couverture'!C22","v":0},"Conc.",{"$f":"'Page Couverture'!C23","v":0},null,null,null,"CANTON",{"$f":"'Page Couverture'!C24","v":0}]
[null,"Types d'activités",null,null,null,1997,1998,1999,2000]
[]
[null,"Acres possédés",null,"Total d'acres",null,null,null,null,{"$f":"'Terres,Bâtiments'!H12","v":0}]
[null,null,null,"Cultivés",null,null,null,null,{"$f":"'Terres,Bâtiments'!I12","v":0}]
[null,null,null,"Pâturage"]
[null,null,null,"Autres"]
[null,"Acres loués",null,"Cultivés",null,null,null,null,{"$f":"'Terrain Loué'!F36","v":0}]
[null,null,null,"Autres"]
[]
[null,"Actifs agricoles",null,"À court terme",null,null,null,{"$f":"Bilan!E18","v":0},{"$f":"Bilan!D18","v":0}]
[null,null,null,"Capital",null,null,null,{"$f":"Bilan!E32","v":0},{"$f":"Bilan!D32","v":0}]
[null,"Actifs non agricoles"]
[]
[null,"Passifs agricoles",null,"À court terme",null,null,null,{"$f":"Bilan!J18","v":0},{"$f":"Bilan!I18","v":0}]
[null,null,null,"À terme",null,null,null,{"$f":"Bilan!J34","v":0},{"$f":"Bilan!I34","v":0}]
[null,"Passifs non agricoles"]
[]
[null,"Total des produits de l'exploitation",null,null,null,null,null,null,{"$f":"'États des Résultats'!D41","v":0}]
[]
[null,"Total des charges de l'exploitation",null,null,null,null,null,null,{"$f":"'États des Résultats'!H48","v":0}]
[]
[null,"Intérêts payés (crédit à l'exploitation, prêts à long terme)",null,null,null,null,null,null,{"$f":"'États des Résultats'!H23+'États des Résultats'!H37","v":0}]
[]
[null,"Capital payé",null,null,null,null,null,null,{"$f":"'Trés. et Prév.'!D48","v":0}]
[]
[null,"Revenu non agricole (net)",null,null,null,null,null,null,{"$f":"'Autres Rev.'!H13","v":0}]
[]
[null,"MESURE D'EFFICACITÉ DE LA PERFORMANCE"]
[null," - Total de l'actif",null,null,null,{"$f":"SUM(F19+F20)","v":0},{"$f":"SUM(G19+G20)","v":0},{"$f":"Bilan!E34","v":0},{"$f":"Bilan!D34","v":0}]
[null," - Total du passif",null,null,null,{"$f":"SUM(F23+F24)","v":0},{"$f":"SUM(G23+G24)","v":0},{"$f":"Bilan!J36","v":0},{"$f":"Bilan!I36","v":0}]
[null," - Avoir du propriétaire",null,null,null,{"$f":"F38-F39","v":0},{"$f":"G38-G39","v":0},{"$f":"H38-H39","v":0},{"$f":"I38-I39","v":0}]
[null," - Pourcentage % de l'avoir du propriétaire",null,null,null,{"$f":"IF(F38=0, \"-\",F40/F38)","v":"-"},{"$f":"IF(G38=0, \"-\",G40/G38)","v":"-"},{"$f":"IF(H38=0, \"-\",H40/H38)","v":"-"},{"$f":"IF(I38=0, \"-\",I40/I38)","v":"-"}]
[]
[null,"RENTABILITÉ"]
[null," - Bénéfice net de la ferme",null,null,null,{"$f":"SUM(F27-F29)","v":0},{"$f":"SUM(G27-G29)","v":0},{"$f":"SUM(H27-H29)","v":0},{"$f":"SUM(I27-I29)","v":0}]
[null," - Rendements des capitaux propres",null,null,null,{"$f":"IF(F40=0, \"-\",F44*100/F40)","v":"-"},{"$f":"IF(G40=0, \"-\",G44*100/G40)","v":"-"},{"$f":"IF(H40=0, \"-\",H44*100/H40)","v":"-"},{"$f":"IF(I40=0, \"-\",I44*100/I40)","v":"-"}]
[]
[null,"EFFICIENCE FINANCIÈRE"]
[null," - Valeur de la production agricole",null,null,null,{"$f":"F27","v":0},{"$f":"G27","v":0},{"$f":"H27","v":0},{"$f":"I27","v":0}]
[null," - Productivité du capital",null,null,null,{"$f":"IF(F48=0,\"-\",F38/F48)","v":"-"},{"$f":"IF(G48=0,\"-\",G38/G48)","v":"-"},{"$f":"IF(H48=0,\"-\",H38/H48)","v":"-"},{"$f":"IF(I48=0,\"-\",I38/I48)","v":"-"}]
[]
[null,"LIQUIDITÉ ET SOLVABILITÉ (en fin d'année)"]
[null," - Ratios de liquidité générale …(:1)",null,null,null,{"$f":"IF(F23=0,\"-\",F19/F23)","v":"-"},{"$f":"IF(G23=0,\"-\",G19/G23)","v":"-"},{"$f":"IF(H23=0,\"-\",H19/H23)","v":"-"},{"$f":"IF(I23=0,\"-\",I19/I23)","v":"-"}]

{"sheet":"l'Actif long terme","index":19,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"OPÉRATIONS PORTANT SUR L'ACTIF À LONG TERME / PRÉVISIONS DE RÉPARATIONS IMPORTANTES / "]
[null,"PRÉVISIONS DES NOUVEAUX PRÊTS À LONG TERME"]
[null,"Plans pour:",null,null,"au:"]
[]
[null,"Mois","Article","Achats d'actifs ","Vente ou échange","Coût"]
[null,null,null," à long terme","d'actifs à long terme"]
[null,null,null,null,null,{"$f":"D7-E7","v":0}]
[null,null,null,null,null,{"$f":"D8-E8","v":0}]
[null,null,null,null,null,{"$f":"D9-E9","v":0}]
[null,null,null,null,null,{"$f":"D10-E10","v":0}]
[null,null,null,null,null,{"$f":"D11-E11","v":0}]
[]
[null,"TOTAL",null,{"$f":"SUM(D7:D12)","v":0},{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0}]
[]
[null,"BUDGET PARTIEL"]
[]
[null,"Avantages",null,"Inconvénients"]
[]
[null,"Revenu annuel additionnel ",null,"Coûts annuels additionnels "]
[]
[]
[]
[]
[null,"Coûts annuels réduits ",null,"Revenu annuel réduit"]
[]
[]
[]
[null,"Total des advantages (A)",{"$f":"SUM(C18:C27)","v":0},"Total des inconvénients (B)",null,{"$f":"SUM(F18:F27)","v":0}]
[]
[null,"Variation estimée en profits agricoles annuels (A-B)",null,{"$f":"SUM(C28-F28)","v":0}]
[]
[]
[null,"Prêteur","Objectif","Taux d'intérêts","Intérêts annuel","Principal annuel"]
[]
[]
[]
[null,"Notes explicatives pour la planification"]
[null,null,null,null,null,null,null," "]