{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Vte directe","Viande","Saisie agneaux","Ovin-colis","Ovin-détail en magasin","Marge merguez","véhicule","Prix moyen de vente","Utilitaire"],"not_rendered":{"charts":4,"images":20,"macros":0,"external_links":6,"defined_names":676,"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":"Vte directe","index":0,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Effectif","Bio (Oui=1)","Carcasse","colis","AMAP","Magasin"]
[1,"Vaiser Didier","04150 SIMIANE-LA-ROTONDE",null,3,1,null,null,null,null,"BAILLY DIDIER","04170 THORAME HAUTE","Arrêt"]
[2,"PICO SERGE","04510 AIGLUN",null,18,1,null,null,null,null,"FLEUTOT FRANCOISE","04230 MONTLAUX","OL"]
[3,"PUIG JEAN","04410 ST JURS",null,18,1,null,null,null,null,"CHRISOSTOME MARIE-ELISABETH","04300 SAINT-MARTIN-LES-EAUX",null,165,1,1]
[4,"MEYNET ELISABETH","04300 SIGONCE",null,29,1,null,null,null,null,"GAEC des OLIVETTES","04000 DIGNE LES BAINS","Autres"]
[5,"KISTON Pierre","04310 GANAGOBIE",null,41,1,null,null,null,null,"MAGNIN Sébastien","04230 MONTLAUX","OL"]
[6,"GALFARD","Dargèle","ALLONS",76,0,null,1,null,null,"BISOGNO","Murielle","BEYNES",182,0,1]
[7,"MADANI Anissa","04200 SISTERON",null,82,1,null,1,null,null,"MOREUX PATRICK","04110 SAINT-CROIX-à-LAUZE","Caprins"]
[8,"SAINT-ROCH DIDIER","04200 AUTHON",null,90,1,null,1,null,null,"BERNE STEPHEN","04300 SAINT-MAIME"]
[9,"ARBEZ Cyril","04660 CHAMPTERCIER",null,90,1,null,null,null,null,"PREAU","Michel","ROUMOULES"]
[10,"BAYLE MICHELE","04700 LURS",null,95,1,null,null,null,null,"SCHAAL Florentin","04230 CRUIS","OL"]
[11,"VOYER","Noel","MOUSTIERS STE MARIE",108,0,null,1,null,null,"FERAUD Jean-Paul","04380 HAUTES DUVES",null,383,1,1]
[12,"JOLLY JEAN MICHEL","04410 SAINT-JURS",null,120,1,null,null,null,null,"ROUX Martine","04300 LIMANS","OL"]
[13,"PERAIN SILVIA","04150 REVEST-DES-BROUSSES",null,129,1]
[14,"GAEC LES GRANGES","04110 MONTFURON",null,129,1,null,1,null,null,"GASSEND ROLAND","04380 BARRAS","Autres"]
[15,"AGLIO YVES","04850 JAUSIERS",null,131,1,null,1]
[16,"MADANI KARIM","04200 CHATEAU-NEUF-MIRAVAIL",null,142,1,null,1,null,null,"L ETOILE DU BERGER","04140 LE-VERNET","OL"]
[17,"FERRARI","Benoit","BEYNES",145,0,null,1]
[18,"LOQUES CHRISTOPHE","04250 TURRIERS",null,160,1]
[19,"MERMET ISABELLE","04320 ENTREVAUX",null,160,1,null,null,null,null,"REYNAUD NICOLAS","04000 DIGNE LES BAINS","Pas de vente?"]
[20,"SCEA LE COLLET","04500 MONTAGNAC MONTPEZAT",null,171,1,null,1,null,null,"BERGERIE DE COSTEBELLE","04200 AUTHON"]
[21,"Stéphane GARAVAGNO","04170 THORAME-HAUTE",null,178,1,null,1,null,null,"EARL DE ST ANNE","04500 QUINSON"]
[22,"BONDIL VINCENT","04360 MOUSTIERS-SAINT-MARIE",null,200,1,null,1,1,null,"Franck Sauvecanne","04110 MONTFURON"]
[23,"GIRAUD CATHERINE","04230 CRUIS",null,215,1]
[24,"SCEA DE VAUBELLE","04300 PIERRERUE",null,225,1,null,1]
[25,"GAEC la ferme de bonnet","04200 AUTHON",null,237,1,null,1]
[26,"MONIER JOEL","04230 ONGLES",null,242,1]
[27,"CAUVIN","Christophe","CASTELLANE",244,0,null,1]
[28,"GAEC DU BOSQUET","04140 SELONNET",null,249,1,null,1]
[29,"GAEC DU PRA SIMON","GARINO Julien & Jacqueline","LA CONDAMINE",252,0,null,1]
[30,"PELESTOR PIERRE HENRI","04000 ENTRAGES",null,275,1,null,1]
[31,"GAEC Le Déoule","04340 LA-BRéOLE",null,280,1,null,1,1]
[32,"BEVALOT","Luc","BLIEUX",290,0,null,1]
[33,"RICHAUD","Hubert","SISTERON",300,0,null,null,null,1]
[34,"Moran Emilie","04200 VALERNES",null,301,1,null,1]
[35,"FAUDON JEAN-PHILIPPE","04380 HAUTES DUVES",null,310,1]
[36,"ASSOCIATION LONGO MAI","04300 LIMANS",null,320,1]
[37,"NICOLAS","François","FAUCON DU CAIRE",325,0,null,1]
[38,"GAEC DES BREISSAND","BREISSAND Cédric & André","Le CASTELLARD MELAN",380,0,null,1]
[39,"GAEC Clavelas",null,"ST MARTIN LES EAUX",410,0,null,1,1]
[40,"GAEC de Cordhelle","04500 ALLEMAGNE-EN-PROVENCE",null,436,1,null,1,1]
[41,"METERY","Sylvie","MONTAGNAC",454,0,null,1]
[42,"GAEC LA ROCHETTE","04300 FORCALQUIER",null,484,1,null,1,1]
[43,"LADRET AGNES","04150 LIMANS",null,507,1,null,1]
[44,"GAEC DU CLOS DE JALINES","UGHETTO, MIGLIORE, DOFF…","MARCOUX",550,0,null,null,null,1]
[45,"GAEC MONTAURIS","Guibert","MONTJUSTIN",570,0,null,1]
[46,"GUICHARD","Evelyne","LA PALUD SUR VERDON",570,0,null,1,null,null,null," "]
[47,"METERY","Annie","MONTAGNAC",573,0,null,1]
[48,"GAEC DE L'ESPERANCE","Ayasse","PIEGUT",662,0,null,1]
[49,"GAEC DU PRE DES POIRIERS","04200 NOYERS-SUR-JABRON",null,950,1,1]
[50,"GAEC DE PASCALONE","GAYDE Michel","RIEZ",1150,0,null,1]
[51,"GAEC DU MOURRE NEGRE","04280 CERESTE",null,1650,1,null,1]
[null,null,null,null,{"$f":"SUM(E2:E52)","v":15726},34,1,33,5,2]

{"sheet":"Viande","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"Prix couleurs paysannes","Etal 3 vallées"]
[null,null,null,null,null,"Bio GAEC Isoard"]
[null,"Gigot",{"$f":"$C$7*20%","v":{"$error":"#REF!"}},16,null,null,"16 (raccourci)"]
[null,"Epaule",{"$f":"$C$7*15%","v":{"$error":"#REF!"}},13.5,null,"15-18 (roulée)"]
[null,"cotellettes",{"$f":"$C$7*35%","v":{"$error":"#REF!"}},18,null,"20 (cote 2nde)","18-19"]
[null,"Selle-carré-collier",{"$f":"$C$7*30%","v":{"$error":"#REF!"}},10,null,"de 12 à 13",10]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(C3*D3+C4*D4+C5*D5+C6*D6)/C7","v":{"$error":"#REF!"}}]

{"sheet":"Saisie agneaux","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[[24,0,24,1]]}
[]
[null,null,"Saisissez ici vos chiffres",null,"Une moyenne locale pour vous aider"]
[null,"Poids moyen carcasse",16,null,16]
[null,"Prix moyen au kilo carcasse",5.5,5.5,5.5,"Prix moyen indicatif 2016"]
[null,"Nombre moyen d'agneaux par lot en vente directe",12,null,"5 à 15"]
[null,"Distance à l'abattoir (aller-retour)",80,null,80]
[null,"Prix abattage au kilo",0.92,null,0.92,"Prix abattoir de Digne 2016 (>2T)"]
[null,"Prix découpe au kilo (découpe normale en frais)",1.5,null,1.5,"Prix atelier de découpe Digne 2016 "]
[null,"% de perte à la découpe (normale en frais)",0.18,null,"10 à 20%","Attention très variable selon l'atelier, type d'agneau (engraissé/herbe) et type de découpe. A titre indicatif on peut prendre 16% pour une découpe normale et 18% en découpe barbecue,"]
[null,"Kilométrage moyen d'une livraison",200,null,"100 à 250 Km","Distance domicile - atelier de découpe - livraison et retour"]
[null,"Prix de revient du kilomètre pour amener les agneaux",0.45,null,{"$f":"véhicule!F38","v":0.44910000000000005},"Pour un calcul personnalisé allez à l'onglet \"véhicule\""]
[null,"Prix de revient du kilomètre pour livrer la viande",0.61,null,{"$f":"véhicule!F40","v":0.60576666666666668},"Pour un calcul personnalisé allez à l'onglet \"véhicule\""]
[null,"Frais généraux annuels",null,null,null,"Télephone, dépliants, site internet, place de marché…"]
[null,"Nombre de livraisons annuelles",10,null,10]
[null,"Temps moyen passé pour un lot de vente directe",13,null,13,"5h de transport + 2h de contact client + 2h abattoir + 4h commande et organisation tournée                Si vente en magasin: 2,5h de transport + 4h de permanence au magasin + 1h abattoir.\n"]
[null,"Prix de vente TTC au client",13,null,13]
[]
["A remplir uniquement si vous envisagez la vente en magasin:"]
[null,"% de frais de magasin",0.15,null,0.15,"En général entre 15 et 20%"]
[null,"Prix de vente moyen TTC d'un agneau en magasin",16,null,16,"Pour un calcul personnalisé allez à l'onglet \"Prix moyen de vente\""]
[null,"Prix de découpe au kilo (en détail sous-vide)",1.7,null,1.7,"Prix atelier de découpe Digne \"découpe sous-vide\""]
[null,"% de perte à la découpe en sous-vide",0.18,null,0.18,"Attention très variable selon lieu de découpe, type d'agneau (engraissé/herbe) et type de découpe. A titre indicatif on peut prendre 16% pour une découpe normale et 18% en découpe barbecue,"]
[]
[]
["Résultat de la saisie                                                                                                   (pour en savoir plus allez sur l'onglet correspondant):",null,"Vente en colis",null,"Vente détail en magasin"]
[null,"Marge par agneau",{"$f":"'Ovin-colis'!J31","v":19.508579778831006},null,{"$f":"'Ovin-détail en magasin'!J34","v":5.3368578199052195}]
[null,"Rémunération horaire de votre travail",{"$f":"'Ovin-colis'!J35","v":18.007919795844007},null,{"$f":"'Ovin-détail en magasin'!J38","v":2.0526376230404688}]

{"sheet":"Ovin-colis","index":3,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,17],[28,4,28,6],[34,1,34,4],[34,5,34,8],[34,10,34,12],[22,12,22,14]]}
[null,"CALCUL DE LA MARGE VENTE DIRECTE PAR AGNEAU ET DE LA REMUNERATION DE VOTRE TRAVAIL"]
[null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de l'agneau",{"$f":"J6","v":88},{"$f":"W4/$W$9","v":0.51594746716697926}]
[null,null,null,null,null,"Poids moyen",null,"agriculteur/sinstaller-dans-les-alpes-de-haute-provence/",null,"Prix agneau",null,null,null,null,null,null,null,null,null,null,null,"Transport",{"$f":"J9+J18","v":13.166666666666666},7.7196685428392725E-2]
[null,"Agneau vendu carcasse via cheville",null,null,null,{"$f":"'Saisie agneaux'!C3","v":16},"x",{"$f":"'Saisie agneaux'!C4","v":5.5},"=",{"$f":"F6*H6","v":88},null,null,null,null,null,null,null,null,null,null,null,"Abattage-découpe",{"$f":"J12+J15","v":38.72},0.22701688555347088]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null," ",null,null,null,null,null,"TVA et divers",{"$f":"J21+J28*Utilitaire!B2+J22","v":11.16475355450237},6.5459389977148036E-2]
[null,null,null,"Distance abattoir (AR)",null,"Prix du Km",null,"Nombre d'agneaux",null,"Frais transport vif",null,null,null,null,null,null,null,null,null,null,null,"Marge",{"$f":"J31","v":19.508579778831006},0.11437957187400916]
[null,"Frais de transport en vif",null,{"$f":"'Saisie agneaux'!C6","v":80},"x",{"$f":"'Saisie agneaux'!C11","v":0.45},":",{"$f":"'Saisie agneaux'!C5","v":12},"=",{"$f":"IF(H9=0,0,F9*D9/H9)","v":3},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W4:W8)","v":170.56000000000003},1]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Frais abattage"]
[null,"Frais d'abattage",null,null,null,{"$f":"F6","v":16},"x",{"$f":"'Saisie agneaux'!C7","v":0.92},"=",{"$f":"F12*H12","v":14.72}]
[null,null,null,null,null,null,null,null,null,"+",null,null," "]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Frais découpe"]
[null,"Frais de découpe",null,null,null,{"$f":"F6","v":16},"x",{"$f":"'Saisie agneaux'!C8","v":1.5},"=",{"$f":"F15*H15","v":24}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,"Distance client (AR)",null,"Prix du Km",null,"Nombre d'agneaux",null,"Frais transport viande"]
[null,"Frais de transport en caissette",null,{"$f":"'Saisie agneaux'!C10","v":200},"x",{"$f":"'Saisie agneaux'!C12","v":0.61},":",{"$f":"H9","v":12},"=",{"$f":"IF(H18=0,0,F18*D18/H18)","v":10.166666666666666}]
[null," ",null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,"Frais totaux",null,"Nombre d'agneaux",null,"Frais divers"]
[null,"Frais généraux (dépliants, téléphone, place…)",null,null,null,{"$f":"'Saisie agneaux'!C13","v":0},":",{"$f":"'Saisie agneaux'!C5*'Saisie agneaux'!C14","v":120},"=",{"$f":"IF(H21=0,0,F21/H21)","v":0}]
[null,"Taxes Interbev & redevances spécifiques à la vente directe",null,null,null,null,null,null,"=",{"$f":"0.128*F6+0.225","v":2.2730000000000001}]
[null,null,null,null,null,null,null,null,null,"=",null,null,"Kilomètre par agneau:",null,null,{"$f":"(D18+D9)/H9","v":23.333333333333332}]
[null,null,null,null,null,null,null,null,null,"Cout total agneau"]
[null,"Cout total de l'agneau HT (sans votre travail)",null,null,null,null,null,null,"=",{"$f":"J6+J9+J12+J15+J18+J21+J22","v":142.15966666666665}]
[]
[null,null,null,null,null,"Poids viande client",null,"Prix au kilo",null,"Prix de vente HT client"]
[null,"Prix de vente HT client",null,null,null,{"$f":"'Saisie agneaux'!C3*(1-'Saisie agneaux'!C9)","v":13.120000000000001},"x",{"$f":"'Saisie agneaux'!C16/(1+Utilitaire!B2)","v":12.322274881516588},"=",{"$f":"F28*H28","v":161.66824644549766}]
[null,null,null,null,{"$f":"'Saisie agneaux'!C9","v":0.18},null,null,{"$f":"'Saisie agneaux'!C16","v":13},null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Marge par agneau"]
[null,"Marge \"vente directe\" par agneau",null,null,null,null,null,null,"=",{"$f":"J28-J25","v":19.508579778831006}]
[]
[null,null,null,null,null,"Temps de travail par lot",null,"Nombre d'agneaux",null,"Temps de travail par agneau"]
[null,"Temps de travail par agneau (en minutes)",null,null,null,{"$f":"'Saisie agneaux'!C15","v":13},":",{"$f":"H18","v":12},"=",{"$f":"IF(H34=0,0,60*F34/H34)","v":65}]
[null,null,null,null,null,"Soit une rémunération horaire de votre travail à",null,null,null,{"$f":"IF(J34=0,0,60*J31/J34)","v":18.007919795844007},{"$f":"100*J35/Utilitaire!B3","v":186.2246100914582}]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Ovin-détail en magasin","index":4,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,12,25,14],[0,1,0,17],[31,4,31,6],[37,1,37,4],[37,5,37,8],[37,10,37,12]]}
[null,"CALCUL DE LA MARGE VENTE DIRECTE PAR AGNEAU ET DE LA REMUNERATION DE VOTRE TRAVAIL"]
[null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de l'agneau",{"$f":"J6","v":88},{"$f":"W4/$W$10","v":0.41920731707317077}]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Prix agneau",null,null,null,null,null,null,null,null,null,null,null,"Transport",{"$f":"J9+J18","v":31.599999999999998},0.15053353658536586]
[null,"Agneau vendu carcasse via cheville",null,null,null,{"$f":"'Saisie agneaux'!C3","v":16},"x",{"$f":"'Saisie agneaux'!C4","v":5.5},"=",{"$f":"F6*H6","v":88},null,null,null,null,null,null,null,null,null,null,null,"Abattage-découpe",{"$f":"J12+J15","v":41.92},0.19969512195121952]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null," ",null,null,null,null,null,"TVA et divers",{"$f":"J21+J31*5.5%+J22","v":13.216696682464455},6.2960635873020462E-2]
[null,null,null,"Distance abattoir (AR)",null,"Prix du Km",null,"Nombre d'agneaux",null,"Frais transport vif",null,null,null,null,null,null,null,null,null,null,null,"Frais de magasin",{"$f":"J25","v":29.846445497630331},0.14218009478672985]
[null,"Frais de transport en vif",null,{"$f":"'Saisie agneaux'!C6","v":80},"x",{"$f":"'Saisie agneaux'!C11","v":0.45},":",5,"=",{"$f":"IF(H9=0,0,F9*D9/H9)","v":7.2},null,null,null,null,null,null,null,null,null,null,null,"Marge",{"$f":"J34","v":5.3368578199052195},2.5423293730493617E-2]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W4:W9)","v":209.92},{"$f":"SUM(X4:X9)","v":1.0000000000000002}]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Frais abattage"]
[null,"Frais d'abattage",null,null,null,{"$f":"F6","v":16},"x",{"$f":"'Saisie agneaux'!C7","v":0.92},"=",{"$f":"F12*H12","v":14.72}]
[null,null,null,null,null,null,null,null,null,"+",null,null," "]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Frais découpe"]
[null,"Frais de découpe",null,null,null,{"$f":"F6","v":16},"x",{"$f":"'Saisie agneaux'!$C$21","v":1.7},"=",{"$f":"F15*H15","v":27.2}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,"Distance client (AR)",null,"Prix du Km",null,"Nombre d'agneaux",null,"Frais transport viande"]
[null,"Frais de transport en caissette",null,{"$f":"'Saisie agneaux'!C10","v":200},"x",{"$f":"'Saisie agneaux'!C12","v":0.61},":",{"$f":"H9","v":5},"=",{"$f":"IF(H18=0,0,F18*D18/H18)","v":24.4}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,"Frais totaux annuel",null,"Nombre d'agneaux",null,"Frais généraux"]
[null,"Frais généraux (dépliants, téléphone, place…)",null,null,null,{"$f":"'Saisie agneaux'!C13","v":0},":",{"$f":"'Saisie agneaux'!C5*'Saisie agneaux'!C14","v":120},"=",{"$f":"IF(H21=0,0,F21/H21)","v":0}]
[null,"Taxes Interbev & redevances spécifiques à la vente directe",null,null,null,null,null,null,"=",{"$f":"0.128*F6+0.225","v":2.2730000000000001}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,"Prix de vente HT client",null,"% de frais",null,"Frais de magasin"]
[null,"Frais de magasin",null,null,null,{"$f":"J31","v":198.97630331753555},"x",{"$f":"'Saisie agneaux'!C19","v":0.15},"=",{"$f":"F25*H25","v":29.846445497630331}]
[null,null,null,null,null,null,null,null,null,"=",null,null,"Kilomètre par agneau:",null,null,{"$f":"(D18+D9)/H9","v":56}]
[null,null,null,null,null,null,null,null,null,"Cout total agneau"]
[null,"Cout total de l'agneau HT (sans votre travail)",null,null,null,null,null,null,"=",{"$f":"J6+J9+J12+J15+J18+J21+J25+J22","v":193.63944549763033}]
[]
[null,null,null,null,null,"Poids viande client",null,"Prix au kilo",null,"Prix de vente HT client"]
[null,"Prix de vente HT client",null,null,null,{"$f":"'Saisie agneaux'!C3*(1-'Saisie agneaux'!C9)","v":13.120000000000001},"x",{"$f":"'Saisie agneaux'!C20/(1+Utilitaire!B2)","v":15.165876777251185},"=",{"$f":"F31*H31","v":198.97630331753555}]
[null,null,null,null,{"$f":"'Saisie agneaux'!$C$22","v":0.18},null,null,{"$f":"'Saisie agneaux'!$C$20","v":16}]
[null,null,null,null,null,null,null,null,null,"Marge par agneau"]
[null,"Marge \"vente directe\" par agneau",null,null,null,null,null,null,"=",{"$f":"J31-J28","v":5.3368578199052195}]
[]
[null,null,null,null,null,"Temps de travail par lot",null,"Nombre d'agneaux",null,"Temps de travail par agneau"]
[null,"Temps de travail par agneau (en minutes)",null,null,null,{"$f":"'Saisie agneaux'!C15","v":13},":",{"$f":"H18","v":5},"=",{"$f":"IF(H37=0,0,60*F37/H37)","v":156}]
[null,null,null,null,null,"Soit une rémunération horaire de votre travail à",null,null,null,{"$f":"IF(J37=0,0,60*J34/J37)","v":2.0526376230404688},{"$f":"100*J38/Utilitaire!B3","v":21.226862699487786}]

{"sheet":"Marge merguez","index":5,"n_rows":36,"n_cols":28,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,10],[21,12,21,14],[30,4,30,6],[33,1,33,4],[33,5,33,8]]}
[null,"CALCUL DE LA MARGE VENTE DIRECTE BREBIS TRANSFORMEE EN MERGUEZ"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de la brebis",{"$f":"J7","v":30},{"$f":"W5/$W$10","v":0.18239285738621139}]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Prix par brebis",null,null,null,null,null,null,null,null,null,null,null,"Transport",{"$f":"J10+J24","v":0},0]
[null,"Brebis vendue carcasse via cheville",null,null,null,25,"x",1.2,"=",{"$f":"F7*H7","v":30},null,null,null,null,null,null,null,null,null,null,null,"Abattage-découpe-transformation",{"$f":"J21-J20","v":113.52083333333333},0.69017963881768452]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,null,null,null,null,null,"TVA et divers",{"$f":"J20+J27*5.5%","v":11.507020833333334},6.9959946993144326E-2]
[null,null,null,"Distance abattoir (AR)",null,"Prix du Km",null,"Nombre de brebis",null,"Frais transport vif",null,null,null,null,null,null,null,null,null,null,null,"Marge",{"$f":"J33","v":9.4522709320695526},5.7467556802959771E-2]
[null,"Frais de transport en vif",null,{"$f":"'Saisie agneaux'!C6","v":80},"x",0,":",3,"=",{"$f":"IF(H10=0,0,F10*D10/H10)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W5:W9)","v":164.48012509873621},1]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,"Poids moyen",null,"Prix au kilo",null,"Frais abattage & transformation"]
[null,"Frais d'abattage",null,null,null,{"$f":"F7","v":25},"x",0.92,"=",{"$f":"F13*H13","v":23}]
[null,"Frais de désossage",null,null,null,{"$f":"F7","v":25},"x",1.1499999999999999,"=",{"$f":"F14*H14","v":28.749999999999996}]
[null,null,null,"Perte au desossage:",0.45]
[null,"Frais de fabrication",null,null,null,{"$f":"$F$7*(1-$E$15)","v":13.750000000000002},"x",3.5,"=",{"$f":"F16*H16","v":48.125000000000007}]
[null,"Frais de conditionnement",null,null,null,{"$f":"F16","v":13.750000000000002},"x",0.75,"=",{"$f":"F17*H17","v":10.312500000000002}]
[null,"Autres frais (ingrédients fournis…)",null,null,null,null,"x",null,"=",{"$f":"F18*H18","v":0}]
[null,"Frais fixe ( 1 analyse par lot)",null,null,null,null,null,10,"=",{"$f":"H19/H10","v":3.3333333333333335}]
[null,"Cotisation Interbev et redevances spécifiques vente directe",null,null,null,null,null,null,null,{"$f":"0.128*F13+0.225","v":3.4250000000000003}]
[null,null,null,null,null,null,null,"Soit au total",null,{"$f":"SUM(J13:J20)","v":116.94583333333333}]
[null,null,null,null,null,null,null,null,null,{"$f":"J21/F16","v":8.505151515151514}]
[null,null,null,"Distance client (AR)",null,"Prix du Km",null,"Nombre de brebis",null,"Frais transport viande"]
[null,"Frais de transport en caissette",null,{"$f":"'Saisie agneaux'!C10","v":200},"x",0,":",{"$f":"H10","v":3},"=",{"$f":"IF(H24=0,0,F24*D24/H24)","v":0}]
[null,null,null,null,null,null,null,null,null,"="]
[null,null,null,null,null,null,null,null,null,"Cout total brebis"]
[null,"Cout total de la brebis HT (sans votre travail)",null,null,null,null,null,null,"=",{"$f":"J7+J10+J21+J24","v":146.94583333333333}]
[]
[null,null,null,null,null,"Poids viande client",null,"Prix au kilo",null,"Prix de vente HT client"]
[null,"Prix de vente HT client",null,null,null,{"$f":"F16","v":13.750000000000002},"x",{"$f":"H31/1.055","v":11.374407582938389},"=",{"$f":"F30*H30","v":156.39810426540288},null,null,null,null,null,null,null,null,null,null,null,"Non comptées taxes\"élevage\" qui sont déduites également si vente négoce",null,null,null,null,{"$f":"0.019*F7","v":0.47499999999999998},"par bête"]
[null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxes spécifiques abattage découpe en cas de vente directe",null,null,null,null,{"$f":"0.225+0.147*F7","v":3.9},"par bête"]
[null,null,null,null,null,null,null,null,null,"Marge par brebis",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecart",null,null,{"$f":"AA31-AA30","v":3.4249999999999998}]
[null,"Marge \"vente directe\" par brebis",null,null,null,null,null,null,"=",{"$f":"J30-J27","v":9.4522709320695526}]
[]
[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,null," "]

{"sheet":"véhicule","index":6,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,0,2,3],[20,0,20,3],[28,0,28,4],[37,0,37,4],[39,0,39,4]]}
[null,null,"CALCUL DU PRIX DE REVIENT KILOMETRIQUE DES TRANSPORTS EN VENTE DIRECTE"]
[]
["Prix de revient au km du véhicule de traction:"]
[]
[null,"Prix HT véhicule (déduire reprise ou revente)",null,null,15000]
[]
[null,"Durée de vie prévisionnelle du véhicule (an)",null,null,12,null,"Frais kilométrique d'amortissement du véhicule: ",{"$f":"E5/(E7*E9)","v":8.3333333333333329E-2}]
[]
[null,"Nombre total de km par an",null,null,15000]
[]
[null,"Consommation moyenne / 100 km",null,null,8]
[null,null,null,null,null,null,"Frais kilométrique de carburant du véhicule: ",{"$f":"E11*E13/100","v":9.1999999999999998E-2},null,"Total",{"$f":"H7+H12+H17","v":0.28910000000000002}]
[null,"Prix moyen du carburant HT",null,null,1.1499999999999999]
[]
[null,"Frais annuels d'entretien et pneus",null,null,1000]
[]
[null,"Frais annuels d'assurances",null,null,500,null,"Autres frais kilométrique du véhicule: ",{"$f":"(E15+E17+E19)/E9","v":0.11376666666666667}]
[]
[null,"Frais divers annuels ( 5%)",null,null,{"$f":"0.05*(((E5/E7))+(E11*E9*E13/100)+E15+E17)","v":206.5}]
[]
["Prix de revient au km de la bétaillère:"]
[]
[null,"Prix HT bétaillère (déduire reprise ou revente)",null,null,3000]
[]
[null,"Durée de vie prévisionnelle du véhicule (an)",null,null,15,null,"Frais kilométrique de la bétaillère (incluant 20% de frais divers): ",null,null,"Total",{"$f":"1.2*E23/(E25*E27)","v":0.16}]
[]
[null,"Nombre total de km par an",null,"(Km pour la vente directe et les autres usages)",1500]
[]
["Prix de revient au km du caisson réfrigéré ou isotherme:"]
[]
[null,"Prix HT du caisson (déduire reprise ou revente)",null,null,9500]
[]
[null,"Durée de vie prévisionnelle du véhicule (an)",null,null,12,null,"Frais kilométrique du caisson (incluant 20% de frais divers): ",null,null,"Total",{"$f":"1.2*E31/(E33*E35)","v":0.31666666666666665}]
[]
[null,"Nombre total de km par an",null,null,3000]
[]
[]
["Prix de revient au km du transport en vif:",null,null,null,null,{"$f":"K12+K25","v":0.44910000000000005}]
[]
["Prix de revient au km du transport de la viande:",null,null,null,null,{"$f":"K12+K33","v":0.60576666666666668}]

{"sheet":"Prix moyen de vente","index":7,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,2,0,9]]}
[null,null,"Calcul de valorisation d'une carcasse à partir du prix de vente au détail de différents morceaux"]
[]
[null,null,null,null,"Répartition des morceaux","Poids des morceaux","Prix unitaire TTC","% invendus","Poids vendu","Prix total TTC"]
["Morceaux nobles (côtes, gigot tranché)",null,null,null,0.45,{"$f":"F7*E4","v":5.9040000000000008},19.5,0,{"$f":"F4*(1-H4)","v":5.9040000000000008},{"$f":"I4*G4","v":115.12800000000001}]
["Epaules roulées",null,null,null,0.15,{"$f":"F7*E5","v":1.968},17.5,0,{"$f":"F5*(1-H5)","v":1.968},{"$f":"I5*G5","v":34.44}]
["Autres morceaux (selle, collier, souris…)",null,null,null,0.4,{"$f":"F7*E6","v":5.2480000000000011},11.5,0,{"$f":"F6*(1-H6)","v":5.2480000000000011},{"$f":"I6*G6","v":60.352000000000011}]
[null,null,null,"Total:",{"$f":"E4+E5+E6","v":1},{"$f":"'Ovin-détail en magasin'!F31","v":13.120000000000001},null,null,{"$f":"I4+I6+I5","v":13.120000000000001},{"$f":"J4+J6+J5","v":209.92000000000002}]
[]
[null,null,null,null,null,null,"Soit un prix moyen de vente TTC de:",null,null,{"$f":"J7/F7","v":16}]
[]
[" "]

{"sheet":"Utilitaire","index":8,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["Taux de TVA",5.5E-2]
["SMIC horaire brut 2015",9.67]