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.

Step 1: Setup a New NearBus Account

To setup a new account in the NearBus Connector, please follow the steps 1 to 5 in the Hello World example.

IMPORTANT: Remember that this example works in TRNSP mode so you should uncheck the VMCU option when configuring a new device (Step 2) in the NEW DEVICE configuration screen (VMCU is the default option).

<p>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 </p><p>kindly help!</p>
Hello, I am following the instructions to configure with at Google acount. When I enter all the information nothing happens. Please see screenshot
<p>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 </p><p>please help!</p>
<p>Hi,</p><p>I work at WIZnet as chip designer, I colllect the good references in my blog and <a href="http://wiznetmuseum.com" rel="nofollow">http://wiznetmuseum.com</a> . Can I share your contents on my collecition?</p><p>Thank you in advance.</p>
<p>Hi midnightcrow, yes, it is fine for us. </p><p>Thanks for your feedback</p>
<p>Thanks a lot for sharing your contents.</p><p>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. </p><p>If you are interested in WIZnet &amp; W7500 IOT platform, Feel free to contact to me or WIZnet. </p><p>Thank you.</p>
Sorry screen shot was not attached <br>
Great project and you presented it wel