ࡱ> WyV  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUuYZ[\]^_abcdefghiXklmnopqrstvx{|}~Root Entry F֧wn[nj@BWorkbook-_VBA_PROJECT_CUR"+*P]3ynynVBA@6yn%yn T8\puser Ba= ThisWorkbook=p;.8F@"1Calibri1Calibri1Calibri1Calibri1Arial1Arial1Arial1Arial1 Arial1Calibri1 Calibri1$Calibri1Calibri1@Calibri1Arial1Arial1 Arial1 Arial1Arial1Arial1Arial18Arial1Arial1Arial1Arial1Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Calibri1Arial1Arial1Arial1Calibri1Arial1Arial1Arial1Arial1& Courier New1Calibri1@ Arial1 Calibri3" "\ #,##0;" "\ \-#,##0=" "\ #,##0;[Red]" "\ \-#,##0?" "\ #,##0.00;" "\ \-#,##0.00I"" "\ #,##0.00;[Red]" "\ \-#,##0.00u*8_ " "\ * #,##0_ ;_ " "\ * \-#,##0_ ;_ " "\ * "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ,@_ " "\ * #,##0.00_ ;_ " "\ * \-#,##0.00_ ;_ " "\ * "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ "$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000.0 0.000 0.0000% 0.00000 0.000000 0.0000000 0.00000000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                       ff     !  "  # P $ P %  %  &   ' ` (         )     * + a> , | - -| . | !| /!|  @ @   - \ -\  |@ @   L - L  |@ @  |@ @  \ -\ |@ @   |@ @  |@ @  0@ @  @ @  1@ @  0|@ @  @ @  @ @  @ @  @ @   -  D  D 2 L 3|!@ @  | @ 4 |@ @  . |@ @  5|@ @   L 6 L 7)@|@ @  8x@ @  |@ @  |@ @  @ @  @ @  |@ @  |@ @  @ @   @ @  @ @   |@ @   |@ @  |@ @  @ @  |@ @  | |@ |@ @  \ x@ @  |@ @  |@ @    d@ @   l@ @  |@ @  |@ @  |@ @  |@ @   |@ @   |@ @   |@ @  9| | /*  @ @  @ @  @ @   |@ @  |@ @  ||ro}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0."\ * _ ;_ }}* 00_)[$ -???##0.???"\ * ???_ ;_ ???}-}/ 00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}}7 ??v00_)̙[$ -##0."\ * _ ;_ }A}8 }00_)[$ -}A}9 e00_)[$ -}-}: 00_)}x}=00_)[$## "\ _ }}> ???00_)[$???## ???"\  ???_ ;_ ???}-}B 00_)}U}C 00_)[$## }-}D 00_)}(}F 00_)}(}G 00_)}-}H 00_)}(}K 00_)}(}N 00_)}(}P 00_)}(}S 00_)}(}W 00_)}(}[ ef00_)}(}] 00_)}(}^ ef00_)}(}d 00_)}-}e 00_)}-}g 00_)}(}h z700_)}(}j 00_)}-}k 00_)}(}m f00_)}(}o 00_)}(}p 00_)}-}q 00_)}-} 00_)}(} 00_)}(} 00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%3Normal % :Normal 27Normal 2 % ;Normal 3&Normal 3 <Normal 4&Normal 4 =Noteb Note   >OutputwOutput  ???%????????? ????$Percent@ Percent 2( Percent 2A Percent 3( Percent 3 BTitle1Title I}% CTotalMTotal %OOD Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16` XBoQ1AMacros[EV4_BOQ_AllinOne.xlsmConfigSheet1BoQ1V4_BOQ_AllinOneYZ BoQ_Ver2.0ZFullyINRSelectZ BoQ_Ver4.0Z( PartiallyUSD Discount BoQZJPY Negative BoQZEURC1D1Z AUSYY\1UsersgepadminDesktopBOQ_itemrate_turnkey.xlsBoQ PRICE BIDSUPPLYWTandVOLYYZ  Cl @YY:   2_xlfn.BAHTTEXT_xlfn.COUNTIFSBAA1:" boq_type;% boq_version;) conversion_type;  cstvat;46' currency_name; dfsga= ) domestic_global;  Excise= % Excise_Duty=! Excised=$ ExciseDuty;48 HelpButton  MyList; option9<**# other_boq;  ;6 PrintButton  Select;46& SelectD1OrC1;, SelectLessOrExcess;! Service= $ ServiceTax;46 SpellNumber Tax;TOT_ST:  ValidateAllSheetsSff@@zr8&Ko-G.-("#AS3 A@@   x9Sl. No.Item Code / Make,Please Enable Macros to View BoQ information BoQ_Ver3.0 Item RateNormalINR OnlyINRSelect, Excess (+), Less (-)Less (-) PRICE SCHEDULE (This BOQ template must not be modified/replaced by the bidder and the same should be uploaded after filling the relevent columns, else the bidder is liable to be rejected for this tender. Bidders are allowed to enter the Bidder Name and Values only )NUMBER #TEXT #NUMBERTEXTTEXT#DATEUnitsAddition / DeductionAddition / Deduction Values%Currency Convertion against each Item'Quoted Currency in INR / Other Currency'Freight Charges ( Unloading & Stacking)Any Other Taxes/Duties/Levies Other Taxes 2GIIIrd Party i.e DGS&D / RITES etc Inspection Charges @0.34%+Service TaxRLess for Cenvat Credit,if any respect of Supplies Under full Excise Duty Category TOTAL AMOUNT In Wordsitem1Nos Excess(+)4Supplying, Conveying and fixing spls. Including eart/Construction of chamber for 100mm sluice platesitem5Total in FiguresSelectFull ConversionQuoted Rate in WordsQuoted Rate in Figures,Name of the Bidder/ Bidding Firm / Company :Estimated Rate in Rs. P GST in % GST Amount in Rs. P,TOTAL AMOUNT Without GST in Rs. P aTOTAL AMOUNT With GST in Rs. PWDTender Inviting Authority: INDIAN INSTITUTE OF MANAGEMENT CALCUTTAQuantity DescriptionKBASIC RATE per sq.cm. In Figures To be entered by the Bidder in Rs. P  6<@J Name of Work: Publication of an Advertisement in the Times of India, All India Edition, ASCENT Page, Size 8x6 Sq.cm. and The Telegraph, JOB Page, All India Edition, Size: 7.9x5 Sq.cm. relating to the recruitment of Senior Technical Assistant for Computer Centre. Publication of Advertisement in the Newspaper. The Times of India, All India Edition Insersion Area : ASCENT Page Size : 8 x 6 Sq.cm.HX The Telegraph, All India Edition Insertion Area : JOB Page Size : 7.9 x 5 Sq.cm. cegitem2item3)Contract No: NIT/91ƬC/ADV/2/2021-22B*L L"NNOPTS6W ccB~-z4nA_)k:~yw T8 `Bx  dMbP?_*+%,&?'Q?(Q?)RQ?MAdobe PDFS 4dXXA4PRIV ''''0\KhCFFSMTJ0EBDAStandard" dXX333333?333333?&<3U} me} @T?@T@@T@@TA@TA@TB@TB@TC@TC@TD@TD@TE@TE@TF@TF@TG@TG@TH@TH@TI@TI@TJ@TJ@TK@TK@6 SSSSS~ v? 3 pn qrstuvwtt6~ W@Y@ W W WʡE^@ W~ v@Y@ 4 p6~ q? r stu vB w? ,D Less(-)   B t% t xx ) ~ D D 4D P yzz{|||||||||||||||||||||||||||||||||3 4  0D ! 55 D 4D ) 6#$ $ 5B INR Zero Only~ W@Y@ W W WʡE^@ W~ vY@ 5 p7~ q? r stu vB w?4,DLess(-)   B  t%  t  xx )~5DD4D Pyzz{|||||||||||||||||||||||||||||||||3%4 4C@D !5 5 D4D)6 5#$ $5B INR Zero Only~ W@Y@ W WWʡE^@ W #lYYYY3#4 % 44#5 6 % 55)6}6#$$5B INR Zero Only~ W@ W! W"~ W$@ W X' Z[\ ]$j^___`ab VVVVV4h5DAD Excess (+) D4D4DANDLess (-) 'D4D4DA ""B!5i D4A)6U 6#$ $5B Zero Onlyddddd &) 6#$$4B INR Zero Onlyn6dddddeeeeeeeeeee e4e6eSSSSS*hf0h(.SR(  H sF  OC (Group 1"_K ] O`8 8 B P  :Y'B C DEnFQNR*UVW,]:|dYY?D X  +om 4   XVVX @  ` X 4   XX  ,]<{:|Round Diagonal Corner Rectangle 23" @äPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!_:drs/shapexml.xmlTn0?KA⠽IjkٮHd_%%=(HI>NZ.xr&0қyx:y%Ѳ{Y3.oo$qb+kp#HM5xB5&Y^$Ju'|]jX,V+nSAN>|T%xy `3/[J(xwvad* >LCM-O];`a-)B,D_IpOX o+[+\Ai *R^xzyNٓiz1 b  4K3Jlv~69 I'$\l9Z @,xRaw|G:uߣ rP/%E Q(4NJ lXpBj?MlRoF<7q3UU$c#6o*{(ޚr$M=xlм\j8ʀLۮeUs,qX` {iþ}Sp4(՚]8~>>6=M7<+7v{PK!2drs/downrev.xmlDMK1E!;ʴE jmN1˹٢׍85qMnUmJ(ja=,W3J̆Y(EBBJ5mĮNSѕR9"\7.IćZ^Vg!Y'ʪz,v[-oFD>?֯}~ nAojC>C~6PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!_:)drs/shapexml.xmlPK-!2drs/downrev.xmlPKs*7F ],P` 9 $< Validate<:3 3 B Q  :Y'BԜ CQDEnFQNR*UVW,]:|dYY?D TԜ Ԝ Ԝ Ԝ mMJ Q QQQTRRT @  ` TԜ Ԝ Ԝ  QQQTT Ԝ Q,]<{:|Round Diagonal Corner Rectangle 33" @ßPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!Δg7drs/shapexml.xmlTn0?K B$ lR GwIFA/zpwoZN`4HTe9\7ϟfK O\ o$qb'k5jIi :8qt;)mCg5F/?~%(cɣ;Pk9AŗUk`n%dtD Zg(ɭ[0%+VKo·$7h+[wQs(H'FqNɁ|W X"d:̲1%<~ 6Ҝ- Fmj D||Gz$ L V92ѰXYlwLJ=\hK\3ʅބh+o| +7qcU>۰ܴ=<I [/6/ J m9A f:98_s.J03p=aaFkCW I厫]dPK!b\=drs/downrev.xmlDMK@Eax ;-5 mJˇfޤ3c˹z48eYZ~zdeR0jo\ZD 4!lȠٞ8vuCᦓIJ-LJ{**OkA$Y)u{3nA/8MO ~qZ#mtޢDhMA.PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!Δg7)drs/shapexml.xmlPK-!b\=drs/downrev.xmlPKNF ],Q`9 $<Print<:5 5 B R  :Y'B C DEnFQNR*UVW,]:|dYY?D X  +om 4   XVVX @  ` X 4   XX  ,]<{:|Round Diagonal Corner Rectangle 43" @áPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!#'9drs/shapexml.xmlTn0?K$6B I\eq|}P@).꺭-h3 ʕV{tzY@ [c20׈8˂ZZk4n|-^*+|&fEgZa5t;|CjdzBq=jeC0QZN>|Ѷ>!: uOwXY4UwL)354wOP#WyGQSL ꑢb4<$Y'$~;Z@U$rs0zlgPgJ*(\Seib^mJ{5=m\*$ғ"me}3w|SUENOrgL;x;ڀ,:t}#ԕ(iIw:ӥYpeMÙG;s4cQ$)ݑQα5ǢD#(3+ ރH=[RPsjI]98Ӭӟ߻*WPK!drs/downrev.xmlDQK0Co.UpJl@ 5mf[z0|v ngrkG!ر#X./k܎NElD6>2T-Y 3ɥfo1= n;yesiѸbO*(euز[i4{9}m΃?V+QLoC$ %d r PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!#'9)drs/shapexml.xmlPK-!drs/downrev.xmlPKTF ],R` 9 $<Help<:>@P6B66 66666A, INR   Percentage Invalid Datak1. Enter a valid Percentage. 2. Do not enter + or - or % symbol in this field. 3. Enter only Numeric Valuel1. Enter a valid Percentage. 2. Do not enter + or - or % symbol in this field. 3. Enter only Numeric Value  X@  Option C1 or D1Please enter valid values only(Please select the Option C1 or Option D1(Please select the Option C1 or Option D1Select Option C1 Option D1C Less or ExcessPlease enter valid values only3Please select either LESS ( - ) or EXCESS ( + )1Please select either LESS ( - ) or EXCESS ( + )* Cla %%"I # Item Rate Percentage Item WisetI # INR Only INR and Other Currency = Percentage Invalid Datak1. Enter a valid Percentage. 2. Do not enter + or - or % symbol in this field. 3. Enter only Numeric Valuel1. Enter a valid Percentage. 2. Do not enter + or - or % symbol in this field. 3. Enter only Numeric Value +lSelect X@ B  Percentage Rate Invalid EntryBPlease Choose the Percentage Option then Enter the Percentage RateBPlease Choose the Percentage Option then Enter the Percentage Rate+DolSelectB1BlSelect (\X@BH " Normal SingleWindow Alternated Rate Entry Invaid Entry6Please enter the Basic Price in Rupees for this item. !Only Numeric Values are allowed.  P ta3&k C L &va#Partial Conversion Full Conversion    Rate Entry Invaid Entry1Please enter Basic Rate in Rupees for this item. !Only Numeric Values are allowed. d. 3&k C  U Addition / DeductionPlease Choose the correct Onefoth  ; ctExcess(+) Less(-)  ^  Invalid Entry!Only Numeric Values are allowed.  th3&k C B Itemcode/MakePlease enter text a a  Rate Entry Invaid Entry7Please enter the Other Taxes2 in Rupees for this item. !Only Numeric Values are allowed.  &3&k C  Rate Entry Invaid Entry?Please enter the Excise Duty Category in Rupees for this item. !Only Numeric Values are allowed.  k 3&k C  Rate Entry Invaid Entry=Please enter the Inspection Charges in Rupees for this item. !Only Numeric Values are allowed.  3&k C C UnitsPlease enter Units in text Ipe  Quantity Invalid Entry)Please enter the Quantity for this item. !Only Numeric Values are allowed. al re3&k C  Sheet14b(b(8߿gg@ T8 W  dMbP?_*+%,&?'?(?)?",??&U  , , , ,  ,  ,  ,  ,  ,               $PH 0(  >@    7 Sheet2ggD ThisWorkbook%`O"__SRP_8__SRP_9;Sheet14 C  !"#$%&'()*+,-./0123456789:<=>?@ABDEFGHIJKLMNOPQRSTUWXYZ[\^`acdefghijklmnopqrstvwxyz{} 4 F H RP 8h"P  H " 4 F X 8`"Px  R"  "  x]Macros1' .Author : Ken Puls (www.excelguru.ca [1])KMacro Purpose: Ensure that the macro instruction sheet is saved as the only0 visible worksheet in the workbook]]]]A:Turn off screen flashing <9>9@qRecord active worksheet B.44Save workbook directly or prompt for saveas filename ,Excel Files (*.xls*), *.xls*F <%D'6 6X False'8d -Save the workbook using the supplied filenameAH 6 $B@J 6 <!LB@NAP'8k@d8Save the workbookAH $B@RAP'8kRestore file to where user was 4B@TRestore screen updates <9@9>qx$Set application states appropriately 8 $(V'.d '.ko .Author : Ken Puls (www.excelguru.ca [2])=Macro Purpose: Unhide all worksheets since macros are enabled <(@AP <(@ $(Vo@x.Author : Ken Puls (www.excelguru.ca [3])@Macro Purpose: Hide all worksheets except the macro welcome page] ^ ($Z(\ 0 $!Z 0! (G ` 0(\j 0 ($ZB@To0.Author : Ken Puls (www.excelguru.ca [4])@Macro Purpose: Show all worksheets except the macro welcome page]H 0 $!Z 0! (G ^ 0(\j 0 ` ($Z(\o0hA:o Call allinoneoAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit Const WelcomePagY"Macros~ P15 Sub _BeforeSave(ByVal AsUI As Boolean, Cancel ) 'Author : Ken Puls (www.exguru.ca [1]Er: Ensure thate m* i1ruc6sheet is s'd as onlyvisiiw Nn  Dim wsA2@ % AvevF0ilenFVarian]EbANdMCCal$l Wid@`AlDlSA6s C'Turn off screQfl@ashingWith AppyaEC.EnEventsˁSUp@@a End A!Recor@Y@QCSbwsG= B1? E[ directly prompt @BrqfDRIf= [ Then'/@!.GetAs%3( _!eter:="ES aU*.xls*),: " UCStr()@(",N",A$@= 0E⊅ 'b%the%us!4Asu!$BIHideHei.# ;#hJ.?Hb".A ddUShowf MIf!O!gYte'Re/ to wheuser wa@vA%a.`@zhyuAoemxu'| Duad st@s @ropte! \$" n+ad?u+;`@ &Open^(Ac_f_fTf2_f: Unh2 W&Meimgpp]cds y1/Tc#P]&9."OEb{j?OxIx3: {ZH3yw3 p@.tpus(؈).Vq$z= xp%F!bEachzIn{Vǟ.73+Not.,QOeryPdeNex1E )>z 4: ceвpP ?s ?|rkJ?)?s!T!!'6BokDClose(TGd@DwrdߗOHeA_Changֱ s Obj, aTargБRAK Ginon @O  @ :JXr`"#p~rb1DJ[FrReD a xrReD a ~rb1DJ[MEp [LSS 20j>"LLL *P6489bd35*\R1*#3c4*\R1*#129*\R1*#27f`j "  4( R` 6    8@HP X *x : :h& 0 8 4@  x v V         $ 8 H hpx  *    " 4 D8 .  0  "rU@@@8 ` qA ADHaMNOB1GXa 1 /` !  `` ``iY9I   i gg  g 8egph gp gg*pU g>Xgh0 H`x80g&g(D(RgpLgg gv H`xZ`gVfq08 0g gggg g Z0g ggg Pg 8eg gh ggdg ZPgzgggg`X2,(0gg.p 8g g0 8g ZPg8HggR  g8Ze g2 D g @g gH gxHL&&rgg8Ze g2 D g @g >gR  gxL&&Hih(gg(D `$h $h ` Z Z Z  Z`  "a"a`A $h$h2rU@@@xP`p81aC8A`x@8`8 `@ `HaCX`PbZr#p˜C̢_M}}' F)O v^I[x)O v^I[˜C̢_M}}'ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0n %@p7.%l%Hx@x8UW$*\Rffff*0C6489bd77` xAttribute VB_Name = "Sheet14" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2 rU@@@8`Agaqg__SRP_10V__SRP_11]jModule1 ziQ__SRP_4z*`DrU@@@xbrU@@@R0*#10*\R0*#f  6  8 B@ B B  V N0 <  @ F N` X  T  x0H`x 8Ph(Hh0Hh(@Xxw{BrxME(6 x p`kX ww irxit ve`x`z`|`~x``  `x`` `XH `0 ` ` `h ` ` ``P` `@`H`x`p`h```X`P`H`@`88`p ` ` `( ` ` ` `x `X` `H `0 ` ` `  ` ` ` `0 `Hp ``X `@ `x( ` `P `h ` `@ `( ` `Xh `P `8 ` ``` ` ` `` ` n% 8p80H`xP( H`@p pH@x @X ` @H   @@ 0 @ ( @  @ @p @ @ @ @ @ @ p @H X @ @ @0 ( @`  @x @ @ @ @ @ @ h @ P @8 8 @P @h  @ @ @ @ @ @ x @ ` @( H @@ 0 @p  @X @ @ @ @ @ @ p @ X @H @ @0 ( @`  @x @ @ @ @ @ @ h @ P @h8 @8 @P @ @ @ @ @ @x @@` @H @(0 @X @ @ phUW$*\Rffff*0=6489bd35*\R0*#18*\ 0 H `        8 P h       8 X x      ( @ `       0 H `      8 X`hpx 0     (8H`x (@H`x       (( P` x  $J  $* <0*@ P$`p      ( 8 H X h  Tx2  , 22P0&P$h*x* (     (@H P2`2xP"$** ( (0 8PX ` h  22P"$*(*@ P`p*    2 D8"X,h2x* "  2 D8 X$h*x* "  2 *8*P `"p  2* " (08@ HPX`.h:    .8@HP X"h x* 0D   /This function will work upto 99,99,99,99,999.99@;-- Updated on II/11/2011. Updated up to 9999 Thousan croresx;-- Modified as per requirement and updated as on 15/09/2011OAttribute Macro4.VB_Description = "Macro recorded 05/01/01 by Shailesh Agrawal"GAttribute Macro4.VB_ProcData.VB_Invoke_Func = "Normal.NewMacros.Macro4"6 Your comments and Feed back will be most appreciated. Macro4 Macro9 Macro recorded 05/01/2001 by Shailesh Agrawal Associates@ This macro is available free of cost at www.CharteredValuer.comG For Further inquiry feel free to contact on shashi@CharteredValuer.comR This is distributed as freeware. We do not take any responsiblity for any problem due to this macroN Updated to work up 9999 Thousand Crores of Indian Rupees. by KSR on 3/09/2011]dZero+vOne+vTwo+vThree+vFour+vFive+vSix+vSeven+vEight+vNine +vTen +vEleven +vTwelve +vThirteen +vFourteen+vFifteen+vSixteen+v Seventeen+vEighteen+vNineteen+vTwenty+v Twenty One+v Twenty Two+v Twenty Three+v Twenty Four+v Twenty Five+v Twenty Six+v Twenty Seven+v Twenty Eight+v Twenty Nine+vThirty+v Thirty One+v Thirty Two +v Thirty Three!+v Thirty Four"+v Thirty Five#+v Thirty Six$+v Thirty Seven%+v Thirty Eight&+v Thirty Nine'+vForty(+v Forty One)+v Forty Two*+v Forty Three++v Forty Four,+v Forty Five-+v Forty Six.+v Forty Seven/+v Forty Eight0+v Forty Nine1+vFifty2+v Fifty One3+v Fifty Two4+v Fifty Three5+v Fifty Four6+v Fifty Five7+v Fifty Six8+v Fifty Seven9+v Fifty Eight:+v Fifty Nine;+vSixty<+v Sixty One=+v Sixty Two>+v Sixty Three?+v Sixty Four@+v Sixty FiveA+v Sixty SixB+v Sixty SevenC+v Sixty EightD+v Sixty NineE+vSeventyF+v Seventy OneG+v Seventy TwoH+v Seventy ThreeI+v Seventy FourJ+v Seventy FiveK+v Seventy SixL+v Seventy SevenM+v Seventy EightN+v Seventy NineO+vEightyP+v Eighty OneQ+v Eighty TwoR+v Eighty ThreeS+v Eighty FourT+v Eighty FiveU+v Eighty SixV+v Eighty SevenW+v Eighty EightX+v Eighty NineY+vNinetyZ+v Ninety One[+v Ninety Two\+v Ninety Three]+v Ninety Four^+v Ninety Five_+v Ninety Six`+v Ninety Sevena+v Ninety Eightb+v Ninety Ninec+v One Hundredd+v]]]] ]8P]h*==========================================]D ]D ]D ]D ]D( ]D@ ]DX ]Dp ]D ]D ]D0 H`x]D ]D ]D  ]D8 Ph]]](@X]p]]D4]D 0H]D` x]D ]D ]D ]D ]D  8]DP  ' '!-- Limits in place 2004-09-23 ... t r Zero Only'pzkx tqvH7B High Value'pz@k8 t'   ' d$' ' $' $' $' $' ' $' Crore '| Lakh '~ Thousand ' Hundred ' and Paise' ' ' ' ' ' ' ' ' '&' $ $- $ ' Minus'x MsgBox RABJI1d( $ 'k   $ '  $ ' $ $ '  _B' $' $ ' $'  $v Thousand 'd( ' CRORE = ""'k d KARANT8 = "" CRORE = ""'k   $ '  $ ' $ $ ' ʚ;' $' $ ' $'  $v Hundred 'd ' CRORE = ""'k d KARANT8 = "" CRORE = ""'kX   $ ' $ ' $ $ ' ' $' $ ' $'    and 'kx  $v 'dX' CRORE = "" GXZP1 = ""kd''|'k  $ ' $ $ ' ' $' $ ' $'  $v'd8''~'kd''~'k  $ ' $ $ ' ' $' $ ' $'  $v'd8'''kd'''k  $ ' $' $'  $v'dx'''kXdP'''k0  $ ' $'  $v'd''kd''k    $' $''''  $v'd'kd'k   '''k  $v'd'''k` $'#3AQ_ r x $    $    $   |$   $   ~$   $   $   $   $     $   $   $   $   Only 'z z'piAttribute VB_Name = "Module1" 'This function will work upto 99,9.99 @ Op\Explicit-- Updated II/11/2011.up R99 Thousan c`rores=ifi>as per requirement and]`15/\09`FSpellNumber(s As Sng, kapilDouPble)'MaH4.Desxcrir Ic(ordQ0>1/01 by Shailesh Agrawal(ProcData.Invoke_YNormal.New@s.C$ Your comsFe@backbe mosppreci. !30201HsooAgkm@a v@ s t ^ 89J 10LINZUR 6 66 6 60&PAST6KAAMKA1RABJI@F̓XORD 9.99 "High Value BINDRZ 7- Int()2Round((* 100), 0 cA231e4`b3(%1 1AJEB!  CR`M" Crore;LAKH"Lakhthousa@.!?T(HU$EDH redPAISEaPais-tmpE G0JA##5 7R^& E(Left(TrimF(!31))-"fF r= Abs(gMinGd R@Wtd, 1!: %aN'aI$ ) -`(D!CA+Q#3 /AW0#߀.G4g, %QB6a@7@ b= wordsad 7) +0A' 8'F-& Ap C'$v* 8 9QBht5alۿ9p @"bA$ bv577'1_5q__= _55prg24cwK XYYa3;1+9 8 "4^e ue0D[S5tsU, 5%W3QW_8%Q=(1zNcB5?!r$ s> H5Q#C5" Fb z!  1h~Ъa433׍=KkB1 1q2Dgfg"hbs!! /od2eBORISL, rCYRUrA OS12?qRQpERUPTV&?1. End If Else RUPT = ""`HUNDRED8GXZP40If Len(RABJI1) > 1 Then!xZZARRight@, 2)A4DOZALVxal(&I> 0C FLITIES,words(". ! XYZ. L(f< 2 ApNGRIPDP15Lefp1N 2 q M5D6 3*)} w3;a/HPAST4@Hs A=0B0E/PAISEDH7XYMAXAJEB] GHAU wils + MinuTrim(KARANT10)99" "@90Q8E1E CRORE) _LINZ(UR4 2 LAKHD HARP73 tho`usand EA4 5o) bE6E{#FJ7e3%ST5" Only@SpellN`umber23  ``jFunctio !o__SRP_5!_Sheet2&b__SRP_au__SRP_b|jP`PKbA#Zrd#pb )*HCCL FoG[mObCW72xoG[mObCW72b )*HCCLME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0n %@p7.%%Hx@x8UW$*\Rffff*0@6489bd35`xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 Tg TrU@@@8 1a`rU@@@@~xy5!7!9<=?Aq1a1q1qQ1!qa a !Q!!!A"""#A##$a$$$A%%%&A&&&1'q''(a((()a))*A***1+q++,a,,-Q---A...!/q//0a001Q1111222!3q334a445::!;q;;;A?1AaA$ ggTgTgTg Tg Tg Tg Tg TgTg Tg Tg Tg Tg TgTgTgTgTgTgTgTgTgTgTgTgTg Tg!Tg"Tg#Tg$Tg%Tg& Tg'!Tg("Tg)#Tg*$Tg+%Tg,&Tg-'Tg.(Tg/)Tg0*Tg1+Tg2,Tg3-Tg4.Tg5/Tg60Tg71Tg82Tg93Tg:4Tg;5Tg<6Tg=7Tg>8?9:;<TgC=TgD>TgE?TgF@TgGATgHBTgICTgJDTgKETgLFTgMGTgNHTgOITgPJTgQKTgRLTgSMTgTNTgUOTgVPTgWQTgXRTgYSTgZTTg[UTg\VTg]WTg^XTg_YTg`ZTga[Tgb\Tgc]Tgd^Tge_Tgf`TggaTghbTgicTgjdTgk@gk8gpA glPqxg ggqvH7B g`mg ggn`Hg$HHExHgJ`dxHH00 Hg Exg$xxhg*ha(n`P(g<HExHH00xHg*xa(n``(g`ExHg$Hxx`gngogpgqxgrgkxgkgkhgk`gkXgkPgkHgk@gk8gsgT`xxHH`tKxH@ g2`xx-H`xgur gg,`xx`xggL hg2 `@xxg2 `@xxgPa a(n`( g&` _Bxg$xxg*xxg*a(n`(g`2g('pPqx@\gg`vpgvpg~ggvggLpg2 `@xxg2 `@xxgPa a(n`( g"`ʚ;xg$xxg*xxg*a(n`(g`:g('qPqxXdgg`vpgvgggvggLg2 `@xxg2`@xxgPa a(n`( g"`xg$xxg*xxg*a(n`(g`rgkD<gwxgg*x'Pqxpgg`vpggg`vpgvgvhggLg2`@xxgDa(n`(g"`xg,xx`xg2`@xxg*a(n`(g`Zg"'q`gg`vgvgv`ggg`vgvgv`ggLg2`@xx gD a(n`(g `xg$xxg*xxg*a(n`(g`Pg"'q`gg`vgvgvXggg`vgvgvXggLg2`@xxg*xxg*a(n`(g`g"'q`gg`vgvxgvPg>gg`vgvxgvPggL8g2`@xxg*a(n`(g`g"'q`,gg`vgvgbgg`vgvgg.LL2g:`@xx`xggvgvHgv@gZg 'q`tgg`vggg`vgg.LL2gvgvHgv@ggP`Jg"P'q`8gg`v8gvgv8gg*`a(n`(gPqH@xx0pq`kXqpXk@p((hq@hqhPP8`q @`qxx`XqH0@XqPqpXx@@((HqqPqhhP@q8 8q@x8q`H800x`^xH0X(hP hP8x`0Hx0p@(gq`g  $G 0H`xe@h`XPpHxxhX@0P(88p`H :1( xH0p@(hP8x`0X(hP xH0 a$h.DrU@@@ xbrU@@@~x   eModule2V__SRP_c~__SRP_dModule3 $6 B%(kK:L$j!!3Please Hide the Currency Selection Columns K and L A@k  B%!INR and Other Currency B%!INReINR,USD,JPY,EUR B%( TOTAL AMOUNT, It will be convert 5 B%(cTOTAL TAXES It will be convert only If you choose Full Conversion, Until it will be treated as INR 6 B%(K:L$j!!5Please UnHide the Currency Selection Columns K and L A@kp B%!INR and Other Currency B%!INRe1Please include the INR in Currency Selection ListA@F'INR,USD,JPY,EUR B%( B%!INR and Other Currency B%! e B%! $" B%(k B!&!(!* '$ , $ . ]X B%!'0L ,$j!2C@4 6l :8 >< 0@C@N9B9Dq . ,ip B!&!(!* '$] B%! PercentageFor C1D1 Drop down B%!C1D1Select, Option C1, Option D1'HD $$j!2C@4 6l :8 >< H@C@N9B9Dq B%!DiscounteSelect, Discount'HD $$j!2C@4 6l :8 >< H@C@N9B9DqdD $$j!2C@4qk#For AtPar, Excess and Less for IOCL B%! Percentage B%!IOCL B%!Discount$Select, At Par, Excess (+), Less (-)'HE $$j!2C@4 6l :8 >< H@C@N9B9DqFor Excess and Less B%! Percentage B%!  B%!DiscounteSelect, Excess (+), Less (-)'HE $$j!2C@4 6l :8 >< H@C@N9B9DqFor Discount BoQ B%! Percentage B%!  B%!DiscounteSelect, Less (-)'HE $$j!2C@4 6l :8 >< H@C@N9B9DqxdpE $$j!2C@4q@ )Range("E" & LastRow).Value = vbNullString7Please assign the Cell A3 for Excess or Less Drop Down A@kki.LastRow = ActiveSheet.UsedRange.Rows.Count - 4'L]8]P]h B%! Item Rate B%!MCL0For DeptUsers Drop down for Service Tax Category/Select,With CENVAT Credit,Without CENVAT Credit'NA L$j!2C@4 6l :8 >< N@C@N9B9Dq(Select,Works Contract Service Category I,Works Contract Service Category II,Works Contract Service Category III, Turnkey Works Contract (Divisible Contract), Exempted Services'PB L$j!2C@4 6l :8 >< P@C@N9B9DqnmclOptions3 = "Select, Agency is a body corporate and Not availaing CENVAT credit, Agency  QAr]xME(V*8:h~( @H\< 0*@Rp<0 H`h&  B  @(H p" $ &(0 8&@ h &      *(pX ,  & H P  X ` l  $   8 &@ h p  x  l     @ &H p x         0  B 8 @ H B P 4X     J 6 88 p  &     & tp 0P&X$B J h      " (J0      " N(Vx   J ` x     "(0B 8@HP X` &  T$p:$  ^ B  * $(P X`*&$   (TH$ B  (DBPp x B  (L`p (R( 0 $@h p x(T  &(P X`(H`x (H  \@     (H (!H!`h!! ! !!(N"X" x"R"" "# #(L0###P#$ $ $8$(DH$$$$N$ % (%0%P%(H`%%%J%8& V@&& & B%!INR Only B%!INRINR B%(TOTAL AMOUNT Without Taxes 5 B%( B%!DGSND?Total Evaluated Cost (including of ED/ST but excluding CST/VAT) 6 B%(dTOTAL AMOUNT With Taxes is a body corporate and availaing CENVAT credit, Agency is an individualHUFPartnership or Association of person and Not availaing CENVAT credit, Agency is an individualHUFPartnership or Association of person and availaing CENVAT credit, The bidder is a Small Service Provider"Select,Small Service Provider Availing Service Tax Exemption,Body Corporate Service Provider,Other than Body Corporate but not a Small Service Provider Availing Service Tax Exemption'RE L $j!2C@4 6l :8 >< R@C@N9B9Dqh L  B%!T(Vk8i0 B!&!(!* '$ Z B%!T(V B%! Item Rate B%!HideC:C$j!(F:F$j!(G:J$j!(M:M$j!(N:AZ$j!(BB:BB$j!( $  B%!\(AJ B%! Percentage B%!HideeC:C$j!(F:F$j!(G:J$j!(M:AZ$j!(BB:BB$j!( $  B%!\( B%! Percentage B%!INR Only,Please Reset the value as INR Only for Cell  B% $^A@ B%!T(VF'k AF B%! Item Wise B%!HideeC:C$j!(F:F$j!(G:J$j!(M:Z$j!(AA:AZ$j!(BB:BB$j!( $  B%!\(k i ]0]P]p BoQStatus $%j.bCR BoQStatus $,jX BoQVersion $%j.f BoQ_Ver3.0 BoQVersion $,j BoQChartType $%j.h hInvalid hNormal h SingleWindow h AlternateNormal BoQChartType $,j0Please reset the Custom Property boqcharttype :A@ hInvalideNormal BoQChartType $,jkWMsgBox "The Basic BoQ validations are complied, protect the Sheet and proceed further "ix]]](P BoQStatus $%j.b bNC bCR bCCCC BoQStatus $,jdThe BoQ is Tampered in BS A@k BoQVersion $%j.f f BoQ_Ver3.0 fInvalid BoQ_Ver3.0 BoQVersion $,j f BoQ_Ver3.0eThe BoQ is Tampered in BV A@k BoQChartType $%j.h hInvalid hNormal h SingleWindow h AlternateThe BoQ is Tampered in CT A@k0i(H!Dim boqstatus As DocumentProperty BoQStatus $%jCR BoQStatus $%jCCNC BoQStatus $,jki]]]8]X]x]]]]]  BoQStatus $%j.b !   BoQStatus lNC $!jB@N bCCeNC BoQStatus $,jkh` BoQVersion $%j.f !   BoQVersion lInvalid $!jB@NdInvalid'f f BoQVersion $,jk BoQChartType $%j.h !   BoQChartType lInvalid $!jB@Nd BoQChartType $%j'h h BoQChartType $,jkSRTWOT $%j.r !   SRTWOT lNo $!jB@N rYes rNoeNoSRTWOT $,jUPlease reset the Custom Property ShowRowTotalWithOutTaxes value as either Yes or No :A@kxSRTWT $%j.t !   SRTWT lNo $!jB@N tYes tNoeNoSRTWT $,jRPlease reset the Custom Property ShowRowTotalWithTaxes value as either Yes or No :A@kXPSCTWT $%j.v !   SCTWT lNo $!jB@N vYes vNoeNoSCTWT $,jUPlease reset the Custom Property ShowColumnTotalWithTaxes value as either Yes or No :A@k0( ShowSummary $%j.x !   ShowSummary lNo $!jB@N xYes xNoeNo ShowSummary $,jHPlease reset the Custom Property ShowSummary value as either Yes or No :A@k FormBased $%j.z !   FormBased lNo $!jB@N zYes zNoeNo FormBased $,jFPlease reset the Custom Property FormBased value as either Yes or No :A@kRank $%j.| !   Rank l $!jB@N | | |eRank $,jCPlease reset the Custom Property Rank value as either 1 or 2 or 3 :A@kCSType $%j.~ !   CSType lL $!jB@N ~H ~LeLCSType $,j@Please reset the Custom Property CSType value as either L or H :A@kOMsgBox "The Basic BoQ validations are Not Complied, please correct the issues "i`XqAttribute VB_Name = "Module2" Function CurrencyListItem@s() If ADveSheet.Cells(2, 4).ValuINR Only" And\5.<> "/" Thenbfc43.1 1, 53TOTAL AMOUNT Without Taxes|9o3, $DGSND XZB Total Evated Cost (including of ED/SDT ex CST/VAT)TElse%?N@2ElIfG@DRange("K:L").EntireColumn.@HiddenFa#p$MsgBox "Please e theƗ Seles K a L :$=RizOrDp,USD,JPY,8EUR/ԅU, It will be convert_JyTAXES o`s `(you choo3Fu Cb s, U "Discount" Then Options"Select, Excess (+),D L -)" 5With Range("E" & LastRowu8idaS 1r.D ateAdd Type:=xlCt eLisFAlertStyl  op, Op@eratorBetween, Formula1 :=n8IgnoreBlank}HTruJInDropdownE1'?  BoQ ElseIf2, = "Percentag@x섀( .5zG~A c A'r @MsgBoxNlease assign the _ A3 forϥ Ab DbHyIf #Funo% !  MCL()  ' nUsedB. s.CA - 4 E`7im mcl1 As #5M2W3Iv "PItemtv3`poepti`rsB" b!/Service Tax Category#+  ĸMCENVAT Credit,Aout 7HA!h*x.߰]Zw.8PoC ' 2GWorks Contract 0E0 I,>_III, Turnkey (Divipsibl8T yExempted s"Bal~ytx5zXxsx ;x '3 Agency is a body co8rpoЂN@{Not availaq1cs2 n inddualHUFPartnership TAssoci!b of Pson a ; a;d? b idder3SmallF/Prov~i&?/! >AaQLS,,BCE,Ohrh bLnq %T3d+3OZ?33333533Ƽ, 5)teriorwlorIndex620 8~q}ABPdCo lumnsppl|ayQ~1@~aϏ~nt~1O s(4o c xlNonĽO|ռO|YR"H&O C:C").Ent(ire#.dewF:FO9aAFalsTG|:J_T aM:MO\N:AZod BB:|BBood)"- 12sPO4`CqLu-C$!/Dl!/_ !!.ǴHidden = True Range("F:F").EntireColumn.Fals1jG:JjM:AZ/5BB:BB(6ActiveSheet.Cells(LastRow - 1, 1vtIf %2, 2).Value"Percentage"P And4<> "INR Only" ThenMsgBox "Please Reset the v9as for p0 " &< Chr(13)R7+Interior.orIndex:3boq@%idations tatusEF"% EFIfCall DropDown2RBoQ EaItem Wisa3, a= "@ O`C:CX(AAp;p/K_p(FFunyo e% Up NeCustomDHocPHT(\Dim `R$QAs umsAerty Dvers`V ychart0typeTOnp Errqu@ Next#SvhisWork`book.iPes("_S"i"(vTlpCRq_t&"rte~V)_3.0,4C;T;%w5 bn›CN ormalSingleWind$owTAlnat=/A($=rd' u1 :WSIeSo 9oQo oc ? '%q Basic "pg are complied, protecSsb ahPceed furtr 0ElEopBE_AE?8_HJEEcwE /{NC" Or!7D?p N oQNA+CC&C+BoQ is T amper in BS#?<NOYt1NGS"K3 /a$ocoQRerRw:5K  5BV ( nW-Xz AsXoqX{Xg\X2 (CT EEҼ&E'{ @/>/>+> ;^9???0E3a vORO47#ShowTotalWithOutTaxes\\ 6Summary{_UFqQ Property Dim Rank As Do@cument C SType|  On Err@or Res Next2Set boqstatus = ThisWorkbook.Custom ties("Bo$QS2")GIfa.Number > 0Ien"W.Add _4Name:=8,LinkT oCont:=`False:0=msoStringValu9NC"EE(p<> "CC."q"2nd8 If8mversionmV ?nEnEZn EnInvalidoT@rN"K gFTM=  Exchartt|srtsCa\< "Yes"0 And 4 ThenThisWorkbook.CustomD0ocumies("]") = |MsgBo@x "Ple? reset the ' jEvb@ as eir W or No :j]IfS@On ErrResO Next S7RankLs$g")+.Number > 0.Add Namjq*Յ151‚E2J3sDWjB" 123yCS' tXA AaOL7kHÃ(L"AQC AmǂdAL!AH2A'E` ic BoQ idations aret Compli ed, pÓcorrecissPues $EAu$nc #`afHiHipHiHiHiHiggZ@ThH`Z@`C7l`gBZ@gg0@>`hHi a Z  Z  Z  Z   Z  Z   Z  Z,rU@@@ 8 `8q `8 `8 `8 `8! `8 `8! `brU@@@H  h                B! B%! BoQ_Ver3.0 B!$BoQR Invalid BoQ!!! Please download the BoQ from the Downloads section of eProc Portal $^A@Ap B! B%! BoQ_Ver3.0 B!$BoQeAXApAAJ Call DuplicateSerialNoAAA B! B%! BoQ_Ver3.0 B!$BoQ BoQChartType $%j AlternateeAA B! B%! BoQ_Ver3.0 B!$BoQ1 BoQChartType $%j AlternateeAA B! B%! BoQ_Ver3.0 BoQStatus $%jCR BoQStatus $%jCC BoQStatus $%jNCe=Please download the correct BoQ from the eProcurement portal A@kpohX BoQStatus $%jNC+The Basic BoQ validations are Not complied B! , please correct the issue  A@g BoQStatus $%jCR B!e+The Basic BoQ validations are complied for B!) , protect the sheet and proceed further A@ B%!INR Only B%! Item WiseQPlease Ensure that the formula for Column BA (AMOUNT) and Column BB (ONLY TAXES) A@kp BoQStatus $%jCC B!e0MsgBox "The Basic BoQ validations are complied " BoQStatus $%jCR BoQStatus $%jCC B!e=Please download the correct BoQ from the eProcurement portal A@k`iX ! Item Rate   ' ! Percentagee   ' ! Item Wise INR Onlye  ' ! Item Wise INR Onlye  'kXiP  ! ExciseDuty !JED NA at present and will not be charged even if it is applicable later on ' !GED NA at present and will be charged if it becomes applicable later one  d ' ! ED Extra @ ! e  d ' ! ED Extra @ !e',Please Enter ED Extra % Rate, it cannot be 0A@ !ED Inclusive @ ! e ' !ED Inclusive @ !e'0Please Enter ED Inclusive % Rate, it cannot be 0A@d'k ! ServiceTaxe !Service Tax NA ' !Extra @e  d 'd('kd'kiAttribute VB_Name = "Module3" Sub allinone() If ActiveSheet.ProtectContents~False And NCells(2, 1).Value <> "BoQ_Ver3.0"1Left( ^, 3)," ThenMsgBox " Invalid '!!! Pleadownload the from "Ds s`io@n of ehc Portal" & Chr(13}9C ResetCustoPmDocpKEFgX$TypeBdColumnsDispplay TZ7@CurrencyListItems!DropAZfoPrMCL 'DuplicateSerialNoPCheck Mandatory6ieBBStatubmsG#~#t.~4~1## #2 (r xME` 0j> L "L 5?P, c;a7 @7/a pt B;qgGOl" OA-o&k b_dgsnd(g_ , Tax-"ED_stru|ctL)`# G#ExcRDut V(8 D NA Spr 0ntQwill not bFЫg_even if itp3 apr, l*r onK $ E d H  bePn~e~_ _ _ ] * (1 + `/ 100 reJExtra @oT> 0)9dgsnd = Basic_rate * (1 + EDp/ 1@00) ElseIf (|structure.Value"ED Extra @" A@0) ThenUtotal_amo    ?-"#$%&'()*+,./01:3456789 ;<=>RBCDEFGHIJKLMNOPQ]TUVWXYZ[\@^_`abcdefghijklmnopqrstuvwxyz{|}~unt_bb_0 &MsgBox "Please EnteFrp% R, it cannot be 0"BInclusive^> *^GA=+A=P3nrEIf CbT@ax_typS@ervice"̉ NA")hsCHVWVe !Functio@s __SRP_e __SRP_fPModule40__SRP_6!8`8a``Aq!Q ^^^^^^^!`q ^^^^bgg ZrU@@@8`b=aC! rU@@@8`b! gGrU@@@@~x1 and B2, which should not be Blank A@Ap|@!Chk for BoQ Type Should not BlankBoQ1 %%! BoQ_Ver3.0BoQ1 %%! eGPlease reset BoQ Type values in the Cell B2, which should not be Blank A@Ap|H,Chk for BoQ Chart Type same as CustomDocProp BoQChartType $%jBoQ1 %%!eCPlease reset BoQ Chart Type values should be same as CustomDocProp A@Ap|h'Chk for Form Based BoQ in CustomDocProp FormBased $%jYes  %%! Item Wisee 2MsgBox ActiveWorkbook.Sheets(sc).Cells(2, 2).ValueZPlease reset Form Based values should be No OR all the sheets contains only Item Wise BoQ A@Ap|0'Chk for 2nd row values are same as BoQ1BoQ1 %%!  %%!BoQ1 %%!  %%!e3Please reset 2nd row values should be same as BoQ1 A@Ap| 9Chk for itemcode are same as BoQ1 for alternate boq chartd , B!&!(!* BoQChartType $%j Alternate ,BoQ1 %%! ,  %%! BoQChartType $%j Alternate ,BoQ1 %%! ,  %%!9Please reset itemcode/make values should be same as BoQ1 A@Ap|pkh ,AkH BoQStatus $%jCR BoQStatus $%jCC  'd|k  %!$BoQ e  %!$B@TPlease sheet name should be BoQ A@  'Apk0MsgBox "scount " & sc  NC BoQStatus $,j/Please assign atleast one sheet should be BoQ1 A@ApkoxpAttribute VB_Name = "Module4" Sub ValidateAllSheets() bc1 BoQ1*Found&False 'MsgBox ActiveWorkbook ."p").Cells(2, h3).hu:8. Cgt_For bs Toe, If Left(sc).~CbN" Then tTrVe E|If'`Chk fP y in OrderGD <>  A/>  V ?s should beC(ed ),A2 ... :{A3Call ResetCustomDocProp.Exit @C=CE@~5" & @.A6 _DL|).#) bTypeCAnot Blank .a1vbNfu@ng@V2T=A0rPlea0se rem Version aP B7valueBsthe A A1whichEA@@ h??k@!--E9.a_3.0""`BN_.AaV.U,Bs+e +`|+CPhart#>sa s urThisfFument{erties(a&B ")a+ʷ)VgT8)@m Bjbf((" (YesTAϦfTItem WiseM go2.No OR aEs contains only  J?E?e9e/Q W E2Orow $ are "B?F//o/Uj__OD4U_?5_aet |4O4~~o'1 i0+code MҐalternz boq< cAL( ru13R.UsedRange.Rows3 - ~4 |?Oq?OoQ9O;Ae ;;r##Or@SYoc rU@@@~x'aQ=\aC!   qa gGSgY1Y[Tg\bATe`af1kay1zz{Q|_a}D gg Z ZC` Z0T7Ch7Pl 0gb0 O( 0grg Z ZC` Z0C7Ch7Pl 0\gggggg g rgb Z ZC` Z0C7Ch7P0HZ@ HT7lH 0g g rgb Z ZC` Z0C7Ch7P0HZ@ HC7lH 0g g rg ZC` Z0C7Z@ T7hHZ@ HPT7hZ@ 8T 7l H 0PrgL0I(0gg{8H0hP (ggTZ@ Kg Z8 Oh!OP( hP8gkgZ@ Ch ZP C87lP@g8" ZOh#OP( hP8g Zh$TP Z8X%C7@lh84gL8Ph&I(hP8ggZ@ Ch ZP C87lPgZ@ Th Z@ PT878 Z8C@7 l8PgL8PhI(hP8gg(@V 8hP8@ Hi8Hi   aS  Z 2 &o* (V rxMEX6 LLL " <`6489bd35*\R1*#3c7*\R1*#12d*\R1*#136*\R1*#121*\R0*#f*\R0*#17$*\Rffff*0A6489bd77*\R0*#e$*\Rffff*0?6489bd35$*\Rffff*0B6489bd77R" < (X n(  48L0hp .x (X@ hLH   (bF RLP   2B NL8   .V 8  dLX    .. >L   @ $t( PDL8   D       2( ` 0L         B :L0 p x   ''6MsgBox ActiveWorkbook.Sheets("BoQ1").Cells(2, 3).Value"MsgBox ActiveWorkbook.Sheets.Count  !!*  %!$BoQ'k(Chk for BoQ Sheet in Order  %!BoQ1  -BoQ Sheets should be Ordered BoQ1, BoQ2 ... :A@Ap|  %!BoQ  e  %!$B@T!Chk for BoQ Type Should not BlankBoQ1 %%! BoQ1 %%! ^Please reset BoQ Version and BoQ Type values in the Cell A Q]1o(VMg(o(((u /make:))?ryc B Next "xLinon!1m?$oQStatus#_CR"QA((CwC^ =A+ P }k/I TQ9A<$$MM $f n##gbA@O)ut"sc sc "# * NCrLassign atlпtPvnwܑ I]  ! __SRP_7Module52.%__SRP_14A!__SRP_15 $!A@Anz9Chk for OptionC1D1 / Discount is Empty for Percentage BoQ B%! Percentage $  B%!Selecte-Please Choose Option C1 or Option D1 for Row $  B% in the Sheet  B!A@Anzp:Chk for Percentage Type Option is Empty for Percentage BoQ B%! Percentage $  B%!Selecte4Please Enter the Percentage Type Option for rU@@@@~x(aQ R=aC! gGSTATqTXY1YaY[Q[\a]^^_A_aaQbbbb1ce`aaef1f:ggggnXZ `lp(4g Z    K Lggg Z    TpC7XC7l zgL I(gg{g Z    OCpC7l 0gh Z   pZ pph phg@px  Z  q8C hpZ phqC+l phzgLI(gg{>g@px  Z  8C hpZ phqC7l ph,gLI(gg{>gZ@x8pX  Z  p\ pngLI(gg{>gZ@XCx8p Z  pT7l p gLI(gg{>g(px  Z  8hpZ phTXp xZ xp(08Z 80(T+hl phxp80(l gLI(gg{>ggtX PZ  2gZ@X CP @8px  Z  pP @hZ hT7xZ@xX CP @0@ 8pZ p80hP @(Z (T7h+Pl phxp80(hgL!I(gg{ggP g gg"Z@X#Cx"Z@8$C+lg $gg{gg Z    CpC7l gh Z   pZ pph phgL%O(g ggg(gKgB"X&Z@gL'I(ggg{hD@(8 P phxp80(hhP aS4the Row $  B% in the Sheet  B!A@AnzP3Chk for Percentage Rate is Empty for Percentage BoQ B%! Percentage $  B%!Select $  B%! e-Please Enter the Percentage Rate for the Row $  B% in the Sheet  B!A@% $  B%(Anz3Chk for Percentage Rate is Empty for Percentage BoQ B%! Percentage $  B%!Select $  B%!%e-Please Enter the Percentage Rate for the Row $  B% in the Sheet  B!A@Anz3Chk for Percentage Rate is Empty for Percentage BoQ B%! Percentage $  B%!Select $  B%!%e?Please Enter the Valid Data Format Percentage Rate for the Row $  B% in the Sheet  B!A@Anz`:Chk for Quoted Percentage Rate is Empty for Percentage BoQ B%! Percentage $ 5 B%! eLPlease Enter the Valid Data in Quoted Percentage Rate in Figure for the Row $  B% in the Sheet  B!A@Anz0k(5Chk for Basic Rate is Empty for Itemrate and Itemwise , +Chk for Column Rate_M, TotAmt_BA, TotAmt_BB , B%!$ ,5 B%!$ ,6 B%!$&Please Check the Quoted Rate for S.No , B% in the Sheet  B!A@Anz3Chk for Total Amount With and WithOut Tax is Number , B%!  ,5 B%!$ ,6 B%!$e&Please Check the Quoted Rate for S.No , B% in the Sheet  B!A@Anz6Chk for Basic Rate is Filled for All items in Itemrate B%! Item Rate , B%!  , B%!  , B%!e%Please Enter the Basic Rate for S.No , B% in the Sheet  B!A@Anzp B%! Item Rate , B%!  , B%!  , B%!e'=Chk for Basic Rate is Filled for atleast one item in Itemwb Xr_xME8P6 L < `k [[%H88pP@ `8Bn l@ @ @ @` @ @h @$P @8 @0 @x @ @ @ @ @ @  @8p @PX @h@ @( @ @ @ @@ @ @P @ @(x @X` @pH @0 @ @ @ @h @ @, @( @7@p (7@h @P @8 @ @ @ (O`XUW$*\Rffff*0E6489bd77*\R1*#3c7*\R1*#12d$*\Rffff*0A6489bd77*\R0*#e*\R0*#17*\R0*#14[B b (8 @@ .  "jjp x ,Flh p @xRp  @Rv(  :vTph"d  :xTPp8 @ :H~r  @L0     < $ 20 `h b 0  8 :@ ^@ b H  P <X  b     D`    <2Z~      B!&!(!* '$ $ '"'9Range("M13:M" & LastRow - 3).Interior.ColorIndex = xlNone(Range("B8").Interior.ColorIndex = xlNoneAnChk for Bidder Name is Empty B%! -Please Enter the Bidder Name for the Cell B8  B% in the Sheet  B!A@Anz&Chk for Bidder Status is Empty for MCL B%!MCL B%!Selecte/Please Enter the Bidder Status for the Cell E8  B% in the Sheet  Bise  B%! Item Wise , B%!  , B%!  , B%!e'  B%! Item Wise , B%!  , B%!  , B%!e'kh ,5Chk for Basic Rate is Empty for Itemrate and Itemwise  B%! Percentage1Please Enter the Basic Rate for atleast one Item  in the Sheet  B!A@AnzpkhAliXPAttribute VB_Name = "Module5" Function BiddersColumnsValidate() LastRo wnATveSheet.Used@Range.6s.Count - 1 in\ = z- 3 AtleasetOneItemF illedXFalse 'R("M13:M" & >).In@teriormlorIndex<`xlNon=;B8"* Call ReECustomDocPr0opBTBCChk for is Empty If Cells(8, 2).uvbNullSng Then MsgBox "P Eh the 4< + B8& 71)" in!.<&Exit Ń@Status ABGMCL EnD3, 3D" " AndN5H Select"M{' NE?N@AF4NOpAC1D1 /` Disc PPercentagoQR2 " ÕT1, 4+gRChoose  C1 ` A,ϡsRSt.S rS((Typ,Qx,ic~_X24eY-, --Ÿ-URËBY Y(,<> "%ӊ6g`h(_3*_3I3"%5]@=m ?3I ?3MI?3 63t6t0.o`bvOrRs5t. 5etvv5 'Նv5Cs Tx5InЌ( )NumberFormat, ) <= 0??b Data  7o"_Q s/hetN_WQuot` 445_N}eXNO _n Figure")A33 OP32 E@If7asic c R jIrkaqwLis' r13 To0FR̃GF:#r_M,t@Amt_BAB@Not Is1pc3(r{%)±F?s15)X8!-CheckRQ17S.NoNC1 QQ/k1L!6Total AmWith Out TaxHOD^ ֱ0hJ3QO?F 02,0 the Sheet " & Activex.Name Call ResetCustomDoc@PropBTExit Funon,'Chk for Basic Rate is Filled0Aitems in Ir# vbNullStrin2g1131LoLckl2TrNT heMsgBox "Please Enter tS.NNo}e1)"ݿ_.,_jl _At^tOneD= j at onqŭwisNTFnaԝQWtcGV+?#b?sx?#喟N'#> 0[MG |!!E`If Next r OEmptyV aaONM;_* "Percentage"ebbߔOdfLE' UPlease remove duplicate ItemCode highlight in Background Color $^A@rU@@@@~x aQ aC!t! gGQbbbY1YAl7SmammnnopAmaqqrav!waww_AxggbZ hPg P8g ggjZ  qKg(X Z O OZhO(hX(gg gZ  C@Zh  CX7(lhg(XZ O OZhO(hX(gg gZ  CPh@Z X C(7lXg(PZ O OhZOX(hX(gg gZ  CPh@Z X C(7lXg(PZ O OhZOX(hX(gg gNZ  CPh@Z X T(7PxZH  q0C7l XH^ g(PZ O OhZOX(hX(gdPZ  gg gNZ  CPh@Z X T(7PxZH  0C7l XH g(PZ O OhZOX(hX(gg glZ  CPh@Z X T(7PxZH 0Oe7lXH g(PZ O OhZOX(hX(gg gZ  CPh@5Z X qC(7lXg(PZ O OhZOX(hX(gg gg$ 8pHg @ Z    @5Z h  2 @@6Z X  2 hX4g(X @Z O OZhO(hX(gg ,g: @Z  qT @5Zh   [@7X @6Z(   [7lh@(fg(X @Z O OZhO(hX(gg ,gZ  C @pZh  qTX7( @ Z  qxCH7 @0 hZh PT78lhhg(X @Z O OZhO(hX(gg ,gZ  C @pZh  qTX7( @ Z  qxTH7 @0 hZh PT78lhhg ,g CZ  Ch7 @@ZX ( qT7 @ ZH  q`T7 @ hZh 8 T7lhX(H8jg ,g CZ  Ch7 @@ZX ( qT7 @ ZH  `7 @ hZh 8 C7lhX(H8,g ggp(g TZ  Th7lrg~Xh PqZO( hXgg gggd>p 8PhhX(H8 a Z2F'kkk  'k  'Duplicate S.No Checking End FA`d@Apk0i(X B!&!(!* '$-LastCol = ActiveSheet.UsedRange.Columns.Count $ ' BoQStatus $%jNC+The Basic BoQ validations are Not complied B! , please correct the issue  A@d  ZA13:M $ $j!T(VT'BptIr2xME(6 <<< X` ,, ` ,X%XUW$*\Rffff*0D6489bd77DB  $0 4P(  0 H P `p R HX pT (08@ PX`p "x B  48"Hfp(  8 4P *N`h  6B $ L8$ P P $    4( ` x  * N 8  X Vh ~ @  ` *p z   @ ,P R v  P` h Hx   (PH  R (^H  vp    <`x   <^`   >j`    >lh  $ >`h  V`P p Xjh Xlp Xlx Xj < $  hH f 6 P pdX@ `p x<\( HvXh8  X h h!p! !~!d "" "" "<"Z#p# ##Z0$$ $$ZP%% %%d&' 0'@'d(p( (( (( ( ( $($)$()$P)$x)  @)R)j8*$*** :*L +lp+$+,, F,~`,r,$X--- @-L-v .$... D.L/xh/$/00 0$ 0$H0p0$x0$00  0$0X1$p1 1L1X1$P2 x242f2$(3 P3:`3l3$4 842H4j44 5 5 *(5 X5@x5 5 5@5 (686 @6P6X6`6h6p6x6 6Duplicate S.No Checking Start  B!&!(!* '$* -LastCol = ActiveSheet.UsedRange.Columns.Countx $ ' ZA13:L $ $j!T(VT' '  A X 'C X '2MsgBox ActiveSheet.Cells(4, 1).Interior.ColorIndex.MsgBox ActiveSheet.Cells(LastRow - 1, 4).Value#Chk for Domestic for Percentage BoQ B%! Percentage B%!INR Only6Please reset the Conversion type as INR Only for S.No  B% $^A@ B%!T(VF'k`0Chk for C1D1 and Discount BoQ Dropdown as Select B%!  $  B%! IPlease reset the cell value as Blank for one row before LastRow D Column $  B% in the Sheet  B!A@ $  B%!T(VF' B%!C1D1 $  B%!SelecteKPlease reset the Option C1D1 as Select for one row before LastRow D Column $  B% in the Sheet  B!A@ $  B%!T(VF' B%!Discount $  B%!SelecteOPlease reset the Option Discount as Select for one row before LastRow D Column $  B% in the Sheet  B!A@ $  B%!T(VF'k-Chk for Heading and Notnull from 4 to 12 rows , Z , B%!T(V B%!T(V , , B%! $Please Enter Valid Data for the Row , B% $^A@ , B%!T(VF' , , B%!,Name of the Bidder/ Bidding Firm / Company :eSPlease Enter the Word 'Name of the Bidder/ Bidding Firm / Company :' for the Cell , B% $^A@ , B%!T(VF' , , B%! eOPlease Reset the 'Name of the Bidder/ Bidding Firm / Company :' as Blank Value , B% $^A@ , B%!T(VF'&Chk for Bidder Status is Empty for MCL , B%!MCL B%!Selecte9Please reset the Bidder Status as Select for the Cell E8  B% in the Sheet  B!A@F'k ,AMsgBox InStr(ActiveSheet.Cells(LastRow - 1, 6).NumberFormat, "%") , For Mandatory Fields Check .7 . . , . B%! %Please Enter Valid Data for the S.No , . B% $^A@ , . B%!T(VF'k0 . B%! Item Wise , B%! e , . B%! 4Please Enter Valid Item Code / Item No for the S.No , . B% $^A@ , . B%!T(VF' , . B%!d eKThe Item Code / Item No should not exceed more than 100 Chars for the S.No , B% $^A@ , . B%!T(VF'kX . .e Chk for Qty , B%!  , B%! 6Please Enter Valid Data for Quantity Columns for S.No , B% $^A@ , B%!T(VF' Chk for Units , B%!  , B%! e3Please Enter Valid Data for Units Columns for S.No , B% $^A@ , B%!T(VF' Chk for Units length , B%!  , B%! e?The Units value should not exceed more than 255 Chars for S.No , B% $^A@ , B%!T(VF'kh Chk for Column H length , B%!  , B%! BThe Column H value should not exceed more than 255 Chars for S.No , B% $^A@ , B%!T(VF'k` .  .5 .6e , . B%!$ , . B%! 5Please Enter Valid Data for Numeric Columns for S.No , . B% $^A@ , . B%!T(VF' .5 .6 , B%!  , . B%! e5Please Enter Valid Data for Numeric Columns for S.No , . B% $^A@ , . B%!T(VF' . e , B%!  , B%!  , . B%! . '.@Please set the Rate as Blank value or Protect the Cell for S.No , B% $^A@ , B%!T(VF' , B%!  , B%!  , . B%!e . '.BPlease set the Rate as Blank value or UnProtect the Cell for S.No , B% $^A@ , B%!T(VF' , B%!  , B%!  , . B%!e . '.BPlease set the Rate as Blank value or UnProtect the Cell for S.No , B% $^A@ , B%!T(VF' , B%!  , B%!  , . B%!e . '.@Please set the Rate as Blank value or Protect the Cell for S.No , B% $^A@ , B%!T(VF' , B%!  , B%! e , B%!T(Vkk .  .5 .6e bIf IsNumeric(ActiveSheet.Cells(r, c).Value) And ActiveSheet.Cells(r, c).Value <> vbNullString Then_MsgBox "Please Enter Valid Data for TEXT Columns for S.No " & ActiveSheet.Cells(r, c) & Chr(13)/ActiveSheet.Cells(r, c).Interior.ColorIndex = 3boqvalidationstatus = "F" . B%! Percentage , B%!  , B%! .Please Enter Valid Estimate Rate for the S.No , . B% $^A@ , . B%!T(VF'k . e , B%!  , B%! 1Please Choose Valid Convertion Type for the S.No , B% $^A@ , . B%!T(VF' B%! Item Rate , B%!  , . B%!Partial Conversione=Please reset the Conversion type as Full Conversion for S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , B%!  , . B%!Partial Conversione=Please reset the Conversion type as Full Conversion for S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , . B%!Partial Conversione:Please reset Convertion Type as Full Convert for the S.No , B% $^A@ , . B%!T(VF'k@ . e , B%!  , B%! /Please Choose Valid Currency Type for the S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , B%!  , . B%!INRe/Please reset the Currency Type as INR for S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , B%!  , . B%!INRe/Please reset the Currency Type as INR for S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , B%!  , . B%!Partial Conversion , . B%!INRe9Please Enter valid Currency type other than INR for S.No , B% $^A@ , . B%!T(VF' B%! Percentage B%!INR Only , B%!  , . B%!INR B%! , . B%!e:Please Enter valid Currency from the Master List for S.No , B% $^A@ , . B%!T(VF'kXkPkH . , Z $  B%!T(V Z $  B%!T(V Z $  B%!T(V Z $ 5 B%!T(V Z $ 5 B%!T(V:Chk for Percentage Type Option is Empty for Percentage BoQ B%! Percentage $  B%!SelectTPlease reset the Percentage Type Option as Select for Cell Highlighted in Red Color $^A@ $  B%!T(VApz 3Chk for Percentage Rate is Empty for Percentage BoQ B%! Percentage $  B%! eVPlease set the Percentage Rate Cell should be Blank for Cell Highlighted in Red Color $^A@ $  B%!T(VApz?Chk for Percentage Rate Format is Percentage for Percentage BoQ B%! Percentage $  B%!Select $  B%!%e\Please Set the Percentage Rate Cell should be format as % for Cell Highlighted in Red Color $^A@ $  B%!T(VApzp:Chk for Quoted Percentage Rate is Empty for Percentage BoQ B%! Percentage $ 5 B%! e_Please set the Formulla for the Quoted Percentage Rate in Figure Cell Highlighted in Red Color $^A@ $ 5 B%!T(VApz0=Chk for Estimated Percentage Rate is Empty for Percentage BoQ B%! Percentage $ 5 B%! ebPlease set the Formulla for the Estimated Percentage Rate in Figure Cell Highlighted in Red Color $^A@ $ 5 B%!T(VApzd $  B%!  $  B%!T(Vk $  B%!T(V $  B%!T(Vk0Chk for Last 3 Rows $ 5 B%! BPlease Enter the valid formulla for Cell Highlighted in Red Color $^A@ $ 5 B%!T(VF' B%! Percentage $ 5 B%! eBPlease Enter the valid formulla for Cell Highlighted in Red Color $^A@ $ 5 B%!T(VF' $  B%!Total in FigureseOPlease Enter the value as 'Total in Figures' for Cell Highlighted in Red Color $^A@ $  B%!T(VF' $  B%!Quoted Rate in FigureseUPlease Enter the value as 'Quoted Rate in Figures' for Cell Highlighted in Red Color $^A@ $  B%!T(VF' $ B%!Quoted Rate in WordseSPlease Enter the value as 'Quoted Rate in Words' for Cell Highlighted in Red Color $^A@ $ B%!T(VF'k $Check 2nd and 3rd Row should be Hide B%!\!6Please Hide the 2nd Row, This Row only for System Use A@F' B%!\!e6Please Hide the 3rd Row, This Row only for System Use A@F'k FA`d Apk k i x yAttribute VB_Name = "Module6" Function CheckDuplicates() '8 S.NoDing Start LastRowAveSheet.UsedRange.6s.Count - 1O0Col0umna3 in^@= m- 3 `("A13:L" & ).Int erior{lo@rIndex9xlNone boqvalidastatu2s"TLLhoop 18 W hile <=F Q-LChdPValuAQCStr(1 IC@CIf 0Len(~ 2).5) > 0 OrIC ThenG-$LTestD=*? @E7,B<>  QMEHN  P\@(S@cACXZ 0%E MsgBox "Please remove dE~b|s high l`t@[ BacHkgr xd `sor"Shr(131kFk)ElseaE[VI :FP:g::1Id: A;ItemPCode;C;  ;End Ifkub}E{ +Wend b`Av9 L "F"hCall Up`eCustomDocProppDT a^Reset@& Man` ory$@e= yyy|4}yyThisWorkbook.f ument!erti@"BLoQw")">NoG8u-Hsic  H{ are Not comed J"&`, pcOcorrect th e issy", vbCritlu9MA؇7 !'$ ) Cells(4, 1oO.CG 1, 4}"'Chk for Dom}PercqageR,28, 27" ^A( 0INR Onlyy0 g.Converstype as  rMp1):K Z!twj7KP%C1D1 p7` Disc­Q)D!P=down Se.l&3vbNulla!OAW3APe=/c04`/BlLans" rbe"୔Da ~5'+"Q5n8GYoh3O"-6R.39. u.OpCֲ#s .A X =3 oT `4? ct ;/ /ol/tW[/m/_>=&1/oK 'ôChk for Heading and Notnull from 4 to 12 rows FQr =TTT ActiveSheet.Cells(r, 1).Interior.ColorIndexlxlNonej8, 2520 If r <> 7 AwValu"eivbNStrThen  MsgBox "Please E id Datathe Row " & 3 Chr(1\3)+F3boqvalidationstatus\"F" Elsew= 8 w"Name of ^Bidd0er/ Firm / Company :" Word ''O ?P?Pé@ËP#Res etXlFas Bplank֖2n)ʟF'C S#Ois Emptyb8MCLP`(@3, 3).c(= ""U{5%USelect Qsr-k)NM,E8TN1*" in7╎a]CsasIf NePxt r'I n@(ρLasta- 1, 6).Numbermat, "%"#13 inAACount'M atory Fields `Checkc`155a`Or 2dҘc 100_0@r o should not exceed more `-anRCharsI^ ו .򇩑.4 4C5 dQtyF *#w.= .?Yc1B'5-er Qu0antinumnoo)Io`IAooyUnitи/#I}_]lwOO" l? 0 1/`(/ "b11 length..9d _JQJ257 EQJĠIII//////IRϝIF; H`HH??q"8Tz? 59 oMcoc'o` 1t1 boqvalidationstatus = "F" End IfLEls eIf cV13( Or54 0Then ^Not IsNumeric(ActiveSheet.Cells(r, c).Valu0e) As" <> vbNullStringsMsgBox "Please E nter 3id Data for K Columns S.No` " & D Chr(13)u;_I@ior.6orIndex3"у( Ř4[NR^=^^^^zÏR`LT`@mL ockedyTr ue8eGc + 1sQ iset the Rate as Blank ` @jProtecC!|j 1)jІ"j0dj;7m77G7=> 7@7à7Un77(7177U71!" > 0ԟ6C_ni6nMwOOzOTO߆O7okO7Nd} o7z OSOSOSqUOSOS  /!zo/S5/' ol20o]P"(cq  'K~'(P{TEXTw__5c'C'++Pz/"'_'_'q86ba2, 2%`Percentag|e"]GG;6'z֒ @oEstim2ˁB["Os_=; $5 $CA11__B11?2A8 od4 \ChoocConverQ Typews ;ionstatus = "F"  ElseIf ActiveSheet.Cells(2, 2).ValuevItem Rat@e" And^r, 4^<> vbNullStr(ing1caPartial Co nvers" 0ThenMsgBox "Please res@et the> type as FD for S.No " &d1) Chr(1<3)?gInterior.ColorInde x3"boqv@alidatPercentagvjINR OnlyuEBFuuB%uu "?v |4oo#waY TOot nAto ocoh/oeEIfKx6c{12%@1=( 6Ch ooठrid Currency42A_g__ 22_B?g_M2Fyۑ 7@ۡ7_j/5P'llIooOo oOl~4l R2QV7-# P_S4",߈W S, c - 1(ϏC_s%o; E] W2oPprPan < , w? ? ? ? ? ? ? ? ? ? ? i8? Ƹi "Select" Then @MsgBoxUlease res@et theas D Highlted in RCol" & Chrp(13)6m UInterior.A Indexy3aCall/PCustomDocPropExit Funom'Chk RatBeElse6`vbNullStringaPaB/\should be Blan9b ,b]bFormatdLBeSIn@g(ܪ@HNumberC1, "%") <= 0uSOk:@ " m%l l(_;llQuo8z:^s53m= mawem!9@sa.An Figure ߟnߟ( nR!EstiI3n',Ѩ3ٿ3 ,Ҷ34MK44` 0k/g`Z;4%P|_-||OK] v20Dt9If5).H~2Ex , 3 s'&ow &Evalid@m&A>ώώ ԎboqBaastatusF"#?#?-Sorϡϡ+" }d6:6"186"Total}^s?6J0k{''Be$$$$ $* ?ps}Voo 'O`tshĿ}? , d Wordooe ="l"OO0D2 XXeck 2a03rpÀHideYepP!ire\.den MFaP_|"P#!"YQ, onlsSystem UQpSS $3R=  ZP , This Row only for System Use "  boqvalidationstatus = "FxEnd If If R<>TenCall UpeCustomDocPropDT@ Else%Reset $"rzaFunc HiHiX a Z  ZrU@@@8`8q`brU@@@~xHiHiXHi a Z S alidastatus"TALLoop 18 While 1 <= Q-LChdValuAQCStr('If Len&(g).) > 0 Then/LTestO* S*!B<>  7E8 ;:ZA?CA@IsMH MsgBox "Please remove dEs hPighlt @Backgr@d orhr(13S/FEEnd If+F'Bp"BE+zeWend T?@< G GU"F"CC@all UpzeCustomDocPropDT 0 Els$Reset@D#ţ Sub HelpButtonmsgmor{CC4"For h` pE? fer H@to@ prepaBoQ @umen~t< iCells(2, 1)vbNulFl`!Or 2#| 'fDep@!9VThis Templ` does't support our apǀ. $]download th stVer3.@0 fromBD!s seofD e`5c P al", vbInm, "GePNIC \#Workbook.Clo=a>(@ t ContFa C A`?'-" "_#N'B2 "Warn!2messages , r: T>0 21A1.Zd0only/ 1.0 9.03 8ab/ #q22.& not DELETE!INSERT any colw between A *BCi 33 eaJBC, ifrQ  required si%y HI@DE it. s4g44 L 4wi>bU&at2%ti0@publish3`I7sg55MAZBidders, It-Price bid oper(sg66 M ODIFY commap(@pFs57q7S A 1D,2d 3B System u@gr,Eal0@u#( sg8q8. ALSAVE@"Ck F=> SaplpOK C@ LP1c2c3c4c5c6c7c8c1T??pG??>.?>հ/>*>P[پ(") <> "NCB$V4OB<Bh' BGr:a qerFata Entry A"CUT!ACOPYqPAjS BwD?#srg@DoE,z "nqǀ 0juctuoAGoArqvoX@cmOG@AJviohp pt1j@subjg]Kref,:W@////& b//.n,no/././.O#Yl/././.+.R.ng jp.)P?f1p...?s `hOin FhR'2s2~ 2A7?&2_2t~r22- rv2 tion this boq will be subjected to re,f the bid" & Chr(13) msg5 = "5. For SAVEVBoQ Click File => Sa"vOK MsgBox L_12345more, vbInforma, "GePNIC }Valid" End IfSub  PrintButton(gActiveWindow.SelSheets.Preview" rxME(6 <<<` X` ## ` $$# ` GXP% UW$*\Rffff*0<6489bd35JB  $0 4P(     0@ XxR   08@P "X "b J(x (D8@HLhXZj DTB0^xj>H <H` Zp B L jh > < BX H ` ZH B L @ H "P X h x Duplicate S.No Checking Start B!&!(!* '$-LastCol = ActiveSheet.UsedRange.Columns.Countx $ ' ZA13:L $ $j!T(VT' '  A X ' $j! '    A X ' $j! $j! $j!T(V $j!T(V;Please remove duplicate S.Nos highlight in Background Color $^A@F'kk  'k  'Duplicate S.No Checking End FA`d`ApkPiHX $^6For more help please refer How to prepare BoQ Document $^ $^' B%!  B%! efor DeptThis BoQ Template does't support our application. Please download the Latest BoQ Ver3.0 from the Downloads section of eProc Portal GePNIC BoQ ValidationA@ B@B B! B%! BoQ_Ver3.0eafor Dept Warning messages for Dept User: $^ $^'41. This BoQ only support GePNIC Ver1.09.03 or above $^'72. Do not DELETE or INSERT any columns between A to BC $^'T3. The Columns between A to BC, if any of the column is not required simply HIDE it. $^'E4. The Columns A to L will be read at the time of publish the tender $^'U5. The Columns M to AZ for Bidders, It will be read at the time of Price bid opening $^'/6. Do not DELETE or MODIFY the command buttons $^'?7. The Rows 1,2 and 3 for System use , Do not alter the values $^'-8. For SAVE the BoQ Click File => Save => OK $^'           GePNIC BoQ ValidationA@ B! B%! BoQ_Ver3.0 BoQStatus $%jNCe for BiddersWarning messages for Bidder: $^ $^'5msg1 = "1. Green Cells are for Data Entry " & Chr(13)32. Do not use CUT or COPY or PASTE while Data Entry $^'L3. Do not MODIFY the boq Sheetname or Structure or any other protected cells $^'F4. Any violation on this boq will be subjected to rejection of the bid $^'-5. For SAVE the BoQ Click File => Save => OK $^'        GePNIC BoQ ValidationA@ B! B%! BoQ_Ver3.0 BoQStatus $%jNCe for BiddersWarning messages for Bidder: $^ $^'5msg1 = "1. Green Cells are for Data Entry " & Chr(13)-1. Please enter the values in required cells $^'32. Do not use CUT or COPY or PASTE while Data Entry $^'L3. Do not MODIFY the boq Sheetname or Structure or any other protected cells $^'F4. Any violation on this boq will be subjected to rejection of the bid $^'-5. For SAVE the BoQ Click File => Save => OK $^'        GePNIC BoQ ValidationA@ko !B@o0Attribute VB_Name = "Module7" Function DuplicateSerialN@o() 'T S.No Checking Start LasPtRowAveSheet.UsedRange.6s.Coun`t - 1O0Col0umn30 in^@= Am- 3 `("A13:L" & ).Intor{lorIn(dex9xjne boqv__SRP_2__SRP_3( Module8Y__SRP_16 SPrU@@@8`8q`8`brU@@@@~x a$h.   @ `       ( H `      (Hh  0 08 h x    @X p 8 P `p     (  (0H`h px   (8P  h x          (8 H`hx   0@`h p    @P`x    (0 8H`x 08 @ Xpx  0@PX`hpx  0@PX`hpx  (08@HPX`p 0@HP Xhx  GrxME(6 <<< `X irxit@ @ @ @ 0 @  @ @ `@ @ @ @ @ @ @  "xX @$ `&. (( vhH`x`z`|`~`` `` ` ` ` ` ` ` ` ``` ```````````` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ``` ` ` `` ` *8  x %xH @ UW$*\Rffff*0F6489bd78 6 8 B@ B B  V N0 <  @ F N` X  T  >xD  0H`x 8Ph(@Xx0H`x0Ph  @ X p       ( H ` x       0 P h      (0 @ Xp(@X px     0HPX`x      8 P h x          !0!H!`!x!!!!!!  ! ! ! !"" "(" 0"@" 0DP" F# ##($($0$8$ H$/This function will work upto 99,99,99,99,999.99@;-- Updated on II/11/2011. Updated up to 9999 Thousan croresx;-- Modified as per requirement and updated as on 15/09/2011OAttribute Macro4.VB_Description = "Macro recorded 05/01/01 by Shailesh Agrawal"GAttribute Macro4.VB_ProcData.VB_Invoke_Func = "Normal.NewMacros.Macro4"6 Your comments and Feed back will be most appreciated. Macro4 Macro9 Macro recorded 05/01/2001 by Shailesh Agrawal Associates@ This macro is available free of cost at www.CharteredValuer.comG For Further inquiry feel free to contact on shashi@CharteredValuer.comR This is distributed as freeware. We do not take any responsiblity for any problem due to this macroN Updated to work up 9999 Thousand Crores of Indian Rupees. by KSR on 3/09/2011] 8Ph]( @]  ]d0Zero+vOne+vTwo+vThree+vFour+vFive+vSix+vSeven+vEight+vNine +vTen +vEleven +vTwelve +vThirteen +vFourteen+vFifteen+vSixteen+v Seventeen+vEighteen+vNineteen+vTwenty+v Twenty One+v Twenty Two+v Twenty Three+v Twenty Four+v Twenty Five+v Twenty Six+v Twenty Seven+v Twenty Eight+v Twenty Nine+vThirty+v Thirty One+v Thirty Two +v Thirty Three!+v Thirty Four"+v Thirty Five#+v Thirty Six$+v Thirty Seven%+v Thirty Eight&+v Thirty Nine'+vForty(+v Forty One)+v Forty Two*+v Forty Three++v Forty Four,+v Forty Five-+v Forty Six.+v Forty Seven/+v Forty Eight0+v Forty Nine1+vFifty2+v Fifty One3+v Fifty Two4+v Fifty Three5+v Fifty Four6+v Fifty Five7+v Fifty Six8+v Fifty Seven9+v Fifty Eight:+v Fifty Nine;+vSixty<+v Sixty One=+v Sixty Two>+v Sixty Three?+v Sixty Four@+v Sixty FiveA+v Sixty SixB+v Sixty SevenC+v Sixty EightD+v Sixty NineE+vSeventyF+v Seventy OneG+v Seventy TwoH+v Seventy ThreeI+v Seventy FourJ+v Seventy FiveK+v Seventy SixL+v Seventy SevenM+v Seventy EightN+v Seventy NineO+vEightyP+v Eighty OneQ+v Eighty TwoR+v Eighty ThreeS+v Eighty FourT+v Eighty FiveU+v Eighty SixV+v Eighty SevenW+v Eighty EightX+v Eighty NineY+vNinetyZ+v Ninety One[+v Ninety Two\+v Ninety Three]+v Ninety Four^+v Ninety Five_+v Ninety Six`+v Ninety Sevena+v Ninety Eightb+v Ninety Ninec+v One Hundredd+v]p]]]]]*==========================================]D ]D0 ]DH `]Dx ]D ]D ]D ]D  ]D8 Ph]D ]D ]D( @X]Dp ]D ]D ]0H`]x]]] 8P]hD4]D ]D  ( ]D@ ]DX ]Dp  ]D ]D  ]D  ' '!-- Limits in place 2004-09-23 ... t r Zero Only'z k tqvH7B High Value'z k t'   ' d$' ' $' $' $' $' ' $' Crore '| Lakh '~ Thousand ' Hundred ' ' ' ' ' ' ' ' ' '&' $ $- $ ' Minus'x MsgBox RABJI1d $ 'k   $ '  $ ' $ $ '  _B' $' $ ' $'  $v Thousand 'd ' CRORE = ""'kh d` KARANT8 = "" CRORE = ""'k   $ '  $ ' $ $ ' ʚ;' $' $ ' $'  $v Hundred 'd@ ' CRORE = ""'k d KARANT8 = "" CRORE = ""'k   $ ' $ ' $ $ ' ' $' $ ' $'    and 'k  $v 'd' CRORE = "" GXZP1 = ""kd''|'k`  $ ' $ $ ' ' $' $ ' $'  $v'd''~'kd''~'k`  $ ' $ $ ' ' $' $ ' $'  $v'd'''kd'''k`  $ ' $' $'  $v'd'''kd'''k  $ ' $'  $v'd@''k(d ''k    $' $''''  $v'd'kpdh'kX   '''k  $v'd'''k $' iocl code startPAISE = "Point"]d Zero+*One+*Two+*Three+*Four+*Five+*Six+*Seven+*Eight+*Nine +*'''$'' t'  .'Zero '' '  '   '  ' '   $'   $'d'  '   $''kx  ' X+. a$. +($. +($(+.$(X +"$"$*'$ $  '  ' Point 'd`'kP  ' X+. a$. +($. +($(+.$(X +"$"$*'$ $  '  'XdP'k@ ' Zero'& e Zero Zero'&d'&k rINR  & '#3AQ_ r x $    $    $   |$   $   ~$   $   $   $   $     $   $   and Paise $   Only 'z@+ GXZP7 + "Paise " + Trim(PAISE) + GXZP7 + Trim(PAST5) + " Only"d   & ' r x   Only 'zk z'i޶Attribute VB_Name = "Module8" 'This function will work upto 99B,9.99fOpVExplicit '-- Updated II/11/2011.up O99 Thousan crores=ifi>as per requirement and]`15/09`FSpellNumber123(s As Sng, kapilDoub(le)'Ma H4.Desc1/01 by Shailesh Ag`rawal(ProcData.Invoke_ZNormal.New@s.C$ Your coJmsFe@backbe mosppreci. !0201Hso7gkm@av@ 9 .  "Hig"h lue9 BINDRZ 8- Int()2Round((* 100), 0 cA2^3@2e4`Valb3‚(}%1 1AJEB!  CR N" Crore;LAKBH"Lakhthousa?TI(HU$EDH red dE0`!I&I߆! 5 SQa\@& C(Left(Trim(#b`11))-" P Dq= Abs@&AfMinus" 'MsgBox ElseaZ D+! Len(S) ^>P"dRRp*t4, 1W&#) -}.(tC3 /q*0#@ "4q5, A6a?7?Pa!?ordsd 7)l +0@& 8',% @p B'$r* 8 9?rhtPC9pw?n "Q  77C1_5q__= __5 624v XY\P3sA+  8 1^ } ~8ue [S5sU, 5%W3QW8%Q= PyҗNcBdPq r$ s> PQ#c" F/ y 1h}i3c֍=KkB1 1q2Dgg"hbs!!Y acK If Len(RABJI1) > 2 Then BORIS = RighBt, 3)hCYRUhLeft"(N, 10OS1hVal(J*G0> 0 @ ERUPT+wpords-!.Elsed ""HUNDRED1AGXZP4End If =\* 9 71TZZARS2TDOZAL@v $ vFLITIEwvoXYZn f: ""'> *"+c(@= CDbl(Do Until0"@ l(b"\ 1* "Modj=G a(cCFl  RnaGT%+d " + $enA" ALoopC' % aT7i."c /n%! "y)q//2// /ss(. /W! b,  yqTƅ apstdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft SGXZP2GXZP3GXZP4GXZP5GXZP6GXZP7HARP1opHARP2ppHARP3qpHARP4rpHARP5spHARP6tpHARP7upJANTIJANTI1JANTI2JANTI3KARANT1KARANT2KARANT3KARANT4KARANT5KARANT6KARANT7KARANT8KARANT9KARANT10ujLINZUR1LINZUR2LINZUR3LINZUR4LINZUR5LINZURqPAST1PAST2PAST3PAST4PAST5PAST120RABJI1XORE6\XORE7\XORE8\XYMEOXYZFLITIESI*ZZARTORoundStrValTrim@Right  Sheet2 Module2c(CurrencyListItems5CellsValueK EntireColumnHidden]MsgBoxRboqvalidationstatus vbNullStringReplacefLastRoww UsedRangeȉRowsUCount0vricZstrCurrencyNamey Validation DeletexxlValidateListĤ AlertStyle7xlValidAlertStopOperatork xlBetweenkFormula1 IgnoreBlankRInCellDropdown9(DropDownforPercentageBoQOptions(DropDownforMCLR$ DropDownRowR mclOptions1 mclOptions2 mclOptions3Interior; ColorIndex(BoQTypeBasedColumnsDisplayxlNone EntireRowChrK~(UpdateCustomDocPropDT boqstatusSDocumentProperty&V boqversion boqcharttype4dCustomDocumentPropertiesޖ(UpdateCustomDocPropBTI(ResetCustomDocPropBT(ResetCustomDocProp{ShowRowTotalWithOutTaxes'ShowRowTotalWithTaxesShowColumnTotalWithTaxes0 ShowSummary FormBasedDRank CSType*ErroNumber- LinkToContentLmsoPropertyTypeString4msoPropertyTypeNumber Module3d(allinone ProtectContents(CheckDuplicates+(MandatoryColumnsValidate$(BoQValidStatus(BiddersColumnsValidate vbCritical+}(total_amount_ba!boq_type3 is_globalvqtyestimate5iadd_less0 convert_typezratek (total_amount_bb_dgsnd Basic_rate|Tax_typeS ED_structureED_rateK Module4ebc\BoQ1SheetFoundsc_ActiveWorkbookSheets  Module5f intRowCountČAtleasetOneItemFilledD NumberFormatR IsNumeric$*Locked  Module6gLLoop\& LChangedValueKLChangedValueICG LTestLoop LTestValue LTestValueIC^H Module7h( DuplicateSerialNo0x ( HelpButtonmsgmoreu vbInformationnmsgQmsg1cmsg2dmsg3emsg4fmsg5gmsg6hmsg7imsg8j ( PrintButton ActiveWindow+SelectedSheets PrintPreview Module8i( SpellNumber123#len1|len2|p_exist total_leni`from1\to1from2\to2l_strpr_strSc_l_str.~c_r_strDec_StrVTmp_StrQ total_strRaXurwords^ app_extraPlcwordss`Workbookk BeforeSave BeforeClose~; SheetChangeWa @ *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#C:\Program Files\Microsoft Office\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library UW r ThisWorkbook0?6489bd35%ThisWorkbook`"Sheet140C6489bd77mSheet14Module10=6489bd35nModule10B Sheet20@6489bd35 Sheet2dHModule20A6489bd77Module2]`WAModule30B6489bd77Module3 `xModule40>6489354506489775Ѣ606489776270<6489bd35Module7Module80F6489bd78Module8G0x`yW3JS"0k!6Cn}B$9Gl@'lqLFP=Ш)R6C2=M#A>8b"Д)' "h MinusQ5k @`"h and  Only&m A 8Excel Files (*.xls*), *.xls*Q5S aUb[A FalseF!QaGi1 &mA&m1 &mF&maG&mQName BoQ BoQ1 ZBoQ Sheets should be Ordered BoQ1, BoQ2 ... :(~CurrencyListItemsDropDownforPercentageBoQDropDownforMCLBoQTypeBasedColumnsDisplayUpdateCustomDocPropDTUpdateCustomDocPropBTResetCustomDocPropBTResetCustomDocPropActivate Cells Value2 Please reset BoQ Version and BoQ Type values in the Cell A1 and B2, which should not be Blank  BoQ_Ver3.0& Please reset BoQ Type values in the Cell B2, which should not be Blank  BoQChartTypeQ5` ai$ Please reset BoQ Chart Type values should be same as CustomDocProp  FormBased Yes Item Wise0 Please reset Form Based values should be No OR all the sheets contains only Item Wise BoQ  CR CC fPlease reset 2nd row values should be same as BoQ1 UsedRangeRows Count Alternate rPlease reset itemcode/make values should be same as BoQ1 allinoneBoQValidStatustotal_amount_batotal_amount_bb_dgsnd BoQStatus >Please sheet name should be BoQ NC ^Please assign atleast one sheet should be BoQ1 !Q@˜C̢_M}}')O v^I[ProtectContents, Invalid BoQ!!! Please download the BoQ from the Downloads section of eProc Portal aCheckDuplicatesMandatoryColumnsValidateBiddersColumnsValidate zPlease download the correct BoQ from the eProcurement portal  ZPlease Enter the Bidder Name for the Cell B8  MCL % Select ^Please Enter the Bidder Status for the Cell E8  Percentage ZPlease Choose Option C1 or Option D1 for Row  hPlease Enter the Percentage Type Option for the Row  ZPlease Enter the Percentage Rate for the Row NumberFormat" ~Please Enter the Valid Data Format Percentage Rate for the Row ( Please Enter the Valid Data in Quoted Percentage Rate in Figure for the Row Q51 au`Z  LPlease Check the Quoted Rate for S.No  Item Rate Locked JPlease Enter the Basic Rate for S.No  bPlease Enter the Basic Rate for atleast one Item  VThe Basic BoQ validations are Not complied  8 , please correct the issue  VThe Basic BoQ validations are complied for  R , protect the sheet and proceed further  INR Only* Please Ensure that the formula for Column BA (AMOUNT) and Column BB (ONLY TAXES) SpellNumber123L__SRP_1' PROJECTwmPROJECT)SummaryInformation(,   wilskapil q SaveAsUICancelSh q 0Target qPboq_type is_globalqtyestimateadd_less convert_typerate Basic_rateTax_type ED_structureED_ratezThisWorkbookThisWorkbookModule1Module1Sheet2Sheet2Module2Module2Module3Module3Module4Module4Module5Module5Module6Module6Sheet14Sheet14Module7Module7Module8Module8ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Module=Module1 Document=Sheet2/&H00000000 Module=Module2 Module=Module3 Module=Module4 Module=Module5 Module=Module6 Document=Sheet14/&H00000000 Module=Module7 Module=Module8 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="BCBE10D6709674967493799379" DPB="787AD43BF13BF1C40F3CF10562CF41AAC53538BACF22AD2BBF333CBA5EB9370A804E7DA3" GC="3436985EE81BE91BE91B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=75, 75, 1237, 525, Z Module1=200, 200, 1362, 650, Sheet2=0, 0, 0, 0, C Module2=150, 150, 1312, 600, Module3=175, 175, 1337, 625, Module4=125, 125, 1287, 575, Module5=100, 100, 1262, 550, Module6=175, 175, 1337, 625, Sheet14=50, 50, 1212, 500, Module7=175, 175, 1337, 625, Module8=125, 125, 1287, 575, Oh+'0HPhx AdministratoruserMicrosoft Excel@ui @N@ӕyn՜.+,D՜.+,$HP X`hp x  MacrosBoQ1!Print_Area  WorksheetsDocumentSummaryInformation8CompObjk Named Ranges h';KWco {    BoQStatus BoQVersion BoQChartTypeSRTWOTSRTWTSCTWT ShowSummary FormBased Rank CSTypeCR BoQ_Ver3.0NormalYesYesYesYesNoL FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q