Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Conversion Functions (Excel 2000 >)

    Hi all;

    I recently compiled a list of conversion formulas and spent a little time creating some Excel Functions from them. After setting up the functions, I saved the file as an attachment. If you have the need to enhance Excels function capabilities, feel free to copy the Add-In attachment and save it to your hard drive!

    Installing add-ins on your computer:
    Before you can use an add-in, you must first install it on your computer and then load it into Excel. Add-ins (*.xla files) are installed by default in one of the following places:

    1. The Documents and Settings/<user name>/Application Data/Microsoft/AddIns folder.
    2. The Library folder or one of its subfolders in the Microsoft Office/Office folder.

    Loading add-ins into Excel:
    After installing an add-in in the above folder, you must load it into Excel. Loading an add-in makes the feature available in Excel and adds any associated commands to the appropriate menus. To do this go to the TOOLS MENU and click on Add-Ins. Check the Conversion Functions checkbox. This will activate the Add-In and install the conversion functions into the Information Category of the Insert Function Dialog Box.

    I hope these functions can be of use to you. If you have more conversions, feel free to let me know and we can upgrade the Add-In as needed!

    Cheers
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Functions (Excel 2000 >)

    You add-in contains a number of specific conversions that will come in handy for people who need them.

    Did you know that the Analysis ToolPak add-in that comes with Excel contains a worksheet function CONVERT?
    For example, <code>=CONVERT(120,"mm","in")</code> will convert 120 millimeters to inches.
    And <code>=Convert(68,"F","C")</code> will convert 68 degrees Fahrenheit to degrees Celsius (not Celcius)

    The CONVERT function generally uses more precise conversion constants than your add-in. However, it is not very convenient for compound units such as PSI, that's much easier with your add-in.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Well, that is a new one. I've never encountered the CONVERT function. Thanx for sharing that! I'm gonna play around with that to see what its capabilities are!
    CHEERS
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    So that explains <post#=493,540>post 493,540</post: >

    Anyway, nice touch. Safely stored away for future use when I need to work out density of my database <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Jerry

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Yeah, it was the beginnings of a long and arduous conversions trip!!

    I feel quite converted myself too!!! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Regards,
    Rudi

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion Functions (Excel 2000 >)

    Rudi

    Thanks for making your add-in available. If you're after more ammunition, you might want to check out joshmadison's convert, which is handy <img src=/S/free.gif border=0 alt=free width=30 height=15>ware standalone program in its own right. Myself, I've been working on a project for the building industry, with some of the most obscure units I've encountered since cubits and pecks. Some of them are driving me nuts <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>.

    Alan

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Pleasure Alan.

    Cheers for the link....Though I doubt I'll need more than what I put into the Add-In...its handy to know of freeware programs that can give more info too!
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  8. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Hi Rudi

    I installed you conversion function, put it in both the places you advised now excel will not open without an error I click on debug and this line of the function is highlighted

    Application.MacroOptions Macro:="Cv_EP_Rating", Category:=9

    1. The Documents and Settings/<user name>/Application Data/Microsoft/AddIns folder.
    2. The Library folder or one of its subfolders in the Microsoft Office/Office folder.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Functions (Excel 2000 >)

    You need only install the .xla in the first location, not in both.

    Rudi doesn't seem to be online today, so I took the liberty to create a slightly modified version based on an article by Laurent Longre. It assigns the functions to a custom category "Conversion functions". I didn't bother putting in elaborate descriptions, I'll leave that for Rudi.

    Unzip the .xla from the attachment to this post into your Cocuments and Settings<user name>Application DataMicrosoftAddIns folder.

    Tip for Rudi: download and install Longre's free Funcustomize add-in. See Excel add-ins.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Hans That is a gem of a link. That could be a nice star post as I sometimes see other Loungers asking about add-ins.
    Jerry

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Functions (Excel 2000 >)

    The site has been mentioned before in this forum. It is really worth a visit - I recommend the Morefunc add-in, very useful functions.

  12. #12
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Playing with it as we speak
    Jerry

  13. #13
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    Hi Hans

    I removed Rudi's Function and then loaded the one you supplied, but I still get this error, I would add that this error only appears if I have the function loaded, If I remove it
    everything is OK

    Braddy
    If you are a fool at forty, you will always be a fool

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conversion Functions (Excel 2000 >)

    Braddy,

    First, clear the check box for the Conversion Functions add-in in Tools | Add-Ins...
    Quit Excel.
    Now, delete ALL instances of Conversion Functions.xla from you hard disk.
    To be on the safe side, download the zip file from my previous reply anew.
    Copy the .xla from the zip file to your Cocuments and Settings...AddIns folder.
    Start Excel.
    Select Tools | Add-Ins...
    Tick the check box for Conversion Functions.
    Click OK
    Quit and restart Excel. The problem shouldn't occur now.

  15. #15
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conversion Functions (Excel 2000 >)

    HI Hans

    That worked fine, everything now OK.

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •