EXCEL 2020-09

仮想マシン : VIRTUAL MACHINE

PHILIPPINES: USBONG CONTINUES TO PROVIDE

COMPUTER SERVICE ASSISTANCE

TO MARIKINA ORTHOPEDIC SPECIALTY CLINIC (MOSC)

& PARTNER PERIPHERAL UNITS

September 2020

To eliminate excess steps and inefficient time usage, MOSC requested Usbong's services to automate routine, monotonous tasks and share with unit members know-how on computers.

Here are Key Action Items that we executed in this updates list.

1) Installed BSD (Berkley Software Distribution) Operating System, e.g. FreeBSD, OpenBSD.

1.1) learned: it is faster to use Linux to create a Virtual Box where we install BSD.

--> This is instead of immediately installing BSD on a physical machine, without the use of a host operating system, e.g. Linux.

--> In addition, Virtual Machine Images offer faster saving and transferring of data to another physical machine with Virtual Box.

--> This is due to variations in physical machine specifications, e.g. 64-bit machine architecture, CD/DVD device availability.

--> Virtual Box empowers us to set virtual specifications, e.g. file systems, Random Access Memory (RAM).

NOTE (from SYSON, MICHAEL B.):

2) Continued to update Knowledge Management System (KMS)

2.1) Added: set of instructions for a Computer Bot to automatically save the database storage from one machine to another.

--> The Computer Bot executes the following actions:

--> 2.1.1) verifies each file in the source computer's database storage

--> 2.1.2) copies from the source computer and overwrites in the destination computer only those files that are updated/modified based on their date and time stamp

--> At present, elapsed time to execute this action is 4mins.

--> In addition, the machines are connected to the computer network.

2.2) Added: Computer Bots to assist in the Weekly Payment Collection Report of peripheral Unit at our partner clinic

--> The Computer Bots auto-generate the HyperText Markup Language (HTML) web page from an input .csv file.

--> The input file is the output of a Macro, i.e. set of instructions, from a LibreOffice Calc workbook.

--> At present, we execute any additional editing in the workbook before saving as .csv file format.

2.3) Added: Value-Added Tax (VAT) checkbox for non-medicine items to eliminate excess steps.

--> We note that patients classified as Senior Citizens (SC) and Persons with Disabilities (PWD) are VAT-exempt.

--> I agree with Dr. Peter that patients classified now as PWD are not life-long PWD patients.

2.4) Verified: that with our noon report, we can finish in less than 1 minute if there are no further corrections with the Computer Report and the Cash Register Report.

--> We at the Accounting/Cashier Unit decided to execute noon reports to speed-up the verification of the day's report after the clinic closes.

--> We admit that adding in the inventory list more item variations, e.g. new medicine and non-medicine items, and executing more actions, e.g. classifying expired medicine items, cause delay.

--> However, we are now able to provide vital information, e.g. the actual total and the auto-computed total are not exact and by how much.

--> We immediately investigated the cause to learn among others the following:

--> 2.4.1) Select patients opted not to receive the exact amount, e.g. received PHP1.00, instead of PHP0.80.

--> 2.4.2) Centavo coins are not correctly counted due to the similarity between PHP0.05, 0.10, and 0.01.

Action: Count combinations of .05 and 0.10

centavo coins until you reach 1.00

--> 2.4.3) Select cashed out items, e.g. additional PHP100.00 to be PHP500.00 due to no exact bill, are not noted in writing.

--> 2.4.4) There is a correction in the computer's set of instructions to compute the total with VAT.

--> Therefore, we recommend that the totals be exact, i.e. no excess or missing amount, even the centavos.

--> I note that we have already written a request to Bangko Sentral ng Pilipinas (BSP) to already eliminate the centavo coins.

--> Amounts that still have centavos can be rounded to become whole numbers, i.e. integers.

--> The Bureau of Internal Revenue (BIR) already executes this, albeit still only in select BIR forms.

3) Shared with Unit member at Information Desk know-how on computer reporting and use of cash register

--> If the Unit member at the Accounting/Cashier Unit and I are both absent, it is vital that it is clear who the next in-command is.

NOTE (from SYSON, MICHAEL B.):

4) Notified the Philippine Long Distance Telephone (PLDT) company regarding telephone problems, e.g. no dial tone, at MOSC

--> 4.1) Verified: incident on 2020-09-05

--> 4.2) Notified: MOSC that telephone numbers, (8)941-4888 and (8)942-4011 both have no dial tone;

--> Observation: Likely due to wired device connecting both telephones;

--> Additional Observation: (8)942-4011 sometimes receives dial tone after adjusting, i.e. removing and returning wired connection, to telephone port

--> 4.3) Attempted: to contact PLDT's Customer Care via email on 2020-09-11 due to persisting problem

--> 4.4) Received: email reply to contact Customer Care via Facebook, Twitter, or Service Hotline 171

--> 4.5) Contacted: Customer Care on 2020-09-19 via Service Hotline 171

--> 4.6) Received: on 2020-10-02, after 13 days, PLDT Unit member at MOSC HQ

--> Start Service Repair Execution: 09:02; Finished: 09:44

--> Service Repair Execution Time at MOSC HQ: 42mins

--> Total Number of Days (From incident verified Until service repaired): 21 days

NOTE (from SYSON, MICHAEL B.):

5) Added in partner peripheral Unit at the Sta. Lucia Health Care Center (SLHCC) Computer Bots to assist in automatically writing and sending the day's report to MOSC HQ via the Short Messaging Service (SMS) network.

--> 5.1) Verified: Multimedia Messaging Service (MMS) not anymore available in PLDT network

--> Initially, we intended to send the reports as image files, e.g. QR codes.

Example Text Report as a QR Code Image

Automatically generated by Computer Bots

--> 5.2) Reverified: cyptographic output character encoding problem when sent to telephone network

--> Given that the available network service does not anymore accept image files, we attempted to send the report, which include not only patient information, but also the gross and net service fees, as encrypted text messages.

--> However, the text message received by the telephone at the MOSC HQ is not equal with the original message.

--> I note that the character encoding pertains to the numerical value of letters, symbols, etc.

--> For example, in ASCII, the capital letter, "A", has a numerical value of 65.

--> But because there are only 128 supported characters in the list, those that are not included do not have a numerical value.

--> In this case, the computer may automatically use a character to signify a reading error.

--> At present, we opted to send only select information, e.g. total transactions, total fees from Cash and Health Maintenance Organization (HMO) payments, without additional encryption.

Example SMS Report from peripheral Unit

with assistance from Computer Bots

NOTE (from SYSON, MICHAEL B.):

6) Requested assistance from the Marikina City Public Attorney's Office (PAO) regarding the problem with the budol-budol/manloloko/carnapper/communist terrorist/cybercriminal group.

--> I again note that the aforementioned group uses wireless broadcasting technology to cause physical injury.

--> Added: Usbong Education Training Course: Training Centre: Security Defense Force

NOTE (from SYSON, MICHAEL B.):

7) Continued with Research & Development (R&D) pertaining to energy, e.g. food, production to increase yield using less resources.

--> Added: photographs identifying and classifying plants

--> Reused: rainwater during rainy days to water the plants

--> I note that we use the rainwater that we stored inside lidless containers before the 5th day.

--> With this action, we destroy the mosquitoes that grow to fly by the 5th~7th day.

--> Noted: light and water as vital to energy production

NOTE (from SYSON, MICHAEL B.):

8) Continued to share milk, tea (green and barley), and rice subsidies to Unit members

--> In addition, we shared existing, albeit defective computers to Unit members.

--> The objective was to verify if Unit members can already repair the computers themselves.

--> This is instead of waiting for me to repair the computers.

--> The result was that we learned we need to re-train with each other.

--> This is due to know-how unused is forgotten.

9) Added training courses on Image Processing Automation

--> 9.1) verified: automatic conversion of index cards into digital format

--> At present, processing takes at least 4 minutes per set of two index cards.

--> This includes putting the index card to the scanner and notifying the Computer Bot to begin scanning.

--> 9.2) verified: automatic counting of shapes

--> This is to solve the problem pertaining to counting by hand medicine tablets/capsules, which are priced at PHP12~15 each and can total from 20 pieces to 60 pieces per patient.

--> We already verified in a recent report that we lost 2 tablets.

--> In addition, we intend to reuse this technology in white/red blood cell counting, etc.

--> 9.3) verified: automatic drawing of shapes

--> This is to remember previously learned know-how and advance further.

--> I note that we already have the set of instructions for the computer to draw a square grid and a red square that we can move using the directional keys.

--> In addition, we can already rotate the grid to be isometric in view.

3-Dimensional (3D) image auto-drawn

by a Windows Machine

--> I add that in 8 days we were able to make time to quickly write the sets of instructions for three (3) Operating Systems, i.e. Windows, Linux, and macOS.

--> We already shared these sets of instructions to the public.

--> 3D images empower us to first create virtual objects that we can verify before manufacturing/printing to reduce costs.

--> Previously, 2D images in the form of sprite sheets were drawn by hand to achieve an output for multiple angles.

--> With 3D images, we can also quickly do among others: increase/decrease the size of objects using scaling.

NOTE (from SYSON, MICHAEL B.):

10) Added reference materials for Case Study on Nippon Telegraph and Telephone (NTT) corporation

--> We emphasize mathematical optimization promotes communication.

--> We first use examples from Asakura Reiji's "Revolutionaries at Sony".

--> We add application examples in the Philippine context.

NOTE (from SYSON, MICHAEL B.):