som.Registry=[];som.aniLen=250;som.hideDelay=1000;som.minCPUResolution=10;function som(id,dir,left,top,width,height){this.ie=document.all?1:0;this.ns4=document.layers?1:0;this.dom=document.getElementById?1:0;if(this.ie||this.ns4||this.dom){this.id=id;this.dir=dir;this.orientation=dir=="left"||dir=="right"?"h":"v";this.dirType=dir=="right"||dir=="down"?"-":"+";this.dim=this.orientation=="h"?width:height;this.hideTimer=false;this.aniTimer=false;this.open=false;this.over=false;this.startTime=0;this.gRef="som_"+id;eval(this.gRef+"=this");som.Registry[id]=this;var d=document;var strCSS='<style type="text/css">';strCSS+="#"+this.id+"Container { display:none; ";strCSS+="left:"+left+"px; ";strCSS+="top:"+top+"px; ";strCSS+="overflow:hidden; z-index:10000; }";strCSS+="#"+this.id+"Container, #"+this.id+"Content { position:absolute; ";strCSS+="width:"+width+"px; ";strCSS+="height:"+height+"px; ";strCSS+="clip:rect(0 "+width+" "+height+" 0); ";strCSS+="}";strCSS+="</style>";d.write(strCSS);this.load()}}som.prototype.load=function(){var d=document;var lyrId1=this.id+"Container";var lyrId2=this.id+"Content";var obj1=this.dom?d.getElementById(lyrId1):this.ie?d.all[lyrId1]:d.layers[lyrId1];if(obj1){var obj2=this.ns4?obj1.layers[lyrId2]:this.ie?d.all[lyrId2]:d.getElementById(lyrId2)}var temp;if(!obj1||!obj2){window.setTimeout(this.gRef+".load()",100)}else{this.container=obj1;this.menu=obj2;this.style=this.ns4?this.menu:this.menu.style;this.homePos=eval("0"+this.dirType+this.dim);this.outPos=0;this.accelConst=(this.outPos-this.homePos)/som.aniLen/som.aniLen;if(this.ns4){this.menu.captureEvents(Event.MOUSEOVER|Event.MOUSEOUT)}this.menu.onmouseover=new Function("som.showMenu('"+this.id+"')");this.menu.onmouseout=new Function("som.hideMenu('"+this.id+"')");this.endSlide()}};som.showMenu=function(f){var e=som.Registry;var d=som.Registry[f];if(d.container){d.over=true;for(menu in e){if(f!=menu){som.hide(menu)}}if(d.hideTimer){e[f].hideTimer=window.clearTimeout(e[f].hideTimer)}if(!d.open&&!d.aniTimer){e[f].startSlide(true)}}};som.hideMenu=function(c){var d=som.Registry[c];if(d.container){if(d.hideTimer){window.clearTimeout(d.hideTimer)}d.hideTimer=window.setTimeout("som.hide('"+c+"')",som.hideDelay)}};som.hideAll=function(){var b=som.Registry;for(menu in b){som.hide(menu);if(menu.hideTimer){window.clearTimeout(menu.hideTimer)}}};som.hide=function(c){var d=som.Registry[c];d.over=false;if(d.hideTimer){window.clearTimeout(d.hideTimer)}d.hideTimer=0;if(d.open&&!d.aniTimer){d.startSlide(false)}};som.prototype.startSlide=function(b){this[b?"onactivate":"ondeactivate"]();this.open=b;if(b){this.setVisibility(true)}this.startTime=(new Date()).getTime();this.aniTimer=window.setInterval(this.gRef+".slide()",som.minCPUResolution)};som.prototype.slide=function(){var d=(new Date()).getTime()-this.startTime;if(d>som.aniLen){this.endSlide()}else{var c=Math.round(Math.pow(som.aniLen-d,2)*this.accelConst);if(this.open&&this.dirType=="-"){c=-c}else{if(this.open&&this.dirType=="+"){c=-c}else{if(!this.open&&this.dirType=="-"){c=-this.dim+c}else{c=this.dim+c}}}this.moveTo(c)}};som.prototype.endSlide=function(){this.aniTimer=window.clearTimeout(this.aniTimer);this.moveTo(this.open?this.outPos:this.homePos);if(!this.open){this.setVisibility(false)}if((this.open&&!this.over)||(!this.open&&this.over)){this.startSlide(this.over)}};som.prototype.setVisibility=function(d){var c=this.ns4?this.container:this.container.style;c.display=d?"block":"none"};som.prototype.moveTo=function(b){this.style[this.orientation=="h"?"left":"top"]=this.ns4?b:b+"px"};som.prototype.getPos=function(b){return parseInt(this.style[b])};som.prototype.onactivate=function(){};som.prototype.ondeactivate=function(){};new som("menu1","right",150,200,150,250);new som("menu2","right",150,255,150,100);new som("menu3","right",150,283,150,175);new som("menu4","right",150,311,150,75);var imgAr=new Array("images/smenu.gif","images/mmenu.jpg");if(document.images){var rImg=new Array();for(var i=0;i<imgAr.length;i++){rImg[i]=new Image();rImg[i].src=imgAr[i]}};var TINY={};function T$(a){return document.getElementById(a)}TINY.box=function(){var a,e,k,j,c,h,g,l,d,i=0;return{show:function(q,m,f,o,b,n){if(!i){a=document.createElement("div");a.id="tinybox";e=document.createElement("div");e.id="tinymask";k=document.createElement("div");k.id="tinycontent";document.body.appendChild(e);document.body.appendChild(a);a.appendChild(k);e.onclick=TINY.box.hide;window.onresize=TINY.box.resize;i=1}if(!b&&!m){a.style.width=f?f+"px":"auto";a.style.height=o?o+"px":"auto";a.style.backgroundImage="none";k.innerHTML=q}else{k.style.display="none";a.style.width=a.style.height="100px"}if(q.length>=3){var p=q.substring(q.length,q.length-3).toLowerCase();if(p=="gif"||p=="jpg"||p=="png"){q='<img src="'+q+'"/>'}}this.mask();c=q;h=m;g=f;l=o;d=b;this.alpha(e,1,80,3);if(n){setTimeout(function(){TINY.box.hide()},1000*n)}},fill:function(p,n,m,o,f){if(n){a.style.backgroundImage="";var b=window.XMLHttpRequest?new XMLHttpRequest():new ActiveXObject("Microsoft.XMLHTTP");b.onreadystatechange=function(){if(b.readyState==4&&b.status==200){TINY.box.pics(b.responseText,m,o,f)}};b.open("GET",p,1);b.send(null)}else{this.pics(p,m,o,f)}},psh:function(p,m,n,f){if(f){if(!m||!n){var b=a.style.width,o=a.style.height;k.innerHTML=p;a.style.width=m?m+"px":"";a.style.height=n?n+"px":"";k.style.display="";m=parseInt(k.offsetWidth);n=parseInt(k.offsetHeight);k.style.display="none";a.style.width=b;a.style.height=o}else{k.innerHTML=p}this.size(a,m,n)}else{a.style.backgroundImage="none"}},hide:function(){TINY.box.alpha(a,-1,0,3)},resize:function(){TINY.box.pos();TINY.box.mask()},mask:function(){e.style.height=TINY.page.total(1)+"px";e.style.width="";e.style.width=TINY.page.total(0)+"px"},pos:function(){var b=(TINY.page.height()/2)-(a.offsetHeight/2);b=b<10?10:b;a.style.top=(b+TINY.page.top())+"px";a.style.left=(TINY.page.width()/2)-(a.offsetWidth/2)+"px"},alpha:function(f,m,b){clearInterval(f.ai);if(m==1){f.style.opacity=0;f.style.filter="alpha(opacity=0)";f.style.display="block";this.pos()}f.ai=setInterval(function(){TINY.box.ta(f,b,m)},20)},ta:function(f,b,p){var m=Math.round(f.style.opacity*100);if(m==b){clearInterval(f.ai);if(p==-1){f.style.display="none";f==a?TINY.box.alpha(e,-1,0,2):k.innerHTML=a.style.backgroundImage=""}else{f==e?this.alpha(a,1,100):TINY.box.fill(c,h,g,l,d)}}else{var q=Math.ceil((m+((b-m)*0.5)));q=q==1?0:q;f.style.opacity=q/100;f.style.filter="alpha(opacity="+q+")"}},pics:function(q,s,n,r){k.innerHTML=q;var m,f,p=new Array(),b=new Array(),t=0,o=0;m=k.getElementsByTagName("img");for(f in m){if(m[f].src!=undefined){p[f]=new Image();p[f].src=m[f].src;b[f]=false}}this.lpic(p,b,t,o,q,s,n,r)},lpic:function(o,b,t,n,q,s,m,r){var p=this,f;n++;if(t==o.length||n>=100){clearTimeout("to");p.psh(q,s,m,r)}else{for(f=0;f<=o.length;f++){if(b[f]==false&&o[f].complete){b[f]=true;t++}}to=setTimeout(function(){p.lpic(o,b,t,n,q,s,m,r)},100)}},size:function(p,r,n){var o=parseInt(e.style.height,10);if((n+10)>=o){e.style.height=(n+30)+"px"}p=typeof p=="object"?p:T$(p);clearInterval(p.si);var b=p.offsetWidth,s=p.offsetHeight,q=b-parseInt(p.style.width),t=s-parseInt(p.style.height);var f=b-q>r?0:1,m=(s-t>n)?0:1;p.si=setInterval(function(){TINY.box.ts(p,r,q,f,n,t,m)},20)},ts:function(q,s,r,m,p,u,o){var f=q.offsetWidth-r,t=q.offsetHeight-u;if(f==s&&t==p){clearInterval(q.si);a.style.backgroundImage="none";k.style.display="block";q.style.filter=""}else{if(f!=s){var b=f+((s-f)*0.5);q.style.width=m?Math.ceil(b)+"px":Math.floor(b)+"px"}if(t!=p){var b=t+((p-t)*0.5);q.style.height=o?Math.ceil(b)+"px":Math.floor(b)+"px"}this.pos()}}}}();TINY.page=function(){return{top:function(){return document.documentElement.scrollTop||document.body.scrollTop},width:function(){return self.innerWidth||document.documentElement.clientWidth||document.body.clientWidth},height:function(){return self.innerHeight||document.documentElement.clientHeight||document.body.clientHeight},total:function(f){var a=document.body,c=document.documentElement;return f?Math.max(Math.max(a.scrollHeight,c.scrollHeight),Math.max(a.clientHeight,c.clientHeight)):Math.max(Math.max(a.scrollWidth,c.scrollWidth),Math.max(a.clientWidth,c.clientWidth))}}}();function rrevs(pname,id,pid,nb){if(nb==""){nb=10};var content='<iframe id="frameTiny" src="reviews.asp?p='+id+'&amp;l='+nb+'&amp;h=n&amp;j=n&amp;s=1" width="500" height="378" scrolling="vertical" frameborder="no" marginwidth="0" marginheight="0"></iframe><p align="right"><a href="javascript:wrev('+pid+')">Write a Review for '+ pname+'</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="javascript:TINY.box.hide();"><img src="images/closelabel.gif" style="vertical-align:top"></a></p>';TINY.box.show(content,0,500,400,1);}function wrev(id){document.getElementById("frameTiny").src="prodreview.asp?id="+id;}
function review(prodid){if(prodid!=""){var content='<iframe id="frameTiny" src="prodreview.asp?id='+ prodid+'" width="400" height="290" scrolling="no" frameborder="no" marginwidth="0" marginheight="0"></iframe><p align="right" style="margin:0px"><a href="javascript:TINY.box.hide();"><img src="images/closelabel.gif" border="0"></a></p>';TINY.box.show(content,0,400,312,1);}}
function dv(p){var cnt='<iframe id="frameVideo" src="video.asp?prod='+p+'&amp;y=1" width="800" height="590" scrolling="no" frameborder="no" marginwidth="0" marginheight="0"></iframe><p align="right"><a href="javascript:TINY.box.hide();"><img src="images/closelabel.gif" style="vertical-align:top"></a></p>';TINY.box.show(cnt,0,800,612,1);}
function limg(p,i,t,u){var shtm="",aj=0;if(p!=''){aj=1;shtm+='screen.asp?p='+p}else{shtm+='<table border="0" cellspacing="0" cellpadding="0"><tr><td colspan="2">';if(u!=""){shtm+='<a href="'+u+'" title="Get &quot;'+t+'&quot; Here">'};shtm+='<img src="'+i+'" alt="'+t+'" border="0" />';if(u!=""){shtm+='</a>'};shtm+='</td></tr><tr><td align="left" valign="bottom">';if(u!=""){shtm+='<a href="'+u+'" title="Get &quot;'+t+'&quot; Now" class="btno">Get Now</a>'};shtm+='</td><td align="right" valign="bottom"><a href="javascript:TINY.box.hide();"><img src="images/closelabel.gif" alt="Close" border="0" /></a></td></tr></table>';}TINY.box.show(shtm,aj,0,0,1);}
function ls(){if(document.search.q.value!=""){window.location="solutions.asp?q="+document.search.q.value.replace(/ /g,"+")}}
function refq(){var s="";var st="";var e="";if(document.URL.indexOf('q=')!=-1){s=document.URL.search(/q=/);st=document.URL.substring(s+2);e=st.search(/&/);e=(e==-1)?st.length:e;st=st.substring(0,e);}if(document.referrer&&document.referrer!=""&&st==""&&document.referrer.indexOf('q=')!=-1){s=document.referrer.search(/q=/);st=document.referrer.substring(s+2);e=st.search(/&/);e=(e==-1)?st.length:e;st=st.substring(0,e);}if(st==""){st=document.title;}st=st.replace(/Excel/g,"");st=st.replace(/Templates/g,"");st=st.replace(/Help/g,"");st=st.replace(/for /g,"");st=st.replace(/Add-ins/g,"");st=st.replace(/and/g,"");st=st.replace(/&/g,"");st=st.replace(/-/g,"");st=st.replace(/:/g,"");st=st.replace(/  /g," ");st=st.replace(/^\s\s*/,"").replace(/\s\s*$/,"");if(st.length!=0){st=st.replace(/\+/g," ");st=unescape(st);if(document.getElementById("sbx")){document.getElementById("sbx").value=st;}}}
if(window.addEventListener){window.addEventListener('load',refq,false);}else if(window.attachEvent){window.attachEvent('onload',refq);}
function sas(id){document.getElementById(id).focus();document.getElementById(id).select();}
function gxo(){if(window.XMLHttpRequest){return new XMLHttpRequest();}else{return new ActiveXObject("Microsoft.XMLHTTP");}}
var sreq=gxo();function ssug(){if(sreq.readyState==4||sreq.readyState==0){var str=escape(document.getElementById('sbx').value);document.getElementById('sbx').setAttribute("autocomplete","off");if(str.length>1){sreq.open("GET",'searchsuggest.asp?q='+str,true);sreq.onreadystatechange=hssug;sreq.send(null);}else{document.getElementById('dss').innerHTML='';}}}function hssug(){if(sreq.readyState==4){var ssh=document.getElementById('dss');ssh.innerHTML='';var str=sreq.responseText.split("\n");for(i=0;i<str.length-1;i++){var sug='<div onmouseover="javascript:sugr(this); "';sug+='onmouseout="javascript:sugt(this);" ';sug+='onclick="javascript:sugs(this.innerHTML);" ';sug+='class="slink">'+ str[i]+'</div>';ssh.innerHTML+=sug;}}}function sugr(dv){dv.className='slinko';}function sugt(dv){dv.className='slink';}function sugs(v){document.getElementById('sbx').value=v.replace(" &amp;","");document.getElementById('dss').innerHTML='';}
function sti(){if(document.getElementById("stc")){var sj="";sj+="<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"2\"><tr>";sj+="<td width=\"32\" valign=\"bottom\"><span class=\"st_plusone_button\"><\/span><\/td>";sj+="<td width=\"104\" valign=\"middle\" align=\"center\" class=\"cb\">";sj+="<span class=\"st_sharethis\" st_image=\"http:\/\/www.business-spreadsheets.com\/images\/bslogo.png\" title=\"Share this with others\"><\/span>";sj+="<span class=\"st_bus_exchange\" title=\"Add this to the Business Exchange\"><\/span>";sj+="<span class=\"st_fwisp\" title=\"Submit this to the fwisp network\"><\/span>";sj+="<span class=\"st_edmodo\" title=\"Save this on Edmodo\"><\/span>";sj+="<\/tr><\/table>";document.getElementById("stc").innerHTML=sj;if(typeof stLight!='undefined'){stLight.options({publisher:'852708e2-0550-437e-ab25-38f260be79ea',onhover:false,headerTitle:'Share this with associates and networks',theme:'3'})};}}
var switchTo5x=true;var __st_loadLate=true;var oh=document.getElementsByTagName('head').item(0);var os=document.createElement("script");os.type="text/javascript";os.src="http://w.sharethis.com/button/buttons.js";oh.appendChild(os);if(window.addEventListener){window.addEventListener('load',sti,false);}else if(window.attachEvent){window.attachEvent('onload',sti);}var _gaq=_gaq||[];_gaq.push(['_setAccount','UA-1270988-1']);_gaq.push(['_trackPageview']);(function(){var ga=document.createElement('script');ga.type='text/javascript';ga.async=true;ga.src=('https:'==document.location.protocol?'https://ssl':'http://www')+'.google-analytics.com/ga.js';var s=document.getElementsByTagName('script')[0];s.parentNode.insertBefore(ga,s);})();
