Excel Pivot Tables

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".

## Deliverables

1) A working Spreadsheet with pivot tables capable of the manipulations outlined. 2) Complete ownership and distribution copyrights to all work purchased.

## Platform

Excel 2000

Habilidades: PHP

Veja mais: simple spreadsheet examples, pivot tables, excel PIVOT, database required in excel, compare spreadsheet, excel categories, interactive excel, analyse php, php analyse, raw excel data, php pivot, excel split, excel raw data work, excel form access, excel spreadsheet database form, pivot using, excel data tables, excel database front, excel data analyse, excel form access database, excel work windows form, excel question answer, data compare access, voting system using, front end excel access

Acerca do Empregador:
( 5 comentários ) United Kingdom

ID do Projeto: #2962252

Concedido a:


See private message.

$68 USD em 7 dias
(152 Comentários)

4 freelancers estão ofertando em média $70 para esse trabalho


See private message.

$127.5 USD in 7 dias
(3 Comentários)

See private message.

$42.5 USD in 7 dias
(2 Comentários)

See private message.

$42.5 USD in 7 dias
(3 Comentários)