There is a high degree of inconsistency in the translation of the new functions regarding dynamic arrays (will you use dynamiske matrixer or dynamiske matricer in Danish?) in Excel.
I know they currently are only available in Beta/Insiders Program but IMHO they need to be addressed before publishing (shown as UK (DK)):
FILTER (FILTER)
I think the function should be named FILTRER in Danish.
UNIQUE (UNIK)
I think the function should be named either 1) UNIKKE (primary suggestion) or 2) ENTYDIGE (secondary suggestion).
I’m aware of the use of entydige for unique in Power Query and actually suggest the use of unikke in all cases within Excel and Power Query (PBI/XL) because that is the common data term ie. in SQL etc.
Be aware, that the online article names the function ENTYDIGE but shows the UNIK function in the screenshots.
SORT (SORTÉR)
This is the first time I see an accented function name in Excel and strongly suggest that you change this to SORTER (without the accent).
SORTBY (SORTER.EFTER)
This name is actually good, but the online article shows a screenshot with SORTÉR.EFTER (accented) and is kind of strange “translated” in the article like in “Menuen Sorter efter function” and “Funktionen menuen sorter efter”. Rubbish.
SEQENCE (SEKVENS)
Works like a charm. No changes needed.
The online article needs review.
SINGLE (ENKEL)
This function should be named ENKELT like in the online article (and not like the screenshots). A single value translates to “en enkelt værdi” and not “en enkel værdi”.
The online article refers to ENKEL, ENKELT and SINGLE in random order.
Maybe you could just use SINGLE since that is a valid and approved Danish term for a single value – like in singlesculler, singlekultur (but can also mean being single).
RANDARRAY (VILKÅRLIG.MATRIX)
Since RAND and RANDBETWEEN are translated to SLUMP and SLUMPMELLEM I think this function should be translated to SLUMPMATRIX to be consistent with the two other randomizing functions.
Be aware, that the name of the function has not been translated but mentions the correct Danish SLUMP function several times and that makes it even more relevant that you change VILKÅRLIG to SLUMP. Since SLUMPMELLEM is without punctuation I also think that SLUMPMATRIX should be without.
Note
You also have to define the term of the spilled range operator (#) – if you read the online article, it is talking about watertight areas and spilled fluids etc. *LOL*
Inside Excel, it is called “overløb” which actually is a nice term. But it has absolutely nothing to do with water, fluids and watertight areas! The error code #SPILL! should be translated to #OVERLØB!
MT does NOT work in your favor. All the online articles needs human interaction. It is impossible for me to mention all the mistakes in the articles. There are too many.
Regards,
Jørgen
