Q[j%adZddlmZddlZddlZddlZddlZddlZddlZddl Z ddl Z ddl Z ddl Z ddl Z ddlmZddlmZmZmZddlmZddlmZmZddlZddlmZmZdd lmZmZmZmZm Z dd l!m"Z"eej#$d Z%e%d z Z&e%d z Z'e%dz Z(e%dz Z)e%dz Z*e*dz Z+e'dz e*dz e%dz dz dz gZ,dZ-ej.dz dz dz Z/dXdZ0dYdZ1hdZ2gdZ3eGdd Z4dZd"Z5d[d$Z6d\d(Z7d]d+Z8d^d-Z9d_d`d1Z:dad4Z;dbdcd8ZZ>d_dgd@Z?dhdidDZ@djdFZAe(dGz fdkdHZBe(dIz fdkdJZCe(dKz fdldMZDdmdNZEdndodPZFdndpdRZGdqdSZHdrdUZId[dVZJeKdWkr eJdSdS)sa'Health intelligence pipeline for JARVIS. Functions: - Parse the user-maintained lab reference XLSX. - Export 4-eyes correction workbooks. - Generate the current lab report in the desired pivot format. - Generate a simple HTML dashboard and daily/weekly markdown reports. - Apply reviewed correction XLSX files to the master DB. - Register local inbox files in the document table. This script deliberately keeps OCR/Docling extraction separate from final DB writes: newly extracted lab values should first go into laborwerte_staging and be reviewed. ) annotationsN) dataclass)datedatetime timedelta)Path)AnyIterable)Workbook load_workbook) AlignmentBorderFont PatternFillSide)get_column_letterz~/.hermes/assets/Gesundheitzhealth_data.dbinboxreports corrections attachmentsz$Laborwerte_Uebersicht_2021-2025.xlsxz!260510_Laborwerte_Uebersicht.xlsxbackup_originalzfriday.uplink@gmail.comz.hermessecretszgog_keyring.envreturnstrcltjdd}|r|Stst dttjdzrt dtt d D]}|}|r| dr.| d r|d d}| d \}}}|rX|dkr@|d d }|r|cSt dt)NGOG_KEYRING_PASSWORDz-Missing gog keyring secret environment file: ?z/Unsafe permissions on gog keyring secret file: utf-8encoding#zexport ="'z GOG_KEYRING_PASSWORD missing in ) osenvirongetstripGOG_SECRET_ENVis_file RuntimeErrorstatst_mode read_text splitlines startswith partition)valueraw_linelinekeysep raw_valuesecrets @/home/agent/.hermes/assets/Gesundheit/scripts/health_pipeline.pyload_gog_keyring_passwordr<6s JNN12 6 6 < < > >E   ! ! # #][>[[\\\$u,_]^]]^^^",,g,>>IIKK  ~~ ts++   ??9 % % $8>>##D"nnS11S)  399;;"888__&&,,S1177< Entzündung Hämatologie SchilddrüseAuto-Antikörper gegenSchilddrüse & Hormone Leber & NiereBlutstatus LeukSpezielle GerinnungInfektion / AutoimmunElektrolyte & VitamineImmunologie / InfektionBlutfette & StoffwechselBlutbild automatisch absolutVirale Hepatitiden A,B,C,D,EUrinHormoneProteine Gerinnung Sonstiges Blutabnahmen)status kategorieparameter_namewert_extrahiertwert_korrigiert wert_finaleinheitreferenzbereich abnahme_datum befund_datumflag confidencequelle dokument_id kommentarcPeZdZUded<ded<ded<ded<ded<dZded <dS) LabValuercategory parameter str | None referencerr4Nunit)__name__ __module__ __qualname____annotations__rnrCr=r;riridsSMMMNNN IIIJJJDr=risqlite3.ConnectioncZtjt}tj|_|SN)sqlite3connectDBRow row_factory)cs r;connr|nsAKAM Hr=NonecnttttfD]}|dddS)NT)parentsexist_ok)REPORTS CORRECTIONSINBOX ATTACHMENTSmkdir)ps r; ensure_dirsrts={E; 7-- t,,,,--r=r4r rlcx||dkrdSt|tr&|St|tr|St |}dD]M} tj||cS#t$rYJwxYwtj d|}|rC| dd| dd| dS|S)Nr)%Y-%m-%dz%d.%m.%Yz%d.%m.%yz%Y/%m/%dz#(20\d{2})[-_.]?(\d{2})[-_.]?(\d{2})-) isinstancerr isoformatrr*strptime ValueErrorresearchgroup)r4textfmtms r;normalize_daterys7 } t%""(zz||%%'''%!   u::    D? $T3//4466@@BB B B B    D  8$??A9''!**88qwwqzz88AGGAJJ888 Ks8C CCref)tuple[str | None, str | None, str | None]c|sdSt|}d}tjd|}tjd|}|r'|d}d|vrLt |dkr9|ddd |ddd |fS|d r!|rd|ddd |fS|d r!|r|ddd d|fSdd|fS) NNNNz[-+]?\d+(?:[.,]\d+)?u1(?:\d|[<>])\s*([A-Za-zµ%/][A-Za-z0-9µ/%^ .-]*)$rrrr,.<>) rr*rfindallrrlenreplacer2)rrrnnumsm_units r;split_referencersN   s88>>  D D :-t 4 4D YKT R RF '||A$$&& d{{s4yyA~~AwsC(($q'//#s*C*CTII zz||s##55T!W__S#..44 zz||s##55AwsC(($44 t r=rc`dtD}|stSdd}t||S) Nc:g|]}||SrC)exists).0rs r; z'best_reference_xlsx..s%>>>a188::>>>>r=rrrtuple[int, float]c t|dd}||jd}t|jpd|jfS#t $rd|jfcYSwxYw)NFT) read_only data_onlyr)r sheetnamesint max_columnr.st_mtime Exception)rwbwss r;scorez"best_reference_xlsx..scores *qETBBBBBM!$%B *++QVVXX->? ? * * *qvvxx() ) ) ) *sAA%A>=A>r7)rrrr)REFERENCE_CANDIDATESREFERENCE_XLSXmax)existingrs r;best_reference_xlsxrsM>>/>>>H **** xU # # ##r=path Path | Nonelist[LabValue]c |t}|st|t|d}||jdi}t djdzD]1}td|j }|r|||<2g}d}t dj dzD]dj }|%t| dkrFt| }fd |D} dj } |tvr| s| s|}| st| rt| nd\} } } |D]\}}|j } | %t|  dkrH|t#||| r!t|  nd|t|  | |S) NTrrrrrWrrcg|]:}|jdv|j;S)Nr)cellr4)rr{rowrs r;rz(parse_reference_xlsx..sD q q q1QTVWI^fpIpIpa!6IpIpIpr=)rrFileNotFoundErrorr rrangerrrr4max_rowrr*CATEGORY_NAMESritemsappendri)rrdatescoldvaluesrjnamename_snon_empty_date_valuesr_rnvalrrs @@r;parse_reference_xlsxrsV |"$$ ;;==&%%% tt , , ,B BM!  BEQ )** 2771c??0 1 1  E#JFHQ Q''ttwwsA$ <3t99??,,22 T"" q q q q q q q qggc1oo# ^ # #C #8M #H $  $%>SXXX$?? 1dkkmm t tFC''#s##)C{c#hhnn.."44 MM(8V5VSXX^^5E5E5ERVXY[^_b[c[c[i[i[k[kmqrr s s s s  t Mr=r\tuple[list[str], list[str], dict[tuple[str, str], LabValue], dict[str, str], dict[str, str]]c.td|D}ii}i}|D]8}|j|j<|jr|j||j<|||j|jf<9dt t Dtfd}||||fS)Nch|] }|j SrC)r)rvs r; z!get_lab_matrix..s+++qAF+++r=ci|]\}}|| SrCrC)rir{s r; z"get_lab_matrix..s 8 8 8daQ 8 8 8r=c|dd|d|fS)NrWir)r)lower)rcatsorders r;z get_lab_matrix..sJ488A{3K3KS)Q)QSWS[S[\]_aSbSbdedkdkdmdm(nr=r)sortedrjrkrmr enumerater)rrrefsmatrixrparamsrrs @@r;get_lab_matrixrs ++F+++ , ,EDD.0F **JQ[ ; , ! D () QV$%% 8 8i77 8 8 8E Dnnnnn o o oF &&$ ,,r=C2rfreezec ||_|j|j_t d|jdzD]}t |}d}t dt|jddzD]Z}| ||j }|;t|tdtt|dz}[||j|_dS)Nr P-r) freeze_panes dimensions auto_filterrrrrminrrr4rrrcolumn_dimensionswidth)rrrlettermax_lenrrs r; style_sheetrsBOBNQ )**55"3''C B//!344 C CC''#s##)Cgs2s3s88}}q/@'A'ABB-4V$**55r=zaktuelle_blutwerte.xlsxoutputsourcec jtt|}t|\}}}}t}|j}d|_t dd} tdd} t dd} tdd} td td D} | d d g|z|d D]-}| |_ | |_ tdd|_| |_.d}d}|D]|d}||kr| |gdgt#|d zzz||d |t#|dz||d }| |_ | |_ | |_|}|d z }| |dgfd|Dz||D],}| |_t|jdkrdndd|_-|d z }d|jd_d|jd_tdt#|dzD]!}d|jt/|_"t1||||S)NzAktuelle Blutwertesolid1F4E78fgColorFFFFFFTcolorboldD9EAF7c38K|]}tddVdS)thinBFBFBF)stylerN)r)rrs r; z&generate_lab_report..s/KKQdx888KKKKKKr= ParameterReferenzbereichrcenter) horizontal wrap_textrrW) start_row start_columnend_row end_columnrczg|]7}|fr|fjnd8Sru)r)r4)rrrrs r;rz'generate_lab_report..sK)r)r)rghfjjRSUVQWFXFX*b&**aV*<*<*B*B^b)r)r)rr=left*ABr )rrrr activetitlerrrrrfillfontr alignmentborderr)r merge_cellsrcolumnrrrrsave)rrrrrrrrr header_fill header_fontcat_fillcat_fontr rr current_catcatr{rrrs @@r;generate_lab_reportr*sMMM !& ) )F(6v(>(>%E664 B B#BHgx888KXD111K7H555H(...H KK%((KKK LFII{-.67771PP [9`htxKyKyKy$.JP{|G|G CK   hhq+&& +   IIsetfE Q77 8 8 8 NNSq#RUV[R\R\]^R^N _ _ _QA(XAFRXqxKsaxs 1dhhq"oo&)r)r)r)r)rlq)r)r)rrsssC x xAAHYahYZll((`frv-w-w-wq{{ q&(B#&(B#QE 1 %%@@=?.s334::OOOGGFOOO Mr=batch_idct|s)dtjdz}|td|dz }t }|j}d|_|tt}g} t| d|f}| n#| wxYw|r|D]}|dp|d p|d }||d |d |d |d |d ||d|d|d|d|d|d|d|d|dgnn|p t} t| D]N} |d| j| j| jd| j| j| j| jddd| jddgOt/dd} t1dd} |d D]} | | _| | _t7|d!"|||S)#zExport a review workbook. If batch_id exists in staging, export it; otherwise export reference XLSX as initial validated review. reference_z %Y%m%d_%H%M%SNKORREKTUR_Laborwerte_.xlsxLaborwerte_KorrekturzcSELECT * FROM laborwerte_staging WHERE batch_id=? ORDER BY kategorie, parameter_name, abnahme_datumr^r]r\rYrZr[r_r`rarbrcrdrerfrg validiertg?z Referenz-XLSXr7030A0rrTrrA2)r)rrnowstrftimerr rrrREVIEW_HEADERSr|listexecutecloserrrjrkr4rnrmrrrrrrrr#)r+rrrrr{rowsrfinal source_pathrr$r%rs r;export_correction_xlsxr>s3MMM K(,.."9"9/"J"JJ ~FxFFFF B B%BHIIn A DAIIDGOFQRRSS    m S SAlOSq):';SqAR?SE IIq{AkNA6F4GK\I]_`ar_suz|}H}IKLM^K_abcrasuvwEuFHIJPHQSTUaSbdefndoqrs@qACDEPCQR S S S S S5 3 5 5 %k22 m mA II{AJ QWdAGUVU[]^]hjkjprvx|BDODTVZ\kl m m m mgx888KXD111K199 [4    GGFOOO Ms $C C rcdt|d}||jd}d|dD}dt|D}hd}|t|ks"t d|t|z t }d}t jd } td |j dzD]} t| | | d djpd } | d vrj| | |dj} | | |djp4| | | d|dj} t#| | |dj}| r| dvs|s| dr/| | | ddjnd}| dr/| | | ddjnd}t%|rt|nd\}}}| dr/| | | ddjn|j}|dt| ||f}|rQ|dt| ||||rt|ndt||| |df np|dt| t| t| |||||rt|nd| || ddt||f |dz }||n#|wxYw|S)zNRead reviewed correction workbook and upsert validated values into laborwerte.Trrclg|]1}|j&t|jnd2Sr)r4rr*)rr{s r;rz%apply_corrections..8s8RRRqqw':s17||!!###RRRr=rc i|] \}}||dz S)rrC)rrhs r;rz%apply_corrections..9s" 3 3 311a!e 3 3 3r=>r^rar[zMissing required columns: z%Y-%m-%d %H:%M:%SrrYr1> gelöschtreject abgelehnt geloeschtr[r^r]rarr_Nr`rezmSELECT id FROM laborwerte WHERE parameter_name=? AND abnahme_datum=? AND COALESCE(einheit,'')=COALESCE(?, '')zUPDATE laborwerte SET wert=?, wert_original=COALESCE(wert_original, wert), einheit=?, reference_min=?, reference_max=?, bemerking=?, quelle=?, validierungsstatus='validiert', review_batch_id=?, befund_datum=COALESCE(befund_datum, ?) WHERE id=?ida.INSERT INTO laborwerte (parameter_name, wert, wert_original, einheit, reference_min, reference_max, einheiten, bemerking, ermittlung_datum, abnahme_datum, befund_datum, quelle, validierungsstatus, review_batch_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'validiert', ?)r)r rrsetrr|rr4r5rrrrr)r4r*rrrrr8fetchonecommitr9)rr+rrheadersidxrequiredr{countr4rrYparamr4abnahmer_rrminrmaxrrers r;apply_correctionsrS4s~ tt , , ,B BM!  BRRBqERRRG 3 3 ' 2 2 3 3 3C@@@H s3xx  KhS6IKKLLL A E ,.. ! !"5 6 6CBJN++  Ccggh&:&:;;AP[QQWWYY__aaFJJJGGC%5!677=EGGC\!2339~RWWS#''RcehiuevJwJw=x=x=~E$RWWS#o2F%G%G%MNNG EZ//w/CF779CUCU_bggc3779a#8#899??[_GGJwwO`GaGak"''#sww'8!<<==CCgkC+,ECHHHFFMD$ADARARaRWWS#''(A"6"677==X\XaFyy"QTWX]T^T^`gipSqrr{{}}H h Tu::wd0documents_with_textUSELECT count(*) FROM laborwerte_staging WHERE status IN ('zur_pruefung','extrahiert') open_reviews)r|r8rIr9)r{outtables r; db_countsrhes A Q R RE#B5#B#BCCLLNNqQCJJ%&YY0G&H&H&Q&Q&S&STU&V !"ii(AAJJLLMNON   s BCCzhealth_dashboard.htmlc~ddl}tdz dz }|jtjt |gd|S)aGenerate dashboard via robust v3 renderer. The previous inline Chart.js annotation-plugin implementation failed silently in some browsers/CDN states, leaving only titles/reference text visible. v3 uses plain Chart.js datasets for lines/reference bands/event markers. rNscriptszhealth_dashboard_v3.pyTcheck subprocessBASErunsys executablerrrnscripts r;generate_dashboardrursI I  8 8FJNCNCKK0==== Mr=zhealth_dashboard_v4.htmlcddl}tdz dz }|jtjt |dt |gd|S)z?Generate the complete mobile and privacy-hardened dashboard v4.rNrjzhealth_dashboard_v4.py--outputTrkrmrss r;generate_dashboard_v4rxsR I  8 8FJNCNCKKS[[IQUVVVV Mr=zhealth_dashboard_v5.htmldbc ddl}tdz dz }|jtjt |dt |dt |gd|S) z@Generate the parallel Dashboard v5 preview without replacing v4.rNrjzhealth_dashboard_v5.py--dbrwTrkrm)ryrrnrts r;generate_dashboard_v5r|si  I  8 8FJN Vfc"ggz3v;;O Mr=ctdz dz }tjtjt |dt |gddS)zURefresh aggregate-only exploratory correlations for the explicitly selected database.rjzmultimodal_correlations.pyr{TrkN)rornrprqrrr)ryrts r; generate_multimodal_correlationsr~sD I  < .s%^%^%^UV%\!J-*E:%\%\>IZ%\%\z{}F{GaO`vhijsht`v`v`vMO&P%^%^%^r=z ## Symptomec<g|]}d|dd|dpddS)rsymptomz ( schwergradzn/a)rCrs r;rz)generate_daily_report..s:"a"a"aXY#S) #S#S,8P5#S#S#S"a"a"ar=z## Tagebuch / Gesundheitsdatenc Lg|]!}d|dd|dd|dpd"S)rkategorirtitelu — inhaltrrCrs r;rz)generate_daily_report..sG5}5}5}uv6p1Z=6p6pAgJ6p6p]^_g]h]nln6p6p5}5}5}r=)u## Nächste sinnvolle Schritteu1- Offene Korrektur-XLSX prüfen, falls vorhanden.zM- Bei neuen Labor-/Befunddokumenten Verarbeitung abwarten und Freigabe geben. rr fINSERT INTO report_runs(report_type, period_start, period_end, output_path, summary) VALUES(?,?,?,?,?)dailyzTagesbericht generiert)rrtodayrrr|r7r8r9any write_textjoinrrJ)rrr{erntbsymliness r;generate_daily_reportrsMMM )''))C  @w!@!@!@!@@F A199ux{w}~~ !))jmplrss t t199psvrxyyzz   3c 3 3R 8E R~  E CDD c /c%^%^Z]%^%^%^c`bc c g -f"a"a]`"a"a"afceff C 2C5}5}z|5}5}5}C@BC C vvvvE dii&&999 A CFMORTWY\]cYdYdf~E@@@BCBJBJBLBLBLNONUNUNWNWNW Ms A,CC,end_dayct|r'tj|dntj}|t dz }|p4t d|d|dz }t} | d||f d}| d ||f d}| d ||f d}| d  d}| n#| wxYwd |d |ddd|d|d|d|ddddddddg} | d | dt}| dd||t|df|| |S) Nr)daysweekly_health_report_rrzGSELECT count(*) FROM dokumente WHERE date(upload_datum) BETWEEN ? AND ?rz;SELECT count(*) FROM ernaehrung WHERE datum BETWEEN ? AND ?z9SELECT count(*) FROM symptome WHERE datum BETWEEN ? AND ?rdu# Wochenbericht Gesundheit — z bis rz## Zusammenfassungz- Neue/registrierte Dokumente: u- Ernährungseinträge: u- Symptomeinträge: z- Offene Labor-Korrekturen: u## Einschätzunguu- Korrelationen werden belastbarer, sobald YAZIO-/Wearable-Daten täglich vollständig und Laborwerte validiert sind.u- Auffälligkeiten sollten als Musterhinweise verstanden und bei medizinischer Relevanz mit Ärztinnen/Ärzten besprochen werden.z## Offene Aktionenz<- Dokumente ohne Volltext weiter mit Docling nachbearbeiten.uB- Korrektur-XLSX prüfen und danach Freigabe zur Übernahme geben.rrr rweeklyzWochenbericht generiert)rrrrrrrrr|r8rIr9rrrrJ) rrendstartr{docsrrreviewsrs r;generate_weekly_reportrsMMM;B T( GZ 0 0 5 5 7 7 7 C )### #E  aw!a9J9J!a!aS]]__!a!a!aaF Ayybejetetevevx{yFyFyHyHeIJJSSUUVWXiiUX]XgXgXiXiknkxkxkzkzW{||FFHHIJKiiSV[VeVeVgVgilivivixixUyzzDDFFGHI))stt}}ABC   S%//*;*;SS#--//SSUWFFFHhcfHhHhkGBEkGkGIqhoIqIqsuTVY[]\_c  E  dii&&999 A CFNPUP_P_PaPacfcpcpcrcrtwx~ttAZE[\\\^_^f^f^h^h^hjkjqjqjsjsjs Ms $D)G""G8c tt}d} tD]P}|r|jdr2|j}|dvrP|dvrdnd}|dkrd}|jtfdd Drd ntfd d Drd nd}| dt||jf }|r| d|jt||t|jdz d|ddf|dz }R||n#|wxYw|S)Nrr>.pdf.jpg.png.jpegr/>rrrimagepdfr/c3 K|]}|vV dSrurCrxname_ls r;r z'register_inbox_files..s'%k%kaa6k%k%k%k%k%k%kr=)laborblutchemiehaematuhämatLABORc3 K|]}|vV dSrurCrs r;r z'register_inbox_files..s[BbBbSTCDHNCNBbBbBbBbBbBbr=)befundberichtmrict ultraschalluröntgenroentgenBEFUNDE SONSTIGESz:SELECT id FROM dokumente WHERE dateipfad=? OR datei_name=?zINSERT INTO dokumente(datei_name,dateipfad,daten_typ,groessekbytes,status,kategorie,quelle,review_status) VALUES(?,?,?,?,?,?,?,?)ineurnicht_geprueftr)rr|riterdirr,rr2suffixrrr8rrIrr.st_sizerJr9)r{rNrext data_typerjrrs @r;register_inbox_filesrsMMM A E  A99;; !&"3"3C"8"8 (..""CDDD#&*C#C#CIg~~! V\\^^F"%%k%k%k%k;j%k%k%k"k"kswwBBbBbBbBbXaBbBbBbbbrsqzqzhsHYY[^abc^d^dfgfl]mnnwwyyF  IIZvs1vvy#affhh6Ft6K2L2LeU]_fhxy { { { QJEE     Ls E?F55G  parent_idc ddtddt|d|ddg }tj|t d } t j|}|d p<|d id p|S#t$r|cYSwxYw) Ngogz-adriveupload--parentz--jsonz --no-inputT)envrrGfile) ACCOUNTrrn check_outputrDjsonloadsr)r*r)rrcmdrfdatas r; gog_uploadrs $(CIIz9V^`l mC  !#7994 @ @ @Cz#xx~~N&"!5!5!9!9$!?!?N399;;N yy{{sA%B))C  C cRtj}|dd}|d|d}|d|d|d}|d |d|d |d |d }|d t d|d}|d t d|d}|d|d}|d|d|d}|d|dd|} | jdkrttdS| jdkr?tt| j | j rt | j nddS| jdkr9tdtt | j| j dS| jd krttdS| jd krtt!dS| jd kr#tt#| jdS| jdkrt'| jdS| jdkr#tt)| jdS| jdkr#tt-| jdS| jdkr tdt1dS| jdkr6tt3t | j| jdSdS)NrT)destrMzgenerate-lab-reportzexport-correctionz --batch-idrwzapply-correctionsxlsx dashboardz dashboard-v4z dashboard-v5r{)typerM correlationsz daily-reportz--datez weekly-reportz --end-datezregister-inboxrrr)rMu Übernommen: z Registriert: )argparseArgumentParseradd_subparsers add_parser add_argumentr parse_argsrprintr*r>r+rrSrrurxr|ryr~rrrend_daterrrparent) apsubp_corrp_applyp_dashboard_v5p_correlationsp_dayp_weekp_uploadargss r;mainrs  " "B    6 6CNN())) ^^/ 0 0F&2E2El2S2S2SU[UhUhisUtUtUtnn011G73G3G3O3O3OQXQeQefrQsQsQsNN;NN>"""^^N33NTDAAA^^N33NTDAAA NN> * *EE,>,>x,H,H,H ^^O , ,Ff.A.A,.O.O.ONN#$$$~~h''H)>)>v)F)F)FH]H]^hswH]HxHxHx ==??D x((( !##$$$$$ ( ( ( $T]4^D4E4E4EZ^__````` ( ( ( Q/TYOOQQRRRRR [   ""##### ^ # # #%%&&&&& ^ # # #DG,,----- ^ # #(11111 ^ # # #DI..///// _ $ $ $T]3344444 % % % 62446677777 X   jdi$+6677777  r=__main__)rr)rr>)rrs)rr})r4r rrl)rrlrr)rrru)rrrr)rrrr)r)rr rrrr})rrrrrrr)r+rlrrrrrr)rrr+rlrr)rT)rUrrrV)rrY)rrrr)ryrrrrr)ryrrr})NN)rrlrrrr)rrlrrrr)rr)rrrrrr)L__doc__ __future__rrcsvhtmlrr'rshutilrvrnrquuid dataclassesrrrrpathlibrtypingr r openpyxlr r openpyxl.stylesr rrrropenpyxl.utilsrr expanduserrorxrrrrrrrrBr+r<rDrr6rir|rrrrrrrr*r>rSrXrhrurxr|r~rrrrrrorCr=r;rs  #"""""  !!!!!!.......... ,,,,,,,,FFFFFFFFFFFFFF,,,,,, tBG  < = =>>  w  ]" ]" EE //88 },/UU $y(947HHLLLL,      ---- && $ $ $ $!!!!!H - - - - 5 5 5 5 5(/1J'Jbf"""""JD&&&&&R    '.0G&G     *13M)M77     OOOO 408'8'8'8'8T zDFFFFFr=