I have data files that come in .csv or Excel format that I need processed and reorganized with their data in a series of new tables.
The data represents times when individuals complete certain tasks; each individual completes the same tasks in the same order. The times are given in "time of day" format; using a universal "start of day" time, we need to convert the time of day fields into fields indicating the number of seconds since the universal "start of day" time that each individual completed each task.
Then we need a table built for each task, indicating the time (in number of seconds) at which each individual completed each task.
It is my intention to connect via desktop share the first time we work together; I'll send you the procedure in a word processor document and we will complete the first spreadsheet together.
I will have about ten spreadsheets to process between now and the end of the year and I'm looking for a couple of people to help me process them all. For now, I'm offering one spreadsheet for you to do yourself.
To be clear: Your time commitment includes working through the first spreadsheet with me via desktop share *in addition to* completing the second spreadsheet by yourself.
I have examples of exactly how the final product should look; I am not looking for you to figure out how to do anything - just study our process and become an expert at it.
Accuracy is critical. We can only pay for accurate work.
35 freelancers are bidding on average $85 for this job
With my ETL experience and the fact that your data is in *.csv files, I can create an automated, repeatable process to do all of your files very quickly and accurately.