This project is for importing data info from simple CSV lines to excel.
Example of the data file is attached.
In the Example file are measurements made with human body analizator weight/FAT% scale.
This DATA should be imported into excel and sorted by the date of the measurement taken that is found in CSV file.
The importing process should be able to batch import all *.CSV files from one directory/folder (the program should ask which folder to choose for source) into appropriate excel files or sheets within the same excel file in one run.
Each CSV file will have in each line three values that will be always the same, and on the same place so the program/macro will automatically know where (which excel file/sheet) these data should go to.
When importing CSV file with new version of these three values found, the program will ask in which excel file should the data be imported. Then it will remember this for the next time and will do it automatically.
If the same data was already imported the line would not be imported, but it would be skipped.
After import, the excel files/sheets that got new data will be opened in excel.
In the excel file will also be present some extra columns, that I will be fillingwith data/adding manually. These to, will be used in graphical charts...
The data should then be represented graphically with nice charts.
And there should be an option to choose the range of data (from which date to which date) that should be represented in the charts.
And also an user friendly click-able option to show only the charts for specific measurements.
+In excel there should be an option of goal settings. Like manually entering data, that we are pursuing with this measurments. That could look just like one line on the top or on the bottom of imported lines. Then the charts could be represented with final goal in mind. Something like this maybe. [url removed, login to view]
So when I'll look on the chart I will know where I am. A relative Progress Towards concrete Goals.
I might get some other ideas later, but for now please bid for current described project and if we will add additional options not mentioned in the project description we will setup a new project or just negotiate the price for extra options...
PUT the word 'elephant' somewhere in the bid, so I will know that You are serious and that You read project description thoroughly.
Décerné à :
I have over 7 years experience developing custom VBA code for Microsoft Products including Access and Excel. I am available to work on this project immediately. Elephant
6 freelance font une offre moyenne de $82 pour ce travail
I see that in order to avoid all the problem. it would be good to have a program that would export all the information to excel. i am willing to get you the program to work to suite your needs