Standard Jet DBnb` Ugr@?~1y0̝cßFN!a7ޜa(,`{6R߱nCh53y[5/|*|S$jf_Љ$g'DeFx -bT4.0dv Y*S ** Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OY|S)Y Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YkSkY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/ @@@A"d@ @   @@@ @@@@@@Y`fdim+fiYbmMd``dbOYJ^dUJfYMd`LYbQO+QkmY`JmQ+iQfdimQkm+YmQ`+ko`+kdim+Lv+MdkmQkmMd``QbmkQkmY`JmQ+YmQ`+ko``Jiv+iQfdimQkmY`JmQUidofJO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+OMd`LYbQO+QkmY`JmQ+iQfdim+kh+OMWY^O@6+kh+OQkm+YmQ`+ko`+kdim+Lv+Mdkm+kh+OMWY^OB6+kh+OQkmY`JmQ+YmQ`+ko``Jiv+iQfdim+kh+OMWY^OB6+kh+iQkmY`JmQUidofQkmY`JmQQkmY`JmQUidofQkmY`JmQYmQ``kvkJMMQkkkmdiJUQ `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhivMd``Qbm!hivSYubo^^fiYMQ"hiviQfdim#hiviQfdimkdimLvMdkm$kQ^QMmOYkmYbMmYmQ`k%mQkm&mQkmOQ^iQMk:'JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOQkmY`JmQQkmY`JmQYmQ`(`kvkJMMQkkkmdiJUQkmUiQ^)  @ @ @ @ @          !"#$%'() K&  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @PPPPPPPPP P P P PPPPPPPPPPPPP$P% P& P' P( P) P* P+ P2 P3 P4 P5 P6 P7 P8 P9 P:P;P<P=P>P?P@PAPBPCPDPEPFPGPHPIPJPKPLPMPNPOVVVVVVVVVVV V!V"V#V$V(V)V*P,P-P.P/P0P1V VVV V VVVVVVPPVVVVVVVVVV V KV%KV&KV'PPPP PP PPPP!P"P#Y @ @ @ @ @ @ @ @ @ @ @ @ @           !"$%&'()#*,-./012345 6 7 8 9 :;<=>?@A+BDEFGHJJJJJ J J J J J J J J J  JCJJJJJJJJJJJJJJJJ J J!J QkmY`JmQQkmY`JmQYmQ`N`kvkJMMQkkkmdiJUQkmUiQ^N QkmY`JmQYmQ`N`kvkJMMQkkkmdiJUQN QkmY`JmQN`kvkJMMQkkkmdiJUQNU*d _ N [  v r  Q Hq40G]DxIEC_A$IzT@IzT@MSysAccessStorageSTGREL+PIzT@IzT@MSysAccessStorageSTGREL+PPPPPPPPPPN t(R @t(R @EstimateEstimateItem+JJJJJJJJJJH TKx^ @[^ @test+@^666*******( @@j @J&l @selectdistinctitems+@^`@Q`TTHHHHHHHF @ƳT @$ @qryReportsortbycost+@^@U`TTHHHHHHHF @ؾ @^ @qryReport+:@]@UL@@44444442 @T @"h @qryComment+@]`@UNBB66666664 @IzT@IzT@ MSysAccessStorage+DDDDDDDDDDB Qi @֑ @EstimateItem+[ FFF:::::::8 @s @D ۑ @EstimateGroup+| @ZHHH<<<<<<<: @T3C@3C@~sq_rEstimateGroup+4MR2KeepLocal TFFFFFFFD @ @ @~sq_dEstimate_Item_Summary_Report~sq_dChild60+4MR2KeepLocal T|||||||z @E @hS @~sq_dEST_ITEM_SUM_SORT_BY_COST~sq_dChild60+4MR2KeepLocal Tvvvvvvvt @T 4 @\TS @Admin+@U8,,,,,,,,,*  @ @EstimateGroup+V@RHHH<<<<<<<: @,51@,51@Estimate_Item_Summary_Report+@SfffZZZZZZZX @ 6$+ @6$+ @EstComments+R@SDDD88888886 @T 6z4@6z4@Combined_Estimate_Report+R@R^^^RRRRRRRP @ %3 @%3 @CommonDialogAPI+@@@@@@@@@@>  ȳ7 @ȳ7 @IMPORT_PRINT+T@RFFF:::::::8 @ C̮@C̮@UserDefined+A@RDDD88888886 @ C̮@gT@SummaryInfo+@RDDD88888886 @ Ϊݮ@z}T@AccessLayout+4MR2KeepLocal T.@Qzz:::::::8 @C̮@C̮@SysRel+.........., C̮@C̮@Scripts+0000000000. C̮@C̮@Reports+0000000000. C̮@C̮@Modules+0000000000. C̮@C̮@Forms+,,,,,,,,,,* ̮@̮@DataAccessPages+@@@@@@@@@@> ̮@xž @MSysRelationships*@ZPPPDDDDDDDB @̮@̮@MSysQueries*88888888886 ̮@̮@MSysACEs*22222222220 ̮@̮@MSysObjects*88888888886 ̮@UϾT@MSysDb+@R:::......., @̮@̮@Relationships*<<<<<<<<<<: ̮@̮@Databases*44444444442 ̮@̮@Tables*.........., InP2J, | N  Y  K J  n P 2  hr<}?u1r0d!iw7Estimate.LettingDate3 gEstimate.EstimateId2 gEstimate.Description3 gEstimateItem))) Estimate!!!   GEstimateEstimateItemV@IE9! Estimate.SpecYear0 gEstimate.UnitSystem2 gEstimate.Comment/ gEstimate.EstimatedTotal6 gEstimateItem.groupnumber7 gEstimate.unique_items4 g EstimateItem.ExtendedAmount: g EstimateItem.UnitPrice5 g EstimateItem.Quantity4 g EstimateItem.Units1 g EstimateItem.Comment3 gEstimateItem.Description7 gEstimateItem.ItemCode4 gEstimateItem.LineNumber6 gEstimate.CountyDescription9 gEstimate.Estimator1 gEstimate.LettingDate3 gEstimate.EstimateId2 gEstimate.Description3 gEstimateItem))) Estimate!!!   GH@I 'EstimateItem.ExtendedAmount0UG wEstimateItem.UnitPrice0K= wEstimateItem)))  G G  GEstimateItem.Comment>""6 'EstimateEstimateItemV@IE9!  EstimateItem.ExtendedAmount: g EstimateItem.UnitPrice5 g EstimateItem.Quantity4 g EstimateItem.Units1 gEstimateItem.Comment3 gEstimateItem.Description7 gEstimateItem.ItemCode4 gEstimateItem.LineNumber6 gEstimate.CountyDescription9 gEstimate.LettingDate3 gEstimate.EstimateId2 gEstimate.Description3 gEstimateItem))) Estimate!!!   GEstimateGroup+++   G  GEstimateGroup+++   G  GEstimateGroup+++   G  GEstimateGroup+++   G  GH YN'%' Y  Y  Y  Y 0 Y  Y F Y F Y  Y  Y F Y F Y  Y  Y F Y F Y  Y  Y F Y F Y  Y  Y F Y F Y  Y  Y F Y F Y  Y  Y F Y F Y  Y  Y!!! F Y""" F Y### Y$$$  Y%$% FY&%& EstimateIdDescriptionEstimatorPreparationDateLettingDateEstimateType.EstimateTypeDescriptionWorkType&WorkTypeDescriptionHighwayType,HighwayTypeDescriptionUrbanRuralType2UrbanRuralTypeDescription County"CountyDescription Season"SeasonDescriptionCheckedByDateCheckedApprovedByDateApprovedUnitSystemCatalogSpecYear$PriceRoundingLevel*QuantityRoundingLevel,ExtensionRoundingLevel.PercentageRoundingLevelTrnsportFlag,TrnsportPriceBasesFlag$EditPricesOnlyFlagComment.EstimatedCostUnfinishedEstimatedCost$ContingencyPercent0EstimatedTotalUnfinishedEstimatedTotalPINunique_itemsF%EitMAYY$EstimateeSTIMATEiD EstimateTANUMBERv1@P'@VSAMPLE01TAA 08-000Harold Crusan2008/06/04ALBANYMNYSTAcatalog.cat95]]]]]]]]]]]]]]YGEEEEEEE==========11" %@PkJ`f^Q68  [YN Y  Y g Y  Y ( Y Tq Y qFY  Y TdGroupNumberDescriptionAlternateCodeCommentUsedInTotal(GroupTotalUnfinishedGroupTotalESTIMATEiDFqTFqTFTqFY*EstimateGroupTANUMBERv1BT0002Group 002 - 100% Verizon FundedYSAMPLE01C33111 e0001Group 001 - 100% Thruway FundedYSAMPLE01C33111 @kJ`f^Q68kJ`f^Q68. YN Y  Y  Y  Y 0 Y , Y F Y F Y , Y , Y F Y FY  Y , Y FY   Y  , Y ,LineNumberItemCodeDescription.SupplementalDescriptionDRequireSupplementalDescriptionFlagComment UnitsAlternateCodeIsAdHocPriceQuantity&UnitPriceUnfinishedUnitPriceUsedInTotal0ExtendedAmountUnfinishedExtendedAmounteSTIMATEiDgroupnumber,F,FF,,F,FF,YY(EstimateItemTANUMBERItemCodev1 x ~U  0008651.99083125FIBER OPTIC DISTRIBUTION CABLENWill place 5' deep to avoid other utilities in area.MY100.00YSAMPLE010002~HFF&@B0006402.0972019.5MM F2 SUPERPAVE HMA 70 SERIES COMPACTIONNMTY300.00YSAMPLE010001ysccaaYWWSSQQ$I0004207.13GEOTEXTILE SLOPE PROTECTIONNSQMY100.00YSAMPLE010001f`PPNNFDD??== 0002201.06CLEARING AND GRUBBINGNLSY1.00YSAMPLE010001]WGGEE?==9977  @ kJ`f^Q68kJ`f^Q68kJ`f^Q68kJ`f^Q68  @:686B:6D8<>6:6HD:68B@8HH6F<8:@ RYFTNFFFFFFFY Y Y F Y  Y `Y FY FDateCreateDateUpdateIdLvNameParentIdType,F,FFF,,F,FGF,,F,FHF,,F,FOF,YYYYY.rEId.MSysAccessStorageSTGRELParentIdIdParentIdName v1b @ ?  20@  . D a  l  R DnT:k&v3X P=zT@=zT@5 @5TypeInfo2:62" =zT@=zT@4PropData2PLH8 =zT@=zT@3; Blob22.*" =zT@=zT@23"  w=zT@T@1BlobDelta-0,( w=zT@T@0@5TypeInfo-:62" =zT@T@/PropData-PLH8 =zT@T@.GJ6 Blob-2.*" =zT@T@-2"  w=zT@T@,BlobDelta(0,( w=zT@T@+@5TypeInfo(:62" =zT@T@*PropData(PLH8 =zT@T@)K0 Blob(2.*" =zT@T@(1"  w=zT@=zT@'@!BlobDelta#<84" =zT@=zT@&@!TypeInfo#:62" =zT@=zT@%PropData#PLH8 =zT@=zT@$. Blob#2.*" =zT@=zT@#0"  w=zT@=zT@"Reports,($ w=zT@=zT@!PropDataCopy62. w=zT@=zT@  0CB0PropDataIEA1 =zT@=zT@("CommonDialogAPIDirDatab^ZJ =zT@=zT@PropDataCopy62. w=zT@=zT@ PropDataGC?/ =zT@=zT@0  w=zT@=zT@Modules,($ w=zT@=zT@Cmdbars,($ w=zT@=zT@; 0CB0 1CB0 2CB0 3CB0 4CB0PropDataCopy}yu] IzT@=zT@ 0CB0PropDataIEA1 IzT@=zT@"IMPORT_PRINTDirData\XTD IzT@=zT@@!BlobDelta<84" IzT@=zT@c@$TypeInfo:62" IzT@=zT@PropDataPLH8 IzT@=zT@, Blob2.*" IzT@=zT@0  wIzT@=zT@Forms($  wIzT@=zT@ @$YROKWDKRJVLORDVWZGOZDNZHQTVNb^Z" IzT@=zT@ `% YDLWEE_PDLOQHEPBSGKFFWBJIMREb^Z" IzT@=zT@ 5@$TRVNLMJWGPGBXDAGRUYQKGOLLOKHb^Z" IzT@=zT@ 8@!SHZMBUBENPWWODJYBLUYMVGMZBUKb^Z" IzT@=zT@ " JTWWLSMMESARRDZXLBGFIDARXHE_b^Z" IzT@=zT@@!AOXSAMCZKHBBODTBHQYZFKSFVMCIb^Z" IzT@}T@VBA$  wIzT@}T@VBAProject2.* wIzT@}T@VBA$  wIzT@IzT@MSysAccessStorage_SCRATCHPLH wIzT@=zT@MSysAccessStorage_ROOTJFB wLVALA &EstComments`@`B`D`F`H`J`L`N`P`R`T`V`X`Z`\`^ A`X8ib,!`i Adif ,!dxX i  ,hijilinip8i rp %`t,x!ijilin0ipPi z %`t% m H  H   (08@HPX`hpx  "  B"   B(08 B@ PX ` hx    0 @ PX ` xB     (8@X`h x         xph^^^^0^H^`^x^^^^^^^ ^8^P^h^^LVAL^p0]@]@ b'\mX \'`m f'^m ^'dm x]X]x r r94 j96 l98 p9:9@$\9BD r!B 9D r!B9F r!D9H n9J Select Database 9L9Nq r$*'t tnone'\'^d r!B$v'\'^kxip ]p] z z94 j96 l98 p9:9@$\9B z!B 9D z!B9F z!D9H n9J Save File 9L9Nq z$2't tnone'\'^dX z!B$v'\'^k0i( Attribute VB_Name = "CommonDialogAPI" Bas0{FCFB3D2A-A0FA-1068-A738-08002B3371B5} |GlobalSpacI False dCr@eatablPredeclaDIdTru BE`xpose`TemplateDerivCus tomizDOption p@ DT  <licit L P/3 DV FuncGetOpenFileLib "comdlg32.dll " Alias " A" T(pfnAs OPENFILENAME) !Long@Save$ 3 Typ"e) lstructsize-hwndOwnerIns8tan@9A lp2t S?CrnMaxGOhIndex "E-f 8Tit/ AxeG InitDiBCI`Flags !O ffsetIn`teger1bExtens[ Def AJ'` fnHookEo^ End^ ECEhm#(E:Q:a .:;:lp9X:"@":c.Ϝ: !:tr:/? ::#:itZ(2D: ?:p?:p4:?:P?:?:?:1?:?:mx'a?:?:_LVAL !ͬr({Ay_aDetailh cmdIMPORTXMLh cmdCOMBRPTh cmdESTITEMh  cmdPrint_to_wordh  cmdPRINT_SUM_TO_FILEe Box11e Box12d  Label13h cmdPrt_Comment_FileeBox17h cmdPrt_CommenteBOXsORTEDpRINTOUTh cmdPrt_Sorth cmdPrt_Sort_FileWxME (S<S<S<<N0{279F1051-988E-463B-845E-E06165D0925A}0 ~x@i` ii& %x  "  "  ( @ ` VPx]`o`x error messages text box 42 =IIf((([UNITS]<>"LS") And ([units]<>"DC") And (CLng(CSng([unitprice])*100)<>CLng(CSng([Text30])*100))),"Error - Unit price must be equal in all groups","")Ztext box 40 =IIf(([unitprice]<>1) And [units]="DC","Error - DC unit price not = $1.00","")P text box 38 =IIf(([Text20]<>1) And [units]="LS","Error - LS Qty not = 1.00","")xoIAttribute VB_Name = "Report_Combined_Est@imate_`"D Basl0{279F1051-988E-463B-845E-E06165D@0925A} |G lobal{SpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplAqDerivCustomizD$Option ep@ DT 0 P&* Sub Open(Cancel As Integer) Dim FullSpecyearSπng End!)Header_For-, Count 9' error messages ' text box 42 =IIf((([UNITS]<>"L S") A#([ unitsDCCLng(CSBprice])*100)<>%T30D)),"EB!- U mZ be equal in all groups",""5K'G*0D*<>1C*s]=")1GDC 0not$1.00A38E-20<ELS Qty pDKxME (S<S<S<<N0{B08D816B-C900-4CB7-AC50-5931354633FD} $@i`i&%H "   xoh`8Attribute VB_Name = "Report_Estimate_Item_SummarDy_p" Bast0{B08D816B-C900-4CB7-AC50-5931354633FD} |GlobaBlSpacIFalse dCre atablTru PredecdlaId"E`xpose_TemplxDerivCustomizD$Option Comp@ DT P&* Sub GroupFooter1_For(Cancel As Int@eger, CPount )&End$ LVAL & ( FxME PS<S<S<<(<< > D0 Bx F 6 <@ F > :! H! X!h!p!H!! 2!" "" " "(" 0" 8"P" h"p" x""" " """ " "" "" "### " #(# 0#  8#X# p#x# ### #"## # $## $$ $$($ 0$"8$@$ H$ P$h$ $$ $$$ $ "$$ $ "$$ %%  %(%8% @% "H%P% X% "`%% %% %%%% B %%%%%& & &(&H&`& & & & & & && '' '(' "0' 8'H'x3 coded by Dave Kent and modified by Jerry Anania toLVAL(' programatically import XML into tables< read in XML data as text to load header info and group info- setup tables to allow report needs to be met version 13 10/5/2006"On Error GoTo Err_cmdCOMBRPT_Click]@Combined_Estimate_Report'   B@p|h` !A@Ho@X0]Estimate_Item_Summary_Report'   B@| !A@o:ALLOWS USER TO SELECT MDB DATABASE TO SAVE ITEM HISTORY TO9OR SELECT PREVIOUSLY CREATED ITEM HISTORY FILE FOR REVIEW]]](]@]X]p]]]$.]]]0]H]`]x]]] !'j !'lC:\'n*.XML'"ALLOWS USER TO VIEW ONLY XML FILESXML Files (*.XML ) $*.XML$'pM Next line calls the WIN API that brings up the browse/select file dialog box j l n p %h' !`'-if valid file or a file was selected the code !dGoTo skipdeleteUDelete records in existing tables to allow the XML Import function to append new dataDELETE Estimate.* FROM Estimate B@=DELETE EstimateRegressionModel.* from EstimateRegressionModel B@7DELETE EstimateAverageModel.* from EstimateAverageModel B@9DELETE EstimateMarketAreaMap.* from EstimateMarketAreaMap B@CDELETE EstimateItemReferencePrice.* from EstimateItemReferencePrice B@CDELETE EstimateItemPriceBasisList.* from EstimateItemPriceBasisList B@ODELETE EstimateItemCostSheetMaterialSet.* from EstimateItemCostSheetMaterialSet B@IDELETE EstimateItemCostSheetLaborSet.* from EstimateItemCostSheetLaborSet B@QDELETE EstimateItemCostSheetEquipmentSet.* from EstimateItemCostSheetEquipmentSet B@'DELETE EstimateItem.* from EstimateItem B@3DELETE EstBidCoeffSetNode.* from EstBidCoeffSetNode B@5DELETE EstimateAreaMapNode.* from EstimateAreaMapNode B@SDELETE EstimateBidRegressionModelCoeffSet.* from EstimateBidRegressionModelCoeffSet B@)DELETE EstimateGroup.* from EstimateGroup B@ADELETE EstimateItemBidBasedPrice.* from EstimateItemBidBasedPrice B@:DELETE EstimateItemCostSheet.* from EstimateItemCostSheet B@DELETE TEST.* FROM TEST B@ !`'You Selected this file: A@this section brings in and appends data from xml file does not have a problem with the TANUMBER field in table not existing in XML  B@dA file not selected so controlreturns to form with no action takeng No file selected. Either no file selected or file name incorrectly entered. No XML inported. Try againA@kpRead in txt file to get ESTIMATE header data because ACCESS does not bring in the estimator ESTIMATE header info(Need to see if can determine the problem ' A little error checkingTEST''t $ ~ ' the file exists, it's safe to continue, read in XMl as text and place in test table$.  ImportErrors B@test %.   $b   C@ $ testxmlstring;C@q Vv grab needed fields related to general project info and assign to variable for later updating of estimate table record '  't t(  With rstEstimateInfo .AddNew  .Fields(0) = InputBuffer  .UpdateEnd With $v'>'<'  $   $' 'k` $  $' $'k t 't VDELETE Estimate.* FROM Estimate B@]$.selectdistinctitems %.  ! ' B@B-load general project info into estimate table$.Estimate %. C@ ; ; ; ; ; ; ; ; ; ; ; ; $; &;C@q EstimateGroup %. 5UPDATE EstimateGroup Set ESTIMATEGroup.ESTIMATEiD = ' ''  B@qX EstimateiTEM %. 3UPDATE EstimateiTEM Set ESTIMATEiTEM.ESTIMATEiD = ' ''  B@q B@B B@B't/run query to remove all unnecessary XML records testdelrecs2'    B@ynext section gets group numbers and inserts the group number into the appropriate lineno record in the estimateitem table$.test %. C@ C@"bp k After running the previous code the table test has one record for each group and one record for each item. a the test table is arranged by group with each item in the group in sequential order in the table  Group 1  linnumber 1  linenumber 2  linenumber 3  linenumber 4  Group 2  linnumber 5  linenumber 6  linenumber 7  linenumber 85$ $  5$$ 'dh5$ $ '4UPDATE EstimateItem Set ESTIMATEItem.Groupnumber = ' $' where ESTIMATEItem.LineNumber = ' ''& & B@k t 'tC@(5xkqxDim dbsNorthwind As DatabaseDim fldLoop As FieldDim relLoop As Relation]]0Set dbsNorthwind = OpenDatabase("Northwind.mdb") . Display the attributes of a TableDef object's fields.T;Debug.Print "Attributes of fields in " & ' .TableDefs(0).Name & " table:" *5. )Debug.Print " " & tdfLoop.Name & " = " & *!', ,EstimateKT do nothing EstimateItemKT do nothing EstimateGroupKT do nothingtestKT do nothingSysAccessObjectsKT do nothingSysACEsKT do nothing SysObjectsKT do nothing SysQueriesKT do nothingSysRelationshipsKT do nothingS` Delete or other tables  , B@n  *q5DoCmd.DeleteObject acTable, "EstimateRegressionModel"2DoCmd.DeleteObject acTable, "EstimateAverageModel"3DoCmd.DeleteObject acTable, "EstimateMarketAreaMap"8DoCmd.DeleteObject acTable, "EstimateItemReferencePrice"8DoCmd.DeleteObject acTable, "EstimateItemPriceBasisList">DoCmd.DeleteObject acTable, "EstimateItemCostSheetMaterialSet";DoCmd.DeleteObject acTable, "EstimateItemCostSheetLaborSet"?DoCmd.DeleteObject acTable, "EstimateItemCostSheetEquipmentSet"0DoCmd.LVAL*DeleteObject acTable, "EstBidCoeffSetNode"6DoCmd.DeleteObject acTable, "from EstimateAreaMapNode"@DoCmd.DeleteObject acTable, "EstimateBidRegressionModelCoeffSet"7DoCmd.DeleteObject acTable, "EstimateItemBidBasedPrice"3DoCmd.DeleteObject acTable, "EstimateItemCostSheet" B@B B@B't 0"2B@46The file has been imported. Hit OK button to continue. 8$'6d0, the file isn't there. Don't try to open it.ko(<]h EstComments'   B@>|< !A@>ho`BP] EstComments' F  B@DH|B !A@HoL]Combined_Estimate_Report' F  B@DN|Lx !A@N`oX0RH]pEstimate_Item_Summary_Report' F  B@DT|R !A@ToX] testdelrecs'    B@Zx|pXh !A@ZPoH^8] EST_ITEM_SUM_SORT_BY_COST'   B@`|^ !A@`o8d]xEST_ITEM_SUM_SORT_BY_COST' F  B@DfX|PdH !A@f0o(]]0]H]`]x>'<' h  r 'j h j$ 'h h  r 'n n   $v'p p  r 'n p n$ 'p h p'hd h n$ 'hk h'ioAttribute VB_Name = "Form_IMPORT_PRINT" " Bas0{142872AF-1C7B-41D9-B1F0-79125FEB 61E3} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ DT ' cod&by ve Kent and modifi Jerry Anania toprogramatically import XML into msd  d; as text$ load @headerfo@/<= Me.> <= @on.hWndAccesss>:\ *._`'^VIEW ONW US %`Eb Hs ( ) " & Chr(0:)"& 2 N5elP ibhe WIN @. t@hat brs ebrowse/select$ f dB1 box2T*= 3[KA 3(, ,^Ea0 0g"T/@ if `validpiaݓws yt |0 If Status$ Then_'mski4pdtd'D# ucortin exi03"mwI~funcrap@md n`EQ~b0gqpRunSQL ""DPTE e`.* FROM# ?8Regr) Ml from/&_Aag>e`Ma rketAMa>p QrReBeXce-QisL@ emqCostSheettMr5Wermet??:LaboreO@Equipm b__Q?emBidCoeffN/?4*b\7U =G-B1d-__A,h. ~T`Pc.vcRt"You S]ctbisd:s8Y'th~spr`]s ] rUxmlhdoes not haa @m withve TANUMBERRe2fPpef!gQSouζrce:=selfilename, ImportOptions:=2 Else '  not ected so controlreturns to form wiDthV ac takenMsgBox " NG*{M. E4er6jfor{ incorrly entered.KXMLTry again"uGoTo alldonEnd If @ 'Read txt1_get ESTIMATE hIdata becLVAL+ause ACCESS doesUt bring"he estimatCY!info9Ne3see if can decmine t problem  FNum =` Free A littl4rr2check1? t="T "" Thenu[exists, it's saFf#winurADLXMl a{e@NaSplac4dn !ta0C^SASdbsxmsults%Cu@p@ntDb() DoCmd.Del@BObj@w@T, "åE;ss!rstE[eIV.OpenRedset(z"%"ED F@RInput As ]E& WhbOF(DDt #@сBufferC :W@ ,GA.A ddNew Fi0elds/@Pst "):Left(, 255%A .Upn"CLoop#CloZDC' grab n UUf rela~Wgeneral U5[ A assig@o variA8! r ueof%eǠL@zord$'_6eC_7x < 4b!a6'%7'`07.D7054kA'O4'k4c hk?!Trim>(>startchar">ehend< Mid$( , 1@1"  2E B7 1F5ddTo@_ 1_ _ EQ "` Val_g x + 1]SW`qߏ RunSQL "DELE .* `FROM 4uDimemcq-qIgUT dbs eiC aqITEM`spctdлuts ={bx.ñ2.c'loOfou vh?"q/P A15B1/1k! o迩3Oq%s4edk_Q5U@Typ)8 Q1W  .Fields(14) = est_County 21UnitSystemR2ata(logL3&Sp@ecYear'3xComment&6NEstTox'8i^cv Update End WithSet rstXMLResultsdbsxmlr.OpenRecordseHt("Cim&G@roup")" ( $ sqlADno0"UPDPATE & EESTIM /.iD'" & tanum"'" 2DoCmd.RunSQL IE > 2?iTEM>tR>>hZS><.ClosĆK~x_0'run query to remove all unneces|sa@C stDocNameI"t@de@cs2pnQ , acNormDalAEdi'next section ge W gAR `Cbers a\inser! the  in`appropri% lineSr]@ @4@k tablD% U%2 Curr@yDb(c- l#eKtj2) .M.Las3Fi EDo While T ruq' After 9ningprevious code"b  has one$: for eachD*-큑.e' *( i4rranged by w@ϣ 07in>@Ontial `4(3d" 1  a<D1eD,ۂE3 E4J0 d 5 6W7W8HIf Mid$(.7`str1=, 1@"<Num`e>" Then".a3 4, 5 Elai=tP3, 4* uB== Ipj%.bt= rb & "' where *L>`;# {e e8 3HeIfASx v+&R:NKx.EOFMExitLoopqB'Dim C0FPSthwi`PAs D0ba"fld! "relRela!VtdflqTPDeDr^`Sb'S' = A_ ("V .mdbqPP5' DispTlaihht`bu/ of a !E objb'sc*' f¢hJ';Debug.P3t "AAI_ '.s(0).B$Nj:(%FSESI\n H0' > q`p2 &{"= d[Sel C!c+011'do nothFA;_ p?//d !QAczO$s___QCE e/Qiew Aship___b5Ӏ<)te} $}r};cYDS/,,RC/7*X52ST'V-Reg0sM0l!teAverage. le, FMarketAreaMap/teA8RefqnceN0 <$sBtt = InТ(x1, 6\dText?pare`) + 1 = Mid$'P " !ng,K -If< 0 `n! p #a"Num,BufferXV= Trim(InPS$ p| o omf 2 9& e& c"Ay8.vs10GDetailw\X4LVAL -0238w9=Babc!e ghij3k ȳ7 @CڶdB{8 UlImporting/Printing XML Files From TRNS*PORT Estimator Arial8 h \\fp2\engl22 S odXXLetterPRIV0''''T\KhC]F4TRJPHAALOCKHARTUNTITLED1)HP LaserJet 8150 PS\\fp2\engl22engl22:d2 Tahomae12hgh Tahomam45 Tahoma` Detail"[Event Procedure]|(ƨFq?ôh01U`abcg hcmdIMPORTXML\Import Estimator XML File for Custom Reporting"[Event Procedure]Iq>A#_@h1]` ab\ c,icmdCOMBRPTNView and Print Combined Estimate Report"[Event Procedure]cF$A0Kh1]` ab\ c,icmdESTITEMDView and Print Item Summary Report"[Event Procedure]'_NFxU#|h1]` ab\ c,i cmdPrint_to_wordPPrint Combined Estimate Report to a File"[Event Procedure]HReport to FileU[;VLB\|h1]` a b\ c,i(cmdPRINT_SUM_TO_FILENPrint Estimate Summary Report to a File"[Event Procedure]H$Fe145`l abc Box11ނ"HIӑqe145`l ap LVAL bc8 Box12(z}Jiw>Id12345U7`abchd eLabel13HNYSTA Estimate Reports - Version 1.1 Arial6pBЌf12{h1]` ab\ c,icmdPrt_Comment:View and Print Comment Report"[Event Procedure]`幯eL >/hEh1]` ab\ c,i&cmdPrt_Comment_Filem !eC)e145`l a bc Box17~X*No;[e145]`l abc"BOXsORTEDpRINTOUTAJGVah1` ab\ c,icmdPrt_SortJView and Print Report Sorted by Cost "[Event Procedure]3AFQl#'h1` ab\ c,i cmdPrt_Sort_FileJPrint Sorted by Cost Report to a File"[Event Procedure]*kI]͘LVAL /08|:<=Babc2e ghiXj:k @̣N(\U U c=k@=GnD ۑ @EstimateGroupyRJ< c=k@=GnDescription9nrJY6e 0> c=k@=GnGroupTotalԥ)a)b*c7e gKh6,ij^8k \+?K $qryReport.ItemCodelz @x T)UCyy 6 U`6(kE wՃ^ @qryReport( J#1C`6(kE wՃEstimate.Description5;@EWCr`6(kE wՃEstimateIdpJMo!bs`6(kE wՃLettingDate;{NC `6(kE wՃEstimatorl9:L9*-`6(kE wՃCountyDescription4VTGʻ?|`6(kE wՃEstimatedTotal>1>OJD`6(kE wՃSpecYear "\aH[!*v`6(kE wՃItemCodeP @H:X`6(kE wՃEstimateItem.Description>x'O~sk`6(kE wՃUnitshiIBi~}`6(kE wՃQuantity^LO!U>`6(kE wՃUnitPriceV9I+dO>`6(kE wՃExtendedAmountG<VBr8T`6(kE wՃLineNumberɸ4 nLK~d7`6xabc,, Label56 (Project Description:x f*z=Pm;F{`6Da<bk  Units  Unitsx i#}!PAK͙{K`,,  Detailx +=FD3pm;F{`6!btk Quantity Quantityx wL!uģm0G;F{`6`'k UnitPrice UnitPricex  [BYF]om0G;F{`6.bk ExtendedAmount ExtendedAmount& *$#,##0.00;($#,##0.00)x k*BYimF{`6bk LineNumber LineNumberx wNA?ÀmF{`6,bhi# j%k  Text42 =IIf(([Text20]<>1) And [units]="LS","Error - LS quantity not = 1.00","")x K!6WG -3`imF{`6xbi# j%  Text47 =IIf(([unitprice]<>1) And [units]="DC","Error - DC unit price not = $1.00","")x !,ZM~ymF{`6xbi# j%k  Text55 6=IIf((([UNITS]<>"LS") And ([units]<>"DC") And (CLng(CSng([unitprice])*100)<>CLng(CSng([Text30])*100))),"Error - Unit price must be equal in all groups","")x )Jrp>mF{`6Pbk groupnumber groupnumberx IrK K`,P "[Event Procedure] GroupFooter1x `ہE1 rm;F{`6-a<b Subtotal ,=Sum([extendedamount])& *$#,##0.00;($#,##0.00)x 2uL$N^d7`6bec, Label19 Item Total:x ۻEGMm0G;F{`6,a<bk  Text20 d=IIf([Units]="LS",Avg([quLVALantity]),Sum([quantity]))& General Numberx ɸD-m !;<F{`6-a<bi# j%k  Text14 H="Page " & [Page] & " of " & [Pages]" @Times New Romanx ڪfQM( &K`,  ReportFooterx ;!HkTm;F{`6<-axb4  Text24 ,=Sum([extendedamount])& *$#,##0.00;($#,##0.00)x ȀsNO*id7`6)a<bc,, Label26  Total:x $RcJ`}mF{`6 a<b k  Text53 unique_itemsx .:J7 i΋d7`6<b c,, Label54 0Number of Unique Items:x 3&MDO,-*p`6xab4d Child60 (Report.EstimateGroupx V FOonf2 `6xab5c,  Line62x mlkSaK-|LVAL ;2 4CB0 1CB0 2CB0 3CB0 0CB0 5CB8defgjmnopdddddddfdmdmdmdfmmmmmmmmmfͬ"kvN_O٘.*ReportHeaderPageHeaderSectiondItemCode_LabeldLineNumber_LabeldDescription_LabeldComment_LabeldQuantity_LabeldUnitPrice_LabeldExtendedAmount_Labelf Line19d Label16m EstimateIdd Label21m Estimate_DescriptionEstimate.DescriptiondLabel22mLettingDatedLabel23fLine24DetailmItemCodemLineNumbermDescriptionmCommentmQuantitymUnitPricemExtendedAmountPageFooterSectionmText17mText18fLine20ReportFooterCountyDescription EstimateItem.Description!Unitsͬ=Q';F^aeВZReportHeaderdLabel12fLine15PageHeaderSectiondItemCode_LabeldDescription_LabeldQuantity_Labeld UnitPrice_Labeld ExtendedAmount_Labelf Line17d Label33f Line16GroupHeader0DetailmQuantitymUnitPricemExtendedAmountGroupFooter1mSubtotalmText20mText30mText32mItemCodemUnitsmText38mText40mText42PageFooterSectionmText13mText14 ReportFooterm!Text24d"Label26+GroupTotal,LineNumber-EstimateItem.Description.Commentm/Estimate_DescriptionEstimate.Descriptionm1EstimateIdp5Child50m6CountyDescriptiond7Label52m8LettingDated9Label53d:Label54d;Label55f<Line56f=Line57m>Text58d?Label59m@EstimatedTotaldALabel60dCLabel61mBEstimateCommentmDEstimatordELabel62mHUnitSystemdILabel64JSpecYearmKtxtspecyr2dLLabel69ͬ>kɷLPY15F3ReportHeaderdLabel12fLine15PageHeaderSectiondItemCode_LabeldDescription_LabeldQuantity_LabeldUnitPrice_LabeldExtendedAmount_Labelf Line16f Line17d Label35d Label46 GroupHeader0mItemCodemDescriptionmUnitsDetailmQuantitymUnitPricemExtendedAmountmLineNumbermText42mText47mText55GroupFooter1mSubtotaldLabel19mText20fLine27mText30PageFooterSectionm Text13m!Text14"ReportFooterm#Text24d$Label26m&Text53d'Label54,EstimateItem.Description-Commentm.Estimate_DescriptionEstimate.Descriptiond/Label56m0EstimateIdd1Label57f2Line59p3Child60f4Line62m5LettingDated6Label63m7groupnumberd8Label69m9Estimatord:Label70m;CountyDescriptiond<Label71m=EstimatedTotald>Label72m?UnitSystemd@Label73mASpecYeardBLabel74LVAL 7u08w:<=5B>a)b*c@8e gFh6ij;k =,?l( @x EF}GEfss,+y  U`6(kE wՃ^ @qryReport`z2YDn9,l`6(kE wՃEstimate.Comment5;@EWCr`6(kE wՃEstimateId( J#1C`6(kE wՃEstimate.DescriptionpJMo!bs`6(kE wՃLettingDatel9:L9*-`6(kE wՃCountyDescriptioni`*zBwuR!`6(kE wՃunique_items4VTGʻ?|`6(kE wՃEstimatedTotal;{NC `6(kE wՃEstimator>1>OJD`6(kE wՃSpecYearhiIBi~}`6(kE wՃQuantity^LO!U>`6(kE wՃUnitPriceV9I+dO>`6(kE wՃExtendedAmountbmΒB5EF}GEfss,+ExtendedAmount)CsdEF}GEfss,+Units?)GjEF}GEfss,+Quantity i|;@\>\EF}GEfss,+SubtotalZ|_ACpyEF}GEfss,+Text20P @H:X`6(kE wՃEstimateItem.Description "\aH[!*v`6(kE wՃItemCode>x'O~sk`6(kE wՃUnits rwcOL8QKrҞf2 ab$6  Line16x RC, dqVm`6 a<b(c,,i#  EstimateId EstimateIdx l&9EtIm`6abi# k (Estimate.Description (Estimate.Description (Estimate_Descriptionx LyDMXF0m`6Xaxbtc,,i# k LettingDate LettingDatex KZH\HVd7`6| a<b(c,, Label53 Letting Datex /(FUCB%q!m`6/abc,,e` i# k "CountyDescription "CountyDescriptionx k@4YEiKd7`6(aHbc,, Label52 County:x |/B<|*d`6xa<bc,, Label54  PIN:x \3C %ud`6xabc,, Label55 Project Desc:x XѯOnrF mF{`6abi# k  Text58 unique_itemsx U(^GKz=d7`6xaHbQ c,, Label59 0Unique Items in Project:x JtC_\0kmF{`6abi# k EstimatedTotal EstimatedTotal& *$#,##0.00;($#,##0.00)x ܫóiCMd7`6LaHb c,, Label60 Estimated Cost:x П *6OU"7mF{`6axb$ k Estimator Estimatorx d7`6(axbc,, Label64  Unit Of Measure:x ihJGΜrmF{`6/ak txtspecyr2 SpecYearx CT߱OұNrRd`6(abc,, Label69 Spec Year:x >J˰K`, GroupHeader0x 8ӖfC8"_K`,h  Detailx kqiڅA[8QwMm;F{`6\bc, Quantity Quantityx ?)Gjm0G;F{`6!b8c,k UnitPrice UnitPricex  rwcOL\m;F{`6 bk  Text20 d=IIf([Units]="LS",Avg([quantity]),Sum([quantity]))x Z|_ACpym;F{`6T$bk  Text30 (=[Subtotal]/[Text20]& *$#,##0.00;($#,##0.00)x <+K'mF{`6bk  Text32 0EstimateItem.Descriptionx ,OrDj)m !0G<F{bdi# k ItemCode ItemCode" @Times New Romanx tz3,]GgC7*m;F{`6b8k  Units  Unitsx )CsdmF{`6X/bDj%k  Text38 =IIf(([Text20]<>1) And [units]="LS","Error - LS Qty not = 1.00","")x $NN=7mF{`6X/bj%k  Text40 =IIf(([unitprice]<>1) And [unitsELVALU]="DC","Error - DC unit price not = $1.00","")x [*kH0mF{`6X/bj%k  Text42 6=IIf((([UNITS]<>"LS") And ([units]<>"DC") And (CLng(CSng([unitprice])*100)<>CLng(CSng([Text30])*100))),"Error - Unit price must be equal in all groups","")x *#LEp k`, "PageFooterSectionx 2:P@lt:m !;<F{`6<ab i# j%  Text13  =Now()& Long Date" @Times New Romanx &dڄEF+ #km !;<F{`6+ai# j%k  Text14 H="Page " & [Page] & " of " & [Pages]" @Times New Romanx M; ;2@aU K`,L ReportFooterx H)&@hNH%Pm;F{`6(abd  Text24 ,=Sum([extendedamount])& *$#,##0.00;($#,##0.00)x %7IY"Bq d7`6!abc,, Label26  Total:x zqUIJ1ʷp`6ab5c,P d Child50 (Report.EstimateGroupx y$N?RKz b@f2 `6<aXb`6  Line56x QEI;eHWf2 `6<axb$6  Line57x !oG_EkfxKLVAL <08:<=Babc@8e gixj ?k!"[Event Procedure]J @}{An2D  Uq!u-A{ (ˠ"h @qryComment5;@EWCrq!u-A{ (ˠeSTIMATEiD( J#1Cq!u-A{ (ˠEstimate.DescriptionpJMo!bsq!u-A{ (ˠLettingDate "\aH[!*vq!u-A{ (ˠItemCodeG<VBr8Tq!u-A{ (ˠLineNumberP @H:Xq!u-A{ (ˠEstimateItem.Description_KڪtYaq!u-A{ (ˠCommenthiIBi~}q!u-A{ (ˠQuantity^LO!U>q!u-A{ (ˠUnitPriceV9I+dO>q!u-A{ (ˠExtendedAmount qryCommentEstCommments Arial8@8hh4 odXXLetter DINU"4qWI K$Anpi942f51d278d eTimes New Romane24fg37jghm5C Arialn= Arialo3A Arialp4ItemCode`<ReportHeader9гAiTe`"PageHeaderSectionAZwXE醶d`<atb8c,ItemCode_LabelItemCodeDetachedLabel3PId`atb9c+ LineNumber_LabelLine NumberDetachedLabel(折}F+d`atbc,"Description_LabelDescriptionDetachedLabel;Iȓ?d`atbc,Comment_LabelCommentDetachedLabelrث@a4@d`&atbc,Quantity_LabelQuantityDetachedLabelFrB- C2{Q(d`+atb8c,UnitPrice_LabelUnitPriceDetachedLabelA4Fd`0atbc+(ExtendedAmount_Label"Extended AmountDetachedLabel0ܮY}HZ&f2`<ab7 Line19  YNXPJd2`<a<bcdLabel16&Estimator Commments65E_CBM23;m`tabDci eSTIMATEiDeSTIMATEiDlfH\Yd`abc,Label21 PIN:t|LԽKcm`aXbi k(Estimate.Description(Estimate.Description(Estimate_Description;Ld7`aXbc,Label22(Project Description:cFa5+tm`!ai kLettingDateLettingDate~' Am)TeSd7` abc,Label23LettingDate:_L2Af2`<ab7 Line24wwCYB`h Detail9Ѣ!K'IKFm`<a<b8cItemCodeItemCodeeT˝=CA0m`a<bckLineNumberLineNumber.NpY'am`4a<b cikDescription0EstimateItem.Description3)Ǎf,VLqm`a<bXckCommentComment8\6#Iŷ.|m`&a<b8ckQuantityQuanT LVALd tity@{CP*/@m`,a<bckUnitPriceUnitPrice۞ M5Z^d9?m`81a<btckExtendedAmountExtendedAmount30Dd6ǧ_`"PageFooterSectionYD}IS8m ;<`<abc,i j Text17 =Now()Long DateTimes New RomanDVATW`D\m ;<`abc,i jk Text18H="Page " & [Page] & " of " & [Pages]Times New Roman]p_J5,P f2`<ab7 Line20!/ntԖ@J^`ReportFooter)ڴιZAE  ~9F q  z 7  h  o , = }T@}T@KN@CPROJECT840" }T@}T@J@CPROJECTwm<84" }T@}T@ID _VBA_PROJECTB>:" }T@}T@H@Cdir0,(" }T@}T@G AcessVBADataNJF. =zT@=zT@FDataAccessPages<84 w=zT@=zT@ECustomGroups62. w=zT@=zT@DMSysDbDirDataAPLH8 =zT@=zT@CBlobB&" w=zT@=zT@B0A  w=zT@=zT@ADatabases0,( w=zT@=zT@@ijPropDataPLH8 =zT@=zT@?Scripts,($ w=zT@=zT@>F@5PropDataCopy"B>:" =zT@=zT@=; 0CB0 3CB0 2CB0 1CB0 4CB0PropData"uqm] =zT@=zT@<@!DirData":62" =zT@hT@;BlobDelta70,( w=zT@hT@:@CTypeInfo7:62" =zT@hT@9PropData7PLH8 =zT@hT@8B> Blob72.*" =zT@hT@74"  w=zT@=zT@6@5BlobDelta2<84" LVAL ?Pu08w:<=5B>a)b*c7e gHh6 ij<Dvc/1$ @qryReportsortbycost( J#1C)g>Dvc/1Estimate.Description5;@EWCr)g>Dvc/1EstimateIdpJMo!bs)g>Dvc/1LettingDatehiIBi~})g>Dvc/1Quantity^LO!U>)g>Dvc/1UnitPriceV9I+dO>)g>Dvc/1ExtendedAmountG<VBr8T)g>Dvc/1LineNumber_1R DgӘ+1)g>Dvc/1groupnumberP @H:X)g>Dvc/1EstimateItem.Description>x'O~sk)g>Dvc/1Units "\aH[!*v)g>Dvc/1ItemCodez||KW{2Ғ1I#;ExtendedAmount^J!~Ғ1I#;Units'5L%jvҒ1I#;Quantityk܊yF%|HYҒ1I#;SubtotalZL4~0SҒ1I#;Text20î-MGHҒ1I#;UnitPriceuiIDN3NҒ1I#;Text30i`*zBwuR!)g>Dvc/1unique_itemṣN(\UzT@vc0EstimateGroup &qryReportsortbycost 8Estimate Item Summary Report @ Arial 87h \\fp2\engl22  odXXLetterPRIV0''''T\KhC]F4TRJPHAALOCKHARTUNTITLEDLVAL@ 1)HP LaserJet 8150 PS\\fp2\engl22engl22:d!278d# e%" @Times New Romane24 fg3I75jg4h5mf5IC" @ Arialn=I" @ Arialo3IA" @ Arialp4I0K ExtendedAmountK`,X ReportHeaderx P'L}yOd2`6<a<bo'c,d# Label12 VNYSTA - Estimate Report Sorted by Item Costx Q!w,FJ´{f2 a<bp5  Line15x 1J4|N`, "PageHeaderSectionx Zs@F_S% d`6xabc,I ItemCode_Label Item Number  DetachedLabelx `%ECŽȣ7d`6abc,, "Description_Label Description  DetachedLabelx ֜.f2 abp5  Line16x -+7IhM|d/f2 abp5  Line17x xpcڼLZpuMY3Wd`6abc,I Label35 Line Numberx &/iHvJ"d`6ab:c,, Label46  Unitsx ~XHng{m`6haxb` (Estimate.Description (Estimate.DLVALAescription (Estimate_Descriptionx e|HA@d7`6a<bc,, Label56 (Project Description:x !q)Jui@;m`6Haxbk EstimateId EstimateIdx FoCqJ' d7`6xa<bc,, Label57 PIN x >9Eqm`6/axk LettingDate LettingDatex ?ÜyTnC AEd7`6l*a<bc,, Label63 LettingDate:x ;fcH'G8zNU_d`6abc,, Label69  Groupx "LS") And ([units]<>"DC") And (CLng(CSng([unitprice])*100)<>CLng(CSng([Text30])*100))),"Error - Unit price must be equal in all groups","")x MϊyvmF{`6hbi# j%k  Text47 =IIf(([unitprice]<>1) And [units]="DC","Error - DC unit price not = $1.00","")x 5 9E4{KmF{`6a<bhi# j%k  Text42 =IIf(([Text20]<>1) And [units]="LS","Error - LS quantity not = 1.00","")x ]9Kfքy`,, "PageFooterSectionx es\@W1m !;<F{`6xb i# j%  Text13  =Now()& Long Date" @Times New Romanx A rEr~‘Em !;<F{`6-a<bi# j%k  Text14 H="Page " & [Page] & " of " & [Pages]" @Times New Romanx "5DiCxN5K`,  ReportFooterx R8Z`ZCElm;F{`6X/ab  Text24 ,=Sum([extendedamount])& *$#,##0.00;($#,##0.00)x qz>N [d7`6,abc,, Label26  Total:x =>jD 9+mF{`6&ab k  Text53 unique_it LVAL emsx HIYvSd7`6ab c,, Label54 0Number of Unique Items:x U)aGįR6p`6xab4d Child60 (Report.EstimateGroupx =JAebf2 aHb5c,  Line62x 8̛'J,e\f2 a,b5c,  Line71x [mbjIGbM^=5LVAL iKID="{36BA99F4-69C4-4B3C-8A46-FAB75845EDFB}" DocClass=Report_Estimate_Item_Summary_Report/&H00000000 DocClass=Report_Combined_Estimate_Report/&H00000000 DocClass=Form_IMPORT_PRINT/&H00000000 Class=CommonDialogAPI DocClass=Report_EST_ITEM_SUM_SORT_BY_COST/&H00000000 DocClass=Report_EstComments/&H00000000 Name="combinedest" HelpContextID="0" VersionCompatible32="393222000" CMG="4143616765676567656765" DPB="8280A2E1E2E2E2E2E2" GC="C3C1E3A025A125A1DA" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Report_Estimate_Item_Summary_Report=0, 0, 0, 0, C Report_Combined_Estimate_Report=88, 132, 988, 675, C Form_IMPORT_PRINT=44, 58, 1052, 490, Z CommonDialogAPI=66, 99, 966, 642, C Report_EST_ITEM_SUM_SORT_BY_COST=44, 66, 944, 609, C Report_EstComments=44, 66, 1038, 604, C Report_Estimate_Item_Summary_ReportReport_Estimate_Item_Summary_ReportReport_Combined_Estimate_ReportReport_Combined_Estimate_ReportForm_IMPORT_PRINTForm_IMPORT_PRINTCommonDialogAPICommonDialogAPIReport_EST_ITEM_SUM_SORT_BY_COSTReport_EST_ITEM_SUM_SORT_BY_COSTReport_EstCommentsReport_EstComments0* pHd combinedest8@ = t  I( J< ADODB> ADOB  *\G{020 1-10-8 AA006D2EA4}#2.1#0#C:\Program Files\Common System\ado\ms21.tlb#Microsoft ActiveX Data Objects , LibrarFyHDAO>~DAр[ Y25EY00-CY46}#5 .0YNShared\;3600.DLL^ 3L.6[YJRYJTRYW,AC3B8B4C-B6CA-11D 1-9F3A]C04FC29D52Y6Yjro.dll)Jet and ReplicatigZ6 .Xstdole>stdoPleh@/^D0U20430@[AY]2]WIN@DOWS\sB32\C2„OLE Autom'{MSXML2"MSXML2"lbF5078F18-C551AS3-89B9&F81FE2218}#4"C"ms0xml4LN, v COWC10COWCP10#G#FE55F1?h\QWeb `lponents\10\LSOffice XP @Œ`Cort_Estax XG$>p?r@_EAC(mm ns AOXSAMCZKHBBODTBHQYZFKSFVMCIH28!O7SxM'ZKH,B THQYZF SV`=CI `@-`]f,""(+#giLe_I_Summ`_JG teiEae_@tEm Sum@aryR%!TRVNLMJWGPGBXDAGRUYQKGOLLOKH!"T VNYMJ`IGPG XA RU!Q!G'LO`H! !!!h4_EPo 8bie@[=:YROKWDKRJVLORDVWZGOZDNZHQTVNC Y4W(K`JVO D W`ZN!/TpN/]X_/ 'EST_ITEM_SU0ORT_BY_COSTG Sq-T`Mr-ZU_V TB+0(O0T>SHZMBUBENPWWODJYBLUYMVGMZBTUKSS:ZB0,BN-W!>ZJB0-MGpZp/U-D>--PForm_IMPPRIN`F,rM P`I 8 YDLWEE_PDLOQHEPBSGKFFWBJIMRED W EP`L9QEpB@G` FDW *J.M0EFF. ` ͬ3ͪ I@HReportHeaderdLabel12fLine15PageHeaderSectiondItemCode_LabeldDescription_LabeldQuantity_LabeldUnitPrice_LabeldExtendedAmount_Labelf Line16f Line17d Label35d Label46m Estimate_DescriptionEstimate.DescriptiondLabel56mEstimateIddLabel57mLettingDatedLabel63dLabel69GroupHeader0DetailmQuantitymUnitPricemExtendedAmountmLineNumbermgroupnumbermDescriptionmUnitsmItemCodeGroupFooter1mSubtotald Label19m!Text20f"Line27m#Text30f$Line59m%Text55m&Text47m'Text42(PageFooterSectionm)Text13m*Text14+ReportFooterm,Text24d-Label26m.Text53d/Label54p0Child60f1Line62f2Line71LVAL Eam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office10\MSACC.OLB#Microsoft Access 10.0 Object Library*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL#Microsoft DAO 3.6 Object Library(*\G{AC3B8B4C-B6CA-11D1-9F31-00C04FC29D52}#2.6#0#C:\Program Files\Common Files\System\ado\msjro.dll#Microsoft Jet and Replication Objects 2.6 Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{F5078F18-C551-11D3-89B9-0000F81FE221}#4.0#0#C:\WINDOWS\System32\msxml4.dll#Microsoft XML, v4.0:*\G{0002E550-0000-0000-C000-000000000046}#1.1#0#C:\Program Files\Common Files\Microsoft Shared\Web Components\10\OWC10.DLL#Microsoft Office XP Web Components I8AOXSAMCZKHBBODTBHQYZFKSFVMCI01488b10bb$Report_EstComments]8TRVNLMJWGPGBXDAGRUYQKGOLLOKH02488b10bb#FReport_Estimate_Item_Summary_Report8JTWWLSMMESARRDZXLBGFIDARXHE_03488b10bb)CommonDialogAPI/08YROKWDKRJVLORDVWZGOZDNZHQTVN04488b10bb}>Report_Combined_Estimate_ReportH]8SHZMBUBENPWWODJYBLUYMVGMZBUK05488b10bb@Report_EST_ITEM_SUM_SORT_BY_COST`8YDLWEE_PDLOQHEPBSGKFFWBJIMRE06488b10bb"Form_IMPORT_PRINTxF`H0xvx2F/fV,DEJ?o]ɗc DbÒuM̙B.WRATEHK߬L^K}aNhBAccessVBAWin16~Win32MacVBA6# combLVALinedestEADODBsDAOJRO)stdole`MSXML2OReport_EstComments _Evaluate Report_NoDatayCancelMsgBoxR vbExclamation#Report_Estimate_Item_Summary_ReportGroupFooter1_Format9 FormatCountCommonDialogAPIw GetOpenFileName]? pOpenfilenamec OPENFILENAME35 comdlg32.dll mGetSaveFileNameW lstructsize/r hwndOwner hInstance  lpstrFilterlpstrCustomFilternMaxCustFilter` nFilterIndexc lpstrFileVnMaxfilelpstrFileTitlep4 nMAxFileTitleymlpstrInitialDirr lpstrTitleoFlagso nFileOffsetInFileExtension9 lpstrDefExt_ lCustData'5lpfnHooklpTemplateNamet mstrFilename mblnStatus getname<strNameZ getStatusK blnStatusOpenFileDialog lngFormHwndlngAppInstance strInitDir strFileFilterOpenFilexoTrim@SaveFileDialogSaveFile}Report_Combined_Estimate_ReportS Report_Opend FullSpecyearReportHeader_Formatu Report_EST_ITEM_SUM_SORT_BY_COSTForm_IMPORT_PRINTcmdCOMBRPT_Click stDocNamezDoCmdƧ OpenReport acPreviewoExit_cmdCOMBRPT_ClickErr_cmdCOMBRPT_ClickErro Description cmdESTITEM_Click;Err_cmdESTITEM_ClickExit_cmdESTITEM_ClickexcmdIMPORTXML_ClickcdlgQ lngResultQ lenofgetname tbdUpdate>TableDefmtbdField* Field3dbsestimateitem O CurrentDbSxmdbvcurrenttxtdbnameFileNum# InputBuffergroupnoEBlinenoG est_tanum chkstring4Hwnd/ Application* hWndAccessAppChrK~ selfilename:RunSQL ImportXML DataSource  ImportOptions=alldoneotest4 dbsxmlresultsP DeleteObjectTacTablerstEstimateInfo0 OpenRecordset|EOFAddNewaFields7Update startcharʢendchar8 SetupXmlstrest_descQ est_EstimatorU est_Prepdatew est_LetDateASest_UnitSystem3, est_SpecYear est_Countyr est_Catalog est_CommentJ  est_EstTotal`5Val itemcountUrstESTIMATEITEMP RecordCount{ est_EstType~est_EstTypeDescs rstXMLResults sqlUpdateDnoF OpenQueryacNormalacEditIdbsxmlresults2 rstXMLResults2$MoveLast MoveFirstN testxmlstring^sqlupdategroupMoveNextL!tdfloop TableName`  TableDefs%iForm txtInfoBox$Vhide9zresponsevbOKOnlycmdPrt_Comment_Click#Err_cmdPrt_Comment_ClickExit_cmdPrt_Comment_ClickcmdPrt_Comment_File_Click]Err_cmdPrt_Comment_File_ClickoOutputTo`acReport%Exit_cmdPrt_Comment_File_ClickcmdPrint_to_word_ClickErr_cmdPrint_to_word_ClickExit_cmdPrint_to_word_ClickѹcmdPRINT_SUM_TO_FILE_Click8Err_cmdPRINT_SUM_TO_FILE_ClickIExit_cmdPRINT_SUM_TO_FILE_ClickCommand19_Click\Err_Command19_ClickExit_Command19_ClickcmdPrt_Sort_ClickErr_cmdPrt_Sort_Click4Exit_cmdPrt_Sort_ClickZ4cmdPrt_Sort_File_Click0Err_cmdPrt_Sort_File_Click<Exit_cmdPrt_Sort_File_Click7 XMLstringYstartstr StringFormatEnumHendstr%line2str vbTextCompare Q Detail_Click/OWC10LPv#)}  l  @ @ @ @ @ @ @ @ @                           ! " # $ % & ' !( ") #* $+ %, &- '. (/ )0 *1 +2 ,3 -4 .5 /6=7=8=9=:=;=<===>=?= @= A= B= C= D=E=F=G=H=I=J=K=L @@@@@@@@@@@@@@@@@@     " ?= @= A= E=F=  G= J=K=      H=I=           !   "# "( ""- '"2 ,"7="<="==">=#$ #% #& #' !() #(* $(+ %(, &-. (-/ )-0 *-1 +23 -24 .25 /26=78=79=7:=7;=AB= AD=BC= 1@@@@ @  @@@ M`OLJik Mokmd`Uidofk=OJmJJMMQkkfJUQk=OJmJLJkQk= Sdi`k `dOo^Qk `kvkJMMQkkkmdiJUQ+iddm fidfOJmJ= iQfdimk kMiYfmk= qLJ `kvkJMMQkkkmdiJUQ+kMiJmMW JMQkkqLJOJmJ=qLJfid[QMm fid[QMm=fid[QMms`=qLJ +qLJ+fid[QMm=JdukJ`Mx\WLLdOmLWhvxS\kSq`MY OYi=[mss^k``QkJiiOxu^LUSYOJiuWQ+ kWx`LoLQbfssdO[vL^ov`qU`xLo\ miqb^`[sUfULuOJUiovh\Ud^^d\W vO^sQQ+fO^dhWQfLkU\SSsL[Y`iQ vid\sO\i[q^diOqsxUdxObxWhmqb 6 OYiOJmJ fidfOJmJ fidfOJmJMdfv L^dL L^dLOQ^mJ fidfOJmJ mvfQYbSd 6 OYiOJmJ fidfOJmJ fidfOJmJMdfv fidfOJmJ fidfOJmJMdfv "6 "8 "": '"< ,">="OYiOJmJ="fidfOJmJ="fidfOJmJMdfv=#L^dL #L^dLOQ^mJ !#fidfOJmJ #mvfQYbSd (L^dL #(L^dLOQ^mJ &(fidfOJmJ $(mvfQYbSd %-L^dL (-L^dLOQ^mJ +-fidfOJmJ )-mvfQYbSd *2L^dL -2L^dLOQ^mJ=2fidfOJmJ .2mvfQYbSd /7L^dL=7L^dLOQ^mJ=7fidfOJmJ=7mvfQYbSd=A6= AOYiOJmJ=BL^dL=  LVALb  (((Mid$(test.testxmlstring,1,12)) Not Like "<LineNumber>") And ((Mid$(test.testxmlstring,1,13)) Not Like "<GroupNumber>"))Estimate.EstimateId=EstimateItem.eSTIMATEiDEstimate.EstimateId=EstimateItem.eSTIMATEiD(((EstimateItem.UnitPrice) Is Null))Estimate.EstimateId=EstimateItem.eSTIMATEiD"w6t3 i % T { :  J Q b @I ' Mid$(test.testxmlstring,1,13)< gMid$(test.testxmlstring,1,12)< gExpr5Mid$(test.testxmlstring,1,13)F oExpr4Mid$(test.testxmlstring,1,12)F oExpr3Mid$(test.testxmlstring,1,21)F oExpr2Mid$(test.testxmlstring,1,13)F oExpr1Mid$(test.testxmlstring,1,12)F otest.testxmlstring1 gtest.*% g test  G   GEstimateItem.ItemCode4 gEstimateItem)))  G  G dEstimateItem.ExtendedAmount< /EstimateEstimateItemV@IE9! Estimate.Comment/ gEstimate.EstimatedTotal6 gEstimateItem.groupnumber7 g Estimate.unique_items4 g EstimateItem.ExtendedAmount: g EstimateItem.UnitPrice5 g EstimateItem.Quantity4 g EstimateItem.Units1 gEstimateItem.Comment3 gEstimateItem.Description7 gEstimateItem.ItemCode4 gEstimateItem.LineNumber6 gEstimate.CountyDescription9 gvY9NLL Y testxmlstringdv K^4 0008!0002#0006!0004!0002!0001#kMSysAccessStorageSTGRELMSysAccessStorageParentIdMSysAccessStorageIdn^<EstimateEstimateItemEstimateItemeSTIMATEiDEstimateEstimateIdrbN6  @ @ @ @ @ @ @ @ @      = = = ==  = ==      ==              " " "" '" ,"="="="=# # # # !( #( $( %( &- (- )- *- +2 -2 .2 /2=7=7=7=7=A= A=B= QQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'+  *  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  +  *  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  +  *  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  +  *  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  + + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp *  +  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  *  +  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  *  +  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  * * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp +  +  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  *  +  )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp  * * * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * + * + )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * `LVALrά'jfQ ʾ Mxtest testdelrecs2IMPORT_PRINTEstimate_Item_Summary_ReportCreate data access page in Design viewCommonDialogAPI:^35LVALn K OMR2 GUIDNameMap2 ̣N(\U  U c=k@=GnD ۑ @EstimateGroupyRJ< c=k@=GnDescription9nrJY6e 0> c=k@=GnGroupTotalԥ)1>OJD`6(kE wՃSpecYearhiIBi~}`6(kE wՃQuantity^LO!U>`6(kE wՃUnitPriceV9I+dO>`6(kE wՃExtendedAmountbmΒB5EF}GEfss,+ExtendedAmount)CsdEF}GEfss,+Units?)GjEF}GEfss,+Quantity i|;@\>\EF}GEfss,+SubtotalZ|_ACpyEF}GEfss,+Text20P @H:X`6(kE wՃEstimateItem.Description "\aH[!*v`6(kE wՃItemCode>x'O~sk`6(kE wՃUnits rwcOL 6 U`6(kE wՃ^ @qryReport( J#1C`6(kE wՃEstimate.Description5;@EWCr`6(kE wՃEstimateIdpJMo!bs`6(kE wՃLettingDate;{NC `6(kE wՃEstimatorl9:L9*-`6(kE wՃCountyDescription4VTGʻ?|`6(kE wՃEstimatedTotal>1>OJD`6(kE wՃSpecYear "\aH[!*v`6(kE wՃItemCodeP @H:X`6(kE wՃEstimateItem.Description>x'O~sk`6(kE wՃUnitshiIBi~}`6(kE wՃQuantity^LO!U>`6(kE wՃUnitPriceV9I+dO>`6(kE wՃExtendedAmountG<VBr8T`6(kE wՃLineNumberɸq!u-A{ (ˠUnitPriceV9I+dO>q!u-A{ (ˠExtendedAmount MR2 GUIDNameMapn Ғ1I#;J B U)g>Dvc/1$ @qryReportsortbycost( J#1C)g>Dvc/1Estimate.Description5;@EWCr)g>Dvc/1EstimateIdpJMo!bs)g>Dvc/1LettingDatehiIBi~})g>Dvc/1Quantity^LO!U>)g>Dvc/1UnitPriceV9I+dO>)g>Dvc/1ExtendedAmountG<VBr8T)g>Dvc/1LineNumber_1R DgӘ+1)g>Dvc/1groupnumberP @H:X)g>Dvc/1EstimateItem.Description>x'O~sk)g>Dvc/1Units "\aH[!*v)g>Dvc/1ItemCodez||KW{2Ғ1I#;ExtendedAmount^J!~Ғ1I#;Units'5L%jvҒ1I#;Quantityk܊yF%|HYҒ1I#;SubtotalZL4~0SҒ1I#;Text20î-MGHҒ1I#;UnitPriceuiIDN3NҒ1I#;Text30i`*zBwuR!)g>Dvc/1unique_itemṣN(\UzT@vc0EstimateGroup[ Ws @Fg @ testdelrecs2++@^|@_RFF:::::::8 @cn @0)d @0qryFIXNULLPRICE+@]|@UXLL@@@@@@@> @fs @-T- @Estimate+$W >>>22222220 @x3C@x3C@~sq_dCombined_Estimate_Report~sq_dChild50+4MR2KeepLocal Ttttttttr @ RۮG @RۮG @EST_ITEM_SUM_SORT_BY_COST+@S```TTTTTTTR @(LVALL p@ά'"`[fl Estimate2m EstimateItemά}flEstimate2m EstimateItemά/]xC&m EstimateItemάL:sW άL:Ws&xEstimateEstimate!(EstimateGroupEstimateGroup2x EstimateItemEstimateItem+vcO<)   x  d Q > +   z g T @-}* )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + K+ K* K)?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp * T)?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + T)?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp + * )?l`z&tm7GEc)9o4)pz[_Nvf>aY2Osa]M~TUݶp LVAL XMR2.DefaultValueRequiredAllowZeroLengthGUID FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenValidationRuleValidationTextOrientationDefaultViewDescription FormatInputMaskCaptionDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesEstimateId   5;@EWCr      m   Description   ( J#1C $     m   Estimator   ;{NC       m   $PreparationDate   h(I͗b      m   LettingDate   pJMo!bs      m   EstimateType   7݆[      m   ("CountyDescription   l9:L9*- `     m    Season   rFIɈ$      m   ("SeasonDescription   T˓tCOǡw      m   CheckedBy   ,tQG)w^V4      m   DateChecked   ͻO> "̱Q      m   ApprovedBy   q#bF]L9z      m   DateApproved   T7͛G&      m   UnitSystem   臦D{q      m   Catalog   eteJ \G ߇      m   SpecYear   >1>OJDLVALY      m   *$PriceRoundingLevel   ol#M      m   0*QuantityRoundingLevel   aζ.&J3In      m   2,ExtensionRoundingLevel   ^feCBJ Z      m   4.PercentageRoundingLevel   I6G C5J      m   TrnsportFlag   $D3려      m   2,TrnsportPriceBasesFlag   O?H4TG#      m   *$EditPricesOnlyFlag   ],,ZKDŪ/      m   Comment   `z2YDn9,l      m   4.EstimatedCostUnfinished    Gpz%      m    EstimatedCost   RkXD$yp<      m   *$ContingencyPercent   ENmO@      m   60EstimatedTotalUnfinished   C䜄OJ[F0      m    PIN    5A4 R?      m   =  [bLP*0?W   U[bLP*0?W) @Estimate5;@EWCr[bLP*0?WEstimateId( J#1C[bLP*0?WDescription;{NC [bLP*0?WEstimatorh(I͗b[bLP*0?WPreparationDatepJMo!bs[bLP*0?WLettingDate7݆[[bLP*0?WCountyl9:L9*-[bLP*0?WCountyDescriptionrFIɈ$[bLP*0?WSeasonT˓tCOǡw[bLP*0?WSeasonDescription,tQG)w^V4[bLP*0?WCheckedByͻO> "̱Q[bLP*0?WDateCheckedq#bF]L9z[bLP*0?WApprovedByT7͛G&[bLP*0?WDateApproved臦D{q[bLP*0?WUnitSystemeteJ \G ߇[bLP*0?WCatalog>1>OJD[bLP*0?WSpecYearol#M[bLP*0?WPriceRoundingLevelaζ.&J3In[bLP*0?WQuantityRoundingLevel^feCBJ Z[bLP*0?WExten LVAL! sionRoundingLevelI6G C5J[bLP*0?WPercentageRoundingLevel$D3려[bLP*0?WTrnsportFlagO?H4TG#[bLP*0?WTrnsportPriceBasesFlag],,ZKDŪ/[bLP*0?WEditPricesOnlyFlag`z2YDn9,l[bLP*0?WComment Gpz%[bLP*0?WEstimatedCostUnfinishedRkXD$yp<[bLP*0?WEstimatedCostENmO@[bLP*0?WContingencyPercentC䜄OJ[F0[bLP*0?WEstimatedTotalUnfinished4VTGʻ?|[bLP*0?WEstimatedTotal 5A4 R?[bLP*0?WPINi`*zBwuR![bLP*0?Wunique_items   unique_items        0  m i`*zBwuR!"EstimatedTotal     2 *$#,##0.00;($#,##0.00)   0  4VTGʻ?|pLVALMR2GUID$ ĝ0$@ (Z2ccolumn RzNJw^. grbit ?߃C*ӓ2icolumn }(ZKŨ{4szColumn 佅}!OE|f4szObject MAO#KũH*$szReferencedColumn OQ:\FbNaZEH*$szReferencedObject belCfMftM$@"szRelationship {f)Ghk%nMR2.DefaultValueRequiredAllowZeroLengthGUIDValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesGroupNumber   ԥ)LVAL \MR2.DefaultValueRequiredAllowZeroLengthGUID FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenValidationRuleValidationTextOrientationDefaultViewDescription FormatInputMaskCaptionDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesLineNumber   G<VBr8T      m   ItemCode    "\aH[!*v      m   Description   P @H:X      m   4.SupplementalDescription   |گAۉ_       m   JDRequireSupplementalDescriptionFlag   2HzH(      m   Comment   _KڪtYa      m    Units   >x'O~sk      m    AlternateCode   wb8|KN R      m   IsAdHocPrice   4˕+nKFw_      m   Quantity   hiIBi~}      m   ,&UnitPriceUnfinished   bHssx      m   UsedInTotal   Y4:ε"A5      m   60ExtendedAmountUnfinished   %\%BRQ^      m   eSTIMATEiD   ]D {N      m   ! |Gt`a   U|Gt`aՑ @EstimateItemG<VBr8T|Gt`aLineNumber "\aH[!*v|Gt`aItemCodeP @H:X|Gt`aDescription|گAۉ_ |Gt`aSupplementalDescription2HzH( |Gt`aRequireSupplementalDescriptionFlag_KڪtYa|Gt`aComment>x'O~sk|Gt`aUnitswb8|KN R|Gt`aAlternateCode4˕+nKFw_|Gt`aIsAdHocPricehiIBi~}|Gt`aQuantitybHssx|Gt`aUnitPriceUnfinished3 y M7$O0v|Gt`aUnitPriceY4:ε"A5 |Gt`aUsedInTotal%\%BRQ^|Gt`aExtendedAmountUnfinishedzYdMR-O{t|Gt`aExtendedAmount]D {N|Gt`aeSTIMATEiD_1R DgӘ+1|Gt`agroupnumber   groupnumber      MLVAL]  m    _1R DgӘ+1UnitPrice     2 *$#,##0.00;($#,##0.00)   0  ^LO!U>"ExtendedAmount     2 *$#,##0.00;($#,##0.00)   0  V9I+dO> LVAL: n4MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDOLGUIDColumnWidthColumnHiddenDefaultView  <   d \ U[bLP*0?W-T- @U%DEstimate|Gt`a֑ @U%DEstimateItem( J#1C[bLP*0?WDescription5;@EWCr[bLP*0?WEstimateIdpJMo!bs[bLP*0?WLettingDate;{NC [bLP*0?WEstimatorl9:L9*-[bLP*0?WCountyDescriptionG<VBr8T|Gt`aLineNumber "\aH[!*v|Gt`aItemCodeP @H:X|Gt`aDescription_KڪtYa|Gt`aComment>x'O~sk|Gt`aUnitshiIBi~}|Gt`aQuantity^LO!U>|Gt`aUnitPriceV9I+dO>|Gt`aExtendedAmounti`*zBwuR![bLP*0?Wunique_items_1R DgӘ+1|Gt`agroupnumber4VTGʻ?|[bLP*0?WEstimatedTotal`z2YDn9,l[bLP*0?WComment臦D{q[bLP*0?WUnitSystem>1>OJD[bLP*0?WSpecYear]D {N|Gt`aeSTIMATEiD `6(kE wՃ  Y>8[EstimateItem].[Description]    MR2RecordLocksODBCTimeoutUseTransactionFailOnErrorOrientationNameMapDOLGUID"  <     U|Gt`a֑ @EstimateItem^LO!U>|Gt`aUnitPriceV9I+dO>|Gt`aExtendedAmount O0euOMR24RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDOLGUIDColumnWidthColumnHiddenReplicableDefaultView5  <     U|Gt`a֑ @EstimateItem_KڪtYa|Gt`aComment[bLP*0?W-T- @Estimate( J#1C[bLP*0?WDescription5;@EWCr[bLP*0?WEstimateIdpJMo!bs[bLP*0?WLettingDatel9:L9*-[bLP*0?WCountyDescriptionG<VBr8T|Gt`aLineNumber "\aH[!*v|Gt`aItemCodeP @H:X|Gt`aDescription>x'O~sk|Gt`aUnitshiIBi~}|Gt`aQuantity^LO!U>|Gt`aUnitPriceV9I+dO>|Gt`aExtendedAmount]D {N|Gt`aeSTIMATEiD  q!u-A{ (ˠ Y>8[EstimateItem].[Description]    LVALd MR28ODBCTimeoutMaxRecordsRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLUseTransactionFailOnErrorReplicable <       z Uw,dŚL;[^ @test2תN9 w,dŚL;testxmlstring     "yʾM> MR2TOrientationOrderByOnNameMapDefaultViewColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionGUID   z UHFI펋e] @test:(gMi̡HFItestxmlstring  w,dŚL; testxmlstring ")      m       2תN9 MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    bAx'O~sk|Gt`aUnitshiIBi~}|Gt`aQuantity^LO!U>|Gt`aUnitPriceV9I+dO>|Gt`aExtendedAmounti`*zBwuR![bLP*0?Wunique_items_1R DgӘ+1|Gt`agroupnumber4VTGʻ?|[bLP*0?WEstimatedTotal`z2YDn9,l[bLP*0?WComment]D {N|Gt`aeSTIMATEiD   )g>Dvc/1Y>8[EstimateItem].[Description]    t LVAL άO&Otest