Picture of Internet Graphical Interface for Arduino

This App Note describes how to implement a web temperature dashboard for Arduino Ethernet. It is intended to show you how the Memory-Map concept works in the practice and the way in which it can help you to improve your Arduino projects with some few simple modifications.

The system shown consists of an Arduino with a temperature sensor (eg. a LM134 lineal temperature sensor IC) connected to the NearBus Connector through internet to display the temperature value in a graphical way using the Google Spreadsheet Web App (as shown below).

How does it work?

As detailed in the overview section the NearBus system has two working modes, the VMCU (virtual microcontroller unit) mode and the TRNSP (transparent) mode. In this example we are going to use the TRNSP mode.

Under the TRNSP mode the NearBus system works replicating two groups of 8 registers each (Reg_A and Reg_B) in a periodic way :

Reg_A: Data sent from Microcontroller to the Cloud.
Reg_B: Data received in the Microcontroller from the Cloud.

In others words, the TRNSP mode can be understood as a RPC (Remote Procedure Call) or function call, that you make in your Arduino code to execute it in the cloud (as a spreadsheet formula or script), obtaining a result, and then using it in your Arduino code.

The most powerful feature of NearBus is the extremely easy way in which this complex process can be achieved. Including a single line in your code (a function call) you will be able to synchronize the register blocks (8+8) with the Google Cloud and then access them from a simple spreadsheet table (2 rows 8 cells).

So, under the TRNSP mode, changing a value in the spreadsheet replicates this value in the Arduino's memory (and vice versa) in a periodic way.

jaspreetedu4 months ago

hello! my problem is that every connection i made is correct and everything goes UP but still i haven't received anything to the spreadsheet. when i click on setup button nothing happens

kindly help!

Hello, I am following the instructions to configure with at Google acount. When I enter all the information nothing happens. Please see screenshot

i had the same problem. actually in my case everything goes UP but when i click on setup button then, nothing happens. the reading does not reflect back to the spreadsheet

please help!

midnightcow6 months ago


I work at WIZnet as chip designer, I colllect the good references in my blog and http://wiznetmuseum.com . Can I share your contents on my collecition?

Thank you in advance.

nearbus (author)  midnightcow6 months ago

Hi midnightcrow, yes, it is fine for us.

Thanks for your feedback

Thanks a lot for sharing your contents.

I have always interested in your service. I expect that WIZnet will co-work with your IOT cloud service because WIZnet will launch the W7500 MCU integrated CortextM0 with WIZnet TCP/IP hw core on May 2015.

If you are interested in WIZnet & W7500 IOT platform, Feel free to contact to me or WIZnet.

Thank you.

Sorry screen shot was not attached
Great project and you presented it wel