The Geek House
Posts tagged build
Arrow charts in Excel
03 years ago
by valerashylin
in VBA
Hi,
Today we would like to present you another solution that we started to use in our company. This is a tool for automatically building ARROW CHARTS!
After spending some time searching for ideas or similar tools in the Internet we found nothing that would perfectly fit our needs, thus, we created our own solution. 
To make the story short, this is how it works:
The tool works with a 4-column table of data where each row starts with a name of the series. An XY chart will be created (or you may use any already created XY chart). Only four columns after the title column are considered. The tool will use the first 2 data columns to put the point and the arrow from the second point will point to the first one. (I hope I made myself clear…)
The current version does not work correctly in Excel 2007. In fact, it works perfectly well in Excel 2003. So, make sure you updated your MS Office software. Since this is our tool for internal use, we did not test it on Office 2002 and Office 2000.
Soon we will introduce the support for Office 2007.
This tool can become very useful for the companies which conduct marketing research and need to build dozens of arrow charts. Since Excel does not provide tools for doing that automatically the work is typically done manually. From now on we make Excel do it for us!!!
Feel free to contact us with any questions, suggestions and ideas about this topic.
Traditionally, you can find this solution on our web site www.yRiver.it
(ArrowCharts.exee [the file you download is a self-extracting archive; change its extension from .exee to .exe])
where in the category OUR PROJECTS
you can also find other projects, solutions, ideas and concepts.
Charts in Excel automatically
03 years ago
Hi,
today we will present you one more small solution to simplify your life in working with Excel. This is an Excel add-in that will enable you to build charts based on one selected.
Let me explain its use on an example. Assume that you have a huge table of data (say, some 50 000 rows). When you decide to build a chart based on this table of data you will probably want to build one chart per one row since it is the only feasible way of presenting data graphically in such a case. If you decide to do that manually (even if you totally need “only”, say, 100 charts) it will take A LOT of time!
So, this add-in will help you create charts based on the selected range of rows. You have to define the template chart.
The current implementation allows you to build charts with only one series. Though, the number of series could be expanded on demand.
Below you can see the video demonstration of how it actually works:
You can freely download the add-in from our web-site www.yRiver.it
(AutomaticCharts.zip)
which is actually located in the category OUR PROJECTS
where you will find other projects, solutions, ideas and concepts.
Kraljic matrix and Kraljic diagram in Excel
33 years ago
by valerashylin
in VBA
Hi,
here we would like to present a solution in Excel that implements a Kraljic matrix and builds a Kraljic diagram. Profound information about Kraljic matrix can be found in wikipedia, but speaking generally it is a tool for the evaluation of strategic importance of some entities for the company. Usually, they are company’s suppliers.
The system actually represents a questionnaire by means of which strategic importance of car components is evaluated. It is semi-automatized, provides intuitive interface and allows easy answering the questionnaire questions.
The developed system was a part of a university project for the evaluation of the strategic importance of Alfa Romeo suppliers by means of a questionnaire applied to the components of a chosen car model. Since it was a one-time project, it was created within one night in order not to spend much time on the development phase but to concentrate on the implementation one. That is why the system is semi-automatized: it does not allow you to “easily” create the questionnaire which is its only problem. Therefore, the usability can still be improved.
The file Excel consists of 3 sheets: one containing component names, another containing the questionnaire with questions, answers, answer weights, and the last one the actual Kraljic matrix and the Kraljic diagram.
From the managerial point of view the biggest difficulty of the system is a good balance of the questionnaire. It is highly recommended to think thoroughly every single question, its answers and (which is of key importance) their weights (numeric values). It is also required that highly competent persons or better groups of persons answer the questionnaire that can contain questions related to both specific technical and marketing areas.
Below you can see a video presentation of the Kraljic matix in Excel:
You can freely download the solution from our web-site www.yRiver.it
(Alfa_Romeo_Kraljic_matrix.zip)
which is actually located in the category OUR PROJECTS
where you will find other projects, solutions, ideas and concepts. 
