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