{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["data_HID","data","CBC Design","CBC Analysis","Market generator","XLSTAT_20210518_175850_1_HID1","Market Simulation","XLSTAT_20210518_175850_1_HID","CBC Analysis_HID","Market Simulation_HID"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":1,"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":"data_HID","index":0,"n_rows":8,"n_cols":33,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["RefEdit_Y","CheckBoxVarLabels","RefEdit_Market","CheckBox_Desc","CheckBoxRegCharts","CheckBoxTrans","ComboBoxModel","OptionButton_R","OptionButton_S","OptionButton_W","RefEdit_R","RefEdit_W","CheckBox_W","RefEdit_ObsLabels","CheckBox_ObsLabels","RefEdit_UtilLabels","CheckBox_Group","CheckBox_Wr","ComboBox_Method","RefEdit_Group","RefEdit_Wr","CheckBoxPie","CheckBoxPieCompare","CheckBoxStack","TextBoxNbSim","CheckBox_Interactions","TextBoxLevel","ScrollBarLevel","RefEditStdDev","CheckBoxOld","CheckBoxSaveForm","RefEdit_ReportCJT","RefEdit_ReportMarket"]
["RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","CheckBox","ComboBox","OptionButton","OptionButton","OptionButton","RefEdit","RefEdit","CheckBox","RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","ComboBox","RefEdit","RefEdit","CheckBox","CheckBox","CheckBox","TextBox","CheckBox","TextBox","ScrollBar","RefEdit","CheckBox","CheckBox","RefEdit","RefEdit"]
["Sheet24954X765'!$C$26:$C$37","True","Sheet370597X765'!$C$9:$F$13","True","True","False","1","False","True","False",null,null,"False","Sheet370597X765'!$B$9:$B$13","True","Sheet24954X765'!$B$15:$F$19","False","False","0",null,null,"True","True","True","10000","False","2","4",null,"False","True","Sheet24954X765'!$H$13","Sheet370597X765'!$H$13"]
[]
[4]
[4]
["$B$1"]
["$C$23"]

{"sheet":"data","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Temperature","Sugar","Lemon","Intensity"]
[null,"Ice","No sugar","yes","Strong"]
[null,"Warm","1 sugar","no","Medium"]
[null,"Very warm","2 sugar",null,"Low"]

{"sheet":"CBC Design","index":2,"n_rows":87,"n_cols":15,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Designs for choice-based conjoint analysis - Start time: 18/05/2021 at 17:57:19 / End time: 18/05/2021 at 17:57:25 / Microsoft Excel 16.013929"]
[null,"Factors/Categories table: Workbook = demoCBC_02_en (1).xlsm / Sheet = data / Range = 'data'!$B$2:$E$5 / 3 rows and 4 columns"]
[null,"Maximum number of profiles: 12"]
[null,"Number of respondents: 10"]
[null,"Number of comparisons: 20"]
[null,"Profiles per comparison: 3"]
[null,"Prohibited combinations: Yes"]
[null,"Initial partition: 123456789"]
[]
[]
[]
[]
[null,"Variable informations:"]
[]
[null,"Short name","Nbr. of categories","Category 1","Category 2","Category 3"]
[null,"Temperature",3,"Ice","Warm","Very warm"]
[null,"Sugar",3,"No sugar","1 sugar","2 sugar"]
[null,"Lemon",2,"yes","no",""]
[null,"Intensity",3,"Strong","Medium","Low"]
[]
[]
[null,"Information on prohibited combinations:"]
[]
[null,"Prohibited combinations","Temperature","Sugar","Lemon","Intensity"]
[null,"Combination 1","","","no","Strong"]
[]
[]
[null,"Profiles Optimized:"]
[]
[null,"Observations","Temperature","Sugar","Lemon","Intensity"]
[null,"Profile 1","Very warm","No sugar","yes","Medium"]
[null,"Profile 2","Warm","2 sugar","yes","Medium"]
[null,"Profile 3","Warm","1 sugar","yes","Strong"]
[null,"Profile 4","Ice","2 sugar","no","Medium"]
[null,"Profile 5","Ice","No sugar","no","Low"]
[null,"Profile 6","Ice","No sugar","yes","Strong"]
[null,"Profile 7","Very warm","2 sugar","yes","Strong"]
[null,"Profile 8","Warm","No sugar","no","Medium"]
[null,"Profile 9","Warm","No sugar","yes","Low"]
[null,"Profile 10","Ice","2 sugar","yes","Low"]
[null,"Profile 11","Ice","1 sugar","yes","Medium"]
[null,"Profile 12","Very warm","1 sugar","no","Low"]
[]
[]
[null,"Designs for conjoint analysis:"]
[]
[null,"Comparison","Choice 1","Choice 2","Choice 3","Individual 1","Individual 2","Individual 3","Individual 4","Individual 5","Individual 6","Individual 7","Individual 8","Individual 9","Individual 10"]
[null,"Comparison 1",3,1,2,1,2,3,2,2,3,3,1,1,1]
[null,"Comparison 2",4,6,5,1,3,1,1,3,1,2,1,1,3]
[null,"Comparison 3",9,7,8,1,1,1,1,1,2,3,1,1,1]
[null,"Comparison 4",10,11,12,2,1,2,2,1,3,2,2,2,2]
[null,"Comparison 5",7,4,1,3,2,1,2,2,2,2,2,3,2]
[null,"Comparison 6",6,8,2,2,2,3,2,1,1,2,3,2,3]
[null,"Comparison 7",5,10,3,3,1,2,1,2,3,1,2,2,1]
[null,"Comparison 8",12,9,11,3,3,1,3,3,3,3,2,3,1]
[null,"Comparison 9",7,3,6,2,3,3,2,2,2,1,2,2,2]
[null,"Comparison 10",8,5,1,1,1,3,3,3,3,1,1,3,1]
[null,"Comparison 11",9,2,4,3,2,1,3,2,3,3,2,3,2]
[null,"Comparison 12",1,11,10,2,2,3,2,2,2,3,2,2,3]
[null,"Comparison 13",3,4,12,3,2,2,3,2,1,2,2,2,3]
[null,"Comparison 14",2,5,7,3,1,1,1,3,3,3,2,3,1]
[null,"Comparison 15",10,6,9,3,2,1,3,1,1,2,2,1,3]
[null,"Comparison 16",8,12,11,1,3,3,1,3,3,1,3,3,3]
[null,"Comparison 17",1,12,6,1,3,1,3,3,3,1,3,3,3]
[null,"Comparison 18",4,10,8,3,1,2,2,1,2,1,2,1,3]
[null,"Comparison 19",5,3,9,2,3,2,3,1,2,1,2,3,3]
[null,"Comparison 20",11,2,7,1,1,1,2,1,3,1,1,2,2]
[null,"Enter the code associated to the choice made (from 1 to 3)."]
[null,"Enter the 0 value if none of the choices have been selected."]
[]
[]
[]
[null,"Once you filled the conjoint design with individuals responses, you can click the above button to automatically launch the interface that allows running a conjoint analysis based on choice."]
[]
[]
[null,"Optimization summary:"]
[]
[null,"Iteration","Log(Determinant)","Norm. Log Det"]
[null,6,0.22535360405908064,-1.6250433132679587]
[null,6,0.2253536040590807,-1.6250433132679587]
[null,6,0.2253536040590807,-1.6250433132679587]
[null,6,0.2253536040590807,-1.6250433132679587]
[null,6,0.22535360405908056,-1.6250433132679587]
[null,6,0.2253536040590807,-1.6250433132679587]
[null,6,0.2253536040590807,-1.6250433132679587]
[null,6,0.22535360405908061,-1.6250433132679587]
[null,6,0.22535360405908064,-1.6250433132679587]

{"sheet":"CBC Analysis","index":3,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Choice-based conjoint analysis - Start time: 18/05/2021 at 17:57:52 / End time: 18/05/2021 at 17:57:54 / Microsoft Excel 16.013929"]
[null,"Responses: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Design / Range = 'CBC Design'!$F$47:$O$67 / 20 rows and 10 columns"]
[null,"Profiles: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Design / Range = 'CBC Design'!$C$30:$F$42 / 12 rows and 4 columns"]
[null,"Choice table: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Design / Range = 'CBC Design'!$C$47:$E$67 / 20 rows and 3 columns"]
[null,"Method: Choice model"]
[null,"Constraints: Sum(ai)=0"]
[null,"Tolerance: 0,0001"]
[null,"Stop conditions: Iterations = 10000 / Convergence = 0,00001"]
[]
[]
[]
[]
[null,"Variable informations:"]
[]
[null,"Short name","Nbr. of categories","Category 1","Category 2","Category 3"]
[null,"Temperature","3","Ice","Very warm","Warm"]
[null,"Sugar","3","1 sugar","2 sugar","No sugar"]
[null,"Lemon","2","no","yes"]
[null,"Intensity","3","Low","Medium","Strong"]
[]
[]
[null,"Utilities:"]
[]
[null,"Aggregated utilities:"]
[]
[null,"Source","Utilities"]
[null,"Temperature-Ice",0.43468100440360719]
[null,"Temperature-Very warm",-0.48685053789097826]
[null,"Temperature-Warm",5.2169533487371078E-2]
[null,"Sugar-1 sugar",0.28236871706915462]
[null,"Sugar-2 sugar",-5.38014314865864E-2]
[null,"Sugar-No sugar",-0.22856728558256822]
[null,"Lemon-no",-0.18431076129118681]
[null,"Lemon-yes",0.18431076129118681]
[null,"Intensity-Low",-0.13420292268457015]
[null,"Intensity-Medium",0.46106635491515413]
[null,"Intensity-Strong",-0.32686343223058401]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Standard deviations table:"]
[]
[null,"Source","Std. dev."]
[null,"Temperature-Ice",0.11889205569138662]
[null,"Temperature-Very warm",0.15406410278847371]
[null,"Temperature-Warm",0.13116713182081738]
[null,"Sugar-1 sugar",0.14831031046992593]
[null,"Sugar-2 sugar",0.12658149099804242]
[null,"Sugar-No sugar",0.12536708643171471]
[null,"Lemon-no",0.10272936942698899]
[null,"Lemon-yes",0.10272936942698899]
[null,"Intensity-Low",0.13699433754845228]
[null,"Intensity-Medium",0.12725698241055275]
[null,"Intensity-Strong",0.16234336540367814]
[]
[]
[null,"Importances:"]
[]
[null,"Aggregated importances:"]
[]
[null,"Source","Importances"]
[null,"Temperature",35.593852112385321]
[null,"Sugar",19.734734713470257]
[null,"Lemon",14.237884823311928]
[null,"Intensity",30.433528350832482]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Market generator","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Market generator - Start time: 18/05/2021 at 17:58:53 / End time: 18/05/2021 at 17:59:31 / Microsoft Excel 16.013929"]
[null,"Variable informations: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Analysis / Range = 'CBC Analysis'!$B$15:$F$19 / 5 rows and 5 columns"]
[]
[]
[]
[]
[null,"Simulated market:"]
[]
[null,"Product ID","Temperature","Sugar","Lemon","Intensity"]
[null,"Product 1","Very warm","2 sugar","yes","Low"]
[null,"Product 2","Warm","1 sugar","no","Medium"]
[null,"Product 3","Warm","2 sugar","yes","Low"]
[null,"Product 4","Ice","1 sugar","yes","Medium"]

{"sheet":"XLSTAT_20210518_175850_1_HID1","index":5,"n_rows":8,"n_cols":34,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["RefEdit_Y","CheckBoxVarLabels","RefEdit_Market","CheckBox_Desc","CheckBoxRegCharts","CheckBoxTrans","ComboBoxModel","OptionButton_R","OptionButton_S","OptionButton_W","RefEdit_R","RefEdit_W","CheckBox_W","RefEdit_ObsLabels","CheckBox_ObsLabels","RefEdit_UtilLabels","CheckBox_Group","CheckBox_Wr","ComboBox_Method","RefEdit_Group","RefEdit_Wr","CheckBoxPie","CheckBoxPieCompare","CheckBoxStack","TextBoxNbSim","CheckBox_Interactions","TextBoxLevel","ScrollBarLevel","RefEditStdDev","CheckBoxOld","CheckBoxSaveForm","RefEdit_ReportCJT","RefEdit_ReportMarket","CheckBoxConstraint"]
["RefEdit0","CheckBox","RefEdit0","CheckBox","CheckBox","CheckBox","ComboBox","OptionButton","OptionButton","OptionButton","RefEdit","RefEdit","CheckBox","RefEdit0","CheckBox","RefEdit0","CheckBox","CheckBox","ComboBox","RefEdit","RefEdit","CheckBox","CheckBox","CheckBox","TextBox","CheckBox","TextBox","ScrollBar","RefEdit","CheckBox","CheckBox","RefEdit0","RefEdit0","CheckBox"]
["XLSTAT_20210518_175749_1'!$C$26:$C$37","True","XLSTAT_20210518_175850_1'!$C$9:$F$13","True","True","False","1","False","True","False",null,null,"False","XLSTAT_20210518_175850_1'!$B$9:$B$13","True","XLSTAT_20210518_175749_1'!$B$15:$F$19","False","False","1",null,null,"True","True","True","10000","False","2","4",null,"False","True","XLSTAT_20210518_175749_1'!$H$14","XLSTAT_20210518_175850_1'!$H$9","False"]
[]
[4]
[4]
["$B$1"]
["$C$23"]

{"sheet":"Market Simulation","index":6,"n_rows":80,"n_cols":7,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2021.2.1.12345 - Conjoint analysis simulation tool - Start time: 18/05/2021 at 18:00:11 / End time: 18/05/2021 at 18:00:13 / Microsoft Excel 16.013929"]
[null,"Utilities table: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Analysis / Range = 'CBC Analysis'!$C$26:$C$37 / 11 rows and 1 column"]
[null,"Variable informations: Workbook = demoCBC_02_en (1).xlsm / Sheet = CBC Analysis / Range = 'CBC Analysis'!$B$15:$F$19 / 4 rows and 5 columns"]
[null,"Simulated market: Workbook = demoCBC_02_en (1).xlsm / Sheet = Market generator / Range = 'Market generator'!$C$9:$F$13 / 4 rows and 4 columns"]
[null,"Product ID: Workbook = demoCBC_02_en (1).xlsm / Sheet = Market generator / Range = 'Market generator'!$B$9:$B$13 / 4 rows and 1 column"]
[null,"Model: CBC"]
[null,"Method: Logit(Beta=1)"]
[]
[]
[]
[]
[null,"Variable informations:"]
[]
[null,"Short name","Nbr. of categories","Category 1","Category 2","Category 3"]
[null,"Temperature","3","Ice","Very warm","Warm"]
[null,"Sugar","3","1 sugar","2 sugar","No sugar"]
[null,"Lemon","2","no","yes"]
[null,"Intensity","3","Low","Medium","Strong"]
[]
[]
[null,"Simulated market:"]
[]
[null,"Product ID","Temperature","Sugar","Lemon","Intensity"]
[null,"Product 1","Very warm","2 sugar","yes","Low"]
[null,"Product 2","Warm","1 sugar","no","Medium"]
[null,"Product 3","Warm","2 sugar","yes","Low"]
[null,"Product 4","Ice","1 sugar","yes","Medium"]
[null,"You can click the row corresponding to the last product to change levels of attributes. By clicking on the button below, you can then run again the analysis with the modified market."]
[]
[]
[]
[null,"Market share:"]
[]
[null,"Product ID","Market share (Total)"]
[null,"Product 1",8.2625772717998291]
[null,"Product 2",24.867818359502667]
[null,"Product 3",14.164752048644946]
[null,"Product 4",52.704852320052552]
[]
[]
[null,"Market share plot:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Utilities estimated with method Logit(Beta=1):"]
[]
[null,"Utilities / Market share:"]
[]
[null,"Product ID","Utilities","Market share"]
[null,"Product 1",8.2625772717998286E-2,8.2625772717998291]
[null,"Product 2",0.24867818359502666,24.867818359502667]
[null,"Product 3",0.14164752048644946,14.164752048644946]
[null,"Product 4",0.52704852320052553,52.704852320052552]
[]
[]
[null,"Utilities (Individual data):"]
[]
[null,"Product ID","Utilities"]
[null,"Product 1",8.2625772717998291]
[null,"Product 2",24.867818359502667]
[null,"Product 3",14.164752048644946]
[null,"Product 4",52.704852320052552]

{"sheet":"XLSTAT_20210518_175850_1_HID","index":7,"n_rows":3,"n_cols":34,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["RefEdit_Y","CheckBoxVarLabels","RefEdit_Market","CheckBox_Desc","CheckBoxRegCharts","CheckBoxTrans","ComboBoxModel","OptionButton_R","OptionButton_S","OptionButton_W","RefEdit_R","RefEdit_W","CheckBox_W","RefEdit_ObsLabels","CheckBox_ObsLabels","RefEdit_UtilLabels","CheckBox_Group","CheckBox_Wr","ComboBox_Method","RefEdit_Group","RefEdit_Wr","CheckBoxPie","CheckBoxPieCompare","CheckBoxStack","TextBoxNbSim","CheckBox_Interactions","TextBoxLevel","ScrollBarLevel","RefEditStdDev","CheckBoxOld","CheckBoxSaveForm","RefEdit_ReportCJT","RefEdit_ReportMarket","CheckBoxConstraint"]
["RefEdit0","CheckBox","RefEdit0","CheckBox","CheckBox","CheckBox","ComboBox","OptionButton","OptionButton","OptionButton","RefEdit","RefEdit","CheckBox","RefEdit0","CheckBox","RefEdit0","CheckBox","CheckBox","ComboBox","RefEdit","RefEdit","CheckBox","CheckBox","CheckBox","TextBox","CheckBox","TextBox","ScrollBar","RefEdit","CheckBox","CheckBox","RefEdit0","RefEdit0","CheckBox"]
["XLSTAT_20210518_175749_1'!$C$26:$C$37","True","XLSTAT_20210518_175850_1'!$C$9:$F$13","True","True","False","1","False","True","False",null,null,"False","XLSTAT_20210518_175850_1'!$B$9:$B$13","True","XLSTAT_20210518_175749_1'!$B$15:$F$19","False","False","1",null,null,"True","True","True","10000","False","2","4",null,"False","True","XLSTAT_20210518_175749_1'!$H$14","XLSTAT_20210518_175850_1'!$H$9","False"]

{"sheet":"CBC Analysis_HID","index":8,"n_rows":8,"n_cols":33,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["RefEdit_Y","CheckBoxVarLabels","RefEdit_Market","CheckBox_Desc","CheckBoxRegCharts","CheckBoxTrans","ComboBoxModel","OptionButton_R","OptionButton_S","OptionButton_W","RefEdit_R","RefEdit_W","CheckBox_W","RefEdit_ObsLabels","CheckBox_ObsLabels","RefEdit_UtilLabels","CheckBox_Group","CheckBox_Wr","ComboBox_Method","RefEdit_Group","RefEdit_Wr","CheckBoxPie","CheckBoxPieCompare","CheckBoxStack","TextBoxNbSim","CheckBox_Interactions","TextBoxLevel","ScrollBarLevel","RefEditStdDev","CheckBoxOld","CheckBoxSaveForm","RefEdit_ReportCJT","RefEdit_ReportMarket"]
["RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","CheckBox","ComboBox","OptionButton","OptionButton","OptionButton","RefEdit","RefEdit","CheckBox","RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","ComboBox","RefEdit","RefEdit","CheckBox","CheckBox","CheckBox","TextBox","CheckBox","TextBox","ScrollBar","RefEdit","CheckBox","CheckBox","RefEdit","RefEdit"]
["Sheet24954X765'!$C$26:$C$37","True","Sheet370597X765'!$C$9:$F$13","True","True","False","1","False","True","False","Sheet370597X765'!$C$9:$F$13","Sheet370597X765'!$C$9:$F$13","False","Sheet370597X765'!$B$9:$B$13","True","Sheet24954X765'!$B$15:$F$19","False","False","1","Sheet24954X765'!$B$15:$F$19","Sheet24954X765'!$B$15:$F$19","True","True","True","10000","False","2","4","Sheet24954X765'!$B$15:$F$19","False","True","Sheet24954X765'!$H$13","Sheet370597X765'!$H$13"]
[]
[4]
[4]
["$B$1"]
["$C$23"]

{"sheet":"Market Simulation_HID","index":9,"n_rows":8,"n_cols":33,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["RefEdit_Y","CheckBoxVarLabels","RefEdit_Market","CheckBox_Desc","CheckBoxRegCharts","CheckBoxTrans","ComboBoxModel","OptionButton_R","OptionButton_S","OptionButton_W","RefEdit_R","RefEdit_W","CheckBox_W","RefEdit_ObsLabels","CheckBox_ObsLabels","RefEdit_UtilLabels","CheckBox_Group","CheckBox_Wr","ComboBox_Method","RefEdit_Group","RefEdit_Wr","CheckBoxPie","CheckBoxPieCompare","CheckBoxStack","TextBoxNbSim","CheckBox_Interactions","TextBoxLevel","ScrollBarLevel","RefEditStdDev","CheckBoxOld","CheckBoxSaveForm","RefEdit_ReportCJT","RefEdit_ReportMarket"]
["RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","CheckBox","ComboBox","OptionButton","OptionButton","OptionButton","RefEdit","RefEdit","CheckBox","RefEdit","CheckBox","RefEdit","CheckBox","CheckBox","ComboBox","RefEdit","RefEdit","CheckBox","CheckBox","CheckBox","TextBox","CheckBox","TextBox","ScrollBar","RefEdit","CheckBox","CheckBox","RefEdit","RefEdit"]
["Sheet24954X765'!$C$26:$C$37","True","Sheet370597X765'!$C$9:$F$13","True","True","False","1","False","True","False",null,null,"False","Sheet370597X765'!$B$9:$B$13","True","Sheet24954X765'!$B$15:$F$19","False","False","1",null,null,"True","True","True","10000","False","2","4",null,"False","True","Sheet24954X765'!$H$13","Sheet370597X765'!$H$13"]
[]
[4]
[4]
["$B$1"]
["$C$23"]