Pages: [1]   Go Down
Author Topic: PC program for logging temperatures?  (Read 448 times)
0 Members and 1 Guest are viewing this topic.
Offline Offline
Newbie
*
Karma: 0
Posts: 34
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Hi All.

At work, we've got to manually take temp checks twice daily, on 5 fridges. It's a pain in the butt, so I got some one wire temp waterproof temp probes, and wired, and hooked it all up no problems.

I've got the serial monitor giving me fridge readouts, but I've got to record all these, and print them out (company wants proof that it's being taken).

I'm happy to leave it plugged in 24/7, but is there any PC programs that can take the data from the serial monitor and put it onto a excel document? (bonus points if it can average the readouts over a 12 hour period).

Thanks.
Logged

SE USA
Offline Offline
Faraday Member
**
Karma: 40
Posts: 3783
@ssh0le
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

http://robottini.altervista.org/arduino-and-real-time-charts-in-excel
Logged


Beijing
Offline Offline
Full Member
***
Karma: 3
Posts: 193
Skype name habib.derbyshire
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Meguno link
Logged

What is man's best friend? The breadboard!

Dee Why NSW
Offline Offline
Edison Member
*
Karma: 30
Posts: 1698
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset


I'm happy to leave it plugged in 24/7, but is there any PC programs that can take the data from the serial monitor and put it onto a excel document? (bonus points if it can average the readouts over a 12 hour period).


I use this   http://www.parallax.com/tabid/393/default.aspx
It will give you a real-time graph if you want it.

Another alternative is RealTerm, which accumulates data that may then be incorporated into Excel.

It is also simple to log to an SD card, making a new CSV file every day which can then be used in Excel.

If your company is sufficiently paranoid, you can send the data to cosm and they can check up on you whenever they like.

    https://cosm.com/feeds/83153

And any of the above can include any averaging you can think of.

You could do what I do, which is all of the above, and an LCD display too. If you do, you will probably need a Mega, if you don't already have one.


« Last Edit: January 28, 2013, 10:50:24 pm by Nick_Pyner » Logged

UK
Offline Offline
Shannon Member
****
Karma: 184
Posts: 11197
-
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

I'd suggest dumping the results into a relational database rather than a spreadsheet. It gives you much greater flexibility to manage and process the data, and you can still query the data from a spreadsheet if you want.

If you're running in Windows then the software to implement that is all freely available (SQL Server, Gobetwino).
Logged

I only provide help via the forum - please do not contact me for private consultancy.

Beijing
Offline Offline
Full Member
***
Karma: 3
Posts: 193
Skype name habib.derbyshire
View Profile
WWW
 Bigger Bigger  Smaller Smaller  Reset Reset

Meguno link can display a graph
Logged

What is man's best friend? The breadboard!

Pages: [1]   Go Up
Jump to: