We have a large data set in Excel with data from over 1300 respondents who answered several hundred questions in an online survey that is administered two times per year (with approximately 50 respondents in April and 50 in September) and calls for numeric responses. The spreadsheet currently consists of four different worksheets of data, linked to each other and linked to 20 charts. The data is made up of individual entries, group or session averages, along with the overall means for each category over time, adding up to four thousand rows of data and spanning 421 columns. This data is used to create personalized reports for each participant in the program. This model was created with Excel 2003 which had a limit of only 256 columns across, resulting in the need to be broken up in 3 parts. Now that Excel 2007 and 2010 have come out it needs to be updated.
The data is ultimately used to prepare a personalized report using Word. This report is approximately 40 pages and provides participating respondents the average response for the total 1300 respondents, the average for their particular 50-person cohort, and their own personal response.
We are looking for an Expert in Excel and Access to help us in the short-term and long-term, as the data over the years has grown to such a large amount that Access is probably a better method for management now.
1) In the immediate short-term we need someone to take the raw data and only generate the needed formulas and charts, NOT build a full interactive model. Rather just make the reports we need (individual, group, and overall numbers) for the current program at this time.
2) If that initial work is successful, the subsequent job is to completely rebuild an interactive model that can be updated by us with each additional program's data. We need this larger project completed before August.
32 pekerja bebas membida secara purata $872 untuk pekerjaan ini
I am a US based consultant with immediate availability to work on your project. I look forward to working with you on this project. See PM for Details regards, Paranos.
I'm an Excel and Access expert and recently completed a similar project for one of my clients, who did use Excel and is now using Access. I can start immediately.
I am sure I can fulfill all your requirements in Excel environment. Excel VBA expert here. I've done similar projects. Please check PM for details. Thanks!