{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil2","index":0,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[0,14,0,18],[0,9,0,12],[0,6,0,7]]}
["VENTES",null,null,null,"Volumes",null,"Prix HA si éclatement sur plusieurs entrées",null,null,"Stock au 30/06",null,null,null,null,"Réception "]
["VCDEAGRE.ARTICLE","DESIGNATION","DATE_COMMANDE","QTES_VENDUES","Volumes prit sur \nSTOCK","Volumes prit sur\nRECEPTION (entrée)","Prix HA\n(Cde FOUR)","Prix HA\n(Cde FOUR)",null,"ARTICLE","DESIGNATION","Stock au 30/06","Prix Stock",null,"Date de réception ","ARTICLE","DESIGNATION","Volumes réceptinnés à partir du 01/07","Prix HA"]
[100020,"carotte","2022-07-02",2,{"$f":"IF(SUMIFS($D$2:D3,$B$2:B3,B3)<=VLOOKUP(B3,$K$3:$M$4,2),D3,IF(SUMIFS($D$2:D3,$B$2:B3,B3)>VLOOKUP(B3,$K$3:$M$4,2),VLOOKUP(B3,$K$3:$M$4,2)-SUMIFS($E$2:E2,$B$2:B2,B3),0))","v":2},{"$f":"IF(D3=E3,\"\",D3-E3)","v":""},{"$f":"Eclatement_0(F3)","v":""},{"$f":"Eclatement_1(F3)","v":""},null,100020,"carotte",8,35,null,"2022-07-16",100020,"carotte",26,50]
[100020,"carotte","2022-07-02",3,{"$f":"IF(SUMIFS($D$2:D4,$B$2:B4,B4)<=VLOOKUP(B4,$K$3:$M$4,2),D4,IF(SUMIFS($D$2:D4,$B$2:B4,B4)>VLOOKUP(B4,$K$3:$M$4,2),VLOOKUP(B4,$K$3:$M$4,2)-SUMIFS($E$2:E3,$B$2:B3,B4),0))","v":3},{"$f":"IF(D4=E4,\"\",D4-E4)","v":""},{"$f":"Eclatement_0(F4)","v":""},{"$f":"Eclatement_1(F4)","v":""},null,130045,"Pdt",200,1500,null,"2022-07-18",100020,"carotte",25,60]
[100020,"carotte","2022-07-02",20,{"$f":"IF(SUMIFS($D$2:D5,$B$2:B5,B5)<=VLOOKUP(B5,$K$3:$M$4,2),D5,IF(SUMIFS($D$2:D5,$B$2:B5,B5)>VLOOKUP(B5,$K$3:$M$4,2),VLOOKUP(B5,$K$3:$M$4,2)-SUMIFS($E$2:E4,$B$2:B4,B5),0))","v":3},{"$f":"IF(D5=E5,\"\",D5-E5)","v":17},{"$f":"Eclatement_0(F5)","v":50},{"$f":"Eclatement_1(F5)","v":""},null,"17 à 50",null,null,null,null,"2022-07-20",100020,"carotte",30,70]
[100020,"carotte","2022-07-02",5,{"$f":"IF(SUMIFS($D$2:D6,$B$2:B6,B6)<=VLOOKUP(B6,$K$3:$M$4,2),D6,IF(SUMIFS($D$2:D6,$B$2:B6,B6)>VLOOKUP(B6,$K$3:$M$4,2),VLOOKUP(B6,$K$3:$M$4,2)-SUMIFS($E$2:E5,$B$2:B5,B6),0))","v":0},5,{"$f":"Eclatement_0(F6)","v":50},{"$f":"Eclatement_1(F6)","v":""},null,"5 à 50",null,null,null,null,"2022-07-21",130045,"Pdt",50,55]
[100020,"carotte","2022-07-02",13,{"$f":"IF(SUMIFS($D$2:D7,$B$2:B7,B7)<=VLOOKUP(B7,$K$3:$M$4,2),D7,IF(SUMIFS($D$2:D7,$B$2:B7,B7)>VLOOKUP(B7,$K$3:$M$4,2),VLOOKUP(B7,$K$3:$M$4,2)-SUMIFS($E$2:E6,$B$2:B6,B7),0))","v":0},13,{"$f":"Eclatement_0(F7)","v":50},{"$f":"Eclatement_1(F7)","v":60},null,"4 à 50","9 à 60",null,null,null,"2022-07-23",130045,"Pdt",20,40]
[130045,"Pdt","2022-06-15",14,{"$f":"IF(SUMIFS($D$2:D8,$B$2:B8,B8)<=VLOOKUP(B8,$K$3:$M$4,2),D8,IF(SUMIFS($D$2:D8,$B$2:B8,B8)>VLOOKUP(B8,$K$3:$M$4,2),VLOOKUP(B8,$K$3:$M$4,2)-SUMIFS($E$2:E7,$B$2:B7,B8),0))","v":14},"",{"$f":"Eclatement_0(F8)","v":""},{"$f":"Eclatement_1(F8)","v":""},null,null,null,null,null,null,"2022-07-25",100020,"carotte",34,52]
[130045,"Pdt","2022-07-29",42,{"$f":"IF(SUMIFS($D$2:D9,$B$2:B9,B9)<=VLOOKUP(B9,$K$3:$M$4,2),D9,IF(SUMIFS($D$2:D9,$B$2:B9,B9)>VLOOKUP(B9,$K$3:$M$4,2),VLOOKUP(B9,$K$3:$M$4,2)-SUMIFS($E$2:E8,$B$2:B8,B9),0))","v":42},"",{"$f":"Eclatement_0(F9)","v":""},{"$f":"Eclatement_1(F9)","v":""},null,null,null,null,null,null,"2022-08-01",130045,"Pdt",15,37]
[130045,"Pdt","2022-07-29",9,{"$f":"IF(SUMIFS($D$2:D10,$B$2:B10,B10)<=VLOOKUP(B10,$K$3:$M$4,2),D10,IF(SUMIFS($D$2:D10,$B$2:B10,B10)>VLOOKUP(B10,$K$3:$M$4,2),VLOOKUP(B10,$K$3:$M$4,2)-SUMIFS($E$2:E9,$B$2:B9,B10),0))","v":9},"",{"$f":"Eclatement_0(F10)","v":""},{"$f":"Eclatement_1(F10)","v":""}]