One more question as our first larger survey starts to take shape.
I have about 50 questions on my survey, most of which are multi-select. This leads to about 120 choices for diagnoses, and the user usually selects just one or two, so the form can be filled out in less than 20 seconds. This part is fine.
I have requirements to be able to fill out forms for the UN (50 choices) and the host country (122 choices), and I am thinking about adding a column for each question to match their forms. (Note that one choice could be in both reports.) I would calculate a 1 or 0 for each answer, and these can be easily filtered and summed by our end users. Also, as noted elsewhere, I am thinking of adding a note question for each response for a summary page.
Here is my question. Is there any file size limit that I need to be concerned about? Would 350 questions (mostly calculations) in the survey and 350 columns in the data file be excessive or cause any issues? We will look into automating the reports in our central office, which could reduce the XLS size, but that would be at a later date.