Spreadsheet Required: I require a functional spreadsheet to analyse data taken from an interactive voting system - with 70 keypads and voting responses of 0-9 possible. The data is currently in the form: Q1-4 Demographic questions (possible responses 1-9, eg 1 corresponds to Norwich, 2 to Cambridge etc) Q5-230 Response questions. These are approx 75 questions (in three sub-categories) split into 3 parts (a, b and c). For a the possible responses are 0-9, b are 0-4 and c are 0-9. We wish to compare these and rank them - Examples may be - For question 23 how did cambridge rank the three parts? or, For "Bristol" what were the responses to Questions in category b. The iterations required will be many and our work so far has identified the need to turn the raw data into meaningful numbers - ie from the demographics answer 3 on the keypad corresponds to london. The actual numbers and demographics differ from above -this is a very complex spreadsheet with over 1400 responses. The delivered spreadsheet/database should remain as simple as possible. The users are not overly familiar with using Access or with having different packages as a "front end".
1) A working Spreadsheet with pivot tables capable of the manipulations outlined. 2) Complete ownership and distribution copyrights to all work purchased.