[Equest-users] Hey, how do you guys restore defaults?

[Jeremy McClanathan]

Fyi, excel is great for more complicated things, but when I do use a text editor for quick changes, I have been using a free one called Note Tab Light http://www.notetab.com/   It is a lot better than notepad.

___________________________________________

Jeremy McClanathan, LEED(r) AP
CDi ENGINEERS
4200 194th St SW, Ste 200, Lynnwood, WA 98036
P 425-672-1071 | F 425-778-8769
P Please consider the environment before printing this email.



From: Nick Caton [mailto:ncaton at smithboucher.com]
Sent: Wednesday, July 28, 2010 12:02 PM
To: ssavich at systemswestengineers.com; equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Hey, how do you guys restore defaults?

Thanks for the flood of responses everyone!

I had a hunch I might pick up something new - I didn't realize a copy-pasted default would also paste as a default (green) input... doesn't work in all cases (when the default is a non-entry/blank), but definitely handy to know!

I've also been hung up on notepad and didn't realize you can simply open an .inp in excel for editing... oh, the possibilities!! =)

Much appreciated!

~Nick

[cid:image001.jpg at 01CB2E57.BDCE7DD0]

NICK CATON, E.I.T.
PROJECT ENGINEER
25501 west valley parkway
olathe ks 66061
direct 913 344.0036
fax 913 345.0617
Check out our new web-site @ www.smithboucher.com

From: Steven Savich [mailto:ssavich at systemswestengineers.com]
Sent: Wednesday, July 28, 2010 12:18 PM
To: Nick Caton; equest-users at lists.onebuilding.org
Subject: RE: [Equest-users] Hey, how do you guys restore defaults?

Nick,

If I have a bunch of the same parameter to restore, right-click & restore in one cell, ctrl+c the restored cell, then ctrl+v the rest of the cells in the column and use arrow keys to advance to the next cells.  Don't know of a keystroke combination to bring up the cell-specific context menu, though.

Thanks for the tip about right-click and 'r', didn't know about that one.

Steven



From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Jeremy McClanathan
Sent: Wednesday, July 28, 2010 11:45 AM
To: 'Kendra Tupper'; 'Pasha Korber-Gonzalez'
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Hey, how do you guys restore defaults?

Another option is to use the search and replace function of a text editor to find the line of code and replace with a blank line.  Sometimes I will do this in excel, then run a macro to delete all the blank rows and clean up the file.

Jeremy

From: Kendra Tupper [mailto:ktupper at rmi.org]
Sent: Wednesday, July 28, 2010 9:40 AM
To: Pasha Korber-Gonzalez
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] Hey, how do you guys restore defaults?

You can also copy and paste the "restored default" in spreadsheet view with CTRL C and CTRL V. But you can only paste one cell at a time - it doesn't work with multiple selections. Its a bit faster than right clicking though

Kendra Tupper, PE, LEED AP
Senior Consultant
Built Environment Team

Rocky Mountain Institute  |  T  303-567-8641 |  F  303-245-7213  |  www.rmi.org<http://www.rmi.org>
On Wed, Jul 28, 2010 at 10:38 AM, Pasha Korber-Gonzalez <pasha.pkconsulting at gmail.com<mailto:pasha.pkconsulting at gmail.com>> wrote:
I've tried and tested some hopefull-keystrokes to achieve the same thing, but I've only been able to get to where you are, 'right-click mouse & press "r".   But as I continue to get more practice (doing this a lot) I have gotten faster at the "click".  so, while it is still frustrating, it doesn't take as long as it used too.    lol

Ive also observed that by taking time to 'restore defaults' only once in my file and then use the aid of "user defaults", "global parameters", "user expressions", and "define link-ing" my inputs that I can stream-line my default inputs via these short-cut methods.  At least it has been working for me.   The clicking exercise of restoring-defaults only once in the model process is far more bearable.

pkg


From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Nick Caton
Sent: Wednesday, July 28, 2010 9:25 AM
To: equest-users at lists.onebuilding.org
Subject: [Equest-users] Hey, how do you guys restore defaults?

I learned a while ago that I can fly through spreadsheets and wizard/detailed edit screens restoring defaults by using my mouse to right-click a field and then using my other hand to hit the letter 'r.'

It occurred to me that for spreadsheet edits where I'm alternately entering new values and restoring defaults, it would be handy if there was a keystroke-only manner to do this (i.e. not using the mouse)... something like ctrl+r or some other way to bring up the cell-specific context menu...  Feels kinda clunky everytime I'm in this situation...

Is anyone aware of any alternate methods to restoring defaults?

~Nick

[cid:image001.jpg at 01CB2E57.BDCE7DD0]

NICK CATON, E.I.T.
PROJECT ENGINEER
25501 west valley parkway
olathe ks 66061
direct 913 344.0036
fax 913 345.0617
Check out our new web-site @ www.smithboucher.com


This email message, including any attachments, is for the sole use of the intended recipient and may contain confidential, proprietary, and/or privileged information, as well as content subject to copyright and other intellectual laws.  If you are not the intended recipient, you may not disclose, use, copy, or distribute the email message or its attachments.  If you believe you have received this email message in error, please contact the sender by reply email, immediately delete this email and destroy copies.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20100728/8238556f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1459 bytes
Desc: image001.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20100728/8238556f/attachment.jpg>