Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Duluth, Minnesota, USA
    Posts
    215
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Template for international spreadsheet? (Excel 2K SR-1)

    Oh Great and Powerful Gurus, I have a question.

    I have a spreadsheet that is used in the US, the EU, and in Asia. Currently, I am trying to maintain versions for each language, currency type, and unit system. Needless to say, it is a task to keep track of revision levels across such a system. I would like to find a way to maintain one master that would then disperse across all of the custom spreadsheets. How possible would this be?

    I think that the structure would have to be the same across all versions. The text describing the contents of the data cells would be in different languages. I do not see how I could have just one set of formulas because of the various factors used in formulas having to do with currency calculations and units (such as US vs British vs metric).

    Has anyone out there attempted to do this sort of thing in the past?

    All suggestions welcome.

    TIA, Douglas

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

    Re: Template for international spreadsheet? (Excel 2K SR-1)

    You could create a "core" of language/country-independent worksheets (probably hidden), worksheets with local conversion factors (hidden too), and a "shell" of language/dependent input and output (visible).

    Example: you want to input or output the volume of something. Internally, all lengths are stored in cubic meters, but users enter the volume in US Gallons or UK Gallons or Liters, depending on their location.
    The conversion sheet contains the factor needed to convert from gallons or liters to cubic meters (and back).

    You could keep multiple conversion sheets in the workbook, and one "current" conversion sheet. To switch between systems, just copy the appropriate conversion sheet to the current one.

Posting Permissions

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