{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["FF.12-Nota","Nota.Worksheet","FF.12.Foies.de.volaille.VQRit","FF.12.Modèle.vierge","Vocabulaire","Poids fruits et légumes","ORT","utilitaires"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FF.12-Nota","index":0,"n_rows":107,"n_cols":28,"rows_kept":107,"cut":false,"hidden":false,"merged":[[105,2,105,10],[106,1,106,21],[57,21,59,24],[47,3,47,9],[47,11,50,14],[47,16,50,19],[47,21,47,24],[48,2,56,2],[48,21,48,24],[50,21,53,24],[51,16,55,19],[52,11,55,14],[54,21,56,24],[0,2,2,14],[0,18,1,20],[0,23,1,25],[0,26,1,28],[6,27,7,28],[40,27,41,28]]}
[null,null,"Modèles avec Mises en formes Conditionnelles Excel .xlsm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FF-12",null,null,null,null,"VERSION E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restauration avec MFC",null,null,null,null,"dernière mise à jour : 17 Février 2022"]
[null,null,{"$f":"\"Page \"&_xlfn.SHEET()&\" sur \"&_xlfn.SHEETS()","v":"Page 1 sur 8"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mise en Forme Conditionnelle",null,null,null,null,"annule ou remplace les versions précédentes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FF = Fiche de Fabrication"]
[]
[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,"Union des Professionnels de la Restauration Territoriale - UPRT.FR"]
[null,"l’uprt la diffusion des savoirs – le partage des savoirs faire"]
[]
[null," Madame....Monsieur..Bonjour...et ...Bienvenue dans nos documents"]
[]
[null,"C’est prouvé : donner rendrait plus heureux que recevoir"]
[null,"Partager son savoir-faire ses savoirs d’expérience"]
[]
[null,"La conception de documents (qui suppose une diversité de connaissances) est chronophage"]
[null,"et les recherches sur le net le sont également"]
[]
[null,"Nous vous proposons dans ce document"]
[null,"des savoirs d'expérience,que nous avons acquis tout au long de notre parcours professionnel en restauration collective"]
[null,"des liens et des savoirs de passionnés qui les ont diffusés sur le net"]
[null,"(nous citons toujours leurs Auteurs et ajoutons des liens qui permettent de retrouver leurs documents)"]
[]
[null,"CONTENU DU CLASSEUR"]
[]
[null,null,"FF.12.Foies.de.volaille.VQRit"]
[null,null,"FF.12.Modèle.vierge"]
[null,null,"Vocabulaire"]
[null,"u","Poids fruits et légumes"]
[null,null,"ORT"]
[null,null,"utilitaires"]
[]
[]
[null,"Nous vous en souhaitons une bonne utilisation - peut être trouverez vous une \"pépite\" qui vous rendra service...c'est là tout notre souhait"]
[]
[null,"Transmettez vos savoirs faire  peu importe qui les récupèrent ; pourvu qu'un plus grand nombre puisse en bénéficier."]
[null,"Joël LEBOUCHER …Octobre 2019"]
[]
[]
[]
[null,"Comment utiliser les tableaux :",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,"vous pouvez dupliquer la feuille mais vous pouvez aussi copier / coller des petits tableaux dans vos feuilles . Comment"]
[null,null,"choisissez le tableau qui vous convient "]
[null,null,"comment le copier : en cliquant sur la cellule",null,null,null,null,null,null,null,null,"ICI"," en descendant et en vous déportant vers la droite vous sélectionnez le document"]
[null,null,"clic droit : Copier….allez sur votre feuille excel puis clic droit Coller"]
[null,null,"des colonnes et les lignes ont été fusionnées pour cela"]
[]
[null,null,"ICI","colonnes fusionnées",null,null,null,null,null,null,null,"Avant de saisir quoi que ce soit dans une cellule cliquez dessus pour vérifier qu'il n'y ait pas de formule",null,null,null,null,"les valeurs #DIV/0!  indiquent seulement que les recettes sont \"vierges\" sur la feuille de saisie ",null,null,null,null,"POUR LES FICHES RECETTES A LA PORTION"]
[null,null,"lignes fusionnées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l'Auteur a prévu la recette pour "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Adultes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Nb de portions Si vous estimez que les grammages sont trop ou pas assez copieux pour vos convives : modifiez les prévisions de l'Auteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"si vous n'utilisez pas toutes les lignes vous pouvez masquer cette valeur par une couleur de police BLANC"]
[null,null,null,null,null,null,null,null,null,null,null,"Pour imprimer : sélectionnez les recettes qui vous conviennent : définir la zone d'impression -Mise à l'échelle : Ajuster la feuille à 1 page"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pas assez copieux : diminuez le nombre de portions cela augmentera les grammages à la portion "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trop copieux : augmentez le nombre de portions cela diminuera les grammages à la portion"]
[]
[]
[]
[]
[null,"Quelques polices de caractères utilisées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quelques formats utilisés"]
[null,null,"Arial",null,"Calibri",null,"Rockwell",null,null,"Verdana",null,null,null,null,null,null,"15.5 >",null,15.5,null,15.5,null,15.5]
[null,null,"ARIAL",null,"CALIBRI",null,"ROCKWELL",null,null,"VERDANA",null,null,null,null,null,null,"personnalisés >",null,"0.000\" Kg\"",null,"0\" %\"",null,"Monétaire"]
[]
[null,"Autres polices à découvrir"]
[null,null,"ARIAL NARROW    Arial Narrow",null,null,null,null,"COMIC SANS MF  Comic Sans MF",null,null,null,null,null,null,null,"GIL SANS MT  Gill Sans MT",null,null,null,null,null,"PALATINO LINOTYPE  Palatino Linotype"]
[null,null,"TAHOMA   Tahoma",null,null,null,null,"TIMES NEW ROMAN Times New Roman",null,null,null,null,null,null,null,"TRBUCHET MF  Trébuchet MF",null,null,null,null,null,"TW CEN MT  Tw Cen MT"]
[null,null,"VRINDA   Vrinda"]
[null,"Une numérotation avec couleur de police modifiable"]
[null,null,"❶","❷","❸","❹","❺","❻","❼","❽","❾","❿","⓫","⓬","⓭","⓮","⓯","⓰","⓱","⓲","⓳","⓴"]
[]
[null,null,"❶","❷","❸","❹","❺","❻","❼","❽","❾","❿","⓫","⓬","⓭","⓮","⓯","⓰","⓱","⓲","⓳","⓴"]
[]
[null,null,1,"2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[null,null,"⓪①②③④⑤⑥⑦⑧⑨⑩⑪⑫⑬⑭⑮⑯⑰⑱⑲⑳",null,null,null,null,null,null,null,null,"couleur de police blanc sur fond gris à modifier pour vos documents"]
[null,null,"cliquez sur la colonne  C et sélectionnez dans la barre le numéro qui vous intéresse"]
[null,null,"⓿❶❷❸❹❺❻❼❽❾❿⓫⓬⓭⓮⓯⓰⓱⓲⓳⓴"]
[]
[null,"des caractères spéciaux"]
[null,"!","\"","#","$","%","&","@","‰","≈","±","»","¼","½","¾","ø","►","◄","▲","▼","Φ"]
[]
[null,null,"0.00\\ \" cm³\"",null,null,"Format | cellule | personnalisé | 0\" cm³\""]
[null,null,3]
[null,null,null,null,null,null,null,"ou copier-coller",null,null,null,null,null,"X","t","u"]
[null,null,"le ² se fait en tapant alt+0178",null,null,null,null,"m² ","M² ","cm² ","²",null,null,"Police Wingdings 3"]
[null,null,"le ³ se fait en tapant alt+0179",null,null,null,null,"m³ ","M³ ","cm³ ","³",null,null,"Z","q","p"]
[]
[]
[]
[null,null,"lien >","Les unités pifométriques"]
[]
[null,null,"Je remercie chaleureusement les internautes passionnés qui élaborent et proposent des formules et fonctions imbriquées"]
[null,null,"Quelques sites Excel pour vous aider à créer vos documents"]
[]
[null,"Transmettez votre savoir et votre savoir faire  peu importe qui le récupère; pourvu qu'un plus grand nombre puisse en bénéficier."]
[null,"Joël LEBOUCHER …Octobre 2015"]
[null,"un lien rompu ou devenu obsolète…..pas de panique…Google saura vous retrouver un document équivalent"]
[]
[null,"Site à découvrir"]
[null,"SPACE pour Suivi et Programmation d'ACtivités en Equipe est un outil destiné à permettre un suivi exhaustif des activités d'une équipe."]
["lien >",null,"Fil de discussion dédié à ce programme "]
[" >","http://www.excel-downloads.com/remository/Download/Professionnels/Planification-et-gestion-de-projets/SPACE.html"]

{"sheet":"Nota.Worksheet","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Si vous souhaitez faire du copier/ coller sur un document avec macro procédez comme suit :"]
[null,"Cliquez sur l'onglet de la feuille"]
[null,"clic droit : Visualiser le code"]
[null,"dans worksheet   copiez le code et collez le sur le bloc note de votre PC"]
[null,"retournez dans worksheet et supprimez le code"]
[null,"Fermez votre document puis ouvrez le"]
[null,"travaillez dans votre document"]
[null,"lorsque vous avez fini recopiez le code collé sur le bloc note "]
[null,"pour le coller à son emplacement dans worksheet"]
[null,"enregistrez "]
[null,"verifiez que l'enregistrement soit bien au format Excel,xlsm"]
[null,"ou dans un document supportant les macros"]
[]
[]
[]
[]
[]
[]
[null,"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"]
[null,"  Calculate"]
[null,"End Sub"]

{"sheet":"FF.12.Foies.de.volaille.VQRit","index":2,"n_rows":87,"n_cols":39,"rows_kept":87,"cut":false,"hidden":false,"merged":[[43,16,43,18],[47,16,50,16],[54,1,54,13],[55,2,55,13],[78,1,79,13],[80,1,80,13],[36,20,36,23],[36,25,36,28],[38,20,38,23],[38,25,38,28],[41,1,41,13],[30,20,30,23],[30,25,30,28],[32,20,32,23],[32,25,32,28],[34,20,34,23],[34,25,34,28],[24,20,24,23],[24,25,24,28],[26,20,26,23],[26,25,26,28],[28,20,28,23],[28,25,28,28],[17,16,18,18],[18,20,18,23],[18,25,18,28],[20,20,20,23],[20,25,20,28],[21,16,22,16],[21,17,22,17],[21,18,22,18],[22,20,22,23],[22,25,22,28],[12,20,12,23],[12,25,12,28],[14,16,15,18],[14,20,14,23],[14,25,14,28],[16,20,16,23],[16,25,16,28],[8,20,8,23],[8,25,8,28],[8,31,8,37],[9,31,9,37],[10,20,10,23],[10,25,10,28],[4,20,4,23],[5,16,6,18],[6,20,6,23],[6,25,6,28],[7,6,7,7],[7,16,7,18],[5,10,5,13],[1,1,1,13],[2,0,84,0],[2,2,2,10],[2,12,2,13],[4,6,4,7],[4,10,4,13],[81,3,81,13],[82,3,82,13],[83,1,83,13]]}
[3,8,8,8,8,24,8,8,10,10,10,8,9,9]
["ICI"]
[{"$f":"C3","v":"Gâteau de foies de volaille avec La vache qui rit Formule Plus"},"①","Gâteau de foies de volaille avec La vache qui rit Formule Plus",null,null,null,null,null,null,null,null,null,"CODE"]
[]
[null,"❼ l'Auteur a prévu la recette pour ",null,null,null,null,"❽ Vous voulez la dupliquer pour:",null,100,{"$f":"D7","v":"convives"},"La vache qui rit Formule Plus",null,null,null,null,null,"RÉCAP Mode d'emploi des fiches FF.2.B.1",null,null,null,"① Catégorie"]
[null,{"$f":"SUM(E10:E38)","v":1.5300000000000002},"Kg",10,"portion",null,null,"Coût portion",{"$f":"IF(M40=\"\",\"\",M40/I5)","v":0.22799999999999998},{"$f":"SUM(I10:I38)","v":15.299999999999999},{"$f":"NOW()","v":"2022-02-17T17:21:40.060"},null,null,null,null,null,"Saisissez vos valeurs dans les cellules fond jaune ou ivoire",null,null,null,"Copiez / Collez colonnes de K à N"]
[null,null,null,"convives",{"$f":"(B6/D6)*1000","v":153.00000000000003},null,null,"⑩ Coefficient vente",2.5,null,null,null,"Coût portion avec coeff.",{"$f":"IF(M40=\"\",\"\",I6*I7)","v":0.56999999999999995},null,null,null,null,null,null,"PATISSERIES",null,null,null,null,"   R255-V204 B153"]
[null,"❸","❹","❺",null,null,null,null,null,"⑥",null,"⑨",null,null,null,null,"à saisir"]
[null," Nb d'unités","Quoi","Poids Unitaire","④ Total Auteur","❷ Denrées","UNITE","Quoi","BRUT","% Perte","NET à servir","Prix U HT","Prix T HT","Pour 1Kg Brut",null,null,"❶ Nom du plat et",null,null,null,"ENTRÉES",null,null,null,null,"   R51-V153 B102",null,null,null,null,null,"Pour l'identification des fiches vous avez le choix "]
[null,null,null,0.4,{"$f":"IF(ISBLANK(B10),D10,B10*D10)","v":0.4},"Foies de volaille ",{"$f":"IF(ISBLANK(B10),0,(B10/D6)*I5)","v":0},{"$f":"C10","v":0},{"$f":"(E10/D6)*I5","v":4},20,{"$f":"IF(E10=0,0,((I10-(I10*J10%))))","v":3.2},1,{"$f":"L10*I10","v":4},{"$f":"IF(J6=0,0,(I10/J6))","v":0.26143790849673204},null,null,"① Catégorie Exemple SF SAUCE FROIDE DE BASE -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"entre la numérotation et l'identification Alpha"]
[null,null,null,0.01,{"$f":"IF(ISBLANK(B11),D11,B11*D11)","v":0.01},"Echalotes",{"$f":"IF(ISBLANK(B11),0,(B11/D6)*I5)","v":0},{"$f":"C11","v":0},{"$f":"(E11/D6)*I5","v":0.1},2,{"$f":"IF(E11=0,0,((I11-(I11*J11%))))","v":9.8000000000000004E-2},1,{"$f":"L11*I11","v":0.1},{"$f":"IF(J6=0,0,(I11/J6))","v":6.5359477124183017E-3},null,null,"AGNEAU :  \"Sauté d'agneau sans os- épaule - collier\"  -   ",null,null,null,"POISSONS",null,null,null,null,"   R50-V204 B255",null,null,null,null,null,null,"N°2",null,"A"]
[null,null,null,0.01,{"$f":"IF(ISBLANK(B12),D12,B12*D12)","v":0.01},"Persil",{"$f":"IF(ISBLANK(B12),0,(B12/D6)*I5)","v":0},{"$f":"C12","v":0},{"$f":"(E12/D6)*I5","v":0.1},5,{"$f":"IF(E12=0,0,((I12-(I12*J12%))))","v":9.5000000000000001E-2},1,{"$f":"L12*I12","v":0.1},{"$f":"IF(J6=0,0,(I12/J6))","v":6.5359477124183017E-3},null,null,"Choux Fleur- Pâte à choux etc….. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpha vous permet de vous constituer des répertoires Alphabétiques"]
[null,null,null,0.2,{"$f":"IF(ISBLANK(B13),D13,B13*D13)","v":0.2},"La vache qui rit® Formule Plus",{"$f":"IF(ISBLANK(B13),0,(B13/D6)*I5)","v":0},{"$f":"C13","v":0},{"$f":"(E13/D6)*I5","v":2},null,{"$f":"IF(E13=0,0,((I13-(I13*J13%))))","v":2},1,{"$f":"L13*I13","v":2},{"$f":"IF(J6=0,0,(I13/J6))","v":0.13071895424836602},null,null,"OU Famille : Hors d'œuvre - Plat - Légume - Dessert",null,null,null,"VOLAILLES",null,null,null,null,"   R255-V204 B0",null,null,null,null,null,"et de regrouper des préparations pour vous permettre de faire des assemblages"]
[null,null,null,0.1,{"$f":"IF(ISBLANK(B14),D14,B14*D14)","v":0.1},"Béchamel ",{"$f":"IF(ISBLANK(B14),0,(B14/D6)*I5)","v":0},{"$f":"C14","v":0},{"$f":"(E14/D6)*I5","v":1},null,{"$f":"IF(E14=0,0,((I14-(I14*J14%))))","v":1},2.5,{"$f":"L14*I14","v":2.5},{"$f":"IF(J6=0,0,(I14/J6))","v":6.535947712418301E-2},null,null,"❷ Liste des Denrées "]
[null,null,null,null,{"$f":"IF(ISBLANK(B15),D15,B15*D15)","v":0},"(sur une base d'une liaison de",{"$f":"IF(ISBLANK(B15),0,(B15/D6)*I5)","v":0},{"$f":"C15","v":0},{"$f":"(E15/D6)*I5","v":0},null,{"$f":"IF(E15=0,0,((I15-(I15*J15%))))","v":0},null,{"$f":"L15*I15","v":0},{"$f":"IF(J6=0,0,(I15/J6))","v":0},null,null,"❸ Nb d'unités",null,null,null,"VIANDES",null,null,null,null,"   R255-V0 B0",null,null,null,null,null,"le répertoire vous permettre d'aller chercher des\"postits\"  "]
[null,null,null,null,{"$f":"IF(ISBLANK(B16),D16,B16*D16)","v":0},"100 g de beurre et farine au litre)",{"$f":"IF(ISBLANK(B16),0,(B16/D6)*I5)","v":0},{"$f":"C16","v":0},{"$f":"(E16/D6)*I5","v":0},null,{"$f":"IF(E16=0,0,((I16-(I16*J16%))))","v":0},null,{"$f":"L16*I16","v":0},{"$f":"IF(J6=0,0,(I16/J6))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de les assembler sur une fiche pour faire des recettes à multiples préparations"]
[null,null,null,null,{"$f":"IF(ISBLANK(B17),D17,B17*D17)","v":0},null,{"$f":"IF(ISBLANK(B17),0,(B17/D6)*I5)","v":0},{"$f":"C17","v":0},{"$f":"(E17/D6)*I5","v":0},null,{"$f":"IF(E17=0,0,((I17-(I17*J17%))))","v":0},null,{"$f":"L17*I17","v":0},{"$f":"IF(J6=0,0,(I17/J6))","v":0},null,null,"❹ Quoi ",null,null,null,"PLATS COMPLETS",null,null,null,null,"   R255-V102 B0",null,null,null,null,null,"pourquoi ré-écrire X fois une recette si cette recette vous convient."]
[null,4,"œufs",0.05,{"$f":"IF(ISBLANK(B18),D18,B18*D18)","v":0.2},"œufs",{"$f":"IF(ISBLANK(B18),0,(B18/D6)*I5)","v":40},{"$f":"C18","v":"œufs"},{"$f":"(E18/D6)*I5","v":2},null,{"$f":"IF(E18=0,0,((I18-(I18*J18%))))","v":2},0.3,{"$f":"L18*I18","v":0.6},{"$f":"IF(J6=0,0,(I18/J6))","v":0.13071895424836602},null,null,"❺ Poids Unitaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"il suffit de l'ajouter sur votre document et d'en déterminer les quantités à fabriquer"]
[null,null,null,0.03,{"$f":"IF(ISBLANK(B19),D19,B19*D19)","v":0.03}," Huile olive",{"$f":"IF(ISBLANK(B19),0,(B19/D6)*I5)","v":0},{"$f":"C19","v":0},{"$f":"(E19/D6)*I5","v":0.3},null,{"$f":"IF(E19=0,0,((I19-(I19*J19%))))","v":0.3},null,{"$f":"L19*I19","v":0},{"$f":"IF(J6=0,0,(I19/J6))","v":1.9607843137254902E-2},null,null,null,null,null,null,"ACCOMPAGNEMENTS",null,null,null,null,"   R0-V255 B0"]
[null,null,null,0.05,{"$f":"IF(ISBLANK(B20),D20,B20*D20)","v":0.05},"Oignons",{"$f":"IF(ISBLANK(B20),0,(B20/D6)*I5)","v":0},{"$f":"C20","v":0},{"$f":"(E20/D6)*I5","v":0.5},20,{"$f":"IF(E20=0,0,((I20-(I20*J20%))))","v":0.4},1,{"$f":"L20*I20","v":0.5},{"$f":"IF(J6=0,0,(I20/J6))","v":3.2679738562091505E-2},null,null,"Exemple :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si vous souhaitez faire du copier/ coller sur un document avec macro procédez comme suit :"]
[null,null,null,0.5,{"$f":"IF(ISBLANK(B21),D21,B21*D21)","v":0.5},"Coulis de tomate",{"$f":"IF(ISBLANK(B21),0,(B21/D6)*I5)","v":0},{"$f":"C21","v":0},{"$f":"(E21/D6)*I5","v":5},null,{"$f":"IF(E21=0,0,((I21-(I21*J21%))))","v":5},2.5,{"$f":"L21*I21","v":12.5},{"$f":"IF(J6=0,0,(I21/J6))","v":0.32679738562091504},null,null,"❷","❸","❹",null,"PREPARATIONS CHAUDES",null,null,null,null,"   R255-V204 B153",null,null,null,null,null,"Cliquez sur l'onglet de la feuille"]
[null,null,null,0.01,{"$f":"IF(ISBLANK(B22),D22,B22*D22)","v":0.01}," Ail ",{"$f":"IF(ISBLANK(B22),0,(B22/D6)*I5)","v":0},{"$f":"C22","v":0},{"$f":"(E22/D6)*I5","v":0.1},2,{"$f":"IF(E22=0,0,((I22-(I22*J22%))))","v":9.8000000000000004E-2},null,{"$f":"L22*I22","v":0},{"$f":"IF(J6=0,0,(I22/J6))","v":6.5359477124183017E-3},null,null,"Nb d'unités","Quoi","Poids Unitaire",null,null,null,null,null,null,null,null,null,null,null,null,"clic droit : Visualiser le code"]
[null,null,null,null,{"$f":"IF(ISBLANK(B23),D23,B23*D23)","v":0},"Thym",{"$f":"IF(ISBLANK(B23),0,(B23/D6)*I5)","v":0},{"$f":"C23","v":0},{"$f":"(E23/D6)*I5","v":0},null,{"$f":"IF(E23=0,0,((I23-(I23*J23%))))","v":0},null,{"$f":"L23*I23","v":0},{"$f":"IF(J6=0,0,(I23/J6))","v":0},null,null,null,null,null,null,"PLAT PRINCIPAL ",null,null,null,null,"  R255-V0 B255",null,null,null,null,null,"dans worksheet   copiez le code et collez le sur le bloc note de votre PC"]
[null,20,"olives",1E-3,{"$f":"IF(ISBLANK(B24),D24,B24*D24)","v":0.02},"Olives noires",{"$f":"IF(ISBLANK(B24),0,(B24/D6)*I5)","v":200},{"$f":"C24","v":"olives"},{"$f":"(E24/D6)*I5","v":0.2},null,{"$f":"IF(E24=0,0,((I24-(I24*J24%))))","v":0.2},2.5,{"$f":"L24*I24","v":0.5},{"$f":"IF(J6=0,0,(I24/J6))","v":1.3071895424836603E-2},null,null,2,"pommes",0.05,null,null,null,null,null,null,null,null,null,null,null,null,"retournez dans worksheet et supprimez le code"]
[null,null,null,null,{"$f":"IF(ISBLANK(B25),D25,B25*D25)","v":0},null,{"$f":"IF(ISBLANK(B25),0,(B25/D6)*I5)","v":0},{"$f":"C25","v":0},{"$f":"(E25/D6)*I5","v":0},null,{"$f":"IF(E25=0,0,((I25-(I25*J25%))))","v":0},null,{"$f":"L25*I25","v":0},{"$f":"IF(J6=0,0,(I25/J6))","v":0},null,null,null,"œufs liquides",null,null,"CRUDITES",null,null,null,null,"   R0-V128 B0",null,null,null,null,null,"Fermez votre document puis ouvrez le"]
[null,null,null,null,{"$f":"IF(ISBLANK(B26),D26,B26*D26)","v":0},null,{"$f":"IF(ISBLANK(B26),0,(B26/D6)*I5)","v":0},{"$f":"C26","v":0},{"$f":"(E26/D6)*I5","v":0},null,{"$f":"IF(E26=0,0,((I26-(I26*J26%))))","v":0},null,{"$f":"L26*I26","v":0},{"$f":"IF(J6=0,0,(I26/J6))","v":0},null,null,null,null,0.15,null,null,null,null,null,null,null,null,null,null,null,null,"travaillez dans votre document"]
[null,null,null,null,{"$f":"IF(ISBLANK(B27),D27,B27*D27)","v":0},null,{"$f":"IF(ISBLANK(B27),0,(B27/D6)*I5)","v":0},{"$f":"C27","v":0},{"$f":"(E27/D6)*I5","v":0},null,{"$f":"IF(E27=0,0,((I27-(I27*J27%))))","v":0},null,{"$f":"L27*I27","v":0},{"$f":"IF(J6=0,0,(I27/J6))","v":0},null,null,null,"jaunes d'œufs",null,null,"CUIDITES",null,null,null,null,"   R153-V204 B0",null,null,null,null,null,"lorsque vous avez fini recopiez le code collé sur le bloc note "]
[null,null,null,null,{"$f":"IF(ISBLANK(B28),D28,B28*D28)","v":0},null,{"$f":"IF(ISBLANK(B28),0,(B28/D6)*I5)","v":0},{"$f":"C28","v":0},{"$f":"(E28/D6)*I5","v":0},null,{"$f":"IF(E28=0,0,((I28-(I28*J28%))))","v":0},null,{"$f":"L28*I28","v":0},{"$f":"IF(J6=0,0,(I28/J6))","v":0},null,null,3,"jaunes",0.02,null,null,null,null,null,null,null,null,null,null,null,null,"pour le coller à son emplacement dans worksheet"]
[null,null,null,null,{"$f":"IF(ISBLANK(B29),D29,B29*D29)","v":0},null,{"$f":"IF(ISBLANK(B29),0,(B29/D6)*I5)","v":0},{"$f":"C29","v":0},{"$f":"(E29/D6)*I5","v":0},null,{"$f":"IF(E29=0,0,((I29-(I29*J29%))))","v":0},null,{"$f":"L29*I29","v":0},{"$f":"IF(J6=0,0,(I29/J6))","v":0},null,null,null,"œufs coquille",null,null,"FECULENTS",null,null,null,null,"   R153-V51 B0",null,null,null,null,null,"enregistrez "]
[null,null,null,null,{"$f":"IF(ISBLANK(B30),D30,B30*D30)","v":0},null,{"$f":"IF(ISBLANK(B30),0,(B30/D6)*I5)","v":0},{"$f":"C30","v":0},{"$f":"(E30/D6)*I5","v":0},null,{"$f":"IF(E30=0,0,((I30-(I30*J30%))))","v":0},null,{"$f":"L30*I30","v":0},{"$f":"IF(J6=0,0,(I30/J6))","v":0},null,null,5,"œufs",0.05,null,null,null,null,null,null,null,null,null,null,null,null,"verifiez que l'enregistrement soit bien au format Excel,xlsm"]
[null,null,null,null,{"$f":"IF(ISBLANK(B31),D31,B31*D31)","v":0},null,{"$f":"IF(ISBLANK(B31),0,(B31/D6)*I5)","v":0},{"$f":"C31","v":0},{"$f":"(E31/D6)*I5","v":0},null,{"$f":"IF(E31=0,0,((I31-(I31*J31%))))","v":0},null,{"$f":"L31*I31","v":0},{"$f":"IF(J6=0,0,(I31/J6))","v":0},null,null,null,null,null,null,"COMPOSÉS VERTS",null,null,null,null,"   R0-V255 B0",null,null,null,null,null,"ou dans un document supportant les macros"]
[null,null,null,null,{"$f":"IF(ISBLANK(B32),D32,B32*D32)","v":0},null,{"$f":"IF(ISBLANK(B32),0,(B32/D6)*I5)","v":0},{"$f":"C32","v":0},{"$f":"(E32/D6)*I5","v":0},null,{"$f":"IF(E32=0,0,((I32-(I32*J32%))))","v":0},null,{"$f":"L32*I32","v":0},{"$f":"IF(J6=0,0,(I32/J6))","v":0},null,null,"⑥ % Perte (facultatif)"]
[null,null,null,null,{"$f":"IF(ISBLANK(B33),D33,B33*D33)","v":0},null,{"$f":"IF(ISBLANK(B33),0,(B33/D6)*I5)","v":0},{"$f":"C33","v":0},{"$f":"(E33/D6)*I5","v":0},null,{"$f":"IF(E33=0,0,((I33-(I33*J33%))))","v":0},null,{"$f":"L33*I33","v":0},{"$f":"IF(J6=0,0,(I33/J6))","v":0},null,null,null,null,null,null,"LAITAGES FROMAGES",null,null,null,null,"   R0-V0 B255"]
[null,null,null,null,{"$f":"IF(ISBLANK(B34),D34,B34*D34)","v":0},null,{"$f":"IF(ISBLANK(B34),0,(B34/D6)*I5)","v":0},{"$f":"C34","v":0},{"$f":"(E34/D6)*I5","v":0},null,{"$f":"IF(E34=0,0,((I34-(I34*J34%))))","v":0},null,{"$f":"L34*I34","v":0},{"$f":"IF(J6=0,0,(I34/J6))","v":0},null,null,"❼ l'Auteur a prévu la recette pour "]
[null,null,null,null,{"$f":"IF(ISBLANK(B35),D35,B35*D35)","v":0},null,{"$f":"IF(ISBLANK(B35),0,(B35/D6)*I5)","v":0},{"$f":"C35","v":0},{"$f":"(E35/D6)*I5","v":0},null,{"$f":"IF(E35=0,0,((I35-(I35*J35%))))","v":0},null,{"$f":"L35*I35","v":0},{"$f":"IF(J6=0,0,(I35/J6))","v":0},null,null,null,null,null,null,"LAITAGES +FECULENTS",null,null,null,null,"   R153-V204 B255"]
[null,null,null,null,{"$f":"IF(ISBLANK(B36),D36,B36*D36)","v":0},null,{"$f":"IF(ISBLANK(B36),0,(B36/D6)*I5)","v":0},{"$f":"C36","v":0},{"$f":"(E36/D6)*I5","v":0},null,{"$f":"IF(E36=0,0,((I36-(I36*J36%))))","v":0},null,{"$f":"L36*I36","v":0},{"$f":"IF(J6=0,0,(I36/J6))","v":0},null,null,"❽ vos Effectifs"]
[null,null,null,null,{"$f":"IF(ISBLANK(B37),D37,B37*D37)","v":0},null,{"$f":"IF(ISBLANK(B37),0,(B37/D6)*I5)","v":0},{"$f":"C37","v":0},{"$f":"(E37/D6)*I5","v":0},null,{"$f":"IF(E37=0,0,((I37-(I37*J37%))))","v":0},null,{"$f":"L37*I37","v":0},{"$f":"IF(J6=0,0,(I37/J6))","v":0},null,null,null,null,null,null,"DESSERTS",null,null,null,null,"   R0-V102 B204"]
[null,null,null,null,{"$f":"IF(ISBLANK(B38),D38,B38*D38)","v":0},null,{"$f":"IF(ISBLANK(B38),0,(B38/D6)*I5)","v":0},{"$f":"C38","v":0},{"$f":"(E38/D6)*I5","v":0},null,{"$f":"IF(E38=0,0,((I38-(I38*J38%))))","v":0},null,{"$f":"L38*I38","v":0},{"$f":"IF(J6=0,0,(I38/J6))","v":0},null,null,"⑨ Prx au Kg ou Unité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"]
[null,null,null,0,null,null,0,0,null,0,null,null,{"$f":"L39*I39","v":0},{"$f":"IF(ISERROR(M39/M41),\"\",M39/M41)","v":""},null,null,null,null,null,null,"GOUTER",null,null,null,null,"   R204-V153 B255",null,null,null,null,null,"  Calculate"]
[null,{"$f":"SUM(B10:B39)","v":24},null,null,{"$f":"SUM(E10:E38)","v":1.5300000000000002},null,0,{"$f":"SUM(H10:H39)","v":0},{"$f":"SUM(I10:I38)","v":15.299999999999999},{"$f":"I40-K40","v":0.90899999999999714},{"$f":"SUM(K10:K38)","v":14.391000000000002},null,{"$f":"SUM(M10:M38)","v":22.799999999999997},{"$f":"SUM(N10:N39)","v":1},null,null,"⑩ Coefficient vente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Sub"]
[null," Nb d'unités","Quoi","Poids Unitaire","④ Total Auteur",null,"UNITE","Poids recette","BRUT arrondi","Perte","NET à servir",null,"Prix T HT","Pour 1Kg Brut",null,null,"⑪ lien Internet",null,null,null,10,8,9,9,"largeurs de colonnes"]
[null,"Auteur de la recette et références bibliographiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"CELL(\"largeur\",R42)","v":16},{"$f":"CELL(\"largeur\",S42)","v":16}]
[null,"⑪ lien Internet",null,"https://www.belfoodservice.be/recettes.php"]
[null,{"$f":"CELL(\"filename\",A3)","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12.Foies.de.volaille.VQRit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null," Aide à la décision"]
[null,0,"Technique :",null,null,null,null,null,"Durée préparation","_:_",null,null,"Durée de cuisson",null,null,null,"Nb de portions","Poids portion ","Total"]
[null,{"$f":"IF(ISBLANK(C46),\"\",LARGE(B45:B45,1)+1)","v":""},null,null,null,null,null,"Produit à promouvoir",null,null,null,null,null,null,null,null,150,250,{"$f":"(R46*Q46)/1000","v":37.5}]
[null,{"$f":"IF(ISBLANK(C47),\"\",LARGE(B45:B46,1)+1)","v":1},"NUMÉROTATION AUTOMATIQUE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Saisissez vos valeurs dans les tableaux"]
[null,{"$f":"IF(ISBLANK(C48),\"\",LARGE(B45:B47,1)+1)","v":""},null,"si vous ne voulez pas de N°",null,null,null,null,null,null,null,null,null,null,null,null,"Pourcentages Brut / Net et Net / Brut","Brut","NET ASSIETTE"]
[null,{"$f":"IF(ISBLANK(C49),\"\",LARGE(B45:B48,1)+1)","v":""},null,"saisissez du texte dans ces colonnes",null,null,null,null,null,null,null,null,null,null,null,null,null,200,140]
[null,{"$f":"IF(ISBLANK(C50),\"\",LARGE(B45:B49,1)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30]
[null,{"$f":"IF(ISBLANK(C51),\"\",LARGE(B45:B50,1)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R49=0,0,((R49-(R49*R50%))))/1000","v":0.14000000000000001},{"$f":"(S49/(100-S50)*100)/1000","v":0.2}]
[null,{"$f":"IF(ISBLANK(C52),\"\",LARGE(B45:B51,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C53),\"\",LARGE(B45:B52,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C54),\"\",LARGE(B45:B53,1)+1)","v":""}]
[null,"L'utilisation professionnelle des fiches vous engage à connaître la réglementation en matière d'hygiène et HACCP.Procédures non développées ici pour ne pas alourdir les documents"]
[null,0,"MISE EN PLACE DU POSTE DE TRAVAIL"]
[null,{"$f":"IF(ISBLANK(C57),\"\",LARGE(B56:B56,1)+1)","v":1},"tenue professionnelle de circonstance (charlotte-masque)",null,null,null,null,{"$f":"MAX(B57:B60)+1","v":4},"se laver les mains souvent - prévoir gants"]
[null,{"$f":"IF(ISBLANK(C58),\"\",LARGE(B56:B57,1)+1)","v":2},"verifier - bactéricide - esssuie mains - sacs poubelle",null,null,null,null,{"$f":"IF(ISBLANK(I58),\"\",LARGE(H57:H57,1)+1)","v":5},"sélectionner le matériel nécessaire"]
[null,{"$f":"IF(ISBLANK(C59),\"\",LARGE(B56:B58,1)+1)","v":3},"vérifier températures - locaux et chambres froides",null,null,null,null,{"$f":"IF(ISBLANK(I59),\"\",LARGE(H57:H58,1)+1)","v":6},"laver et désinfecter le matériel et le poste de travail"]
[null,{"$f":"IF(ISBLANK(C60),\"\",LARGE(B56:B59,1)+1)","v":""},null,"ORGANISATION RAISONNÉE DU TRAVAIL",null,null,null,{"$f":"IF(ISBLANK(I60),\"\",LARGE(H57:H59,1)+1)","v":7},"en suivant les protocoles"]
[null,0,null,"Etape 1",null,null,null,null,{"$f":"MAX(B61:B77)","v":11},"Observations :",null,null,null,null,null,null,{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"Q"},{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"R"},{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"S"},"< colonnes"]
[null,{"$f":"IF(ISBLANK(C62),\"\",LARGE(B61:B61,1)+1)","v":1},"Confectionner la sauce tomate : ",null,null,null,null,null,{"$f":"IF(ISBLANK(J62),\"\",LARGE(I61:I61,1)+1)","v":""},null,null,null,null,null,null,null,0,"MISE EN ŒUVRE"]
[null,{"$f":"IF(ISBLANK(C63),\"\",LARGE(B61:B62,1)+1)","v":2},"suer les oignons émincés à l'huile d'olive, ",null,null,null,null,null,{"$f":"IF(ISBLANK(J63),\"\",LARGE(I61:I62,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R63),\"\",LARGE(Q62:Q62,1)+1)","v":1},"la numérotation est automatique"]
[null,{"$f":"IF(ISBLANK(C64),\"\",LARGE(B61:B63,1)+1)","v":3},"ajouter le coulis, l'ail et le thym. ",null,null,null,null,null,{"$f":"IF(ISBLANK(J64),\"\",LARGE(I61:I63,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R64),\"\",LARGE(Q62:Q63,1)+1)","v":2},"lorsque vous saisissez du texte"]
[null,{"$f":"IF(ISBLANK(C65),\"\",LARGE(B61:B64,1)+1)","v":4},"Cuire environ 1/2 heure. ",null,null,null,null,null,{"$f":"IF(ISBLANK(J65),\"\",LARGE(I61:I64,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R65),\"\",LARGE(Q62:Q64,1)+1)","v":3},"dans cette colonne R"]
[null,{"$f":"IF(ISBLANK(C66),\"\",LARGE(B61:B65,1)+1)","v":""},null,"En fonction des coulis, détendre avec de l'eau. ",null,null,null,null,{"$f":"IF(ISBLANK(J66),\"\",LARGE(I61:I65,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R66),\"\",LARGE(Q62:Q65,1)+1)","v":""},null,"si vous ne voulez pas de numérotation"]
[null,{"$f":"IF(ISBLANK(C67),\"\",LARGE(B61:B66,1)+1)","v":5},"Mixer avec les olives pour la texture modifiée.",null,null,null,null,null,{"$f":"IF(ISBLANK(J67),\"\",LARGE(I61:I66,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R67),\"\",LARGE(Q62:Q66,1)+1)","v":""},null,"saisissez votre texte dans celle-ci colonne S pour l'exemple"]
[null,{"$f":"IF(ISBLANK(C68),\"\",LARGE(B61:B67,1)+1)","v":""},null,"Etape 2",null,null,null,null,{"$f":"IF(ISBLANK(J68),\"\",LARGE(I61:I67,1)+1)","v":12},"NUMÉROTATION AUTOMATIQUE",null,null,null,null,null,null,{"$f":"IF(ISBLANK(R68),\"\",LARGE(Q62:Q67,1)+1)","v":4},"formule utilisée :SI(ESTVIDE(R68);\"\";GRANDE.VALEUR(Q62:Q67;1)+1"]
[null,{"$f":"IF(ISBLANK(C69),\"\",LARGE(B61:B68,1)+1)","v":6},"Parer les foies puis les mixer avec les échalotes, le persil,",null,null,null,null,null,{"$f":"IF(ISBLANK(J69),\"\",LARGE(I61:I68,1)+1)","v":""},null,"si vous ne voulez pas de N°",null,null,null,null,null,{"$f":"IF(ISBLANK(R69),\"\",LARGE(Q62:Q68,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C70),\"\",LARGE(B61:B69,1)+1)","v":7},"La vache qui rit® Formule Plus, la béchamel, l'ail et l'assaisonnement.",null,null,null,null,null,{"$f":"IF(ISBLANK(J70),\"\",LARGE(I61:I69,1)+1)","v":""},null,"saisissez du texte dans ces colonnes"]
[null,{"$f":"IF(ISBLANK(C71),\"\",LARGE(B61:B70,1)+1)","v":8},"Incorporer les oeufs et mixer à nouveau.",null,null,null,null,null,{"$f":"IF(ISBLANK(J71),\"\",LARGE(I61:I70,1)+1)","v":""},null,null,null,null,null,null,null,"D'autres recettes sur le Net"]
[null,{"$f":"IF(ISBLANK(C72),\"\",LARGE(B61:B71,1)+1)","v":""},null,"Etape 3",null,null,null,null,{"$f":"IF(ISBLANK(J72),\"\",LARGE(I61:I71,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C73),\"\",LARGE(B61:B72,1)+1)","v":9},"Dresser dans des moules individuels ou dans une terrine. ",null,null,null,null,null,{"$f":"IF(ISBLANK(J73),\"\",LARGE(I61:I72,1)+1)","v":""},null,null,null,null,null,null,null,"Les Recettes de Vache qui rit - 7"]
[null,{"$f":"IF(ISBLANK(C74),\"\",LARGE(B61:B73,1)+1)","v":10},"Cuire à couvert au four vapeur environ 12 minutes à 95°C.",null,null,null,null,null,{"$f":"IF(ISBLANK(J74),\"\",LARGE(I61:I73,1)+1)","v":""},null,null,null,null,null,null,null,"https://recettes.de/vache-qui-rit/7"]
[null,{"$f":"IF(ISBLANK(C75),\"\",LARGE(B61:B74,1)+1)","v":""},null,"Etape 4",null,null,null,null,{"$f":"IF(ISBLANK(J75),\"\",LARGE(I61:I74,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C76),\"\",LARGE(B61:B75,1)+1)","v":11},"Dresser avec la sauce tomate puis servir en décorant avec les olives",null,null,null,null,null,{"$f":"IF(ISBLANK(J76),\"\",LARGE(I61:I75,1)+1)","v":""},null,null,null,null,null,null,null,"quiche au saumon"]
[null,{"$f":"IF(ISBLANK(C77),\"\",LARGE(B61:B76,1)+1)","v":""},null," pour la texture entière.",null,null,null,null,{"$f":"IF(ISBLANK(J77),\"\",LARGE(I61:I76,1)+1)","v":""},null,null,null,null,null,null,null,"https://www.yumpu.com/fr/document/view/2245108/livret-vop-mise-en-page-1-bel-food-service-catalogues-interactifs-/19"]
[null,"Pour vérification : cocher - entourer - ou surligner les produits ou actions concernées",null,null,null,null,null,null,{"$f":"IF(ISBLANK(J78),\"\",LARGE(I61:I77,1)+1)","v":""}]
[null,"L'utilisation professionnelle de cette recette vous engage à connaître la réglementation en matière d'hygiène et HACCP. Procédures non développées ici pour ne pas alourdir la fiche technique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarte à la vache qui rit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.paperblog.fr/4683938/tarte-a-la-vache-qui-rit/"]
[null,"Conception 1998 Cuisine centrale de Clamart Joël Leboucher - Adaptation 2009 Cuisine Centrale de Rochefort sur mer sur un document avec macro..de D.DEMILLY "]
[null,"Adresse PC",null,{"$f":"CELL(\"filename\",A1)","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12.Foies.de.volaille.VQRit"},null,null,null,null,null,null,null,null,null,null,null,null,"La Vache qui rit Canada"]
[null,"Mise à jour",null,"du 21-02-2017- Annule et remplace les versions précédentes",null,null,null,null,null,null,null,null,null,null,null,null,"https://www.facebook.com/LaVachequiritCanada/"]
[null,"Adaptation 2022: Joël Leboucher..UPRT \"Union des Personnels de la Restauration Territoriale\"  membre du réseau RESTAU'CO"]
[null,8,8,8,8,24,8,8,10,10,10,8,9,9,"largeurs de colonnes manuel",null,"Purée à la Vache qui rit®"]
[null,{"$f":"CELL(\"largeur\",B86)","v":8},{"$f":"CELL(\"largeur\",C86)","v":8},{"$f":"CELL(\"largeur\",D86)","v":8},{"$f":"CELL(\"largeur\",E86)","v":8},{"$f":"CELL(\"largeur\",F86)","v":24},{"$f":"CELL(\"largeur\",G86)","v":8},{"$f":"CELL(\"largeur\",H86)","v":8},{"$f":"CELL(\"largeur\",I86)","v":10},{"$f":"CELL(\"largeur\",J86)","v":10},{"$f":"CELL(\"largeur\",K86)","v":10},{"$f":"CELL(\"largeur\",L86)","v":8},{"$f":"CELL(\"largeur\",M86)","v":9},{"$f":"CELL(\"largeur\",N86)","v":9},"largeurs de colonnes contrôle par formule",null,"http://unsiphonfonfon.ladymilonguera.fr/2012/09/puree-vache-qui-rit/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://unsiphonfonfon.ladymilonguera.fr/"]

{"sheet":"FF.12.Modèle.vierge","index":3,"n_rows":86,"n_cols":39,"rows_kept":86,"cut":false,"hidden":false,"merged":[[36,25,36,28],[38,25,38,28],[8,31,8,37],[9,31,9,37],[5,10,5,13],[24,25,24,28],[26,25,26,28],[28,25,28,28],[30,25,30,28],[32,25,32,28],[34,25,34,28],[6,25,6,28],[8,25,8,28],[10,25,10,28],[12,25,12,28],[14,25,14,28],[16,25,16,28],[14,20,14,23],[16,20,16,23],[18,20,18,23],[20,20,20,23],[22,20,22,23],[24,20,24,23],[28,20,28,23],[30,20,30,23],[32,20,32,23],[34,20,34,23],[26,20,26,23],[18,25,18,28],[20,25,20,28],[22,25,22,28],[4,20,4,23],[6,20,6,23],[8,20,8,23],[10,20,10,23],[12,20,12,23],[43,16,43,18],[47,16,50,16],[54,1,54,13],[55,2,55,13],[2,0,84,0],[2,2,2,10],[5,16,6,18],[7,16,7,18],[14,16,15,18],[17,16,18,18],[21,16,22,16],[21,17,22,17],[21,18,22,18],[36,20,36,23],[38,20,38,23],[1,1,1,13],[2,12,2,13],[4,6,4,7],[4,10,4,13],[7,6,7,7],[41,1,41,13],[81,3,81,13],[82,3,82,13],[83,1,83,13],[78,1,79,13],[80,1,80,13]]}
[3,8,8,8,8,24,8,8,10,10,10,8,9,9]
["ICI"]
[{"$f":"C3","v":"NOM DE LA RECETTE"},"①","NOM DE LA RECETTE",null,null,null,null,null,null,null,null,null,"CODE"]
[]
[null,"❼ l'Auteur a prévu la recette pour ",null,null,null,null,"❽ Vous voulez la dupliquer pour:",null,200,{"$f":"D7","v":"convives"},"① Catégorie",null,null,null,null,null,"RÉCAP Mode d'emploi des fiches FF.2.B.1",null,null,null,"① Catégorie"]
[null,{"$f":"SUM(E10:E38)","v":0},"Kg",600,"portion",null,null,"Coût portion",{"$f":"IF(M40=\"\",\"\",M40/I5)","v":0},{"$f":"SUM(I10:I38)","v":0},{"$f":"NOW()","v":"2022-02-17T17:21:40.060"},null,null,null,null,null,"Saisissez vos valeurs dans les cellules fond jaune ou ivoire",null,null,null,"Copiez / Collez colonnes de K à N"]
[null,null,null,"convives",{"$f":"(B6/D6)*1000","v":0},null,null,"⑩ Coefficient vente",2.5,null,null,null,"Coût portion avec coeff.",{"$f":"IF(M40=\"\",\"\",I6*I7)","v":0},null,null,null,null,null,null,"PATISSERIES",null,null,null,null,"   R255-V204 B153"]
[null,"❸","❹","❺",null,null,null,null,null,"⑥",null,"⑨",null,null,null,null,"à saisir"]
[null," Nb d'unités","Quoi","Poids Unitaire","④ Total Auteur","❷ Denrées","UNITE","Quoi","BRUT","% Perte","NET à servir","Prix U HT","Prix T HT","Pour 1Kg Brut",null,null,"❶ Nom du plat et",null,null,null,"ENTRÉES",null,null,null,null,"   R51-V153 B102",null,null,null,null,null,"Pour l'identification des fiches vous avez le choix "]
[null,null,null,null,{"$f":"IF(ISBLANK(B10),D10,B10*D10)","v":0},null,{"$f":"IF(ISBLANK(B10),0,(B10/D6)*I5)","v":0},{"$f":"C10","v":0},{"$f":"(E10/D6)*I5","v":0},null,{"$f":"IF(E10=0,0,((I10-(I10*J10%))))","v":0},1,{"$f":"L10*I10","v":0},{"$f":"IF(J6=0,0,(I10/J6))","v":0},null,null,"① Catégorie Exemple SF SAUCE FROIDE DE BASE -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"entre la numérotation et l'identification Alpha"]
[null,null,null,null,{"$f":"IF(ISBLANK(B11),D11,B11*D11)","v":0},null,{"$f":"IF(ISBLANK(B11),0,(B11/D6)*I5)","v":0},{"$f":"C11","v":0},{"$f":"(E11/D6)*I5","v":0},null,{"$f":"IF(E11=0,0,((I11-(I11*J11%))))","v":0},null,{"$f":"L11*I11","v":0},{"$f":"IF(J6=0,0,(I11/J6))","v":0},null,null,"AGNEAU :  \"Sauté d'agneau sans os- épaule - collier\"  -   ",null,null,null,"POISSONS",null,null,null,null,"   R50-V204 B255",null,null,null,null,null,null,"N°2",null,"A"]
[null,null,null,null,{"$f":"IF(ISBLANK(B12),D12,B12*D12)","v":0},null,{"$f":"IF(ISBLANK(B12),0,(B12/D6)*I5)","v":0},{"$f":"C12","v":0},{"$f":"(E12/D6)*I5","v":0},null,{"$f":"IF(E12=0,0,((I12-(I12*J12%))))","v":0},null,{"$f":"L12*I12","v":0},{"$f":"IF(J6=0,0,(I12/J6))","v":0},null,null,"Choux Fleur- Pâte à choux etc….. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpha vous permet de vous constituer des répertoires Alphabétiques"]
[null,null,null,null,{"$f":"IF(ISBLANK(B13),D13,B13*D13)","v":0},null,{"$f":"IF(ISBLANK(B13),0,(B13/D6)*I5)","v":0},{"$f":"C13","v":0},{"$f":"(E13/D6)*I5","v":0},null,{"$f":"IF(E13=0,0,((I13-(I13*J13%))))","v":0},null,{"$f":"L13*I13","v":0},{"$f":"IF(J6=0,0,(I13/J6))","v":0},null,null,"OU Famille : Hors d'œuvre - Plat - Légume - Dessert",null,null,null,"VOLAILLES",null,null,null,null,"   R255-V204 B0",null,null,null,null,null,"et de regrouper des préparations pour vous permettre de faire des assemblages"]
[null,null,null,null,{"$f":"IF(ISBLANK(B14),D14,B14*D14)","v":0},null,{"$f":"IF(ISBLANK(B14),0,(B14/D6)*I5)","v":0},{"$f":"C14","v":0},{"$f":"(E14/D6)*I5","v":0},null,{"$f":"IF(E14=0,0,((I14-(I14*J14%))))","v":0},null,{"$f":"L14*I14","v":0},{"$f":"IF(J6=0,0,(I14/J6))","v":0},null,null,"❷ Liste des Denrées "]
[null,null,null,null,{"$f":"IF(ISBLANK(B15),D15,B15*D15)","v":0},null,{"$f":"IF(ISBLANK(B15),0,(B15/D6)*I5)","v":0},{"$f":"C15","v":0},{"$f":"(E15/D6)*I5","v":0},null,{"$f":"IF(E15=0,0,((I15-(I15*J15%))))","v":0},null,{"$f":"L15*I15","v":0},{"$f":"IF(J6=0,0,(I15/J6))","v":0},null,null,"❸ Nb d'unités",null,null,null,"VIANDES",null,null,null,null,"   R255-V0 B0",null,null,null,null,null,"le répertoire vous permettre d'aller chercher des\"postits\"  "]
[null,null,null,null,{"$f":"IF(ISBLANK(B16),D16,B16*D16)","v":0},null,{"$f":"IF(ISBLANK(B16),0,(B16/D6)*I5)","v":0},{"$f":"C16","v":0},{"$f":"(E16/D6)*I5","v":0},null,{"$f":"IF(E16=0,0,((I16-(I16*J16%))))","v":0},null,{"$f":"L16*I16","v":0},{"$f":"IF(J6=0,0,(I16/J6))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de les assembler sur une fiche pour faire des recettes à multiples préparations"]
[null,null,null,null,{"$f":"IF(ISBLANK(B17),D17,B17*D17)","v":0},null,{"$f":"IF(ISBLANK(B17),0,(B17/D6)*I5)","v":0},{"$f":"C17","v":0},{"$f":"(E17/D6)*I5","v":0},null,{"$f":"IF(E17=0,0,((I17-(I17*J17%))))","v":0},null,{"$f":"L17*I17","v":0},{"$f":"IF(J6=0,0,(I17/J6))","v":0},null,null,"❹ Quoi ",null,null,null,"PLATS COMPLETS",null,null,null,null,"   R255-V102 B0",null,null,null,null,null,"pourquoi ré-écrire X fois une recette si cette recette vous convient."]
[null,null,null,null,{"$f":"IF(ISBLANK(B18),D18,B18*D18)","v":0},null,{"$f":"IF(ISBLANK(B18),0,(B18/D6)*I5)","v":0},{"$f":"C18","v":0},{"$f":"(E18/D6)*I5","v":0},null,{"$f":"IF(E18=0,0,((I18-(I18*J18%))))","v":0},null,{"$f":"L18*I18","v":0},{"$f":"IF(J6=0,0,(I18/J6))","v":0},null,null,"❺ Poids Unitaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"il suffit de l'ajouter sur votre document et d'en déterminer les quantités à fabriquer"]
[null,null,null,null,{"$f":"IF(ISBLANK(B19),D19,B19*D19)","v":0},null,{"$f":"IF(ISBLANK(B19),0,(B19/D6)*I5)","v":0},{"$f":"C19","v":0},{"$f":"(E19/D6)*I5","v":0},null,{"$f":"IF(E19=0,0,((I19-(I19*J19%))))","v":0},null,{"$f":"L19*I19","v":0},{"$f":"IF(J6=0,0,(I19/J6))","v":0},null,null,null,null,null,null,"ACCOMPAGNEMENTS",null,null,null,null,"   R0-V255 B0"]
[null,null,null,null,{"$f":"IF(ISBLANK(B20),D20,B20*D20)","v":0},null,{"$f":"IF(ISBLANK(B20),0,(B20/D6)*I5)","v":0},{"$f":"C20","v":0},{"$f":"(E20/D6)*I5","v":0},null,{"$f":"IF(E20=0,0,((I20-(I20*J20%))))","v":0},null,{"$f":"L20*I20","v":0},{"$f":"IF(J6=0,0,(I20/J6))","v":0},null,null,"Exemple :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si vous souhaitez faire du copier/ coller sur un document avec macro procédez comme suit :"]
[null,null,null,null,{"$f":"IF(ISBLANK(B21),D21,B21*D21)","v":0},null,{"$f":"IF(ISBLANK(B21),0,(B21/D6)*I5)","v":0},{"$f":"C21","v":0},{"$f":"(E21/D6)*I5","v":0},null,{"$f":"IF(E21=0,0,((I21-(I21*J21%))))","v":0},null,{"$f":"L21*I21","v":0},{"$f":"IF(J6=0,0,(I21/J6))","v":0},null,null,"❷","❸","❹",null,"PREPARATIONS CHAUDES",null,null,null,null,"   R255-V204 B153",null,null,null,null,null,"Cliquez sur l'onglet de la feuille"]
[null,null,null,null,{"$f":"IF(ISBLANK(B22),D22,B22*D22)","v":0},null,{"$f":"IF(ISBLANK(B22),0,(B22/D6)*I5)","v":0},{"$f":"C22","v":0},{"$f":"(E22/D6)*I5","v":0},null,{"$f":"IF(E22=0,0,((I22-(I22*J22%))))","v":0},null,{"$f":"L22*I22","v":0},{"$f":"IF(J6=0,0,(I22/J6))","v":0},null,null,"Nb d'unités","Quoi","Poids Unitaire",null,null,null,null,null,null,null,null,null,null,null,null,"clic droit : Visualiser le code"]
[null,null,null,null,{"$f":"IF(ISBLANK(B23),D23,B23*D23)","v":0},null,{"$f":"IF(ISBLANK(B23),0,(B23/D6)*I5)","v":0},{"$f":"C23","v":0},{"$f":"(E23/D6)*I5","v":0},null,{"$f":"IF(E23=0,0,((I23-(I23*J23%))))","v":0},null,{"$f":"L23*I23","v":0},{"$f":"IF(J6=0,0,(I23/J6))","v":0},null,null,null,null,null,null,"PLAT PRINCIPAL ",null,null,null,null,"  R255-V0 B255",null,null,null,null,null,"dans worksheet   copiez le code et collez le sur le bloc note de votre PC"]
[null,null,null,null,{"$f":"IF(ISBLANK(B24),D24,B24*D24)","v":0},null,{"$f":"IF(ISBLANK(B24),0,(B24/D6)*I5)","v":0},{"$f":"C24","v":0},{"$f":"(E24/D6)*I5","v":0},null,{"$f":"IF(E24=0,0,((I24-(I24*J24%))))","v":0},null,{"$f":"L24*I24","v":0},{"$f":"IF(J6=0,0,(I24/J6))","v":0},null,null,2,"pommes",0.05,null,null,null,null,null,null,null,null,null,null,null,null,"retournez dans worksheet et supprimez le code"]
[null,null,null,null,{"$f":"IF(ISBLANK(B25),D25,B25*D25)","v":0},null,{"$f":"IF(ISBLANK(B25),0,(B25/D6)*I5)","v":0},{"$f":"C25","v":0},{"$f":"(E25/D6)*I5","v":0},null,{"$f":"IF(E25=0,0,((I25-(I25*J25%))))","v":0},null,{"$f":"L25*I25","v":0},{"$f":"IF(J6=0,0,(I25/J6))","v":0},null,null,null,"œufs liquides",null,null,"CRUDITES",null,null,null,null,"   R0-V128 B0",null,null,null,null,null,"Fermez votre document puis ouvrez le"]
[null,null,null,null,{"$f":"IF(ISBLANK(B26),D26,B26*D26)","v":0},null,{"$f":"IF(ISBLANK(B26),0,(B26/D6)*I5)","v":0},{"$f":"C26","v":0},{"$f":"(E26/D6)*I5","v":0},null,{"$f":"IF(E26=0,0,((I26-(I26*J26%))))","v":0},null,{"$f":"L26*I26","v":0},{"$f":"IF(J6=0,0,(I26/J6))","v":0},null,null,null,null,0.15,null,null,null,null,null,null,null,null,null,null,null,null,"travaillez dans votre document"]
[null,null,null,null,{"$f":"IF(ISBLANK(B27),D27,B27*D27)","v":0},null,{"$f":"IF(ISBLANK(B27),0,(B27/D6)*I5)","v":0},{"$f":"C27","v":0},{"$f":"(E27/D6)*I5","v":0},null,{"$f":"IF(E27=0,0,((I27-(I27*J27%))))","v":0},null,{"$f":"L27*I27","v":0},{"$f":"IF(J6=0,0,(I27/J6))","v":0},null,null,null,"jaunes d'œufs",null,null,"CUIDITES",null,null,null,null,"   R153-V204 B0",null,null,null,null,null,"lorsque vous avez fini recopiez le code collé sur le bloc note "]
[null,null,null,null,{"$f":"IF(ISBLANK(B28),D28,B28*D28)","v":0},null,{"$f":"IF(ISBLANK(B28),0,(B28/D6)*I5)","v":0},{"$f":"C28","v":0},{"$f":"(E28/D6)*I5","v":0},null,{"$f":"IF(E28=0,0,((I28-(I28*J28%))))","v":0},null,{"$f":"L28*I28","v":0},{"$f":"IF(J6=0,0,(I28/J6))","v":0},null,null,3,"jaunes",0.02,null,null,null,null,null,null,null,null,null,null,null,null,"pour le coller à son emplacement dans worksheet"]
[null,null,null,null,{"$f":"IF(ISBLANK(B29),D29,B29*D29)","v":0},null,{"$f":"IF(ISBLANK(B29),0,(B29/D6)*I5)","v":0},{"$f":"C29","v":0},{"$f":"(E29/D6)*I5","v":0},null,{"$f":"IF(E29=0,0,((I29-(I29*J29%))))","v":0},null,{"$f":"L29*I29","v":0},{"$f":"IF(J6=0,0,(I29/J6))","v":0},null,null,null,"œufs coquille",null,null,"FECULENTS",null,null,null,null,"   R153-V51 B0",null,null,null,null,null,"enregistrez "]
[null,null,null,null,{"$f":"IF(ISBLANK(B30),D30,B30*D30)","v":0},null,{"$f":"IF(ISBLANK(B30),0,(B30/D6)*I5)","v":0},{"$f":"C30","v":0},{"$f":"(E30/D6)*I5","v":0},null,{"$f":"IF(E30=0,0,((I30-(I30*J30%))))","v":0},null,{"$f":"L30*I30","v":0},{"$f":"IF(J6=0,0,(I30/J6))","v":0},null,null,5,"œufs",0.05,null,null,null,null,null,null,null,null,null,null,null,null,"verifiez que l'enregistrement soit bien au format Excel,xlsm"]
[null,null,null,null,{"$f":"IF(ISBLANK(B31),D31,B31*D31)","v":0},null,{"$f":"IF(ISBLANK(B31),0,(B31/D6)*I5)","v":0},{"$f":"C31","v":0},{"$f":"(E31/D6)*I5","v":0},null,{"$f":"IF(E31=0,0,((I31-(I31*J31%))))","v":0},null,{"$f":"L31*I31","v":0},{"$f":"IF(J6=0,0,(I31/J6))","v":0},null,null,null,null,null,null,"COMPOSÉS VERTS",null,null,null,null,"   R0-V255 B0",null,null,null,null,null,"ou dans un document supportant les macros"]
[null,null,null,null,{"$f":"IF(ISBLANK(B32),D32,B32*D32)","v":0},null,{"$f":"IF(ISBLANK(B32),0,(B32/D6)*I5)","v":0},{"$f":"C32","v":0},{"$f":"(E32/D6)*I5","v":0},null,{"$f":"IF(E32=0,0,((I32-(I32*J32%))))","v":0},null,{"$f":"L32*I32","v":0},{"$f":"IF(J6=0,0,(I32/J6))","v":0},null,null,"⑥ % Perte (facultatif)"]
[null,null,null,null,{"$f":"IF(ISBLANK(B33),D33,B33*D33)","v":0},null,{"$f":"IF(ISBLANK(B33),0,(B33/D6)*I5)","v":0},{"$f":"C33","v":0},{"$f":"(E33/D6)*I5","v":0},null,{"$f":"IF(E33=0,0,((I33-(I33*J33%))))","v":0},null,{"$f":"L33*I33","v":0},{"$f":"IF(J6=0,0,(I33/J6))","v":0},null,null,null,null,null,null,"LAITAGES FROMAGES",null,null,null,null,"   R0-V0 B255"]
[null,null,null,null,{"$f":"IF(ISBLANK(B34),D34,B34*D34)","v":0},null,{"$f":"IF(ISBLANK(B34),0,(B34/D6)*I5)","v":0},{"$f":"C34","v":0},{"$f":"(E34/D6)*I5","v":0},null,{"$f":"IF(E34=0,0,((I34-(I34*J34%))))","v":0},null,{"$f":"L34*I34","v":0},{"$f":"IF(J6=0,0,(I34/J6))","v":0},null,null,"❼ l'Auteur a prévu la recette pour "]
[null,null,null,null,{"$f":"IF(ISBLANK(B35),D35,B35*D35)","v":0},null,{"$f":"IF(ISBLANK(B35),0,(B35/D6)*I5)","v":0},{"$f":"C35","v":0},{"$f":"(E35/D6)*I5","v":0},null,{"$f":"IF(E35=0,0,((I35-(I35*J35%))))","v":0},null,{"$f":"L35*I35","v":0},{"$f":"IF(J6=0,0,(I35/J6))","v":0},null,null,null,null,null,null,"LAITAGES +FECULENTS",null,null,null,null,"   R153-V204 B255"]
[null,null,null,null,{"$f":"IF(ISBLANK(B36),D36,B36*D36)","v":0},null,{"$f":"IF(ISBLANK(B36),0,(B36/D6)*I5)","v":0},{"$f":"C36","v":0},{"$f":"(E36/D6)*I5","v":0},null,{"$f":"IF(E36=0,0,((I36-(I36*J36%))))","v":0},null,{"$f":"L36*I36","v":0},{"$f":"IF(J6=0,0,(I36/J6))","v":0},null,null,"❽ vos Effectifs"]
[null,null,null,null,{"$f":"IF(ISBLANK(B37),D37,B37*D37)","v":0},null,{"$f":"IF(ISBLANK(B37),0,(B37/D6)*I5)","v":0},{"$f":"C37","v":0},{"$f":"(E37/D6)*I5","v":0},null,{"$f":"IF(E37=0,0,((I37-(I37*J37%))))","v":0},null,{"$f":"L37*I37","v":0},{"$f":"IF(J6=0,0,(I37/J6))","v":0},null,null,null,null,null,null,"DESSERTS",null,null,null,null,"   R0-V102 B204"]
[null,null,null,null,{"$f":"IF(ISBLANK(B38),D38,B38*D38)","v":0},null,{"$f":"IF(ISBLANK(B38),0,(B38/D6)*I5)","v":0},{"$f":"C38","v":0},{"$f":"(E38/D6)*I5","v":0},null,{"$f":"IF(E38=0,0,((I38-(I38*J38%))))","v":0},null,{"$f":"L38*I38","v":0},{"$f":"IF(J6=0,0,(I38/J6))","v":0},null,null,"⑨ Prx au Kg ou Unité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"]
[null,null,null,0,null,null,0,0,null,0,null,null,{"$f":"L39*I39","v":0},{"$f":"IF(ISERROR(M39/M41),\"\",M39/M41)","v":""},null,null,null,null,null,null,"GOUTER",null,null,null,null,"   R204-V153 B255",null,null,null,null,null,"  Calculate"]
[null,{"$f":"SUM(B10:B39)","v":0},null,null,{"$f":"SUM(E10:E38)","v":0},null,0,{"$f":"SUM(H10:H39)","v":0},{"$f":"SUM(I10:I38)","v":0},{"$f":"I40-K40","v":0},{"$f":"SUM(K10:K38)","v":0},null,{"$f":"SUM(M10:M38)","v":0},{"$f":"SUM(N10:N39)","v":0},null,null,"⑩ Coefficient vente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Sub"]
[null," Nb d'unités","Quoi","Poids Unitaire","④ Total Auteur",null,"UNITE","Poids recette","BRUT arrondi","Perte","NET à servir",null,"Prix T HT","Pour 1Kg Brut",null,null,"⑪ lien Internet",null,null,null,10,8,9,9,"largeurs de colonnes"]
[null,"Auteur de la recette et références bibliographiques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"CELL(\"largeur\",R42)","v":16},{"$f":"CELL(\"largeur\",S42)","v":16}]
[null,"⑪ lien Internet"]
[null,{"$f":"CELL(\"filename\",A3)","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12.Modèle.vierge"},null,null,null,null,null,null,null,null,null,null,null,null,null,null," Aide à la décision"]
[null,0,"Technique :",null,null,null,null,null,"Durée préparation","_:_",null,null,"Durée de cuisson",null,null,null,"Nb de portions","Poids portion ","Total"]
[null,{"$f":"IF(ISBLANK(C46),\"\",LARGE(B45:B45,1)+1)","v":""},null,null,null,null,null,"Infos :",null,null,null,null,null,null,null,null,150,250,{"$f":"(R46*Q46)/1000","v":37.5}]
[null,{"$f":"IF(ISBLANK(C47),\"\",LARGE(B45:B46,1)+1)","v":1},"NUMÉROTATION AUTOMATIQUE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Saisissez vos valeurs dans les tableaux"]
[null,{"$f":"IF(ISBLANK(C48),\"\",LARGE(B45:B47,1)+1)","v":""},null,"si vous ne voulez pas de N°",null,null,null,null,null,null,null,null,null,null,null,null,"Pourcentages Brut / Net et Net / Brut","Brut","NET ASSIETTE"]
[null,{"$f":"IF(ISBLANK(C49),\"\",LARGE(B45:B48,1)+1)","v":""},null,"saisissez du texte dans ces colonnes",null,null,null,null,null,null,null,null,null,null,null,null,null,200,140]
[null,{"$f":"IF(ISBLANK(C50),\"\",LARGE(B45:B49,1)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,30]
[null,{"$f":"IF(ISBLANK(C51),\"\",LARGE(B45:B50,1)+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R49=0,0,((R49-(R49*R50%))))/1000","v":0.14000000000000001},{"$f":"(S49/(100-S50)*100)/1000","v":0.2}]
[null,{"$f":"IF(ISBLANK(C52),\"\",LARGE(B45:B51,1)+1)","v":""},null,null,null,null,null,"Auteurs"]
[null,{"$f":"IF(ISBLANK(C53),\"\",LARGE(B45:B52,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C54),\"\",LARGE(B45:B53,1)+1)","v":""}]
[null,"L'utilisation professionnelle des fiches vous engage à connaître la réglementation en matière d'hygiène et HACCP.Procédures non développées ici pour ne pas alourdir les documents"]
[null,0,"MISE EN PLACE DU POSTE DE TRAVAIL"]
[null,{"$f":"IF(ISBLANK(C57),\"\",LARGE(B56:B56,1)+1)","v":1},"tenue professionnelle de circonstance (charlotte-masque)",null,null,null,null,{"$f":"MAX(B57:B60)+1","v":4},"se laver les mains souvent - prévoir gants"]
[null,{"$f":"IF(ISBLANK(C58),\"\",LARGE(B56:B57,1)+1)","v":2},"verifier - bactéricide - esssuie mains - sacs poubelle",null,null,null,null,{"$f":"IF(ISBLANK(I58),\"\",LARGE(H57:H57,1)+1)","v":5},"sélectionner le matériel nécessaire"]
[null,{"$f":"IF(ISBLANK(C59),\"\",LARGE(B56:B58,1)+1)","v":3},"vérifier températures - locaux et chambres froides",null,null,null,null,{"$f":"IF(ISBLANK(I59),\"\",LARGE(H57:H58,1)+1)","v":6},"laver et désinfecter le matériel et le poste de travail"]
[null,{"$f":"IF(ISBLANK(C60),\"\",LARGE(B56:B59,1)+1)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I60),\"\",LARGE(H57:H59,1)+1)","v":7},"en suivant les protocoles"]
[null,0,"ORGANISATION RAISONNÉE DU TRAVAIL",null,null,null,null,null,{"$f":"MAX(B61:B77)","v":1},"Observations :",null,null,null,null,null,null,{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"Q"},{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"R"},{"$f":"LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN(),4))-1)","v":"S"},"< colonnes"]
[null,{"$f":"IF(ISBLANK(C62),\"\",LARGE(B61:B61,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J62),\"\",LARGE(I61:I61,1)+1)","v":""},null,null,null,null,null,null,null,0,"MISE EN ŒUVRE"]
[null,{"$f":"IF(ISBLANK(C63),\"\",LARGE(B61:B62,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J63),\"\",LARGE(I61:I62,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R63),\"\",LARGE(Q62:Q62,1)+1)","v":1},"la numérotation est automatique"]
[null,{"$f":"IF(ISBLANK(C64),\"\",LARGE(B61:B63,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J64),\"\",LARGE(I61:I63,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R64),\"\",LARGE(Q62:Q63,1)+1)","v":2},"lorsque vous saisissez du texte"]
[null,{"$f":"IF(ISBLANK(C65),\"\",LARGE(B61:B64,1)+1)","v":1},"NUMÉROTATION AUTOMATIQUE",null,null,null,null,null,{"$f":"IF(ISBLANK(J65),\"\",LARGE(I61:I64,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R65),\"\",LARGE(Q62:Q64,1)+1)","v":3},"dans cette colonne R"]
[null,{"$f":"IF(ISBLANK(C66),\"\",LARGE(B61:B65,1)+1)","v":""},null,"si vous ne voulez pas de N°",null,null,null,null,{"$f":"IF(ISBLANK(J66),\"\",LARGE(I61:I65,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R66),\"\",LARGE(Q62:Q65,1)+1)","v":""},null,"si vous ne voulez pas de numérotation"]
[null,{"$f":"IF(ISBLANK(C67),\"\",LARGE(B61:B66,1)+1)","v":""},null,"saisissez du texte dans ces colonnes",null,null,null,null,{"$f":"IF(ISBLANK(J67),\"\",LARGE(I61:I66,1)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(R67),\"\",LARGE(Q62:Q66,1)+1)","v":""},null,"saisissez votre texte dans celle-ci colonne S pour l'exemple"]
[null,{"$f":"IF(ISBLANK(C68),\"\",LARGE(B61:B67,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J68),\"\",LARGE(I61:I67,1)+1)","v":2},"NUMÉROTATION AUTOMATIQUE",null,null,null,null,null,null,{"$f":"IF(ISBLANK(R68),\"\",LARGE(Q62:Q67,1)+1)","v":4},"formule utilisée :SI(ESTVIDE(R68);\"\";GRANDE.VALEUR(Q62:Q67;1)+1"]
[null,{"$f":"IF(ISBLANK(C69),\"\",LARGE(B61:B68,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J69),\"\",LARGE(I61:I68,1)+1)","v":""},null,"si vous ne voulez pas de N°",null,null,null,null,null,{"$f":"IF(ISBLANK(R69),\"\",LARGE(Q62:Q68,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C70),\"\",LARGE(B61:B69,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J70),\"\",LARGE(I61:I69,1)+1)","v":""},null,"saisissez du texte dans ces colonnes"]
[null,{"$f":"IF(ISBLANK(C71),\"\",LARGE(B61:B70,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J71),\"\",LARGE(I61:I70,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C72),\"\",LARGE(B61:B71,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J72),\"\",LARGE(I61:I71,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C73),\"\",LARGE(B61:B72,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J73),\"\",LARGE(I61:I72,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C74),\"\",LARGE(B61:B73,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J74),\"\",LARGE(I61:I73,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C75),\"\",LARGE(B61:B74,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J75),\"\",LARGE(I61:I74,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C76),\"\",LARGE(B61:B75,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J76),\"\",LARGE(I61:I75,1)+1)","v":""}]
[null,{"$f":"IF(ISBLANK(C77),\"\",LARGE(B61:B76,1)+1)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(J77),\"\",LARGE(I61:I76,1)+1)","v":""}]
[null,"Pour vérification : cocher - entourer - ou surligner les produits ou actions concernées",null,null,null,null,null,null,{"$f":"IF(ISBLANK(J78),\"\",LARGE(I61:I77,1)+1)","v":""}]
[null,"L'utilisation professionnelle de cette recette vous engage à connaître la réglementation en matière d'hygiène et HACCP. Procédures non développées ici pour ne pas alourdir la fiche technique"]
[]
[null,"Conception 1998 Cuisine centrale de Clamart Joël Leboucher - Adaptation 2009 Cuisine Centrale de Rochefort sur mer sur un document avec macro..de D.DEMILLY "]
[null,"Adresse PC",null,{"$f":"CELL(\"filename\",A1)","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12.Modèle.vierge"}]
[null,"Mise à jour",null,"du 21-02-2017- Annule et remplace les versions précédentes"]
[null,"Adaptation 2022 Joël Leboucher..UPRT \"Union des Personnels de la Restauration Territoriale\"  membre du réseau RESTAU'CO"]
[null,8,8,8,8,24,8,8,10,10,10,8,9,9,"largeurs de colonnes manuel"]
[null,{"$f":"CELL(\"largeur\",B86)","v":8},{"$f":"CELL(\"largeur\",C86)","v":8},{"$f":"CELL(\"largeur\",D86)","v":8},{"$f":"CELL(\"largeur\",E86)","v":8},{"$f":"CELL(\"largeur\",F86)","v":24},{"$f":"CELL(\"largeur\",G86)","v":8},{"$f":"CELL(\"largeur\",H86)","v":8},{"$f":"CELL(\"largeur\",I86)","v":10},{"$f":"CELL(\"largeur\",J86)","v":10},{"$f":"CELL(\"largeur\",K86)","v":10},{"$f":"CELL(\"largeur\",L86)","v":8},{"$f":"CELL(\"largeur\",M86)","v":9},{"$f":"CELL(\"largeur\",N86)","v":9},"largeurs de colonnes contrôle par formule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN"]

{"sheet":"Vocabulaire","index":4,"n_rows":122,"n_cols":42,"rows_kept":122,"cut":false,"hidden":false,"merged":[[1,22,1,38],[2,1,2,9],[2,11,2,19]]}
[null,"Mise à jour du 2 Décembre 2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOCABULAIRE PROFESSIONNEL    un verbe…une action",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le vocabulaire professionnel en pâtisserie"]
[null,"VOCABULAIRE PROFESSIONNEL \" CUISINE DE COMPOSITION\" ",null,null,null,null,null,null,null,null,null,"VOCABULAIRE PROFESSIONNEL \"La CUISINE DE REFERENCE\" Michel MAINCENT",null,null,null,null,null,null,null,null,null,null,"En complément vous avez des liens en bas de page",null,null,null,null,null,null,null,null,null,null,"Quelques verbes d'action complémentaires"]
[null,null,"A",null,"E",null,"P",null,"R",null,null,null,"A",null,"D",null,"H",null,"R",null,null,null,"A",null,"D",null,"F",null,"M",null,"R",null,"T",1,"accomplir",null,{"$f":"AH59+1","v":57},"générer",null,null,"Lien >","http://www.juliemyrtille.com/lexique_du_patissier/"]
[null,1,"Abaisser la temp. à coeur",{"$f":"B22+1","v":16},"Egrener",{"$f":"D26+1","v":32},"Parfumer",{"$f":"F24+1","v":51},"Respecter le délai de 2 H",null,null,1,"Abaisser",{"$f":"L52+1","v":46},"Dépouiller",{"$f":"N52+1","v":91},"Habiller",{"$f":"P52+1","v":130},"Réduire",null,null,1,"Abaisser",{"$f":"V62+1","v":56},"Dauber",{"$f":"X63+1","v":113},"Façonner",{"$f":"Z62+1","v":163},"Macérer",{"$f":"AB62+1","v":217},"Rabattre",{"$f":"AD57+1","v":268},"Tabler",{"$f":"LARGE(AH4:AH4,1)+1","v":2},"acheter",null,{"$f":"LARGE(AK4:AK4,1)+1","v":58},"gérer",null,null,null,"A"]
[null,{"$f":"LARGE(B5:B5,1)+1","v":2},"Accompagner",{"$f":"LARGE(D5:D5,1)+1","v":17},"Eliminer",{"$f":"LARGE(F5:F5,1)+1","v":33},"Parsemer",{"$f":"LARGE(H5:H5,1)+1","v":52},"Retirer",null,null,{"$f":"LARGE(L5:L5,1)+1","v":2},"Abricoter",{"$f":"LARGE(N5:N5,1)+1","v":47},"Dérober",{"$f":"LARGE(P5:P5,1)+1","v":92},"Hacher",{"$f":"LARGE(R5:R5,1)+1","v":131},"Relever",null,null,{"$f":"LARGE(V5:V5,1)+1","v":2},"Abaisser la temp. à coeur",{"$f":"LARGE(X5:X5,1)+1","v":57},"Décanter",{"$f":"LARGE(Z5:Z5,1)+1","v":114},"Faire bouillir",{"$f":"LARGE(AB5:AB5,1)+1","v":164},"Maintenir en temp. sup à 63°",{"$f":"LARGE(AD5:AD5,1)+1","v":218},"Raccourcir",{"$f":"LARGE(AF5:AF5,1)+1","v":269},"Tailler",{"$f":"LARGE(AH4:AH5,1)+1","v":3},"achever",null,{"$f":"LARGE(AK4:AK5,1)+1","v":59},"identifier",null,null,null,"Abaisse : morceau de pâte que l’on étale au rouleau à une épaisseur voulue"]
[null,{"$f":"LARGE(B5:B6,1)+1","v":3},"Additionner",{"$f":"LARGE(D5:D6,1)+1","v":18},"Enfourner",{"$f":"LARGE(F5:F6,1)+1","v":34},"Peler",{"$f":"LARGE(H5:H6,1)+1","v":53},"Retourner",null,null,{"$f":"LARGE(L5:L6,1)+1","v":3},"Arroser",{"$f":"LARGE(N5:N6,1)+1","v":48},"Désosser",{"$f":"LARGE(P5:P6,1)+1","v":93},"Historier",{"$f":"LARGE(R5:R6,1)+1","v":132},"Remonter",null,null,{"$f":"LARGE(V5:V6,1)+1","v":3},"Abricoter",{"$f":"LARGE(X5:X6,1)+1","v":58},"Décercler",{"$f":"LARGE(Z5:Z6,1)+1","v":115},"Farcir",{"$f":"LARGE(AB5:AB6,1)+1","v":165},"Manchonner",{"$f":"LARGE(AD5:AD6,1)+1","v":219},"Rafraîchir",{"$f":"LARGE(AF5:AF6,1)+1","v":270},"Tamiser",{"$f":"LARGE(AH4:AH6,1)+1","v":4},"activer",null,{"$f":"LARGE(AK4:AK6,1)+1","v":60},"imaginer",null,null,null,"Abaisser : étaler une pâte au rouleau à une épaisseur voulue."]
[null,{"$f":"LARGE(B5:B7,1)+1","v":4},"Adjoindre",{"$f":"LARGE(D5:D7,1)+1","v":19},"Enfourner",{"$f":"LARGE(F5:F7,1)+1","v":35},"Porter à ébullition",{"$f":"LARGE(H5:H7,1)+1","v":54},"Rincer",null,null,{"$f":"LARGE(L5:L7,1)+1","v":4},"Assaisonner",{"$f":"LARGE(N5:N7,1)+1","v":49},"Dessécher",null,"I",{"$f":"LARGE(R5:R7,1)+1","v":133},"Revenir",null,null,{"$f":"LARGE(V5:V7,1)+1","v":4},"Accoler",{"$f":"LARGE(X5:X7,1)+1","v":59},"Décorer",{"$f":"LARGE(Z5:Z7,1)+1","v":116},"Farder",{"$f":"LARGE(AB5:AB7,1)+1","v":166},"Manier",{"$f":"LARGE(AD5:AD7,1)+1","v":220},"Raidir",{"$f":"LARGE(AF5:AF7,1)+1","v":271},"Tamponner",{"$f":"LARGE(AH4:AH7,1)+1","v":5},"agrandir",null,{"$f":"LARGE(AK4:AK7,1)+1","v":61},"inscrire",null,null,null,"Abricoter : étendre une confiture d’abricot à l’aide d’un pinceau sur un entremets, sur une tarte ou une préparation pour la rendre brillante et la protéger en surface en limitant les risques de dessèchement et de brunissement enzymatique."]
[null,{"$f":"LARGE(B5:B8,1)+1","v":5},"Agir rapidement",{"$f":"LARGE(D5:D8,1)+1","v":20},"Etaler",{"$f":"LARGE(F5:F8,1)+1","v":36},"Préchauffer",null,"S",null,null,null,"B",{"$f":"LARGE(N5:N8,1)+1","v":50},"Détendre",{"$f":"LARGE(P5:P8,1)+1","v":94},"Inciser",{"$f":"LARGE(R5:R8,1)+1","v":134},"Rissoler",null,null,{"$f":"LARGE(V5:V8,1)+1","v":5},"Accompagner",{"$f":"LARGE(X5:X8,1)+1","v":60},"Décortiquer",{"$f":"LARGE(Z5:Z8,1)+1","v":117},"Fariner",{"$f":"LARGE(AB5:AB8,1)+1","v":167},"Manipuler",{"$f":"LARGE(AD5:AD8,1)+1","v":221},"Rassir",{"$f":"LARGE(AF5:AF8,1)+1","v":272},"Tapisser",{"$f":"LARGE(AH4:AH8,1)+1","v":6},"ajuster",null,{"$f":"LARGE(AK4:AK8,1)+1","v":62},"insérer",null,null,null,"Accoler : réunir, rassembler deux ou plusieurs éléments pour constituer un gâteau, un élément de fabrication ou autre."]
[null,{"$f":"LARGE(B5:B9,1)+1","v":6},"Ajouter",null,"F",{"$f":"LARGE(F5:F9,1)+1","v":37},"Prélever",{"$f":"LARGE(H5:H9,1)+1","v":55},"Saupoudrer",null,null,{"$f":"LARGE(L5:L9,1)+1","v":5},"Barder",{"$f":"LARGE(N5:N9,1)+1","v":51},"Dorer",null,"L",{"$f":"LARGE(R5:R9,1)+1","v":135},"Rompre",null,null,{"$f":"LARGE(V5:V9,1)+1","v":6},"Additionner",{"$f":"LARGE(X5:X9,1)+1","v":61},"Décuire",{"$f":"LARGE(Z5:Z9,1)+1","v":118},"Festonner",{"$f":"LARGE(AB5:AB9,1)+1","v":168},"Marbrer",{"$f":"LARGE(AD5:AD9,1)+1","v":222},"Rayer",{"$f":"LARGE(AF5:AF9,1)+1","v":273},"Terminer",{"$f":"LARGE(AH4:AH9,1)+1","v":7},"améliorer",null,{"$f":"LARGE(AK4:AK9,1)+1","v":63},"inspecter",null,null,null,"Appareil : mélange de différentes substances alimentaires entrant dans la composition d’une préparation de pâtisserie."]
[null,{"$f":"LARGE(B5:B10,1)+1","v":7},"Aplatir",{"$f":"LARGE(D5:D10,1)+1","v":21},"Faire bouillir",{"$f":"LARGE(F5:F10,1)+1","v":38},"Préparer",{"$f":"LARGE(H5:H10,1)+1","v":56},"Servir",null,null,{"$f":"LARGE(L5:L10,1)+1","v":6},"Beurrer",{"$f":"LARGE(N5:N10,1)+1","v":52},"Dresser",{"$f":"LARGE(P5:P10,1)+1","v":95},"Lier",{"$f":"LARGE(R5:R10,1)+1","v":136},"Rôtir",null,null,{"$f":"LARGE(V5:V10,1)+1","v":7},"Adjoindre",{"$f":"LARGE(X5:X10,1)+1","v":62},"Déffilandrer",{"$f":"LARGE(Z5:Z10,1)+1","v":119},"Fileter",{"$f":"LARGE(AB5:AB10,1)+1","v":169},"Mariner",{"$f":"LARGE(AD5:AD10,1)+1","v":223},"Réaliser",{"$f":"LARGE(AF5:AF10,1)+1","v":274},"Tomber",{"$f":"LARGE(AH4:AH10,1)+1","v":8},"aménager",null,{"$f":"LARGE(AK4:AK10,1)+1","v":64},"installer",null,null,null,"Apprêt : technique survenant après le façonnage d’une pâte levée fermentée (pain, brioche…), pour assurer le développement des pièces par la fermentation avant la cuisson."]
[null,null,"B",null,"G",{"$f":"LARGE(F5:F11,1)+1","v":39},"Protéger",{"$f":"LARGE(H5:H11,1)+1","v":57},"Snacker",null,null,{"$f":"LARGE(L5:L11,1)+1","v":7},"Blanchir",null,"E",{"$f":"LARGE(P5:P11,1)+1","v":96},"Limoner",null,"S",null,null,{"$f":"LARGE(V5:V11,1)+1","v":8},"Agir rapidement",{"$f":"LARGE(X5:X11,1)+1","v":63},"Déglacer",{"$f":"LARGE(Z5:Z11,1)+1","v":120},"Fixer",{"$f":"LARGE(AB5:AB11,1)+1","v":170},"Marquer",{"$f":"LARGE(AD5:AD11,1)+1","v":224},"Réchauffer en moins d'1 H",{"$f":"LARGE(AF5:AF11,1)+1","v":275},"Torréfier",{"$f":"LARGE(AH4:AH11,1)+1","v":9},"analyser",null,{"$f":"LARGE(AK4:AK11,1)+1","v":65},"inventer",null,null,null,"Aromatiser : incorporer un arôme ou un aromate à une préparation."]
[null,{"$f":"LARGE(B5:B12,1)+1","v":8},"Battre",{"$f":"LARGE(D5:D12,1)+1","v":22},"Garnir",null,"R",null,"T",null,null,{"$f":"LARGE(L5:L12,1)+1","v":8},"Blondir",{"$f":"LARGE(N5:N12,1)+1","v":53},"Ebarber",{"$f":"LARGE(P5:P12,1)+1","v":97},"Lisser",{"$f":"LARGE(R5:R12,1)+1","v":137},"Saigner",null,null,{"$f":"LARGE(V5:V12,1)+1","v":9},"Ajouter",{"$f":"LARGE(X5:X12,1)+1","v":64},"Dégorger",{"$f":"LARGE(Z5:Z12,1)+1","v":121},"Flamber",{"$f":"LARGE(AB5:AB12,1)+1","v":171},"Masquer",{"$f":"LARGE(AD5:AD12,1)+1","v":225},"Recouvrir",{"$f":"LARGE(AF5:AF12,1)+1","v":276},"Tourer",{"$f":"LARGE(AH4:AH12,1)+1","v":10},"appliquer",null,{"$f":"LARGE(AK4:AK12,1)+1","v":66},"inventorier",null,null,null,"B"]
[null,null,"C",null,"I",{"$f":"LARGE(F5:F13,1)+1","v":40},"Réaliser",{"$f":"LARGE(H5:H13,1)+1","v":58},"Terminer",null,null,{"$f":"LARGE(L5:L13,1)+1","v":9},"Bouler",{"$f":"LARGE(N5:N13,1)+1","v":54},"Ecailler",{"$f":"LARGE(P5:P13,1)+1","v":98},"Lustrer",{"$f":"LARGE(R5:R13,1)+1","v":138},"Saisir",null,null,{"$f":"LARGE(V5:V13,1)+1","v":10},"Aplatir",{"$f":"LARGE(X5:X13,1)+1","v":65},"Dégourdir",{"$f":"LARGE(Z5:Z13,1)+1","v":122},"Flanquer",{"$f":"LARGE(AB5:AB13,1)+1","v":172},"Masser",{"$f":"LARGE(AD5:AD13,1)+1","v":226},"Rectifier",{"$f":"LARGE(AF5:AF13,1)+1","v":277},"Tourner",{"$f":"LARGE(AH4:AH13,1)+1","v":11},"approuver",null,{"$f":"LARGE(AK4:AK13,1)+1","v":67},"localiser",null,null,null,"Beurrer :"]
[null,{"$f":"LARGE(B5:B14,1)+1","v":9},"Chauffer",{"$f":"LARGE(D5:D14,1)+1","v":23},"Incorporer",{"$f":"LARGE(F5:F14,1)+1","v":41},"Réchauffer en moins d'1 H",null,"U",null,null,{"$f":"LARGE(L5:L14,1)+1","v":10},"Braiser",{"$f":"LARGE(N5:N14,1)+1","v":55},"Ecaler",null,"M",{"$f":"LARGE(R5:R14,1)+1","v":139},"Sangler",null,null,{"$f":"LARGE(V5:V14,1)+1","v":11},"Aromatiser",{"$f":"LARGE(X5:X14,1)+1","v":66},"Dégraisser",{"$f":"LARGE(Z5:Z14,1)+1","v":123},"Fleurer",{"$f":"LARGE(AB5:AB14,1)+1","v":173},"Mélanger",{"$f":"LARGE(AD5:AD14,1)+1","v":227},"Réduire",{"$f":"LARGE(AF5:AF14,1)+1","v":278},"Travailler",{"$f":"LARGE(AH4:AH14,1)+1","v":12},"archiver",null,{"$f":"LARGE(AK4:AK14,1)+1","v":68},"maintenir",null,null,null,"– ajouter de beurre à une sauce"]
[null,{"$f":"LARGE(B5:B15,1)+1","v":10},"Conserver",{"$f":"LARGE(D5:D15,1)+1","v":24},"Indications packaging",{"$f":"LARGE(F5:F15,1)+1","v":42},"Recouvrir",{"$f":"LARGE(H5:H15,1)+1","v":59},"Utiliser",null,null,{"$f":"LARGE(L5:L15,1)+1","v":11},"Brider",{"$f":"LARGE(N5:N15,1)+1","v":56},"Ecorcher",{"$f":"LARGE(P5:P15,1)+1","v":99},"Macérer",{"$f":"LARGE(R5:R15,1)+1","v":140},"Sauter",null,null,{"$f":"LARGE(V5:V15,1)+1","v":12},"Arroser",{"$f":"LARGE(X5:X15,1)+1","v":67},"Déhousser",{"$f":"LARGE(Z5:Z15,1)+1","v":124},"Foisonner",{"$f":"LARGE(AB5:AB15,1)+1","v":174},"Meringuer",{"$f":"LARGE(AD5:AD15,1)+1","v":228},"Refroidir",{"$f":"LARGE(AF5:AF15,1)+1","v":279},"Tremper",{"$f":"LARGE(AH4:AH15,1)+1","v":13},"assembler",null,{"$f":"LARGE(AK4:AK15,1)+1","v":69},"manier",null,null,null,"– enduire un moule ou un ustensile de beurre afin d’empêcher les mets d’attacher au fond ou aux parois."]
[null,{"$f":"LARGE(B5:B16,1)+1","v":11},"Contrôler",null,"J",{"$f":"LARGE(F5:F16,1)+1","v":43},"Rectifier",null,"V",null,null,null,"C",{"$f":"LARGE(N5:N16,1)+1","v":57},"Ecosser",{"$f":"LARGE(P5:P16,1)+1","v":100},"Manchonner",{"$f":"LARGE(R5:R16,1)+1","v":141},"Serrer",null,null,{"$f":"LARGE(V5:V16,1)+1","v":13},"Assaisonner",{"$f":"LARGE(X5:X16,1)+1","v":68},"Délayer",{"$f":"LARGE(Z5:Z16,1)+1","v":125},"Foncer",{"$f":"LARGE(AB5:AB16,1)+1","v":175},"Mettre au point",{"$f":"LARGE(AD5:AD16,1)+1","v":229},"Régénérer",{"$f":"LARGE(AF5:AF16,1)+1","v":280},"Tronçonner",{"$f":"LARGE(AH4:AH16,1)+1","v":14},"attacher",null,{"$f":"LARGE(AK4:AK16,1)+1","v":70},"manœuvrer",null,null,null,"– incorporer du beurre dans la détrempe d’une pâte feuilletée ou d’une pâte levée feuilletée, pour le tourage."]
[null,null,"D",{"$f":"LARGE(D5:D17,1)+1","v":25},"Jeter",{"$f":"LARGE(F5:F17,1)+1","v":44},"Refroidir",{"$f":"LARGE(H5:H17,1)+1","v":60},"Vérifier la temp.",null,null,{"$f":"LARGE(L5:L17,1)+1","v":12},"Canneler",{"$f":"LARGE(N5:N17,1)+1","v":58},"Ecumer",{"$f":"LARGE(P5:P17,1)+1","v":101},"Marbrer",{"$f":"LARGE(R5:R17,1)+1","v":142},"Singer",null,null,null,"B",{"$f":"LARGE(X5:X17,1)+1","v":69},"Démouler",{"$f":"LARGE(Z5:Z17,1)+1","v":126},"Fondre",{"$f":"LARGE(AB5:AB17,1)+1","v":176},"Mettre en cuisson",{"$f":"LARGE(AD5:AD17,1)+1","v":230},"Réhydrater",{"$f":"LARGE(AF5:AF17,1)+1","v":281},"Trousser",{"$f":"LARGE(AH4:AH17,1)+1","v":15},"attribuer",null,{"$f":"LARGE(AK4:AK17,1)+1","v":71},"mesurer",null,null,null,"Bain-marie : eau plus ou moins chaude dans laquelle on place des récipients contenant des préparations à cuire ou à tenir au chaud."]
[null,{"$f":"LARGE(B5:B18,1)+1","v":12},"Décorer",null,"L",{"$f":"LARGE(F5:F18,1)+1","v":45},"Réhydrater",{"$f":"LARGE(H5:H18,1)+1","v":61},"Verser",null,null,{"$f":"LARGE(L5:L18,1)+1","v":13},"Caraméliser",{"$f":"LARGE(N5:N18,1)+1","v":59},"Effilandrer",{"$f":"LARGE(P5:P18,1)+1","v":102},"Mariner",{"$f":"LARGE(R5:R18,1)+1","v":143},"Suer",null,null,{"$f":"LARGE(V5:V18,1)+1","v":14},"Barder",{"$f":"LARGE(X5:X18,1)+1","v":70},"Dénerver",{"$f":"LARGE(Z5:Z18,1)+1","v":127},"Fouetter",{"$f":"LARGE(AB5:AB18,1)+1","v":177},"Mijoter",{"$f":"LARGE(AD5:AD18,1)+1","v":231},"Relâcher",{"$f":"LARGE(AF5:AF18,1)+1","v":282},"Turbiner",{"$f":"LARGE(AH4:AH18,1)+1","v":16},"brancher",null,{"$f":"LARGE(AK4:AK18,1)+1","v":72},"mettre",null,null,null,"Battre : agiter vigoureusement une préparation à l’aide d’un fouet, pour la rendre homogène ou lui donner du volume (foisonnement)."]
[null,{"$f":"LARGE(B5:B19,1)+1","v":13},"Délayer",{"$f":"LARGE(D5:D19,1)+1","v":26},"Laver",{"$f":"LARGE(F5:F19,1)+1","v":46},"Remonter en température",null,null,null,null,{"$f":"LARGE(L5:L19,1)+1","v":14},"Châtrer",{"$f":"LARGE(N5:N19,1)+1","v":60},"Effiler",{"$f":"LARGE(P5:P19,1)+1","v":103},"Masquer",null,"T",null,null,{"$f":"LARGE(V5:V19,1)+1","v":15},"Battre",{"$f":"LARGE(X5:X19,1)+1","v":71},"Dénoyauter",{"$f":"LARGE(Z5:Z19,1)+1","v":128},"Fouler",{"$f":"LARGE(AB5:AB19,1)+1","v":178},"Mixer",{"$f":"LARGE(AD5:AD19,1)+1","v":232},"Relever",null,null,{"$f":"LARGE(AH4:AH19,1)+1","v":17},"calculer",null,{"$f":"LARGE(AK4:AK19,1)+1","v":73},"moderniser",null,null,null,"Beurre clarifié : beurre fondu et décanté dont on a éliminé de la caséine et du petit lait."]
[null,{"$f":"LARGE(B5:B20,1)+1","v":14},"Disperser",null,"M",{"$f":"LARGE(F5:F20,1)+1","v":47},"Remplacer",null,null,null,null,{"$f":"LARGE(L5:L20,1)+1","v":15},"Chaufroiter",{"$f":"LARGE(N5:N20,1)+1","v":61},"Egermer",{"$f":"LARGE(P5:P20,1)+1","v":104},"Masser",{"$f":"LARGE(R5:R20,1)+1","v":144},"Tailler",null,null,{"$f":"LARGE(V5:V20,1)+1","v":16},"Beurrer",{"$f":"LARGE(X5:X20,1)+1","v":72},"Denteler",{"$f":"LARGE(Z5:Z20,1)+1","v":129},"Fourrer",{"$f":"LARGE(AB5:AB20,1)+1","v":179},"Modeler",{"$f":"LARGE(AD5:AD20,1)+1","v":233},"Remonter en température",null,"U",{"$f":"LARGE(AH4:AH20,1)+1","v":18},"cataloguer",null,{"$f":"LARGE(AK4:AK20,1)+1","v":74},"monter",null,null,null,"Beurre en pommade : beurre ramolli ayant la consistance d’une pommade."]
[null,{"$f":"LARGE(B5:B21,1)+1","v":15},"Disposer",{"$f":"LARGE(D5:D21,1)+1","v":27},"Maintenir en temp. sup à 63°",{"$f":"LARGE(F5:F21,1)+1","v":48},"Remuer",null,null,null,null,{"$f":"LARGE(L5:L21,1)+1","v":16},"Chemiser",{"$f":"LARGE(N5:N21,1)+1","v":62},"Egoutter",{"$f":"LARGE(P5:P21,1)+1","v":105},"Meringuer",{"$f":"LARGE(R5:R21,1)+1","v":145},"Tamiser",null,null,{"$f":"LARGE(V5:V21,1)+1","v":17},"Blanchir",{"$f":"LARGE(X5:X21,1)+1","v":73},"Dépouiller",{"$f":"LARGE(Z5:Z21,1)+1","v":130},"Fraiser",{"$f":"LARGE(AB5:AB21,1)+1","v":180},"Moiner",{"$f":"LARGE(AD5:AD21,1)+1","v":234},"Remplacer",{"$f":"LARGE(AF5:AF21,1)+1","v":283},"Upériser",{"$f":"LARGE(AH4:AH21,1)+1","v":19},"centraliser",null,{"$f":"LARGE(AK4:AK21,1)+1","v":75},"naviguer",null,null,null,"Blanchiment : phénomène de déstabilisation d’une fabrication de chocolat, correspondants à la migration en surface des cristaux de sucre, liée à une conservation en atmosphère humide et/ou un travail du chocolat à des températures inadaptées."]
[null,null,null,{"$f":"LARGE(D5:D22,1)+1","v":28},"Manipuler",{"$f":"LARGE(F5:F22,1)+1","v":49},"Répartir",null,null,null,null,{"$f":"LARGE(L5:L22,1)+1","v":17},"Chiqueter",{"$f":"LARGE(N5:N22,1)+1","v":63},"Egrapper",{"$f":"LARGE(P5:P22,1)+1","v":106},"Mijoter",{"$f":"LARGE(R5:R22,1)+1","v":146},"Tamponner",null,null,{"$f":"LARGE(V5:V22,1)+1","v":18},"Blondir",{"$f":"LARGE(X5:X22,1)+1","v":74},"Dérober",{"$f":"LARGE(Z5:Z22,1)+1","v":131},"Frapper",{"$f":"LARGE(AB5:AB22,1)+1","v":181},"Monder",{"$f":"LARGE(AD5:AD22,1)+1","v":235},"Remuer",{"$f":"LARGE(AF5:AF22,1)+1","v":284},"Utiliser",{"$f":"LARGE(AH4:AH22,1)+1","v":20},"chercher",null,{"$f":"LARGE(AK4:AK22,1)+1","v":76},"nettoyer",null,null,null,"Blanchir : travailler ensemble le jaune d’œuf et le sucre au fouet jusqu’à ce que le mélange devienne mousseux."]
[null,null,null,{"$f":"LARGE(D5:D23,1)+1","v":29},"Mélanger",{"$f":"LARGE(F5:F23,1)+1","v":50},"Repasser",null,null,null,null,{"$f":"LARGE(L5:L23,1)+1","v":18},"Ciseler",{"$f":"LARGE(N5:N23,1)+1","v":64},"Egrener",{"$f":"LARGE(P5:P23,1)+1","v":107},"Monder",{"$f":"LARGE(R5:R23,1)+1","v":147},"Tapisser",null,null,{"$f":"LARGE(V5:V23,1)+1","v":19},"Bouler",{"$f":"LARGE(X5:X23,1)+1","v":75},"Désosser",{"$f":"LARGE(Z5:Z23,1)+1","v":132},"Fraser",{"$f":"LARGE(AB5:AB23,1)+1","v":182},"Monter",{"$f":"LARGE(AD5:AD23,1)+1","v":236},"Répartir",null,null,{"$f":"LARGE(AH4:AH23,1)+1","v":21},"classifier",null,{"$f":"LARGE(AK4:AK23,1)+1","v":77},"optimiser",null,null,null,"Bouler : façonner à la main une pâte pour lui donner la forme d’une boule."]
[null,null,null,{"$f":"LARGE(D5:D24,1)+1","v":30},"Mettre en cuisson",null,null,null,null,null,null,{"$f":"LARGE(L5:L24,1)+1","v":19},"Citronner",{"$f":"LARGE(N5:N24,1)+1","v":65},"Emincer",{"$f":"LARGE(P5:P24,1)+1","v":108},"Monter",{"$f":"LARGE(R5:R24,1)+1","v":148},"Tourer",null,null,{"$f":"LARGE(V5:V24,1)+1","v":20},"Braiser",{"$f":"LARGE(X5:X24,1)+1","v":76},"Dessécher",{"$f":"LARGE(Z5:Z24,1)+1","v":133},"Frémir",{"$f":"LARGE(AB5:AB24,1)+1","v":183},"Mortifier",{"$f":"LARGE(AD5:AD24,1)+1","v":237},"Repasser",null,"V",{"$f":"LARGE(AH4:AH24,1)+1","v":22},"commander",null,{"$f":"LARGE(AK4:AK24,1)+1","v":78},"ordonnancer",null,null,null,"Brunissement enzymatique : c’est le phénomène qui se produit au contact de l’air à la suite d’opérations ou de traitements de divers végétaux (épluchage, taille) lesquels dégradent la structure végétale externe. Le phénomène conduit à un changement de couleur brun caractéristique du fruit)."]
[null,null,null,{"$f":"LARGE(D5:D25,1)+1","v":31},"Mixer",null,null,null,null,null,null,{"$f":"LARGE(L5:L25,1)+1","v":20},"Clarifier",{"$f":"LARGE(N5:N25,1)+1","v":66},"Enrober",{"$f":"LARGE(P5:P25,1)+1","v":109},"Mortifier",{"$f":"LARGE(R5:R25,1)+1","v":149},"Tourner",null,null,{"$f":"LARGE(V5:V25,1)+1","v":21},"Brider",{"$f":"LARGE(X5:X25,1)+1","v":77},"Détailler",{"$f":"LARGE(Z5:Z25,1)+1","v":134},"Frire",{"$f":"LARGE(AB5:AB25,1)+1","v":184},"Mouiller",{"$f":"LARGE(AD5:AD25,1)+1","v":238},"Réserver",{"$f":"LARGE(AF5:AF25,1)+1","v":285},"Vanner",{"$f":"LARGE(AH4:AH25,1)+1","v":23},"compiler",null,{"$f":"LARGE(AK4:AK25,1)+1","v":79},"organiser",null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L26,1)+1","v":21},"Coller",{"$f":"LARGE(N5:N26,1)+1","v":67},"Eplucher",{"$f":"LARGE(P5:P26,1)+1","v":110},"Mouiller",{"$f":"LARGE(R5:R26,1)+1","v":150},"Travailler",null,null,{"$f":"LARGE(V5:V26,1)+1","v":22},"Broyer",{"$f":"LARGE(X5:X26,1)+1","v":78},"Détendre",null,null,{"$f":"LARGE(AB5:AB26,1)+1","v":185},"Mouler",{"$f":"LARGE(AD5:AD26,1)+1","v":239},"Respecter le délai de 2 H",{"$f":"LARGE(AF5:AF26,1)+1","v":286},"Vérifier la temp.",{"$f":"LARGE(AH4:AH26,1)+1","v":24},"compter",null,{"$f":"LARGE(AK4:AK26,1)+1","v":80},"planifier",null,null,null,"Candir : technique qui consiste à immerger des confiseries, des décors, dans un sirop de sucre afin d’obtenir une cristallisation de sucre en surface."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L27,1)+1","v":22},"Compoter",{"$f":"LARGE(N5:N27,1)+1","v":68},"Escaloper",null,"N",{"$f":"LARGE(R5:R27,1)+1","v":151},"Tremper",null,null,{"$f":"LARGE(V5:V27,1)+1","v":23},"Brûler",{"$f":"LARGE(X5:X27,1)+1","v":79},"Détremper",null,"G",{"$f":"LARGE(AB5:AB27,1)+1","v":186},"Mousser",{"$f":"LARGE(AD5:AD27,1)+1","v":240},"Retirer",{"$f":"LARGE(AF5:AF27,1)+1","v":287},"Verser",{"$f":"LARGE(AH4:AH27,1)+1","v":25},"concevoir",null,{"$f":"LARGE(AK4:AK27,1)+1","v":81},"préparer",null,null,null,"Canneler : c’est le fait de faire de petites cannelures peu profondes à l’aide d’un couteau à canneler (appelé aussi canneleur) sur la surface de certains fruits & légumes (oranges, citrons, carottes…) pour améliorer leur présentation."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L28,1)+1","v":23},"Concasser",{"$f":"LARGE(N5:N28,1)+1","v":69},"Etuver",{"$f":"LARGE(P5:P28,1)+1","v":111},"Nacrer",{"$f":"LARGE(R5:R28,1)+1","v":152},"Tronçonner",null,null,null,null,{"$f":"LARGE(X5:X28,1)+1","v":80},"Disperser",{"$f":"LARGE(Z5:Z28,1)+1","v":135},"Garnir",null,"N",{"$f":"LARGE(AD5:AD28,1)+1","v":241},"Retomber",{"$f":"LARGE(AF5:AF28,1)+1","v":288},"Videler",{"$f":"LARGE(AH4:AH28,1)+1","v":26},"conduire",null,{"$f":"LARGE(AK4:AK28,1)+1","v":82},"présenter",null,null,null,"Caramélisation : phénomène correspondant au changement de couleur consécutif à une dégradation du saccharose au contact d’une source de chaleur importante. C’est une réaction de brunissement non enzymatique."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L29,1)+1","v":24},"Confire",{"$f":"LARGE(N5:N29,1)+1","v":70},"Evider",{"$f":"LARGE(P5:P29,1)+1","v":112},"Napper",{"$f":"LARGE(R5:R29,1)+1","v":153},"Trousser",null,null,null,"C",{"$f":"LARGE(X5:X29,1)+1","v":81},"Disposer",{"$f":"LARGE(Z5:Z29,1)+1","v":136},"Gerber",{"$f":"LARGE(AB5:AB29,1)+1","v":187},"Nacrer",{"$f":"LARGE(AD5:AD29,1)+1","v":242},"Retourner",{"$f":"LARGE(AF5:AF29,1)+1","v":289},"Voiler",{"$f":"LARGE(AH4:AH29,1)+1","v":27},"consigner",null,{"$f":"LARGE(AK4:AK29,1)+1","v":83},"prévoir",null,null,null,"Caraméliser : enduire un moule ou une pâtisserie de sucre cuit au caramel."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L30,1)+1","v":25},"Contiser",{"$f":"LARGE(N5:N30,1)+1","v":71},"Exprimer",null,null,{"$f":"LARGE(R5:R30,1)+1","v":154},"Turbiner",null,null,{"$f":"LARGE(V5:V30,1)+1","v":24},"Candir ",{"$f":"LARGE(X5:X30,1)+1","v":82},"Dorer",{"$f":"LARGE(Z5:Z30,1)+1","v":137},"Glacer",{"$f":"LARGE(AB5:AB30,1)+1","v":188},"Napper",{"$f":"LARGE(AD5:AD30,1)+1","v":243},"Revenir",null,null,{"$f":"LARGE(AH4:AH30,1)+1","v":28},"constituer",null,{"$f":"LARGE(AK4:AK30,1)+1","v":84},"produire",null,null,null,"Chablonner : appliquer du chocolat de couverture ou de la pâte à glacer à la base des entremets, petits gâteaux, des ganaches, pour faciliter leur manipulation avant leur montage ou découpage."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L31,1)+1","v":26},"Corner",null,"F",null,"P",null,null,null,null,{"$f":"LARGE(V5:V31,1)+1","v":25},"Canneler",{"$f":"LARGE(X5:X31,1)+1","v":83},"Doubler",{"$f":"LARGE(Z5:Z31,1)+1","v":138},"Gommer",null,"P",{"$f":"LARGE(AD5:AD31,1)+1","v":244},"Rincer",null,"Z",{"$f":"LARGE(AH4:AH31,1)+1","v":29},"construire",null,{"$f":"LARGE(AK4:AK31,1)+1","v":85},"programmer",null,null,null,"Chemiser : appliquer contre la paroi intérieur d’un moule ou d’une caissette, une couche de pâte, de biscuit, de gelée, de chocolat, de glace, de farine etc…"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L32,1)+1","v":27},"Corser",{"$f":"LARGE(N5:N32,1)+1","v":72},"Farcir",{"$f":"LARGE(P5:P32,1)+1","v":113},"Paner",null,"V",null,null,{"$f":"LARGE(V5:V32,1)+1","v":26},"Caraméliser",{"$f":"LARGE(X5:X32,1)+1","v":84},"Dresser",{"$f":"LARGE(Z5:Z32,1)+1","v":139},"Grainer",{"$f":"LARGE(AB5:AB32,1)+1","v":189},"Panacher",{"$f":"LARGE(AD5:AD32,1)+1","v":245},"Rioler",{"$f":"LARGE(AF5:AF32,1)+1","v":290},"Zester",{"$f":"LARGE(AH4:AH32,1)+1","v":30},"contrôler",null,{"$f":"LARGE(AK4:AK32,1)+1","v":86},"rebâtir",null,null,null,"Chiqueter : tailler le tour d’une pièce de feuilletage avant la cuisson avec la lame d’un couteau pour lui donner un aspect particulier."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L33,1)+1","v":28},"Coucher",{"$f":"LARGE(N5:N33,1)+1","v":73},"Festonner",{"$f":"LARGE(P5:P33,1)+1","v":114},"Papilloter",{"$f":"LARGE(R5:R33,1)+1","v":155},"Vanner",null,null,{"$f":"LARGE(V5:V33,1)+1","v":27},"Caraméliser",null,null,{"$f":"LARGE(Z5:Z33,1)+1","v":140},"Graisser",{"$f":"LARGE(AB5:AB33,1)+1","v":190},"Paner",{"$f":"LARGE(AD5:AD33,1)+1","v":246},"Rissoler",null,null,{"$f":"LARGE(AH4:AH33,1)+1","v":31},"couper",null,{"$f":"LARGE(AK4:AK33,1)+1","v":87},"réceptionner",null,null,null,"Confire : remplacer l’eau de végétation des fruits par un sirop à la suite d’immersions multiples et répétées dans un sirop de sucre de plus en plus concentré."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L34,1)+1","v":29},"Coucher",{"$f":"LARGE(N5:N34,1)+1","v":74},"Flamber",{"$f":"LARGE(P5:P34,1)+1","v":115},"Passer",{"$f":"LARGE(R5:R34,1)+1","v":156},"Videler",null,null,{"$f":"LARGE(V5:V34,1)+1","v":28},"Cerner",null,"E",{"$f":"LARGE(Z5:Z34,1)+1","v":141},"Gratiner",{"$f":"LARGE(AB5:AB34,1)+1","v":191},"Papilloter",{"$f":"LARGE(AD5:AD34,1)+1","v":247},"Rompre",null,null,{"$f":"LARGE(AH4:AH34,1)+1","v":32},"créer",null,{"$f":"LARGE(AK4:AK34,1)+1","v":88},"reconstruire",null,null,null,"Corner : utiliser une corne à l’intérieur d’un  récipient pour récupérer le maximum d’appareil."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L35,1)+1","v":30},"Crémer",{"$f":"LARGE(N5:N35,1)+1","v":75},"Flanquer",{"$f":"LARGE(P5:P35,1)+1","v":116},"Persiller",{"$f":"LARGE(R5:R35,1)+1","v":157},"Voiler",null,null,{"$f":"LARGE(V5:V35,1)+1","v":29},"Chablonner",{"$f":"LARGE(X5:X35,1)+1","v":85},"Ebarber",{"$f":"LARGE(Z5:Z35,1)+1","v":142},"Griller",{"$f":"LARGE(AB5:AB35,1)+1","v":192},"Parer",{"$f":"LARGE(AD5:AD35,1)+1","v":248},"Rôtir",null,null,{"$f":"LARGE(AH4:AH35,1)+1","v":33},"creuser",null,{"$f":"LARGE(AK4:AK35,1)+1","v":89},"réduire",null,null,null,"Corps : terme appliqué à une pâte pour désigner son élasticité, sa résistance après son pétrissage, résultant de la formation de gluten."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L36,1)+1","v":31},"Crever",{"$f":"LARGE(N5:N36,1)+1","v":76},"Fleurer",{"$f":"LARGE(P5:P36,1)+1","v":117},"Piler",null,null,null,null,{"$f":"LARGE(V5:V36,1)+1","v":30},"Châtrer",{"$f":"LARGE(X5:X36,1)+1","v":86},"Ebaucher",{"$f":"LARGE(Z5:Z36,1)+1","v":143},"H",{"$f":"LARGE(AB5:AB36,1)+1","v":193},"Parfumer",{"$f":"LARGE(AD5:AD36,1)+1","v":249},"Rouler",null,null,{"$f":"LARGE(AH4:AH36,1)+1","v":34},"cultiver",null,{"$f":"LARGE(AK4:AK36,1)+1","v":90},"régler",null,null,null,"Corser : donner de l’élasticité à une pâte  en la pétrissant davantage."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L37,1)+1","v":32},"Cuire",{"$f":"LARGE(N5:N37,1)+1","v":77},"Foisonner",{"$f":"LARGE(P5:P37,1)+1","v":118},"Pincer",null,"Z",null,null,{"$f":"LARGE(V5:V37,1)+1","v":31},"Chauffer",{"$f":"LARGE(X5:X37,1)+1","v":87},"Ecailler",{"$f":"LARGE(Z5:Z37,1)+1","v":144},"Habiller",{"$f":"LARGE(AB5:AB37,1)+1","v":194},"Parsemer",{"$f":"LARGE(AD5:AD37,1)+1","v":250},"Roussir",null,null,{"$f":"LARGE(AH4:AH37,1)+1","v":35},"décentraliser",null,{"$f":"LARGE(AK4:AK37,1)+1","v":91},"réguler",null,null,null,"Coucher (synonyme de dresser) : façonner à la poche à douille généralement sur plaque ou tapis anti-adhérant, papier sulfurisé des appareils mous (pâte à choux, biscuits, meringues)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"D",{"$f":"LARGE(N5:N38,1)+1","v":78},"Foncer",{"$f":"LARGE(P5:P38,1)+1","v":119},"Piquer",{"$f":"LARGE(R5:R38,1)+1","v":158},"Zester",null,null,{"$f":"LARGE(V5:V38,1)+1","v":32},"Chaufroiter",{"$f":"LARGE(X5:X38,1)+1","v":88},"Ecaler",{"$f":"LARGE(Z5:Z38,1)+1","v":145},"Hacher",{"$f":"LARGE(AB5:AB38,1)+1","v":195},"Passer",null,null,null,null,{"$f":"LARGE(AH4:AH38,1)+1","v":36},"décharger",null,{"$f":"LARGE(AK4:AK38,1)+1","v":92},"remodeler",null,null,null,"Crémer : travailler une matière grasse seule ou avec du sucre, afin de lui donner la consistance d’une crème."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L39,1)+1","v":33},"Décanter",{"$f":"LARGE(N5:N39,1)+1","v":79},"Fondre",{"$f":"LARGE(P5:P39,1)+1","v":120},"Pocher",null,null,null,null,{"$f":"LARGE(V5:V39,1)+1","v":33},"Chemiser",{"$f":"LARGE(X5:X39,1)+1","v":89},"Echauder",{"$f":"LARGE(Z5:Z39,1)+1","v":146},"Historier",{"$f":"LARGE(AB5:AB39,1)+1","v":196},"Pasteuriser",null,"S",null,null,{"$f":"LARGE(AH4:AH39,1)+1","v":37},"dessiner",null,{"$f":"LARGE(AK4:AK39,1)+1","v":93},"remplacer",null,null,null,"Crouter : opération permettant de sécher à l’air ou en étuve une fabrication crue ou cuite afin d’obtenir une pellicule sèche et résistante à sa surface (biscuit cuillère, macarons…)."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L40,1)+1","v":34},"Décercler",{"$f":"LARGE(N5:N40,1)+1","v":80},"Fouler",{"$f":"LARGE(P5:P40,1)+1","v":121},"Poêler",null,null,null,null,{"$f":"LARGE(V5:V40,1)+1","v":34},"Chevaucher",{"$f":"LARGE(X5:X40,1)+1","v":90},"Ecorcher",{"$f":"LARGE(Z5:Z40,1)+1","v":147},"Huiler",{"$f":"LARGE(AB5:AB40,1)+1","v":197},"Peler",{"$f":"LARGE(AD5:AD40,1)+1","v":251},"Sabler",null,null,{"$f":"LARGE(AH4:AH40,1)+1","v":38},"documenter",null,{"$f":"LARGE(AK4:AK40,1)+1","v":94},"rénover",null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L41,1)+1","v":35},"Décortiquer",{"$f":"LARGE(N5:N41,1)+1","v":81},"Fraiser",{"$f":"LARGE(P5:P41,1)+1","v":122},"Pousser",null,null,null,null,{"$f":"LARGE(V5:V41,1)+1","v":35},"Chiqueter",{"$f":"LARGE(X5:X41,1)+1","v":91},"Ecosser",null,null,{"$f":"LARGE(AB5:AB41,1)+1","v":198},"Persiller",{"$f":"LARGE(AD5:AD41,1)+1","v":252},"Saigner",null,null,{"$f":"LARGE(AH4:AH41,1)+1","v":39},"écouler",null,{"$f":"LARGE(AK4:AK41,1)+1","v":95},"réorganiser",null,null,null,"Décercler : retirer avec précaution le cercle d’un fond de tarte ou d’un entremet."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L42,1)+1","v":36},"Décuire",{"$f":"LARGE(N5:N42,1)+1","v":82},"Fileter",{"$f":"LARGE(P5:P42,1)+1","v":123},"Puncher",null,null,null,null,{"$f":"LARGE(V5:V42,1)+1","v":36},"Ciseler",{"$f":"LARGE(X5:X42,1)+1","v":92},"Ecumer",null,"I",{"$f":"LARGE(AB5:AB42,1)+1","v":199},"Peser",{"$f":"LARGE(AD5:AD42,1)+1","v":253},"Saisir",null,null,{"$f":"LARGE(AH4:AH42,1)+1","v":40},"écrire",null,{"$f":"LARGE(AK4:AK42,1)+1","v":96},"réparer",null,null,null,"Décoction : solution obtenue par l’action prolongée de l’eau bouillante sur une plante aromatique."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L43,1)+1","v":37},"Déffilandrer",{"$f":"LARGE(N5:N43,1)+1","v":83},"Frapper",null,"Q",null,null,null,null,{"$f":"LARGE(V5:V43,1)+1","v":37},"Citronner",{"$f":"LARGE(X5:X43,1)+1","v":93},"Effilandrer",{"$f":"LARGE(Z5:Z43,1)+1","v":148},"Imbiber",{"$f":"LARGE(AB5:AB43,1)+1","v":200},"Pétrir",{"$f":"LARGE(AD5:AD43,1)+1","v":254},"Sangler",null,null,{"$f":"LARGE(AH4:AH43,1)+1","v":41},"édifier",null,{"$f":"LARGE(AK4:AK43,1)+1","v":97},"résoudre",null,null,null,"Dessécher : déshydrater, faire évaporer l’excédent d’eau se trouvant dans une préparation en la chauffant sur feu doux dans une étuve ou dans un four (ex : pâte à choux)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L44,1)+1","v":38},"Déglacer",{"$f":"LARGE(N5:N44,1)+1","v":84},"Frémir",{"$f":"LARGE(P5:P44,1)+1","v":124},"Quadriller",null,null,null,null,{"$f":"LARGE(V5:V44,1)+1","v":38},"Clarifier",{"$f":"LARGE(X5:X44,1)+1","v":94},"Effiler",{"$f":"LARGE(Z5:Z44,1)+1","v":149},"Inciser",{"$f":"LARGE(AB5:AB44,1)+1","v":201},"Piler",{"$f":"LARGE(AD5:AD44,1)+1","v":255},"Saumurer",null,null,{"$f":"LARGE(AH4:AH44,1)+1","v":42},"effectuer",null,{"$f":"LARGE(AK4:AK44,1)+1","v":98},"réviser",null,null,null,"Détailler : découper des morceaux de pâte de forme bien déterminée dans une abaisse de pâte, à l’aide d’un couteau ou d’un découpoir."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L45,1)+1","v":39},"Dégorger",{"$f":"LARGE(N5:N45,1)+1","v":85},"Frire",null,null,null,null,null,null,{"$f":"LARGE(V5:V45,1)+1","v":39},"Clouter",{"$f":"LARGE(X5:X45,1)+1","v":95},"Egermer",{"$f":"LARGE(Z5:Z45,1)+1","v":150},"Incorporer",{"$f":"LARGE(AB5:AB45,1)+1","v":202},"Pincer",{"$f":"LARGE(AD5:AD45,1)+1","v":256},"Saupoudrer",null,null,{"$f":"LARGE(AH4:AH45,1)+1","v":43},"élaborer",null,{"$f":"LARGE(AK4:AK45,1)+1","v":99},"revoir",null,null,null,"Détrempe : mélange de farine, d’eau et de sel servant de base à la pâte feuilleté et à la pâte levée feuilleté."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L46,1)+1","v":40},"Dégourdir",null,"G",null,"R",null,null,null,null,{"$f":"LARGE(V5:V46,1)+1","v":40},"Coller",{"$f":"LARGE(X5:X46,1)+1","v":96},"Egoutter",{"$f":"LARGE(Z5:Z46,1)+1","v":151},"Indications packaging",{"$f":"LARGE(AB5:AB46,1)+1","v":203},"Piquer",{"$f":"LARGE(AD5:AD46,1)+1","v":257},"Sauter",null,null,{"$f":"LARGE(AH4:AH46,1)+1","v":44},"emplir",null,{"$f":"LARGE(AK4:AK46,1)+1","v":100},"sensibiliser",null,null,null,"E"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L47,1)+1","v":41},"Dégraisser",{"$f":"LARGE(N5:N47,1)+1","v":86},"Glacer",{"$f":"LARGE(P5:P47,1)+1","v":125},"Rabattre",null,null,null,null,{"$f":"LARGE(V5:V47,1)+1","v":41},"Compoter",{"$f":"LARGE(X5:X47,1)+1","v":97},"Egrapper",{"$f":"LARGE(Z5:Z47,1)+1","v":152},"Infuser",{"$f":"LARGE(AB5:AB47,1)+1","v":204},"Plaquer",{"$f":"LARGE(AD5:AD47,1)+1","v":258},"Serrer",null,null,{"$f":"LARGE(AH4:AH47,1)+1","v":45},"employer",null,{"$f":"LARGE(AK4:AK47,1)+1","v":101},"simplifier",null,null,null,"Écumer : c’est éliminer les impuretés qui se forment à la surface de cuisson de sucre, confitures, gelées à l’aide d’une écumoire."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L48,1)+1","v":42},"Déhousser",{"$f":"LARGE(N5:N48,1)+1","v":87},"Gommer",{"$f":"LARGE(P5:P48,1)+1","v":126},"Rafraîchir",null,null,null,null,{"$f":"LARGE(V5:V48,1)+1","v":42},"Concasser",{"$f":"LARGE(X5:X48,1)+1","v":98},"Egrener",null,null,{"$f":"LARGE(AB5:AB48,1)+1","v":205},"Pocher",{"$f":"LARGE(AD5:AD48,1)+1","v":259},"Servir",null,null,{"$f":"LARGE(AH4:AH48,1)+1","v":46},"enregistrer",null,{"$f":"LARGE(AK4:AK48,1)+1","v":102},"soulever",null,null,null,"Émonder : retirer les peaux, pellicules et enveloppe de certains fruits ou légumes."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L49,1)+1","v":43},"Dénerver",{"$f":"LARGE(N5:N49,1)+1","v":88},"Graisser",{"$f":"LARGE(P5:P49,1)+1","v":127},"Raidir",null,null,null,null,{"$f":"LARGE(V5:V49,1)+1","v":43},"Confire",{"$f":"LARGE(X5:X49,1)+1","v":99},"Eliminer",null,"J",{"$f":"LARGE(AB5:AB49,1)+1","v":206},"Poêler",{"$f":"LARGE(AD5:AD49,1)+1","v":260},"Singer",null,null,{"$f":"LARGE(AH4:AH49,1)+1","v":47},"entretenir",null,{"$f":"LARGE(AK4:AK49,1)+1","v":103},"standardiser",null,null,null,"Émulsionner : opération consistant à provoquer la dispersion d’un liquide dans un autre liquide ou d’une matière non miscible (ex : ganache)."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L50,1)+1","v":44},"Dénoyauter",{"$f":"LARGE(N5:N50,1)+1","v":89},"Gratiner",{"$f":"LARGE(P5:P50,1)+1","v":128},"Rassir",null,null,null,null,{"$f":"LARGE(V5:V50,1)+1","v":44},"Conserver",{"$f":"LARGE(X5:X50,1)+1","v":100},"Emonder",{"$f":"LARGE(Z5:Z50,1)+1","v":153},"Jeter",{"$f":"LARGE(AB5:AB50,1)+1","v":207},"Porter à ébullition",{"$f":"LARGE(AD5:AD50,1)+1","v":261},"Siroper",null,null,{"$f":"LARGE(AH4:AH50,1)+1","v":48},"envoyer",null,{"$f":"LARGE(AK4:AK50,1)+1","v":104},"superviser",null,null,null,"Évider : éliminer, extraire l’intérieur de certains fruits (ex : citrons, orange)."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(L5:L51,1)+1","v":45},"Denteler",{"$f":"LARGE(N5:N51,1)+1","v":90},"Griller",{"$f":"LARGE(P5:P51,1)+1","v":129},"Rayer",null,null,null,null,{"$f":"LARGE(V5:V51,1)+1","v":45},"Contiser",{"$f":"LARGE(X5:X51,1)+1","v":101},"Émulsionner",null,null,{"$f":"LARGE(AB5:AB51,1)+1","v":208},"Poudrer",{"$f":"LARGE(AD5:AD51,1)+1","v":262},"Siroter",null,null,{"$f":"LARGE(AH4:AH51,1)+1","v":49},"ériger",null,{"$f":"LARGE(AK4:AK51,1)+1","v":105},"surveiller",null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V52,1)+1","v":46},"Contrôler",{"$f":"LARGE(X5:X52,1)+1","v":102},"Enfourner",null,"L",{"$f":"LARGE(AB5:AB52,1)+1","v":209},"Pousser",{"$f":"LARGE(AD5:AD52,1)+1","v":263},"Snacker",null,null,{"$f":"LARGE(AH4:AH52,1)+1","v":50},"établir",null,{"$f":"LARGE(AK4:AK52,1)+1","v":106},"tester",null,null,null,"Façonner : c’est donner une forme  particulière à toute sortes de pâtes par un travail manuel ou mécanique avant cuisson."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V53,1)+1","v":47},"Corner",{"$f":"LARGE(X5:X53,1)+1","v":103},"Enrober",{"$f":"LARGE(Z5:Z53,1)+1","v":154},"Larder",{"$f":"LARGE(AB5:AB53,1)+1","v":210},"Praliner",{"$f":"LARGE(AD5:AD53,1)+1","v":264},"Sonder",null,null,{"$f":"LARGE(AH4:AH53,1)+1","v":51},"étendre",null,{"$f":"LARGE(AK4:AK53,1)+1","v":107},"transformer",null,null,null,"Festonner : constituer des bordures décoratives ou des formes arrondies sur des pâtisseries (ex : pithiviers, tartelette…)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V54,1)+1","v":48},"Corser",{"$f":"LARGE(X5:X54,1)+1","v":104},"Eplucher",{"$f":"LARGE(Z5:Z54,1)+1","v":155},"Laver",{"$f":"LARGE(AB5:AB54,1)+1","v":211},"Préchauffer",{"$f":"LARGE(AD5:AD54,1)+1","v":265},"Stériliser",null,null,{"$f":"LARGE(AH4:AH54,1)+1","v":52},"examiner",null,{"$f":"LARGE(AK4:AK54,1)+1","v":108},"trier",null,null,null,"Fleurer : saupoudrer de farine un tour, une plaque ou un moule afin d’empêcher certaines préparations de coller."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V55,1)+1","v":49},"Coucher",{"$f":"LARGE(X5:X55,1)+1","v":105},"Equeter",{"$f":"LARGE(Z5:Z55,1)+1","v":156},"Lever",{"$f":"LARGE(AB5:AB55,1)+1","v":212},"Prélever",{"$f":"LARGE(AD5:AD55,1)+1","v":266},"Suer",null,null,{"$f":"LARGE(AH4:AH55,1)+1","v":53},"exécuter",null,{"$f":"LARGE(AK4:AK55,1)+1","v":109},"utiliser",null,null,null,"Foncer : tapisser l’intérieur d’un moule ou d’un cercle avec de la pâte, pour qu’elle épouse parfaitement sa forme."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V56,1)+1","v":50},"Craquer",{"$f":"LARGE(X5:X56,1)+1","v":106},"Escaloper",{"$f":"LARGE(Z5:Z56,1)+1","v":157},"Lier",{"$f":"LARGE(AB5:AB56,1)+1","v":213},"Préparer",{"$f":"LARGE(AD5:AD56,1)+1","v":267},"Surgeler",null,null,{"$f":"LARGE(AH4:AH56,1)+1","v":54},"exploiter",null,{"$f":"LARGE(AK4:AK56,1)+1","v":110},"vaporiser",null,null,null,"Fond : pâtisseries utilisée comme base de fabrication et constituant généralement la couche inférieure des gâteaux."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V57,1)+1","v":51},"Crémer",{"$f":"LARGE(X5:X57,1)+1","v":107},"Etaler",{"$f":"LARGE(Z5:Z57,1)+1","v":158},"Limoner",{"$f":"LARGE(AB5:AB57,1)+1","v":214},"Protéger",null,null,null,null,{"$f":"LARGE(AH4:AH57,1)+1","v":55},"extraire",null,{"$f":"LARGE(AK4:AK57,1)+1","v":111},"vérifier",null,null,null,"Foisonnement: phénomène résultant d’une augmentation de volume d’une fabrication par incorporation de gaz."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V58,1)+1","v":52},"Crever",{"$f":"LARGE(X5:X58,1)+1","v":108},"Etoffer",{"$f":"LARGE(Z5:Z58,1)+1","v":159},"Lisser",{"$f":"LARGE(AB5:AB58,1)+1","v":215},"Puncher",null,null,null,null,{"$f":"LARGE(AH4:AH58,1)+1","v":56},"faire",null,null,null,null,null,null,"Fraser : écraser les ingrédients d’une pâte pour les agglomérer soit sur le marbre avec la paume de la main en la poussant devant soi, soit au batteur en écrasant avec la paume de sa main sur les parois."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V59,1)+1","v":53},"Crouter",{"$f":"LARGE(X5:X59,1)+1","v":109},"Etouffer",{"$f":"LARGE(Z5:Z59,1)+1","v":160},"Lustrer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V60,1)+1","v":54},"Cuire",{"$f":"LARGE(X5:X60,1)+1","v":110},"Etuver",{"$f":"LARGE(Z5:Z60,1)+1","v":161},"Luter",null,"Q",null,null,null,null,null,null,null,null,null,null,null,null,"Garnir : remplir avec une préparation de crème ou autres un fond de gâteau, un moule, une poche."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(V5:V61,1)+1","v":55},"Culotter",{"$f":"LARGE(X5:X61,1)+1","v":111},"Evider",{"$f":"LARGE(Z5:Z61,1)+1","v":162},"Lyophiliser",{"$f":"LARGE(AB5:AB61,1)+1","v":216},"Quadriller",null,null,null,null,null,null,null,null,null,null,null,null,"Glacer :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LARGE(X5:X62,1)+1","v":112},"Exprimer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"– action de recouvrir partiellement ou entièrement la surface d’une pâtisserie avec un glaçage (ex : fondant)"]
[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,null,null,null,null,null,null,null,null,null,null,"– rendre brillant la surface d’une pâtisserie avec du sirop avant le passage au four ou saupoudrer une pièce de sucre glace et la passer au four, le temps de caraméliser le sucre."]
[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,null,null,null,null,null,null,null,null,null,null,"Grainage : phénomène résultant de la déstabilisation d’une mousse alimentaire (ex : blancs montés) ou d’une émulsion mousseuse (ex : crème fouettée) à la suite d’un battage prolongé."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lien >","Lexique en français de la boucherie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graisser : enduire d’une couche de matière grasse à l’aide d’un pinceau ou d’une bombe à graisse les parois d’un moule ou une plaque."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lien >","Le dictionnaire du boucher",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verbes d'action Lien >","https://www.unamur.be/services/sevrexe/prodoc/documents-mission-accompagnement-prodoc-AL/verbes-actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imbiber : c’est faire pénétrer un liquide (sirop, alcool, liqueur etc…) dans une préparation dans le but de la rendre moins sèche ou dans le but de la parfumer."]
[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,null,null,null,null,null,null,null,null,null,null,"Infuser : opération consistant à placer une substance aromatique dans un liquide chauffé au préalable, pendant un temps déterminé et à couvert pour capter son arôme."]
[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,null,null,null,null,null,null,null,null,null,null,"L"]
[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,null,null,null,null,null,null,null,null,null,null,"Lisser : mélanger une préparation pour la rendre homogène."]
[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,null,null,null,null,null,null,null,null,null,null,"Lustrer : recouvrir de nappage de gelée ou de beurre fondu, une préparation afin de lui donner un aspect brillant."]
[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,null,null,null,null,null,null,null,null,null,null,"M"]
[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,null,null,null,null,null,null,null,null,null,null,"Macérer : opération consistant à faire tremper un corps dans un liquide froid pour en extraire les parties solubles ou un produit alimentaire pour le parfumer ou le conserver."]
[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,null,null,null,null,null,null,null,null,null,null,"Marbrer : réaliser divers dessins sur des gâteaux glacés (au fondant, au nappage etc …) pour améliorer leur présentation."]
[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,null,null,null,null,null,null,null,null,null,null,"Masquer : recouvrir un entremets ou un fond de plat d’une légère couche de crème, de sauce ou de gelée."]
[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,null,null,null,null,null,null,null,null,null,null,"Monter :"]
[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,null,null,null,null,null,null,null,null,null,null,"–  battre au fouet une substance ou un appareil pour le rendre plus léger et en augmenter le volume (ex : blanc en neige)."]
[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,null,null,null,null,null,null,null,null,null,null,"– assembler les différentes parties d’une pâtisserie pour en faire un gâteau plus ou moins important (monter un entremet, pièce montée)."]
[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,null,null,null,null,null,null,null,null,null,null,"Mouler : verser une substance ou une préparation liquide ou semi-liquide dans un moule pour en obtenir une reproduction de sa forme après solidification."]
[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,null,null,null,null,null,null,null,null,null,null,"N"]
[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,null,null,null,null,null,null,null,null,null,null,"Napper : verser sur un met chaud ou froid une sauce, une gelée, ou une crème pour le recouvrir complètement."]
[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,null,null,null,null,null,null,null,null,null,null,"P"]
[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,null,null,null,null,null,null,null,null,null,null,"Pasteuriser : action de soumettre une préparation à un traitement thermique (Température inférieure à 100°C), pendant un temps défini, afin de détruire d’éventuels germes pathogènes et de prolonger leur conservations."]
[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,null,null,null,null,null,null,null,null,null,null,"Passer : faire traverser un liquide dans un ustensile percé de trous  pour en retenir en général les impuretés (ex : chinois,  passoire, tamis)."]
[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,null,null,null,null,null,null,null,null,null,null,"Pâton : nom donné à un morceau de pâte pesé et prêt à être façonné."]
[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,null,null,null,null,null,null,null,null,null,null,"Piquer : percer de nombreux petits trous la surface d’une abaisse de pâte à l’aide d’une fourchette ou d’un pique vite, dans le but d’empêcher la formation de boursouflures durant la cuisson."]
[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,null,null,null,null,null,null,null,null,null,null,"Pincer : faire un décor sur le pourtour d’une tarte à l’aide d’une pince spéciale."]
[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,null,null,null,null,null,null,null,null,null,null,"Pocher : opération qui consiste à cuire une préparation ou des aliments dans un liquide (eau, sirop, etc…) à une température basse, généralement comprise entre 70° et 85°C."]
[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,null,null,null,null,null,null,null,null,null,null,"Pointage : technique survenant après le pétrissage d’une pâte levée, fermentée, permettant à la première fermentation de se réaliser et de développer des arômes caractéristiques, mais aussi de renforcer le corps de la pâte avant son façonnage."]
[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,null,null,null,null,null,null,null,null,null,null,"Punch : mélange de sirop de sucre et d’un autre ingrédient (alcool, café, jus ou purée de fruits, vanille etc…)."]
[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,null,null,null,null,null,null,null,null,null,null,"Puncher (synonyme d’imbiber): rayer avec la pointe de la lame d’un couteau d’office, inciser de raies parallèles la surface de certains gâteaux préalablement passée à la dorure afin de parfaire la présentation."]
[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,null,null,null,null,null,null,null,null,null,null,"R"]
[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,null,null,null,null,null,null,null,null,null,null,"Retomber : se dit d’une pâte, d’un appareil dont le volume diminue après avoir augmenté pendant le montage ou la cuisson."]
[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,null,null,null,null,null,null,null,null,null,null,"Rognures : chutes de pâtisseries provenant de découpes de pâtes, d’entremets."]
[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,null,null,null,null,null,null,null,null,null,null,"Rompre : actions manuelles consistant après un certain temps de pointage, a rabattre une pâte levée, fermentée, pour en chasser les gaz produits, avant le façonnage."]
[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,null,null,null,null,null,null,null,null,null,null,"Ruban : préparation qui, après avoir été travaillé au fouet ou à la spatule, se glisse comme un ruban lorsqu’on la fait retomber de hauteur (ex : génoise)."]
[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,null,null,null,null,null,null,null,null,null,null,"S"]
[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,null,null,null,null,null,null,null,null,null,null,"Sabler : opération qui consiste à brasser de la farine et de la matière grasse jusqu’à l’obtention d’un mélange rappelant la texture du sable."]
[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,null,null,null,null,null,null,null,null,null,null,"T"]
[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,null,null,null,null,null,null,null,null,null,null,"Tabler : technique de pré-cristallisation du chocolat de couverture sur un marbre."]
[]
[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,null,null,null,null,null,null,null,null,null,null,"Tourer : action de plier  en trois ou en quatre un pâton de pâte levée, feuilletée, après l’avoir allongée."]
[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,null,null,null,null,null,null,null,null,null,null,"Tremper :"]
[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,null,null,null,null,null,null,null,null,null,null,"–  imbiber une pièce de pâtisseries avec du sirop"]
[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,null,null,null,null,null,null,null,null,null,null,"–  enrober des bonbons, des intérieurs, des fruits dans du chocolat de couverture ou du fondant."]
[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,null,null,null,null,null,null,null,null,null,null,"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,null,null,null,null,null,null,null,null,null,null,null,"Vanner : remuer une sauce ou une crème pendant son refroidissement pour la rendre homogène, limité son dessèchement en surface et accélérer sa descente en température."]
[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,null,null,null,null,null,null,null,null,null,null,"Z"]
[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,null,null,null,null,null,null,null,null,null,null,"Zeste : peau découpée dans l’écorce des agrumes."]
[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,null,null,null,null,null,null,null,null,null,null,"Zester : retirer la partie extérieure de l’écorce d’agrumes (citrons, oranges, pamplemousse….) à l’aide d’un zesteur ou d’une râpe."]
[]
[]
[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,null,null,null,null,null,null,null,null,null,"Lien >","https://www.passionpatisserie.fr/lexique"]
[]
[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,null,null,null,null,null,null,null,null,null,"Lien >","http://devenir.patissier.free.fr/cours-CAP-vocabulaire-professionnel-eleve.pdf"]
[]
[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,null,null,null,null,null,null,null,null,null,"Lien >","http://technologiepatisserie.blogspot.com/p/le-vocabulaire-professionnel-en.html"]
[]
[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,null,null,null,null,null,null,null,null,null,"Lien >","https://devenirpatissier.fr/vocabulaire-professionnel/"]
[]
[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,null,null,null,null,null,null,null,null,null,"Lien >","https://www.encoreungateau.com/pourquoi-un-blog-de-patisserie/vocabulaire-du-patissier/"]

{"sheet":"Poids fruits et légumes","index":5,"n_rows":128,"n_cols":51,"rows_kept":128,"cut":false,"hidden":false,"merged":[[73,31,74,31],[73,32,73,34],[73,35,73,38],[101,27,101,29],[102,27,103,28],[0,1,0,21],[1,1,3,6],[1,8,3,13],[1,15,3,20],[4,0,67,0],[4,7,67,7],[4,14,67,14],[4,21,67,21]]}
[null,"POIDS DES FRUITS ET LÉGUMES  …décembre 2017 annule et remplace les versions précédentes"]
[null,"Saisissez votre nombre d'unité (encre rouge)Modifiez le poids unitaire (encre verte) s'il n'est pas excact",null,null,null,null,null,null,"Saisissez votre nombre d'unité (encre rouge)Modifiez le poids unitaire (encre verte) s'il n'est pas excact",null,null,null,null,null,null,"Saisissez votre nombre d'unité (encre rouge)Modifiez le poids unitaire (encre verte) s'il n'est pas excact"]
[]
[]
[null,"N°","Produits","Poids unitaire","Nb d'unités","Poids en Gr","Poids en Kg",null,"N°","Produits","Poids unitaire","Nb d'unités","Poids en Gr","Poids en Kg",null,"N°","Produits","Poids unitaire","Nb d'unités","Poids en Gr","Poids en Kg"]
[null,null,"A",null,null,null,null,null,null,"G",null,null,null,null,null,null,"R",null,null,null,null,null,null,"4.1. Poids et mesures (A-C)",null,null,null,null,null,null,null,"Poids moyen (à la pièce, en grammes).  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIENS"]
[null,1,"Abricot",55,10,{"$f":"(D7*E7)","v":550},{"$f":"F7/1000","v":0.55000000000000004},null,{"$f":"B66+1","v":56},"Hareng",170,10,{"$f":"(K7*L7)","v":1700},{"$f":"M7/1000","v":1.7},null,{"$f":"I68+1","v":113},"Raisin sec Tasse thé de 15 cl",20,10,{"$f":"(R7*S7)","v":200},{"$f":"T7/1000","v":0.2}]
[null,{"$f":"LARGE(B7:B7,1)+1","v":2},"Ail gousse",5,10,50,0.05,null,{"$f":"LARGE(I7:I7,1)+1","v":57},"Haricot sec Verre de 20 cl",160,10,{"$f":"(K8*L8)","v":1600},1.6,null,{"$f":"LARGE(P7:P7,1)+1","v":114},"Riz long Verre de 20 cl",125,10,1250,1.25,null,null,"Aliment","Mesure de capacité ","Poids",null,"Aliment","Mesure de capacité ","Poids",null,"Biscuit sec : 10. Biscotte : 18. Croissant : 50. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.nubel.be/fra/manual/liste_des_denrees_alimentaires.asp"]
[null,{"$f":"LARGE(B7:B8,1)+1","v":3},"Ail gousse moyenne",8,10,80,0.08,null,{"$f":"LARGE(I7:I8,1)+1","v":58},"Homard moyen",885,10,8850,8.85,null,null,"S",0,null,0,0]
[null,{"$f":"LARGE(B7:B9,1)+1","v":4},"Ail tête",50,10,500,0.5,null,{"$f":"LARGE(I7:I9,1)+1","v":59},"Homard petit",500,10,5000,5,null,{"$f":"LARGE(P7:P9,1)+1","v":115},"Sardine",45,10,450,0.45,null,null,"Ananas (frais)/ananas (boîte)","1 tranche moyenne","100 g/35 g",null,"Mandarine","1 moyenne","60 g",null," Crustacés (entiers) : écrevisse 34, homard 885. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.nubel.be/fra/default.aspx"]
[null,{"$f":"LARGE(B7:B10,1)+1","v":5},"Ananas",2000,10,20000,20,null,null,"L",0,null,0,0,null,{"$f":"LARGE(P7:P10,1)+1","v":116},"Sel 1 pincée",1,10,10,0.01,null,null,"Avocat","1 moyen","160 g",null,"Mangue","1 moyenne","200 g"]
[null,{"$f":"LARGE(B7:B11,1)+1","v":6},"Artichaut",350,10,3500,3.5,null,{"$f":"LARGE(I7:I11,1)+1","v":60},"Lapin vidé",1500,10,15000,15,null,{"$f":"LARGE(P7:P11,1)+1","v":117},"Sel fin 1 cuillère café rase",50,10,500,0.5,null,null,"Abricot (sans noyau)",1,"150 g",null,"Maquereau fumé","1 filet","145 g",null," Fromages : camembert 250, livarot 500, pont-l'évêque 320, petit-suisse 25-30, yaourt (petit pot) 120-150. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POIDS MOYEN BRUT DE LA PIÈCE",null,"http://www.basesdelacuisine.com/Cadre1/z1/pp80.htm"]
[null,{"$f":"LARGE(B7:B12,1)+1","v":7},"Avocat 1/2",110,10,1100,1.1000000000000001,null,{"$f":"LARGE(I7:I12,1)+1","v":61},"Lentilles Verre de 20 cl",150,10,1500,1.5,null,{"$f":"LARGE(P7:P12,1)+1","v":118},"Sel fin 1 cuillère soupe rase",15,10,150,0.15,null,null,null,null,null,null,"Margarine","1 cuillère","18 g"]
[null,{"$f":"LARGE(B7:B13,1)+1","v":8},"Avocat entier",220,10,2200,2.2000000000000002,null,null,"M",0,null,0,0,null,{"$f":"LARGE(P7:P13,1)+1","v":119},"Sel fin 1 tasse",200,10,2000,2,null,null,"Bacon","1 fine tranche","11 g",null,"Mayonnaise","1 cuillère","25 g",null,"Fruits : abricot 55, banane 150, citron 125, datte 10, figue sèche 42, figue fraîche 45, mandarine 100, noix 13, orange 180, pamplemousse 400, pêche 130, poire 180, pomme 120, pruneau 15. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fruits et légumes frais Poids moyen d'une pièce",null,null,"http://lahalledepessac.com/content/14-fruits-et-legumes-frais-poids-moyen-d-une-piece"]
[null,null,"B",0,null,0,0,null,{"$f":"LARGE(I7:I14,1)+1","v":62},"Maizena 1 cuillère soupe",10,10,100,0.1,null,{"$f":"LARGE(P7:P14,1)+1","v":120},"Sel pour 1 Kg Blé",12,10,120,0.12,null,null,"Banane","1 moyenne","130 g",null,"Melon","1 moyen","540 g"]
[null,{"$f":"LARGE(B7:B15,1)+1","v":9},"Banane",120,10,1200,1.2,null,{"$f":"LARGE(I7:I15,1)+1","v":63},"Melon gros",800,10,8000,8,null,{"$f":"LARGE(P7:P15,1)+1","v":121},"Sel pour 1 Kg Foie gras",12,10,120,0.12,null,null,"Beurre","1 cuillère","18 g",null,"Merlan","1 filet","100 g",null," Légumes : artichaut 250, aubergine 225, chou 1 000, chou-fleur 1 200, laitue 500, romaine 400, chicorée frisée 400, melon 700-1 000, radis (la botte) 350, tomate 100, oignon 125. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLES DE GRAMMAGES","http://etab.ac-poitiers.fr/lycee-hotelier-la-rochelle/IMG/pdf/Grammage_4.pdf"]
[null,{"$f":"LARGE(B7:B16,1)+1","v":10},"Baton de vanille",8,10,80,0.08,null,{"$f":"LARGE(I7:I16,1)+1","v":64},"Melon portion",500,10,5000,5,null,{"$f":"LARGE(P7:P16,1)+1","v":122},"Sel pour 1 Kg Merguez",19,10,190,0.19,null,null,"Beurre de cacahuète","1 cuillère","15 g",null,"Miel","1 cuillère","27 g"]
[null,{"$f":"LARGE(B7:B17,1)+1","v":11},"Beurre 1 cuillère café",4,10,40,0.04,null,{"$f":"LARGE(I7:I17,1)+1","v":65},"Merlan",230,10,2300,2.2999999999999998,null,{"$f":"LARGE(P7:P17,1)+1","v":123},"Sel pour 1 Kg Pâtes alimentaires",12,10,120,0.12,null,null,"Bière (pils)","1 verre à bière","250 ml",null,"Milk-shake","1 verre","150 ml",null," Poissons (entiers) : brochet 1 250, carpe 775, colin 2 000, daurade 600, églefin 350, hareng 170, saur 130, limande 150, maquereau 250, merlan 230, plie 160, sardine 45, truite 450, turbot 2 350. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POIDS MOYEN BRUT LEGUMES ET FRUITS ",null,"http://dmcwilshim.canalblog.com/archives/2009/01/18/12131475.html"]
[null,{"$f":"LARGE(B7:B18,1)+1","v":12},"Beurre 1 cuillère soupe",15,10,150,0.15,null,{"$f":"LARGE(I7:I18,1)+1","v":66},"Mouton 1/2 carcasse",9.5,10,95,9.5000000000000001E-2,null,{"$f":"LARGE(P7:P18,1)+1","v":124},"Sel pour 1 Kg Pommes terre",13,10,130,0.13,null,null,"Biscotte blanche/complète",1,"8 g/10 g",null,"Moule","1 pièce","4 g"]
[null,{"$f":"LARGE(B7:B19,1)+1","v":13},"Beurre 1 noisette",4,10,40,0.04,null,{"$f":"LARGE(I7:I19,1)+1","v":67},"Mouton carré couvert (5+3)",900,10,9000,9,null,{"$f":"LARGE(P7:P19,1)+1","v":125},"Sel pour 1 Kg Saucisse a griller",12,10,{"$f":"(R20*S20)/1000","v":0.12},1.1999999999999999E-4,null,null,"Biscuit",1,"10 g",null,"Muesli","1 tasse à café","50 g",null,"Sucre (morceau) : 6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correspondance Calibre/ Poids fruits legumes"]
[null,{"$f":"LARGE(B7:B20,1)+1","v":14},"Beurre 1 noix",15,10,150,0.15,null,{"$f":"LARGE(I7:I20,1)+1","v":68},"Mouton carré découvert (5)",900,10,9000,9,null,{"$f":"LARGE(P7:P20,1)+1","v":126},"Sel pour 1 Kg Semoule a couscous",13,10,{"$f":"(R21*S21)/1000","v":0.13},1.3000000000000002E-4,null,null,"Biscuit apéritif","1 pièce","4 g"]
[null,{"$f":"LARGE(B7:B21,1)+1","v":15},"Beurre 1 tasse",200,10,2000,2,null,{"$f":"LARGE(I7:I21,1)+1","v":69},"Mouton cervelle ",230,10,2300,2.2999999999999998,null,{"$f":"LARGE(P7:P21,1)+1","v":127},"Semoule Tasse thé de 15 cl",110,10,{"$f":"(R22*S22)/1000","v":1.1000000000000001},1.1000000000000001E-3,null,null,"Biscuit au chocolat",1,"20 g",null,"Nectarine",1,"95 g",null,"Viandes : lapin (vidé) 1 500 ; oie (entière) 5 500 ; poulet (entier) 1 800. Cervelle : bœuf 500, veau 300, mouton 100, porc 110.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://portal.health.fgov.be/pls/portal/docs/PAGE/INTERNET_PG/HOMEPAGE_MENU/ABOUTUS1_MENU/INSTITUTIONSAPPARENTEES1_MENU/HOGEGEZONDHEIDSRAAD1_MENU/ADVIEZENENAANBEVELINGEN1_MENU/ADVIEZENENAANBEVELINGEN1_DOCS/6545-2_POIDSETMESURES_FR_2005_2.PDF"]
[null,{"$f":"LARGE(B7:B22,1)+1","v":16},"Bœuf Cervelle",500,10,5000,5,null,{"$f":"LARGE(I7:I22,1)+1","v":70},"Mouton cœur",230,10,2300,2.2999999999999998,null,{"$f":"LARGE(P7:P22,1)+1","v":128},"Semoule Verre de 20 cl",130,10,{"$f":"(R23*S23)/1000","v":1.3},1.2999999999999999E-3,null,null,"Boudin blanc",1,"100 g",null,"Noisettes","10 pièces","12 g",null,"Cœur : bœuf 2 750, veau 500, mouton 230, porc 225. Foie : bœuf 8 500, veau 2 500, porc 750. "]
[null,{"$f":"LARGE(B7:B23,1)+1","v":17},"Bœuf cœur",2750,10,27500,27.5,null,{"$f":"LARGE(I7:I23,1)+1","v":71},"Mouton épaule",1.7,10,17,1.7000000000000001E-2,null,{"$f":"LARGE(P7:P23,1)+1","v":129},"Sole T1",280,10,{"$f":"(R24*S24)","v":2800},2.8,null,null,"Boudin noir",1,"100 g",null,null,null,null,null," Langue : bœuf 4 000, veau 1 000. Pied de porc 200. Ris de veau 750. Rognon : bœuf 1 000, veau 250, porc 170.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.aliments.org/poids.htm"]
[null,{"$f":"LARGE(B7:B24,1)+1","v":18},"Bœuf entrecôte",6000,10,60000,60,null,{"$f":"LARGE(I7:I24,1)+1","v":72},"Mouton gigot raccourci",2.2000000000000002,10,22,2.1999999999999999E-2,null,{"$f":"LARGE(P7:P24,1)+1","v":130},"Sole T2",350,10,3500,3.5,null,null,"Boudoir",1,"5,5 g",null,"Oeuf cuit",1,"50 g"]
[null,{"$f":"LARGE(B7:B25,1)+1","v":19},"Bœuf faux filet",8000,10,80000,80,null,{"$f":"LARGE(I7:I25,1)+1","v":73},"Mouton selle anglaise",2,10,20,0.02,null,{"$f":"LARGE(P7:P25,1)+1","v":131},"Sole T3",500,10,5000,5,null,null,null,null,null,null,"Oignon","1 moyen","115 g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.astro.ulg.ac.be/cours/magain/stat/stat52.html"]
[null,{"$f":"LARGE(B7:B26,1)+1","v":20},"Bœuf filet",4200,10,42000,42,null,null,"N",0,null,0,0,null,{"$f":"LARGE(P7:P26,1)+1","v":132},"Sole T4 + de",600,10,6000,6,null,null,"Cabillaud","1 darne","175 g",null,"Olive","1 moyenne","4 g",null,"Modification.   Poids brut d'aliments résultant de la cuisson de:"]
[null,{"$f":"LARGE(B7:B27,1)+1","v":21},"Bœuf foie",8500,10,85000,85,null,{"$f":"LARGE(I7:I27,1)+1","v":74},"Noix",8,10,80,0.08,null,{"$f":"LARGE(P7:P27,1)+1","v":133},"Sole T4 + de",800,10,8000,8,null,null,"Cacahuètes","1 cuillère/10 pièces","20 g/20 g",null,"Omelette (1 œuf)",1,"60 g",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lien : une portion c'est combien   sur la nutrition.fr"]
[null,{"$f":"LARGE(B7:B28,1)+1","v":22},"Bœuf langue",4000,10,40000,40,null,{"$f":"LARGE(I7:I28,1)+1","v":75},"Noix épluchées Tasse thé de 15 cl",50,10,500,0.5,null,{"$f":"LARGE(P7:P28,1)+1","v":134},"Sucre morceaux",5,10,50,0.05,null,null,"Café/thé","1 tasse","125g",null,"Orange","1 moyenne","140 g",null,"100 g d'aliments crus. Farineux : coquillettes 385, macaronis 400, nouilles 385, riz 295, spaghettis 385. "]
[null,{"$f":"LARGE(B7:B29,1)+1","v":23},"Bœuf rognon",1000,10,10000,10,null,null,"O",0,null,0,0,null,{"$f":"LARGE(P7:P29,1)+1","v":135},"Sucre semoule 1 cuillère café",5,10,50,0.05,null,null,"Cake","1 fine tranche","30 g"]
[null,{"$f":"LARGE(B7:B30,1)+1","v":24},"Bœuf train côtes milieu",8500,10,85000,85,null,{"$f":"LARGE(I7:I30,1)+1","v":76},"Oeuf  le blanc",30,10,300,0.3,null,{"$f":"LARGE(P7:P30,1)+1","v":136},"Sucre semoule 1 cuillère soupe",15,10,150,0.15,null,null,"Cake fourré aux fruits","1 fine tranche","35 g",null,"Pain blanc/gris","1 tranche carrée","27 g",null,"100 g d'aliments crus. Légumes frais : artichauts 87, asperges 87, bettes 90, betteraves rouges à l'eau 91, au four 57, carottes à l'eau 100, à l'étouffée 64, "]
[null,{"$f":"LARGE(B7:B31,1)+1","v":25},"Brochet",1250,10,12500,12.5,null,{"$f":"LARGE(I7:I31,1)+1","v":77},"Oeuf gros",60,10,600,0.6,null,{"$f":"LARGE(P7:P31,1)+1","v":137},"Sucre semoule 1 tasse",200,10,2000,2,null,null,"Canard/faisan","1 portion","125 g",null,"Pain blanc/gris","1 tranche ronde","29 g"]
[null,null,"C",null,null,0,0,null,{"$f":"LARGE(I7:I32,1)+1","v":78},"Oeuf moyen",50,10,500,0.5,null,{"$f":"LARGE(P7:P32,1)+1","v":138},"Sucre Verre de 20 cl",150,10,1500,1.5,null,null,"Carambole","1 pièce","155 g",null,"Pain complet","1 tranche carrée","35 g",null,"100 g d'aliments crus. légumes frais : , céleris (côtes) 94, raves cuites à l'eau 91, sautées 54, champignons de couche frits 83, "]
[null,{"$f":"LARGE(B7:B33,1)+1","v":26},"Cacao poudre 1 cuillère soupe",8,10,80,0.08,null,{"$f":"LARGE(I7:I33,1)+1","v":79},"Oeuf petit",40,10,400,0.4,null,null,"T",0,null,0,0,null,null,"Carotte","1 moyenne","100 g",null,"Pain complet","1 tranche ronde","45 g"]
[null,{"$f":"LARGE(B7:B34,1)+1","v":27},"Cacao Tasse thé de 15 cl",120,10,1200,1.2,null,{"$f":"LARGE(I7:I34,1)+1","v":80},"Œufs 1 douzaine",50,12,600,0.6,null,{"$f":"LARGE(P7:P34,1)+1","v":139},"Tapioca Tasse thé de 15 cl",100,10,1000,1,null,null,"Céleri rave, cru","1 portion","85 g",null,"Pain grillé blanc/gris",1,"21 g",null,"100 g d'aliments crus. légumes frais :  chou vert, cuit à l'eau 92, à l'étouffée 64, de Bruxelles 86, -fleur 92, "]
[null,{"$f":"LARGE(B7:B35,1)+1","v":28},"Canard vidé",1500,10,15000,15,null,{"$f":"LARGE(I7:I35,1)+1","v":81},"Œufs blanc d'",30,10,300,0.3,null,{"$f":"LARGE(P7:P35,1)+1","v":140},"Thon boite 1/10",80,10,800,0.8,null,null,"Céréales de petit déjeuner","1 tasse à café","40 g",null,"Pain d'épices","1 tranche","23 g"]
[null,{"$f":"LARGE(B7:B36,1)+1","v":29},"Carotte moyenne",120,10,1200,1.2,null,{"$f":"LARGE(I7:I36,1)+1","v":82},"Œufs entiers",50,10,500,0.5,null,{"$f":"LARGE(P7:P36,1)+1","v":141},"Thon boite 1/3 saladière",260,10,2600,2.6,null,null,"Cerise (sans noyau)",1,"4 g",null,"Pain de seigle","1 tranche","40 g",null,"100 g d'aliments crus. légumes frais : épinards cuits à l'eau ou au jus 83, haricots verts cuits à l'eau 104, à l'étouffée 90, navets, cuits à l'eau 95, à l'étouffée 92,"]
[null,{"$f":"LARGE(B7:B37,1)+1","v":30},"Céléri 1 branche",35,10,350,0.35,null,{"$f":"LARGE(I7:I37,1)+1","v":83},"Œufs jaune",20,10,200,0.2,null,{"$f":"LARGE(P7:P37,1)+1","v":142},"Thon boite 1/5",160,10,1600,1.6,null,null,"Cervelas",1,"150 g",null,"Pain de viande","1 fine tranche","30 g"]
[null,{"$f":"LARGE(B7:B38,1)+1","v":31},"Céléri rave",1000,10,10000,10,null,{"$f":"LARGE(I7:I38,1)+1","v":84},"Oignon moyen",70,10,700,0.7,null,{"$f":"LARGE(P7:P38,1)+1","v":143},"Thon boite 1/6 basse",430,10,4300,4.3,null,null,"Champignon, cuit","1 cuillère","30 g",null,"Pain français (baguette)","1 moyen","260 g",null,"100 g d'aliments crus. légumes frais : poireaux 81, p. de terre en robe des champs 98, à l'anglaise 95, au four 80, en purée 119, en ragoût 154, frites 44 1, "]
[null,{"$f":"LARGE(B7:B39,1)+1","v":32},"Cerises",65,10,650,0.65,null,{"$f":"LARGE(I7:I39,1)+1","v":85},"Olives",4,10,40,0.04,null,{"$f":"LARGE(P7:P39,1)+1","v":144},"Thon boite 1/8",52,10,520,0.52,null,null,"Chicon",1,"100 g",null,"Pamplemousse","1 moyen","200 g"]
[null,{"$f":"LARGE(B7:B40,1)+1","v":33},"Choux fleur",1500,10,15000,15,null,{"$f":"LARGE(I7:I40,1)+1","v":86},"Orange",240,10,2400,2.4,null,{"$f":"LARGE(P7:P40,1)+1","v":145},"Thon boite 4/4 saladière",118,10,1180,1.18,null,null,"Chips","1 paquet","30 g",null,"Papaye","1 moyenne","125 g",null,"100 g d'aliments crus. légumes frais : , potiron 55, scarole 71, tomates frites 69. Légumes secs : fèves 310, haricots 270,"]
[null,{"$f":"LARGE(B7:B41,1)+1","v":34},"Choux vert",2000,10,20000,20,null,{"$f":"LARGE(I7:I41,1)+1","v":87},"Orange moyenne",140,10,1400,1.4,null,{"$f":"LARGE(P7:P41,1)+1","v":146},"Tomate grosse",110,10,1100,1.1000000000000001,null,null,"Chocolat","1 barre","25 g",null,"Parmesan","1 cuillère","10 g"]
[null,{"$f":"LARGE(B7:B42,1)+1","v":35},"Citron moyen",80,10,800,0.8,null,null,"P",0,null,0,0,null,{"$f":"LARGE(P7:P42,1)+1","v":147},"Tomate moyenne",50,10,500,0.5,null,null,"Chou de Bruxelles, cuit","1 cuillère","40 g",null,"Pastèque","1 moyenne","1125 g",null,"100 g d'aliments crus. légumes frais : ,, pois cassés 400. "]
[null,{"$f":"LARGE(B7:B43,1)+1","v":36},"Clémentine",70,10,700,0.7,null,{"$f":"LARGE(I7:I43,1)+1","v":88},"Pamplemousse",400,10,4000,4,null,{"$f":"LARGE(P7:P43,1)+1","v":148},"Tomate petite",50,10,500,0.5,null,null,"Chou-fleur/brocoli, cuit","1 cuillère","30 g",null,"Pâte à tartiner (choco)","1 cuillère","33 g"]
[null,{"$f":"LARGE(B7:B44,1)+1","v":37},"Colin",2000,10,20000,20,null,{"$f":"LARGE(I7:I44,1)+1","v":89},"Pêche",120,10,1200,1.2,null,{"$f":"LARGE(P7:P44,1)+1","v":149},"Truite portion",250,10,2500,2.5,null,null,"Citron","1 moyen","70 g",null,"Pâté de foie","1 cuillère","15 g",null,"100 g d'aliments crus. l Poissons : au court-bouillon 95, frits 81. Crevettes : 97. "]
[null,{"$f":"LARGE(B7:B45,1)+1","v":38},"Concombre",200,10,2000,2,null,{"$f":"LARGE(I7:I45,1)+1","v":90},"Pied veau",1,10,10,0.01,null,{"$f":"LARGE(P7:P45,1)+1","v":150},"Turbot",3500,10,35000,35,null,null,"Clémentine",1,"35 g",null,"Pâtes, cuites","1 tasse à café","210 g"]
[null,{"$f":"LARGE(B7:B46,1)+1","v":39},"Coquillette Verre de 20 cl",120,10,1200,1.2,null,{"$f":"LARGE(I7:I46,1)+1","v":91},"Poireau beau",200,10,2000,2,null,null,"V",0,null,0,0,null,null,"Compote de pommes","1 cuillère","40 g",null,"Pâtes, sèches","1 tasse à café","70 g",null,"100 g d'aliments crus.  Viandes : bœuf : bifteck grillé 88, au gril 83, au plat 88, rôti (1/2 h) 77, bouilli 83. "]
[null,{"$f":"LARGE(B7:B47,1)+1","v":40},"Courgette",350,10,3500,3.5,null,{"$f":"LARGE(I7:I47,1)+1","v":92},"Poireau blanc de",40,10,400,0.4,null,{"$f":"LARGE(P7:P47,1)+1","v":151},"Veau carré couvert (5+3)",2200,10,22000,22,null,null,"Concombre, cru","1 portion","85 g",null,"Pêche (sans noyau)",1,"125 g"]
[null,{"$f":"LARGE(B7:B48,1)+1","v":41},"Cresson botte",200,10,2000,2,null,{"$f":"LARGE(I7:I48,1)+1","v":93},"Poireau moyen",150,10,1500,1.5,null,{"$f":"LARGE(P7:P48,1)+1","v":152},"Veau carré découvert (5)",2000,10,20000,20,null,null,"Confiture","1 cuillère","30 g",null,"Pickles","1 cuillère","15 g",null,"100 g d'aliments crus.  Viandes :  Veau : à la poêle 93, rôti (3/4 d'h) 74. Mouton : rôti 73, sauté 69. "]
[null,{"$f":"LARGE(B7:B49,1)+1","v":42},"Cuillère café liquide",5,10,50,0.05,null,{"$f":"LARGE(I7:I49,1)+1","v":94},"Poivron",150,10,1500,1.5,null,{"$f":"LARGE(P7:P49,1)+1","v":153},"Veau cervelle",300,10,3000,3,null,null,"Corned-beef","1 fine tranche","20 g",null,"Pistolet",1,"45 g"]
[null,{"$f":"LARGE(B7:B50,1)+1","v":43},"Cuillère soupe liquide",10,10,100,0.1,null,{"$f":"LARGE(I7:I50,1)+1","v":95},"Pomelos 1/2",200,10,2000,2,null,{"$f":"LARGE(P7:P50,1)+1","v":154},"Veau cœur",900,10,9000,9,null,null,"Corn Flakes","1 tasse à café","30 g",null,"Plie","1 pièce","135 g",null,"100 g d'aliments crus.  Viandes :  Porc : côtelette 83, rôti 64. Cheval : bifteck à la poêle 93. Foie : 91. Boudin : 94. Saucisse fraîche : 92."]
[null,null,"D",0,null,0,0,null,{"$f":"LARGE(I7:I51,1)+1","v":96},"Pomme",140,10,1400,1.4,null,{"$f":"LARGE(P7:P51,1)+1","v":155},"Veau Foie",3500,10,35000,35,null,null,"Couque à la crème",1,"80 g",null,"Poire","1 moyenne","160 g"]
[null,{"$f":"LARGE(B7:B52,1)+1","v":44},"Daurade",600,10,6000,6,null,{"$f":"LARGE(I7:I52,1)+1","v":97},"Pomme de terre moyenne",100,10,1000,1,null,{"$f":"LARGE(P7:P52,1)+1","v":156},"Veau langue",1200,10,12000,12,null,null,"Couque au beurre",1,"75 g",null,"Poireau, cuit","1 cuillère","45 g",null,null,"Verres"]
[null,null,"E",0,null,0,0,null,{"$f":"LARGE(I7:I53,1)+1","v":98},"Pomme fruit grosse",150,10,1500,1.5,null,{"$f":"LARGE(P7:P53,1)+1","v":157},"Veau noix",3100,10,31000,31,null,null,"Couque suisse","1 longue / ronde","75 g / 90 g",null,"Poivron vert/jaune/rouge","1 pièce","185 g",null,null,"Petit verre à eau/limonade, rempli normalement 150"]
[null,{"$f":"LARGE(B7:B54,1)+1","v":45},"Eau grand verre à eau",200,10,2000,2,null,{"$f":"LARGE(I7:I54,1)+1","v":99},"Pomme fruit moyenne",100,10,1000,1,null,{"$f":"LARGE(P7:P54,1)+1","v":158},"Veau noix patissière",2650,10,26500,26.5,null,null,"Courgette, cuite","1 cuillère","35 g",null,"Pomme","1 moyenne","140 g"]
[null,{"$f":"LARGE(B7:B55,1)+1","v":46},"Echalote belle",25,10,250,0.25,null,{"$f":"LARGE(I7:I55,1)+1","v":100},"Pomme terre grosse",200,10,2000,2,null,{"$f":"LARGE(P7:P55,1)+1","v":159},"Veau ris",750,10,7500,7.5,null,null,"Cramique","1 tranche","40 g",null,"Pomme de terre, cuite (ovale)",1,"50 g",null,null,"Grand verre à eau/limonade, rempli normalement 250"]
[null,{"$f":"LARGE(B7:B56,1)+1","v":47},"Echalote moyenne",18,10,180,0.18,null,{"$f":"LARGE(I7:I56,1)+1","v":101},"Pomme terre moyenne",120,10,1200,1.2,null,{"$f":"LARGE(P7:P56,1)+1","v":160},"Veau rognon",350,10,3500,3.5,null,null,"Crème","1 cuillère","24 g",null,"Pomme de terre, rôtie","1 cuillère","30 g"]
[null,{"$f":"LARGE(B7:B57,1)+1","v":48},"Echalote petite",10,10,100,0.1,null,{"$f":"LARGE(I7:I57,1)+1","v":102},"Pomme terre petite",80,10,800,0.8,null,{"$f":"LARGE(P7:P57,1)+1","v":161},"Veau sous noix",6200,10,62000,62,null,null,"Crème à fouetter","1 cuillère","12 g",null,"Porto","1 petit verre","75 ml",null,null,"Verre à vin: blanc/rouge, rempli normalement 125"]
[null,{"$f":"LARGE(B7:B58,1)+1","v":49},"Ecrevisse",35,10,350,0.35,null,{"$f":"LARGE(I7:I58,1)+1","v":103},"Porc cervelle ",225,10,2250,2.25,null,null,null,null,null,null,null,null,null,"Crème glacée","1 boule","50 g",null,"Poulet, poitrine (sans peau)","1 filet","160 g"]
[null,null,"F",0,null,0,0,null,{"$f":"LARGE(I7:I59,1)+1","v":104},"Porc cœur",225,10,2250,2.25,null,null,null,null,null,null,null,null,null,"Crêpe","1 pièce","60 g",null,"Poulet, cuisse(sans peau)","1 cuisse","165 g",null,null,"Verre à mousseux, rempli normalement 100"]
[null,{"$f":"LARGE(B7:B60,1)+1","v":50},"Farine 1 cuillère café",3,10,30,0.03,null,{"$f":"LARGE(I7:I60,1)+1","v":105},"Porc foie",750,10,7500,7.5,null,null,null,null,null,null,null,null,null,"Crevettes","1 cuillère","18 g",null,"Praline",1,"15 g"]
[null,{"$f":"LARGE(B7:B61,1)+1","v":51},"Farine 1 cuillère soupe",8,10,80,0.08,null,{"$f":"LARGE(I7:I61,1)+1","v":106},"Porc jambon",8.6,10,86,8.5999999999999993E-2,null,null,null,null,null,null,null,null,null,"Croissant","1 moyen","50 g",null,"Prune, sans noyau","1 moyenne","55 g",null,null,"Verre à bière, rempli normalement 250 et 330"]
[null,{"$f":"LARGE(B7:B62,1)+1","v":52},"Farine 1 tasse",100,10,1000,1,null,{"$f":"LARGE(I7:I62,1)+1","v":107},"Porc longe",11.5,10,115,0.115,null,null,null,null,null,null,null,null,null,"Croque-monsieur",1,"135 g",null,"Prune, sèche",1,"6 g"]
[null,{"$f":"LARGE(B7:B63,1)+1","v":53},"Farine Tasse thé de 15 cl",100,10,1000,1,null,{"$f":"LARGE(I7:I63,1)+1","v":108},"Porc poitrine",3.75,10,37.5,3.7499999999999999E-2,null,null,null,null,null,null,null,null,null,"Croquette de pomme de terre (c)","1 moyenne","27 g",null,"Pudding","1 portion","125 g/200 g",null,null,"Lors de l’établissement du poids des denrées alimentaires liquides (boissons alcoolisées,"]
[null,{"$f":"LARGE(B7:B64,1)+1","v":54},"Farine Verre de 20 cl",135,10,1350,1.35,null,{"$f":"LARGE(I7:I64,1)+1","v":109},"Porc rognon",170,10,1700,1.7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purée de pommes de terre","1 cuillère/portion","50 g/160 g"]
[null,{"$f":"LARGE(B7:B65,1)+1","v":55},"Fraise",12,10,120,0.12,null,{"$f":"LARGE(I7:I65,1)+1","v":110},"Poulet 4/4",1000,10,10000,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lait, lait chocolaté et lait de soja, milkshake et yaourt) les \"ml\" ont été assimilés aux \"g\""]
[null,null,null,null,null,null,null,null,{"$f":"LARGE(I7:I66,1)+1","v":111},"Poulet pac",1500,10,15000,15,null,null,null,null,null,null,null,null,null,"Aliment","Mesure de capacité ","Poids",null,"Aliment","Mesure de capacité ","Poids",null,null,"(source 7.104)."]
[null,null,null,null,null,null,null,null,{"$f":"LARGE(I7:I67,1)+1","v":112},"Pruneau",15,10,150,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datte sèche (sans noyau)",1,"9 g",null,"Radis","1 pièce","6 g",null,null,"Pour la crème glacée et la mousse, le facteur de conversion est mentionné dans la colonne"]
[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,"Raisin",1,"7 g",null,null,"précisions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Éclair au chocolat","1 pièce","115 g",null,"Raisin, sec","1 cuillère","12 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edam jeune","1 fine tranche","25 g",null,"Ravioli","1 portion","400 g"]
[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,"Riz au lait, vanille","1 portion","100 g/200 g",null,"Nota : (1) En cuisant, les pommes frites absorbent 8 à 10 % de matières grasses."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farine","1 cuillère","12 g",null,"Riz, cuit","1 portion","150 g",null,"Besoins journaliers (limites moyennes)","En grammes",null,null,"En milligrammes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fécule de pomme de terre","1 cuillère","12 g",null,"Riz, non cuit","1 sachet","62,5 g",null,null,"Protides","Lipides","Glucides","Calcium 7","Phosphore","Fer","Vit. C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fenouil",1,"200 g",null,null,null,null,null,"Jeunes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fève de soja, cuite","1 tasse à café","140 g",null,"Salami","1 fine tranche","9 g",null," 2 à 4 ans","30/35",32,"200/250","700/750","650/700","40/94","40/60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figue, sèche","1 pièce","20 g",null,"Sandwich sucré",1,"40 g",null," 4 à 6 ans","35/40",33,"200/250","600/800","600/800","40/94","40/60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filet d'Anvers","1 tranche","15 g",null,"Sardine","1 pièce","33 g",null," 6 à 10 ans","45/55",37,"300/340","850/950","850/950","40/94","40/60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flétan, fumé","1 fine tranche","30 g",null,"Saumon","1 tranche","180 g",null,"10 à 12 ans (filles 9 à 11)","60/65",50,"350/400 1","1 000/1 200","1 100/1 300","20/30","60/100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flocons d'avoine","1 tasse à café","45 g",null,"Saumon, fumé","1 fine tranche","30 g",null,"12 à 15 ans (filles 11 à 13)","5/9 2",65,"440/550 3","1 200/1 400","1 300/1 500","20/30","60/100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fraise","1 moyenne","15 g",null,"Sel","1 cuillère","15 g",null,"15 à 20 ans (filles 13 à 18)","75/100 4",75,"550/600 5","1 400/1 600","1 500/1 700","20/30","60/100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frangipane","1 part","100 g",null,"Soupe","1 tasse/1 assiette","300 ml/250 ml",null,"Hommes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frites","1 portion","250 g",null,"Spaghetti, préparé","1 assiette","300 g",null,"Vie sédentaire","75/85 4",60,"400/500","800/900","1 200/1 400","18/20","70/80"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fromage frais","1 cuillère","25 g",null,"Spéculoos","1 pièce","7 g",null,"Travail de force"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fromage fondu","1 portion/cuillère","20 g/15 g",null,"Sucre","1 cuillère/morceau","15 g/6 g",null," 4e et 3e cat.","85/110",75,"550/700","1 000/1 200","1 500/1 800","23/26","90/110"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fruit de la passion","1 moyen","15 g",null,"Sucre impalpable","1 cuillère","6 g",null," 2e et 1re cat.","100/110",95,"850/1 000","1 400/1 600","2 000/2 400","30/45","130/150"]
[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,"Femmes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galette de riz","1 pièce","7 g",null,"Tarte à la confiture","1 part","80 g",null,"Vie sédentaire","65/75 4",50,"350/400","800/900","1 000/1 200","15/20","60/70"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gaufre au chocolat","1 moyenne","60 g",null,"Tarte au riz","1 part","140 g",null,"Enceintes (5e-9e mois) 6","90/110",80,"500/550","1 500/2 000","1 500/2 000","20/25","100/150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gaufre de Liège","1 moyenne","55 g",null,"Tarte aux fruits","1 part","165 g",null,"Allaitant 6 ","100/110",80,"500/550","1 500/2 000","1 500/2 000","20/25","100/150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gouda","1 fine tranche","20 g",null,"Tarte aux mattons","1 morceau","120 g",null,"Vieillards 6 ",65,45,"300/400","900/1 000","900/1 000","14/16","50/60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graisse de cuisson","1 cuillère","18 g",null,"Toast","1 pièce","3 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gruyère","1 fine tranche","25 g",null,"Tomate","1 moyenne","150 g",null,"Nota : Pour les filles : (1) 330/350, (2) 80/85, (3) 400/500, (4) 85-90, (5) 500/550. (6) Vie sédentaire ou légère activité. (7) Contenu surtout dans le fromage et le lait."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gruyère, râpé","1 cuillère","15 g",null,"Truite","1 pièce","120 g"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamburger + sandwich","1 moyenne","130 g",null,"Viande de porc, côtelette","1 avec/sans côte","175g /160 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haricot blanc, cuit /sec","1 cuillère","35 g/105 g",null,"Viande de porc, tranche",1,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hareng/maatje","1 moyen","80 g",null,"Vin de table blanc/rouge","1 verre","125 ml"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Huile","1 cuillère","10 g",null,"Yaourt","1 cuillère","25 g"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jambon, cru, fumé","1 fine tranche","25 g",null,"4. MESURES DE CAPACITE*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jambon, cuit","1 fine tranche","45 g",null,"Mesures de capacité calculées à partir d’eau             ",null,"Poids en grammes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jambon de dinde","1 fine tranche","20 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jambon de poulet","1 fine tranche","20 g",null,"Cuillère à café",null,"4,5 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jus de pomme/jus d'orange","1 verre","150 ml",null,"Cuillère à soupe",null,"12 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ketchup","1 cuillère","23 g",null,"Cuillère à dessert",null,"8 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kiwi","1 moyen","75 g",null,"Cuillère à sauce",null,"25 g"]
[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,"Louche",null,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lait","1 verre","150 ml",null,"Tasse à ras bord",null,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lait battu nature","1 verre","150 ml",null,"Tasse liquide",null,"125 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lait chocolaté","1 petite bouteille","200 ml",null,"Grande tasse à ras bord",null,"250 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lait concentré","1 portion individuelle","7,5 g",null,"Grande tasse liquide",null,"225 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langue de bœuf","1 fine tranche","15 g",null,"Gobelet plastique à ras bord",null,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lapin/lièvre (cuisse)","1 morceau","250 g",null,"Gobelet plastique liquide",null,"125 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lard fumé","1 petite tranche","15 g",null,"Bol de soupe à ras bord",null,"300 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lasagne","1 portion","400 g",null,"Bol de soupe liquide",null,"250 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Levure fraîche","1 petit paquet","42 g",null,"Ravier à dessert",null,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limonade/cola/eau","1 verre","150 ml",null,"Verre à limonade/eau",null,"150 g"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Litchi",1,"11 g",null,"Verre à limonade grand",null,"250 g"]
[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,"Verre à vin rouge",null,"125 g"]
[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,"Verre à vin blanc",null,"125 g"]
[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,"Verre à champagne",null,"100 g"]
[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,"Verre à bière petit",null,"250 g"]
[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,"Verre à bière grand",null,"330 g"]
[]
[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,"* Source:"]
[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,"Groupe de travail « Poids et mesures », Conseil Supérieur d’Hygiène."]

{"sheet":"ORT","index":6,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,2,10],[3,1,4,10],[7,1,7,10],[14,2,14,10]]}
[null,"ORGANISATION RAISONNÉE DU TRAVAIL"]
[null,"PROCESS  > principales étapes  >  un verbe = une action"]
[]
[null,"Mesures d'Hygiène"]
[]
[null,"Auteur","Michel Grossman et Alain Le Franc  La cuisine de collectivité éditions BPI - 2006"]
[null,{"$f":"MID(CELL(\"filename\",B7),FIND(\"[\",CELL(\"filename\",B7)),300)","v":"[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]ORT"}]
[null,"MISE EN PLACE DU POSTE DE TRAVAIL"]
[null,1,"tenue professionnelle de circonstance (charlotte-masque)"]
[null,"2","verifier - bactéricide - esssuie mains - sacs poubelle"]
[null,"3","vérifier températures - locaux et chambres froides"]
[null,"4","se laver les mains souvent - prévoir gants"]
[null,"5","sélectionner le matériel nécessaire"]
[null,"6","laver et désinfecter le matériel et le poste de travail"]
[null,null,"ORGANISATION RAISONNÉE DU TRAVAIL"]
[null,"1","controler les marchandises - qualité - quantité - températures"]
[null,"2","vérifier les DLC - relever les N° de lot ou conserver les étiquettes"]
[null,"3","désinfecter les sachets - poches - barquettes - boites avant ouverture"]
[null,"4","laver légumes et fruits avant utilisation"]
[null,"5","égoutter en bacs perforées si besoin"]
[null,"6","décongeler en bacs perforés + étiquette date de décongélation"]
[null,"7","cuire et refroidir en cellule avant assemblage"]
[null,"8","trancher - découper - hacher en respectant les protocoles"]
[null,"9","préparer l'assaisonnement ou la sauce"]
[null,"10","assembler"]
[null,"11","gouter et vérifier l'assaisonnement - dresser"]
[null,"12"," décorer  "]
[null,"13","conditionner et étiqueter DLC"]
[null,"14","garder un plat témoins"]
[null,"15","stocker en chambre froide"]
[]
[null,null,"Pour vérification : cocher - entourer - ou surligner les produits ou actions concernées"]
[null,null,"Si vous manquez de place pour les codes barres traçabilité "]
[null,null,"collez les au dos de cette feuille en indiquant le N° de ligne produit"]

{"sheet":"utilitaires","index":7,"n_rows":322,"n_cols":17,"rows_kept":322,"cut":false,"hidden":false,"merged":[[269,0,270,13],[315,1,316,13],[238,1,239,13],[240,2,240,13],[241,2,241,13],[242,1,242,13],[255,1,255,9],[267,1,267,9],[217,11,218,12],[224,1,224,13],[225,11,225,12],[226,11,226,12],[236,2,236,3],[236,5,236,6],[236,8,236,9],[236,11,236,12],[205,2,205,13],[206,1,206,13],[208,0,209,0],[208,1,209,12],[208,13,209,13],[210,0,242,0],[210,1,210,13],[211,1,214,13],[215,1,215,13],[216,11,216,12],[200,2,200,3],[200,5,200,6],[200,8,200,9],[200,11,200,12],[202,1,203,13],[204,2,204,13],[176,1,177,13],[179,0,180,0],[179,1,180,12],[179,13,180,13],[181,0,206,0],[181,1,181,13],[182,1,185,13],[186,1,186,13],[187,11,187,12],[188,11,188,12],[164,2,164,3],[164,4,164,5],[165,2,165,3],[165,4,165,5],[168,2,170,12],[174,0,175,13],[161,2,161,3],[161,4,161,5],[162,2,162,3],[162,4,162,5],[163,2,163,3],[163,4,163,5],[158,2,158,3],[158,4,158,5],[159,2,159,3],[159,4,159,5],[160,2,160,3],[160,4,160,5],[155,2,155,3],[155,4,155,5],[156,2,156,3],[156,4,156,5],[157,2,157,3],[157,4,157,5],[151,2,152,3],[151,4,152,5],[151,6,152,6],[151,7,152,12],[153,2,153,12],[154,2,154,3],[154,4,154,5],[145,2,145,3],[145,4,145,5],[145,6,145,8],[149,2,150,3],[149,4,150,5],[149,6,150,6],[149,7,149,12],[142,2,143,3],[142,4,143,5],[142,6,143,8],[142,12,143,12],[144,2,144,3],[144,4,144,5],[144,6,144,8],[137,2,137,3],[137,4,137,5],[138,2,138,3],[138,4,138,5],[140,2,140,12],[141,4,141,12],[131,2,131,12],[132,2,132,12],[133,4,133,12],[134,2,134,12],[135,2,136,3],[135,4,136,5],[119,10,120,11],[121,2,122,2],[121,3,122,3],[121,4,122,5],[121,6,122,6],[121,7,122,7],[121,9,122,9],[121,10,122,11],[116,8,117,8],[116,9,117,9],[119,2,120,2],[119,3,120,3],[119,4,120,5],[119,6,120,6],[119,7,120,7],[119,8,120,9],[113,2,114,5],[113,6,114,7],[113,8,114,8],[113,9,114,10],[113,11,114,11],[116,2,117,3],[116,4,117,4],[116,5,117,5],[116,6,117,6],[116,7,117,7],[95,3,95,5],[97,3,97,5],[99,3,99,5],[103,2,103,11],[105,2,108,11],[109,2,112,11],[86,2,91,2],[87,3,87,5],[88,3,88,5],[89,3,89,5],[90,3,90,5],[91,3,91,5],[78,2,78,11],[79,2,79,11],[80,2,80,11],[82,2,84,2],[83,3,83,5],[84,3,84,5],[71,2,71,4],[71,7,71,8],[71,10,71,11],[72,2,72,4],[76,2,76,11],[77,2,77,11],[69,2,69,4],[69,7,69,8],[69,10,69,11],[70,2,70,4],[70,7,70,8],[70,10,70,11],[67,2,67,4],[67,7,67,8],[67,10,67,11],[68,2,68,4],[68,7,68,8],[68,10,68,11],[65,2,65,4],[65,7,65,8],[65,10,65,11],[66,2,66,4],[66,7,66,8],[66,10,66,11],[45,1,45,4],[47,3,47,15],[49,3,49,15],[53,11,53,13],[63,2,63,11],[64,2,64,4],[64,7,64,8],[64,10,64,11],[42,13,43,13],[43,1,44,1],[43,2,44,2],[43,3,44,3],[43,4,44,4],[44,7,44,13],[42,7,43,7],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[42,12,43,12],[39,9,40,9],[39,10,40,10],[39,11,40,11],[39,12,40,12],[39,13,40,13],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,7,41,13],[37,10,38,10],[37,11,38,11],[37,12,38,12],[37,13,38,13],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[39,7,40,7],[39,8,40,8],[32,1,33,1],[32,2,33,6],[32,8,32,9],[33,8,33,9],[36,1,37,2],[36,3,37,3],[36,4,37,4],[37,7,38,7],[37,8,38,8],[37,9,38,9],[29,2,29,6],[29,8,29,9],[30,1,31,1],[30,2,31,6],[30,8,30,9],[31,8,31,9],[27,2,27,6],[27,8,28,9],[27,10,28,11],[27,12,28,12],[27,13,28,13],[28,2,28,6],[21,1,22,6],[21,9,23,9],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[15,8,16,15],[19,1,20,6],[19,8,19,12],[20,8,20,12],[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,16],[7,8,7,15],[8,8,8,11],[8,12,8,15]]}
[{"$f":"CELL(\"largeur\",A1)","v":4},10,11,11,11,11,11,10,11,11,11,11,11,11,11,{"$f":"CELL(\"largeur\",P1)","v":11},{"$f":"CELL(\"largeur\",Q1)","v":11}]
[null,"Cuisiniers : PESEZ …..Evitez les volumes , n'utilisez que les poids comme les pâtissiers"]
[null,"Les cuisiniers \"sont des artistes\"……..ce qui ne doit pas les empêcher … d'UTILISEZ UNE BALANCE…...les résultats seront plus réguliers"]
[null,"Cuisiniers : PESEZ …..même le sel…..on ne sale pas 50L de sauce à la \"chichette\" au \"pif\" ou à l'expérience"]
[null," la sauce crémée ne se sale pas comme la sauce tomatée etc……."]
[]
[]
[null,null,null,null,null,null,null,null,"Equivalence litre / Kg"]
[null,null,null,null,null,null,null,null,"sur la base eau : 1L = 1Kg ",null,null,null,"Saisissez vos valeurs"]
[null,null,null,null,null,null,null,null,"Litres (l.) ","Centilitres (cl.) ","Décilitres (dl.) ","Kilogrammes (kg.) ","Kg","hg","dag","gr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"L","dl","cl","ml"]
[null,null,null,null,null,null,null,null,"1litre","100 cl","10 dl","1 kg",1,"0","0",0]
[null,null,null,null,null,null,null,null,"1/2 litre","50 cl","5 dl","0,500 kg",0,5,"0",0]
[null,null,null,null,null,null,null,null,"1/4 litre","25 cl","2,5 dl","0,250 kg",0,2,5,0]
[null,null,null,null,null,null,null,null,"1/8 litre","12, 5 c","1,25 dl","0,125 kg",0,1,2,5]
[null,null,null,null,null,null,null,null,"http://www.cuisinealafrancaise.com/fr/2-poids-et-mesures"]
[]
[]
[]
[null,"LIAISON AU TAPIOCA",null,null,null,null,null,null,"Equivalence litre / Kg",null,null,null,null,null,"Saisissez votre volume"]
[null,null,null,null,null,null,null,null,"Saisissez vos valeurs",null,null,null,null,null,2.5,"L","Kg"]
[null,"POUR 1 LITRE DE SAUCE TERMINÉE",null,null,null,null,null,null,"Kg",",","hg","dag","gr",null,{"$f":"O21*10","v":25},"dl","hg"]
[null,null,null,null,null,null,null,null,"L",null,"dl","cl","ml",null,{"$f":"O22*10","v":250},"cl","dag"]
[null,"30 gr","pour lier 1L de soupe à l'oignon ",null,null,null,null,null,"0",null,"0","0","1",null,{"$f":"O23*10","v":2500},"ml","gr"]
[null,"30 gr","pour lier 200g de chair à saucisse pour tomates farcies ",null,null,null,null,null,"sur la base eau : 1L = 1Kg "]
[null,"30 gr","pour lier 1Kg de tomates concassées avec jus ",null,null,null,null,null,"1 gr = 2 zéros après la virgule du Kg"]
[null,"40 gr","pour quiche avec 2 œufs"]
[null,"50 gr","sauce bien liée épaisse",null,null,null,null,null,"SERVICE DES SAUCES",null,"Plat mode de cuisson",null,"Grammages sauce p.p.","1 Kg pour :"]
[null,"60 gr","plus 8 œufs pour crème patissière"]
[null,"60 gr","un velouté ou une sauce veloutée",null,null,null,null,null,"Sans sauce",null,"grillé,frit,nature"]
[null,"70/80 gr","béchamelle gluante, solidification à froid, donc épaississement important lors de la chute en température",null,null,null,null,null,"Déglaçage",null,"roti,poélé",null,"20/30 g","33 à 50 p."]
[null,null,null,null,null,null,null,null,"Sauce courte",null,"pièces sautées",null,"40/50 g","20 à 25 p."]
[null,"90 gr","pour lier 1L de lait pour gratin d'épinards avec 4 œufs et 120g de gruyère",null,null,null,null,null,"Sauce longue",null,"ragoûts,braisés",null,"60/80 g","12 à 16 p."]
[null,null,null,null,null,null,null,null,"Bouillon",null,"pochés,plats complets",null,"90/150 g","6 à 11 p."]
[]
[null,"Quantités nettes à prévoir : Mater - Prim - Adul - Adul+  ",null,null,null,null,null,"PURÉE DÉSHYDRATÉE"]
[null,"Grammages nets",null,"Quantité Totale ",{"$f":"(B39*B42)+(C39*C42)+(D39*D42)+(E39*E42)","v":228.85000000000002},null,null,"Purée déshydratée","Eau","Lait déshydraté","Lait frais","Crème fraiche","Beurre","Poids reconstitué"]
[null,null,null,null,null,null,null,0.12,1,0.11,0,0.01,5.0000000000000001E-3,{"$f":"SUM(H38:M38)","v":1.2450000000000001}]
[null,6.5000000000000002E-2,7.4999999999999997E-2,0.12,0.15]
[null,null,null,null,null,null,null,{"$f":"(H38/N38)*N40","v":2.1204819277108431},{"$f":"(I38/N38)*N40","v":17.670682730923691},{"$f":"(J38/N38)*N40","v":1.9437751004016062},{"$f":"(K38/N38)*N40","v":0},{"$f":"(L38/N38)*N40","v":0.17670682730923692},{"$f":"(M38/N38)*N40","v":8.8353413654618462E-2},22]
[null,"Maternelles","Primaires","Adultes ","Adultes +"]
[null,920,1700,240,85,null,null,"Poids à l'arrondi supérieur"]
[null,null,null,null,null,null,null,{"$f":"ROUNDUP(H40,2)","v":2.13},17.680000000000003,1.95,0,0.18000000000000002,0.09,{"$f":"SUM(H43:M43)","v":22.03}]
[null," Effectifs",{"$f":"SUM(B42:E42)","v":2945},"Parts Adultes",{"$f":"IF(E37=0,0,E37/D39)","v":1907.0833333333335}]
[null,null,null,null,null,null,null,"Saisissez vos valeurs dans les cellules fond ivoire ou jaune"]
[null,"Saisissez vos valeurs dans les cellules fond ivoire ou jaune"]
[]
[null,null,null,"Combien faut-il commander pour des effectifs et des grammages différents"]
[]
[null,null,null,"Petit utilitaire d'Aide à la décision"]
[]
[null,null,null,null,null,null,"Saisissez vos effectifs ",250,620,37,14,{"$f":"SUM(H52:K52)","v":921},"couverts"]
[null,null,null,null,null,null," et vos grammages nets à servir",4.4999999999999998E-2,7.0000000000000007E-2,0.11,0.13,null,"% de perte",25,"@"]
[null,null,null,null,null,null,"Familles de convives","Mater","Prim","Adultes","Adultes +","Quantités à Prévoir"]
[null,null,null,null,null,null,"Net à servir :",{"$f":"H53*H52","v":11.25},{"$f":"I53*I52","v":43.400000000000006},{"$f":"J53*J52","v":4.07},{"$f":"K53*K52","v":1.82},{"$f":"SUM(H55:K55)","v":60.540000000000006},null,"Net"]
[null,null,null,null,null,null,"Brut à Commander",{"$f":"H55/(100-N53)*100","v":15},{"$f":"I55/(100-N53)*100","v":57.866666666666674},{"$f":"J55/(100-N53)*100","v":5.4266666666666667},{"$f":"K55/(100-N53)*100","v":2.4266666666666667},{"$f":"SUM(H56:K56)","v":80.72},null,"Brut"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L56-L55","v":20.179999999999993},null,"poids de perte"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(L57/L52)*1000","v":21.910966340933761},null,"en moyenne par convive"]
[null,null,null,null,"@","Facultatif Mais si vous saisissez un % la question à vous poser c'est : le produit brut ou cru perd comblien au parage ou en cuisson"]
[null,null,null,null,null,"Vous obtiendrez le poids brut à commander"]
[]
[]
[]
[null,null,"Composition d'une garniture \"COUSCOUS\""]
[null,null,"POIDS NET A FABRIQUER",null,null,1,{"$f":"F65","v":1},"Net cuit",null,"perte en cuisson","Poids brut à mettre en œuvre"]
[null,null,"carottes coupées",null,null,25,{"$f":"G65","v":1},{"$f":"(G66*F66)/100","v":0.25},null,20,{"$f":"H66/(100-J66)*100","v":0.3125}]
[null,null,"courgettescoupées",null,null,20,{"$f":"G65","v":1},0.2,null,25,0.26666666666666672]
[null,null,"navets coupé",null,null,15,{"$f":"G65","v":1},0.15,null,20,0.1875]
[null,null,"pois chiches pré-cuits",null,null,15,{"$f":"G65","v":1},0.15,null,0,0.15]
[null,null,"garniture de céléri branche",null,null,10,{"$f":"G65","v":1},0.1,null,20,0.125]
[null,null,"poivrons rouges coupés",null,null,7.5,{"$f":"G65","v":1},7.4999999999999997E-2,null,20,9.375E-2]
[null,null,"poivrons verts coupés",null,null,7.5,{"$f":"G65","v":1},7.4999999999999997E-2,null,20,9.375E-2]
[null,null,"Total",null,null,{"$f":"SUM(F66:F72)","v":100}]
[]
[]
[]
[null,null,"COMPOSITION ET SERVICE D'UN PLAT COMPLET"]
[null,null,"Veullez saisir les informations dans les cellules fond de couleur ivoire. "]
[null,null,"SERVICE EN FONCTION DES EFFECTIFS"]
[null,null,{"$f":"CELL(\"nomfichier\")","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12-Nota"}]
[null,null,"COUSCOUS"]
[null,null,null,null,"Document édité le :",null,{"$f":"TODAY()","v":"2022-02-17"},null,null,{"$f":"NOW()","v":44609.723380439813}]
[null,null,1,"Effectifs  à saisir"]
[null,null,null,"Famille de convives",null,null,null,"Mater","Prim","Adultes","Adultes +","Ainés"]
[null,null,null,"Total Effectifs",null,null,{"$f":"SUM(H85:L85)","v":2170},550,920,340,150,210]
[]
[null,null,2,"grammages ou nombre de Morceaux ou tranches à saisir"]
[null,null,null,"haut de cuisse de poulet",null,null,{"$f":"(H88*H85)+(I88*I85)+(J88*J85)+(K88*K85)+(L88*L85)","v":1470},0,1,1,0,1]
[null,null,null,"pilon de poulet",null,null,{"$f":"(H89*H85)+(I89*I85)+(J89*J85)+(K89*K85)+(L89*L85)","v":850},1,0,0,2,0]
[null,null,null,"merguez",null,null,{"$f":"(H90*H85)+(I90*I85)+(J90*J85)+(K90*K85)+(L90*L85)","v":1895},0.5,1,1,1,1]
[null,null,null,"Agneau en morceaux",null,null,{"$f":"(H91*H85)+(I91*I85)+(J91*J85)+(K91*K85)+(L91*L85)","v":1190},0,0,2,2,1]
[null,null,null,"Agneau boulettes",null,null,{"$f":"(H92*H85)+(I92*I85)+(J92*J85)+(K92*K85)+(L92*L85)","v":2540},1,2,0,1,0]
[null,null,null,null,null,null,null,"Mater","Prim","Adultes","Adultes +","Ainés"]
[null,null,null,null,null,null,"Total Mx par convive",{"$f":"SUM(H88:H93)","v":2.5},{"$f":"SUM(I88:I93)","v":4},{"$f":"SUM(J88:J93)","v":4},{"$f":"SUM(K88:K93)","v":6},{"$f":"SUM(L88:L93)","v":3}]
[]
[null,null,3,"légumes couscous cuits",null,null,{"$f":"(H96*H85)+(I96*I85)+(J96*J85)+(K96*K85)+(L96*L85)","v":208.60000000000002},0.06,0.08,0.15,0.2,0.1]
[]
[null,null,4,"Semoule cuite",null,null,{"$f":"(H98*H85)+(I98*I85)+(J98*J85)+(K98*K85)+(L98*L85)","v":213.5},0.06,0.1,0.12,0.15,0.12]
[]
[null,null,5,"Bouillon",null,null,{"$f":"(H100*H85)+(I100*I85)+(J100*J85)+(K100*K85)+(L100*L85)","v":237.5},0.06,0.1,0.15,0.2,0.15]
[]
[]
[]
[null,null,"Comment respecter un grammage à servir Exemple N° 1"]
[null,null,"Police de couleur pour saisir vos valeurs    Noir ou gris = formules"]
[null,null,"Les quantités consommées par les enfants dépendent :de l'âge, de la saison, du goût, de l'influence des camarades,de l'activité phisique et/ou du grignotage en récréation sans parler du verre de lait (long à digérer) servi parfois trop près de l'heure du repas"]
[]
[]
[]
[null,null,"Au repas si l'enfant mange beaucoup de pain avec ou en remplacement du plat proposé; les quantités ingérées seront d'autant diminuées. Pour limiter le \"gaspillage\" et satisfaire les \"gourmants\"; vous pouvez avoir recours à cet exemple de service."]
[]
[]
[]
[null,null,"POSSON PANÉ",null,null,null,"Poids unitaire du produit ",null,0.09,"Grammages à servir",null,0.12]
[]
[]
[null,null,{"$f":"IF(E117=\"\",\"produit à servir\",\"produits entiers à couper en \")","v":"produits entiers à couper en "},null,{"$f":"IF(K124=1,\"\",K124)","v":1.5},{"$f":"LARGE(F125:F129,1)","v":3},"parts","pour",{"$f":"LARGE(G125:G129,1)","v":2},"enfants"]
[]
[]
[null,null,{"$f":"IF(D120=\"\",\"MOINS\",\"Servir \")","v":"Servir "},{"$f":"IF(F117-1=0,\"\",F117-1)","v":2},{"$f":"IF(D120=\"\",\"\",IF(G120=1,\"produits entiers de\",\"produits coupés en \"))","v":"produits entiers de"},null,{"$f":"IF(D120=\"\",\"\",I117/D120)","v":1},{"$f":"IF(D120=\"\",\"\",\"parts\")","v":"parts"},{"$f":"IF(D120=\"\",\"\",\"grammage unitaire\")","v":"grammage unitaire"},null,{"$f":"IF(D120=\"\",\"\",I114/G120)","v":0.09}]
[]
[null,null,{"$f":"IF(D120=\"\",\"\",\"plus\")","v":"plus"},{"$f":"IF(D120=\"\",\"\",F117-D120)","v":1},{"$f":"IF(D122=\"\",\"\",\"produit coupé en \")","v":"produit coupé en "},null,{"$f":"IF(E122=\"\",\"\",I117)","v":2},{"$f":"IF(E122=\"\",\"\",\"parts\")","v":"parts"},null,{"$f":"IF(D122=\"\",\"moins\",\" de\")","v":" de"},{"$f":"IF(E122=\"\",I114-L114,I114/G122)","v":4.4999999999999998E-2}]
[]
[null,null,"Poids  produit à servir","Poids  produit envoyé","Écart de poids","Meilleur rapport",null,"produits entiers","pour",null,{"$f":"LARGE(L125:L129,1)","v":1.5},{"$f":"SMALL(E125:E129,COUNTIF(E125:E129,0)+1)","v":3.0000000000000027E-2}]
[null,null,{"$f":"L114*I125","v":0},{"$f":"I114*H125","v":0.09},{"$f":"D125-C125","v":0.09},{"$f":"IF(E125=L124,H125,0)","v":0},{"$f":"IF(F125>0,I125,0)","v":0},1,{"$f":"INT(J125)","v":0},{"$f":"D125/L114","v":0.75},{"$f":"IF(F125=0,0,F125/G125)","v":0},{"$f":"ROUNDDOWN(K125,1)","v":0}]
[null,null,{"$f":"L114*I126","v":0.12},{"$f":"I114*H126","v":0.18},{"$f":"D126-C126","v":0.06},{"$f":"IF(E126=L124,H126,0)","v":0},{"$f":"IF(F126>0,I126,0)","v":0},2,{"$f":"INT(J126)","v":1},{"$f":"D126/L114","v":1.5},{"$f":"IF(F126=0,0,F126/G126)","v":0},{"$f":"ROUNDDOWN(K126,1)","v":0}]
[null,null,{"$f":"L114*I127","v":0.24},{"$f":"I114*H127","v":0.27},{"$f":"D127-C127","v":3.0000000000000027E-2},{"$f":"IF(E127=L124,H127,0)","v":3},{"$f":"IF(F127>0,I127,0)","v":2},3,{"$f":"INT(J127)","v":2},{"$f":"D127/L114","v":2.2500000000000004},{"$f":"IF(F127=0,0,F127/G127)","v":1.5},{"$f":"ROUNDDOWN(K127,1)","v":1.5}]
[null,null,{"$f":"L114*I128","v":0.36},{"$f":"I114*H128","v":0.36},{"$f":"D128-C128","v":0},{"$f":"IF(E128=L124,H128,0)","v":0},{"$f":"IF(F128>0,I128,0)","v":0},4,{"$f":"INT(J128)","v":3},{"$f":"D128/L114","v":3},{"$f":"IF(F128=0,0,F128/G128)","v":0},{"$f":"ROUNDDOWN(K128,1)","v":0}]
[null,null,{"$f":"L114*I129","v":0.36},{"$f":"I114*H129","v":0.44999999999999996},{"$f":"D129-C129","v":8.9999999999999969E-2},{"$f":"IF(E129=L124,H129,0)","v":0},{"$f":"IF(F129>0,I129,0)","v":0},5,{"$f":"INT(J129)","v":3},{"$f":"D129/L114","v":3.7499999999999996},{"$f":"IF(F129=0,0,F129/G129)","v":0},{"$f":"ROUNDDOWN(K129,1)","v":0}]
[]
[]
[null,null,"Tableaux pour service ou cuisson"]
[null,null,"1 = saisissez le poids dans un contenant (une louche - une barquette etc,,)"]
[null,null,null,null,"2 =  saisissez le poids de la portion à servir par convive"]
[null,null,"Police de couleur pour saisir vos valeurs    Noir = formules"]
[null,null," Poids dans 1 contenant",null,"Poids d' une Portion"]
[]
[null,null,10,null,0.1,null,null,null,null,null,"1 louche ou 1 contenant pour ",{"$f":"C138/E138","v":100}]
[null,null,1,null,7.0000000000000007E-2,null,null,null,null,null,"1 louche ou 1 contenant pour ",{"$f":"C139/E139","v":14.285714285714285}]
[]
[null,null,"1 = saisissez le poids dans un contenant (une louche - une barquette etc,,)"]
[null,null,null,null,"2 =  saisissez le nombre de portions à servir"]
[null,null," Poids dans 1 contenant",null,"Nb de Portions à servir",null,"Exemples",null,null,null,null,null,"Poids de la portion"]
[]
[null,null,0.9,null,7,null,"1 melon de ",null,null,{"$f":"C145","v":0.9},"pour",{"$f":"E145","v":7},{"$f":"C145/E145","v":0.12857142857142859}]
[null,null,3.5,null,20,null,"1 plaque hachis parmentier ",null,null,{"$f":"C146","v":3.5},"pour",{"$f":"E146","v":20},{"$f":"C146/E146","v":0.17499999999999999}]
[]
[]
[]
[null,null,"Total Mx dans 1 contenant",null,"Portion Nb de Mx par portion",null,"Nb portions","Police de couleur pour saisir vos valeurs    Noir = formules"]
[]
[null,null,32,null,1.45,null,{"$f":"C152/E152","v":22.068965517241381},"QUOI ?"]
[]
[null,null,"EXEMPLES"]
[null,null,32,null,1.2,null,{"$f":"C155/E155","v":26.666666666666668},"32 tranches par plaque ( 1 plaque pour 26 maternelles)"]
[null,null,12,null,1,null,12,"table de 12"]
[null,null,32,null,2,null,16,"32 tranches par plaque ( 1 plaque pour 16 adultes)"]
[null,null,32,null,1.2,null,26.666666666666668,"32 tranches par plaque ( 1 plaque pour 16 adultes)"]
[null,null,33,null,1.3,null,25.384615384615383,"1 plaque pour 25 ( 1 tranche par maternelle plus RAB )"]
[null,null,33,null,1.5,null,22,"33 tranches par plaque ( 1.5 tranches par primaire)"]
[null,null,30,null,1.2,null,25,"1 plaque pour 25 ( 1 morceau par maternelle plus RAB )"]
[null,null,33,null,1.6,null,20.625,"1 plaque pour 20 ( 1 morceau par primaire plus RAB )"]
[null,null,33,null,2,null,16.5,"1 plaque pour 16 ( 1 morceau par adulte plus RAB )"]
[null,null,48,null,6,null,8,"1 plaque pour 8 ( 6 morceau par adulte + )"]
[null,null,1,null,0.25,null,4,"1 CITRON POUR 4"]
[null,null,25,null,1,null,25,"1 Boite de compote pour 25"]
[]
[null,null,"Le contenant peut être une louche pour le service - un gastro pour la cuisson  etc…"]
[null,null,"Les Mx cela peut s'appliquer à des morceaux de bourguignon mais aussi des tomates farcies ou des oreillons de pêches au sirop pour le dessert etc.."]
[]
[]
[]
[]
[]
["COMPLÉMENTS"]
[]
[null,"Mise à jour du 3 Janvier 2017"]
[]
[]
["ICI","QUANTITÉS A SERVIR OU A COMMANDER",null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,"DESCRIPTIF"]
[null," Saisissez vos effectifs - Saisissez vos quantités pour vos familles de convives et vous obtiendrez le net à servir. Avez-vous un pourcentage de perte (à l'épluchage -au parage - en cuisson ou autre)…saisissez le et vous obtiendrez les quantités brutes à commander"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"❶"]
[null,null,null,null,null,null,null,null,null,null,"Que traitez vous : des Kg des litres des pièces - des portions …des poires etc…","pommes"]
[]
[null,null,null,null,null,"Famille de convives","Mater","Prim","Adultes","Adultes +","Seniors"]
[null,null,null,null,null,"Saisissez vos effectifs ",50,500,150,13,13,{"$f":"SUM(G192:K192)","v":726},"couverts"]
[null,null,null,null,null,"Saisissez vos quantités nets à servir",0.5,1,1,2,1,{"$f":"SUM(G193:K193)/COUNTIF(G193:K193,\">0\")","v":1.1000000000000001},"de moyenne"]
[null,null,null,null,null,"Net à préparer :",{"$f":"G193*G192","v":25},{"$f":"H193*H192","v":500},{"$f":"I193*I192","v":150},{"$f":"J193*J192","v":26},{"$f":"K193*K192","v":13},{"$f":"SUM(G194:K194)","v":714},{"$f":"L189","v":"pommes"}]
[null,null,null,null,null,null,{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"}]
[null,null,"% de perte",10,"❷"]
[null,null,null,null,null,"Brut à Commander",{"$f":"G194/(100-D196)*100","v":27.777777777777779},{"$f":"H194/(100-D196)*100","v":555.55555555555554},{"$f":"I194/(100-D196)*100","v":166.66666666666669},{"$f":"J194/(100-D196)*100","v":28.888888888888886},{"$f":"K194/(100-D196)*100","v":14.444444444444443},{"$f":"SUM(G197:K197)","v":793.33333333333337},{"$f":"L189","v":"pommes"}]
[null,null,null,null,null,null,{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"},{"$f":"L189","v":"pommes"}]
[]
[null,"❶","Collez une des unités suivante ou saisissez un nom de produit"]
[null,null,"litres",null,null,"Kg",null,null,"Portions",null,null,"Pièce(s)"]
[null,"❷","si vous n'avez pas de perte ne saisissez rien"]
[null,"Familles de convives :Mater = enfants Maternelles - Prim = enfants de l'enseignement Primaire - Adulte = sédentaire - Adulte + = travailleur de force - Seniors = nos Ainés - je classe les Adolescennts en Adultes +"]
[]
[null,"Adresse PC",{"$f":"CELL(\"nomfichier\")","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12-Nota"}]
[null,"Mise à jour","du 03-01-2017 - Annule et remplace les versions précédentes"]
[null,"Adaptation : Joël Leboucher..UPRT \"Union des Personnels de la Restauration Territoriale\"  membre du réseau RESTAU'CO"]
[]
["ICI","COMBIEN POURRIEZ VOUS SERVIR AVEC",null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,"DESCRIPTIF"]
[null,"Vous avez préparé ou il vous reste un poids X d'une préparation. Avec ce poids combien de convives ou combien de portions pourrez vous servir"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"❶"]
[null,null,null,null,null,null,null,null,null,null,"Poids de votre préparation ",2.4]
[]
[]
[null,null,null,null,null,"Famille de convives","Mater","Prim","Adultes","Adultes +","Seniors"]
[null,null,null,null,null,"Saisissez vos grammages nets à servir",0.05,0.08,0.11,0.125,7.0000000000000007E-2,{"$f":"SUM(G222:K222)/COUNTIF(G222:K222,\">0\")","v":8.6999999999999994E-2},"de moyenne"]
[null,null,null,null,null,"Vous pourrIez servir",{"$f":"L218/G222","v":47.999999999999993},{"$f":"L218/H222","v":30},{"$f":"L218/I222","v":21.818181818181817},{"$f":"L218/J222","v":19.2},{"$f":"L218/K222","v":34.285714285714285},"Portions / pièces / parts"]
[null,"❶","A vous de saisir un poids"]
[null,"BONUS"]
[null,null,null,null,null,null,null,null,null,null,null,"❷"]
[null,null,null,null,null,null,null,null,null,null,"Que traitez vous : des Kg des litres des pièces - des portions …des poires etc…","Kg"]
[]
[null,null,null,null,null,"Saisissez vos effectifs ",50,500,150,13,13,{"$f":"SUM(G229:K229)","v":726},"couverts"]
[null,null,null,null,null,"Vous devriez préparer :",{"$f":"G222*G229","v":2.5},{"$f":"H222*H229","v":40},{"$f":"I222*I229","v":16.5},{"$f":"J222*J229","v":1.625},{"$f":"K222*K229","v":0.91000000000000014},{"$f":"SUM(G230:K230)","v":61.534999999999997},{"$f":"L227","v":"Kg"}]
[null,null,null,null,null,null,{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"}]
[null,null,"% de perte",50,"❸"]
[null,null,null,null,null,"Brut à Commander",{"$f":"G230/(100-D232)*100","v":5},{"$f":"H230/(100-D232)*100","v":80},{"$f":"I230/(100-D232)*100","v":33},{"$f":"J230/(100-D232)*100","v":3.25},{"$f":"K230/(100-D232)*100","v":1.8200000000000005},{"$f":"SUM(G233:K233)","v":123.07000000000001},{"$f":"L227","v":"Kg"}]
[null,null,null,null,null,null,{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"},{"$f":"L227","v":"Kg"}]
[null,"❸","si vous n'avez pas de perte ne saisissez rien"]
[null,"❷","Collez une des unités suivante ou saisissez un nom de produit"]
[null,null,"Kg",null,null,"Portions",null,null,"Pièce(s)",null,null,"litres"]
[]
[null,"Familles de convives :Mater = enfants Maternelles - Prim = enfants de l'enseignement Primaire - Adulte = sédentaire - Adulte + = travailleur de force - Seniors = nos Ainés - je classe les Adolescennts en Adultes +"]
[]
[null,"Adresse PC",{"$f":"CELL(\"nomfichier\")","v":"E:\\0-UPRT\\1-UPRT.FR-SITE-WEB\\ff-fiches-fabrications\\ff-fiches-fabrication-maj-08-2020\\[OK.Modèle.fiche.F.B2.2022-25.lignes.avec.MFC.xlsm]FF.12-Nota"}]
[null,"Mise à jour","du 03-01-2017 - Annule et remplace les versions précédentes"]
[null,"Adaptation : Joël Leboucher..UPRT \"Union des Personnels de la Restauration Territoriale\"  membre du réseau RESTAU'CO"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Prix D'ACHAT / Prix de VENTE"]
[null,null,"PRIX D'ACHAT",0.44,null,"PRIX D'ACHAT",100,null,"PRIX VENTE",115]
[null,null,"%  d'augmentation",60,null,"Augmentation",10,null,"PRIX D'ACHAT",133]
[null,null,"Augmentation",{"$f":"D247*D248%","v":0.26400000000000001},null,"PRIX VENTE",{"$f":"IF(G247=0,0,G247+G248)","v":110},null,"Augmentation",{"$f":"IF(J247=0,0,IF(J248=0,0,J247-J248))","v":-18}]
[null,null,"PRIX VENTE",{"$f":"((D247*D248)/100)+D247","v":0.70399999999999996},null,"%  d'augmentation",{"$f":"IF(G247=0,0,IF(ISBLANK(G247),0,(G248/G247)*100))","v":10},null,"%  d'augmentation",{"$f":"IF(J248=0,0,IF(ISBLANK(J248),0,(J249/J248)*100))","v":-13.533834586466165}]
[]
[null,null,"PRIX D'ACHAT",5.8970000000000002,null,"PRIX VENTE",9.64,null,"PRIX VENTE",100]
[null,null,"PRIX VENTE",9.64,null,"%  d'augmentation",63.5,null,"Augmentation",50]
[null,null,"Augmentation",{"$f":"IF(D252=0,0,IF(D253=0,0,D253-D252))","v":3.7430000000000003},null,"Augmentation",{"$f":"G252-G255","v":3.7439755351681958},null,"PRIX D'ACHAT",{"$f":"IF(J252=0,0,IF(ISBLANK(J252),0,J252-J253))","v":50}]
[null,null,"%  d'augmentation",{"$f":"IF(D252=0,0,IF(ISBLANK(D252),0,(D254/D252)*100))","v":63.472952348651859},null,"PRIX D'ACHAT",{"$f":"(G252/(100+G253)*100)","v":5.8960244648318048},null,"%  d'augmentation",{"$f":"IF(J254=0,0,IF(ISBLANK(J253),0,(J253/J254)*100))","v":100}]
[null,"Saisissez vos valeurs dans les cellules fond ivoire ou jaune"]
[]
[null,"Aide à la décision",null,null,null,null,null,null,null,"Pourcentages NET / BRUT"]
[null,null,"POIDS NET",1,null,"POIDS NET",10,null,"POIDS BRUT",10]
[null,null,"%  de PERTE",50,null,"POIDS de PERTE",2,null,"POIDS NET",3.2]
[null,null," POIDS DE PERTE",{"$f":"D262*D260%","v":1},null," POIDS BRUT",{"$f":"IF(G259=0,0,G259+G260)","v":12},null," POIDS DE PERTE",{"$f":"IF(J259=0,0,IF(J260=0,0,J259-J260))","v":6.8}]
[null,null,"POIDS BRUT",{"$f":"D259/(100-D260)*100","v":2},null,"%  de PERTE",{"$f":"IF(G259=0,0,G260/G261)","v":0.16666666666666666},null,"%  de PERTE",{"$f":"IF(J259=0,0,J261/J259)","v":0.67999999999999994}]
[]
[null,null,"POIDS NET",100,null,"POIDS BRUT",183,null,"POIDS BRUT",100]
[null,null,"POIDS BRUT",150,null,"%  de PERTE",40,null,"POIDS de PERTE",15]
[null,null," POIDS DE PERTE",{"$f":"IF(D264=0,0,IF(D265=0,0,D265-D264))","v":50},null," POIDS DE PERTE",{"$f":"G264*G265%","v":73.2},null," POIDS NET",{"$f":"IF(J264=0,0,IF(J265=0,0,J264-J265))","v":85}]
[null,null,"%  de PERTE",{"$f":"IF(D264=0,0,IF(D265=0,0,D266/D265))","v":0.33333333333333331},null,"POIDS NET",{"$f":"G264-G266","v":109.8},null,"%  de PERTE",{"$f":"IF(J264=0,0,IF(J265=0,0,J265/J264))","v":0.15}]
[null,"Saisissez vos valeurs dans les cellules fond ivoire ou jaune"]
[]
["RÉFLEXION SUR DES MODÈLE DE RÉPERTOIRE"]
[]
[]
[null,null,null,null,"Créer un ou plusieurs répertoires n'est pas tâche facile…à chacun de classer comme il le souhaite"]
[null,null,null,null,null,"par famille de produits"]
[null,null,null,null,null,"par technique"]
[null,null,null,null,null,"par ingrédients "]
[null,null,null,null,null,"etc...autant de possibilités que de façons de penser"]
[null,null,null,null,"vous pouvez utiliser un disque dur externe qui vous suivra partout"]
[]
[null,null,"Répertoire Patisserie",null,null,null,null,null,"Répertoire \"Postits\" Alpha par type de fabrication si possible"]
[]
[null,null,null,"Entremets"]
[null,null,null,"A",null,null,null,"C"]
[null,null,null,"B",null,null,null,null,"Cracker - (Pâte à)"]
[null,null,null,"C",null,null,null,null,"Cracker - (Poudre à)"]
[null,null,null,"D",null,null,null,"F"]
[null,null,null,"Etc…",null,null,null,null,"Fraises des bois dans leur jus"]
[null,null,null,null,null,null,null,"I"]
[null,null,null,"Tartes",null,null,null,null,"Insert Kappa fraise"]
[null,null,null,"A",null,null,null,"J"]
[null,null,null,"B",null,null,null,null,"Jus de fraise"]
[null,null,null,"C",null,null,null,"K"]
[null,null,null,"D",null,null,null,null,"Kappa fraise"]
[null,null,null,"Etc…",null,null,null,"S"]
[null,null,null,null,null,null,null,null,"Sorbet Avocat"]
[null,null,null,"Gros Gateaux",null,null,null,null,"Siphon Fraise"]
[null,null,null,"A",null,null,null,null,"Sauce Fraise"]
[null,null,null,"B",null,null,null,null,"Sirop à Crackers"]
[null,null,null,"C"]
[null,null,null,"Coussin Cœur St Valentin 2014 - François Perret - Journal du Patissier N° 292 page 40"]
[null,null,null,"D"]
[null,null,null,"Etc…"]
[]
[null,null,null,"Pièces individuelles"]
[null,null,null,"A"]
[null,null,null,"B"]
[null,null,null,"C"]
[null,null,null,"D"]
[null,null,null,"Etc…"]
[]
[]
[]
[null,"Utilitaire pour supprimer les espace vides dans une phrase"]
[null,"Collez votre texte dans la 1° cellule blanche"]
[null,"1° Cellule","•Contamination microbiologique (B)             •Multiplication des germes (B)      ",null,null,null,null,null,null,null,null,null,{"$f":"LEN(C315)","v":83},"Caractères"]
[null,"Récupérez votre texte dans la 2° cellule verte - cliquez sur Copier et pour coller dans votre document : collage spécial Valeur pour ne pas copier la formule"]
[]
[null,"2° Cellule",{"$f":"TRIM(C315)","v":"•Contamination microbiologique (B) •Multiplication des germes (B)"},null,null,null,null,null,null,null,null,null,{"$f":"LEN(C318)","v":65},"Caractères"]
[]
[null,"les pages Facebook  :",null," UPRT","ma page","le site"]
[]
[null,null,"Bonne utilisation et… à chacun d'améliorer et d'adapter ces documents"]