{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CG","Planning"],"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":"CG","index":0,"n_rows":51,"n_cols":27,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,8,0,9],[6,8,6,9]]}
[null,null,"Etat","Nb",null,"Origine du contact","Nb",null,"Rendez-vous obtenu par mailing",null,null,"Délais de réponse moyen",null,"Nombre moyen d'AVP",null,null,"% moyen de MB"]
[null,null,"En cours",{"$f":"COUNTIF(Tableau1[[#All],[Etat]],\"En cours\")","v":16},null,"LP",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"LP\")","v":2},null,"Oui",{"$f":"COUNTIFS(Tableau1[[#All],[Premier RDV obtenu]],\"Oui\",Tableau1[[#All],[Origine du contact]],\"Mailing\")","v":3},null,{"$f":"AVERAGE(Tableau1[[#All],[Délais de réponse]])","v":"1900-01-01T14:44:59.944"},null,{"$f":"AVERAGE(Tableau1[Nb AVP])","v":7.666666666666667},null,null,{"$f":"AVERAGE(Tableau1[% Marge brute])","v":0.13500000000000001}]
[null,null,"Stand by",{"$f":"COUNTIF(Tableau1[[#All],[Etat]],\"Stand by\")","v":6},null,"Site TC",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Site TC\")","v":1},null,"Non",{"$f":"COUNTIFS(Tableau1[[#All],[Premier RDV obtenu]],\"Non\",Tableau1[[#All],[Origine du contact]],\"Mailing\")","v":3}]
["logo",null,"Abandon",{"$f":"COUNTIF(Tableau1[[#All],[Etat]],\"Abandon\")","v":5},null,"Site SV",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Site SV\")","v":5},null,"En attente",{"$f":"COUNTIFS(Tableau1[[#All],[Origine du contact]],\"Mailing\",Tableau1[[#All],[Premier RDV obtenu]],\"\")","v":2},null,"Montant moyen du 1er chiffrage",null,"Nb moyen de RDV (global)",null,null,"Nb moyen de RDV affaires signés"]
[null,null,"Signé",{"$f":"COUNTIF(Tableau1[[#All],[Etat]],\"Signé\")","v":2},null,"Tel",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Tel\")","v":4},null,"Total",{"$f":"SUM(J2:J4)","v":8},null,{"$f":"AVERAGE(Tableau1[Montant du 1er estimation])","v":1377603.5},null,{"$f":"AVERAGE(Tableau1[Nb RDV])","v":6.5},null,null,{"$f":"AVERAGEIFS(Tableau1[Nb RDV],Tableau1[Etat],\"Signé\")","v":7}]
[null,null,"Vide",{"$f":"COUNTIF(Tableau1[[#All],[Etat]],\"\")","v":9},null,"Mail",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Mail\")","v":0}]
[null,null,"Total",{"$f":"SUM(D2:D6)","v":38},null,"Geotruc",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Geotruc\")","v":3},null,"Rendez -vous obtenu (global)",null,null,"Montant moyen à la signature",null,"Somme marge brute générer"]
[null,null,null,null,null,"Mailing",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Mailing\")","v":8},null,"Oui",{"$f":"COUNTIF(Tableau1[[#All],[Premier RDV obtenu]],\"Oui\")","v":9},null,{"$f":"AVERAGE(Tableau1[Montant à la signature])","v":1345096.6666666667},null,{"$f":"SUM(Tableau1[Marge brute])","v":1049268}]
[null,null,null,null,null,"Réseau",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"Réseau\")","v":2},null,"Non",{"$f":"COUNTIF(Tableau1[[#All],[Premier RDV obtenu]],\"Non\")","v":9}]
[null,null,null,null,null,"Vide",{"$f":"COUNTIF(Tableau1[[#All],[Origine du contact]],\"\")","v":13},null,"En attente",{"$f":"COUNTIF(Tableau1[[#All],[Premier RDV obtenu]],\"\")","v":20},null,"Delta 1er chiffrage et signature (%)"]
[null,null,null,null,null,"Total",{"$f":"SUM(G2:G10)","v":38},null,"Total",{"$f":"SUM(J8:J10)","v":38},null,{"$f":"L8/L5","v":0.97640334585870803}]
[]
["N° affaire","Etat","Entreprise","Noms ","Adresse","Telephone","Adresse mail","Date","Origine du contact","Code APE","CA","Resultat","Effectif","EBE","Projet","Premier RDV obtenu","Date du rappel","Délais de réponse","Commentaire","Montant du 1er estimation","Nb AVP","Nb RDV","Volume horaire","Montant à la signature","Date de signature","% Marge brute","Marge brute"]
[null,null,"aaa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X14*Z14","v":0}]
[null,null,"hhdfhhef",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X15*Z15","v":0}]
[null,null,"uhç",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X16*Z16","v":0}]
[null,null,"iuybib",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X17*Z17","v":0}]
[null,"Stand by","szs",null,null,null,null,"2019-04-04T09:46:43",null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X18*Z18","v":0}]
[null,null,"gsgds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X19*Z19","v":0}]
[null,"En cours","giugouggohoph",null,null,null,null,"2019-04-02T14:26:09","Site TC",null,null,null,null,null,null,"Oui","2019-04-04T09:46:53",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T19:20:44"},null,null,null,null,null,null,null,null,{"$f":"X20*Z20","v":0}]
[null,"En cours","giygigiu",null,null,null,null,"2019-04-02T14:25:14",null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,43557.720694444448,null,0]
[null,null,"tdtyyt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,43557.721030092594,null,0]
[null,null,"yiuiuobouihoi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[null,null,"jiojoin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[848,"En cours","rggsgd",null,null,null,null,"2019-03-28T15:31:10","Tel",null,null,null,null,null,null,"Oui","2019-03-29T17:32:39",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T02:01:29"},null,null,null,null,null,null,null,null,{"$f":"X26*Z26","v":0}]
[null,"Stand by","sdsqsqqs",null,null,null,null,"2019-03-28T16:04:01","Site SV",null,null,null,null,null,null,"Oui","2019-03-29T17:32:36",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:28:35"},null,null,null,null,null,null,null,null,0]
[null,"Signé","boby",null,null,null,null,"2019-03-28T16:04:04","Mailing",null,null,null,null,null,null,"Oui","2019-03-29T17:32:42",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:28:38"},null,null,null,6,null,null,null,null,0]
[null,"Signé","CC",null,null,null,null,"2019-03-28T15:30:50","LP",null,null,null,null,null,null,"Non","2019-03-29T17:30:29",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:59:39"},null,null,null,8,null,null,null,null,0]
[64,"En cours",null,null,null,null,null,"2019-03-28T16:04:18","Mailing",null,null,null,null,null,null,"Oui","2019-03-29T17:32:45",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:28:27"},null,null,null,null,null,null,null,null,0]
[65,"Abandon","m",null,null,null,null,"2019-03-28T16:04:23","Mailing",null,null,null,null,null,null,"Non","2019-03-29T17:30:26",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:26:03"},null,null,null,null,null,null,null,null,0]
[203,"Abandon","mid","ff","efe","fe",null,"2019-03-28T15:31:07","Site SV",null,null,null,null,null,null,"Non","2019-03-29T17:30:24",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:59:17"},null,null,null,null,null,null,null,null,{"$f":"X32*Z32","v":0}]
[102,"En cours","rod",null,null,null,null,"2019-04-01T11:54:50","Site SV",null,null,null,null,null,null,"Non","2019-04-01T11:54:54",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"00:00:04"},null,null,null,null,null,null,null,null,{"$f":"X33*Z33","v":0}]
[99,"En cours","WW",null,"fdf",null,null,"2019-03-29T17:06:04",null,null,null,null,12,null,null,"Oui","2019-04-01T11:54:59",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-02T18:48:55"},null,null,null,null,null,null,null,null,{"$f":"X34*Z34","v":0}]
[21,"Stand by","UU",null,null,null,null,"2019-03-28T15:31:44","Mailing","ddff",50000,null,null,51151,null,"Oui","2019-03-29T17:35:31",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T02:03:47"},"cool",15898,6,5,8,15000,null,0.16,{"$f":"X35*Z35","v":2400}]
[58,"Abandon","MM",null,null,null,null,"2019-03-28T15:31:50","Mailing",null,null,null,null,5151,null,"Non","2019-04-01T08:38:29",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-03T17:06:39"},null,null,null,null,null,null,null,null,{"$f":"X36*Z36","v":0}]
[88,"En cours","Lidl",null,null,null,null,"2019-03-28T15:32:06","Geotruc",null,null,5151,null,null,null,"Oui","2019-03-29T17:03:06",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:31:00"},"pas cool",48894,4,6,4,45000,null,0.12,{"$f":"X37*Z37","v":5400}]
[77,"En cours","Mcdo","fsdfdf","ezfzef",null,null,"2019-03-28T15:31:57","Tel",null,null,null,null,648,null,"Oui","2019-04-01T08:38:32",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-03T17:06:35"},null,null,null,null,null,null,null,null,{"$f":"X38*Z38","v":0}]
[84,"En cours","II",null,null,null,null,"2019-03-28T15:31:54","Site SV",null,null,null,15,null,null,"Non","2019-03-29T17:03:10",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-01T01:31:16"},null,null,null,null,null,null,null,null,{"$f":"X39*Z39","v":0}]
[94,"En cours","HH",null,null,null,null,"2019-03-28T15:31:52","Tel",null,null,null,null,null,null,"Non","2019-04-01T08:38:07",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-03T17:06:15"},"top",684,12,10,12,600,null,0.11,{"$f":"X40*Z40","v":66}]
[25,"En cours","FF",null,null,null,null,null,"Tel",null,75885,null,null,98466,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X41*Z41","v":0}]
[68,"Stand by","EE",null,null,null,null,null,"Geotruc",null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X42*Z42","v":0}]
[74,"Abandon","DD",null,null,null,"zefzef",null,null,null,null,null,60,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},"riche",8189818,15,12,16,8000000,null,0.13,{"$f":"X43*Z43","v":1040000}]
[98,"En cours","CC",null,null,null,null,"2019-04-01T08:37:31","Mailing",null,5151,null,null,null,null,"Non","2019-04-01T08:38:44",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"00:01:13"},null,null,null,null,null,null,null,null,{"$f":"X44*Z44","v":0}]
[31,"En cours","BB",null,null,null,null,null,"Mailing",null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,{"$f":"X45*Z45","v":0}]
[32,"En cours","AA",null,"ezfzef",null,null,null,"Mailing",null,null,null,null,89499,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},"pauvre",9843,3,2,8,9500,null,0.14000000000000001,1330.0000000000002]
[33,"Abandon","Jack","zzfzf",null,null,null,null,"Réseau",null,null,151,20,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[36,"En cours","Puto",null,null,null,null,null,"LP",null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[59,"Stand by","Donald",null,null,null,null,"2019-03-29T17:37:24","Site SV",null,null,null,14,null,null,"Non","2019-04-01T08:38:47",{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":"1900-01-02T15:01:23"},"copain",484,6,3,4,480,null,0.15,72]
[95,"Stand by","Mini",null,null,null,null,null,"Geotruc",null,null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]
[2,"En cours","Mickey",null,null,null,null,null,"Réseau",null,null,null,10,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date du rappel]]=\"\",\"\",Tableau1[[#This Row],[Date du rappel]]-Tableau1[[#This Row],[Date]])","v":""},null,null,null,null,null,null,null,null,0]

{"sheet":"Planning","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["N° affaire","Etat","Entreprise","Semaine 1","Semaine 2","Semaine 3","Semaine 4","Semaine 5","Semaine 6","Semaine 7"]
[null,null,"aaa",2]
[null,null,"hhdfhhef",null,3]
[null,null,"uhç",null,null,4]
[null,null,"iuybib"]
[null,"Stand by","szs"]
[null,null,"gsgds"]
[null,"En cours","giugouggohoph"]
[null,"En cours","giygigiu"]
[null,null,"tdtyyt"]
[null,null,"yiuiuobouihoi"]
[null,null,"jiojoin"]
[]
[848,"En cours","rggsgd"]
[null,"Stand by","sdsqsqqs"]
[null,"Signé","boby"]
[null,"Signé","CC"]
[64,"En cours"]
[65,"Abandon","m"]
[203,"Abandon","mid"]
[102,"En cours","rod"]
[99,"En cours","WW"]
[21,"Stand by","UU"]
[58,"Abandon","MM"]
[88,"En cours","Lidl"]
[77,"En cours","Mcdo"]
[84,"En cours","II"]
[94,"En cours","HH"]
[25,"En cours","FF"]
[68,"Stand by","EE"]
[74,"Abandon","DD"]
[98,"En cours","CC"]
[31,"En cours","BB"]
[32,"En cours","AA"]
[33,"Abandon","Jack"]
[36,"En cours","Puto"]
[59,"Stand by","Donald"]
[95,"Stand by","Mini"]
[2,"En cours","Mickey"]