Excel application

Auteur:
Henk Hietbrink
An Excel application has been developed to generate and verify muqarnas designs. It performs an in-depth 3D analysis of the structure of muqarnas and generates drawings, tables and statistics for any muqarnas. Input is a series of coded strings. The software interprets these strings using the geometrical definitions of a collection of muqarnas units. For the software, a muqarnas is a collection of strings of letters, where each letter represents a unit. The letters A to F have been chosen for the top row of units with rear wall and the letters G to L for the bottom row of intermediate units without rear wall. One of the aims is to identify for each unit its neighbours (left, right, above, and below) and to detect missing neighbours and other inconsistencies. During my inquiries, I found out that I needed more, dedicated units for special purposes, for example at the end of a layer or in the middle of a layer to gain extra height. These new units are often half the size of a standard unit, but can also be something surprisingly new. These units are also coded. For example, the codes A1 and A2 represent the left and right half of the blue square building block that got the letter A. An example of a new building block is the flat wall, coded with the letter Z. The software accepts all triangular and quadrangular shapes.
[size=100]This is an example of the input of the Excel application. Fours rows with strings of letters referring to the coding of the muqarnas building units.[/size]
This is an example of the input of the Excel application. Fours rows with strings of letters referring to the coding of the muqarnas building units.
[size=100]These are the fourteen basic building units. For coding purposes, they are labeled from A to N. Usage of different colors is a way to improve the readability of a design. Occasionally, one may need rare building units. More often, one may need half building units, for example half of large biped J.[/size]
These are the fourteen basic building units. For coding purposes, they are labeled from A to N. Usage of different colors is a way to improve the readability of a design. Occasionally, one may need rare building units. More often, one may need half building units, for example half of large biped J.
[size=100]This is an example of the output of part of the the Excel application. The left table is a listing of the number of objects used. The right table shows the relationships between neighbouring objects. Not shown are the where-used lists.[/size]
This is an example of the output of part of the the Excel application. The left table is a listing of the number of objects used. The right table shows the relationships between neighbouring objects. Not shown are the where-used lists.
[size=100]Graphical output is a 2D plan of the muqarnas. Another tool has been developed in GeoGebra to generate 3D animations.[/size]
Graphical output is a 2D plan of the muqarnas. Another tool has been developed in GeoGebra to generate 3D animations.
[size=100]The application checks the design. It recognizes when layers do not match,[/size]
The application checks the design. It recognizes when layers do not match,

Nieuw didactisch materiaal

Ontdek materiaal

Ontdek onderwerpen