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.

Evner: Ingeniørarbejde, PHP, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Pittsburgh, United States

Projekt ID: #4049306

19 freelancere byder i gennemsnit $1128 på dette job


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 in 7 dage
(220 bedømmelser)

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, Flere

$1777 USD in 15 dage
(52 bedømmelser)

Hi! I'm interested in it

$1000 USD in 7 dage
(48 bedømmelser)

Hi, Please check private message.

$1500 USD in 25 dage
(31 bedømmelser)

Please check PMB for more details. Thanks

$2000 USD in 30 dage
(138 bedømmelser)

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 in 30 dage
(128 bedømmelser)

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

$1500 USD in 30 dage
(32 bedømmelser)

"Please see PMB"

$1200 USD in 7 dage
(43 bedømmelser)

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

$1499 USD in 15 dage
(22 bedømmelser)

Hi, I can start now , please check PM.

$750 USD in 2 dage
(32 bedømmelser)

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 Flere

$750 USD in 14 dage
(3 bedømmelser)

Looking forward to working with you...

$750 USD in 2 dage
(5 bedømmelser)

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

$750 USD in 4 dage
(4 bedømmelser)

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 in 5 dage
(3 bedømmelser)

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 Flere

$1200 USD in 25 dage
(5 bedømmelser)

I can do this....

$750 USD in 5 dage
(0 bedømmelser)

consider it done . !!! check pm.

$750 USD in 10 dage
(0 bedømmelser)

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

$1500 USD in 9 dage
(0 bedømmelser)

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

$750 USD in 30 dage
(0 bedømmelser)

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. Flere

$1800 USD in 20 dage
(0 bedømmelser)