Frequently Asked Questions (FAQ) about The Create Time Dimension App.
The app data creation is currently available in the following languages:
If you would like to contribute a translation for another language, please send me the following information:
Language name in both English and local
Example: Swedish, Svenska
Header translations for all table headers in the created table.
Example: ‘id’, ‘DateId’, ‘Date’, ‘Local Date String’, ‘Year’, ‘Month’, ‘Day’, ‘Month Name’, ‘Month Name (Short)’, ‘Weekday’, ‘Weekday (Short)’, ‘Day of Week’, ‘Quarter’, ‘Quarter (format)’, ‘Day Of Year’, ‘Week Number’, ‘Week Number (Format)’
Localized names for all months and day names etc in both full and short form. Also, please indicate if the list starts on Sunday or Monday.
Example: Weekday names full: ‘Sunday’, ‘Monday’, ‘Tuesday’, ‘Wednesday’, ‘Thursday’, ‘Friday’, ‘Saturday’
Month names short: ‘Jan’, ‘Feb’, ‘Mrt’, ‘Apr’, ‘Mei’, ‘Jun’, ‘Jul’, ‘Aug’, ‘Sep’, ‘Okt’, ‘Nov’, ‘Dec’
Please send them to me on email stefan at this domain or contact me on any of the social networks linked on the home page. Also, please indicate your web site and Twitter handle etc and I will credit your work.
Recap, please send:
- Language Name
- Header column names
- Weekday names long
- Weekday names short
- Month names long
- Month names short
About Excel 2013 and PowerPivot
This app is available for Excel 2013 but the table it creates is most useful when analyzing data in PowerPivot. PowerPivot is currently only supported in Excel 2013 as part of the Microsoft Office Professional Plus offering. It is not available in Office for Windows RT such as on the Microsoft Surface. PowerPivot is built into Excel but the user interface that was standard in 2010 is not enabled by default.
Note that you dont actually have to enable the UI unless you want to use it, or perhaps are used to the interaction model from Excel 2010.
Something looks wonky in the app window