Excel Ref Table
Project ID: 1260839865
Project Details
- Status: Closed (Chosen Programmer: engrfrancisr; Paid + bonus; Rated 10 out of 10)
- Posted: 12/14/2009 at 20:17 EST
- Closed: 12/22/2009 at 3:53 EST
- Project Creator:
- Budget: N/A
- Description: In an excel file, there are about 1100 four-digit numbers placed inside about 100 cells on spreadsheet 1. Each number corresponds to an item on my website. In the file, the column headers represents the item levels and the row headers represent the item types. See attached file.
I would like a finished Excel file to that does the following
*read the data from spreadsheet 1
*Allows me to update or add to the data from spreadsheet 1
On spreadsheet 2, I should be able to:
*select 1 or more item types (from dropdown list)
*select 1 or more item levels (from dropdown list)
*see the matching list of item numbers
The results from sprea
I would like to get started right away. Payment will be released from escrow only after I have a working file.Additional Info (Added 12/14/2009 at 21:23 EST)...One of my sentences was cut off. I meant: "The results from spreadsheet 2 should automatically reflect any change made in spreadsheet 1".Additional Info (Added 12/14/2009 at 21:42 EST)...Attached file: reference_table_2.xlsAdditional Info (Added 12/14/2009 at 21:43 EST)...If it is possible, make each item number a link to spreadsheet 3. The item will be listed there in its own row with fields "Status", "My answer", "correct answer", "time" and "notes".
Each of the first 3 fields will be a dropdown:
*Status --> "got it", "maybe", "need help"
*My answer --> "A", "B", "C", "D" "E"
*Correct Answer --> "A", "B", "C", "D", "E"
*Time --> minutes and seconds format
*Note --> free text input
When a new item is added to spreadsheet 1, update spreadsheet 3 automatically (add a new row, sorted by item number).Additional Info (Added 12/15/2009 at 15:04 EST)...Removed file: reference_table.xlsxAdditional Info (Added 12/15/2009 at 15:04 EST)...Removed file: reference_table_2.xlsAdditional Info (Added 12/15/2009 at 15:04 EST)...Attached file: reference_table_2.xlsAdditional Info (Added 12/15/2009 at 15:08 EST)...Removed file: reference_table_2.xlsAdditional Info (Added 12/15/2009 at 15:08 EST)...Attached file: reference_table_2.xlsAdditional Info (Added 12/22/2009 at 1:30 EST)...Attached file: excel reference table details.ppt
File info: illustration of what I want on user sheet 3 - Tags:
| Project Bids |
| Programmer | Bid |
Delivery Time | Time of Bid | Rating | |
| alexsokolsky | $20 | 1 day | 12/16/2009 at 14:19 EST | (No Feedback Yet) | |
| Please see PMB for details. | |||||
| moneymatters09 | $20 | 7 days | 12/18/2009 at 1:26 EST | (1 review) |
|
| I have excellent MS Excel and MS Word skills. | |||||
| rnjcs |
$25 | 1 day | 12/15/2009 at 14:12 EST | (179 reviews) |
|
| please check PMB | |||||
| aftabyunis | $30 | 2 days | 12/17/2009 at 8:30 EST | (No Feedback Yet) | |
| you can pay me what ever you would like to pay me | |||||
| balabeena | $30 | 3 days | 12/14/2009 at 23:15 EST | (2 reviews) |
|
| I would like to do the project | |||||
| engrfrancisr | $35 | 2 days | 12/17/2009 at 10:29 EST | (8 reviews) |
|
| Hi, see PMB for a sample/demo, I believe a buyer should see a prrof of concept first before comitting to a coder so as not to waste time. | |||||
| ilovecoding | $39 | 2 days | 12/15/2009 at 11:05 EST | (27 reviews) |
|
| Please check PMB for my proposal, thanks | |||||
| ajithgani |
$70 | 1 day | 12/15/2009 at 2:59 EST | (148 reviews) |
|
| Ready to do.... | |||||
| antonykavin | $75 | 2 days | 12/15/2009 at 2:27 EST | (No Feedback Yet) | |
| Hello Sir, This can be completed in a couple of days. We have enough experience in excel, to complete your requirement. Give us the opportunity to work for you. Warm Regards, Antony. | |||||
| jaipursoftware | $100 | 4 days | 12/15/2009 at 14:15 EST | (No Feedback Yet) | |
| We have broad knowledge of various domains such as medical, tourism,CRM,Education etc gained from the development of successful projects for more than 5 years. can start immediately once bid is accepted and will provide support for 15 dys after completion | |||||
| akiles99 |
$120 | Immediately | 12/15/2009 at 11:06 EST | (217 reviews) |
|
| will be done... | |||||
| frehmanpk | $200 | 2 days | 12/14/2009 at 20:38 EST | (20 reviews) |
|
| Respected Sir, Please see PMB for details. | |||||






