Humboldt University

Great time saving for applications for research projects With an interactive personnel calculator app based on Microsoft Excel and Open as App the university greatly increases its efficiency for the applications for research projects. At a glance – Open as App at Humboldt University Challenge Research and publications contribute to the reputation of the Humboldt University of […]

Education

Great time saving for applications for research projects

With an interactive personnel calculator app based on Microsoft Excel and Open as App the university greatly increases its efficiency for the applications for research projects.

At a glance – Open as App at Humboldt University

Humboldt University Diagram EN

Challenge

Research and publications contribute to the reputation of the Humboldt University of Berlin. To achieve this, a wide organization must be managed.

More than 2,000 professors and their research assistants submit a large number of applications for research projects every year. Apart from the description of the research project, the budget is of central importance.

To ensure that all projects are adequately funded, the Research Service Centre examines the budgets of all applications. A large part of the expenses is detailed personnel costs. Up to now, professors have had to insert this from the public pay scale tables by hand – a time-consuming process.

“Around 2,000 professors and their staff apply for research funds each semester. All applications must be carefully reviewed. By using an app, the budget calculation is much faster, standardized, and always with up-to-date data.”

Dr. Christoph Raiser, Team Leader/Manager External Funding Research, Service Center Research of the Humboldt-University, Berlin

As this often involved overwriting existing applications or using outdated pay scale tables, the review and correction of applications were also time-consuming and required a great deal of communication between the applicant and the processor.

Solution

In order to make the application process for research projects more efficient, Humboldt University is taking a new approach. A standardized Excel spreadsheet lists all relevant data from standard wages to health insurance contributions. However, the Excel solution itself is too complex to be distributed directly.

Humboldt University

With the new app the personnel costs for applications of research projects are calculated.

With Open as App, the team of third-party funded research uses the existing spreadsheet to create an app in a short time that makes the complex calculation simple and user-friendly. The existing logic of the Excel file with formulas and dependencies is also available via the app and is displayed in such an optimal way that each user only sees and calculates the data he or she needs at the moment.

All details such as hourly duration, salary level or part-time employee are displayed.

After the calculation, the relevant data for the salary breakdown is broken down in detail. The app and data source remains connected so that every change in the Excel sheet is immediately available in the app.

The Humboldt University team can, therefore, continue working in the familiar Excel file while the professors access the user-friendly app.

“There are several thousand research proposals at Humboldt University each year. Even saving half an hour of time per project has an enormous impact. With Open as App, we can always distribute our data correctly and in a user-friendly manner and thus work much more efficiently.”

Dr. Christoph Raiser, Team Leader/Manager External Funding Research, Service Center Research of the Humboldt-University Berlin
Humboldt University

The personnel calculator app is embedded into the service websites of the Humboldt University

Result

The personnel calculator app is well received by the professorial community. A large number of them now use the service website with the embedded app to calculate the costs of personnel requirements in research projects.

This significantly reduces the workload of the third-party funding teams when reviewing applications.

“The creation of apps with Open as App is just right for digitization at the university. Fast, uncomplicated, and cost-effective. We have received very positive feedback on the website and calculation app. It is easy and intuitive to use and provides optimal support for our internal organization.”

Dr. Christoph Raiser, Team Leader/Manager External Funding Research, Service Center Research of the Humboldt-University Berlin
Humboldt University

Kategorien

Beliebte Ressourcen

Alexandra Müller

ARAG

Insurance

Alexandra Müller

Department of Education, The Philippines

Public Sector

Alexandra Müller

Humboldt University

Education

Alexandra Müller

MedUni Vienna

Healthcare

Alexandra Müller

Schoellershammer

Manufacturing

Alexandra Müller

SDK Group

SDK group Excel to apps

Alexandra Müller

On-Premises Gateway

On-premise

Alexandra Müller

Security

Security

Alexandra Müller

SharePoint Integration

SharePoint Integration

Alexandra Müller

Armstrong International

Armstrong International No-Code Apps

Alexandra Müller

Wageningen Plant Research

Experts use app to consult smallholder farmers

Alexandra Müller

RCG Valuation Creates Customer Self Service App without Coding

white and blue glass walled high rise building

Alexandra Müller

HM Carport – Mobile Quote Apps for Carports Sales on the Go

green grass field with trees under blue sky during daytime

Alexandra Müller

Timesheet App for Ringlink Scotland

aerial view of two harvesters on brown field

Alexandra Müller

Coastal Safety Group

Tony Blunden Coastal Safety Group at a beach

Alexandra Müller

KLC Group

Forklift on storage ground

oaaadmin

Share your app

greyd-ImgPh-dark-wide

Alexandra Müller

Siemens Financial Services

Siemens using no-code apps

Let’s keep in touch!

Newsletter-Girl
Siemens using no-code apps

Alexandra Müller

Siemens Financial Services