Find Jobs
Hire Freelancers

Develop database

€20-60 EUR

I përfunduar
Postuar about 6 years ago

€20-60 EUR

Paguhet në dorëzim
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
ID e Projektit: 16489559

Rreth projektit

13 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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 në 3 ditë
4,9 (291 përshtypje)
7,6
7,6
13 freelancers are bidding on average €50 EUR for this job
Avatari i Përdoruesit
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 në 3 ditë
4,9 (346 përshtypje)
8,0
8,0
Avatari i Përdoruesit
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 në 5 ditë
5,0 (14 përshtypje)
3,4
3,4
Avatari i Përdoruesit
A proposal has not yet been provided
€55 EUR në 1 ditë
4,1 (6 përshtypje)
3,4
3,4
Avatari i Përdoruesit
A proposal has not yet been provided
€44 EUR në 2 ditë
3,9 (6 përshtypje)
2,3
2,3
Avatari i Përdoruesit
can do it
€22 EUR në 1 ditë
4,3 (3 përshtypje)
2,3
2,3
Avatari i Përdoruesit
A proposal has not yet been provided
€48 EUR në 4 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 në 3 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i FRANCE
Piégon, France
5,0
2
Mënyra e pagesës u verifikua
Anëtar që nga pri 7, 2012

Verifikimi i klientit

Punë të tjera nga ky klient

Excel vba macro
€35-65 EUR
Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.