§
    ÷„’jõ  ã                  óL   — d dl mZ d dlmZmZmZmZmZmZm	Z	m
Z
mZmZmZ d„ ZdS )é    )Úannotations)ÚALIGN_CENTERÚ
ALIGN_LEFTÚALIGN_RIGHTÚ
BORDER_BOXÚFILL_HEADERÚFMT_CURRENCY_VNDÚ	FONT_DATAÚFONT_HEADERÚ	FONT_MONOÚFONT_SUBTITLEÚ
FONT_TITLEc                ó   — d| _         d| j        j        d         _        |                      d¦  «         d| d<   t
          | d         _        t          | d         _        |                      d¦  «         d| d	<   t          | d	         _        t          | d	         _        g d
¢}|D ]R\  }}|| |<   t          | |         _        t          | |         _        t          | |         _        t          | |         _        ŒSd| j        d         _        g d¢}d}t#          |d¦  «        D �]*\  }\  }}}	}
}}|| d|› �<   || d|› �<   || d|› �<   |	| d|› �<   |
| d|› �<   || d|› �<   || d|› �<   t$          | d|› �         _        t          | d|› �         _        t          | d|› �         _        t&          | d|› �         _        t          | d|› �         _        t          | d|› �         _        t$          | d|› �         _        t(          | d|› �         _        t          | d|› �         _        t$          | d|› �         _        t(          | d|› �         _        t          | d|› �         _        t$          | d|› �         _        t          | d|› �         _        t          | d|› �         _        t&          | d|› �         _        t*          | d|› �         _        t,          | d|› �         _        t          | d|› �         _        t$          | d|› �         _        t(          | d|› �         _        t          | d|› �         _        d| j        |         _        |dz  }�Œ,ddddddddœ}|                     ¦   «         D ]\  }}|| j        |         _        Œd S ) Nu!   GiÃ¡ Váº­t TÆ° & NhÃ¢n CÃ´ng 2026Tr   zA1:G1u[   Báº¢NG Ä�Æ N GIÃ� Váº¬T TÆ¯, NHÃ‚N CÃ”NG & CA MÃ�Y CHUáº¨N Ä�á»ŠNH SÆ N (Háº¢I PHÃ’NG 2026)ÚA1zA2:G2u}   CÄƒn cá»© ThÃ´ng bÃ¡o giÃ¡ LiÃªn Sá»Ÿ XÃ¢y Dá»±ng Háº£i PhÃ²ng & CÃ´ng bá»‘ giÃ¡ thá»‹ trÆ°á»�ng thá»±c táº¿ Cty Ä�á»‹nh SÆ¡nÚA2))ÚA4ÚSTT)ÚB4u
   MÃ£ Hiá»‡u)ÚC4u&   TÃªn Váº­t TÆ° / Ca MÃ¡y / NhÃ¢n CÃ´ng)ÚD4u   Quy CÃ¡ch / TiÃªu Chuáº©n)ÚE4u   Ä�VT)ÚF4u   Ä�Æ¡n GiÃ¡ VÃ¹ng II (VNÄ�))ÚG4u   Ghi ChÃº Nguá»“n Dá»¯ Liá»‡ué   é   )
)z	VT-CAT-01u    CÃ¡t vÃ ng háº¡t lá»›n bÃª tÃ´ngu0   MÃ´ Ä‘un Ä‘á»™ lá»›n Mk >= 2.0 (Chuáº©n HP 2026)Úm3ipÕ
 õ.   ThÃ´ng bÃ¡o giÃ¡ Sá»Ÿ XD Háº£i PhÃ²ng VÃ¹ng II)z	VT-CAT-02u   CÃ¡t vÃ ng xÃ¢y trÃ¡tu,   Háº¡t trung bÃ¬nh trÃ¡t tÆ°á»�ng / á»‘p lÃ¡tr   i0È r   )z	VT-CAT-03u   CÃ¡t Ä‘en san ná»�nu   Ä�á»™ sáº¡ch táº¡p cháº¥t <= 5%r   iØG r   )z
VT-THEP-01u#   ThÃ©p cuá»™n D10 HÃ²a PhÃ¡t CB300-VúTCVN 1651-2:2018Úkgi A  õ'   BÃ¡o giÃ¡ Ä‘áº¡i lÃ½ cáº¥p 1 HÃ²a PhÃ¡t)z
VT-THEP-02u!   ThÃ©p thanh váº±n D16-D25 CB400-Vr   r   i0C  r    )zVT-BT-01u"   BÃª tÃ´ng thÆ°Æ¡ng pháº©m M300 R28u1   Ä�á»™ sá»¥t 12Â±2 cm, Xi mÄƒng PCB40 Háº£i PhÃ²ngr   i` u-   Tráº¡m trá»™n bÃª tÃ´ng PhÃºc SÆ¡n / Nam SÆ¡n)zVT-BT-02u   BÃª tÃ´ng lÃ³t mÃ³ng M100u   Ä�Ã¡ 4x6, Xi mÄƒng PCB30r   iPø u&   Ä�á»‹nh má»©c sáº£n xuáº¥t táº¡i chá»—)z	CM-DAO-01u    Ca mÃ¡y Ä‘Ã o bÃ¡nh xÃ­ch 0.8 m3zKobelco SK200 / Komatsu PC200ÚcaiÀû9 õ%   Báº£ng giÃ¡ ca mÃ¡y Ä�á»‹nh SÆ¡n 2026)zCM-UI-01u   Ca mÃ¡y á»§i 110 CVzKomatsu D31Pr!   i @, r"   )zNC-XD-01u#   NhÃ¢n cÃ´ng xÃ¢y dá»±ng báº­c 3.5/7u4   NhÃ³m II VÃ¹ng II Háº£i PhÃ²ng (Nghá»‹ Ä‘á»‹nh 2026)u   cÃ´ngi¨C u6   CÃ´ng bá»‘ Ä‘Æ¡n giÃ¡ nhÃ¢n cÃ´ng Sá»Ÿ XD Háº£i PhÃ²ngé   é   ÚAÚBÚCÚDÚEÚFÚGé   é   é   é#   é&   é   é   é(   )r%   r&   r'   r(   r)   r*   r+   )ÚtitleÚviewsÚ	sheetViewÚshowGridLinesÚmerge_cellsr   Úfontr   Ú	alignmentr   r   r   Úfillr   ÚborderÚrow_dimensionsÚheightÚ	enumerater
   r   r   r   r	   Únumber_formatÚitemsÚcolumn_dimensionsÚwidth)Úws2Ú	p_headersÚcell_refÚtextÚmarket_dataÚp_rowÚidxÚcodeÚnameÚspecÚunitÚpriceÚnoteÚp_col_widthsÚ
col_letterrC   s                   ú=C:\Projects\DSCons\app\services\takeoff\excel_sheet_market.pyÚbuild_market_prices_sheetrT      sÆ  € Ø3€C„IØ+/€C„IÔ˜ÔÔ(à‡O‚O�GÑÔÐàeð ˆ�Iõ  €Cˆ„I„NÝ&€Cˆ„IÔà‡O‚O�GÑÔÐð 	Hð ˆ�Iõ #€Cˆ„I„NÝ&€Cˆ„IÔðð ð €Ið $ð *ð *‰ˆ�$ØˆˆH‰Ý(ˆˆHŒÔÝ(ˆˆHŒÔÝ".ˆˆHŒÔÝ)ˆˆHŒÔÐØ#%€CÔ�qÔÔ ðQð Qð Q€Kðf €EÝ6?ÀÈQÑ6OÔ6Oð 'ñ 'Ñ2ˆÑ2ˆd�D˜$  e¨TØˆˆK�ˆKˆKÑØˆˆK�ˆKˆKÑØˆˆK�ˆKˆKÑØˆˆK�ˆKˆKÑØˆˆK�ˆKˆKÑØ ˆˆK�ˆKˆKÑØˆˆK�ˆKˆKÑå )ˆˆK�ˆKˆKÔÔÝ%1ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%1ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%/ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%/ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%1ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%0ˆˆK�ˆKˆKÔÔ"Ý)9ˆˆK�ˆKˆKÔÔ&Ý",ˆˆK�ˆKˆKÔÔå )ˆˆK�ˆKˆKÔÔÝ%/ˆˆK�ˆKˆKÔÔ"Ý",ˆˆK�ˆKˆKÔÔà+-ˆÔ˜5Ô!Ô(Ø�‰
ˆ‰à ¨"°2¸AÀBÈRÐPÐP€LØ)×/Ò/Ñ1Ô1ð 8ð 8Ñˆ
�EØ27ˆÔ˜jÔ)Ô/Ð/ð8ð 8ó    N)Ú
__future__r   Úapp.common.excel_stylerr   r   r   r   r   r	   r
   r   r   r   r   rT   © rU   rS   ú<module>rY      s·   ðØ "Ð "Ð "Ð "Ð "Ð "ðð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ðb8ð b8ð b8ð b8ð b8rU   