Simple Excel (CSV) Filter Project

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

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.

Databehandling Excel Import/Export MySQL PHP

Projekt-id: #17920312

About the project

33 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

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 inom 1 dag
(330 omdömen)
6.8

33 frilansare har lagt bud på i genomsnitt $33 för det här jobbet

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 Mer

$100 USD inom 2 dagar
(384 omdömen)
8.1
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 inom 3 dagar
(180 omdömen)
7.2
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 inom 1 dag
(133 omdömen)
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 Mer

$30 USD inom 1 dag
(191 omdömen)
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 Mer

$35 USD inom 1 dag
(119 omdömen)
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 Mer

$50 USD inom 1 dag
(118 omdömen)
6.2
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 inom 1 dag
(50 omdömen)
5.2
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 Mer

$30 USD inom 7 dagar
(20 omdömen)
4.7
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 inom 1 dag
(15 omdömen)
4.1
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 Mer

$25 USD inom 1 dag
(29 omdömen)
3.9
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 Mer

$10 USD inom 1 dag
(21 omdömen)
3.5
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 inom 3 dagar
(4 omdömen)
2.9
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 Mer

$25 USD inom 0 dagar
(3 omdömen)
2.6
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 Mer

$30 USD inom 1 dag
(4 omdömen)
2.5
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 inom 1 dag
(2 omdömen)
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 inom 1 dag
(4 omdömen)
1.6
ITIDevelopers

Hello, I am expert in excel, data processing can help you in what you need quickly and with high quality Many thanks, Hoda

$13 USD inom 2 dagar
(0 omdömen)
0.0
saranyaramesh040

I have very good typing speed with accuracy. Know the value of time too. Have experience in data entry, email handling, chat support. worked with telecommunication company as a project specialist.

$15 USD inom 1 dag
(0 omdömen)
0.0
vipintc

Pay me only if you are satisfied with my work

$25 USD inom 1 dag
(0 omdömen)
0.0
azhar5675

I'm having experience in data entry field of 4 years

$25 USD inom 1 dag
(0 omdömen)
0.0