{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Stock initial","Devis_Gros","Devis_Détail","Facture_Gros","Facture_Détail","ETAT DE STOCK"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":4,"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":"Stock initial","index":0,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,3,5,4],[5,9,5,10],[16,3,16,4],[16,9,16,10],[6,9,6,11],[6,3,6,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[17,3,17,5],[17,9,17,11],[12,4,12,5],[8,10,8,11],[9,10,9,11],[10,10,10,11],[11,10,11,11]]}
[]
[]
[]
[]
[]
[null,null,null,"Informations de l'entreprise",null,null,null,null,null,"Dossiers d'enregistrement"]
[null,null,null,"Veuillez saisir les informations de l'entreprise",null,null,null,null,null,"Veuillez saisir adresses des dossiers d'enregistrement"]
[]
[null,null,null,"Nom ","Chambre Froide Race d'Abraham",null,null,null,null,"Devis en gros ","C:\\Users\\Lenovo\\OneDrive\\Images\\CHAMBRE FROIDE\\DEVIS EN GROS"]
[null,null,null,"Adresse ","7ème rue Limete-Industriel-Kinshasa",null,null,null,null,"Devis en détail","C:\\Users\\Lenovo\\OneDrive\\Images\\CHAMBRE FROIDE\\DEVIS EN DETAIL"]
[null,null,null,"Télé ",24382,null,null,null,null,"Facture en gros","C:\\Users\\Lenovo\\OneDrive\\Images\\CHAMBRE FROIDE\\FACTURE EN GROS"]
[null,null,null,"Email ","noella",null,null,null,null,"Facture en détail ","C:\\Users\\Lenovo\\OneDrive\\Images\\CHAMBRE FROIDE\\FACTURE EN DETAIL"]
[null,null,null,"Site "]
[]
[]
[]
[null,null,null,"Informations des produits en gros",null,null,null,null,null,"Information des produits en détails"]
[null,null,null,"Veuillez saisir les informations des produits",null,null,null,null,null,"Veuillez saisir les informations des clients"]
[]
[null,null,null,"DÉSIGNATION","REFERENCE","PRIX",null,null,null,"DESIGNATION","REFERENCE","PRIX"]
[null,null,null,"Iphone 13 Pro","S1",1119,null,null,null,"Nokia","N8",3000]
[null,null,null,"SAMSUNG GALAXY S22","S2",899,null,null,null,"SAMSUNG GALAXY S22","S2",899]
[null,null,null,"XIAOMI 12","S3",789,null,null,null,"XIAOMI 12","S3",789]
[null,null,null,"Drone DJI Mini 3 Pro","F1",999,null,null,null,"Drone DJI Mini 3 Pro","F1",999]
[null,null,null,"Canon EOS R7","F2",1449,null,null,null,"Canon EOS R7","F2",1449]
[null,null,null,"Canon EOS R8","F3",1479,null,null,null,"Canon EOS R8","F3",1479]
[null,null,null,"Nintendo Switch","C1",269,null,null,null,"Nintendo Switch","C1",269]
[null,null,null,"Console Sony PS5 ","C2",948,null,null,null,"Console Sony PS5 ","C2",948]
[null,null,null,"Oculus Quest 2","C3",349,null,null,null,"Oculus Quest 2","C3",349]
[null,null,null,"Xbox Series X","C4",679,null,null,null,"Xbox Series X","C4",679]
[null,null,null,"Xbox One 500","C5",599,null,null,null,"Xbox One 500","C5",599]
[null,null,null,"Samsung Galaxy Tab S8","T1",1169,null,null,null,"Samsung Galaxy Tab S8","T1",1169]
[null,null,null,"iPad Air 10,9","T2",979,null,null,null,"iPad Air 10,9","T2",979]
[null,null,null,"Huawei MatePad 11","T3",449,null,null,null,"Huawei MatePad 11","T3",449]
[null,null,null,"Apple AirPods 2 ","E1",149,null,null,null,"Apple AirPods 2 ","E1",149]
[null,null,null,"Sony True Wireless","E2",229,null,null,null,"Sony True Wireless","E2",229]
[null,null,null,"Jabra Elite Active ","E3",99,null,null,null,"Jabra Elite Active ","E3",99]
[null,null,null,"Sony WH1000XM4","C1",279,null,null,null,"Sony WH1000XM4","C1",279]
[null,null,null,"Marshall Major IV ","C2",134,null,null,null,"Marshall Major IV ","C2",134]
[null,null,null,"AirPods Max ","C3",579,null,null,null,"AirPods Max ","C3",579]
[null,null,null,"Galaxy Watch4","W1",269,null,null,null,"Galaxy Watch4","W1",269]
[null,null,null,"Apple Watch Series 7","W2",459,null,null,null,"Apple Watch Series 7","W2",459]
[null,null,null,"Huawei Watch GT2","W3",199,null,null,null,"Huawei Watch GT2","W3",199]

{"sheet":"Devis_Gros","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[34,6,34,8],[41,4,41,11],[37,4,39,11],[31,9,31,11],[32,9,32,11],[34,9,34,11],[28,9,28,11],[29,9,29,11],[30,9,30,11],[32,5,32,6],[19,9,19,11],[20,9,20,11],[21,9,21,11],[22,9,22,11],[23,9,23,11],[24,9,24,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[31,5,31,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[18,5,18,6],[18,9,18,11],[8,9,8,11],[9,9,9,11],[13,4,13,6],[14,4,14,6],[15,4,15,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2024-06-15"}]
[null,null,null,null,null,null,null,null,"N°:","D2024-06-0001"]
[]
[]
[]
[null,null,null,null,{"$f":"'Stock initial'!E9:F9","v":"Chambre Froide Race d'Abraham"}]
[null,null,null,null,{"$f":"'Stock initial'!E10:F10","v":"7ème rue Limete-Industriel-Kinshasa"}]
[null,null,null,null,{"$f":"'Stock initial'!E11:F11","v":24382}]
[]
[]
[null,null,null,null,"Référence","Désignation",null,"Prix","Quantité","Total"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_gros[],2,FALSE),\"\")","v":"S3"},"XIAOMI 12",null,{"$f":"IFERROR(VLOOKUP(F20,Produits_gros[],3,FALSE),\"\")","v":789},2,{"$f":"IFERROR(H20*I20,\"\")","v":1578}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H21*I21,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H22*I22,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[]
[null,null,null,null,null,null,"Montant Total :",null,null,{"$f":"SUM(J20:L33)","v":1578}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Des questions?\",CHAR(10),\"Envoyez-nous un E-mail à \",'Stock initial'!E12:F12,CHAR(10),\"Appelez-nous au \",'Stock initial'!E11:F11)","v":"Des questions?\nEnvoyez-nous un E-mail à noella\nAppelez-nous au 24382"}]
[]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE('Stock initial'!E10:F10)","v":"7ème rue Limete-Industriel-Kinshasa"}]

{"sheet":"Devis_Détail","index":2,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,4,39,11],[41,4,41,11],[31,5,31,6],[31,9,31,11],[32,5,32,6],[32,9,32,11],[34,6,34,8],[34,9,34,11],[28,5,28,6],[28,9,28,11],[29,5,29,6],[29,9,29,11],[30,5,30,6],[30,9,30,11],[25,5,25,6],[25,9,25,11],[26,5,26,6],[26,9,26,11],[27,5,27,6],[27,9,27,11],[22,5,22,6],[22,9,22,11],[23,5,23,6],[23,9,23,11],[24,5,24,6],[24,9,24,11],[19,5,19,6],[19,9,19,11],[20,5,20,6],[20,9,20,11],[21,5,21,6],[21,9,21,11],[8,9,8,11],[9,9,9,11],[13,4,13,6],[14,4,14,6],[15,4,15,6],[18,5,18,6],[18,9,18,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2024-06-15"}]
[null,null,null,null,null,null,null,null,"N°:","D2024-06-0005"]
[]
[]
[]
[null,null,null,null,{"$f":"'Stock initial'!E9:F9","v":"Chambre Froide Race d'Abraham"}]
[null,null,null,null,{"$f":"'Stock initial'!E10:F10","v":"7ème rue Limete-Industriel-Kinshasa"}]
[null,null,null,null,{"$f":"'Stock initial'!E11:F11","v":24382}]
[]
[]
[null,null,null,null,"Référence","Désignation",null,"Prix","Quantité","Total"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_détails[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H20*I20,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_détails[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H21*I21,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_détails[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H22*I22,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_détails[],3,FALSE),\"\")","v":""},null,""]
[]
[null,null,null,null,null,null,"Montant Total :",null,null,{"$f":"SUM(J20:L33)","v":0}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Des questions?\",CHAR(10),\"Envoyez-nous un E-mail à \",'Stock initial'!E12:F12,CHAR(10),\"Appelez-nous au \",'Stock initial'!E11:F11)","v":"Des questions?\nEnvoyez-nous un E-mail à noella\nAppelez-nous au 24382"}]
[]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE('Stock initial'!E10:F10)","v":"7ème rue Limete-Industriel-Kinshasa"}]

{"sheet":"Facture_Gros","index":3,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,4,39,11],[41,4,41,11],[31,5,31,6],[31,9,31,11],[32,5,32,6],[32,9,32,11],[34,6,34,8],[34,9,34,11],[28,5,28,6],[28,9,28,11],[29,5,29,6],[29,9,29,11],[30,5,30,6],[30,9,30,11],[25,5,25,6],[25,9,25,11],[26,5,26,6],[26,9,26,11],[27,5,27,6],[27,9,27,11],[22,5,22,6],[22,9,22,11],[23,5,23,6],[23,9,23,11],[24,5,24,6],[24,9,24,11],[19,5,19,6],[19,9,19,11],[20,5,20,6],[20,9,20,11],[21,5,21,6],[21,9,21,11],[8,9,8,11],[9,9,9,11],[13,4,13,6],[14,4,14,6],[15,4,15,6],[18,5,18,6],[18,9,18,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2024-06-15"}]
[null,null,null,null,null,null,null,null,"N°:","F2024-06-0001"]
[]
[]
[]
[null,null,null,null,{"$f":"'Stock initial'!E9:F9","v":"Chambre Froide Race d'Abraham"}]
[null,null,null,null,{"$f":"'Stock initial'!E10:F10","v":"7ème rue Limete-Industriel-Kinshasa"}]
[null,null,null,null,{"$f":"'Stock initial'!E11:F11","v":24382}]
[]
[]
[null,null,null,null,"Référence","Désignation",null,"Prix","Quantité","Total"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H20*I20,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H21*I21,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H22*I22,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[]
[null,null,null,null,null,null,"Montant Total :",null,null,{"$f":"SUM(J20:L33)","v":0}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Des questions?\",CHAR(10),\"Envoyez-nous un E-mail à \",'Stock initial'!E12:F12,CHAR(10),\"Appelez-nous au \",'Stock initial'!E11:F11)","v":"Des questions?\nEnvoyez-nous un E-mail à noella\nAppelez-nous au 24382"}]
[]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE('Stock initial'!E10:F10)","v":"7ème rue Limete-Industriel-Kinshasa"}]

{"sheet":"Facture_Détail","index":4,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,4,39,11],[41,4,41,11],[31,5,31,6],[31,9,31,11],[32,5,32,6],[32,9,32,11],[34,6,34,8],[34,9,34,11],[28,5,28,6],[28,9,28,11],[29,5,29,6],[29,9,29,11],[30,5,30,6],[30,9,30,11],[25,5,25,6],[25,9,25,11],[26,5,26,6],[26,9,26,11],[27,5,27,6],[27,9,27,11],[22,5,22,6],[22,9,22,11],[23,5,23,6],[23,9,23,11],[24,5,24,6],[24,9,24,11],[19,5,19,6],[19,9,19,11],[20,5,20,6],[20,9,20,11],[21,5,21,6],[21,9,21,11],[8,9,8,11],[9,9,9,11],[13,4,13,6],[14,4,14,6],[15,4,15,6],[18,5,18,6],[18,9,18,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2024-06-15"}]
[null,null,null,null,null,null,null,null,"N°:","F2024-06-0002"]
[]
[]
[]
[null,null,null,null,{"$f":"'Stock initial'!E9:F9","v":"Chambre Froide Race d'Abraham"}]
[null,null,null,null,{"$f":"'Stock initial'!E10:F10","v":"7ème rue Limete-Industriel-Kinshasa"}]
[null,null,null,null,{"$f":"'Stock initial'!E11:F11","v":24382}]
[]
[]
[null,null,null,null,"Référence","Désignation",null,"Prix","Quantité","Total"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_détails[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F20,Produits_détails[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H20*I20,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F21,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H21*I21,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F22,Produits_gros[],3,FALSE),\"\")","v":""},null,{"$f":"IFERROR(H22*I22,\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F23,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F24,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F25,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F26,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F27,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F28,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F29,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F30,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F31,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F32,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(F33,Produits_gros[],3,FALSE),\"\")","v":""},null,""]
[]
[null,null,null,null,null,null,"Montant Total :",null,null,{"$f":"SUM(J20:L33)","v":0}]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Des questions?\",CHAR(10),\"Envoyez-nous un E-mail à \",'Stock initial'!E12:F12,CHAR(10),\"Appelez-nous au \",'Stock initial'!E11:F11)","v":"Des questions?\nEnvoyez-nous un E-mail à noella\nAppelez-nous au 24382"}]
[]
[]
[]
[null,null,null,null,{"$f":"CONCATENATE('Stock initial'!E10:F10)","v":"7ème rue Limete-Industriel-Kinshasa"}]

{"sheet":"ETAT DE STOCK","index":5,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,3,15,4],[15,10,15,11],[16,3,16,6],[16,10,16,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Informations des produits en gros",null,null,null,null,null,null,"Information des produits en détails"]
[null,null,null,"Veuillez saisir les informations des produits",null,null,null,null,null,null,"Veuillez saisir les informations des clients"]
[]
[null,null,null,"DÉSIGNATION","REFERENCE","QUANTITE","PRIX D'ACHAT","REVENUS","OBS. STOCK","ETAT",null,null,null,"DESIGNATION","REFERENCE","QUANTITE","PRIX D'ACHAT","REVENUS","OBS. STOCK","ETAT"]
[null,null,null,"Iphone 13 Pro","S1",12,1119,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I20","v":12},null,null,null,null,"Nokia","N8",12,3000]
[null,null,null,"SAMSUNG GALAXY S22","S2",54,899,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I21","v":54},null,null,null,null,"SAMSUNG GALAXY S22","S2",54,899]
[null,null,null,"XIAOMI 12","S3",25,789,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I22","v":25},null,null,null,null,"XIAOMI 12","S3",25,789]
[null,null,null,"Drone DJI Mini 3 Pro","F1",98,999,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I23","v":98},null,null,null,null,"Drone DJI Mini 3 Pro","F1",98,999]
[null,null,null,"Canon EOS R7","F2",56,1449,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I24","v":56},null,null,null,null,"Canon EOS R7","F2",56,1449]
[null,null,null,"Canon EOS R8","F3",32,1479,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I25","v":32},null,null,null,null,"Canon EOS R8","F3",32,1479]
[null,null,null,"Nintendo Switch","C1",36,269,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I26","v":36},null,null,null,null,"Nintendo Switch","C1",36,269]
[null,null,null,"Console Sony PS5 ","C2",34,948,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I27","v":34},null,null,null,null,"Console Sony PS5 ","C2",34,948]
[null,null,null,"Oculus Quest 2","C3",35,349,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I28","v":35},null,null,null,null,"Oculus Quest 2","C3",35,349]
[null,null,null,"Xbox Series X","C4",35,679,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I29","v":35},null,null,null,null,"Xbox Series X","C4",35,679]
[null,null,null,"Xbox One 500","C5",25,599,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I30","v":25},null,null,null,null,"Xbox One 500","C5",25,599]
[null,null,null,"Samsung Galaxy Tab S8","T1",12,1169,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I31","v":12},null,null,null,null,"Samsung Galaxy Tab S8","T1",12,1169]
[null,null,null,"iPad Air 10,9","T2",25,979,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I32","v":25},null,null,null,null,"iPad Air 10,9","T2",25,979]
[null,null,null,"Huawei MatePad 11","T3",85,449,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I33","v":85},null,null,null,null,"Huawei MatePad 11","T3",85,449]
[null,null,null,"Apple AirPods 2 ","E1",100,149,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I34","v":100},null,null,null,null,"Apple AirPods 2 ","E1",100,149]
[null,null,null,"Sony True Wireless","E2",123,229,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I35","v":123},null,null,null,null,"Sony True Wireless","E2",123,229]
[null,null,null,"Jabra Elite Active ","E3",36,99,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I36","v":36},null,null,null,null,"Jabra Elite Active ","E3",36,99]
[null,null,null,"Sony WH1000XM4","C1",65,279,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I37","v":65},null,null,null,null,"Sony WH1000XM4","C1",65,279]
[null,null,null,"Marshall Major IV ","C2",24,134,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I38","v":24},null,null,null,null,"Marshall Major IV ","C2",24,134]
[null,null,null,"AirPods Max ","C3",14,579,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I39","v":14},null,null,null,null,"AirPods Max ","C3",14,579]
[null,null,null,"Galaxy Watch4","W1",15,269,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I40","v":15},null,null,null,null,"Galaxy Watch4","W1",15,269]
[null,null,null,"Apple Watch Series 7","W2",145,459,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I41","v":145},null,null,null,null,"Apple Watch Series 7","W2",145,459]
[null,null,null,"Huawei Watch GT2","W3",85,199,null,{"$f":"Produits_gros4[[#This Row],[QUANTITE]]-Facture_Gros!I42","v":85},null,null,null,null,"Huawei Watch GT2","W3",85,199]