Essence of the instrument panel.
The instructions of use are developed in this book.
The examples were tested under Microsoft Excel 2000,2003 and 2007 on CP (Windows 98, Windows XP).
Regulate your security level in “weak” position (finely “Tool” “Macro” “Security”).
Use the function “display” and “zoom” to adjust the display size as well as possible.
These programs are free of use. The user can recover them, amend them and especially to supplement them at will (in particular to add the routines of management of errors). Whatever of it is the use, the author does not guarantee in any manner operation. These programs are provided only as examples and must be considered thus.
The programs are intentionally simple.
The use of each program is described in the book “the Essence of the instrument panel”.
By precautions, and data processing being what it is, use a “neutral” post for your tests. A “neutral” post is a CP which contains neither of the important data nor of the essential programs and whose operation is not critical for the firm.
In the event of problems make you assist of a Microsoft Excel competence.
Downloading
- You read the use cautions? Then you fit with the book and click here.
- You do not have the book under the hand? Thus click on this button: Download
(From this link, you will reach the page of downloading.
It will be asked to you to seize a code that you will obtain from a simple phone call. This appeal is directly invoiced 1,80 on your note calls. The totality of the documents and tools forwarded here will be then accessible. The code is valid until midnight.
Note: your navigator must accept the “cookies”.)
Files and tools available in downloading
Models of cards
The models of cards are with the format and directly usable.
|
| Model 1: The model of a complete questionnaire-customer (40 questions to determine the point seen customer) |
| Model 2: A standard example of Card-share |
| Model 3: A standard example of Card-indicator |
|
Practical cards
All the cards with the format are provided with the sources and directly usable. |
| Card practices 2: Use the formulas and functions |
| Card practices 3: Produce an indicator sight-meter |
| Card practices 5: Reach the sights of detail |
| Card practices 6: Use the graphs with knowledge |
| Card practices 7: Exploit the tools for cartography |
| Card practices 8: Use the scenarios |
| Card practices 9: Use the |
| Card practices 10: Extract the maximum of the dynamic boards |
| Card practices 11: Automate the board |
| Card practices 12a: Produce an indicator “fire tricolor” in VBA |
| Card practices 12b: Produce an indicator “measures” in VBA |
| Card practices 12c: Produce an indicator “measures” standard 2 in VBA |
| Card practices 13: Reach a Database external |
|
How to produce indicators like:
or the complete board below?
It is the subject of these practical cards…
The instrument panel of
| The instrument panel of entire book and reusable to the format |
| The complete dashboard of society with all the source programs |
|
