[Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

[Rohner, Curt]

You have to be careful but it can work.

Click on any cell in equest, hold the shift button and use the arrow keys to select the desire info to copy.  It should look like the screen below.

Click ctrl+c


[cid:image004.jpg at 01CC79D2.7EA8DA70]

Copy the data into excel like below.

[cid:image005.jpg at 01CC79D2.7EA8DA70]

Edit as necessary and then select the edited info and copy it.  See below.

[cid:image007.jpg at 01CC79D2.7EA8DA70]

Select the data in equest you want to paste over.

[cid:image009.jpg at 01CC79D2.7EA8DA70]

Click
Ctrl+Alt+V
Ctrl+C
Ctrl+V

If you look below.  I have copied in all of the Equip W/SF to 2 and the changed the first one to 1.5 to prove the change has in fact taken hold.

[cid:image011.jpg at 01CC79D2.7EA8DA70]




CURT ROHNER, LEED AP BD+C, EIT
Energy Services

Cannon Design

crohner at cannondesign.com<mailto:aborgese at cannondesign.com>

From: Charles Land [mailto:cland at geo-marine.com]
Sent: Friday, September 23, 2011 8:54 AM
To: Rohner, Curt; Pasha Korber-Gonzalez; Robby Oylear
Cc: equest-users at lists.onebuilding.org
Subject: RE: [Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

I just tried this out of curiosity and it didn't work....  I found I had to have a value there prior to trying this operation (just a zero worked fine) and I had to click on the box and then hit the down arrow and then up to make the box have a black outline. And then the values would past in using Ctrl+Alt+V.  Otherwise the values were not showing up as red text and would delete as soon as I entered my next value.  Also steps three and four just made it go away.  Are you using windows 7?  Im on XP.  This may be the difference.

From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Rohner, Curt
Sent: Friday, September 23, 2011 8:34 AM
To: Pasha Korber-Gonzalez; Robby Oylear
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

You can't copy and paste every cell.  Some are locked and prevent that function.

But don't despair.

Simply

Ctrl+C the desired material to copy over from excel while in excel.

Ctrl+Alt+V the material into the desired cells in the spreadsheet mode in eQuest.

Now here is the trick. Immediately

Ctrl+C again the material in the spreadsheet in eQuest

Without moving or doing anything else

Ctrl+V

And there you go.  I know it sounds ridiculous but it does work.

Remember

Ctrl+Alt+V
Ctrl+C
Ctrl+V

Don't do too much in too large a model.  It can take some time for eQuest to change all the values in the inp and can look like the program is stalled while it is in fact working but can (and has for me) taken a couple of hours to finish all the changes.

CURT ROHNER, LEED AP BD+C, EIT
Energy Services

Cannon Design

crohner at cannondesign.com<mailto:aborgese at cannondesign.com>

From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Pasha Korber-Gonzalez
Sent: Friday, September 23, 2011 4:02 AM
To: Robby Oylear
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Copy/Paste in eQUEST Spreadsheet Mode

HI Robby-

eQuest looks like a spreadsheet but doesn't act like one.  Don't mistake it for a spreadsheet.   You can copy/paste but you can only do it one cell at a time.

Cheers,
Pasha
On Thu, Sep 22, 2011 at 3:48 PM, Robby Oylear <robbyoylear at gmail.com<mailto:robbyoylear at gmail.com>> wrote:
Has anyone had any success with using the method below for copy/paste into eQUEST spreadsheet mode?  Once I've pasted the values into eQUEST it appears as if it's worked, but as soon as you allow the spreadsheet to update (by entering a value in any cell for example), all of the pasted values disappear and the old values are still present.

http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/2010-November/006688.html

Thanks,
-Robby

_______________________________________________
Equest-users mailing list
http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org
To unsubscribe from this mailing list send  a blank message to EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG<mailto:EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 109221 bytes
Desc: image004.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 102253 bytes
Desc: image005.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 87466 bytes
Desc: image007.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.jpg
Type: image/jpeg
Size: 113897 bytes
Desc: image009.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.jpg
Type: image/jpeg
Size: 109995 bytes
Desc: image011.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110923/cfbdfc69/attachment-0004.jpg>