{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":41,"n_cols":12,"rows_kept":41}
[null,"Par macro:  A chaque nouvelle vente "]
[null,null,1,"création d'une ligne de vente"]
[null,null,2,"insertion en zone d'insertion d'un tableau de ventilation des coûts d'achat"]
[null,null,3,"création automatique des formules"]
[null,null,4,"FORMULE QUI ME POSE PROBLEME"]
[{"$nulls":3},"comment introduire dans la formule l'addition de la nouvelle zone crée après l'insertion"]
[{"$nulls":3},"elle devra être ensuite copiée dans chaque cellule de la zone    L22 à L25"]
["SUIVI GENERAL",{"$nulls":6},2018,"Janvier","Février","Mars","Avril"]
[]
[{"$nulls":7},"C.A",{"$f":"I13+I19","v":{"v":6000,"d":"6,000.00 €"}},{"$f":"J13+J19","v":{"v":15750,"d":"15,750.00 €"}},{"v":5250,"d":"5,250.00 €"},0]
[{"$nulls":7},"CUMUL",{"$f":"+I10","v":{"v":6000,"d":"6,000.00 €"}},{"$f":"+J10+I11","v":{"v":21750,"d":"21,750.00 €"}},{"$f":"+K10+J11","v":{"v":27000,"d":"27,000.00 €"}},{"v":27000,"d":"27,000.00 €"}]
[]
[{"$nulls":7},"GLOBALISATION",{"$f":"SUM(I15:I17)","v":9800},{"$f":"SUM(J15:J17)","v":24500},8750,0]
[null,null,{"$f":"IF($G1=0,0,$F1)","v":0},{"$nulls":3},"ON/OFF"]
[null,1,"VENTES",{"v":1000,"d":"1,000.00 "},9.8,{"$f":"E15*D15","v":{"v":9800,"d":"9,800.00 "}},1,"Ventilation VENTES",{"$f":"IF($G15=0,0,$F15)","v":9800}]
[null,2,"VENTES",{"v":2500,"d":"2,500.00 "},9.8,{"$f":"E16*D16","v":{"v":24500,"d":"24,500.00 "}},1,"Ventilation VENTES",null,{"$f":"IF($G16=0,0,$F16)","v":24500}]
[null,3,"VENTES",{"v":875,"d":"875.00 "},10,{"v":8750,"d":"8,750.00 "},1,"Ventilation VENTES",null,null,{"$f":"IF($G17=0,0,$F17)","v":8750}]
[]
[null,null,"ACHAT",{"$nulls":4},"GLOBALISATION",{"$f":"-SUM(I22:I25)","v":{"v":-3799.9999999999995,"d":"-3800.00"}},{"$f":"-SUM(J22:J25)","v":{"v":-8750,"d":"-8750.00"}},{"$f":"-SUM(K22:K25)","v":{"v":-3500,"d":"-3500.00"}},{"$f":"-SUM(L22:L25)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"ROW(A21)","v":21},null,"VENTILATION DES COÛTS"]
[{"$nulls":4},"GLOBALISATION","ACHATS",null,null,{"$f":"+I28+I33+I38","v":{"v":2349.9999999999995,"d":"2350.00"}},{"$f":"+J28+J33+J38","v":{"v":5125,"d":"5125.00"}},{"$f":"+K28+K33+K38","v":2231.25},{"$f":"+L28+L33+L38","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Fabrication",null,null,{"$f":"+I29+I34+I39","v":{"v":770,"d":"770.00"}},{"$f":"+J29+J34+J39","v":{"v":1925,"d":"1925.00"}},{"$f":"+K29+K34+K39","v":673.75},{"$f":"+L29+L34+L39","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Emballage",null,null,{"$f":"+I30+I35+I40","v":{"v":580,"d":"580.00"}},{"$f":"+J30+J35+J40","v":{"v":1450,"d":"1450.00"}},{"$f":"+K30+K35+K40","v":{"v":507.49999999999994,"d":"507.50"}},{"$f":"+L30+L35+L40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Envoi",null,null,{"$f":"+I31+I36+I41","v":{"v":100,"d":"100.00"}},{"$f":"+J31+J36+J41","v":{"v":250,"d":"250.00"}},{"$f":"+K31+K36+K41","v":{"v":87.5,"d":"87.50"}},{"$f":"+L31+L36+L41","v":{"v":0,"d":"0.00"}}]
[null,null,"Zone d'insertion"]
[null,3,{"v":4,"d":"4.00 €"},"Nb Pièces","PxACH","Tot",null,"Contrôle si vente",{"$f":"IF(I17=0,0,I17)","v":0},{"$f":"IF(J17=0,0,J17)","v":0},{"$f":"IF(K17=0,0,K17)","v":8750},{"$f":"IF(L17=0,0,L17)","v":0}]
[null,null,"Achat",{"$f":"+D17","v":875},{"$f":"C27-E29-E30-E31","v":{"v":2.55,"d":"2.55 €"}},{"$f":"E28*D28","v":{"v":2231.25,"d":"2,231.25 €"}},{"$f":"+G17","v":1},"Ventilation des coûts",{"$f":"IF(I27=0,0,IF($G28=0,0,$F28))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J27=0,0,IF($G28=0,0,$F28))","v":{"v":0,"d":"0.00"}},{"$f":"IF(K27=0,0,IF($G28=0,0,$F28))","v":2231.25},{"$f":"IF(L27=0,0,IF($G28=0,0,$F28))","v":{"v":0,"d":"0.00"}}]
[null,null,"Fabrication",{"$f":"+D28","v":875},{"v":0.77,"d":"0.77 €"},{"$f":"E29*D29","v":{"v":673.75,"d":"673.75 €"}},{"$f":"+G28","v":1},null,{"$f":"IF(I27=0,0,IF($G29=0,0,$F29))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J27=0,0,IF($G29=0,0,$F29))","v":{"v":0,"d":"0.00"}},673.75,{"$f":"IF(L27=0,0,IF($G29=0,0,$F29))","v":{"v":0,"d":"0.00"}}]
[null,null,"Emballage",{"$f":"+D29","v":875},{"v":0.58,"d":"0.58 €"},{"v":507.49999999999994,"d":"507.50 €"},{"$f":"+G29","v":1},null,{"$f":"IF(I27=0,0,IF($G30=0,0,$F30))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J27=0,0,IF($G30=0,0,$F30))","v":{"v":0,"d":"0.00"}},{"v":507.49999999999994,"d":"507.50"},{"$f":"IF(L27=0,0,IF($G30=0,0,$F30))","v":{"v":0,"d":"0.00"}}]
[null,null,"Envoi",875,{"v":0.1,"d":"0.10 €"},{"v":87.5,"d":"87.50 €"},1,null,{"$f":"IF(I27=0,0,IF($G31=0,0,$F31))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J27=0,0,IF($G31=0,0,$F31))","v":{"v":0,"d":"0.00"}},{"v":87.5,"d":"87.50"},{"$f":"IF(L27=0,0,IF($G31=0,0,$F31))","v":{"v":0,"d":"0.00"}}]
[null,2,{"v":3.5,"d":"3.50 €"},"Nb Pièces","PxACH","Tot",null,"Contrôle si vente",{"$f":"IF(I16=0,0,I16)","v":0},{"$f":"IF(J16=0,0,J16)","v":24500},{"$f":"IF(K16=0,0,K16)","v":0},{"$f":"IF(L16=0,0,L16)","v":0}]
[null,null,"Achat",{"$f":"+D16","v":2500},{"$f":"C32-E34-E35-E36","v":{"v":2.05,"d":"2.05 €"}},{"$f":"E33*D33","v":{"v":5125,"d":"5,125.00 €"}},{"$f":"+G16","v":1},"Ventilation des coûts",{"$f":"IF(I32=0,0,IF($G33=0,0,$F33))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J32=0,0,IF($G33=0,0,$F33))","v":{"v":5125,"d":"5125.00"}},{"$f":"IF(K32=0,0,IF($G33=0,0,$F33))","v":{"v":0,"d":"0.00"}},{"$f":"IF(L32=0,0,IF($G33=0,0,$F33))","v":{"v":0,"d":"0.00"}}]
[null,null,"Fabrication",{"$f":"+D33","v":2500},{"v":0.77,"d":"0.77 €"},{"$f":"E34*D34","v":{"v":1925,"d":"1,925.00 €"}},{"$f":"+G33","v":1},null,{"$f":"IF(I32=0,0,IF($G34=0,0,$F34))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J32=0,0,IF($G34=0,0,$F34))","v":{"v":1925,"d":"1925.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L32=0,0,IF($G34=0,0,$F34))","v":{"v":0,"d":"0.00"}}]
[null,null,"Emballage",{"$f":"+D34","v":2500},{"v":0.58,"d":"0.58 €"},{"v":1450,"d":"1,450.00 €"},{"$f":"+G34","v":1},null,{"$f":"IF(I32=0,0,IF($G35=0,0,$F35))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J32=0,0,IF($G35=0,0,$F35))","v":{"v":1450,"d":"1450.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L32=0,0,IF($G35=0,0,$F35))","v":{"v":0,"d":"0.00"}}]
[null,null,"Envoi",2500,{"v":0.1,"d":"0.10 €"},{"v":250,"d":"250.00 €"},1,null,{"$f":"IF(I32=0,0,IF($G36=0,0,$F36))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J32=0,0,IF($G36=0,0,$F36))","v":{"v":250,"d":"250.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L32=0,0,IF($G36=0,0,$F36))","v":{"v":0,"d":"0.00"}}]
[null,1,{"v":3.8,"d":"3.80 €"},"Nb Pièces","PxACH","Tot",null,"Contrôle si vente",{"$f":"IF(I15=0,0,I15)","v":9800},{"$f":"IF(J15=0,0,J15)","v":0},{"$f":"IF(K15=0,0,K15)","v":0},{"$f":"IF(L15=0,0,L15)","v":0}]
[null,null,"Achat",{"$f":"+D15","v":1000},{"$f":"C37-E39-E40-E41","v":{"v":2.3499999999999996,"d":"2.35 €"}},{"$f":"E38*D38","v":{"v":2349.9999999999995,"d":"2,350.00 €"}},{"$f":"+G15","v":1},"Ventilation des coûts",{"$f":"IF(I37=0,0,IF($G38=0,0,$F38))","v":{"v":2349.9999999999995,"d":"2350.00"}},{"$f":"IF(J37=0,0,IF($G38=0,0,$F38))","v":{"v":0,"d":"0.00"}},{"$f":"IF(K37=0,0,IF($G38=0,0,$F38))","v":{"v":0,"d":"0.00"}},{"$f":"IF(L37=0,0,IF($G38=0,0,$F38))","v":{"v":0,"d":"0.00"}}]
[null,null,"Fabrication",{"$f":"+D38","v":1000},{"v":0.77,"d":"0.77 €"},{"$f":"E39*D39","v":{"v":770,"d":"770.00 €"}},{"$f":"+G38","v":1},null,{"$f":"IF(I37=0,0,IF($G39=0,0,$F39))","v":{"v":770,"d":"770.00"}},{"$f":"IF(J37=0,0,IF($G39=0,0,$F39))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L37=0,0,IF($G39=0,0,$F39))","v":{"v":0,"d":"0.00"}}]
[null,null,"Emballage",{"$f":"+D39","v":1000},{"v":0.58,"d":"0.58 €"},{"v":580,"d":"580.00 €"},{"$f":"+G39","v":1},null,{"$f":"IF(I37=0,0,IF($G40=0,0,$F40))","v":{"v":580,"d":"580.00"}},{"$f":"IF(J37=0,0,IF($G40=0,0,$F40))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L37=0,0,IF($G40=0,0,$F40))","v":{"v":0,"d":"0.00"}}]
[null,null,"Envoi",1000,{"v":0.1,"d":"0.10 €"},{"v":100,"d":"100.00 €"},1,null,{"$f":"IF(I37=0,0,IF($G41=0,0,$F41))","v":{"v":100,"d":"100.00"}},{"$f":"IF(J37=0,0,IF($G41=0,0,$F41))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"IF(L37=0,0,IF($G41=0,0,$F41))","v":{"v":0,"d":"0.00"}}]