Below is the explanation of what I'm seeing, and here is a link to a blinded file for reference/example:
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.