![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Data entry + google sheets formula
- or -
Post a project like this99
£30(approx. $39)
- Posted:
- Proposals: 15
- Remote
- #4180988
- PRE-FUNDED
- Awarded
DATA SCRAPPING | DATA ENTRY | EXCEL GOOGLESHEET GURU | PYTHON SCRIPT | ADMIN ASSISTANT | EXCEL DASHBOARD
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
WordPress Developer and Designer | Shopify Customization | Go High Levels Expertise
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Expert Graphic Designer |Logo Designer |Graphic Animations|Illustration | 3D designer| Video Editor
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX | 3D Architecture | Video Editing |Photoshop Expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Graphic Designer|Video editing|2D/3D Logo I Animation | Content Writer | Web Content | Data Entry | Translator | Specialized in Power Point, Excel, Word, Translation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Web developer|| Mobile App Developer | Wordpress | PHP Laravel | Flutter App Developer | Ecommerce | Android App | IOS APP
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Pro Designer✮WordPress✮Laravel✮Full Stack✮Data Analyst✮Python✮Next JS✮Excel expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
976031431510051083884766081731101940633061749152355595797610889716109215881004965811151305
![Armaghan A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/29108d4bf232f820a0e10142eb76097f_70x70.jpeg)
![Jam Mahmood A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/7e875414419d7ad13982e309cd741c50_70x70.jpeg)
![Sana J.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/cc24146a0562ef1ec78236ba6af69f95_70x70.jpg)
![Laiba ..](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/843b8b01ab80456cce95dd1990e11362_70x70.jpg)
Description
Experience Level: Entry
Estimated project duration: less than 1 week
Hi,
I have 21 pages like the one attached with this project (sample.jpg) which shows the first 35 rows, for a total of 678 rows. The first task I need doing is for this data to be entered into a google sheets spreadsheet. The 'position', 'cap' and 'name' fields have already been entered. I now only need the 'arrival date' and 'arrival time fields' to be filled out.
In addition to this, I want to add a column to the spreadsheet for 'time elapsed'. This will be the time in days, hours and minutes that has elapsed between the start time + date and the arrival time and date mentioned in the 'arrival date' and 'arrival time' column for each row. The start date is 10/02/24 and the start time is 18:10. All arrivals are also in February 2024.
I have provided a link to a spreadsheet that shows an example of the format desired. Upon acceptance of the project, I will share a spreadsheet where the 'position', 'cap' and 'name' fields have already been filled in.
I do not want the elapsed time to be manually calculated and entered each time. I would like a formula entered into the spreadsheet that looks up the arrival date and arrival time for each row and provides the elapsed time in the format 'XXDXXHXXM', where D is for Days, H is for Hours and is for Minutes.
Finally, this project contains one more task. The data here is for the arrival times of participants in a race at three checkpoints and the finish line. I would like to know the relative position change of each participant at each of the checkpoints. For example : If I participant is in first position at the first checkpoint but is in 5th position at the 2nd checkpoint, +4 should be added into the relevant cell. If the participant was in 10th position at the first checkpoint then arrived in first position at the second checkpoint, -9 should be entered in the relevant cell. It would be great if this could be automated in the spreadsheet but if that is not possible then it will need to be manually calculated and entered for each partipant arrival. You will also see that the number of participants decreases from one checkpoint to the other. This is because there were participants who did not finish the event. I would like a list of the participants for each checkpoint that dropped out of the race at that checkpoint. If they do not appear in the next checkpoint list, then they have dropped out of the race.
I have assigned a budget of £30 for this project. Please let me know if this is sufficient for the task at hand.
Here is the link for the example google sheet :
https://docs.google.com/spreadsheets/d/1NCN7CUQn8THzdG9c8X6NLWFJwzMIR9_3ieUPj7Ke30k/edit?usp=sharing
I have 21 pages like the one attached with this project (sample.jpg) which shows the first 35 rows, for a total of 678 rows. The first task I need doing is for this data to be entered into a google sheets spreadsheet. The 'position', 'cap' and 'name' fields have already been entered. I now only need the 'arrival date' and 'arrival time fields' to be filled out.
In addition to this, I want to add a column to the spreadsheet for 'time elapsed'. This will be the time in days, hours and minutes that has elapsed between the start time + date and the arrival time and date mentioned in the 'arrival date' and 'arrival time' column for each row. The start date is 10/02/24 and the start time is 18:10. All arrivals are also in February 2024.
I have provided a link to a spreadsheet that shows an example of the format desired. Upon acceptance of the project, I will share a spreadsheet where the 'position', 'cap' and 'name' fields have already been filled in.
I do not want the elapsed time to be manually calculated and entered each time. I would like a formula entered into the spreadsheet that looks up the arrival date and arrival time for each row and provides the elapsed time in the format 'XXDXXHXXM', where D is for Days, H is for Hours and is for Minutes.
Finally, this project contains one more task. The data here is for the arrival times of participants in a race at three checkpoints and the finish line. I would like to know the relative position change of each participant at each of the checkpoints. For example : If I participant is in first position at the first checkpoint but is in 5th position at the 2nd checkpoint, +4 should be added into the relevant cell. If the participant was in 10th position at the first checkpoint then arrived in first position at the second checkpoint, -9 should be entered in the relevant cell. It would be great if this could be automated in the spreadsheet but if that is not possible then it will need to be manually calculated and entered for each partipant arrival. You will also see that the number of participants decreases from one checkpoint to the other. This is because there were participants who did not finish the event. I would like a list of the participants for each checkpoint that dropped out of the race at that checkpoint. If they do not appear in the next checkpoint list, then they have dropped out of the race.
I have assigned a budget of £30 for this project. Please let me know if this is sufficient for the task at hand.
Here is the link for the example google sheet :
https://docs.google.com/spreadsheets/d/1NCN7CUQn8THzdG9c8X6NLWFJwzMIR9_3ieUPj7Ke30k/edit?usp=sharing
![Nelson T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/0723b048b523ef22ed5089b5f4a8ade8_150x150.jpg)
Nelson T.
100% (9)Projects Completed
11
Freelancers worked with
11
Projects awarded
17%
Last project
5 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies