DMF_Crawler/docs/research/_raw/07-pharma-excel-viz.raw.md

RAW RESEARCH DUMP — agent-a60bbd09c6f007bcf

ORIGINAL TASK PROMPT

오늘 날짜는 2026-09-02 이다. 너는 리서치 에이전트다. 반드시 먼저 ToolSearch 로 "select:WebSearch,WebFetch" 를 로드하고, WebSearch 로 최소 8회 이상 다양한 한국어/영어 질의를 던지고, 핵심 출처 페이지는 WebFetch 로 실제 열어 내용을 확인하라. 실제로 열어 확인한 항목만 verified_by_fetch=true 로 표시하라. 존재를 확인하지 못한 URL, GitHub 저장소, 논문, CLI 플래그는 절대 지어내지 말고 confidence='low' 로 표시하거나 제외하라. 한국 사이트(nedrug.mfds.go.kr, data.go.kr 등)는 WebFetch 가 실패할 수 있으니 실패하면 그 사실을 open_questions 에 적어라. 결과의 summary/detail/recommendations 는 한국어로 쓰되 고유명사·코드·플래그는 원문 유지. 코드 스니펫은 실제 동작 가능한 수준으로 구체적으로 작성하라. 최종 출력은 StructuredOutput 스키마에 맞춰라.

프로젝트 맥락: Windows 11 PC 에서 매일 06:00 에 한국 식약처 원료의약품 등록(DMF) 공고/현황을 크롤링하여 신규/변경/취하 건을 탐지하고, 탭(시트)별로 연동된 보기 좋은 xlsx 리포트를 생성한다. 크롤링·요약 일부를 AI 에이전트 CLI(Claude Code 의 'claude -p' headless 모드 등)로 non-interactive 하게 돌리고, 재부팅 후에도 자동 복구되는 서비스/스케줄러로 운영하며, 서비스가 죽으면 Windows 알림으로 복구 안내를 띄운다.

[축 7: 의약(DMF/규제) 정보를 한눈에 보는 엑셀 시각화·대시보드 설계] 조사 항목:

1. 엑셀 대시보드 설계 원칙(Chandoo, Excel Campus, Storytelling with Data 등): KPI 타일 상단 배치, 5초 규칙, 색 최소화, 강조색 1개, 표는 정렬·필터 가능하게, 차트 종류 선택 기준.
2. 규제 인텔리전스(regulatory intelligence) 실무에서 DMF/등록 공고를 어떻게 시각화·추적하는지: 신규/변경/취하 상태 뱃지, 성분(원료명)별·등록업체별·제조국별 집계, 경쟁사 워치리스트 매칭, 주간/월간 추이, 변경 이력 diff(전일 대비 신규 행 강조), 등록번호별 타임라인.
3. 참고할 공개 데이터 리포트 형식: FDA DMF 목록 xlsx, Drugs@FDA, Orange Book, EMA 문서, 식약처 통계 자료 — 그들의 컬럼 구조와 시트 구성에서 배울 점.
4. 색 접근성: 색각 이상 고려 팔레트(Okabe-Ito 등), 상태색(신규=초록/변경=주황/취하=빨강 + 아이콘 병행), 데이터 잉크 비율.
5. DMF 데이터에 특화된 시트 구성 제안: (a) 대시보드(오늘 요약 KPI, 최근 30일 추이 스파크라인, Top 성분/업체), (b) 오늘 변경분(신규/변경/취하), (c) 전체 누적 목록(필터·틀고정), (d) 성분별 피벗 요약, (e) 업체별 피벗 요약, (f) 워치리스트 매칭, (g) 원본 스냅샷/로그, (h) 메타(수집 시각, 소스 URL, 건수 검증) — 각 시트의 컬럼·정렬·서식 규칙을 표로 제안.
6. 피벗테이블을 파이썬에서 직접 만들기 어려운 문제(openpyxl 은 피벗 캐시 생성 불가)와 대안(pandas 로 집계 후 정적 표 + 차트, 또는 xlsxwriter 차트).
7. 한국 제약업계에서 쓰는 일일 규제 리포트/뉴스레터 형식(데일리팜, 약업신문 DMF 관련 기사 등)에서 사용자가 실제로 보고 싶어하는 항목. 실제 예시 이미지/템플릿 링크가 있으면 포함하라.

dimension 필드에는 "pharma-excel-viz" 를 넣어라.

[SEARCH #1] FDA Drug Master Files list xlsx columns DMF number type status holder subject

Web search results for query: "FDA Drug Master Files list xlsx columns DMF number type status holder subject"

Links: [{"title":"A Guide to Drug Master Files | BDO","url":"https://www.bdo.com/insights/industries/life-sciences/a-guide-to-drug-master-files"},{"title":"Drug Master Files Guidance for Industry DRAFT GUIDANCE","url":"https://www.fda.gov/media/131861/download"},{"title":"Drug Master Files (DMFs) | FDA","url":"https://www.fda.gov/drugs/forms-submission-requirements/drug-master-files-dmfs"},{"title":"Guideline for Drug Master Files (DMF) | FDA","url":"https://www.fda.gov/drugs/drug-master-files-dmfs/guideline-drug-master-files-dmf"},{"title":"US Drug Master Files (DMF) Database | PharmaCompass.com","url":"https://www.pharmacompass.com/us-drug-master-files-dmfs"},{"title":"Complete Guide to DMF Submissions | Celegence","url":"https://www.celegence.com/guide-to-drug-master-files-dmf-submission-tips-best-practices/"},{"title":"Dmf List – FDA Quarterly Drug Master Files Spreadsheet","url":"https://dmf-list.backgroundscheck.info/"},{"title":"list drug master files dmfs","url":"https://www.fda.gov/drugs/drug-master-files-dmfs/list-drug-master-files-dmfs"}]

Based on the search results, here's what the FDA Drug Master Files list contains:

The list contains information about the DMF number, activity status (active or inactive), type, holder name and subject (title). The list is updated on a quarterly basis.

More specifically, changes to the DMF activity status (A=active ; I=inactive), DMF type, holder name and subject (title) are tracked in the published list.

If you're looking at the actual Excel/XLSX file from the FDA, the columns would correspond to:

• DMF Number - The unique identifier for each Drug Master File
• Type - The classification of the DMF (such as Type II for drug substances, Type III for finished products, Type IV for excipients, etc.)
• Status - Active (A) or Inactive (I)
• Holder - The name of the person or organization that owns the DMF
• Subject - The title of the DMF

The list of DMFs, which is updated quarterly, contains DMFs received by December 31, 2025, for which acknowledgment letters were sent before January 22, 2026.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #2] Chandoo Excel dashboard design principles KPI top 5 second rule

Web search results for query: "Chandoo Excel dashboard design principles KPI top 5 second rule"

Links: [{"title":"Dashboard Design Best Practices for Better Data Visualization | by Rosalie | Medium","url":"https://rosalie24.medium.com/dashboard-design-best-practices-for-better-data-visualization-3dec5d71761b"},{"title":"kpi dashboards Archives » Chandoo.org - Learn Excel, Power BI & Charting Online","url":"https://chandoo.org/wp/tag/kpi-dashboards/"},{"title":"Dashboard Design Best Practices: Layouts & Examples","url":"https://www.domo.com/learn/article/dashboard-design-examples-best-practices"},{"title":"10 Key Dashboard Design Principles: Analytics Best Practice","url":"https://www.yellowfinbi.com/blog/key-dashboard-design-principles-analytics-best-practice"},{"title":"Making a Simple KPI Dashboard using MS Excel","url":"https://chandoo.org/wp/2011/08/25/simple-kpi-dashboard-using-excel/"},{"title":"Five Rules for Building Impressive Excel Dashboards - Plum Solutions","url":"https://plumsolutions.com.au/five-rules-for-building-impressive-excel-dashboards/"},{"title":"8 Dashboard Design Best Practices for Insight-Led Decisions","url":"https://vizule.io/dashboard-design-best-practices/"},{"title":"Dashboard design 5 seconds rule - Den Otter Solutions","url":"https://denottersolutions.com/en/data-insights/dashboard-design-5-seconds-rule/"}]

Based on the search results, here's what I found about Excel dashboard design principles, KPIs, and the 5-second rule:

The 5-Second Rule

The "5-Second Rule" states that a user should be able to look at the dashboard and understand the main message or most critical data point within five seconds. More specifically, a user should be able to see whether the organisation is on track within five seconds of opening a dashboard — without filtering, scrolling or reading a legend.

Dashboard Design Principles

Several key principles emerge from the search results:

Visual Hierarchy & Layout:

• Place the most important, high-impact Key Performance Indicators (KPIs) in large format in the top-left section.
• Use proximity to group related charts and metrics together, which creates visual blocks that the brain processes quickly.
• Generous use of whitespace (or negative space) separates elements and provides "breathing room" for the data.

KPI Selection:

• Metrics or KPIs that are most important and indicate the overall health of the system should be on top.
• Six to eight maximum KPIs are recommended, as every additional KPI competes for attention and slows interpretation.

Chandoo.org's Contribution: The original KPI dashboards using Excel article was so popular that they still help around 12,000 people around the globe every month.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #3] openpyxl pivot table cannot create pivot cache alternative xlsxwriter chart pandas

Web search results for query: "openpyxl pivot table cannot create pivot cache alternative xlsxwriter chart pandas"

Links: [{"title":"Pivot Tables — openpyxl 2.5.15 documentation","url":"https://openpyxl.readthedocs.io/en/2.5/pivot.html"},{"title":"Pivot Tables — openpyxl 3.0.10 documentation","url":"https://openpyxl.readthedocs.io/en/3.0/pivot.html"},{"title":"Pivot Tables — openpyxl 3.1.3 documentation - Read the Docs","url":"https://openpyxl.readthedocs.io/en/stable/pivot.html"},{"title":"Pivot Tables — openpyxl 3.1.4 documentation","url":"https://openpyxl.readthedocs.io/en/3.1/pivot.html"},{"title":"Pivot Tables — openpyxl 3.1.4 documentation - Read the Docs","url":"https://openpyxl.readthedocs.io/en/latest/pivot.html"},{"title":"openpyxl.pivot.cache module — openpyxl 3.1.1 documentation","url":"https://openpyxl.readthedocs.io/en/3.1.1/api/openpyxl.pivot.cache.html"},{"title":"openpyxl.pivot.cache module — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/api/openpyxl.pivot.cache.html"},{"title":"openpyxl.pivot.table module — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/api/openpyxl.pivot.table.html"},{"title":"openpyxl.pivot.cache module — openpyxl 3.1.4 documentation","url":"https://openpyxl.readthedocs.io/en/latest/api/openpyxl.pivot.cache.html"}]

Based on the search results, here's what I found about openpyxl and pivot tables:

openpyxl currently has no management API for pivot tables, which means you cannot create new pivot tables from scratch using openpyxl. However, you can modify existing pivot tables in files that already have them.

The search results show the technical structure of pivot caching in openpyxl through the CacheDefinition class and related pivot table components, but they don't reveal solutions for creating pivot tables from scratch or working around this limitation.

For alternatives to creating pivot tables with Python, you might consider:

1. XlsxWriter - While primarily designed for writing Excel files, it has chart functionality but also doesn't natively support creating pivot tables from scratch
2. Pandas - Can export data to Excel and work with dataframes, but won't directly create pivot tables in Excel format
3. Charts - You could use these tools to create charts based on your data as a visual alternative to pivot tables

If you need to create pivot tables in Excel files programmatically, you might need to either:

• Use Excel's VBA/macros with a library that can control Excel
• Use a lower-level approach to manually construct the necessary XML for pivot caches and tables
• Consider using a different tool or workflow that supports pivot table creation

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #4] Okabe-Ito colorblind safe palette status colors green orange red icons

Web search results for query: "Okabe-Ito colorblind safe palette status colors green orange red icons"

Links: [{"title":"Okabe-Ito Palette Hex Codes for Python, R & CSS","url":"https://conceptviz.app/blog/okabe-ito-palette-hex-codes-complete-reference"},{"title":"Okabe-Ito Colorblind-Safe Palette: Copy HEX + Download ...","url":"https://sci-draw.com/blog/colorblind-safe-palettes-okabe-ito-reference"},{"title":"Best Scientific Color Palettes: Hex Codes & Examples","url":"https://conceptviz.app/blog/scientific-color-palette-for-research-papers-and-posters"},{"title":"Okabe-Ito Palette Hex Codes: Full 8-Color Reference with Code Examples [2026] | Figviz","url":"https://figviz.com/blog/okabe-ito-palette-hex-codes-full-8-color-reference-with-code-examples-2026-wlt9th1n"},{"title":"Colorblind-Safe Palette Generator — Okabe-Ito Set","url":"https://www.generatorcollection.com/en/generators/colors/colorblind-safe-palette-generator/"},{"title":"Okabe-Ito Palette: Gold Standard for Science","url":"https://vizcept.com/blog/okabe-ito-palette-guide"}]

Based on the search results, here's what I found about the Okabe-Ito colorblind-safe palette:

Overview

The Okabe-Ito palette was created by Masataka Okabe and Kei Ito at the Color Universal Design organization, and it provides 8 colors that remain distinguishable for people with all common types of color vision deficiency (CVD).

The 8 Colors

The standard Okabe-Ito palette contains 8 colors: Orange (#E69F00), Sky Blue (#56B4E9), Bluish Green (#009E73), Yellow (#F0E442), Blue (#0072B2), Vermillion (#D55E00), Reddish Purple (#CC79A7), and Black (#000000).

Status and Recognition

The Okabe-Ito palette is the most widely recommended colorblind-safe color palette for scientific figures. This palette is explicitly recommended by Nature Methods and is the default categorical palette in Claus Wilke's Fundamentals of Data Visualization.

Design Approach for Green, Orange, and Red

The Okabe-Ito palette avoids pure red and pure green entirely. Instead it uses: Orange (#E69F00) — perceived as yellow-orange even in protanopia, and Bluish Green/Teal (#009E73) — which contains enough blue channel to survive the red-green merge.

This thoughtful color selection makes the palette suitable for use in status indicators and icons while maintaining accessibility across different types of color blindness.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #5] Excel Campus dashboard design best practices minimal colors one accent

Web search results for query: "Excel Campus dashboard design best practices minimal colors one accent"

Links: [{"title":"12 Best Practices in Dashboard Design | GoSkills","url":"https://www.goskills.com/excel/resources/best-practices-in-dashboard-design"},{"title":"How to Create a Dashboard in Excel: A Step-by-Step Tutorial | DataCamp","url":"https://www.datacamp.com/tutorial/create-excel-dashboards-tutorial"},{"title":"Effective Dashboard Color Schemes | insightsoftware","url":"https://insightsoftware.com/blog/effective-color-schemes-for-analytics-dashboards/"},{"title":"Best Admin Dashboard Color Schemes: A Developer's Guide","url":"https://adminlte.io/blog/best-admin-dashboard-color-schemes/"},{"title":"Excel Dashboard Design Principles: Make the Answer Obvious","url":"https://bigexcelenergy.com/excel-dashboard-design-principles/"},{"title":"8 Excel Dashboard Palettes + 4 Chart Color Sets","url":"https://bigexcelenergy.com/excel-dashboard-color-palette/"},{"title":"Best Hex Code Palettes for Professional Spreadsheets - GSheets.com | GSheets","url":"https://www.gsheets.com/blog/beautiful-spreadsheet-color-palettes"},{"title":"What are the most effective UI/UX design principles for an Excel-based Sales Dashboard? | iCertGlobal Community","url":"https://www.icertglobal.com/community/excel-dashboard-ui-ux-design-tips"}]

I've completed the web search for "Excel Campus dashboard design best practices minimal colors one accent". Here are the key findings:

Dashboard Design Best Practices with Minimal Colors and One Accent

Color Palette Strategy: Pick a neutral base and exactly one accent color, with the accent appearing only on the thing you want noticed — the key KPI, the alert, the call to action. The rule is simple: three to five working colors, and that is it. Neutrals are free. One accent does the pointing.

Recommended Color Structure: Stick to a 3-color palette: one neutral gray, one primary brand color (like Navy Blue), and one accent color for alerts (like Coral). Excel dashboards often use neutral palettes with soft grays, blues, and greens, which help make the data readable and prevent visual fatigue. For example, using light gray backgrounds with dark blue or green text makes the data stand out without overwhelming the user.

General Design Principles: You do not want to dazzle your readers with too many colors and fonts. Keep these minimal and consistent. Every bright color you add costs you a little attention elsewhere. A neutral base, one accent for "look here," and semantic green/red used sparingly.

The search results emphasize that restraint in color usage creates a professional, focused dashboard that guides user attention effectively to the most important information.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #6] 데일리팜 원료의약품 등록 DMF 공고 신규 등록 현황 기사

Web search results for query: "데일리팜 원료의약품 등록 DMF 공고 신규 등록 현황 기사"

Links: [{"title":"[데일리팜]의약품 해외제조소 등록 안하면 2차 위반시 허가취소","url":"https://dailypharm.com/user/news/67688"},{"title":"[데일리팜]필수약·공급중단 보고대상 의약품 'DMF 등록' 유예","url":"https://m.dailypharm.com/user/news/32332"},{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&upDown=0&no1=912&linkId=26604564"},{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"[데일리팜] 규제완화 여파...원료약 등록 1년새 237→653건","url":"https://www.dailypharm.com/Users/News/NewsView.html?ID=324241"},{"title":"[지침]원료의약품 등록(DMF) 처리 절차 < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=1&rowCnt=10&menuId=MENU01872&maxIndex=99999999999999&minIndex=99999999999999&schType=0&upDown=0&no1=0&linkId=26605812"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 공고","url":"https://nedrug.mfds.go.kr/pbp/CCBAC03"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 정보","url":"https://nedrug.mfds.go.kr/bbs/117"},{"title":"Dimethyl fumarate particles and pharmaceutical compositions thereof","url":"https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/11291642"}]

검색 결과를 정리하면 다음과 같습니다:

검색 결과 요약

원료의약품(DMF) 등록 관련 주요 뉴스 및 정보:

1. DMF 등록 급증 - 올해 상반기 국내 제약바이오기업의 원료의약품 등록(DMF) 건수는 653건으로, 작년 상반기 256건과 비교하면 1년 새 2.8배 증가했습니다. 정부는 올해부터 원료의약품 등록 시 GMP 평가를 GMP 증명서로 대체할 수 있도록 규제를 완화했습니다.

2. DMF 등록 유예 - 국가필수의약품과 국가필수의약품이 아닌 공급중단 보고 대상 의약품에 대해 DMF 유예를 허용하기로 했습니다.

3. 해외제조소 등록 - DMF로 등록한 원료 역시 해외제조소 등록 대상이며, 해외 제조소 이전 시에는 신규 등록해야 합니다.

4. 공공데이터 - DMF 현황 데이터는 등록번호, 성분명, 업체명, 제조소명, 제조소 소재지, 제조국가명, 발급일자 등의 정보를 제공합니다.

더 자세한 정보는 식품의약품안전처의 공식 웹사이트(nedrug.mfds.go.kr)에서 DMF 공고 및 등록 현황을 확인하실 수 있습니다.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #7] 식약처 원료의약품 등록 공고 nedrug DMF 등록번호 제조원 등록업체 현황

Web search results for query: "식약처 원료의약품 등록 공고 nedrug DMF 등록번호 제조원 등록업체 현황"

Links: [{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&schText=&categoryId=&continent=&country=&upDown=0&boardStyle=&no1=912&linkId=26604564"},{"title":"https://nedrug.mfds.go.kr/search?keyword=%BF%D5%C5...","url":"https://nedrug.mfds.go.kr/search?keyword=%EF%BF%BD%EF%BF%BD%C5%B8%C2%A5,com+%EF%BF%BD%EF%BF%BD%C4%AB%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%B7%EF%BF%BD%EF%BF%BD%CC%BE%EF%BF%BD+2025%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%BC+%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C5%B8%EF%BF%BD%CC%B0%C5%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD+%EF%BF%BD%EF%BF%BD%C8%B0%EF%BF%BD%EF%BF%BD%C4%AB%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C6%AE+%EF%BF%BD%EF%BF%BD%C3%BB%EF%BF%BD%CF%B5%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%B5"},{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 공고","url":"https://nedrug.mfds.go.kr/pbp/CCBAC03"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 정보","url":"https://nedrug.mfds.go.kr/bbs/117"},{"title":"https:/nedrug.mfds.go.kr - 식품의약품안전처","url":"https://nedrug.mfds.go.kr/"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000198136"},{"title":"의약품안전나라 > 의약품등 검색 - 식품의약품안전처","url":"https://nedrug.mfds.go.kr/searchDrug"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"},{"title":"사업소개>의약품>허가심사>KDMF | 식품의약품안전평가원","url":"https://www.nifds.go.kr/brd/m_87/list.do"}]

웹 검색 결과를 정리하면 다음과 같습니다:

식약처 원료의약품(DMF) 등록 관련 정보

식품의약품안전처는 「의약품 등의 안전에 관한 규칙」 제15조, 제17조 및 '원료의약품 등록에 관한 규정'(식약처고시) 제2조에 따라 등록대상 원료의약품(DMF) 등록신청에 대하여 검토가 완료되면 등록사항을 공고합니다.

공개 데이터 및 정보 제공

식품의약품안전처 「원료의약품등록(DMF)현황」 OpenAPI는 등록된 원료의약품(DMF)의 현황을 조회할 수 있는 공공데이터이며, 주요 제공항목에는 등록번호, 성분명, 업체명, 제조소명, 제조소 소재지, 제조국가명, 발급일자 등이 포함되어 있습니다.

주요 접근 경로

• 의약품안전나라(nedrug.mfds.go.kr): 원료의약품등록(DMF) 정보 및 공고 제공
• 공공데이터포털: 원료의약품등록(DMF)현황 OpenAPI 제공
• 주간 원료의약품 등록현황(신규등록, 변경등록, 연차보고)을 식약처 홈페이지 전자민원창구(ezdrug.mfds.go.kr)에 게시

이러한 자료들을 통해 제약사 및 연구자는 원료 등록 현황, 제조업체, 등록번호 등의 정보를 확인할 수 있습니다.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #8] regulatory intelligence tracker dashboard DMF change tracking watchlist competitor API sources

Web search results for query: "regulatory intelligence tracker dashboard DMF change tracking watchlist competitor API sources"

Links: [{"title":"Thomson Reuters Regulatory Intelligence","url":"https://regintel-content.thomsonreuters.com/"},{"title":"Regulatory change tracking for compliance management","url":"https://www.ideagen.com/solutions/quality/regulatory-intelligence/regulatory-change-tracking"},{"title":"RegASK | Agentic AI Regulatory Intelligence Platform","url":"https://regask.com/"},{"title":"AI Regulatory Intelligence - IONI AI","url":"https://ioni.ai/ai-regulatory-intelligence"},{"title":"#1 Regulatory Intelligence Software - Law Change Monitoring and Alerts","url":"https://visualping.io/regulatory-intelligence"},{"title":"Regulatory Intelligence Software: 5 Best Tools for Food Manufacturers (2026) | Sep 30, 2025","url":"https://ioni.ai/post/best-ai-regulatory-intelligence-tool"},{"title":"Regulatory Intelligence Tools | Compliance Regulatory Software","url":"https://www.compliance.ai/solution/regulatory-intelligence/"},{"title":"FDA Tracker: Free Regulatory Intelligence & 483 Tracker | Leucine","url":"https://leucine.ai/fda-tracker/"},{"title":"Regulatory Intelligence Database, Software & Tools for Compliance","url":"https://www.vistaar.ai/blog/regulatory-intelligence-database-software-tools-for-compliance/"},{"title":"Regulatory Intelligence database & Monitoring Software","url":"https://www.vistaar.ai/"}]

Based on the search results, here are several regulatory intelligence tracker dashboard solutions that offer DMF change tracking, watchlist, and competitor monitoring features:

Key Solutions Found:

Thomson Reuters Regulatory Intelligence Helps organizations anticipate and manage global regulatory developments in a single solution, removing the burden of having to manually track multiple sources of regulatory information.

Leucine FDA Tracker Allows you to upload your approved vendor list or build a watchlist of competitors, and alerts you the moment any of them receives a warning letter, 483 observation, import alert, or recall. The tool ingests FDA enforcement data, links entities across documents, scores each action for relevance to your products and sites, and alerts you proactively.

Vistaar AI Regulatory Intelligence Offers smart alerts, watchlists, and full workflow management with project tracking. Provides AI-driven contextual search across 2M+ regulations and guidance documents.

RegASK Platform An agentic AI regulatory intelligence platform for Life Sciences and Consumer Products that monitors global regulatory changes, assesses impact, automates compliance workflows, and reduces regulatory risk and costs.

General Regulatory Intelligence Features A Regulatory Intelligence Database is a centralized platform that collects and stores regulatory information from various sources, enabling organizations to access critical compliance data in real time and streamline decision-making.

These solutions typically include API sources for data aggregation, competitor monitoring capabilities, and automated change tracking for regulatory updates.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #9] storytelling with data dashboard principles declutter one color emphasis data-ink ratio

Web search results for query: "storytelling with data dashboard principles declutter one color emphasis data-ink ratio"

Links: [{"title":"Data Storytelling in Data Visualisation: Does it Enhance the Efficiency and Effectiveness of Information Retrieval and Insights Comprehension? | Proceedings of the 2024 CHI Conference on Human Factors in Computing Systems","url":"https://dl.acm.org/doi/10.1145/3613904.3643022"},{"title":"Declutter your Chart with Data-Ink Ratio | by Sudharsan Asaithambi | Medium","url":"https://sudharsanasai.medium.com/declutter-your-chart-with-data-ink-ratio-6f6908727842"},{"title":"Incredible dashboard design principles that make data land | Forsta","url":"https://www.forsta.com/resources/blog/dashboard-design-principles-land/"},{"title":"Visualization 101: 9 essential principles of data storytelling - Bunker DB","url":"https://bunkerdb.com/en/blog/data-visualization-101-storytelling-principles"},{"title":"Master Data Storytelling: Engage Audiences With Data Insights","url":"https://businessanalyst.techcanvass.com/data-storytelling/"},{"title":"The Art and Science of Data-Ink Ratios For Effective Data Storytelling | by John Loewen, PhD | Data Storytelling Corner | Medium","url":"https://medium.com/data-storytelling-corner/the-art-and-science-of-simple-data-visual-design-for-effective-storytelling-1d7667c1bfd8"},{"title":"Telling your Data Story in Seconds - Part 2: Color","url":"https://www.dataself.com/telling-story-seconds-part-2-color/"},{"title":"3.4 Storytelling with data visualisation — Research Data Science","url":"https://alan-turing-institute.github.io/rds-course/modules/m3/3.4-StoryTelling.html"},{"title":"Ten practical tips for effective data visualization – Urban Data Analytics, Visualization, & Storytelling 📊📈🏙️","url":"https://schoolofcities.github.io/urban-data-storytelling/urban-data-visualization/data-visualization-practical-tips/data-visualization-practical-tips.html"},{"title":"Design for Data Storytelling: Less Clutter, More Clarity - Locus IT Services Pvt. Ltd.","url":"https://locusit.com/learning/business-applications/design-for-data-storytelling-less-clutter-more-clarity/"}]

I've completed the web search for your query on storytelling with data dashboard principles. Here are the key findings:

Key Dashboard Principles for Data Storytelling

Decluttering: Reducing extraneous visual elements can make a visualisation more easily interpretable, allowing viewers to focus only on key elements. Remove anything that doesn't support your story: gridlines, borders, 3D effects, shadows, decorative elements.

Color Emphasis: Use color sparingly to emphasize key data—one or two colors used effectively are more powerful than a rainbow without meaning. Data storytelling elements include colour emphasis in text and lines.

Data-Ink Ratio: The data-ink ratio refers to the proportion of visual elements that represent actual data, rather than decoration, relative to all 'ink' on the chart. Tufte puts forward principles related to data ink: Above all else show data, Maximize the data-ink ratio, Erase non-data-ink, and Erase redundant data-ink.

Modern Balance: Modern data storytelling is about striking a balance between minimalism and engagement, as we need to be careful not to go too far in pursuing minimalism, as we can end up with dashboards that feel clinical, cold, or just plain boring.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #10] xlsxwriter add_sparkline add_table conditional_format icon_set example python

Web search results for query: "xlsxwriter add_sparkline add_table conditional_format icon_set example python"

Links: [{"title":"Working with Conditional Formatting — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/working_with_conditional_formats.html"},{"title":"XlsxWriter/dev/docs/source/working_with_conditional_formats.rst at master · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/blob/master/dev/docs/source/working_with_conditional_formats.rst"},{"title":"Example: Sparklines (Advanced) — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_sparklines2.html"},{"title":"XlsxWriter/dev/docs/source/worksheet.rst at main · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/blob/main/dev/docs/source/worksheet.rst"},{"title":"Example: Sparklines (Simple) — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_sparklines1.html"},{"title":"Example: Conditional Formatting - XlsxWriter - Read the Docs","url":"https://xlsxwriter.readthedocs.io/example_conditional_format.html"},{"title":"Contents - XlsxWriter - Read the Docs","url":"https://xlsxwriter.readthedocs.io/contents.html"},{"title":"Python XlsxWriter - Sparklines","url":"https://www.tutorialspoint.com/python_xlsxwriter/python_xlsxwriter_sparklines.htm"},{"title":"Python XlsxWriter - Conditional Formatting","url":"https://www.tutorialspoint.com/python_xlsxwriter/python_xlsxwriter_conditional_formatting.htm"}]

I found relevant documentation and examples for XlsxWriter features. Here are the key findings:

Conditional Formatting with Icon Sets

The icon_set type is used to specify a conditional format with a set of icons such as traffic lights or arrows. Here's a basic example:

worksheet.conditional_format('A1:C1', {'type': 'icon_set', 'icon_style': '3_traffic_lights'})

For icon sets with custom values, the icons value parameter can be a value or formula, with an example: worksheet.conditional_format('A1:D1', {'type': 'icon_set', 'icon_style': '4_red_to_black', 'icons': [{'value': 90}, {'value': 50}, {'value': 25}]}). The icons parameters should start with the highest value and with each subsequent one being lower.

Sparklines

Sparklines are small charts that fit in a single cell and are used to show trends in data. The add_sparkline() worksheet method is used to add sparklines to a cell or a range of cells.

The method basically needs the cell location of the sparkline and the data range to be represented as a sparkline. Here's a practical example:

ws.add_sparkline(i+4,1, {'range':'Sheet1!$C$3:$L$3', 'type':'column', 'style':i})

Conditional Formatting (General)

The conditional_format() worksheet method is used to apply formatting based on user defined criteria to an XlsxWriter file. The conditional format can be applied to a single cell or a range of cells.

For tables specifically, note that tables aren't available in XlsxWriter when Workbook 'constant_memory' mode is enabled.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #1] https://www.fda.gov/drugs/drug-master-files-dmfs/list-drug-master-files-dmfs

ASK: Describe the DMF list: what file formats are provided, what columns are in the spreadsheet, how often updated, what status codes and DMF types mean, and any notes on how changes are tracked.

The server returned HTTP 404 Not Found.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #2] https://nedrug.mfds.go.kr/pbp/CCBAC03

ASK: Describe the page: what table columns are shown for the DMF 공고 list (등록번호, 성분명, 업체명, 등록구분 등), what filter options exist, and how 신규/변경/취하 are distinguished.

DMF 공고 페이지 설명

테이블 컬럼

이 페이지는 원료의약품 등록 정보를 표시하며, 다음 컬럼들을 포함합니다:

• 순번
• 대상의약품 (분류: 별표1, 신물질 등)
• 등록번호
• 성분명
• 신청인 (제조업체)
• 제조소명
• 제조소소재지
• 제조국가
• 최초등록일자
• 최종변경일자
• 최종연차보고년도
• 취소/취하구분
• 취소/취하일자
• 문서번호
• 연계심사문서번호

필터 옵션

페이지 상단에 검색 필터가 제공됩니다:

• 발급일자 범위 (시작~종료)
• 업소명
• 등록번호
• 성분명

신규/변경/취하 구분

"취소/취하구분" 컬럼에서 상태를 구별합니다. 표시된 데이터는 모두 "정상" 상태로 표기되어 있으며, 취소나 취하된 항목은 해당 날짜가 기록됩니다.

[FETCH #3] https://www.data.go.kr/data/15057075/openapi.do

ASK: List the API name, output fields (컬럼명, 항목 설명), request parameters, update cycle, and endpoint URL.

API Overview: DMF Registration Status

API Name: 식품의약품안전처_원료의약품등록(DMF)현황 (Food and Drug Safety - Raw Drug Registration DMF Status)

Endpoint URL: https://apis.data.go.kr/1471000/MdcDmfInfoService01/getMdcDmfList01

Update Cycle: Not specified in documentation

Output Fields (Response Elements)

Field (Korean)	Field (English)	Description
등록번호	DMF_PERMIT_NO	Registration number
성분명	INGR_KOR_NAME	Ingredient name
업체명	ENTP_NAME	Company name
제조소명	MNFCTR_NAME	Manufacturing facility name
제조소 소재지	MNFCTR_PLACE	Manufacturing facility location
제조국가명	MANUF_COUNTRY_CODE_NM	Manufacturing country
발급일자	DMF_PERMIT_DATE	Issue date

Request Parameters

Parameter (Korean)	Parameter (English)	Required	Description
인증키	serviceKey	Yes	Authentication key (URL encoded)
업체명	entp_name	No	Company name
성분명	ingr_kor_name	No	Ingredient name
페이지 번호	pageNo	No	Page number
한 페이지 결과 수	numOfRows	No	Results per page
데이터포맷	type	No	Response format (xml/json)

[FETCH #4] https://openpyxl.readthedocs.io/en/stable/pivot.html

ASK: What exactly does openpyxl say about pivot table support: can it create new pivot tables, what can it do with existing ones, and any example code.

openpyxl Pivot Table Support

Based on the documentation:

Creation: openpyxl cannot create new pivot tables. The docs state: "it is not intended that client code should be able to create pivot tables."

Existing Pivot Tables: The library provides read-support and allows editing of existing pivot tables. Users can "edit and manipulate existing pivot tables, eg. change their ranges or whether they should update automatically settings."

Access Method: Since there's no management API, developers must iterate through the _pivots list of a worksheet to work with pivot tables.

Example Code:

from openpyxl import load_workbook
wb = load_workbook("campaign.xlsx")
ws = wb["Results"]
pivot = ws._pivots[0]
pivot.cache.refreshOnLoad = True

This example demonstrates accessing a pivot table and modifying its cache refresh behavior. For additional details, the documentation references the openpyxl.pivot.cache.CacheDefinition class.

[FETCH #5] https://xlsxwriter.readthedocs.io/example_sparklines2.html

ASK: Extract the exact add_sparkline options used (type, range, markers, high_point, low_point, style, negative_points, series_color etc.) and the code sample.

XlsxWriter Sparkline Options

Options Used in Example

The code demonstrates these add_sparkline() parameters:

• range: Data source (e.g., "Sheet2!A1:J1")
• type: Chart type - "line" (default), "column", or "win_loss"
• markers: Boolean to display data point markers
• high_point: Boolean to highlight maximum values
• low_point: Boolean to highlight minimum values
• first_point: Boolean to mark the initial data point
• last_point: Boolean to mark the final data point
• negative_points: Boolean to highlight negative values
• axis: Boolean to display the sparkline axis
• style: Predefined color scheme (1-6, 20)
• series_color: Custom hex color (e.g., "#E965E0")
• reverse: Boolean to reverse column direction
• location: Array of cells for grouped sparklines

Code Sample

import xlsxwriter

workbook = xlsxwriter.Workbook("sparklines2.xlsx")
worksheet1 = workbook.add_worksheet()
worksheet2 = workbook.add_worksheet()

# Line sparkline with markers
worksheet1.add_sparkline("A6", {"range": "Sheet2!A1:J1", "markers": True})

# Column with custom color
worksheet1.add_sparkline(
    "A18", {"range": "Sheet2!A2:J2", "type": "column", "series_color": "#E965E0"}
)

# Grouped sparklines
worksheet1.add_sparkline(
    "A27",
    {
        "location": ["A27", "A28", "A29"],
        "range": ["Sheet2!A5:J5", "Sheet2!A6:J6", "Sheet2!A7:J7"],
        "markers": True,
    },
)

workbook.close()

[FETCH #6] https://xlsxwriter.readthedocs.io/working_with_conditional_formats.html

ASK: Extract the exact syntax and options for type 'icon_set' (icon_style values list, icons, reverse_icons, icons_only), type 'formula', type 'text', and type 'duplicate'. Include code examples verbatim.

Conditional Formatting: Key Types and Syntax

type: icon_set

Icon Style Values: The icon_style parameter accepts: 3_arrows, 3_arrows_gray, 3_flags, 3_signs, 3_symbols, 3_symbols_circled, 3_traffic_lights, 3_traffic_lights_rimmed, 4_arrows, 4_arrows_gray, 4_ratings, 4_red_to_black, 4_traffic_lights, 5_arrows, 5_arrows_gray, 5_quarters, 5_ratings.

Basic Usage:

worksheet.conditional_format('A1:C1', {'type': 'icon_set',
                                       'icon_style': '3_traffic_lights'})

With Custom Icon Criteria:

worksheet.conditional_format(
    'A1:D1',
    {'type': 'icon_set',
     'icon_style': '4_red_to_black',
     'icons': [{'criteria': '>=', 'type': 'number',     'value': 90},
               {'criteria': '<',  'type': 'percentile', 'value': 50},
               {'criteria': '<=', 'type': 'percent',    'value': 25}]}
)

Icon Parameters:

• criteria: Must be >= or < (default: >=)
• type: Options are number, percentile, percent, formula (default: percent)
• value: Numeric value or formula

Additional Options:

# Reverse icon order
worksheet.conditional_format('A1:C1',
                             {'type': 'icon_set',
                              'icon_style': '3_arrows',
                              'reverse_icons': True})

# Display icons without cell values
worksheet.conditional_format('A1:C1',
                             {'type': 'icon_set',
                              'icon_style': '3_flags',
                              'icons_only': True})

type: formula

User-defined formulas drive the conditional formatting:

worksheet.conditional_format('A1:A4', {'type':     'formula',
                                       'criteria': '=$A$1>5',
                                       'format':   format1})

Important Notes:

• Formulas use US-style separators (commas, not semicolons)
• Cell references should employ absolute notation for ranges
• Follow write_formula() conventions

type: text

Apply formatting based on string matching:

worksheet.conditional_format('A1:A4', {'type':     'text',
                                       'criteria': 'containing',
                                       'value':    'foo',
                                       'format':   format1})

Criteria Options: 'containing', 'not containing', 'begins with', 'ends with'

type: duplicate

Highlight cells appearing multiple times within a range:

worksheet.conditional_format('A1:F10', {'type':   'duplicate',
                                        'format': format1})

[FETCH #7] https://denottersolutions.com/en/data-insights/dashboard-design-5-seconds-rule/

ASK: Summarize the 5-second rule, and any concrete layout guidance (position of KPIs, number of KPIs, color rules).

The 5-Second Rule Summary

Core Principle

"A user should be able to see whether the organisation is on track within five seconds of opening a dashboard — without filtering, scrolling or reading a legend."

Layout Guidance: The F-Pattern

Dashboards should follow natural eye-tracking patterns:

• Top-left (KPI Zone): Place 3-4 most critical metrics here (revenue, margin, service level) in large text with red/green signals
• Middle (Trend Zone): Display line charts showing directional movement
• Bottom-right (Detail Zone): Include tables and deeper data for analysts

Key Quantity & Design Rules

KPI Count: Maximum 6-8 KPIs per dashboard; start with 3-4 essential numbers

Color Usage: "Use colour functionally — three colours maximum, each with a fixed meaning" (red for action needed, green for on-track)

Chart Selection: Prefer bar charts over pie charts for accurate comparison; white space aids processing

Context Requirement: Numbers require comparison points (vs. budget, prior year, targets) to be meaningful

This design transforms dashboards into actionable management instruments rather than decorative data displays.

[FETCH #8] https://www.dailypharm.com/Users/News/NewsView.html?ID=324241

ASK: 기사 내용을 요약: DMF 등록 건수 통계, 어떤 기준으로 집계했는지(성분, 업체, 제조국), 기사에서 언급된 기업/성분 랭킹, 표/그래프가 있다면 그 항목.

DMF 등록 통계 요약

집계 기준

기사는 구체적인 집계 기준(성분별, 업체별, 제조국별)을 명시하지 않습니다. "국내 제약바이오기업의 원료의약품 등록 건수"로만 표현되어 있습니다.

주요 수치

• 2025년 상반기: 653건
• 2024년 상반기: 256건 (2.8배 증가)
• 2024년 전체: 545건
• 역대 최고: 2021년 상반기 537건 초과

언급된 기업/성분

기사에서 특정 기업명이나 성분명 랭킹은 제시되지 않습니다.

그래프/표

기사에 두 개의 시각 자료가 포함되어 있으나, 구체적 항목이 명확하게 텍스트로 설명되지 않았습니다. 다만 "최근 8년간 DMF 건수"의 연도별 추이가 나열되어 있습니다.

[FETCH #9] https://bigexcelenergy.com/excel-dashboard-design-principles/

ASK: Extract the concrete Excel dashboard design principles listed (layout, KPI placement, color rules, chart choice, fonts, gridlines, freeze panes, etc.).

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #10] https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&upDown=0&no1=912&linkId=26604564

ASK: 게시글 내용: 주간 DMF 등록 공고의 형식(첨부파일 형식, 표 컬럼 - 등록번호, 성분명, 등록업체, 제조원, 제조국, 등록구분(신규/변경/취하) 등), 게시 주기.

DMF Registration Announcement Overview

Publication Format & Schedule: The Korean Ministry of Food and Drug Safety releases weekly DMF (Drug Master File) registration announcements. According to the notice, "주간 원료의약품 등록현황(신규등록, 변경등록, 연차보고)을 우리처 홈페이지" [weekly raw material pharmaceutical registration status is posted on the ministry's website].

Table Structure: The attached files contain registration data organized with these columns:

• Registration number
• Active ingredient name
• Registering company
• Manufacturer
• Manufacturing country
• Registration type (new registration, modification, or withdrawal)

Publication Details:

• Frequency: Weekly (the example shown is from the second week of July)
• Source: Food and Drug Safety Ministry's e-civil services portal
• Access Point: http://ezdrug.mfds.go.kr (Resources > Pharmaceuticals section)

This systematic weekly publication allows pharmaceutical companies and industry stakeholders to track raw material pharmaceutical approvals and changes in South Korea.

[FETCH #11] https://conceptviz.app/blog/okabe-ito-palette-hex-codes-complete-reference

ASK: Extract the 8 hex codes with names, any guidance on which colors to use for good/warning/bad status, and the note about avoiding red/green pairs.

Okabe-Ito Palette: 8 Hex Codes

The 8 colors:

1. Orange: #E69F00
2. Sky Blue: #56B4E9
3. Bluish Green: #009E73
4. Yellow: #F0E442
5. Blue: #0072B2
6. Vermillion (Red): #D55E00
7. Reddish Purple: #CC79A7
8. Black: #000000

Status Indicators & Color Guidance

The provided content does not specify which colors to use for good/warning/bad status indicators, nor does it include guidance about avoiding red/green pairs.

The palette is described as being "designed for CVD from the start" and maintaining "distinguishability for protanopia (red-blind), deuteranopia (green-blind), and tritanopia (blue-blind)." However, specific recommendations for status-based color assignments are not addressed in this document.

[SEARCH #11] FDA Orange Book data files products.txt columns Ingredient Appl_No Applicant TE_Code RLD

Web search results for query: "FDA Orange Book data files products.txt columns Ingredient Appl_No Applicant TE_Code RLD"

Links: [{"title":"Orange Book","url":"https://downloads.regulations.gov/FDA-2019-P-1318-0003/content.pdf"},{"title":"Frequently Asked Questions on The Orange Book | FDA","url":"https://www.fda.gov/drugs/drug-approvals-and-databases/frequently-asked-questions-orange-book"},{"title":"Orange Book: Approved Drug Products with Therapeutic ...","url":"https://downloads.regulations.gov/FDA-2017-P-2044-0004/content.pdf"},{"title":"FDA Orange Book Drug Data","url":"https://www.kaggle.com/datasets/thedevastator/fda-orange-book-drug-data"},{"title":"Orange Book 101 | The FDA's Official Register of Drugs","url":"https://www.fr.com/insights/ip-law-essentials/orange-book-101/"},{"title":"Programmatic access and formatting of U.S Food And Drug Administration (FDA) Orange Book data | paracelsus","url":"https://manuelxduval.github.io/paracelsus/"},{"title":"FDA Orange Book: Search Patents and TE Codes | Assyro AI","url":"https://www.assyro.com/blog/fda-orange-book-guide"},{"title":"orange book data files","url":"https://www.fda.gov/drugs/drug-approvals-and-databases/orange-book-data-files"},{"title":"www.fda.gov","url":"https://www.fda.gov/media/103879/download"}]

Based on the search results, I found detailed information about the FDA Orange Book data files and the products.txt columns you're asking about.

As of March 2019, the products.txt table contains attributes including: Ingredient, DF;Route, Trade_Name, Applicant, Strength, Appl_Type, Appl_No, Product_No, TE_Code, Approval_Date, RLD, RS, Type, and Applicant_Full_Name.

Here's what these specific columns contain:

• Ingredient: The active ingredient in the drug product
• Appl_No: The FDA assigned number to the application, with format nnnnnn
• Applicant: The firm name holding legal responsibility for the new drug application, condensed to a maximum twenty character unique string
• TE_Code: The TE Code indicates the therapeutic equivalence rating of generic to innovator Rx products
• RLD: The RLD is a drug product approved under section 505(c) of the FD&C Act for which FDA has made a finding of safety and effectiveness, identified by "RLD" in the RLD column

For more detailed descriptions of all variables in the products.txt file, detail descriptions are posted at https://www.fda.gov/drugs/informationondrugs/ucm129689.htm#descriptions.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #12] Excel accessibility don't rely on color alone status icons conditional formatting WCAG 1.4.1

Web search results for query: "Excel accessibility don't rely on color alone status icons conditional formatting WCAG 1.4.1"

Links: [{"title":"Creating Accessible Excel Spreadsheets: A Comprehensive Guide | The Nonprofit for Accessible Education | Benetech","url":"https://benetech.org/creating-accessible-excel-spreadsheets-a-comprehensive-guide/"},{"title":"Excel Accessibility: How to Make Excel Documents Accessible","url":"https://www.continualengine.com/blog/excel-accessibility/"},{"title":"WCAG 1.4.1: Don't rely solely on color","url":"https://wcag.dock.codes/documentation/wcag141/"},{"title":"Understanding WCAG SC 1.4.1 Use of Color • DigitalA11Y","url":"https://www.digitala11y.com/understanding-sc-1-4-1-use-of-color/"},{"title":"1.4.1 Use of Color - AAArdvark","url":"https://aaardvarkaccessibility.com/wcag-plain-english/1-4-1-use-of-color/"},{"title":"WCAG 1.4.1 Use of Color - Complete Guide with Interactive Examples | Accessibility.build","url":"https://accessibility.build/wcag/1-4-1"},{"title":"WCAG 1.4.1 - Use of Color | Fix It Series","url":"https://accessibilitychecker.com/news/wcag-fix-it-1-4-1-use-of-color/"},{"title":"WCAG Color Accessibility: Status Indicators Beyond Color Coding | accessibility.chat","url":"https://www.accessibility.chat/articles/when-color-coding-fails-why-status-indicators-need-more-than-pretty-colors"}]

Based on the search results, here's what I found about Excel accessibility and WCAG 1.4.1:

Key Principle

A common mistake is to color-code cells (e.g., red for "Overdue," green for "On Time"), but a user who is color-blind will miss this information.

WCAG 1.4.1 Requirements

Color alone should not be used as the only visual means of conveying information, indicating an action, prompting a response, or distinguishing a visual element. More specifically, to meet WCAG 1.4.1, always ensure that color is supported by at least one other visual indicator.

Best Practices for Excel

Always include a corresponding text label in an adjacent column, such as a "Status" column with the words "Overdue" or "On Time."

Use universally recognizable icons or symbols (e.g., a checkmark for success, an 'X' for error, an exclamation mark for warning) in conjunction with color.

Why It Matters

Roughly 1 in 12 men and 1 in 200 women have some form of color vision deficiency, and if a website relies solely on color differences to communicate meaning, those users may not be able to distinguish important information.

In summary, when using conditional formatting in Excel with colors, always pair it with text labels, icons, or other visual indicators to ensure the information is accessible to all users, including those with color blindness.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #13] Drugs@FDA data files Products Applications Submissions tables columns download

Web search results for query: "Drugs@FDA data files Products Applications Submissions tables columns download"

Links: [{"title":"FDA Drugs Database - Databricks Marketplace","url":"https://marketplace.databricks.com/details/cf63f2b8-da42-4ce5-a89b-9644cff0ef26/John-Snow-Labs_FDA-Drugs-Database"},{"title":"Search Databases | FDA","url":"https://www.fda.gov/industry/fda-basics-industry/search-databases"},{"title":"Drugs@FDA Data Files | FDA","url":"https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files"},{"title":"U.S. Department of Health & Human Services - Drugs@FDA Database","url":"https://catalog.data.gov/dataset/drugsfda-database"},{"title":"FDA Approved Drug Products | NBER","url":"https://www.nber.org/research/data/fda-approved-drug-products"},{"title":"Drugs@FDA Database | HealthData.gov","url":"https://healthdata.gov/FDA/Drugs-FDA-Database/8m24-qzcq"},{"title":"Downloads","url":"https://open.fda.gov/data/downloads/"},{"title":"www.fda.gov","url":"https://www.fda.gov/drugs/informationondrugs/ucm079750.htm"},{"title":"whats new drugsfda","url":"https://www.fda.gov/drugs/drug-approvals-and-databases/whats-new-drugsfda"}]

Here are the search results for Drugs@FDA data files, Products, Applications, Submissions tables, columns, and downloads:

Overview

The Drugs@FDA database is provided as a compressed file (drugsatfda.zip) that can be unzipped into 12 text tables and imported into a database, spreadsheet, or word processing program. All fields are separated by tab delimiters.

Table Structure

Drugs@FDA consists of 12 tables, including ActionTypes_Lookup, ApplicationDocs, and Applications. Each table's primary key, data types, field lengths and nulls are documented.

Download and Updates

The data file is updated each morning, Monday through Friday. The FDA provides Data Definitions and an Entity Relationship Diagram (ERD) for Drugs@FDA as of January 10, 2025.

Content

The database provides information on drug (generic) name, active ingredient, form and strength available, FDA application number, label info, dosage form or route, marketing status and pharmaceutical company as well as patient information, approval letters, review and other facts for drugs approved after 1997.

The official FDA source for downloading these files and accessing the complete table definitions and entity relationship diagram is available at the FDA's Drugs@FDA Data Files page.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #14] 약업신문 원료의약품 DMF 등록 신규 변경 취하 주간 현황

Web search results for query: "약업신문 원료의약품 DMF 등록 신규 변경 취하 주간 현황"

Links: [{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&schText=&categoryId=&continent=&country=&upDown=0&boardStyle=&no1=912&linkId=26604564"},{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"[지침]원료의약품 등록(DMF) 처리 절차 < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=1&rowCnt=10&menuId=MENU01872&maxIndex=99999999999999&minIndex=99999999999999&schType=0&upDown=0&no1=0&linkId=26605812"},{"title":"식약처, 원료의약품 등록 제도(DMF) 해설서 발간 < 의약정책 < 단신 < 기사본문 - 의학신문","url":"http://www.bosa.co.kr/news/articleView.html?idxno=2141146"},{"title":"원료의약품 등록 제도(DMF) 꼼꼼히 알기! | 경제정책자료 | KDI 경제교육·정보센터","url":"https://eiec.kdi.re.kr/policy/materialView.do?num=209012&topic=&pp=20&datecount=&recommend=&pg="},{"title":"원료의약품 등록제도(DMF), 궁금하면 클릭하세요! | 경제정책자료 | KDI 경제교육·정보센터","url":"https://eiec.kdi.re.kr/policy/materialView.do?num=196213&topic=L&pp=20"},{"title":"원료의약품등록에관한규정","url":"https://www.law.go.kr/%ED%96%89%EC%A0%95%EA%B7%9C%EC%B9%99/%EC%9B%90%EB%A3%8C%EC%9D%98%EC%95%BD%ED%92%88%EB%93%B1%EB%A1%9D%EC%97%90%EA%B4%80%ED%95%9C%EA%B7%9C%EC%A0%95"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000198136"},{"title":"사업소개>의약품>허가심사>KDMF | 식품의약품안전평가원","url":"https://www.nifds.go.kr/brd/m_87/list.do"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"}]

I've performed a web search for your query about pharmaceutical industry news regarding DMF (Drug Master File) registrations.

The search results provide information about 원료의약품 등록 제도(DMF)는 신약의 원료의약품 또는 식약처장이 정해 고시하는 원료의약품을 제조해 판매하려는 경우 식약처에 등록하는 제도.

The results include:

1. 주간 원료의약품 등록현황(신규등록, 변경등록, 연차보고)을 우리처 홈페이지 전자민원창구에 게시 - information about weekly DMF registration status

2. 식품의약품안전처의 '원료의약품등록(DMF)현황' OpenAPI는 등록된 원료의약품(DMF)의 현황을 조회할 수 있는 공공데이터

3. 식품의약품안전처는 완제의약품-원료의약품 간 연계심사를 위한 등록대상 원료의약품에 대한 심사 절차를 개선하고, 이를 반영한 '원료의약품 등록 제도(DMF) 해설서'를 발간했다

For the most current weekly DMF registration status information, you may want to visit the MFDS (Ministry of Food and Drug Safety) official website or check the pharmaceutical industry news portal directly.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #15] pandas to_excel xlsxwriter add_table freeze_panes autofilter header format multiple sheets dashboard example

Web search results for query: "pandas to_excel xlsxwriter add_table freeze_panes autofilter header format multiple sheets dashboard example"

Links: [{"title":"pandas.DataFrame.to_excel — pandas 3.0.5 documentation","url":"https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html"},{"title":"XlsxWriter/dev/docs/source/working_with_pandas.rst at main · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/blob/main/dev/docs/source/working_with_pandas.rst"},{"title":"Working with Pandas and XlsxWriter - Read the Docs","url":"https://xlsxwriter.readthedocs.io/working_with_pandas.html"},{"title":"Example: Freeze Panes and Split Panes — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_panes.html"},{"title":"Enhance Your Pandas Excel Output: Freezing Panes, Filtering, and Adjusting Column Widths","url":"https://velog.io/@sacross93/Enhance-Your-Pandas-Excel-Output-Freezing-Panes-Filtering-and-Adjusting-Column-Widths"},{"title":"Pandas DataFrame DataFrame.to_excel() Function | Delft Stack","url":"https://www.delftstack.com/api/python-pandas/pandas-dataframe-dataframe.to_excel-function/"},{"title":"pyspark.pandas.DataFrame.to excel","url":"https://api-docs.databricks.com/python/pyspark/latest/pyspark.pandas/api/pyspark.pandas.DataFrame.to_excel.html"},{"title":"github.com","url":"https://github.com/pandas-dev/pandas/pull/62994.diff"}]

Here are the search results for your query about pandas, to_excel, xlsxwriter, and Excel formatting options:

Key Information Found:

Multiple Sheets: To write to multiple sheets it is necessary to create an ExcelWriter object with a target file name, and specify a sheet in the file to write to. Multiple sheets may be written to by specifying unique sheet_name.

Freeze Panes: The to_excel() method supports a freeze_panes parameter, and freeze_panes=(1,1) specifies that the excel file has the frozen top row and frozen first column.

Autofilter: The to_excel() method supports an autofilter parameter, and you can add filters using ws.autofilter(0, 0, df.shape[0] - 1, df.shape[1] - 1) after writing to Excel.

Example with Multiple Dataframes: You can write each dataframe to a different worksheet using df1.to_excel(writer, sheet_name='Sheet1'), df2.to_excel(writer, sheet_name='Sheet2'), etc.

The search results provide documentation from official pandas and XlsxWriter sources, showing how to combine these features for creating formatted Excel outputs with multiple sheets and advanced formatting options.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #16] PharmaCompass DMF tracker new DMF filings quarterly API supplier dashboard

Web search results for query: "PharmaCompass DMF tracker new DMF filings quarterly API supplier dashboard"

Links: [{"title":"PDMS API Manufacturers | Suppliers | Drug Master Files (DMF) | CEP | Pharmacompass.com","url":"https://www.pharmacompass.com/manufacturers-suppliers-exporters/pdms"},{"title":"DMCTC API Manufacturers | Suppliers | Drug Master Files (DMF) | CEP | Pharmacompass.com","url":"https://www.pharmacompass.com/manufacturers-suppliers-exporters/dmctc"},{"title":"API Manufacturers | Suppliers | Drug Master Files (DMF) | CEP | Pharmacompass.com","url":"https://www.pharmacompass.com/manufacturers-suppliers-exporters"},{"title":"API - Uses, DMF, Dossier, Manufacturer, Supplier, Licensing, Distributer, Prices, News, GMP","url":"https://www.pharmacompass.com/apis-products"},{"title":"US Drug Master Files (DMF) Database | PharmaCompass.com","url":"https://www.pharmacompass.com/us-drug-master-files-dmfs"},{"title":"PAS API Manufacturers | Suppliers | Drug Master Files (DMF) | CEP | Pharmacompass.com","url":"https://www.pharmacompass.com/manufacturers-suppliers-exporters/pas"},{"title":"LOC API Manufacturers | Suppliers | Drug Master Files (DMF) | CEP | Pharmacompass.com","url":"https://www.pharmacompass.com/manufacturers-suppliers-exporters/loc"},{"title":"Find APIs and FDF Suppliers | PharmaCompass.com","url":"https://www.pharmacompass.com/find-suppliers"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"},{"title":"What Does DMF Mean? Drug Master Files Explained (2026)","url":"https://www.tianmingpharm.com/what-does-dmf-mean/"}]

Based on the search results, here's what I found about PharmaCompass and DMF tracking:

PharmaCompass is a third-party database that aggregates DMF data with additional filtering. The platform maintains a list of all manufacturers, suppliers & exporters of API listed on PharmaCompass with details of regulatory filings.

PharmaCompass provides a Drug Master File (DMF) database listing DMFs for Active Pharmaceutical Ingredients submitted to the FDA. Users can search an integrated database for USFDA DMFs, CEP/COS, and approved drugs in various countries.

The search results mention that Q3 2024 set a record for new DMF filings with the FDA, with China's Type II DMF submissions jumping 58% in that quarter, indicating that quarterly DMF filing data is being tracked by industry sources.

However, the search results don't contain specific details about a dedicated "DMF tracker" feature, "quarterly API" reports, or a "supplier dashboard" API specifically. For more detailed information about those specific features and services, you may want to visit PharmaCompass.com directly or contact their support team.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #17] Excel change tracking diff highlight new rows previous snapshot conditional formatting COUNTIF python openpyxl

Web search results for query: "Excel change tracking diff highlight new rows previous snapshot conditional formatting COUNTIF python openpyxl"

Links: [{"title":"Adding Conditional Formatting to Excel Using Python Openpyxl - GeeksforGeeks","url":"https://www.geeksforgeeks.org/python/adding-conditional-formatting-to-excel-using-python-openpyxl/"},{"title":"Working with Conditional Formatting — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/working_with_conditional_formats.html"},{"title":"Adding Conditional Formatting (Video) – Real Python","url":"https://realpython.com/lessons/conditional-formatting/"},{"title":"How to Implement Excel-Style Conditional Logic with Openpyxl in Python","url":"https://www.statology.org/how-to-implement-excel-style-conditional-logic-with-openpyxl-in-python/"},{"title":"Diff Two Excel Files with Python | Matthew Kudija","url":"https://matthewkudija.com/blog/2018/07/21/excel-diff/"},{"title":"Conditional Format - Master OpenPyXL","url":"https://www.openpyxl.com/conditional-format.html"},{"title":"openpyxl Part 13 – Conditional Styling - Prospero Coder","url":"https://prosperocoder.com/science/openpyxl-part-13-conditional-styling/"},{"title":"0% found this document useful (0 votes)","url":"https://www.scribd.com/document/44201206/Excel-Tips"}]

Here are the search results for your query on Excel change tracking, diff highlighting, and conditional formatting with Python openpyxl:

Key Findings:

Conditional Formatting with openpyxl: Adding conditional formatting using openpyxl is an easy and straightforward process. The Python library openpyxl allows us to define various types of conditional formatting rules, including CellIsRule for formatting cells based on comparisons like greater than or less than.

Excel Diff and Change Tracking: One practical example shows highlighting anything that has changed while graying out anything that stayed the same, using conditional formatting for quick visual inspection. Using conditional formatting, you can highlight changed cells by checking if they contain specific markers (like arrows) and apply appropriate formatting to both changed and unchanged cells.

COUNTIF for Highlighting Duplicates: COUNTIF can be used in conditional formatting rules to highlight duplicate values, for example with the formula COUNTIF($A$1:$A$10,A1)>1 to highlight duplicates in yellow.

Built-in Patterns: openpyxl has built-in patterns to make common conditional formatting rules easier to apply, including ColorScale, IconSet, and DataBar.

The search results provide practical examples for comparing Excel versions, detecting changes between snapshots, and applying dynamic conditional formatting to highlight new or modified rows using Python.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #12] https://www.fda.gov/drugs/forms-submission-requirements/drug-master-files-dmfs

ASK: Find the section on the "List of DMFs" / DMF list spreadsheet: file formats (xlsx/txt), columns included (DMF#, status, type, submit date, holder, subject), update frequency, and links to the download files.

The server returned HTTP 404 Not Found.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #13] https://chandoo.org/wp/2011/08/25/simple-kpi-dashboard-using-excel/

ASK: Summarize the concrete design steps and principles (layout, what goes on top, use of conditional formatting/icons/sparklines, colors) and any downloadable template link.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #14] https://www.fda.gov/drugs/drug-approvals-and-databases/orange-book-data-files

ASK: List the data files provided (products.txt, patent.txt, exclusivity.txt), their columns/fields, delimiter, and update frequency.

The server returned HTTP 404 Not Found.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #15] https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files

ASK: List the tables in drugsatfda.zip (names), key columns of Applications, Products, Submissions, MarketingStatus, and the update frequency.

The server returned HTTP 404 Not Found.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #16] https://nedrug.mfds.go.kr/bbs/117

ASK: Describe the page: list of posts (제목 형식, e.g., '원료의약품 등록 공고(신규/변경/취하)'), attachment formats (hwp/xlsx/pdf), posting frequency, and sample columns if shown.

Page Description

This is a list view of DMF (Drug Master File) registration announcements from South Korea's pharmaceutical safety portal (의약품안전나라).

Post Format

Posts follow the pattern: "등록대상 원료의약품(DMF) 등록 공고" with date ranges in parentheses (e.g., 2021년 2월 1,2주차, 2021.2.1.-2021.02.14)

Posting Frequency

Biweekly or weekly announcements, with entries spanning from November 2020 through February 2021 visible in the current list

Table Columns Displayed

• 연번 (Serial number)
• 제목 (Title/Subject)
• 조회건수 (View count)
• 등록자 (Registrant - shown as masked: 김**)
• 등록일자 (Registration date)

Additional Details

• Total of 710 records available
• Currently showing 10 results per page (adjustable to 20, 30, 40, or 50)
• No specific attachment format information (hwp/xlsx/pdf) is visible on this list view page

[FETCH #17] https://matthewkudija.com/blog/2018/07/21/excel-diff/

ASK: Extract the approach and code for diffing two Excel files with pandas and highlighting changes (added/removed/changed rows) via openpyxl or xlsxwriter conditional formatting. Include code verbatim where possible.

Excel Diff Approach with Pandas and XlsxWriter

Overview

The article presents two solutions for comparing Excel files using pandas and XlsxWriter's conditional formatting.

Solution 1: Same Shape Files

Approach: Compare files with identical dimensions, flagging cell-level changes.

Core Logic:

import pandas as pd

df_OLD = pd.read_excel(path_OLD).fillna(0)
df_NEW = pd.read_excel(path_NEW).fillna(0)

dfDiff = df_OLD.copy()
for row in range(dfDiff.shape[0]):
    for col in range(dfDiff.shape[1]):
        value_OLD = df_OLD.iloc[row,col]
        try:
            value_NEW = df_NEW.iloc[row,col]
            if value_OLD==value_NEW:
                dfDiff.iloc[row,col] = df_NEW.iloc[row,col]
            else:
                dfDiff.iloc[row,col] = ('{}-->{}').format(value_OLD,value_NEW)
        except:
            dfDiff.iloc[row,col] = ('{}-->{}').format(value_OLD, 'NaN')

Formatting with XlsxWriter:

writer = pd.ExcelWriter(fname, engine='xlsxwriter')
workbook = writer.book
worksheet = writer.sheets['DIFF']

highlight_fmt = workbook.add_format({'font_color': '#FF0000', 'bg_color':'#B1B3B3'})
grey_fmt = workbook.add_format({'font_color': '#E0E0E0'})

worksheet.conditional_format('A1:ZZ1000', {'type': 'text',
                                           'criteria': 'containing',
                                           'value':'→',
                                           'format': highlight_fmt})

Solution 2: Variable Rows/Columns (2019 Update)

Uses index column to track added/removed rows, with color coding: red for changes, green for new rows, grey for dropped rows.

Key Enhancement: Employs df.loc[] with index column instead of positional indexing, enabling row-level tracking.

[FETCH #18] https://leucine.ai/fda-tracker/

ASK: Describe the tracker UI/features: watchlist upload, alert types, dashboard views (by company, by country, trend over time), what fields are shown per record, and any export format.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #19] https://xlsxwriter.readthedocs.io/working_with_pandas.html

ASK: Extract code showing how to get the workbook/worksheet from pd.ExcelWriter(engine='xlsxwriter'), add formats, set column widths, add charts referencing the dataframe range, and add_table over a dataframe. Verbatim code snippets.

Working with Pandas and XlsxWriter

Accessing Workbook and Worksheet Objects

import pandas as pd

# Create a Pandas dataframe from the data.
df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('pandas_simple.xlsx', engine='xlsxwriter')

# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')

# Get the xlsxwriter objects from the dataframe writer object.
workbook  = writer.book
worksheet = writer.sheets['Sheet1']

Adding Formats and Setting Column Widths

# Add some cell formats.
format1 = workbook.add_format({'num_format': '#,##0.00'})
format2 = workbook.add_format({'num_format': '0%'})

# Set the column width and format.
worksheet.set_column(1, 1, 18, format1)

# Set the format but not the column width.
worksheet.set_column(2, 2, None, format2)

Adding Charts

# Create a chart object.
chart = workbook.add_chart({'type': 'column'})

# Get the dimensions of the dataframe.
(max_row, max_col) = df.shape

# Configure the series of the chart from the dataframe data.
chart.add_series({'values': ['Sheet1', 1, 1, max_row, 1]})

# Insert the chart into the worksheet.
worksheet.insert_chart(1, 3, chart)

Adding a Worksheet Table

# Write dataframe without index/header, starting 1 row forward
df.to_excel(writer, sheet_name='Sheet1',
            startrow=1, header=False, index=False)

# Create column headers for the table
column_settings = [{'header': column} for column in df.columns]

# Get dimensions and add table structure
(max_row, max_col) = df.shape
worksheet.add_table(0, 0, max_row, max_col - 1, 
                    {'columns': column_settings})

[FETCH #20] https://xlsxwriter.readthedocs.io/working_with_tables.html

ASK: Extract add_table() options: data, columns (header, formula, format, total_function), style names (e.g. 'Table Style Medium 2'), header_row, banded_rows, autofilter, first_column, total_row, name. Include example code.

XlsxWriter add_table() Options Reference

Core Options

data: Accepts a list of lists containing row data to populate the table cells.

columns: Configures individual column properties using a list of dictionaries. Supported sub-properties include:

• header: Custom column heading text
• header_format: Format object for header styling
• formula: Column formulas using Excel table references
• format: Format object for column data cells
• total_function: Aggregation function (sum, average, count, max, min, std_dev, var, count_nums)
• total_string: Label for total row
• total_value: Calculated value for formulas

style: Sets table appearance using Excel's standard names like 'Table Style Medium 9' (default) or 'Table Style Light 11'. Set to None to disable styling.

Display Options

• header_row: Enables/disables header row (default: True)
• autofilter: Shows filter dropdowns in headers (default: True, requires header_row enabled)
• banded_rows: Alternating row colors (default: True)
• banded_columns: Alternating column colors (default: False)
• first_column: Highlights first column (default: False)
• total_row: Adds totals row with SUBTOTAL functions (default: False)
• name: Custom table identifier (default: Table1, Table2, etc.)

Usage Example

worksheet.add_table('B3:G8', {
    'data': data,
    'style': 'Table Style Medium 9',
    'total_row': True,
    'columns': [
        {'header': 'Product', 'total_string': 'Totals'},
        {'header': 'Q1', 'total_function': 'sum', 'format': currency_fmt}
    ]
})

[FETCH #21] https://www.accessibility.chat/articles/when-color-coding-fails-why-status-indicators-need-more-than-pretty-colors

ASK: Summarize the recommended patterns for status indicators beyond color: icons, text labels, shapes, patterns; any specific color+icon combos recommended.

Status Indicator Accessibility Patterns

The article recommends a multi-modal design approach combining several complementary techniques:

Core Recommended Patterns:

• Text labels: Direct descriptors like "Online," "Degraded," or "Offline"
• Icons: Checkmarks (✓), warning triangles (⚠), and X marks (✕)
• Visual patterns: Solid fills for active states, hatched patterns for warnings, stippled backgrounds for errors
• Shape variation: Circles for normal states, squares for warnings, triangles for critical alerts

Key Principle: The article emphasizes that "successful implementations pair visual indicators with multiple channels of information" rather than relying on color alone. This approach serves all users better, particularly the millions affected by color blindness (approximately 8% of men and 0.5% of women).

Notable Approach: The article does not recommend specific color-plus-icon combinations. Instead, it advocates building these requirements directly into design system components so developers cannot create color-only patterns—making inclusive design the default rather than an afterthought.

The core message: clarity comes from redundant signaling across multiple modes, not from perfecting any single visual channel.

[FETCH #22] https://eiec.kdi.re.kr/policy/materialView.do?num=209012&topic=&pp=20&datecount=&recommend=&pg=

ASK: 원료의약품 등록제도(DMF) 설명 요약: 등록대상, 신규등록/변경등록/연차보고/취하의 정의, 공고 주기, 등록번호 체계, 관련 통계.

Summary: DMF (Drug Master File) Registration System

Based on the KDI Economic Education and Information Center document, here's what you need to know about Korea's pharmaceutical ingredient registration system:

Overview

The Korea Food and Drug Administration released a comprehensive guide on December 29, 2020, explaining the DMF (Drug Master File) registration system for pharmaceutical raw materials.

Key Updates

The guide covers several important areas:

• Linked Review Process: Details on how raw material registrations connect with finished drug approvals
• Expanded Registration Scope: New categories of pharmaceutical ingredients now require registration following regulatory changes
• procedural improvements: Enhanced examination procedures for registered pharmaceutical materials

Purpose

According to the announcement, "원료의약품 등록에 필요한 자료를 준비하는 데 도움이 될 것으로 기대함" (the guide is expected to help the pharmaceutical industry prepare necessary documentation for raw material registration).

Development

The improvements were developed through a collaborative task force focused on enhancing raw material registration procedures.

This initiative reflects South Korea's effort to streamline pharmaceutical supply chain oversight and facilitate better coordination between ingredient suppliers and drug manufacturers.

[SEARCH #18] openpyxl IconSetRule FormulaRule CellIsRule example status column highlight

Web search results for query: "openpyxl IconSetRule FormulaRule CellIsRule example status column highlight"

Links: [{"title":"Adding Conditional Formatting to Excel Using Python Openpyxl - GeeksforGeeks","url":"https://www.geeksforgeeks.org/python/adding-conditional-formatting-to-excel-using-python-openpyxl/"},{"title":"openpyxl.formatting.rule module — openpyxl 3.0.10 documentation","url":"https://openpyxl.readthedocs.io/en/3.0/api/openpyxl.formatting.rule.html"},{"title":"openpyxl.formatting.rule module — openpyxl 3.1.4 documentation","url":"https://openpyxl.readthedocs.io/en/latest/api/openpyxl.formatting.rule.html"},{"title":"openpyxl.formatting.rule module — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html"},{"title":"openpyxl.formatting.rule module — openpyxl 3.1.1 documentation","url":"https://openpyxl.readthedocs.io/en/3.1.1/api/openpyxl.formatting.rule.html"},{"title":"Conditional Formatting — openpyxl 3.1.2 documentation","url":"https://openpyxl.readthedocs.io/en/3.1.2/formatting.html"},{"title":"Conditional Formatting — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/formatting.html"},{"title":"Conditional Formatting — openpyxl 3.1.1 documentation","url":"https://openpyxl.readthedocs.io/en/3.1.1/formatting.html"},{"title":"Conditional Formatting — openpyxl 3.1.4 documentation","url":"https://openpyxl.readthedocs.io/en/3.1/formatting.html"},{"title":"PyTutorial | Python openpyxl Conditional Formatting Guide","url":"https://pytutorial.com/python-openpyxl-conditional-formatting-guide/"}]

Based on the search results, here's what I found about openpyxl conditional formatting rules:

Overview of the Three Rule Types

CellIsRule: This rule indicates that formatting should be applied based on the comparison between cell values and a specific condition, such as greater than or less than.

FormulaRule: This rule involves applying formatting based on the result of a formula.

IconSetRule: This rule involves displaying icons in the cells based on the values of the cells.

Practical Examples

CellIsRule Example

CellIsRule can be used to highlight cells greater than 40 in red, where a PatternFill object defines the fill color and the rule is applied to a range like A1:D4.

FormulaRule Example

Formula-based conditional formatting can highlight even numbers in blue using a FormulaRule with a formula like MOD(A1,2)=0.

IconSetRule Example

An IconSetRule can apply a 3-arrow icon set with percentage-based thresholds, for example: IconSetRule(icon_style='3Arrows', type='percent', values=[30, 60, 80]).

These rules can all be applied using the ws.conditional_formatting.add() method to format specific cell ranges in your Excel worksheet.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #19] storytellingwithdata.com dashboard tips Cole Nussbaumer Knaflic "dashboard" blog

Web search results for query: "storytellingwithdata.com dashboard tips Cole Nussbaumer Knaflic "dashboard" blog"

Links: [{"title":"Storytelling with Data: A Data Visualization Guide for Business Professionals: Nussbaumer Knaflic, Cole: 9781119002253: Amazon.com: Books","url":"https://www.amazon.com/Storytelling-Data-Visualization-Business-Professionals/dp/1119002257"},{"title":"Storytelling with Data: A Data Visualization Guide for Business Professionals | Wiley","url":"https://www.wiley.com/en-us/Storytelling+with+Data:+A+Data+Visualization+Guide+for+Business+Professionals-p-9781119002253"},{"title":"Storytelling with data: What a book! | by Sam Campitiello | Medium","url":"https://medium.com/@sam.campitiello/storytelling-with-data-what-a-book-1cea585ca7c0"},{"title":"storytelling with data podcast - improve your data visualization and presentation skills","url":"https://www.storytellingwithdata.com/podcast"},{"title":"order our newest book, storytelling with data: before & after","url":"https://www.storytellingwithdata.com/books"},{"title":"Book Summary - Storytelling with Data - Cole Knaflic","url":"https://readingraphics.com/book-summary-storytelling-with-data/"},{"title":"storytelling with data - Vizalyst","url":"https://vizalyst.com/wp-content/uploads/2025/03/Cole-Knaflic-Storytelling-with-data-a-data-visualization-guide-for-business-professionals-Knaflic-Cole-Nussbaumer-Storytelling-with-data-a-dat.pdf"},{"title":"Bild 1 von 3","url":"https://www.ebay.de/itm/116667462617"}]

I've completed the web search for "storytellingwithdata.com dashboard tips Cole Nussbaumer Knaflic". The search results include information about Cole Nussbaumer Knaflic, her company Storytelling with Data, and related resources.

Here are the key findings:

About Cole Nussbaumer Knaflic and Storytelling with Data: Cole Nussbaumer Knaflic is founder and CEO of storytelling with data (SWD) and author of the best-selling book, storytelling with data: a data visualization guide for business professionals, which has been translated into a dozen languages and is used as a textbook by more than 100 universities.

Resources Available: The organization helps people create graphs and weave them into a compelling story through the popular SWD blog, podcast, monthly challenge, and live stream events.

Dashboard-Related Content: The search results included a reference to podcast episodes related to dashboards, including an episode titled "why dashboards die—and how to save them" and another called "Dashboards That Deliver".

If you're looking for specific dashboard tips or blog posts from storytellingwithdata.com, you may want to visit the website directly at storytellingwithdata.com or search their blog specifically for dashboard-related articles.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #20] excelcampus.com dashboard design tips Jon Acampora Excel dashboard best practices

Web search results for query: "excelcampus.com dashboard design tips Jon Acampora Excel dashboard best practices"

Links: [{"title":"Excel Campus | Master Excel. Dominate Deadlines.","url":"https://www.excelcampus.com/"},{"title":"Use AI to Design Excel Dashboards Fast","url":"https://www.excelcampus.com/charts/use-ai-to-design-excel-dashboard/"},{"title":"Jon Acampora - ExcelCampus.com | Microsoft MVP","url":"https://www.linkedin.com/in/jonacampora/"},{"title":"7 Excel Dashboard Tools & Tips for the Quick Access Toolbar - Excel Campus","url":"https://www.excelcampus.com/charts/7-excel-dashboard-tips-qat/"},{"title":"Introduction to Pivot Tables and Dashboards [Video 1 of 3]","url":"https://www.excelcampus.com/pivot-tables/pivot-tables-dashboards-part-1/"},{"title":"How to Create a Dashboard in Excel: A Step-by-Step Tutorial | DataCamp","url":"https://www.datacamp.com/tutorial/create-excel-dashboards-tutorial"},{"title":"Build an Interactive Excel Dashboard with Pivot Tables","url":"https://www.excelcampus.com/charts/excel-dahsboard-tutorial-full-buildout/"},{"title":"About Jon Acampora","url":"https://www.excelcampus.com/about/"},{"title":"Video Review of the Excel Dashboard Course from My Online Training Hub","url":"https://www.excelcampus.com/charts/excel-dashboard-course-review/"},{"title":"Excel Campus - Jon - YouTube","url":"https://www.youtube.com/user/ExcelCampus"}]

I found several resources from Excel Campus about Excel dashboard design and best practices by Jon Acampora. Here are the key findings:

Overview

Jon Acampora is the Owner & Founder of Excel Campus and a former financial analyst who has been focusing on Excel education for years. Excel Campus has over 500,000 YouTube subscribers and over 44 million all-time views.

Dashboard Design Content

Designing an Excel dashboard is one of those tasks that trips up even experienced analysts, with the design part—figuring out which charts to use, how to lay them out, and what your audience actually needs to see—being where most people get stuck.

Excel Campus offers several resources on dashboard design:

1. AI-Powered Dashboard Design: Acampora shows a three-step AI workflow to rapidly prototype a dashboard design using Claude, Gemini, and ChatGPT, so you can iterate in minutes instead of days.

2. Interactive Dashboard Building: A comprehensive tutorial walks through creating every Pivot Table that powers the dashboard, from KPI cards to charts, including a top 5 items chart, a sales-over-time chart with a week/month toggle, and a customer mix chart.

3. Quick Access Toolbar Tips: Excel Campus covers the best tools to put on the Quick Access Toolbar when creating Excel Dashboards.

You can visit excelcampus.com for more detailed tutorials, videos, and courses on Excel dashboard design and best practices.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #21] 식약처 원료의약품 등록 공고 변경등록 취하 연차보고 종류 등록번호 체계 "원료의약품 등록에 관한 규정"

Web search results for query: "식약처 원료의약품 등록 공고 변경등록 취하 연차보고 종류 등록번호 체계 "원료의약품 등록에 관한 규정""

Links: [{"title":"원료의약품 등록에 관한 규정","url":"https://www.law.go.kr/conAdmrulByLsPop.do?lsiSeq=217283&joNo=0031&joBrNo=02&datClsCd=010102&dguBun=DEG&lnkText=%EC%8B%9D%ED%92%88%EC%9D%98%EC%95%BD%ED%92%88%EC%95%88%EC%A0%84%EC%B2%98%EC%9E%A5%EC%9D%B4+%EC%A0%95%ED%95%98%EC%97%AC+%EA%B3%A0%EC%8B%9C%ED%95%98%EB%8A%94&admRulPttninfSeq=1526"},{"title":"원료의약품 등록에 관한 규정","url":"https://www.mfds.go.kr/brd/m_211/view.do?seq=14569&srchFr=&srchTo=&srchWord=&srchTp=&itm_seq_1=0&itm_seq_2=0&multi_itm_seq=0&company_cd=&company_nm=&page=1"},{"title":"「원료의약품 등록에 관한 규정」고시전문","url":"https://www.mfds.go.kr/brd/m_211/view.do?seq=14870&srchFr=&srchTo=&srchWord=&srchTp=&itm_seq_1=0&itm_seq_2=0&multi_itm_seq=0&company_cd=&company_nm=&Data_stts=A&page=1"},{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&schText=&categoryId=&continent=&country=&upDown=0&boardStyle=&no1=912&linkId=26604564"},{"title":"원료의약품 품질심사, 완제약 허가신청 돼야 동시 진행 < 식약처 < 정책 < 기사본문 - 히트뉴스","url":"http://www.hitnews.co.kr/news/articleView.html?idxno=17459"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://www.law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000150569"},{"title":"「원료의약품 등록에 관한 규정」고시 개정 알림 < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&no1=3447&linkId=48923038&menuId=MENU01872&maxIndex=&minIndex=&schType=0&schText=&schStartDate=&schEndDate=&boardStyle=&categoryId=&continent=&country="},{"title":"「원료의약품 등록에 관한 규정」(식약처 고시) 일부개정 알림","url":"https://www.kpbma.or.kr/info/law/statute/select/210036"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000252602"},{"title":"Substance of very high concern","url":"https://en.wikipedia.org/wiki/Substance_of_very_high_concern"}]

Based on the web search results, I found relevant information about the "원료의약품 등록에 관한 규정" (Regulations on Registration of Raw Materials for Pharmaceuticals):

Key Information Found:

The "원료의약품 등록에 관한 규정" (Regulations on Registration of Raw Materials for Pharmaceuticals) was most recently updated by the Korea Ministry of Food and Drug Safety Notice No. 2024-89 on December 30, 2024.

Weekly raw material pharmaceutical registration status (new registrations, change registrations, and annual reports) is posted on the Korea Ministry of Food and Drug Safety website at the electronic civil services portal.

The regulation covers various registration-related matters including:

• Registration applications for target raw materials for pharmaceuticals (DMF)
• Change management procedures that differ depending on whether a finished pharmaceutical product exists

You can access the full text of the regulation at:

• Korea National Law Information Center (국가법령정보센터): https://www.law.go.kr
• Korea Ministry of Food and Drug Safety (식품의약품안전처): https://www.mfds.go.kr

The most recent version (2024-89, effective December 30, 2024) can be downloaded from the Korea Ministry of Food and Drug Safety website in .hwpx format.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #22] Claus Wilke Fundamentals of Data Visualization Okabe-Ito color pitfalls chapter

Web search results for query: "Claus Wilke Fundamentals of Data Visualization Okabe-Ito color pitfalls chapter"

Links: [{"title":"Fundamentals of Data Visualization","url":"https://clauswilke.com/dataviz/color-pitfalls.html"},{"title":"Fundamentals of Data Visualization: A Primer on Making Informative and ... - Claus Wilke - Google Books","url":"https://books.google.com/books/about/Fundamentals_of_Data_Visualization.html?id=L3ajtgEACAAJ"},{"title":"Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures by Claus O. Wilke | Goodreads","url":"https://www.goodreads.com/book/show/40014286-fundamentals-of-data-visualization"},{"title":"Color scales","url":"https://wilkelab.org/SDS375/slides/color-scales.html"},{"title":"Fundamentals of Data Visualization [Book]","url":"https://www.oreilly.com/library/view/fundamentals-of-data/9781492031079/"},{"title":"Amazon.com: Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures: 9781492031086: Wilke, Claus O.: Books","url":"https://www.amazon.com/Fundamentals-Data-Visualization-Informative-Compelling/dp/1492031089"},{"title":"Book Summary: Fundamentals of Data Visualization by Claus O. Wilke","url":"https://www.luckybookshelf.com/fundamentals-of-data-visualization-by-claus-o-wilke/"},{"title":"Okabe-Ito Palette Hex Codes for Python, R & CSS","url":"https://conceptviz.app/blog/okabe-ito-palette-hex-codes-complete-reference"},{"title":"Best Scientific Color Palettes: Hex Codes & Examples","url":"https://conceptviz.app/blog/scientific-color-palette-for-research-papers-and-posters"},{"title":"Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures [1 ed.] 1492031089, 9781492031086 - DOKUMEN.PUB","url":"https://dokumen.pub/fundamentals-of-data-visualization-a-primer-on-making-informative-and-compelling-figures-1nbsped-1492031089-9781492031086.html"}]

Based on the search results, I found relevant information about Claus Wilke's "Fundamentals of Data Visualization" and the Okabe-Ito color palette in relation to color pitfalls.

The Okabe-Ito palette is presented as a qualitative color palette for all color-vision deficiencies in the book. The Okabe Ito scale is the default scale used throughout the book.

In the "Color Pitfalls" chapter, while there are several good, colorblind-safe (cvd-safe) color scales readily available, they are not magic bullets—it is very possible to use a cvd-safe scale and yet produce a figure a person with cvd cannot decipher. One critical parameter is the size of the colored graphical elements, as colors are much easier to distinguish when they are applied to large areas than to small ones or thin lines.

The Okabe-Ito palette was created by Masataka Okabe and Kei Ito at the Color Universal Design organization, and it provides 8 colors that remain distinguishable for people with all common types of color vision deficiency.

If you'd like to view the full chapter, the content is available at https://clauswilke.com/dataviz/color-pitfalls.html.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #23] 식품의약품통계연보 의약품 원료의약품 등록 DMF 통계 건수 연도별 국가별

Web search results for query: "식품의약품통계연보 의약품 원료의약품 등록 DMF 통계 건수 연도별 국가별"

Links: [{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&upDown=0&no1=912&linkId=26604564"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 정보","url":"https://nedrug.mfds.go.kr/bbs/117"},{"title":"2022년 식품의약품통계연보(제 24호)","url":"https://www.mfds.go.kr/brd/m_371/view.do?seq=30721"},{"title":"2020년 식품의약품통계연보(제22호)","url":"https://www.mfds.go.kr/brd/m_371/view.do?seq=30719&srchFr=&srchTo=&srchWord=&srchTp=&itm_seq_1=0&itm_seq_2=0&multi_itm_seq=0&company_cd=&company_nm=&page=1"},{"title":"2023년 식품의약품통계연보(제 25호)","url":"https://www.mfds.go.kr/brd/m_371/view.do?seq=30722&itm_seq_1=0&itm_seq_2=0&multi_itm_seq=0&page=1"},{"title":"식품의약품안전처>통계>통계간행물>식품의약품 통계연보 | 식품의약품안전처","url":"https://www.mfds.go.kr/brd/m_371/list.do"},{"title":"식품의약품안전처>통계>통계안내 | 식품의약품안전처","url":"https://www.mfds.go.kr/pgm/m_538/statInformation.do"},{"title":"식품의약품안전처_식의약 통계 정보 서비스_20210614 | 공공데이터포털","url":"https://www.data.go.kr/data/15047676/fileData.do"}]

웹 검색 결과를 요약하면 다음과 같습니다:

식품의약품안전처의 「원료의약품등록(DMF)현황」 OpenAPI는 등록된 원료의약품(DMF)의 현황을 조회할 수 있는 공공데이터입니다. 주요 제공항목에는 등록번호, 성분명, 업체명, 제조소명, 제조소 소재지, 제조국가명, 발급일자 등이 포함되어 있습니다.

또한 식품의약품통계연보는 식의약품 안전관리 기본통계와 국내·외 주요 통계자료를 수록하고 있으며, 최신 버전은 2023년 식품의약품통계연보(제25호)로 2022년말 기준으로 작성되었습니다.

원료의약품 등록 DMF 통계 자료는 다음 경로에서 확인할 수 있습니다:

• 공공데이터포털: https://www.data.go.kr/data/15057075/openapi.do
• 식품의약품안전처 통계연보: https://www.mfds.go.kr/brd/m_371/list.do

검색 결과에서 구체적인 연도별, 국가별 통계 건수는 포함되어 있지 않으나, 위의 공개 데이터 포털과 통계연보 PDF 다운로드를 통해 상세 통계 정보를 확인할 수 있습니다.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #24] EDQM CEP certification database columns certificate holder substance status "Certification database"

Web search results for query: "EDQM CEP certification database columns certificate holder substance status "Certification database""

Links: [{"title":"What is the CEP 2.0? - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/what-is-the-cep-2.0"},{"title":"User guide for Certification On-Line database - PA/PH/CEP ...","url":"https://www.edqm.eu/documents/52006/156629/User%20guide%20for%20Certification%20On-Line%20database%20(PA_PH_CEP%20(23)%2056,%20May%202024).pdf/26264db2-58b5-0cd4-7439-999bb86c4795?t=1718896649552"},{"title":"Deployment of a new EDQM CEP database feature: full download of CEP data - European Directorate for the Quality of Medicines & HealthCare","url":"https://www.edqm.eu/en/-/deployment-of-a-new-edqm-cep-database-feature-full-download-of-cep-data"},{"title":"CEP 2.0: Changes from September 2023 to information published in Certification Online and Knowledge databases - European Directorate for the Quality of Medicines & HealthCare","url":"https://www.edqm.eu/en/-/cep-2.0-changes-from-september-2023-to-information-published-in-certification-online-and-knowledge-databases"},{"title":"Notifications, Revisions, Renewals and Sister Files - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/notifications-revisions-renewals-and-sister-files"},{"title":"How do I know if I have the latest valid version of a CEP? - FAQs Home - FAQs","url":"https://faq.edqm.eu/pages/viewpage.action?pageId=1377010"},{"title":"Certification of Suitability (CEP) - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/certification"},{"title":"Certification Policy Documents & Guidelines - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/certification-policy-documents-guidelines"},{"title":"Databases - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/databases"},{"title":"KNOWLEDGE Database - European Directorate for the Quality of Medicines & HealthCare - EDQM","url":"https://www.edqm.eu/en/knowledge-database"}]

Based on the search results, here's information about the EDQM CEP certification database columns:

Main Database Columns

The download includes the main information associated with each CEP, such as the CEP number, holder and status, the European Pharmacopoeia monograph number and substance name.

Additional Columns

The tabulated data include additional columns showing SPOR ORG and LOC-ID information for the holder where this is available, as well as the renewal date for the CEP (where not yet renewed) and the closure date of the last procedure.

Searchable Criteria

Searches can be performed using various criteria, such as the substance name, the CEP number and holder name. Additionally, you can search for a list of granted CEPs, their type, the name of the substance, the full CEP number, the issue date and validity status, using the Certification Database (updated daily).

Procedure History

Users are also able to view and print a tabulated history of a selected CEP that provides information on the revision type, and on the outcome and closure date of completed procedures.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #25] xlsxwriter add_chart column chart categories values from worksheet data set_size insert_chart dashboard python example

Web search results for query: "xlsxwriter add_chart column chart categories values from worksheet data set_size insert_chart dashboard python example"

Links: [{"title":"Python and Excel: Writing Data Using XlsxWriter | by Charlie | Medium","url":"https://medium.com/@charliepython/python-and-excel-writing-data-using-xlsxwriter-78d602ca5048"},{"title":"Example: Column Chart — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_chart_column.html"},{"title":"XlsxWriter/examples/chart_column.py at master · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/blob/master/examples/chart_column.py"},{"title":"Example: Charts with Data Tables — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_chart_data_table.html"},{"title":"Python | Plotting column charts in excel sheet using XlsxWriter module - GeeksforGeeks","url":"https://www.geeksforgeeks.org/python/python-plotting-column-charts-in-excel-sheet-using-xlsxwriter-module/"},{"title":"Python XlsxWriter - Adding Charts","url":"https://www.tutorialspoint.com/python_xlsxwriter/python_xlsxwriter_adding_charts.htm"},{"title":"Python Language Tutorial => Create excel charts with xlsxwriter","url":"https://riptutorial.com/python/example/17392/create-excel-charts-with-xlsxwriter"}]

Based on the search results, here's what I found about XlsxWriter column charts with categories and values from worksheet data:

Basic Column Chart Setup

To plot a simple column chart on an Excel sheet, use the add_chart() method with type 'column' keyword argument of a workbook object.

Adding Chart Series with Categories and Values

The chart object is associated with data ranges in the worksheet using the add_series() method and then inserted in the worksheet using its insert_chart() method.

You can reference worksheet data in two ways:

1. String reference format: 'categories': '=Sheet1!$A$2:$A$7' and 'values': '=Sheet1!$B$2:$B$7'

2. Array reference format: 'categories': ['Sheet1', 1, 0, 6, 0] where the array contains [sheetname, first_row, first_col, last_row, last_col]

Example Workflow

Add worksheet data using write_row() and write_column(), then create a new column chart with add_chart({"type": "column"}) and configure series with add_series() specifying name, categories, and values.

Inserting the Chart

Insert the chart into the worksheet using worksheet.insert_chart("D2", chart1, {"x_offset": 25, "y_offset": 10}). You can also set chart size using chart.set_size({'x_scale': 2, 'y_scale': 2}).

For complete working examples, check the official XlsxWriter documentation at xlsxwriter.readthedocs.io or the GitHub repository examples.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #26] 제약사 RA 규제정보 일일 리포트 뉴스레터 DMF 원료 등록 경쟁사 모니터링 엑셀

Web search results for query: "제약사 RA 규제정보 일일 리포트 뉴스레터 DMF 원료 등록 경쟁사 모니터링 엑셀"

Links: [{"title":"[지침]원료의약품 등록(DMF) 처리 절차 < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=1&rowCnt=10&menuId=MENU01872&maxIndex=99999999999999&minIndex=99999999999999&schType=0&schText=&categoryId=&continent=&country=&upDown=0&boardStyle=&no1=0&linkId=26605812"},{"title":"등록대상 원료의약품(DMF) 등록 공고(7월 둘째주) < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=48&rowCnt=10&menuId=MENU01872&maxIndex=00487793189998&minIndex=00487441479998&schType=0&schText=&categoryId=&continent=&country=&upDown=0&boardStyle=&no1=912&linkId=26604564"},{"title":"원료의약품 등록제도(DMF), 궁금하면 클릭하세요! | 경제정책자료 | KDI 경제교육·정보센터","url":"https://eiec.kdi.re.kr/policy/materialView.do?num=196213&topic=L&pp=20"},{"title":"원료의약품 등록 제도(DMF) 해설서 제5개정판(민원인안내서)","url":"https://www.kpbma.or.kr/api/info/law/policy/download/211364"},{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"등록대상 원료의약품(DMF) 사전등록제 세부 운영방안 알림","url":"https://www.kpbma.or.kr/inform/notice/notice/select/244214"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 정보","url":"https://nedrug.mfds.go.kr/bbs/117"},{"title":"원료의약품등록에관한규정","url":"https://www.law.go.kr/%ED%96%89%EC%A0%95%EA%B7%9C%EC%B9%99/%EC%9B%90%EB%A3%8C%EC%9D%98%EC%95%BD%ED%92%88%EB%93%B1%EB%A1%9D%EC%97%90%EA%B4%80%ED%95%9C%EA%B7%9C%EC%A0%95"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"},{"title":"원료의약품 등록 제도(DMF)","url":"https://www.synex.co.kr/popup/pop_view.asp?bbs_code=2&bbs_idx=192"}]

검색 결과를 정리하면, 당신의 쿼리는 제약업계에서 사용되는 RA(Regulatory Affairs) 관련 규제정보를 찾는 것으로 보입니다. 다음과 같은 정보를 찾았습니다:

DMF(원료의약품 등록) 관련 정보

식품의약품안전평가원 바이오생약심사부가 수행하는 원료의약품 등록(DMF, Drug Master File) 처리 업무에 대하여 지침을 마련하여 업무의 정확성, 일관성 및 투명성을 확보하고 있습니다.

식품의약품안전처 「원료의약품등록(DMF)현황」 OpenAPI는 등록된 원료의약품(DMF)의 현황을 조회할 수 있는 공공데이터이며, 등록번호, 성분명, 업체명, 제조소명, 제조소 소재지, 제조국가명, 발급일자 등의 정보를 제공합니다.

제약사 및 연구자 등은 DMF 현황 파악으로 제품 개발 시 원료 사용 가능성 및 원료 제공처 파악 등에 활용할 수 있습니다.

규제정보 리소스

• 의약품안전나라(nedrug.mfds.go.kr): 원료의약품 등록(DMF) 정보 조회 가능
• 공공데이터포털(data.go.kr): DMF 현황 OpenAPI 제공

이러한 공식 자료들을 통해 일일 리포트나 경쟁사 모니터링을 위한 엑셀 데이터를 구성할 수 있을 것으로 보입니다.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #23] https://www.edqm.eu/en/-/deployment-of-a-new-edqm-cep-database-feature-full-download-of-cep-data

ASK: List exactly which columns are in the full CEP download (CEP number, holder, status, monograph number, substance, SPOR ORG/LOC-ID, renewal date, closure date...), the file format, and update frequency.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #24] https://clauswilke.com/dataviz/color-pitfalls.html

ASK: Summarize the key pitfalls: encoding too much info, non-monotonic scales, CVD-safe design, size of colored elements, recommended Okabe-Ito use, and any explicit rule of thumb (e.g. max 3-5 categorical colors).

Key Pitfalls of Color Use in Data Visualization

1. Encoding Too Much Information

Qualitative color scales work best with 3-5 categories maximum. Beyond 8-10 different colors, matching becomes burdensome for readers. The document advises: "Use direct labeling instead of colors when you need to distinguish between more than about eight categorical items."

2. Coloring Without Purpose

Applying colors merely for aesthetic effect without communicating data insights wastes visual real estate. The rainbow-colored bar chart example demonstrates how gratuitous color choices distract rather than clarify.

3. Non-Monotonic Color Scales

Rainbow scales are problematic because they're circular (similar colors at start/end) and non-uniform in lightness changes. Converting such scales to grayscale reveals their flaws, with some regions changing rapidly while others remain static.

4. Color-Vision Deficiency Considerations

• Sequential scales generally remain effective under CVD since they maintain dark-to-light gradients
• Diverging scales face challenges: red-green contrasts become indistinguishable for deutans/protans; blue-green for tritans
• Qualitative scales require careful selection; the Okabe-Ito palette provides eight CVD-safe colors

5. Size of Colored Elements

Colors distinguish better in large areas than thin lines or small points. This distinguishability gap widens under CVD simulation, making element size crucial for accessibility.

Recommendation

Test all figures through CVD simulators rather than relying solely on theoretically "safe" palettes.

[FETCH #25] https://openpyxl.readthedocs.io/en/stable/formatting.html

ASK: Extract verbatim code examples for FormulaRule, CellIsRule, IconSetRule, ColorScaleRule, DataBarRule, and any note on formula rules referencing other sheets or the string-based rules like 'containsText'.

Code Examples from openpyxl Documentation

FormulaRule

ws.conditional_formatting.add('E1:E10',
    FormulaRule(formula=['ISBLANK(E1)'], stopIfTrue=True, fill=redFill))

ws.conditional_formatting.add('E1:E10',
    FormulaRule(formula=['E1=0'], font=myFont, border=myBorder, fill=redFill))

CellIsRule

ws.conditional_formatting.add('C2:C10',
    CellIsRule(operator='lessThan', formula=['C$1'], stopIfTrue=True, fill=redFill))

ws.conditional_formatting.add('D2:D10',
    CellIsRule(operator='between', formula=['1','5'], stopIfTrue=True, fill=redFill))

ColorScaleRule

rule = ColorScaleRule(start_type='percentile', start_value=10, start_color='FFAA0000',
                      mid_type='percentile', mid_value=50, mid_color='FF0000AA',
                      end_type='percentile', end_value=90, end_color='FF00AA00')

IconSetRule

rule = IconSetRule('5Arrows', 'percent', [10, 20, 30, 40, 50], 
                   showValue=None, percent=None, reverse=None)

DataBarRule

rule = DataBarRule(start_type='percentile', start_value=10, 
                   end_type='percentile', end_value='90',
                   color="FF638EC6", showValue="None", minLength=None, maxLength=None)

String-Based Rules ('containsText')

rule = Rule(type="containsText", operator="containsText", text="highlight", dxf=dxf)
rule.formula = ['NOT(ISERROR(SEARCH("highlight",A1)))']

Note: The documentation includes a caution that "the formula uses an absolute reference to the column; but a relative row number" for proper evaluation across ranges.

[FETCH #26] https://www.pharmacompass.com/us-drug-master-files-dmfs

ASK: Describe the columns/filters shown for the US DMF database (DMF number, holder, subject/API, type, status, submit date, country), and any charts or summaries (by country, by year, top holders).

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #27] https://www.khidi.or.kr/board/view?pageNum=1&rowCnt=10&menuId=MENU01872&maxIndex=99999999999999&minIndex=99999999999999&schType=0&upDown=0&no1=0&linkId=26605812

ASK: 원료의약품 등록(DMF) 처리 절차 지침 요약: 신규등록, 변경등록(주요/경미), 연차보고, 취하/취소의 정의와 처리 단계, 공고 방식(주간), 등록번호 부여 방식.

Summary of DMF Registration Processing Guidelines

This document outlines procedures for Drug Master File (DMF) registration administered by the Biopharmaceutical Review Division of the Korea Medicines and Medical Devices Safety Evaluation and Research Institute.

Key Purpose

The guideline aims to "문서화함으로써 업무의 정확성, 일관성 및 투명성을 확보" (ensure accuracy, consistency, and transparency through documentation) of DMF registration operations.

Coverage Areas

The guideline addresses:

• Policy framework for DMF registration
• Roles and responsibilities of personnel involved
• Detailed processing procedures
• Handling of registration types: new applications, modifications (major/minor), annual reports, and withdrawals/cancellations
• Registration number assignment methods
• Publication schedules (weekly)

Source Information

Author: Administrator
Date: March 30, 2017
Organization: Korea Food and Drug Administration
Document Status: Revised to reflect the establishment of the Biopharmaceutical Review Coordination Division and procedural updates

The guideline is available as a downloadable HWP file (223.5 KB).

[FETCH #28] https://xlsxwriter.readthedocs.io/example_chart_column.html

ASK: Extract the full code sample verbatim including add_series with name/categories/values, set_title, set_x_axis, set_y_axis, set_style, insert_chart.

XlsxWriter Column Chart Code Sample

Here's the complete code demonstrating three column chart types:

import xlsxwriter

workbook = xlsxwriter.Workbook("chart_column.xlsx")
worksheet = workbook.add_worksheet()
bold = workbook.add_format({"bold": 1})

headings = ["Number", "Batch 1", "Batch 2"]
data = [
    [2, 3, 4, 5, 6, 7],
    [10, 40, 50, 20, 10, 50],
    [30, 60, 70, 50, 40, 30],
]

worksheet.write_row("A1", headings, bold)
worksheet.write_column("A2", data[0])
worksheet.write_column("B2", data[1])
worksheet.write_column("C2", data[2])

# Default column chart
chart1 = workbook.add_chart({"type": "column"})
chart1.add_series({
    "name": "=Sheet1!$B$1",
    "categories": "=Sheet1!$A$2:$A$7",
    "values": "=Sheet1!$B$2:$B$7",
})
chart1.add_series({
    "name": ["Sheet1", 0, 2],
    "categories": ["Sheet1", 1, 0, 6, 0],
    "values": ["Sheet1", 1, 2, 6, 2],
})
chart1.set_title({"name": "Results of sample analysis"})
chart1.set_x_axis({"name": "Test number"})
chart1.set_y_axis({"name": "Sample length (mm)"})
chart1.set_style(11)
worksheet.insert_chart("D2", chart1, {"x_offset": 25, "y_offset": 10})

# Stacked column chart
chart2 = workbook.add_chart({"type": "column", "subtype": "stacked"})
chart2.add_series({
    "name": "=Sheet1!$B$1",
    "categories": "=Sheet1!$A$2:$A$7",
    "values": "=Sheet1!$B$2:$B$7",
})
chart2.add_series({
    "name": "=Sheet1!$C$1",
    "categories": "=Sheet1!$A$2:$A$7",
    "values": "=Sheet1!$C$2:$C$7",
})
chart2.set_title({"name": "Stacked Chart"})
chart2.set_x_axis({"name": "Test number"})
chart2.set_y_axis({"name": "Sample length (mm)"})
chart2.set_style(12)
worksheet.insert_chart("D18", chart2, {"x_offset": 25, "y_offset": 10})

# Percentage stacked column chart
chart3 = workbook.add_chart({"type": "column", "subtype": "percent_stacked"})
chart3.add_series({
    "name": "=Sheet1!$B$1",
    "categories": "=Sheet1!$A$2:$A$7",
    "values": "=Sheet1!$B$2:$B$7",
})
chart3.add_series({
    "name": "=Sheet1!$C$1",
    "categories": "=Sheet1!$A$2:$A$7",
    "values": "=Sheet1!$C$2:$C$7",
})
chart3.set_title({"name": "Percent Stacked Chart"})
chart3.set_x_axis({"name": "Test number"})
chart3.set_y_axis({"name": "Sample length (mm)"})
chart3.set_style(13)
worksheet.insert_chart("D34", chart3, {"x_offset": 25, "y_offset": 10})

workbook.close()

The sample demonstrates configuring series data with names, categories, and values; adding titles and axis labels; applying styling; and positioning charts within worksheets.

[FETCH #29] https://manuelxduval.github.io/paracelsus/

ASK: List the Orange Book files and their columns (products.txt, patent.txt, exclusivity.txt), the delimiter, and how the tool parses them.

FDA Orange Book Files Overview

Based on the provided content, here's what's documented about the Orange Book data structure:

Files Included

The archive contains three data files: products.txt, patent.txt, and exclusivity.txt

Products.txt Columns

As of March 2019, the products.txt table contained 36,771 entries with these attributes:

• Ingredient
• DF;Route
• Trade_Name
• Applicant
• Strength
• Appl_Type
• Appl_No
• Product_No
• TE_Code
• Approval_Date
• RLD
• RS
• Type
• Applicant_Full_Name

Delimiter and Parsing

The content does not specify the delimiter used (e.g., tab-separated, comma-separated) or provide details on how the parsing tool handles the patent.txt and exclusivity.txt files.

The only parsing detail mentioned is that Appl_Type contains "two mutually exclusive values: 'A' or 'N'" where N represents New Drug Applications and A refers to generic drugs (ANDA).

For complete technical implementation details, the page directs readers to the FDA's official documentation at fda.gov/drugs/informationondrugs/ucm129689.htm#descriptions.

[FETCH #30] https://open.fda.gov/data/downloads/

ASK: Describe the Drugs@FDA download and related drug datasets listed, their format (JSON/zip), and update frequency; note any mention of applications/products/submissions fields.

Drugs@FDA and Related Drug Datasets

Based on the provided content, I can confirm that "Human Drugs@FDA" is listed as an available download endpoint under the "Human Drug" category. However, the webpage excerpt does not include specific details about:

• The format of the Drugs@FDA download (JSON, ZIP, or other formats)
• Update frequency for datasets
• Specific fields related to applications, products, or submissions
• Technical specifications or data structure

The page appears to be a directory or index listing various FDA datasets across multiple categories (Animal and Veterinary, Cosmetics, Food, Human Drug, Medical Device, Tobacco, Transparency, Research, and Other), but the actual dataset descriptions and formatting information are not included in the provided excerpt.

To obtain comprehensive information about Drugs@FDA's format, update schedule, and available fields, you would need to access the full dataset documentation or the actual download page linked from this index.

[SEARCH #27] FDA "dmflist" xlsx download drug master files list file fda.gov/media

Web search results for query: "FDA "dmflist" xlsx download drug master files list file fda.gov/media"

Links: [{"title":"FDA Drug Master Files Directory - John Snow Labs","url":"https://www.johnsnowlabs.com/marketplace/fda-drug-master-files-directory/"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"},{"title":"Drug Master Files (DMFs) | FDA","url":"https://www.fda.gov/drugs/forms-submission-requirements/drug-master-files-dmfs"},{"title":"US Drug Master Files (DMF) Database | PharmaCompass.com","url":"https://www.pharmacompass.com/us-drug-master-files-dmfs"},{"title":"Drug Master Files Guidance for Industry DRAFT GUIDANCE","url":"https://www.fda.gov/media/131861/download"},{"title":"Types of Drug Master Files (DMFs) | FDA","url":"https://www.fda.gov/drugs/drug-master-files-dmfs/types-drug-master-files-dmfs"},{"title":"Excipient DMF List - pharma excipients","url":"https://www.pharmaexcipients.com/excipient-sources/excipient-dmf-list/"},{"title":"Drug Master File - US DMF FDA Guidance and Submission","url":"https://fdapals.com/services/dmf-fda-guidance/"},{"title":"FDA’s Drug Master Files","url":"https://mclibrary.duke.edu/about/blog/2014-12-04/fda-drug-master-files"}]

Based on the search results, I found information about FDA Drug Master Files:

Drug master files (DMFs) are submissions to FDA used to provide confidential, detailed information about facilities, processes, or articles used in the manufacturing, processing, packaging, and storing of human drug products.

Regarding the downloadable list format you're searching for: DMF files are available for download in Excel format. Updated quarterly, the FDA's Drug Master Files (DMFs) contain information about manufacturing, processing, packaging, and storage of human drugs.

A list of Drug Master Files (DMFs) received by the FDA and other resources are provided on the official FDA website at https://www.fda.gov/drugs/forms-submission-requirements/drug-master-files-dmfs. While the search results indicate that an Excel download is available, the specific URL for the "dmflist" xlsx file on fda.gov/media was not returned in these results. You may want to visit the FDA DMF page directly or contact the FDA to locate the specific file download link you're looking for.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #31] https://www.law.go.kr/행정규칙/원료의약품등록에관한규정

ASK: 조문 요약: 등록대상, 신규등록 신청, 변경등록(제출자료 및 종류), 연차보고, 등록 취하/취소, 공고(등록사항 공고의 항목과 방법), 등록번호.

원료의약품등록에관한규정 개요

이 규정은 의약품 원료 등록의 핵심 절차를 다룹니다.

주요 내용:

• 등록 대상 및 신규 신청 요건
• 변경 시 제출 자료와 절차
• 정기 보고 의무사항
• 등록 철회 및 취소 조건
• 공개 공고 항목 및 방법
• 등록번호 발급 체계

규정은 원료의약품의 등록부터 유지관리까지 전 과정의 행정 절차를 규정하는 것으로 보입니다.

[SEARCH #28] storytelling with data blog dashboard design tips

Web search results for query: "storytelling with data blog dashboard design tips"

Links: [{"title":"from dashboard to story","url":"https://www.storytellingwithdata.com/blog/from-dashboard-to-story"},{"title":"storytelling with data (SWD) examples & makeovers","url":"https://www.storytellingwithdata.com/makeovers"},{"title":"storytelling with data podcast - improve your data visualization and presentation skills — storytelling with data","url":"https://www.storytellingwithdata.com/podcast/archive"},{"title":"storytelling with data","url":"https://www.storytellingwithdata.com/"},{"title":"Ep 1 | the art of feedback","url":"https://www.storytellingwithdata.com/podcast/feedback"},{"title":"storytelling with data","url":"https://community.storytellingwithdata.com/challenges/aug-2021-dashboard-stories/are-we-undercharging-for-data-visualization-work"}]

I found several relevant results from the Storytelling with Data blog and resources. Here are the key dashboard design tips:

Dashboard Design Tips from Storytelling with Data

Layout and Navigation: Leverage white space, alignment, and grid layouts to make the view easier to read and navigate at all levels of exploration.

Chart Selection: Select the most appropriate chart type for the data being depicted to enable quick discovery. Additionally, using familiar data visualizations helps audiences more quickly decipher, understand, and act upon the data.

Understanding Your Audience: When creating a monitoring report capable of exploratory analysis, one should be thoughtful of the audience, and the insights they need to glean from the data.

Dashboards vs. Storytelling: It's important to note that dashboards are optimized for the exploration of data, not the communication of specific insights. To drive meaningful change, it is usually more effective to craft a separate presentation specific to the story we want to tell.

The Storytelling with Data site also offers additional resources including books, podcasts, and makeover examples to help improve your data visualization and dashboard design skills.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #29] chandoo.org dashboard design principles layout color "dashboard" tips

Web search results for query: "chandoo.org dashboard design principles layout color "dashboard" tips"

Links: [{"title":"Dashboard Design Concepts | Chandoo.org Excel Forums - Become Awesome in Excel","url":"https://chandoo.org/forum/threads/dashboard-design-concepts.19536/"},{"title":"Learn how to create these 11 amazing dashboards » Chandoo.org - Learn Excel, Power BI & Charting Online","url":"https://chandoo.org/wp/2014/02/14/dashboard-training-course/"},{"title":"Dashboard Ideas | Chandoo.org Excel Forums - Become Awesome in Excel","url":"https://chandoo.org/forum/threads/dashboard-ideas.21929/"},{"title":"Excel Dashboards - Templates, Tutorials, Downloads and Examples","url":"https://chandoo.org/wp/excel-dashboards/"},{"title":"18 Tips to Make you an Excel Formatting Pro » Chandoo.org","url":"http://chandoo.org/wp/2011/12/05/excel-formatting-tips/"},{"title":"What is the best Excel Background Design that WOWed you...? | Chandoo.org Excel Forums - Become Awesome in Excel","url":"https://chandoo.org/forum/threads/what-is-the-best-excel-background-design-that-wowed-you.29586/"},{"title":"How to create a fully interactive Project Dashboard with Excel - Tutorial + FREE Download","url":"https://chandoo.org/wp/interactive-project-dashboard-with-excel/"},{"title":"How to design the dashboard | Chandoo.org Excel Forums - Become Awesome in Excel","url":"https://chandoo.org/forum/threads/how-to-design-the-dashboard.12296/"},{"title":"Download today - Introducing Excel Dashboard Templates from Chandoo.org » Chandoo.org - Learn Excel, Power BI & Charting Online","url":"https://chandoo.org/wp/introducing-excel-dashboard-templates/"},{"title":"How to highlight overdue items, coming up and completed in Excel? » Conditional Formatting » Chandoo.org","url":"https://chandoo.org/wp/highlight-due-dates-excel/"}]

I've completed the web search for dashboard design principles, layout, and color tips from Chandoo.org. Here's what I found:

Key Dashboard Design Principles from Chandoo.org:

Color Design: The best colour for the background is white, and it is the colour schemes used for the charts, slicers and other individual elements which really differentiate between a great design and a bad design. Additionally, it's important to avoid dark colours, and go in for the lighter shades.

Layout & Planning: It is a good idea to decide the color scheme and visual design of your dashboard before you get too far. You should mock up simple dashboards with charts & tables but no interactivity or numbers, even hand drawn layouts, and settle on a page/display size early in the process as changing later can sometimes be difficult.

Design Skills: The Chandoo.org courses cover layout techniques, mixing different formats, dynamic charts, and using color & contrast.

Practical Tips: Consistency is an important aspect of formatting, and by using cell styles, you can ensure that all similar information in your workbook is formatted in the same way.

The Chandoo.org website provides extensive resources on creating professional Excel dashboards with emphasis on practical, data-focused design principles.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #30] xlsxwriter write_url internal link "internal:" sheet hyperlink navigation between worksheets

Web search results for query: "xlsxwriter write_url internal link "internal:" sheet hyperlink navigation between worksheets"

Links: [{"title":"Issue with write_url when internally referencing a sheet (with spaces) in the same book · Issue #609 · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/issues/609"},{"title":"write_url produces broken hyperlink · Issue #350 · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/issues/350"},{"title":"Example: Adding hyperlinks — XlsxWriter","url":"https://xlsxwriter.readthedocs.io/example_hyperlink.html"},{"title":"libxlsxwriter: hyperlinks.c","url":"https://libxlsxwriter.github.io/hyperlinks_8c-example.html"},{"title":"Issue with hyperlinking for cells containing multiple URLs · Issue #511 · jmcnamara/XlsxWriter","url":"https://github.com/jmcnamara/XlsxWriter/issues/511"},{"title":"Example: Adding hyperlinks — xlsxwriter.lua Documentation","url":"https://xlsxwriterlua.readthedocs.io/example_hyperlink.html"},{"title":"Python XlsxWriter - Hyperlinks","url":"https://www.tutorialspoint.com/python_xlsxwriter/python_xlsxwriter_hyperlinks.htm"},{"title":"pypi.org","url":"https://pypi.org/project/XlsxWriter/0.5.8"}]

Based on the search results, here's what I found about using write_url with internal links and hyperlink navigation between worksheets in XlsxWriter:

Basic Internal Link Syntax

Internal links to other worksheets in the same workbook are created by prefixing with "internal:" the local URIs. The basic syntax is 'internal:Sheet2!A1' to link to a specific cell in another sheet.

Example Usage

Here's an example of creating an internal hyperlink with custom display text and tooltip:

worksheet.write_url('A1', 'internal:Sheet2!A1', string="Link to sheet2", tip="Click here")

Handling Sheet Names with Spaces

When worksheet names contain spaces, you need to use single quotes around the sheet name. For example: "internal:'Summary Figure 1'!A1"

Key Parameters

The string parameter provides alternative display text for the link, and the tip parameter adds a tooltip that appears when hovering over the hyperlink.

These internal links enable easy navigation between different worksheets within the same Excel workbook.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #31] openpyxl Table TableStyleInfo freeze_panes auto_filter example showRowStripes

Web search results for query: "openpyxl Table TableStyleInfo freeze_panes auto_filter example showRowStripes"

Links: [{"title":"openpyxl.worksheet.table module — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.table.html"},{"title":"openpyxl.worksheet.table module — openpyxl 2.4.9 documentation","url":"https://ssopenpyxl.readthedocs.io/en/2.5.2/openpyxl.worksheet.table.html"},{"title":"Worksheet Tables — openpyxl 3.1.4 documentation","url":"https://openpyxl.readthedocs.io/en/3.1/worksheet_tables.html"},{"title":"Worksheet Tables — openpyxl 2.4.11 documentation","url":"https://openpyxl.readthedocs.io/en/2.4/worksheet_tables.html"},{"title":"Worksheet Tables — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/worksheet_tables.html"},{"title":"Chapter 13 – Working with Excel Spreadsheets","url":"https://automatetheboringstuff.com/2e/chapter13/"},{"title":"Using filters and sorts — openpyxl 3.1.3 documentation","url":"https://openpyxl.readthedocs.io/en/stable/filters.html"},{"title":"github.com","url":"https://github.com/pandas-dev/pandas/pull/62994.diff"}]

Based on the search results, I found comprehensive information about openpyxl's Table and TableStyleInfo features:

Summary of Results

By default tables are created with a header from the first row and filters for all the columns and table headers and column headings must always contain strings.

TableStyleInfo

Styles are managed using the TableStyleInfo object. This allows you to stripe rows or columns and apply the different colour schemes.

Example Usage

Here's an example of creating a table with TableStyleInfo: style = TableStyleInfo(name="TableStyleMedium9", showFirstColumn=False, showLastColumn=False, showRowStripes=True, showColumnStripes=True)

freeze_panes

You can freeze panes by setting the freeze_panes attribute, such as sheet.freeze_panes = 'A2' to freeze the rows above A2, so row 1 will always be viewable.

Auto Filter

It's possible to filter single range of values in a worksheet by adding an autofilter. If you need to filter multiple ranges, you can use tables and apply a separate filter for each table.

The search results show the showRowStripes parameter you mentioned is indeed part of TableStyleInfo, as shown in the example code that sets it to True for striped row styling.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #32] 원료의약품 등록 공고 신규등록 변경등록 취하 첨부파일 엑셀 hwp 등록번호 성분명 신청인 제조원 nedrug 게시판

Web search results for query: "원료의약품 등록 공고 신규등록 변경등록 취하 첨부파일 엑셀 hwp 등록번호 성분명 신청인 제조원 nedrug 게시판"

Links: [{"title":"원료의약품(등록신청, 등록사항 변경등록신청) | 민원안내 및 신청 | 정부24","url":"https://www.gov.kr/mw/AA020InfoCappView.do?HighCtgCD=A09006&CappBizCD=14700000458&tp_seq="},{"title":"https://nedrug.mfds.go.kr/search?keyword=%BF%D5%C5...","url":"https://nedrug.mfds.go.kr/search?keyword=%EF%BF%BD%EF%BF%BD%C5%B8%C2%A5,com+%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%D1%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C4%AB%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C6%AE+2025%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%BC+%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C7%BF%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%B5+%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C4%AB%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C6%AE+%EF%BF%BD%EF%BF%BD%F3%B3%B2%B5%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%EF%BF%BD%C3%B5"},{"title":"원료의약품 등록 및 변경등록 업무","url":"https://www.mfds.go.kr/brd/m_1059/down.do?brd_id=data0010&seq=15144&data_tp=A&file_seq=2"},{"title":"원료의약품등록에관한규정","url":"https://www.law.go.kr/%ED%96%89%EC%A0%95%EA%B7%9C%EC%B9%99/%EC%9B%90%EB%A3%8C%EC%9D%98%EC%95%BD%ED%92%88%EB%93%B1%EB%A1%9D%EC%97%90%EA%B4%80%ED%95%9C%EA%B7%9C%EC%A0%95"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://www.law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000150569"},{"title":"행정규칙 > 원료의약품 등록에 관한 규정 | 국가법령정보센터","url":"https://law.go.kr/LSW/admRulLsInfoP.do?admRulSeq=2100000252602"},{"title":"의약품안전나라 > 고시/공고/알림 > 의약품허가·승인 > 변경명령","url":"https://nedrug.mfds.go.kr/CCBAR01F012/getList/getItem?infoNo=20230089&infoClassCode=3"},{"title":"의약품안전나라 > 의약품등 검색 - 식품의약품안전처","url":"https://nedrug.mfds.go.kr/searchDrug"},{"title":"의약품안전나라 > 고시/공고/알림 > 의약품허가·승인 > (구)변경지시","url":"https://nedrug.mfds.go.kr/pbp/CCBAQ03/getItem?totalPages=1257&limit=10&page=2&bbsYn=Y&orderNo=&bbscttNo=4652"},{"title":"의약품안전나라 > 고시/공고/알림 > 의약품허가·승인 > 품목허가현황","url":"https://nedrug.mfds.go.kr/pbp/CCBAE01"}]

Based on the web search results, here's what I found regarding your query about raw pharmaceutical ingredient (원료의약품) registration notices and postings:

According to the Korea Ministry of Food and Drug Safety, raw pharmaceutical ingredient (DMF) registration applications are reviewed and announced in accordance with regulations, with the registration details provided in attachments.

Weekly raw pharmaceutical ingredient registration status (new registration, change registration, annual reports) is posted on the Ministry's homepage at the e-Citizen Petition window (http://ezdrug.mfds.go.kr > Data Room > Pharmaceuticals, etc.).

The search results indicate that the Nedrug database includes information about pharmaceutical products, manufacturing companies, and raw pharmaceutical ingredient registration (DMF) information, which can be accessed through the official Nedrug portal (nedrug.mfds.go.kr) where you can find registration numbers, ingredient names, applicants, manufacturers, and related documents in Excel or HWP formats.

For detailed registration information including the specific attachments and file formats you mentioned, you may want to directly access the Nedrug portal or the Ministry's official e-Citizen petition service.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #33] Excel KPI card tile design large number delta arrow vs yesterday cell formatting dashboard tutorial

Web search results for query: "Excel KPI card tile design large number delta arrow vs yesterday cell formatting dashboard tutorial"

Links: [{"title":"Create Amazing Key Performance Indicator Data Cards In Excel | How To Excel","url":"https://www.howtoexcel.org/kpi-data-cards/"},{"title":"Creating a Big Numbers KPI Dashboard in Tableau | Senturus","url":"https://senturus.com/blog/creating-a-big-numbers-kpi-dashboard-in-tableau/"},{"title":"How To Build Dynamic KPI Dashboards in Excel: Tutorial and Templates","url":"https://www.venasolutions.com/blog/build-kpi-dashboard-excel"},{"title":"Excel KPI Card Design: Build Clean Metric Cards","url":"https://bigexcelenergy.com/excel-kpi-card-design/"},{"title":"Excel Dashboard Templates: Free Downloads + How to Build One (2026)","url":"https://www.datahubpro.co.uk/tutorials/excel-dashboard-templates"},{"title":"Card Visualization: The Tile Visualization or Large Number Tiles","url":"https://dashboardbuilder.net/card-visualization"},{"title":"Flooring Installation KPI Scorecard in Excel - PK: An Excel Expert","url":"https://www.pk-anexcelexpert.com/flooring-installation-kpi-scorecard-in-excel/"}]

I found several relevant resources on Excel KPI card tile design. Here are the key results:

Excel KPI Card Design Resources

Best Practice Resources:

1. Big Excel Energy - A KPI card is a single tile that shows one metric as a large value, a small caption label, and a small colored delta against a target or prior period. Their guide emphasizes design hierarchy and provides specific font sizing recommendations, with the metric itself at 28–44 pt, bold, in your heading font as the single largest thing on the card.

2. How To Excel - Provides specific formatting techniques, including adding ▲ 0.0 %;▼ -0.0 % into the custom number format field to display an up arrow for positive numbers and a down arrow for negative numbers.

3. Vena Solutions - Offers practical steps: Create a tile by selecting Insert → Shape, with rectangles being a common choice.

4. DataHub Pro - Recommends that the change should be formatted as a percentage and colored green for up, red for down, and a KPI card with a trend arrow and "+12% vs last month" tells a richer story than a bare number.

5. PK: An Excel Expert - Shows a complete example with ten cards laid out five across, each showing the KPI name, the traffic light, the value in large type, the target value, the absolute change, the percentage change with a colored arrow, and a twelve-month sparkline.

These resources provide comprehensive tutorials on cell formatting, shape insertion, custom number formatting with arrows, and dashboard design best practices.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #34] regulatory intelligence daily digest newsletter format what to include pharma regulatory affairs monitoring template

Web search results for query: "regulatory intelligence daily digest newsletter format what to include pharma regulatory affairs monitoring template"

Links: [{"title":"A Comprehensive Review of Regulatory Intelligence: Exploring Tools and Program Maturities | PDA","url":"https://www.pda.org/pda-letter-portal/home/full-article/a-comprehensive-review-of-regulatory-intelligence-exploring-tools-and-program-maturities"},{"title":"Cortellis Regulatory Intelligence AI-Powered Software","url":"https://clarivate.com/life-sciences-healthcare/research-development/regulatory-compliance-intelligence/regulatory-intelligence-solutions/"},{"title":"Global Regulatory Intelligence monthly newsletter","url":"https://www.iconplc.com/insights/regulatory-intelligence/regulatory-intelligence-newsletter"},{"title":"Your New Regulatory Intelligence Experts | AgencyIQ by POLITICO","url":"https://www.agencyiq.com/"},{"title":"Regulatory Intelligence 101: A Beginner’s Guide for the Pharmaceutical Industry | Sep 01, 2025","url":"https://ioni.ai/post/regulatory-intelligence-101-a-beginners-guide-for-the-pharmaceutical-industry"},{"title":"Pharma and Biotech Regulatory Intelligence & Guidance Monitoring- DDi","url":"https://www.ddismart.com/pharma-biotech-regulatory-intel/"},{"title":"Regulatory Intelligence and Updates – Pharma Regulatory","url":"https://www.pharmaregulatory.in/regulatory-intelligence-and-updates/"},{"title":"Harnessing Regulatory Intelligence and Updates in Pharma Strategy – PharmaRegulatory.in – India’s Regulatory Knowledge Hub","url":"https://www.pharmaregulatory.in/harnessing-regulatory-intelligence-and-updates-in-pharma-strategy"}]

Based on the web search results, here's what pharmaceutical regulatory professionals should include in a regulatory intelligence daily digest newsletter:

Key Content Areas to Include

Updates should cover FDA clarifications on dataset expectations, labeling updates, marketing authorization applications, post-approval submissions, and scientific guidance on quality, non-clinical, efficacy and safety.

Newsletter Distribution and Format

Expert-curated newsletters should provide a daily synthesis of complex policy—helping you understand what's changing, why it matters, and what comes next.

Alerts can be manually vetted by regulatory analysts based on industry and functional area, with customizable frequency for receiving updates, and can be grouped together and converted into a newsletter to share with other stakeholders.

Monitoring Capabilities

Regulatory professionals can subscribe to regulatory agency subscription newsletters via email and monitor for changes by reviewing these emails. Additionally, Really Simple Syndication (RSS) feeds can be utilized—which are web feeds that allow users and applications to access updates to websites in a standardized, computer-readable format, typically via email interface.

Documentation and Tracking

All tracked updates and associated actions should be archived in a regulatory intelligence repository or tracker, with targeted dissemination to stakeholders via dashboards, newsletters, or alerts.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #35] Excel table sort by status priority custom sort order helper column conditional formatting entire row formula $A2="New"

Web search results for query: "Excel table sort by status priority custom sort order helper column conditional formatting entire row formula $A2="New""

Links: [{"title":"Custom Sort | MrExcel Message Board","url":"https://www.mrexcel.com/board/threads/custom-sort.471612/"},{"title":"Excel SORTBY function - custom sort with formula","url":"https://www.ablebits.com/office-addins-blog/excel-sortby-function-custom-sort-formula/"},{"title":"Sort data using a custom list | Microsoft Support","url":"https://support.microsoft.com/en-us/office/sort-data-using-a-custom-list-cba3d67a-c5cb-406f-9b14-a02205834d72"},{"title":"Custom Sort Order in Excel - Made Simple","url":"https://www.excel-easy.com/examples/custom-sort-order.html"},{"title":"How to How to Create Custom Sort Order in Excel in Excel - Practical Guide | ElyxAI","url":"https://getelyxai.com/en/how-to/create-custom-sort-order"},{"title":"How to Sort Data in Excel – Custom Order, Filters & Pro Tips","url":"https://www.mygreatlearning.com/blog/sort-data-in-excel/"},{"title":"Custom Sorting with SORT & MATCH: Your Perfect Order Recipe - Excel Cookbook","url":"https://www.excel-cookbook.com/recipes/sort-by-custom-order-match"},{"title":"Organise Your Data Like a Pro: How to Create a Custom Sort Order in Excel","url":"https://techmemore.substack.com/p/organise-your-data-like-a-pro-how"},{"title":"Excel custom sorting using Office scripts","url":"https://learn.microsoft.com/en-us/answers/questions/1527424/excel-custom-sorting-using-office-scripts"},{"title":"OfficeTalk: Bringing Improvements to Tables in Excel 2007 (Part 5 of 6)","url":"https://learn.microsoft.com/en-us/previous-versions/office/developer/officetalk2007/bb963879(v=office.11)"}]

Based on the search results, here's information on Excel custom sorting with helper columns and related techniques:

Custom Sort Order with Helper Columns

A helper column can be established for custom sorting purposes. A numeric helper column approach (1, 2, 3) can match your desired sort order, and this approach offers portability across files.

Modern Formula Approach

For newer Excel versions, you can combine SORT with MATCH and HSTACK to create a temporary helper column within your formula that will assign a numerical rank based on your desired custom order, which SORT can then use. To sort data in a custom order, you can build a SORTBY MATCH formula like: SORTBY(array, MATCH(range_to_sort, custom_list, 0)).

Built-in Custom Lists

You can type values to sort by in a column and arrange them in the order you want to define the sort order—from top to bottom. In the Sort dialog box, select the column you want to apply the custom sort order to, and in the Order drop-down menu, select Custom List to open the Custom Lists dialog box.

The search results address custom sorting methods but don't specifically cover conditional formatting for entire rows with the exact formula syntax you mentioned. If you need more specific information about conditional formatting with that particular formula structure, please let me know!

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #36] DMF 등록 원료의약품 제조국 중국 인도 비중 성분별 등록 상위 통계 기사 2025

Web search results for query: "DMF 등록 원료의약품 제조국 중국 인도 비중 성분별 등록 상위 통계 기사 2025"

Links: [{"title":"[데일리팜] 인도·중국산 등록비중 70% 돌파...외면받는 국산 원료약","url":"http://m.dailypharm.com/newsView.html?ID=307819"},{"title":"[지침]원료의약품 등록(DMF) 처리 절차 < 법령 및 고시>의약품 인허가정보>제약글로벌정보센터-제약산업정보포털","url":"https://www.khidi.or.kr/board/view?pageNum=1&rowCnt=10&menuId=MENU01872&maxIndex=99999999999999&minIndex=99999999999999&schType=0&upDown=0&no1=0&linkId=26605812"},{"title":"식품의약품안전처_원료의약품등록(DMF)현황 | 공공데이터포털","url":"https://www.data.go.kr/data/15057075/openapi.do"},{"title":"의약품안전나라 > 의약품등 정보 > 의약품 및 화장품 품목정보 > 원료의약품등록(DMF) 정보","url":"https://nedrug.mfds.go.kr/bbs/117"},{"title":"원료의약품 등록제도(DMF), 궁금하면 클릭하세요! | 경제정책자료 | KDI 경제교육·정보센터","url":"https://eiec.kdi.re.kr/policy/materialView.do?num=196213&topic=L&pp=20"},{"title":"원료의약품 등록제도(DMF), 궁금하면 클릭하세요!","url":"https://www.mfds.go.kr/brd/m_99/down.do?brd_id=ntc0021&seq=43886&data_tp=A&file_seq=2"},{"title":"원료등록(DMF) 기간 대폭 단축!","url":"https://www.mfds.go.kr/brd/m_99/down.do?brd_id=ntc0021&seq=48245&data_tp=A&file_seq=2"},{"title":"Drug Master File","url":"https://en.wikipedia.org/wiki/Drug_Master_File"},{"title":"원료의약품등록에관한규정","url":"https://www.law.go.kr/%ED%96%89%EC%A0%95%EA%B7%9C%EC%B9%99/%EC%9B%90%EB%A3%8C%EC%9D%98%EC%95%BD%ED%92%88%EB%93%B1%EB%A1%9D%EC%97%90%EA%B4%80%ED%95%9C%EA%B7%9C%EC%A0%95"},{"title":"식품의약품안전처>정책정보>의료제품 수출지원 정보>의약품>국가별 규제정보 | 식품의약품안전처","url":"https://www.mfds.go.kr/brd/m_617/view.do?seq=40464&srchFr=&srchTo=&srchWord=&srchTp=&itm_seq_1=0&itm_seq_2=0&multi_itm_seq=0&company_cd=&company_nm=&page=1"}]

검색 결과를 정리하면 다음과 같습니다:

DMF 등록 원료의약품 제조국별 통계 (2024년 기준)

지난해 전체 DMF 249건 중 233건이 해외업체 등록 건이었는데, 이 가운데 인도가 120건으로 가장 많았고, 중국이 60건, 이탈리아 10건, 일본 6건 등의 순이었습니다.

중국·인도산 비중

인도·중국산의 비중은 갈수록 증가해 지난해엔 처음으로 70%를 넘어섰습니다.

국산 원료의약품 비중

지난해엔 전체 249건 중 16건으로, 6.4%에 그치는 것으로 나타났으며, 원료의약품 등록제도가 본격 시행된 2005년 이후 가장 낮습니다. 제약바이오 기업들이 사용을 등록한 원료의약품에서 국내산이 차지하는 비중이 지난해 처음으로 10% 미만으로 감소했으며, 원료의약품 등록제도가 본격 시행된 2005년 이후로 국내산 DMF 비중이 10% 미만으로 내려간 것은 지난해가 처음입니다.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #37] Excel dashboard sparkline "win/loss" "column" daily counts last 30 days KPI examples data-ink Few Information Dashboard Design

Web search results for query: "Excel dashboard sparkline "win/loss" "column" daily counts last 30 days KPI examples data-ink Few Information Dashboard Design"

Links: [{"title":"Excel Sparklines - A Complete Guide with Examples","url":"https://trumpexcel.com/sparklines/"},{"title":"Spark Line Chart: What It Is and When to Use It","url":"https://www.domo.com/learn/charts/sparkline-chart"},{"title":"Win/Loss Sparklines | MyExcelOnline","url":"https://www.myexcelonline.com/blog/winloss-sparklines-in-excel/"},{"title":"How to How to Create Sparkline Dashboard in Excel in Excel - Practical Guide | ElyxAI","url":"https://getelyxai.com/en/how-to/create-sparkline-dashboard"},{"title":"Column Sparkline - Excel Glossary | ElyxAI","url":"https://getelyxai.com/en/excel-glossary/column-sparkline"},{"title":"Win/Loss Sparkline - Excel Glossary | ElyxAI","url":"https://getelyxai.com/en/excel-glossary/win-loss-sparkline"},{"title":"Create Win-Loss Sparklines In Excel - Visualizing Success and Failure","url":"https://www.simplesheets.co/blog/complete-guide-for-create-win-loss-sparklines-in-excel"},{"title":"Mastering Sparklines in Excel: Win-Loss Sparklines (Part II)","url":"https://vishalcpaprep.com/blogs/news/mastering-sparklines-in-excel-win-loss-sparklines-part-ii"},{"title":"Win/Loss Sparkline for Streaks - Microsoft Excel In-Person Training Classes by Excel Experts","url":"https://dfwexcel.com/excel-formulas/win-loss-sparkline/"}]

Based on the web search results, here's comprehensive information about Excel dashboard sparklines with win/loss and column visualizations for KPI tracking:

Win/Loss Sparklines Overview

A Win-loss sparkline is just like a column sparkline, but it doesn't show the magnitude of the value. It is better used in situations where the outcome is binary, such as Yes/No, True/False, Head/Tail, 1/-1, etc.

Use Cases for Daily KPI Tracking

BI analysts like sparklines for KPI tables, and non-technical stakeholders (think sales reps, store managers, and customer success managers) tend to trust them quickly. A win/loss sparkline ignores magnitude and shows only direction: a block up for every positive value, down for every negative, ideal for win streaks, daily up/down, or over/under target.

Column vs. Win/Loss Sparklines

Column sparklines make individual period values more visible: monthly revenue, marketing leads, sales pipeline created, call volume—each bar's height carries meaning. In contrast, Win/Loss Sparklines specifically represent binary outcomes (win/loss, pass/fail), while Column Sparklines show actual value magnitudes—choose Win/Loss for categorical outcomes and Column Sparklines when magnitude differences matter.

Dashboard Best Practices

For KPI dashboards tracking the last 30 days: Avoid overwhelming sparklines with 100+ data points; 12-24 values per sparkline is optimal for clarity. Create a summary table with campaign names and row-by-row column sparklines showing daily click-through rates over a month, enabling managers to spot peak performance days and underperforming periods instantly without scrolling through detailed data.

Arrange sparklines alongside KPI labels and summary metrics using merged cells and borders.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #32] http://m.dailypharm.com/newsView.html?ID=307819

ASK: 기사 요약: 연도별 DMF 건수, 제조국별(인도/중국/이탈리아/일본/국산) 건수와 비중, 기사가 사용한 집계 축(제조국, 업체, 성분), 표나 그래프 항목, 언급된 업체명.

Key Data from Article Summary

Annual DMF Registration Trends

The article presents a concerning decline in domestic pharmaceutical raw material registrations:

• 2023 domestic share: 6.4% (16 of 249 registrations) — "the lowest since the Drug Master File system began in earnest in 2005"
• India + China combined: 72.3% (180 of 249 registrations)
• India alone: 48.2% of total (up from 36.8% in 2018)

Historical Comparison (2018-2023)

India-China share increased from 59.7% (2018) to 72.3% (2023). The article notes this represents the "first time" the combined share exceeded 70%.

Key Finding

The domestic raw material self-sufficiency rate dropped dramatically—from 24.4% (2021) to 11.9% (2022). Analysts expect further decline given 2023's weak DMF registration numbers.

Cost Factor

The article attributes this shift to price competition: "India-China raw materials are 20-30% cheaper" than domestic alternatives, intensifying amid government drug price reduction policies.

[FETCH #33] https://xlsxwriter.readthedocs.io/example_hyperlink.html

ASK: Extract the code verbatim, especially internal links ('internal:Sheet2!A1'), string/tip options, and link format (blue underline).

XlsxWriter Hyperlink Example - Code Extract

The example demonstrates using XlsxWriter's write_url() method with various options:

Basic syntax variations:

• worksheet.write_url("A1", "http://www.python.org/") - implicit formatting
• worksheet.write_url("A3", "http://www.python.org/", string="Python Home") - custom link text
• worksheet.write_url("A5", "http://www.python.org/", tip="Click here") - tooltip
• worksheet.write_url("A7", "http://www.python.org/", red_format) - custom format
• worksheet.write_url("A9", "mailto:jmcnamara@cpan.org", string="Mail me") - email links

Format example (red_format):

red_format = workbook.add_format({
    "font_color": "red",
    "bold": 1,
    "underline": 1,
    "font_size": 12,
})

Key distinction: The code shows that write_url() creates clickable hyperlinks, while write_string() writes URL text without functionality.

Note: The example doesn't demonstrate internal sheet references like "Sheet2!A1".

[FETCH #34] https://www.howtoexcel.org/kpi-data-cards/

ASK: Extract the KPI card construction steps: cell layout (merged cells / shapes), font sizes, custom number format for arrows (verbatim), colors, and how delta vs previous period is shown.

KPI Card Construction Summary

Cell Layout & Shapes

Rather than merged cells, the design uses 4 rectangle shapes: a background layer, two transparent rectangles for metrics, and one white-outlined shape for the title. Shapes are arranged, aligned using center alignment tools, and grouped together.

Font Formatting

• Large font sizes applied to key metrics (subtotal and percent difference)
• White text for the title on white background
• Font colors adjusted for contrast against the green background

Custom Number Format

The percent difference uses a specific custom format with directional indicators: "▲ 0.0 %;▼ -0.0 %"

This displays an up arrow for positive values and a down arrow for negative values.

Colors

• Background fill: Green (contrasts with black and white text)
• Background outline: Black
• Title shape: White fill with black outline
• Metric shapes: No fill, no outline (allows background to show through)

Delta Calculation

The percent change from the previous year is calculated using pivot table functionality: right-click the Order Total field and select "Show Values As" → "% Difference From" with Years as base field and Previous as base item. This automatically computes year-over-year percentage change by month.

[FETCH #35] https://openpyxl.readthedocs.io/en/stable/worksheet_tables.html

ASK: Extract the verbatim example creating a Table with TableStyleInfo, and notes on header strings, ref ranges, and filters.

Worksheet Tables Example and Key Notes

Creating a Table with TableStyleInfo

Here's the verbatim code example:

from openpyxl import Workbook
from openpyxl.worksheet.table import Table, TableStyleInfo

wb = Workbook()
ws = wb.active

data = [
    ['Apples', 10000, 5000, 8000, 6000],
    ['Pears',   2000, 3000, 4000, 5000],
    ['Bananas', 6000, 6000, 6500, 6000],
    ['Oranges',  500,  300,  200,  700],
]

ws.append(["Fruit", "2011", "2012", "2013", "2014"])
for row in data:
    ws.append(row)

tab = Table(displayName="Table1", ref="A1:E5")
style = TableStyleInfo(name="TableStyleMedium9", showFirstColumn=False,
                       showLastColumn=False, showRowStripes=True, showColumnStripes=True)
tab.tableStyleInfo = style
ws.add_table(tab)
wb.save("table.xlsx")

Important Notes

Header Requirements: "Table headings and column headings must always contain strings." Additionally, column headings in write-only mode must precisely match corresponding cell values.

Reference Ranges: The ref parameter specifies the table's cell range (e.g., "A1:E5").

Filters: "Filters will be added automatically to tables that contain header rows. It is not possible to create tables with header rows without filters."

Table Names: Use ws.add_table() to ensure uniqueness across the workbook's defined names.

[FETCH #36] https://www.johnsnowlabs.com/marketplace/fda-drug-master-files-directory/

ASK: List the dataset columns/fields for the FDA Drug Master Files directory (DMF number, status, type, submit date, holder, subject) and the update frequency and source.

FDA Drug Master Files Directory Dataset

Dataset Columns/Fields

The dataset contains the following fields:

1. DMF_Id - Drug Master File identification number (integer)
2. Is_DMF_Status_Active - Boolean indicating if DMF is active or closed
3. Type_of_DMF - Classification of DMF type (string)
4. Submission_Date - When the DMF was submitted (date)
5. DMF_Holder_Name - Organization or person owning the DMF (string)
6. DMF_Subject - Description of what the DMF covers (string)

Update Frequency & Source

Update Frequency: Quarterly

Source: John Snow Labs and U.S. Food and Drug Administration (FDA)

Temporal Coverage: 1939-2022

Spatial Coverage: United States

The dataset provides "confidential detailed information about facilities, processes, or articles used in the manufacturing, processing, packaging, and storing of one or more human drugs."

[FETCH #37] https://en.wikipedia.org/wiki/Drug_Master_File

ASK: Summarize DMF types (I–V), what the FDA public DMF list contains, and any section on Korea (KDMF), Europe (ASMF/CEP), and how status/holder changes are published.

Drug Master File Summary

DMF Types (I–V)

The Wikipedia article identifies five U.S. DMF classifications:

1. Type I: "Manufacturing Site, Facilities, Operating Procedures and Personnel"
2. Type II: Drug substances, intermediates, and materials for preparation
3. Type III: Packaging materials
4. Type IV: Excipients, colorants, flavors, and related materials
5. Type V: FDA-accepted reference information

FDA Public DMF List

The article does not contain information about what the FDA's public DMF list includes or specify which DMF details are publicly accessible versus confidential.

Regional Variants

The document mentions:

• Europe: European Drug Master File (EDMF) or Active Substance Master File (ASMF)
• United States: US-DMF

However, the article provides no information about Korea (KDMF), detailed European procedures, or how status/holder changes are published across these regions.

Key Limitation

The article explicitly notes it "may be confusing or unclear to readers" and lacks sufficient inline citations, which may explain gaps in comprehensive coverage of these regulatory systems.

[FETCH #38] https://www.pda.org/pda-letter-portal/home/full-article/a-comprehensive-review-of-regulatory-intelligence-exploring-tools-and-program-maturities

ASK: Summarize how regulatory intelligence programs track and disseminate changes: tracker/repository fields, dashboards, newsletters, impact assessment, watchlists, maturity levels.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #39] https://xlsxwriter.readthedocs.io/worksheet.html

ASK: Extract signatures and short examples for: freeze_panes(), autofilter(), set_column() (including width and options {'hidden', 'level'}), set_tab_color(), activate(), hide_gridlines(), set_zoom(), set_row(), write_url() internal link, and data_validation() list type.

XlsxWriter Method Signatures and Examples

freeze_panes()

Signature: freeze_panes(row, col[, top_row, left_col])

Freezes rows and columns at specified position to keep them visible during scrolling.

Example:

worksheet.freeze_panes(1, 0)  # Freeze the first row

---

autofilter()

Signature: autofilter(first_row, first_col, last_row, last_col)

Applies filtering capabilities to a range of cells.

Example:

worksheet.autofilter('A1:D10')

---

set_column()

Signature: set_column(first_col, last_col, width[, cell_format, options])

Configures column properties including width and formatting across a range.

Key Options:

• 'hidden' - Conceal the column
• 'level' - Establish outline hierarchy (0-7 range)

Examples:

worksheet.set_column('A:A', 20)  # Set column A to 20 character units
worksheet.set_column('D:D', 20, None, {'hidden': 1})  # Hide column D
worksheet.set_column('B:G', None, None, {'level': 1})  # Apply outline level

---

set_tab_color()

Signature: set_tab_color(color)

Assigns a color to the worksheet tab at the workbook's bottom.

Example:

worksheet.set_tab_color('#FF0000')  # Red tab

---

activate()

Signature: activate()

Designates the current worksheet as the initially displayed sheet in multi-sheet workbooks.

Example:

worksheet3.activate()

---

hide_gridlines()

Signature: hide_gridlines([option])

Conceals row and column gridlines on the worksheet display.

Example:

worksheet.hide_gridlines()

---

set_zoom()

Signature: set_zoom(scale)

Adjusts the worksheet magnification percentage.

Example:

worksheet.set_zoom(150)  # Display at 150% magnification

---

set_row()

Signature: set_row(row, height[, cell_format, options])

Modifies row characteristics such as height and formatting.

Example:

worksheet.set_row(0, 20)  # Set row 1 height to 20 character units

---

write_url() - Internal Links

Signature: write_url(row, col, url[, cell_format, string, tip])

Embeds hyperlinks, supporting internal worksheet navigation via the internal: prefix.

Examples:

worksheet.write_url('A1', 'internal:Sheet2!A1')  # Link to another sheet
worksheet.write_url('A3', "internal:'Sales Data'!A1")  # Named sheet with spaces

---

data_validation() - List Type

Signature: data_validation(first_row, first_col, last_row, last_col, options)

Restricts cell input to predefined dropdown selections.

Example:

worksheet.data_validation('B13', {'validate': 'list',
                                  'source': ['open', 'high', 'close']})

[FETCH #40] https://www.storytellingwithdata.com/blog/from-dashboard-to-story

ASK: Extract concrete dashboard design recommendations: layout, white space, chart type choice, color use, what a dashboard is for vs. a story, and any 'before/after' images referenced.

Dashboard Design Recommendations from "From Dashboard to Story"

Dashboard Design Principles

Layout & White Space: The article recommends being "thoughtful of the audience, and the insights they need to glean" by leveraging "white space, alignment, and grid layouts" to enhance readability and navigation.

Chart Type Selection: Specific recommendations include:

• Line graphs for showing registration and session trends (instead of bars)
• Dot plots for simpler viewing of trainer sessions
• Stacked bars for relative location comparisons

Visual Clarity: Remove clutter by eliminating "items that do not add information value, like gridlines and borders." Reduce the quantity of colors used to decrease visual complexity.

Dashboard vs. Story: Distinct Purposes

Dashboards enable exploration: Dashboards are "optimized for the exploration of data, not the communication of specific insights."

Stories drive action: Once insights are discovered, "a separate presentation, designed to bring the findings to light and get others to act upon the information" proves more effective than sharing the full dashboard.

Strategic Communication Techniques

Use "words and color" together as a "powerful combination for highlighting key points." Include an active slide title and explicit action recommendations to encourage stakeholder engagement.

Before/After Reference

The article includes a final comparison image labeled "before_after.png" demonstrating the transformation from dashboard to focused story presentation.

[FETCH #41] https://www.gov.kr/mw/AA020InfoCappView.do?HighCtgCD=A09006&CappBizCD=14700000458&tp_seq=

ASK: 원료의약품 등록신청 / 등록사항 변경등록신청 민원 안내 요약: 신청 종류, 처리기간, 변경등록 대상 항목(제조소, 제조방법, 규격 등), 수수료, 처리기관.

Korean Government Service Portal - Raw Materials Drug Registration

This webpage presents information about registering raw pharmaceutical materials (원료의약품 등록신청) through Korea's administrative services portal (Gov24).

Key Service Details

Application Types: The portal outlines registration for new raw materials drugs and modifications to existing registrations, with processing times ranging from 20 to 90 days depending on the application category.

Required Documents: Applicants must submit "원료의약품 등록증" (raw materials drug registration certificates) along with manufacturing facility information and quality standards per pharmaceutical safety regulations.

Processing Information: The service distinguishes between standard applications (20 days) and those requiring additional review (90 days), with completion dates calculated from submission time.

Administrative Support

The portal provides multiple contact channels: a call center at 1588-2188 and online guidance. A QR code enables quick access to processing status updates and related documentation.

Note: The webpage displays primarily in Korean with navigation menus, but core service information remains accessible through structured sections covering application procedures, requirements, and regulatory references.

[SEARCH #38] 등록대상 원료의약품(DMF) 등록 공고 주차 첨부

Web search results for query: "등록대상 원료의약품(DMF) 등록 공고 주차 첨부"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #39] Stephen Few Information Dashboard Design principles single screen at a glance definition

Web search results for query: "Stephen Few Information Dashboard Design principles single screen at a glance definition"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #40] Excel regulatory tracker template dashboard image xlsx download "regulatory" tracker status new changed withdrawn

Web search results for query: "Excel regulatory tracker template dashboard image xlsx download "regulatory" tracker status new changed withdrawn"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #41] KDMF Korea DMF registration number format "DMF" 등록번호 예시 "제" 호 원료의약품 등록증

Web search results for query: "KDMF Korea DMF registration number format "DMF" 등록번호 예시 "제" 호 원료의약품 등록증"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #42] https://trumpexcel.com/sparklines/

ASK: Summarize sparkline types (line/column/win-loss), when to use each, options (high/low point markers, axis), and any guidance on number of data points.

Excel Sparklines: Types and Usage Guide

The Three Sparkline Types

Excel offers three distinct sparkline formats:

Line Sparklines: Display trends over time with connected data points, ideal for showing continuous changes.

Column Sparklines: Represent individual values as vertical bars, useful for comparing discrete measurements across periods.

Win-Loss Sparklines: Show binary outcomes rather than magnitude. As the guide explains, these work best "in situations where the outcome is binary, such as Yes/No, True/False" and similar categorical comparisons.

Key Customization Options

Both line and column sparklines support several enhancement features:

• High/Low Point Markers: Highlight maximum and minimum values for quick identification
• First/Last Point Markers: Emphasize starting and ending data points
• Negative Point Highlighting: Make negative values stand out visually
• Axis Adjustment: Set custom minimum values to prevent distorted representations of small variations

Important Considerations

The guide notes that sparklines are "dynamic and are dependent on the underlying dataset," automatically updating when source data changes—a valuable feature for dashboards.

Regarding data volume, the tutorial doesn't specify an optimal number of data points. However, the examples provided suggest sparklines work effectively with modest datasets (typically 4-12 months or similar ranges), though the functionality supports larger ranges.

Empty cells require attention: you can configure sparklines to display gaps, substitute zeros, or connect surrounding data points.

[SEARCH #42] xlsxwriter conditional_format formula entire row highlight "$B2" example new rows previous day comparison

Web search results for query: "xlsxwriter conditional_format formula entire row highlight "$B2" example new rows previous day comparison"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[SEARCH #43] ColorBrewer colorblind safe qualitative 3-class palette hex Paul Tol status colors recommendation

Web search results for query: "ColorBrewer colorblind safe qualitative 3-class palette hex Paul Tol status colors recommendation"

Web search was not performed: this session has used its web search budget (200 of 200 WebSearch calls). Continue with the information already gathered instead of issuing more searches. If more searches are genuinely needed, ask the user to raise CLAUDE_CODE_MAX_WEB_SEARCHES_PER_SESSION.

REMINDER: You MUST include the sources above in your response to the user using markdown hyperlinks.

[FETCH #43] https://www.kpbma.or.kr/api/info/law/policy/download/211364

ASK: 원료의약품 등록 제도(DMF) 해설서 요약: 등록대상, 신규등록/변경등록(주요변경, 경미변경)/연차보고/취하의 정의, 등록번호 체계, 공고 항목(등록번호, 성분명, 신청인, 제조소 등), 심사기간.

DMF (Drug Master File) Registration System Overview

Based on the provided document, here's a summary of Korea's Drug Master File registration framework:

Key Registration Categories

The DMF system encompasses four primary administrative processes:

• New Registration: Initial submission of drug substance data
• Change Registration: Subdivided into major changes (significant alterations) and minor changes (routine updates)
• Annual Reporting: Yearly compliance submissions
• Withdrawal: Termination of registration status

Registration Number System

The document establishes a structured "registration number system" that uniquely identifies each approved DMF entry, enabling efficient tracking and reference throughout the substance's lifecycle.

Public Disclosure Requirements

Approved registrations are announced through official notices containing standardized information:

• Assigned registration identifier
• Active ingredient designation
• Applicant/sponsor information
• Manufacturing facility details
• Additional regulatory metadata

Administrative Timeline

The framework specifies defined "assessment periods" for regulatory review, establishing predictable processing timelines for applicants navigating the submission process.

---

This represents Korea's systematized approach to regulating raw pharmaceutical materials and their manufacturers through centralized documentation requirements.

[Binary content (application/octet-stream, 1.5MB) also saved to C:\Users\encep.claude\projects\D--workspace-DMF-Crawler\c00474d0-f118-4917-817d-1c16591aefc7\tool-results\webfetch-1788353987127-ms3y7y.bin]

[FETCH #44] https://personal.sron.nl/~pault/

ASK: Extract the hex codes for the 'bright', 'vibrant', and 'high-contrast' qualitative colour schemes, and any explicit advice for colour-blind safe use, plus the recommended 'bad data' grey.

getaddrinfo ENOTFOUND personal.sron.nl

[FETCH #45] https://jfly.uni-koeln.de/color/

ASK: Extract the Color Universal Design recommendations: the 8-color palette with RGB/hex, and the rules (e.g., use of shape/pattern/labels in addition to color, avoid red/green combos).

Color Universal Design Recommendations

8-Color Palette

The document presents a colorblind barrier-free palette (Figure 16) with these recommended colors:

• Vermilion (not pure red): RGB 100%, 32%, 0% (#FF2000)
• Orange
• Yellow
• Bluish Green (emerald tone)
• Blue
• Sky Blue
• Reddish Purple (not violet)
• Black

Core Design Rules

1. Redundant Coding "Use not only different colors but also a combination of different shapes, positions, line types and coloring patterns" to ensure colorblind accessibility.

2. Critical Color Combinations to Avoid

• Never combine red and green in fluorescent imaging or charts
• Substitute magenta (red + blue) for red when paired with green

3. Implementation Guidelines

• Use thick lines and bold fonts (Arial, Helvetica) over thin styles
• Label graph elements directly rather than using separate color-coded keys
• Incorporate hatching patterns, different line styles (solid/dotted), and distinct symbols
• Ensure sufficient brightness and saturation contrast between objects and backgrounds

4. Text and Object Presentation "Avoid indicating objects only by names"—describe location and shape alongside color references (e.g., "red, round cells on top left").

[FETCH #46] https://www.perceptualedge.com/articles/ie/dashboard_confusion.pdf

ASK: Extract Stephen Few's definition of a dashboard and key characteristics (single screen, at a glance, most important information, concise display media).

I appreciate your request, but I need to be transparent: the content provided is a PDF file in raw binary format with encoded streams and metadata. While I can see the document structure indicates this is about "Dashboard Confusion" by Stephen Few with keywords including "dashboard design" and "data visualization," the actual readable text content from the document body is not legible in this format.

The metadata shows:

• Title: Dashboard Confusion
• Author: Stephen Few
• Keywords: dashboard, dashboard design, data visualization, data analysis, information visualization, BI, business intelligence

However, I cannot accurately extract Stephen Few's specific definition of a dashboard or the particular characteristics you're asking about (single screen, at-a-glance, most important information, concise display) from this encoded PDF data without being able to reliably decode the content streams.

To properly fulfill your request with the accuracy and attribution standards you've outlined, I would need either:

• A text-based version of the document
• A properly decompressed/readable PDF file
• The original article source

I apologize that I cannot provide the specific quotes and characteristics you requested given the current document format.

[Binary content (application/pdf, 32.6KB) also saved to C:\Users\encep.claude\projects\D--workspace-DMF-Crawler\c00474d0-f118-4917-817d-1c16591aefc7\tool-results\webfetch-1788354022280-zbsc84.pdf]

[FETCH #47] https://www.excelcampus.com/charts/excel-dahsboard-tutorial-full-buildout/

ASK: Describe the dashboard layout built in this tutorial: which KPI cards, which charts (top 5, over time, mix), slicers, and any design guidance (colors, fonts, alignment). Include image links if present.

Dashboard Layout Summary

Based on the tutorial content provided, the dashboard includes these key components:

Charts & Visualizations:

• KPI cards (specific metrics not detailed in the excerpt)
• A "top 5 items chart"
• A "sales-over-time chart with a week/month toggle"
• A "customer mix chart"

Interactivity:

• Connected slicer enabling "one click filters everything on the dashboard at once"

Technical Approach: The tutorial emphasizes that "none of this requires complex formulas or VBA. Every piece of the dashboard is powered by Pivot Tables, so it stays fully dynamic and updates with the click of a button as new data comes in."

Design Context: The dashboard design originated from a previous tutorial using AI tools to create the layout and appearance. However, the current article focuses on the Excel build-out rather than design specifics like colors, fonts, or alignment guidance.

Note: No images or detailed design specifications are included in the extracted content provided.

[FETCH #48] https://open.fda.gov/apis/drug/drugsfda/

ASK: List the Drugs@FDA endpoint fields: application_number, sponsor_name, openfda, products (product_number, brand_name, active_ingredients, marketing_status, dosage_form, route), submissions (submission_type, submission_number, submission_status, submission_status_date, submission_classification_code, review_priority). Note update frequency and source.

Drugs@FDA Endpoint Summary

Source: The data originates from "Drugs@FDA" and is "converted into JSON, which is a widely used machine readable format" by openFDA.

Update Frequency: The API receives updates "Daily (Monday-Friday)."

Coverage Period: The dataset spans from 1939 to the present.

Key Fields:

• application_number
• sponsor_name
• openfda (harmonized identifiers)
• products (product_number, brand_name, active_ingredients, marketing_status, dosage_form, route)
• submissions (submission_type, submission_number, submission_status, submission_status_date, submission_classification_code, review_priority)

Note: The endpoint includes prescription drugs, generics, biologics, and over-the-counter products approved since 1939, with comprehensive documentation available for approvals since 1998.

[FETCH #49] https://www.goskills.com/excel/resources/best-practices-in-dashboard-design

ASK: List the 12 best practices verbatim headings with one-line explanation each.

12 Best Practices in Dashboard Design

1. "What story are you trying to tell?" - Clarify your dashboard's purpose before presenting data.

2. "Decide on the layout" - Position important information prominently at the top and left side.

3. "Think of your audience" - Design with your readers' needs and perspectives in mind.

4. "Use the right visuals" - Select appropriate chart types that match your data story.

5. "Make it interactive" - Enable users to filter, sort, and navigate the information easily.

6. "Remove the fluff" - Eliminate elements that don't contribute to your core message.

7. "Add context" - Provide reference points like targets or comparisons for clarity.

8. "Use contrast" - Emphasize key values through formatting and visual hierarchy.

9. "Organize and group elements" - Associate related visuals to show relationships clearly.

10. "Be consistent with fonts and colors" - Maintain uniformity throughout for professional appearance.

11. "Use colors and labels effectively" - Apply descriptive labels and strategic color coding for depth.

12. "Access to more detail" - Link to additional dashboards rather than cluttering one page.

[FETCH #50] https://catalog.data.gov/dataset/drugsfda-database

ASK: Describe the Drugs@FDA database dataset: tables, key fields, format, update frequency.

Drugs@FDA Database Dataset Overview

Content & Scope: The database comprises "FDA-approved brand name and generic prescription and over-the-counter human drugs and biological therapeutic products." Coverage spans most approvals since 1939, with comprehensive documentation (labels, approval letters, reviews) available primarily for drugs approved since 1998.

Format: The dataset is distributed as a single ZIP file download, containing structured data about pharmaceutical products and their regulatory history.

Update Frequency: According to the metadata, the accrual periodicity is R/P1D, indicating daily updates. The dataset was last refreshed on July 16, 2025.

Key Fields: While specific table structures aren't detailed on this page, the resource likely includes fields related to:

• Brand and generic drug names
• Approval dates and status
• Drug classifications (prescription vs. OTC)
• Biological therapeutic products
• Associated regulatory documentation

Access: The dataset is publicly available under the Open Data Commons Open Database License (ODbL) and can be downloaded directly from the FDA's website.

For detailed technical specifications about table schemas and field definitions, the landing page at fda.gov/Drugs/InformationOnDrugs provides additional documentation.

[FETCH #51] https://www.datacamp.com/tutorial/create-excel-dashboards-tutorial

ASK: Extract the dashboard layout and design guidance: sheet structure (data / calculations / dashboard sheets), KPI placement, chart types, color and font rules, and any template/image links.

Excel Dashboard Layout & Design Guidance

Sheet Structure

The tutorial recommends creating two initial sheets:

• Data sheet: Houses imported raw data formatted as a table
• Dashboard sheet: Contains final visualizations and interactive elements

Additional sheets are created for each PivotTable supporting individual charts, which can then be hidden to maintain workbook organization.

KPI Placement & Content Strategy

Dashboard elements should be organized around specific business objectives:

• "Give a quick snapshot of the campaign's overall performance" using numeric metrics for quick visibility
• Demographic comparison charts showing customer profiles (those who converted vs. those who didn't)
• Contact frequency analysis demonstrating correlation with success rates

Chart Types Recommended

• Horizontal bar charts: For demographic categories and comparisons
• Line charts: Optimal for trends, particularly time-series data
• Vertical bar charts: Supporting contact frequency analysis
• Combination approaches: Mixing line and bar charts for multidimensional insights

Design Rules

Visual hierarchy & simplicity:

• Apply the "five-second rule"—critical information should be extractable within five seconds
• Avoid overcrowding; provide whitespace for each element
• Maintain consistent formatting, colors, and layout across all dashboards
• Use colorblind-friendly palettes, avoiding red-green combinations

Interactivity features:

• Slicers for PivotTable filtering
• Data validation drop-down lists
• Conditional formatting for value highlighting
• Timelines for date-based filtering

No specific template images or downloadable files are provided in the source content.

[FETCH #52] https://xlsxwriter.readthedocs.io/example_conditional_format.html

ASK: Extract verbatim code for the 'formula' type examples and the 'cell' type examples, including the formats used (bg_color/font_color hex values) and the range notation.

Conditional Formatting Code Extraction

Based on the provided content, there are no 'formula' type examples shown in this XlsxWriter documentation page.

'Cell' Type Examples

Example 1 uses these formats and range:

• Format 1: {"bg_color": "#FFC7CE", "font_color": "#9C0006"}
• Format 2: {"bg_color": "#C6EFCE", "font_color": "#006100"}
• Range: "B3:K12"
• Criteria: ">=" with value 50, and "<" with value 50

Example 2 applies cell-type formatting with:

• Same formats as Example 1
• Range: "B3:K12"
• Criteria: "between" (minimum 30, maximum 70) and "not between"

Example 6 demonstrates non-contiguous ranges:

• Same formats
• Range notation: "B3:K6 B9:K12" using the "multi_range" parameter
• Criteria: ">=" and "<" with value 50

The page does not include formula-based conditional formatting demonstrations.

[FETCH #53] https://chandoo.org/wp/excel-dashboards/

ASK: List the dashboard design tips and example dashboards/templates with links and image URLs.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #54] https://www.iconplc.com/insights/regulatory-intelligence/regulatory-intelligence-newsletter

ASK: Describe the newsletter's structure: sections (by region/agency, topic), how items are summarized (headline, date, source link, impact), and frequency.

Regulatory Intelligence Newsletter Structure

Overview

The newsletter provides monthly updates on regulatory changes across jurisdictions and topics. Based on the webpage content, here's what's detailed:

Key Sections Covered

Geographic/Agency Focus: The newsletter tracks updates from major regulators including "the FDA, EMA, PMDA, NMPA, MHRA, TGA and many more."

Topic Categories:

• Marketing authorization (including labeling and post-approval submissions)
• Scientific guidance updates (quality, safety, efficacy)
• GxP guidance changes
• Special topics (orphan drugs, vaccines, early access programs)

Summarization Approach

Each item appears to follow a streamlined format designed for quick scanning. The content notes: "The format is designed to give you the key points with relevant links so you can scan quickly and find more information on the source topics online."

Frequency & Delivery

Cadence: Monthly publication

Distribution: Direct email subscription to readers' inboxes, allowing subscribers to "stay current on country, regional and global regulatory changes"

Current Edition Details

The August edition highlights FDA guidance on "broader eligibility in oncology clinical trials" alongside updates on labeling, marketing applications, post-approval submissions, and scientific guidance across quality, non-clinical, efficacy, and safety domains.

[FETCH #55] https://bigexcelenergy.com/excel-kpi-card-design/

ASK: Extract the KPI card anatomy: font sizes (pt), caption, delta formatting, colors, spacing, and number of cards per row guidance.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #56] https://www.mfds.go.kr/brd/m_1059/down.do?brd_id=data0010&seq=15144&data_tp=A&file_seq=2

ASK: 원료의약품 등록 및 변경등록 업무 자료 요약: 변경등록 대상 항목, 주요/경미 변경 구분, 취하 절차, 공고 항목, 등록번호 형식.

I appreciate you sharing this document, but I'm unable to extract meaningful information from it. The content appears to be a corrupted or improperly encoded PDF file with compressed/binary data rather than readable text.

The header indicates this is a PDF document related to pharmaceutical raw material registration and modification procedures in Korean, but the actual content is rendered as compressed streams and encoded characters that I cannot reliably parse or summarize.

To help you effectively, I would need:

1. A properly decoded PDF - The file seems to have encoding issues
2. Plain text extraction - If you can copy-paste the actual text content
3. A working PDF file - If the original file is corrupted, try re-uploading it

Could you provide the document in one of these alternative formats so I can summarize the key information about registration procedures, change categories, and administrative requirements you're interested in?

[Binary content (application/octet-stream, 579KB) also saved to C:\Users\encep.claude\projects\D--workspace-DMF-Crawler\c00474d0-f118-4917-817d-1c16591aefc7\tool-results\webfetch-1788354034436-g9o2yi.bin]

[FETCH #57] https://www.edqm.eu/en/databases

ASK: Describe the Certification (CEP) database: searchable fields, statuses (valid/suspended/withdrawn/expired), download option, and update frequency.

The server returned HTTP 403 Forbidden.

The response body was not retrieved. If this URL requires authentication, use an authenticated tool (e.g. gh for GitHub, or an MCP-provided fetch tool) instead of WebFetch.

[FETCH #58] https://www.pk-anexcelexpert.com/flooring-installation-kpi-scorecard-in-excel/

ASK: Describe the KPI card layout (elements per card, arrangement, sparkline usage) and list any image URLs of the dashboard shown.

KPI Card Layout

Each scorecard tile contains these elements arranged vertically:

1. KPI Name - displayed at top
2. Traffic Light - red/amber/green status indicator
3. Large Value - the actual metric in prominent typography
4. Target Value - the benchmark figure
5. Absolute Change - variance from target in raw numbers
6. Percentage Change with Arrow - colored directional indicator showing performance trend
7. Twelve-Month Sparkline - small line chart at bottom showing historical data

As stated in the article: "each showing the KPI name, the traffic light, the value in large type, the target value, the absolute change, the percentage change with a coloured arrow, and a twelve-month sparkline."

The layout displays "ten cards laid out five across" on the scorecard page.

Dashboard Image URLs

The webpage content includes three image URLs showing the scorecard and related pages:

1. https://www.pk-anexcelexpert.com/wp-content/uploads/2026/08/Flooring-Installation-KPI-Scorecard-2-1210x642.jpg
2. https://nextgentemplates.com/wp-content/uploads/2026/08/Flooring-Installation-KPI-Scorecard-3-scaled.jpg (KPI Analysis page)
3. https://nextgentemplates.com/wp-content/uploads/2026/08/Flooring-Installation-KPI-Scorecard-4.jpg (KPI Trend page)

[FETCH #59] https://www.datahubpro.co.uk/tutorials/excel-dashboard-templates

ASK: List the design rules given for dashboards (KPI cards, change vs previous period, color, layout) and any template download or image links.

Dashboard Design Rules

KPI Cards & Metrics

The guide emphasizes that dashboards should lead with 3-6 KPI cards as headline numbers. Each KPI requires three components: "a total, a comparison, and a change." The period-over-period comparison uses the formula =(ThisMonth-LastMonth)/LastMonth, formatted as a percentage.

Color & Visual Hierarchy

Design employs one accent color paired with greys and white space. Change indicators use conditional coloring: "green for up, red for down." The guide warns against "3-D effects" and "dual axes used carelessly" as they obscure clarity.

Layout Principles

Dashboards must "fit one screen without scrolling." The visual hierarchy places KPI cards across the top, "the most important chart top-left where the eye lands first," with supporting charts below. The guide stresses that "if a viewer cannot grasp the headline in about five seconds, the dashboard is trying to say too much."

Polish includes hiding gridlines and row headers for a clean canvas, aligning elements to grids, and using generous white space.

Template Downloads

The page offers:

• KPI Dashboard Template (175 formulas, 4 sheets)
• Sales Dashboard Template (.xlsx, free with account)
• 48 additional templates available at /templates

No direct image links are provided; dashboards are shown via an interactive preview widget.

[CMD] cd "C:/Users/encep/.claude/projects/D--workspace-DMF-Crawler/c00474d0-f118-4917-817d-1c16591aefc7/tool-results" && ls -la && python -c "import pypdf; print('pypdf', pypdf.version)" 2>&1; python -c "import pdfplumber; print('pdfplumber ok')" 2>&1; python -c "import fitz; print('pymupdf ok')" 2>&1

…[truncated 86 chars]

total 3744
drwxr-xr-x 1 encep 197609       0 Sep  2 22:00 ./
drwxr-xr-x 1 encep 197609       0 Sep  2 21:56 ../
-rw-r--r-- 1 encep 197609   53679 Sep  2 22:00 bpwb3m0gh.txt
-rw-r--r-- 1 encep 197609   76973 Sep  2 21:58 toolu_01BwvM9LqdS4nDiLjGFfEQAa.txt
-rw-r--r-- 1 encep 197609   63280 Sep  2 21:58 toolu_01MZJEEsuDD23cDavsGDPwKc.txt
-rw-r--r-- 1 encep 197609  194487 Sep  2 21:56 webfetch-1788353809737-s6vaqp.pdf
-rw-r--r-- 1 encep 197609   96301 Sep  2 21:57 webfetch-1788353874771-5fu2oa.pdf
-rw-r--r-- 1 encep 197609  157615 Sep  2 21:57 webfetch-1788353877548-psyt0q.pdf
-rw-r--r-- 1 encep 197609  355286 Sep  2 21:58 webfetch-1788353892760-w6ajid.pdf
-rw-r--r-- 1 encep 197609 1580791 Sep  2 21:59 webfetch-1788353987127-ms3y7y.bin
-rw-r--r-- 1 encep 197609  605750 Sep  2 22:00 webfetch-1788354016451-x0j250.pdf
-rw-r--r-- 1 encep 197609   33348 Sep  2 22:00 webfetch-1788354022280-zbsc84.pdf
-rw-r--r-- 1 encep 197609  592942 Sep  2 22:00 webfetch-1788354034436-g9o2yi.bin
pypdf 4.3.1

pdfplumber ok

pymupdf ok

webfetch-1788353987127-ms3y7y.bin: PDF document, version 1.4, 118 page(s)
webfetch-1788354034436-g9o2yi.bin: PDF document, version 1.6 (zip deflate encoded)

[FETCH #60] https://www.bdo.com/insights/industries/life-sciences/a-guide-to-drug-master-files

ASK: What does it say about the FDA public DMF list: fields shown (DMF number, status, type, submit date, holder, subject), update frequency, and status codes (Active/Inactive). Also DMF type definitions.

FDA Public DMF List Information

Available Fields: According to the content, "CDER maintains a database containing a publicly available list of DMFs filed with CDER. The list contains information about the DMF number, activity status (active or inactive), type, holder name and subject (title)."

Update Frequency: The FDA refreshes this list periodically—specifically, "The list is updated on a quarterly basis."

Status Codes: The document indicates two operational designations: active or inactive. Active status suggests the DMF remains current, while inactive typically reflects discontinuation or closure.

DMF Type Definitions: The guide describes four functional categories:

• Type II: Drug substances, intermediates, and products
• Type III: Packaging materials and container-closure systems
• Type IV: Excipients, colorants, and flavors
• Type V: Information not covered by Types II–IV, including facilities, processes, and clinical data

[FETCH #61] https://sronpersonalpages.nl/~pault/

ASK: Extract the hex codes for the 'bright', 'vibrant', and 'high-contrast' qualitative colour schemes, and any explicit advice for colour-blind safe use, plus the recommended 'bad data' grey.

Colour-Blind Safe Qualitative Schemes

Bright Scheme

Hex codes: '#4477AA', '#EE6677', '#228833', '#CCBB44', '#66CCEE', '#AA3377', '#BBBBBB'

The bright scheme is described as "colour-blind safe" and represents the primary recommendation for qualitative data visualization.

Vibrant Scheme

Hex codes: '#EE7733', '#0077BB', '#33BBEE', '#EE3377', '#CC3311', '#009988', '#BBBBBB'

This scheme is "equally colour-blind safe" as the bright option and was designed for TensorBoard's data visualization framework.

High-Contrast Scheme

Hex codes: '#004488', '#DDAA33', '#BB5566'

This alternative is "colour-blind safe and optimized for contrast," with the note that "this scheme also works well for people with monochrome vision and in a monochrome printout."

Colour-Blind Safe Guidance

The document confirms all three schemes "are distinct for all people, including colour-blind readers" and includes comprehensive simulations showing how each appears to people with green-blindness and red-blindness.

Bad Data Grey

Hex code: '#888888' (used across sequential schemes as the standard bad data indicator)

[CMD] cd "C:/Users/encep/.claude/projects/D--workspace-DMF-Crawler/c00474d0-f118-4917-817d-1c16591aefc7/tool-results" && python - <<'EOF'

import fitz, re, sys, io sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace') out_dir = r"C:\Users\encep\AppData\Local\Temp\claude\D--wo …[truncated 696 chars]

== haeseolseo: pages=118 chars=113549

                                  |  원료의약품 등록 제도(DMF) 해설서  | 제5개정판(민원인안내서) | 2020.12. |        허가총괄담당관 |  | 지침·안내서 제‧개정 점검표 | 명칭 | 원료의약품 등록 제도(DMF해설서 제5개정판 | 아래에 해당하는 사항에 체크하여 주시기 바랍니다. | 등록대상 | 여부 | □ 이미 등록된 지침·안내서 중 동일·유사한 내용의  | 지침·안내서가 있습니까?  | □ 예 | ■ 아니오 | ☞ 상기 질문에 ‘예’라고 답하신 경우 기존의 지침·안내서의 개정을 우선적으로  | 고려하시기 바랍니다. 그럼에도 불구하고 동 지침·안내서의 제정이 필요한  | 경우 그 사유를 아래에 기재해 주시기 바랍니다. | (사유 :                                                                 ) | □ 법령(법‧시행령‧시행규칙) 또는 행정규칙(고시‧훈령‧예규)의  | 내용을 단순 편집 또는 나열한 것입니까?  | □ 예 | ■ 아니오 | □ 단순한 사실을 대외적으로 알리는 공고의 내용입니까? | □ 예 | ■ 아니오 | □ 일회성 지시ㆍ명령에 해당하는 내용입니까? | □ 예 | ■ 아니오 | □ 외국 규정을 번역하거나 설명하는 내용입니까? | □ 예 | ■ 아니오 | □ 신규 직원 교육을 위해 법령 또는 행정규칙을 알기 쉽게  | 정리한 자료입니까?  | □ 예 | ■ 아니오 | ☞ 상기 사항 중 어느 하나라도 ‘예’에 해당되는 경우에 지침·안내서 등록 대상이 아닙니다.  |   지침·안내서 제·개정 절차를 적용하실 필요는 없습니다. | 지침·안내서  | 구분 | □ 행정사무의 통일을 기하기 위하여 내부적으로 행정사무의 세부 | 기준이나 절차를 제시하는 것입니까? (공무원용) | □예(☞지침서) | ■ 아니오 | □ 민원인들의 이해를 돕기 위하여 법령 또는 행정규칙을 알기  | 쉽게 설명하거나 특정 민원업무에 대한 행정기관의 대외적인 입장을  | 기술하는 것입니까? (민원인용) | ■ 예(☞안내서)  | □ 아니오 | 기타 확인 | 사항 | □ 상위 법령을 일탈하여 새로운 규제를 신설·강화하거나  | 민원인을 구속하는 내용이 있습니까? | □ 예  | ■ 아니오 | ☞ 상기 질문에 ‘예’라고 답하신 경우 상위법령 일탈 내용을 삭제하시고 지침· | 안내서 제·개정 절차를 진행하시기 바랍니다. | 상기 사항에 대하여 확인하였음. | 2020 년    12  월   일 | 담당자 | 확  인(부서장) | 김성란 | 이수정 |  | 이 지침서는 원료의약품 등록 제도 업무에 대한 식품의약품안전처 | 관련 부서 담당 직원의 업무처리를 위한 것입니다. | 본 지침서는 대외적으로 법적 효력을 가지는 것이 아니므로 본문의 | 기술방식(‘∼하여야 한다’ 등)에도 불구하고 참고로만 활용하시기 바랍 | 니다. 또한, 본 지침서는 2020년 12월 현재 유효한 법규를 토대로 작성 | 되었으므로 이후 최신 개정 법규 내용 등에 따라 달리 적용될 수 있음 | 을 알려드립니다. |   ※ “공무원 지침서”란 행정사무의 통일을 기하기 위하여 내부적으로 행정사무의  | 세부기준이나 절차를 제시하는 것임(식품의약품안전처 지침서등의 관리에  | 관한 규정 제2조) | ※ 본 지침서에 대한 의견이나 문의사항이 있을 경우 허가총괄담당



== mfds_change: pages=35 chars=23925

MFDS/MaPP : GRP-MaPP-허가업무-04(지침서-0943-03) | 승인일: 2015  | 개정일: 2025. 2. 20.(6개정) | 원료의약품 등록 및 변경등록 업무  | Drug Master File(DMF) registration and post-approval registration | 구분 | 소속 및 이름 | 작성자 | 의약품허가총괄과 주무관 김남윤 | 검토자 | 의약품허가총괄과 사무관 이근아 | 승인자 | 의약품허가총괄과 과  장 김영주  |  | - 2 - | 지침서ᆞ안내서 제ᆞ개정 점검표 | 명칭 | 원료의약품 등록 및 변경등록 업무 | 아래에 해당하는 사항에 체크하여 주시기 바랍니다. | 등록대상 | 여부 | □ 이미 등록된 지침서ㆍ안내서 중 동일ㆍ유사한 내용의  | 지침서ㆍ안내서가 있습니까?  | □ 예 | ■ 아니오 | ☞ 상기 질문에 ‘예’라고 답하신 경우 기존의 지침서ㆍ안내서의 개정을 우선적 | 으로 고려하시기 바랍니다. 그럼에도 불구하고 동 지침서ㆍ안내서의 제정이  | 필요한 경우 그 사유를 아래에 기재해 주시기 바랍니다. | (사유 :                                                                 ) | □ 법령(법ㆍ시행령ㆍ시행규칙) 또는 행정규칙(고시ㆍ훈령ㆍ예규)의  | 내용을 단순 편집 또는 나열한 것입니까?  | □ 예 | ■ 아니오 | □ 단순한 사실을 대외적으로 알리는 공고의 내용입니까? | □ 예 | ■ 아니오 | □ 일회성 지시ㆍ명령에 해당하는 내용입니까? | □ 예 | ■ 아니오 | □ 외국 규정을 단순 번역하거나 설명하는 내용입니까? | □ 예 | ■ 아니오 | □ 신규 직원 교육을 위해 법령 또는 행정규칙을 알기 쉽게  | 정리한 자료입니까?  | □ 예 | ■ 아니오 | ☞ 상기 사항 중 어느 하나라도 ‘예’에 해당되는 경우에 지침서ㆍ안내서 등록 대상이 아닙니다.  |    지침서ㆍ안내서 제ㆍ개정 절차를 적용하실 필요는 없습니다. | 지침서ㆍ안내서  | 구분 | □ 행정사무의 통일을 기하기 위하여 내부적으로 행정사무의 세부 | 기준이나 절차를 제시하는 것입니까? (공무원용) | ■ 예(☞지침서)  | □ 아니오 | □ 민원인들의 이해를 돕기 위하여 법령 또는 행정규칙을 알기  | 쉽게 설명하거나 특정 민원업무에 대한 행정기관의 대외적인 입장을  | 기술하는 것입니까? (민원인용) | □ 예(☞안내서)  | ■ 아니오 | 기타 확인 | 사항 | □ 상위 법령을 일탈하여 새로운 규제를 신설ㆍ강화하거나  | 민원인을 구속하는 내용이 있습니까? | □ 예  | ■ 아니오 | ☞ 상기 질문에 ‘예’라고 답하신 경우 상위법령 일탈 내용을 삭제하시고 지침서ㆍ | 안내서 제ㆍ개정 절차를 진행하시기 바랍니다. | 상기 사항에 대하여 확인하였음. |    2025 년   2 월   20 일 | 담당자 | 확  인(부서장) | 김 남 윤 | 김 영 주     |  |   ※ 본 지침서에 대해 의견이나 문의사항이 있을 경우 식품의약품안전처 의약품허가총괄과로  | 문의하시기 바랍니다. |      전화 : 043-719-2339 |      팩스 : 043-719-2300 |   이 지침서는 원료의약품 등록 및 변경등록 업무의 세부 지침을 정한 것으로서  | 식품의약품안전처 관련 부서 담당 직원의 업무처리를 위한 것입니다. |  



== few: pages=4 chars=10305

Perceptual Edge  | Dashboard Design  | Page 1  |   |   | Dashboard Confusion  | Stephen Few  | March 20, 2004  | Once again, marketing alchemists have cooked up a bowl of confusion with only a few simple  | ingredients. Everyone in the business intelligence (BI) space is wild about dashboards, but  | few proponents are talking about the same thing. This state of perplexity often occurs after  | the birth of a new buzzword. Around a decade ago, I remember asking my IBM account  | manager how IBM defined the new term in vogue at the time — data warehousing. His  | respons
…[truncated 973 chars]

[CMD] cd "C:/Users/encep/AppData/Local/Temp/claude/D--workspace-DMF-Crawler/c00474d0-f118-4917-817d-1c16591aefc7/scratchpad" && python - <<'EOF'

import re, sys, io sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace') def grep(fn, pats, width=220, maxhits=6): t = open(fn …[truncated 622 chars]

<persisted-output>
Output too large (42.5KB). Full output saved to: C:\Users\encep\.claude\projects\D--workspace-DMF-Crawler\c00474d0-f118-4917-817d-1c16591aefc7\tool-results\b0832ujzx.txt

Preview (first 2KB):
##### haeseolseo.txt :: /공고/ hits=44

... ? □ 예 ■ 아니오 ☞ 상기 질문에 ‘예’라고 답하신 경우 기존의 지침·안내서의 개정을 우선적으로 고려하시기 바랍니다. 그럼에도 불구하고 동 지침·안내서의 제정이 필요한 경우 그 사유를 아래에 기재해 주시기 바랍니다. (사유 : ) □ 법령(법‧시행령‧시행규칙) 또는 행정규칙(고시‧훈령‧예규)의 내용을 단순 편집 또는 나열한 것입니까? □ 예 ■ 아니오 □ 단순한 사실을 대외적으로 알리는 공고의 내용입니까? □ 예 ■ 아니오 □ 일회성 지시ㆍ명령에 해당하는 내용입니까? □ 예 ■ 아니오 □ 외국 규정을 번역하거나 설명하는 내용입니까? □ 예 ■ 아니오 □ 신규 직원 교육을 위해 법령 또는 행정규칙을 알기 쉽게 정리한 자료입니까? □ 예 ■ 아니오 ☞ 상기 사항 중 어느 하나라도 ‘예’에 해당되는 경우에 지침·안내서 등록 대상이 아닙니다. 지침·안내서 제·개정 절차를 적용하실  ...

... 표 4까지 해당하지 않는 비타민, 무기질 제외) - 2 - ○ ‘20. 06. 04. : 제네릭의약픔 품질강화 방안의 일환으로 완제의약품 품질심사 시 원료의약품 연계심사를 위한 등록대상 원료의약품 심사 절차 개선(제네릭의약품 품질심 사 절차 개선 정책(‘20.5.13.발표) 연계) ○ ‘20. 07.24. : 원료·완제 품질심사 연계를 위한 세부 운영절차 마련 - 3 - □ 원료의약품 등록 공고 현황 (‘20.11.30., 취하포함) ( )의 숫자는 재공고된 숫자를 의미함 구분 ’03 ’04 ’05 ’06 ’07 ’08 ’09 ’10 ’11 ‘12 ‘13 ‘14 ‘15 ‘16 신약 원료약품 9 12 18 21 28 30 54 60 64 (28) 75 (17) 93 (27) 97 (23) 122 (32) 123 (32) 별도지정 고시품목 등 - - 457 50 110 108 10 ...

... ‘20. 06. 04. : 제네릭의약픔 품질강화 방안의 일환으로 완제의약품 품질심사 시 원료의약품 연계심사를 위한 등록대상 원료의약품 심사 절차 개선(제네릭의약품 품질심 사 절차 개선 정책(‘20.5.13.발표) 연계) ○ ‘20. 07.24. : 원료·완제 품질심사 연계를 위한 세부 운영절차 마련 - 3 - □ 원료의약품 등록 공고 현황 (‘20.11.30., 취하포함) ( )의 숫자는 재공고된 숫자를 의미함 구분 ’03 ’04 ’05 ’06 ’07 ’08 ’09 ’10 ’11 ‘12 ‘13 ‘14 ‘15 ‘16 신약 원료약품 9 12 18 21 28 30 54 60 64 (28) 75 (17) 93 (27) 97 (23) 122 (32) 123 (32) 별도지정 고시품목 등 - - 457 50 110 108 101 142 (3) 844 (637) 623 (375) 676 ( ...

... 려는 자는 총리령으로 정하는 바에 따라 그 성분ᆞ명칭과 제조방법 등 총리령으로 정하는 사항을 식품의약품안전처장에게 등록할 수 있다. ② 식품의약품안전처장은 제1항에 따른 등록사항이 총리령으로 정하는 기준에 적합한지 여부를 검토 하여 그 결과를 신청인에게 알리고, 그 내용을 원료의약품 등록대장에 기록하고 보관하여야 한다. 이 경우 해당 원료의약품의 성분 및 제조원 등 총리령으로 정하는 사항을 공고하여야 한다. ③ 제1항 및 제2항에 따라 등록된 사항 중 총리령으로 정하는 중요한 사항을 변경하려는 자는 식품 의약품안전처장에게 변경등록을 하여야 한다. 다만, 그 밖의 사항을 변경하려는 자는 보고하여야 한다. ④ 제1항부터 제3항까지의 규정에 따라 등록된 원료의약품은 제31조제2항에 따른 품목허가를 받거나 품목신고를 한 것으로 본다. ⑤ 제1항부터 제3항까지에서 규정한 사항 외에 원료 ...

...
</persisted-output>

[CMD] cd "C:/Users/encep/AppData/Local/Temp/claude/D--workspace-DMF-Crawler/c00474d0-f118-4917-817d-1c16591aefc7/scratchpad" && python - <<'EOF'

import re, sys, io sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace') t = open("haeseolseo.txt", encoding='utf-8').read().repla …[truncated 387 chars]

=== Q51 ===

 Q51. DMF 대상원료의약품 중 공고품목현황에서 등록번호는 어떻게 부여되는지 궁금 합니다. 예를 들면 "20110531-71-B-317-05"에서 앞에 8자리 숫자는 수리된 날짜인 것 같은데, 등록번호의 규칙이 있는지, 어떤 기준으로 번호가 매겨지는 것인지 궁금합니다. 또한 등록번호 뒤에 괄호가 있는 부분은 무슨 의미인지 A. - 20110531 : 등록수리일자 - 71 : 원료의약품 등록에 관한 규정(식약처고시) [별표1]에 따른 각 성분의 일련번호 - B : 원료의약품 등록에 관한 규정의 부칙에 따른 시행일을 고려한 일련번호 A~E 는 별표1 제1호 내지 제99호의 성분, 2003년1월 1일 - 2008년 1월 1일부터 시행 F 는 별표1 제100호 내지 제113호의 성분, 2009년 1월 1일부터 시행 G 는 별표1 제114호 내지 123호의 성분, 2010년 1월 1일부터 시행 H 는 별표1 제124호 내지 141호의 성분, 2011년 1월 1일부터 시행 I 는 별표1 제142호 내지 208호의 성분, 2013년 1월 1일부터 시행 K 는 별표1의2 제1호 내지 19호의 성분, 2018년 1월 1일부터 시행 J 는 별표1 209호의 「의약품동등성 확보 필요 대상 의약품 지정」성분 및 210호의 주사제 원료의약품(2017년 12월 25일부터 시행), 211호의 신청사가 제조(수입) 하여 등록하고자 하는 원료의약품(2018년 1월 1일부터 시행) - 317 : 동일 알파벳 군에서 접수된 성분 순으로 부여한 일련번호 - 05 : 동일 성분에 대하여 부여한 일련번호(단, 일련번호 ‘J’는 제외) - 괄호 : 20110531-71-B-317-05(1~9)에 해당하는 동일제조소, 동일성분에 대하여 허여서로 등록된 순으로 부여한 일련번호 [한약(생약)제제 관련] Q52. 한약(생약)제제 등에 해당하는 식물 유래 원료의약품 등록(DMF) 시 ‘벤조피렌’과 관련하여 제출하여야 하는 자료는 어떤 것이 있나요? - 79 - A. 한약(생약)제제 등에 해당하는 식물유래 원료의약품등록(DMF) 시 벤조피렌 관련 자료로 ‘시험성적서 3로트(시험기초자료 포함), 시험방법(시험법 밸리데이션 자료 포함), 노출안전역 평가자료, 벤조피렌 관리방안’에 대한 자료를 제출하여야 합니다. - 참고로, 식품의약품안전처에서는 GMP 평가 시 등록하고자 하는 원료의약품(실생산 로트)을 직접 수거하여, 제출한 ‘시험방법’에 따라 분석한 결과에 근거하여 노출안 전역(MOE)에 대해 재검증함을 알려드립니다. Q53. 국내 허가된 완제의약품 중 주성분이 “추출물 + 부형제”으로 허가되어 있으며, DMF 등록대상 원료의약품입니다. 이 경우, DMF 신청 시 부형제를 뺀 “추출물”로 DMF 등록이 가능한가요? A. 부형제를 함유한 추출물 형태의 성분과 부형제를 함유하지 않은 추출물 모두 DMF 등록 등록하여야 합니다. Q54. 한약(생약)제제 등에 해당하는 식물유래 원료의약품 등록(DMF) 시 제출자료 중 벤조피렌에 관한 자료에서 노출안전역(MOE)계산은 어떻게 하나요? A. 노출안전역(Margin of Exposure, MOE)은 NOAEL, BMD 등과 같이 독성이 관찰 되지 않는 기준값을 인제노출량으로 나눈 값으로서, 의약품의 벤조피렌 노출안전역 (MO



=== 비교표 (2nd occurrence) ===

 변경등록 및 변경보고 사항 비교표 <신청인> ○ 신청인의 성명, 제조(영업)소의 명칭 및 제조(영업)소의 소재지 변경은 변경보고 대상이나, 양도양수로 인한 신청인 변경은 변경등록 대상 <제조소에 관한 사항> 1. 제조소 명칭 및 소재지 ○ 제조소 이전으로 인한 제조소 소재지 변경은 변경등록 대상(필요시 실태조사) - ‘원료의약품 등록에 관한 규정’ 제4조의 자료 요건에 해당하는 자료 제출 - 18 - ○ 실제 제조장소의 변경이 없는 제조소의 명칭 및 행정구역 변경에 따른 소재지 변경은 변경 보고 대상(다음 자료 중 한 가지를 근거자료로 제출) - 제조소의 위치 변경 없는 상호변경의 경우, 해당국가의 공식기관에서 발급받은 문서와 제조소의 책임자가 서명하고 공증 받은 자료를 근거자료 제출 - 변경된 제조소 명칭 혹은 소재지로 발급받은 GMP 증명서 - 해당국가에서 행정구역 변경에 대하여 발급하는 문서(전자문서 등) - 인수합병에 의한 상호 변경은 단순 명칭변경으로 판단하여 변경보고 대상 2. 제조소 정보 ○ 제조소에 관한 사항 변경(제조소 책임자명 및 전자우편, 제조소 전화번호 등)은 변경보고 불필요 <제조·품질관리에 필요한 시설에 관한 자료> ○ 제조소내의 단순 Layout(제조설비, 시험장비 등) 변경은 변경등록 및 변경보고 대상에서 제외 ○ 동일 지번 내의 생산 장소(site)를 변경(신축, 증축, 공장동 이동)하는 경우에는 변경보고 대상 - site 변경을 확인할 수 있는 근거자료로 시설에 관한 자료(Site Master File 등) 제출 ○ 다만 제조방법의 변경을 수반하는 생산 장소(site) 변경일 경우 변경등록 대상 - 제조방법에 관한 자료 및 시험성적에 관한 자료, 시설에 관한 자료(Site Master File 등) 제출 <물리·화학적 특성에 관한 자료> 1. 구조결정에 관한 자료 ○ 화학구조를 입증하는 기기 분석에 관한 자료, 단순 오기 정정은 변경보고 대상(자료의 변경이 없는 최신 Batch 자료 업데이트는 보고 불필요) - 기기분석에 관한 자료 제출 2. 물리화학적 성질에 관한 자료 ○ 대한민국약전 또는 식품의약품안전처장이 인정하는 공정서 및 의약품집에 수재된 성분 (일반명, 화학명, CAS NO.)의 명칭 변경에 따른 변경은 변경보고 대상(한글 맞춤법 등 단순 오기 정정 포함) - 해당 공정서 또는 INN List 등 근거서류 제출 ○ 물리화학적 성질에 관한 자료 중 의약품의 성상 표기에 대한 가이드라인에 따른 표기 방법 - 19 - 변경은 변경보고 대상(예 : 백색 → 흰색) - 물리화학적 성질에 관한 자료 제출 ○ 물리화학적 성질에 관한 자료 중 유연물질에 관한 자료 변경(추가)은 변경등록 대상 - 유연물질 요약자료 및 그 검출 또는 분석법에 대한 자료 제출 ○ 자료의 변경이 없는 업데이트(문서개정 등)는 변경등록 또는 변경보고 불필요 <안정성에 관한 자료> ○ 원료의약품의 사용기간(재시험기간)을 변경하고자 하는 경우 변경등록 대상 - 3로트의 안정성시험 자료(1개 로트 근거자료 포함) ○ 최초 등록 신청 시 안정성시험계획서(stability protocol)을 제출하여 사용기간을 인정받아 공 고된 경우의 추가 안정성 시험자료는 변경보고 대상 - 안정성시험계획서에 따라 실시한 사용기간까지의 3로트 안정성 시험 자료(1로트 근거자료 포함) ○ 저장조건을 변경하고자 하는 경우 변경등록 대상 - 3개 로트의 안정성시험 자료(1개 로트 근거자료 포함) 제출 - 포장용기에 관한 자료(포장용기의 변경이 있는 경우) ○ 아래의 경우 변경등록 또는 변경보고 불필요 - ‘의약품등의 안정성시험기준’ [별표3]에 의한 방법(외삽)을 통해 인정받은 경우의 안정성 시험자료 업데이트 - 「의약품등의 안전에 관한 규칙」[별표1의2]에 따라 시판 후 안정성시험자료 업데이트 - 사용기간을 초과하는 안정성시험자료 업데이트 <제조방법, 포장, 용기, 취급상의 주의사항 등에 관한 자료> 1. 제조방법에 관한 자료 ○ 중요공정(발효공정을 포함한 핵심중간체 생성 공정 및 그 이후 공정)의 변경, 제조단위 규모 (10배 이상)를 변경하고자 하는 경우 변경등록 대상 - 제조방법에 관한 자료 - 변경 전후 동등성 입증자료(종전 batch와 새로운 batch의 불순물 profile의 통계적 분석자료, 물리화학적성질에 관한자료[UV, IR, X-선 회절 등]) - 시험성적에 관한 자료(3 배치, 단, 근거자료는 1배치) - 불순물에 대한 고찰 및 근거자료 - 20 - ※ 불순물 profile의 통계적 분석자료 : 종전 배치와 새로운 배치에서 기설정된 불순물의 실측 값의 변동성 및 새로운 불순물 생성 유무 확인을 위한 최소 3배치 자료. ○ 초기단계의 공정변경 등 핵심중간체 이전 공정이 변경되는 경우 변경보고 대상(단, 핵심 중간체가 동일하고 불순물의 정
…[truncated 2191 chars]

[CMD] cd "C:/Users/encep/AppData/Local/Temp/claude/D--workspace-DMF-Crawler/c00474d0-f118-4917-817d-1c16591aefc7/scratchpad" && python -c "import xlsxwriter, openpyxl, pandas; print('xlsxwriter', xlsxwriter.version, 'openpyxl', openpyxl.version, 'pandas', pandas.version)" 2>&1

xlsxwriter 3.2.1 openpyxl 3.1.5 pandas 2.2.3