next topic »

[on:]

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.

[Reply #1 on:]

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

[Reply #2 on:]

Meguno link

[Reply #3 on:]

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.

[Reply #4 on:]

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

[Reply #5 on:]

Meguno link can display a graph