Help with QA

[Martin555 21]

H, Can somebody to help me?

 

I want to create QA for obtaining consumption from DAIKIN air conditioning. I can read the data, but I can't organize them into a table and get data -  Total consumption for this year and last year and for individual months.

 

response is data from DAIKIN - consumption for each month for this and last year for heating and cooling. 

How I can calculate the total consumption for this year and the consumption for the last year and the consumption for each month this year?

 

response from daikin is string:

 "ret=OK,curr_year_heat=0/0/0/0/2/0/0/0/0/0/0/0,prev_year_heat=0/0/6/21/0/7/0/0/0/0/0/0,curr_year_cool=37/34/38/38/59/57/0/0/0/0/0/0,prev_year_cool=37/34/31/14/37/61/105/117/37/37/36/36"

Individual numbers in the string represent consumption values for a month

I create this but I can't sort it and count it at the end. Somebody to help me with that.

 

function QuickApp:org()

response =  "ret=OK,curr_year_heat=0/0/0/0/2/0/0/0/0/0/0/0,prev_year_heat=0/0/6/21/0/7/0/0/0/0/0/0,curr_year_cool=37/34/38/38/59/57/0/0/0/0/0/0,prev_year_cool=37/34/31/14/37/61/105/117/37/37/36/36"

print(response)

self:organize_answer(response)

end

 

function QuickApp:organize_answer(answer)

    local Table = {}

             for v in answer:gmatch('([^,]+)') do

                table.insert(Table, v)

               print(Table,v)

               self:sum(v)

              end

end

 

 function QuickApp:sum(line)

  local total = 0

  local myTable = {}

  for str in line:gmatch("/(%d+)" ) do 

  table.insert(myTable, str)

   total = total + tonumber(str)

  end

   print(total)

  end

 

This is result for LUA: Sum of  Number 2 and 226 is This Year consuption so 2+226 , and sum of Number 34 and 545 is last Year Consuption. 

 

Please login or register to see this attachment.

 

[jgab 2,164]

Please login or register to see this code.

 

[Martin555 21]

13 hours ago, jgab said:

Please login or register to see this code.

 

Thanks