{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Tableau de bord","Facture","Stock","Historique factures","Clients","TVA"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Tableau de bord","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,0,13,1],[15,0,15,1],[0,0,0,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[7,0,7,2]]}
["Nouveau client",null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
["Nom",null,null,null,"janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre"]
["Prénom",null,null,"Total / mois",{"$f":"SUMIF('Historique factures'!$E:$E,E1,'Historique factures'!$D:$D)","v":75.558000000000007},{"$f":"SUMIF('Historique factures'!$E:$E,F1,'Historique factures'!$D:$D)","v":197.68600000000001},{"$f":"SUMIF('Historique factures'!$E:$E,G1,'Historique factures'!$D:$D)","v":168.79999999999998},{"$f":"SUMIF('Historique factures'!$E:$E,H1,'Historique factures'!$D:$D)","v":0},{"$f":"SUMIF('Historique factures'!$E:$E,I1,'Historique factures'!$D:$D)","v":1296.7919999999999},{"$f":"SUMIF('Historique factures'!$E:$E,J1,'Historique factures'!$D:$D)","v":901.92000000000007},{"$f":"SUMIF('Historique factures'!$E:$E,K1,'Historique factures'!$D:$D)","v":5930.2100000000009},{"$f":"SUMIF('Historique factures'!$E:$E,L1,'Historique factures'!$D:$D)","v":0},{"$f":"SUMIF('Historique factures'!$E:$E,M1,'Historique factures'!$D:$D)","v":0},{"$f":"SUMIF('Historique factures'!$E:$E,N1,'Historique factures'!$D:$D)","v":0},{"$f":"SUMIF('Historique factures'!$E:$E,O1,'Historique factures'!$D:$D)","v":0},{"$f":"SUMIF('Historique factures'!$E:$E,P1,'Historique factures'!$D:$D)","v":0}]
["Adresse"]
["Code Postal"]
["Ville"]
["Tél"]
[{"$f":"COUNTIF(Clients!A:A,CONCATENATE(B2,\" \",B3))","v":0}]
["Menu"]
["Facture"]
["Stock"]
["Historique"]
["Clients"]
["TVA"]
[]
["Récapitulatif"]
["Montant Max",{"$f":"MAX(Clients!I:I)","v":6823.0480000000007}]
["Le meilleur client",{"$f":"VLOOKUP(B17,Clients!I:J,2,0)","v":"Lopez Eric"}]
["Montant Min",{"$f":"MIN('Historique factures'!D:D)","v":39.457000000000001}]
["Montant Moyen",{"$f":"AVERAGE('Historique factures'!D:D)","v":1071.3707500000003}]
["Montant Median",{"$f":"MEDIAN('Historique factures'!D:D)","v":281.0915}]
["Montant Total",{"$f":"SUM('Historique factures'!D:D)","v":8570.9660000000022}]
["Nombre de facture",{"$f":"COUNT('Historique factures'!D:D)","v":8}]

{"sheet":"Facture","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[44,3,44,5],[6,0,6,1],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5],[4,4,4,6],[7,0,7,6],[0,0,0,2],[0,4,0,6],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
["Entreprise Fictive\n15 av. test 75015\nParis",null,null,null,{"$f":"TODAY()","v":"2019-11-27"}]
[]
[null,null,null,null,{"$f":"IF(E2=\"\",\"\",VLOOKUP(E2,Clients!A:G,4,0))","v":""}]
[null,null,null,null,{"$f":"IF(E2=\"\",\"\",CONCATENATE(VLOOKUP(E2,Clients!A:G,5,0),\" \",VLOOKUP(E2,Clients!A:G,6,0)))","v":""}]
[null,null,null,null,{"$f":"IF(E2=\"\",\"\",VLOOKUP(E2,Clients!A:G,7,0))","v":""}]
[]
["N° de Facture"]
[{"$f":"IF(MIN(Stock!I:I)<0,\"Attention !!! Rupture de stock\",\"\")","v":""}]
["Ref.","Quant.","Désignation","TVA","P.U ht","P.U ttc","Total ttc","total ht","tva"]
[null,{"$f":"IF(A10=\"\",\"\",1)","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Stock!A:B,2,0))","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Stock!A:C,3,0))","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Stock!A:D,4,0))","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(D10,TVA!A:B,2,0)*E10+E10)","v":""},{"$f":"IF(A10=\"\",\"\",B10*F10)","v":""},{"$f":"IF(A10=\"\",\"\",B10*E10)","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(D10,TVA!A:B,2,0)*E10)","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",1)","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Stock!A:B,2,0))","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Stock!A:C,3,0))","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Stock!A:D,4,0))","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11+E11)","v":""},{"$f":"IF(A11=\"\",\"\",B11*F11)","v":""},{"$f":"IF(A11=\"\",\"\",B11*E11)","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(D11,TVA!A:B,2,0)*E11)","v":""}]
[null,"",{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Stock!A:B,2,0))","v":""},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Stock!A:C,3,0))","v":""},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Stock!A:D,4,0))","v":""},{"$f":"IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12+E12)","v":""},"","",{"$f":"IF(A12=\"\",\"\",VLOOKUP(D12,TVA!A:B,2,0)*E12)","v":""}]
[null,"",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Stock!A:B,2,0))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Stock!A:C,3,0))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Stock!A:D,4,0))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13+E13)","v":""},"","",{"$f":"IF(A13=\"\",\"\",VLOOKUP(D13,TVA!A:B,2,0)*E13)","v":""}]
[null,"",{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Stock!A:B,2,0))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Stock!A:C,3,0))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Stock!A:D,4,0))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14+E14)","v":""},"","",{"$f":"IF(A14=\"\",\"\",VLOOKUP(D14,TVA!A:B,2,0)*E14)","v":""}]
[null,"",{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Stock!A:B,2,0))","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Stock!A:C,3,0))","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Stock!A:D,4,0))","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15+E15)","v":""},"","",{"$f":"IF(A15=\"\",\"\",VLOOKUP(D15,TVA!A:B,2,0)*E15)","v":""}]
[null,"",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Stock!A:B,2,0))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Stock!A:C,3,0))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Stock!A:D,4,0))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(D16,TVA!A:B,2,0)*E16+E16)","v":""},"","",{"$f":"IF(A16=\"\",\"\",VLOOKUP(D16,TVA!A:B,2,0)*E16)","v":""}]
[null,"",{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Stock!A:B,2,0))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Stock!A:C,3,0))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Stock!A:D,4,0))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(D17,TVA!A:B,2,0)*E17+E17)","v":""},"","",{"$f":"IF(A17=\"\",\"\",VLOOKUP(D17,TVA!A:B,2,0)*E17)","v":""}]
[null,"",{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Stock!A:B,2,0))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Stock!A:C,3,0))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Stock!A:D,4,0))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(D18,TVA!A:B,2,0)*E18+E18)","v":""},"","",{"$f":"IF(A18=\"\",\"\",VLOOKUP(D18,TVA!A:B,2,0)*E18)","v":""}]
[null,"",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Stock!A:B,2,0))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Stock!A:C,3,0))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Stock!A:D,4,0))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(D19,TVA!A:B,2,0)*E19+E19)","v":""},"","",{"$f":"IF(A19=\"\",\"\",VLOOKUP(D19,TVA!A:B,2,0)*E19)","v":""}]
[null,"",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Stock!A:B,2,0))","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Stock!A:C,3,0))","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Stock!A:D,4,0))","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(D20,TVA!A:B,2,0)*E20+E20)","v":""},"","",{"$f":"IF(A20=\"\",\"\",VLOOKUP(D20,TVA!A:B,2,0)*E20)","v":""}]
[null,"",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Stock!A:B,2,0))","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Stock!A:C,3,0))","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Stock!A:D,4,0))","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(D21,TVA!A:B,2,0)*E21+E21)","v":""},"","",{"$f":"IF(A21=\"\",\"\",VLOOKUP(D21,TVA!A:B,2,0)*E21)","v":""}]
[null,"",{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Stock!A:B,2,0))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Stock!A:C,3,0))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Stock!A:D,4,0))","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(D22,TVA!A:B,2,0)*E22+E22)","v":""},"","",{"$f":"IF(A22=\"\",\"\",VLOOKUP(D22,TVA!A:B,2,0)*E22)","v":""}]
[null,"",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Stock!A:B,2,0))","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Stock!A:C,3,0))","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Stock!A:D,4,0))","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(D23,TVA!A:B,2,0)*E23+E23)","v":""},"","",{"$f":"IF(A23=\"\",\"\",VLOOKUP(D23,TVA!A:B,2,0)*E23)","v":""}]
[null,"",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Stock!A:B,2,0))","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Stock!A:C,3,0))","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Stock!A:D,4,0))","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(D24,TVA!A:B,2,0)*E24+E24)","v":""},"","",{"$f":"IF(A24=\"\",\"\",VLOOKUP(D24,TVA!A:B,2,0)*E24)","v":""}]
[null,"",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Stock!A:B,2,0))","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Stock!A:C,3,0))","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Stock!A:D,4,0))","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(D25,TVA!A:B,2,0)*E25+E25)","v":""},"","",{"$f":"IF(A25=\"\",\"\",VLOOKUP(D25,TVA!A:B,2,0)*E25)","v":""}]
[null,"",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Stock!A:B,2,0))","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Stock!A:C,3,0))","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Stock!A:D,4,0))","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(D26,TVA!A:B,2,0)*E26+E26)","v":""},"","",{"$f":"IF(A26=\"\",\"\",VLOOKUP(D26,TVA!A:B,2,0)*E26)","v":""}]
[null,"",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Stock!A:B,2,0))","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Stock!A:C,3,0))","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Stock!A:D,4,0))","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP(D27,TVA!A:B,2,0)*E27+E27)","v":""},"","",{"$f":"IF(A27=\"\",\"\",VLOOKUP(D27,TVA!A:B,2,0)*E27)","v":""}]
[null,{"$f":"IF(A28=\"\",\"\",1)","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Stock!A:B,2,0))","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Stock!A:C,3,0))","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Stock!A:D,4,0))","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP(D28,TVA!A:B,2,0)*E28+E28)","v":""},"","",{"$f":"IF(A28=\"\",\"\",VLOOKUP(D28,TVA!A:B,2,0)*E28)","v":""}]
[null,"",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Stock!A:B,2,0))","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Stock!A:C,3,0))","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Stock!A:D,4,0))","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(D29,TVA!A:B,2,0)*E29+E29)","v":""},"","",{"$f":"IF(A29=\"\",\"\",VLOOKUP(D29,TVA!A:B,2,0)*E29)","v":""}]
[null,"",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Stock!A:B,2,0))","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Stock!A:C,3,0))","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Stock!A:D,4,0))","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP(D30,TVA!A:B,2,0)*E30+E30)","v":""},"","",{"$f":"IF(A30=\"\",\"\",VLOOKUP(D30,TVA!A:B,2,0)*E30)","v":""}]
[null,"",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Stock!A:B,2,0))","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Stock!A:C,3,0))","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Stock!A:D,4,0))","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP(D31,TVA!A:B,2,0)*E31+E31)","v":""},"","",{"$f":"IF(A31=\"\",\"\",VLOOKUP(D31,TVA!A:B,2,0)*E31)","v":""}]
[null,"",{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Stock!A:B,2,0))","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Stock!A:C,3,0))","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Stock!A:D,4,0))","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP(D32,TVA!A:B,2,0)*E32+E32)","v":""},"","",{"$f":"IF(A32=\"\",\"\",VLOOKUP(D32,TVA!A:B,2,0)*E32)","v":""}]
[null,"",{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Stock!A:B,2,0))","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Stock!A:C,3,0))","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Stock!A:D,4,0))","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP(D33,TVA!A:B,2,0)*E33+E33)","v":""},"","",{"$f":"IF(A33=\"\",\"\",VLOOKUP(D33,TVA!A:B,2,0)*E33)","v":""}]
[null,"",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,Stock!A:B,2,0))","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,Stock!A:C,3,0))","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,Stock!A:D,4,0))","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(D34,TVA!A:B,2,0)*E34+E34)","v":""},"","",{"$f":"IF(A34=\"\",\"\",VLOOKUP(D34,TVA!A:B,2,0)*E34)","v":""}]
[null,"",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,Stock!A:B,2,0))","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,Stock!A:C,3,0))","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,Stock!A:D,4,0))","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(D35,TVA!A:B,2,0)*E35+E35)","v":""},"","",{"$f":"IF(A35=\"\",\"\",VLOOKUP(D35,TVA!A:B,2,0)*E35)","v":""}]
[null,"",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,Stock!A:B,2,0))","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,Stock!A:C,3,0))","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,Stock!A:D,4,0))","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(D36,TVA!A:B,2,0)*E36+E36)","v":""},"","",{"$f":"IF(A36=\"\",\"\",VLOOKUP(D36,TVA!A:B,2,0)*E36)","v":""}]
[null,"",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,Stock!A:B,2,0))","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,Stock!A:C,3,0))","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,Stock!A:D,4,0))","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(D37,TVA!A:B,2,0)*E37+E37)","v":""},"","",{"$f":"IF(A37=\"\",\"\",VLOOKUP(D37,TVA!A:B,2,0)*E37)","v":""}]
[null,"",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,Stock!A:B,2,0))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,Stock!A:C,3,0))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,Stock!A:D,4,0))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(D38,TVA!A:B,2,0)*E38+E38)","v":""},"",{"$f":"IF(A38=\"\",\"\",B38*E38)","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(D38,TVA!A:B,2,0)*E38)","v":""}]
[null,"",{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,Stock!A:B,2,0))","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,Stock!A:C,3,0))","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,Stock!A:D,4,0))","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(D39,TVA!A:B,2,0)*E39+E39)","v":""},"","",{"$f":"IF(A39=\"\",\"\",VLOOKUP(D39,TVA!A:B,2,0)*E39)","v":""}]
[null,"",{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,Stock!A:B,2,0))","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,Stock!A:C,3,0))","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,Stock!A:D,4,0))","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(D40,TVA!A:B,2,0)*E40+E40)","v":""},"","",{"$f":"IF(A40=\"\",\"\",VLOOKUP(D40,TVA!A:B,2,0)*E40)","v":""}]
[null,null,null,"Total ht",null,null,{"$f":"SUM(H10:H40)","v":0}]
[null,null,null,"TVA",null,null,{"$f":"SUM(I10:I40)","v":0}]
[null,null,null,"Frais de Port"]
[null,null,null,"Total ttc",null,null,{"$f":"SUM(G10:G40)+G43","v":0}]

{"sheet":"Stock","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ref.","Désignation","Code TVA","Prix HT","Quantité","Mini","Rupture","facture en cours","Stock après facture"]
["D101","Anchoïde à la provençale - 210 gr",1,5.4,90,10,{"$f":"IF(E2<F2,\"Rupture de stock\",\"\")","v":""},{"$f":"SUMIF(Facture!$A$10:$A$40,A2,Facture!$B$10:$B$40)","v":0},{"$f":"E2-H2","v":90}]
["HO110","Sachet Provençal \"Mouans-Sartoux\"",2,5.4,95,10,"",{"$f":"SUMIF(Facture!$A$10:$A$40,A3,Facture!$B$10:$B$40)","v":0},{"$f":"E3-H3","v":95}]
["H101","Huile d'olive vierge extra Nice 1L",1,16,46,5,"",{"$f":"SUMIF(Facture!$A$10:$A$40,A4,Facture!$B$10:$B$40)","v":0},46]
["O101","Olive Noires de Nice 250 gr",1,3.6,97,10,"",{"$f":"SUMIF(Facture!$A$10:$A$40,A5,Facture!$B$10:$B$40)","v":0},97]
["C101","Coffret cadeau Nice",2,148,30,5,"",{"$f":"SUMIF(Facture!$A$10:$A$40,A6,Facture!$B$10:$B$40)","v":0},30]
["DH105","Savonette Amandes douces - 125 gr",2,60,0,30,"Rupture de stock",{"$f":"SUMIF(Facture!$A$10:$A$40,A7,Facture!$B$10:$B$40)","v":0},0]

{"sheet":"Historique factures","index":3,"n_rows":9,"n_cols":21,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["N° facture","Client","Date","Montant","mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A:A)","v":9}]
[8,"Lopez Eric","2013-07-08",5526.2560000000003,{"$f":"MONTH(C2)","v":7}]
[7,"Laurette Marie","2013-03-08",168.79999999999998,{"$f":"MONTH(C3)","v":3}]
[6,"Dupond François","2013-06-08",901.92000000000007,{"$f":"MONTH(C4)","v":6}]
[5,"Laurette Marie","2013-07-08",364.49700000000001,{"$f":"MONTH(C5)","v":7}]
[4,"Lopez Eric","2013-05-08",1296.7919999999999,5]
[3,"Dupond François","2013-07-15",39.457000000000001,7]
[2,"Laurette Marie","2013-01-08",75.558000000000007,1]
[1,"Dupond François","2013-02-08",197.68600000000001,2]

{"sheet":"Clients","index":4,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Identifiant","Nom","Prénom","Adresse","Code Postal","Ville","Tél.","factures","Montant total","Identifiant"]
[{"$f":"CONCATENATE(B2,\" \",C2)","v":"Lopez Eric"},"Lopez","Eric","45 rue …",16000,"Angouleme","05 45 87 98 54",{"$f":"COUNTIF('Historique factures'!B:B,A2)","v":2},{"$f":"SUMIF('Historique factures'!B:B,A2,'Historique factures'!D:D)","v":6823.0480000000007},{"$f":"A2","v":"Lopez Eric"}]
[{"$f":"CONCATENATE(B3,\" \",C3)","v":"Dupond François"},"Dupond","François","54 av …",75018,"Paris","01 12 45 21 54",{"$f":"COUNTIF('Historique factures'!B:B,A3)","v":3},{"$f":"SUMIF('Historique factures'!B:B,A3,'Historique factures'!D:D)","v":1139.0630000000001},{"$f":"A3","v":"Dupond François"}]
[{"$f":"CONCATENATE(B4,\" \",C4)","v":"Laurette Marie"},"Laurette","Marie","21 rue …",75019,"Paris","02 02 21 54 32",{"$f":"COUNTIF('Historique factures'!B:B,A4)","v":3},{"$f":"SUMIF('Historique factures'!B:B,A4,'Historique factures'!D:D)","v":608.85500000000002},"Laurette Marie"]

{"sheet":"TVA","index":5,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Code TVA","Taux"]
[1,5.5E-2]
[2,0.19600000000000001]