Excel macro data extract


I would like a script / macro in Excel to filter data and generate reports based on valid data.

I have numerous text files that contain +30k lines of data separated by commas. Each file represents the activities of a piece of construction equipment with each line reporting the output of the instrumentation on the machines for that second. So the data comes in at one hertz and a file contains approx 12 hrs of recording.

The program needs to:

- Read the file and report strings of data that delineate the installation of a product in a single report for each installation.

- There are between 300-900 reports per file.

- Each report needs to show the raw data, show a summary table that gives max depth, max pressure, location, time start & finish etc., and 1 or 2 graphs (see below)

- In addition to a report for each installation, the program should create a summary report that lists the each of the summaries from the individual reports.

- Each continuous string of valid depths should be summarized in one report containing no more than 60 lines of raw data (for printing purposes).

- Installation start of a product can be inferred by depth reading going above zero and installation stop can be inferred by depth reading going blow zero (or 2 to eliminate some instrumentation inaccuracy)

- There will be times when there will be more than 60 lines of continuous valid depth readings. In these cases there will be many lines that have the same depth reading. In these instances the program should report a few ( ~4) lines of stagnant reading and then skip to the last line of the same depth and resume reporting normally.

- The raw data files have a date format of dd/mm/yyyy, the reports should output date in mm/dd/yyyy format.

- Each individual report needs to graphically represent the relationship between depth and pressure vs. time.

- Each page needs to have some bacground information that can be input prior to processing as well as a company logo.

- Formatiing should be uniform and look professional and should be made such that each report can be easily printed to pdf or paper for reporting and archiving.

This program does not need to utilize excel, that would be the most logical solution in my mind.

I have attached a typical raw data file (r1 8-23-12.txt.)

Software solution is desired ASAP
Posted budget reflects low end of anticipated cost. All reasonable offers will be entertained.

Kemahiran: Kejuruteraan, PHP, Kejuruteraan Perisian

Lihat lagi: report pdf, summary for resume, string processing in c, skip logo, should my resume be one page, resume summary, resume professional summary, resume engineering, professional summary resume, professional summary for resume, mind and machines, graphs with data, graphs of data, graphs for data, graphs data, excel macro file location, engineering resume format, engineering resume, eliminate paper, data in graphs, data graphs, data for graphs, data and graphs, create construction logo, create a construction logo

Tentang Majikan:
( 0 ulasan ) Pittsburgh, United States

ID Projek: #4049306

19 pekerja bebas membida secara purata $1128 untuk pekerjaan ini


I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$750 USD dalam 7 hari
(220 Ulasan)

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Lagi

$1777 USD dalam 15 hari
(52 Ulasan)

Hi! I'm interested in it

$1000 USD dalam 7 hari
(48 Ulasan)

Hi, Please check private message.

$1500 USD dalam 25 hari
(31 Ulasan)

Please check PMB for more details. Thanks

$2000 USD dalam 30 hari
(138 Ulasan)

I can take on the job and provide an Excel Macro based solution. Please have a look at my profile and let me know.

$1200 USD dalam 30 hari
(128 Ulasan)

I have excellent ratings and have developed many custom VBA programs in Excel, including for data analysis. Please see my PM.

$1500 USD dalam 30 hari
(32 Ulasan)

"Please see PMB"

$1200 USD dalam 7 hari
(43 Ulasan)

Professional here............................Can do in reasonable budget

$1499 USD dalam 15 hari
(22 Ulasan)

Hi, I can start now , please check PM.

$750 USD dalam 2 hari
(32 Ulasan)

We have a huge amount of experiences in data parsing, transformation, adapting it to the needed format. Please consider that the project will be in the hands of the team who is able to tackle all the challenges most ef Lagi

$750 USD dalam 14 hari
(3 Ulasan)

Looking forward to working with you...

$750 USD dalam 2 hari
(5 Ulasan)

Hi, I can do the job, please see your private message box for details.

$750 USD dalam 4 hari
(4 Ulasan)

Hi, I can do the job, MS Access, Excel Expert, experience dealing with big and small databases Please check PMB I am looking forward to work with you Regards Diego

$750 USD dalam 5 hari
(3 Ulasan)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Lagi

$1200 USD dalam 25 hari
(5 Ulasan)

I can do this....

$750 USD dalam 5 hari
(0 Ulasan)

consider it done . !!! check pm.

$750 USD dalam 10 hari
(0 Ulasan)

I can do your project with the given period and good in this type of project.

$1500 USD dalam 9 hari
(0 Ulasan)

Hi, you need professional help, I am used to excel macro

$750 USD dalam 30 hari
(0 Ulasan)

Hi, Can you make me clear about it first. The first line: "23/08/2012,07:11:37,140+00.0,0.0,$$$$$$$,$$$$$$,-1.1,$$$$$$$$,-0.8?,1.3?,Non-differential,157.8?". Please tell me what is the value of special character. Lagi

$1800 USD dalam 20 hari
(0 Ulasan)