Excel for Healthcare Data
Excel for Healthcare Data
A comprehensive Excel guide covering XLOOKUP, PowerQuery, Pivot Tables, data validation, and data cleaning functions — focused on healthcare data workflows.
I'm a board-certified Occupational Medicine physician with a Master's in Health Research and Management, and a self-taught software developer. I create web and desktop applications that solve real clinical problems, from automating health checkup data entry to building patient-facing health record systems.
Interests
— research
Education
Current Positions
Occupational health consultations and employee health management at a major private hospital group.
Medical advisory and full-stack development for a health-tech company focused on personal health records and NFC-based health data.
Experience
Clinical occupational medicine, health surveillance programs, and in-house software development for the department.
Occupational health consultations and employee health management at a major private hospital group.
Medical advisory and full-stack development for a health-tech company focused on personal health records and NFC-based health data.
ระบบติดตาม KPI อาชีวเวชศาสตร์
Dashboard system for tracking and monitoring operational performance indicators (KPI) across occupational medicine departments in the Bangkok Hospital network, with data visualization and team management.
ระบบทดสอบสมรรถภาพร่างกาย BAFS
Physical fitness testing and tracking system for Bangkok Aviation Fuel Services (BAFS) employees, developed in collaboration with Bangkok Hospital's Center of Excellence in Occupational Medicine.
ระบบประเมินการยศาสตร์ ErgoTrack
Intelligent ergonomics assessment platform for evaluating and managing workplace ergonomic risk factors in office environments, with systematic risk scoring and team management tools.
ระบบจัดการสุขภาพการได้ยิน AudiAnalytix
Enterprise audiogram recording and analysis system for occupational hearing health programs, with automatic Standard Threshold Shift (STS) detection per OSHA standards, baseline management, and Excel reporting.
ระบบประเมินสุขภาพจิต
Online mental health self-assessment platform with user self-registration, standardized psychological questionnaires, and downloadable evaluation results for occupational mental health programs.
เว็บไซต์ healthtag.io
Company website for Medicense Intelligence featuring a Next.js frontend with Strapi CMS, plus an AWS Lambda + DynamoDB event registration system using Microsoft Graph for transactional email.
Excel for Healthcare Data
A comprehensive Excel guide covering XLOOKUP, PowerQuery, Pivot Tables, data validation, and data cleaning functions — focused on healthcare data workflows.
Building the ATK Data System
From Google Forms to a full-featured Blazor WebAssembly + ASP.NET Core system — the development journey of a rapid antigen test data platform.
Reverse-Engineering a Medical Web Portal
Using Selenium and C# to reverse-engineer Doctor Station web pages for automated data entry — a deep dive into web automation for healthcare.
ทำไมถึงสนใจคอม
ทำไมถึงสนใจคอม
ฟีเจอร์ของ Windows 11
ฟีเจอร์ใหม่ๆ ที่น่าสนใจของ Windows 11
Setting Up Python + Jupyter Lab on Windows
Step-by-step guide to installing Python 3.9 via the Microsoft Store, Jupyter Labs, Pandas, Plotly, and integrating everything with VS Code.