Enhancement request - Provision of Excel Charts

Jishar13 / pvbeancounter

Automatically exported from code.google.com/p/pvbeancounter

1 stars 0 forks source link

Enhancement request - Provision of Excel Charts #27

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

Would you be able to create Excel 2007 charts that use the Access database as a 
data source and display summary data please?  I guess along the lines of 
Hourly, Daily, Monthly, Yearly summaries. Thanks!

Original issue reported on code.google.com by jonpull...@gmail.com on 17 Apr 2011 at 9:29

GoogleCodeExporter commented 8 years ago

Not difficult - considering the correct response

Original comment by DennisMackayFisher on 17 Apr 2011 at 11:03

Added labels: Priority-Low, Type-Enhancement
Removed labels: Priority-Medium, Type-Defect

GoogleCodeExporter commented 8 years ago

Original comment by DennisMackayFisher on 17 Apr 2011 at 11:03

Changed state: Accepted

GoogleCodeExporter commented 8 years ago

Original comment by DennisMackayFisher on 24 Apr 2011 at 7:01

Changed title: Enhancement request - Provision of Excel Charts

GoogleCodeExporter commented 8 years ago

Hi Dennis, This would also be really useful to do from the SQLite database.  I 
was going to use Access as the database until I read you were considering 
discontinuing support!  So having the ability to use Excel for analysis from 
SQLite would be great.  Thanks Malcolm

Original comment by mjyoun...@googlemail.com on 3 Jul 2011 at 9:13

GoogleCodeExporter commented 8 years ago

[deleted comment]

GoogleCodeExporter commented 8 years ago

Hi Dennis, I would agree with Malcolm - even though I'm currently using MS 
Access I have read that support is being discontinued, so am eagerly waiting to 
convert my DB to MS SQL 2008 and would find Excel charts connecting to SQL a 
better option. Many thanks

Original comment by jonpull...@gmail.com on 3 Sep 2011 at 8:02

GoogleCodeExporter commented 8 years ago

This is background work. I have made progress on a database migration tool. MS 
Access will not be dropped unless I have a migration option in place.

I do not want to create Excel charts. I will provide some basic dashboard 
facilities in the future including data export in Excel friendly formats.

You can use the PVBC Access database in Excel via ODBC drivers for MS Access.

Dennis M-F

Original comment by DennisMackayFisher on 4 Sep 2011 at 12:43

GoogleCodeExporter commented 8 years ago

Dennis,
Personally speaking, just the ability to be able to export a csv from the 
sqlite for a given date range giving energy usage in time period blocks (ie, 10 
or 30 mins) would be awesome, something similar to the output Google Powermeter 
used to provide. (even the 6 sec blocks is workable, just makes for a very long 
csv for three months!)
That can then be copy-pasted into my excel book to spit out the AGL TOU 
expected tariffs!
Was working great until google packed up and wandered off!

Original comment by PeteRown...@gmail.com on 30 Sep 2011 at 12:39

GoogleCodeExporter commented 8 years ago

I had the same need - to extract data from SQLite and manipulate in Excel.

Found this:  <http://sqliteadmin.orbmu2k.de/> which is fairly simple but seems 
to do the job adequately despite my ignorance of SQL databases!  I just copy 
the PVHistory.S3db file (to avoid possible problems with the active database) 
then open with SQLite Administrator and export data to Excel. Still learning 
how to  manipulate the data in SQLite Administrator before exporting!

May well be other similar applications

Rob

Original comment by moilo...@gmail.com on 26 Jul 2012 at 9:17

GoogleCodeExporter commented 8 years ago

Refer to dev schedule

Original comment by DennisMackayFisher on 5 Dec 2012 at 3:36

Changed state: Done