6lj#SrSSKJr SSKrSSKJr SSKJr SSKJ r J r J r J r SSK r SSKJr SSKJrJr SS KJr /S QrS rS rS r"SS\5rSSjrSSjrSSjrSSjrSSjrSSjrSSjr g)uWhat a batch exports: one row per question, as a workbook or as text. The two writers share the row building and nothing else, because each writes a different thing. A workbook cell carries its own type and number format, so the printed figure is a text cell nothing reformats and a percentage arrives as the fraction under a percent format, displaying at the printed scale. A text file encodes what it can in the characters: the printed column is quoted, the numeric column is not, and a percentage keeps its percent sign for the importer to divide. Both land the same value in the same cell; they need different bytes to get there. Every figure is written twice, as printed and as a number. Both are read off the answer — `value` and the derived `number` — and nothing here parses a printed figure. `answers/figures.py` is the one place that does, and the two sign-flipping defects that motivated that rule were both written by an export re-deriving what the answer already carried. A question with no answer is a third kind of row, distinct from a figure and from a failure: a sentinel in the printed column, an empty numeric column, and the model's explanation in the note. Formula injection is handled structurally. Workbook text cells are typed as text, so a question beginning with `=` is characters. In the CSV the free-text columns are prefixed, and only those — a printed figure is never prefixed, because that column has to match the filing byte for byte. ) annotationsN)Decimal)BytesIO)AnyDictListOptional) BaseModel) is_percent norm_printed)RunState) questionz as printednumberunitperiodpagez cited idszsource cell textstatusnotez review flagerrorz #not found#reviewz; c\rSrSr%SrS\S'SrS\S'SrS\S 'S rS \S 'S r S \S 'Sr S\S'Sr S\S'Sr S\S'Sr S\S'SrS\S'SrS\S'SrS\S'S rS \S'SrS\S'Srg) ExportRowHzCOne question's row, typed for the writers rather than for a reader.strrprintedNzOptional[Decimal]rFboolpercentfigurerrpages cited_ids cell_textrrrr)__name__ __module__ __qualname____firstlineno____doc____annotations__rrrrrrr r!r"rrrr__static_attributes__r#5/home/mande/repo/quber/src/quber/playground/export.pyrrHsMMGS $F $GTFDD#NFCE3OIsIsFCD#NFDE3Or+rcURVs/sH.n[URURUR5PM0 sn$s snf)N)rows _build_rowrrresponse)staterows r, build_rowsr3]s3IN T#Js||SYY = TT Ts5AcUc[X=(d SS9$[US9nURS5=(d /nURS5=(d 0nURS5nUS:XaURS5=(d SUlS Ul[ UR5UlURS 5nUb [ U5OSUlURS 5=(d SUlURS 5=(d SUl OUS :Xa+[UlURS5=(d SUl O_US:Xa URS5=(d SUlO9[R"USS9UlURS 5=(d SUl/nUH5n [U RS55n X;dM$URU 5 M7 [ R#U5Ul[ R#SU55Ul[ R#SU55Ul[ R#SU55UlUV s/sHoRS5(dMU SPM! n n U (a;[ R#UR(a UR/O/U -5Ul [-SU55UlU$s sn f)Nfailed)rr)r referencesvalueshapescalarrTrrr unanswerablereasonprosetext),:) separatorsrc3D# UHoRSS5v M g7f)ref_idrNget.0rs r, _build_row..sADquuXr22Ds c3Z# UH!oRS5(dMUSv M# g7f)r=NrCrEs r,rHrIsH$Q%%-yqy$+ +c3Z# UH!oRS5(dMUSv M# g7f)rNrCrEs r,rHrIsIAxKAhKrKrc3B# UHoRS5v M g7f)flaggedNrCrEs r,rHrIs4t!UU9%%ts)rrDrrr rrrrrNOT_IN_DOCUMENTrjsondumpsrappend_JOINjoinr r!r"ranyr) rrr0r2refspayloadkind serialized seen_pagesrefrrGnotess r,r/r/as/(2C8DD X &C << % +Dll7#)rG << D xkk'*0b   - [[* ,6,BWZ( ;;v&,"[[*0b  % ;;x(.B kk&)/R jjZ@ ;;v&,"J3776?#  !   d # :&CIJJADAACMJJH$HHCMIIICJ $ 61f YQvYE 6 ::SXXz2FG4t44CJ J 7s K : K c[U5RS5R5nSU;a[UR S5S5OSnU(a SSU-S3$S$)zA percent format with as many decimals as the figure was printed with, so `6.7 %` shows as 6.7% rather than being padded to 6.70%.%.rz0.0z0%)r rstripstriplensplit)rdigitsplacess r,percent_formatrhs\' " ) )# . 4 4 6F*--Sc"1% &QF#)Rf ~Q 3t3r+c [R"5nURnUceSUlUR [ 5 [ [U5SS9GHFup4URURURURURURURURUR UR"(a[$OSUR&S. nUR)5H+upgUS:XaM UR+X6US9nSUlSUlM- UR0cMUR+US UR2(aUR0S - O UR0S9n UR2(dGM,[5UR5U lGMI [75n UR9U 5 U R;5$) uSThe workbook. Text cells are typed as text — nothing reformats the printed figure and a leading `=` is characters. A percentage's numeric cell holds the fraction under a percent format, so it computes as a rate and displays as the document printed it; the writer picks a value and a format and performs no arithmetic beyond that rescale.batch)startr) r`rk )r2columnr7s@d)openpyxlWorkbookactivetitlerRCOLUMNS enumerater3rrrrr r!r"rrrREVIEWritemscell data_type number_formatrrrhrsavegetvalue) r1wbwsrGr2textscolr7rnumouts r, write_xlsxrs[    B B >>BHIIgJu-Q7||{{xxzzyy}}}}zz**"    ++-JC{77qE7:D DN!$D ( :: !''aS[[c1AVYV`V`'aC{{{$23;;$?!384 )CGGCL <<>r+c2SURSS5-S-$)N"z"")replacerws r,_quoters 3% % ++r+c4USSS;aSU-n[U5$)zA free-text cell: prefixed when it begins with a formula character, then quoted. The prefix is the injection guard; the quotes are what keeps the text as typed when the importer treats quoted fields as text.Nr`)=+-rx')rrs r, _free_textrs& !u$$ !G !9r+cXSR[5/n[U5GHqnURcSnO6UR(aURS3nO[ UR5nUR SR[UR5UR(a[UR5O[UR5U[UR5[UR5[UR5[UR5[UR 5[UR"5[UR$5UR&(a[(OS[UR*5/ 55 GMt SRU5S-$)uThe same rows as text. The printed column is quoted and never prefixed; the numeric column is bare, and a percentage keeps its percent sign so the importer stores the fraction under a percent format — the same cell the workbook writes directly.r>rr^z )rTrr3rrrrRrrrrrrrr r!r"rrrrr)r1linesr2rs r, write_csvrs! XXg  E%  :: F [[ |1%F_F HHs||,+.::F3;;':ckk;Rsxx(szz*399%3==)s}}-3::&sxx(!jjFbsyy)   !2 ;;u  &&r+)r1r returnzList[ExportRow])rrrz Optional[str]r0zOptional[Dict[str, Any]]rr)rrrr)r1r rbytes)rwrrr)r1r rr)!r( __future__rrPdecimalriortypingrrrr r{pydanticr quber.playground.answers.figuresr r quber.playground.batchr rrOrrSrr3r/rhrrrrr#r+r,rsv6# ,,E+ ,    *U.b4'T,'r+