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

[Nick Caton]

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/20110707/3cb02cfd/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 15214 bytes
Desc: image001.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110707/3cb02cfd/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12422 bytes
Desc: image002.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110707/3cb02cfd/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12394 bytes
Desc: image003.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110707/3cb02cfd/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1459 bytes
Desc: image004.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110707/3cb02cfd/attachment-0002.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 18115 bytes
Desc: image005.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110707/3cb02cfd/attachment-0011.png>