EXCEL 2020-11

COMMUNITY・FAMILY・COMPANY DOCTOR = VITAL

血液（Blood Liquid）・大脳生理（Big Brain Grow Reason）

・精神（Spirit God）

PHILIPPINES: USBONG CONTINUES TO PROVIDE

COMPUTER SERVICE ASSISTANCE

BY SHARING KNOW-HOW ON MAPARAANG PAGBIBILANG

November 2020

To eliminate excess steps and inefficient time usage, Marikina Orthopedic Specialty Clinic (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) Continued to update Knowledge Management System (KMS)

1.1) added: in Non-medicine Item Page, Value-Added Tax (VAT) cell with auto-computed value

--> +added: cell with auto-computed value of discount for patients classified as SC/PWD

--> where: SC = Senior Citizens (SC); PWD = Persons with Disabilities

--> These actions assist Unit members with Official Receipts.

--> In addition, these are based on feedback after actual use by Unit members.

1.2) added: in system snack items

--> This action is to solve problems with computer auto-generated report does not include snack count and income, in contrast to Cash Register report.

--> In addition, we note that entering of patient transactions to computer database is at times executed after noon.

--> This occurs when paying patients increased to form a wait list.

--> Recommended Action from Unit Member: Receive assistance to process an increased number of paying patients

--> We add that the computer auto-generates the unified and non-unified snack reports.

--> where: non-unified = time-based list; unified = list that combines items whose item identifications are equal

1.3) added: system notifies Cashier Unit member if patient name is not included in the Cart List

--> This action is to solve the problem of no patient name in the auto-generated Official Receipts (OR) Reports

--> Recommended Action: Reuse tool as part of point card system

--> This action identifies patients who buy from MOSC, their place of residence, also in Barangay STO. NIÑO, Marikina City, etc?

--> Community・Family・Company Doctor = VITAL

1.4) updated: system to fix auto-computed total fee and count report problem when the same patient has already paid and comes back to buy another set of items/services

1.5) updated: system to set maximum execution time for any request to be 300seconds

--> I note that this is due to the size of our database now requires maximum execution time to be more than 30seconds.

--> Problem already occurs with command: viewReportMedicineUnified.php

--> In addition, we can reduce the main database size by making smaller database sub-sets from it.

--> These sub-sets contain transactions that are less often used, e.g. those from a previous year.

1.6) continued: to share printed Usbong Newsletters to Salespersons in Barangays Sta. Elena and San Roque

+observed that due to Typhoons, e.g. Ulysses, select roads become muddy and slippery

--> We can still walk, albeit with caution, from Barangay Sto. Niño to Sta. Elena and San Roque.

--> +observed: E. Manalo Ave., Sto. Niño, in front of USBONG HQ and MOSC HQ Building (Postal Number: 1820)

--> Water level of the flood did not become so high that we had to move items to higher ground.

--> Water level became lower by 17:00 after the Typhoon hit Marikina City.

--> +verified: Newspaper Salespersons in Barangays Concepcion Uno and Dos, Marikina City

--> Barangay Concepcion Uno: Near the Puregold Supermarket and McDonalds Fastfood Restaurant, the Newspaper Salesperson does not yet sell "Balita".

--> Barangay Concepcion Dos: I did not yet find Newspaper Salespersons even near a Bakery.

--> We can establish partnerships to build points where people can get the printed Usbong Newsletter.

--> This is in addition to the digital version.

--> By sharing know-how and information, we can increase the skill level of the population in the barangay, the city, the main island of Luzon, the whole Philippines, the Asian continent, the whole world, the beyond, and outer space.

--> Recommended Reading: Enix. (1995). Dragon Quest VI: Usage and Explanation Book/Manual (translated from nihongo by SYSON, MICHAEL B.; Super Family Computer version). Tokyo: Enix Stock Corporation

NOTE (from SYSON, MICHAEL B.):

2) Requested: PhilHealth via email that the Total Amount Due in the auto-computed PhilHealth Statement of Premium Account (SPA) Form already be rounded to become whole numbers, i.e. integers.

--> This is so that when we pay our contributions in cash, the totals and the received change are 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 eliminate the centavo coins.

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

--> Action: Count combinations of 0.01, 0.05, 0.10 centavo coins until you reach 1.00

--> We humans counting by hand these combinations of centavo coins causes inefficient usage of time.

--> We would rather use available time to do other things, especially when we reach our 60’s.

3) Added training course on Introduction to Computer Networks

--> The sets of instructions are already available to the public from the Open Source Community.

--> We at USBONG updated the sets to execute on LUBUNTU machines.

--> We shall verify adding Windows machines.

--> We note that the sets use the Berkeley Software Distribution (BSD) sockets.

--> These are available with Linux and UNIX-like machines.

--> In addition, we use the C Computer Programming Language.

NOTE (from SYSON, MICHAEL B.):

4) Added training courses on Introduction to Maparaang Pagbibilang

--> 3.1) Algebra, i.e. use of containers whose value inside may vary

--> 3.2) Coordinate System to identify positions in the x, y, and z-axes

--> 3.3) 2D Shapes, e.g. square, triangle

--> 3.4) 3D Shapes, e.g. cube

--> 3.5) Trigonometry, i.e. identify positions using angles and distances of shapes, e.g. in particular, triangles

--> shared: with Unit members questions as review of each Maparaang Pagbibilang concept

--> We classify the difficulty of all skills to be Middle ~ High School level.

--> Unit members who can answer the questions correctly need not do additional questions as a form of repetitive exercise.

--> We note that Unit members are reminded to write the names of the people they worked with after finishing each question.

--> In addition, by identifying each Unit member's present skill level, we can request Unit members to assist in Computer Service Automation based on their level.

--> We learned that the list of concepts, e.g. Algebra, can be used with computers using any computer language.

--> Indeed, the purpose of computers is "to compute".

--> The objective of which is for us to receive as output: Information.

--> However, from observation, those who have already received an introductory training on Maparaang Pagbibilang do not necessarily advance to learning Computer Languages.

--> This tendency is due to the training system.

--> Computers become noticeably useful when the number of transactions that the trainees count exceed 1000 per year.

--> Action: Count the global population size; Select reports share that it already exceeds 6 Billion.

NOTE (from SYSON, MICHAEL B.):

5) Added Case Study on Nippon Telegraph and Telephone (NTT) corporation

--> We emphasize mathematical optimization promotes communication.

--> Example Problem: SONY PlayStation Hardware Sales Forecast overly optimistic;

--> Result (1997): Warehouse (Japan): Excess Stock X 500~600K @USD180 each; Loss: USD108M

--> Solution: Hardware Expansion via Software Profit

--> Software Profit via Repeat Production using Compact Disc (CD) technology

--> PlayStation Sales Results: 1.78 price elasticity

--> where value <1 = necessity, i.e. people buy with less and less regard for price

--> Example (at present): insulin medicine

--> Philippine Context Action: Ayusin via Maparaang Pagbibilang ang sistema sa Pinas upang may 1.78 price elasticity ang PlayStation sa "general public"

--> Reference: Asakura Reiji's "Revolutionaries at Sony".

NOTE (from SYSON, MICHAEL B.):

6) Continued to work with the Sta. Lucia Health Care Center (SLHCC)'s Accounting Unit

--> This is with regard to remaining uncollected Cash and unpaid Health Maintenance Organization (HMO) transactions

--> +observed: increased elaped time in identifying uncollected cash payments from previous weeks

--> Previously, unpaid cash was for the week only.

--> Action: -add: auto-identify previous weeks to reduce elapsed time

--> We note that elapsed time of going to SLHCC Unit every Monday~Saturday is still longer.

--> This is due to Traveling Time (26mins x2) and Waiting Time (at least 60mins).

--> +updated: set of instructions to auto-verify paid HMO transactions

--> +updated: set of instructions to auto-generate unpaid HMO Summary Reports

--> Example: Unpaid HMO transactions (2019)

--> The delay is due to among others:

--> 6.1) Select HMO Offices were closed during the CORONA VIRUS 2019 (COVID-19) Quarantine Lock-down

--> 6.2) Select Unit members were attacked by the budol-budol/manloloko/carnapper/communist terrorist/cybercriminal group, who still even now continues to use wireless broadcasting technology to cause physical injury,

--> e.g. cough, ear and throat itch leading to pain, breathing/cardiac problems;

--> reminder: Ear, Nose, and Throat (ENT) are connected

--> We emphasize 6.2) due to the additional stress that it creates, thereby causing select Unit members to do the following:

--> 6.2.1) opt to rest, 6.2.2) undergo therapy, and 6.2.3) eventually resign

--> Unfinished work is then carried by remaining Unit members in addition to their present workload.

7) Updated Training Centre: Security Defense Force to include Introduction to Self-Defense Parts 1 and 2

--> Mungkahing mga Aksyon:

--> 7.1) Puksain ang mga budol-budol/manloloko/carnapper/communist terrorist/cybercriminal group na gumagamit ng wireless broadcasting technology upang gumawa ng mga panlolokong ingay at pisikal na pananakit.

--> 7.1.1) Halimbawa ng Panloloko:

--> May nakikita kang mga larawan/imahe o may naririnig kang mga bulung-bulong ukol sa mga yumaong kilala o mga anghel/demonyo na sinusundo ka na.

--> Paalala:

--> Hindi ito tulad ng iyong radyo o television na madali mong maisasara kung nais mo gamit, halimbawa, ng POWER OFF button nito.

--> 7.1.2) Halimbawa ng Pisikal na Pananakit:

--> Gamit ang baterya ng sasakyan, pasadahan mo ng kuryente ang isda sa ilog. Makikita mo na mahihilo ito at madaling kunin gawa ng hindi na ito mabilis na makalangoy upang makaiwas.

--> Kapag direkta mo namang tinusok at pinasadahan ng kuryente mula sa baterya ng sasakyan ang palaka, makikita mong manginginig ito.

--> Paalala:

--> Alalahanin na maaaring dumaloy ang kuryente sa hangin, i.e. wireless.

--> 7.2)「お悩み12：どこでも誰でも簡単にできるストレス解消法」

--> "Iyong Alinlangan#12: Simpleng paraan ng paglabas ng istres: Saan man, kahit sino"

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

--> Ito'y kapag nakararanas ka ng istres dahil ang pakiramdam mo, wala ka nang kontrol sa mga nangyayari.

--> 7.2.1) Gumawa ng Prediction

--> Kung alam mo na ang mangyayari, hindi ka na kailangang mag-alinlangan.

--> Kung hindi mo alam kung ano ang mangyayari, dahil mulat ka sa iyong nararamdaman, maisasaayos mo ito.

--> 7.2.2) Maglakad

--> Move your left foot, say out-loud "left"

--> Move your right foot, say out-loud "right"

--> 7.2.3) Huminga

--> Breathe slowly; Exhale slowly

--> 7.3) Sanggunian:

--> 7.3.1) Marikina City Ordinance Enacting the Noise Control Regulations (ORDINANCE No. 100 Series of 2010)

--> 7.3.2) Fujitsu Group Total Life. (2008). Information Magazine: プラスワン（Plus 1） (No. 74, Summer 2008). Japan: Fujitsu Health Insurance Group et al.

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

--> recommended: max traveling time (to workplace): 1 hour

--> recommended: max traveling time (return home): 1 hour

8.1) Verified: with TOMICA distributor ToysRUs Philippines regarding availability of BitChar-G 二カド電池 (Ni-Cd Battery)

--> learned: at present, not available

Radio Control (RC) machine

NOTE (from SYSON, MICHAEL B.):

8.3) Added: references materials

--> shared: with Unit members that using computers, we already have the tools to build an engine

--> Recommended Action: share know-how on Maparaang Pagbibilang

MOJANG MINECRAFT: The Survivors' Book of Secrets

NOTE (from SYSON, MICHAEL B.):

9) Shared Information via among others: available used books, brochures, computers, printers

--> Example: Villanueva, Rene (Anvil Publishing, Inc.)'s "Mahiwagang Ibong Adarna At Iba Pang Dulang Pang-Elementary"

--> +added: paper marks to identify pages to emphasize:

--> "Mahiwagang Ibong Adarna" page49; "Ang Gamugamong Naakit sa Liwanag" page33

--> This action pertains to the company system where the older sibling shares with younger sibling.

--> Example: Instead of the younger sibling buying a new set of school books, he can receive the set that his older sibling used.

--> At USBONG, we also repair among other Information Technology (IT) tools: computers, scanners, and printers

--> Any Unit member who has sufficient know-how and is willing to make time to fix available tools can use them.

--> In addition, when an office or workplace upgrades their machines, we can buy those used items.

--> We then transfer the items that we had been using to Unit members who request for their use.

10) Shared Information on Energy and Health

--> +reminded: Unit members and patients who visit MOSC the value of physical activity

--> Select medicine items are not effective without accompanying physical activity.

--> recommended: 20mins of continuous walking everyday;

--> however, those that eat more also need to increase their physical activity

--> Example: skip ropes x800; if going from 1~800 is too challenging, begin first with smaller sets, e.g. set of 200 x4

--> In addition, correct technique prevents among others: back pain and slipping on the floor.

--> Ang ating dugo ang nagdadala ng pagkain, i.e. energy, sa mga cell ng ating katawan.

--> Kapag umiinom tayo ng gamot, lalo na ang mga may kailangan ng receta, nagkakaroon ng lason, i.e. toxic, sa dugo.

--> Ang ating liver ang pangunahing naglilinis nito.

--> Kaya lang, kapag labis-labis ang pag-inom ng gamot, hindi na makakayanang linisin ng liver ang lason.

--> Nagdudulot ito ng mga problema sa ating pakiramdam.

--> Dahil dito, maiging alamin bukod sa pag-inom ng gamot, kung ano ang maiging paraan ng paglunas,

--> e.g. lifestyle change to increase physical activity, eat nutritious food, e.g. vegetables,

--> whose total weight you can carry using a basket

--> Reminder: avoid eating pork/swine and food made from animals/insects, e.g. rats, cockroaches, that eat dirt

--> We add that with this action, we learn to identify and classify what we eat.

NOTE (from SYSON, MICHAEL B.):