[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