Completed

Simple Excel (CSV) Filter Project

Should only take a few hours, if that to complete.

User will upload a CSV file with the following columns:

Unique ID, Parent First Name, Parent Last Name, Parent E-Mail Address, First Name, Last Name, Number of Visits, Date of Last Visit and Visit Dates

Immediate export of same file except that code will analyze csv file based on:

- Each unique ID and find the number of days between date of last visit and most recent visit prior to that and add that number in an additional column labeled Days Between Most Recent and Last

Then it will purge all duplicate rows for that unique ID and leave just one row for that unique ID that has the most recent Visit Date in it.

To give you an example of the process, the first file shows what the file would look like when uploaded.

The second image shows you what data to look for, first the unique ID, second the most recent visit date and third the most recent Previous visit date.

The third file shows you the end result of what the file should look like. You'll see all the extra lines have been purged leaving a clean file with only one of the unique ID's for each customer, the row that is left is based on the Visit Dates column and it is the date that is PREVIOUS to the MOST RECENT (or what is in the Date of Last Visit column). You'll also see it appended the number of days between PREVIOUS most recent date and Date of Last visit date.

You do not have to save anything to database if you don't want to, you don't have to save files to server, you don't have to change any columns around, or have logins or users accounts, literally is just an upload and download project.

It must be able to handle a lot of records, must be able to do calculation. Only one file will be uploaded/processed at a time so no need for batch uploading, etc.

Skills: Data Processing, Excel, Import/Export, MySQL, PHP

See more: simple excel project grade, convert excel csv delimiter tab, j2me simple excel, simple excel vba, excel csv oscommerce, convert excel csv tab delimiter file cnet, excel give thanks project, delphi excel csv, creating simple excel project, simple excel visual basic project, simple excel financial project report, simple excel project analysis, excel filter project, simple excel project input data, simple excel project list, simple excel work project, simple excel project database, simple excel to track freelance project

About the Employer:
( 6 reviews ) Grand Rapids, United States

Project ID: #17920312

Awarded to:

NayaPakistan

Hello there. I can create a php script to filter the CSV file as per the details mentioned. Please send me a message to get started. Thanks

$50 USD in 1 day
(266 Reviews)
6.7

35 freelancers are bidding on average $32 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$100 USD in 1 day
(636 Reviews)
8.3
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Simple Excel (CSV) Filter Project. I've delivered more than 400 + projects in the last 5 years and this makes me very confident w More

$100 USD in 2 days
(308 Reviews)
7.7
$19 USD in 1 day
(268 Reviews)
7.4
theincredible

Hello sir, I have reviewed the attached images for before and after dta processing, I can do it as per your requirements and I can deliver it within 24 hours max. Thanks

$50 USD in 1 day
(133 Reviews)
7.1
safiqulislam67

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu More

$30 USD in 1 day
(140 Reviews)
6.6
polarjin2017

Hello? How are you? I have good skills in this type jobs..... So I can complete your job in time. Hope to work with you. Thank you.

$55 USD in 3 days
(106 Reviews)
6.8
customizedata

I have gone through the 3 attached images and have got the idea. 1- Please provide sample CSV file . 2- I will make an executable having a browse file and Start process button. Upon clicking button it More

$35 USD in 1 day
(117 Reviews)
6.2
binaryromel

Hi there, I'm expert in Advance Excel, Formula and Function. I've analytical ability to make report. Please check my profile as I've similar job experience. I'm ready to start immediately. Waiting for your More

$50 USD in 1 day
(100 Reviews)
6.1
nicrosoft

Respected Employer, I am a website developer having competitive expertise and experience in Web development, database development and database management, data processing etc. I will deliver you with in next 5 to 8 More

$10 USD in 1 day
(22 Reviews)
4.8
jsb1156

Experienced project professional, US based, MBA, EXCEL and MS Project expert; also experienced with complex formulas, LOOKUPS, PIVOTS, and charts. I would be glad to assist with your CSV conversion project. Thanks More

$30 USD in 1 day
(13 Reviews)
3.7
dataexplorer

"Hello, I am happy to inform you that I have read your project ""Simple Excel (CSV) Filter Project "" description and understood all of your required requirement. I'd like to help you with confidence and satisfying More

$30 USD in 7 days
(14 Reviews)
3.4
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$30 USD in 1 day
(11 Reviews)
3.0
nishantha041

Dear sir, I can meet your requirement through a excel vba development.i have developed many excel solutions as well. Thank you

$14 USD in 3 days
(4 Reviews)
2.9
zaahidali61

hi next employer, I am interested in your project. I hold master degrèe in finance. Having more than 9 years experience of data entry, web scraping,  excel based projects. hope you give a chance to work with you

$15 USD in 1 day
(5 Reviews)
2.8
incomepay0153

Hello Dear. I am a Professional Virtual Assistant & Lead Generator Expert. i saw you job Description. it is very nice. I saw your samples beautifully. I can do your work within 2-3 hours. You can hire me if More

$25 USD in 0 days
(3 Reviews)
2.5
ramizq922

Hi I have read your whole description & saw the attachments and i can complete your work in 3 hrs i have 7 member in my Team all Expert with 7 years experience Excel & VBA Macros with 93 Word Per Minute if you can see More

$30 USD in 1 day
(3 Reviews)
2.4
Farhinzaffar1

i am Data Entry. Data processing expert who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without adding additional charges. If you are looking More

$10 USD in 1 day
(5 Reviews)
2.3
srijanagrawal21

About me & what I can provide - • I understand that you want only one row in data after processing and the row should have visit JUST BEFORE the last visit • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Form More

$25 USD in 1 day
(3 Reviews)
1.7
atifzinbox

Hi, I can provide you this within a day. Please let me know if you are interested. I will create PHP application to handle all this.

$70 USD in 1 day
(2 Reviews)
1.4
Wantse

Hello, I plan on using MS Excel formulas to calculate the days between the dates and after calculation is done, then it removes the duplicates.

$30 USD in 1 day
(1 Review)
0.8