Find Jobs
Hire Freelancers

166995 Excel / csv data

N/A

In Progress
Posted over 16 years ago

N/A

Paid on delivery
Greetings! I am in need of someone to go to a website and take multiple csv files and reformat them for me. Here are the specifics: Go to [login to view URL] Click on "Games" Mouse over "X-Hi/lo" Click on "stats" This will bring up multiple files listed by day. These files date back to September 25, 2006 through yesterday. It should be easy to see how you change the dates, and each file represents 1 day. I need the following for each file: 1. Column A has two game types: Turbo and Standard. I need all the Turbo removed. This will not be an issue in all files, just the older ones. 2. Then, I need you to filter out the data that does not relate to "Card 1 or further" in Colunm G. 3. This should leave you with about 350-500 lines of data per file / day. All relating to "Card 1 or further." 4. Then I need you to add a column to the right of column "i". Column I has eitehr a "1" or a "0" in it. This new column should translate the "1"s into "W" and the "0"s into "L" 5. All I need for each row is: column D (date / time), and the new column (which is either "W" or "L". the end result should be 350-500 lines with 2 columns as described above. 6. I need these files compiled into month periods (September 2006 is one file. October 2006 is another.) In these month files, i would want there to be one sheet with continuous lines merged from the seperate days. So chronologically it would be the first result from the 1st minute of the first day in that month going to down to the last results from the last minute of the last day of that month. 7. the final results should be pasted in "values" format, so i can easily cut and paste into another excel file to use. 8. You can either email me the files, or if you have an FTP where you can post the results, I can go get them. I will make my decision based on the following: 1. Your feedback must be good. 2. You must respond to me in a way that I know you have read and understood my request - don't just cut and paste a response. 3. You must speak english very, very well. If you cannot speak english well, I cannot use you. 4. Your cost must be competitive. 5. You must be able to complete the project quickly. I am open to questions or clarification. I always pay quickly, and make myself available to help you work faster. I will not use escrow. I will pay you through paypal. I will pay a portion up front to show you good faith, and the remainder as it is completed. Thanks! Michael
Project ID: 1913188

About the project

Remote project
Active 12 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

About the client

Flag of
5.0
29
Member since Sep 21, 2005

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.