12:16 pm

August 2, 2020

Hello,
I am a Civil Engineer and has very limited knowledge about IOT.
I have set up a DS18B20 temperature sensor sending data to Thingspeak via a ESP8266 MCU.
The sensor is placed inside a concrete cube, measuring its setting temperature.
The measured temperature, lets call it Ta is to be used in the following equation.
M(t) = ∑ (Ta-Td) ∆t
Where M(t) – Maturity at age t (°C-Hrs)
Ta - Average Temperature in ° C
Td - Datum Temperature in ° C and is set to 0
∆t - Time Interval
As you can see Ta is the only measured data along with time interval between 2 readings (set to 30 minutes). I wish to create a MATLAB analysis wherein the measured temperature from the first channel is used to calculate M(t).
But I dont know how to code the above formula as it requires to add the calculated M(t) once every 30 minutes and tell the updated value.
I would greatly appreciate your help.
11:50 am


Moderators
March 7, 2017

Set up the following MATLAB analysis
myTimeTable = thingSpeakRead(channelID, 'ReadKey', ''READAPIKEY", 'outputFormat','Timetable', 'numMinutes',1000);
%I presume your average means average temperature over the local time segment, so just the temperature value written.
% If we need to average over several values, that can be done as well.
timeDurations = diff(myTimeTable.Timestamps)
sumElements = timeDurations * myTimeTable.TEMPERATUREFIELDNAME; %replace TEMPERATUREFIELDNAME with your temp field
total = sum(sumElements);
Total will then be in units of scaled durations - i.e. hours and minutes times temperature. There are MATLAB functions to convert it to seconds or whatever units you like.
Then set up a timecontrol to call this code at whatever interval you like.
then you can even add a ThingSpeakWrite at the end to write the output to another channel each time the calculation runs.
FYI MATLAB answers is the preferred location for ThingSpeak support.
Most Users Ever Online: 166
Currently Online:
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
bogart, estebanmateo93, mikewrite, onlinebusiness, winzy99, Zark_zeuganModerators: cstapels: 460
Administrators: Hans: 405, lee: 457