AnsweredAssumed Answered

vrf vrf- Numbers (1-201etc) to Excel like cell A,B,C...AA etc. ?

Question asked by VRFuser on Apr 8, 2004
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><TITLE>Re: [vrf]- Numbers (1-201etc) to Excel like cell A,B,C...AA etc. ?</TITLE><META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD><BODY><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=690254621-08042004>Ah yes, table lookup, usually a good idea for small sets of data. I like it for this use.</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=690254621-08042004></SPAN></FONT> </DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=690254621-08042004>Thanks Bruno,</SPAN></FONT></DIV><DIV> </DIV><P><FONT size=2>Scott Bayes<BR>Software Technical Support<BR><BR>Agilent Technologies, Inc.<BR>815 14th Street S.W.<BR>Loveland, CO, U.S.A. 80537<BR><BR>970 679 3799 Tel<BR>970 635 6867 Fax</FONT> </P><BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Beliveau, Bruno   [mailto:BrunoBeliveau@solectron.com]<BR><B>Sent:</B> Thursday, April 08, 2004   3:22 PM<BR><B>To:</B> VRF<BR><B>Cc:</B> VRF<BR><B>Subject:</B> [vrf] Re:   [vrf]- Numbers (1-201etc) to Excel like cell A,B,C...AA etc.   ?<BR><BR></FONT></DIV>  <P><FONT size=2>Just trying to simplify the calculations every time a column   number is needed...</FONT> </P>  <P><FONT size=2>-----Message d'origine-----</FONT> <BR><FONT size=2>De:   BAYES,SCOTT (A-Loveland,ex1) [<A   href="mailto:scott_bayes@agilent.com">mailto:scott_bayes@agilent.com</A>]</FONT>   <BR><FONT size=2>Date: 8 avril 2004 14:40</FONT> </P>  <P><FONT size=2>Hi Detlef and other vrf-ers,</FONT> </P>  <P><FONT size=2>I did the forward direction (numeric to alpha) during lunch,   attached. Extra outputs are for debugging, could/should use local variables   instead. I was too lazy to do the reverse direction.</FONT></P>  <P><FONT size=2>Someone (Warren?) recently mentioned putting stuff into UFs,   even if it's pretty simple. I agree. Even the little one-boxer that does the   work in my example probably should be put into a UF so it can be called from   multiple places but maintained only in one place.</FONT></P>  <P><FONT size=2>For example, this code will fail if the input number >=   256*26. To fix that you might want to add a third digit & character TD   & TC so you can generate AAA, AAB, etc, or maybe fire an error pin. You   might even rewrite completely to generalize the number of characters it can   handle. If it's in a UF, it becomes relatively easy to change and maintain. If   it were scattered through your application as formulas or UOs, these changes   would be harder to locate and coordinate without error.</FONT></P>  <P><FONT size=2>End of sermon.</FONT> </P><BR>  <P><FONT size=2>> -----Original Message-----</FONT> <BR><FONT size=2>>   From: Baranski, Detlef [<A   href="mailto:Detlef.Baranski@PILKINGTON.de">mailto:Detlef.Baranski@PILKINGTON.de</A>]</FONT>   <BR><FONT size=2>> Sent: Thursday, April 08, 2004 8:34 AM</FONT> <BR><FONT   size=2>> </FONT><BR><FONT size=2>> Does someone has a nice functions in   Vee availble to </FONT><BR><FONT size=2>> transform the numbers</FONT>   <BR><FONT size=2>> 1-256 into Excel - Cell formats A,B,C ...AA,AB, AC   etc.  ? </FONT><BR><FONT size=2>> And maybe vice</FONT> <BR><FONT   size=2>> versa ?</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>>   Or is there an excel function to do so ?</FONT> <BR><FONT size=2>>   </FONT><BR><FONT size=2>> Thanks for any help,</FONT> <BR><FONT size=2>>   detlef</FONT> </P>  <P><FONT face=Arial color=#000000 size=2></FONT> </P></BLOCKQUOTE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>  

Outcomes