Hi cam15. I ran the files you uploaded and got the same kind of error. I got rid of it when I changed the names of the calculated variables, the ones that ended with opt in rows 10-17 of your responses.xls file. I just named them a1-a8 and the values from the formulas in cells b10-17 showed up as expected.
I'm going to look into why this was not working, but for now, you should be able to get around it by simply choosing different names for the calculated variables.
Jason Reed
Empirisoft Software Support Specialist