Find Jobs
Hire Freelancers

develop a code to sort data

$30-250 USD

Cancelled
Posted over 7 years ago

$30-250 USD

Paid on delivery
I want a code that sorts data obtained from a time attendance app. The data has employee ID, name, and sign on time and sign off time as well as the longitude. However, this data is not sorted at all. So it does not make much sense. I want a code that will sort the data in a form from which: Identifiers such as Job ID and name is used as identifier. Then, from the data, sorted and entered in a form or table, there shall be column for sign on/ sign off. From that, the hours worked can be stated and if less than the set shift hours, then the person is marked as late. If 24 hours passes without a registered ID registering time, then they shall be marked as absent. If someone works two shifts the same day, then they are entered in a form for overtime, with date and location set as well. Maybe this will be a good guide. 1. From the unsorted data, filter and import data and i. Create columns for: a. ID, Name, Date, sign on, sign off time, longitude/latitude. ii. From the created table, then sort the data based on: a. If sign the difference between sign off and sign on time for the same day is less than 8 hours, then, record in a column for lateness. b. If a registered ID and name misses time for a whole day, over 24 hours, record under absent. c. If someone clocks and works at intervals of 8 hours twice in a day, record as overtime. d. Develop a chart showing, lateness, absent overtime. 2. The code should enable someone to paste data in one form and it is sorted to give the above data. 3. I have attached a sample data. 4. This code can be sent to work in any software platform that you think is the best. But the output format for the sorted data have to be in excel, pdf, etc.
Project ID: 12306621

About the project

22 proposals
Remote project
Active 7 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
22 freelancers are bidding on average $142 USD for this job
User Avatar
Hello I'm interesting your project very well I'm a Good C++, Java, PHP, DB, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks
$155 USD in 2 days
4.9 (1059 reviews)
9.4
9.4
User Avatar
A proposal has not yet been provided
$166 USD in 2 days
5.0 (91 reviews)
7.5
7.5
User Avatar
I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 6 years. My work is online game developing, and mainly focus on server side, using c++ under linux environment. I used c++ to make many great projects, for example, I made the tools which can convert java files into c++ scripts, of course garbage collection included, this job is very similar to a compiler, and is very complex. I also made our own mobile game using c++, I can show you the demo of client, if you like. I am very proficient in java also. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you.
$150 USD in 3 days
4.9 (159 reviews)
7.2
7.2
User Avatar
hi I am a php developer with expertise in many php frameworks and cms. I have read thru your requirements and I can do it for you in 2 days time. I will use php for this , and it has libraries like tcpdf,dompdf for pdf generation and phpexcel for excel format . I have experience building project management system, attendance/leave management system for my company and we have sold in codecanyon. So I think I can do this task for you with grace. If interested please msg me Thanks
$166 USD in 3 days
5.0 (36 reviews)
6.2
6.2
User Avatar
hello,how are you. i read your bid carefully. i am c/c++, algorithm expert and have full experience for 10 years. c++ language is my top skill. i can provide most quality and high speed. if you want to success, please contact me. Then, I will give you good result to the proposals. hire me.
$155 USD in 3 days
4.8 (51 reviews)
6.4
6.4
User Avatar
Hello, It'd be my pleasure to work on this project for you ! I am a very experienced PHP developer and this shouldn't be an issue at all to code. If you need more informations, let me know ! Regards
$80 USD in 10 days
4.9 (26 reviews)
5.0
5.0
User Avatar
Hello
$250 USD in 3 days
5.0 (24 reviews)
4.7
4.7
User Avatar
I will develop a python script to perform this task. The script will import all the data in a sqlite table if there are too many requirements to use memory only and then easily sort according to any requirements needed. Finally it will be exported to Excel (.xlsx or .xls) format as requested.
$155 USD in 3 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hello! I`m experienced R programmer and R is special language to deal with data frames. I have done many tasks like this before. The output can be saved to csv/excel
$80 USD in 3 days
5.0 (1 review)
3.1
3.1
User Avatar
Hello sir, Hope you doing well, i read your project description so pls come technical discussion then we understand n negotiate cost, timeline then we move proceed further , also i show my past work when we discuss.. thanks.
$170 USD in 10 days
4.3 (15 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
$133 USD in 3 days
5.0 (1 review)
2.7
2.7
User Avatar
Dear I will get the job done with minimum cost and maximum quality . I care much about your due dates and all my projects are guaranteed for one month for testing and reviews even after your Acceptance . Txt me.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in data processing and modeling and can do this either in excel or R.
$220 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Kindly share the module requirements with us to start working on coding. Look forward to your reply. Best regards, Ashish
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can implement it through java
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have 15 years of experience in working with Matlab, C++, Python, etc , and Two masters in Electrical and Mechanical engineerings. I am currently working through my PhD in Mechanical engineering. You can find out about my credential by searching my name in LinkedIn. I am confident I can deliver the project, and be an asset for your future references. I am eagerly waiting to hear from you, Sincerely, Hadi Hajieghrary
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very good at Data Structures and Algorithms and I can solve your problem by keeping time complexity in mind i.e. using efficient algorithm.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
can do it
$150 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KENYA
nairobi, Kenya
4.9
9
Payment method verified
Member since Jun 19, 2013

Client Verification

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.