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.

Kemahiran: Pemprosesan Data, Excel, Import/Export, MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 6 ulasan ) Grand Rapids, United States

ID Projek: #17920312

Dianugerahkan kepada:


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 dalam sehari
(272 Ulasan)

34 pekerja bebas membida secara purata $32 untuk pekerjaan ini


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 ( Lagi

$100 USD dalam sehari
(657 Ulasan)

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 Lagi

$100 USD dalam 2 hari
(322 Ulasan)
$19 USD dalam sehari
(277 Ulasan)

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 dalam sehari
(133 Ulasan)

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 Lagi

$30 USD dalam sehari
(145 Ulasan)

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 dalam 3 hari
(115 Ulasan)

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 Lagi

$35 USD dalam sehari
(117 Ulasan)

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 Lagi

$50 USD dalam sehari
(100 Ulasan)

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 dalam sehari
(22 Ulasan)

"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 Lagi

$30 USD dalam 7 hari
(18 Ulasan)

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 Lagi

$30 USD dalam sehari
(14 Ulasan)

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 dalam sehari
(8 Ulasan)

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 Lagi

$25 USD dalam sehari
(14 Ulasan)

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

$14 USD dalam 3 hari
(4 Ulasan)

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 Lagi

$25 USD dalam 0 hari
(3 Ulasan)

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 Lagi

$30 USD dalam sehari
(4 Ulasan)

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 Lagi

$10 USD dalam sehari
(5 Ulasan)

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 dalam sehari
(2 Ulasan)

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 dalam sehari
(4 Ulasan)

Pay me only if you are satisfied with my work

$25 USD dalam sehari
(0 Ulasan)