{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Tableau de Bord","TCD","Données de Ventes","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Tableau de Bord","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TCD","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Somme de CA HT","Étiquettes de colonnes"]
["Étiquettes de lignes","Dentiste","Parapharmacie","Pharmacie","(vide)","Total général"]
["2021-01-01",510.99,null,887.48,null,1398.47]
["2021-01-04",564.16000000000008,null,833.04,null,1397.2]
["2021-01-05",719.84,603.67999999999995,1473.68,null,2797.2]
["2021-01-06",876.66000000000008,null,4460.12,null,5336.78]
["2021-01-07",500,null,1843.55,null,2343.5500000000002]
["2021-01-08",63.5,null,1284.8899999999999,null,1348.3899999999999]
["2021-01-11",2308.5599999999995,null,287.56,null,2596.1199999999994]
["2021-01-12",225,null,642.96,null,867.96]
["2021-01-13",1096.27,null,357.44,null,1453.71]
["2021-01-14",352.70000000000005,null,1194.47,null,1547.17]
["2021-01-15",1669.1,null,1430.26,null,3099.3599999999997]
["2021-01-18",231.04,null,264.8,null,495.84000000000003]
["2021-01-19",1025.19,null,389.52,null,1414.71]
["2021-01-20",1400,null,null,null,1400]
["2021-01-21",1518.1399999999999,null,1767.6399999999999,null,3285.7799999999997]
["2021-01-22",343.9,null,967.2,null,1311.1]
["2021-01-24",211.82,null,null,null,211.82]
["2021-01-25",250,null,1707.72,null,1957.72]
["2021-01-26",955.99,null,663.84,null,1619.83]
["2021-01-27",null,null,562.88,null,562.88]
["2021-01-28",1240.56,null,820.68000000000006,null,2061.2399999999998]
["2021-01-29",664.87,null,734.88,null,1399.75]
["(vide)"]
["Total général",16728.289999999997,603.67999999999995,22574.610000000004,null,39906.579999999987]

{"sheet":"Données de Ventes","index":2,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Date","Nom du  client","Code postal","Type de Client","Ouverture","CA HT","Max","Min"]
["2021-01-01",null,59650,"Dentiste","Oui",439.79,{"$f":"IF(F2=MAX($F$2:$F$125),F2,0)","v":0}]
["2021-01-01",null,"68000","Dentiste","Non",71.2,{"$f":"IF(F3=MAX($F$2:$F$125),F3,0)","v":0},null,null,"Total Dentiste",{"$f":"SUMIF(D:D,\"Dentiste\",F:F)","v":16728.290000000005}]
["2021-01-01",null,56700,"Pharmacie","Oui",361.8,0,null,null,"Total Pharmacie",{"$f":"SUMIF(D:D,\"Pharmacie\",F:F)","v":22574.610000000008}]
["2021-01-01",null,"33600","Pharmacie","Non",525.67999999999995,0,null,null,"Total Parapharmacie",{"$f":"SUMIF(D:D,\"Parapharmacie\",F:F)","v":603.67999999999995}]
["2021-01-04",null,67360,"Dentiste","Oui",166.43,0]
["2021-01-04",null,44000,"Dentiste","Non",397.73,0]
["2021-01-04",null,83530,"Pharmacie","Oui",572.16,0]
["2021-01-04",null,25500,"Pharmacie","Non",260.88,0]
["2021-01-05",null,54000,"Dentiste","Oui",96.12,0]
["2021-01-05",null,6600,"Dentiste","Non",151.30000000000001,0]
["2021-01-05",null,85710,"Dentiste","Oui",151.30000000000001,0]
["2021-01-05",null,59780,"Dentiste","Non",96.12,0]
["2021-01-05",null,31450,"Dentiste","Oui",225,0]
["2021-01-05",null,21600,"Dentiste","Non"," 471,80€",0]
["2021-01-05",null,"54000","Pharmacie","Oui",219,0]
["2021-01-05",null,59560,"Pharmacie","Non",635.32000000000005,0]
["2021-01-05",null,6400,"Pharmacie","Oui"," 501,11€",0]
["2021-01-05",null,44150,"Pharmacie","Non",619.36,0]
["2021-01-05",null,31000,"Parapharmacie","Oui",603.67999999999995,0]
["2021-01-06",null,"06240","Dentiste","Oui",412.56,0]
["2021-01-06",null,"85710","Dentiste","Non",35.6,0]
["2021-01-06",null,"62110","Dentiste","Oui",428.5,0]
["2021-01-06",null,"50230","Pharmacie","Non",631.36,0]
["2021-01-06",null,"35650","Pharmacie","Oui",243.72,0]
["2021-01-06",null,"18000","Pharmacie","Non",279,0]
["2021-01-06",null,"56270","Pharmacie","Oui",335.12,0]
["2021-01-06",null,"63170","Pharmacie","Non",958,0]
["2021-01-06",null,"59240","Pharmacie","Oui",242.64,0]
["2021-01-06",null,"17000","Pharmacie","Non",504.56,0]
["2021-01-06",null,"24750","Pharmacie","Oui",1117.04,0]
["2021-01-06",null,"06600","Pharmacie","Non",148.68,0]
["2021-01-07",null,"82200","Dentiste","Non",250,0]
["2021-01-07",null,"33000","Dentiste","Oui",250,0]
["2021-01-07",null,"17530","Pharmacie","Oui",171.35,0]
["2021-01-07",null,"56170","Pharmacie","Non",457.2,0]
["2021-01-07",null,"86410","Pharmacie","Oui",197.04,0]
["2021-01-07",null,"98000","Pharmacie","Non",1017.96,0]
["2021-01-08",null,"33600","Dentiste","Non",63.5,0]
["2021-01-08",null,"68000","Pharmacie","Oui",595.79999999999995,0]
["2021-01-08",null,"62000","Pharmacie","Non",689.09,0]
["2021-01-11",null,"29500","Dentiste","Oui",447.86,0]
["2021-01-11",null,"13090","Dentiste","Non",285.12,0]
["2021-01-11",null,"59560","Dentiste","Oui",151.30000000000001,0]
["2021-01-11",null,"10120","Dentiste","Non",151.30000000000001,0]
["2021-01-11",null,"44690","Dentiste","Oui",181.56,0]
["2021-01-11",null,"67000","Dentiste","Non",302.60000000000002,0]
["2021-01-11",null,"49100","Dentiste","Oui",251.35,0]
["2021-01-11",null,"59480","Dentiste","Non",250,0]
["2021-01-11",null,"34980","Dentiste","Oui",287.47000000000003,0]
["2021-01-11",null,"44350","Pharmacie","Oui",287.56,0]
["2021-01-12",null,"13810","Dentiste","Non",112.5,0]
["2021-01-12",null,"44000","Dentiste","Oui",112.5,0]
["2021-01-12",null,"35580","Pharmacie","Non",398.28,0]
["2021-01-12",null,"44700","Pharmacie","Oui",244.68,0]
["2021-01-13",null,"34000","Dentiste","Non",226.95,0]
["2021-01-13",null,"41150","Dentiste","Oui",257.10000000000002,0]
["2021-01-13",null,"64000","Dentiste","Non",343.8,0]
["2021-01-13",null,"67000","Dentiste","Oui",235.72,0]
["2021-01-13",null,"66700","Dentiste","Non",32.700000000000003,0]
["2021-01-13",null,"63200","Pharmacie","Non",357.44,0]
["2021-01-14",null,"83000","Dentiste","Oui",144.18,0]
["2021-01-14",null,"17300","Dentiste","Non",208.52,0]
["2021-01-14",null,"59000","Pharmacie","Oui",342.36,0]
["2021-01-14",null,"31600","Pharmacie","Non",165.27,0]
["2021-01-14",null,"85620","Pharmacie","Oui",386.64,0]
["2021-01-14",null,"56100","Pharmacie","Non",300.2,{"$f":"IF(F67=MAX($F$2:$F$125),F67,0)","v":0}]
["2021-01-15",null,"66700","Dentiste","Oui",151.30000000000001,0]
["2021-01-15",null,"86240","Dentiste","Non",128.16,0]
[null,null,null,null,"Oui",null,0]
[null,null,null,null,"Non",null,0]
[null,null,null,null,"Oui",null,0]
[null,null,null,null,"Non",null,0]
["2021-01-15",null,"56300","Dentiste","Oui",47.88,0]
["2021-01-15",null,"09700","Dentiste","Non",741.12,0]
["2021-01-15",null,"64140","Dentiste","Oui",368.52,0]
["2021-01-15",null,"62161","Dentiste","Non",96.12,0]
["2021-01-15",null,"26100","Dentiste","Oui",136,0]
["2021-01-15",null,"65170","Pharmacie","Oui",152.28,0]
["2021-01-15",null,"09700","Pharmacie","Non",1277.98,1277.98]
["2021-01-18",null,"62180","Dentiste","Non",131.04,0]
["2021-01-18",null,"54000","Dentiste","Oui",100,0]
["2021-01-18",null,"44140","Pharmacie","Oui",264.8,0]
["2021-01-19",null,"17530","Dentiste","Non",107.02,0]
["2021-01-19",null,"59780","Dentiste","Oui",151.30000000000001,0]
["2021-01-19",null,"33160","Dentiste","Non",257.20999999999998,0]
["2021-01-19",null,"02300","Dentiste","Oui",328.1,0]
["2021-01-19",null,"44690","Dentiste","Non",181.56,0]
["2021-01-19",null,"34980","Pharmacie","Non",361.64,0]
["2021-01-19",null,"83500","Pharmacie","Oui",27.88,0]
["2021-01-20",null,"86240","Dentiste","Oui",112.14,0]
["2021-01-20",null,"71100","Dentiste","Non",522,0]
["2021-01-20",null,"31220","Dentiste","Oui",765.86,0]
["2021-01-21",null,"06330","Dentiste","Non",128.85,0]
["2021-01-21",null,"12300","Dentiste","Oui",10.9,0]
["2021-01-21",null,"84000","Dentiste","Non",146,0]
["2021-01-21",null,"67000","Dentiste","Oui",603.87,0]
["2021-01-21",null,"31100","Dentiste","Non",628.52,0]
["2021-01-21",null,"57000","Pharmacie","Non",749.68,0]
["2021-01-21",null,"98000","Pharmacie","Oui",1017.96,0]
["2021-01-22",null,"29480","Dentiste","Oui",192.6,0]
["2021-01-22",null,"17400","Dentiste","Non",151.30000000000001,0]
["2021-01-22",null,"67400","Pharmacie","Non",372.48,0]
["2021-01-22",null,"63400","Pharmacie","Oui",222.2,0]
["2021-01-22",null,"06400","Pharmacie","Non",372.52,0]
["2021-01-24",null,"59400","Dentiste","Oui",211.82,0]
["2021-01-25",null,"54760","Dentiste","Non",250,0]
["2021-01-25",null,"21000","Pharmacie","Oui",439.4,0]
["2021-01-25",null,"63000","Pharmacie","Non",242.64,0]
["2021-01-25",null,"31770","Pharmacie","Oui",485.2,0]
["2021-01-25",null,"71100","Pharmacie","Non",540.48,0]
["2021-01-26",null,"17640","Dentiste","Oui",287.47000000000003,0]
["2021-01-26",null,"25200","Dentiste","Non",668.52,0]
["2021-01-26",null,"59800","Pharmacie","Oui",663.84,0]
["2021-01-27",null,"34800","Pharmacie","Non",562.88,0]
["2021-01-28",null,"35000","Dentiste","Oui",275.39999999999998,0]
["2021-01-28",null,"56300","Dentiste","Non",662.56,0]
["2021-01-28",null,"83320","Dentiste","Oui",151.30000000000001,0]
["2021-01-28",null,"31860","Dentiste","Non",151.30000000000001,0]
["2021-01-28",null,"46600","Pharmacie","Oui",435.48,0]
["2021-01-28",null,"26200","Pharmacie","Non",385.2,0]
["2021-01-29",null,"83000","Dentiste","Oui",611.47,0]
["2021-01-29",null,"31650","Dentiste","Non",53.4,0]
["2021-01-29",null,"31770","Pharmacie","Oui",442.2,0]
["2021-01-29",null,"68700","Pharmacie","Non",292.68,0]

{"sheet":"Janvier","index":3,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DATE","CA HT"]
["2021-01-01",{"$f":"SUMIFS('Données de Ventes'!F:F,'Données de Ventes'!A:A,44197)","v":1398.4699999999998}]
[{"$f":"WORKDAY($A2,1)","v":"2021-01-04"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-01-05"}]
["2021-01-06"]
["2021-01-07"]
["2021-01-08"]
["2021-01-11"]
["2021-01-12"]
["2021-01-13"]
["2021-01-14"]
["2021-01-15"]
["2021-01-18"]
["2021-01-19"]
["2021-01-20"]
["2021-01-21"]
["2021-01-22"]
["2021-01-25"]
["2021-01-26"]
["2021-01-27"]
["2021-01-28"]
["2021-01-29"]

{"sheet":"Février","index":4,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-02-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-02-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-02-03"}]
["2021-02-04"]
["2021-02-05"]
["2021-02-08"]
["2021-02-09"]
["2021-02-10"]
["2021-02-11"]
["2021-02-12"]
["2021-02-15"]
["2021-02-16"]
["2021-02-17"]
["2021-02-18"]
["2021-02-19"]
["2021-02-22"]
["2021-02-23"]
[{"$f":"WORKDAY($A18,1)","v":"2021-02-24"}]
["2021-02-25"]
["2021-02-26"]

{"sheet":"Mars","index":5,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Date"]
["2021-03-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-03-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-03-03"}]
["2021-03-04"]
["2021-03-05"]
["2021-03-08"]
["2021-03-09"]
["2021-03-10"]
["2021-03-11"]
["2021-03-12"]
["2021-03-15"]
["2021-03-16"]
["2021-03-17"]
["2021-03-18"]
["2021-03-19"]
["2021-03-22"]
["2021-03-23"]
["2021-03-24"]
["2021-03-25"]
["2021-03-26"]
["2021-03-29"]
["2021-03-30"]
["2021-03-31"]

{"sheet":"Avril","index":6,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-04-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-04-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-04-05"}]
["2021-04-06"]
["2021-04-07"]
["2021-04-08"]
["2021-04-09"]
["2021-04-12"]
["2021-04-13"]
["2021-04-14"]
["2021-04-15"]
["2021-04-16"]
["2021-04-19"]
["2021-04-20"]
["2021-04-21"]
["2021-04-22"]
["2021-04-23"]
["2021-04-26"]
["2021-04-27"]
["2021-04-28"]
["2021-04-29"]
[{"$f":"WORKDAY($A22,1)","v":"2021-04-30"}]

{"sheet":"Mai","index":7,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-05-03"]
[{"$f":"WORKDAY($A2,1)","v":"2021-05-04"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-05-05"}]
["2021-05-06"]
["2021-05-07"]
["2021-05-10"]
["2021-05-11"]
["2021-05-12"]
["2021-05-13"]
["2021-05-14"]
["2021-05-17"]
["2021-05-18"]
["2021-05-19"]
["2021-05-20"]
["2021-05-21"]
["2021-05-24"]
["2021-05-25"]
["2021-05-26"]
["2021-05-27"]
["2021-05-28"]
["2021-05-31"]

{"sheet":"Juin","index":8,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-06-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-06-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-06-03"}]
["2021-06-04"]
["2021-06-07"]
["2021-06-08"]
["2021-06-09"]
["2021-06-10"]
["2021-06-11"]
["2021-06-14"]
["2021-06-15"]
["2021-06-16"]
["2021-06-17"]
["2021-06-18"]
["2021-06-21"]
["2021-06-22"]
["2021-06-23"]
["2021-06-24"]
["2021-06-25"]
["2021-06-28"]
["2021-06-29"]
["2021-06-30"]

{"sheet":"Juillet","index":9,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-07-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-07-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-07-05"}]
["2021-07-06"]
["2021-07-07"]
["2021-07-08"]
["2021-07-09"]
["2021-07-12"]
["2021-07-13"]
["2021-07-14"]
["2021-07-15"]
["2021-07-16"]
["2021-07-19"]
["2021-07-20"]
["2021-07-21"]
["2021-07-22"]
["2021-07-23"]
["2021-07-26"]
["2021-07-27"]
["2021-07-28"]
["2021-07-29"]
["2021-07-30"]

{"sheet":"Août","index":10,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-08-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-08-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-08-03"}]
["2021-08-04"]
["2021-08-05"]
["2021-08-06"]
["2021-08-09"]
["2021-08-10"]
["2021-08-11"]
["2021-08-12"]
["2021-08-13"]
["2021-08-16"]
["2021-08-17"]
["2021-08-18"]
["2021-08-19"]
["2021-08-20"]
["2021-08-23"]
["2021-08-24"]
["2021-08-25"]
["2021-08-26"]
["2021-08-27"]
[{"$f":"WORKDAY($A22,1)","v":"2021-08-30"}]
["2021-08-31"]

{"sheet":"Septembre","index":11,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-09-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-09-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-09-03"}]
["2021-09-06"]
["2021-09-07"]
["2021-09-08"]
["2021-09-09"]
["2021-09-10"]
["2021-09-13"]
["2021-09-14"]
["2021-09-15"]
["2021-09-16"]
["2021-09-17"]
["2021-09-20"]
["2021-09-21"]
["2021-09-22"]
["2021-09-23"]
["2021-09-24"]
["2021-09-27"]
["2021-09-28"]
["2021-09-29"]
["2021-09-30"]

{"sheet":"Octobre","index":12,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-10-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-10-04"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-10-05"}]
["2021-10-06"]
["2021-10-07"]
["2021-10-08"]
["2021-10-11"]
["2021-10-12"]
["2021-10-13"]
["2021-10-14"]
["2021-10-15"]
["2021-10-18"]
["2021-10-19"]
["2021-10-20"]
["2021-10-21"]
["2021-10-22"]
["2021-10-25"]
["2021-10-26"]
["2021-10-27"]
["2021-10-28"]
["2021-10-29"]

{"sheet":"Novembre","index":13,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-11-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-11-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-11-03"}]
["2021-11-04"]
["2021-11-05"]
["2021-11-08"]
["2021-11-09"]
["2021-11-10"]
["2021-11-11"]
["2021-11-12"]
["2021-11-15"]
["2021-11-16"]
["2021-11-17"]
["2021-11-18"]
["2021-11-19"]
["2021-11-22"]
["2021-11-23"]
["2021-11-24"]
["2021-11-25"]
["2021-11-26"]
["2021-11-29"]
["2021-11-30"]

{"sheet":"Décembre","index":14,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["DATE"]
["2021-12-01"]
[{"$f":"WORKDAY($A2,1)","v":"2021-12-02"}]
[{"$f":"WORKDAY($A3,1)","v":"2021-12-03"}]
["2021-12-06"]
["2021-12-07"]
["2021-12-08"]
["2021-12-09"]
["2021-12-10"]
["2021-12-13"]
["2021-12-14"]
["2021-12-15"]
["2021-12-16"]
["2021-12-17"]
["2021-12-20"]
["2021-12-21"]
["2021-12-22"]
["2021-12-23"]
["2021-12-24"]
["2021-12-27"]
["2021-12-28"]
[{"$f":"WORKDAY($A21,1)","v":"2021-12-29"}]
["2021-12-30"]
["2021-12-31"]