Lukket

Excel macro data extract

Hi,

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

Færdigheder: Ingeniørarbejde, PHP, Software Arkitektur

Se mere: report pdf, summary resume, skip logo, resume summary, resume professional summary, resume engineering, professional summary resume, mind machines, excel macro file location, engineering resume format, engineering resume, eliminate paper, data graphs, create construction logo, create company logo line, construction resume, company logo paper, attached resume, hrs data, dd logo, generate company logo, engineering report format, summary table, raw data, mm logo

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

Projekt-ID: #4049306

19 freelancere byder i gennemsnit $1128 for dette job

SigmaVisual

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)
7.7
WebBizSolution

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

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

Hi! I'm interested in it

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

Hi, Please check private message.

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

Please check PMB for more details. Thanks

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

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)
5.3
jal540

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)
5.2
softwarehandyman

"Please see PMB"

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

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

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

Hi, I can start now , please check PM.

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

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 Mere

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

Looking forward to working with you...

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

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

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

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)
3.1
getveltrod

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 Mere

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

I can do this....

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

consider it done . !!! check pm.

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

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

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

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

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

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

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