{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RR-Bailli"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"RR-Bailli","index":0,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[23,14,23,17],[23,12,24,12],[22,0,23,1],[59,0,59,1],[58,0,58,1],[23,2,23,5],[23,6,23,11],[23,13,24,13],[16,0,17,1],[16,11,17,11],[16,6,16,7],[13,11,13,12],[16,10,17,10],[16,2,16,3],[16,4,16,5],[16,8,16,9],[16,12,16,13],[0,13,0,15],[2,15,4,15],[13,5,13,6],[8,1,8,6],[2,11,4,11],[0,10,0,12],[2,14,4,14],[8,7,8,12],[12,5,12,6],[9,5,9,6],[10,12,11,12],[9,11,9,12],[12,11,12,12],[10,6,11,6]]}
[null,null,null,null,null,null,null,null,null,null,"Ble",null,null,"Mais"]
["VENTE","Animaux d'hier après achat","Animaux d'aujourd'hui avant achat","Animaux d'aujourd'hui après achat","Animaux vendu","Prix de vente (HT)","Gains",null,"DONNEES DE BASES","Nourriture","Sacs/bete","Prix du sac (HT)","achats par multiple de","Sacs/bete","Prix du sac (HT)","achats par multiple de"]
["Vaches",30,null,{"$f":"C3+B11+H11","v":0},{"$f":"(B3)-(C3)","v":30},45,{"$f":"(E3)*(F3)","v":1350},{"$f":"C3*F3","v":0},"Vaches","blé",3,12.2,1,11.25,3.25,4]
["Moutons",29,null,{"$f":"C4+B12+H12","v":0},{"$f":"(B4)-(C4)","v":29},35,{"$f":"(E4)*(F4)","v":1015},{"$f":"C4*F4","v":0},"Moutons","blé",2.33,null,3,8.75]
["Cochons",31,null,{"$f":"C5+B13+H13","v":0},{"$f":"(B5)-(C5)","v":31},25,{"$f":"(E5)*(F5)","v":775},{"$f":"C5*F5","v":0},"Cochons","mais",1.67,null,49,6.25]
[null,null,null,null,"TOTAL",{"$f":"(G3)+(G4)+(G5)","v":3140},null,{"$f":"SUM(H3:H5)","v":0},null,null,null,12.6,null,null,3.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cases à remplir tous les jours avec les données IG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formule à copier/coller chaque jour (valeurs)"]
[null,"Blé",null,null,null,null,null,"Mais",null,null,null,null,null,null,null,"Cases à vérifier et modifier si modification"]
["ACHAT","Animaux crées","Sacs/bete","Prix du sac","Cout des betes","Nombre de sacs",null,"Animaux crées","Sacs/bete","Prix du sac","Cout des betes","Nombre de sacs",null,null,null,{"$f":"A23","v":"BILAN PAR MANDAT"},"coût par PE (écus)","ratio nb embauche 10 pe/20 pe","ratio nb PE par embauche","Différence\n(écus)"]
["Vaches",null,{"$f":"K3","v":3},{"$f":"L3","v":12.2},{"$f":"(B11)*(C11)*(D11)","v":0},{"$f":"(B11)*(C11)","v":0},{"$f":"SUM(F11:F12)","v":0},null,{"$f":"N3","v":11.25},{"$f":"O3","v":3.25},{"$f":"(H11)*(I11)*(J11)","v":0},{"$f":"(H11)*(I11)","v":0},{"$f":"SUM(L11:L12)","v":0},null,null,"Arthurdayne",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}}]
["Moutons",null,{"$f":"K4","v":2.33},{"$f":"L3","v":12.2},{"$f":"(B12)*(C12)*(D12)","v":0},{"$f":"(B12)*(C12)","v":0},null,null,{"$f":"N4","v":8.75},{"$f":"O3","v":3.25},{"$f":"(H12)*(I12)*(J12)","v":0},{"$f":"(H12)*(I12)","v":0},null,null,null,"Gothyra 1",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q12-Q11)*SUM(#REF!)","v":{"$error":"#REF!"}}]
["Cochons",null,{"$f":"K5","v":1.67},{"$f":"L3","v":12.2},{"$f":"(B13)*(C13)*(D13)","v":0},{"$f":"(B13)*(C13)","v":0},null,null,{"$f":"N5","v":6.25},{"$f":"O3","v":3.25},{"$f":"(H13)*(I13)*(J13)","v":0},{"$f":"(H13)*(I13)","v":0},null,null,null,"Gothyra 2",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q13-Q11)*SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,"TOTAL",{"$f":"(E11)+(E12)+(E13)","v":0},{"$f":"SUM(F11:F13)","v":0},null,null,null,"TOTAL",{"$f":"(K11)+(K12)+(K13)","v":0},{"$f":"SUM(L11:L13)","v":0},null,null,null,"Jojo4900 1",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q14-Q13)*SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jojo4900 2",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q15-Q13)*SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gothyra 3",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q16-Q15)*SUM(#REF!)","v":{"$error":"#REF!"}}]
["BENEFICE NET PAR JOUR",null,"Coûts (nb sacs)",null,"Vache (nb)",null,"Moutons (nb)",null,"Cochons (nb)",null,"Bénéfices (écus)","Valeur Cheptel","Hauts fonctionnaires",null,null,"Gothyra 4",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q17-Q15)*SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,"Blé","Mais","Vente","Achat","Vente","Achat","Vente","Achat",null,null,"nb 20pe","nb 10pe",null,"Jojo4900 3",{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)/SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"(Q18-Q17)*SUM(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"TODAY()","v":"2018-07-03"},{"$f":"TEXT(A19,\"jjjj\")","v":"mardi"},{"$f":"$F$14","v":0},{"$f":"$L$14","v":0},{"$f":"$E$3","v":30},{"$f":"$B$11+$H$11","v":0},{"$f":"$E$4","v":29},{"$f":"$B$12+$H$12","v":0},{"$f":"$E$5","v":31},{"$f":"$B$13+$H$13","v":0},{"$f":"($G$3)-($E$11)-$K$11+($G$4)-($E$12)-$K$12+($G$5)-($E$13)-$K$13","v":3140},{"$f":"$D$3*$F$3+$D$4*$F$4+$D$5*$F$5","v":0}]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
["BILAN PAR MANDAT",null,{"$f":"$E$3","v":30},{"$f":"$E$4","v":29},{"$f":"$E$5","v":31},{"$f":"$G$3+$G$4+$G$5","v":3140},{"$f":"$B$11+$H$11","v":0},{"$f":"$B$12+$H$12","v":0},{"$f":"$B$13+$H$13","v":0},{"$f":"$F$14","v":0},{"$f":"$L$14","v":0},{"$f":"$J$23*$L$3+$K$23*$O$3","v":0},{"$f":"($G$3)-($E$11)-$K$11+($G$4)-($E$12)-$K$12+($G$5)-($E$13)-$K$13","v":3140},{"$f":"$D$3*$F$3+$D$4*$F$4+$D$5*$F$5","v":0},{"$f":"P23*25+Q23*20","v":0},{"$f":"$M$19","v":0},{"$f":"$N$19","v":0},{"$f":"P23*20+Q23*10","v":0}]
[null,null,"VENTE",null,null,null,"ACHAT",null,null,null,null,null,"Bénéfices (écus)","Valeur Cheptel (écus)","HAUTS FONCTIONNAIRES"]
["Date","Jour","Nb Vache","Nb Mouton","Nb Cochon","écus","Nb Vache","Nb Mouton","Nb Cochon","Blé\n(nb sacs)","Mais \n(nb sacs)","écus",null,null,"Coûts embauche","Nb embauche 20PE","Nb embauche 10PE","Nb PE",null,null,null,386.05]
["2018-07-02",{"$f":"TEXT(A26,\"jjjj\")","v":"lundi"},15,21,14,1760,15,21,16,93.93,100,1470.9459999999999,289.05400000000009,3140,0,0,0,0]
["2018-07-03",{"$f":"TEXT(A27,\"jjjj\")","v":"mardi"}]
["2018-07-04","mercredi"]
["2018-07-05","jeudi"]
["2018-07-06","vendredi"]
["2018-07-07","samedi"]
["2018-07-08","dimanche"]
["2018-07-09","lundi"]
["2018-07-10","mardi"]
["2018-07-11","mercredi"]
["2018-07-12","jeudi"]
["2018-07-13","vendredi"]
["2018-07-14","samedi"]
["2018-07-15","dimanche"]
["2018-07-16","lundi"]
["2018-07-17","mardi"]
["2018-07-18","mercredi"]
["2018-07-19","jeudi"]
["2018-07-20","vendredi"]
["2018-07-21","samedi"]
["2018-07-22","dimanche"]
["2018-07-23","lundi"]
["2018-07-24","mardi"]
["2018-07-25","mercredi"]
["2018-07-26","jeudi"]
["2018-07-27","vendredi"]
["2018-08-28","mardi"]
["2018-07-29","dimanche"]
["2018-07-29","dimanche"]
["2018-07-30","lundi"]
["2018-07-31","mardi"]
[]
[]
["TOTAL"]
["moyenne journalière"]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]