Data Analysis Prototype in Excel - repost

  • Status Closed
  • Budget £20 - £250 GBP
  • Total Bids 28

Project Description

Having been badly let down by a Freelancer who has been promising the job was in progress and ready soon, (before cancelling the project), I now need someone free to spend a couple of hours immediately to create an Excel spreadsheet with control sheet to run extract of data held in .CSV file.

File format is described in Table A.

Control sheet will allow entry of search criteria described in Table B.

Control sheet will include a 'Run Query' button that will create extract of data and a summary of extract to new worksheets based on the criteria entered on the control sheet/interface.

Two new worksheets will be created as result of 'Run Query' button being actioned.

1) Detail – in same format as Table A but with addition of fields described in Table C. Data will be ordered by Date and Time, (columns BG and B).

2) Summary of Data File in format Table D.

Process can be re-run by adding new control sheet/interface data and actioning 'Run Query' button again – NB existing data should be deleted first.

See attached for full spec including table formats plus example of input file.

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online