APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Daniel Burapavong
Hello. I am using the latest version of APC Reporter that was sent to me yesterday.



On the Unit Tracking tab, I am having a copy-and-paste issue into Excel. When I select all on the Unit Tracking tab and paste into Excel, the header comes in funky like this and I have to manually fix it:



Am I doing something wrong or is this something you can correct in the app?

Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Rob Burchett
Administrator
Daniel - No, you're doing nothing wrong - our bad.

We recently (yesterday) responded to a user request to automatically pre-sort the unit name column when switching views using the radio buttons. (Don't worry Neil, I won't say who it is).  This required putting the "totals" in the column headers, because the former "Totals" row would get lost in the sorting.  To make the column headers pretty, I put a "return" character in the text to make sure the totals value would be on a separate "line" in the header: hence your funny looking grid-copy.

All fixed now - but you will no doubt notice the absence of a "totals" row in what winds up in Excel.  Working on that, but it may be harder than it sounds.

Also note: It's not necessary to first select the grid you are copying.  Just right-click any cell, and the entire grid will copy.

You should get an "update" link from John soon.  Thanks for your patience.
Rob.
Rob
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Neil Copeland
Rob, I also noticed that the annual totals have been replaced with "Total" and the annual value is actually gone now.  Can that be changed to report the annual number?

Also, I noticed when looking at the hourly tab the wind, for example, all have zeroes after the decimal.  For example, instead of displaying 42.68, the APC will report 43.00.
Neil Copeland
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Rob Burchett
Administrator
Neil - it's Friday afternoon.  Really?
I just repaired the things you mentioned - John will send you a link soon.
On to perfection!
Rob
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Daniel Burapavong
In reply to this post by Rob Burchett
Rob Burchett wrote
We recently (yesterday) responded to a user request to automatically pre-sort the unit name column when switching views using the radio buttons. (Don't worry Neil, I won't say who it is).


Thanks, Rob and Neil.

I would like to get the latest version that incorporates the changes Neil identified too, please. Thank you.

Edit: I received the update link via email at 2:26 PM ET. I'm not sure if that incorporates Neil's suggested changes or not.
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Rob Burchett
Administrator
Yes - the previous link should have the latest.
Rob
Reply | Threaded
Open this post in threaded view
|

Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Daniel Burapavong
Hey Rob, I used the latest link that was sent to me for the APC Reporter and my version still doesn't show the total on the Unit Tracking tab. Can you please send me the latest version? Thank you.

Reply | Threaded
Open this post in threaded view
|

RE: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Rob Burchett
Administrator

Daniel,  It should be on its way to you soon.

 

Rob

www.PowerAnalyticsSoftware.net

518.384.0872

 

From: Daniel Burapavong [via Power Analytics Software Forum] <[hidden email]>
Sent: Thursday, December 10, 2020 4:26 PM
To: Rob Burchett <[hidden email]>
Subject: Re: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

 

Hey Rob, I used the latest link that was sent to me for the APC Reporter and my version still doesn't show the total on the Unit Tracking tab. Can you please send me the latest version? Thank you.


To start a new topic under Power Analytics Software Forum, email [hidden email]
To unsubscribe from Power Analytics Software Forum, click here.
NAML

Rob
Reply | Threaded
Open this post in threaded view
|

RE: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Daniel Burapavong
Got it and it works. Thank you, Rob.
Reply | Threaded
Open this post in threaded view
|

RE: APC Reporter - Unit Tracking Tab - Copy and Paste Issue

Daniel Burapavong
Rob, this is not urgent, but after copying and pasting from the APC Reporter into Excel, we are having to manually calculate the totals that show up in the headers of the APC Reporter. Unless I'm missing something, in a future release, can you please allow us to also copy in the totals from the APC Reporter? Thank you.