{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Achat Jour","DIVALTO"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Achat Jour","index":0,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,5,31,8],[32,3,32,5],[32,6,32,8],[20,6,20,8],[20,3,20,5],[19,5,19,8],[25,5,25,8],[26,3,26,5],[26,6,26,8],[7,5,7,8],[8,3,8,5],[8,6,8,8],[13,5,13,8],[14,3,14,5],[14,6,14,8]]}
[null,null,null,null,null,"Prix Jour",null,null,"PA BRUT","Frontignan",null,"Port la Nvlle","Marge","PV Brut"]
["ADDITIVATION",7,null,false,null,"FOD A",true,null,500,null,null,null,150,{"$f":"I2+M2","v":650}]
["PRECARITE",6,null,false,null,"GNR A",true,null,800,null,null,null,"100",{"$f":"I3+M3","v":900}]
["CEE GNR/GO",3,null,false,null,"GO",true,null,700,null,null,null,"50",{"$f":"I4+M4","v":750}]
[]
["Propagé ?","Oui",null,true,null,null,false,null,"Non"]
[]
["Prix Achat",null,null,null,null,"NARBONNE",null,null,null,"REFERENCE","CODE TARIF","PA RENDU","PV BRUT"]
[null,null,null,"FRO",null,null,"PLN",null,null,"0310","H1",{"$f":"L12-B2","v":808},{"$f":"L9+M3","v":908}]
["TRANSPORT",null,null,null,null,8,null,null,5,"0210","H1",{"$f":"L11-B2","v":511},{"$f":"L10+M2","v":661}]
["FOD A",200,{"$f":"IF($D$6=TRUE,(I2+B2+B3+F10),I11=I2+B2+B3+I10)","v":521},false,null,{"$f":"IF(D6=TRUE,IF(D2=TRUE,I2+B2+B3+F10,0),IF(D6=FALSE,IF(D11=TRUE,B11+B2+B3+F10,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$2=FALSE),$I$2+$B$2+B3+I10,IF(AND($D$6=FALSE,D11=FALSE),B11+B2+B2+I10,0))","v":518},"0217A","H1",{"$f":"IF(D11=TRUE,F11,I11)","v":518},{"$f":"L11+M2","v":668}]
["GNR A",300,{"$f":"IF(D6=TRUE,(I3+B2+B4+F10),I12=I3+B2+B4+I11)","v":818},false,null,{"$f":"IF(D6=TRUE,IF(D3=TRUE,I3+B2+B4+F10,0),IF(D6=FALSE,IF(D12=TRUE,B12+B2+B4+F10,0)))","v":0},true,null,{"$f":"IF(AND(D6=TRUE,D3=FALSE),I3+B2+B4+I10,IF(AND(D6=FALSE,D12=FALSE),B12+B2+B4+I10,0))","v":815},"0312A","H1",{"$f":"IF(D12=TRUE,F12,I12)","v":815},{"$f":"L12+M3","v":915}]
["GO",400,{"$f":"IF(D6=TRUE,(I4+B2+B4+F10),I13=I4+B2+B4+I10)","v":718},false,null,{"$f":"IF(D6=TRUE,IF(D4=TRUE,I4+B2+B4+F10,0),IF(D6=FALSE,IF(D13=TRUE,B13+B2+B4+F10,0)))","v":0},true,null,{"$f":"IF(AND(D6=TRUE,D4=FALSE),I4+B2+B4+I10,IF(AND(D6=FALSE,D13=FALSE),B13+B2+B4+I10,0))","v":715},"0120","H1",{"$f":"IF(D13=TRUE,F13,I13)","v":715},{"$f":"L13+M4","v":765}]
[null,null,null,null,null,"CAPENDU"]
[null,null,null,"FRO",null,null,"PLN",null,null,"0310","H2",{"$f":"L18-B2","v":810},{"$f":"L15+M3","v":910}]
["TRANSPORT",null,null,null,null,11,null,null,7,"0210","H2",{"$f":"L17-B2","v":513},{"$f":"L16+M2","v":663}]
["FOD",200,{"$f":"IF($D$6=TRUE,(I2+$B$2+B3+$F$16),I17=I2+$B$2+B3+$I$16)","v":524},false,null,{"$f":"IF(D6=TRUE,IF(D2=TRUE,I2+B2+B3+F16,0),IF(D6=FALSE,IF(D17=TRUE,B17+B2+B3+F16,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$2=FALSE),$I$2+$B$2+B3+I16,IF(AND($D$6=FALSE,D17=FALSE),B17+B2+B3+I16,0))","v":520},"0217A","H2",{"$f":"IF(D17=TRUE,F17,I17)","v":520},{"$f":"L17+M2","v":670}]
["GNR",300,{"$f":"IF($D$6=TRUE,(I3+$B$2+B4+$F$16),I18=I3+$B$2+B4+$I$16)","v":821},false,null,{"$f":"IF(D6=TRUE,IF(D3=TRUE,I3+B2+B4+F16,0),IF(D6=FALSE,IF(D18=TRUE,B18+B2+B4+F16,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$3=FALSE),$I3+$B$2+B4+$I$16,IF(AND($D$6=FALSE,D18=FALSE),B18+$B$2+B4+$I$16,0))","v":817},"0312A","H2",{"$f":"IF(D18=TRUE,F18,I18)","v":817},{"$f":"L18+M3","v":917}]
["GO",400,718,false,null,{"$f":"IF(D6=TRUE,IF(D4=TRUE,I4+B2+B4+F16,0),IF(D6=FALSE,IF(D19=TRUE,B19+B2+B4+F16,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$4=FALSE),$I4+$B$2+B4+$I$16,IF(AND($D$6=FALSE,D19=FALSE),B19+$B$2+B4+$I$16,0))","v":717},"0120","H2",{"$f":"IF(D19=TRUE,F19,I19)","v":717},{"$f":"L19+M4","v":767}]
[null,null,null,null,null,"HOMPS"]
[null,null,null,"FRO",null,null,"PLN",null,null,"0310","H3",{"$f":"L24-B2","v":809},{"$f":"L21+M3","v":909}]
["TRANSPORT",null,null,null,null,10,null,null,6,"0210","H3",{"$f":"L23-B2","v":512},{"$f":"L22+M2","v":662}]
["FOD",200,null,false,null,{"$f":"IF(D6=TRUE,IF(D2=TRUE,I2+B2+B3+F22,0),IF(D6=FALSE,IF(D23=TRUE,B23+B2+B3+F22,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D2=FALSE),I2+$B$2+B3+$I$22,IF(AND($D$6=FALSE,D23=FALSE),B23+$B$2+B3+$I$22,0))","v":519},"0217A","H3",{"$f":"IF(D23=TRUE,F23,I23)","v":519},{"$f":"L23+M2","v":669}]
["GNR",300,null,false,null,{"$f":"IF(D6=TRUE,IF(D3=TRUE,I3+B2+B4+F22,0),IF(D6=FALSE,IF(D24=TRUE,B24+B2+B4+F22,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$3=FALSE),$I$3+$B$2+B4+$I$22,IF(AND($D$6=FALSE,D24=FALSE),B24+$B$2+B4+$I$22,0))","v":816},"0312A","H3",{"$f":"IF(D24=TRUE,F24,I24)","v":816},{"$f":"L24+M3","v":916}]
["GO",400,null,false,null,{"$f":"IF(D6=TRUE,IF(D4=TRUE,I4+B2+B4+F22,0),IF(D6=FALSE,IF(D25=TRUE,B25+B2+B4+F22,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,$D$4=FALSE),$I$4+$B$2+B4+$I$22,IF(AND($D$6=FALSE,D25=FALSE),B25+$B$2+B4+$I$22,0))","v":716},"0120","H3",{"$f":"IF(D25=TRUE,F25,I25)","v":716},{"$f":"L25+M4","v":766}]
[null,null,null,null,null,"LIMOUX"]
[null,null,null,"FRO",null,null,"PLN",null,null,"0310","H4",{"$f":"L30-B2","v":813},{"$f":"L27+M3","v":913}]
["TRANSPORT",null,null,null,null,14,null,null,10,"0210","H4",{"$f":"L29-B2","v":516},{"$f":"L28+M2","v":666}]
["FOD",200,null,false,null,{"$f":"IF(D6=TRUE,IF(D2=TRUE,I2+B2+B3+F28,0),IF(D6=FALSE,IF(D29=TRUE,B29+B2+B3+F28,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D2=FALSE),I2+$B$2+B3+$I$28,IF(AND($D$6=FALSE,D29=FALSE),B29+$B$2+B3+$I$28,0))","v":523},"0217A","H4",{"$f":"IF(D29=TRUE,F29,I29)","v":523},{"$f":"L29+M2","v":673}]
["GNR",300,null,false,null,{"$f":"IF(D6=TRUE,IF(D3=TRUE,I3+B2+B4+F28,0),IF(D6=FALSE,IF(D30=TRUE,B30+B2+B4+F28,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D3=FALSE),I3+$B$2+B4+$I$28,IF(AND($D$6=FALSE,D30=FALSE),B30+$B$2+B4+$I$28,0))","v":820},"0312A","H4",{"$f":"IF(D30=TRUE,F30,I30)","v":820},{"$f":"L30+M3","v":920}]
["GO",400,null,false,null,{"$f":"IF(D6=TRUE,IF(D4=TRUE,I4+B2+B4+F28,0),IF(D6=FALSE,IF(D31=TRUE,B31+B2+B4+F28,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D4=FALSE),I4+$B$2+B4+$I$28,IF(AND($D$6=FALSE,D31=FALSE),B31+$B$2+B4+$I$28,0))","v":720},"0120","H4",{"$f":"IF(D31=TRUE,F31,I31)","v":720},{"$f":"L31+M4","v":770}]
[null,null,null,null,null,"CARCASSONNE"]
[null,null,null,"FRO",null,null,"PLN",null,null,"0310","H5",{"$f":"L36-B2","v":811},{"$f":"L33+M3","v":911}]
["TRANSPORT",null,null,null,null,11,null,null,8,"0210","H5",{"$f":"L35-B2","v":514},{"$f":"L34+M2","v":664}]
["FOD",200,null,false,null,{"$f":"IF(D6=TRUE,IF(D2=TRUE,I2+B2+B3+F34,0),IF(D2=FALSE,IF(D35=TRUE,B35+B2+B3+F34,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D2=FALSE),I2+$B$2+B3+$I$34,IF(AND($D$6=FALSE,D35=FALSE),B35+$B$2+B3+$I$34,0))","v":521},"0217A","H5",{"$f":"IF(D35=TRUE,F35,I35)","v":521},{"$f":"L35+M2","v":671}]
["GNR",300,null,false,null,{"$f":"IF(D6=TRUE,IF(D3=TRUE,I3+B2+B4+F34,0),IF(D3=FALSE,IF(D36=TRUE,B36+B2+B4+F34,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D3=FALSE),I3+$B$2+B4+$I$34,IF(AND($D$6=FALSE,D36=FALSE),B36+$B$2+B4+$I$34,0))","v":818},"0312A","H5",{"$f":"IF(D36=TRUE,F36,I36)","v":818},{"$f":"L36+M3","v":918}]
["GO",400,null,false,null,{"$f":"IF(D6=TRUE,IF(D4=TRUE,I4+B2+B4+F34,0),IF(D4=FALSE,IF(D37=TRUE,B37+B2+B4+F34,0)))","v":0},true,null,{"$f":"IF(AND($D$6=TRUE,D4=FALSE),I4+$B$2+B5+$I$34,IF(AND($D$6=FALSE,D37=FALSE),B37+$B$2+B5+$I$34,0))","v":715},"0120","H5",{"$f":"IF(D37=TRUE,F37,I37)","v":715},{"$f":"L37+M4","v":765}]

{"sheet":"DIVALTO","index":1,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Champs clé",null,null,null,null,null,null,null,null,null,"Extraction",null,null,null,"Intégration",null,null,"Anomalies"]
[]
["reference","sref1","sref2","devise","tarif","client","marche","unite","depot","seuil","donnee=art.des","donnee=prix1","donnee=prixpar1","donnee=HTCOD","resultat=HTCOD","resultat=prix1","resultat=prixpar1","erreur"]
["0310",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M9","v":908},1000,"Code tarif H1 inexistant"]
["0210",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M10","v":661},1000,"Code tarif H1 inexistant"]
["0217A",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M11","v":668},1000,"Code tarif H1 inexistant"]
["0312A",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M12","v":915},1000,"Code tarif H1 inexistant"]
["0120",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M13","v":765},1000,"Code tarif H1 inexistant"]
["0312",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P9","v":915},1000,"Code tarif H1 inexistant"]
["0217",null,null,"EUR","H1",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P8","v":668},1000,"Code tarif H1 inexistant"]
["0310",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M15","v":910},1000,"Code tarif H2 inexistant"]
["0210",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M16","v":663},1000,"Code tarif H2 inexistant"]
["0217A",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M17","v":670},1000,"Code tarif H2 inexistant"]
["0312A",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M18","v":917},1000,"Code tarif H2 inexistant"]
["0120",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M19","v":767},1000,"Code tarif H2 inexistant"]
["0312",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P16","v":917},1000,"Code tarif H2 inexistant"]
["0217",null,null,"EUR","H2",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P15","v":670},1000,"Code tarif H2 inexistant"]
["0310",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M21","v":909},1000,"Code tarif H3 inexistant"]
["0210",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M22","v":662},1000,"Code tarif H3 inexistant"]
["0217A",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M23","v":669},1000,"Code tarif H3 inexistant"]
["0312A",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M24","v":916},1000,"Code tarif H3 inexistant"]
["0120",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M25","v":766},1000,"Code tarif H3 inexistant"]
["0312",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P23","v":916},1000,"Code tarif H3 inexistant"]
["0217",null,null,"EUR","H3",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P22","v":669},1000,"Code tarif H3 inexistant"]
["0310",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M27","v":913},1000,"Code tarif H4 inexistant"]
["0210",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M28","v":666},1000,"Code tarif H4 inexistant"]
["0217A",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M29","v":673},1000,"Code tarif H4 inexistant"]
["0312A",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M30","v":920},1000,"Code tarif H4 inexistant"]
["0120",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M31","v":770},1000,"Code tarif H4 inexistant"]
["0312",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P30","v":920},1000,"Code tarif H4 inexistant"]
["0217",null,null,"EUR","H4",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P29","v":673},1000,"Code tarif H4 inexistant"]
["0310",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M33","v":911},1000,"Code tarif H5 inexistant"]
["0210",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M34","v":664},1000,"Code tarif H5 inexistant"]
["0217A",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M35","v":671},1000,"Code tarif H5 inexistant"]
["0312A",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M36","v":918},1000,"Code tarif H5 inexistant"]
["0120",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"'Achat Jour'!M37","v":765},1000,"Code tarif H5 inexistant"]
["0312",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P37","v":918},1000,"Code tarif H5 inexistant"]
["0217",null,null,"EUR","H5",null,null,"M3",null,null,null,null,null,null,"HT",{"$f":"P36","v":671},1000,"Code tarif H5 inexistant"]