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.
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.
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.
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.
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.
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.
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.
In this example, the KPI targets and performance are managed and the result therefore is linked to the human resources evaluation system.
The employee uses the balanced score card for analysis, consults with their supervisor, sets targets for the KPIs, and inputs them on this screen.
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.
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.
Now, I will demonstrate the details I have just explained.
Now, let me summarize the effects of introducing this 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.
Now let’s move along to demonstration.
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.