Page 1 of 5 1 2 3 ... LastLast
Results 1 to 10 of 49

Thread: Online Excel Formula Translator to other languages

  1. #1

    Online Excel Formula Translator to other languages



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there...

    I have published my first version of my free online tool at http://translator.excel-ticker.de for translating single and especially combined Excel 2010 (or lower) Formulas to another language. Currently the tool supports English, German and French.

    The main reason for me to implement the tool in PHP was, that I am also active in English speaking forums and when trying out posted formulas, in many cases, I have to firstly change my Excel language, inserting the formula in a sheet, save it and then switch back to German. I thought, it's a complicated way for just one formula, especially if the formula is more complex and retyping it, is some 'work'. Also, I experienced sometimes that a user has, for example, only a french version of Excel and wants to post a formula to a german speaking forum and a translation of the formula is not possible on the fly.

    I am currently adding more languages to the tool. Then I am planning to create a widget or something similar for use and/or embed in forums or blogs.

    But before realize my plans, I would be thankful, if you can give me a feedback to the ideas and tell me if such a tool can be useful for you. Thanks in advance.

    Regards :-)

  2. #2
    I think it would be better if the input and output boxes were separate, so you can still see your original formula. You could then switch target from say Deutsch to Francais without changing the target language, which would be better.

  3. #3
    Also, in the English text, your eaxmples should be delimited by comma not semi-colons.

  4. #4
    Hi Bob...

    much thanks for your suggestions and feedback :-)

    Yes, I think, you are right, may be better to have 2 boxes for the formulas. Will be implemented.

    Regards :-)

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    Yes, those commas are an issue for those of us in North America. (Not sure where else may suffer that.) When I translate the following:
    =ROUND(MIN((SUM($F54:G54)-$C$10*COUNTA($F9:G9)/12)*$C$12*$C$13,$C$14)-SUM($E56:F56),2)

    I get this:
    =RUNDEN(MIN((SUMME($F54:G54)-$C$10*ANZAHL2($F9:G9)/12)*$C$12*$C$13,$C$14)-SUMME($E56:F56),2)

    I'm guessing that it should be:
    =RUNDEN(MIN((SUMME($F54:G54)-$C$10*ANZAHL2($F9:G9)/12)*$C$12*$C$13;$C$14)-SUMME($E56:F56);2)

    Awesome tool though... I can see where that would be very helpful.

    (Also agree with Bob's suggestion about two windows.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Not necessarily Ken. I don't think you have semi-colons JUST because it is German or French, it is more to do with the international settings (of course, the international settings for France and Germany would default to semi-colons, but can be changed). Having said that though, I think it makes sense to change to the expected defaults, but I guess that makes it that much harder.

  7. #7
    What about months that are spelt out, such as

    =SUMPRODUCT(--(TEXT(A1:A20="mmmm")="February"))

    =SUMPRODUCT(--(TEXT(A1:A20="mmm")="Feb"))

    And whilst we are at it, what about

    =TEXT(A2,"dd")

    In French that would be

    =TEXTE(A1,"jj")

    and in German

    =TEXT(A1,"tt")
    Last edited by Bob Phillips; 2011-08-23 at 05:58 PM.

  8. #8
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    Fair enough. My experience is pretty limited with foreign language translation in Excel. I guess the people I've helped have either been able to work with what I've given, or translated it on their own.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  9. #9
    You mean that you haven't read that chapter in PED?

  10. #10
    Hi Ken, Hi Bob...

    Ken, much thanks your feedback too :-)

    Yes, the tool does not currently convert the commas to semi-colons and as Bob said, it depends on the system's settings. I changed my Excel language to EN and still have semicolons on my Windows 7 DE system. And I tried the same on my Windows 7 VM in English to change the Excel language to German and the have the commas instead of semicolons (=WENN(B1<>1,"Hello World","Ok"))

    I think, Bobs suggestion to set it per default would be a way and will surely apply to most systems but not to all. I can create an option, setted by default, and let the user decide by himself. The problem when converting the commas to semicolons will be to not replace the commas included in static text. PHP however offers powerful functions to find regular expressions; however I must teach myself a little bit in RegExpr..

    So, my next steps will be adding more languages, primarly languages with a latin charset. Then change the formula boxes as suggested by Bob and try some replacements for the commas and semicolons. And when I am ready, I'll post here an update.

    Update: I have been writing while yu have posted. Months who are spelt out can be replaced; concerning the formats, hmm, I must think about it. But it's on my list now :-)

    Regards :-)
    Last edited by maninweb; 2011-08-23 at 06:14 PM.

Page 1 of 5 1 2 3 ... 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
  •