***IMPORTANT*** Only bid on this project if you can start right away
PROJECT DESCRIPTION STARTS HERE:
I have 2 Excel spreadsheets for 2017 that together have ~2,700 rows of credit card transactions.
For the two 2017 spreadsheets, I need a category value added in the Category column for each row.
Examples of "Category" values = Travel, Office Supplies, etc.
The categories can be derived in two ways:
1. by looking at similar category assignments given to the credit card charges for the 2 Excel spreadsheets from the previous year (2016)
2. by picking the best fit category [if you choose this method, you need another column that says "Best Guess"] from a list of categories that will be provided for you
3. if you can't figure out a category using methods 1 and 2, leave the field blank
If interested, please PM me for spreadsheet samples.
Working with Excel to create useful easy tools for Data Entry/Analysis/Visualization reports , developing tools using Formulas , tables , charts , Macro and VBA.
I work in the field of Accounting currently looking for any new job/work for monthly maintenance so interested in taking this work. As an accountant my maximum daily work in Excel only. I think can do this perfectly.
Thank you
Hello,
If I have well understood, the purpose of the work is to find the "best guess" as you described it for an unkown data.
I am working as a data analyst in a big industrial company and have just singed up to Freelancer.
If I get the chance to work on the project, I will use some simple algorithms of classification and prediction on the basis of the two methods provided in the description and try to take the value that minimizes the error.
My understanding will of course only be accurate when I take a look at the spreadsheets.
Please contact me ti discuss any further detail.
Good luck.
I have worked with vast amounts of data quickly and accurately. I can get your job done in 3days @ 20$/hr starting immidiatly.
Relevant Skills and Experience
I have with a lot of data in my previous projects.