Terminé

Program for Data shifting in .csv excel file

I have uploaded here a .csv excel file in which a program needs to be developed.

It contains approximately 17 series of data e.g. column A to G represents 1st series, column I to T represents 2nd series and so on. There is a(one) column gap between each series.

First series A to G and last series GW to HC need not be done anything. Programming is required for second series to 16th series of data.

Each series contains a column heading TIME. Time generally starts from 9:16:00 for each series. But for some series time starts from different time e.g. for this source file, 2nd series time starts 9:16:00, 3rd series 9:18:00, 5th series 9:33:00 and so on. There is no guarantee of the extent of (Time) deviation for different series. When a new data is entered different series may have different extent of deviation.

A program needs to be developed to produce the result file, in which all data in the deviated series will be shifted downward equal to the extent of deviation. e.g. if deviation is by 1 minute, then it will be shifted by 1 column, if deviation is by 8 minutes then needs to be shifted in by 8 column...... equal to as shown in result file.

For 16th series many times there comes an extra row 9:15:00, which needs to be deleted (if present) and shift the whole data in that series upward, as shown in result file.

Data is reentered into the source file regularly, erasing the previous data. Once data is reentered the program will check the each series again and shift data accordingly.

If there is a shift in the series, the excel file usually asks to save the file before entering new file, as shown in the image file(uploaded). The program needs to be made, so that it automatically discard changes in (or never asks to save the change in) the excel file, which is made by the program. Otherwise new data cannot be reentered into the source file.

Compétences : Traitement de Données, Excel, Architecture Logicielle, Visual Basic

en voir plus : how to force excel to open csv files with data arranged in columns, how to open csv file in excel 2010, how to save csv file in excel 2013, how to force excel 2016 to open csv files with data arranged in columns, excel export sheet to csv, fix csv file, open csv file in excel without formatting, how to open csv file in excel with columns automatically, data non applicable excel file, copy data paste anther excel file macro, move data oracle database excel file using, csv excel file date format, aspnet capture form data export csv excel, data map csv import file, program extract data excel file, data excel file csv file mining, data entry projects excel file, data mining csv file excel, data entry work excel file, data countries details excel file

Concernant l'employeur :
( 4 commentaires ) JUNAGARH, India

Nº du projet : #18460381

Décerné à:

Ahmed818

Hello, sir i am interested in this project , i can begin now waiting your answer on chat Regards

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% INR en 0 jours
(42 Commentaires)
4.5

7 freelance font une offre moyenne de ₹1275 pour ce travail

macroPOL

Hello, I am Excel and VBA expert. I understand the requirements and I can do it today If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 0 jours
(78 Commentaires)
5.8
manishadk

Hi, I have more than 10 years of experience in software development. I can write a macro script program. We can place source csv file in particular folder. Macro script will read source file and will apply the shiftin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(21 Commentaires)
4.3
soltracker

yes buddy, me here to start, u will feel brotherhood,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(10 Commentaires)
2.3
i0xHeX

Hello, I'm experienced java developer and had a lot of work with data processing. I think I can complete that project in few hours. Program will check specified file every N time to ensure it was changed and then app Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(3 Commentaires)
1.5
cliffstats

Hello? I am a Data scientist with over 5 years experience in using python and excel for data mining, cleaning analysis, visualization and modeling. I can provide intuitive python or g-script (excel functions/formatting Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(1 Évaluation)
0.5
SushmaHR

I have 9 yrs of experience in data mining. Please give me a chance to work. I am a quick learner.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(0 Commentaires)
0.0