{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Recherche","Janvier"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Recherche","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"Recherche volume  coupe N° : ","001/2014"]
[null,null,"Nom"]
[{"$f":"SUM(C3:O3)","v":139.15},"Janvier",{"$f":"SUMIF(Janvier!D5:D600,$D$1,Janvier!I5:I600)","v":139.15}]
[0,"Février"]
[0,"Mars"]
[0,"Avril"]
[0,"Mai"]
[0,"Juin"]
[0,"Juillet"]
[0,"Août"]
[0,"Septembre"]
[0,"Octobre"]
[0,"Novembre"]
[0,"Décembre"]
[{"$f":"SUM(A3:A14)","v":139.15}]
[]
[null,"Je voudrais aller chercher le volume  en janvier colonne \"I\" suivant la référence de D1 "]
[null,"Mais en plus il faut qu'il me rajoute les cellules vides des volumes correspondant toujours en D 1 en multipliant par le nombre en J 2."]
[]
[null,"La j'ai 139,150 et je voudrais rajouter le nombre de tours à 0 multiplier par J 2"]
[null,"Je devrai avoir les 139,150 plus 2 fois à 32 soit 203,150"]

{"sheet":"Janvier","index":1,"n_rows":123,"n_cols":10,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,0,2,1]]}
["NOM"]
[null,null,null,null,null,"Facture",null,"Rebut",null,32]
["JANVIER  ",null,null,null,null,"Prévision",{"$f":"J3*J2+I3","v":2934.8999999999996},"Réalisé : ",{"$f":"SUM(I5:I202)","v":2774.8999999999996},{"$f":"SUMPRODUCT(NOT(ISBLANK(C5:C401))*ISBLANK(I5:I401))","v":5}]
["Date","Un","Deux","Trois","Quatre","Cinq","Six","Sept","VOLUME","Neuf"]
["2014-12-31","STBL","VAUXOUE","278/2013",null,"ONF","1110D","O",31.5,1]
["2014-12-31","STBL","VAL DU PUITS","001/2014","MER","ONF","1110DJ","O",35.700000000000003,2]
["2014-12-31","FIMALUX","CHATEL GERARD","001/2014",32,"DH","1110DD","O",null,3]
[]
[]
[]
["2014-01-06","STBL","VAL DU PUITS","191/2013","MER","ONF","1110DJ","O",36,4]
["2014-01-06","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",35.9,5]
["2014-01-06","AKA","VILLERS PATRAS","350/2013",null,"BRB","1110C","O",31.2,6]
["2014-01-06","TEB","COURTIVRON","001/2014",9,"DH","XC","O",null,7]
[]
["2014-01-07","STBL","VAL DU PUITS","191/2013","MER","ONF","1110DJ","O",35.35,8]
["2014-01-07","STBL","VAL DU PUITS","191/2013","MER","ONF","1110DJ","O",35.1,9]
["2014-01-07","AKA","VILLERS PATRAS","350/2013",null,"BRB","1110C","O",32.75,10]
["2014-01-07","TEB L ","AUBERIVE"," 170/2012",928,"DH","XC","O",33.450000000000003,11]
["2014-01-07","SNC2M","AUBERIVE"," 170/2012",928,"DH","XC","O",33.549999999999997,12]
[]
["2014-01-08","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",34.450000000000003,13]
["2014-01-08","STBL","CHATILLON","362/2013",332,"ONF","1110E","O",35.299999999999997,14]
["2014-01-08","WESTRANS","VILLERS PATRAS","350/2013","2 TIERS","BRB","1110C","O",{"$f":"29.65/3*2","v":19.766666666666666},15]
["2014-01-08",null,"VILLERS PATRAS","330/2013","1 TIERS POISSON","DH","1110C","O",{"$f":"29.65/3","v":9.8833333333333329}]
["2014-01-08","TEB L ","AUBERIVE"," 170/2012",928,"DH","XC","O",33.200000000000003,16]
["2014-01-08","SNC2M","AUBERIVE"," 170/2012",928,"DH","XC","O",32.200000000000003,17]
["2014-01-08","FIMALUX","CHATEL GERARD","100/2012",79,"ONF","1110DD","O",32.6,18]
["2014-01-08","FIMALUX","CHATEL GERARD","100/2012",79,"ONF","1110DD","O",30,19]
[]
["2014-01-09","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",null,20]
["2014-01-09","STBL","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",null,21]
["2014-01-09","WESTRANS","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",33.6,22]
["2014-01-09","FIMALUX","CHATEL GERARD","100/2012",79,"ONF","1110DD","O",32.799999999999997,23]
["2014-01-09","SNC2M","AUBERIVE"," 170/2012",928,"DH","XC","O",33.049999999999997,24]
["2014-01-09","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",36.950000000000003,25]
[]
["2014-01-10","STBL","VAL DU PUITS","292/2013",null,"ONF","1110DJ","O",32.549999999999997,25]
["2014-01-10","STBL","VAL DU PUITS","292/2013",null,"ONF","1110DJ","O",32,26]
["2014-01-10","WESTRANS","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",31.3,27]
["2014-01-10","SNC2M","AUBERIVE"," 170/2012",928,"DH","XC","O",34.35,28]
[]
[null,null,null,null," "]
[]
["2014-01-13","STBL","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",34.15,29]
["2014-01-13","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",33.549999999999997,30]
["2014-01-13","WESTRANS","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",33.299999999999997,31]
[]
["2014-01-14","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",32.549999999999997,32]
["2014-01-14","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",33.75,33]
["2014-01-14","WESTRANS","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",32.549999999999997,34]
["2014-01-14","AKA","VAUXOUE","278/2013","23-25","ONF","1110D","O",30.6,35]
["2014-01-14","AKA","VAUXOUE","278/2013","23-25","ONF","1110D","O",31.75,36]
[]
["2014-01-15","AKA","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",33.549999999999997,37]
["2014-01-15","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",35.35,38]
["2014-01-15","WESTRANS","VILLERS PATRAS","330/2013","Poissons","DH","1110C","O",35.65,39]
["2014-01-15","TEB L","LATRECEY","159/2012",null,"DH","XC","O",35.75,40]
[]
["2014-01-16","SNC2M","LATRECEY","159/2012",null,"DH","XC","O",32.700000000000003,41]
["2014-01-16","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110C","O",33.799999999999997,42]
["2014-01-16","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",33.1,43]
["2014-01-16","AKA","VAL DU PUITS","292/2013","TERRA","ONF","1110C","O",31.6,44]
[]
["2014-01-17","SNC2M","LATRECEY","159/2012",null,"DH","XC","O",32.299999999999997,45]
["2014-01-17","STBL","VAL DU PUITS","001/2014","TERRA","ONF","1110C","O",31.95,46]
["2014-01-17","STBL","VAL DU PUITS","001/2014","TERRA","ONF","1110DJ","O",37.4,47]
["2014-01-17","AKA","VAUXOUE","278/2013","23-25","ONF","1110D","O",31.7,48]
[]
[]
[null,null,null," "]
["2014-01-20","STBL","VAUXOUE","278/2013","P9-10","ONF","1110D","O",34.4,49]
["2014-01-20","STBL","VAUXOUE","278/2013","P9-10","ONF","1110D","O",32.799999999999997,50]
["2014-01-20","SNC2M","VAL DU PUITS","292/2013","TERRA","ONF","1110C","O",31.05,51]
["2014-01-20","WESTRANS","VAL DU PUITS","292/2013","TERRA","ONF","1110DJ","O",31.5,52]
[null,null,null," "]
["2014-01-21","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110C","O",34.1,53]
["2014-01-21"]
[]
["2014-01-22","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110D","O",33.9,54]
["2014-01-22","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110C","O",33.35,55]
[null,null,"VAUXOUE","278/2013","P9-10","ONF","1110D"]
[]
["2014-01-23","STBL","VAL DU PUITS","292/2013","TERRA","ONF","1110D","O",35.25,56]
["2014-01-23","TEB L ","COURTIVRON","016/2014",10,"DH","XC","O",34.200000000000003,57]
[]
["2014-01-24","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",34.450000000000003,58]
["2014-01-24","TEB L ","COURTIVRON","016/2014",10,"DH","XC","O",33.200000000000003,59]
["2014-01-24","TRANSVALONGO","AUBERIVE","005/2014",315,"DH","TRANSVAL","O",29.65,60]
["2014-01-24","TRANSVALONGO","AUBERIVE","005/2014",315,"DH","TRANSVAL","O",30.5,61]
["2014-01-24","TRANSVALONGO","AUBERIVE","005/2014",315,"DH","TRANSVAL","O",31.7,62]
[null,null,null,null,null,null,null,null," "]
[]
[]
["2014-01-27","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",33.799999999999997,63]
["2014-01-27","STBL","ST BROING","097/2012",null,"DH","1110D","O",35.9,64]
["2014-01-27","TRANSVALONGO","AUBERIVE","005/2014",315,"DH","TRANSVAL","O",31.65,65]
["2014-01-27","TRANSVALONGO","AUBERIVE","005/2014",315,"DH","TRANSVAL","O",31.25,66]
["2014-01-27","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",34.450000000000003,67]
["2014-01-27","TEB L ","COURTIVRON","016/2014",10,"DH","XC","O",33.799999999999997,68]
[null,null,null,null," "]
["2014-01-28","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",34.15,69]
["2014-01-28","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",34.950000000000003,70]
["2014-01-28","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",31.65,71]
["2014-01-28","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",35.549999999999997,72]
["2014-01-28","TEB L ","COURTIVRON","016/2014",10,"DH","XC","O",35.549999999999997,73]
[]
["2014-01-29","FIMALUX","CHATEL GERARD"," 257/2012",111,"DH","1110DD","O",35.15,74]
["2014-01-29","STBL","ST BROING","097/2012",null,"DH","1110D","O",35.450000000000003,75]
["2014-01-29","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",34.65,76]
["2014-01-29","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",32.5,77]
["2014-01-29","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",31.05,78]
["2014-01-29","TEB L ","COURTIVRON","001/2014",9,"DH","XC","O",34.1,79]
[]
["2014-01-30","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",35.1,80]
["2014-01-30","STBL","GRANDS BOIS","360/2013","16-17","DH","1110E","O",32.9,81]
["2014-01-30","TRANSVALONGO","AUBERIVE","218/2011",320,"DH","TRANSVAL","O",30.9,82]
["2014-01-30","TRANSVALONGO","AUBERIVE","218/2011","320 / 2P","DH","TRANSVAL","O",{"$f":"32.55/3*2","v":21.7},83]
["2014-01-30",null,"SIGFRA VIVEY","164/2012","2826-2827-2813","DH","TRANSVAL","O",{"$f":"32.55/3","v":10.85}]
[]
["2014-01-31","WESTRANS","RECEY","344/2013",null,"MORTIER","1110C","O",35.200000000000003,84]
["2014-01-31","SNC2M","RECEY","344/2013",null,"MORTIER","1110C","O",36.35,85]
["2014-01-31","TRANSVALONGO","SIGFRA VIVEY","164/2012","2826-2827-2813","DH","TRANSVAL","O",34.700000000000003,86]