https://www.dropbox.com/s/n5u8f4mt4q839td/Checking%20differences%20between%20calculations%20and%20online%20simulator%20-%20blinded.xlsx

-------

I am getting slightly different results when comparing a very basic Excel simulator and the online simulator with share of preference results. My online simulator formulas are:

Total utility: The sum of all individual attribute level utilities, =SUM(C3,T3,AE3,AF3,BC3)

I did this for each of the 6 products in my simulation (I completely ignored the NONE product)

Share of preference: The antilog of product 1 divided by the sum of the antilogs of products 1 through 6, =EXP(BG3)/(EXP($BG3)+EXP($BH3)+EXP($BI3)+EXP($BJ3)+EXP($BK3)+EXP($BL3))

I've double and triple checked my formulas and even recreated it from scratch but I'm still getting different results. I think there is an aspect of a formula I am missing. It's probably simple, but I have never built an Excel simulator before.

Yes, I am calculating these formulas at the respondent level and then averaging them. But I am still getting different results.

I have posted a blinded version of my Excel file here in case it helps:

https://www.dropbox.com/s/n5u8f4mt4q839td/Checking%20differences%20between%20calculations%20and%20online%20simulator%20-%20blinded.xlsx