Find Jobs
Hire Freelancers

Develop database

€20-60 EUR

Completed
Posted about 6 years ago

€20-60 EUR

Paid on delivery
I need help to transform my large datafiles (ie. between 500,000 and 2,000,000 lines) in csv format with 4 numeric type variables (eg. A, B, C and D) recorded in millisecond time points (format [login to view URL] hh:mm:ss.000), structured as follows: Datetime_Milliseconds A B C D 13.12.2017 00:00:00.176 1 2 3 2 I need a developer to provide me (1) macros, script or some other code or method that will transform the file as described below, and (2) with some guidance about how to edit the specific calculations described below, so that I can modify them myself in future. 1. Create new variables (eg. E) that are derived from calculations involving variables in the datafile. For example, if A>0, E = C , else E = 0 Datetime_Milliseconds A B C D E 13.12.2017 00:01:176 1 2 3 2 3 2. Create a new datafile that summarises values (as either the maximum, minimum, sum, mean, median or mode) in longer time periods (eg. 1, 5, 30 minutes etc or 1, 2, 8 hours etc. For example, the mean average of values that occur in a 1 minute period Datetime_1Minute A B C D E 13.12.2017 00:01 1 3 8 3 6 3. I then need to import variables from other csv files that contain data recorded in the same time period. For example, import variables F and G from another csv format datafile recorded in the same time period (eg. 1 minute data points) Datetime_1Minute A B C D E F G 13.12.2017 00:01 1 3 8 3 8 4 8 4. Create new variables (eg. N1) that are derived from calculations using variables in the datafile: N1 = (A_maximum – A_minimum)/E Datetime_1Minute A B C D E F G N1 13.12.2017 00:01 1 3 8 3 8 4 8 0.25 The transformed datafiles must be in, or able to be saved or exported into csv or tab-delimited format. It would be preferable for the solution to be executed using MS Excel and/or MS Access, but this is not strictly essential. The software used does however need to be compatible with Windows 10 and be able to handle very large datasets. I have some experience in coding but it was a long time ago - so I may need the developer to explain how to modify parts of their solution so that I can make some specific changes (eg. modify the calculation required for creating a new variable (see step #4), choose a different time interval (see step #1) to summarise data or to use median values rather than using the mean etc). Please do not apply for this job if you are unwilling to do this. Payment will be made after (1) explanation is provided about how to modify certain aspects of the solution as described above, and (2) when the solution can be applied to successfully transform another similar datafile. If this test is unsuccessful, the developer will be given an opportunity to produce another solution. Persons who want to be paid for incomplete work should not apply for this job. Applicants should indicate the general approach they plan to take (including software) and the approximate amount of time required to produce a solution that I can test. The selected applicant will be provided with the following to develop a solution upon: - a csv datafile containing approximately 600,000 lines of data - another smaller file to import data as described in step #3 - additional calculations to include with steps #2 and #4
Project ID: 16489559

About the project

13 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, there. My name's Paris and I'm a very experienced Excel developer. All you mention in your brief can be tackled by using a macro-enabled Excel spreadsheet. I will write all necessary code to import and export csv files accordingly. I use to add comments inside my code to make it readable and easy to alter in future upgrades. All functions will be initiated by pressing a couple of buttons put in a distinguished place. I will explain how the code works and leave space for modifications in the future. Finally, I'm not going to ask to get paid unless the final version of the file has been delivered and you're happy with it. I'm looking forward to hearing from you. Paris
€60 EUR in 3 days
4.9 (291 reviews)
7.6
7.6
13 freelancers are bidding on average €50 EUR for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for Develop database and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Programming, Excel, Microsoft Access, SQL, Visual Basic We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
€80 EUR in 3 days
4.9 (346 reviews)
8.0
8.0
User Avatar
I think I can help you on your project. I believe that a VBA script could solve all steps that you had described. I think that I could do the entire assignment within 4-5 days. My proposal is to do each step in 1 day and send to you, so you can test it and send me the feedback if that it's ok or not. And I will let the VBA code open and with comments, so you could manipulate it freely. Feel free to contact me to discuss any further details about the project, my bid and deadlines. Best Regards.
€26 EUR in 5 days
5.0 (14 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
€55 EUR in 1 day
4.1 (6 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
€44 EUR in 2 days
3.9 (6 reviews)
2.3
2.3
User Avatar
can do it
€22 EUR in 1 day
4.3 (3 reviews)
2.3
2.3
User Avatar
A proposal has not yet been provided
€48 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can deliver this project using SQL Server. If you have SQL Server installed in your local, you can use that solution. I will load those 2 data files into SQL Database table and then i will process required through Stored Procedure. In between, i will create some tables to store aggregated data (max, min, mean, avg etc) , another table to save data with different time value ex:till min, hours, days, month, year etc. After that you can use those table in Excel Pivot table to check this solution. Please check my profile and let me know if you find my profile for this project. For future enhancement, either you need to import these table and query in access or you can use have some knowledge in SQL to update this solution in SQL Server database.
€34 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FRANCE
Piégon, France
5.0
2
Payment method verified
Member since Apr 7, 2012

Client Verification

Other jobs from this client

Excel vba macro
€35-65 EUR
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.