Prev: Query joining two tables with different dates
Next: totals do not display unless user clicks on text box
From: Matt S on 25 May 2010 13:58
Hello everyone,

I've been wondering this question for a few weeks now. My situation is that
I generate many "runlogs" from my reactor that have various outputs, such as
temperatures, sensor data, etc. versus time. Very frequently, I want to
compare one runlog to another. Sometimes I want to average the output of
several runlogs together. I currently have a macro made up in Excel that
analyzes the files, but it really is getting harder to manage all the excel
files floating around.

So is it worth dumping all the excel output from my macro into a database
and comparing them that way?

Thanks,
Matt
From: Jeff Boyce on 25 May 2010 15:05
Matt

Like an economist, which answer do you want?...(sorry, inside joke, no
unnecessary disrespect intended to economists)

MS Access is a relational database. If you want to get the best use of it,
you need to feed it well-normalized relational data.

If you've been using Excel, I'm sorry, but you may have to UN-learn some
things before you can get Access to work well.

And then there are the things you need to learn. In fact, I generally point
out at least four separate learning curves you'll want to consider:

1. relational database design -- it all starts with the data
2. Access tricks & tips -- I've been at it for over 15 years, and I'm
still learning...
3. Graphical User Interface -- if it isn't easy to use and understand,
it won't get used
4. Application development -- if you've never built a house, where do
you start?!

Sorry if that's a bit too generic, but you'll find that these newsgroups,
for as long as they continue (soon to be discontinued by Microsoft), work
best if you seek specific answers to specific questions.

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Matt S" <MattS(a)discussions.microsoft.com> wrote in message
news:F56A699E-574C-44AA-BFDA-BB8298985596(a)microsoft.com...
> Hello everyone,
>
> I've been wondering this question for a few weeks now. My situation is
> that
> I generate many "runlogs" from my reactor that have various outputs, such
> as
> temperatures, sensor data, etc. versus time. Very frequently, I want to
> compare one runlog to another. Sometimes I want to average the output of
> several runlogs together. I currently have a macro made up in Excel that
> analyzes the files, but it really is getting harder to manage all the
> excel
> files floating around.
>
> So is it worth dumping all the excel output from my macro into a database
> and comparing them that way?
>
> Thanks,
> Matt


From: Steve on 25 May 2010 15:40
Hi Matt,

Excel is good when you have a small number of scenarios to analyze. A
database is approproate when the number of scenarios is large. Obviously,
the number of scenarios is beyond what Excel can analyze efficiently for
you. So, Access is the appropriate tool for you. I provide help with Access,
Excel and Word applications for a small fee. Let me put together a database
for you that you can use to analyze your reactor data. I would import your
existing Excel data into the new database. My fee would be very reasonable.
The advantage to you would be you would get to see how an Access application
is put together, you would get a more efficient system for analyzing your
reactor data and at that point if you wanted to add more functionality you
could learn Access and add the new functionality yourself.

By the way, I was previously an engineer in a large refinery so am familiar
with reactor data.

Steve
santus(a)penn.com


"Matt S" <MattS(a)discussions.microsoft.com> wrote in message
news:F56A699E-574C-44AA-BFDA-BB8298985596(a)microsoft.com...
> Hello everyone,
>
> I've been wondering this question for a few weeks now. My situation is
> that
> I generate many "runlogs" from my reactor that have various outputs, such
> as
> temperatures, sensor data, etc. versus time. Very frequently, I want to
> compare one runlog to another. Sometimes I want to average the output of
> several runlogs together. I currently have a macro made up in Excel that
> analyzes the files, but it really is getting harder to manage all the
> excel
> files floating around.
>
> So is it worth dumping all the excel output from my macro into a database
> and comparing them that way?
>
> Thanks,
> Matt


From: Matt S on 25 May 2010 16:03
they're getting rid of these forums?! That's ridiculous... there's so much
I've learned from here! This is pretty much my go-to location for any VBA
coding!

Thanks for the reply, by the way.

Matt


"Jeff Boyce" wrote:

> Matt
>
> Like an economist, which answer do you want?...(sorry, inside joke, no
> unnecessary disrespect intended to economists)
>
> MS Access is a relational database. If you want to get the best use of it,
> you need to feed it well-normalized relational data.
>
> If you've been using Excel, I'm sorry, but you may have to UN-learn some
> things before you can get Access to work well.
>
> And then there are the things you need to learn. In fact, I generally point
> out at least four separate learning curves you'll want to consider:
>
> 1. relational database design -- it all starts with the data
> 2. Access tricks & tips -- I've been at it for over 15 years, and I'm
> still learning...
> 3. Graphical User Interface -- if it isn't easy to use and understand,
> it won't get used
> 4. Application development -- if you've never built a house, where do
> you start?!
>
> Sorry if that's a bit too generic, but you'll find that these newsgroups,
> for as long as they continue (soon to be discontinued by Microsoft), work
> best if you seek specific answers to specific questions.
>
> Best of luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "Matt S" <MattS(a)discussions.microsoft.com> wrote in message
> news:F56A699E-574C-44AA-BFDA-BB8298985596(a)microsoft.com...
> > Hello everyone,
> >
> > I've been wondering this question for a few weeks now. My situation is
> > that
> > I generate many "runlogs" from my reactor that have various outputs, such
> > as
> > temperatures, sensor data, etc. versus time. Very frequently, I want to
> > compare one runlog to another. Sometimes I want to average the output of
> > several runlogs together. I currently have a macro made up in Excel that
> > analyzes the files, but it really is getting harder to manage all the
> > excel
> > files floating around.
> >
> > So is it worth dumping all the excel output from my macro into a database
> > and comparing them that way?
> >
> > Thanks,
> > Matt
>
>
> .
>
From: Stop$teve on 25 May 2010 18:30
By the way, you are advertising again... you are very familiar with that also!!


--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!)

Arno R



"Steve" <notmyemail(a)address.com> schreef in bericht news:OnS8yIE$KHA.5168(a)TK2MSFTNGP05.phx.gbl...
> Hi Matt,
>
> Excel is good when you have a small number of scenarios to analyze. A database is approproate when the number of scenarios is
> large. Obviously, the number of scenarios is beyond what Excel can analyze efficiently for you. So, Access is the appropriate tool
> for you. I provide help with Access, Excel and Word applications for a small fee. Let me put together a database for you that you
> can use to analyze your reactor data. I would import your existing Excel data into the new database. My fee would be very
> reasonable. The advantage to you would be you would get to see how an Access application is put together, you would get a more
> efficient system for analyzing your reactor data and at that point if you wanted to add more functionality you could learn Access
> and add the new functionality yourself.
>
> By the way, I was previously an engineer in a large refinery so am familiar with reactor data.
>
> Steve
> santus(a)penn.com
>
>
> "Matt S" <MattS(a)discussions.microsoft.com> wrote in message news:F56A699E-574C-44AA-BFDA-BB8298985596(a)microsoft.com...
>> Hello everyone,
>>
>> I've been wondering this question for a few weeks now. My situation is that
>> I generate many "runlogs" from my reactor that have various outputs, such as
>> temperatures, sensor data, etc. versus time. Very frequently, I want to
>> compare one runlog to another. Sometimes I want to average the output of
>> several runlogs together. I currently have a macro made up in Excel that
>> analyzes the files, but it really is getting harder to manage all the excel
>> files floating around.
>>
>> So is it worth dumping all the excel output from my macro into a database
>> and comparing them that way?
>>
>> Thanks,
>> Matt
>
>


 |  Next  |  Last
Pages: 1 2
Prev: Query joining two tables with different dates
Next: totals do not display unless user clicks on text box