{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AxisVM","Toelichting"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AxisVM","index":0,"n_rows":57,"n_cols":36,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[null,null,null,"Project:","VBA in EXCEL",null,null,null,null,"Versie:",null,"1.00"]
[null,null,null,"Onderdeel:","XL en AxisVM"]
[null,null,null,"Datum:","2021-04-21",null,null,null,null,null,null,"Klik het logo"]
[]
[]
[]
[]
["I","MODEL",null,"start = klik op logo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULTATEN ANALYSE"]
[null,"Nr Velden","=",9,"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AXISVM BESTAND: C:\\Users\\Documents\\XL2AXIS_test"]
[null,"NR Bouwlagen","=",4,"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERPLAATSINGEN KNOPEN (3 BELASTINGSITUATIES)"]
[null,"DX veldlengte","=",1,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR","dx DL","dz DL","dx LL","dz LL","dx LC","dz LC"]
[null,"DZ hoogte bouwlaag","=",1.2,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"0,000","-0,003","0,002","0,002","0,002","-0,001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-0,001","-0,016","0,474","0,009","0,473","-0,007"]
["I","BELASTINGEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"0,000","-0,024","0,639","0,010","0,639","-0,014"]
[null,"Rustende belasting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"0,001","-0,028","0,718","0,011","0,719","-0,017"]
[null,"   Q-vloer","=",-5.35,"kN/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"0,000","-0,005","0,001","-0,001","0,001","-0,006"]
[null,"   Q-Dak","=",-4.0999999999999996,"kN/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"0,000","-0,026","0,471","-0,005","0,471","-0,031"]
[null,"Veranderlijke belasting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"0,000","-0,039","0,635","-0,007","0,635","-0,046"]
[null,"   Q-vloer","=",-1.75,"kN/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"0,000","-0,045","0,714","-0,008","0,715","-0,053"]
[null,"   Q-Dak","=",-1,"kN/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"0,000","-0,005","0,001","-0,001","0,001","-0,006"]
[null,"   Fx,wind (knoop 2,3,4)","=",10,"kN ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"0,000","-0,026","0,469","-0,004","0,469","-0,030"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"0,000","-0,039","0,633","-0,007","0,633","-0,046"]
["R","MODEL MAAT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"0,000","-0,045","0,712","-0,008","0,711","-0,053"]
[null,"Aantal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"0,000","-0,003","0,001","-0,003","0,001","-0,006"]
[null,"Knopen","=",{"$f":"(D10+1)*(D11+1)","v":50},"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"0,001","-0,016","0,467","-0,014","0,468","-0,030"]
[null,"Staven","=",{"$f":"(D10*D11)+(D11*(D10+1))","v":76},"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"0,000","-0,024","0,632","-0,018","0,632","-0,042"]
[null,"Staven kolom","=",{"$f":"D11*(D10+1)","v":40},"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"-0,001","-0,028","0,711","-0,020","0,710","-0,047"]
[null,"Staven vloer","=",{"$f":"(D11-1)*D10","v":27},"stuks",null,null,"Basisopzet van de geometrie van de constructie in dit XL-voorbeeld",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERPLAATSINGEN STAAF (1 BELASTINGSITUATIE)"]
[null,"Staven dak","=",{"$f":"1*D10","v":9},"stuks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staaf: 1 (Belastingcombinatie 4)"]
[null,"Breedte (x-as)","=",{"$f":"D10*D12","v":9},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR","Pos","dx","dz"]
[null,"Hoogte   (z-as)","=",{"$f":"D11*D13","v":4.8},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"0,00","0,002","-0,002"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"0,20","0,093","-0,003"]
["R","GENEREER HET MODEL",null,null,null,null,"GENEREER AXISVM MODEL",null,null,null,null,"VERZAMEL MODEL INFORMATIE ",null,null,null,null,"VERZAMEL RESULTATEN ANALYSE",null,null,null,null,null,3,"0,40","0,182","-0,003"]
[1,"MATERIAAL",":","-",null,null,"MATERIAAL",":","OK",null,null,"LENGTE STAVEN",":","OK",null,null,"DISPL NODE",":","OK",null,null,null,4,"0,60","0,269","-0,004"]
[2,"PROFIEL",":","-",null,null,"PROFIEL",":","OK",null,null,"COORD KNOPEN",":","OK",null,null,"DISPL BEAM",":","OK",null,null,null,5,"0,80","0,352","-0,005"]
[3,"KNOPEN",":","OK",null,null,"KNOPEN",":","OK",null,null,"NUL STAVEN",":",0,null,null,"dZ KNOPEN",":","0,719","mm",null,null,6,"1,00","0,430","-0,005"]
[4,"STAVEN",":","OK",null,null,"STAVEN",":","OK",null,null,"(x;z)min",":","0,000 ; 0,000","m",null,"dX KNOPEN",":","0,053","mm",null,null,7,"1,20","0,503","-0,006"]
[5,"STEUNPUNTEN",":","OK",null,null,"STEUNPUNTEN",":","OK",null,null,"(x;z)max",":","6,000 ; 6,000","m",null,"FORCES BEAM",":","OK",null,null,null,8,"1,40","0,568","-0,007"]
[6,"BELASTING GROEP",":","-",null,null,"BELASTING GROEP",":","OK",null,null,"Lstaven",":",42000,"m",null,null,null,null,null,null,null,9,"1,60","0,625","-0,007"]
[7,"BELASTING GEVAL",":","-",null,null,"BELASTING GEVAL",":","OK",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"1,80","0,673","-0,008"]
[8,"BELASTING COMB",":","-",null,null,"BELASTING COMB",":","OK",null,null,"AXIS-BESTAND",":","C:\\Users\\Documents\\XL2AXIS_test",null,null,null,null,null,null,null,null,11,"2,00","0,710","-0,009"]
[9,"BELASTING EG",":","-",null,null,"BELASTING EG",":","OK",null,null,"TIME BESTAND",":","22-04-2021 _ 08:50:20",null,null,null,null,null,null,null,null,"SNEDEKRACHTEN STAAF (1 BELASTINGSITUATIE)"]
[10,"BELASTING RB",":","OK",null,null,"BELASTING RB",":","OK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staaf: 1 (Belastingcombinatie 4)"]
[11,"BELASTING VB_Q",":","OK",null,null,"BELASTING VB_Q",":","OK",null,null,null,null,null,null,null,null,null,null,null,null,null,"NR","Pos","Nx","Vz","My"]
[12,"BELASTING VB_F",":","OK",null,null,"BELASTING VB_F",":","OK",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"0,00",-17521,9330,"0,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"0,20",-17079,9330,1866]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"0,40",-16636,9330,3732]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"0,60",-16194,9330,5598]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"0,80",-15751,9330,7464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"1,00",-15309,9330,9330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"1,20",-14866,9330,11196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"1,40",-14423,9330,13061]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"1,60",-13981,9330,14927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"1,80",-13538,9330,16793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"2,00",-13096,9330,18659]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END RESULTS"]

{"sheet":"Toelichting","index":1,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project:",{"$f":"Projectnaam","v":"VBA in EXCEL"},null,null,null,null,"Versie:",null,{"$f":"Versie","v":"1.00"}]
[null,null,null,"Onderdeel:",{"$f":"Onderdeel","v":"XL en AxisVM"}]
[null,null,null,"Datum:",{"$f":"Datum","v":"2021-04-21"}]
[]
[]
[null,"Toelichting"]
[]
[null,"In dit XL-bestand is een VBA-project opgenomen. De VBA applicatie wordt opgestart met een klik op het VA-logo (alleen op werkblad \"AxisVM\")."]
[null,"Dit is een voorbeeld hoe een koppeling wordt gemaakt tussen XL en AxisVM. Vanuit XL wordt een compleet model gegenereerd, inclusief materialen, profielen en belastingen."]
[null,"Vervolgens wordt dit door de VBA-code overgebracht naar AxisVM. AxisVM wordt automatisch opgestart en de opbouw van het model door XL kan worden gevolgd."]
[null,"Als er afwijkingen worden gevonden worden deze tussentijds kenbaar gemaakt."]
[null,"Als het model gereed is, wordt door VBA automatisch een lineaire statische berekening opgestart. Daarvoor wordt het AxisVM model automatisch opgeslagen op de hardeschijf."]
[null,"Er wordt een default naam gebruikt. Dit is een must, omdat het een vast onderdeel is van de AxisVM workflow. "]
[null,"Als de berekening gereed is worden er enkele modelgegevens door VBA-code verzameld en op de XL-sheet \"AxisVM\" geplaatst. De gebruiker kan het uitgevoerd proces volgen en"]
[null,"kan aan de hand van enkele \"kengetallen\" beoordelen of het model voldoet aan eigen wensen en eisen."]
[null,"Daarnaast zijn in de VBA-code enkele voorbeelden opgenomen die rekenresultaten uit AxisVM ophalen en op de XL-sheet \"AxisVM\" plaatsen. "]
[]
[null,"Dit XL-bestand is alleen bedoeld om te laten zien hoe men AxisVM kan aansturen vanuit XL, zonder dat er verder nog handelingen van de gebruiker nodig zijn."]
[null,"Het model, de verwerking van de informatie en rekenresultaten moeten als voorbeelden worden beschouwd hoe een eigen constructie te verwerken in dit XL-bestand of een geheel"]
[null,"niet XL-bestand. De VBA-code kan voor een groot deel worden hergebruikt. De VBA-code is heel uitvoerig en zo helder mogelijk opgesteld. Elke handeling is apart uitgewerkt en kan"]
[null,"eenvoudig worden gevolg. Ook zijn comments aan de VBA-code toegevoegd om helder te maken wat er allemaal gaande is. "]
[]
[null,"Gebruik dit voorbeeld voor het maken van een eigen VBA-applicatie voor de aansturing van AxisVM (of andere software). Hiermee is het mogelijk om allerlei eigen veel voorkomende"]
[null,"constructievormen te verwerken, zoals het voorbeeld. Met enkele eenvoudige aanpassingen kan de gebruiker eenvoudig en binnen een hele korte tijd een volledige berekening uitvoeren."]
[null,"Dit proces is tevens eenvoudig uit te breiden met allerlei eigen wensen. Dit voor het verbeteren van de workflow of het verkrijgen van meer informatie, het verkrijgen van meer vrijheid in de"]
[null,"opzet van het model of het optimaliseren van een constructie. Alles is PARAMETRISCH."]
[null,"Het gebruik van de VBA-applicatie voor het optimaliseren van constructies is hier erg aantrekkelijk. Maak een model, laat AxisVM de berekening uitvoeren. Voer controles uit op de rekenresultaten"]
[null,"met behulp van VBA in XL en als het nodig is pas automatisch het model aan volgens een eigen set regels. En het proces start opnieuw. XL maakt een model, AxisVM maakt een berekening en XL "]
[null,"voert controles uit, totdat het gewenste resultaat is gevonden. Dit kan 1x, 10x, 1000x wat nodig is. "]
[]
[null,"In dit XL-bestand zijn enkele voorbeelden gegeven, maar zeker niet alle opties en mogelijkheden. De mogelijkheden gaan in ieder geval veel verder dan hier is te zien. Echter geeft het een goede start"]
[null,"om zelf ook te kijken naar de mogelijkheden en zelf aanpassingen / aanvullingen uit te voeren. De basis principes zijn gelijk aan de voorbeelden. En voor de extra opties, gegevens en mogelijkheden"]
[null,"zie de handleidingen: \"AxisVM User's Manual\" en \"AxisVM COM interface\". Deze kan men downloaden van de website van de leveranciers van de AxisVM software, zoals www.technosoft.nl."]
[null,"Op de websites zijn ook ander voorbeelden gegeven, ook voor andere programeertalen."]
[]
[]
[null,"Toegang tot AxisVM COM"]
[null,"Het kan zijn dat XL (VBA) AxisVM niet kan vinden en de applicatie werkt niet. De oorzaak hiervoor is zeer waarschijnlijk dat XL de AxisVM COM bib niet kan vinden. In de handleiding \"AxisVM COM Interface\""]
[null,"(laatste hoofdstuk \"Importing type library\") wordt aangegeven hoe je de AXisVM COM bib bij XL bekend moet maken. Let op dit is afhankelijk van de versie van XL die wordt gebruikt op je pc."]