DATABASE & MS-OFFICE

MS-Excel MS-Visio MS-Word MS-Access MS-SQL Server MS Visual Basic for Applications (VBa)

[ XML IMPORT\EXPORT to EXCEL (MOVICON SCADA TAG \ ALARMS DATABASES) ]

  • Client : Paradigm For Excellence (Water Utility projects)
  • Ability to import object based XML databases into EXCEL spreadsheet and re-export to XML
    • Allowing easy edit of Tags \ Alarms
    • Copy Paste of large record sets (making replication a breeze)
  • Excel VBa implementation

[ MS-WORD Reports AUTOMATION from XML data ]

  • Typically 400 page structural (Siesmic & Static load cases) reports
  • Extension of a High volume racking design application to import a parameterized CAD design into a Structural Analysis package, that undertakes complex seismic and static load calculations, the results of which are in XML tables and need to be heavily manipulated for report presentation and report summaries.   The MS-WORD template file can have report sections suppressed by using VB.NET side forms inside MS-WORD.  
  • The formating parts of the reports can be generated in under 1 minute, so that only reviews and summaries need to be conducted by structural specialists.  All suspect sections wjhere load capacity indicates the structure may fail are highlighted in RED. These rep[orts used to take a PhD engineer 3 months to prepare just one! 
  • Skills: VB.NET, VSO MS-OFFICE integration tools, XML readers