<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:D="DAV:" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:st="" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:Z="urn:schemas-microsoft-com:"><head><META content="text/html; charset=us-ascii" http-equiv="Content-Type">
<STYLE><!-- /* Style Definitions */ p.ecd5e81d-d305-4caf-a30f-2ff6caa1c563, li.ecd5e81d-d305-4caf-a30f-2ff6caa1c563, div.ecd5e81d-d305-4caf-a30f-2ff6caa1c563, table.ecd5e81d-d305-4caf-a30f-2ff6caa1c563Table {margin:0cm; margin-bottom:.0001pt;}div.Section1 {page:Section1;}--></STYLE>
<meta content="text/html; charset=us-ascii" http-equiv=Content-Type>
<meta content="Microsoft Word 12 (filtered medium)" name=Generator>
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Myriad Web Pro";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head><BODY>
<P CLASS="ecd5e81d-d305-4caf-a30f-2ff6caa1c563">
<div class=WordSection1>
<p class=MsoNormal><span style='color:#1F497D'>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 <a href="http://www.notetab.com/">http://www.notetab.com/</a>
It is a lot better than notepad.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Myriad Web Pro";
color:gray'>___________________________________________</span></b><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:olive'> <o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:olive'>Jeremy McClanathan</span></b><span style='font-size:7.5pt;
font-family:"Verdana","sans-serif";color:gray'>, LEED<sup>®</sup> AP</span><span style='font-size:12.0pt;font-family:"Verdana","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:olive'>CDi ENGINEERS</span></b><span style='font-family:"Verdana","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:gray'>4200 194th St SW, Ste 200, Lynnwood, WA 98036</span><span style='font-family:"Verdana","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:gray'>P 425-672-1071 | F 425-778-8769 </span><span style='font-family:
"Verdana","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:13.5pt;font-family:Webdings;
color:#99CC00'>P</span><span lang=EN-GB style='font-family:Webdings;color:#99CC00'>
</span><i><span lang=EN-GB style='font-size:7.0pt;font-family:"Verdana","sans-serif";
color:#99CC00'>Please consider the environment before printing this email.</span></i><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Nick Caton
[mailto:ncaton@smithboucher.com] <br>
<b>Sent:</b> Wednesday, July 28, 2010 12:02 PM<br>
<b>To:</b> ssavich@systemswestengineers.com; equest-users@lists.onebuilding.org<br>
<b>Subject:</b> Re: [Equest-users] Hey, how do you guys restore defaults?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for the flood of responses
everyone!<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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!<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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!! =)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Much appreciated!<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>~Nick<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='color:#1F497D'><img alt="cid:489575314@22072009-0ABB" border=0 height=37 id="_x0000_i1026" src="cid:image001.jpg@01CB2E57.BDCE7DD0" width=119></span><b><o:p></o:p></b></p>
<p class=MsoNormal><b><o:p> </o:p></b></p>
<p class=MsoNormal><b>NICK CATON, E.I.T.<o:p></o:p></b></p>
<p class=MsoNormal><span style='font-size:7.5pt;color:#CC9900'>PROJECT ENGINEER</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>25501 west
valley parkway<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>olathe ks 66061<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>direct 913
344.0036<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>fax 913 345.0617<o:p></o:p></span></p>
<p class=MsoNormal><i><span style='font-size:10.0pt;color:#2D4D5E'>Check out
our new web-site @ </span></i><span style='color:#1F497D'><a href="www.smithboucher.com" title="blocked::www.smithboucher.com"><span style='font-size:10.0pt'>www.smithboucher.com</span></a></span><u><span style='font-size:10.0pt;color:blue'> </span></u><span style='color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b>From:</b> Steven Savich
[mailto:ssavich@systemswestengineers.com] <br>
<b>Sent:</b> Wednesday, July 28, 2010 12:18 PM<br>
<b>To:</b> Nick Caton; equest-users@lists.onebuilding.org<br>
<b>Subject:</b> RE: [Equest-users] Hey, how do you guys restore defaults?<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Nick,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for the tip about
right-click and 'r', didn't know about that one.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Steven<o:p></o:p></span></p>
<div style='border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b>From:</b> equest-users-bounces@lists.onebuilding.org
[mailto:equest-users-bounces@lists.onebuilding.org] <b>On Behalf Of </b>Jeremy
McClanathan<br>
<b>Sent:</b> Wednesday, July 28, 2010 11:45 AM<br>
<b>To:</b> 'Kendra Tupper'; 'Pasha Korber-Gonzalez'<br>
<b>Cc:</b> equest-users@lists.onebuilding.org<br>
<b>Subject:</b> Re: [Equest-users] Hey, how do you guys restore defaults?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Jeremy<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b>From:</b> Kendra Tupper [mailto:ktupper@rmi.org] <br>
<b>Sent:</b> Wednesday, July 28, 2010 9:40 AM<br>
<b>To:</b> Pasha Korber-Gonzalez<br>
<b>Cc:</b> equest-users@lists.onebuilding.org<br>
<b>Subject:</b> Re: [Equest-users] Hey, how do you guys restore defaults?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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<o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><br clear=all>
Kendra Tupper, PE, LEED AP<br>
Senior Consultant<br>
Built Environment Team<br>
<br>
Rocky Mountain Institute | T 303-567-8641 | F
303-245-7213 | <a href="http://www.rmi.org">www.rmi.org</a><o:p></o:p></p>
<p class=MsoNormal>On Wed, Jul 28, 2010 at 10:38 AM, Pasha Korber-Gonzalez <<a href="mailto:pasha.pkconsulting@gmail.com">pasha.pkconsulting@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal>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 <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>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.<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>pkg<o:p></o:p></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b>From:</b> equest-users-bounces@lists.onebuilding.org
[mailto:equest-users-bounces@lists.onebuilding.org] <b>On Behalf Of </b>Nick
Caton<br>
<b>Sent:</b> Wednesday, July 28, 2010 9:25 AM<br>
<b>To:</b> equest-users@lists.onebuilding.org<br>
<b>Subject:</b> [Equest-users] Hey, how do you guys restore defaults?<o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.’<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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…<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Is anyone aware of any alternate methods to restoring
defaults?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>~Nick<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><img alt="cid:489575314@22072009-0ABB" border=0 height=37 id="Picture_x0020_1" src="cid:image001.jpg@01CB2E57.BDCE7DD0" width=119><b><o:p></o:p></b></p>
<p class=MsoNormal><b><o:p> </o:p></b></p>
<p class=MsoNormal><b>NICK CATON, E.I.T.<o:p></o:p></b></p>
<p class=MsoNormal><span style='font-size:7.5pt;color:#CC9900'>PROJECT ENGINEER</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>25501 west
valley parkway<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>olathe ks 66061<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>direct 913
344.0036<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#2D4D5E'>fax 913
345.0617<o:p></o:p></span></p>
<p class=MsoNormal><i><span style='font-size:10.0pt;color:#2D4D5E'>Check out
our new web-site @ </span></i><span style='color:#1F497D'><a href="www.smithboucher.com" title="blocked::www.smithboucher.com"><span style='font-size:10.0pt'>www.smithboucher.com</span></a></span><u><span style='font-size:10.0pt;color:blue'> </span></u><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</P>
<P CLASS="ecd5e81d-d305-4caf-a30f-2ff6caa1c563"><FONT COLOR="#808080" FACE="Verdana" SIZE="1">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.</FONT></P></BODY></HTML>