Vattenfall Operations Report Power App

Development of a Power App with approval workflow.

Input of heating installation projects that deviate from the specification.

Multidimensional risk assessment with detailed risk matrix.

Multistage approval workflow (Power Automate) with reminders and escalation.

User-friendly navigation with the possibility of editing and evaluating reports.

Customer information

Vattenfall is a Swedish energy company.

Vattenfall Site Provisioning

Development of a SharePoint SPFX web part and backend for ordering SharePoint sites.

Selection of specific templates possible based on SharePoint site types and PnP XML templates.

Input of additional owners and members.

Selection of language, external sharing, and time zone possible.

Display of all sites with search and filter.

Customer information

Vattenfall is a Swedish energy company.

SharePoint URL Shortener & Redirector

Development of a SharePoint SPFX web part for shortening and redirecting links.

Storage of mappings in a SharePoint list with up to 10 million entries.

IDs can be assigned by the user.

Search for target URLs possible.

Further links

SharePoint Permission Center

Development of a SharePoint SPFX web part for displaying and managing site permissions.

Shows all people who have access to a site collection with nested groups.

Expandable user cards with personal details: permission levels, group memberships.

Complete group nest diagram with SharePoint, M365, and Azure groups.

Shows hidden groups and all sharing links.

Further links

Vattenfall RESI

Backend optimization for an internal system to create optimized offers.

Adaptation of PL-SQL queries and procedures. Performance analysis with Ants Profiler.

Adaptation of the middleware to speed up computational processes (C#, Entity Framework).

Customer information

Vattenfall is a Swedish energy company.

Telekom PIMS

A SharePoint 2013-based application for recording products and product types within Telekom.

Data storage in SharePoint lists. Implementation as a provider-hosted app with event listeners.

Use of SharePoint branding options via themes, master pages, and JavaScript.

Site Provisioning

Development of a site provisioning solution to roll out the structure to several hundred sites and update them (AngularJS, C# backend).

Customer information

The solution was developed by ORBIT IT-Solutions in Bonn.

M-OnSite mobile App

A mobile app for iOS and Android that facilitates working through checklists during conference setup. The app is downloaded via the AppGyver scanner and also works offline. In online mode, the pending checks are synchronized with the server. The project manager can see the setup status on his iPad and give instructions via chat.

The solution runs with a SharePoint backend so that all information is also available in the intranet.

Developed with HTML5/JS/CSS3 using the AppGyver frameworks with Steroids/Cordova.

Customer information

M Events offers project management and state-of-the-art technology for conferences and events.

Project management solution for SharePoint

A SharePoint solution was developed for project management at M Events. It allows projects to be created and archived and was implemented with SharePoint workflows.

To ensure access to the data offline, an Excel sheet with SharePoint connection was created.

Customer information

M Events offers project management and state-of-the-art technology for conferences and events.

CryptoXL

The project aimed to enable end-to-end encryption with AES256 for SharePoint. Data is stored encrypted in SharePoint and is only decrypted and encrypted on the user's computer.

For the Excel client, an AES256 encryption VBA was programmed, which is 100% compatible with the Crypto.JS JavaScript library.

Developed with HTML5/JS and VBA using AngularJS, Crypto.js and VBA-WEB.

Customer information

WhizzyTools creates apps & tools for Microsoft Office and SharePoint.

Mobile Performance Record with Excel

The goal was to implement a solution that allows CARL GmbH employees to record their working hours on Android tablets using Excel sheets. The filled-in Excel sheets are stored on a central Dropbox.

Using a master sheet, employee data is imported and checked daily. At the end of the month, it is exported in aggregated form for the tax advisor.

Customer information

CARL GmbH operates guesthouses in Munich.

M Events Intranet

The SharePoint intranet of M Events was revised and restructured in early 2015. A branding package was developed and implemented. As part of the restructuring, smaller apps with workflows were also developed.

Customer information

M Events offers project management and state-of-the-art technology for conferences and events.

Excel Time Tracking

A solution for time tracking and project cost control for Excel. Designed for both freelancers and smaller teams. Fully expandable; runs in 22+ languages. Includes a master sheet that aggregates the recorded working hours of team members.

The solution runs in work environments with high IT security requirements, without macros and add-ins.

Customer information

WhizzyTools creates apps & tools for Microsoft Office and SharePoint.

DesktopTracker Design & Implementation

Design and implementation of a web application focused on ease of use. The design incorporates many UI features of the Vaadin framework.

The application was implemented in Java and successfully realized in detail.

Customer information

Avalain is a young startup from Budapest, HUNGARY.

Position Keeping Solution

The Portfolio Monitor was developed and improved over several years. It is a tool for position keeping and is used for hedge funds and overlays. It supports derivatives such as futures, options, and FX forwards. The goal is position evaluation and risk monitoring (Value-At-Risk) in real-time.

The program was developed in C# under the .NET Framework 3.5 and uses the Bloomberg Terminal API (.NET and COM).

Customer information

Vescore is a financial services provider from Munich.

Market Navigator

Design and implementation of the Market Navigator (Java, Swing, C#). A client-server application for visualizing model-based return predictions.

The application was programmed in Java (Swing) and delivered over the internet via Java WebStart. The database and calculation modules were accessed via SOAP.

Customer information

Vescore is a financial services provider from Munich.

Factsheet Engine

The goal was to create an Excel-based solution for semi-automatically creating monthly fund factsheets.

Customer information

Vescore is a financial services provider from Munich.

Bencer Web 2012

Redesign of the web presence with a focus on improved display on mobile devices. The website supports over 12 browsers.

The menu was implemented in JavaScript.

Customer information

Bencer Project Management is one of the leading German project managers for construction projects in China.

Bencer Construction Web 2011

Website design and implementation for Bencer's new 'Construction' spinoff.

The slide box on the right was implemented in JavaScript.

Customer information

Bencer Project Management is one of the leading German project managers for construction projects in China.

Bencer Web 2010

Design and programming of the company's website.

Customer information

Bencer Project Management is one of the leading German project managers for construction projects in China.

FUTOP ID Generator

This Excel-based solution generates an identifier for futures and options that can be traded on international exchanges, similar to the ISIN for stocks.

Using this FUTOP ID, fully automated inventory imports and checks for over 20 funds were implemented, which collaborate with 7 banks and financial institutions.

Customer information

Vescore is a financial services provider from Munich.

Quick Inventory Check

This Excel-based solution helps the fund manager review inventories. The simple traffic light system makes it easy to find discrepancies between the portfolio manager and the investment bank.

The preliminary work is done by a fully automated import of executed orders and inventories from emails, reporting websites, Excel sheets, CSV, PDF, and other formats.

The solution was implemented with an Excel add-in. The import was implemented in AutoIt, a popular automation scripting language.

Customer information

Vescore is a financial services provider from Munich.

TODI Attachment Saver

This Microsoft Outlook add-in saves attachments to the local hard drive and reduces the size of the Outlook PST file. The attachments are linked at the end of the email.

The add-in was implemented in Visual Basic 6 and uses the Outlook COM add-in interface.

WhizzyTools Corporate Design Manual

Corporate design manual for WhizzyTools.com: logos, icons, color palettes, and fonts.

Customer information

WhizzyTools.com develops apps for Microsoft Office.