EXCEL 2021-01

1.1.2) Problem: Wait List at the Accounting/Cashier Unit

--> Solutions:

--> 1.1.2.1) +added: in patient wait list, Elapsed Time to Done and the Average Wait to Done Time

--> notifies: Unit members via wait list's "DONE! START TIME?" when patient transaction reached Accounting/Cashier Unit, without being added at Info Desk Unit.

--> 1.1.2.2) +updated: instructions so that computer auto-adds in combined transaction notes "MED ONLY", "NON-MED ONLY", "SNACK ONLY", and combinations of these, e.g. "NON-MED, SNACK ONLY".

--> Previously, Unit members had to add by hand these keywords in the notes.

--> Now, the computer auto-identifies based on the number values for the fees, which also include X-ray and Lab fees.

--> 1.1.2.3) +noted: at present, another Unit member provides assistance to quickly eliminate the wait list.

--> Total: more than 2 Unit members work on the cash payment collection at the Accounting/Cashier Unit

--> The Information Desk Unit provides additional Unit members.

--> We use tools, e.g. Tablet Personal Computers (PC) (wireless) and PC (wired).

--> This is to quickly identify the price of items, e.g. medicine and non-medicine.

--> Indeed, we do not quickly eliminate the wait list if the Accounting/Cashier Unit and the patients have to wait for the one (1) person with the know-how to finish.

--> Recommended Action: Continue with sharing know-how, such that Unit members (and even patients) advance to the next level, instead of stagnating in the same skill level for years and years to come.

1.1.3) Problem: Low-level Unit members remain stagnant in skill-level and company income contribution

--> Recommended action: learn whole system

--> where: "whole" = "integer", i.e. integrated

NOTE (from SYSON, MICHAEL B.):

1.1.4) Problem: text, e.g. numbers, letters, on the Computer Monitor is difficult to read

--> Solution: We can use the zoom tool to make the text larger

--> Additional Note: We remind Unit members to use computer, e.g. Tablet Personal Computer (PC), Mobile Computer, for max time of 30~60mins only; afterwards, execute another action away from Computer Monitor

NOTE (from SYSON, MICHAEL B.):

1.4) updated: set of instructions to speed-up KMS

--> deleted: excess steps, e.g. JOIN commands for computer to access multiple spreadsheet tables in the database

--> Example: ACECLOFENAC (DICLOTOL) 100mg; Cashier Personal Computer (PC); wired network connection

--> view medicine item page command elapsed time (previous): 23, 27, 22, 30seconds

--> view medicine item page command elapsed time (now): 5, 6seconds

NOTE (from SYSON, MICHAEL B.):

1.5) updated: KMS to auto-identify and write the year now

--> This is to solve the problem of my having to edit the year every new year.

--> We use the following Computer Languages among others:

--> 1.5.1) PHP Hypertext Preprocessor Computer Language

--> 1.5.2) Java Computer Language

1.6) updated: KMS to auto-generate reports with charts

--> Example: Bar Charts

--> We auto-generate the output charts using Microsoft (MS) EXCEL.

--> It is faster to save the worksheet as .html with the charts as image files than using additional tools and Computer Language.

--> We add the phantom.js tool to save as a whole photograph the output that is viewable on a Computer Web Browser.

--> At present, it is faster to view by a human person this photograph file via network sharing tools, e.g. Viber, Gmail.

--> Reminded: Unit members to use activated software, e.g. Microsoft Office, Microsoft Windows Operating System (OS).

--> As alternative, we recommend what we use: LibreOffice and LUBUNTU 20.04 (LTS) OS.

--> observed: noticeable delay, if not failure to finish execution, in opening and saving MS EXCEL workbook files (size: at least 800KB) using LibreOffice Calc and computers with 32-bit OS system type

--> At present, we save the worksheet of the MS EXCEL workbook as .csv (comma-separated value) file.

--> This .csv file is what we open and verify with our LibreOffice Calc workbook file.

--> Additional Note: There is still noticeable delay when saving the LibreOffice Calc workbook, albeit the execution finishes.

--> We can still speed-up execution by deleting excess worksheets in the workbook.

--> At present, the file size of our workbook with 2 years of data does not reach 900KB.

--> A 3.5inch high-density diskette can store 1.44MB (max).

--> We add that media files, e.g. photographs, sound, videos, i.e. sequence of photographs with/without sound, cause rapid increase in used file storage size.

1.7) continued: to share significance of Information Technology

--> where: technology, e.g. computers, printers

--> コンピュータ(computer) 情報(information)

--> Recommended action: share information classified to be with Maparaang Pagbibilang, i.e. not emotional/unclear

--> Minecraft: Report Contact Consult

--> Translated from nihongo to English by SYSON, MICHAEL B.

--> Minecraft Playstation(R)3 Edition

--> Reminder: With computers, there is a tendency to gather information in excess.

--> The solution can be as simple as improving interaction between Unit members, including the patients.

--> Recommended Reading: Jeffrey Liker's "The Toyota Way"

2) Continued with Research & Development (R&D): Automotive

--> 2.1) Usbong CAD (Computer-Aided Design)

NOTE (FROM SYSON, MICHAEL B.):

--> 2.2) Usbong OpenGL (Graphics Library) and Usbong Engine

--> executed: stress test for computer to auto-draw via 3D grid using tiles as cube

--> verified: increasing 2x window width and height to be 4096

--> verified: increasing 2x grid max row and columns counts to be 40

--> 2.2.1) verified: using the following computer specifications

-->2.2.1.1) Computer #1

//Processor: Genuine Intel(R) CPU T2130 @1.86GHz

//RAM: 3.00GB (2.87 GB usable)

//System type: 32-bit Operating System (OS)

//OS: Windows 7 Ultimate (C) 2009 Service Pack 1

--> 2.2.1.2) Computer #2

//Processor: Intel(R) Celeron(R) CPU N2940 @ 1.83GHz

//RAM: 2.00GB (1.91 GB usable)

//System type: 64-bit Operating System (OS)

//OS: LUBUNTU 20.04 LTS

--> 2.2.2) Results:

--> 2.2.2.1) Computer #1: Noticeable delay in auto-draw

--> 2.2.2.2) Computer #2: No noticeable delay in auto-draw

--> 2.2.3) Solution: in main set of instructions, lower auto-draw delay number to update whole canvas

--> 2.2.4) Additional Notes:

--> 2.2.4.1) lowering auto-draw delay causes smoother, i.e. not skipping, animation sequences

--> 2.2.4.2) verify: adding delay in RobotShip's own movement animation due to noticeably excessively quick

--> 2.2.4.3) Using auto-scaling technique to make all objects smaller did not solve the noticeable delay in auto-draw

--> 2.2.5) OpenGLCanvas: myWindowWidth x myWindowHeight; 6144 x 6144

--> Grid: iRowCountMax x iColumnCountMax; 30 x 30

NOTE (from SYSON, MICHAEL B.):

2.2.6) +added: dash command for RobotShip to move x2 faster

--> Pilot notifies RobotShip by pressing directional key x2 to move, with the second press held.

NOTE (from SYSON, MICHAEL B.):

--> verified: if dash command instructions causes excess RobotShip movements

--> This is when pressing directional keys to execute rotating movements.

--> At present, the RobotShip executes no excess movements using Linux and Windows machines.

NOTE (from SYSON, MICHAEL B.):

--> 2.3) Usbong Mecha

--> 2.3.1) verified: techniques, e.g. 2D and 3D printing, to bring the auto-drawn 3D shapes out of the computer monitor

--> i.e. from illusion, i.e. ART, 絵画 (drawing picture), 幻影 (illusion shadow), to material object as product

--> 材料を使って物を作る = use material, make object

--> where: product = 製品 (made item), 成果 (accomplished fruit)

--> Additional Note: メーカー (me-ka-) = maker, i.e. manufacturer

--> learned: we can use an external Universal Serial Bus (USB) keyboard to receive Light Emitting Diode (LED) output via Caps Lock key input from Computer Laptop

--> 2.3.2) verified: solutions, e.g. "miniaturization", i.e. make objects smaller, to solve carrying weight problem

--> From physics, i.e. 物理 (object reason), we learn that smaller objects have less heavier weight

--> W = m * a

--> where:

--> W = weight of object due to its mass and gravity

--> m = mass of object

--> a = "acceleration" due to gravity

--> Reference: Dennis, J. (2007). "Pocket idiot's guide to physics". USA: Alpha Books

--> Recommended Reading: Asimov, I. (1987). "Fantasic voyage II: destination brain". New York: Bantam Books.

--> "miniaturization"

3) Continued Training Centre: Security Defense Force

--> 3.1) From Usbong R&D: Automotive:

--> 3.1.1) put tool close to your center position when firing beams as projectiles to quickly and correctly hit targets

--> If you put tool closer to your right side, hitting targets becomes difficult, especially when you also move your position.

--> 3.1.2) use oscillating, i.e. wave movement, with rapid firing of beams as projectiles to increase hits

--> There is a known problem with what we see, such that we do not hit targets.

--> This is even if it appears that we should have hit the targets.

--> 3.2) Question: How to solve unable to open rusted padlock?

--> Answer: Steps:

--> 3.2.1) Clean visible rust using cloth or tissue paper.

--> 3.2.2) Put oil in padlock's open portions, e.g. keyhole, top portion.

--> 3.2.3) Put key to unlock the padlock.

--> 3.2.4) If padlock is still locked using key, repeat to Step 3.2.1).

--> Additional Note: Metal rust can be due to among others: water combined with shampoo and/or soap.

--> Recommendation: For publicly accessible padlocks, e.g. for use with bicycles, use with key as physical material object, instead of those that require entering of Personal Identification Numbers (PIN).

NOTE (from SYSON, MICHAEL B.):

4) Continued to update website: WWW.USBONG.PH

--> updated: font size, font style, e.g. bold to be clearer

--> deleted: excess text

5) Continued to share Information on Energy and Health

--> 5.1) observed: select patients buy medicine items, e.g. pain relievers, due to belief that such items solves their health problem

--> reminded: patients to also verify lifestyle, e.g. physical activity.

--> 5.2) reminded: patients to verify medicine item expiration date

--> If already past the expiration date, we recommend not to take such medicine item anymore, unless certain of action.

--> From understanding, medicine items still have weeks after their expiration date, so that patients are not immediately physically injured; reminded: patients to notify us at MOSC if the expiration date is difficult to read due to the small font size, etc

--> We notify the Medical Representatives regarding feedback.

--> 5.3) observed: family members, etc who assist patients with medicine items at times do not yet have sufficient skill-level/know-how; therefore, continuing to share know-how is vital.

--> This is in addition to caring for self.

--> 5.4) observed: at Clinical Unit, due to the number of patients and lower than our recommended skill-level of Unit members, there is an increase in quick, but incorrect, outputs, e.g. blank answers to among others: occupation, body temperature, blood pressure, pulse, weight, in the patient index cards.

--> added: due to the system, which includes training and lifestyle, Medical Doctors eventually forget to care

--> 5.5) clarified: each medicine item has generic name, e.g. paracetamol, and brand name, e.g. Biogesic.

--> Another brand of medicine item with the same generic name, “paracetamol”, can be less expensive.

--> As explained by Unit members, Medical Representatives, and the Philippine Pharmaceutical Directory (PPD) book, there is no big difference between medicine items with varying brands, but have an equal generic name.

--> noted: variations of select medicine items include: can easily be crushed and have only small change in physical effects.