{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["EDI"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"EDI","index":0,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,11,0,12],[4,5,4,10],[5,5,5,10],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
[null,null,null,null,null,null,null,null,null,null,null,"Modèle n° ADC082F-15I"]
["RAISON SOCIAL",null,"ALIMA FOOD"]
["ID_FISCAL",null,40379671]
["ANNEE",null,2016]
["PERIODE(Mois)",null,4,null,null,"Relevé de déduction"]
["REGIME(Encais-1)",null,1,null,null,"(Article 112 du Code Général des Impôts)"]
[]
["OR","FACT_NUM","DESIGNATION","M_HT","TVA","M_TTC","IF","LIB_FRSS","ICE_FRS","TAUX","ID_PAIE","DATE_PAIE","DATE_FAC"]
[1,"7201","MARCHANDISE",195510,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":39102},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":234612},4100688,"LES CONSERVES","001529756000069",0.2,5,"2016-04-06","2016-02-02"]
[2,"AV9343","MARCHANDISE",-822.16,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":-164.43200000000002},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":-986.59199999999998},4100688,"LES CONSERVES","001529756000069",0.2,5,"2016-04-06","2016-02-02"]
[3,"0767","MARCHANDISE",142290.91,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":14229.091},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":156520.00099999999},3727455,"TECNOSCIENCES","001528526000088",0.1,5,"2016-04-27","2016-02-24"]
[4,"2719","MARCHANDISE",38181.82,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":3818.1820000000002},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":42000.002},3701585,"CENTRALE MAROC","001529852000026",0.1,5,"2016-04-07","2016-02-12"]
[5,"2727","MARCHANDISE",63636.36,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":6363.6360000000004},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":69999.995999999999},3701504,"CENTRALE  MAROC","001529852000040",0.1,5,"2016-04-14","2016-02-26"]
[6,"2723","MARCHANDISE",63636.36,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":6363.6360000000004},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":69999.995999999999},3701504,"CENTRALE  MAROC","001529852000059",0.1,5,"2016-04-27","2016-02-19"]
[7,"0765","MARCHANDISE",129090.91,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":12909.091},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":142000.00099999999},3726545,"TECNOS","001529756000069",0.1,5,"2016-04-06","2016-02-15"]
[8,"0326","MARCHANDISE",39556.370000000003,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":3955.6370000000006},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":43512.007000000005},40182429,"ASMAR","001529756000069",0.1,2,"2016-04-22","2016-03-16"]
[9,"1828","MARCHANDISE",13255,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":2651},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":15906},2223243,"MAD","001430353000049",0.2,2,"2016-04-26","2016-02-20"]
[10,"3467","MARCHANDISE",95571.6,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":19114.320000000003},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":114685.92000000001},3502802,"BEL MAROC","001530549000087",0.2,5,"2016-04-28","2016-03-21"]
[11,"0653","CARBURANT",6272.8,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":627.28000000000009},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":6900.08},41611322,"STATION OLIBYA ","EN COUR",0.1,2,"2016-04-05","2016-03-31"]
[12,"0586","GARDINNAGE",400,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":80},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":480},1111807,"CITEMAG","EN COUR",0.2,2,"2016-04-01","2016-03-12"]
[13,"2874","MARCHANDISE",64807.5,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":12961.5},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":77769},2330160,"PAST","001511742000081",0.2,2,"2016-04-21","2016-03-17"]
[14,"0257","MARCHANDISE",46250,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":9250},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":55500},2800559,"EBELLE","001514332000088",0.2,2,"2016-04-13","2016-02-11"]
[15,"0266","MARCHANDISE",18750,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":3750},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":22500},40182429,"ASMAR","EN COUR",0.2,2,"2016-04-11","2016-03-04"]
[16,"2426","MARCHANDISE",149571.9,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":29914.38},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":179486.28},4902802,"BEL MAROC","001530549000087",0.2,5,"2016-04-13","2016-03-11"]
[17,"2402","MARCHANDISE",44528,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":8905.6},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":53433.599999999999},4902802,"BEL MAROC","001530549000087",0.2,5,"2016-04-07","2016-03-10"]
[18,"7602","MARCHANDISE",30240,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":6048},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":36288},4200627,"LES CONSERVES PM","001529756000061",0.2,5,"2016-04-28","2016-03-05"]
[19,"1719","MARCHANDISE",112146.1,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":22429.22},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":134575.32},3502802,"BEL MAROC PM","001530549000087",0.2,5,"2016-04-06","2016-03-04"]
[20,"5420","TELEPHONE",429.17,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":85.834000000000003},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":515.00400000000002},3332162,"IAM","001522585000066",0.2,2,"2016-04-22","2016-03-11"]
[21,"9064","TELEPHONE",335.67,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":67.134},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":402.80400000000003},3332162,"IAM","001522585000066",0.2,2,"2016-04-22","2016-04-01"]
[22,"9063","TELEPHONE",242.96,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":48.592000000000006},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":291.55200000000002},3332162,"IAM","001522585000066",0.2,2,"2016-04-22","2016-04-01"]
[23,"9065","INTERNET",165,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":33},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":198},3332162,"IAM","001522585000066",0.2,2,"2016-04-22","2016-04-01"]
[24,"9068","TELEPHONE",375.64,{"$f":"+Tableau5[[#This Row],[M_HT]]*Tableau5[[#This Row],[TAUX]]","v":75.128},{"$f":"+Tableau5[[#This Row],[M_HT]]+Tableau5[[#This Row],[TVA]]","v":450.76799999999997},3332162,"IAM","001522585000066",0.2,2,"2016-04-22","2016-04-01"]
["Total",null,null,{"$f":"SUBTOTAL(109,Tableau5[M_HT])","v":1254421.9099999997},{"$f":"SUBTOTAL(109,Tableau5[TVA])","v":202617.829},{"$f":"SUBTOTAL(109,Tableau5[M_TTC])","v":1457039.7389999998},null,null,null,null,null,null,null,null,null,2017,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,12]