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:
    Rated 10 out of 10 for this project.
  • 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.xls
    Additional 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.xlsx
    Additional Info (Added 12/15/2009 at 15:04 EST)...
    Removed file: reference_table_2.xls
    Additional Info (Added 12/15/2009 at 15:04 EST)...
    Attached file: reference_table_2.xls
    Additional Info (Added 12/15/2009 at 15:08 EST)...
    Removed file: reference_table_2.xls
    Additional Info (Added 12/15/2009 at 15:08 EST)...
    Attached file: reference_table_2.xls
    Additional 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 10.00/10
(1 review)
I have excellent MS Excel and MS Word skills.
rnjcs $25 1 day 12/15/2009 at 14:12 EST 9.69/10
(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 10.00/10
(2 reviews)
I would like to do the project
engrfrancisr $35 2 days 12/17/2009 at 10:29 EST 10.00/10
(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 10.00/10
(27 reviews)
Please check PMB for my proposal, thanks
ajithgani $70 1 day 12/15/2009 at 2:59 EST 9.68/10
(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 10.00/10
(217 reviews)
will be done...
frehmanpk $200 2 days 12/14/2009 at 20:38 EST 10.00/10
(20 reviews)
Respected Sir, Please see PMB for details.