Most Valuable Professional

subscribe to rss feed
Subscribe in a reader

Home > English site > Services
Deze pagina in het Nederlands

Services

What can I do for you?

JKP Application Development Services develops custom-made applications, using Microsoft Excel and VBA to its full extent. Since the products are customer specific and often under NDA, there are no downloadable examples on this site.

Applications may range from relatively simple repetitive task handling utilities to full fledged applications.

There are no restrictions to your type of business. The application to be developed can concern any discipline or profession, e.g. financial, chemical engineering, data modelling, statistical, medical, etcetera.

To get an impression of some of the available expertise, a few examples of utilities developed by me are to be found on my download pages.

Check out the products page for examples of commercially developed products.

Recent Projects

  1. www.CP7.nl : Creating an e-invoicing and fully electronic order processing system: MS Access 2003/VBA;
  2. SNS Asset Management: Update portfolio management reporting (Excel/VBA)
  3. Shell EP Netherlands: Develop a set of templates which are used to update project planning models. The Excel templates are downloaded from a SAP portal and use SAP Webservices to (securely) pull data from and push data to SAP XI.
  4. Essent trading : Developing various Excel (VBA) tools for the Energy trading desk, supporting traders with their Excel related issues.
  5. ABN AMRO bank the Netherlands (Risc Managment): Developing various complex rapporting systems (Excel + VBA + Lotus Notes automation) and a switchboard Application (MSAccess) to run these automatically.
  6. For Fortis Netherlands: Assisting with a migration project from Win NT/Office 97 to WinXP/Office 2003. Analysis of hundreds of thousands of files for potential migration issues, using a customised Access application. Fixing issues during the migration.
  7. NavigatorXL: Wizards for uploading data to and downloading data from Oracle systems directly from within Excel.
  8. For Weka publishers: professionalise a system to create annual social reports.
  9. For the Dutch Ministry of Social Affairs: a course on Advanced Excel VBA. Topics: Class modules (backgrounds, custom events, collections). Userforms (Create on-the-fly using code, add code programmatically, add controls at runtime, create control events using class modules). Add-ins (COM, VB6) in Excel. Smart Tags. Controlling Outlook and Word via Excel VBA. Creating and modifying databases and tables using ADO and SQL.
  10. For Shell Brands International AG, a system to enter and analyse global advertising campaign pre-test research data (using VBA, Pivot tables, Data Validation and conditional formatting).
  11. For a UK waste management company: updating a graphing package that is used for the analysis of nuclear waste streams (using extensive VBA coding).
  12. A reporting system for an American company with which they calculate the weekly pay and bonuses for their technicians and which reports their sales over various periods of time. The project involves Excel and VBA programming, using Microsoft ADO to extract data from an Access database.
  13. For an American financial consultancy company: A system to import email messages from Outlook into Excel in order to be able to process the name and address data (entered in a webform) from people subscribing to a newsletter. This project involved programming Outlook from Excel, using VBA from within Excel.