{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Saisie Ingrédients","Macérats","Poudres","Parfums-HE","Huiles et BV","Additifs","Poudres Synthé.","Ajouts","Recettes","MO Savons","MO Cosmét.","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Saisie Ingrédients","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Référence Interne :"]
[null,"NOM :"]
[null,"INCI :"]
[null,"Fournisseur :"]
[null,"N° de Lot :"]
[null,"Quantité Reçue (en g) :"]
[null,"DLUO/DDM :"]
[null,"Date de Réception :"]
[null,"Bulletin d'Analyses :"]
[null,"Seuil d'alerte : "]

{"sheet":"Macérats","index":1,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) : ","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]

{"sheet":"Poudres","index":2,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) : ","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]

{"sheet":"Parfums-HE","index":3,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'alerte (en g) : ","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]
[null,2000,"Lavande","Lavandula Officinalis Flower Oil","LANDEMA","Test2000",1000,"2025-12-31","2025-01-01","Oui"]

{"sheet":"Huiles et BV","index":4,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) :","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]
[null,3000,"Coco","Coco","ACTIBIO","Test222",25000,"2026-12-31","2025-01-01","Oui"]

{"sheet":"Additifs","index":5,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) :","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]
[null,4000,"Eau","Aqua","SAUR","Test333",10000,"2025-12-31","2025-01-01","Oui"]

{"sheet":"Poudres Synthé.","index":6,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) : ","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]
[null,5000,"Soude","Hydroxyde de sodium","INNOVYN","Test444",25000,"2026-12-31","2025-01-01","Oui"]

{"sheet":"Ajouts","index":7,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Référence Interne :","NOM :","INCI :","Fournisseur :","N° de Lot : ","Quantité Reçue (en g) :","DLUO/DDM : ","Date de Réception : ","Bulletin d'Analyses : ","Seuil d'Alerte (en g) : ","Quantité Utilisée (en g) :","Recette :","Quantité Restante (en g) :"]

{"sheet":"Recettes","index":8,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[9,0,9,3],[19,0,19,3],[57,0,57,3],[44,0,44,3],[31,0,31,3],[60,5,60,8],[1,5,1,8],[0,5,0,8],[20,5,20,8],[11,5,11,8],[29,5,29,8],[39,5,39,8],[50,5,50,8]]}
["Savons",null,null,null,null,"Cosmétiques"]
["SAVON TOUT OLIVE",null,null,null,null,"SHAMPOING POUR TOUS"]
["Réf. Int.","Ingrédients","Pourcentage","Poids théorique (en g)",null,"Réf. Int.","Ingrédients","Pourcentage","Poids théorique (en g)"]
[2,{"$f":"IF(A4=\"\",\"\",IFERROR(VLOOKUP(A4,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"D4/D8","v":0.55440055440055436},800,null,5001,{"$f":"IF(F4=\"\",\"\",IFERROR(VLOOKUP(F4,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I4/I10","v":0.4},40]
[3000,{"$f":"IF(A5=\"\",\"\",IFERROR(VLOOKUP(A5,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"D5/D8","v":0.13860013860013859},200,null,1004,{"$f":"IF(F5=\"\",\"\",IFERROR(VLOOKUP(F5,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I5/I10","v":0.2},20]
[4000,{"$f":"IF(A6=\"\",\"\",IFERROR(VLOOKUP(A6,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"D6/D8","v":0.20790020790020791},300,null,4002,{"$f":"IF(F6=\"\",\"\",IFERROR(VLOOKUP(F6,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I6/I10","v":0.15},15]
[5000,{"$f":"IF(A7=\"\",\"\",IFERROR(VLOOKUP(A7,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"D7/D8","v":9.90990990990991E-2},143,null,4004,{"$f":"IF(F7=\"\",\"\",IFERROR(VLOOKUP(F7,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I7/I10","v":0.15},15]
[" TOTAL",null,{"$f":" SUM(C4:C7)","v":0.99999999999999989},{"$f":"SUM(D4:D7)","v":1443},null,3006,{"$f":"IF(F8=\"\",\"\",IFERROR(VLOOKUP(F8,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I8/I10","v":7.0000000000000007E-2},7]
[null,null,null,null,null,3010,{"$f":"IF(F9=\"\",\"\",IFERROR(VLOOKUP(F9,Tingr[],2,0),\"?\"))","v":"?"},{"$f":"I9/I10","v":0.03},3]
[null,null,null,null,null," TOTAL",null,{"$f":"SUM(H4:H9)","v":1.0000000000000002},{"$f":"SUM(I4:I9)","v":100}]

{"sheet":"MO Savons","index":9,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,11,10,11],[9,7,10,7],[1,2,1,10],[9,6,10,6],[9,8,10,8],[9,9,10,9],[9,10,10,10]]}
[]
[null,null,"FICHE DE FABRICATION D'UN SAVON"]
[]
[null,null,"Date de fabrication : "]
[null,null,"Code interne : ",null,{"$f":"IF(E18=\"SAVON_TOUT_OLIVE\",\"TO\",IF(E18=\"SAVON_ROSE\",\"SR\",IF(E18=\"SAVON_PETIT_COCO\",\"PC\",IF(E18=\"SAVON_CHOCO_VANI\",\"CV\",IF(E18=\"SAVON_CAROTTE\",\"CAR\",\"CAN\")))))","v":"TO"}]
[null,null,"Numéro de lot : ",null,23]
[null,null,"Température : "]
[null,null,"Hygrométrie : "]
[null,null,"Autre : "]
[null,null,"Coefficient multiplicateur : ",null,null,null,"Réf. Int.","Ingrédients","Pourcentage","Poids théorique (en g)","Pesée réelle (en g)","Lot/DLU"]
[null,null,"Moules utilisés : "]
[null,null,"Matériels utilisés : ",null,null,null,{"$f":"INDIRECT($E$18)","v":2},"?",0.55440055440055436,800,805,"Test111"]
[null,null,"Liquide : ",null,null,null,3000,"?",0.13860013860013859,200,205,"Test222"]
[null,null,"Température corps gras : ",null,null,null,4000,"?",0.20790020790020791,300,295,"Test333"]
[null,null,"Température soude : ",null,null,null,5000,"?",9.90990990990991E-2,143,140,"Test444"]
[null,null,"Additifs ajoutés : ",null,null,null," TOTAL",0,0.99999999999999989,1443]
[null,null,"Surgras : ",null,0.08]
[null,null,"Recette : ",null,"SAVON_TOUT_OLIVE"]
[null,null,"Poids du lot : "]
[null,null,"Quantité de savons : "]
[null,null,"Observations : "]
[null,null,"Contrôle olfactif : "]
[null,null,"Contrôle visuel : "]
[null,null,"pH : "]
[null,null,"Date de mise en cure : "]
[null,null,"Date de sortie de cure prévue : "]

{"sheet":"MO Cosmét.","index":10,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,11,10,11],[1,2,1,10],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10]]}
[]
[null,null,"FICHE DE FABRICATION D'UN COSMETIQUE"]
[]
[null,null,"Date de fabrication : "]
[null,null,"Code interne : ",null,{"$f":"IF(E14=\"SHAMPOING_POUR_TOUS\",\"ShCN\",IF(E14=\"BAUME_A_LEVRES\",\"BAUL\",IF(E14=\"BAUME_MAINS_PIEDS\",\"BMP\",IF(E14=\"DENTIFRICE\",\"DENT\",IF(E14=\"DEODORANT_MENTHE_CITRON\",\"DeoMC\",IF(E14=\"DEODORANT_THE_VERT\",\"DeoTV\",\"FC\"))))))","v":"ShCN"}]
[null,null,"Numéro de lot : ",null,31]
[null,null,"Température : "]
[null,null,"Hygrométrie : "]
[null,null,"Autre : "]
[null,null,"Moules utilisés : ",null,null,null,"Réf. Int.","Ingrédients","Pourcentage","Poids théorique (en g)","Pesée réelle (en g)","Lot/DLU"]
[null,null,"Matériels utilisés : "]
[null,null,"Coefficient multiplicateur : ",null,null,null,{"$f":"INDIRECT($E$14)","v":5001},"?",0.4,40,35,"Test511"]
[null,null,"Contenants utilisés : ",null,null,null,1004,"?",0.2,20,25,"Test512"]
[null,null,"Recette : ",null,"SHAMPOING_POUR_TOUS",null,4002,"?",0.15,15,12,"Test513"]
[null,null,"Poids total de la préparation : ",null,null,null,4004,"?",0.15,15,20,"Test514"]
[null,null,"Quantité : ",null,null,null,3006,"?",7.0000000000000007E-2,7,6,"Test515"]
[null,null,"Contrôle olfactif : ",null,null,null,3010,"?",0.03,3,5,"Test516"]
[null,null,"Contrôle visuel : ",null,null,null," TOTAL",0,1.0000000000000002,100]
[null,null,"Observations : "]
[null,null,"Autres : "]

{"sheet":"Data","index":11,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[0,6,1,6]]}
["SAVONS",null,null,"COSMETIQUES",null,null,"Fournisseurs",null,"INGREDIENTS","Colonne1","Colonne2","Colonne3"]
["Recettes","Code Interne",null,"Recettes","Code Interne",null,null,null,"Réf. Int.","Nom","INCI","Seuil d'alerte (en g)"]
["SAVON_TOUT_OLIVE","TO",null,"SHAMPOING_POUR_TOUS","ShCN",null,"ACTIBIO",null,"0000","Camomille","Matricaria Chamomilla Flower Extract in Olea Europaea Fruit Oil",2000]
["SAVON_ROSE","SR",null,"BAUME_A_LEVRES","BAUL",null,"ARCANE",null,"0001","Lauriers","Laurus Nobilis in Olea Europaea Fruit Oil",2000]
["SAVON_PETIT_COCO","PC",null,"BAUME_MAINS_PIEDS","BMP",null,"AROMAZONE",null,"0002","Vanille","Vanilla Planifolia Fruit Extract in Olea Europaea Fruit Oil",2000]
["SAVON_CHOCO_VANI","CV",null,"DENTIFRICE","DENT",null,"BIORIGINS",null,"0003","Calendula"," Calendula Officinalis Flower Extract in Vitis Vinifera Seed Oil",2000]
["SAVON_CAROTTE","CAR",null,"DEODORANT_MENTHE_CITRON","DeoMC",null,"INNOVYN",null,"1000","Argile Rose","Pink Clay",50]
["SAVON_CANNELE","CAN",null,"DEODORANT_THE_VERT","DeoTV",null,"JMVANILLE",null,"1001","Bicarbonate de Soude","Sodium Bicarbonate"]
[null,null,null,"FONDANT_POUR_LE_CORPS","FC",null,"LANDEMA",null,"1002","Charbon Végétal","Charcaol Powder",10]
[null,null,null,null,null,null,"LES_SAVONS_DE_NANOU",null,"1003","Cacao","Theobroma Cacao Fruit Powder",50]
[null,null,null,null,null,null,"MYSTIC_MOMENT",null,"1004","Rhassoul","Moroccan Lava Clay",2000]
[null,null,null,null,null,null,"NAISSANCE",null,"1005","Alun","Potasium Alum",100]
[null,null,null,null,null,null,"NESTLE",null,"1006","Kaolin","Kaolin",1000]
[null,null,null,null,null,null,"OKA_COSMETICS",null,"1007","Carbonate de Calcium","Calcium Carbonate",100]
[null,null,null,null,null,null,"PAQUITO",null,"1008","Argile Verte","Green Clay"]
[null,null,null,null,null,null,"SAUR",null,"1009","Cristaux de Menthe","Menthol"]
[null,null,null,null,null,null,"SUPER_U",null,"2000","Lavande","Lavandula Officinalis Flower Oil",50]
[null,null,null,null,null,null,null,null,"2001","Cèdres","Cedrus Atlantica Bark Oil",50]
[null,null,null,null,null,null,null,null,"2002","Litsee Citronnée","Litsea Cubeba May Chang Oil",50]
[null,null,null,null,null,null,null,null,"2003","Patchouli","Pogostemon Cablin Leaf Oil",50]
[null,null,null,null,null,null,null,null,"2004","Geranium Bourbon","Geranium Bourbon Essential Oil",50]
[null,null,null,null,null,null,null,null,"2005","Camomille","Anthemis Nobilis Flower Oil",50]
[null,null,null,null,null,null,null,null,"2006","Mandarine Verte","Citrus Reticulata Peel Oil",50]
[null,null,null,null,null,null,null,null,"2007","Gingembre","Zingiber Officinale Root Oil",50]
[null,null,null,null,null,null,null,null,"2008","Palmarosa","Cymbopogon Martini Oil",50]
[null,null,null,null,null,null,null,null,"2009","Orange","Citrus Sinensis Peel Oil Expressed",50]
[null,null,null,null,null,null,null,null,"2010","Menthe Poivrée","Mentha Piperita Oil",50]
[null,null,null,null,null,null,null,null,"2011","Ylang Ylang","Cananga Odorata Flower Oil",50]
[null,null,null,null,null,null,null,null,"2012","Citron","Citrus Lemon Peel Oil",50]
[null,null,null,null,null,null,null,null,"2013","Thé Vert","Camellia Sinensis Leaf Extract",50]
[null,null,null,null,null,null,null,null,"3000","Coco","Cocos Nucifera Seed Butter",5000]
[null,null,null,null,null,null,null,null,"3001","Karité","Butyspermum Parkii Butter",5000]
[null,null,null,null,null,null,null,null,"3002","Macadamia","Macadamia Ternifolia Seed Oil",5000]
[null,null,null,null,null,null,null,null,"3003","Olive","Olea Europea Fruit Oil",5000]
[null,null,null,null,null,null,null,null,"3004","Raisins","Vitis Vinifera Seed Oil",5000]
[null,null,null,null,null,null,null,null,"3005","Sésame","Sesamum Communis Seed Oil",5000]
[null,null,null,null,null,null,null,null,"3006","Ricin","Ricinius Communis Seed Oil",5000]
[null,null,null,null,null,null,null,null,"3007","Blé","Triticum Vulgare Germ Oil",5000]
[null,null,null,null,null,null,null,null,"3008","Colza","Brassica Campestris Seed Oil",5000]
[null,null,null,null,null,null,null,null,"3009","Cire d'Abeilles","Cera Alba",5000]
[null,null,null,null,null,null,null,null,"3010","Cameline","Camelina Sativa Seed Oil",5000]
[null,null,null,null,null,null,null,null,"4000","Eau","Aqua",0]
[null,null,null,null,null,null,null,null,"4001","Jus de Carottes","Daucus Carotta Sativa Juice",1000]
[null,null,null,null,null,null,null,null,"4002","Gel d'Aloe Vera","Aloe Barbadensis Leaf Juice",2000]
[null,null,null,null,null,null,null,null,"4003","Crème de Coco","Coco Nucifera Fruit",1000]
[null,null,null,null,null,null,null,null,"4004","Glycérine","Glycerin",2000]
[null,null,null,null,null,null,null,null,"5000","Soude","Sodium Hydroxyde",5000]
[null,null,null,null,null,null,null,null,"5001","SCI","Sodium Cocoyl Isethionate",2000]
[null,null,null,null,null,null,null,null,"6000","Fleurs Camomilles","Chamomilla Matricaria Flower Extract",0]
[null,null,null,null,null,null,null,null,"6001","Fleurs de Soucis","Calendula Officinalis Flower Extract",0]
[null,null,null,null,null,null,null,null,"6002","Fleurs de Lauriers","Laurus Nobilis Extract",0]
[null,null,null,null,null,null,null,null,"6003","Gousses de Vanille","Vanilla Planifolia Fruit ",0]