HomeRoast Digest


Topic: data logging to Excel (36 msgs / 1857 lines)
1) From: homeroast
This is a multi-part message in MIME format.
------_=_NextPart_001_01C8599C.6A271854
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I'm roasting with an iR2 and manually logging temps every 30 sec from
the readings of the thermocouple (the one the SM sells).  I really want
to see this data as graphs to compare different profiles but I haven't
had time to go back and transfer all the numbers. Perhaps one of these
days I'll just set a couple of hours and enlist my son to help me, but
for the future;  Does anyone have a good method of datalogging their
roast profiles directly into Excel?   Does anyone have a good home grown
excel program for graphing roast data?  Any help greatly appreciated! 
------_=_NextPart_001_01C8599C.6A271854
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!--
 /* Font Definitions */
 @font-face
	{font-family:"MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
	{font-family:"\@MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->

I’m roasting with an iR2 and manually logging = temps every 30 sec from the readings of the thermocouple (the one the SM = sells).  I really want to see this data as graphs to compare different profiles but I = haven’t had time to go back and transfer all the numbers. Perhaps one of these = days I’ll just set a couple of hours and enlist my son to help me, but for the = future;  Does anyone have a good method of datalogging their roast profiles directly = into Excel?   Does anyone have a good home grown excel program for = graphing roast data?  Any help greatly appreciated!

------_=_NextPart_001_01C8599C.6A271854--

2) From: homeroast
------=_Part_3349_8791693.1200660759921
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi Carlos,
<Snip>
interface one could use to suck the data out of it. I may be wrong, but it's
hard to really know from just looking at that picture. That said, I don't
think that this would be too hard to do. I know that there are Digital
Multimeters that will support k-type thermocouples which have RS-232
interfaces. That would give one a way to get the data to the PC. Then it's
just a matter of finding or writing some code to put the data into a comma
delimited form. The you just import it into Excel and draw pretty pictures.
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then
write some code.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/18/08, Mejia, Carlos  wrote:
<Snip>
------=_Part_3349_8791693.1200660759921
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi Carlos,
 
From what I see on the SM page, that device doesn't have any sort of interface one could use to suck the data out of it. I may be wrong, but it's hard to really know from just looking at that picture. That said, I don't think that this would be too hard to do. I know that there are Digital Multimeters that will support k-type thermocouples which have RS-232 interfaces. That would give one a way to get the data to the PC. Then it's just a matter of finding or writing some code to put the data into a comma delimited form. The you just import it into Excel and draw pretty pictures. 
 
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
 
On 1/18/08, Mejia, Carlos <carlos.mejia> wrote:

I'm roasting with an iR2 and manually logging temps every 30 sec from the readings of the thermocouple (the one the SM sells).  I really want to see this data as graphs to compare different profiles but I haven't had time to go back and transfer all the numbers. Perhaps one of these days I'll just set a couple of hours and enlist my son to help me, but for the future;  Does anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated!

------=_Part_3349_8791693.1200660759921--

3) From: homeroast
------=_Part_861_9551066.1200662894246
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hey Jeff - that sounds awesome!  Let us know if you move forward with this
(Inquiring minds want to know)
So - what is Iowa's Most exciting City?
And - we need an Ethanol Country Coffee Gathering - Dave Kvindlog is game
too,a nd I know of several others...
Best regards (best as can be at 4 degrees Fahrenheit)
Brett
On 1/18/08, Jeff Cozad  wrote:
<Snip>
-- 
Cheers,
Bretthttp://homeroast.freeservers.com------=_Part_861_9551066.1200662894246
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hey Jeff - that sounds awesome!  Let us know if you move forward with this (Inquiring minds want to know)
 
So - what is Iowa's Most exciting City?
And - we need an Ethanol Country Coffee Gathering - Dave Kvindlog is game too,a nd I know of several others...
 
Best regards (best as can be at 4 degrees Fahrenheit)
Brett
 
On 1/18/08, Jeff Cozad <smlist> wrote:
Hi Carlos,
 
From what I see on the SM page, that device doesn't have any sort of interface one could use to suck the data out of it. I may be wrong, but it's hard to really know from just looking at that picture. That said, I don't think that this would be too hard to do. I know that there are Digital Multimeters that will support k-type thermocouples which have RS-232 interfaces. That would give one a way to get the data to the PC. Then it's just a matter of finding or writing some code to put the data into a comma delimited form. The you just import it into Excel and draw pretty pictures. 
 
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
 
On 1/18/08, Mejia, Carlos <carlos.mejia> wrote: 

I'm roasting with an iR2 and manually logging temps every 30 sec from the readings of the thermocouple (the one the SM sells).  I really want to see this data as graphs to compare different profiles but I haven't had time to go back and transfer all the numbers. Perhaps one of these days I'll just set a couple of hours and enlist my son to help me, but for the future;  Does anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated!


-- Cheers, Brett http://homeroast.freeservers.com ------=_Part_861_9551066.1200662894246--

4) From: homeroast
------=_Part_3474_23270230.1200664556155
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Brett,
Will do. I write code for a living, so that part is the easy part (for me).
I just need to find a multi-meter with the interface. I've seen a few of
them for around $50. And I have a number of old PC's to choose from.
I'd be up for an Iowa home roaster meeting. We'd just need to figure out
where and when.
Bettendorf used to have a slogan proclaiming it to be "Iowa's Most Exciting
City". (I have a picture somewhere of me leaning up against that sign. The
picture was framed such that it had the barn/out building that was falling
into itself in the background.) They have since changed the slogan several
times, so one can conclude that some other city in Iowa must be more
exciting.
4F, eh? It was a balmy 9F here this morning. The bike ride into the office
was invigorating.
 Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/18/08, Brett Mason  wrote:
<Snip>
------=_Part_3474_23270230.1200664556155
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Brett,
 
Will do. I write code for a living, so that part is the easy part (for me). I just need to find a multi-meter with the interface. I've seen a few of them for around $50. And I have a number of old PC's to choose from.
 
I'd be up for an Iowa home roaster meeting. We'd just need to figure out where and when.
 
Bettendorf used to have a slogan proclaiming it to be "Iowa's Most Exciting City". (I have a picture somewhere of me leaning up against that sign. The picture was framed such that it had the barn/out building that was falling into itself in the background.) They have since changed the slogan several times, so one can conclude that some other city in Iowa must be more exciting.
4F, eh? It was a balmy 9F here this morning. The bike ride into the office was invigorating.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
On 1/18/08, Brett Mason <homeroast> wrote:
Hey Jeff - that sounds awesome!  Let us know if you move forward with this (Inquiring minds want to know)
 
So - what is Iowa's Most exciting City?
And - we need an Ethanol Country Coffee Gathering - Dave Kvindlog is game too,a nd I know of several others...
 
Best regards (best as can be at 4 degrees Fahrenheit)
Brett
 
On 1/18/08, Jeff Cozad <smlist
> wrote: 
Hi Carlos,
 
From what I see on the SM page, that device doesn't have any sort of interface one could use to suck the data out of it. I may be wrong, but it's hard to really know from just looking at that picture. That said, I don't think that this would be too hard to do. I know that there are Digital Multimeters that will support k-type thermocouples which have RS-232 interfaces. That would give one a way to get the data to the PC. Then it's just a matter of finding or writing some code to put the data into a comma delimited form. The you just import it into Excel and draw pretty pictures. 
 
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
 
On 1/18/08, Mejia, Carlos <carlos.mejia
> wrote: 

I'm roasting with an iR2 and manually logging temps every 30 sec from the readings of the thermocouple (the one the SM sells).  I really want to see this data as graphs to compare different profiles but I haven't had time to go back and transfer all the numbers. Perhaps one of these days I'll just set a couple of hours and enlist my son to help me, but for the future;  Does anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated!


-- Cheers, Brett http://homeroast.freeservers.com ------=_Part_3474_23270230.1200664556155--

5) From: homeroast
Hi Jeff,
<Snip>
I'm very new to this list and I don't yet have my roasting equipment,
but let me know if you have any problems with this step.  I'm a software
developer by profession, so I might be able to help in this area.
The project sounds interesting, and maybe something that could be
expanded to do graphing on it's own and even share roast profiles over
the Internet etc..
- Dave
On Fri, 2008-01-18 at 06:52 -0600, Jeff Cozad wrote:
<Snip>

6) From: homeroast
This is a multi-part message in MIME format.
------_=_NextPart_001_01C859FC.C47FDD36
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hey thanks for the quick reply!  I'll show my ignorance here by saying I
didn't realize that multimeters could measure temperature.  I have no
idea how one would choose the right type of instrument and set up
something like this.  I currently have the digital thermometer that SM
sells set up with the business end of the probe more or less permanently
positioned such that it's buried in the bean mass when roasting.  Are
there multimeters that accept this type of probe for the data in and
which also have a way to connect to a laptop (preferably USB)?   I think
others on this list might be interested to know how to put this together
if anyone can offer guidance.  Thanks!   ~carlos
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Jeff Cozad
Sent: Friday, January 18, 2008 4:53 AM
To: homeroast
Subject: Re: +data logging to Excel
 
Hi Carlos,
 
<Snip>
interface one could use to suck the data out of it. I may be wrong, but
it's hard to really know from just looking at that picture. That said, I
don't think that this would be too hard to do. I know that there are
Digital Multimeters that will support k-type thermocouples which have
RS-232 interfaces. That would give one a way to get the data to the PC.
Then it's just a matter of finding or writing some code to put the data
into a comma delimited form. The you just import it into Excel and draw
pretty pictures. 
 
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and
then write some code.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
 
On 1/18/08, Mejia, Carlos  wrote: 
I'm roasting with an iR2 and manually logging temps every 30 sec from
the readings of the thermocouple (the one the SM sells).  I really want
to see this data as graphs to compare different profiles but I haven't
had time to go back and transfer all the numbers. Perhaps one of these
days I'll just set a couple of hours and enlist my son to help me, but
for the future;  Does anyone have a good method of datalogging their
roast profiles directly into Excel?   Does anyone have a good home grown
excel program for graphing roast data?  Any help greatly appreciated! 
------_=_NextPart_001_01C859FC.C47FDD36
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#default#ieooui) }
<!--
 /* Font Definitions */
 @font-face
	{font-family:"MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"\@MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->

Hey thanks for the quick reply! =  I’ll show my ignorance here by saying I didn’t realize that multimeters = could measure temperature.  I have no idea how one would choose the right type of instrument and set up something like this.  I currently have the = digital thermometer that SM sells set up with the business end of the probe more = or less permanently positioned such that it’s buried in the bean mass = when roasting.  Are there multimeters that accept this type of probe for = the data in and which also have a way to connect to a laptop (preferably = USB)?   I think others on this list might be interested to know how to put = this together if anyone can offer guidance.  Thanks!   = ~carlos

 

From: homeroast-admin [mailto:homeroast-admin] On Behalf Of Jeff Cozad Sent: Friday, January 18, = 2008 4:53 AM To: homeroast Subject: Re: +data = logging to Excel

 

Hi Carlos,

 

From what I see on the SM page, that device doesn't have any = sort of interface one could use to suck the data out of it. I may be wrong, but = it's hard to really know from just looking at that picture. That said, I = don't think that this would be too hard to do. I know that there are Digital = Multimeters that will support k-type thermocouples which have RS-232 = interfaces. That would give one a way to get the data to the PC. Then it's just a matter = of finding or writing some code to put the data into a comma delimited = form. The you just import it into Excel and draw pretty pictures. =

 

Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.

 

Jeff C

Bettendorf IA - Formerly Iowa's = Most exciting City

 

 

On 1/18/08, Mejia, Carlos <carlos.mejia> wrote:

I'm roasting with an iR2 and manually logging temps every 30 sec from the = readings of the thermocouple (the one the SM sells).  I really want to see = this data as graphs to compare different profiles but I haven't had time to = go back and transfer all the numbers. Perhaps one of these days I'll just set a = couple of hours and enlist my son to help me, but for the future;  Does = anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated! =

------_=_NextPart_001_01C859FC.C47FDD36--

7) From: homeroast
Radio shack has them  and there not cheap about $89.00 they come with a temp
probe.  Would work perfect after all a thermocouple is nothing more than a
part that changes heat into electrical power more heat the more power they
make so a multimeter is perfect to measure that power

8) From: homeroast
------=_Part_4316_25611290.1200681354409
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Carlos,
I have found a number of things Googling around. I'll attempt to pull my
findings together and post them. There are a couple of other solutions that
would work besides using a DMM. It is all going to boil down to how much
functionality vs hassle vs dollars and where one falls in that spectrum.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/18/08, Mejia, Carlos  wrote:
<Snip>
------=_Part_4316_25611290.1200681354409
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Carlos,
 
I have found a number of things Googling around. I'll attempt to pull my findings together and post them. There are a couple of other solutions that would work besides using a DMM. It is all going to boil down to how much functionality vs hassle vs dollars and where one falls in that spectrum.
 

Jeff C

Bettendorf IA - Formerly Iowa's Most exciting City

On 1/18/08, Mejia, Carlos <carlos.mejia> wrote:

Hey thanks for the quick reply!  I'll show my ignorance here by saying I didn't realize that multimeters could measure temperature.  I have no idea how one would choose the right type of instrument and set up something like this.  I currently have the digital thermometer that SM sells set up with the business end of the probe more or less permanently positioned such that it's buried in the bean mass when roasting.  Are there multimeters that accept this type of probe for the data in and which also have a way to connect to a laptop (preferably USB)?   I think others on this list might be interested to know how to put this together if anyone can offer guidance.  Thanks!   ~carlos

 

From: homeroast-admin [mailto:homeroast-admin] On Behalf Of Jeff Cozad Sent: Friday, January 18, 2008 4:53 AM To: homeroast Subject: Re: +data logging to Excel

 

Hi Carlos,

 

From what I see on the SM page, that device doesn't have any sort of interface one could use to suck the data out of it. I may be wrong, but it's hard to really know from just looking at that picture. That said, I don't think that this would be too hard to do. I know that there are Digital Multimeters that will support k-type thermocouples which have RS-232 interfaces. That would give one a way to get the data to the PC. Then it's just a matter of finding or writing some code to put the data into a comma delimited form. The you just import it into Excel and draw pretty pictures.

 

Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.

 

Jeff C

Bettendorf IA - Formerly Iowa's Most exciting City

 

 

On 1/18/08, Mejia, Carlos < carlos.mejia> wrote:

I'm roasting with an iR2 and manually logging temps every 30 sec from the readings of the thermocouple (the one the SM sells).  I really want to see this data as graphs to compare different profiles but I haven't had time to go back and transfer all the numbers. Perhaps one of these days I'll just set a couple of hours and enlist my son to help me, but for the future;  Does anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated!

------=_Part_4316_25611290.1200681354409--

9) From: homeroast
This is a multi-part message in MIME format.
------_=_NextPart_001_01C85A1E.A2A868A0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I look forward to hear what you've found.  Hopefully the solution won't
be too far into the $$ end of the spectrum.    On the second part of
this quest does anyone have an excel file which is set up for graphing?
Even without the 'automatic' data logging, I would still like to
manually input some of my roast profiles.  I could probably figure out
how to do this in Excel but it would take me a while and probably not be
as nice as possible by someone who really knows how to drive Excel.
 
~carlos
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Jeff Cozad
Sent: Friday, January 18, 2008 10:36 AM
To: homeroast
Subject: Re: +data logging to Excel
 
Carlos,
 
I have found a number of things Googling around. I'll attempt to pull my
findings together and post them. There are a couple of other solutions
that would work besides using a DMM. It is all going to boil down to how
much functionality vs hassle vs dollars and where one falls in that
spectrum. 
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
------_=_NextPart_001_01C85A1E.A2A868A0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#default#ieooui) }
<!--
 /* Font Definitions */
 @font-face
	{font-family:"MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"\@MS Mincho";
	panose-1:2 2 6 9 4 2 5 8 3 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle20
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->

I look forward to hear what = you’ve found.  Hopefully the solution won’t be too far into the $$ = end of the spectrum.    On the second part of this quest does anyone = have an excel file which is set up for graphing?  Even without the = ‘automatic’ data logging, I would still like to manually input some of my roast profiles.  I = could probably figure out how to do this in Excel but it would take me a while = and probably not be as nice as possible by someone who really knows how to = drive Excel.

 

~carlos

=

 

From: = homeroast-admin [mailto:homeroast-admin] On Behalf Of Jeff Cozad Sent: Friday, January 18, = 2008 10:36 AM To: homeroast Subject: Re: +data = logging to Excel

 

Carlos,

 

I have found a number of things Googling around. I'll attempt to = pull my findings together and post them. There are a couple of other = solutions that would work besides using a DMM. It is all going to boil down to how much functionality vs hassle vs dollars and where one falls in that spectrum. =

 

Jeff C

Bettendorf = IA - Formerly Iowa's Most exciting = City

------_=_NextPart_001_01C85A1E.A2A868A0--

10) From: homeroast
------=_Part_6583_26138284.1200699317318
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Here's what I have works great!http://www.jsits.com/tnika/Sper/s800009.htmOn Jan 18, 2008 2:08 PM, Mejia, Carlos  wrote:
<Snip>
------=_Part_6583_26138284.1200699317318
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Here's what I have works great!
 
http://www.jsits.com/tnika/Sper/s800009.htmOn Jan 18, 2008 2:08 PM, Mejia, Carlos <carlos.mejia> wrote:

I look forward to hear what you've found.  Hopefully the solution won't be too far into the $$ end of the spectrum.    On the second part of this quest does anyone have an excel file which is set up for graphing?  Even without the 'automatic' data logging, I would still like to manually input some of my roast profiles.  I could probably figure out how to do this in Excel but it would take me a while and probably not be as nice as possible by someone who really knows how to drive Excel.

 

~carlos

 

From: homeroast-admin [mailto:homeroast-admin] On Behalf Of Jeff Cozad Sent: Friday, January 18, 2008 10:36 AM To: homeroast Subject: Re: +data logging to Excel

 

Carlos,

 

I have found a number of things Googling around. I'll attempt to pull my findings together and post them. There are a couple of other solutions that would work besides using a DMM. It is all going to boil down to how much functionality vs hassle vs dollars and where one falls in that spectrum.

 

Jeff C

Bettendorf IA - Formerly Iowa's Most exciting City

------=_Part_6583_26138284.1200699317318--

11) From: homeroast
If there's a show of a few interested hands I might set up some import
function to suck in the list of automated readings into my Access Roasting
Database roasting session. Then you could use the graphing reports already
in the application. We'd probably need a column for the temp and another for
the corresponding time, plus an optional comment field, and maybe an option
for just a column of temps, with a start time and the interval between tmp
readings, i.e. started 2 mins into the roast, with a reading every 30 secs.
DJ
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Mejia, Carlos
Sent: Friday, January 18, 2008 5:08 PM
To: homeroast
Subject: RE: +data logging to Excel
I look forward to hear what you've found.  Hopefully the solution won't be
too far into the $$ end of the spectrum.    On the second part of this quest
does anyone have an excel file which is set up for graphing?  Even without
the 'automatic' data logging, I would still like to manually input some of
my roast profiles.  I could probably figure out how to do this in Excel but
it would take me a while and probably not be as nice as possible by someone
who really knows how to drive Excel.
~carlos
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Jeff Cozad
Sent: Friday, January 18, 2008 10:36 AM
To: homeroast
Subject: Re: +data logging to Excel
Carlos,
I have found a number of things Googling around. I'll attempt to pull my
findings together and post them. There are a couple of other solutions that
would work besides using a DMM. It is all going to boil down to how much
functionality vs hassle vs dollars and where one falls in that spectrum. 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City

12) From: homeroast
------=_Part_8198_7910586.1200721900542
Content-Type: text/plain; charsetF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Not everyone uses Microsoft. Might be preferable to make input for Open
Office.  Then Windows, Mac and Linux users could all make use of it.
------=_Part_8198_7910586.1200721900542
Content-Type: text/html; charsetF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Not everyone uses Microsoft. Might be preferable to make input for Open Office.  Then Windows, Mac and Linux users could all make use of it.
------=_Part_8198_7910586.1200721900542--

13) From: homeroast
likewise not all use Open Office. Can't Open Office use excel files?
dave "on a mac"
On Jan 18, 2008, at 9:51 PM, Paul Helbert wrote:
<Snip>

14) From: homeroast
But Open Office is free, so anyone could have the spread sheet program 
at no additional cost. My husband (AKA the IT Accountant guy) says that 
complex Excel spread sheets, with complex macros, don't always run in OO.
vicki
Dave Ehrenkranz wrote:
<Snip>

15) From: homeroast
I think I read the other day that open office was coming out for macs  
but wasn't out yet. But I am not sure.
dave
On Jan 19, 2008, at 3:43 AM, Vicki Smith wrote:
<Snip>

16) From: homeroast
And even if you do use MS Excel there is a version compatibility 
question between the recent versions.
Paul Helbert wrote:
<Snip>

17) From: homeroast
Open office is open source, free software.  MS Excel is not.  If it is a 
basic Excel file then Oo will be able to use it but some of the eye 
candy, whiz-bang Excel features are not implementer in Oo.
Dave Ehrenkranz wrote:
<Snip>

18) From: homeroast
It's been out for a long time, but look for something called NeoOffice. 
It's based on Open Office, but it's a lot better!
Sheila - also on a Mac, sipping India Mysore!
Dave Ehrenkranz wrote:
<Snip>

19) From: homeroast
------=_Part_8803_30745990.1200754781153
Content-Type: text/plain; charsetF-8
Content-Transfer-Encoding: base64
Content-Disposition: inline
UG9pbnQgaXMgdGhhdCBPcGVuIE9mZmljZSB3b3JrcyBmb3IgYWxsIG9mIHVzIChmcmVlIGRvd25s
b2FkKSB3aGlsZSBFeGNlbApvbmx5IHdvcmtzIGZvciB0aG9zZSB3aG8gYm91Z2h0IGl0LgoKRW5q
b3lpbmcgdmFjdXVtIGJyZXdlZCBGQyAgR3VhdGUuIFNhbiBKb3NlIE9jYcOxYSwgZnJvbSBTTSwg
dGhpcyBtb3JuaW5nLgo=
------=_Part_8803_30745990.1200754781153
Content-Type: text/html; charsetF-8
Content-Transfer-Encoding: base64
Content-Disposition: inline
PGJyPlBvaW50IGlzIHRoYXQgT3BlbiBPZmZpY2Ugd29ya3MgZm9yIGFsbCBvZiB1cyAoZnJlZSBk
b3dubG9hZCkgd2hpbGUgRXhjZWwgb25seSB3b3JrcyBmb3IgdGhvc2Ugd2hvIGJvdWdodCBpdC48
YnI+PGJyPjxtZXRhIGh0dHAtZXF1aXY9IkNPTlRFTlQtVFlQRSIgY29udGVudD0idGV4dC9odG1s
OyBjaGFyc2V0PXV0Zi04Ij48dGl0bGU+PC90aXRsZT48bWV0YSBuYW1lPSJHRU5FUkFUT1IiIGNv
bnRlbnQ9Ik9wZW5PZmZpY2Uub3JnIDIuMiAgKExpbnV4KSI+CjxtZXRhIG5hbWU9IkFVVEhPUiIg
Y29udGVudD0iUGF1bCI+PG1ldGEgbmFtZT0iQ1JFQVRFRCIgY29udGVudD0iMjAwODAxMTQ7OTIx
MDQwMCI+PG1ldGEgbmFtZT0iQ0hBTkdFREJZIiBjb250ZW50PSJQYXVsIj48bWV0YSBuYW1lPSJD
SEFOR0VEIiBjb250ZW50PSIyMDA4MDExNDsyMzA2MzkwMCI+RW5qb3lpbmcgPGZvbnQgc3R5bGU9
ImZvbnQtc2l6ZTogMTZwdDsiIHNpemU9IjQiPjxmb250IGZhY2U9IlRpbWVzIE5ldyBSb21hbiwg
c2VyaWYiPgo8Zm9udCBzaXplPSIzIj48c3BhbiBzdHlsZT0iIj48c3BhbiBzdHlsZT0iYmFja2dy
b3VuZDogdHJhbnNwYXJlbnQgbm9uZSByZXBlYXQgc2Nyb2xsIDAlIDUwJTsgLW1vei1iYWNrZ3Jv
dW5kLWNsaXA6IC1tb3otaW5pdGlhbDsgLW1vei1iYWNrZ3JvdW5kLW9yaWdpbjogLW1vei1pbml0
aWFsOyAtbW96LWJhY2tncm91bmQtaW5saW5lLXBvbGljeTogLW1vei1pbml0aWFsOyI+PC9zcGFu
Pgo8L3NwYW4+PC9mb250PjwvZm9udD48L2ZvbnQ+PGZvbnQgc3R5bGU9ImZvbnQtc2l6ZTogMTZw
dDsiIHNpemU9IjQiPjxmb250IGZhY2U9IlRpbWVzIE5ldyBSb21hbiwgc2VyaWYiPjxmb250IHNp
emU9IjMiPjxzcGFuIHN0eWxlPSIiPjxzcGFuIHN0eWxlPSJiYWNrZ3JvdW5kOiB0cmFuc3BhcmVu
dCBub25lIHJlcGVhdCBzY3JvbGwgMCUgNTAlOyAtbW96LWJhY2tncm91bmQtY2xpcDogLW1vei1p
bml0aWFsOyAtbW96LWJhY2tncm91bmQtb3JpZ2luOiAtbW96LWluaXRpYWw7IC1tb3otYmFja2dy
b3VuZC1pbmxpbmUtcG9saWN5OiAtbW96LWluaXRpYWw7Ij4KdmFjdXVtIGJyZXdlZCBGQyZuYnNw
OyA8L3NwYW4+PC9zcGFuPjwvZm9udD48L2ZvbnQ+PC9mb250Pkd1YXRlLiA8Zm9udCBzaXplPSIy
Ij5TYW4gSm9zZSBPY2E8L2ZvbnQ+PGZvbnQgc3R5bGU9ImZvbnQtc2l6ZTogMTZwdDsiIHNpemU9
IjQiPjxmb250IGZhY2U9IlRpbWVzIE5ldyBSb21hbiwgc2VyaWYiPjxmb250IHNpemU9IjMiPjxz
cGFuIHN0eWxlPSIiPjxzcGFuIHN0eWxlPSJiYWNrZ3JvdW5kOiB0cmFuc3BhcmVudCBub25lIHJl
cGVhdCBzY3JvbGwgMCUgNTAlOyAtbW96LWJhY2tncm91bmQtY2xpcDogLW1vei1pbml0aWFsOyAt
bW96LWJhY2tncm91bmQtb3JpZ2luOiAtbW96LWluaXRpYWw7IC1tb3otYmFja2dyb3VuZC1pbmxp
bmUtcG9saWN5OiAtbW96LWluaXRpYWw7Ij4Kw7FhLCBmcm9tIFNNLCB0aGlzIG1vcm5pbmcuPC9z
cGFuPjwvc3Bhbj48L2ZvbnQ+PC9mb250PjwvZm9udD48Zm9udCBzaXplPSIxIj48Zm9udCBzaXpl
PSIyIj4gPC9mb250PjwvZm9udD48bWV0YSBodHRwLWVxdWl2PSJDT05URU5ULVRZUEUiIGNvbnRl
bnQ9InRleHQvaHRtbDsgY2hhcnNldD11dGYtOCI+PHRpdGxlPjwvdGl0bGU+PG1ldGEgbmFtZT0i
R0VORVJBVE9SIiBjb250ZW50PSJPcGVuT2ZmaWNlLm9yZyAyLjIgIChMaW51eCkiPgo8bWV0YSBu
YW1lPSJBVVRIT1IiIGNvbnRlbnQ9IlBhdWwiPjxtZXRhIG5hbWU9IkNSRUFURUQiIGNvbnRlbnQ9
IjIwMDgwMTE0OzkyMTA0MDAiPjxtZXRhIG5hbWU9IkNIQU5HRURCWSIgY29udGVudD0iUGF1bCI+
PG1ldGEgbmFtZT0iQ0hBTkdFRCIgY29udGVudD0iMjAwODAxMTQ7MjMwNjM5MDAiPgoKCgkKCQoJ
CgkKCQoJCgkKCTxzdHlsZSB0eXBlPSJ0ZXh0L2NzcyI+CgkmbHQ7IS0tCgkJQHBhZ2UgeyBzaXpl
OiA4LjVpbiAxMWluOyBtYXJnaW46IDAuNzlpbiB9CgkJUCB7IG1hcmdpbi1ib3R0b206IDAuMDhp
biB9CgktLSZndDsKCTwvc3R5bGU+Cgo8cCBzdHlsZT0ibWFyZ2luLWJvdHRvbTogMGluOyI+PGZv
bnQgc3R5bGU9ImZvbnQtc2l6ZTogMTZwdDsiIHNpemU9IjQiPjxmb250IGZhY2U9IlRpbWVzIE5l
dyBSb21hbiwgc2VyaWYiPjxmb250IHNpemU9IjMiPjxzcGFuIHN0eWxlPSIiPjxzcGFuIHN0eWxl
PSJiYWNrZ3JvdW5kOiB0cmFuc3BhcmVudCBub25lIHJlcGVhdCBzY3JvbGwgMCUgNTAlOyAtbW96
LWJhY2tncm91bmQtY2xpcDogLW1vei1pbml0aWFsOyAtbW96LWJhY2tncm91bmQtb3JpZ2luOiAt
bW96LWluaXRpYWw7IC1tb3otYmFja2dyb3VuZC1pbmxpbmUtcG9saWN5OiAtbW96LWluaXRpYWw7
Ij4KPGJyPjwvc3Bhbj48L3NwYW4+PC9mb250PjwvZm9udD48L2ZvbnQ+PC9wPgo8c3R5bGUgdHlw
ZT0idGV4dC9jc3MiPgoJJmx0OyEtLQoJCUBwYWdlIHsgc2l6ZTogOC41aW4gMTFpbjsgbWFyZ2lu
OiAwLjc5aW4gfQoJCVAgeyBtYXJnaW4tYm90dG9tOiAwLjA4aW4gfQoJLTwvc3R5bGU+PGJyPjxi
cj4K
------=_Part_8803_30745990.1200754781153--

20) From: homeroast
And, that is indeed true.
Paul Helbert wrote:
<Snip>

21) From: homeroast
------=_Part_10104_12327204.1200795597088
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Oh- I read "Ethanol Country Coffee Gathering" and saw "Coffee Country
Ethanol Gathering" Nuts! -ro
On Jan 18, 2008 6:28 AM, Brett Mason  wrote:
<Snip>
-- 
"When the theme hits the bass, I dance the Jig!" - -Virgil Fox at the Mighty
Wichita (ex- NYC Paramount) WurliTzer- 1976
------=_Part_10104_12327204.1200795597088
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Oh- I read "Ethanol Country Coffee Gathering" and saw "Coffee Country Ethanol Gathering" Nuts! -ro 
On Jan 18, 2008 6:28 AM, Brett Mason <
homeroast> wrote:
Hey Jeff - that sounds awesome!  Let us know if you move forward with this (Inquiring minds want to know)
 
So - what is Iowa's Most exciting City?
And - we need an Ethanol Country Coffee Gathering - Dave Kvindlog is game too,a nd I know of several others...
 
Best regards (best as can be at 4 degrees Fahrenheit)
Brett
 
On 1/18/08, Jeff Cozad <smlist> wrote:
Hi Carlos,
 
From what I see on the SM page, that device doesn't have any sort of interface one could use to suck the data out of it. I may be wrong, but it's hard to really know from just looking at that picture. That said, I don't think that this would be too hard to do. I know that there are Digital Multimeters that will support k-type thermocouples which have RS-232 interfaces. That would give one a way to get the data to the PC. Then it's just a matter of finding or writing some code to put the data into a comma delimited form. The you just import it into Excel and draw pretty pictures. 
 
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and then write some code.
 
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
 
 
On 1/18/08, Mejia, Carlos <carlos.mejia> wrote: 

I'm roasting with an iR2 and manually logging temps every 30 sec from the readings of the thermocouple (the one the SM sells).  I really want to see this data as graphs to compare different profiles but I haven't had time to go back and transfer all the numbers. Perhaps one of these days I'll just set a couple of hours and enlist my son to help me, but for the future;  Does anyone have a good method of datalogging their roast profiles directly into Excel?   Does anyone have a good home grown excel program for graphing roast data?  Any help greatly appreciated!


-- Cheers, Brett http://homeroast.freeservers.com
-- "When the theme hits the bass, I dance the Jig!" - -Virgil Fox at the Mighty Wichita (ex- NYC Paramount) WurliTzer- 1976 ------=_Part_10104_12327204.1200795597088--

22) From: homeroast
I can't find any pricing on the referenced website.  What's this baby
cost?
~carlos

23) From: homeroast
Excel uses Visual basic for Application (VBA) as its macro language.  
This is a powerful language that is quite capable of reading a 
temperature probe and plotting in real time.  I don't believe Open 
Office can use this language. As mentioned previously, Microsoft does 
make subtle changes to their VBA  implementation with different versions 
of Office so sometimes code must be tweaked a bit when Microsoft 
releases a new version.
A while ago I started a project  to use Excel to computer control my 
popper.  I got the software started  using LabJack as the IO interface.  
It could be adapted for other interfaces fairly easily. Project is 
stalled at the moment waiting  for me to finish some thermocouple 
amplifiers.  The code got to the point where I could read and plot a 
temperature graph in real time.  If anyone is interested contact me off 
list and I'll send you a copy.
Dave

24) From: homeroast
We use an Extech with dual probes, which writes out a DAT fail and 
imports easily to Excel. It's about 200 bucks.
I would like to know if there is an easy way to datalog right onto a 
laptop too.
Tom
Carlos,
I have found a number of things Googling around. I'll attempt to pull 
my findings together and post them. There are a couple of other 
solutions that would work besides using a DMM. It is all going to 
boil down to how much functionality vs hassle vs dollars and where 
one falls in that spectrum.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/18/08, Mejia, Carlos 
<carlos.mejia> wrote:
Hey thanks for the quick reply!  I'll show my ignorance here by 
saying I didn't realize that multimeters could measure temperature. 
I have no idea how one would choose the right type of instrument and 
set up something like this.  I currently have the digital thermometer 
that SM sells set up with the business end of the probe more or less 
permanently positioned such that it's buried in the bean mass when 
roasting.  Are there multimeters that accept this type of probe for 
the data in and which also have a way to connect to a laptop 
(preferably USB)?   I think others on this list might be interested 
to know how to put this together if anyone can offer guidance. 
 Thanks!   ~carlos
From:  
homeroast-admin 
[mailto:homeroast-admin] 
On Behalf Of Jeff Cozad
Sent: Friday, January 18, 2008 4:53 AM
To:  homeroast
Subject: Re: +data logging to Excel
Hi Carlos,
 From what I see on the SM page, that device doesn't have any sort of 
interface one could use to suck the data out of it. I may be wrong, 
but it's hard to really know from just looking at that picture. That 
said, I don't think that this would be too hard to do. I know that 
there are Digital Multimeters that will support k-type thermocouples 
which have RS-232 interfaces. That would give one a way to get the 
data to the PC. Then it's just a matter of finding or writing some 
code to put the data into a comma delimited form. The you just import 
it into Excel and draw pretty pictures.
Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and 
then write some code.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/18/08, Mejia, Carlos < 
carlos.mejia> wrote:
I'm roasting with an iR2 and manually logging temps every 30 sec from 
the readings of the thermocouple (the one the SM sells).  I really 
want to see this data as graphs to compare different profiles but I 
haven't had time to go back and transfer all the numbers. Perhaps one 
of these days I'll just set a couple of hours and enlist my son to 
help me, but for the future;  Does anyone have a good method of 
datalogging their roast profiles directly into Excel?   Does anyone 
have a good home grown excel program for graphing roast data?  Any 
help greatly appreciated!
--
                   "Great coffee comes from tiny roasters"
            Sweet Maria's Home Coffee Roasting  -  Tom & Maria
                      http://www.sweetmarias.com                Thompson Owen george_at_sweetmarias.com
     Sweet Maria's Coffee - 1115 21st Street, Oakland, CA 94607 - USA
             phone/fax: 888 876 5917 - tom_at_sweetmarias.com

25) From: homeroast
------=_Part_12985_5490721.1200917556484
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Tom,
There's lots of stuff out there. However, much of it is designed to run as
part of a test system hence designed to interface with software such as
LabView (a popular graphical environment/language for controlling test
instruments & writing tests -- we're talking several hundred to thousands
for the SW).
Here's a company with some inexpensive software:http://www.omega.com/ppt/pptsc.asp?ref-CP-QUADTEMP&Nav=dase01Another company's solution:http://www.iotech.com/catalog/daq/persdaq.html.I comes with their software for $649 (5 TC inputs).">http://www.omega.com/ppt/pptsc.asp?ref-CP-IFC110&Nav=dasb01but hardware is still a bit pricey. An 8 channel logger is $599:http://www.omega.com/ppt/pptsc.asp?ref-CP-QUADTEMP&Nav=dase01Another company's solution:http://www.iotech.com/catalog/daq/persdaq.html.I comes with their software for $649 (5 TC inputs).
Both of these companies have been around for a while. You might want to
browse the rest of the offerings too. Maybe a wireless connection to your PC
would be a good solution for you?
I found a homebrew non-solution:http://www.anotherurl.com/therm/logger.htm.Temperature range seems insufficient.
This is a start. There are others on the list that can provide additional
insight.
--MikeW
On Jan 18, 2008 3:29 PM, Tom & Maria - Sweet Maria's Coffee <
sweetmarias> wrote:
<Snip>
-- 
"About the time we think we can make ends meet, somebody moves the ends."
--Herbert Hoover
------=_Part_12985_5490721.1200917556484
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Tom,
There's lots of stuff out there. However, much of it is designed to run as part of a test system hence designed to interface with software such as LabView (a popular graphical environment/language for controlling test instruments & writing tests -- we're talking several hundred to thousands for the SW).
Here's a company with some inexpensive software: http://www.omega.com/ppt/pptsc.asp?ref-CP-IFC110&Nav=dasb01but hardware is still a bit pricey. An 8 channel logger is $599: 
.">http://www.iotech.com/catalog/daq/persdaq.html.I comes with their software for $649 (5 TC inputs).">http://www.omega.com/ppt/pptsc.asp?ref-CP-QUADTEMP&Nav=dase01Another company's solution: http://www.iotech.com/catalog/daq/persdaq.html.I comes with their software for $649 (5 TC inputs).
Both of these companies have been around for a while. You might want to browse the rest of the offerings too. Maybe a wireless connection to your PC would be a good solution for you?
I found a homebrew non-solution: http://www.anotherurl.com/therm/logger.htm.Temperature range seems insufficient. 
This is a start. There are others on the list that can provide additional insight.
--MikeW
On Jan 18, 2008 3:29 PM, Tom & Maria - Sweet Maria's Coffee <sweetmarias> wrote:
We use an Extech with dual probes, which writes out a DAT fail and
imports easily to Excel. It's about 200 bucks.
I would like to know if there is an easy way to datalog right onto a
laptop too.
Tom
                   "Great coffee comes from tiny roasters"
            Sweet Maria's Home Coffee Roasting  -  Tom & Maria
                       http://www.sweetmarias.com                Thompson Owen george_at_sweetmarias.com
     Sweet Maria's Coffee - 1115 21st Street, Oakland, CA 94607 - USA
             phone/fax: 888 876 5917 - tom_at_sweetmarias.com
homeroast mailing list
http://lists.sweetmarias.com/mailman/listinfo/homeroastTo change your personal list settings (digest options, vacations, unsvbscribes) go to 
">http://sweetmarias.com/maillistinfo.html#personalsettings
-- "About the time we think we can make ends meet, somebody moves the ends." --Herbert Hoover ------=_Part_12985_5490721.1200917556484--

26) From: homeroast
Tom,
The lab software can be very nice but, as Michael Wascher mentioned can 
also be expensive. Excel itself could probably read and plot data from 
your Extech data logger.
Which model is it?  The EA15 has a serial port that a computer can 
interface to.  WE would have to find out the protocol used.  The manual 
describes their included software but doesn't specify enough detail to 
write a VBA program for communication.
Dave

27) From: homeroast
------=_Part_15525_32227099.1200966028669
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Here's a datalogger from Sper Scientific:http://www.technika.com/Sper/s800008.htmWhen I purchased it, the software was included.
On Jan 21, 2008 5:08 PM, David Lang  wrote:
<Snip>
------=_Part_15525_32227099.1200966028669
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Here's a datalogger from Sper Scientific:
http://www.technika.com/Sper/s800008.htmWhen I purchased it, the software was included.
On Jan 21, 2008 5:08 PM, David Lang <davlang> wrote:
Tom,
The lab software can be very nice but, as Michael Wascher mentioned can
also be expensive. Excel itself could probably read and plot data from
your Extech data logger.
Which model is it?  The EA15 has a serial port that a computer can
interface to.  WE would have to find out the protocol used.  The manual
describes their included software but doesn't specify enough detail to
write a VBA program for communication.
Dave
homeroast mailing list
http://lists.sweetmarias.com/mailman/listinfo/homeroastTo change your personal list settings (digest options, vacations, unsvbscribes) go to 
http://sweetmarias.com/maillistinfo.html#personalsettings------=_Part_15525_32227099.1200966028669--

28) From: homeroast
This could be sweet--I just can't make myself buy it
4 channels of interface Type K to 9-pin serial port. $125
 From the website it seems like these guys could do a standalone 
datalogger with USB if you threatened to give them money.http://www.aprsworld.com/thermok/Dean
In da weeds
Tom & Maria - Sweet Maria's Coffee wrote:
<Snip>

29) From: homeroast
------=_Part_2784_18433982.1200970501117
Content-Type: text/plain; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Dean,
That certainly looks like it will do it. The schematic of the thing is there
on the web site and it appears to be using off the shelf hardware (PIC16F873A
& MAX6675). They even have instructions to suck the data out of it with
Excel. It's got an RS232 interface on it. You can buy an RS232 to USB
converter for less than $20. I am unclear how acceptable a +/-4C accuracy is
for this. I would assume that to get better is going to require more
dollars.
I'd been looking at doing some sweet talking of one of the EE bro-in-laws,
but... Now I have to figure out how I can get yet another coffee "necessity"
into the house.
Tom - The manual talks about how to use Hyper Terminal to get the data out
of this right into the machine. You may be able to do something similar.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/21/08, Dean  wrote:
<Snip>
------=_Part_2784_18433982.1200970501117
Content-Type: text/html; charsetO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Dean,
That certainly looks like it will do it. The schematic of the thing is there on the web site and it appears to be using off the shelf hardware (PIC16F873A & MAX6675)
. They even have instructions to suck the data out of it with Excel. It's got an RS232 interface on it. You can buy an RS232 to USB converter for less than $20. I am unclear how acceptable a +/-4C accuracy is for this. I would assume that to get better is going to require more dollars. 
I'd been looking at doing some sweet talking of one of the EE bro-in-laws, but... Now I have to figure out how I can get yet another coffee "necessity" into the house.
Tom - The manual talks about how to use Hyper Terminal to get the data out of this right into the machine. You may be able to do something similar.
Jeff C
Bettendorf IA - Formerly Iowa's Most exciting City
On 1/21/08, Dean <
dean_schaffran> wrote:
This could be sweet--I just can't make myself buy it
4 channels of interface Type K to 9-pin serial port. $125
 From the website it seems like these guys could do a standalone
datalogger with USB if you threatened to give them money.
http://www.aprsworld.com/thermok/Dean
In da weeds
Tom & Maria - Sweet Maria's Coffee wrote:
> We use an Extech with dual probes, which writes out a DAT fail and
> imports easily to Excel. It's about 200 bucks.
>
> I would like to know if there is an easy way to datalog right onto a
> laptop too.
>
> Tom
>
> Carlos,
>
> I have found a number of things Googling around. I'll attempt to pull
> my findings together and post them. There are a couple of other
> solutions that would work besides using a DMM. It is all going to boil
> down to how much functionality vs hassle vs dollars and where one
> falls in that spectrum.
>
>
> Jeff C
>
> Bettendorf IA - Formerly Iowa's Most exciting City
>
> On 1/18/08, Mejia, Carlos
> <<mailto:
carlos.mejia>carlos.mejia> wrote:
>
> Hey thanks for the quick reply!  I'll show my ignorance here by saying
> I didn't realize that multimeters could measure temperature. I have no
> idea how one would choose the right type of instrument and set up
> something like this.  I currently have the digital thermometer that SM
> sells set up with the business end of the probe more or less
> permanently positioned such that it's buried in the bean mass when
> roasting.  Are there multimeters that accept this type of probe for
> the data in and which also have a way to connect to a laptop
> (preferably USB)?   I think others on this list might be interested to
> know how to put this together if anyone can offer guidance. Thanks!
> ~carlos
>
>
>
>
> From: <mailto:
homeroast-admin>
> homeroast-admin
> [mailto:<mailto:
homeroast-admin>homeroast-admin]
> On Behalf Of Jeff Cozad
> Sent: Friday, January 18, 2008 4:53 AM
> To: <mailto:homeroast>
> homeroast

> Subject: Re: +data logging to Excel
>
>
>
> Hi Carlos,
>
>
>
> From what I see on the SM page, that device doesn't have any sort of
> interface one could use to suck the data out of it. I may be wrong,
> but it's hard to really know from just looking at that picture. That
> said, I don't think that this would be too hard to do. I know that
> there are Digital Multimeters that will support k-type thermocouples
> which have RS-232 interfaces. That would give one a way to get the
> data to the PC. Then it's just a matter of finding or writing some
> code to put the data into a comma delimited form. The you just import
> it into Excel and draw pretty pictures.
>
>
>
> Hmmm.... Maybe I'll have to cruise E-Bay and/or do some Googling and
> then write some code.
>
>
>
> Jeff C
>
> Bettendorf IA - Formerly Iowa's Most exciting City
>
>
>
>
>
> On 1/18/08, Mejia, Carlos <<mailto:carlos.mejia
>
> carlos.mejia> wrote:
>
> I'm roasting with an iR2 and manually logging temps every 30 sec from
> the readings of the thermocouple (the one the SM sells).  I really
> want to see this data as graphs to compare different profiles but I
> haven't had time to go back and transfer all the numbers. Perhaps one
> of these days I'll just set a couple of hours and enlist my son to
> help me, but for the future;  Does anyone have a good method of
> datalogging their roast profiles directly into Excel?   Does anyone
> have a good home grown excel program for graphing roast data?  Any
> help greatly appreciated!
>
>
homeroast mailing list
http://lists.sweetmarias.com/mailman/listinfo/homeroast
To change your personal list settings (digest options, vacations, unsvbscribes) go to http://sweetmarias.com/maillistinfo.html#personalsettings------=_Part_2784_18433982.1200970501117--

30) From: Mejia, Carlos
This is a multi-part message in MIME format.
I'm wondering if there's a problem with the URL... I can't seem to get
it to work by either clicking or cut/pasting into my browser.  Can you
check it and resend?
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Michael
Wascher
Sent: Tuesday, January 22, 2008 3:17 PM
To: homeroast
Subject: Re: +data logging to Excel
 
While poking around I found this device. I don't see the temperature
range specified anywhere. This is small enough to drop in a roaster with
the beans, then pull it out afterwards to extract the log of
temperatures.
Not a so;ution fpr tom's present issue, but interesting.http://www.saelig.com/miva/merchant.mvc?Screen=PROD&Product_Code=DLTH=SA0
17&Category_Codehttp://www.saelig.com/miva/merchant.mvc?Screen=PROD&=Pro
duct_Code=DLTHSA017&Category_Code=

31) From: Allon Stern
--Apple-Mail-11--515766028
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charsetNDOWS-1252;
	delsp=yes;
	format=flowed
On Jan 23, 2008, at 6:00 PM, Mejia, Carlos wrote:
<Snip>
to  
<Snip>
try:
--Apple-Mail-11--515766028
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charsetNDOWS-1252
On Jan 23, 2008, at 6:00 PM, Mejia, Carlos wrote:
I’m wondering if there’s a = problem with the URL… I can’t seem to get it to work by either = clicking or cut/pasting into my browser.  Can you check it and = resendhttp://www.saelig.com/miva/merchant.mvc?Screen=PROD&am=p;Product_Code=DLTHSA017> = --Apple-Mail-11--515766028--

32) From: Rich
Try this one....http://www.saelig.com/miva/merchant.mvc?ScreenOD&Product_CodeTHSA017&Category_Code=
Mejia, Carlos wrote:
<Snip>

33) From: Michael Wascher
Sorry about that, it must be a dynamic web page & it expired. Go to the mai=
n
page:http://www.saelig.com/and search for "smart button temperature logger". The search box is at the
very top.
On Jan 23, 2008 6:08 PM, Allon Stern  wrote:
<Snip>
 to
<Snip>
SA017
<Snip>
-- 
"About the time we think we can make ends meet, somebody moves the ends."
--Herbert Hoover

34) From: kevin creason
I've looked at things like these before. they don't have the range-- they
are not rated to the temps we need.
On Jan 23, 2008 5:17 PM, Michael Wascher  wrote:
<Snip>
e
<Snip>
it
<Snip>
ck it
<Snip>
LTHSA017
<Snip>
-- 
-Kevin
Admit your errors before someone else exaggerates them. - Andrew V. Mason

35) From: lesliejcarpenter
Is there something that is in the range?
---- Original Message ----
From: kevin creason 
To: homeroast
Sent: Thu, 24 Jan 2008 11:02 am
Subject: Re: +data logging to Excel
I've looked at things like these before. they don't have the range-- they ar=
e not rated to the temps we need.
On Jan 23, 2008 5:17 PM, Michael Wascher < wascher> wrote:
Sorry about that, it must be a dynamic web page & it expired. Go to the main=
 page: http://www.saelig.com/and search for "smart button temperature logger". The search box is at the v=
ery top. 
On Jan 23, 2008 6:08 PM, Allon Stern  wrote:
On Jan 23, 2008, at 6:00 PM, Mejia, Carlos wrote:
I'm wondering if there's a problem with the URL… I can't seem to get=
 it to work by either clicking or cut/pasting into my browser.  Can you=
 check it and resend? 
 
try:
-- 
"About the time we think we can make ends meet, somebody moves the ends." --=
Herbert Hoover 
-- 
-Kevin
Admit your errors before someone else exaggerates them. - Andrew V. Mason
Meet the new AOL.ca. Free radio, music, videos, news & entertainment â€=
“ with a Canadian perspective.

36) From: kevin creason
not that I've seen in the buttons type sensors.
On Jan 25, 2008 7:58 PM,  wrote:
<Snip>
et
<Snip>
u check
<Snip>
=DLTHSA017
<Snip>
-- 
-Kevin
Admit your errors before someone else exaggerates them. - Andrew V. Mason


HomeRoast Digest