Home Automation Domotica Forum Europe, Bwired Forum

Since a couple of months I have a new CV and given that the gas prices are increasing, I would like to have a closer look at my gas usage.
I would like to store the Toon usage data in Excel. With the export function on Toon I can get all the usage files on my PC in CSV format. After converting the the CSV to something readable I have the date and a value. The value has a maximum length of 5 digits but can also be 3 or 4 digits.
I am trying to find an easy way to convert the values in Excel. If a value is less than 5 digits I can add some trailing zeros, but then I still have to decide where to put the comma.
"19061" could be "1906,1" or "190,61". By looking at the actual value on my Toon I see where the comma should be, but isn't there a better way to have the best split between the value and the decimals?
Any suggestions?

Just divide by 100?

TheHogNL wrote:Just divide by 100?

That works in some cases, but in other cases it should be divided by 10.
E.g. Value "665" should be 665,00 and Value "12003" should be 1200,30 and not 120,03
As the Gas counter has changed from 3 to 4 digits (999->1000) now, perhaps I am making things too difficult, as the values will be 4 digits for a long time, but I was just wondering if I am overlooking some logic of the CSV export.

Arnout2000 wrote:

TheHogNL wrote:Just divide by 100?

That works in some cases, but in other cases it should be divided by 10.
E.g. Value "665" should be 665,00 and Value "12003" should be 1200,30 and not 120,03
As the Gas counter has changed from 3 to 4 digits (999->1000) now, perhaps I am making things too difficult, as the values will be 4 digits for a long time, but I was just wondering if I am overlooking some logic of the CSV export.

the whole CSV export is stupid from the start Toon only made this to be AGV compliant but is doesn't work properly

I think you are better of with the rrd export, search for "/hcb_rrd?action=getRrdData&loggerName" in de forum

Of maak gebruik van het aantal digits in de cel dus len(cell)

If(len(A1)=5), A1/100). Etc..

Ik ben weer eens in het importeren van TOON data gedoken. In eerste instantie door via het menu een dump te maken en die via de browser te importeren.

Ik vraag me af op welk tijdstip er gegevens worden weggeschreven in bijvoorbeeld dit bestand:
elec_quantity_nt_CurrentElectricityQuantity_10yrdays.csv

Als ik de dump op zondagmiddag maak, dan is de laatste entry in de file al de volgende dag, dus maandag. Dat lijkt me vreemd. Wat doe ik fout?