INSEDE
Institute for Sustainable
Economic Development
Beyond (classic) BI cockpits - prerelease bengin 
     

Want to show the relationship between monetary and nonmonetary indicators and values?
(or the relationship between monetary and monetary or even nonmonetary and nonmonetary indicators)
This is the solution: kpisquare and Vektor Profiles.

On this page you will find different templates for Excel vector profiles for download.
Click on the picture shows the large version and click on the link on the right side of the picture downloads the Excel file(....xlsx).

The templates are unprotected and free from macros/VBA.
You may use it free for your personal and noncommercial use. See Creative Commons License below.

Tips/Recommendations:

  10_one "Pure 10 vectors"
Comparison of 10 clusters - for example, divisions, countries, projects, cost centers..... - among themselves and within the overall context.

10_vect_add_one_001_e
10_one_frame 10 Vectors with frames. These frames facilitate untrained observer the orientation.

10_vect_add_one_frame_001_e
 
           
  10_two Similar to "Pure 10 vectors" but with a second record.
This allows the simultaneous display of budget and account - or two periods or.....

10_vect_add_two_001_e
10_sep 10 cluster starting x=0 and y=0 (without addition) with sumvector.

10_vect_sep_001_e
 
            
  04_one 4 clusters and vectors with underlying colored background.
Easier for novices to see the interdependences.

04_vect_add_one_box1_001_e
10_one_box1 "Backed 10 vectors"
Similar to "Pure 10" - 10 clusters and vectors with underlying colored background.
Easier for novices to see the interdependences.

10_vect_add_one_box1_001_e
 
           
  10_ort_one Ortscurve / Valuetrack

Connects several 2d-Milestones - for example, nine years track of milestones in an enterprise.....

10_vect_ort_one_nine_001_e
10_ort_three Three Ortskurves / Valuetracks

Example for tracking 3 Enterprises.... or customers... or competitors... or....
three periods.

10_vect_ort_three_three_001_e
 
           
10_one_box3 Similar to "Backed 10 vectors" above

The y=values of the clusters have three parameters.

Sample "Product cost":
Parameter 1 = cost of production
Parameter 2 = cost of R & D
Parameter 3 = cost of marketing

10_vect_add_one_box3_001_e
01_pyt This visualization discloses the solution to establish a quantitative solution for an objective use value.
The basics of the formula follows the principle of pythagoras.

01_vect_pyt_one_001_e
 
Legale notes:
Pictures are proprietary and part of "Business Engineering Systems" (Registered Copyright TXu512154).
Private use is permitted without license - derivative works and commercial use requires registered license (enduser, consultant, education, software...).

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Questions / feedback / what's in the pipeline?

It's not easy to see the difficulties people who are not familiar with Excel would have to modify the charts to their needs.
Therefore you may send your possible questions (problems with downloads, additional links, special excel manual, license rules....?) to
peter.bretscher@bengin.com
So we can modify this page in that it better fits your needs.

Peter Bretscher, Ingenieurbüro für Wirtschaftsentwicklung, Alpsteinstrasse 4, 9034 Eggersriet, Switzerland
Mobile: ++41 79 650 49 04
Google+ https://plus.google.com/107048744275438760860/

© 2012, Peter Bretscher, peter.bretscher@bengin.com - www.bengin.net - www.insede.org
Ingenieurbüro für Wirtschaftsentwicklung, Alpsteinstrasse 4, CH-9034 Eggersriet, Switzerland