Data Analysis Prototype in Excel - repost
£20-250 GBP
Paid on delivery
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.
Project ID: #4526671
About the project
25 freelancers are bidding on average £123 for this job
VBA developer since 1998, VBA (and Excel) instructor for 10+ years. The attachment is missing. Please upload the file. Even without seeing all details, I can say for sure that I can finish this project in 1 or max 2 More
Sounds like a bit more than a couple of hours to me. What version of Excel do you need it for? Regards, Svet.
I have extensive experience developing custom Excel applications. I can finish your prototype.
hello, I am interested to solve this task. Please consider. Best regards. CValerian I could not find any attachment so as a brief start on it can be submittted
Hi i can give you 100% Quality and Creative Work. i can still working till you are 100% satisfied with my work. Kindly see private massage for more details and Portfolio. Thanks.
we bring YOU EXACTLY WHAT YOU REQUESTED and WHAT YOU NEED ~ Will Provide Service Until U Satisfy 100% ~
Hi.. Iam willing to take up this opportunity. I assure a good quality work. Please check pm, hope you would consider me. Thanks in advance
