Cancelled

Data Analysis Prototype in Excel - repost

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.

Skills: Excel

See more: summary excel, summary in freelancer, summary freelancer example, prototype freelancer, prototype date, need data input freelancer, i need an excel freelancer, freelancer with excel, freelancer summary example, freelancer prototype, freelancer excel spreadsheet, freelancer date and time, freelancer adding someone, formats in excel, excel for data analysis, data freelancer in, data analysis with excel, data analysis for excel, csv freelancer, data and analysis, job search based data entry, freelancer input data, job search data entry free, freelancer excel sheet, excel data analysis

About the Employer:
( 9 reviews ) Armagh, Ireland

Project ID: #4526671

27 freelancers are bidding on average £122 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

£111 GBP in 3 days
(59 Reviews)
6.3
svet63

Sounds like a bit more than a couple of hours to me. What version of Excel do you need it for? Regards, Svet.

£210 GBP in 3 days
(47 Reviews)
6.2
Teloquence

Consider it done. Check your PM for my bid details.

£150 GBP in 3 days
(49 Reviews)
5.3
best4best

Please provide the sample file - attachment is missing.

£150 GBP in 3 days
(55 Reviews)
4.9
dominique1

No problem, I can create sheet.

£150 GBP in 3 days
(48 Reviews)
4.6
satsin7

Hi I've done many such projects. This will require use of VBA. Please send the attachments.

£105 GBP in 3 days
(17 Reviews)
4.6
chriskerpini

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

£126 GBP in 2 days
(12 Reviews)
4.4
samitXI

pLEASE Check your Inbox. Thanks

£139 GBP in 3 days
(16 Reviews)
4.3
jal540

I have extensive experience developing custom Excel applications. I can finish your prototype.

£111 GBP in 5 days
(9 Reviews)
4.2
fhasanbd

Hello ready to start with you!

£189 GBP in 5 days
(15 Reviews)
3.8
oFAZo

I can do this FOR SURE and rest assured, I will complete this within a day. If you are interested, I can do this in MS Access as well. This process will also have the ability to archive past [url removed, login to view]!

£122 GBP in 1 day
(10 Reviews)
3.2
cdumitru

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

£55 GBP in 3 days
(5 Reviews)
3.2
swapnilchavan18

Lets do it.

£133 GBP in 0 days
(1 Review)
3.0
omaralieissa

Hi, i can do this, but in C#, thanks.

£100 GBP in 3 days
(4 Reviews)
2.9
Youth2day

I have good Excel skills and i can do the best what you need.

£111 GBP in 2 days
(0 Reviews)
0.0
philippehorovitz

I would do that with VBA, instead of deleting older files you may want to keep them ? I am available to do it today or tomorrow as you wish.

£111 GBP in 1 day
(0 Reviews)
0.0
narendar777

working with excel from last 7 years

£177 GBP in 6 days
(0 Reviews)
0.0
rezakaneta

I am an Expert MS Excel Professional & I can assure you that I will do your job properly. Thank you.

£150 GBP in 3 days
(0 Reviews)
0.0
rameezkhan1992

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.

£144 GBP in 3 days
(0 Reviews)
0.0
intan76

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

£111 GBP in 7 days
(0 Reviews)
0.0