top of page
작은 시작 DX/Excel VBA
대응 사례 일람
지금까지 대응한 사례를 일람으로 게재
현장에서 도움이 되는 팁이 되시면 감사하겠습니다.
Nursing care facility shift schedule
Automatically allocate multiple shifts, such as early shifts, late shifts, and night shifts, while meeting employee requests
Drug database collation
A database was created by comparing the list of prescription drugs published by the Ministry of Health, Labor and Welfare with data from research institutions based on drug names.
Welding qualification management work efficiency tool
Streamline the complicated work of managing welding qualifications with Excel VBA. Eliminate dependency on individuals through paper-based operations and automated processing suited to the workplace.
Cooperation between pharmacists and pharmacies for customer service and accounting
A case study of digital transformation in pharmacy operations. A system was built to streamline operations by linking the four parties of pharmacists, pharmacies, accounting, and customers using Google Spreadsheets and GAS, and centrally managing everything from dispensing to billing, shipping, and payment.
Shift management tool for home care
Create shift schedules for staff and users
Automatically create performance records
Email notifications to staff and automatically register individual employees to Google Calendar
Automatically create performance records
Email notifications to staff and automatically register individual employees to Google Calendar
Automatic generation of welding robot teaching data
We will introduce a case where teaching data for welding robots at a shipyard is automatically created using Excel VBA. This case also supports labor-saving in creating commands and automatic generation of STL data for simulation, resulting in improved efficiency and quality on site.
Hospital duty schedule
40 doctors, automating the even allocation of on-call doctors by medical specialty for three months
Inventory management for auto parts factories
Inventory management tool for 500 different parts.
Designed to withstand tight schedules from prime contractors.
Designed to withstand tight schedules from prime contractors.
Calculating payroll based on working hours
An automated payroll calculation tool that uses information on arrival, departure, and break times to match the rules of the consulting company.
Automatic creation of CSV data for e-commerce sites
In response to changes in the e-commerce site's specifications, we developed a tool that can rewrite all of the original data (CSV) for 10,000 product pages.
Black box tool improvements
We fixed an Excel tool that could no longer be maintained due to the employee's retirement. We also realized new customization.
Event attendance management system
Manage event attendance with QR codes
Shift creation support tool for childcare workers
Built to streamline the process of creating shift schedules for childcare workers in Excel
Building a CDP scoring automation tool
We built an automated scoring tool that supports all questions (approximately 700 items) in the CDP (Carbon Disclosure Project). Scoring work, which previously required a huge amount of time and manual work, was converted into an Excel-based system that can be processed instantly. This is an example of development that was handled entirely in-house, from structuring the rules to building the logic.
A gross profit and marginal profit aggregation tool that automates Rakuten Ichiba's expense management
Reads the order CSV and invoice CSV data output from the RMS and automatically calculates marginal profit and operating profit. Visualizes monthly data and makes profit structure visible.
For welfare facilities: Excel tool to automate monthly nursing care supplies tasks
Setting individual copayment rates (0%, 10%, 20%, etc.) for each user
Determining public funding eligibility/exclusion rules for certain items
Calculating copayment amounts above a certain amount
Creating documents (receipts, etc.) according to submission formats
Determining public funding eligibility/exclusion rules for certain items
Calculating copayment amounts above a certain amount
Creating documents (receipts, etc.) according to submission formats
A tool to streamline the creation of general-purpose documents such as medical certificates
To essentially reduce the burden of writing template sentences, we developed an Excel VBA "automated template sentence input tool." This tool aims to significantly reduce the time-consuming and cumbersome manual work required, freeing up time to focus on core business tasks.
Daily report input and aggregation system
When entering daily reports, it is extremely important to be able to do so quickly and without stress. This system is equipped with a wide range of input assistance functions that are "as intuitive and easy to understand as possible, and that also reduce work time." Specifically, these include "reducing manual input by completing the mouse operation" and "time can be entered using only the numeric keypad."
School uniform measurement input + order form creation tool
The approach is to input simple combinations of numbers or letters and have them automatically converted internally (e.g., "11" to "jacket," "23" to "slacks," etc.). With this method, as users become more proficient, the operation becomes more familiar to their hands, and they can work smoothly, just like playing a typing game.
Automatically create fax cover sheets for visiting nurses with a double click
A visiting nursing service wanted to streamline its fax sending operations.
This service was creating fax messages to other services in Excel.
Currently, they were creating faxes by copying and pasting the service name and recipient's address from a list of services, which led to selection and input errors. Because faxes are sent frequently, the amount of input work required is increasing.
They contacted us to discuss ways to reduce the hassle of manually adjusting the address and message for each recipient.
This service was creating fax messages to other services in Excel.
Currently, they were creating faxes by copying and pasting the service name and recipient's address from a list of services, which led to selection and input errors. Because faxes are sent frequently, the amount of input work required is increasing.
They contacted us to discuss ways to reduce the hassle of manually adjusting the address and message for each recipient.
In-house system automation development support
Developed an Excel tool to automate our company's proprietary system.
Developed a tool that would only work in the client's environment, checking the situation through online communication only.
Developed a tool that would only work in the client's environment, checking the situation through online communication only.
Development of investment tools
Development of investment tools using Rakuten RSS
Developing a custom system that enables investors to more quickly implement their unique trade monitoring and order placement know-how
Developing a custom system that enables investors to more quickly implement their unique trade monitoring and order placement know-how
Structural calculations for buildings in the construction industry
A system that automatically calculates the outer shape of each room based on 2D data of a house's floor plan. A program that combines multiple adjacent polygons.
Gantt chart optimization of machine and human movements
Automatically generate a Gantt chart that minimizes the movement of three or more machines and the operators.
The time required for preparation, removal, operation, and inspection of each machine is determined, and the time required to achieve the planned production volume is minimized.
The time required for preparation, removal, operation, and inspection of each machine is determined, and the time required to achieve the planned production volume is minimized.
bottom of page