<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" 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:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:"Stylus BT";
panose-1:2 14 4 2 2 2 6 2 3 4;}
/* 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 lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Nick,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Another work around - when the default in a blank, make the default a user defined value (it doesn't matter what it is). You can now cut and paste the default value (in blue) across the board. Once you've done
that you can restore it to DOE2 default which will make it go back to blank.<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">Tada!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:9.0pt;
font-family:"Arial","sans-serif";color:gray">Vikram Sami</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:gray">, LEED AP<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;
font-family:"Arial","sans-serif";color:gray">Sustainable Design Analyst<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;
font-family:"Arial","sans-serif";color:gray">1382 Peachtree St. NE, Atlanta, GA 30309<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.0pt;
font-family:"Arial","sans-serif";color:gray">t: 404-443-7462 f:
</span><span lang="ES" style="font-size:9.0pt;font-family:"Arial","sans-serif";
color:gray">404.892.5823 </span><span style="font-size:9.0pt;
font-family:"Arial","sans-serif";color:gray"> e: vikram.sami@perkinswill.com
</span><span style="color:#1F497D"><a href="http://www.perkinswill.com/"><span style="font-size:9.0pt;font-family:
"Arial","sans-serif";color:gray;text-decoration:none">www.perkinswill.com</span></a></span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:gray"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;text-autospace:none"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:gray">Perkins+Will.</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:gray">
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#ADD425">Ideas + buildings that honor the broader goals of society</span><span style="font-size:
9.0pt;font-family:"Arial","sans-serif";color:green"><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"><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""> 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 3: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 border="0" width="119" height="37" id="_x0000_i1026" src="cid:image001.jpg@01CB33F1.938F7B60" alt="cid:489575314@22072009-0ABB"></span><b><span style="font-family:"Stylus BT","sans-serif";
color:#2D4D5E"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Stylus BT","sans-serif";
color:#2D4D5E"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Stylus BT","sans-serif";
color:#2D4D5E">NICK CATON, E.I.T.</span></b><b><span style="font-size:12.0pt;
font-family:"Stylus BT","sans-serif";color:#2D4D5E"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#CC9900">PROJECT ENGINEER</span><span style="font-size:7.5pt;font-family:"Times New Roman","serif";color:#CC9900"><o:p></o:p></span></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><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""> 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></span></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><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""> 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></span></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><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""> 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></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p> </o:p></span></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><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""> 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></span></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 border="0" width="119" height="37" id="Picture_x0020_1" src="cid:image001.jpg@01CB33F1.938F7B60" alt="cid:489575314@22072009-0ABB"><b><span style="font-family:"Stylus BT","sans-serif";color:#2D4D5E"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Stylus BT","sans-serif";
color:#2D4D5E"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Stylus BT","sans-serif";
color:#2D4D5E">NICK CATON, E.I.T.</span></b><b><span style="font-size:12.0pt;
font-family:"Stylus BT","sans-serif";color:#2D4D5E"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#CC9900">PROJECT ENGINEER</span><span style="font-size:7.5pt;font-family:"Times New Roman","serif";color:#CC9900"><o:p></o:p></span></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>
<br>
<font face="Arial" color="Gray" size="1">This email and any files transmitted with it are confidential and intended solely for the addressee. If you are not the named addressee you should not disseminate, distribute, copy, or alter this email.<br>
</font>
</body>
</html>