{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Tableau de bord","source","liste","analyse"],"not_rendered":{"charts":4,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Tableau de bord","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"source","index":1,"n_rows":12,"n_cols":17,"rows_kept":12}
["Société","Adresse","Pays","secteur d'activite","Nom","Prénom","Fonction","numéro de téléphone","Adresse mail","Status","Quantite","Type d'abonn","Date début","Date de fin","Type de paiement","Montant","Commentaire"]
["a","a","a","a","a","a","a","a","a","a","a","a","a","a","a"]
["b","b","b","b","b","b","b","b","b","b","b","b","b","b","b","a"]
["c","c","c","c","c","c","c","c","c","c","c","c","c","c","c","b"]
["d","d","d","d","d","d","d","d","d","d","d","d","d","d","d","c"]
["e","e","e","e","e","e","e","e","e","e","e","e","e","e","e","d"]
["f","f","f","f","f","f","f","f","f","f","f","f","f","f","f","e"]
["g","g","g","g","g","g","g","g","g","g","g","g","g","g","g","f"]
["h","h","h","h","h","h","h","h","h","h","h","h","h","h","h","g"]
["i","i","i","i","i","i","i","i","i","i","i","i","i","i","i","h"]
["j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","i"]
[{"$nulls":15},"j"]

{"sheet":"liste","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"hidden":true}
["Status",null,"Type d'abonn",null,"Type de paiement"]
["abonné",null,"serv1",null,"Virement bancaire"]
["annulé",null,"serv2",null,"Cheque"]
["desabonné",{"$nulls":3},"Espèce"]
[{"$nulls":4},"Espèce SG"]

{"sheet":"analyse","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"hidden":true}
["nombre bd",{"$f":"COUNTA(Tableau5[Status])","v":10}]
["abonnees",{"$f":"COUNTIF(Tableau5[Status],source!J23)","v":0}]
["desabonnees",{"$f":"COUNTIF(source!J:J,source!J4)","v":1}]
[]
["service1",{"$f":"COUNTIF(source!L:L,source!L4)","v":1}]
["service2",{"$f":"COUNTIF(source!L:L,source!L3)","v":1}]
[]
["Virement bancaire",{"$f":"COUNTIF(source!O:O,source!O3)","v":1}]
["Cheque",{"$f":"COUNTIF(source!O:O,source!O11)","v":1}]
["Espèce",{"$f":"COUNTIF(source!O:O,source!O19)","v":0}]
["Espèce SG",{"$f":"COUNTIF(source!O:O,source!O6)","v":1}]
[]
["Ici",{"$f":"COUNTIF(source!C:C,source!C2)","v":1}]
["Etranger",{"$f":"COUNTIF(source!C:C,source!C16)","v":0}]