minbe-data 님의 블로그

Managing meal plans manually can be time-consuming, especially when ingredient quantities must be adjusted based on the number of people. In this example, Power Query and Python work together to automate the entire process. Power Query automatically: - Merges meal plans with recipe data - Calculates ingredient quantities - Adjusts quantities by person count - Creates a clean meal planning datase..

In Excel expense reports, card usage data is often stored in a separate table. When preparing an expense report, we usually need to bring only the transactions that match a selected date and management number. In this example, XLOOKUP is used to bring key report information, while Power Query filters the related card usage records automatically. Power Query checks: - Report Date - Management Num..

Tracking employee workdays can be difficult when working hours are recorded across multiple day columns. In many attendance sheets, employees are listed in rows while daily work hours are stored horizontally. In this example, Power Query automatically: - Converts daily work hours into a structured table - Identifies weekdays and holidays - Applies custom workday rules - Counts qualifying weekday..