How to calculate data with price rate for water consumption.

I am looking for a code for matlab analysis of my data, I want to calculate water bill for every 100 litre=1USD, for 1 month. So that the user can get total water consumption bill at the end of the month. Please help.

[KSSV]

What data you have?

[Aman Kumar]

The data is total water consumption, using water flow sensor. The flow sensor will update how much water is being used in a day. So i want to create a billing system for a month.

Eg. 400 litre water is used in a month i.e total water consumption. Where 100 litre cost 1usd therefore 400 litre will be costing 4usd to the user.

https://thingspeak.com/channels/1035265

above is my channel's link. I need help, regarding this.

[David Stacer]

The thingSpeakRead call is what you would used in the matlab script to read the data from a channle. It lookls like your logging every 20 seconds. That is quite frequent (about 4000+ datapoint per day?). The thingSpeakRead function is limited to 8000 data points per read.

My approach to this would be a daily matlab program that reads yesterdays data, compute/sum up and writes a single summary record to another channel.

I have a system like this on my Reverson Osmosis water filter. A esp32 that counts pulses from two water flow meters. Uploads the counters every 5 minutes. Then used a timecontrol to run a matlab program at 2 am that looks at yesterdays raw data.

Little code to get you going:

% this gives you 00:00 of current formatted for correct time zone. data is stored with UTC but I wany my 12AM to 12PM day.
EndDate = datetime('today','TimeZone','America/New_York','Format','yyyy-MM-dd''T''HH:mmZZZ')      % use your TimeZone What time is it "right now" (local) when running this

%tinterval - calculated desired time interval
StartDate = EndDate - days(1)     

%this will read yesterdays data for one of the flow meters. 
[pulses, time] = thingSpeakRead(readChannelID,'Fields',RO_IN,'DateRange',[StartDate,EndDate], 'ReadKey', readAPIKey);
% Calculate the OZ from input pulses per day
sumPulse = sum(pulses);
sumPulse
%the next lines take the number of pulses most water flow sensors actually put out and converts to
% the volume type you want. You need to change this lines for your own sensors..
Ounces_In = (sumPulse / 3.31) / 29.574;    % 3.31 is ml per pulse.  29.574 oz per ml
Ounces_In = round(Ounces_In,2)
Gallons_In = round(Ounces_In / 128,2)

%now write out to a different channel. 
dataTable = timetable(StartDate, Ounces_In, Ounces_Out, Gallons_In, Gallons_Out, Total_Out)
%display(dataTable)
response = thingSpeakWrite(writeChannelID, dataTable, 'WriteKey',writeAPIKey);
% display(response)

My code sample is not complete. I left out setting all of the read/write keys, field number etc. I included the stuff that I thought was critical and were I spent alot of time figuring out how to do it.

[Aman Kumar]

Thank you so much, but i did come up with something, it's working the way i wanted there are some issues, I want to send the output as e-mail notification to the user, so how can i do that on thingspeak. Please help.

% Enter your MATLAB Code below
% Read Output Water Quantity over the past month from a ThingSpeak channel and write

% the average to another ThingSpeak channel.

% Channel 1035265 contains data from the MathWorks water supply station, located

% in Natick, Massachusetts. The data is collected once every day. Field

% 3 contains output liquid quantity data.

% Channel ID to read data from

readChannelID = 1035265;

% Output Liquid Quantity Field ID

outputliquidqantityFieldID = 3;

% Channel Read API Key

% If your channel is private, then enter the read API Key between the '' below:

readAPIKey = '';

% Get Output Liquid Quantity data for the last 30 days from the MathWorks water supply

% station channel. Learn more about the THINGSPEAKREAD function by going to

% the Documentation tab on the right side pane of this page.

meter_reading = thingSpeakRead(readChannelID,'Fields', outputliquidqantityFieldID,'NumDays',30,'ReadKey',readAPIKey);

% Calculate the Cost
Billing_cost = 5* (meter_reading/1000);

display(Billing_cost,'Total Billing Cost (INR)');

[David Stacer]

Link to a post with e-mail idea

[Aman Kumar]

Thanks it worked, but i didn't got the requided notification message. I needed the data of total water used and bill amount. Here is the code, please check if i did something wrong.

% Enter your MATLAB Code below
% Read Output Water Quantity over the past month from a ThingSpeak channel and write

% the average to another ThingSpeak channel.

% Channel 1035265 contains data from the MathWorks water supply station, located

% in Natick, Massachusetts. The data is collected once every day. Field

% 3 contains output liquid quantity data.

% Channel ID to read data from

readChannelID = 1035265;

% Output Liquid Quantity Field ID

outputliquidqantityFieldID = 3;

% Channel Read API Key

% If your channel is private, then enter the read API Key between the '' below:

readAPIKey = '';

% Get Output Liquid Quantity data for the last 30 days from the MathWorks water supply

% station channel. Learn more about the THINGSPEAKREAD function by going to

% the Documentation tab on the right side pane of this page.

meter_reading = thingSpeakRead(readChannelID,'Fields', outputliquidqantityFieldID,'NumDays',1,'ReadKey',readAPIKey);

% Calculate the Cost
Billing_cost = 5* (meter_reading/1000);

display(Billing_cost,'Total Billing Cost (INR)');

% Start by setting the channel ID and Alert key. All alert key start with TAK.

data = thingSpeakRead(1035265,"NumDays", 1);
Water = sum(data(:, 2));
apiKey = 'TAK1S83KIQN0BBLNS';
alertURL = "https://api.thingspeak.com/alerts/send";
options = weboptions("HeaderFields", ["ThingSpeak-Alerts-API-Key", apiKey ]);
alertBody = sprintf("The Water consumption bill is", 5* (meter_reading/1000));
alertSubject = sprintf(" Water consumption exceeded 100 kl!");
if Water >= 100
    webwrite(alertURL, "body", alertBody, "subject", alertSubject, options);
end 

[Aman Kumar]

I need the message as (The water consumption bill is, 5usd" for 1200kl or any amount value that the user consumed. Please Help

Answer 1

[Christopher Stapels]

This sounds like a very interesting project. I wonder what sensor you are using to track the water consumption.

It sounds like you need help with the sprintf function. This line seems to be missing a format specifier.

alertBody = sprintf("The Water consumption bill is", 5* (meter_reading/1000));

Have a look at the documentation for sprintf.