{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"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":"Feuil1","index":0,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,2],[9,2,9,3],[9,0,9,1]]}
[null,null,null,"Date d'effet :","2021-07-01","Taux",0.1,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,"Magasin","Z",null,null,null,null,null,null,null,null,null,"Z"]
[]
[null,null,"Valeur","Ristourne"]
["Article",null,7,1,{"$f":"C6*D6","v":7}]
[]
["Total Valeur",null,{"$f":"C6","v":7},null,{"$f":"E6","v":7}]
[]
["Valeur à prendre en compte - La Valeur à prendre en compte est la cellule E10 (saisie manuelle). A défaut, c'est la cellule C10 ",null,{"$f":"C8","v":7}]
[]
["Montant Net",null,null,null,{"$f":"E8","v":7}]
["Frais Magasin",null,"Taux :",{"$f":"IF(E10 =\"\",IF(E3=\"Z\",IF(C10<6,0,IF(AND(C10>=6,C10<20),0.06,IF(AND(C10>=20,C10<50),0.12,0.18))),IF(E3=\"X\",IF(C10<6,0,IF(AND(C10>=6,C10<20),0.07,IF(AND(C10>=20,C10<50),0.14,0.21))),\"Inconnu?\")),IF(E3=\"Z\",IF(E10<6,0,IF(AND(E10>=6,E10<20),0.06,IF(AND(E10>=20,E10<50),0.12,0.18))),IF(E3=\"X\",IF(E10<6,0,IF(AND(E10>=6,E10<20),0.07,IF(AND(E10>=20,E10<50),0.14,0.21))),\"Inconnu?\")))","v":0.06},{"$f":"E12*D13","v":0.42}]
["MONTANT TOTAL",null,null,null,{"$f":"SUM(E12:E13)","v":7.42}]
[]
[]
[]
["Détail des frais par magasin :"]
[null,"Magasin X"]
[null,"- moins de 6€ --> pas de frais"]
[null,"- de 6 à 20€ --> 7% de frais"]
[null,"- de 20 à 50€ --> 14% de frais"]
[null,"- Plus de 50 € --> 21% de frais"]
[]
[null,"Magasin Y"]
[null,"- moins de 6€ --> pas de frais"]
[null,"- de 6 à 20€ --> 7,63% de frais"]
[null,"- de 20 à 50€ --> 15,26% de frais"]
[null,"- Plus de 50 € --> 22,89% de frais"]
[]
[null,"Magasin Z :"]
[null,"- moins de 6€ --> pas de frais"]
[null,"- de 6 à 20€ --> 6% de frais"]
[null,"- de 20 à 50€ --> 12% de frais"]
[null,"- Plus de 50 € --> 18% de frais"]