̣%j(dZddlmZddlZddlmZeejjZ e dz Z e dz Z e dz Z gdZ d Zd Zgd Zdd Zdd ZddZddZddZddZddZddZddZddZedk(reyy) zSDerive capacity_timeseries.csv and company_gw_chart.html from forecast_vintage.csv.) annotationsN)Pathzforecast_vintage.csvzcapacity_timeseries.csvzcompany_gw_chart.html) z FY2024-FQ1z FY2024-FQ2z FY2024-FQ3 FY2024-FQ4z FY2025-FQ1z FY2025-FQ2z FY2025-FQ3 FY2025-FQ4z FY2026-FQ1rFY2026 companytickerfiscal_quarter actual_gwlatest_forecast_gworiginal_forecast_gwunder_construction_gwcapex_actual_usd_bcapex_guidance_latest_usd_bcapex_guidance_original_usd_bcapex_actual_metriccapex_actual_is_derivedcaveatc`t|dd}t|jdd}||fS)Nz-FQ)intsplit)pfyfqs m/home/dev/research_loop/runs/gw-forecast-production-001-loop06/artifacts/production/GOOGL/build_timeseries.py period_keyr .s1 QqVB QWWU^A  B 8Octjd5}ttj|cdddS#1swYyxYw)Nutf-8encoding)VINTAGEopenlistcsv DictReader)fs r load_vintager,4s8 w ''1CNN1%&'''s ?Acg}|D]:}|ddk(s |dtk(s|j|dt|df<t|dS)N metric_namecapex_guidance target_period as_of_period raw_valuect|dS)Nr)r )xs rz#guidance_vintages..AsZ!%5r!)key)GUIDANCE_TARGETappendfloatsorted)rowsoutrows rguidance_vintagesr>9sc#%CG  "2 2O$7 JJN+U3{3C-DE F G #5 66r!c|t|k(rtt|S|djdjdS)Nz.3f0.)rstrrstrip)values r fmt_usd_brEDs< E 3u:C[  % , ,S 11r!cht|}d}|D]\}}t||kst|}!|S)N)r rE)quartervintagesqklatestperiodrDs rguidance_as_ofrMJsB G B F!&  f  #u%F& Mr!cbt|ttkry|syt|ddS)NrGrr)r GUIDANCE_ORIGIN_QUARTERrE)rHrIs roriginal_guidance_as_ofrPSs1'Z(?@@  Xa[^ $$r!c,|D])}|d|k(s |ddk(s|d|k(s|dd|dfcS|dk(r.|D])}|d|k(s |ddk(s|ddk(s|dd |dfcS|d k(r.|D])}|d|k(s |ddk(s|dd k(s|dd|dfcSy ) Nr1r. capex_actualr0r2 is_derivedrFY2024capex_actual_fyr)rGrGrG)rHr;r=s rcapex_actual_for_quarterrW[s G  7 *M"n4O$/{#^S5FF F G, NCN#w. &.8(H4;'):C r7rOQUARTERSrWr8rMrP)r;guidancerr<rHcapexmetricderiveds rbuild_timeseriesr`ys &H S  >?V>WW_ a !#C !9'4!Hvw %!")&((*)+&+/=gx/P1HRZ1['-+2    & Jr!c|Dcgc]}|d c}|Dcgc]}|drt|dnd}}|Dcgc]}|drt|dnd}}|Dcgc]}|drt|dnd}}t||Dcgc]\}}|ddk(rdn|}}}tdt|Dd}d\}} } |z | z z | z c||z|zDcgc]}|| } }|||| j ||| rt | d znd d d;fd d<fd d=fd } d} |R||M|||}}d|dd|dz dd|dzdd|dd|dd|dzdd|dz dd|dd|dd|dz dd} g}dkrdndkrdnd}t d tdz|D]O}|}|j dd |dd!|| z d"|dd# |j d$d%z d|d&zdd'|d(Qdjfd)tD}djgd*|d+d,|dd-dd.d+d/dj|d0d1z zd2dd3z d4d1z zd2d5| |d6d7| |d8d7| |d9d7| d7|d:Scc}wcc}wcc}wcc}wcc}}wcc}w)>Nr rrrrrUc38K|]\}}|ddk(s|yw)rrUNrV).0irs r zsvg_chart..s"Xtq!!,A*BFW*WXs)iiFrgZg?rcF|ttdz dz zzS)Nr)maxlen)rdlabelsmlpws rr4zsvg_chart..xs'QS[1_a00B666r!c,z|z z z zz S)NrV)vmtphymaxymins ryzsvg_chart..ys$Bw1t8t 4:::r!cg}t|D],\}}| |j|dd|d.t|dkryd|ddj|dS) N.1f,rrGz) enumerater8rmjoin)valscolorptsrdrrr4rws rpolylinezsvg_chart..polylines|dO 5DAq} ad3Zq1c 34 5 s8a</w6STWT\T\]`TaSbbeffr!rGzFY2024 annual2 drz c 3pK|]-\}}d|dddz d|dddz d|d /yw) rryrrzH" text-anchor="end" font-size="10" fill="#374151" transform="rotate(-35 r{z)">rNrV)rcrdlabhr4s rrfzsvg_chart..s[ As AaD:U1R4&)!!"1c !AbD6SE Bs36u GOOGL — Capex Actual vs FY2026 Guidance Vintages (GW Proxy)

Alphabet (GOOGL) — Infrastructure Spend Proxy: Actual vs Guidance

z Fiscal quarter (as-of) USD billions (capex proxy) z#2563ebz z#16a34az#dc2626a��
Capex actual (quarterly proxy) FY2024 full-year actual (annual anchor) Latest FY2026 capex guidance vintage (as-of) Original FY2026 capex guidance (~$180B midpoint, from FY2025-FQ4)
)rdrreturnr9)rrr9rr9)r~zlist[float | None]rrBrrB) r9zipnextr|r8rlrangerr})r;re raw_actualrKoriginalrrquarterly_actualannual_anchor_idxwmrmball_valsr annual_markeraxaygridsteptickyyxlabelsrrnrorsrtrpr4rwrurvs @@@@@@@@@@r svg_chartrs +/ 0aa ! 0F_cdZ[A6J4K%./0QUUdJdmq rhi;X9YeA345_cc rF r 677V5Wa/01]aaHj) Aq'(,==1DXyX  4Aq"b"b Vb[!b&2+FB+f4x?Qa1=QHQ$4E)F)R #456"*3x=3 D D7;;gM$4E)F)R$%q4E)F'GB3xqAc !BqD:Qr#ha3xqQSTUQUVYPZZ[!tCj"S"3xuRU3K0# $  D2 "DaTQ-  tW jF2c(&2fRHL`ab 1vU2a4*,^_c^ddk l  gg 'G * * * .c/* ./* .3/* ../* ./0S/* .12/* .34/* .5/* 0T1* 01* 0d1* 0$1* 0%'41* 0(21* 0351* 061* 2WWT]O3* 23* 42a4i_5* 4"5* 4#$B$5* 4(#5* 6$&19S/7* 627* 8 *+9* 8,9* :fi !;* :";* <h "#=* <$=* >O?* >?* @ IA* @ A* *C1d r Rs( KKK&K$K),K/4K/ct}t|}tjddd5}t j |t }|j|j|dddtjt|dtdt|dttd ty#1swYZxYw) NrrGr#)newliner%) fieldnamesr$zWrote z rows to zWrote chart to )r,r` TIMESERIESr'r) DictWriterFIELDS writeheader writerowsCHART write_textrprintrm)vintagetsr+writers rmainrsnG ' "B b7 ;qf5 Yr]W5 F3r7)9ZL 12 OE7 #$ s =CC __main__)rrBrztuple[int, int])rlist[dict[str, str]])r;rrlist[tuple[str, float]])rDr9rrB)rHrBrIrrrB)rHrBr;rrztuple[str, str, str])r;rrr)r;rrrB)rNone)__doc__ __future__rr)pathlibr__file__resolveparentBASEr&rrr[rOr7rr r,r>rErMrPrWr`rr__name__rVr!rrsY"  H~&& ' ' - -  && ' " ' 72 %<>l^ % zFr!