A tough one!

  • Thread starter Thread starter Pico
  • Start date Start date
P

Pico

Hi,
This one has stumped me!! I've got daily reports that I
need to take data from, Im looking to create a file where
i can just type in two dates and I can bring up a graph
for all the values between those dates. Im not really
keen to put all the data on one sheet just now as its
Pressure values every 10 mins so would be massive. A
database is being created at the end of the year so just
looking for somthing simple to get us through the rest of
this year. Also does anyone know a way that when the new
reports come through their data can automatically be
included?

Thanks for your help.
 
What form are your daily reports in?

Basically, you need a chart data area that can flexibly return data from a lot of different files, which might be possible if your files are consistent and consistently named in some way. Need a bit more info about your data really.
 
They are consistently set up in the the same way in the
sheets, the naming of the files can always be adjusted
easliy enough its just dates. In the sheets I require the
info from, the date is on the left of the file, then I've
got 144 spaces until the next date, and in Column B I've
got values in every cell?


-----Original Message-----
What form are your daily reports in?

Basically, you need a chart data area that can flexibly
Click to expand...
return data from a lot of different files, which might be
possible if your files are consistent and consistently
named in some way. Need a bit more info about your data
really.
 
Hi

Hi

Those daily reports - what they are. Excel workbooks? CSV-files? Text files?
And how are those reports structured?

Some data after every 10 minutes, this is 144 rows of data in 24 hrs - and
52560 - 52704 rows in year. Really a bit too much for Excel. Of course you
can do it with excel too (probably using a lot of VBA coding for it), but
whenever it's possible, collect your measuring data directly into p.e.
Access database. You can then continue with your graph directly in Access,
or you can query this database from Excel, using ODBC (you can edit the
QueryString so, that given datarange read from worksheet is used as WHERE
clause). As retrieved datarange isn't fixed, you have to define all series
for graph as dynamic named ranges (define the name in form
SheetName.RangeName), and then you have to refer to them in graph wizard
like: SheetName!RangeName
 
Sorry, I'm a bit confused. daily reports with more than one days data? What does each file contain? Is data duplicated over more than one file, or do you need all the files to get all the data? If each file contains all the data up to a certain date, then the problem is much simpler to resolve.
 
Sorry what I ment was if you were to extract the required
data from one days report, then extract the data from the
next days report and placed it all on a new sheet, thats
the situation you would be left with, yes I do require
all the files to get all of the data.



-----Original Message-----
Sorry, I'm a bit confused. daily reports with more than
Click to expand...
one days data? What does each file contain? Is data
duplicated over more than one file, or do you need all
the files to get all the data? If each file contains all
the data up to a certain date, then the problem is much
simpler to resolve.
 
Back
Top