Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating a data file with some sort of Macro
If anyone could help it would be great. I am currently working on a dat
collection project dealing with strain data from a bridge. I downloa the data via a datalogger in a comma delimiated format. Each item i the data set has its own value. Lets say I have 65 strain gages tha are collecting data and I record every 10 minutes and download once week. Thats 655200 data points a week. Needless to say, the excel shee gets very large very quickly. In the past others have opened eac downloaded data set and manually copied the data from a particular gag and created a file that only contains information for that gage. So eac week they had to copy and paste into 65 different files. My question is, is there anyway to create a macro to help. Lets say.. Converting the comma format to columns, then picking out a certai column and copying the data from that column and inserting it into file that has already been created to store data from that gage ever week. This would require that the data be inserted at the bottom of th data that has already been included in that created file. If this coul be done it would cut out a lot of data processing work for us students Thanks for any help you could give -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating a data file with some sort of Macro
Yes, a macro can be written for this, but to do so requires SPECIFIC
information about the layout of the original text file, the criteria for identifying a gauge, the number of columns of data, the names of the workbooks to which it is to be copied, etc. Perhaps you should be using a database program like Access for this. It's much better at handling large data sets, and would allow you to more easily do any calculations that require data from more than one gauge, etc. You can also import into Excel data that results from an Access query, in order to do more complicated calculations. On Thu, 16 Sep 2004 23:25:09 -0500, taldridg2 wrote: If anyone could help it would be great. I am currently working on a data collection project dealing with strain data from a bridge. I download the data via a datalogger in a comma delimiated format. Each item in the data set has its own value. Lets say I have 65 strain gages that are collecting data and I record every 10 minutes and download once a week. Thats 655200 data points a week. Needless to say, the excel sheet gets very large very quickly. In the past others have opened each downloaded data set and manually copied the data from a particular gage and created a file that only contains information for that gage. So each week they had to copy and paste into 65 different files. My question is, is there anyway to create a macro to help. Lets say... Converting the comma format to columns, then picking out a certain column and copying the data from that column and inserting it into a file that has already been created to store data from that gage every week. This would require that the data be inserted at the bottom of the data that has already been included in that created file. If this could be done it would cut out a lot of data processing work for us students. Thanks for any help you could give. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating ranges in a different file | Links and Linking in Excel | |||
Manipulating ranges in a different excel file | Excel Worksheet Functions | |||
Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) | |||
Manipulating 150+ checkboxes with a macro in Excel 2000 | Excel Programming | |||
Manipulating 150+ checkboxes with a macro in Excel 2000 | Excel Programming |