[Equest-users] Changing Multiple Spreadsheet Cells with Single NewValue

Varkie C Thomas thomasv at iit.edu
Fri Jul 8 08:34:46 PDT 2011


Nick,
Thanks.  You really are an expert at eQUEST and the subject of building energy performance analysis.
Varkie


----- Original Message -----
From: Nick Caton <ncaton at smithboucher.com>
Date: Thursday, July 7, 2011 5:57 pm
Subject: RE: [Equest-users] Changing Multiple Spreadsheet Cells with Single NewValue
> Hey Varkie! 
> 
> 
> 
> Good question � IIRC, this came up once in an earlier discussion 
> sharing other time-saving input tips � might be worth a search in 
> the archives. 
> 
> 
> Here�s a quick visual walk-through of user defaults: 
> 
> 
> 
> 1.       Right-click a field in spreadsheet view: 
> 
> 
> 
> 2.       Clicking �Edit/View User Default�� brings you this dialog: 
> 
> 
> 
> 3.       Click the 2nd radio button and set a new default value 
> like so, and click �OK�: 
> 
> 
> 
> 4.       Voila!  All inputs for that field which are defaulted 
> (not red) will change blue, to indicate a non-library default is 
> being used.  You can copy (ctrl+c) and paste (ctrl+v) green or 
> blue cells to return defined (red) fields to default 
> (green/blue/violet): 
> 
> 
> 
> 
> ~Nick 
> 
> 
> 
> 
> 
> 
> 
> NICK CATON, P.E. 
> 
> SENIOR ENGINEER 
> 
> 
> 
> Smith & Boucher Engineers 
> 
> 25501 west valley parkway, suite 200 
> 
> olathe, ks 66061 
> 
> direct 913.344.0036 
> 
> fax 913.345.0617 
> 
> www.smithboucher.com 
> 
> 
> 
> From: equest-users-bounces at lists.onebuilding.org [mailto:equest- 
> users-bounces at lists.onebuilding.org] On Behalf Of Varkie C Thomas 
> Sent: Thursday, July 07, 2011 4:31 PM 
> To: equest-users at lists.onebuilding.org 
> Subject: [Equest-users] Changing Multiple Spreadsheet Cells with 
> Single NewValue 
> 
> 
> 
> I could not make the instructions below work.  Could someone 
> explain it in more detail? 
> 
> From: bldg-sim-bounces at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> 
> 
> [mailto:bldg-sim-bounces at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> ] On Behalf Of Josh 
> 
> Greenfield 
> 
> Sent: Tuesday, May 27, 2008 11:40 AM 
> 
> To: bldg-sim at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> 
> 
> Subject: [Bldg-sim] eQuest Spreadsheet tab 
> 
> 
> 
> Is there a way to edit/change multiple values at one time while in the 
> 
> Detailed Edit Spreadsheet tab?  Multi-selecting using Ctrl+ didn't 
> seem 
> to work... 
> 
> 
> 
> Josh Greenfield, PE, LEED AP 
> 
> Primera Engineers, Ltd. 
> 
> 
> 
> ________________________________ 
> 
> 
> 
> From: bldg-sim-bounces at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> 
> 
> [mailto:bldg-sim-bounces at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> ] On Behalf Of Kevin Kyte 
> 
> Sent: Tuesday, May 27, 2008 11:52 AM 
> 
> To: 'Josh Greenfield' 
> 
> Cc: bldg-sim at lists.onebuilding.org 
> <http://lists.onebuilding.org/listinfo.cgi/bldg-sim- 
> onebuilding.org> 
> 
> Subject: Re: [Bldg-sim] eQuest Spreadsheet tab 
> 
> 
> 
> Right-click input box > Left-click edit/view user default > Click 
> 
> User-defined default value > enter default value in box after colon. 
> 
> 
> 
> Kevin Kyte, LEED AP 
> 
> RobsonWoese, Inc. 
> 
> 
> 
> ________________________________ 
> 
> 
> 
> However, that only works if the values in question are already at 
> their 
> default.  
> 
> Nevertheless you can copy and paste multiple values. 
> 
> 
> 
> Demba Ndiaye 
> 
> 
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110708/bb349ab1/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: thomasv.vcf
Type: text/x-vcard
Size: 308 bytes
Desc: Card for Varkie C Thomas <thomasv at iit.edu>
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110708/bb349ab1/attachment-0002.vcf>


More information about the Equest-users mailing list