{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VENTES","TOTAL"],"not_rendered":{"charts":0,"images":0,"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":"VENTES","index":0,"n_rows":180,"n_cols":14,"rows_kept":180,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"$","VENDU",null,null,null,null,null,null,null," "]
[null,null,null,null,"USD",10,null,"TOTAL 1",{"$f":"SOMME_SI_COULEUR($F$2:$F$180,H2)","v":5093.58}]
[null,null,null,null,"USD",100,null,"TOTAL 2",{"$f":"SOMME_SI_COULEUR($F$2:$F$180,H3)","v":1686.04}]
[null,null,null,null,"USD",30,null,"TOTAL 3",{"$f":"SOMME_SI_COULEUR($F$2:$F$180,H4)","v":4222.75}]
[null,null,null,null,"USD",48,null,"TOTAL 4",{"$f":"SOMME_SI_COULEUR($F$2:$F$180,H5)","v":260}]
[null,null,null,null,"USD",50,null,"TOTAL 5",{"$f":"SOMME_SI_COULEUR($F$2:$F$180,H6)","v":154}]
[null,null,null,null,"USD",33,null,"TOTAL 6"]
[null,null,null,null,"USD",50,null,"TOTAL 7"]
[null,null,null,null,"USD",62,null,"TOTAL 8"]
[null,null,null,null,"USD",20,null,"TOTAL 9"]
[null,null,null,null,"USD",10,null,"TOTAL 10"]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",25,null,"La fonction personnalisée se trouve dans le module1"]
[null,null,null,null,"USD",38,null,"Il y a des explications dans le module"]
[null,null,null,null,"USD",48,null,"La fonction doit contenir comme paramètres :"]
[null,null,null,null,"USD",20,null,"- la plage à compter (ici $F$2:$F$180)"]
[null,null,null,null,"USD",50,null,"- la cellule contenant la couleur à tester (ici H2 volatile donc quand on duplique la cellule par tirage, elle s'adapte pour tester H3 ; H4 etc…"]
[null,null,null,null,"USD",15,null,"Si plus de couleur nécessaire : "]
[null,null,null,null,"USD",40,null,"- mettre en couleur une cellule dans la colonne H et dupliquer avec le pinceau la mise en forme dans la colonne F pour les différrentes cellules impliquées"]
[null,null,null,null,"USD",130,null,"ainsi on est certan d'utiliser la même couleur"]
[null,null,null,null,"USD",120,null,"- dupliquer la fonction dans la colonne I (I5 vers I6…) autant de fois que nécessaire)"]
[null,null,null,null,"USD",28]
[null,null,null,null,"USD",25,null,"A noter que cette fonction ne peut réaliser son comptage que pour des couleurs mises manuellement"]
[null,null,null,null,"USD",15,null,"CELA NE FONCTIONNE PAS AVEC LA MISE EN FORME CONDITIONNELLE (EXCEL EST INCAPABLE DE TESTER LES COULEURS DE LA MEFC)"]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",90,null,"ATTENTION"]
[null,null,null,null,"USD",70,null,"Pour des raisons que seul Excel connait, la mise en couleur doit être faite par duplication à l'aide du pinceau (copie format d'une cellule répondant aux critères voulus vers une autre cellule"]
[null,null,null,null,"USD",40,null,"Si la mise en couleur est faite à partir de l'outil mise en couleur ou Format, il faudra impérativement lancer le calcul de la feuille en appuyant sur F9"]
[null,null,null,null,"USD",58,null,"En effet, le simple fait de mettre en couleur ne déclenche pas le recalcul de la feuille mais pour une raison que je ne connait pas, quand on procède avec le pinceau, le recalcul se fait"]
[null,null,null,null,"USD",30,null,"Cela marche également, mais c'est beaucoup plus long, si on fait copier/collage spécial/format"]
[null,null,null,null,"USD",38]
[null,null,null,null,"USD",52]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",23]
[null,null,null,null,"USD",37]
[null,null,null,null,"USD",75]
[null,null,null,null,"USD",40]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",39]
[null,null,null,null,"USD",42]
[null,null,null,null,"USD",17]
[null,null,null,null,"USD",240]
[null,null,null,null,"USD",110]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",72]
[null,null,null,null,"USD",85]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",90]
[null,null,null,null,"USD",45]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",34]
[null,null,null,null,"USD",75]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",62]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",85]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",40]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",27.5]
[null,null,null,null,"USD",15]
[null,null,null,null,"USD",32]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",32]
[null,null,null,null,"USD",65]
[null,null,null,null,"USD",45]
[null,null,null,null,"USD",65]
[null,null,null,null,"USD",22]
[null,null,null,null,"USD",17]
[null,null,null,null,"USD",15]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",28.5]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",65]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",18]
[null,null,null,null,"USD",65]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",60]
[null,null,null,null,"USD",81]
[null,null,null,null,"USD",80]
[null,null,null,null,"USD",30]
[null,null,null,null,"USD",10]
[null,null,null,null,"USD",75]
[null,null,null,null,"USD",10]
[null,null,null,null,"CAD",50]
[null,null,null,null,"USD",24]
[null,null,null,null,"USD",60]
[null,null,null,null,"CAD",70]
[null,null,null,null,"CAD",15]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",18]
[null,null,null,null,"CAD",55]
[null,null,null,null,"CAD",40]
[null,null,null,null,"CAD",25]
[null,null,null,null,"USD",68]
[null,null,null,null,"CAD",80]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",20]
[null,null,null,null,"CAD",15]
[null,null,null,null,"CAD",30]
[null,null,null,null,"USD",20]
[null,null,null,null,"USD",20]
[null,null,null,null,"CAD",35]
[null,null,null,null,"USD",76]
[null,null,null,null,"USD",120]
[null,null,null,null,"USD",41.04]
[null,null,null,null,"CAD",13]
[null,null,null,null,"EUR",260]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",50]
[null,null,null,null,"USD",20]
[null,null,null,null,"CAD",38]
[null,null,null,null,"CAD",25]
[null,null,null,null,"CAD",42]
[null,null,null,null,"USD",66]
[null,null,null,null,"USD",39]
[null,null,null,null,"USD",60]
[null,null,null,null,"USD",13]
[null,null,null,null,"CAD",275]
[null,null,null,null,"USD",180]
[null,null,null,null,"CAD",75]
[null,null,null,null,"CAD",60]
[null,null,null,null,"CAD",10]
[null,null,null,null,"CAD",25]
[null,null,null,null,"CAD",32]
[null,null,null,null,"USD",31]
[null,null,null,null,"USD",79.58]
[null,null,null,null,"USD",210]
[null,null,null,null,"CAD",32]
[null,null,null,null,"USD",25]
[null,null,null,null,"USD",40]
[null,null,null,null,"USD",275]
[null,null,null,null,"USD",22]
[null,null,null,null,"CAD",100]
[null,null,null,null,"CAD",20]
[null,null,null,null,"USD",200]
[null,null,null,null,"CAD",110]
[null,null,null,null,"CAD",40]
[null,null,null,null,"USD",70]
[null,null,null,null,"CAD",30]
[null,null,null,null,"CAD",38]
[null,null,null,null,"CAD",70]
[null,null,null,null,"CAD",191]
[null,null,null,null,"USD",82]
[null,null,null,null,"CAD",15]
[null,null,null,null,"CAD",30]
[null,null,null,null,"CAD",80]
[null,null,null,null,"CAD",170]
[null,null,null,null,"USD",200]
[null,null,null,null,"CAD",37]
[null,null,null,null,"CAD",418]
[null,null,null,null,"USD",20]
[null,null,null,null,"CAD",6]
[null,null,null,null,"USD",240]
[null,null,null,null,"CAD",39]
[null,null,null,null,"CAD",336]
[null,null,null,null,"USD",80]
[null,null,null,null,"CAD",80]
[null,null,null,null,"CAD",210]
[null,null,null,null,"USD",300]
[null,null,null,null,"CAD",18.75]
[null,null,null,null,"CAD",90]
[null,null,null,null,"USD",275]
[null,null,null,null,"CAD",13]
[null,null,null,null,"CAD",84]
[null,null,null,null,"CAD",90]
[null,null,null,null,"CAD",130]
[null,null,null,null,"CAD",80]
[null,null,null,null,"CAD",150]
[null,null,null,null,"CAD",90]
[null,null,null,null,"CAD",90]

{"sheet":"TOTAL","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["$","$","€"]