{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DataSheet00000","XLDTREE"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":83,"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":"DataSheet00000","index":0,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["id","treeWB","treeWS","startCellRef","nameCellRef","forTreeCalculation","treeDisp","branchNodeDisp","refEditDisp","calcMethod","withUtility","RUtility","optimalPathTarget","displayCalcNodes","displayCalcBranches","displayRef","displayRefBeforeCalc"]
["DCTT202104011733069814","DemoDCT1_FR.xlsm","Arbre",{"$f":"XLDTREE!$B$9","v":0},{"$f":"XLDTREE!$B$28","v":"Publicité"},{"$f":"SUM($G$27:$I$47)+COUNTIF($H$27:$H$47,\"=FALSE\")+SUM($H$4:$H$25)+COUNTA($A$27:$A$47)+COUNTA($A$4:$A$25)+$J$2+IF(ISNUMBER($L$2),$L$2,0)","v":216549},0,1,0,0,0,null,0,"5,1,1,Gain;7,1,1,Gain att.;3,0,1,Coût;4,0,1,Profit;6,0,0,Gain R;8,0,0,Gain R att.","3,1,1,Opti;4,0,0,Opti R","0,1,1,Feuille ref;1,1,1,Arbre ref;2,1,1,Noeud ref",1]
["id","nType","parentNodeId","nameCellRef","refNodeWBWS","refTreeId","refNodeId","forRefNodeCalculation"]
["DCTN202104011733061979",0,null,{"$f":"XLDTREE!$F$28","v":"Quel canal publicitaire ?"}]
["DCTN202104011733151206",0,"DCTN202104011733061979",{"$f":"XLDTREE!$J$13","v":"Type de ressources"}]
["DCTN202104011733156374",1,"DCTN202104011733151206",{"$f":"XLDTREE!$N$12","v":"Hypothèse CA attendu"}]
["DCTN202104011733156160",4,"DCTN202104011733156374",{"$f":"XLDTREE!$V$10","v":"Fin"}]
["DCTN202104011733151122",4,"DCTN202104011733156374",{"$f":"XLDTREE!$V$14","v":"Fin"}]
["DCTN202104011733153818",1,"DCTN202104011733151206",{"$f":"XLDTREE!$N$21","v":"Hypothèse CA attendu"}]
["DCTN202104011733152149",4,"DCTN202104011733153818",{"$f":"XLDTREE!$V$19","v":"Fin"}]
["DCTN202104011733155100",4,"DCTN202104011733153818",{"$f":"XLDTREE!$V$23","v":"Fin"}]
["DCTN202104011733153685",0,"DCTN202104011733061979",{"$f":"XLDTREE!$J$31","v":"Type de ressources"}]
["DCTN202104011733159545",1,"DCTN202104011733153685",{"$f":"XLDTREE!$N$30","v":"Hypothèse CA attendu"}]
["DCTN202104011733151041",4,"DCTN202104011733159545",{"$f":"XLDTREE!$V$28","v":"Fin"}]
["DCTN202104011733154499",4,"DCTN202104011733159545",{"$f":"XLDTREE!$V$32","v":"Fin"}]
["DCTN202104011733158904",1,"DCTN202104011733153685",{"$f":"XLDTREE!$N$39","v":"Hypothèse CA attendu"}]
["DCTN202104011733152617",4,"DCTN202104011733158904",{"$f":"XLDTREE!$V$37","v":"Fin"}]
["DCTN202104011733156653",4,"DCTN202104011733158904",{"$f":"XLDTREE!$V$41","v":"Fin"}]
["DCTN202104011733153276",0,"DCTN202104011733061979",{"$f":"XLDTREE!$J$49","v":"Type de ressources"}]
["DCTN20210401173315845",1,"DCTN202104011733153276",{"$f":"XLDTREE!$N$48","v":"Hypothèse CA attendu"}]
["DCTN202104011733157721",4,"DCTN20210401173315845",{"$f":"XLDTREE!$V$46","v":"Fin"}]
["DCTN202104011733155545",4,"DCTN20210401173315845",{"$f":"XLDTREE!$V$50","v":"Fin"}]
["DCTN202104011733155331",1,"DCTN202104011733153276",{"$f":"XLDTREE!$N$57","v":"Hypothèse CA attendu"}]
["DCTN202104011733153408",4,"DCTN202104011733155331",{"$f":"XLDTREE!$V$55","v":"Fin"}]
["DCTN202104011733153449",4,"DCTN202104011733155331",{"$f":"XLDTREE!$V$59","v":"Fin"}]
["id","leftNodeId","rightNodeId","position","isForced","nameCellRef","probabilityCellRef","logicCellRef","valueCellRef"]
["DCTB202104011733156908","DCTN202104011733061979","DCTN202104011733151206",1,0,{"$f":"XLDTREE!$J$10","v":"Réseaux sociaux"},null,null,{"$f":"XLDTREE!$K$12","v":0}]
["DCTB202104011733153622","DCTN202104011733151206","DCTN202104011733156374",1,0,{"$f":"XLDTREE!$N$9","v":"Internes"},null,null,{"$f":"XLDTREE!$O$11","v":-5000}]
["DCTB202104011733152808","DCTN202104011733156374","DCTN202104011733156160",1,0,{"$f":"XLDTREE!$R$10","v":"Haute"},{"$f":"XLDTREE!$S$11","v":0.5},null,{"$f":"XLDTREE!$S$12","v":20000}]
["DCTB20210401173315333","DCTN202104011733156374","DCTN202104011733151122",2,0,{"$f":"XLDTREE!$R$14","v":"Basse"},{"$f":"XLDTREE!$S$15","v":0.5},null,{"$f":"XLDTREE!$S$16","v":15000}]
["DCTB202104011733156101","DCTN202104011733151206","DCTN202104011733153818",2,0,{"$f":"XLDTREE!$N$18","v":"Externes"},null,null,{"$f":"XLDTREE!$O$20","v":-10000}]
["DCTB202104011733153324","DCTN202104011733153818","DCTN202104011733152149",1,0,{"$f":"XLDTREE!$R$19","v":"Haute"},{"$f":"XLDTREE!$S$20","v":0.6},null,{"$f":"XLDTREE!$S$21","v":25000}]
["DCTB202104011733155674","DCTN202104011733153818","DCTN202104011733155100",2,0,{"$f":"XLDTREE!$R$23","v":"Basse"},{"$f":"XLDTREE!$S$24","v":0.4},null,{"$f":"XLDTREE!$S$25","v":18000}]
["DCTB202104011733159479","DCTN202104011733061979","DCTN202104011733153685",2,0,{"$f":"XLDTREE!$J$28","v":"Newsletter"},null,null,{"$f":"XLDTREE!$K$30","v":0}]
["DCTB202104011733158411","DCTN202104011733153685","DCTN202104011733159545",1,0,{"$f":"XLDTREE!$N$27","v":"Internes"},null,null,{"$f":"XLDTREE!$O$29","v":-3500}]
["DCTB202104011733158798","DCTN202104011733159545","DCTN202104011733151041",1,0,{"$f":"XLDTREE!$R$28","v":"Haute"},{"$f":"XLDTREE!$S$29","v":0.4},null,{"$f":"XLDTREE!$S$30","v":18000}]
["DCTB202104011733151656","DCTN202104011733159545","DCTN202104011733154499",2,0,{"$f":"XLDTREE!$R$32","v":"Basse"},{"$f":"XLDTREE!$S$33","v":0.6},null,{"$f":"XLDTREE!$S$34","v":16000}]
["DCTB202104011733158624","DCTN202104011733153685","DCTN202104011733158904",2,0,{"$f":"XLDTREE!$N$36","v":"Externes"},null,null,{"$f":"XLDTREE!$O$38","v":-5000}]
["DCTB20210401173315720","DCTN202104011733158904","DCTN202104011733152617",1,0,{"$f":"XLDTREE!$R$37","v":"Haute"},{"$f":"XLDTREE!$S$38","v":0.6},null,{"$f":"XLDTREE!$S$39","v":20000}]
["DCTB20210401173315992","DCTN202104011733158904","DCTN202104011733156653",2,0,{"$f":"XLDTREE!$R$41","v":"Basse"},{"$f":"XLDTREE!$S$42","v":0.4},null,{"$f":"XLDTREE!$S$43","v":16000}]
["DCTB202104011733159670","DCTN202104011733061979","DCTN202104011733153276",3,0,{"$f":"XLDTREE!$J$46","v":"Publicité internet"},null,null,{"$f":"XLDTREE!$K$48","v":0}]
["DCTB202104011733157147","DCTN202104011733153276","DCTN20210401173315845",1,0,{"$f":"XLDTREE!$N$45","v":"Internes"},null,null,{"$f":"XLDTREE!$O$47","v":-8000}]
["DCTB202104011733159751","DCTN20210401173315845","DCTN202104011733157721",1,0,{"$f":"XLDTREE!$R$46","v":"Haute"},{"$f":"XLDTREE!$S$47","v":0.6},null,{"$f":"XLDTREE!$S$48","v":30000}]
["DCTB202104011733153810","DCTN20210401173315845","DCTN202104011733155545",2,0,{"$f":"XLDTREE!$R$50","v":"Basse"},{"$f":"XLDTREE!$S$51","v":0.4},null,{"$f":"XLDTREE!$S$52","v":20000}]
["DCTB202104011733155651","DCTN202104011733153276","DCTN202104011733155331",2,0,{"$f":"XLDTREE!$N$54","v":"Externes"},null,null,{"$f":"XLDTREE!$O$56","v":-15000}]
["DCTB202104011733156292","DCTN202104011733155331","DCTN202104011733153408",1,0,{"$f":"XLDTREE!$R$55","v":"Haute"},{"$f":"XLDTREE!$S$56","v":0.7},null,{"$f":"XLDTREE!$S$57","v":40000}]
["DCTB202104011733152060","DCTN202104011733155331","DCTN202104011733153449",2,0,{"$f":"XLDTREE!$R$59","v":"Basse"},{"$f":"XLDTREE!$S$60","v":0.3},null,{"$f":"XLDTREE!$S$61","v":25000}]

{"sheet":"XLDTREE","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Internes"]
[null,null,null,null,null,null,null,null,null,"Réseaux sociaux",null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733153622\",3)","v":true},null,null,"Haute",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733156908\",3)","v":false},null,null,"Valeur",-5000,null,null,"Probabilité",0.5,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733156160\",5)","v":15000}]
[null,null,null,null,null,null,null,null,null,"Valeur",0,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",20000]
[null,null,null,null,null,null,null,null,null,"Type de ressources",null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733156374\",5)","v":-5000}]
[null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733151206\",5)","v":0},null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733156374\",7)","v":12500},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733151206\",7)","v":12500},null,null,null,null,null,null,"Probabilité",0.5,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733151122\",5)","v":10000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",15000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Externes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733156101\",3)","v":false},null,null,"Haute",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",-10000,null,null,"Probabilité",0.6,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733152149\",5)","v":15000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",25000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153818\",5)","v":-10000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153818\",7)","v":12200},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probabilité",0.4,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733155100\",5)","v":8000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",18000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Internes"]
[null,"Publicité",null,null,null,"Quel canal publicitaire ?",null,null,null,"Newsletter",null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733158411\",3)","v":false},null,null,"Haute",null,null,null,"Fin"]
[null,"Noeuds",{"$f":"[1]!DTree_TreeValue(TUP_DCTT202104011733069814,\"DCTT202104011733069814\",0)","v":10},null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733061979\",7)","v":20500},null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733159479\",3)","v":false},null,null,"Valeur",-3500,null,null,"Probabilité",0.4,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733151041\",5)","v":14500}]
[null,null,null,null,null,null,null,null,null,"Valeur",0,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",18000]
[null,null,null,null,null,null,null,null,null,"Type de ressources",null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733159545\",5)","v":-3500}]
[null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153685\",5)","v":0},null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733159545\",7)","v":13300},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153685\",7)","v":13400},null,null,null,null,null,null,"Probabilité",0.6,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733154499\",5)","v":12500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",16000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Externes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733158624\",3)","v":true},null,null,"Haute",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",-5000,null,null,"Probabilité",0.6,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733152617\",5)","v":15000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",20000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733158904\",5)","v":-5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733158904\",7)","v":13400},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probabilité",0.4,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733156653\",5)","v":11000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",16000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Internes"]
[null,null,null,null,null,null,null,null,null,"Publicité internet",null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733157147\",3)","v":false},null,null,"Haute",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733159670\",3)","v":true},null,null,"Valeur",-8000,null,null,"Probabilité",0.6,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733157721\",5)","v":22000}]
[null,null,null,null,null,null,null,null,null,"Valeur",0,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",30000]
[null,null,null,null,null,null,null,null,null,"Type de ressources",null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN20210401173315845\",5)","v":-8000}]
[null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153276\",5)","v":0},null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN20210401173315845\",7)","v":18000},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153276\",7)","v":20500},null,null,null,null,null,null,"Probabilité",0.4,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733155545\",5)","v":12000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",20000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Externes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Opti",{"$f":"[1]!DTree_BranchValue(TUP_DCTT202104011733069814,\"DCTB202104011733155651\",3)","v":true},null,null,"Haute",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",-15000,null,null,"Probabilité",0.7,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153408\",5)","v":25000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hypothèse CA attendu",null,null,null,"Valeur",40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733155331\",5)","v":-15000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain att.",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733155331\",7)","v":20500},null,null,"Basse",null,null,null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probabilité",0.3,null,null,"Gain",{"$f":"[1]!DTree_NodeValue(TUP_DCTT202104011733069814,\"DCTN202104011733153449\",5)","v":10000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur",25000]