Japanese (日本語)

dbSheetClientVideo Tutorials

This page explains main features of dbSheetClient. And demonstration of each program presents how dbSheetClient actually works.
* Any name of a person or an entity that appears in the demo are fictitious.
Double click to Full Screen.

The Ability Evaluation System


1. The Ability Evaluation System

Many corporations perform their personnel ability evaluations as Excel form work. They create evaluation sheets in Excel, distribute them to employees, have employees perform self-evaluation, then supervisors collect those sheets and perform supervisor evaluations. Then, finally, General Affairs collects and manages these sheets. This is the usual work flow. However, many companies have a great deal of difficulty in carrying out this work. This is because managing an Excel book for each employee creates cumbersome work.


2. Demonstrations of The Ability Evaluation System

We will introduce the sample system we will be using for this demonstration. Generally, the difficult part of establishing this kind of ability evaluation is how to create the ability evaluation standard. For this sample, we will use the vocational ability evaluation standards arranged by the Japan Vocational Ability Development Association, a special private corporation under the Ministry of Health, Labour and Welfare.


Incremental budgeting and forecast/result management


1. Incremental budgeting and forecast/result management

dbSheetClient makes Excel a web-enabled system, directly connecting Excel to a database.Therefore, it is a tool that benefits greatly from the application of routine Excel operations.
Here, we would like to introduce a prototype system for creating a budget in the form of an income statement and managing budgets and results, which are the most typical types of routine Excel operations.


2. Incremental budgeting and forecast/result management demo

First, let’s view the windows that a manager uses to prepare a budget using an incremental method. This system allows us to use an incremental approach to derive the figures.


3. Incremental budgeting and forecast/result management demo ( the work flow)

Next is from the viewpoint of the director. Let’s examine the work flow. We can see that there are three sections under the jurisdiction of the director, as well as the status for application approval.Here you can press the "Aggregate confirmation”button to confirm the status of budget aggregation in these three sections.


PSI


PSI

We will demonstrate the improvements in product planning accuracy by sharing a sales plan from the sales department.First, from the opening screen, we go to the window where sales personnel input the sales plan.


KPI Management using Balanced Score Cards in dbSheetClient


1. KPI Management using Balanced Score Cards in dbSheetClient.

In this example, the KPI targets and performance are managed and the result therefore is linked to the human resources evaluation system.


2. The demonstration of KPI Management using Balanced Score Cards in dbSheetClient.

The employee uses the balanced score card for analysis, consults with their supervisor, sets targets for the KPIs, and inputs them on this screen.


3. The results from installation of KPI Management using Balanced Score Cards in dbSheetClient.

Lastly, let's list the results from installation.
If you would like to know more about this product, please feel free to inquire at our company.


The Sales Forecast Management System


1. The Sales Forecast Management System.

In this presentation we will introduce the Sales Forecast Management System developed by dbSheetClient.This system, used in our company since last year, allows us to manage sales forecasts for three months into the future.


2. The demonstration of the Sales Forecast Management System developed by dbSheetClient.

Now, I will demonstrate the details I have just explained.


3. The effects of the Sales Forecast Management System developed by dbSheetClient.

Now, let me summarize the effects of introducing this system.


PL Monitor System


1. PL Monitor System.

This system is also being operated in our company since last year. It allows us to manage forecasts for our PL statement for the next three months.


2. The demonstration of PL Monitor System.

Now let’s move along to demonstration.


3. The effects of PL Monitor System.

I would like to summarize the effects of introducing this system.
First, the latest data in the database is always shown, so you don't need to worry about managing updates of the data.
Second, management of privileges provides a highly secure environment in which reliable data can be shared.
Third, changes in the forecast for the next three months can be viewed on a weekly basis, allowing the prompt formulation of countermeasures.
Fourth, information can be shared by all employees, allowing everyone to be aware of difficult situations in times of economic stagnation.
Fifth, each employee begins to develop a feeling for management.
This concludes my introduction of the PL Monitor. For more information, please don't hesitate to inquire at our booth. Thank you for your attention.