(C) 2009 - 2014 by Mourad Louha · All rights reserved

All posts tagged Excel

Excel Advent Calendar

Categories: Calendar Templates
Comments: No

Petros Chatzipantazis asked me some days ago, if I was interested to translate his advent calendar to german and to publish it on my blog. I thought the idea for the advent calendar was great, so it took very short time to accept his suggestion. The advent calendar includes quizes from Petros, Chris Macro and me. Each day, you can answer to a question about Excel – some of these questions are relatively easy and others are more difficult. Each author provided some questions. I provided the questions in German. Petros and Chris provided questions in English. Petros also published a post Anticipate Christmas by counting down the days using Excel on his blog. The following screenshot shows the german version for the advent calendar

Advent

The advent calendar is available in two versions. The first version does not need anything else than the activation of macros. You can answer the questions by clicking on the buttons next to the questions, which appear in the ribbon tab “Advent calendar”. And you can select a question by clicking on the day numbers or by using the buttons “Next question” and “Previous question”. However, some of the buttons just only show a message box; for example is you try to choose an author. This is due to the fact, that’s not possible to change the ribbon tab at run time via VBA.

The second version of the advent calendar uses the Ribbon Commander Framework. This framework allows dynamic Ribbon UI development from VBA & .NET and therefore the second version of the advent calendar offers more possibilities. After downloading the framework (which can be freely tested for 30 days), you can download the advent calender from its integrated Add-In-Manager. The framework can be directly downloaded from the source site or you can use the web laucher, which is an Excel-Add-In and does all work for you via Excel.

Advent

In early December 2012, I have released the new websites for the Excel formula translator. The site in a similar design to Excel Ticker is available in German, English, French, Italian and Hungarian and is also part of my planned network of websites focusing on Microsoft Excel.

Excel Formula Translator

The websites provide, in addition to the integration of the online tool, a reference to the translations of all Excel functions from Microsoft Excel. In case where the translation on an Excel function differs from one Excel version to another, these translations are listed separately. And all translations are linked to the Microsoft Online Help in the corresponding language. A few days ago, I did an update and released the websites in Italian and Hungarian.

Many thanks to Roberto Mensa and Krisztina Szabó for supporting and helping me to translate the sites. Roberto is an Excel e VBA enthusiast expert. He is mainly active on Italian online forums and he regularly publishes his work on his sites E90E50 and E90E50fx. Krisztina is the manager of Excel Hero LinkedIn Group and member of the Frankens Team.

If you would like to support us to translate the website into more languages, we welcome your comments here or write us an email to the address mentioned on our imprint page.

 

We are pleased to announce the release of the next version 3.0 of the Excel Soccer – the Soccer World Cup and Championship Planner – on April 23th, 2012.

The new version is a complete redesign and development from scratch, including a new user interface and a new navigation. New internal structures should also contribute to an increase in speed. Additionally, there will be no more single files for each language, but all the translations can be found in the same file. We are planning a short test phase after the release, so that if errors will be found, we can fix them in time before the European Championship. The Add-on tool will be released after the planner.

I have moved all my domains, which are related to the Excel Soccer, to a more performant server. The websites have also been rebuild and reorganized and, we hope so, welcome the visitors with a more modern interface. Please note, that the websites are currently in progress, so there may be some missing content here and there. By the way, I am using a multi-site installation of WordPress for all sites, allowing me a comfortable and flexible management of the templates and plug-ins at a global level, and much more.

In addition to the main domain www.excel-soccer.de for the Excel Soccer, I created a subdomain for each language (German, English and French):

All other domains I used the last years are now redirecting to the domains mentionned before. Although the obsolete domains will remain active for a while, please update your bookmarks and favorites as soon as possible.

Last but not least, I have set up a forum for the Excel Soccer with three subforums for each language. The Excel Soccer Forum – forum.excel-soccer.de serves as primary point of contact for questions, support and help around the Excel Soccer. Please note, that the forums itself also supports the three languages.

Some people who had supported us during the World Cup 2010 have already contacted us and offered their support, for example translations, for the next version. At this point, our big thanks.

This following post is a guest post and was written by Roberto Mensa, Krisztina Szabó and Gábor Madács. Thanks Roberto, Krisztina and Gábor 🙂

A few days ago we were working with the CELL formula to draw your attention to use the English info_type attribute if you share your Excel file with someone how uses Excel with different language setting. The second argument of this formula is the reference, which is optional. If it is omitted, the information is returned for the last cell that was changed, as we can read in the Excel Help.

Dynamic Chart in Excel

It is important to make it clear that “last cell that was changed” relates to the calculation. Change means a kind of change that triggers calculation. So if you manually re-calculate your sheet, the “last cell” will be the active cell where your cursor is positioned. My Hungarian friend Krisztina Szabó gave me an idea to build a dynamic chart based on the active cell. So we made a challenging example. In this article, we would like to show you how you can build up a similar solution based on our tricks. We have provided a sample file, which you can download at the end of this article.

Read more

This article presents my first version of my free Excel Add-In (Version 0.75 Build 151110) for calculating large numbers in Excel. The Add-In (you can download the file at the end of this article) currently implements functions for the addition, subtraction, multiplication and exponentiation of large numbers. The code in the Add-In is password protected; however you can unprotect the VBA project by using the password “excel-ticker” (without the quotes). Please also read the copyright notice and license terms in the last section of this article.

The Add-In is also digitally signed with a certificate which was issued to me by the company “TC TrustCenter GmbH, Germany”. So, only files including this digital signature have been created and published by me.

Currently, the Add-In can only perform calculations with integer numbers, an extension for calculating decimal numbers is in progress. Additionally, the Add-In will later provide more functions, such as the division or calculation of special formulas like “X ^ Y Mod N”. These new functions will use more complex algorithms based on the research from Donald Knuth and derivatives from his algorithms.

Naming conventions of the functions in the Add-In

The Add-In includes the functions described below, which can be accessed, for example, through the category “User defined” of the select function box in Excel. Each function of the Add-In is available in English, German and French.

VBA Large Numbers

Read more

This fourth part of my article series about the calculation of very large numbers in Excel talks about the exponentiation of two large numbers. If we consider the original problem (see my first article) which was the calculation of 80 ^200 in Excel, we will need at least from 80 ^ 160 an own algorithm.

The calculation of 80 ^200 is equivalent to a total of 200 – 1 = 199 times multiplying the number 80 by itself. We already have a function for multiplying large numbers; see my third article. However the large number of multiplications could lead to a performance problem; so we will check if it is possible to reduce this number.

Binary exponentiation

Exponentiation by squaring (or binary exponentiation) is, according to the Wikipedia, a general method for fast computation of large integer powers of a number. This algorithm has already been discovered around 200 BC in India and can be seen as a standard method for reducing the number of multiplication needed for the calculation of the power of an integer value.

VBA Large Numbers

Read more