{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Analyse","Toelichting","Hulp"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":17,"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":"Analyse","index":0,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Project:","Parametrisch ontwerpen",null,null,"Versie:",{"$f":"Versie","v":"1.00"}]
[null,null,"Onderdeel:","Analyse bestaande en nieuwe werkbladen"]
[null,null,"Datum:","2020-08-09",null,null,"Klik op logo Vullings Advies"]
[]
[]
[]
[null,"Invoer",null,null,null,null,"Resultaat"]
[null,"Hoogte",400,"mm",null,null,"Oppervlak",{"$f":"invHoogte*invBreedte","v":100000},"mm2"]
[null,"Breedte",250,"mm",null,null,"W",{"$f":"invBreedte/6*invHoogte^2","v":6666666.666666666},"mm3"]
[null,null,null,null,null,null,"I",{"$f":"invBreedte/12*invHoogte^3","v":1333333333.3333333},"mm4"]
[null,"E-modulus",32000,"Nmm2"]
[null,null,null,null,null,null,"Mmax",{"$f":"invQd/8*invL^2","v":112.5},"kNm"]
[null,"Overspanning Lt",6,"m",null,null,"Vmax",{"$f":"invQd/2*invL","v":75},"kN"]
[null,"Gelijkmatige last qd",25,"kN/m1",null,null,"smax",{"$f":"resM*1000000/resW","v":16.875},"N/mm2"]
[null,null,null,null,null,null,"tmax",{"$f":"resV*1000/resOppervlak","v":0.75},"N/mm2"]
[null,null,null,null,null,null,"dmax",{"$f":"5/384*invQd*(invL*1000)^4/(invEmod*resI)","v":9.8876953125000018},"mm"]

{"sheet":"Toelichting","index":1,"n_rows":211,"n_cols":23,"rows_kept":211,"cut":false,"hidden":false,"merged":[[5,1,5,3]]}
[]
[null,null,"Project:","Parametrisch ontwerpen",null,null,"Versie:","1.00"]
[null,null,"Onderdeel:","Analyse bestaande en nieuwe werkbladen"]
[null,null,"Datum:","2020-09-08"]
[]
[]
[null,"Toelichting"]
[]
[null,"Sheet: Analyse"]
[null,"In de sheet \"Analyse\" wordt op een andere wijze gebruik gemaakt van VBA-code om parametrisch te ontwerpen. Hier wordt gebruik gemaakt"]
[null,"van een bestaande rekensheet die door de gebruiker is opgesteld. De sheet kan elke gewenste berekening bevatten. Het kan ook een \"oude\""]
[null,"rekensheet zijn, die al 10 jaar oud is. Hierbij gaan we er vanuit dat het een enkelvoudige rekensheet gaat. Dit wil zeggen dat invoerwaarden worden"]
[null,"gegeven en direct het resultaat wordt berekend. Formules worden niet herhaald. Het gaat om enkele formules achter elkaar die te samen een "]
[null,"meer complex geheel vormen. Om in een dergelijke sheet meerdere varianten uit te werken is het nodig dat de gebruiker zelf verschillende waarden"]
[null,"in de rekensheet verwerkt en de resultaten telkens opschrijft of kopieerd. Als het hier om 10 varianten gaat is dit geen probleem. Als dit er duizende"]
[null,"zijn wordt dit lastig. Dan wordt er vaak toch gekeken om formules te herhalen op de rekensheet, één rij per variant.  Dit resulteert vaak in erg"]
[null,"onoverzichtelijke berekeningen / rekensheets. Het opstellen van een enkelvoudige berekening, zoals in het voorbeeld, is veel eenvoudiger, meer"]
[null,"overzicht en veel begrijperlijker. Om toch snel veel varianten te kunnen beschouwen kan deze VBA-code helpen. Met deze VBA-code kunnen de "]
[null,"duizende varianten automatisch worden uitgevoerd voor rekensheets met enkelvoudige berekeningen. "]
[null,"De VBA-code is universeel opgesteld, zodat deze past in elke rekensheet. Er is maar één voorwaarde waaraan de rekensheet moet voldoen en dat is dat "]
[null,"de cellen die automatisch moeten worden gewijzigd én de cellen waarin de resultaten zijn opgenomen die automatisch worden gevolgd, al deze cellen"]
[null,"moeten een naam hebben. De VBA-code selecteerd cellen alleen op naam (hierover later meer)."]
[]
[null,"Wat doet de VBA-code"]
[null,"De VBA-code is erop gericht om heel snel en heel eenvoudig varianten te genereren op basis van berekenen in een willekeurige rekensheet."]
[null,"Het is de bedoeling dat deze VBA-code in een bestaande of nieuwe rekensheet wordt opgenomen. De VBA-code kan vervolgens automatisch de"]
[null,"inhoud van cellen wijzigen en de resultaten van de wijzigingen weergeven. "]
[null,"In deze Excelsheet is een heel eenvoudig voorbeeld opgenomen, waarbij enkele berekeningen zijn opgenomen van een rechthoekige balk met een"]
[null,"belasting q, een lengte L en een E-modulus E. De invoer is in de kolommen B t/m D weergegeven en de berekeningen, de resultaten in de kolommen"]
[null,"G t/m I. Dit is een mogelijk opzet van een willekeurige rekensheet."]
[null,"Deze rekensheet is opgezet als een enkelvoudige berekening. Er worden enkele invoerwaarden gegeven en er rolt direct een resultaat uit. "]
[null,"De berekeningen en de formules worden niet herhaald in de rekensheet. "]
[null,"De VBA-code wijzigd de inhoud van een specifieke cel, conform de wensen van de gebruiker, en maakt het resultaat zichtbaar. Hiermee kunnen",null,null,null,null,null,null,null,"Figuur B1: Overzicht van invoerformulier van applicatie (er zijn al enkele gegevens ingevoerd)",null,null,null,null,null,null,null,null,null,null,null,null,"Figuur B2: Overzicht van de werksheet met de koppelling van de applicatie"]
[null,"met elke willekeurige rekensheet varianten worden bepaald. Het grote voordeel hiervan is dat varianten studies automatisch kunnen worden"]
[null,"uitgevoerd én dit kan van bestaande rekensheets."]
[]
[null,"Het wijzigen van de inhoud van cellen kan op verschillende manieren, een specifiek getal, een reeks getallen of het zoeken"]
[null,"naar een specifiek resultaat (gelijk aan de functie Doelzoeken in Excel zelf). Het grote voordeel van deze methode is dat de gebruiker verschillende"]
[null,"manieren cellen kan aanpassen en elke willekeurige cel kan kiezen en daarvoor een vast script kan opstellen, zodat alle varianten direct"]
[null,"achter elkaar worden uitgevoerd. De belangrijkste resultaten worden na iedere stap zichtbaar gemaakt. "]
[null,"De resultaten worden in een venster weergegeven. Door zelf de VBA-code aan te passen kunnen de resultaten ook op andere manieren worden"]
[null,"weergegeven. Ook het genereren van reeksen enz kan door eigen aanpassingen eenvoudig naar wens worden herschreven. De huidige VBA-code"]
[null,"vormt een goede basis."]
[]
[null,"Aan de slag"]
[null,"Het belangrijkste van deze applicatie is dat de gewenste cellen van een naam zijn/worden voorzien. Een functionaliteit van Excel die enkele grote "]
[null,"voordelen kent. In figuur B2 is een voorbeeld gegeven van een willekeurige rekensheet. Op basis van enkele invoergegevens worden allerlei"]
[null,"berekeningen uitgevoerd. Het gaat hier om hele eenvoudige berekeningen, maar dit kunnen natuurlijk ook hele complexe berekeningen zijn. "]
[null,"Er zijn geen eisen gesteld aan de vorm én berekeningen in de rekensheet. De enige huidige beperking van de applicatie is dat het alleen getallen"]
[null,"kan wijzigen. Het wijzigen van karakters enz. is niet mogelijk. Dit behoeft enige aanpassing van de VBA-code."]
[null,"De rekensheet functioneerd volledig zelfstandig en is niet afhankelijk van VBA, in welke vorm dan ook. Daarom is deze applicatie ook geschikt voor"]
[null,"elke willekeurige rekensheet (nieuw en oud)."]
[null,"De enigen voorwaarden voor het gebruik van de applicatie is het toepassen van celnamen. Indien een gebruiker en cel celecteerd wordt de"]
[null,"bekende celverwijzing \"C9\" kenbaar gemaakt in de invoerbalk direct boven de rekensheet. De cel \"C9\" bevat de waarde van de hoogte van een balk."]
[null,"De opsteller van de rekensheet vraagt de gebruiker om hier een gewenste hoogte van een balk in te voeren en de sheet rekend vervolgens allerlei"]
[null,"gegevens. Dit geldt niet alleen voor de hoogte, maar ook voor de breedte, E-modules van het materiaal enz."]
[]
[null,"In dit voorbeeld heeft de cel \"C9\" de naam \"invHoogte\", zie figuur B2 en werkblad \"Analyse\". Alle invoerwaarden hebben een naam."]
[null,"Het grote voordeel is dat deze namen ook in functies/berekeningen kunnen worden gebruikt i.p.v. celverwijzingen \"C9\" enz. "]
[null,"Zie de cellen in kolom \"H\". De cellen met de resultaten van berekeningen hebben ook een naam gekregen. Cel \"H9\" heeft naam \"resOppervlak\"."]
[null,"De waarde \"resOppervlak\" is bepaald met de formule \"=invHoogte*invBreedte\" i.p.v. \"=C9*C10\". Dit laatstte zegt natuurlijk niemand iets."]
[null,"Maar in het geval van \"=invHoogte*invBreedte\" weet iedereen wat hier gebeurd. "]
[null,"Een ander voordeel is dat het het verwijderen van rijen, kolommen, toevoegen van rijen en kolommen enz. geen invloed hebben op deze namen."]
[null,"Tenzij de cel met de naam expliciet verwijderd. "]
[null,"Het is overigens prima mogelijk om cellen op een later tijdstip van namen te voorzien. Vanaf dat moment is de naam beschikbaar voor het formuleren"]
[null,"van functies en berekeningen. \"Oude\" formules worden niet aangepast. Maar is geen probleem voor de applicatie. Dus het achteraf benoemen van cellen"]
[null,"is geen enkel probleem voor de applicatie."]
[null,null,null,null,null,null,null,null,null,"Figuur B3: Overzicht van de uitvoer van een script. Bij elke stap worden de gewenste gegevens weergegeven, zoals Breedte en Hoogte.",null,null,null,null,null,null,null,null,null,null,null,null,"Figuur B4: Invoer van gegevens voor het opstellen van een script"]
[null,"Bij het opstarten van de applicatie zoek de applicatie in het actieve werkblad alle cellen met een naam en geeft deze weer in de lijst \"Input cellen\"."]
[null,"Door deze aan te klikken worden enkele gegevens van de betreffende cel weergegeven. In figuur B1 is \"resZakking\" geselecteerd. De informatie laat"]
[null,"zien dat cel \"resZakking\" celreferentie H17 heeft, het bevat een formule en de waarde, het resultaat van de formule is gelijk aan 5,0625. "]
[null,"De formule is gelijk aan: \"=5/384*invQd*(invL*1000)^4/(invEmod*resI)\". Iedereen kan zien dat het hier gaat om het vergeet-me-nietje voor de zakking"]
[null,"d = 5/384   q l4 / EI"]
[]
[]
[null,"Maak een script"]
[null,"Voor dit voorbeeld zie figuur B4."]
[null,"stap 1: Om een script samen te stellen en verschillende gewenste berekeningen uit te voeren selecteer de gewenste cel uit de lijst \"Input cellen\"."]
[null,"             De geselecteerde cel is \"invHoogte\". De informatie geeft aan wat de huidige waarde is (500), de referentie (C9) en of"]
[null,"             de cel is voorzien van een formule. Het is van belang om dit te weten. Het is niet verstandig om een formule te wijzigen, omdat dit de"]
[null,"             berekeningen in het werkblad kan beinvloeden. De applicatie zal deze forumle vervangen door een vaste waarde. Om dit te voorkomen"]
[null,"             zijn er in de applicaties enkele controles ingebouwd. De applicatie zal geen waarden wijzigen in cellen met een formule. Deze cellen"]
[null,"             kunnen wel waardevol zijn voor de gebruiker, bijvoorbeeld voor het monitoren van resultaten."]
[]
[null,"stap 2: voer de waarden voor de geselecteerde cel (voor invHoogte). In dit geval zijn verschillende waarden voor invHoogte ingevoerd."]
[null,"             De waarden zijn: 100; 200 en een reeks die loopt van 300 naar 500 met stappen van 25."]
[]
[null,"stap 3: klik op de gewenste actie en de actie wordt toegevoegd aan het script, zie overzicht \"Invoer script\"."]
[null,"             Indien nodig kunnen de ingevoerde acties nog worden aangepast door de gebruiker door de pijlknopjes. "]
[null,"             Daarmee is het mogelijk om (van links naar rechts):"]
[null,"             A) een geselecteerde actieregel te verwijderen. "]
[null,"             B) reset, alle regels worden verwijderd en begin met een nieuw het opstellen van een nieuwscript"]
[null,"             C) wijzig de acties in het script door de geselecteerde regel omhoog te plaatsen"]
[null,"             D) wijzig de acties in het script door de geselecteerde regel omlaag te plaatsen"]
[]
[null,"            Herhaal deze stappen tot het gewenste script is samengesteld."]
[]
[null,"REEKS"]
[null,"Bijvoorbeeld: \"REEKS   : invHoogte    = 100;200;300>500s25\""]
[null,"De waarde van een cel wordt in stappen gewijzigd. De gewenste waarden worden opgegeven door de gebruiker in het formulier."]
[null,"Daarvoor is de volgende syntax van toepassing: "]
[null,"\"100\" = invoer van een enkel getal"]
[null,"\"100;150;200;500\" = invoer van een serie getallen. De getallen worden één voor één in de betreffende cel verwerkt."]
[null,"\"100>150\" = invoer van een reeks getallen. De reeks loopt van 100 t/m 150 en de stapgrootte is default gelijk aan 1"]
[null,"\"100>150s5\" = invoer van een reeks getallen. De reeks loopt van 100 t/m 150 met stappen van 5."]
[null,"\"150>100s-10\" = invoer van een reeks getallen. De reeks loopt van 150 naar 100 met stappen gelijk aan -10"]
[null,"\"100;150;400>500s10;1000>600s-100\" = combinaties zijn ook mogelijk."]
[null,"Gebruik de juiste karakters anders geeft de applicatie een foutmelding en zal de actie niet verwerken."]
[]
[null,"ZOEK"]
[null,"Bijvoorbeeld: \"ZOEK  : resOppervlak  = 283764  WIJZIG  invBreedte\""]
[null,"De zoek-functie is gelijk aan de Excelfunctie \"Doelzoeken\". In dit geval is het echter mogelijk om dit in een script te verwerken."]
[null,"Selecteer de cel waarvan een gewenste waarde wordt gezocht (bijv. invOppervlak). Selecteer de cel in de lijst \"Input cellen\". "]
[null,"Geeft de gewenste zoekwaarde in \"Waarde\" (bijv. 283764). Klik op ZOEK. De applicatie laat een nieuwe lijst met celnamen zien."]
[null,"Selecteer de cel die moet worden gewijzigd, zodat de gewenste waarde voor de aangegeven cel wordt gevonden (bijv. invBreedte)."]
[null,"De lijst die zichtbaar is bevat alleen cellen zonder formules. Uiteraard is de zoekcel ook geen onderdeel van de lijst. Deze actie "]
[null,"is immers niet mogelijk."]
[]
[null,"MONITOR"]
[null,"Bijvoorbeeld: \"MONITOR  :  invOppervlak\""]
[null,"Selecteer de gewenste cel in \"Input cellen\" en klik op MONITOR. De applicatie zal de waarde van deze cel weergeven tijdens het"]
[null,"uitvoeren van het script. Daarmee zijn de voortgang en resultaten te volgen."]
[null,"Er kunnen meerdere MONITOR cellen worden opgegeven. Hou er echter reken mee dat de naast elkaar in het formulier worden geplaatst."]
[null,"Als er te veel cellen worden geselecteerd zullen er een aantal niet zichtbaar zijn in het formulier."]
[]
[null,"SAVE"]
[null,"Bijvoorbeeld: \"SAVE :       = 1\""]
[null,"Met save worden de waarden en formules in alle cellen opgeslagen. Daarmee is het mogelijk om een resultaat vast te leggen voor later gebruik."]
[null,"Er zijn meerdere SAVE momenten mogelijk. De SAVE momenten krijgen allemaal een automatisch volgnummer. Er is een maximaal aantal."]
[null,"Advies is om een SAVE moment als eerste op te nemen in het script, hiermee is het altijd mogelijk om terug te gaan naar het beginpunt, de"]
[null,"waarden voordat het script wordt uitgevoerd."]
[]
[null,"RESTORE"]
[null,"Bijvoorbeeld: \"RESTORE:      = 1\""]
[null,"Met RESTORE wordt een SAVE moment terug gehaald. Het SAVE moment met hetzelfde volgnummer. "]
[null,"Alle vervolg acties gaan verder met deze waarden."]
[null,"Advies om samen met SAVE 1 een RESTORE 1 aan het eind van het script op te nemen. Dan worden alle beginwaarden terug in het werkblad beplaatst."]
[]
[null,"ANALYSE"]
[null,"Klik op analyse om het script uit te voeren. Alle ingevoerde acties worden uitgevoerd. Voor elke stap worden de gewenste MONITOREN zichtbaar gemaakt."]
[]
[]
[null,"Geef een cel een naam"]
[null,"In figuur C1 is een deel van een Excel sheet weergegeven. In cel B2 is de tekst \"Hoogte\" ingevoerd. Dit is de eerste stap in het opstellen van eigen rekensheet."]
[null,"Stel dat het doel is om een rekensheet op te stellen die een oppervlakte berekend van een rechthoekige doorsnede met een variabele hoogte en breedte."]
[null,"Na het plaatsen van de tekst \"Hoogte\" (in welke cel dan ook) wordt een waarde (\"200\") toegevoegd (figuur C2) en de gewenste eenheid \"mm\"."]
[null,"De volgende stappen zijn het toevoegen van de breedte en de berekening zelf van het oppervlak. Figuur C3 geeft een mogelijke opzet."]
[]
[null,"In cel C4 is nu de gewenste formule weergegeven, zijnde: \"=C2*C3\""]
[null,"Dit is de gebruikelijk wijze waarop formules in Excel worden opgesteld en worden weergegeven. Celverwijzingen zijn de variabelen in formules en Excel zoekt in de"]
[null,"betreffende cel naar de waarde van die cel en voegt deze in de formule in. Dus \"=C2*C3\" is gelijk aan \"=200*50\". De waarde is gelijk aan \"10.000\"."]
[null,"De gebruiker van de rekensheet kan in de cellen C2 en C3 andere waarden invullen en Excel verwerkt dit direct in alle celreferenties, ook in de formule in cel C4."]
[]
[null,"Zoals aangegeven is de leesbaarheid van de formules niet erg duidelijk, zeker als de hele rekensheet complex wordt. Excel geeft de mogelijkheid om cellen eigen",null,null,null,null,null,null,null,null,"Figuur C1: De tekst \"Hoogte\" in cel B2",null,null,null,null,null,null,null,"Figuur C2: De waarde \"200\" in cel C2"]
[null,"unieke namen te geven. Dit kan op twee verschillende manieren. "]
[]
[null,"1) Ga met je muis naar de locatie die met de pijl wordt aangegeven in de figuren C1 t/m C3, nadat je de cel hebt geselecteerd die je van een naam wilt voorzien."]
[null,"Voer de naam \"Hoogte\" in en sluit af met Enter. Nu heeft de cel C2 de naar \"Hoogte\". In formules kan nu de celnaam worden gebruikt of de verwijzing C2. "]
[null,"Bestaande formules worden niet automatisch \"herschreven\" door de celverwijzingen C2 te vervangen door de celnaam \"Hoogte\". Dit moet de gebruiker zelf doen."]
[null,"De volgende stap is het toevoegen van de naam \"Breedte\" aan cel C3. Nu kan de \"oude\" formule in C4 worden herschreven van \"=C2*C3\" naar \"=Hoogte*Breedte\"."]
[null,"Figuur C5 laat dit zien. De uitkomst is uiteraard gelijk en de formule is leesbaar. Andere formules kunnen daarna ook gebruik maken van de celnamen."]
[null,"Bijvoorbeeld voor de bepaling van de omtrek van de rechthoek: \"=(Hoogte+Breedte)*2\""]
[null,"Het is dus handig om de celnamen op voorhand in te voeren, voordat alle formules worden ingevoerd in de rekensheet. Dit vereenvoudigd het werkproces."]
[]
[null,"De celnaam kan maar 1x worden gebruikt. Door op het \"driehoekje\" (figuur C5) te klikken wordt de lijst met celnamen zichtbaar. Door vervolgens op een naam te klikken"]
[null,"wordt de betreffende cel op de rekensheet geselecteerd. Zo kun je snel de betreffende cellen terugvinden."]
[null,"De celnamen moeten uniek zijn en zijn ongevoelig voor hoofdletters en kleine letters. De celnaam moet beginnen met een letter en mag verder ook getallen "]
[null,"hebben en/of een underscore (\"_\"). Gebruik logische het herkenbare namen."]
[null,"Ook gebieden (meerdere cellen) kunnen een naam krijgen. Indien de gebruiker een vaste selectie cellen gebruikt voor te printen kan deze selectie bijvoorbeeld van de"]
[null,"naam \"PrintVeld\" worden voorzien. Dit gaat op dezelfde wijze als het toepassen van enkele celnamen. Dit kan erg handig zijn.",null,null,null,null,null,null,null,null,"Figuur C3: Uiteindelijke opzet van de rekensheet",null,null,null,null,null,null,null,"Figuur C4: Cel C2 heeft de naam \"Hoogte\" gekregen"]
[]
[null,"2) De tweede manier om celnamen in te voeren is het gebruik van de snelknoppen op het lint. Selecteer \"Formules\" en dan zijn alle knoppen gegeven onder"]
[null,"het kopje \"Gedefineerde namen\". Klik op de knop \"Namen beheren\" en een lijst met alle namen wordt zichtbaar, inclusief aanvullende informatie."]
[null,"Hier is het mogelijk om celnamen toe te voegen, te verwijderen en te wijzigen. Indien een naam wordt gewijzigd wordt deze ook in de formules gewijzigd."]
[null,"Indien een celnaam wordt toegevoegd wordt de celverwijzing in formules NIET gewijzigd. Dus C2 blijft staan, ook al krijgt C2 de celnaam \"Hoogte\". "]
[null,"Indien gewenst moet de gebruiker dit zelf handmatig aanpassen."]
[null,"Als een celnaam uit de lijst wordt verwijderd en de betreffende celnaam wordt nog in formules gebruikt, wordt deze formule NIET gewijzigd door Excel. Excel zal bij de"]
[null,"formule een foutmelding (\"#Naam?\") geven."]
[]
[null,"Alle overige voorwaarden en uitgangspunten zijn verder gelijk aan voorgaande omschrijving (optie 1). "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Figuur C5: De nieuwe formule is \"Hoogte*Breedte\"",null,null,null,null,null,null,null,"Figuur C6: Invoeren, bewerken en beheren van celnamen, zie \"Gedefineerde namen\" in het lint"]
[]
[]
[null,"Gebruik VBA code / applicatie"]
[null,"Zoals aangegeven kan deze applicatie worden gebruikt voor bestaande én nieuwe Excelsheets. "]
[null,"De applicatie zelf (de VBA code) kan op verschillende manieren worden toegepast."]
[]
[null,"A) Dit document"]
[null,"Maak gebruik van dit document om nieuwe, eigen werkbladen aan toe te voegen met eigen berekeningen."]
[null,"Met de applicatie (VBA-code) kunnen vervolgens analyses worden uitgevoerd zoals hierboven is aangegeven."]
[]
[null,"B) Selecteer ander document, ander werkblad"]
[null,"De applicatie start automatisch met een selectie mogelijkheid voor het kiezen van een ander Exceldocument"]
[null,"en/of ander werkblad voor het uitvoeren van de analyses, zoals hierboven is aangegeven (fig C7). Dit kunnen natuurlijk"]
[null,"eigen Excelbestanden zijn, oud én nieuw. De voorwaarden zijn ook hierboven gegeven."]
[null,"De applicatie (VBA-code) werkt dan vanuit dit Exceldocument en bewerkt het andere, geselecteerde document en werkblad."]
[]
[null,"C) Copie van VBA-code in ander document"]
[null,"Het is mogleijk om alle VBA-code (modules en formulieren) over te nemen in oude bestaande Excelbestanden"]
[null,"of in nieuwe bestanden. Dan is de applicatie (VBA-code) ook in andere Exceldocumenten beschikbaar (fig.C8)."]
[]
[null,"D) Copie in \"Normal.dot\""]
[null,"Excel kent ook zoiets als een \"normal.dot\", zoals in Word. Hierbij worden standaard instellingen van de gebruiker"]
[null,"geladen, elke keer als Excel wordt opgestart. In deze instellingen kan men ook VBA-code, deze applicatie opnemen (fig.C8)."]
[null,"Dit betekent dat de applicatie altijd beschikbaar is voor elk document dat in Excel wordt geladen, oud en nieuw. "]
[null,"Het verwerken in de \"normal.dot\" is een eenmalige actie. Daarna is de applicatie altijd beschikbaar.",null,null,null,null,null,null,null,null,"Figuur C7: Opgave gewenst werkblad voor analyse",null,null,null,null,null,null,null,"Figuur C8: Deze formulieren en modules overnemen in ander Exceldocument"]

{"sheet":"Hulp","index":2,"n_rows":263,"n_cols":17,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Project:",{"$f":"Project","v":"Parametrisch ontwerpen"},null,null,"Versie:",{"$f":"Versie","v":"1.00"}]
[null,null,"Onderdeel:",{"$f":"Onderdeel","v":"Analyse bestaande en nieuwe werkbladen"}]
[null,null,"Datum:",{"$f":"Datum","v":"2020-09-08"}]
[]
[]
[null,null,null,"Font","Font","Font","Font","Font",null,null,null,null,"Teken+font","Teken+font","Teken+font","Teken+font","Teken+font"]
[null,null,"ASCII","Wingdings","Wingdings 2","Wingdings 3","Symbol","MT Extra",null,"Nr","Teken",null,"Wingdings","Wingdings 2","Wingdings 3","Symbol","MT Extra"]
[null,null,0,0,0,0,0,0,null,1,{"$f":"CHAR(J9)","v":"\u0001"},null,{"$f":"CHAR(J9)","v":"\u0001"},{"$f":"CHAR(J9)","v":"\u0001"},{"$f":"CHAR(J9)","v":"\u0001"},{"$f":"CHAR(J9)","v":"\u0001"},{"$f":"CHAR(J9)","v":"\u0001"}]
[null,null,1,1,1,1,1,1,null,2,{"$f":"CHAR(J10)","v":"\u0002"},null,{"$f":"CHAR(J10)","v":"\u0002"},{"$f":"CHAR(J10)","v":"\u0002"},{"$f":"CHAR(J10)","v":"\u0002"},{"$f":"CHAR(J10)","v":"\u0002"},{"$f":"CHAR(J10)","v":"\u0002"}]
[null,null,2,2,2,2,2,2,null,3,"\u0003",null,"\u0003","\u0003","\u0003","\u0003","\u0003"]
[null,null,3,3,3,3,3,3,null,4,"\u0004",null,"\u0004","\u0004","\u0004","\u0004","\u0004"]
[null,null,4,4,4,4,4,4,null,5,"\u0005",null,"\u0005","\u0005","\u0005","\u0005","\u0005"]
[null,null,5,5,5,5,5,5,null,6,"\u0006",null,"\u0006","\u0006","\u0006","\u0006","\u0006"]
[null,null,6,6,6,6,6,6,null,7,"\u0007",null,"\u0007","\u0007","\u0007","\u0007","\u0007"]
[null,null,7,7,7,7,7,7,null,8,"\b",null,"\b","\b","\b","\b","\b"]
[null,null,8,8,8,8,8,8,null,9,"\t",null,"\t","\t","\t","\t","\t"]
[null,null,9,9,9,9,9,9,null,10,"\n",10,"\n","\n","\n","\n","\n"]
[null,null,"a","a","a","a","a","a",null,11,"\u000b",null,"\u000b","\u000b","\u000b","\u000b","\u000b"]
[null,null,"b","b","b","b","b","b",null,12,"\f",null,"\f","\f","\f","\f","\f"]
[null,null,"c","c","c","c","c","c",null,13,"\r",null,"\r","\r","\r","\r","\r"]
[null,null,"d","d","d","d","d","d",null,14,"\u000e",null,"\u000e","\u000e","\u000e","\u000e","\u000e"]
[null,null,"e","e","e","e","e","e",null,15,"\u000f",null,"\u000f","\u000f","\u000f","\u000f","\u000f"]
[null,null,"f","f","f","f","f","f",null,16,"\u0010",null,"\u0010","\u0010","\u0010","\u0010","\u0010"]
[null,null,"g","g","g","g","g","g",null,17,"\u0011",null,"\u0011","\u0011","\u0011","\u0011","\u0011"]
[null,null,"h","h","h","h","h","h",null,18,"\u0012",null,"\u0012","\u0012","\u0012","\u0012","\u0012"]
[null,null,"i","i","i","i","i","i",null,19,"\u0013",null,"\u0013","\u0013","\u0013","\u0013","\u0013"]
[null,null,"j","j","j","j","j","j",null,20,"\u0014",20,"\u0014","\u0014","\u0014","\u0014","\u0014"]
[null,null,"k","k","k","k","k","k",null,21,"\u0015",null,"\u0015","\u0015","\u0015","\u0015","\u0015"]
[null,null,"l","l","l","l","l","l",null,22,"\u0016",null,"\u0016","\u0016","\u0016","\u0016","\u0016"]
[null,null,"m","m","m","m","m","m",null,23,"\u0017",null,"\u0017","\u0017","\u0017","\u0017","\u0017"]
[null,null,"n","n","n","n","n","n",null,24,"\u0018",null,"\u0018","\u0018","\u0018","\u0018","\u0018"]
[null,null,"o","o","o","o","o","o",null,25,"\u0019",null,"\u0019","\u0019","\u0019","\u0019","\u0019"]
[null,null,"p","p","p","p","p","p",null,26,"\u001a",null,"\u001a","\u001a","\u001a","\u001a","\u001a"]
[null,null,"q","q","q","q","q","q",null,27,"\u001b",null,"\u001b","\u001b","\u001b","\u001b","\u001b"]
[null,null,"r","r","r","r","r","r",null,28,"\u001c",null,"\u001c","\u001c","\u001c","\u001c","\u001c"]
[null,null,"s","s","s","s","s","s",null,29,"\u001d",null,"\u001d","\u001d","\u001d","\u001d","\u001d"]
[null,null,"t","t","t","t","t","t",null,30,"\u001e",30,"\u001e","\u001e","\u001e","\u001e","\u001e"]
[null,null,"u","u","u","u","u","u",null,31,"\u001f",null,"\u001f","\u001f","\u001f","\u001f","\u001f"]
[null,null,"v","v","v","v","v","v",null,32," ",null," "," "," "," "," "]
[null,null,"w","w","w","w","w","w",null,33,"!",null,"!","!","!","!","!"]
[null,null,"x","x","x","x","x","x",null,34,"\"",null,"\"","\"","\"","\"","\""]
[null,null,"y","y","y","y","y","y",null,35,"#",null,"#","#","#","#","#"]
[null,null,"z","z","z","z","z","z",null,36,"$",null,"$","$","$","$","$"]
[null,null,"A","A","A","A","A","A",null,37,"%",null,"%","%","%","%","%"]
[null,null,"B","B","B","B","B","B",null,38,"&",null,"&","&","&","&","&"]
[null,null,"C","C","C","C","C","C",null,39,"'",null,"'","'","'","'","'"]
[null,null,"D","D","D","D","D","D",null,40,"(",40,"(","(","(","(","("]
[null,null,"E","E","E","E","E","E",null,41,")",null,")",")",")",")",")"]
[null,null,"F","F","F","F","F","F",null,42,"*",null,"*","*","*","*","*"]
[null,null,"G","G","G","G","G","G",null,43,"+",null,"+","+","+","+","+"]
[null,null,"H","H","H","H","H","H",null,44,",",null,",",",",",",",",","]
[null,null,"I","I","I","I","I","I",null,45,"-",null,"-","-","-","-","-"]
[null,null,"J","J","J","J","J","J",null,46,".",null,".",".",".",".","."]
[null,null,"K","K","K","K","K","K",null,47,"/",null,"/","/","/","/","/"]
[null,null,"L","L","L","L","L","L",null,48,"0",null,"0","0","0","0","0"]
[null,null,"M","M","M","M","M","M",null,49,"1",null,"1","1","1","1","1"]
[null,null,"N","N","N","N","N","N",null,50,"2",50,"2","2","2","2","2"]
[null,null,"O","O","O","O","O","O",null,51,"3",null,"3","3","3","3","3"]
[null,null,"P","P","P","P","P","P",null,52,"4",null,"4","4","4","4","4"]
[null,null,"Q","Q","Q","Q","Q","Q",null,53,"5",null,"5","5","5","5","5"]
[null,null,"R","R","R","R","R","R",null,54,"6",null,"6","6","6","6","6"]
[null,null,"S","S","S","S","S","S",null,55,"7",null,"7","7","7","7","7"]
[null,null,"T","T","T","T","T","T",null,56,"8",null,"8","8","8","8","8"]
[null,null,"U","U","U","U","U","U",null,57,"9",null,"9","9","9","9","9"]
[null,null,"V","V","V","V","V","V",null,58,":",null,":",":",":",":",":"]
[null,null,"W","W","W","W","W","W",null,59,";",null,";",";",";",";",";"]
[null,null,"X","X","X","X","X","X",null,60,"<",60,"<","<","<","<","<"]
[null,null,"Y","Y","Y","Y","Y","Y",null,61,"=",null,"=","=","=","=","="]
[null,null,"Z","Z","Z","Z","Z","Z",null,62,">",null,">",">",">",">",">"]
[null,null,"!","!","!","!","!","!",null,63,"?",null,"?","?","?","?","?"]
[null,null,"@","@","@","@","@","@",null,64,"@",null,"@","@","@","@","@"]
[null,null,"#","#","#","#","#","#",null,65,"A",null,"A","A","A","A","A"]
[null,null,"%","%","%","%","%","%",null,66,{"$f":"CHAR(J74)","v":"B"},null,{"$f":"CHAR(J74)","v":"B"},{"$f":"CHAR(J74)","v":"B"},{"$f":"CHAR(J74)","v":"B"},{"$f":"CHAR(J74)","v":"B"},{"$f":"CHAR(J74)","v":"B"}]
[null,null,"^","^","^","^","^","^",null,67,"C",null,"C","C","C","C","C"]
[null,null,"&","&","&","&","&","&",null,68,"D",null,"D","D","D","D","D"]
[null,null,"(","(","(","(","(","(",null,69,"E",null,"E","E","E","E","E"]
[null,null,")",")",")",")",")",")",null,70,"F",70,"F","F","F","F","F"]
[null,null,"_","_","_","_","_","_",null,71,"G",null,"G","G","G","G","G"]
[null,null,"-","-","-","-","-","-",null,72,"H",null,"H","H","H","H","H"]
[null,null,"+","+","+","+","+","+",null,73,"I",null,"I","I","I","I","I"]
[null,null,"=","=","=","=","=","=",null,74,"J",null,"J","J","J","J","J"]
[null,null,"|","|","|","|","|","|",null,75,"K",null,"K","K","K","K","K"]
[null,null,"\\","\\","\\","\\","\\","\\",null,76,"L",null,"L","L","L","L","L"]
[null,null,"?","?","?","?","?","?",null,77,"M",null,"M","M","M","M","M"]
[null,null,"<","<","<","<","<","<",null,78,"N",null,"N","N","N","N","N"]
[null,null,">",">",">",">",">",">",null,79,"O",null,"O","O","O","O","O"]
[null,null,".",".",".",".",".",".",null,80,"P",80,"P","P","P","P","P"]
[null,null,",",",",",",",",",",",",null,81,"Q",null,"Q","Q","Q","Q","Q"]
[null,null,null,null,null,null,null,null,null,82,"R",null,"R","R","R","R","R"]
[null,null,null,null,null,null,null,null,null,83,"S",null,"S","S","S","S","S"]
[null,null,null,null,null,null,null,null,null,84,"T",null,"T","T","T","T","T"]
[null,null,null,null,null,null,null,null,null,85,"U",null,"U","U","U","U","U"]
[null,null,null,null,null,null,null,null,null,86,"V",null,"V","V","V","V","V"]
[null,null,null,null,null,null,null,null,null,87,"W",null,"W","W","W","W","W"]
[null,null,null,null,null,null,null,null,null,88,"X",null,"X","X","X","X","X"]
[null,null,null,null,null,null,null,null,null,89,"Y",null,"Y","Y","Y","Y","Y"]
[null,null,null,null,null,null,null,null,null,90,"Z",90,"Z","Z","Z","Z","Z"]
[null,null,null,null,null,null,null,null,null,91,"[",null,"[","[","[","[","["]
[null,null,null,null,null,null,null,null,null,92,"\\",null,"\\","\\","\\","\\","\\"]
[null,null,null,null,null,null,null,null,null,93,"]",null,"]","]","]","]","]"]
[null,null,null,null,null,null,null,null,null,94,"^",null,"^","^","^","^","^"]
[null,null,null,null,null,null,null,null,null,95,"_",null,"_","_","_","_","_"]
[null,null,null,null,null,null,null,null,null,96,"`",null,"`","`","`","`","`"]
[null,null,null,null,null,null,null,null,null,97,"a",null,"a","a","a","a","a"]
[null,null,null,null,null,null,null,null,null,98,"b",null,"b","b","b","b","b"]
[null,null,null,null,null,null,null,null,null,99,"c",null,"c","c","c","c","c"]
[null,null,null,null,null,null,null,null,null,100,"d",100,"d","d","d","d","d"]
[null,null,null,null,null,null,null,null,null,101,"e",null,"e","e","e","e","e"]
[null,null,null,null,null,null,null,null,null,102,"f",null,"f","f","f","f","f"]
[null,null,null,null,null,null,null,null,null,103,"g",null,"g","g","g","g","g"]
[null,null,null,null,null,null,null,null,null,104,"h",null,"h","h","h","h","h"]
[null,null,null,null,null,null,null,null,null,105,"i",null,"i","i","i","i","i"]
[null,null,null,null,null,null,null,null,null,106,"j",null,"j","j","j","j","j"]
[null,null,null,null,null,null,null,null,null,107,"k",null,"k","k","k","k","k"]
[null,null,null,null,null,null,null,null,null,108,"l",null,"l","l","l","l","l"]
[null,null,null,null,null,null,null,null,null,109,"m",null,"m","m","m","m","m"]
[null,null,null,null,null,null,null,null,null,110,"n",110,"n","n","n","n","n"]
[null,null,null,null,null,null,null,null,null,111,"o",null,"o","o","o","o","o"]
[null,null,null,null,null,null,null,null,null,112,"p",null,"p","p","p","p","p"]
[null,null,null,null,null,null,null,null,null,113,"q",null,"q","q","q","q","q"]
[null,null,null,null,null,null,null,null,null,114,"r",null,"r","r","r","r","r"]
[null,null,null,null,null,null,null,null,null,115,"s",null,"s","s","s","s","s"]
[null,null,null,null,null,null,null,null,null,116,"t",null,"t","t","t","t","t"]
[null,null,null,null,null,null,null,null,null,117,"u",null,"u","u","u","u","u"]
[null,null,null,null,null,null,null,null,null,118,"v",null,"v","v","v","v","v"]
[null,null,null,null,null,null,null,null,null,119,"w",null,"w","w","w","w","w"]
[null,null,null,null,null,null,null,null,null,120,"x",120,"x","x","x","x","x"]
[null,null,null,null,null,null,null,null,null,121,"y",null,"y","y","y","y","y"]
[null,null,null,null,null,null,null,null,null,122,"z",null,"z","z","z","z","z"]
[null,null,null,null,null,null,null,null,null,123,"{",null,"{","{","{","{","{"]
[null,null,null,null,null,null,null,null,null,124,"|",null,"|","|","|","|","|"]
[null,null,null,null,null,null,null,null,null,125,"}",null,"}","}","}","}","}"]
[null,null,null,null,null,null,null,null,null,126,"~",null,"~","~","~","~","~"]
[null,null,null,null,null,null,null,null,null,127,"\u007f",null,"\u007f","\u007f","\u007f","\u007f","\u007f"]
[null,null,null,null,null,null,null,null,null,128,"€",null,"€","€","€","€","€"]
[null,null,null,null,null,null,null,null,null,129,"\u0081",null,"\u0081","\u0081","\u0081","\u0081","\u0081"]
[null,null,null,null,null,null,null,null,null,130,{"$f":"CHAR(J138)","v":"‚"},130,{"$f":"CHAR(J138)","v":"‚"},{"$f":"CHAR(J138)","v":"‚"},{"$f":"CHAR(J138)","v":"‚"},{"$f":"CHAR(J138)","v":"‚"},{"$f":"CHAR(J138)","v":"‚"}]
[null,null,null,null,null,null,null,null,null,131,"ƒ",null,"ƒ","ƒ","ƒ","ƒ","ƒ"]
[null,null,null,null,null,null,null,null,null,132,"„",null,"„","„","„","„","„"]
[null,null,null,null,null,null,null,null,null,133,"…",null,"…","…","…","…","…"]
[null,null,null,null,null,null,null,null,null,134,"†",null,"†","†","†","†","†"]
[null,null,null,null,null,null,null,null,null,135,"‡",null,"‡","‡","‡","‡","‡"]
[null,null,null,null,null,null,null,null,null,136,"ˆ",null,"ˆ","ˆ","ˆ","ˆ","ˆ"]
[null,null,null,null,null,null,null,null,null,137,"‰",null,"‰","‰","‰","‰","‰"]
[null,null,null,null,null,null,null,null,null,138,"Š",null,"Š","Š","Š","Š","Š"]
[null,null,null,null,null,null,null,null,null,139,"‹",null,"‹","‹","‹","‹","‹"]
[null,null,null,null,null,null,null,null,null,140,"Œ",140,"Œ","Œ","Œ","Œ","Œ"]
[null,null,null,null,null,null,null,null,null,141,"\u008d",null,"\u008d","\u008d","\u008d","\u008d","\u008d"]
[null,null,null,null,null,null,null,null,null,142,"Ž",null,"Ž","Ž","Ž","Ž","Ž"]
[null,null,null,null,null,null,null,null,null,143,"\u008f",null,"\u008f","\u008f","\u008f","\u008f","\u008f"]
[null,null,null,null,null,null,null,null,null,144,"\u0090",null,"\u0090","\u0090","\u0090","\u0090","\u0090"]
[null,null,null,null,null,null,null,null,null,145,"‘",null,"‘","‘","‘","‘","‘"]
[null,null,null,null,null,null,null,null,null,146,"’",null,"’","’","’","’","’"]
[null,null,null,null,null,null,null,null,null,147,"“",null,"“","“","“","“","“"]
[null,null,null,null,null,null,null,null,null,148,"”",null,"”","”","”","”","”"]
[null,null,null,null,null,null,null,null,null,149,"•",null,"•","•","•","•","•"]
[null,null,null,null,null,null,null,null,null,150,"–",150,"–","–","–","–","–"]
[null,null,null,null,null,null,null,null,null,151,"—",null,"—","—","—","—","—"]
[null,null,null,null,null,null,null,null,null,152,"˜",null,"˜","˜","˜","˜","˜"]
[null,null,null,null,null,null,null,null,null,153,"™",null,"™","™","™","™","™"]
[null,null,null,null,null,null,null,null,null,154,"š",null,"š","š","š","š","š"]
[null,null,null,null,null,null,null,null,null,155,"›",null,"›","›","›","›","›"]
[null,null,null,null,null,null,null,null,null,156,"œ",null,"œ","œ","œ","œ","œ"]
[null,null,null,null,null,null,null,null,null,157,"\u009d",null,"\u009d","\u009d","\u009d","\u009d","\u009d"]
[null,null,null,null,null,null,null,null,null,158,"ž",null,"ž","ž","ž","ž","ž"]
[null,null,null,null,null,null,null,null,null,159,"Ÿ",null,"Ÿ","Ÿ","Ÿ","Ÿ","Ÿ"]
[null,null,null,null,null,null,null,null,null,160," ",160," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null,161,"¡",null,"¡","¡","¡","¡","¡"]
[null,null,null,null,null,null,null,null,null,162,"¢",null,"¢","¢","¢","¢","¢"]
[null,null,null,null,null,null,null,null,null,163,"£",null,"£","£","£","£","£"]
[null,null,null,null,null,null,null,null,null,164,"¤",null,"¤","¤","¤","¤","¤"]
[null,null,null,null,null,null,null,null,null,165,"¥",null,"¥","¥","¥","¥","¥"]
[null,null,null,null,null,null,null,null,null,166,"¦",null,"¦","¦","¦","¦","¦"]
[null,null,null,null,null,null,null,null,null,167,"§",null,"§","§","§","§","§"]
[null,null,null,null,null,null,null,null,null,168,"¨",null,"¨","¨","¨","¨","¨"]
[null,null,null,null,null,null,null,null,null,169,"©",null,"©","©","©","©","©"]
[null,null,null,null,null,null,null,null,null,170,"ª",170,"ª","ª","ª","ª","ª"]
[null,null,null,null,null,null,null,null,null,171,"«",null,"«","«","«","«","«"]
[null,null,null,null,null,null,null,null,null,172,"¬",null,"¬","¬","¬","¬","¬"]
[null,null,null,null,null,null,null,null,null,173,"­",null,"­","­","­","­","­"]
[null,null,null,null,null,null,null,null,null,174,"®",null,"®","®","®","®","®"]
[null,null,null,null,null,null,null,null,null,175,"¯",null,"¯","¯","¯","¯","¯"]
[null,null,null,null,null,null,null,null,null,176,"°",null,"°","°","°","°","°"]
[null,null,null,null,null,null,null,null,null,177,"±",null,"±","±","±","±","±"]
[null,null,null,null,null,null,null,null,null,178,"²",null,"²","²","²","²","²"]
[null,null,null,null,null,null,null,null,null,179,"³",null,"³","³","³","³","³"]
[null,null,null,null,null,null,null,null,null,180,"´",180,"´","´","´","´","´"]
[null,null,null,null,null,null,null,null,null,181,"µ",null,"µ","µ","µ","µ","µ"]
[null,null,null,null,null,null,null,null,null,182,"¶",null,"¶","¶","¶","¶","¶"]
[null,null,null,null,null,null,null,null,null,183,"·",null,"·","·","·","·","·"]
[null,null,null,null,null,null,null,null,null,184,"¸",null,"¸","¸","¸","¸","¸"]
[null,null,null,null,null,null,null,null,null,185,"¹",null,"¹","¹","¹","¹","¹"]
[null,null,null,null,null,null,null,null,null,186,"º",null,"º","º","º","º","º"]
[null,null,null,null,null,null,null,null,null,187,"»",null,"»","»","»","»","»"]
[null,null,null,null,null,null,null,null,null,188,"¼",null,"¼","¼","¼","¼","¼"]
[null,null,null,null,null,null,null,null,null,189,"½",null,"½","½","½","½","½"]
[null,null,null,null,null,null,null,null,null,190,"¾",190,"¾","¾","¾","¾","¾"]
[null,null,null,null,null,null,null,null,null,191,"¿",null,"¿","¿","¿","¿","¿"]
[null,null,null,null,null,null,null,null,null,192,"À",null,"À","À","À","À","À"]
[null,null,null,null,null,null,null,null,null,193,"Á",null,"Á","Á","Á","Á","Á"]
[null,null,null,null,null,null,null,null,null,194,{"$f":"CHAR(J202)","v":"Â"},null,{"$f":"CHAR(J202)","v":"Â"},{"$f":"CHAR(J202)","v":"Â"},{"$f":"CHAR(J202)","v":"Â"},{"$f":"CHAR(J202)","v":"Â"},{"$f":"CHAR(J202)","v":"Â"}]
[null,null,null,null,null,null,null,null,null,195,"Ã",null,"Ã","Ã","Ã","Ã","Ã"]
[null,null,null,null,null,null,null,null,null,196,"Ä",null,"Ä","Ä","Ä","Ä","Ä"]
[null,null,null,null,null,null,null,null,null,197,"Å",null,"Å","Å","Å","Å","Å"]
[null,null,null,null,null,null,null,null,null,198,"Æ",null,"Æ","Æ","Æ","Æ","Æ"]
[null,null,null,null,null,null,null,null,null,199,"Ç",null,"Ç","Ç","Ç","Ç","Ç"]
[null,null,null,null,null,null,null,null,null,200,"È",200,"È","È","È","È","È"]
[null,null,null,null,null,null,null,null,null,201,"É",null,"É","É","É","É","É"]
[null,null,null,null,null,null,null,null,null,202,"Ê",null,"Ê","Ê","Ê","Ê","Ê"]
[null,null,null,null,null,null,null,null,null,203,"Ë",null,"Ë","Ë","Ë","Ë","Ë"]
[null,null,null,null,null,null,null,null,null,204,"Ì",null,"Ì","Ì","Ì","Ì","Ì"]
[null,null,null,null,null,null,null,null,null,205,"Í",null,"Í","Í","Í","Í","Í"]
[null,null,null,null,null,null,null,null,null,206,"Î",null,"Î","Î","Î","Î","Î"]
[null,null,null,null,null,null,null,null,null,207,"Ï",null,"Ï","Ï","Ï","Ï","Ï"]
[null,null,null,null,null,null,null,null,null,208,"Ð",null,"Ð","Ð","Ð","Ð","Ð"]
[null,null,null,null,null,null,null,null,null,209,"Ñ",null,"Ñ","Ñ","Ñ","Ñ","Ñ"]
[null,null,null,null,null,null,null,null,null,210,"Ò",210,"Ò","Ò","Ò","Ò","Ò"]
[null,null,null,null,null,null,null,null,null,211,"Ó",null,"Ó","Ó","Ó","Ó","Ó"]
[null,null,null,null,null,null,null,null,null,212,"Ô",null,"Ô","Ô","Ô","Ô","Ô"]
[null,null,null,null,null,null,null,null,null,213,"Õ",null,"Õ","Õ","Õ","Õ","Õ"]
[null,null,null,null,null,null,null,null,null,214,"Ö",null,"Ö","Ö","Ö","Ö","Ö"]
[null,null,null,null,null,null,null,null,null,215,"×",null,"×","×","×","×","×"]
[null,null,null,null,null,null,null,null,null,216,"Ø",null,"Ø","Ø","Ø","Ø","Ø"]
[null,null,null,null,null,null,null,null,null,217,"Ù",null,"Ù","Ù","Ù","Ù","Ù"]
[null,null,null,null,null,null,null,null,null,218,"Ú",null,"Ú","Ú","Ú","Ú","Ú"]
[null,null,null,null,null,null,null,null,null,219,"Û",null,"Û","Û","Û","Û","Û"]
[null,null,null,null,null,null,null,null,null,220,"Ü",220,"Ü","Ü","Ü","Ü","Ü"]
[null,null,null,null,null,null,null,null,null,221,"Ý",null,"Ý","Ý","Ý","Ý","Ý"]
[null,null,null,null,null,null,null,null,null,222,"Þ",null,"Þ","Þ","Þ","Þ","Þ"]
[null,null,null,null,null,null,null,null,null,223,"ß",null,"ß","ß","ß","ß","ß"]
[null,null,null,null,null,null,null,null,null,224,"à",null,"à","à","à","à","à"]
[null,null,null,null,null,null,null,null,null,225,"á",null,"á","á","á","á","á"]
[null,null,null,null,null,null,null,null,null,226,"â",null,"â","â","â","â","â"]
[null,null,null,null,null,null,null,null,null,227,"ã",null,"ã","ã","ã","ã","ã"]
[null,null,null,null,null,null,null,null,null,228,"ä",null,"ä","ä","ä","ä","ä"]
[null,null,null,null,null,null,null,null,null,229,"å",null,"å","å","å","å","å"]
[null,null,null,null,null,null,null,null,null,230,"æ",230,"æ","æ","æ","æ","æ"]
[null,null,null,null,null,null,null,null,null,231,"ç",null,"ç","ç","ç","ç","ç"]
[null,null,null,null,null,null,null,null,null,232,"è",null,"è","è","è","è","è"]
[null,null,null,null,null,null,null,null,null,233,"é",null,"é","é","é","é","é"]
[null,null,null,null,null,null,null,null,null,234,"ê",null,"ê","ê","ê","ê","ê"]
[null,null,null,null,null,null,null,null,null,235,"ë",null,"ë","ë","ë","ë","ë"]
[null,null,null,null,null,null,null,null,null,236,"ì",null,"ì","ì","ì","ì","ì"]
[null,null,null,null,null,null,null,null,null,237,"í",null,"í","í","í","í","í"]
[null,null,null,null,null,null,null,null,null,238,"î",null,"î","î","î","î","î"]
[null,null,null,null,null,null,null,null,null,239,"ï",null,"ï","ï","ï","ï","ï"]
[null,null,null,null,null,null,null,null,null,240,"ð",240,"ð","ð","ð","ð","ð"]
[null,null,null,null,null,null,null,null,null,241,"ñ",null,"ñ","ñ","ñ","ñ","ñ"]
[null,null,null,null,null,null,null,null,null,242,"ò",null,"ò","ò","ò","ò","ò"]
[null,null,null,null,null,null,null,null,null,243,"ó",null,"ó","ó","ó","ó","ó"]
[null,null,null,null,null,null,null,null,null,244,"ô",null,"ô","ô","ô","ô","ô"]
[null,null,null,null,null,null,null,null,null,245,"õ",null,"õ","õ","õ","õ","õ"]
[null,null,null,null,null,null,null,null,null,246,"ö",null,"ö","ö","ö","ö","ö"]
[null,null,null,null,null,null,null,null,null,247,"÷",null,"÷","÷","÷","÷","÷"]
[null,null,null,null,null,null,null,null,null,248,"ø",null,"ø","ø","ø","ø","ø"]
[null,null,null,null,null,null,null,null,null,249,"ù",null,"ù","ù","ù","ù","ù"]
[null,null,null,null,null,null,null,null,null,250,"ú",250,"ú","ú","ú","ú","ú"]
[null,null,null,null,null,null,null,null,null,251,"û",null,"û","û","û","û","û"]
[null,null,null,null,null,null,null,null,null,252,"ü",null,"ü","ü","ü","ü","ü"]
[null,null,null,null,null,null,null,null,null,253,"ý",null,"ý","ý","ý","ý","ý"]
[null,null,null,null,null,null,null,null,null,254,"þ",null,"þ","þ","þ","þ","þ"]
[null,null,null,null,null,null,null,null,null,255,"ÿ",null,"ÿ","ÿ","ÿ","ÿ","ÿ"]