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?
Importing gas usage in Excel
Moderators: marcelr, TheHogNL, Toonz
-
- Member
- Posts: 111
- Joined: Sun Oct 04, 2020 8:11 pm
Re: Importing gas usage in Excel
That works in some cases, but in other cases it should be divided by 10.TheHogNL wrote:Just divide by 100?
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.
Re: Importing gas usage in Excel
the whole CSV export is stupid from the start Toon only made this to be AGV compliant but is doesn't work properlyArnout2000 wrote:That works in some cases, but in other cases it should be divided by 10.TheHogNL wrote:Just divide by 100?
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.
Member of the Toon Software Collective
Re: Importing gas usage in Excel
I think you are better of with the rrd export, search for "/hcb_rrd?action=getRrdData&loggerName" in de forum
Member of the Toon Software Collective
-
- Advanced Member
- Posts: 638
- Joined: Sat Feb 09, 2019 7:18 pm
Re: Importing gas usage in Excel
Of maak gebruik van het aantal digits in de cel dus len(cell)
If(len(A1)=5), A1/100). Etc..
If(len(A1)=5), A1/100). Etc..
-
- Member
- Posts: 111
- Joined: Sun Oct 04, 2020 8:11 pm
Re: Importing gas usage in Excel
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?
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?