Daily Consumption CSV

Avatar

sdg.matiaan
2019-08-08 16:26

There is a report in PNPSCADA for Daily Consumption Graph.
However, it does not supply the daily consumption as a CSV download.
You can get half hour consumption in CSV from View->Download and then summate for each date, however this can be quite cumbersome, esp if there are many days.
Microsoft has a tool LogParser 2.2 that can help.
You can download it at https://www.microsoft.com/en-us/download/confirmation.aspx?id=24659
After installing it, put your CSV file in C:\Users\\
Take out the first row of the CSV (in Excel) that says 'pnpscada.com', so that P, Q, DATE, TIME is the first row
and then run this command
'c:\Program Files (x86)\Log Parser 2.2\LogParser' 'select date,sum(p) from 8110-2016-03-16-0.csv group by date order by date'
(You will need to change the 8110-2016-03-16-0.csv with you file's name)
You should then get output like this:

Please log in to post a comment