You can still do a manual correction for the data to Midnight as there are only a few points that require correcting by using the data from SolarWeb and then recalculate to tidy up the data to the end of the day.
There were only 11 entries to fix, so you can do it manually as below:
Go to SolarWeb, and note down the following:
Time and Power Usage(watts) over the interval from 23:05 to 23:55
23:05,158
23:10,100464
etc.
Do this for the erroneous 50 minutes of data in PVOutput starting 5 minutes before the spike at 23:05 hrs up to 23:55 hours. On the top menu of PVOutput, select “Add Output”, and at the bottom of this page select “live loader”
Set the load page like below:
Select the date you want to populate
Enable just Time and Power Consumed, with Power Consumed set to W (watts) and Position 2, and then just type the values into the Entry box as:
23:05,158
23:10, 100464
etc.
Once you have typed in the corrected entries, click on the “Validate” button at the bottom of the page. The entered data will be checked, and if all good you will see a list of the entries that will be replaced. If all is correct choose “Upload” and the current erroneous data, and the spike will be corrected. Give it a few minutes to load, then recheck the data. It should now have the spike fixed, as well as correcting the hour of incorrect usage data.
If the data has now been fixed, and you want to correct any calculated usage costs, go to the daily view, and enable the tick box on the left hand side for yesterday’s data. Under the daily graph, click on “more” to show further options, one of which is “Recalculate” This will recalculate the data for after the corrections for incremental totals, costs and savings.
Appreciate it!