Convert spreadsheets used for data entry and display into an online data entry and display tool

Cancelled Posted Mar 31, 2014 Paid on delivery
Cancelled Paid on delivery

OVERVIEW: This project is to convert a set of identical spreadsheets used to capture and summarize input from 10-15 people to allow online data entry using a standard, off-the-shelf online database or survey tool. We have ALL this in existing spreadsheets, so you will have format, behavior, formulas, and other aspects to copy.

 

DETAIL: If you think about a spreadsheet, it will be easier to imagine the data entry and display because it is in classic, simple rows and columns. Columns are markets (e.g. Pharmaceuticals, Oil and Gas Exploration, Database Acceleration, Human Resources). Rows are characteristics of these markets that fall into one of five categories. Categories are overall topics like "Criticality of the pain" or "Likelihood of closing deals." Each of the five categories has 3-6 rows under it. These rows are the "characteristics." Examples of characteristics that fit under the five categories are things like "Application performance is critical" under "Criticality of the pain" or "Ability to reach a decision maker" under "Likelihood of closing deals."

 

To be clear, a spreadsheet/database with 12 markets and 5 characteristics in each of the five categories would have 12 markets * 5 categories * 5 factors = 300 intersections – which would be cells if still in a spreadsheet.

 

There are two use cases for this database requiring different input forms and output displays.

 

Use Case 1: individual people estimate a 1-5 rating in each the 300 cells. People must be able to provide their ratings from any web-enabled location without seeing the input of other people. The system should provide auto-save during data entry, so the person doesn't lose ratings if the connection is lost in the middle...or if they want to finish later. Within a single "sheet" or input from a single person, the ratings for characteristics (rows) in a given market (column) are averaged to provide a rating for the category. Then the ratings for the categories are averaged allowing comparison and ranking between markets (columns).

 

We then aggregate across "sheets" (input from individuals), so basic math is done to aggregate all input into a top-level page. The math includes average (e.g. across all people providing a 1-5 rating at the intersection representing "Ability to reach a decision maker" in the market "Pharmaceutical," what is the average rating?), count (how many people rated this item?), and standard deviation (is there general agreement among people who rate this item or is there high variation?). Spreadsheets and databases typically have a standard deviation formula and whatever is included in the database should work fine.

 

Display for Use Case 1: should look like a one-page spreadsheet for data entry (i.e. putting in the ratings) and should look like a one-page spreadsheet for the aggregated numbers (one page for average, one page for count, and one page for standard deviation). We should be able to use color, a logo, and various notes to users of both the data entry page and the data summary page, but nothing more than you could add to empty cells in a spreadsheet. For example, a title, a logo, and space for instructions.

 

Use Case 2: in a *single* market, these same rows become interview questions. You can think of this as only one column with all of the rows. The interviewer will type directly into a text box representing a single characteristic (row within a column). Obviously, the input form for this use case must have larger text boxes. Boxes that expand as someone types would be nice, but scrolling may be enough. Each text box should support internal paragraph breaks. Entries in these text boxes will range from blank or 5 words up to ~200 words.

 

Display for Use Case 2: We will want to view interview notes in two ways: (1) all the responses from 1 interview (i.e. the same as the data input form) or (2) a subset of factors (rows) across all interviewees in a market (column), preferably a customizable subset of factors.

Data Entry Data Processing Database Administration Excel

Project ID: #5744258

About the project

11 proposals Remote project Active Apr 7, 2014

11 freelancers are bidding on average $209 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 USD in 4 days
(193 Reviews)
6.8
FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this. Regards

$54 USD in 3 days
(40 Reviews)
4.9
Beacon09

A proposal has not yet been provided

$600 USD in 36 days
(17 Reviews)
4.6
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel dat More

$250 USD in 5 days
(7 Reviews)
4.3
TechJSolutions

Dear Krosen, Thank you for inviting me in this bid. I would like to discuss further more with you. Is it only data processing? Or create application online data entry? If create application what platform you will More

$250 USD in 7 days
(11 Reviews)
2.6
tasleem83

Hello, having gone through your requirement; I feel suitable enough for the role hence my application for the project. I am happy to work with you on this project to achieve set objectives and targets.

$144 USD in 3 days
(9 Reviews)
2.1
steve10086

I have read and understood the requirements, I am expert in Copy Typing, Data Entry, Data Mining, Data Processing, Web Scraping. I have strong work ethic. I will give you a quality project. You can send me message for More

$166 USD in 7 days
(3 Reviews)
1.8
CraigslistPk

The Experts Are Here! Kindly Give Me A Chance To Handle Your Project... I Have Last 2 Years Experience...

$155 USD in 3 days
(2 Reviews)
1.2
sksameer

A proposal has not yet been provided

$60 USD in 3 days
(3 Reviews)
0.8
abhineetraj

I have 10+ years of experience in working and maintaining excel and spreadsheets. I have 100% completion rates on other free lancing sites. We can consider this request urgent and can reduce the time needed to compl More

$188 USD in 5 days
(0 Reviews)
0.0
coyone

Hi, I would like to work on your project. I have over ten years of accounting experience in a variety of accounting functions, most recently as as a Senior Revenue Accountant.. I have also worked on a number of account More

$155 USD in 3 days
(0 Reviews)
0.0